REPORT DIGEST
ILLINOIS HOUSING
DEVELOPMENT AUTHORITY
FINANCIAL AUDIT AND COMPLIANCE EXAMINATION (In accordance with the
For the Year Ended: June 30, 2005 Summary of Findings: Total this report 10 Total last report 10 Repeated from last report 8 Release Date:
April 25, 2006
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 and the
Full Report are also available on the worldwide web at http://www.state.il.us/auditor
|
SYNOPSIS ¨ The Illinois Housing Development Authority (Authority) is not adequately monitoring subrecipients of the HOME Investment Partnership (HOME) program. ¨ The Authority inaccurately calculated and reported its match for the HOME program. ¨ The Authority did not obtain required certifications that subrecipients were not suspended or debarred from participation in Federal assistance programs for the HOME program. ¨ The Authority did not properly reconcile the loan subsidiary system for the Affordable Trust Fund program loans to the general ledger as of June 30, 2005. ¨ The Authority did not maintain time sheets for its salaried employees in compliance with the State Officials and Employees Ethics Act during fiscal year 2005.
{Financial Information and Activity Measures are summarized on the next page.} |
FINANCIAL AUDIT AND COMPLIANCE EXAMINATION
For The Year Ended June 30, 2005
GOVERNMENTAL FUNDS
REVENUE AND EXPENDITURES |
FY 2005 |
FY 2004 |
FY 2003 |
● Total Governmental Funds Revenue.........
Real Estate
Transfer Taxes.............................
% of Total Revenue.....................................
Federal Home
Funds.......................................
% of Total Revenue.....................................
Investment,
Interest and Other Income............
% of Total Revenue.................................... |
$80,611,281
$53,486,272
66.3%
$22,859,448
28.4%
$4,265,561
5.3% |
$63,457,723
$43,078,589
67.9%
$16,919,931
26.7%
$3,459,203
5.4% |
$57,400,905
$35,677,836
62.1%
$18,467,260
32.2%
$3,255,809
5.7% |
● Total Governmental Funds
Expenditures & Transfers.....................................................
Grants............................................................
% of Total Expenditures...............................
General and
Administrative.............................
% of Total Expenditures...............................
Payments to
State of Illinois - GRF..................
% of Total Expenditures...............................
Provision for Est. Loss on Loans
Receivable…
% of Total Expenditures..……………………….
Operating
Transfers........................................
% of Total Expenditures………………………. . |
$35,309,919
$19,068,177
54.0%
$3,381,315
9.6%
$5,160,427
14.6%
$2,500,000
7.1%
$5,200,000
14.7% |
$26,387,004
$8,595,276
32.6%
$3,287,728
12.5%
$8,804,000
33.4%
$500,000
1.8%
$5,200,000
19.7% |
$20,335,942
$10,065,379
49.5%
$3,570,563
17.5%
$0
0.0%
$1,500,000
7.4%
$5,200,000
25.6% |
ADMINISTRATIVE FUND
REVENUE AND EXPENSES |
|||
● Total Administrative Fund Revenue...........
Service Fees..................................................
% of Total Revenue.....................................
Interest
and Investment Income......................
% of Total Revenue.....................................
Other Income.................................................
% of Total Revenue..................................... ● Total Administrative Expenses ..................
Salaries and
Benefits......................................
% of Total Expenses................................. ..
Average
No. of Employees...........................
Professional
Fees ........................................ .
% of Total Expenses....................................
Other
General and Administrative Expenses.....
% of Total Expenses....................................
Transfers.......................................................
% of Total Expenses....................................
Financing
Costs..............................................
% of Total Expenses.................................... ● Net Value of Property and Equipment......... |
$19,355,656
$9,371,623
48.4%
$5,501,498
28.4%
$4,482,535
23.2%
$29,707,955
$11,228,953
37.8%
193
$1,325,244
4.5%
$3,282,486
11.0%
$13,533,288
45.6%
$337,984
1.1%
$498,089 |
$17,123,673
$8,964,254
52.4%
$4,055,046
23.7%
$4,104,373
23.9%
$16,690,745
$11,270,791
67.6%
198
$1,921,958
11.6%
$3,426,062
20.6%
$(487,453)
(3.2)%
$559,387
3.4%
$595,811 |
$16,075,809
$8,211,732
51.1%
$3,602,576
22.4%
$4,261,501
26.5%
$15,888,921
$10,429,594
65.7%
195
$1,277,098
8.0%
$3,604,299
22.7%
$211,646
1.3%
$366,284
2.3%
$703,202 |
SELECTED
ACTIVITY MEASURES
|
|||
Total Number of Bond Issues Outstanding......... Total Bond Issue Liability (in millions)................ Production of Housing Units.............................. Production of Low Income Housing Units.......... % Low Income Housing Units to all Units.......... |
81
$1,493
162,771
145,174
89.2% |
82
$1,490
156,171
140,227
89.8% |
94
$1,783
150,055
134,371
89.5% |
EXECUTIVE DIRECTOR |
|||
During Audit Period:
Kelly King Dibble
Currently: Kelly King Dibble |
Note: Statistics above do not include bond activity.
The Authority is
not adequately monitoring subrecipients of the HOME program
The Authority
did not document their attempts to collect 17 delinquent subrecipient reports
The Authority
did not follow-up on six reports that contained instances of noncompliance The Authority
over-reported matching funds of approximately $165,258
The Authority did not include a certification and/or verify that subrecipients were not barred from participation in federal programs The Authority had a
variance of $347,360 between the records of a loan program and their general
ledger
No supervisory
review is performed on loan information input in the Benedict system Not all Authority
employees maintained time sheets as required by the Act |
INTRODUCTION
The 2005 engagement of the Illinois Housing Development Authority (Authority) is presented in two reports. The State compliance attestation examination is presented in one report and the financial statement audit is presented in another report. Our engagement was performed in accordance with the Single Audit Act and OMB Circular A-133.
FINDINGS, CONCLUSIONS, AND
RECOMMENDATIONS
INADEQUATE MONITORING OF SUBRECIPIENTS RECEIVING FEDERAL AWARDS The Authority is not adequately monitoring subrecipients of the HOME Investment Partnership Program (HOME). We tested all 29 subrecipients of the HOME program for fiscal year 2005. We noted the following exceptions: · Seventeen of the subrecipient OMB Circular A-133 reports were received from 15 to 268 days after the reports were due, and there was no documentation of the Authority’s attempts to collect the delinquent reports. · Six of the subrecipients had instances of noncompliance in their reports, and the Authority did not follow-up on and did not issue a management’s decision on these audit findings.
Authority management indicated they followed up on delinquent audit reports via e-mail, but failed to retain documentation of the follow-up. Management went on to note staff shortages resulted in a lack of follow-up on the corrective action plans and audit findings of subrecipients. Failure to adequately monitor all subrecipients could result in federal funds being expended for unallowable purposes and/or subrecipients not properly administering the federal program. (Finding 1, pages 14-16) This finding was first reported in 2002.
We recommended the Authority document the monitoring and follow-up procedures on the submission of OMB Circular A-133 reports from subrecipients. Additionally, we recommended Authority management establish procedures to ensure decisions regarding findings in subrecipient reports are issued within six months of receipt. Authority management concurred with our recommendations and noted a monthly supervisory and follow-up procedures is being implemented, a staff member has been assigned to review audit tracking lists monthly and to request all audits in a timely manner. The monthly supervisor review will include procedures to ensure that management decisions are issued within six months of receipt of the audit reports. (For the previous Authority response, see Digest footnote #1.) INACCURATE CALCULATION AND
REPORTING OF MATCH EXPENDITURES During our testing of the match calculations for the HOME program, we selected 12 loans that comprised 50% of the match reported for the HOME program. We noted 3 of the 12 loan match calculations used loan terms that did not agree to the final loan documents, resulting in an over reporting of match funds of approximately $165,258. In addition, we noted there was no documentation of a supervisory review of the match calculations or the HOME match report prior to submission. Authority management stated the lack of a review of the match calculation was due to staff shortages at the time of compiling the reports. Failure to accurately calculate match expenditures results in the Authority providing incorrect information on their required annual HOME match report. (Finding 3, pages 18-19) We recommended the Authority implement procedures to ensure match calculations are accurate, and the HOME match report is reviewed by a supervisor prior to submission. Authority management concurred with our recommendation and indicated they will implement a procedure to ensure all loan document revisions are communicated and a supervisor will review the match reports. Failure to Obtain Suspension and Debarment Certifications for
Subrecipients
During our testing of 29 subrecipients of the Home program, we noted the Authority did not include a suspension and debarment certification in its subrecipient agreements. Additionally, the Authority did not perform a verification check with the “Excluded Parties List System” (EPLS) maintained by the General Services Administration for any of its subrecipients; however, as a result of our audit test work we noted that none of the 29 subrecipients were suspended or debarred from participation in Federal assistance programs. Authority management indicated the lack of the certification was an oversight. Failure to obtain the required certifications or perform verification procedures with the EPLS could result in the awarding of Federal funds to subrecipients that are suspended or debarred from participation in Federal assistance programs. (Finding 5, pages 22-23) We recommended the Authority establish procedures to ensure grantees receiving individual awards for $25,000 or more certify their organization is not suspended or debarred or otherwise excluded from participation in Federal assistance program. Authority management concurred with our recommendation and noted it is amending its procedures so that all subrecipients will be required to provide the Authority with the debarment certifications in conjunction with Authority’s Conditional Commitment Letter for funding. ACCOUNTING FOR PROGRAM LOANS
RECEIVABLE During our testing we noted the Affordable Trust Fund program loan balances recorded in the Benedict system were not reconciled to the general ledger as of June 30, 2005. The variance totaled $347,360 and total loan balances for the Affordable Trust Fund program per the Benedict system were $193,060,620 at June 30, 2005. Additionally, the Authority does not have an adequate process to ensure that new loans are accurately entered into the Benedict system. Specifically, we noted one individual is responsible for entering new loan information into the Benedict system without a supervisory review of the information added or changed. Authority management stated the Benedict system did not become fully linked to the general ledger until late in the fiscal year. Without ensuring program loan balances are properly included and updated in both the Benedict system and the general ledger the true outstanding loan balance and activity will not be known by management and properly reported in the financial statements. This finding was first reported in 2001. (Finding 8, pages 28-29) We recommended the Authority establish and implement procedures to reconcile the program loan balances reported per the Benedict system to the general ledger on a monthly basis. We also recommended the Authority implement procedures to include a supervisory review of new loans entered into the Benedict system to ensure the loan terms agree to the final loan documents. Authority officials concurred with our recommendation and indicated an Accounting Department reorganization addressed both of these issues and assigned specific individuals and supervisory personnel to accomplish these tasks. The Authority indicated they had started reconciling the Benedict system to the general ledger during fiscal year 2006 and will work on doing so monthly. (For the previous Authority response, see Digest footnote #2.) TIME SHEETS NOT MAINTAINED IN
COMPLIANCE WITH THE STATE OFFICIALS AND EMPLOYEES ETHICS ACT The Authority was not maintaining time sheets for its
salaried employees in compliance with the State Officials and Employees
Ethics Act (Act) during fiscal year 2005.
The Authority did not require time reports from its salaried employees
unless overtime hours are incurred. The Act requires
the Authority to maintain a positive timekeeping process. The Act notes policies shall require State
employees to periodically submit time sheets documenting the time spent each
day on official State business. Authority management
indicated they did not receive direction from the Governor’s Office until March 2005 and they
have amended their policies and procedures effective July 13, 2005 requiring
the maintenance of time sheets in compliance with the Act. (Finding 10, page 34) We
recommended the Authority ensure its employees follow the new policy requiring them to maintain
time sheets in compliance with the Act.
Authority management concurred with our
recommendation and indicated on July 13, 2005 the Authority began to maintain
time sheets in compliance with the Act.
OTHER FINDINGS
The remaining findings are reportedly being given attention by the Authority. We will review the Authority’s progress toward the implementation of our recommendations in our next engagement. Mr. James Kregor, Controller, provided the responses to our recommendations.
AUDITORS’ OPINION Our auditors state the Authority’s financial statements as of and for the year ended June 30, 2005 were fairly presented in all material respects.
___________________________________ WILLIAM G. HOLLAND, Auditor General WGH:RPU:pp SPECIAL ASSISTANT AUDITORS KPMG LLP were our special assistant auditor for this engagement. DIGEST FOOTNOTES #1 - INADEQUATE MONITORING OF
SUBRECIPIENTS RECEIVING FEDERAL AWARDS 2004: The Authority concurs with the
recommendation to document the review of the financial audits performed in
accordance with OMB Circular A-133 for each subrecipient that has HOME
program expenditures and to document when the OMB Circular A-133 reports have
been received. The Authority will
develop a checklist to document the receipt and review of the reports, to
include the recommended procedures. The Authority concurs
with the recommendation to add the CFDA number of the HOME Investment
Partnership program and the Federal agency name to correspondence with the
subrecipient. #2 -
ACCOUNTING FOR PROGRAM LOANS RECEIVABLE 2004: The Authority concurs with the
recommendations to establish and implement procedures to reconcile the
program loan balances reported per the Benedict system to the general ledger
on a monthly basis. The Authority
plans to accomplish this for the review of the June 30, 2005 balances and
then apply this on a monthly basis going forward. The Authority concurs with the recommendation to
include a supervisory review of new loans entered into the Benedict system to
ensure the loan terms agree to the final loan documents. The Authority will address the information
flow difficulties noted in the auditor’s comments and plans top re-organize
certain job responsibilities so that specialized loan set-up positions are
created and have supervisory review.
The Authority wishes to note that loan documents can be revised during
the term of a loan such as to incorporate work-out agreements, and that
revised procedures will be developed to ensure that any revised terms are
reflected in the Benedict system. |