Hi @Tut, is it still necessary to create an ‘Inventory Costing Calculation Worksheet’ to prevent the recalculation from changing past unit costs and consequently changing profit, loss, and cost of goods sold int the latest manager.io version (25.5.31.2363), I don’t know how inventory item recalculation, inventory unit cost, inventory costing calculation worksheet affect each other in the new version?
Inventory Costing Calculation Worksheet is just a report. It has nothing to do with locking unit costs.
Inventory cost correction which you can access by clicking Recalculate button or you can find it at the end of the Inventory unit cost screen in Settings.
To preserve your Unit costs, you need to setup Lock date which you find under settings.
1 Like
@shahabb, do you know how to set the Inventory Unit Cost manually? In the previous version (25.1.22.2041), I could set the “Inventory Unit Cost” on a specific date. I do this, for example, when I’ve created a report for management approval. I need to make the “Inventory On Hand” and “Cost of Goods Sold” match the numbers I just reported. On the newest version, it seems setting the “Inventory Unit Cost” at specific date doesn’t affect the “Inventory on Hand” and “COGS” in Profit and Loss report?
Unit cost is used to calculate cost of goods sold on transaction basis.
I know there have been quite a few changes how it’s all working because there are so many requirements and possibilities so I did experiment with nearly every possibility and gathering feedback. It’s all settled now and the way inventory works now is definitive.
See this guide on inventory cost correction: https://www.manager.io/guides/inventory-cost-correction
The best way to adjust total cost figure is to simply make journal entry between Inventory on hand and your inventory cost expense account. Do not enter quantities as you only want to adjust amounts, not quantities.
2 Likes