Who this is for: GMs, controllers, and owners at independent hotels, hotel groups, motels, resorts, B&Bs, parks, and hostels who track cash coming in and going out.
A hotel cash flow template tracks cash moving in and out of a property. Profit and cash position often diverge, especially around payroll and debt service. Some properties only need a simple tracker. Others need a full statement or a forward projection. This page covers all three formats.
What's Included in This Template
- Reporting period covered (day, week, month, or quarter)
- Beginning cash balance
- Cash inflows by category (room, F&B, and other revenue collected)
- Cash outflows by category (payroll, vendors, utilities, debt service, capital expenditures)
- Net cash flow for the period
- Ending cash balance
- A quarterly projection view for forward planning
Which Cash Flow Template Do You Need?
Most properties need one of three formats. It depends on how much detail the reporting requires.
| Format | Use For | Key Fields |
|---|---|---|
| Simple Cash Flow Tracker | Quick day-to-day or week-to-week cash tracking | Total cash in, total cash out, net cash flow |
| Full Cash Flow Statement | Detailed monthly reporting broken out by category | Cash inflows, cash outflows, summary |
| Quarterly Cash Flow Projection | Forward planning across the next four quarters | Total cash in, total cash out by quarter |
Template 1: Simple Cash Flow Tracker
For quick tracking of cash in, cash out, and the resulting balance.
| Field | Details |
|---|---|
| Period | [Day/Week/Month] |
| Beginning Cash Balance | $[Amount] |
| Total Cash In | $[Amount] |
| Total Cash Out | $[Amount] |
| Net Cash Flow | $[Amount] |
| Ending Cash Balance | $[Amount] |
Template 2: Full Cash Flow Statement
For a detailed monthly breakdown of cash inflows, outflows, and the summary position.
| Section | Field | Details |
|---|---|---|
| Cash Inflows | Room Revenue Collected | $[Amount] |
| Cash Inflows | F&B Revenue Collected | $[Amount] |
| Cash Inflows | Other Revenue Collected | $[Amount] |
| Cash Inflows | Total Cash In | $[Amount] |
| Cash Outflows | Payroll | $[Amount] |
| Cash Outflows | Vendor Payments | $[Amount] |
| Cash Outflows | Utilities | $[Amount] |
| Cash Outflows | Debt Service | $[Amount] |
| Cash Outflows | Capital Expenditures | $[Amount] |
| Cash Outflows | Other Outflows | $[Amount] |
| Cash Outflows | Total Cash Out | $[Amount] |
| Summary | Net Cash Flow | $[Amount] |
| Summary | Beginning Cash Balance | $[Amount] |
| Summary | Ending Cash Balance | $[Amount] |
Template 3: Quarterly Cash Flow Projection
Quarterly columns keep this projection practical, since 12 months would crowd the sheet.
| Line Item | Q1 | Q2 | Q3 | Q4 |
|---|---|---|---|---|
| Total Cash In | $[Amount] | $[Amount] | $[Amount] | $[Amount] |
| Total Cash Out | $[Amount] | $[Amount] | $[Amount] | $[Amount] |
| Net Cash Flow | $[Amount] | $[Amount] | $[Amount] | $[Amount] |
| Ending Cash Balance | $[Amount] | $[Amount] | $[Amount] | $[Amount] |
Best Practices for Hotel Cash Flow
Review cash flow on a fixed schedule so shortfalls surface before payroll is due.
- Review cash flow every week, even in slower off-season months.
- Flag a projected shortfall as soon as the numbers show it.
- Separate operating cash from capital reserves in every report.
- Compare actual cash flow against the quarterly projection each month.
- Reconcile the ending balance against the actual bank balance every period.
Common Mistakes to Avoid
- Tracking profit instead of actual cash moving in and out.
- Mixing capital expenditure spending into routine operating outflows.
- Skipping the weekly review until a shortfall forces attention.
- Leaving debt service payments out of the total cash outflow.
- Recording revenue as collected before the payment actually clears.
- Building a quarterly projection without checking the prior quarter's actual result.
Example: Completed Full Cash Flow Statement
A filled-in example makes the numbers concrete. This is one month at a mid-size independent hotel.
| Section | Field | Example Entry |
|---|---|---|
| Cash Inflows | Room Revenue Collected | $380,000 |
| Cash Inflows | F&B Revenue Collected | $70,000 |
| Cash Inflows | Other Revenue Collected | $15,000 |
| Cash Inflows | Total Cash In | $465,000 |
| Cash Outflows | Payroll | $180,000 |
| Cash Outflows | Vendor Payments | $60,000 |
| Cash Outflows | Utilities | $20,000 |
| Cash Outflows | Debt Service | $35,000 |
| Cash Outflows | Capital Expenditures | $15,000 |
| Cash Outflows | Other Outflows | $10,000 |
| Cash Outflows | Total Cash Out | $320,000 |
| Summary | Net Cash Flow | $145,000 |
| Summary | Beginning Cash Balance | $210,000 |
| Summary | Ending Cash Balance | $355,000 |
Hotel Cash Flow Templates by Property Type
Every property type manages cash coming in and going out. Independent Hotels use the three templates above as written. The other six variations are below.
Hotel Groups Cash Flow
Adds a property and location field for portfolio-wide treasury planning.
| Field | Details |
|---|---|
| Property Name & Location | [Property Name, City, State] |
| Period | [Month/Quarter] |
| Beginning Cash Balance | $[Amount] |
| Total Cash In | $[Amount] |
| Total Cash Out | $[Amount] |
| Net Cash Flow | $[Amount] |
| Ending Cash Balance | $[Amount] |
Motel Cash Flow
Drops capital expenditures and debt service, since many motels carry neither line.
| Field | Details |
|---|---|
| Room Revenue Collected | $[Amount] |
| Payroll | $[Amount] |
| Utilities | $[Amount] |
| Net Cash Flow | $[Amount] |
Resort Cash Flow
Adds Spa and Activities Revenue Collected, a meaningful cash inflow at resorts.
| Field | Details |
|---|---|
| Room Revenue Collected | $[Amount] |
| F&B Revenue Collected | $[Amount] |
| Spa and Activities Revenue Collected | $[Amount] |
| Total Cash In | $[Amount] |
| Total Cash Out | $[Amount] |
| Net Cash Flow | $[Amount] |
Bed & Breakfast Cash Flow
Simplifies to one revenue line, since breakfast is already included in the room rate.
| Field | Details |
|---|---|
| Room Revenue Collected (Breakfast Included) | $[Amount] |
| Payroll | $[Amount] |
| Utilities | $[Amount] |
| Other Outflows | $[Amount] |
| Net Cash Flow | $[Amount] |
Parks (RV & Campground) Cash Flow
Replaces room revenue with site revenue, and adds a camp store revenue line.
| Field | Details |
|---|---|
| Site Revenue Collected | $[Amount] |
| Camp Store Revenue Collected | $[Amount] |
| Total Cash In | $[Amount] |
| Payroll | $[Amount] |
| Utilities | $[Amount] |
| Net Cash Flow | $[Amount] |
Hostel Cash Flow
Replaces room revenue with bed revenue, otherwise matching the Independent Hotel shape.
| Field | Details |
|---|---|
| Bed Revenue Collected | $[Amount] |
| F&B Revenue Collected | $[Amount] |
| Other Revenue Collected | $[Amount] |
| Total Cash In | $[Amount] |
| Total Cash Out | $[Amount] |
| Net Cash Flow | $[Amount] |
Bottom Line
A profitable month can still leave a property short on cash for payroll. Debt service payments often come due in that same tight week. Cash in the bank often lags behind revenue already booked. roommaster PMS pulls actual cash collected by category from hundreds of built-in reports. roommaster Payments also saves 4 to 6 hours of staff time every week.
Frequently Asked Questions
1. What is a hotel cash flow template?
Tracks cash moving in and out of a property over a set reporting period.
2. What's the difference between cash flow and profit?
Profit reflects revenue earned on paper. Cash flow reflects money actually collected and paid.
3. How often should a hotel review its cash flow?
Weekly reviews catch a shortfall early, before it affects payroll or debt service.
4. What counts as a capital expenditure in hotel cash flow?
Capital expenditures cover large purchases like renovations, new equipment, or property upgrades.
5. Can a small property use a simple cash flow tracker?
Small properties can rely on the simple tracker for daily or weekly totals.
