I have created a custom report that lists all bills along with the assigned customer/project, if applicable. The report lists each bill three times. Why?

mark.dale · ‎September 01, 2025

The report data is correct. Some custom fields are included. The bills are in all statuses, and for all customers/projects. The goal of the report is to confirm that I did not forget to assign a customer/project to a bill. Why is every bill grouped as a collection of three rows?

Ethel_A

I need to confirm some key details regarding the custom report you created, Mark.

Could you let me know the specific report you generated and customized to display the assigned project? Additionally, providing a screenshot that includes the three rows for each bill would be greatly helpful to ensure we can offer an effective resolution to your issue.

In the meantime, you can also run a Transaction List by Supplier report and customize it to show the assigned project for each bill.

Here's how:

From the left menu, go to Reports and choose Standard reports.
Enter the Transaction List by Supplier in the search box.
Choose the Report period.
Click the Filter icon and add the Transaction type. it should be equal to Expense.
Hit the Columns icon and add the Project.

You can save the customized report showing bills with their assigned projects by clicking the Save Customization button.

Don't hesitate to comment below for the additional details and if you have additional questions about running reports in QuickBooks Online.

Topics

Training

Community

Resources

I have created a custom report that lists all bills along with the assigned customer/project, if applicable. The report lists each bill three times. Why?

I have created a custom report that lists all bills along with the assigned customer/project, if applicable. The report lists each bill three times. Why?

Need to get in touch?