# Periodic Manual Inventory Adjustment **URL:** \ **Category:** Uncategorized\ **Created:** [October 31, 2016, 9:48pm UTC](https://forum.manager.io/t/periodic-manual-inventory-adjustment/7524 "2016-10-31T21:48:04Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![devan](https://avatars.discourse-cdn.com/v4/letter/d/13edae/32.png) [@devan](https://forum.manager.io/u/devan)\ **Post date:** [October 31, 2016, 9:48pm UTC](https://forum.manager.io/t/periodic-manual-inventory-adjustment/7524/1 "2016-10-31T21:48:04Z")
I’d like to know the proper way to record a periodic (e.g., monthly, quarterly) manual adjustment of inventory quantity in Manager. Each of my sales transactions are bulk loaded into a Cash Account using the ‘Import bank statement’ function. Although I could edit each imported sales receipt and add the relevant inventory items consumed, that would be a very tedious task. An inventory write-off didn’t seem correct since the inventory items (raw materials) were consumed in the product manufactured and sold. In looking at older posts, I saw a mention of using a Journal entry, but couldn’t figure out how that would be done. If I manually adjusted the Quantity on Hand, I would’t have an audit record of the manual adjustment. This seems like a simple, but common issue and any advice would be appreciated. ---
**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:** [October 31, 2016, 10:02pm UTC](https://forum.manager.io/t/periodic-manual-inventory-adjustment/7524/2 "2016-10-31T22:02:48Z")
Inventory is adjusted when the Sales Invoice is created, not when the payment is received. ---
**Author:** ![devan](https://avatars.discourse-cdn.com/v4/letter/d/13edae/32.png) [@devan](https://forum.manager.io/u/devan)\ **Post date:** [November 1, 2016, 12:51am UTC](https://forum.manager.io/t/periodic-manual-inventory-adjustment/7524/3 "2016-11-01T00:51:26Z")
Thanks - I’m aware of that, but I don’t use Sales Invoices. Most customers buy my products online and pay with PayPal. At the end of the week, I do an Import Bank Statement into my PayPal cash account in Manager. I could go into each of the 50 or so imported transactions and add the inventory (raw material) used to make each specific item sold (custom silver jewelry). That works, but is very tedious and time consuming. I was just wondering how businesses that do periodic, “manual” inventories would adjust their quantities in software such as Manager. ---
**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:** [November 1, 2016, 1:46am UTC](https://forum.manager.io/t/periodic-manual-inventory-adjustment/7524/4 "2016-11-01T01:46:08Z")
Ok, then there is an alternative system but that doesn’t involve having Inventory Items. So do you need to know or have your accounting system know detailed Inventory stock levels/values. If no. then you can run the opening/closing stock system - read this topic the juicy bits start half way down > [@Inventory accounting using Opening Stock + Purchases - Closing Stock](https://forum.manager.io/t/facing-difficulty-with-inventory/5252): > > I don’t want to use Inventory items etc. I want it to be turned off but at the same time when i make a sales invoice the figure gets added to the sale and the tax goes to it’s designated account. but where is the stock getting decreased for sales and increased for purchases what steps should be taken to correct this.I should know the position of my stock after each sale or purchase. Please help. ---
**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:** [November 1, 2016, 3:44am UTC](https://forum.manager.io/t/periodic-manual-inventory-adjustment/7524/5 "2016-11-01T03:44:12Z")
A question to ask yourself, @devan, is whether you need to be concerned with inventory at all. The answer may well depend on local tax laws, so check with an accountant. But you might be able to run the business simply expensing materials. Typically, when supplies and materials are not held for extended periods, but are consumed within a normal accounting cycle, they are not accounted for as inventory. For example, a custom furniture maker might buy special wood for a custom project. The wood is used up in the process of building the furniture. There is no need to create inventory for the wood. Nor would she count bottles of glue or screws remaining from a box of fasteners. In your case, you might buy rolls of silver wire or beads. But you don’t sell wire and beads; you sell finished jewelry. So if you hold finished items for sale, it can be appropriate to treat them as inventory. But not the raw materials. On the other hand, if you had a large and expensive stock of gem stones, some of which might sit around for months or years waiting for the right piece to use them in, it could be appropriate to treat individual stones as inventory. ---
**Author:** ![devan](https://avatars.discourse-cdn.com/v4/letter/d/13edae/32.png) [@devan](https://forum.manager.io/u/devan)\ **Post date:** [November 1, 2016, 8:55pm UTC](https://forum.manager.io/t/periodic-manual-inventory-adjustment/7524/6 "2016-11-01T20:55:23Z")
Thanks. That thread has some good info with examples. I’m going to create a test business in Manger (a very helpful feature) and work on a couple scenarios. ---
**Author:** ![devan](https://avatars.discourse-cdn.com/v4/letter/d/13edae/32.png) [@devan](https://forum.manager.io/u/devan)\ **Post date:** [November 1, 2016, 9:18pm UTC](https://forum.manager.io/t/periodic-manual-inventory-adjustment/7524/7 "2016-11-01T21:18:30Z")
When the business first started and things were simple, it could have been done either way as you said – expensing my materials or keep an inventory. However, I now have a significant investment in core components (silver sheet, silver wire, gemstones, etc.) whose cost can’t be deducted until they are sold. I currently use a sole trader, cash-basis method of accounting, but with an inventory. The IRS allows a modified cash-basis accounting system such as this (vs, straight cash or accrual) if the gross receipts are under $1 million. ---
**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:** [November 2, 2016, 6:41am UTC](https://forum.manager.io/t/periodic-manual-inventory-adjustment/7524/8 "2016-11-02T06:41:54Z")
> [@devan](#): > > However, I now have a significant investment in core components (silver sheet, silver wire, gemstones, etc.) whose cost can’t be deducted until they are sold. Therefore you can run a duel system - Inventory for the core components and expensed for the non-core components. So getting back to your initial question of “periodic manual inventory adjustment”. Accepting that it would be vary tedious task (even though proper) to adjust each sale invoice for the cost of goods componentry. Therefore, there is an alternate approach. For the core components, do a monthly stocktake and calculate the difference between the Manager Inventory Item quantities and the stocktake quantities (which should always be lower). Then create a zero value Sales Invoice - Invoice total is 0.00. List the Inventory items and enter the calculated quantities (usage) as if they were being sold (so positive numbers) but with zero values. Once the invoice is created, the inventory item quantity and value would be adjusted and a Cost of Sales value would be added to the P&L So a monthly stocktake and an adjusting Sales Invoice in place of 50 sales invoices, also much better then using Inventory write off or a Journal ---
**Author:** ![devan](https://avatars.discourse-cdn.com/v4/letter/d/13edae/32.png) [@devan](https://forum.manager.io/u/devan)\ **Post date:** [November 2, 2016, 5:48pm UTC](https://forum.manager.io/t/periodic-manual-inventory-adjustment/7524/9 "2016-11-02T17:48:52Z")
> [@Brucanna](#): > > … So a monthly stocktake and an adjusting Sales Invoice in place of 50 sales invoices, also much better then using Inventory write off or a Journal. Thanks - I like that. ---
**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:30pm UTC](https://forum.manager.io/t/periodic-manual-inventory-adjustment/7524/10 "2023-01-18T15:30:30Z")