Distributor Stock & Sales Statement: How to Read and Analyze It.
Every month, a sheet lands in a sales manager's inbox. It's a distributor's stock and sales statement. Most of the time it gets a quick glance at the total, a nod, and a place in a folder.
That's a missed opportunity. A stock and sales statement is one of the few documents that shows you what is happening below your own invoices: how much stock the distributor holds, how much they sold, and whether the two numbers make sense together. Read properly, it can tell you about over-stocking, slow-moving SKUs, stock being pushed to hit a scheme, and distributors whose reported sales look too neat to be true.
This guide explains what a stock and sales statement contains, how to check that it adds up, which ratios matter, and which warning signs are worth a phone call.
What a Distributor Stock and Sales Statement Is
A stock and sales statement (often called an S&S statement or stock statement) is a periodic report a distributor sends to the brand. It summarizes stock movement for the period, usually a month, and often SKU by SKU.
A typical statement includes:
- Opening stock — what the distributor held at the start of the period.
- Purchases or receipts — stock received from the company during the period (your primary sales to them).
- Sales — stock sold by the distributor to retailers and other buyers (secondary sales).
- Returns, damages, expiry, and adjustments — stock that moved out of saleable inventory for other reasons.
- Closing stock — what the distributor held at the end of the period.
Some companies also ask for outstanding balances, scheme claims, or outlet-wise sales. Formats and terminology differ between companies, so check what your own template calls each column before comparing numbers across distributors.
The Basic Equation Behind Every Statement
Every stock statement rests on one simple relationship:
Opening stock + Purchases − Sales ± Returns, damages, and adjustments = Closing stock
If a statement doesn't follow this, something is wrong. It may be an arithmetic error, a missing entry, or a number that was adjusted to make the sheet look right.
Here's an illustrative example for one SKU, in cases. These numbers are made up to show the method. A distributor reports opening stock of 100 cases, purchases of 300 cases, sales of 320 cases, and 5 cases of damaged stock. The closing stock should be 100 + 300 − 320 − 5 = 75 cases. If the statement shows 90, there are 15 cases unaccounted for. That gap is the question to ask.
One practical tip: reconcile in units or cases wherever you can. Stock is often valued at purchase cost while sales are valued at selling price, so value-based columns won't tie out neatly even when the statement is accurate.
How to Read Each Part of the Statement
Opening stock
This should match the previous month's closing stock exactly. If it doesn't, ask why. A quiet change between two statements is a common sign that numbers are being adjusted after the fact.
Purchases
Match the purchases column with your own primary invoices for the same period. Differences often come from stock in transit, invoices dated at month-end, or entry errors. A distributor who reports fewer purchases than you invoiced may be recording stock when it's received rather than when it's billed, which is fine, but should be consistent.
Sales
This is the number that matters most, and the hardest to verify. Look at it SKU by SKU. Which products are moving, which are not, and does the pattern fit what you know about the territory? Compare it with the previous three to six months. A sudden jump or fall deserves an explanation.
Returns, damages, and expiry
Some leakage is normal. What matters is the trend. A rising share of damages or near-expiry stock can point to poor storage, over-stocking of slow movers, or products that retailers aren't buying.
Closing stock
Check that it ties out with the equation, and then ask whether it makes sense for the distributor's sales rate. Very high stock suggests over-buying. Very low stock on fast-moving SKUs suggests stock-outs and lost sales.
Ratios Worth Calculating
The statement gives you the raw figures. A few simple ratios turn them into insight:
Stock days (days of inventory). Closing stock divided by average daily sales. In the example above, 320 cases sold over 30 days is roughly 10.7 cases a day. With 75 cases in closing stock, the distributor has about 7 days of stock. Whether that's healthy depends on your delivery cycle, but a distributor with 7 days of stock and a 10-day replenishment cycle will run out regularly.
Sell-through. Sales divided by purchases over the period. Looking at one month can mislead, because stock moves between months. Track it over a quarter. A ratio that stays well below 100 percent means stock is building up. One persistently above 100 percent means the distributor is drawing down stock and will need to reorder.
SKU-wise stock against sales. Fast-moving SKUs with thin stock and slow-moving SKUs with heavy stock show where the distributor's ordering doesn't match demand.
Returns and damage percentage. Returns and damages divided by sales or purchases, tracked over time.
Stock against outstanding. If a distributor has a large outstanding balance and a large closing stock, they may be struggling to sell what they've bought. That combination is worth watching.
Red Flags to Look For
- The statement doesn't reconcile: opening plus purchases minus sales and adjustments doesn't equal closing.
- Opening stock differs from last month's closing stock without explanation.
- Purchases spike near the end of a scheme or target period while sales stay flat, which can indicate stock being pushed rather than sold.
- SKUs with purchases but no sales for several months, or stock that never changes.
- Sales figures that look suspiciously round, or nearly identical month after month.
- Negative stock, or sales that exceed opening stock plus purchases.
- Large or frequent adjustments with no clear reason.
- Sales bunched into the last few days of the month.
- Late, incomplete, or constantly changing statement formats.
- Closing stock that doesn't match what you see in a physical check of the godown.
None of these proves anything on its own. They are reasons to ask questions, not conclusions.
7 Steps to Review a Stock and Sales Statement
1. Use a consistent format
Ask every distributor to report in the same template, with the same columns, units, and period. Comparing statements across distributors is nearly impossible when each one uses its own layout.
2. Check the arithmetic
Run the basic equation for each SKU and for the total. Flag anything that doesn't tie out.
3. Compare opening stock with last month's closing stock
They should match. If they don't, find out why before moving on.
4. Match purchases with your own primary invoices
Reconcile receipts against what you billed. Note stock in transit and timing differences so they don't trigger false alarms next month.
5. Review SKU-wise sales and stock
Look for fast movers running short, slow movers piling up, and any sudden changes in pattern compared with previous months.
6. Calculate stock days and sell-through
Use these to judge whether the distributor is over-stocked, under-stocked, or buying in line with demand.
7. Verify and follow up
Spot-check stock physically on a sample of SKUs and, where possible, compare reported sales with what your field team sees in outlets. Record the questions you raise and the answers you get, so patterns are visible over time.
Common Mistakes When Reading Stock Statements
- Looking only at the total and ignoring SKU-level detail.
- Accepting statements late or in different formats from each distributor.
- Not comparing with previous months, which hides trends.
- Reading value columns without checking quantities.
- Treating reported sales as verified fact when it is self-reported.
- Ignoring adjustments and damages because the amounts look small.
- Using the statement only to find fault, instead of to help the distributor plan stock better.
- Never checking physical stock against the report.
Why Manual Statements Only Go So Far
A monthly stock statement has built-in limits. It's prepared by the distributor, often manually, after the month has ended. It reflects the distributor's own records, and it reaches you days or weeks late. By the time you spot a problem, the next month has already begun.
This is why many brands move towards systems that capture distributor and field data as transactions happen. When orders, dispatches, and outstanding balances are recorded at the source, the numbers on the statement become something you can cross-check rather than simply accept. Depending on the platform, this can include secondary sales captured with each order, order-to-dispatch tracking, outstanding tracking by customer, and dashboards that bring the figures together across distributors.
How Rupyz Helps You Cross-Check Distributor Data
Rupyz is a B2B SaaS platform for FMCG brands, distributors, and field sales teams, covering sales force automation, field sales management, B2B e-commerce, order management, and distributor and retailer management.
A few capabilities are relevant to reading stock and sales data. Rupyz supports secondary sales management, with on-the-go order capture, tracking of no-order visits, and automated daily sales reports. Order management tracks the order-to-dispatch workflow with real-time updates, and customer outstanding tracking sits within the same platform. The B2B storefront provides real-time inventory updates, reporting is available through customizable dashboards, and Tally integration is supported for businesses that keep their accounts there.
Having this data captured as work happens gives brands something concrete to compare against a distributor's monthly statement. It doesn't replace the judgment involved in reading it, but it makes the questions sharper.
Frequently Asked Questions
What is a distributor stock and sales statement?
It's a periodic report, usually monthly, in which a distributor shows opening stock, purchases from the company, sales to retailers, returns and damages, and closing stock. Brands use it to see how stock is moving beneath their own primary invoices.
How do you check if a stock and sales statement is correct?
Run the equation: opening stock plus purchases minus sales and adjustments should equal closing stock. Then match opening stock with last month's closing stock, compare purchases with your invoices, and spot-check physical stock for a sample of SKUs.
What is the difference between primary and secondary sales in the statement?
Purchases represent primary sales, the stock the company sold to the distributor. The sales column represents secondary sales, the stock the distributor sold on to retailers. Comparing the two shows whether stock is moving through or building up.
How do you calculate stock days from the statement?
Divide closing stock by average daily sales. For example, 75 cases of closing stock against 320 cases sold in 30 days is roughly 7 days of stock. Compare the result with your replenishment cycle to judge whether the level is healthy.
What are the warning signs in a distributor's stock statement?
Common signs include figures that don't reconcile, opening stock that differs from last month's closing stock, purchases spiking while sales stay flat, SKUs with no sales for months, unusually round numbers, and frequent unexplained adjustments.
How often should you review distributor stock statements?
Monthly is the usual rhythm, with a closer look each quarter at trends in stock days, sell-through, and returns. High-volume or high-risk distributors may justify more frequent checks, especially around scheme periods or target deadlines.
Why might a distributor's reported sales not match primary sales?
The difference is normally stock. If sales are lower than purchases, stock is building up. If higher, the distributor is drawing down inventory. Timing, in-transit stock, returns, and reporting errors can also explain gaps, so track the pattern across several months.
Can software replace the monthly stock statement?
Software that records orders, dispatches, and outstanding balances as they happen can reduce reliance on manual statements and make data easier to verify. Capabilities vary by platform, and many brands still use periodic statements alongside system data.
We would love to give a comprehensive walk through of our system & demonstrate how we can contribute to your growth story.
For More Info Contact Us
Website: - https://rupyz.com/

No comments:
Post a Comment