The actual Luna daily audit email, viewed on a phone — no login or dashboard required.
🔒Everything below stays exactly where it lives — your own Google Drive. Luna isn't a separate service with its own servers; it's an add-on that runs entirely inside your own Google Sheet, using Google's own infrastructure. There's nothing to send it to, because there's nowhere else for it to go. This isn't just a promise — it's
CASA (Cloud Application Security Assessment) Tier 2 certified, Google's own third-party security assessment for apps handling data like this.
Traditionally, this is the one part owners actually read out of a 40-page night audit report — and the rest usually goes unopened, not from lack of interest, but from lack of time and the discipline to check it every single night. Business Snapshot puts that quick overview — occupancy, ADR, RevPAR, revenue, arrivals, cancellations — right at the top, in plain numbers, before any of the audit flags below it. The one part everyone actually wants, given to you without having to go looking for it.
🔒Every number above — every guest, every dollar, every adjustment — stays inside your own Google account. Luna runs as an add-on inside your Sheet, not as a separate service somewhere else — there's no outside server for any of it to travel to.
CASA (Cloud Application Security Assessment) Tier 2 certified: independently assessed, then validated by Google itself.
Every morning's email includes a set of audit flags — each one a specific check against
last night's activity. Here's what each one is actually looking for, in the same order
they appear in the email.
Owed to Hotel (not in-house, excl. direct-bill)
Guests who checked out today still owing money — the fresh alert, not the full running list. Most PMS systems won't let a guest check out with a balance at all — which is exactly why this happens: front desk zeroes the balance to force the checkout through, then reverses it afterward, restoring what's actually owed. This is the secondary check built specifically to catch that pattern. Excludes direct-bill accounts, since their balance goes to the company, not the guest.
Show more
📋 Direct Bill Violations
Direct bill accounts — CLC and other corporate contracts — typically only pay for room, tax, and mandatory hotel charges. They don't pay for a gift shop item, a vending charge, or anything else outside that agreement. Catch it the moment it happens, not weeks later when the invoice comes back disputed — this is exactly the kind of thing that damages a corporate relationship, and enough of it can cost you the account entirely.
Show more
🧾 Adjustments
Your fingerprint on every correction. Every negative charge reversal and manual adjustment, the night it happened — who made it, on which room and account, and exactly how much. Not a summary, a drill-down: click through and you're looking at the original transaction it corrected, side by side. And it's not just tonight's — this holds up to 30 days of history, so if you've been out on a well-earned vacation, you can come back and review every adjustment made while you were away, all in one place.
Show more
🕵️ Departures — No Ledger Activity
A guest checked in and out the same day, before the night audit ever ran — and unless someone manually posted a charge and payment, there's nothing in the ledger for that stay at all. No room charge, no payment, no trace. This is the one check built specifically to catch that: revenue that isn't wrong or missing a few dollars — it never got recorded as existing in the first place.
Show more
No-Show Today: Payment Not Collected / Payment Collected
Every no-show, one glance: who was no-show, and whether the fee's already collected or not. Miss it at night audit, catch it the next morning — not at month-end. Luna's own monthly OTA reconciliation would eventually catch a missed fee on a Booking.com or Expedia reservation — but for direct bookings, this daily check is the only thing standing between you and a fee that quietly never gets charged at all.
Show more
⚠️ Rate Discrepancy — In-House
In-house guests whose actual charged rate differs from what's configured for their rate plan — meaning someone at the front desk overrode the rate. Worth a look to confirm the override was intentional and approved.
Show more
🚫 Zero Room Revenue — In-House
Flags in-house guests showing $0 room revenue for the night they just stayed — a secondary check alongside Rate Discrepancy, specifically for a room charge zeroed out completely rather than just overwritten to a lower rate. Since this re-checks every night of a stay, it catches someone editing a rate mid-stay, on a multi-night reservation, the same night it happens — you'll know exactly which room and who made the change. A few cases are excluded on purpose, since $0 is correct there: house accounts, employee-discount (comp) stays, and guests who are cancelled, no-show, or haven't arrived yet.
Show more
🚫 Zero Room Revenue — Checked-Out
Same check, applied once a guest has already left — usually catching a single-night stay where the room rate was $0 for the entire visit, since that's the only night there was to zero out. Worth a look the moment it shows up, since a checked-out folio is harder to correct than one still in-house.
Show more
⏩ Early Departures
Guests who checked out before the date they were originally booked through. This can mean the hotel never collected revenue for the nights they didn't stay on a prepaid reservation — worth confirming the folio was closed out correctly.
Show more
Open Balances — Checked Out
In-house or recently-departed guests who currently owe the hotel money — balance above $0, not on direct bill. The day-to-day "who still owes us" list.
Show more
Automatic cash reconciliation, done for you.
Gross shows every cash dollar collected, split into Room and Other. Net Drop is the number that matters at the safe — Gross minus any cash collected as a future-stay deposit, since that's not tonight's revenue. 30 days of history, so a "shortage" from last week is just as easy to trace back as tonight's.
The one comparison every owner actually cares about.
Are we ahead of last year, or behind? Month-to-date and year-to-date room revenue, shown side by side against the same period twelve months ago — one glance, no spreadsheet, no pulling last year's numbers yourself. Green means you're pacing ahead, red means you're not, with the exact percentage either way. And when the hotel fills up completely for the night, Luna tells you that too.