Had to share this painful but educational experience. One of our junior auditors was working on a grain elevator account with Otter Tail Power and missed a critical detail in the large power rate schedule. The customer had been incorrectly billed on LP-1 instead of LP-2 for eighteen months, difference of about $2,800 per month. Junior caught the rate schedule error but calculated the refund wrong by not accounting for the seasonal demand charges properly. Underestimated the refund by nearly $50,000. Customer was not happy when they found out. How do you prevent these kinds of calculation errors?
New hire made $50k error - lessons learned
Ouch, that's a tough lesson. I always have juniors show their work step by step, especially on large refund calculations. For seasonal rate schedules, I make them create a month-by-month spreadsheet showing both the incorrect billing and correct billing side by side. Then someone else has to verify the calculations before we present findings to the client. Double-checking large dollar amounts should be standard procedure.
This is exactly why I don't let junior auditors handle large commercial accounts solo until they've been with us at least two years. Here in Alabama with Alabama Power's complex rate structures, there are too many ways to make expensive mistakes. I have them work on smaller accounts first and always pair them with a senior auditor for anything over $10,000 annual usage. Better to slow down the training process than risk these kinds of errors.
Sorry to hear about this situation Anita. We use a three-person verification process for any refund calculation over $25,000 - original auditor, senior review, and final partner sign-off. Also created a checklist specifically for seasonal rate schedules that covers common mistakes like summer/winter demand charges, time-of-use variations, and fuel cost adjustments. Sounds like overkill but one big error can really damage client relationships.
Had a similar issue last year with an OG&E large power customer. Junior auditor missed the fact that the demand charge had a ratchet provision based on the highest summer demand. Calculated twelve months of refunds without accounting for how the ratchet would have worked under the correct rate schedule. Always emphasize to new hires that they need to understand not just the current charges but how billing would have worked historically under different conditions.
Susan raises a great point about ratchet provisions. Those are tricky even for experienced auditors. I always tell trainees to flag any account with seasonal rate structures for senior review, especially if there are demand ratchets involved. The math gets complicated quickly when you're recalculating historical bills with different peak demands. Better to ask for help than guess and get it wrong by tens of thousands of dollars.
We've started using audit software that flags potential large dollar variances for additional review. If a refund calculation exceeds certain thresholds, the system requires supervisor approval before the report can be finalized. Not foolproof but helps catch obvious errors before they reach the client. Also helps to have juniors present their findings to the team before client meetings - often someone will spot issues during the presentation.
Tom, that's a good idea about the software flags. We're looking at upgrading our systems anyway. The presentation approach sounds useful too. This particular error probably would have been caught if someone else had looked at the seasonal calculations. The junior knew the theory but didn't apply it correctly to the historical billing periods. Expensive lesson but hopefully prevents future mistakes.
I require all my junior auditors to keep detailed notes of their calculation methodology, especially for complex rate schedules. That way when we review their work, we can see their thought process and identify where they went wrong. Also helps them learn from mistakes. For seasonal schedules, I have them create a narrative explanation of how the rates work before they start calculating anything.
Marcus, I love the idea of writing out the methodology first. We do something similar - make them explain the rate structure in plain English before touching any numbers. If they can't explain how the tariff works to a non-technical person, they're not ready to do the calculations. Had too many situations where juniors got lost in the math without really understanding what they were calculating.
All good suggestions here. I think the key is creating a culture where asking questions is encouraged, not seen as weakness. Junior auditors sometimes hesitate to ask for help because they don't want to look incompetent. But it's much better to ask and get it right than to guess and create a $50,000 error. Regular check-ins during large audits can help catch problems early.
Noel makes an excellent point about the culture aspect. We actually track metrics on question-asking during training - juniors who ask more questions in their first six months tend to make fewer errors later. It's counterintuitive but the people who seem to struggle early often become the most thorough auditors because they learned to verify everything. Pride can be expensive in this business.