Hotel Service Charge Reconciliation — From Collections to Payroll and the General Ledger

On: November 15, 2026 |
Hotel finance and payroll staff comparing restaurant collection and payroll allocation reports

Hotel service charge reconciliation follows a charge from the guest bill to the staff allocation, payroll register and general ledger. The monthly review should explain what was collected, what was approved for distribution, what went through payroll and what remains payable. In this fictional hotel, ₹96,000 is available for allocation and ₹4,000 remains in the service charge clearing account after payroll.

1. Reconcile billings to eligible collections

Start with service charge transactions from the restaurant point of sale, banquets and the property management system. Group them by business date, outlet and transaction code. Trace reversals and refunds to the original bills. If a restaurant bill was transferred to a guest room, match the point-of-sale transaction to the folio and count the charge once. Keep the service charge component separate from other bill lines in this worksheet. Oracle’s cashier reports illustrate how transaction codes and amounts can be traced to a particular shift. Oracle Hospitality cashier reports.

For this example, the hotel has an approved process that allocates eligible amounts after collection. Restaurant and banquet bills show ₹1,05,000 in service charge for the month. Approved reversals total ₹5,000. Another ₹4,000 relates to open guest or banquet balances, leaving ₹96,000 collected and available for this run. The figures are illustrative. The applicable collection, distribution and accounting rules depend on the property, jurisdiction and approved policy.

Illustrative collections bridge
LineAmountEvidence
Service charge billed₹1,05,000Outlet and banquet transaction reports
Less approved reversals₹5,000Void and refund log
Less uncollected service charge₹4,000Open folio and receivables review
Collected and available for allocation₹96,000Matched settlement records

2. Compare the approved staff allocation with payroll

Ask the reviewer to match the allocation file to its approval and verify the payroll period, employee identifier and earnings code. The hotel service charge reconciliation should keep the approved amount and the amount accepted by payroll in separate columns. Compare those amounts after the final payroll run, since an accepted import can still be changed by a later correction or rerun.

In the example, the allocation file assigns ₹42,000 to Food and Beverage, ₹30,000 to Rooms and ₹24,000 to other eligible teams. The final register shows ₹42,000, ₹28,000 and ₹22,000 respectively. The payroll team traces the two ₹2,000 differences to held employee lines. The approval remains ₹96,000 and the register totals ₹92,000.

Hotel service charge reconciliation showing ₹96,000 approved, ₹92,000 in payroll and ₹4,000 held
The Rooms and Other teams each account for ₹2,000 held.

Before importing a corrected file, save the original import reference and confirm which entries the new file will replace. Review rejected records, count accepted rows and compare the control total against the approved allocation. Verify that the correction did not add a second earning to staff who were already processed. Keep a separate record of each held amount, its owner and the date it is due for review.

3. Match the payroll register to the Salary JV

Export the Salary JV or payroll journal for the same approved run and filter it by the service charge earning code or account mapping. Check that the gross allocation agrees to the final payroll register. A net salary bank file usually combines several earnings and deductions. Use the register to trace the service charge earning and use the broader payroll reconciliation to match total net pay to the bank. Payroll Reconciliation guide and journal examples.

In this simplified example, assume accounting already credited ₹96,000 of eligible collections to the service charge clearing account and the opening balance was zero. The service charge portion of the payroll journal debits service charge clearing ₹92,000 and credits payroll clearing ₹92,000. The normal payroll journal then allocates payroll clearing to net pay and any applicable deductions in line with the hotel’s approved account mapping. Avoid a second posting if the payroll interface has already created the transfer.

Service charge ledger showing ₹96,000 credited, ₹92,000 debited and a ₹4,000 closing credit
The ₹4,000 closing ledger balance agrees to the two held payroll lines.

4. Explain the closing balance before signing off

The ledger now shows a ₹4,000 credit balance on the service charge clearing account. It matches the held payroll lines and remains open for the next approved processing cycle. A reconciliation should include the underlying employee-level evidence in the private close file, the reason for the hold, the responsible person and the expected clearing date. Use the approved correction procedure if the held item must be cancelled or reallocated.

Two separate amounts happen to be ₹4,000 in this example. One was excluded from available collections because the guest or banquet balances were still open. The other was collected and allocated but was held out of payroll. Track each amount with its own reference to prevent double counting. Use a settlement reconciliation to follow amounts still in transit between the point of sale, payment provider and bank. Hotel Payment Settlement Reconciliation.

5. Use a hotel service charge reconciliation checklist

  • Record the property, reporting period and business-date cutoff.
  • Match outlet and banquet transactions to settlement records. Document reversals and amounts excluded from the allocation.
  • Keep the approved allocation file and check the import totals and rejected rows.
  • Match the final service charge earning total to the Salary JV and the posted general ledger.
  • Reconcile the opening balance, eligible credits, payroll debits and closing balance. Assign an owner and date to every open item.

Bring the signed hotel service charge reconciliation into the month-end close pack together with the payroll report, posted journal and open-item follow-up. If the prior-month held lines are released this month, link the new journal reference to the earlier schedule so the movement is easy to trace. Hotel Month-End Close guide.

Share

TaxNexus Editorial Team

TaxNexus Editorial Team creates educational content about Indian taxation, GST, TDS, accounting, payroll and personal finance. We use practical examples and relevant official sources, and periodically review our content for accuracy and clarity.

Leave a Comment