Odoo Cash Flow Forecast: Reports, Follow-ups and Bank Reconciliation
Odoo cash flow forecast options in Odoo 19 and 20: cash flow statement, aged receivables, spreadsheet forecasts, follow-up levels and bank reconciliation.
Cash problems start with unreconciled bank lines, invoices nobody chased and bills paid twice. Our Odoo consulting services fix that chain first, so any Odoo cash flow forecast you build rests on numbers you can trust.
Related service: Odoo for finance teams — accounting, tax and reporting automation.
This guide is for CFOs, controllers and owners running Odoo 19 or 20 who want real cash flow management, not another export to Excel. If you are new to the ledger side, start with our guide on how Odoo Accounting works.
Does Odoo have a cash flow forecast report?
Odoo does not ship a dedicated cash flow forecast report in versions 19 or 20; it ships historical cash reports and the data you need to forecast. That difference matters when you plan your setup.
The Odoo 20 reporting documentation lists the generic reports: Balance Sheet, Profit and Loss, Executive Summary, General Ledger, Aged Receivable, Aged Payable, Cash Flow Statement, Tax Report and Audit Trail. None of them projects cash by future week.
Users notice. On the Odoo forum, an Odoo 16 Enterprise user asked whether a cash flow forecast is possible inside Odoo without external tools. The replies were others asking the same thing, with no native answer.
The closest native figure is the Executive Summary's "Short-term cash forecast". Odoo defines it as the month's Sales account balance minus the Purchases account balance. That is a margin proxy, not a forecast of when cash lands in the bank.
Which native Odoo cash flow reports should you use?
Use the Cash Flow Statement for history, Aged Receivable and Aged Payable for timing, and the Executive Summary for debtor and creditor days. Together they cover most of what a weekly cash meeting needs.
| Report | What it answers | Where to find it | Watch out for |
|---|---|---|---|
| Cash Flow Statement | Where cash came from and went, by operating, investing, financing | Accounting, Reporting | Depends on correct account tags and types |
| Aged Receivable | Who owes you, and how late | Accounting, Reporting | Only as good as your reconciliation |
| Aged Payable | What you owe, and how long unpaid | Accounting, Reporting | Includes credit notes and overpayments |
| Executive Summary | Average debtor days, creditor days, current ratio | Accounting, Reporting | Its cash forecast line is a sales minus purchases proxy |
| Partner Ledger and Follow-up Report | Due vs overdue per customer | Accounting, Reporting | Send it from the customer form |
| Bank Reconciliation Summary | Reconciled and unreconciled lines at a date | Bank journal menu, Report | Odoo 20 adds the reconciled section |
All of these reports export to PDF or XLSX and support period comparison, so you can see whether collection is improving month on month.
How does the Odoo cash flow statement work?
The Odoo cash flow statement shows how changes in balance sheet accounts and income affect cash, split into operating, investing and financing activities. It is an indirect, accrual-based view built from your chart of accounts.
Because the report reads accounts, the setup decides the result. Odoo's chart of accounts guide notes that some reports need tags on the relevant accounts. If a loan or fixed asset account lacks the right tag, its movement lands in the wrong section.
On the Odoo forum, in a thread on how the default cash flow statement works, one user called the report hard to audit and dependent on reconciled bank lines; another said it worked on Odoo Online 18.4.
Run three checks first:
- Tags: review every balance sheet account and confirm its type and cash flow tag.
- Bank and suspense: clear the bank suspense account, since unreconciled lines distort operating cash.
- Tie-out: confirm the closing cash in the statement equals your bank journal balances on the same date.
How do you build an Odoo cash flow forecast in a spreadsheet?
Build the forecast in an Odoo spreadsheet that reads open receivables, open payables and bank balances directly from the ledger. It stays current without a weekly export.
Odoo spreadsheets include accounting functions. The Odoo spreadsheet functions list includes ODOO.BALANCE, ODOO.DEBIT, ODOO.CREDIT, ODOO.RESIDUAL, ODOO.PARTNER.BALANCE and ODOO.CURRENCY.RATE, plus standard functions such as FORECAST and NPV.
A practical 13-week sheet we set up looks like this:
- Opening cash: ODOO.BALANCE on your bank and cash account codes as of today.
- Expected receipts: a pivot of open receivable journal items grouped by due date and week, or ODOO.RESIDUAL on the receivable account.
- Expected payments: the same pivot for payable items, plus payroll, rent, tax and loan lines typed in as fixed rows.
- Adjustments: a collection rate per customer group, for example 80% of items over 60 days late, labelled as your own assumption.
- Closing cash: opening plus receipts minus payments, rolled forward week by week.
- Review: refresh every Monday and compare last week's forecast with the bank.
The sheet only trusts its inputs. Wrong payment terms or a bank two weeks behind make the forecast wrong, so the next sections matter more than the sheet.
How do payment terms shape your cash forecast?
Payment terms set the due dates that drive both your aged receivable report and your forecast, so they must match what customers actually agreed. Wrong terms make every projection late or early.
Odoo payment terms and installment plans support due dates, early payment discounts and split payments, such as 30% on invoice and the rest at the end of the following month. Each installment gets its own due date, so a forecast picks up each part on the right week.
- Default terms: set them on the customer and vendor, not on each invoice.
- Early payment discounts: they can bring cash forward; model the take-up rate.
- Vendors: record real supplier terms on bills, or your payables column is fiction.
How do Odoo payment follow-up levels work?
Odoo follow-up levels send the right reminder at the right number of days overdue, by email, letter, SMS or WhatsApp, and can run automatically. This is where Odoo cash flow management turns into collected cash.
The Odoo payment follow-up guide covers the setup under Accounting, Configuration, Follow-up Levels. Each level sets the days, the actions, a content template, the Automatic option, whether to attach overdue invoices and an optional activity for a named user.
A negative number of days sends a reminder before the due date, which is a gentle way to cut late payments. Letters, SMS and WhatsApp messages use In-App Purchase credits, so budget for them if you use those channels.
Odoo's own docs give one rule we repeat to every client: reconcile all bank transactions before you run follow-ups. Otherwise customers who have paid get a reminder, and your credit team loses credibility.
In Odoo 20, our Odoo 20 accounting release notes record a reworked reminder flow. Invoices gain a "Send Reminder" button and a "Last Reminder" date, and levels can be timed before or after the due date. In our test database the menu reads Invoice Reminders.
How does Odoo bank reconciliation support cash flow?
Odoo bank reconciliation matches each bank transaction to an invoice, bill or payment, so your cash, receivables and payables reflect what really happened. Without it, no cash report is reliable.
Under the Odoo bank reconciliation guide, Odoo first matches on references when no partner is set. When a partner is set, it matches on amount: exact match, then discounted match for early payment terms, then the invoice amount found in the label.
Unmatched lines sit in the bank suspense account until reconciled. Netting offsets a partner's receivable against their payable without a bank movement.
Odoo bank synchronization supports over 26,000 institutions through third-party providers and needs an Odoo Enterprise subscription. In Europe, statement files or EBICS may suit you better; our guide to Odoo EBICS, bank sync or CAMT.053 compares them.
Card payouts need extra care, since one payout line nets off fees and refunds across many orders. Our Odoo Stripe reconciliation guide walks through payouts, fees and disputes.
Which Odoo reconciliation models save the most time?
Reconciliation models automate recurring write-offs and matches, such as bank fees, cash discounts and known transfers, so staff only touch exceptions. They are the biggest time saver in daily cash work.
The Odoo reconciliation models guide explains that models can be manual buttons or automated rules. Conditions include journal, partner, amount range and label, with "contains", "not contains" or regex matching. When several automated models match, the first in sequence wins.
| Use case | Model type | Typical condition |
|---|---|---|
| Monthly bank charges | Automated | Label contains the bank's fee text |
| Small payment differences | Manual button | Amount lower than a set limit |
| Card processor fees | Automated | Partner is the processor, label regex |
| Loan repayments | Manual button | Label contains the loan reference |
| Internal transfers | Automated | Label contains "transfer" and both journals |
Odoo 20 adds Matching Rules with a payment tolerance in percent or amount and an oldest-first or newest-first order, plus a "Run Auto Reconciliation" action.
What changed for cash management in Odoo 20?

Odoo 20 tightens bank data, renames payment states and adds tools that cut double payments and reconciliation time. If you are on Odoo 19, plan for these before your upgrade.
| Area | Odoo 19 | Odoo 20 |
|---|---|---|
| Payment states | In Process, Paid | Draft, Paid, Reconciled |
| Bank entries | Manual lines on bank accounts possible | Bank and cash accounts only via bank transactions |
| Reminders | Partner-level follow-ups | Per-invoice reminders with Last Reminder date |
| Matching | Reconciliation models | Adds Matching Rules with payment tolerance |
| Bank report | Unreconciled items | Bank Reconciliation Summary with reconciled section |
| Vendor payments | Batch files to the bank | Adds Pay Now via payment initiation, Enterprise only |
The payment wizard in Odoo 20 also detects payments already marked Paid but not yet matched, and lowers the amount it proposes. That closes a common source of double payments to suppliers.
How do cash flow needs differ by industry?
Cash pressure comes from different places in each industry, so the Odoo setup should target the driver that hurts most. The table shows where we usually start.
| Industry | Pain or cost driver | Odoo approach | How iVentureTeam helps |
|---|---|---|---|
| Distribution | Long customer terms, short supplier terms | Payment terms, aged receivable, follow-up levels | Align terms and automate reminders |
| Manufacturing | Cash tied up in stock and work orders | Aged payable plus purchase timing in the forecast | Add stock and PO rows to the forecast sheet |
| eCommerce | Payouts net of fees and refunds | Reconciliation models for processor fees | Map payouts to orders and fees |
| Professional services | Unbilled time and slow approvals | Installment plans and pre-due reminders | Set reminder levels before due date |
| Subscriptions | Failed renewals and churn | Recurring invoices with automatic follow-ups | Track residual by contract group |
| Construction and projects | Milestone billing and retentions | Installments and analytic tracking | Forecast by project and milestone |
For project and department views of the same cash, pair the forecast with Odoo analytic accounting and budgets.
What weekly routine keeps an Odoo cash forecast accurate?
A short weekly routine of reconcile, chase, review and refresh keeps the forecast honest. The month-end close then becomes a check, not a rescue.
- Monday morning: reconcile every bank journal to yesterday and clear suspense.
- Monday: process follow-ups for all customers due for action.
- Tuesday: review Aged Receivable over 60 days with sales owners.
- Wednesday: approve the supplier payment run against the forecast.
- Thursday: refresh the forecast sheet and note big variances.
- Month end: run the full close; our Odoo month-end close checklist covers bank, accruals, tax and lock dates.
To watch overdue totals between meetings, see our guide to Odoo dashboards and alerts.
How iVentureTeam helps with Odoo cash flow management

iVentureTeam sets up the reports, reminders, bank feeds and reconciliation rules first, then builds a cash flow forecast your team can trust. We have delivered 150+ ERP projects across 35+ countries with 40+ Odoo specialists, led by a consultant with 13+ years in Odoo.
- Cash setup review: account tags, payment terms, journals and suspense accounts checked against your cash flow statement.
- Collections: follow-up levels, templates and automatic reminders tuned to your customer segments.
- Bank and payouts: bank synchronization or statement imports, reconciliation models and Odoo 20 matching rules.
- Forecast sheet: a 13-week Odoo spreadsheet tied to your ledger, plus training for the finance team.
- Health check first: run our free Odoo health check to spot gaps, and see our Odoo ERP implementation guide if you are still rolling out.
Odoo cash flow case study: payment gateways for eCommerce brands
This was a payment integration project, not a cash forecasting project, but it fixed the problem that breaks most cash forecasts: payments that never reconcile in Odoo. We share it as the closest fit we have.
Online merchants on Odoo eCommerce held gateway contracts with CardConnect, BlueSnap, SecurionPay, Cielo and Paymee. Odoo could not talk to any of them, and manual workarounds broke order status flow and left payments unreconciled in Odoo.
We built five connectors on Odoo's standard payment acquirer framework, across Odoo 12, 13 and 14. Payment confirmations now drive order confirmation, and transaction references land on the Odoo order automatically, so reconciliation happens against Odoo records.
The project delivered clean, matched payments, which any forecast needs first. Read the payment gateways Odoo eCommerce integration case study.
The bottom line on Odoo cash flow forecasting
Odoo gives you strong cash history, collections and reconciliation, but the forward forecast is something you build, usually in an Odoo spreadsheet. Clean data comes first.
Set correct payment terms, reconcile the bank daily, automate follow-up levels and tag your accounts. Then a simple 13-week sheet on ODOO.BALANCE and open items will tell you more than any add-on built on messy data.
Ready to see your cash position weeks ahead?

Get a cash setup review and a working forecast built on your own Odoo data. Ask for an Odoo cash flow setup review, call +91-90235-15208, or email business@iventureteam.com.
Frequently Asked Questions
Does Odoo have a cash flow forecast?
+
Not as a dedicated report in Odoo 19 or 20. Odoo offers a Cash Flow Statement, aged receivable and payable reports and an Executive Summary. Most teams build the forecast in an Odoo spreadsheet using ledger functions and open items.
How do I get a cash flow statement in Odoo?
+
Go to Accounting, Reporting, Cash Flow Statement. It splits cash movement into operating, investing and financing activities. Check account types and tags first, and reconcile the bank, or the sections will be wrong.
Is the Odoo cash flow statement direct or indirect?
+
It is an indirect, accrual-based view that reads changes in balance sheet accounts and income. If you need a direct-method view by transaction category, you usually need a custom report or a spreadsheet.
How do follow-up levels work in Odoo?
+
Each level sets the days overdue, the actions such as email, letter, SMS or WhatsApp, a template and whether it runs automatically. A negative number of days sends a reminder before the due date.
Do Odoo payment reminders cost extra?
+
Odoo's docs list In-App Purchase credits for letters, SMS and WhatsApp messages, not for email. Add those credits to your running costs if you use those channels.
What is a reconciliation model in Odoo?
+
It is a rule that matches or writes off recurring bank lines, such as bank fees or small differences. Models can be manual buttons or automated, with conditions on journal, partner, amount and label.
Does Odoo bank synchronization work with my bank?
+
Odoo supports over 26,000 institutions through third-party providers, and it needs an Odoo Enterprise subscription. Check the supported list on Odoo's site; if your bank is missing, import statement files instead.
What changed in Odoo 20 bank reconciliation?
+
Odoo 20 adds matching rules with payment tolerance, a Run Auto Reconciliation action, multi-account splits and a Bank Reconciliation Summary with reconciled lines. Bank accounts can no longer take manual journal lines.
Can Odoo predict late payments?
+
Not natively as a score. You can use Aged Receivable, average debtor days in the Executive Summary and each customer's history to set collection assumptions in your forecast sheet.
Free written answer from a certified consultant
Getting Odoo Accounting set up right?
We map your accounting, tax and reporting in Odoo and show what to set up first, and what to watch.
Free, with no obligation. A senior consultant replies within 12 business hours.
Free Odoo tools
All tools- Odoo Health CheckVersion, modules, findings and upgrade cost
- Odoo App SelectorWhich apps you need, by industry
- Odoo Project EstimateIndicative cost and timeline in minutes
- Odoo Implementation Cost CalculatorImplementation cost and timeline, in minutes
- Odoo Migration Cost CalculatorVersion jump or legacy ERP, priced in minutes
Continue reading
Odoo Tax Automation: Fiscal Positions, Tax Returns and E-Invoicing
Odoo tax automation in 19 and 20: fiscal positions, tax mapping, tax reports, VAT return checks, lock dates, closing entries and e-invoicing explained.
Odoo Accounting for CFOs in the GCC: VAT, E-Invoicing and Controls
Odoo accounting for CFOs in the GCC: UAE and Saudi VAT, ZATCA and UAE e-invoicing, AED and SAR multi-currency, lock dates and hashed audit controls.
Odoo Singapore GST Setup: Tax Codes, GST F5 and InvoiceNow in 19/20
Set up Odoo Singapore GST in Odoo 19 and 20: IRAS tax codes, the 9% rate, GST F5 boxes, PINT SG and the InvoiceNow timeline, plus when you need an AP.
