Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowHi
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
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:
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!
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.
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.
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:job: Customize 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!
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.
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:
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!
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here