Skip to main content
February 24, 2024
Question

Transaction List Report by Project

  • February 24, 2024
  • 1 reply
  • 0 views

Hi, 

 

Bills are entered using the expense category and description field allocated to a project/customer in quickbooks online. 

 

How can I pull a transaction list filtered by bills that has the description field from the bill and also lists the project/customer for each line item?

 

Thanks

1 reply

February 25, 2024

Hello there, @JD40958. Let me lay down the steps with the report that filters bills entered as expenses allocated to a project or customers. 

 

We can use the Transaction list with Splits report to show the category used in a bill. To show projects or customers, Customize and filter the dates, names of projects and customers. So, once we run it, it'll show the report you've wanted to achieve. 

 

Here's how:

 

  1. Go to Report, then type Transaction list with splits in the search bar.
  2. Click Customize, then the drop-down button under the Report period, and Filter the date.
  3. Select the Filter, and check the Name of the project, Customer, and Vendor you want to run.
  4. Tick the Transaction Type drop-down and check Bill.
  5. Click Run report.

 

By doing this, you'll pull up a report that shows the category and description field allocated to a project/customer.

 

Additionally, I've added this article for your reference if you want to memorize reports so you can find, run, export, and edit or delete them from your custom reports once you save the customization: Memorize reports in QuickBooks Online.

 

Do not hesitate to reply to this thread should you need additional assistance running reports in QuickBooks Online. Stay safe.