Audit 25930

FY End
2022-12-31
Total Expended
$19.69M
Findings
6
Programs
31
Organization: County of Mercer (PA)
Year: 2022 Accepted: 2023-09-28

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
23218 2022-001 Significant Deficiency - L
23219 2022-001 Significant Deficiency - L
23220 2022-002 Material Weakness - L
599660 2022-001 Significant Deficiency - L
599661 2022-001 Significant Deficiency - L
599662 2022-002 Material Weakness - L

Programs

ALN Program Spent Major Findings
21.023 Covid-19 Emergency Rental Assistance Program $5.98M Yes 1
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $5.55M Yes 2
14.231 Covid-19 Emergency Solutions Grant Program $281,604 - 0
93.659 Adoption Assistance $221,565 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $181,217 - 0
93.563 Child Support Enforcement $173,161 - 0
93.958 Block Grants for Community Mental Health Services $156,047 - 0
93.558 Temporary Assistance for Needy Families $144,573 - 0
20.205 Highway Planning and Construction $119,907 - 0
97.042 Emergency Management Performance Grants $107,528 - 0
93.667 Social Services Block Grant $102,076 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $70,127 - 0
14.228 Covid-19 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $60,958 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $56,552 - 0
93.150 Projects for Assistance in Transition From Homelessness (path) $56,180 - 0
14.231 Emergency Solutions Grant Program $48,982 - 0
90.404 Hava Election Security Grants $48,243 - 0
16.034 Covid-19 Coronavirus Emergency Supplemental Funding Program $46,076 - 0
93.556 Mary Lee Allen Promoting Safe and Stable Families $43,485 - 0
84.181 Special Education-Grants for Infants and Families $36,206 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $35,161 - 0
93.658 Foster Care_title IV-E $31,673 Yes 0
97.029 Flood Mitigation Assistance $30,842 - 0
93.669 Child Abuse and Neglect State Grants $27,953 - 0
15.226 Payments in Lieu of Taxes $27,675 - 0
10.568 Emergency Food Assistance Program (administrative Costs) $17,230 - 0
12.112 Payments to States in Lieu of Real Estate Taxes $8,947 - 0
15.611 Wildlife Restoration and Basic Hunter Education $2,911 - 0
93.556 Promoting Safe and Stable Families $2,652 - 0
93.090 Guardianship Assistance $67 - 0
93.778 Medical Assistance Program $18 Yes 0

Contacts

Name Title Type
HL5TPLAPER14 Lee Ann Sok Auditee
7246627540 Michelle L. Bryan Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: The accompanying Schedule is presented using the modified accrual basis of accounting. Expenditures are recognized following the cost principles contained in the Uniform Guidance. Negative amounts shown on the Schedule represent adjustment or credits made in the normal course of business to amounts reported as expenditures in prior years. Cash receipts are shown on the Schedule on the cash basis of accounting, as required by the various Commonwealth of Pennsylvania pass-through agencies. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The accompanying schedule of expenditures of federal awards (Schedule) includes the federal award activity of the County of Mercer (County) under programs of the federal government for the year ended December 31, 2022. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the County, it is not intended to and does not present the financial position or changes in net position of the County.
Title: Emergency Food Assistance Program Accounting Policies: The accompanying Schedule is presented using the modified accrual basis of accounting. Expenditures are recognized following the cost principles contained in the Uniform Guidance. Negative amounts shown on the Schedule represent adjustment or credits made in the normal course of business to amounts reported as expenditures in prior years. Cash receipts are shown on the Schedule on the cash basis of accounting, as required by the various Commonwealth of Pennsylvania pass-through agencies. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. In-kind values are reported in the Schedule at the fair value of the commodities received and disbursed.

Finding Details

Finding 2022-001 ? Internal Control over Financial Reporting and Account Adjustments Condition: Internal controls were not in place to ensure accuracy of financial statements, which resulted in material adjustments that were identified by the auditors in order for the financial statements to be prepared in accordance with accounting principles generally accepted in the United States of America (GAAP). Adjustments were identified as being required based on the auditor?s review of the trial balance information provided for audit. Adjustments identified to management included: recording of intergovernmental revenues, balancing of interfund transactions, accruing accounts payable, recording of taxes receivable, and balancing pension funds. Material adjustments noted include those required to major federal programs Emergency Rental Assistance Program (ALN 21.023) and Coronavirus State and Local Fiscal Recovery Funds (ALN 21.027). These adjustments were necessary to properly reflect current year operations and balances as of the year-end. Management does review and accept the financial statements prior to their final issuance, and adjustments required were provided to the auditors based on preliminary identification by the auditors and subsequent discussions with management. Criteria: Auditing standards place emphasis on determining an entity?s ability to fully prepare their own external financial statements, including the posting of all adjustments necessary to present GAAP financials and evaluating the need for all necessary financial statement disclosures. Reliance on auditors to ensure comprehensive financial reporting is considered to be an internal control deficiency. Cause: Internal controls were not in place to ensure that the County of Mercer (County) reconciled some of its balance sheet accounts, including interfund accounts, accounts payable, unearned revenues, taxes receivable, and pension accounts, to the general ledger and did not post necessary adjustments for balances to be recorded in accordance with GAAP. Effect: Significant adjustments were required to be recorded in order for the financial statements to be prepared in accordance with GAAP. Recommendation: We recommend that management evaluate their internal controls over the financial reporting process and ensure that an individual is assigned to reconcile balance sheet accounts on a monthly, quarterly, and annual basis. We also recommend that a second individual be assigned to review the reconciliations and ensure that the financial statements are prepared in accordance with GAAP. Management?s Response: Management agrees with this finding. See separate Corrective Action Plan.
Finding 2022-001 ? Internal Control over Financial Reporting and Account Adjustments Condition: Internal controls were not in place to ensure accuracy of financial statements, which resulted in material adjustments that were identified by the auditors in order for the financial statements to be prepared in accordance with accounting principles generally accepted in the United States of America (GAAP). Adjustments were identified as being required based on the auditor?s review of the trial balance information provided for audit. Adjustments identified to management included: recording of intergovernmental revenues, balancing of interfund transactions, accruing accounts payable, recording of taxes receivable, and balancing pension funds. Material adjustments noted include those required to major federal programs Emergency Rental Assistance Program (ALN 21.023) and Coronavirus State and Local Fiscal Recovery Funds (ALN 21.027). These adjustments were necessary to properly reflect current year operations and balances as of the year-end. Management does review and accept the financial statements prior to their final issuance, and adjustments required were provided to the auditors based on preliminary identification by the auditors and subsequent discussions with management. Criteria: Auditing standards place emphasis on determining an entity?s ability to fully prepare their own external financial statements, including the posting of all adjustments necessary to present GAAP financials and evaluating the need for all necessary financial statement disclosures. Reliance on auditors to ensure comprehensive financial reporting is considered to be an internal control deficiency. Cause: Internal controls were not in place to ensure that the County of Mercer (County) reconciled some of its balance sheet accounts, including interfund accounts, accounts payable, unearned revenues, taxes receivable, and pension accounts, to the general ledger and did not post necessary adjustments for balances to be recorded in accordance with GAAP. Effect: Significant adjustments were required to be recorded in order for the financial statements to be prepared in accordance with GAAP. Recommendation: We recommend that management evaluate their internal controls over the financial reporting process and ensure that an individual is assigned to reconcile balance sheet accounts on a monthly, quarterly, and annual basis. We also recommend that a second individual be assigned to review the reconciliations and ensure that the financial statements are prepared in accordance with GAAP. Management?s Response: Management agrees with this finding. See separate Corrective Action Plan.
Finding 2022-002 ? Reporting U.S. Department of Treasury COVID-19 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) ? ALN 21.027 Reporting Condition: The internal control system to ensure that the Project and Expenditure Report submitted to Treasury was accurate was not operating effectively. The County reported expenses on the fourth quarter report that had already been included on previous reports. In addition, the County elected to not apply expenditures related to a project to the CSLFRF funds for approximately $720,000 that were previously reported to Treasury as a use of these funds. Criteria: Quarterly reports are required to be accurate and include all activity of the reporting period, supported by the applicable accounting records and fairly presented in accordance with Treasury requirements. The reports are to include the current period expenditures, as well as the cumulative expenditures related to the projects. Cause: Internal controls in place to ensure that the quarterly reports were completed accurately were not adequate. Effect: The quarterly reports submitted to Treasury do not contain information supported by the accounting records of the County. Questioned Costs: Unknown. Identification as a Repeat Finding: This is not a repeat finding from the prior audit. Recommendation: We recommend the County implement a procedure to ensure that all required quarterly reports are completed accurately and verify that the cumulative expenditures agree to the previously submitted quarterly current period expenditures. In addition, we recommend that the County ensure proper correction of previously submitted reports. Management?s Response: Management agrees with this finding. See separate Corrective Action Plan.
Finding 2022-001 ? Internal Control over Financial Reporting and Account Adjustments Condition: Internal controls were not in place to ensure accuracy of financial statements, which resulted in material adjustments that were identified by the auditors in order for the financial statements to be prepared in accordance with accounting principles generally accepted in the United States of America (GAAP). Adjustments were identified as being required based on the auditor?s review of the trial balance information provided for audit. Adjustments identified to management included: recording of intergovernmental revenues, balancing of interfund transactions, accruing accounts payable, recording of taxes receivable, and balancing pension funds. Material adjustments noted include those required to major federal programs Emergency Rental Assistance Program (ALN 21.023) and Coronavirus State and Local Fiscal Recovery Funds (ALN 21.027). These adjustments were necessary to properly reflect current year operations and balances as of the year-end. Management does review and accept the financial statements prior to their final issuance, and adjustments required were provided to the auditors based on preliminary identification by the auditors and subsequent discussions with management. Criteria: Auditing standards place emphasis on determining an entity?s ability to fully prepare their own external financial statements, including the posting of all adjustments necessary to present GAAP financials and evaluating the need for all necessary financial statement disclosures. Reliance on auditors to ensure comprehensive financial reporting is considered to be an internal control deficiency. Cause: Internal controls were not in place to ensure that the County of Mercer (County) reconciled some of its balance sheet accounts, including interfund accounts, accounts payable, unearned revenues, taxes receivable, and pension accounts, to the general ledger and did not post necessary adjustments for balances to be recorded in accordance with GAAP. Effect: Significant adjustments were required to be recorded in order for the financial statements to be prepared in accordance with GAAP. Recommendation: We recommend that management evaluate their internal controls over the financial reporting process and ensure that an individual is assigned to reconcile balance sheet accounts on a monthly, quarterly, and annual basis. We also recommend that a second individual be assigned to review the reconciliations and ensure that the financial statements are prepared in accordance with GAAP. Management?s Response: Management agrees with this finding. See separate Corrective Action Plan.
Finding 2022-001 ? Internal Control over Financial Reporting and Account Adjustments Condition: Internal controls were not in place to ensure accuracy of financial statements, which resulted in material adjustments that were identified by the auditors in order for the financial statements to be prepared in accordance with accounting principles generally accepted in the United States of America (GAAP). Adjustments were identified as being required based on the auditor?s review of the trial balance information provided for audit. Adjustments identified to management included: recording of intergovernmental revenues, balancing of interfund transactions, accruing accounts payable, recording of taxes receivable, and balancing pension funds. Material adjustments noted include those required to major federal programs Emergency Rental Assistance Program (ALN 21.023) and Coronavirus State and Local Fiscal Recovery Funds (ALN 21.027). These adjustments were necessary to properly reflect current year operations and balances as of the year-end. Management does review and accept the financial statements prior to their final issuance, and adjustments required were provided to the auditors based on preliminary identification by the auditors and subsequent discussions with management. Criteria: Auditing standards place emphasis on determining an entity?s ability to fully prepare their own external financial statements, including the posting of all adjustments necessary to present GAAP financials and evaluating the need for all necessary financial statement disclosures. Reliance on auditors to ensure comprehensive financial reporting is considered to be an internal control deficiency. Cause: Internal controls were not in place to ensure that the County of Mercer (County) reconciled some of its balance sheet accounts, including interfund accounts, accounts payable, unearned revenues, taxes receivable, and pension accounts, to the general ledger and did not post necessary adjustments for balances to be recorded in accordance with GAAP. Effect: Significant adjustments were required to be recorded in order for the financial statements to be prepared in accordance with GAAP. Recommendation: We recommend that management evaluate their internal controls over the financial reporting process and ensure that an individual is assigned to reconcile balance sheet accounts on a monthly, quarterly, and annual basis. We also recommend that a second individual be assigned to review the reconciliations and ensure that the financial statements are prepared in accordance with GAAP. Management?s Response: Management agrees with this finding. See separate Corrective Action Plan.
Finding 2022-002 ? Reporting U.S. Department of Treasury COVID-19 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) ? ALN 21.027 Reporting Condition: The internal control system to ensure that the Project and Expenditure Report submitted to Treasury was accurate was not operating effectively. The County reported expenses on the fourth quarter report that had already been included on previous reports. In addition, the County elected to not apply expenditures related to a project to the CSLFRF funds for approximately $720,000 that were previously reported to Treasury as a use of these funds. Criteria: Quarterly reports are required to be accurate and include all activity of the reporting period, supported by the applicable accounting records and fairly presented in accordance with Treasury requirements. The reports are to include the current period expenditures, as well as the cumulative expenditures related to the projects. Cause: Internal controls in place to ensure that the quarterly reports were completed accurately were not adequate. Effect: The quarterly reports submitted to Treasury do not contain information supported by the accounting records of the County. Questioned Costs: Unknown. Identification as a Repeat Finding: This is not a repeat finding from the prior audit. Recommendation: We recommend the County implement a procedure to ensure that all required quarterly reports are completed accurately and verify that the cumulative expenditures agree to the previously submitted quarterly current period expenditures. In addition, we recommend that the County ensure proper correction of previously submitted reports. Management?s Response: Management agrees with this finding. See separate Corrective Action Plan.