Ask most finance teams how they forecast cash flow, and the honest answer is a spreadsheet someone rebuilds every Friday — half of it pulled manually from open invoices, half of it educated guessing about when customers will actually pay. It works, sort of, right up until the week it doesn't, and someone discovers a payroll run and a large vendor payment were about to hit the same account on the same day.
The frustrating part is that Business Central ships with a genuine cash flow forecasting engine built to solve exactly this — pulling live data from payables, receivables, and budgets automatically instead of requiring someone to manually reconstruct the picture every week. Most companies simply never turn it on, or set it up once, incorrectly, and quietly abandon it a month later.
Here's what the native tool actually does, and how to configure it so it's worth trusting.
What the Cash Flow Forecast Page Actually Shows
The Cash Flow Forecast page in Business Central projects your cash position forward across a defined time horizon, broken into periods you control — weekly, monthly, or otherwise. It combines your current liquid funds with projected inflows and outflows pulled from live transactional data, rather than requiring anyone to manually estimate what's coming.
Done properly, it answers the specific question every Controller actually needs answered: not "what's our cash balance today," but "will we have enough cash on the 15th, after that payroll run and before that customer payment clears."
What Actually Feeds the Forecast
The forecast is only as good as the sources feeding it, and BC pulls from several places that need to be configured correctly to produce a number worth trusting.
1. Liquid Funds — Your Starting Point
Liquid Funds represent your current cash position: bank accounts and other immediately available funds. This needs to be accurate and current, which usually means your bank reconciliation process needs to be reasonably tight — a forecast built on a stale starting balance is wrong before it even projects forward.
2. Payables and Receivables
Open vendor invoices feed projected outflows, and open customer invoices feed projected inflows, both timed according to due dates or payment terms. This is where most of the forecast's real value comes from — it's live data, not a guess, and it updates automatically as invoices get created, paid, or adjusted.
The accuracy here depends entirely on whether payment terms are set up correctly and consistently across customers and vendors. A forecast that assumes every customer pays on the invoice due date, when your actual average is 15 days later, will be optimistic in a way that quietly undermines trust in the whole tool.
3. Sales and Purchase Orders
Beyond posted invoices, BC can incorporate open sales orders and purchase orders that haven't yet been invoiced — giving visibility further out than payables and receivables alone would provide. This is particularly valuable for businesses with longer lead times between order and invoice, like manufacturers or distributors managing significant purchase commitments.
4. Budgeted Amounts
For periods beyond what's covered by actual open transactions, the forecast can pull from G/L Budgets — giving a projected view even for cash flows that don't yet exist as concrete transactions. This is where a forecast stops being purely reactive and starts genuinely projecting forward, provided the underlying budget is realistic and kept current.
5. Recurring and Manual Entries
Not everything fits neatly into payables, receivables, or budgets. Payroll, loan payments, tax remittances, and other recurring cash events can be entered directly as Cash Flow Manual Expense/Revenue entries, ensuring the forecast reflects reality rather than just what happens to be sitting in the AP/AR ledgers.
Setting It Up Properly
Configure the Chart of Cash Flow Accounts
Before the forecast means anything, the Chart of Cash Flow Accounts needs to be built out — a structure separate from your G/L Chart of Accounts that categorizes cash flow sources (operating, investing, financing) in a way that matches how your organization actually thinks about cash movement. Skipping this step is the single most common reason companies set up the forecast once and then find it unusable.
Map Your Source Types Correctly
In Cash Flow Setup, each source type — payables, receivables, budgets, fixed assets, tax — needs to be mapped to the right cash flow accounts and assigned an appropriate delay or adjustment where relevant. This is a one-time setup task that pays off every week afterward, but it does require someone to sit down and think through the mapping deliberately rather than accepting defaults.
Choose a Realistic Forecast Horizon
A 13-week rolling forecast is a common standard for good reason — long enough to catch problems with lead time to act, short enough that the underlying data (open invoices, near-term orders) is still reasonably reliable. Forecasting a full year out using this tool tends to lean heavily on budget data rather than live transactions, which is a different — and less trustworthy — kind of forecast.
Reconcile Actuals Against the Forecast Regularly
The forecast should be checked against what actually happened, regularly — not set up once and trusted blindly. If actual cash consistently comes in meaningfully different from forecast, that's a signal something in the setup — payment term assumptions, a missing manual entry pattern, stale liquid funds data — needs adjustment.
Why Most Companies Never Get Here
The honest reason most companies abandon this tool isn't that it doesn't work — it's that proper setup takes real thought, and the payoff isn't immediately obvious until you're relying on it during a genuinely tight cash period. Spreadsheet forecasting feels more controllable, even though it's slower to build every week and more prone to human error.
The companies that do get this right tend to treat setup as a one-time investment worth doing carefully, rather than something to configure quickly and revisit later — because "later" rarely comes until there's already a cash crunch forcing the issue.
Where to Start
If your Cash Flow Forecast page has sat untouched since implementation, the fastest path forward is auditing three things: whether your Chart of Cash Flow Accounts actually reflects how your business thinks about cash, whether payment terms are set up accurately enough to trust the receivables and payables projections, and whether recurring cash events like payroll are captured as manual entries or simply missing from the picture entirely.