Case studies → Manufacturing → WIP reconciliation Use case 01 · Manufacturing finance · Process 1.2
Reconcile WIP. Chase it in week one. After settlement, a robot matches every order against its job cost sheet, sorts it into one of four buckets and tells each planner what is still open.
Cleared & matching Variance differs WIP still open Settlement error
WIP reconciliation · at a glance
Current process estimates ~1 day
to reconcile by hand, more if settlement had errors
<2h
reconciliation time, including review
Estimated 4 buckets
every closed order gets a clear next action
Week 1
open WIP chased, instead of week 3
Estimated
How it was done
Exports, VLOOKUPs and mails, one order at a time.
Settlement run KO88 / CO88
→ Export WIP report
→ Export settlement log
→ VLOOKUP against cost sheet summary
→ Mail planners about open WIP
About a full day One person spent a day on it every month, so orders still carrying WIP were usually chased in the third week of the month.
How it works now
One signal from finance. Every order in the right bucket. The robot waits for finance, reads the settlement results, matches them to process 1.1’s cost sheets and routes every order.
KO88 / CO88 settlement → Finance drops trigger file → Robot starts matching → Workbook + planner mails
SAP · WIP & settlement log ₹
Order WIP balance Settled variance ORD-48201 0 12,400 ORD-48213 0 30,500 ORD-48224 1,85,000 — ORD-48230 0 31,200 ORD-48241 — No settlement rule ORD-48257 0 8,750 ORD-48262 64,300 —
✓ Match
≠ Differs
◷ WIP open
✓ Match
✕ Error
✓ Match
◷ WIP open
Process 1.1 · Job cost summary ₹
Order Calculated variance ORD-48201 12,400 ORD-48213 28,900 ORD-48224 9,200 ORD-48230 31,200 ORD-48241 4,100 ORD-48257 8,750 ORD-48262 2,300
Every order lands in one bucket, with an owner
Cleared & matching
Nothing to do. Counted in the summary tab.
● Summary tab
Variance differs
Gap above ₹1,000 listed, not explained.
● Costing lead
WIP still open
Grouped mail: orders and open amount.
● Production planner
Settlement error
e.g. missing settlement rule. Listed, no retry.
● Finance
Planner mail drafts → Costing lead approves → Sent (first two months)
Sample data
Where the robot stops
Automation handles the work. People own the decisions.Variance gaps above ₹1,000 are listed for a person, never explained by the robot. Settlement errors go to finance, with no retries. Planner mails are grouped by planner, not one mail per order. For the first two months, mails go out only after the costing lead says OK.
Why it works
Open WIP chased while the job is still fresh. Starts on a signal from finance, never on a guess Every order lands in exactly one bucket Builds on the cost sheets from process 1.1
Your reconciliation business case
How long does open WIP sit before it’s chased? See the hours you’d get back after settlement, and how much open WIP gets followed up two weeks sooner. Share your workflow for a detailed estimate.
Example from this case a full day of matching → under 2 hours , open WIP chased in week 1, not week 3
See what faster reconciliation is worth For a detailed estimate, we’ll ask
Orders settled per month Hours spent reconciling Planners you chase Typical open WIP value
Less month-end chasing. Faster follow-through. Move from VLOOKUPs to a workbook that already says who needs to act on what.
Book a 20-min walkthrough
Indicative benefits based on the client's current process estimates. Final savings and automation feasibility depend on SAP access, settlement data consistency, master data quality and pilot validation. Client details withheld.