Had a painful learning experience last month that I wanted to share as a cautionary tale. One of my junior auditors was working a Consumers Energy account and miscalculated a demand ratchet recovery. What should have been a $180K refund claim got filed as $18K due to a decimal point error in the spreadsheet formula. Client signed off on the lower amount before we caught the mistake. Now we're dealing with an awkward situation trying to file an amended claim. How do you all prevent calculation errors like this?
Junior auditor made $180K mistake - lessons learned
Tina, that's a tough lesson but an important one. At my firm, we have mandatory peer review for any calculation over $50K. Two sets of eyes on every major formula. PSE has complex demand calculations and we've caught several potential errors this way. Also use color coding in spreadsheets to highlight critical formulas.
Vera makes good points about peer review. DP&L cases taught me to always do sanity checks - if the recovery amount seems too good to be true, it probably is. I have junior auditors estimate expected recovery ranges before running detailed calculations. Helps catch order-of-magnitude errors early.
Kevin's sanity check approach is critical. We also require senior review signatures on all calculations over $25K. Duke Energy has enough complexity that small errors can snowball into big problems. I've seen similar decimal point disasters - they're more common than people think.
The signing requirement Cecilia mentions is key. I also use Excel's formula auditing tools religiously. Cincinnati G&E cases often involve complex multi-year calculations where one wrong cell reference can throw everything off. The trace precedents/dependents features have saved me countless times.
Thanks for the feedback everyone. We're implementing mandatory peer review for anything over $50K going forward. The sanity check approach really resonates - in hindsight, $180K seemed high for the account size but we got excited about a big recovery. Lesson learned the hard way.
Tina, don't beat yourself up too much. We've all been there. Avista had a case where we missed a rate change effective date and undercalculated by $90K. Now we maintain detailed rate change logs for every client. These mistakes make us better auditors in the long run.
Boyd's rate change tracking is excellent practice. Entergy loves to slip in rate adjustments with minimal notice. I create timeline documents for every audit showing all relevant tariff changes during the claim period. Helps prevent missing critical effective dates.
Juan brings up a great point about rate change documentation. We also photograph or screenshot key tariff pages with effective dates highlighted. PSE's online tariffs sometimes get updated and historical versions disappear. Having that backup documentation has saved us several times.
Vera's documentation practice is smart. Duke periodically "reorganizes" their tariff structure and finding historical versions becomes impossible. I now archive PDFs of every tariff section we reference in our audit files. Regulators appreciate the thoroughness too.
All great suggestions on documentation and change tracking. For calculation verification, I also recommend using different software packages to cross-check results. Excel for main calculations, then verify key numbers in a simple calculator. Different tools can catch different types of errors.
Kevin, that's a great point about using multiple tools for verification. We're also going to start requiring written summaries of calculation methodology before beginning detailed work. Forces auditors to think through the approach logically. Thanks again everyone for the excellent advice!
Written methodology summaries are brilliant, Tina. Cincinnati G&E cases often have multiple potential approaches, and documenting the logic upfront prevents method confusion later. Also helps with training newer staff on complex calculations.
This has been an excellent discussion on quality control procedures. At AAUBA, we see calculation errors as one of the top reasons audit claims get disputed by utilities. The peer review, sanity checking, and documentation practices discussed here should be standard operating procedure for all member firms. Thanks for sharing these hard-learned lessons - they'll help other auditors avoid similar mistakes.