I was recently on a plane doodling and thought of some funny / interesting stories from 25+ years of working and traveling. So I decided to write them up as short, random chapters of a non-book with the title of this post. Hope you enjoy them and / or find them interesting. Certainly the value will be at least equal to the marginal cost of the book (zero)…
The Midwest, early 1990s
For a long time many governmental entities did not have audits from outside firms. Beginning in the 1980s and 1990s it became common-place for them to have to open up their books and bring in third party professional audit firms to review their accounts. If they had not been audited before, we called it a “first time through” audit because the amount of work was exponentially maybe one and a half to two times higher – you had to document the controls, figure out who was who at the client, validate the opening balances, etc… Typically after the first audit it was much easier because the 2nd year audit just followed the work papers of the prior year auditors (unless you were like me and asked a lot of questions, which is a story for another “25 stories about work” article).
Recently I thought about my experience when I read this article about the state of New Mexico while reading this article from Bloomberg (a fantastic news source) titled “New Mexico’s $100 Million Accounting Error”. From the article:
New Mexico can’t balance its checkbook.
Cash in the state’s bank account is at least $100 million short of what’s recorded in the finance department’s ledger, pushing officials to adjust reserves by that amount, to about $650 million. The blame, the current administration says, lies with the introduction of a new accounting system in 2006.
While it would seem astonishing that in this day and age, when you have on-line bank statements and immediate access to data for personal accounts, that a governmental entity could be that far off the mark, it wasn’t shocking to me. As a new auditor at this first-time through audit, I was given what was thought to be the simplest of tasks – auditing the cash on the books and reconciling this cash balance to the bank statement.
How you and I and almost everyone else operates is that you have a checkbook balance and as you make a payment (write a check), you deduct that amount from your available cash and you then know how much money you have left in your account. Since deductions can come in many forms (ATM withdrawals, auto-payments, and manual checks) you need to balance your checkbook periodically to make sure you don’t miss anything, but other than that it isn’t that difficult conceptually. The same process obviously works in reverse for deposits.
The governmental entity I was auditing in the early 1990s, however, used a totally different philosophy. They assumed that they HAD the cash forever until you proved that the check was cashed by whomever they sent the payment out to. Thus when you started to look at the bank balance “on the books”, it showed hundreds of millions of dollars. When you looked at bank statement (from the bank), you saw a few million dollars. Thus my nearly insane task was to reconcile out the hundreds of millions of dollars in payments that had been made over the years to get from all the cash deposited back to the few million dollars left on hand. To be fair, staff at the governmental entity had taken a “crack” at this task and there was lots of manual records attempting to bridge the gap, but it was still a giant effort. New Mexico apparently uses the same “model” today – per that Bloomberg article:
Officials commissioned a study on the variances between the state ledger and its bank accounts from fiscal 2007 through February 2013.
Contractors could match only 2 percent of 160 million entries to a corresponding bank transaction, according to a Jan. 19 memo to lawmakers from Legislative Finance Committee staff.
Hundreds of thousands of transactions totaling more than $836 million are absent from the system, the study found. It estimated that the state could have from $76 million to $400 million less than its records reflect.
Clifford said he requested $3.4 million to create processes to properly record cash balances. It will take about two years to achieve a “clean” annual financial report, he said. Should the imbalance exceed $100 million, the gap would come out of reserves, he said.
I still remember writing up memos attempting to explain this situation to the partner on the engagement. We did not have a lot of time set aside for auditing cash, which is supposed to be simple, and when you bid out these governmental jobs we were already doing the work at a loss (compared to standard billing rates) so there was little or no tolerance for spending extra work at this unprofitable client. Thus I was not only handed an impossible task my own firm was not pleased with my careful documentation of this situation which caused them to have to spend even more time writing memos to provide credence to the numbers so that we could complete the audit.
Read more
