How to find hidden errors and fake balancing figures in old spreadsheets
Inherited accounting spreadsheets often contain hidden mistakes, like white-font balancing figures or broken nested formulas that quietly mask massive financial variances. These undetected errors prevent accurate reconciliations and lead to severe financial discrepancies, such as hundreds of thousands in unbilled revenue or unexpected period-end losses.
What people tried
Every workaround mentioned in the threads below. We haven’t tested any of them — and nobody here is claiming they worked.
- 1Rerunning prior periods to figure out how accounts work
- 2Doing manual reconciliation checks
- 3Reviewing formulas and cleaning up inherited accounts
- 4Starting books from scratch using audited balances
- 5Archiving the old system and data, cutting 3rd party reports
- 6Using a business partner for data warehouse transfers and data validation
In their words
Unedited, grouped by where they were said, most upvoted first within each place, each linked to the thread it came from.
“Early in my career I took over a dirty control account rec that had hundreds of entries per period but had always balanced back, then the first month I was out £12k”source ↗
“Turns out the person before me didn’t know how it worked and was typing in a balancing figure in white font, and because the reviewer was not casting or doing any proper checks, it had never been noticed”source ↗
“Long story short, the prior CFOs used 3rd party reports instead of the built in financials over 20 years and never confirming the data in the original system to the 3rd party reports.”source ↗
“Add in department and project codes that the reports don’t pull, nothing balances.”source ↗
“It’s so bad, that trying to fix the mess, creates more problems exasperating the already 50 million dollar imbalance.”source ↗
“Bruh, im actually going through the same situation! I’ve been tasked to reconcile some intercompany control accounts and the ones done by some specific guy never match when I run the rec myself but they show up as fine in the balance sheet. Turns out this guy was just clearing the variances with made up settlements!”source ↗
“Been at my current job 2 months, and we have penalties and premiums for different quality specs on our products. I found that we have not been billing for a quality premium in our contract because the formula was a long ass nested if statement, and at the end of the entire formula was a *0 just chilling. $800K+ unbilled year-to-date because of it...”source ↗
Where this came up
People with this problem also raised
- 9How do you do account reconciliation when departments are split up?
- 2How do I find a specific change in an audit log?
- 17How to handle expense reports without being good at math
- 23How to clean up months of messy client expense records
- 3Why do accountants keep messing up my bookkeeping software?
- 3Found a mistake on my resume after submitting the job application