REPORT DIGEST

 

UNIVERSITY OF ILLINOIS

 

COMPLIANCE EXAMINATION

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

For the Year Ended: June 30, 2009

 

Summary of Findings:

Total this audit:  47

Total last audit:  12

Repeated from last audit:  7

 

Release Date: May 13, 2010

 

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 Full Report are also available on the worldwide web at http://www.auditor.illinois.gov

 

 

INTRODUCTION

 

            The Financial Statement Audit for the year ended June 30, 2009 was previously released on March 25, 2010.  That audit contained three audit findings. This report addresses federal and State compliance findings pertaining to the Single Audit and State Compliance Examination.  In total, this document contains 47 audit findings, three of which had been reported in the Financial Statement Audit.

 

SYNOPSIS

 

           The University does not have adequate documentation of payroll and fringe benefit expenditures for certain nonacademic and hourly employees at the Chicago campus.

 

           The University does not have adequate documentation of payroll and fringe benefit expenditures for employees at the Urbana campus who work on the Cooperative Extension Services program or the Hatch Grant under the Research and Development Cluster program.

 

           The University does not have an adequate process in place to determine the allowability of certain expenditures used to meet the cost share (matching) requirement of the Supplemental Nutrition program.

 

           The University used an unsupported rate to value services of volunteers used to meet the cost share (matching) requirement of the Supplemental Nutrition program.

 

           The University did not initially include all federal grants in the schedule of expenditures of federal awards.

 

           The University is not adequately performing or documenting reviews of subrecipient OMB Circular A-133 audit reports.

 

           The University did not accurately report federal expenditures in quarterly reports for the Supplemental Nutrition program submitted to the Illinois Department of Human Services.

 

           The University did not properly perform verification procedures for students at the Urbana campus.

 

           The University did not provide required program information relative to federal funds passed through to the subrecipients of the Research and Development Cluster programs for the year ended June 30, 2009.

 

           The University has not established adequate internal controls over contracts and leases to ensure they contain all necessary provisions and are properly executed prior to performance.

 

           The University has not established adequate internal controls over estimating and recording its allowance for doubtful patient accounts receivable.

 

           The University does not have an adequate process to measure and value pharmaceutical inventory balances as of fiscal year end.

 

INTRODUCTION

 

            The Single Audit and Compliance Examination is contained in two report documents.  One report contains compliance findings disclosed by our tests and certain supplemental information.  The other report contains supplementary financial information and special data requirements.

 

FINDINGS, CONCLUSIONS, AND RECOMMENDATIONS

 

INADEQUATE DOCUMENTATION FOR PAYROLL AND FRINGE BENEFIT EXPENDITURES

 

            The University does not have adequate documentation of payroll and fringe benefit expenditures for certain nonacademic and hourly employees at the Chicago campus.

 

            Bi-weekly time reports are prepared by the Chicago campus for non-academic and hourly personnel.  These bi-weekly time reports, which are prepared on both a positive and negative (exception) basis depending on the type of employee, are intended to meet the effort reporting requirements of OMB Circular A-21, Cost Principles for Higher Education Institutions (OMB Circular A-21).  However, the bi-weekly time reports for certain departments do not include the activities of the employee on the time report as required by OMB Circular A-21. 

 

            Specifically, the University uses two different methods for the recording and approving time for non-academic and hourly employees.  The first method, Web Entry, is designed so that employees directly enter their own total hours worked.  Payroll costs are allocated to federal and nonfederal projects (funds) based on the initial appointments (budgeted allocation percentages). 

 

            For the Web Entry method, a supervisor reviews and approves the time and the respective federal and nonfederal project (fund) allocations.  The second method, Department Time, is designed so that time is entered centrally by a designated employee.  Similar to the Web Entry method, time is allocated to federal and nonfederal projects (funds) based on the initial appointments (budgeted allocation percentages). For these employees, a supervisor reviews the total time reported by an employee; however, the electronic time reports reviewed do not directly contain the federal and nonfederal project (fund) allocations to substantiate the allocations as required by OMB Circular A-21.   The University estimates that approximately half of the departments on the Chicago campus use the Web Entry method and half use the Department Time method. 

 

            Our audit identified other controls and processes that the University has implemented to mitigate the risk that payroll costs are improperly charged to a federal program.  These include required reviews and approvals of the initial appointments of employees (i.e. allocation to federal and nonfederal projects) and monthly reviews by principal investigators (PI’s) of labor distribution reports and project ledgers.  However, the monthly review by principal investigators is not documented.

 

            Inadequate documentation and lack of required effort certifications may result in the federal funds being expended for unallowable purposes. (Finding 4, Pages 26-28)

 

            We recommended the University implement procedures to ensure documentation exists to substantiate the after-the-fact confirmation of activity allocable to each federal grant by the respective employee, principal investigator, or a responsible official.

 

            University officials accepted the recommendation and stated that they will establish documentation to substantiate the after the fact attestation of time spent and fund allocations for bi-weekly employees.

 

INADEQUATE DOCUMENTATION FOR PAYROLL AND FRINGE BENEFIT EXPENDITURES

 

            The University does not have adequate documentation of payroll and fringe benefit expenditures for employees at the Urbana campus who work on the Cooperative Extension Services (CES) program or the Hatch Grant under the Research and Development Cluster program.

 

            The University does not obtain effort certifications for employees who work on the CES program or the Hatch Grant under the Research and Development Cluster program as required by federal regulations.  We reviewed a sample of 30 payroll and fringe benefit expenditures totaling $88,494 for the CES program and two payroll and one fringe benefit expenditures totaling $2,624 for the Hatch Grant noting that the effort of these individuals was charged to multiple activities; however, effort certifications were not obtained.

 

            Additionally, we noted effort certifications were not obtained for any of the payroll charges used to meet the cost sharing (matching) requirements of the CES program and Hatch Grant.  Total payroll and fringe benefit expenditures charged to the CES program for the fiscal year ended June 30, 2009 were $3,298,151 and $2,364,529, respectively.  Total payroll and fringe benefit expenditures charged to the Hatch Grant for the fiscal year ended June 30, 2009 were $1,694,592 and $74,244, respectively.  Total payroll and fringe benefit expenditures used to meet the cost sharing (matching) requirement of the CES program and Hatch Grant for the year ended June 30, 2009 were $11,027,702 and $15,354,139, respectively. No indirect costs were charged to the CES program or Hatch Grant.

 

            We did note that bi-weekly time reports are prepared for most employees.  However, these bi-weekly time reports, which are prepared on both a positive and negative (exception) basis depending on the type of employee, do not include the activities of the employee as required by OMB Circular A-21. 

 

            Our audit identified other controls and processes that the University has implemented to mitigate the risk that payroll costs are improperly charged to a federal program.  These include required reviews and approvals of the initial appointments of employees (i.e. allocation to federal and nonfederal projects) and monthly reviews by principal investigators (PI’s) of labor distribution reports and project ledgers.  However, the monthly review by principal investigators is not documented.

 

            Inadequate documentation and lack of required effort certifications may result in the federal funds being expended for unallowable purposes.  (Finding 5, Pages 29-32)

 

            We recommended the University implement procedures to ensure documentation exists to substantiate the after-the-fact confirmation of activity allocable to each federal grant and cost share by the respective employee, principal investigator, or a responsible official.

 

            University officials did not accept this finding. The University believes its systems provide sufficient documentation to meet the requirements for programmatic and financial reporting as outlined in the administrative manuals associated with these funding streams in addition to Circular A-21 requirements. 

 

            In an auditor’s comment, we noted that bi-weekly time reports do not include the activities of employees.  Although we acknowledge there are other controls and processes the University has implemented to mitigate the risk that payroll costs are improperly charged to a federal program, we believe the University is not in compliance with documentation requirements for payroll costs under OMB Circular A-21.

 

INADEQUATE PROCEDURES TO DETERMINE THE ALLOWABILITY OF COST SHARE EXPENDITURES

 

            The University does not have an adequate process in place to determine the allowability of certain expenditures used to meet the cost share (matching) requirement of the Supplemental Nutrition Program (SNAP).

 

            The University is required to meet a cost share requirement of approximately $8.1 million relative to the SNAP program.  The expenditures used to meet the SNAP cost share requirement include expenditures for teacher salaries made by public school districts at which nutrition education programs are presented.  The value of the expenditures made by the public school districts for teacher’s salaries are estimated by the University based upon an hourly rate derived from the average annual expenditure data reported by the public school district to the Illinois State Board of Education (ISBE).

 

            Specifically, the University computes hourly rates for each school district based upon average annual wage expenditures reported to ISBE and multiplies the applicable school district’s rate times the number of teacher hours documented by the school district and University personnel delivering the program.  However, in determining the estimate of the value of the time spent by the teachers in the educational programs, the University does not have sufficient documentation to ensure that teacher salaries being used to meet the SNAP cost share were not funded by other federal programs operated by the school district.

 

            We did note the University receives a certification at the beginning of the year from participating school districts stating that teachers participating in the SNAP educational programs will not be charged to another federal program.  However, there is no after-the-fact verification to substantiate that participating teacher salaries were not funded by other federal programs. 

 

            As a result, it is possible that the value of the teacher salaries used to meet the University’s cost share requirement under the SNAP program may also have been charged to another federal program or used to meet a cost share requirement of another federal program by the school district which is not allowable under SNAP program regulations.

 

            Teacher salary expenditures used to meet the cost sharing requirement of the SNAP program were $792,313 for the year ended June 30, 2009.

 

            Failure to ensure expenditures used to meet cost share requirements are not used for other federal programs may result in unallowable expenditures being used to meet cost share requirements.  (Finding 8, Pages 38-40)

 

            We recommended the University implement procedures to verify expenditures used to meet the SNAP cost share requirement have not been reimbursed under another federal program or used to meet the cost share requirement of another federal program.  In addition, the University should be using the actual wages for the teachers participating in the educational program.

 

            University officials did not accept this finding. The University stated that under this program, the mandatory cost-share is a one-to-one match of direct expenditures, not the $8.1 million matching requirement stated in the finding.

 

            The University also stated in their response that the UI Extension has procedures to verify that teacher salaries used as in-kind cost share are not directly reimbursed from any other federal source of funds.   The UI Extension offices require potential program contributors to submit Form A, Confirmation of Community In-Kind Cost Share Contributions.  This form, signed by contributors, states, “I confirm the Source of Funding for these contributions are NOT directly or indirectly from Federal Government or Private monies.”  The form provided by the school officials certifying the source of funding for the teacher salaries has been accepted by the sponsor as documentation supporting this portion of the required cost-share.

 

            In an auditor’s comment, we noted the Form A discussed above is obtained from potential program contributors in advance of the performance of the services (i.e. at the beginning of the program year).   There is no after-the-fact verification to substantiate that participating teacher salaries were not funded by other federal programs.  As a result, it is possible that the value of the teacher salaries used to meet the University’s cost share requirement under the SNAP program may also have been charged to another federal program or used to meet a cost share requirement of another federal program by the school district which is not allowable under SNAP program regulations.

 

            Additionally, the University computes hourly rates for each school district based upon average annual wage expenditures reported to ISBE, not the actual salary of the teachers that provided services under the SNAP program.  Accordingly, we do not believe there is an adequate process in place to determine the allowability of these expenditures used to meet the cost share (matching) requirement.

 

            Further, the grant agreement between IDHS and the University requires the University to provide matching expenditures (cost share) of $10,003,560 from non-federal sources over the term of the grant, which covers more than the current year.  Of this amount, an allocable portion for the current year based on a one-to-one ratio is $8.1 million.

 

UNSUPPORTED VOLUNTEER RATE USED FOR COST SHARE REQUIREMENT

 

            The University used an unsupported rate to value services of volunteers used to meet the cost share (matching) requirement of the SNAP Program.

 

            The University is required to meet a cost share requirement of approximately $8.1 million relative to the SNAP program.  The expenditures used to meet the cost share requirement are funded by several sources, including in-kind contributions from local governmental entities at which nutrition education programs are presented.  The in-kind contributions from the local governments include an estimated value for the time spent by volunteers who assist University personnel during the educational programs.

 

            The University has established an estimated hourly rate of $18.97 which is used to value the services of the volunteers.  Management stated the rate was based on an estimated dollar value of volunteer time published by a not-for-profit organization that was established to serve as a leadership forum for charities, foundations, and corporate giving programs.  Management further stated that volunteers were performing specialized tasks including materials translation, food preparation demonstrations, and the delivery of curriculum. 

 

            However, there was no documentation to substantiate what services each volunteer was performing and how it correlated to the hourly rate of $18.97.   As there is no documentation on the specific services provided by the volunteers and a clear link to specialized skills and corresponding values, we believe the minimum hourly wage rate of $6.55 (in effect during fiscal year 2009) should be used to value these services.  As a result, the contributed volunteer services could be overstated by as much as $111,146.

 

            Failure to appropriately value volunteer services may result in the University not meeting its cost share requirement.  (Finding 9, Pages 41-43)

 

            We recommended that the University implement procedures to ensure rates established to value volunteer services are consistent with the services being provided by the volunteer.

 

            University officials did not accept this finding. The University disagreed that the rate used for volunteer services is undocumented and disagreed that the federal minimum hourly wage rate is a more appropriate estimate of the value of these services.

 

                        The federal SNAP guidelines do not require that the rate used for costing volunteer activities be specifically approved.  Per the federal SNAP guidelines, the value of a volunteer’s time should be computed on a reasonable hourly basis in accordance with the duties being performed.  The volunteers are critical to the mission of the SNAP programs and perform specialized tasks including materials translation, food preparation demonstrations, and the delivery of curriculum, none of which are minimum wage tasks.  The University provided information indicating the volunteers provide highly specialized skills, serving as interpreters in classroom settings to assist Hispanic, Chinese, and Somalian students.  Using the minimum wage to cost these services would not properly reflect the true value of these services that are critical to the program.

 

            In an auditor’s comment we noted that although management made a general statement that volunteers performed specialized tasks, there is no documentation to substantiate what services were actually provided, nor is there a clear link to specialized skills and corresponding values for the services provided.

 

INADEQUATE PROCESS FOR PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS

 

            The University did not initially include all federal grants in the Schedule of Expenditures of Federal

Awards (SEFA).

 

            During our testwork of the SNAP program, we identified expenditures totaling $1,485,594 that were improperly excluded from the draft schedule of expenditures of federal awards for the year ended June 30, 2009.  Upon further review and investigation, management of the University identified 17 federal grants with net expenditures of $2,561,009 that were improperly excluded from the SEFA.  Management subsequently included these grants in the final version of the schedule of expenditures of federal awards that is included in this report.

 

            Failure to prepare a complete and accurate SEFA prevents the University from having an audit properly performed in accordance with OMB Circular A-133 which may result in the suspension of federal funding.  (Finding 12, Pages 51-52)

 

            We recommended that the University review the current process for preparing the schedule of expenditures of federal awards and implement changes necessary to ensure expenditures for all federal awards are properly reported.

 

            University officials accepted the recommendation and stated that the draft version of the SEFA submitted for review to the auditors in November 2009 contained omissions of items for which follow-up was necessary.  Due to personnel changes and human error, the follow-up was not completed until the final version of the SEFA intended for inclusion in the published FY09 Audit Report Package was provided to the audit firm.

 

INADEQUATE MONITORING OF SUBRECIPIENT OMB CIRCULAR A-133 AUDIT REPORTS

 

            The University is not adequately performing or documenting reviews of subrecipient OMB Circular A-133 audit reports.  Additionally, the Chicago campus does not have a system to track and follow-up with subrecipients when OMB Circular A-133 reports have not been received.

 

            The University requires subrecipients expending more than $500,000 in federal awards during their fiscal year to: (1) submit OMB Circular A-133 audit reports, or (2) provide written notification that an audit was conducted in accordance with OMB Circular A-133 and the schedule of findings and questioned costs disclosed no audit findings relating to the Federal awards that were pass-through the University (notification letter).

 

            University staff in the Office of Grants and Contracts are responsible for reviewing the OMB Circular A-133 audit reports and determining whether the audit reports meet the audit requirements of OMB Circular A-133, evaluating the type of audit opinion issued (i.e. unqualified, qualified, adverse), and issuing management decisions on findings reported within required timeframes.

 

            However, there is no documentation of the “desk reviews” performed, nor does management use a checklist to help determine whether the audit reports meet the audit requirements of OMB Circular A-133 and whether management decisions have been issued on findings reported within required timeframes.  Lastly, we noted the Chicago Campus does not have a process to track and follow-up with subrecipients when OMB Circular A-133 reports or notification letters have not been received.

 

            Additionally, during our testwork over 30 subrecipients of the Research and Development Cluster program, two subrecipients of the Foreign Language program, and three subrecipients of the AIDS program, we noted the following:

 

           There were three subrecipients of the Research and Development Cluster program and one subrecipient of the Foreign Language program for which a management decision was required, but was not issued by the University.

 

           There were four subrecipients of the Research and Development Cluster program and one subrecipient of the AIDS program for which no OMB Circular A-133 audit report was received.  In addition, these subrecipient files did not contain evidence that follow up procedures had been performed by the University to obtain the missing audit reports.

 

           There were 19 subrecipients of the Research and Development Cluster program, two subrecipients of the Foreign Language program, and one subrecipient of the AIDS program for which A-133 audit reports were submitted after the nine month filing deadline.  These files contained no documentation the University followed up on the delinquent report or approved an extension of the filing deadline. (Finding 18, Pages 70-72)

 

            We recommended that the University establish procedures to ensure all subrecipients receiving federal awards have audits performed in accordance with OMB Circular A-133 and that desk reviews of A-133 audit reports be formally documented using an A-133 desk review checklist and that management decisions be issued within six months.

 

            University officials accepted the recommendation and stated that they will implement procedures to strengthen oversight of subrecipient monitoring and follow-up activities.

 

 

INACCURATE QUARTERLY EXPENDITURE REPORTS PREPARED FOR THE SNAP PROGRAM

 

            The University did not accurately report federal expenditures in quarterly reports for the SNAP Program submitted to the Illinois Department of Human Services (IDHS).

 

            The University is required to prepare a quarterly expenditure report for the SNAP program which identifies the expenditures incurred to date under the federal award and used to meet the matching requirement.  The quarterly expenditure reports are used by IDHS to determine the amount to be reimbursed to the University (reported on the line item “Total IDHS Share”) and to monitor the University’s progress towards the matching requirement.

 

            During our testwork over the quarterly expenditure report submitted for the quarter ended December 31, 2008, we noted the University improperly reported the “Total IDHS Share” line item as half of the combined amounts of federal and matching expenditures.  As a result, the “Total IDHS Share” line item was overstated by $321,891 for the quarter ended December 31, 2008.  Upon review of the quarterly reports submitted during the University’s fiscal year, we noted the following differences in the amounts reported for the “Total IDHS Share line” item:

 

Quarter Ended             Amount Reported      Correct Amount        Difference

December 31, 2008             1,348,163                  1,026,272                321,891

March 31, 2009                   1,638,883                  1,374,579                264,304

June 30, 2009                      1,849,551                  2,435,745              (586,194)

 

            The University indicated that IDHS requested these amounts to be reported this way as the federal expenditures and matching expenditures all qualify for federal reimbursement; however, the matching expenditures include in-kind contributions from local governments which are not allowed to be reimbursed from federal sources. (Finding 21, Pages 77-78)

 

            We recommended that the University implement procedures to ensure that the quarterly expenditure reports accurately reflect the grantor’s share of expenditures.

 

            University officials did not accept this finding.  They stated that IDHS approved the University's billing and reporting methodology for the federal expenditures on this program.  Under this program, the mandatory cost-share is a one-to-one match of direct expenditures, not the $10 million matching requirement as stated in the finding.  The federal expenditures on this program are accurately reported; the data in the table for this finding is inaccurate because it does not follow the billing methodology approved by the funding agency, IDHS.

 

            In an auditor’s comment we stated that it is our belief that the report is inaccurate and results in the improper reimbursement of expenditures under the SNAP program.  Additionally, the grant agreement between IDHS and the University requires the University to provide matching expenditures (cost share) of $10,003,560 from non-federal sources over the term of the grant, which covers more than the current year.  Of this amount, an allocable portion for the current year based on a one-to-one ratio is $8.1 million.

 

FAILURE TO PROPERLY COMPLETE REQUIRED VERIFICATION PROCEDURES

 

            The University did not properly perform verification procedures for students at the Urbana campus.

 

            In order to validate the accuracy of information reported by applicants for financial aid, US Department of Education (USDE) requires schools participating in federal student financial assistance programs to perform procedures to verify the accuracy of student financial and household information used to compute the expected family contribution (EFC) of each applicant.  The EFC is used by the schools to determine the types and amounts of federal student financial aid each student is eligible to receive.  USDE selects students for verification and schools are required to establish and follow a verification policy that complies with the federal regulations.

 

            The University verifies the Institutional Student Information Records (ISIR) for all students selected by the USDE central processor at its Urbana and Springfield campuses and operates a quality assurance program at its Chicago campus.  As such, the financial aid system has been designed to place a hold flag on the student awards for all students selected by the central processor for verification at the Urbana and Springfield campuses and for students meeting the verification selection criteria established by the University at the Chicago campus.  The hold flag prevents disbursement of financial aid awards until the flag is manually removed by a financial aid counselor upon completion of the verification procedures.

 

            During our testwork over 85 students (45 from Urbana, 15 from Chicago, and 25 from Springfield) selected for verification, we noted certain exceptions at the Urbana Campus.  (Finding 25, pages 86-87)

 

            We recommended that the University implement additional procedures to ensure adequate supporting documentation is obtained and evaluated by financial aid counselors prior to disbursing federal funds to students selected for verification.

 

            University officials accepted the recommendation and stated that they will review and update procedures to ensure adequate supporting documentation is obtained and evaluated by financial aid staff prior to disbursing federal funds to students selected for verification. 

 

 

FAILURE TO NOTIFY SUBRECIPIENTS OF FEDERAL FUNDING

 

            The University did not provide required program information relative to federal funds passed through to the subrecipients of the Research and Development Cluster programs for the year ended June 30, 2009.

 

            During our testwork of 30 subrecipients who received $11,515,251 of the Research and Development Cluster program funds, we noted the University did not communicate the specific program name or CFDA number under which federal funding had been provided in grant award documents or in funding notification letters sent to subrecipients for four subrecipients of the Urbana campus and two subrecipients of the Chicago campus.  Subrecipient expenditures under the Research and Development Cluster program for the year ended June 30, 2009 were $52,770,488.

 

            Failure to inform subrecipients of federal award information could result in subrecipients improperly omitting expenditures from their schedule of expenditures of federal awards, expending federal funds for unallowable purposes, or not receiving a single audit in accordance with OMB Circular A-133. (Finding 30, Pages 96-97)

 

            We recommended that the University review its current process for preparing subrecipient funding notifications to ensure all required information is properly communicated to its subrecipients.

            University officials accepted the recommendation.

 

CONTRACTS AND REAL ESTATE LEASES NOT PROPERLY EXECUTED

 

            The University has not established adequate internal controls over contracts and leases to ensure they contain all necessary provisions and are properly executed prior to performance.

 

            During our review of forty two contracts executed during the year ended June 30, 2009, some of the items noted are as follows:

 

           13 contracts were executed subsequent to performance of the contract. The contract execution dates ranged from 15 days to 127 days after the beginning of the contract start date.

           17 contracts did not include the federal identification number for the vendor.

           1 contract did not include any of the required certifications.

 

            During our review of forty real estate leases executed during the year ended June 30, 2009, some of the items noted are as follows:

 

           17 leases were executed after the lease term began. The lease execution dates ranged from 2 days to 42 days after the beginning of the lease term.

           15 leases did not include the federal identification number for the lessor.

           36 leases did not include the Illinois Use Tax Certification. (Finding 35, Pages 111-112)

 

We recommend that the University establish appropriate procedures to ensure all contracts and leases are completed, approved, and executed prior to the start of the services and lease term. Further, the University should review procedures to ensure all appropriate clauses and certifications are obtained prior to execution for all contracts and lease agreements.

 

University officials accepted the recommendation and stated they will continue to examine and improve procedures to ensure contracts and leases are properly approved and executed prior to the start of the services and lease terms.

 

INADEQUATE PROCESS FOR ESTIMATING ALLOWANCE FOR DOUBTFUL ACCOUNTS RECEIVABLE

 

            The University has not established adequate internal controls over estimating and recording its allowance for doubtful patient accounts receivable (the allowance).

 

            During our audit, we noted the University’s procedures for estimating its allowance primarily consisted of applying a standard percentage to the outstanding balance of patient accounts receivable.  The standard percentage used was developed several years ago and has not been analyzed by management to determine if the percentage being used is consistent with current and historical payer data and trends.

 

            In addition, the accounts receivable aging analysis used by the University to estimate the allowance is based upon the most recent billing date for each patient, rather than the service date which results in the accounts receivable balances appearing to be more current than they are.  Finally, the University does not perform a retrospective analysis comparing the University’s prior year estimated allowance to actual collection experience.

 

            Patient accounts receivable approximated $70,864,000, net of an allowance of $250,081,000 at June 30, 2009. (Finding 37, Pages 116-117)

 

            We recommended that the University establish procedures (1) to estimate its allowance based on historical collection experience and current payer trends and (2) to assess the historical accuracy of its estimation process.  We also recommended that the aging analysis used to estimate the allowance be prepared based upon the date of service.

 

            University officials stated that the Medical Center will develop improvements to procedures to address the recommendations noted in this finding.

 

 

 

 

 

INACCURATE PHARMACEUTICAL INVENTORY VALUATION

 

            The University does not have an adequate process to measure and value pharmaceutical inventory balances as of fiscal year-end (i.e. balance sheet date).

 

            During our review of physical inventories, we noted the timing of five pharmaceutical physical inventories did not correspond to the University’s fiscal year-end of June 30th, ranging from 46 to 48 days before year-end.  Further, because the University does not maintain a perpetual inventory system for pharmaceutical inventories, the quantities used to measure the inventory as of the balance sheet date was the same as the quantity physically counted and was not adjusted for purchases or sales that occurred after the physical inventory but before the balance sheet date.

 

            We noted the following physical inventories did not correspond to the University’s fiscal year-end: 

 

Failure to record pharmaceutical inventories based on quantities on hand at year-end results in inventory balances being inaccurately reported in the University’s financial statements. (Finding 41, Pages 123-124)

 

            We recommended that the University review its process for performing pharmaceutical physical inventories and consider performing such procedures on or near the balance sheet date.

 

            University officials accepted the recommendation.

 

OTHER FINDINGS

 

            The remaining findings are reportedly being addressed by University management.  We will review the University’s progress toward the implementation of our recommendations in our next examination. 

 

AUDITORS’ OPINION

 

            The financial audit reports were previously released.  Our auditors stated the June 30, 2009 financial statements were fairly presented in all material respects.

 

 

WILLIAM G. HOLLAND, Auditor General

 

WGH:TLK:pp

 

SPECIAL ASSISTANT AUDITORS

 

KPMG were our special assistant auditors.