I need to create an AP Report by customer Job?

Thank you!

Hello dorothys-azapb-c,

You are most certainly welcome! Remember, if you have any concerns or questions in the future, we are here to help! Do enjoy the rest of your day.

I recently found this thread. Unfortunately it doesn't answer the question.

I need to be able to run a report of Open AP by Job. 

If there is not a filter option for the Customer/Job on the AP reports, how am I supposed to get this report?

This is a very sloppy oversight on the part of Intuit to not include this Filter option.

I have the information and workaround you need to run a report that associates Accounts Payable (A/P) transactions with a specific project or job in QuickBooks Online (QBO), @FL_Guru.

To begin with, it's important to note that while the standard A/P report allows filters for vendor, location, terms, and due date, it does not offer an option for Customer/Job.

However, you can consider generating the Transaction Detail by Account report and filtering it by Customer as a workaround. This way, you can track AP transactions associated with your projects in QBO.

Here’s how to do that:

1. Hover over the Reports menu and search for Transaction Detail by Account.
2. Click on the Filter option within the report.
3. Filter Customer and select the specific project or job name for which you want to generate the report.
4. 

    

Additionally, you can filter the report to show only A/P transactions, which will help you monitor aging and paid transactions related to your projects.

For your convenience, consider memorizing this customized report so you can easily access it in the future. 

If you have any further questions about filtering reports in QBO, please don’t hesitate to click the Reply button below. We're here to help you get the most out of QuickBooks and ensure your reports meet your needs.