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.
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
Article ID: 18
Category: Import from QIF, OFX and CSV files
Date added: 2010-08-23 20:14:00
Views : 10394
Rating (Votes): (80)