How to review a VAT return prepared by software: what tax advisors should ask for
When software or an agent prepares the VAT return, the arithmetic is rarely the risk. A review routine for Dutch BTW and UK VAT returns, and the evidence pack to ask for.
David van Duijn6 min read
Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.
On this page
To review a VAT return prepared by software, check the inputs rather than the arithmetic: tie every box to the ledger, reconcile the VAT control account, test how transactions were coded, and read the list of exceptions and manual overrides. Ask the client or the provider for that evidence as a standard pack, so every return gets the same review.
If you are a tax advisor, more of the returns on your desk are now prepared by software, and increasingly by agents that code transactions and fill the return without a bookkeeper in between. That changes where the risk sits. Addition errors are rare. What goes wrong is the classification of individual transactions, missing transactions, and judgement calls made silently by a rule.
Your review should follow the risk.
What changes when software prepares the return?
A traditional review often starts from the return and works back to the bookkeeping. With software-prepared returns it is more efficient to go the other way: start from how the system decided, then look at what it produced.
Three questions do most of the work:
- Is the population complete? Every bank line, sales invoice and purchase invoice for the period should be in the ledger, and the ledger should tie to the bank.
- Were transactions coded correctly? Every box total is the sum of transactions carrying a VAT code. A wrong code on a recurring supplier repeats every period.
- What did a person change? Overrides, manual journals and corrections to earlier periods are where a return most often departs from the system's logic.
What should you ask for?
Make this a standard request for every return you review. If the client or their provider cannot produce it, that is your first finding.
- A box-to-ledger reconciliation, showing for each box which VAT codes and ledger accounts feed it.
- A reconciliation of the VAT control accounts: opening balance, plus output VAT, minus input VAT, minus payments, equals closing balance.
- A transaction listing per VAT code for the period, with a link to the source document for each line.
- The list of exceptions the software raised, and how each was resolved.
- Every manual override of a VAT code and every manual journal touching VAT accounts, with who made it.
- Changes since the last period, such as new VAT codes, new foreign suppliers or customers, and new countries of sale.
- Any correction of an earlier period included in this return.
At Thred, VAT returns are prepared from the live VAT position and every entry stays traceable to its source document, so this pack is something the system should be able to export rather than something someone assembles.
How do you review a Dutch BTW return?
Most Dutch businesses file quarterly, and a business established in the Netherlands files and pays within one month after the end of the period. The boxes (rubrieken) an SME uses most are 1a and 1b for domestic sales at 21% and 9%, 2a for domestic reverse charge, 3b for supplies to businesses in other EU countries, 4a and 4b for purchases from outside and inside the EU where the business accounts for the VAT itself, and 5b for input VAT.
A worked example
Say a client's Q3 return was prepared like this:
- box 1a, base EUR 80,000, VAT EUR 16,800
- box 1b, base EUR 10,000, VAT EUR 900
- box 4b, base EUR 5,000, VAT EUR 1,050
- box 5b, input VAT EUR 9,450
Start with the quick ratios. EUR 16,800 / EUR 80,000 is exactly 21%, and EUR 900 / EUR 10,000 is exactly 9%. If those ratios are off, transactions were coded with the wrong rate or the base contains something that should not be there.
Total VAT due is EUR 16,800 + EUR 900 + EUR 1,050 = EUR 18,750. Box 5b of EUR 9,450 should include the EUR 1,050 from box 4b if the purchase is fully deductible, leaving EUR 8,400 of domestic input VAT. The return shows EUR 18,750 - EUR 9,450 = EUR 9,300 payable.
Then reconcile the control account. If the VAT accounts held EUR 7,900 at 1 July for the Q2 return, and that EUR 7,900 was paid in July, the closing balance at 30 September should be exactly EUR 9,300. Any difference is a booking outside the return, and you want to know what it is.
What to check beyond the boxes
- Box 3b should agree with the ICP declaration for the same period, customer by customer.
- Supplies in 3b need a valid VAT number for the customer; check that new customers were verified.
- Input VAT on costs with private use or mixed use needs a policy, not a default code.
- Errors in earlier returns of EUR 1,000 or less can be corrected in the next return. Above EUR 1,000, the business must file a correction (suppletie) as soon as possible, and within eight weeks of finding the error.
How do you review a UK VAT return?
UK returns are usually quarterly, and the deadline for filing and paying is normally one calendar month and seven days after the period ends. Since April 2022, every VAT-registered business must follow Making Tax Digital unless it is exempt, which means the return is submitted through compatible software and records are kept digitally.
Check the digital links
Making Tax Digital requires digital links between the pieces of software that make up the records. HMRC does not accept copy and paste as a digital link. If the software-prepared return was exported to a spreadsheet and adjusted by hand before submission, that chain is broken. Ask how the figures travelled from the ledger to the submission.
Run the ratios
Box 1 is output VAT, box 4 is input VAT, box 6 is net sales and box 7 is net purchases. A simple test catches miscoding fast. If box 6 is GBP 150,000, of which GBP 30,000 is zero-rated, the standard-rated base is GBP 120,000, and box 1 should be about GBP 120,000 x 20% = GBP 24,000. A large gap points to reduced-rate or exempt sales coded as standard, or the reverse.
Know which correction route applies
HMRC allows errors on earlier returns to be corrected on the current return (method 1) if the net value is GBP 10,000 or less, or between GBP 10,000 and GBP 50,000 and not more than 1% of the current return's box 6. Above those limits, or where the error was deliberate, the business must notify HMRC separately (method 2). Software that "fixes" an old period by posting into the current one should tell you which route it assumed. Check the current HMRC guidance before relying on these thresholds for a specific client.
Where should you sample?
Do not sample at random first. Start where software is most likely to be confidently wrong:
- the largest transactions in each box
- suppliers and customers that appear for the first time this period
- any foreign counterparty, and every reverse-charge line
- zero-rated and exempt sales
- transactions where a person overrode the suggested code
- costs coded with full input VAT that look partly private
Then add a small random sample across the rest, so you also learn how the routine transactions are handled. If the random sample is clean for several periods, you can rely more on the system and spend your time on the exceptions.
How should sign-off work?
Agree in writing who reviews, who approves and who files. Keep the evidence pack, your review notes and the final return together for the period. Dutch VAT records generally have to be kept for seven years, and UK VAT records for at least six, so your file should still make sense to someone opening it years from now.
For firms reviewing many clients, the same routine can run across the whole client base. In Thred, one workspace covers every client administration, with checks across all clients for unreconciled items and unusual bookings, so your review starts from a short list rather than a blank page.
If you review software-prepared returns every quarter, book a demo and see what a complete evidence pack looks like.
Frequently asked questions
How do I check a Dutch VAT return quickly?
Divide the VAT in boxes 1a and 1b by their bases; the results should be 21% and 9%. Check that box 5b includes the VAT from boxes 4a and 4b where it is deductible, that box 3b agrees with the ICP declaration, and that the VAT control account closes at the amount payable.
How are errors in an earlier Dutch VAT return corrected?
An error of 1,000 euros or less can be corrected in the next return. For larger amounts, the Belastingdienst requires a separate correction (suppletie) through Mijn Belastingdienst Zakelijk, as soon as possible and within eight weeks of discovering the error.
When can a UK VAT error be corrected on the next return?
HMRC allows correction on the current return if the net error is 10,000 pounds or less, or up to 50,000 pounds if it does not exceed 1% of box 6 for the current period. Larger or deliberate errors must be notified to HMRC separately.
What does Making Tax Digital require for software-prepared returns?
VAT records must be kept digitally and the return submitted through compatible software, with digital links between the programs used. HMRC does not treat copy and paste as a digital link, so manual adjustments in a spreadsheet before submission break the chain.
How long must VAT records be kept?
In the Netherlands the general retention period is seven years, and ten years for data on immovable property. In the UK, VAT records must generally be kept for at least six years.
Sources
Read next
- Dutch VAT return deadlines 2026 and 2027: every date by month, quarter and year
- VAT return in Xero under Making Tax Digital: connect to HMRC, review, adjust and submit, with a worked example
- Domestic reverse charge for construction in Xero: DRC tax rates, invoices, bills, CIS and the VAT return
Where Thred comes in
Make your firm more efficient with AI, so you have more time for relationships, new customers and advisory work.



