Excel workbook previewOSS VAT Return Reconciliation Template
3 free downloads per account. Just your email and a 6-digit code.
About this template
An OSS VAT return reconciliation shows that the quarterly One Stop Shop return agrees with the sales ledger, the general ledger and the payment. Businesses in the Union scheme declare their B2C distance sales of goods and cross-border B2C services for every Member State of consumption in one return, filed by the end of the month after the quarter. Auditors and tax authorities ask for the working papers behind it, and corrections to earlier quarters have their own rules.
The workbook converts each sale to euro at the ECB rate for the last day of the period, applies the rate of the Member State of consumption, and assigns the return part. It builds the figures per Member State, adds corrections, compares them to the filed return and ties the totals to the GL and the payment. It rests on the Commission's Guide to the VAT One Stop Shop and Directive 2006/112/EC.
Who it is for
The tax accountant or controller who files the quarterly Union OSS return and was asked by the auditor to show how the return ties to the sales ledger, the general ledger and the payment.
What is inside
- Settings sheet that works out the quarter, the return and payment due date and the days left, with an ECB rate table and the EUR 10 000 threshold test
- VAT rates for all 27 Member States as input cells, prefilled from the Commission's Your Europe rates page (checked 13/07/2026)
- Sales Ledger sheet with 12 worked sales and 24 blank rows: EUR conversion, rate lookup, OSS return part (2a, 2b, 2d) and a scope check by formula
- Return by Member State sheet with taxable amounts and VAT per rate, corrections (Part 3), balance due (Part 4), the filed figure and the difference for 27 Member States
- Corrections sheet with 4 worked corrections that works out the three-year limit and whether the correction goes in the OSS return or straight to the Member State
- GL Tie-out sheet that agrees revenue, the OSS VAT payable account and the payment to the return, with a list of reconciling items
- How to use sheet with the return deadlines, the exchange rate rule and the record keeping period
How to use it
Enter the year and quarter on the Settings sheet, check the ECB rates and the VAT rates, then paste the quarter's B2C sales into the Sales Ledger.
Files
- XLSXoss-vat-return-reconciliation-template.xlsx26 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.
Questions about this template
When is the OSS VAT return due?
The Commission's OSS guide says the Union and non-Union scheme returns are quarterly and are submitted by the end of the month following the end of the quarter: 30 April, 31 July, 31 October and 31 January. The date does not move when it falls on a weekend or public holiday, and payment is due by the same date.
Which exchange rate is used in the OSS return?
The return is made in euro, unless the Member State of identification uses another currency. Supplies in other currencies are converted using the exchange rate published by the European Central Bank on the last date of the tax period, according to the Commission's OSS guide. The template applies one rate per currency for the whole quarter.
How do I correct a previous OSS return?
For periods from 1 July 2021, a correction is made in a later OSS return, in Part 3, stating the tax period, the Member State of consumption and the VAT amount. The Commission's guide allows this within three years of the date the original return was due. After that, the correction goes to the Member State of consumption under its own rules.



