Prepare your quarterly OSS VAT return from WooCommerce

Once your cross-border B2C sales pass the EUR 10,000 OSS threshold, the quarterly return becomes a recurring chore: for every EU country you sold to, you need net sales and the VAT due at that country’s rate, split by quarter. Pulling that out of WooCommerce by hand — reconciling refunds, currencies and off-platform sales — is exactly where mistakes creep in.

Sellinor EU VAT One Stop Shop (OSS) for WooCommerce does the assembly for you. With the Pro add-on active, the Reports tab builds a filing-ready, country-by-country breakdown for each quarter, ready to print or export as CSV. To be clear from the outset: the plugin prepares the figures; it does not file or submit the return to any tax portal for you.

It prepares the numbers — you still file

This page describes a filing aid, not an automated submission. The Reports tab produces the same per-country, per-rate figures an OSS return asks for, so you can transcribe or upload them into your own OSS portal with the underlying numbers reconciled to your orders. The act of registering and filing remains yours (or your accountant’s).

The reporting features described below are a Pro add-on and require a Pro license. The free plugin still does the heavy lifting of real-time threshold tracking so you know the moment OSS becomes relevant.

When the quarterly tables appear

OSS filing only matters once destination VAT applies, so the Reports tab is deliberately quiet until then. The quarterly tables show up when:

• the selected year has exceeded the EUR 10,000 threshold, or
• the previous year exceeded it — in which case destination VAT applies for the whole following year.

Below that point the tab shows a No OSS reports required yet state with your current threshold progress and a link back to the dashboard. Home-country VAT still applies, so there is genuinely nothing to file through OSS.

What each quarterly table contains

For each quarter — Q1 (Jan–Mar) through Q4 (Oct–Dec) — the report lists every destination country with tracked sales, in the columns a return expects:

Column	What it shows
Country	The destination EU member state
Standard VAT rate (%)	That country’s standard rate
Net sales (EUR)	Net cross-border B2C sales attributed to the quarter
VAT due (EUR)	Net sales multiplied by the standard rate

A totals row sums net sales and VAT due for the quarter. A year selector switches between years, and a Recalculate button rebuilds the figures from your order history — useful if a year has per-country totals but no order-level detail (for example, orders placed before the plugin was installed).

The figures rest on the free engine: only genuine cross-border EU B2C sales count, the tracked amount per order is the order total minus tax in EUR (shipping in, VAT out), and refunds, cancellations and status reversals are netted out automatically with no double-counting.

Standard rates only

VAT due is calculated at each member state’s standard rate. Reduced and zero rates are not handled. If some of your products qualify for a reduced rate in a destination country, adjust those lines before filing. See VAT rates by country for how standard rates are applied.

How refunds are attributed

Refunds are where naïve reports get OSS corrections wrong. Sellinor follows the rule a return expects: the original sale stays in the quarter it was placed, and the refund reduces the quarter — and calendar year — in which the refund actually happened.

So a sale made in Q4 and refunded the following February appears as a positive amount in Q4 of the first year and a negative adjustment in Q1 of the next year. That matches how OSS corrections are reported, rather than retroactively rewriting a quarter you have already filed.

Off-platform sales sit in a separate table

If you also sell through Amazon, eBay or in person, those sales count toward the same legal threshold, and you record them as manual adjustments on the dashboard. But a manual adjustment carries a year and no quarter, so it cannot be attributed to a specific quarterly return.

Rather than guess, the Reports tab keeps them out of the quarterly tables and shows them in a separate, clearly labelled Manual / off-platform adjustments table — per country, with net sales and computed VAT due for the year — plus a note reminding you to fold them into the relevant quarterly return yourself.

Print and CSV export

Each quarter section gives you two actions:

• Print — opens a print-friendly view in your browser’s print dialog.
• Export CSV — downloads the quarter as oss-report-YYYY-QN.csv.

The CSV carries the columns Country, Country Code, Standard VAT Rate (%), Net Sales (EUR) and VAT Due (EUR), plus a totals row. Amounts use a plain decimal point with no thousands separators, so accounting tools parse them as numbers, and every value is hardened against spreadsheet formula injection. The same Pro CSV export module adds a separate dashboard export (oss-export-YYYY.csv) covering the per-country threshold breakdown for the year — handy for your accountant. See the CSV export docs for the full field list.

Built for real, long-lived stores

The reports read orders correctly on both WooCommerce High-Performance Order Storage (HPOS) — the modern default — and legacy post-based storage. Orders are aggregated in bounded pages rather than loaded all at once, so reports stay reliable even on stores with large order histories.

Selling in a non-EUR currency? The free plugin tracks EUR stores; the Pro multi-currency module converts orders and refunds to EUR using ECB daily reference rates so your reports stay meaningful in SEK, PLN, DKK and the rest. It only converts internally for tracking and reporting — it never changes what customers see or pay.

Not tax advice

The report is prepared from your store’s order data as a filing aid, not as tax or legal advice, and it does not guarantee compliance. Always verify the figures — especially any lines that should use a reduced rate — with a qualified tax professional before submitting your OSS return.

Ready to see your quarterly figures take shape? Start with free threshold tracking, and when OSS becomes relevant, the Pro add-on builds the country-by-country return for you. New to OSS in WooCommerce? Our setup guide walks through it end to end.