Unified payments analytics - Card-present and Online
All data is synthetic
Alerts & Notifications …significantly off portfolio median
1 · General Overview
Combined monthly trend — Card-present collected vs Online deposits
Monthly collected volume for card-present (ZABA) and online reservations (web, app, call centre, pay-by-link) on one axis — shows the two channels side by side and how seasonality drives both.
Scheme split in money (bars) and transactions (line) in one view. A gap between a scheme's €-share and tx-share shows ticket-size differences — input for scheme fee negotiations.
Monthly volume & transaction count
Card-present collected volume (bars) against transaction count (line) per month — average ticket trend.
Top 10 hotels by Void (€)
Highest voided amounts by property — a director fixes hotels, not brands. Surfaces properties with operational or auth issues.
Property
Count
Void €
Top 10 hotels by Refund (€)
Highest refunded amounts by property — refund leakage is cash out the door after a stay.
Property
Count
Refund €
Refund leakage by property (% of collected)
Refunds as a share of collected card-present volume — hides in gross numbers. Above ~2% signals a process problem (or fraud); compare properties, not absolutes.
Property
Refund €
Collected €
Leak %
DCC opportunity — international cards billed in EUR
Foreign-issued cards (GBP/USD/CHF…) charged in EUR with no currency choice, × typical 1.2% DCC margin — found money, no integration cost. Modeled: issuer currency mix is synthetic.
Property
Intl vol €
Tx
Est. margin €
Top 10 hotels by transactions per room
Properties with the most payment activity relative to room count — front-desk load and terminal pressure.
Property
Tx
Rooms
Per room
3 · Online Transactions
Link status mix
Where every online payment stands: paid, still open (sent), expired, or failed. Covers Valamar.com (web), pay-by-link, call centre and mobile app. The expired + failed share is direct deposit leakage.
Deposit collection rate trend (paid ÷ sent)
Monthly deposit capture = paid online deposits ÷ sent. Drop-offs show where the booking-to-payment funnel leaks.
Revenue at risk — expired + failed deposits (€/month)
Online deposit value that was requested but never collected, by month. This is the pipeline HPG auto-reminders and recovery would protect.
Auto-post gap — paid but not posted to OPERA
Online deposits paid successfully yet missing from OPERA (manual entry gap). Causes reconciliation work and mismatched guest ledgers.
Failure reasons
Why online payments fail — the top reasons tell you which PSP/issuer interventions recover the most.
Online channel mix
Online payment volume by channel — Valamar.com (web), pay-by-link, call centre, and mobile app. Shows channel reliance and where to focus conversion.
Top 10 properties by expired deposit value (€)
Properties losing the most deposit value to expiry — prioritise these for automated recovery.
Property
€
Links
Time-to-pay — link sent → paid
When online deposits actually get paid after the link goes out. A long right tail means cash lands late vs check-in — chase earlier with reminders; a fast median means the flow works.