Holiday Rental Profit & Performance System | Google Sheets

Holiday Rental Profit & Performance System

Move beyond payout totals and build a clearer picture of how your holiday rental is performing.

The Holiday Rental Profit & Performance System is a connected Google Sheets workbook for independent Airbnb hosts, holiday rental owners and small property managers who want to understand their business figures without subscribing to complex management software.

Record bookings, payouts, expenses and property availability in one structured system. Built-in formulas then turn those entries into monthly reports, annual summaries, property comparisons, booking-channel results and an organised performance Dashboard.

Review revenue after discounts, refunds and platform-related fees. Monitor operating expenses, profit, occupancy, ADR and RevPAR. Compare results across months, years and up to 10 properties, all from your own private Google Sheets copy.

From Payout Totals to Meaningful Business Information

Many independent hosts know how much money enters their bank account but do not have one consistent way to answer the wider questions:

• How much revenue remained after discounts, refunds and booking-related fees?
• What did the property cost to operate?
• Which months performed most strongly?
• Is occupancy meeting expectations?
• Which properties and booking channels are generating revenue?
• How much operating profit was produced?
• How do current results compare with the targets set for the business?
• What remained after recorded capital and financing transactions?

Booking-platform statements, bank deposits and separate expense lists each show only part of the picture.

This system brings those figures together in a structured reporting workflow. You enter and maintain the underlying information; the workbook calculates the relevant summaries and presents them in a clearer monthly, annual and Dashboard format.

A Performance System Designed for Holiday Rentals

This is not a generic household budget or a basic income-and-expense list.

The workbook is structured around the way independent holiday rentals operate, including:

• Individual reservations
• Multiple booking channels
• Cleaning fees and other booking income
• Discounts and refunds
• Channel and payment-processing fees
• Property availability
• Owner-blocked and maintenance-closure nights
• Fixed and variable operating expenses
• Capital and financing transactions
• Occupancy
• Average stay
• ADR
• RevPAR
• Operating profit and operating margin
• Property and booking-channel comparisons
• Optional monthly targets

It supports a single holiday rental or a small portfolio of up to 10 properties, with reporting across as many as five years.

For stock and property-supply management, use it alongside the Holiday Rental Inventory & Restock System.

Key Benefits

• Understand more than total payouts: Review income alongside discounts, refunds, channel fees, processing fees and operating expenses.
• See monthly operating performance: Bring together availability, bookings, revenue, fees, expenses and profit in one monthly report.
• Review up to five reporting years: Compare performance over time and identify seasonal or longer-term patterns.
• Manage one property or a small portfolio: Set up and review as many as 10 individual properties.
• Compare individual properties: See how selected properties contribute to portfolio-level results.
• Review booking-channel performance: Compare booking income and reservation counts across the channels you use.
• Track meaningful holiday rental metrics: Monitor occupancy, average stay, ADR, RevPAR, operating profit and operating margin.
• Separate different types of expenditure: Distinguish normal operating costs from capital, financing, owner-related and excluded transactions.
• Account for actual property availability: Remove owner-blocked dates, maintenance closures and other unavailable nights from availability records.
• Set optional targets: Compare selected monthly results with your own occupancy, ADR, revenue, expense or profit goals.
• Reduce repetitive calculations: Built-in formulas convert the information entered into organised monthly, annual and Dashboard reporting.
• Create a consistent review process: Follow the same workflow when recording transactions and reviewing business performance.
• Keep information under your control: Customers create their own private copy in Google Drive and manage its sharing settings themselves.
• Avoid an ongoing subscription: The workbook does not require a Practical Editions subscription or specialist software installation.

Features

• Eight connected Google Sheets tabs
• Designed for one to 10 properties
• Supports up to five reporting years
• Customisable business and portfolio settings
• Editable property list
• Customisable booking-channel list
• Customisable booking statuses
• Customisable expense categories
• Structured expense reporting treatments
• Booking and payout records
• Income, discount, refund and fee fields
• Detailed expense register
• Property availability records
• Optional monthly performance targets
• Portfolio and individual-property reporting
• Monthly performance report
• Annual performance summary
• Booking-channel comparisons
• Property-level comparisons
• Dashboard filters for reporting year, property and booking channel
• Built-in formulas and calculated summaries
• Dropdown menus for more consistent data entry
• Occupancy calculations
• Average-stay calculations
• ADR and RevPAR reporting
• Operating-profit and operating-margin calculations
• Cash-after-capital-and-financing reporting
• Example entries demonstrating the system
• Clear Start Here instructions
• No specialist software installation
• No recurring Practical Editions subscription

What’s Included

Your purchase includes one Holiday Rental Profit & Performance System containing eight connected Google Sheets tabs:

1. Start Here
2. Setup
3. Bookings & Income
4. Expenses
5. Availability & Targets
6. Monthly Performance
7. Annual Summary
8. Dashboard

The workbook also includes:

• Guided setup instructions
• A recommended operating workflow
• Example booking and expense entries
• Built-in formulas
• Customisable dropdown menus
• Property and channel filters
• Monthly and annual summaries
• Portfolio and property-level reporting
• Performance charts
• Optional target and variance reporting
• Up to 10 property records
• Up to five reporting years

Example entries are included to demonstrate how the workbook works. These should be reviewed, cleared or replaced before entering real business information.

The Eight Connected Tabs

1. Start Here

The Start Here tab provides a complete introduction to the workbook and explains the recommended order of use.

The Quick Start process covers:

1. Creating a personal copy of the Google Sheets file
2. Completing the Setup tab
3. Reviewing and replacing the example entries
4. Entering bookings and payouts
5. Entering expenses
6. Updating availability and optional targets
7. Reviewing the reports and Dashboard

This means customers are not left with an unexplained spreadsheet. The workbook provides a clear starting point, operating guidance and a repeatable routine for maintaining useful records.

2. Setup

The Setup tab controls important settings, lists, labels and reporting periods used throughout the workbook.

Customers can enter or customise:

• Business or portfolio name
• Currency label
• First reporting year
• Number of reporting years
• Default reporting year
• Preferred date format
• Property IDs and names
• Property locations or markets
• Sleeping capacity
• Number of bedrooms
• Active or inactive property status
• Booking channels
• Booking statuses
• Yes or No options
• Expense categories
• Reporting treatment for different expenses

The property table supports up to 10 properties. The booking-channel list can include Airbnb, Vrbo, Booking.com, Expedia, Tripadvisor, direct bookings and other sources used by the customer.

Customised dropdown menus make recurring data entry more consistent and reduce the need to type the same property names, channels, statuses and expense categories repeatedly.

The currency setting changes the displayed currency label only. It does not convert currencies or retrieve exchange rates. Customers should choose and use one consistent reporting currency throughout the workbook.

3. Bookings & Income

The Bookings & Income tab records one row for each reservation.

Information can include:

• Booking ID
• Property
• Booking channel
• Booking status
• Booking date
• Check-in date
• Check-out date
• Number of guests
• Accommodation revenue
• Cleaning fee
• Other income
• Discounts
• Refunds
• Channel fees
• Processing fees
• Payout date
• Payout received

These entries feed the Monthly Performance, Annual Summary and Dashboard tabs.

The booking record helps keep essential reservation and payout information together while creating the foundation for property-level and booking-channel reporting.

Each reservation should have a unique Booking ID. Discounts and refunds are entered as positive figures and subtracted through the workbook’s calculations.

The supplied example bookings should be cleared or replaced before the workbook is used for real business reporting. Formula columns should not be deleted or overwritten.

4. Expenses

The Expenses tab records one row for each business transaction.

Each expense can be assigned to the appropriate property and category, helping customers understand where money is being spent and how different transactions affect their reports.

The system supports reporting treatments including:

• Fixed operating expenses
• Variable operating expenses
• Capital expenditure
• Financing transactions
• Owner or personal transactions
• Excluded or pass-through items

Customisable example categories include:

• Cleaning
• Laundry and linen
• Guest supplies
• Utilities
• Internet and television
• Insurance
• Property management
• Repairs and maintenance
• Gardening or pool expenses
• Software and subscriptions
• Marketing
• Professional fees
• Licences and permits
• Rent or lease
• Rates or property tax
• Furniture and equipment
• Renovations and improvements
• Loan interest
• Loan principal
• Owner drawings or personal transactions
• Pass-through tax
• Other expenses

Separating these categories provides a more useful view than treating every outgoing payment as an ordinary operating expense.

The spreadsheet does not determine the legally or professionally correct accounting or tax treatment. Customers are responsible for choosing suitable categories and consulting a qualified professional where necessary.

For organising the physical repairs and recurring work behind maintenance expenditure, use the Holiday Rental Property Maintenance Log & Planner.

5. Availability & Targets

The Availability & Targets tab allows customers to record the nights each property was genuinely available for guests.

Unavailable nights can include:

• Owner-blocked dates
• Maintenance closures
• Other unavailable periods

Accounting for these dates produces a more meaningful occupancy calculation than treating every calendar night as available regardless of whether the property could actually be booked.

Customers can also enter optional monthly targets for measures such as:

• Occupancy
• ADR
• Revenue
• Expenses
• Profit

Targets are entered manually and are optional. When targets are used, the reporting tabs help customers compare actual results with their own expectations.

The spreadsheet does not recommend nightly prices, automatically create forecasts or supply external market data.

6. Monthly Performance

The Monthly Performance tab converts booking, expense and availability entries into a structured month-by-month report.

Customers select a reporting year and can review the whole portfolio or an individual property.

Reported measures include:

• Available nights
• Occupied nights
• Occupancy
• Number of bookings
• Average stay
• Accommodation revenue
• Cleaning and other net income
• Gross revenue
• Channel and processing fees
• Net revenue
• Fixed operating costs
• Variable operating costs
• Total operating expenses
• Operating profit
• Operating margin
• ADR
• RevPAR
• Other included cash and performance measures

This report removes the need to calculate each monthly figure separately. It shows how bookings, income, fees and operating costs work together and provides a consistent structure for identifying stronger and weaker months.

7. Annual Summary

The Annual Summary brings the selected year into one consolidated view.

The annual overview includes measures such as:

• Net revenue
• Operating expenses
• Operating profit
• Operating margin
• Occupancy
• ADR
• RevPAR
• Cash after capital and financing

It also contains:

• A monthly overview
• Target and variance information where targets have been entered
• Performance warnings where applicable
• A property-comparison table for the selected year

This helps customers review seasonal patterns, compare properties and see whether selected revenue, expense, occupancy or profit targets were met.

The Annual Summary is an internal business-review resource. It does not produce statutory accounts, formal financial statements or tax returns.

8. Dashboard

The Dashboard provides an at-a-glance visual overview of important performance information.

Customers can filter it by:

• Reporting year
• Property
• Booking channel

Displayed performance indicators include:

• Net revenue
• Operating profit
• Occupancy
• ADR
• Operating expenses
• Operating margin
• Cash after capital and financing
• Number of bookings
• Other relevant measures included in the workbook

The Dashboard also presents:

• Monthly revenue, expenses and profit
• Booking-channel net revenue
• Property-level net revenue
• Performance charts
• Occupancy and target comparisons where targets are available

The booking-channel filter applies to booking revenue and booking counts. Because expenses are assigned to properties rather than individual booking channels, expense figures remain property-level results.

The Dashboard updates from the information entered in the connected working tabs. It does not retrieve live information or independently monitor booking platforms, bank accounts or properties.

Understanding the Main Performance Measures

Available Nights

The number of nights the property was genuinely available to receive bookings after recorded owner blocks, maintenance closures and other unavailable periods are considered.

Occupied Nights

The number of nights associated with qualifying reservations entered into the workbook.

Occupancy

The proportion of available nights that were occupied. This helps show how effectively the property’s available capacity was used.

Number of Bookings

The number of qualifying reservations recorded for the selected period, property or applicable booking-channel filter.

Average Stay

The average number of occupied nights per qualifying booking.

Accommodation Revenue

The recorded income attributable to the accommodation portion of qualifying reservations.

Gross Revenue

The combined booking-related income calculated from the relevant revenue and adjustment fields before recorded booking-channel and payment-processing fees are deducted.

Net Revenue

Revenue remaining after the relevant channel and processing fees recorded in the system have been deducted.

Operating Expenses

The fixed and variable expenses categorised as part of ordinary property operations.

Operating Profit

Net revenue less the recorded operating expenses included in the report.

Operating Margin

Operating profit expressed as a percentage of net revenue. This helps compare profitability across periods or properties of different sizes.

ADR

Average Daily Rate shows the average accommodation revenue generated per occupied night, based on the qualifying information entered into the workbook.

RevPAR

Revenue per Available Room, or RevPAR, relates accommodation revenue to the nights the property was available. It reflects the combined effect of rate and occupancy.

Cash After Capital and Financing

A cash-oriented measure showing what remains after the relevant recorded capital and financing transactions have been applied to operating results.

Target Variance

The difference between a manually entered target and the corresponding calculated result. Targets are optional and are not forecasts or recommendations generated by the spreadsheet.

All calculations depend on the accuracy, consistency and completeness of the information entered by the customer.

How the System Works

Step 1: Create Your Private Copy

Open the supplied template link, sign in to a Google account and create your own copy in Google Drive.

Your copy is separate from the Practical Editions master template. You control your spreadsheet and its sharing settings.

Step 2: Complete the Setup

Enter the business name, reporting currency label, reporting years, properties, booking channels, statuses and expense categories.

Step 3: Remove the Example Data

Review the supplied example entries to understand how the workbook works, then clear or replace them before entering real business information.

Step 4: Record Bookings and Income

Add one row for each reservation, including the property, booking channel, dates, revenue, discounts, refunds, fees and payout information.

Step 5: Record Expenses

Enter business transactions and assign each one to the relevant property, category and reporting treatment.

Step 6: Update Availability and Targets

Record unavailable nights and, if desired, enter monthly occupancy, ADR, revenue, expense or profit targets.

Step 7: Review Monthly Results

Use the Monthly Performance tab to compare revenue, expenses, profit, occupancy and other key measures across the selected year.

Step 8: Review the Annual Summary and Dashboard

Use the consolidated reports to compare months, properties, booking channels and actual performance against any targets entered.

Recommended Ongoing Workflow

For the most useful results:

1. Enter bookings consistently
2. Record discounts, refunds and fees
3. Add expenses at regular intervals
4. Update unavailable nights
5. Confirm booking statuses
6. Review payout information
7. Check the Monthly Performance report
8. Investigate unexpected figures or missing information
9. Review the Dashboard
10. Complete a fuller annual review at the end of each reporting period

The workbook can support a monthly business-review routine, but it does not monitor or update itself without customer input.

Hosts establishing their first accommodation can use the system alongside the Holiday Rental Launch Planner to organise the wider setup and launch process.

Who It Is For

The Holiday Rental Profit & Performance System is designed for:

• Independent Airbnb hosts
• Holiday rental and vacation-rental owners
• Short-term rental hosts
• Hosts managing one property
• Hosts building a small property portfolio
• Small property managers managing up to 10 properties
• Hosts receiving reservations through several booking channels
• Hosts who want clearer monthly and annual performance information
• Hosts currently using basic income-and-expense lists
• Hosts relying on disconnected spreadsheets or handwritten notes
• Hosts who want to understand occupancy, ADR and RevPAR
• Hosts who want an alternative to an ongoing specialist-software subscription
• Hosts who are prepared to enter and maintain their own business information

For clearer property-preparation and cleaning standards, pair it with the Holiday Rental Cleaning & Staging Manual.

Who It May Not Suit

This system may not be suitable for:

• Large property-management companies
• Businesses managing more than 10 properties
• Customers requiring more than five reporting years in one workbook
• Customers requiring live bank feeds
• Customers requiring automatic transaction imports
• Customers requiring automatic Airbnb, Vrbo or Booking.com integrations
• Customers needing a channel manager
• Customers needing a live reservation calendar
• Customers needing automated currency conversion
• Customers requiring automatic market data
• Customers requiring automated nightly-rate recommendations
• Customers needing formal accounting or bookkeeping software
• Customers requiring payroll features
• Customers requiring tax-return preparation
• Customers unwilling to enter bookings, expenses and availability manually
• Customers without access to Google Sheets
• Customers requiring confirmed Microsoft Excel compatibility

Specifications

• Product format: Digital Google Sheets workbook
• Number of connected tabs: Eight
• Property capacity: Up to 10 properties
• Reporting period: Up to five reporting years
• Suitable for: One property or a small portfolio
• Input areas: Fully editable
• Example entries: Included
• Built-in formulas: Included
• Dropdown menus: Included
• Calculated reports: Included
• Dashboard: Included
• Property comparisons: Included
• Booking-channel comparisons: Included
• Optional performance targets: Included
• Google account required: Yes
• Software installation: Not required
• Practical Editions subscription: Not required
• Automatic platform integrations: Not included
• Automatic bank feeds: Not included
• Automatic currency conversion: Not included
• Confirmed Microsoft Excel compatibility: Not included
• Physical product: Not included

The system should be used with one consistent reporting currency. Changing the currency field alters the displayed label but does not convert monetary values.

Important Digital-Product Information

This is a digital product. No physical workbook, printed document, laptop, tablet, stationery or other item shown in the product photographs will be delivered.

Customers receive access instructions and a link to create their own private Google Sheets copy. A free Google account is required.

No specialist software installation or ongoing Practical Editions subscription is required.

Input areas can be customised, but customers should avoid deleting or overwriting formula cells, report structures or essential system labels. Changes to formula areas may affect calculations, summaries, charts and Dashboard results.

The workbook includes example entries for demonstration. These are not real business results, recommendations or forecasts and should be removed or replaced before use.

Accuracy and Professional-Advice Disclaimer

The Holiday Rental Profit & Performance System is an organisational and internal business-review resource.

It is not:

• Accounting software
• Tax software
• Bookkeeping software
• Payroll software
• A property-management system
• A channel manager
• A reservation calendar
• Financial, accounting, tax or legal advice
• A substitute for an accountant, bookkeeper, tax adviser or other qualified professional

The workbook does not decide the correct legal, tax or accounting treatment of a transaction. Rules vary by country, business structure, property and individual circumstances.

Customers remain responsible for:

• Entering complete and accurate information
• Selecting appropriate categories and reporting treatments
• Keeping records current
• Retaining any legally required source documents
• Checking applicable tax and accounting requirements
• Seeking qualified professional advice where appropriate

Calculated results will only be as accurate as the information entered.

Frequently Asked Questions

What is the Holiday Rental Profit & Performance System?

It is an eight-tab Google Sheets workbook that helps independent holiday rental hosts record bookings, income, expenses, availability and targets, then review calculated monthly, annual and Dashboard performance information.

Is it an accounting system?

No. It is an internal business-management and performance-tracking spreadsheet. It does not replace accounting, bookkeeping or tax software.

Is it a property-management system?

No. It does not manage reservations, messages, calendars, tasks, guest communication or booking-platform listings.

Is it an app?

No. It is a Google Sheets workbook.

How many properties can I include?

The Setup tab supports up to 10 properties.

Can I use it for one property?

Yes. The system is suitable for a single holiday rental as well as a small portfolio.

How many reporting years can I use?

The workbook supports up to five reporting years, beginning with the first year selected in the Setup tab.

Do I need a Google account?

Yes. A free Google account is required to create, access and edit your own copy.

Do I need to install any software?

No. The product is designed for Google Sheets and does not require specialist software installation.

Is there a subscription?

No ongoing Practical Editions subscription is required to use the workbook.

Does it connect to Airbnb, Vrbo or Booking.com?

No. It does not connect to or synchronise with booking platforms.

Booking information must be entered manually.

Does it import reservations automatically?

No. Customers enter one row for each reservation.

Does it connect to my bank?

No. The system does not download or synchronise bank transactions.

Does it synchronise calendars or availability?

No. It does not connect to booking-platform calendars. Customers manually record availability and unavailable nights.

Does it recommend nightly prices?

No. The system reports results from the information entered. It does not recommend rates, use live market data or provide dynamic pricing.

What booking channels can I use?

The booking-channel dropdown can be customised. Example channels include Airbnb, Vrbo, Booking.com, direct bookings, Expedia, Tripadvisor and other sources.

Can I track direct bookings?

Yes. Direct booking can be included as a customisable booking channel, provided the relevant booking and income information is entered manually.

Can I customise the expense categories?

Yes. Expense categories and their reporting treatments can be adapted through the Setup tab.

Customers are responsible for selecting categories appropriate to their business and professional requirements.

Does the system calculate occupancy?

Yes. Occupancy is calculated from the qualifying occupied nights and the availability information entered into the workbook.

What are ADR and RevPAR?

ADR shows average accommodation revenue per occupied night. RevPAR relates accommodation revenue to the number of available nights.

Both calculations depend on the booking and availability information entered.

Does it calculate operating profit?

Yes. The reporting tabs calculate operating profit from the relevant net revenue and recorded operating expenses included in the workbook.

It is an internal performance measure rather than a formally prepared accounting figure.

What is operating margin?

Operating margin expresses calculated operating profit as a percentage of net revenue, helping customers compare results across periods or properties.

Can I compare properties?

Yes. Customers can review portfolio-level results and individual-property performance for up to 10 properties.

Can I compare booking channels?

Yes. The Dashboard includes booking-channel reporting for relevant booking revenue and booking counts.

Expenses are assigned at property level, so the booking-channel filter does not allocate operating expenses to individual channels.

Can I set performance targets?

Yes. Optional monthly targets can be entered manually for selected measures such as occupancy, ADR, revenue, expenses and profit.

The system does not generate the targets or create forecasts automatically.

Does it convert currencies?

No. The Setup tab allows the customer to change the displayed currency label only.

The workbook does not convert currencies or retrieve exchange rates. Use one consistent reporting currency.

Does it prepare tax returns?

No. It does not generate tax returns, statutory accounts or formal financial statements.

Can I give the reports to my accountant?

You may choose to share relevant records with a professional, but your accountant or bookkeeper must determine whether the information is suitable and what additional documentation is required.

Are example entries included?

Yes. Example entries demonstrate how the workbook works. They should be cleared or replaced before using the system with real information.

Will my information be private?

Customers create their own separate copy in Google Drive. They control access through their own Google sharing settings.

Is it compatible with Microsoft Excel?

Microsoft Excel compatibility has not been confirmed. The product is designed and supplied for use in Google Sheets.

Will I receive a physical product?

No. This is a digital Google Sheets product. Nothing will be printed or posted.

Where can I find complementary hosting resources?

Explore the Practical Editions Host Resources collection for operational planners, manuals and systems designed for Airbnb and holiday rental hosts.