Weekly cash control and bank reconciliation: a worked ETB example
By Birhanu Arbse · Published 26 October 2026 · Version 1.0
A bank balance can look reassuring while a supplier payment is still waiting to clear. A cashbook can also look wrong simply because a deposit has not appeared on the bank statement. The weekly task is to explain the difference, correct the records and decide what needs attention before another payment is approved.
This guide is for an owner or bookkeeper of a small trading or service business with one ETB bank account and a separate cash float. You can follow it with a ruled notebook or a spreadsheet. Prepare a separate reconciliation for each account and currency. Find the other practical guides on Resources.
The business, references, dates and amounts below are fictional teaching material. They are not ARBSE transactions, client records, market statistics or evidence of field results. This is a basic operating-control example, not a tax calculation, a statutory reporting procedure or a substitute for advice on a particular accounting entry.
Know which balance you are checking
- Cashbook bank balance: the business’s record of money entering and leaving this bank account. In this guide, “cashbook” means its bank column only. A separate cash column or cash-on-hand record tracks notes and coins.
- Bank-statement balance: the bank’s recorded closing balance at the same cut-off. It reflects the entries the bank has posted by then.
- Physical cash available: notes and coins actually counted in the till or safe. A deposit already handed to the bank is no longer physical cash on the premises.
- Timing difference: a genuine transaction already correctly recorded by the business, with evidence, that the bank has not yet posted. Keep it on a follow-up list; do not record it twice.
- Actual error: an incorrect amount, duplicate, omission or wrong-account entry. Investigate and correct the record that is wrong, keeping the original evidence and the correction reference.
A statement balance is also different from the bank’s current available balance. Check holds, restrictions and pending payments before deciding what can be spent. A reconciliation explains records; it does not approve new spending.
The fictional week: 19–23 October 2026
The example uses one ETB bank account and a separate ETB 2,000 cash float. The previous reconciliation is complete. At the opening of 19 October, both the cashbook bank balance and bank statement are ETB 30,000, with no brought-forward timing differences. The physical float is counted separately and agrees to its cash record at ETB 2,000.
Use 18:00 on 23 October, Addis Ababa time, as the common cut-off. The statement and business records must cover the same account and end point. All bank amounts below are in ETB; “+” means money in and “−” means money out from the business’s perspective.
1. Read the cashbook as it was first recorded
| Date and reference | Bank-column entry | ETB |
|---|---|---|
| 19 Oct · opening | Agreed opening balance | 30,000 |
| 19 Oct · C101 | Customer bank transfer received | +18,000 |
| 19 Oct · T101 | Supplier transfer paid | −12,000 |
| 20 Oct · D101 | Cash sales deposited at bank | +6,500 |
| 21 Oct · T102 | Utility payment, entered incorrectly | −7,200 |
| 22 Oct · T103 | Rent transfer paid | −8,000 |
| 23 Oct · D102 | Cash deposit handed to bank | +9,000 |
| 23 Oct · P104 | Supplier cheque issued and delivered | −5,000 |
| 23 Oct · close | Uncorrected cashbook bank balance | 31,300 |
Receipts total 18,000 + 6,500 + 9,000 = 33,500. Recorded payments total 12,000 + 7,200 + 8,000 + 5,000 = 32,200. Therefore 30,000 + 33,500 − 32,200 = 31,300.
D101 and D102 transfer money from physical cash into the bank. The underlying cash sales belong in the sales/cash records once; banking those takings is not another sale. In this simplified week, cash sales received are ETB 15,500 and all those takings are deposited. No payment is made from the separate cash float.
2. Read the bank statement independently
| Date and reference | Statement movement | ETB |
|---|---|---|
| 19 Oct · opening | Opening bank balance | 30,000 |
| 19 Oct · C101 | Customer transfer credited | +18,000 |
| 19 Oct · T101 | Supplier transfer debited | −12,000 |
| 20 Oct · D101 | Cash deposit credited | +6,500 |
| 21 Oct · T102 | Actual utility transfer debited | −2,700 |
| 22 Oct · T103 | Rent transfer debited | −8,000 |
| 23 Oct · B001 | Bank service charge | −250 |
| 23 Oct · close | Closing statement balance | 31,550 |
The statement totals independently: 30,000 + 18,000 − 12,000 + 6,500 − 2,700 − 8,000 − 250 = 31,550. It contains neither D102 nor P104 at the cut-off.
Match transactions before adjusting totals
Tick a cashbook line and its corresponding statement line only when the amount, direction and reference agree. If a bank uses a different reference, connect it to the supporting receipt or transfer advice. Equal amounts alone do not prove a match.
C101, T101, D101 and T103 match. Four items need separate treatment:
- D102, ETB 9,000 — deposit in transit. The dated deposit receipt confirms the cash was handed to the bank on 23 October. It is already correctly in the cashbook but absent from this statement. Add it when reconciling the statement balance; follow up its eventual credit.
- P104, ETB 5,000 — outstanding cheque. The approved payment record and delivered cheque support the cashbook entry. The bank has not debited it. Deduct it when reconciling the statement balance and keep the obligation visible. Do not issue a replacement simply because it has not cleared.
- B001, ETB 250 — unrecorded bank charge. The bank has posted it; the business has not. Check the statement description, then record the charge and its reference in the books.
- T102 — recording error. The authorised payment record and transfer confirmation both show ETB 2,700. The bank agrees. The cashbook wrongly deducted ETB 7,200. The excess deduction is 7,200 − 2,700 = 4,500.
A deposit without evidence is an unresolved item, not automatically a timing difference. Likewise, a transfer request marked failed or rejected needs investigation rather than being carried indefinitely as an outstanding payment. If evidence points to a bank error, raise it with the bank and retain the case reference; do not alter the bank statement yourself.
Correct the cashbook, then reconcile the bank
3. Make the supported book corrections
| Cashbook correction | Effect on bank balance, ETB |
|---|---|
| Uncorrected cashbook balance | 31,300 |
| Add back the excess T102 deduction | +4,500 |
| Record bank charge B001 | −250 |
| Corrected cashbook bank balance | 35,550 |
The utility correction increases the balance because too much was previously deducted. One clear correction record would say: “T102 payment was ETB 2,700; ETB 7,200 entered; restore ETB 4,500,” with a dated correction reference. Record the bank charge separately. Keep the original entry readable or retain the system’s change history. If using double-entry accounts, the corresponding expense or payable correction must also be handled appropriately; increasing the bank balance is not new income.
Corrected cashbook: 31,300 + 4,500 − 250 = 35,550. Do not add D102 or deduct P104 again in the cashbook: both were already recorded correctly.
4. Explain the bank-statement balance
| Reconciliation at 23 October | ETB |
|---|---|
| Closing bank-statement balance | 31,550 |
| Add D102 deposit in transit | +9,000 |
| Deduct P104 outstanding cheque | −5,000 |
| Adjusted bank balance | 35,550 |
| Corrected cashbook bank balance | 35,550 |
| Unexplained difference | 0 |
Adjusted bank: 31,550 + 9,000 − 5,000 = 35,550. The adjusted bank balance now agrees with the corrected cashbook. These bank-side reconciliation adjustments explain the statement; they are not instructions to change it or post the same transactions again.
For a simple follow-through, suppose D102 is credited and P104 is debited on 26 October, with no other activity. The bank then reaches 31,550 + 9,000 − 5,000 = 35,550. Mark both timing items cleared against that later statement. Their clearance does not require another receipt or payment in the cashbook.
5. Count physical cash separately
| Cash-on-hand check | ETB |
|---|---|
| Opening float | 2,000 |
| Cash sales received during the week | +15,500 |
| Cash handed to bank: D101 + D102 | −15,500 |
| Expected physical cash at cut-off | 2,000 |
| Actual counted notes and coins | 2,000 |
| Cash-count difference | 0 |
Count denominations and record the date, time and people present. The ETB 9,000 deposit in transit is not still in the till. Do not count it as physical cash as well as a bank receipt. If the actual count were ETB 1,900, the ETB 100 shortage would need its own investigation even though the bank reconciliation balances.
Checks that expose a false reconciliation
The original cashbook and statement differed by only ETB 250. That small net gap hid a ETB 4,500 error and ETB 4,000 net timing difference. Looking only at closing balances could miss both.
- Recalculate opening balance plus receipts minus payments independently. A correct final subtraction does not repair a missing transaction.
- Confirm T102’s direction: +4,500, not −4,500. Deducting the bank charge alone leaves the cashbook at ETB 31,050 and still ETB 4,500 below the adjusted bank balance.
- Give every difference a unique reference and a supporting document. Check for repeated amounts, duplicate references and items entered in another bank account.
- Roll forward every open timing item from the previous review. Clear it only against evidence; keep its original date so its age remains visible.
- Never invent an “adjustment” to force zero. Agreement can also hide offsetting errors or unsupported transactions; review the underlying matches.
Reusable weekly review checklist
Copy this checklist into a notebook or your existing workbook. Mark each line only when its evidence is available. Repeat it for every bank account; count cash separately.
- ☐ Record the business, masked account identifier, currency, week and exact cut-off.
- ☐ Agree the opening cashbook balance to the previous signed reconciliation and bring forward its open items.
- ☐ Obtain the complete bank statement or transaction record through the cut-off; check continuity, not just a balance screenshot.
- ☐ Total receipts and payments; match statement lines to cashbook entries and supporting references.
- ☐ Verify deposits against sales/cash records and deposit receipts; prevent duplicate sales recognition.
- ☐ Record verified bank-side entries and approved book corrections with dated references.
- ☐ List each timing item with amount, original date, evidence, expected clearance, owner and follow-up date.
- ☐ Calculate both adjusted balances and the unexplained difference; leave unresolved amounts visible.
- ☐ Count physical cash, compare it with its own record and investigate any difference.
- ☐ Review confirmed available bank funds, pending payments and upcoming obligations before proposing new spending.
- ☐ Have the reviewer check the evidence, corrections and exceptions; record names and review date.
- ☐ Retain the week’s pack, assign remaining actions and set the next review date.
Use a short exception record for anything still open: reference; amount; what is known; missing evidence; action; owner; due date; clearance evidence. This makes the next week’s starting point explicit.
Turn the reconciliation into action
The bookkeeper or person maintaining the records prepares the reconciliation. The owner or a second authorised person reviews it against the statement and payment/deposit evidence. Separate preparation from review where staffing permits. A sole owner can perform a documented second pass later, using the original evidence, while recognising that self-review provides less independence.
For this fictional week, the preparer records the two book corrections and follows up D102 and P104 on 26 October. The reviewer checks their supporting documents, confirms the ETB 35,550 agreement and the separate ETB 2,000 cash count, and keeps the uncleared ETB 5,000 payment reserved in payment planning until its status is confirmed.
Escalate an unexplained difference or unsupported entry to the owner before signing the week off. Missing cash, an unknown withdrawal, an altered payee or a deposit absent beyond its agreed follow-up date needs prompt attention regardless of amount. Contact the bank promptly for a disputed bank entry. A timing item can remain open only with evidence, an owner and a follow-up date; it must not disappear because a new week starts. These are recommended operating controls, not statutory deadlines or a claim that every discrepancy proves misconduct.
Keep the statement, dated cashbook version, deposit slips, payment approvals and confirmations, cash-count sheet, correction records, timing-item list and dated review together. Protect account details and keep a recoverable copy. Follow the retention requirements applicable to your business; this guide does not prescribe a legal retention period.
If an unresolved control problem needs a defined review, the Focused Decision Review explains ARBSE’s advisory scope. Describe the issue and timing in the initial inquiry; keep statements, account numbers and confidential records out of the public form.
Method references
The example, checklist and explanations were prepared for this ARBSE resource. General treatment of book-side entries and bank timing items was cross-checked against ACCA’s FA2 examiner’s report, Example 2, page 4. OpenStax, Principles of Accounting, section 8.3, provides further reading on responsibilities, documentation and separation of duties. No external illustration or worked example is reproduced here.