How work in process posts to QuickBooks: the journal entries behind a work order

QuickBooks does not know what a work order is. It knows debits and credits, and a work order produces a small, regular set of them: material into work in process, finished goods out of it, labor and overhead applied, scrap written off. This page lists those entries, works them through on one order, and says what the accounts should show at month-end — so the person who closes the books can see the manufacturing in them and trust it.

Reading this for your own shop? Start a free 14-day trial — no credit card, and your data is yours to export at any time.

1.The short answer

Two consequences fall out of that table, and they are the two things to check at month-end. The Work in Process balance is the material in open jobs and nothing else. And Production Variance carries, for every job closed out in the period, the difference between what its completions applied and what its confirmed time cost: the period's over- or under-absorption, which is a real number about the shop, not an error.

2.The example order

The shelf unit from the cost rollup guide: a work order for ten, released with a rolled cost of $811.80 — $668.30 material, $95.67 labor, $47.83 overhead — so $81.18 a unit. Every entry below uses those figures; they were frozen when the order was released, which is what makes the entries reproducible.

Issue: material into work in process

Whether the components are picked to the job deliberately or backflushed when units are reported complete, each component line posts as it is consumed, at the cost the order snapshotted. Issuing everything for the ten units:

Nothing about labor appears here. The steel has moved from the rack to the job; the welder's time has not been paid through this entry and is not pretended to have been.

Completion: finished goods out, in three credits

Four units are finished on Tuesday. They enter finished-goods inventory at $81.18 each, and the credit is split by the order's own proportions — material, labor, overhead — each share being that cost divided by the planned ten, times four:

The shares are rounded to cents and any rounding remainder lands on the WIP line, so the entry always balances. When the remaining six complete on Thursday, the same entry posts for six: $487.08 against $400.98, $57.40 and $28.70. After both, WIP has been debited $668.30 and credited $668.30 for this job — it nets to zero, which is the test of the whole design. An order with no routing cost, labor and overhead both zero, posts the plain two-line version, debit Inventory, credit WIP.

Scrap: straight to the P&L

Suppose one of the ten is scrapped at the welding step with a reason recorded. The components that unit had consumed are gone, so their cost does not belong in work in process, waiting to become a product that will never exist:

It goes to the same account shrinkage uses, because every connected company already has one mapped, so a scrap entry is never held up waiting for a setting. The labor and overhead that unit had absorbed up to the welding step are reported on the scrap event for job costing, but not posted — there is no asset to carry them. A scrap entered in error is reversed, not deleted, and the reversal is the mirror entry.

3.What the accounts should show at month-end

Work in Process

The material cost of every order that has been issued to and not yet completed. The inventory system keeps a WIP ledger per order and in total, derived from the same issue and completion movements that produced the entries above, so the reconciliation is one comparison: ledger total against account balance. Where they differ, the ledger names the order. The usual cause is an entry that failed to post and is sitting in the sync-error list waiting for someone.

Labor Applied and Overhead Applied

These are Cost of Goods Sold-type accounts that carry a credit for the period — the labor and overhead the completed units took into inventory with them. The actual wages and overhead were expensed through payroll and the usual expense accounts. If applied is less than actual, the shop under-absorbed: the routing rates or times were optimistic, or volume was low and fixed overhead had fewer units to land on. If applied exceeds actual, the reverse. Either way the figure is real information about the rates on the routing, which the cost rollup guide covers.

Production Variance: the close-out

When a completed order's actual time is confirmed, the job is closed out in one entry, so the applied accounts do not carry a job's estimate for ever. Labor and overhead variance — the confirmed actual minus what the completions applied — is debited to a Production Variance account (a Cost of Goods Sold-type account; if none is mapped, the entry uses your Cost of Goods Sold account) and credited back to Labor Applied and Overhead Applied; a favourable variance reverses the pair. Any material still sitting in WIP for that job — an override at completion, a component with no cost, rounding — is moved to the same account, so a closed job leaves WIP at zero. On the example order, confirmed at $120 of labor and $40 of overhead against $95.67 and $47.83 applied, the close-out debits Production Variance $24.33 and credits Labor Applied $24.33, then debits Overhead Applied $7.83 and credits Production Variance $7.83. Over the period, Production Variance is the shop's over- or under-absorption, on the P&L where the accountant expects it, and a job closes out once — a second confirmation posts nothing.

Inventory

Down by the material issued, up by the finished goods completed at full cost, down by scrap. The finished goods now carry labor and overhead in their inventory value, which is what lets cost of goods sold be right when they are sold — and why the applied accounts are needed on the other side.

4.Setting up the accounts

Four accounts beyond the ones any connected company has (Inventory Asset, Cost of Goods Sold, Inventory Adjustment):

• Work in Process — an Other Current Asset.
• Labor Applied and Overhead Applied — Cost of Goods Sold-type accounts, so the credit sits next to the expense it offsets.
• Production Variance — also Cost of Goods Sold-type, for the close-out. Optional: if it is not mapped, the close-out posts to your Cost of Goods Sold account.

Each is mapped once in the connection's account settings; the setup wizard suggests a match by name if one exists and creates one if not. If an account an entry needs is not mapped, the entry is held as pending with the missing account named — it is never dropped and never posted half-way — and it posts when the mapping is filled in.

5.QuickBooks Desktop

The entries above post to QuickBooks Online. On QuickBooks Desktop they are not sent today: the integration records that as a standing, visible limitation in its sync log rather than silently skipping the movements, so nobody discovers at year-end that a category of entry was missing. A Desktop shop runs the work-in-process ledger in the inventory system and posts a period-end summary journal entry from it. The Work in process report lays the month out as that one entry — issues, completions, applied labor and overhead, and any scrap or close-out variance — which is what most Desktop manufacturers were doing by hand before, with the difference that the numbers now come from a ledger rather than a spreadsheet. Receipts, sales and cost of goods sold post to Desktop as they do to Online; the Desktop integration guide covers the rest.

6.Questions people ask

Does a journal entry to Inventory change item quantities in QuickBooks?

No — a journal entry moves value between accounts, not units between items. In this arrangement the inventory system is the record of quantities and QuickBooks is the record of value, which is the division of labor the bill of materials guide argues for. Item-level valuation and cost of goods sold at sale are posted from the same system, so the two agree.

Why not post labor into WIP when the operator clocks on?

Because the amount is not known until the job is done and the actuals confirmed, and because payroll already expenses the wages on its own schedule. Applying labor at completion, at the rolled rate, and reconciling to actual at period end is the standard absorption approach, and it keeps WIP a clean material figure that ties to the physical job.

What if a job is completed at a cost different from the rollup?

A completion can carry an overridden unit cost. The override is what finished goods are booked at; labor and overhead are still applied at the rollup's amounts; WIP takes the difference, as a debit or credit the WIP ledger shows against that order; and the close-out moves that difference to Production Variance when the job's time is confirmed. The override is visible rather than absorbed, which is the point.

What happens to WIP when a job is cancelled?

Material already issued is returned from the job to stock, and the return posts as the mirror of the issue: debit Inventory, credit Work in Process. A cancelled job leaves no residue in WIP.