4.4 Extracting & Validating VAT Data from the Accounting System
Key Takeaways
- The VAT return must be built from the accounting records for the exact prescribed accounting period, using tax point dates rather than posting dates or payment dates.
- Extracted figures must be traceable back to original, verified source documents — sales and purchase invoices, credit notes, till records, bank statements and import statements.
- Accounting software reduces error by validating VAT codes, flagging missing supplier VAT numbers and preventing input tax being claimed on transactions coded as blocked or exempt.
- Reconciling the VAT return to the accounting records is a required check: differences must be explained, not simply overwritten.
- The most common causes of a return-to-ledger difference are timing cut-off, manual journals posted without a VAT code, and adjustments such as fuel scale charges made outside the ledger.
4.4 Extracting & Validating VAT Data from the Accounting System
The scope of content for "Calculate VAT" opens not with a calculation but with a data question: which records, for which period, and how do you know the figures are right? Sub-topic 2.1 asks you to identify relevant sources of VAT information, identify the accounting records covering the period of the return, extract the revenue, expenditure and VAT figures, validate that they came from original and verified source documents, and understand the benefits of accounting software in identifying errors. Learning outcome 3 then adds the reconciliation. This section covers all of it.
1. Sources of VAT Information
There are two different meanings of "source", and the assessment uses both.
A. Sources of the rules
| Source | What it gives you |
|---|---|
| HMRC VAT Notices (e.g. Notice 700 — the VAT Guide) | The operational rules HMRC applies, with the force of law in parts |
| GOV.UK guidance pages | Current thresholds, rates and deadlines |
| VATA 1994 and the VAT Regulations 1995 | The underlying legislation |
| HMRC internal manuals | HMRC's own detailed interpretation |
| AAT reference material | The specific rates and tables supplied in the assessment |
| The VAT helpline and the business's own adviser | Escalation route for anything genuinely uncertain |
B. Sources of the figures
| Source | Feeds |
|---|---|
| Sales day book / sales invoices issued | Box 1 output tax, Box 6 net sales |
| Purchase day book / purchase invoices received | Box 4 input tax, Box 7 net purchases |
| Credit notes issued and received | Reductions to Boxes 1/6 and 4/7 |
| Cash book and petty cash records | Output tax on cash sales, input tax on small purchases |
| Till rolls / daily gross takings | Retail output tax |
| Bank statements | Verification and cash-accounting tax points |
| Postponed import VAT statements and C79 certificates | Import VAT in Boxes 1, 4 and 7 |
| Fixed asset register | Capital purchases, deregistration assets, FRS £2,000 capital claims |
| Fuel scale charge table and vehicle records | Box 1 scale charge adjustment |
| Bad debt / refunds for bad debts account | Box 4 bad debt relief |
2. Identifying the Right Period
A VAT return covers a prescribed accounting period, and the boundary of that period is set by tax points, not by when a transaction happened to be posted. Three distinctions matter:
- Tax point vs posting date. An invoice with a 29 June tax point posted on 4 July belongs in the June return. Extracting on posting date silently moves it to the next quarter.
- Tax point vs payment date. Under standard accounting the payment date is irrelevant. Under cash accounting the payment date is the tax point, so the extraction is driven by the cash book instead.
- The stagger. A business's quarters may not be calendar quarters. Always confirm the period ends from the VAT registration details before running the report.
Practical control: run the VAT report on tax point date, then run a second report for transactions posted after the period end with a tax point inside it. Anything that appears in the second report but not the first is a cut-off error.
3. Extracting the Figures
For each transaction you need four data items — the tax point, the net value, the VAT rate, and the VAT amount. These are also, not coincidentally, the items MTD requires to be held digitally.
A disciplined extraction routine looks like this:
- Run the VAT return report from the software for the correct period and correct basis (accruals or cash).
- Print or export the detailed transaction listing behind each box, not just the summary.
- Separate out the transactions that need a manual adjustment — fuel scale charges, bad debt relief, partial exemption restrictions, error corrections from earlier periods.
- Post those adjustments through the VAT account so the ledger and the return stay in step.
- Re-run the report and confirm the boxes have moved by exactly the amounts adjusted.
4. Validating the Data
Extraction is not the same as verification. The scope of content specifically requires you to determine that the figures extracted have come from original and verified source documents. In practice that means five checks.
| Check | What you are testing | Typical failure |
|---|---|---|
| Existence | Is there an original invoice or receipt behind the entry? | Input tax claimed from a supplier statement or a bank line |
| Validity | Does the document meet the VAT invoice requirements? | No supplier VAT number, or no tax point |
| Accuracy | Do net, rate and VAT agree arithmetically? | VAT posted as 20% of a gross figure |
| Classification | Is the VAT code right for the supply? | Exempt insurance coded as zero-rated; blocked entertaining coded as recoverable |
| Ownership | Is the invoice addressed to the business? | Invoice in a director's own name |
A sensible approach is to test all high-value items and a sample of the rest, focusing the sample on the risky categories: motor expenses, entertaining, professional fees, anything with an unfamiliar supplier, and anything coded at a rate other than 20%.
5. How Accounting Software Helps — and Where It Does Not
What software does well
- Applies the right rate consistently once a supplier or nominal code carries a default VAT code.
- Validates VAT registration numbers, often against HMRC's checking service, so an invalid number is caught before the input tax is claimed.
- Flags impossible arithmetic, such as VAT that is not the expected proportion of the net value.
- Blocks recovery on coded categories, so entertaining posted to the right nominal code never reaches Box 4.
- Maintains the digital links required by MTD and files the return through HMRC's API, removing transcription error entirely.
- Produces the detailed listings that make the checks in section 4 possible in the first place.
What software cannot do
Software applies the code it is given. It cannot tell that a supply of training was actually exempt, that a car was bought with private use, that a zero-rated export has no proof of export, or that a supplier's "VAT" line was charged in error by a business that is not registered. A wrong code applied consistently produces a consistently wrong return. That is why the human validation step survives automation.
6. Reconciling the Return to the Accounting Records
Before submission, the return must agree to the ledger, and any difference must be explained.
VAT Return to Ledger Reconciliation
===================================================================
Balance on VAT control account at period end £X,XXX
Add: Output tax adjustments posted outside the ledger
(fuel scale charges, deemed supplies) £XXX
Less: Input tax not yet claimed
(invoices awaiting valid VAT documentation) (£XXX)
Add: Prior period error corrections included on this return £XXX
Less: Input tax restricted by partial exemption (£XXX)
-------------------------------------------------------------------
Reconciled figure — must equal Box 5 £X,XXX
===================================================================
The usual causes of a difference
| Cause | How to identify it |
|---|---|
| Cut-off — invoices posted after the period end with a tax point inside it | Compare tax point report to posting date report |
| Manual journals with no VAT code | List journals touching the VAT control account |
| Adjustments made on the return but not in the ledger | Check the fuel scale charge and bad debt entries |
| Cash accounting timing | The ledger is on invoices; the return is on cash |
| Partial exemption restriction | Recovery percentage applied on the return only |
| Payments to HMRC posted to the wrong period | Review the control account debits |
An unexplained difference is a stop signal. Overwriting the ledger to force agreement with the return, or vice versa, destroys the audit trail and is exactly what an HMRC officer looks for.
7. Worked Example
Scenario: Alderway Trading Ltd files quarterly returns to 30 June 2026. The software's VAT report shows Box 1 £41,300 and Box 4 £26,800, giving Box 5 of £14,500. The VAT control account shows a credit balance of £13,900.
Investigation finds:
- A fuel scale charge of £43.50 was added directly to the return but never journalled to the ledger.
- Two purchase invoices dated 27 June, totalling £2,700 net plus £540 VAT, were posted on 6 July and are in the ledger but not in the return.
- A manual journal of £16.50 was posted to the VAT control account to clear a rounding difference, with no VAT code.
Reconciliation:
| £ | |
|---|---|
| VAT control account credit balance | 13,900.00 |
| Add: fuel scale charge on the return, not in the ledger | 43.50 |
| Add: input tax posted to the ledger but not yet on the return | 540.00 |
| Add: unexplained manual journal | 16.50 |
| Reconciled to Box 5 | 14,500.00 |
Actions before filing: journal the £43.50 scale charge into the ledger; correct the cut-off so the £540 of input tax is claimed on the June return (its tax point is 27 June); and investigate the £16.50 journal rather than leaving it as a plug. Only then submit.
When extracting figures for a standard-basis VAT return, which date should determine whether a transaction belongs in the period?
Which of these is a genuine limitation of relying on accounting software to produce a correct VAT return?
A VAT return shows Box 5 of £14,500 but the VAT control account shows £13,900. Which of the following is the correct response?
Which check confirms that input tax claimed came from a valid original source document?