eHMS Press · Tools

Digital companion shelf

Search workbooks, templates, calculators, worksheets and web tools connected to eHMS Press books and Decision Guides. Every companion has a permanent page that can be shared directly or used in a QR code.

Find a resource

Search or filter companions

Search by topic, workbook name, book, Decision Guide, chapter or resource type.

Available in the reporting web edition

Interactive Appendix A-I companions

These working companion sheets are built directly into the Hotel Financial Reporting reader.

A

Appendix A

Terminology and Decision-Impact Index

Appendix A is the cross-book terminology control. It does not replace the licensed USALI 12 text, property policy, management agreement, local law, accounting standards, tax rules, lender definitions, or legal advice. It shows where a term is primarily owned, what decision it can distort, and which control should follow when the meaning is uncertain or has changed.

Open web companion →
B

Appendix B

KPI Formula, Source, and Permitted-Use Reference

Appendix B consolidates the core formulas and formula rules used across the revised book. The formula is only the arithmetic shell. Every KPI still requires a business question, controlled numerator, controlled denominator, period, reporting basis, source owner, comparator, companion measure, and permitted-use decision.

Open web companion →
C

Appendix C

Hotel Context and Comparability Passport

Appendix C protects the reader from applying a correct definition or formula to the wrong business model. Use it before comparing hotels, importing a portfolio target, interpreting an external benchmark, judging an apparent outlier, or transferring a chapter example to a different asset.

Open web companion →
D

Appendix D

Local and External Reporting Adaptation Log

Appendix D records the differences between the USALI management view and the local or external reporting bases that affect the same hotel. It is a controlled bridge, not a country guide. The hotel should populate the log from current law, contracts, accounting policy, tax advice, lender documents, and approved owner reporting requirements.

Open web companion →
E

Appendix E

Schedule Navigation and Verification Index

Appendix E helps the reader move from a statement line to the supporting schedule, source evidence, decision, and verification boundary. The schedule labels below are navigation labels used by this companion. Exact official titles, line descriptions, inclusions, exclusions, and account-level treatment must be confirmed against the licensed USALI 12 text and the property's approved policies and agreements.

Open web companion →
F

Appendix F

Hotel Blue Moon Sample Statement and Evidence Pack

Appendix F is the controlled teaching dataset used to connect the revised final case to the schedules, statistics, KPI release decisions, owner bridge, forecast treatment, and closure evidence. The figures are rounded and illustrative. They describe one monthly case and must not be treated as universal operating targets.

Open web companion →
G

Appendix G

Monthly Commentary, Benchmark, Action, and Owner-Decision Templates

Appendix G contains reusable forms, not another explanation of Chapters 37-39. Complete the relevant form only after the statement, supporting schedule, statistic, KPI use status, and comparison basis have been controlled. A blank field is a visible evidence gap; do not replace it with unsupported certainty.

Open web companion →
H

Appendix H

Digital Companion Architecture and User Guide

Appendix H merges the workbook architecture and digital-companion register into one controlled guide. The companion may be delivered as one master workbook or as linked modules. The published book should refer to stable module names, not fragile cell addresses. The final release must document the files actually delivered.

Open web companion →
I

Appendix I

Reader Portfolio Scoring Sheet

Appendix I is a printable assessment instrument for self-study, hotel training, consulting, or formal instruction. It does not repeat the HOTS explanations in the chapters and Part VIII closeout. It scores whether the reader can produce a controlled management output that another person can use and defend.

Open web companion →

Books & Decision Guides

Companion resources

The public page explains each resource. Purchaser-only files and tools remain protected until the matching purchase or entitlement is verified.

Purchaser resource

Decision Guide · 13-Week Cash Flow for Hotels · Decision Guide companion

Live 13-Week Hotel Cash Forecast

Template for your own testing

WorkbookPurchase verification requiredView access options
Open to all

Decision Guide · 13-Week Cash Flow for Hotels · Decision Guide companion

Worked Example to read along with guide

Download and read this template along with guide. You can test and edit the numbers for your own hotel too.

WorkbookReady to useOpen companion page
Purchaser resource

Book · From Finance Manager to CFO · Book companion · 20 tools

Consolidated CFO Readiness Toolkit

The book's primary companion: 20 practical tools covering readiness assessment, competency evidence, development planning, operational learning, business partnering, growth, cost and productivity, forecasting, investment, management agreements, cash, ERP benefits, governance, crisis response, team capability, succession, multi-property responsibility, board recommendations, interview evidence, and the first 90 days.

Printable / editable workbookPurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 1

DC-01 Budget Agreement Builder

Establish the budget agreement before detailed schedules begin: diagnose likely failure points, assign assumption ownership, lock source data, document approvals, and prepare the first controlled forecast handoff.

Excel workbookPurchase verification requiredView access options
Open to all

Book · Hotel Budgeting and Forecasting in Practice · Chapter 1

DC-01 Why Hotel Budgets Fail and How to Make Them Useful

From Annual File to Management Agreement

Excel workbook / working templateReady to useOpen companion page
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 2

DC-02 Budget Architecture and Handoff

Map the connected budget layers, source-to-driver relationships, ownership, ripple effects, and architecture readiness before detailed schedules are built.

Excel workbookPurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 3

DC-03 Budget Process and Forecast Handoff

Convert the approved budget architecture into a controlled annual process covering the calendar, responsibilities, source locks, assumptions, versions, approvals, and forecast rhythm.

Excel workbookPurchase verification requiredView access options
Open to all

Book · Hotel Budgeting and Forecasting in Practice · Chapter 3

DC-03 Budget Process Architecture

When to Start, Who Owns What, and How the Budget Becomes a Forecast

Excel workbook / working templateReady to useOpen companion page
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 4

DC-04 Rooms Market Research and Revenue Strategy

How evidence becomes segment, channel, value, pricing, and marketing choices

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 5

DC-05 Rooms Revenue Budget Model

Converting market strategy into capacity, segment demand, pricing, USALI Rooms revenue, channel value, and management action

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 6

DC-06 F&B Market, Concept and Revenue Strategy

From the rooms budget and current restaurant landscape to capture, menu, marketing, and future budget assumptions

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 7

DC-07 F&B Outlet Revenue and Margin Model

From the unchanged Chapter 6 strategy to segment-wise resident capture, outside demand, takeaway, concession income, margin, and forecast action

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 8

DC-08 Banquet, Events, and MICE Budget Model

From city demand and on-the-books business to targeted event creation, contribution, cash, and forecast action

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 9

DC-09 Other Revenue Departments

Building spa, guest laundry, recreation, water sports, transport, access, retail, and partner income from room-segment demand and local-market drivers

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 10

DC-10 Qualitative Priorities, Service Productivity, and the Guest Experience Budget

Turning commercial promises into funded service, people, quality, productivity, maintenance, and owner decisions

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 11

DC-11 Expense Budget Architecture and Hospitality Cost Behaviour

Build expense architecture from operating activity and classify cost behaviour before challenging the amount.

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 12

DC-12 Cost Control Before the Budget

Zero-base review of contracts, suppliers, technology, volume response, and future cost pressure

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 13

DC-13 The Whole-Hotel Manpower Budget

Connecting revenue, workload, productivity, service quality, shared services, and payroll before departmental expenses

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 14

DC-14 Full Employee Cost and Total Hotel Labour

Converting the approved manpower plan into local and expatriate employee cost, loaded casual and contract labour, cash, and departmental labour cost

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 15

DC-15 Rooms Division Expense Budget Model

From the approved room stay to housekeeping, front-office, textile, acquisition, contract, CPOR, and contribution budgets

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 16

DC-16 F&B Division Cost and Expense Budget Model

From approved covers, orders, food and beverage revenue, events, and service standards to Cost of Sales, named Other Expenses, departmental profit, and forecast action

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 17

DC-17 Other Operated Department Expense Budgets, Departmental Contribution, and Flow-Through

Building spa, guest laundry, recreation, transport, parking, retail, partner-cost, and whole-hotel contribution from approved Rooms, F&B, event, package, and ancillary strategies

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 18

DC-18 Administrative & General and IT Systems Expense Budgets

Building separate Schedule 5 and Schedule 6 forecasts from revenue strategy, labour, transactions, systems, shared services, renewals, projects, and control risk

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 19

DC-19 Sales, Marketing, Distribution, Loyalty, and Campaign ROI Budget Model

Funding the hotel demand engine from occupancy strategy, channel economics, loyalty commitments, modern media, AI-enabled execution, and contribution-based return

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 20

DC-20 Property Operation and Maintenance and Energy, Water, and Waste Budget Model

Building asset reliability, preventive work, repair control, resource consumption, tariff exposure, deferment decisions, and forecast action

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 21

DC-21 GOP, Business Models, Management Fees, and Flow-Through Protection

Build one controlled waterfall from revenue to IBNOIE while protecting flow-through and modelling management fees on the correct basis.

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 22

DC-22 Capital Expenditure Budget, Asset Renewal, and FF&E Reserve

Turning asset condition, mandatory work and strategic investment into a funded, phased and accountable project portfolio

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 23

DC-23 Below-GOP Charges, Schedule 11, EBITDA, D&A, Interest, and Book Profit

Protect the operating result before adding the owner burden and keep USALI and statutory reporting maps separate.

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 24

DC-24 Cash Flow, Working Capital, Tax, Major Payments, and Funding Plan

Turning book profit into daily collections, monthly liquidity, and an approximate cash requirement for the hotel

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 25

DC-25 Budgeted Balance Sheet and Integrated Three-Statement Plan

Connecting the approved P&L, capital plan and cash flow into a complete monthly financial position

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 26

DC-26 Owner Review Dashboards, Strategy Storytelling, and Budget Approval

Turning the connected hotel budget into an owner-ready decision story and presentation

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 27

DC-27 Rolling Forecast, Scenario Planning, and Forecast Governance

Refreshing the hotel outlook without changing the approved budget baseline

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 28

DC-28 Pre-Opening Budget, Opening Cash Burn, and Ramp-Up Plan

Building the financial plan from mobilization through soft opening, break-even and stabilization

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · Chapter 29

DC-29 Three-to-Five-Year Strategic Plan, Asset Strategy, and Owner Return

Extending the annual budget into a market, operating, capital, financing and ownership roadmap

Excel workbook / working templatePurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · chapter 4

Make Rooms market strategy and convert into forecast

Chapter 4 companion: convert evidence into controlled segment, channel, value, pricing, marketing, and revenue-management decisions before the rooms model is built.

Excel workbookPurchase verification requiredView access options
Purchaser resource

Book · Hotel Budgeting and Forecasting in Practice · chapter 5

Rooms Revenue Budget Model

Completed Azure teaching example — USALI 12th Revised Edition compliant structure

Excel workbookPurchase verification requiredView access options
Purchaser resource

Book · Hotel Financial Reporting in Practice · Chapters 10–12

F&B Customer and Average-Check Tool

Reconcile food, beverage, package, event, and beverage-only customer populations before calculating average check.

Excel workbookPurchase verification requiredView access options
Purchaser resource

Book · Hotel Financial Reporting in Practice · Chapter 39

Hotel Blue Moon Applied Case Pack

Controlled case data, schedules, KPIs, owner bridge, management commentary, and answer framework.

Excel / PDF bundlePurchase verification requiredView access options
Reader account

Book · Hotel Financial Reporting in Practice · Chapters 6 and 36

KPI Reliability Passport

Document the business question, numerator, denominator, source, continuity, comparator, and permitted use.

Excel workbookSign in requiredView access options
Purchaser resource

Book · Hotel Financial Reporting in Practice · Chapters 20–25

Labor, FTE, and Total Workforce Bridge

Separate official employee FTE from outsourced capacity while retaining a complete productivity view.

Excel workbookPurchase verification requiredView access options
Reader account

Book · Hotel Financial Reporting in Practice · Chapters 8–9

Rooms Statistics Decision Table

Control rooms sold, occupied rooms, available inventory, complimentary rooms, no-shows, and package statistics.

Excel / PDFSign in requiredView access options
Open to all

Book · Hotel Financial Reporting in Practice · Chapters 4–6

Statement Reading Checklist

Name the result level, open the schedule, test the KPI, and assign the decision.

PDF / worksheetOverview available; file upload pendingOpen companion page
Purchaser resource

Decision Guide · My Food Cost Is Too High — Where Is the Loss? · Decision Guide companion

Template for Assessing and using the Food cost Analysis

Download this example to read with guide

WorkbookPurchase verification requiredView access options
Purchaser resource

Decision Guide · Restaurant Financial Performance Review · Decision Guide companion

Restaurant_Financial_Performance_Review_WORKED_EXAMPLE

Use this worked example to follow the guide

WorkbookPurchase verification requiredView access options
Open to all

Decision Guide · Restaurant Financial Performance Review · Decision Guide companion

Restaurant_Performance_Review_Readiness_Assessment

Assess if your restaurant is ready for comple financial review

WorkbookReady to useOpen companion page
Reader account

Decision Guide · The Monthly Hotel P&L Review · Decision Guide companion

20-Minute Hotel P&L First-Read Checklist

Printable control to frame the report, shortlist material movements, diagnose the first driver and close with an owned action.

TemplateSign in requiredView access options
Reader account

Decision Guide · The Monthly Hotel P&L Review · Decision Guide companion

DG-01 Diagnostic Quick Reference

One-page diagnostic reference for FRAME, SEQUENCE, DIAGNOSE, DECIDE and monthly review follow-through.

ResourceSign in requiredView access options
Purchaser resource

Decision Guide · The Monthly Hotel P&L Review · Decision Guide companion

LIve Excel companion for follow along with guide

Change the numbers and name for your hotel

WorkbookPurchase verification requiredView access options
Reader account

Decision Guide · The Monthly Hotel P&L Review · Decision Guide companion

Monthly P&L Review Meeting Agenda

A structured pre-meeting, 60–75 minute review and post-meeting follow-up agenda.

TemplateSign in requiredView access options
Reader account

Decision Guide · The Monthly Hotel P&L Review · Decision Guide companion

One-Page Monthly Review Summary

A one-page monthly review summary built around FRAME, SEQUENCE, DIAGNOSE and DECIDE.

TemplateSign in requiredView access options

Appendix H control architecture

Master companion workbook modules

The module names below match the finalized reporting manuscript.

00

Setup and Read Me

Hotel profile, period calendar, departments, rooms/outlets, source systems, user roles, version, and data status.

Parts I-II; Appendices C-DControlled property and reporting context.
01

Statement Builder

Summary statement, schedule roll-up, Actual/Budget/Prior Year/Forecast, statement ladder.

Chs. 4-5; Appendix EReconciled statement and schedule trail.
02

Revenue and Statistics

Segment/channel mapping, packages, rooms charges, room statistics, F&B/event close, ancillary and non-standard models.

Part IIIClassified revenue and reconciled operating statistics.
03

Departmental Expense

Rooms, F&B, events, ancillary cost stack, workload, evidence, conversion, and control actions.

Part IVDepartmental conversion and direct-cost pack.
04

Labor and FTE

Full labor stack, worked department, external workforce, policy layer, hours, FTE, productivity, and forecast.

Part V; Schedule 15Labor bridge and capacity forecast.
05

Support Platform and GOP

A&G, IT/subscriptions, Sales and Marketing, POM, EWW, shared/mandatory costs, and GOP bridge.

Part VI; Schedule 16 visibilitySupport-platform control pack.
06

Owner Economics and External Bases

Fees, nonoperating items, reserve, NOI passport, debt, cash, returns, US GAAP/IFRS/statutory/tax/lender bridges.

Part VIIOwner waterfall and reporting-basis reconciliation.
07

KPI, Dashboard, and Benchmark

Statistic register, permitted-use status, dashboard source trail, benchmark passport, normalization bridge.

Chs. 36-37; Appendices B-CApproved dashboard and comparison pack.
08

Commentary, Action, and Owner Decision

Commentary spine, action tracker, aging, forecast bridge, decision request, closure record.

Chs. 38-39; Appendix GMonthly management and owner-decision pack.
09

Final Case and Assessment

Blue Moon evidence, exercises, answer key, portfolio submission, scoring, feedback, and resubmission.

Appendices F and IApplied learning and assessment record.