OdooWiki OCA HUB

MIS Builder Cash Flow

mis_builder_cash_flow folder_open OCA/account-financial-reporting open_in_new
Uncategorised License: AGPL-3

This module allows you to have a cash flow forecast. The forecast is based on two types of date:

  • Accounting entries: uses the Due Date field instead of the accounting Date.
  • Forecast lines: manual lines created that forecast in/out cash flow moves.

It also adds:

  • Cash flow plans: a recurring template that generates a whole series of forecast lines with a single click.
  • A per-company, configurable limit on the number of forecast lines a single plan can generate at once, to avoid runaway series over very long date ranges.

auto_awesome What this module does

AI-generated from the code · Odoo 19.0

Plan and forecast your company's future cash in and out. Create recurring cash flow plans that automatically generate forecast lines, and view everything in a Cash Flow report with weekly and monthly periods.

This module adds a cash flow forecasting tool on top of the MIS Builder reporting engine. It appears under the Finance reporting menu with two new entries: 'Cash Flow Forecast Line' and 'Forecast Planner'.

  • Forecast Planner: create a plan with a name, partner, account, amount, start and end dates, and a recurrence (every X days, weekly or monthly). A 'Generate Forecast Lines' button creates one forecast line per period. If lines already exist, a confirmation warns they will be deleted and regenerated. A counter button shows how many lines were generated and opens them.
  • Forecast lines: each line has a date, account, partner, description and amount. They can also be created manually. The account must belong to the selected company, and only receivable/payable accounts can be chosen.
  • Accounts: a new 'Hide in Cash Flow?' checkbox on receivable and payable accounts excludes them from the report.
  • Report: a 'Cash Flow' MIS report combines unreconciled journal items (using their due date) with forecast lines, showing liquidity, in/out totals, period balance and overall balance, with green/red styling for positive/negative results. Predefined periods cover the current situation plus the next weeks and months.
  • Settings: a per-company limit (default 100) caps how many lines a plan can generate at once; a warning appears if the limit is reached.

Depends on

mis_builder

Required by other modules

l10n_it_withholding_tax_mis_builder_cash_flow

Menus it adds

menu_mis_cash_flow_forecast_lineForecast Planner
Models and fields (6)
  • res.company · extends an existing modelcash_flow_plan_max_forecast_lines
  • mis.cash_flow · new modeldate, name, debit, credit, line_type, account_id (Account), company_id (Company), partner_id (Partner), reconciled, account_type, move_line_id (Journal Item), parent_state, full_reconcile_id (Matching Number)
  • account.account · extends an existing modelhide_in_cash_flow (Hide in Cash Flow?)
  • mis.cash.flow.plan · new modelname, balance (Balance / Amount), date_end, account_id (Account), company_id, date_start, partner_id (Partner), periodicity, every_x_days (Interval (Days)), forecast_line_ids (Generated Forecast Lines), forecast_line_count
  • res.config.settings · extends an existing modelcash_flow_plan_max_forecast_lines (Cash Flow Plan Max Forecast Lines)
  • mis.cash_flow.forecast_line · new modeldate, name, balance, account_id (Account), company_id (Company), partner_id (Partner), cash_flow_plan_id (Origin Cash Flow Plan)

Text generated by AI (DeepSeek) from reading the Odoo 19.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 8 confirmed, 1 with no information of 9 versions.

Sources · Odoo 19.0

Confirmed on 2026-11-03 in branch 19.0 of OCA/account-financial-reporting.

terminal Installation and usage

OCA documentation · Odoo 19.0

Usage

Source · Odoo 19.0

To use this module, you need to:

  • Go to Accounting \> Reports \> MIS Reporting \> MIS Reports and choose "Cash Flow" report
  • You can add forecast lines on Accounting \> Reports \> MIS Reporting \> Cash Flow Forecast Line
  • If you select on "Target Moves" the value "All Posted Entries", you will get only lines for already posted invoices/entries + the forecast lines.
  • Selecting "All Entries", draft invoices/entries are also included.
  • In any case, cancelled invoices/entries are not included.

To create a recurring cash flow plan, you need to:

  • Go to Accounting \> Reporting \> MIS Reporting \> Forecast Planner.
  • Create a new plan and set the periodicity (every X days, weekly or monthly).
  • Click on Generate Forecast Lines. The plan creates one cash flow forecast line per period between the start and end dates.
  • Use the Forecast Lines smart button on the plan to see the generated lines.

To limit how many lines a single plan can generate at once, you need to:

  • Go to Accounting \> Configuration \> Settings, section Cash Flow Plan.
  • Set the Max Forecast Lines value.
  • If generating a plan would exceed this limit, only the first lines up to the limit are created and a warning is shown.

No verified information in OCA: Installation, Configuration.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.