FOXNUT AI

Comparison

Does automated cash flow forecasting actually work?

Automated cash flow forecasting works for the known items. Predicting when customers pay is unproven, so treat those dates as a range.

By the Foxnut team · Updated

Does automated cash flow forecasting work?

Automated cash flow forecasting works on one half of the problem and is unproven on the other, because half of a cash flow forecast is arithmetic and half is a guess about other people. Almost every disappointment with this software comes from buying one half and being sold the other. The arithmetic half is everything already contracted: payroll, rent, tax, debt service, standing orders, the payables run with dates attached and the receipts already banked. Assembling it is a data-plumbing job with a known answer, and automating it is uncontroversial.

Foxnut AI is a senior-only practice in Bengaluru and Paris. One of the four arrangements below, the payment-date model, is the kind of system we would build and hand over, and it is the right answer least often. There’s a link to talk to us at the end of this article. Let’s first find out which half of your forecast is worth automating.

The other half is when customers actually pay, and that is not a fact about the company holding the forecast at all. In 2024, suppliers across the European Union reported average agreed business-to-business payment terms of 43 days and an average actual payment period of 60.3 days. That is a gap of roughly seventeen days between the date in the ledger and the date the money arrives.

So the decision in front of a finance team is not whether to automate the forecast. It is which of four arrangements it can live with, and how much of the second half it will pay a machine to guess. Settle what that kind of build has to leave behind, and who owns a forecasting model after the build, before any of this.

What are the four arrangements for cash flow forecasting?

The four arrangements are a spreadsheet, the accounting package’s own projection, a treasury platform and a payment-date model. What separates them is not sophistication. It is what each one assumes about payment dates, and what it does when that assumption is wrong.

AxisSpreadsheet rebuilt from ledger exportsThe accounting package or ERP’s own projectionTreasury platform with bank connectivityA payment-date model on the company’s own history
What it producesA period-by-period position, rebuilt by hand from open items and a bank balanceThe same position, generated from open receivables and payables inside the system of recordA consolidated multi-account position with scenarios layered over itA predicted payment date, or a probability of payment in a window, for each open invoice
What it assumes about payment datesWhatever the preparer types, which is usually the due date adjusted by memoryThe due date, treated as the payment dateThe due date, plus rules or averages the treasurer configuresThat past payment behaviour predicts future payment behaviour at the account level
Where it breaksStaleness, and a version history nobody can auditThe seventeen-day gap between terms and reality, applied silently across every open invoiceRule maintenance, and scenarios that multiply faster than anyone reviews themCounterparty behaviour that shifts, thin history on new accounts, and disputes the ledger never recorded
What it costs to keep runningThe preparer’s hours, every cycle, foreverLittle, if the underlying ledger is clean and the bank feed is connectedLicence, bank connectivity, and an owner for the rule setA maintained model, a monitored data feed, and someone who can tell drift from noise
Who owns it after go-liveThe person who built it, and nobody elseThe finance system’s administrator, by defaultWhoever the vendor trained, if anyoneThe trained internal team the system was handed to

The second row decides most cases. Three of the four arrangements use the contractual due date as the expected payment date, and the published evidence says that date is systematically optimistic. The fourth tries to correct it, and the question is whether that correction is reliable enough to act on.

What does the decision to automate cash flow forecasting turn on?

The decision turns on six structural dimensions. Cash flow forecasting reads unusually on three of them: the variance being modelled belongs to other organisations, the regulatory exposure is nil for most of the year and then briefly serious, and the software market is mature at the half of the problem that was never hard.

Cash flow forecasting: process profile
DimensionWhat it reads on cash flow forecastingSource
Exception varianceThe exception is the subject. Average agreed business-to-business terms across the EU were 43 days in 2024 against an average actual payment period of 60.3 days, and public authorities paid 9.5 days later still. The variance is structured by country far more than by sector: payment performance varies more between Member States than between sectors within one country, and construction was the most punctual sector in six Member States while being the worst performer in three others. A prior learned in one market does not transfer to another.EU Payment Observatory, Annual Report 2025
VolumeNot invoice count. A forecast is produced on a cadence, so the effort does not scale with lines; what scales is the number of counterparties whose behaviour has to be tracked and the collections work behind it. Companies report spending an average of 9.85 hours a week chasing late payments, and 52% report facing problems from late payments in 2024, five points more than in 2023. Those hours, not throughput, are the payback condition.EU Payment Observatory, Annual Report 2025
Cost of an errorAsymmetric, and paid in financing. An optimistic forecast costs an unplanned draw, a missed supplier payment or a fee; a pessimistic one costs idle cash and deferred commitments. The scale of the underlying constraint is not small: the European monitoring report estimates that EU micro companies, SMEs and intermediate-sized enterprises would have over EUR 100 billion a year in additional cash flow if late payments stopped.EU Payment Observatory, Annual Report 2025
ReversibilityHigh for the forecast, low for the action taken on it. A projection can be rerun at negligible cost, and error compounds with horizon rather than being locked in: a probabilistic model trained on more than 3.5 million transaction entries from over 1,000 SME customers forecast 12 weeks ahead, and its authors record that multi-step prediction accumulates error iteratively and that the results could hardly meet the required coverage. The irreversibility sits in the decision, not the document.Kotios and others, Journal of Big Data, 2022
Regulatory exposureNil for most of the year, then briefly and specifically serious. A cash flow forecast is not a book of record, but management's going-concern assessment covering at least twelve months from approval of the financial statements commonly rests on one, and the auditor is required to apply professional scepticism when reviewing future cash flow. Audit procedures include checking the forecast's arithmetic and testing whether it is inconsistent with forecasts prepared for other purposes such as impairment or deferred tax, where the underlying data would be expected to be the same.ISA (Ireland) 570 Going Concern, Revised October 2019
Vendor market maturityMature at the plumbing, unproven at the prediction. Bank connectivity, ledger integration and scenario tooling are long-established commodities. Predicting when an individual invoice will be paid is not: a prototype built with a multinational bank reported up to 81% prediction accuracy, improved from up to 77% in the earlier report of the same work, and the stated obstacle is that the decision-making process is not registered in the accounts receivable system at all.Appel and others, arXiv:2008.07363 and arXiv:1912.10828

Two of those rows carry the argument. The exception-variance row says the thing being forecast is a behaviour belonging to somebody else, in an economy where the average payer runs seventeen days past the terms it agreed to, and where the shape of that lateness is a property of the country rather than of the industry.

The vendor-maturity row says information the forecasting company does not hold sets the ceiling on correcting for it. The reason an invoice is being withheld is decided inside the customer’s payables department and is not written down anywhere the model can read.

The regulatory row changes what a good system looks like. For most of the year nothing here is attested to anyone. Once a year the same forecast, or one built from the same data, sits underneath a going-concern assessment. An auditor examines it with explicit professional scepticism, checking its arithmetic and whether it contradicts the forecasts prepared for impairment or deferred tax.

That procedure does not reward point accuracy. It rewards a forecast whose assumptions are written down, whose data lineage is traceable, and which produces the same numbers as the other forecasts built from the same ledger. A system optimised for a single best-guess figure, unable to show its workings, is worse at the one moment of the year when the forecast is actually inspected.

When should you choose each arrangement?

Choose by the shape of your company, because each arrangement wins a real category of company. The failure modes are asymmetric, which is why the order matters more than the sophistication of any one of them.

When does the spreadsheet win?

It wins when the position is simple, the counterparties are few, and the person who maintains it knows them. A single bank account, a dozen customers and a finance lead who can say which of them pays on the fifteenth regardless of terms is a forecasting system with better information than any model would have. The knowledge that matters is relational, not statistical.

Failure mode: it exists once and nowhere else. There is no version history, no way to see which assumption moved between two versions, and no continuity when the preparer leaves. The upgrade worth making is almost never a forecasting product. It is connecting the bank and the ledger so the sheet stops being retyped.

When does the accounting package or ERP projection win?

It wins whenever it is already licensed and the ledger underneath it is clean, which is more often than it is used. It reads open receivables and payables directly from the system of record, so it cannot drift from the books, and it costs nothing further to run. Settle this before considering any build, because a large share of what gets scoped as a forecasting project is an unconfigured module and an unconnected bank feed.

Failure mode: the due-date assumption applied silently. Every open invoice is projected to land on its terms, and the total is optimistic by roughly the gap the European data records. That error is invisible in the output and consistent in direction, which is the worst combination. So the first useful measurement any finance team can take is its own realised gap between terms and payment, per customer.

When does a treasury platform win?

It wins with several accounts, several currencies or several entities, where the work is consolidation and not prediction, and where somebody needs a defensible scenario view and not a single number. Bank connectivity is hard to build and commoditised to buy, so building it is rarely justified.

Failure mode: rule sprawl. The payment-timing corrections are configured by hand, they are correct on the day they are set, and nothing tells anyone when a counterparty’s behaviour has moved. Scenarios have the same problem, multiplying until nobody can say which one the business is planning against.

When does a payment-date model win?

It wins where three conditions hold together: enough counterparties that the behaviour is statistical and not relational, enough payment history per counterparty that a pattern exists to fit, and a receivables ledger that records what happened and not only what is outstanding.

The evidence that this can work is real. A prototype developed with a multinational bank reached up to 81% prediction accuracy, and its authors report simulations in which prioritising collectors’ work on that basis saves up to about 1.75 million dollars a month.

Failure mode: the one that same paper names. The decisions that determine payment are made in the customer’s organisation and are not registered in the receivables system, so the model is fitted to an incomplete record of its own subject. A second failure mode shows up on the horizon that matters most for treasury. Forecasting further out compounds error step by step, and one study of SME cash flow found its 12-week probabilistic forecasts falling short of their own coverage targets on real bank data.

What do people usually get wrong about automated cash flow forecasting?

The category is sold as an accuracy improvement and is mostly a data-plumbing improvement. Most of the value of replacing a manual forecast is that the position is now current, complete and consistent with the ledger, which has nothing to do with prediction. That value is real and it is the majority of the benefit. But crediting it to the model sets an expectation the model cannot meet, and the disappointment arrives about two quarters later.

The second error is treating the payment date as a modelling problem when it is a commercial one. The strongest published lever on when money arrives is not a better estimate. It is the terms themselves. Longer payment terms are associated with longer payment periods in 87% of cases, larger companies are the ones paying late in 16 of 20 Member States, and public authorities pay 9.5 days later than businesses despite tighter statutory limits.

A company with a payment-timing problem has a negotiation and a collections problem, which a forecast can describe more precisely and cannot fix.

The third is a measurement trap that catches careful teams. Comparative payment data is thinner than it looks. The European monitoring report for 2025 records that data availability worsened on the previous year, with fewer sectoral and impact breakdowns available, and it names the resulting gap as a serious one.

Treat circulating benchmark figures for forecast accuracy by horizon with the same scepticism, because most of them trace to treasury-software marketing and not to any published study. A forecast accuracy target inherited from a vendor’s collateral is not a target.

One prior question sits before the four arrangements. Whether the ledger data is complete, consistently coded and current enough for any of this is a readiness question with its own answer. A forecasting system built on a receivables ledger nobody trusts will produce a confident number from bad inputs faster than a person would.

Should you automate your cash flow forecast?

Yes for the assembly and cautiously for the prediction, and the split is clean enough to write into a scope. Automate the assembly without hesitation: bank connectivity, ledger integration, the contractually known inflows and outflows, the consolidation, the version history and the assumption log. That work is deterministic, the tooling is mature and mostly already paid for, and it is where the recoverable time sits, next to the ten hours a week the European survey data records companies spending on chasing payment.

Treat a predicted payment date as an input to a range, not as a date. Do not buy one at all until the receivables ledger records why invoices go unpaid.

The reason is structural, not a matter of the current state of the technology. The variance being forecast is generated by other organisations, and is more a property of the country they trade in than of their industry. The information that would explain it sits in the customer’s payables department and is absent from the seller’s records by construction, which is the constraint the payment-prediction research reports and not a gap more data will close. And the one moment an outsider inspects the forecast is an audit procedure that tests arithmetic, consistency and assumptions, not accuracy.

A process with that profile does not reward a more confident number. It rewards a current one, with its assumptions visible and its range honest.

For a finance team weighing this, the useful first move is a measurement and not a purchase. Take the last two years of paid invoices, and for each significant customer compute the realised gap between the agreed terms and the actual payment date, along with how much that gap moves.

A team that can produce that distribution already has most of the forecast improvement a model would offer. It knows whether its own book behaves statistically or relationally, and can tell whether the projection in its existing accounting system is wrong by three days or by twenty. A team that cannot produce it is being asked to buy a prediction of something it has never measured, and measuring it first costs a week.

Who can give you a second opinion on your cash flow forecast?

We know nobody wants to hear that the forecast they have been trusting is wrong in the same direction every month. A payment-date model is what we would build, and we will still tell you when you do not need one, as this page does. Foxnut AI has one tier, so the senior practitioner who reads your numbers is the one who does the work, and what we build is handed to your trained team.

The first step is a free expert audit, with no RFP and no pitch deck. You can read how our consulting practice works first. If you want a second opinion on which half of your own forecast is worth automating, bring us the distribution and we will tell you plainly.

The part most pages leave out

When not to choose Foxnut AI

Situations where another option is the better call, and where we say so in the first conversation rather than the fourth.

  • Your accounting package or ERP already projects a cash position from open receivables, open payables and a bank feed, and that feature has never been switched on, or the bank feed was never connected. That software, and we will say so. Connecting a bank feed and turning on a projection you already license is configuration work, not a build. Paying for a custom system to produce a view the incumbent already produces is the wrong purchase.
  • You have one bank account, a short list of customers whose paying habits your finance lead can recite by name, and a forecast that one person rebuilds in an hour when it is needed. The person already doing it, unchanged. The cost this work removes is time spent reconciling and chasing, not lines processed. Where that time is an hour and not the ten hours a week the European survey data reports as the average, there is no payback to find. Connecting the bank feed to the spreadsheet is the whole of the useful automation.
  • Your receipts are concentrated in a handful of counterparties whose payment timing is negotiated case by case, or a single late payer dominates the position. A redesigned process, not an automated one. With a handful of counterparties there is no distribution to learn from, only a set of relationships, and the effective work is renegotiating terms and collections practice. A model fitted to a dozen payers will report the recent past with a confidence interval attached to it.
  • The forecast would be wired to an irreversible decision, such as drawing a facility, deferring a payroll run or releasing a payment batch, with nobody reading the output before it acts. A human control point, or a simpler deterministic rule. The forecast can be rerun at any time at no cost, but a facility drawn or a payment released cannot be recalled, so the asymmetry belongs to the decision and not to the model. Automating the contractually known half and leaving the judgement to a treasurer is both cheaper and the position the audit standard's own procedures assume.
  • Disputes, credit notes, promises to pay and the reasons an invoice is being withheld live in email threads and in your credit controller's memory, while the receivables ledger records only that an invoice is open. Your organisation, doing the documentation work first. The published payment-prediction research names this limitation directly: the decision-making process is not registered in the accounts receivable system, so the facts that determine when an invoice is paid are the ones a model never sees. Data scattered across several systems is workable, and we work with that routinely. Data that exists only in an inbox is not.

Sources

  1. EU Payment Observatory, 'Annual Report 2025', written by the Centre for European Policy Studies and Ernst & Young for the European Commission (EISMEA), December 2025 - Publications Office of the European Union, ISBN 978-92-9412-340-4, DOI 10.2826/0995695. Summary of findings and the 2024 payment-performance chapter read in the report PDFRetrieved
  2. Irish Auditing and Accounting Supervisory Authority, 'ISA (Ireland) 570 Going Concern (Revised October 2019)', effective for audits of financial statements for periods commencing on or after 15 December 2019 - paragraphs 12D-3, 13-1, A3-13 and A16-1 read in the standard PDFRetrieved
  3. Kotios, Makridis, Fatouros and Kyriazis, 'Deep learning enhancing banking services: a hybrid transaction classification and cash flow prediction approach', Journal of Big Data, published 2 October 2022, DOI 10.1186/s40537-022-00651-x - open access, read on PubMed CentralRetrieved
  4. Appel, Malfatti, Cunha, Lima and de Paula, 'Predicting Account Receivables with Machine Learning', arXiv:2008.07363, submitted 11 August 2020 - a nine-page workshop paperRetrieved
  5. Appel, Oliveira, Lima, Malfatti, Figueredo de Santana and de Paula, 'Optimize Cash Collection: Use Machine learning to Predicting Invoice Payment', arXiv:1912.10828, submitted 20 December 2019 - the earlier report of the same work, which the 2020 paper substantially overlapsRetrieved

Foxnut AI takes on work like this from Bengaluru and Paris. If you want to see how we do it before you talk to anyone, here is what an AI engagement covers and what you keep.