Hotel Night Audit Reconciliation
Hotel night audit automation that ties out revenue, taxes, payments, and statistics every operating day — replacing the overnight spreadsheet drill with a live, exception-only dashboard.
- less time on night audit
- 70%less time on night audit
- of nights tied out before sunrise
- 100%of nights tied out before sunrise
- morning fire drills for the controller
- 0morning fire drills for the controller
Automate the nightly tie-out.
Terrace ingests the night audit trial balance, revenue, tax, payment, and POS feeds, ties them together, and produces a clean audit package per property and per brand. Overnight staff stop balancing reports by hand.
- Live tie-out of trial balance, revenue, tax, payment recap
- Brand-specific night audit packages
- Portfolio rollups across every property
What is hotel night audit reconciliation?
Hotel night audit reconciliation is the nightly process that balances every revenue, tax, payment, and statistics report from the operating day so the property can close the day and roll into the next one. It is the foundation of all downstream hotel accounting — revenue reporting, GL postings, brand reports, and forecasts all flow from a clean night audit.
The challenge is that night audit happens every single night at every single property, usually staffed by one overnight clerk under time pressure. Variances must be found and resolved before the operating day rolls, or the next day's reports will be wrong. Hotel night audit automation software like Terrace AI ties out the entire audit package automatically and surfaces only the real variances for review.
- Trial balance balances
- Room revenue equals rooms × rate
- Tax recap equals rate × taxable base
- Payment recap equals folio payments
- POS feeds complete for the day
- Allowances and adjustments validated
Why hotel night audit reconciliation is painful for accounting teams
Night audit happens overnight, every night
Night audit is run on every property every operating day, often by a single overnight staffer who balances dozens of reports under time pressure.
Manual balancing across many reports
Room revenue, tax, F&B, ancillary, payments, deposits, and allowances must all tie to the trial balance, often via printed reports and Excel.
Errors block the next-day open
If the night audit doesn't balance, the next operating day can't roll, blocking front-desk operations and corrupting downstream reporting.
Variance hunts eat the auditor's shift
Finding a $4 variance can take an hour of digging through reports, leaving less time for the actual reconciliation work.
Brand requirements differ by flag
Each brand has its own night audit report set and standards, multiplying the work for management companies with multiple flags.
Multi-property rollups happen by email
Above-property accounting waits for each property's night audit package to arrive by email before consolidated reporting can run.
What data is matched in hotel night audit reconciliation?
- Revenue
- Tax
- Payments
- Balance
- Room
- Rate code
- Amount
- Outlet
- Category
- Amount
- Tender
- Folio
- Amount
- Type
- Approver
- Reason
- Rooms sold
- Rate
- Revenue
Common hotel night audit exceptions
Total credits and debits on the night audit trial balance don't equal, blocking the day from rolling.
Statistics report shows a different revenue than the sum of nightly room posts due to a missed post or rate override.
A POS outlet failed to send its revenue file, leaving the night audit short by the outlet's total.
A correction allowance was posted with an effective date in a closed period, requiring a re-open or adjustment.
Computed tax does not equal the rate times the taxable revenue base, indicating a misapplied rate or exempt line.
The tender-by-tender payment recap differs from the sum of payments posted to folios during the operating day.
How hotels manually run night audit reconciliation
- 1
Run the PMS night audit process and produce the trial balance and supporting reports.
- 2
Reconcile room revenue to the statistics report (rooms sold times rate equals revenue).
- 3
Reconcile tax recap to the rate times taxable revenue for each tax jurisdiction.
- 4
Reconcile payment recap to the sum of folio payments by tender.
- 5
Reconcile POS revenue from each outlet against the totals on the trial balance.
- 6
Investigate any variance and re-run reports if needed to resolve.
- 7
Roll the operating day and produce the night audit package for above-property review.
- 8
Email or upload the package to the controller and brand audit teams.
Automated hotel night audit reconciliation with Terrace AI
Terrace pulls every night audit report, ties them together in real time, surfaces only variances, and produces the brand-specific audit package.
Live tie-out
Live night audit tie-out
Terrace pulls trial balance, revenue, payment, and statistics reports as they generate and ties them against each other in real time.
Variance hunt
Automatic variance investigation
When a balance is off, Terrace traces the variance to the source post, surfacing the underlying record instead of leaving the auditor to dig.
POS check
POS feed verification
Every POS feed is checked for completeness before the day rolls, preventing missing revenue that would corrupt downstream reports.
Brand audit
Brand-specific audit packages
Terrace produces brand-specific night audit packages in the format each brand requires, ready to upload or share automatically.
Portfolio view
Portfolio night audit dashboard
Above-property accounting sees every property's night audit status on one dashboard instead of waiting for individual emails.
Hand-off
Clean morning handoff
Controllers and AGMs start their day with a green dashboard instead of a stack of overnight variance emails.
Put hotel revenue on autopilot
From OTA statement to GL posting — faster cash, accurate books, and less manual reconciliation.
Frequently asked questions
Hotel night audit reconciliation is the nightly process of balancing every revenue, tax, payment, and statistics report from the operating day so the property's books are closed for the day and the next operating day can roll. It is the most important reconciliation a hotel performs because everything downstream — revenue reporting, the GL, brand reporting — depends on it.
Continue exploring AR reconciliation workflows
Browse every hotel reconciliation workflow Terrace AI automates.
Verify guest folios balance per stay before checkout.
Tie PMS revenue and taxes to the general ledger each period.
Tie PMS records back to accounting, payments, and channels.