How do I export the journal and match it to my chart of accounts?

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.

  1. Open Settings and the tile Accounting export (daily journal CSV).
  2. Choose the Export folder.
  3. Choose the File format: Plain CSV (any software), QuickBooks Online, QuickBooks Desktop, Xero or Zoho Books.
  4. Choose the first and the last day. At most one year at a time.
  5. 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.
  6. 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?

Print this article · Contact support