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.
