QuickBooksHelpIntuit

Common custom reports in QuickBooks Online

SOLVED•by QuickBooks•3•Updated 4 days ago

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

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

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

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

Go to Business overview and select Reports (Take me there).
Search for, and open a Transaction List by Date report.
Set the date range.
From the Group by dropdown menu, select either Customer or Supplier. You can also select Employees as a group.
Select Customise.
In the window, select the Filter ▼ icon to open the section.
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.
To see specific customers or suppliers, select them from the Name dropdown menu.
When you're ready, select Run report.

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

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

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

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

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

There's a special report that compares your budgets and with what you actually spent.

You can customise 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:

Go to Business overview and select Reports (Take me there).
Search for and open a Profit and Loss report.
Select Customise and in the window, select the Rows/Columns ▼ icon to open the section.
From the Columns dropdown, select Years, Fiscal Years or Calendar Years. You can also select days, weeks, or quarters to get other time periods.
Select the Previous year checkbox.
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.
When you're ready, select Run report.

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

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

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

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

Learn more about custom reports

Share your tips and learn from others in our community.

Was this helpful?

You must to vote, reply, or post

QuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

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