Hotel Guest Ledger Reconciliation
Hotel guest ledger reconciliation software that ties in-house guest balances, advance deposits, and routed charges between PMS reports and the GL — every operating day.
- less time on guest ledger tie-out
- 75%less time on guest ledger tie-out
- of in-house balances tied daily
- 100%of in-house balances tied daily
- month-end surprises on guest ledger
- 0month-end surprises on guest ledger
Daily guest ledger tie-out, automatically.
Terrace ingests in-house folios, advance deposits, and routing data, then ties the guest ledger to the GL every operating day. Front office accounting stops waiting for month-end to find variances.
- Daily in-house folio total tied to GL
- Routed charge verification across folios
- Advance deposit reconciliation
What is hotel guest ledger reconciliation?
Hotel guest ledger reconciliation is the daily verification that the sum of in-house guest folio balances — plus any advance deposits sitting on the guest ledger — equals the guest ledger account balance on the GL. It confirms that what guests currently in-house owe the property is accurately reflected on the books, before they check out and the balance moves elsewhere.
The challenge is that the guest ledger changes continuously with every check-in, checkout, POS post, and deposit. Reconciling only at month-end means errors compound across weeks of activity. Hotel guest ledger reconciliation software like Terrace AI runs the tie-out every operating day, validates routing rules, handles late check-outs across the cutoff, and treats house-use rooms separately.
- In-house folios sum to GL guest ledger
- Advance deposits reconciled
- Routed charges not double-counted
- House-use rooms flagged separately
- Late check-out cutoff handled
- Daily not monthly tie-out
Why hotel guest ledger reconciliation is painful for accounting teams
Guest ledger changes minute by minute
In-house balances move with every check-in, checkout, and POS post. A snapshot from earlier in the day is stale within hours.
Advance deposits sit on guest ledger until checkout
Deposits collected before arrival increase the guest ledger balance and must be applied to the correct folio at checkout.
Routed charges hide on master folios
Charges routed from guest folios to group masters or AR accounts reduce the in-house guest balance and must reconcile precisely.
House-use rooms don't always reconcile cleanly
Out-of-order rooms used for staff or comp purposes still appear on the guest ledger and complicate the daily tie-out.
Late check-outs cross operating days
Guests who check out after night audit appear on both today's and yesterday's guest ledger, requiring careful cutoff handling.
GL ties only happen at month-end
Most properties only formally tie the guest ledger to the GL at month-end, by which point any error has weeks of activity layered on top.
What data is matched in hotel guest ledger reconciliation?
- Folio
- Room
- Balance
- Arrival
- Folio
- Amount
- Collected date
- Source
- Destination
- Categories
- Master folio
- Routed charges
- Account
- Balance
- Postings
- Folio
- Charge code
- Amount
Common hotel guest ledger reconciliation exceptions
The aggregate guest ledger balance does not equal the sum of in-house folio balances for the same operating day.
A charge routed to a group master also appears on the guest folio, inflating the in-house balance.
A deposit collected for an in-house guest is not reflected in the guest ledger balance.
The guest ledger account on the GL has a balance different from the PMS in-house report for the same period.
A house-use or out-of-order room appears on the standard in-house list without being flagged for separate treatment.
A guest who checked out after night audit appears on both operating days' in-house lists.
How hotels manually reconcile the guest ledger
- 1
Pull the PMS in-house folio report at the operating day cutoff.
- 2
Pull the advance deposit sub-ledger for the same period.
- 3
Sum the in-house balances plus deposits to compute the expected guest ledger total.
- 4
Pull the guest ledger account balance from the GL.
- 5
Tie the two totals and investigate any variance.
- 6
Verify routing rules on each in-house folio with routed charges.
- 7
Document house-use and late check-out treatment.
- 8
Sign off on guest ledger reconciliation for the day and store the audit trail.
Automated hotel guest ledger reconciliation with Terrace AI
Terrace ties the guest ledger to the GL every operating day, validates routing, reconciles advance deposits, and surfaces only the variances that need attention.
Daily tie
Daily guest ledger tie-out
Terrace ties the in-house folio total to the guest ledger account on the GL every operating day, not just at month-end.
Routing check
Routed charge verification
Charges routed from guest folios to group masters are traced from origin to destination so they don't appear in two places.
Deposits
Advance deposit reconciliation
Deposits collected for in-house guests are reconciled into the guest ledger total and surfaced when missing.
House-use
House-use and OOO handling
Out-of-order rooms and house-use folios are flagged automatically so they're reconciled separately from revenue-generating rooms.
Cutoff
Late check-out cutoff
Guests whose check-out crosses the operating day cutoff are handled correctly so balances don't double-count.
Trend
Guest ledger trending
Daily guest ledger balances are tracked over time so anomalies surface before they become month-end variances.
Put hotel revenue on autopilot
From OTA statement to GL posting — faster cash, accurate books, and less manual reconciliation.
Frequently asked questions
Hotel guest ledger reconciliation is the daily verification that the sum of all in-house guest folio balances (plus advance deposits) equals the guest ledger account on the GL. It confirms that the balance owed by guests currently staying at the property is accurately reflected on the books.
Continue exploring AR reconciliation workflows
Browse every hotel reconciliation workflow Terrace AI automates.
Verify guest folios balance per stay before checkout.
Reconcile group masters and direct bill accounts in AR.
Track advance deposits from collection through application.