Bank reconciliation
Import the bank statement, auto-match against posted ledger entries, chase the differences — and record inter-account transfers in one click.
Reconciliation is the chore that exposes every bookkeeping gap: entries in the ledger that never hit the bank, bank lines nobody recorded, and a difference figure that takes a weekend to explain.
Zaffre Axon puts the ledger and the bank statement side by side. Equal amounts within a week auto-suggest their matches; what remains is exactly the list of things to investigate — visible, small and finite.
The reconciliation workspace shows four numbers that matter: the ledger balance of the selected bank account, the imported statement balance, the difference, and how many statement lines remain unmatched. When the difference is zero and unmatched is zero, the account shows Reconciled — a state you can reach weekly instead of quarterly.
Import accepts the CSV your bank already exports — date, description, reference, amount — and maps columns by name. Deposits and withdrawals are signed automatically, and duplicates are skipped so a re-import is always safe.
Matching is deliberately conservative: suggestions pair one statement line with one posted entry of the same amount within a week, and manual matches are validated against the entry’s actual movement on that account. Wrong-amount matches are rejected outright, which is exactly what keeps a reconciliation trustworthy.
Built-in safeguards against fake attendance
Duplicate-safe imports
Statement rows are de-duplicated on import (same account, date, amount and reference are skipped), so re-uploading a corrected file never double-counts.
Verified matching
A match is only accepted when the journal entry’s movement on that bank account equals the statement amount on the correct side — and each entry can match only one line.
One-click suggestions
Unmatched lines with an equal-amount ledger entry within ±7 days show a Match button; everything else offers a ranked manual-match list.
Exclusions with undo
Bank noise — duplicate bank lines, items handled elsewhere — can be excluded from the reconciliation and brought back at any time.
Inter-account transfers
Moving money between bank and cash accounts posts the balanced transfer entry immediately, so the next reconciliation already knows about it.
How it works
- 1
Pick the account
Choose any bank or cash ledger account; the workspace loads its posted entries and prior statement lines.
- 2
Import the statement
Upload the bank’s CSV. Columns map by name; duplicates are skipped automatically.
- 3
Accept suggestions
Equal-amount entries within ±7 days are suggested one-to-one — accept each with a click.
- 4
Resolve the rest
Use the ranked manual-match drawer for the remainder, exclude bank noise, and record missing transfers on the spot.
- 5
Reach zero
When difference and unmatched both hit zero, the account is reconciled — and stays that way with weekly imports.
Frequently asked questions
- What file format does the bank statement import accept?
- CSV with date and amount columns (description and reference optional). Column names are matched flexibly — "Transaction Date", "Value Date", "Amount", "Ref" and similar variants all work.
- Can the same journal entry be matched to two statement lines?
- No. Matching is strictly one-to-one, and a match is only accepted when amounts agree on the correct side — this is what keeps the reconciliation meaningful.
- What happens if I import the same statement twice?
- Duplicate rows (same account, date, amount and reference) are skipped and reported, so re-imports are safe.
- How do I record a transfer between two bank accounts?
- The Transfer action posts a balanced journal entry — debit destination, credit source — dated as you choose, provided the accounting period is open.
- Can I reconcile a cash account too?
- Yes. Any postable bank or cash account in the chart of accounts can be selected, so petty cash counts can be reconciled the same way.