cancel
Showing results for 
Search instead for 
Did you mean: 
YvonneI
Level 2

AP Reports with jobs

I have a client that want to run an AP report by vendor that list the customer/job the invoice was assigned to.  They want to see all the jobs a particular vendor has billed and been paid for.

 

I cannot locate the Customer/Job column in the customize report function.

 

Anyone else have any luck creating this in QBE 2019?

Thanks,

5 Comments 5
JasroV
QuickBooks Team

AP Reports with jobs

Hi there, @YvonneI.

 

AP reports only show you the lists the unpaid bills in accounts payable, grouped by when the bill was due.

 

However, if you want a report where it shows the name of the customer is billed for You can create a Custom Transaction Detail Report instead. Let me show you how:

  1. Go to Reports.
  2. Select Custom Reports and choose Transaction Detail.
  3. Click Customize Report and mark all columns you want to add under the Display tab and click OK.
  4. Click Customize Report and select the Filters tab.
  5. Select Transaction Type in the Filter field 
  6. Choose Multiple Transaction Types in the Transaction Type drop-down menu. 1.png
  7. Mark Bill and Item Receipt in the Select Transaction Types pop-up window and click OK.
  8. Select Vendor from the drop-down menu in the Total by field. 2.png

For more information on how to customize reports in QuickBooks Desktop. Feel free to check this article for references: Customize Reports in QuickBooks Desktop.

 

Also, feel free to visit our QuikcBooks Desktop Help articles page in case you want to learn more some "How do I" steps.

 

Feel free to leave a comment below if you have other concerns and questions, I'll be around to help.

YvonneI
Level 2

AP Reports with jobs

Thanks @JasroV  that was helpful.

 

Any idea how to run the report for a single vendor as opposed to the entire vendor list?

Thanks,

Alessandra_B
QuickBooks Team

AP Reports with jobs

Thank you for getting back to us, @YvonneI.

 

I'm glad that my colleague @JasroV was able to help you create a custom report to suite your needs.

 

To continue, you can filter your report to only show a specific vendor's transactions. Here's how:

  1. From your report, click on Customize Report.
  2. Select the Filter tab.
  3. In the Choose Filter section, click on Name.
  4. Choose the specific vendor from the drop-down.
  5. Click on OK to apply the filter.

Also, you can click on Memorize to save your custom report in the Memorized Reports List.

 

You can refer to the article provided above to better customize your reports.

 

As always, you can tag me in your comment if you have any other concerns. I'll be here to help. Have a good one!

YvonneI
Level 2

AP Reports with jobs

@Alessandra_B 

 

Thank you for the further input.

 

I will try this.

 

I appreciate your assistance.

 

Thanks,

MorganB
Content Leader

AP Reports with jobs

I'm glad you were able to get the assistance you were looking for here in the Community, YvonneI. Please don't hesitate to reach out if you have any other questions.

Need to get in touch?

Contact us