Most "cash flow projection template" articles stop at a blank grid and a definition. That is fine until you run a store that spends real money on ads every day. You need a projection built from operating numbers — orders, payout timing, supplier charges — not a tidy spreadsheet that pretends cash in and cash out happen on the same day. This one does.
A cash flow projection is not a P&L
Your profit and loss statement answers "did the store make money this month?" Your cash flow projection answers a different, more urgent question: "will the bank balance cover next week's ad card?"
The gap matters because profit is booked on the sale date, while cash moves on its own schedule. A store can show a healthy operating profit and still be unable to pay a bill, because the cash from this week's sales has not landed yet. If you want the profit side first, start with our ecommerce P&L guide, then come back here for the cash timing.
A sample cash flow projection for an operating store
Say you run a store doing 340 orders a month at a $31 average order value — about $10,540 in gross sales — spending $2,800 a month on Meta ads, fulfilled through a print-on-demand supplier at roughly $13 a unit. Here is a three-month projection in the standard layout: opening cash, cash in, cash out, net, closing.
| Line | Month 1 | Month 2 | Month 3 |
|---|---|---|---|
| Opening cash | $6,000 | $7,556 | $9,112 |
| Cash in — net store payouts | +$9,816 | +$9,816 | +$9,816 |
| Cash out — POD supplier | −$4,420 | −$4,420 | −$4,420 |
| Cash out — ad spend (Meta) | −$2,800 | −$2,800 | −$2,800 |
| Cash out — platform + apps | −$150 | −$150 | −$150 |
| Cash out — email + design tools | −$90 | −$90 | −$90 |
| Cash out — owner draw | −$800 | −$800 | −$800 |
| Cash out — quarterly estimated tax | $0 | $0 | −$1,400 |
| Net cash flow | +$1,556 | +$1,556 | +$156 |
| Closing cash | $7,556 | $9,112 | $9,268 |
The arithmetic is yours to check: cash out in Month 1 is 4,420 + 2,800 + 150 + 90 + 800 = $8,260, so net cash flow is 9,816 − 8,260 = +$1,556, and closing cash is 6,000 + 1,556 = $7,556. Month 3 looks almost flat (+$156) only because the quarterly estimated tax payment lands that month — a cash event that never shows up on a monthly P&L, which is exactly why you project it.
What the "net store payouts" line actually contains
That $9,816 is not your sales. It is a net settlement. Your store deposits gross sales minus processing fees minus refunds, batched on a delay. Shopify Payments in the US charges around 2.9% plus 30¢ per online transaction, according to A2X's breakdown of Shopify fees, and disputes carry a fifteen-dollar chargeback fee on top (refunded if you win).
So the payout math for this store is: processing is 2.9% × 10,540 + 0.30 × 340 = about $408, refunds run roughly $316 at a three-percent return rate, and 10,540 − 408 − 316 = $9,816 of actual cash in. Book gross sales at the top of your books and the net payout as the cash consequence — never the other way around, or your projection quietly overstates every month.
Why a profitable store still goes cash-negative
This store nets over $1,500 of cash in a steady month. It looks safe. The trap shows up the moment you scale.
The same A2X breakdown notes that payouts settle on a rolling multi-day delay — commonly a couple of business days in the US, longer across weekends and for newer accounts. Meanwhile your ad spend leaves daily and your POD supplier charges you at production, right after the customer buys. Money goes out before the matching payout comes back. That gap is the float, and it widens every time you grow.
A short timing walk
Say you decide to scale and push Meta from $2,800 to $4,500 for a month to chase growth. Orders rise, and every cohort is still profitable — but the ad card is charged today while the payouts for those extra orders settle days later, some of them after the month closes.
So your projection for that month shows ad spend and supplier charges jumping immediately, while cash in rises only partway before month-end. Net cash flow can turn negative in a growth month even though the store is more profitable than ever. Founders read the strong P&L, keep scaling, and get blindsided when the balance won't cover next week's spend. The fix is a cash buffer sized to roughly your daily ad plus supplier spend multiplied by the payout delay in days, plus a weekend cushion.
How to build your own projection
- Pick the timeframe. Monthly columns across three to twelve months works for most stores; add a weekly view if you scale ad spend fast.
- Start with real opening cash — today's actual bank balance, not an estimate.
- Project cash in as net payouts, not gross sales. Take gross sales, subtract processing and expected refunds, and shift the timing to when the money actually lands.
- List every cash out by when it hits: supplier charges at production, ad spend daily, subscriptions monthly, owner draw, and the lumpy ones — quarterly estimated taxes, annual tool renewals.
- Compute net cash flow and carry the closing balance forward as next month's opening cash.
- Run a worst-case column where ad spend scales and payouts lag, so you see the trough before you hit it.
A free printable profit and loss statement gives you the profit picture to pair with this; for the cash side, the structure above is the whole job. If you want the projection to update itself instead of living in a spreadsheet, see our guide to cash flow software for small business.
Where the numbers should come from
A projection is only as honest as its inputs. The two that stores get wrong most are per-order profit (because supplier cost, processing, and ad spend are scattered across different tools) and payout timing (because the bank deposit never matches the sales report).
This is the gap PodVector AI built Victor to close. Victor is an AI employee that connects your store, Meta Ads, Google Ads, and your POD supplier — Printify, Printful, or Gelato — and computes your true per-order profit from that live data, then delivers the reports to your Google Drive. Every write action he takes is approval-gated, so nothing happens without your say-so. Instead of hand-keying last month's numbers into a grid, you start your projection from figures that already reconcile. Put Victor to work on your store and build the projection from numbers you can trust.
Projections built like this stop being a once-a-year chore and become the thing you check before every ad-budget decision. The same reconciled view works whether you sell apparel, mugs, or — if you ran a very different business — the kind of fixed-cost model a hotel profit and loss statement captures. The discipline is identical: map cash to when it actually moves.
This is general information, not tax advice. Tax rules change and vary by situation — consult a licensed CPA or tax professional before acting.
FAQs
What is a cash flow projection for a small business?
It is a forward-looking schedule of the cash you expect to come in and go out over a set period, usually month by month, ending with a projected closing balance for each period. Unlike a P&L, it tracks money by when it actually moves — so it catches the week a profitable store runs short before payouts land.
How is a cash flow projection different from a cash flow statement?
A cash flow statement reports what already happened to your cash last period. A projection does the opposite: it forecasts what will happen next, using your sales history, payout timing, and known upcoming costs like quarterly estimated taxes. You use the statement to check accuracy and the projection to make decisions.
Why does my projection show profit but no cash?
Because profit is booked when a sale happens and cash arrives when the payout settles — often days later. If you are scaling ad spend, you pay for the ads and supplier charges today while the resulting payouts land after a rolling delay, commonly a couple of business days in the US per A2X. The faster you grow, the wider that gap, which is the float.
How many months should a cash flow projection cover?
Three to twelve months of monthly columns is standard for an operating store. If you spend heavily on ads and scale quickly, add a weekly or thirteen-week view, because a monthly column can hide a mid-month cash trough between ad charges and payout settlement.
What should I include as cash out?
Everything that leaves the bank, timed to when it hits: supplier or production charges, daily ad spend, platform and app subscriptions, email and design tools, owner draw, and the lumpy items people forget — quarterly estimated taxes, annual renewals, and equipment. Leaving out the irregular outflows is the single most common reason a projection looks fine and the balance doesn't.