A guest arrives on 30 October and leaves on 4 November. The stay occupies five nights: two in October and three in November. Allocating the entire booking to October answers a different question from allocating each night to the month when it was occupied.
Neither the reservation date nor the bank transfer date tells you how many nights were occupied in each month. Start by deciding whether you want a booking-cohort report or an operating calendar view. The example below explains the latter.
Apply this method to your own records: explore the Airbnb operating profit calculator.
A clear definition of the metric or operating question.
A calculation you can reproduce with your own data.
The limits that prevent the number being misread.
Count the occupied nights, excluding checkout
The nights are 30 and 31 October, then 1, 2 and 3 November. Checkout on 4 November is not an additional occupied night. Allocate the dates first and check that the parts add up to the original stay.
In this example the rate is €120 for every night, so total accommodation revenue is €600. October receives €240 and November €360. Cleaning income is not included in this nightly revenue calculation.
| Period | Occupied nights | Accommodation revenue |
|---|---|---|
| October | 2 | €240 |
| November | 3 | €360 |
| Total | 5 | €600 |
Use the actual nightly prices when they differ
An equal split is only accurate when the rate is constant, or when you deliberately adopt a proportional approximation and disclose it. If October nights cost €150 each and November nights €100 each, the same five-night stay allocates €300 to each month.
Keep the total after any accommodation discount equal to the booking’s accommodation amount. Where a discount is only available at booking level, document how you spread it across nights and reconcile the rounded allocations to the original total.
Handle one-off charges and costs separately
A single cleaning fee is not five separate fees. Decide how your operating analysis allocates it, and apply that rule once. The cleaning work itself may happen at checkout; preserve that service date in the expense record.
Apply the same discipline to platform charges: if you allocate a booking-level deduction across periods, the allocated parts must add up to the recorded deduction. Do not infer a current fee rate for an older reservation.
Check the workbook convention before changing records
Read the calculator user guide and inspect the month assigned to the reservation. Do not assume that a spreadsheet automatically performs nightly revenue allocation just because it accepts arrival and departure dates.
If your analysis needs a different convention, keep a separate reconciliation schedule. Duplicating a complete reservation as two rows can double cleaning income, fees or booking counts. Any split must preserve the original totals and its reference.
Compare reports only after aligning their basis
Before explaining a month-on-month revenue change, ask whether the reporting method changed. A long stay beginning near month-end can move a large amount between periods without any change in underlying demand.
Record both the reporting convention and the payout date, but use each for its own purpose. Follow the monthly close checklist to keep the operating view traceable.
Explore related questions
Clear answers, without the jargon
Does checkout count as an occupied night?
Not for the departing stay. A stay from 30 October to 4 November occupies five nights, ending with 3 November.
Can I simply divide revenue by the number of nights?
Yes for a constant nightly rate. When prices vary, actual nightly amounts give a more faithful allocation; disclose any proportional approximation.
Should I split the cleaning fee equally?
There is no universal operating convention. Choose and document one, preserving the original charge and keeping accommodation revenue distinct.
Is this a tax reporting rule?
No. It is a method for analysing operations by calendar month. Statutory reporting follows the rules applicable to your business.
How this guide was prepared
Each example starts with recorded accommodation revenue, completed stays and operating costs. Calculations state their inputs, cleaning income is kept separate where comparability requires it, and no external income benchmark is presented as an expected result.
Hostpartner is an operational analysis tool. It does not calculate VAT, taxes, depreciation, financing or mortgage principal and does not connect to booking platforms, banks or PMS systems.
Build a monthly view you can explain.
Record your stays and expenses in Hostpartner. Use the guide to understand the workbook’s reporting rules before comparing your results.
- Built for 1–7 properties
- Excel (.xlsx)
- No platform connection required
What the Hostpartner calculator measures and which inputs you need
ADR
Occupancy