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:
| 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
Posting Transactions
- All guest transactions (check-ins, check-outs, incidentals) are recorded in folios.
- Folio reconciliation ensures no transactions are missed.
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.
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.
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
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.
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.
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:
- Post all transactions to folios (as shown earlier).
- Reconcile folios with City Ledger (Kathmandu).
- Verify cash count (NPR 280,000 received).
- Reconcile credit card transactions (NPR 50,000 processed).
- 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:
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
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:
- Run a night audit report in seconds.
- Detect discrepancies (e.g., missing transactions).
- Generate a management dashboard showing revenue trends.
Exam Tip
Understand the Night Audit Process
- Exams often ask for step-by-step night audit procedures. Memorize the flowchart and reconciliation steps.
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).
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%).
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.
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).
- Expect numerical problems like:
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…