| name | reconcile-a-bank-statement |
| category | money |
| description | Reconcile bank activity to accounting records while identifying timing differences, missing entries, duplicates, fees, and unauthorized transactions. Use when closing a period or investigating a cash discrepancy. |
reconcile-a-bank-statement
Preserve the original statement and prove the path from bank balance to book balance.
When to use
- Use for periodic cash reconciliation, close support, audit evidence, or a suspected payment discrepancy.
- Only post adjustments with the required accounting authority; reconciliation is not payment approval.
Procedure
- Save the original bank statement and record the account, currency, opening date, closing date, and statement balance.
- Confirm the prior reconciliation's adjusted balance and investigate any changed opening amount.
- Match deposits, withdrawals, transfers, card settlements, checks, and bank references to book entries.
- List deposits in transit and outstanding payments with dates, amounts, counterparties, and evidence of later clearance.
- Identify bank fees, interest, direct debits, returned items, foreign-exchange effects, duplicates, and missing entries.
- Escalate unfamiliar or potentially unauthorized activity through the approved fraud process without contacting a suspected party independently.
- Prepare proposed book adjustments with source evidence, account coding, date, and approver.
- Calculate the adjusted bank and book balances and require an exact reconciliation.
- Age unresolved items and prevent stale differences from rolling forward without an owner and deadline.
Worked example
The statement closes at $84,210 while the ledger shows $80,910. Matching finds a $4,000 deposit in transit, a $900 outstanding payment, a $200 bank fee not recorded, and no other difference. After the approved fee entry, adjusted bank and book balances both equal $83,310. The reconciliation report links every item and records when the timing items clear.
Done
- A bank reconciliation report preserves the statement, matched transactions, timing items, proposed entries, and exact adjusted balance
- Every old, duplicate, unfamiliar, or unauthorized item is recorded in an exception list with evidence, owner, and resolution status