Top 4 Inventory Reports Every Small Retailer Must Run

A quick question: hands up how many of you wait until stocktake is complete, or the accountant asks for end-of-year reports, until you realise there is a problem with your inventory? That’s not good enough and you should know better!

If your retail shop is like most others, inventory accounts for 95-100% of your sales revenue. It’s probably also where you have hundreds of thousands of dollars invested. So why aren’t you spending more time managing that investment?

We’ve observed many retail managers over the years. Without a doubt, the most successful retailers have more stock turns than average. They recoup their investment on inventory more quickly than others. To help achieve this they check a few key inventory reports on a regular basis. They use this information to improve efficiency and profitability of their shop.

When reports are looked at regularly the effort required to inspect and fix inventory problems is greatly reduced. It is quicker and easier than dealing with a few problems, sporadically, than a large number of problems all at once.So here are the four reports that, when looked at regularly, will give you maximum benefit with minimal time investment.

1. Negative Stock

Negative stock is where your POS system reports your on hand stock has fallen below zero. I.e. -1, -2, -3, etc. Essentially this means you have sold more than you have purchased for a particular product. You need to regularly run a report to locate such products.

WHY?

Stock might be negative due to:

  • Items are being incorrectly looked up by code or description instead of scanned in by barcode.
  • When similar items are presented at checkout, operators are scanning one barcode and multiplying it out, instead of scanning each item which in a customer’s basket might differ slightly in colour or size.
  • Invoicing and collecting payment from a customer before you buy in the items from your supplier. This could include special orders where you ask for the customer to pay up front.
  • Putting goods on the shop floor and selling them before the purchasing paperwork has been applied.
  • Incorrect counting at stocktake time, or manual “fiddling” with on hand stock figures in your database.

Incorrect stock counts may have company tax implications. They can also indicate that sales figures are incorrect. Are you willing to make business decisions on incorrect data? Probably not.

Finding problems sooner helps sort issues out while they are fresh in people’s minds and correct errors as you go.

HOW?

Find your inventory listing or on hand stock report, filter by quantity less than zero.

If you don’t have a filter, then sort the report by on hand quantity. This might require exporting to Excel and then sorting by the quantity column.

WHAT TO DO?

Work through a couple of products and figure out why they are negative.

  • Is paperwork behind in purchasing? Then apply all the incoming invoices from suppliers and re-run the report.
  • Are staff picking up the wrong goods when selling? Are they scanning each barcode, or multiplying out? Then let them know the effect this is having.
  • Has an error been made in purchasing? You might want to go back and alter the invoice in your system to correct errors.
  • Possibly the product was mis-counted last stocktake. Was there another box in the back room that was missed? You could re-count that product and similar products to correct the problem.

It isn’t always easy to determine why, but that isn’t an excuse for low standards. Investigating just two or three products might be enough to spot a pattern of behaviour that is affecting most or all of your negative stock problems.

And if all else fails, call your point of sale vendor for advice. They might have the ability to check things out and spot something that you couldn’t.

2. Low Margin

The margin is the difference between what you sell a product for, and what it cost you.

WHY?

Low-margin products are most likely costing you money. Remember that the margin itself (gross margin) is not “pure profit”. That margin must absorb overheads such as power and water, staffing costs, shrinkage, spoilage, discounting and loyalty benefits… basically every expense in your retail business! These margins need to be sufficiently high to sustain your business, so any product that is being sold with a low margin could in fact be costing you money, not making you money.

HOW?

Inventory report again, and this time filter by a low margin percentage.

Don’t have this? Try exporting to Excel and sorting in there.

Most retailers will know what “low” means for their particular niche. Unless you are selling a commodity or are in the supermarket game, we suggest you start by looking at anything less than 10% gross margin. Then once they are adjusted, look at anything less than 20%.

WHAT TO DO?

Work from the lowest margin products that are selling below-cost (zero or negative margin) or with a very small margin. If you have many of these, concentrate on those products that you know are popular, and/or those that are priced high. These are the ones that are costing you the most money.

Some products might be loss-leaders, but never assume these are driving sales of higher-margin products!  Check some sales transactions to verify that customers really are buying more than simply low-margin baskets of products.

To fix the problem, consider raising the price of low-margin product, even slightly, to improve profitability.

Or decide to not stock them anymore. You can sell out of your current stock and do not reorder. Why waste retail floor space on unprofitable products?

3. High Margin

High-margin products is an often overlooked area of inventory.  They sound great, but might indicate a problem.

WHY?