Booking income
The amount earned from stays and host-charged fees before platform-side deductions. This is the starting point, not what necessarily reached the bank.
What the stay earned
A plain-language P&L for small hosts
See what the rental actually kept.
An Airbnb payout tells you what the platform sent. A profit and loss spreadsheet adds the costs paid elsewhere, so booking income, platform fees, operating expenses, and the monthly result sit in one view.
Excel + Google Sheets · up to 5 rentals · no subscription or bank connection
1–5rentals
12monthly views
400booking rows
600expense rows
$49once
Three numbers hosts often mix together.
The confusion usually starts when a booking total, a bank deposit, and profit are treated as the same number. They answer different questions.
Platform payout
The amount sent after host fees, adjustments, taxes withheld, or other platform-side activity. One deposit may also contain several reservations.
What the platform sent
Monthly result
Booking income minus platform fees and the operating expenses you paid elsewhere. It is an organizing view, not a filed tax return.
What was left after recorded costs
Build one month in four passes.
The workbook stays useful when every number has a visible source and the routine is short enough to repeat.
Enter bookings
Use gross booking amounts and exact platform fees from the earnings report.
Match deposits
Compare expected payouts with bank deposits and investigate any difference.
Add expenses
Record cleaning, supplies, utilities, repairs, insurance, software, and other chosen costs.
Read the month
Review the P&L by property without confusing a payout with the final result.
Use each source for the job it can do.
No single platform report contains every cost of running the rental. A clean P&L brings the chosen totals together without hiding where they came from.
| Source | What it can tell you | What it cannot finish alone |
|---|---|---|
| Airbnb earnings report | Gross earnings, adjustments, host service fees, taxes withheld, net pay, listings, and payout methods. | Costs paid outside Airbnb, such as utilities, repairs, supplies, insurance, or other software. |
| Bank statement | The amount and date that actually arrived at the bank. | Which reservations a batched deposit contains or whether the rental was profitable. |
| P&L spreadsheet | A monthly operating view that combines chosen platform totals and off-platform expenses. | Professional judgment, tax filing, depreciation decisions, or repairs to incomplete records. |
| Tax return | The filed treatment based on applicable facts, forms, rules, and professional decisions. | Your day-to-day operating routine or the source trail behind missing numbers. |
Primary source: Airbnb says hosts can download monthly and annual earnings reports plus CSV exports containing gross earnings, adjustments, host service fees, taxes withheld, and net pay. Those fields supply the platform side of the view; expenses paid elsewhere still come from your own records. See Airbnb's download instructions.
What the $49 workbook adds.
StaySums is deliberately between a one-month free template and a multi-year investment forecast. It organizes an operating year for a small host.
Inside StaySums
One Excel workbook that also opens in Google Sheets.
Up to 5 rentalsFull-year tracking400 booking rows600 expense rowsMonthly P&LDashboardTax summaryMileage logPayout checksSetup guide
It fits if you want…
- manual control instead of bank feeds;
- one to five rentals in a full-year file;
- Excel or Google Sheets;
- no recurring subscription;
- privacy from an online bookkeeping account.
Choose something else for…
- automatic imports or receipt scanning;
- more than five rentals or team workflows;
- multi-year forecasts and valuation;
- cleanup, tax filing, or professional advice.
Common questions.
A monthly P&L is useful only when its scope and limits stay plain.
What should an Airbnb profit and loss spreadsheet include?
At minimum, keep booking income, platform or host fees, adjustments, operating expenses, and a monthly result visible. Keep each property and month identifiable, and preserve the source records behind the totals.
Is an Airbnb payout the same as profit?
No. A payout is the amount the platform sends after platform-side fees and adjustments. Profit also depends on operating costs paid elsewhere, such as cleaning, supplies, utilities, insurance, repairs, and software.
Does Airbnb provide a profit and loss statement?
Airbnb provides earnings reports and CSV exports with platform-side details such as gross earnings, adjustments, host service fees, taxes withheld, and net pay. You still add expenses paid outside the platform to see a broader operating result.
Can I use StaySums in Google Sheets?
Yes. StaySums is delivered as an Excel workbook and is designed to open in Excel or Google Sheets. It does not require macros, an online StaySums account, or a bank connection.
Is the StaySums P&L a tax return?
No. It is an organizing and operating view. It does not file a return or decide tax, legal, accounting, or financial treatment. Verify those decisions with a qualified professional.