Skip to product information
VAT tracker for freelancers (Excel)
€14,95
Pickup currently not available
Your quarterly Dutch VAT return, done in minutes. Add your sales invoices and receipts to this Excel sheet. The quarterly overview shows what to enter in each box of the VAT return (btw-aangifte), what you pay or get back, and by which date.
What the sheet does for you
- Works out the VAT per invoice and per receipt (21%, 9% or 0%), also when you enter the amount including VAT.
- Quarterly overview with boxes 1a, 1b, 1e, 2a, 3b, 4a, 4b, 5a and 5b.
- Handles reverse charge: services to EU businesses, and purchases from for example Google, Meta or Adobe in Ireland.
- VAT on food and drinks in restaurants and cafés is automatically left out of your input VAT.
- Warns you about purchases from €450 that you have to depreciate.
- Tracks your turnover for the KOR limit of €20,000.
- Shows which invoices are still open or overdue.
- Costs per category and an indication of your result.
Good to know
- Instant download after payment: one zip file with the English and the Dutch version (.xlsx).
- Made for Microsoft Excel (Windows and Mac); also opens in Google Sheets.
- Room for 1,000 income and 1,000 expense rows; you set the year yourself.
- Plain-language instructions on the first tab, including how the boxes match the Dutch return.
Need an invoice template and expense checklist too? Get the Freelancer Starter Pack.
This is a tool, not tax advice. Not sure about your situation? Ask your accountant.