Spreadsheet templates: quarterly tax tracker and rent ledger
Excel templates for freelancers in Spain and for landlords and tenants: an invoice and expense tracker whose summary fills in the boxes of models 303 and 130 per quarter, and a rent ledger with monthly payments, IPC/IRAV updates, deposit and receipts. Opens in Excel, LibreOffice and Google Sheets.
Free version: a CSV with the sheets, columns and labels, without formulas.
Pro: the .xlsx with every formula
Totals, quarters, 303 and 130 boxes, carry-overs and the rent due are calculated by the spreadsheet itself as you type.
Structure of the spreadsheet
ƒx = cell with a formula (Pro .xlsx) · Shaded = cell for your data
Invoices issued
| Date | Invoice no. | Client | Client NIF | Taxable base (€) | IVA % | IVA (€) | IRPF withholding % | IRPF withheld (€) | Invoice total (€) | Quarter |
| ƒx | ƒx | ƒx | ƒx | |||||||
| ƒx | ƒx | ƒx | ƒx |
… and 299 more rows.
Expenses
| Date | Invoice no. | Supplier | Supplier NIF | Concept | Base (€) | IVA % | Deductible IVA (€) | Investment good (x) | IRPF expense (€) | Quarter | Type (C/I) |
| ƒx | ƒx | ƒx | ƒx | ||||||||
| ƒx | ƒx | ƒx | ƒx |
… and 299 more rows.
Summary
| Quarterly summary 2026: models 303 and 130 | |||||
| Concept | Box | Q1 | Q2 | Q3 | Q4 |
| Filing period | 01/04/2026 - 20/04/2026 | 01/07/2026 - 20/07/2026 | 01/10/2026 - 20/10/2026 | 01/01/2027 - 30/01/2027 | |
| Your data | |||||
| Previous year's net earnings from activities (€, leave empty if over 12,000 €) | |||||
| Other IRPF expenses of the quarter without IVA (fee, amortisation…) | |||||
| Model 303 (IVA) | |||||
| IVA charged: base at 21 % | 07 | ƒx | ƒx | ƒx | ƒx |
| Rate | 08 | 21 % | 21 % | 21 % | 21 % |
| IVA charged: quota at 21 % | 09 | ƒx | ƒx | ƒx | ƒx |
| IVA charged: base at 10 % | 04 | ƒx | ƒx | ƒx | ƒx |
| Rate | 05 | 10 % | 10 % | 10 % | 10 % |
| IVA charged: quota at 10 % | 06 | ƒx | ƒx | ƒx | ƒx |
| IVA charged: base at 4 % | 01 | ƒx | ƒx | ƒx | ƒx |
| Rate | 02 | 4 % | 4 % | 4 % | 4 % |
| IVA charged: quota at 4 % | 03 | ƒx | ƒx | ƒx | ƒx |
| IVA charged: base at 0 % | 150 | ƒx | ƒx | ƒx | ƒx |
| Rate | 151 | 0 % | 0 % | 0 % | 0 % |
| IVA charged: quota at 0 % | 152 | ƒx | ƒx | ƒx | ƒx |
| Total IVA charged | 27 | ƒx | ƒx | ƒx | ƒx |
| IVA paid on current expenses: base | 28 | ƒx | ƒx | ƒx | ƒx |
| IVA paid on current expenses: quota | 29 | ƒx | ƒx | ƒx | ƒx |
| IVA paid on investment goods: base | 30 | ƒx | ƒx | ƒx | ƒx |
| IVA paid on investment goods: quota | 31 | ƒx | ƒx | ƒx | ƒx |
| Total deductible | 45 | ƒx | ƒx | ƒx | ƒx |
| General regime result | 46 | ƒx | ƒx | ƒx | ƒx |
| Sum of results | 64 | ƒx | ƒx | ƒx | ƒx |
| State share result (100 %) | 66 | ƒx | ƒx | ƒx | ƒx |
| Amount to compensate from earlier periods (Q1: type it) | 110 | ƒx | ƒx | ƒx | |
| Compensated this period | 78 | ƒx | ƒx | ƒx | ƒx |
| Left to compensate later | 87 | ƒx | ƒx | ƒx | ƒx |
| Result | 69 | ƒx | ƒx | ƒx | ƒx |
| Result of the return | 71 | ƒx | ƒx | ƒx | ƒx |
| Outcome | ƒx | ƒx | ƒx | ƒx | |
| Model 130 (IRPF, direct estimation, cumulative) | |||||
| Income from 1 January | 01 | ƒx | ƒx | ƒx | ƒx |
| Deductible expenses from 1 January | 02 | ƒx | ƒx | ƒx | ƒx |
| Net earnings | 03 | ƒx | ƒx | ƒx | ƒx |
| 20 % of the net earnings (0 if negative) | 04 | ƒx | ƒx | ƒx | ƒx |
| Payments of earlier quarters | 05 | 0 | ƒx | ƒx | ƒx |
| Withholdings from 1 January | 06 | ƒx | ƒx | ƒx | ƒx |
| Section result | 07 | ƒx | ƒx | ƒx | ƒx |
| Sum (0 if negative) | 12 | ƒx | ƒx | ƒx | ƒx |
| Reduction (art. 110.3.c RIRPF) | 13 | ƒx | ƒx | ƒx | ƒx |
| Difference | 14 | ƒx | ƒx | ƒx | ƒx |
| Negative results of earlier quarters still available | 0 | ƒx | ƒx | ƒx | |
| Negative results of earlier quarters deducted | 15 | ƒx | ƒx | ƒx | ƒx |
| Total | 17 | ƒx | ƒx | ƒx | ƒx |
| Result of the return | 19 | ƒx | ƒx | ƒx | ƒx |
| Outcome | ƒx | ƒx | ƒx | ƒx |
Notes
| Quarterly tax tracker 2026: notes |
| Use one file per year (2026). Dates must be real dates: the quarter is taken from the month. |
| Invoices issued: one row per invoice. Type rates as percentages (21 %, 15 %). Exempt income goes at 0 % and counts in the 130. |
| Expenses: one row per supplier invoice with deductible IVA. Mark investment goods with an x: their IVA goes to boxes 30-31 and they are not an IRPF expense (add their amortisation to the summary row of other expenses). |
| Summary: shaded cells are for your data. The quotas are base × rate per rate, rounded to the cent, as on the 303. Amounts to compensate and negative 130 results are carried over to the next quarter automatically. |
| Not covered: recargo de equivalencia, simplified regime or modules, prorrata, intra-EU and reverse-charge operations, cash accounting, box 16 of the 130, corrective returns. National and regional holidays don't move the filing periods here. |
| Box numbers, rates and reduction tiers: AEAT, instrucciones del modelo 303 (ejercicio 2026, Orden EHA/3786/2008 modificada por Orden HAC/27/2026) y del modelo 130; Reglamento del IRPF (RD 439/2007), arts. 110 y 111 (BOE-A-2007-6820). Valid from 2026-01-01 to 2026-12-31. |
| https://sede.agenciatributaria.gob.es/Sede/todas-gestiones/impuestos-tasas/iva/modelo-303-iva-autoliquidacion_/instrucciones-2026.html |
| ƒx |
| ƒx |
| Indicative template generated by eines. It is not tax or legal advice; check the official forms before filing. |
How it works
The file is generated in your browser, in the language of this page, and nothing is uploaded. In the tax tracker you write one row per invoice (date, base, IVA rate, IRPF withholding rate) and one row per expense; mark investment goods with an x so their IVA goes to boxes 30-31 and they don't count as an IRPF expense. The summary adds up each quarter: IVA charged per rate (boxes 01-09 and 150-152), deductible IVA, result 46/66 and the amount to compensate carried over to the next quarter, and for the 130 the cumulative income, expenses, the 20 %, earlier payments, withholdings and the reduction of up to 100 €. Box numbers and rates come from the same dated rule table as the quarterly models tool.
Rent ledger
Enter the start date and the monthly rent on the contract sheet and the payments sheet fills in the months and the rent due. When the annual update arrives, write its date and the variation (IPC, IRAV or the one agreed in the contract) in the update table: from that month on the new rent is used. Balance = amount paid minus rent and other charges.
Limits
The tax tracker covers the same cases as the quarterly models tool: general IVA regime, direct estimation, no recargo de equivalencia, no prorrata, no intra-EU operations. It's a helper for keeping your accounts: check the result in the AEAT programs before filing.
Related tools: Spanish forms 303 and 130: quarterly boxes for the self-employed · Update rent in Spain by CPI (IPC) or IRAV · Spanish invoice template for freelancers (IVA and IRPF)
How to use it
- Choose the Template: the quarterly tax tracker (models 303 and 130) for freelancers, or the rent ledger for landlords and tenants.
- Read the Structure of the spreadsheet preview. It shows each sheet with its columns; cells marked ƒx hold a formula and shaded cells are for your data.
- For free, press "Download the empty layout (CSV, free)" to get the sheets, columns and labels without formulas.
- With Pro, press "Download the .xlsx" to get the real workbook, in the language of the page, with every formula already in place.
- Open it in Excel, LibreOffice or Google Sheets and fill in the shaded cells. In the tax tracker add one row per invoice and per expense; in the rent ledger fill in the contract sheet first.
Worked example
In the tax tracker, a freelancer issues one invoice in the first quarter with a taxable base of 3,000 € at 21 % IVA, so the IVA charged is 630 €. Expenses that quarter are a base of 500 € at 21 %, so deductible IVA is 105 € and the IVA result to pay is 525 €. For model 130, income is 3,000 € and expenses 500 €, so net earnings are 2,500 € and 20 % of that is 500 € before withholdings and reductions. In the rent ledger, a rent of 800 € with an update of 2.2 % becomes 800 × 1.022 = 817.60 € from the month of the update.
Frequently asked questions
Do the templates replace models 303 and 130?
No. They are a helper to keep your invoices and expenses in order and to see what each quarter's boxes should roughly be. You still file in the tax agency's own forms. The workbook states it is indicative and not tax advice, so compare its result with the official program before you submit anything.
Which tax situations does the tracker cover?
The general IVA regime with direct estimation for IRPF. It does not cover recargo de equivalencia, the simplified regime or modules, prorrata, intra-EU or reverse-charge operations, cash accounting or corrective returns. Mark investment goods with an x so their IVA goes to boxes 30 and 31 and they don't count as an IRPF expense.
How do I use the rent ledger when the rent is updated?
Enter the start date and monthly rent on the contract sheet. When an annual update arrives, write its date and the variation as a percentage (IPC, IRAV or what the contract says) in the update table. The new rent is the previous one times one plus the variation, rounded to the cent, and the payments sheet uses it from that month.
Will it open in Excel and Google Sheets?
It is a standard .xlsx, but I can only vouch for LibreOffice: a filled sample was opened and recalculated there, and the 303 and 130 boxes of four quarters matched the quarterly models tool. It has not been opened in Excel or Google Sheets yet, so check a sample row in your program first.
Why one file per year?
The summary sheet is built for one calendar year, with the quarters, rates and filing periods of that year, and amounts to compensate carry over from quarter to quarter inside the file. Dates must be real dates because the quarter is taken from the month. Start a fresh file each January so the rules and carry-overs don't mix.
Everything is calculated in your browser: this site doesn't send what you type anywhere.