REPORT DIGEST

ILLINOIS DEPARTMENT OF PUBLIC AID

FINANCIAL AND COMPLIANCE AUDIT

For the Year Ended:

June 30, 2000

Summary of Findings:

Total this audit 8
Total last audit 24*
Repeated from last audit 5

*Included 7 federal findings; audit results of federal programs for FY 00 will be reported separately in our Statewide Single Audit.

Release Date:
May 17, 2001

Logo.gif (1870 bytes)

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
Attn: Records Manager
Iles Park Plaza
740 E. Ash Street
Springfield, IL 62703

(217)782-6046 or TDD (217) 524-4646

This Report Digest is also available on
the worldwide web at
http://www.state.il.us/auditor

SYNOPSIS

  • Due to the lack of competent evidential matter related to the integrity of accounts receivable balances, the Child Support Trust funds have been omitted from the financial statements and we have issued a qualified opinion on the financial statements for the third year in a row.
  • The Department did not obtain reports necessary to monitor, evaluate and report activity of the Child Support State Disbursement Unit.
  • The Department did not have a complete property listing at June 30, 2000. The Department’s listing did not include $6,150,316 of property purchased for the Child Support State Disbursement Unit and the Medical Warehouse System.
  • The Department’s Bureau of Internal Audit did not comply with provisions of the Fiscal Control and Internal Auditing Act.
  • The Department did not perform monthly reconciliations between the Department’s records and those of the Comptroller for two funds, the Child Support Enforcement Trust Fund and the Public Assistance Recoveries Fund.
  • The Department’s established State Case Registry for child support orders did not contain the information as required by statute.
  • The Department has made limited progress in implementing findings from the Office of the Auditor General’s Management audit of the Child Support State Disbursement Unit. Of our 15 prior recommendations, 2 were implemented, 7 were partially implemented, and 6 were not implemented.

 

 

 

DEPARTMENT OF PUBLIC AID
FINANCIAL AND COMPLIANCE AUDIT
For The Year Ended June 30, 2000

EXPENDITURE STATISTICS (in thousands)

FY 2000

FY 1999

Total Expenditures

$6,778,491

$6,069,226

OPERATIONS TOTAL

% of Total Expenditures

$500,638

7.4%

$367,321

6.1%

Personal Services

% of Operations Expenditures

Average No. of Employees (whole numbers)

$106,834

21.3%

2,853

$100,717

27.4%

2,744

Other Payroll Costs (FICA, Retirement, Group Insurance)

% of Operations Expenditures

$29,371

5.9%

$27,144

7.4%

Contractual Services

% of Operations Expenditures

$101,774

20.3%

$74,619

20.3%

All Other Operations Items

% of Operations Expenditures

$262,659

52.5%

$164,841

44.9%

AWARDS AND GRANTS

% of Total Expenditures

$6,272,673

92.5%

$5,694,862

93.8%

REFUNDS

% of Total Expenditures

$5,180

(Less than 1%)

$7,043

(Less than 1%)

! Cost of Property and Equipment

$49,685

$44,160

SELECTED ACTIVITY MEASURES

FY 2000

FY 1999

Adjudication Processing Time

In Calendar Days (See schedule on page 123)

Overall Average Time Elapsing In Calendar Days to Pay

A Claim (See schedule on page 123)

15.6 Days

24.4 Days

10.8 Days

16.3 Days

Accounts Payable and Accrued Liabilities (General Fund) (Page 42) (in thousands)

$1,050,131

$854,503

AGENCY DIRECTOR(S)

During Audit Period: Ms. Ann Patla (through February 28, 2001)

Currently: Ms. Jackie Garner (effective March 1, 2001)

 

 

 

 

 

 

Child Support accounts receivable balances were not accurate

 

 

 

 

 

 

Qualified opinion on the financial statements for third year in a row

 

 

 

 

Data integrity problems noted during federal certification review

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Contract for SDU ultimately totaled $24 million

 

 

Eight reports were not obtained from contractor

 

 

 

 

 

 

 

 

Recommendations from management audit still open

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Untimely reporting of equipment totaling $6,150,316

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Three major system audits not performed

 

 

 

 

 

 

 

 

 

 

 

 

Child Support Trust Fund and Public Assistance Recoveries Trust Fund not reconciled monthly

 

 

 

 

 

 

 

 

 

 

 

 

 

81 of 81 cases reviewed lacked driver’s license number for custodial parent

 

 

 

 

 

 

 

 

 

 

 

Significant problems remain outstanding

 

 

Of the 15 recommendations, 2 were implemented, 7 were partially implemented, and 6 were not implemented

FINDINGS, CONCLUSIONS, AND RECOMMENDATIONS

INADEQUATE CONTROLS OVER DATA INTEGRITY RELATED TO CHILD SUPPORT ACCOUNTS RECEIVABLE BALANCES

The Department was unable to provide evidence of substantial improvements to the integrity of the data in the Key Information Delivery System (KIDS), which has resulted in the Department’s inability to validate the Child Support Enforcement accounts receivable balances at June 30, 2000. This finding has been repeated since 1998.

During the audit period, the Department formed a workgroup to determine the extent to which noted problems had been resolved or still existed and what corrective actions were needed. During our review of the workgroup results and discussions with Department personnel, we noted:

  • The workgroup randomly selected a sample of 81 child support cases in February 2000, and concluded that errors similar to those found in the past two audits still existed;
  • All 81 cases reviewed contained one or more errors;
  • 20 out of the 81 (25%) cases reviewed, contained errors related to accounts receivable balances; and
  • Some of these problems found required system changes to KIDS, retraining of supervisors and field staff and/or closer supervision of field staff.

Based on our FY98 and FY99 audits, the conditions described above and the conditions described in other findings in our current audit related to Child Support issues, we concluded there were not adequate controls over data integrity related to child support accounts receivable balances.

Due to the lack of competent evidential matter related to the integrity of accounts receivable balances, the Child Support Trust funds have been omitted from the financial statements and we have issued a qualified opinion on the financial statements for the third year in a row.

As also reported in our FY99 and FY98 audits, due to the data integrity problems noted during the Federal Certification Review process, the KIDS system is conditionally certified by the Federal government. The Department was in the process of cleansing data during our fieldwork in an effort to address the federal certification.

Good internal controls would require the Department to maintain sufficient records and financial reports to properly account for assets when a governmental unit is functioning as an agent to another party. Failure to maintain accurate records of child support activity not only affects the financial reporting of the Department of Public Aid, but also increases the risk of material misstatements in the State's general-purpose financial statements. (Finding 1, pages 14 – 15)

We recommended the Department continue with its efforts to identify and correct data integrity problems in KIDS and to obtain unconditional certification by the Federal government. We further recommended the Department strengthen its controls over financial reporting by performing periodic internal tests of account balances and evaluating the reasonableness of child support financial reports.

Department officials accepted our recommendation to continue with its efforts to identify and correct data integrity problems in KIDS and to obtain unconditional certification by the Federal government. However, the Department noted it was officially informed by the federal government in April 2001 that data integrity conditions were fully satisfied. Department officials further stated that the Department is applying all necessary resources to ensure KIDS meets the additional federal requirements for Federal Welfare Reform and the needs of the State, within the constraints of available state and federal appropriations and cash resources. (For previous Department responses, see Digest Footnote 1.)

In an auditor’s comment, we noted our point regarding the KIDS system being conditionally certified by the Federal government was accurate according to information available during our audit fieldwork that ended December, 2000. Additional information was not provided to us regarding this issue until April, 2001. We will evaluate this information during our next compliance audit of the Department.

LACK OF CONTROLS OVER SDU

The Department did not obtain reports necessary to monitor, evaluate and report activity of the State Disbursement Unit (SDU).

The SDU, required by a 1996 Federal law, processes the collection and disbursement of child support payments. The Department executed a contract during February 1999, ultimately totaling $24 million, with the Office of the Clerk of the Circuit Court of DuPage County. The contract required DuPage to develop, establish and operate the SDU.

We noted the Department did not obtain nine reports from DuPage which were required by the contract during FY00. These reports included a monthly report of the total number of transactions processed, total dollars collected by the SDU and total dollars disbursed by the SDU; an exception report of all payments received but not disbursed by the SDU; and an exception report of all unapplied payments received by the SDU.

Additionally, we noted the Department did not audit or contract for an audit of the SDU to determine the reliability of SDU financial information. An audit report would provide assurances as to the effectiveness and efficiency of internal controls over financial reporting.

Other deficiencies related to the SDU were noted in a management audit issued by the Auditor General in March, 2000. The status of the recommendations from the management report are discussed later in this digest. (Finding 2, pages 16-17)

We recommended the following:

  • The Department should obtain reports outlined in its contractual agreements within the timeframes specified.
  • The Department should utilize these reports to monitor and evaluate the contractor’s performance.
  • The Department should monitor contracts to ensure significant functions, such as reconciliations, are being performed timely.
  • The Department should audit the activities of the SDU.
  • The Department should fully implement audit recommendations made in the Auditor General’s Management Audit.

The Department accepted our recommendation with one reservation. The Department did not accept the recommendation to fully implement audit recommendations made in the Auditor General’s Management Audit of the SDU. The Department noted it did not accept all of the recommendations made by the Auditor General in the Management Audit and will implement those it did accept. The Department also responded the contract with the DuPage County Clerk expired on June 30, 2000 and the Department is currently operating the SDU. The Department will monitor future SDU vendor contracts to ensure that the reports required in the contract are provided on a timely basis.

INADEQUATE CONTROL OVER EQUIPMENT

The Department did not maintain adequate controls over property and equipment. We noted the Department did not have a complete property listing as of June 30, 2000. The Department’s listing did not include equipment purchased for the SDU totaling $1,943,091 and its Medical Warehouse System totaling $4,207,225. Lack of a complete listing at June 30, 2000 caused various reports filed with the State Comptroller to be inaccurate.

In August 2000 the Department identified and recorded the above items. In November 2000 the Department reported the omissions to the State Comptroller. (Finding 3, pages 18-19)

We recommended the Department supervise, monitor and report all equipment under its jurisdiction. We further recommended the Department devote adequate resources to ensure accurate and timely reporting of equipment.

The Department officials responded they had implemented our recommendation. The Department noted it concurred that original inventory records provided to the auditors were not all inclusive of these two categories of equipment; efforts/ correction actions were well under way during the course of the audit to correct these conditions. Both of these equipment issues were a result of contractual relationships as opposed to direct purchases of equipment. The Department has strengthened its controls in this area to ensure that all equipment is promptly tagged and recorded in the appropriate system.

NON COMPLIANCE WITH FISCAL CONTROL AND INTERNAL AUDITING ACT

The Department’s Bureau of Internal Audit (BIA) did not comply with provisions of the Fiscal Control and Internal Auditing Act.

During our audit, we noted BIA did not perform the scheduled audits, as outlined by the BIA’s audit plan for Fiscal Year 2000. The audit plan had three major system audits (Agency Organization & Management, Purchasing/Contracting/Leasing and Revenues and Receivables) scheduled; however, none of these audits were performed.

The Fiscal Control and Internal Auditing Act requires that audits of major systems of internal accounting and administrative control be conducted on a periodic basis so that all major systems are reviewed at least once every two years. (Finding 4, page 20)

We recommended BIA devote adequate resources to ensure audits of major systems are conducted at least once every two years as required by the Fiscal Control and Internal Auditing Act.

Department officials accepted our recommendation and stated three vacant positions have been filled; and there are two vacant positions. The Department also responded it is BIA’s intention to complete all audits with the available resources.

LACK OF MONTHLY RECONCILIATIONS

The Department did not perform monthly reconciliations between its records and cash reports of State Comptroller for the Child Support Enforcement Trust Fund (#957) and the Public Assistance Recoveries Trust Fund (#421).

According to Statewide Accounting Management System procedures, a reconciliation of cash should be performed monthly and the Office of the State Comptroller notified of any unreconcilable difference so necessary corrective action can be taken to locate the differences and correct the accounting records.

Failure to properly reconcile the ending balance of available cash in a timely manner could result in inaccurate financial reporting. (Finding 6, page 23)

We recommended the Department prepare complete, accurate and timely reconciliations of the monthly Comptroller report to ensure the accuracy of accounting records and to monitor available funds.

Department officials agreed with the finding and noted the Department has allocated the necessary resources needed to reconcile these funds. The 957 fund has been reconciled and is current. Staff is working on the 421 fund and expect to have it current June 30, 2001.

LACK OF REQUIRED INFORMATION IN THE STATE CASE REGISTRY

The Department’s State Case Registry did not contain driver’s license number for the Custodial Parent or phone number of the Non-Custodial Parent's employer, as required by statute.

During our audit we noted:

  • The Department performed a review of child support cases in February 2000. In 81 of 81 cases reviewed, the driver’s license number for the Custodial Parent was not present in the State Case Registry; and
  • In 54 of 70 (77%) applicable cases reviewed by the Department, the phone number of the Non-Custodial Parent’s employer was not present in the State Case Registry. (Finding 8, pages 25-26)

We recommended the Department continue its efforts to obtain all information for the State Case Registry as required by the Illinois Public Aid Code.

The Department accepted our recommendation.

STATUS OF FINDINGS FROM THE CHILD SUPPORT STATE DISBURSEMENT UNIT MANAGEMENT AUDIT

The Department of Public Aid has made limited progress in implementing findings from the Office of the Auditor General’s Management Audit of the Child Support State Disbursement Unit (SDU). Significant problems remain outstanding.

The audit made 15 recommendations to the Department of Public Aid and the DuPage County Circuit Clerk who was the SDU vendor. Of the 15 recommendations, 2 were implemented, 7 were partially implemented, and 6 were not implemented. The status is summarized in the exhibit on the next page.

 

 

 

No documentation of audit provided

 

 

Circuit clerks reported the Department had not worked with them to eliminate duplicate cases

 

 

 

 

 

 

Reconciliations between Department records and circuit clerks not performed

 

 

 

 

 

$9.7 million of emergency payments not recouped

 

 

 

In 7 of 55 cases sampled, emergency payments were made on the same date or after regular support payments had been disbursed

 

 

Emergency payments not reviewed to determine whether they were unnecessary or duplicative

 

 

 

Some of the recommendations from the management audit not implemented included:

Conduct Audit of KIDS: The management audit recommended that the Department should conduct a detailed audit of the KIDS (Key Information Delivery System) computer system to identify the nature and cause of its deficiencies. In our follow-up work, the Department reported that it was having an audit done of the Child Support Program which includes the KIDS system, but did not provide any documentation of that audit.

Remove SDU Inactive Cases: The management audit recommended that the SDU and Public Aid, with the assistance of circuit clerks, should take the steps necessary to remove inactive or duplicate cases from the SDU database and ensure that the remaining data in the SDU system is accurate. Our follow-up work found that the Department did not remove a significant number of inactive or duplicate cases from the SDU system. In the management audit we reported that there were over 800,000 cases in the SDU system. On January 4, 2001, the Department reported that there were still 798,467 cases in the system. We spoke with 7 circuit clerks during this follow-up audit work and most reported that the Department had not worked with them to eliminate duplicate cases.

Reconcile Case Information: The management audit recommended that the Department should continue its efforts to reconcile IV-D case information with the circuit clerks and ensure that non-custodial parents' account balances are accurately stated. In our follow-up work, we found that the Department had contracted with a private vendor to scrub the data in the SDU system. However, this contract did not include work to correct receivable balances. Child Support officials previously stated that they planned to begin an internal process to reconcile account balances in June 2000; however, in October 2000, Child Support officials told us that the reconciliation project had been discontinued.

We also conducted follow-up work related to the $10 million issued in emergency checks by the Department between October 19, 1999 and January 5, 2000. Approximately $9.7 million of the emergency payments have not been recouped by the Department. In a formal opinion, the Attorney General determined that federal law prohibits the Department from recouping emergency payments without the custodial parents' permission. In his February 21, 2001 budget address, the Governor stated that the State should not attempt to recoup emergency payments.

In our follow-up work, we reviewed 55 accounts with large dollar emergency checks, ranging from $2,030 to $8,100 apiece. For most of these cases, our review of the SDU payment history database showed that backlogged payments appeared to be caught up with payments being regularly disbursed by February 2000. In fact, in 7 cases (13%) the emergency payment was made on the same date or after regular child support payments had been disbursed.

Neither a contractor hired by the Department nor the Department's Inspector General had reviewed emergency payments to determine whether any of the checks issued were unnecessary (because regular child support payments were current at the time the emergency check was issued) or duplicative. The Department had not determined the extent to which individual accounts may have been overpaid because of emergency payments, and the Inspector General's review of emergency payments to identify possible fraudulent activity is on-going.

OTHER FINDINGS

The remaining findings are reportedly being given attention by the Department. We will review the progress towards the implementation of our recommendations in our next compliance audit.

Mr. Eappen Thomas, Acting Chief Internal Auditor for the Department, provided written responses to our findings and recommendations on April 24, 2001.

AUDITORS’ OPINION

Our auditors stated the Department’s financial statements as of and for the year ended June 30, 2000 were fairly presented in all material respects except for the effect of the omissions of Child Support Enforcement Trust Funds #957, #1957, and #2957. The Child Support Enforcement Trust Funds should be included in order to conform with generally accepted accounting principles.

_____________________________________

WILLIAM G. HOLLAND, Auditor General

WGH:GSS:pp

SPECIAL ASSISTANT AUDITORS

Pandolfi, Topolski, Weiss & Co., LTD. were our special assistant auditors for this audit.

DIGEST FOOTNOTES

#1 INADEQUATE CONTROLS OVER DATA INTEGRITY RELATED TO CHILD SUPPORT ACCOUNTS RECEIVABLE BALANCES - Previous Agency Responses

1999: "ACCEPTED - As of October 1, 1999, the Division of Child Support Enforcement (DCSE) has implemented the Data Base Cleanup Project to cleanse data currently in the KIDS system. Additionally, by April 1, 2000, the DCSE will establish a quality control process which will require supervisory staff to randomly select cases and review balances for accuracy. By March 1, 2000, the DCSE will be contracting with a third party to provide additional data clean up services for the KIDS system."

"IMPLEMENTED - The KIDS system is certified as meeting Federal requirements. Staff will continue to be dedicated to maintain and operate the KIDS system to satisfy any needs of the State. It is the intent of the Department to thoroughly plan future large system development projects to ensure that contractual provisions are met and the operational systems are implemented in a timely manner."

1998: "Accepted. The lack of accounts receivable documentation is being addressed by the establishment of an internal financial accountability workgroup. This workgroup has the responsibility to ensure that reporting requirements are met and that supporting documentation for these financial records are maintained in accordance with federal record retention requirements."