A 13-week cash flow forecast template for CPG brands in trade cycles.

01 Two cycles running on top of one another

A CPG brand selling into retail has its operating cash cycle — receive PO, schedule the co-pack run, manufacture, ship to the retailer DC, invoice, collect on terms — and on top of that, a trade-spend cycle in which deductions and promotion funding hit on a separate schedule. The two cycles compound: when a promotion runs, the shipment goes out, the off-invoice portion lowers the net price on remittance day, the bill-back or scanback portion is taken as a deduction six to twelve weeks after the promotion ends, and the funded promotion is recognised against the trade accrual at quarter-end on the GAAP books. The cash collected from the shipment lands sixty to ninety days after ship, net of every deduction that hits between now and then. Most cash models collapse the four moving parts into one line and produce the wrong answer for the entire 13-week horizon.

The right frame: the 13-week document carries the operating-cycle math (DSO by channel applied to forecast invoices) and the trade-spend math (event-level promotion ledger, accrual roll-forward, deduction matching against accrual) as two linked sub-models inside one document. The lines on the cash summary tab show the net effect by week. The work happens on the trade-ledger tab and the AR tab underneath. If the trade ledger lives in a separate spreadsheet that only the sales team writes to — which is where most $20M to $80M brands have it today — the cash document is built on a fiction the finance team cannot see, and the quarter-end clean-up is where the surprises land.

02 The trade ledger lives inside the cash document

Every promotion gets a row. The fields that have to be there: promotion ID (YEAR-CUST-SEQ format), retailer, banner or DC, channel tag, brand and SKU set, promotion type (TPR / feature / display / off-invoice / bill-back / scanback / MCB / slotting / lump-sum / new-item fee), mechanic and depth, start and end dates on the retail calendar and the fiscal calendar, baseline volume, planned incremental volume, planned funded amount in dollars, funding basis ($/case or % of gross), accrual rate, weekly accrued amount, lifetime accrual balance, expected settlement timing rule, linked deduction IDs as they arrive, cleared amount, rejected amount, recovered amount, and open/closed status. Thirty fields on the active row is the minimum; brands at scale carry more.

The cash event is when the retailer takes the deduction against the promotion on remittance day. The template ties each deduction to its original promotion, so the cash going out is matched against the accrual the brand has been carrying on the balance sheet. Promotions without a matching deduction stay on the accrual and surface as the next quarter's cleanup; deductions without a matching promotion are leakage, by definition. The work flow is weekly — import deductions from AR, auto-match against open events by retailer + date window + mechanic description, push the unmatched pile into manual review, reduce the accrual on the matched events, flag any deduction larger than the matched accrual as an over-deduction for dispute. None of this is novel. Almost none of it is being done at brands without either a dedicated TPM platform or a deliberate in-document workflow.

The 7.4% median is not a marketing number. It is the operating-margin point recovery we have measured at the eight CPG brands $15M–$120M in revenue where we rebuilt the deduction process from scratch, on the same methodology — trade ledger inside the cash document, weekly deduction matching, monthly accrual reconciliation, formal dispute pipeline. CPGvision's independent reporting on invalid deductions costing 5–10% of trade claims aligns with the upper end of our sample. The $1.8M median annualised recovery on a $40M brand sits inside the broader industry pattern: trade spend is typically 15–25% of gross sales for grocery and mass CPG, 5–15% of that is leakage or invalid deduction in an unmanaged process, and recovery of 1–3% of net sales is achievable in the first 12–18 months of structured work.

03 Channel-level DSO is the single biggest cash variable

The remittance lag by channel is the variable that determines whether the cash document is forecasting reality or wishful thinking. Stated terms are the starting point. Effective DSO — what actually arrives, after exception handling, OTIF chargebacks, and the EDI 820 matching cycle — is the number the cash document needs. The two move together but the gap is significant, and per channel, the gap has its own shape.

Grocery channel — 4–7 weeks invoice to cash

Kroger and Albertsons sit at Net 30 to Net 45 stated; effective DSO 40–55 days for clean accounts and 55–70 days when chargebacks or exception handling enter the picture. Publix runs slightly faster on the effective side (35–50 days) because of operational cleanliness; Wegmans the same shape at the smaller end. H-E-B runs 35–55 days. None of these need to be modelled as Net 30 in the cash document — modelling them as a six-week median with a +/- two-week dispersion around it produces a more accurate forecast.

Mass channel — 8–11 weeks invoice to cash

Walmart at Net 45 historical, Net 60 for newer or smaller vendors. Effective DSO 45–70 days, and the OTIF compliance penalty regime affects net cash collected against the gross invoice. Target at Net 45 to Net 60; effective 50–75 days, with allowance-driven deductions a recurring shape. Costco (when sold as mass rather than club) runs 35–55 days effective. Mass is the channel where the gap between revenue recognition on the P&L and cash arrival in the bank is widest, and the channel where most cash forecasting errors compound the fastest.

Club, natural, drug — the wider band

Costco as club at Net 30–45 effective 35–55 days. Sam's Club at Net 45 effective 45–65 days. BJ's in the same shape as Costco club. Whole Foods direct at Net 30–45 effective 35–55. UNFI/KeHE distributor model (most common for smaller naturals) at Net 30–60 contractual, effective 40–70 days — longer than direct but operationally simpler. CVS and Walgreens at Net 60 effective 60–80 days; Rite Aid the same shape with financial-distress risk that warrants its own contingent reserve line in the cash document.

04 The deduction lag pattern that breaks single-line models

Off-invoice promotions deduct on the invoice — no separate cash event, just a lower net price on remittance day. Bill-backs and scanbacks are the cash events the model has to surface separately: the retailer issues a statement 2–4 weeks after the promotion end based on POS data, and takes the deduction on the next one to two remittances after that. Total lag from initial shipment to deduction cash event: 6–12 weeks after the promotion ends, or 8–16 weeks from the original ship date when you account for the full ship-to-promo-end window.

Lump-sum program fees, MCBs, slotting and new-item allowances are the third pattern — taken as a single deduction within one to three months of the agreed date, often on the first remittance after the agreed window opens. These are the line items that startle CFOs who have inherited a brand mid-cycle and are seeing a large deduction in week three with no obvious recent promotion attached. The promo attached is six months old and was negotiated by sales at the line-review meeting; the lump-sum fee was carried as an accrual the whole time. If the accrual is on the balance sheet, the deduction is a non-event on cash. If the accrual is not — because the in-document trade ledger is incomplete and the sales-team-only spreadsheet held the line — the deduction is a six-figure surprise.

The practical 13-week pattern by channel: for grocery, 60–70% of trade hits with the original invoice as a lower net price; 30–40% (scanbacks, bill-backs, performance funds) lands as a deduction 6–10 weeks after the event. For mass, a larger share via structured bill-backs with the 8–16 week lag from shipment. For natural via distributor, deductions are simpler in shape (the distributor consolidates) but harder to dispute (you do not own the retailer relationship). For drug, the long stated terms compound on top of the deduction lag — meaning trade activity in week one of the quarter does not affect cash inside the same quarter at all. These are the patterns the cash document has to encode.

05 Inventory cash for CPG — three cash events per co-pack run

CPG inventory cash is co-pack-dependent, and the cycle is three distinct cash events that most cash models collapse into one. The deposit goes to the co-packer when the run is booked and the unique materials are committed — 20–30% of run value for repeat business, 30–50% for new brands or custom components. The balance payment lands on completion or on shipment with Net 0 to Net 30 terms behind it. The inbound freight cash to move finished goods from the co-packer to the brand-owned warehouse or 3PL is the third event, zero to one week after completion if shipping direct. Modelling these as one line — "inventory purchase" the way the GAAP books do — destroys the cash forecast.

Lead-time benchmarks the template has to encode: shelf-stable food and beverage 4–8 weeks PO-to-FG at the brand DC, with materials and scheduling 3–6 of those weeks. Chilled or short shelf life 2–4 weeks but with stricter slot locking. Personal care 8–13 weeks total, custom packaging extending the front end. Supplements (capsules, powders, gummies) 10–15+ weeks with long-lead ingredients and strict QA stability. For food and beverage, one complete cycle fits inside the 13-week window. For personal care and supplements, deposits hit for runs that will not convert to revenue until after week 13 — meaning the template carries the deposit as a cash outflow inside the window and the corresponding revenue as a beyond-window line that needs its own monitoring.

Retailer modular resets lock the cash calendar

Major retailers run category planogram resets two to four times per year. Reset week R requires inventory at the retailer DC by R minus 2 to R minus 4. Co-pack completion is required by R minus 3 to R minus 6. Deposits land at R minus 8 to R minus 12. For brands scaling into national retail, the reset calendar locks the production calendar which locks the cash calendar — and the 13-week window inside a reset frequently shows all three production cash events without any of the corresponding revenue. This is the dominant pattern behind the cash-flow surprises that startle mid-market CPG founders in their second year of national distribution; the run economics are the cycle, not the symptom.

Working from the field, approximately 40–60% of short-term cash forecast variance in mid-market CPG brands traces to co-pack timing — runs slipping out a week, deposits accelerating because of input-cost volatility, freight repricing on the inbound move, MOQ-driven overbuilds because forecast volume moved 5%. Modelling the three cash events explicitly, with each run carrying its own deposit-week, completion-week, and freight-week input, transforms the document's usefulness. With food manufacturing PPI running 1.5–2.7% year-on-year in the trailing six months (FRED series PCU311311, latest 2026-04), input-cost volatility is moderate today — not the 8–11% pressure of 2022–2023 — but brands locked on stale 2025 contract rates still need the model rebuilt against the actual cost curve.

06 The Monday review — what gets decided

The 13-week document is updated every Monday. The week-prior actuals roll in: retailer remittances by SKU and account (cash applied, gross deductions taken, net cash collected), co-pack run progress (deposits paid, balance payments cleared, FG receipts at the warehouse), trade-promotion accrual roll-forward (new accrual, deductions matched, balance carried), and the operating-cash basics (payroll, freight, merchant fees, ad spend, debt service). The 13-week horizon rolls forward one column.

The review meeting is 45 minutes. CFO, head of sales (for the trade-promotion ledger), and head of supply chain (for the co-pack and inventory cycle). The decisions that surface: which active promotions to extend, accelerate, or kill based on the deduction velocity already coming in; where to push or pull the co-pack scheduling against the retailer reset windows; when to open a formal dispute on the largest leakage items in the unmatched-deduction pile; whether to accelerate or delay the inbound freight on the next run to land the cash event in the right week. None of these are 12-month-plan decisions. All of them move the next thirteen weeks of cash.

1. Is the trade ledger inside the cash document, or in a separate spreadsheet that only the sales team writes to and finance reconciles at quarter-end?
2. Are deductions matched against original promotions weekly, with the unmatched pile surfaced and assigned an owner — or is the matching only happening at month-end close?
3. Are co-pack deposits, completion payments, and inbound freight modelled as three separate cash events, or collapsed into one inventory-purchase line that misstates the cash by two to four weeks?
4. Is the effective DSO by channel encoded into the AR forecast — or is the model assuming Net 30 across the board and ignoring the OTIF chargebacks and EDI exception lag that move the actual cash arrival by 10–20 days?

07 When the in-document approach graduates to a TPM platform

The in-document trade ledger inside the cash workbook works up to roughly $40M to $80M in revenue, 10–30 active retail accounts, and 200 or fewer active promotions per year. Above that, the cash document still works as the cash document, but the trade ledger has to migrate to a dedicated TPM platform. The cash document continues to reference the ledger; the editing and weekly maintenance moves into the platform. Below $40M with under 200 promotions, the in-document approach is the right one — buying TPM software is premature, and the discipline of building the ledger by hand teaches the team what the platform will later automate.

Leading mid-market TPM platforms for 2025–2026: Vividly (formerly Crisp TPM) and Cresicor at the $30K–$120K annual entry point with implementation $25K–$80K; PromoMash at the lighter SMB end (often $10K–$60K/yr); Blacksmith Applications (now part of TELUS Agriculture & Consumer Goods) at the upper-mid range often above $100K/yr with implementation $75K–$300K. Adjacent tools — Repsly (retail execution), Wiser (pricing/shelf analytics), Circana/IRI and NielsenIQ (syndicated data + bundled analytics) — are not TPM replacements but complement the core ledger. The ROI case has two pieces: deduction leakage recovery (2–5 percentage-point reduction is typical and on $9M of trade spend equals ~$180K–$450K/yr) and promo ROI lift from structured pre-event modelling and post-event analysis (5–15% portfolio-level improvement, worth $450K–$1.4M on the same trade base). Payback runs 12–24 months for brands with $5M–$10M+ annual trade.

The graduation signal is rarely revenue alone. It is the combination of complexity (10+ national chains with overlapping programs), promotion volume (200+ active events with frequent overlaps), and deduction volume (enough to require a dedicated FTE managing the matching and dispute pipeline). When two of the three are present, the platform is the right call. When only one is present and the others are not, the in-document approach with one disciplined owner still wins on total cost of ownership. The mid-market M&A multiple data we publish quarterly tracks this same maturity curve: brands that have institutionalised their trade ledger — platform or document — clear at 0.5–1.0 turns of EBITDA above peers in sale processes for exactly this reason.

08 Implementation — the eight-week build

For a brand running today on a P&L-only forecast with trade spend tracked in the sales team's shared drive, the canonical implementation is eight weeks. The shape:

1. 01
   Weeks 1–2 — Structure and data: Build the workbook (summary tab, customer-receipts tab by top 10 retailers, trade-ledger tab, deductions tab, co-pack-runs tab, AP/opex tab). Define customer-level assumptions: effective DSO, deduction lag, average trade as % of net sales, leakage % by retailer. Pull the last 12 months of deductions from AR and tag by type (promo / compliance / leakage / unknown).
2. 02
   Weeks 3–4 — Trade ledger backfill: Populate the trade ledger with the trailing 12 months of promotion events even if only at summary level. Map historical deductions to events and build the lag distribution: how many weeks after event end does each deduction type hit, per retailer? This becomes the forecast assumption layer for the forward 13 weeks.
3. 03
   Weeks 5–6 — Co-pack cycle integration: For each active and scheduled co-pack run, capture deposit week, completion week, freight week, and tie each to the appropriate retailer reset or replenishment forecast. Build the three cash events explicitly so shifting a production date automatically shifts cash in the model.
4. 04
   Weeks 7–8 — Cadence and governance: Start the weekly Monday review with CFO, head of sales, head of supply chain. Run actuals-vs-forecast variance against the prior week. Adjust DSO assumptions, deduction lag patterns, and leakage estimates by retailer based on what is actually arriving. By week 8, the document is the active operating instrument; by week 12, the forecast accuracy on weeks 1–4 should be 95%+.

The companion canonical posts — the trade-spend deduction recovery playbook on the deduction-side mechanics, the co-pack vs in-house margin framework on the production-side trade-off, the DTC variant of the 13-week template for the pure-DTC subset of mid-market consumer brands — are the references the implementation team will want open in the second monitor. Engagement with our team is one path; the materials are designed to be self-serve for brands with a disciplined CFO or finance lead already in seat.