Audit 10632

FY End
2022-12-31
Total Expended
$1.52M
Findings
12
Programs
4
Organization: County of Grundy (MO)
Year: 2022 Accepted: 2024-01-10

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
8080 2022-001 Significant Deficiency Yes P
8081 2022-001 Significant Deficiency Yes P
8082 2022-001 Significant Deficiency Yes P
8083 2022-001 Significant Deficiency Yes P
8084 2022-001 Significant Deficiency Yes P
8085 2022-001 Significant Deficiency Yes P
584522 2022-001 Significant Deficiency Yes P
584523 2022-001 Significant Deficiency Yes P
584524 2022-001 Significant Deficiency Yes P
584525 2022-001 Significant Deficiency Yes P
584526 2022-001 Significant Deficiency Yes P
584527 2022-001 Significant Deficiency Yes P

Programs

Contacts

Name Title Type
KWU1BJ613QJ8 Courtney Campbell Auditee
6603594040 Robert Lock Auditor
No contacts on file

Notes to SEFA

Title: 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 de minimus cost rate. The accompanying Schedule of Expenditures of Federal Awards (SEFA) includes the federal award activity of Grundy County, Missouri for the year ended December 31, 2022. The information in this schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the financial statements.
Title: Subrecipients (delete if there were subs) 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 de minimus cost rate. The County did not pass any federal awards through to subrecipients during the year ended December 31, 2022.

Finding Details

Federal Grantor: U.S. Department of Agriculture, U.S. Department of Justice, U.S. Department of the Treasury and U.S. Department of Homeland Security Pass-Through Grantor: Missouri Department of Public Safety Federal Assistance Listing Number: 10.923, 16.738, 21.027 and 97.042 Program Title: Emergency Watershed Protection Program; Drug Court Discretionary Grant Program; COVID-19 Coronavirus State and Local Fiscal Recovery Funds; Emergency Management Performance grants Pass-through Entity Identifying Number: NR216424XXXXC021, 2019-DC-BX-0036, EMK-2021-EP-00006-045, EMK-2022-EP-00004-042, EMK-2020-EP-00004-SL08 Award Year: 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. This finding was noted in the prior audit for the year ended December 31, 2021 as item 2021-001. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 annual budget documents contained errors in amounts of federal expenditures reported. Discrepancies in amounts reported on the 2022 SEFA and amount supported by underlying accounting records are summarized as follows: Cause: The County Clerk did not prepare an accurate SEFA for the year ending December 31, 2022. This was caused by the reporting of the receipt of federal funds rather than the amount expended. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for the year ended December 31, 2022. 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, such as performing a reconciliation between the SEFA and underlying accounting records. Federal reimbursement grants should be reported on the SEFA based on reimbursable expenditures made during the year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of Justice, U.S. Department of the Treasury and U.S. Department of Homeland Security Pass-Through Grantor: Missouri Department of Public Safety Federal Assistance Listing Number: 10.923, 16.738, 21.027 and 97.042 Program Title: Emergency Watershed Protection Program; Drug Court Discretionary Grant Program; COVID-19 Coronavirus State and Local Fiscal Recovery Funds; Emergency Management Performance grants Pass-through Entity Identifying Number: NR216424XXXXC021, 2019-DC-BX-0036, EMK-2021-EP-00006-045, EMK-2022-EP-00004-042, EMK-2020-EP-00004-SL08 Award Year: 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. This finding was noted in the prior audit for the year ended December 31, 2021 as item 2021-001. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 annual budget documents contained errors in amounts of federal expenditures reported. Discrepancies in amounts reported on the 2022 SEFA and amount supported by underlying accounting records are summarized as follows: Cause: The County Clerk did not prepare an accurate SEFA for the year ending December 31, 2022. This was caused by the reporting of the receipt of federal funds rather than the amount expended. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for the year ended December 31, 2022. 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, such as performing a reconciliation between the SEFA and underlying accounting records. Federal reimbursement grants should be reported on the SEFA based on reimbursable expenditures made during the year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of Justice, U.S. Department of the Treasury and U.S. Department of Homeland Security Pass-Through Grantor: Missouri Department of Public Safety Federal Assistance Listing Number: 10.923, 16.738, 21.027 and 97.042 Program Title: Emergency Watershed Protection Program; Drug Court Discretionary Grant Program; COVID-19 Coronavirus State and Local Fiscal Recovery Funds; Emergency Management Performance grants Pass-through Entity Identifying Number: NR216424XXXXC021, 2019-DC-BX-0036, EMK-2021-EP-00006-045, EMK-2022-EP-00004-042, EMK-2020-EP-00004-SL08 Award Year: 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. This finding was noted in the prior audit for the year ended December 31, 2021 as item 2021-001. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 annual budget documents contained errors in amounts of federal expenditures reported. Discrepancies in amounts reported on the 2022 SEFA and amount supported by underlying accounting records are summarized as follows: Cause: The County Clerk did not prepare an accurate SEFA for the year ending December 31, 2022. This was caused by the reporting of the receipt of federal funds rather than the amount expended. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for the year ended December 31, 2022. 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, such as performing a reconciliation between the SEFA and underlying accounting records. Federal reimbursement grants should be reported on the SEFA based on reimbursable expenditures made during the year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of Justice, U.S. Department of the Treasury and U.S. Department of Homeland Security Pass-Through Grantor: Missouri Department of Public Safety Federal Assistance Listing Number: 10.923, 16.738, 21.027 and 97.042 Program Title: Emergency Watershed Protection Program; Drug Court Discretionary Grant Program; COVID-19 Coronavirus State and Local Fiscal Recovery Funds; Emergency Management Performance grants Pass-through Entity Identifying Number: NR216424XXXXC021, 2019-DC-BX-0036, EMK-2021-EP-00006-045, EMK-2022-EP-00004-042, EMK-2020-EP-00004-SL08 Award Year: 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. This finding was noted in the prior audit for the year ended December 31, 2021 as item 2021-001. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 annual budget documents contained errors in amounts of federal expenditures reported. Discrepancies in amounts reported on the 2022 SEFA and amount supported by underlying accounting records are summarized as follows: Cause: The County Clerk did not prepare an accurate SEFA for the year ending December 31, 2022. This was caused by the reporting of the receipt of federal funds rather than the amount expended. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for the year ended December 31, 2022. 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, such as performing a reconciliation between the SEFA and underlying accounting records. Federal reimbursement grants should be reported on the SEFA based on reimbursable expenditures made during the year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of Justice, U.S. Department of the Treasury and U.S. Department of Homeland Security Pass-Through Grantor: Missouri Department of Public Safety Federal Assistance Listing Number: 10.923, 16.738, 21.027 and 97.042 Program Title: Emergency Watershed Protection Program; Drug Court Discretionary Grant Program; COVID-19 Coronavirus State and Local Fiscal Recovery Funds; Emergency Management Performance grants Pass-through Entity Identifying Number: NR216424XXXXC021, 2019-DC-BX-0036, EMK-2021-EP-00006-045, EMK-2022-EP-00004-042, EMK-2020-EP-00004-SL08 Award Year: 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. This finding was noted in the prior audit for the year ended December 31, 2021 as item 2021-001. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 annual budget documents contained errors in amounts of federal expenditures reported. Discrepancies in amounts reported on the 2022 SEFA and amount supported by underlying accounting records are summarized as follows: Cause: The County Clerk did not prepare an accurate SEFA for the year ending December 31, 2022. This was caused by the reporting of the receipt of federal funds rather than the amount expended. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for the year ended December 31, 2022. 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, such as performing a reconciliation between the SEFA and underlying accounting records. Federal reimbursement grants should be reported on the SEFA based on reimbursable expenditures made during the year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of Justice, U.S. Department of the Treasury and U.S. Department of Homeland Security Pass-Through Grantor: Missouri Department of Public Safety Federal Assistance Listing Number: 10.923, 16.738, 21.027 and 97.042 Program Title: Emergency Watershed Protection Program; Drug Court Discretionary Grant Program; COVID-19 Coronavirus State and Local Fiscal Recovery Funds; Emergency Management Performance grants Pass-through Entity Identifying Number: NR216424XXXXC021, 2019-DC-BX-0036, EMK-2021-EP-00006-045, EMK-2022-EP-00004-042, EMK-2020-EP-00004-SL08 Award Year: 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. This finding was noted in the prior audit for the year ended December 31, 2021 as item 2021-001. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 annual budget documents contained errors in amounts of federal expenditures reported. Discrepancies in amounts reported on the 2022 SEFA and amount supported by underlying accounting records are summarized as follows: Cause: The County Clerk did not prepare an accurate SEFA for the year ending December 31, 2022. This was caused by the reporting of the receipt of federal funds rather than the amount expended. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for the year ended December 31, 2022. 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, such as performing a reconciliation between the SEFA and underlying accounting records. Federal reimbursement grants should be reported on the SEFA based on reimbursable expenditures made during the year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of Justice, U.S. Department of the Treasury and U.S. Department of Homeland Security Pass-Through Grantor: Missouri Department of Public Safety Federal Assistance Listing Number: 10.923, 16.738, 21.027 and 97.042 Program Title: Emergency Watershed Protection Program; Drug Court Discretionary Grant Program; COVID-19 Coronavirus State and Local Fiscal Recovery Funds; Emergency Management Performance grants Pass-through Entity Identifying Number: NR216424XXXXC021, 2019-DC-BX-0036, EMK-2021-EP-00006-045, EMK-2022-EP-00004-042, EMK-2020-EP-00004-SL08 Award Year: 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. This finding was noted in the prior audit for the year ended December 31, 2021 as item 2021-001. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 annual budget documents contained errors in amounts of federal expenditures reported. Discrepancies in amounts reported on the 2022 SEFA and amount supported by underlying accounting records are summarized as follows: Cause: The County Clerk did not prepare an accurate SEFA for the year ending December 31, 2022. This was caused by the reporting of the receipt of federal funds rather than the amount expended. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for the year ended December 31, 2022. 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, such as performing a reconciliation between the SEFA and underlying accounting records. Federal reimbursement grants should be reported on the SEFA based on reimbursable expenditures made during the year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of Justice, U.S. Department of the Treasury and U.S. Department of Homeland Security Pass-Through Grantor: Missouri Department of Public Safety Federal Assistance Listing Number: 10.923, 16.738, 21.027 and 97.042 Program Title: Emergency Watershed Protection Program; Drug Court Discretionary Grant Program; COVID-19 Coronavirus State and Local Fiscal Recovery Funds; Emergency Management Performance grants Pass-through Entity Identifying Number: NR216424XXXXC021, 2019-DC-BX-0036, EMK-2021-EP-00006-045, EMK-2022-EP-00004-042, EMK-2020-EP-00004-SL08 Award Year: 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. This finding was noted in the prior audit for the year ended December 31, 2021 as item 2021-001. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 annual budget documents contained errors in amounts of federal expenditures reported. Discrepancies in amounts reported on the 2022 SEFA and amount supported by underlying accounting records are summarized as follows: Cause: The County Clerk did not prepare an accurate SEFA for the year ending December 31, 2022. This was caused by the reporting of the receipt of federal funds rather than the amount expended. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for the year ended December 31, 2022. 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, such as performing a reconciliation between the SEFA and underlying accounting records. Federal reimbursement grants should be reported on the SEFA based on reimbursable expenditures made during the year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of Justice, U.S. Department of the Treasury and U.S. Department of Homeland Security Pass-Through Grantor: Missouri Department of Public Safety Federal Assistance Listing Number: 10.923, 16.738, 21.027 and 97.042 Program Title: Emergency Watershed Protection Program; Drug Court Discretionary Grant Program; COVID-19 Coronavirus State and Local Fiscal Recovery Funds; Emergency Management Performance grants Pass-through Entity Identifying Number: NR216424XXXXC021, 2019-DC-BX-0036, EMK-2021-EP-00006-045, EMK-2022-EP-00004-042, EMK-2020-EP-00004-SL08 Award Year: 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. This finding was noted in the prior audit for the year ended December 31, 2021 as item 2021-001. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 annual budget documents contained errors in amounts of federal expenditures reported. Discrepancies in amounts reported on the 2022 SEFA and amount supported by underlying accounting records are summarized as follows: Cause: The County Clerk did not prepare an accurate SEFA for the year ending December 31, 2022. This was caused by the reporting of the receipt of federal funds rather than the amount expended. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for the year ended December 31, 2022. 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, such as performing a reconciliation between the SEFA and underlying accounting records. Federal reimbursement grants should be reported on the SEFA based on reimbursable expenditures made during the year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of Justice, U.S. Department of the Treasury and U.S. Department of Homeland Security Pass-Through Grantor: Missouri Department of Public Safety Federal Assistance Listing Number: 10.923, 16.738, 21.027 and 97.042 Program Title: Emergency Watershed Protection Program; Drug Court Discretionary Grant Program; COVID-19 Coronavirus State and Local Fiscal Recovery Funds; Emergency Management Performance grants Pass-through Entity Identifying Number: NR216424XXXXC021, 2019-DC-BX-0036, EMK-2021-EP-00006-045, EMK-2022-EP-00004-042, EMK-2020-EP-00004-SL08 Award Year: 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. This finding was noted in the prior audit for the year ended December 31, 2021 as item 2021-001. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 annual budget documents contained errors in amounts of federal expenditures reported. Discrepancies in amounts reported on the 2022 SEFA and amount supported by underlying accounting records are summarized as follows: Cause: The County Clerk did not prepare an accurate SEFA for the year ending December 31, 2022. This was caused by the reporting of the receipt of federal funds rather than the amount expended. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for the year ended December 31, 2022. 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, such as performing a reconciliation between the SEFA and underlying accounting records. Federal reimbursement grants should be reported on the SEFA based on reimbursable expenditures made during the year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of Justice, U.S. Department of the Treasury and U.S. Department of Homeland Security Pass-Through Grantor: Missouri Department of Public Safety Federal Assistance Listing Number: 10.923, 16.738, 21.027 and 97.042 Program Title: Emergency Watershed Protection Program; Drug Court Discretionary Grant Program; COVID-19 Coronavirus State and Local Fiscal Recovery Funds; Emergency Management Performance grants Pass-through Entity Identifying Number: NR216424XXXXC021, 2019-DC-BX-0036, EMK-2021-EP-00006-045, EMK-2022-EP-00004-042, EMK-2020-EP-00004-SL08 Award Year: 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. This finding was noted in the prior audit for the year ended December 31, 2021 as item 2021-001. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 annual budget documents contained errors in amounts of federal expenditures reported. Discrepancies in amounts reported on the 2022 SEFA and amount supported by underlying accounting records are summarized as follows: Cause: The County Clerk did not prepare an accurate SEFA for the year ending December 31, 2022. This was caused by the reporting of the receipt of federal funds rather than the amount expended. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for the year ended December 31, 2022. 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, such as performing a reconciliation between the SEFA and underlying accounting records. Federal reimbursement grants should be reported on the SEFA based on reimbursable expenditures made during the year.
Federal Grantor: U.S. Department of Agriculture, U.S. Department of Justice, U.S. Department of the Treasury and U.S. Department of Homeland Security Pass-Through Grantor: Missouri Department of Public Safety Federal Assistance Listing Number: 10.923, 16.738, 21.027 and 97.042 Program Title: Emergency Watershed Protection Program; Drug Court Discretionary Grant Program; COVID-19 Coronavirus State and Local Fiscal Recovery Funds; Emergency Management Performance grants Pass-through Entity Identifying Number: NR216424XXXXC021, 2019-DC-BX-0036, EMK-2021-EP-00006-045, EMK-2022-EP-00004-042, EMK-2020-EP-00004-SL08 Award Year: 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. This finding was noted in the prior audit for the year ended December 31, 2021 as item 2021-001. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2022 annual budget documents contained errors in amounts of federal expenditures reported. Discrepancies in amounts reported on the 2022 SEFA and amount supported by underlying accounting records are summarized as follows: Cause: The County Clerk did not prepare an accurate SEFA for the year ending December 31, 2022. This was caused by the reporting of the receipt of federal funds rather than the amount expended. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for the year ended December 31, 2022. 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, such as performing a reconciliation between the SEFA and underlying accounting records. Federal reimbursement grants should be reported on the SEFA based on reimbursable expenditures made during the year.