Simpro Data Cleanse Service | Platinum Consultants
Simpro Data Cleanse Service

Years of Data Entry Normalised and Perfected.

We connect directly to your Simpro build to normalise and enrich every customer, supplier, site, and contact record. Cross-referenced against official Australian government data, Google Places, and live ABN lookups. You get back a fully audited, import-ready dataset.

12.65M
Official Australian address points used to validate every property, street, and suburb
3 Phases
Extract, Normalise, Import. Nothing is touched in Simpro until you review and approve the outputs
100%
Read-only during extraction. Nothing in Simpro is changed without your approval
Read-only API extraction
No records created or deleted
Full change report and audit trail
Simpro-import-ready CSV files
ABN validated via ATO algorithm
The silent cost of CRM data

The Problem With Simpro Data Over Time.

Every business that has used Simpro for more than a year has the same problem: data quality degrades silently. It happens because Simpro is used under time pressure by real people, imported from old systems, or populated by customers themselves. Over time, the errors compound.

The consequences are practical: mail merges and invoices look unprofessional when names are in the wrong case. Postal deliveries fail when addresses are malformed. ABN verification fails for customers or suppliers with incorrect numbers. Duplicate records create double-billing risk. Reporting becomes unreliable when state and postcode data is inconsistent. And importing data to a new system or integration carries the errors forward.

Fixing these problems manually, record by record, is not realistic at scale. A business with 2,000 customer records and 10,000 sites cannot afford to have a staff member review every field. That is what this service exists to solve.

Common data quality issues we find

  • Phone numbers entered with brackets, labels, or extra text — or multiple numbers in one field
  • Company names in ALL CAPS from bulk imports or old system migrations
  • Suburb in the postcode field, state written out in full, or a full address crammed into the street line
  • ABNs missing, misformatted, failed the checksum, or registered as Cancelled in the ABR
  • Email addresses with domain typos, defunct ISP providers, or no active mail server
  • Duplicate contact records accumulating across customers and sites
  • Common Pty Ltd entry errors such as "Pry Ltd", "Ptu Ltd", or "Proprietary Limited"
  • Postcodes that do not match the suburb and state on record
  • Job title spelling errors: "manger", "techincian", "electritian"
90%+
Address confidence threshold. Misspelled suburbs are fuzzy-matched and auto-corrected only when we are confident in the result. Below that threshold, records are flagged for your review rather than silently changed.
Modulus 89
The ATO's official ABN validation algorithm. Every ABN is validated before any lookup. Missing ABNs are searched against the Australian Business Register by company name.
Deliverables

What You Will Receive.

We deliver two things for every file type processed: customers, suppliers, sites, contacts, employees, and contractors. Nothing is a black box — every change is documented before anything goes back into Simpro.

Cleaned CSV Files
One file per entity type, formatted to Simpro's import specification and ready to upload directly. Only changed fields are updated. We never create new records and never delete existing ones. You can choose to apply only certain corrections — for example, phone fixes only — by reviewing the relevant columns before importing.
Excel Change Report
A five-tab report covering a summary dashboard, every change made with the original value alongside the corrected value, items requiring a human decision, potential duplicates with confidence levels, and records with no address. A sixth tab is included when Google Places enrichment has run. This is the paper trail that lets you verify and, if needed, reverse any correction before it goes back into Simpro.
Transparent pricing

Priced by Record Volume.

Every tier covers all entity types in your Simpro build: customers, suppliers, sites, contacts, employees, and contractors. No per-field fees. No hidden extras. The price is set by your total record count.

Up to 10,000 records
Small to Mid-Size Build
$499
+ GST
10,000 to 50,000 records
Growing Business
$999
+ GST
50,000 to 100,000 records
Large Operation
$1,899
+ GST
100,000+ records
Enterprise Build
Custom
Pricing on request

We verify your record count before confirming the price. Enquire below and we will confirm your tier and quote before any work begins.

What is included at every tier
  • Read-only extraction via Simpro REST API — nothing changed without your approval
  • Full normalisation of business names, phone numbers, email addresses, websites, and addresses
  • ABN and ACN validation using ATO Modulus 89 and ASIC Modulus 10 algorithms
  • ABR cross-reference for every business entity — missing ABNs looked up by company name
  • Approximately 40 email domain typo corrections, defunct ISP flagging, and live MX record checks
  • 16-step address pipeline validated against 12.65 million official Australian address points
  • 4,858 locality alias and 31,317 street alias mappings resolved
  • Street numbers and unit numbers validated against GNAF address points
  • Duplicate detection with HIGH and MEDIUM confidence flags across all entity types
  • Google Places, web, and ABR enrichment for records with missing addresses
  • Cleaned CSV files formatted to Simpro import specification — one per entity type
  • Five-tab Excel change report: dashboard, changes made, needs review, duplicates, missing addresses
Best suited for
  • Businesses that have been on Simpro for a year or more
  • Teams preparing for a system audit, integration, or new software migration
  • Businesses that have grown through acquisition and need imported data merged cleanly
  • Any business where data quality issues are slowing operations or creating errors
Also included at every tier
  • Secure, credential-based API access only — no third-party data brokers used
  • Nothing imported without your explicit review and approval
  • Items requiring a human decision clearly flagged in the Needs Your Review tab
  • Import is update-only — blank columns are never overwritten, selective imports are safe
The cleaning engine

Examples of What We Fix and Enrich.

Our cleaning pipeline validates against 12.65 million official Australian address points covering every state and territory, plus the Australian Business Register, Google Places, and live MX record checks. Here is a breakdown of what we handle.

Business and Person Names
Company Name Normalisation
ALL CAPS names converted to proper Title Case. Acronyms preserved: PTY LTD, BMW, HVAC, NSW. Common Pty Ltd entry errors corrected. Reversed names detected. Junk values stripped: email addresses, phone numbers, and bracket notes found in name fields are removed and flagged.
Phone Numbers
Phone Format Standardisation
Every phone type normalised: landlines (0X XXXX XXXX), mobiles (04XX XXX XXX), 1300, 1800, satellite. Dirty fields with labels, brackets, or multiple numbers handled automatically. 8-digit numbers have area codes inferred from state.
Email Addresses
Email Cleaning and Validation
Lowercased, whitespace removed, approximately 40 domain typo corrections applied. Defunct ISP addresses flagged. Every domain checked for active MX records. Freemail providers flagged on business records. Role-based addresses (info@, admin@) noted.
Addresses
16-Step Address Pipeline
Validated against 12.65 million address points. Covers all states and territories including the NT. Wrong postcodes corrected, not just missing ones filled. Street numbers and unit numbers validated against GNAF address points. 4,858 locality alias and 31,317 street alias mappings resolved.
ABNs
ABN Validation and Lookup
Every ABN validated using the ATO's Modulus 89 algorithm. ACNs validated via Modulus 10. Missing ABNs looked up against the Australian Business Register by business name. Cancelled ABNs flagged. ABNs that fail the checksum are never silently deleted.
Duplicates and Websites
Duplicate Detection and Web Cross-Checks
HIGH confidence flags: same ABN, same email, same mobile, same site address. MEDIUM confidence: same company name, same phone. Websites stored in consistent www.domain format. Dead domains, expired registrations, and email domain mismatches flagged as advisory notes.
Typical change rates from real Simpro installs
"Customer records: approximately 76% change rate. Main drivers are phone formatting, company name case, address fields, and ABN formatting."
"Supplier records: approximately 99% change rate. ALL CAPS names, dirty phone fields, and ABN formatting mean almost every supplier record needs correction."
"A typical install of 2,500 customers, 10,000 sites, 9,500 contacts, and 800 suppliers — around 23,000 records total — completes in 5 to 10 minutes."
Simple and straightforward

How the Process Works.

For a typical installation the entire run completes in 5-10 minutes, generating a comprehensive paper trail documenting every modification.

01
Extract from Simpro
We connect to your Simpro instance via its REST API using read-only credentials. Nothing is changed at this stage. Parallel fetching retrieves full field data for every entity type. Every business record is simultaneously cross-referenced against the Australian Business Register.
Read-only
02
Normalise and Validate
The cleaning pipeline runs against the extracted data using 12.65 million official Australian address points, the ABR, live MX record checks, and Google Places. Names, phones, emails, addresses, ABNs, and websites are all processed. Duplicates are flagged before any normalisation takes place.
Deterministic pipeline
03
Review Your Report
You receive the cleaned CSV files and the Excel change report. Review every modification before anything goes back into Simpro. Nothing is imported without your sign-off.
You approve first
04
Import Back to Simpro
Once you approve the cleaned CSV files, they are imported back into Simpro. We only update changed fields. We never create new records and never delete existing ones.
Safe and targeted
05
Done
Your Simpro data is clean, consistent, and fully documented. A complete audit trail is yours to keep, covering every change that was made during the process.
Full audit trail
Get started today

Stop Guessing. Start Cleaning.

Book your Data Cleanse Service and get back a Simpro dataset you can trust. Clean records, validated ABNs, consistent formats, and a full audit trail to keep.