Bank reconciliation compares a bank statement with the cash ledger for the same account, currency, and cutoff. Finish this guide with a saved working paper showing two adjusted balances, a retained unexplained residual, and an evidence-review list.
Last updated: 29 October 2026.
What does bank reconciliation establish?
Your bank statement and cash ledger can show different balances at the same cutoff. A reconciliation working paper explains supported differences without changing either original record. The output here is two adjusted working balances, a retained unexplained residual, and an investigation list. It is not an instruction to post accounting entries or move money.
Adjusted means adjusted within this comparison worksheet only. It does not mean the bank has changed its displayed balance or that your books have already been corrected. Preserve that distinction when sharing the result with someone who authorizes accounting changes.
Restrict the exercise to one account, one currency, and one cutoff. A cutoff is the date and point in time covered by the comparison. A statement ending yesterday cannot be compared casually with a ledger including today's activity. Record both source ranges before considering any reconciling item.
This is also different from a forward-looking cash flow plan. A forecast asks when future receipts and payments will occur. This working paper investigates why two historical records differ at a defined point.
Preserve the two starting records
Save unchanged copies of the statement and the cash-account ledger. Label the account reference, currency, covered dates, and extraction time where available. Record the two starting balances explicitly so a reviewer can reconstruct every later step from the same inputs.
- Confirm that both files identify the same account. Expected output: a documented account match, not a guess based on a familiar balance.
- Confirm currency and cutoff. Output: a common comparison boundary rather than a mixture of dates or denominations.
- List unmatched transactions with evidence references. Output: individual questions that can be investigated without altering the source records.
- Keep transaction identifiers intact. Output: a way to distinguish duplicate rows from genuinely separate transactions of equal value.
An equal amount is not sufficient matching evidence. Direction, reference, date, and supporting documents can matter. If a row belongs to another account or currency, stop this bounded exercise rather than inventing an exchange rate or assuming the difference is harmless.
If you are still choosing or opening an account, the business bank account guide addresses that setup task. This exercise starts after an account and its two record sources already exist.
Separate timing items from book-side omissions
OpenStax describes timing differences, bank charges, and errors as reasons bank and company records can differ. The classification question is specific: at the cutoff, which source contains this transaction and which does not? A name such as “payment” does not answer that question on its own.
| Documented situation | Working-paper treatment | Reason |
|---|---|---|
| Deposit recorded in the ledger but not yet by the bank | Add on bank side | Identified timing difference |
| Payment recorded in the ledger but not yet deducted by the bank | Subtract on bank side | Identified timing difference |
| Bank fee deducted on statement, absent from ledger | Subtract on book side | Show the documented omission in this comparison |
| Unknown item or missing supporting evidence | No invented adjustment | Retain for investigation |
These are worksheet categories, not posting instructions. The person responsible for accounting must separately validate the evidence and determine any appropriate action. An alleged timing item needs support that it was recorded on one side by the cutoff and not yet on the other.
Assign each item a unique evidence identifier. Counting the same deposit under two descriptions can create a false result. Conversely, merging separate payments because their amounts match can hide a real difference. Keep the source relationship visible beside the category.
A fictional two-balance exercise you can inspect
Teaching-model disclosure: the following inputs are invented by the author. They are not an Anar account, client incident, real bank statement, or measured operational result. The evidence descriptions are explicit exercise stipulations, not claims that actual banking documents were obtained.
The fictional account uses one currency unit and a cutoff of 29 October 2026. Its statement balance is 1,000 and its ledger balance is 1,070. Stipulated supporting facts identify a deposit in transit of 200, an outstanding payment of 150, and a bank fee of 20 missing from the ledger.
| Path | Calculation | Working balance |
|---|---|---|
| Bank side | 1,000 + 200 − 150 | 1,050 |
| Book side | 1,070 − 20 | 1,050 |
| Unexplained residual | 1,050 − 1,050 | 0 |
The arithmetic was executed in a decimal model and independently reconstructed with integer minor-unit sums. Both paths returned 105,000 minor units. The input and result file was saved, reopened, and compared with the original model output. No native spreadsheet interface was tested.
A zero residual is not proof of correct classification or complete evidence. Two mistakes can offset. The result tells you that these particular working rows produce equal totals, nothing more. A reviewer still needs to trace every item to its source, confirm its cutoff status, and check that it appears only once.
Use failures to identify the next question
Omit the fee from the exercise and the bank side remains 1,050 while the book side remains 1,070. With residual defined as bank minus book, the result is −20. Keep that sign convention on the sheet. Do not convert the gap into an invented expense simply because its size looks familiar.
For a deliberate sign-error diagnostic, subtract the deposit instead of adding it. The incorrect bank-side calculation is 1,000 − 200 − 150 = 650. Against the book-side 1,050, the residual becomes −400. This is a signal to revisit the working-paper sign, not evidence of an additional real transaction.
- Duplicate evidence identifiers mean HOLD until their relationship is understood.
- Different accounts, currencies, or cutoffs mean HOLD for this single-boundary exercise.
- Missing evidence, nonfinite values, or an unknown item category mean HOLD rather than a balancing plug.
- A supported but unresolved difference remains visible with an owner and next check.
In this model the amount is positive and the category supplies the direction. Entering a negative amount and subtracting it again can reverse the intended effect. If your export uses signed amounts, agree on its meaning before mapping it into these rows.
A complete mathematical match can still be substantively wrong. Review the item list even when the residual is zero. An omitted pair of offsetting items would not necessarily announce itself through the final balance.
Create and reopen a reviewable working paper
A fifteen-minute working window is a suggested starting session, not a measured speed claim. With incomplete documents, a useful result is an evidence-gap list rather than a forced match. Your immediate task is to make the question reviewable, not to eliminate every difference before the timer ends.
On Windows, search Start for Notepad and create a blank document titled “Fictional bank reconciliation V1”. Copy the template into it. Open Calculator from Start separately to check the sums; Notepad does not execute formulas.
- Capture the account, currency, cutoff, and original balances. Output: a clear boundary and two preserved starting figures.
- List unmatched items with source identifiers and status at cutoff. Output: a traceable set of candidate differences.
- Classify supported items and show each signed effect separately. Output: two reconstructable balance paths.
- Calculate the residual, save the file, and reopen it. Output: matching retained inputs and totals, with unresolved questions still visible.
Account / currency / cutoff: ... Original bank statement balance: ... Original cash-ledger balance: ... Item ID / evidence / positive amount: ... Present in which source at cutoff, absent from which: ... Working-paper side / direction / reviewer: ... Adjusted bank-side working balance: ... Adjusted book-side working balance: ... Unexplained residual = bank side − book side Open question / owner / next check: ...
In Notepad, choose File → Save As, select Documents and save bank-reconciliation-V1.txt. If that name exists, choose a new version name instead of overwriting another file. Close Notepad, open Documents in File Explorer and reopen that saved file. Locate the teaching inputs 1000/1070, signed items +200/−150/−20, both 1050 working balances and residual 0. Keep original records separate, retain each revision reason and never silently replace the starting balances. A final-number screenshot alone cannot reveal an incorrect account, duplicate deposit or changed cutoff.
When reopening the file, compare identifiers and input values as well as totals. A retained document is useful only if someone can see how it was built and what remains uncertain. None of these steps authorizes changes to a ledger or banking system.
Send the evidence question to the right owner
AccountingCoach explains comparison of bank and company transactions and separate working adjustments for the two sides. In your own file, attach an owner and requested document to each unexplained item. “Finance will check” is less useful than naming the row, evidence gap, and responsible reviewer.
Invoice allocation remains a different problem. Partial payment matching connects receipt amounts to invoices without double counting. Equal bank and ledger working balances do not prove that receipts were allocated correctly. An accounts receivable aging review then addresses due balances, not this two-record cash reconciliation.
Close with a precise statement: “The displayed paths match; evidence completeness and classification still require review,” or “An unexplained residual remains with these named investigation items.” For the broader reporting context, use the financial statements guide. This working paper is neither a financial statement nor an instruction to make accounting entries.
Frequently asked questions
Does a zero residual prove the reconciliation is correct?
No. Equal totals do not prove evidence completeness or correct classification. Trace each working item to its source and cutoff status.
Can I post an unknown gap as another expense?
No. This exercise authorizes no accounting entries. Retain the unknown amount with its evidence question, responsible reviewer, and next check.
Do equal amounts identify the same transaction?
Not necessarily. Compare references, direction, dates, and supporting evidence as well as the amount.
Does the example come from a real bank account?
No. It is an invented author teaching model that was executed, independently checked, saved, and reopened, not a real account or client result.
