Financial Planning
How to Build a Startup Cash Flow Forecast
Build a cash forecast from bank balances, expected receipts and payment dates, then keep it useful with weekly variance checks.
What you will learn
- Build a cash calendar from receipts and payment records
- Reconcile balances and diagnose timing variances
- Stress-test a collection delay and attach a decision
Build a startup cash flow forecast by putting expected bank receipts and payments into the periods when they will actually happen. Reconcile opening cash, schedule each material movement, carry closing cash forward, and test delays. The output is a dated cash calendar with decisions attached, not a revenue chart renamed cash flow.
You need a reconciled bank balance, open invoices, committed bills, payroll dates, and a finance owner who can resolve missing entries. Start with weekly periods when timing is tight, then connect them to the monthly model. This lesson builds the receipt-and-payment schedule; our financial-model lesson owns the broader assumptions framework.
Separate cash from revenue
A signed sale, an invoice, recognized revenue, and a bank receipt can occur on different dates. A profitable month can still consume cash. The SEC’s financial-statement guide distinguishes profit from cash movements. This is a management forecast, not a substitute for an accountant-prepared cash flow statement.
Create one input list with amount, expected bank date, counterparty, source record, confidence, and owner. Keep restricted or unavailable funds out of operating cash. A transfer between company accounts is not new company income.
Build the forecast in five passes
- Reconcile the starting point. Choose an as-of date. Match bank balances to recorded movements and unresolved items. Explain differences instead of forcing a balance.
- Schedule receipts individually. Use contract terms and collection history. Keep unsigned pipeline separate. A probability-weighted sales estimate belongs in a labeled scenario, not committed receipts.
- Schedule payments. Include payroll, taxes, subscriptions, vendors, debt payments, deposits, and one-off purchases on expected bank dates. Have the finance owner check classification and completeness.
- Roll cash forward. Closing cash equals opening cash plus receipts minus payments. Next period’s opening equals the prior closing. Show financing separately so the no-new-financing case remains visible.
- Attach a decision. Leadership chooses a minimum cash threshold and review date. That is a company-specific planning choice, not a universal recommended reserve.
Change specific collection dates, hiring inputs, or obligations in downside cases. A blanket percentage reduction can hide the cause of a shortfall.
Work a reconciled four-week example
Illustrative company, not a customer result: Cedar Tools starts with $180,000 of available operating cash and assumes no financing. Values below are thousands of dollars.
Completed cash forecast, $000
| Line | Week 1 | Week 2 | Week 3 | Week 4 |
|---|---|---|---|---|
| Opening cash | 180 | 160 | 150 | 120 |
| Collections | 20 | 25 | 15 | 30 |
| Payments | 40 | 35 | 45 | 35 |
| Closing cash | 160 | 150 | 120 | 115 |
The bridge reconciles: $180,000 + $90,000 − $155,000 = $115,000. Now move the $25,000 Week 2 receipt to Week 5. Do not erase it or spread it evenly. Closing balances become $160,000, $125,000, $95,000, and $90,000 during Weeks 1–4.
If leadership selected $100,000 as an internal warning threshold, the base case stays above it while the delay case crosses it in Week 3. The discussion is now specific: collection timing and optional spending. The model does not establish that supplier payments may lawfully be delayed or that financing will arrive.
Maintain a variance record
When the week closes, replace estimates with actual bank movements and preserve the earlier forecast.
Completed Week 2 variance explanation
| Line | Forecast | Actual | Action |
|---|---|---|---|
| Collections | $25,000 | $0 | Finance owner confirms invoice timing; moves expected receipt to Week 5. |
| Payments | $35,000 | $35,000 | No change. |
| Closing cash | $150,000 | $125,000 | Explain $25,000 timing variance, not an unexplained cost overrun. |
Forecast version / as-of date / currency: [ ]
Opening available cash and reconciliation: [ ]
Period ending: [ ]
Receipt: [counterparty, amount, bank date, source, confidence]
Payment: [payee/category, amount, bank date, obligation]
Closing cash: opening + receipts − payments
Separate financing assumption: [ ]
Minimum cash and first threshold crossing: [ ]
Actual / prior forecast / variance: [ ]
Timing difference or permanent change: [ ]
Remaining forecast adjustment: [ ]
Decision, owner and due date: [ ]Troubleshoot and verify
Cash improves without more sales: inspect collections, financing, deposits, and deferred payments before calling it operating improvement. The month balances but one week goes negative: do not conceal the week in an average. The forecast needs a round: show the no-funding case instead of treating unsigned commitments as cash.
- The starting balance matches a dated reconciliation.
- Each material movement has a source, date, and owner.
- Balances roll forward without plugs.
- Delayed receipts are moved, not counted twice.
- The finance owner can explain the largest actual-versus-forecast differences.
Use the result to update your fundraising timeline and use-of-funds plan. Label forecasts as forecasts when sharing them.
Informational disclaimer
We are not lawyers. This article is for general education only and is not legal, tax, accounting or investment advice. Check with your attorney or accountant before acting on it.