Export bookings to CSV

Tento obsah zatím není dostupný ve vašem jazyce.


Why	Hand your accountant a list of bookings for a period, or bring it into a spreadsheet — with sources, or without confidential data.
Who	The administrator; the accountant works through them.
What you’ll get	A CSV file of bookings for a period — one channel only if needed — with passport details included as a conscious choice.
Limitations	Up to 5,000 rows; the set of columns is not configurable; this is an export, not a report — the system totals nothing.

When a list of bookings is needed outside the system — a month for the accountant, or a spreadsheet to tally yourself — bookings leave as a file. The “Export CSV” button above the list opens a dialog with a period, a source, and a question about passport details. This article covers how to set up the export, why passport details are off by default, and where the format’s limits run.

Open the export

Open “Bookings” in the left menu.
In the list’s header, next to “New booking”, press “Export CSV”.
The “Export bookings to CSV” dialog opens — the file does not download at once, but after you fill in the form: period, source, passport details.

Set the period and source

The period is counted by the arrival date — the day the guest is due to arrive.

In the “Arrival from” field pick the first day of the period, in “Arrival to” the last one: the file takes the bookings whose arrival falls inside this range.
In the “Source” field keep “All sources” or pick a single channel — for example, when the export is needed for Booking.com only.
Press “Export” — the file downloads.

Two nuances:

The source directory holds channels: on the demo stand those are Airbnb, Booking.com, and Expedia. Direct sources — the front desk, the phone, the hotel website — are not in the list: “All sources” covers them automatically, and exporting only the direct ones is not possible.
The dialog has no other periods: bookings cannot be filtered by the booking date or the departure date here — arrival only.

Passport details — a deliberate choice

The dialog holds a toggle captioned “Include guests’ passport details (sensitive PII)”, and it is off by default. While it is off, passport details do not reach the file. Turn it on — and the columns with guests’ personal details end up in the file.

The rule is simple: leave it off unless you need it. A month for the accountant or a per-channel tally does not require passports — keep the toggle off. Turn it on only when the data is genuinely required, and remember: a file with guests’ passport details is sensitive — pass it directly to the recipient and do not keep it longer than needed.

Export and check

Double-check the period, the source, and the state of the passport-details toggle.
Press “Export” — next to “Cancel” — and open the downloaded file.
Check the selection: arrivals inside the range, the channel you picked, as many rows as there are bookings for the period.

Two limits of the format worth knowing before you export:

Up to 5,000 rows. The file holds no more than five thousand bookings. If the period is wider, narrow the “Arrival from” / “Arrival to” range and export in parts.
Columns are not configurable. There is no column or format choice in the dialog: the file is a fixed flat list of bookings. Whatever it does not hold gets tallied later, in your own spreadsheet.

Result: you have a CSV file with the bookings of the chosen period — across all channels or one, and without passport details as long as the toggle stayed off.

Scenario: your accountant needs a month

Open “Bookings” and press “Export CSV”.
Set the period: “Arrival from” — the first day of the month, “Arrival to” — the last one.
Source — “All sources”; leave the passport-details toggle off: the accountant does not need passports.
Press “Export” and hand over the file.

If the same month also needs a per-channel breakdown, the tally is done with repeated exports: the same period, the channel you want in the “Source” field, “Export” — and the channel’s file lands next to the overall one. How sources work in the system is covered in Booking channels and sources: what you can see.

Honest limits

This is an export, not a report. The CSV is a flat list of bookings: the system totals and summarizes nothing — that is your spreadsheet’s job.
Money does not export to a file. There is no export of the money movements journal in the system — only bookings leave as a file. Amounts for a period are added up by hand from the journal.
The period is arrival-based only. The booking date and the departure date are not available in the export dialog.