Skip to content

Cash Flow Management for CPG and Consumer Product Companies

By Newtown Analytics · · 8 min read

For ops, supply chain & planning leaders

Cash flow management for CPG companies is shaped by three things: retailers that pay on terms and take deductions, trade spending that reduces what you collect, and manufacturing that requires money well before products reach shelves. Revenue can grow quickly while cash gets tighter, because each new retailer adds receivables, inventory and promotional funding before it adds cash. This guide explains where the cash goes in a consumer products business, walks through a working capital example for a growing brand and sets out practices for forecasting, promotions, terms and financing. It extends cash flow management and draws on working capital.

Where the cash goes

AreaCash effectTiming
Co-manufacturer or plantDeposits, minimum run costs, packaging and ingredient purchasesWeeks or months before sale
FreightInbound, outbound and warehouseAround production and shipment
Retailer termsReceivables outstanding until the retailer pays30 to 60 days or more after delivery
Trade spendPromotions, allowances, scan-based discounts, off-invoice deductionsDeducted at invoice or paid later
Slotting and listing feesOne-time costs to get on shelfBefore first sale
Deductions and chargebacksShort-pays for compliance, shortages, damages and disputed promotionsAfter delivery, often weeks later
Marketing and samplingDemos, digital, in-storeBefore and during promotions
Returns, spoilage and obsolescenceWrite-offs and creditsAfter sale or at end of shelf life

Retail terms and deductions sit at the center. Net sales, after trade spend and deductions, are lower than invoiced sales, and cash is lower still because of the payment delay.

A working capital example

A hypothetical brand has $6,800,000 of net sales (after trade spend) and cost of goods sold of $4,080,000 (60 percent of net sales). Its days are DSO of 52 (retailers pay in about 45 days, and deductions add delay), DIO of 70 and DPO of 25.

ComponentCalculationAmount
Receivables$6,800,000 / 365 × 52$968,767
Inventory$4,080,000 / 365 × 70$782,466
Payables$4,080,000 / 365 × 25-$279,452
Net working capital$1,471,781

Net working capital is about 21.6 percent of net sales. The cash conversion cycle is 52 + 70 - 25 = 97 days. See the cash conversion cycle.

What growth costs

If net sales grow 25 percent and days stay the same, working capital rises by about 25 percent: 0.25 × $1,471,781 = $367,945. Add the one-time costs of getting into new retailers (slotting, samples, launch promotions). If the brand pays $60,000 in fees and funds $90,000 of introductory promotions, the cash needed before the first profit is roughly $517,945 ($367,945 + $60,000 + $90,000). A brand that budgets only for production may find itself short.

The value of days

Daily net sales are $6,800,000 / 365 = $18,630, and daily COGS is $4,080,000 / 365 = $11,178. A five-day reduction in DSO releases about $93,150; a ten-day reduction in DIO releases about $111,780; a five-day increase in DPO releases about $55,890. The three together would release about $260,820. See working capital optimization.

Retailer terms and deductions

Terms

Retailers often set payment terms and may extend them. Each extra 30 days on $6,800,000 of annual sales costs about $558,904 of additional receivables ($6,800,000 / 365 × 30). Compare that with the cost of capital and the margin earned, and understand your right to negotiate. See net 30 vs. net 60.

Deductions

Short-pays for promotions, shortages, damages and compliance fines can be a large and unpredictable drain. Manage them by:

  1. Recording every promotion and its funding terms.
  2. Matching deductions to promotions, purchase orders and shipping records.
  3. Disputing invalid deductions quickly, before time limits expire.
  4. Tracking deduction rate by retailer and cause.
  5. Reserving for expected deductions in the cash forecast, based on history.

If a retailer's deductions average 3 percent of invoiced sales and take 60 days to resolve, the brand carries those amounts as receivables of uncertain value. Measure deduction aging separately in the aging report. See the accounts receivable aging report.

Trade spend and promotion cash

Trade promotions affect cash in two ways: they reduce net revenue, and they often increase inventory and receivables as shipments surge.

Example: a four-week promotion at one retailer expects a 40 percent lift in volume over a baseline of 10,000 cases per month. The extra 4,000 cases at a cost of $14 per case require $56,000 of production, which is paid before the shipments, while the retailer pays 45 days after delivery, and the promotion's funding (a $2 per case discount on 14,000 cases = $28,000) is deducted at invoice or claimed later. If the lift is lower than expected, the brand is left with excess inventory and the cost of the discount. Plan promotions with realistic lifts, tie production to confirmed orders where possible and track post-promotion sell-through. A strong demand plan improves these decisions. See demand planning and inventory optimization.

When a retailer pays late

A late payment is a working capital loan you did not choose to make. Suppose a retailer buys $400,000 a month, which is about $13,333 a day. If it pays 15 days later than usual, receivables rise by roughly $200,000 ($13,333 × 15). For a brand with a few such accounts, a slip in one can empty the cash cushion. Include late-payment scenarios in the forecast and track days to pay by retailer, not only the overall DSO.

Co-manufacturer and supplier terms

If you use co-manufacturers, understand:

  • Deposit requirements and when they convert to payments
  • Minimum run sizes that force larger inventory than demand requires
  • Lead times for ingredients and packaging that drive safety stock
  • Payment terms and early-pay discounts
  • Capacity commitments that carry costs if unused

Negotiate where you can, and compare the cost of larger runs with the cost of carrying the extra stock. See how to negotiate better supplier payment terms.

Shelf life and obsolescence

Consumer products with limited shelf life turn inventory from an asset into a liability quickly. Track age by lot, set rules for retailer acceptance windows and plan markdowns and donations before the product is close to expiry. A unit that expires has already consumed cash for ingredients, production and storage.

Forecasting cash in a CPG business

Build a 13-week forecast and a 12-month projection from the demand plan.

LineDriver
Retailer receiptsShipments by retailer, terms and observed days to pay, less expected deductions
Direct and ecommerce receiptsOrders and payout lag
Production and ingredient paymentsProduction schedule and supplier terms
Freight and warehousingShipments and storage
Trade and marketing paymentsPromotion calendar and payment timing
Slotting and listing feesRetailer onboarding schedule
Payroll and overheadHeadcount plan

Reconcile the first weeks to open orders and the receivables aging, and the later weeks to the promotion and production calendar. See the 13-week cash flow forecast and how to build a cash flow forecast you will actually use. Run a downside with a promotion that underperforms and a retailer that pays 15 days late. See cash flow scenario planning.

Financing options

NeedPossible tools
Seasonal and growth working capitalRevolving line of credit or asset-based facility. See asset-based lending
Inventory buildInventory financing. See inventory financing
Faster cash on retailer receivablesInvoice financing or factoring. See invoice factoring vs. invoice financing
Supplier supportLonger terms or supply chain programs. See supply chain finance
Marketing-led growthRevenue-based financing. See revenue-based financing

Lenders will review your receivables quality, deductions history, inventory age and forecast accuracy. See how lenders evaluate your cash flow and working capital.

Metrics to track

  • Net revenue per case after trade, and trade spend as a percent of gross sales
  • Deduction rate, aging and recovery rate
  • DSO by retailer
  • DIO by item, and inventory age against shelf life
  • Promotion return: incremental volume and cash margin versus cost
  • Cash conversion cycle
  • Forecast accuracy and bias by item and retailer. See how to measure and improve cash forecast accuracy

Common mistakes

  • Ignoring deductions in the cash forecast.
  • Planning production on the optimistic promotion lift.
  • Taking on retailers without funding their working capital.
  • Accepting extended terms without pricing the cost.
  • Holding too much stock near expiry.
  • Failing to align sales, supply and finance.
  • Using one margin number for all retailers instead of net of trade and terms.

A 90-day plan for a growing brand

  1. Weeks 1 to 2: build the receivables aging by retailer, including deductions, and a 13-week forecast.
  2. Weeks 3 to 4: calculate the cash conversion cycle and the working capital needed for the next growth step.
  3. Weeks 5 to 8: set up the deduction process, review terms with key retailers and test promotion plans against realistic lifts.
  4. Weeks 9 to 12: agree production and ingredient schedules with the demand plan, set an inventory age policy and arrange any financing before it is needed.

For online selling, see cash flow management for ecommerce brands. For retail businesses that buy and sell goods in stores, see cash flow management for retailers and for manufacturers, see cash flow management for manufacturers.

FAQs

Why do CPG companies run short of cash while growing?

Each new retailer adds inventory, receivables and promotional costs before cash arrives, and deductions and trade spend reduce what is collected.

How do trade spend and deductions affect cash flow?

They reduce net sales and delay or reduce collections. Track them by retailer and promotion, and reserve for them in your forecast.

How much working capital does a CPG brand need?

It depends on days of receivables, inventory and payables. In the example, about 22 percent of net sales. Calculate your own from your cycle. See how much working capital your business needs.

How can a CPG brand improve cash flow?

Improve forecast accuracy, resolve deductions faster, negotiate terms, reduce excess inventory, plan promotions realistically and arrange suitable financing before growth requires it.

Does demand planning affect cash?

Yes. Forecast accuracy and planning determine inventory levels, production timing and purchases, which are among the biggest drivers of cash in a product business.

This article is for general information. It is not accounting, tax, legal or investment advice, and examples use illustrative numbers rather than client data. Confirm decisions that carry financial or legal consequences with a qualified professional.

Better forecasts. Healthier inventory. More working capital.

Newtown Analytics advises growing consumer-product companies on demand planning and inventory optimization.