Cash flow forecast example for ecommerce brands

Ecommerce brands rarely die because they stopped making a profit. They die because they run out of cash while the P&L still says they are winning. The income statement books a sale the day it ships, but the cash that paid for that inventory left the building 60 to 150 days earlier, and the payout from the sale lands days or weeks after. A cash flow forecast is the one document that puts those timing gaps on a calendar. This is the worked example: the structure, the line-by-line build, the step where most founders get the timing wrong, and the downside scenario that decides whether you draw the credit line or cut a purchase order.

Why profit and cash are not the same thing in ecommerce

Profit is an accrual idea. Cash is a timing one. The number that actually keeps your lights on is not net margin, it is the cash conversion cycle: how many days pass between the moment you pay for inventory and the moment you collect the net cash from selling it.

The formula is simple: CCC = DIO + DSO minus DPO. Days inventory outstanding (DIO) is how long stock sits before it sells. Days sales outstanding (DSO) is how long you wait to get paid after the sale. Days payable outstanding (DPO) is how long your suppliers let you wait before paying them. Retail and ecommerce average a 60 to 90 day cash conversion cycle (Ramp, Wayflyer), which means two to three months of operating cash your brand has to self-fund out of its own pocket on every cycle.

Here is the worked build for a representative brand carrying 60 days of inventory, a one-week payout lag, and 30-day supplier terms:

Component	Days
Days inventory outstanding (DIO)	60
Days sales outstanding (DSO)	7
Days payable outstanding (DPO)	-30
Cash conversion cycle (CCC)	37

Thirty-seven days is a healthy number. The same brand with 120 days of inventory and 20-day supplier terms lands at a 107-day CCC, nearly three times the cash trapped. When I talk to founders running a brand this size, the lightbulb moment is almost always the same: they had been managing the margin and ignoring the cycle, and the cycle is where the brand actually lives or dies.

The 13-week forecast structure: rows, columns, and the direct method

The tool for this is a 13-week direct cash flow forecast. Direct means you forecast actual cash movements (receipts and disbursements) rather than starting from net income and adjusting. Thirteen weeks is a quarter plus a buffer week, about 91 days, which is long enough to capture a full inventory cycle and short enough to forecast by hand. If you want the row-by-row template behind this, we walk through it in how to build a 13-week cash flow forecast.

The columns are the next 13 weeks. The rows are the line items below. The structure is deliberately boring, which is the point: every dollar lands in exactly one row and one week.

Section	Line items
Opening cash balance	Per bank statement (not GL)
Cash inflows	Shopify/DTC payouts; Amazon payouts; other marketplaces; BNPL (Klarna/Affirm/Afterpay); wholesale A/R; loans, equity, interest
Cash outflows	Inventory purchases by vendor; freight and 3PL; marketing (Meta/Google/TikTok); processor and platform fees; payroll and contractors; rent, software, insurance; sales and payroll tax; debt service; capex and one-offs
Net cash flow	Total inflows minus total outflows (weekly)
Ending cash balance	Opening cash + net cash flow, rolls into next week's opening

Two rules make or break the shell. First, the opening balance is your bank statement number, not the cash line in your accounting software, because the GL lags reality by days. Second, every channel and every vendor gets its own row. The pattern we see again and again is a brand that lumps "sales" into one inflow line, applies an average lag, and then gets blindsided when the Amazon settlement and the wholesale invoice land in different weeks than the blended average implied.

Step by step: building each line

This is the operational core. Work through the rows in three passes.

Pass one, the inflows. Take each channel's daily sales and shift the cash into the week it actually arrives. Channel payout lag is the DTC replacement for accounts receivable, and the spread is wide.

Shopify Payments defaults to about a three-business-day payout in most regions once your account is seasoned (T+1 only on Shopify Balance, and five-plus days for new merchants or some countries); Stripe settles in roughly two once seasoned. BNPL providers land in roughly three. Amazon settles every 14 days and holds a reserve on top. Wholesale lands on Net-30 or Net-60. If 40 percent of your revenue is Amazon, nearly half your cash arrives in lumpy 14-day clumps, and your forecast has to show that, or the trough weeks will surprise you.

Pass two, the inventory roll-forward. This is the line that breaks most forecasts. With 30/70 or 20/80 overseas terms, your deposit leaves the day you place the PO, the balance leaves on shipment, and the goods then take 30 to 90 days to produce plus 20 to 40 days on the water before they are sellable. So cash leaves 60 to 150 days before the matching sale. Model the deposit and the balance as two separate disbursements in the weeks they actually clear, tied to each specific PO.

How much cash that ties up depends entirely on how lean you run inventory.

The leanest private DTC brands run 6 to 12 inventory turns a year, roughly 30 to 60 days on hand. Over-stocked public peers run 2 to 3 turns, 120 to 180 days. When we have struggled with a brand's cash, the fix has almost always lived in this row. One operator had pushed inventory to 140 days chasing a never-out-of-stock policy. Pulling it back toward 75 freed up a quarter of a year's working capital without touching a single price.

Pass three, the fixed and semi-fixed outflows. Payroll on its real dates, ad platforms on their billing cadence (most charge a few days after spend, or on a threshold), processor fees netted out of payouts, rent and software on their cycles, and the tax line that operators forget until it is a five-figure surprise. Sales tax and payroll tax both belong in the forecast on their remittance dates.

A worked example: three weeks in the life of a $5M brand

Picture a $5M DTC brand, 60/7/30 on the cycle above, opening a given week with $180,000 in the bank. Here is how three weeks actually play out.

Week 1: a $90,000 PO deposit (30 percent of a $300,000 reorder) leaves on Tuesday. DTC payouts of $55,000 land across the week. A Meta invoice of $28,000 clears Friday. Net for the week is roughly minus $63,000, and the brand ends near $117,000. On the accrual P&L, this is a great week. In cash, it is the worst of the three.

Week 2: the Amazon 14-day settlement lands, $48,000 in one lump. DTC adds another $52,000. Payroll of $40,000 goes out mid-week, software and rent take $14,000. Net is positive, about $46,000, ending near $163,000.

Week 3: the $210,000 PO balance (the 70 percent) clears on shipment. Even with $60,000 of payouts arriving, the week nets to roughly minus $150,000 and the ending balance drops to about $13,000. That is the trough. Nothing in the P&L flagged it, because the inventory expense will not even hit the income statement until those goods sell two months from now. The forecast caught it three weeks early, which is exactly enough time to delay the PO balance by a week or pre-arrange a small line draw.

The income statement tells you whether the business model works. The 13-week cash forecast tells you whether you survive to find out. Profit is an opinion about the quarter. Cash is a fact about Tuesday.

Stress-testing and the weekly operating rhythm

A single forecast line is a guess. Run three. Base case is your honest plan. Downside is sales at minus 20 percent with inventory already ordered and marketing held flat. Liquidity-preservation is the floor: what you cut to keep the bank balance above zero.

The downside scenario is the one that earns its keep, because the expensive commitments do not flex. When sales come in 20 percent light, your payouts shrink in those weeks but the PO balances you already signed and the payroll you already owe land on schedule. The miss hits the bank balance almost dollar-for-dollar. When I talk to founders this size, the ones who sleep at night are the ones who already know which lever they pull first: most pull or delay the next PO, then draw the line of credit, and cut marketing only as a last resort because cutting ads also cuts next month's receipts.

Then run it weekly. Every Monday: drop last week into actuals, compute the variance (and split it into volume versus timing, because a sales miss and a slow payout demand different responses), re-extend the 13th week, and write a one-line note. The rhythm is what converts a spreadsheet into an early-warning system you actually trust.

Cash buffers, runway, and when to get help

The forecast tells you when you are short. The buffer tells you how much margin you have before short becomes a crisis. As a rule of thumb, recommended runway scales down with revenue: sub-$1M brands want 12 or more months of operating expenses accessible, $1-5M want 9 to 12, $5-25M want 6 to 9, and $25M+ can run on 4 to 6. As a rough rule, hold 15 to 25 percent of annual revenue as working capital.

Metric	Healthy / target	Common but stretched
Days inventory outstanding (DIO)	30-60 days	90-180+ days
Days payable outstanding (DPO)	45-60 days	20-30 days
Days sales outstanding (DSO), pure DTC	1-7 days	24-73 days (with wholesale/Amazon)
Cash conversion cycle (CCC)	30-60 days	60-150 days
Cash runway ($5-25M revenue)	6-9 months	<4 months

If your forecast keeps printing a trough you cannot fund, the answer is rarely one more spreadsheet tweak. It is usually one of three structural levers: extend supplier terms (push DPO from 30 toward 60), pull inventory days down, or fix the channel mix that is starving your weekly cash. For the wider topic, see our note on forecasting ecommerce cash flow. When the levers need a hand on the wheel, our interim CFO services team builds and runs this model with operators every week.

Related reading. For the committed-PO adjustment that makes a forecast honest, see the runway myth, minus committed POs.

Sources and methodology

This guide synthesizes the standard 13-week direct cash-flow method from Intuit, Wall Street Prep, Atlar, and BDO, all of whom describe the same core mechanic: forecast weekly cash receipts minus disbursements rolling forward roughly 90 days, started from the bank balance rather than the accrual P&L, and rebuilt each week against actuals with a volume-versus-timing variance read.

The cash conversion cycle definition and the 60 to 90 day retail and ecommerce benchmark come from Ramp, with corroborating working-capital framing from Wayflyer. The CCC = DIO + DSO minus DPO formula is standard; the 37-day worked example is adapted from a practitioner working-capital guide and rebuilt here for a representative brand.

Channel payout timings are provider-published policy defaults: Shopify Payments about three business days in most regions (T+1 on Shopify Balance; up to five business days for new merchants) per the Shopify Help Center; Amazon's 14-day settlement cadence per the Amazon Seller blog (July 2025); and Stripe's 7 to 14 day initial payout, falling to roughly T+2 once seasoned, per Stripe documentation. Actual timing varies by account age, region, and risk profile, so model your forecast against your own payout reports as the source of truth, not these defaults.

Inventory benchmarks (turns by brand tier, converted to days as 365 divided by turns) draw on the Yotpo 2026 ecommerce benchmarks and vendor DTC statistics. Supplier deposit structures (30/70 and 20/80) and net-terms working-capital impact follow J.P. Morgan's net-terms guidance and standard trade-finance practice, with production and ocean-freight lead times in the 30 to 90 and 20 to 40 day ranges respectively.

The benchmark bands here are directional, synthesized from vendor and operator sources rather than a single audited dataset, and should be read as ranges, not precise figures. No figures were fabricated; every number traces to a cited source above. The operator observations are anonymized composites from work with DTC brands and never identify a specific company.

Frequently asked questions

why am i profitable but still running out of cash?

Because profit is an accrual idea and cash is a timing one. Your P&L books a sale the day it ships, but your inventory cash often left 60 to 150 days earlier and your channel payouts land days to weeks after the sale. A retail brand can sit on a 60 to 90 day cash conversion cycle, so you can earn a profit in the same month your bank balance hits zero.

how do you build a cash flow forecast for an ecommerce brand step by step?

Start from your real bank balance, not the P&L. List cash receipts by channel and week (Shopify, Amazon, wholesale, BNPL), list cash disbursements by category (inventory POs, freight, ads, payroll, fees, tax), net them weekly, and roll the ending balance into next week's opening. Extend it 13 weeks, then rebuild it every Monday with actuals.

what is a 13-week cash flow forecast and why 13 weeks?

Thirteen weeks is one fiscal quarter plus a buffer week, about 91 days. It is long enough to capture a full inventory-to-cash cycle and short enough that you can still forecast each line by hand. It is the same horizon lenders and turnaround teams use, which is why it travels well if you ever raise debt.

how much cash does inventory tie up and when does it actually leave your bank account?

More than founders expect, and earlier. With 30/70 or 20/80 supplier terms, your deposit leaves at the PO, the balance leaves on shipment, and the goods then take 30 to 90 days to arrive and weeks more to sell. A lean brand holds 30 to 60 days of inventory; an over-stocked one holds 120 to 180. That gap is months of working capital sitting on a shelf.

how do you separate cash inflows by channel in a forecast?

Give each channel its own receipt row with its own lag. Shopify defaults to about a 3-business-day payout in most regions (T+1 on Shopify Balance) and Stripe to roughly 2 once seasoned, BNPL in roughly 3, Amazon settles every 14 days and holds a reserve, and wholesale lands on Net-30 or Net-60 terms. Apply the lag to each channel's daily sales so the cash shows up in the week it truly arrives, not the week of the sale.

how often should an ecommerce operator update their cash flow forecast?

Weekly. Every Monday, drop last week into actuals, compare forecast versus actual to find variance, re-extend the 13th week, and write a one-line note on what moved. A forecast you build once and never touch is a static guess. The weekly roll is what turns it into an early-warning system.

what happens to your cash flow forecast if sales come in 20% below plan?

Your bank balance takes the hit almost dollar-for-dollar, because the expensive part (inventory you already ordered) does not flex. A 20% revenue miss shrinks your payouts in the affected weeks while the PO balances and fixed costs land on schedule. That is why you build a downside scenario: it tells you whether you pull a PO, draw the credit line, or cut marketing, and roughly when.

how many months of cash runway should an ecommerce brand keep in the bank?

It scales down with size. Sub-$1M brands want 12+ months of operating expenses accessible, $1-5M want 9-12, $5-25M want 6-9, and $25M+ can run 4-6. As a rough buffer, hold 15 to 25 percent of annual revenue as working capital. The forecast tells you whether you are above or below that line on any given week.