QuickBooks Integration: Customization Settings Configuration

When setting up the integration, follow the step-by-step configuration. To pause, click “Continue Later” to save your settings. You can resume anytime and review or change settings using the Back button. Before submitting, you can cancel the QBO integration to prevent syncing. Consult with your bookkeeper or accountant before finalizing.

This article will guide you through configuring the Customization Settings Configuration.

*Important*: Once submitted, you cannot change the settings without moving to a NEW QuickBooks account.

The Customizing option requires you to make detailed decisions about which items will sync with QBO, and how and when they should sync. Because of its complexity, it’s advisable to consult with your bookkeeper or accountant before customizing your QBO integration. If you choose this option, you will have to create your own QBO bank account and match it to a Rocket Matter bank account.

**Important:** QBO Integration Guide for RM: BEFORE configuring your QuickBooks Integration, we strongly suggest reviewing our in-depth QuickBooks Online Guide with your bookkeeper or accountant. This guide will walk through all integration items, configuration items, required QBO settings, syncing, resyncing, and much more!

QuickBooks Customization Settings Configuration

To integrate QuickBooks Online:

1. From the left navigation panel, click Accounting.
2. From the Accounting menu, click QuickBooks.
3. On the QuickBooks Integration page, slide the toggle button On.
   
4. You’ll be prompted with the QBO Acknowledgement.
   Important: BEFORE you begin configuring your QuickBooks Integration, we strongly suggest reviewing our in-depth QBO Integration Guide with your bookkeeper or accountant. This guide will walk you through all integration items, configuration items, required QBO settings, syncing, resyncing, and much more!
5. Once you’ve read the QBO Integration Guide, and you wish to proceed with the integration setup, click Acknowledge and Proceed.
   
6. Select the account you want to use to access QuickBooks and click Sign In.
   
7. Enter your password.
8. From the Search for your company drop-down, select your company and click Next.
9. You will get the confirmation message QuickBooks is successfully linked to your Rocket Matter account! Click Back to Rocket Matter.
   

Step 1: General Setup

You will be directed to the configuration setup. Review the welcome page information in step one and click “Next” in the bottom right.

Step 2: Business Accounting

1. In Step 2, we will focus on Business Accounting. This article will guide you through the Customization Settings Configuration steps, where you will choose the option “Map existing QBO Bank Accounts”.
   • The Customizing option requires you to make detailed decisions about which items will sync with QBO, and how and when they should sync.
2. As shown below, the Rocket Matter Bank Account “Operating Bank – Business Account” will need to be ‘mapped’ to one of the QBO Bank Accounts displayed in the drop-down menu.
3. Add Rocket Matter Bank – If you wish to add a Rocket Matter bank account, select “Add Rocket Matter Bank.” You will then be prompted to enter the name of the operating bank or credit card account.
4. Click ‘Next‘ when complete.

Step 3: Trust Accounting

Rocket Matter will create and map QBO trust bank and QBO trust liability accounts to Rocket Matter trust bank accounts, but you can turn off this feature or customize your settings. Within the Trust Accounting configuration, you’ll have the following options:

1. 1. Sync Trust Accounts:

      • You are not required to sync your trust account with QBO to use the Trust Accounting functions.
      • If you turn off the sync trust account feature, Rocket Matter will not sync any of your trust transactions to QBO and you will have to manually add your trust transactions to QBO.

   2. Trust Bank Deposit Options:

      • Option 1: Sync Individual Trust Deposit Transactions: If you choose this option, you won’t be able to batch these items onto a deposit slip in QBO, but the customer/matter will appear on QBO reports.
      • Option 2: Sync Deposit Slips: If you choose this option you must create a deposit slip in Rocket Matter for every single trust deposit (even for single item deposits) and the customer/matter for the deposit slip items may not pull into QBO reports.
   3. Trust Bank Mapping:

      • Option 1: Let Rocket Matter Create and Map QBO Trust Bank Accounts:

        If you choose this option, the system creates one QBO client Trust Liability Account that is mapped to current and future Trust Bank Accounts.

        • As shown below, the Rocket Matter Bank Account “Operating Bank – Business Account” will map to the QBO Bank Account “RM Operating Bank – Business Account.”
      • 

      • Option 2: Map Existing QBO Bank Accounts:

        If you choose this option, you will have to use existing, or create new QBO trust bank and QBO client trust liability accounts and then map those to your Rocket Matter Banks in the table below. If desired, you can create a separate QBO Client Trust Liability account for each Trust Bank Account.

        1. Select the QBO Bank Account from the drop-down menu.
        2. Select the QBO Liability Account from the drop-down menu.
           

   4. Add Rocket Matter Bank –

      If you wish to add a Rocket Matter bank account, select “Add Rocket Matter Bank.” You will then be prompted to enter the details for the Trust Account.
      
      

   5.  Once complete, click Next.

Step 4: Hard Costs

Rocket Matter is set up to sync matter-related operating checks and credit card charges with QBO, but you can turn off or customize this feature below.

1. Sync Hard Costs:

   • If you turn this feature off, you will have to manually add your hard costs expenses into QBO.

     

2. Hard Cost Catagory Options:

   • Option 1: Use Rocket Matter Generated Categories for Hard Costs – Choose this option if you want Rocket Matter to create the necessary QBO general ledger accounts for you.
   • Option 2: Use Customized QBO Categories for Hard Costs – Choose this option if you want to use existing or create your own QBO asset, and QBO expense accounts for tracking hard cost expenditures.
     
3. Track Matter-Related Expenses: Choose whether to track your matter-related expenses as Advanced Client Costs or as Hard Cost Expenses
   • Option 1: Hard Costs Expenses – Choose this to track matter-related as expenses when paid and as income when reimbursed
   • Option 2: Advanced Client Costs – Choose this to track matter-related expenses to the same asset account when reimbursed
4. Review the Hard Cost selection and mappings below. Once complete, click “Next.”

Step 5: Invoices & Payments

The system is set for Rocket Matter to sync invoices and invoice payments into QBO, but you can turn off or customize your settings below.

1. Toggle to Sync or not to sync Invoices/Invoice Payments.
   • If you turn off the sync invoice/invoice payments feature, none of your invoice payments will sync with QBO. You will need to manually add invoices and invoice payments into QBO.
     
2. Sync Invoice Options:
   • Option 1: Sync Invoices and Invoice Payments: Choose this if you want the system to bring in all invoices and invoice payments dated after the sync start date. If an invoice is deleted from QBO, the payment won’t sync even if this option.
     • If selected, the option to Allow Unlink Payments in Rocket Matter will appear. If you check this option, the system will unlink the payment in Rocket Matter only. The unlinked payment is not synced to QBO and you will have to manually record the unlinked payment in QBO
   • Option 2: Sync Invoices Only – If you choose this option, you will have to manually record your invoice payments in QBO.
   • Option 3: Sync Invoice Payments Only – If you choose this option, the system brings invoice payments into QBO as Sales Receipts without creating invoices.
     • If selected, the option to Allow Unlink Payments in Rocket Matter will appear. If you check this option, the system will unlink the payment in Rocket Matter only. The unlinked payment is not synced to QBO and you will have to manually record the unlinked payment in QBO.
   • 
3. If Sync Invoices and Invoice Payments or Sync Invoices Only is selected, Invoice Item Options will appear. 
   • Aggregate Time/Expense Items:
     • If selected, the system creates an invoice in QBO that shows the total fees, total costs, etc., rather than syncing the individual time and expense cards that were on the invoice in Rocket Matter.
     • If you turn off the aggregate time/expense items, the system will sync every single time and expense item when it syncs the invoice.
   • Use Individual Time/Expense Items when Syncing Invoices: If selected, the system syncs the entire invoice including the individual time and expense cards that were on the invoice in Rocket Matter.
     
4. Once complete, click Next.

Step 6: Invoice & Payment Item Mapping

Step 7: Change/Write-Offs

1. Sync Change/Write-Offs: If you turn off the Sync Change/Write-Offs feature, none of your changes or write-offs will sync with QBO. You will need to manually add any changes or write-offs to the QBO invoices.
   
2. Invoice Item Mapping:
   • Option 1: Let Rocket Matter create and map QBO Products and Services – The system automatically creates QBO Products and Services and maps them to the appropriate Rocket Matter write-off items.
     
   • Option 2: Map existing QBO products and services for change/write-offs – This option allows you to use custom-created QBO products and services when recording change/write-offs in QBO.
     
3. Once complete, click Next.

Step 8: Contacts and Matters

1. Rocket Matter syncs ALL contacts and ALL matters with QBO regardless of the sync start date. You cannot turn this function off.
   • Rocket Matter Clients will sync into QuickBooks as contact type “Customer.”
   • All other Rocket Matter contacts will sync into QuickBooks as contact type “Vendor.”
2. Duplicate Contacts
   • Toggle here to check if Rocket Matter Contact is a duplicate.
   • If you choose not to check for duplicate contacts, integrating with an existing QBO account could result in a significant number of duplicate contacts being imported into QBO.
3. Rocket Matter Contact Fields Used to Check for QBO Duplicates – By default, Rocket Matter automatically checks for duplicates based on Name and Display Name. The system can check for duplicates based on additional contact fields, and select all those that apply.
   • 
4. Check Reverse Name/Display Name: QBO may display the contact name in the opposite order than how it displays in Rocket Matter. Check this if you want Rocket Matter to check for duplicates by both Last Name, First Name, AND First Name Last Name.
   
5. Rocket Matter Contact Considered Duplicate If...
   • Every selected field matches – When selected, Rocket Matter creates a new contact in QBO if any one of the checked fields above does NOT match the corresponding field in QBO.
   • Any of the selected fields match – When selected, Rocket Matter doesn’t create a new contact in QBO if any one of the checked fields above matches the corresponding field in QBO.
     
6. Duplicate Contact Handling
   • Keep QBO Contact “as is” – If the Rocket Matter contact is a duplicate of a QBO contact, the system doesn’t make any changes to the QBO contact information.
   • Keep QBO Contact, but supplement missing information with Rocket Matter data – If the Rocket Matter contact is a duplicate of a QBO contact, the system doesn’t make any changes to the QBO contact information, but it does replace any blank fields in the QBO contact with the information from Rocket Matter.
   • Overwrite QBO Contact with Rocket Matter information – If the Rocket Matter contact is a duplicate of a QBO contact, the system replaces all fields in the QBO contact with the information from Rocket Matter’s contact.
7. When finished, click Next.

Step 9: Sync Options

1. Sync Start Date: Before you can submit your sync, you must choose a sync start date. This is very important because only items dated after your sync start date will be synced with QBO.
   • Items dated after the sync start date automatically sync with QBO in real-time.
   • Contacts and Matters sync with QBO regardless of when they were created.
     
2. Sync All Unpaid Invoices: 
   • If you disable the Sync Fully Outstanding Invoices feature, only invoices with fully outstanding balances as of the sync start date will be synced.
   • Partially paid invoices will not be synced at all. Consequently, none of your existing invoices will be synced with QBO if this feature is turned off.
   • Additionally, any payments made on these invoices will not be synced either.

Step 10: Review and Submit

• You have completed the QBO Integration Wizard. Please review all of your settings carefully to make sure that they are correct. Click “Continue Later” if you’d like to save your changes and come back to them later.
• *Important*: Once submitted, you cannot change the settings without moving to a NEW QuickBooks account.
• We recommend that you print these settings and keep them handy for future reference. Click the Print Settings to print all selections.
• Once finished, click Submit.