Inventory Accounting for Mid-Market Manufacturers

The Three Inventory Buckets

Each fails a different way. Fixing one doesn't fix the others.

Raw materials — the receiving-window problem

Raw material accuracy is a data-entry and cutoff problem, not an accounting problem. The failures we see most often at $10M–$50M manufacturers:

• The receiving dock records to when the paperwork was entered, not when the material arrived. A shipment received at 4:30pm Friday but entered Monday morning shows up in the wrong month if the cutoff falls in between. Multiply that by 40 vendors and you have a $200K–$600K month-end variance appearing and disappearing at random.
• Vendor packing slips don't match the PO. Someone accepts the short-ship, receives the physical quantity, and never opens a variance case. The PO stays open at the full quantity, the AP invoice hits at the full quantity, and the price/quantity mismatch surfaces during the three-way match — sometimes weeks later.
• Returns to vendor aren't reversed cleanly. The material leaves the building but the inventory system still shows it, and the AP credit lags by a cycle.

These aren't accounting problems. They're operational-process problems that surface as accounting variances. The fix is at the receiving dock — a hard cutoff time, a paper-shipment-log that doesn't leave the dock until entered, a policy on short-shipments — not in the general ledger.

Work-in-process — the reason your close takes three weeks

WIP is where most mid-market manufacturers actually lose control. Raw material is easy to count (it's on a shelf). Finished goods is easy to count (it's boxed). WIP is spread across the floor in bins, on machines, in the paint booth, staged for the next operation — and the value at any given moment is a snapshot of a process that never stops.

Most $10M–$50M shops we see do WIP one of three ways, and each has failure modes:

• Standard cost × operation count. Every job routed through operations 1–7, and WIP value = jobs currently at each operation × the cumulative standard cost through that operation. Fails when standards are stale (see the standard vs actual cost piece) or when jobs pause and don't get updated in the routing system.
• Percentage-of-completion by job. Estimator marks each job 25/50/75/100% complete. Fails when the estimate is stale and 90% complete jobs sit at 90% for weeks while material and labor keep hitting them.
• Bulk WIP adjustment at month-end. The Controller pulls a WIP report, adjusts to physical inventory found on the floor, and books the difference to variance. Fails when the "variance" line becomes a plug that hides real cost problems.

None of the three is wrong for every business. But whichever you use, the tell that WIP is broken is: the Controller can't tell you the WIP value at 2pm on Wednesday without waiting until Friday. If WIP has to be "closed" to be known, it's not being managed — it's being reconstructed.

Finished goods — the sub-ledger reconciliation gap

Finished goods failures usually look like this: the inventory sub-ledger (what your ERP or warehouse system says you have) doesn't match the general ledger (what accounting has booked). The gap accumulates quietly. At month-end someone runs the reconciliation, finds an $80K difference, and either researches it (rare) or writes it off to shrinkage (common).

The four most common root causes:

• Costed shipments to customers that didn't book to COGS in the same period (cutoff on the shipping side).
• Standard cost changes applied to on-hand inventory without a corresponding GL revaluation.
• Manual journal entries to inventory that didn't hit the sub-ledger.
• Returns from customers received into inventory at the original standard cost when standard has changed since.

Every one of these is fixable, but each one requires a specific process discipline. Shrinking the gap to under $10K per month is realistic for a $30M manufacturer running competent operations. Shrinking it to zero isn't the goal — narrowing it to a range you understand is.