MechCAD Software Helpdesk
MechCAD Software Home About us Products Downloads Support Contact us FAQ Wiki Yahoo Group Online Store
Knowledgebase
MechCAD Software > MechCAD Software Tech Support > Knowledgebase
PromoRate Loan
Search help:


My bank only supports CSV format (comma separated values). Can AceMoney handle this file type?

Solution

Yes, it can. CSV is a simple plain text format where each line contains several fields separated with commas. AceMoney can import CSV files that were created by AceMoney, Microsoft Excel, OpenCalc or any other spreadsheet software.

Many banks provide CSV files for download from their web sites, however it might be challenging to import them as is, since each bank orders data in the CSV files differently. Such files should be updated in any spreadsheet application to match AceMoney expectations. Usually all you need to do is add empty or reorder the existing columns.

AceMoney expects the following columns in the CSV file:

* A (1) - Transaction/check number
* B (2) - Date
* C (3) - Payee
* D (4) - Category
* E (5) - Status
* F (6) - Withdrawal
* G (7) - Deposit
* H (8) - Total
* I (9) - Comment

These fields are the same as in AceMoney account register and they are ordered the same way as on the screen.

There is another way to import CSV files to AceMoney. There is a freeware utility converting data from CSV or any other spreadsheet format to QIF format which is well supported by AceMoney. You can download the tool free of charge at this address: http://xl2qif.chez-alice.fr/xl2qif_en.php

 
Was this article helpful? yes / no
Related articles How to import transactions from Excel or OpenOffice?
When I import QIF file downloaded from my bank's web site, all transaction dates are set to current. What is wrong?
My bank tells me that it does not support AceMoney, how come it is in your Online Setup list?
Can AceMoney open QIF or OFX files directly from the web site without downloading and importing manually?
How can I setup automatic synchronization between AceMoney and AceMoney for Pocket PC?
Article details
Article ID: 18
Category: Import from QIF, OFX and CSV files
Date added: 2010-08-24 01:14:00
Views: 6278
Rating (Votes): Article rated 3.0/5.0 (45)

 
« Go back

 
Powered by Help Desk Software HESK, brought to you by SysAid