Criteria or Specific Requirement: The quarterly reporting requirements were stated in the "2 CFR 200.328 and 31 CFR section 35.1(c) Reporting and requests for other information" section of the Federal Register dated January 27, 2022. The US Department of Treasury requries that quarterly reports be submitted to the department if a county has a populaton below 250,000 residents and are allocated more than $10 million in SLFRF funding. The quarterly reports must be completed and submitted within the next month after the quarterly period ended. Condition: The County was not able to provide the SLFRF quarterly report to verify that the report was submitted and completed within a timely manner. Context: The County has been unable to access the SLFRF website due to the County receiving error messages that they have "insuficient access rights on cross-reference id". Questioned Costs: $0 Effect: The County was not in compliance with SLFRF reporting requirements. Cause: The County has received error messages that says they have "insufficent access rights on cross-reference id" and they can't log-in to the SLFRF portal. Repeat: No Auditor's Recommendation: We recommend that the County seek out assistance from the US Department of Treasury about correcting their access to the SLFRF quarterly reports. View of Responsible Officials: Management acknowledges the finding and has prepared a corrective action plan. The County will seek out assistance so that they can obtain access to the SLFRF quarterly reports.
Special Tests and Provisions (Reporting) Federal Department – U.S. Department of Transportation Pass-through Illinois Department of Transportation Highway Planning and Construction, Federal Assistance Listing #20.205 County Department – Department of Transportation and Highway Finding 2023 – 003 CRITERIA As required by the grant agreement(s) with the State of Illinois, Department of Transportation (IDOT), grantee agrees to submit periodic financial and performance reporting on the approved IDOT BoBS 2832 form. Grantee shall file quarterly BoBS 2832 reports with grantor describing the expenditure(s) of the funds and performance measures related thereto. Quarterly reports must be submitted no later than 30 calendar days following the period covered by the report. For the purpose of reconciliation, the grantee must submit a BoBS 2832 report for the period ending 11/30. BoBS 2832 report marked as "Final Report" must be submitted to the grantor 60 days after the end date of the agreement. Failure to submit the required BoBS 2832 reports may cause a delay or suspension of funding. The grant agreement also states that “pursuant to 2 CFR 200.328, periodic performance reports shall be submitted no later than 30 calendar days following the period covered by the report.” CONDITION During the current audit period, Cook County Department of Transportation and Highway (DOTH) did not comply with the reporting requirements as outlined in its grant agreement(s). CAUSE Based on discussions with management, this finding was the result of working with consultants who had not previously submitted reports of this nature. The reports they produced required multiple revisions due to errors which lead to DOTH failing to submit the reports in a timely manner. EFFECT Failure to submit reports in a timely manner could impair the grantor agency’s ability to monitor program activities and could result in the loss of grant funding. Also, the failure to ensure accurate amounts are reported could result in the over-reporting and future spending of grant funds. QUESTIONED COSTS None. CONTEXT During our review of seven reports submitted (five quarterly reports and two annual BoBS periodic performance and financial) under three DOTH grants, we noted the 2 annual reports were submitted late. See Finding for chart/table. In addition, for grant C-91-381-19 report, we noted that the “remaining balance available” amount included in the report was overstated by $15,924. This occurred due to a recalculation error in the report. IDENTIFICATION OF REPEATED FINDINGS None. RECOMMENDATION We recommend that DOTH develop and implement procedures to ensure reports are submitted in a timely manner and in compliance with its grant agreements. A compliance calendar of all grants reporting due dates should be maintained to assist with ensuring compliance with reporting requirements. In addition, we recommend DOTH ensure all amounts included on grant reports are accurately calculated and reported. VIEWS OF RESPONSIBLE OFFICIALS AND PLANNED CORRECTIVE ACTIONS The County agrees with the finding and recommendation. The County’s corrective action plan is on page 54.
2023-102 Lack of Documentation Related to Reporting (prior two years 2022-108 and 2021-104) (initially reported 2018) Assistance Listing Number: 93.224 and 93.527 Name of Federal Agency: Department of Health and Human Services, HRSA Program Title: Health Center Program (Community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) and Grants for New and Expanded Services Under the Health Center Program Compliance Requirement: Reporting Pass-through Entity: N/A Federal Grant/Contract Number and Grant Year: H8006452 (2022 and 2023), H2E45500 (2022), COVID-19 ARP H8F40324 (2021), H8K49674 (2023), C1439909 (2020), H2E50094 (2023), COVID-19 H8L50549 (2023) and COVID-19 H8G48569 (2022) Finding Type: Significant Deficiency in Internal Control Questioned Costs: $0 Condition: The Organization did not maintain proper documentation in support of reporting requirements. Criteria: 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Also, under compliance requirements for reporting 2 CFR 200.328 states that information must be collected with the frequency required by the terms and conditions of the federal award for effective monitoring of the federal awards. Cause: Supporting records used to populate the Uniform Data System (UDS) report were not retained by the Organization. Effect: The Organization could submit incorrect information. Recommendation: Documentation should be prepared, reviewed, and retained to support the reporting. The documentation should clearly document who prepared the information, who reviewed the information, and that the reviewer considered whether the information was complete and accurate. Views of Responsible Officials and Planned Corrective Action: The Organization has hired a new Chief Financial Officer as well as additional supporting staff within the finance department. The accounting staff was restructured in November 2024 with the addition of a Finance Manager and Senior Accountant to strengthen internal controls and facilitate segregation of duties best practices for day-to-day activities. In addition to review of month-end journal entries, reporting requirements with additional review was also implemented in 2025.
2023-102 Lack of Documentation Related to Reporting (prior two years 2022-108 and 2021-104) (initially reported 2018) Assistance Listing Number: 93.224 and 93.527 Name of Federal Agency: Department of Health and Human Services, HRSA Program Title: Health Center Program (Community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) and Grants for New and Expanded Services Under the Health Center Program Compliance Requirement: Reporting Pass-through Entity: N/A Federal Grant/Contract Number and Grant Year: H8006452 (2022 and 2023), H2E45500 (2022), COVID-19 ARP H8F40324 (2021), H8K49674 (2023), C1439909 (2020), H2E50094 (2023), COVID-19 H8L50549 (2023) and COVID-19 H8G48569 (2022) Finding Type: Significant Deficiency in Internal Control Questioned Costs: $0 Condition: The Organization did not maintain proper documentation in support of reporting requirements. Criteria: 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Also, under compliance requirements for reporting 2 CFR 200.328 states that information must be collected with the frequency required by the terms and conditions of the federal award for effective monitoring of the federal awards. Cause: Supporting records used to populate the Uniform Data System (UDS) report were not retained by the Organization. Effect: The Organization could submit incorrect information. Recommendation: Documentation should be prepared, reviewed, and retained to support the reporting. The documentation should clearly document who prepared the information, who reviewed the information, and that the reviewer considered whether the information was complete and accurate. Views of Responsible Officials and Planned Corrective Action: The Organization has hired a new Chief Financial Officer as well as additional supporting staff within the finance department. The accounting staff was restructured in November 2024 with the addition of a Finance Manager and Senior Accountant to strengthen internal controls and facilitate segregation of duties best practices for day-to-day activities. In addition to review of month-end journal entries, reporting requirements with additional review was also implemented in 2025.
2023-102 Lack of Documentation Related to Reporting (prior two years 2022-108 and 2021-104) (initially reported 2018) Assistance Listing Number: 93.224 and 93.527 Name of Federal Agency: Department of Health and Human Services, HRSA Program Title: Health Center Program (Community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) and Grants for New and Expanded Services Under the Health Center Program Compliance Requirement: Reporting Pass-through Entity: N/A Federal Grant/Contract Number and Grant Year: H8006452 (2022 and 2023), H2E45500 (2022), COVID-19 ARP H8F40324 (2021), H8K49674 (2023), C1439909 (2020), H2E50094 (2023), COVID-19 H8L50549 (2023) and COVID-19 H8G48569 (2022) Finding Type: Significant Deficiency in Internal Control Questioned Costs: $0 Condition: The Organization did not maintain proper documentation in support of reporting requirements. Criteria: 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Also, under compliance requirements for reporting 2 CFR 200.328 states that information must be collected with the frequency required by the terms and conditions of the federal award for effective monitoring of the federal awards. Cause: Supporting records used to populate the Uniform Data System (UDS) report were not retained by the Organization. Effect: The Organization could submit incorrect information. Recommendation: Documentation should be prepared, reviewed, and retained to support the reporting. The documentation should clearly document who prepared the information, who reviewed the information, and that the reviewer considered whether the information was complete and accurate. Views of Responsible Officials and Planned Corrective Action: The Organization has hired a new Chief Financial Officer as well as additional supporting staff within the finance department. The accounting staff was restructured in November 2024 with the addition of a Finance Manager and Senior Accountant to strengthen internal controls and facilitate segregation of duties best practices for day-to-day activities. In addition to review of month-end journal entries, reporting requirements with additional review was also implemented in 2025.
2023-102 Lack of Documentation Related to Reporting (prior two years 2022-108 and 2021-104) (initially reported 2018) Assistance Listing Number: 93.224 and 93.527 Name of Federal Agency: Department of Health and Human Services, HRSA Program Title: Health Center Program (Community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) and Grants for New and Expanded Services Under the Health Center Program Compliance Requirement: Reporting Pass-through Entity: N/A Federal Grant/Contract Number and Grant Year: H8006452 (2022 and 2023), H2E45500 (2022), COVID-19 ARP H8F40324 (2021), H8K49674 (2023), C1439909 (2020), H2E50094 (2023), COVID-19 H8L50549 (2023) and COVID-19 H8G48569 (2022) Finding Type: Significant Deficiency in Internal Control Questioned Costs: $0 Condition: The Organization did not maintain proper documentation in support of reporting requirements. Criteria: 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Also, under compliance requirements for reporting 2 CFR 200.328 states that information must be collected with the frequency required by the terms and conditions of the federal award for effective monitoring of the federal awards. Cause: Supporting records used to populate the Uniform Data System (UDS) report were not retained by the Organization. Effect: The Organization could submit incorrect information. Recommendation: Documentation should be prepared, reviewed, and retained to support the reporting. The documentation should clearly document who prepared the information, who reviewed the information, and that the reviewer considered whether the information was complete and accurate. Views of Responsible Officials and Planned Corrective Action: The Organization has hired a new Chief Financial Officer as well as additional supporting staff within the finance department. The accounting staff was restructured in November 2024 with the addition of a Finance Manager and Senior Accountant to strengthen internal controls and facilitate segregation of duties best practices for day-to-day activities. In addition to review of month-end journal entries, reporting requirements with additional review was also implemented in 2025.
2023-102 Lack of Documentation Related to Reporting (prior two years 2022-108 and 2021-104) (initially reported 2018) Assistance Listing Number: 93.224 and 93.527 Name of Federal Agency: Department of Health and Human Services, HRSA Program Title: Health Center Program (Community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) and Grants for New and Expanded Services Under the Health Center Program Compliance Requirement: Reporting Pass-through Entity: N/A Federal Grant/Contract Number and Grant Year: H8006452 (2022 and 2023), H2E45500 (2022), COVID-19 ARP H8F40324 (2021), H8K49674 (2023), C1439909 (2020), H2E50094 (2023), COVID-19 H8L50549 (2023) and COVID-19 H8G48569 (2022) Finding Type: Significant Deficiency in Internal Control Questioned Costs: $0 Condition: The Organization did not maintain proper documentation in support of reporting requirements. Criteria: 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Also, under compliance requirements for reporting 2 CFR 200.328 states that information must be collected with the frequency required by the terms and conditions of the federal award for effective monitoring of the federal awards. Cause: Supporting records used to populate the Uniform Data System (UDS) report were not retained by the Organization. Effect: The Organization could submit incorrect information. Recommendation: Documentation should be prepared, reviewed, and retained to support the reporting. The documentation should clearly document who prepared the information, who reviewed the information, and that the reviewer considered whether the information was complete and accurate. Views of Responsible Officials and Planned Corrective Action: The Organization has hired a new Chief Financial Officer as well as additional supporting staff within the finance department. The accounting staff was restructured in November 2024 with the addition of a Finance Manager and Senior Accountant to strengthen internal controls and facilitate segregation of duties best practices for day-to-day activities. In addition to review of month-end journal entries, reporting requirements with additional review was also implemented in 2025.
2023-102 Lack of Documentation Related to Reporting (prior two years 2022-108 and 2021-104) (initially reported 2018) Assistance Listing Number: 93.224 and 93.527 Name of Federal Agency: Department of Health and Human Services, HRSA Program Title: Health Center Program (Community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) and Grants for New and Expanded Services Under the Health Center Program Compliance Requirement: Reporting Pass-through Entity: N/A Federal Grant/Contract Number and Grant Year: H8006452 (2022 and 2023), H2E45500 (2022), COVID-19 ARP H8F40324 (2021), H8K49674 (2023), C1439909 (2020), H2E50094 (2023), COVID-19 H8L50549 (2023) and COVID-19 H8G48569 (2022) Finding Type: Significant Deficiency in Internal Control Questioned Costs: $0 Condition: The Organization did not maintain proper documentation in support of reporting requirements. Criteria: 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Also, under compliance requirements for reporting 2 CFR 200.328 states that information must be collected with the frequency required by the terms and conditions of the federal award for effective monitoring of the federal awards. Cause: Supporting records used to populate the Uniform Data System (UDS) report were not retained by the Organization. Effect: The Organization could submit incorrect information. Recommendation: Documentation should be prepared, reviewed, and retained to support the reporting. The documentation should clearly document who prepared the information, who reviewed the information, and that the reviewer considered whether the information was complete and accurate. Views of Responsible Officials and Planned Corrective Action: The Organization has hired a new Chief Financial Officer as well as additional supporting staff within the finance department. The accounting staff was restructured in November 2024 with the addition of a Finance Manager and Senior Accountant to strengthen internal controls and facilitate segregation of duties best practices for day-to-day activities. In addition to review of month-end journal entries, reporting requirements with additional review was also implemented in 2025.
2023-102 Lack of Documentation Related to Reporting (prior two years 2022-108 and 2021-104) (initially reported 2018) Assistance Listing Number: 93.224 and 93.527 Name of Federal Agency: Department of Health and Human Services, HRSA Program Title: Health Center Program (Community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) and Grants for New and Expanded Services Under the Health Center Program Compliance Requirement: Reporting Pass-through Entity: N/A Federal Grant/Contract Number and Grant Year: H8006452 (2022 and 2023), H2E45500 (2022), COVID-19 ARP H8F40324 (2021), H8K49674 (2023), C1439909 (2020), H2E50094 (2023), COVID-19 H8L50549 (2023) and COVID-19 H8G48569 (2022) Finding Type: Significant Deficiency in Internal Control Questioned Costs: $0 Condition: The Organization did not maintain proper documentation in support of reporting requirements. Criteria: 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Also, under compliance requirements for reporting 2 CFR 200.328 states that information must be collected with the frequency required by the terms and conditions of the federal award for effective monitoring of the federal awards. Cause: Supporting records used to populate the Uniform Data System (UDS) report were not retained by the Organization. Effect: The Organization could submit incorrect information. Recommendation: Documentation should be prepared, reviewed, and retained to support the reporting. The documentation should clearly document who prepared the information, who reviewed the information, and that the reviewer considered whether the information was complete and accurate. Views of Responsible Officials and Planned Corrective Action: The Organization has hired a new Chief Financial Officer as well as additional supporting staff within the finance department. The accounting staff was restructured in November 2024 with the addition of a Finance Manager and Senior Accountant to strengthen internal controls and facilitate segregation of duties best practices for day-to-day activities. In addition to review of month-end journal entries, reporting requirements with additional review was also implemented in 2025.
2023-102 Lack of Documentation Related to Reporting (prior two years 2022-108 and 2021-104) (initially reported 2018) Assistance Listing Number: 93.224 and 93.527 Name of Federal Agency: Department of Health and Human Services, HRSA Program Title: Health Center Program (Community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) and Grants for New and Expanded Services Under the Health Center Program Compliance Requirement: Reporting Pass-through Entity: N/A Federal Grant/Contract Number and Grant Year: H8006452 (2022 and 2023), H2E45500 (2022), COVID-19 ARP H8F40324 (2021), H8K49674 (2023), C1439909 (2020), H2E50094 (2023), COVID-19 H8L50549 (2023) and COVID-19 H8G48569 (2022) Finding Type: Significant Deficiency in Internal Control Questioned Costs: $0 Condition: The Organization did not maintain proper documentation in support of reporting requirements. Criteria: 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Also, under compliance requirements for reporting 2 CFR 200.328 states that information must be collected with the frequency required by the terms and conditions of the federal award for effective monitoring of the federal awards. Cause: Supporting records used to populate the Uniform Data System (UDS) report were not retained by the Organization. Effect: The Organization could submit incorrect information. Recommendation: Documentation should be prepared, reviewed, and retained to support the reporting. The documentation should clearly document who prepared the information, who reviewed the information, and that the reviewer considered whether the information was complete and accurate. Views of Responsible Officials and Planned Corrective Action: The Organization has hired a new Chief Financial Officer as well as additional supporting staff within the finance department. The accounting staff was restructured in November 2024 with the addition of a Finance Manager and Senior Accountant to strengthen internal controls and facilitate segregation of duties best practices for day-to-day activities. In addition to review of month-end journal entries, reporting requirements with additional review was also implemented in 2025.
2023-102 Lack of Documentation Related to Reporting (prior two years 2022-108 and 2021-104) (initially reported 2018) Assistance Listing Number: 93.224 and 93.527 Name of Federal Agency: Department of Health and Human Services, HRSA Program Title: Health Center Program (Community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) and Grants for New and Expanded Services Under the Health Center Program Compliance Requirement: Reporting Pass-through Entity: N/A Federal Grant/Contract Number and Grant Year: H8006452 (2022 and 2023), H2E45500 (2022), COVID-19 ARP H8F40324 (2021), H8K49674 (2023), C1439909 (2020), H2E50094 (2023), COVID-19 H8L50549 (2023) and COVID-19 H8G48569 (2022) Finding Type: Significant Deficiency in Internal Control Questioned Costs: $0 Condition: The Organization did not maintain proper documentation in support of reporting requirements. Criteria: 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Also, under compliance requirements for reporting 2 CFR 200.328 states that information must be collected with the frequency required by the terms and conditions of the federal award for effective monitoring of the federal awards. Cause: Supporting records used to populate the Uniform Data System (UDS) report were not retained by the Organization. Effect: The Organization could submit incorrect information. Recommendation: Documentation should be prepared, reviewed, and retained to support the reporting. The documentation should clearly document who prepared the information, who reviewed the information, and that the reviewer considered whether the information was complete and accurate. Views of Responsible Officials and Planned Corrective Action: The Organization has hired a new Chief Financial Officer as well as additional supporting staff within the finance department. The accounting staff was restructured in November 2024 with the addition of a Finance Manager and Senior Accountant to strengthen internal controls and facilitate segregation of duties best practices for day-to-day activities. In addition to review of month-end journal entries, reporting requirements with additional review was also implemented in 2025.
Finding 2023-004 – Reporting (Significant Deficiency and Noncompliance) Information on the federal program: U.S. Department of Education, Assistance listing # 84.425 Education Stabilization Fund Criteria: 2 CFR 200.328-300 establish requirements for designing and monitoring internal controls over reporting requirements of a non-federal entity. Controls should be implemented to ensure accurate and complete reporting compliance. Condition: We selected a sample of 2 reports submitted for the HEERF program during the year. For both the annual and quarterly report examined, there was no documentation of a control such as reviewing and approving the report prior to submission. In addition, the annual report programmatic data source documentation varied from the data reported for several items. Cause: The College had a team managing the COVID funds due to their unique nature. While they were contact with each other about the program and reports, documentation of a review and approval was not available. The annual report included programmatic accomplishments and the report provided to support the data had several variances. Effect: The College did not properly implement documentation of internal controls to ensure compliance with reporting requirements. Questioned Costs: None reported Recommendation: We recommend the College strengthen its policies and procedures surrounding grant reporting to include documentation of controls such as review and approvals to ensure documentation is retained to support compliance requirements. Views of Responsible Officials: See Management’s View and Corrective Action Plan included at the end of the report.
Information on the federal program: U.S. Department of the Treasury, Assistance listing # 21.027 COVID-19 Coronavirus State and Local Fiscal Recovery Funds Criteria: 2 CFR 200.328-300 establish requirements for designing and monitoring internal controls over reporting requirements of a non-federal entity. Controls should be implemented to ensure accurate and complete reporting compliance. The Coronavirus State and Local Fiscal Recovery Funds: Overview of the Final Rule establishes the specific requirements for ARPA fund reporting. Condition: We examined the annual Project and Expenditure report required. It was not filed within 30 days of specified year end as required. Cause: There had been no fund expenditures prior to December of 2022. Annual reporting requirements for ARPA funds is at March 30 year end. The City’s controls around reporting focus on fiscal quarter end and fiscal and calendar year end. This reporting period is not in the City’s normal reporting schedule and therefore was not addressed through the controls in place. Effect: The City did not timely fulfill the related reporting requirements. Questioned Costs: None reported. Recommendation: We recommend the City strengthen its policies and procedures surrounding grant reporting to include (at inception of each award) documentation of a schedule of reporting requirements, review, and approvals to ensure documentation is retained to support compliance requirements. Views of Responsible Officials: Management agrees with the finding. See Corrective Action Plan included at the end of the report.
U.S. Department of Justice Crime Victim Assistance – Assistance #16.575 #2023-008 – Major Federal Award Finding – Reporting Nature of Finding: Compliance Finding Reporting and Material Weakness in Internal Controls over Compliance This is a repeat of prior year finding #2022-006. Criteria/Condition: Federal regulations 2 CFR 200.328 - 200.329 provide that required reporting under the federal program must be completed timely and accurately. The federal award agreement includes specific report filing due dates. Segregation of duties is also a key element of internal controls, including controls over compliance, and involves processes whereby the activities of one employee are reviewed or checked by the activities of another individual, and avoids one employee having the ability to perform a transaction or process from beginning to end. We noted during testing of sixteen different required reports that five of these reports tested were not filed in a timely manner. There were also no review procedures in place surrounding these reports. Cause/Context: Controls were not in place to ensure timely reporting. Only one individual was involved in the reporting process for the reports. A total of five of the reports tested were submitted more than ten days late. Effect: A lack of controls could result in late or failed reporting. Recommendation: We recommend the Organization establish procedures and controls to ensure financial and performance reports are filed timely. Views of Responsible Officials and Planned Corrective Actions: The Organization will ensure that all federal award reports are filed in a timely manner. The Organization is in the process of posting a new position, Director of Grants and Compliance. The individual in this new role will be responsible for tracking report due dates and working with the individuals responsible for the content of these reports to ensure the information is accurate and on time. In situations where the Director of Grants and Compliance is responsible for gathering the data for required reporting, the data will be reviewed by either the CFO or CEO prior to submission of the report.
U.S. Department of Justice Crime Victim Assistance – Assistance #16.575 #2023-008 – Major Federal Award Finding – Reporting Nature of Finding: Compliance Finding Reporting and Material Weakness in Internal Controls over Compliance This is a repeat of prior year finding #2022-006. Criteria/Condition: Federal regulations 2 CFR 200.328 - 200.329 provide that required reporting under the federal program must be completed timely and accurately. The federal award agreement includes specific report filing due dates. Segregation of duties is also a key element of internal controls, including controls over compliance, and involves processes whereby the activities of one employee are reviewed or checked by the activities of another individual, and avoids one employee having the ability to perform a transaction or process from beginning to end. We noted during testing of sixteen different required reports that five of these reports tested were not filed in a timely manner. There were also no review procedures in place surrounding these reports. Cause/Context: Controls were not in place to ensure timely reporting. Only one individual was involved in the reporting process for the reports. A total of five of the reports tested were submitted more than ten days late. Effect: A lack of controls could result in late or failed reporting. Recommendation: We recommend the Organization establish procedures and controls to ensure financial and performance reports are filed timely. Views of Responsible Officials and Planned Corrective Actions: The Organization will ensure that all federal award reports are filed in a timely manner. The Organization is in the process of posting a new position, Director of Grants and Compliance. The individual in this new role will be responsible for tracking report due dates and working with the individuals responsible for the content of these reports to ensure the information is accurate and on time. In situations where the Director of Grants and Compliance is responsible for gathering the data for required reporting, the data will be reviewed by either the CFO or CEO prior to submission of the report.
U.S. Department of Justice Crime Victim Assistance – Assistance #16.575 #2023-008 – Major Federal Award Finding – Reporting Nature of Finding: Compliance Finding Reporting and Material Weakness in Internal Controls over Compliance This is a repeat of prior year finding #2022-006. Criteria/Condition: Federal regulations 2 CFR 200.328 - 200.329 provide that required reporting under the federal program must be completed timely and accurately. The federal award agreement includes specific report filing due dates. Segregation of duties is also a key element of internal controls, including controls over compliance, and involves processes whereby the activities of one employee are reviewed or checked by the activities of another individual, and avoids one employee having the ability to perform a transaction or process from beginning to end. We noted during testing of sixteen different required reports that five of these reports tested were not filed in a timely manner. There were also no review procedures in place surrounding these reports. Cause/Context: Controls were not in place to ensure timely reporting. Only one individual was involved in the reporting process for the reports. A total of five of the reports tested were submitted more than ten days late. Effect: A lack of controls could result in late or failed reporting. Recommendation: We recommend the Organization establish procedures and controls to ensure financial and performance reports are filed timely. Views of Responsible Officials and Planned Corrective Actions: The Organization will ensure that all federal award reports are filed in a timely manner. The Organization is in the process of posting a new position, Director of Grants and Compliance. The individual in this new role will be responsible for tracking report due dates and working with the individuals responsible for the content of these reports to ensure the information is accurate and on time. In situations where the Director of Grants and Compliance is responsible for gathering the data for required reporting, the data will be reviewed by either the CFO or CEO prior to submission of the report.
U.S. Department of Justice Crime Victim Assistance – Assistance #16.575 #2023-008 – Major Federal Award Finding – Reporting Nature of Finding: Compliance Finding Reporting and Material Weakness in Internal Controls over Compliance This is a repeat of prior year finding #2022-006. Criteria/Condition: Federal regulations 2 CFR 200.328 - 200.329 provide that required reporting under the federal program must be completed timely and accurately. The federal award agreement includes specific report filing due dates. Segregation of duties is also a key element of internal controls, including controls over compliance, and involves processes whereby the activities of one employee are reviewed or checked by the activities of another individual, and avoids one employee having the ability to perform a transaction or process from beginning to end. We noted during testing of sixteen different required reports that five of these reports tested were not filed in a timely manner. There were also no review procedures in place surrounding these reports. Cause/Context: Controls were not in place to ensure timely reporting. Only one individual was involved in the reporting process for the reports. A total of five of the reports tested were submitted more than ten days late. Effect: A lack of controls could result in late or failed reporting. Recommendation: We recommend the Organization establish procedures and controls to ensure financial and performance reports are filed timely. Views of Responsible Officials and Planned Corrective Actions: The Organization will ensure that all federal award reports are filed in a timely manner. The Organization is in the process of posting a new position, Director of Grants and Compliance. The individual in this new role will be responsible for tracking report due dates and working with the individuals responsible for the content of these reports to ensure the information is accurate and on time. In situations where the Director of Grants and Compliance is responsible for gathering the data for required reporting, the data will be reviewed by either the CFO or CEO prior to submission of the report.
U.S. Department of Justice Crime Victim Assistance – Assistance #16.575 #2023-008 – Major Federal Award Finding – Reporting Nature of Finding: Compliance Finding Reporting and Material Weakness in Internal Controls over Compliance This is a repeat of prior year finding #2022-006. Criteria/Condition: Federal regulations 2 CFR 200.328 - 200.329 provide that required reporting under the federal program must be completed timely and accurately. The federal award agreement includes specific report filing due dates. Segregation of duties is also a key element of internal controls, including controls over compliance, and involves processes whereby the activities of one employee are reviewed or checked by the activities of another individual, and avoids one employee having the ability to perform a transaction or process from beginning to end. We noted during testing of sixteen different required reports that five of these reports tested were not filed in a timely manner. There were also no review procedures in place surrounding these reports. Cause/Context: Controls were not in place to ensure timely reporting. Only one individual was involved in the reporting process for the reports. A total of five of the reports tested were submitted more than ten days late. Effect: A lack of controls could result in late or failed reporting. Recommendation: We recommend the Organization establish procedures and controls to ensure financial and performance reports are filed timely. Views of Responsible Officials and Planned Corrective Actions: The Organization will ensure that all federal award reports are filed in a timely manner. The Organization is in the process of posting a new position, Director of Grants and Compliance. The individual in this new role will be responsible for tracking report due dates and working with the individuals responsible for the content of these reports to ensure the information is accurate and on time. In situations where the Director of Grants and Compliance is responsible for gathering the data for required reporting, the data will be reviewed by either the CFO or CEO prior to submission of the report.
U.S. Department of Justice Crime Victim Assistance – Assistance #16.575 #2023-008 – Major Federal Award Finding – Reporting Nature of Finding: Compliance Finding Reporting and Material Weakness in Internal Controls over Compliance This is a repeat of prior year finding #2022-006. Criteria/Condition: Federal regulations 2 CFR 200.328 - 200.329 provide that required reporting under the federal program must be completed timely and accurately. The federal award agreement includes specific report filing due dates. Segregation of duties is also a key element of internal controls, including controls over compliance, and involves processes whereby the activities of one employee are reviewed or checked by the activities of another individual, and avoids one employee having the ability to perform a transaction or process from beginning to end. We noted during testing of sixteen different required reports that five of these reports tested were not filed in a timely manner. There were also no review procedures in place surrounding these reports. Cause/Context: Controls were not in place to ensure timely reporting. Only one individual was involved in the reporting process for the reports. A total of five of the reports tested were submitted more than ten days late. Effect: A lack of controls could result in late or failed reporting. Recommendation: We recommend the Organization establish procedures and controls to ensure financial and performance reports are filed timely. Views of Responsible Officials and Planned Corrective Actions: The Organization will ensure that all federal award reports are filed in a timely manner. The Organization is in the process of posting a new position, Director of Grants and Compliance. The individual in this new role will be responsible for tracking report due dates and working with the individuals responsible for the content of these reports to ensure the information is accurate and on time. In situations where the Director of Grants and Compliance is responsible for gathering the data for required reporting, the data will be reviewed by either the CFO or CEO prior to submission of the report.
2023-004 U.S. Department of Transportation Federal Financial Assistance Listing 20.106 Airport Improvement Grant 3-16-0018-048-2020, 3-16-0018-049-2021, 3-16-0018-054-2021, 3-16-0018-055-2021, 3-16-0018-056-2022 Compliance Requirement - Reporting Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR §200.328, Financial Reporting, mandates that information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly except in unusual circumstances. Condition: During our testing of the required annual reports, SF-425 report, it was noted some of the annual reports required to be submitted by December 31, 2022, were submitted late on January 3, 2023. Cause: During the period under audit, there was a changeover in personnel at the airport, including the individual who was responsible for reviewing and submitting the reports. Effect: The reports were submitted to and accepted by the FAA; however, they were late. Questioned Costs: None reported. Context/Sampling: Sampling was not used. 100% of the required reports were tested. Of the 11 reports required to be submitted by December 31, 2022, 5 of them were late. Repeat Finding from Prior Year(s): Yes, 2022-001 Recommendation: The City should review its current policies and processes to ensure that the controls operate effectively, even in the event of a change in personnel. Views of Responsible Officials: The City concurs with the auditor’s findings.
2023-004 U.S. Department of Transportation Federal Financial Assistance Listing 20.106 Airport Improvement Grant 3-16-0018-048-2020, 3-16-0018-049-2021, 3-16-0018-054-2021, 3-16-0018-055-2021, 3-16-0018-056-2022 Compliance Requirement - Reporting Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR §200.328, Financial Reporting, mandates that information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly except in unusual circumstances. Condition: During our testing of the required annual reports, SF-425 report, it was noted some of the annual reports required to be submitted by December 31, 2022, were submitted late on January 3, 2023. Cause: During the period under audit, there was a changeover in personnel at the airport, including the individual who was responsible for reviewing and submitting the reports. Effect: The reports were submitted to and accepted by the FAA; however, they were late. Questioned Costs: None reported. Context/Sampling: Sampling was not used. 100% of the required reports were tested. Of the 11 reports required to be submitted by December 31, 2022, 5 of them were late. Repeat Finding from Prior Year(s): Yes, 2022-001 Recommendation: The City should review its current policies and processes to ensure that the controls operate effectively, even in the event of a change in personnel. Views of Responsible Officials: The City concurs with the auditor’s findings.
2023-004 U.S. Department of Transportation Federal Financial Assistance Listing 20.106 Airport Improvement Grant 3-16-0018-048-2020, 3-16-0018-049-2021, 3-16-0018-054-2021, 3-16-0018-055-2021, 3-16-0018-056-2022 Compliance Requirement - Reporting Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR §200.328, Financial Reporting, mandates that information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly except in unusual circumstances. Condition: During our testing of the required annual reports, SF-425 report, it was noted some of the annual reports required to be submitted by December 31, 2022, were submitted late on January 3, 2023. Cause: During the period under audit, there was a changeover in personnel at the airport, including the individual who was responsible for reviewing and submitting the reports. Effect: The reports were submitted to and accepted by the FAA; however, they were late. Questioned Costs: None reported. Context/Sampling: Sampling was not used. 100% of the required reports were tested. Of the 11 reports required to be submitted by December 31, 2022, 5 of them were late. Repeat Finding from Prior Year(s): Yes, 2022-001 Recommendation: The City should review its current policies and processes to ensure that the controls operate effectively, even in the event of a change in personnel. Views of Responsible Officials: The City concurs with the auditor’s findings.
2023-004 U.S. Department of Transportation Federal Financial Assistance Listing 20.106 Airport Improvement Grant 3-16-0018-048-2020, 3-16-0018-049-2021, 3-16-0018-054-2021, 3-16-0018-055-2021, 3-16-0018-056-2022 Compliance Requirement - Reporting Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR §200.328, Financial Reporting, mandates that information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly except in unusual circumstances. Condition: During our testing of the required annual reports, SF-425 report, it was noted some of the annual reports required to be submitted by December 31, 2022, were submitted late on January 3, 2023. Cause: During the period under audit, there was a changeover in personnel at the airport, including the individual who was responsible for reviewing and submitting the reports. Effect: The reports were submitted to and accepted by the FAA; however, they were late. Questioned Costs: None reported. Context/Sampling: Sampling was not used. 100% of the required reports were tested. Of the 11 reports required to be submitted by December 31, 2022, 5 of them were late. Repeat Finding from Prior Year(s): Yes, 2022-001 Recommendation: The City should review its current policies and processes to ensure that the controls operate effectively, even in the event of a change in personnel. Views of Responsible Officials: The City concurs with the auditor’s findings.
2023-004 U.S. Department of Transportation Federal Financial Assistance Listing 20.106 Airport Improvement Grant 3-16-0018-048-2020, 3-16-0018-049-2021, 3-16-0018-054-2021, 3-16-0018-055-2021, 3-16-0018-056-2022 Compliance Requirement - Reporting Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR §200.328, Financial Reporting, mandates that information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly except in unusual circumstances. Condition: During our testing of the required annual reports, SF-425 report, it was noted some of the annual reports required to be submitted by December 31, 2022, were submitted late on January 3, 2023. Cause: During the period under audit, there was a changeover in personnel at the airport, including the individual who was responsible for reviewing and submitting the reports. Effect: The reports were submitted to and accepted by the FAA; however, they were late. Questioned Costs: None reported. Context/Sampling: Sampling was not used. 100% of the required reports were tested. Of the 11 reports required to be submitted by December 31, 2022, 5 of them were late. Repeat Finding from Prior Year(s): Yes, 2022-001 Recommendation: The City should review its current policies and processes to ensure that the controls operate effectively, even in the event of a change in personnel. Views of Responsible Officials: The City concurs with the auditor’s findings.
2023-004 U.S. Department of Transportation Federal Financial Assistance Listing 20.106 Airport Improvement Grant 3-16-0018-048-2020, 3-16-0018-049-2021, 3-16-0018-054-2021, 3-16-0018-055-2021, 3-16-0018-056-2022 Compliance Requirement - Reporting Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR §200.328, Financial Reporting, mandates that information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly except in unusual circumstances. Condition: During our testing of the required annual reports, SF-425 report, it was noted some of the annual reports required to be submitted by December 31, 2022, were submitted late on January 3, 2023. Cause: During the period under audit, there was a changeover in personnel at the airport, including the individual who was responsible for reviewing and submitting the reports. Effect: The reports were submitted to and accepted by the FAA; however, they were late. Questioned Costs: None reported. Context/Sampling: Sampling was not used. 100% of the required reports were tested. Of the 11 reports required to be submitted by December 31, 2022, 5 of them were late. Repeat Finding from Prior Year(s): Yes, 2022-001 Recommendation: The City should review its current policies and processes to ensure that the controls operate effectively, even in the event of a change in personnel. Views of Responsible Officials: The City concurs with the auditor’s findings.
2023-004 U.S. Department of Transportation Federal Financial Assistance Listing 20.106 Airport Improvement Grant 3-16-0018-048-2020, 3-16-0018-049-2021, 3-16-0018-054-2021, 3-16-0018-055-2021, 3-16-0018-056-2022 Compliance Requirement - Reporting Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR §200.328, Financial Reporting, mandates that information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly except in unusual circumstances. Condition: During our testing of the required annual reports, SF-425 report, it was noted some of the annual reports required to be submitted by December 31, 2022, were submitted late on January 3, 2023. Cause: During the period under audit, there was a changeover in personnel at the airport, including the individual who was responsible for reviewing and submitting the reports. Effect: The reports were submitted to and accepted by the FAA; however, they were late. Questioned Costs: None reported. Context/Sampling: Sampling was not used. 100% of the required reports were tested. Of the 11 reports required to be submitted by December 31, 2022, 5 of them were late. Repeat Finding from Prior Year(s): Yes, 2022-001 Recommendation: The City should review its current policies and processes to ensure that the controls operate effectively, even in the event of a change in personnel. Views of Responsible Officials: The City concurs with the auditor’s findings.
2023-004 U.S. Department of Transportation Federal Financial Assistance Listing 20.106 Airport Improvement Grant 3-16-0018-048-2020, 3-16-0018-049-2021, 3-16-0018-054-2021, 3-16-0018-055-2021, 3-16-0018-056-2022 Compliance Requirement - Reporting Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR §200.328, Financial Reporting, mandates that information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly except in unusual circumstances. Condition: During our testing of the required annual reports, SF-425 report, it was noted some of the annual reports required to be submitted by December 31, 2022, were submitted late on January 3, 2023. Cause: During the period under audit, there was a changeover in personnel at the airport, including the individual who was responsible for reviewing and submitting the reports. Effect: The reports were submitted to and accepted by the FAA; however, they were late. Questioned Costs: None reported. Context/Sampling: Sampling was not used. 100% of the required reports were tested. Of the 11 reports required to be submitted by December 31, 2022, 5 of them were late. Repeat Finding from Prior Year(s): Yes, 2022-001 Recommendation: The City should review its current policies and processes to ensure that the controls operate effectively, even in the event of a change in personnel. Views of Responsible Officials: The City concurs with the auditor’s findings.
2023-004 U.S. Department of Transportation Federal Financial Assistance Listing 20.106 Airport Improvement Grant 3-16-0018-048-2020, 3-16-0018-049-2021, 3-16-0018-054-2021, 3-16-0018-055-2021, 3-16-0018-056-2022 Compliance Requirement - Reporting Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR §200.328, Financial Reporting, mandates that information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly except in unusual circumstances. Condition: During our testing of the required annual reports, SF-425 report, it was noted some of the annual reports required to be submitted by December 31, 2022, were submitted late on January 3, 2023. Cause: During the period under audit, there was a changeover in personnel at the airport, including the individual who was responsible for reviewing and submitting the reports. Effect: The reports were submitted to and accepted by the FAA; however, they were late. Questioned Costs: None reported. Context/Sampling: Sampling was not used. 100% of the required reports were tested. Of the 11 reports required to be submitted by December 31, 2022, 5 of them were late. Repeat Finding from Prior Year(s): Yes, 2022-001 Recommendation: The City should review its current policies and processes to ensure that the controls operate effectively, even in the event of a change in personnel. Views of Responsible Officials: The City concurs with the auditor’s findings.
2023-004 U.S. Department of Transportation Federal Financial Assistance Listing 20.106 Airport Improvement Grant 3-16-0018-048-2020, 3-16-0018-049-2021, 3-16-0018-054-2021, 3-16-0018-055-2021, 3-16-0018-056-2022 Compliance Requirement - Reporting Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR §200.328, Financial Reporting, mandates that information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly except in unusual circumstances. Condition: During our testing of the required annual reports, SF-425 report, it was noted some of the annual reports required to be submitted by December 31, 2022, were submitted late on January 3, 2023. Cause: During the period under audit, there was a changeover in personnel at the airport, including the individual who was responsible for reviewing and submitting the reports. Effect: The reports were submitted to and accepted by the FAA; however, they were late. Questioned Costs: None reported. Context/Sampling: Sampling was not used. 100% of the required reports were tested. Of the 11 reports required to be submitted by December 31, 2022, 5 of them were late. Repeat Finding from Prior Year(s): Yes, 2022-001 Recommendation: The City should review its current policies and processes to ensure that the controls operate effectively, even in the event of a change in personnel. Views of Responsible Officials: The City concurs with the auditor’s findings.
2023-001 L Reporting Compliance Requirement (Significant Deficiency in Internal Controls over Compliance and Noncompliance) Reference Number: 2023-001 L. Reporting Compliance Requirement ALN 21.027 Coronavirus State and Local Fiscal Recovery Fund Federal Award Agreement Number: 17460025442 Award Year: 2022-2023 Federal Agency: U.S. Department of Treasury Criteria: Non‐federal entities are required to establish and maintain effective internal controls over compliance in accordance with 2 CFR 200.328 and 31 CFR section 35.4 (c), states metropolitan cities and counties with a population below 250,000 residents that are allocated more than $10 million in SLFRF funding are required to submit quarterly Project and Expenditure Reports. Condition Found: During our review of the quarterly reporting process, CRI identified one quarterly report was not submitted and no documentation was maintained to support evidence that the report was reviewed and submitted. Cause: Documentation regarding Q1 2023 project and expenditure report was not maintained. Effect: The Department of Treasury uses the reports internally for oversight purposes and to fulfill Treasury’s transparency and legal obligations. The results of the City not submitting a report timely could lead to a finding of non‐compliance, which could result in development of corrective action plan or other consequences. Questioned Cost: $0 Recommendation: We recommend the City to document and maintain all quarterly reports that are submitted through the portal and include a printout of all reports submitted. Views of Responsible Officials: Management agrees with the findings. See corrective action plan beginning on page 228.
Finding 2023-007 – Reporting (Significant Deficiency and Noncompliance) Information on the federal program: U.S. Department of Health and Human Services, Assistance Listing #93.137 Community Programs to Improve Minority Health Grant Program. Criteria: 2 CFR section 200.328 establishes the requirements for timely and accurate financial reporting requirements and 2 CFR 200.329 establishes responsibility for reporting activities under the grant. Both financial and programmatic reporting requires the nonfederal entity to establish internal controls to ensure accuracy of reports. Condition: We tested on financial and one programmatic report filed for this grant during the year. For the programmatic report, data reported for accomplishments and clients served was not clearly supported. In addition, review and approval of the report was not clearly documented. Cause: Results reported in the programmatic report were supported by time sheets and client internal notes. This support was not summarized or categorized in a manner in which the reported data could be traced back to the support. Employees involved in the preparing and filing of these reports are copied on email submission but a review and approval prior to submission was not documented. Effect: The Council did not comply with reporting control requirements. Questioned Costs: None reported Recommendation: We recommend the Council strengthen procedures and documentation policies to ensure program accomplishments are adequately supported by records that are accumulated and summarized in accordance with the required criteria. Procedures should also be strengthened to include a clear review and approval process to be documented prior to report submission. Views of Responsible Officials: See Management’s View and Corrective Action Plan at the end of the report.
Criteria: In accordance with 2 CFR §170, prime awardees awarded a federal grant are required to file a Federal Funding Accountability and Transparency Act (FFATA) sub-award report by the end of the month following the month in which the prime awardee awards any sub-grant equal to or greater than $30,000. Further, the Organization is subject to reporting requirements for both financial and progress reporting. In accordance with 2 CFR §200.328, Federal Financial Reports (FFR) should be submitted based on frequency required by the terms and conditions. In instances were the Organization is a subrecipient, the grant agreement with the prime recipient Rural Community Assistance Partnership (RCAP), requires that in order to facilitate RCAP’s financial reporting requirements, the Organization is required to submit reimbursement request monthly within 10 days of the following month. Additionally, in accordance with the agreement with RCAP, in order to facilitate RCAP’s progress reporting requirements the Organization is required to submit data related to progress made within 12 days for quarterly reports under program 66.446 and a final narrative within 75 days from project close. The requirements for progress reports for program 10.761 are to be submitted within 15 days for quarterly reports and 45 days for final narrative. Condition: During the review of the reporting compliance requirement related to major program, it was determined that a FFATA reports were not filed by the Organization within the required period. Further, the Organization did not file a FFR report within the required deadline for a grant it is a prime recipient. For grants on which the Organization is a subrecipient, it was determined that reimbursement requests and progress reports were not submitted within the required deadline. Cause: Internal controls over financial reporting were not operating effectively to file the FFATA report a timely manner. Management was not aware of the FFATA requirements for prime awards. Further, internal controls over financial reporting were not operating effectively to file FFRs, reimbursement requests and progress reports in a timely manner. Effect: Failure to submit the FFATA reports by the end of the following month after sub-grant greater than $30,000 is awarded results in noncompliance with 2 CFR §170. Failure to submit the semi-annual FFR within the 30-day submission deadline results in noncompliance with 2 CFR §200.328. Additionally, failure to submit the reimbursement request and progress reports within the specified deadline results in a breach of contract with RCAP. Questioned Costs: Questioned costs were not identified.Perspective information: It is noted that the Organization has not established policies and procedures that will ensure that FFATA reports are submitted within the required timeline and therefore three out of three samples tested for this compliance requirement were not completed. Further, for the awards that the Organization was a prime recipient one out one sample tested from a population of two was submitted timely. For awards which the Organization is a subrecipient, three out of the nine samples tested from a population of thirty-six were not submitted within the specified timeline. Additionally, for awards which the Organization is a subrecipient, one out of two samples from a population of 12 were not submitted with the specified timeline. Non-compliance surrounding reporting was identified for the following awards during the fiscal 2023: Federal Agency Pass-Through Entity ALN Federal Award Name Award Year Department of Health and Human Services Direct 93.570 HHS RCD - SERCAP 9/30/2022 – 8/31/2023 United States Department of Agriculture Rural Community Assistance Partnership Inc. 10.761 Technitrain 2022-2023 9/1/2022 – 8/31/2023 United States Department of Agriculture Rural Community Assistance Partnership Inc. 10.761 Tribal 2022 - 2023 9/1/2022 – 8/31/2023 Environmental Protection Agency Rural Community Assistance Partnership Inc. 66.446 Training and Technical Assistance for Treatment Works 4/1/2022 – 9/30/2023 Repeat Finding: No similar finding was reported in the prior year. Recommendations: We recommend that management attend training related to federal grant requirements. We also recommend that management establish procedures to ensure that it meets FFATA requirements on a timely basis. The Organization should review its internal controls surrounding financial and progress reporting for each federal award and develop an effective reporting tracking system to allow the Organization to monitor and ensure reports are prepared and submitted within deadlines.
Criteria: In accordance with 2 CFR §170, prime awardees awarded a federal grant are required to file a Federal Funding Accountability and Transparency Act (FFATA) sub-award report by the end of the month following the month in which the prime awardee awards any sub-grant equal to or greater than $30,000. Further, the Organization is subject to reporting requirements for both financial and progress reporting. In accordance with 2 CFR §200.328, Federal Financial Reports (FFR) should be submitted based on frequency required by the terms and conditions. In instances were the Organization is a subrecipient, the grant agreement with the prime recipient Rural Community Assistance Partnership (RCAP), requires that in order to facilitate RCAP’s financial reporting requirements, the Organization is required to submit reimbursement request monthly within 10 days of the following month. Additionally, in accordance with the agreement with RCAP, in order to facilitate RCAP’s progress reporting requirements the Organization is required to submit data related to progress made within 12 days for quarterly reports under program 66.446 and a final narrative within 75 days from project close. The requirements for progress reports for program 10.761 are to be submitted within 15 days for quarterly reports and 45 days for final narrative. Condition: During the review of the reporting compliance requirement related to major program, it was determined that a FFATA reports were not filed by the Organization within the required period. Further, the Organization did not file a FFR report within the required deadline for a grant it is a prime recipient. For grants on which the Organization is a subrecipient, it was determined that reimbursement requests and progress reports were not submitted within the required deadline. Cause: Internal controls over financial reporting were not operating effectively to file the FFATA report a timely manner. Management was not aware of the FFATA requirements for prime awards. Further, internal controls over financial reporting were not operating effectively to file FFRs, reimbursement requests and progress reports in a timely manner. Effect: Failure to submit the FFATA reports by the end of the following month after sub-grant greater than $30,000 is awarded results in noncompliance with 2 CFR §170. Failure to submit the semi-annual FFR within the 30-day submission deadline results in noncompliance with 2 CFR §200.328. Additionally, failure to submit the reimbursement request and progress reports within the specified deadline results in a breach of contract with RCAP. Questioned Costs: Questioned costs were not identified.Perspective information: It is noted that the Organization has not established policies and procedures that will ensure that FFATA reports are submitted within the required timeline and therefore three out of three samples tested for this compliance requirement were not completed. Further, for the awards that the Organization was a prime recipient one out one sample tested from a population of two was submitted timely. For awards which the Organization is a subrecipient, three out of the nine samples tested from a population of thirty-six were not submitted within the specified timeline. Additionally, for awards which the Organization is a subrecipient, one out of two samples from a population of 12 were not submitted with the specified timeline. Non-compliance surrounding reporting was identified for the following awards during the fiscal 2023: Federal Agency Pass-Through Entity ALN Federal Award Name Award Year Department of Health and Human Services Direct 93.570 HHS RCD - SERCAP 9/30/2022 – 8/31/2023 United States Department of Agriculture Rural Community Assistance Partnership Inc. 10.761 Technitrain 2022-2023 9/1/2022 – 8/31/2023 United States Department of Agriculture Rural Community Assistance Partnership Inc. 10.761 Tribal 2022 - 2023 9/1/2022 – 8/31/2023 Environmental Protection Agency Rural Community Assistance Partnership Inc. 66.446 Training and Technical Assistance for Treatment Works 4/1/2022 – 9/30/2023 Repeat Finding: No similar finding was reported in the prior year. Recommendations: We recommend that management attend training related to federal grant requirements. We also recommend that management establish procedures to ensure that it meets FFATA requirements on a timely basis. The Organization should review its internal controls surrounding financial and progress reporting for each federal award and develop an effective reporting tracking system to allow the Organization to monitor and ensure reports are prepared and submitted within deadlines.
Criteria: In accordance with 2 CFR §170, prime awardees awarded a federal grant are required to file a Federal Funding Accountability and Transparency Act (FFATA) sub-award report by the end of the month following the month in which the prime awardee awards any sub-grant equal to or greater than $30,000. Further, the Organization is subject to reporting requirements for both financial and progress reporting. In accordance with 2 CFR §200.328, Federal Financial Reports (FFR) should be submitted based on frequency required by the terms and conditions. In instances were the Organization is a subrecipient, the grant agreement with the prime recipient Rural Community Assistance Partnership (RCAP), requires that in order to facilitate RCAP’s financial reporting requirements, the Organization is required to submit reimbursement request monthly within 10 days of the following month. Additionally, in accordance with the agreement with RCAP, in order to facilitate RCAP’s progress reporting requirements the Organization is required to submit data related to progress made within 12 days for quarterly reports under program 66.446 and a final narrative within 75 days from project close. The requirements for progress reports for program 10.761 are to be submitted within 15 days for quarterly reports and 45 days for final narrative. Condition: During the review of the reporting compliance requirement related to major program, it was determined that a FFATA reports were not filed by the Organization within the required period. Further, the Organization did not file a FFR report within the required deadline for a grant it is a prime recipient. For grants on which the Organization is a subrecipient, it was determined that reimbursement requests and progress reports were not submitted within the required deadline. Cause: Internal controls over financial reporting were not operating effectively to file the FFATA report a timely manner. Management was not aware of the FFATA requirements for prime awards. Further, internal controls over financial reporting were not operating effectively to file FFRs, reimbursement requests and progress reports in a timely manner. Effect: Failure to submit the FFATA reports by the end of the following month after sub-grant greater than $30,000 is awarded results in noncompliance with 2 CFR §170. Failure to submit the semi-annual FFR within the 30-day submission deadline results in noncompliance with 2 CFR §200.328. Additionally, failure to submit the reimbursement request and progress reports within the specified deadline results in a breach of contract with RCAP. Questioned Costs: Questioned costs were not identified.Perspective information: It is noted that the Organization has not established policies and procedures that will ensure that FFATA reports are submitted within the required timeline and therefore three out of three samples tested for this compliance requirement were not completed. Further, for the awards that the Organization was a prime recipient one out one sample tested from a population of two was submitted timely. For awards which the Organization is a subrecipient, three out of the nine samples tested from a population of thirty-six were not submitted within the specified timeline. Additionally, for awards which the Organization is a subrecipient, one out of two samples from a population of 12 were not submitted with the specified timeline. Non-compliance surrounding reporting was identified for the following awards during the fiscal 2023: Federal Agency Pass-Through Entity ALN Federal Award Name Award Year Department of Health and Human Services Direct 93.570 HHS RCD - SERCAP 9/30/2022 – 8/31/2023 United States Department of Agriculture Rural Community Assistance Partnership Inc. 10.761 Technitrain 2022-2023 9/1/2022 – 8/31/2023 United States Department of Agriculture Rural Community Assistance Partnership Inc. 10.761 Tribal 2022 - 2023 9/1/2022 – 8/31/2023 Environmental Protection Agency Rural Community Assistance Partnership Inc. 66.446 Training and Technical Assistance for Treatment Works 4/1/2022 – 9/30/2023 Repeat Finding: No similar finding was reported in the prior year. Recommendations: We recommend that management attend training related to federal grant requirements. We also recommend that management establish procedures to ensure that it meets FFATA requirements on a timely basis. The Organization should review its internal controls surrounding financial and progress reporting for each federal award and develop an effective reporting tracking system to allow the Organization to monitor and ensure reports are prepared and submitted within deadlines.
Item 2023‐003 Performance Reporting – Annual Project and Expenditure Report Coronavirus State and Local Fiscal Recovery Fund ALN# 21.027 U.S. Department of Treasury Grant period – Year ended September 30, 2023 Criteria – 2 CFR 200.303 requires the non‐Federal entity to “(a) establish and maintain effective internal controls over the Federal award that provides reasonable assurance that the non‐Federal entity is managing the Federal statutes, regulations, and the terms and conditions of the Federal award.” Grantees should have controls in place to ensure that required reporting requirements under the compliance supplement are satisfied. 2 CFR 200.328 requires the City to file the Annual Project and Expenditure Report under the Performance Reporting requirement of the grant. Condition – Adequate controls were not in place to ensure that annual reporting was filed in accordance with performance reporting requirements. Cause – Changes in leadership roles at the grantee led to a lack of sufficient controls over the communication of the reporting requirement to ensure the accuracy and completeness of performance reporting under the grant. Effect – Lack of notification of the reporting requirement could lead to disallowed costs. We noted that the annual report was subsequently submitted to the grantor. However, our audit disclosed no instances of unallowable costs. Questioned Costs – Not determinable. Recommendation – We recommend the strengthening of controls to ensure annual reporting required under the compliance supplement is performed in a timely manner. Management’s Response – The City will strengthen the controls in place to provide assurance that annual reporting is performed timely in accordance with program guidelines.
Finding 2023-003 Significant deficiency in internal controls over compliance related to reporting. Federal Agency: U.S. Department of Health and Human Services Program Title: Developmental Disabilities Basic Support and Advocacy Grants Assistance Listing Number: 93.630 Awards Number: 2201WAPADD-00 & 03; 2001WAPAPH-00 & 01 Award Period: 10/01/2021 - 9/30/2024 Criteria 2 U.S. Code of Federal Regulations (CFR) 200 Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) Subpart D section 2 CFR 200.328 (as codified by the Department of Health and Human Services [DHHS] in 45 CFR 75) requires accurate financial reporting to be submitted under the terms of the Federal award. Condition/Context For the year ended September 30, 2023, DRW submitted their required semi-annual SF-425 reporting for the reporting period ending September 30, 2023. Though the reporting was submitted timely, it contained inaccurate information related to the balance of their unused Program Income, excluding their unused balance of approximately $142,000. Effect/Potential Effect DRW did not comply with the accuracy reporting requirement as specific in 2 CFR 200.328 Questioned Costs Not applicable Cause DRW’s internal controls were not designed to ensure accurate reporting Repeat Finding Not applicable Recommendation We recommend that DRW implement internal controls to ensure required reporting includes accurate information. Views of Responsible Officials Management agrees with the finding and has provided the corrective action plan following the Single Audit Report.
Finding 2023-003 Significant deficiency in internal controls over compliance related to reporting. Federal Agency: U.S. Department of Health and Human Services Program Title: Developmental Disabilities Basic Support and Advocacy Grants Assistance Listing Number: 93.630 Awards Number: 2201WAPADD-00 & 03; 2001WAPAPH-00 & 01 Award Period: 10/01/2021 - 9/30/2024 Criteria 2 U.S. Code of Federal Regulations (CFR) 200 Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) Subpart D section 2 CFR 200.328 (as codified by the Department of Health and Human Services [DHHS] in 45 CFR 75) requires accurate financial reporting to be submitted under the terms of the Federal award. Condition/Context For the year ended September 30, 2023, DRW submitted their required semi-annual SF-425 reporting for the reporting period ending September 30, 2023. Though the reporting was submitted timely, it contained inaccurate information related to the balance of their unused Program Income, excluding their unused balance of approximately $142,000. Effect/Potential Effect DRW did not comply with the accuracy reporting requirement as specific in 2 CFR 200.328 Questioned Costs Not applicable Cause DRW’s internal controls were not designed to ensure accurate reporting Repeat Finding Not applicable Recommendation We recommend that DRW implement internal controls to ensure required reporting includes accurate information. Views of Responsible Officials Management agrees with the finding and has provided the corrective action plan following the Single Audit Report.
Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds (SLFRF) Assistance Listing Number: 21.027 Compliance Requirement: Reporting Federal Agency: Department of Treasury Criteria or Specific Requirement: In accordance with the Authoritative Requirement 2 CFR 200.328, 31 CFR section 35.4(c) Reporting and request for other information, and the Consolidated Appropriations Act, (CAA), grantees using SLFRF funds for the eligible uses provided in the 2023 CAA will be required to report on their uses of funds in their Project and Expenditure reports. Condition: Required submission of the Project and Expenditure report during fiscal year 2023 was not submitted prior to the reporting deadline. Questioned Costs: None Context: The City’s Project and Expenditure report was selected for testing and it was noted the City did not submit the required report prior to the reporting deadline. Effect: The City did not submit the required Project and Expenditure report by the reporting deadline as required by the Uniform Guidance. Cause: The City did not have adequate internal controls over reporting requirements to ensure that the required report was submitted prior to the reporting deadline. Identification as a Repeat Finding: N/A Recommendation: Management should implement policies and procedures to ensure required reports are completed and filed by their respective due date in accordance with the grant agreement and the Uniform Guidance. Views of Responsible Officials: We agree with the finding. See separate report for planned corrective actions.
Criteria or Specific Requirement 2 CFR 200.328 and 31 CFR section 35.4(c) requires submission of quarterly and annual project and expenditure reports which are due to the Department of Treasury 30 days after the end of each quarter and April 30th, of the year proceeding, respectively. The project and expenditure report contains specific instructions on how to complete the report. Within the project and expenditure report, ‘Expenditure Categories’ is a critical component to be completed by reporting “obligations” and “expenditures” on each project. As defined in the report, “obligation” is an order placed (such as a contract) and similar transactions that require payment; “expenditure” is when the service has been rendered or the good has been delivered to the entity, and payment is due. Condition Upon review and testing of the quarterly reports as submitted to the Department of Treasury, it was noted that amounts reported as expenditures for certain projects included amounts that were obligated but not yet incurred (service was not yet rendered or the good was not yet received) until a subsequent quarter. The expenditures as reported were allowable expenditures, but the timing of the expenditures was reported in the incorrect period. In addition, upon testing the expenditures as reported in the unadjusted schedule of expenditures of federal awards (the “schedule”), it was noted that $415,821 was improperly included as expenditures belonging to the fiscal year ended September 30, 2023. The expenditures identified were prematurely recorded in the general ledger since the equipment was not received until after year-end. The City’s schedule of expenditures of federal awards for the fiscal year ended September 30, 2023 required a correction to remove those amounts from the schedule and to add those amounts to the subsequent fiscal year’s schedule. Cause The Grants Administrator’s lack of understanding of the proper manner in which the obligations and expenditures are required to be reported in the quarterly reports resulted in expenditure amounts being reported in the incorrect quarters. The City’s year-end procedures did not identify certain necessary adjustments in a timely manner in order to remove capital outlay expenditures that were incorrectly recorded during the fiscal year ended September 30, 2023 and were incorrectly included in the unadjusted schedule of expenditures of federal awards. The Grants Administrator utilized the amounts recorded as expenditures in the accounting system to prepare the quarterly reports. Expenditures should be recorded in the City’s general ledger utilizing the date services are rendered and/or goods are received. Proper monthly review of the expenditure accounts should have led to identifying expenditures that were recorded but not yet incurred. Effect or Potential Effect The two conditions listed above resulted in differences between expenditure amounts as correctly adjusted and reported in the schedule of expenditures of federal awards, versus expenditure amounts as reported and submitted to the Department of Treasury in the quarterly reports. Future reports may be incorrectly completed if obligation amounts and expenditure amounts are not following the criteria to properly enter amounts in the quarterly reports. Questioned Costs None. Context During compliance testing of the reporting compliance requirement, it was noted that the total expenditures included in the schedule of expenditures of federal awards for the fiscal year ended September 30, 2023 did not agree to the total expenditures reported in the quarterly expenditure reports as submitted to the Department of Treasury for the same period. During testing of disbursements as included in the schedule of expenditures of federal awards for the major Federal program, and during internal control and compliance testing, it was noted there were two disbursements, amounting to a total of $415,821, recorded within accounts payable as capital outlay expenditures which were improperly recorded in the fiscal year ended September 30, 2023 and improperly included in the schedule of expenditures of federal awards. As evidenced by the invoice date and ship date within the invoices, the equipment was not shipped, and the equipment was not received by the City, until after year-end. The expenditures should be recorded and reported in the fiscal year ended September 30, 2023. Adjustments were made accordingly for proper recording, reporting, and presentation in the financial statements and schedule of expenditures of federal awards. Repeat Finding This is a variation of a prior year finding from 2022. See summary schedule of prior audit findings. Recommendation Management should ensure year-end closing procedures are completed in a timely manner and are sufficient to assure accounts and financial statements are prepared in accordance with GAAP. If properly prepared and recorded, the subledgers for expenditures by federal awards will be generated with accurate expenditure amounts for the fiscal year. Management should assess the risk associated with this condition and identify any additional processes that can be incorporated into their existing controls to improve the deficiency; such as, minimizing the likelihood of year-end material audit adjustments through review of transactions and balances for general propriety and accuracy within one month after year-end. Follow-up and inquiries can be made timely for any transactions for which proper recording is unclear to management, if any. The Grants Administrator should maintain an up-to-date listing of expenditures by award (for all federal, state, and local awards) and should communicate with the Finance Department on a monthly basis to review the listing and determine the proper period in which the expenditures should be recorded and presented. The Grants Administrator and Finance Department should prepare a reconciliation of the expenditures as reported in the schedule of expenditures of federal awards for the major Federal program for the fiscal year ended September 30, 2023, as well as expenditures incurred from October 1, 2023 through today, and compare to the expenditures as reported in all quarterly reports through September 30, 2023 and September 30, 2024. An analysis should be completed to determine the differences between the expenditures incurred by quarter versus expenditures as reported by quarter, and to determine the differences in total between expenditures incurred and expenditures reported in the quarterly and annual project and expenditure reports. The Grants Administrator should then review the Department of Treasury’s Project and Expenditure Report User Guide of State and Local Fiscal Recovery Funds, and/or contact the grantor, to determine if reports as previously submitted should be corrected for the timing difference, or to determine what the correct course of action should be.
Finding 2023-005 – REPORTING Type: Material Weakness in Internal Control/Noncompliance. Program: ALN 93.493 Congressional Directives Criteria: Pursuant to 2 CFR 200.328(c), “The recipient or subrecipient must submit financial reports as required by the Federal award.” According to the closeout requirements of the Federal award, recipients must, “Reconcile financial expenditures to the reported total disbursement and charges in PMS.” Condition: The CMHSP did not reconcile financial expenditures shown in the Federal Financial Report to the total disbursement and charges in PMS. Cause: This condition was caused by an insufficient internal control process for review and approval of grant reports. Effect: Federal share of expenditures listed on the Federal Financial Report were overstated by $361,981. Questioned Cost: None. Context: Amounts received as Federal reimbursement, as detailed in PMS, were supported by the books and records of the CMHSP. However, the final report of expenditures was overstated by $361,981. Recommendation: We recommend that the CMHSP review their internal controls and make necessary changes to ensure that reports adhere to the grant requirements. Management’s Resp: We are in agreement with this finding.
Finding 2023-004 – Reporting (Significant Deficiency and Noncompliance) Information on the federal program: U.S. Department of Education, Assistance listing # 84.425 Education Stabilization Fund Criteria: 2 CFR 200.328-300 establish requirements for designing and monitoring internal controls over reporting requirements of a non-federal entity. Controls should be implemented to ensure accurate and complete reporting compliance. Condition: We selected a sample of 2 reports submitted for the HEERF program during the year. For both the annual and quarterly report examined, there was no documentation of a control such as reviewing and approving the report prior to submission. In addition, the annual report programmatic data source documentation varied from the data reported for several items. Cause: The College had a team managing the COVID funds due to their unique nature. While they were contact with each other about the program and reports, documentation of a review and approval was not available. The annual report included programmatic accomplishments and the report provided to support the data had several variances. Effect: The College did not properly implement documentation of internal controls to ensure compliance with reporting requirements. Questioned Costs: None reported Recommendation: We recommend the College strengthen its policies and procedures surrounding grant reporting to include documentation of controls such as review and approvals to ensure documentation is retained to support compliance requirements. Views of Responsible Officials: See Management’s View and Corrective Action Plan included at the end of the report.
Information on the federal program: U.S. Department of the Treasury, Assistance listing # 21.027 COVID-19 Coronavirus State and Local Fiscal Recovery Funds Criteria: 2 CFR 200.328-300 establish requirements for designing and monitoring internal controls over reporting requirements of a non-federal entity. Controls should be implemented to ensure accurate and complete reporting compliance. The Coronavirus State and Local Fiscal Recovery Funds: Overview of the Final Rule establishes the specific requirements for ARPA fund reporting. Condition: We examined the annual Project and Expenditure report required. It was not filed within 30 days of specified year end as required. Cause: There had been no fund expenditures prior to December of 2022. Annual reporting requirements for ARPA funds is at March 30 year end. The City’s controls around reporting focus on fiscal quarter end and fiscal and calendar year end. This reporting period is not in the City’s normal reporting schedule and therefore was not addressed through the controls in place. Effect: The City did not timely fulfill the related reporting requirements. Questioned Costs: None reported. Recommendation: We recommend the City strengthen its policies and procedures surrounding grant reporting to include (at inception of each award) documentation of a schedule of reporting requirements, review, and approvals to ensure documentation is retained to support compliance requirements. Views of Responsible Officials: Management agrees with the finding. See Corrective Action Plan included at the end of the report.
U.S. Department of Justice Crime Victim Assistance – Assistance #16.575 #2023-008 – Major Federal Award Finding – Reporting Nature of Finding: Compliance Finding Reporting and Material Weakness in Internal Controls over Compliance This is a repeat of prior year finding #2022-006. Criteria/Condition: Federal regulations 2 CFR 200.328 - 200.329 provide that required reporting under the federal program must be completed timely and accurately. The federal award agreement includes specific report filing due dates. Segregation of duties is also a key element of internal controls, including controls over compliance, and involves processes whereby the activities of one employee are reviewed or checked by the activities of another individual, and avoids one employee having the ability to perform a transaction or process from beginning to end. We noted during testing of sixteen different required reports that five of these reports tested were not filed in a timely manner. There were also no review procedures in place surrounding these reports. Cause/Context: Controls were not in place to ensure timely reporting. Only one individual was involved in the reporting process for the reports. A total of five of the reports tested were submitted more than ten days late. Effect: A lack of controls could result in late or failed reporting. Recommendation: We recommend the Organization establish procedures and controls to ensure financial and performance reports are filed timely. Views of Responsible Officials and Planned Corrective Actions: The Organization will ensure that all federal award reports are filed in a timely manner. The Organization is in the process of posting a new position, Director of Grants and Compliance. The individual in this new role will be responsible for tracking report due dates and working with the individuals responsible for the content of these reports to ensure the information is accurate and on time. In situations where the Director of Grants and Compliance is responsible for gathering the data for required reporting, the data will be reviewed by either the CFO or CEO prior to submission of the report.
U.S. Department of Justice Crime Victim Assistance – Assistance #16.575 #2023-008 – Major Federal Award Finding – Reporting Nature of Finding: Compliance Finding Reporting and Material Weakness in Internal Controls over Compliance This is a repeat of prior year finding #2022-006. Criteria/Condition: Federal regulations 2 CFR 200.328 - 200.329 provide that required reporting under the federal program must be completed timely and accurately. The federal award agreement includes specific report filing due dates. Segregation of duties is also a key element of internal controls, including controls over compliance, and involves processes whereby the activities of one employee are reviewed or checked by the activities of another individual, and avoids one employee having the ability to perform a transaction or process from beginning to end. We noted during testing of sixteen different required reports that five of these reports tested were not filed in a timely manner. There were also no review procedures in place surrounding these reports. Cause/Context: Controls were not in place to ensure timely reporting. Only one individual was involved in the reporting process for the reports. A total of five of the reports tested were submitted more than ten days late. Effect: A lack of controls could result in late or failed reporting. Recommendation: We recommend the Organization establish procedures and controls to ensure financial and performance reports are filed timely. Views of Responsible Officials and Planned Corrective Actions: The Organization will ensure that all federal award reports are filed in a timely manner. The Organization is in the process of posting a new position, Director of Grants and Compliance. The individual in this new role will be responsible for tracking report due dates and working with the individuals responsible for the content of these reports to ensure the information is accurate and on time. In situations where the Director of Grants and Compliance is responsible for gathering the data for required reporting, the data will be reviewed by either the CFO or CEO prior to submission of the report.
U.S. Department of Justice Crime Victim Assistance – Assistance #16.575 #2023-008 – Major Federal Award Finding – Reporting Nature of Finding: Compliance Finding Reporting and Material Weakness in Internal Controls over Compliance This is a repeat of prior year finding #2022-006. Criteria/Condition: Federal regulations 2 CFR 200.328 - 200.329 provide that required reporting under the federal program must be completed timely and accurately. The federal award agreement includes specific report filing due dates. Segregation of duties is also a key element of internal controls, including controls over compliance, and involves processes whereby the activities of one employee are reviewed or checked by the activities of another individual, and avoids one employee having the ability to perform a transaction or process from beginning to end. We noted during testing of sixteen different required reports that five of these reports tested were not filed in a timely manner. There were also no review procedures in place surrounding these reports. Cause/Context: Controls were not in place to ensure timely reporting. Only one individual was involved in the reporting process for the reports. A total of five of the reports tested were submitted more than ten days late. Effect: A lack of controls could result in late or failed reporting. Recommendation: We recommend the Organization establish procedures and controls to ensure financial and performance reports are filed timely. Views of Responsible Officials and Planned Corrective Actions: The Organization will ensure that all federal award reports are filed in a timely manner. The Organization is in the process of posting a new position, Director of Grants and Compliance. The individual in this new role will be responsible for tracking report due dates and working with the individuals responsible for the content of these reports to ensure the information is accurate and on time. In situations where the Director of Grants and Compliance is responsible for gathering the data for required reporting, the data will be reviewed by either the CFO or CEO prior to submission of the report.
U.S. Department of Justice Crime Victim Assistance – Assistance #16.575 #2023-008 – Major Federal Award Finding – Reporting Nature of Finding: Compliance Finding Reporting and Material Weakness in Internal Controls over Compliance This is a repeat of prior year finding #2022-006. Criteria/Condition: Federal regulations 2 CFR 200.328 - 200.329 provide that required reporting under the federal program must be completed timely and accurately. The federal award agreement includes specific report filing due dates. Segregation of duties is also a key element of internal controls, including controls over compliance, and involves processes whereby the activities of one employee are reviewed or checked by the activities of another individual, and avoids one employee having the ability to perform a transaction or process from beginning to end. We noted during testing of sixteen different required reports that five of these reports tested were not filed in a timely manner. There were also no review procedures in place surrounding these reports. Cause/Context: Controls were not in place to ensure timely reporting. Only one individual was involved in the reporting process for the reports. A total of five of the reports tested were submitted more than ten days late. Effect: A lack of controls could result in late or failed reporting. Recommendation: We recommend the Organization establish procedures and controls to ensure financial and performance reports are filed timely. Views of Responsible Officials and Planned Corrective Actions: The Organization will ensure that all federal award reports are filed in a timely manner. The Organization is in the process of posting a new position, Director of Grants and Compliance. The individual in this new role will be responsible for tracking report due dates and working with the individuals responsible for the content of these reports to ensure the information is accurate and on time. In situations where the Director of Grants and Compliance is responsible for gathering the data for required reporting, the data will be reviewed by either the CFO or CEO prior to submission of the report.
U.S. Department of Justice Crime Victim Assistance – Assistance #16.575 #2023-008 – Major Federal Award Finding – Reporting Nature of Finding: Compliance Finding Reporting and Material Weakness in Internal Controls over Compliance This is a repeat of prior year finding #2022-006. Criteria/Condition: Federal regulations 2 CFR 200.328 - 200.329 provide that required reporting under the federal program must be completed timely and accurately. The federal award agreement includes specific report filing due dates. Segregation of duties is also a key element of internal controls, including controls over compliance, and involves processes whereby the activities of one employee are reviewed or checked by the activities of another individual, and avoids one employee having the ability to perform a transaction or process from beginning to end. We noted during testing of sixteen different required reports that five of these reports tested were not filed in a timely manner. There were also no review procedures in place surrounding these reports. Cause/Context: Controls were not in place to ensure timely reporting. Only one individual was involved in the reporting process for the reports. A total of five of the reports tested were submitted more than ten days late. Effect: A lack of controls could result in late or failed reporting. Recommendation: We recommend the Organization establish procedures and controls to ensure financial and performance reports are filed timely. Views of Responsible Officials and Planned Corrective Actions: The Organization will ensure that all federal award reports are filed in a timely manner. The Organization is in the process of posting a new position, Director of Grants and Compliance. The individual in this new role will be responsible for tracking report due dates and working with the individuals responsible for the content of these reports to ensure the information is accurate and on time. In situations where the Director of Grants and Compliance is responsible for gathering the data for required reporting, the data will be reviewed by either the CFO or CEO prior to submission of the report.
U.S. Department of Justice Crime Victim Assistance – Assistance #16.575 #2023-008 – Major Federal Award Finding – Reporting Nature of Finding: Compliance Finding Reporting and Material Weakness in Internal Controls over Compliance This is a repeat of prior year finding #2022-006. Criteria/Condition: Federal regulations 2 CFR 200.328 - 200.329 provide that required reporting under the federal program must be completed timely and accurately. The federal award agreement includes specific report filing due dates. Segregation of duties is also a key element of internal controls, including controls over compliance, and involves processes whereby the activities of one employee are reviewed or checked by the activities of another individual, and avoids one employee having the ability to perform a transaction or process from beginning to end. We noted during testing of sixteen different required reports that five of these reports tested were not filed in a timely manner. There were also no review procedures in place surrounding these reports. Cause/Context: Controls were not in place to ensure timely reporting. Only one individual was involved in the reporting process for the reports. A total of five of the reports tested were submitted more than ten days late. Effect: A lack of controls could result in late or failed reporting. Recommendation: We recommend the Organization establish procedures and controls to ensure financial and performance reports are filed timely. Views of Responsible Officials and Planned Corrective Actions: The Organization will ensure that all federal award reports are filed in a timely manner. The Organization is in the process of posting a new position, Director of Grants and Compliance. The individual in this new role will be responsible for tracking report due dates and working with the individuals responsible for the content of these reports to ensure the information is accurate and on time. In situations where the Director of Grants and Compliance is responsible for gathering the data for required reporting, the data will be reviewed by either the CFO or CEO prior to submission of the report.
2023-004 U.S. Department of Transportation Federal Financial Assistance Listing 20.106 Airport Improvement Grant 3-16-0018-048-2020, 3-16-0018-049-2021, 3-16-0018-054-2021, 3-16-0018-055-2021, 3-16-0018-056-2022 Compliance Requirement - Reporting Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR §200.328, Financial Reporting, mandates that information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly except in unusual circumstances. Condition: During our testing of the required annual reports, SF-425 report, it was noted some of the annual reports required to be submitted by December 31, 2022, were submitted late on January 3, 2023. Cause: During the period under audit, there was a changeover in personnel at the airport, including the individual who was responsible for reviewing and submitting the reports. Effect: The reports were submitted to and accepted by the FAA; however, they were late. Questioned Costs: None reported. Context/Sampling: Sampling was not used. 100% of the required reports were tested. Of the 11 reports required to be submitted by December 31, 2022, 5 of them were late. Repeat Finding from Prior Year(s): Yes, 2022-001 Recommendation: The City should review its current policies and processes to ensure that the controls operate effectively, even in the event of a change in personnel. Views of Responsible Officials: The City concurs with the auditor’s findings.
2023-004 U.S. Department of Transportation Federal Financial Assistance Listing 20.106 Airport Improvement Grant 3-16-0018-048-2020, 3-16-0018-049-2021, 3-16-0018-054-2021, 3-16-0018-055-2021, 3-16-0018-056-2022 Compliance Requirement - Reporting Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR §200.328, Financial Reporting, mandates that information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly except in unusual circumstances. Condition: During our testing of the required annual reports, SF-425 report, it was noted some of the annual reports required to be submitted by December 31, 2022, were submitted late on January 3, 2023. Cause: During the period under audit, there was a changeover in personnel at the airport, including the individual who was responsible for reviewing and submitting the reports. Effect: The reports were submitted to and accepted by the FAA; however, they were late. Questioned Costs: None reported. Context/Sampling: Sampling was not used. 100% of the required reports were tested. Of the 11 reports required to be submitted by December 31, 2022, 5 of them were late. Repeat Finding from Prior Year(s): Yes, 2022-001 Recommendation: The City should review its current policies and processes to ensure that the controls operate effectively, even in the event of a change in personnel. Views of Responsible Officials: The City concurs with the auditor’s findings.