|
REPORT DIGEST OFFICE OF BANKS AND REAL ESTATE COMPLIANCE
EXAMINATION For the Two Years Ended: June 30, 2004 Summary of Findings: Total this audit 16 Total last audit 6 Repeated from last audit 2 Release Date: State of Illinois Office of the Auditor General WILLIAM G. HOLLAND AUDITOR GENERAL To obtain a copy of the
Report contact: Office of the Auditor
General Iles Park Plaza 740 E. Ash Street Springfield, IL 62703 (217) 782-6046 or TTY (888) 261-2887 This Report Digest is also
available on the worldwide web at http://www.state.il.us/auditor |
SYNOPSIS ¨ The Agency made payments for efficiency initiative billings from improper line item appropriations and funds. ¨ The Agency’s Credentialing Licensing Enforcement And Regulation computer system (CLEAR) had significant deficiencies. ¨ The Agency did not have adequate controls over its revenue processing. ¨ The Agency did not maintain adequate control over State vehicles. ¨ The Agency did not establish a Savings Bank Examiner Training Foundation in accordance with 205 ILCS 205/9007 of the Savings Bank Act. ¨ The Agency was not in compliance with provisions of the Residential Mortgage License Act of 1987. ¨ The Agency failed to conduct examinations of the affairs of residential mortgage licensees.
{Expenditures and Activity Measures are summarized on the next page.} |
OFFICE OF BANKS AND REAL ESTATE
COMPLIANCE EXAMINATION
For The Two Year Ending June 30,
2004
|
EXPENDITURE STATISTICS |
FY 04 |
FY 03 |
FY 02 |
|||
|
Total
Expenditures (All Funds)........................ |
$27,339,176 |
$29,563,417 |
$28,571,299 |
|||
|
OPERATIONS TOTAL..................................... % of
Total Expenditures................................... |
$27,327,676 99.96% |
$29,553,417 99.97% |
$28,571,299 100.00% |
|||
|
Personal Services.................................................. % of
Total Expenditures................................... Average
Number of Employees....................... |
$15,665,453 57.32% 251 |
$17,241,018 58.34% 271 |
$16,066,124 56.23% 274 |
|||
|
Other Payroll Costs (FICA, Retirement)................ % of
Total Expenditures................................... |
$6,195,021 22.67% |
$6,271,827 21.22% |
$5,930,019 20.76% |
|||
|
Contractual Services.............................................. % of
Total Expenditures................................... |
$1,966,872 7.20% |
$2,603,660 8.81% |
$2,794,570 9.78% |
|||
|
Electronic Data Processing..................................... % of
Total Expenditures................................... |
$1,317,868 4.82% |
$1,361,537 4.61% |
$1,434,607 5.02% |
|||
|
Travel.................................................................... % of
Total Expenditures................................... |
$1,098,428 4.02% |
$1,114,611 3.77% |
$1,170,155 4.10% |
|||
|
Other Expenditures................................................ % of
Total Expenditures................................... |
$1,084,034 3.97% |
$960,764 3.25% |
$1,175,824 4.11% |
|||
|
NonAppropriated Funds Total............................... % of
Total Expenditures................................... |
$11,500 0.04% |
$10,000 0.03% |
$0 0.00% |
|||
|
Cost
of Property and Equipment........................ |
$4,507,306 |
$4,646,328 |
$4,627,005 |
|||
|
SELECTED ACTIVITY MEASURES (unaudited) |
June 30, 2004 |
June 30, 2003 |
June 30, 2002 |
|||
|
Domestic Commercial
Banks........................... Foreign Bank Offices...................................... Domestic Corporate Fiduciaries...................... Financial Information System Entities............... Pawnbroker Licensees.................................... State-Chartered
Savings and Loan Associations, Savings Banks, and Service Corporations................................ Residential Mortgage Licensees...................... |
492 15 203 544 207
92 2,012 |
501 17 558 208
93 1,828 |
509 18 217 569 223 96 1,545 |
|||
|
|
FY
2004 |
FY
2003 |
FY
2002 |
|||
|
Real Estate New
Licenses Issued................................ Renewals
Issued....................................... Cases
Investigated.................................... Real Estate Appraisers New
Licenses Issued................................ Renewals
Issued....................................... Auctioneers New Licenses Issued................................ Renewals
issued........................................ |
11,651 27,264 794 3,166 3,417 121 1,175 |
9,313 38,971 969 1,168 388 140 12 |
7,967 28,549 1,057 1,821 4,639 177 1,417 |
|||
|
AGENCY HEAD |
|
During Audit Period:
William Darr (until 1/31/03) D. Lorenzo Padron (effective 5/02/03 -
6/30/04) Currently: D. Lorenzo Padron |
|
Agency did not receive guidance or documentation with
the billings from CMS Efficiency initiative payments were made from line
items that had available monies Efficiency initiative payments totaled $386,693
A $1 million computer system does not meet the needs of
the Agency
Lack of training has led to inaccurate data being
entered into the system
Daily receipts are not reconciled to the general ledger
Fees assessed are not reconciled to fees collected
Accounts receivable balances of $631,855 and $449,207
at June 30, 2004 and 2003, respectively, were not adequately monitored Vehicle logs were not maintained
Two unassigned vehicles were used 73% and 62% of the
time for commuting purposes during the period
Savings Bank Examiner Training Foundation was not
established as required by law
Vacancy was not filled for 173 days Fourteen of 25 licensees did not submit an annual
report within required timeframe
203 of 515 examinations were conducted 1 to 20 months
late |
INTRODUCTION
This report presents our State compliance examination for the two years ended June 30, 2004. In March 2004, the Governor issued Executive Order #6 to reorganize agencies by the transfer of the functions of the Department of Financial Institutions, the Department of Insurance, the Department of Professional Regulation and the Office of Banks and Real Estate into the newly created Department of Financial and Professional Regulation. This Executive Order consolidated the powers, duties, rights, responsibilities, and functions of the four agencies into one new agency. The Executive Order was filed with the Secretary of State on April 1, 2004, and went into effect July 1, 2004. The Office of Banks and Real Estate was considered abolished as of July 1st, and is now part of the new Department of Financial and Professional Regulation.
FINDINGS, CONCLUSIONS, AND
RECOMMENDATIONS
PAYMENTS WERE MADE FOR EFFICIENCY INITIATIVE BILLINGS FROM IMPROPER
LINE ITEM APPROPRIATIONS AND FUNDS
The Agency made payments for efficiency initiative billings from improper line item appropriations and funds. Public Act 93-0025, in part, outlines a program for efficiency initiatives to reorganize, restructure and reengineer the business processes of the State. The State Finance Act details that the amount designated as savings from efficiency initiatives implemented by the Department of Central Management Services (CMS) shall be paid into the Efficiency Initiatives Revolving Fund. The Act further requires State agencies to pay these amounts from line item appropriations where cost savings are anticipated to occur.
The Agency did not receive guidance or documentation with the billings from CMS detailing from which line item appropriations savings were anticipated to occur. According to Agency staff, they received no documentation or information from CMS detailing the nature and/or type of savings that CMS anticipated. The only guidance received on the billings was the amount of payments that should be taken from General Revenue Funds ($263,930) versus Other Funds ($122,763) for the September 2003 billings. The Agency adjusted its payments for the billings since it did not receive any General Revenue Fund appropriations for FY04. The Agency made payments for these billings not from line item appropriations where the cost savings were anticipated to have occurred but from line items that had available monies. For example, the Agency used: · $78,859 from the Savings and Residential Finance Regulatory Fund (Fund #0244) for parts of the CMS billings relative to the Procurement Efficiency, Information Technology and Vehicle Fleet Management Initiatives. State law (205 ILCS 105/7-19.1 (b)) details that “Moneys in the Savings and Residential Finance Regulatory Fund may not be appropriated, assigned, or transferred to another State fund. The moneys in the Fund shall be for the sole benefit of the institutions assessed.” When specifically asked how the use of this Fund for the efficiency billings was in accordance with the law, the Agency replied, “These payments were made at the direction of the Governor’s Office of Management and Budget pursuant to Public Act 93-0025.” · $187,234 from the Bank and Trust Company Fund (Fund #0795) for parts of the CMS billings relative to the Procurement Efficiency, Information Technology and Vehicle Fleet Management Initiatives. State law (205 ILCS 5/48 (3) (c)) details that administrative expenses can be paid with monies in the Fund. Additionally, the law states that expenses are payable “all to the extent that those expenditures are directly incidental to such examinations or administration.” When specifically asked how the use of this Fund for the efficiency billings was in accordance with the law, the Agency replied, “These payments were made at the direction of the Governor’s Office of Management and Budget pursuant to Public Act 93-0025.” The Agency paid a total of $386,693 for the efficiency initiative from various funds. (Finding 1, pages 10-12) We recommended that the Agency only make payments for efficiency initiative billings from line item appropriations where savings would be anticipated to occur. Further, the Agency should seek an explanation from the Department of Central Management Services as to how savings levels were calculated, or otherwise arrived at, and how savings achieved or anticipated impact the Agency’s budget. Agency officials concurred with our finding and stated they have continued to seek identification of these savings.
DEFICIENCIES IDENTIFIED WITH
THE LICENSING, ENFORCEMENT, AND REGULATORY COMPUTER SYSTEM
The Agency’s Credentialing
Licensing Enforcement And Regulation system (CLEAR) had significant
deficiencies. The CLEAR system was
implemented in February 2003. This
computerized licensing, enforcement and regulatory system was developed by a
contractor with a total cost of approximately $1 million. During our
review of the Mortgage Banking Division, we found the CLEAR system was not
meeting the needs of the Agency. The
following problems were identified: · Inability to accurately count fees and reconcile to dollar amounts. · Entities are billed more than once for the same transaction. · Licenses were not automatically listed as inactive when renewal timeframes were not met. · Access to the system was not effectively controlled. We identified former employees with active access rights and staff with excessive rights based on job duties. · A user manual to guide staff on the efficient and effective use of the system had not been developed. Additionally, the lack of user training has led to inaccurate information being entered into the CLEAR system causing incorrect fees to be assessed. (Finding 2, pages 13-14)
We recommended that the Agency evaluate the CLEAR system and develop a corrective action plan to enhance the system to ensure that it meets the needs of the users. Agency officials concurred with the finding and indicated they are in contact with the vendor to ascertain the feasibility of certain system changes and/or enhancements. In addition, the Agency also indicated that procedures will be developed and training provided to the users. NEED TO IMPROVE CONTROLS OVER REVENUE PROCESSING
The
Agency did not have adequate controls over its revenue processing. The Agency was comprised of the following
four Bureaus: 1.
Bureau of Banks
and Trust Companies, 2.
Bureau of Real
Estate Professions, 3.
Bureau of
Residential Finance and 4.
Bureau of
Administration. Each
of these Bureaus process revenues to varying degrees and these revenues are
ultimately sent to the Fiscal Office in the Bureau of Administration for
final processing and posting to the general ledger. The Agency collected approximately $42,872,046 and $30,919,687
through 27 and 25 different fee categories in FY04 and FY03,
respectively. We noted the following deficiencies with revenue
processing: ·
Checks are not logged immediately after receipt in all divisions. · Checks are not immediately restrictively endorsed in all divisions. ·
Daily receipt logs, if maintained, are not reconciled to deposits or
entries in the Credentialing Licensing Enforcement And Regulation (CLEAR)
system. ·
Receipts entered into the CLEAR system are not reconciled to the
general ledger. ·
Fees assessed are not reconciled to fees collected. ·
The Agency does not maintain a listing of NSF/returned checks to
promote adequate monitoring and follow-up. ·
Divisions within the Bureau of Real Estate Professions and Bureau of
Residential Finance do not have procedures in place to adequately monitor and
track accounts receivable. The total
accounts receivable balances for these divisions were $631,855 and $449,207
at June 30, 2004 and 2003, respectively. ·
General policies and procedures for revenue processing have not been
developed. ·
The Mortgage Banking division does not adequately segregate the billing
function from the payment receipt function.
(Finding 4, pages 16-17) We
recommended that the Agency develop and implement adequate and consistent
internal controls over revenue processing.
We further recommended that the Agency adequately segregate the
billing functions from the receipt functions. Agency officials concurred with the finding
and stated that they plan to centralize the receipt processing function,
which will provide stricter oversight.
In addition, the Agency has submitted a request to the vendor for an
estimate of costs to change the CLEAR System in respect to controls over
revenue processing. |