If you do not know your numbers, you do not have a business — you have an expensive hobby. Monthly cash flow analysis is the single most important financial habit for Florida STR owners. It tells you whether you are making money, how much, and where the leaks are. Here is the template and process.
What Goes Into a Monthly Cash Flow Analysis?
Cash flow is simple: money in minus money out. But accuracy requires capturing every dollar in both directions.
Income Categories
Rental income:
- Nightly booking revenue (by platform: Airbnb, VRBO, direct bookings)
- Cleaning fees collected from guests
- Pet fees
- Early check-in / late checkout fees
- Pool heating surcharges
Other income:
- Security deposit forfeitures (when damage exceeds deposit)
- Insurance claim payments
- Interest earned on reserves
Track income by platform to understand which channels are most profitable after fees.
Expense Categories
Fixed monthly expenses (same every month):
- Mortgage payment (principal + interest)
- Property insurance
- HOA or condo fees
- Property taxes (divide annual by 12)
- Internet service
- Lawn service
- Pool service
- Pest control
- Property management software
- Channel manager subscription
- Dynamic pricing tool subscription
Variable monthly expenses (change based on occupancy):
- Cleaning costs (turnover cleaning × number of turnovers)
- Utilities — electric, water, gas (AC costs spike in Florida summer)
- Platform booking fees (Airbnb service fee, VRBO commission)
- Consumable supplies (toilet paper, soap, coffee, kitchen supplies)
- Linen replacement and laundry costs
- Guest amenity costs (welcome gifts, beach gear replacement)
- Credit card processing fees (direct bookings)
Periodic expenses (not monthly, but budget monthly):
- HVAC maintenance (2x/year ÷ 12)
- Deep cleaning (4x/year ÷ 12)
- Annual termite bond (÷ 12)
- STR license and permit renewal (÷ 12)
- Annual property inspection (÷ 12)
- Professional photography (÷ 12)
- Annual property insurance (÷ 12 if paid annually)
Irregular expenses (budget a monthly reserve):
- Maintenance and repairs
- Furniture replacement
- Appliance replacement
- Guest damage not recovered
- Emergency service calls
What Does a Monthly Cash Flow Template Look Like?
Here is a simplified template you can build in a spreadsheet:
INCOME
| Category | Amount |
|---|---|
| Airbnb revenue | $ |
| VRBO revenue | $ |
| Direct booking revenue | $ |
| Cleaning fees collected | $ |
| Pet fees | $ |
| Other income | $ |
| Total Income | $ |
EXPENSES
| Category | Amount |
|---|---|
| Mortgage (P&I) | $ |
| Property tax (monthly) | $ |
| Insurance (monthly) | $ |
| HOA/condo fees | $ |
| Utilities (electric, water, gas) | $ |
| Internet | $ |
| Cleaning costs | $ |
| Platform fees | $ |
| Lawn/landscape | $ |
| Pool service | $ |
| Pest control | $ |
| Supplies/consumables | $ |
| Linen/towel replacement | $ |
| Maintenance/repairs | $ |
| Software subscriptions | $ |
| Marketing | $ |
| Reserve contribution | $ |
| Total Expenses | $ |
CASH FLOW = Total Income - Total Expenses
What Key Metrics Should You Calculate Monthly?
Beyond the cash flow number itself, calculate these performance indicators:
Net Operating Income (NOI): Total income minus all operating expenses (NOT including mortgage principal). This measures your property's operational profitability independent of your financing.
NOI Margin: NOI ÷ Total Income × 100. Target 40-55% for Florida STRs. Below 35% means your expenses are eating too much of your revenue.
RevPAN (Revenue Per Available Night): Total revenue ÷ days in the month. This is the most comprehensive single metric because it accounts for both rate and occupancy.
Average Daily Rate (ADR): Total revenue ÷ booked nights. Compare to your market benchmarks.
Occupancy Rate: Booked nights ÷ available nights × 100. Target 70-80% annually in Florida.
Cost Per Turnover: Total cleaning cost ÷ number of turnovers. If this is rising, investigate why.
Utility Cost Per Occupied Night: Total utilities ÷ booked nights. Track seasonally — Florida AC costs spike in summer.
How Do You Analyze Monthly Cash Flow Trends?
Month-over-month comparison: Is your cash flow improving or declining? Seasonal variation is expected in Florida, but the trend within each season should be stable or improving.
Year-over-year comparison: Compare each month to the same month last year. This controls for seasonality and reveals true performance changes.
Expense ratio analysis: Track each expense category as a percentage of revenue. If cleaning goes from 12% to 18% of revenue, investigate. If utilities spike 40% in July versus June, is it normal AC increase or a problem?
Red flags to watch:
- Cash flow negative for more than 2 consecutive months outside of planned capital improvements
- NOI margin below 30%
- Any single expense category increasing more than 15% without a clear reason
- Platform fees as a percentage of revenue exceeding 15% (consider direct bookings)
- Maintenance costs spiking (may indicate equipment reaching end of life)
How Do You Use Cash Flow Data for Decision Making?
Pricing decisions: If your cash flow shows strong profit at current occupancy, you might be underpriced. If occupancy is high but cash flow is thin, your expenses need attention.
Upgrade decisions: Use your cash flow data to calculate ROI on proposed upgrades. A pool heater that costs $3,500 and adds $40/night in winter at 80% occupancy adds $5,800 in seasonal revenue — clear go.
Expense optimization: Identify your top 3 expense categories. Can you negotiate better rates? Switch providers? Reduce frequency without quality impact?
Reserve building: Set aside 5-10% of monthly gross revenue into a reserve fund for major repairs and replacements. This prevents unexpected expenses from creating cash flow emergencies.
Tax preparation: Monthly cash flow tracking makes tax time dramatically simpler. Your expense tracking is already done. Hand your spreadsheet to your CPA and maximize your deductions.
Run your cash flow analysis on the 5th of every month (after all previous month transactions have posted). It takes 30 minutes and is the most valuable half-hour you spend on your Florida STR business. For a bigger-picture view, pair monthly cash flow with your annual performance review and profit analysis to build a vacation rental business that generates real, measurable wealth.
