Skip to content

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 ​

SymptomLikely causeWhat to do
bank_statement_duplicateSame statement already importedOpen existing session; do not re-import identical file
bank_line_not_openLine already matched/closedUnmatch only if your process allows; else pick another line
bank_line_amount_mismatchVoucher amount ≠ statement lineSplit/categorize correctly or pick the right voucher
reconciliation_out_of_balanceSession totals do not agreeClear unmatched differences before complete
Cheque mismatchCheque ↔ bank line rules failedFix cheque status/amount; see cheque help
Unsupported fileBad CSV/OFX/QFX/QIFFix format or map columns as the importer requires
Period issuesRelated posts hit closed periodAdjust dates or period before posting fixes

Steps ​

  1. Select the correct bank account.
  2. Import or refresh statement lines.
  3. Match open lines to receipts, payments, transfers, or cheques.
  4. Resolve amount differences; complete only when balanced.

BlueMatrix Help — product documentation for tenants