Vrbo Quickbooks Templates

QuickBooks for Vrbo: Property Management without Trust Accounting

Why should you read this guide?

In this guide, we introduce an alternative accounting method using QuickBooks for Vrbo property managers who do not use a trust account. With the right systems in place, Vrbo property management can be a lucrative operation, and in many jurisdictions, managing short-term rentals does not require licensing or strict trust-accounting compliance. Under this approach, all funds are collected directly from Vrbo and recorded as income by the property management company, which then pays the owner’s share as a direct cost.

Although this method is not the traditional approach, it is widely used for two key reasons. First, it is significantly simpler than trust accounting—requiring far less data entry, oversight, and training to maintain accurately. Second, because all funds are recognized as income before owner payouts, it can help a property management company demonstrate higher revenue when applying for business financing. If your jurisdiction does not require trust accounting, this streamlined method may be worth considering.

Disclaimer: If you operate in a jurisdiction where short-term rental property managers are legally required to use a trust account, the accounting method outlined in this guide is not appropriate. Some jurisdictions classify property managers as fiduciary custodians of owner funds, which requires a more comprehensive trust accounting method.

USING AIRBNB? READ THIS ARTICLE INSTEAD

NOTE: In this guide, we only cover income accounting, not costs. For a guide about Vrbo costs and chart of accounts to consider, check out this guide instead: Vrbo Costs and Chart of Accounts to Consider

Table of Contents

What you’ll get from this guide:

  1. QuickBooks Chart of Accounts Template for Vrbo Property Management
  2. How to Automate Accounting for Vrbo Listings
  3. Execute Common Transaction Workflows in QuickBooks
  4. Generate Monthly Reports and Owner Statements in QuickBooks

Cash Flow Diagram

Who should not read this guide?

There are other business models that may be more suitable in your particular scenario, which are covered better in the following guides:

QuickBooks Chart of Accounts Template for Vrbo Property Management

We will now describe our chart of accounts template in great detail. With this chart of accounts template, you can create a highly organized system to keep track and manage all Vrbo revenue.

Account Codes

No. AccountType
24000Rental LiabilityLiability
24110Rental Liability: Vrbo Owner Funds PayableLiability
24210Rental Liability: Vrbo Taxes PayableLiability
42000Rental RevenueRevenue
42310Rental Revenue: Vrbo Income – Accommodation FareRevenue
42320Rental Revenue: Vrbo Income – Cleaning FeeRevenue
42330Rental Revenue: Vrbo Income – Other Fees CollectedRevenue
42610Rental Revenue: Vrbo RefundsRevenue
51000Rental CostsCost of Service
51110Rental Costs: Vrbo Base Commission FeeCost of Service
51120Rental Costs: Vrbo Payment Processor FeeCost of Service
51210Rental Costs: Vrbo Amounts Due to OwnerCost of Service

NOTE: In this guide, we only cover income accounting, not costs. For a guide about Vrbo costs and chart of accounts to consider, check out this guide instead: Vrbo Costs and Chart of Accounts to Consider

Detailed Explanation of Accounts

Each account charted is precisely defined below. This accounting method is for Vrbo Property Management businesses that do not use a trust account to manage funds. Rather, the property manager’s operations account is used to collect Vrbo funds and pay out to owners. As such, you’ll notice that amounts paid to owners are considered a cost to the business. This is also balanced by an Owner Funds Payable account. Read below to learn more about any particular account.

Rental Liability

24000 – Rental Liability – This is a parent account with child accounts that account for rental liabilities.

24110 – Rental Liability: Vrbo Owner Funds Payable – This account tracks Vrbo funds payable to owners. This is for property management businesses that do not use a trust account to manage funds.

24210 – Rental Liability: Vrbo Taxes Payable – This represents all Taxes collected from Vrbo and payable to a tax authority.

Rental Revenue

42000 – Rental Revenue – This is a parent account with child accounts that account for rental revenue.

42310 – Rental Revenue: Vrbo Income – Accommodation Fare – This account tracks the accommodation fare portion of each Vrbo reservation. The accommodation fare is equal to the number of nights multiplied by the average nightly rate of each reservation.

42320 – Rental Revenue: Vrbo Income – Cleaning Fee – This account tracks the cleaning fee portion of each Vrbo reservation.

42330 – Rental Revenue: Vrbo Income – Other Fees Collected – This account tracks any other fees collected from Vrbo.

42610 – Rental Revenue: Vrbo Refunds – This account tracks refunds executed by Vrbo.

Rental Costs

51000 – Rental Costs – This is a parent account with child accounts that account for rental costs.

51110 – Rental Costs: Vrbo Base Commission Fee – This account tracks service fee costs from Vrbo for each reservation, which is subtracted from the income.

51120 – Rental Costs: Vrbo Payment Processor Fee – This account tracks payment processor fees from Vrbo for each reservation, which is subtracted from the income.

51210 – Rental Costs: Vrbo Amounts Due to Owner – This account tracks amounts paid to owners as a cost to the business. This account is for property management businesses that do not use a trust account to manage funds.

Accounts not included in this template

For the scope of this guide, we’re mainly focused on Vrbo revenue recognition. It is important to point out that our template does not include many general accounts. We also make reference to some accounts not included in this particular template, which we’ll list here:

  • 11100 – Vrbo Payment Clearing Account – This account is used to apply payments to Vrbo invoices upon the day the Vrbo reservation payout is posted. Payouts can take 2-6 days (or longer) to arrive in the bank account after posted from Vrbo. Monies owed are held in this clearing account until the payouts are received in the bank. This account also helps to automate the reconciliation process.
  • 1XXXX – Operations Bank Account – This is your business operations bank account set up with your financial institution. It’s a cash asset account to facilitate your Vrbo property management company’s day-to-day business operations.
  • 4XXXX – Billable Expenses Income – This is a general account for capturing income received for the payment of billable expenses by owners, which may include a markup.
  • 7XXXX – Billable Expenses – This is a general account for tracking billable expenses for any owners.

Quick Setup Steps

Here’s how to import the above chart of accounts template. All of the accounts discussed in this article can be imported into QuickBooks automatically using Tallybreeze’s setup tools. Here’s how to access this utility…

  1. If you haven’t already, Sign Up to Tallybreeze. It includes free use of this template.
  2. Once registered, go to the Connections manager in Tallybreeze. Connect your Vrbo account, connect your QuickBooks Online account and then create a connection between the two.
  3. Within the Connection settings, select “Set Up QuickBooks”
  4. Select your business model from the drop-down list at the top and select “Import Template to QuickBooks”.

How to Automate Accounting for Vrbo Listings

Vrbo accounting can be automated using Tallybreeze, which allows the Vrbo Property Management company to reconcile all reservations in great detail and allocate payments to owners on-the fly. A reservation made through Vrbo is automatically retrieved and processed given the accounting rules set in the Tallybreeze software. We’ll discuss this feature further along with how it works using the chart of accounts discussed above.

Tallybreeze Listing Presets

Once you connect your Vrbo and QuickBooks account, Tallybreeze will guide you through setting up the accounting rules for each listing. When selecting “edit” on a particular property page, Tallybreeze will provide preset options with easy access to pre-made templates that are tailored specifically towards several types of businesses in the industry. After selecting your particular business model for Vrbo Property Management, the presets below can be broken down into two main groups: Lines 1-6 and Lines 7-12.

Explanation of Preset Lines

To learn more about each preset group, click on the corresponding dropdown.

Lines 1-6: All amounts received by Vrbo are 100% allocated as revenue

This group of lines allocates 100% of all income from Vrbo as revenue to the business. This includes the accommodation fare, cleaning fee, Vrbo base commission fee (subtracted), Vrbo payment processing fee (subtracted), other fees collected and any taxes collected (if they exist)

Vrbo Price Item%Account
Accommodation Fare100%42310 – Rental Revenue: Vrbo Income – Accommodation Fare
Cleaning Fee100%42320 – Rental Revenue: Vrbo Income – Cleaning Fee
Other Fees Collected100%42330 – Rental Revenue: Vrbo Income – Other Fees Collected
Taxes Collected100%24210 – Rental Liability: Vrbo Taxes Payable
Vrbo Base Commission Fee100%51110 – Rental Costs: Vrbo Base Commission Fee
Vrbo Payment Processor Fee100%51120 – Rental Costs: Vrbo Payment Processor Fee

Lines 7-10: Allocate 80% of the accommodation fare and service fee as a cost payable to the owner.

Example Reservation

Let’s say you have Tallybreeze set up for this listing using the preset settings above. Let’s say Vrbo sends a payout for a current reservation with the following itinerary price items:

  • Accommodation Fare: $2000
  • Cleaning Fee: $300
  • Vrbo Base Commission Fee: -$30
  • Vrbo Payment Processor Fee: -$30
  • Vrbo Transient Occupancy Taxes: $200
  • Reservation Total: $2440

First, Tallybreeze accounts for all the income received by Vrbo, separating out each price item. The total amount to be received from Vrbo for this reservation is $2440, which is allocated to the Vrbo Payment Clearing Account to be later reconciled against the resulting bank deposit.

AccountDebitCredit
42310 – Rental Revenue: Vrbo Income – Accommodation Fare$2000
42320 – Rental Revenue: Vrbo Income – Cleaning Fee$300
51110 – Rental Costs: Vrbo Base Commission Fee$30
51120 – Rental Costs: Vrbo Payment Processor Fee$30
24210 – Rental Liability: Vrbo Taxes Payable$200
11100 – Vrbo Payment Clearing Account (Asset)$2440

Next, within the same invoice, Tallybreeze calculates 80% of the Accommodation Fare ($2000 * 80% = $1600) and marks it as a cost payable to the owner. Then, Tallybreeze calculates 80% of the Vrbo Base Commission Fee (-$30 * 80% = -$24) and the Vrbo Payment Processor Fee (-$30 * 80% = -$24), subtracts this amount from the cost and removes it from what’s owed to the owner:

AccountDebitCredit
51210 – Rental Costs: Vrbo Amounts Due to Owner$1600
24110 – Rental Liability: Vrbo Owner Funds Payable$1600
51210 – Rental Costs: Vrbo Amounts Due to Owner$24
24110 – Rental Liability: Vrbo Owner Funds Payable$24
51210 – Rental Costs: Vrbo Amounts Due to Owner$24
24110 – Rental Liability: Vrbo Owner Funds Payable$24

Finally, on the date the reservation payout is received from Vrbo into your Operations Bank Account (3-5 days later), a bank rule in QuickBooks can automatically reconcile the amount back to the Vrbo Payment Clearing Account:

AccountDebitCredit
1XXXX – Operations Bank Account$2440
11100 – Vrbo Payment Clearing Account (Asset)$2440

Set Invoice Customer & Class Categories

In your Tallybreeze listings, we recommend to set the owner as the customer for each invoice. We also recommend creating two classes in QuickBooks: one parent class for the owner and another sub-class for the listing. See below example:

Automate Additional Bills & Invoices (Optional)

With Tallybreeze, you’re also able to automate the creation of additional bills and invoices for each reservation. Consider the following:

  • Create a bill to set payouts payable to the property owner for each reservation.
  • Create a bill to set amounts payable to a tax authority for each reservation.
  • Create a bill to set amounts payable to a cleaning service for turnover of each reservation.
  • Create additional invoice to set amounts receivable by any third party for each reservation.

Quick Setup Steps

All of the above settings can be quickly set up using Tallybreeze’s presets for your listings. Here’s how to set up these presets…

  1. If you haven’t already, Sign Up to Tallybreeze.
  2. After logging into Tallybreeze, set up your connections, then go to Listing Rules.
  3. Select any listing you’d like to automate that hasn’t already been set up.
  4. Select “Load Presets”.
  5. Select your business model from the options.

From here, presets will be loaded as your listing accounting rules and you can edit as needed.

Execute Common Transaction Workflows in QuickBooks

In Vrbo Property Management, there’s several other kinds of transactions in QuickBooks which you’ll need to build into your accounting process with owners and various other parties. We’ll list the common workflows in this section.

Paying Owners

To identify how much is owed to an owner, one can look at the balance sheet and filter for each class category under the owner. The amount that needs to be paid pertains specifically under “24110 – Rental Liability: Vrbo Owner Funds Payable”.

Example Transaction

You, the Vrbo property management company, are holding funds under “24110 – Rental Liability: Vrbo Owner Funds Payable” account in the amount of $20,000 for the owner, Kim Sorreno, for the listing 462 Atlas Way. You’d like to pay this amount to the owner as a result of a month-end report.

First, you’ll need to send the owner the money via bank transfer, ACH, check or other means. Once the transfer is posted and complete, reconcile the outgoing transaction from the Operations Bank Account using the following entry:

DebitCreditClass Category
1XXXX – Operations Bank Account (Asset)$20,000Kim Sorreno: 462 Atlas Way
24110 – Rental Liability: Vrbo Owner Funds Payable$20,000Kim Sorreno: 462 Atlas Way

Detailed instructions for QuickBooks Online

Paying Expenses on Behalf of Owners

There may be situations in which you’ll need to purchase items for the owner’s properties, but the funds come from your operations bank account. This happens when there’s something that needs an immediate fix when a guest checks in – perhaps a smaller maintenance issue. If your contract with the owner allows, you can make the purchase for these items directly from your operations bank account and subtract the paid amount from what’s owed to the owner under “51210 – Rental Costs: Vrbo Amounts Due to Owner”. See example below:

Example

A property owned by Kim Sorreno needs a bathroom faucet to be replaced by a professional plumber. The service costs a total of $200 and needs to be rectified quickly as there are guests checking in later in the day. You also charge a 10% markup for allocating funds and handling these kinds of issues for the owner.

First, you’ll need to pay the plumbing company from your Operations Bank Account either via bank transfer, ACH, check, Venmo or other means. Once the transaction is posted and complete, record the outgoing transaction from your Operations Bank Account using the following entry:

DebitCreditClass Category
1XXXX – Operations Bank Account (Asset)$200Kim Sorreno: 462 Atlas Way
7XXXX – Billable Expenses (Expense)$200Kim Sorreno: 462 Atlas Way

Next, make an entry to deduct the amounts from the amount you owe the owner under “51210 – Rental Costs: Vrbo Amounts Due to Owner”. Include a 10% markup for coordinating & funding the service, and allocate it to your billable expenses income account. Use the following entry:

DebitCreditClass Category
51210 – Rental Costs: Vrbo Amounts Due to Owner$220Kim Sorreno: 462 Atlas Way
4XXXX – Billable Expenses Income (Revenue)$220Kim Sorreno: 462 Atlas Way

Detailed instructions for QuickBooks Online

Remitting Custom Taxes

The line item for Taxes Collected in Tallybreeze will catch any taxes collected by Vrbo – our presets are designed for this purpose. You can then pay the local tax authority on your own terms following the below example:

Example

The owner, Kim Sorreno, has a listing at 462 Atlas Way, which Vrbo is set up to receive custom taxes for all reservations. In Tallybreeze, these amounts are allocated to “24210 – Rental Liability: Vrbo Taxes Payable”. After running a balance sheet report on this listing in QuickBooks, you see that $1000 is owed for transient occupancy taxes.

First, you’ll need to send your payment to the tax authority either via bank transfer, ACH, check or other means. Once the transaction is posted and complete, record the outgoing transaction from the Operations Bank Account using the following entry:

DebitCreditClass Category
1XXXX – Operations Bank Account (Asset)$1,000Kim Sorreno: 462 Atlas Way
24210 – Rental Liability: Vrbo Taxes Payable$1,000Kim Sorreno: 462 Atlas Way

Detailed instructions for QuickBooks Online

Generate Monthly Reports and Owner Statements in QuickBooks

Now that we’ve got our data automatically pulled from Vrbo and precisely synced into QuickBooks, the next time you need statements or reports for your business, it’s easy to produce beautiful copies for both owner and internal stakeholders each month.

Monthly Owner Statement by Listing

The detailed transaction report below provides a snapshot of what the owner has earned for each listing for the month. This statement can be sent to owners every month, with details grouped by listing, so that they know how their earnings compare for each listing. The example below is an owner statement for Kim Randall, who has two listings:

Quick Setup Steps

Here’s how to create this Owner Statement by Listing in QuickBooks Online:

  1. In QuickBooks Online, go to Reports, select “Transaction Detail by Account”
  2. Select the report period (perhaps the previous month)
  3. Select “Customize” and select the following
    • Under “Rows/Columns” select to Group by “Class”
    • Select “Change columns” and remove all columns except “Date”, “Memo/Description” and “Amount”
    • Under “Filter” select “Distribution Account” and select only the account “Rental Liability: Vrbo Owner Funds Payable”
    • Under “Filter” select “Class” and select the owner and their respective listings you want to report
  4. Sort by “Date” ascending order
  5. Select “Run Report”

From here this statement can be saved as a custom report and re-used every month for the owner.

Profit & Loss by Customer

This report is specifically for the Vrbo property manager. This gives a perspective of how much you – as a company – profit or lose on a per listing basis. It gives a clear idea on which kinds of owners you should seek in the future, and which owners you should consider dropping or renegotiating with as an Vrbo property management company. This report is found under QuickBooks “Reports” as “Profit and Loss by Customer”:

Conclusion

Paying owners accurately requires both integrity and a reliable, streamlined accounting process. Because many jurisdictions do not mandate trust accounting, numerous Vrbo property management companies choose the method outlined in this guide. It is far simpler to manage than trust accounting and allows all Vrbo revenue to be recognized as company income—an advantage when applying for business financing.

Most importantly, this approach provides clear financial transparency for property owners and gives you, as the management company, a stronger understanding of your firm’s performance and profitability. We hope this guide has offered valuable insight as you continue to grow and strengthen your Vrbo property management business.

Finally, there are other business models that are not covered in this guide but are covered better in the following guides. Be sure to check these out:

Tallybreeze

Software professional, data wrangler, family man. Jason is a Co-Founder and Head of Product @ Tallybreeze. He’s worked for major global tech companies including Amazon, Hewlett-Packard and Intel Corporation with several issued patents in the digital product space. Computer Science background and establisher of several profitable grassroots ventures in Silicon Valley. He’s into practical zen, the flow state, high-tech and the hustle.

Recent Posts

QuickBooks for Guesty: Property Management without Trust Accounting

For short-term rentals, many jurisdictions do not require licensing or strict trust accounting rules for…

3 weeks ago

QuickBooks for Guesty: Trust Accounting for Property Managers

This guide is a comprehensive method of accounting for those who need to follow thorough…

3 weeks ago

QuickBooks for Guesty: Rental Arbitrage Accounting

Rental Arbitrage is a business model where an operator rents a property from an owner…

3 weeks ago

QuickBooks for Guesty: Investment Property Accounting

A vacation rental investment property is a business model in which an operator purchases a…

3 weeks ago

Vacation Rental Cost Accounting and Chart of Accounts to Consider

How to account for vacation rental costs for owners and operators across various business models.…

3 weeks ago

Vrbo Accounting & Bookkeeping: A Comprehensive Guide

An in-depth discussion about Vrbo accounting and bookkeeping using popular accounting software, QuickBooks. Accordingly, we…

4 weeks ago