REPORT DIGEST

 

ILLINOIS HOUSING DEVELOPMENT AUTHORITY

 

FINANCIAL AUDIT AND COMPLIANCE EXAMINATION

(In accordance with the
Single Audit Act and OMB Circular A-133)

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.}

 

 


ILLINOIS HOUSING DEVELOPMENT AUTHORITY

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.