Write off Inventory Kits

Continuing the discussion from Profit and loss - inventory sales:

In service based businesses where inventory kits are produced and sold to order many times a day, it would make sense to be able to write-off unsold, discarded or lost kits.

Inventory Write-offs are the most faithful representation of sucj transaction and this would eliminate the need to resolve to difficult to understand workarounds such as using Sales Invoices and or Receipts, which would possibly be as difficult justify to auditors and tax authorities.

I disagree strongly with this concept. Inventory kits were introduced as data entry shortcuts for inventory items stocked, managed, and stored individually but sold together. An inventory kit does not exist until sold. For example, tables and chairs are handled as individual inventory items, but might be sold as a dining set (probably at a lower overall price) as an inventory kit.

Thus, an inventory kit cannot be written off, because it does not physically exist.

The example in the linked thread was a cocktail. Cocktails of the type discussed in that thread are not made in advance and warehoused for later sale. They are mixed to order and sold instantly.

Personally, I question the entire notion of treating consumable refreshment supplies as inventory items. That is a lot of accounting work for little value; but I understand why some entities might wish to do so, such as when constituent components are stored for indeterminant intervals before potentially being used again. But incorporating a write-off feature for inventory kits into the program could well lead to problems. Future developments are unlikely to take account of usage of inventory kits contrary to their entire reason for being.

2 Likes

Even though I agree with a big part of your reasoning, the workflow described in the OP is a valid workflow and Iā€™m not in a position to judge why this cocktail was mixed and then discarded but the OP provides an example of this happening.

To separate the issue from that individual case, it would be useful to take IKEA as an example, which deal mostly in assembly kits. Some of their kits come prepackaged and in case of these kits get totally damaged, I imagine they would be able to write-off the entire kit instead of having to write-off each component individually.

I can surmise from your reply, that you appreciate the problem but not so much the solution, which is great since the OP didnā€™t describe this idea to be the end-all-be-all solution, and Iā€™m not willing to defend this idea when an alternative solution is available.

What would you propose if you were in that exact situation?

1 Like

Imo it is an issue as a result of trying to use Manager as a POS system.

Discarding cocktails implies they have been made and do physically exist.

How Manager should handle this depends on what market Manager as trying to address and the effect on other businesses which use Manager for other applications such as straight accounting.

I donā€™t think your Ikea example holds up. Ikea stocks, counts, and manages the complete kit. They do not collect components from individual items when one is sold. Their kits are finished goods in their own right.

1 Like

Maybe, but while Iā€™m not entirely for designing Manager around specific niche cases but carving out the boundaries of Manager to avoid specific use cases will eventually corner it into a niche of itā€™s own.

The OP found that Manager fits 99% of their needs and is trying to figure out how to incorporate the remaining 1% without going too much out of their way. I would argue that a General Accounting Software such as Manager should be able to accommodate that, in theory.

I donā€™t suggest turning Manager into a POS, but, it would be nice to have versatile tools at hand for users to cope Manager to better fit their situation ā€“ tools such as Inventory Kits in this example.

1 Like

Not sure why this is in the ideas category. I have not come across any accounting application yet that writes off an inventory-kit or similar as a whole. In all cases we should break a kit down or disassemble and apply the write-off to the individual items, because writing off a kit:

  1. would ignore the value of the individual items itā€™s composed of;
  2. can lead to an inaccurate inventory valuation. Some items may still have value or be used elsewhere, and financial records need to reflect the true value of the inventory.

Also note that inventory adjustments (such as write-offs) are typically made based on individual item costs or specific issues like damage or obsolescence. Treating a kit as a single unit can conflict with these practices.

1 Like

I sometimes have to make up printed circuit boards with 20+ components which I have as inventory kits. On the rare occasion that one fails it is more economical for me to toss the whole PCB and build a new one. Currently I write off the items individually which can be time consuming, but being able to write them all off in kit form would be a real game changer.
Iā€™m all for it.

2 Likes

When there is a change of some goods into other goods, wouldnā€™t it be more appropriate to use a Production Order?

2 Likes

I dont know why some users are against this even if its just a shortcut for mutiple items still this shouldnt be an issue. If someone doesnt want it they can select items individually. I think Inventory Kits should be available everywhere where possible even Production Orders (which i think was already discussed and can somewhat solve the lack of BOM issue in Production Orders). Only place it could make issue is Purchases because of cost allocation issues other than that i see no issues in it.

I think Production Orders are suitable for ā€œBuild to Stockā€ Items and Invenotry kits are suitable for ā€œBuild to Orderā€.

4 Likes

Have to disagree here. Make to order items are still Finished Goods and are NOT Kits. Perhaps a solution for Vacuum Dog would be to complete the full production order and scrap the one PCB that is a reject.

2 Likes

That is a totally incorrect use of inventory kits. @Mabaega is correct. You should add the PC boards to inventory as separate inventory items using a production order. The value in finished PC boards in Inventory on hand will then reflect the value of their components at the time they were built. If one must be scrapped, the program can assign a value. But if you scrap an inventory kit, the program has no way of knowing what the value of the components were when the kit was assembled for sale, because the individual components are not linked to a specific kit. For all the program knows, the kit could have been assembled last year when parts were cheaper.

Cost of goods sold for inventory kits is determined at the moment of sale, because that is when the program assumes components were pulled from inventory.

@VACUUMDOG, your workflow is just plain wrong accounting. Within Manager, inventory kits are part of a one-way process that only involves sale, never production. And that highlights another problem with your approach. Non-inventory costs, which can be captured with a production order, cannot be captured by an inventory kit. If you were to write off a kit, what would you do with non-inventory costs?

1 Like

The PCBā€™s (and other certain items) are made as required. They are not a ā€˜Stock Itemā€™.There is only parts costs involved.
You have no idea of my workflow!!
The method I use works fine.
The discussion here was about the feasability of being able to write off inventory kits, not to criticise other peoples business practices.

In addition to my earlier post where I explained, why to my knowledge, no accounting application has a write-off function for an inventory kit, please also see the Manager guides at https://www.manager.io/guides?inventory-kits

Specifically [emphasis added]:

An Inventory kit is essentially a bundle of Inventory Items that are sold as a package, but arenā€™t physically grouped or stored as a single unit. The items within the kit can also be sold individually at different times. When a kit is sold, its components are collected from their respective storage spots for shipment. While the inventory kit isnā€™t used for manufacturing, it serves as a convenient sales strategy that offers multiple advantages.

I understand that using inventory kits seem practical because of the manufacturing at request that you explained. However, it does not account for labour costs and thus would be incomplete as far as establishing Cost of Goods Sold, see also https://www.accountingcoach.com/blog/what-are-manufacturing-costs#:~:text=Manufacturing%20costs%20are%20the%20costs,to%20comply%20with%20U.S.%20GAAP.

1 Like

That is the whole point: the PCBs are made, as in produced. Inventory kits are never made; they are sold.

The more people try to defend this idea, the more obvious it becomes that it is not appropriate.

3 Likes

So if your customer changes their mind do you ā€œunmakeā€ them and put the items back in stock as they were.

If so inventory kit is reasonable. If not you have just in time manufacture which is handled in Manager via a production order.

In Manager unpacking a box to change the unit size is a manufacturing process

2 Likes

While everyone seems to be sidestrepping the issue of being able to provide the ability to write off inventory kits IF REQUIRED ie no-one is being forced to use it, I will explain my use for this.
A customer brings an item in for repair.
I find that the PCB is fried and make up a new one from inventory on hand (stock that is available for individual purchse) with no labour actually charged to the kit.
My labour is charged at fixed rates ie easy, harder and complex, for the whole repair.
If the new pcb fails in a major way it gets binned and a new one made up. If itā€™s only minor I might replace just the failed components and write them off individually.
This suits MY work flow and has done so since 1987.
As in other ideas that get put down by some here no one is saying you have to do it that way. All we are asking for is the ability for us to do it as an option.
At times there just seems to be too much negativity hereā€¦sad.

Inventory kits have a much broader range of uses than just their literal definition.
So some businesses might find this useful for make to order products.

No one is sidestepping this. We tried to explain that writing off an inventory kit is not a good idea for accounting because Inventory kits use quantity of items not including each items value which causes all kinds of issues when writing of as the values of these inventory items may have changed and thus it can not simply returned at the values at the time of creating the inventory kit. Therefore, however simple it may seem, a reversal of the qty at some ā€œreturnā€ date of the PCB in most instances will result in inaccurate inventory valuation of the items used. Hence the need to disassemble the kit to its individual items and write off qty + value using standard inventory write-off procedures. I encourage you to search the internet, look a other accounting software including SAP (used by IKEA) and you will notice not any will allow for inventory kit write-off if they have such functionality for reasons given. They all tell you to disassemble to the individual items to write-off (often also referred to as components).

2 Likes

This topic has now got to the point of comparing Manager to SAP !

I know thatā€™s a slight exaggeration, but it does seem that everything that can be said, has been said

2 Likes