by Emma-Lee Oliver | Senior Consultant, Australian Payroll Association
There was a time when a large underpayment remediation meant one thing in my world: clear the calendar, open Excel and brace for impact.
Like many of you, I’ve sat through the painstaking process of manually calculating underpayments and overpayments line by line. Extract the data, build the spreadsheet, insert the formulas, cross-check the rates, reconcile totals, sense-check the results… and then do it all again because something didn’t quite tie back.
I sometimes think, if only I knew then what I know now.
At the time, it felt thorough. Responsible, even. We were rolling up our sleeves and getting into the details. But with hindsight and with the benefit of the remediation software now available, it’s hard not to see just how exposed we were relying solely on manual spreadsheets.
Excel is powerful. It’s flexible. It’s familiar. And therein lies the danger.
The first issue is obvious but persistent: formula errors. A single misplaced bracket, an incorrect cell reference dragged one row too far or a hard-coded value that should have been dynamic. In a remediation involving thousands of lines of data across multiple pay periods, even a small formula error can compound quickly.
Then there’s version control. How many times have we saved “Remediation_v3_FINAL” only to later discover someone was working off “Remediation_v2_UPDATED”? Multiple payroll team members touching the same workbook adds another layer of risk, particularly under time pressure.
But the more subtle issue is how manual calculations often happen in silos.
We identify Issue A say, an overtime miscalculation and we calculate the variance. Then we identify Issue B perhaps a missed allowance and calculate that separately. Each issue is worked through methodically, but often in isolation. What’s not always considered is the interaction between them.
If overtime was miscalculated because the base rate was wrong due to a missed allowance, then correcting the allowance should technically flow through to the overtime recalculation. When issues are calculated separately, you risk either understating or overstating the true liability.
I have seen situations where adjustments were double counted. I have also seen situations where one correction inadvertently masked another. Neither outcome is ideal when you are dealing with Fair Work, auditors or very concerned employees.
What manual remediation really carries is personal accountability.
When you are building those spreadsheets, you are effectively designing the engine that determines how much someone is owed. There is no system audit trail explaining the methodology unless you document it yourself. There is no automated logic applying award interpretations consistently across the dataset unless you have painstakingly embedded it.
You become the control framework.
That is a heavy responsibility, particularly as wage compliance has moved into sharper regulatory focus. Boards are asking more questions. HR and legal teams want assurance. Employees expect transparency.
The landscape has shifted significantly in recent years. We now have sophisticated remediation software that can recalculate entire employment histories using configured award rules, applying all variables simultaneously rather than sequentially. These systems don’t get tired at 10pm. They don’t accidentally overwrite a formula. They calculate each pay period holistically, not issue by issue.
That doesn’t mean technology replaces professional judgement. Far from it. You still need to understand the awards, the interpretation decisions, the data integrity issues and the practical payroll nuances. But the heavy computational lifting no longer has to rest on a manually built spreadsheet.
Looking back, I am proud of the work we did manually. It was detailed and careful and it reflected the tools we had at the time. But I am equally relieved that our profession has evolved.
If you are still relying on complex Excel models for large-scale remediation, it might be worth pausing to reflect on the risk exposure, not just operationally, but reputationally.
Payroll has always been about precision. Now, we have better tools to support it. And if there’s one lesson I would pass on to my younger payroll self, it would be this: just because you can calculate it manually, doesn’t always mean you should.
If you are currently navigating a remediation or simply want to understand what tools are available in the market, it may be worth having a conversation. The right technology can significantly reduce risk, improve transparency and make what is often a very complex exercise far more manageable. At APA we work closely with organisations undertaking remediation and have visibility of a number of systems designed specifically for this purpose. If you’d like to explore what options exist and what might suit your organisation, we’d be very happy to have a discussion.