A pure-Excel audit workflow looks free because there's no subscription invoice, but three specific costs accumulate over several years and are easy to miss until they actually happen: version control incidents where two staff members edit different copies of the same working paper and the firm loses track of which is authoritative; knowledge loss when a senior or manager who built the firm's informal Excel templates and macros leaves, taking the undocumented logic with them; and peer review or quality control findings that trace specifically to spreadsheet-based evidence — missing version history, no enforced review sign-off, formulas that can be silently overwritten without a trace.
Version control incidents — more common than firms admit
An Excel-based working paper shared over email or a shared drive has no built-in way to show which version is current once more than one person has touched it. This usually works fine for years, until a specific incident happens: a senior sends a schedule by email for review, the partner edits a saved local copy, and the two versions diverge without anyone noticing until a figure doesn't tie out weeks later during finalisation.
- A reviewer approving a working paper without realising it's not the latest version, because the file was emailed back and forth rather than tracked in one place.
- Two team members independently correcting the same error in their own copies, producing two different 'corrected' versions neither of which is reconciled against the other.
- A figure changed in one schedule not propagating to a dependent schedule that references an old, now-incorrect, pasted value rather than a live formula.
Knowledge loss from staff turnover
A firm's Excel-based system is often, in practice, a set of templates, macros, and informal conventions built up by whichever senior or manager has been there longest. When that person leaves, the firm doesn't just lose a staff member — it loses the undocumented logic behind why a schedule is structured the way it is, which formula does what, and which shortcut the firm has quietly relied on for years.
| What's lost | Why it's rarely documented |
|---|---|
| The logic behind a complex cross-referencing formula or macro | Built incrementally over time by one person, rarely written down as it was built |
| Which client-specific quirks a template already accounts for | Learned through experience on that client, not captured in a written procedure |
| Why a particular shortcut or workaround exists in a schedule | Often added under time pressure during a prior busy season and never revisited |
Peer review and quality control findings tied to spreadsheets specifically
- No evidence of who reviewed a working paper and when, because Excel doesn't enforce or timestamp a review sign-off the way a dedicated system does.
- No change history for a schedule, making it hard to show an inspector exactly what changed between a draft and final version and why.
- Formulas quietly replaced with pasted static values during the file's life, with no trace of when or why that happened — a common finding that's hard to defend after the fact.
None of these costs show up as a line item anywhere, which is exactly why they're easy to underweight against a software subscription's very visible, very specific cost. A firm comparing the two fairly needs to put a number, even a rough one, on the version-control incident it had last year or the templates it's still rebuilding since a senior left.
Common practice, not a requirement
A useful exercise: ask the firm's own staff, honestly, whether a version-control mix-up or a 'who built this formula and why' moment has happened in the last two years. Most firms running a pure-Excel process for several years will have at least one real example, and that example is the actual cost comparison, not an abstract argument.
This is practical guidance written for audit teams, not an authoritative statement of any standard or statute. Standards, forms and timelines change. Check the current text issued by the ICAI and the relevant authority before relying on anything here in an audit file.
Related resources
- Technology, data & AI in auditMigrating from Excel working papers to audit softwareWhat a firm actually gains and loses leaving Excel, the version chaos Excel creates across a review chain, and a realistic first-engagement timeline.
- Technology, data & AI in auditAudit software ROI for small CA firms: how to think about itA worksheet a firm fills in with its own numbers: hours on repetitive matching, the value of partner time, and what that adds up to before and after.
- Audit workflow & automationData migration checklist: moving prior-year working papers to new softwareThe question isn't just what to move over — it's what to deliberately re-create instead of migrating, and how to document the switch itself.
- Audit workflow & automationPresenting the case for audit software to a skeptical senior partner"We've always done it this way and it's worked fine" is the objection underneath most of the others. Here's how to actually meet it, not just talk past it.
Free tools, no signup
Each one reads a file entirely in your browser — or, for two of them, just answers a few questions — and nothing is ever uploaded.
- Purchase register checkDuplicate payments, round-sum amounts, weekend-dated invoices, incomplete records.
- GSTR-2B reconcilerMatches your purchase register against GSTR-2B — missing invoices either side, amount mismatches.
- Bank reconciliation checkerMatches your cash book against a bank statement — what's outstanding on each side.
- Fixed asset register checkDuplicate asset codes, missing location or useful life, negative net book value.
- Payroll red-flag scannerBank accounts shared across employees, and records missing an ID, PAN or salary.
- CARO applicability checkerAnswer a few questions about the company and see which CARO 2020 clauses likely apply.
- MSME payment delay checkerMSME-flagged invoices paid — or still unpaid — beyond the 45-day Section 22 limit.
- Related-party transaction screenerTransactions above a threshold you set with no approval reference, grouped by counterparty.
- Depreciation useful life checkerCompares a useful life in use against the Schedule II, Part C indicative figure.
- Materiality calculatorOverall and performance materiality against PBT, revenue, assets or equity, with reasoning shown.
- Sample size calculatorStatistical sample size for a test of controls or a substantive test of detail.