cancel
Showing results for 
Search instead for 
Did you mean: 
leahhag
Level 1

Report for (daily/range of time) sales and current inventory

Would 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?

7 Comments 7
CharleneMaeF
QuickBooks Team

Report for (daily/range of time) sales and current inventory

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:

  1. Go to the Reports menu.
  2. Select Sales and then choose Sales by Item Summary.
  3. Enter the correct date.
  4. Click Customize Report to filter the other necessary details.
  5. Once done, click on OK.

 

To run the Inventory Valuation Summary report, I suggest following these steps:

  1. From the Reports menu, select Inventory.
  2. Choose Inventory Valuation Summary.
  3. Enter the correct date.
  4. Click Customize Report to filter the other necessary details.
  5. Once done, click on OK.

 

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.

leahhag
Level 1

Report for (daily/range of time) sales and current inventory

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!

MaryLurleenM
Moderator

Report for (daily/range of time) sales and current inventory

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.

leahhag
Level 1

Report for (daily/range of time) sales and current inventory

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!

Adrian_A
Moderator

Report for (daily/range of time) sales and current inventory

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!

leahhag
Level 1

Report for (daily/range of time) sales and current inventory

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!

Jovychris_A
Moderator

Report for (daily/range of time) sales and current inventory

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:

  1. Click the Help menu and then select Send Feedback Online.
  2. Choose Product Suggestion.
  3. Select Type of Feedback as Product Suggestion, and the Product Area is for Reports.
  4. Type your suggestion.
  5. Click Send Feedback.

 

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!

Need to get in touch?

Contact us