| 
   
 
 REPORT DIGEST   DEPARTMENT OF NATURAL
  RESOURCES   FINANCIAL AUDIT OF
  CAPITAL ASSET ACCOUNT  For the Year Ended June 30, 2004   COMPLIANCE EXAMINATION For the Two Years Ended: June 30, 2004   Summary of Findings: Total this audit 29 Total last audit 12 Repeated from last audit 9   Release Date: April 28, 2005   
   
 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 Department made payments for efficiency billings from
  improper line item appropriations   ·         
  The
  Department’s preparation and submission of year-end accounting reports to the
  Office of the State Comptroller were not performed in an accurate manner.    ·         
  The
  Department’s preparation and submission of year-end accounting reports to the
  Office of the State Comptroller related to the capital asset account were not
  performed accurately, causing financial reporting delays.      ·         
  The
  Department did not maintain accurate property control records.  Equipment and property totaled in excess
  of $1.035 billion at June 30, 2004.    ·         
  The
  Department did not maintain accurate and complete commodity inventory
  records.  The Department did not
  record the value of paper or printed publications for sale as inventories and
  included postage amounts as commodity inventories rather than pre-paid postage.
     ·         
  The
  Department failed to consistently use its Programmatic Accounting System as
  outlined in its policies and procedures related to federal aid
  coordination.     ·         
  The
  Department-wide timekeeping system was not automated which resulted in
  inefficiencies and errors in reporting employee accumulated leave.  Each division within the Department
  maintained a manual timekeeping system for their several hundred employees.   ·         
  The
  Department did not have adequate controls over its State vehicles.    ·         
  The
  Department did not maintain adequate controls over processes related to
  telecommunications equipment and expenditure records.    ·         
  The
  Department did not cancel telephone calling cards in a timely manner when use
  of the calling card was not justified.   ·         
  The
  Department did not enter citations and written warnings issued by
  Conservation Police Officers into the TIPS in a timely manner.    ·         
  The
  Department did not ensure adequate controls were implemented in the
  management of its petty cash funds and in accordance with State Comptroller
  requirements.    ·         
  The
  Department did not prepare and file annual progress reports on the
  implementation and development of the Open Space Lands Acquisition and
  Development Act.    ·         
  The
  Department did not submit quarterly accounts receivable reports in a timely
  manner and did not maintain a formal quarterly aging schedule for accounts
  receivable.     ·         
  The
  Department did not maintain time sheets for its employees in compliance with
  the State Officials and Employees Ethics Act. 
 
 Expenditures and Activity Measures are summarized on the next page.}  | 
 
DEPARTMENT
OF NATURAL RESOURCES
FINANCIAL
AUDIT OF CAPITAL ASSET ACCOUNT 
For the Year Ended June 30, 2004 
AND COMPLIANCE
EXAMINATION 
For the
Two Years Ended June 30, 2004
 
| 
      | 
  
   FY 2004  | 
  
   FY 2003  | 
  
   FY 2002  | 
 
| 
   Total Expenditures (All Appropriated Funds).          OPERATIONS TOTAL...............................              % of Total
  Expenditures.........................                Personal Services....................................              % of Operations Expenditures.................              Average No. of Employees:                   Regular.............................................                    Part-time...........................................                Other Payroll Costs (FICA, Retirement)..              % of Operations Expenditures.................                Contractual Services...............................              % of Operations Expenditures.................                     All Other Operations Items......................              % of Operations Expenditures.................                GRANTS, REFUNDS, OTHER.............              % of Total
  Expenditures.........................    Cost of Property and Equipment (in thousands)........................................................   | 
  
   $284,600,500   $113,578,410 39.9%   $69,440,029 61.1%   1,816 329   $18,987,459 16.7%   $13,066,714 11.5%   $12,084,208 10.7%   $171,022,090 60.1%     $1,035,066  | 
  
   $326,297,574   $119,135,611 36.5%   $74,979,458 62.9%   1,882 291   $20,104,217 16.9%   $12,613,912 10.6%   $11,438,024 9.6%   $207,161,963 63.5%     $987,540  | 
  
   $362,139,630   $121,965,239 33.7%   $75,251,060 61.7%   2,067 341   $20,121,028 16.5%   $13,744,741 11.3%   $12,848,410 10.5%   $240,174,391 66.3%     $973,098  | 
 
 
| 
   SELECTED ACTIVITY
  MEASURES  (Not Examined)  | 
  
     FY 2004  | 
  
     FY 2003  | 
  
     FY 2002  | 
 
| 
   Acreage owned and
  managed..............................  Site Attendance...................................................  Protected Natural Area
  Acreage..........................  Hunting Licenses Issued.......................................  Fishing Licenses Issued........................................  Students Certified in
  Safety Education Classes.....   | 
  
   456,039 41,086,927 82,957 321,998 754,767 20,248  | 
  
   450,814 43,819,584 76,179 318,164 743,947 26,740  | 
  
   440,465 41,781,000 71,163 326,570 793,034 25,848  | 
 
 
| 
   AGENCY DIRECTOR  | 
 
| 
   During
  Audit Period:   Brent Manning (July 1,
  2002 through March 31, 2003); Joel Brunsvold                                     (effective
  April 1, 2003 through June 30, 2004) Currently:                     Joel
  Brunsvold  | 
 
| 
                                           Department did not receive guidance or
  documentation with the billings from CMS               Efficiency
  initiative payments billed totaled $4,176,774           
   Efficiency
  initiative payments paid by the Department totaled $3,562,174                             Efficiency
  initiative payments made from two funds which could be considered illegal
  diversions of license revenues                                                   Numerous errors in
  preparation and submission of GAAP reporting packages noted         Significant adjustments
  and changes needed to agree Department records to actual expenditures                                   
 
   
   Department
  officials disagree with auditor recommendations           
 
   Auditor Comment                                 
   Year end capital
  asset information in accounting reports not prepared accurately, causing
  financial reporting delays       
 
   Auditors cannot
  determine if ending balances are reasonably stated      
   Amounts not
  substantiated        Failure to
  reconcile   
   Methodology used by
  Department resulted in overstatements         
   $26 million of
  bikeways not initially included on Department records         
   Approximately $37
  million not included on property control records for Water Resources sites   
   All quarterly
  reports on property prepared by the Department and submitted to the State
  Comptroller were inaccurately prepared                                                  
   Auditor Comment                       Inaccurate records over property and
  equipment totaling in excess of $1.035 billion                                                           Incomplete commodity inventory records
  maintained                                         
   Auditor Comment                     Department did not
  follow its policies and procedures related to federal aid coordination       Department unable
  to seek federal reimbursement of $63,992 due to lack of information             
   PAS not
  consistently used to record expenditures                                     Auditor Comment                                   
   Inefficiencies and
  errors in calculating employee accumulated leave due to manual timekeeping
  system                                                         Auditor Comment                               Inadequate controls
  over State vehicles               
   One employee
  authorized to use personal car reimbursed $2,851                                                                 
   Phone records not
  available for FY03       Review of telephone
  calls not required                                                                 
   Telephone calling
  cards not cancelled timely                                           Citations and
  written warnings not entered into TIPS timely                                       Inadequate controls
  over petty cash funds                         
   Monthly
  reconciliations not performed or reconciled by Custodian                                                 
   Auditor Comment                             Annual progress
  report not submitted for FY03 and FY04                                               
   Quarterly accounts
  receivable reports submitted late for 4 of 8 quarters             
   Centralized records
  not maintained to support accounts receivables                                         Auditor Comment                                                                      | 
  
   
 FINDINGS, CONCLUSIONS, AND
  RECOMMENDATIONS   PAYMENTS WERE MADE FOR EFFICIENCY INITIATIVE BILLINGS FROM IMPROPER LINE ITEM APPROPRIATIONS   The Department made payments for efficiency initiative billings from improper line item appropriations. 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 Department did not receive guidance or documentation with the billings from CMS detailing from which line item appropriations savings were anticipated to occur. According to Department staff, they received no documentation or information from CMS detailing the nature and/or type of savings that CMS anticipated. The only guidance received was the amount of payments that should be taken from General Revenue Funds versus other funds for the September 2003 billings.   The Department did not make payments for billings from line item appropriations where the cost savings were anticipated to have occurred. During FY04, the Department received three billings totaling $4,176,774 from CMS for savings from efficiency initiatives. The Department prorated the amounts evenly across all non-federal and unrestricted federal funds, including those in lump sum accounts. The Department paid $3,562,174 for efficiency initiatives from the following:   · $2,702,700 from its personal services, employer paid retirement, contributions to SERS, contributions to Social Security, contractual services, travel, commodities, equipment, EDP, telecommunication, operation of auto and lump sum and other operational purposes line item appropriations to pay for the Procurement Efficiency billing.   · $587,675 from its lump sum and other operation purposes line item appropriation to pay for the Vehicle Fleet Management billing.   · $271,799 from its personal services, employer paid retirement, contributions to SERS, contributions to Social Security and group insurance line item appropriations to pay for the Information Technology billing.   Efficiency initiative payments were also made from two license and stamp funds which could be considered an illegal diversion of license revenues under federal law. To be eligible for these federal funds, the State had to pass assent legislation to assure the U.S. Fish and Wildlife Service (USFWS) there would be no diversion of fish and wildlife license revenues. Diversion of these funds through efficiency initiative payments could invalidate past and future funding from the USFWS. (Finding 1, pages 12-15)   We recommended the Department only make payments for efficiency initiative billings from line item appropriations where savings would be anticipated to occur. Further, we recommended the Department seek an explanation from the Department of Central Management Services as to how savings levels were calculated, or otherwise determined, and how savings achieved or anticipated impact the Agency’s budget.   Department officials agreed with our recommendation and stated they will make savings payments from appropriation lines for which they obtain savings.   INADEQUATE PREPARATION OF YEAR END ACCOUNTING REPORTS   The Department's preparation and submission of year end accounting reports (Generally Accepted Accounting Principles GAAP Package Forms) to the Office of the State Comptroller were not performed in an accurate manner. We noted: 
 · Five adjustments totaling over $4 million were required to agree GAAP reporting packages to actual expenditures.   · Significant changes were required for 10 federal programs. Revisions were needed for receipts, expenditures, receivables, deferred revenues and subrecipient amounts.   · The Department used incorrect rates when calculating salary related costs to prepare the Compensated Absences Form (SCO 580).   · The Statewide Accounting Management System (SAMS) to GAAP reconciliation – capital assets (SCO 537) and the Capital Asset Summary (SCO 538) were prepared incorrectly.   · The Department had inadequate procedures to identify liabilities for capital projects and land acquisition costs payable to local governments from reappropriated accounts. (Finding 2, pages 16-18) This finding was first reported in 2000.   We recommended the Department implement procedures to ensure year end accounting reports are prepared in an accurate and complete manner. We further recommended the Department review and revise, as necessary, its current system of gathering programmatic expenditure information to improve the accuracy of its financial reporting, as well as devote sufficient personnel to the task.   Department officials disagreed with our recommendation and stated management must make informed estimates of the final figures since the GAAP packages are due in many instances prior to the availability of final financial data. Management also stated that until the time issue is addressed, GAAP packages will always require adjusting entries, many of which may be substantial. (For previous Department Response, see Digest Footnote #1.)   In an auditor’s comment we noted this is a repeat finding and that in the prior audit, we noted similar problems with a failure to timely and accurately prepare the Department’s GAAP packages and identify liabilities. Nevertheless, we found similar problems in the current audit. Making informed estimates takes planning, effort and resources. The Department also had two years to deal with its capital asset issues and liabilities issue and neither was resolved in this audit. The proper use of its Programmatic Accounting System noted in finding 04-9 would help the accuracy of the Department’s GAAP forms submitted to the Office of the State Comptroller.   INADEQUATE CONTROLS OVER THE CALCULATION AND SUBMISSION OF CAPITAL
  ASSET INFORMATION FOR FINANCIAL REPORTING PURPOSES    The Department’s preparation and submission of year end accounting reports (GAAP Package Forms) to the Office of the State Comptroller related to the capital asset account were not prepared accurately, causing financial reporting delays. We noted the following problems with the Department’s Statewide Accounting Management System to GAAP Reconciliation – Capital Assets (SCO 537) and the Capital Asset Summary (SCO 538) submitted to the State Comptroller:   · The Department had not agreed the June 30, 2002 ending recalculations with the Common Inventory System (CIS) as of June 30, 2004 although this had been noted in the prior audit.   · Due to the incompleteness of CIS records, the Department did not obtain ending balances for each capitalization category from property control records. Without these amounts, it cannot be determined if ending balances are reasonably stated.   · Accumulated depreciation was calculated incorrectly and individual transaction amounts were not substantiated.   · The Department calculated additions based upon expenditure amounts, and did not reconcile these additions to the CIS system transactions for the year.   · The Department calculated deletions and transfers based upon CIS activity. These amounts are overstated due to the manner in which the Department makes adjustments on the CIS system.   · The Department did not consistently record historical treasures, works of art and other collections in their records.   · The Department did not include Department of Transportation managed projects, totaling approximately $26 million, related to bikeways on its property control records.   · The Department did not include Capital Development Board (CDB) managed state-wide projects, totaling approximately $900,000 on its property control records.   · The Department did not include Office of Water Resources sites, totaling approximately $37 million, on its property control records.   · The Department prepared the SCO 537 based upon incorrect quarterly reports (C-15’s) amounts. All quarterly reports prepared during the examination period were prepared incorrectly.   · Due to the complexity of the above issues, revised amounts related to capital assets and accumulated depreciations were not available until January 12, 2005. (Finding 3, pages 19-21)   We recommended the Department implement procedures to ensure capital assets are reported in an accurate, complete and timely manner and reconcile the Common Inventory System to capital asset reporting amounts to ensure the property control system can be utilized for capital asset reporting. We further recommended the Department review and revise, as necessary, its current system of gathering property control information to improve the accuracy of the Common Inventory System records and devote necessary personnel to these tasks.     Department officials agreed with our recommendation and stated they will continue to pursue solutions to the 30-odd years of previous management staff’s questionable practices for capital asset recording, the Capital Development Board’s misclassification of capital assets in its transfer reports and the Common Inventory System’s inability to provide reports on capital assets that do not require further analysis by Department staff. 
 In an auditor’s comment we noted the Department did not devote sufficient time and resources to properly address GASB 34 when it first became effective in fiscal year 2002 which exacerbated the problem on a go forward basis. We also noted the Department is ultimately responsible for reviewing the information obtained from other State agencies and ensuring the information is properly classified and reported.   INACCURATE PROPERTY CONTROL RECORDS         The Department did not maintain accurate
  property control records over its property and equipment totaling in excess
  of $1.035 billion at June 30, 2004. 
  We noted the following:   ·       
  Five items were not
  properly tagged with a Department property control tag, five items were
  located at sites, but were not listed on the property control records, three
  items appeared obsolete or unusable, but still maintained on property control
  listings, and three items could not be located during our testing.   ·       
  Inconsistencies in
  the manner the Department accounted for historical treasures, works of art
  and other collections.   ·       
  All quarterly
  reports filed with the Office of the Comptroller were inaccurate.  (Finding 4, pages 22-23)  This finding was first reported in 2002.         We recommended the Department remind
  employees of its property control procedures to ensure that such procedures
  are followed and that property control    supervisors be
  held responsible for accurate and complete property control records.         Department officials agreed with our
  recommendation and stated they will remind all employees of property control
  and capital asset reporting responsibilities.  (For previous
  Department Response, see Digest Footnote #2.)   FAILURE
  TO MAINTAIN ACCURATE COMMODITY INVENTORY RECORDS FOR FINANCIAL REPORTING
  PURPOSES         The Department did not maintain accurate
  and complete commodity inventory records for financial reporting purposes in
  accordance with Generally Accepted Accounting Principles (GAAP).         During our review of fiscal year 2004
  GAAP package submissions to the Office of the State Comptroller, we noted the
  Department did not record the value of paper or printed publications for sale
  as inventories and erroneously included postage amounts as commodity
  inventories rather than as pre-paid postage.          We recommended the Department maintain a record of all
  printed material for sale as part of its commodity inventories and properly
  record and classify amounts on year end GAAP package submissions for
  financial reporting.  (Finding 5,
  pages 24-25)  This finding was
  first reported in 2002.   Department officials partially agreed with our recommendation and acknowledged that although the inventories were not included in their GAAP reports, these items were counted and valued. (For previous Department Response, see Digest Footnote #3.)   In an auditor’s comment we noted this is a repeat finding. In the prior audit, we noted the same issue that the Department did not maintain accurate and complete commodity inventory records for GAAP reporting purposes. It is not the auditors’ responsibility to gather this information and post it to GAAP reporting packages submitted to the Office of the State Comptroller.   FAILURE
  TO CONSISTENTLY USE PROGRAMMATIC ACCOUNTING SYSTEM   The Department failed to consistently use its Programmatic Accounting System (PAS) as outlined in its policies and procedures related to federal aid coordination. We noted the following:   · The Office of Land Management did not properly use PAS to record all expenditures related to Federal Emergency Management Agency (FEMA) declared disaster areas at State Parks. The Department failed to capture costs related to vendor payments and employees’ timesheets related to a disaster. Initially, FEMA inspectors estimated disaster repairs to be $122,827, but PAS only captured $63,992 in costs associated with the repairs. The Department is unable to seek reimbursement in excess of $63,992 due to the lack of information entered on PAS documenting actual work completed at various sites.   · The Office of Land Management (OLM) did not properly use PAS to record all expenditures related to its Agriculture Lease program. Because the majority of expenditures had not been properly recorded on PAS, OLM had to separately accumulate all expenditures for each applicable cost center, match the list of centers with a list of eligible federal aid sites, and determine total expenditures. (Finding 9, pages 30-31)   We recommended the Department educate field staff of policies and procedures regarding the Programmatic Accounting System and enforce these procedures to ensure all applicable costs are captured for the federal reporting process.   Department officials generally agreed with the recommendation that the Office of Land Management did not consistently use PAS, but did not believe this caused the loss of federal reimbursements. Department officials also stated the Agriculture Lease program is not a federal program.   In an auditor’s comment we noted the Department’s policies and procedures require the Department to use the PAS system for billings for federal programs. Since the Department did not consistently follow their own policies and procedures, the auditors were unable to determine if all time was captured and claimed. The issue with FEMA was one example of this problem. In addition, although the Agriculture Lease Program is not a federal program, the Department is required to report all Agriculture Lease Program expenditures to the federal government for all sites purchased with federal funds, and we still contend PAS should be used to properly accumulate this information.   TIMEKEEPING SYSTEM IS NOT AUTOMATED  The Department-wide timekeeping system is not automated, resulting in inefficiencies and errors in accurately calculating employee accumulated leave. The Department employs over 1,800 employees and each division within the Department maintains a manual timekeeping system. We noted the following weaknesses:   · The Department calculated accrued leave incorrectly for 11 of 60 (18%) employees selected for testing. One of these errors resulted in accrued vacation being overstated at the end of the month by 19 hours for an individual.   · The Department’s timekeeping process is not universal throughout the Department. The Division of Mines and Minerals uses the CMS Timekeeping System and the Illinois Waste Management Resource Center and the Illinois State Water Survey have their own timekeeping systems; however, most of the divisions use the DNR Manual Timekeeping System which is paper intensive allowing for human errors. (Finding 12, pages 36-37) This finding was first reported in 2000.   We recommended the Department implement an automated timekeeping system to strengthen internal controls and eliminate the multiple timekeeping systems currently used by the Department.   Department officials partially agreed with our recommendation. Department officials stated they are not aware of any authoritative State requirement to implement an automated timekeeping system; however, they will seek to make available to timekeepers currently owned and licensed software that can minimize calculation errors. (For previous Department Response, see Digest Footnote #4.)   In an auditor’s comment, we noted this is a repeat finding and that in the prior audit we noted the same issues with the Department being unable to properly calculate accrued leave and incurring a large number of manual errors. The Department agreed with our prior recommendation to implement an automated system. We again emphasize that due to the size and decentralization of the Department and the continued errors noted, it would be prudent business practices to implement an automated timekeeping system, even as simple as a spreadsheet or database system.   INADEQUATE PROCEDURES REGARDING STATE VEHICLES    The Department did not have adequate controls over its State vehicles. We noted the following:   · 4 of 60 personally assigned vehicles were not approved in writing by the Director as required;   · A regular review of vehicle assignments to determine whether the assignments are in the best interest of the State did not occur;   · 4 of 264 employees reported driving their assigned vehicle less than 1,000 miles during a three-month period. Personally assigned vehicles were not evaluated annually to determine the assignment was still justifiable and in the best interest of the State;   · 1 out of 10 employees did not effectively utilize the Department’s vehicle fleet. This traveler was approved to use his personal vehicle for 7,810 miles, resulting in reimbursement totaling $2,851;   · 12 out of 117 accidents involving State vehicles were not reported in a timely manner. The reports were submitted between 1 and 124 days late;   · Odometer readings were not maintained; and   · Documentation to ensure personally assigned vehicles were adequately maintained was not readily available. (Finding 15, pages 41-44) This finding was first reported in 2002.   We recommended the Department strengthen its controls regarding State vehicles for the items noted.   Department officials agreed with our recommendation and stated the Department’s Offices of Administration and Fiscal Management will co-lead an initiative to reenergize and further enhance the evaluations of the Department’s vehicle fleet management which were initially completed in 2003 and implement as many of the recommendations as is determined viable within existing resources. (For previous Department Response, see Digest Footnote #5.)   INADEQUATE
  CONTROLS OVER TELECOMMUNICATIONS EXPENDITURES AND RECORDS   The Department did not maintain adequate controls over processes related to telecommunications equipment and expenditure records. We noted the following: 
 · The Department failed to maintain records of phone calls for fiscal year 2003 and the Department is currently unable to access electronic back ups of the information.   · The Department did not require supervisors to adequately review and verify a monthly itemized listing of local and long distance calls. 10 of 25 calls selected were not approved in writing by the supervisor.   · Telecommunication records are not updated for changes in assignments of equipment, such as cell phones and pagers. We noted 6 instances where cell phones or pagers were either lost, unnecessary or not currently used by the persons listed by the Telecommunications Coordinator. (Finding 18, pages 48-49) This finding was first reported in 2002. This finding is revised from the previous finding.   We recommended the Department modify the record retention policy to ensure all required information is properly retained and available for review. Also, the Department should document its review of telecommunications charges and phone calls and insure such review is performed in a consistent manner throughout the Department. We further recommended the Department incorporate specific documentation procedures in the Department’s Policies and Procedures Manual.   Department officials agreed with our recommendation and stated the Offices of Administration and Fiscal Management will collaborate on an extensive and exhaustive review of the Department’s telecommunications functions as a whole and will develop and implement policies and procedures as well as modify pertinent existing procedures to achieve an adequate level of management control to the extent possible within existing resources. (For previous Department Response, see Digest Footnote #6.)   TELEPHONE
  CALLING CARDS NOT CANCELLED ON A TIMELY BASIS   The Department did not cancel telephone calling cards in a timely manner when use of the calling card was not justified. We noted 3 of 25 (12%) calling cards assigned to individuals were not cancelled when the employee’s use of the calling card was no longer necessary. (Finding 19, page 50) This finding was first reported in 2002.   We recommended the Department implement procedures to cancel all telephone calling cards immediately when an employee no longer needs the calling card.   Department officials agreed with our recommendation and stated they will reevaluate their need for telephone calling cards and will promptly cancel all cards of former   employees as well as all calling cards. (For previous Department Response, see Digest Footnote #7.)   STATE
  POLICE TRAFFIC INFORMATION PLANNING SYSTEM (TIPS) NOT UPDATED IN A TIMELY
  MANNER         The Department did not enter citations and written warnings
  issued by Conservation Police Officers (CPO) into the TIPS in a timely
  manner.  We noted that as of November
  12, 2004, citations dated June 1, 2004 to present were not entered into
  TIPS.  Also written warnings dated
  from July 1999 to present were not entered into TIPS.  (Finding 21, pages 53-54)  This finding was first reported in
  2002.    We recommended the Department enter all past and future tickets and written warnings issued by CPO’s into TIPS in a timely manner.   Department officials agreed with our recommendation and stated the Department has now made substantial progress in addressing the back-log and believes they will be reasonably current in the near future. (For previous Department Response, see Digest Footnote #8.)   INADEQUATE
  CONTROLS OVER PETTY CASH FUNDS   The Department did not ensure adequate controls were implemented in the management of its petty cash funds and in accordance with State Comptroller requirements (SAMS Procedures 9.10.40). We tested 15 of the Department’s approximate 190 petty cash funds maintained in Springfield and at sites throughout the State and noted the following:   · The Department did not ensure the authorized amounts assigned to each petty cash fund were turning over approximately six times a year. We noted that 8 out of the 15 (53%) funds tested had annual turnover rates for the year that ranged from 0.836 to 4.8. We also noted 1 of the 15 (7%) funds did not submit an annual petty cash turnover report for the year ended 12/31/02.   · The Department did not conduct monthly reconciliations in 3 out of 15 of their petty cash funds tested. We noted 3 out of the 15 (20%) funds tested did not have petty cash reconciliations performed every month. One fund was not reconciled for 7 months from 7/1/02 to 1/31/03. Another petty cash fund was not reconciled for the month of March 2003. Also, 4 out of the 15 (27%) funds were reconciled by the Custodian. (Finding 28, pages 58-59)   We recommended the Department comply with SAMS procedure 9.10.40 and implement controls to ensure petty cash funds’ authorized amounts result in annual turnover rates of approximately six or document within the Petty Cash Turnover Report submission why the current level of the Fund is necessary. We also recommended the Department implement controls to ensure petty cash funds are reconciled on a monthly basis by individuals other than the Custodian.   Department officials disagreed with our recommendation and stated the low turnover rates are historically characteristic of the Department’s petty cash funds due to the nature of the Department’s programs, particularly seasonality and, the remoteness of many petty cash fund locations. Department officials also contend the Comptroller is aware of this issue and provided tacit approval.   In an auditor’s comment we stated the Department’s response that low turnover is due to seasonality and remoteness of petty cash fund locations is inaccurate. All 8 funds noted were maintained at the Central Office. There does not appear to have been any effort to evaluate these funds’ usage once the Department was consolidated into the new building. In addition, the Department did not document on the Petty Cash Turnover Report submission their reasoning why the current funding level of the petty cash funds was necessary. Lastly, the Department did not address our recommendation to ensure petty cash funds are reconciled on a monthly basis by an individual other than the custodian.     REPORTS
  NOT SUBMITTED TO THE GOVERNOR AND GENERAL ASSEMBLY   The Department did not prepare and file annual progress reports on the implementation of the Open Space Lands Acquisition and Development Act. The reports due for fiscal years 2003 and 2004 were not submitted at all. The most recent report was submitted for fiscal year 2001. (Finding 26, page 60) This finding was first reported in 2000. The current finding is revised from the previous finding.   We recommended the Department comply with the Open Space Lands Acquisition and Development Act by preparing and submitting required annual reports to the Governor and General Assembly.   Department officials agreed with our recommendation and stated they will reexamine the statute to verify the requirements and prepare an annual report as soon as fiscal year ending data is available for fiscal year 2005 and each year thereafter. (For previous Department Response, see Digest Footnote #9.)   WEAKNESSES
  IN ACCOUNTS RECEIVABLE REPORTING   The Department did not submit quarterly accounts receivable reports to the Office of the State Comptroller in a timely manner. In addition, the Department did not maintain a formal quarterly aging schedule for accounts receivable. We noted the following:   · The Department is required to submit 4 separate accounts receivable reports (Forms C-97, C-98, C-99, and C-99A) no later than the last day of the month following the end of the quarter to the Office of the State Comptroller. These reports were submitted late 4 of the 8 quarters (50%) during the audit period. In addition, another quarter was submitted after the initial due date, but with an extension granted by the Comptroller’s Office. The reports were submitted from 1 to 21 days late, averaging 5.3 days late.   · The Department’s Fiscal Office did not maintain centralized records supporting accounts receivable and aged accounts receivables submitted to the Comptroller. (Finding 28, pages 62-63)   We recommended the Department implement procedures to file all required accounts receivable reports with the Office of the State Comptroller in a timely manner as required by SAMS. Further, the Department should maintain a current aging schedule of accounts receivable for each quarter of the fiscal year.   Department officials disagreed with our recommendation and stated the information cited in the finding failed to consider whether or not extensions of time to file had been granted. The Department also feels the due dates established by the Office of the Comptroller are arbitrary. In addition, the Department contends they do have files of records supporting its receivable reports from the Division where they originate. Lastly, the Department contended the collectibility estimate is of use to the Department only at year end.   In an auditor’s comment we noted we did consider extensions and added suggested language to the first bullet of the finding addressing the extension. No other documentation was given to the auditors noting any other extensions. It is the Fiscal Office’s responsibility to file accounts receivable reports with the Comptroller and to maintain all necessary support for the information on the forms. The Department’s audit liaison did not provide documentation to support the Department’s accounts receivables numbers, and it is not the auditor’s responsibility to search the Department to find documentation to support the Department’s accounts receivable numbers.     NEED TO COMPLY WITH STATE OFFICIALS
  AND EMPLOYEE ETHICS ACT   The Department is not maintaining timesheets for its employees in compliance with the State Officials and Employees Ethics Act (Act).   The Act requires the Department to adopt personnel policies consistent with the Act. The Act (5 ILCS 430/5-5(c)) states, "The policies shall require State employees to periodically submit timesheets documenting the time spent each day on official State business to the nearest quarter hour."   We noted the Department's employees (other than senior management) did not maintain timesheets in compliance with the Act. Department management stated they relied on advice from the Governor's Office staff which initially stated that agencies using the Department of Human Services payroll system would be in compliance with the Act. (Finding 29, page 64)   We recommended the Department amend its policies to require all employees maintain timesheets in compliance with the Act.   Department officials agreed with our recommendation and stated that its Ethics Officer will confirm with the Governor's Office the actions necessary to fully comply with the Act.     OTHER FINDINGS   The remaining findings are reportedly are being given attention by the Department. We will review progress towards the implementation of our recommendations in our next compliance engagement.   Ms. Ann Sundeen, Chief Fiscal Officer for the Department, provided the responses.   
 
 AUDITORS’ OPINION         We conducted a financial audit of the
  Department’s Capital Asset Account for the year ended June 30, 2004 and a
  compliance examination of the Department for the two years ended June 30,
  2004 as required by the Illinois State Auditing Act.  Our
  special assistant auditors stated that the Department’s capital asset account
  as of June 30, 2004 is presented fairly in all in all material respects.
     
       ____________________________________ WILLIAM G. HOLLAND, Auditor General   WGH:JSC:pp 
 
 AUDITORS ASSIGNED   Our special assistant auditors for this engagement were Sikich Gardner & Co. LLP.     DIGEST FOOTNOTES
 #1 – LACK
  OF TIMELY INFORMATION REPORTED AND INADEQUATE PREPARATION OF GAAP PACKAGES –
  Previous Department Response   2002:  We
  concur.  During FY 2003 the Department
  will establish new methodologies to gather information to improve the
  timeliness and accuracy of our financial reporting.  These methodologies will specifically address the concerns
  identified by the auditors regarding the reporting of capital assets and
  payables for capital projects and grants. 
  The Department also will strive to assign additional personnel to the
  preparation of our annual GAAP reports.   #2 - INACCURATE PROPERTY CONTROL RECORDS –
  Previous Department Response   2002:  We concur.  The Department will immediately remind all location supervisors
  of the Agency’s property control procedures to ensure that such procedures
  are followed and will follow-up on the specific instances noted by the
  auditors to ensure that such instances are corrected in FY 2003.     #3 –
  FAILURE TO MAINTAIN ACCURATE COMMODITY INVENTORY RECORDS FOR GAAP REPORTING
  PURPOSES – Previous Department Response 
 2002:  We concur.  The Department will implement procedures to ensure that paper
  and printed publications for sale are included in the Agency’s commodities
  inventory reported in our GAAP submissions for FY 2003 and future years.  In addition, in FY 2003 the Department
  will implement procedures to reconcile the delivery of publications shipped
  to multiple sites.   #4 –
  TIMEKEEPING SYSTEM IS NOT AUTOMATED – Previous Department Response   2002:  We concur.  The Department will evaluate existing timekeeping systems
  available to the Department at minimal cost. 
  Subject to staffing and funding levels, the Department will work
  toward implementing an automated system in calendar year 2004.  In the meantime, the Department will
  immediately remind all timekeepers and supervisors of their responsibility to
  confirm all timesheet calculations prior to signing such documents.    #5 –
  INADEQUATE PROCEDURES REGARDING STATE VEHICLES – Previous Department Response   2002:  We concur.  In accordance with Executive Order #2, 2003, the Department has
  initiated a thorough evaluation of our vehicle management processes which
  will be completed in March 2003.  As
  part of this evaluation, we are reviewing all assignments of vehicles to
  individual employees to ensure that such assignments are in the best interest
  of the State and that documentation of the Director’s approval of vehicle
  assignments is retained in Agency files.      #6 –
  INADEQUATE CONTROLS OVER TELECOMMUNICATIONS EXPENDITURES AND RECORDS –
  Previous Department Response 
 2002:  We concur.  The Department’s current written procedures requiring
  supervisory review of monthly telephone statements will be revised in FY 2003
  to incorporate specific documentation procedures for this review
  process.  In addition, all Department
  offices have been reminded of their responsibility to review their monthly
  statements to ensure the proper use of the Agency’s telecommunication
  resources.    #7 –
  TELEPHONE CALLING CARDS NOT CANCELLED ON A TIMELY BASIS – Previous Department
  Response 
 2002:  We concur.  In January 2003, the Department’s Telephone Coordinator
  reviewed the listing of employees with assigned calling cards with each
  Agency office to ensure that such cards were cancelled for all employees who
  have retired, transferred or left the Department.  The Department’s existing written procedures for the
  cancellation of calling cards will be revised in FY 2003 to clarify
  responsibilities and ensure that in the future these cards are cancelled in a
  timely manner.  The Department has
  reviewed our billing records for the past two years and has confirmed that
  the nine calling cards identified by the auditors were not used during this
  time period.     #8 – STATE
  POLICE TRAFFIC INFORMATION PLANNING SYSTEM (TIPS) NOT UPDATED IN A TIMELY
  MANNER – Previous Department Response   2002:  We concur.  The staff of the Department’s Office of Law Enforcement is
  working overtime to enter citations into TIPS and has initiated action to
  fill the vacant position assigned responsibility for entering TIPS
  information.    #9 –
  REPORTS NOT SUBMITTED TO THE GOVERNOR AND GENERAL ASSEMBLY INA TIMELY MANNER
  – Previous Department Response   2002:  We concur.  Legislation (P.A. 92-690) was enacted in 2002 which revised the
  submission date for future energy assistance and weatherization reports from
  March 15 to September 30.  This change
  will facilitate the collection and analysis of information provided by
  utility companies and ensure that future reports are submitted to the
  Governor and General Assembly by the statutory due date.     |