Hotel Reconciliation Reports
Start with reports your hotel already knows how to produce.
InnRecon is upload and email first. The property does not need to rename native columns or complete a major integration project before the core audit can begin.
Core report package
Different recovery areas use different source records.
The package is modular. Missing an optional crew report should not block OTA, payments or AP work that has complete inputs.
| Report | Typical cadence | Primary use |
|---|---|---|
| PMS Completed-Stay Detail | Monthly, with recent-stay overlap where available | OTA matching, commissions, travel, crew and supporting evidence |
| OTA Finance / Commission Detail | Monthly by material OTA | Commission, payout and settlement reconciliation |
| OTA Open VCC / Balance Aging | More frequent where time sensitive | Uncharged, undercharged and aging virtual-card recovery |
| Merchant Processor Statement | Monthly | Contract billing reconciliation |
| Processor Transaction / Interchange Detail | Monthly where available | Settlement matching and verified savings analysis |
| AP Payment Ledger / Check Register | Monthly with overlap | Duplicate payment and selected vendor-credit recovery |
| Travel Agent / GDS Commission | Conditional | Commission reconciliation |
| Crew / CLC Settlement | Conditional | Rate, deduction and settlement recovery |
What InnRecon does not need for the core process
- Full credit-card numbers or CVVs.
- Guest identity as the primary matching key.
- Manual column renaming before upload.
- One giant file containing multiple properties with no property identifier.
- Password-protected source files inside the automated pipeline.
When one item is missing
The intake workflow should ask for the exact missing report or field, not send the property a generalized data-quality questionnaire.
Preferred formats
CSV / XLSX
Preferred for transaction-level data.
Native searchable PDF
Accepted for stable statements and agreements.
Scanned image-only files
Not preferred for the core automated process.
Free Recovery Audit
Get My Free Recovery AuditLet us find the money your hotel is losing.
See the recovery opportunity in your own financial data before deciding whether to authorize InnRecon to pursue it.