Speak Out Loud NA

Sunday, June 18, 2006

Re-Post: March, 2006 - Audit Results

Important Findings of 2004 Audit:
The previous posting, which spoke of the finding in the 2004 audit of the City of New Albany, was left open for citizens to discuss what they felt were pertinent issues that merited further discussions.
As we all know, there was not much mention of the actual audit findings, but rather a plethora of various perceptions of the Administration and their competence, or lack thereof, as well as a lot of unnecessary personal and political jabs.
Before we delve further into the 2004 Audit, we would like to reiterate our stance that this blog is for the Citizens of New Albany, and will not be used as a platform for any political campaigning.
That said, let's move forward with the 2004 Audit written report, which is a public document produced by the Indiana State Board of Accounts.
On page 4, 4th paragraph, of the Independent Auditor's report on financial statements, they note:
"We were unable to audit the note disclosure relating to capital assests of the City, because capital asset records were not properly maintatined and updated; and we were unable to satisfy ourselves as to the value of the capital assets by other auditing procedures. In addition, we were unable to verify the accuracy of cash and investment balances because monthly cash reconcilements were never compared to the funds ledger so that variances could be identified and corrected in a timely manner."
They further note; "The Wastewater Utility did not maintain sufficient capital asset records. Due to lack of supporting documentation, capital asset valuation cannot be verified." Nahhhhhhhh, not the Sewer Utility!
Surely, with all the other departments that were being supported by Sewer Funds, and all the "loans" that were made out of Sewer Funds, surely they were keeping accurate and detailed records of all such expenditures.
"In addition, we were unable to verify the accuracy of cash and investment balances because monthly cash reconcilements were never compared to the funds ledger so that variances could be identified and corrected in a timely manner."
Well now, doesn't that just take the cake, so to speak? Only in this instance, the cake is made of the hard earned money of the rate payers.
What does all this mean?
"As capital assets and cash equivalents constitute a major portion of the Statement of Net Assets, any uncertainty concerning assets and cash and cash equilvalents similarly affects the Statement of Net Assets."
In other words, because no one managed to do the monthly balancing of the City's books, and reconcile the funds ledger, they really can't tell what the City has in terms of the bottom line.
One other statement early in the report that raises concerns is as follows:
"The City has not presented Management's Discussion and Analysis or Budgetary Comparison Schedules that the Governmental Accounting Standards Board has determined is necessary to supplement, although not required to be part of, the basic financial statements."
As we mentioned in a previous posting, the State guidelines say no departments may make expenditures in excess of their appropriated budget. However, New Albany has several departments that show spending indeed exceeded the budgeted amounts for those departments. Namely, the General Fund (duh), Motor Vehicle Highway, Local Road and Street (no, we're not kidding), Park Nonreverting, Ambulance Runs, and Park Cummulative Building.
The total excess spending for these funds was just over $1.7 million dollars.
The Audit notes: "These disbursements were funded by inappropriate available cash balances." (mis-appropriated funds?).
After perusing through the pages of numbers, looking at balances and debt, disbursements and income, assets and liabilities, we turned our attention to the Audit results and comments concerning the condition of records (pg.38).
There we discovered the profound cumulative effects of the propensity of City Departments to repeatedly fail to reconcile cash accounts monthly with the City funds ledgers.
Such instances are more fully described later in this posting; However, our purpose here is to explore the consequences of such oversights, or simple non-compliance with proper accounting procedures.
As revealed in the documents of Findings and Questioned Costs (pg. 52), the Audit found problems with the condition of City records (2004-1).
The Audit notes: “…reconciled amounts were not totaled and compared to actual cash transactions recorded in the City’s records. As a result of undetected errors as of Dec. 31, 2004, the City [had] $88,947 more in unidentified cash recorded in its records than [was] being held in its bank accounts.”
In “Notes To Financial Statements”, on pg. 17, item I-C notes: "The government –wide, governmental fund , internal service fund and fiduciary fund financial statements are reported using the basis of accounting that demonstrates compliance with the cash basis and budget laws of the State of Indiana…. Receipts are recorded when received and disbursements are recorded when paid.” Doesn’t sound too terribly difficult to us. How about you?
Back to page 38, concerning the Condition of Records, Indiana Code 5-13-6-1(e) states: “All local investment officers shall reconcile at least monthly the balance of public funds, as disclosed by the records of the local officers, with the balance statements provided by the respective depositories.”
These comments go on to explain: “At all times, the manual and/or computerized records, subsidiary ledgers, control ledgers, and reconciled bank balance should agree. If the reconciled bank balance is less than the subsidiary or control ledgers, then the responsible official or employee may be held personally responsible for the amount needed to balance the fund. (Accounting and Uniform Compliance Guidelines Manual for Cities and Towns, Chapter 7)”.
How ‘bout them apples?

7 Comments:

  • As we can all attest, if we do our household budgeting/balancing properly, the reconciling of accounts has become immeasureably easier with the advent of computers and 24/7 access to bank records. However, designing, building, and training people to use a modern computerized fully integrated system for financial management is a HUGE and costly endeavor. If the financial management systems for the city are out-dated, how can we know? Whose job is it to establish and maintain all these systems? The comptroller or CFO. If the comptroller of CFO can not produce timely and accurate financial reports, that says to me we need an overhaul of that department, it doesn't say the mayor is a crook or people are embezzling money. It says we need a better financial management system.

    By Blogger G Coyle, at 10:43 AM, June 18, 2006  

  • Sure, that would solve all our problems. Spend a bundle of money on a new computer system and they could blame it on GIGO, what happened to the old pencil and green sheets? If the computer system fails you need to be able to add and subtract, basic math, without help.

    No, to me it appears someone's hand was caught in the cookie jar!!

    By Anonymous Anonymous, at 4:25 PM, June 18, 2006  

  • It could be either scenario, but let's try to get some more information about the issues g.coyle mentions before we dismiss any possibilities.
    Does anyone remember the year of the last computer update for the City? Didn't they update some under Overton's administration?
    There has been some very expensive software purchased recently for various tasks. One to do in-house billing. How's that going?
    Another was purchased so that Cory Earl (former city employee) could work on the Stormwater compliance data.
    Anyone who can provide more detail on these expenditures, please help to fill us in on the details.

    By Blogger East Ender, at 5:08 PM, June 18, 2006  

  • Gina, we bought new computers and financial software under the last administration. A lot of training was administered. This purchase came before the City Council.

    The software would have had to conformed to Indiana guidelines (LAWS), in order for the partial Audits we now receive to be performed.

    This is why we can't blame it on the computers, and don't understand exactly WHAT IS THE PROBLEM?

    It took citizens to crack the two sets of books and then the compromising of all of the data; guess we'll just have to figure this one out, too. If I knew what else to do, we'd tell you.

    Creative bookkeeping as I have never seen...

    Think the "new" software would have been around the third year of Overton's Admin; which would make all of the computers/software about 3 1/2 years old. Yes, some of the people under the last Admin are still there that WERE trained.

    Go figure.

    By Anonymous Anonymous, at 12:28 AM, June 19, 2006  

  • I kicked around the internet yesterday and one site I can recommend is http://www.gfoa.org which is an organization for public finance officers and goes into some detail on the various aspects of public finance...and O-MI-GOD, is it technical and deep. What I learned is there are standards and certifications available, from GFOA for one, that exist solely to support proper public finance programs. Some cities actually win awards for producing clear current financials! I wonder if NA even has a certified Public Finance Officer on board? A CPA? Please take a look at how other cities run their finance programs - it's instructive.

    By Blogger G Coyle, at 7:42 AM, June 19, 2006  

  • Kay Garry IS a CPA

    By Anonymous Anonymous, at 8:13 AM, June 19, 2006  

  • g.coyle,
    You're right. But this is only part of the overhaul that needs to happen. Don't underestimate both issues, that of defining where we are and where we need to be. They need to go hand in hand.

    Me thinks, most of all, the mayor does protest too much.

    You can ask the question, "Why" or been around long enough to know the answer.....

    By Anonymous Anonymous, at 10:38 PM, June 19, 2006  

Post a Comment

Links to this post:

r

<< Home