Vacation rental owner statement template
A monthly owner statement shows a rental property's income, fees, expenses and the payout or balance due to its owner. This free Excel workbook brings those figures together in EUR, for one owner, property and reporting month at a time.
What is an owner statement?
It is the report a vacation rental manager prepares for a property owner to explain the month's income and deductions. An owner statement is an operational report, not a guest invoice or a tax return. Reconcile it with bookings, payment records and receipts before sharing it.
What's inside
- Owner, property and month selection
- Income, refunds, platform fees and commission
- Printable payout statement with example rows
How to use it
- Download the workbook and read its instructions.
- On Statement, enter matching owner and property codes and the first day of the reporting month.
- Enter positive booking amounts and owner-chargeable expenses in their ledgers using the same codes and posting dates. Use the yellow inputs and keep formula cells unchanged.
- Leave the workbook in LIVE mode; sample rows are excluded.
- Enter any opening balance and prior payments, then check the payout against booking records, receipts and the bank transfer.
Example owner payout in EUR
This fictional example uses the workbook's commission rule: 20% of accommodation income less accommodation refunds. The percentage is an example, not a suggested fee.
- Accommodation income
- €1,000
- Cleaning income
- €60
- Platform fees
- -€30
- Management commission
- -€200
- Owner-chargeable expense
- -€50
- Owner payout
- €780
€1,000 + €60 - €30 - €200 - €50 = €780. This assumes no refunds, other income, opening balance or prior payments. Do not count platform or management fees again in the expenses ledger.
Using it in Cyprus, Greece and Europe
The English-language workbook uses EUR amounts and can be a starting point for rental managers in Cyprus, Greece and other euro-area markets. It does not include country-specific VAT, withholding, tourist levies, registrations or reporting rules. It is not an AADE filing tool or a Cyprus tax form. Ask your accountant how those items belong in your records; this workbook does not calculate them.
Elsewhere in Europe, EUR formatting may not match your operating currency. The workbook does not convert currencies or exchange rates. Check your owner agreement, commission base and posting-month policy before using it.
When a spreadsheet stops being enough
Repeated updates across bookings, property care and owner reporting can become hard to keep aligned. Explore the sample dashboard to see a connected workflow.
Try the live demo ↗When a spreadsheet is no longer enough
For a client, we connected booking records, expenses and owner reporting in a custom system. The client saved more than 30 hours a month on administrative bookkeeping and grew its portfolio by 40% in under a year without adding office staff.
Results from one project, not a promise. Growth occurred alongside the change; it is not attributed to the software alone.
Frequently asked questions
Is this Excel template free to download?
Yes. Download the .xlsx workbook directly without entering an email address or creating an account. It includes instructions and fictional examples.
What does this owner statement template calculate?
It brings accommodation income, cleaning and other income, refunds, platform fees, commission, owner charges, opening balance and prior payments into a monthly payout statement for the selected owner and property.
What is the management commission based on?
The commission is applied to accommodation income less accommodation refunds only. Check this matches your agreed owner terms before using the statement.
Does it split bookings across months or calculate VAT?
No. Income falls in the entered posting month. There is no VAT, tax or withholding calculation; reconcile the statement with your accounting records.
Does sample data affect my real results?
Sample rows are excluded in default LIVE mode. Use LIVE mode for your own records.
Has it been tested in Microsoft Excel?
It is supplied as an Excel .xlsx file and was recalculated and tested in LibreOffice Calc, not native desktop Microsoft Excel. Check it in your spreadsheet app before relying on the results. Formula cells are not locked.