For landlords
Income & Expense Tracker
Rent in, costs out, one row at a time. At the end of the year the numbers are already added up.
- Excel + Google Sheets
- Per-property totals
- Instant download
What it does
Rent in, costs out, one row at a time. At the end of the year the numbers are already added up.
Rental bookkeeping goes wrong in the same way every year: the numbers exist, but they exist in a bank app, a shoebox and three email threads, and pulling them together in March takes a weekend.
This file is the place you put them as they happen. Rent received on one sheet, costs on another, each line tagged with the property it belongs to. That is the whole discipline.
The totals then look after themselves: what each property brought in, what it cost to run, and what is actually left once the boiler service and the letting fees come out. Which of your properties earns its keep stops being a feeling and becomes a number.
What you get
Everything in the download.
- Income and expense logging, one line per transaction
- Everything tagged by property
- Per-property and whole-portfolio totals worked out for you
- Expense categories that match how rental costs actually arrive
- Opens in Excel or Google Sheets, no macros
- A written guide that walks through the first month
Questions
Worth knowing first.
Will this do my tax return?
No, and it does not pretend to. It puts your figures in one place in a form your accountant can read without ringing you. Tax rules differ by country and change; this file does not guess at them.
How many properties does it handle?
It is built for a small portfolio rather than an agency. If you own a handful of units it is comfortable.
Can two people use it?
Yes. Put it in Google Sheets and share it with whoever else needs to add lines.
Landlord Spreadsheet: Rental Property Income and Expense Tracker
Bought and downloaded on Etsy. One payment, instant download, and the file is yours to keep.