Blog

Moving internal audit off spreadsheets: what to move first

· internal-audit, spreadsheets, migration

Most internal audit functions run on spreadsheets, and for a small team with a short plan they work well: everyone knows them, they cost nothing, and they bend to any methodology. They break in predictable places, and those places tell you what to move first.

Where spreadsheets break

When a file leaves the audit team. Inside the team, a shared file is fine. The moment an issue tracker goes to twenty business owners for updates, you have twenty copies, three of them edited, and a merge that someone does by hand on a Friday.

When the question is "what changed". A spreadsheet has no memory. Who moved that due date? What did this observation say before it was softened? When did this risk score change, and on whose word? A year later you are reconstructing it from mail.

When two people work at once. Fieldwork is two or three auditors in the same workbook. Locked files and "final_v3_updated" are the symptom.

When evidence gets heavy. Work papers link to files in folders. The folders move, the links break, and the evidence behind a finding is the one thing that must still be findable when the finding is challenged.

When you need a number across audits. How many issues are open across the organisation? How many are overdue, and where? Any single spreadsheet can answer for itself. The answer across twenty of them is a manual roll-up nobody enjoys.

Move the issue register first

It is the part that hurts most and the part that is easiest to move. It is shared with people outside the audit team, it goes stale, and its whole value is knowing what is late right now.

What you need is small: the open issues, their observation, an owner, an agreed action, a due date and a status. Take the open ones. The closed ones can stay in the archive.

The change people notice in the first month is not the tool. It is that chasing stops being a weekly job for the audit team, because owners see their own overdue items themselves.

Then the audit universe and the risk assessment

Move these in time for next year's plan, not in the middle of this one. You need the entity list with owners, the scoring factors and their weights, and last year's scores as a starting point.

The work here is agreement, not data entry. Whatever was implicit in the spreadsheet — why "payroll" scores high, what "complexity" means — has to be written down. That is uncomfortable, and it is the point: it is also what makes the plan defensible when the audit committee asks.

Then fieldwork, with the next audit

Do not convert audits in flight. Start with the first audit of the new plan: work papers, evidence, observations and review in the system, from the kick-off. One audit end to end teaches the team more than any training, and an audit that is half in a spreadsheet and half in a system is worse than either.

What to leave alone

The archive. Old audits stay where they are, read-only, with a note saying where to find them.

Analysis. Sampling, data analysis, reconciliations: do them wherever you do them well, which is usually a spreadsheet, and attach the result as evidence. An audit system is a system of record, not a replacement for analysis.

Anything with one user and no history. A personal tracker that works, works.

A sequence that finishes

  1. Weeks 1 to 2: the issue register, open items only, owners confirmed.
  2. Weeks 3 to 6: the audit universe and the risk model, with the weights written down.
  3. The next audit: fieldwork in the system, end to end, with a senior reviewing in it too.
  4. The next plan: built from the scores, and reported from the system.

Every step ends with something working. The functions that stall are the ones that try to be fully migrated by a date, which means running two systems while carrying on with the actual audits.

Where a product fits

AuditEase Pro covers that whole sequence in one system: audit universe and risk scoring, the annual plan, fieldwork and observations, reports, and issues with owners and due dates. It is single-tenant and white-label, so it carries your organisation's name, runs on infrastructure you choose, and is quoted per customer rather than per seat, which is what makes giving auditees access a process decision rather than a budget one.

The live demo holds a fictional organisation with a plan, audits, observations and an issue register already in it, so you can walk the sequence above before deciding anything.

Common questions

Do we have to migrate our old audits?
No, and usually you should not. Keep the archive where it is, read-only, and start in the new system with the current plan. Migrating history costs weeks and is read about twice a year.
How long does the move take?
The software is quick. The time goes into agreeing the questionnaires, risk weights and report template, which is your methodology written down. If it is already in a manual, that is days rather than months.
What if our methodology is still changing?
Move the issue register first. It barely depends on methodology, and it is where a spreadsheet costs you most. The risk assessment can wait for the methodology to settle.
Will auditees have to learn a new system?
They see a small part of it: their questionnaires, the observations raised against their area and their action plans. In practice that is a walkthrough, not training.