Why Month-End Close Slips in Manufacturing
A trading business mostly reconciles cash, receivables and payables. A manufacturer has to reconcile all of that plus inventory in three forms (raw material, work in progress and finished goods), the cost of converting one into the next, job work sitting at vendors, and GST that depends on where goods moved and at what value.
When those live in different tools, closing the month means exporting, matching and adjusting by hand, and the statements that come out are only as trustworthy as the last spreadsheet someone checked.
1. Sub-Ledger Tie-Out: Do the Parties Add Up to the Ledger?
Your trade receivables control account should equal the sum of every customer balance, and your trade payables account should equal the sum of every supplier balance. When they differ, something was posted to the control account without a party, or to a party without reaching the ledger.
- Run the tie-out as of the last day of the month, not today.
- A difference of zero is the only acceptable result. Anything else is a specific entry to find, not a rounding issue to write off.
- Investigate manual journals first; they are the most common way a control account moves without a party.
2. Stock-to-GL Reconciliation: Does Inventory Match the Books?
The value of stock in your inventory records should agree with the inventory accounts in the general ledger. In a manufacturing ERP this breaks in predictable places.
- Goods received but not yet billed, and bills posted before goods arrived.
- Stock adjustments and write-offs recorded in inventory without a matching journal.
- Material issued to production that never reached work in progress in the books.
- Landed costs such as freight added to a bill after the stock was already valued.
3. WIP Valuation and WIP Ageing
Work in progress is where manufacturing cost hides. Value it across the whole floor, not order by order, and age it: a work order that has held material for 90 days is either stuck or already finished and not booked.
Closed and cancelled work orders should carry no WIP. If they still do, material or labour was issued after completion or never relieved to finished goods.
4. Material Variance: Usage Versus Rate
When the actual cost of production differs from standard, split the difference into two causes. Usage variance means more or less material was consumed than the bill of materials allows; that is a floor problem. Rate variance means the material cost more or less per unit than planned; that is a buying problem. A single combined variance tells you something went wrong but not who should fix it.
5. GST, TDS and MSME Checks Before You File
Reconcile the tax side before returns are filed, while there is still time to correct a document.
- Match your purchase register to GSTR-2B and resolve missing or mismatched supplier invoices.
- Track input tax credit that must be reversed under Rule 37 for supplier bills unpaid beyond 180 days, and make sure a reversal is reported once, not every month.
- Check export invoices and foreign-currency invoices are reported at the correct value and as zero-rated where applicable.
- Reconcile TDS deducted against Form 26AS, and check MSME supplier payments against the 45-day rule.
6. Lock the Period, and Mean It
Once the month is signed off, lock it. A period lock only protects you if it covers every entry that affects the statements: ledger journals, and also stock movements, receipts and adjustments. A lock that covers only the ledger still lets someone back-date a stock adjustment into a closed month and quietly change a signed-off inventory value.
A Month-End Close Checklist
Use this sequence each month:
- Post all goods receipts, bills, dispatches and invoices up to the last day.
- Run the sub-ledger tie-out for receivables and payables. Resolve to zero.
- Run the stock-to-GL reconciliation. Resolve every difference.
- Review WIP valuation and WIP ageing. Clear closed orders carrying WIP.
- Review usage and rate variance and assign follow-ups.
- Reconcile GSTR-2B, Rule 37 reversals, TDS and MSME payments.
- Produce the trial balance, profit and loss, Schedule III balance sheet and cash flow.
- Lock the period.
How ERPDrive Supports the Close
ERPDrive posts production, inventory and finance to one ledger, and includes the reports this checklist relies on: sub-ledger tie-out, stock-to-GL reconciliation, Day Book and voucher verification, WIP valuation and ageing, material variance split into usage and rate, receivable and payable ageing that can be pinned to a past date, GSTR-1, 3B, 9 and 2B, ITC Rule 37 tracking, TDS forms and a Schedule III balance sheet. Its period lock covers stock movements as well as ledger entries. See the full list on the Reports and Analytics page.
Frequently Asked Questions
What is a sub-ledger tie-out?
It is a check that the balance of a control account, such as trade receivables, equals the sum of the individual customer or supplier balances behind it. A non-zero difference points to a specific posting error.
Why does inventory not match the general ledger?
Common causes are goods received but not billed, stock adjustments without a matching journal, material issued to production that never reached work in progress, and landed costs added after stock was valued.
What is the difference between usage variance and rate variance?
Usage variance comes from consuming more or less material than the bill of materials allows. Rate variance comes from paying a different price per unit than planned.
Should stock movements be blocked in a closed period?
Yes. If only ledger entries are locked, a back-dated stock adjustment can still change a signed-off inventory value.