Rental Income & Expenses Tracker — Landlord Tax Year Summary Spreadsheet (International)

Description

Twelve months of rent, repairs and receipts – and a tax form that wants it all sorted into boxes. This keeps your rental income and costs in one place and sorts them by your country’s tax lines as you go.

Sound Familiar?

• A shoebox (or inbox) of receipts every tax year
• Not sure which tax-form line a cost belongs on
• Late rent you only noticed weeks later
• No clear view of which property actually makes money

That’s not a you problem – it’s a missing-system problem.

Your Rental Records, Sorted by Tax Line

Log rent, other income, expenses and mortgage interest once. The Tax Year Summary groups everything per property and in total under your country’s form lines, splits it into the right tax year automatically, and the Dashboard shows income, costs and profit by month and by property.

Pick Your Country

• UK – SA105 lines, 6 April tax year, Section 24 finance-cost credit, MTD-ready records with a quarterly view (does not submit to HMRC)
• USA – Schedule E lines, calendar tax year
• Canada – T776 lines, calendar tax year
• Australia – rental schedule items, 1 July tax year
• New Zealand – IR3R lines, 1 April tax year

Bonus: See It in Action

Your download includes a fully filled-in example portfolio.

What’s Inside

• Dashboard – income, costs and profit by month and property
• Properties and Tenancies – your lets, ownership share and rent due
• Rent Ledger – rent due and paid with late flags
• Other Income, Expenses and Mortgage Interest logs
• Tax Year Summary – totals per tax-form line, per property and in total
• Tax Map – see and change which line each category goes to
• Settings – country, currency, tax rate and theme
• Start Here – a plain-English guide built into the workbook

Format

Instant digital download – works in Microsoft Excel, Google Sheets and LibreOffice, on Mac, PC, Chromebook or tablet. No macros, no add-ons, no subscription.

How It Works

1. Purchase and download the files
2. Open in Excel, or upload to Google Drive and open with Google Sheets
3. Pick your country on the Settings tab – wording, currency and rules switch to match
4. Log rent and costs as they happen – the tax-year summary builds itself

Please Note

This is a digital product – no physical item will be shipped or posted. Figures are estimates to help you prepare your return, not tax advice; depreciation and capital allowances are not calculated (enter your own figure). Rules are shown “as of 29 Oct 2026 – check before relying on this” and can be edited in the sheet. For personal/business use only, please don’t resell or share the file.

Questions before you buy? Email hello@spreadsheetland.com – happy to help!