Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Good morning,
I'm looking for a way to do a report on Estimated inventory, meaning all the products that I quoted on for clients.
I need to buy in some stock, but want to see which products I quoted on the most.
Hope it makes sense.
Thank you
Hi AneVenter,
You can run the Transaction List With Splits report then customize it by following these steps:
If you want to include the total for each product/service, you can export the report to Excel. Then manually edit the file to include the information. See article: Export QuickBooks Online Reports to Excel.
I'd also recommend sending feedback to our product developers about your suggestion. To send feedback, click the Gear icon and select Feedback.
I’ll also share this idea with our product development team. Suggestions help us create features based on what users need most for their companies.
Feel free to reach out to us if there's anything else you need help with QuickBooks. Thanks.
Thank you so much, this helps a lot. Is there a way to filter it according to the SKU?
All my part numbers are filled in in the SKU section, and when I did the filter as suggested, it gives me only the filter names and not the part numbers.
Kind Regards,
Ane Venter
Thanks for getting back to me, Ane.
At the moment, you'll have to run a separate report to get the part numbers that were entered in the SKU field. You can use the Product/Service List report and add the SKU column.
Once done, you can include this information to the report exported to Excel.
I'll be around if you have any additional questions about QuickBooks.
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