Financial & Tax · Smoobu Hosts · Berlin

Berlin Übernachtungssteuer

How to calculate and file Berlin's city tourism tax using your Smoobu data — the routine part every host can handle themselves.

7.5%rate (from 2025)
Quarterlyfiling
All staysno exemptions
Berlinonly (this guide)
Recent changes: The business travel exemption was abolished in April 2024. The rate increased from 5% to 7.5% in January 2025. The 21-day long-stay exemption also ended in 2025. From 2026, electronic filing is required for all operators. This guide reflects current rules.

Do you owe it?

You owe the Übernachtungssteuer on a booking if all of these apply:

  • The property is in Berlin
  • The booking is for fewer than 6 months
  • You are the operator registered with the Finanzamt

Since April 2024, there are no exemptions based on the purpose of travel — business stays are taxable just like tourist stays.

What is the Übernachtungssteuer?

Berlin's city tourism tax was introduced in 2014 and has been reformed several times since. From January 2025, the rate is 7.5% of the net accommodation price. It applies to all short-term accommodation in Berlin — hotels, apartments, and Airbnb listings alike, for all guests regardless of the purpose of travel.

"Net accommodation price" means after stripping VAT and after excluding the cleaning fee — the pure accommodation component. You file and pay it quarterly, directly to the Berliner Finanzamt. This guide covers that process end to end. It does not cover income tax, VAT returns, or the EÜR — those are Steuerberater territory.

One-time registration

Before your first quarterly filing, register as an Übernachtungssteuer payer with the Berliner Finanzamt. This is a one-time step.

  1. Fill in form uenst-8 (Anmeldung zur Übernachtungssteuer)
  2. Submit via the Berlin.de tax portal
  3. Optionally set up a SEPA mandate for direct debit with form sepa-mandat_be
  4. You receive a tax reference number for the Übernachtungssteuer — keep it

Register before your first taxable booking. If you are already renting and have not registered, do it now and file retroactively for missed quarters.

The quarterly calculation

For each booking in the quarter, you need two numbers from Smoobu (or your OTA statement):

  • paid_out — total payout to you after the OTA host fee, including city tax passed through by the OTA
  • host_fee — what the OTA kept (the host service fee)

Step 1 — Net accommodation (the tax base)

net accommodation = paid_out ÷ (1.07 × 1.075)
= paid_out ÷ 1.15025

This strips out 7% VAT (Umsatzsteuer) and 7.5% city tax that are layered into the Airbnb payout. What remains is the pure accommodation price — the tax base.

Step 2 — City tax owed

Übernachtungssteuer = net accommodation × 7.5%

Worked example

5-night Airbnb stay, 3 guests

Smoobu paid_out €876.55
Airbnb host_fee €32.45
Net accommodation (÷ 1.15025) €762.05
Übernachtungssteuer (7.5%) €57.15

For your accountant: the VAT base (Bemessungsgrundlage)

The uenst-2a form also asks for the Bemessungsgrundlage — the full accommodation charge to the guest, stripped of VAT. This is the base for your Umsatzsteuer return, not for the city tax itself.

Bemessungsgrundlage = (paid_out + host_fee) ÷ 1.07

Using the example above: (€876.55 + €32.45) ÷ 1.07 = €849.53. Umsatzsteuer: €849.53 × 7% = €59.47 — filed separately on your VAT return, not on the uenst-2a.

How Airbnb handles this — and why you still file

Airbnb collects the city tax from guests and passes it through to hosts in Berlin. It appears in your payout details as "Occupancy Tax Amount Paid To Host." This is why the city tax is embedded in your paid_out — and why the ÷ 1.15025 formula strips it back out.

Airbnb collecting it does not mean they file on your behalf. You receive the tax in your payout and you are responsible for remitting it to the Berliner Finanzamt quarterly.

Booking.com may handle this differently. Check your payment statements — if city tax is not being passed through, the formula adjusts to paid_out ÷ 1.07 (strip VAT only). When in doubt, check with your OTA's support.

Quarterly filing — step by step

  1. Pull your booking data — export from Smoobu or use the Google Sheets sync script to get paid_out and host_fee per booking
  2. Apply the formulas — calculate net_accommodation and city tax (7.5%) per booking
  3. Sum the quarter — total Bemessungsgrundlage, total guest-nights, total city tax
  4. File online — Berlin.de tax portal, form uenst-2a-anmeldung-uebernachtungsteuer. From 2026, electronic filing is mandatory.
  5. Pay — via SEPA mandate (set up once with sepa-mandat_be) or bank transfer

Quarterly deadlines

QuarterBookingsFile by
Q1January – March30 April
Q2April – June31 July
Q3July – September31 October
Q4October – December31 January (next year)

Official Berlin FAQ and filing portal: berlin.de — Übernachtungssteuer

Tracking this in a spreadsheet

The calculation needs to happen for every booking, every quarter. The practical setup is a Google Sheets file connected to Smoobu via the API — bookings sync automatically, formulas apply per row, quarterly totals populate the uenst-2a form fields.

The full technical setup — API connection, CONFIG block, column formulas — is in the companion guide: Smoobu → Google Sheets: the complete sync script.

The tracking spreadsheet — ready to copy

A pre-configured Google Sheet with all formulas built in, fake example bookings from Airbnb and Booking.com, and a step-by-step runbook tab covering the full quarterly workflow: data sync → ÜnStG tab → Elster.

  • 5 tabs: Tax export, Interpretation, Pivot, ÜnStG calculation, Runbook
  • Formulas wired in: Bemessungsgrundlage, ÜnSt, VAT columns, quarterly SUM rows
  • Google Apps Script included — paste your Smoobu API key and sync in one click
  • Full filing runbook with Elster screenshots and Booking.com notes
Copy the template to your Drive →

Opens in Google Sheets — click "Make a copy" to get your own editable version.

This template is a starting point, not tax advice. For income tax, VAT, or complex situations, consult a Steuerberater.

Free tool

Get your starting setup — configured for your situation

Tell us your city, which OTAs you use, and how many properties you manage. We'll send you a pre-configured starting point with formulas explained and a step-by-step Smoobu API connection guide. One email. No spam.

Configure my template →

Takes 90 seconds · One email with your setup · Nothing else unless you ask

Revenue & City Tax Estimator

Annual estimate — Berlin 7.5% rate, all stays taxable.

Occupancy rate
Gross revenue
After OTA fees

Berlin Übernachtungssteuer (7.5%)

Net accommodation
City tax owed
Estimated net income

Approximate — assumes Berlin 7.5% rate and Airbnb-style tax pass-through in payout. Booking.com may differ. Verify with your actual payout data.

This guide describes the mechanical process of calculating and filing the Übernachtungssteuer — it is not tax advice. For income tax, VAT returns, or the EÜR, consult a Steuerberater. Last reviewed: 1 July 2026. Rate 7.5% applies from January 2025. Other German cities (Hamburg, Munich, Frankfurt) have their own city taxes at different rates.

The channel manager I actually use. Airbnb, Booking.com, and direct bookings in one dashboard — 14-day free trial, no credit card.

Try Smoobu free → * Affiliate link