Free template · XLSX
Free income, expense and OTA commission spreadsheet for vacation rentals
Record gross booking revenue, OTA commission and other operating expenses on each row. The workbook calculates management net result and commission rate, then summarises the selected month.
Free · no email · 300 rows + monthly summary
Real Planner screens with fictitious demo data.
What's inside
Three sheets: Tracker, Monthly Summary and Instructions. Enter date, property/unit, channel, booking reference, gross revenue, commission and expenses; net result and commission rate are formulas.
- 300 rows
- Automatic net result
- Monthly summary
- Commission rate
Worked example
A €1,000 booking with €150 OTA commission and €80 other expenses leaves a €770 management result and a 15% commission rate.
When the Planner adds value
The sheet solves simple month-end financial control. MAXORI adds booking, unit, calendar, recorded-payment and hospitality-KPI context so the same information does not have to be maintained twice.
Template limits
- This is a management tracker, not tax accounting or guest invoicing.
- It does not connect to banks or OTAs; values are entered manually.
Is it free and email-free?
Yes. The file downloads directly.
Is the net result taxable profit?
No. It is a management result based on the values you enter.
Can I use it for several units?
Yes. Each row includes a property/unit field.
Can I import it into MAXORI?
Not as it is: this tracker records income and expense movements, not bookings (there is no guest or departure date). MAXORI imports bookings with guest, unit, arrival and departure from a CSV file; expenses are recorded in the Planner.
Try MAXORI with your own bookings
Free 14-day trial on the real Planner, no credit card. Add a few bookings and see whether the workflow fits your operation.