A 13-week cash flow forecast template for $20M+ DTC brands.

01 Why 13 weeks, weekly, not 12 months

Twelve months is a planning horizon. Thirteen weeks is an operating horizon. The DTC working-capital cycle — deposit on a purchase order through receipt of goods through sell-through through processor payout — fits inside the 13-week window for almost every brand under $150M with overseas supply chains. Modelling at this cadence forces the founder to face the decisions that the 12-month view smooths over: the deposit cliff sitting in week 7, the freight invoice landing in week 9, the BFCM cash collection that does not actually hit until week 12, and the payroll plus quarterly sales-tax payment that both fall in week 11.

The accounting conventions that govern the annual budget — accrual revenue, GAAP cost-of-goods recognition — actively obscure the cash story. Revenue books when an order ships; cash arrives when Shopify or Stripe settles, two to seven days later. Inventory hits the P&L when sold; cash hits the bank as a 30% deposit twelve weeks before goods arrive and a 70% balance four weeks before they are saleable. The 13-week unwinds every one of those accruals back to a cash event. McCracken Alliance, JP Morgan, and Abacum all converge on the same point in their guidance: the opening cash balance must come from the bank, not the GL, and inflows must tie to actual receipts — processor payouts, AR invoices on real due dates — rather than booked revenue.

The macro backdrop matters for sequencing. The FRED ECOMSA series shows US ecommerce sales at $326.7B in Q1 2026 — up 9.8% year-over-year — while the PPI for transportation services has re-accelerated to 188.5 in April 2026, up 10.2% from January 2025. Topline growth and freight inflation are running in parallel, which means the inbound cash cliff is widening as fast as the receivable side is. For brands importing from Asia on 30/70 terms, every dollar of freight inflation hits cash 35 to 75 days before it hits the P&L. Our companion piece on the broader DTC working-capital read for Q2 2026 sits at /blog/dtc-working-capital-q2-2026/.

02 The 18 lines that actually matter

Most templates I inherit from prior CFOs run 60-plus lines. Ours runs 18. The discipline of eighteen lines is the work: anything more is theatre, anything less misses an event class. The line set has been stable across engagements for three years and survives every revenue tier from $20M to $150M without modification.

The eighteen lines are: (1) beginning cash, (2) DTC processor payouts net of fees, (3) marketplace payouts (Amazon, Walmart, TikTok Shop), (4) wholesale and retail AR collections, (5) refunds and chargebacks as a contra-cash outflow, (6) inventory deposits (PO trigger), (7) inventory balances on shipment, (8) freight and duties, (9) 3PL and fulfilment fees, (10) paid media by platform card statement, (11) payroll and contractors, (12) rent, utilities, and SaaS, (13) credit-card and lender debt service, (14) sales, payroll, and income tax payments, (15) capex, (16) other operating, (17) financing inflows (revolver draw, equity, debt) and outflows (principal repayment), (18) ending cash and available liquidity.

Two structural choices in that list deserve naming. First, refunds sit as a contra-cash outflow on line 5, not netted against line 2. The Shopify Payments and Stripe payout reports already net refunds against gross; the temptation is to import them that way and skip the explicit line. Resist it. The refund cash event is the single best leading indicator we have of category-level demand health in the next four weeks. Brands with apparel return rates running 28-30% typically see a week-over-week change in the refund line that precedes a week-over-week change in net sales by ten to fourteen days. Hiding it in a netted payout line loses the signal.

Second, inventory takes two lines, not one. Most P&L-driven cash models collapse "inventory spend" into a single monthly average divided by four, which smooths the deposit cliff and freight event into a flat line that bears no relation to the actual bank-debit pattern. McCracken explicitly warns against this in their published 13-week guide. Lines 6 and 7 — deposits at PO release and balances at ex-factory — break that smoothing apart and make the deposit-to-receipt timing visible to the founder. The third inventory event, freight and duties, sits on line 8 because freight invoices arrive on a different cadence (typically on or near vessel arrival) and from a different vendor counterparty than the supplier balance.

03 The inventory cadence — where most models break

The single line that breaks most DTC cash models is inventory. The supplier deposit (30% of PO value on standard terms) goes out at PO confirmation; the balance (70%) clears on ex-factory which is typically 30-55 days later; the goods then sit on the water for 18-27 days West Coast or 28-44 days East Coast (ExFreight 2025-26 benchmarks); customs clearance, drayage, and 3PL receiving add another 7-14 days; and the saleable inventory only then begins converting to cash over the following 45-day sell-through window, with processor payout adding T+2 to T+7. The model has to handle deposits separately from balances, balances separately from freight, freight separately from saleable inventory, and saleable inventory separately from the receipt of cash. Most models collapse some subset of those four events into one and produce the wrong answer at exactly the point in the cycle where it matters most.

A worked example. A $40M apparel brand on a $1.5M PO with a Chinese supplier under standard 30/70 terms with West Coast routing. Day 0, the 30% deposit of $450K leaves the bank. Day 35, the balance of $1.05M clears as production finishes and goods ship. Day 64, the vessel arrives Los Angeles or Long Beach; the freight invoice — call it $48K all-in — clears within seven days. Day 74, the inventory is saleable in the 3PL. Day 74 through Day 119, sell-through generates roughly $4.2M in gross retail revenue at the brand's typical sell-through curve; refunds run 28% of gross at sub-category, and Shopify Payments settles net on T+2. The first dollar of cash on this PO arrives at Day 76 — 76 days after the deposit went out. One hundred percent of COGS was paid by Day 35. The cash gap is real and it is the single largest source of revolver utilisation in growing DTC brands.

The Freightos Baltic Index reading for the week of December 21 2025 had Asia-to-US West Coast container rates at $2,127 per FEU and East Coast at $3,069 per FEU — both back near pre-COVID levels after the 2024-25 normalisation. The Freightos 2025-26 forecast points to continued oversupply from new fleet capacity holding rates lower year-over-year, but the FRED PPI series I cited earlier shows transportation services up 10.2% over fifteen months. The combination is operationally interesting: ocean container rates have stabilised but inland freight, drayage, and last-mile inflation has not. The total landed cost line — not just the FEU rate — is what matters in the 13-week. Our SKU-profitability and landed-cost piece at /blog/sku-profitability-dtc-landed-cost/ walks the math from PO to per-unit contribution.

04 Returns, refunds, and the line that lies

Returns and refunds belong as a contra-cash line, not a contra-revenue line. The accounting team books contra-revenue inside the period the return is processed; the bank sees cash leave on the next payout cycle. Two different events on two different timelines, and the 13-week tracks both.

Shopify Payments processes a refund through a 2-business-day pending window, then the merchant cash impact lands in the next payout — T+2 to T+3 from initiation. If the brand's Shopify Payments balance is insufficient (common during low-volume weeks or after large refund batches), Shopify directly debits the merchant's linked bank account within roughly 2 business days. Stripe runs the same shape: balance reduced immediately on initiation, next payout reduced by the refund amount, bank impact 1-3 business days. The Stripe processing fee on the original transaction does not refund — a pure economic leak in high-refund-rate categories. Customer-facing timing (5-10 business days to appear on the card statement) is irrelevant to the operator's cash model; the merchant cash is gone within five business days regardless.

Return rates by category drive the size of this line. Across engagements: apparel and fashion 25-35%, women's fashion clustering 28-30%+ and BFCM peaks above 40%; footwear 25-40% depending on sneaker and boot mix; beauty and personal care 5-12%; electronics and wearables 10-18%; supplements 3-7%; pet food 3-5%; subscriptions 1-4%. Loop Returns, Narvar, and Optoro 2024-25 client data all converge on similar ranges, with the directional caveat that fashion-heavy DTC brands have moved structurally higher since the post-pandemic try-at-home behaviour normalised. Brands with 28-35% category return rates run cash positions that are 8-18% different from what their P&L forecasts suggest.

Two operating heuristics fall out of this. First, the refund line is the single best early warning we have for net sales softness — when refunds rise 10%+ week-over-week without a corresponding promotional event, net sales follow within two weeks. Second, the cost of the return itself — reverse logistics, restocking, write-down — runs 20-65% of original retail per Optoro's research. That is a separate event from the refund itself and lives in the monthly P&L, not the 13-week. The cash document handles the cash event; the monthly handles the economic event. Our deeper piece on the returns reserve — the single most-mismodelled line in DTC finance — sits at /blog/returns-reserve-most-mismodeled-dtc-finance/.

05 The Monday cadence — owners, agenda, decisions

The template is updated every Monday. That sentence does most of the operational work. Bank actuals from the prior week roll into the prior-week column; the 13-week horizon rolls forward one column; the prior week's variance versus forecast gets flagged with a short comment ("Meta card-statement timing landed two days later than modelled — no economic change"); and the founder, the CFO or fractional CFO, the controller, and the heads of operations and growth sit for 30 to 45 minutes to walk the document and leave with three to five decisions.

The ownership pattern that holds across engagements: the controller owns mechanics (actuals, roll-forward, AR/AP reconciliation, payroll mapping, variance flags). The CFO or fractional CFO owns judgment (assumptions, liquidity strategy, financing, scenarios, lender and board communication). The CEO and founder own the cash-moving decisions themselves (inventory buys, hiring, ad spend, pricing, capital raises). Dwight Funding's published guidance assigns the model to "a Controller, Financial Analyst, or Fractional CFO" with weekly updates and review across management, investors, and lenders. Chew On This describes the same pattern for DTC specifically: a rolling 13-week reviewed every Monday by finance, ops, and marketing together. The trap is having no named owner; the second trap is having the owner be someone too senior to update it.

1. Who owns the document — by name and seat — and is it the same person who updates it every Monday morning before the meeting?
2. Where do inventory deposits sit on the timeline, and are they modelled separately from balances, and balances separately from freight, and freight separately from saleable inventory?
3. What is the trigger threshold below which a revolver draw becomes pre-approved by the CFO without a board conversation, and is it documented in writing somewhere the lender has seen?
4. Which two scenarios are maintained alongside the base case — what does downside look like (slower collections, higher returns, a missed BFCM target) and what does upside (a sell-through outperform funding an early PO release) look like?

The Monday agenda is short by design. Five items: prior-week actuals vs forecast and variance commentary; the next four weeks of cash in detail (what is the projected low point and which week does it fall in); inventory and PO calendar review with operations; ad spend review with growth; and explicit decision capture — three to five decisions named and assigned. The output of every Monday is a one-slide summary that goes to the founder, the leadership team, and to lenders if there is reporting obligation: current cash, projected low point inside the 13-week window in base and downside, top three variance drivers from the prior week, and the decisions taken. JP Morgan's cash forecasting ebook recommends the same shape; the difference between the brands that operate it and the brands that do not is the discipline of running it every Monday whether things look easy or hard.

06 The decision triggers the template was built to surface

A 13-week cash document that is not driving decisions weekly is a reporting artefact, not an operating instrument. Across the brands we work with, the document drives four classes of decisions. Each one has a named trigger threshold, set in writing, that converts a forecast reading into an action.

1. 01
   Revolver draw trigger. Set a minimum cash floor — typically 1.0 to 1.5 months of fixed operating outflow (payroll, rent, debt service, baseline SaaS). When projected ending cash in any week inside the 13 falls below that floor, a revolver draw is prepared. When the breach is in weeks 1-4, the draw executes; when the breach is in weeks 5-13, the CFO communicates to the lender that a draw is likely and adjusts discretionary spend (paid media, hiring, non-critical POs) to push the breach further out. Abacum's published guidance explicitly recommends a minimum cash threshold with proactive measures rather than waiting for the cash floor to be reached.
2. 02
   Inventory PO release trigger. Do not release a PO that the 13-week cannot absorb. The model needs to handle the deposit event (the 30% trigger), the balance event (the 70% on ex-factory), and the freight event without breaching the minimum cash floor in any week. When a PO causes a future breach, the operating options are: delay the PO by 2-4 weeks to push the deposit out, split the PO into two smaller drops (which doubles freight but halves the cash cliff), reduce the unit quantity, or finance the PO through a PO-finance line or inventory facility that mirrors the 90-130 day cycle. Operations and finance own this jointly; the CEO owns the strategic call when none of the four options fit.
3. 03
   Ad spend pull-forward or pause trigger. If the 13-week is tightening and contribution margin is compressing, paid media is the fastest discretionary lever — card-statement timing means the cash impact lands within two to four days of the platform decision. If the 13-week is loose and contribution margin is strong, pulling spend forward into a high-conversion window funds incremental cash in week 6-10. The trigger threshold is contribution margin holding above a defined floor (we typically use 35% blended for mid-market DTC) combined with the 13-week projected low point staying above the cash floor; if either breaks, paid media tightens before any other operating expense moves.
4. 04
   Hiring and capex trigger. New hires and discretionary capex are the slowest reversible decisions in a DTC operating model — both create commitments that extend beyond the 13-week window. The trigger we use: a new hire is approved only when the 13-week projected low point stays above the cash floor in both base and downside cases, with the new payroll line fully loaded from the start date. Capex over a defined threshold (typically $50K for $20-50M brands; $250K for $50-150M brands) gets the same test. The Monday meeting is the forum where these get approved or deferred.

07 When the spreadsheet stops working

The template ships as a Google Sheets / Excel workbook. For 80% of the brands we engage with — typically $20M to $50M revenue with a small finance team and a single fulfilment lane — the spreadsheet is the right tool, and the operating discipline matters more than the software. Brands that jump directly from no cash forecast to a full FP&A implementation almost always end up with a dashboard nobody updates.

Signals that a brand has outgrown the spreadsheet: weekly update taking more than 2-3 hours, multiple entities or fulfilment lanes creating manual export workflows, board reporting asking for scenario comparison the workbook cannot serve cleanly, lender covenant tracking requiring more granular cuts. Preferred CFO frames it the same way: Excel is the go-to for smaller and mid-sized businesses; a more robust FP&A platform becomes necessary when collaboration and integration scale up. The DTC-specific threshold sits roughly at $40-50M revenue with multi-entity or multi-channel complexity.

Tooling choice depends on which constraint is binding. Drivepoint fits DTC brands where the binding constraint is tying inventory and revenue forecasting to financial planning — Shopify, Amazon, and inventory integrations are the value add. Cube and Vena fit when the constraint is preserving Excel-native modelling with enterprise controls. Mosaic fits when headcount planning and board reporting are the binding constraints. Pry sits well for operational planning speed and scenario iteration. Finaloop, Bench, and Pilot operate one layer up as bookkeeping providers — they feed the FP&A tool with timely actuals rather than replace it. Brands that pick the wrong tool typically run the spreadsheet alongside the new tool for 6-12 months and eventually shelve the platform.

The transition pattern that works: run the spreadsheet 8-12 weeks before evaluating tools so the line set, assumption logic, and Monday cadence have stabilised. Take it to the vendor as the spec. Run both in parallel for 60-90 days. Deprecate the spreadsheet only when the new tool reproduces the Monday rhythm. Compressing the transition into 30 days almost always breaks the cadence.

08 The failure modes I see most often

Most failure modes that wreck a 13-week cash document in a DTC brand are operating, not modelling. Six show up across almost every engagement, ranked by frequency.

First, forecasting revenue instead of cash receipts — using Shopify gross sales as the inflow line rather than processor payouts net of fees. The fix is to tie every inflow row to a processor settlement report, an AR invoice on its real due date, or a confirmed financing event. Second, treating inventory as a single monthly outflow — collapsing deposits, balances, and freight into one number divided by four. The fix is lines 6, 7, and 8 modelled to the actual PO and shipment calendar for the next 6-8 weeks. Third, no clear owner — the document drifts because nobody is responsible for the Monday update. The fix is naming a controller or fractional CFO and putting the Monday meeting on the founder's calendar.

Fourth, optimism on the downside — running only the base case, with no formal downside scenario for slower collections, higher returns, missed promo, or delayed PO. Abrigo's commentary on common forecasting errors flags this, and we see it most often around BFCM where the base case assumes prior-year sell-through and the downside is missing entirely. Fifth, letting the model go stale after a lender ask — many brands build the 13-week once for a credit facility and never update it. The fix is the Monday cadence itself; the model is built to roll, not to file. Sixth, conflating P&L recognition and cash timing — treating refunds as contra-revenue in the cash document, treating inventory accrual as cash, treating depreciation as cash. The 13-week is a direct-method cash document, and every line must be a bank event.

Brands that fix the six end up with a document they update in 90 minutes every Monday morning and that drives three to five named decisions across the leadership team. That is the operating outcome the template is built for. The lender-facing version — the PDF that goes to the bank — is a byproduct of the discipline, not the reason for it.