Hotel Folio Reconciliation
Automate hotel folio reconciliation across every checkout. Terrace audits every guest folio for routing, tax, deposit application, and payment posting — surfacing only the folios that need review.
- less time reviewing folios
- 80%less time reviewing folios
- faster end-of-day audit
- 5xfaster end-of-day audit
- of folios balanced before checkout
- 100%of folios balanced before checkout
Audit every guest folio without a spreadsheet.
Terrace ingests folios, routing rules, payments, and revenue posts, then audits each folio against the math that should balance it. Front office accounting only sees folios with real problems.
- Per-folio balance audit at checkout
- Routed charge verification across folios
- Line-level tax and deposit application checks
What is hotel folio reconciliation?
Hotel folio reconciliation is the per-stay verification that every guest folio balances internally — that posted room revenue, taxes, ancillary charges, routed charges, advance deposits, and payments sum correctly so the folio closes at zero. It also confirms that each folio's contributions to the revenue and tax accounts on the GL match the totals reported by the night audit.
Folio reconciliation is one of the most operationally important reconciliations a hotel runs because a folio with bad math at checkout means the guest may have been overcharged, undercharged, or charged the wrong tax — and the property's revenue reporting downstream will be wrong. Hospitality folio reconciliation software like Terrace AI runs this audit automatically every night.
- Charges minus payments equal zero
- Routed charges on the right folio
- Tax applied at correct line rate
- Advance deposits applied correctly
- Comp and house-use posted correctly
- Late posts handled to right folio
Why hotel folio reconciliation is painful for accounting teams
Charges arrive after the folio closes
Mini-bar, parking, and POS charges posted after checkout reopen folios and force the audit team to re-run the math.
Routing splits charges across folios
Group block charges routed to a master folio, or incidentals routed to a company AR account, complicate the per-stay reconciliation.
Tax must reconcile per line
Different charge categories carry different tax treatment, and tax must reconcile at the line level not just the folio total.
Allowances and rebates change posted totals
An allowance after checkout reduces the folio total and creates an after-the-fact discrepancy with payment and revenue records.
Advance deposits applied at checkout
Deposits collected weeks before arrival must be applied to the right folio at checkout. Misapplied deposits create folio variance.
Comp and house-use rooms still post taxes
Even when a room is comped, certain taxes and fees may still apply, and the audit must confirm the right treatment.
What data is matched in hotel folio reconciliation?
- Folio ID
- Charges
- Payments
- Balance
- Stay date
- Rate code
- Amount
- Item
- Outlet
- Tax
- Amount
- From folio
- To folio
- Categories
- Amount
- Tender
- Auth code
- Reason
- Approver
- Amount
Common hotel folio reconciliation exceptions
A folio balance is non-zero at checkout because charges, payments, or adjustments do not sum correctly.
A charge intended for the group master folio also appears on the guest folio, double-counting the amount.
Calculated tax on a folio line does not equal the rate times the taxable amount.
An advance deposit was applied to a different folio than the one it was collected for.
A comped room shows revenue posted instead of being offset by a house-use or comp posting.
A mini-bar or POS charge arrived after checkout, creating a non-zero balance on a folio that should be closed.
How hotels manually reconcile folios
- 1
Pull the in-house and checked-out folio reports from the PMS for the operating day.
- 2
Pull room revenue, POS revenue, and tax posting reports for the same day.
- 3
For each folio, verify that charges minus payments equal the closing balance.
- 4
Confirm routed charges appear on the correct folio and not on the original guest folio.
- 5
Reconcile tax on each line against the rate that should apply to that category.
- 6
Confirm advance deposits were applied to the correct folio at checkout.
- 7
Investigate any folio with a non-zero balance after checkout or a tax variance.
- 8
Post corrections and close the folio audit for the operating day.
Automated hotel folio reconciliation with Terrace AI
Terrace audits every folio at checkout, validates routing, tax, and deposit application, and surfaces only the folios that need review.
Folio audit
Per-folio balance audit
Terrace audits every folio at checkout to confirm charges minus payments equal zero, surfacing any folio that didn't close cleanly.
Routing check
Routed charge verification
Charges routed to group, AR, or other folios are traced from origin to destination and flagged if they appear in two places.
Tax check
Line-level tax reconciliation
Each folio line is checked against the tax rate that should apply, surfacing rate or category errors before they hit the GL.
Deposits
Advance deposit application check
Deposits are matched to the folio they were collected for, surfacing deposits applied to the wrong folio or never applied.
Comp handling
Comp and house-use validation
Comp, house-use, and complimentary postings are validated against PMS rules so revenue isn't recognized incorrectly on comped rooms.
Late posts
Late post detection
Charges posted after checkout are detected and routed to the right folio or AR account so closed folios stay closed.
Put hotel revenue on autopilot
From OTA statement to GL posting — faster cash, accurate books, and less manual reconciliation.
Frequently asked questions
Hotel folio reconciliation is the process of verifying that every guest folio balances — that posted room revenue, taxes, ancillary charges, routed charges, deposits, and payments sum correctly per stay — and that the folio detail ties to the revenue and tax accounts on the GL.
Continue exploring AR reconciliation workflows
Browse every hotel reconciliation workflow Terrace AI automates.
Automate the nightly close before the operating day rolls.
Match in-house balances and routed charges to the GL.
Reconcile group masters and direct bill accounts in AR.