Page 1 of 1

Importing from Banks

PostPosted: 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

PostPosted: 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