Why Cash Flow Forecasting Matters
Many profitable sellers go out of business due to cash shortages. Profitability and cash flow are different:
- Profitability: Revenue minus expenses (accrual accounting)
- Cash Flow: When money actually enters/leaves your bank account (cash timing)
Example: You made $100K profit in November but spent $80K on December inventory. Your bank shows a $20K surplus, but you have $80K less cash than yesterday.
Cash flow forecasting prevents surprises by showing your bank balance 13 weeks ahead. This lets you:
- Plan large inventory purchases
- Negotiate payment terms with suppliers
- Arrange financing before you need it
- Avoid missed payroll or bill payments
- Invest in growth at the right time
Components of Cash Flow Forecasting
1. Beginning Cash Balance
Start with this week's actual bank balance. Check your bank account and enter the number.
2. Sales Revenue (Inflows)
- Amazon deposits: Project weekly/bi-weekly based on historical average + seasonality
- Shopify deposits: Usually daily, so project daily average
- Other channels: eBay, Etsy, direct sales
- Adjustments: Returns, chargebacks, refunds reduce cash
Tip: Be conservative. Use last 4 weeks average, not best-case scenario.
3. Inventory Purchases (Outflows)
- Supplier payments: When do you pay? Immediately, Net 30, Net 60?
- Freight costs: When is ocean freight invoiced vs. paid?
- Customs duties: When are tariffs due?
- Existing commitments: Purchase orders already placed
Tip: List all purchase orders with payment dates. This is critical.
4. Operating Expenses (Outflows)
- Fixed: Software subscriptions, office rent (same amount each month)
- Variable: Advertising spend, packaging (changes with sales)
- Payroll: Your salary, contractor payments
- Taxes: Quarterly tax payments (April 15, June 15, Sept 15, Jan 15)
5. Loan Payments & Debt Service
- Business line of credit payments
- Amazon lending repayments
- Equipment financing
6. Owner Draws/Distributions
- How much do you take from the business monthly?
- Plan withdrawals conservatively
Creating Your 13-Week Cash Flow Forecast
Week 1: Gather Historical Data
- Pull last 4 weeks of bank statements
- Calculate average weekly revenue per platform
- List all committed inventory purchases
- Document fixed expenses (Software: $100/month, Ads: $3K/week)
Week 2: Build the Forecast Template
Create columns for 13 weeks:
- Week starting date
- Beginning cash
- Amazon deposits
- Shopify deposits
- Other revenue
- Total inflows
- Inventory purchases
- Operating expenses
- Taxes & loans
- Total outflows
- Ending cash (Beginning + Inflows - Outflows)
Week 3: Enter Data
- For next 13 weeks, enter expected inflows/outflows
- Row by row, calculate ending cash each week
- Watch for negative weeks (cash shortfall)
Week 4: Identify Problem Periods
- Highlight any week with negative cash balance
- Note the magnitude of shortfall
- Plan solutions (reduce spending, delay purchases, borrow)
Example Forecast (Simplified)
| Week | Beginning Cash | Revenue | Inventory | Expenses | Ending Cash |
|---|---|---|---|---|---|
| Week 1 (Nov 6) | $45,000 | +$8,000 | -$0 | -$3,000 | $50,000 |
| Week 2 (Nov 13) | $50,000 | +$9,000 | -$25,000 | -$3,000 | $31,000 |
| Week 3 (Nov 20) | $31,000 | +$12,000 | -$0 | -$3,000 | $40,000 |
| Week 4 (Nov 27) | $40,000 | +$15,000 | -$35,000 | -$3,000 | $17,000 |
Alert: Week 4 shows only $17K cash remaining. If next week needs $20K inventory purchase, you're short $3K.
Seasonality & Growth Adjustments
Account for Seasonal Changes
- Q4 (Nov-Dec): Sales typically 2-3x normal. Forecast higher revenue.
- January: Sales drop 40-60% post-holidays. Plan for slower cash.
- Summer: Varies by product category
If Growing Year-Over-Year
- Don't assume constant growth (diminishing returns)
- Use historical percentage growth (e.g., last quarter grew 15%)
- Apply conservatively (grow 10% vs. actual 15%)
Using the Forecast to Make Decisions
Scenario 1: Forecasted shortfall in Week 7
Your forecast shows ending cash of -$8,000 in Week 7.
Options:
1. Delay Week 6 inventory purchase by 1-2 weeks
2. Negotiate 60-day terms instead of Net 30
3. Arrange business line of credit ($10K) as buffer
4. Reduce advertising spend that week ($2K savings)
Scenario 2: Peak holiday buying opportunity
Forecast shows strong November-December sales. You want to order 50% more inventory.
- Would purchases drop ending cash negative? (Check forecast)
- Can you secure financing to cover the gap? (Talk to lender)
- Is timing reasonable (inventory arrives before peak)? (Check supplier lead times)
- Do you have capital to invest? (Calculate ROI vs. borrowed cost)
Maintaining Your Forecast
Weekly Updates (30 minutes)
Common Cash Flow Forecasting Mistakes
- Overestimating revenue: Use conservative average, not best weeks
- Forgetting payment timing: Inventory costs cash when paid, not when received
- Ignoring taxes: Quarterly tax payments are major cash drains
- One-time forecasts: Update weekly as actual data comes in
- No buffer: Plan for unexpected expenses; keep $5-10K minimum cash
- Ignoring seasonality: Q4 is very different from January
- Spreadsheet errors: Double-check formulas; ensure ending cash = beginning cash + inflows - outflows
Cash Flow Forecast Tool Options
| Tool | Cost | Ease of Use | Best For |
|---|---|---|---|
| Excel/Google Sheets | Free | Moderate | Sellers who build their own |
| QuickBooks Forecasting | Included in QB | Easy | QB users wanting automation |
| Xero Cash Forecast | Included in Xero | Easy | Xero users wanting automation |
| Float | $99-299/month | Very Easy | Advanced forecasting with automation |
| Vend/Square | Included in POS | Moderate | Retail + e-commerce sellers |
Summary: Cash Flow Forecasting Best Practices
✓ Create: 13-week rolling forecast weekly
✓ Include: Revenue (by platform), all outflows (inventory, operating, taxes, debt)
✓ Monitor: Negative cash balance weeks; plan mitigation
✓ Adjust: Weekly as actual data arrives
✓ Maintain: Minimum $5-10K cash buffer at all times
Result: Never surprised by cash shortages; make confident growth decisions