Airbnb Expense Spreadsheet Template: Categories, Monthly P&L and Formulas

What goes in an Airbnb expense spreadsheet?

Three tabs cover it: a transaction log (one row per expense or payout), a category list, and a monthly summary that totals the log. Everything else is a report built on those three.

The column set for the log is short on purpose. Short logs get filled in; long ones get abandoned in March.

I build spreadsheet math, not tax returns; I am not a host or an accountant, and this guide is not tax or financial advice.

Airbnb expense categories: per-stay vs fixed

Per-stay costs happen because a guest booked; fixed costs happen because you own or lease the unit. Tag every category with one of the two and the spreadsheet can tell you your break-even occupancy.

Keep furnishing and big one-off purchases in their own "Startup / capital" category. They are cash out, but they do not belong in one month's operating cost; a tax adviser will tell you how they are depreciated.

Try it: see what your expenses do to profit

Enter your nightly rate, occupancy, per-stay costs and fixed monthly total. The calculator below returns yearly profit and break-even occupancy using the same formula as the full-year example.

Here is the example condo for a full year. Every input is an assumption; replace it with your own numbers.

The condo nets $3,298.77 a year and breaks even at 50.94% occupancy. Per-stay costs total $7,790.56 across 84.68 stays, which is why short stays with a low cleaning fee drag the number down. If you are still deciding whether the listing is worth it at all, the Airbnb profit calculator spreadsheet guide focuses on that projection; this page is about tracking what actually happens.

Monthly Airbnb profit and loss layout

A monthly P&L for one listing is revenue, minus per-stay costs and fees (the "direct" costs), equals gross profit, minus fixed costs, equals operating profit. Build one column per month and a year-to-date column at the end.

Example month (assumed): 18 booked nights at $140 plus 7 stays at a $75 cleaning fee is $2,520 + $525 = $3,045. Direct costs are the 3% fee of $91.35 plus 7 x ($80 + $12) = $644, total $735.35.

Gross margin is 75.85%, which looks healthy, but after $1,985.00 of fixed costs the month keeps $324.65, an operating margin of 10.66%. That gap is the reason to separate the two groups: a month with 4 fewer nights would cut revenue far more than it cuts costs.

One accuracy note. This layout uses the whole mortgage payment, so it is a cash view of profit. For a tax view, replace the payment with the interest portion (from your lender statement) and add depreciation, which your tax preparer calculates.

How to track Airbnb expenses step by step

Log every transaction the week it happens, tag it, and let formulas do the monthly totals. A weekly 10-minute habit beats a year-end shoebox.

1. Create the category list on its own tab, each with its cost group.
2. Add a drop-down (Data validation) on the log's Category column that points at that list.
3. Download the payout report from your Airbnb earnings page each month and paste payouts as income rows.
4. Enter cleaner invoices and supply receipts with the booking code where you can.
5. Let the summary tab total each category by month with SUMIFS.
6. Compare actual occupancy and profit to your plan each month.

What expenses can I write off for an Airbnb?

The IRS says rental expenses "may include mortgage interest, real estate taxes, casualty losses, maintenance, utilities, insurance, and depreciation," generally reported on Schedule E (IRS Topic 415, Renting residential and vacation property). Name your categories so they map cleanly to those lines.

Two rules from the same IRS page change what you can deduct, so your spreadsheet should capture the data for them:

• Personal use days. You are treated as using a unit as a residence if personal days exceed the greater of 14 days or 10% of days rented at a fair price. Add a "Personal use" column or tab so you can count those days.
• Rented fewer than 15 days. If you use the unit as a residence and rent it for fewer than 15 days, you do not report the rental income or deduct rental expenses.
• Mixed use. Expenses are generally divided between rental and personal use by number of days, so record nights rented and nights used per month.

Tax treatment of short-term rentals has more wrinkles than this. Take the spreadsheet to a tax professional; it will save them time and you fees.

Expense spreadsheet vs accounting app vs a paid template

A free spreadsheet suits one or two listings and an owner who wants to see every number. Accounting and property apps suit hosts who want bank feeds and many units. A paid template sits between: the layout is done, the formulas are yours to inspect.

The Airbnb expense and profit spreadsheet template is $14.99 one-time and works in Excel and Google Sheets. It covers nightly rate, occupancy and nights, all recurring costs (cleaning, fees, utilities, restocking) and returns net profit, margin and break-even occupancy. It is also in the $49 Complete Toolkit of seven templates.

Common mistakes in Airbnb spreadsheets

The most expensive mistake is a cleaning fee set below the real cost of a turnover. In the example the guest pays $75.00, the host keeps $72.75 after the 3% fee, and the clean plus supplies costs $92: a $19.25 loss on every stay.

• Recording payouts, not bookings. Payouts are after fees. Log the gross and the fee separately or your fee line disappears.
• Mixing principal into expenses for tax. Fine for a cash view, wrong for a tax view.
• Free-typed categories. Use a drop-down so SUMIFS finds every row.
• No reserve line. Linens, furniture and appliances wear out. A small monthly reserve keeps a bad month from looking like a surprise.

If you are still choosing between hosting and a traditional lease, run the Airbnb vs long-term rental calculator. For an unfurnished rental, the rental property analysis spreadsheet guide covers cap rate and cash flow. When you are ready to stop building from scratch, the Airbnb spreadsheet template has the structure in place.

Step-by-step: Airbnb Expense Spreadsheet Template: Categories, Monthly P&L and Formulas

1. Set up a category list. List every income and expense category on its own tab and tag each expense as per-stay or fixed.
2. Create the transaction log. Add columns for date, type, category, cost group, amount, booking code and receipt link. Put a drop-down on category.
3. Enter bookings and costs weekly. Paste gross booking revenue and platform fees from your earnings report, then add cleaner invoices and supply receipts.
4. Total by month with SUMIFS. On a summary tab, total each category by month so revenue, per-stay costs and fixed costs sit in columns.
5. Compute monthly profit. Revenue minus per-stay costs and fees gives gross profit; subtract fixed costs for operating profit.
6. Review against plan. Each month compare occupancy and profit to your projection and adjust price or cleaning fee if per-stay costs outrun them.

Related guides