The verdict in three sentences
A manufacturer with GBP 24 million (about USD 30 million) in revenue and strong seasonality can no longer manage cash with a spreadsheet filled in by hand on Monday morning. Off-the-shelf tools (GBP 170 to 780, USD 220 to 1,000 a month) suit regular flows, while a custom model connected to the ERP and banks (GBP 13,000 to 30,000, USD 16,000 to 38,000) uses the order book, actual customer payment behaviour and the rhythm of material purchases. The realistic target is a rolling 13-week forecast with under 5% variance and half a day of CFO time freed every week.
Why manual forecasts miss
The CFO of a mid-sized manufacturer rebuilds the forecast from three extracts: aged receivables, supplier payment schedule and bank statements. Then average assumptions are applied, such as "customers pay at 60 days". Reality is more granular: one major OEM pays at 58 days, another consistently at 75, deposits on special orders arrive early, and steel or resin purchases follow production seasonality 6 to 8 weeks ahead.
The AI model learns these behaviours from 24 to 36 months of history. It combines the 4-month order book, payment behaviour per customer, tax and payroll deadlines (VAT, PAYE or US payroll taxes, corporate tax instalments) and recurring flows (wages, rent, leases), then recalculates the forecast every night.
| Data source | Collection method | Frequency | Weight in forecast variance |
|---|---|---|---|
| Bank statements | Open Banking or bank feed | daily | starting point |
| Customer invoices and aged receivables | ERP connector | daily | 35 to 45% |
| Order book | ERP connector | daily | 15 to 25% |
| Supplier orders and invoices | ERP connector | daily | 20 to 30% |
| Tax and payroll deadlines | configured calendar | monthly | 5 to 10% |
| Payroll and fixed costs | import or rule | monthly | 5 to 10% |
Off-the-shelf tool or custom model: 2026 prices
Cash management software for mid-sized companies (Float, Fathom, Kyriba entry tiers, ERP treasury modules) offers flow categorisation, scenarios and a simple forecast. They often rely on historical averages and make little use of an industrial order book.
| Option | Setup | Recurring cost | Horizon | Typical forecast variance | Timeline |
|---|---|---|---|---|---|
| Manual spreadsheet | none | 4 h of CFO time a week | 4 to 8 weeks | 10 to 20% | immediate |
| SME cash SaaS | GBP 0 to 1,700 / USD 0 to 2,200 | GBP 170 to 430 / USD 220 to 550 a month | 13 weeks | 8 to 12% | 2 to 4 weeks |
| SaaS with advanced ERP connector | GBP 2,600 to 7,000 / USD 3,300 to 8,800 | GBP 430 to 780 / USD 550 to 1,000 a month | 13 to 26 weeks | 6 to 10% | 4 to 8 weeks |
| Custom model, ERP and bank flows | GBP 13,000 to 19,000 / USD 16,000 to 24,000 | GBP 170 to 350 / USD 220 to 450 a month | 13 weeks | 5 to 7% | 2 months |
| Custom model with order book and AI | GBP 21,000 to 30,000 / USD 27,000 to 38,000 | GBP 260 to 520 / USD 330 to 660 a month | 13 to 52 weeks | 3 to 5% | 3 months |
| Annual maintenance | n/a | 10 to 15% of project | n/a | maintained | ongoing |
Custom work is justified above roughly GBP 13 to 17 million (USD 16 to 22 million) in revenue, with marked seasonality or high customer concentration. Below that, a SaaS well connected to the ERP is often enough.
What the CFO gets every Monday
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
The deliverable is not an algorithm but a dashboard: consolidated position for the day, week-by-week forecast over 13 weeks, the cash low point identified with its date, forecast versus actual for the previous week, and three scenarios (a major customer paying late, materials up 10%, an exceptional order). An automatic alert fires as soon as the projected balance drops below the safety threshold agreed with your bank.
Mini case study
Mark, CFO of a plastic components manufacturer in the Midlands (GBP 24 million revenue, 160 staff), spends 4 hours every Monday on his forecast and draws on a revolving facility at 7.5% to cover the May and September troughs. He deploys a custom model at GBP 24,000 and GBP 390 a month. Forecast variance falls from 14% to 4.5%. He sees the September trough 6 weeks in advance, arranges targeted invoice finance instead of an overdraft and cuts average facility usage by GBP 500,000, about GBP 37,500 in interest avoided per year, plus 200 hours of CFO time freed. The project pays back within a year. A comparable plant in Ohio would budget about USD 30,000 for the same scope.
FAQ
How much history is needed to train the model? At least 24 months, ideally 36, to capture two or three seasonal cycles. With 12 months the model is usable, but variance tends to sit between 7 and 10%.
Which ERPs are compatible? Common manufacturing ERPs (Sage X3, SAP Business One, Epicor, NetSuite, Odoo, Microsoft Dynamics 365) offer APIs or scheduled exports. Allow GBP 2,600 to 5,200 (USD 3,300 to 6,600) per ERP connector if no standard API exists.
Does the AI replace the CFO's judgement? No. The model provides a baseline forecast, and the CFO adds events only they know about (an ongoing negotiation, a capital purchase). These manual adjustments are logged and compared with actuals.
Is bank data secure? Feeds go through regulated Open Banking providers or bank host-to-host connections, read-only, encrypted, hosted in the UK, EU or US as required.
How quickly do we see a gain? From the first month for time saved, after 2 to 3 months for accuracy, once the model has recalibrated on your recent payment patterns.
Let's scope your project. Tell us your ERP, your banks and your revenue: we will scope a project between GBP 13,000 and 30,000 (USD 16,000 to 38,000) delivered in 2 to 3 months. Detailed quote within 48 h. WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.