MACEBOOKS JOURNAL

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.