V8 - Tracking work in progress (WIP)
For many companies, the process of turning raw materials into finished goods can take days, weeks, months—and in some cases, years. As the length of time involved in manufacturing increases, so does the importance of tracking work in progress (WIP). Tracking WIP allows you to remove raw materials from inventory that are no longer available because they have been used in manufacturing. However, the finished good might not yet be available.
SOS Inventory offers two methods for tracking WIP: work centers and items created to represent WIP. These two methods are not mutually exclusive. You can use one or both, depending on your tracking needs.
- Method 1: Work centers. This method is available only to Pro Plan customers. Work centers allow you to organize your manufacturing into stages and indicate where in the manufacturing process the product is. You add work centers by going to the Work Centers list (Company menu > Miscellaneous > Work Centers). Work center tracking is most useful when used in conjunction with Jobs, as you can specify work centers for a given job and even run a profit/loss statement on each work center within a job. See Work centers for more information on this feature.
edit_noteNOTE: Only company administrators may set up work centers.
- Method 2: Items. It is often useful to set up special items to represent WIP items in SOS Inventory. This allows you to track exactly how many units of each “sub-product” that you have at any given time. For example, suppose that you start with a Widget which must first be welded and then painted to make the finished good. You might want to know how many items have been welded and are waiting to be painted. A simple approach is to create an item called Widget— Raw to represent the original raw material. Then create an item called Widget—Welded to represent the welded version, and then an item called Widget—Painted or Widget to represent the finished good that will eventually be sold to customers.
Alternative methods for tracking work in progress (WIP) for Companion and Plus plan subscribers
SOS Inventory's work-in-progress and work center features are designed for Pro Plan subscribers. However, if you are not on the Pro plan, here are some possible workarounds:
- Companion plan option: create a WIP item. An interim assembly item can be produced for items that are converted into a finished item, but the process takes time. Example: A widget is made from 1 gadget and 1 cog. Create an assembly item called Work in progress - Widget that has a WIP asset account assigned to the item. Add the gadget and the cog to the bill of materials (BOM). Then create the Widget assembly item and the bill of materials is just the Work in progress - Widget.
- When you get ready to build the Widget, you add a build of Work in progress - Widget. This will remove the gadget and cog from inventory and place the Work in progress - Widget into inventory.
- When the Widget is complete, you add a build of the Widget. This will remove the Work in progress - Widget from inventory and place the Widget into inventory. This will also send a journal entry to QuickBooks Online to remove the value of the Work in progress - Widget from the WIP asset account and place it in the Widget’s asset account.
- Plus plan option: create another location called Work in progress. Create a location and make it non-nettable so that the inventory at that location will not show in your available stock. Transfer the goods to the WIP location when the build is started. When the build is complete, record the build at the WIP location and then transfer the finished good back to the main location.
edit_noteNOTE: Only company administrators may set up locations.