Export from Settings, Accounting export (daily journal CSV), with the Xero file format, after giving each kind of entry its Xero account code. Then import the CSV in Xero as manual journals. Try one day first.
Prepare
- In Settings, Accounting export (daily journal CSV), fill in the account list. Xero matches accounts by code, so write the code after the | sign: tender.cash = Cash on hand | 1000: see How do I export the journal and match it to my chart of accounts?.
- Choose the Xero file format.
- Choose one day and press Export.
In Xero
- Open the manual journals (in the accounting menu) and choose to import.
- Choose the CSV file written by the till.
- Xero shows the journals as drafts. Open one and check the lines and the total.
- Post the journals.
Check, then go on
- Compare the day in Xero with the day's Z reports: sales, tax, cash, card.
- An account code that Xero does not know stops the import: add the account in Xero, or correct the code in the till, and export again.
- Tax: the journal carries the tax collected as its own line. Whether the lines should also carry a Xero tax rate depends on how your accountant files returns from Xero; ask before posting a whole period.
- When one day is right, export and import the rest, each day once.
Menu names in Xero change over time; use Xero's own help for the import screen. The link is a file, not a live connection, and has not been certified by Xero.