Purchase by Vendor, listing the associated Job, QB Enterprise

JACDN · ‎February 01, 2019

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?

Rose-A · ‎February 01, 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:

Click Report at the top menu bar.
On the drop-down list, go to Purchases and select Purchases by Item Detail.
Click Customize Report.
Under Columns, search and select for Name and Source Name.
Hit OK.
Go to Filters.
Under Filter, search and select for Name.
Under the drop-down list, choose All customers/jobs.
Hit OK.
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-Repo....

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

View solution in original post

Rose-A · ‎February 01, 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:

Click Report at the top menu bar.
On the drop-down list, go to Purchases and select Purchases by Item Detail.
Click Customize Report.
Under Columns, search and select for Name and Source Name.
Hit OK.
Go to Filters.
Under Filter, search and select for Name.
Under the drop-down list, choose All customers/jobs.
Hit OK.
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-Repo....

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

qbteachmt · ‎February 02, 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.

Topics

Training

Community

Resources

Purchase by Vendor, listing the associated Job, QB Enterprise