Best Value Complete Financial Planning Bundle →
✓ Financial Planning✓ Net Worth Tracker✓ Monthly Budgeting✓ Travel Budget Planner✓ Annual Budgeting Planner✓ Monthly Expense Tracker✓ Annual Tax Planner✓ Retirement Planning
$139 One purchase, no subscription
View Bundle →
by Segmio
View Bundles
Language
ENEnglishDEDeutschESEspañolFRFrançaisPTPortuguêsITItalianoARالعربيةNLNederlandsZH中文
Airbnb Rental Tracker Ultimate ›

Instant digital delivery · Terms & Conditions apply

Essentials Template - Excel & Google Sheets

Essentials Airbnb Rental Tracker Spreadsheet Template for Google Sheets & Excel

Thirty stays with both dates recorded, and the money kept in the parts it actually arrives in: a nightly rate, a cleaning fee charged once per booking, the platform's cut, and whatever a particular guest cost you. The Essentials Airbnb Rental Tracker spreadsheet template builds gross income from the nights and the rate, then takes the fees and expenses off for the net. Three working sheets and a dashboard. Google Sheets and Excel. No macros, no VBA.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

View Ultimate Airbnb Rental Tracker Spreadsheet Template
$29
Essentials Airbnb Rental Tracker spreadsheet template - Google Sheets and Excel preview

What's Included

  • Thirty bookings with both check-in and check-out recorded
  • Nightly rate and cleaning fee as separate fields, since one is per night and one per booking
  • Platform fees and guest-specific expenses tracked per stay
  • Gross income derived from the nights, the rate and the cleaning fee
  • Net income derived once fees and expenses come off
  • Dashboard with gross, net, total fees, booking count, nights occupied and gross income per night
  • A pie chart splitting the gross into what you keep, what the platform takes and what costs take
  • A currency dropdown on the Dashboard that relabels money columns across both sheets
  • Works in Microsoft Excel and Google Sheets with no setup required
Ultimate Version Available

Need more from this template?

The Essentials Spreadsheet Template covers everyday tracking. The Ultimate Spreadsheet Template gives each part of the template its own sheet, with more capacity and deeper reporting on top.

Essentials - $19
  • Thirty bookings with both check-in and check-out recorded
  • Nightly rate and cleaning fee as separate fields, since one is per night and one per booking
  • Platform fees and guest-specific expenses tracked per stay
  • Gross income derived from the nights, the rate and the cleaning fee
Ultimate - $29
  • Booking Log of 100 stays, each tagged with the property it belongs to
  • Net per night alongside net per booking, which often settles short stays against long ones
  • Property Setup holding type, size, purchase price and the monthly carrying costs
  • Standing costs counted whether or not a property is booked
  • Occupancy by property by month
See what's in the Ultimate version› One-time purchase. No subscription.

The FinancialAha Essentials Airbnb Rental Tracker Spreadsheet Template for Google Sheets and Excel is a two-sheet workbook that breaks a booking into its parts, with a How to Use guide on a third tab. It works as an Essentials Airbnb Rental Tracker Excel template and an Essentials Airbnb Rental Tracker Google Sheets template from the same download. Where the Free build takes totals you have worked out, this Essentials Airbnb Rental Tracker spreadsheet template takes the rate, the nights, the cleaning fee, the platform's cut and any costs, and derives the gross and the net itself. No macros, no VBA.

Inside the workbook

What's inside the FinancialAha Essentials Airbnb Rental Tracker spreadsheet template

The FinancialAha Essentials Airbnb Rental Tracker Spreadsheet Template runs on two working sheets - one you type into, one that reports back - plus the guide. It works in both Microsoft Excel and Google Sheets and here is what the Essentials Airbnb Rental Tracker spreadsheet holds.

  1. 01 of 02

    Booking Log

    The sheet you type into, thirty stays deep. Both dates are recorded rather than just the arrival, so the log shows when the calendar was blocked and not only when the guest walked in, with the nights alongside them. The money is broken into the parts a short let actually has: the nightly rate, the cleaning fee that applies once per booking, whatever the platform takes, and any costs tied to that particular guest. Gross and net both follow from those, which means a booking that looked good at the headline rate can be seen properly once the cleaning and the fees are in.

    FinancialAha Airbnb Rental Tracker spreadsheet template - Booking Log sheet

  2. 02 of 02

    Dashboard

    The season in six figures: what came in gross, what was left after everything, what the fees and costs came to, how many bookings there were, how many nights were occupied, and what a night brought in gross. A pie chart splits the gross into what you kept, what the platform took and what the costs came to - which is the picture most hosts have a rough sense of and rarely a precise one.

    FinancialAha Airbnb Rental Tracker Google Sheets template - Dashboard sheet

  3. Included guide

    How to Use

    A step-by-step guide on its own tab, covering setup, what each column expects, how gross and net are arrived at, and how to read the dashboard. Because it ships inside the file, the instructions travel with the template wherever it is opened.

Works in both Google Sheets and Excel

Essentials Airbnb Rental Tracker Spreadsheet template for Google Sheets

Upload the Essentials Airbnb Rental Tracker Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Essentials Airbnb Rental Tracker Google Sheets template needs no conversion step and the chart survives the trip intact - the totals keep working exactly as they do in Excel. The currency dropdown on the Dashboard relabels every money column across both sheets at once.

Essentials Airbnb Rental Tracker Google Sheets template setup

A shared copy of the Essentials Airbnb Rental Tracker Google Sheets template suits a property run between two people or with a cleaner who needs the dates, and Sheets version history covers a booking edited after the fact. Because the reporting sits on its own tab, the log stays a log.

Sharing the Essentials Airbnb Rental Tracker Google Sheet

Day to day the Essentials Airbnb Rental Tracker Google Sheet is a line per booking: the dates, the guest, the rate and the fees. Gross and net settle themselves, so keeping it current through a season is a matter of minutes rather than a reconciliation.

Also available as:

Essentials Airbnb Rental Tracker Spreadsheet template for Excel

The Essentials Airbnb Rental Tracker spreadsheet Excel download is a plain .xlsx. Excel opens this Essentials Airbnb Rental Tracker Excel template directly, with no import step and no compatibility prompt, and the chart is a native Excel chart that redraws as bookings go in. There are no macros and no VBA in the file, so it opens without a security warning.

Essentials Airbnb Rental Tracker Excel template setup

The same Essentials Airbnb Rental Tracker Excel template opens in Excel on Windows, Excel on Mac, and Excel for the web. It is also the identical file you would upload to Drive, so there is no separate Essentials Airbnb Rental Tracker spreadsheet download to choose between.

Essentials Airbnb Rental Tracker spreadsheet Excel notes

The Essentials Airbnb Rental Tracker spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt. The same Essentials Airbnb Rental Tracker spreadsheet Excel download also opens in Excel for the web, which matters when you move between a work machine and a personal one.

Opening the Essentials Airbnb Rental Tracker spreadsheet Excel file

Nothing in the Essentials Airbnb Rental Tracker Excel template is version-specific, so this Essentials Airbnb Rental Tracker spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.

Also available as:

Spreadsheet template highlights

What the Essentials Airbnb Rental Tracker spreadsheet template tracks

You log the booking and the Essentials Airbnb Rental Tracker Spreadsheet Template works out the money:

Check-In
the date the stay begins
Check-Out
the date it ends
Guest
who the booking is for
Nights auto
derived, check-out less check-in
Nightly Rate
what the guest pays per night
Cleaning Fee
the one-off charge for the booking
Airbnb Fees
what the platform takes on the payout
Expenses
costs tied to that particular stay
Gross Income auto
derived, the nights at the rate plus the cleaning fee
Net Income auto
derived, what is left once the fees and expenses come off

Compare builds

FinancialAha Airbnb Rental Tracker spreadsheet template: Free, Essentials, and Ultimate compared

Feature Free View Spreadsheet Template Essentials This page Ultimate View Spreadsheet Template
Working sheets 1 2 6
Bookings 16 30 100
Properties One One Up to 5, defined once
Net per booking Derived Derived Derived, plus net per night
Check-out date – Yes Yes
Nightly rate and cleaning fee – Separate fields Separate fields
Charts – 1 2
Occupancy – Nights only Rate, per property per month
Property costs – – Mortgage, insurance, utilities, tax
Month-by-month – – Net income per property
Return on investment – – Compared across properties

The FinancialAha Essentials Airbnb Rental Tracker Spreadsheet Template covers two working sheets and thirty bookings, and it takes the booking apart rather than taking your total for it. Against the Free Airbnb Rental Tracker Spreadsheet Template, where you supply the gross and the fee figure against an arrival date and the net follows from the two, this build records both dates and separates the nightly rate, the cleaning fee, the platform's cut and the guest-specific costs, deriving the gross and the net from them. It also reports occupancy in nights and what a night brought in gross. It still covers one property. The Ultimate Airbnb Rental Tracker Spreadsheet Template runs several, with their carrying costs, occupancy rates by month, a monthly profit and loss per property, and a return comparison between them.

Compare the other builds: Free Airbnb Rental Tracker spreadsheet template or the Ultimate Airbnb Rental Tracker spreadsheet template .

Good to know

Notes on working in the Essentials Airbnb Rental Tracker spreadsheet template

  • The cleaning fee is separate from the nightly rate because it applies once per booking rather than per night, which changes what a short stay is worth.
  • The fee column takes an amount rather than applying a percentage, since what a platform charges varies by host and changes over time.
  • Expenses here are the ones tied to a particular stay. Standing property costs are what the Ultimate build adds.
  • Nights is derived from check-out less check-in rather than typed, so it always matches what the two dates say.
  • The per-night figure on the dashboard divides the gross by the nights, so the cleaning fee is inside it. It sits above the nightly rate you charge, and the gap widens the shorter the stays are.
  • The pie chart is the one to look at first - it shows how much of the gross actually reaches you.
  • The currency dropdown sits on the Dashboard and relabels money columns across the whole Essentials Airbnb Rental Tracker spreadsheet. It changes the label only and does not convert the numbers.

How to Use the Essentials Airbnb Rental Tracker Spreadsheet Template

1

Enter the dates

Record check-in and check-out for the reservation, along with the guest.

2

Add the rate

Enter the nightly rate and the cleaning fee for the booking. The nights follow from the dates.

3

Record the costs

Add the platform's fee and any expenses tied to that stay.

4

Read the dashboard

Gross, net, total fees, nights occupied and gross income per night, with a chart of where the money goes.

Stress-tested with AI.

Every template starts with deep research into how people actually track the topic. We design the layout, build the formulas, and polish the design until it feels like something we would use ourselves. Along the way, we use AI to stress-test the calculations: unusual inputs, edge cases, and formula behavior, checked until the numbers hold.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

Frequently Asked Questions

Is the FinancialAha Essentials Airbnb Rental Tracker Spreadsheet Template a Google Sheets template?

Yes. Upload the file to Drive and choose "Open with Google Sheets". The Essentials Airbnb Rental Tracker Google Sheets template needs no conversion step and the chart survives the trip intact.

Is the FinancialAha Essentials Airbnb Rental Tracker Spreadsheet Template an Excel template?

Yes. The download is a plain .xlsx, so the Essentials Airbnb Rental Tracker Excel template opens directly in Excel with no import step. The chart is a native Excel chart, and there are no macros or VBA.

Will the FinancialAha Essentials Airbnb Rental Tracker spreadsheet Excel file open in older versions of Excel?

Yes. The Essentials Airbnb Rental Tracker spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.

Can the Essentials Airbnb Rental Tracker spreadsheet handle several properties?

No, it covers one. The Ultimate build tags every booking with its property, holds the standing costs each one carries, and reports occupancy and profit per address.

Why are the nightly rate and cleaning fee separate?

Because they behave differently - the rate applies per night and the cleaning fee once per booking. Keeping them apart is what shows why a two-night stay can be worth much less than the headline rate suggests.

How are the platform fees entered?

As an amount per booking rather than a percentage the sheet applies. What a platform charges varies by host and changes over time, so the figure comes from your payout rather than from an assumption.

What does the pie chart show?

Where the gross income actually goes - what you keep, what the platform takes, and what the costs come to. It is the split most hosts have a rough sense of rather than a precise one.

How do I open the Essentials Airbnb Rental Tracker spreadsheet template in Google Sheets?

Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.

More Essentials Business Finance Templates

Cash Flow Statement

Twelve months across the page, with operating, investing and financing activities grouped into sections of their own and an annual total closing the grid. The Essentials Cash Flow Statement spreadsheet template carries the cash position month to month - you enter January's opening balance and the rest link forward - and follows the usual accounting convention on the working-capital lines. Three working sheets. Google Sheets and Excel. No macros, no VBA.

$19

Profit & Loss Projection

Year one is what you enter; years two and three are worked out from six assumptions you set - revenue, cost of goods sold and operating expense growth, plus a tax rate. The Essentials Profit & Loss Projection spreadsheet template runs thirteen lines from revenue through gross profit and margin, operating income, EBITDA, interest and income before tax, down to net income, with a dashboard over the top. Google Sheets and Excel. No macros, no VBA.

$19

Sales Forecast

Ten product lines forecast across twelve months, then the same ten again recording what actually happened, with the variance worked out per month in money and as a percentage. The Essentials Sales Forecast spreadsheet template gives every line an annual total and a share-of-total figure, and reports the year total and the implied growth on a dashboard. Two working sheets, Google Sheets and Excel. No macros, no VBA.

$19

Startup Costs

Fourteen one-time costs and twelve monthly operating ones stay on lists of their own, each line carrying an estimate, an actual, the variance and a per-cent-spent figure. The Essentials Startup Costs spreadsheet template builds a first-year total from both, one-time plus twelve months of operating, and sets up to six funding sources against it. A notes column records what each figure assumes. Google Sheets and Excel. No macros, no VBA.

$19
Essentials
Preview
See Real Estate Ultimate Pack 10 templates included • Save $141

Instant digital delivery · Terms & Conditions apply

Highlights:

Dashboard with charts and KPIs
Pre-filled categories and sample data
No sign-up, no subscription
Lifetime free updates
Works in
Excel Google Sheets

Looking for premium spreadsheet templates?

Our paid templates include advanced multi-sheet dashboards, native Excel charts, and ongoing updates.

View Premium Templates Browse All Essentials Templates

Private & secure

Your financial data stays on your device. We never see it.

Learn more →

Need help?

Check our guides or reach out with questions.

View FAQ →