Revenue & Profitability
- Revenue
- Gross Profit
- Gross Margin
- Operating Profit
- Operating Margin
All resources
Free Excel Scorecard
Know Which Jobs Are Actually Driving Your Business
The free Vertex Contractor KPI Scorecard helps you track revenue, margins, job performance, major costs, working capital and backlog, all in one practical Excel workbook.
Microsoft Excel · Free download · No signup required
Revenue isn't the whole story
A Busy Contractor Isn't Necessarily a Profitable One
Revenue alone doesn't tell you what is happening inside the business. Labour, subcontractors, materials, overhead and job-level cost overruns can materially change what remains after the work is completed.
The Contractor KPI Scorecard brings those financial drivers together so you can review the business and individual jobs with greater visibility.
See the Financial Drivers Behind the Business
Cost Structure
- Direct Labour
- Subcontractors
- Materials
- Direct Job Costs
- Overhead
Cash & Working Capital
- Cash
- Accounts Receivable
- Accounts Payable
- A/R Days
- Working Capital
Operating Activity
- Jobs Completed
- Jobs in Progress
- Backlog
- Approved Change Orders
Job performance
See How Your Jobs Are Performing Against Estimate
Revenue can look strong while individual projects perform very differently from what was originally estimated. The Job Performance section helps you compare estimated and actual or current direct costs across your projects.
| Job | Contract Value | Estimated Cost | Actual / Current Cost | Estimated Margin | Actual / Current Margin | Cost Variance | Margin Variance |
|---|---|---|---|---|---|---|---|
Compare up to 10 recent or active jobs and identify which projects are contributing most to changes in cost and margin.
For in-progress jobs, results represent current performance based on the information entered and may change as additional costs are incurred.
Understand Where Job Economics Changed
Original Contract Value
+Approved Change Orders
=Revised Contract Value
Estimated Direct Costs
vs.
Actual / Current Direct Costs
Estimated Margin
vs.
Actual / Current Margin
See whether labour, subcontractor, material or other direct costs changed from the original estimate and how those changes affected job margin.
Profit and Cash Don't Always Move Together
Contractors often experience timing differences between completing work, invoicing customers, collecting receivables and paying employees, subcontractors and suppliers.
The scorecard includes working-capital measures to help you monitor cash, accounts receivable, accounts payable and collection timing alongside profitability.
Cash Balance
Accounts Receivable
Accounts Payable
A/R Days
Current Ratio
Cash Coverage
Keep Backlog in Context
Track contracted work that has not yet been recognized as revenue and review it alongside current job activity and financial performance.
Backlog is not the same as cash, recognized revenue or guaranteed profit. Its significance depends on project timing, capacity, costs and the circumstances of the business.
One workbook. The numbers that matter.
Enter your monthly financial and job information and the scorecard organizes revenue, margins, costs, working capital and backlog into a single view.
Contractor KPI DashboardMonthly view
Revenue
Gross Margin
Operating Margin
Cash
A/R Days
Backlog
Revenue & gross profit trend
Direct cost mix
Labour
Subcontractors
Materials
Other
Estimated vs. actual / current job margin
Job 1
Job 2
Job 3
Illustrative layout. Values shown are representational only.
What's included
What's Inside the Scorecard
Start Here
Instructions and guidance for using the scorecard.
Monthly Inputs
Enter monthly revenue, direct job costs, overhead, working capital and operating activity.
Job Performance
Compare estimated and actual/current job costs, margins and variances across recent or active jobs.
KPI Analysis
Review revenue, profitability, cost structure, working capital and operational KPIs.
KPI Targets
Compare performance against your own financial targets.
Working Capital
Monitor cash, receivables, payables, collection timing and liquidity.
Action Plan
Surface financial questions worth investigating based on the information entered.
Executive Dashboard
Review key contractor financial metrics and trends in one place.
How it works
Enter Your Monthly Numbers
Replace the fictional example with your own revenue, job costs, overhead and working-capital information.
Add Your Jobs
Enter estimated and actual/current costs for recent or active projects.
Set Your Targets
Enter your own financial goals rather than relying on generic industry benchmarks.
Review the Business
Use the KPI analysis, job-performance section and executive dashboard to understand what is driving the numbers.
Built for Owner-Led Contractors & Trades
General contractorsRenovation contractorsElectrical contractorsPlumbing contractorsHVAC contractorsRoofing contractorsLandscaping contractorsPainting contractorsOther project-based trades businesses
Get Better Visibility Into Your Jobs and Margins
Download the free Contractor KPI Scorecard and use your own numbers to review financial performance, job profitability, costs, working capital and backlog.
Free Excel workbook · No signup required
Need better financial visibility in your contracting business?
Vertex Strategic Finance provides CPA-led accounting and advisory support to owner-led businesses, helping owners better understand profitability, cash flow and the financial drivers behind their decisions.
Book a Complimentary ConversationThis resource is provided for general informational and educational purposes only. It is not accounting, tax, legal, investment or construction-law advice and does not constitute an assurance engagement. Results depend on the assumptions and information entered. The workbook does not perform formal WIP accounting, percentage-of-completion accounting or revenue recognition. Consider your business circumstances and seek professional advice where appropriate.