|
#2
| |||
| |||
| In microsoft.public.money, roxylee wrote: - quote - > Thank you for the input. I was doing my banking by simply listing
I understood that is what you wanted. I did not explicitly say that> transactions in an excel spreadsheet. I changed the column headings to match > the register headings and imported them as such. they matched up well to the > proper columns, but my debits were Money's credits and vice versa. now I > don't know how to change the listings except individually. I'm hoping there > is a way to select many transactions at one time and simply change the debit > to credit and vice versa, based on the transactions I select (by holding down > the shift or ctrl key as a select, but that hasn't worked). I'm hoping I > don't have to do this one by one. oh well. Money does not have a built-in way to change the sense on a bunch of transactions, but it doesn't. You could export what Money has, modify the QIF file with a macro editor, delete the account, and import the modified QIF. But there is no macro capability in Money to reverse the sign on a bunch of transactions. My point of asking if you had made QIF files, is that that is the only way I know of that you could have imported that data from Excel. So modifying the spreadsheet to change the sign of the data, then re-importing to a pre-import version of the Money file seemed like the likely easiest way. |
|
#1
| |||
| |||
| Thank you for the input. I was doing my banking by simply listing transactions in an excel spreadsheet. I changed the column headings to match the register headings and imported them as such. they matched up well to the proper columns, but my debits were Money's credits and vice versa. now I don't know how to change the listings except individually. I'm hoping there is a way to select many transactions at one time and simply change the debit to credit and vice versa, based on the transactions I select (by holding down the shift or ctrl key as a select, but that hasn't worked). I'm hoping I don't have to do this one by one. oh well.... "Cal Learner-- MVP" wrote: - quote - > In microsoft.public.money, roxylee wrote: > > I recently began using money 2006. i was successful in downloading > > (importing) transactions from an excel spreadsheet, but the transactions all > > came in as credits, not debits. > That doesn't sound like success. Did you create QIF files? > > How do I select mulitple transactions to > > a: change them to debits instead of credits (prefer this if possible). > > b: delete so I can re import them as debits or > > c: let me know that I'm dead in the water. start everything over. (I hope not) > File-> Restore will let you go back to points where backups were > made. Since Money 2006 keeps backups, you may have suitable backups. > I suggest you increase the number of backups that are maintained so > you can go back farther as you experiment. |
| | |||
| |||
| In microsoft.public.money, roxylee wrote: - quote - > I recently began using money 2006. i was successful in downloading
That doesn't sound like success. Did you create QIF files?> (importing) transactions from an excel spreadsheet, but the transactions all > came in as credits, not debits. - quote - > How do I select mulitple transactions to
File-> Restore will let you go back to points where backups were> a: change them to debits instead of credits (prefer this if possible). > b: delete so I can re import them as debits or > c: let me know that I'm dead in the water. start everything over. (I hope not) made. Since Money 2006 keeps backups, you may have suitable backups. I suggest you increase the number of backups that are maintained so you can go back farther as you experiment. |
|
#-1
| |||
| |||
| I recently began using money 2006. i was successful in downloading (importing) transactions from an excel spreadsheet, but the transactions all came in as credits, not debits. How do I select mulitple transactions to a: change them to debits instead of credits (prefer this if possible). b: delete so I can re import them as debits or c: let me know that I'm dead in the water. start everything over. (I hope not) thanks in advance for any help on this |
| Tags |
| bad, fixing, imports |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| QFX File Imports Michael Biel: I'm currently using Money 2004 Standard. Can I import QFX files with this version? I'm wondering, because when I try to import a QFX file nothing... | Microsoft Money | 6 | 05-31-2005 05:04 AM | |
| Money 2005 - ETA on fixing duplicates, yodlee, MSN, etc.? Matthew Coble: Microsofties: So I spent several weeks and several email exchanges with Microsoft Support trying to sort out the numerous issues I've been having... | Microsoft Money | 13 | 12-06-2004 12:41 PM | |
| fixing corrupt money and backup files? Scott: A recent crash corrupted both my primary and my backup money 2004 Deluxe Business files. Money's salvage program doesn't work because it doesn't... | Microsoft Money | 1 | 08-17-2004 04:16 PM | |
| Thread Tools | |
| Display Modes | |
| |