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.
The cedolare is not withheld from the net: it's listed as information — the owner pays it via F24.
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
Accrued cedolare (informational only)
Calculation of the cedolare secca (flat-rate rental tax) 21% (or 26%) on the period's gross. It is not withheld by the PM: the owner pays it via F24 in their tax return. Listing it helps the owner track future tax outflows and compare regimes (see also forfettario vs cedolare). Common mistake: withholding it from the net transferred. DON'T.
- 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 € |
| NET TO TRANSFER TO OWNER | 1.248,00 € |
| TAX DISCLOSURE | |
| Accrued cedolare (21% on €2,460 gross), to be paid via F24 | 516,60 € |
Why the cedolare is informational
The owner receives €1,248.00 transferred by the PM and must pay €516.60 in cedolare secca via F24 (advances June 30 + November 30, balance June of the following year). The PM never withholds the cedolare. Listing it in the monthly statement helps the owner not be caught off guard in June.
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 cedolare active)
- 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.
Start the free trial