8.2 Recording Adjustments & Completing the Extended Trial Balance

Recording Adjustments & Completing the Extended Trial Balance

In modern accounting practice, financial statements are rarely drafted directly from the raw nominal ledger. Between the extraction of the initial trial balance and the publication of final statutory statements, multiple year-end accounting adjustments must be calculated, recorded, and verified.

The Extended Trial Balance (ETB) is an essential accounting working paper that provides a structured, transparent mechanism to integrate period-end adjustments with initial ledger balances, compute the draft profit or loss for the year, and produce perfectly balanced inputs for the Statement of Profit or Loss (SPL) and the Statement of Financial Position (SFP).

---

1. Architecture of the Extended Trial Balance

The standard Extended Trial Balance comprises an 8-column layout organized into four matched pairs of Debit and Credit columns:

┌──────────────────────────────────────────────────────────────────────────────────────────────────┐
│                            THE 8-COLUMN EXTENDED TRIAL BALANCE STRUCTURE                         │
├────────────────────┬───────────────────┬─────────────────────────────┬───────────────────────────┤
│ 1. TRIAL BALANCE   │ 2. ADJUSTMENTS    │ 3. STATEMENT OF PROFIT/LOSS │ 4. STATEMENT OF FIN. POS. │
│    Dr (£)   Cr (£) │    Dr (£)  Cr (£) │    Dr (£)            Cr (£) │    Dr (£)          Cr (£) │
├────────────────────┼───────────────────┼─────────────────────────────┼───────────────────────────┤
│ Unadjusted nominal │ Year-end accruals,│ Operating expenses, cost of │ Non-current & current     │
│ ledger balances    │ prepayments, dep'n│ sales, and revenue items    │ assets, liabilities, and  │
│ extracted from the │ closing inventory,│ used to calculate Profit or │ owner's capital/drawings  │
│ general ledger.    │ error corrections.│ Loss for the period.        │ at the reporting date.    │
└────────────────────┴───────────────────┴─────────────────────────────┴───────────────────────────┘

Primary Advantages of Using an ETB

1. Error Prevention: Ensures every period-end adjustment satisfies double-entry rules before financial statements are formally drafted.
2. Audit Trail: Provides a clear, documented link between unadjusted general ledger accounts and final published figures.
3. Flexibility: Enables accountants to draft and review financial statements before posting formal year-end closing journal entries into the nominal ledger.
4. Immediate Balancing Check: Arithmetically proves that the draft profit for the year correctly balances the Statement of Financial Position.

---

2. Standard Period-End Adjustments on the ETB

When preparing the ETB, adjustments are entered in the Adjustments Dr and Adjustments Cr columns against existing account lines or newly created adjustment lines at the bottom of the schedule.

┌──────────────────────────────────────────────────────────────────────────────────────────────────┐
│                             MASTER PERIOD-END ADJUSTMENTS ON THE ETB                             │
├──────────────────────────┬───────────────────────────────────────┬───────────────────────────────┤
│ Adjustment Type          │ Debit Entry (Dr)                      │ Credit Entry (Cr)             │
├──────────────────────────┼───────────────────────────────────────┼───────────────────────────────┤
│ 1. Accrued Expense       │ Expense Account (SPL)                 │ Accruals (SFP Liability)      │
│ 2. Prepaid Expense       │ Prepayments (SFP Asset)               │ Expense Account (SPL)         │
│ 3. Accrued Income        │ Accrued Income (SFP Asset)            │ Income Account (SPL)          │
│ 4. Deferred Income       │ Income Account (SPL)                  │ Deferred Income (SFP Liab)    │
│ 5. Closing Inventory     │ Closing Inventory (SFP Asset)         │ Closing Inventory (SPL Cost)  │
│ 6. Depreciation Charge   │ Depreciation Expense (SPL)            │ Accumulated Depreciation(SFP) │
│ 7. Irrecoverable Debt    │ Irrecoverable Debts Expense (SPL)     │ Trade Receivables (SFP Asset) │
│ 8. Allowance Increase    │ Irrecoverable Debts Expense (SPL)     │ Allowance for Doubtful (SFP)  │
│ 9. Allowance Decrease    │ Allowance for Doubtful (SFP)          │ Irrec Debts Expense (SPL)     │
│ 10. Correction of Errors │ Account understated (SPL or SFP)      │ Account overstated / Suspense │
│ 11. NCA Disposal (Cost)  │ Disposals Account                     │ NCA at Cost (SFP)             │
│ 12. NCA Disposal (Depn)  │ Accumulated Depreciation (SFP)        │ Disposals Account             │
│ 13. Part-Exchange Allow. │ NCA Supplier / Payables (SFP)         │ Disposals Account             │
└──────────────────────────┴───────────────────────────────────────┴───────────────────────────────┘

**The eight adjustments AAT names.** The FAPS specification lists exactly which adjustments must be placed correctly into the adjustments columns so that the adjusted trial balance still balances: closing inventory; accruals of income or expenses; prepayments of income or expenses; **corrections of errors**; depreciation; irrecoverable debts; allowances for doubtful receivables; and **disposals of non-current assets, including part-exchange**. The last two are the ones candidates most often forget are ETB items at all.

* **Corrections of errors** enter the adjustments columns exactly as they would enter the general journal (Section 3.2). Where the error created a trial balance imbalance, the suspense account appears as a line in the trial balance columns and is cleared by the adjustment, so it must extend to **neither** the SPL nor the SFP columns — a suspense balance still showing after the adjustments means an error remains unresolved.
* **Disposals** occupy three adjustment lines: cost out of the asset account, accumulated depreciation out of the depreciation account, and the proceeds or part-exchange allowance in. The resulting balance on the disposals account is the profit or loss on disposal, and it extends to the **SPL** columns — a credit balance to SPL credit (profit on disposal) or a debit balance to SPL debit (loss on disposal). Note that the disposals account is one of the accounts that can carry a balance on either side (Section 8.1).

Critical Rule for Closing Inventory

Unlike all other trading accounts, Closing Inventory does not appear on the initial Trial Balance because it is determined via physical inventory count at the close of business on the reporting date. On the ETB, closing inventory is introduced via the Adjustments columns:

• Debit: Closing Inventory line in the SFP column (representing the asset owned at year-end).
• Credit: Closing Inventory line in the SPL column (deducted from cost of goods available for sale to calculate Cost of Sales).

---

3. Horizontal Extension Rules across Columns

Once all adjustments are entered, verify that Total Adjustment Debits = Total Adjustment Credits. Then, extend every nominal line horizontally into either the SPL or SFP columns according to the following mathematical rules:

Arithmetic Combining Rules

• Debit Balance + Debit Adjustment = Extended as larger Debit.
• Debit Balance − Credit Adjustment = Extended as net Debit (or net Credit if adjustment exceeds balance).
• Credit Balance + Credit Adjustment = Extended as larger Credit.
• Credit Balance − Debit Adjustment = Extended as net Credit (or net Debit if adjustment exceeds balance).

Destination Allocation Matrix

---

4. Calculating and Transferring the Profit or Loss for the Year

Once all nominal lines are extended into the SPL and SFP columns, the final balancing procedure is executed:

┌─────────────────────────────────────────────────────────────────────────────┐
│                     PROFIT BALANCING MECHANICS ON THE ETB                   │
├─────────────────────────────────────────────────────────────────────────────┤
│ 1. Cast the SPL Columns:                                                    │
│    • Sum SPL Credits (Total Revenues + Closing Inventory)                   │
│    • Sum SPL Debits  (Total Expenses + Cost of Sales)                       │
│                                                                             │
│ 2. Compute Net Profit / Loss:                                               │
│    • Net Profit = Total SPL Credits − Total SPL Debits                      │
│                                                                             │
│ 3. Insert the Balancing Entry:                                              │
│    • If NET PROFIT (Credits > Debits):                                      │
│      ► Enter Profit in SPL DEBIT Column  (equalizes SPL Dr and Cr)          │
│      ► Enter Profit in SFP CREDIT Column (increases Owner's Equity)         │
│                                                                             │
│    • If NET LOSS (Debits > Credits):                                        │
│      ► Enter Loss in SPL CREDIT Column (equalizes SPL Dr and Cr)            │
│      ► Enter Loss in SFP DEBIT Column  (reduces Owner's Equity)             │
│                                                                             │
│ 4. Cast and Verify SFP Columns:                                             │
│    • Total SFP Debits MUST equal Total SFP Credits!                         │
└─────────────────────────────────────────────────────────────────────────────┘

---

5. Comprehensive Master ETB Case Study: Orion Retailers

To master the complete construction of an Extended Trial Balance, analyze the end-of-year accounting records of Orion Retailers (a sole proprietorship) for the financial year ended 31 December 20X5.

Year-End Adjustment Schedule at 31 December 20X5:

1. Closing Inventory: Physical inventory count on 31 December 20X5 valued at cost per IAS 2 is £25,000.
2. Depreciation: Plant & Equipment is depreciated at 10% per annum on cost using the straight-line method. Cost is £50,000; depreciation charge = 10% x £50,000 = £5,000.
3. Irrecoverable Debt: An irrecoverable customer debt of £2,000 is to be written off from Trade Receivables.
4. Allowance for Doubtful Receivables: The allowance is to be adjusted to 5% of remaining trade receivables.
   • Adjusted receivables = £34,000 - £2,000 = £32,000.
   • Required allowance = 5% x £32,000 = £1,600.
   • Existing allowance in Trial Balance = £1,000.
   • Increase required in SPL = £1,600 - £1,000 = £600.
5. Rates Prepayment: Local authority business rates included in Rent & Rates prepaid at year-end amount to £2,000.
6. Electricity Accrual: Estimated unbilled electricity consumed in Nov–Dec 20X5 amounts to £1,200.

Master 18-Line Extended Trial Balance Table

---

Step-by-Step Mathematical Verification of Orion Retailers ETB

1. Trial Balance Columns:
   • Total Debits = £18,000 + £120,000 + £50,000 + £22,000 + £34,000 + £9,500 + £110,000 + £2,500 + £16,000 + £8,000 + £42,000 + £7,000 = £439,000
   • Total Credits = £157,000 + £15,000 + £1,000 + £26,000 + £240,000 = £439,000
2. Adjustments Columns:
   • Total Debits = £1,200 + £2,000 + £600 + £5,000 + £2,000 + £25,000 = £35,800
   • Total Credits = £5,000 + £2,000 + £600 + £2,000 + £1,200 + £25,000 = £35,800
3. Statement of Profit or Loss (SPL):
   • Total Credits (Revenue + Closing Inventory) = £240,000 + £25,000 = £265,000
   • Total Debits (Cost of Sales + Expenses) = £22,000 + £110,000 + £2,500 + £14,000 + £9,200 + £42,000 + £7,000 + £2,000 + £600 + £5,000 = £214,300
   • Profit for the Year = £265,000 - £214,300 = £50,700
   • Balancing Entry: Insert £50,700 in SPL Debit (bringing Total SPL Debits to £265,000).
4. Statement of Financial Position (SFP):
   • Total SFP Debits = £18,000 + £120,000 + £50,000 + £32,000 + £9,500 + £2,000 + £25,000 = £256,500
   • Total SFP Credits (before profit) = £157,000 + £20,000 + £1,600 + £26,000 + £1,200 = £205,800
   • Final SFP Credits (including Profit) = £205,800 + £50,700 = £256,500
   • Arithmetical agreement: Total SFP Debits (£256,500) = Total SFP Credits (£256,500).

---

6. The ETB for Sole Traders and for Partnerships

AAT requires you to understand how the extended trial balance differs between a sole trader and a partnership, but the FAPS specification explicitly excludes completing an ETB for a partnership from assessment. Know the difference; practise the completion for sole traders only.

The practical consequence is that a partnership's profit figure leaves the extended trial balance and enters the appropriation account. That is why partnership tasks in the assessment start from a stated profit for the year rather than from an extended trial balance, and why the ETB you will be asked to complete will always be that of a sole trader.

---

7. Key Exam Traps and Best Practice Rules

• Trap 1: Misplacing Profit on the ETB: Remember that Net Profit is a credit balance (increase in equity). On the ETB, it is placed in the SPL Debit column (to balance the statement) and the SFP Credit column (to increase capital). Inverting these will double the error (£101,400 imbalance).
• Trap 2: Forgetting to Adjust Receivables before Calculating Allowance: The percentage allowance for doubtful receivables must be calculated on the net receivables figure after deducting irrecoverable debts written off (£32,000, not £34,000).
• Trap 3: Omitting Closing Inventory from either SPL or SFP: Closing inventory must always appear twice: as a Credit in SPL (deducted from cost of sales) and as a Debit in SFP (Current Asset).