Cash flow forecasting is the single most underutilized financial tool in small e-commerce businesses. Most founders either don't have one, or have a version that's so disconnected from reality it's worse than useless.
The goal of a cash flow forecast isn't to be right about the future — it's to stop being surprised by it. Here's how to build one that actually works for a DTC or CPG brand.
Start with cash in, not revenue
The most common mistake founders make is confusing revenue with cash. They're not the same thing, and in e-commerce, the gap between the two can be significant.
If you sell DTC through Shopify, your cash timing is actually pretty clean — Shopify pays out on a rolling 2-3 day cycle, so revenue and cash are close to aligned. But if you sell wholesale or through retail, you might be shipping product in January and not collecting payment until April. Meanwhile you already paid your co-man 30 days before you shipped.
Your forecast needs to model when cash actually lands in your bank account, not when you recognize the sale. Build a simple schedule that maps your revenue by channel to your expected collection timing.
The inventory cash trap
For product businesses, inventory is where cash goes to hide. A founder can look at a healthy P&L and wonder why they're always broke — the answer is almost always inventory timing.
Here's the cycle that catches brands off guard: you place a purchase order 90 days before you need the product. You pay a deposit upfront and the balance before your freight ships. The product arrives, sits at your 3PL for 30 days before you sell it. Then, if it's wholesale, you wait another 60 days to collect. That's potentially 6 months of working capital tied up in a single PO.
Your cash flow forecast needs an inventory build schedule. Map out every PO you expect to place over the next 12 months, when you'll pay for it, and when you expect to convert it to revenue. This single exercise will reveal cash crunches you didn't know were coming — and give you time to do something about them.
Model your operating expenses honestly
Most founders underforecast expenses in two ways: they forget about irregular payments, and they're optimistic about variable costs.
Irregular payments are the ones that don't show up every month but still hurt when they do: annual software renewals, quarterly insurance payments, trade show deposits, agency retainers that spike around product launches. Build a full calendar of expected payments and spread them into your monthly forecast, even if the actual payment timing is lumpy.
Variable costs — especially paid media — need to be modeled as a percentage of your revenue targets, not as a flat number. If you're planning to spend $20k/month on Meta and your sales are tracking 30% below plan, that $20k needs to flex down with it. A good forecast has these linkages built in.
The three scenarios you actually need
A single-line forecast is a false sense of precision. Build three scenarios:
Base case: Your honest expectation — not what you're telling investors, what you actually think will happen based on current trends.
Downside case: What happens if revenue comes in 20–25% below plan? Does the business survive? For how long? This scenario tells you your minimum cash buffer requirement.
Upside case: This one trips people up — fast growth can actually be a cash flow problem in product businesses. If orders spike 50% above plan, can you fund the inventory? Model it.
Running all three every month and comparing actuals against your base case is how you get early warning of problems, not post-mortems.
The metrics to watch every week
A 12-month forecast is strategic. But cash flow management is also a weekly discipline. The numbers to watch:
- Cash balance vs. forecast: Are you tracking ahead or behind your projection?
- Accounts receivable aging: Is wholesale money coming in on time, or are retailers stretching their terms?
- Inventory on hand vs. days of supply: Are you holding too much, or are you about to stock out?
- Burn rate: How many months of runway do you have at your current spending pace?
When to ask for help
If you're spending more than a few hours a month trying to figure out your cash position, something is wrong — either with your books, your forecast, or both. A well-built model should take 30 minutes to update each month and give you a clear 90-day view with 10 minutes of review.
The founders who use their cash flow forecast well treat it like a dashboard, not a spreadsheet exercise. It runs in the background, flags problems early, and lets them focus on the actual business.
If you don't have this yet, it's worth building. The cost of getting caught off guard — whether that's missing payroll, scrambling for a bridge loan, or turning down a retail opportunity because you can't fund the inventory — is almost always higher than the cost of doing it right.