Skip to main content
iVentureTeam
Odoo Accounting & Tax

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.

Siddharth JambukiyaSiddharth JambukiyaOdoo Techno-Functional Consultant
November 21, 202613 min read0 views
Odoo Cash Flow Forecast: Reports, Follow-ups and Bank Reconciliation cover

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.

ReportWhat it answersWhere to find itWatch out for
Cash Flow StatementWhere cash came from and went, by operating, investing, financingAccounting, ReportingDepends on correct account tags and types
Aged ReceivableWho owes you, and how lateAccounting, ReportingOnly as good as your reconciliation
Aged PayableWhat you owe, and how long unpaidAccounting, ReportingIncludes credit notes and overpayments
Executive SummaryAverage debtor days, creditor days, current ratioAccounting, ReportingIts cash forecast line is a sales minus purchases proxy
Partner Ledger and Follow-up ReportDue vs overdue per customerAccounting, ReportingSend it from the customer form
Bank Reconciliation SummaryReconciled and unreconciled lines at a dateBank journal menu, ReportOdoo 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:

  1. Tags: review every balance sheet account and confirm its type and cash flow tag.
  2. Bank and suspense: clear the bank suspense account, since unreconciled lines distort operating cash.
  3. 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:

  1. Opening cash: ODOO.BALANCE on your bank and cash account codes as of today.
  2. Expected receipts: a pivot of open receivable journal items grouped by due date and week, or ODOO.RESIDUAL on the receivable account.
  3. Expected payments: the same pivot for payable items, plus payroll, rent, tax and loan lines typed in as fixed rows.
  4. Adjustments: a collection rate per customer group, for example 80% of items over 60 days late, labelled as your own assumption.
  5. Closing cash: opening plus receipts minus payments, rolled forward week by week.
  6. 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 caseModel typeTypical condition
Monthly bank chargesAutomatedLabel contains the bank's fee text
Small payment differencesManual buttonAmount lower than a set limit
Card processor feesAutomatedPartner is the processor, label regex
Loan repaymentsManual buttonLabel contains the loan reference
Internal transfersAutomatedLabel 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 19 vs Odoo 20: What changed for cash management?

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.

AreaOdoo 19Odoo 20
Payment statesIn Process, PaidDraft, Paid, Reconciled
Bank entriesManual lines on bank accounts possibleBank and cash accounts only via bank transactions
RemindersPartner-level follow-upsPer-invoice reminders with Last Reminder date
MatchingReconciliation modelsAdds Matching Rules with payment tolerance
Bank reportUnreconciled itemsBank Reconciliation Summary with reconciled section
Vendor paymentsBatch files to the bankAdds 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.

IndustryPain or cost driverOdoo approachHow iVentureTeam helps
DistributionLong customer terms, short supplier termsPayment terms, aged receivable, follow-up levelsAlign terms and automate reminders
ManufacturingCash tied up in stock and work ordersAged payable plus purchase timing in the forecastAdd stock and PO rows to the forecast sheet
eCommercePayouts net of fees and refundsReconciliation models for processor feesMap payouts to orders and fees
Professional servicesUnbilled time and slow approvalsInstallment plans and pre-due remindersSet reminder levels before due date
SubscriptionsFailed renewals and churnRecurring invoices with automatic follow-upsTrack residual by contract group
Construction and projectsMilestone billing and retentionsInstallments and analytic trackingForecast 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.

  1. Monday morning: reconcile every bank journal to yesterday and clear suspense.
  2. Monday: process follow-ups for all customers due for action.
  3. Tuesday: review Aged Receivable over 60 days with sales owners.
  4. Wednesday: approve the supplier payment run against the forecast.
  5. Thursday: refresh the forecast sheet and note big variances.
  6. 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

Unsure your cash data is clean? Run a health check

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?

Book a cash setup review

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.

We use cookies to improve your experience

Essential cookies make the site work, and we use analytics to improve it. Choose “Only necessary” to turn analytics off. See our cookie policy.