QuickBooks HelpQuickBooksHelpIntuit

View key performance indicators for your business

by Intuit• Updated a day ago

The KPI Scorecard in QuickBooks Online Advanced 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. 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. and select KPIs (Take me there).
  2. On the KPI Scorecard page, you can view the different KPIs available to you. For example:
    • Revenue
    • Cost of Goods Sold
    • Total Expenses
    • Gross Profit
    • Gross Profit Margin
    • Net Profit
    • Net Profit Margin
    • Operating Expenses
    • Net Operating Income
    • Operating Margin
  3. Use the Period and Compare with â–Ľ dropdown to compare current KPIs to historical periods and view the variance.
  4. Select any KPI row to expand details and see a visualization of the data.
  1. Go to Reports Icon image of the Reports menu. and select KPIs (Take me there).
  2. On the KPI Scorecard page, you can view the different KPIs available to you. For example:
    • Revenue
    • Cost of Goods Sold
    • Total Expenses
    • Gross Profit
    • Gross Profit Margin
    • Net Profit
    • Net Profit Margin
    • Operating Expenses
    • Net Operating Income
    • Operating Margin
  3. Use the Period and Compare with â–Ľ dropdown to compare current KPIs to historical periods and view the variance.
  4. 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 catalogue 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. and select KPIs (Take me there).
  2. Select the Manage scorecard.
  3. Use the KPI category list to browse KPIs, or use the Magnifying glass search icon.Search bar to find specific KPIs.
  4. For any KPI metric you want to add, select Add or Add to scorecard from the Actions column. If you've already added the KPI metric and want to remove it, you'll instead see Remove from scorecard or Remove.
  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 or + 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. and select KPIs (Take me there).
  2. Select Create KPI.
  3. Enter a KPI name and Description, and select a KPI category.
  4. From the Unit of measure â–Ľ dropdown, select Currency, Percentage, or Number.
  5. From the Variance â–Ľ dropdown, select either Higher values are better (for example, revenue) or Lower values are better (for example, expenses).
  6. Select a KPI calculation method:
    • Build a formula: This option lets 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. Select 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.
  7. From the Chart type â–Ľ dropdown, select Line chart or Bar chart to preview the data visualization.
  8. When finished, select Save and close.

Related links