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 your sales and expenses, calculate output and input VAT, and know what to put in each box on Form 303.
Who is it for? Self-employed individuals and small SLs. If you want to understand the full VAT regime, see the Form 303 section below.
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:
Enter the date, client name, invoice number, taxable base, and VAT rate for each sales invoice you issued that quarter. The template supports 21%, 10%, and 4% rates. Select the correct rate for each line and the VAT amount calculates automatically. Column totals update at the bottom of the tab.
Enter the date, supplier name, invoice number, taxable base, and VAT rate for each expense invoice you received. Only include invoices that are deductible: those linked to your business activity and backed by a valid invoice with a NIF. Personal expenses and invoices without a NIF are not deductible and should not be entered here.
The Summary tab pulls the totals from the Income and Expenses tabs automatically. It shows:
That net balance 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 (recurring each year):
Even if you issued or received no invoices that quarter, you must still file with a zero balance.
In the Income and Expenses tabs, enter the taxable base and VAT for each invoice. The template calculates automatically.
The Summary tab gives you the key figures that go directly into the form:
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.
