Skip to main content
April 14, 2024
Question

seting up quickbook for Airbnb and Longterm rental

  • April 14, 2024
  • 1 reply
  • 0 views

I have one rental that is on Airbnb and another that a relator  handles. I want to log the income and expense on quick books. The one the relator takes care of handles all the expenses except for water bill ,real estate tax and insurance, the Airbnb is more involved because of cleaning, project manager fees etc.

can anyone guide me or show me a tutorial on how to set up these 2 units under my LLC?

Both units pay into my bank account so I don't need to send bills/invoices or send receipts. 

1 reply

April 14, 2024

I can help you set up your Airbnb and long-term property rentals in QuickBooks Online (QBO), @Djjeffa. Here's a step-by-step guide to make the process easier for you.

 

First, you need to set up and add your customers (renters/tenants) to keep track of their transactions within the program. You can follow the steps below for your guidance:

 

  1. Go to the Sales menu, then select Customers.
  2. Click New Customer.
  3. In the Customer display name field, enter what you want to display for the customer. You can also add an identifier to differentiate your tenants from the Airbnb and the long-term rental.
  4. Review each section and enter any other important customer info. 
  5. Select Save.

Next, let's ensure to set up your income and expense account, and service items properly in QuickBooks. You can also consult with your accountant to help set this up for you in the program. Here are some examples of the accounts and items you can set up: 

 

 

Set up Income and Expense accounts:

 

  1. Go to the Gear icon, then select Chart of Accounts.
  2. Click New, then enter the  Account name
  3. Select an Account type and the Detail type from the dropdowns.
  4. If you choose an Asset, Liabilities, or Equity account, enter Opening Balance, and fill out the starting date in the As of field.
  5. You can add a Description for additional information about this account. 
  6. Select Save

 

Set up Service Items:

 

  1. Go to the Sales menu, then select Product & services.
  2. Click New, then select Service.
  3. Enter the Name of the item, and its Sales price/rate.
  4. Select the Income account you've created previously to track the sales.
  5. In the Sales tax section, sales tax is applied by default based on location. For more specific options, or to make the product or service nontaxable, select Edit sales tax. Then do one of the following, depending on the product or service:
    1. If the service is tax-exempt, select Nontaxable, then select Done
    2. If the item has a special tax rate, use the Search field or Browse all to find and select a more specific product or service type, then select Done.
  6. Once done, select Save and Close.

 

Then, to track your income, you can record the rent from your tenants as an invoice if you receive the payments at a later date or as a sales receipt if you received them right away. 

 

Afterward, you may record and keep track of your expenses, like utilities, maintenance, repairs, and more. If you pay your expenses later, you can create a bill. However, if you pay your vendor right away, you can use a check to instantly record your payments. 

 

Furthermore, once you've recorded all the properties' income and expenses, you may run financial reports like Profit & Loss reports and Balance sheets in QuickBooks to view and monitor your financial performance. 

 

Also, you can customize these to filter and personalize the data according to your reporting needs. 

 

Please let me know if you need further assistance setting up your account in QuickBooks Online. I'll be right here ready to lend you a hand. Have a great day!