The city tax report gives you an estimation of the tourist tax collected on your bookings over a chosen period, so you can declare it to your local authority. You receive the file as an Excel attachment by email.
Two views are available — pick the one your local authority asks for:
By booking — one row per booking, useful for detail.
By day — one row per calendar day, useful for monthly returns.
Before you start
Set up your city tax in Settings > Taxes > City tax first — the report uses those rates.
The figures are an estimation, not a legal document. Some OTAs (e.g. Booking.com, Airbnb) collect and remit city tax directly to the municipality — those amounts may not appear here, depending on your channel setup.
Step-by-step guide
1. Open the Reports list
From the admin sidebar, go to Reports > Reports. Scroll until you find City tax report.
2. Select the report
Tick the checkbox next to the City tax report. A pop-up appears — click Next.
3. Choose dates, format, and send
Pick the email address, the date range, and whether you want the report by booking or by day. Click Send reports. The Excel file arrives in your inbox shortly.
What's in the report
By booking (1 row per booking):
Booking ID, Room category, Source (Booking.com, Airbnb, direct…), Arrival and Departure dates
Actual nights stayed — total nights of the stay
Taxable nights — nights where city tax applied (after exemptions)
Exempt nights — actual nights minus taxable nights
Adults and Children
City tax and Total for adults — amount collected
Total for children — always 0 (see Important rules)
VAT rate — only if your hotel charges VAT on city tax
Amount — final total per booking
By day (1 row per date):
Date, Rooms sold, Adults, Children
Unit price, Total for adults, Total for children (0), Total amount
How the tax is calculated
For each booking, the report applies:
City tax = rate × adults × taxable nights
— using the rate configured in Settings > Taxes > City tax, the number of adults on the booking, and the number of nights inside your date range after any exemptions you've set up (age bands and length-of-stay caps).
Example: city tax of €1.50, 50 guests in April, 1 night each → estimation = 50 × 1.50 = €75.
When the tax is already included in the room price (a setting on the room), the system recomputes the city tax from your current settings rather than reading a separate charge.
Important rules
Only confirmed and modified bookings are counted. Cancellations and no-shows are excluded.
Nights are counted by stay date, not booking date. A stay straddling the period boundary only contributes the in-range nights.
Children are never billed in this calculation (Total for children = 0). If your local authority taxes minors, you'll need to adjust the declaration manually.
Exemptions configured in Settings > Taxes > City tax (age bands, length-of-stay caps) reduce the taxable nights automatically.
OTAs that collect city tax directly (such as Airbnb in many cities) may not appear in this report — the data is what was billed through Amenitiz.
If you change your city tax rate, bookings with the tax included in the room price will use your current rate when the report is generated.
FAQs
Why does the report only give an estimation?
Why does the report only give an estimation?
Some OTAs (Booking.com, Airbnb, etc.) collect and remit city tax directly to the municipality, and don't pass that data back. Amenitiz can only report on what was billed through your booking engine and PMS — so the total may differ from what the municipality has on file.
Are children charged?
Are children charged?
No. The report assumes children are exempt and shows 0 in the children columns. If your local authority taxes minors (some Spanish regions do), you'll need to adjust the declaration manually.
Are cancelled bookings or no-shows included?
Are cancelled bookings or no-shows included?
No — only confirmed and modified bookings appear in the report. If your local authority requires no-shows to be declared, add them to the declaration manually.
How are age and length-of-stay exemptions handled?
How are age and length-of-stay exemptions handled?
Configure them in Settings > Taxes > City tax (age bands and any length-of-stay cap your municipality applies). The report's Taxable nights column already accounts for those exemptions.
What's the difference between "by booking" and "by day"?
What's the difference between "by booking" and "by day"?
Both report the same tax — just laid out differently. By booking gives you one row per reservation (good for audit); by day gives you one row per calendar date (good for monthly declarations).
Why doesn't a tax-included booking match my current rate?
Why doesn't a tax-included booking match my current rate?
For bookings where city tax is included in the room price, the report recomputes the amount from your current settings. If you changed the rate since the booking was made, the report will use the new rate — not the rate that was in force at the time.