Guides

How to Set Up Real-Time WIP Accounting in Odoo

Most manufacturers value work-in-progress monthly, manually, approximately. Real-time WIP accounting means production costs post to the ledger as manufacturing actually progresses: materials into WIP at consumption, conversion costs at operations, finished goods out at completion. We built exactly this and have kept it live across Odoo 15 through 19.

This guide shares the architecture. Full delivery story: the case study.

What it takes in practice

  • Define the costing events. Which production moments post journals: material consumption, work order completion, labour/overhead application, finished-goods receipt. Your accountant defines the treatment; the system enforces it identically every time.
  • Automate journals from production state. Custom logic watches manufacturing orders and generates the corresponding entries with full source references, replacing month-end estimation with continuous truth.
  • Handle the messy realities. Scrap, rework, partial completions and by-products all need defined postings, because real factories produce all four weekly. Undefined cases become manual journals, which is the disease you’re curing.
  • Reconcile WIP as a control. A WIP account that reconciles to open manufacturing orders at any moment is the health check: if ledger WIP matches operational WIP, the system is truthful.
  • Survive upgrades by design. Accounting automation must outlive Odoo versions. Ours has crossed four majors live; the architecture choices (clean module boundaries, tested logic) are what made that affordable.
  • Month-end becomes review. With WIP posting continuously, close becomes reviewing exceptions rather than constructing estimates, typically saving days per month and an argument per quarter.

Where a specialist earns the fee

This is real engineering, not configuration, and the design decisions matter more than the code. We’ve built these systems at production scale, from real-time WIP accounting carried live across Odoo v15 to v19 to a platform running 150-plus tenants, and the value we add is the judgement to avoid the expensive wrong turns rather than just the hours to type. If the scope here matches something you need built properly, we scope it with a fixed quote and an hours breakdown before anyone commits.

Common questions

Our costs aren't accurate enough for real-time posting.
Start with materials (usually reliable) and standard rates for conversion, then refine. Real-time posting with periodic rate review beats monthly guesswork on both speed and accuracy.
Does this require Odoo Enterprise?
The pattern works on both editions; Enterprise's accounting features make some reporting nicer. The custom logic is edition-agnostic and we've built it as such.
What does the auditor think?
Auditors tend to love it: every WIP movement carries its source production event, making sampling and walkthroughs trivially traceable compared with month-end estimate journals.

Not sure where to start? Book a free discovery call and we’ll map your current setup, or request a free Odoo health check if you’re already running Odoo.

Next step

Ready to fix your ops?

Book a free discovery call. We'll look at your current setup and tell you honestly whether Odoo is the right move and what it would involve.