Overview
The Charges Report lists every charge — booked nights, extras, and city taxes — across all bookings in the period you pick. Each charge is its own row, so a 3-night booking with breakfast shows up as multiple lines. It's the report to reach for when you want to verify that charges, payments, and invoices line up for a given day or month.
This article isn't a step-by-step task — it's a reference. Below you'll find how to pull the report and what every column in it means.
Before you start
The report includes all charges from active bookings — paid or not, invoiced or not. Cancelled bookings drop off the report entirely.
For OTA bookings, the VAT rate sometimes can't be retrieved from the channel and ends up as 0% or wrong. You can fix it on a charge in the booking's details, and the report updates accordingly.
The report is delivered as an Excel (.xlsx) file by email — pick the recipient address before sending.
How to get the report
Go to
Reportsin the sidebar, then click theReportssubsection. Scroll down and tick the box next toCharges report. A modal appears.Choose the recipient email and the date range you want covered. Then click
Send reports. The Excel file lands in the recipient's inbox shortly after.
What each column means
Date — the day the charge was consumed by the guest, or the date you set when you added the charge manually. A 3-night stay produces three booked-night rows, one per date.
Type — what kind of charge: booked night, city tax, extra, or a custom free field if you've added one.
Category — only populated for the Extra type. Shows the category you linked the extra to in your settings. Empty if the extra isn't linked to a category. See how to create and manage extra categories.
Accounting code — the accounting code attached to the charge. For booked nights it always shows Room sold. For extras it's the accounting code set on the extra's category. Blank if no code is configured.
Description — the name of the extra, or the room category for booked-night rows. This is what lets you tell two rows of the same Type apart.
Client — the name of the person who made the booking. If the booker and the occupant are different, this column still shows the booker's name.
Booking reference — the Amenitiz internal reference. Use it to find the booking from the search bar at the top of the admin, or to share with support when reporting an issue.
Charge revenue (tax excl.) — the revenue for that line, before VAT.
VAT rate — the VAT % applied to the charge, based on what you set when you created the room or extra. If you manually overrode it in the booking's details, the override is what appears here.
VAT amount — the VAT in money terms. Computed as VAT rate × tax-excluded amount; also reflects any manual override on the booking.
Charge revenue (tax incl.) — the tax-included total for the line. Equals tax-excluded + VAT amount.
Source — where the booking originated: Amenitiz (your Booking Engine), manual (you entered it directly in the admin), or the name of the OTA channel.
FAQs
Why doesn't a cancelled booking show in the report?
Why doesn't a cancelled booking show in the report?
Cancelled bookings are removed from the report entirely — no rows for any of their charges. If you need to audit cancellations specifically, that lives in the booking history, not in the Charges Report.
The VAT rate shows 0% on an OTA charge — how do I fix it?
The VAT rate shows 0% on an OTA charge — how do I fix it?
Open the booking from Reservations, find the specific charge in the booking details, and update the VAT rate manually. The next time you pull the Charges Report, the corrected rate appears.
Why does one booking show as multiple rows?
Why does one booking show as multiple rows?
Each row is one charge for one date. A booking spanning three nights with a breakfast extra each night gives you three booked-night rows + three breakfast rows. This per-day split is what makes the report useful for daily reconciliation against payments and invoices.
What does "Room sold" mean in the Accounting code column?
What does "Room sold" mean in the Accounting code column?
Room nights don't carry a custom accounting code the way extras do — they're always labelled Room sold in the Accounting code column. Extras inherit their accounting code from the category they're linked to.
I exported as Excel — can I get a CSV instead?
I exported as Excel — can I get a CSV instead?
The Charges Report is delivered as Excel (.xlsx) only. If you need CSV, open the file in Excel or Google Sheets and use Save as / Download as CSV.