Before you start
Country-neutral practice, with US references where noted. This tutorial reconciles one bank account for one period. It assumes you have the bank's statement for the period and the next month's statement, the ledger detail for the account, and the prior month's reconciliation. The explanation of what a reconciliation proves is on the bank and credit card reconciliations page. This page is the procedure.
Use the bank's own statement. Evidence from outside the entity, in documentary form, is more reliable than internal records (AU-C 505.02), and the statement is that document.
The steps
1. Set up the header
Write the entity, account name, last four digits of the account number, the period end date, your initials and the date, and the source of each balance. Last digits only: keep full account numbers out of working files you share.
2. Record the two starting balances
- Statement ending balance, from the statement.
- Ledger balance at the same date, from the ledger or trial balance.
Reference each to its source document.
3. Carry forward last period's open items
List outstanding checks and deposits in transit from the prior reconciliation. Mark each as cleared this period (and the date it cleared) or still outstanding. An item still outstanding after more than one period is a flag.
4. Match the statement to the ledger
Go through the statement line by line and the ledger line by line. Mark each matched pair with a tick and a reference. Matching on amount alone is not enough. Match on amount, date and description, because two items of the same amount can mask an error.
5. List the unmatched items
Unmatched ledger items are outstanding checks and payments, and deposits in transit. Unmatched statement items are fees, interest, bank-initiated payments and receipts, and returned items not yet in the ledger.
6. Work out the adjusted bank balance
Statement balance, plus deposits in transit, minus outstanding checks.
7. Work out the adjusted book balance
Ledger balance, plus unrecorded receipts such as interest, minus unrecorded charges such as fees, corrected for ledger errors.
8. Compare
The two adjusted balances should be equal. If they are, go to step 10. If not, go to step 9.
9. Find the difference
Re-foot the reconciliation. Compare the difference to single items. Look for transposed digits (the difference is divisible by nine), items entered twice, items on the wrong side, and items on the wrong date. Check last period's open items. If the difference persists, record it as an unreconciled amount, list what you checked, and tell the manager. Do not hide it in an expense account.
10. Propose the adjusting entries
For every statement-side item not yet in the ledger (fees, interest, bank-initiated items) and any ledger error, write the journal entry with the amount, the account and the support. Propose, and post only if you are authorised to.
11. Check subsequent clearing
Look at the next month's statement. Do outstanding items clear? Do deposits in transit appear in the first days? Record the clearing date for each. An item that does not clear gets a note.
12. Write the conclusion and sign
"Account reconciles at [date] after adjusting entries of [amount]. Outstanding items agree to subsequent clearing except [items]." Sign and date. For audit files, record who performed the work and when and leave space for the reviewer's name and date (AU-C 230.09).
Worked example
Illustrative example, invented figures, account for March.
| Line | Amount |
|---|---|
| Statement balance, 31 March | 48,250 |
| Add: deposit in transit (recorded 31 March, bank credit 2 April) | 2,000 |
| Less: outstanding check 1021 | (3,100) |
| Less: outstanding check 1024 | (1,450) |
| Adjusted bank balance | 45,700 |
| Ledger balance, 31 March | 45,735 |
| Less: bank fee on statement, not yet recorded | (35) |
| Adjusted book balance | 45,700 |
Check: 48,250 + 2,000 = 50,250; 50,250 − 3,100 = 47,150; 47,150 − 1,450 = 45,700. And 45,735 − 35 = 45,700. The balances agree, so the reconciliation is complete.
Entry proposed: debit bank charges 35, credit bank 35, supported by the statement line.
Subsequent clearing from the April statement: deposit cleared 2 April; check 1021 cleared 6 April; check 1024 cleared 9 April. All three are recorded with the dates. No exceptions.
Common errors
- Starting from the client's list of cleared items instead of the bank statement.
- Netting two reconciling items against each other.
- Forgetting last period's open items.
- Ignoring items that cleared the bank in a different month from the ledger date.
- Treating a bank-side error as a ledger problem. Ask the bank to correct it and list it.
- Skipping the subsequent-clearing check.
For credit card accounts
The method is the same with the sign reversed: statement balance owed, plus charges recorded in the ledger and not yet on the statement, less payments in transit, compared to the ledger liability after recording fees, interest and disputed items. Reconcile to the issuer's statement.
What a reviewer checks
The statement balance against the document, the ledger balance against the trial balance, the arithmetic, the support for each reconciling item, subsequent clearing, and anything old, large, round or unexplained. The IRS says records should support what is reported and be kept as long as needed to prove income or deductions (IRS, Recordkeeping). Keep the statement, the reconciliation and the entries together.
FAQ
What if an outstanding check is very old?
Do not clear it yourself. Flag it with payee, number, date and amount and ask the manager.
Do I reconcile every month?
For any period that will be reported, yes. Many firms ask for every month.
What if the statement shows an item I cannot identify?
Ask the manager or the client contact the firm designates. List it as unidentified until answered.
Can I reconcile from the bank portal?
Use the statement the bank issues for the period, or something the firm accepts as equivalent. Portal balances change as items post.
Sources
- AICPA, AU-C Section 505, External Confirmations (AU-C sections, currently effective): https://www.aicpa-cima.com/resources/download/aicpa-statements-on-auditing-standards-currently-effective
- AICPA, AU-C Section 230, Audit Documentation (same download): https://www.aicpa-cima.com/resources/download/aicpa-statements-on-auditing-standards-currently-effective
- IRS, Recordkeeping: https://www.irs.gov/businesses/small-businesses-self-employed/recordkeeping