EU Seller Bookkeeping & VAT/OSS Tracker 2026

Bookkeeping built for online sellers based in the EU. Enter your sales and expenses; the workbook works out the VAT treatment, rate and amount, your quarterly VAT figures and your profit.

What's included

• EU-Seller-Bookkeeping-VAT-OSS-2026.xlsx – one workbook, ready to use
• Start Here guide: set up in 10 minutes
• Settings for any of the 27 EU home countries, VAT registered or not, Dutch KOR on/off and OSS status
• Income log with automatic VAT rate and amount per sale (customer country, B2C/B2B)
• Expenses log: 19 editable categories, deductible VAT, EU reverse charge, business-use %
• EU VAT rates for all 27 member states (checked October 2026)
• Quarterly VAT summary: domestic return (Dutch btw boxes as a guide) and OSS return by country
• €10,000 threshold monitor that switches to destination-country VAT automatically
• KOR check, monthly P&L dashboard with 4 charts, mileage log and home-office allocation
• Year-end summary with audit-style control checks and a checklist

Who it's for

Etsy, Shopify, Amazon, print-on-demand, Bol.com and own-webshop sellers, and freelancers selling online, based in the Netherlands or elsewhere in the EU.

How to use

1. Excel: unzip the download, then open the .xlsx in Microsoft Excel 2010 or later (Windows or Mac).
2. Google Sheets: upload the file to Google Drive, open it with Google Sheets, then choose File → Save as Google Sheets.
3. Start on the Start Here tab. White cells are for your input; grey cells are calculated and locked.
4. No macros, no add-ons, formulas locked so you can't break them by accident.

Good to know

• Tax year 2026. Built-in thresholds: EU distance-selling €10,000, Dutch KOR €20,000 turnover, mileage €0.25/km (all editable in Settings).
• A record-keeping aid, not tax, legal or accounting advice. Check your situation with your tax office or an adviser before filing.
• Amounts in EUR. EU VAT rates are correct as of October 2026; check the rates tab each January.

Support

Questions? Email balans@brightsheetsstudio.com

Instant digital download. By purchasing you agree the download starts immediately, which waives the 14-day withdrawal right for digital content.