Rental Property Tracker Spreadsheet, Multi-Property Cash Flow Analysis (Excel/Google Sheets)

Every door, every dollar, and which one is actually earning.

A portfolio can look fine in total while one property quietly eats the others. This file works out each door separately so that cannot happen without you noticing.

WHAT YOU GET — 5 tabs

START HERE — What to do, in four steps.
PROPERTIES — Purchase, down payment, loan balance, rate, expected rent.
LEDGER — Every transaction, tagged to a property and a category.
PERFORMANCE — Cash flow, cash-on-cash return and expense ratio per door.
DASHBOARD — Portfolio totals, plus any door running negative.

HOW IT IS BUILT

No macros. No array formulas — those collapse silently in Google Sheets, which is why so many templates break the moment you open them somewhere else. Every formula is an ordinary one that older versions of Excel read too.

No gridlines, because every line you see was put there on purpose. Every number is typed once and read everywhere else. You fill in the ruled cells; everything else is a formula.

WHAT YOU NEED

Microsoft Excel, or Google Sheets with a free Google account. Mac and Windows. Nothing to install and nothing to sign up for.

HOW YOU GET IT

Instant download. The moment the payment clears, the file is on your Downloads page and in your email — nothing is posted to you and nothing ships. If you are on a phone, download it on a computer: spreadsheets are miserable to set up on a small screen.

WHAT THIS IS NOT

It is a file, not software and not a service. There is no app, no login and no cloud account. It does not connect to your bank and it never sees your money — you type what you want it to know. And it is a record-keeping tool, not financial, tax or legal advice.

QUESTIONS PEOPLE ASK

Do I need Microsoft Excel?
No. It opens in Excel, and it opens in Google Sheets with a free Google account. Upload the file to Google Drive, open it with Sheets, and it behaves the same. Mac and Windows both fine.

Will the formulas break when I open it in Google Sheets?
No, and that is deliberate. There are no array formulas anywhere in this file. Those are the ones that collapse silently when a spreadsheet moves between programs, and they are why so many templates arrive broken.

Can I change the categories and the labels?
Yes. Every list, label and category is yours to rename. Nothing is locked and there are no macros to enable.

Is this a subscription?
No. You buy the file once and it is yours. No account, no monthly fee, nothing to renew.

What if something does not add up?
Message me. I built it, I will fix it, and you will get the corrected file.

LICENSE

Use it for yourself, your household or your own business, on as many of your own devices as you like. Do not resell it, share the file, or pass it on as your own.

Built by BenchMark Ink. Tools made by someone who had to use them.

NEED A HAND?
If something is not working, or you would like a change to fit how you use it, message us. We will fix it, re-edit it and send you a new version, or walk you through it. Every download comes with real help.