Hotel Payment Reconciliation: Find What Does Not Add Up
Frontdesko's Payment Discrepancy Report (Reports, Finance) lists every reservation checking out in your chosen dates whose money does not add up, such as unpaid check-outs, overpayments and duplicate entries. The Hotel Sales report also shows payments by method, split Direct (PMS) and OTA bookings.
By the Frontdesko team · Last updated: November 18, 2026
What does the Payment Discrepancy Report check?
It looks at every reservation that checks out inside the dates you pick and asks one question about each: does the money add up? Amounts are read from the folio, so a row always matches the Billing section of that reservation. Each problem is one row, grouped by type with the most serious first.
Three summary cards sit above the table: Findings (with how many reservations are affected out of those scanned), Owed to the hotel and Held above what was billed. Each reservation is counted once per direction, so a booking that is both checked out unpaid and marked paid is not added up twice. Duplicate payments are flagged for review and are not added to the money totals.
How do you use it at month end?
- Open Reports, choose Finance, then Payment Discrepancies, and set the date range. The report filters on check-out date.
- Read the summary cards. If everything reconciles, the report says so and shows how many departures it scanned.
- Click an issue card, or use the filter, to work one type at a time. You can also search by reservation, guest or room.
- Click a row to open the reservation in the detail modal and fix it there: collect, refund, post a missing charge or correct the label.
- Use Ignore differences up to to hide rounding noise. The default is 0.05. Show or hide columns with the column picker, and export to CSV, Excel or PDF for your accountant.
Because it is hotel-wide money, it is only shown to staff whose access includes financial reports. The report loads only while it is on screen.
What does a finding look like? An illustrative example
Illustrative scenario. The figures below are made up to show the screens. They are not a customer story and not real results.
How does it treat OTA bookings and duplicate payments?
These two rules are cautious on purpose, so the list stays worth reading.
- OTA amount differs from folio. Compares what the channel sold with the OTA-collected payment on the folio, or with the folio total when nothing was collected. It skips bookings the channel quoted in another currency and bookings with a recorded channel discount. OTA differences under one currency unit are ignored.
- Possible duplicate payment. Needs the same folio, method, amount and local day. OTA-collected and city ledger entries are skipped, because a second identical row there is usually a re-sync. Fully refunded payments are skipped too, since the correction already happened.
What does Hotel Sales show for payments by method?
The Hotel Sales report has a Payments by Method table with cash, bank transfer, card and every other payment type, with count, received, refunded and net for each. Since 11 November it is split into two groups, so your own desk takings read apart from channel-collected money.
- Dated by the stay. The table counts the payments of the same bookings whose nights make up the sales figures, whatever day the money moved. A guest who prepaid through an OTA months ahead is counted in the stay month, not the booking month.
- Cash total as a footnote. The footnote gives the plain total received in the period for any stay, with the number of payments, for desks that reconcile against the bank.
- Refunds subtract. Voided, declined and authorised-only payments are not counted. Cancelled and no-show bookings are left out, as their revenue is.
- Empty period. The table says No payments in this period.
Which payment report answers which question?
Use the Payment report for the cashier's day, Hotel Sales for how a month was paid for, and the discrepancy report for what to chase. The night audit still closes each business day; see hotel night audit. Virtual card payments get their own line in these reports, covered in OTA virtual credit card payments.
What does it cost?
The PMS, including these reports, the booking engine, the guest app and the POS are free forever with no room limit. The channel manager and AI assistant are the paid add-ons, at $35 a month for 0-10 rooms, $42 for 11-30 rooms or $54 for 31-50 rooms. See pricing.
Frequently Asked Questions
What is hotel payment reconciliation?
It is checking that the money on each guest's folio matches what was charged, what was paid and what the booking channel sold. Frontdesko's Payment Discrepancy Report does this for every reservation checking out in the dates you choose and lists the ones that do not add up.
Where is the Payment Discrepancy Report?
Open Reports, choose Finance, then Payment Discrepancies. It lists reservations that check out in the selected period, and each row opens the reservation so you can fix it.
What kinds of payment discrepancies does it find?
Eight types. Checked out with balance due, cancelled or no-show holding payment, stay ended with the booking still open and unpaid, overpaid, cancelled or no-show with unpaid charges, OTA amount differing from the folio, possible duplicate payment, and a wrong Paid or Not paid label.
Can I ignore tiny differences?
Yes. The Ignore differences up to field hides amounts at or below the number you enter. The default is 0.05, and OTA amount differences under one currency unit are always ignored.
Who can see the report?
Staff whose access includes financial reports. The same permission applies to the report and to the data behind it, so other staff do not see hotel-wide money.
What does the Payments by Method table on Hotel Sales show?
For the chosen period it shows each payment type with count, received, refunded and net, grouped under Direct (PMS) bookings and OTA bookings. It follows the stay dates, with a footnote giving the cash received in the period.
Why can Hotel Sales payments differ from my bank deposits?
Hotel Sales dates payments by the stay, so an OTA prepayment taken months earlier counts in the stay month. The footnote shows the cash actually received in the period, which is the number to compare with the bank.
Does this cost extra?
No. The PMS and its reports are free forever with unlimited rooms. Only the channel manager and AI assistant are paid, at $35, $42 or $54 a month by room band.
Reconcile payments before month end, not after
Free PMS, guest app and booking engine with unlimited rooms. Start with a live demo.
Start Live DemoRelated guides
More on reports and money
Hotel Reporting and Analytics
The reports Frontdesko includes.
Hotel Night Audit
Closing the business day.
What Is a Guest Folio
Where the money on each booking lives.
OTA Connections
How OTA bookings reach the PMS.
OTA Virtual Credit Card Payments
Recording VCC payments.
Pricing
What is free and what is paid.