Case Study / Inventory Controls & Monthly Variance Review

Inventory cleanup and monthly cost monitoring for a growing trade supply business.

A Roanoke-area contractor supply and service business needed a better way to track parts, job materials, warehouse inventory, and monthly cost movement. The company was profitable, but inventory records were inconsistent, job margins were hard to explain, and leadership lacked a clean monthly review process.

Request a Consultation View More Case Studies

Inventory Controls Contractor Accounting Job Costing Variance Reporting Monthly Close

Business Situation

The business supported local contractors, property managers, and small commercial clients. It carried replacement parts, installation materials, specialty supplies, and service-van stock. Sales were growing, but the back office still relied heavily on spreadsheets, manual counts, and after-the-fact inventory adjustments.

Inventory Was Split Across Too Many Places

Warehouse stock, service-van materials, special-order items, and job materials were not being reviewed through one consistent monthly process.

Job Margins Were Difficult to Explain

Some jobs looked profitable when invoiced, but later adjustments for parts, returns, freight, and unbilled materials reduced the actual margin.

Month-End Adjustments Were Too Reactive

Inventory corrections were often made at the end of the month without a clear explanation of whether the issue was purchasing, usage, pricing, shrinkage, or timing.

Eight Leaf Approach

The goal was not to build an enterprise-level system. The goal was to create a practical, repeatable inventory and variance review process that a small/midsize business could maintain every month.

Inventory Setup

Separated resale inventory, job materials, consumables, and service-van stock.
Reviewed item naming, units of measure, and duplicate part numbers.
Created inventory adjustment categories for shrinkage, damaged goods, returns, and job usage.
Built a simple monthly inventory roll-forward.
Added review steps for special orders and unbilled job materials.

Monthly Monitoring

Compared beginning inventory, purchases, transfers, usage, adjustments, and ending inventory.
Reviewed job material usage against invoiced revenue.
Monitored vendor price changes and freight impact.
Flagged slow-moving and obsolete parts.
Prepared a monthly variance summary for ownership review.

Monthly Variance Check-In

Each month, the review separated timing issues from true cost problems. Positive variance amounts were treated as unfavorable. Negative variance amounts were treated as favorable.

Variance Area	Monthly Amount	Status	Finding	Action Taken
Parts Usage	+$7,860	Unfavorable	Materials pulled for jobs were not consistently assigned before billing.	Added job material review before invoice finalization.
Vendor Price Changes	+$3,420	Unfavorable	High-turnover items increased in cost before sales prices were updated.	Created monthly price review for top 25 items.
Freight & Delivery	+$1,950	Unfavorable	Freight was absorbed on several special-order purchases.	Added freight recovery review for special orders.
Returns & Credits	-$2,740	Favorable	Vendor credits cleared older open returns.	Matched credits to original purchase records.
Inventory Adjustments	+$4,180	Unfavorable	Service-van counts showed missing or unassigned parts.	Implemented monthly van stock count sheets.
Net Monthly Variance	+$14,670	Unfavorable	Primary drivers were job material timing, vendor price changes, and van stock control.	Reviewed with ownership during monthly close meeting.

Certain operational metrics and financial values have been modified to preserve client confidentiality while maintaining the integrity of the workflow and reporting structure.

Reporting Package

The finished monthly package was designed for business owners, not accountants only. It gave leadership a clear view of where inventory dollars were moving and which issues required follow-up.

Inventory Accuracy 91%

Unbilled Materials $18.6K

Slow-Moving Stock $42.3K

Close Timeline 6 Days

Inventory Roll-Forward

Beginning inventory, purchases, transfers, usage, adjustments, and ending inventory were reviewed in one monthly schedule.

Top Variance Drivers

The report highlighted the largest unfavorable movements so ownership could focus on material issues instead of reviewing every transaction.

Action List

Each monthly review ended with practical follow-up items: pricing updates, count issues, vendor credits, purchase cutoffs, or job billing corrections.

Implementation Timeline

The project was structured in phases so the business could improve controls without disrupting normal operations.

Phase 1

Reviewed the existing chart of accounts, item list, inventory categories, vendor records, and recent inventory adjustments.

Phase 2

Cleaned up duplicate items, standardized material categories, and built a monthly inventory reconciliation schedule.

Phase 3

Introduced monthly variance reporting for parts usage, vendor pricing, freight, returns, and inventory adjustments.

Phase 4

Added owner-facing review notes, action items, and a recurring monthly check-in process tied to the close schedule.

Results

The business gained a practical inventory control process and a clearer understanding of how inventory movement affected monthly profitability.

74% → 91% Inventory accuracy improved after monthly count and adjustment procedures were standardized.

11 → 6 Days Month-end close became faster because inventory issues were reviewed earlier in the process.

$31K Older vendor credits, duplicate items, and unassigned job materials were identified for correction.

Top 25 High-turnover items were placed on a monthly pricing and margin review list.

Monthly Ownership received a recurring variance report instead of waiting for year-end cleanup.

Cleaner Job costing improved through better material assignment and invoice review procedures.

Need better control over inventory and job costs?

Eight Leaf Financial Services helps growing businesses strengthen bookkeeping, inventory controls, monthly reporting, and operational cost visibility without adding unnecessary complexity.

Schedule a Financial Review