QuickBooks HelpQuickBooksHelpIntuit

View key performance indicators for your business

by Intuit•37• Updated 4 days ago

The KPI Scorecard in QuickBooks Online Advanced and Intuit Enterprise Suite provides a centralized view of your business's key performance indicators (KPIs). Use this feature to monitor real-time data, identify trends, and track progress against goals to make informed business decisions.

Availability

This feature is available for QuickBooks Online Advanced and Intuit Enterprise Suite. Both include more than 80 KPIs in the KPI library designed to monitor growth, profitability, liquidity, and other strategic areas.

Feature overview

The KPI Scorecard empowers you to monitor critical KPIs in real-time, providing a complete overview of your business's financial health and performance. Here's a feature breakdown:

  • KPI Scorecard: a Key Performance Indicator (KPI) scorecard to track various metrics related to targeted growth, profitability, cash flow, liquidity, efficiency, and others.
  • Historical Comparison: identify growth trends and analyze individual KPI performance by comparing with historical periods.
  • KPI library: access a robust library of the most commonly used KPIs to evaluate organizational performance.

See your KPI Scorecard

You must be signed in as a Primary admin, Company admin, or Standard all-access role to access the KPI Scorecard.

  1. Go to Reports Icon image of the Reports menu., then KPIs (Take me there).
  2. Select the Consolidated or Company tab to track KPIs across all of your companies, or just a single one. (Intuit Enterprise Suite only)
  3. On the KPIs page, you can view the different KPIs available to you. For example:
    • Revenue
    • Cost of Goods Sold (COGS)
    • Total Expenses
    • Gross Profit
    • Gross Profit Margin
    • Net Profit
    • Net Profit Margin
    • Operating Expense
    • Net Operating Income
    • Operating Margin
  4. Use the Period and Compare with dropdown menus to compare current KPIs to historical periods and view the variance.
  5. Select any KPI row to expand details and see a visualization of the data.

Add or remove KPIs

Access the KPI Library to browse a catalog of predefined key performance indicators. It's a standardized set of metrics that you can easily select and add to your scorecard. You can also connect your CRM apps, such as Monday.com, Hubspot, and Salesforce, to track KPIs using data from those platforms.

  1. Go to Reports Icon image of the Reports menu., then KPIs (Take me there).
  2. Select the Manage KPIs button.
  3. Use the KPI category list to browse KPIs, or use the search bar to find specific KPIs.
  4. For any KPI metric you want to add, select + Add to scorecard. If you've already added the KPI metric and want to remove it, you'll instead see X Remove from scorecard.
  5. For KPIs that pull data from a CRM app, you’ll instead select Connect data source. This takes you to the Find integrations page where you can choose a suggested integration. Follow on-screen steps to set up the connection, then return to the KPI library where you can then select + Add to scorecard.
  6. When finished, select Done to return to the KPIs page. You'll see your newly added metrics listed.

Create custom KPIs

You can add custom KPIs by defining formulas or using manual data input.

  1. Go to Reports Icon image of the Reports menu., then KPIs (Take me there).
  2. Select the Manage KPIs button.
  3. Select Create KPI.
  4. Enter a KPI name and Description, and choose a KPI category.
  5. From the Unit of measure dropdown, choose Currency, Percentage, or Number.
  6. From the Variance dropdown, choose either Higher values are better (e.g., revenue) or Lower values are better (e.g., expenses).
  7. Choose a KPI calculation method:
    • Build a formula: This option allows you to build your KPI using pre-set values, such as KPIs, active chart of accounts, and external data from CRM apps. You can also set specific time periods for each metric in your formula. Select the Formula field to see a list of values to build from.
      Image of the custom KPI creator in Intuit Enterprise Suite.
    • Enter manually: This option allows you to manually enter data points to track. Choose an Alert frequency for when to receive for missing data points, then add your data points to the available time periods.
      Image of the custom KPI creator in Intuit Enterprise Suite.
  8. From the Chart type dropdown, choose Line chart or Bar chart to preview the data visualization.
  9. When finished, select Save and close.

Related links

QuickBooks Online Advanced