Back to website
Latest news

How to Create One Source of Truth for Business Pricing

Published 16 Oct 2026 • 1172 words
How to Create One Source of Truth for Business Pricing

If your office team, engineers and quotes all pull prices from different places, mistakes are almost guaranteed. One person checks an old supplier spreadsheet, another uses a saved list in ServiceM8, and someone else copies a price from a previous job. It does not take long for small differences to turn into lost margin, awkward customer conversations and extra admin.

For UK trade businesses, especially in busy autumn months when plumbing and heating firms are gearing up for winter demand, having one reliable place for pricing matters more than ever. If your team is quoting boilers, cylinders, valves, controls or general materials every day, you need a single source of truth.

This guide explains how to build one, how to keep it accurate, and how to make it useful inside your existing workflow.

What a single source of truth actually means

A single source of truth for business pricing is one trusted system or file that holds your latest approved material prices. Everyone uses the same information, whether they are pricing a job, adding items in ServiceM8, checking a supplier increase or reviewing margins.

It does not mean every part of your business has to live in one piece of software. In practice, many ServiceM8 users keep their core pricing data in a central spreadsheet, then sync that data into the tools their team already uses.

The important bit is simple. There should be only one place where a price is edited first.

Why trade businesses struggle with pricing consistency

Most pricing problems do not start with bad intentions. They usually grow over time.

Common causes include:

During October and the run-up to winter, this gets worse. Jobs come in faster, urgent heating work increases, and teams have less time to double-check every line item. That is when messy pricing systems start costing real money.

What to include in your central pricing list

Your one source of truth should be practical, not overcomplicated. For most small and medium trade businesses, a well-structured Google Sheet is enough.

Key fields to keep in one place

Include columns such as:

This gives you a clean foundation for better pricing control with Materialm8.

Keep naming consistent

If one item is called “15mm copper elbow” in one place and “Copper Elbow 15 mm” somewhere else, duplicates creep in quickly. Pick a naming format and stick to it. Your office staff and engineers do not need perfect data language, but they do need consistency.

How to build your pricing source of truth

You do not need a huge system overhaul. Start with a simple process and tighten it up.

1. Choose your master pricing location

For many ServiceM8 users, Google Sheets works well because it is easy to update, share and review. It also gives you a clear place to compare supplier changes before they affect live pricing.

2. Audit your current price sources

List every place prices currently live. This often includes:

Once you know where prices are coming from, you can decide what should stay and what should be retired.

3. Clean and combine your data

Merge duplicates, fix naming issues and remove items you no longer use. This is often the most time-consuming part, but it is also where the biggest improvements happen.

4. Assign one person to approve updates

Not everyone should be changing prices whenever they like. Give one person responsibility for approving changes, even if several team members help gather supplier data.

5. Push approved prices into ServiceM8

Once your master list is updated, your ServiceM8 inventory should reflect that same data. This is where many firms lose time by updating items one by one.

If you want a simpler way to connect your central list with ServiceM8, Materialm8 is built for exactly that job.

How to keep it accurate over time

Creating one source of truth is only half the job. The other half is keeping it trustworthy.

A few habits make a big difference:

  1. review supplier price changes on a regular schedule
  2. update your central list before changing live job pricing
  3. archive old versions rather than overwriting everything blindly
  4. check for duplicate items before imports or syncs
  5. make sure your team knows which list is the approved one

For seasonal businesses, autumn is a smart time to do this properly. Plumbing and heating companies heading into colder months often see more quoting volume, more material movement and more pressure on office teams. A reliable pricing source helps you move faster without creating chaos.

Signs your business does not yet have one source of truth

You probably need to tighten up pricing control if any of these sound familiar:

These are not just admin annoyances. They are warning signs that your pricing process is too fragile.

Make your systems support the way you already work

The best pricing system is the one your team will actually use. It should be easy to maintain, easy to check and easy to connect with ServiceM8.

That is why many UK trade firms use Google Sheets as the master record, then use tools to keep ServiceM8 aligned with it. You keep the flexibility of a spreadsheet, while reducing manual updates and avoidable mistakes.

If you want to see a straightforward way to do that, explore Materialm8 for ServiceM8 users. It helps trade businesses create a clearer pricing process without rebuilding everything from scratch.

Final thoughts

A single source of truth for pricing is really about control. It helps your whole business work from the same numbers, protects margins and cuts down the back-and-forth that slows office teams down.

If your current setup relies on old spreadsheets, memory or manual updates in too many places, now is a good time to fix it before winter gets even busier. Visit Materialm8 to see how you can keep your pricing data cleaner, more consistent and easier to manage inside ServiceM8.