The NetSuite Month-End Close Checklist for CPG Brands

Most CPG finance teams don't have a close problem — they have a sequencing problem. NetSuite can produce a clean, decision-ready close on a fixed calendar, but only if inventory, landed cost, and deductions are locked down before the accounting team starts reconciling. Do it out of order and every downstream number gets touched twice.

Before you close: lock the inputs

The close should not start until three things are true for the period. If any of these are still moving, the numbers you close on will need to be restated.

• Inventory transactions (receipts, transfers, adjustments) for the period are fully entered — no backdated entries after this point.
• Landed cost allocations (freight, duty, and other inbound costs) are applied to the relevant receipts, not sitting in a suspense account.
• Deduction and chargeback claims from the period are logged against the correct customer and reason code, even if they haven't been resolved yet.

The close sequence

1. Inventory and landed cost

Reconcile the NetSuite inventory valuation report against your 3PL or warehouse counts. Landed cost variances are the single most common source of COGS misstatement in CPG — a freight invoice that lands two weeks after the goods it's allocated to is the classic case. Book landed cost accruals for anything received but not yet invoiced.

2. Deductions and trade spend

Deductions taken by retailers against invoices need to hit the right account — not just AR as an unexplained shortfall. Categorize by reason code (shortage, promotional allowance, chargeback, compliance fine) so the P&L shows real trade spend instead of a mystery variance. This is also what makes margin-by-SKU reporting trustworthy later.

3. Cash, AP, and AR reconciliation

Standard reconciliation, but sequenced after inventory and deductions because both feed AR aging and AP accruals. Reconcile bank feeds, clear suspense accounts, and confirm AP accruals for received-not-invoiced goods match what you booked in step one.

4. Margin review by SKU and channel

This is the step that turns a close into decision-ready reporting. Once inventory, landed cost, and deductions are locked, gross margin by SKU and by channel should move predictably period to period. A margin swing that doesn't map to a known driver (a price change, a new landed cost, a spike in deductions) is a signal something upstream wasn't actually locked.

5. Close and lock the period

Lock the period in NetSuite once reporting is reviewed. A locked period is what makes the next month's close faster — nobody is chasing backdated entries into a period that's supposed to be done.

What a standardized close protects

Beyond speed, a close that runs this way produces two things most CPG operators actually need: lender-ready reporting (asset-based lenders will pull inventory valuation and AR aging directly) and margin clarity you can act on mid-quarter instead of discovering at year-end.