AAT L3 Cheat Sheet 2026

The 30 highest-yield AAT L3 facts, distilled from real exam questions. Print it, save it as a PDF, or study it here — free, no sign-up.

1. If selling price is £20 per unit, variable cost is £12 per unit, and fixed costs are £40,000, the breakeven point in units is: → 5,000 units
2. Accrued expenses at the year end are recorded as: → Debit expense account, Credit accruals (liability)
3. The revaluation reserve in a limited company balance sheet arises from: → An upward revaluation of non-current assets
4. In Microsoft Excel, which function calculates the sum of a range of cells that meet a specified condition? → SUMIF
5. Which Excel function returns the largest value from a range? → MAX
6. Continuing Professional Development (CPD) is important for accountants because: → It ensures knowledge remains current, supporting the principle of professional competence
7. An accountant is asked to produce a cash flow forecast in Excel. To ensure the forecast updates automatically when assumptions change, the accountant should: → Link all forecast outputs to clearly labelled assumption input cells using formulas
8. The Excel NETWORKDAYS function calculates: → The number of working days (excluding weekends and optionally holidays) between two dates
9. Which Excel function looks up a value in the first row of a range and returns a value from a specified row below it? → HLOOKUP
10. Which of the following describes the purpose of the nominal (general) ledger? → To contain all accounts used to prepare the trial balance and financial statements
11. When a credit note is issued to a customer for goods returned, the double entry is: → Debit Sales Returns, Credit Trade Receivables
12. In Excel, a macro is used to: → Record and replay a sequence of actions, automating repetitive tasks
13. The contribution per unit is calculated as: → Selling price minus variable cost per unit
14. When the Bank of England increases the base interest rate, what is the MOST likely direct impact on businesses with variable-rate loans? → Their interest repayments will increase
15. Which fundamental principle is MOST directly threatened when an accountant provides tax planning advice that they are not technically qualified to give? → Professional competence and due care
16. The going concern concept means financial statements are prepared on the assumption that: → The business will continue trading for the foreseeable future
17. When is a business required to compulsorily register for VAT? → When taxable turnover in the previous 12 months has exceeded the registration threshold
18. When actual overheads exceed overheads absorbed, the result is: → Under-absorption
19. Which Excel chart type is most appropriate for showing trends over time? → Line chart
20. An accountant who agrees with a client's aggressive accounting treatment just to avoid conflict is exhibiting: → Lack of objectivity — allowing personal comfort to override professional judgement
21. The Excel TEXT function is used to: → Format a number as text with a specified format
22. For a limited company, retained earnings brought forward plus profit for the year minus dividends paid equals: → Retained earnings carried forward
23. A business intending to make only exempt supplies should: → Not register for VAT as it cannot reclaim input VAT
24. Which feature in Excel allows you to protect the formulas in a spreadsheet from being accidentally changed? → Sheet protection (with locked cells)
25. Depreciation for the year is treated in the final accounts as: → An expense in the income statement
26. A business fails to submit its VAT return by the deadline. Under the new penalties regime, what is the consequence for a first late submission? → A penalty point is recorded but no financial penalty is immediately charged
27. The overhead absorption rate (OAR) is calculated as: → Budgeted overheads / Budgeted activity level
28. For a partly business, partly private use asset, a business can recover VAT on: → Only the business use proportion of the VAT
29. If no formal partnership agreement exists in a UK business partnership, which legislation provides the default rules governing the partners' rights? → Partnership Act 1890
30. A prepayment is classified in the balance sheet as: → A current asset