Free Rental Cash Flow Spreadsheet – Download & Setup

Want to know instantly if your rental property is profitable?
This guide delivers a free rental property cash flow spreadsheet plus a step‑by‑step walkthrough so you can stop guessing and start seeing real numbers in seconds. Download, plug in your data, and watch the profit (or loss) appear automatically.

The chaos of juggling receipts and spreadsheets

When you track rent, mortgage, repairs, and taxes in separate notebooks or sheets, you’ll spend hours reconciling numbers each month. The result? Missed expenses, hidden vacancy loss, and no clear picture of cash flow.

The core problem: no single place to see income vs. out‑goings at a glance.

The simple fix: a free spreadsheet that does the heavy lifting

1️⃣ Download the template

Visit the Rental Insights resources page and click “Download Google Sheet” (or the .xlsx version for Excel).
Save the file to your drive – File → Make a copy for your own property.

2️⃣ Populate the Inputs tab

Enter raw figures in the green cells:

Rent Received – monthly rent you collect.
Mortgage Payment – principal + interest.
Property Taxes & Insurance – fixed recurring costs.
Utilities, Repairs & Maintenance – any variable expense.
Vacancy Loss – estimate the monthly rent you lose when a unit is empty.

Tip: Add custom rows for unique costs like pest control or legal fees; the sheet will automatically incorporate them.

3️⃣ Let the Calculations tab do the math

All formulas are hidden here. As soon as you update Inputs, the sheet recalculates:

Total Income
Total Expenses
Net Cash Flow (month‑by‑month and annual total)

4️⃣ Review the Summary tab

A quick snapshot shows:

Total profit for the year.
Average monthly cash flow.
A bar chart visualizing income vs. expenses – instant profit snapshot without manual chart work.

Key features you’ll love

One‑click vacancy accounting – just type the estimated loss and the calculator factors it in.
Live Google Sheets chart – updates automatically as you type, perfect for on‑the‑go phone updates.
Optional CapEx tab – plan big upgrades (roof, appliances) and see long‑term cash‑flow impact.
Excel compatibility – same formulas work in .xlsx; enable macros if prompted (they’re not required but safe to keep on).

Quick setup checklist

Step	Action	Done?
1	Make a copy of the Google Sheet	☐
2	Fill every green cell in Inputs with your numbers	☐
3	Verify the Summary chart reflects your data	☐
4	Add any custom expense categories you need	☐
5	Save and bookmark the sheet for monthly updates	☐

How to keep your cash‑flow tracking accurate

Update monthly – spend 5 minutes after rent collection to log new numbers.
Include every small expense – a $15 pest‑control bill matters over a year.
Review quarterly – compare the Summary profit to your bank statements to catch any discrepancies.

Wrap‑up: why this spreadsheet changes the game

Having a single, automated view of your rental cash flow eliminates guesswork, reduces nightly stress, and empowers data‑driven decisions—whether that means raising rent, scheduling a repair, or planning a new acquisition.

Ready to take control? Download the free template now, follow the steps above, and start seeing real profit numbers each month.

If you found this guide helpful, subscribe to Rental Insights for more landlord tools and share the post with fellow property owners who need a clearer financial picture. Happy tracking!