Workflow · Finance close · Opening soon
Hotel occupancy and ADR
Use your exported Excel files to calculate monthly hotel occupancy rate, ADR and RevPAR by property. Match reservations to properties, expand each stay into nights, then roll up the monthly rates.
Someone typed
“calculate occupancy rate, average daily rate and RevPAR by property and month from our reservations”
The agent read it as
Calculate occupancy rate, average daily rate and RevPAR by property and month from our Reservations, using Properties for room counts.
What the agent built
5 steps, each one an ordinary Mammoth step you can open and change.
File
Reservations
CSV export · 42 rows
File
Properties
CSV export · 3 rows
Step
Make property lookup key
Step 1
Step
Make reservation property key
Step 2
Join
Add property room counts
42 of 42 paired
Step
Expand reservations into nights
Step 4
Step
Calculate monthly property rates
Step 5
Result
Monthly Property Performance
6 rows
Schedule
Runs when you say
Proposed
- FileReservationsCSV export · 42 rows
- FilePropertiesCSV export · 3 rows
- StepMake reservation property keyStep 2
- StepMake property lookup keyStep 1
- JoinAdd property room counts42 of 42 paired
- StepExpand reservations into nightsStep 4
- StepCalculate monthly property ratesStep 5
- ResultMonthly Property Performance6 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 6 rows came out, and the join paired 42 of 42 rows.
- Download Reservations sample (42 rows)Excel: Reservations sheet
- Download Properties sample (3 rows)Excel: Properties sheet
What you get back
The result of that run, the rows to look at first.
Monthly Property PerformanceSample data6 rows
| Property | Month | Occupancy rate (%) | Average daily rate | RevPAR | Occupied room nights | Available room nights | Room revenue |
|---|---|---|---|---|---|---|---|
| Marrow Street Inn | 2026-09-01 | 54.4 | 228.9 | 124.61 | 49 | 90 | 11,215 |
| Marrow Street Inn | 2026-10-01 | 52.7 | 235 | 123.83 | 49 | 93 | 11,516 |
| Juniper Wharf Hotel | 2026-09-01 | 53.3 | 177.5 | 94.66 | 48 | 90 | 8,519 |
| Juniper Wharf Hotel | 2026-10-01 | 52.7 | 179.7 | 94.70 | 49 | 93 | 8,807 |
| The Alder House | 2026-09-01 | 54.4 | 196.6 | 107.01 | 49 | 90 | 9,631 |
| The Alder House | 2026-10-01 | 52.7 | 202.9 | 106.92 | 49 | 93 | 9,944 |
How do you calculate occupancy rate by property and month?
Export your reservations from Excel, and export your property list with room counts. Mammoth matches each reservation to a property, expands stays into nights, and calculates monthly occupancy rate, average daily rate and RevPAR by property.
How it works
How to use the Monthly Property Performance workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Monthly Property Performance: questions
Which export should you use?
Use an Excel export of reservations, plus an Excel export of properties that includes room counts. If your reservations and properties are in separate sheets or files, export both and use them together.
What happens to rows that do not match?
Rows that do not match the property lookup stay out of the matched results. You can review them, fix the source data, and run the workflow again.
How do you change the rules in words?
Edit the step names or the rule text to change how properties are matched, how room counts are picked up, or how monthly rates are grouped. For example, you can say to group by property and month, or to use a different property key.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.
- Profit and loss by monthBuild a monthly profit and loss statement from a QuickBooks general ledger export, with revenue, COGS, gross profit, expenses, and net income.See the workflow Built by the agent
- Real estate commission splitWork out real estate commission on each closed sale and split it between the listing agent, buying agent and brokerage.See the workflow Built by the agent
- Loan amortization from statementsBuild a monthly loan amortization schedule from an Excel export, with interest, principal, and remaining balance for each loan.See the workflow Built by the agent
- Accrued expenses scheduleBuild an accrued expenses schedule from QuickBooks exports. Match purchase orders to vendor bills, calculate unbilled amounts, and flag items that need accrual.See the workflow Built by the agent
- Cash conversion cycle by monthWork out cash conversion cycle each month from QuickBooks exports, using month-end balances and monthly sales.See the workflow Built by the agent
- Expense report from card transactionsTurn Amex card exports into an expense report per employee, with category totals and missing receipts flagged.See the workflow Built by the agent