Skip to Content

Odoo 19: forecasting invoicing per project milestone

November 16, 2026 by
Odoo 19: forecasting invoicing per project milestone

You sell your projects at a fixed price and invoice them by milestones: 30% when the mock-up is approved, 50% on delivery, 20% at go-live. Odoo 19 is very good at invoicing each milestone once reached. But ask it “how much will we invoice in March, and on which projects?” and it has no answer. Here is why, what the standard really does, and the free module I wrote to fill the gap.

1. The need, as it keeps coming up on the Odoo forum

Several users ask for it almost word for word: an expected invoicing report per milestone, where each amount would be milestone percentage × total of the sales order line, placed on the milestone deadline. In other words, a pivot table with projects in rows and months in columns.

The need is real: it is the cash-flow plan of a services company. An engineering firm, a web agency or an integrator whose revenue comes in steps wants to know what is left to invoice, what is late and what can go into this month’s invoicing run.

💡 Key takeaway

Milestone invoicing works in Odoo. What is missing is the overview over time.

2. What the standard does, checked in the code

In Odoo 19 (module sale_project), a milestone holds a sales order line, a percentage of its quantity and a deadline. When you tick “Reached”, the delivered quantity of the line becomes the sum of the reached percentages × the ordered quantity, and the next invoice bills that share. It is clean and it works.

But no field stores an amount on the milestone. A percentage alone does not add up in a pivot table: 30% of a €12,000 quote and 30% of a €2,000 quote make “60%”, which means nothing. I checked versions 18, 19 and 20: same structure, no amount. Odoo 20 does add a “Forecast Margins” report in Project, but it works per sales order line, not per milestone deadline.

💡 Key takeaway

Without an amount stored on the milestone, no monthly grouping is possible, in Community or in Enterprise.

3. The solution: an amount and a status on every milestone

The Milestone Forecast module adds to every milestone linked to a sales order:

  • the expected amount: milestone share × untaxed subtotal of the line, discount included, in the order currency;
  • the same amount in the company currency, converted at the rate of the order;
  • a status: Not Reached, To Invoice, Invoiced.

A new menu Project › Reporting › Milestone Forecast opens a pivot table (projects in rows, months of deadline in columns), a bar chart stacked by status and a list where late milestones stand out in red. Ready-made filters: Not Invoiced, To Invoice, Late.

💡 Key takeaway

Nothing changes in the way you work: you plan your milestones as before, the report fills itself.

4. The trade-offs, stated

Untaxed. The amount follows revenue, like the Sales Analysis report and the untaxed total of your invoices. A VAT-included cash-flow plan would need another column; I did not add it without being asked.

The order rate. The conversion to the company currency uses the rate Odoo stores on the order, the one of the Sales Analysis report. Your forecast therefore does not move with every rate update; on the other hand, it does not follow the rate of the deadline day.

A simple invoicing rule. The quantity invoiced on the line is allocated to its milestones, reached ones first (by date), then the others (by deadline). A fully covered milestone is “Invoiced”. A credit note created from the order or a cancelled invoice brings it back to “To Invoice”.

Access rights. In Odoo, every employee can read milestones, and portal customers those of shared projects. The added amounts and statuses are restricted to the Sales group: a site manager without sales access sees neither the menu nor the figures.

💡 Key takeaway

Amounts are stored and recomputed when the line, the share or an invoice changes, with a fixed number of queries: 6, whether there are 2 or 100 milestones. The pivot table takes a single query.

⚔️ The Match: standard Odoo vs Milestone Forecast

Criterion Standard Odoo 19 With Milestone Forecast
Amount of a milestone Percentage only, to multiply by hand Untaxed amount stored
Monthly forecast Export and spreadsheet Pivot table projects × months
Milestones to invoice or late Project by project One filter
Orders in foreign currency Not consolidated Converted to the company currency

Checked on Odoo 19 and 20, Community and Enterprise, demo database with three fictitious projects.

The Verdict: your milestones finally know what they are worth

The module is free, under the LGPL-3 licence, for Odoo 19 and 20: Milestone Forecast.

Does your project invoicing live in a spreadsheet next to Odoo? Let’s talk about it during an Odoo audit.

Request a Free Audit
Odoo 19: build a quotation from several quotation templates