How do I prepare my 3PL’s inventory discrepancy log for a buyer’s review?
Gather every count difference into one log showing the date, item group, size of the gap, the cause found and the fix. Add totals and a trend across several periods, with customer names removed. A tidy log with honest causes shows a buyer that problems are found and closed.
Collect the sources: cycle count sheets, adjustment entries in the warehouse system and any notes from customers about missing or surplus goods. Put them into a single table. For each entry, record what was found, what caused it and what changed so it would not repeat. Where the cause is unknown, say so rather than invent one.
Then summarize. Show total differences by cause, such as receiving errors, picking errors, damage and system faults, and show how each has moved over time. A falling trend backed by process changes is persuasive. A flat or rising one needs an explanation and a plan, and it is better that you offer it first.
Check the log against the books. Your accountant should be able to tie any claims or credits paid to customers for missing goods to what appears in the financial statements. Prepare totals with client names and details removed, and ask your lawyer about a confidentiality agreement before you share anything. Keep the original records on file. Include a short note on your count routine: what is counted, how often and by whom. A buyer will want to know the log reflects regular checking, not occasional discovery. If the routine has changed, say when and why, since that affects how the trend should be read.
Key takeaways
- Combine count sheets, adjustments and notes into one table.
- Summarize by cause and show the trend across several periods.
- Ask your accountant to tie customer claims to the financial statements.
Related reading
13 pages on the same subject, grouped by topic.
Due diligence
Buying
- Expert answerWhat should I ask about a 3PL’s warehouse management system before taking over?
- Expert answerHow do I check a janitorial distributor’s warehouse inventory for expired stock?
- Expert answerHow do I judge the aging inventory in a refurbished electronics reseller’s warehouse?
- Expert answerWhat should I ask about a co-packer’s customer-owned inventory in its warehouse?
- Expert answerHow do I review an Amazon seller’s inbound shipping plans to the warehouse?
- Expert answerHow do I review a packing service’s inventory of boxes, wrap and tape?
Selling
- Expert answerHow do I prepare my flooring store’s warehouse and stock for a buyer’s walkthrough?
- Expert answerHow do I prepare my packaging company’s warehouse layout and storage map for a buyer?
- Expert answerHow do I prepare my trucking company’s driver files for a buyer’s review?
- Expert answerHow do I tell my 3PL’s clients about a sale without losing their stock contracts?
- Expert answerHow do I get my trading card inventory ready for a buyer to review?
Sources
This answer is checked against primary sources. Links were last confirmed on the dates shown.
- 01Business Development Bank of CanadaGovernmentWhat is inventory
- 02Business Development Bank of CanadaGovernmentHow to conduct due diligence when buying a business
Deavo is an advertising and listings platform, not a brokerage, law firm or valuation firm. This page is general information, not legal, tax, accounting or valuation advice, and rules differ by province. Confirm anything you rely on with a qualified professional before you act on it.