Your budget, living next to your actuals
A spreadsheet-style view that stays in sync with the data you already have in SwiftGuest. Monthly P&L, variance bars, rolling forecast, property-group roll-ups, and one-click CSV or Excel export.
USALI
Schedule-aligned by default
12-month
Rolling forecast horizon
.xlsx
Native Excel export
The problem
Most hotel budgets live outside the PMS — and pay for it
A plan disconnected from the booking graph goes stale inside a week. Variance tracking becomes a monthly fire drill instead of a daily instrument.
The annual budget dies on day 8
Most hotel budgets are built in a spreadsheet, emailed around once, then forgotten until Q2 when variance is suddenly 15%. By then it's late to act.
Forecast accuracy has no feedback loop
Without closing the loop between pace, pickup, pricing, and the month-end, forecasts drift. You find out the summer is soft in August, not May.
Multi-property roll-up is manual
Each property builds its own sheet, sends it to the group controller, who re-types it into a master. Errors compound. Variance is blurred by reconciliation lag.
Accounting needs clean exports
Your accountants want USALI-shaped exports, not a screenshot. Without a proper export pipeline, month-end becomes a copy-paste marathon.
Monthly P&L
Every line item. Every month. Live actuals.
The monthly P&L pulls reservation, POS, ancillary, and expense data directly from SwiftGuest. Variance bars make favourable and unfavourable swings visible at a glance. You drill from any line item to the transactions behind it.
- USALI Schedule 4 layout out of the box, custom layouts supported
- Variance bars centred on zero — favourable/unfavourable at a glance
- Click any line to see underlying folios, POS tickets, or POM entries
- Month lock prevents edits to closed periods
YTD actual
$962k
Full-year FC
$3.03M
vs budget
+2.4%
Rolling forecast
Always see twelve months forward, anchored in this month's reality
Each month closes and locks as actuals. The remaining months re-forecast using pace, on-the-books revenue, dynamic pricing projections, and a seasonal blend from your prior year. You get a living plan, not an expiring one.
Monthly close
Actuals lock automatically on month-end
Live pace
On-the-books and pickup flow in continuously
Scenario plans
Save upside, base, and downside cases
Prior-year blend
Weighted seasonality from your history
Property group
Roll-up across every property in one view
Build property groups by brand, region, or owner and the roll-up happens automatically. Group-level variance is just another column — drill down to property, department, or line item without leaving the page.
- Multi-currency with live FX conversion
- Inter-property transfers netted at group level
- Custom groupings (region × brand × product type)
- Per-property permissions and P&L locks
Export
Clean CSV and Excel out of the box
Accountants keep their templates. You skip the copy-paste. Every export preserves USALI structure, currency, and period lock state.
One-click CSV
UTF-8 encoded, comma or semicolon delimited, with header metadata for period, currency, and locks.
Native Excel (.xlsx)
Multi-sheet workbooks — Summary, P&L, Variance, Rolling Forecast, Property Breakdown — with preserved formatting and formulas.
Scheduled delivery
Drop month-end packs to S3, Google Drive, Dropbox, or email. Choose daily, weekly, or on-close triggers.
Example export
FY2026-Apr-Kandy-City-Hotel.xlsx · 6 sheets · 184 KB
Forecast accuracy that improves itself
Each month's variance feeds back into seasonality weights, pace multipliers, and expense ratios. The plan does not need to be perfect on day one — it needs to learn.
±3%
Revenue accuracy after 6 months
12
Months rolling horizon
0
Manual re-forecast effort
FAQ
Common questions
How is budgeting different from the forecasting in dynamic pricing?
Dynamic pricing forecasts demand for the next 30/60/90 days so rates can react. Budgeting is the financial plan for the full fiscal year: line-item revenue and expense targets, variance tracking, and a rolling re-forecast that updates as actuals land. They share data — pickup and pace from the pricing engine feed the rolling forecast automatically.
What line items are tracked?
USALI-aligned by default: rooms revenue, F&B revenue, ancillary revenue, total expenses by department, fixed vs variable cost, gross operating profit, and net operating income. You can add custom line items, tag them by department, and set a budget-vs-actual check on any of them.
How does the rolling forecast work?
Each month closes and locks as actuals. The remaining months re-forecast using live pace, current booking on the books, dynamic pricing projections, and a seasonal blend from your prior year. You always see a 12-month forward view anchored in this month's actuals.
Can I compare multiple properties?
Yes. Property groups roll up automatically. A three-property group shows per-property variance, group variance, and department-level breakdowns. You can drill from group to property to individual line item without leaving the view.
How do I get this data into my accounting system?
Exports are native CSV and Excel (.xlsx) with preserved formatting. Column layouts follow USALI Schedule format by default or custom templates you define. Scheduled exports can drop a monthly file to S3, Google Drive, or email.
Can I manage capital expenditure plans here?
Yes. Capex is a separate schedule with planned-vs-committed-vs-paid tracking, linked to projects. It rolls into the annual cash flow view alongside operating budget so you see the full picture, not just P&L.
Your budget. Your actuals. Finally in one place.
Connect your property, import last year's budget, and start the rolling forecast this month. No credit card required.