Profitability per project
One row per project: value sold, budget, revenue from approved client bills and cost from the building budget. Cost is split CAPEX and OPEX, with committed, margin and budget used.
PLANSScale only
The problem it solves
- You know what a job cost only when it is over and the accountant has closed the books.
- Every project manager says their site is fine; nobody puts the figures side by side.
- Capital spend and running cost are mixed, so the margin is hard to read.
How it works
- Run the project with an approved building budget and client progress bills. Nothing else is needed: the report reads them.
- Open Construction > Projects > Reporting > Profitability. Running projects show first.
- Each row shows the client, project manager, value sold, revenue, cost, OPEX and CAPEX cost, margin, margin % and budget used %. Projects losing money are in red.
- Use the filters Losing Money and Over Budget, or switch to the pivot or the bar chart to compare by project manager or client.
- The list icon on a row opens the budget lines behind the figures. The arrow opens the project.
Everything it does
Columns
- Value Sold: the project's contract value
- Budget: current amount of the approved building budget
- Revenue: gross of approved client progress bills
- Cost: actual of the approved budget lines (wages, billed purchases, approved subcontractor bills, plant log sheets, loan interest and fees, typed costs)
- Cost of Labour: the part on Labour cost codes
- CAPEX Cost and OPEX Cost: by each cost code's mark
- Committed: ordered or contracted, not yet spent
- Margin: revenue less cost; Margin %: margin ÷ revenue
- Budget Used %: (cost + committed) ÷ budget
Views and filters
- List, pivot (by project manager to start with) and bar chart of revenue and cost
- Filters: Running, Losing Money, Over Budget
- Group by project manager, client, status or Entity
- Totals at the foot of each money column
- Read only: nothing is typed here
How current it is
- Cost and committed are as the budget's last cost update counted them: every hour for approved budgets, or at once with Update Costs
- Revenue counts a client bill once it is approved
- Projects without an approved budget show revenue only
Who uses it
Managing directorCompares projects, finds the ones losing money, and asks why.
Construction ManagerReads the report and opens the budget lines behind a figure.
AccountsUses CAPEX and OPEX cost to see what builds the asset and what is running cost.
Where you use it
- Web: Construction > Projects > Reporting > Profitability (Construction Managers)
- Not in the phone app
- Not on the client portal
What you control
Settings
- CAPEX / OPEX mark per cost code, set once on the cost code list
- Labour cost codes (Cost Type Labour) decide the Cost of Labour column
- The contract value on the project gives Value Sold
Questions
Where does revenue come from?
From approved client progress bills, at their gross before retention and advance recovery. Payment plans of buyers in the Developer package are not counted here.Why is cost lower than our accounts show?
Cost is what the approved building budget has counted. A vendor bill that came from no purchase order or work order is not in it until you add it under Typed Costs. Overheads outside the project are not in it either.Can I see which costs make up a figure?
Yes. The list icon on a row opens that project's budget lines in Budget Analysis, by cost code, with committed and actual.Which plan has it?
Scale, with the CAPEX / OPEX mark on cost codes. The building budget itself is in every plan.Related features
MONEYBuilding budget with 80 and 100 % alertsOne budget per project, by cost code and place, approved once and changed only by approved revisions. Costs from site flow into it every hour. The project manager is told when a line passes 80 % and 100 % used.MONEYCommitments, forecast and over-budget checksEvery budget line shows what is already ordered or contracted, what is spent, what is still to come and where the line will end. A project purchase order that goes past what is left of its line needs a Construction Manager to confirm it.MONEYClient progress billsBill the client on the contract items. Each bill shows this bill, previous and up to date per item, the retention the client keeps and the advance taken back. It is approved inside first, prints as a progress bill, payment application or interim payment certificate, and becomes the customer invoice.MONEYCash flow planA month-by-month plan of money in and out for each project, filled from the budget, schedule, bills, wages and loans. Actual figures sit beside it, with the most money the project will need and when.PROJECTS AND SET-UPDashboards: Site, Projects, QualityReady dashboards open first in Construction: Site for every site engineer, Projects and Quality for managers, and Sales for the sales team. Every number counts only what the viewer may open, and a click shows the records behind it.
See your next site report on it.
Tell us what you build, how many sites you run and how your client hears about progress today. We will set up a project with you and send your first daily update.