Free Vacation Rental Cash Flow Forecast Template
Download this free Google Sheet to forecast your management company's operating cash month by month, find your lowest cash month and size the reserve that carries you to peak season.

How to Use This Template
Make a copy of the Google Sheet (File → Make a copy), then replace the example numbers in the white cells with your own. Every gray cell is a formula, so totals, ending cash and the forecast summary update as you type. The Instructions tab walks through each step.
For the method behind the template, read our guide to Cash Flow Forecasting for Seasonal STR Markets.
What This Template Is Designed to Do
Most cash flow templates assume revenue arrives when it's earned and that the cash in the bank is yours. Neither holds for a vacation rental management company. Commission reaches your operating account after stays end, while payroll, preseason hiring and annual bills keep coming, and advance deposits in trust can make the bank balance look healthy right before operating cash runs low.
This template forecasts operating cash only. It dates commission to the month it actually arrives, shows your low point months in advance and calculates the opening cash or credit line you need to get through it.
What This Template Includes
1. Assumptions and Forecast Summary
Enter opening operating cash, your commission rate, when commission reaches your operating account and a reserve buffer. The summary shows your lowest ending cash, the month it happens, months below zero and the opening cash you need.
2. Revenue and Commission
Booked revenue from your PMS plus expected pickup for each month, converted into the commission your company earns. A Downside scenario shows the same year with less pickup than expected.
3. Cash In and Cash Out
Commission received, other company income and owner reimbursements on one side. Fixed overhead, seasonal labor, one-time and annual bills, card balances and expenses you front for owners on the other, each dated to the month money leaves your account.
4. Ending Cash by Month
Opening cash, net cash flow and ending cash for 12 months, with a chart that flags your low point.
5. 13-Week Cash Forecast
A week-by-week view of the next quarter for payroll dates, commission transfers and bill runs that a monthly view hides. Opening cash links to the monthly forecast.
6. A Worked Example
The template comes filled in with a seasonal beach market company that ends the year ahead but runs below zero from March through June. Use it to see how the forecast works before you add your own numbers.
Recommended Use
- Refresh booked revenue from your PMS at least monthly, and weekly during shoulder season.
- Roll the 13-week forecast forward one week every week.
- Compare forecast to actual ending cash each month and adjust your pickup assumptions.
- Run the Downside scenario before committing to new hires or large purchases.
- Put any credit line in place before the first month below zero.
Important Note on Trust Cash
Advance deposits, owner funds, security deposits and lodging taxes held in trust belong to guests, owners and tax authorities. Enter operating cash only. Commission becomes operating cash once it has been earned and transferred from trust under your management agreements and state rules.
Questions or Need Help?
If you have questions about using this template, email: info@topkey.io.