FMCG Management Analytics
The Collective Dairy
This enhancement provided the client with better insights into their operations, facilitating informed decision-making.
Read case study →Spreadsheet Auditing
Will the spreadsheet you rely on pass an audit?
Spreadsheet errors are more common — and more costly — than most businesses realise. We provide independent spreadsheet audits for New Zealand businesses, reviewing the models and workbooks that support critical decisions before those errors surface at the wrong moment.
Book a free consultationSituations that call for a spreadsheet audit
Common spreadsheet risk scenarios across New Zealand organisations.
A critical spreadsheet is used for major financial decisions but has never been reviewed by anyone outside the team
Formula errors discovered after a report has already been presented to the board or auditors
A model inherited from someone who has left — and no one is sure if the logic is still correct
Circular references or broken links that have been ignored because no one knows how to fix them
Inconsistent formulas across rows where some cells have been manually overridden
A spreadsheet that works most of the time — but occasionally produces numbers that look wrong
Spreadsheet audit case studies
Issues found — and prevented — through independent spreadsheet review.
Finance
Investment Model Audit
Pre-investment review of a target company's three-statement financial model identified three formula errors and two structural issues that materially affected the valuation output.
Regulatory
Regulatory Submission Spreadsheet Review
Independent review of calculation spreadsheets used in a regulatory submission — confirmed methodology, identified two input cells with incorrect references and provided a written sign-off report.
Operations
Pricing Tool Audit
Audit of a pricing spreadsheet used by a sales team revealed that margin calculations were using an outdated cost basis in two product categories — immediately corrected before a major contract renewal.
IT Handover
Departed Staff Spreadsheet Review
Structured review of three critical workbooks inherited after a key staff member left — documented what each does, identified risks and produced a maintenance guide for the team.
Our audit process
Structured, independent review with a written report.
01
Intake and scope
- Receive the spreadsheet and understand its purpose
- Identify the decisions, reports or processes it supports
- Agree the scope and depth of review required
Deliverable: Confirmation of audit scope and expected turnaround.
02
Structured audit
- Formula consistency and error checking
- Logic review — does the model calculate what it says it does?
- Structural review — inputs, calculations, outputs, documentation
- Data integrity and input validation assessment
03
Report and recommendations
- Written audit report with findings categorised by severity
- Recommendations for fixes or improvements
- Optional: we fix identified issues as a separate engagement
Deliverable: Audit report with findings, risk ratings and recommendations.
Spreadsheet auditing across New Zealand
We provide independent spreadsheet auditing to businesses and organisations throughout New Zealand — Auckland, Wellington, Christchurch, Hamilton, Tauranga and beyond. Audit engagements are conducted remotely under NDA. We have audited spreadsheets used in finance, insurance, property, regulatory compliance and executive decision-making across New Zealand.
Frequently asked questions
When should a spreadsheet be professionally audited?
A spreadsheet should be audited when it supports significant financial decisions, is used in regulatory submissions, has been inherited from someone who has left, or has grown in complexity beyond what the original author intended. If numbers from a spreadsheet are used to make material decisions, it is worth getting independent assurance.
What does a spreadsheet audit actually involve?
Our audits review formula consistency (are all rows using the same logic?), calculation integrity (does the model do what it says it does?), structural quality (inputs, calculations and outputs properly separated?), error checking (broken references, circular references, hard-coded overrides) and documentation adequacy.
How long does a spreadsheet audit take?
A straightforward workbook audit typically takes two to four days. A complex multi-sheet model or a formal audit with a written report suitable for external use typically takes five to ten business days.
Can you audit a spreadsheet confidentially?
Yes. All audit engagements are conducted under a non-disclosure agreement. We handle your data securely and return or delete files at the conclusion of the engagement.
Do you fix issues found during the audit?
The audit itself produces a report of findings. We offer a separate remediation engagement to fix identified issues — this can be quoted after the audit is complete and the scope of fixes is clear.
Get independent assurance on your spreadsheet.
Tell us about the spreadsheet you need reviewed and we will confirm the right audit approach.
Book a free consultationRelated case study
Health Care
Media Asset Management System
Fisher and Paykel Health Care
The new system improved the efficiency of media asset management, allowing for better organisation and retrieval of information.
Read case study →Industries we do this for
Related reading
From the blog
Start a conversation
Let's talk about what you need
Big or small, we are happy to discuss it. Send us a message or book a free discovery call — we typically respond same business day.
What happens next
- 1
We review your enquiry carefully and reach out personally — usually same business day. No obligation, no hard sell.
- 2
We clarify scope, then provide a clear fixed-price quote and realistic delivery timeframe so you know exactly where you stand.
- 3
Once agreed, we build in stages, keep you updated, and hand over a solution your team can rely on — with support if you need it.