Audit 292258

FY End
2022-12-31
Total Expended
$3.07M
Findings
22
Programs
11
Organization: County of Madison, Missouri (MO)
Year: 2022 Accepted: 2024-02-26

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
370556 2022-007 Significant Deficiency - P
370557 2022-007 Significant Deficiency - P
370558 2022-007 Significant Deficiency - P
370559 2022-007 Significant Deficiency - P
370560 2022-007 Significant Deficiency - P
370561 2022-007 Significant Deficiency - P
370562 2022-007 Significant Deficiency - P
370563 2022-007 Significant Deficiency - P
370564 2022-007 Significant Deficiency - P
370565 2022-007 Significant Deficiency - P
370566 2022-007 Significant Deficiency - P
946998 2022-007 Significant Deficiency - P
946999 2022-007 Significant Deficiency - P
947000 2022-007 Significant Deficiency - P
947001 2022-007 Significant Deficiency - P
947002 2022-007 Significant Deficiency - P
947003 2022-007 Significant Deficiency - P
947004 2022-007 Significant Deficiency - P
947005 2022-007 Significant Deficiency - P
947006 2022-007 Significant Deficiency - P
947007 2022-007 Significant Deficiency - P
947008 2022-007 Significant Deficiency - P

Contacts

Name Title Type
FCJKHWGVLND3 Donal Firebaugh Auditee
5737832176 Mark Stair Auditor
No contacts on file

Notes to SEFA

Title: NOTE A – BASIS OF PRESENTATION Accounting Policies: Expenditures are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance, wherein certain types of expenditures are not allowed or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: Auditee did not use the de minimis cost rate. The accompanying Schedule of Expenditures of Federal Awards (SEFA) includes the federal award activity of Madison County, Missouri for the years ended December 31, 2022 and 2021. 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). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the financial statements.
Title: NOTE B – SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES Accounting Policies: Expenditures are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance, wherein certain types of expenditures are not allowed or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: Auditee did not use the de minimis cost rate. Expenditures are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), wherein certain types of expenditures are not allowed or are limited as to reimbursement. The County has elected not to use the 10 percent de minimus indirect cost rate as allowed under the Uniform Guidance.

Finding Details

Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of the Interior, U.S. Department of Transportation, U.S. Department of Treasury, Environmental Protection Agency, Election Assistance Commission, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security. Pass-Through Grantor: Missouri Office of Administration, Missouri Department of Transportation, Missouri State Treasurer, Southeast Missouri Regional Planning & Economic Development Commission, Missouri Secretary of State and Missouri Department of Public Safety. Federal Assistance Listing Number: 10.665, 15.226, 15.438, 20.205, 20.616, 20.703, 21.019, 21.027, 66.039, 66.802, 90.401, 97.036 and 97.067. Program Title: Schools and Roads – Grants to States; Payment in Lieu of Taxes, National Forest Acquired Lands; Highway Planning and Construction; National Priority Safety Programs; COVID-19 - Coronavirus Relief Fund; COVID-19 – Coronavirus State and Local Fiscal Recovery Funds; Diesel Emissions Reduction Act; Superfund State, Political Subdivision and Indian Tribe Site-Specific Cooperative Agreement; Help America Vote Act Requirement Payments; Homeland Security Grant Program. Pass-through Entity Identifying Number: BRO-B062(011), EPA-OAP-OTAQ-20-02, DE-97784601-0, 97750001, #4317, 2017-PF-37(PWSD#1). Award Year: 2021 and 2022. Questioned Costs: None. Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 and 2023 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Reasons for discrepancies in individual programs varied. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2022 and 2021. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.