Every quarter you need to reconcile your VAT and file Form 303. This Excel template does it for you: record your invoices, calculate the balance, and get the exact figures to fill in the form without errors.
What is this template for?
To record sales and expenses, calculate output and input VAT, and know what to put in each box on Form 303.
Who can use it?
Self-employed individuals and small SLs. If you want to understand the full regime, read the complete self-employed guide.
Does it file Form 303 automatically?
No. It calculates the figures. You file the form yourself on the AEAT's electronic office.
Open the quarterly VAT Google Sheets template.
The file has three tabs. Here is how each one works:
That amount goes in box 64 of Form 303.
Form 303 is the quarterly VAT return. You pay the difference between the VAT you collected from your clients and the VAT you paid to your suppliers.
If the balance is negative, that credit carries over to the next quarter. In the fourth quarter you can request a direct refund.
Filing deadlines in 2026:
Even if you issued or received no invoices that quarter, you must still file. With a zero balance, but you still file.
In the Income and Expenses tabs, enter the taxable base and VAT for each invoice. The template calculates automatically.
The Summary tab gives you three figures that go directly into the form:
The final result goes in box 64. Positive means you pay. Negative means credit for the next quarter.
Have questions about which invoices you can deduct? Read the invoicing guide for the self-employed.
With few invoices per quarter, Excel works. But as your activity grows, manual records generate errors and deductions that slip through the cracks.
Many self-employed people end up switching to tools that connect to their bank and email, capture invoices automatically, and calculate VAT in real time. You always know where you stand before the quarter arrives. That is what renn does.
If you want to compare alternatives, here are the best invoicing platforms for the self-employed.
The template gives you the exact figures for Form 303: sales base, output VAT, input VAT, and final balance. Update it every quarter and your VAT will always be under control.
