How to Track Airbnb Income and Expenses in a Spreadsheet

Your Airbnb dashboard tells you what you earned. It does not tell you what you made. It shows gross booking revenue with the cleaning fee bundled in, before you paid the cleaner, before the mortgage, before the $310 HOA bill and the STR insurance premium that costs three times a normal homeowner’s policy. Ask a host what their place brings in and you will get the gross number, because it is the only one anybody hands them.

This guide builds the other number. It walks through a spreadsheet that takes one row per booking and one row per expense and turns them into occupancy rate, ADR, RevPAR, net profit and a Schedule E-ready tax summary — per property and across a portfolio.

Everything below runs on one worked example so you can see the arithmetic. The figures are assumptions I have chosen to be plausible for a two-bedroom coastal condo, not national averages. Yours will differ. The structure will not.

The example property

Harbor Loft — a two-bedroom condo listed on Airbnb and VRBO. Over a full calendar year:

Hold on to those numbers. They come back in every section.

Start here: the 10-minute setup (copy-ready)

If you want to be tracking by tonight, do this first and read the rest for the reasoning. Create three tabs — Bookings, Expenses and Dashboard — and paste these header rows into row 1.

Bookings tab (columns A–K):

Booking ID | Property | Platform | Check-in | Check-out | Nights | Nightly rate | Room revenue | Cleaning fee | Commission | Net payout

Expenses tab (columns A–I):

Date | Property | Category | Description | Vendor | Amount | Paid with | Receipt saved? | Deductible?

Then enter these formulas in row 2 of the Bookings tab and fill down:

Column Formula (row 2) What it does
Nights (F) =E2-D2 Counts nights from the two dates
Room revenue (H) =F2*G2 Nightly rate × nights
Net payout (K) =H2+I2-J2 Room revenue + cleaning fee − commission

And these on the Dashboard tab, with the property name in cell B1 and the nights available that year in B2:

Metric Formula Notes
Nights booked =SUMIF(Bookings!B:B,B1,Bookings!F:F) Total nights for that property
Room revenue =SUMIF(Bookings!B:B,B1,Bookings!H:H) Excludes cleaning fees
Net payout =SUMIF(Bookings!B:B,B1,Bookings!K:K) What actually reached your bank
Total expenses =SUMIF(Expenses!B:B,B1,Expenses!F:F) Same property name, same spelling
Net profit =B5-B6 Payout minus expenses
Occupancy =B3/B2 Nights booked ÷ nights available
ADR =B4/B3 Room revenue ÷ nights booked
RevPAR =B4/B2 Room revenue ÷ nights available

Two cautions. First, SUMIF matches the property name exactly, so “Harbor Loft” and “Harbor loft ” (trailing space) are different properties — make the Property column a dropdown on both tabs. Second, if you ever copy a booking’s cleaning fee into the nightly rate, you will quietly inflate ADR; keep it in its own column.

Layer 1: the booking log

This is the spine of the whole spreadsheet. One row per reservation, entered when the booking is confirmed. Nine columns do all the work:

Column Entered or calculated
Booking ID entered
Property entered (dropdown)
Platform entered (dropdown)
Check-in entered
Check-out entered
Nights = Check-out − Check-in
Nightly rate entered
Gross room revenue = Nightly rate × Nights
Cleaning fee collected entered
Platform commission entered from the payout report
Net payout = Gross + Cleaning fee − Commission

Two habits make this log worth keeping.

Enter check-in and check-out as real dates and let the sheet count the nights. Typing “4” in a nights column feels faster and it is how the log rots — one fat-fingered number and every metric downstream is wrong with no error message to warn you. A date subtraction cannot silently disagree with the calendar.

Keep the cleaning fee in its own column, never folded into the nightly rate. The cleaning fee is not revenue in any meaningful sense. It is money you collect on a cleaner’s behalf and pass through, and the moment it is mixed into your room revenue your ADR is inflated and every performance comparison you make is meaningless. It belongs on the row, and it belongs in its own column.

For Harbor Loft, the year’s booking log rolls up to:

Line Amount
Room revenue (168 nights × $190) $31,920
Cleaning fees collected (42 × $110) $4,620
Gross collected from guests $36,540
Platform commission (3%) −$1,096
Net payout to your bank $35,444

That $35,444 is the number the platform actually deposits. It is not profit. It has not met a single bill yet.

Layer 2: the expense log, categorised the way the IRS wants it

One row per transaction: date, property, category, description, vendor, amount, payment method, receipt saved, deductible yes/no.

The category column is the one that saves you money, and the trick is to pick your categories now to match the lines on the tax form you will eventually file, rather than inventing your own and re-sorting a year of transactions the week before the deadline. For most hosts that form is Schedule E, whose expense lines include advertising, auto and travel, cleaning and maintenance, commissions, insurance, legal and professional fees, management fees, mortgage interest, repairs, supplies, taxes, utilities and depreciation. (Whether your rental belongs on Schedule E or on Schedule C is a real question with a real cost attached — it is worth ten minutes of your time.)

Harbor Loft’s year:

Category Amount
Cleaning & turnover (42 × $95) $3,990
Supplies & consumables $1,180
Utilities (electric, water, gas) $2,040
Internet & streaming $1,140
Repairs & maintenance $1,865
STR insurance $1,704
Property taxes $2,580
HOA fees $3,720
Mortgage interest $9,640
Listing tools & software $456
Advertising / direct-booking site $390
Accounting & licences $520
Total expenses $29,225

Note what is and is not in that table. Mortgage interest is there; the principal portion of the payment is not, because paying down principal is not an expense — it is you buying more of your own building. Depreciation is not there either, and for most hosts it is the single largest deduction on the return. It does not belong in a cash-flow view but it absolutely belongs on the tax return, and working out the depreciable basis of a property is a conversation with a tax professional, not a spreadsheet formula.

Layer 3: the number nobody quotes

Net payout $35,444
Total expenses −$29,225
Net profit (before depreciation) $6,219
Profit margin 17.6%
Net profit per booked night $37

Gross collected, $36,540. Real profit, $6,219. Seventeen percent of the headline number.

That gap is not a sign the property is bad — a condo generating six thousand dollars of cash profit while a tenant pays down the mortgage is a perfectly reasonable asset. The point is that the gap is thirty thousand dollars wide, and a host who only ever sees the top line cannot tell the difference between a property clearing $6,000 and one quietly losing $2,000. Both of them look like $36,540 on the app.

This is also why per-booking maths matters more than most hosts think. A single four-night stay at $180 a night looks like an $805 payout, but after direct costs and its share of the fixed costs it nets $45 — and the break-even nightly rate for that property turns out to be $168, which is uncomfortably close to what a lot of hosts discount to in the shoulder season.

Stress test: what a different fee structure does to the same year

The 3% commission in this example is Airbnb’s split-fee host charge. Airbnb’s own host resource centre describes a second structure — a single fee deducted from the host’s price, typically 14 to 16% — and says it is used for most hosts on property-management or channel-management software. To see why you should read your own payout line rather than assume, here is Harbor Loft’s identical year with only the fee changed (15.5% applied to the same $36,540 collected; this is an illustration of sensitivity, not a claim about what any particular host pays):

Split fee (3%) Single fee (15.5%)
Gross collected $36,540 $36,540
Platform fee −$1,096 −$5,664
Net payout $35,444 $30,876
Total expenses −$29,225 −$29,225
Net profit $6,219 $1,651
Profit per booked night $37 $10

Same property, same guests, same expenses — and profit falls by roughly three-quarters. In practice a host on a single fee would set a higher nightly price to compensate, which is exactly why the commission belongs in its own column of the booking log, read from the payout report, rather than assumed. If your fee structure ever changes, the sheet shows the damage in the first month instead of the first tax season.

Layer 4: the dashboard

Three logs are data. The dashboard is where they become decisions. Six metrics, calculated per property and for the portfolio — the same structure you would use to track multiple rental properties in one place on the long-term rental side:

Metric Formula Harbor Loft
Occupancy rate Nights booked ÷ nights available 47.9%
ADR Room revenue ÷ nights booked $190.00
RevPAR Room revenue ÷ nights available $90.94
Net profit Payout − expenses $6,219
Profit margin Net profit ÷ payout 17.6%
Avg cleaning cost Total cleaning ÷ turnovers $95.00

Occupancy here uses 351 available nights — 365 minus the 14 the owner blocked. That choice matters and it is where most host spreadsheets go wrong: if you count nights you deliberately took off the market as vacancy, you are penalising yourself for using your own condo, and the metric stops being comparable year to year. Pick a denominator, write it down, never change it mid-year.

ADR and RevPAR are the pair that decides where your next dollar goes, and they routinely disagree. A property with a $260 ADR at 48% occupancy earns less per available night than one with a $165 ADR at 81% — $124.80 against $133.65, a difference of $3,230 a year on a single unit. If you only track ADR you will conclude the expensive property is your winner and price the other one up until it stops selling. The full arithmetic, and how to pick the right denominator, is here.

Build the dashboard with SUMIF and COUNTIF against the property name so it recalculates itself. Revenue for a property is SUMIF(BookingLog[Property], "Harbor Loft", BookingLog[GrossRevenue]); turnovers are COUNTIF; every KPI is a ratio of two of those. Nothing gets typed twice, and adding a fourth property means adding a column, not rebuilding the sheet.

Layer 5: month by month, because the annual average lies

An annual occupancy figure of 47.9% describes no month that actually happened. Harbor Loft’s July ran 27 booked nights at a $268 ADR — a RevPAR of $233. Its January ran six nights at $150, a RevPAR of $29. Eight times the earning power in one month versus the other, and the average tells you about neither.

Here is Harbor Loft’s year as the grid would show it (a worked allocation of the year’s 168 nights and $31,920 room revenue across months, with the 14 owner-blocked nights taken in March, September and November):

Month Nights booked Nights available Occupancy ADR Room revenue RevPAR
Jan 6 31 19% $150 $900 $29
Feb 8 28 29% $145 $1,160 $41
Mar 11 27 41% $146 $1,606 $59
Apr 13 30 43% $151 $1,963 $65
May 15 31 48% $160 $2,400 $77
Jun 20 30 67% $182 $3,640 $121
Jul 27 31 87% $268 $7,236 $233
Aug 25 31 81% $238 $5,950 $192
Sep 15 25 60% $175 $2,625 $105
Oct 12 31 39% $160 $1,920 $62
Nov 8 25 32% $140 $1,120 $45
Dec 8 31 26% $175 $1,400 $45
Year 168 351 47.9% $190 $31,920 $90.94

July and August together bring in $13,186 — 41% of the year’s room revenue from 17% of the calendar days. The monthly formula is a SUMIFS with two conditions, property and month: =SUMIFS(Bookings!H:H,Bookings!B:B,"Harbor Loft",Bookings!D:D,">="&DATE(2026,7,1),Bookings!D:D,"<"&DATE(2026,8,1)). It assigns each booking to the month it checks in, which is a simplification — a stay that spans two months is counted wholly in the first — but it is consistent, and consistency is what makes month-over-month comparison honest.

So the P&L grid runs categories down the side and months across the top. It answers the questions the annual number cannot: which months carry the property, which months you should stop discounting into and simply block for maintenance, when the insurance and tax bills land relative to when the money arrives, and how much cash you need to hold in January to survive to April.

Once you have two years of that grid side by side, you can price the coming season off your own history instead of guessing — which is the whole basis of setting nightly rates by season without eyeballing it.

Layer 6: the operational tabs that protect the revenue

Two more logs earn their place, because both of them protect money the first four layers are only measuring.

The turnover schedule. One row per checkout: date, property, crew, fee, and the next check-in date. One calculated column — hours between checkout and the next arrival — and a conditional format that turns the cell red under four hours. Every host eventually accepts a same-day turn they should have blocked, and finds out at 3pm when the cleaner texts. A red cell on a calendar is cheaper than a one-star review about dirty towels.

The pricing log. Your rate and a competitor’s rate for the same date range, plus the occupancy you actually achieved in that window. This is the only way to build the history that makes next year’s pricing a calculation rather than a guess, and it takes about two minutes a month to maintain.

Seven mistakes that make an Airbnb spreadsheet useless

  1. Tracking the payout instead of the booking. The payout arrives days after checkout and sometimes bundles several reservations. A log built from deposits cannot compute occupancy.
  2. Folding the cleaning fee into the nightly rate. It inflates ADR and RevPAR and makes seasons incomparable.
  3. Counting owner-blocked nights as vacancy. It makes a property look worse for being used by its owner and breaks year-over-year comparison.
  4. Treating the mortgage payment as an expense. Interest is; principal is not. Mixing them understates profit and misstates what the tax return will show.
  5. Typing nights instead of calculating them. One fat-fingered number corrupts every metric with no warning.
  6. Assuming the commission percentage. Read it off a payout report; it differs by fee structure, as the stress test above shows.
  7. Keeping one file per property. You lose the portfolio view and the cross-property RevPAR comparison that tells you where to spend next.

Setting it up so you still use it in November

Three rules, and they are the difference between a live sheet and an abandoned one.

Log the booking at confirmation, the expense within the week. Confirmed bookings show you a filling calendar; expenses logged while you still recognise the charge are deductions you will actually claim.

Reconcile to the payout report monthly. Total the net payout column for the month and compare it to what the platform says it sent. When they disagree it is almost always a resolution adjustment, a refunded booking or a commission rate you assumed instead of read — all things you want to find in a month, not in April.

Never let a booking exist only in the platform’s calendar. Direct bookings, a friend of a friend, the week your brother-in-law paid cash: if it is not in the log, your occupancy is understated, your ADR is wrong, and your tax return is incomplete.

Putting it together

The whole system is one loop. Log every booking and every expense against a property → let the sheet compute occupancy, ADR, RevPAR and true net profit → read the monthly grid to see which season is carrying you → price and staff next year off that instead of a feeling. The tax summary falls out of the same data for free, because you categorised as you went.

You can build all of it from the tables above — a booking log with a net payout formula, a Schedule E-aligned expense log, a SUMIF dashboard and a monthly P&L grid. If you would rather start with it already built and formula-driven, that is what our host dashboard does.

Frequently Asked Questions

What should an Airbnb income and expense spreadsheet actually track?

Five things, in this order — a booking log with one row per reservation (dates, nights, nightly rate, cleaning fee, platform commission, net payout), an expense log with one row per transaction tagged to a property and an IRS Schedule E category, a property table holding the fixed monthly costs, a dashboard that turns those logs into occupancy rate, ADR, RevPAR, net profit and margin, and a month-by-month P&L. Everything else is optional. Without the booking log you cannot compute a single performance metric, because every one of them is revenue divided by nights.

Why is my Airbnb payout so different from my gross booking revenue?

Because three things come out between the two. The guest's total includes your cleaning fee, which is money you collect and then immediately hand to a cleaner. The platform deducts its host commission before it pays you. And the payout still contains no allowance for utilities, supplies, insurance, taxes, HOA fees or your mortgage. In the worked example in this guide the property collects $36,540 in a year and clears $6,219 of net profit — 17% of the number the host would quote at a dinner party.

Should I use one spreadsheet for multiple Airbnb properties or one per property?

One workbook, with a property column on every row of the booking log and the expense log. Splitting into separate files means you can never see portfolio totals, you duplicate every formula change, and you have no way to compare properties on RevPAR — which is the comparison that tells you where to put your next dollar. Filtering one combined log by property gives you a per-property view whenever you want it, and a portfolio view you could not otherwise build.

How often should I update an Airbnb tracking spreadsheet?

Log bookings when the reservation is confirmed, not when the guest checks out, so future revenue is visible and you can see the calendar filling. Log expenses weekly — a fifteen-minute pass through the card statement while you still remember what each charge was. Reconcile against the platform payout report once a month. The reason to log an expense the week it happens is that a receipt you cannot identify in March is a deduction you will not claim in April.

What are the best columns for an Airbnb income tracker spreadsheet?

For the booking log: booking ID, property, platform, check-in, check-out, nights (calculated), nightly rate, gross room revenue (calculated), cleaning fee collected, platform commission and net payout (calculated). For the expense log: date, property, category, description, vendor, amount, payment method, receipt saved and deductible yes/no. Those two tabs plus a property table are enough to calculate every metric in this guide. The copy-ready header rows and formulas are in the setup section above.

Does the platform commission come off the cleaning fee too?

On Airbnb's split-fee structure the host fee is a percentage of your nightly price plus any fees you add, such as a cleaning fee, according to Airbnb's host resource centre — which is why the worked example applies the 3% to the full $36,540 collected rather than to room revenue alone. Fee structures differ by account and by channel, so read the service-fee line on one of your own payouts and use that percentage, not ours. Hosts on a single-fee structure see a much larger deduction, typically in the 14 to 16% range per Airbnb.

Can I use Google Sheets to track Airbnb income and expenses?

Yes. Everything in this guide uses only date subtraction, SUMIF, SUMIFS, COUNTIF and basic division, all of which work identically in Excel and Google Sheets. Google Sheets adds two conveniences for hosts: a co-host or cleaner can be given edit access to just the turnover tab, and a phone-friendly form can feed new expense rows. The main discipline is the same in either tool — one row per booking, one row per expense, one property column on every row.

Know What Your Short-Term Rental Actually Earns

The Airbnb & Short-Term Rental Host Dashboard — 13 tabs — a booking log that calculates nights, gross revenue and net payout after cleaning fees and platform commission, a 13-category expense tracker that rolls into a Tax Summary laid out as 13 IRS Schedule E expense lines, a portfolio dashboard with occupancy rate, ADR, RevPAR, net profit and margin for up to 5 properties, a cleaning turnover schedule that flags gaps under 4 hours in red, a dynamic pricing log with competitor rates by season, a monthly P&L, a Schedule E tax summary, guest comms and review trackers, a supplies inventory with reorder alerts, and a year-over-year seasonal comparison. 500+ formulas. Works in Microsoft Excel and Google Sheets.

View on Etsy — $19.99