Skip to main content

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

Start Live Demo

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.

PriorityFindingWhat triggers itCounted as
HighChecked out with balance dueGuest checked out and the folio still shows money owed.Owed to the hotel
HighCancelled / no-show holding paymentA cancelled or no-show booking holds more money than was charged.Held above what was billed
MediumStay ended, booking still open and unpaidThe departure date has passed, the booking was never closed, and a balance is owed.Owed to the hotel
MediumOverpaid (credit balance)A live booking has been paid more than it was charged.Held above what was billed
MediumCancelled / no-show with unpaid chargesA cancelled or no-show booking carries charges nobody paid.Owed to the hotel
MediumOTA amount differs from folioThe amount the channel sold, or the OTA-collected payment, does not match the folio.Flagged for review
MediumPossible duplicate paymentSame folio, same method, same amount, same day, entered more than once.Flagged for review
LowPayment status label is wrongThe Paid, Partially paid or Not paid label disagrees with the folio.Flagged for review

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?

  1. Open Reports, choose Finance, then Payment Discrepancies, and set the date range. The report filters on check-out date.
  2. Read the summary cards. If everything reconciles, the report says so and shows how many departures it scanned.
  3. Click an issue card, or use the filter, to work one type at a time. You can also search by reservation, guest or room.
  4. 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.
  5. 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.

WhereWhat you seeWhat it means
Reports → Finance → Payment DiscrepanciesPick last month. A card says 5 findings across 4 reservations.Four departures this month do not reconcile. Click a card to filter the table to one issue type.
Row: Checked out with balance dueCharges 180.00, Paid 120.00, Difference 60.00.The guest left owing 60.00. Open the reservation, collect it or correct the charge.
Row: Possible duplicate payment2 × 50.00 Cash on the same day, with the times listed.Check the cashier did not key the same payment twice. It is a prompt, not an error.
Row: Payment status label is wrongMarked Not paid, but the folio says Paid.Fix the label so the tape chart and reports agree.

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.

GroupRows inside itColumns
Direct (PMS) bookingsOne row per payment method, highest net firstPayment Type, Count, Received, Refunded, Net
OTA bookingsOne row per payment method, highest net firstPayment Type, Count, Received, Refunded, Net
TotalWhole periodCount, Received, Refunded, Net
  • 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?

ReportQuestion it answersDated by
Payment reportWhat payments were taken, and how?Payment date
Hotel Sales: Payments by MethodHow were this period's bookings paid for, split Direct (PMS) vs OTA?The stay, not the payment date
Payment Discrepancy ReportWhich departures do not add up?Check-out date

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 Demo

See hotel reporting

Related guides

More on reports and money