# WIP Inventory Valuation Worksheet > Source: https://netray.co/tools/wip-inventory-valuation-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Value work in process at period end by job, using quantity, standard material and conversion cost, and percent complete for each. ## Category cost-finance ## Industry Discrete Manufacturing ## Audience - Controller - Cost accountant - Plant accountant - Auditor ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Job or work order **Key:** job **Type:** text #### Part **Key:** part **Type:** text #### Qty in WIP **Key:** qty **Type:** number #### Std material per unit **Key:** mat_std **Type:** number **Format:** currency #### Std conversion per unit **Key:** conv_std **Type:** number **Format:** currency **Help:** Labor plus applied overhead. #### Material % issued **Key:** mat_pct **Type:** number **Unit:** % #### Conversion % complete **Key:** conv_pct **Type:** number **Unit:** % #### Material value **Key:** mat_val **Type:** number **Expr:** qty * mat_std * mat_pct / 100 **Format:** currency #### Conversion value **Key:** conv_val **Type:** number **Expr:** qty * conv_std * conv_pct / 100 **Format:** currency #### WIP value **Key:** wip_val **Type:** number **Expr:** mat_val + conv_val **Format:** currency **Rows:** **Job:** WO-10231 **Part:** Hydraulic manifold **Qty:** 120 **Mat std:** 64 **Conv std:** 38 **Mat pct:** 100 **Conv pct:** 40 **Job:** WO-10238 **Part:** Gearbox housing **Qty:** 80 **Mat std:** 92.5 **Conv std:** 55 **Mat pct:** 100 **Conv pct:** 65 **Job:** WO-10244 **Part:** Shaft assembly **Qty:** 300 **Mat std:** 18.2 **Conv std:** 14.5 **Mat pct:** 80 **Conv pct:** 25 **Job:** WO-10252 **Part:** Control panel **Qty:** 25 **Mat std:** 410 **Conv std:** 165 **Mat pct:** 60 **Conv pct:** 30 **Job:** WO-10260 **Part:** Bracket kit **Qty:** 1500 **Mat std:** 3.4 **Conv std:** 2.1 **Mat pct:** 100 **Conv pct:** 90 **Totals:** #### Total material in WIP **Key:** mat_val **Agg:** sum **Format:** currency #### Total conversion in WIP **Key:** conv_val **Agg:** sum **Format:** currency #### Total WIP value **Key:** wip_val **Agg:** sum **Format:** currency **Summary:** #### Conversion share of WIP **Key:** conv_share **Expr:** if(gt(sum_wip_val,0), sum_conv_val / sum_wip_val * 100, 0) **Format:** percent #### Average WIP value per job **Key:** avg_job **Expr:** if(gt(count,0), sum_wip_val / count, 0) **Format:** currency **Primary:** true #### Largest job in WIP **Key:** largest **Expr:** max_wip_val **Format:** currency **Notes:** Material is usually issued at the start of the operation, so material percent is often 100 even when little conversion has occurred. Percent complete should come from routing progress or reported operations, not guesswork. Reconcile the total to the WIP general ledger account. ## Content **Intro:** Work in process is the inventory balance that is hardest to defend at audit. This worksheet values open jobs using a standard cost split between material and conversion, with a separate percent complete for each, so the logic is visible and reconcilable. **Sections:** #### How to use the worksheet **Body:** List every open job at period end with its quantity in process. Enter standard material cost per unit and standard conversion cost per unit, which is labor plus applied overhead from the routing. Then enter how much material has been issued and how far conversion has progressed, each as a percentage. The sheet computes material, conversion and total WIP value per job and in total. Compare the total with the WIP account in the general ledger and investigate the difference. **Bullets:** - Include all released and in-progress work orders, not just those with recent activity - Take percent complete from the last reported operation on the routing - Remove jobs that are physically complete but not yet closed - Flag jobs open far beyond normal lead time #### The method behind it **Body:** This follows the equivalent units idea from process and job costing: material and conversion are tracked separately because they enter at different points. WIP value = quantity x standard material x material percent + quantity x standard conversion x conversion percent. If material is added at the start, use 100 percent for material from the first operation. Actual-cost systems accumulate real issues and labor on the job instead, and WIP is the accumulated balance rather than an estimate. #### Reading the result **Body:** A high conversion share suggests many jobs are far along, so a lot of labor and overhead is capitalized. If that share is high and the jobs are old, you may be carrying costs that will not be recovered. Compare worksheet WIP to the ledger: a worksheet higher than the ledger can mean unposted labor, a lower one often means stale jobs, scrap not written off or issues without a work order. Sorting by value shows where review time matters most. #### Common mistakes and ERP notes **Body:** Counting completed units as WIP, forgetting scrap and rework cost, and applying overhead at a rate that has not been refreshed. Estimating percent complete from elapsed time rather than routing steps is another common error. In SAP the production order WIP is calculated in the settlement run (CO88 for WIP calculation, as an example), in Oracle EBS the WIP accounting class drives the accounts, and in SyteLine, Epicor and NetSuite the job or work order accumulates costs until close. Reconcile each month before the books close. **Cta:** A monthly WIP report that ties out to the ledger without manual cleanup is achievable from ERP data. We can outline the approach for your system. Ask for an expert review. **Faq:** #### Why track material and conversion separately? **Answer:** Because they enter production at different times. Material is often issued up front while labor and overhead accrue gradually. Treating them together overstates or understates WIP when jobs are early or late in routing. #### How do I estimate percent complete? **Answer:** Use the share of routing standard hours or operations completed, weighted by cost if possible. Avoid estimating from the calendar. Reported shop floor transactions are the best evidence. #### What if WIP does not match the general ledger? **Answer:** List possible causes: unposted labor, material issued to the wrong order, completed orders still open, scrap not recorded, and variances not yet settled. Investigate the largest jobs first. #### Should abnormal scrap be in WIP? **Answer:** Abnormal scrap and idle capacity are generally expensed when incurred, not capitalized into inventory. Normal scrap is part of the cost of production. Check your accounting policy and auditor expectations. ## Search terms WIP valuation worksheet, work in process inventory calculation, WIP inventory excel template, work in progress valuation manufacturing, percent complete WIP inventory, month end WIP report, equivalent units WIP --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json