QuickBooks HelpQuickBooksHelpIntuit

Common custom reports in QuickBooks Online

SOLVEDby QuickBooks20Updated 1 week ago

Learn specific ways to customize your reports to get awesome insights.

Your financial reports tell you a lot about your business. Customize your reports to focus on specific details and learn even more.

Here are a few ways you can customize reports to fit your specific needs.

In this article, you'll learn how to:



See all customer or supplier payments

Add filters to Transaction List reports to see transactions for your customers or suppliers.

  1. Go to Business overview and select Reports (Take me there).
  2. Search for, and open a Transaction List by Date report.
  3. Set the date range.
  4. From the Group by dropdown menu, select either Customer or Supplier. You can also select Employees as a group.
  5. Select Customize.
  6. In the window, select the Filter ▼ icon to open the section.
  7. From the Transaction Type dropdown, select Payment. You can also select other transaction types you want to see on the report. If you want to see everything, select All.
  8. To see specific customers or suppliers, select them from the Name dropdown menu.
  9. When you're ready, select Run report.


Compare income or expenses by customer or supplier

Want to know who's bringing in the most income? You can easily filter income or expenses by customers or suppliers.

Run an income and expense report for all customers or suppliers

  1. Go to Business overview and select Reports (Take me there).
  2. Search for and open a report, like a type of Profit and Loss report.
  3. Select Customize.
  4. In the window, select the Rows/Columns ▼ icon to open the section.
  5. From the Columns dropdown, select Customers or Suppliers. Note: These options are not available for all reports.
  6. When you're ready, select Run report.

The report columns show your income or expenses for each customer or supplier.

Filter a report for specific customers or suppliers

  1. Go to Business overview and select Reports (Take me there).
  2. Search for and open a report.
  3. Select Customize, in the window, select the Rows/Columns ▼ icon to open the section.
  4. From the Columns dropdown, select Customers or Supplier. Note: These options are not available for all reports.
  5. Select the Filter ▼ icon to open the section.
  6. From the Customer or Location or Supplier dropdown, select the checkboxes for the specific customers or suppliers you want to include.
  7. When you're ready, select Run report.

The report columns only show your income or expenses for the customers or suppliers you selected.



Compare your budgets and actual spend



Compare different time periods for the same report

You can customize report columns to show different report periods. This makes it easy to do quick comparisons.

In this example, let's compare different years on a Profit and Loss report. You can use these steps for other reports and time periods:

  1. Go to Business overview and select Reports (Take me there).
  2. Search for and open a Profit and Loss report.
  3. Select Customize and in the window, select the Rows/Columns ▼ icon to open the section.
  4. From the Columns dropdown, select Years, Fiscal Years or Calendar Years. You can also select days, weeks, or quarters to get other time periods.
  5. Select the Previous year checkbox.
  6. If you want to see your numbers as percentages of your account totals, select one of the % options. This makes it easy to understand the impact of the numbers.
  7. When you're ready, select Run report.


Make reports easier to understand

There are several filters that make reports easier to read. This is especially helpful if you send report to others.

See items as a percentage of income

This lets you quickly see which products or services have the biggest impact on your business.

  1. Go to Business overview and select Reports (Take me there).
  2. Search for and open a report.
  3. Select Customize then Filter ▼ icon to open the section.
  4. Select Product/Service checkbox.
  5. Select the Rows/Columns ▼ icon to open the section.
  6. Select to check the % of Income checkbox.
  7. When you're ready, select Run report.

Note: Instead of products and services, you can also select your customers, suppliers, or even employees.

Show negative numbers in red

  1. Go to Business overview and select Reports (Take me there).
  2. Search for and open a report.
  3. Select Customize then General ▼ icon to open the section.
  4. Select to check the Show in red checkbox.
  5. When you're ready, select Run report.

Change or remove your company name

To simplify your reports, you can remove or change unnecessary info.

  1. Go to Business overview and select Reports (Take me there).
  2. Search for and open a report.
  3. Select Customize then Header/Footer ▼ icon to open the section.
  4. Select and uncheck the boxes for any info you don't need.
  5. When you're ready, select Run report.


Learn more about custom reports


Share your tips and learn from others in our community.

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