Join the waitlist | HospoAnalytix

Every day

How did yesterday go?Daily flash: rooms, F&B and labour vs budget and last year.Did the night audit balance?Guest ledger, city ledger and deposits tied out.Do the takings match the bank?Cash and EFTPOS banked vs POS and front desk.Do the card settlements match?Card payments received vs card takings, fees found.Is petty cash balanced?Float, receipts and top-ups in one place.

Payroll and compliance

Did we pay everyone right this pay run?Every person's pay rebuilt from their shifts and matched to the pay run summary.What does this roster cost?Award cost, the traps in it and every person's breakdown, before it goes out.Did we pay what we rostered?Early starts, late finishes, unplanned overtime and missed breaks, in dollars.What's our underpayment risk?Every person and shift in a pay run checked against the award, with back pay worked out.Are our contracts priced right?A role's duties to its award level, and one pattern priced four ways.Which casuals could go permanent?The pattern behind each casual over 6 or 12 months, as evidence.What will the 1 July pay rise cost?The annual wage review by department, and who drops below the minimum.What does an hour really cost?Super, workers comp, payroll tax and leave on top of the wage.Do annualised salaries cover the award?Every salaried person checked against what the award would have paid.What award level fits this role?Tick what the person does: the level, minimum rate and market pay.Which pay dates are coming up?Junior birthdays, probation ends, casual conversion and the 1 July rise in one list.What's our gender pay gap?Your WGEA rows, your gap the way WGEA works it out, and what drives it.Is agency cheaper than hiring?True cost of agency hours against a part-timer.Is this one payslip right?Payslip, back pay and salary checks, free.

Month end

How did we perform this month?Mini P&L month and year to date vs budget and last year: margins, cost per occupied room, GOP.What occupancy do we need to break even?Rooms, food and beverage, and the whole hotel.Where will this month land?Wages and FTE so far, the rest of the month from the roster, against budget.Why are we over budget?Actual against budget by day and department, and the shifts that drove it.What do we accrue at month end?Wage accrual from the roster, last month's true-up, journals ready to post.Where does every wage dollar go?Every shift costed and split, in Excel, ready to pivot.Do the balance sheet accounts reconcile?Bank, payroll clearing, guest ledger and creditors against the trial balance.Is the bank reconciled?Statement against the GL cash account, item by item.Do the OTA commissions reconcile?Commission charged against stays, booking by booking.Do the loyalty charges reconcile?Program charges against the stays they came from.Where did the month land, and why?Variance commentary drafted from the numbers; you edit and send.Who should we chase first?Aged debtors ranked by size and lateness.What do we report in the ABS survey?The survey answers pulled from your own figures.What payroll tax do we owe?Wages by state against each state's threshold and rate.

Every year

What should next year's budget be?Budget by P&L line and department, built from rates, standards and last year, spread to days.Is the operator compliance checklist done?Every obligation in the management agreement, ticked off with evidence.What contracts do we have, and what do they cost?Contract list: renewals, prepayments spread, write-offs, feeds the budget.What depreciation do we book?The asset register to the month's depreciation journal.What's our FBT bill?Benefits by type, grossed up, ready for the return.

Decisions

Is this group worth taking?What the group adds after the guests it displaces.Does this package make money?Package net against selling the room on its own.Will this capex pay back?Payback, NPV and yearly return on the spend.Should we open on the holiday?Labour cost of opening fully, partly or not at all.What's our optimal staff mix?See how the mix moved from last year to now, and how to optimise it.Lease or buy?The two total costs side by side over the term.What should we charge for this event?The labour cost of an event, so the quote covers it.Who can cover, and for less?Swaps and sick-call cover from availability, priced under the award.

Owners and asset managers

Will we have enough cash this year?Week by week, then by month, lowest point flagged.Where will the next 12 months land?Actual to date plus scenarios for the rest.How healthy is the balance sheet?All ratios in one card: debtor and creditor days and ageing, current and quick ratio, assets to liabilities, gearing.Are the operator's fees right?Base and incentive fees, head-office charges and the FF&E reserve, checked monthly.What is each booking channel costing us?Commission and cost per booking, direct vs OTA.Are we inside the debt covenants?Each covenant tested against the latest figures.If revenue drops 10%, what happens to profit?Flow-through applied to your own cost structure.Is the operator delivering?Revenue against competitors, margins, flow-through and labour against peers.Management or franchise agreement: which costs less?Fees and charges under each, on your own numbers.What is the hotel worth?Net operating income to value, and what each finding adds.

Be first in