Branch books

Bank reconciliationNew

Import a bank CSV, then match each statement line to a customer, invoice, supplier, or ledger.

All guides

Bank reconciliation links what hit the bank to what you posted in XZONO (receipts, payments, and similar).

Before you start

  1. Create bank / cash accounts under Chart of Accounts → Banks.

How to reconcile

  1. Accounting → click your branch. The Bank reconciliation card shows Last imported for each bank. That is the newest statement date already brought in, so you can see how far behind the import is. Not imported yet means no statement has been brought in. Click the bank to open it.
  2. In Filter, choose the bank. Import uses that bank. Click Import. The popup asks for the CSV. Download template if you want the Date, Description, Amount layout (the same shape as a Standard Bank export). Or upload your bank CSV as it is.
  3. Click Upload & preview. The window closes. The lines appear on the Statement entries tab. Tick the ones you want and click Import selected lines.
  4. Under Statement entries, filter to Unmatched, Matched, or All. Search statement entries filters the lines already on the page by description, reference, date, or amount. Clear the box to show the list again.
  5. Open a line, choose Match type, pick the account, and Save match. If other lines in this date range suggest the same expense, you can save them together. Up to 25 of those lines are saved at a time. Save again for any that remain.
  6. Match type can be a customer, supplier, sales invoice, purchase invoice, payslip, Pay PAYE, expense account, expense voucher, cash account, or another ledger.
  7. When you match a receipt to a customer, XZONO settles that customer’s open invoices oldest first. Example: invoices of R1 680 and R220, and an EFT of R1 940. Both invoices are paid. The other R40 stays as credit on the customer. Put that R40 in as the tip on this match. Add tip on Tip payouts is only for the special case where you already saved the match and forgot the tip. That backdates the tip to the EFT and does not change the invoices.
  8. Enter the tip and split it across staff. The staff amounts must add up to the tip, the same way as the till. Save match. The receipt debits the bank for the full amount, credits the customer for the invoice portion, and credits Tips payable for the tip. Unmatch reverses the invoice settlements and the tip. If that tip was already paid out, reverse the payout first.
  9. Tick Remember for similar descriptions when the same wording should pre-fill next time. Those saved patterns are under Rules.
  10. Add statement is a separate tab. Use it when you type a line instead of importing a file. It is hidden until you open that tab.
  11. Use Ignore for a line you do not want to match. Import history is the last tab. Open it to undo a batch you imported by mistake. It stays off the main statement list.
  12. On the customer ledger, click the receipt number (for example RC-000634). The receipt shows whether that bank line was matched. Click the match to open Bank reconciliation on that statement line, filtered to Matched.