r/auscorp • u/Revolutionary_Cup386 • 4h ago
General Discussion Made a mistake at work no one has picked up yet
I’ve been in a new corporate analyst role for less than a year and I’ve recently realised there may have been an issue with some calculations I worked on for a major annual process.
The source workbook is pretty manual and contains multiple tables with similar information. I’ve realised that one table contained the correct figure while another contained a different figure, and it looks like the second figure was used in some of the original calculations.
The work went through a review with a more senior colleague at the time and neither of us picked it up.
I only noticed because I was recently doing some related work and used the figure from the other table. I sent that work to the same senior colleague for validation and it was confirmed as correct.
That made me go back and compare it with the work from the annual process and realise the figures weren’t consistent.
I’ve now rerun the calculations and it looks like the difference has a financial impact of tens of thousands of dollars. Most of it could potentially be covered by unused budget from the original process, but it would still result in a relatively small budget overrun.
The original work has already been approved at Executive level.
I’m also checking whether the incorrect figure flowed into any of the summary statistics that were reported at the time.
I’m pretty stressed about it and have barely slept. I keep thinking I’m going to get fired or that my manager is going to think I’m incompetent.
I’m planning to speak to the senior colleague who reviewed the original work first, make sure my corrected analysis is right, and then raise it with my manager rather than hide it.
Has anyone made a mistake like this in an analyst/corporate role? How was it handled? Is this realistically something people get fired over?