Troubleshoot bank matching
Goal
Fix bank statement import and reconciliation match failures.
Who it is for
Treasury clerks and managers with bank.view (manage keys for import/match actions).
Preconditions
- Module treasury; bank account exists.
- Open Accounting → Bank reconciliation.
Common problems
| Symptom | Likely cause | What to do |
|---|---|---|
bank_statement_duplicate | Same statement already imported | Open existing session; do not re-import identical file |
bank_line_not_open | Line already matched/closed | Unmatch only if your process allows; else pick another line |
bank_line_amount_mismatch | Voucher amount ≠ statement line | Split/categorize correctly or pick the right voucher |
reconciliation_out_of_balance | Session totals do not agree | Clear unmatched differences before complete |
| Cheque mismatch | Cheque ↔ bank line rules failed | Fix cheque status/amount; see cheque help |
| Unsupported file | Bad CSV/OFX/QFX/QIF | Fix format or map columns as the importer requires |
| Period issues | Related posts hit closed period | Adjust dates or period before posting fixes |
Steps
- Select the correct bank account.
- Import or refresh statement lines.
- Match open lines to receipts, payments, transfers, or cheques.
- Resolve amount differences; complete only when balanced.