We're pleased to introduce the Quick P&L Report, a simple and powerful way to view the profitability of a job at a glance.
This new report brings together quoted values, actual job costs, and invoiced amounts into a single summary, helping you quickly understand how each job is performing financially throughout its lifecycle.
What does the Quick P&L Report show?
The report provides three key profitability views:
Quoted Profit
Quoted Profit is calculated using the total cost and total price of all line items on the quote.
Calculation:
Total Quoted Price
Minus Total Quoted Cost
This allows you to review the expected profit and margin when the job was initially won.
Current Profit
Current Profit is based on the work completed so far.
Calculation:
Actual Job Price
Minus Actual Job Cost
Actual Job Price includes the total price of all tasks and parts recorded against the job.
Actual Job Cost includes the total cost of all tasks and parts recorded against the job.
This gives you a live view of job profitability before invoicing is complete.
Actual Profit
Actual Profit is calculated using the total cost and total price of all line items on invoices raised against the job.
Calculation:
Total Invoice Price
Minus Total Invoice Cost
This provides visibility of profitability based on invoiced amounts.
Profit Margin Included
Alongside each profit calculation, the report also displays a Profit Margin %.
Profit Margin (%) shows the percentage of the job value that remains as profit after costs have been deducted.
Formula:
(Price - Cost) ÷ Price × 100
Example
Actual Job Price: £100
Actual Job Cost: £40
Profit: £60
Profit Margin:
(£100 - £40) ÷ £100 × 100 = 60%
This means that 60% of the job value has been retained as profit after costs have been deducted.
Key Figures Included
Metric | Description |
|---|---|
Total Quoted Cost | Total cost of all line items on the quote (pre-VAT) |
Total Quoted Price | Total price of all line items on the quote (pre-VAT) |
Actual Job Cost | Total cost of all tasks and parts recorded against the job (pre-VAT) |
Actual Job Price | Total price of all tasks and parts recorded against the job (pre-VAT) |
Total Invoice Cost | Total cost of all line items on invoices raised against the job (pre-VAT) |
Total Invoice Price | Total price of all line items on invoices raised against the job (pre-VAT) |
Why use the Quick P&L Report?
The Quick P&L Report helps managers and administrators to:
Review profitability without running detailed financial reports
Compare quoted margins against actual performance
Identify jobs where costs are exceeding expectations
Monitor work in progress before invoicing is completed
Understand profitability based on invoiced values
With all key figures presented on a single screen, the Quick P&L Report provides a fast and accessible overview of job performance from quote through to invoice.
Availability
The Quick P&L Report is available now within WorkPal and can be generated for individual jobs, providing an instant snapshot of quoted, current, and invoiced profitability.