About Services Tools Blog Contact us

VAT Period Evidence Export

Pulls one VAT period out of Xero into a saved folder of transactions, contacts, documents and a summary. If it is interrupted, it carries on from where it stopped.

  • Accounting & Reconciliation
  • Professional services
  • Tool
  • Productised
  • Local/private
  • 2026

The problem

Checking a VAT return meant paging through invoices and bank lines in Xero. There was no single evidence folder for the period. And a long export that failed part-way had to start again.

What it does

You pick a period and the exporter works through reference data, invoices, credit notes, bank lines, contacts, attachments and a summary. Each request does as much as fits in a set time, saves its progress and can carry on later. Requests are spaced to stay within Xero's usage limit. Finished folders can be downloaded and are kept apart from day-to-day editing.

Outcomes

  • One folder holds the period's transactions and the documents behind them.
  • An export can be stopped and carried on.
  • A second run of the same period shows the steps already complete.
  • Requests are spaced so Xero's usage limit is respected.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

VAT period pack

Period attachment access

Authorised and paid invoices, credit notes and bank lines in the window, plus accounts, tax rates, contacts and attachments. Each request stops after 20 seconds. Calls wait 1.1 seconds apart. Session calls: 0.

Progress 2026-01-01_2026-03-31
  1. Reference data
  2. Sales invoices
  3. Purchase invoices
  4. Credit notes
  5. Bank lines
  6. Contacts
  7. Documents
  8. Period summary
Ready
Packs on this file
PeriodStatusDocumentsNet VATUpdated
1 Oct 2025 – 31 Dec 2025 complete 74 £6,360.00 6 Jan 2026
1 Jan 2026 – 31 Mar 2026 not started – – today

Same period again

Steps already complete
8 / 8
Calls on the first run
186
Saved
7 Apr 2026, 14:06
manifest on disk
2026-01-01_2026-03-31 complete
  1. Reference data 8 calls
  2. Sales invoices 42
  3. Purchase invoices 61
  4. Credit notes 4
  5. Bank lines 118
  6. Contacts 37
  7. Documents 86 files
  8. Period summary written

Interrupted pack

1 Jul 2025 – 30 Sep 2025 stopped

Documents stopped on INV-2416. The attachment call passed the 20 second budget. Reference data, invoices, credit notes, bank lines and contacts are already stored.

2025-07-01_2025-09-30 · 40 of 71 documents · net VAT not written

Saved before the stop
  1. Reference data
  2. Sales invoices 38
  3. Purchase invoices 44
  4. Credit notes 2
  5. Bank lines 96
  6. Contacts 29
Still to do
  1. Documents
  2. Period summary
Waiting to resume

Q4 2025 pack

complete
Documents
74
Box 5
£6,360.00
VAT to pay
Closed
6 Jan 2026
Folder 2025-10-01_2025-12-31
FileRows
manifest.json1
summary.json9
transactions/invoices_accrec.json36
transactions/invoices_accpay.json48
transactions/credit_notes.json3
transactions/bank_transactions.json102
contacts/contacts.json31
documents/74
summary.json
BoxMeaningAmount
1VAT due on sales£16,240.00
2VAT due on acquisitions£0.00
3Total VAT due£16,240.00
4VAT reclaimed£9,880.00
5Net VAT£6,360.00
6Sales ex VAT£81,200.00
7Purchases ex VAT£49,400.00
8Supplies to EC£0.00
9Acquisitions from EC£0.00
Documents
FileContactKindNet
INV-2314.pdfLumen Rooms LtdSales£2,400.00
INV-2288.pdfPriya ShahSales£860.00
BILL-1091.pdfKeel Paper LtdPurchase£214.00
CN-0094.pdfHarbour Yard surveyCredit£180.00
BILL-1102.pdfMarrow Print CoPurchase£640.00

How it works

  1. Choose the VAT period on the connected Xero account.
  2. Work through reference data, invoices, credit notes, bank lines, contacts and attachments.
  3. Save progress after each timed batch.
  4. Carry on with an export that was interrupted.
  5. Write a summary and offer the folder as a download.

Pipeline

flowchart LR
  Period[VAT period] --> Ref[Reference data]
  Ref --> Sales[Sales and purchases]
  Sales --> Bank[Bank lines]
  Bank --> Docs[Documents]
  Docs --> Pack[Downloadable pack]