cash flow forecasting
Your cash position can change long before the next budget review. A weekly cash flow forecast gives founders and CEOs a practical view of expected receipts, payments and balances ahead, so they can adjust decisions in time.
Key Takeaways
- A rolling cash flow forecast shows your expected receipts, payments and balances ahead of time so you can act before cash gets tight.
- Reviewing the forecast weekly keeps payroll timing, vendor payments and runway decisions grounded in current numbers.
- The right template or software should match your billing cycles and complexity rather than force you into generic categories.
- Accurate books feed a reliable forecast, which is why clean accrual accounting and cash visibility go hand in hand.
Pair a detailed 13-week view with a 12-month runway outlook. The first helps leadership manage near-term commitments. The second connects those choices to hiring, investment and financing plans.
Cash Flow Forecasting: What It Is and Why It Runs Weekly, Not Yearly
Cash flow forecasting estimates when money will enter and leave a company, then projects the cash balance over time. A profitable company can still face a cash squeeze if customer payments arrive after payroll or vendor bills are due. A useful forecast connects cash movements to dates and gets updated as information changes.
Cash flow forecasting in plain English
Think of it as a forward-looking cash calendar. Start with money available today, add expected customer collections and other receipts, then subtract payments such as payroll, rent, vendors, debt service and taxes. Each period’s closing balance becomes the next period’s opening balance. This makes timing visible: an invoice may count as revenue before cash reaches your bank account.
Forecast vs. budget vs. cash flow statement
These tools answer different questions. A budget sets planned income and spending, often by month or year. A cash flow statement reports past cash movements. A forecast estimates future cash using current information. Leadership needs all three perspectives: the plan, the historical record and the forward view.
| Tool | Time frame | Leadership question |
|---|---|---|
| Budget | Planned period | What did we intend to spend and earn? |
| Cash flow statement | Completed period | Where did cash come from and go? |
| Cash forecast | Upcoming weeks and months | When might cash arrive or need to go out? |
Why the forecast belongs in your weekly rhythm, not budget season
A forecast loses value when it sits untouched between planning cycles. Weekly updates let the finance team replace estimates with current information, such as a revised customer payment date, a new vendor commitment or a changed hiring plan. Review material changes, assign an owner to uncertain items and record why assumptions moved. This keeps updates focused and shows decision-makers what changed.
What a credible forecast unlocks: runway, payroll confidence and board readiness
A current forecast helps leadership examine near-term liquidity alongside longer-term runway. It can surface a gap between expected collections and scheduled payments early enough to consider options such as adjusting spend timing or following up on receivables. For board discussions and diligence preparation, it also provides a traceable view of the assumptions behind the cash position.
How to Build a 13-Week Rolling Forecast (Plus a 12-Month Runway Tab)
The dual-horizon design: next week's payroll and your 12-month runway, tied to one closing balance
Build a weekly schedule for the near term and a separate monthly view extending 12 months. The weekly schedule shows whether receipts are likely to arrive before obligations such as payroll. The monthly tab supports choices about hiring, spending and financing. Link the views through their cash balances: the final weekly balance should flow into the matching month without an unexplained gap.
Step-by-step build: opening balance, receipts, payments, timing, roll-forward
Keep the structure simple enough to maintain. A model with hidden formulas or unowned assumptions can quickly go stale.
- Set the opening balance. Start with cash in bank accounts using a consistent cutoff date.
- Schedule receipts. Estimate customer collections by expected payment date, not invoice date. Add other known inflows separately.
- Schedule payments. Use expected payment dates for payroll, vendors and other commitments.
- Calculate the roll-forward. Opening cash plus receipts minus payments gives each period’s closing cash.
- Refresh and explain changes. Update actuals, revise timing and note material differences from the prior version.
Line items that matter: AR collections, AP payment runs, payroll, deferred revenue, debt service, capex and taxes
Group cash movements so leaders can see what drives the balance. Track accounts receivable collections by likely date and accounts payable by planned payment run. Include payroll, debt service, capital spending and tax payments when relevant. For SaaS companies, distinguish cash collected upfront from revenue recognized over time: deferred revenue may affect accounting results differently from bank receipts. For inventory-led businesses, include supplier deposits, freight and fulfillment payments when their timing affects liquidity.
Direct vs. indirect methods, and when each one fits
The direct method lists expected cash receipts and payments. It often suits a weekly operating view because it shows when money moves through bank accounts. The indirect method starts with a profit measure and adjusts for noncash items and working-capital changes. It can connect a longer-range financial plan to projected cash, but may be less intuitive for managing next week’s payments. Some teams use a direct weekly schedule alongside an indirect monthly planning view.
Download the 13-week template (with monthly and scenario tabs)
A practical cash flow forecasting template should include 13 weekly periods, an opening balance, receipt and payment categories, a closing balance and a forecast-to-actual comparison. Add a monthly runway tab drawing from the weekly view, plus scenario tabs for changes in collection timing, spending or hiring. Keep assumptions visible and name the person responsible for each input. This makes the file easier to review and adapt as the business grows.
A Worked Example with Numbers: Funded SaaS and an Ecommerce Brand
Illustrative example: a Series A SaaS company forecasting collections on annual contracts
The schedule should show the expected collection date, not treat the invoice as cash received. If payment slips by two weeks, the forecast shows the effect and lets the company assess its position before committing to more spending.
Illustrative example: an ecommerce brand modeling inventory purchases and 3PL timing
Consider a hypothetical growing ecommerce brand with $80,000 in opening cash. The brand forecasts customer receipts by expected settlement date, not order date, and separates supplier payments from fulfillment costs. This shows when cash leaves the bank and when sales proceeds are likely to arrive. The amounts are educational examples, not Cypher client data.
The June inventory purchase sold across later months: how timing gaps create false shortages
The June forecast records the full supplier payment when due. Later sales receipts appear when payment is expected, based on customer payment and processor settlement timing. Looking only at June’s outflow could suggest a shortage without showing the later inflows tied to those goods. Counting expected sales proceeds before they settle can also make available cash look higher than it is.
Adding a variance column so the forecast improves every week
Add columns for forecast cash, actual cash and variance by week. For the ecommerce brand, compare planned supplier and 3PL payments with cleared bank transactions. Note material variances, such as a delayed customer, changed delivery date or revised payment plan. This turns the model into a working record of assumptions and changes.
Excel vs Cash Flow Forecasting Software: An Honest Comparison
Where Excel breaks: multi-entity, multi-currency, manual data cleanup and no live bank feeds
Excel can work when one finance owner maintains the file and inputs come from a manageable number of sources. Complexity rises when teams combine entities, currencies, accounting systems, invoices and bank activity by hand. Copy-and-paste can leave stale balances, inconsistent categories or formula errors that are hard to spot during a busy close. The spreadsheet will not show live bank activity unless someone brings it in through a connected feed or manual update. These limits concern process and scale, not the spreadsheet itself.
What software must include as standard: payment timing modeling and live bank feeds, not paid add-ons
For a growing finance team, check whether the core subscription includes live bank feeds and payment timing assumptions. A useful system lets users change when a customer is expected to pay or a vendor is scheduled to receive payment, then shows the effect on projected balances. Check that these functions work across entities and currencies and that accounting and billing data connect without recurring manual cleanup. Ask for a clear demonstration of standard features, paid add-ons and plan limits. The “cash flow forecasting software” label matters less than the workflow included in the price.
Side-by-side comparison: spreadsheets vs. FP&A planning tools vs. treasury platforms vs. accounting-native tools
Tool categories differ in setup and emphasis. A spreadsheet offers flexibility and direct control. FP&A planning tools connect cash projections with operating plans. Treasury platforms focus on cash positions across accounts and entities. Accounting-native tools keep projections close to bookkeeping data, with planning depth varying by product. Compare the workflow your team needs rather than assuming a larger system will solve data quality or ownership gaps.
| Tool type | Where it can fit | Check before choosing |
|---|---|---|
| Spreadsheet | A simple model with a clear owner | Formula controls, update steps and bank-data handling |
| FP&A planning tool | Cash planning tied to operating assumptions | Implementation effort, integrations and payment-date flexibility |
| Treasury platform | Cash visibility across accounts or entities | Forecast depth, currency support and included bank connections |
| Accounting-native tool | Projections built near accounting records | Scenario functions, data freshness and multi-entity support |
An evaluation checklist for lean finance teams: total cost, deployment speed and fit
Map current inputs, owners and update cadence before choosing a system. Ask vendors to demonstrate a delayed collection, a changed vendor payment date and a bank balance refresh using your intended workflow. Confirm total cost, including setup, integrations, user access and separately sold features. Check how quickly your team can maintain the model after implementation and whether it supports the company’s entity structure. The right tool should reduce avoidable data handling while letting finance leaders inspect assumptions and explain changes.
Common Forecasting Mistakes and the Questions Investors Will Ask
A forecast earns trust when assumptions are visible, changes are explained and the team uses it to make decisions. For growth-minded leadership, the goal is a dependable view of cash and its drivers, not perfect prediction. Compare expected and actual movements, investigate meaningful gaps and revise assumptions that no longer fit. This helps finance teams prepare clear answers for board discussions and diligence while keeping the forecast grounded in operations.
Five forecasting mistakes and the fix for each
Most forecast problems come from weak inputs or unclear ownership, not complicated math. Use this table to review the process before the next leadership meeting.
| Mistake | Why it distorts the view | Practical fix |
|---|---|---|
| Using invoice dates as collection dates | Expected cash appears earlier than it may arrive | Set a likely receipt date and flag uncertain customer payments |
| Leaving old assumptions untouched | The projection no longer reflects current commitments | Refresh changed dates and document material revisions |
| Combining all payments into one line | Leadership cannot see which obligations drive the balance | Separate major categories such as payroll, vendors and debt service |
| Ignoring forecast-to-actual differences | The same timing errors can recur without explanation | Record variances and note their cause |
| Assigning no clear update owner | Inputs can go stale between reviews | Name an owner for each key assumption and review cadence |
Scenario and sensitivity analysis: base, upside and downside views
Build scenarios around decisions leadership may need to make, rather than changing every assumption at once. A base view uses the current operating plan. An upside view could test earlier collections or stronger sales, while a downside view might model delayed receipts, higher costs or a hiring change. Sensitivity analysis isolates one driver, such as a customer payment moving later, to show its effect on projected cash. Label each case, identify its assumptions and assign someone to update them as information arrives. Scenarios are planning tools, not promises about future results.
Which questions a credible forecast answers during diligence
Investors and board members may ask what drives projected cash, which assumptions are least certain and how leadership would respond if collections shifted. They may also ask how planned hiring, vendor commitments and financing assumptions fit together. A maintained forecasting process gives the finance team a traceable basis for answering. Keep important inputs clear and compare actual results with prior expectations so the team can explain revisions without implying a guaranteed outcome.
Where to go next: turning your forecast into an investor-ready financial model
A cash forecast is one part of a broader financial model. Connecting it to operating assumptions, reporting and scenario planning can help leadership evaluate growth choices and prepare for investor conversations. At Cypher, we support growing companies with financial modeling, forecasting and CFO services, alongside accounting and reporting. The right support depends on your finance team and the complexity you need to manage. If your forecast is hard to maintain or explain, review the assumptions, data owners and decisions it needs to support.
Frequently Asked Questions
How is a cash flow forecast calculated?
A cash flow forecast starts with your opening bank balance, then adds expected receipts by payment date and subtracts scheduled payments for payroll, vendors, debt service and taxes. Opening cash plus receipts minus payments gives each period's closing balance, which becomes the next period's opening balance. We recommend pairing a detailed 13-week view with a 12-month runway outlook so near-term timing connects to longer-term planning.
What is the most common cash flow method?
The direct method is the most common approach for weekly operating forecasts because it lists expected cash receipts and payments as they move through your bank accounts. The indirect method starts with a profit measure and adjusts for noncash items and working-capital changes, which works better for longer-range planning. Many teams run a direct weekly schedule alongside an indirect monthly view.
What are the three types of cash flows?
The three types of cash flows are operating, investing and financing. Operating cash covers day-to-day receipts and payments like collections and payroll, investing cash covers capital spending, and financing cash covers debt service and equity activity. For a weekly forecast, the operating movements usually drive the near-term balance you need to watch.
What is the difference between a cash flow forecast and a budget?
A budget sets planned income and spending for a period, while a cash flow forecast estimates when cash will actually arrive or leave in the upcoming weeks and months. A budget answers what you intended to spend and earn; a forecast answers when cash moves. Leadership needs both, plus the historical record from a cash flow statement, to see the full picture.
Why should a cash flow forecast be updated weekly instead of yearly?
A forecast loses value when it sits untouched between budget cycles because timing assumptions go stale fast. Weekly updates let you replace estimates with current information, like a revised customer payment date or a new vendor commitment. Review material changes, assign an owner to uncertain items and record why assumptions moved so decision-makers see what changed.
Can a profitable company still run out of cash?
Yes, profitability and cash timing are two different things. An invoice counts as revenue before cash reaches your bank account, so a profitable company can face a squeeze if customer payments arrive after payroll or vendor bills are due. A cash flow forecast makes that timing visible early enough to adjust spending or follow up on receivables.
What should a good cash flow forecast template include?
A practical template should include 13 weekly periods, an opening balance, receipt and payment categories, a closing balance and a forecast-to-actual comparison. Add a monthly runway tab drawing from the weekly view, plus scenario tabs for changes in collection timing, spending or hiring. Keep assumptions visible and name the person responsible for each input so the file stays current.
