Resources/CPG Finance 101/
Cash Flow Forecasting for CPG Brands: The 13-Week View, Inventory, and Retailer Timing
Cash Flow & Runway Management

Cash Flow Forecasting for CPG Brands: The 13-Week View, Inventory, and Retailer Timing

A direct, weekly cash forecast built around the three things that break consumer brand cash: lumpy inventory payments, slow retailer and distributor remittances, and growth.

9 min read
Updated October 2026

Quick answer

Cash flow forecasting for a CPG brand projects weekly cash receipts and disbursements, typically over 13 weeks, built from actual receivables, payables, and purchase order schedules in the near term and the demand forecast run through per-channel payment terms after that. It exists because inventory is paid for months before it sells and retailer payments arrive late and short, so a profitable P&L can still run out of cash.

Cash flow forecasting for a CPG brand is the practice of projecting, week by week, when cash actually arrives and leaves: Shopify payouts and Amazon settlements on one side, co-manufacturer deposits, ad spend, payroll, and retailer invoices that pay net 60 minus deductions on the other. It is a different exercise from the P&L forecast, because in consumer goods the gap between booking revenue and banking it can run months, and inventory has to be paid for before any of it. This guide walks through the 13-week cash flow (the tool most brands should use), why inventory is the cash sink, how retailer and distributor timing works, how to track burn and runway, and what to require from software.

Why the P&L forecast is not a cash forecast

Your P&L recognizes revenue when a retailer accepts the shipment and COGS when the unit sells. Cash does neither of those things on those dates. The co-manufacturer wanted half the money when you placed the purchase order and the rest before the truck left. The retailer will pay in 45 to 75 days, short-paid for promotions and chargebacks. Meanwhile ad spend bills daily and payroll runs every two weeks regardless. A brand with a healthy EBITDA line can still miss payroll, and the P&L will never show you the week it happens. Only a direct cash forecast does.

The 13-week cash flow

Thirteen weeks is one quarter, which is far enough to see the next production run and the next retailer payment, and short enough that the numbers are real rather than aspirational. The structure is simple:

  1. Opening cash for the week, by bank account.
  2. Receipts: DTC payouts, Amazon settlements, retailer and distributor remittances by customer, financing draws.
  3. Disbursements: inventory and packaging (deposits and balances, by PO), freight, 3PL and fulfillment, marketing, payroll, rent and software, taxes, debt service.
  4. Net cash flow = receipts minus disbursements.
  5. Ending cash = opening cash plus net cash flow, which becomes next week's opening.

Weeks one through four should be built from known items: the AR aging, the AP ledger, scheduled POs, the payroll calendar. Weeks five through thirteen come from the demand forecast run through your channel terms. Every week, you roll it: actuals replace the forecast for the week just closed, a new week is added at the end, and the variances tell you which assumptions were wrong. A 13-week cash flow template built for consumer brands gives you the layout; the hard part is feeding it with the right timing assumptions, which the rest of this guide covers.

A worked example

Consider a fictional sparkling tea brand we will call Harborline Beverage, selling on Shopify, Amazon, and into two regional grocery chains. Opening cash: $600K. Over the next 13 weeks the forecast looks like this.

Receipts. DTC payouts of about $45K per week ($585K over the quarter). Six Amazon settlements of roughly $70K each ($420K). Two grocery invoices, $140K and $120K, both shipped in the prior quarter on net 60 terms, expected in weeks 3 and 7, each landing about 4% light after deductions ($250K collected). Total receipts: about $1,255K.

Disbursements. A $320K production run: 50% deposit in week 2, balance in week 7 when it ships. A $150K deposit on the following run in week 11. Marketing at $35K per week ($455K). Seven payroll runs at $60K ($420K). Rent, software, 3PL, and freight at about $20K per week ($260K). Total disbursements: about $1,605K.

Net cash flow: roughly negative $350K. Ending cash around $250K. The headline is bad enough, but the quarter does not move in a straight line either. In week 7 the $160K production balance is due in the same week the second grocery invoice is expected, and the model shows cash at about $430K if the grocer pays on time. If the grocer pays two weeks late, which is common, the week 7 balance is closer to $310K with a payroll run inside it. That is the conversation the 13-week view exists to start, eight weeks before it happens.

Inventory is the cash sink

In Harborline's quarter, inventory payments were $470K against $1,605K of total outflows, and they arrived in three lumps rather than a smooth line. That is normal. Three features of CPG inventory make it the dominant cash problem:

  • You pay before you sell. Minimum order quantities, co-manufacturer deposits, and 8 to 16 week lead times on packaging or imported ingredients mean cash leaves two to four months before a unit reaches a customer.
  • It lands in lumps. A production run is one or two large payments, not a weekly expense. Smooth monthly P&L COGS hides this completely.
  • Growth makes it worse before better. Each step up in demand requires a larger buy, funded from cash generated by the smaller previous buy. A brand growing 60% a year is almost always cash-negative on inventory even when profitable.

The practical fix is to treat every purchase order as a dated cash event in the forecast, not just a quantity in the inventory system. An open-to-buy view of PO cash commitments does this: it lays the deposit and balance for each PO on the weeks they are due, so you can see whether splitting a run, delaying a reorder on a slow SKU, or negotiating terms with the co-manufacturer changes the trough. Weeks of supply by SKU (units on hand divided by forecast weekly units) tells you which POs are actually necessary.

Retailer and distributor timing

Channel mix is the second biggest driver of a CPG cash forecast, because each channel pays on a different clock.

  • Shopify and other DTC. Payouts typically arrive within a few business days of the order. Subscriptions via Recharge are the most predictable cash in the business.
  • Amazon. Settlements run roughly every two weeks, net of referral fees, FBA fees, advertising, and any reserve Amazon holds. Model the settlement date and the net amount, not gross sales.
  • Retail. Terms are negotiated and vary by account, with net 30 to net 60 common and longer at some large accounts. The remittance is reduced by deductions: promotional allowances, damages, freight, and compliance chargebacks. Forecast each account at expected payment date and expected net amount.
  • Distributors (UNFI, KeHE). Payment follows the distributor's contracted terms, and the distributor takes its margin, off-invoice promotions, and various program fees before remitting. Gross-to-net on a distributor invoice can be 15% to 30% or more depending on the promo calendar, so model the net.

A brand shifting from 80% DTC to 50% DTC will see its average days to collect roughly double even if nothing else changes. That is why retail launches, which look like pure upside on the P&L, so often cause the cash crunch. The retail launch financial model guide works through one in detail.

Burn rate and runway

Two formulas, both from the 13-week view rather than the P&L:

  • Net burn = total cash out minus total cash in over a period. Harborline's is about $350K per quarter, or roughly $117K per month.
  • Runway = current cash / monthly net burn. At $250K projected ending cash and $117K monthly burn, Harborline exits the quarter with about 2.1 months of runway.

Two cautions. First, burn in a CPG brand is lumpy, so a single month can show positive cash flow (a big retailer paid, no production run) and flatter you into a bad decision; use a trailing quarter. Second, runway assumes burn stays constant, and growth usually increases it through bigger inventory buys. The honest version is a 26 or 52 week extension of the forecast with the inventory plan included. For Harborline, two months of runway at quarter end, with the next production run already half committed, means the decision is now: slow the reorder, push the grocer for shorter terms, open an inventory line, or raise. Any of those is fine. Finding out in week 12 is not.

Cash flow management for DTC and ecommerce brands

Pure DTC brands often skip cash forecasting because collections are fast and the bank balance looks like truth. The traps are different but real: ad spend that scales faster than payouts, Amazon reserves that hold cash during peak, FBA storage and long-term storage fees on slow SKUs, and the Q4 inventory build that has to be paid for in August and September when sales are softest. The same 13-week structure works. The channel terms are just simpler, which means more of the forecast risk sits in the demand plan and the purchase orders.

What cash flow forecasting software should do

Spreadsheets can run a 13-week cash flow. What they struggle with is staying connected: the AR aging changes daily, the PO schedule lives in another system, and the demand forecast that drives weeks five through thirteen lives in a third. Whatever tool you use should:

  • Pull actual receipts and disbursements from the bank and accounting system weekly, so rolling the forecast is a review rather than a rebuild.
  • Drive future receipts from the same demand forecast as the P&L, run through per-channel terms and deduction rates.
  • Treat POs as dated cash commitments with deposit and balance schedules.
  • Produce the P&L, balance sheet, and cash flow from one set of assumptions, so inventory on the balance sheet, COGS on the P&L, and the co-manufacturer payment in the cash flow agree.
  • Run scenarios on timing: retailer pays late, production run splits, ad spend cut 20%, launch slips a month.
  • Show burn and runway on a trailing basis with the forecast extension.

If a tool does the 13-week view but not the inventory and channel modeling behind it, you will end up typing the hard numbers in by hand, and the forecast will be stale by the time you present it.

Where Drivepoint fits

Drivepoint is the AI finance platform for consumer brands. It connects Shopify, Amazon, QuickBooks, NetSuite, Recharge, and WMS and 3PL systems through 100+ integrations, then drives a forecast of the full P&L, balance sheet, and cash flow in Excel from one set of assumptions. Purchase orders, channel payment terms, deductions, and inventory by SKU all flow into the same weekly cash view, and what-if scenarios on timing run in minutes rather than days. Laundry Sauce runs at 98% forecast accuracy on it. Pricing is published starting at $449 per month, and the 13-week cash flow template is the quickest way to see the structure before a demo.

Frequently asked

Questions, answered

How often should a CPG brand update its cash flow forecast?

Weekly. Roll the 13-week forecast every week: replace the closed week with actuals, add a new week at the end, and review the variances. Receivables, purchase order timing, and retailer payment behavior change too fast for a monthly cadence, and most cash problems in consumer brands build over four to eight weeks, which a weekly review catches with time to act.

Why does a profitable consumer brand run out of cash?

Because profit is recognized when goods ship and cash moves on different dates. Inventory is paid for two to four months before it sells, in large lumps. Retailers pay in 30 to 60 days or more, net of deductions. Growth requires bigger inventory buys funded by the smaller previous ones. Each of these widens the gap between booked revenue and banked cash, and the P&L shows none of it.

How do I forecast retailer payments and deductions?

Forecast each account separately at its contracted terms, then apply an expected deduction rate based on history for promotions, damages, freight, and compliance chargebacks. Book the receipt on the expected payment date, not the invoice date, and consider adding a lateness buffer for accounts that habitually pay slow. For distributors like UNFI and KeHE, start from gross invoice and net out their margin and program fees to reach the expected remittance.

What is a reasonable cash runway for a consumer brand?

It depends on growth plans and funding access, but most operators want to see at least six months of runway at the forecast burn, including the inventory builds in the plan. Calculate it from a trailing quarter of net burn rather than a single month, because CPG cash flow is lumpy. If runway is under four months, the forecast should already contain the decision that fixes it: slower reorders, shorter terms, financing, or a raise.

Can I run a 13-week cash flow in a spreadsheet?

Yes, and many brands start there. The difficulty is keeping it connected: receivables, payables, purchase orders, and the demand forecast all live in other systems, so the spreadsheet goes stale between updates. If you stay in a spreadsheet, build it so that the demand forecast drives receipts and purchase orders drive disbursements, and set a fixed weekly time to refresh actuals. Software mainly automates that refresh and the scenario work.

How should DTC brands think about cash flow differently?

Collections are fast, so the forecast risk shifts almost entirely to spending: ad budgets that scale ahead of payouts, Amazon reserves and storage fees during peak, and the Q4 inventory build paid for in late summer. The same 13-week structure applies, with simpler receipt timing and more attention on purchase order schedules, marketing pacing, and weeks of supply by SKU.

See what Drivepoint
looks like for your brand.

Book a demo and see how quickly Drivepoint gets your complete financial model up and running — connected to your data, built for your channels, ready for your next big decision. Whether you're planning a retail launch, preparing for a raise, or replacing a spreadsheet that only one person can touch.

Book a demo