Foundry Academy · Bookkeeping Fundamentals · Lesson 4 of 6

Bank and card reconciliation

Reconcile cash and card activity to independent statements and resolve differences through a controlled exception process.

Start the lesson

Your learning work, on this device

No signup, cloud storage, cross-device sync or verified completion. Saving is optional. This browser profile is shared with anyone who can use it; private mode, browser cleanup or storage limits may remove work. Use only fictional or non-sensitive material. Export a copy before relying on this device.

Not saved. Worksheets, answers and practice notes currently last only in this tab.

Practice markers are self-reported, never credentials.

01 · Explanation

Bank and card reconciliation

Objective: Reconcile cash and card activity to independent statements and resolve differences through a controlled exception process.

A reconciliation compares the ledger with an independent statement for the same account and cutoff date. Begin with the opening balance, confirm statement coverage, and compare deposits, withdrawals, fees, transfers, card charges, refunds, and payments. Identify timing items such as outstanding checks and deposits in transit separately from errors or missing transactions. Do not plug the difference into a miscellaneous account. Every reconciling item needs an amount, date, explanation, source, owner, and target resolution date. Use read-only statement access where possible and protect account numbers and credentials.

A preparer completes the comparison and an authorized reviewer investigates unusual or stale items, verifies corrections, and signs the reconciliation. Look for duplicate charges, unrecognized payees, altered payment details, transfers recorded on only one side, old outstanding items, cash withdrawals, and activity after a cardholder left. Suspicious activity is a security and banking matter, not merely a bookkeeping variance; follow the bank's reporting process and the organization's incident plan promptly. Never ask a learner or client to place credentials, full card numbers, or personal financial information in a worksheet or unapproved collaboration tool.

Before you begin

  • Confirm F01–F04 and the sign convention before calculating: bank $46,820.14; ledger $49,105.14; duplicate receipt $1,900; outstanding check $410; bank fee $25.
  • Calculate the starting difference as ledger minus bank: $2,285.00.
  • Treat F05 as a conflicting classification exception, not as a plug or an automatic reconciling item.

Original overview module anchor →

02 · Compare the artifacts

Supported work. Visible uncertainty.

This is a fictional, sanitized training case with fabricated transactions. It contains no real personal, banking, payroll, tax, or confidential data and is not accounting, tax, legal, or financial advice.

Northline Field Services month-end close

Northline Field Services is a fictional six-person equipment-inspection business completing its April books. The owner asks an operations coordinator to prepare a review-ready close without making accounting or tax judgments. The bank statement ending balance is $46,820.14, while the ledger cash balance is $49,105.14. The $2,285 starting difference sits alongside a $1,900 customer payment recorded twice, a $410 check issued but not yet cleared, and a $25 bank fee not recorded. Applying those items with the proper signs explains $1,515 of the difference and leaves $770 unresolved; the packet intentionally supplies no reconciling record for that residual. A $6,400 deposit is supported by two documents that conflict: the bank memo says owner transfer, while the CRM labels it annual-service revenue. An April 30 supplier invoice for $3,780 was received May 2 for work delivered in April. A field technician used a personal card for $286.40 of approved supplies, but the reimbursement form lacks the project code. A twelve-month software subscription of $2,160 was charged on April 1 and posted entirely to April software expense. The payroll summary shows gross wages of $18,600; the bank shows a $15,900 payroll withdrawal, and no liability reconciliation is attached. Accounts receivable includes a $4,250 invoice that the customer disputed in writing over incomplete deliverables. A vehicle purchased for $31,000 was posted to repairs expense. The owner withdrew $3,000 and labeled it payroll in a spreadsheet, but no payroll record supports that description. Northline's draft income statement shows a $21,400 April profit, which the owner wants to send to a lender tomorrow. Learners must assemble a controlled bookkeeping file, identify what can be corrected from available evidence, and route classification, tax, payroll, collectibility, and reporting questions to qualified reviewers. The target is a transparent, reproducible close—not a preferred profit number.

Supported example — reference only

Line ID
RECON-RESIDUAL
Reconciliation side
Derived ledger-minus-bank bridge
Item
Unresolved residual after supported April adjustments
Source amount
$2,285.00 starting difference; $1,900.00 duplicate receipt; $410.00 outstanding check; $25.00 bank fee.
Signed bridge effect
−$1,900.00 + $410.00 − $25.00 = −$1,515.00 under the stated orientation.
Adjusted amount or subtotal
$2,285.00 − $1,515.00 = $770.00 unresolved residual.
Source input IDs
M04-I01 (F01); M04-I02 (F02); M04-I03 (F03); M04-I04 (F04)
Evidence status
Source amounts confirmed; $1,515.00 subtotal and $770.00 residual are derived arithmetic.
Owner
Authorized bookkeeper, accountant, or financial reviewer
Reviewer sign-off
Not supplied
Exception or gap
Transaction-level evidence explaining the $770.00 and any correction record are not supplied; no plug entry is permitted.
Status
Residual open — reconciliation not complete

A well-handled evidence gap

Line ID
RECON-GAP-F05
Reconciliation side
Classification exception outside the arithmetic bridge
Item
$6,400 deposit classification conflict
Source amount
$6,400.00 deposit; bank memo says owner transfer while CRM says annual-service revenue.
Signed bridge effect
Not applied; no supplied evidence shows that this classification conflict explains the bank-ledger difference.
Adjusted amount or subtotal
$770.00 arithmetic residual remains unresolved and separate.
Source input IDs
M04-I01 (F01); M04-I02 (F02); M04-I03 (F03); M04-I04 (F04); M04-I05 (F05, conflicting)
Evidence status
Conflicting classification; transaction-level bridge relationship is not supplied.
Owner
Authorized accountant or financial reviewer
Reviewer sign-off
Not supplied
Exception or gap
Deposit trace, agreement, customer or owner support, accounting treatment, review date, and disposition are not supplied.
Status
Conflict open — separate from arithmetic residual

Flawed approach — do not copy

Marking this bank-reconciliation schedule “approved and complete” without the required evidence or reviewer is a flawed submission. Stop close and lender release while the $770 residual, sign convention, or any material exception lacks authorized review.

Repair: Rework the bank-reconciliation schedule as an evidence-backed draft, not an approved result. Set reconciliation orientation explicitly as ledger minus bank and reproduce the $2,285.00 starting difference from F01. List the duplicate receipt, outstanding check, and bank fee separately with the side affected and signed effect on the chosen bridge. Apply the supported signs: remove $1,900 duplicate ledger receipt, recognize $25 bank fee in ledger, and treat $410 outstanding check as a bank-side timing item. Check the revision against this requirement: The schedule and bridge reproduce $2,285.00, $1,515.00, and $770.00 with visible formulas and signs. If the required evidence is still absent, keep the decision blocked and identify the missing input or authorized reviewer.

Full case record, ambiguities and all assignments →

03 · Bounded practice

Build the bank-reconciliation schedule.

Analyze the bank and ledger difference using only supported entries, show both possible reconciliation orientations, and isolate any residual contradiction instead of forcing a plug.

Deliverable: A bank-reconciliation starter, arithmetic bridge, and exception register that leaves any unexplained residual visible for review.

Complete a bounded starter and gap analysis using only CB01, F01, F02, F03, F04, F05, and the assignment-scope record below. Populate supported fields, label every unavailable field “not supplied,” and cite the input ID for each material statement. You may design a proposed template, control, question, or decision rule, but must label it as a learner proposal rather than observed case evidence. Do not contact people, access live systems, run tests, sign records, claim approval, or invent names, dates, quotations, transactions, results, or source documents.

Exact supplied inputs for this assignment
  • M04-I01 · F01 — The April bank ending balance is $46,820.14 and ledger cash is $49,105.14.
  • M04-I02 · F02 — A $1,900 customer receipt appears twice in the ledger.
  • M04-I03 · F03 — A $410 issued check remained outstanding at April 30.
  • M04-I04 · F04 — A $25 bank fee is present on the statement but absent from the ledger.
  • M04-I05 · F05 — A $6,400 deposit is labeled owner transfer by the bank memo and annual-service revenue by the CRM.
  • M04-B01 · CB01 — Use CB01, the full versioned case brief printed once at the start of this packet, as a citable narrative source for details not normalized into F01–F12. Preserve its uncertainty language and do not treat narrative detail as approval, complete operational records, or professional judgment.
  • M04-S01 · F01, F02, F03, F04, F05 — Build a starter version of “A bank-reconciliation starter, arithmetic bridge, and exception register that leaves any unexplained residual visible for review.” from the listed case facts. Treat requested structures, controls, questions, calculations, and templates as learner-designed proposals. Where an operational record or result is absent, add a gap entry naming the missing evidence and authorized owner instead of fabricating it.

Operating procedure

  1. Set reconciliation orientation explicitly as ledger minus bank and reproduce the $2,285.00 starting difference from F01.
  2. List the duplicate receipt, outstanding check, and bank fee separately with the side affected and signed effect on the chosen bridge.
  3. Apply the supported signs: remove $1,900 duplicate ledger receipt, recognize $25 bank fee in ledger, and treat $410 outstanding check as a bank-side timing item.
  4. Show that the three properly signed adjustments explain $1,515.00 of the $2,285.00 difference, leaving a derived $770.00 residual.
  5. Keep the $770.00 as an unresolved exception with source arithmetic, owner role, evidence request, and pending review; never post it to a plug account.
  6. Record the conflicting $6,400 deposit classification separately because classification review does not automatically make it a cash-reconciliation adjustment.
  7. Route the bridge, sign convention, residual, and F05 treatment to an authorized accounting reviewer for sign-off.
  8. Perform a final arithmetic check: starting difference minus explained adjustments equals residual, with every component traceable to F01–F04.
Field-by-field guidance
Line ID
Use stable identifiers for opening balances, the starting difference, each signed adjustment, the explained subtotal, and the residual.
Reconciliation side
State bank, ledger, timing, ledger correction, derived bridge, or external classification exception; never leave orientation implicit.
Item
Name the balance, duplicate receipt, outstanding check, bank fee, residual, or classification conflict represented by the line.
Source amount
Record the exact supplied or derived amount and distinguish source balance, adjustment, subtotal, and residual.
Signed bridge effect
Show the sign and formula under the stated ledger-minus-bank orientation; never use an unexplained plug.
Adjusted amount or subtotal
Record the resulting difference or subtotal after the signed effect and make derived arithmetic reproducible.
Source input IDs
Cite M04-I01 through M04-I04 for the bridge and M04-I05 only for the separate classification conflict.
Evidence status
Use Confirmed source amount, Conflicting classification, Derived arithmetic, or Evidence not supplied.
Owner
Name the authorized bookkeeper, accountant, or financial reviewer role responsible for evidence or disposition.
Reviewer sign-off
Record Not supplied until an authorized reviewer signs the bridge and exception treatment.
Exception or gap
State the missing transaction trace, correction evidence, classification support, review date, or unexplained residual.
Status
Use Calculated, Timing item, Ledger correction pending, Residual open, or Reviewer sign-off pending.
Bank-reconciliation schedule · learning draft
Line IDReconciliation sideItemSource amountSigned bridge effectAdjusted amount or subtotalSource input IDsEvidence statusOwnerReviewer sign-offException or gapStatus

Start with 6 rows; the complete workbook specifies 8 stable rows for this artifact. Add rows here or use the full download. No action is saved until you explicitly choose saving above.

Download complete six-module workbook (.md) · Structured case packet (.json)

Keep private client data, unpublished inventions, personal identifiers and credentials out of these public learning tools.

Module 4 · 2-item formative check

Bank and card reconciliation

Choose an answer and request feedback. Read why each option does or does not fit the evidence. Answers stay in this tab unless you choose device-only saving; they are never submitted.

Question 1 of 2 · MODULE 4 · knowledgeWhat demonstrates that a bank reconciliation is complete and ready for review?
Question 2 of 2 · MODULE 4 · scenarioWhich reconciliation packet accurately presents Northline's supplied April cash evidence without forcing the ledger to balance?

Answer either question to review its reasoning.

Inspect the artifact, not just your quiz answers

  • The schedule and bridge reproduce $2,285.00, $1,515.00, and $770.00 with visible formulas and signs.
  • F01–F04 support every bridge amount; F05 remains a separate conflicting exception.
  • No plug, invented transaction, correction posting, review date, or sign-off is recorded.

Stop: Stop close and lender release while the $770 residual, sign convention, or any material exception lacks authorized review.

Go: Go to reviewer sign-off when the bridge reproduces $2,285, explains $1,515, preserves the $770 residual, and cites F01–F04.

Escalate: Escalate F05 classification and any proposed correction or write-off to the authorized accounting reviewer.

04 · Evidence to keep

Leave with usable work.

Reconciliation cover sheet, matched transaction list, reconciling-item schedule, correction support, incident escalation record, and reviewer signoff.

Download your artifact CSV and, if wanted, export the learning-work JSON above. Neither export is a reviewed submission or certificate. Device-only saving is optional; you must press Save my work now after edits.

When all six artifacts are ready, compare the full packet against the track rubric. Qualified human review is still required before real-world decisions.

Finance professional reviewing business data and records at an office workstation.
Learn the standard. Practice the work.
Organized financial documents, calculator, and source records on a business desk.
Leave with evidence you can inspect.

Sources, scope and review boundaries

Curriculum 2026.10.08-learning-paths-1. External source dates below are record checks, not continuing guarantees. Verify current requirements before consequential use.

irs-publication-583 · Official guidance

IRS Publication 583: Starting a Business and Keeping Records

Primary federal guidance on records, supporting documents, bookkeeping systems, bank reconciliation, and retention concepts.

Open reviewed external source ↗

sba-manage-your-finances · Official guidance

SBA: Manage your finances

Official small-business guidance on bookkeeping, financial statements, and financial management.

Open reviewed external source ↗

ws-bookkeeping-operating-standard · Academy internal operating standard

Wealth Synergy bookkeeping workflow internal operating standard

Academy-selected responsibility, exception, close, approval, and evidence controls; it does not provide accounting, tax, or audit authority. This is an internal operating standard selected by Foundry Academy; it is not law, accreditation, licensure, or an external-standard requirement.

Version 1.0 · reviewed 2026-09-01 · owner: Foundry Academy curriculum owner

A future Wealth Synergy private professional-development certificate would be issued only after its assessment, capstone, identity, reviewer, retention, access, deletion, appeal, and issuance controls pass quality review. No credential is currently issued. Any future certificate would not be an accredited academic qualification, professional license, or government certification.