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.
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.
Federal Agency: U. S. Department of Treasury AL No.: 21.027 Program Title: Coronavirus State and Local Fiscal Recovery Funds Area: Reporting Repeat Finding from Prior Audit? No Questioned Cost: $0.00 Criteria: Pursuant to 2 CFR 200.328, recipients of federal grants must submit performance reports that document project progress. These reports should compare actual accomplishments to established goals, explain any delays, and outline corrective actions. For construction projects, additional reporting is required, including project schedules, completion percentages, quality control documentation, and related materials. Additionally, 31 CFR Section 35.4(c) mandates that recipients of federal funds submit periodic reports as required by the awarding agency. Recipients must maintain accurate records supporting financial and performance reports and provide additional information upon request to ensure compliance with federal requirements. As specified in the grant award, recipients must submit quarterly progress reports by the end of the month following each quarter. Condition: For all four quarters, CUC prepared the quarterly reports; however, no assurance was provided as to whether the reports were submitted on time. Cause: The inability to confirm the timely submission of the reports stems from a lack of internal processes or tracking mechanisms to ensure that reports are submitted by the required deadlines. There was no systematic follow-up or verification to ensure compliance with reporting deadlines. Effect: The failure to ensure the timely submission of quarterly reports impacts the federal agency’s ability to effectively monitor and assess the project’s progress. It also creates a risk of noncompliance with federal guidelines, which could lead to delays in funding, increased scrutiny from the awarding agency, and potential administrative penalties. Recommendation: CUC should implement the following corrective actions: 1. Establish and enforce internal controls to ensure the timely preparation and submission of monthly progress reports. 2. Assign responsibility to a designated compliance officer to monitor and verify compliance with reporting requirements. 3. Develop a tracking system to document the submission and review of reports. 4. Provide training to project managers and relevant personnel on reporting obligations under 2 CFR 200.328 and 31 CFR35.4(c). 5. Implement corrective action steps for future noncompliance, including escalation procedures for late or missing reports. Views of the Officials: CUC’s response is documented in the corrective action plan.
Condition The required Annual Project and Expenditure (P & E) Report was submitted late. The report required for the year ended March 31, 2023, was due on April 30, 2023. Criteria 2 CFR 200.328 and 31 CFR section 35.4(c) required financial and performance reporting information. The 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, for example where more frequent reporting is necessary for the effective monitoring of the Federal award or could significantly affect program outcomes, and preferably in coordination with performance reporting. Context We request the report submitted during the fiscal year to be audited and observed the report was submitted after the due date. Cause The Municipality failed in submission of the required report on time due to lack of knowledge of requisites and instructions about the completion of the report. Effect The Municipality cannot comply with federal regulations; the evaluation of the federal funds use cannot be observed and monitored by the Agency. The situation could affect the program outcomes. Questioned Costs Not determined Recommendation We recommend the Municipality maintain the schedule of the due date of required reports.
Condition The required Annual Project and Expenditure (P & E) Report was submitted late. The report required for the year ended March 31, 2023, was due on April 30, 2023. Criteria 2 CFR 200.328 and 31 CFR section 35.4(c) required financial and performance reporting information. The 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, for example where more frequent reporting is necessary for the effective monitoring of the Federal award or could significantly affect program outcomes, and preferably in coordination with performance reporting. Context We request the report submitted during the fiscal year to be audited and observed the report was submitted after the due date. Cause The Municipality failed in submission of the required report on time due to lack of knowledge of requisites and instructions about the completion of the report. Effect The Municipality cannot comply with federal regulations; the evaluation of the federal funds use cannot be observed and monitored by the Agency. The situation could affect the program outcomes. Questioned Costs Not determined Recommendation We recommend the Municipality maintain the schedule of the due date of required reports.
2023-003 Department of Justice and State of South Dakota Department of Public Safety FFAL #16.575, 2022-COMBO-00022 Crime Victim Assistance Reporting Material Weakness in Internal Control over Compliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal controls over the federal awards that provide assurance that the entity is managing the federal awards in compliance with federal statutes, regulations, and the conditions of the federal award. 2 CFR 200.327 and 2 CFR 200.328 require the auditee to collect financial information and monitor its activities under federal awards to assure compliance with applicable federal requirements and performance expectations are being achieved and report these items in accordance with the program requirements. Condition: The Victims’ Service final financial report was not completed and submitted until requested by the auditors. Cause: There was a lapse in the Organization’s internal control process ensuring reporting requirements were fulfilled timely. Effect: Lack of compliance with designed internal controls over reporting could result in the Organization reporting incorrect or incomplete information. Questioned Costs: None reported. Context/Sampling: A nonstatistical sample of 6 reports out of 10 reports. Repeat Finding from Prior Year(s): No Recommendation: We recommend management review internal control procedures over reporting to ensure reporting requirements are completed and submitted timely.
Finding: 2023-002 Program Affected: COVID-19 Higher Education Emergency Relief Fund (HEERF) (AL Number 84.425E) Finding Type: Significant deficiency on internal control Criteria: The HEERF I, II, and III funding came with various requirements instituted by the CARES Act, CRRSAA, and ARP and then further defined by the US Department of Education (ED). The ED exercised its reporting authority under 2 CFR section 200.328 and 2 CFR section 200.329 to define three reporting requirements for the HEERF program funds, which include 1) public reporting on the (a)(1) Student Aid Portion; 2) public reporting on the (a)(1) Institutional Portion (a)(2) and (a)(3) subprograms (Quarterly Reporting Form), as applicable; and 3) the annual report. These reporting requirements stipulate specific guidelines regarding when, how, and what information is to be reported on quarterly and the annual reports. Condition: Per review of the University’s annual report, we noted three instances where the amounts and information reported did not agree to the internal records. Issues noted included incorrect amounts and information posted for the Emergency Financial Aid grants, monitoring and suppressing coronavirus, and total of institutional annual expenditures. Cause: Reporting requirements posted by the Department of Education for HEERF program funds have continuously changed with the intent to be made clearer with each subsequent revision. However, it is difficult to draw conclusions on some of the reporting guidance. There were not adequate controls nor review processes in place to monitor the reporting requirements issued by the Department of Education to ensure the annual report was posted accurately. Effect: The effect or possible effect is that the University may be determined ineligible to receive future HEERF program funding. Additionally, the program does not have accurate information regarding how HEERF program funds were expended by the University. Questioned Costs: None Recommendation: Controls should be established to allow for a second detailed review of all reporting of HEERF program funds by an official extensively familiar with the reporting requirements published by the Department of Education and other regulators. Auditee's Response: The reports will be monitored more closely going forward. See attached corrective action plan.
Department of Education COVID-19 Higher Education Emergency Relief Fund (HEERF) – Assistance Listing #84.425E, #84.425F #2023-003 – Major Federal Award Finding – Reporting Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-003. Conditions: We noted during testing of two quarterly reports and one annual report required under the HEERF program that the two quarterly reports selected for testing were not filed timely. There were also no review procedures in place surrounding these quarterly reports. In addition, some inaccuracies were noted within the annual reporting. Criteria: Federal regulations 2 CFR Section 200.328 - 200.329 provide that required reporting under the federal program must be completed timely and accurately. The quarterly reports for institutional and student aid are required to be updated and posted to the website within 10 days of the end of the quarter. 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. Cause/Context: The University did not meet the reporting deadline requirements set forth by the Department of Education for the HEERF program. Only one individual was involved in the reporting process for the quarterly reports. There is a higher likelihood of errors going undetected in the absence of monitoring and review. Inaccuracies were noted in the amounts reported in the 2022 calendar annual report for HEERF student disbursements and institutional expenditures. Recommendation: Management should review the University’s practices related to reporting under the HEERF program to ensure that reports are submitted timely and that more than one individual is involved in the reporting process. Management should also submit a revision of the HEERF calendar 2022 annual report once the reporting portal is reopened by the Department of Education. Views of Responsible Officials and Planned Corrective Actions: The University agrees with the recommendations put forth by the auditors. The University will submit a revised report for the 2022 calendar year and will put a procedure in place to ensure that all reports are reviewed prior to submission. See also attached Corrective Action Plan.
Department of Education COVID-19 Higher Education Emergency Relief Fund (HEERF) – Assistance Listing #84.425E, #84.425F #2023-003 – Major Federal Award Finding – Reporting Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-003. Conditions: We noted during testing of two quarterly reports and one annual report required under the HEERF program that the two quarterly reports selected for testing were not filed timely. There were also no review procedures in place surrounding these quarterly reports. In addition, some inaccuracies were noted within the annual reporting. Criteria: Federal regulations 2 CFR Section 200.328 - 200.329 provide that required reporting under the federal program must be completed timely and accurately. The quarterly reports for institutional and student aid are required to be updated and posted to the website within 10 days of the end of the quarter. 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. Cause/Context: The University did not meet the reporting deadline requirements set forth by the Department of Education for the HEERF program. Only one individual was involved in the reporting process for the quarterly reports. There is a higher likelihood of errors going undetected in the absence of monitoring and review. Inaccuracies were noted in the amounts reported in the 2022 calendar annual report for HEERF student disbursements and institutional expenditures. Recommendation: Management should review the University’s practices related to reporting under the HEERF program to ensure that reports are submitted timely and that more than one individual is involved in the reporting process. Management should also submit a revision of the HEERF calendar 2022 annual report once the reporting portal is reopened by the Department of Education. Views of Responsible Officials and Planned Corrective Actions: The University agrees with the recommendations put forth by the auditors. The University will submit a revised report for the 2022 calendar year and will put a procedure in place to ensure that all reports are reviewed prior to submission. See also attached Corrective Action Plan.
Type of Finding – Significant Deficiency in Internal Control Over Compliance Condition/Context – Internal control procedures over reporting requirements did not ensure compliance with federal awards. The reports prepared by the Director of Grant Compliance and Procurement are not reviewed and approved before being submitted. Criteria – In accordance with Uniform Guidance, 2 CFR 200.328(i) requires that an entity implements control over the performance and financial reporting. 2 CFR 200.303(a) requires an entity to establish and maintain effective internal control over the Federal awards that provides reasonable assurance that the entity is managing the award in compliance with Federal statutes. Cause – Clerical oversight. Effect – Noncompliance with the Compliance Supplement and Uniform Guidance. Repeat Finding – No Questioned Costs – None Recommendation – The Organization implements a review and approval process over the performance and financial reports. View of Responsible Officials - There is no disagreement with the audit findings.
Type of Finding – Significant Deficiency in Internal Control Over Compliance Condition/Context – Internal control procedures over reporting requirements did not ensure compliance with federal awards. The reports prepared by the Director of Grant Compliance and Procurement are not reviewed and approved before being submitted. Criteria – In accordance with Uniform Guidance, 2 CFR 200.328(i) requires that an entity implements control over the performance and financial reporting. 2 CFR 200.303(a) requires an entity to establish and maintain effective internal control over the Federal awards that provides reasonable assurance that the entity is managing the award in compliance with Federal statutes. Cause – Clerical oversight. Effect – Noncompliance with the Compliance Supplement and Uniform Guidance. Repeat Finding – No Questioned Costs – None Recommendation – The Organization implements a review and approval process over the performance and financial reports. View of Responsible Officials - There is no disagreement with the audit findings.
Type of Finding – Significant Deficiency in Internal Control Over Compliance Condition/Context – Internal control procedures over reporting requirements did not ensure compliance with federal awards. The reports prepared by the Director of Grant Compliance and Procurement are not reviewed and approved before being submitted. Criteria – In accordance with Uniform Guidance, 2 CFR 200.328(i) requires that an entity implements control over the performance and financial reporting. 2 CFR 200.303(a) requires an entity to establish and maintain effective internal control over the Federal awards that provides reasonable assurance that the entity is managing the award in compliance with Federal statutes. Cause – Clerical oversight. Effect – Noncompliance with the Compliance Supplement and Uniform Guidance. Repeat Finding – No Questioned Costs – None Recommendation – The Organization implements a review and approval process over the performance and financial reports. View of Responsible Officials - There is no disagreement with the audit findings.
2023-001 Internal Control over Compliance and Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards (SEFA)) Information on the Major Federal Program: Department of Homeland Security Federal Emergency Management Agency Federal Assistance Listing Number: 97.024 Federal Assistance Listing Name: Emergency Food and Shelter National Board Program Pass-through Awards under the Uniform Guidance Requirements: Pass-through Entity Award Name Award Period The United Way SE Family Center DC Phase 39 November 1, 2021 to April 30, 2023 The United Way SE Family Center DC ARPAR November 1, 2021 to April 30, 2023 The United Way Mont. Co Family Center Phase 39 November 1, 2021 to April 30, 2023 The United Way Mont. Co Family Center ARPAR November 1, 2021 to April 30, 2023 The United Way Parish Partners PG Co Phase 39 November 1, 2021 to April 30, 2023 The United Way Parish Partners PG Co ARPAR November 1, 2021 to April 30, 2023 The United Way Parish Partners Calvert Co ARPAR November 1, 2021 to April 30, 2023 The United Way Parish Partners Charles Co ARPAR November 1, 2021 to April 30, 2023 The United Way Angel’s Watch Charles Co ARPAR November 1, 2021 to April 30, 2023 The United Way St. Josephine’s Shelter DC ARPAR November 1, 2021 to April 30, 2023 The United Way Adam’s Place Shelter DC ARPAR November 1, 2021 to April 30, 2023 The United Way SMFB ARPAR November 1, 2021 to April 30, 2023 The United Way SCC Food Pantry Phase 39 November 1, 2021 to April 30, 2023 The United Way SCC Food Pantry ARPAR November 1, 2021 to April 30, 2023 The United Way Phase HR22 April 13, 2022 to July 7, 2022 Criteria: Title 2 U.S. Code of Federal Regulations Part 200 (2 CFR part 200) Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” The schedule must provide total Federal awards expended for each individual Federal program. In accordance with §200.302 Financial Management, a non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for the following: (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §200.327 Financial Reporting and §200.328 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for Federally-funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets.
2023-001 Internal Control over Compliance and Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards (SEFA)) Information on the Major Federal Program: Department of Homeland Security Federal Emergency Management Agency Federal Assistance Listing Number: 97.024 Federal Assistance Listing Name: Emergency Food and Shelter National Board Program Pass-through Awards under the Uniform Guidance Requirements: Pass-through Entity Award Name Award Period The United Way SE Family Center DC Phase 39 November 1, 2021 to April 30, 2023 The United Way SE Family Center DC ARPAR November 1, 2021 to April 30, 2023 The United Way Mont. Co Family Center Phase 39 November 1, 2021 to April 30, 2023 The United Way Mont. Co Family Center ARPAR November 1, 2021 to April 30, 2023 The United Way Parish Partners PG Co Phase 39 November 1, 2021 to April 30, 2023 The United Way Parish Partners PG Co ARPAR November 1, 2021 to April 30, 2023 The United Way Parish Partners Calvert Co ARPAR November 1, 2021 to April 30, 2023 The United Way Parish Partners Charles Co ARPAR November 1, 2021 to April 30, 2023 The United Way Angel’s Watch Charles Co ARPAR November 1, 2021 to April 30, 2023 The United Way St. Josephine’s Shelter DC ARPAR November 1, 2021 to April 30, 2023 The United Way Adam’s Place Shelter DC ARPAR November 1, 2021 to April 30, 2023 The United Way SMFB ARPAR November 1, 2021 to April 30, 2023 The United Way SCC Food Pantry Phase 39 November 1, 2021 to April 30, 2023 The United Way SCC Food Pantry ARPAR November 1, 2021 to April 30, 2023 The United Way Phase HR22 April 13, 2022 to July 7, 2022 Criteria: Title 2 U.S. Code of Federal Regulations Part 200 (2 CFR part 200) Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” The schedule must provide total Federal awards expended for each individual Federal program. In accordance with §200.302 Financial Management, a non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system of each non-Federal entity must provide for the following: (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §200.327 Financial Reporting and §200.328 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for Federally-funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets.