Audit 320312

FY End
2023-12-31
Total Expended
$25.58M
Findings
12
Programs
44
Year: 2023 Accepted: 2024-09-23

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
497551 2023-001 Significant Deficiency - L
497552 2023-001 Significant Deficiency - L
497553 2023-001 Significant Deficiency - L
497554 2023-001 Significant Deficiency - L
497555 2023-001 Significant Deficiency - L
497556 2023-001 Significant Deficiency - L
1073993 2023-001 Significant Deficiency - L
1073994 2023-001 Significant Deficiency - L
1073995 2023-001 Significant Deficiency - L
1073996 2023-001 Significant Deficiency - L
1073997 2023-001 Significant Deficiency - L
1073998 2023-001 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $14.67M Yes 0
21.023 Emergency Rental Assistance Program $1.42M Yes 0
93.563 Child Support Enforcement $1.31M - 0
93.659 Adoption Assistance $1.11M - 0
93.658 Foster Care_title IV-E $967,715 Yes 0
14.267 Continuum of Care Program $358,047 - 0
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $354,136 Yes 1
20.205 Highway Planning and Construction $305,144 - 0
93.558 Temporary Assistance for Needy Families $254,272 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $192,413 - 0
10.569 Emergency Food Assistance Program (food Commodities) $164,489 - 0
93.090 Guardianship Assistance $141,567 - 0
93.556 Promoting Safe and Stable Families $137,921 - 0
93.788 Opioid Str $128,362 Yes 0
16.585 Drug Court Discretionary Grant Program $127,694 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $107,459 - 0
21.032 Local Assistance and Tribal Consistency Fund $100,000 - 0
84.181 Special Education-Grants for Infants and Families $95,119 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $89,555 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $83,564 Yes 1
93.667 Social Services Block Grant $77,116 - 0
97.042 Emergency Management Performance Grants $72,714 - 0
10.568 Emergency Food Assistance Program (administrative Costs) $63,631 - 0
93.053 Nutrition Services Incentive Program $50,046 Yes 1
14.231 Emergency Solutions Grant Program $47,981 - 0
93.150 Projects for Assistance in Transition From Homelessness (path) $45,949 - 0
16.588 Violence Against Women Formula Grants $41,284 - 0
93.472 Title IV-E Prevention and Family Services and Programs (a) $38,041 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $32,162 - 0
16.812 Second Chance Act Reentry Initiative $24,139 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $21,111 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $19,029 - 0
93.042 Special Programs for the Aging_title Vii, Chapter 2_long Term Care Ombudsman Services for Older Individuals $18,511 - 0
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $12,689 - 0
93.778 Medical Assistance Program $10,996 - 0
93.669 Child Abuse and Neglect State Grants $9,543 - 0
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $6,736 - 0
97.067 Homeland Security Grant Program $6,191 - 0
93.324 State Health Insurance Assistance Program $5,751 - 0
93.958 Block Grants for Community Mental Health Services $5,672 - 0
93.071 Medicare Enrollment Assistance Program $5,441 - 0
93.041 Special Programs for the Aging_title Vii, Chapter 3_programs for Prevention of Elder Abuse, Neglect, and Exploitation $2,344 - 0
16.593 Residential Substance Abuse Treatment for State Prisoners $0 - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $0 - 0

Contacts

Name Title Type
MNU2SG7YJNC5 Teresa Beckner Auditee
7172613105 Cory Johnson Auditor
No contacts on file

Notes to SEFA

Title: REPORTING ENTITY Accounting Policies: The accompanying schedule of expenditures of federal awards is presented using the modified accrual basis of accounting, which is described in Note 1 to the County's financial statements. De Minimis Rate Used: N Rate Explanation: The County did not use the 10% de minimis indirect cost rate. The COUNTY OF FRANKLIN, PENNSYLVANIA (the "County") as the reporting entity for financial reporting purposes is defined in Note 1 to the County's financial statements. For purposes of preparing the schedule of expenditures of federal awards, the County's reporting entity differs from that used for financial purposes, in that awards received and expended, if any, by the following entities are excluded: - Franklin County Industrial Development Authority - Tuscarora Managed Care Alliance - Franklin County Conservation District - Franklin County Redevelopment Authority - Letterkenny Industrial Development Authority Direct awards pertaining to these entities have been excluded from the accompanying schedules principally because the County is not directly involved in maintaining the accounting records or systems of internal accounting and administrative controls for these entities. Where applicable, these entities have arranged for the issuance of separate Single Audit Reports containing their audited financial statements and schedule of expenditures of federal awards and all required audit reports. Except as indicated above, the accompanying schedule of expenditures of federal awards presents the activity of all federal award programs of the County.
Title: BASIS OF ACCOUNTING Accounting Policies: The accompanying schedule of expenditures of federal awards is presented using the modified accrual basis of accounting, which is described in Note 1 to the County's financial statements. De Minimis Rate Used: N Rate Explanation: The County did not use the 10% de minimis indirect cost rate. The accompanying schedule of expenditures of federal awards is presented using the modified accrual basis of accounting, which is described in Note 1 to the County's financial statements. The County did not use the 10% de minimis indirect cost rate.
Title: RISK-BASED AUDIT APPROACH Accounting Policies: The accompanying schedule of expenditures of federal awards is presented using the modified accrual basis of accounting, which is described in Note 1 to the County's financial statements. De Minimis Rate Used: N Rate Explanation: The County did not use the 10% de minimis indirect cost rate. The 2023 threshold for determining Type A and Type B Programs was $767,420. The following Type A programs were audited as major: AL Number Program 21.023 Emergency Rental Assistance Program 21.027 Coronavirus State and Local Fiscal Recovery Funds 93.044/93.045/93.053 Aging Cluster 93.658 Foster Care Title IV-E 93.788 Opioid STR/SOR The following high risk Type B program was audited as major: AL Number Program None None The amount expended under programs audited as major federal programs for the year ended December 31, 2023, totaled $19,026,134 or 74.38% of total federal awards.

Finding Details

AL Number 93.044/93.045/93.053 Aging Cluster Criteria: Pursuant to 2 CFR Section 208328, the awarding agency must collect financial information, and 2 CFR Part 200, Subpart F requires auditors to obtain an understanding of the non-federal entity's internal control over federal programs sufficient to plan the audit to support a low assessed level of control risk for major programs, plan the testing of internal control over major programs to support a low assessed level of control risk for the assertions relevant to the compliance requirements for each major program, and perform testing of internal control as planned. Condition: For the aging Cluster reports tested, ZA was unable to determine whether the reports submitted were reviewed and approved. Cause: The County's internal control procedures to ensure compliance with Reporting requirements were not operating as designed. Effect: The County’s controls over Reporting were not operating effectively. Questioned Costs: None. Recommendation: The County should ensure that all program reports are properly approved prior to submission. Management's Response: Management agrees with the finding and is implementing procedures to correct it. Applicable staff will be briefed on the finding and training will be provided on both written policy and procedure. The County has a quality assurance program to monitor and ensure all reports are reviewed prior to submission.
AL Number 93.044/93.045/93.053 Aging Cluster Criteria: Pursuant to 2 CFR Section 208328, the awarding agency must collect financial information, and 2 CFR Part 200, Subpart F requires auditors to obtain an understanding of the non-federal entity's internal control over federal programs sufficient to plan the audit to support a low assessed level of control risk for major programs, plan the testing of internal control over major programs to support a low assessed level of control risk for the assertions relevant to the compliance requirements for each major program, and perform testing of internal control as planned. Condition: For the aging Cluster reports tested, ZA was unable to determine whether the reports submitted were reviewed and approved. Cause: The County's internal control procedures to ensure compliance with Reporting requirements were not operating as designed. Effect: The County’s controls over Reporting were not operating effectively. Questioned Costs: None. Recommendation: The County should ensure that all program reports are properly approved prior to submission. Management's Response: Management agrees with the finding and is implementing procedures to correct it. Applicable staff will be briefed on the finding and training will be provided on both written policy and procedure. The County has a quality assurance program to monitor and ensure all reports are reviewed prior to submission.
AL Number 93.044/93.045/93.053 Aging Cluster Criteria: Pursuant to 2 CFR Section 208328, the awarding agency must collect financial information, and 2 CFR Part 200, Subpart F requires auditors to obtain an understanding of the non-federal entity's internal control over federal programs sufficient to plan the audit to support a low assessed level of control risk for major programs, plan the testing of internal control over major programs to support a low assessed level of control risk for the assertions relevant to the compliance requirements for each major program, and perform testing of internal control as planned. Condition: For the aging Cluster reports tested, ZA was unable to determine whether the reports submitted were reviewed and approved. Cause: The County's internal control procedures to ensure compliance with Reporting requirements were not operating as designed. Effect: The County’s controls over Reporting were not operating effectively. Questioned Costs: None. Recommendation: The County should ensure that all program reports are properly approved prior to submission. Management's Response: Management agrees with the finding and is implementing procedures to correct it. Applicable staff will be briefed on the finding and training will be provided on both written policy and procedure. The County has a quality assurance program to monitor and ensure all reports are reviewed prior to submission.
AL Number 93.044/93.045/93.053 Aging Cluster Criteria: Pursuant to 2 CFR Section 208328, the awarding agency must collect financial information, and 2 CFR Part 200, Subpart F requires auditors to obtain an understanding of the non-federal entity's internal control over federal programs sufficient to plan the audit to support a low assessed level of control risk for major programs, plan the testing of internal control over major programs to support a low assessed level of control risk for the assertions relevant to the compliance requirements for each major program, and perform testing of internal control as planned. Condition: For the aging Cluster reports tested, ZA was unable to determine whether the reports submitted were reviewed and approved. Cause: The County's internal control procedures to ensure compliance with Reporting requirements were not operating as designed. Effect: The County’s controls over Reporting were not operating effectively. Questioned Costs: None. Recommendation: The County should ensure that all program reports are properly approved prior to submission. Management's Response: Management agrees with the finding and is implementing procedures to correct it. Applicable staff will be briefed on the finding and training will be provided on both written policy and procedure. The County has a quality assurance program to monitor and ensure all reports are reviewed prior to submission.
AL Number 93.044/93.045/93.053 Aging Cluster Criteria: Pursuant to 2 CFR Section 208328, the awarding agency must collect financial information, and 2 CFR Part 200, Subpart F requires auditors to obtain an understanding of the non-federal entity's internal control over federal programs sufficient to plan the audit to support a low assessed level of control risk for major programs, plan the testing of internal control over major programs to support a low assessed level of control risk for the assertions relevant to the compliance requirements for each major program, and perform testing of internal control as planned. Condition: For the aging Cluster reports tested, ZA was unable to determine whether the reports submitted were reviewed and approved. Cause: The County's internal control procedures to ensure compliance with Reporting requirements were not operating as designed. Effect: The County’s controls over Reporting were not operating effectively. Questioned Costs: None. Recommendation: The County should ensure that all program reports are properly approved prior to submission. Management's Response: Management agrees with the finding and is implementing procedures to correct it. Applicable staff will be briefed on the finding and training will be provided on both written policy and procedure. The County has a quality assurance program to monitor and ensure all reports are reviewed prior to submission.
AL Number 93.044/93.045/93.053 Aging Cluster Criteria: Pursuant to 2 CFR Section 208328, the awarding agency must collect financial information, and 2 CFR Part 200, Subpart F requires auditors to obtain an understanding of the non-federal entity's internal control over federal programs sufficient to plan the audit to support a low assessed level of control risk for major programs, plan the testing of internal control over major programs to support a low assessed level of control risk for the assertions relevant to the compliance requirements for each major program, and perform testing of internal control as planned. Condition: For the aging Cluster reports tested, ZA was unable to determine whether the reports submitted were reviewed and approved. Cause: The County's internal control procedures to ensure compliance with Reporting requirements were not operating as designed. Effect: The County’s controls over Reporting were not operating effectively. Questioned Costs: None. Recommendation: The County should ensure that all program reports are properly approved prior to submission. Management's Response: Management agrees with the finding and is implementing procedures to correct it. Applicable staff will be briefed on the finding and training will be provided on both written policy and procedure. The County has a quality assurance program to monitor and ensure all reports are reviewed prior to submission.
AL Number 93.044/93.045/93.053 Aging Cluster Criteria: Pursuant to 2 CFR Section 208328, the awarding agency must collect financial information, and 2 CFR Part 200, Subpart F requires auditors to obtain an understanding of the non-federal entity's internal control over federal programs sufficient to plan the audit to support a low assessed level of control risk for major programs, plan the testing of internal control over major programs to support a low assessed level of control risk for the assertions relevant to the compliance requirements for each major program, and perform testing of internal control as planned. Condition: For the aging Cluster reports tested, ZA was unable to determine whether the reports submitted were reviewed and approved. Cause: The County's internal control procedures to ensure compliance with Reporting requirements were not operating as designed. Effect: The County’s controls over Reporting were not operating effectively. Questioned Costs: None. Recommendation: The County should ensure that all program reports are properly approved prior to submission. Management's Response: Management agrees with the finding and is implementing procedures to correct it. Applicable staff will be briefed on the finding and training will be provided on both written policy and procedure. The County has a quality assurance program to monitor and ensure all reports are reviewed prior to submission.
AL Number 93.044/93.045/93.053 Aging Cluster Criteria: Pursuant to 2 CFR Section 208328, the awarding agency must collect financial information, and 2 CFR Part 200, Subpart F requires auditors to obtain an understanding of the non-federal entity's internal control over federal programs sufficient to plan the audit to support a low assessed level of control risk for major programs, plan the testing of internal control over major programs to support a low assessed level of control risk for the assertions relevant to the compliance requirements for each major program, and perform testing of internal control as planned. Condition: For the aging Cluster reports tested, ZA was unable to determine whether the reports submitted were reviewed and approved. Cause: The County's internal control procedures to ensure compliance with Reporting requirements were not operating as designed. Effect: The County’s controls over Reporting were not operating effectively. Questioned Costs: None. Recommendation: The County should ensure that all program reports are properly approved prior to submission. Management's Response: Management agrees with the finding and is implementing procedures to correct it. Applicable staff will be briefed on the finding and training will be provided on both written policy and procedure. The County has a quality assurance program to monitor and ensure all reports are reviewed prior to submission.
AL Number 93.044/93.045/93.053 Aging Cluster Criteria: Pursuant to 2 CFR Section 208328, the awarding agency must collect financial information, and 2 CFR Part 200, Subpart F requires auditors to obtain an understanding of the non-federal entity's internal control over federal programs sufficient to plan the audit to support a low assessed level of control risk for major programs, plan the testing of internal control over major programs to support a low assessed level of control risk for the assertions relevant to the compliance requirements for each major program, and perform testing of internal control as planned. Condition: For the aging Cluster reports tested, ZA was unable to determine whether the reports submitted were reviewed and approved. Cause: The County's internal control procedures to ensure compliance with Reporting requirements were not operating as designed. Effect: The County’s controls over Reporting were not operating effectively. Questioned Costs: None. Recommendation: The County should ensure that all program reports are properly approved prior to submission. Management's Response: Management agrees with the finding and is implementing procedures to correct it. Applicable staff will be briefed on the finding and training will be provided on both written policy and procedure. The County has a quality assurance program to monitor and ensure all reports are reviewed prior to submission.
AL Number 93.044/93.045/93.053 Aging Cluster Criteria: Pursuant to 2 CFR Section 208328, the awarding agency must collect financial information, and 2 CFR Part 200, Subpart F requires auditors to obtain an understanding of the non-federal entity's internal control over federal programs sufficient to plan the audit to support a low assessed level of control risk for major programs, plan the testing of internal control over major programs to support a low assessed level of control risk for the assertions relevant to the compliance requirements for each major program, and perform testing of internal control as planned. Condition: For the aging Cluster reports tested, ZA was unable to determine whether the reports submitted were reviewed and approved. Cause: The County's internal control procedures to ensure compliance with Reporting requirements were not operating as designed. Effect: The County’s controls over Reporting were not operating effectively. Questioned Costs: None. Recommendation: The County should ensure that all program reports are properly approved prior to submission. Management's Response: Management agrees with the finding and is implementing procedures to correct it. Applicable staff will be briefed on the finding and training will be provided on both written policy and procedure. The County has a quality assurance program to monitor and ensure all reports are reviewed prior to submission.
AL Number 93.044/93.045/93.053 Aging Cluster Criteria: Pursuant to 2 CFR Section 208328, the awarding agency must collect financial information, and 2 CFR Part 200, Subpart F requires auditors to obtain an understanding of the non-federal entity's internal control over federal programs sufficient to plan the audit to support a low assessed level of control risk for major programs, plan the testing of internal control over major programs to support a low assessed level of control risk for the assertions relevant to the compliance requirements for each major program, and perform testing of internal control as planned. Condition: For the aging Cluster reports tested, ZA was unable to determine whether the reports submitted were reviewed and approved. Cause: The County's internal control procedures to ensure compliance with Reporting requirements were not operating as designed. Effect: The County’s controls over Reporting were not operating effectively. Questioned Costs: None. Recommendation: The County should ensure that all program reports are properly approved prior to submission. Management's Response: Management agrees with the finding and is implementing procedures to correct it. Applicable staff will be briefed on the finding and training will be provided on both written policy and procedure. The County has a quality assurance program to monitor and ensure all reports are reviewed prior to submission.
AL Number 93.044/93.045/93.053 Aging Cluster Criteria: Pursuant to 2 CFR Section 208328, the awarding agency must collect financial information, and 2 CFR Part 200, Subpart F requires auditors to obtain an understanding of the non-federal entity's internal control over federal programs sufficient to plan the audit to support a low assessed level of control risk for major programs, plan the testing of internal control over major programs to support a low assessed level of control risk for the assertions relevant to the compliance requirements for each major program, and perform testing of internal control as planned. Condition: For the aging Cluster reports tested, ZA was unable to determine whether the reports submitted were reviewed and approved. Cause: The County's internal control procedures to ensure compliance with Reporting requirements were not operating as designed. Effect: The County’s controls over Reporting were not operating effectively. Questioned Costs: None. Recommendation: The County should ensure that all program reports are properly approved prior to submission. Management's Response: Management agrees with the finding and is implementing procedures to correct it. Applicable staff will be briefed on the finding and training will be provided on both written policy and procedure. The County has a quality assurance program to monitor and ensure all reports are reviewed prior to submission.