Twelve columns, one row per booking or per cost, and a category column that turns tax time into arithmetic instead of archaeology. Below is the whole layout, explained column by column, so you can build it in ten minutes in whatever spreadsheet you already use.
Income rows fill columns one to nine and leave ten and eleven blank. Expense rows fill one, two, ten and eleven and leave the booking columns blank. Everything else follows from that.
One caution worth stating plainly: this is a bookkeeping layout, not tax advice. What is deductible, how income is classified and which local lodging taxes apply are jurisdiction-specific questions for somebody qualified where you are. The sheet's job is to make sure that when you ask them, you have the rows to answer with.
Columns seven and ten together answer whether your cleaning fee covers the changeover — the cleaning fee calculator takes those two numbers directly. Columns six and nine give you the real cost of each channel after commission. Column five gives you your true average stay length, which is the input everyone guesses at when setting a minimum stay.
And columns one and six laid out by month give you the shape of your own season — which weeks carried the year and which ones you subsidised. That is the map seasonal pricing asks you to build, and no external dataset can build it for you, because it is a record of your property rather than an estimate about it.
The one thing this sheet cannot hold is what everyone else was charging on those nights. That is the outside half of the picture: we read asking prices from live listing pages on Booking.com and Agoda when you run a scan, night by night. We never forecast, and nothing we run changes your listing. First city scan free, no card.