5.1 Preparing the Bank Reconciliation Statement
Key Takeaways
- The Bank Reconciliation Statement is an internal control and verification document, not a ledger account, and does not form part of the double-entry bookkeeping system.
- Reconciliations bridge the timing gap between internal business records (updated Cash Book) and external banking records (Bank Statement).
- Unpresented cheques (drawn and credited in the cash book, but uncleared by the bank) must be deducted from the bank statement balance.
- Outstanding lodgements / deposits in transit (banked and debited in the cash book, but uncleared by the bank) must be added to the bank statement balance.
- Bank errors are corrected solely on the Bank Reconciliation Statement and reported to the bank; they are never entered into the business's cash book.
5.1 Preparing the Bank Reconciliation Statement
Quick Summary: The Bank Reconciliation Statement is an internal verification schedule—not a double-entry ledger account—that mathematically reconciles the updated balance of the business's Cash Book to the external Bank Statement. Reconciling items consist exclusively of timing differences (unpresented cheques and outstanding lodgements) and errors committed by the bank. By adding outstanding lodgements and subtracting unpresented cheques from the bank statement balance, bookkeepers prove that cash records agree precisely.
1. Purpose and Status of the Bank Reconciliation Statement
In business operations, the Cash Book (specifically its bank columns) and the external Bank Statement are mirror records kept by two independent parties:
- The Business records all receipts and payments affecting its commercial bank accounts in the Cash Book (a book of prime entry whose bank column also acts as the Bank Account in the general ledger).
- The Bank records all transactions flowing through the account on its own banking ledgers, providing a periodic summary known as the Bank Statement.
Under ideal conditions, the closing balance on the cash book would agree to the penny with the closing balance on the bank statement. In commercial reality, they almost never agree on any given date. The discrepancy arises from two distinct categories of items:
- Transactions known to the bank but not yet recorded by the business: Bank fees, overdraft interest, standing orders, direct debits, credit transfers from customers, and dishonoured cheques. These are resolved in Stage 1 by updating the Cash Book.
- Transactions recorded by the business but not yet processed by the bank (Timing Differences) and Bank Errors: Unpresented cheques, outstanding lodgements, and bank mistakes. These are resolved in Stage 2 by preparing the Bank Reconciliation Statement.
+-----------------------------------------------------------------------------------+
| THE TWO-STAGE RECONCILIATION PROCESS |
+-----------------------------------------------------------------------------------+
| STAGE 1: Update the Cash Book (AAT Task 3) |
| Compare Cash Book against Bank Statement. |
| Post unrecorded items into the Cash Book: |
| - Standing Orders, Direct Debits, Bank Charges, Interest, Credit Transfers |
| - Correct any internal business bookkeeper errors. |
| Balance off the Cash Book to find the UPDATED CASH BOOK BALANCE. |
+-----------------------------------------------------------------------------------+
│
▼
+-----------------------------------------------------------------------------------+
| STAGE 2: Prepare the Bank Reconciliation Statement (AAT Task 4) |
| Reconcile the Bank Statement balance to the Updated Cash Book balance using: |
| - Outstanding Lodgements (Deposits in transit) |
| - Unpresented Cheques (Outstanding cheques) |
| - Bank Errors (Mistakes made by the bank itself) |
| PROVE ARITHMETIC AGREEMENT. |
+-----------------------------------------------------------------------------------+
Critical Distinction: Memorandum Verification Document vs. Ledger Account
A vital rule tested repeatedly on the AAT Level 2 assessment is the accounting status of the reconciliation statement:
- It is NOT a ledger account: The Bank Reconciliation Statement does not form part of the double-entry bookkeeping system. It does not have a debit side or a credit side, and no entries are ever posted from it to the general ledger.
- It is a memorandum schedule: It is an internal control report prepared periodically (daily, weekly, or monthly) for management and external auditors to verify the integrity of the cash asset.
- No double-entry is generated: When you list an unpresented cheque or outstanding lodgement on the reconciliation statement, no general ledger accounts are updated. These transactions have already been entered into the double-entry system via the cash book; they are simply waiting for the commercial banking system to clear them.
2. Key Reconciling Items: Timing Differences and Bank Errors
Once the cash book has been updated for all bank charges, direct debits, standing orders, and automated receipts, any remaining discrepancy must be caused by timing differences or bank errors.
1. Unpresented Cheques (Outstanding Cheques)
An unpresented cheque is a cheque drawn and issued by the business to a payee (such as a trade supplier, HMRC, or utility provider) that has not yet been presented to the bank for payment by the statement cut-off date.
- Bookkeeping Entry Already Made: When the cheque was written and dispatched, the business immediately credited the Cash Book (payments side) and debited the corresponding account (e.g., Payables Ledger Control Account or expense account). The cash book balance was immediately reduced.
- Banking Reality: The payee may not pay the cheque into their bank immediately, or the cheque may still be processing through the banking clearing system (such as the UK Image Clearing System, which typically clears cheques within one business day of deposit, though postal and handling delays remain significant). The funds have not yet left the business's bank account.
- Reconciliation Effect: The bank statement balance is higher than the updated cash book balance because the bank has not yet deducted the funds. Therefore, unpresented cheques must be DEDUCTED from the bank statement balance.
2. Outstanding Lodgements (Deposits in Transit / Uncleared Lodgements)
An outstanding lodgement consists of cash, postal orders, or customer cheques received and paid into the bank by the business, which have not yet been credited to the account on the bank statement.
- Bookkeeping Entry Already Made: When the receipts were prepared and taken to the bank (or deposited via a smart automated deposit machine or night safe), the business immediately debited the Cash Book (receipts side) and credited the customer's account (or Receivables Ledger Control Account). The cash book balance was immediately increased.
- Banking Reality: Deposits made late in the afternoon (after the bank's daily clearing cut-off time), on weekends, or on non-business days do not appear on the bank statement until the subsequent business day. Similarly, deposited customer cheques require clearing time before funds are formally credited.
- Reconciliation Effect: The bank statement balance is lower than the updated cash book balance because the bank has not yet added the deposited funds. Therefore, outstanding lodgements must be ADDED to the bank statement balance.
3. Bank Errors
A bank error occurs when the financial institution itself makes an operational mistake. Examples include:
- Charging another customer's cheque or standing order to the business's account.
- Processing an automated payment twice in error.
- Misreading account digits during electronic clearing and depositing another client's funds into the business's account.
- Incorrectly calculating bank charges or interest on the statement.
+-----------------------------------------------------------------------------------+
| HANDLING BANK ERRORS: THE GOLDEN RULE |
+-----------------------------------------------------------------------------------+
| A business CANNOT make a double-entry posting to correct an error made by its |
| bank. The cash book reflects what the business has legitimately spent or received.|
| |
| 1. If the bank erroneously DEBITED our account (deducted money wrongly): |
| -> The bank statement balance is artificially TOO LOW. |
| -> ADD the error back to the Bank Statement on the reconciliation statement. |
| |
| 2. If the bank erroneously CREDITED our account (added money wrongly): |
| -> The bank statement balance is artificially TOO HIGH. |
| -> DEDUCT the error from the Bank Statement on the reconciliation statement. |
| |
| In both cases, inform the bank immediately so they can rectify their records. |
+-----------------------------------------------------------------------------------+
3. Standard Layout of the Bank Reconciliation Statement
In standard UK accounting practice and throughout the AAT CBA platform, there are two accepted presentation layouts. Candidates must be fluent in both.
Presentation 1: Starting with the Bank Statement Balance (Standard AAT Format)
This is the presentation most commonly encountered in AAT POBC Task 4 assessments. It starts with the balance shown on the external bank statement and adjusts it to arrive at the balance in the updated cash book:
Bank Reconciliation Statement as at [Date]
£ £
Balance as per Bank Statement X,XXX
Add: Outstanding lodgements (deposits in transit) XXX
Add: Bank error (amount improperly debited by bank) XXX
-------
Subtotal X,XXX
Less: Unpresented cheques (XXX)
Less: Bank error (amount improperly credited by bank) (XXX)
-----
Total deductions (XXX)
-------
Balance as per updated Cash Book X,XXX
=======
Presentation 2: Starting with the Updated Cash Book Balance (Reverse Format)
Examiners occasionally present a reconciliation template that begins with the business's updated cash book balance and works toward the closing bank statement balance. Notice that every adjustment sign is reversed:
Bank Reconciliation Statement as at [Date]
£ £
Balance as per updated Cash Book X,XXX
Add: Unpresented cheques XXX
Add: Bank error (amount improperly credited by bank) XXX
-------
Subtotal X,XXX
Less: Outstanding lodgements (XXX)
Less: Bank error (amount improperly debited by bank) (XXX)
-----
Total deductions (XXX)
-------
Balance as per Bank Statement X,XXX
=======
Why Signs Invert in the Reverse Presentation
Understanding the logic prevents rote memorization errors:
- In Presentation 1, we ask: "What must the bank do when it catches up with the business?" The bank will add our lodgements (+), deduct our unpresented cheques (-), and correct its mistakes.
- In Presentation 2, we ask: "How do we unwind our internal cash book entries to match where the bank currently stands?" Since the cash book has already deducted unpresented cheques, we must add them back (+). Since the cash book has already added outstanding lodgements, we must subtract them (-).
4. Comprehensive Worked Numerical Scenario
Let us work through a complete, realistic examination scenario illustrating the entire process from data extraction to formal reconciliation.
Scenario Data
On 30 September 2026, the bookkeeper of Thameside Logistics Ltd reviewed the company's banking records. The cash book bank columns were balanced off following the posting of routine period-end bank charges and direct debits, yielding an updated Cash Book balance of £6,000 (Debit).
Upon examining the Bank Statement dated 30 September 2026, the bookkeeper observed a closing credit balance of £6,780. Comparing the cash book against the bank statement revealed the following discrepancies:
- Outstanding Lodgement: A customer receipt of £1,450 paid into the bank branch at 16:45 on 30 September was recorded on the debit side of the cash book on 30 September, but was not processed onto the bank statement until 2 October.
- Unpresented Cheques: Two cheques drawn and dispatched to trade suppliers in late September had not yet been presented for payment by the suppliers' banks:
- Cheque #100842 (payable to Apex Fleet Parts): £820
- Cheque #100849 (payable to Meridian Fuel Ltd): £1,280
- Total unpresented cheques: £820 + £1,280 = £2,100
- Bank Error: The bank statement showed a credit entry of £130 on 29 September described as "BACS Trf - K. Vance". The bookkeeper verified that Thameside Logistics Ltd has no customer or debtor by this name. The bank confirmed over the phone that this was an error; the deposit was intended for "Thameside Security Ltd" (a completely separate business with an adjacent account number) and will be reversed on the October statement.
Arithmetic Proof
Before drafting the formal statement, verify the mathematics:
\text{Bank Statement Balance} &= \pounds6,780 \\ \text{Add: Outstanding Lodgements} &= +\pounds1,450 \quad (\pounds6,780 + \pounds1,450 = \pounds8,230) \\ \text{Less: Unpresented Cheques} &= -\pounds2,100 \quad (\pounds8,230 - \pounds2,100 = \pounds6,130) \\ \text{Less: Bank Error (Credit in error)} &= -\pounds130 \quad (\pounds6,130 - \pounds130 = \mathbf{\pounds6,000}) \\ \text{Agreed Updated Cash Book Balance} &= \mathbf{\pounds6,000} \end{aligned}$$ The calculation agrees exactly to the updated cash book balance of £6,000. ### Formal Bank Reconciliation Statement Layout **Thameside Logistics Ltd** **Bank Reconciliation Statement as at 30 September 2026** | Item / Description | Calculation (£) | Total (£) | | :--- | :--- | :--- | | **Balance as per Bank Statement (30 September 2026)** | | **6,780** | | **Add: Outstanding lodgement** | | | | Deposit in transit (banked 30 September) | 1,450 | **1,450** | | | | *8,230* | | **Less: Unpresented cheques** | | | | Cheque #100842 (Apex Fleet Parts) | (820) | | | Cheque #100849 (Meridian Fuel Ltd) | (1,280) | (2,100) | | **Less: Bank error** | | | | Miscredited BACS transfer (K. Vance) | (130) | (130) | | **Balance as per updated Cash Book** | | **6,000** | ### Reverse Presentation Layout (Proof Check) If required to begin with the updated Cash Book balance: | Item / Description | Calculation (£) | Total (£) | | :--- | :--- | :--- | | **Balance as per updated Cash Book (30 September 2026)** | | **6,000** | | **Add: Unpresented cheques** | | | | Cheque #100842 | 820 | | | Cheque #100849 | 1,280 | **2,100** | | **Add: Bank error (credit in error by bank)** | | **130** | | | | *8,230* | | **Less: Outstanding lodgement** | | | | Deposit in transit (banked 30 September) | (1,450) | **(1,450)** | | **Balance as per Bank Statement** | | **6,780** | Both presentations lead to the identical verified result, confirming complete mathematical agreement between internal and external records. --- ## 5. Tactical Rules and Examiner Insights for AAT Task 4 To secure full marks on Task 4 of the POBC assessment, keep these examiner insights at the forefront: ### 1. The Ticking-Off Method When given an initial cash book and bank statement in Task 3 and Task 4: - **Tick off** every item that appears on BOTH the cash book and bank statement. - Any unticked item in the **Bank Statement** represents an unrecorded transaction that must be posted into the **Cash Book** in Task 3 (e.g., bank charges, direct debits). - Any unticked item in the **Cash Book** represents a timing difference that belongs strictly in the **Bank Reconciliation Statement** in Task 4 (unpresented cheques on the payments side; outstanding lodgements on the receipts side). ### 2. Never Mix the Stages A frequent cause of failure reported by AAT assessors is placing cash book adjustment items on the reconciliation statement, or vice versa: - **Items that belong ONLY in the Cash Book:** Bank interest paid/received, bank service charges, direct debits, standing orders, unpaid/dishonoured cheques, and bookkeeper arithmetic errors. - **Items that belong ONLY in the Bank Reconciliation Statement:** Unpresented cheques, outstanding lodgements (deposits in transit), and bank errors. ### 3. Check Cheque Dates and Stale Cheques In practical bookkeeping and occasionally in exam scenarios, an unpresented cheque may remain uncashed for an extended period: - Under UK banking conventions, a cheque is legally considered **stale** after **six months** from its date of issue, and banks will routinely reject it. - If an unpresented cheque on the reconciliation schedule is older than six months, it should not remain on the bank reconciliation statement indefinitely. The bookkeeper must cancel the stale cheque by debiting the Bank column in the Cash Book and crediting the relevant supplier's account or expense account, and then reissuing a replacement cheque if the liability is still valid.What is the primary operational purpose and accounting status of the Bank Reconciliation Statement in UK bookkeeping practice?
When preparing a Bank Reconciliation Statement starting with the balance shown on the bank statement, how should unpresented cheques be treated?
The bank erroneously debits £250 from an organisation's bank account for a transaction that belongs to another commercial client. How should the bookkeeper treat this error during the bank reconciliation process?
A company's updated cash book reflects a debit balance of £8,450. Unpresented cheques total £1,620, outstanding lodgements amount to £2,150, and the bank has made no errors. What is the closing balance on the bank statement?