Documentation
Release Notes
Rev.io Developer Portal
Documentation
Release Notes
Rev.io Developer Portal
Getting Started
Customer Module
Service Module
Inventory Module
Scheduling Module
Billing Module
Reports Module
Admin Module
Admin Module OverviewManaging Permissions, Roles, and User Groups
API Management
Custom Fields Manager
Customer Portal
FTP Sites
Integrations Library
Integrations Library: OverviewIntegrations Library: Summary TabIntegrations Library: Marketplace Tab Integrations Library: Instances TabIntegrations Library: Executions TabIntegrations Library: Logs TabIntegrations Library: Attachments TabIntegrations Library: TroubleshootingIntegrations Library: Data Sync & MappingQuickBooks Online Integration: OverviewQuickBooks Online Integration: ConfigurationGoogle & Outlook Integrations: OverviewGoogle Integration: Admin ConfigurationGoogle Integration: User ConfigurationOutlook Integration: Admin ConfigurationOutlook Integration: User ConfigurationPax8 Integration: OverviewPax8 Integration: ConfigurationAcronis Integration: OverviewAcronis Integration: ConfigurationSlack & Teams Integrations: OverviewSlack & Teams Integrations: Admin ConfigurationSlack & Teams Integrations: User Configuration
Quote Templates
Roles & Permissions
System Settings
User Groups
User Management
Workflows
Rev.io Community
Rev.io Mobile App
Customer Portal
Video Training Library
How-To Guides

QuickBooks Online Integration: Configuration

Complete the steps below to configure the QuickBooks Online integration.

NOTE: Before you begin this configuration, complete the following to ensure you have everything you need to complete the setup.

  • Contact Rev.io to ensure you have an API user created in your instance. 
  • Make note of the API user's Login Name from their user profile in Rev.io and the password.
  • Make note of the following information for product mappings.
     - Rev.io Product ID for unmatched items from QBO.
     - QBO Item ID for unmatched one-time products from Rev.io.
     - QBO Item ID for unmatched recurring products from Rev.io.
     - QBO Tax Code to use when creating invoices from Rev.io.
     - QBO Class to assign to invoice line items from Rev.io.
  1. Click Admin on the sidebar menu and select Integrations Library.

     
  2. Click the Marketplace tab.

     
  3. Locate and select the QuickBooks & Rev.io Data Sync Integration in the Accounting & Finance section.

     
  4. Click the Configure button.

     
  5. The Initial Configuration section is automatically populated. Click the Next button.

     
  6. Click the Connect to QuickBooks button. You will be redirected to QuickBooks to login with your credentials.

      
  7. Enter your credentials to log into your QuickBooks account. Once the authorization is successfully completed, close the QuickBooks tab in your browser and return to Rev.io PSA.

     
  8. If your connection was successful, the status circle in the QuickBooks Online section will be green. 

     
  9. Scroll down to the Rev.io REST API section. Enter the Username and Password for the Rev.io user you created for API configurations. NOTE: Be sure to use the Client Code Info provided in this section as part of your username in the format loginname@clientcode. Then, click the Next button.

     
  10. The invoice configuration options display already configured. If you'd like to make any customizations, review the options on this screen and make any adjustments as desired. Then, click the Next button.

     
  11. Create mappings for your payment methods by clicking the Add to Payment Method Mappings button. Then, select a Rev.io Payment Method option from the dropdown and the corresponding QuickBooks Payment Method. Repeat this process for as many payment methods as you support and then click the Next button.

     
  12. Create mappings for your product types by clicking the Add to Product Type Mappings button. Then, select a QuickBooks Item Type option from the dropdown and the corresponding Rev.io PSA Product Type. Repeat this process for as many product types as you support and then click the Next button.

     
  13. The payment configuration options display already configured. If you'd like to make any customizations, review the options on this screen and make any adjustments as desired. Then, click the Next button.

     
  14. Create mappings for unmatched items between QuickBooks Online and Rev.io by selecting the respective options from the dropdowns in this section as shown below. Then, click the Next button.
     - Rev.io Product ID for unmatched items from QBO.
     - QBO Item ID for unmatched one-time products from Rev.io.
     - QBO Item ID for unmatched recurring products from Rev.io.
     - QBO Tax Code to use when creating invoices from Rev.io.
     - QBO Class to assign to invoice line items from Rev.io.

     
  15. Select a Rev.io Bill Profile to assign to new customers created in Rev.io from QuickBooks online. Review the remaining sync options on this screen, make any adjustments as desired, and click the Finish button.

     
  16. The integration will sync your customers and products. Do not leave this page while the sync is running. If you need to work on something in the system while the integration syncs, open Rev.io in another tab. See the Integrations Library: Data Sync & Mapping article for more information about mapping your customers and products for QuickBooks Online.

Was this article helpful?

Powered by Product Fruits