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.



 How to import transactions from Excel or OpenOffice?

Solution

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.

 
Was this article helpful? yes / no

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