Know which jobs made money

Costed correctly

“We were busy all year and made nothing.”

The vans were out every day, the fitters were flat out, and when the accounts came back in the spring there was nothing in them. Nobody can point at the jobs that did it, because the only place the money was ever added up was at the end of the year.

Installa adds it up job by job while the work is still going on: what it sold for, what it actually cost, and what was left.

What each job made

Sold for, cost, profit and margin, job by job.

Where the work comes from

Sources, conversions by stage, and why the rest were lost.

What the open work is worth

Open work, weighted by the win probability on each stage.

Tables you can read

Numbers by job and by person, with a date range and filters on every report.

Costed correctly

What the job cost, against what it sold for

Every job has a cost sheet. Materials, labour as hours against a rate, subcontractors and anything else, set beside the money actually coming in. The quote fills in the first version of it, so you are correcting a figure rather than starting from a blank page, and the scaffold that came in dearer than expected is on the job the day you find out.

The profitability report then puts every job in one table: sold for, cost, profit, margin. Sort it by the thinnest margin, or tick the box to see only the thin ones, and the pattern usually shows up straight away. It is rarely all the jobs. It is the ones with two days of scaffold, or the ones a particular person priced.

Beside it the costs are split into materials, labour, subcontractors and other, and the profit trend shows whether the last few months are going the right way.

The job profitability report: a table of jobs with revenue, cost, profit and margin for each, and the total cost broken down into materials, labour, subcontractors and other
Customers looked after

Where the work comes from, and why you lose it

You already have a feeling about which advert pays for itself. The lead sources report has the figures: how many enquiries each source brought, what they were worth, how many were won, and the reasons the rest were lost, because each one was given a reason when it was closed.

Conversions by stage show where enquiries stop moving. If half of them die between the survey and the quote, that is a fortnight in your own process, not a market problem.

Sales performance does the same per person: enquiries, won, lost, conversion and revenue, with a date range on it.

The sales performance report: a table of the sales team with enquiries, won, lost, conversion rate, revenue and average deal for each person

What the open work is worth, and what the team can fit in

Enough warning to book a crew, or to stop and go out selling.

Pipeline

What the open enquiries are worth, both as a raw total and weighted by the win probability you set on each stage. The second number is the one to plan with.

Likely, not just possible

The weighted figure is the open work multiplied by each stage’s chance of winning, so a board full of new enquiries does not read like a board full of orders. A thin likely figure is a warning you can still act on.

Delivery

Installs scheduled, completed and overdue, jobs per installer, crew utilisation and the workload grid, so the plan is checked against what the team can actually fit in.

A record of who did what

Tables you can read, not a wall of charts

The reports are tables of numbers with bars where a comparison needs a shape. Each one has a date range and the filters that suit it. Profitability is job by job and sales performance is person by person, so you can see what sits behind a figure instead of guessing at it.

Everything is under Reports: sales, pipeline, forecast, profitability, conversions by stage, lead sources, sales performance, jobs, installation metrics, crew utilisation and workload.

Taking the numbers out

These lists export to CSV, for your accountant or your own spreadsheet:

Enquiries
Customers
Jobs
Tasks
Pipeline
Sales performance
Products

The other reports are read on the screen. There is no Excel file, and nothing is emailed to you on a schedule.

What it does not do

Better you know before you start than after.

  • A job only appears in the profit figures once somebody has put its costs on it. Installa can start that off from the quote, but it cannot know what the scaffolder charged you unless it is entered.
  • It does not connect to your accounting software.
  • There is no invoicing and no payment tracking beyond marking a deposit paid, so the revenue on a job is what it sold for, not what has been banked.

Where the numbers come from

Reports are only as good as the work that feeds them.

The guide

Running a solar installation business by the numbers

The seven numbers an owner should know, and the weekly and monthly review that turns them into decisions.

Read the guide

See it with one of your own jobs

Put in one real enquiry, draw the roof, check the design and send yourself the quote. You will know within the hour whether Installa would have caught the things that went wrong last month.

Start free Ask a question