Short-term rental owner statement template: structure, example, and automation
Seven standard blocks, a complete monthly example, differences between revenue share and master lease, calculation of the accrued cedolare secca (flat-rate rental tax). Plus: why Excel works up to 3 units and what changes beyond. Reference material for property managers, professional hosts, and accountants (commercialisti) handling Italian short-term rentals.
In sintesi
Seven mandatory blocks in the statement: header + CIN, list of bookings, revenue, deductible costs, net to the owner, accrued cedolare (informational), notes and attachments.
Standard market cadence: monthly, transfer to the owner by the 15th of the following month.
In revenue share the statement is detailed per booking (the owner sees everything). In master lease it becomes a simple receipt for the fixed rent plus an informational cedolare calculation.
21% withholding when you collect: a PM who collects the rents must by law apply the 21% withholding (art. 4 of Decree-Law 50/2017), pay it via F24 and issue the CU certificate; the owner's cedolare is then settled in their tax return.
Excel works up to 3 units. Beyond that, the issue isn't the format but consistency across different owners and monthly OTA reconciliations.
Anatomy of the statement: the 7 blocks
Standard sequence in the Italian market. Each block is optional only if the contractual model allows (e.g., the booking list is omitted in master lease).
- 1
Header and identification
Period (month/year), property (name, address), owner, CIN code, any regional CIR, details of the issuing PM. The CIN has been mandatory since 2024: any statement without a CIN is a red flag.
- 2
List of bookings for the period
For each stay: check-in/check-out date, number of guests, channel (Airbnb, Booking, Vrbo, direct), gross price received, any extras. Omitted in master lease (the PM keeps the detail).
- 3
Revenue items
OTA gross, extra fees (pet, cleaning charged to the guest), tourist tax collected. The tourist tax is a pass-through with zero margin: listing it is good practice — it avoids confusion when the owner sees the gross OTA payout.
- 4
Deductible cost items
OTA commissions, cleaning and linens, PM fee (% agreed in revenue share), non-deductible VAT on commissions if the owner's tax regime requires it. Attach invoices and receipts where possible. OTA commission calculator →
- 5
Net to the owner
Total revenue minus deductible costs = net to transfer. Indicate amount, owner's IBAN, expected transfer date. The owner wants to know "how much I receive" and "when" before everything else.
- 6
21% withholding and accrued cedolare
If the PM collects the rents on the owner's behalf (revenue share, as here), it must by law apply the 21% withholding on the gross rents (art. 4 of Decree-Law 50/2017), pay it via F24 and issue the CU certificate. The withholding must appear in the statement: with the 21% cedolare it covers the tax; in other cases it's an advance credited in the tax return. Also listing the accrued cedolare helps the owner compare regimes (see forfettario vs cedolare). Common mistake: wiring the gross without applying the withholding when you collect the rents.
- 7
Notes and attachments
Cleaning invoices, linen receipts, OTA commission screenshots, extraordinary communications (maintenance, damage, complaints). Documentary transparency reduces the owner's "why?" questions and builds trust for annual management-contract renewals.
Numerical example: monthly statement in revenue share
Two-room apartment in Rome, 4 bookings in the month, PM management in 70/30 revenue share (owner 70% of OTA net, PM 30%). Private owner under cedolare secca 21%.
| Item | Amount |
|---|---|
| REVENUE | |
| OTA gross (4 bookings) | 2.400,00 € |
| Extras (pet fee, late check-in) | 60,00 € |
| Tourist tax collected (pass-through to municipality) | 120,00 € |
| Total management revenue | 2.460,00 € |
| DEDUCTIBLE COSTS | |
| OTA commissions (~15%) | −360,00 € |
| Cleaning + linens (4 turnovers × €60) | −240,00 € |
| PM fee (30% of OTA net = 30% × 2,040) | −612,00 € |
| Total deductible costs | −1.212,00 € |
| MANAGEMENT NET (BEFORE WITHHOLDING) | 1.248,00 € |
| TAX DISCLOSURE | |
| 21% withholding on the gross (€2,460), paid by the PM via F24 | −516,60 € |
| Actual transfer to the owner (net − withholding) | 731,40 € |
How the 21% withholding works
From the management net of €1,248.00 the PM withholds €516.60 (21% of the gross, art. 4 of Decree-Law 50/2017) and wires €731.40. The withholding is paid via F24 by the 16th of the following month, with the CU certificate to the owner in March. For an owner on the 21% cedolare it covers the tax on the intermediated rents; with the 26% cedolare or IRPEF the balance is settled in the tax return. When the OTAs collect (Airbnb, Booking), they apply the withholding themselves.
Differences in master lease
In master lease the PM pays the owner a fixed monthly rent agreed in the contract, independent of bookings. The statement becomes a simple rent receipt:
- Period + property + CIN
- Agreed rent (e.g., €1,500)
- Any expense reimbursements borne by the owner
- Accrued cedolare on the rent (if applicable: for a master lease to a business tenant this is a debated point — check with your accountant)
- IBAN + transfer date
The PM keeps the operational detail (bookings, costs, margin) — the commercial risk is theirs. The owner gets a certain rent; the PM gains or loses on the difference between management revenue and rent paid.
Four mistakes to avoid in the statement
- PM business overhead pushed onto the owner (employees, software, office, marketing). These are your costs. If you list them, you lose credibility the moment the owner asks for details.
- VAT charged to the owner when the regime doesn't require it. Verify with your accountant (commercialista): most PM-owner relationships in Italy don't include VAT charged, but there are exceptions for certain structures.
- Hidden PM margin inside 'cleaning' or 'maintenance' items. If the cleaning provider costs €40 and you put €60 in the statement, that's a disguised PM margin. If discovered, goodbye contract renewal.
- Tourist tax treated as revenue or cost. It's a zero-margin pass-through (you collect it and remit it to the municipality). Listing it separately from management revenue avoids confusion about the net.
When Excel is no longer enough
For 1-3 units the Excel template works great: copy the file, change the numbers, export to PDF, send by email. Above 5 units the issue isn't the format but consistency:
- Each owner receives a slightly different Excel (custom columns, formulas that break when you insert rows)
- Reconciliations with OTA reports take hours a month
- Numbers don't always tally between PMS-imported bookings and those in the statement
- Copy-paste errors the owner notices before you do
- Time spent on formatting that adds no value
Read more: Excel vs dedicated software for short-term rentals.
Generate branded PDF statements, automatically
14 days free trial, no credit card. Import bookings from your PMS, configure the model (revenue share or master lease) and the statement fields, generate the PDF for each owner with one click. Accrued cedolare calculated automatically based on the configured regime.