The Best Rental Property Cash Flow Spreadsheet (Free Template + 2026 Guide)
Not sure whether your rental is actually making money once every bill is paid? This guide shows you how to build and use a rental property cash flow spreadsheet, with a free template, a worked example, and the formulas investors rely on.
Key Takeaways
- Cash flow = rental income minus operating expenses minus debt service. Your spreadsheet should calculate it monthly and annually, before and after capital expenditure reserves.
- Track three metrics beyond cash flow: net operating income (NOI), cap rate, and cash on cash return. Together they tell you whether a property is a good investment, not just whether it broke even this month.
- Budget conservatively. Plan for a 5% to 10% vacancy rate on long-term rentals, use realistic occupancy for short-term rentals, and set aside roughly 1% of the property value each year for upkeep.
- Small swings matter. In our worked example, a five-point drop in occupancy turns a positive net cash flow into a loss, which is why sensitivity analysis belongs in every rental property analysis.
- Spreadsheets are a great start. Once you manage multiple units or several booking channels, software that pulls your numbers automatically saves hours of data entry.
A rental property cash flow spreadsheet is the simplest way to see whether your rental business is profitable, where your money goes each month, and how a property compares to other investment options. If you only check your bank balance, it's easy to miss slow leaks like rising insurance premiums or a cleaning bill that crept up 15%.
We'll walk through what to include, how to calculate cash flow step by step, which metrics real estate investors use to judge a deal, and the mistakes that quietly eat into a rental property's profitability. Then you can grab our free template and start plugging in your own numbers.
What Is a Rental Property Cash Flow Spreadsheet?
A rental property cash flow spreadsheet is a simple spreadsheet, usually built in Microsoft Excel or Google Sheets, that records every income source and expense for a rental property and calculates the money left over after operating costs and loan payments. It gives property owners a clear picture of their rental property finances and helps them make informed decisions about pricing, spending, and future purchases.
Rental property templates simplify financial record-keeping, and tracking every expense consistently boosts profitability while taking a lot of the stress out of tax season. Think of it as a profit and loss statement and a deal analyzer in one. You use it to track income and expenses for a property you already own, and to run the numbers on a property you're thinking of buying before you settle on an offer price.
What to Include in Your Rental Property Spreadsheet
The best rental property spreadsheet is one you'll actually keep up to date. Start with these five sections.
1. Property Details and Initial Investment
Every good spreadsheet opens with the basics: property address, property type, number of units, purchase price, and your total initial investment. That last figure includes your down payment, closing costs, inspection fees, and any upfront costs like furnishing a short-term rental or renovating before your first guest.
If you need a starting point for property valuation, compare recent sales of similar homes nearby with a comparative market analysis, or check estimates from Zillow and Redfin. Our guide on how to value a rental property covers the methods in more depth.
2. Rental Income
List every income source separately so you can easily identify which ones are growing and which are slipping:
- Monthly rent or booking revenue: For a long-term rental, this is your monthly rent. For a short-term rental, it's your nightly rate multiplied by booked nights.
- Fees: Cleaning fees, pet fees, parking, early check-in, or late checkout.
- Other income: Laundry, storage, add-on services, or local experiences you sell.
Then adjust for reality. Effective rental income is your potential rental income minus vacancy and credit losses. For long-term rentals, most investors use a 5% to 10% vacancy rate. For short-term rentals, use a realistic occupancy rate based on comparable listings in your market, not your best month.
If you run a portfolio, add a simple rent roll tab that shows each unit, its rent or average nightly rate, and its booking status.
3. Operating Expenses
Operating expenses are the recurring costs of keeping the property running. Common rental property expenses include:
- Property taxes based on your local assessment
- Insurance, including landlord or short-term rental coverage
- Utilities you cover, such as water, electricity, gas, internet, and trash
- Repairs and routine maintenance, like HVAC servicing or appliance fixes
- Cleaning and laundry, a major line item for short-term rentals
- Property management fees, if you use a manager or co-host
- Platform and payment fees from booking channels
- Supplies such as toiletries, linens, and cleaning products
- HOA fees, pest control, landscaping, and pool care
- Professional services for accounting, legal help, or tax preparation
- Licenses, permits, and software subscriptions
- Other expenses that are unique to your property
Good spreadsheet practice is to keep a column for estimated costs and a separate column for actual costs. Comparing the two each month shows you where your projections were too optimistic.
4. Financing and Debt Service
If you financed the purchase, record the loan amount, interest rate, loan term, and monthly payment. Your total debt service is the principal and interest you pay each year. Interest payments are often the single largest cost in a rental property cash flow spreadsheet, so even a small change in your interest rate can make or break a deal.
5. Capital Expenditures
Capital expenditures (CapEx) are big, infrequent costs like a new roof, water heater, or flooring. You won't pay them every month, but they will come. Set aside a monthly CapEx reserve in your spreadsheet so these capital investments don't wipe out a year of profit when they hit.
How to Calculate Cash Flow for a Rental Property
Here's the cash flow analysis in four steps.
- Calculate effective gross income: Potential rental income + other income - vacancy and credit losses
- Calculate net operating income (NOI): Effective gross income - operating expenses
- Subtract debt service: NOI - annual mortgage principal and interest
- Subtract your CapEx reserve: The result is your net cash flow
Put simply:
Cash Flow = Gross Rental Income - Operating Expenses - Debt Service
That's your cash flow before reserves. Subtract your CapEx reserve to get net cash flow, then divide the annual figure by 12 to get your monthly cash flow.
Worked Example: A Short-Term Rental
Here's how the numbers might look for a hypothetical short-term rental bought for $350,000 with 25% down. All figures are illustrative, so swap in your own.
The property has positive cash flow: income covers every expense, the loan, and the reserve, with some money left over. If the result were below zero, you'd have negative cash flow and would be covering the gap out of pocket.
Now run a quick sensitivity analysis. Drop occupancy from 60% to 55% (about 201 booked nights) and keep everything else the same. Booking revenue falls to about $42,200, and the property swings to a loss of roughly $1,050 a year. That's why it's extremely important to test a few "what if" scenarios before you buy, especially in seasonal markets.
Key Metrics to Track: NOI, Cap Rate, and Cash on Cash Return
Cash flow tells you what landed in your account. These three metrics tell you how good the investment is.
Net Operating Income (NOI)
NOI = Effective gross income - Operating expenses
NOI leaves out your mortgage, which lets you compare properties regardless of how they're financed. Our guide to calculating NOI in real estate goes deeper on what to include.
Cap Rate
Cap rate = (NOI ÷ Property value) × 100
In our example, $26,190 ÷ $350,000 gives a cap rate of about 7.5%. Many residential markets land somewhere between 5% and 10%. A cap rate over 10% suggests excellent income relative to property value, but it often comes with higher risk, such as an older building or a less stable market. A lower cap rate usually reflects lower risk or a high-demand area. Learn more in our guide on how to calculate cap rate for vacation rentals.
Cash on Cash Return
Cash on cash return = (Annual cash flow ÷ Total cash invested) × 100
Cash on cash return measures the yield on the money you actually put in. In our example, $2,733 ÷ 110,000(87,500 down payment plus $22,500 in closing costs and furnishing) is about 2.5%.
Notice the gap: a 7.5% cap rate but a 2.5% cash on cash return. That's financing at work. At a 7% interest rate, the loan absorbs most of the NOI. Your spreadsheet should calculate both automatically so you can see the effect of a larger down payment or a better rate. For benchmarks, read what is a good rate of return on rental property.
What Is Good Cash Flow for a Rental Property?
Good cash flow is positive after every operating expense, your full loan payment, and a CapEx reserve, with enough cushion to survive a slow season or a surprise repair. Many real estate investors set a target cash on cash return, commonly 8% to 12%, rather than a fixed dollar amount, because a "good" monthly figure depends on how much cash you tied up.
Investors also use quick rules of thumb to screen deals before building a full analysis:
- The 1% rule: Monthly rent should be at least 1% of the purchase price.
- The 2% rule: A stricter version that's usually only achievable in lower-cost markets.
- The 50% rule: Assume roughly half of rental income will go to operating expenses, excluding the mortgage.
- The 7% rule: Definitions vary, but most often it means annual gross rental income should be at least 7% of the purchase price.
These rules are filters, not answers. They ignore your actual taxes, insurance, financing, and occupancy, which is exactly what your spreadsheet captures.
Download Our Free Rental Property Cash Flow Spreadsheet
Want to skip building from scratch? Grab our free template and start plugging in your property details.
What's Inside the Template
Our template is built with short-term rentals in mind and tracks your numbers month by month, starting with a sheet for your first property:
- Revenue inputs: nightly rate, occupancy rate, and additional income
- Expense inputs: mortgage or loan payment, property management fees, utilities, maintenance costs, cleaning fees, insurance, taxes, and supplies
- Automatic totals: total revenue, total expenses, and net profit for each month and the full year
- A monthly cash flow chart that updates as you fill in the sheet
How to Use Your Spreadsheet
- Make a copy. Keep a backup in Google Drive or as an Excel spreadsheet so you never lose your history.
- Enter your nightly rate and expected occupancy for each month. Be realistic about your slow season.
- Add every other income source, like pet fees or add-on services.
- Log expenses as they happen. Keep receipts, and separate estimated costs from actual costs.
- Review monthly. Check your net profit and cash flow chart, then run the NOI, cap rate, and cash on cash return formulas above when you want to judge the investment as a whole. Duplicate the sheet for each additional property.
Excel Templates vs Google Sheets
Both work well. Microsoft Excel templates are great for offline use and complex formulas. Google Sheets makes it easy to share a live file with a co-host, partner, or accountant. Pick the one your team already uses. Consistency matters more than the tool.
Either way, a template can automate calculations like NOI, cap rate, and cash on cash return, so you only enter the raw numbers once. Our template totals revenue, expenses, and net profit for you, and you can add a few cells with the formulas above to calculate the rest. Keeping all your expenses organized in one file also helps you prepare for tax time instead of digging through receipts in April.
If you mainly need to log income and expenses for tax time, our rental income and expense worksheet is a lighter option.
Common Mistakes (and How to Avoid Them)
Many landlords build a spreadsheet once and never revisit their assumptions. Here's what to watch for.
Overestimating Income
It's tempting to project your peak-season rate across the whole year. Use market-level figures from comparable properties and your own booking history instead. Our rental profit calculator guide shows how to estimate realistic revenue.
Pro Tip: Plan for vacancies with a 5% to 10% vacancy rate on long-term rentals, and use conservative occupancy for short-term rentals. Better to be pleasantly surprised than the other way around.
Skipping CapEx and Maintenance
Routine maintenance and capital expenditures are the costs most often left out. A common rule of thumb is to set aside at least 1% of the property's value each year for upkeep, plus a separate reserve for big-ticket replacements.
Forgetting Financing Costs
Your loan payment is a big part of the cash flow equation. Leaving it out, or using an old interest rate, paints a much rosier picture than reality. Our guide to short-term rental loans covers financing options worth comparing.
Underestimating Management Time and Fees
Short-term rentals mean frequent turnovers, guest messages, and cleaning schedules. If you hire a manager, vacation rental property management fees commonly run 20% to 40% of rental income. If you self-manage, value your time, or use vacation rental automation to cut the hours.
Overlooking Taxes and Deductions
Rental income is taxable, but accurate expense tracking maximizes your deductions and potential tax savings. According to IRS Publication 527, landlords can typically deduct mortgage interest, repairs and maintenance, property management fees, insurance, and other ordinary rental expenses.
Depreciation also lets you deduct the cost of a residential rental building over 27.5 years. Our rental property depreciation calculator walks through how to estimate it. Capital expenditures that improve the property generally must be capitalized and depreciated rather than deducted all at once. Tax rules for short-term rentals can differ, so work with a tax pro and read our guide to Airbnb taxes.
When to Move From a Spreadsheet to Software
A simple spreadsheet is perfect for one or two properties. As your rental business grows, manual data entry becomes a job in itself. Every booking, payout, and cleaning fee from Airbnb, Vrbo, and Booking.com has to be copied over by hand, and one missed line throws off your financial reports.
That's usually the point when property owners switch to software that tracks income automatically. With iGMS, your bookings from every channel sync into one place, and the Cash Flow Report on the PRO+ plan turns them into real-time financial analysis without the copy-paste. You can see how that fits into accounting and reporting in iGMS or keep tracking the right vacation rental KPIs alongside your spreadsheet.
FAQ
How do you calculate cash flow for a rental property?
Add up all rental income and fees, subtract vacancy losses and operating expenses to get net operating income, then subtract your annual mortgage payments (debt service). Subtract a CapEx reserve to get your net cash flow.
Is there a free template for a rental property spreadsheet?
Yes. You can download our free rental property cash flow spreadsheet above. It's built with short-term rentals in mind, with monthly revenue and expense inputs that calculate your net profit automatically.
What is the 50% rule for rental property?
The 50% rule estimates that about half of your rental income will go to operating expenses, not including your mortgage. It's a quick screening tool, not a substitute for a full cash flow analysis.
What is the best way to track expenses for a rental property?
Log every expense as it happens, sort it into consistent categories, keep receipts, and review the totals monthly. A spreadsheet works well for a few properties. Software that syncs bookings and payouts saves time as you grow. Our Airbnb accounting guide covers the basics.
What expenses can I write off for a rental property?
Common deductions include mortgage interest, property taxes, insurance, repairs and maintenance, utilities you pay, property management fees, supplies, and depreciation. Rules vary, so confirm with a tax professional.
Final Thoughts
Running a rental without tracking cash flow is like driving without a fuel gauge. You'll find out you're empty at the worst possible moment. A rental property cash flow spreadsheet shows you exactly where your money goes, flags weak months early, and gives you the numbers to make strategic decisions about pricing, upgrades, and your next purchase.
Start with our free template. When manual data entry starts eating your weekends, let iGMS do the heavy lifting. It brings your bookings, guest messaging, and financial reporting into one platform so you can focus on financial returns instead of spreadsheets.
About the Author
Daniëlle Kruger is a writer and Content Manager at iGMS. She is an avid reader and researcher of all things travel, always trying to keep her finger on the pulse of the latest trends and innovations. Find her on LinkedIn.
