Many small trade and construction businesses juggle sticky notes, separate Excel files, emails and messenger chats. As enquiries grow, this quickly becomes a control problem: which enquiry needs a follow-up? What margin is in the quote? Which project is going over budget? Which payment is still outstanding?
That's why contractor estimating with Excel shouldn't just calculate a selling price. It should connect the whole process, from enquiry and estimate through quote and project to payment.
Straight to the tool: Contractor Studio brings together estimating, quote, job site, change orders, handover, invoice and job review in one offline app with Excel.
Which costs belong in a contractor estimate?
- Material costs – building materials, components, consumables and bought-in parts
- Labour costs – your own working time at a suitable hourly or charge-out rate
- Subcontracted work – subcontractors and outside specialist work
- Machines and equipment – job-related equipment costs
- Transport and travel – travel, delivery and job-related logistics
- Other direct costs – such as disposal, permits or job-related rentals
Only once the direct costs are fully recorded can overheads, selling price and desired profit be calculated sensibly.
Keep overheads and profit separate
Overheads arise in the business without being directly assignable to a job, for example admin, insurance, office, software, workshop or general vehicle costs. Profit, on the other hand, is the surplus after costs. Both should be kept separate in the calculation.
Markup and margin are not the same
Example: a job has calculated costs of EUR 8,000. A 25% profit markup leads to a net selling price of EUR 10,000. The profit is EUR 2,000. Relative to the selling price, that is a margin of 20%, not 25%.
If you want to sell at a specific target margin, don't treat markup and margin as the same thing.
More detail: the guide Material markup in the trades: markup, margin and quote price gives you the formulas, a worked example and a 5-step process for pricing.
Connecting quotes with the estimate
The estimate is the internal view. The customer needs a clear quote. Before sending, check at least the scope of work, quantities, net/gross amounts, discounts, deposit, payment terms, how long the quote is valid and any country-specific required details.
Enquiries and follow-ups help decide who gets the job
A good estimating system doesn't solve the problem if prospects are forgotten after the first contact. That's why a simple follow-up list makes sense. It should show the customer, the enquiry, the estimated value, the status, the next step and the follow-up date.
After winning the job: planned vs. actual review
A job you've won isn't automatically a profitable job. Once work starts, compare the planned costs with the actual costs.
- planned and actual total costs
- variance in euros or percent
- planned and actual gross profit
- actual margin
- extra work and change orders
This shows whether materials got more expensive, more working time was needed or extra subcontracted work came up. This data improves your next estimate.
Keep track of open payments
Revenue is not the same as money received. A system for trade businesses should therefore show deposits, balances due, due dates and outstanding invoices. Especially with several jobs running, a central overview stops amounts due from disappearing in separate files or emails.
Which figures belong on the overview?
- number and value of open enquiries
- quote volume and jobs won
- jobs in progress
- planned and actual gross profit
- open and overdue payments
- upcoming follow-ups
The goal is not to produce as many charts as possible, but to see on one page where action is needed today.
A practical process for trade businesses
- Record customer and company details in one place.
- Log every new enquiry with a next step.
- Estimate the job costs in full.
- Account for overheads and profit separately.
- Check discount, tax, deposit and balance.
- Review the quote before sending.
- Move jobs you've won into your job overview.
- Compare planned and actual costs during the job.
- Track open payments and due dates.
- After the job, evaluate variances for future quotes.
Excel or contractor software?
For larger organisations with many users, mobile site processes and complex accounting, a full ERP or specialised contractor software can make sense. Small businesses often first need a consistent, clear process. If your team is comfortable with Excel, a lot can be done with well-built spreadsheets. If you'd rather have estimate, quote, job site and invoice in one place without another monthly subscription, an offline app with Excel export is an option.
Practical help: Contractor Studio
Contractor Studio by ProPraxisPlan takes you from the first call to the final invoice: estimates with labour groups, materials and travel, a quote in one click, times and photos from the job site, change orders with signature, a handover record, progress and final invoices (including e-invoices) and a job review that shows where the money went.
The app runs offline in your browser, your data stays on your device, and everything can be exported as an Excel file. Buy once, no monthly subscription.
You'll find more tools for trade and construction businesses in Trades and construction, and calculation tools in Finance and pricing.
Frequently asked questions about contractor estimating with Excel
Can Excel replace contractor software?
For small, manageable processes, a structured Excel setup can handle many organisational tasks. With complex accounting, many users, time tracking or deep integrations, specialised software is often better suited.
What matters more: markup or margin?
The two figures answer different questions. Markup is calculated on costs; margin relates profit to the selling price. For pricing decisions, both should be clear.
Why do follow-ups belong with estimating?
Because a correctly calculated quote brings in no revenue if nobody follows it up and tracks its status. Estimating and sales go together in day-to-day work.
Note
This guide explains basic organisational and costing principles and is not tax, legal, accounting or other professional advice. Tax treatment, required details, costing assumptions and legal requirements must be checked for your business and country.