🚧 Under construction — VoTechWorks is being built. A free tech program — complimentary, as our commitment to get America working.
voTechWorksGrade 13 · a vocational technology learning center, by urbanicity
newSchoolWorks.com › VoTechWorks › Hospitality, Food & Tourism › Hotel & Hospitality Operations › Property Management Systems (PMS) for Hotel Operations › Lesson 7
HOS-HOTE29-06 · Lesson 7 · 14 clock hours · lab

Night Audit: End-of-Day Processing and Balancing

Objective. Students will execute the night audit sequence in the PMS training environment — posting room and tax charges, running departmental trial balance, resolving out-of-balance conditions, and closing the business date — producing a balanced audit report.

⚠ Pending professional review

This lesson, its worked examples and its practice questions has not yet been verified by a certified food-safety manager and industry professional or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.

VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.

What the Night Audit Is — and Why It Matters

The night audit is the process that closes one business day in the property management system (PMS) and opens the next. It happens during the overnight hours — typically between midnight and 6 a.m. — when guest activity is lowest. The audit serves three purposes: it posts all outstanding charges to guest folios, it verifies that every dollar of revenue is accounted for, and it produces the management reports that the morning team will use to run the property. A clean, balanced audit is the backbone of accurate hotel accounting and confident operational decisions.

The Night Audit Sequence

Most PMS platforms follow the same logical sequence. Your printed checklist keeps you on track; initial every step as you complete it.

1. Run the No-Show Report. Compare expected arrivals against actual check-ins. Guests listed as no-shows must have their reservations handled according to property policy — usually charged one night if a guaranteed reservation was held — before room charges are posted.

2. Post Room and Tax Charges. The PMS auto-posts the nightly room rate and applicable room tax to every occupied folio. Verify that the correct rate plan posted to each room type. A deluxe king should not receive a standard queen rate, and vice versa. Rate plan errors are one of the most common causes of an out-of-balance condition.

3. Run Departmental Totals. Each revenue center — rooms, food and beverage, parking, spa — produces a subtotal. The sum of all departmental totals must equal the total charges posted that day.

4. Reconcile to the Trial Balance. The trial balance compares what the PMS recorded against what each outlet reported independently. If the figures match, the audit is in balance. If they do not, you have an out-of-balance condition that must be resolved before you close the date.

5. Resolve Any Variances. Pull the room revenue report and compare it line by line against the expected totals table. Locate the posting that does not match — wrong rate, wrong room, duplicate entry, or missing charge. Correct the posting in the PMS, then re-run the trial balance to confirm the variance is now zero.

6. Close the Business Date. Once the trial balance shows zero unexplained variance, you close the business date. This action is generally irreversible in a live system; in your training environment it can be reset by the instructor, but treat every practice close as final. After the close, the PMS rolls to the next date automatically.

7. Generate and Export Key Reports. Immediately after closing, produce the following minimum report set: occupancy report, room revenue report, departure list for the coming day, and arrivals list for the coming day. Save or print each one. These reports belong to that closed business date; if the system is updated later, the night audit reports preserve a permanent snapshot.

Using Reports to Drive Operational Decisions

The AHLEI Hospitality Supervisor exam area on using data for operational decisions is directly connected to what you do in the final step of the audit. A morning manager scanning the occupancy report can see the house count and immediately decide staffing levels for housekeeping. The departure list tells the front office how many checkouts to expect and when the rooms will be available for incoming arrivals. The room revenue report flags any rate discrepancies that the revenue manager needs to address. When you annotate your printed reports, you are practicing the same analytical habit a supervisor uses every morning.

Out-of-Balance Conditions: Finding and Fixing Them

An out-of-balance condition means the numbers do not agree. The most efficient way to find the error is to compare the PMS room revenue report, rate plan by rate plan, against your expected totals table. When you find a line that is off, ask two questions: Is the dollar amount wrong, or is it in the right amount but posted to the wrong category? A room charged at $129 instead of $149 is a rate error. A room charged at the correct rate but coded as the wrong room type is a classification error. Both appear as variances; both must be corrected with a posting adjustment before you can close.

Always document what you found and what correction you made. In a live property, that documentation protects the audit trail and gives the general manager a clear record.

Safety and Data Integrity Points

The night audit is a low-physical-hazard task, but data integrity is its equivalent of safety. Several practices protect the integrity of the audit:

Connecting to Your Credentials

All three AHLEI credentials you are working toward touch the night audit. The Guest Service Professional credential covers folio accuracy and charge posting. The Front Desk Representative credential addresses the audit sequence and report generation. The Hospitality Supervisor credential expects you to interpret the resulting reports and use them to direct the morning operation. Tonight's lab exercises all three of those skill layers at once.

Key terms9

Night auditThe end-of-day process in the PMS that posts outstanding charges to guest folios, reconciles all revenue totals, and closes the business date so the system rolls to the next day.
Trial balanceA PMS-generated summary that compares total charges posted by the system against independently reported totals from each revenue department; a zero variance means the audit is in balance.
Business date closeThe PMS action that locks the current day's transactions and advances the system calendar to the next date; on a live system this is generally irreversible.
Room charge postingThe automated step in the night audit sequence that applies the nightly room rate and applicable tax to every occupied guest folio based on the assigned rate plan.
Rate planA defined pricing structure in the PMS (for example, standard queen, deluxe king, AAA rate) that determines the room rate applied to a reservation during charge posting.
Out-of-balance conditionA state in which the PMS trial balance shows a discrepancy between posted totals and departmental reports, requiring identification and correction of the posting error before the business date can be closed.
No-show reportA PMS report generated at the start of the night audit that lists guaranteed reservations for which the guest never checked in, allowing the front desk to process applicable no-show charges before room posting begins.
Occupancy reportA key night audit output showing the total number of rooms occupied, vacant, out of order, and the resulting occupancy percentage for the closed business date.
Audit trailThe PMS log that records every transaction, correction, and user action during the night audit, providing a verifiable record for management review and accounting purposes.

Worked examples4

1. The room revenue report shows total room revenue of $14,820. The expected totals table shows room revenue should be $14,970. Identify the variance amount and determine what type of error likely caused it.
  1. Step 1 — Calculate the variance: $14,970 (expected) − $14,820 (posted) = $150 variance. The posted total is $150 short.
  2. Step 2 — Consider what posting error produces a $150 shortfall. If one room was charged $129 instead of $279, the shortfall would be $150. Alternatively, if one room at $149 was posted to a $0 comp rate incorrectly, the shortfall would be $149 — not a match. A $150 shortfall is consistent with a room that should have been charged $279 (deluxe rate) but was charged $129 (standard rate): $279 − $129 = $150.
  3. Step 3 — Locate the suspect folio. Filter the room revenue report by rate plan. Look for any room assigned to a deluxe room type that shows a $129 posting instead of $279.
  4. Step 4 — Confirm the correct rate by checking the original reservation record. Once confirmed, post a rate adjustment of +$150 to the correct folio.
  5. Step 5 — Re-run the trial balance. Expected total $14,970 should now equal posted total $14,970, variance = $0.
Answer: The variance is $150. The most likely cause is a room charged at the standard rate ($129) instead of the correct deluxe rate ($279). Correcting the folio by posting a $150 adjustment and re-running the trial balance should bring the audit to zero variance.
2. After posting room charges, the trial balance shows: Rooms Revenue posted = $9,450; Food & Beverage posted = $1,230; Parking posted = $180. The departmental totals report shows: Rooms = $9,450; F&B = $1,230; Parking = $210. What is the variance, which department is out of balance, and by how much?
  1. Step 1 — Compare each department individually. Rooms: $9,450 = $9,450 ✓. F&B: $1,230 = $1,230 ✓. Parking: PMS posted $180 vs. departmental report $210.
  2. Step 2 — Calculate the parking variance: $210 − $180 = $30. The PMS posted $30 less than the parking department reported.
  3. Step 3 — The overall trial balance variance is $30. Only the parking department is out of balance.
  4. Step 4 — Investigate parking postings for the business date. Look for a folio where a $30 parking charge may have been omitted or posted to the wrong account.
  5. Step 5 — Correct the missing or misapplied $30 charge, then re-run the trial balance to confirm a zero variance before closing the date.
Answer: The variance is $30 in the Parking department (PMS posted $180; department reported $210). All other departments are in balance. A missing or misapplied $30 parking charge must be located and corrected before the business date can be closed.
3. A hotel has 120 rooms. On the night audit occupancy report, 96 rooms show as occupied and 4 rooms show as out of order. What is the hotel's occupancy percentage for that night, calculated on rooms available (total rooms minus out-of-order rooms)?
  1. Step 1 — Determine rooms available: 120 total rooms − 4 out of order = 116 available rooms.
  2. Step 2 — Apply the occupancy percentage formula: Occupancy % = (Rooms Occupied ÷ Rooms Available) × 100.
  3. Step 3 — Substitute the values: (96 ÷ 116) × 100.
  4. Step 4 — Perform the division: 96 ÷ 116 = 0.8276 (rounded to four decimal places).
  5. Step 5 — Multiply by 100: 0.8276 × 100 = 82.76%. Round to two decimal places as is standard on hotel reports: 82.76%.
Answer: The hotel's occupancy percentage for that night is 82.76%, based on 96 occupied rooms out of 116 available rooms.
4. During the night audit, you find that room 214 (a king suite with a rate of $249/night) was accidentally posted at $149/night — the standard king rate — and room 302 (a standard king at $149/night) was posted correctly. You need to calculate the total adjustment required and confirm the corrected revenue for both rooms.
  1. Step 1 — Identify the error. Room 214 should be $249 but was posted at $149. Room 302 was posted correctly at $149.
  2. Step 2 — Calculate the adjustment needed for room 214: $249 (correct rate) − $149 (posted rate) = $100 additional charge to post.
  3. Step 3 — Room 302 requires no adjustment since it posted correctly.
  4. Step 4 — Post a $100 rate adjustment to room 214's folio, bringing its nightly total to $249.
  5. Step 5 — Confirm: Room 214 corrected total = $149 (original posting) + $100 (adjustment) = $249. Room 302 total = $149. Combined two-room revenue = $249 + $149 = $398. Re-run the trial balance to verify the $100 variance is now resolved.
Answer: A single adjustment of +$100 posted to room 214's folio corrects the error. After the adjustment, room 214 shows $249 and the trial balance variance of $100 should be eliminated.

The math in this lesson1

Learners compute a $150 posting variance and test which rate error explains the shortfall.
A-SSE.1
Brush up in the math halls at newSchoolWorks.com:
In class: Night audit sequence walkthrough: working from a printed night audit checklist, students follow each step in the PMS training environment (run no-show report, post room charges, post taxes, run departmental totals, reconcile to the trial balance) and initial each step on the checklist as completed. · Out-of-balance drill: the instructor has pre-loaded a training day with one intentional posting error (a room charge applied to the wrong room type rate); students must identify the discrepancy by comparing the room revenue report to the expected totals table provided, then correct the posting and re-run the trial balance. · Business-date close and report generation: students close the business date and immediately generate and print or export the day's key reports (occupancy report, room revenue report, departure list for next day, arrivals list); they annotate each report identifying two actionable data points a morning manager would use — connecting to AHLEI Hospitality Supervisor exam area on using data for operational decisions.
Materials: PMS training environment; printed night audit checklist (instructor-prepared); expected totals table for out-of-balance drill; AHLEI Managing Front Office Operations textbook chapter on the night audit; lab log booklet
Check: Audit report submission: student submits the exported trial balance and occupancy report showing a balanced close; pass = business date closed with zero unexplained variance, all required reports generated, and out-of-balance posting identified and corrected (instructor verifies in PMS audit trail); 85% rubric score required.

Practice check8

Answer each question, then check it. Nothing is recorded; this is your own practice.

Front Office Operations / Night Audit Procedures
1. Which step in the night audit sequence must be completed BEFORE posting room and tax charges?
Front Office Operations / Night Audit Procedures
2. A night auditor finds that the PMS trial balance shows a $75 variance — the system posted $75 less in room revenue than the rooms department reported. What is the FIRST action the auditor should take?
Front Office Operations / Night Audit Procedures
3. Why is the business date close considered a critical and generally irreversible action on a live PMS?
Hospitality Supervisor / Using Data for Operational Decisions
4. A Hospitality Supervisor reviews the night audit occupancy report and sees that occupancy was 58% on a night when the hotel had budgeted 75%. Which operational decision would this data most directly support?
Front Office Operations / Folio Management
5. During the out-of-balance drill, a student finds that room 118, a standard queen priced at $129, was posted at $189 — the deluxe queen rate. What is the correct adjustment to bring the folio into balance?
Front Office Operations / Report Generation and Use
6. Which report generated immediately after the night audit close would a front office manager use to prepare for the next morning's checkout activity?
Front Office Operations / Occupancy Statistics
7. A hotel has 200 total rooms, 6 of which are out of order. On a given night, 156 rooms are occupied. What is the occupancy percentage based on available rooms?
Hospitality Supervisor / Accountability and Record Keeping
8. From a data-integrity standpoint, which practice is MOST important when a night auditor discovers and corrects a posting error?
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.
← Previous lessonProgram planNext lesson →