Importing from Banks
Posted:
Sun Nov 16, 2008 3:44 pm
by nthev
My bank allows downloading csv statements, but the format includes separate columns for credit and debit amounts. Is this possible to import, because when I try, it tells me the import is complete, but no transactions have been imported!
Thanks
Re: Importing from Banks
Posted:
Sun Nov 16, 2008 3:52 pm
by mthadm
My Money supports very specific CSV format that was originated by Microsoft Money.
This is how a typical Money CSV fragment looks like:
- Code: Select all
Num,Date,Payee,C,Account,Memo,Category,Amount
,9/19/06,INTEREST PAYMENT,E,Citibank Online Interest Checking,INTEREST,Income/Interest,0.4
If your CSV is different then you will need to use some kind of a macro in Excel to bring it to what we support
Thanks