Van Sales Stock Reconciliation: Prevent Losses

Why Van Sales Stock Is a High-Risk Area

Van sales is a high-trust model. You load product onto a rep's vehicle, send them out into the field, and trust that every unit is accounted for at the end of the day. For most reps, the system works. But without a formal reconciliation process, the few cases that don't work out can add up to tens of thousands of rands in untracked losses over a year.

Van sales stock reconciliation — the daily process of accounting for every unit that was loaded, sold, returned, damaged, or written off — is the single most important control you can put in place for a van sales operation. This guide covers how to do it properly, how to make it fast, and how to build a culture where reconciliation is routine rather than confrontational.

Automate your daily van stock reconciliation. Start your 14-day free trial — no credit card required.

The Three Sources of Van Stock Discrepancy

Before designing your reconciliation process, it helps to understand why variances occur. In most South African distribution operations, discrepancies come from three sources:

1. Administrative Errors

This is by far the most common cause of stock variance, and it is not malicious. A rep records a sale of 12 units when the customer actually took 15. A return is received but not captured in the system. A stock transfer between two vans is done informally without a record. A write-off for damaged stock is never entered.

These errors compound quickly. A variance of two or three units per day becomes a mystery of 60-90 units per month that cannot be traced.

2. Theft or Pilferage

Difficult to prove without records — and impossible to address fairly without them. Pilferage can happen at the depot during loading, in transit, or at the point of sale. Without a chain-of-custody record showing exactly what was loaded, who signed for it, and what was sold to whom, there is no way to pinpoint where stock disappeared.

Digital reconciliation does not stop theft, but it narrows the window significantly. If loading is confirmed digitally and every sale is captured in real time, the period of unaccounted stock is minutes rather than days.

3. Damaged and Expired Stock Not Written Off

Stock that is damaged in transit or reaches its expiry date while on the vehicle must be formally removed from the sellable count via a write-off. If it is not written off, the system thinks the stock still exists. When the physical count comes and the units are not there, a variance appears that has nothing to do with theft or poor record-keeping — it is simply housekeeping that was not done.

Many FMCG businesses lose significant value annually to unrecorded write-offs for damaged stock, and their reps take the blame for variances that are actually a process failure.

The Daily Reconciliation Formula

The formula is simple and should be applied every single working day:

Opening Stock + Received Today − Sold Today − Customer Returns − Write-offs = Closing Stock

The closing stock must equal the physical count at end of shift. If it does not, the variance needs to be explained before the rep goes home.

In a paper-based system, this formula is completed on a stock sheet. In a digital system, the formula is calculated automatically from the transactions recorded during the day, and the rep simply confirms their closing count.

Digital vs Paper-Based Reconciliation: The Practical Difference

For a rep carrying 40 SKUs, paper-based reconciliation can take 90 minutes to two hours at end of day. They are cross-referencing their sales dockets against their stock sheet, counting physical units for each SKU, and filling in a form manually.

With a digital stock management system, the same process takes 20-30 minutes. The rep's sales have been captured in real time throughout the day. At end of shift, they enter their physical closing count by SKU. The system calculates the variance instantly and highlights any SKU where the count does not match the running total. The rep only needs to investigate and explain the discrepancies, not reconstruct the entire day.

SalesRep Software's mobile app handles real-time stock adjustments with every sale, so the daily reconciliation is a confirmation rather than a calculation.

What a Variance Report Looks Like

A good variance report shows, by SKU:

Opening stock (confirmed at start of day)
Units received (top-up loads during the day)
Units sold (from transaction records)
Units returned (from customers)
Units written off (with reason code: damaged, expired, sample)
Expected closing stock (calculated by the formula)
Actual closing stock (physical count entered by rep)
Variance (expected minus actual, highlighted if non-zero)

A variance of zero for every SKU means the rep is balanced. A positive variance (more physical stock than expected) usually indicates an unrecorded return or a sale that was entered incorrectly. A negative variance (less physical stock than expected) is the one that needs investigation.

Use SalesRep Software's analytics tools to track variance trends over time.

Setting the Threshold: What Triggers an Investigation?

Not every variance of one unit warrants a formal investigation — reps are human and minor counting errors happen. Most businesses set a threshold: variances below a set rand value are noted and carried forward with a comment; variances above the threshold trigger a formal investigation.

A common approach:

R0–R50 variance: noted, rep provides a brief explanation
R51–R500 variance: documented explanation required, manager reviews
R500+ variance: formal investigation, chain-of-custody review, management sign-off

The threshold should be set thoughtfully. Too low and you create administrative burden for trivial errors. Too high and genuine losses get absorbed without investigation.

Chain of Custody: The Full Record From Depot to Customer

A properly controlled van sales process has a documented chain of custody for every unit of stock:

Depot loading: stock counted and confirmed, rep signs for the load
Top-up loads during the day: each additional load signed for separately
Customer deliveries: each sale linked to a specific outlet, with proof of delivery
Returns: each return linked to the customer it came from, with a reason
Write-offs: each write-off recorded with a reason code and quantity
End-of-day: physical count confirmed by rep, variance signed off

If stock goes missing, you can look at this chain and identify exactly where the gap appears. That is the basis for a fair investigation.

Batch and Serial Number Tracking for Pharma and High-Value Goods

For pharmaceutical and high-value product distribution, SKU-level reconciliation may not be sufficient. Batch number tracking — recording which specific batch of product was loaded, sold, and to which outlet — is required for cold chain compliance and product recall purposes.

Under South Africa's medicines regulatory framework, pharmaceutical reps and distributors must be able to trace the movement of a specific batch of product from manufacturer to patient. This means your reconciliation system needs to record not just "12 units of Product X were sold" but "12 units of Batch B2025-04 of Product X were sold to Clicks Store #104 at 10:45am."

This level of detail is achievable with digital tools and essentially impossible to manage accurately on paper at any reasonable volume.

Building a Reconciliation Culture

The biggest obstacle to daily reconciliation is not the process — it is the attitude. Reps who view reconciliation as a punishment or an accusation resist it. Reps who understand that reconciliation protects them embrace it.

Frame it this way with your team: if stock goes missing on your watch and you have no records, you cannot defend yourself. If stock goes missing and your records show exactly what you sold and where, the problem can be traced to loading or transit — not to you.

Give your reps the tools to protect themselves and your stock. Start your 14-day free trial — no credit card required.

Practical steps to build the culture:

Start with the why: explain that reconciliation is about accuracy, not suspicion
Make it easy: if reconciliation takes two hours, reps will avoid it; if it takes 20 minutes, they will do it
Be consistent: enforce reconciliation every single day, not just when you suspect a problem
Acknowledge clean months: recognise reps who maintain zero variance consistently
Investigate professionally: when variances occur, investigate the data before making any accusation

Connecting Daily Reconciliation to the Monthly Stock Count

Daily reconciliation keeps variances small and traceable. Monthly stock count confirms that the daily running totals have been accurate throughout the month. Together, they create a two-layer control that catches both day-to-day errors and systematic drift.

At month-end, pull the closing stock balance from the daily reconciliation records and compare it against a full physical count of every vehicle. If the two numbers match, your daily reconciliation process is working. If there is a significant difference, investigate which days' reconciliations may have been incomplete or inaccurate.

Over time, a well-run reconciliation process should result in monthly variance below 0.1% of total stock value moved. Any business managing above 0.5% variance has a process or culture problem that needs to be addressed.

A digital reconciliation system makes the daily formula automatic and the monthly comparison instant. If your team is still doing van stock reconciliation on paper, you are spending hours on a process that should take minutes — and you are accepting a level of error that a digital system would eliminate. Start your 14-day free trial of SalesRep Software and see how fast daily reconciliation can be.