What’s in your download

Your blank spreadsheet – ready for your own details (Excel and Google Sheets), with a Country setting for the UK, USA, Canada, Australia and New Zealand
A filled-in EXAMPLE copy – the same sheet with an example rental portfolio, so you can see every tab working
A full PDF user guide – choosing your country, every tab explained, a simple routine, a worked example, the rules where you are (with official sources), troubleshooting and FAQs

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

Purchase and download the files
Open in Excel, or upload to Google Drive and open with Google Sheets
Pick your country on the Settings tab – wording, currency and rules switch to match
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!

rent ledger

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