Reconcile a personal bank statement
See this course’s project requirements
A fictional personal-account register reconciled to a statement, with pending items, availability, fees and an error-report draft.
Keep your working files in your own notebook or software. Save a private description, checklist, and work link in My Proof.
What to include
- An account-service and annual-fee comparison with unanswered eligibility questions.
- A posted/available/uncommitted balance worksheet with each commitment counted once.
- A running-balance register with transaction identities, types and posting states.
- A two-sided bank reconciliation with an unmatched-item log.
- A transaction-specific error inquiry and follow-up log.
- A paper account-move checklist with a retained-funds calculation and closure conditions.
Review and revise
Use these criteria to check your work and choose what to improve.
- All supplied records reconcile and the decision uses the named case rules.
- Calculations show units, intermediate values and a second check.
- Changed-input practice revises the affected result and identifies uncertainty.
- The final project combines six lesson records, separates fictional assumptions from current rules, and states a supported next step.
Want more background?
The idea in everyday life
This is a new independent statement case, not a continuation of the previous payment-register case. Its transaction T1 is a separate USD 30 transfer and it adds outstanding check C1 for USD 20; do not carry forward the previous case’s USD 50 transfer. This is an original fictional practice case. No account, payment, personal record or outside participation is required. Register closes $325. Statement closes $340; a $20 check is outstanding and a $5 bank fee is missing from the register.
Explain differences between two records; do not force agreement by inventing an adjustment.
Reconcile a personal bank statement — worked practice
Explain differences between two records; do not force agreement by inventing an adjustment.
This is a new independent statement case, not a continuation of the previous payment-register case. Its transaction T1 is a separate USD 30 transfer and it adds outstanding check C1 for USD 20; do not carry forward the previous case’s USD 50 transfer. Use paper or a local table; label all amounts as fictional USD unless the case names another unit. Register closes $325. Statement closes $340; a $20 check is outstanding and a $5 bank fee is missing from the register.
Register before bank-fee update
Paste at A1.
| AID | BEvent | CSigned USD | DRegister state |
|---|---|---|---|
| OPEN | Opening | 300 | Recorded |
| D1 | Deposit | 120 | Recorded |
| G1 | Groceries | -45 | Recorded |
| T1 | Own savings transfer | -30 | Recorded |
| C1 | Check | -20 | Unpresented |
Copy as plain text
Bank statement
Paste at A1.
| AID | BEvent | CSigned USD | DStatement state |
|---|---|---|---|
| OPEN | Opening | 300 | Posted |
| D1 | Deposit | 120 | Posted |
| G1 | Groceries | -45 | Posted |
| T1 | Own savings transfer | -30 | Posted |
| F1 | Bank fee | -5 | Posted |
Copy as plain text
1. Step 1: Compare unmatched items by amount and identity
Match OPEN, D1, G1 and T1 by identity and amount in the two supplied tables; tick matching rows. Put C1 and F1 in the unmatched-item log rather than changing a matched row.
You should see: One $20 outstanding check and one $5 fee.
Explain differences between two records; do not force agreement by inventing an adjustment.
2. Step 2: Adjust the statement for the unpresented check
Adjust the statement for the unpresented check.
You should see: 340−20=$320.
Keep this intermediate result so the final decision can be checked.
3. Step 3: Record the supported fee in the register
Record the supported fee in the register.
You should see: 325−5=$320.
Keep this intermediate result so the final decision can be checked.
4. Step 4: Compare corrected totals and retain the difference list
Compare corrected totals and retain the difference list.
You should see: Both adjusted balances are $320; reconciliation difference $0.
Keep this intermediate result so the final decision can be checked.
What to finish
A two-sided bank reconciliation with an unmatched-item log.
Watch for this
Posting an outstanding check to the register again when it was already recorded.
How can I tell I understand it?
Reconcile a register and bank statement using supported book adjustments and timing differences on a new supplied case, with a visible intermediate check and no unsupported real-world promise.
Quick knowledge check
Answer all 3 questions. Get at least 2 right and the lesson completes automatically.
You’ll get an explanation for each answer. Signed in? Your results save to your account.
Pass the check. We’ll save the progress.
Answer all 3 questions above and get at least 2 right. You can review the explanations and try again.
Go to the knowledge checkTools, templates, and lesson sources
Tools and templates
Tools open in a new tab so you can keep your place here.
Sources and further reading
Explore the references behind this lesson.
Source & access notes · checked 2026-10-01
Official page opened/read during Money expansion authoring; checked the relevant concept and access state. These sources do not establish funding eligibility.
Access: Readable official webpage inspected with the web reader on 2026-10-01. No interactive-tool operation is claimed.
Reuse: Original fictional practice, questions and calculations; paraphrased concepts with a source link. No source exercise copied.
Report a problem with this lesson
Tell us what went wrong. Please leave out personal information and private project contents.