Airbnb income and expense Excel template: what to track and how to structure it

Four areas every Airbnb income and expense spreadsheet needs

Use consistent property identifiers throughout the workbook. A dropdown or validated list reduces mismatches such as Apartment 1 and Apt 1 being treated as different properties. Add the month and availability record needed for occupancy calculations.

What to include in each Airbnb booking row

Use one row per completed stay in the operating register and check for duplicate booking IDs. Keep reservations that have not yet happened distinct from completed-stay reporting. Document how refunds, cancellations and month-end stays are handled so the totals are reproducible.

If you copy a payout amount, first check which fees have already been deducted. Starting from net income and subtracting those fees again understates the result. See how much Airbnb income remains after expenses for a worked example.

• A unique booking ID and property identifier.
• Check-in and checkout dates.
• Accommodation revenue and cleaning income separately.
• Actual platform fees.
• Paid cleaning, laundry and guest supplies.
• Other direct costs with a short explanation.

Keep general operating expenses in a separate table

Record expense date, property, category, amount and a note or invoice reference. Electricity, internet, insurance, software, repairs and general supplies often do not belong to a single booking.

Avoid entering the same cleaning cost in both the stay table and the general expense table. Use a short-term rental expense checklist to decide where each cost belongs and keep that rule consistent.

Retain unusual repairs with a clear note. A monthly result is easier to understand when the reason for a cost spike remains attached to the record.

Turn Airbnb spreadsheet inputs into monthly profit

For that example, operating margin is €1,800 ÷ €3,000 × 100, or 60%. The result excludes taxes, financing and accounting adjustments. Keep this distinction visible wherever the workbook labels a profit figure.

Add the ten monthly metrics for an Airbnb dashboard: revenue, costs, profit, margin, occupancy, ADR, RevPAR, result per stay, profit per occupied night and average stay length. Use accommodation income alone for ADR and RevPAR.

Protect formula cells and make input cells visually distinct. If a denominator is zero, show N/A for that ratio rather than hiding an error with an apparently meaningful zero.

Checks to make before trusting the spreadsheet

Keep a copy before changing formulas, and test a small worked example whose result you already know. If several people edit the workbook, agree who owns the monthly close and how corrections are recorded.

• Check dates, property IDs and duplicate records.
• Reconcile recorded income with the source records.
• Confirm platform fees were deducted only once.
• Check costs against invoices and receipts.
• Use the same period and currency throughout.
• Investigate occupied nights above available nights.

Using Hostpartner in Excel 365 or Google Sheets

Host Profit Dashboard is designed for one to seven properties with separate Excel 365 and Google Sheets editions. You enter the data manually; it does not automatically import bookings or bank transactions.

The Airbnb income and expense dashboard for Excel and Google Sheets brings the operating view together. You can request the resource through the site's form. This guide describes the structure and intended use, rather than providing a separate spreadsheet download inside the article.

For several properties, use a consistent vacation rental profitability comparison to make sure the same rules apply to every home.