Skip to content
Spryhand

Real Estate & Landlords

Rental Property Income & Expense Tracker

Log rent collected and expenses paid across one or more properties, with automatic monthly and annual totals.

Delivery
Instant download
Purchase
One-time payment
Format
  • Google Sheets
  • Excel
Updated
August 2026
$5.90Buy on Etsy
Sample preview — illustrative data

Collected

94.8%

Net received

$26,022

PropertyArrears
  • Maple St duplex$31,200 / $28,850 — $2,350 owed
  • Oak Ave condo$14,000 / $14,000 — nothing owed

Sample data preview of the Rental Property Income & Expense Tracker spreadsheet, shown for illustration only.

What this spreadsheet does

Landlord income and expenses are often scattered across bank statements and receipts, making year-end numbers hard to reconstruct.

What you can do with it

  • Track rent collected each month across units
  • Log repair and maintenance expenses by property
  • Prepare organized numbers for tax filing

What's included

Sheet tabs

  • Instructions
  • Annual Summary
  • Rent Roll
  • Expense Log

Features

  • Rent due and rent received tracked separately, so arrears are a number rather than a surprise
  • Per-charge status: Paid, Part paid, Unpaid or Void — an empty unit is not an unpaid one
  • Expense log across eight categories, each cost marked Repair or Improvement
  • Twelve monthly rows of due, received, arrears, expenses, net and collection rate
  • Per-property breakdown for multi-property owners
  • A repairs subtotal kept separate from capital improvements

How it works

  1. 1Add one Rent Roll row per unit per month, with rent due and rent received entered separately
  2. 2Log each cost on the Expense Log, marked Repair or Improvement
  3. 3Set the year on Annual Summary — monthly totals, arrears and the per-property split follow

Who it's for

Landlords managing one or more rental properties.

Frequently asked questions

Can I track multiple properties?

Yes, each row is tagged by property so the Annual Summary tab can break totals down per property.

Is this enough for tax filing?

It gives you a year of categorised costs with repairs kept separate from capital improvements — the split that changes how a cost is treated. It's a bookkeeping aid, not tax advice; the treatment differs by country, so confirm the figures with an accountant.

Does it show me who is behind on rent?

That's the reason it exists. Rent due and rent received are separate columns, so every charge is marked Paid, Part paid, Unpaid or Void, and arrears accumulate month by month. A tracker that only records what arrived can't show a tenant slipping behind until it's a legal problem.

What if a unit is empty between tenancies?

Enter the rent due as 0 and the charge reads Void, not Unpaid. They're different problems — one costs you a tenant, the other costs you a tenant and a debt-recovery process.

Complete the setup

The rest of the tools this one was built to sit beside.

Similar tools

The same kind of tool, for a different job.