Financing, tax rates, and accounting
Join us March 21 for an AMA on planning your 2023 marketing budget with 2H Media co-owners, Matt and Aron
Is there a way to get a report of what I had in inventory at year end?
yes, if I remember correctly...
go to Analytics, Reports,
Month-end inventory snapshot
and change the date to Dec 31, 2020.
Thank you, however that doesn't give a total amount and that's what I need.
We're glad you found a solution to a problem that many of us have. Could you be the "helper" that you sought and share with us your method?
My guess would be to follow LBLLC's direction to get to "Month-End Inventory Snapshot". From there, click the hyperlink in blue marked "export the report", which will download a .CSV file that you can open up in Microsoft Excel. I'm terrible with Excel but I believe you can then use Excel tools to remove any items with a value of "0" so you can see only items with stock on Dec, 31st. Add them up and assign value to those quantities to come up with your "Cost of Inventory Remaining".
Thanks and God bless you.
User | RANK |
---|---|
2 | |
2 | |
2 | |
2 | |
2 |
Thanks to all Community members that participated in our inaugural 2 week AMA on the new E...
By Jacqui Mar 10, 2023Upskill and stand out with the new Shopify Foundations Certification program
By SarahF_Shopify Mar 6, 2023One of the key components to running a successful online business is having clear and co...
By Ollie Mar 6, 2023