Airbnb Income and Expense Tracking: A Simple System

23 Oct 20268 min readBy Md Arif Ahamed

Airbnb income and expense tracking means recording every booking and every cost in one place, so you know your real profit, not just what lands in your bank. The simplest system is a spreadsheet with two logs – bookings and expenses – plus a 30-minute monthly routine to match payouts and receipts.

This guide shows you exactly what to record, which categories to use, how to handle payouts versus gross revenue and platform fees, and how to keep tax-ready records. It ends with a worked example table you can copy.

Why payouts are not your income

Many hosts look at the money that arrives in the bank and call it income. That hides two important numbers:

• Gross booking revenue – what the guest paid you for the stay (nightly price plus fees you charge, such as cleaning). This is the true size of your business.
• Platform fees – the commission the platform keeps before it pays you. This is a real cost and belongs in your expenses.

The payout is what is left: Payout = Gross booking revenue − Platform fees − any adjustments. If you only record payouts, you cannot see how much you pay in commission, and your records may not match the earnings reports platforms issue.

Airbnb fees are a good example. As of 2026, most hosts are on Airbnb’s single-fee structure, where the whole service fee comes out of the host payout. Airbnb’s help centre states that most hosts pay 15.5%, others typically pay 14–16%, and listings in Brazil and Mexico pay 16%; the older split-fee structure (usually 3% for hosts) is being phased out (Airbnb: Airbnb service fees). Check your own rate in your earnings reports, because it can differ by account and booking date. Our OTA commission calculator helps you see what a given rate costs you.

What to record for every booking

Record each booking once, on the day it is confirmed, then update it after check-out. These columns cover what most hosts need:

Taxes collected from guests are usually not your income. If the platform collects and pays them to the tax office, record them for information only. If you collect them yourself, record them separately so you can pay them on time. Rules differ by country and city, so check locally.

What to record for every expense

For each cost, record the date, supplier, description, category, property, amount, tax (such as VAT or GST) if shown, payment method and a receipt link or file name. The receipt reference is the field hosts forget most, and it is the one you need most if you are ever asked to prove a cost.

Short-term rental bookkeeping categories

Use a short, fixed category list. Too many categories make the data hard to read; too few hide where money goes.

If you share costs with your own home (for example, you rent out a room), note the share used for guests. How you split shared costs for tax is a question for a local accountant.

Example: a simple Airbnb spreadsheet

Here is a fictional month for one apartment with three bookings, two from Airbnb at an example 15.5% host fee and one direct booking with an example 3% card processing fee.

The formulas behind it:

• Gross = Accommodation + Cleaning fee (for B-001: $450 + $60 = $510)
• Airbnb fee = Gross × 15.5% (for B-001: $510 × 0.155 = $79.05)
• Payout = Gross − Fee (for B-001: $510 − $79.05 = $430.95)

Now add the month’s expenses (also fictional): cleaning $165, supplies $48, utilities $140, internet $35, software $30. Operating expenses = $418. Then:

• Net operating income = Payout − Operating expenses = $1,304.05 − $418 = $886.05
• Platform fees as a share of gross = $185.95 ÷ $1,490 = 12.5%
• Cleaning fee vs cleaning cost = $180 collected vs $165 spent – the fee covers the cost this month

Rent or mortgage, insurance and other fixed costs should also be included each month (divide annual costs by 12). To test whether your cleaning fee is right, try our Airbnb cleaning fee calculator.

Building this by hand works for one unit. Once you have several units or channels, a ready-made workbook saves time. The Short-Term Rental Spreadsheet Pro has booking and expense logs, a dashboard, occupancy, ADR, RevPAR, channel mix and a tax summary for up to 10 properties in Excel or Google Sheets.

Your monthly bookkeeping routine

Set a fixed date, such as the 3rd of each month, and follow the same steps every time. It usually takes 30–60 minutes for a single property.

1. Download platform reports. On Airbnb, as of 2026, go to Menu > Earnings; you can export a CSV from the Paid or Upcoming tabs, and Airbnb also produces monthly and annual earnings reports showing gross earnings, host service fees, taxes withheld and net pay (Airbnb: View and download earnings). Do the same on other platforms.
2. Update every booking. Mark completed stays, cancellations and refunds. Add any missing bookings.
3. Match payouts to the bank. Tick each payout against your bank statement. Investigate anything that does not match, such as adjustments or resolution payments.
4. Enter all expenses. Go through bank and card statements, and save every receipt in a folder named by month.
5. Check categories. Make sure each expense has one category and one property.
6. Review the numbers. Look at gross revenue, fees, net operating income, occupancy and ADR against last month and the same month last year.
7. Write one action. For example: “Fees were 12.5% of gross; push more repeat guests to book direct” or “Utilities are up; check heating settings.”

Comparing actual numbers with your plan each month is the habit that improves profit. Our budget variance calculator makes that comparison quick, and the homestay income calculator helps you set a realistic monthly target.

Keeping tax-ready records (general guidance)

Tax rules for short-term rentals differ a lot between countries, states and cities, and they change. This section is general record-keeping guidance, not tax advice. Speak to a qualified local accountant about what you must report and what you can claim.

• Keep gross and fees separate. Many tax systems look at gross rental income, with platform fees treated as costs. Recording both makes your records match platform reports.
• Keep platform tax documents. Airbnb provides tax documents in account settings for the countries where it issues them. Download them every year.
• Keep receipts. Store digital copies with dates and supplier names. Many countries require you to keep records for several years; check the period where you live.
• Separate personal and business money. A dedicated bank account or card for your rental makes everything easier.
• Note owner use. Record the nights you or your family use the property, as this can affect tax treatment in some countries.
• Track big purchases separately. Furniture, appliances and renovations are often treated differently from everyday costs.
• Record occupancy taxes. Note whether each platform collected and paid them or whether you must pay them yourself.

Airbnb income and expense tracking checklist

• One booking log with gross, fees, taxes and payout as separate columns
• One expense log with a fixed category list and receipt references
• Property and channel recorded on every line
• Monthly platform report download
• Payouts matched to bank statement
• Fixed costs spread monthly
• Monthly review of profit, fees, occupancy and ADR
• Annual tax documents saved
• Records backed up in the cloud

FAQ

Should I record Airbnb income as gross or payout?

Record both. Gross shows the real size of your business and usually matches platform reports; the payout is what you can match to your bank. The difference is the platform fee, which you record as a cost.

How often should I update my Airbnb spreadsheet?

Add bookings when they are confirmed and expenses weekly if you can. Do a full check once a month.

Do I need accounting software?

Not always. A well-built spreadsheet works for most hosts with one to ten units. Larger operations, or hosts with an accountant who prefers a specific system, may benefit from software.

Which month does a booking belong to?

For management reports, most hosts count income in the month the nights are stayed. For tax, the rule depends on your country and accounting method, so ask your accountant.

How do I handle cancellations and refunds?

Keep the booking in your log, change its status, and record any amount you kept or refunded. This keeps your history complete and your totals correct.

Conclusion

Good Airbnb income and expense tracking is simple: record gross revenue, fees and payouts separately for every booking, use a short list of expense categories, and run the same monthly routine. Within a few months you will see your real profit, your true cost of each channel, and where to act.

If you want the complete, ready-to-use workbook with logs, dashboard, KPIs and tax summary, see the Short-Term Rental Spreadsheet Pro.

More Revenue Management guides

Revenue Management

Revenue Management for Boutique Hotels: A Practical Guide

A practical guide to pricing and distribution for small, distinctive hotels, including room-type pricing, restrictions, channels and a weekly checklist.

23 Oct 20268 min read

Revenue Management

Short Term Rental KPIs: 10 Metrics with Formulas

The 10 short term rental KPIs every host should track, each with a formula and a worked example, plus how to set…

23 Oct 20267 min read

Revenue Management

Revenue Management for Resorts: A Practical Guide

How resorts can manage rates, groups, packages and non-room revenue to maximise total income per guest, with a worked example and checklist.

23 Oct 20267 min read

Revenue Management

Revenue Management for Homestays: A Practical Guide

A practical, step-by-step guide to pricing, channels and add-on income for small homestays, with a worked example and a 30-minute weekly routine.

22 Oct 20267 min read

Revenue Management

Hotel Rate Parity: What It Is and How to Maintain It

Rate parity keeps your price consistent across OTAs, metasearch and your website. Learn what causes disparity and a practical daily routine to…

18 Oct 20268 min read

Revenue Management

Outsource Hotel Revenue Management vs In-House vs RMS Software

In-house hire, software or an outsourced team? Compare the three ways to run hotel revenue management and find the model that fits…

14 Oct 20268 min read

See all Revenue Management articles