Quick Help

Knowledgebase is a categorized collection of answers to frequently asked questions (FAQ) and articles. You can read articles in this category or select a subcategory that you are interested in.



 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

 
Powered by Help Desk Software HESK, in partnership with SysAid Technologies