Reconcile factory inventory and WIP at the financial cutoff

Why physical counts and general-ledger values disagree at month end

In machinery and process manufacturing plants running across multiple shifts, physical material movement rarely pauses cleanly at 23:59:59 on the last day of the month. When the Finance Controller compares the month-end physical/cycle-count valuation (M020) and open WIP ledger (M071) against the general ledger (GL) control accounts on Day +2, large variances appear across raw material, WIP, and subcontract stock—even when not a single component was stolen or lost.

Four cutoff timing mismatches cause the vast majority of month-end factory reconciliation errors:

1. Late subcontract or purchase receipts (Physical_Event_Date ≤ Cutoff below Posting_Date): A lorry carrying machined castings from a subcontractor (S02) arrives at the factory gate at 21:40 on 31 October and is unloaded into the inspection bay (counted in physical stock), but the stores clerk posts the ERP subcontract receipt and material consumption at 09:30 on 1 November. On 31 October at midnight, the ERP still shows the raw forgings sitting at the subcontractor warehouse and 0 finished castings in the plant.
2. Issued to shop floor but unbackflushed in WIP (M011): Stores physically hands over 40 steel plates to fabrication on 30 October, or an operator finishes a batch at 22:30 on 31 October, but the production order backflush is posted on 1 November—leaving raw material overstated or WIP understated at cutoff.
3. Unsegregated customer-owned or vendor consignment stock (S24, M018): Physical floor counts include free-issue customer motors or vendor-managed fasteners that rightly carry ₹0.00 value on the company's balance sheet.
4. GRN/IR price and quantity cutoff mismatches (S18): Goods are received before cutoff without a matched vendor invoice, or an invoice is posted in October for goods that physically cross the gate on 1 November.

Direct answer: A reliable month-end inventory and WIP cutoff workflow locks a precise Cutoff Timestamp, captures both Physical_Event_Timestamp and Ledger_Posting_Timestamp on every boundary transaction, reconciles raw, WIP, finished, and external/custody stock through an explicit Quantity and Valuation Cutoff Bridge, and resolves timing gaps through authorised cutoff journals or controlled period postings—never by erasing audit timestamps or lumping timing differences into unexplained stock write-offs.

As documented in ERPNext outward subcontracting and ERPNext inward customer-stock workflows, external processor stock and customer-provided stock follow distinct warehouse and consumption transitions. Meanwhile, Microsoft Dynamics 365 accounts payable invoice matching governs the reconciliation between product receipts and vendor invoices. All cutoff recognition rules, accrual reversals, and period-reopening authorities must follow your company's approved accounting policy and external audit requirements.

Month-End Factory Inventory & WIP Cutoff Reconciliation Workflow

Follow the workflow below, or open its complete text version.

Read the complete workflow as text

1. Publish Month-End Cutoff Timestamp (e.g., 31 Oct 23:59:59)... → Extract Unadjusted ERP Subledgers (Raw, WIP, Finished, Subc...
2. Extract Unadjusted ERP Subledgers (Raw, WIP, Finished, Subc... → Compile Physical Count & Boundary Event Logs (Gate Pass, Un...
3. Compile Physical Count & Boundary Event Logs (Gate Pass, Un... → Exclude Non-Owned Customer & Consignment Stock from Valued...
4. Exclude Non-Owned Customer & Consignment Stock from Valued... → Match Boundary Events: Compare Physical_Event_Timestamp vs...
5. Match Boundary Events: Compare Physical_Event_Timestamp vs... → Classify in Cutoff Bridge (Late Subcontract Return, Unposte...
6. Classify in Cutoff Bridge (Late Subcontract Return, Unposte... → Isolate in Named Physical Variance Register for Stores/Prod...
7. Isolate in Named Physical Variance Register for Stores/Prod... → Finance Controller Approves Cutoff Adjustment / Period Post...
8. Finance Controller Approves Cutoff Adjustment / Period Post... → Verify Reconciled Subledger + Cutoff Bridge Matches GL Cont...

Worked example: reconciling a straddling subcontract return and unbackflushed WIP at cutoff

The following scenario, dates, quantities, unit costs, and ledger balances are explicitly illustrative and use assumed values to demonstrate a month-end quantity and value cutoff bridge across raw, subcontract, WIP, and finished stock.

Suppose an industrial pump manufacturer closes its monthly financial books at 2026-10-31 23:59:59 IST. To see how cutoff reconciliation resolves apparent multi-bucket variances without hiding physical losses, trace the month-end position for Pump Impeller Family IMP-300 across four inventory buckets:

• Standard raw casting cost (RAW-IMP-300, rough stainless casting): ₹1,500.00 / unit
• Contracted external CNC machining charge at Subcontractor SUB-CNC-04 (S02): ₹400.00 / unit
• Standard semi-finished machined impeller cost (SFG-IMP-300 = ₹1,500 + ₹400): ₹1,900.00 / unit
• Internal balancing & assembly conversion cost added in Plant WIP (WIP-IMP-300): ₹300.00 / unit (yielding finished impeller assembly FG-IMP-300 at ₹2,200.00 / unit).

1. Comparing unadjusted ERP ledger at 2026-10-31 23:59:59 vs physical cutoff count

When Stores and Finance compare the unadjusted ERP snapshot taken at 23:59:59 on 31 October against the verified physical cutoff count at the plant and subcontractor, every single bucket appears out of balance:

At first glance, the subledger looks chaotic: Raw Store is short 42 units (−₹63,000), Subcontractor stock is short 80 units (−₹1,20,000), Semi-Finished Store is over by 80 units (+₹1,52,000), and Shop-Floor WIP is over by 55 counted units!

2. Resolving the three cutoff events and one real physical variance

Rather than booking blind write-offs and write-ons across the four accounts, the Cutoff Bridge traces the exact event timestamps versus posting timestamps:

1. Event A — Subcontract return received before cutoff, posted after cutoff (80 units):

   • Lorry carrying 80 machined impellers (SFG-IMP-300) from SUB-CNC-04 arrived at the plant gate at 2026-10-31 21:15 IST (Gate Pass GP-1031-88, physical arrival ≤ cutoff) and was placed in the Semi-Finished bay (counted in Bucket 3 physical = 130 units).
   • However, the stores clerk posted Subcontract Receipt SCR-2026-1102 at 2026-11-01 09:20 IST.
   • Cutoff bridge impact: Recognising the October physical arrival moves 80 units (₹1,20,000.00 casting value) out of Bucket 2 (Subcontractor Stock: 120 − 80 = 40 units, matching physical 40) and adds 80 units (₹1,20,000.00 casting + 80 × ₹400 = ₹32,000.00 accrued subcontract machining charge = ₹1,52,000.00) into Bucket 3 (SFG Store: 50 + 80 = 130 units, matching physical 130).

2. Event B — Raw castings physically issued to shop floor on 31 Oct, slip keyed on 1 Nov (40 units):

   • At 2026-10-31 19:45 IST, Stores issued 40 raw castings (₹60,000.00) on signed Issue Slip MIS-4490 to the assembly shop floor (WIP), but the ERP material transfer was keyed on 2026-11-01 08:10 IST.
   • Cutoff bridge impact: Moving 40 units (₹60,000.00) from Bucket 1 (Raw Store: 300 − 40 = 260 units) to Bucket 4 (Owned WIP: 60 + 40 = 100 owned units) resolves both the +40 owned WIP overage and 40 of the 42 Raw Store shortage.

3. Event C — Customer-owned free-issue impellers sitting on the shop floor (15 units):

   • Physical counters tallied 115 impellers on the floor in Bucket 4, which included 15 customer-owned impellers (JWO-CUST-19, S24) held for repair under a non-valued custody order (M018, M067).
   • Cutoff bridge impact: Separating those 15 custody units into the non-valued Customer_Custody_Ledger (115 total counted − 15 customer FOC = 100 company-owned WIP units) aligns physical owned WIP (100 units, ₹1,50,000.00) with the Event B adjusted ERP WIP (60 + 40 = 100 units, ₹1,50,000.00).

4. Item D — Remaining true physical variance in Raw Store (−2 units):

   • After deducting the 40 units issued on MIS-4490 (Event B), Raw Store expected book stock is 300 − 40 = 260 units (₹3,90,000.00) versus physical count 258 units (₹3,87,000.00).
   • The remaining −2 units (−₹3,000.00) is a genuine unposted physical discrepancy (later traced to 2 castings taken for destructive metallurgical sectioning without a scrap issue note) and is logged as Named Variance Item VAR-2026-10-04 for Inventory Controller sign-off.

3. Complete month-end cutoff bridge table (2026-10-31 23:59:59 IST)

*Note on Event A value bridge: Moving 80 units from Subcontractor (₹1,500/unit = ₹1,20,000) to Semi-Finished Store (₹1,900/unit = ₹1,52,000) conserves physical castings (−80 + 80 = 0 net units) while recognising +₹32,000.00 (80 × ₹400.00) of accrued subcontract machining value added before midnight on 31 October (matched by a +₹32,000.00 Unbilled Subcontract GRN/IR accrual under S18).

Check the overall reconciliation arithmetic:

• Unadjusted net value difference (Physical ₹8,44,000 minus Unadjusted ERP ₹8,15,000): +₹29,000.00.
• Explained by Event A (+₹32,000.00 subcontract value added on received lot) + Event B (₹0.00 internal transfer between Raw and WIP) + Item D (−₹3,000.00 destructive test shortage): +₹32,000.00 + ₹0.00 − ₹3,000.00 = +₹29,000.00 (every rupee and unit is fully reconciled!).

Governance rules for cutoff adjustments and period locks

Acceptance criteria for month-end inventory and WIP cutoff reconciliation

1. Straddling transaction detection (TEST-M070-01): A cutoff query identifies every receipt, subcontract return, floor issue, and shipment where Physical_Event_Date and Ledger_Posting_Date fall in different accounting periods.
2. Custody stock exclusion (TEST-M070-02): Physical count sheets and WIP reports segregate customer-owned (S24) and vendor-consignment (M018) quantities so non-owned stock is never multiplied by company valuation rates.
3. Zero-sum internal transfer verification (TEST-M070-03): Every late shop-floor issue or subcontract return adjustment balances quantities across source and destination buckets (−40 Raw = +40 WIP; −80 Subcontract = +80 SFG) while isolating added conversion accruals (+₹32,000).
4. Subledger-to-GL tie-out without anonymous plugs (TEST-M070-04): After applying the approved Cutoff Bridge and named variance adjustments, the sum of Raw, WIP, Finished, and External subledgers reconciles to the GL control accounts (M071), and every unresolved item carries a unique exception ID and owner.

Synthesis and next actions

Month-end inventory and WIP reconciliation turns from a three-day argument into a repeatable two-hour check when you separate timing straddles across boundaries from real physical stock losses and never allow non-owned custody stock to pollute valued counts.

1. Publish a last-document cutoff register at midnight on close day: Capture the final gate pass, GRN, subcontract challan (S02), floor issue slip (M011), and dispatch note numbers at 23:59:59 before counting begins (M020).
2. Require both Event_Timestamp and Posting_Timestamp on warehouse and WIP transactions: Configure receiving and shop-floor screens so late-keyed entries record the actual gatepass or shift time without altering the system audit timestamp.
3. Run an automated 48-hour straddle query on Day +1: Extract all movements posted during the first 48 hours of the new month whose physical gate pass or shift date belongs to the prior month, and populate the Cutoff Bridge automatically.
4. Reconcile external subcontract and customer-custody balances before locking GL accounts: Verify subcontractor challan balances (S02), customer free-issue stock (S24), and GRN/IR clearing accounts (S18) alongside in-house WIP (M071) before signing off the monthly close.