Airbnb Profit and Loss Worksheet: A Monthly Operator Template

By Sean Rakidzich.

Published August 15, 2026.

TL;DR

An Airbnb profit and loss worksheet is an internal planning tool. It lets you subtract your operator-entered expenses from your operator-entered revenue for a chosen month. The result is a surplus or deficit for that period only.

This worksheet is not a tax return, an audited statement, or a filing document. It does not provide tax, filing, legal, valuation, or performance conclusions. It gives you a clear monthly number you can act on as an operator.

Educational scope: This worksheet uses operator-entered assumptions for internal planning only. It does not determine tax, accounting, legal, valuation, investment-return, or performance outcomes.

What This Worksheet Is and Is Not

A profit and loss statement measures net income or loss over a defined period. The core formula is: revenues minus expenses equals net income or loss. That definition comes from the SBA Glossary of Business Financial Terms.

This internal worksheet applies that same arithmetic to your short-term rental records. The result is an internal surplus or deficit. It is not SBA net income, and it is not equivalent to a formal profit and loss statement. This is not a GAAP financial statement. It does not provide audit readiness, tax-return suitability, or financial-statement assurance.

Step 1: Freeze the Reporting Period

Every row in the worksheet must belong to one declared period. Choose a calendar month or a custom date range. Write it at the top of the sheet before entering any number. A period like "July 1 through July 31" keeps revenue and expense rows aligned. Mixing periods produces a surplus or deficit figure that cannot be compared across months.

Apply the same period to every property if you run more than one listing. Consistent period labels let you add property rows into a portfolio total without double-counting or gaps.

Step 2: Collect Airbnb Exports and Separate Records

Airbnb Report Fields

Airbnb monthly and annual earnings reports can show gross earnings, adjustments, host service fees, withheld taxes, total net pay, nights booked, and average stay length. Reports and CSV exports can be filtered by listing, payout method, and date range. CSV exports can include earnings, host service fees, optional cleaning fees, gross earnings, and withheld taxes. Those details come from the Airbnb Help: Earnings and Payouts page.

Before you use any Airbnb field as a worksheet input, classify it. Each field is one of four things relative to your own records:

• Embedded: The Airbnb figure already includes another item you might count separately.
• Separate: The Airbnb figure and your own record cover different items with no overlap.
• Excluded: The operator's actual record confirms the field is outside the selected worksheet input.
• Unknown: You have not yet confirmed whether the Airbnb figure overlaps your own record.

Do not add or subtract any field whose status is still unknown. Resolve the relationship from the operator's actual export or payout record first. Then check separate bank and vendor records for additional items that belong in the declared worksheet scope.

Off-Platform Records

The Airbnb earnings report guide covers the listed Airbnb fields. Check separate bank, receipt, vendor, and operator records for any additional items in your declared worksheet scope. For a consistent label set across properties, see the Airbnb chart of accounts guide.

Step 3: Define Revenue Labels

Choose one revenue label for each income type and use it every month. Common operator-defined labels include nightly revenue, cleaning-fee revenue, and other platform revenue. The label set is yours to define. What matters is that each label maps to exactly one source field or record, with no overlap between labels.

Gross earnings and total net pay are source-labeled fields listed in the Airbnb earnings report guide. The source does not define their composition relationship for this worksheet. Use the operator's actual export or payout record to classify each field as embedded, separate, excluded, or unknown. Do not add either field while that relationship remains unknown.

If you collect revenue from other booking channels, add a separate label for each channel. Do not combine multi-channel revenue into a single row unless you have confirmed there is no overlap with the Airbnb export figures.

Step 4: Define Operating-Cost Labels

Operating costs are the expenses you pay to run the property during the reporting period. Define a label for each cost type. Examples of operator-defined cost labels include platform fees, cleaning costs, supplies, maintenance, utilities, and property management fees.

Host service fees are among the fields listed in the Airbnb earnings report guide. The source does not establish whether that field is embedded in or separate from another selected input. Classify the relationship from the operator's actual export or payout record. If it is unknown, leave the fee outside both revenue and expense totals until it is resolved.

Lines you have not yet classified belong outside this worksheet until you define their scope from your own records. Do not leave unresolved lines in the totals.

For a deeper look at how cash moves through the period, the Airbnb cash flow spreadsheet guide covers timing differences between earned revenue and received payouts.

Step 5: Reconcile Property and Portfolio Views

Single-Property View

For one property, the worksheet has three sections: a revenue block, an expense block, and a result row. The result row holds the internal surplus or deficit for the period. The formula is: total revenue minus total expenses equals internal surplus or deficit. A positive result is a surplus. A zero result means revenue and expenses are equal for the period. A negative result is a deficit.

If total expenses are zero, the result equals total revenue. If total revenue is zero, the result is a negative number equal to total expenses. If both are zero, the result is zero and the worksheet contains no useful information for the period.

Portfolio View

A portfolio view adds the surplus or deficit rows from each property. Every property must use the same declared period and the same label set, or an explicit mapping table that converts each property's labels to a common set. A mapping table lists each property's label in one column and the portfolio label it maps to in the next. Without a consistent label set or a mapping table, the portfolio total mixes unlike categories and the result is not comparable across properties.

The portfolio total is still an internal figure. It does not represent audited or certified performance across properties.

If you share results with a property owner, the Airbnb owner statement template guide covers how to present period summaries in a format suited for owner review.

Worked Hypothetical: One Property, July 2026

The following example is hypothetical. Period: July 1 through July 31, 2026. Units: US dollars. All figures are operator-entered assumptions, not actual results.

Assume an operator enters these revenue rows:

• Nightly revenue (from Airbnb gross earnings field, confirmed separate from cleaning fees): $2,400.00
• Cleaning-fee revenue (from Airbnb optional cleaning-fee field, confirmed separate from nightly revenue): $300.00

Total revenue: $2,400.00 + $300.00 = $2,700.00

Assume the operator enters these expense rows:

• Host service fee (from Airbnb CSV, confirmed separate from gross earnings input): $288.00
• Cleaning cost (paid to cleaner, off-platform, confirmed separate from cleaning-fee revenue row): $240.00
• Supplies (receipts, off-platform): $45.00
• Utilities (bank statement, off-platform): $120.00

Total expenses: $288.00 + $240.00 + $45.00 + $120.00 = $693.00

Internal surplus or deficit: $2,700.00 minus $693.00 = $2,007.00 surplus for July 2026.

Assumptions: The operator confirmed that gross earnings and cleaning-fee revenue are separate fields in the export with no overlap. The host service fee is separate from the gross earnings input. No other channels contributed revenue in this period. No lines remain in unknown status. Rounding: none applied; all figures are exact as entered.

A different operator with different inputs, a different period, or unresolved field classifications would produce a different result. This example does not represent a typical or expected outcome.

Month-Close Checklist for July 2026

1. Confirm the reporting period dates at the top of the worksheet.
2. Download the Airbnb CSV export filtered to the same date range and listing.
3. Classify each Airbnb field as embedded, separate, excluded, or unknown before entering it.
4. Resolve all unknown-status lines before finalizing totals.
5. Enter off-platform costs from bank statements and receipts.
6. Verify that no label appears in both the revenue block and the expense block for the same item.
7. Calculate the result row: total revenue minus total expenses.
8. Note any lines left outside the worksheet and the reason each was excluded.
9. Save the export file and supporting records alongside the worksheet for the same period.

Common Errors

Using Total Net Pay and Gross Earnings Together

Total net pay and gross earnings are fields listed in the Airbnb earnings report guide, but that source does not define their composition relationship for this worksheet. Classify each from the operator's actual export or payout record as embedded, separate, excluded, or unknown. Do not add or subtract either field while the relationship is unknown.

Mixing Periods Across Properties

A portfolio total is only meaningful when every property row covers the same declared period. A July surplus from one property added to an August surplus from another produces a number that does not represent either month.

Leaving Unknown-Status Lines in the Totals

An unknown-status line may overlap another row, or it may be a gap. Either way, including it before resolving its status can overstate or understate the result. Move unresolved lines outside the totals until the operator's records confirm their classification.

Treating the Internal Surplus or Deficit as a Formal Financial Result

The worksheet result is an internal planning figure based on operator-entered assumptions. It does not equal audited net income, taxable income, or any regulated financial measure.

FAQ

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