At month end, the balance on the manufacturing inventory account should be explainable from the costs still in production. The work in process inventory formula is ending WIP = beginning WIP + manufacturing costs added - cost of goods manufactured, before any other movements affecting the WIP account. Cost of goods manufactured (COGM) is the cost transferred out for completed production during the period.
Use the formula to build a rollforward (a bridge from the prior closing balance to the current one). Then compare it with independently valued unfinished production and the general ledger. If you calculated COGM from the same ending WIP you are testing, rearranging that calculation will return the number you started with.
Pull each input at the same cutoff
Beginning WIP comes from the prior period’s accepted ending balance. Match plant, accounts, currency, and costing basis before using it. If a prior period was reopened, document which version feeds this month’s rollforward so the reviewer can distinguish a changed opening from a current-period movement.
Manufacturing costs added are direct materials charged to production, direct labor, and manufacturing overhead charged under the plant’s costing policy. Rice University’s OpenStax shows how those costs enter WIP in its job-order costing chapter. Use the posted costs within the period. An invoice for raw materials can increase raw inventory without adding the same amount to WIP. The total manufacturing cost formula covers building up those current-period inputs.
Cost of goods manufactured comes from the cost assigned to completed production transferred out of WIP. Use a transfer or completion valuation report that stands on its own if you want an independent check. Include partial completions that carry costs out, even when their orders remain open. Keep reversals linked to the original postings so the net amount reflects the transactions in the period.
Reconcile the formula to the ledger and order detail
Assume one plant reports in dollars and uses job-order costing. All amounts below are hypothetical, and the example starts with no separate write-offs, revaluations, or other WIP entries. The completed-goods amount comes from posted transfers, including a partial completion on an open order.
| Rollforward line | Amount | Evidence |
|---|---|---|
| Beginning WIP | $42,000 | Prior accepted closing balance |
| Direct materials added | +$75,000 | Posted production issues, net of returns |
| Direct labor added | +$28,000 | Labor postings charged to production |
| Manufacturing overhead added | +$19,000 | Applied overhead postings |
| Completed-goods transfers | -$132,000 | Valued completion and transfer postings |
| Expected ending WIP | $32,000 | Rollforward result |
Current production costs total $122,000. Add $42,000 and subtract $132,000 to reach $32,000. Assume the WIP ledger account also shows $32,000, but the order-detail extract shows $35,600. The account tie confirms the movement bridge under the stated assumptions. The extra $3,600 in order detail still needs an explanation.
In this example, the order extract retained the gross cost on one partially completed order and omitted a $3,600 transfer already in the ledger. Match the transfer’s order and posting ID, then subtract it once in the detail. The residual order costs tie to $32,000 after the correction to the extract. Keep that extract and transfer together so the reviewer can reproduce the tie.
Separate timing, valuation, and real adjustments
Start with posting dates and period assignment when the detail and account do not tie. An order can finish before the month closes while the completion posts in the next period. Record both times and ask the close owner to apply the approved cutoff rule. For the physical count at a shop-floor cutoff, use work in process inventory by operation.
Then check whether both reports use the approved costing basis. An order summary with estimated overhead and a ledger with applied overhead will differ by construction. Compare the cost elements on the affected order, and preserve the method behind each amount before asking the costing owner to reconcile the difference.
Show approved write-offs, revaluations, and other WIP postings as separate signed lines when they apply. A journal entry can move the account without corresponding to a finished unit. Keep its reference and explanation in the bridge, then investigate any remaining unexplained amount. A negative job balance also warrants transaction review because a missing issue, return, or completion reversal could change the balance.
Compare open orders with positive residual costs to completed or canceled orders that still carry a balance. Start with orders whose quantities have cleared all operations but whose value remains. They need a transaction and policy review because status alone cannot explain a late labor charge, unused material returned to stores, or an approved residual that has not posted.
Keep the source breakdown for every remaining cost. A matching plant total can hide a labor posting charged to the wrong order when two errors offset. Match the order-level amounts and group any remaining gap by cost element. Save both the reconciliation and the underlying extracts used to make it, including the timestamps and report parameters.
The production-to-inventory bridge ends when completed costs leave WIP. A later sale moves costs through finished goods into cost of goods sold. Keep the finished-goods account outside this reconciliation so a shipment posting cannot mask an unmatched production transfer.
Inspect your production cost inputs
Start with a supported source and check whether order, cost element, and posting period travel with each amount.
Where Permute fits in the WIP close
Permute is the context layer we sell between business data and the AI tools people already use. We can bring together eligible NetSuite postings and an approved Excel job-cost export, matching records by plant, order, and transaction ID where available.
We apply the cutoff and costing rules your team supplies to a repeatable reconciliation, keeping the ledger and order sources visible. Separate account adjustments remain identifiable as the balance changes.
A plant controller can ask which orders explain the difference between detail and ledger, then inspect the matching transfers and report versions within their permissions.
Keep costing policy and postings with accounting
The accounting owner sets the costing and cutoff policy and approves adjustments. We read connected records for this review, while posting corrections stays with the system of record and its approval process. An unvalued transfer remains an open item until the owner supplies usable evidence.
Carry the reconciled balance into next month
Build ending WIP from the accepted opening balance, posted production costs, and the value transferred out of production. Tie the result to both the ledger and cost detail at the same cutoff. In the example, the $3,600 partial transfer explains the difference once the order extract includes it. Save the reconciled basis so next month opens with the same balance.
Review a WIP close with Permute
Bring the ledger balance, the order valuation report, and one completion that is difficult to trace between them.
Questions about reconciling ending WIP
Can I use the formula before all completion costs are posted?
Use it for a provisional review if you label the missing postings and the extraction cutoff. Final reconciliation needs the accepted completion values or approved adjustments under your close policy.
Does a shipment reduce WIP?
The standard inventory flow moves completed production out of WIP at completion. A later sale affects finished goods and cost of goods sold, so using shipment cost in the WIP formula mixes two different movements.