Credit card reconciliation in a hotel is the process of proving that every card payment recorded in your property management system actually settled, for the right amount, into your bank account — after processors take their fees, chargebacks claw back revenue, and OTA virtual cards behave nothing like regular cards. In most industries this is a simple match. In hotels, it is one of the hardest reconciliations in accounting, and it is where revenue quietly leaks.
This guide walks through the full workflow we use to reconcile hotel card payments daily — the three-way match, the netting problem, the discrepancies to hunt for, and where automation genuinely helps. It pairs with our guides on the night audit (where reconciliation starts) and OTA reconciliation (its most painful special case).
What is credit card reconciliation?
It is the control that connects three records that should agree but rarely do on their own: the PMS (what you believe guests paid by card), the processor (what was authorized, captured, and settled), and the bank (what money actually arrived). Reconciliation means matching these at the transaction level, explaining every difference — fees, chargebacks, holds, timing — and fixing what doesn't belong.
Done daily, it takes minutes per property and catches problems while they are correctable. Done monthly, it becomes archaeology: thousands of transactions, netted deposits, and a statute of limitations quietly expiring on your ability to dispute processor errors.
Why hotels are uniquely difficult
- Deposits never match revenue. Processors deposit net: gross card sales minus interchange and fees, minus chargebacks, sometimes minus reserves. A day's $18,000 in card revenue might arrive as $17,540 across three deposits two days later.
- Multiple revenue centers. Front desk, restaurant, bar, spa, and parking may settle through different merchant accounts or terminals, each with its own batch.
- Card-present and card-not-present mix. Online bookings, phone reservations, and front-desk swipes carry different fees and different chargeback risk.
- OTA virtual cards. Booking.com and Expedia pay with single-use virtual cards that are easy to charge for the wrong amount, at the wrong time, or never — the subject of our dedicated OTA reconciliation guide.
- Timing. Authorization at check-in, incremental holds during the stay, capture at checkout, settlement a day later, funding a day after that. Every lag is a place where amounts drift.
The three-way match
| Match | Question it answers | Catches |
|---|---|---|
| PMS ↔ Processor batch | Did everything we posted get captured — once, and for the right amount? | Duplicate settlements, missed captures, amount mismatches, payments on the wrong folio |
| Processor ↔ Bank deposit | Did settled funds actually arrive, net of explained fees? | Missing deposits, fee errors, unexplained holds and reserves, chargeback debits |
| Bank ↔ General ledger | Do the books reflect reality? | Posting errors, unrecorded fees, revenue recognized but never collected |
Most hotels do only the first match, at night audit, and assume the rest "works out." The leakage lives in the second match — fees that creep, chargebacks that were never contested, deposits that simply didn't arrive.
The daily workflow, step by step
- Pull yesterday's PMS payment journal by card type (Visa, Mastercard, Amex, Discover) and by revenue center.
- Pull the processor batch report(s) for the same business date — every terminal, every merchant ID.
- Match batch totals to PMS totals by card type. Differences get traced to the transaction the same day: a forced authorization, a tip adjustment, a refund posted but not transmitted.
- Verify the settlement file transmitted. A batch that balanced but never settled is a week of missing cash flow.
- Two days later, match funding. Tie each deposit on the bank statement back to its batch; explain every cent of difference as a documented fee, reserve, or chargeback.
- Log chargebacks the day they debit. Deadlines to respond are short; the evidence that wins disputes goes stale fast.
- Record fees to the GL monthly, reconciled against the processor statement — and benchmark the effective rate. Fee creep is real, negotiable, and almost never flagged by anyone but you.
Weekly and monthly layers
Weekly: review unmatched items older than three days, chargeback status, and refund activity by agent (refund abuse is a classic internal leak). Monthly: reconcile the processor statement in full — effective rate check, fee schedule changes, reserve movements — and close the loop to the general ledger so the books carry audited, not assumed, card revenue. This cadence is exactly how our reconciliation service runs it for client hotels, layered on top of the nightly work described in our night audit guide.
Discrepancies to hunt for
| Discrepancy | What it looks like | Why it matters |
|---|---|---|
| Duplicate settlement | Same card, same amount, same day, two batches | Guaranteed future chargeback with fee — refund proactively instead |
| Missed capture | PMS shows payment; batch doesn't | Revenue recognized, cash never collected |
| Amount drift | Capture ≠ authorization (tips, incidentals, rate changes) | Small per event; large in aggregate; dispute trigger |
| Unexplained processor fee | Deposit short with no matching fee line | Fee creep compounds monthly until challenged |
| Uncharged virtual card | OTA booking checked out; VCC never charged | Pure revenue loss — the OTA will not call to remind you |
| Orphan refund | Refund in processor, no folio adjustment | Classic fraud pattern; audit immediately |
Automation, AI, and judgment
Transaction matching is exactly the kind of repetitive, rule-bound work that software should do. Our teams use automation and AI to do the heavy matching, flag exceptions, and summarize the noise — but every exception is reviewed and resolved by a trained accountant, because the judgment calls (fight or refund, fee error or new schedule, agent mistake or agent pattern) are human decisions. AI helps our people see everything; it does not decide for them. That operating philosophy runs through our whole Operations Suite.
Never wonder if your card revenue actually arrived. Our reconciliation teams match PMS, processor, and bank daily — and chase every cent that goes missing.
Explore Reconciliation ServicesDaily reconciliation checklist
- PMS payment journal pulled by card type and revenue center
- Processor batches matched to PMS by card type — differences traced same day
- Settlement transmission confirmed for every batch
- Bank deposits tied to batches; fees, reserves, chargebacks explained line by line
- New chargebacks logged with response deadline
- Virtual cards for departed OTA guests confirmed charged
- Refunds reviewed against folio adjustments
- Unmatched items escalated after 72 hours
Frequently asked questions
How often should a hotel reconcile credit cards?
Batch-to-PMS daily at night audit, deposit-to-bank within two business days of funding, and processor statement in full monthly. Daily matching turns most problems into same-day fixes.
Why don't my bank deposits match my card revenue?
Processors deposit net of interchange and fees, batch multiple days together or split days apart, and debit chargebacks and reserves from deposits. Reconciliation means explaining every one of those differences, not accepting them.
Who should do the reconciliation — front desk, accounting, or a third party?
Not the person who posts the payments; separation of duties is the point. Hotels without a dedicated accounting function typically outsource it, which also adds consistency across staff turnover.
What is an effective rate and why check it?
Total card fees divided by total card volume for the month. It is the one number that exposes fee creep, downgrades, and surcharges hiding across hundreds of statement lines. Track it monthly and question every increase.
What software do I need?
You can reconcile with PMS reports, processor portals, and a disciplined spreadsheet — the method matters more than the tool. Automation earns its keep at scale or across portfolios, provided exceptions still get human review.
Related guides
- Hotel Night Audit: The Complete Operator's Guide
- OTA Reconciliation: Getting Every Dollar from Booking.com & Expedia
- Hotel Chargebacks: Prevention Playbook & Dispute Guide
Hands On Hotels is a hotel back-office operations company. Our teams run the night audit, books, reconciliations, and sales desks for hotels every single night — and we build the Hands On Operations Suite, software born from that work. This guide is written and reviewed by the operators who do this for a living.