Inventory was moving.
The accounting wasn't keeping up.
One company. Several pools of inventory.
The business supported contractors, property managers, and smaller commercial clients with replacement parts, installation materials, specialty supplies, and service work.
Sales were growing, but inventory tracking still depended heavily on spreadsheets, manual counts, and adjustments made after problems had already appeared in the financial statements.
Warehouse, van, job and special-order inventory were not reviewed through one consistent monthly reconciliation.
Job margins could change after invoicing when parts, returns, freight or previously unassigned material were identified.
Month-end inventory adjustments were being recorded without enough detail to explain the operational reason behind the correction.
Before analyzing variance, the item records had to make sense.
Duplicate part numbers, inconsistent units of measure, miscellaneous items, and unclear locations can make a technically complete inventory system unreliable.
The cleanup separated resale inventory, job material, consumables and service-van stock while creating clearer categories for returns, damage, shrinkage and job usage.
| Item | Description | Location | System Qty | Count Qty | Unit Cost | Extended Variance | Review |
|---|---|---|---|---|---|---|---|
| P-1044 | Commercial Valve Assembly | Warehouse A | 42 | 42 | $118.40 | $0.00 | MATCH |
| F-2210 | Flexible Supply Line | Warehouse B | 185 | 179 | $14.80 | ($88.80) | COUNT |
| V-0842 | Replacement Motor | Van 03 | 6 | 4 | $286.20 | ($572.40) | REVIEW |
| S-4198 | Special Order Control Kit | Job Hold | 3 | 3 | $492.00 | $0.00 | JOB? |
| C-1190 | Installation Consumable Pack | Van 06 | 24 | 17 | $31.60 | ($221.20) | USAGE |
Service-van inventory became part of the close.
Inventory carried by technicians is easy to overlook because the material physically leaves the warehouse before it necessarily appears on a customer invoice.
A recurring count sheet created a documented link between expected stock, physical counts and material assigned to jobs.
Van Stock Count
Vehicle 03 / Month-End ReviewThe adjustment became the beginning of the question — not the end of it.
The monthly review separated timing issues from actual cost problems and concentrated attention on the largest drivers.
Positive variance amounts below are treated as unfavorable; negative amounts are favorable.
Every month needed an explanation from beginning inventory to ending inventory.
A simple roll-forward gave ownership and accounting one schedule for evaluating purchases, transfers, job usage and adjustments.
Instead of asking only whether ending inventory looked reasonable, the review explained how the balance changed.
The report was built to direct attention, not create more paperwork.
Leadership did not need to review every inventory transaction. The monthly package summarized the control status, largest variances and specific items requiring follow-up.
Inventory Control Review
The control process was introduced in stages.
The purpose was to improve inventory reporting without disrupting normal purchasing, service or warehouse operations.
Reviewed the chart of accounts, item list, inventory categories, vendor records and recent inventory adjustments.
Cleaned duplicate items, standardized material categories and built a monthly reconciliation schedule.
Added monitoring for parts usage, vendor pricing, freight, returns and inventory adjustments.
Added management notes, action items and a recurring inventory discussion within the monthly close schedule.
The inventory balance became something the business could explain.
If inventory changes every month but no one can clearly explain why, the problem may be the process around it.
Eight Leaf Financial Services helps growing businesses organize inventory accounting, job-cost activity, reconciliations and monthly management reporting without adding unnecessary complexity.
Discuss your inventory process →