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.

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)

Everything is calculated in your browser: this site doesn't send what you type anywhere.