Preparing your QuickBooks Online (QBO) company file

A step-by-step guide to configuring your designated trust accounting QBO company file to optimize the VRPlatform workflows

In this article

Step 1: Add a new QuickBooks Online subscription

Step 2: Configure your account and settings

Step 3: Set up your chart of accounts

Step 4: Set up your products & services

Step 5: Set up your classes

Step 6: Set up your vendors

Step 7: Set up your customer types

Step 8: Set up your custom fields (optional)

Steps

Step 1: Add a new QuickBooks Online subscription

If you haven't already subscribed to a QBO company file, please do so here.

The VRPlatform integration requires, at minimum, a QuickBooks Online Plus subscription.

Step 2: Configure your account and settings

First, let's customize a few QBO settings to optimize the VRPlatform workflow:

  1. Sign in to QuickBooks Online.
  2. From the QuickBooks homepage, select the Gear icon and choose Account and settings.
  3. On the Sales tab, in the Sales form content section, ensure the following toggles are turned on, then click Save.

    Custom transaction numbers

  4. On the Sales tab, in the Products and services section, ensure the following toggles are turned on, then click Save.

    Show Product/Service column on sales forms

    Track quantity and price/rate

  5. On the Expenses tab, in the Bills and expenses section, ensure the following toggles are turned on, then click Save.

    Show Items table on expense and purchase forms
    Track expenses and items by customer

  6. On the Advanced tab, in the Accounting section, confirm the Accounting method is set to Accrual, then click Save.
  7. On the Advanced tab, in the Categories section, configure Classes as shown below, then click Save.
  8. On the Advanced tab, configure the Automation section as shown below, then click Save.
  9. On the Advanced tab, in the Other preferences section, ensure the following toggles are turned on, then click Save.

    Warn if duplicate bill number is used
    Warn if duplicate journal number is used

Select Done.

Step 3: Set up your chart of accounts

Download our free, ready-to-import Sample Chart of Accounts for Trust Accounting to kickstart yours.

  1. Prepare your spreadsheet for import
    1. Open the link above, then navigate to File>Download>Comma-separated values (.csv).
    2. Save the file to your drive.
  2. Upload your spreadsheet
    1. Sign in to QuickBooks Online.
    2. Select Settings ⚙. Then select Import Data.
    3. Select Chart of Accounts.
    4. To upload a file from your computer, select Browse and choose the file. Then select Open.
    5. Select Next.
  3. Map your spreadsheet fields to QuickBooks fields

    Once you upload your spreadsheet, map your accounts so they import correctly.

    1. In the Your Field column, select the small arrow ▼ icon and match the names to the QuickBooks Online field for:
      • Detail Type
      • Account Name
      • Account number
      • Type
    2. With the exception of Account Name, you can select No Match if there's a field that doesn’t have a matching column in your spreadsheet. For example, if you don’t use account numbers.
    3. Select Next.
  4. Import your chart of accounts

    You’re almost finished. Check everything one last time before you import your accounts.

    1. If you haven’t yet, be sure to add types and detail types.
      Tip: Focus on getting the account types right first. Then select the detail types that fit the transactions you want to track.
    2. If you see a field highlighted in red, hover over the highlighted field to see what you need to fix.
    3. Uncheck any account you don’t want to save.
    4. If everything looks good, select Import.

Step 4: Set up your products & services

Download our free, ready-to-import Sample Products and Services for Trust Accounting to kickstart yours.

  1. Prepare your spreadsheet for import
    1. Open the link above, then navigate to File>Download>Comma-separated values (.csv).
    2. Save the file to your drive.
  2. Sign in to QuickBooks Online.
  3. Select Settings ⚙. Then select Import Data.
  4. Select Products and Services.
  5. Select Browse to upload the file from your computer. Choose the file, and then select Open.
  6. Select Next.
  7. Map your information. Your Field represents the headers on your spreadsheet. From each drop-down ▼ menu, select the one that matches a field in QuickBooks Online.
  8. Select Next.
  9. If you see some cells highlighted in red, this means the cell is invalid. Check the cell in your spreadsheet and try importing again.
  10. Select Overwrite all values for each product or service with the same name. Make sure everything looks correct because this can't be undone.
  11. Select Import.

Step 5: Set up your classes and locations

VRPlatform uses "classes" and "locations" in QBO to tag the transactions it creates. In the classes section, you'll be adding:

  1. One class for your property management business (ex: Property Management Co.)
  2. One class for each separate listing
    1. NOTE - if you have multiple listings for a single property, you may create a parent class for the property for expense tracking and roll-up.  This is not required, but many find it helpful.   

During the VRPlatform configuration, you'll map each listing in your PMS to the corresponding class you've created here.

To add a new class:

  1. Go to Settings ⚙ and then All Lists.
  2. Select Classes.
  3. Select New. Give this class a name.
  4. To add a sub-class, select Is a sub-class and select the main class. You can nest up to five classes.
  5. Select Save.

    Example suggested class hierarchy:


A subscription to QuickBooks Online Plus or QuickBooks Online Advanced is required for class tracking. Plus subscribers are limited to 40 classes. If you have more than 40 listings, you may need to upgrade to Advanced to take full advantage of the VRPlatform automation. If you need to upgrade your plan, click here.

Only admins can create classes.

For more information on managing classes in QBO, click here.

Step 6: Set up your vendors

From the perspective of the trust account, your business is a vendor, in the sense that you're providing services to your owners and will be paid for those services from the trust account.

First, add your business as a vendor.

To add a vendor manually:

  1. Select Expenses, then Vendors.
  2. Select New Vendor.
  3. Complete the fields in the Vendor Information window.
  4. Select Save and close.

From the perspective of the trust account, your owners are vendors, in the sense that you'll be paying them out their share of income from the trust account.

Second, create a vendor record for each owner following the steps above.

Alternatively, consider importing your owners as vendors from a spreadsheet. 

  1. Download a sample vendor import file for QBO.
    1. Open the link above, then navigate to File>Download>Comma-separated values (.csv).
    2. Save the file to your drive.
  2. Sign in to QuickBooks Online.
  3. Select Settings ⚙. Then select Import Data.
  4. Select Vendors.
  5. Select Browse to upload the file from your computer. Choose the file, and then select Open.
  6. Select Next.
  7. Map your information. Your Field represents the headers on your spreadsheet. From each drop-down ▼ menu, select the one that matches a field in QuickBooks Online.
  8. Select Next.
  9. If you see some cells highlighted in red, this means the cell is invalid. Check the cell in your spreadsheet and try importing again.
  10. Select Import.

For help troubleshooting your vendor file import, click here.

Step 7: Set up your customer types

This step is required if you utilize Guesty because the sync with API Nation requires customer types. This step is optional if not using Guesty.

VRPlatform uses "customer types" in QBO to tag the customer records it creates. Here, you'll be adding one customer type for each channel you accept reservations through. 

During the VRPlatform configuration, you'll map each customer type you've created here to the corresponding channel in your PMS.

If you haven't already added at least one customer record, you'll need to add your first one before setting up a new customer type:

  1. Go to Sales.
  2. Select the Customers tab.
  3. Select Add customer manually.
  4. Enter the customer's info.
  5. Select Save.
To add a new customer type:
  1. Go to Sales.
  2. Select the Customers tab.
  3. Select Customer types.
  4. Select New customer type.
  5. Enter the name of the channel you're creating the customer type for. For example, Airbnb.
  6. Select Save.
  7. Repeat for each channel you accept reservations through.

Don't forget to add a customer type to represent your direct bookings (ex: bookings made through your website).

Step 8: Set up your custom fields (optional - only applicable for Guesty Users)

VRPlatform leverages QBO's custom fields to tag invoices with the Booking Date, Check-in Date, and Check-out Date of reservations per your PMS. To add custom fields:

  1. Select the Gear icon in the upper righthand corner of your QuickBooks screen; select Custom fields.
  2. On the following page, click Add custom field.
  3. Add a custom field named Booking Date by completing the form as shown below; click Save.
  4. Add two (2) additional custom fields, one named Check-in Date and another named Check-out Date.
The names of the custom fields must be entered exactly as shown below to function properly:

Booking Date
Check-in Date
Check-out Date

Up next

Once you've configured your QBO company file, you're ready to connect your QBO, PMS and Stripe or BrainTree accounts. Click here to get started.