QBO 2.0: Quickbooks Online (QBO) Post Setup Testing, FAQs, and Troubleshooting

Test Your QBO Connection

Important note: Follow the steps to test your QBO connection in your Production environment. 

Use the steps below to test that your integration was successful. 

  1. Create a shipment in Turvo with costs added.

  2. If you have a new QBO account, create a carrier and customer invoice for the shipment you created and ensure that they are in the Approved status. If you have an existing QBO account, skip to step 3.

  3. If you have an existing QBO account, verify that the account ID in the Carrier and Customer profiles match the ID’s in QBO.
  1. If a successful sync occurs, the QBO icon appears next to the invoice.

  2. Now, login to QBO and locate the transaction that you created in Turvo. Ensure that the invoice number in Turvo and the QBO sales transactions column ID match.

  3. In QBO, record payments for the carrier and customer invoices.

  4. Go to Turvo and ensure that the invoices are marked as paid. Then navigate to the customer and carrier blocks and expand the payments row to verify that the the transactions synced from QBO.

  5. Now, void and delete the payments in QBO.

  6. Confirm that the payments are deleted in the customer and carrier blocks in Turvo.

  7. In Turvo, leave the customer and carrier invoices in the Approved status and archive them.

  8. Navigate to QBO and confirm that the invoices have been removed.

  9. In Turvo, update the shipment status to Canceled

Answers to Frequently Asked Questions for QBO

  • EFS/Comcheck will sync to QuickBooks as checks.

  • QBO doesn’t allow zero (0) amount transactions. There should be at least one cost line item defined for both customer and carrier.

  • QBO is the source for an Aging Report, Turvo provides an AP/AR report.

  • If you make changes to your Chart of Accounts in QBO, you need to update your mappings in Turvo's Integration hub to include the cost items that you made changes to. 
  • Carrier information that syncs from Turvo to QBO as the Vendor is pulled from the Pay to fields is available in the Details tab of the carrier’s profile.
    • To locate and fill in the Pay to information, navigate carrier’s Turvo profile > Details tab > Payments section > Pay to.

      Note: If the Pay to fields are not enabled for your tenant, reach out to your Turvo representative. The ability to sync factoring information to your QBO must also be enabled for your integration. Reach out to your Turvo representative for more details.
  • When paying a carrier who uses a factoring company via paper check, those users pulling factoring company information from Turvo via the Pay to field will be able to have the name of the Vendor in QBO be the carrier, but the pay to on the check will be the factoring company.
  • Holding Account: A temporary account used when an advance is issued or a prepayment. This can be optional in your accounting process but is mapping requirement in the Integration hub.

Troubleshooting Your QBO Integration

Broken QBO connections are indicated in Turvo by a red warning icon instead of the QBO icon. If you have a broken QBO connection, double-check your error codes by navigating to the Accounting Sync Analytics report and checking the descriptions. 

User deletion warning

Important Note: If the user that created your app in the Intuit Developer Dashboard is deleted from QBO or changes their password, the connection between Turvo and QBO breaks. It is important to create your app with a universal user to avoid this error.

If the user changes their password: 

  1. Navigate to the OAuth 2.0 Playground.
  2. Within the Step 1 section of the page, select the app from the drop-down menu and enter com.intuit.quickbooks.accounting for the scope to be selected. 
  3. Click Get authorization code.
  4. In the Step 2 section of the page, click Get tokens and copy the access_tokens and refresh_tokens.
  5. Once the tokens are acquired, contact Turvo Support with the tokens, your Client ID, and Client secret.

If the user is deleted from QBO:

  1. Disconnect the existing QBO integration.
  2. Create a new Intuit app.
  3. Create a Turvo Support Ticket and share the new credentials with Turvo Support. Turvo then updates the credentials and the integration will now work as expected.

Quickbooks error code 6000 for carrier invoices

When you experience the QBO 6000 error code for a carrier invoice, follow these steps to resolve the error:

  1. Update and replace all Quickbooks Online Carrier Cost line items in Integration hub that are mapped as Accounts Payable (A/P) Account Type and Detail Type to a different entity type that is not restricted by QBO.
    If you need guidance on a specific entity type to map, this QuickBooks article outlines how to map general account ledgers in QBO.
  2. After all carrier cost line items in Integration hub have been updated from Accounts Payable in the Account Type and Detail Type, archive the carrier invoice that you experienced the error in.
  3. Test the updated mapping by creating a new $1.00 carrier invoice for the shipment to successful sync and initiate the green QBO Integration hub logo.

Was this article helpful?

0 out of 0 found this helpful