1. Night audit should isolate exceptions, not recheck every OTA reservation from the beginning.
2. Resolve anything that can change occupancy, guest balances, room status, or tomorrow's arrivals.
3. Keep the OTA confirmation and the PMS record together when documenting a correction.
4. Do not close a business day with an unexplained duplicate, open balance, or missing arrival.
An OTA reservation night audit checklist gives the closing team one final chance to catch problems while the day's records are still easy to verify. The goal is not to prove that every booking is perfect. It is to find the few reservations that could carry a wrong balance, room count, guest status, or arrival instruction into the next business day.
For a hotel owner, a clean close means tomorrow's front desk can trust the arrival list, housekeeping can trust room status, and finance can trust the day's revenue. The eight exceptions below deserve attention before the night auditor completes the close.
Set the Review Window Before You Start
Use the PMS business date, not only the clock on the wall. Around midnight, the calendar date and the hotel's open business day may be different. Confirm which stays, departures, no-shows, and payments belong to the day being closed.
Then filter for exceptions. Review OTA reservations with recent changes, cancelled or no-show status, open balances, manual adjustments, duplicate names, unassigned rooms, or a difference between the OTA and PMS. A connected hotel management software view should make those exceptions easier to isolate without rebuilding the day from separate spreadsheets.
Assign one person to make corrections and another person to approve high-risk actions such as deleting a duplicate, waiving a charge, issuing a refund, or changing a final reservation status. That separation prevents a rushed close from becoming an accounting problem.
Exceptions 1–2: Missing and Duplicate OTA Records
1. A confirmed OTA booking is absent from the PMS
First confirm the reservation is active in the OTA account and belongs to the correct property and date. Search the PMS by OTA confirmation number, guest surname, arrival date, room type, and all statuses. The booking may be present but hidden from the normal arrival view.
If the booking is genuinely missing, protect the room and follow the hotel's controlled manual-entry process. Mark the temporary record for follow-up so a delayed automated copy is not accepted as a second stay. The night-audit note should include the OTA reference, room held, action owner, and next review time.
2. Two PMS records appear to represent one OTA stay
Do not delete the record that looks newer or emptier until you know which one remains connected to the OTA. Compare external references, change history, room assignment, payment entries, guest messages, and inventory impact.
Keep one operational record, move only the information your PMS procedure allows, and close the extra record without cancelling the genuine OTA reservation. Confirm that inventory is held once—not twice and not zero times. A dependable channel manager helps preserve the relationship between the OTA reference, the PMS booking, and the affected room inventory.
When these two exceptions are handled from disconnected screens, staff can easily protect the wrong record or count the room twice. Smart Order keeps incoming channel reservations and the hotel calendar in one workflow, giving the closing team a clearer record to verify before the date rolls forward.
Close the Day With One Trusted Reservation Record
Bring OTA bookings, PMS inventory, and exception follow-up into one operating view so tomorrow's team starts with reliable arrivals and room counts.
Exceptions 3–4: Changes That Affect Tomorrow
3. A modified reservation still shows the old dates or room
Compare the current OTA booking with the PMS record. Focus on arrival, departure, room count, room type, guest count, total price, and payment responsibility. An old confirmation email is not the final record after a modification.
If the stay moved away from tomorrow, remove it from tomorrow's operational workload only after the PMS record is corrected. If it moved into tomorrow, ensure it appears on the arrival list, has a valid room assignment or room-type hold, and carries the latest notes. Document any manual correction so the morning shift does not restore the old version.
4. A cancellation remains active—or an active booking looks cancelled
Open the current OTA reservation and verify its final status. A guest message asking to cancel, a fee-waiver request, or a payment warning is not the same as a completed cancellation.
If the OTA shows a final cancellation, confirm the PMS no longer treats the booking as an active arrival and that inventory changed only once. Then handle fees according to the booking terms and the party responsible for collecting payment. If the OTA still shows confirmed, do not cancel the PMS stay merely to clear an exception report.
Exceptions 5–6: Guest Status and Room Status
5. A guest is physically in the hotel but not checked in
This exception understates occupied rooms and may leave the entire stay's room revenue in the wrong day. Confirm the guest identity, room number, actual arrival, and payment record. Then complete the check-in using the hotel's approved late-arrival procedure.
Check multi-room reservations carefully. One room may have arrived while another remains expected. Do not mark the whole reservation checked in or no-show without confirming each room.
6. The reservation status and physical room status disagree
A checked-out guest with an occupied room, or an in-house guest whose room appears vacant and clean, requires immediate verification. Call the front desk or duty manager, then confirm the room physically when needed. Do not let a screen status override what staff can verify on property.
Correct the guest status first, then the room status, and record who made the change. This preserves the sequence housekeeping and the next shift need. If the room cannot be verified, block it from assignment until the morning team resolves the exception.
Exceptions 7–8: Money That Does Not Reconcile
7. The OTA payment instruction and PMS balance disagree
Identify who collected the money: the OTA, the hotel, or both for different parts of the stay. Compare the OTA's current payment instruction with posted payments, deposits, refunds, taxes, fees, and remaining balance in the PMS.
Do not charge a guest simply because the PMS says unpaid. The OTA may already have collected the booking total or may provide another settlement method. Record the expected collection method and move any uncertain case to a manager or finance queue before checkout.
8. Revenue or commission has no clear reservation basis
Review reservations with manual rate changes, cancellations, no-shows, shortened stays, or commission adjustments. The room revenue recorded for the day should match what the hotel actually earned under the final reservation status. Commission should remain tied to the reservation and the amount on which the OTA calculates it.
Use hotel reports and analysis to compare daily room revenue, channel production, open balances, and adjustments. Night audit does not need to finish the monthly OTA invoice, but it should flag any reservation whose amount cannot be explained from the final booking record.
What Must Be True Before You Close
The closing manager should be able to answer four questions without guessing: How many rooms were actually occupied? Which OTA reservations arrive next? Who owes money on each unresolved stay? Which exceptions are assigned to a named person for follow-up?
Do not force every issue to zero merely to finish the shift. Some exceptions genuinely need OTA, payment, or PMS support. In those cases, preserve the booking, protect inventory, document the amount at risk, and assign a deadline. A visible exception is safer than a silent correction that no one can explain tomorrow.
Your handover note should identify the reservation, the confirmed current status, what was changed, what remains unresolved, and who owns the next action. Avoid full card details or sensitive guest documents in ordinary notes.
A Simple Owner Review the Next Morning
Owners and general managers do not need to repeat the night audit. Review the exception log, confirm that open items have owners, and look for recurring causes. Repeated missing modifications may point to a connection or mapping problem. Repeated payment uncertainty may point to unclear front-desk procedures. Repeated room-status differences may need a housekeeping handoff reset.
The best night audit is short because the hotel catches exceptions throughout the day. Use this checklist as the final control, then improve the process that allowed each repeated problem to reach closing time.
Frequently Asked Questions
Should night audit compare every OTA booking with every PMS record?
No. Start with exception filters and high-risk reservations: recent changes, cancellations, no-shows, duplicates, missing arrivals, open balances, manual corrections, and room-status differences. Expand the review only when totals or occupancy still do not reconcile.
Can the hotel close with an unresolved OTA exception?
Yes, when the issue cannot be resolved safely overnight. Protect the guest and inventory, record the financial exposure, assign an owner and deadline, and keep the exception visible for the next shift.
Who should approve changes during night audit?
The hotel's authority policy should decide. High-risk actions such as refunds, fee waivers, deletion of duplicate records, and final no-show decisions should normally require a supervisor or manager.
What is the most important final night-audit check?
Confirm that physical occupancy, active PMS stays, tomorrow's arrival list, and unresolved guest balances tell the same operational story. Any difference needs either correction or a documented handover.
