Open Settings, Accounting export (daily journal CSV). Choose the folder, the file format and the dates, and write next to each kind of entry the name of your own account. The till then writes one journal per day that your accounting software can import.
- Open Settings and the tile Accounting export (daily journal CSV).
- Choose the Export folder.
- Choose the File format: Plain CSV (any software), QuickBooks Online, QuickBooks Desktop, Xero or Zoho Books.
- Choose the first and the last day. At most one year at a time.
- Fill in Accounts: kind = account name | code (the code is used by Xero): one line per kind, for example tender.cash = Cash on hand | 1000.
- Press Export. The till says where the files were written.
The kinds
| Kind | Meaning |
|---|---|
| tender.cash, tender.card, tender.account, tender.gift_card, tender.voucher, tender.wallet, tender.cheque, tender.store_credit, tender.points, tender.other | money in, by payment method |
| revenue, discounts, rounding, tips | sales |
| tax, tax_input | tax collected, tax on purchases |
| returns, returns_cash | returns and their refunds |
| cogs, inventory, purchases, landed_costs, opening_stock | stock and its cost |
| payables | owed to suppliers |
| safe, bank, card_payable, owner, cash_in_out, cash_over_short | where money sits or moved |
| stock_loss.damaged, .expired, .theft, .own_use, .count, .adjustment | stock losses by reason |
| expense.other and your expense categories | expenses |
Advice
- The account names must be written exactly as they are in your accounting software, or the import will refuse them or create new accounts.
- The list is saved, so you fill it in once.
- Import one day first and check it with your accountant before importing a whole period.
- Import each period once. Importing the same days twice doubles the figures.
For: Accountant Owner since version 1.0.8
Did this help?
Thank you. Your answer helps us improve the help.