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:
- multiple spreadsheets saved by different staff
- supplier lists downloaded and never properly merged
- duplicate inventory items in ServiceM8
- old prices copied from previous invoices or quotes
- engineers using item names that are similar, but not identical
- no clear owner for price updates
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:
- product code or SKU
- product name
- supplier name
- cost price
- selling price
- VAT status, if relevant to your workflow
- category, such as plumbing, heating, HVAC or electrical
- last updated date
- notes for replacements, discontinued items or pack sizes
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:
- ServiceM8 inventory
- supplier spreadsheets
- old quote templates
- Xero product lists
- personal spreadsheets kept by office staff
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:
- review supplier price changes on a regular schedule
- update your central list before changing live job pricing
- archive old versions rather than overwriting everything blindly
- check for duplicate items before imports or syncs
- 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:
- two team members give different prices for the same item
- engineers ask the office to confirm material prices regularly
- your ServiceM8 inventory has multiple versions of the same product
- supplier increases take weeks to show up in quotes
- nobody is fully sure which spreadsheet is current
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.