Reconciling Dealer Stock with Secondary Sales: A Monthly Routine

Companies that sell through dealers often measure success by what they sell to the dealer: primary sales. But the dealer is only a stop on the way to the shop and the consumer. If the dealer buys more than the market takes, stock builds up. Sooner or later it shows up as slower orders, requests for returns, pressure on price or expiry. A monthly reconciliation between what the dealer bought, what they sold on and what they hold gives you a view of the real market.

The reconciliation equation

Line	Meaning
Opening stock	What the dealer held at the start of the period
+ Purchases	Primary sales from you to the dealer
− Secondary sales	What the dealer sold to shops
± Returns and adjustments	Customer returns, damages, transfers
= Expected closing stock	What the dealer should hold
Actual closing stock	What a physical count finds
Variance	Actual minus expected

If variance is small and explained, the system is trustworthy. If it is large or repeated, it is time to look closer.

Run the count

1. Agree a count date with the dealer in advance.
2. Count by product and, where relevant, by batch.
3. Record the count the same day, with a photo if it helps.
4. Compare with expected closing stock.
5. Discuss differences with the dealer on the spot.
6. Record agreed explanations and follow-up actions.

Typical causes of variance

• Secondary sales that were not recorded.
• Returns taken from shops but not logged.
• Damaged or expired goods set aside.
• Counting mistakes.
• Transfers to a sub-dealer or another location.
• Sales outside the dealer's territory.
• Theft or loss.

Classify each variance by cause. Over a few months, you will see what is systemic.

Using the result

Finding	Action
Stock above expected, sell-out slow	Reduce next fill, review shop reorders
Stock below expected	Check unrecorded sales or leakage
Close to expiry	Redirect, bundle, request returns
Consistently accurate	Consider lighter checks, more trust

Link results to targets and schemes: see the super-stockist and dealer model and dead and slow-moving stock.

Keeping the data clean

• Every shop order supplied by the dealer should be recorded as a secondary order.
• Returns should be logged when they happen.
• Shops should be linked to their dealer.
• Field staff should check shelf stock, so secondary orders and shelf reality can be compared.

How to run it in gamitrack

1. Set supply mode to via-dealers and link shops to dealers.
2. Book secondary orders for shops; the dealer fulfils them in the dealer app, creating the sell-out record.
3. Invoice primary sales to the dealer and track payments in the ledger.
4. Record the monthly dealer stock count. The count compares expected closing with actual and shows variance.
5. Handle returns. A shop's return in via-dealers mode goes to its dealer to accept or reject; the dealer's own returns to the company are approved into a branch with a credit note.
6. Set dealer targets by Nepali fiscal quarter and monitor secondary sales against them.
7. Review reports for dealers with persistent variance and slow sell-out.
8. Use schemes based on fulfilled secondary sales so rewards follow actual sell-out.

Related: dealer and distributor management for primary and secondary sales. Beverage and FMCG companies can see beverages and FMCG and packaged food.

A hypothetical example

Imagine Example Foods (an invented name) with a dealer whose month-end count shows more stock than expected on two products. The dealer explains that two shops returned goods by hand, and the returns were not logged. The officer records them, the variance clears, and the dealer agrees to log returns promptly. On a third product, the count is below expected with no explanation. The manager asks the officer to check the shops in the territory and notes the item for the next count.

Monthly reconciliation checklist

• Count dates set with each dealer.
• Counts recorded and variances calculated.
• Causes classified and actions agreed.
• Fills adjusted for next month.
• Persistent variance escalated.

Common mistakes

• Counting only when something looks wrong.
• Accepting unexplained variance as normal.
• Failing to log returns.
• Using primary sales to judge dealer performance.
• Never sharing results with the dealer.

Making the count a cooperative routine

Dealers sometimes see counts as an audit and resist them. Present the count as a service: it helps both sides plan fills, avoid expiry and resolve disputes. A few habits help:

• Schedule counts in advance and keep to the same day each month.
• Share the result with the dealer straight away.
• Fix process gaps together, such as unlogged returns.
• Recognise dealers with accurate records.
• Use the results to adjust fills, not to punish.

A simple variance log

Date	Dealer	Product	Variance	Cause	Action	Owner
Month-end	Name	SKU	Units over or under	Classified cause	Agreed step	Person

A log like this, even if it is short, turns scattered conversations into a pattern you can review each quarter. Dealers with a clean history can move to lighter checks; those with repeated gaps get closer attention and clearer rules.

Linking reconciliation to schemes and targets

When rewards are paid on fulfilled secondary sales rather than on primary purchases, dealers have a reason to record sell-out properly. Pair reconciliation with scheme approval: before a reward is approved, check that the dealer's stock count is in order. This keeps incentives aligned with real market movement.

Summary in one line

Track what the dealer bought, what they sold on and what they hold, compare it with a physical count each month, and talk about the gap openly. Over a few cycles, the pattern of variances tells you whom to trust, whom to support and where stock is quietly building up.

Next step

Choose your three largest dealers and schedule their first monthly count. Plans are on the pricing page.