Pick your system
In Migrate data pick Zoho Books, Xero, QuickBooks or Odoo. These work through files, so they read Excel / CSV files. System not listed? Choose Excel / CSV.
Export the files from your system
Export what you need from your old system as Excel or CSV:
- The chart of accounts
- Customers and suppliers
- Items
- The trial balance for the day before your start date
- Only the customer invoices and supplier bills still unpaid
In a trial balance the reader looks for the closing balance columns and the report date, and leaves out heading and total rows. The screen tells you what it understood from the file, so read it.
Upload each file in its place
Press Choose file on each row, then Next. The usual column headings match automatically, and you correct the rest from the list.
Watch for doubled receivables
If the trial balance holds a receivable or payable control account and you are also bringing open invoices, you see Receivables may be counted twice. Tick Drop the control lines from the trial balance and take the balances from the invoices (recommended), then review and apply.
Was this tutorial helpful?
No, I need help