A comprehensive gradual release lesson teaching students how to reconcile bank statements and cash ledgers, covering timing differences, fees, deposits in transit, outstanding checks, and error corrections.
Summit Gear Co. Cash Audit • Verify that Adjusted Bank equals Adjusted Book before proceeding. Page 1 of 2
Forensic Audit Investigation
Scenario 2: Apex Cafe & Diagnostic Sleuth
Transposition & Bank Errors
Apex Cafe Audit File (As of September 30, 2026)
Apex Cafe's checkbook indicates a balance of $7,565.00, while the First City Bank statement shows an ending balance of $7,210.00. The audit team uncovered the following items:
A. Deposit in transit dated Sept 30: $1,150.00
B. Outstanding Check #740 ($630) & #744 ($480)
C. Monthly bank service fee: $40.00
D. Interest credit on account: $25.00
E. Book Error: Check #738 for kitchen equipment maintenance was written for $640.00 and correctly paid by the bank for $640.00. However, the cafe bookkeeper entered it in the journal as $460.00.
F. Bank Error: The bank incorrectly charged Apex Cafe's account for a $120.00 check drawn by another customer, "Apex Hardware".
Bank deducted $120.00 belonging to another company.
Does the company's bookkeeper know this?
Action: The bank must [Add / Deduct] this $120 back.
Adjustment side: Adjust the [Bank / Book] side.
Part B: Apex Cafe Reconciliation Schedule
BANK BALANCE RECONCILIATION
Record starting balance ($7,210.00), adjustments, bank error:
Adjusted Bank:
BOOK BALANCE RECONCILIATION
Record starting balance ($7,565.00), adjustments, book error:
Adjusted Books:
PRO-TIP The "Rule of 9s" Transposition Trick:
Whenever two digits are transposed (e.g., $640 written as $460), the error difference ($180) is always evenly divisible by 9 (\(180 \div 9 = 20\)). If an out-of-balance difference divides by 9, what kind of mistake should you look for first?
Apex Cafe Case Study • Reconciling complex discrepancies with professional precision. Page 2 of 2
SCENARIO 1
Summit Gear Co. Full Solution
BANK STATEMENT (ENDING: $6,740.00)
+ Deposit in Transit (Aug 31): +$780.00
- Outstanding Checks:
Check #603: $420.00
Check #605: $315.00
Check #606: $140.00
Total Outstanding Checks: -$875.00
ADJUSTED BANK BALANCE: $6,645.00
COMPANY BOOKS (ENDING: $6,815.00)
+ Interest Earned: +$15.00
- Book Deductions:
Customer NSF Check: -$160.00
Bank Service Fee: -$25.00
Total Book Deductions: -$185.00
ADJUSTED BOOK BALANCE: $6,645.00
SCENARIO 2
Apex Cafe Forensic Audit Solution
Part A (Check #738 Error): Diff: $180.00 ($640 - $460). Cash was overstated on books. Action: Deduct from Book balance.
Part A (Apex Hardware Bank Error): Bank wrongly subtracted $120. Company has no record of it. Action: Bank must Add back to Bank side.
BANK STATEMENT ($7,210.00)
+ Deposit in Transit: +$1,150.00
+ Bank Error (Correction): +$120.00
- O/S Checks (#740 + #744): -$1,110.00
ADJUSTED BANK: $7,370.00
COMPANY BOOKS ($7,565.00)
+ Interest Earned: +$25.00
- Monthly Service Fee: -$40.00
- Check #738 Error ($640-$460): -$180.00
ADJUSTED BOOKS: $7,370.00
Common Student Traps & How to Intervene
Trap 1: Adjusting the wrong side for bank errors. Remind students: You only record entries on the business books for things the business needs to correct. A bank error belongs strictly to the bank side of the reconciliation.
Trap 2: Adding an understated check instead of subtracting. Walk through cash flow: "Checks are cash outflows. If you recorded paying $200 when you really paid $380, you have less cash in reality. Less cash means subtract!"
Statement Sleuth Facilitation Guide • Section 2: Comprehensive Case Keys & Diagnostics Page 2 of 2
4. Direct Customer Wire: +$580 → Add to Books
5. NSF Check & Fee: -$145 total → Deduct from Books
Target Reconciled Balance
$4,830.00
Both sides reach $4,830.00!
Turn to your guided notes Page 2 and confirm your partner calculations match!
YOU DO Independent Mastery
The Auditor's 3-Step Routine
Audit Ready
1
Cross-Check Records
Match check numbers and deposits between both documents. Mark cleared items with a checkmark.
2
Ask: "Who Doesn't Know?"
If the bank hasn't seen it, adjust the Bank side. If the business hasn't logged it, adjust the Book side.
3
Reconcile to Zero Discrepancy
Calculate Adjusted Bank and Adjusted Books. If they don't match, check for transpositions (Rule of 9s!).
Open your worksheets to Vanguard Logistics & Summit Gear Co. Precision • Integrity • Accountability
