Skip to main content
J
JACDN
February 1, 2019
Solved

Purchase by Vendor, listing the associated Job, QB Enterprise

  • February 1, 2019
  • 2 replies
  • 0 views

Occasionally we have a bill entered where someone has failed to link it to a job.

To try catch this, I need to generate a list of vendor purchases and find out which ones are NOT linked with a job.

Running a report by job will not show this, since it will not include any bills not associated with a job. Running purchases by vendor detail it does not give an option of a "job" column.

Is there anything at the accountant level that will show this? 

Best answer by Rose-A

Thanks for dropping by, JACDN.

I'd be happy to help you run a report that includes the job in QuickBooks Desktop.

 

You can pull up and customize the Purchase by Item Detail report to show the job column.

 

Here's how:

  1. Click Report at the top menu bar.
  2. On the drop-down list, go to Purchases and select Purchases by Item Detail.
  3. Click Customize Report.
  4. Under Columns, search and select for Name and Source Name.
  5. Hit OK.
  6. Go to Filters.
  7. Under Filter, search and select for Name.
  8. Under the drop-down list, choose All customers/jobs.
  9. Hit OK.
  10. Source Name is for vendor's name, while the Name column is for the job.

See screenshots below.

 

You may find this article helpful: https://quickbooks.intuit.com/community/Employees-and-payroll-taxes/Use-Check-or-Deposit-Detail-Reports-to-show-transaction-links/m-p/202002.

 

Let me know how it goes, I'll be around if you need more help with running a report in QuickBooks Desktop.

 

 

2 replies

Rose-A
Rose-AAnswer
February 1, 2019

Thanks for dropping by, JACDN.

I'd be happy to help you run a report that includes the job in QuickBooks Desktop.

 

You can pull up and customize the Purchase by Item Detail report to show the job column.

 

Here's how:

  1. Click Report at the top menu bar.
  2. On the drop-down list, go to Purchases and select Purchases by Item Detail.
  3. Click Customize Report.
  4. Under Columns, search and select for Name and Source Name.
  5. Hit OK.
  6. Go to Filters.
  7. Under Filter, search and select for Name.
  8. Under the drop-down list, choose All customers/jobs.
  9. Hit OK.
  10. Source Name is for vendor's name, while the Name column is for the job.

See screenshots below.

 

You may find this article helpful: https://quickbooks.intuit.com/community/Employees-and-payroll-taxes/Use-Check-or-Deposit-Detail-Reports-to-show-transaction-links/m-p/202002.

 

Let me know how it goes, I'll be around if you need more help with running a report in QuickBooks Desktop.

 

 

    qbteachmt
    qbteachmt
    February 2, 2019

    If you installed your Enterprise program as the Contractor or Accountant Edition, you would have the report for "Expenses not assigned to job." Right now, your closest reporting tool is P&L by Job, then Remove the Job filter to see a new column = No Name. Double-click the Total Expenses there to see all the Not Job Tracked entries.

    Terms & ConditionsAccessibility statement