The Reconciliation Framework
Reconciliation happens at the package and category level, not just in total. Opening quantity plus receipts and production, less sales, transfers, samples, waste and adjustments, must equal closing quantity in both systems.
- Package-level quantity tie-out between tracking system and ledger
- Sales and dispensing volume agreement with point of sale
- Transfer and manifest verification
- Waste, destruction and sampling documentation
Variance Investigation
Every variance gets a cause code: data entry timing, unrecorded transfer, weight tolerance, packaging conversion, or genuine loss. Cause coding turns a monthly annoyance into a management report that identifies which sites, shifts or processes need attention.
Process Design and Training
Most tracking discrepancies are workflow problems rather than accounting problems. We document who enters what, when, and what secondary review looks like, then train the team on the sequence.
Audit and Inspection Readiness
Regulatory inspections and tax examinations both start with inventory. A current, documented reconciliation is the single best preparation for either.
Frequently Asked Questions
- How often should tracking data be reconciled to the books?
- Sales and dispensing data daily, full inventory reconciliation at least monthly, with cycle counts in between. Quarterly reconciliation is generally too infrequent to isolate causes.
- What tolerance is acceptable for weight variances?
- Set a written tolerance policy appropriate to your product forms and scales, investigate anything outside it, and document the outcome. Undocumented adjustments are the real risk.
- Can you work with our existing compliance team?
- Yes. Reconciliation works best as a joint process between compliance and accounting, with clearly assigned ownership for each step.