Odoo cash flow forecast: what you get and what to add
What Odoo covers for cash out of the box, where the gaps really hurt and three honest ways to get a rolling forecast you can trust.
You already run Odoo. Sales and purchase invoices sit there with due dates, payments post, bank statements get imported, your accountant signs off the quarter. And still, every Monday you open a spreadsheet to guess how much cash you will have six weeks from now. Odoo knows about money. What it does not do, out of the box, is look forward. A proper Odoo cash flow forecast is not something that comes installed, and that is why payroll Fridays feel tighter than planned and why you learn about a late payment the week you were about to sign for the new van.
This piece puts things in order. What Odoo gives you for cash, what it misses and three realistic ways to close the gap without re-implementing anything. You will see when a spreadsheet fed from Odoo still works, when an Odoo module makes sense and when a separate tool reading your Odoo data is the honest answer. There is a worked example built around a small Irish fabrication shop, an eight-week table where the numbers add up and a short decision guide for Monday morning.
If your treasury has lived in Excel for years and it mostly works, you are not forced to switch. What is worth knowing is where the risk hides, what the alternatives actually cost and when the Monday mornings start adding up to a real salary. By the end you will know whether your case holds with the spreadsheet, deserves a module or earns a tool of its own.
What Odoo ships for cash out of the box
In Community you get invoices with due dates and payments, and bank statements you can load in. The reconciliation screen and the accounting reports (aged balances, trial balance) sit in Enterprise or in a community module. Enough to run the business, not to forecast cash. There is no built-in report that says “five weeks from now you will have €18,000 in the bank”. The community does maintain modules that try to fill the gap, with uneven quality, often tied to a single Odoo version and with maintenance that resets at every upgrade. If you are still choosing between the two editions, there is a dedicated comparison in Odoo Community and Enterprise for treasury work.
In Enterprise you also get the Statement of Cash Flows, structured the classic way (operating, investing, financing). It tells you what has already happened to your cash, grouped by activity. It is useful for explaining the year and keeping your auditor happy. It looks backward. The only forward signal is a short indicator in the Executive Summary that estimates inflows and outflows for the next thirty days from the month’s sales and purchases, with no taxes, payroll or recurring payments. For a small business that needs six to twelve weeks of visibility with VAT, wages and loan repayments in place (whether that is a UK quarterly return or an Irish bi-monthly one), it is not enough.
What you do get out of the box, and should use, is the raw material. Due dates, scheduled supplier payments, confirmed sales and purchase orders, bank reconciliation and, when you run several entities, all of them inside the same database. Keep that clean and the forecast practically builds itself. Leave it messy and no tool will save you. The result will be wrong with the kind of precision that makes it feel right.
What is missing to actually decide
Before you pick how to solve it, write down what you really need. This is the list that almost every small business ends up with when they build a serious forecast for the first time.
- Weekly projection for the next 13 weeks and monthly for the next 12 months.
- Non-invoice inflows and outflows: payroll, employer taxes, loan repayments, leasing, subscriptions, expected dividends, bonuses.
- VAT and payroll tax returns on the date you actually pay, not the date you accrue.
- Confirmed orders not yet invoiced and quotes with a probability.
- Receipts assumptions: a customer who agreed thirty days and pays at sixty, accounts that routinely slip by ten days.
- Side-by-side scenarios: hire two people in March, delay an investment, a large customer goes into administration.
- The real bank balance today (what the bank says) against the book balance (what Odoo says) and the reason for the gap. There is a whole piece on bank balance versus book balance in Odoo because that gap explains a good share of the surprises.
- Email alerts when the forecast drops below a floor you set.
- With a group, a consolidated view with inter-company flows kept separate, several currencies and real cash per entity. Group work has its own traps in multi-company cash position in Odoo.
If you are honest with that list, Odoo covers only a small part of it. The rest you build around it or buy ready-made.
Three realistic ways to close the gap
A spreadsheet that reads Odoo
This is where most companies start. Each week you export open receivables and payables with their due dates, paste into a template with a weekly model, add payroll, taxes and standing payments by hand and compute the running balance. For a single entity and someone who knows Excel, it can hold for years.
Pros: no cost, full control, instant tweaks, no vendor to depend on. Cons: every refresh is manual, paste errors creep in, assumptions live only in the head of whoever runs it, and when they are off on Monday the business flies blind. If starting here makes sense for you, follow how to build a cash flow forecast step by step before you fight your own template.
An Odoo module for forecasting
There are community and paid modules that add a forecast screen inside Odoo. Paid ones usually land between €100 and €400 of licence per version, plus the cost of upgrading when you move Odoo versions and, often, custom work to get recurring payments and taxes into the model.
Pros: everything stays inside Odoo, no exports. Cons: tied to a single Odoo version, needs maintenance at every upgrade, planned-versus-actual and scenarios usually fall short, and the screen is visible only to Odoo users when the finance lead and the owner often are not. The full comparison with when each option pays off is in when to pick an Odoo module and when a separate tool.
A separate tool that reads your Odoo
A dedicated treasury app connects to Odoo, reads invoices and payments, lets you add what is missing (payroll, taxes, standing payments) and renders the forecast and scenarios on a screen of its own. Odoo stays untouched.
Pros: finance and management get a screen built for them, with the live bank balance, side-by-side scenarios, alerts when cash tightens and a history that explains why reality drifted from plan. Cons: a monthly subscription that for a small business sits between €30 and €250 a month depending on features and entities, with corporate suites in a different order of magnitude. A route that often fits once you have more than one entity or a dedicated finance person.
Kashbi, the tool we build, fits here. It reads Odoo without touching it, you pay a monthly fee tied to how many entities you run, and it opens soon. If you want a sense of how options compare on price and features, see what cash flow software for small business usually costs.
Clean these three in Odoo before you forecast anything
The route does not matter. If Odoo has these three bases covered, any forecast will serve you. If not, you are forecasting fog.
Due dates and payment terms. Make sure every customer carries the real term. If you invoice at thirty, set thirty. If they actually pay at sixty, run a scenario at sixty, but the master data reflects what was agreed. Invoices with no due date do not land in any forecast.
Weekly bank reconciliation. Import statements each week, reconcile and leave the “to reconcile” bucket at zero. Two reasons. Odoo’s cash today has to be truthful, and the opening balance of your forecast has to be the real bank number. A €2,000 drift carried for three months comes due on payroll Friday. Bank balance versus book balance in Odoo covers the whole story.
Standing items that are not invoices. Payroll, employer taxes, loan repayments, leases, domains, licences, subscriptions. Build a list with amount and day of the month. In Odoo they can live as recurring vendor bills, as manual entries in a planned cash account or as inputs in the forecast tool. What matters is that the forecast actually sees them.
A worked example: eight weeks in a small business
Riverforge Metals Ltd, a precision fabrication shop near Dublin with 28 people and a single entity. Annual turnover around €1.8 million. Two bank accounts (operating and payroll), a standing credit line for emergencies and a five-year loan. The office manager imports bank statements on Monday and reconciles by Wednesday.
Combined real cash on Friday 30 October is €38,500. The alert floor the owner has set is €15,000. With what Odoo already carries (invoices and confirmed orders) and what finance adds by hand (payroll, PAYE and PRSI, loan instalment, Christmas bonus), the weekly forecast reads as follows.
| Week | Inflows | Outflows | Net | Closing cash |
|---|---|---|---|---|
| 2-8 Nov | 22,500 | 9,200 | +13,300 | 51,800 |
| 9-15 Nov | 11,800 | 9,800 | +2,000 | 53,800 |
| 16-22 Nov | 8,200 | 10,400 | -2,200 | 51,600 |
| 23-29 Nov | 14,500 | 39,100 | -24,600 | 27,000 |
| 30 Nov-6 Dec | 9,500 | 9,500 | 0 | 27,000 |
| 7-13 Dec | 16,200 | 7,900 | +8,300 | 35,300 |
| 14-20 Dec | 9,800 | 30,500 | -20,700 | 14,600 |
| 21-27 Dec | 18,200 | 39,100 | -20,900 | -6,300 |
What the forecast shows and Odoo on its own would not.
- The week of 23 November carries monthly payroll plus PAYE and PRSI and still holds, because October was a strong month on collections.
- The week of 14 December carries the Christmas bonus. Cash drops to €14,600, below the floor. There is time to shift one flexible supplier payment, ask a customer who normally pays mid-month to pay early or draw on the credit line with two weeks of notice.
- The week of 21 December carries regular payroll and employer taxes again. Cash goes negative. If nobody sees it in October, it surfaces Thursday afternoon in December.
The value is not the €38,500 opening cash. It is seeing the two red zones six weeks ahead.
How to pick
- Single entity, decent spreadsheet, finance reconciles every week: stay in Excel and automate inputs with a weekly export. If the pain is small, do not touch it.
- One or two entities, management and finance asking for the picture every Monday, pain from pasting by hand: separate tool reading Odoo. The time saved on admin pays back fast.
- Group of three or more entities, several currencies, inter-company flows: separate tool, no debate. You need the group view with inter-company flows kept out of the totals.
- Heavily customised Odoo with an in-house tech team: consider a module when planned-versus-actual and scenarios are not critical.
One last filter helps. Count the cost of not seeing it. A €20,000 late payment that forces you to draw on an eight per cent credit line for two months is around €267 in avoidable interest each time. Two of those a year pay for a year of the simpler tools.
Frequently asked questions
Does Odoo Community support cash flow forecasting?
Out of the box, no. You get invoices with due dates, payments and bank reconciliation, but no report that projects your balance forward. Community and paid modules try to fill the gap with uneven quality and ties to a specific Odoo version.
Is Odoo Enterprise’s Statement of Cash Flows a forecast?
No. It is a backward-looking report that groups what already happened into operating, investing and financing activities, useful for explaining the year. The Executive Summary carries a short forward indicator for the next thirty days from the month’s sales and purchases, but it leaves out taxes, payroll and loan repayments. For a small business it is not enough.
Do I need Odoo Enterprise to forecast cash?
No. If your due dates are kept current, you reconcile the bank weekly and you add the recurring items by hand (payroll, employer taxes, VAT, loan repayments), Community provides the raw material. The projection and scenarios can live outside Odoo, in a spreadsheet or in a treasury tool that reads your Odoo data.
What should a serious forecast cost me?
It depends on size and route. A spreadsheet costs your time, an Odoo module usually €100 to €400 of licence per version plus maintenance, and a separate tool for a small business €30 to €250 a month depending on features and entities. Mid-market and enterprise suites play in a different league. The full price map is in cash flow software for small business and what it costs.