Hotel front office

Manager's Daily Report

A one-page snapshot of a business day's operational, revenue, and collections numbers. This is what the night auditor reviews before closing the day, and what an owner or manager reads to see how the day went.

Where to find it

  • From the dashboard — the quickest route. There is a Manager's Daily Report bar near the top of the home page with two buttons: Today, and Yesterday for the day that has finished.
  • Reports → Manager's Daily Report, alongside the other front-office reports.
  • Front Office → Reports → Daily Report.

It reads properly on a phone. The four figures most people open it for — occupancy, net revenue, collected, and net income — sit at the top before any of the detail.

Before you start

  • You need either Financial Statements or Night Audit access. Owners and managers normally hold the first; night auditors hold the second. Either one opens the report.
  • Pick a date with Today or Yesterday, the arrows to step a day at a time, or the date picker for any other day. Future dates cannot be chosen — there is nothing to report yet.
  • The system can build a report for any past date — even days before Night Audit was switched on. Historical days seeded by the initial install show with no closing operator (they were never formally audited; treat the numbers as a baseline reconciliation only).

What's on the report

The page is split into three bands. Each band's metrics are computed from the same booking, sale, and ledger tables your other reports read from — there is no separate roll-up to keep in sync.

Occupancy

  • Rooms available — total active rooms (excludes OOS / Maintenance / Renovation).
  • In-house at start of day — rooms occupied at midnight.
  • Arrivals / Departures — distinct folios that checked in or checked out during the day.
  • In-house at end of day — start + arrivals − departures.
  • Occupancy % — end-of-day in-house ÷ rooms available.
  • ADR (Average Daily Rate) — room revenue ÷ end-of-day occupied rooms.
  • RevPAR (Revenue Per Available Room) — room revenue ÷ rooms available.
  • No-shows — decisions logged during the day's night-audit run. Zero until the no-shows step ships in a follow-up release.
  • Complimentary / House-use nights — guests whose Sponsorship is Complimentary or HouseUse and who were in-house at any point during the day.

Revenue

  • Room revenue — room-type charges (the Reservation-family items).
  • Late checkout fees — billed via the auto-generated LateCheckoutFee item.
  • F&B / POS revenue — sales tagged as POS (TableTransactionID or InvoiceType='POS').
  • Other charges — every other charge on the day's invoices.
  • Service charge / Tax — informational lines already folded into the gross.
  • Gross revenue — sum of the buckets above.
  • Discounts — discount lines on invoice details.
  • Net revenue — gross − discounts.
  • Refunds (return inwards) — same-day Return Inward total.

Collections & AR

  • Cash / Card / Bank transfer / Other tender — same-day Cash Receipt payments, grouped by the payment method's category.
  • Total collected — sum of the four buckets above.
  • AR balance — start / end of day — Customer-side Ledger balance at midnight and at end-of-day.
  • AR change — end − start. Positive means receivables grew; negative means more was collected than billed.

P&L roll-up

  • Income — per-account list of revenue accounts that posted today, with the day's net (credits − debits) for each.
  • Cost of Goods Sold — same shape, for COGS accounts.
  • Gross profit — Income total − COGS total.
  • Operating expenses — per-account list of expense accounts that posted today.
  • Operating income — Gross profit − Operating expenses total.
  • Net income for the day — Operating income (Other income/expense bucketing lands in a future release).
  • Variance check — at the bottom of the band, the system compares (Collected − Refunds) against (Net revenue + AR change). A non-zero variance is flagged with a red banner: a posting from another module affected the books today; investigate during the reconcile step.

Tips

  • The "Closed" chip on the date strip means the night audit has been finalised for that day. Reports for closed days are stable; reports for open days update as new transactions post.
  • Print opens a clean print preview in a new tab. No chrome, no sidebar, just the report. Use it to keep paper copies in the night audit folder for compliance.

What is on the report

The four figures at the top — occupancy, net revenue, money collected, net income for the day.

Four bands below them: Occupancy, Revenue, Collections & AR, and the P&L roll-up from the ledger.

Profitability — room and department contribution at three period scopes: the day, month to date, and year to date. Tap Day, MTD or YTD to switch. It breaks down by room type, by department, and by individual room.

This is contribution, not profit. A room's cost here is what was consumed in it — the amenities housekeeping delivered. Overheads such as electricity, salaries and rent are not included, so a room showing a healthy margin has not yet paid for the building. Do not set room rates from this figure alone. The report says the same thing in an amber band above the numbers.

The day in detail — cards for guests in house, arrivals, departures, sales by category, purchases, money received, cash movement, income by department, and anyone who checked out still owing. When restaurant or bar tables are still open, a Tables still open card lists them with their unbilled value; their sales are not in the other figures until billed. It only appears on the report for the day being closed, not when you look back at an older date. Each card shows the headline figure; tap it to open the full report behind it.

Each card is tagged Operational or Financial. If you only hold one of those permissions you will see only those cards, and a line under them says so — so a short list means limited access, not a quiet day.

Worth your attention

Above the bands you may see coloured cards — occupancy falling, sales holding up while collections do not, one customer holding most of what you are owed. These come from the report's own figures, not from anybody's opinion. An empty space here is the good outcome.

Some cards carry a line marked Suggested. That sentence is written by an AI from the finding above it — never from your money figures, which are not sent. It is a suggestion, not a measurement. Everything above it is calculated.

Staff activity

A Staff activity card counts what each person changed in the system that day: total actions, how many were edits, and how many were deletions. It is a count, not a list — the full trail lives in the Audit Log.

Deletions are shown separately from edits on purpose. An edit leaves a record of what the value used to be; a deletion leaves an absence. That makes the deletion column the one worth glancing at, not because deleting is wrong — correcting a mistyped line is ordinary work — but because it is the change that cannot be read back later.

You may occasionally see a card noting that deletions were well above the fortnight's norm, or that one person made almost every change that day. Neither is an accusation. A correction run explains the first; a small team on a quiet day explains the second. They are flagged because they are worth a look, and the wording says exactly that.

Ask about this day

If your administrator has switched it on, an Ask about this day button lets you ask questions in plain language — "why is occupancy lower than last week?", "who owes us the most?".

Before using it, understand what it does. Answering sends that day's figures — revenue, collections, receivables, net income — to an external AI service. The coloured cards above never do this; they send only percentages. That is why the assistant is a separate switch in Preferences, off until somebody turns it on.

It answers only from this report. Ask it something the report cannot address and it will say so rather than guess — if it ever quotes a figure you cannot find on the report, treat that as a fault and tell us.

Reading it on a phone

The top four tiles are the summary: occupancy, net revenue, money collected, and net income for the day. Amounts there are shortened — ₦1.2m, ₦880k — so they fit. The bands underneath always carry the exact figure, so use those when you need the precise number.

Net income is coloured: green when the day made money, red when it did not.

Common problems

  • Numbers look low / zero — confirm the date. Check the Closed chip on the date strip. Reports for today early in the morning will naturally have fewer transactions than late-evening reports.
  • No data anywhere — the API isn't reaching the tenant DB. Refresh; if it persists, check the Server Status page in Setup.
  • AR change doesn't line up with collections — a posting from another module (e.g. an unposted purchase that cleared today) is affecting the ledger. The reconciliation step of the night audit surfaces these.
  • "Permission denied" — your user is missing the Night Audit role code. Ask an Administrator to enable it on your User record.

See it working on your own business

Start a 45-day free trial — no card needed — and follow this guide in your own practice company.