Knowledge · Estimating
The builder's cost database,
the asset behind every price.
Items, rates, labour constants and composite rates, maintained like an asset rather than left to decay like a spreadsheet. What the database holds, where rates drift, the invoice-actuals loop that keeps it honest, and whose job it is in a small building company.
01 / Overview
What a cost database is
A cost database is the builder's maintained record of what work actually costs. It holds cost items (one per priceable element of work), the current rate for each, the labour constants that say how long a task takes, and composite rates that combine material, labour and plant into a price per unit of finished work. It is the pricing engine behind every method described in the estimating reference, and building it is one of the core pieces of work that makes estimating accurate at all.
Defined precisely, the database is a structured, dated, sourced set of rates the business trusts enough to contract off. Each of those words is doing work. Structured means the items mirror the cost codes the rest of the job uses. Dated and sourced mean every number can say where it came from and how old it is. Trusted means the rates are corrected from real jobs, not adjusted by feel.
Why it matters
The alternatives to a database are memory and published guides, and both fail in predictable ways. Memory holds perhaps a few dozen rates with no date on any of them, and it leaves the business when the person holding it does. Published cost data is a legitimate reference class, but it describes an average market, not your suppliers, your subbies or your standard details. Your own corrected rates are the number that holds. A maintained database also compounds, because every finished job leaves the rates slightly more accurate than it found them, which is the quiet mechanism behind builders whose second decade of estimates is sharper than their first.
02 / The lifecycle
Where the database sits in the estimating workflow
In the estimating workflow, takeoff produces the quantities and the database prices them. Everything upstream of the database is measurement; everything downstream is judgement (packaging, preliminaries, margin, review). That position makes it the single point where a systemic error multiplies, because one stale rate prices wrong on every estimate that touches it, in both directions. The full sequence from qualification to contract is covered in the construction estimating guide.
The database is also where the estimating loop closes. When a job finishes and actual costs are compared against the estimate by cost code, the differences have exactly one useful destination, the rates that produced them. A business that runs this loop is estimating from evidence; a business that does not is estimating from the market as it stood the last time somebody had a quiet week.
03 / Process workflow
Building and maintaining the database
Eight steps, from structuring the items to closing the loop at job completion. The first five build the asset; the last three are the maintenance schedule that stops it decaying.
- 01
Structure the items before the rates
Decide the cost items and how they map to your cost codes before entering a single price. A database whose items match the way the business buys, builds and reports is one where actuals can flow back without translation.
- 02
Seed from published data and real quotes
A new database starts from published cost guides and the quotes already in the inbox. Published rates are a reference class, a defensible starting point, and every one of them should expect to be replaced by your own number.
- 03
Attach labour constants
Record productivity (hours per unit of work) separately from the labour rate. Wages move often; how long a task takes moves slowly. Splitting them means a wage change is one edit, not a hundred.
- 04
Build composite rates from the parts
Combine material, labour and plant into composite rates per unit of finished work, keeping the build-up visible. A rate you cannot decompose is a rate you cannot correct.
- 05
Record source and date on every rate
Every rate carries where it came from (supplier quote, invoice actual, published guide) and when. An undated rate cannot be trusted, and a dispute is lost the moment the original price cannot be produced.
- 06
Correct from quotes as they land
Each supplier and subcontractor quote received during tendering is fresh market data. Held against the database rate, it either confirms the number or corrects it before the next job is priced off it.
- 07
Code invoice actuals back against estimate lines
The fastest correction loop in estimating. When invoices are coded to the lines that priced the work, drift shows up within weeks of the work happening, not at close-out months later.
- 08
Review estimated against actual at close-out
Compare by cost code, push the corrections into the database, and note why each gap happened. This is the loop that compounds; skip it and every job starts from the same stale numbers.
04 / Key mechanics
What a working cost database holds
Six components. The rates get the attention; the metadata and the labour constants are where the long-term value sits.
Cost items
The unit of the database. One item per priceable element of work, structured to mirror your cost codes so estimates, purchase orders and actuals all speak the same line items.
Unit rates
The current price per unit of measure (square metre, lineal metre, each), held with material and labour separated. A single blended number hides which half of the rate is drifting.
Labour constants
Productivity data, the hours a task takes per unit of work. The slowest-moving and hardest-won data in the database, and the part that makes first-principles pricing possible.
Composite rates
One rate for a unit of finished work, built up from its material, labour and plant parts. Fast to apply at estimate time, and honest only while the build-up behind it stays visible.
Supplier price files
The current agreed pricing from regular suppliers, with the date and the document it came from. This is the paper trail that settles a quote-versus-invoice dispute.
Rate metadata
Source, date, supplier and the job a number was proven on. Metadata is what separates a database from a list of figures nobody can vouch for.
Two structural rules keep these components useful. First, rates are held at cost, with profit applied deliberately at the estimate level where it can be seen (the distinction is covered in margin and markup). Second, items are combined into reusable build-ups, so a correction to one item flows into every assembly that uses it; that reuse layer is assemblies and recipes, and it is how a small builder gets first-principles accuracy at unit-rate speed.
05 / Rate drift
Where rates drift, and how drift is caught
Rates do not drift on a schedule; they drift when suppliers move, and suppliers move mid-job. A recurring pattern builders report is the supplier invoice that arrives above the agreed purchase-order price, often because the supplier priced from their own outdated rates, and the dispute then turns entirely on paperwork. If the original quoted rates were held in someone's head, or in an email nobody can find, the supplier can deny the original pricing and the builder absorbs the overrun. The dispute is lost at the moment the source rate cannot be produced, which is a database failure, not a negotiation failure.
The quote-versus-invoice gap is also the estimator's best early-warning signal. Every invoice that lands above the rate that priced the work is telling the business one of two things, either the market has moved or the supplier is chancing it, and both answers matter. Catching the gap requires deliveries and invoices to be checked against what was ordered, which is the discipline covered in receiving and invoice matching. An unmatched invoice is not just a payables risk; it is market data the database never receives.
Drift also has a background rate. Australian construction input costs have escalated materially and unevenly across materials, fuel, wages and charges in recent years (the figures are in the Australian considerations below), which means a database that was accurate at its last review is not merely ageing, it is ageing in a moving market. The practical consequence is that maintenance cadence is a pricing decision, not an administrative one.
06 / Best practice
How experienced builders keep the database alive
The operators who estimate well hold a view that sounds like semantics and is not. A cost database is an asset with a maintenance schedule; a spreadsheet of rates is a document that decays. The difference is not the software, it is whether anyone is accountable for the numbers between estimates. A stale database is more dangerous than no database, because it produces numbers that are precise, confident and wrong, and precision is exactly what stops anyone questioning them. The builder pricing from a guessed range at least knows to be nervous.
The second thing experienced operators know is that the fastest correction loop is not the annual review or the close-out report, it is invoice actuals coded back against the estimate lines that priced the work. That loop corrects a rate within weeks of the work happening, on evidence, while the close-out review is still months away. It also turns the database into a form of construction knowledge the business owns rather than rents from whoever currently holds the rates in their head, because the learning of every finished job is stored where the next job can use it.
Whose job it is
In a small building company there is no quantity surveying department, so the database needs one named owner and several feeders. The owner is whoever estimates, and their accountability is the structure, the corrections and the review cadence. Accounts feeds it by coding invoices to estimate lines rather than to a general materials bucket. Supervisors feed it by confirming whether the labour constants match what crews actually achieve on site. In practice the arrangement fails in one specific way, the feeding stops in a busy month, so experienced builders make the feeds part of an existing process (invoice approval, close-out) rather than a separate task that can be skipped.
Where software fits the workflow
Traditionally the database lives in a spreadsheet, quotes are checked against it by eye, and invoice actuals never reach it at all. In VIABUILD the database sits under the estimate itself. Takeoff quantities price from your rates and assemblies, Oryn™ reads supplier invoices and matches them against purchase orders, and the actual lands coded against the line that priced the work, so the correction loop runs as a by-product of paying the bills. The estimator still owns every rate; the system just stops the evidence going missing. The wider discipline of tracking cost against estimate is covered in the builder cost tracking guide.
07 / Australian considerations
Cost data and the Australian market
The database itself is not regulated, but the Australian cost environment it describes has specific features worth knowing. The points below are labelled by evidence class; figures change, so confirm the current source before relying on any of them.
- Common practice. Published cost data (Rawlinsons' construction cost guides, Cordell) is widely used to seed databases and benchmark rates, and is updated on a publication cycle. Treat published rates as a reference class, not your rates; your database, corrected from your own jobs, is the number that holds.
- Industry data. Industry forecasters have put the construction cost base up roughly 35 per cent since 2019, with further escalation forecast for 2026 in the range of 7 to 7.5 per cent across fuel, materials, wages, superannuation, insurance, interest and government charges (ACIF and related industry commentary). Construction is also described as the economy's most diesel-dependent industry (Civil Contractors Federation), so fuel moves flow through cartage, plant and materials pricing. Confirm current figures before using them in a price review.
- Professional recommendation. Match the review cadence to volatility. Many builders run a full database review against the annual cost guide publication, correct volatile trades more often, and let the invoice-actuals loop run continuously underneath both.
- Common practice. Rates are held exclusive of GST and exclusive of margin, so the database, supplier quotes and invoices can be compared like for like. GST treatment in pricing is a recurring estimating trap; confirm your structure with your accountant.
08 / Common mistakes
How cost databases actually fail
None of these failures announces itself. Each one is discovered inside a job that was priced months earlier, which is the most expensive place to learn anything.
Treating it as a spreadsheet, not an asset
An asset has a maintenance schedule and an owner. A spreadsheet decays quietly until an estimate built on it loses a job, or worse, wins one.
Pricing off published rates forever
Published guides are a reference class, sound for seeding and sanity checks. A builder still pricing off them two years in has a library, not a database.
One blended rate per item
When material and labour live in a single number, a supplier increase and a productivity problem look identical. Split rates can be corrected; blended rates can only be guessed at.
No date or source on rates
An undated rate gives no warning it has expired, and a rate with no source cannot be defended when a supplier invoices above the price that was agreed.
Quotes never reconciled to invoices
The quoted rate and the invoiced rate are two different observations of the same market. A builder who never compares them is estimating from prices nobody confirmed were ever paid.
The database in one person’s head
Rates held in memory walk out the door with the person holding them. The knowledge is real; it is just not an asset the business owns until it is written down and maintained.
09 / Practical example
A worked drift scenario
Illustrative only, not a benchmark. A builder's database holds a wall framing composite rate of $92 per square metre, last corrected fourteen months ago from a real invoice. The timber supplier has since lifted prices twice, and the true current rate is nearer $101. Every estimate priced in between has carried framing roughly 9 per cent light, silently, on a rate nobody had reason to question because it was precise and had once been proven.
Now run the same scenario with the invoice loop closed. The first framing invoice after the supplier's increase lands above the purchase order, the match flags it, and the coded actual corrects the database rate that week. One job wears a modest overrun on one trade; every subsequent estimate prices framing at the real number. The difference between the two scenarios is not estimating skill, it is whether the business had a route for an invoice to talk to a rate.
10 / FAQ
Common questions.
On two clocks at once. Event-driven corrections happen continuously, every supplier quote, every subbie price and every coded invoice either confirms a rate or corrects it. Scheduled reviews then sweep whatever the events missed; many builders align a full review with the annual publication of the cost guides and revisit volatile trades more often. A database corrected only on the schedule, without the event-driven loop, is always pricing from the last review rather than the current market.
From published cost guides, from the quotes and invoices already sitting in the business, and from the last few completed jobs if their costs were coded. Published data gets a workable database standing in weeks rather than years, and that is its proper role. Every seeded rate should be treated as provisional until a real quote or a real invoice from your own jobs has confirmed or replaced it.
A labour constant is productivity data, the hours a task takes per unit of work, for instance hours per square metre of a given wall type. The labour rate is what an hour costs. Kept separate, a wage movement is a single edit to the rate and every item reprices; blended together, every wage movement means re-deriving every item. Constants also move far more slowly than prices, which makes them the most durable value in the database.
Common practice is to hold rates at cost, excluding GST and excluding margin, so the database answers one question only, what the work costs. Margin is then applied deliberately at the estimate level where it can be seen and defended, and GST is handled in the pricing structure rather than buried inside rates. Mixing either into the rates makes every later comparison against quotes and invoices a units problem. Confirm the GST treatment for your own pricing structure with your accountant.
It needs one named owner, and in most small builders that is whoever estimates, the estimator if the role exists, otherwise the owner or builder pricing the work. Everyone else feeds it. Accounts supplies coded invoice actuals, supervisors confirm whether the labour constants match what crews actually achieve, and whoever lets trade packages passes quote data back. Owned by nobody, the database becomes the spreadsheet nobody trusts and everybody quietly overrides.
A spreadsheet can hold the items and rates, and plenty of builders start there. The weakness is not storage but connection. The spreadsheet does not receive coded invoice actuals, so the correction loop runs on manual effort, which is exactly the effort that stops in a busy month. Whatever the tool, the test is whether an invoice paid on a job can find its way back to the rate that priced the work without someone re-keying it.
11 / Terms
Glossary for this topic
Cost item (one priceable element of work), unit rate (price per unit of measure), labour constant (hours per unit of work), composite rate (one rate combining material, labour and plant for finished work), rate metadata (the source and date behind a number), reference class (published data used for benchmarking rather than pricing), invoice actual (the cost evidenced by a paid invoice). Definitions for the wider vocabulary live in the construction glossary. From here, the natural next article is assemblies and recipes, where the database's items combine into the reusable build-ups that price whole elements at once.
12 / Keep reading
Related knowledge, guides and features
13 / Further reading
Primary sources
- Rawlinsons construction cost guides , the reference Australian construction cost data, updated annually and the usual seed for a new database.
- Australian Institute of Quantity Surveyors , professional guidance on measurement and cost data practice.
- The Australian Construction Industry Forum's published forecasts, for the industry-level cost escalation figures referenced above.
- Your own coded job cost records, the only cost data source that describes your suppliers, your subbies and your standard details.
Correct a rate once, and every future estimate inherits it.
VIABUILD prices estimates from your maintained database and assemblies, then codes invoice actuals back against the lines that priced the work, so the rates stay current as a by-product of running the job.
