Finance controls

Bank reconciliation: from statement import to reviewed matches

Match your bank statement to the general ledger, resolve the differences, and keep evidence of the review. A high automatic match rate is not a substitute for reconciliation.

WORKFLOW / 06
  1. Import statement
  2. Match strong references
  3. Review differences
  4. Approve and retain evidence
Four steps to apply this guide.

Begin with the right statement and ledger

Choose the bank account, currency and date range. Compare the opening statement balance to the prior reconciled closing balance, and check that the imported statement includes every page or record. If a file overlaps the previous import, confirm that repeat rows are not loaded twice. Keep the original statement with the reconciliation record.

Match the strongest evidence first

Start with exact references and amounts, then consider date differences or grouped settlements. A card processor might pay a net amount for several sales after fees. Tie the settlement to the underlying transactions and fee entry rather than forcing a same-amount match. If two receipts have equal amounts, inspect the reference or remitter before accepting a suggestion.

Classify remaining differences

Separate genuine timing differences from missing entries and mistakes. A deposit in transit may clear next month; a bank fee may need a reviewed journal entry. An unknown transfer needs investigation, not a plug. Record the owner, evidence and expected resolution date for each outstanding item.

Close with a second look

Confirm the bank and ledger balances are explained by the reconciled items and documented differences. Review unusually old outstanding items. Keep the statement, match report and approved adjustments together so another reviewer can reproduce the result. If an import or match is reversed, record what changed and recheck the closing position.

Can a bank statement create missing entries automatically?

A system can propose entries based on rules, but unidentified or unusual items should be reviewed before posting. Keep a link to the statement line and approval.