If there is one financial tool that every CPG founder should have and most do not, it is the 13-week cash flow forecast. Not a P&L projection. Not an annual budget. A week-by-week view of exactly how much cash is coming in, how much is going out, and what your bank balance will look like every Friday for the next quarter.
This is the tool that prevents the 2 AM panic when you realize you cannot cover payroll next week. It is the tool that lets you negotiate with suppliers from a position of knowledge instead of desperation. And it is the tool that investors and lenders expect to see when you ask for capital.
Why 13 Weeks
Thirteen weeks is one fiscal quarter — long enough to see around corners, short enough to forecast with reasonable accuracy. Beyond 13 weeks, CPG cash flows become too uncertain because of retailer order variability, promotional timing, and ingredient cost fluctuations. Shorter than 13 weeks, and you do not have enough visibility to make proactive decisions.
Why the 13-Week Window Works
The 13-week window also aligns with how most CPG businesses experience cash flow cycles. A major retailer launch, a seasonal promotion, a co-manufacturing run — these events typically play out over 8 to 12 weeks from commitment to cash collection. Thirteen weeks captures the full cycle.
Early Warning = More Options
How to Structure the Forecast
The 13-week cash flow forecast follows a simple structure — but the devil is in the CPG-specific details. Here is the framework.
Starting Cash Balance: Begin each week with your actual bank balance. Not your accounting cash balance — your real, available bank balance net of any holds, pending transactions, or restricted funds. This is your ground truth, and everything else flows from it.
Cash Receipts: This is where CPG gets complicated. Unlike a subscription business with predictable monthly receipts, CPG cash inflows are lumpy and channel-dependent.
Cash Receipts by Channel
Watch Distributor Deductions
Cash Disbursements: This is usually the longer and more detailed section. For CPG brands, the major outflows include:
Ingredient & raw material purchases
Map these to your production schedule. If you are placing a co-man order in week 3 that requires ingredients to ship in week 2, the payment likely hits in week 2 or 3.
Co-manufacturer payments
Co-mans typically require a deposit at order placement and a balance on shipment. A $100K production run might mean $30K out in week 1 and $70K out in week 5.
Packaging and labeling
Often ordered separately from the co-man with their own lead times and payment terms.
Freight and logistics
Inbound freight to your warehouse, outbound freight to retailers, and 3PL storage and fulfillment fees. These are recurring and often underestimated.
Trade spend and promotional costs
Slotting fees, promotional allowances, demo costs, and retailer marketing programs. These are some of the largest and most unpredictable cash outflows in CPG.
Payroll and benefits
The most predictable line item. Match to your actual payroll schedule.
Marketing and advertising
Digital ad spend, influencer payments, content creation, agency fees. Many are controllable levers if cash gets tight.
Fixed overhead, debt service, and taxes
Rent, insurance, SaaS, loan payments, line of credit interest, estimated tax payments, and compliance-related fees.
Net Cash Flow Formula
Using the Forecast for Decision-Making
A 13-week forecast is not a report you build and file away. It is a decision-making tool. Here is how to use it:
Identify the Cash Floor. Look across all 13 weeks and find your lowest projected bank balance. That is your cash floor. If it dips below your minimum operating threshold — typically 4 to 6 weeks of fixed costs — you have a problem to solve, and you have the lead time to solve it.
Cash Floor Safety Thresholds
Scenario Planning. Build at least two versions: a base case using your best estimates, and a downside case where collections slip by two weeks and a major customer order falls through. If the downside case shows a cash shortfall, you need a contingency plan before you need the cash.
Time Your Big Expenditures. If you see a strong cash position in weeks 6 through 8, that might be the right window to place your next co-man run. If weeks 3 through 5 look tight, you might negotiate with your co-man to push the deposit by a week.
Negotiate with Leverage
The Weekly Update Cadence
The forecast is only useful if it is current. Here is the cadence that works:
Monday morning: update with actuals
Replace the completed week with actual numbers — what actually came in and went out. Add a new week 13 at the end.
Review variances
Compare what you forecasted for the prior week against what actually happened. Were collections late? Did a supplier invoice hit earlier than expected? Track your accuracy.
Roll forward
Adjust the remaining 12 weeks based on any new information — a confirmed retailer PO, a price increase from a supplier, a delayed shipment.
Flag risks
Highlight any week where the ending balance drops below your minimum threshold. Communicate these to your leadership team or investors before they become crises.
Weekly Time Investment
Common Pitfalls to Avoid
Forecasting Revenue Instead of Cash
The Distributor Deduction Trap
Forgetting seasonal patterns. CPG cash flows are seasonal. Retail orders spike before holidays and summer, but so do ingredient costs and freight rates. Trade spend tends to concentrate in Q1 and Q4. Make sure your forecast reflects the seasonality of both inflows and outflows.
Being too optimistic on timing. If a retailer's terms are net-30, forecast collection in week 5 or 6, not week 4. Payments are almost never early and frequently late. Build in a buffer of 3 to 5 days on collections and assume disbursements hit on time or early.
Every Weekly Review Needs an Action Item
Getting Started
You do not need fancy software to build a 13-week cash flow forecast. A well-structured spreadsheet works for most brands under $10M in revenue. Start with your bank balance, list your known commitments and expected collections, and build from there.
Start Imperfect, Improve Weekly
The brands that manage cash proactively survive downturns, negotiate better terms, and raise capital from a position of strength. The ones that do not are perpetually two bad weeks away from a crisis. The 13-week forecast is how you stay on the right side of that divide.