QuickBooks HelpQuickBooksHelpIntuit

Connect your CRM app to get sales insights

by Intuit• Updated about 17 hours ago

Get a complete view of your business by bringing your sales data into QuickBooks Online Advanced. Connect your CRM app and see key performance metrics like win rate, pipeline value, and deal size alongside your financial data.

Data flows one way from your CRM into your Intuit product. Your data in Monday.com, HubSpot, and Salesforce stays exactly as it is. Changes made in Intuit products won’t affect anything in your CRM app.

Supported CRM apps

You can connect any of these CRM apps:

  • Monday.com: Sync leads, deals, customers, and products
  • HubSpot: Sync leads, deals, customers, and products
  • SalesForce: Sync leads, deals, customers, and products

What you can track

Once you connect your CRM app, you can track these key performance indicators (KPIs) in QuickBooks Online Advanced:

KPIWhat it tells you
Lead Conversion RateHow many leads become customers.
Deal Win RateHow often you close deals.
Sales Pipeline ValueTotal value of deals in progress.
Deals in PipelineNumber of open opportunities.
Average Deal SizeTypical value of your deals.
Average Time to CloseHow long deals take to close.
Number of LeadsTotal leads in your pipeline.
Number of Won DealsDeals you've closed.
Number of Lost DealsDeals that didn't close.
Average Won Deal SizeTypical value of closed deals.
Average Lost Deal SizeTypical value of lost deals.
Lead Qualification RatePercentage of leads that were qualified.

Connect your CRM app

  1. Go to Reports Icon image of the Reports menu. and select KPIs (Take me there).
  2. Select Manage KPIs.
  3. Find and select a KPI with the Connect data source button.
  4. Select your CRM app (Monday.com, HubSpot, or Salesforce).
  5. Sign in to your CRM account and authorise the connection.
  6. Select the metrics you want to bring into QuickBooks Online Advanced.

We’ll recognise your default CRM boards and map them to the right categories. If you use custom boards, you can adjust the mappings to fit your setup.

You can also start from a dashboard template:

  1. Go to Reports Icon image of the Reports menu. and select Dashboards (Take me there).
  2. Find a CRM dashboard template.
  3. Select Connect data source to sign in to your CRM account and authorise the connection.
  4. Select the metrics you want to bring into QuickBooks Online Advanced.

Use your CRM data

After you connect, your CRM data appears in several places:

  • KPI Library: View and track individual metrics
  • Dashboards: Build custom views that combine sales and financial data
  • Custom KPIs: Create your own metrics using CRM variables

Your data refreshes every hour, so your dashboards stay up to date with your latest sales activity. Every synced record is tagged with its source, so you always know where your data came from.

How we use your CRM data

Contacts and Accounts

Contacts and Account (or Company) information are intelligently merged as Customers in QuickBooks. By default, only Contacts associated with Deals are synced as Customers in QuickBooks, however this can be expanded to all contacts if desired.

Auto Merge is by default turned on, which will automatically merge contacts if our system does not detect a duplicate. When duplicates are detected, the contacts will be available to review and merge into existing customer entries. When Auto-Merge is turned off, all contacts will need to be reviewed and manually merged in QuickBooks customers.

Deals

Deals (or Opportunities in some CRM apps) will be synced to QuickBooks only once their associated contact is synced and merged into QuickBooks customers. If Auto-Merge is turned off, this will require you to manually merge contacts before deals will appear.

Products

Products registered with your CRM can optionally be synced to your QuickBooks Products/Services list. This option is turned on by default, but can be turned off when connecting your CRM app.