Hotel payment report: open balances automatically
Payment status, open balances and discrepancies arrive regularly as a report.
- Trigger
- daily or weekly
- Guide value
- ≈ 10 minutes per property and day (estimate)
- Systems
- PMS
Today
Look up payment status and open balances in the PMS one by one.
Afterwards
Payment status, open balances and discrepancies arrive regularly as a report.
How to set it up
- 01
Describe the task
In plain language, the way you would explain it to a new colleague. The description below is a starting point.
- 02
Review the first run
Discontinue shows you the result before anything runs on a schedule.
- 03
From then on it runs
On a schedule or when something happens. You can change it in chat at any time.
Every morning at 8:30, send me a payment report: yesterday’s departures with an open balance, arrivals in the next 3 days without payment, and discrepancies between invoice and payment.
Step by step in the documentation: Create a report in chat and Schedule a report.
What the result looks like
The report arrives on schedule, wherever your team reads it.
What stays with you
You decide how open balances are handled.
- Open balance
- 3 departures · €412
- Unpaid
- 5 arrivals
Sample data. Your output uses your property’s data.
Systems and permissions
| Software, any one of them | Access | What for |
|---|---|---|
| PMS | read | Read folios, invoices and payments |
| Payments (optional) | read | Match payments at the payment provider |
| Team channels (optional) | write | Deliver the result to the team inbox or channel |
Apaleo
Oracle OPERA Cloud
Cloudbeds
Beds24
Hospitable
Mollie
PayPal
Slack
TelegramWhich data and actions are available depends on each system’s interface. When you connect a system you decide what is granted; every run is logged.
Frequently asked questions
Can the report come weekly instead of daily?
Yes. You set the schedule when you set it up and can change it in chat at any time.
Which permissions does “Payment report” need?
PMS (Apaleo, Oracle OPERA Cloud, Cloudbeds, Beds24, or Hospitable): read, Read folios, invoices and payments. When you connect a system you decide which areas and actions are granted. Everything else stays off-limits.
Does every run cost AI credit?
No. A report is built once with AI and then runs from its saved definition. Scheduled report runs cost no credit.