When Accounting Cares About Production Orders
The message came in at 7:40 on a Tuesday, from a controller I've worked with for years: WIP is up again and I can't explain it to the auditors. I've heard some version of that from four different finance teams now, so I'm writing the answer down once.
It was day three of close. Work in process was up $812,000 since the last balance sheet, nothing on the shop floor looked unusual, and the plant manager swore every order that shipped was finished. Both of them were right. The orders were finished. They just weren't ended.
If you run production in Dynamics 365 Supply Chain Management and your WIP account only goes one direction, this post is the explanation. It's almost never a posting setup problem. It's a lifecycle problem, and the fix is mostly discipline plus one reconciliation nobody builds until it bites them.
A production order hits the general ledger four times, and only the last one tells the truth
Finance tends to think of a production order as one event. It isn't. It's a series of postings spread across days or weeks, and three of the four are estimates.
Status | What's happening on the floor | What hits the ledger |
Estimated, Scheduled, Released | Paperwork, planning, materials staged | Nothing |
Started (picking list) | Raw material consumed | Credit raw material inventory, debit WIP |
Started (route card or job card) | Labor and machine hours reported | Debit WIP, credit the absorption accounts off the costing sheet |
Reported as finished | Good quantity put away | Debit finished goods at estimated cost, credit WIP |
Ended | Nothing. This is an accounting event. | Actual cost calculated, estimates reversed, WIP cleared, variances or adjustments posted |
That fifth row is the whole post. Ending the order is the only step that promises WIP goes back to zero for that order. Everything before it is a placeholder.
Whether any of it posts at all depends on Production control > Setup > Production control parameters, on the Ledger tab: post picking list in ledger, post route card in ledger, post report as finished in ledger, and post costing in ledger. Microsoft's overview of how production control integrates with the general ledger is a decent orientation if you want the full map.
Why the balance climbs
In rough order of how often I see it:
Orders are reported as finished and never ended. Production considers an order done when the good quantity is on the rack. Accounting considers it done when it's costed. Nobody owns the gap. This one accounts for most of the balance, most of the time.
Report as finished runs ahead of consumption. If the flushing principle on materials is manual and nobody posted the picking list, finished goods gets debited and WIP gets credited for materials that were never charged to it. WIP can go negative on that order while the total still climbs from others.
Partial completions left open. 1,000 ordered, 940 good, 60 scrapped, nobody reports the scrap or reduces the order. The order stays open and holds the cost of the remainder.
Journals created but never posted. Picking list and route card journals sitting unposted don't hit the ledger, so the physical side and the financial side drift. Check this before you blame the setup.
End date lands in a different period than report as finished. Report in March, end in May, and March's P&L carries finished goods at estimate while WIP carries the difference for two months.
Manual journal entries into the WIP account. Somebody needed a plug. Lock the account from manual entry and the problem stops recurring.
The reconciliation nobody builds
WIP in Dynamics 365 is a subledger balance pretending to be a control account, so treat it like one. Once a month, tie the WIP main account balance to the accumulated cost of every production order not in Ended status at period end.
If the two tie, you don't have a problem, you have a backlog, and you can quantify it. If they don't tie, the difference is almost always manual journals to the account or orders ended in a period other than the one you're looking at.
I'd also age the open orders. Started or Reported as finished for more than 30 days is a reasonable flag for most discrete manufacturers. A plant with long cycle times needs a different threshold, but it still needs one.
A close checklist you can actually hand to someone
All production reported before cutoff, including scrap and error quantity
Unposted picking list and route card journals cleared
End run as a batch for everything complete, before cutoff
WIP balance tied to open orders by status, with an aging
For anything not on standard cost, inventory recalculation or close run before you trust unit costs
No manual journal entries in the WIP account, ever
If you're already a year behind
Don't mass-end three hundred orders on a Tuesday because the balance bothers you. Every variance and adjustment lands in whatever period you post it in, and a cleanup you ran in November shows up as a November margin problem the CFO has to explain. Pick the period deliberately, size it first by running the end on a copy of production, and tell finance the number before they find it.
Frequently asked questions
Does ending a production order always post to the general ledger?
Only if ledger posting is enabled for costing in the production control parameters. Ending always calculates actual cost and settles the order's WIP internally. Whether that reaches the GL is a setup question, and if the answer is no, your inventory values and your ledger will disagree instead.
Why is our WIP account negative?
Usually report as finished running ahead of material consumption, so the credit side posts before the debit side. Check the flushing principles on the BOM lines and whether picking lists are actually getting posted.
Can we end a production order in a closed period?
No, and that's the right behavior. If the order should have been costed in a closed period, you're choosing between reopening the period and accepting the cost in the current one. That's a controller's decision, not a consultant's.
We use FIFO, not standard cost. Does any of this apply?
All of it except the variances. Non-standard items don't generate the four production variances. The difference between estimate and actual shows up as cost adjustments once you run inventory recalculation or close, which means your production costs aren't final until that runs.
Should WIP be one account or several?
Split it at least between material and conversion cost if you want anyone to diagnose the balance later. One lump WIP account is easy to set up and painful every month after that.
Stay tuned (or don't) for parts 2 and / or 3
DynamicsDad
Comments