The Night Audit Workflow That Catches $500+ in Daily Leakage Most Hotels Miss

Most hotel managers run their night audit reports and move on. They don't realize they're leaving hundreds of dollars on the table every single shift, missing charged fees, wrong room rates, uncaught no-shows, and payment gaps that compound daily. The night audit isn't just a box to check. It's your last defense against revenue leakage.

This post walks you through a structured night audit workflow that goes beyond "run the report." You'll learn what to verify, when to escalate, and how to catch the errors your PMS doesn't automatically flag.

Start With Room Rate Verification Before Anything Else

Room rate errors are the sneakiest revenue leak. A guest books at $89, but someone manually inputs $79, and that $10 difference gets lost in the daily noise. Or a guest requests an extra bed mid-stay, but the rate never updates. Over a week, these small gaps add up to hundreds of dollars.

Your first night audit task is to run your Room Rate Variance report, most PMS systems have this. It sorts all occupied rooms by rate code. Cross-check three things: (1) Is the rate in the system what the reservation shows? (2) Did any guest request service changes (extra bed, late checkout, additional guests) that should trigger a rate adjustment? (3) Are any rates below your minimum or above your expected range for that day?

If you spot a mismatch, don't just note it. Document exactly which folio it's on, the correct rate, and why the change is needed. This creates an audit trail that prevents the same error repeating.

Reconcile the Cash and Credit Card Report Against Postings

Payment discrepancies happen when cash or card transactions don't match what posted to the guest account. Someone pays $150 in cash, but only $140 appears on their folio. Or a credit card goes through twice. These aren't always your fault, payment processors sometimes create duplicate transactions, guests may have made partial payments, or there's a genuine cash-handling error.

Pull your daily payment reconciliation report. This should show total cash collected, total card payments processed, and total amounts posted to guest accounts. The sum of cash + cards should equal total postings (minus any payments posted from previous days). If the numbers don't match, the variance is your starting point.

When variance is small ($5-20), document it as a minor variance and flag it for the morning manager. These often self-correct the next day or are legitimate timing differences.

When variance is larger ($50+), dig deeper. Pull individual transaction records. Did a guest check out without settling? Is a pending charge still processing? Was a refund issued but not posted? Create an exception log entry with the guest name, amount, date, and next action (call guest, contact payment processor, etc.).

Hunt for Posted Charges That Never Matched a Folio

This is where your revenue system can trick you. The PMS shows "total charges $3,200" and "total payments $3,100", a $100 gap. But where did that $100 go? It might be a service charge that posted but wasn't assigned to any guest, a departmental charge (F&B, laundry) that hasn't been routed yet, or an orphan transaction.

Run an unapplied credits and charges report. This shows any money sitting in limbo. If there's $100 floating around, trace it back: What was charged? When? To which department or guest? If you can't match it to a specific folio within 5 minutes, escalate it immediately. Don't roll the business day with mystery charges.

Verify Every No-Show Against Cancellation Policy

No-show leakage kills revenue. A guest books, doesn't show, doesn't cancel, and sometimes the room fee never gets charged. Other times it's charged but then refunded by accident. Or a guest shows up two days after their reservation was marked no-show, creating a mess.

Pull your arrivals and departures report with no-shows flagged. For each no-show, confirm: (1) Was the no-show fee (or room charge) actually posted to the guest's account? (2) Did it match your cancellation policy (24-hour notice, 1-night penalty, etc.)? (3) Is the guest dispute-prone or a repeat no-show who needs a call tomorrow?

If the no-show fee wasn't charged, post it immediately, don't wait for the morning. If it was charged but the guest disputes it later, you have documentation from the audit that you did your job. If it's a repeat offender, flag their folio for a call or a deposit requirement on future bookings.

Cross-Check Guest Folios Against Room Status

Room status mismatches create both billing and operational chaos. A room shows "occupied" in the system but the guest checked out. Or it shows "vacant" but a guest is still there. When this happens, the night auditor is often the only person who catches it during the audit.

Run a room status report and walk the property (or have your night staff do a quick visual check of key rooms). Match every occupied room in the system to an actual guest in that room. If a room shows occupied but is clearly empty, mark it as checked out immediately, this prevents an erroneous room charge from posting. If a guest is in a room that shows vacant, update the status so tomorrow's housekeeping knows not to clean it.

These small fixes prevent double-charging, skipped cleanings, and guest complaints about unexpected charges.

Document Every Exception With Ownership and Deadline

Exceptions are normal. The goal is not to eliminate them, it's to control them. A consistent night audit reconciliation method builds trend visibility and strengthens daily financial discipline. Each discrepancy you find should go into an exception log with these details: what the issue is, the dollar amount, when it occurred, the likely cause, who's responsible for fixing it, and a deadline.

For example: "Room 304 charged $89 instead of $99 (rate variance). $10 shortfall. Guest checked out 9/15. Front desk manager to review booking and post adjustment by 10 AM." This one-line entry turns chaos into accountability.

Review your exception log weekly. Are the same errors repeating? (Room rate input mistakes, payment processor glitches, staff handling cash incorrectly?) That's your signal to retrain or fix a process. Most hotels that plug revenue leaks find that 60-70% of discrepancies trace back to 2-3 preventable causes.

Run Reports in the Right Order, Then Roll

Your night audit sequence matters. Do it out of order and you'll miss dependencies. The workflow should be: (1) Post room charges and service charges to all folios, (2) Verify room rates (catch errors before finalizing), (3) Reconcile payments (identify cash/card gaps), (4) Review guest folios for errors or adjustments, (5) Generate management reports (occupancy, revenue, tax), (6) Document exceptions, (7) Roll the business day.

Don't skip to step 7 just because you're tired. Rolling the day locks everything in. Once it's rolled, corrections become more complicated and slower for your back office team. Take the extra 15 minutes to verify and document. That's where the $500+ leak gets plugged.

Set Up a Weekly Leakage Review

One-time catches matter, but patterns matter more. Every Friday (or Monday, depending on your shift), sit down with that week's exception logs. Total up the variances: How much in rate errors? How much in payment discrepancies? How much in no-show fees not charged? Where are the biggest gaps?

If no-shows cost you $300 last week but your no-show policy charges $150/night, something's broken. If payment discrepancies averaged $50/night, your payment processor might be causing duplicates, or your staff needs training. If room rate errors totaled $200, your front desk booking procedure needs a fix.

Bring these trends to your morning meeting. The goal is continuous improvement, not blame. "We caught $400 in leakage this week. Here's what we're fixing this week to prevent it next week."

Takeaway

The night audit is not just reconciliation, it's revenue protection. When you skip the deep verification steps, you're leaving $500+ per week (or more) in daily leakage that compounds across a month and a year. A structured workflow that verifies room rates first, reconciles payments second, hunts for exceptions third, and documents everything systematically turns your night audit into a profit center instead of a chore. Start with your rate variance report tomorrow night and build from there.