# Project Wise Profit
Project Wise Profit shows revenue, costs, and profit margin for each project in a selected month or custom date range — optionally filtered by project supervisor.
Overview
Go to Project → Reports → Project Wise Profit.
What it shows. One row per project with man hours, unconsidered hours, payslip cost, consumables, purchase cost, expenses, total cost, sale value, profit, and profit margin percentage. Additional Cost and Unconsidered Cost columns appear when those per-hour rates are set on at least one project in the result.
Use Cases
- Monthly P&L by job — Select the current month to review which projects are profitable.
- Supervisor review — Filter by Project Supervisor to see all jobs managed by one employee.
- Drill-down from employee report — Opened automatically when you click an employee name on Employee Wise Project Profit.
Filters
| **Filter** | **Description** |
|------------|-----------------|
| Year | Calendar year for the report. |
| Month | January through December, or Custom for a date range. |
| Date range | Shown when Month = Custom. |
| Project Supervisor | Optional — filter to projects supervised by one employee. |
Columns
| **Column** | **Description** |
|------------|-----------------|
| Project | Project name (click to open project). |
| Project code | Project reference number. |
| PWO number | Shown when any row has a PWO number. |
| Man Hours | Total labour hours on the project (considered + unconsidered). |
| Unconsidered Hours | Hours that do not overlap a posted or paid payslip. |
| Payslip Cost | Salary cost allocated only to considered hours (hours overlapping a payslip). |
| Unconsidered Cost | Unconsidered Hours Cost per Hour × unconsidered hours. Shown when that rate is set on at least one project. |
| Consumables | Cost of consumable issues. |
| Purchase Cost | Approved purchase invoice value. |
| Expenses | Approved expense value. |
| Additional Cost | Additional Cost per Hour × total man hours. Shown when that rate is set on at least one project. |
| Total Cost | Payslip Cost + consumables + purchases + expenses + Additional Cost + Unconsidered Cost. |
| Sale Value | Approved sale invoice value. |
| Profit | Sale value minus total cost. |
| Profit Margin % | Profit as a percentage of sale value. |
Footnotes on the report explain Payslip Cost, unconsidered hours, and additional cost. Set the rates on the project under Cost Settings.
Actions
- Generate — run the report with current filters.
- Export — download to Excel.
- Print — print the report.
FAQ
Why is profit negative on a project?
Costs (purchases, consumables, expenses, payslip cost, and any extra project rates) exceed sale value for the selected period. Check whether all revenue has been invoiced.
Does the report include draft documents?
Only approved transactions are included in cost and revenue figures.
Why is a project missing from the list?
Projects with no approved activity in the selected month or date range may show zero values or be omitted depending on filters. Widen the date range or clear the Project Supervisor filter.
What is the maximum date range?
Custom date ranges are limited to 12 months. Use Year and Month filters for standard monthly reporting.
How is Payslip Cost calculated?
From approved payslips overlapping attendance on the project. Only considered hours (hours that overlap a posted or paid payslip) are included. Unconsidered hours are not in Payslip Cost.
What are Unconsidered Hours?
Attendance hours with no overlapping posted or paid payslip. If Unconsidered Hours Cost per Hour is set on the project, those hours are costed at that rate. See Cost Settings.
Why is there no Additional Cost column?
The column appears only when at least one project in the result has Additional Cost per Hour set.
How does this differ from Project Summary?
Project Wise Profit lists all projects for a period with one row each. Project Summary is a detailed single-project report with breakdown tables and KPI widgets.
Do the same totals appear on Project Dashboard?
Yes. Financial KPI widgets on Project Dashboard use the same calculation as this report for the selected period, including labor and extra project rates.
Why do PWO columns appear on some rows only?
The PWO Number column is shown when at least one project in the result set has a PWO value entered and the field is enabled in Project Settings.