Importing from Banks

General Discussions and Announcements

Importing from Banks

Postby nthev » Sun Nov 16, 2008 3:44 pm

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
nthev
 
Posts: 1
Joined: Sun Nov 16, 2008 3:34 pm

Re: Importing from Banks

Postby mthadm » Sun Nov 16, 2008 3:52 pm

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
---
MTH Software

Reminder: MTH Software employees will never ask for the username and password for any of your banking or credit card accounts.
Please do not provide this information when using our contact form.

My Money download page: http://www.mthbuilt.com/download.html
My Money manual: http://wiki.mthbuilt.com/My_Money_2.0_Manual
User avatar
mthadm
Site Admin
 
Posts: 1056
Joined: Mon May 05, 2008 12:58 am


Return to General Discussions and Announcements

Who is online

Users browsing this forum: No registered users and 1 guest

cron