A count adjustment records what changed in the system. An investigation log explains why the adjustment was supported. The difference matters when a manager, finance reviewer, or future team member needs to reconstruct the decision.
Start each row with a stable reference: item code, location, count date, system snapshot quantity, physical count, unit of measure, quantity variance, unit cost, and extended value. Store the underlying count sheet and transaction report references instead of replacing them with a narrative summary.
Give the discrepancy a status. Useful stages are New, Recount Required, Evidence Under Review, Explained, Unexplained, and Approved for Adjustment. Status names should describe where the work stands, not whether a person is at fault.
Investigate in a consistent order. First verify the counted item and unit conversion. Next check the timing cutoff and movements that happened around it. Then review purchase receipts, customer returns, location transfers, sales, and production or consumption records. Reconcile each supported quantity against the original variance.
Example: Item X is short eight pieces. A transfer document shows six pieces shipped out before the count but posted afterward. A documented damage disposal accounts for the remaining two. Record both references and timestamps. If the evidence aligns, explain the full eight-piece variance without guessing.
Do not label a difference Explained simply because a possible reason sounds plausible. Attach document numbers or other verifiable evidence. If only six of eight pieces are supported, keep the remaining two as unresolved and document any further recount or adjustment decision separately.
Add a reviewer, review date, corrective action, and repeat-issue indicator. If a product is consistently miscounted because two similar labels sit side by side, the long-term fix may be signage or bin separation rather than repeated financial adjustments.
A concise monthly dashboard can report total shortages, total overages, net adjustment, largest material exceptions, and investigation status. Present shortage and overage values separately before netting them; offsetting totals can hide major process issues.
Good investigations are traceable. They show exactly what was counted, what the system showed, which evidence was checked, and who approved the final outcome.