Service
Spreadsheet Audit & Repair
Excel spreadsheet audit and repair - 7-check audit that catches the common errors in 10 minutes. Written remediation report + fix. From ₹6K fixed scope 1-day delivery.
- audit
- quality
- review
- best practices
Inherited a workbook that has lived in “final” for six months? Most teams ship numbers they cannot quite trust and hope no one notices. We notice. The audit runs seven mechanical checks on the workbook, every one of them automated, and surfaces the errors that have been quietly misreporting for quarters. The fix is the easy part - the value is knowing which numbers you can stop double-checking.
Broken workbook before a board meeting?
Message us on WhatsApp with the deadline. Urgent fixes are prioritised, and the delivery time is agreed in writing before work starts.
The audit
Seven checks that catch the most common errors.
Every audit runs the same seven checks in the same order. Each one is a single line of Excel that returns TRUE or FALSE - no judgement, no interpretation, no “it depends”. A workbook that passes all seven is safe to send. A workbook that fails any one of them is not.
Want to see where your file stands before you get in touch? The free Workbook X-ray scans every sheet in your browser and lists the risky cells. Nothing is uploaded.
- 01
No hard-coded totals
Every total is =SUM or =SUBTOTAL of a range - never a typed-in number. A hard-coded total in a refreshable workbook is a number that silently rots.
- 02
No hidden rows in SUM ranges
Filtered and unfiltered totals match. SUBTOTAL ignores hidden rows; SUM does not - the most common error we find on inherited workbooks.
- 03
Headline traces to source
Trace precedents from every headline number back to a Table or Power Query connection. The chain ends at source, not at a typed number on a hidden tab.
- 04
No hard-coded assumptions
GST, FX, commission, discount, headcount - every magic number is a named cell on an Assumptions tab. A change to a rate is a change to one cell.
- 05
Correct data types
Every key column is the right type. SUMIFS skips text silently - amounts stored as text are the error that understates your revenue by the missing rows.
- 06
Reconciled to source
Sum of detail equals the headline, every time, every refresh. A 1% gap is not rounding - it is a missing row, a hidden filter, or a drifted assumption.
- 07
Fresh refresh timestamp
Last refresh is recent and the source connection is alive. A dashboard with a stale refresh is a dashboard no one should be reading.
What audits usually find
The three errors behind most gaps.
In inherited workbooks, three errors account for the overwhelming majority of the gaps. Want to check your own file first? The step-by-step formula auditing guidewalks through all seven checks and Excel's built-in auditing tools.
01
Hidden rows in the SUM range
The user filtered to one region, hit a total, then unfiltered. The filter hid rows but the SUM still counted them. A common error in inherited workbooks.
02
Hard-coded assumptions inside formulas
GST, FX, commission, discount, headcount. A change to the rate is invisible - the formula still shows the old number.
03
Text stored as numbers (or vice versa)
Imports paste amounts as text. SUMIFS skips them silently - no error, no warning, no missing row count to alert you.
Built into the workbook
A Checks tab that runs itself.
The deliverable is not a PDF report. It is a Checks tab inside the workbook that runs the seven assertions on every refresh. While any check is FALSE, the report does not go out the door. The architecture decision that makes a workbook auditable by construction - not by heroism.
// One tab. Seven checks. Runs on every refresh.
=LET(
detail_count, COUNTA(Detail),
expected_count, 2148,
amount_check, SUMPRODUCT(--ISNUMBER(Detail[Amount])) = detail_count,
headline_check,ISNUMBER(Headline) * ISFORMULA(Headline) = 1,
no_errors, COUNTIF(Summary, "#*") = 0,
fresh_refresh, NOW() - RefreshedAt < 1,
IF(AND(detail_count = expected_count, amount_check,
headline_check, no_errors, fresh_refresh),
"SEND",
"DO NOT SEND - see failed checks")Impact
What changes after the audit.
10 min
Audit per workbook, every time
7
Mechanical checks, no judgement calls
1 tab
Checks that runs itself on refresh
0
Errors that survive the handover
Deliverables
What you walk away with.
- 1
A written audit report - every issue ranked by severity, with the cell reference and the impact in rupees
- 2
A fixed version of the workbook with every issue resolved and a Checks tab that runs on every refresh
- 3
A short handover session with the team that uses the workbook, so the fixes stick and the errors do not come back
- 4
A 30-day support window for the questions that come up once the new workbook is in production
Engagement
What we need from you, and how it runs.
What we need from you
- One or two of the workbooks that get sent to the most senior reader - the CFO, the CEO, the auditor
- Read access to the source data (we sign an NDA if you need one)
- A single point of contact who knows how the workbook is meant to behave
- A 30-minute call to walk us through the report before the audit begins
How it runs
- 1We run the seven-point audit on every workbook you send - fast, mechanical, repeatable. Most audits complete in under an hour.
- 2We write a ranked report - every issue with the cell reference, the impact, and the fix. You see the worst problems first.
- 3We fix the workbook - one fix at a time, with the Checks tab in place so the errors cannot come back.
- 4We hand over with a recorded walkthrough and 30 days of post-delivery support for the questions that always come up.
Free Self-Serve Excel Tools
Interactive in-browser calculators and diagnostics. No sign-up, no email required.
Workbook Compare
Drop two versions of a file and see every changed cell and formula, inserted rows, and formulas someone typed over.
Workbook Map
See how your sheets feed each other as a diagram, with links to other files, hidden feeders and circular links flagged.
Formula Explainer
Paste any formula and read it in plain English, step by step in the order Excel calculates it.
Related
Keep reading
Service
Fictional Excel Reporting Demo
Fictional Excel reporting demonstration with invented data, a sample monthly summary, and illustrative workflow checks
Service
Sample Scoping Sprint Deliverable
A worked Scoping Sprint on a fictional workbook - the written diagnosis, fixed-price proposal and Definition of Done you receive
Service
Excel Automation
Automate monthly Excel reporting with Power Query and VBA. Replace recurring exports, cleanup, refreshes, and distribution with a fixed-scope workflow and documented handover.
Service
Excel VBA / Macros
Excel VBA and macros for reconciliation, mail merge, PDF export and scheduled refreshes.
Service
Excel Dashboard Design
Excel dashboard design - KPIs, slicers and one-click refresh. Power Query + Pivot or Power Pivot.
Service
Excel Data Cleaning
Excel data cleaning with Power Query - tidy, deduplicated, validated source data that survives the next refresh.
Service
Financial Modeling
Financial modeling in Excel - three-statement, budget, scenario forecasts and sensitivity tables.
Service
Power Query / Power BI
Power Query and Power BI builds - refreshable M pipelines, validated transformations and dashboards your team can hand off.
Service
Google Sheets Automation
Google Sheets automation with Apps Script - triggers, validation and Connected Sheets for BigQuery-scale data.
Service
Excel Error Fixing
Excel error fixing - broken VLOOKUP, #REF, #VALUE and slow files. Free tools first, then a fixed-quote Quick fix from $75 / ₹6K.
In writing
Four guarantees on every paid engagement.
What every paid engagement comes with - in writing, before any build work starts.
Written scope, fixed price, fixed timeline
Agreed in writing before any build work begins. No open-ended discovery, no scope creep, no surprise invoice at the end.
Working draft within five working days
Or your deposit back, no questions. We will not string you along for a month to find out we are not a fit.
30-day post-handover support window
Every defect against the Definition of Done fixed free, and every question answered within one working day. New features are quoted separately.
A written Definition of Done
If we miss it, we fix it free. No arguments. The bar is in writing before the work starts, not after.
Cost of waiting
What an unchecked workbook is costing your business.
Pick the row closest to your situation. The number on the right is the cost of errors that ship silently - wrong reports, mis-stated GST, a number the auditor flags after the fact. The audit engagement is one fixed price. This is what the absence of that audit is quietly billing your business.
Senior accountant reviewing and correcting inherited workbooks
Hrs / week: 4 hrs
Hourly cost: ₹800
Per year: ₹1,66,400 lost
Cost of a single material error caught after the report goes to leadership
Hrs / week: 12 hrs
Hourly cost: ₹1,500
Per year: ₹9,36,000 lost
Auditor time spent resolving formula issues during annual review
Hrs / week: 8 hrs
Hourly cost: ₹2,500
Per year: ₹10,40,000 lost
A one-time engagement typically pays back inside two to three months. After that, every week is hours your team gets back.
Three options, side by side
Why a one-time Excel build is cheaper than it looks.
Pricing for a spreadsheet audit & repair engagement gets compared to a freelancer rate card. The honest comparison is against the three realistic alternatives - an in-house analyst, a BI tool plus a consultant, or doing nothing. The Excel you already own has no licence cost. Anything we build keeps working after the last invoice is paid.
FormulaSurge build
- Cost type
- One-time, negotiable
- Year 1
- Starting from ₹6K - we work with your budget
- Year 2+
- ₹0 ongoing
- Time to value
- Live in 2–5 weeks
When the numbers already live in Excel and you want them visible by Monday morning. Tell us your budget - we will tell you what fits.
Hire an in-house analyst
- Cost type
- Recurring salary
- Year 1
- ₹2.0–3.0L salary + benefits
- Year 2+
- ₹2.0–3.0L every year
- Time to value
- 3–6 month ramp to productive
When you have 40+ hrs/week of analytical work, every week, for the next 18 months
Buy a BI tool + consultant
- Cost type
- Licence + hours
- Year 1
- ₹20K–50K licence + consultant hours
- Year 2+
- Licence renews every year
- Time to value
- 3–6 month platform migration
When Excel is genuinely outgrown - multi-tenant, real-time, hundreds of millions of rows
See the full three-year TCO on the comparison page.
Free tools · 30 sec to 2 min each
Try it yourself before you book a call.
A real audit starts with the formula and data hygiene. Run these checks first - if anything lights up, send the result on WhatsApp and we will dig deeper.
Spreadsheet Risk Score
Seven questions to spot fragile formulas, missing checks, and workbook risks.
Open toolExcel Error Solver
Paste a broken formula, pick the error, get 4 production-ready rewrites.
Open toolSlow File Diagnoser
Answer a few questions to find the one fix that helps most.
Open toolExcel Formula Error Checker
Find out what common Excel errors mean and how to fix them.
Open tool
Built for teams in
Industries and cities this work is set up for
See also
Related Industries
For Finance Teams
Excel for finance teams - build dashboards close faster models and pipelines the team you already have. 7 reports every CFO opens on Monday. From ₹6K fixed scope.
For Sales Operations
Excel for sales operations - pipeline coverage quota attainment and forecast accuracy in one Excel refresh. 5 KPIs the VP Sales opens every Monday. Senior-led fixed scope from ₹6K.
For Professional Services
Excel for professional services firms - utilisation project margins and WIP in one Excel place without buying a new platform. 5 KPIs the partner opens monthly. Senior-led fixed scope from ₹6K.
For E-commerce & D2C Brands
Excel for e-commerce and D2C brands - daily sales inventory and marketing attribution across Shopify and Amazon in one refresh. 6 KPIs the founder opens every Monday. Senior-led from ₹6K.