The cash flow forecast: A CFO's secret to better budgeting

For the mid-market CFO, manual cash flow reporting creates an operational blind spot. In these cases, leadership is forced to navigate timing mismatches and inconsistent inputs that obscure true liquidity. This friction is a widespread bottleneck: 60% of finance leaders report that a lack of data accessibility is the primary factor holding them back.

Solving this requires a shift to business process automation for cash flow forecasting. By integrating accounting software with every operational touchpoint, firms eliminate the latency between a transaction and its reporting. This creates a single source of truth, where entity-wide data refreshes instantly as invoices are settled.

In this article, we'll cover the importance of cash flow forecasting for mid-sized businesses and the four main types of forecasting CFOs use.

What is a cash flow forecast?

A cash flow forecast is a prediction of how money moves in and out of a company within a given time period. For CFOs, this matters because it shows when cash will be available to meet bills and invest.

A company can be profitable on paper but still face a liquidity crisis if intercompany timing gaps or subsidiary-level cash vacuums emerge. For CFOs, the challenge is often the staggered timing of project revenue or unexpected capital calls that create friction across entities.

Cash flow forecasts show when timing gaps between incoming and outgoing cash could strain liquidity and solvency.

Its two key components are:

• Cash inflows: This includes payments from customers, returns on investments, drawdowns from credit facilities, and receipts from grants or the sale of assets.
• Cash outflows: This includes payments to suppliers, wages, overheads (like rent, utilities and insurance), repayments on credit facilities, the purchase of assets, and taxes.

The difference between your cash outflows and cash inflows is your net cash flow.

Positive net cash flow is when you take in more money than you spend over the given time period. Negative net cash flow is the opposite: you spend more than you receive.

How it works

To prepare a cash flow forecast for your company, take these steps:

• Choose a timeframe: Decide on the period you want to forecast. That could be, for example, three months for short-term operations or 12 months for long-range planning.
• Estimate your inflows: Project all the cash you expect to receive based on customer payment terms, past collection patterns, and any upcoming sales you’re planning.
• Estimate your outflows: List all of the payments you expect to make, including to employees, suppliers, lenders and in tax. Include any items you’re likely to commit to during that period, like planned hires or staff bonuses.
• Calculate your net cash flow: Subtract the outflows from the inflows over the period to get your net cash flow.

The forecast will show you when, during the time period you’ve chosen, income exceeds expenditure and vice versa. You’ll be able to see:

• When inflows exceed outflows, you could put the capital to work to, for example, invest in new stock.
• When outflows exceed inflows, you need to protect your working capital and cut back on costs.

Why is cash flow forecasting important?

Cash flow forecasting is important because it provides CFOs with an integrated, operations-based view of their company’s liquidity.

This visibility helps them manage working capital in line with longer-term strategic priorities. It’s about knowing where you are now and where you may be in the future. Cash flow management is an essential part of active financial stewardship for a business.

Risk mitigation and liquidity assurance

In a 2023 FTI Consulting survey, CFOs cited inflation and the cost of borrowing as two significant risks facing their businesses.

High-fidelity forecasting provides an early-warning system for enterprise-level risks, such as impending covenant breaches or escalating DSO across specific entities.

This gives them enough time to:

• Arrange additional financing
• Refinance existing facilities at lower rates
• Negotiate with vendors on price and payment terms
• Cut spending across the business

Without planning, cash issues surface only when balances are already low, limiting the options available to fix them.

Example: The CFO of a distribution company notices that a large customer payment is due the same week that quarterly tax and debt servicing payments go out. Even if the customer pays on time, this will leave their working capital level very close to their banking covenant threshold.

To mitigate the threat, they contact three suppliers they’re due to pay around the same time who agree to split payments over two months. They also arrange a short-term facility in advance for further cash and covenant protection.

Strategic decision-making

Although CFOs are still concerned with short-term financial management, 55% now identify long-term planning and resource allocation as their top priority, according to McKinsey.

The more confident CFOs are about their future cash positions, the more confident they are providing evidence and direction on the following types of decisions:

• When to buy equipment: Working out the optimal timing for asset purchases or equipment financing.
• When to manage debt: Lining up debt facilities well in advance to cover leaner periods and knowing when there’s surplus cash available to pay down loans early.
• When to invest: Timing the acquisition of a competitor or committing to product development initiatives that can improve future net operating profit after tax (NOPAT).

Example: A manufacturer of outdoor power equipment typically increases inventory in Q4 and Q1 to prepare for summer demand for lawn mowers, trimmers, and other garden equipment.

In Q1, working capital is tied up in raw materials and labor costs, but by the start of Q3, they expect to have collected $800,000 in receivables and built up surplus cash. The CFO advises the board to delay a planned acquisition to Q3 to minimize borrowing requirements for the takeover.

4 types of cash flow forecasts

Different time horizons answer different questions and allow you to test a variety of assumptions. Use the following four types of cash flow forecasts so you get the broad view you need across your business on liquidity, performance, and strategic headroom.

The 13-week rolling forecast

A 13-week rolling cash flow forecast is the operational gold standard for managing liquidity.

Finance teams update it weekly so it captures the latest sales, project, and payment data. This gives CFOs a clear view of how cash moves through the business each quarter, including payroll, rent, supplier payments, inventory replenishment, tax, and debt servicing.

Example: A construction firm uses a 13-week forecast to connect progress billing across three large projects, retention releases, and collections from smaller jobs.

Then, a rep wins a large order that’s due to start in week nine on 60-day terms. Cash from the project won’t come in until week 17.

Recognizing that funding the upfront materials and mobilization costs will create a subsidiary-level cash vacuum that could trigger a group-wide liquidity strain, the CFO arranges a covering facility weeks in advance to protect the parent company’s position.

Monthly forecast

Monthly forecasting is the standard model for internal reporting and budgeting cycles in mid-sized businesses.

While some companies build a new forecast each month, others project 6 to 12 months ahead and update each month as new data comes in. This approach helps companies understand how their actual performance compares with the budget and assess whether they can cover upcoming monthly debt or interest payments.

Example: A mid-market manufacturer’s forecast flags a dip in working capital during the annual maintenance shutdown in three months’ time.

The problem is that, at the same time, a quarterly tax payment, large raw material order, and insurance renewal are due in the shutdown month. To avoid an overdraft breach, the CFO negotiates split payments on the renewal and inventory, smoothing the cash cycle across the entity.

Annual forecast

CFOs create annual forecasts for strategic planning and capital budgeting. Sometimes, they’re just for the next year but some businesses project up to three years in advance.

This gives boards the vision they need to test:

• Expansion plans
• M&A activity
• Long-term debt financing positions and covenant headroom

Lenders also rely on them to see when new projects will generate enough cash to service debt and support ongoing investment.

Example: A hospitality group creates a three-year forecast to model a new site development. The CFO factors in not only the localized construction costs and revenue ramp-up but also the cross-entity billing cycles and seasonal demand fluctuations observed at nearby locations.

They model the build three years out, factoring in items like construction costs, pre-opening payroll, and revenue ramp-up. This shows the lender that they can manage cash flow without needing extra cash until the site becomes profitable.

Scenario planning

Companies use scenario planning to test how resilient their business is to various positive and negative “what if” scenarios.

Scenario planning involves running multiple forecasts. You test to see how variations in factors like revenue, revenue growth, expenditure, gross margins, and other metrics affect your viability.

Example: Risk management in construction projects allows CFOs and project managers to measure how setbacks like overruns, delays, and price increases affect the profitability of a project. In this case, a contractor models a client paying after 60 days and not 30, and steel input prices rising by 8%.

They find that this means cash falls below the safety buffer in the fourth month. To mitigate this, the CFO tightens change control conditions, requires faster payment terms and arranges a short-term bridge facility to keep the company within its covenants.

How to forecast cash flow in 5 steps with Intuit Enterprise Suite

Precise, reliable forecasting requires constantly updated, accurate data. You can’t achieve this from spreadsheets, but you can from connected software. They also provide the analytic tools you need to turn raw data into actionable reports that the board can use.

CFOs can do this in Intuit Enterprise Suite by taking the following five steps.

Step 1: Automate data integration

The system you’re using must be able to draw live and historical data from a real-time central database. It won’t work if you rely on a finance team member to interpret and re-key numbers into a new spreadsheet from multiple departmental spreadsheets.

The information you need at the very least is:

• Accounts receivable (A/R) aging
• Accounts payable (A/P) aging
• Historical profit & loss data

Before you start forecasting, run a cash reconciliation so your ledger matches the bank before you rely on any numbers. You can then start building cash flow forecasts.

Example: A family-owned components group relied on weekly spreadsheets from its three factories. Now, they can pull A/R, A/P and payroll directly from each site.

The CFO notices that one of the group companies is scheduled to pay for a large bulk material order and repay an intercompany loan in the same week. This will push its working capital dangerously low. The CFO splits the material order into two deliveries and moves the loan repayment back a week, so cash stays above policy without taking extra external finance.

Intuit Enterprise Suite: You can automate data integration in Intuit Enterprise Suite with advanced ecosystem connectivity.

By integrating selected QuickBooks apps and disparate data sources, the suite can function as a centralized hub for your cash flow forecasting. Depending on your specific configuration, you can link core accounting data and associated operational apps to your group companies to gain a more comprehensive view of group-wide liquidity.

Step 2: Segment operational details

A single blended view of group or company cash flow may look, on the surface, healthy but it may also be hiding divisions, entities, and projects that are under pressure. Segmenting them by driver lets you see which parts of the business generate cash and which parts are drawing down cash or putting a strain on working capital.

Example: A clothing manufacturer has multiple plants, and the 13-week group forecast looks comfortable.

They run a cash flow forecast and discover that the cash flow at one factory turns negative in week ten, as this is when a new line change is due to be installed. Because revenue dips for a few weeks, the CFO sets up a temporary internal loan to prevent the site from going into overdraft. This saves interest costs and prevents a possible external loan covenant breach.

Intuit Enterprise Suite: Intuit Enterprise Suite supports dimensional tagging (like project, plant, product line, or region), allowing you to categorize transactions as they occur. By assigning these attributes, you can gain more granular visibility into profit and cash flow by segment, helping to identify which specific business units are driving liquidity.

Step 3: Project cash inflows

From your accounts receivable (A/R) aging report, examine your open invoices, promised payment dates, and historical collection patterns.

This will help you see more clearly when individual customers are most likely to pay. It also lets you spot timing gaps between when you book revenue and when cash actually arrives.

With AI-assisted forecasting, finance leaders can use Intuit Enterprise Suite to analyze cash inflows to support more realistic timing assumptions. This baseline allows you to refine your forecast with greater precision, ensuring your projections are rooted in actual historical performance.

Example: 85% of a manufacturer’s revenue comes from three national retailers. Using A/R aging in Intuit Enterprise Suite, the CFO spots that one retailer now pays after 50 days on average, much higher than their previous 32 days.

Their cash flow forecast shows that this may cause a problem in seven weeks, when they need the cash to meet payroll and sales tax payments. The CFO sets up a modest invoice-finance line against those receivables and offers a small early-payment discount to encourage faster payment.

Intuit Enterprise Suite: The platform includes pre-built 13-week and 12-month cash flow forecasts. Pull income history from your chart of accounts to populate it, then filter and slice the data to spot patterns, outliers, or timing mismatches. So, you get a clearer view of upcoming cash needs and can interrogate day sales outstanding (DSO) by customer, sector, or project.

Step 4: Project cash outflows

Using accounts payable (A/P) as your base, create a schedule of supplier terms, expected invoice volumes, and fixed overheads like payroll, utilities, insurance, committed capex, and tax.

This gives you a clear view of what happens if you negotiate a 45 day payment window with suppliers instead of the current 30 days. Achieving this might:

• Free up cash to bring forward upgrading equipment and machinery by a quarter.
• Help you build up a bigger cash buffer to cover slower months or unexpected costs without needing to borrow.

Example: A cardboard manufacturer builds an outflow forecast from its A/P aging, payroll, and planned capex data. The CFO notes that the cash balance looks positive and high. But, in two months, they need to pay the rent, a quarterly loan repayment, and add a tooling upgrade in the same month.

To mitigate, the CFO negotiates with the supplier providing the tool upgrade and they agree to send three monthly invoices instead of one for the work. This smooths out the cash curve and preserves the company’s required minimum level of working capital.

Intuit Enterprise Suite: Use the AI-assisted cash flow to analyze historical spending patterns and receipt timing, to populate a 13-week view of projected inflows and outflows. By automatically pulling in data from open bills, payroll, and past financial activity, the system establishes a baseline for your short-term liquidity.

Step 5: Model risk and scenario test

Once you have a solid inflow and outflow forecast, turn it into a decision tool by running structured scenario tests.

Run these on Intuit Enterprise Suite by adjusting your current assumptions on sales, collections, payment timing, and investments.

Example: An auto parts manufacturer wants to expand capacity with a new production line. They build three models in Intuit Enterprise Suite, one assuming current demand, one assuming a fall in sales of 10%, and one showing customers taking an extra 10 days to pay.

Both downside scenarios show cash levels dropping close to the bank’s covenant threshold during the quarter the company takes ownership of the new production line. The CFO recommends that the project go ahead, but that the board delay a nonessential capital expenditure (capex) item and agree to an additional revolving facility. That way, they do not risk breaching covenants in either downside scenario.

Intuit Enterprise Suite: In Intuit Enterprise Suite, first create a detailed three-way financial forecast or an AI-assisted cash flow forecast. Choose the length of forecast, the sources of information, the methodology you want to use, and then adjust the key drivers like growth rates, margins, and timings to run a report.

Intuit Enterprise Suite also allows you to forecast across multiple entities, so you can spot timing mismatches, shared risks, and surplus cash across the group.

Boost productivity and enhance profitability

High-fidelity forecasting transitions the CFO from a reporter of history to a strategic architect of capital. In a multi-entity environment, the board relies on finance to provide the scenario confidence needed to navigate volatility.

By replacing manual processes with integrated technology, you optimize working capital efficiency and ensure the group maintains the liquidity required for long-term growth.

Find out more about Intuit Enterprise Suite and book a call with one of our advisors to see how it supports multi-entity complexity.