Inventory management can be hard for any business to do well. Whether you're in manufacturing or retail, your business can suffer if you have too little stock – or too much. Here's how to get it right.

2015_MAR - ALL - How to create an efficient inventory management system

Inventory is money

Inventory management can be difficult because it's hard to predict demand. If you stock up on a particular product line but demand drops, you'll have stock that you don't need. And if products are lying in your warehouse for too long, that will affect your cashflow because:

  • unsold items don't generate revenue.
  • warehousing costs money, and so does inventory accounting.
  • stored items take up space that could be used for something else.
  • stock may deteriorate or become obsolete.
  • items could be damaged or even stolen.

So the money tied up in excess inventory could be put to better use elsewhere.

On the other hand, if you don't keep enough stock and demand then spikes, you'll miss out on sales – and maybe even lose customers. You won't be able to fill big orders and you'll have to scramble to catch up with your competitors.

Either way you could lose money. So it's important to manage your inventory as efficiently as possible.

Understand the inventory types your business has

Inventory usually falls into one of three main categories:

  1. Raw materials.These are the basic materials from which your final product is made. Depending on your field of work, they can take up a lot of space.
  2. Work in progess (WIP) These are goods that are in the process of being manufactured but are not yet complete. Examples include toys to be painted and ceramics that haven't yet been fired.
  3. Finished goods. These are products that are ready to be sold to your customers. They may be sent to distributors or you might sell them directly to your clients.
  4. Each category has different storage requirements, but each one is dependent on the other. If you don't have enough raw materials, you can't make finished goods. And if demand for your finished goods drops, you could end up with too many raw materials.

    Improve your forecasts

    The first step to efficient inventory management is to understand the demand for your products. How does it vary over time? There may be seasonal fluctuations or other trends that can help you work out how demand will change.

    Quality accounting software will generate reports into past sales. These can help you identify which products are popular at which times of year. Then you can adjust your stock accordingly.

    Understanding the market which you operate in is the best way to fine-tune your predictions. Once you've done that, you'll have taken a big step towards more efficient inventory management.

    Track your inventory

    The next step is to find out what inventory you have and where it is. That might be easy if your business is small, but it can quickly become complex as you scale up.

    Raw materials may be easy to track, but WIPs will move around a lot, and could be anywhere in the building. Finished goods need to be tracked right out of the door – and beyond.

    The best systems track products every step of the way – from raw materials to customer delivery of finished goods.

    Barcode scanning is the traditional way to track stock, and it's still popular today. Other systems, such as radio-frequency identification (RFID) tags, are becoming more affordable and are often faster and more flexible.

    Use the best tools

    Whatever tracking system you use, make sure you have the software to support it. Avoid relying on Excel spreadsheets to manage your inventory, as:

    • spreadsheets can't easily be modified by several people at once.
    • it's easy to make mistakes and delete entries – or even the whole file.
    • you have to make regular backups to avoid data loss.
    • spreadsheets weren't designed for stock management.

    It makes more sense to use inventory management software that was made for the job. Ideally this should tie into your accounting software – because inventory is money.

    If the software is cloud-based, you won't have to worry about upgrades or backups, because it's all done for you. This will also let you check and manage your inventory from anywhere, at any time.

    Six ways your software can help you

    Once you have the best software for your needs, make the most of it.

    • Track the full life-cycle of your inventory, from raw materials to finished goods.
    • Set up indicators and warnings when stock reaches certain levels – not too high or low.
    • Take holidays into account. And don't forget historical and seasonal trends.
    • Allow for differences between online and offline retail. Think about popular selling days, stock turnover and delivery considerations.
    • Understand the impact of shipping costs on different items.
    • Incorporate all this information into your business and accounting workflow.

    Get your priorities right

    The 80/20 rule often applies in business. This means 20 percent of your product line might generate 80 percent of your sales. So it makes sense to concentrate on that 20 percent – especially if you're introducing a new inventory system.

    Use your accounting software to generate reports that identify your best sellers. Not just in terms of volume, but in terms of revenue and profit too.

    Use this information to prioritise your efforts. Once you get that right, you can move on to the remaining products.

    10 ways to look after your inventory

    You wouldn't leave a big pile of money in the middle of your shop floor, unattended and unprotected. Since stock has financial value, it's important to look after it sensibly.

    1. Decide who can order the inventory in your company. Restrict purchasing access to those people – no others.
    2. Account for your stock carefully – make sure you know what it's worth.
    3. Decide how to handle products that don't sell. Try to make at least some money from them.
    4. Budget sensibly to limit the amount of money spent on stock.
    5. Track the movement of items inside your company – and outside if possible.
    6. Use proper labels and signs in your warehouse, so you and your staff can locate everything.
    7. Always use consistent units of measure. For example, don't mix pounds and kilograms.
    8. Think about where your fire extinguishers and sprinkler systems are located.
    9. Make sure your security is adequate for the value of the items you're storing.
    10. Develop a training plan for new employees to explain how the system works.

    Efficient inventory management means better cashflow

    A great inventory management system can help your business become more efficient. It will reduce waste, decrease the time that each item spends in your warehouse and help you predict future demand.

    If you sell physical items, proper inventory management is key to your company’s well-being. With money invested up in every different type of item, even small efficiencies can make a big difference.

    If this is tied into cloud-based accounting software, you can have the best of both worlds. You'll have an effective stock tracking solution coupled with clear financial reporting. And you'll be able to manage everything on-site and remotely.

    The less money you have tied up in unproductive stock, the more you'll have for other areas of business. And that means greater cashflow, which is what your business needs to survive and thrive.


This content is provided courtesy of Xero Accounting Software - used by hundreds of thousands of businesses all over the world.