Basic Bank Reconciliation
Let’s say Sarah, owner of 'Sarah's Sweets', gets her bank statement for October, showing an ending balance of
2,500. Her internal accounting software (general ledger) shows an ending cash balance of
3,200. She investigates and finds: A customer check for $800 was deposited on October 29th, recorded in her books, but only cleared the bank on November 1st (Deposit in Transit). A payment for baking supplies, check #455 for $300, was mailed on October 28th and recorded, but hasn't been cashed yet (Outstanding Check). The bank statement shows a $50 monthly service charge that Sarah hadn't recorded. Here’s how she reconciles: Bank Side:
Bank Statement Balance:
2,500
Add: Deposit in Transit: $800
Subtract: Outstanding Check: $300
Adjusted Bank Balance:
3,000 Book Side:
General Ledger Cash Balance:
3,200
Subtract: Bank Service Charge: $50
Adjusted Book Balance:
3,150 Wait, they don't match! Upon re-checking, Sarah realizes she missed recording a
50 interest payment from the bank on her books. Adjusted Book Balance (Revised):
General Ledger Cash Balance:
3,200
Add: Interest Earned:
50
Subtract: Bank Service Charge: $50
Revised Adjusted Book Balance:
3,300 Still not matching? Sarah meticulously re-examines her bank statement and finds the correct Service Charge was $50. She reviews her books and realizes she had mistakenly added a $300 expense instead of subtracting it. A quick correction to her internal records for the incorrect transaction from
3,200 to
3,300 (before adjustments) makes the numbers align. This highlights the painstaking process required to find these errors. In this illustrative example, even with the formula, careful transactional matching is key. The example should ideally end with a match: Let's assume the correct General Ledger Cash Balance was
3,300 and the initial missing adjustment was the $50 service charge and
50 earned interest. Bank Side:
Bank Statement Balance:
2,500
Add: Deposit in Transit: $800
Subtract: Outstanding Check: $300
Adjusted Bank Balance:
3,000 Book Side:
General Ledger Cash Balance:
2,850 (Original G/L
3,200 - $350 Error which was actually a payment. This illustrates how errors create mismatches)
Let's assume the correct G/L balance before adjustments was
2,850.
Add: Interest Earned:
50
Subtract: Bank Service Charge: $50
Adjusted Book Balance:
2,950 This discrepancy (
3,000 vs
2,950) means Sarah needs to find the final $50 error. It shows the real-world complexity where direct alignment takes effort. After more investigation, Sarah finds she forgot to record a $50 cash withdrawal she made for petty cash. Once recorded, her books become
2,900. After adding
50 interest and subtracting $50 service charge, the book balance becomes
3,000, finally matching the bank's reconciled balance.