Hotel AccountingUnit 613 min read

Front Office Accounting & Night Audit: Records, Audits & Reconciliation

Unit 6 of Hotel Accounting covers the daily accounting tasks in hotel front offices—guest ledgers, folio reconciliation, night audit procedures, and how to prepare front office reports like occupancy reports, guest accounts, and management reports. It explains the role of the night auditor, the flow of transactions fro

TAKEAWAYS:

  • Front office accounting records guest transactions (advances, incidentals, charges) in individual folios and control accounts like the Guest Ledger and City Ledger.
  • The night audit is a critical daily process where all front office transactions are reconciled, errors are corrected, and reports are generated for management.
  • Key reports include the Occupancy Report, Guest Account Summary, and Management Report, which help in decision-making and financial control.
  • Reconciliation ensures that the front office cash matches the general ledger and that all guest accounts are settled before closing the day.
  • Night audit procedures include posting transactions, reconciling folios, verifying cash, and preparing the Night Audit Report for the next day’s operations.
  • Errors in front office accounting (e.g., overcharging, underposting, or misclassification) can lead to financial discrepancies and guest dissatisfaction, so accuracy is crucial.

1. Introduction to Front Office Accounting

Front office accounting is the daily recording and reconciliation of financial transactions related to guest services in a hotel. It involves:

  • Tracking guest payments (advances, incidentals, room charges).
  • Maintaining individual guest folios (accounts for each guest).
  • Reconciling cash and credit transactions with the general ledger.
  • Preparing daily reports for management.

The front office is the first point of contact for guests, and its accounting records must be accurate, up-to-date, and reconciled daily to avoid discrepancies.

Key Terms

Term Definition
Guest Folio A record of all transactions (charges, payments) for a single guest.
City Ledger A control account that summarizes all guest folios for a specific city or region.
Guest Ledger A master account that summarizes all guest folios in the hotel.
Night Audit The daily process of reconciling front office accounts and preparing reports.
Occupancy Report A summary of room occupancy, revenue, and expenses for the day.
Management Report A detailed report for hotel management showing financial performance.

2. Guest Folios and Ledgers

Every guest who checks into the hotel is assigned a folio, which records:

  • Room charges (rental, taxes, service charges).
  • Incidental charges (minibar, room service, laundry).
  • Advances (prepaid amounts).
  • Payments (cash, credit card, bank transfer).

Types of Ledgers in Front Office Accounting

classDiagram
    class GuestFolio {
        +Room Charges
        +Incidental Charges
        +Advances
        +Payments
    }
    class CityLedger {
        +Summarizes Guest Folios by City
        +Control Account
    }
    class GuestLedger {
        +Summarizes All Guest Folios
        +Master Account
    }
    GuestFolio --> CityLedger : "Belongs to"
    CityLedger --> GuestLedger : "Part of"

Example: Guest Folio for a Kathmandu Hotel Guest

Assume Mr. Sharma checks into Hotel Himalaya in Kathmandu for 2 nights. His folio would look like this:

Guest Folio #KTM-2024-0501 (Mr. Ram Prasad Shah)Dr.Cr.To Room Charges (Deluxe Room)12,000To Mini-bar (Incidentals)1,500To Restaurant Bill3,200To Laundry800By Advance Payment5,000By Credit Card (Visa)11,500By Balance c/d1,00017,50017,500
Sample debit/credit entries for a single guest folio (NPR values)
Date Particulars Folio No. Amount (NPR) Dr. Cr.
2024-05-01 Room Rental (Deluxe Room) 1001 12,000 12,000
2024-05-01 Service Charge (10%) 1001 1,200 1,200
2024-05-01 Advance Payment (Cash) 1001 8,000 8,000
2024-05-02 Minibar Consumption 1001 2,500 2,500
2024-05-03 Room Service (Breakfast) 1001 1,500 1,500
2024-05-03 Check-Out Settlement 1001 6,200 6,200
Total 1001 14,200 14,200

Explanation:

  • Mr. Sharma paid an advance of NPR 8,000 on check-in.
  • Additional charges (minibar, room service) were added to his folio.
  • At check-out, he settled the remaining balance of NPR 6,200.
  • The folio is balanced (Dr. = Cr.).

3. Night Audit: The Daily Reconciliation Process

The night audit is performed after the hotel closes (typically between 11 PM and 1 AM) to ensure all front office transactions are accurate. The process includes:

Steps in Night Audit

Key Tasks in Night Audit

  1. Posting Transactions

    • All guest transactions (check-ins, check-outs, incidentals) are recorded in folios.
    • Folio reconciliation ensures no transactions are missed.
  2. Reconciliation of Ledgers

    • Guest folios are reconciled with the City Ledger.
    • The City Ledger is reconciled with the Guest Ledger.
    • Any discrepancies are investigated and corrected.
  3. Cash and Bank Reconciliation

    • The front office cash is counted and reconciled with the bank statement.
    • Credit card transactions are verified against the hotel’s merchant account.
  4. Preparing Reports

    • Occupancy Report: Shows room occupancy, revenue, and expenses.
    • Guest Account Summary: Lists all guest accounts and their balances.
    • Management Report: Provides financial insights for decision-making.

4. Front Office Reports

Three key reports are generated during the night audit:

A. Occupancy Report

Shows room occupancy status, revenue, and expenses for the day.

Particulars Amount (NPR)
Rooms Occupied 150
Rooms Available 50
Room Revenue 250,000
Incidentals Revenue 30,000
Total Revenue 280,000
Expenses (Housekeeping) 15,000
Net Revenue 265,000

B. Guest Account Summary

Lists all guest accounts and their final balances.

Folio No. Guest Name Room Charges Incidentals Advances Balance (NPR)
1001 Mr. Sharma 12,000 4,000 8,000 0
1002 Ms. Rai 10,000 2,000 5,000 7,000
1003 Mr. Gurung 8,000 1,500 0 9,500

C. Management Report

Provides financial performance metrics for management.

Metric Value
Total Revenue 280,000
Occupancy Rate (%) 75%
Average Room Rate (NPR) 10,000
Incidentals Revenue (%) 10.7%
Net Profit Margin 25%

5. Common Errors in Front Office Accounting & How to Avoid Them

Error Cause Solution
Overcharging Guests Incorrect room rate applied Verify rates before posting.
Underposting Transactions Forgetting to record charges Double-check folios before night audit.
Cash Discrepancies Theft or miscounting Conduct a cash count before reconciliation.
Folio Not Balanced Arithmetic errors Use trial balance for folios.
Credit Card Errors Incorrect merchant processing Reconcile with bank statements daily.

6. Real-World Applications in Nepalese Hotels

In the Real World

  1. eSewa & Khalti Payments in Hotels

    • Many hotels in Nepal (e.g., Hotel Yak & Yeti) now accept eSewa and Khalti for room payments.
    • How it works: The front office records the digital payment in the guest folio and reconciles it with the eSewa/Khalti transaction log during night audit.
    • Why it matters: Ensures no cash handling errors and faster reconciliation.
  2. Pathao & Uber for Guest Transport Charges

    • Hotels like Hotel Himalaya allow guests to book Pathao/Uber rides via the hotel’s front desk.
    • How it works: The transport charge is added to the guest folio, and the hotel reconciles the Pathao/Uber payout with the folio during night audit.
    • Why it matters: Prevents discrepancies in incidental charges.
  3. Ncell & NTC Bill Reconciliation in Hotel Operations

    • Hotels receive Ncell/NTC bills for phone/internet services used by guests.
    • How it works: The front office records guest phone charges in folios, and the night auditor reconciles these with the Ncell/NTC bill to ensure no overcharging.
    • Why it matters: Avoids guest complaints and financial losses.

Worked Example: Night Audit for a Kathmandu Hotel (Hotel Everest)

Assume Hotel Everest had the following transactions on 2024-05-01:

Transaction Type Amount (NPR)
Room Revenue 300,000
Incidentals (Minibar) 25,000
Incidentals (Laundry) 15,000
Cash Received 280,000
Credit Card Payments 50,000
Bank Deposit (Pending) 30,000

Night Audit Steps:

  1. Post all transactions to folios (as shown earlier).
  2. Reconcile folios with City Ledger (Kathmandu).
  3. Verify cash count (NPR 280,000 received).
  4. Reconcile credit card transactions (NPR 50,000 processed).
  5. Prepare reports:
    • Occupancy Report: 200 rooms occupied, 75% occupancy rate.
    • Guest Account Summary: 5 guests with outstanding balances.
    • Management Report: Net revenue = NPR 340,000 (after expenses).

Final Reconciliation:

075000150000225000300000Room Revenue300000Incidentals40000Cash280000Credit Card50000Revenue in NPR (2024-05-01)
Breakdown of Hotel Everest’s front office revenue sources (NPR 340,000 total)

7. Advantages and Disadvantages of Front Office Accounting

Advantages Disadvantages
✅ Accurate financial records for guests and management. ❌ Time-consuming if manual entries are used.
✅ Prevents fraud by reconciling cash and transactions daily. ❌ Human errors can occur in posting.
✅ Helps in decision-making with occupancy and revenue reports. ❌ Requires trained staff for night audit.
✅ Ensures guest satisfaction by resolving billing issues quickly. ❌ Technical issues (e.g., POS system failures) can disrupt reconciliation.

8. Computerized Front Office Accounting (PMS Systems)

Modern hotels use Property Management Systems (PMS) like:

  • Opera PMS
  • Cloudbeds
  • HotelX
1980sManual ledgers(paper-based folios)1990sFirst DOS-basedPMS (e.g., Micros FIDE2000sCloud PMS adoption(e.g., Opera, Amadeus)2020sAI-driven revenuemanagement (dynamic pr
Evolution of front office accounting systems in Nepalese hotels

Benefits of PMS:

  • Automated folio posting (reduces errors).
  • Real-time reconciliation with bank and credit card systems.
  • Generates reports instantly (occupancy, revenue, guest history).
  • Integrates with POS and payment gateways (eSewa, Khalti, credit cards).

Example: If Hotel Himalaya uses Opera PMS, the night auditor can:

  1. Run a night audit report in seconds.
  2. Detect discrepancies (e.g., missing transactions).
  3. Generate a management dashboard showing revenue trends.

Exam Tip

  1. Understand the Night Audit Process

    • Exams often ask for step-by-step night audit procedures. Memorize the flowchart and reconciliation steps.
  2. Practice Folio Reconciliation

    • Be able to prepare a guest folio and reconcile it with the City Ledger.
    • Example: If a guest’s folio shows Dr. 50,000 and Cr. 45,000, identify the missing NPR 5,000 (likely an unposted charge).
  3. Know Key Reports

    • Occupancy Report, Guest Account Summary, and Management Report are frequently asked.
    • Calculate occupancy rate (e.g., 150 rooms occupied out of 200 = 75%).
  4. Common Exam Questions

    • "What are the steps in night audit?" → Use the flowchart.
    • "How do you reconcile a guest folio?" → Show Dr./Cr. entries.
    • "What errors can occur in front office accounting?" → List overcharging, cash discrepancies, folio errors.
  5. Real-World Scenarios

    • Expect numerical problems like:
      • "A guest’s folio shows NPR 20,000 room charge, NPR 5,000 incidentals, and NPR 15,000 advance. What is the check-out balance?"
      • Answer: NPR 10,000 (20,000 + 5,000 - 15,000).

Final Note: Front office accounting is not just about numbers—it’s about guest satisfaction, financial control, and operational efficiency. Mastering folio reconciliation, night audit, and report generation will help you excel in exams and real-world hotel operations. Practice with real scenarios (like the Hotel Everest example) to build confidence!

Based on the TU BHM syllabus for Hotel Accounting (BHM324), unit 6.

Discussion

Loading…