Audit 379448

Federal Program: Assistance Listing #’s 93.778, Medical Assistance Program, Passed Through Pennsylvania Department of Human Services, Pass-Through Entity Identifying Number: 13-1415MATP-4-2; 93.658, Foster Care Title IV-E, Passed Through Pennsylvania Department of Human Services, Pass-Through Entity Identifying Number: not available; 21.027, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds, U.S. Department of Treasury; 93.558, Temporary Assistance for Needy Families, Passed Through Pennsylvania Department of Labor and Industry, Pass-Through Entity Identifying Number: not available. Criteria: Pursuant to the provisions of the Uniform Guidance, under Section 200.512(a), the County is required to complete and submit its Single Audit and related Data Collection Form within nine months of the end of its fiscal period (September 30) of the following year. Condition/Context: The County's Single Audit and reporting package was delayed for the year ended December 31, 2022 beyond the nine-month due date. Effect: The County is not in compliance with certain requirements of the Uniform Guidance, including the Single Audit reporting requirements. Questioned Costs: None. Cause: Reconciliations and reports were not completed on a timely basis, and therefore, the completion and filing of its December 31, 2022 Single Audit and reporting package was not prioritized. Recommendation: We recommend that County management review its staffing and personnel responsibilities to prioritize the completion of its audit responsibilities within the prescribed timeframes. Views of Responsible Officials and Planned Corrective Actions: The County plans to have information ready for the auditors to get 2024 done in a reasonable time frame. This finding will likely carry to 2024 but between staffing and priorities, the County hopes to have cleared by the 2025 audit.

Federal Program: Assistance Listing #’s 93.778, Medical Assistance Program, Passed Through Pennsylvania Department of Human Services, Pass-Through Entity Identifying Number: 13-1415MATP-4-2; 93.658, Foster Care Title IV-E, Passed Through Pennsylvania Department of Human Services, Pass-Through Entity Identifying Number: not available; 21.027, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds, U.S. Department of Treasury; 93.558, Temporary Assistance for Needy Families, Passed Through Pennsylvania Department of Labor and Industry, Pass-Through Entity Identifying Number: not available. Criteria: The tracking and matching of grant revenues and expenditures and the related grant receivable and unearned revenue amounts is necessary to assist in making management decisions and for the proper reporting and use of those funds in accordance with each of the individual grant requirements. In addition, this information is essential in preparing the County's Schedule of Expenditures of Federal Awards (SEFA). Condition/Context: The County's system of tracking its grants and matching revenues with expenditures lacks the necessary level of sophistication, given the number and complexities of the County's grant activities, which hampers the County's ability to maintain an accurate general ledger and prepare a complete and accurate SEFA. The current year SEFA also required the restatement of beginning accrued revenue balances. Effect: Grants receivable and unearned revenue amounts are not readily ascertainable to assist in making management decisions or for use in the timely preparation of the County's SEFA. The County did not prepare a complete and accurate SEFA in a timely manner to comply with its financial reporting requirements. Cause: The County has not prioritized a formal system for tracking its grant activities. Recommendation: We recommend that the County develop and implement a formal system for tracking its grant related activities and in doing so require that all departments with responsibility for federal award programs provide periodic reconciliations of their grant reports to the general ledger to a responsible management official. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the restatement of the beginning accrued revenue balances on the SEFA and is working to realign staff responsibilities to provide a dedicated business office staff member to oversee, track, report and manage all of the County's grant awards.