• Negative Inventory

When having exploratory conversations with potential customers, the following often arises “We need to be able to maintain negative inventories in our accounting software, because we _______”.  Whatever reason fills in the blank, we often find that it is a result of a less than ideal business practice which was implemented in response to a lack of functionality and controls in the organization’s current software.

With this in mind, some systems support bad business practises by allowing a company to record negative inventory which results in incorrect information in the system. Although some companies use it as an actual business practice, negative inventory is not – you can’t for example count negative twelve items if you go to the warehouse to look for them.  While the ability to allow inventories to go into a negative position may seem to make certain processes easier to perform, it can cause problems throughout the company if not monitored and corrected in an appropriate manner.  Some of the more common reasons companies want to track negative inventory include:

  • Items shipped from a newly received inbound shipment prior to them having been received in the system. This could be a result of not having a chance to record a shipment which just came in, or following a practice whereby shipments are not received in the system until all of the related invoices have been received in order to get accurate costs.
  • Newly produced items being shipped prior to the production run being completed in the system.
  • Items pulled from a kit and shipped as an individual product, again without recording the breakdown of the kit before shipping.

While the above situations are often worked around with the sole goal being to get a shipment out the door and bring a business closer to receiving payment, there are a number of issues with going into a negative inventory position, including:

  • An incorrect Balance Sheet (understated inventory account, understated payables)
  • P&L reports will have incorrect COGS (true cost for the item sold is not known)
  • Even after you adjust the inbound inventory later, inventory values will be wrong, whether you use FIFO or Average costing among other methods
  • True inventory can’t be known by users in the system (besides those who may know about a shipment on the dock)
  • In practice, many companies running negative inventory in their software never get caught up, so the above persists perpetually

As a result of these issues, businesses may not be able to make effective business decisions, and in fact can be making decisions based on incomplete and incorrect information.

Many of these factors behind companies using “negative inventory” can be more appropriately dealt with by taking advantage of functionality available in today’s accounting ERP software.  For example, landed cost tracking features allow users to properly cost the product and receive it into inventory prior to receiving all the related invoices, and reverse production functionality allows users to break a kit into its individual inventory items in order to sell the individual components. And the most common reason, the desire to send an invoice with the shipment, can easily be dealt with in multiple ways without actually posting transactions that would send inventory into a negative value in the software.

As a best practice, businesses should take advantage of the investigation stage of new software as an opportunistic time to review their business processes (including those involving negative inventory). Companies should look at why they do certain things the way they do as they may find that the answers regularly include “because we have always done it that way” or “we do it this way because that is how it needs to be done in our current system”.  When these are the answers which are brought forth, the company should take a hard look to see if there is a better way to perform certain tasks and whether accounting ERP software can help them.   Chances are there will be more efficient ways to manage some processes and in general proper software will help a business obtain more accurate information for making business decisions.

 

Inventory Management Techniques