QuickBooks HelpQuickBooksHelpIntuit

Create charts to see your business performance in QuickBooks Online Advanced and Accountant

SOLVEDby QuickBooks1Updated 1 week ago

Learn how to build charts to see your business performance in QuickBooks Online Advanced and QuickBooks Online Accountant.

If you're a QuickBooks Online user, check out our guide on building these charts in QuickBooks Online.

Create custom charts to track what matters most to your business. You choose the metric and the specific data the chart will include, like products, services, and locations. For some charts, you can even compare your numbers to other businesses in your industry.

Here’s how to work with custom charts. Note: You need to be an admin user to use this feature.

Step 1: See your charts in the Performance centre

The Performance centre shows all your charts in one place. To see it:

  1. Go to Reports (Take me there).
  2. Select the Performance centre tab.

When you first visit the performance centre, QuickBooks has built-in charts ready for you. You can customise them to meet your needs.

Step 2: Create a new chart

You can track one metric in each chart, and create up to 25 charts. You can make charts to track these metrics:

  • Expenses
  • Revenue
  • Gross profit
  • Net profit
  • Accounts receivable
  • Accounts payable
  • COGS (Cost of goods sold)
  • Cash flow
  • Current ratio
  • Quick ratio

Create a quick chart

Want to create a chart for a common metric like revenue or expenses over time? Select Quick add charts and pick a metric from the list. The chart appears instantly on your dashboard.

  • To change the time period, select the current time period, then select an option from the dropdown.
  • To go deeper into the data, select the vertical ellipsisVertical ellipses icon. and then Edit widget. You can group the data by categories, apply filters, or compare the results to a previous time period. For more details, see the steps below for creating a chart from scratch.

Create a custom chart from scratch

  1. Select + Add new chart.
  2. Select the metric you want this chart to track and then select Continue. This opens a customisation window. As you make selections, the preview updates to show you exactly what the chart will look like.
  3. Give your chart a name.
  4. Select the type of chart, such as Trend line, Vertical bars, Pie chart, or Stacked bars. These options vary based on the metric.
  5. In the Time period dropdown, select the time period you want to track.
  6. In the Group by dropdown, select the category you want to group your data by. You can group by classes, suppliers, locations, or other categories. In the Select from multiple dropdown, select the items in the category you want to track. These are what appear in the bars or lines of the chart.
  7. If you want to see only data from a specific category, select it in the Filter by dropdown. Then use the Select from multiple dropdown to narrow it to items in that category.
    Tip: The Group by dropdown determines the type of data the chart will track. The Filter by dropdown is where you decide what specific data is included. For instance, you may only want to see data when it applies to specific classes or locations.
  8. To compare the results over different time periods, select Compare. Then select Previous period or Previous year same period. For some charts, you can also compare against a budget or goal.
  9. When you're done, select Add to Dashboard.

When you go back to the performance centre, you'll see your new chart.

Next steps: Edit or delete a chart

Success metrics always need fine-tuning. You can adjust your charts at any time:

  1. Go to Reports (Take me there) and select Performance centre.
  2. Find the chart you wish to edit or delete.
  3. Select the vertical ellipsis ⋮ on the chart.
  4. To edit a chart:
    1. Select Edit widget.
    2. Make the changes you need, then select Save.
  5. To delete a chart:
    1. Select Delete widget.
    2. Select Delete to confirm.

Was this helpful?

You must sign in to vote, reply, or post

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this