# Average cost when "Qty owned" is very small **URL:** \ **Category:** Uncategorized\ **Created:** [March 10, 2025, 12:20pm UTC](https://forum.manager.io/t/average-cost-when-qty-owned-is-very-small/61218 "2025-03-10T12:20:21Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![WildTZ](https://avatars.discourse-cdn.com/v4/letter/w/df788c/32.png) [@WildTZ](https://forum.manager.io/u/WildTZ)\ **Post date:** [March 10, 2025, 12:20pm UTC](https://forum.manager.io/t/average-cost-when-qty-owned-is-very-small/61218/1 "2025-03-10T12:20:21Z")
Hello! Cloud user. We use the “Inventory quantity by location” report for doing our stock take. In order to ensure every item shows up we have another inventory location with a tiny amount of the product. I’m not sure if this is needed anymore, but it was a workaround I used to ensure every report has the same amount of lines and make it easy to verify our stock. Now regarding average cost, I just know that there have been a lot of changes over the last few months and that it caused some problems for various users. For this item we have nothing in stock, except for the 0.0001 amount I have in an inventory location due to the reasons mentioned above. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/e/5/e580d5349fa1a2830f960019d1100a8f118a292d.png) The “Average cost” says 12,400 USD because it’s “Total cost” divided by “Qty owned”. When I click on “Total cost” it lists a bunch of production orders and write-offs. ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/6/b/6b99e52b13a5c459ce187f27c38f3f45d0684c5c.png) At this point I’m not even sure what my question is 😂. What needs fixing to get it correct? I see the balance isn’t 0. But why is is not 0? The starting stock is from 2019 and the transaction above are from 2021. So it was “0” then. Any advice would be greatly appreciated. ---
**Author:** ![shahabb](https://avatars.discourse-cdn.com/v4/letter/s/838e76/32.png) [@shahabb](https://forum.manager.io/u/shahabb)\ **Post date:** [March 10, 2025, 2:03pm UTC](https://forum.manager.io/t/average-cost-when-qty-owned-is-very-small/61218/2 "2025-03-10T14:03:17Z")
Looks like you need to run Inventory Cost Correction Worksheet. Make sure to remove the Lock Date before running it. ---
**Author:** ![WildTZ](https://avatars.discourse-cdn.com/v4/letter/w/df788c/32.png) [@WildTZ](https://forum.manager.io/u/WildTZ)\ **Post date:** [April 3, 2025, 6:13am UTC](https://forum.manager.io/t/average-cost-when-qty-owned-is-very-small/61218/3 "2025-04-03T06:13:32Z")
It doesn’t change anything. I don’t understand how the average cost for an item is for example 519.84 $ ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/4/f/4fa3603e04bf407355bb4436ea33fbc16c78d4de.png) But when I look at the “Total cost” number and sort by the highest “unit cost” it’s only 28 $ ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/7/27a0deb9a73a457edf267579486434f9f2c8c5ae.png) How can my “Average cost” be almost 20 times higher than my highest recorded cost? ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [April 3, 2025, 9:33am UTC](https://forum.manager.io/t/average-cost-when-qty-owned-is-very-small/61218/4 "2025-04-03T09:33:40Z")
> [@WildTZ](#): > > What needs fixing to get it correct? I see the balance isn’t 0. But why is is not 0? The starting stock is from 2019 and the transaction above are from 2021. So it was “0” then. You need to write-off this balance. As long as there’s a value and a miniscule Qty you’re going to have inflated unit costs ---
**Author:** ![WildTZ](https://avatars.discourse-cdn.com/v4/letter/w/df788c/32.png) [@WildTZ](https://forum.manager.io/u/WildTZ)\ **Post date:** [April 8, 2025, 2:49pm UTC](https://forum.manager.io/t/average-cost-when-qty-owned-is-very-small/61218/5 "2025-04-08T14:49:45Z")
Why is that? I don’t have another work around for our stock takes. We pull a report, do the physical count, the formulas in the sheet create the needed write-off and journal entries to balance it. If any items is “0” it doesn’t show up on the list so it makes it a nightmare to align.