Airbnb Profit Margin Worksheet: See What Your Rental Keeps

By Sean Rakidzich.

Published August 14, 2026.

TL;DR

This worksheet helps you figure out how much money your rental keeps after you subtract costs. You pick a time period, choose your revenue (money in) and costs (money out), and calculate a surplus. Then you divide that surplus by your revenue to get a margin.

The result is an internal measure. It is not tax profit or an investment return. Use it to compare your own periods when the input rules stay the same. This worksheet deliberately avoids external benchmarks.

Hypothetical example: Period = June 2026. Unit = one rental. Currency = US dollars. Revenue base = $4,000 in gross earnings for the period. Embedded deductions in this hypothetical revenue base = none. Separately deducted costs = $200 cleaning supplies + $300 utilities + $500 repairs = $1,000. Included lines = the stated revenue and three stated costs. Excluded lines = host service fee, adjustments, taxes withheld, cleaning fee, and every unlisted revenue or cost line. Surplus = $4,000 − $1,000 = $3,000. Internal margin = $3,000 / $4,000 = 0.75 = 75%.

That 75% belongs only to this hypothetical example. It is not tax profit or an investment return. It shows how the declared inputs produce the example result.

Scope: This educational worksheet is an internal operating measure built from the period, revenue base, and cost lines you select. It is not a tax, accounting, legal, valuation, or investment-return calculation.

Define the Worksheet Boundary

The SBA financial terms glossary explains that a profit and loss statement measures net income or loss over a set period. It gives net income or loss as revenue minus expenses. The glossary also describes gross profit margin as gross profit divided by net sales. Those are general terms only. This worksheet does not use the SBA gross-margin formula. Its ratio is operator-defined.

You pick the start and end dates. Your period can be a month, a quarter, or a year. The key rule: use the same period for both revenue and costs. Do not mix a month of revenue with a year of costs.

Choose your revenue base

Your revenue base can come from an Airbnb earnings report. The report lists gross earnings, adjustments, host service fee, taxes withheld, and total net pay. You choose the starting field for this worksheet. Two example paths follow:

• Gross earnings path: start with the reported gross earnings field. Record each adjustment, host service fee, tax-withheld amount, cleaning fee, and off-platform cost. Mark each line as embedded, separate, excluded, or unknown. Subtract only separate costs.
• Total net pay path: start with the reported total net pay field. This source does not say which other fields are embedded in it. Check each adjustment, fee, tax-withheld amount, cleaning fee, and off-platform cost. Mark each line as embedded, separate, excluded, or unknown. Never subtract one amount twice.

For either path, list the period, currency, and chosen revenue field. Mark every other line as embedded, separate, excluded, or unknown. Do not subtract an unknown line. Check its record first.

Collect Airbnb and Off-Platform Inputs

Your Airbnb report gives you a set of fields. The help article at Airbnb help article 3632 says reports can include: gross earnings, adjustments, host service fee, taxes withheld, total net pay, nights booked, average length of stay. You can break down earnings by listing and payout method. You can also export a CSV that may include an optional cleaning fee.

The Airbnb report does not establish off-platform costs. Record the costs you choose for this worksheet in a separate list. State each amount and period. Examples may include cleaning supplies, utilities, repairs, insurance, or management fees.

Choose Included Cost Lines

List each cost you may use. First mark the line as embedded, separate, excluded, or unknown. Subtract it only when it is a declared separate cost for the same period. Never subtract an embedded or unknown amount.

Possible lines include cleaning services, utilities, repairs, insurance, supplies, and management fees. You choose the lines for this worksheet. That choice is not an accounting or tax label. Keep the same rules when you compare periods.

Calculate Internal Surplus and Margin

Once you have revenue and costs for the same period, do the math.

Internal period surplus = revenue base − total separate costs.

Internal margin = surplus / revenue base (the same revenue number you used for the surplus).

If your revenue base is zero, stop. You cannot divide by zero. The ratio is undefined.

Compare Periods Without False Benchmarks

Compare periods only when the period, revenue choice, and cost rules stay the same. This worksheet deliberately avoids external benchmarks. A changed input rule can change the ratio even when the amounts stay the same. Record each rule change.

Diagnose Numerator and Denominator Changes

If the ratio changes, compare the surplus inputs first. Then compare the revenue inputs. Airbnb lists nights booked and average length of stay as report fields. Those fields do not prove demand, pricing power, listing quality, or the cause of a change. Record the values. Leave the cause unknown unless other evidence supports it.

Hypothetical Example with Unit Checks

Hypothetical example: Period = July 2026. One rental. Currency = US dollars.

• Revenue base = $5,200 in gross earnings for July 2026.
• Embedded deductions in the selected revenue base = none for this hypothetical.
• Separately deducted lines = $780 host service fee + $400 cleaning + $200 electricity + $150 supplies + $500 repair.
• Included lines = the stated revenue and five stated costs. Excluded lines = adjustments, taxes withheld, cleaning fee, and every unlisted revenue or cost line.
• Off-platform costs = $400 + $200 + $150 + $500 = $1,250.
• Total separately deducted costs = $780 + $1,250 = $2,030.
• Surplus = $5,200 − $2,030 = $3,170.
• Internal margin = $3,170 / $5,200 = 0.609615..., rounded to 61%.

Every amount in this example is hypothetical. The percentage is rounded to the nearest whole point.

Common Mistakes

• Mixing paths: subtracting a line without first marking it embedded, separate, excluded, or unknown. Never subtract one amount twice.
• Including costs from a different period. Match dates.
• Assuming the Airbnb report establishes off-platform costs. Record your chosen worksheet costs in a separate list.
• Calling the worksheet margin a tax profit or investment return. It is an operator-defined educational measure.

Operator Checklist

1. Pick a period (example: one month).
2. Open your Airbnb report for that period.
3. Choose a revenue path: gross earnings or total net pay.
4. Write down the revenue number.
5. List each off-platform cost chosen for that period.
6. Add all costs together.
7. Subtract only the declared separate costs to get surplus.
8. Divide surplus by revenue to get margin.
9. Write the margin as a percentage.
10. Keep the list of costs so you can use the same list next period.

FAQ

If you want help applying this worksheet to your operation, Book a strategy session.