Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowWould like to run the Item Summary/Items Sold report, but also want to include the current (post-sales) inventory in the report for select date/time period for frequent/daily restocking. Have attempted to create a custom report, but not having much luck. Is there a canned report that can pull this info together, based on a selected date/time range, or any suggestions on how to create as a custom report?
Thanks for sharing what you'd like to achieve in QuickBooks, leahhag.
We're unable to combine the sales and inventory in one report. Though, we can run the Sales by Item Summary report for the sold items and the Inventory Valuation Summary report for the current inventory. This way, you'll be able to see all the desired information.
Here's how to view the sold items:
To run the Inventory Valuation Summary report, I suggest following these steps:
Additionally, you can memorize the customized reports in QuickBooks Desktop. Doing so helps you easily access them in the future.
You can always ask for assistance here in the Community. We'll be around to lend a helping hand.
Thank you! I think we might be able to use the (a modified) Inventory Valuation report since it does appear to allow us to select the day/date of when items were sold, but is there a way to specify a time range during which the items were sold, vs. just day or date range? If we run this report a few times a day, we'd like to be able to select times such that we are not re-running same info. Thank you!
I'm glad you can use the recommended report, leahhag.
However, adding a time on when the items were sold is unavailable. You can only add the date on the report.
Check out these report related articles for more reference:
If you have other questions about reports in QuickBooks Desktop, don't hesitate to leave a reply here.
Ok, thank you. Is there a way to suggest/request such a report for future? I have seen similar requests - with similar answers - that don't quite seem to get what we want, so it seems a report such as this would be valued by and useful to many. Thank you!
Thanks for getting back to us, leahhag.
I will send feedback to our Developers team about this report. They'll review it and may be added as one of our future updates.
Know that this suggestion helps us to provide a more user-friendly program. If you have other ideas to improve the system, don't hesitate to post them here.
The Community team is up 24/7 to hear from you soon.
Thank you and, keep safe!
Hello - I'm just following up to this exchange to see if there have been any updates/changes that might allow users to run an "Items Sold" report that includes remaining inventory, and allows user to select date/time ranges. Thank you!
Hi there, @leahhag. Thank you for following this thread to check some updates.
The ability that allows users to run an Item Sold report that includes remaining inventory and choose date/time ranges is unavailable for now. I know how beneficial it is to pull up this kind of report for your business.
In the meantime, I encourage submitting feedback to our product development team. This way, they'll know that this is crucial to business owners like you and a chance to enhance your experience in future updates.
Here's how:
In addition, feel free to check out these related articles for more reference:
If you have other concerns with product updates regarding inventory reports, please let me know. I'm always here to hear you out and help. Stay safe, and have a happy weekend!
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.