XAF means XML Auditfile Financieel. Many Dutch bookkeeping packages can export this file. Use it to bring historical customers, income and expenses into AdMemo. The import uses the same Dutch bookkeeping rules in both app languages.
For a single list, use the separate Excel/CSV imports for customers, income, expenses or items. XAF is useful when you have an audit file from a previous bookkeeping package.
Open the import
- Open Settings.
- Choose Switching service.
- Choose an
.xafor.xmlfile exported from your previous package. - Select Skip or Import anyway for possible duplicates.
AdMemo supports XAF 2.0, 3.2 and 4.0, with a maximum file size of 25 MB.
Review the field mapping
AdMemo suggests mappings for Customers, Income and Expenses. Review the example value and the selected AdMemo field for each source field. Choose Do not import when a field does not belong in AdMemo.
| Module | Imported information |
|---|---|
| Customers | Name, email, telephone and address. |
| Income | Date, customer, description, amounts, VAT and line information. |
| Expenses | Date, supplier, category, description, amounts, VAT and line information. |
Only information that fits existing AdMemo fields is saved. Customer names, source descriptions, euro amounts and Dutch category values retain their original data.
What is not imported?
The audit file's ledger helps AdMemo recognise and classify entries. AdMemo does not save it as a separate general ledger. Bank/cash entries, balance-sheet entries, receivables/payables and VAT rows used only for audit checks are not saved as separate AdMemo records.
Open What is not imported? in the wizard to see which rows were deliberately skipped.
Check and save
Choose Check to validate required fields, amounts, VAT and possible duplicates. Correct any mapping errors and check again. When the proposed import is correct, choose Import.
With Skip selected, a repeated import skips entries already recognised as duplicates. Review possible duplicates before choosing Import anyway, since that choice permits additional records.
Before importing
- Export the period you want to bring into AdMemo.
- Check customer names, dates and amounts.
- Leave fields without a suitable AdMemo destination on Do not import.
- Review your imported records before using them in reports.
You can then export your administration for your accountant.