Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Your Little Gem
Level 1

Report by vendor and project

Hi

I am using Desktop Construction Pro and I want to run a report detailing what each individual vendor/subcontractor has been paid on each project and have it broken down by vendor/subcontractor.  The only one I can find breaks it down by type but I want each individual vendor/subcontractor grouped together, not the type.  I get this in Purchases by item detail.  I have tried many different places to find it and manipulate in 

7 Comments 7
Kristine Mae
Moderator

Report by vendor and project

I can think of a different report, Your Little Gem. You can pull up the Purchases by Vendor Detail report.

 

It will show you the transactions per vendor/subcontractor with amounts and balances. Let me guide you:

  1. Click Report.
  2. Go to Purchases.
  3. Select Purchases by Vendor Detail.

You can also customize the report so you can focus on the details that matter to you.

 

Don't hesitate to let us know if you need more help. We're just one comment away. Take care!

Your Little Gem
Level 1

Report by vendor and project

Thanks for he reply.

 

This does not allow me to filter it by the project and a specific vendor/subcontractor though.  It's still too simple.  From there I need to then choose a specific project and the costs associated with a specific vendor/subcontractor in that project.

 

Any thoughts?  Thanks.

Your Little Gem
Level 1

Report by vendor and project

Thank you but this is still too simple a report.

 

From there I need to filter a specific job/project/customer and within that project filter a specific vendor/subcontractor who has costs within that project.  Basically I need to see how much each vendor/subcontractor has been paid on each job/project/customer.

 

Because it is a vendor report it won't let me filter a job/project/customer so it doesn't break it down into a specific job/project/customer.

 

Any thoughts?  Thanks.

MirriamM
Moderator

Report by vendor and project

Thanks for keeping us updated on the results, @Your Little Gem.

 

In QuickBooks Desktop (QBDT), we have the Custom Transaction Detail report that you can run. You can customize it to display detailed vendor expenses totalled by Customer: Job. 

 

Here's how:

1.Go to the Reports menu at the top.

2. Select Custom Reports, then Transaction Detail on the drop-down.

3. In the Display tab:

   a. Enter the appropriate date range.

   b. In the Columns section, put a checkmark beside Source Name to add it to your columns and uncheck Name to remove it from the list.

   c. On the Total By drop-down, choose Customer.

4. Go to the Filters tab.

5. On the Choose Filter page, select Transaction Type.

6. Select the transaction type associated with the Vendor purchases.

7. Click OK.

 

For more information about this process, check out this article and scroll down to Vendor expenses by Customer:jobCustomize vendor reports.

 

To learn more about how to get reports based on your business needs, here's a link that you can visit: Customize vendor reports

 

In case you want to memorize this report, feel free to check out this resource for the detailed steps and information: Create, access, and modify memorized reports.

 

Feel free to post for any questions you have. I’ll be here to help. Have an awesome day ahead!

Your Little Gem
Level 1

Report by vendor and project

This is fantastic thank you MirriamM.

One last thing though - can I set a sub-total at the end of each source name within the report so I don't have to run a separate report for each source name?

Basically so one report for the Customer shows all my selected transactions in one report with a sub-total for  each Source Name being my vendor/subcontractor etc.

 

Thanks.

ZackE
Moderator

Report by vendor and project

Thanks for following up with the Community, Your Little Gem.
 

I can certainly understand how an ability to customize transaction detail reports with a sub-total at the end of each source name could be useful and have submitted a suggestion about it as of today.
 

You can also submit your own feature requests while signed in.
 

Here's how:

  1. In your top menu bar, go to Help, Send Feedback Online, then Product Suggestion....
  2. Choose a Type of Feedback and Product Area (optional) from the available drop-down menus.
  3. Enter any suggestions/feedback in your Here is my suggestion: field.
  4. If you'd like, include your name/email in the My name is: (optional) and My e-mail address is: (optional) fields.
  5. Select Send Feedback.

 

Your feedback's definitely valuable to Intuit. It will be reviewed by our Product Development team and considered in future updates. You can stay up-to-date with the latest news about your product by reviewing Intuit's Product Updates webpage.
 

As a workaround, you can export reports as Excel files and further customize them in Excel.
 

Please feel welcome to send a reply if there's any additional questions. Have an awesome day!

ConstGurl
Level 1

Report by vendor and project

Quickbooks is ridiculous with it's reports. Doesn't anyone realize there are tons of clients that use job cost to track projects. The reporting is incapable of providing the necessary reports. I can get a list of transactions by a single vendor but not by job, I can get them by a single job but not by a single vendor. I agree with the other client who said this should be a very simple report. Quickbooks needs to do a better job and catering to job cost clients. This is all throughout the reporting. Miserable!!

Next year we're changing software.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us