How To Post End of Month WIP Amounts
Move the material and labor tied up in open production orders onto the balance sheet at month end, with a ledger entry that reverses itself on the first day of the next month.Updated Nov 9 2026
Before you start
- The WIP Aging Report is under Production > Orders and needs the Production role. Its cost columns only show if you can see costs: Total Material Cost and Overhead Value need Can See Cost, and Labor Value needs Can See Labor Cost. Users with the Production Only or Hide Cost role don't see them.
- The Account List and the Ledger are under Accounting > Chart/Ledger and need the Accounting role.
- The month you post into must still be open. If it's before your company's GL lock date, the entry is refused unless you have the Admin or Accounting Admin role.
-
Get the WIP totals
- Go to Production > Orders > WIP Aging Report. The page is headed WIP Aging Report.
- Click the filter search bar (Filter or search…) and set:
- As Of Date – the last day of the month you're closing (type it as YYYY-MM-DD and press Enter).
- Show Totals? – choose Yes.
- Location – only if you post WIP separately for each warehouse.
- Click Apply (n). The table lists every order line with work in progress on that date.
- Read the Totals row at the bottom of the table: Total Material Cost is your materials WIP and Labor Value is your labor WIP. Write both down. Overhead Value is totalled too, if you also post overhead.
-
Create the WIP accounts
Do this once. Skip it if your chart of accounts already has WIP accounts.
- Go to Accounting > Chart/Ledger > Account List and click Create Account. A form opens at the top of the page.
- In Account Parent, pick the current-asset account the WIP accounts roll up into (for example Other Current Assets). Type an Account Name such as WIP – Materials and an Account Number.
- Click Create. Cetec shows Account created. and lists the new account under its parent.
- Repeat steps 5–7 for WIP – Labor.
-
Post the WIP entry
Go to Accounting > Chart/Ledger > Ledger. If the page shows DEPRECATION WARNING: This page is no longer maintained…, click current version in that warning.
Click Add Entry. The Add Entry window opens with two empty split rows.
Under Entry Details, type an Entry Name (for example WIP – March 2026) and set the Transaction Date to the last day of the month you're closing. Pick the Location if your company posts by location.
Next to Add Split, type
2in the small box and click Add Split, so you have four split rows.Fill in the four rows. Use the Notes box on each row to repeat the entry name or say what the line is for.
Account Debit (Amount In) Credit (Amount Out) WIP – Materials materials total WIP – Labor labor total your inventory account materials total your cost-of-goods-sold labor account labor total Check the line under the splits reads Entry Balanced. Submit Entry stays greyed out while it reads Entry Not Balanced; Difference is ….
Under Options, set Add Reversing Entry On to the first day of the next month.
Click Submit Entry. Cetec shows Entry Added. and posts two entries: yours, and a reversing entry on the first of the next month named Reversing {entry number}, {your entry name}.
-
Check the ledger impact
- On the Ledger list, remove the Transaction Date chip (its preset ranges all end today, so they miss next month's reversal), click the filter search bar, type the entry name and pick Name. Click Apply (n). You'll see the splits of both entries; the reversal is named Reversing {entry number}, {your entry name}.
- Click the number in the Split # column of one of your entry's rows. The entry opens as a full page, Edit Ledger Entry number. It shows Entry Reversed By Entry {number}.
- Click Summary View in the left-hand menu. General Ledger Summary lists the entry's splits by account, with signed amounts: WIP – Materials and WIP – Labor debited (positive), inventory and cost-of-goods-sold labor credited (negative). Its Transaction Date range runs from the entry date to tomorrow, so for an entry dated after today it shows nothing: set the second date to the entry date and click Submit.
- Go back to the entry and click the Entry {number} link in Entry Reversed By Entry {number} to open the reversal. It credits both WIP accounts and debits inventory and cost-of-goods-sold labor, so the WIP balance is back to zero on the first of the month.