A data audit is a structured look at how information moves through your business. The goal is simple: find out what is broken, and decide what to fix first.
The phrase can sound technical or heavy, so here is what a good audit covers, what you should expect to receive, and what it should not turn into.
What an audit looks at
- Where your data lives. Spreadsheets, databases, your CRM, accounting software, shared drives and email inboxes. Most businesses have more places than they realise.
- How it moves. Which information is copied by hand, which is exported and imported, and which flows between systems automatically.
- Who owns it. Who can change it, who relies on it, and who would notice if it went wrong.
- How reliable it is. Duplicates, gaps, conflicting versions and out-of-date records.
- What you use it for. The reports and decisions that depend on it, because data only matters in relation to what you do with it.
What you should receive
A good audit ends with something you can act on, not just a description of the problem:
- A map of how your data flows between people, spreadsheets and systems.
- The places where it breaks down, and what that is likely costing you in time or errors.
- A clear list of what to fix first, with the quick wins flagged.
- A written roadmap you could follow without the consultant.
That last point matters. The findings should be yours to keep, even if you decide not to work with the person who wrote them.
What an audit should not be
- A 50-page report that nobody reads. Length is not insight.
- An endless discovery phase. An audit should be focused on the areas that hurt most, not every process in the company.
- A sales pitch for a platform. If every finding ends with "buy this product", it is not an audit.
How to prepare
You do not need to tidy anything first. A little thinking beforehand helps, though:
- Pick the two or three processes that frustrate you most.
- Gather a few examples, such as a report you build by hand or a spreadsheet you rely on.
- Note who touches each step, even informally.
- List the systems you use, including the unofficial ones.
Questions to ask any consultant
- What exactly will I receive at the end?
- Do I keep the findings if we stop there?
- Which tools will you recommend, and are you tied to any particular ones?
- How will you explain the results, so that your whole team can follow them?
If you would like to see how we approach it, read about our data audits, or book a free 30-minute consultation to talk through your situation.