A 13-week cash flow forecast template for omnichannel retailers.

01 Four channels, four cadences, four reserve regimes

The starting point is naming the cadences honestly. DTC via Shopify Payments or Stripe lands in your bank account on T+2 to T+3 for established accounts, with a 1-2% rolling reserve held against chargebacks for mature consumer brands and 5-10% for higher-risk categories or new merchants. Marketplaces operate on their own schedules: Amazon disburses every 14 days against an account-level reserve that holds funds for seven days after delivery (DD+7) plus a continuing buffer sized to roughly 7-14 days of trailing sales for mature low-return accounts and 20-30% of gross sales for new sellers in their first six months. TikTok Shop releases funds after delivery plus a seven-day buyer protection window, with reserves of 5-10% of trailing GMV for established sellers and 10-20% for newer accounts. Faire pays brands on Immediate Payout one to three days after shipment ships, taking the retailer credit risk on net-60 buyer terms, but charging 18-22% blended commission for early-stage Faire-sourced retailers and 12-18% for mature mixes. Wholesale to independent retailers nominally runs net-30 to net-60, but the median actual collection lag we see across our engagements sits at 35-45 days for net-30 paper and 65-75 days for net-60 paper, with 1-3% short-paid for damages, shortages, and unauthorised promotional deductions. Big-box retail — Target, Whole Foods, Costco, and the regional grocery chains — runs nominally on the retailer's net-30 to net-60 paper, but with trade-spend overlay of 15-25% of gross sales for large national grocery and club accounts, off-invoice discounts of 5-15%, and OTIF (on-time-in-full) compliance fines of 0.5-3% of invoice when delivery windows are missed. Cash realisation on big-box gross billings, fully loaded with deductions and trade spend, runs 75-85% of headline revenue at an effective DSO of 60-80 days.

Each of those four channels is a separate cash document. Treating omnichannel cash as a single line is the modelling error that breaks the document. The single line will be wrong on the level (because the channel-specific deductions and reserves are invisible), wrong on the timing (because the blended DSO masks the actual receipt week), and wrong on the trajectory (because adding $5M of Costco revenue at net-60 with 20% trade spend changes the blended cash profile in a way the single line cannot capture).

02 Build the document channel-by-channel, then roll

The template builds four parallel cash schedules — DTC, marketplace, wholesale, retail — each with its own collection lag, reserve regime, fee structure, and deduction profile. Each schedule produces a net-cash-receipts line that hits the consolidated weekly cash position. The four sub-schedules are visible on the second tab, and they are what the head of each channel manages to. The consolidated position is what the founder and the lender see.

Inside each sub-schedule, four lines do the work. Line one: weekly gross sales by channel. Line two: fees and commissions as a reduction to receipts (processor fees and reserves for DTC; FBA fees and referral for Amazon; Faire commission; trade spend and deductions for retail). Line three: reserve build or release for the channels that carry one (DTC processor reserve, Amazon ALR, TikTok Shop reserve). Line four: net cash receipts that actually hit the operating bank account this week. Below the four lines, a memo line tracks the reserve balance — which is restricted, not available, liquidity. The cardinal error is treating reserve balances as cash. They are AR-like balances that sit on the marketplace platform until released, and modelling them as available cash overstates the operating position by the cumulative reserve carry — which for a $40M omnichannel brand with material Amazon and TikTok exposure is typically $400k-$1.2M of phantom liquidity.

A practical model: for Amazon, weekly cash receipts equal net-before-reserve from two weeks ago minus the change in reserve this week. If trailing four-week average sales are $200k a week and the target ALR is 10%, the target reserve is $20k; if last week's ALR was $18k, the reserve build of $2k reduces this week's receipts by $2k. The reserve balance is tracked as a memo line, not as cash. For TikTok Shop the math is identical with slightly looser reserve assumptions (7-10% base, 15-20% risk-up) and a 2-week cash lag. For Faire on Immediate Payout, weekly cash receipts equal roughly 90% of (gross Faire sales minus Faire commission) hitting in the same week or the following week — most orders ship and pay within seven days. For wholesale and retail, cash receipts are driven by an AR-aging schedule with channel-specific dilution rates layered on top: 2-3% deduction for independent wholesale, 15-25% trade spend for big-box. The roll-up sums net-cash-receipts across all four channels into the consolidated 13-week cash position.

03 Inventory positioning across five pools

Omnichannel brands carry inventory in 3PL for DTC fulfilment, in FBA for Amazon, in retailer DCs for wholesale and retail orders that have shipped but not yet been invoiced or that sit on consignment, in wholesale customer warehouses where consignment terms or VMI arrangements apply, and in brand-owned warehouses for retail backstock and seasonal builds. Each pool has its own carrying cost, its own aging curve, and its own conversion-to-cash lag. The cash document references the inventory-positioning schedule by pool, weekly, and the working-capital line surfaces the impact of inter-pool transfers as separate cash events from net new inventory purchases.

Carrying cost varies materially by pool. 3PL inventory runs all-in at 20-30% of inventory value per year — 8-14% cost of capital, 8-12% storage and insurance and shrink, 5-10% obsolescence and markdown. Amazon FBA runs 2-4% of inventory value per month for standard-size goods in non-peak months ($0.90 per cubic foot at typical CPG densities) and 5-7% in October through December peak storage at $2.40 per cubic foot. The 2026 aged-inventory surcharge schedule adds approximately $1.50 per cubic foot per month for 271-365 day aged inventory on top of base storage, and for inventory aged over 365 days, the greater of $6.90 per cubic foot per month or $0.15 per unit per month — pushing effective carrying cost on aged FBA stock above 50% per year and frequently into 60-80%. Retailer DCs are usually their inventory once received and invoiced — your carrying cost shifts from inventory holding cost to AR carry — unless you are on consignment or VMI, in which case treat the retailer DC pool like a 3PL node. Brand-owned warehouse all-in runs 18-25% per year. Wholesale customer warehouses on consignment run 20-35% per year given the higher obsolescence and lower visibility.

The critical modelling point: inter-pool transfers are separate cash events from net new inventory purchases, and the cash document has to surface them as such. When you transfer 3PL inventory into FBA to chase a velocity opportunity, you pay LTL or parcel inbound freight, 3PL outbound handling fees, and sometimes FBA inbound receiving — pure cash outflow with no corresponding revenue offset, no second COGS recognition. The same is true when you remove aged FBA inventory back to a 3PL or to a wholesale liquidator: Amazon removal fees run $0.50-$0.90 per unit standard and $1.50-plus oversize, plus inbound receiving at the receiving pool, plus freight. In capital-constrained periods, the decision of whether to reposition a marginal SKU or discount and liquidate in place is a cash decision, not a margin decision — preserving cash by accepting the margin hit on in-place liquidation is frequently the correct answer. The template treats every inter-pool transfer as an explicit cash event, sequenced by week, with the freight and handling cost as a separate outflow line.

04 The Monday review — who is in the room

The 13-week cash document is not a forecast that gets emailed around once a month. It is the operating document for the weekly cash conversation, and the cadence has to hold for it to be useful. Monday morning, updated by Sunday evening from each channel's sub-document, the inventory-positioning schedule, the marketplace reserve balances, and any active retail trade-spend obligations. The CFO or fractional CFO chairs. The head of each channel — DTC, marketplace, wholesale, retail — attends and owns the inputs for their sub-schedule. The head of supply chain or operations attends and owns the inventory-positioning schedule. The founder is in the room.

The agenda is short. Run the consolidated cash position out 13 weeks. Identify the week with the lowest cash trough and name the drivers — a wholesale collection lagging beyond expected, a marketplace reserve building faster than sales, a large inventory PO clearing customs, a trade-spend deduction batch hitting next Tuesday. Look at each channel sub-schedule and ask whether the actual receipts this past week tracked plan. Look at the inventory-positioning schedule and ask whether any pool is sitting at a level that triggers the next-week decision — FBA approaching 271-day surcharge threshold, 3PL holding excess of a slow SKU, retailer DC consignment running below safety stock. Decide which channel to push (incremental marketing spend, additional retailer outreach, accelerated marketplace listing optimisation) and which to hold (reduce ad spend on the channel where the marginal contribution is now negative, slow inventory deployment to the slower-converting pool). Decide where to redeploy inventory between pools. Decide whether the consolidated cash position justifies the next channel-expansion commitment.

1. Are the four channels modelled separately or collapsed into one cash line? If one line, rebuild.
2. Is the marketplace reserve modelled as cash or as restricted liquidity? It is restricted — fix the model.
3. Is inventory positioning by pool inside the cash document, with inter-pool transfers as separate cash events? If transfers are netted into "inventory," the freight cost is hidden.
4. Is the trade-spend accrual schedule visible with the deduction-hit weeks called out, or is it a single accrued balance? Single balance = blind to the cash week.
5. Is the Faire commission line broken out from gross Faire sales, or are receipts modelled net of commission with no visibility into the margin compression on Faire-sourced retailers?
6. Is the OTIF-fine and deduction-rate running average tracked by big-box account, or is "retail" a single line that masks the deduction-heavy accounts?

05 Reserves, deductions, and the phantom-liquidity problem

The biggest single error I see in omnichannel cash documents that have been built without channel-specific treatment is what I call the phantom-liquidity problem. The reported cash balance pulls from the operating bank account, but the marketplace platforms — Amazon, TikTok Shop, sometimes Shopify Payments in higher-risk categories — are holding meaningful balances that the founder treats as "money on the way" but the model treats as cash. For a $40M omnichannel brand running 40% of revenue through Amazon and 10% through TikTok Shop, the cumulative reserve carry typically sits at $400k-$1.2M depending on category return rates and account history. That money is real, but it is not available for next week's payroll or the inventory PO clearing customs on Friday. Surfacing it as a memo line on the cash document, separate from operating cash, is the discipline that turns a fictional liquidity position into an honest one.

The second leakage is on the wholesale and retail side: trade-spend accruals and deduction reserves that have been booked on the balance sheet but are not visible on the cash document as a week-specific outflow. When a Costco promo runs in March, the accrual hits the balance sheet that month, but the deduction shows up on the April or May remittance — sometimes June. The cash document needs to carry the trade-promotion ledger as its own schedule, with each active promotion tied to its expected deduction week, and the deduction modelled as a cash outflow in that specific week. The CPG variant of this template carries the trade ledger as a primary tab; for omnichannel brands with mixed retail exposure, it carries it as a secondary schedule that feeds the retail sub-schedule. Without it, the cash document is fiction for any brand with material trade-spend exposure, and the surprises are concentrated in the weeks where multiple deduction batches clear simultaneously.

The third leakage is on the inventory side: aged-inventory surcharges at FBA, dead-stock holding at the brand DC, and consignment inventory at wholesale customer warehouses that has aged past the point where it can be liquidated at any margin. Each of these is a slow leak — not a single cash event in a single week — but in aggregate they can absorb 5-10% of gross margin if they are not surfaced. The template carries an aged-inventory line under the inventory-positioning module, refreshed weekly, with the per-pool aged balance and the rolling surcharge estimate. When an FBA SKU approaches the 271-day threshold, the decision to liquidate via Outlet or remove to a 3PL gets made before the surcharge layer kicks in — not three weeks after. The SKU-level work that anchors the aged-inventory decision is the same landed-cost-and-contribution analysis we lay out at /blog/sku-profitability-dtc-landed-cost/ — without that view, the liquidation decision gets made on gut feel and the gross-margin leak compounds quietly.

06 When a fifth channel arrives

Most omnichannel brands at $20M-$50M revenue eventually add a fifth channel, and the cash document has to absorb it before the first dollar moves. The four candidates in our practice: B2B custom (private-label or contract-manufacturing work where the brand monetises idle production capacity for other brands), pop-up or owned retail (short-term mall pop-ups or permanent brand-owned stores), international DTC (expansion into UK, EU, Canada, or Australia with the duties, VAT, and currency-hedging complexity that comes with it), and direct-to-CPG-brand wholesale (selling proprietary ingredients, formulations, or finished components to other consumer brands on recurring terms).

B2B custom is the most cash-intensive of the four to absorb. Order sizes run five-to-six figures per PO, with production cycles of four to twelve weeks PO-to-shipment, deposits of 30-50% on PO issuance for small-mid-market customers and 0-20% for large CPG customers with leverage, balance payable on net-30 to net-90 from shipment. Raw materials and packaging buys run 60-80% of project COGS in the four to six weeks after PO issuance, ahead of the balance receipt. Even with a 50% deposit, the project is typically net-cash-negative until final-payment collection ten to eighteen weeks after PO. The cash document absorbs B2B custom as its own block with project-based mini-schedules — each project gets a row with PO date, deposit %, deposit date, planned production weeks, planned shipment, terms, and expected cash receipts — rolled into the weekly view. The down-side scenarios that matter most are customer payment delay (two to four weeks beyond stated terms is common with large CPG customers) and post-PO scope change or cancellation after raw-material commitments have already been made.

Pop-up and owned retail is the most front-loaded of the four. The pre-opening cash stack is the surprise: short-term mall pop-up rent is typically 50-100% prepaid at signing, sometimes with revenue-share of 10-25% in lieu of base rent; fixtures, signage, and POS hardware run $25k-$150k per location and hit within a tight two-to-four-week window before opening; inventory deployment requires four to eight weeks of demand on-hand at the store before the first day. The cash document needs a pop-up sub-schedule with rent, security deposit, fixtures (capex), store payroll, local marketing, and incremental logistics for store replenishment — and a clearance-and-return-freight plan for weeks nine through thirteen if the location underperforms. The most common error: modelling rent and payroll only, missing the fixtures-deposits-inventory stack, and watching actual pre-opening outflows run two-to-three-times plan.

International DTC adds VAT and duties prepay, regional inventory pools with their own carrying-cost profile, and currency-hedging requirements. The cash drag is concentrated in the first ninety days of regional launch: import VAT and duties on full landed value upfront, with reclaim timing on the VAT often three to six months later; regional inventory commits before demand validates; regional payment processor reserves separate from the domestic Shopify Payments balance. The cash document needs a regional sub-schedule with VAT-prepay-and-reclaim timing as a memo line, treating regional inventory as a separate pool inside the positioning module, and carrying any FX hedging settlements as a discrete line. Direct-to-CPG-wholesale is the most recurring of the four — Net-30-to-60 from large CPG buyers, with minimum order quantities frequently in the six figures — and it slots into the wholesale sub-schedule with a distinct dilution profile (the buyer's deduction discipline is usually tighter and cleaner than independent wholesale, but the order sizes are larger).

The discipline is that every new channel gets its own schedule before the first dollar is shipped — not after the surprise cash event in month three. The cash document that has absorbed four channels well can absorb a fifth without breaking; the cash document that runs four channels through a single blended line will hide the fifth channel's cash impact until the cumulative drag is large enough to force a covenant conversation. The discipline costs an afternoon of CFO time at channel launch. Not having the discipline costs multiples of that across the next two quarters. For sellers thinking about a process in 2026 or 2027, the cash-document quality is also one of the highest-ROI sell-side preparation activities — buyers benchmark the operating sophistication against the multiples we lay out in the Q2 2026 consumer M&A read at /blog/dtc-cpg-mid-market-ma-multiples-q2-2026/, and brands that arrive with the four-channel cash document in hand clear at the preparedness premium, not below it.