Lab 1
Reconcile Acme’s July checking account
Scenario
Acme Services’ July bank statement for Checking shows an ending balance of $44,712.50. The books show $44,470.00. The statement lists a $35 monthly service fee and a $12.50 wire fee Acme never recorded, plus all the deposits and payments Acme expected - except one: a $290 check to Metro Uniforms mailed July 30 has not hit the bank.
Steps
- 1
Create a reconciliation session for Checking, period July 1–31, statement ending balance $44,712.50.
Expected: The session opens showing uncleared book transactions for July.
- 2
Clear every book transaction that appears on the statement (deposits from Brightline and Corner Market, the Thursday payment runs, payroll).
Expected: The remaining difference is $242.50 - the statement is higher than the cleared book balance.
- 3
Add the two bank fees inside the session: $35 service fee and $12.50 wire fee, posting to Bank fees expense, and clear them.
Expected: The fees reduce the book side by $47.50, so the difference moves to exactly $290.00.
- 4
Identify the remaining $290.00 difference.
Expected: It is the outstanding Metro Uniforms check - recorded in the books July 30, not yet presented at the bank. Correct handling: leave it uncleared.
- 5
Confirm the session difference is $0.00 against the statement (cleared balance $44,712.50; the $290 stays outstanding).
Expected: Difference reads zero with one outstanding item listed.
- 6
Complete the session.
Expected: July is reconciled; the $290 check will clear in August’s session.
Checkpoints - you got it right if…
- Two bank fees added during the session, posted to Bank fees expense ($47.50 total)
- The $290 Metro Uniforms check left uncleared, not forced or deleted
- Session completed with a difference of exactly $0.00
- You can state next month’s expected first clearing item (the $290 check)