Reports
Find the right report for revenue, payments, taxes, occupancy, booking sources and staff activity, and export any of them to CSV.
Open Reports in the top bar. Reports are grouped down the left. Every report has date controls at the top and Print and Export CSV buttons, so you can hand figures to your accountant or open them in Excel or Google Sheets.
Which report do I need?
| Question | Report |
|---|---|
| How much did we earn, and what were occupancy, ADR and RevPAR? | Ledger → Summary, by day or month. |
| What did we charge, by type (rooms, F&B, spa…)? | Ledger → Charges |
| What did we collect, by payment method? Does the cash drawer match? | Ledger → Payments |
| How much tax do we owe? | Ledger → Taxes |
| Who is arriving, staying or leaving? | Bookings → Check-In/Out Report |
| What was booked, and when? | Bookings → Reservation Report (filter by stay dates or created date) |
| How full were we this year? | Bookings → Yearly Occupancy |
| Which deposits have we taken for future stays? | Bookings → Advance Deposit |
| Who changed this invoice? | Bookings → Folio Audit Trail |
| Where do our bookings come from, and what is each channel worth? | Market Segment → Booking Source |
| Which guest types or countries matter most? | Market Segment → Customer Type and Geographical |
| What did each staff member post or change? | Employees → Employee Ledger and Employee Action |
Charges and payments
Choose Month or a Date Range. Charges are broken down by charge type and payments by payment type, one row per day with totals. Click a date to see the individual lines behind it.
Booking sources
The Booking Source report compares room nights, ADR, RevPAR, room revenue and total revenue for each source: walk-ins, phone, your booking engine and each OTA. Use it to see what your direct channels are worth compared with the OTAs.
Common questions
Which report shows occupancy, ADR and RevPAR?
Reports → Ledger → Summary, by day or month. For what each figure means and how it is calculated, see Revenue management.
How do I reconcile the cash drawer?
Open Reports → Payments for the day. Payments are broken down by payment type, so the cash total should match the drawer. Click the date to see each payment behind it.
Can I export reports to Excel or Google Sheets?
Yes. Every report has an Export CSV button, and the file opens in Excel or Google Sheets or can go straight to your accountant.
How do I see which OTA brings the most bookings?
The Booking Source report compares room nights, ADR, RevPAR and revenue for walk-ins, phone, your booking engine and each OTA.
Still stuck?
Our support team answers every message. Inside Roomsy, open Help → Support Request, or email us.