Back to home

Understanding your TaxLedger Sales & VAT summary

A guide to the sales-tax-summary workbook generated by SellerEngine TaxLedger

Every time you export from TaxLedger, SellerEngine builds a workbook named TaxLedger-sales-tax-summary-<period>-<currency>.xlsx from your Amazon VAT transaction data. This page explains, sheet by sheet, what every section means and how to use it.

This is a draft for your accountant, not a tax filing. TaxLedger reads and organizes your Amazon numbers and maps them to the official portal boxes, but it does not submit anything and it is not tax advice. Always review the figures — especially rows marked Needs review — with a qualified accountant before filing.

How the report is built

TaxLedger takes your Amazon VAT Transactions Report (or a ledger you upload), classifies every line by its fiscal treatment (who the buyer is, where the goods moved, who was responsible for the VAT), and then totals the figures by country and by VAT rate. All amounts are shown in the report currency (for example EUR) — TaxLedger reads the net, VAT and gross values directly from your data and never converts currencies.

The sheets in the workbook

Sheet	What it is for
Executive VAT Summary	One-page overview: headline totals and VAT grouped by fiscal category.
Sales and VAT report	The detailed backbone — every category broken down by country and VAT rate. Every other sheet derives from this.
Inventory Transfers	Amazon moving your stock between fulfillment centers in different countries (not sales).
Per-country VAT draft (DE, ES, FR, ...)	One sheet per country, pre-filled with that country’s official tax-portal box codes.
OSS VAT draft	Your One-Stop-Shop return draft for cross-border B2C sales to EU consumers.

1. Executive VAT Summary

The page to read first. It contains:

Report information — the entity, period, currency and status (always Draft for accountant review).
Executive KPIs — Total Taxable Base (the net amount), Total VAT (the tax you charged), and Total Gross (base + VAT), plus the split between OSS VAT and local B2C / B2B VAT.
VAT summary by fiscal category — each category with its Base, VAT and Total, and the filing treatment (Local VAT, EC sales / reverse charge, OSS return, and so on).

2. Sales and VAT report

The detailed backbone that every other sheet is built from. For each fiscal category it breaks your sales down by origin country, then by VAT rate, separating Products from Shipping, with three money columns:

Base — the net (taxable) amount.
VAT — the tax charged.
Total — the gross (Base + VAT).

The categories you may see correspond to the fiscal treatments explained in the glossary below: local B2C, local B2B, intra-community B2B, OSS, exports, and marketplace-collected sales.

3. Inventory Transfers

Amazon moving your stock between fulfillment centers in different countries (for example stock arriving in DE from SK, or in ES from FR). Each row shows the destination and origin country, the SKU, the HS code, quantity, weight and unit cost. These movements are not sales and carry no VAT, but they can matter for intra-EU movement reporting (such as Intrastat or call-off stock). Pass them to your accountant if they apply to you.

4. Per-country VAT drafts (DE, ES, FR, ...)

One sheet for each country where you have local VAT to declare, pre-filled with the exact box codes of that country’s tax portal (for example ELSTER for Germany or AEAT Modelo 303 for Spain). The header shows the portal name, your VAT ID, the filing frequency and the deadline. The table has these columns:

Column	Meaning
Portal field	The official box number in that country’s VAT return.
What this value means	The official label of that box.
Amount	The value to enter.
Type	Whether the amount is a taxable Base or the VAT itself.
Comes from	Which of your sales feed that box.
Status	Ready to copy (mapped with confidence) or Needs review (confirm with your accountant before filing).

5. OSS VAT draft

Your One-Stop-Shop (Union scheme) return draft. It groups your cross-border B2C sales to EU consumers by the consumer’s country and VAT rate, so you can declare them in a single OSS return in your country of identification instead of registering for VAT in every country you sell to.

VAT terms used in the report

Taxable base (Base) — the net amount before VAT.
Output VAT (VAT) — the VAT you charged on a sale.
Gross (Total) — Base + VAT.
B2C — a sale to a private consumer; VAT is charged at the applicable rate.
B2B — a sale to a VAT-registered business.
Intra-community supply — a cross-border B2B sale within the EU; usually 0% under the reverse charge (the buyer accounts for the VAT), and also reported in the EC Sales List.
OSS (One-Stop-Shop) — a single EU return for cross-border B2C distance sales.
Marketplace VAT / deemed supplier — sales where Amazon collected and remitted the VAT on your behalf.
Export — goods shipped outside the EU; usually 0%.

How to use this workbook

Treat it as a draft. Review every row marked Needs review with your accountant before filing.
The per-country sheets map your values to real portal box codes, but always confirm them in the official portal (ELSTER, AEAT, HMRC, and so on).
If a figure looks wrong, trace it back in the Sales and VAT report sheet — that is the source breakdown for everything else.
Numbers come straight from your Amazon VAT data. If a period looks incomplete, re-upload the latest VAT transactions report and export again.

SellerEngine is software, not a tax advisor. This report and this guide do not constitute tax advice or a tax filing. You remain responsible for the accuracy of your VAT returns.

Questions about your export? Contact us or open TaxLedger from your workspace.