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