Basics
- MicroBiz Cloud uses Perpetual moving average cost to track the value of your inventory.
- Supplier Shipment Cost, Store Transfer In and Beginning Stock Balance cost are all used to calculate the value of your stock - this is tracked for each simple SKU for each store. (Summary valuations for the configurable parent are shown in the inventory tab).
- Transfers Out, Inventory Adjustments and Cost of Goods for sales use the average cost at the time of the transaction for that SKU/Store.
How Perpetual Moving Average Works:
- If you have 6 items left in stock that you had purchased for 37.50 your inventory value = $225.00
- Even if your replacement cost for a new shipment is 38.00 if you sell one your cost of goods will be 37.50.
- If you receive 12 more at a cost of 38.00 you now have 18 at a cost of $456.00.
- The total value of your inventory for this item is $225.00 + $456.00 which equals $681.00
- The average cost of your existing stock is now $37.83 ($681.00 divided by 18 pieces).
What Happens if there is no Vendor Shipment,Transfer In or Beginning Stock Balance?
- If there is no inventory or only an adjustment in - since there is no existing average cost we use whatever the replacement cost is at the time of the transaction.
- Note that changing the replacement cost does not change the cost in an existing transaction.
Vendor Shipments and Late Arriving Cost
- You can edit completed vendor shipments if the cost on the invoice is not what you expected when you received the shipment - however existing transactions subsequent to the shipment are not corrected for this change (on the future features list).
How Can I change the Current Average Cost if I think its wrong?
- Adjust out all the existing stock using Inventory Adjustment.
- Change the replacement Cost
- Adjust it all back in at the new Cost
How Can I change Cost of Goods on an Existing Sale?
- The only way is to return the sale after the average cost has been corrected and resell it - but the sale will move to a different date.