How to import transactions from Excel or OpenOffice?

AceMoney can import transaction from .CSV files that can be produced by all modern spreadsheet applications like Microsoft Excel or OpenOffice Calc. However the order of fields in the file should match AceMoney expectations. 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

There is another option. There is a freeware utility to convert data from spreadsheet to QIF format. You can download it free of charge at this address: http://xl2qif.chez-alice.fr/xl2qif_en.php. Then create the same accounts in AceMoney and import QIF files.