How to Forecast Profit From Your Trade Work Pipeline

A full diary tells you that you have work to do. It does not tell you whether that work is expected to make enough money.

To answer that question, build a forecast using only accepted work. For each secured job, record the agreed selling value, estimate the direct cost of delivering it and calculate the expected profit and margin. Then look at those figures across the weeks and months ahead.

This gives you a commercial view of the pipeline rather than a list of appointments. It can reveal a busy month with a healthy margin, a busy month that looks uncomfortably tight or a future gap that needs filling with the right kind of work.

What is a trade work pipeline profit forecast?

A trade work pipeline profit forecast estimates the financial result of work that customers have accepted but that has not yet been fully completed.

It should answer four practical questions:

• How much secured work do we have?
• What is that work expected to cost us?
• How much job profit should be left?
• When will we need the labour, materials and cash to deliver it?

The forecast will never be exact. Supplier prices change, site conditions create surprises and customers request extra work. Its purpose is not to predict every pound perfectly. Its purpose is to expose weak assumptions while there is still time to act.

Start with accepted work, not every possible job

An enquiry is not secured work. Neither is a quote that has been sent but not accepted.

If you add every open quote to the main forecast, the pipeline can look stronger than it really is. Three customers may be considering quotations worth £40,000, but none of that value is contracted until they accept.

Keep opportunities visible, but separate them from the secured forecast:

• Enquiries and draft quotes: possible future work.
• Sent quotes: opportunities awaiting a decision.
• Accepted quotes or contracted jobs: secured pipeline work.
• Completed jobs: work that belongs in actual performance reporting.

If a customer agrees to a genuine change in scope, add the accepted variation to the job value and update the expected costs. Do not count an unapproved extra simply because you expect the customer to agree to it later.

The four figures you need for every accepted job

1. Secured contract value

This is the value the customer has agreed to pay for the accepted scope. It is not necessarily the same as the amount already invoiced or paid.

If you are VAT registered, use a consistent net-of-VAT basis when assessing revenue and margin because output VAT is not your income. Costs should follow the same consistent basis, with irrecoverable VAT included where appropriate.

2. Forecast direct job costs

Include the costs you reasonably expect to incur because you are delivering that particular job. Depending on the trade and project, these may include:

• materials, delivery charges and consumables;
• your own productive labour allowance;
• employee labour and relevant employer costs;
• subcontractors;
• plant, access equipment and tool hire;
• skips, tipping fees and other waste costs;
• job-specific travel, accommodation, permits or parking;
• a sensible allowance for known risk or likely wastage.

A common mistake is to include materials and subcontractors but value the owner’s time at nothing. A sole trader’s internal labour allowance may not be an accounting wage expense, but it is still useful for management decisions. Without it, a labour-heavy job can appear more profitable than it really is commercially.

3. Forecast job profit

The basic calculation is:

Forecast job profit = secured contract value − forecast direct job costs

This is normally a job-level or gross-profit view. It is not the final net profit of the whole business because general overheads such as insurance, accountancy, advertising, office costs and software still need to be paid.

4. Forecast margin

Margin shows the forecast profit as a percentage of the selling value:

Forecast margin = forecast job profit ÷ secured contract value × 100

Do not confuse margin with markup. Markup compares profit with cost, while margin compares profit with the customer’s price. They produce different percentages.

A worked forecast for one accepted job

Suppose a plumber has an accepted bathroom refurbishment priced at £12,000 excluding VAT. The forecast costs are:

The forecast job profit is:

£12,000 − £7,900 = £4,100

The forecast margin is:

£4,100 ÷ £12,000 × 100 = 34.2%

If the plumber omitted the £2,400 internal labour allowance, the forecast would show £6,500 profit and a 54.2% margin. That may look excellent, but it would hide the value of the time required to complete the work.

Why you need to forecast the whole accepted workload

A single job can look reasonable while the combined workload creates a problem. Looking across accepted work helps you spot whether one low-margin project is consuming a disproportionate amount of capacity.

The combined forecast shows £48,300 of secured work and £14,000 of job profit before overheads. It also lets the owner investigate why the rewire has the lowest expected margin. The answer might be a genuine pricing problem, unusually expensive materials or simply a job that is strategically worthwhile for another reason.

The important point is that the decision is informed. A low-margin job is much more dangerous when nobody knows it is low margin.

Add timing to the forecast

Total pipeline value is useful, but timing turns it into an operating plan. A £30,000 job beginning in four months does not solve a labour gap next week, and a deposit received today does not mean the full contract value is available to spend.

Connect accepted jobs to realistic scheduled periods and consider:

• which weeks need employees or subcontractors;
• when large material orders must be paid for;
• whether two demanding jobs overlap;
• when stage invoices can legitimately be raised;
• whether the diary contains enough allowance for snagging, weather or delays;
• whether future work is concentrated too heavily in one customer or project.

Profit, cash and workload are related, but they are not the same thing. A profitable job can still create a cash squeeze if materials and wages must be paid well before the customer’s next payment stage.

Common forecasting mistakes in trade businesses

Treating pipeline value as profit

A £100,000 order book does not mean the business will make £100,000. Materials, labour, subcontractors, plant and waste may consume most of it.

Counting unanswered quotes as secured work

This can lead to hiring, purchasing or rejecting other work based on jobs the business has not actually won.

Using old supplier prices

A quote may have been prepared months before the work begins. Check significant materials and hire costs again when acceptance is delayed or market prices move.

Ignoring labour overruns

An extra two people for three days can damage margin even when no extra supplier invoice arrives. Forecast labour in hours or days rather than relying on a vague allowance.

Leaving small costs out

Delivery charges, parking, fixings, blades, protective materials and waste fees can become significant across several jobs.

Confusing customer deposits with earned profit

A deposit may be sitting in the bank, but it relates to future work. It may need to fund materials, labour and other commitments before any profit is earned.

Forgetting business overheads

Forecast job profit is not automatically the amount the owner can take home. Compare expected job profit with recurring overheads and other business costs to understand the wider position.

A practical process for maintaining the forecast

1. Update job status promptly. Move work into the secured pipeline only when the customer has accepted it.
2. Confirm the contracted value. Use the accepted scope and add only agreed variations.
3. Break down expected costs. Estimate materials, labour, subcontractors, plant, waste and other direct spend separately.
4. Use realistic dates. Connect the job to the diary so the forecast reflects when capacity and spending will be needed.
5. Review material changes. Update the forecast when supplier prices, labour requirements or scope assumptions change.
6. Compare forecast with actual results. Once the job is complete, examine where costs differed and use that knowledge on future quotes.

A short weekly review is usually more useful than rebuilding a large spreadsheet once every few months. Focus first on newly accepted jobs, projects with large cost changes and work starting soon.

How Tools2Done supports pipeline forecasting

Tools2Done connects customers, quotes, projects, scheduling, job costs, invoices and profitability information. Its Pipeline Forecast focuses on accepted work rather than including every enquiry, draft quote or unanswered quotation.

The forecast brings secured contract value, forecast job spend and forecast profit into one view. This helps an owner look beyond the number of bookings and assess whether the work ahead appears commercially healthy or tight.

As jobs progress, project costs and expenses can be recorded against the relevant work. Completed-job reporting can then show the actual result, helping the business improve future labour allowances, cost assumptions and pricing decisions.

Your next step: audit the next four accepted jobs

Take the next four jobs in your diary and write down the accepted value, expected materials, labour, subcontractors, plant and waste for each one. Calculate forecast profit and margin, then compare the jobs side by side.

If the figures are difficult to assemble, that is useful information in itself. It means the business needs a more connected way to move from accepted quote to schedule, cost tracking and final job result.