Construction: every job site's margin, in one question.

How a contractor went from 2 to 3 days of analysis to one question asked in French, starting from systems that didn't talk to each other.

Construction contractor

Knowing whether a job site makes money, while there is still time to act.

01

The problem

The contractor could not analyze the profitability of its job sites while they were under way. Costs, hours and project documents were spread across several systems, and the ERP had no API.

To know whether a job site was making money, an analyst exported the data and reconciled it in Excel. Each answer took 2 to 3 days, often too late to correct course.

We connected its source systems, including the ERP with no API, and keep them in sync in one place. The team keeps its current tools.

Connected systems
  • Autodesk (projects and documents)
  • QuickBooks (accounting)
  • Construction ERP (no API)
  • Timesheets

The same job site had a different name in each system. We reconciled it, then wrote with the team what the terms that matter mean. Actual margin is now compared with planned margin, job site by job site.

Definitions agreed with the client
  • Job site
  • Committed cost
  • Labour
  • Change order
  • Planned margin
  • Actual margin
05

Results

Project managers check the actual margin of their job sites without waiting for an export and a manual analysis.

  • Before
    2 to 3 days of analysis to get a job site's margin
  • Today
    one question asked in French
  • 21
    people checking these numbers

Tell us about your job sites.

Tell us which number you need on your job sites and which systems it lives in. We'll start with that one.