This guide walks you through a clean, HMRC-aligned VAT workflow in Xero—from setup to submission—plus the checks that keep your return audit-ready.
1) One-time setup & key choices
-
VAT registration details: In Settings → Advanced → Financial settings → VAT, enter VAT number, start date, return frequency, and your VAT accounting basis (Accrual vs Cash).
-
Scheme selection: Choose Standard or Flat Rate Scheme (FRS). If using FRS, set the correct percentage and (if eligible) the first-year discount.
-
MTD authorisation: In Accounting → Reports → VAT Return, connect to HMRC and authorise Xero for Making Tax Digital submissions. Re-authorise when credentials expire.
-
Chart of accounts & tax rates: Ensure UK tax rates (Standard 20%, Reduced 5%, Zero, Exempt, Out of Scope, Reverse Charge options) exist and are mapped correctly.
2) Get the data right before you start
-
Complete the period: Reconcile all bank accounts to the return end date; post missing bills/invoices and allocate payments/receipts.
-
Apply correct VAT codes: Check high-risk areas—delivery charges, mixed-rate items, reverse charge purchases, EU/overseas supplies, employee expenses.
-
Attachments: Attach invoices/receipts to bills and sales invoices; this creates your digital evidence trail.
-
Lock prior periods: If the previous VAT period is complete, set Lock Dates up to the last return end date to prevent back-dating edits.
3) Run pre-submission checks (the “evidence pack” backbone)
-
VAT Audit / Exceptions report: Lists all transactions in the period and late changes to earlier periods (Xero calls these “exceptions”). Review every exception.
-
Aged Receivables/Payables: Confirm nothing material is misdated or duplicated; clear obvious errors before filing.
-
Account Transactions – VAT control: Scan for unusual entries, manual journals, or roundings posted directly to the VAT control account.
-
Profit & Loss / Balance Sheet: Sense-check material swings; miscodings often show up as odd expense spikes.
4) Prepare the VAT Return in Xero
-
Go to Accounting → Reports → VAT Return and select the period HMRC expects.
-
Xero populates Boxes 1–9 from transaction data and your VAT basis/scheme settings.
-
Drill into each box to review source transactions (e.g., Standard-rated sales feeding Box 1 & 6; inputs to Box 4 & 7; EC/reverse charge logic where applicable).
-
Handle adjustments (if needed): Use the Adjustments link on the return to post compliant, documented Box-level adjustments (e.g., partial exemption adjustments, error corrections within HMRC thresholds). Avoid ad-hoc journals that bypass VAT logic.
-
Document rationale: For every adjustment or exception, note the reason and calculation. Save supporting files.
5) Submit via MTD (or mark as filed)
-
If MTD-enabled: click File with HMRC, review the declaration, and submit.
-
If filing outside Xero (rare): you can Mark as filed for internal control, but ensure the HMRC submission matches Xero.
6) After submission
-
Lock the period: Set Lock Dates through the return end date to protect your filed numbers.
-
Archive the evidence pack: Save the VAT Return summary, VAT Audit/Exceptions report, key invoices/bills, reconciliation notes, and any adjustment workings.
-
Post-filing housekeeping: Clear remaining suspense items; schedule a mid-quarter review to catch issues early.
7) Common situations & how to handle them in Xero
-
Late invoices (prior period): Post with the correct original date and code. Xero includes them as VAT exceptions in the current return; review the Exceptions report and keep evidence.
-
Reverse charge purchases (e.g., certain services or domestic RC in construction): Use the appropriate reverse-charge tax rates so Xero posts both output and input VAT correctly (net effect usually nil but must appear in the boxes).
-
Mixed-rate or zero-rated supplies: Split line items with correct tax rates; avoid forcing totals with one blanket rate.
-
Flat Rate Scheme: Sales drive VAT due (at your FRS %). Most purchases don’t go to Box 4 under FRS (except limited rules such as capital assets over the threshold). Ensure your scheme is set in Xero so boxes calculate correctly.
-
Cash basis: VAT is recognised on receipt/payment. Reconcile all cash movements before preparing the return; unresolved items will distort boxes.
8) A simple month/quarter close checklist for VAT in Xero
-
Reconcile banks to period end; import any missing statements.
-
Review Awaiting Approval bills/invoices—approve or remove duplicates.
-
Scan Find & Recode (Advisor) for common miscoding (travel vs entertainment, RC services, zero vs exempt).
-
Run VAT Audit/Exceptions, Aged AR/AP, VAT control account checks.
-
Prepare the VAT Return, drill into boxes, and add any justified Adjustments.
-
Submit via MTD, Lock Dates, and archive the evidence pack.
If you keep VAT codes accurate, reconcile fully, review the Exceptions and Audit reports, and file through Xero’s MTD connection with proper documentation, you’ll produce VAT returns that are both compliant and easy to defend under review.