Managing an Airbnb property comes with a lot of numbers—nightly rates, occupancy rates, cleaning fees, and maintenance costs.
A simple calculator in Google Sheets can help you keep track of your earnings and expenses, making it easier to see how much profit you’re actually making.
What Is the Best Way to Track Airbnb Income and Expenses?
The best way to track Airbnb income and expenses is by using a simple spreadsheet that organizes all financial data in one place.
This method helps you quickly see how much money you’re bringing in versus how much you’re spending, allowing you to make better business decisions.
Step 1: Open Google Sheets
Open Google Sheets and create a new blank spreadsheet.
Step 2: Label Your Columns
In the first row, enter the following column headers:
- Date
- Nights Booked
- Nightly Rate ($)
- Cleaning Fee ($)
- Other Income ($)
- Total Income ($)
- Maintenance Costs ($)
- Other Expenses ($)
- Total Expenses ($)
- Net Profit ($)
Step 3: Input Basic Formulas
In the Total Income column, calculate the total amount earned. Click the first cell under Total Income and enter: = (B2 * C2) + D2 + E2
This formula multiplies the number of nights booked by the nightly rate and adds any extra income like cleaning fees.
In the Total Expenses column, sum up your costs. Click the first cell under Total Expenses and enter: = G2 + H2
This adds up all expenses related to the booking.
In the Net Profit column, calculate your earnings after expenses. Click the first cell under Net Profit and enter: = F2 – I2
This subtracts total expenses from total income to show your profit.
Drag these formulas down to apply them to the entire column.
Step 4: Add Monthly Summaries
At the bottom of your table, add a Monthly Summary section.
Use the SUM function to add up total income, total expenses, and net profit for the month. Example:
- =SUM(F2:F30) for total income
- =SUM(I2:I30) for total expenses
- =SUM(J2:J30) for net profit
Click the Share button in the top-right corner of Google Sheets. Enter the email addresses of those you want to share with or create a shareable link. Choose whether they can View, Comment, or Edit the spreadsheet. Click Send or copy the link to share.
Get the Free Airbnb Calculator Template
Get a copy of the free Airbnb Calculator Template. I’ve populated some cells as examples, but you can customize them as needed.
Final Thoughts
With this simple Airbnb calculator, you can keep track of your earnings and expenses with ease. Whether you manage one property or multiple, a Google Sheets template helps you stay organized and make informed financial decisions.
Want to make your Airbnb tracking even easier? Try linking your sheet with Google Forms for automatic data entry!
Frequently Asked Questions
Can I use Google Sheets formulas to automate calculations?
Yes! Google Sheets offers powerful formulas like SUM, IF, and ARRAYFORMULA to automate calculations. For example, using ARRAYFORMULA((B2:B * C2:C) + D2:D + E2:E) can apply the Total Income formula to an entire column without dragging.
How do I track occupancy rates in my Airbnb calculator?
You can add an occupancy rate column and use a formula like =(Nights Booked / 30) * 100 to calculate the percentage of days your property was booked in a month.
Can I create charts to visualize my earnings?
Absolutely! Select your data and click Insert > Chart to generate bar charts, line graphs, or pie charts for a clear visual representation of your income and expenses.
The Bottom Line:
One keeps you awake. The other gets work done.
A month of coffee: $150
A month of FileDrop: $9.99
Why not have both?
