Rella Solutions
Back to Blog
Bookkeeping

CPG Month-End Close Checklist

Oct 22, 20268 min read

A good CPG month-end close is boring in the best possible way. Same order every month. Same files. Same review points. By day 10, the team should know what moved, what was estimated, and who owns each follow-up item.

The hard part is that CPG books do not close from the bank feed alone. Inventory moves through 3PLs and co-mans, Shopify and Amazon settle net, retailers take deductions after the sale, and freight bills show up late. If you wait for every perfect document, the close drifts. If you book whatever hit cash, the profit and loss is not useful.

The practical answer is simple: close on a clean process, then keep a visible schedule of estimates and true-ups. Here is the 10-day checklist I would use for a founder or controller who wants practical books.

If you want the one-page version, grab the month-end close checklist PDF and use this article as the explanation behind it.


01

The 10-Day Close Sequence

The close needs a fixed cadence before it needs a perfect spreadsheet. Use the same day-by-day sequence every month so the team knows what has been finalized and what is still waiting on backup.

10-Day CPG Close Timeline

Day 0Set cutoff and freeze the close folder
Day 1Clear cash, cards, and payout accounts
Day 2Lock sales and AR
Days 3 and 4Close inventory cutoff and landed cost
Day 5Accrue trade spend
Day 6Review chargebacks and claims
Day 7Review COGS, margins, and channel profit and loss
Day 8Tie AP, prepaids, and accruals
Day 9Controller review
Day 10Lock the month and start the true-up log
A 10-day close does not mean every estimate is perfect. It means the method is repeatable, the open items are visible, and the founder can use the numbers without waiting another three weeks.

02

Day 0: Set Cutoff Before Month-End

The close starts before the calendar flips. Send the cutoff note to the warehouse, co-man, sales lead, and whoever owns trade spend. Ask for the last shipping date, receipts not yet posted, inventory holds, damaged goods, open production runs, and any known customer credits.

✓
Confirm the last ship date for each warehouse and 3PL.
✓
Ask the co-man for open production runs and inventory still on site.
✓
Collect known customer credits, deductions, and disputes before revenue is finalized.
✓
Freeze the close folder so exports and backup have one source of truth.

Close Folder Inputs

Accounting systemQuickBooks or ERP exports
PayoutsShopify, Amazon, Stripe, and marketplace reports
PayablesBill.com AP list and late vendor bills
CardsRamp activity, receipts, owners, and memos
Inventory3PL reports, co-man reports, and SKU rollforward
DeductionsDeduction log, portals, claims, and dispute status

03

Days 1 and 2: Clear Cash, Payouts, Sales, and AR

Start with the balance sheet. Reconcile every bank account, credit card, line of credit, and clearing account. Ramp transactions should have a vendor, class or department, memo, receipt status, and an owner before they hit the profit and loss. Bill.com payments should tie back to the vendor bills they actually paid.

Pull invoices by channel and compare them to shipment data. Retail and distributor invoices should match what shipped before cutoff. DTC orders should match the store export, payment processor, and refund report.

✓
Reconcile each bank, card, and line of credit account.
✓
Tie marketplace deposits to gross sales, discounts, refunds, fees, sales tax, reserves, and timing differences.
✓
Match distributor and retail invoices to shipments before cutoff.
✓
Compare DTC orders to store exports, processor activity, and refund reports.

This is where trade terms matter. If a promotion, rebate, or expected deduction changes the price you expect to collect, it belongs in the close conversation before revenue is called final. FASB's revenue recognition materials are the place to start when you need the accounting standard behind that idea.

Do not book Shopify, Amazon, Stripe, or marketplace deposits as revenue. Those deposits are cash settlements. If the clearing account does not roll forward cleanly, revenue is probably wrong.

04

Days 3 and 4: Close Inventory Cutoff and Landed Cost

Inventory cutoff is usually the biggest close risk for a growing CPG brand. Ask the 3PL for units on hand as of month-end, receipts after cutoff, shipments after cutoff, quarantined goods, and adjustments. Ask the co-man for finished goods not yet transferred, raw materials owned by the brand, work in process, and production runs that crossed month-end.

✓
Get units on hand as of month-end from the 3PL.
✓
Review receipts, shipments, quarantined goods, and inventory adjustments after cutoff.
✓
Confirm finished goods, raw materials, and work in process still held at the co-man.
✓
Reconcile the inventory subledger to the general ledger before moving on.

Refresh the landed cost model here. The CPG COGS mistakes post goes deeper on freight-in and co-man costs, so the close task is not to rebuild the whole model. The close task is to catch new freight, duties, testing, packaging, and production charges that belong with the inventory they helped create.

If the inventory subledger does not tie to the general ledger, stop and explain the difference before finalizing COGS. A clean cash rec will not save a bad inventory cutoff.

05

Day 5: Accrue Trade Spend

Trade spend should not wait for cash deductions to hit. Pull the promo calendar, customer agreements, distributor portals, deduction log, and any open retailer claims. Estimate the month's off-invoice allowances, scanbacks, billbacks, MCBs, free fills, and slotting fees.

If this area is fuzzy, read the trade spend accounting guide first. During close, the goal is a rollforward: beginning accrual, plus new accruals, less deductions applied, equals ending accrual. The ending balance should feel reasonable against the open promo calendar.

Trade Spend Rollforward

Beginning accrualPrior month ending balance
PlusCurrent month promo and allowance accruals
LessDeductions and credits applied
Ending accrualBalance supported by open promos
✓
Review off-invoice allowances, scanbacks, billbacks, MCBs, free fills, and slotting fees.
✓
Compare the ending accrual to the open promo calendar.
✓
Document the estimate source and owner for every large accrual.

06

Day 6: Review Chargebacks and Claims

Retailer deductions need a separate lane from authorized trade spend. Shortage claims, compliance fines, pricing disputes, duplicate deductions, and damaged goods credits should not disappear into one contra-revenue bucket with no owner.

Create an aging by retailer and status. Accepted, disputed, waiting on backup, written off. If a claim is old and nobody owns it, the close meeting should make that obvious. The retailer chargebacks article covers the prevention side. The close job is to make the dollars visible before they become permanent margin leakage.

Deduction Aging Status

AcceptedValid deduction, coded to the right account
DisputedClaim sent back with backup
Waiting on backupOwner assigned, support requested
Written offApproved close decision with reason
Retailer deductions should not disappear into one contra-revenue bucket. Split authorized trade activity from shortages, compliance fines, pricing disputes, duplicate deductions, and damaged goods credits so the owner is clear.

07

Days 7 and 8: Review Margins, AP, Prepaids, and Accruals

Once revenue, inventory, and deductions are posted, run gross margin by SKU and by channel. Look for the weird stuff: negative margin SKUs, Amazon margin that moved without an obvious fee change, wholesale gross margin that improved because deductions were missed, or freight sitting below gross margin.

This is also a good time to compare inventory valuation policy against what is in the system. FIFO, weighted average, and specific identification can tell different stories. The inventory valuation guide is useful background if the team is still deciding which method fits.

Review vendor bills received after month-end for services or goods that belong in the closed month. Freight, storage, co-man charges, broker commissions, software, agency retainers, and contractor work are easy to miss. If the bill is not in Bill.com yet, accrue it with backup and reverse it next month.

Prepaids need the same discipline. Insurance, annual software, large retainers, and slotting fees should amortize over the period they benefit.

✓
Review gross margin by SKU and by channel.
✓
Investigate negative margin SKUs and unusual channel movements.
✓
Make sure freight-in, landed cost, and co-man charges are in the right place.
✓
Accrue late freight, storage, broker, agency, contractor, and co-man costs with backup.
✓
Update prepaid amortization for insurance, software, retainers, and slotting fees.

08

Days 9 and 10: Controller Review, Lock, and True-Up Log

Before calling the books closed, read the balance sheet like a skeptic. Every clearing account should have a reason. Every accrual should have support. Every weird margin movement should have a short explanation. This is where a controller earns the title.

I like a one-page close review with bank rec status, inventory bridge, trade spend rollforward, deduction aging, margin summary, open estimates, and owner for each follow-up item. A founder should be able to read it in 10 minutes and know what changed.

On day 10, lock the month in QuickBooks or the ERP. Limit changes to controller-approved entries. Keep a true-up log for late freight, deduction support, AP surprises, inventory adjustments, and Amazon or Shopify timing items. Next month's close should start with that log.

One-Page Close Review

Reconciliation statusBank, cards, payouts, and clearing accounts
Inventory bridgeGL to SKU rollforward explanation
Trade spend rollforwardBeginning, accruals, deductions, ending
Deduction agingStatus, owner, and next action
Margin summarySKU and channel changes explained
Open estimatesTrue-up log with owner and expected timing

The Close Standard

The founder should be able to read the close review in 10 minutes and know what changed, what is estimated, and what the team will true up next month.

09

FAQ

How fast should a CPG brand close the month?

A practical target is a 10-day close. That gives the team enough time to reconcile cash, clear payouts, validate inventory cutoff, accrue trade spend, review deductions, and explain open estimates before the month is locked.

Why is inventory cutoff so important?

Inventory cutoff is often the largest close risk because receipts, shipments, production runs, quarantined goods, and 3PL adjustments can cross month-end. If the inventory subledger does not tie to the general ledger, gross margin and COGS are unreliable.

Should trade spend wait until cash deductions hit?

No. Trade spend should be accrued based on the promo calendar, customer agreements, distributor portals, deduction logs, and open claims. The close should include a rollforward from beginning accrual to ending accrual.

What should be reviewed before locking the month?

Review bank reconciliation status, payout clearing accounts, the inventory bridge, trade spend accruals, deduction aging, SKU and channel margins, AP accruals, prepaid amortization, open estimates, and owners for follow-up items.


The Bottom Line

A good CPG close is not built on heroics. It is built on cutoff, reconciliations, inventory discipline, accrual support, deduction visibility, and a true-up log that makes next month cleaner.

If your close still depends on heroic spreadsheet work, Rella can help. Start with our CPG accounting and finance services, or send us a note if you want a second set of eyes on your close process.

Need help with your CPG finances?

We help CPG brands get their numbers right — so they can make better decisions and grow profitably.

Book a Free Consultation