4.3 Updating the Cash Book for Non-Timing Items

4.3 Updating the Cash Book for Non-Timing Items

The Two-Phase Reconciliation Framework

A bank reconciliation is not a single, isolated calculation; it is a structured, two-phase accounting protocol:

• Phase 1: Update the Cash Book (Internal Ledger Adjustment): Incorporate all previously unrecorded genuine transactions discovered on the bank statement into the business's accounting system and balance off the account.
• Phase 2: Prepare the Bank Reconciliation Statement (External Reconciling Statement): Reconcile the updated Cash Book balance against the Bank Statement closing balance by adjusting for uncleared timing differences (unpresented cheques and outstanding lodgements) and any uncorrected bank errors.

=========================================================================================
                      THE TWO-PHASE BANK RECONCILIATION PROTOCOL
=========================================================================================
                       PHASE 1: UPDATE THE CASH BOOK
  [Unadjusted Cash Book Balance] 
             +
  [Bank Statement Receipts (BACS, Interest)] 
             -
  [Bank Statement Payments (Charges, DD, SO, Dishonoured Cheques)]
             =
  [ADJUSTED CASH BOOK BALANCE b/d]  <--- True, verified cash asset/liability
                                          reported on the Trial Balance & Balance Sheet
-----------------------------------------------------------------------------------------
                 PHASE 2: PREPARE BANK RECONCILIATION STATEMENT
  [Adjusted Cash Book Balance b/d] 
             +
  [Unpresented Cheques] 
             -
  [Outstanding Lodgements] 
             +/-
  [Bank Processing Errors]
             =
  [CLOSING BALANCE PER BANK STATEMENT] <--- Reconciles with external bank statement
=========================================================================================

Attempting to prepare the Bank Reconciliation Statement before updating the Cash Book is a fundamental bookkeeping error. Until the Cash Book is brought up to date, the general ledger is incomplete, financial statements will misstate cash and expenses, and the trial balance will fail to reflect current trading liabilities.

Rules for Updating the Cash Book

Updating the Cash Book follows strict double-entry conventions:

1. Bring Down the Starting Balance: Begin the updated account by entering the unadjusted closing balance as the opening balance brought down (balance b/d):
   • If the cash book was in credit/positive funds: enter as a Debit balance b/d.
   • If the cash book was overdrawn: enter as a Credit balance b/d.
2. Post Receipts to the DEBIT Side: Any valid transaction that increases the cash held in the bank account is entered in the debit (receipts) column.
3. Post Payments to the CREDIT Side: Any valid transaction or bank deduction that reduces the cash held in the bank account is entered in the credit (payments) column.
4. Balance Off the Account: Total both sides, calculate the closing balance carried down (balance c/d), insert it on the smaller side to balance the columns, and bring it down to the opposite side as the corrected balance b/d for the start of the next period.

Detailed Analysis of Adjusting Entries and Double Entry

1. Debit Entries: Receipts Discovered on the Bank Statement

• Direct Credits / BACS Customer Receipts: Credit customers frequently settle outstanding sales invoices by direct electronic bank transfer without immediately dispatching a remittance advice. When these appear on the statement: \textbf{Debit:} & \text{Bank (Cash Book Receipts Column)} & £X \\ \textbf{Credit:} & \text{Receivables Ledger Control Account (RLCA)} & £X \end{array}$$ *(The customer's individual account in the subsidiary Receivables Ledger is also credited line-by-line).*
• Bank Interest Received (Interest Allowed): Surplus funds in business deposit or current accounts earn credit interest: \textbf{Debit:} & \text{Bank (Cash Book Receipts Column)} & £X \\ \textbf{Credit:} & \text{Bank Interest Received (Nominal Income Account)} & £X \end{array}$$
• Dividends and Investment Returns: Income received from corporate investments or government bonds deposited directly: \textbf{Debit:} & \text{Bank (Cash Book Receipts Column)} & £X \\ \textbf{Credit:} & \text{Investment Income Account} & £X \end{array}$$

2. Credit Entries: Payments Discovered on the Bank Statement

• Bank Charges and Service Fees: Administrative costs, monthly account management fees, CHAPS charges, or foreign exchange fees: \textbf{Debit:} & \text{Bank Charges Account (Nominal Expense)} & £X \\ \textbf{Credit:} & \text{Bank (Cash Book Payments Column)} & £X \end{array}$$
• Overdraft and Loan Interest Paid: Financing costs charged by the bank on borrowed money or credit facilities: \textbf{Debit:} & \text{Interest Paid / Finance Charges (Expense)} & £X \\ \textbf{Credit:} & \text{Bank (Cash Book Payments Column)} & £X \end{array}$$
• Standing Orders Paid: Pre-authorized fixed disbursements such as commercial rent, rates, or loan installments: \textbf{Debit:} & \text{Rent Account / Relevant Nominal Expense} & £X \\ \textbf{Credit:} & \text{Bank (Cash Book Payments Column)} & £X \end{array}$$
• Direct Debits Paid: Variable recurring utility charges or supplier accounts settled automatically: \textbf{Debit:} & \text{Light and Heat / Telephone / Payables Ledger Control} & £X \\ \textbf{Credit:} & \text{Bank (Cash Book Payments Column)} & £X \end{array}$$
• Merchant Service Charges (Card Terminal Fees): Acquirer fees deducted for card transaction processing: \textbf{Debit:} & \text{Merchant Fees Account (Administrative Expense)} & £X \\ \textbf{Credit:} & \text{Bank (Cash Book Payments Column)} & £X \end{array}$$

3. Special Case: Dishonoured Cheques (Reversing Customer Receipts)

When a customer pays by cheque, the business enters the receipt immediately in its books:

Comprehensive Worked Example: Updating Cresta Supplies' Cash Book

Scenario Data

On 31 October 2026, the bookkeeper at Cresta Supplies balances the Cash Book and establishes an unadjusted debit balance of £3,450 in the bank column.

A detailed line-by-line comparison of the October Bank Statement against the Cash Book reveals the following five non-timing transactions appearing on the bank statement that have not yet been recorded in internal records:

1. Standing Order: A regular monthly payment of £250 for commercial building insurance was paid by the bank on 28 October.
2. Direct Debit: A variable monthly direct debit of £180 for warehouse electricity was drawn by PowerGrid UK on 29 October.
3. Bank Charges: Monthly bank service fees and account ledger maintenance charges totaling £45 were deducted on 31 October.
4. Customer BACS Receipt: A credit customer, Oak Ltd, transferred £1,200 directly into Cresta Supplies' bank account via BACS on 30 October in full settlement of invoice #OL-882.
5. Dishonoured Cheque: A cheque for £320 received from customer Pine & Co and lodged on 24 October was returned unpaid by the drawer's bank marked "Refer to Drawer" on 30 October.

Mathematical Step-by-Step Calculation

1. Starting Position: Initial Debit Balance = £3,450
2. Calculate Total Additions (Receipts to Debit):
   • Customer BACS Receipt (Oak Ltd): +£1,200 $\text{Total Debit Pool} = \pounds3,450 + \pounds1,200 = \mathbf{\pounds4,650}$
3. Calculate Total Deductions (Payments to Credit):
   • Standing Order (Insurance): £250
   • Direct Debit (Electricity): £180
   • Bank Charges: £45
   • Dishonoured Cheque (Pine & Co): £320 $\text{Total Payments Pool} = \pounds250 + \pounds180 + \pounds45 + \pounds320 = \mathbf{\pounds795}$
4. Calculate the Adjusted Cash Book Balance: $\text{Adjusted Cash Book Balance} = \pounds4,650 - \pounds795 = \mathbf{\pounds3,855} \text{ (Debit Balance)}$

The Formatted Cash Book (Bank Columns)

                                    CRESTA SUPPLIES
                               Cash Book (Bank Columns)
=========================================================================================
Date    Details             Amount (£) | Date    Details             Amount (£)
=========================================================================================
31 Oct  Balance b/d              3,450 | 31 Oct  Standing Order            250
        (Unadjusted)                   |         (Insurance)                   
31 Oct  Oak Ltd (BACS)           1,200 | 31 Oct  Direct Debit              180
                                       |         (PowerGrid UK)                
                                       | 31 Oct  Bank Charges               45
                                       | 31 Oct  Pine & Co                 320
                                       |         (Dishonoured Cheque)          
                                       | 31 Oct  Balance c/d             3,855
---------------------------------------|-----------------------------------------
Total                            4,650 | Total                           4,650
=========================================================================================
01 Nov  Balance b/d              3,855 |
        (Adjusted)

General Ledger Double-Entry Audit Trail

To ensure full accounting integrity across the general ledger, the five adjustments generate the following double-entry postings:

=========================================================================================
                              GENERAL LEDGER POSTING SUMMARY
=========================================================================================
Transaction                   Account to Debit             Account to Credit
-----------------------------------------------------------------------------------------
1. Standing Order (£250)      Insurance Expense            Bank (Cash Book)
2. Direct Debit (£180)        Light & Heat Expense         Bank (Cash Book)
3. Bank Charges (£45)         Bank Charges Expense         Bank (Cash Book)
4. BACS Receipt (£1,200)      Bank (Cash Book)             Receivables Ledger Control (Oak Ltd)
5. Bounced Cheque (£320)      Receivables Ledger Control         Bank (Cash Book)
                              (Pine & Co)
=========================================================================================

Final Destination of the Adjusted Balance

The corrected closing figure of £3,855 is now:

1. The true, verified bank asset balance reported on Cresta Supplies' Trial Balance.
2. The authoritative starting figure used to prepare the Phase 2 Bank Reconciliation Statement, where it will be compared against the external Bank Statement balance after reconciling unpresented cheques and outstanding lodgements.