VAT Return Preparation: Step-by-Step Example
This example follows a design studio preparing its quarterly VAT return from 240 supplier invoices. Manually, the accountant spends two days cross-checking VAT rates, net/VAT splits, and intra-EU acquisitions in a spreadsheet, at a labour cost of roughly €400 for the quarter. With Nika each invoice is coded with the correct VAT rate as it arrives, so the VAT return is a query — not a project — and costs {price} per processed invoice.
Before: manual process
A 15-person design studio files a quarterly VAT return. For Q1 2025 there are 240 supplier invoices: 180 standard-rated at 21%, 24 reduced-rated at 6% (books, some food), 12 intra-EU acquisitions reverse-charged, and 24 zero-rated or out-of-scope. The studio's bookkeeper downloads each PDF, types net and VAT into a spreadsheet, sorts by rate, and totals each box. A misfiled rate on a €2,400 print job (21% coded as 6%) understates output VAT by €360 until the accountant catches it in review. The whole exercise takes two full days of bookkeeper time — roughly €400 in labour at €25/hour — and runs right up against the filing deadline.
After: with Nika
The same 240 invoices arrive over the quarter. Nika reads each one as it lands and codes the VAT rate from the supplier's history and the invoice's own tax breakdown: PrintHub Ltd at 21%, Boekwerk at 6% (reduced-rate books), Druckhaus München reverse-charged as an intra-EU acquisition. The misfiled-rate problem never arises because the rate comes from the invoice, not from a guess. At quarter-end the accountant opens the VAT return view: box 1 (output VAT) and box 2 (intra-EU acquisitions) are already populated from the coded records. A 15-minute review replaces two days of spreadsheet work. Cost: {price} per processed invoice — charged only on invoices actually filed, not on the return itself.
Workflow
- 1
Capture
In: 240 supplier invoices arriving across the quarter (email + portal downloads)Out: Each invoice detected, PDF extracted, VAT rate read from the documentSaved: ~1 hour/quarter vs. manual download and sort - 2
Code VAT rate
In: Invoice tax breakdown + supplier historyOut: 180 invoices at 21%, 24 at 6%, 12 intra-EU reverse-charge, 24 zero-rated — each tagged to the correct VAT boxSaved: ~1.5 days vs. manual per-invoice rate lookup and spreadsheet entry - 3
Flag rate conflicts
In: Invoice rate vs. rate used on prior invoices from same supplierOut: PrintHub €2,400 invoice showing 6% instead of usual 21% → held for approval with reasonSaved: Catches the €360 understatement at receipt, not at review - 4
Populate return
In: Coded records for the quarterOut: VAT return boxes pre-filled: output VAT, input VAT, intra-EU acquisitions, net turnoverSaved: ~15 min review vs. ~2 days of manual compilation
Cost comparison
| Method | Cost | Time |
|---|---|---|
| Manual — bookkeeper spreadsheet (€25/hr, 2 days) | €400 / quarter (~€1.67 / invoice) | 2 full days, batched at quarter-end |
| Outsourced accountant (VAT filing fee) | Typically €150–350 / quarter + data prep | 1–2 days turnaround |
| Nika (per processed invoice) | {price} / invoice × 240 | Continuous; return is a query at quarter-end |
Key takeaways
- The VAT return becomes a read-only view of already-coded records, not a two-day compilation project.
- Rate conflicts are flagged at receipt — the €360 understatement scenario cannot happen because the rate comes from the invoice itself.
- Per-invoice pricing means a quiet quarter costs less; there is no fixed filing fee.
- The accountant's review is verification, not data entry — the work shifts from building the return to checking it.
Questions
How does Nika handle intra-EU acquisitions and reverse charge?
When a supplier's VAT ID indicates another EU member state and no VAT is charged on the invoice, Nika codes it as a reverse-charge intra-EU acquisition — output VAT and input VAT both posted, net to zero cash impact. You confirm the classification the first time a new EU supplier appears; thereafter it is automatic.
Can I still file through my accountant?
Yes — and most customers do. Nika produces the coded records and the populated VAT boxes; your accountant reviews, signs, and files through the tax authority portal. The difference is that they receive a finished return to check, not a shoebox of invoices to process.
Other examples
- AI Invoice Processing Example: Before and After
- Automated Bookkeeping Workflow Example
- AI Data Entry Example: Invoice to Record
- Per-Task Bookkeeping Example: Cost Breakdown
- Small Business AI Bookkeeping Example
- Expense Categorization: Before and After
- Bank Reconciliation: A Worked Example
- Supplier Invoice Workflow: End-to-End Example
- Monthly Close: A Real-World Example
- Year-End Close: A Real-World Walkthrough
- Multi-Currency Invoice Processing: A Walkthrough
- Expense Report Processing: Before and After AI
- Building an Audit Trail: A Practical Example