Card reconciliation at night audit: matching terminal totals to the hotel system
This guide explains how to perform a three-way match between terminal reports, hotel system payments, and bank settlements. Learn to close differences quickly and log them properly.
Contents
Key takeaways
- Reconciliation is a match of three records, not proof that money arrived: the terminal report, the hotel system's payment report and the bank settlement each answer a different question.
- The bank credits a net figure, so commission must be booked as a cost of accepting the card; matching net to gross creates a permanent, growing difference.
- The most expensive difference is a void or refund recorded on one side only, because the guest is charged while the hotel's books say otherwise.
- A virtual POS or a payment link has no paper roll, so the provider's transaction list is the terminal side and must be matched on a reference the hotel controls, not on the amount alone.
- A difference is closed when a named person writes down the cause and the fix in a log, not when the shift ends.
Credit card reconciliation at night audit is the daily match of three totals: the card terminal's end-of-day report, the hotel system's payment report for the same business date, and the amount the bank later settles. Cash is counted at the desk; cards are usually only checked when the bank statement arrives, which is why differences surface weeks late.
The cash drawer is counted twice a day and every lira is accounted for. The card terminal, which usually carries far more money, is closed with a button press and the printout goes into a drawer. The gap between those two habits appears weeks later, on a bank statement nobody at the desk ever sees. After reading this, you will be able to run a three-way match every business date, close the terminal at a fixed point, name the usual causes of a difference, and log who closes each one.
What is credit card reconciliation at night audit?
It is the check that every card charge in the hotel system has a matching record at the terminal, and every terminal record has a matching charge in the system, for one business date. It is a match of records, not a confirmation that money has arrived.
The business date is the hotel's own accounting day, which the night audit closes. It is not the calendar date and not the terminal's own day. Everything in the match hangs on this one definition, so it is worth writing down in your procedure.
Cash gets counted because it is physical: a shortage is visible at shift handover and belongs to somebody. A card charge leaves no physical trace at the desk, so it is trusted by default. The first independent record most hotels see is the bank statement, and by then the guest has left, the shift has changed and sometimes the month has closed. This is the structural reason card differences surface late, and the routine below exists to remove it.
Two roles work at two moments. The night auditor closes the terminal and records its totals; the income auditor or accounting re-performs the match the next morning. Titles and splits vary by hotel, so write down who does which in your own procedure. Good practice is narrow and cheap: the difference is found the same night, written down with the folio or reservation reference, and closed by a named person.
This article covers the bank's card terminal, the POS. Fiscal receipt devices such as yazar kasa are a separate subject with their own rules and their own reconciliation. For the cash side of the desk, see front desk cash handling: float, drops and shortages.
Which three totals have to agree?
The terminal's end-of-day report, the hotel system's payment report for the same business date, and the bank's settlement. The first two must agree exactly; the third must agree after commission and anything still in transit are taken out.
| Total | Where it comes from | What it should cover | Common reason it differs |
|---|---|---|---|
| Terminal end-of-day | The terminal's own batch-close report | Every card charge and refund since the last close | A charge keyed after the close, or the terminal closed early |
| Hotel system payment report | The PMS payments-by-method report for the business date | Payments posted to guest bills and city ledger | Wrong payment method, wrong business date, a payment posted but never taken |
| Bank settlement | The bank account credit | The same charges, later and net of fees | Timing, commission, refunds and chargebacks |
The third total is not supposed to equal the first. It is supposed to equal the first, minus commission, minus refunds and chargebacks, minus whatever has not settled yet. Treating the bank credit as the thing to match against the terminal total is the single most common way hotels build a difference into their own routine.
Write all three on one sheet with the business date at the top. A difference you can see on one page is a difference somebody will chase. Keep the terminal report with the night audit pack rather than in a drawer, so the morning check has something to check against.
How do you close the card terminal at end of day?
Close it once, at a fixed point that falls after the last charge belonging to the business date and before the night audit is finalized, and have one named person sign the report.
Fix the point in the procedure, not in someone's memory: a stated time, or the moment the last expected check-out has paid, whichever your operation can defend. Record on the printout itself: business date, batch or sequence number, gross total, refunds shown separately, and the number of transactions.
If the terminal is shared between the front desk, the restaurant and the spa, either close per outlet or write on the report which outlets' charges are included. Any charge taken after the close belongs to the next business date. Write it on the next day's pack and flag it, so the morning check does not treat it as a missing item.
If the terminal cannot close, because of the network, paper or a fault, write down the reason and the time and tell the person doing the morning check before they start. Sign and date the report. An unsigned terminal report is a printout, not a record.
ChecklistEnd-of-day terminal close
- Close at the fixed point in the procedure
- One named person performs the close
- Write the business date on the report
- Record the batch or sequence number
- Record the gross total and refunds separately
- Record the transaction count
- Note which outlets are included if the terminal is shared
- Flag any charge taken after the close
- Note any failed close with reason and time
- Sign and file with the night audit pack
Why do the terminal and the hotel system disagree?
Almost always because one side recorded something the other did not, or recorded it differently: a different amount, a different method, a different date, or a void that exists on one side only.
A wrong amount is, for example, a charge keyed as 1,450 when the bill says 1,540. The guest bill and the slip disagree and both look internally consistent, so nothing flags it at the desk. A wrong method is a card payment posted as cash, or a bill moved to a city ledger account while the card charge stands at the terminal.
A wrong date appears when a charge taken just after midnight belongs to the next business date, and the terminal and the system may not agree on which date that is. A pre-authorization treated as a payment is a related trap: a hold is not money. It appears at the terminal and must never be posted as a settled payment.
Split payments and tips cause their own differences: a tip added to the slip after the bill was closed, or one bill paid with two cards and posted as one line. A duplicate swipe charges the guest twice while only one charge reaches the system, and the guest usually discovers it before the hotel does.
Watch outOne-sided void
If a payment is voided in the hotel system but not at the terminal, or refunded at the terminal but not in the system, the guest's card and the hotel's books disagree. Treat any one-sided void as a same-night item: identify the folio, check the terminal, correct the side that is wrong, and write the correction in the discrepancy log with the name of the person who made it.
What changes with virtual POS and payment links?
There is no paper roll and often no shared cut-off, so the provider's transaction list becomes the terminal side and the hotel has to match on a reference it controls.
The merchant panel or back office replaces the printed report. Export the transaction list for the business date rather than reading a total off the dashboard. The provider's day and the hotel's business date can differ, especially around midnight and across time zones, so match on transaction timestamps and then decide which business date each one belongs to.
A 3D Secure failure or an abandoned payment page is an attempt, not a payment. The hotel system should only ever hold completed payments, and the panel will show the failures alongside them. A payment link sent before arrival can be paid days or weeks before the stay, so the payment date and the stay date are different facts and the match needs the reservation number, not the date.
Refunds through the panel may not follow the same path or timing as the original charge, so they appear as their own line and must be matched as their own item. Match on a reference you generate, such as the reservation number or a unique order reference, never on the amount alone: two guests paying the same amount on the same night is normal. For the underlying terms, see virtual POS, 3D Secure, tokens and chargebacks explained.
How do settlement and commission appear in the bank statement?
The bank credits a net figure, later than the stay and usually in more than one line. Commission is a cost of accepting the card, not a shortage, and it must be booked as its own item.
Match gross to gross first: terminal total against system total. Only then compare against the bank, with commission and refunds removed. If you match the net credit to the gross total, you create a difference that recurs every single day and grows with volume, and the real errors hide inside it.
Settlement timing depends on the contract, the card type and the bank's calendar. Do not assume a fixed number of days in your procedure; ask your bank what applies to your account. Refunds and chargebacks arrive as separate lines and can land in a later accounting period than the original charge, so a period's settlement rarely equals a period's sales.
Ask the bank for the transaction-level settlement file or panel, not just the total credit. A single net figure cannot be reconciled to anything. The bank statement is the third record and the last to arrive. By the time it appears, the match between the first two totals should already be done and the difference already explained, as part of what moves from the PMS to the accounting system at day end.
TipOne sheet per business date
Keep the three totals on one sheet per business date: terminal total, system total, difference. Add the bank settlement underneath when it arrives, with commission and refunds shown as separate lines. One page per day means an unresolved item cannot hide in a monthly total.
Who closes a difference, and how is it logged?
The person who can actually act on the cause, recorded in a log with an owner and a status, and re-checked by the morning income audit until it is closed.
The log needs these fields: business date, terminal total, system total, difference and its direction, folio or reservation reference, suspected cause, owner, status and the date it was closed. Assign by cause, not by seniority: a posting error belongs to the front office, a settlement or commission item belongs to accounting, a one-sided void belongs to whoever can reach the terminal and the guest.
Set a time limit as a management policy, for example within the same working day or the same week, and write it down. It is your rule, not a legal requirement. Management may set a tolerance for small unexplained differences; a tolerance decides what gets investigated, it does not delete the entry from the log.
Anything that touches a guest's card is a guest matter before it is a ledger matter: the correction and, where needed, the refund go to the guest, not only to the accounts. Close the loop: the night auditor produces the pack, the income auditor re-performs the match and confirms or reopens each item, and the log is the handover between them. The morning side of this routine is covered in income audit: what the day audit checks after night audit.
What to do next
Tonight, add one sheet to the night audit pack: the terminal total, the system payment total for the same business date, and the difference between them, signed by the person who closed the terminal. Name the person who checks that sheet in the morning. The three-way match, the terminal close, the reasons for a difference, the virtual POS exception and the discrepancy log are one routine, and the routine only works if it runs every business date, including the quiet ones.
Frequently asked questions
Should the terminal be closed before or after the night audit runs?
Before the night audit is finalized, so the terminal total and the system total describe the same set of charges. The exact point depends on when the last charge belonging to the business date is expected; fix it in the procedure and keep it the same every night. Charges taken after the close belong to the next business date and must be flagged.
What should I do if the terminal total is higher than the hotel system?
The terminal holds a charge the system does not, or holds it twice. Check for a duplicate swipe, a charge taken after the close, a pre-authorization mistaken for a payment, and a payment posted to the wrong business date. Find the folio or reservation first, then correct the side that is wrong and log it.
Is bank commission a cash shortage?
No. Commission is the cost of accepting the card and belongs in the accounts as its own expense item. A shortage is money the hotel expected and did not receive or cannot explain. Matching a net bank credit against a gross terminal total will always produce a difference that is not a shortage.
How long should we keep the terminal end-of-day reports?
Long enough to answer a guest query, a chargeback or an inspection, and the period is set by your accountant and your own document policy, so confirm it with them. Keep them with the night audit pack for the same business date rather than in a separate file, so the match can be re-performed later.
Can the same person take the card payments and reconcile them?
It is better if they do not, because the person who took the payment is the person least likely to notice their own error. In a small hotel the same person often does both, and the control then becomes the morning re-check by someone else plus the signed terminal report. Write down which of the two applies in your hotel.