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.
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.