INTERNAL CONTROLS
Input Controls:
a. No central point of journal entry control
b. Under a system of batch entry, input would be more accurate
c. Failure in the internal auditor function and reporting protocol. This oversight would have revealed the reconciliation failure.
d. Generally, the independent auditors do their testing procedures during the interims, i.e. testing of systems commence in the eight or nine month of the calendar or fiscal years, if the SBOA would modify their auditing techniques by advancing the those testing procedures, failure in internal controls may be prevented in the future.
BUY MONEY – POLICE (CITY)
a. In order to assist law enforcement, the Buy-Money
Program should adhere to IC 36-1-3 and, accordingly, the Administration needs to draft an ordinance and the Common Council pass to establish the fund.
PARKING METER FEES (CITY)
a. The Administration needs to establish a special fund
The parking meter fees will be directly deposited in accordance with IC 36-9-12-4.
SEPARATION OF BANK ACCOUNTS
a. The Utility funds are being deposited in the City bank
Account. The Administration needs to establish a separate bank accounts for the Utility only.
CONTRACTS (CITY)
a. The audit of SMG has never been performed in
Accordance with the contract between the City and SMG for 2006, and subsequent to 2006, a reviewed financial statement. It appears that Harding Shymanski was engaged to perform. We as the Common Council request a status report on those engagements and, if completed, a full report on the subsistence.
OVERDRAWN CASH BALANCES
a. Various funds are overdrawn during the calendar year
Due to the timing of the receipt of taxes, generally, property tax. The public would believe that we have over-drafted our checking account, but, these funds are comprised in one or two bank accounts. So, fund A has large balances, while Fund B is in the negative, but, the combined amounts are positive. Nevertheless, according to state law, this can NOT happen during the calendar year. As such, the Administration needs to request from the Common Council, at the direction of the Administration, by temporary ordinance, to loan funds from those funds that are un-restricted and not subject to grant provisions, whereby, any loan would be repaid before year’s end.
BANK ACCOUNT RECONCILIATIONS
a. In accordance to Indiana Code 5-13-6-1(e) “All local
Investment officers (Controller) must reconcile at least monthly to their financial institutions†As such, it should be the responsibility of the Internal Auditor to report the failure of the chief financial officer (Controller) to reconcile any and all public funds to the appropriate financial institution and that report should be presented to the President of the Common Council and the Chairman of the Finance Committee without repercussions.
ANNUAL REPORT
a. As specified in the Indiana Code 5-11-1-4(a), the City’s annual report must be posted on Gate-Way by the 1st day of March for the preceding year. The City has failed to file the annual report several times in the past. As such, the Internal Auditor should report to the Common Council and to the SBOA that the annual report has been filed on a timely basis.
PRESCRIBED FORMS
a. The Munis software fails to produce forms No. 208 &
209. These reports are imperative to the proper presentation of the books and records of the City of Evansville. The Common Council directs the Administration to correct the weakness in our software to allow the appropriate forms.
FINANCIAL REPORT OPINION MODICATIONS
a. The Munis software failed to produce the
Transactional detail necessary to verify to the control totals, i.e. the check book total did not match the bank reconciliation. We, the Common Council, at the direction of the Administration, will provide the necessary resources to correct the City’s IT weaknesses.
b. By allowing the general ledger to remain open until
July of 2012, the year-end control total of the published fund balances were affected by transactions in the current period causing the corruption of the data. The Common Council strongly suggest that the previous years ledgers be close promptly after the filing of the annual report. Any and all adjustments should be made in the current periods and reconciled back to those balances.
c. Within the Utility, the financial system was recorded
On the accrual basis of accounting. Although required by the Indiana Utility Regulatory Commission, the Utility must keep their reporting on the cash basis for the purpose of examination. In regards to the IURC, monthly entries should be reviewed and coordinated to convert the cash basis system producing accrual financial statements. Those entries should be reversed on the first day of the month.
INTERNAL CONTROLS OVER MAJOR
PROGRAMS IN ACCORDANCE WITH
OMB CIRCULAR A-133
FEDERAL GRANTS
INTERNAL CONTROLS OVER FINANCIAL
TRANSACTIONS AND REPORTING
a. Although, the SBOA, presented to the City an
Unqualified Opinion as to the adherence to the provisions of the City’s major Federal Grants, the SBOA cited the same weaknesses in the internal controls relative to the accuracy of the City’s financial reporting. As such, the action by the Common Council is reiterated per the above in reference to expected action of the City’s Internal Auditor. However, the SBOA disclaimed in regards to the Schedule of Expenditures of Federal Awards citing the aforementioned weaknesses.
b. Monitoring of Controls – The SBOA has directed the
Common Council to better understand and develop where necessary controls to assure the compliance thereof. As such, the Common Council should draft an ordinance whereby the Internal Auditor should be responsible to report any violations of those identified controls to the Council. In addition, the Common Council should engage experienced and qualified consultants to monitor and recommend further strengthening of controls.