2.2 Control Accounts & Reconciliation Procedures

Control Accounts & Reconciliation Procedures

In business operations with hundreds or thousands of credit customers and suppliers, maintaining financial accuracy requires a robust verification system. Control accounts (also known as total accounts) serve as the primary internal check on the accuracy of the trade ledgers in the double-entry bookkeeping system.

Within the AAT Level 3 Financial Accounting: Preparing Financial Statements (FAPS) curriculum, you must master the complete double-entry mechanics of control accounts, identify the causes of discrepancies between general ledger control accounts and subsidiary ledger lists of balances, and construct professional reconciliation statements.

1. Purpose and Dual-Role of Control Accounts

A control account is a summary account situated in the General (Nominal) Ledger. It records aggregate totals of transactions rather than individual customer or supplier transactions.

┌─────────────────────────────────────────────────────────────────────────────┐
│                     CONTROL ACCOUNTS vs. SUBSIDIARY LEDGERS                 │
├──────────────────────────────────────┬──────────────────────────────────────┤
│ GENERAL LEDGER CONTROL ACCOUNTS      │ SUBSIDIARY LEDGERS (MEMORANDUM)      │
├──────────────────────────────────────┼──────────────────────────────────────┤
│ • Sales Ledger Control Account (SLCA)│ • Sales Ledger: Individual accounts  │
│   (Trade Receivables Control)        │   for every credit customer          │
│ • Purchases Ledger Control Account   │ • Purchases Ledger: Individual       │
│   (PLCA) (Trade Payables Control)    │   accounts for every credit supplier │
│ • PART of the double-entry system    │ • NOT part of double-entry (memo)    │
│ • Posted from Day Book periodic      │ • Posted daily from individual       │
│   TOTALS                             │   source documents (invoices/notes)  │
│ • Balances appear in Trial Balance   │ • Balances summed to produce the     │
│   and Statement of Financial Position│   "List of Balances" for audit check │
└──────────────────────────────────────┴──────────────────────────────────────┘

Key Functions of Control Accounts

1. Internal Check & Fraud Deterrence: By comparing the control account balance against the independent list of individual balances, errors, omissions, and unauthorized alterations are quickly detected.
2. Segregation of Duties: The general ledger control account is maintained by the senior financial accountant, while subsidiary ledgers are maintained by sales/purchase ledger clerks. This segregation prevents collusion and unauthorized balance write-offs.
3. Speed of Trial Balance Preparation: Management can extract total trade receivables and total trade payables figures immediately at month-end without waiting to total thousands of individual subsidiary ledger accounts.
4. Locating Bookkeeping Errors: When a trial balance fails to balance, comparing control account balances against subsidiary lists narrows the investigation to specific ledgers.

The Four Control Accounts Named by AAT

The FAPS specification lists four control accounts. Two are proved against a memorandum ledger; the other two are proved against independent records:

The wages and salaries control account. Payroll is posted in two stages. First the total employment cost is charged to the business: Dr Wages and Salaries Expense with gross pay plus employer's National Insurance and employer's pension contributions, and Cr Wages and Salaries Control with the same total. Then each element is paid away and debited out of the control account — net pay to the employees, PAYE and both classes of National Insurance to HMRC, and pension deductions to the scheme provider. Once every element has been settled, the wages control account balance is nil. A residual balance is diagnostic: a credit balance usually means an element has been charged but not yet paid over (commonly the month-end PAYE), while a debit balance usually means a payment was made twice or charged to the wrong account.

The VAT control account. Output VAT on sales, and on the disposal of assets, is credited to this account; input VAT on purchases, expenses and asset acquisitions is debited to it. Adjustments run through the same account: VAT on credit notes in both directions, and VAT bad debt relief (Section 7.1). A credit balance is a liability owed to HMRC and sits in current liabilities; a debit balance is an asset, a repayment due from HMRC. VAT control is therefore one of the accounts that can legitimately carry a balance on either side — see Section 8.1 — and it is proved against the VAT return for the period as part of the period-end routine in Section 2.3.

2. Double-Entry Mechanics: SLCA and PLCA

A. Sales Ledger Control Account (Trade Receivables Control)

The SLCA is an Asset account. Its normal balance is a debit, representing total debts owed to the business by credit customers.

                      SALES LEDGER CONTROL ACCOUNT (SLCA)
─────────────────────────────────────────────────────────────────────────────
Debit (Increases Receivables)          │ Credit (Decreases Receivables)
──────────────────────────────────────┼──────────────────────────────────────
Opening Balance (b/d) - Debit balances │ Opening Balance (b/d) - Credit bal*
Credit Sales (Sales Day Book total)    │ Bank / Cash receipts (Cash Book)
Dishonoured Cheques (Cash Book)        │ Discounts Allowed (Cash Book)
Interest Charged on Overdue Accounts   │ Sales Returns (Sales Returns Day Bk)
Refunds paid to overpaid customers     │ Irrecoverable Debts Written Off (GJ)
Closing Balance (c/d) - Credit balances│ Contras / Set-offs with PLCA (GJ)
                                      │ Closing Balance (c/d) - Debit balances
──────────────────────────────────────┼──────────────────────────────────────
Total Debits                           │ Total Credits
──────────────────────────────────────┴──────────────────────────────────────
* Credit opening balances represent customer overpayments or advance deposits.

Detailed Movement Descriptions for SLCA:

• Credit Sales (+ Dr): Periodic gross total from the Sales Day Book.
• Dishonoured Cheques (+ Dr): When a customer's cheque bounces, the original credit must be reversed. We reinstate the receivable (Dr SLCA) and credit Bank.
• Interest Charged (+ Dr): Penalty interest levied on overdue customer accounts (Dr SLCA, Cr Interest Income).
• Customer Refunds (+ Dr): Cash refunded to a customer who had overpaid (Dr SLCA, Cr Bank).
• Discounts Allowed (- Cr): Prompt payment cash discounts granted to credit customers (Dr Discounts Allowed SPL, Cr SLCA).
• Irrecoverable Debts (- Cr): Receivables determined to be uncollectable and written off (Dr Irrecoverable Debts Expense SPL, Cr SLCA).
• Contra / Set-Off (- Cr): Mutual indebtedness offset against the Purchases Ledger (Dr PLCA, Cr SLCA).

B. Purchases Ledger Control Account (Trade Payables Control)

The PLCA is a Liability account. Its normal balance is a credit, representing total amounts owed by the business to trade suppliers.

                    PURCHASES LEDGER CONTROL ACCOUNT (PLCA)
─────────────────────────────────────────────────────────────────────────────
Debit (Decreases Payables)             │ Credit (Increases Payables)
──────────────────────────────────────┼──────────────────────────────────────
Opening Balance (b/d) - Debit bal*     │ Opening Balance (b/d) - Credit balances
Bank / BACS Payments (Cash Book)      │ Credit Purchases (Purchases Day Book)
Discounts Received (Cash Book)        │ Interest Charged by Suppliers (GJ)
Purchases Returns (Purch Returns DB)  │ Refunds received from overpaid supp.
Contras / Set-offs with SLCA (GJ)      │ Closing Balance (c/d) - Debit balances
Closing Balance (c/d) - Credit balances│
──────────────────────────────────────┼──────────────────────────────────────
Total Debits                           │ Total Credits
──────────────────────────────────────┴──────────────────────────────────────
* Debit opening balances represent supplier overpayments or returns after full payment.

Detailed Movement Descriptions for PLCA:

• Credit Purchases (+ Cr): Periodic gross total from the Purchases Day Book.
• Supplier Interest (+ Cr): Interest charged by suppliers on late payments (Dr Finance Costs SPL, Cr PLCA).
• Supplier Refunds (+ Cr): Reversing a debit balance when a supplier repays an overpayment (Dr Bank, Cr PLCA).
• Payments to Suppliers (- Dr): Cash, cheque, or electronic bank transfers paid to suppliers (Dr PLCA, Cr Bank).
• Discounts Received (- Dr): Prompt payment cash discounts taken by our business (Dr PLCA, Cr Discounts Received SPL).
• Purchases Returns (- Dr): Periodic total of goods returned to suppliers from the Purchases Returns Day Book (Dr PLCA, Cr Purchases Returns).
• Contra / Set-Off (- Dr): Mutual indebtedness offset against the Sales Ledger (Dr PLCA, Cr SLCA).

3. Contra Entries (Set-Offs / Inter-Ledger Balances)

A contra entry (or set-off) arises when two businesses trade reciprocally with each other—meaning Business A sells goods to Business B (so B is in A's Sales Ledger), and Business A also buys goods from Business B (so B is in A's Purchases Ledger).

The Golden Rule of Contras

Instead of both parties transferring gross cash payments to each other, they agree to offset their mutual indebtedness by the LOWER of the two outstanding balances.

┌─────────────────────────────────────────────────────────────────────────────┐
│                     CONTRA ENTRY ACCOUNTING MECHANISM                       │
├─────────────────────────────────────────────────────────────────────────────┤
│ 1. Determine the smaller of the customer balance and supplier balance.      │
│ 2. Post a General Journal entry:                                            │
│       Debit:  Purchases Ledger Control Account (PLCA)   [Amount]            │
│       Credit: Sales Ledger Control Account (SLCA)       [Amount]            │
│ 3. Update the individual memorandum accounts:                               │
│       Debit:  Supplier's Account in Purchases Ledger    [Amount]            │
│       Credit: Customer's Account in Sales Ledger        [Amount]            │
└─────────────────────────────────────────────────────────────────────────────┘

Worked Example: Contra Entry

Scenario: Northern Timber owes £1,450 to Apex Supplies (in Apex's Sales Ledger). At the same time, Apex Supplies owes £900 to Northern Timber for raw timber deliveries (in Apex's Purchases Ledger). The companies agree to execute a contra settlement.

• Lower Amount: £900.
• General Journal Entry:
  • Debit: Purchases Ledger Control Account £900
  • Credit: Sales Ledger Control Account £900 (Being mutual contra set-off agreed with Northern Timber)
• Remaining Balances:
  • Northern Timber's balance in Apex's Sales Ledger = £1,450 - £900 = £550 (Debit).
  • Northern Timber's balance in Apex's Purchases Ledger = £900 - £900 = £0.00 (Settled).

4. Control Account Reconciliation Procedures

At the end of each accounting period, the balance on the Control Account must be compared with the total of the individual balances extracted from the subsidiary ledger (the List of Balances). When these two figures do not agree, a systematic reconciliation must be performed.

Error Classification Matrix

5. Comprehensive Worked Step-by-Step Reconciliation

Scenario: At 31 December 20X5, the Sales Ledger Control Account of Titan Trading Ltd showed a debit balance of £54,820. The total of the list of individual balances extracted from the Sales Ledger on the same date totaled £51,460.

Investigation revealed the following six errors and discrepancies:

1. Item 1 (Day Book Casting): The Sales Day Book total for December was overcast (overadded) by £1,200.
2. Item 2 (Transposition in Subsidiary Ledger): A credit sales invoice for £870 issued to customer H. Patel was correctly entered in the Sales Day Book but posted to Patel's personal ledger account as £780.
3. Item 3 (Omitted Dishonoured Cheque): A customer's cheque for £950 from R. Sterling was dishonoured by the bank in late December. It was correctly recorded in the Cash Book, but no entry had been made in the SLCA or Sterling's individual ledger account.
4. Item 4 (Omitted Bad Debt in SLCA): An irrecoverable debt of £640 owed by D. Vance had been written off in the General Journal and credited to Vance's individual sales ledger account, but the credit entry in the SLCA was omitted.
5. Item 5 (Contra Omission in Subsidiary Ledger): An agreed contra set-off of £500 between the sales and purchases ledgers was correctly recorded in the General Journal and posted to both control accounts, but was completely omitted from the customer's account in the Sales Ledger.
6. Item 6 (Credit Note Posting Error): A credit note of £310 issued to customer K. Lewis was correctly entered in the Sales Returns Day Book but debited instead of credited to Lewis's individual sales ledger account.

Step 1: Correcting the Sales Ledger Control Account

We determine which items affect the General Ledger SLCA:

• Item 1: SDB overcast by £1,200. This caused too much to be debited to SLCA. Credit SLCA £1,200 to correct.
• Item 3: Dishonoured cheque £950. Must reinstate the debt. Debit SLCA £950.
• Item 4: Bad debt £640 omitted from SLCA. Credit SLCA £640.

                  SALES LEDGER CONTROL ACCOUNT (ADJUSTED)
─────────────────────────────────────────────────────────────────────────────
Details                                (£) │ Details                      (£)
───────────────────────────────────────────┼─────────────────────────────────
Unadjusted Balance b/d              54,820 │ Item 1: Sales Day Book overcast 1,200
Item 3: Dishonoured Cheque (Sterling)  950 │ Item 4: Irrecoverable Debt (Vance) 640
                                           │ Corrected Balance c/d         53,930
───────────────────────────────────────────┼─────────────────────────────────
                                    55,770 │                               55,770
───────────────────────────────────────────┴─────────────────────────────────
Corrected Balance b/d               53,930

Step 2: Reconciling the List of Individual Balances

We determine which items affect the individual memorandum accounts in the Sales Ledger:

• Original List Total: £51,460
• Item 2: Invoice £870 posted as £780. Customer undercharged by £90 (£870 - £780). Add £90.
• Item 3: Dishonoured cheque £950 omitted from customer account. Add £950.
• Item 5: Contra £500 omitted from customer account. Deduct £500.
• Item 6: Credit note of £310 was debited instead of credited. Lewis's balance is overstated by double the amount (£620). Deduct £620.

                RECONCILIATION OF INDIVIDUAL SALES LEDGER BALANCES
                          AT 31 DECEMBER 20X5
─────────────────────────────────────────────────────────────────────────────
                                                                          (£)
Original Total of List of Individual Balances                          51,460

Additions:
  Item 2: Transposition correction on H. Patel account (£870 - £780)       90
  Item 3: Dishonoured cheque reinstated on R. Sterling account            950
                                                                      ───────
Subtotal                                                               52,500

Deductions:
  Item 5: Contra set-off omitted from customer account                  (500)
  Item 6: Correction of credit note wrongly debited to K. Lewis (£310 x 2)(620)
                                                                      ───────
Adjusted Total of Individual Balances                                  53,930
═════════════════════════════════════════════════════════════════════════════

Step 3: Verification

Both the Adjusted Sales Ledger Control Account Balance (£53,930) and the Adjusted List of Individual Balances (£53,930) now agree perfectly. The audited figure of £53,930 is the correct Trade Receivables figure to be reported on the Statement of Financial Position.

6. Summary Checklist for Control Account Audits

┌─────────────────────────────────────────────────────────────────────────────┐
│                     CONTROL ACCOUNT TROUBLESHOOTING GUIDE                   │
├─────────────────────────────────────────────────────────────────────────────┤
│ 1. Did the error occur in a Day Book TOTAL?                                 │
│    ➜ Adjust the Control Account only.                                       │
│ 2. Did the error occur when posting to a PERSONAL ACCOUNT?                  │
│    ➜ Adjust the Subsidiary List of Balances only.                           │
│ 3. Was a transaction omitted from BOTH the Day Book and Personal Account?   │
│    ➜ Adjust BOTH the Control Account and the Subsidiary List of Balances.   │
│ 4. Was an entry debited instead of credited in a personal account?          │
│    ➜ Correct the List of Balances by DOUBLE the transaction amount.         │
│ 5. Is there a Contra / Set-Off?                                             │
│    ➜ Debit PLCA and Credit SLCA by the LOWER of the two balances.           │
└─────────────────────────────────────────────────────────────────────────────┘