Building a 13-Week Cash Flow Forecast for Your CPG Brand

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.

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.

There is a practical reason too: if you discover a cash shortfall 10 weeks out, you still have time to act. You can adjust production schedules, negotiate payment terms, accelerate collections, or line up financing. Discover that same shortfall 2 weeks out, and your options narrow dramatically.

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. Break your receipts into these categories:

Retail collections. Map each retailer by their payment terms. If Whole Foods pays net-30 and you shipped $50K last week, that cash shows up in week 5 or 6, not this week. Use your actual AR aging to place expected collections in the right week.
Distributor collections. Distributors like UNFI and KeHE often pay on net-30 to net-45 terms, but deductions for spoilage, shortages, and promotional allowances can reduce the actual cash received by 5 to 15 percent. Forecast the net amount, not the gross invoice.
DTC and e-commerce receipts. These are your fastest-converting cash — typically settled within 2 to 5 business days. Forecast based on trailing weekly averages, adjusted for any planned promotions or ad spend changes.
Amazon receipts. Amazon pays on a 14-day cycle with its own reserve holdback. Treat it as its own line item because the timing is unique.
Other income. Include any expected refunds, insurance proceeds, or grant disbursements, but only if you have high confidence in both the amount and timing.

Cash Disbursements

This is usually the longer and more detailed section. For CPG brands, the major outflows include:

Ingredient and 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 ingredient payment likely hits in week 2 or 3 depending on your supplier terms.
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. Map the actual payment milestones.
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. Place them in the week you expect the deduction or payment to hit — which is often different from the promotional period.
Payroll and benefits. The most predictable line item. Match to your actual payroll schedule — biweekly, semi-monthly, or whatever your cadence is.
Marketing and advertising. Digital ad spend, influencer payments, content creation, agency fees. Many of these are billed weekly or monthly and are controllable levers if cash gets tight.
Rent, insurance, and fixed overhead. Monthly recurring costs placed in the appropriate week.
Debt service. Loan payments, line of credit interest, or merchant cash advance payments.
Taxes and regulatory. Estimated tax payments, state registrations, and any compliance-related fees.

Net Cash Flow and Ending Balance

Each week: Starting Balance + Total Receipts - Total Disbursements = Ending Balance. The ending balance of one week becomes the starting balance of the next. This waterfall structure gives you a clear view of when cash gets tight and how tight it gets.

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.

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. The forecast gives you the data to have these conversations proactively.

Negotiate with Leverage

When you can show a supplier your 13-week forecast and demonstrate exactly when you can pay, you negotiate from credibility. Saying "we need to push payment by two weeks" backed by a detailed cash flow model is very different from saying "we cannot pay you right now."

The Weekly Update Cadence

The forecast is only useful if it is current. Here is the cadence that works:

Monday morning: Update the current week with actuals — what actually came in and went out. Replace the completed week with the actual numbers and 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.

This process should take 30 to 60 minutes per week once the model is built. If it is taking longer than that, your model is too complex or you do not have clean enough data feeds from your accounting system.

Common Pitfalls to Avoid

Forecasting Revenue Instead of Cash

This is the most common mistake. Your P&L says you did $80K in revenue this month, but how much of that is actually in your bank account? If your largest retailer pays net-60, a big chunk of that revenue is still sitting in accounts receivable. The 13-week forecast must be built on cash timing, not revenue recognition.

Ignoring Distributor Deductions

If you forecast $100K in distributor collections but actually receive $88K after deductions for spoils, shortages, and promotional allowances, your forecast is $12K off every single cycle. Use your historical net collection rate, not your gross invoice amount.

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.

Not Connecting It to Decisions

A forecast that sits in a spreadsheet and gets updated weekly but never drives a decision is a waste of time. Every weekly review should end with at least one actionable takeaway: a payment to defer, a collection to accelerate, or a confirmation that the plan is on track.

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. The first version will not be perfect — and it does not need to be. A directionally accurate forecast that gets updated weekly is infinitely more valuable than a perfect model that takes three months to build.

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.