Pro feature

CSV export

Overview

CSV export is a Pro feature with two exports, matching the two places you look at your numbers: the dashboard’s per-country threshold breakdown, and the quarterly OSS filing reports.

This feature requires a Pro license. See what’s included and Licensing for details.

Dashboard export: country breakdown

On the Dashboard tab at WooCommerce → One Stop Shop, the country breakdown table has an Export CSV button in its header. It downloads the selected year’s per-country standing as oss-export-YYYY.csv with these columns:

  • Country — the destination member state.
  • Country Code — the two-letter code.
  • Net Sales (EUR) — net cross-border B2C sales for the year.
  • Orders — the number of tracked orders.
  • % of Threshold — that country’s share of the EUR 10,000 limit.

A totals row at the bottom sums the sales and order counts and shows your overall threshold percentage. Use the dashboard’s year selector first to export a previous year.

Per-order audit export

Next to it, the Export orders CSV button downloads oss-orders-YYYY.csv — one row for every order that has ever been OSS-classified in the selected year, including orders that were later reversed or refunded, so the file doubles as an audit trail for the threshold total:

  • Order and Date — the order number and its creation date.
  • Status — the current WooCommerce order status.
  • Country Code / Country — the destination member state.
  • Net Tracked (EUR) — the amount currently counted for this order.
  • Refunded (EUR) — the total of its refund ledger entries.
  • Counted — whether the order currently counts toward the threshold (yes/no — a cancelled or on-hold order shows no but stays in the file).
  • VAT Number / VIES Verdict — the claimed B2B VAT number, if any, and the recorded VIES verdict (valid/invalid, empty when never checked).

This is the export to hand your accountant when they ask why the dashboard total is what it is.

VAT scheme column

The last column, VAT Scheme, shows OSS for a sale made while OSS applied and Home country for a sale made before (for example, earlier in the year you crossed the threshold). Use it to split orders between your OSS return and your domestic VAT return. See Only sales made while OSS applied.

Location-evidence columns

Each row also carries the order’s location evidence: the billing-address country, the IP-geolocation country, whether the sources agree (consistent, conflict, or insufficient), and — when a conflict was reviewed — the resolved country and any destination override. Together with the classification columns this forms a per-order audit pack for the quarter.

Quarterly report export

Each quarter on the Reports tab has its own Export CSV action, which downloads oss-report-YYYY-QN.csv — the filing-ready figures for that quarter:

  • Country
  • Country Code
  • Standard VAT Rate (%)
  • Net Sales (EUR)
  • VAT Due (EUR)

plus a totals row for net sales and VAT due. See Quarterly OSS reports for how these figures are calculated, including how refunds and manual adjustments are treated.

File format notes

  • Amounts use a plain decimal point with no thousands separators, so spreadsheets and accounting tools parse them as numbers without locale guesswork.
  • All values are hardened against spreadsheet formula injection — a cell can never execute as a formula when the file is opened in Excel, LibreOffice, or Google Sheets.
  • Exports require a logged-in user with the WooCommerce management capability; the files are generated on demand and not stored on the server.

Tips

  • Export quarterly — even below the threshold, keeping a per-quarter paper trail makes a later registration or audit much easier.
  • Verify before filing — cross-check exported totals against the on-screen report before entering them in your OSS portal.
  • Store exports securely — treat the files as business records.