Month-end export for hotel accounting
Every month the Excel files land in the accountant’s SFTP directory, named the way their system expects.
- Trigger
- monthly
- Guide value
- ≈ 3 minutes per property and day (estimate)
- Systems
- PMS
- Accounting & banking / SFTP
Today
Export accounting and invoice data by hand every month and pass it on.
Afterwards
Every month the Excel files land in the accountant’s SFTP directory, named the way their system expects.
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.
On the 2nd of every month at 6:00, put last month’s accounting and invoice data as Excel files in our accountant’s SFTP directory. File name: Property_YYYY-MM_accounting.xlsx.
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
Your accountant does the closing itself.
- Files
- 2 · placed in the SFTP directory
Sample data. Your output uses your property’s data.
Systems and permissions
| Software, any one of them | Access | What for |
|---|---|---|
| PMS | read | Read accounting and invoice data |
| Accounting & banking or SFTP | write | Hand the export to accounting or the SFTP directory |
Apaleo
Oracle OPERA Cloud
Cloudbeds
Beds24
Hospitable
sevDesk
Pennylane
Qonto
Debitura
FTP / SFTPWhich 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 file name follow my accountant’s system?
Yes. You describe the pattern once and every export follows it.
Which permissions does “Month-end export” need?
PMS (Apaleo, Oracle OPERA Cloud, Cloudbeds, Beds24, or Hospitable): read, Read accounting and invoice data; Accounting & banking or SFTP (sevDesk, Pennylane, Qonto, Debitura, or FTP / SFTP): write, Hand the export to accounting or the SFTP directory. 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.