Start with the ledger. At the start of the month you sent your 3PL several pallets. At month end, the 3PL inventory report shows a closing figure a few dozen cases away from your own books. You ask, and the reply comes back: it is still in transit, not yet received. If you let that answer stand, you have effectively accepted it. My approach is never to argue first. I take the report apart. A total that ties does not mean the books tie, and a total that does not tie does not automatically mean the 3PL is wrong. Reading a 3PL inventory report is not reading one number. It is checking whether four tables bite into each other.
Reading a 3PL Inventory Report Starts With Definitions, Not Numbers
A usable monthly report should contain at least four tables: on-hand detail, in-transit detail, a slow-moving list, and a variance and adjustment record. Before you look at the size of any number, check the definitions. First, is on-hand a snapshot at close of business on the last day of the month, or a mid-month snapshot? Different cut-off points guarantee different numbers. Second, does in-transit include goods that have arrived but have not yet been put away? That batch is the easiest to lose between two sets of books, because neither side quite claims it. Third, is slow-moving defined by days without movement, or by items you flagged as slow sellers? Change the definition and the quantity changes overnight. Fourth, does every adjustment carry a document number and a reason? An adjustment without a document behind it might as well not be written down.
I always run one simple reconciliation first: closing on-hand should equal opening on-hand, plus receipts for the month, minus shipments for the month, plus adjustments confirmed during the month. If that equation does not hold, set every other explanation aside. I once worked through a report where the equation would not balance, and at the very end we found that a batch of returns had been recorded as receipts but never flowed into the on-hand detail. Nobody had taken anything. Two tables simply had not been aligned.
| Table | Check first | When it does not tie, it usually means |
|---|---|---|
| On-hand detail | SKU, batch, location and quantity, line by line | A putaway, transfer or stock count step was left unfinished |
| In-transit detail | Transit status and expected putaway timing | Arrived but not put away, or a timing gap between shipping and receiving |
| Slow-moving list | How idle time is defined, and whether pending items are included | Definitions differ, or slow items are mixed into normal stock |
| Variance and adjustment record | A document number and reason for every adjustment | An adjustment without evidence, or a count variance not yet closed |
Run through it in order when a report lands. Wherever it sticks, start asking questions there.
Case One: The Total Tied, and the Detail Still Did Not
A home-goods client had monthly totals that tracked his own books closely for several months, so he never dug deeper. Then he needed to replenish stock for a major customer, ordered based on the reported on-hand figures, and was told several styles simply could not be put together. Opening the detail told the story: the total was right, but a few SKUs had been swapped against each other. One style was overstated by a few dozen cases, another understated by roughly the same amount, and the pluses and minuses cancelled out.
That kind of error is the hardest to catch, because a tying total is exactly when people relax. My method is sampling, not a full recount. Each month, pick a handful of fast-moving, high-value SKUs, plus any with recent returns or packaging changes, and match your own records against the report detail line by line. The point is batch and location: a batch mismatch suggests picking against the wrong batch, a location mismatch suggests an unrecorded transfer. A few sampled SKUs are enough to judge whether the detail can be trusted. If it cannot, a tying total is worth nothing.
Variances in a 3PL Inventory Report Fall Into Three Buckets
When a variance appears, do not assign blame first. Classify it. The first bucket is timing: goods have shipped but have not yet reached the other side's books, or have arrived but have not finished putaway. Variances of this kind usually disappear on their own next month, so wait for the cut-off to pass and reconcile again. The second bucket is documentation: a receipt, shipment or return document was missed, duplicated, or entered with the wrong quantity. These never disappear on their own; find the document and correct it. The third bucket is physical: the counted quantity genuinely differs from the book quantity, through damage, mixing between SKUs, wrong location, or genuine loss.
Classification matters because each bucket is chased differently: timing differences are not worth chasing, documentation differences must be chased to the document, and physical differences must be chased to the location and the count record. Too many people treat every variance as a physical loss, only for the 3PL to produce an in-transit document and leave them with nowhere to stand. Classify first, then speak.
Case Two: The Slow-Moving Stock That Was Not Dead Yet
Another client found a batch on the slow-moving list, untouched for months, and his first instinct was to clear it out. I asked him to hold off. Checking its history showed it was not unwanted at all. Its packaging had changed to a new version, and the old-packaging stock had been left in a separate location the sales system could not see. With no visible stock, sales could place no orders. The goods were fine; the link between location and sellable status was broken.
The real question a slow-moving list should answer is not how long something has sat there, but why. Is there no demand, or demand that cannot be turned into an order? Is packaging, batch or quality status holding it up, or has it simply been forgotten in a corner? Each cause calls for a different response. Treating slow-moving stock as one big basket and clearing everything in it is the most expensive form of laziness: clearing a batch that could still have sold loses the value of the whole batch, not just warehousing cost.
Before You Dispute, Line Up the Evidence in This Order
When a variance needs disputing, the evidence chain matters more than the tone. Prepare it in this order. First, your own receipt and shipment records, showing what the quantity should be. Second, the matching lines in the 3PL report, showing which SKU is off, by how much, and at which step. Third, the related documents: receipts, shipping notes, return notes and count records. Fourth, a timeline: when goods shipped, arrived, and were put away. On that timeline, timing and documentation differences become obvious.
Once the chain is laid out, the dispute itself does not need to be long. Three sentences are enough: how large the gap is, at which step it sits, and which documents support it. If the 3PL accepts it, the next month's report should show a corresponding adjustment record. If it does not, ask for the reason and the evidence behind the refusal, not a bare statement that everything has been checked. An acceptance without an adjustment record is not an acceptance, and a refusal without a reason is not an answer. The end of a dispute is seeing the amount settled in the next report.
The Conclusion You Can Actually Calculate
Before you sign a 3PL inventory report, run three calculations. First, does closing on-hand equal opening on-hand plus receipts minus shipments plus confirmed adjustments? If the equation fails, do not sign yet. Second, sample a handful of key SKUs for batch and location. If the detail does not tie, a tying total is no reason to sign. Third, has every variance been classified, backed by documents, and given an adjustment plan for the next period? A variance with no classification and no documents is not ready to sign.
Here is the counter-intuitive part: a report with no variances at all is not necessarily good news. With receipts, shipments, returns and packaging changes all happening, a report that stays at zero variance month after month deserves an extra question. It may mean variances were smoothed over without going through the adjustment record. A healthy report should have variances, each with a classification, a document behind it, and a closing date. Run those three calculations, and you will know whether you have actually read the report, or only glanced at its total.
By Lao Zhou, Logistics Cost Analyst
