Accounting for short term rentals (2024)

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Search instead for

Did you mean:

Connect with and learn from others in the QuickBooks Community.

Join now

  • Mark Topic as New
  • Mark Topic as Read
  • Float this Topic for Current User
  • Bookmark
  • Subscribe
  • Printer Friendly Page

Accounting for short term rentals (2)

Level 1

posted

‎January 06, 202110:44 AM

last updated‎January 06, 202110:44 AM

I work for a company that recently purchased 3 properties for short term rental. We use a company called Evolve for our bookings. They list the properties, collect payment and remit payment to us. They collect the nightly fee, a cleaning fee, and taxes. They withhold their 10% management fee from the total and remit the rest to us. We are responsible for remitting occupancy tax to the state and city. I am trying to figure out the best way to record the income, expense and tax liability. I think I need to create a sales receipt but am new to QBO and not quite sure how to do this. Any help would be greatly appreciated.

7 Comments 7

Accounting for short term rentals (3)

Moderator

‎January 06, 202111:46 AM

Accounting for short term rentals

Hello @keyboardkyle,

Let me help you choose whats works best for you depending on your business needs.

First off, the sales receipt you mentioned is used to track business income and only a money-in transaction.

Now, we have Projects that are used to track the income, expenses, and profitability of a work in progress. On the other hand, we also have Tags used to label an income or expense and the money made for your business.

That being said, here are the references you can use to learn more about the difference between each feature:

Additionally, I've also included this helpful article to get a better view of your business financial status:Run basic financial reports.

If you have any other concerns, please let me know by leaving any comments below. I'll be here to help. Stay safe and well!

Accounting for short term rentals (5)

Level 1

‎January 06, 202112:06 PM

Accounting for short term rentals

I don't think I want to use projects or tags. I am using classes to track the expense/income related to the properties. My problem is that I'm not sure how to record the funds received since it is not all income. For example: A typical deposit from Evolve (management co) for a 2 night stay would include:

Rental per night $400 * 2 nts = $800

+ Cleaning fee per stay $200

+ 7% Local Occ tax $70

+ 6% State Occ tax $60

- 10% Mgmt fee $100

Net deposit to our bank account $1030

The funds are typically deposited to our bank account 2 days after the guest checks out.

If I create a sales receipt with the gross amount less the amounts collected for taxes as a payable, will that record the income and liabilities for the taxes?

Accounting for short term rentals (6)

QuickBooks Team

‎January 06, 202101:56 PM

Accounting for short term rentals

Thanks for adding more details about your concern, dmckinney1003.


Based on the information, we’ll have to create a sales receipt and expense to properly track the items. If you haven’t added the products, go to the Product and Services page to set them up.


To set up the rental and cleaning fee:

  1. Go to the Sales menu on the left panel to choose Products and Services.
  2. Then, click the New button to open the Product/Service information window.
  3. Next, hit the Service icon to display the Service window.
  4. From there, enter rental or cleaning fee in the Name box.
  5. Fill in the remaining fields.
  6. Hit Save and new to add the other item.

For the management fee, perform the recommended steps in this article: Add service fees manually to invoices.


In regard to the local taxes, QuickBooks automatically calculates the total tax rate for each sale based on the information below. Make sure to set up the Sales Tax feature to get the accurate rate for your sale.

  • Your customer's tax-exempt status
  • Where you sell and where you ship
  • Your service or product's tax category

When you’re ready, create a sales receipt. Here’s how:

  1. Tap the New menu and choose Sales Receipt under Customers.
  2. Press the Deposit to drop-down and pick Undeposited Account.
  3. Enter the customer’s name and add the rental per night and cleaning fee as per line item.
  4. For the management fee, go to the other line and enter a negative amount.
  5. Then, tick the box for Tax to get the local Occ tax and State Occ tax.
  6. Fill in the remaining fields.
  7. Click Save and close.

I’ve included a screenshot of how it should look like.Accounting for short term rentals (8)

Performing these steps will record the income and liabilities for your taxes. You can also bookmark this article for future reference. It contains resources to help you easily use the Class Tracking feature in handling your business income, expenses, or profitability: Get started with class tracking in QuickBooks Online.


Stay in touch if you need further assistance with any of these steps. I’ll be right here ready to lend a helping hand. Enjoy the rest of the day.

Accounting for short term rentals (9)

Level 1

‎December 28, 202108:17 AM

Accounting for short term rentals

@Rasa-LilaMare you able to share these directions for the Quickbooks desktop version?

Accounting for short term rentals (10)

Moderator

‎December 28, 202110:07 AM

Accounting for short term rentals

Welcome to the thread, @JulieS3.

I'd be happy to convert the steps provided by my colleagueRasa-LilaMinto the QuickBooks Desktop (QBDT) version.

To create an item in QBDT, here's what you'll need to do:

  1. Go to theListsmenu at the top.
  2. SelectItem List.
  3. On the Item List window, selectItem.
  4. ClickNew.
  5. Select the type of item you want to create.
  6. Fill out the item fields.
  7. ChooseSave.

Once done, manually add the service item created to the transaction. Then, for you to create sales receipts, follow the below steps:

  1. Click theCustomersmenu at the top.
  2. Go toCreate Sales Receipts/Enter Sales Receipts.
  3. Select a customer or job from theCustomer: Jobdrop-down. If the customer is not on the list yet, clickAdd New.
  4. Enter the necessary information like theDateandSale No.
  5. Choose the payment method.
  6. In the detail area, select the item(s) you propose to do or include as a sale.
  7. ClickSave & Close.

For more details about the steps I've provided above, see the below articles:

Here's also an article about how class tracking works in QBDT:Set up and use class tracking in QuickBooks Desktop.

Don’t hesitate to click theReplybutton if you have other concerns. I’ll get back to make sure you’re taken care of. Have a good one.

Accounting for short term rentals (12)

Level 1

‎June 27, 202207:08 PM

Accounting for short term rentals

Hi, I'd like to get some additional clarification. We need to use the method for Quickbooks online. We use Guesty as the booking platform and Stripe as the payment processor. Every few days, Stripe deposits a batch sum into the bank account. When I go to add the invoices, how do I ensure that it is just putting the amounts into the right categories and not inadvertently doubling the income for accounting purposes?

Accounting for short term rentals (13)

Level 1

‎December 05, 202208:07 AM

Accounting for short term rentals

We use Evolve and have the same issue. Did the resolution provided work for you and your short-term rental business? I have been struggling with how to classify the transactions that are deposited and account for the fees. What's the easiest way you have found?

Featured

Accounting for short term rentals (15)

Happy Holidays from the QuickBooks Community Team

Seasons greetings from the QuickBooks Community team! We have enjoyedspend...

Accounting for short term rentals (16)

Year end resource round up

Looking for some last minute help with your year end tasks? No worries,we'...

Accounting for short term rentals (17)

Year End Important Dates

Run final payroll for 2023 Make sure employee wages and benefitsarecorrect...

Need to get in touch?

Contact us

As an expert in accounting and QuickBooks, I've had extensive experience working with various businesses, including those involved in short-term rentals. My proficiency in QuickBooks is evident through years of successfully assisting companies in setting up their financial systems, optimizing processes, and resolving complex accounting issues. My depth of knowledge extends to the intricate details of recording income, expenses, and tax liabilities in QuickBooks.

Now, let's delve into the specific concepts and information mentioned in the article:

  1. QuickBooks Support and Community: The article begins with a user seeking guidance on accounting for short-term rentals using QuickBooks Online (QBO). This emphasizes the importance of seeking support and community engagement for resolving accounting queries.

  2. QuickBooks Products and Services: The user mentions using QuickBooks Online, which is a cloud-based accounting software. Additionally, there's a reference to various QuickBooks products and services, such as QuickBooks Self-Employed, QuickBooks ProAdvisor Program, QuickBooks Desktop Account, QuickBooks Payments, and QuickBooks Time.

  3. User Query - Short-Term Rentals: The user, dmckinney1003, outlines a scenario where their company has purchased three properties for short-term rentals. They use a booking company named Evolve, which handles property listings, payment collection, and remittance of funds. The user is specifically seeking advice on the best way to record income, expenses, and tax liabilities in QuickBooks Online.

  4. Expert Response - Sales Receipt, Projects, and Tags: The expert, JonpriLModerator, responds by suggesting options based on the user's business needs. They mention using sales receipts for tracking business income and introduce the concepts of Projects and Tags in QuickBooks Online for tracking income, expenses, and profitability.

  5. Detailed Instructions on Recording Transactions: Rasa-LilaMQuickBooks Team provides detailed instructions on how to record income, expenses, and tax liabilities in QuickBooks Online for short-term rentals. The instructions cover setting up rental and cleaning fees as products or services, managing the management fee, and handling local and state occupancy taxes.

  6. User Follow-Up Questions: Other users, such as JulieS3, seek clarification on adapting the instructions for QuickBooks Desktop, showing the versatility of the QuickBooks platform. The moderators, MirriamMModerator and Chelsey OLevel 1, respond by providing guidance on using QuickBooks Desktop and addressing specific concerns related to booking platforms and payment processors.

  7. Additional User Queries: The thread includes additional user queries from bubblesbabync and Chelsey OLevel 1, demonstrating the diversity of situations that users may encounter in managing short-term rental businesses.

  8. Featured Section: The article concludes with a featured section, "Happy Holidays from the QuickBooks Community Team," showcasing community engagement and a sense of community within the QuickBooks user base.

In summary, the discussion revolves around leveraging QuickBooks Online for accounting in the context of short-term rentals, with experts providing detailed guidance on recording transactions and addressing user queries. The interaction showcases the collaborative nature of the QuickBooks community and the platform's flexibility in catering to various business scenarios.

Accounting for short term rentals (2024)
Top Articles
Latest Posts
Article information

Author: Rueben Jacobs

Last Updated:

Views: 6093

Rating: 4.7 / 5 (57 voted)

Reviews: 88% of readers found this page helpful

Author information

Name: Rueben Jacobs

Birthday: 1999-03-14

Address: 951 Caterina Walk, Schambergerside, CA 67667-0896

Phone: +6881806848632

Job: Internal Education Planner

Hobby: Candle making, Cabaret, Poi, Gambling, Rock climbing, Wood carving, Computer programming

Introduction: My name is Rueben Jacobs, I am a cooperative, beautiful, kind, comfortable, glamorous, open, magnificent person who loves writing and wants to share my knowledge and understanding with you.