Trust Accounting for Vacation Rental Managers
Founder & CXO
Trust accounting for vacation rental managers (or property managers in general) (“PM”) can be confusing. Add in the selection, set-up & use of VRM booking and accounting software and it can become all out dizzying! The below is not intended to be all encompassing, as the set-up, and specific accounting & reporting is dependent on many different factors. But, it is intended to provide a framework for VRM trust accounting and the different key considerations.
One Bank Account or Two?
There really is not much of an option here. Two bank accounts (at least) are needed to appropriately administer trust accounting. One of the most basic requirements of trust accounting as required by law, is that there be no commingling of company funds and property owner funds. While trust accounting is not required in every state for short-term rental property managers, trust accounting and separate bank accounts is the best way to track owners’ and PM’s funds. The first account is typically an operating account, which holds funds that belong to the PM. The second account is an escrow account that holds rental & security deposits and rental revenues owed to the owners not yet paid out.
Key consideration – Should you use the operating account or escrow account to pay for property and rental related expenses?
Under no circumstances should expenses that are the responsibility of the PM be paid out of the escrow account. Paying rental and property related expenses that are the responsibility of the property owners could be paid out of the escrow account, but this can create issues if the property owner does not have enough funds in the escrow account to cover the expense. If most or all rental related and property expenses are the responsibility of owners, using the escrow account can be considered. If responsibility varies greatly based on type of expense and agreement with owner, the best practice is to use the PM operating account and bill back the expenses to the respectable owner at the end of each month.
Should I use Vacation Rental Management Software?
Vacation rental management apps offer many advantages, including:
- Streamlined booking experience for your renters
- Automatic data transfer and booking into your calendar from multiple online booking sites
- Fast and easy payment processing
- Most offer some sort of trust accounting or general financial reporting features
- Owner statements/portals and EFT transfer for owner payments
- Marketing tools & apps
- Most offer property management scheduling (housekeeping, maintenance, etc.)
One big shortcoming of VRM apps is that they don’t offer the bank/credit card account feeds and even if they integrate with an accounting software, such as QuickBooks Online, they don’t pull in owner expenses automatically. This creates the manual entry of expenses in the VRM app for complete owner statements, which is usually a duplicate entry because expenses have already been recorded in the accounting system if being used concurrently.
Key consideration: Can I just use a VRM app or should I also use an accounting software?
Small VRM’s (usually 5 or fewer properties) may be able to get away with only using a VRM app, but its not recommended. A shortcoming of VRM apps that offer accounting functionality is they are clunky at best and reporting and functionality is poor. Best practice is to use VRM apps for the booking, property and rental management, and tracking owner statements functionality in conjunction with an accounting software.
What accounting software should I use?
There’s A LOT of accounting software options out there, but generally there’s three good options for most PM’s, Xero, QuickBooks Online, and Sage Intacct. A big shortcoming of both Xero & QBO are that they are one entity & one ledger systems. While it can be done, trust accounting for property owners and accounting for the PM’s books in the same instance of QBO or Xero is very difficult. If you have specific questions about selecting accounting software and configuring it for vacation rentals, we would be more than happy to provide you with our recommendations.
- Very well known software with easy access to advisors familiar with the software, including CPAs and tax professionals
- Ease of use of software: With general working knowledge of accounting, use of QBO is fairly straightforward
- Many time saving apps that easily integrate, including several VRM apps
- Automatic bank feeds helps with easy recording of transactions and reconciliation of bank & credit card accounts
- Reporting in QBO can be clunky and not very customizable
- While generally the system is easy to use, there are quirks. It is easy to delete information with no audit trail and knowing how to work the software does take some training.
- QBO is meant to be a fairly straight forward accounting software with limited configuration options; however, there are certain setup considerations and configurations necessary to properly account for the short-term rental business. Getting these settings correct based both on the VRM trust accounting model and your specific business needs takes a certain level of expertise and working knowledge of accounting systems.
- As mentioned above, QBO is meant to be a single entity & single ledger system. Therefore, it is not an ideal environment for the type of multi-entity capabilities that are needed for good trust accounting.
Most of the pros & cons of QBO are the same for Xero. Below highlights the biggest differences:
- Xero is a newer software that is generally easier to use with better customer service
- More robust and easier custom financial reporting
- Easy upload of transactions, which is not a function of QBO except with the use of third-party apps. This becomes handy when transferring data from VRM booking apps.
- Still offers easy integration with many time saving apps, such as Hubdoc, Bill.com, Expensify and others to make bill pay, invoice & receipt data entry and credit card transactions a breeze.
- Robust multi-entity & multi ledger financial management solution making accounting for both the PM and trust accounting for owners very easy in the same system.
- Several different dimensions (known as classes in QBO) to tag and track transactions makes customizing financial reporting, automating owner statements, reporting per booking/guest stay & reporting and data analysis robust, yet quick and easy
- Custom financial reporting and dashboards
- Similar easy integration with many time saving apps
- Open API, allowing for custom integration of VRM apps for streamlined and automated accounting of bookings and recognition of rental revenue after guest stays
- Statistical accounts (i.e. headcount, guest stays, nights stayed, etc.) allowing for robust data and KPI creation and tracking
- Easy template uploads allows for easy transfer of data from VRM/booking softwares to the back-end accounting system
- More complex setup requires expertise from a Sage Intacct Partner to ensure the system is setup correctly
- While highly ranked for its ease of use, likely too robust for a non-trained accounting professional
- While incredibly affordable as a robust financial management solution, the cost is likely out of reach for most PM’s with less than $10M per year in revenue.
Key consideration – Because Ximplifi is a preferred accountant partner with Sage Intacct, we are able to give access to this robust software to our VRM clients as part of our ongoing accounting services.
If you are ready to focus more time on growing your PM business by handing off accounting to Ximplifi and get access to better financial reporting, analysis and advisory, we look forward to helping!
Trust accounting – how the transactions flow.
You will need a general understanding of accounting in order to properly account and track both your owners’ and your own PM company’s books. But hopefully this will give you a general understanding of the flow.
Bookings & Invoices
Rental & security deposits accompany bookings, which usually occur in advance of the actual guest stay, should be recorded as rental deposits and deposited in the escrow account. With some online booking sites, payments for the rental are not received until after the guest departs. If using a VRM app, the tracking of these bookings is very automated and helpful. Because no money is received, generally there is no transaction to record; however, either creating a future dated estimate or invoice in your accounting software on the date of the booking makes accounting for the receipt of the money after the departure much easier. I also recommend creating the future dated estimate or invoice even when a deposit is received (in conjunction with recording a deposit) to make the recognition of revenue, sales tax, etc. automatic after the date of the guest departure.
After the guest stay and usually at the end of the month, rental management commissions will need to be calculated and recorded. A VRM app becomes very useful in tracking and calculating the rental management fees owed per rental. These fees should be recorded as invoices to the owners in the PM books and recorded as bills in the Owners books. Using the upload feature in Xero is very helpful to batch create these invoices and bills. You can use an app like “Transaction Pro” to perform a similar upload in QBO.
Expenses Due To Owner
Expenses paid on behalf of the owner will depend on whether you decided to pay for those expenses out of the Owners’ books (escrow account) or your PM operating account. If you paid via your PM operating account, you will want to make sure these expenses are marked as billable when first recorded. Upon the creation of the rental management fee invoices, you can simply add the billable expenses to that invoice and subsequently record as a bill on the Owners’ books. The downfall of this process is the duplicate entry on the PM & Owners’ books.
Payments Due To Owner
Every month, after rental revenue has been recognized, owners’ expenses and rental management fees recorded, it’s time to process transfers out of the escrow account. The PM will transfer the rental management fees owed to itself from the escrow account and rental revenue less expenses and rental management fees should be transferred to the owners.
There are still other considerations, such as returning security deposits, paying sales taxes, and whether you require a retainer balance for future property expenses, but hopefully this provides an outline to follow to properly account in a trust accounting environment.
Grow Your Property Management Business with Ximplifi.
Ximplifi offers a full-service accounting management solution & CFO advisory for short term rental companies.
If your goal is to take your vacation rental business to the next level, Ximplifi offers services to help you select best-in-class VRM software, automation to streamline your processes, and can even serve as an extension of your business with outsourced financial services. Learn more about our integration software, VRPlatform here.
10 Signs You've Outgrown QuickBooks
Frustrated with QuickBooks?
Download my article to determine if you need a more sophisticated system to meet your needs.