If you’ve ever sat down to prepare your IOSS or OSS return and found yourself staring at mismatched figures from Amazon, eBay, or other marketplaces, you’re definitely not alone. Reconciling marketplace VAT reports with your actual tax returns is one of those tasks that sounds straightforward in theory but can quickly turn into a frustrating puzzle of discrepancies, missing data, and unexplained differences.
The good news? With the right approach and understanding of what you’re looking at, reconciliation doesn’t have to be a monthly headache. Let’s walk through the process step by step, so you can file your returns with confidence.
Why does reconciliation matter so much?
Before diving into the how, it’s worth understanding why this reconciliation process is absolutely critical. Your IOSS or OSS return isn’t just a box-ticking exercise; it’s a legal declaration of the VAT you’ve collected and owe to EU tax authorities.
When the figures you submit don’t match what’s actually happening in your sales, several problems emerge. Tax authorities may query your returns, triggering audits or requests for clarification. If you’ve under-declared VAT, you’ll face penalties and interest charges. Over-declare, and you’re essentially giving away money that belongs in your business.
Beyond compliance, accurate reconciliation gives you genuine insight into your business performance. It helps you understand your true margins, identify pricing issues, and spot problems with your marketplace integrations before they become costly mistakes.
Understanding what marketplaces actually report
Each marketplace handles VAT reporting slightly differently, which is often where confusion starts. Amazon, eBay, Etsy, and others generate VAT reports, but what they show isn’t always what you might expect.
Most marketplace reports show gross sales figures, VAT collected, and sometimes net amounts. However, these reports might include returns that haven’t been processed, cancelled orders that still appear, or transactions that fall outside the reporting period but were included due to processing delays.
Amazon’s VAT Transaction Report, for instance, includes detailed line-by-line transactions but uses the transaction date rather than the settlement date. This timing difference alone can cause discrepancies when you’re trying to match figures to a specific month.
eBay’s VAT reports provide summary data by country, which is helpful for IOSS/OSS filing, but doesn’t always break down the details you need to identify specific problem transactions.
Understanding these quirks for each platform you sell on is the first step towards accurate reconciliation.
What should your reconciliation process look like?
A solid reconciliation process follows a logical sequence. Let’s break it down into manageable steps.
Start by gathering all your source data: Download VAT reports from each marketplace you sell on for the period you’re filing. Make sure you’re pulling reports for the correct date range. Remember, IOSS and OSS returns are typically filed monthly.
Organise data by destination country: Your IOSS or OSS return requires you to report VAT by member state, so you’ll need to break down your marketplace sales by the customer’s location. Most marketplace reports provide this information, though the format varies.
Separate different types of transactions: Not every sale should appear on your IOSS/OSS return. B2B sales where the customer provided a valid VAT number follow different rules. Sales to customers outside the EU don’t belong on EU VAT returns at all. Returns and refunds need to be handled appropriately.
Cross-reference the totals: Once you’ve categorised everything, check that the VAT totals in your marketplace reports match what you’re about to declare. This is where discrepancies usually surface.
Common discrepancies and how to handle them
Even with a careful process, differences between marketplace reports and your prepared returns are common. Here’s what typically causes them and how to address each issue.
Returns and refunds are probably the most frequent culprit. If a customer returned an item in March that they purchased in February, where should the VAT adjustment appear? The answer depends on when you process the refund. You’ll need to subtract the VAT from the period when you issued the refund, which might not match when the original sale occurred in your marketplace report.
Cross-border fulfilment complications arise when you’re using FBA or similar services. If Amazon ships from a German warehouse to a French customer, the VAT treatment might differ from a direct shipment from outside the EU. Your marketplace report might not clearly distinguish these scenarios, so you’ll need to identify and categorise them correctly.
Cancelled orders sometimes appear in marketplace reports even though no money changed hands and no VAT was collected. These need to be excluded from your return, but they can inflate the figures in your initial marketplace data.
Currency conversion differences pop up if you’re selling in multiple currencies. The marketplace converts at one rate, whilst your accounting system or payment processor might use slightly different rates. Small differences across hundreds of transactions can add up to noticeable discrepancies.
Timing differences between transaction dates and settlement dates mean that sales from the end of one month might settle in the following month. Decide whether you’re reporting on a transaction date or settlement date basis and stick to it consistently.
Should you use the transaction date or the settlement date?
This is a question that genuinely confuses many sellers, and there’s no single “right” answer that applies to everyone.
Using the transaction date means reporting VAT based on when the sale occurred, regardless of when you actually received the money. This aligns with how most marketplaces generate their reports and is generally considered the more technically correct approach from an accounting perspective.
The settlement date approach means reporting VAT when the funds actually hit your account. This can be easier for cash flow management and might feel more intuitive; you’re declaring VAT on money you’ve actually received.
The crucial thing is consistency. Whichever approach you choose, use it every single month. Switching back and forth will create chaos in your records and make accurate reconciliation virtually impossible.
Many professional VAT advisers recommend the transaction date method because it aligns with marketplace reporting and reduces the risk of missing transactions entirely.
Building a reconciliation spreadsheet that actually works
A well-designed spreadsheet makes reconciliation infinitely easier. You don’t need anything fancy; a structured Excel or Google Sheets template will do the job.
Your spreadsheet should have columns for: marketplace name, transaction ID, date, customer country, gross amount, VAT rate applied, VAT amount, and transaction type (sale, return, B2B, etc.). Add a notes column for any unusual transactions that need explanation.
Create a summary section that totals VAT by country, which mirrors the structure of your IOSS/OSS return. This way, you can quickly compare your calculated totals with what the marketplace reports show.
Include a reconciliation section where you can document and explain any differences. This becomes incredibly valuable if tax authorities ever query your returns; you have a clear audit trail showing how you arrived at your figures.
When the numbers still don’t match
Sometimes, despite your best efforts, you’ll find differences you simply can’t explain. What then?
First, double-check the obvious things: date ranges, excluded transaction types, and currency conversions. A surprisingly large percentage of discrepancies comes down to simple oversights.
If the difference is small, we’re talking a few pounds or euros, and you’ve thoroughly investigated without finding the cause, it’s often acceptable to make a minor adjustment. Document what you’ve done and why. Perfection across thousands of transactions isn’t always achievable, and tax authorities understand this.
For larger discrepancies, it’s worth reaching out to marketplace support or consulting with a VAT specialist. There might be technical issues with how the marketplace is reporting, or you might be misunderstanding an aspect of the data.
Working with professional VAT support
Many successful e-commerce sellers eventually decide that reconciliation and VAT filing isn’t the best use of their time. They’d rather focus on sourcing products, optimising listings, and growing sales whilst leaving the compliance work to specialists.
Professional VAT services don’t just handle the filing; they take ownership of the entire reconciliation process. They understand the quirks of different marketplaces, stay updated on regulatory changes, and have systems to efficiently process even complex multi-marketplace operations.
This approach provides peace of mind. You know your returns are accurate, filed on time, and fully compliant. If authorities have questions, your VAT adviser handles the correspondence.
Let Cross Border VAT handle your reconciliation headaches
Reconciling marketplace VAT reports shouldn’t consume hours of your valuable time every month. At Cross Border VAT, we specialise in managing IOSS and OSS compliance for e-commerce sellers across Amazon, eBay, Etsy, Shopify, and other platforms.
Our team handles the complete reconciliation process, ensures accurate VAT reporting, and files your returns on time, every time.
Ready to reclaim your time and eliminate VAT compliance stress? Contact us today.
People Also Ask
What’s the biggest mistake sellers make when reconciling marketplace VAT reports?
The most common error is failing to account for returns and refunds properly. Many sellers forget to adjust VAT for refunded transactions or apply the adjustment in the wrong reporting period, leading to over-declared or under-declared VAT that can trigger compliance issues.
Can I use marketplace VAT reports directly for my IOSS/OSS filing?
Whilst marketplace reports provide essential data, they usually need significant processing before they’re suitable for direct filing. You’ll need to exclude certain transaction types, organise data by destination country, handle returns appropriately, and often reconcile timing differences between transaction and settlement dates.
How do I handle VAT when selling on multiple marketplaces?
You’ll need to reconcile each marketplace separately, then combine all the data into a single IOSS or OSS return organised by the destination country. This requires a structured approach to avoid double-counting or missing transactions when consolidating data from different platforms.
What should I do if my marketplace report shows more VAT than I actually collected?
This often happens with cancelled orders or transactions that failed after appearing in reports. Identify these specific transactions, exclude them from your calculations, and document why. If discrepancies persist, contact marketplace support to understand what’s included in their reporting.
How long should I keep reconciliation records and supporting documentation?
EU member states typically require you to maintain VAT records for at least 10 years. Keep all marketplace reports, reconciliation spreadsheets, and supporting documentation for this period. These records are essential if tax authorities audit your IOSS or OSS filings.



