Stock Audit Trails: Why Every Unit Movement at Your 3PL Should Be Time-Stamped

A stock audit trail is the time-stamped record of every movement a unit makes inside your 3PL's warehouse: who moved it, what it was, where it went, when and why. It turns stock disputes into lookups rather than arguments. At Fulfil with Synergy, the RedPrairie Dispatcher WMS logs every movement down to unit, SKU, batch and location.

‍

A stock figure on its own is a claim. A stock figure with a full movement history behind it is evidence. That difference is why we built the technology and automation behind the Northampton operation around a warehouse management system that records every scan, and why every brand should expect the same from its fulfilment partner.

A stock figure is a summary; the audit trail is the story behind it

A stock movement audit trail is a chronological record of events that change where a unit is, what state it is in, or how many of it the warehouse holds. The movement history helps explain how your on-hand figure changed and provides evidence for investigating discrepancies. Our earlier piece on how RedPrairie Dispatcher runs inside the Northampton warehouse explains the WMS as a whole; this article goes deeper on the movement record itself and how you can put it to work.

Five questions every movement record has to answer

Each entry in the trail should answer five questions, and a record missing any one of them is far less useful when something goes wrong.

‍

• Who: the named user, scanner or automated process that made the movement. "System" is acceptable for automated moves; "unknown" never is.
• What: the SKU, the quantity, and where relevant the batch or lot number and best before or expiry date.
• Where: the location the stock came from and the location it went to, down to the bin, pallet position or tote.
• When: a date and time stamp generated by the system at the moment of the scan, not typed in later.
• Why: the movement type and the reference that triggered it, such as a goods-in advice, an order number, a returns reference or an adjustment reason code.

‍

Two further details separate a working trail from a basic one. First, the quantity before and after each change, so an adjustment of minus six can be read in context. Second, adjustments that require a reason code before they can be saved. An adjustment with no reason is the single hardest thing to investigate months later.

The movements that should never go unrecorded

Picking is only one of many events. A complete trail covers every point where a unit is touched or its status changes:

‍

• Receipt against an advance shipping notice, including any over or under delivery
• Putaway to a storage location, and every replenishment move after it
• Transfers into and out of automated storage, such as an AutoStore grid
• Picks, packs and despatch confirmation against the order
• Returns received, graded and either restocked, held or disposed of
• Status changes such as quarantine, damaged, on hold or released
• Kitting and bundling, where components are consumed and a finished kit is created
• Manual adjustments after a count or an investigation

‍

The status changes and kitting moves are where weaker systems tend to go quiet. Stock moved into a damaged location without a record, or components used in a gift set without being booked out, will show up later as a discrepancy that nobody can explain.

Three conversations an audit trail settles in minutes

The value of a trail shows up when someone asks an awkward question. These are the three we hear most often.

"My customer says the parcel arrived with an item missing"

The trail shows which SKU and quantity were picked against that order, by whom, from which location and at what time, then when the parcel was packed and despatched. If the record shows the correct unit was scanned at pick and pack, the conversation moves to the carrier. If it shows a short pick, you know where the problem sits and the warehouse can correct both the order and the stock. Either way, nobody is guessing.

"Stock dropped and we hadn't sold anything"

Unexplained losses are where audit trails earn their keep. When a figure falls without a matching order, the trail lists every movement for that SKU in the period: adjustments, status changes, transfers and returns processing. Most "missing" stock turns out to have moved somewhere specific, such as a damaged location, a quarantine hold or a kit build, and the time stamp and user tag show exactly when and by whom. Where a real loss is confirmed, the trail points to the location and time window to look at.

"Our system says 412 and the warehouse says 398"

A mismatch between your ecommerce platform or ERP and the warehouse is often a timing issue rather than a physical one. Orders placed but not yet picked, despatches confirmed in the WMS but not yet reported back, and returns received but not yet graded all create gaps that close on their own. A time-stamped trail lets you line the two systems up minute by minute and see whether the difference is stock in transit between records or stock that has actually gone. This matters most for brands selling across several channels from multi-channel fulfilment from a single stock pool, where a lag in sync shows up as overselling on one channel and phantom stock on another.

What an audit trail cannot do on its own

A trail is only as good as the discipline behind it. If a warehouse allows stock to be moved without a scan, or lets supervisors overwrite figures in bulk, the log will be complete but wrong. The trail records what the system was told; process control decides whether it was told the truth.

‍

It also answers "what happened" more reliably than "why". A pattern of adjustments on one SKU tells you where to look, but it takes someone on the floor to find out whether the root cause is a similar-looking barcode or a supplier carton count. Batch-level traceability is only possible if batches are captured at goods-in. A 3PL that receives by SKU alone cannot later tell you which batch went to which customer, however detailed its movement log looks.

How Fulfil with Synergy records every unit movement

Fulfil with Synergy is a founder-led UK 3PL and growth partner for ambitious, fast-growing consumer brands, operating a technology-led fulfilment centre in Northampton for health, wellness, beauty, supplement and lifestyle brands across D2C, marketplace, retail and wholesale channels. Every unit in that building is tracked in RedPrairie Dispatcher WMS, a Tier 1 enterprise warehouse management system.

‍

RedPrairie Dispatcher holds real-time inventory down to unit, SKU, batch and location, and keeps a full stock movement audit trail that is time stamped, user-tagged and fully categorised. In practice that means:

‍

• Batch and date control from day one. Batches are captured at goods-in, and FEFO and FIFO rotation is applied automatically, so the trail can follow a batch from receipt to the customer's door.
• Automated and manual handling in one record. Stock moving into and out of our 57,000-tote AutoStore grid and through pick-to-light ports and put walls is recorded in the same WMS as manual pick faces.
• Exceptions caught, not buried. RedPrairie Dispatcher's exception handling flags problems as they happen rather than leaving them to surface as a discrepancy at month end.
• Your data, whenever you need it. Through the 24/7 client portal you can monitor live inventory, stock movements and allocations, alongside inbound status, order status, returns data and tracking. Custom reports can be built, and data can flow to your own systems by API, SFTP or flat file.

‍

The audit trail starts before your first order ships. During onboarding, every unit arriving at Northampton is received, scanned, located and reconciled against the inbound advice. Discrepancies are flagged in real time, photographed, logged and resolved jointly with you, and a formal reconciliation report at the end of the transition gives you a single, definitive opening position. Every movement after that builds on a figure you have already agreed.

‍

People sit behind the system. Each brand has a named Client Manager and a Client Support Specialist on the floor, working with our Inventory Manager, Anna Gawrys, and weekly operational reviews give you a standing slot to go through anything the trail has raised. For brands running an ERP, our in-house integration team connects that data directly; the Boody case study shows how our NetSuite experience featured in their decision. Gab Drake, Global Fulfilment Manager at Boody, described working with us as "Efficient, flexible and proactive." Our guide to what a fulfilment client portal should show you covers the portal in more detail.

Testing a 3PL's trail before you rely on it

The quickest way to judge an audit trail is to ask for one. Whether you are reviewing your current provider or speaking to a new one, four checks tell you most of what you need to know:

‍

1. Ask for the full movement history of one SKU over the last 30 days, and see how long it takes to arrive and whether it shows user, location, time and reason for every line.
2. Ask how manual adjustments are authorised, and whether a reason code is mandatory.
3. Ask whether you can see movement history yourself in the portal, or only on request.
4. Ask whether batch and expiry data is captured at goods-in or added later.

‍

A provider that can answer all four on the spot is usually running a disciplined floor. For the wider picture of reporting cadence and content, see our view on what good inventory reporting from a UK 3PL looks like.

FAQ

What is the difference between a stock audit trail and a stock report?

A stock report shows how much of each SKU is on hand at a point in time. A stock audit trail shows every movement that produced that figure, with who, what, where, when and why for each one. The report tells you the position; the trail lets you prove it, rebuild it for any earlier date and find the exact moment a figure changed. You need both, but only the trail settles disputes.

Can I see stock movement history in the Fulfil with Synergy portal?

Yes. Fulfil with Synergy clients use a 24/7 client portal that gives a live view of the RedPrairie Dispatcher WMS, including inventory, stock movements and allocations, as well as inbound, order, returns and tracking data. If you need movement data in a particular format, the team can build custom reports or send data to your own systems by API, SFTP or flat file, so your finance and operations teams can work from the same record.

Does an audit trail stop stock going missing?

No system prevents every loss, but a time-stamped trail changes what happens next. Instead of a figure that has simply dropped, you get the specific movements, locations, users and time window involved, which narrows any investigation to a handful of events. It also discourages poor practice, because every adjustment and status change is tied to a named user and a reason. Prevention still depends on scan discipline, controlled locations and people who review the data.

How far back should a 3PL keep stock movement records?

Long enough to support your own records, and at minimum across the full life of your contract. For UK limited companies, GOV.UK guidance says accounting records, which include year-end stock and the counts behind it, should generally be kept for six years from the end of the financial year they relate to. Ask your 3PL how long movement history is retained and how you can export it, and confirm your own obligations with your accountant.

Who at a 3PL should be allowed to adjust stock?

Only trained, named users with the right permission level, and never without a reason code. Every adjustment should carry the user, time, location, quantity before and after, and the reason, so it can be reviewed later. Bulk overwrites by supervisors with no line-by-line record are a warning sign. Ask your 3PL who holds adjustment rights, how those rights are controlled, and whether adjustments are reported to you as they happen or only in a monthly summary, because that tells you how quickly you will hear about a problem.

A stock audit trail gives you the history behind every figure your 3PL reports: who moved each unit, what it was, where it went, when and why. With that record, short-shipped orders, unexplained drops and system mismatches become questions with answers. Fulfil with Synergy runs RedPrairie Dispatcher WMS with a full time-stamped stock movement audit trail down to unit, SKU, batch and location, a reconciled opening position from onboarding, and a 24/7 portal that puts that data in your hands.

‍

If you want to know exactly where your stock is and how it got there, talk to the Fulfil with Synergy team about full visibility of your stock.

‍