Matching Depot Records to Head Office
Depot stock reconciliation explains, line by line, why the stock a depot says it holds differs from the stock head office's books say it should hold. The depot records receipts, dispatches and damage as they happen on its floor; head office records the same movements from documents that reach it later. The reconciliation sorts each difference into timing (it will clear on its own), an error in one record (it needs a correction) or a real loss (it needs an explanation), and reports what is left.
In consumer goods this matters more than it sounds. A company may run many depots and carrying and forwarding agents, stock moves between them daily, and each depot's figure feeds the company's closing stock, its sales cut-off and, for a borrower, the stock statement it gives the bank. The general method is the one used for any match of physical stock with the books: fix a cut-off, compare the count with the record, take out each difference a document explains, and report what is left as its own figure. A depot adds a second record to the match, head office's, and the sections below show what that changes.
Where Depot and Head Office Records Part Ways
Almost every difference falls into one of six places. Knowing them turns a single unexplained total into a list that can be worked through.
Timing
Dispatched by the plant, not yet receivedHead office records the dispatch when the plant raises the invoice or challan; the depot records the receipt when the truck is unloaded and booked in. Everything on the road sits in the gap.
Returns
Accepted at the depot, not yet advisedTrade returns, expired stock and damaged packs taken back from distributors and retailers are received at the depot days or weeks before head office processes the credit.
Local write-offs
Corrected at the depot, never escalatedA manager who finds a short case or writes off a damaged batch may correct the depot record and stop there. The depot is then right and head office is not.
Inter-depot transfers
Recorded at one end onlyA transfer booked out by the sending depot and not yet booked in by the receiver, or the reverse, is the single most common line on these reconciliations.
Free and promotional stock
Moving outside the sales flowFree goods for schemes, samples and display material often move on separate documents, or none, and are valued differently from saleable stock.
Units and packs
Cases at head office, pieces at the depotA pack size changed in one system but not the other, or a case-to-piece conversion entered wrongly, produces a difference that looks like quantity and is arithmetic.
Building the Reconciliation, Step by Step
- Fix the cut-off. Pick a date and time, and take head office's book quantity for the depot, by product and batch, at that moment.
- Take the depot's own record at the same cut-off, and the physical count. Compare the depot record with the count first: differences there are the depot's own, before head office comes into it.
- List the timing items. Dispatches to the depot not received by the cut-off, and dispatches from the depot not yet recorded at head office, each with its document number and date.
- List the returns and local adjustments not yet processed at head office, each with the return note or the write-off approval behind it.
- Match the transfers with every other depot: out at one end, in at the other, quantity and batch.
- Correct the unit and pack errors. Convert both records to the same unit before deciding anything is missing.
- Report the residue. Whatever is left after every documented item is removed is reported as its own figure, by product, and not absorbed into the timing lines.
Each reconciling item and the document behind it
A line with no document is part of the residue.
Reconciling item
- Goods in transit to or from the depot
- Trade and expiry returns received
- Damage and shortage written off locally
- Transfers between depots
- Free and scheme stock issued
- Unit and pack differences
Evidence that supports it
- Dispatch document, transporter's receipt and the later receiving entry
- Return note from the distributor and the depot's receipt
- Write-off approval within the manager's authority
- Confirmation from both depots, same quantity and batch
- Scheme approval and the issue record
- The product master in both systems
Goods in Transit: Reconciling Item or Hiding Place
Stock dispatched before the cut-off and received after it belongs to neither depot's count and is the ordinary reconciling item. It is also the easiest place to park a difference, so it gets more attention than its size suggests.
- Every transit line names a document. A dispatch note and a transporter's receipt for a specific consignment, not a balancing figure.
Specific - Every transit line clears. Check the receipts after the cut-off: the consignment should arrive within the normal journey time for that route.
Cleared later - Age the balance. Transit that is still open at the next cut-off, or a transit total that is about the same at every period end, is not goods on a truck. It is a difference somebody has parked.
Ageing
The rule for deciding which side of the cut-off a movement falls on is explained under cut-off procedure and goods in transit.
Local Adjustments and Who Approved Them
Depots have to write off damaged cases and small shortages locally; escalating each one would stop the operation. The control question is whether anyone outside the depot sees the adjustments, and whether they stay inside the authority given.
- Within the limit. Each write-off is checked against the manager's stated authority, and so is the pattern: a large loss split into several entries just under the limit is visible in the data and invisible in any single entry.
Authority - Against the other depots. A depot that writes off far more than its peers, as a share of throughput, needs a reason.
Comparison - Round numbers and timing. Write-offs in round quantities, or bunched in the days before a count, describe something other than handling damage.
Pattern - Reported to head office. Every local adjustment reaches head office within the month, with its approval, so the books and the depot move together.
Escalation
Returns need the same discipline. Returns that are saleable go back into stock; the rest are held apart for destruction or a claim, and both groups are counted separately from fresh stock.
Running It Across a Depot Network
- One cut-off everywhere. Counts at different depots on different days can each be correct and still add up to a position that never existed, and stock moving between two depots can be counted twice or not at all.
Common date - Both ends at once. Where depots exchange stock, count them together or freeze transfers between them for the window; a transfer usually takes a day or more anyway.
Paired counts - Reconcile monthly. A monthly reconciliation keeps each difference small and recent enough to trace. A yearly one on stock that moves every day leaves a residue nobody can explain.
Frequency - Treat a repeated residue as a finding. A residue at the same depot in month after month is a control weakness, however small each one is.
Follow-up
Depot transfers also carry GST documents, and matching the stock to what the returns report is a separate exercise, covered in how to match physical inventory with GSTR-1 and GSTR-3B. Where depot differences keep returning despite reconciliation, the patterns that point to deliberate loss are described in the forensic stock audit guide.
A depot that counts itself tends to find what it expects; the gap between an internal and an independent count at the same site is often the finding. A stock audit for FMCG companies can count a whole depot network to one cut-off and reconcile each depot to the head office books.
