Inventory reports, read correctly, show in just 15 minutes a week which products are earning money, which ones are tying up cash on the shelf, and which items are about to run out; checking four reports regularly — best/worst sellers, profit margin, stock aging, and low stock — makes these decisions possible.
What does the best/worst sellers report tell you?
This report shows which products carry the bulk of your revenue and which ones have barely sold in months. Typically, about 20 percent of your products generate 70-80 percent of your revenue; keeping this top tier always in stock and never letting it slip into low-stock territory should be a priority. The worst-selling tier points to one of two things: either the product is positioned wrong (shelf placement, price, promotion), or there simply isn't demand — in the second case, it's time to clear the product out and redirect that capital toward something that actually turns over.
Why does the profit margin report matter more than the revenue report?
A product that looks like a big revenue generator contributes little if it sells at a thin margin. For example, a product group bringing in $20,000 a month at a 10 percent margin generates $2,000 in profit, while another group bringing in just $8,000 at a 40 percent margin can generate $3,200. The profit margin report shows which category actually makes you money; promotions and shelf priority should be decided based on this report, not on revenue alone. We covered the details of this calculation in our profit and loss analysis guide.
What is the stock aging report for?
Stock aging shows how long a product has been sitting in the warehouse or on the shelf without moving. A product that hasn't moved in more than 90 days is considered dead stock in most industries, and it locks up capital. For example: if a product group worth $15,000 hasn't sold in four months, that money can't be used as working capital anywhere else in the business. Reviewing the aging report once a month means you make the call to discount or clear stock early rather than late. For those who want to measure how fast stock actually turns over, our inventory turnover ratio guide complements this report.
How should the low-stock list be used?
The low-stock list shows products that have dropped below a defined minimum level; its purpose is to trigger an order before the product actually runs out. The minimum level is set based on a product's average weekly sales and the supplier's delivery time — for example, a product that sells 20 units a week and whose supplier delivers in 5 days should have a minimum level of at least 15-20 units. Failing to check this list weekly means your best-selling products run out right when demand is highest, which translates directly into lost revenue.
How do you set up a 15-minute weekly reporting routine?
- Check the low-stock list and flag items that need ordering. (5 minutes)
- Check the stock level of your top 10 best sellers. (3 minutes)
- Glance at your 10 worst sellers and note any that have stayed the same for three weeks running. (3 minutes)
- Look at the profit margin report for any major deviation from last week. (2 minutes)
- Check whether any new items have crossed the 90-day mark in the stock aging report. (2 minutes)
Trying to piece this routine together by hand from separate spreadsheets usually takes 1-2 hours, which is why most owners end up never looking at their reports at all. In a system like Welda Stock, these four reports are generated automatically, and the weekly routine really does shrink down to 15 minutes.
What does making decisions based on reports actually look like?
Three concrete examples: a stationery store notices in its worst-sellers report that a notebook line hasn't moved in three months, pulls it from the most visible shelf spot and replaces it with a best seller — that category's revenue rises 18 percent that month. A cosmetics store notices in its profit margin report that one brand runs at a 15 percent margin while an equivalent-demand alternative brand runs at 35 percent, and shifts shelf space accordingly. A houseware shop sees in its low-stock list that its best-selling holiday product group will run out in 10 days and places an early order to avoid going out of stock.
Who should read the reports, and how often?
In a small business, the owner should run this routine themselves; in a business with 2-3 branches, each branch manager should read their own report while the owner reviews a weekly consolidated summary. Even if the person reading the report changes, the format and frequency should stay fixed — otherwise comparison becomes impossible and the trend gets lost. We covered how this consolidation is set up in multi-branch structures in our multi-location inventory management guide.
Why should reports and physical counts be verified together?
The report in your system shows recorded movements; a physical count confirms actual stock. If a persistent gap keeps showing up between the two, something is wrong — shrinkage, theft, or a recording error. Businesses that skip this verification may end up trusting their reports and trying to sell stock that doesn't actually exist. We covered how often and how to run this check in our how to do a stock count guide.
Should reports be read differently during seasonal or campaign periods?
During periods like holidays, back-to-school, or summer season, the 'best sellers' list shifts away from a normal month's pattern, and that shift is temporary; during these periods, check the low-stock list every 2-3 days instead of weekly, since demand can spike to 2-3 times normal. After a campaign, the opposite caution applies: some products stocked up before a promotion suddenly slow down once it ends; catch these early in the stock aging report and either hold them for the next campaign or clear them quickly. Comparing against the same period last year is the most reliable way to forecast seasonal demand.
Which report should a brand-new business start with?
For a new business that doesn't have a full year of data yet, the most useful starting point is the low-stock list and the best/worst sellers report; these come together quickly and become actionable from the very first weeks. The profit margin and stock aging reports only become meaningful once you've accumulated at least 2-3 months of data — looking at them and making early calls before that can be misleading, since a new business's uneven early sales pattern hasn't settled into a normal rhythm yet.
Should you focus on the number or the trend?
Looking at a single week's number and rushing to a decision is one of the most common mistakes; a drop in one product could be caused by something one-off that week (weather, a local event, a supply delay). The right approach is to line up the last 3-4 weeks side by side and evaluate the direction — is it rising, falling, or flat? For example, if a product has dropped for three weeks in a row, that's a trend and calls for action; a product that dips one week and bounces back the next is probably just normal fluctuation and doesn't call for a hasty decision.
How do you spread the reporting habit across the team?
Keeping report-reading as a 'secret' only the owner knows isn't healthy in the long run. Teaching a shift supervisor to read the weekly low-stock and best-seller reports means critical calls — like placing an urgent order — still get made on time even when the owner is on leave or busy with something else. When handing this off, leaving behind a short written guide on how to read the report prevents interpretation from becoming inconsistent from person to person.
Why should a supplier-level report be tracked separately?
Alongside product-level reports, pulling a supplier-level summary shows which supplier delivers a better profit margin and which one's delivery delays are causing low-stock problems. For example, if one supplier's products sell at an average 22 percent margin while an equivalent product from another supplier sells at 35 percent, gradually shifting order volume to the second supplier directly boosts profitability. Continuing on habit alone — 'we've always ordered from this supplier' — without ever making this comparison can quietly erode profit.
How long should report data be kept?
To make year-over-year comparisons (like comparing this year to the same period last year), you need at least 24 months of historical data — it's the only reliable way to separate seasonal demand from a genuine growth trend. Keeping data intact for that long is hard with paper records or digital files that aren't backed up regularly; in a cloud-based inventory/POS system, historical data is stored automatically and year-over-year comparisons take just a few clicks.
How do barcodes and category structure affect report accuracy?
No matter how well a report is designed, if the underlying data is messy — the same product entered under two different names, categories used inconsistently — the report gives misleading results. For example, if a product is sometimes entered as 'red shirt' and sometimes as 'shirt red L', the best-sellers report may show it as two separate line items and hide its real ranking. Working with barcodes and setting up a consistent category structure from the start is a precondition for reliable reports; we covered how to lay that foundation in our barcode inventory tracking guide.
How long does it take to build the habit of reading reports?
The first few weeks of checking reports can feel forced and time-consuming; the real payoff usually shows up after 6-8 weeks of consistent tracking, because that's the minimum amount of data needed to compare week over week and actually see a trend. Not giving up in those early weeks doesn't mean the report 'isn't working' — it just means enough comparison points haven't built up yet. Once the habit sticks, that weekly 15 minutes becomes one of the most productive stretches of time in an owner's week.
Why can it help to share report results with staff?
Briefly sharing simple results like best-selling products and the weekly revenue trend with the sales team makes staff care about these numbers too; an employee who knows which product to recommend first and which one is still tying up cash on the shelf shapes their selling behavior accordingly. Keeping the numbers entirely hidden and just imposing decisions from above can leave staff unable to answer 'why are we pushing this product', leading them to follow instructions half-heartedly. We covered how this kind of sharing ties into shift scheduling and commission systems in our staff management guide.
Do you need special software to read reports?
A business running a very small number of products can initially keep these four reports in a simple spreadsheet; but once your product range passes 100 items and daily transactions pass 30-40, a manually updated table quickly loses both its accuracy and its currency. For businesses approaching that threshold, switching to an inventory/POS system that generates these reports automatically is less about saving time and more about protecting decision quality, because a manually kept table tends to fall behind, and decisions end up based on stale data instead of current numbers.
Conclusion: is reading reports a habit?
Inventory reports create the most value not as a document you glance at once at month's end, but as a short weekly habit. If you'd like to review your current reporting setup or automate these four reports, get in touch with us.