EU VAT Guide

OSS Reporting: Spreadsheet vs. Automated (What Actually Works)

If you're selling digital services to EU consumers, here's what reporting really involves.

What OSS reporting requires

The One Stop Shop (OSS) scheme lets you report VAT on B2C digital service sales across the EU through a single registration in your home country. That part is straightforward. The reporting itself is where things get involved.

For every sale to an EU consumer, you need to determine the destination country, apply that country's VAT rate, and keep a record of both. At the end of each quarter, you file an OSS return that breaks down your sales by member state and the VAT rate applied.

What you need for each OSS return

✓

Destination country for every B2C sale (where the customer is located)

✓

Correct VAT rate for the destination country at the time of sale

✓

Country-by-country breakdown of total sales and VAT collected

✓

Quarterly filing through your home country's OSS portal

Important

OSS applies specifically to B2C sales of digital services across EU borders. If you're selling B2B (your client has a VAT number), different rules apply — typically reverse charge. If you're selling domestically, standard VAT rules apply. This guide focuses on the B2C cross-border scenario where OSS is relevant.

The spreadsheet approach

Many businesses start with a spreadsheet. It makes sense when you have a handful of sales per month and sell to customers in only two or three countries. The process looks like this:

Record each sale's destination

For every sale, you determine which EU country the customer is in and log it in a column alongside the invoice amount.

Look up the correct VAT rate

You check the standard VAT rate for that destination country and apply it to the sale. France is 20%, Germany is 19%, Italy is 22%, and so on across 27 member states.

Compile the quarterly return

At the end of each quarter, you aggregate all sales by destination country, sum the VAT collected per country, and enter these figures into your OSS return.

With five sales per month to two countries, this takes maybe 20 minutes per quarter. It works. The question is whether it keeps working as things change.

Where the spreadsheet breaks down

The spreadsheet approach has specific failure points. They don't hit all at once — they accumulate gradually, and by the time you notice, you may have already filed incorrect returns.

1. VAT rate changes

EU member states change their VAT rates periodically. When a rate changes mid-quarter, you need to apply the old rate to sales before the change and the new rate afterward. A spreadsheet with a fixed rate column won't catch this unless you're actively monitoring rate changes across all 27 member states.

2. Volume scaling

Ten sales per month across three countries is manageable. Fifty sales per month across twelve countries means your spreadsheet has become a reporting system — one that you built, you maintain, and nobody else can audit.

3. Human error

Manually looking up and entering VAT rates introduces typos, copy-paste errors, and miscategorized countries. A single wrong rate applied to a batch of sales means your OSS return is incorrect — and corrections require amending a return with your tax authority.

4. No audit trail

A spreadsheet doesn't inherently log when you determined the customer's location, which rate you applied, or why. If your tax authority asks how you determined that a specific sale went to France at 20%, pointing at a spreadsheet cell isn't strong evidence.

Real example: one product, three countries

Suppose you sell an online course for €49 (net). In one quarter, you make sales to customers in France, Germany, and Italy.

Spreadsheet: what you need to track per sale

Country	VAT rate	VAT amount	Gross price
France	20%	€9.80	€58.80
Germany	19%	€9.31	€58.31
Italy	22%	€10.78	€59.78

With three countries, this is still manageable in a spreadsheet. But notice that each sale has a different gross price because the VAT rate differs. Your invoices need to reflect the correct rate at the time of sale. Your quarterly return needs the per-country totals. And if France changes its digital services VAT rate mid-quarter, you need to split your French sales into two groups.

Now multiply this by 15 countries and 200 sales per quarter. The spreadsheet that took 20 minutes now takes hours — and one formula error means the entire return is wrong.

Spreadsheet approach

Manually look up each country's rate
Enter rate per sale in a column
Build formulas for per-country totals
Cross-check formulas before filing
Manually update when rates change

Automated approach

Destination country detected from invoice
Current VAT rate applied automatically
Per-country totals calculated in real time
Quarterly summary ready to export
Rate changes reflected immediately

Tracking OSS rates in a spreadsheet?

Invoxo applies the correct destination VAT rate automatically and generates quarterly summaries by member state.

Try free for 14 days

What automation handles

Automation doesn't change the rules. You still need to determine destination, apply the correct rate, and report by country. What changes is who does the work and how reliable it is.

✓

Destination VAT rate lookup

The system knows the current standard VAT rate for every EU member state. When you create an invoice for a consumer in Italy, it applies 22% without you looking anything up.

✓

Correct rate application at invoice time

The rate is locked to the invoice when it's issued. If a rate changes the next day, existing invoices aren't affected. New invoices get the updated rate.

✓

Quarterly summary by destination country

At the end of each quarter, you get a breakdown of total sales and VAT by member state — the same figures your OSS return requires, ready to transfer.

✓

Built-in audit trail

Every invoice records the destination country, the rate applied, and when it was determined. If questions arise during an audit, the evidence is already there.

What to look for in a tool

If you're evaluating tools for OSS reporting, here are the capabilities that actually matter:

✓

Up-to-date rate database

Standard VAT rates for all 27 EU member states, updated when rates change. You shouldn't need to monitor rate changes yourself.

✓

Automatic rate application

The correct destination VAT rate should be applied at invoice creation, not manually entered. The rate should be locked to the invoice once issued.

✓

Reporting by destination country

You need per-country breakdowns of sales and VAT for your quarterly OSS return. This should be a standard report, not something you build yourself.

✓

Integration with invoicing

The OSS reporting should be connected to your actual invoices. Separate systems mean duplicate data entry and more room for errors.

How Invoxo handles OSS

Invoxo determines the destination country from your client details, applies the correct VAT rate automatically, and generates quarterly OSS summaries. The tax treatment is locked to each invoice when issued — so your reporting always matches your invoices.

Learn more about OSS support in Invoxo →

Summary: when to move beyond spreadsheets

—

A few sales, 2-3 countries: a spreadsheet works fine. Low volume means low risk of errors.

—

Growing volume, more countries: error risk increases. Automation saves time and reduces mistakes.

—

Regular B2C sales across the EU: automation is effectively required. The manual effort doesn't scale and the compliance risk is too high.

Related guides

OSS for Digital Services

VAT rules for selling digital services to EU consumers via OSS.

EU VAT Basics

The complete guide to EU VAT for service businesses.

What Your Accountant Needs

How to prepare invoice data and VAT reports for your accountant.

Common questions

Do I need to register for OSS to sell digital services to EU consumers? ⌄

If you sell digital services to consumers in other EU member states, OSS lets you report and pay the destination-country VAT through a single registration in your home country. Without OSS, you would need to register for VAT separately in each country where you have customers.

How often do I need to file an OSS return? ⌄

OSS returns are filed quarterly. The deadlines are the end of the month following each quarter: April 30, July 31, October 31, and January 31. Late filing can result in penalties depending on your home country's rules.

What happens if I apply the wrong VAT rate on an OSS sale? ⌄

If you apply an incorrect rate, your OSS return will be wrong and you may need to file a correction. Underpaid VAT will need to be settled, and some member states may apply interest on late payments. This is one of the key risks of manual rate tracking.

Can I use OSS for physical goods as well? ⌄

Yes, OSS also covers distance sales of goods to consumers in other EU member states. This guide focuses on digital services, but the reporting principles — destination country VAT, quarterly returns, per-country breakdowns — apply to goods as well.

Disclaimer: This guide covers common OSS reporting scenarios for digital services. Rules vary by member state — confirm specific requirements with your accountant.

Automate OSS reporting

Invoxo applies destination VAT rates automatically and generates quarterly summaries by member state. No spreadsheets needed.

See pricing

14-day free trial. No charges until trial ends.