Free Rental Property Cashflow Spreadsheet Template for Google Sheets & Excel
One rental, one month, 15 lines, with what you budgeted set against what actually happened and a difference on every line. The Free Rental Property Cashflow spreadsheet template takes income positive and costs negative so the foot of the sheet is net cashflow, and includes reserve lines for maintenance and vacancy. How to Use on a second tab. Google Sheets or Excel, one file. No macros, no VBA, no sign-up.
The FinancialAha Free Rental Property Cashflow Spreadsheet Template is a one-sheet workbook for Google Sheets and Excel, with a How to Use guide on a second tab. It works as a Free Rental Property Cashflow Excel template and a Free Rental Property Cashflow Google Sheets template from the same download. This Free Rental Property Cashflow spreadsheet template sets what you expected a rental to produce against what it actually did, line by line, and lands on the net cashflow for the month. No macros, no VBA, no sign-up.
Inside the workbook
What's inside the FinancialAha Free Rental Property Cashflow spreadsheet template
The FinancialAha Free Rental Property Cashflow Spreadsheet Template runs on a single working sheet, with the instructions on a tab of their own. It works in both Microsoft Excel and Google Sheets and here is what the Free Rental Property Cashflow spreadsheet holds.
01of 01
Rental Cashflow
One property for one month, a line per item - rent and any other income at the top, then the mortgage, tax, insurance, association fees, management, reserves, utilities and repairs beneath. Each line carries what you budgeted, what actually happened and the gap between them. The layout depends on one convention: income goes in positive and costs go in negative, which is what makes the total at the foot net cashflow rather than an arbitrary sum. Reserves for maintenance and vacancy sit there as costs even in a month when nothing was spent, so the figure describes a normal month rather than a lucky one.
Rental Cashflow
Included guide
How to Use
A step-by-step guide on its own tab, covering the sign convention, how to replace the sample values, and how to change the currency. Because it ships inside the file, the instructions travel with the template wherever it is opened.
Works in both Google Sheets and Excel
Free Rental Property Cashflow Spreadsheet template for Google Sheets
Upload the Free Rental Property Cashflow Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Free Rental Property Cashflow Google Sheets template needs no conversion step and nothing gets rewritten on the way in - the totals recalculate exactly as they do in Excel. The currency dropdown beside the title relabels each money column, and the whole Free Rental Property Cashflow spreadsheet is small enough to open instantly.
Free Rental Property Cashflow Google Sheets template setup
A shared copy of the Free Rental Property Cashflow Google Sheets template works when a property is owned between two people, or when a bookkeeper fills the actual column. Sheets version history covers a figure typed over, and the Free Rental Property Cashflow Spreadsheet Template fits on a screen so nothing needs scrolling past.
Sharing the Free Rental Property Cashflow Google Sheet
One approach is to set the budgeted column once and fill the actual column as the month runs. The Free Rental Property Cashflow Google Sheet updates the difference and the net figure on every entry, so the month's position is current rather than something worked out at the end.
Free Rental Property Cashflow Spreadsheet template for Excel
The Free Rental Property Cashflow spreadsheet Excel download is a plain .xlsx. Excel opens this Free Rental Property Cashflow Excel template directly, with no import step and no compatibility prompt, and every total updates the moment a figure changes. There are no macros and no VBA in the file, so it opens without a security warning.
The same Free Rental Property Cashflow Excel template opens in Excel on Windows, Excel on Mac, and Excel for the web. It is also the identical file you would upload to Drive, so there is no separate Free Rental Property Cashflow spreadsheet download to choose between.
The Free Rental Property Cashflow spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt. The same Free Rental Property Cashflow spreadsheet Excel download also opens in Excel for the web, which matters when a figure needs checking away from a desk.
Opening the Free Rental Property Cashflow spreadsheet Excel file
Nothing in the Free Rental Property Cashflow Excel template is version-specific, so this Free Rental Property Cashflow spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.
The FinancialAha Free Rental Property Cashflow Spreadsheet Template covers one property for one month, with the plan set against what happened. Everything is a flat amount here - there are no percentages, and no return figures at all. The Essentials Rental Property Cashflow Spreadsheet Template for Google Sheets and Excel turns it into a property model: vacancy, maintenance reserve and management fee become rates rather than amounts, the mortgage is worked out from the loan, and it reports cap rate, net operating income, cash-on-cash return and an expense ratio alongside a twelve-month tracking table and two charts. The Ultimate Rental Property Cashflow Spreadsheet Template carries up to five properties with a portfolio cap rate, per-property ROI including gross rent multiplier, and sensitivity grids showing what happens to cashflow as rent and vacancy move.
Notes on working in the Free Rental Property Cashflow spreadsheet template
Income goes in positive and costs negative, which is what makes the row at the foot net cashflow.
The Difference column is actual less budgeted, so it points in opposite directions on a rent line and a cost line.
There are no percentages here - vacancy and maintenance go in as flat amounts rather than rates that scale with the rent.
This build covers one month at a time.
The dropdown beside the title relabels the money columns. It changes the label and nothing else.
How the Rental Property Cashflow template works
The Free Rental Property Cashflow Spreadsheet Template covers one rental for one month: rent and other income at the top, then mortgage, tax, insurance, association fees, management, reserves, utilities and repairs. Each line carries what you budgeted, what actually happened and the gap. The layout depends on one convention - income positive, costs negative - which is what makes the total at the foot net cashflow rather than an arbitrary sum. Reserves for maintenance and vacancy sit there as costs even in a month when nothing was spent, so the figure describes a normal month rather than a lucky one.
When this template helps
01
You own one rental and want to know what it actually put in your pocket this month.
02
You want the plan and the outcome side by side, rather than only the bank balance.
03
A property is owned between two people and you both need the same figures.
04
You would rather keep a file than pay for property management software.
Tips to get the most out of it
Reserves belong in the budgeted column even in a month when nothing is spent, so the figure describes a normal month rather than a lucky one.
A copy per month is what turns this into a series, since one file covers one month.
Rates that scale with the rent are what the paid builds add; here the flat amount has to be revisited when the rent moves.
Common mistakes to avoid
Entering the mortgage as a positive number. The total stops meaning anything the moment income and costs are added together.
Leaving vacancy and maintenance out because nothing happened this month. A property that has never been empty still will be.
Reading the total as a return. It is cashflow for the month - cap rate and cash-on-cash are on the Essentials build.
Treating this as a year. It covers one month, so a year means a copy per month.
How to Use the Free Rental Property Cashflow Spreadsheet Template
1
Enter the rent
Rent and any other income go in as positive amounts.
2
Enter the costs as negatives
Mortgage, tax, insurance, management and the rest. The minus sign is what makes the total work.
3
Budget the reserves
Maintenance and vacancy belong in the plan even in a month when nothing is spent.
4
Fill the actual column
Record what really happened. The difference and the net figure settle themselves.
We use Claude AI to draft each template, after a deep research. Then our team steps in. We refine the layout, stress-test every formula, fix edge cases, and polish the design until it feels like something we would actually use ourselves. The AI gets us 80% there. The last 20% is all human judgment.
Excel
Sheets
No signup
Download instantly, no email required
Formula-driven
All calculations update automatically
Dual compatible
Works in Excel and Google Sheets
Sample data included
See the template in action right away
Frequently Asked Questions
What is the difference between the free, Essentials, and Ultimate Free Rental Property Cashflow spreadsheet template?
Free is a single-sheet starter template with sample data and a How to Use guide. Essentials ($19) is the fuller build - more capacity, more detail, and more worked out for you rather than typed. Ultimate ($29) goes further again, usually six working sheets, giving each part of the template its own sheet and adding deeper reporting on top. What each tier holds differs by template - the comparison table on every template page lists it exactly.
Which Free Rental Property Cashflow spreadsheet template should I download?
Upgrade to Essentials if you want a dashboard with charts, more categories, larger capacity, and a more polished spreadsheet for ongoing use. The Free version is a good fit for one-off planning or trying out the layout.
Can I upgrade the Free Rental Property Cashflow spreadsheet template later?
Essentials is a one-time $19 purchase with no subscription. It typically adds a full dashboard, 30-50% more categories or rows than the Free version, and richer formulas. Most buyers upgrade after using the Free version for a few weeks and hitting its limits.
Is the FinancialAha Free Rental Property Cashflow Spreadsheet Template a Google Sheets template?
Yes. Upload the file to Drive and choose "Open with Google Sheets". Nothing needs rewriting in the Free Rental Property Cashflow Google Sheets template, and the currency dropdown still relabels the money columns.
Is the FinancialAha Free Rental Property Cashflow Spreadsheet Template an Excel template?
Yes. The download is a plain .xlsx, so the Free Rental Property Cashflow Excel template opens directly in Excel with no import step. There are no macros and no VBA, so it opens without a security warning.
Will the Free Rental Property Cashflow spreadsheet Excel file open in older versions of Excel?
Yes. The Free Rental Property Cashflow spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.
Why does the FinancialAha Free Rental Property Cashflow Spreadsheet Template want costs entered as negatives?
Because that is what makes the total at the foot net cashflow. Add rent and a mortgage payment together as positives and the figure means nothing - income positive, costs negative, and the total is what the property actually produced.
Does the Free Rental Property Cashflow spreadsheet work out cap rate or cash-on-cash return?
No. There are no return figures in this build at all - it is a monthly cashflow sheet. Cap rate, net operating income, cash-on-cash return and an expense ratio are on the Essentials build.
Can I enter vacancy as a percentage in the Free Rental Property Cashflow spreadsheet template?
Not here. Everything in this build is a flat amount you work out yourself. Vacancy, maintenance and management as rates that scale with the rent is what the Essentials build adds.
Is the Free Rental Property Cashflow spreadsheet template safe to download?
Yes. No macros, no sign-up, no tracking. The file is a plain .xlsx that opens directly in Excel or Google Sheets.
How do I open the Free Rental Property Cashflow spreadsheet template in Google Sheets?
Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.
Can I use the Free Rental Property Cashflow spreadsheet template for commercial work?
All free templates are released under CC BY 4.0 (Creative Commons Attribution). You can use, modify, and share them freely - including for commercial purposes - as long as you credit FinancialAha.com. They are provided as-is and do not constitute financial advice.
