Reconciliation
Whether the money actually reached the bank: gateway payouts, the bank statement as CSV, and agencies' virtual cards.
What it solves
Charging and receiving are not the same thing. Between a card charge and the peso in the hotel's account there are days, fees and grouped payouts, and the only way to know whether something got lost on the way is to cross-check all three lists.
You notice it in things like these
- A gateway payout arrives and nobody knows which bookings are inside it.
- An agency virtual card expires uncharged and that money is simply lost.
How it works
Gateway payouts
"Sync" reads the hotel account's payouts and the movements inside each one, and links every charge to its booking's payment. It flags charges that match no booking and separates the gateway fee. It is read-only: reconciliation moves no money.
The bank, as CSV
The hotel uploads its statement. Columns are read by name and it tolerates what banks actually send: comma, semicolon or tab separators, day/month/year dates, amounts as "$1,234.56" or "1.234,56", and either a signed amount or separate debit and credit columns. Balance rows or unreadable lines are shown with their line number without killing the file, and uploading the same period twice duplicates nothing.
Automatic only when there is no doubt
A credit is auto-matched only if there is exactly ONE candidate: a payout of the same amount within ±3 days, or a transfer recorded on a booking for the same amount — and if there are several, the only one whose code appears in the description. With two identical ones, a person decides. Manually you reconcile against nearby payouts or payments noting the difference, and a wrong link is undone leaving a trace.
Agency virtual cards
Per booking with a virtual card: its balance, what was charged minus refunded, and its state — to activate, to charge, partial, charged, expired or cancelled — with totals. "Expired" is money lost by not charging in time, which is why it has its own state instead of hiding among the rest.
Where it lives in the panel
- Reservations & stays
- Reservations
- Reconciliation
What it needs first
The hotel's payment account connected, so its payouts can be read.
The bank statement as CSV, if you want to reconcile against the bank.
What it does not do yet
The limits, told by us
- The module still has to be switched on in the plans, and the first sync with a real hotel is still pending.
Carry on here
Shall we walk through it with your hotel on screen?
Half an hour, your rooms and your rates, and whatever questions you have. No commitment and no card.