Excel estimating: where it breaks down
Updated Reza3 min read
Excel estimating breaks down after you win, not while you price. The takeoff and the price drift apart, versions live in filenames, the won quote is retyped into a budget, committed costs stay invisible until the bills land, and one person holds it all together. A connected system keeps your rates and logic but removes the re-typing.
Draft.This article hasn’t had its final edit yet, so treat anything specific in it as provisional.
Every estimator has a spreadsheet they're proud of. Years of refinement, rates that reflect hard-won experience, formulas tuned to how your trade actually prices work. Excel is flexible, familiar and effectively free — which is why most subcontracting businesses in Australia still quote with it.
The problem isn't building an estimate in Excel. The problem is everything that happens after you win.
Where does Excel estimating break down?
1. The estimate and the takeoff drift apart
Quantities live in one tab (or one file), pricing in another. Revise the takeoff after a drawing change and the cost sheet doesn't always follow. Two versions of the truth, and the one you submitted might be the wrong one.
2. Version control by filename
Quote-FINAL-v7-REVISED-USE-THIS-ONE.xlsx is funny until a variation dispute lands and
you need to prove exactly what was priced, when, and against which drawings. A paper
trail assembled from file dates and memory is not a paper trail.
3. Winning the job means re-typing the job
The estimate was cost-coded beautifully — then the job gets tracked in a different spreadsheet, or someone re-keys the numbers into accounting software. Every re-type is a chance for the budget to stop matching the quote. Usually it takes that chance.
4. Committed costs are invisible
Excel can tell you what you've paid. It's much worse at what you've committed — the purchase orders raised and subbie packages let that haven't hit the accounts yet. By the time the invoices land, the money was spent weeks ago and the forecast is history.
5. One person holds the whole thing together
The spreadsheet works because one person knows how it works. When they're on leave, on site, or off to a competitor, the business is guessing. And a shared drive full of formulas has no concept of who's allowed to see margin.
Spreadsheet or connected system: what changes?
The same five failure points, side by side:
| Job | In a spreadsheet | In a connected system like Subino |
|---|---|---|
| Quantities | A takeoff tab or file the price may or may not follow | Measurements held against the scope, inside the revision you priced |
| Revisions | Filenames and file dates | Every revision kept on the job, with the quantities it was priced against |
| Budget | Retyped from the quote | The won estimate is the budget, cost code by cost code |
| Committed cost | Invisible until the invoice arrives | On the job the day you raise the purchase order |
| Forecast | Reconciled by hand, usually late | A forecast final cost and profit remaining on every code |
| Who sees margin | Anyone with the file | Each role sees what the database allows |
What should moving off Excel actually mean?
Moving off Excel shouldn't mean abandoning what made your spreadsheet good — your rates, your cost codes, your way of pricing. It should mean keeping that logic and connecting it: takeoff quantities held against the scope inside the revision you priced, the won estimate becoming the live budget the day you win, purchase orders capturing committed cost the moment you order, and a forecast final cost per cost code that updates while there's still time to act.
That's how Subino is built — estimating and job-cost management with the same cost-coded backbone from the first price to the final claim. And you don't start from an empty system: your jobs, budgets, contacts, purchase orders and bills import straight from a spreadsheet, so day one already has the work you've got on the books.
Book a demo — bring your spreadsheet, and we'll show you what it looks like connected. Pricing shows what each plan includes.
Frequently asked questions
Is Excel good enough for construction estimating?
For building a price, often yes — a good estimator's spreadsheet holds years of tuned rates and logic. It struggles after you win: the budget gets retyped from the quote, committed costs and progress claims live in other files, and revisions are tracked by filename. That is where most job cost problems start.
What are the biggest risks of estimating in Excel?
The takeoff and the cost sheet drifting apart after a drawing change, version control by filename, retyping the won estimate into a budget, committed costs that stay invisible until invoices arrive, and the whole system depending on the one person who understands the formulas. None of them shows up until something has already gone wrong.
Can I import my Excel estimates into Subino?
Not the estimates themselves. The import template takes your jobs, budgets, contacts, purchase orders and bills from a spreadsheet, mapped onto your own cost codes. Your rates and scope logic go in once as your price book and templates, and every new job starts from them.
Do I have to stop using my spreadsheet straight away?
No. The sensible first move is to price your next real job in Subino alongside your spreadsheet and compare the two. Jobs already half-run in a spreadsheet are usually better finished there.
Who can see margin in a connected system?
In Subino the crew, the office and management each see what their role allows, because the database enforces it rather than a hidden button. Margin stays with the people who are supposed to see margin — something a shared drive full of formulas can't do.