Reports, exports & night audit

Reports & Analytics shows revenue, occupancy, attendance, loyalty and stock as live queries, nothing is pre-computed, so what you see is what the database holds right now. From here you can queue an Excel or PDF export, print the page, and close the business date (the night audit).

You only see sections your role can read elsewhere: revenue, payments and inventory need Payments view; occupancy, booking sources and room-type performance need Bookings view; housekeeping and maintenance need Rooms; attendance needs Staff; loyalty needs Guests. Exports follow the same rule, so a workbook never contains a sheet you could not see on screen.

• Net receipts: payments received minus refunds per hotel-local day, for the whole period; the dashed line is the same series for the previous period when Compare is on.
• KPI definitions: Occupancy = room nights sold ÷ room nights available (rooms × days). ADR = room revenue ÷ nights sold. RevPAR = room revenue ÷ nights available. Average stay = nights ÷ stays that arrived in the period. Room revenue = the agreed nightly rate × nights that fall in the period for confirmed, in-house and departed stays. Outstanding is the balance of every open folio right now, not a period figure.
• Occupancy: rooms occupied per night as a share of all rooms, with the previous period dashed when comparing.
• Check-ins and check-outs: arrivals and departures per day over the last two weeks. Room type performance: occupied nights per type as a share of that type's capacity over the last 30 days.
• Staff attendance: daily attendance % with Present / Late / Absent totals in the header. The card only appears once attendance has been recorded.
• Guest loyalty: guests on file, loyalty members, the returning-guest rate, a bar per tier (Platinum, Gold, Silver, Bronze) and how many guests are in-house right now. Spend figures are collected payments.
• Inventory position: Healthy / Low stock / Out of stock counts and how many items carry expiry dates. Full detail is on the Inventory page.
• Booking sources: a count per source (Direct, Walk-in, Booking.com, Expedia, Travel Agent, Corporate) for bookings created in the last 90 days.
• Operations tiles: rooms cleaned and the average clean turnaround (task created to Ready), open work orders, attendance % (present plus late over everything recorded) and guests created in the period.

The page refreshes itself whenever a booking, invoice, housekeeping task, work order, room or staff record changes anywhere in the hotel, you do not need to reload.

1. 1
   Click Export Excel or Export PDF

   Needs Reports Full. The toast reads “Export queued. It appears below when ready”. The request carries the current period (30 days).
2. 2
   Watch the Exports tray

   The row starts as Queued, moves to Running while the worker builds the file, then Ready (or Failed with the reason next to the badge). The tray refreshes on the export.done live event, so there is nothing to poll.
3. 3
   Download

   Click Download on a Ready row. Anyone with Reports View can download; the file is named reports-2026-09-04.xlsx or .pdf. A “Export ready, reports-2026-09-04.xlsx. Download it from Reports” notification also arrives in the System category.

• Excel workbook sheets: Overview, Revenue, Occupancy, Check-in out, Room types, Booking sources, Staff attendance, Guest tiers, Inventory, each only if you may see that section. The hotel name, address and generation time sit in the title block.
• PDF: the same sections laid out as a printable report.
• Guest list: the Export button on the Guests page queues a guests-xlsx export (code, name, phone, email, country, tier, stays, lifetime spend). It needs Reports Full and Guests view, and it downloads from this tray too.
• Retention: files are stored for 30 days; older ones are pruned whenever a new export is queued. The tray lists the 20 most recent. Files above 5 MB fail rather than store.

1. 1
   Check the business-date strip

   It shows today’s hotel-local date (from the timezone in Settings → Branding & locale) and whether it is still open.
2. 2
   Click Close 2026-09-04 in the toolbar

   Needs Reports Edit. The button is hidden once the day is closed.
3. 3
   Confirm “Close 2026-09-04?”

   Dialog text: “This freezes a snapshot of occupancy, cash and open invoices for the hotel-local business date. You cannot close the same day twice.” Click Close business date.
4. 4
   Done

   Toast “2026-09-04 closed”; the strip changes to “Closed 23:58” and an audit-log row night_audit.closed carries the snapshot.

• View: open the page, read every section your other module levels allow, list and download exports, see the night-audit status.
• Edit: Close business date. By default this includes the Accountant and HR Manager.
• Full: Export Excel, Export PDF and the Guests page Export button. The Export action is a Full-level action everywhere in the app, so by default only Super Admin and Hotel Manager produce files; Accountants download them.

Business date

The hotel-local calendar day (per the timezone in Settings), which is what the night audit closes.

Night audit

The daily close: a frozen snapshot of rooms, bookings, cash and open balances, plus a room-state re-sync.

Export tray

The Exports card listing the last 20 generated files with their status.