Hotel GL Reconciliation
Automate hotel general ledger reconciliation. Terrace ties PMS revenue, taxes, and statistics to your GL each period — replacing the spreadsheet that controllers rebuild every month-end.
- less time on month-end PMS-to-GL tie
- 75%less time on month-end PMS-to-GL tie
- faster close
- 4xfaster close
- of revenue lines traced to source
- 100%of revenue lines traced to source
One platform for PMS-to-GL reconciliation.
Terrace ingests PMS and POS revenue data, applies your charge-code-to-GL mapping, and ties every revenue and tax account to the GL automatically. Controllers stop rebuilding the same spreadsheet every close.
- PMS charge code to GL mapping with brand support
- Operating day vs calendar day cutoff handled automatically
- Tax reconciliation by jurisdiction and rate
What is hotel general ledger reconciliation?
Hotel general ledger reconciliation, or hotel GL reconciliation, is the process of confirming that revenue, taxes, statistics, and balance sheet activity in the PMS and POS systems tie to the corresponding accounts on the accounting general ledger. For hotels, GL reconciliation is largely PMS-to-accounting tie-out — making sure that every charge code in Opera, Mews, or Cloudbeds maps to the right GL account in Sage Intacct, NetSuite, M3, or Inn-Flow, and that totals reconcile by period.
The complexity comes from the chart of accounts crosswalk, the difference between the PMS operating day and the calendar accounting day, brand-mandated GL structures, multi-jurisdiction taxes, and adjustments that post to different periods than the original sale. Hotel GL reconciliation software like Terrace AI automates the mapping and tie-out, leaving only true variances for the team to investigate.
- PMS revenue matches GL by department
- Charge codes mapped to correct GL accounts
- Tax accounts tie by jurisdiction
- Operating day vs calendar day reconciled
- Allowances posted to correct period
- Brand chart of accounts compliance
Why hotel GL reconciliation is painful for accounting teams
Chart of accounts differs from PMS charge codes
PMS charge codes map to many GL accounts (or vice versa), and the mapping table is rarely documented or tested as it evolves.
Brand standards add layers of mapping
Branded hotels must comply with brand-mandated chart of accounts that differ from the management company's GL, doubling the mapping work.
PMS day differs from accounting day
The PMS operating day runs from night audit to night audit, while the GL runs midnight to midnight, creating a day's worth of cutoff variance.
Adjustments post in the wrong period
Late charges, allowances, and adjustments hit the PMS on a different day than the original stay, leaving the GL out of sync.
Multiple revenue centers don't roll up
Rooms, F&B, spa, golf, and parking each report on their own cadence, and rolling them up to a single revenue figure requires manual aggregation.
Tax tracking across jurisdictions
Occupancy tax, sales tax, and tourism fees may post to different GL accounts and require per-jurisdiction reconciliation.
What data is matched in hotel GL reconciliation?
- Charge code
- Department
- Amount
- Operating day
- Item category
- Department
- Amount
- Business day
- Account
- Posting date
- Amount
- Source
- PMS code
- GL account
- Brand line
- Tax type
- Jurisdiction
- Rate
- Amount
- Type
- Reason
- Approver
- Amount
Common hotel GL reconciliation exceptions
A PMS charge code was mapped to the wrong GL account, sending revenue to an incorrect department.
A systematic mapping or cutoff issue creates a recurring daily variance between PMS revenue and the GL.
Occupancy or sales tax posted in the PMS does not match the tax liability accounts in the GL.
An allowance or rebate processed today reverses revenue recognized in a prior closed period.
A POS revenue center failed to post one day's revenue, leaving a missing source line on the GL.
The total ties at the department level but individual charge codes within the department do not match.
How hotels manually reconcile PMS to GL
- 1
Export the PMS daily trial balance and revenue summary for the period being reconciled.
- 2
Pull POS revenue reports from each outlet (restaurant, spa, golf, parking, etc.).
- 3
Pull GL transaction detail for every revenue and tax account in the chart of accounts.
- 4
Map PMS charge codes to GL accounts using the property's mapping table.
- 5
Tie out revenue by department and confirm totals at the trial balance level.
- 6
Investigate any account where the PMS source and GL do not match.
- 7
Post journal entries to correct mapping errors, cutoff differences, or omissions.
- 8
Sign off on the PMS-to-GL reconciliation for the period and store the audit trail.
Automated hotel GL reconciliation with Terrace AI
Terrace AI maintains your PMS charge code to GL mapping, ingests revenue and tax data from every source, and ties out the GL each period automatically.
Mapping engine
PMS charge code to GL mapping
Terrace maintains the crosswalk between PMS charge codes and GL accounts, including brand-specific mappings, and applies it automatically every period.
Tie-out
Automated PMS-to-GL tie-out
Each revenue and tax account is tied out by period, with a single view of any variance and the underlying PMS or POS records that caused it.
Cutoff
Operating day vs calendar day cutoff
Terrace handles the difference between the PMS operating day and the calendar accounting day, eliminating the recurring daily cutoff variance.
Multi-source
Multi-source revenue aggregation
Rooms, F&B, spa, golf, and parking are aggregated into one revenue view that ties to the GL, no manual roll-up required.
Tax detail
Tax reconciliation by jurisdiction
Occupancy, sales, and tourism taxes are reconciled by jurisdiction and rate, with variance surfaced per line.
Period close
Period close workflow
Each account flips green when reconciled, giving controllers a one-glance view of where the close stands across every property.
Put hotel revenue on autopilot
From OTA statement to GL posting — faster cash, accurate books, and less manual reconciliation.
Frequently asked questions
Hotel GL reconciliation (general ledger reconciliation) is the process of confirming that revenue, tax, and balance sheet activity in the property management system, point of sale, and source ledgers ties to the general ledger of the accounting system. For hotels, GL reconciliation is largely about PMS-to-accounting tie-out.
Continue exploring AR reconciliation workflows
Browse every hotel reconciliation workflow Terrace AI automates.
Tie PMS records back to accounting, payments, and channel data.
Reconcile cash, AR, advance deposits, and accrual accounts each month.
Automate the nightly close before the operating day rolls.