MACEBOOKS JOURNAL

The CPG Close: What to Reconcile Before Month-End

The CPG Close: What to Reconcile Before Month-End

A practical checklist for turning channel data, inventory movement, and operating costs into a close you can trust.

A practical checklist for turning channel data, inventory movement, and operating costs into a close you can trust.

Minimal product packaging on a studio surface

A close starts before the calendar says it does.

In Consumer Packaged Goods (CPG), waiting until Day 1 of the new month to begin reconciliations guarantees a frantic, error-prone close. High transaction volumes across multiple sales channels, complex supply chain lags, distributor deductions, and third-party logistics (3PL) discrepancies make CPG accounting uniquely vulnerable to blind spots.

Strong CPG financial reporting comes from a dependable rhythm: reconcile sales channels, validate inventory movement, map hidden fees, and flag exceptions before they hit the final ledger review. The goal isn’t more scramble—it’s a clear, repeatable close.

1. Multi-Channel Revenue & Payment Processor Clearing

Selling across direct-to-consumer (Shopify, Amazon) and wholesale (distributors, retail grocers) means gross sales rarely equal cash in the bank.

Reconcile merchant clearing accounts

Track sales reported by your eCommerce storefront against gross payouts and fees in Stripe, PayPal, or Shopify Payments. Any balance remaining in your clearing accounts must represent un-deposited in-transit payouts, not untracked chargebacks or refunds.

Amazon settlement splits

Break out bi-weekly Amazon settlements into gross product sales, promotional discounts, FBA fulfillment fees, storage charges, advertising spend, and sales tax collected. Avoid booking the net payout straight to revenue.

Wholesale cut-off dates

Ensure bills of lading (BOLs) and proof of delivery (PODs) match your revenue recognition criteria. If terms are FOB Destination, revenue cannot be recognized until goods arrive at the retailer’s distribution center.

2. Inventory Alignment & In-Transit Goods

Inventory is the primary engine of cost of goods sold (COGS). If your units are out of balance, your gross margins are fiction.

Reconcile 3PL warehouse management systems (WMS)

Pull month-end inventory stock reports from all co-packers, warehouses, and 3PLs. Match their ending unit counts against your internal ERP or inventory ledger (e.g., Katana, Cin7, DEAR). Investigate shrink, breakages, and unrecorded cycle count adjustments.

Match Amazon FBA inventory

Compare units received, sellable units on hand, and damaged or lost units reported in Seller Central against your recorded inventory. File reimbursement claims for warehouse-damaged stock promptly.

Track Goods-in-Transit (GIT)

Differentiate between raw materials paid for but still on the water versus stock currently in production at your contract manufacturer. Ensure capitalized freight and duties are correctly allocated to landed costs rather than expensed upfront.

3. Distributor Deductions & Trade Spend

Trade spend and distributor chargebacks are the quickest ways CPG margins erode invisibly.

Audit UNFI, KeHE, and direct-retail remittance advices

Line-item audit deductions for off-invoice discounts, MCBs (Manufacturer Chargebacks), scan-downs, slotting fees, and administrative fees.

Separate trade spend from operating expenses

Do not classify marketing bill-backs or promotional allowances as operating SG&A. Under GAAP/ASC 606, trade spending that does not deliver a distinct good or service must reduce gross revenue.

Flag invalid deductions immediately

Identify short-shipped claims, unsaleable returns, or unauthorized pricing penalties while delivery documentation is still fresh.

4. Landed COGS & Co-Manufacturer Invoicing

Calculating true product margins requires factoring in all components of direct cost.

Accrue unbilled manufacturing runs

If your co-packer completed production before month-end but has not yet invoiced processing fees or packaging, accrue the estimated liability to match against the inventory created.

Allocate freight-in and warehousing storage

Inbound freight from suppliers to the warehouse belongs in capitalized inventory, whereas fulfillment and outbound freight to end customers should hit fulfillment expense.

Scrap, yield, and component consumption

Reconcile raw material consumption reports from your co-manufacturer. If component scrap rates exceeded contract allowances, determine whether to write off excess waste or invoice the manufacturer for reimbursement.

5. Month-End Pre-Close Checklist

Run through these five critical checks before locking the period:

Category

Primary Objective

Key Document / Source

Merchant Clearing

Clear in-transit funds; book merchant processing fees

Shopify, Stripe, Amazon Settlement Reports

3PL Inventory

Match physical units on hand across all nodes

3PL Monthly Stock Ledger vs. ERP

Trade Deductions

Reclassify revenue offsets from chargebacks

Distributor Remittance Statements (UNFI, KeHE)

Landed Cost Variance

Align raw material and production bill-of-materials costs

Co-packer production logs, freight bills

Wholesale AR

Check aged retail invoices and cash applications

Accounts Receivable Aging, Retailer Portals

Build a System, End the Monthly Sigh

A successful month-end close isn’t won in the first five days of a new month—it is won by systematically capturing operational data every week.

When your inventory logs, channel settlement payouts, and distributor deductions are continuously reconciled, month-end shifts from a firefighting drill into a routine validation of business health.