Post

6 followers Follow
2

Inventory valuation feature

Answered

I need to be able to see total inventory value at a given moment.

All stores doing monthly accounting need to have their inventory numbers on hand for their balance sheet.

Currently, the only way to do this is to run a report of what's in the inventory, do a bunch of math, and figure out the total value of inventory.

It would be nice to simply run a report showing quantity, price, and total inventory value of each item, with a final bottom line showing the total value of inventory.

Allen Walton Answered

9 comments

0

Hi Allen, 

Thank you for your feedback. I have a couple of questions regarding this request. Do you need to be able to see the inventory value per SKU or just the total value of all items on hand? I ask as I wonder if it would be more beneficial to add a graph to one of our dashboard pages that showed the total retail value of all on hand inventory (at any given time), rather than you having to generate a report with each product listed. If you do require each SKU to be listed in a report then can you please provide some more information on how you use this data. Are you uploading it into another accounting system? Or are you using it to make purchasing decisions? 

Tessa Hadobas [Product Manager]

ShippingEasy 0 votes
0

I like this idea too.  I would like to have this available to schedule a report every month for accounting statistics.  Would be great to have SKU/Category/Supplier/Total available.

Randy Boadway 0 votes
0
Both. It's helpful to see how much money we have tied up in inventory on a per SKU basis. And we need to be able to see the total value of inventory so we can calculate our COGS, current value on hand for balance sheets, and etc.
 
Most of the inventory management alternatives out there have this.

I don't mind generating a report but I like the graph idea for sure.
 
I personally am not uploading the data anywhere at the moment - my accountants ask for it at the end of each month for our financial statements. But per SKU sounds great so I know just how much money I have tied up in products.
 
Allen Walton 0 votes
0

This is an essential basic feature of inventory management. It should be by sku, and should have FIFO as a minimum for book-keeping purposes (first-in-first-out product-price as it applies to vendor cost of goods). 

I'd suggest you need to hire an inventory management expert to guide you, as right now your inventory tools are not ready for the real world.

Phil Dexter 0 votes
0

Hi Allen, 

Thanks for the additional information. I have a couple more questions I'd like to confirm with you: 

1) Should the inventory valuation be calculated using the declared value/price listed in ShippingEasy or the supplier cost/s used on POs?

2) Should the inventory valuation be calculated using the total stock on hand (including unshipped orders) or just the available inventory? 

Tessa Hadobas [Product Manager]

ShippingEasy 0 votes
0

1) Supplier costs used. Should also distribute shipping charges evenly across all products.

Example : purchase order for $17,500 in inventory. 500 widgets at $35 each. Shipping was $300. Thus each products 'landed' cost was $35. Would be great if you could also tack on customs charges, etc.

 

2) If you can't do both, I would say total stock on hand.

 

If you are very serious about having a great inventory solution, I can crowdsource suggestions from other 7 figure store owners. I know a lot of people are using Dear now.

Allen Walton 0 votes
0

Hi Allen, 

Thank you for this additional feedback. I've reached out to you via email so that we can discuss these suggestions in more detail. I really appreciate you taking the time to write all of this out for us. 

Tessa Hadobas [Product Manager]

ShippingEasy 0 votes
0

I am canceling my plan because this most basic simple feature is not available. I should easily be able to get a value of my inventory at any time. It is so common that I did not even know this feature didn't exist until I put my inventory in. WOW!

Brad Roberts 0 votes

Add a comment:

Please sign in to leave a comment.