Audit 363050

FY End
2024-12-31
Total Expended
$6.45M
Findings
18
Programs
27
Organization: Bay County (MI)
Year: 2024 Accepted: 2025-07-25

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
571953 2024-001 Significant Deficiency - L
571954 2024-001 Significant Deficiency - L
571955 2024-001 Significant Deficiency - L
571956 2024-001 Significant Deficiency - L
571957 2024-001 Significant Deficiency - L
571958 2024-001 Significant Deficiency - L
571959 2024-001 Significant Deficiency - L
571960 2024-001 Significant Deficiency - L
571961 2024-001 Significant Deficiency - L
1148395 2024-001 Significant Deficiency - L
1148396 2024-001 Significant Deficiency - L
1148397 2024-001 Significant Deficiency - L
1148398 2024-001 Significant Deficiency - L
1148399 2024-001 Significant Deficiency - L
1148400 2024-001 Significant Deficiency - L
1148401 2024-001 Significant Deficiency - L
1148402 2024-001 Significant Deficiency - L
1148403 2024-001 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
20.205 Highway Planning and Construction $38,873 - 0
93.217 Family Planning Services $31,995 - 0
93.069 Public Health Emergency Preparedness $30,741 - 0
93.493 Congressional Directives $30,225 - 0
93.563 Child Support Services $29,557 Yes 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $27,500 - 0
93.044 Special Programs for the Aging, Title Iii, Part B, Grants for Supportive Services and Senior Centers $27,306 - 0
16.753 Congressionally Recommended Awards $16,195 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $16,189 - 0
93.994 Maternal and Child Health Services Block Grant to the States $15,228 - 0
66.802 Superfund State, Political Subdivision, and Indian Tribe Site-Specific Cooperative Agreements $14,427 - 0
93.778 Medical Assistance Program $13,364 - 0
93.658 Foster Care Title IV-E $10,859 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $10,110 - 0
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $9,483 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $8,990 Yes 1
20.600 State and Community Highway Safety $7,843 - 0
10.553 School Breakfast Program $7,642 - 0
93.045 Special Programs for the Aging, Title Iii, Part C, Nutrition Services $7,176 - 0
10.555 National School Lunch Program $5,047 - 0
20.616 National Priority Safety Programs $4,747 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $2,789 - 0
97.042 Emergency Management Performance Grants $2,407 - 0
93.268 Immunization Cooperative Agreements $1,200 - 0
93.597 Grants to States for Access and Visitation Programs $660 - 0
97.067 Homeland Security Grant Program $400 - 0
93.053 Nutrition Services Incentive Program $98 - 0

Contacts

Name Title Type
LDALV3368274 Scott Trepkowski Auditee
9898954030 Doug Deeter Auditor
No contacts on file

Notes to SEFA

Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of Bay County, Michigan (the “County”) under programs of the federal government for the year ended December 31, 2024. 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, changes in net position or cash flows of the County. De Minimis Rate Used: N Rate Explanation: For purposes of charging indirect costs to federal awards, the County has elected not to use the 10 percent de minimis cost rate as permitted by §200.414 of the Uniform Guidance.

Finding Details

Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027 (all). Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported in all quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2024. This resulted in an overall total difference of $320,511 between the 2024 P&E reports and the County's general ledger and SEFA. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. We recommend an independent review is completed to ensure the reporting is accurate. View of Responsible Officials. Management will conduct the final review and cross-check between the general ledger entries and amounts reported on the quarterly P&E reports to ensure accuracy in the amounts reported for the period.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027 (all). Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported in all quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2024. This resulted in an overall total difference of $320,511 between the 2024 P&E reports and the County's general ledger and SEFA. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. We recommend an independent review is completed to ensure the reporting is accurate. View of Responsible Officials. Management will conduct the final review and cross-check between the general ledger entries and amounts reported on the quarterly P&E reports to ensure accuracy in the amounts reported for the period.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027 (all). Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported in all quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2024. This resulted in an overall total difference of $320,511 between the 2024 P&E reports and the County's general ledger and SEFA. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. We recommend an independent review is completed to ensure the reporting is accurate. View of Responsible Officials. Management will conduct the final review and cross-check between the general ledger entries and amounts reported on the quarterly P&E reports to ensure accuracy in the amounts reported for the period.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027 (all). Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported in all quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2024. This resulted in an overall total difference of $320,511 between the 2024 P&E reports and the County's general ledger and SEFA. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. We recommend an independent review is completed to ensure the reporting is accurate. View of Responsible Officials. Management will conduct the final review and cross-check between the general ledger entries and amounts reported on the quarterly P&E reports to ensure accuracy in the amounts reported for the period.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027 (all). Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported in all quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2024. This resulted in an overall total difference of $320,511 between the 2024 P&E reports and the County's general ledger and SEFA. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. We recommend an independent review is completed to ensure the reporting is accurate. View of Responsible Officials. Management will conduct the final review and cross-check between the general ledger entries and amounts reported on the quarterly P&E reports to ensure accuracy in the amounts reported for the period.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027 (all). Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported in all quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2024. This resulted in an overall total difference of $320,511 between the 2024 P&E reports and the County's general ledger and SEFA. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. We recommend an independent review is completed to ensure the reporting is accurate. View of Responsible Officials. Management will conduct the final review and cross-check between the general ledger entries and amounts reported on the quarterly P&E reports to ensure accuracy in the amounts reported for the period.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027 (all). Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported in all quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2024. This resulted in an overall total difference of $320,511 between the 2024 P&E reports and the County's general ledger and SEFA. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. We recommend an independent review is completed to ensure the reporting is accurate. View of Responsible Officials. Management will conduct the final review and cross-check between the general ledger entries and amounts reported on the quarterly P&E reports to ensure accuracy in the amounts reported for the period.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027 (all). Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported in all quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2024. This resulted in an overall total difference of $320,511 between the 2024 P&E reports and the County's general ledger and SEFA. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. We recommend an independent review is completed to ensure the reporting is accurate. View of Responsible Officials. Management will conduct the final review and cross-check between the general ledger entries and amounts reported on the quarterly P&E reports to ensure accuracy in the amounts reported for the period.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027 (all). Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported in all quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2024. This resulted in an overall total difference of $320,511 between the 2024 P&E reports and the County's general ledger and SEFA. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. We recommend an independent review is completed to ensure the reporting is accurate. View of Responsible Officials. Management will conduct the final review and cross-check between the general ledger entries and amounts reported on the quarterly P&E reports to ensure accuracy in the amounts reported for the period.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027 (all). Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported in all quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2024. This resulted in an overall total difference of $320,511 between the 2024 P&E reports and the County's general ledger and SEFA. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. We recommend an independent review is completed to ensure the reporting is accurate. View of Responsible Officials. Management will conduct the final review and cross-check between the general ledger entries and amounts reported on the quarterly P&E reports to ensure accuracy in the amounts reported for the period.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027 (all). Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported in all quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2024. This resulted in an overall total difference of $320,511 between the 2024 P&E reports and the County's general ledger and SEFA. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. We recommend an independent review is completed to ensure the reporting is accurate. View of Responsible Officials. Management will conduct the final review and cross-check between the general ledger entries and amounts reported on the quarterly P&E reports to ensure accuracy in the amounts reported for the period.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027 (all). Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported in all quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2024. This resulted in an overall total difference of $320,511 between the 2024 P&E reports and the County's general ledger and SEFA. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. We recommend an independent review is completed to ensure the reporting is accurate. View of Responsible Officials. Management will conduct the final review and cross-check between the general ledger entries and amounts reported on the quarterly P&E reports to ensure accuracy in the amounts reported for the period.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027 (all). Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported in all quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2024. This resulted in an overall total difference of $320,511 between the 2024 P&E reports and the County's general ledger and SEFA. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. We recommend an independent review is completed to ensure the reporting is accurate. View of Responsible Officials. Management will conduct the final review and cross-check between the general ledger entries and amounts reported on the quarterly P&E reports to ensure accuracy in the amounts reported for the period.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027 (all). Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported in all quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2024. This resulted in an overall total difference of $320,511 between the 2024 P&E reports and the County's general ledger and SEFA. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. We recommend an independent review is completed to ensure the reporting is accurate. View of Responsible Officials. Management will conduct the final review and cross-check between the general ledger entries and amounts reported on the quarterly P&E reports to ensure accuracy in the amounts reported for the period.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027 (all). Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported in all quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2024. This resulted in an overall total difference of $320,511 between the 2024 P&E reports and the County's general ledger and SEFA. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. We recommend an independent review is completed to ensure the reporting is accurate. View of Responsible Officials. Management will conduct the final review and cross-check between the general ledger entries and amounts reported on the quarterly P&E reports to ensure accuracy in the amounts reported for the period.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027 (all). Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported in all quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2024. This resulted in an overall total difference of $320,511 between the 2024 P&E reports and the County's general ledger and SEFA. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. We recommend an independent review is completed to ensure the reporting is accurate. View of Responsible Officials. Management will conduct the final review and cross-check between the general ledger entries and amounts reported on the quarterly P&E reports to ensure accuracy in the amounts reported for the period.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027 (all). Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported in all quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2024. This resulted in an overall total difference of $320,511 between the 2024 P&E reports and the County's general ledger and SEFA. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. We recommend an independent review is completed to ensure the reporting is accurate. View of Responsible Officials. Management will conduct the final review and cross-check between the general ledger entries and amounts reported on the quarterly P&E reports to ensure accuracy in the amounts reported for the period.
Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027 (all). Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported in all quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2024. This resulted in an overall total difference of $320,511 between the 2024 P&E reports and the County's general ledger and SEFA. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the County did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. We recommend an independent review is completed to ensure the reporting is accurate. View of Responsible Officials. Management will conduct the final review and cross-check between the general ledger entries and amounts reported on the quarterly P&E reports to ensure accuracy in the amounts reported for the period.