Project P&L: did this project make money?
Revenue, cost, net profit and margin for one project, and budget against actual underneath. It reads from the invoices, bills, payroll and stock already in the books.
Now onboarding companies in Dhaka.
PRJ-AUTOMATION · Line Automation Upgrade
rd_capex · cost_plus · —active
Revenue
- Invoiced (pre-VAT)
- BDT 15,00,000
- Completed milestones (billable)
- BDT 10,00,000
- Total revenue
- BDT 25,00,000
Cost
- Direct bills
- BDT 12,00,000
- Allocated bills (multi-project shares)
- BDT 1,00,000
- Direct cost subtotal
- BDT 13,00,000
- Payroll charges
- BDT 3,50,000
- Stock movements
- BDT 1,50,000
- Indirect cost subtotal
- BDT 5,00,000
- Total cost
- BDT 18,00,000
Net
- Net profit
- BDT 7,00,000
- Margin
- 28%
Budget vs Actual
| Category | Budget | Actual |
|---|---|---|
| materials | 27,00,000 | 9,50,000 |
| subcontract | 7,00,000 | 2,50,000 |
| labour | 6,00,000 | 3,50,000 |
| other | 5,00,000 | 2,50,000 |
| Total budget | 45,00,000 | 18,00,000 |
The project P&L, in four boxes
Four boxes on one page: what came in, what went out, what was left, and how that compares with the plan.
- 01Revenue
What you invoiced
Invoiced amounts before VAT, plus the billable value of completed milestones.
- 02Cost
What it cost
Direct bills and allocated bills, then payroll, stock and talent fees as indirect cost.
- 03Net
What was left
Net profit and margin, so you can see at once whether the project is paying.
What each box holds
- Revenue
- Invoiced (pre-VAT), completed milestones, and the total.
- Cost
- Direct bills, allocated bills, the direct subtotal, payroll charges, stock movements, talent fees, the indirect subtotal, and total cost.
- Net
- Net profit and margin.
- Budget vs Actual
- The budget and the actual by category, with the total budget.
- Same books
- Every line is read from the entries already posted, so nothing is typed in twice.
The P&L is where everything on the project ends up
It holds no figures of its own. It adds up what the other tabs and the main books already know.
What feeds it
- Job Cost
Direct cost by code.
- Progress Billing
Revenue from certificates.
- Milestones
Revenue from completed milestones.
- Bill Allocations
Shared costs allocated to the project.
What follows it
- WIP
Earned revenue and estimated profit.
- Financial Reports
Company statements.
Where it shows up
- Ledgers
The accounts behind each line.
- Accounting Hub
Headline numbers at a glance.
A P&L per project, not just per company
A company can be profitable while one project loses money. Only a project P&L shows which.
Revenue, pre-VAT
VAT is not income, so revenue is shown before it.
Direct and indirect
Direct bills and allocations apart from payroll, stock and fees.
Margin at a glance
One percentage tells you if the project pays.
Budget against actual
By category, so the biggest gap is easy to find.
One project, from first bill to margin
A sample project, the way it usually runs.
The project starts with a 45,00,000 budget.
Bills and payroll begin to post.
A certificate and a milestone are invoiced, 25,00,000 in all.
Total cost to date is 18,00,000.
Net profit is 7,00,000, a 28% margin.
How different trades use the project P&L
- Retail
Margin on each store opening.
- Food & Hospitality
Margin on each event and build-out.
- Real Estate
Profit by development and by building.
- Consulting
Profit by client engagement.
- Manufacturing
Profit by line or plant project.
- Health & Fitness
Profit by fit-out.
- Trades
Profit by job.
- Others
Surplus or deficit by programme.
Questions we get about the project P&L
What goes into revenue?
Invoiced amounts before VAT, and the billable value of completed milestones.
What goes into cost?
Direct bills, allocated bills, payroll charges, stock movements and talent fees.
Is VAT included?
No. Revenue is shown before VAT.
What is the margin?
Net profit as a percentage of revenue.
Does it match the main books?
Yes. It reads from the same entries.
Where is Adon ERP available?
We are currently onboarding companies in Dhaka. Book a demo and we will walk through a sample project with you.
Bring a finished project. We will build its P&L in the demo.
A live demo in English or Bangla, using sample books close to your own trade, with time for your accountant’s questions.