# Adjusting Inventory for Actual Count **URL:** \ **Category:** Uncategorized\ **Created:** [January 9, 2017, 9:18pm UTC](https://forum.manager.io/t/adjusting-inventory-for-actual-count/8277 "2017-01-09T21:18:23Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![queenbean84](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/queenbean84/32/6479_2.png) [@queenbean84](https://forum.manager.io/u/queenbean84)\ **Post date:** [January 9, 2017, 9:18pm UTC](https://forum.manager.io/t/adjusting-inventory-for-actual-count/8277/1 "2017-01-09T21:18:23Z")
I took a physical count of my inventory items for year end. Some items I have less than the system balances, some items I have more than the system balance. I can do an inventory write-off for the items where I need to reduce the quantity in the system, but how do I account for the items where I need to **increase** the quantity? I tried using a negative inventory write-off but the system completely ignores the entry. ---
**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\ **Post date:** [January 10, 2017, 12:05am UTC](https://forum.manager.io/t/adjusting-inventory-for-actual-count/8277/2 "2017-01-10T00:05:47Z")
In the case of write-ups, use a Journal. Debit the Inventory item and credit a COGS “expense” account, unfortunately you can’t select the “Inventory Cost” account itself. If Inventory Write Off was changed to Inventory Adjustment - then it could allow for write ups as well as write downs. ---
**Author:** ![queenbean84](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/queenbean84/32/6479_2.png) [@queenbean84](https://forum.manager.io/u/queenbean84)\ **Post date:** [January 10, 2017, 1:46am UTC](https://forum.manager.io/t/adjusting-inventory-for-actual-count/8277/3 "2017-01-10T01:46:29Z")
Thanks. Then I would have to go into each inventory item and adjust the beginning balance then, too. Correct? ---
**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\ **Post date:** [January 10, 2017, 1:55am UTC](https://forum.manager.io/t/adjusting-inventory-for-actual-count/8277/4 "2017-01-10T01:55:00Z")
No, the Journal will adjust the quantity, when you enter the account Inventory On Hand a quantity field becomes available. ---
**Author:** ![queenbean84](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/queenbean84/32/6479_2.png) [@queenbean84](https://forum.manager.io/u/queenbean84)\ **Post date:** [January 11, 2017, 10:30pm UTC](https://forum.manager.io/t/adjusting-inventory-for-actual-count/8277/5 "2017-01-11T22:30:59Z")
So with this method I would have to figure out average cost first. There has to be another way to do this. My average cost is a few decimal places out and manager doesn’t show anything other than 2 decimal places for average cost. This method is just not acceptable. ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [January 11, 2017, 10:57pm UTC](https://forum.manager.io/t/adjusting-inventory-for-actual-count/8277/6 "2017-01-11T22:57:47Z")
Don’t despair. There is actually a way to trick the program. Using a journal entry, allocate the first line to `Inventory on hand` =\> `Inventory item`. A Quantity field will appear. Enter the quantity change (positive, since you are adding to inventory). Leave the debit and credit amounts blank. Delete the second line or just leave it blank. The on-hand quantity will go up, and the average cost will be automatically recalculated. While you might think the program won’t allow this because of the requirement for balanced transactions, the sum of all debits is zero, the sum of all credits is zero, so it balances. I do agree with @Brucanna, though. It would be better to revise the module to be `Inventory Adjustments` and have a single, straightforward process. ---
**Author:** ![queenbean84](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/queenbean84/32/6479_2.png) [@queenbean84](https://forum.manager.io/u/queenbean84)\ **Post date:** [January 12, 2017, 1:33am UTC](https://forum.manager.io/t/adjusting-inventory-for-actual-count/8277/7 "2017-01-12T01:33:31Z")
OH, thank you so much!! ---
**Author:** ![queenbean84](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/queenbean84/32/6479_2.png) [@queenbean84](https://forum.manager.io/u/queenbean84)\ **Post date:** [January 12, 2017, 1:39am UTC](https://forum.manager.io/t/adjusting-inventory-for-actual-count/8277/8 "2017-01-12T01:39:10Z")
The system isn’t going to recalculate all my cost of goods sold for the year based on the new average cost, correct? It should only use the new average cost when new transactions are added as long as they are dated AFTER the journal entry date. ---
**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\ **Post date:** [January 12, 2017, 1:43am UTC](https://forum.manager.io/t/adjusting-inventory-for-actual-count/8277/9 "2017-01-12T01:43:48Z")
Correct, the Journal is no different to adding a Purchase Invoice (in fact you could create a zero value Purchase Invoice and get the same result - but I wouldn’t) ---
**Author:** ![queenbean84](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/queenbean84/32/6479_2.png) [@queenbean84](https://forum.manager.io/u/queenbean84)\ **Post date:** [January 12, 2017, 1:47am UTC](https://forum.manager.io/t/adjusting-inventory-for-actual-count/8277/10 "2017-01-12T01:47:36Z")
Thank you Brucanna. A journal entry is the best way. ---
**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:** [January 18, 2023, 3:29pm UTC](https://forum.manager.io/t/adjusting-inventory-for-actual-count/8277/11 "2023-01-18T15:29:13Z")