Hotel financial reconciliation is the process of matching financial data from multiple source systems — the PMS, payment processors, bank, payroll, and accounting platform — to confirm that all records agree. Controllers reconcile daily revenue, bank statements, credit card settlements, payroll postings, and intercompany balances. The goal is to identify and resolve discrepancies before they compound. Hotel accounting software with built-in reconciliation tools automates the matching step and surfaces exceptions for controller review.
Key Takeaways
- Hotel financial reconciliation covers five distinct areas: PMS-to-GL revenue, bank statements, credit card settlements, payroll postings, and intercompany balances.
- The foundation of fast month-end reconciliation is disciplined daily and weekly reconciliation throughout the month.
- The most common discrepancies are PMS posting errors, settlement timing gaps, and intercompany transactions recorded in one entity but not the other.
- Automated reconciliation tools match transactions across systems and surface exceptions, turning a line-by-line review into an exception-management task.
- In multi-property portfolios, intercompany reconciliation is the most complex reconciliation task and the one most likely to delay month-end close.
What Hotel Financial Reconciliation Covers
Hotel reconciliation is not a single process — it is a set of related processes that each verify a specific financial data connection. The daily income audit reconciles PMS revenue to the GL. Bookkeeping accuracy depends on this daily verification being accurate and complete. The bank reconciliation verifies that GL cash balances match bank statement activity. Credit card reconciliation confirms that payment processor settlements match the amounts received from guests. Payroll reconciliation verifies that posted labor costs match the payroll register. Intercompany reconciliation confirms that transactions between entities balance across both books.
Each of these reconciliations operates on its own cadence and involves its own set of source documents. Together, they confirm that the general ledger is an accurate reflection of the hotel’s actual financial activity — which is the prerequisite for any financial reporting that management, owners, or lenders can trust.
How Daily Revenue Reconciliation Works
Daily revenue reconciliation starts with the night audit. When the PMS closes the day, it produces a summary of revenue by department: room revenue, F&B revenue, spa, parking, and any other operating departments. It also records payment settlements by tender type: cash, credit card, direct bill, and advance deposit movements.
The accounting system should show the same numbers. If PMS room revenue for the day was $47,200, the Rooms Revenue GL account should reflect a $47,200 credit posting. If the PMS recorded $38,500 in credit card settlements, the credit card receivable account should reflect that amount.
Discrepancies at this level come from several sources: manual posting errors, voided transactions that were not reversed in both systems, timing differences in when transactions are recognized, or PMS configuration errors that cause revenue to post to the wrong department. Each discrepancy must be traced to its source and corrected.
Common Reconciliation Discrepancies in Hotel Accounting
PMS-to-GL Revenue Mismatches
The most common source of daily reconciliation discrepancies is the PMS-to-GL connection. When this connection is manual — requiring a human to export and import data — transcription errors, incomplete exports, and formatting problems create discrepancies. When the connection is automated, discrepancies typically signal a PMS configuration issue or a voided transaction that was not handled correctly.
Credit Card Settlement Timing
Credit card processors batch and settle transactions on their own schedule, which does not always align with the accounting period. A guest checkout on the last day of the month may not settle until the first business day of the next month. The controller must identify these timing differences and ensure they are accounted for correctly — either as deposits in transit or as period-end accruals.
Advance Deposit Movements
Advance deposits received for future stays must be recorded as liabilities, not revenue. When a deposit converts to earned revenue upon guest arrival, the liability account is debited and the revenue account is credited. Any error in this conversion process creates a discrepancy between the PMS deposit records and the GL liability balance.
Bank Fees and Interest
Banks charge fees and pay interest without sending invoices. These items appear on bank statements but do not automatically post to the GL. Controllers must identify them during bank reconciliation and post journal entries. Missing these items creates an ongoing reconciliation variance that compounds month after month.
Payroll Register vs. GL Variance
Payroll discrepancies occur when the department split in the payroll journal entry does not match the department split in the payroll register, or when benefits and employer taxes are not allocated to the correct departments. These variances make department-level P&L inaccurate.
Bank Reconciliation Process for Hotel Controllers
Bank reconciliation compares the hotel’s GL cash balance against the bank statement balance and identifies items that cause them to differ. The process begins with the ending bank balance and the ending GL balance. The controller adds outstanding checks (issued but not cleared) and subtracts deposits in transit (deposited but not yet on the bank statement). The adjusted bank balance should match the adjusted GL balance.
When they do not match, the controller investigates. Common causes include: entries on the bank statement not yet posted to the GL (bank fees, wire receipts, returned checks), entries in the GL not yet on the bank statement (outstanding checks issued late in the period), and outright errors in either system.
For hotel management companies, bank reconciliation runs across multiple entities. Each property has its own bank account (or multiple accounts for operating, payroll, and tax), and each must be reconciled independently. Portfolio-level cash management also requires tracking intercompany transfers that may be in transit between entities.
Intercompany Reconciliation in Multi-Property Portfolios
Intercompany reconciliation is the most complex and most time-consuming reconciliation task for hotel management companies. When the management company charges a property a management fee, that transaction appears as income in the management entity and expense in the property entity. Before consolidated financial statements can be produced, these entries must be confirmed to match and then eliminated.
Intercompany mismatches occur when one entity records the transaction and the other does not — or records it in a different period. Finding these mismatches requires comparing accounts across entities, which in non-integrated environments means working from multiple system instances simultaneously.
The intercompany reconciliation process typically runs in the final days before close. The controller prepares an intercompany matrix showing amounts owed and owing between all entities. Any line with a mismatch is investigated, corrected, and documented. Once all intercompany balances agree, the elimination entries are posted and consolidation can proceed.
Tools That Accelerate Hotel Financial Reconciliation
Automation changes hotel reconciliation from a line-by-line verification task to an exception-management task. AI-powered reconciliation tools match transactions across systems automatically — PMS entries to GL entries, bank transactions to GL cash entries, payroll register totals to journal entry amounts — and flag only the items that do not match within tolerance. The controller reviews exceptions rather than reviewing everything.
The practical impact on close time is significant. A bank reconciliation that previously took three hours of manual matching takes 30 minutes when the system does the matching and presents only the unmatched items. Multiply that across all reconciliation types and all properties in a portfolio, and the cumulative time savings are substantial.
Integration is the prerequisite for automation. Hotel accounting software that connects directly to the PMS, bank feed, payment processor, and payroll system can perform automated matching because it has access to all the source data. Software that receives data only at month-end cannot automate daily reconciliation.
How Inn-Flow Addresses This
Inn-Flow connects the data sources that hotel controllers reconcile manually. PMS integration provides daily revenue data automatically. Bank feed integration brings statement transactions into the accounting platform for automated matching. AI-powered reconciliation matches transactions across systems and surfaces exceptions, reducing the time controllers spend on line-by-line comparison. Intercompany balances are tracked across entities in real time, so the month-end intercompany reconciliation is a verification step rather than an investigation project.
Frequently Asked Questions
What does hotel financial reconciliation involve?
Hotel financial reconciliation involves matching revenue data from the PMS against the general ledger, verifying credit card settlements against payment processor reports, reconciling bank statements against GL cash accounts, confirming payroll postings against the payroll register, and resolving intercompany balances in multi-property portfolios.
How often should hotel bank reconciliation be done?
Hotel bank reconciliation should be performed at minimum weekly, with daily review of significant items. Waiting until month-end to reconcile bank accounts allows outstanding items to accumulate and makes discrepancy investigation much harder.
What are the most common hotel reconciliation discrepancies?
Common discrepancies include: PMS revenue totals not matching GL entries due to manual posting errors, credit card settlements delayed by processor timing, bank fees not posted to the GL, payroll journal entry totals differing from the payroll register, and intercompany transactions recorded in one entity but not the other.
How do hotel controllers reconcile PMS and accounting data?
Controllers compare PMS department revenue totals against the GL revenue accounts for each day. Discrepancies are traced to the source — usually a posting error, a timing difference, or a voided transaction that was not reversed in both systems. Clean daily reconciliation prevents these from accumulating.
Can AI help with hotel financial reconciliation?
Yes. AI-powered reconciliation tools automatically match transactions across systems — bank entries to GL entries, PMS settlements to payment processor batches — and surface only the exceptions that do not match. This turns a line-by-line review into an exception-management task.
