Production work in progress
At the end of the month the production costs account (usually 231) keeps a balance: materials have been issued to the shop floor, work has been posted, but there are no finished goods yet. The accountant has to say what this amount is made of — which productions are still in progress and for how much — and the director wants to see how much money is "frozen" on the shop floor. The report splits the account balance on a date by production, and the lines add up to the balance by construction — the same balance the Nominal Ledger Report shows.
Where to find it: Modules → Production → Reports → Production work in progress
Parameters
- On Date — postings dated up to and including it. Empty — today.
- Account — one account. Empty — every production costs account set on productions and operations, plus the production costs account from the Account Usage setting. An account that is not in the chart of accounts is refused: "Account not found!" / "Check the field value and try again".

How to read the report
The report takes every posting on the account up to the date and assigns it to the document that made it:
- production postings (start and finish) — to that production;
- postings of production operations — to their production too: a production with stages is posted by its operations, and only their sum makes sense. An early stage debits the account with materials and outputs nothing, the last one credits the whole output — each operation on its own has a remainder, together per production it is zero;
- postings of other documents and opening balances — in a separate section.
Then come three sections:
| Section | What it holds |
|---|---|
| In progress on the date | productions not finished by that date (not yet Finished, or finished later) |
| Finished but with a balance on the account — check | finished by the date, but debit and credit do not match; also a Finished production with no end date (legacy data) once its output is posted by the date and a production with stages has also reached its last finished operation; the end date is empty |
| Other on the account | postings on the account from other registers (by register name) and "Forward Balances" |
At the bottom — "Balance of account … on the date": the sum of all three sections.
Line columns: the document (production number, linking to it), Structure and Name from the production, Finished product, Quantity, Location, Start date, for finished ones — End date, and three amounts: Consumed (Dt) — what went onto the account, Produced (Ct) — what came back to stock as finished goods, Work in progress — the difference.
The amounts are visible only to users with the "Show cost price" right. Without it the report shows only the list of productions.
Worked example
On 30 November account 231 has a balance of 13,762. The report shows what it is made of:
| Section | What | Consumed (Dt) | Produced (Ct) | Work in progress |
|---|---|---|---|---|
| In progress on the date | production of 20 frames, started 25.11 | 12,000 | 0 | 12,000 |
| Finished but with a balance | production finished 13.10 | 5,000 | 3,388 | 1,612 |
| Other on the account | an invoice posted to 231 | 150 | ||
| Balance of account 231 on the date | 13,762 |
The first line is real work in progress: 12,000 of materials on the shop floor, no frames yet. The second and third are things to fix: a finished production should have closed the account to zero, and a sale should not have reached the production costs account at all.
This is the report in the demo company on 30.11, account 231: production 4 of 03.11 is in progress, its first operation has already consumed materials for 119.40; besides it the account carries a payroll calculation posted to 231 (3,527.80) — the "Other on the account" section. Together that is the account balance, 3,647.20.

Good to know
A finished production with zero is not listed — only one with a remainder. A finished production keeps a remainder after a manual posting, a backdated cost change or a disassembly — the section exists precisely to make it visible.
Postings without a document. If a production or an operation was deleted but its posting stayed, the line goes into the "check" section marked "(no document)" — such amounts never go into "In progress". An operation that has no production is a line of its own marked "(operation without a production)".
Rounding — as in the Nominal Ledger Report. Each posting row is rounded by the company's Rounding setting before the amounts are added up, so the report's balance matches the Nominal Ledger Report to the cent. A remainder is an amount that is not zero after that rounding.
Subaccounts are not included — only exactly named accounts. If you keep production costs on subaccounts, run the report for each of them.
The report does not see productions without postings. If production postings are switched off in the Records from Subsystems setting, there is nothing on the account — and nothing to value work in progress by.
Where to look next
- Production and production operations — the documents whose postings make up the balance.
- Nominal Ledger Report — the same account balance without the split.
- Machine load — how many hours started productions take.