.png)
Cash flow forecasting is the process of developing a forward-looking view of cash. It’s enabled by functions like cash position calculation and cash flow visibility, and takes accounting records like AP, AR, payroll, debt, and taxes as inputs.
Cash flow forecasting, especially on multiple time horizons, is essential for liquidity planning. Liquidity is what keeps an organization solvent; even if margins dip or economic conditions worsen, it’s possible to stay afloat as long as liquidity is available. But planning around liquidity is more challenging than ever in 2026. The volatile rate environment, evolving funding markets, potential supply chain disruptions, and the availability of real-time data combine to result in a high bar for stakeholder to clear when forecasting cash and liquidity.
Given these challenges and the mission-critical role played by cash flow forecasting, we’ve written this guide for accounting and FP&A teams who want to understand and adopt a modern forecasting strategy incorporating automation, AI, and present-day best practices. Incorporating these principles will allow your organization to make better decisions based on more accurate data, with no added increase in manual work or need for additional headcount.
Being able to accurately forecast your organization’s cash flow is the best defense in an uncertain environment.
In order to effectively bring financial data to the attention of stakeholders, however, accountants have to do more than issue reports. With modern tools now automating or truncating much of the copy-paste work involved in traditional accounting workflows, accounting teams are increasingly expected to partner strategically with stakeholders. Forecasting is one effective way to make this ambition a reality.
Providing strategic value requires thinking beyond the immediate, mechanical reality of a cash flow forecast. In concrete terms, a forecast is concerned with questions like, “can we make payroll?”, but in strategic terms, the purpose of a forecast can also be to consider funding needs, terms for negotiating with lenders, or capex and hiring plans.
Such big-picture strategic decisions may seem too lofty to depend on daily or weekly cash flow forecasts. Consider, however, that many organizations rely purely on the month-end close to review financials, and are otherwise flying blind. If these organizations could institute daily or even weekly cash reports, they would flag liquidity issues earlier, be subject to fewer surprises, and catch errors or fraudulent activity sooner. Unless you can manage these micro issues, confidence will be lacking when you try to plan on the macro scale.
For every backward-looking report, moreover, a forward-looking forecast can provide additional context and elevate the quality of insight. Stakeholders want to know what happened in the organization’s cash accounts, but they also want to know what’s likely to happen, along with different scenarios and outlooks. When finance teams can provide these insights frequently and with unfailing accuracy, they embody the partnership-oriented accounting philosophy that modern boards and investors are increasingly looking for.
In most organizations, the responsibility for cash flow forecasting is split between two teams: accounting and FP&A.
While these are separate functions, they’re most effective when they share a single source of truth for cash and collaborate on assumptions and scenarios. In the best cases, accounting owns a reconciled, frequently refreshed cash view, and FP&A leverages that exact dataset to run defined scenarios, quantify liquidity impact, and recommend specific actions.
But this division of labor is a two-way street. For example, FP&A can identify forecast drivers that materially impact near-term liquidity (e.g., expected customer payment delays) and feed them back to accounting. Accounting can then monitor actual cash activity relative to those drivers to validate variances and flag breakdowns early. The end result is a continuous set of workflows that validate and strengthen one another.
A full cash flow forecast can be complex, although the concepts that are used to build it are basic. The following five concepts form the foundation of a cash flow forecast:
Any cash flow forecast, no matter how precise, is an estimate based on a set of assumptions. Short-term and long-term forecasts take different inputs and rely on different assumptions; likewise, accountants use different methods and apply unique treatments to cash data and line item inputs. But in all cases, the end forecast is an estimate, and probabilistic rather than deterministic.
The goal of cash flow forecasting is to estimate cash inflows and outflows over a defined period and determine the resulting ending cash balance.
Cash flow forecasting differs from P&L because it’s anchored to actual cash movement. P&L records revenue and expenses when they’re earned or incurred, regardless of when cash is collected or paid. A sale can improve P&L even if payment is not received for weeks or months, and P&L also includes non-cash items like depreciation and amortization. Cash flow forecasting, by contrast, only reflects cash that is expected to move into or out of the organization’s bank accounts.
CFOs and boards care about P&L forecasting, which estimates future performance and is essential for budgeting, target-setting, and evaluating growth plans. Cash flow forecasting, however, is the primary tool for managing liquidity. In order to meet payroll, vendor payments, and debt obligations, the organization must have cash available when those payments are due. Positive P&L does not guarantee that outcome, and cash flow forecasting is the only way to assess whether the organization can meet its obligations when they come due.
Accountants use two distinct approaches for cash flow forecasting: direct and indirect.
Direct cash flow forecasting projects cash by estimating actual cash receipts and disbursements line by line. Customer collections, payroll, rent, capital expenditures, and taxes are forecast independently before being collated for a final forecast. The direct method is most commonly used for short-term liquidity management over daily to 13-week horizons.
Indirect cash flow forecasting starts from a projected net income figure (taken from the P&L forecast) and adjusts it for non-cash items and expected changes in working capital to estimate future cash generation. The indirect method is most often used for longer-term planning and alignment with budgets and financial statements.
When your goal is to calculate short-term liquidity (for example, in order to manage payment schedules or debt covenants), the direct approach is preferable. It models actual cash receipts and disbursements by date, giving you a granular view into liquidity expectations.
When your goal is to develop long-term operating plans or structural assessments, use the indirect approach. It derives cash expectations directly from your P&L forecast, and reveals whether the organization is cash generative over longer time horizons.
For most organizations, meaningful value is created when multiple time horizons are applied to cash flow forecasts.
Short-term cash flow forecasts (spanning daily to 13-week views) are indispensable for liquidity planning, payment timing, and near-term decision-making. Without this short-term view, your organization can’t be sure that accounts will be sufficiently liquid to meet upcoming payment obligations.
Medium or long-term forecasts (spanning yearly or multi-year views) anchor larger strategic decisions. Fundraising, capital structure decisions, and budgeting plans depend on a birds-eye view of the organization’s likely liquidity and cash generation over time, rather than at one specific moment.
Organizations should leverage both short-term and long-term forecasts. The former create certainty that immediate liquidity risks and payment timing issues can be handled, while the latter create confidence around long-term plans and uncover actionable risks and opportunities. Moreover, short- and long-term forecasts feed inputs back into each other, creating a reinforcing loop of data and assumptions that fosters operational strength.
Accountants have multiple methods at their disposal when building a cash flow forecast. It’s best practice to rely on multiple techniques, particularly when the organization’s cash flow is subject to volatility.
Below are a few key methods:
To effectively combine these methods, teams first generate backward-looking baseline figures using percent-of-sales or straight-line extrapolation. On top of this baseline, market and industry dynamics can be used to adjust and stress-test assumptions. Finally, insights gained using the delphi method are incorporated to account for known upcoming events or risks.
A layered approach that relies on multiple methods will result in a more complete and three-dimensional cash flow forecast than simply using one or two baseline methods.
Given the multiple methods, approaches, and time horizons that accountants can employ when forecasting cash flows, the path to developing an effective, repeatable process isn’t always clear. Below, you’ll find a framework that details the actual steps required to build a cash flow forecast, from start to finish.
First, identify every system, report, or source of information that relates to your organization’s cash. These can include:
No matter whether you’re compiling a daily, 13-week, or yearly cash forecast, you want to use reconciled cash balances. Without a reconciled cash view, your opening cash (the starting point which your entire forecast is built on) cannot be trusted. That’s a problem, because even a minor error can cascade through your calculations, calling the entire forecast into question.
Such errors become more common when portions of your workflow are handled manually. Manual processes like CSV exports across multiple data sources or copy-paste spreadsheet wrangling tend to introduce more errors (along with more data lags) relative to integrated feeds. If your objective is to accurately forecast the organization’s cash, then it’s essential to begin with an accurate snapshot of the organization’s current cash.
Next, it’s time to design your forecast.
While different forecast horizons serve their specific purposes, it’s also important to identify the time buckets that will feature in your forecast.
Time horizon is the total length of time covered by your forecast (e.g., weekly, 13-week, yearly).
Time buckets define how your time horizon is divided (e.g., weekly buckets for a 13-week forecast, monthly buckets for a yearly forecast).
Bucketing is deceptively important. Using overly fine buckets on a long time horizon can result in a highly precise forecast that nevertheless lacks signal. Using overly coarse buckets on a short time horizon can skip over important variance, masking near-term liquidity risk. The best combination of horizons and buckets achieves clear visibility into cash risk without creating unnecessary complexity or false precision.
Below are some general bucketing guidelines:
Weekly forecast:
Use daily buckets. At this horizon, cash decisions are timing-sensitive, and even a one-day delay in a large inflow or outflow can matter.
13-week forecast:
Use weekly buckets. This is the standard horizon/bucket structure for short-term liquidity management.
Yearly horizon:
Use monthly buckets. Monthly aggregation aligns with the close cycle, budgeting process, and working capital analysis.
5-year horizon:
Use annual or quarterly buckets. On this time horizon, long-term drivers and directional trends dominate.
Now, it’s finally time to forecast, starting with collections.
Your goal when modeling cash collections from existing AR is to arrive at a reasonable estimate of how much cash will arrive in your accounts, and when, based on AR aging and historical collection patterns. In general, the longer an invoice is outstanding, the higher the likelihood of late payment (or default).
For example, you might assign these ballpark probabilities to the following aging buckets:
Then, using the following AR bucket values and the midpoint of each probability range above, you might calculate the following cash inflows:
In total, this forecast assumes your organization will collect $131,000 out of a $200,000 AR balance over the next month.
Otherwise, you can use a DSO (Days Sales Outstanding) calculation, which summarizes the average collection period for all receivables into a single number, allowing you to estimate cash inflows based on total AR.
With your collections forecast in hand, the next step is to layer on additional inflow channels:
Taken altogether, inflows from these channels can be combined to generate a reasonably accurate forecast for expected cash inflows over the given period.
Once inflow projections are complete, outflow projections are next. Start by separating operating and non-operating outflows, and creating a list of each.
Operating outflows are cash payments that arise from a company’s core business activities, including paying suppliers, employees, taxes, and routine operating expenses. These outflows are recurring and predictable, and reflect the “cost of doing business”. They include:
Non-operating outflows are cash payments that stem from activities outside normal operations, like debt repayment, capital expenditures, or investment purchases. These outflows are irregular and often require modeling using scenario analysis.
Note that some recurring payments are still classified as non-operating (for instance, debt payments) because they relate to financing, and not to the organization’s regular operations.
When you model these outflows, be sure to use historical patterns, payment terms, and seasonality to estimate timing and amounts for operating outflows, while using assumptions or scenarios for non-operating outflows. This ensures that your forecast captures both the predictable cash demands of day-to-day operations and the irregular outflows that vary across periods.
You’ve modeled inflows and outflows, and you know your opening cash based on trusted, reconciled balances across all cash accounts. These figures are sufficient for you to calculate net cash and an ending balance:
Net cash = total cash inflows - total cash outflows
Ending balance = opening cash + net cash
Helpfully, the ending balance of the forecasted period feeds into the opening cash for the next forecast period. When forecasting multiple periods, this creates a continuous chain, ensuring that each period’s projection reflects the cumulative effect of inflows and outflows.
Ultimately, the goal of your forecast is to arrive at accurate ending balances based on thoughtful, multidimensional forecasting. Along the way, you may identify certain noteworthy events like covenant breaches, minimum cash violations, or negative balances in accounts. Note these in your forecast with simple flags, as they can provide useful context beyond net cash and ending balances.
Your cash flow forecast is complete and reflects the totality of expected inflows and outflows. It uses reconciled opening cash and delivers an accurate estimate of ending balances. The final step is to operationalize this process.
13-week forecasts with weekly time buckets, which many organizations use as their de facto short-term forecasting structure, should be refreshed at least weekly. (Tight liquidity or exceptional volatility may merit more frequent refreshes.) Accomplish the refresh by replacing the prior week’s forecast with actuals, reconciling variances, and simply rolling forward by one week.
This weekly cadence will ensure that your cash flow forecast reflects the most recent data and accounts for irregularity in both inflows and outflows, enabling stakeholders to take corrective action or update assumptions accordingly.
From a procedural standpoint, you’ll also want to exercise version control and governance. A weekly process can become cumbersome if too many owners, approvals, or manual sign-offs are involved; keep it lightweight and leverage automation where possible to maximize impact while minimizing operational burden.
The #1 Cash Management Tool for Accounting Teams
Given the complexity and number of steps involved in developing a cash flow forecast, there are bound to be significant pitfalls, roadblocks, and constraints along the way. In particular, organizations that rely on manual work to calculate cash will encounter frustrating and time-consuming obstacles.
If your goal is to establish a better cash flow forecasting process, you can save time and effort by preemptively studying the common challenges (and their solutions) listed here.
When the data that forms the foundation of your cash forecast is out-of-date or off-target, everything downstream of it will be suspect.
Typical threats to the accuracy or timeliness of your cash data can include unreconciled cash accounts, delayed posting of entries in the ERP or GL, and issues stemming from using multiple bank data imports. Stale and inaccurate data are, in fact, both symptoms of the same underlying flaw: an overreliance on manual processes. When your team is responsible for importing, reconciling, and posting data manually, with no automation or AI support, the time required to complete workflows is longer and the risk of error and fraud is higher.
In addition to implementing automated bank feeds and reconciliation automation with the help of a platform like Numeric, you can improve how data flows into your forecasts by tightening the cadence of reconciliations. The reconciliation process itself helps to match and validate transactions and catch inconsistencies, so more frequent reconciliations means more consistent inputs for your forecasts.
Like an overreliance on manual data imports, heavy reliance on spreadsheets extends each step of the cash flow forecasting process. Even in small or mid-sized organizations, this increases the likelihood of errors and reduces the forecast’s ability to surface risk by the time it becomes available to stakeholders.
In larger organizations with multiple entities and bank accounts, spreadsheet-based forecasting can fundamentally limit the organization’s ability to act. Cash constraints and liquidity risks are often embedded within fragmented, entity-level data that must be manually consolidated. Spreadsheets also offer limited version control and require significant ongoing maintenance, leaving teams focused on keeping the model functional rather than reviewing results.
While spreadsheets may be adequate as an initial solution, they do not scale with transaction volume, organizational complexity, or more frequent forecasting cadence. In practice, spreadsheets often depend on a single individual to maintain macros and links, creating operational bottlenecks and key-person risk.
Spreadsheets should be used where appropriate, but teams should prioritize tools that support automated data ingestion and centralized version control as the organization’s forecasting needs evolve.
A high-quality cash flow forecast doesn’t smooth over inconvenient truths in an organization’s cash movement. Effective forecasting captures how cash actually moves across accounts, including irregularities, and explicitly incorporates complicating factors like seasonality, timing differences, and AR quality.
Many businesses, for example, see revenue spikes in Q4, while renewals, churn, and other seasonal factors can materially affect both short-term and long-term cash inflows. If these dynamics aren’t explicitly modeled, forecasts tend to appear artificially smooth, masking periods of cash pressure and increasing the risk of unexpected liquidity shortfalls.
AR quality is another common source of forecast distortion. A small number of chronically late-paying customers can materially shift cash timing and undermine forecast accuracy. Without incorporating AR aging, DSO trends, and historical payment behavior, inflow projections often assume timely collections that don’t ultimately occur, creating a misleading sense of liquidity.
The best forecasts provide a realistic perspective on your organization’s cash flows, risks and all. Don’t overlook timing risks, and commit to delivering the most complete, actionable insights possible (even if establishing the necessary processes takes more time and effort).
Modernizing your cash flow forecasting can create cascading positive effects across your organization. Clearer forecasts lead to better risk management, smarter liquidity allocation, and quantifiable bottom line impact (in addition to operational efficiency, team member satisfaction, and other intangible gains).
Numeric supports cash flow forecasting by providing the highest-quality inputs to your model. With reliable reconciliation automation and integrated bank feeds, your team can rest assured that their model is ingesting reliable data from Numeric, and can focus on building the highest-quality forecast rather than wrangling fragmented data sources.
Best-in-class cash data is the only valid input for a truly accurate cash flow forecast. With Numeric, your data layer is complete, accurate, and embedded with modern project management tools to ensure processes are accountable and repeatable. If forecasting is essential for organizational liquidity, consider building the process from the ground up and leveraging a data layer that unlocks value across your entire accounting stack.
In 2026, cash flow forecasting is moving away from static spreadsheets and infrequent updates. Rolling forecasts grounded in current, reconciled data have been shown to create value for shareholders, and are eminently achievable with today’s. Cash flow forecasts are no longer retrospective explanations; today, they function as forward-looking controls.
The limiting factor for most teams is not modeling capability, but the reliability of the underlying cash data. Without a trusted system of record, even well-designed forecasts inherit the same timing gaps and reconciliation issues that undermine confidence and slow decision-making.
Numeric solves this problem by anchoring cash flow forecasting to reconciled, up-to-date cash data. By giving accounting and FP&A a shared source of truth, Numeric enables teams to produce forecasts that surface risk earlier and stand up to stakeholder scrutiny.
If your team is looking to enter 2026 with more reliable cash visibility and fewer surprises, schedule a demo to see how Numeric supports modern cash flow forecasting.