Hale & Co product · Landlord workbook

Small Landlord Rent & Expense Tracker

By Jordan Hale · Updated · $11 one-time (regularly $14) Black Friday price through 1 Dec 2026

Short answer: A $11 recordkeeping workbook (regularly $14; Black Friday price through 1 Dec 2026) for landlords with 1–10 units. You log rent and bills in one ledger, see who is late, and open a per-tenant year view — in Excel 2016+ or Google Sheets.

Small Landlord Rent & Expense Tracker cover

Question this page answers: “simple spreadsheet to track rent and expenses for a small landlord.” This is a recordkeeping workbook for people with a handful of units and a day job, not a property-management cockpit.

Disclosure: this is a Hale & Co product. If you buy through the link on this page, we earn the sale. Facts about third-party tools on this site are still sourced from those vendors' official pages. How we make money.

Buy for $11 on Gumroad Questions? Email us

What you get

How it works

  1. Set your year, due day, and grace days once on Start Here.
  2. Add units and tenants. Security deposits are tracked as amounts you are holding, not as rent income.
  3. Log one row per rent period. Leave Amount due blank to use the scheduled rent, or type a prorated amount for a mid-month move-in (a 30-day suggestion is on Properties).
  4. Status fills in for you: PAID, LATE, PARTIAL, DUE, or UNPAID. Days late and an optional late-fee suggestion follow your settings. You type the fee you actually charge, and only if your lease and local law allow it.
  5. Pick a unit and a year on Tenant Year. The twelve months populate from the ledger. You do not keep a second set of books.

What this is not

Compared with free alternatives and named templates

A blank Google Sheet or Excel ledger is free if you are comfortable writing the formulas yourself. This one ships the due-day and grace logic, late flags, a per-tenant year view, and a dashboard already wired. Named products we actually opened (prices and review counts from those pages or archives; no invented ratings):

ProductWhat we sawHow this workbook differs
A blank Sheet or Excel fileFree; you write the formulasShipped logic for due day, grace, late flags, Tenant Year, and Dashboard
TheGoodSheets “Landlord Rental Property Spreadsheet” (Etsy)$7.54, 126 item reviews, 12 monthly tabs (archived Aug 27, 2026) sourceSix tabs and one rent ledger, not a tab per month
FinanceMadeSimpleINC (Etsy)A 2-star review from Carol called setup “convoluted”; a 4-star review from Kaleigh said “Unable to save to computer correctly.” (archived Jan 8, 2026) sourceAn .xlsx file you can save, plus a Sheets import path
HeyMorning (Etsy)13 tabs; listing FAQ said Google Sheets can be glitchy or view-only and to open from a computer (archived Aug 13, 2026) sourceSix tabs; in Sheets, File > Import, then File > Make a copy. Setup is still easier on a computer.
Timberwolf “Rental Income Tracker” (Gumroad)$19, up to 10 properties, 30 rent rows and 30 expense rows, due on the 1st with a 5-day grace hard-coded source600 rent rows and 600 expense rows; you set due day, grace days, and late-fee method (including Off)

A landlord on r/Landlord looking for a rental tracker called some Etsy templates “way too much stuff and looks chaotic.” Related on this site: the rent-collection fee comparison — that page is a software directory. This tracker is a Hale & Co spreadsheet and does not collect rent.

Works with

Microsoft Excel 2016 and later (Windows or Mac) and Google Sheets. Common functions only, so you are not locked into Microsoft 365. Setup is easier on a computer.

Refunds

Digital download. If a file won't open, email [email protected] and I'll fix it or refund you.

Screenshots

Questions and answers

Does this work in Excel and Google Sheets?

Yes. You get .xlsx files that open in Excel 2016 or later. In Google Sheets, use File > Import, then File > Make a copy so you are not stuck in view-only mode.

How many units can I track?

Ten units, plus an "All" tag for bills that cover every unit. There are 600 rent rows and 600 expense rows — enough for 10 units across several years. See "Can I add more rows?" if you outgrow that.

Does it do my taxes or fill out a Schedule E?

No. It keeps a rent and expense record you can hand to an accountant. Totals are not net operating income or a tax figure, and deposits you are holding are not counted as rent income.

Does it charge late fees automatically?

It flags late or unpaid rent from the due day and grace days you set, and it can suggest a flat or percent fee. You type the amount you actually charge, and only if your lease and local law allow it. The suggestion is not legal advice and is not a legally required fee.

Can I add more than 600 rent or expense rows?

The shipped file has 600 formula rows on each ledger. If you need more, copy a blank formula row down, or email me and I will tell you how. You should not need to for 1–10 units.

Can I use it on a phone?

Setup is easier on a computer. We have not verified the Google Sheets or Excel mobile apps, so we do not claim you can log payments from a phone.

What if the file won't open?

Email [email protected]. I will help you get it open in Excel or Google Sheets, or refund you.

Answers restate the sourced facts above.

Related landlord software

If you need online rent collection instead of (or as well as) a workbook: TurboTenant · RentRedi · Baselane.

Other Hale & Co products (our own products)

Reading Library & Book Club Tracker

Our own product · $7 one-time (regularly $9)

Reading Library & Book Club Tracker

A $7 recordkeeping workbook (regularly $9; Black Friday price through 1 Dec 2026) for your shelf and your club. Track format, library due dates, series, a yearly goal you set, and book-club meetings — in Excel 2016+ or Google Sheets. Optional Goodreads export paste.

Black Friday price through 1 Dec 2026

Details Buy for $7 on Gumroad