| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Project (project)
• Purchase (purchase) • Discuss (mail) • Invoicing (account) • Sales (sale_management) • Employees (hr) |
| Lines of code | 236 |
| Technical Name |
project_profitability_custom |
| License | LGPL-3 |
| Website | https://www.twentic.com |
| Versions | 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Project (project)
• Purchase (purchase) • Discuss (mail) • Invoicing (account) • Sales (sale_management) • Employees (hr) |
| Lines of code | 236 |
| Technical Name |
project_profitability_custom |
| License | LGPL-3 |
| Website | https://www.twentic.com |
| Versions | 18.0 19.0 |
Project Profitability
Measure the real profit margin of each project based on sales, purchases and timesheet costs â in real time.
How the Profitability Margin is Calculated
Margin (%) = (Revenue − Total Costs) / Revenue × 100
Revenue
Sum of amount_untaxed from confirmed Sale Orders (state = sale / done) linked to the project via project_id.
Total Costs
Sum of three cost sources detailed below, all linked via the project's analytic account.
Vendor Bills
Posted Vendor Bills & credit notes whose lines include the project's analytic account in analytic_distribution. Credit notes reduce the cost automatically.
Purchase Orders
Sum of price_subtotal from confirmed PO lines (state = purchase / done) with the analytic account in analytic_distribution.
Timesheet Costs
abs(∑ analytic.line.amount) for the project. Odoo stores this as a negative debit (hours × employee cost rate), so the absolute value gives the real cost.
Profitability Level â colour-coded badge
< 0 %
0 â 20 %
20 â 50 %
> 50 %
1. New Menu Entry under Project
Once the module is installed, a Profitability menu entry becomes available inside the Project app. From there you can access the list of all projects with their computed margin and level without leaving the project context.
2. Kanban View with Profitability Ribbon
The standard Project Kanban view is extended with a colour ribbon showing the exact margin percentage on each project card. The ribbon updates automatically when timesheets are logged and can be manually refreshed for sales and purchase changes via the Recompute button.
Key Features
Real-Time Margin Calculation
Sales, Purchases & Timesheets
Colour-Coded Level Badges
Please log in to comment on this module