Criteria: In accordance with 2 CFR 200.328 and 2 CFR 200.329, the College is required to prepare and publicly post quarterly reports related to the student aid and institutional portions of HEERF expenditures. Condition: During our audit, we selected one of the four quarterly reports to test the accuracy of the reporting. Our testing indicated certain amounts on the quarterly report that did not agree to the expenditures for the quarter. Questioned Costs: None Effect: The College was not in compliance with HEERF reporting requirements. Cause: Certain HEERF I expenditures were improperly excluded from the report and some misunderstanding of requirements of certain items in the report. Recommendation: We recommend reconciliation of quarterly reports to related grant documentation and review of the reports by an appropriate team member to ensure accuracy. Views of responsible officials and planned corrective action: The College agrees with this finding and will adhere to the corrective action plan on page 34 in this audit report.
Criteria: In accordance with 2 CFR 200.328 and 2 CFR 200.329, the College is required to prepare and publicly post quarterly reports related to the student aid and institutional portions of HEERF expenditures. Condition: During our audit, we selected one of the four quarterly reports to test the accuracy of the reporting. Our testing indicated certain amounts on the quarterly report that did not agree to the expenditures for the quarter. Questioned Costs: None Effect: The College was not in compliance with HEERF reporting requirements. Cause: Certain HEERF I expenditures were improperly excluded from the report and some misunderstanding of requirements of certain items in the report. Recommendation: We recommend reconciliation of quarterly reports to related grant documentation and review of the reports by an appropriate team member to ensure accuracy. Views of responsible officials and planned corrective action: The College agrees with this finding and will adhere to the corrective action plan on page 34 in this audit report.
2 CFR § 300.1 states the Department of Health and Human Services adopts the Office of Management and Budget (OMB) Guidance in 2 CFR part 200, and has codified the text, with HHS-specific amendments in 45 CFR part 75. Thus, this part gives regulatory effect to the OMB guidance and supplements the guidance as needed for the Department. 2 CFR § 200.329(a) states the non-Federal entity is responsible for oversight of the operations of the Federal award supported activities. The non-Federal entity must monitor its activities under Federal awards to assure compliance with applicable Federal requirements and performance expectations are being achieved. Monitoring by the non-Federal entity must cover each program, function or activity. 45 CFR § 75.302(a) states each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other 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. Section (b) states, in part, 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. Federal program and Federal award identification must include, as applicable, the CFDA title and number, Federal award identification number and year, name of the HHS awarding agency, and name of the pass-through entity, if any. (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 §§ 75.341 and 75.342. (3) Records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. (4) Effective control over, and accountability for, all funds, property, and other assets. The non-Federal entity must adequately safeguard all assets and assure that they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 75.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E of this part and the terms and conditions of the Federal award. The COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution program is administered by the Health Resources and Services Administration (HRSA) and supports eligible health care providers in the battle against the COVID-19 pandemic by providing relief funds to eligible providers of health care services and support for health care-related expenses or lost revenues attributable to coronavirus. PRF recipients must only use payments for eligible expenses. 2022 OMB Compliance Supplement, Part 4, 93.498. Providers who accepted PRF and/or ARP payment(s) agreed to the Terms and Conditions of the program, which include a requirement to report on the use of the funds. See Reporting and Auditing, Health Resources & Services Administration, https://www.hrsa.gov/provider-relief/reporting-auditing. Entities receiving PRF funds are required to submit financial and other information in the Provider Relief Fund Reporting Portal. The PRF amounts to be reported on the County’s Schedule of Expenditures of Federal Awards (SEFA) are based on the PRF report. 2022 OMB Compliance Supplement. Reporting Entities are required to maintain adequate documentation to substantiate that the PRF funds were used for health care-related expenses or lost revenues that are attributable to coronavirus and COVID-19. See PRB Reporting and Auditing FAQ, Health Resources & Services Administration, https://www.hrsa.gov/provider-relief/faq/reporting?categories=210&keywords= . Logan County Logan Acres Care Center Department (the Center) completed and submitted its PRF report based solely on the amounts received; however, the Center did not submit and maintain detailed, complete financial records on the actual expenditures of the PRF funds. As a result, the exact expenditures associated with the grant were unidentifiable which was contrary to the requirements imposed on recipients of PRF funds. Logan County Logan Acres Care Center Department should implement procedures to verify grants are separately accounted for with respect to receipts and expenditures. Failure to maintain detailed financial records can result in unallowable federal grant expenditures and/or reimbursements to the grantor.
2 CFR 1000.10 provides that, except for the deviations set forth elsewhere in this Part, the Department of Treasury adopts the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards set forth at 2 CFR Part 200. 2 CFR 200.302(b) states, in part, that the financial management system of each non-Federal entity must provide for the 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.328 and 200.329. The City did not have proper internal controls in place to ensure the accurate submission of the Project and Expenditure Reports. During testing of Project and Expenditure Reports for the Coronavirus State and Local Fiscal Recovery Funds (AL #21.027), we noted that: ? The City did not properly report cumulative obligations on the report required by July 31, 2022. The City over-reported cumulative obligations due to including a funding project more than once for $880,000 to the Justice Center Design project; and ? The City did not properly report cumulative obligations nor current period expenditures on the report required by October 31, 2022. The City over-reported cumulative obligations by $880,000 due to including a funding project more than once to the Justice Center Design project. The City also over-reported current period expenditures due to including the current period expenditures of $175,741 for a funding project more than once to Rehiring Staff project. Failure to have the proper controls in place to ensure the timely and accurate submission of the Project and Expenditure Reports could result in Treasury taking action against the City for failure to comply with programmatic requirements. The City should implement and have controls in place to ensure the quarterly Project and Expenditure Reports are accurate.
2 CFR 1000.10 provides that, except for the deviations set forth elsewhere in this Part, the Department of Treasury adopts the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards set forth at 2 CFR Part 200. 2 CFR 200.302(b) states, in part, that the financial management system of each non-Federal entity must provide for the 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.328 and 200.329. The City did not have proper internal controls in place to ensure the accurate submission of the Project and Expenditure Reports. During testing of Project and Expenditure Reports for the Coronavirus State and Local Fiscal Recovery Funds (AL #21.027), we noted that: ? The City did not properly report cumulative obligations on the report required by July 31, 2022. The City over-reported cumulative obligations due to including a funding project more than once for $880,000 to the Justice Center Design project; and ? The City did not properly report cumulative obligations nor current period expenditures on the report required by October 31, 2022. The City over-reported cumulative obligations by $880,000 due to including a funding project more than once to the Justice Center Design project. The City also over-reported current period expenditures due to including the current period expenditures of $175,741 for a funding project more than once to Rehiring Staff project. Failure to have the proper controls in place to ensure the timely and accurate submission of the Project and Expenditure Reports could result in Treasury taking action against the City for failure to comply with programmatic requirements. The City should implement and have controls in place to ensure the quarterly Project and Expenditure Reports are accurate.
2 CFR 1000.10 provides that, except for the deviations set forth elsewhere in this Part, the Department of Treasury adopts the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards set forth at 2 CFR Part 200. 2 CFR 200.302(b) states, in part, that the financial management system of each non-Federal entity must provide for the 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.328 and 200.329. The City did not have proper internal controls in place to ensure the accurate submission of the Project and Expenditure Reports. During testing of Project and Expenditure Reports for the Coronavirus State and Local Fiscal Recovery Funds (AL #21.027), we noted that: ? The City did not properly report cumulative obligations on the report required by July 31, 2022. The City over-reported cumulative obligations due to including a funding project more than once for $880,000 to the Justice Center Design project; and ? The City did not properly report cumulative obligations nor current period expenditures on the report required by October 31, 2022. The City over-reported cumulative obligations by $880,000 due to including a funding project more than once to the Justice Center Design project. The City also over-reported current period expenditures due to including the current period expenditures of $175,741 for a funding project more than once to Rehiring Staff project. Failure to have the proper controls in place to ensure the timely and accurate submission of the Project and Expenditure Reports could result in Treasury taking action against the City for failure to comply with programmatic requirements. The City should implement and have controls in place to ensure the quarterly Project and Expenditure Reports are accurate.
2022-002 ? SIGNIFICANT DEFICIENCY ? Internal Controls over Reporting U.S. Department of Treasury ? Passed through the State of Alabama Department of Treasury ? COVID 19 Coronavirus State and Local Fiscal Recovery Fund ? ALN #21.027 ? Program Year 2022 Criteria ? Per 2 CFR Subpart D - 200.329(a), non-federal entities are responsible for oversight of the operations of federal award supported activities and must monitor its activities under federal awards to assure compliance with applicable federal requirements and performance expectations are being achieved. In addition, per CFR 200.303(a), non-federal entities are required to establish and maintain effective internal controls over federal awards. Condition ? The Foundation did not maintain supporting documentation of the proper review and approval of the required final report for the federal award program. Cause ? Appropriate policies and procedures were not implemented by the Foundation to maintain documentation of the review and approval of the final report for the federal award program. Effect ? Lack of documentation of monitoring could lead to improper monitoring of federal award activity and possible misuse of funds. Questioned Costs ? None Auditors? Recommendation ? Policies and procedures should be designed, implemented, and monitored to ensure that documentation is maintained for the Foundation?s monitoring of its federal award program in accordance with federal award requirements. Management response and current status ? See management corrective action plan
FINDING 2022-004 Subject: Staffing for Adequate Fire and Emergency Response (SAFER) - Cash Management Federal Agency: Department of Homeland Security Federal Program: Staffing for Adequate Fire and Emergency Response (SAFER) Assistance Listings Number: 97.083 Federal Award Number and Year (or Other Identifying Number): EMW-2019-FF-00944 Compliance Requirement: Cash Management Audit Findings: Material Weakness, Modified Opinion Condition and Context The Township submits request for reimbursements to the Federal Emergency Management Agency of the Department of Homeland Security. The reimbursement method of cash management requires the Township to retain supporting documentation that shows the costs for which reimbursement was requested were paid prior to the reimbursement date. The Township was awarded a SAFER grant to increase the number of firefighters and was approved for personnel and fringe benefits costs, which includes health insurance, for nine additional firefighters. The Township is self-insured and would make payments to third-party administrators and other benefit coordinators. The Township would pay a large dollar amount at the end of each year to its selfinsurance benefit coordinators for the next year's benefit, and then additional payments throughout the year as needed for employee's medical claim coverage. These payments were made from various Township funds and the Payroll Deductions fund. Additionally, the payroll deductions for health insurance, including those for employees paid from the grant, would accumulate in the Payroll Deductions fund, and be used for payments to the benefit coordinators as needed and the payment of the next year's required funding. The amount submitted for reimbursement for health insurance benefits were based upon a calculation. The Township did not have supporting documentation for the calculation of those benefits that were claimed. In addition, the health insurance benefits claimed for reimbursement were not paid out of the SAFER Grant Fund and were not at a transaction level in the ledger. The health insurance benefit submitted for reimbursement could not be tied to a specific payment; thus, we were unable to determine the Township's compliance for the health benefit reimbursements being incurred and paid prior to the Township's request for reimbursement. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302 states in part: "(a) Each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other 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. See also ? 200.450. (b) The financial management system of each non-Federal entity must provide for the following (see also ?? 200.334, 200.335, 200.336, and 200.337): (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number and year, name of the Federal agency, and name of the pass-through entity, if any. (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.328 and 200.329. If a Federal awarding agency requires reporting on an accrual basis from a recipient that maintains its records on other than an accrual basis, the recipient must not be required to establish an accrual accounting system. This recipient may develop accrual data for its reports on the basis of an analysis of the documentation on hand. Similarly, a pass-through entity must not require a subrecipient to establish an accrual accounting system and must allow the subrecipient to develop accrual data for its reports on the basis of an analysis of the documentation on hand. (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. (4) Effective control over, and accountability for, all funds, property, and other assets. The non-Federal entity must adequately safeguard all assets and assure that they are used solely for authorized purposes. See ? 200.303. . . ." Cause A system of internal controls was not designed or implemented by management of the Township which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect management's expectation of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, health insurance benefits were requested for reimbursement without adequate supporting documentation that the amount was paid prior to the request. Noncompliance with the grant agreement and the cash management compliance requirement could result in the loss of future federal funds to the Township. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the Township establish a proper system of internal controls and develop policies and procedures to ensure expenses are paid prior to requesting reimbursement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-005 Subject: Staffing for Adequate Fire and Emergency Response (SAFER) - Reporting Federal Agency: Department of Homeland Security Federal Program: Staffing for Adequate Fire and Emergency Response (SAFER) Assistance Listings Number: 97.083 Federal Award Number and Year (or Other Identifying Number): EMW-2019-FF-00944 Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context Recipients are required to submit Reimbursement Requests, Quarterly Performance Reports, and Semi-Annual SF-425 Federal Financial Reports to the Federal Emergency Management Agency (FEMA). The reporting periods, as well as the respective due dates are based on the calendar year, and recipients must begin to submit reports in the period following the beginning of their period of performance, and throughout the entire period of performance of the grant. Information to be reported includes expenditures for the appropriate reporting period. The Township submitted five reimbursement requests during the audit period. The Director of Finance prepared a sheet with the payroll and benefit amounts to be submitted for reimbursement and provided it to the Assistant Fire Chief. The reimbursement request was filed by the Assistant Fire Chief, without a review or oversight process in place to prevent, or detect and correct, errors and ensure compliance with the reporting compliance requirement. Additionally, the Township did not have a system of internal controls in place to ensure submission of required reports. The Township did not submit the Semi-Annual SF-425 Federal Financial Report that was due by July 30, 2022, or the four Quarterly Performance Reports that were due during the audit period. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.329 states in part: ". . . (b) Reporting program performance. The Federal awarding agency must use OMBapproved common information collections, as applicable, when providing financial and performance reporting information. As appropriate and in accordance with above mentioned information collections, the Federal awarding agency must require the recipient to relate financial data and accomplishments to performance goals and objectives of the Federal award. Also, in accordance with above mentioned common information collections, and when required by the terms and conditions of the Federal award, recipients must provide cost information to demonstrate cost effective practices (e.g., through unit cost data). In some instances (e.g., discretionary research awards), this will be limited to the requirement to submit technical performance reports (to be evaluated in accordance with Federal awarding agency policy). Reporting requirements must be clearly articulated such that, where appropriate, performance during the execution of the Federal award has a standard against which non-Federal entity performance can be measured. (c) Non-construction performance reports. The Federal awarding agency must use standard, governmentwide OMB-approved data elements for collection of performance information including performance progress reports, Research Performance Progress Reports. (1) The non-Federal entity must submit performance reports at the interval required by the Federal awarding agency or pass-through entity to best inform improvements in program outcomes and productivity. Intervals must be no less frequent than annually nor more frequent 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. Reports submitted annually by the non- Federal entity and/or pass-through entity must be due no later than 90 calendar days after the reporting period. Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. Alternatively, the Federal awarding agency or pass-through entity may require annual reports before the anniversary dates of multiple year Federal awards. The final performance report submitted by the non-Federal entity and/or pass-through entity must be due no later than 120 calendar days after the period of performance end date. A subrecipient must submit to the pass-through entity, no later than 90 calendar days after the period of performance end date, all final performance reports as required by the terms and conditions of the Federal award. See also ? 200.344. If a justified request is submitted by a non-Federal entity, the Federal agency may extend the due date for any performance report. . . ." Cause A system of internal controls was not designed or implemented by management of the Township which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be controls consisting of policies and procedures. Policies reflect the management's expectation of what should be done to effect internal control, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reimbursement requests were completed and filed by one individual and the Semi-Annual SF-425 Federal Financial Report and the four Quarterly Performance Reports due during the audit period were not submitted as required. Noncompliance with the grant agreement and the reporting compliance requirement could result in the loss of future federal funds to the Township. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the Township design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place over reimbursement requestions. In addition, we recommended that management of the Township establish a proper system of internal controls and develop policies and procedures to ensure that all required reports are filed. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-004 Subject: Staffing for Adequate Fire and Emergency Response (SAFER) - Reporting Federal Agency: Department of Homeland Security Federal Program: Staffing for Adequate Fire and Emergency Response (SAFER) Assistance Listings Number: 97.083 Federal Award Numbers and Years (or Other Identifying Numbers): EMW-2017-FH-00374, EMW-2019-FF-01116 Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context Recipients are required to submit Reimbursement Requests, Quarterly Performance Reports, and Semi-Annual SF-425 Federal Financial Reports to the Federal Emergency Management Agency (FEMA). The reporting periods, as well as the respective due dates, are based on the calendar year, and recipients must begin to submit reports in the period following the beginning of their period of performance, and throughout the entire period of performance of the grant. Information to be reported includes expenditures for the appropriate reporting period. Reimbursement Requests The District submitted seven Reimbursement Requests during the audit period. The Financial Coordinator prepared a sheet with the payroll and benefit amounts to be submitted for reimbursement and provided it to the Fire Chief. The Reimbursement Requests were filed by the Fire Chief without a review or oversight process in place to prevent, or detect and correct, errors. Quarterly and Programmatic Performance Reports and Semi-Annual SF-425 Federal Financial Reports EMW-2017-FH-00374 (2017 grant) The District had not implemented or designed a system of internal controls to ensure submission of the Quarterly Performance Reports (quarterly reports) or the Semi-Annual SF-425 Federal Financial Reports. During the audit period, the District was required to submit three quarterly reports and two semi-annual reports. The submission dates for the three quarterly reports could not be determined. Additionally, the District did not submit the Semi-Annual SF-425 Federal Financial Reports that were due by January 30, 2022, and July 30, 2022, in a timely manner. The two reports due were submitted 18 and 19 days late, respectively. EMW-2019-FF-01116 (2019 grant) The District had not implemented or designed a system of internal controls to ensure submission of the Programmatic Performance Report (PPR) or the Semi-Annual SF-425 Federal Financial Report (semi-annual report). During the audit period, the District was required to submit one PPR and two semi-annual reports. The submission date for the PPR, that was due April 30, 2022, could not be determined. In addition, the District did not submit the semi-annual reports that were due by January 30, 2022, and July 30, 2022, in a timely manner. The two reports were submitted 30 and 13 days late, respectively. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.329(c)(1) states in part: "The non-Federal entity must submit performance reports at the interval required by the Federal awarding agency or pass-through entity to best inform improvements in program outcomes and productivity. Intervals must be no less frequent than annually nor more frequent 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. Reports submitted annually by the non-Federal entity and/or pass-through entity must be due no later than 90 calendar days after the reporting period. Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. Alternatively, the Federal awarding agency or pass-through entity may require annual reports before the anniversary dates of multiple year Federal awards. . . ." Cause A system of internal controls was not designed or implemented by management of the District, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect management's statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the seven Quarterly Performance Reports and the four Semi-Annual SF-425 Federal Financial Reports due during the audit period were either not submitted or not submitted timely. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the District. Questioned Costs There were no questioned costs. Recommendation We recommended that management of the District design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place over reimbursement requisitions. In addition, we recommended that management of the District establish a proper system of internal controls and develop policies and procedures to ensure that all required reports are filed and filed timely. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding 2022-002: Significant deficiency in internal control over reporting. Federal Agency Program: U.S. Department of Treasury, Passed through State of Oregon ? Department of Administrative Services Federal Program: 21.027 Coronavirus State and Local Fiscal Recovery Funds Award Period: January 1, 2022 ? December 31, 2022 Criteria: Title 2 U.S. Code of Federal Regulations (CFR) 200.329 requires that non-Federal entities submit performance reports at the interval required by the Federal awarding agency or pass-through entity. The grant agreement required quarterly and annual reports to be submitted. Condition: The quarterly reports and the annual reporting submitted for 2022 by the Organization did not agree to the quarterly information as per the Organization?s accounting records provided. Total award expenditures for the year agreed to the total annual amount reported. Context: Additional procedures were required to reconcile the Federal Award expenditures to the annual reporting submitted. Cause: The Organization received increased support during the year ended December 31, 2022, increasing the complexities of tracking and reporting of Federal expenditures. Policies and procedures over the review and approval of Federal award reporting were not adequately documented. Effect: Without adequate written policies and procedures over the review and approval of reporting of Federal award expenditures, total expenditures by Federal program may not be properly reported. Questioned costs: None. Repeat Finding: No. Recommendation: The Organization should update its written policies and procedures over the review and approval of Federal Award reporting to ensure complete and accurate reporting of award expenditures. Views of Responsible Officials: Management notes the details of this finding. Management will implement procedures to mitigate the outlined issues in our Corrective Action Plan.
2022-003 ? Performance Reporting Federal Agency: U.S. Small Business Administration Federal Program: Microloan Program Assistance Listing Numbers: 59.046 Federal Award Identification Number and Year: ? SBAOCAML210221 ? 2021 ? SBAOCAML220344 ? 2022 Award Period: January 1, 2022 ? December 31, 2022 Type of Finding: ? Significant Deficiency in Internal Control over Compliance ? Compliance - Other Matter Criteria or Specific Requirement: Federal regulations require submission of performance reports at an interval required by the federal awarding agency. Those reports submitted quarterly must be due no later than 30 calendar days after the reporting period. These requirements are outlined in 2 CFR 200.329(c) Monitoring and reporting program performance. Condition: During our testing, we tested two quarterly performance reports and it was noted both were submitted after the required due date outlined in the grant agreement. Questioned Costs: None Context: During our testing, it was noted the Organization did not have proper procedures in place for ensuring timely submission of the quarterly performance reports as required in the federal fund notice of awards. Cause: Management did not have a system in place to ensure the completion and submission of the required performance reporting by the specified due date. Effect: By submitting untimely performance reports, the Organization is not in compliance with the terms and conditions of the award. This did not result in any disallowed costs. Repeat Finding: No Recommendation: We recommend management develop procedures to ensure the required reporting is completed within the timeline allowed by the granting agency. Views of Responsible Officials: Management agrees with finding.
FINDING 2022-003 Subject: Water and Waste Disposal Systems for Rural Communities - Reporting Federal Agency: Department of Agriculture Federal Program: Water and Waste Disposal Systems for Rural Communities Assistance Listings Number: 10.760 Federal Award Number and Year (or Other Identifying Number): CY 2020 Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2021-004. Condition and Context The Town had not designed or implemented adequate internal controls and procedures to ensure that reports were prepared, accurate, and submitted in accordance with the applicable compliance requirements for the federal grant. The United States Department of Agriculture (USDA) requires the following two financial reports be submitted annually: 1. Statement of Budget, Income and Equity, (Form RD 442-2) 2. Balance Sheet (Form RD 442-3) The Form RD 442-2 covers financial operations relating to the borrower's water or waste disposal project. The Form RD 442-3 presents the financial status of the borrower's water or waste disposal project. In both instances, a borrower may submit the financial data on other forms, provided the forms are in a similar format and signed and dated by the organization's official to certify the correctness of the information. Alternatively, an annual audit may be submitted in lieu of the forms. The Town was required to file each report, as noted above, during the audit period. Both reports were selected for testing. Per inquiry with the Town and review of its records, the Town attempted to prepare Form RD 442-2; however, the report was never completed, nor was it filed with the appropriate authorities. Additionally, the Town did not file or even attempt to prepare Form RD 442-3. Neither alternative reports nor a financial statement were submitted to the USDA in lieu of the forms. The lack of internal controls and noncompliance were systemic issues, which occurred throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (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.328 and 200.329. . . ." 7 CFR 1780.47 states in part: "Borrower accounting methods, management reporting and audits. . . . (e) Borrowers exempt from audits. All borrowers who are exempt from audits, will, within 60 days following the end of each fiscal year, furnish the RUS with annual financial statements, consisting of a verification of the organization's balance sheet and statement of income and expense by an appropriate official of the organization. Forms RD 442-2, 'Statement of Budget, Income and Equity,' and 442-3 may be used. (f) Management reports. These reports will furnish management with a means of evaluating prior decisions and serve as a basis for planning future operations and financial strategies. In those cases where revenues from multiple sources are pledged as security for an RUS loan, two reports will be required; one for the project being financed by RUS and one combining the entire operation of the borrower. In those cases where RUS loans are secured by general obligation bonds or assessments and the borrower combines revenues from all sources, one management report combining all such revenues is acceptable. The following management data will be submitted by the borrower to the processing office. These reports at a minimum will include a balance sheet and income and expense statement. . . . (2) Annual management reports. Prior to the beginning of each fiscal year the following will be submitted to the processing office. (If Form RD 442-2 is used as the annual management report, enter data in column three only of Schedule 1, and complete all of Schedule 2.) (i) Two copies of the management reports and proposed 'Annual Budget.' (ii) Financial information may be reported on Form RD 442-2 which includes Schedule 1, 'Statement of Budget, Income and Equity' and Schedule 2, 'Projected Cash Flow' or information in similar format. (iii) A copy of the rate schedule in effect at the time of submission. (g) Substitute for management reports. When RUS loans are secured by the general obligation of the public body or tax assessments which total 100 percent of the debt service requirements, the State program official may authorize an annual audit to substitute for other management reports if the audit is received within nine months after the end of the audit period." Cause A proper system of internal controls was not designed by management of the Town. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the Town's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, required reports were not filed with the USDA. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the Town. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the Town establish a proper system of internal controls and develop policies and procedures to ensure required reports, or allowable alternatives are completed and filed with the USDA. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-007 Subject: CDBG - Entitlement Grants Cluster - Reporting Federal Agency: Department of Housing and Urban Development Federal Programs: Community Development Block Grants/Entitlement Grants, COVID-19 - Community Development Block Grants/Entitlement Grants Assistance Listings Number: 14.218 Federal Award Numbers and Years (or Other Identifying Numbers): B-19-MC-18-0015, B-20-MC-20-0015, B-20-MW-18-0015, B-21-MC-18-0015, B-22-MC-18-0015 Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2021-004. Condition and Context Financial Reporting For each CDBG award, the City is required to submit financial reports to Housing and Urban Development (HUD). The financial reports to be submitted are a quarterly CDBG Cash on Hand (PR29) report and an annual CDBG Financial Summary (PR26). The Community Development Specialist prepared the annual PR26 and quarterly PR29 reports without evidence of a review or an approval process to ensure accuracy of the reports submitted. During the audit period, there were three PR26 reports and six PR29 reports due. Four reports were selected for testing, two PR26 reports and two PR29 reports. One of the two PR26 reports was not supported by the City's records, and one of the two PR29 reports contained errors when reporting cash on hand. Performance Reporting The City is required to enter HUD 60002, Section 3 Summary Report, Economic Opportunities for Low- and Very Low-Income Persons report (Section 3) activities on the closeout screens in the Integrated Disbursement and Information System (IDIS), as well as within the Consolidated Annual Performance and Evaluation Report (CAPER). The Section 3 report was not submitted on the closeout screens in the IDIS as part of the closeout process. The City did submit the Section 3 information within the CAPER; however, the Section 3 information was not supported by the City's records. The City was not able to provide documentation supporting the Section 3 information in the CAPER. Special Reporting for Federal Funding Accountability and Transparency Act (FFATA) Under the requirements of the Federal Funding Accountability and Transparency Act (Pub. L. No. 109-282) (Transparency Act), recipients (i.e., direct recipients) of grants or cooperative agreements who make first tier subawards of $30,000 or more are required to register in the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS) and report subaward data through the FSRS. INDIANA STATE BOARD OF ACCOUNTS 28 CITY OF ELKHART SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) There were two subawards that required submission in the FSRS during the audit period. The due date for the information was August 31, 2022, and November 30, 2022, respectively. The information was completed and submitted by the City; however, there was no documentation of the review or oversight process in place to ensure the accuracy of the information submitted. (See Report PDF for Schedule.) The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (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.328 and 200.329. . . ." Cause A proper system of internal controls was not designed by management of the City. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the City's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, required reports were not accurate nor submitted timely. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the City. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the City design and implement a proper system of internal control, including policies and procedures that would provide segregation of duties to ensure required reports are submitted timely and accurately. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-007 Subject: CDBG - Entitlement Grants Cluster - Reporting Federal Agency: Department of Housing and Urban Development Federal Programs: Community Development Block Grants/Entitlement Grants, COVID-19 - Community Development Block Grants/Entitlement Grants Assistance Listings Number: 14.218 Federal Award Numbers and Years (or Other Identifying Numbers): B-19-MC-18-0015, B-20-MC-20-0015, B-20-MW-18-0015, B-21-MC-18-0015, B-22-MC-18-0015 Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2021-004. Condition and Context Financial Reporting For each CDBG award, the City is required to submit financial reports to Housing and Urban Development (HUD). The financial reports to be submitted are a quarterly CDBG Cash on Hand (PR29) report and an annual CDBG Financial Summary (PR26). The Community Development Specialist prepared the annual PR26 and quarterly PR29 reports without evidence of a review or an approval process to ensure accuracy of the reports submitted. During the audit period, there were three PR26 reports and six PR29 reports due. Four reports were selected for testing, two PR26 reports and two PR29 reports. One of the two PR26 reports was not supported by the City's records, and one of the two PR29 reports contained errors when reporting cash on hand. Performance Reporting The City is required to enter HUD 60002, Section 3 Summary Report, Economic Opportunities for Low- and Very Low-Income Persons report (Section 3) activities on the closeout screens in the Integrated Disbursement and Information System (IDIS), as well as within the Consolidated Annual Performance and Evaluation Report (CAPER). The Section 3 report was not submitted on the closeout screens in the IDIS as part of the closeout process. The City did submit the Section 3 information within the CAPER; however, the Section 3 information was not supported by the City's records. The City was not able to provide documentation supporting the Section 3 information in the CAPER. Special Reporting for Federal Funding Accountability and Transparency Act (FFATA) Under the requirements of the Federal Funding Accountability and Transparency Act (Pub. L. No. 109-282) (Transparency Act), recipients (i.e., direct recipients) of grants or cooperative agreements who make first tier subawards of $30,000 or more are required to register in the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS) and report subaward data through the FSRS. INDIANA STATE BOARD OF ACCOUNTS 28 CITY OF ELKHART SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) There were two subawards that required submission in the FSRS during the audit period. The due date for the information was August 31, 2022, and November 30, 2022, respectively. The information was completed and submitted by the City; however, there was no documentation of the review or oversight process in place to ensure the accuracy of the information submitted. (See Report PDF for Schedule.) The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . (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.328 and 200.329. . . ." Cause A proper system of internal controls was not designed by management of the City. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the City's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, required reports were not accurate nor submitted timely. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the City. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the City design and implement a proper system of internal control, including policies and procedures that would provide segregation of duties to ensure required reports are submitted timely and accurately. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Ref. No. Compliance and Internal Control over Compliance Findings 2022-001 Reporting - Significant Deficiency Federal Agency: Department of Health and Human Services Pass-Through Entity: State of Hawaii Department of Human Services Assistance Listing No.: 93.558 Program: Temporary Assistance for Needy Families (TANF) Criteria: Uniform Guidance 2 CFR 200.329(c)(1) states that the non-Federal entity must submit performance repots at the interval required by the Federal awarding agency or pass-through entity to best inform improvements in program outcomes and productivity. The sub-recipient agreement entered into with the State of Hawaii Department of Human Services required that a quarterly Maintenance of Effort (MOE) Expenditure Report be submitted no later than thirty (3) calendar days following the end of each quarter. Condition: During our audit, we noted two (2) quarters reviewed where the quarterly MOE was submitted more than 30 days after the quarter end. Cause: Lack of adherence to reporting requirements exhibited by key accounting personnel. Effect: Without an effective internal control system, untimely reporting could result in the misrepresentation of data and could adversely affect program outcomes and future funding. Recommendation The Organization should improve processes and procedures to ensure that quarterly reports required by the pass-through entity are completed and submitted on a timely basis. Views of Responsible Officials and Planned Corrective Action The Organization agrees with the finding and the recommendation. See Part IV Correction Action Plan.
#2022-009 - Major Federal Award Finding - Reporting Nature of Finding: Compliance Finding - Reporting and Material Weakness in Internal Controls Over Compliance 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 that no review procedures are in place surrounding these reports. Cause/Context: Controls were not in place to ensure accurate reporting. Only one individual was involved in the reporting process. Of the two reports tested, one Federal Status Report included an expenditure reported in an inaccurate budget category. Payroll tax costs were divided between the Fringe Benefits/Payroll tax budget line and the Other Expenses line, with a total of $1,554 reported in the incorrect budget category. Additionally, the client failed to identify that submission of a single audit was an applicable reporting requirement for the December 31, 2022 year, resulting in a late single audit filing. Effect: The lack of controls resulted in inaccurate, late, and failed reporting compliance. Recommendation: We recommend that a full-range of controls related to reporting, including federal program reporting be implemented. The Organization should devote the resources necessary to ensure that reports are timely and accurately prepared, reviewed, and approved prior to filing. All controls, including review and approval should be documented and that documentation be maintained. Views of Responsible Officials and Planned Corrective Actions: MARR will retain a CPA consultant to implement a full-range of controls relating to reporting, including federal program reporting. MARR will take such steps as necessary to ensure that reports are timely and accurately prepared, reviewed, and approved prior to filing. All controls, including review and approval will be documented in such documentation to be maintained.
#2022-009 - Major Federal Award Finding - Reporting Nature of Finding: Compliance Finding - Reporting and Material Weakness in Internal Controls Over Compliance 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 that no review procedures are in place surrounding these reports. Cause/Context: Controls were not in place to ensure accurate reporting. Only one individual was involved in the reporting process. Of the two reports tested, one Federal Status Report included an expenditure reported in an inaccurate budget category. Payroll tax costs were divided between the Fringe Benefits/Payroll tax budget line and the Other Expenses line, with a total of $1,554 reported in the incorrect budget category. Additionally, the client failed to identify that submission of a single audit was an applicable reporting requirement for the December 31, 2022 year, resulting in a late single audit filing. Effect: The lack of controls resulted in inaccurate, late, and failed reporting compliance. Recommendation: We recommend that a full-range of controls related to reporting, including federal program reporting be implemented. The Organization should devote the resources necessary to ensure that reports are timely and accurately prepared, reviewed, and approved prior to filing. All controls, including review and approval should be documented and that documentation be maintained. Views of Responsible Officials and Planned Corrective Actions: MARR will retain a CPA consultant to implement a full-range of controls relating to reporting, including federal program reporting. MARR will take such steps as necessary to ensure that reports are timely and accurately prepared, reviewed, and approved prior to filing. All controls, including review and approval will be documented in such documentation to be maintained.
2022-006 – Reporting Federal agency: U.S. Department of Health and Human Services Federal program title: Health Centers Cluster Assistance Listing Number: 93.224/93.527 Pass-Through Agency: n/a Pass-Through Number(s): n/a Award Period: 6/1/21-5/31/22 & 6/1/22-5/31/23 Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: § 200.329 indicates that the non-federal entity is responsible for oversight of the operations of the Federal award supported activities. The non-Federal entity must monitor its activities under Federal awards to assure compliance with applicable Federal requirements and performance expectations are being achieved. Condition: There were two instances in which documentation was not available to support amounts included within reports submitted. These instances affected the Federal Financial Report and the UDS report. Questioned costs: None. Context: Documentation was not available to support the amount reported on line E, Federal share of expenditures, of the ARPA Federal Financial Report. In addition, there was no documentation to support two key lines items of the UDS report, Table 9E, Lines 1g and 1q, Column A. Cause: Management turnover Effect: Inaccurate reports could be file if there is no underlying documentation to support the amounts reported. Repeat Finding: The finding is a repeat of a finding in the immediately prior year. Prior year finding number was 2021-07. Recommendation: We recommend that the Organization maintain supporting documentation for all reports required to be filed to the federal agency. Views of responsible officials: There is no disagreement with the audit finding.
2022-006 – Reporting Federal agency: U.S. Department of Health and Human Services Federal program title: Health Centers Cluster Assistance Listing Number: 93.224/93.527 Pass-Through Agency: n/a Pass-Through Number(s): n/a Award Period: 6/1/21-5/31/22 & 6/1/22-5/31/23 Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: § 200.329 indicates that the non-federal entity is responsible for oversight of the operations of the Federal award supported activities. The non-Federal entity must monitor its activities under Federal awards to assure compliance with applicable Federal requirements and performance expectations are being achieved. Condition: There were two instances in which documentation was not available to support amounts included within reports submitted. These instances affected the Federal Financial Report and the UDS report. Questioned costs: None. Context: Documentation was not available to support the amount reported on line E, Federal share of expenditures, of the ARPA Federal Financial Report. In addition, there was no documentation to support two key lines items of the UDS report, Table 9E, Lines 1g and 1q, Column A. Cause: Management turnover Effect: Inaccurate reports could be file if there is no underlying documentation to support the amounts reported. Repeat Finding: The finding is a repeat of a finding in the immediately prior year. Prior year finding number was 2021-07. Recommendation: We recommend that the Organization maintain supporting documentation for all reports required to be filed to the federal agency. Views of responsible officials: There is no disagreement with the audit finding.
2022-006 – Reporting Federal agency: U.S. Department of Health and Human Services Federal program title: Health Centers Cluster Assistance Listing Number: 93.224/93.527 Pass-Through Agency: n/a Pass-Through Number(s): n/a Award Period: 6/1/21-5/31/22 & 6/1/22-5/31/23 Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: § 200.329 indicates that the non-federal entity is responsible for oversight of the operations of the Federal award supported activities. The non-Federal entity must monitor its activities under Federal awards to assure compliance with applicable Federal requirements and performance expectations are being achieved. Condition: There were two instances in which documentation was not available to support amounts included within reports submitted. These instances affected the Federal Financial Report and the UDS report. Questioned costs: None. Context: Documentation was not available to support the amount reported on line E, Federal share of expenditures, of the ARPA Federal Financial Report. In addition, there was no documentation to support two key lines items of the UDS report, Table 9E, Lines 1g and 1q, Column A. Cause: Management turnover Effect: Inaccurate reports could be file if there is no underlying documentation to support the amounts reported. Repeat Finding: The finding is a repeat of a finding in the immediately prior year. Prior year finding number was 2021-07. Recommendation: We recommend that the Organization maintain supporting documentation for all reports required to be filed to the federal agency. Views of responsible officials: There is no disagreement with the audit finding.
Federal Agency: United States Department of Commerce Federal Program Name: Office for Coastal Management Assistance Listing Number: 11.473 Federal Award Identification Year: 2020 Pass-Through Agency: National Fish and Wildlife Grant Agreement Award Period: 9/1/20-08/31/23 Type of Finding: Other Matters - Significant Deficiency in Internal Control Criteria: 2 CFR 200.328 - Unless otherwise approved by OMB, the Federal awarding agency must solicit only the OMB-approved governmentwide data elements for collection of financial information (at time of publication the Federal Financial Report or such future, OMB approved, governmentwide data elements available from the OMB designated standards lead. This 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. 2 CFR 200.329(c)(1) -Requirements state that the non-Federal entity must submit performance reports at the interval required by the Federal awarding agency or passthrough entity to best inform improvements in program outcomes and productivity. Condition: For one of the two reports selected for testing, CFSC did not submit the reports to the National Fish and Wildlife Foundation by the required date. Context: A nonstatistical sample of 2 out of 4 required reports were selected for testing for the Office for Coastal Management program. The condition noted above was identified during our procedures over the CFSC’s reporting requirements. Effect: CFSC did not submit required reports in a timely manner, increasing the risk of noncompliance. Cause: CFSC’s procedures did not consistently ensure that the required reports were submitted on a timely basis. Repeat Finding: The finding is a repeat finding. Recommendation: We recommend that management modify and strengthen its current policies and procedures to ensure that all required reports are submitted on a timely basis to the appropriate Federal Agency or Pass-Through Entity. Management’s Views: See separate corrective action plan.
2 CFR § 1000.10 gives regulatory effect to Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, set forth at 2 CFR part 200 for the Department of Treasury. 2 CFR 200.329(c)(1) states that non-Federal entities must submit performance reports at the interval required by the Federal awarding agency or pass-through entity to best inform improvements in program outcomes and productivity. Reports submitted quarterly must be due no later than 30 calendar days after the reporting period. 31 CFR 35.4(c) requires recipients, in part, during the period of performance, to provide the Secretary of the U.S. Department of Treasury periodic reports providing detailed accounting of the uses of funds, modifications to a State or Territory's tax revenue sources, and such other information as the Secretary may require for the administration of this section. The U.S. Department of Treasury provided supplementary information on reporting requirements in its interim final rule for State and Local Fiscal Recovery Funds for 31 CFR Part 35 and provided further guidance in its Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guide. The County was required to submit the initial Project and Expenditure Report for the period from March 3, 2021 to March 31, 2022 to the U.S Department of Treasury by April 30, 2022. Per review of the initial filed Project and Expenditure Report the report was filed on May 10, 2022, which was after the required due date. Reporting errors could adversely affect future grant awards. An additional control(s) and/or procedure(s) should be implemented to help ensure required reports are accurately prepared and submitted in a timely manner.
Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Reporting requirements are contained in the following: Financial reporting, 2 CFR section 200.328. Monitoring and reporting program performance, 2 CFR section 200.329. Federal regulations and grant/contract conditions require financial and programmatic reports to be filed in a timely manner and should be supported by accurate supporting documentation. Condition/Context: 15.029 – Judicial Services Management has not implemented an effective internal control system for reporting. We were not provided the FY2022 Annual Narrative Report or FY2022 Quarterly SF-425 Federal Financial Reports. 20.205 – Highway Planning and Construction Cluster Management has not implemented an effective internal control system for reporting. We were not provided 1 of 1 required PR-20 Voucher for Work Under Provisions of the Federal-Aid and Federal Highway Acts Report. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Policies and procedures have not been implemented properly to ensure compliance with federal reporting requirements. Further, Joint Programs did not have an effective control system in place to ensure that documentation was retained to support amounts originally reported. Effect: Without an effective internal control system an entity’s objective: operations, reporting, and compliance cannot be achieved. Additionally, Joint Programs is out of compliance with federal reporting requirements for the above programs and amounts reported to federal agencies may be inaccurate. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-006. Recommendation: Joint Programs should improve the controls over the reporting function, which includes the documentation, review, and approval of all required reports, and effective controls over the preparation of reports, as well as a monitoring function to ensure that controls are in place and operating effectively for report submission. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Reporting requirements are contained in the following: Financial reporting, 2 CFR section 200.328. Monitoring and reporting program performance, 2 CFR section 200.329. Federal regulations and grant/contract conditions require financial and programmatic reports to be filed in a timely manner and should be supported by accurate supporting documentation. Condition/Context: 15.029 – Judicial Services Management has not implemented an effective internal control system for reporting. We were not provided the FY2022 Annual Narrative Report or FY2022 Quarterly SF-425 Federal Financial Reports. 20.205 – Highway Planning and Construction Cluster Management has not implemented an effective internal control system for reporting. We were not provided 1 of 1 required PR-20 Voucher for Work Under Provisions of the Federal-Aid and Federal Highway Acts Report. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Policies and procedures have not been implemented properly to ensure compliance with federal reporting requirements. Further, Joint Programs did not have an effective control system in place to ensure that documentation was retained to support amounts originally reported. Effect: Without an effective internal control system an entity’s objective: operations, reporting, and compliance cannot be achieved. Additionally, Joint Programs is out of compliance with federal reporting requirements for the above programs and amounts reported to federal agencies may be inaccurate. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-006. Recommendation: Joint Programs should improve the controls over the reporting function, which includes the documentation, review, and approval of all required reports, and effective controls over the preparation of reports, as well as a monitoring function to ensure that controls are in place and operating effectively for report submission. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Reporting requirements are contained in the following: Financial reporting, 2 CFR section 200.328. Monitoring and reporting program performance, 2 CFR section 200.329. Federal regulations and grant/contract conditions require financial and programmatic reports to be filed in a timely manner and should be supported by accurate supporting documentation. Condition/Context: 15.029 – Judicial Services Management has not implemented an effective internal control system for reporting. We were not provided the FY2022 Annual Narrative Report or FY2022 Quarterly SF-425 Federal Financial Reports. 20.205 – Highway Planning and Construction Cluster Management has not implemented an effective internal control system for reporting. We were not provided 1 of 1 required PR-20 Voucher for Work Under Provisions of the Federal-Aid and Federal Highway Acts Report. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Policies and procedures have not been implemented properly to ensure compliance with federal reporting requirements. Further, Joint Programs did not have an effective control system in place to ensure that documentation was retained to support amounts originally reported. Effect: Without an effective internal control system an entity’s objective: operations, reporting, and compliance cannot be achieved. Additionally, Joint Programs is out of compliance with federal reporting requirements for the above programs and amounts reported to federal agencies may be inaccurate. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-006. Recommendation: Joint Programs should improve the controls over the reporting function, which includes the documentation, review, and approval of all required reports, and effective controls over the preparation of reports, as well as a monitoring function to ensure that controls are in place and operating effectively for report submission. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Reporting requirements are contained in the following: Financial reporting, 2 CFR section 200.328. Monitoring and reporting program performance, 2 CFR section 200.329. Federal regulations and grant/contract conditions require financial and programmatic reports to be filed in a timely manner and should be supported by accurate supporting documentation. Condition/Context: 15.029 – Judicial Services Management has not implemented an effective internal control system for reporting. We were not provided the FY2022 Annual Narrative Report or FY2022 Quarterly SF-425 Federal Financial Reports. 20.205 – Highway Planning and Construction Cluster Management has not implemented an effective internal control system for reporting. We were not provided 1 of 1 required PR-20 Voucher for Work Under Provisions of the Federal-Aid and Federal Highway Acts Report. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Policies and procedures have not been implemented properly to ensure compliance with federal reporting requirements. Further, Joint Programs did not have an effective control system in place to ensure that documentation was retained to support amounts originally reported. Effect: Without an effective internal control system an entity’s objective: operations, reporting, and compliance cannot be achieved. Additionally, Joint Programs is out of compliance with federal reporting requirements for the above programs and amounts reported to federal agencies may be inaccurate. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-006. Recommendation: Joint Programs should improve the controls over the reporting function, which includes the documentation, review, and approval of all required reports, and effective controls over the preparation of reports, as well as a monitoring function to ensure that controls are in place and operating effectively for report submission. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Reporting requirements are contained in the following: Financial reporting, 2 CFR section 200.328. Monitoring and reporting program performance, 2 CFR section 200.329. Federal regulations and grant/contract conditions require financial and programmatic reports to be filed in a timely manner and should be supported by accurate supporting documentation. Condition/Context: 15.029 – Judicial Services Management has not implemented an effective internal control system for reporting. We were not provided the FY2022 Annual Narrative Report or FY2022 Quarterly SF-425 Federal Financial Reports. 20.205 – Highway Planning and Construction Cluster Management has not implemented an effective internal control system for reporting. We were not provided 1 of 1 required PR-20 Voucher for Work Under Provisions of the Federal-Aid and Federal Highway Acts Report. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Policies and procedures have not been implemented properly to ensure compliance with federal reporting requirements. Further, Joint Programs did not have an effective control system in place to ensure that documentation was retained to support amounts originally reported. Effect: Without an effective internal control system an entity’s objective: operations, reporting, and compliance cannot be achieved. Additionally, Joint Programs is out of compliance with federal reporting requirements for the above programs and amounts reported to federal agencies may be inaccurate. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-006. Recommendation: Joint Programs should improve the controls over the reporting function, which includes the documentation, review, and approval of all required reports, and effective controls over the preparation of reports, as well as a monitoring function to ensure that controls are in place and operating effectively for report submission. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Reporting requirements are contained in the following: Financial reporting, 2 CFR section 200.328. Monitoring and reporting program performance, 2 CFR section 200.329. Federal regulations and grant/contract conditions require financial and programmatic reports to be filed in a timely manner and should be supported by accurate supporting documentation. Condition/Context: 15.029 – Judicial Services Management has not implemented an effective internal control system for reporting. We were not provided the FY2022 Annual Narrative Report or FY2022 Quarterly SF-425 Federal Financial Reports. 20.205 – Highway Planning and Construction Cluster Management has not implemented an effective internal control system for reporting. We were not provided 1 of 1 required PR-20 Voucher for Work Under Provisions of the Federal-Aid and Federal Highway Acts Report. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Policies and procedures have not been implemented properly to ensure compliance with federal reporting requirements. Further, Joint Programs did not have an effective control system in place to ensure that documentation was retained to support amounts originally reported. Effect: Without an effective internal control system an entity’s objective: operations, reporting, and compliance cannot be achieved. Additionally, Joint Programs is out of compliance with federal reporting requirements for the above programs and amounts reported to federal agencies may be inaccurate. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-006. Recommendation: Joint Programs should improve the controls over the reporting function, which includes the documentation, review, and approval of all required reports, and effective controls over the preparation of reports, as well as a monitoring function to ensure that controls are in place and operating effectively for report submission. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Program Information: U.S. Department of the Interior AL Number Award Number Award Period Grant Name 15.029 A21AV00088 10/1/2020-9/30/2023 Judicial Services U.S. Department of Transportation AL Number Award Number Award Period Grant Name 20.205 A18AV01093/A17AV00612 1/1/2018-12/31/2022 Highway Planning and Construction Cluster Criteria: Per 2 CFR § 200.303 Internal controls, the non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Reporting requirements are contained in the following: Financial reporting, 2 CFR section 200.328. Monitoring and reporting program performance, 2 CFR section 200.329. Federal regulations and grant/contract conditions require financial and programmatic reports to be filed in a timely manner and should be supported by accurate supporting documentation. Condition/Context: 15.029 – Judicial Services Management has not implemented an effective internal control system for reporting. We were not provided the FY2022 Annual Narrative Report or FY2022 Quarterly SF-425 Federal Financial Reports. 20.205 – Highway Planning and Construction Cluster Management has not implemented an effective internal control system for reporting. We were not provided 1 of 1 required PR-20 Voucher for Work Under Provisions of the Federal-Aid and Federal Highway Acts Report. [X] Compliance Finding [ ] Significant Deficiency [X] Material Weakness Cause: Policies and procedures have not been implemented properly to ensure compliance with federal reporting requirements. Further, Joint Programs did not have an effective control system in place to ensure that documentation was retained to support amounts originally reported. Effect: Without an effective internal control system an entity’s objective: operations, reporting, and compliance cannot be achieved. Additionally, Joint Programs is out of compliance with federal reporting requirements for the above programs and amounts reported to federal agencies may be inaccurate. Questioned Costs: Due to lack of sufficient documentation, we were unable to determine questioned costs. Repeat Finding: Yes – 2021-006. Recommendation: Joint Programs should improve the controls over the reporting function, which includes the documentation, review, and approval of all required reports, and effective controls over the preparation of reports, as well as a monitoring function to ensure that controls are in place and operating effectively for report submission. View of Responsible Officials and Planned Corrective Action: Management agrees with the finding and has prepared corrective action as detailed in its Corrective Action Plan.
Community Development Financial Institutions Rapid Response Program (CDFI RRP), Assistance Listing Number: 21.024 U.S. Department of the Treasury Program Year 2022 Criteria or specific requirement – Reporting (2 CFR section 200.328 and 200.329) Condition – The Credit Union reported the incorrect amount of cumulative awards expended in the 2022 Use of Awards Report. Cause – The Credit Union’s controls did not ensure the proper amounts were reported. Effect – The Credit Union reported the incorrect amount of awards expended during 2022. Questioned costs – N/A Context – The Credit Union is required to submit three reports for the year ended December 31, 2022. All of the required reports were tested. The 2022 Use of Awards report reported $828,265 as the cumulative use of award, rather than the actual total cumulative use of $1,826,265 that was actually expended during the year. Identification as a repeat finding, if applicable – N/A Recommendation – Management should review and update controls over federal grant reporting to ensure reports are prepared using complete and accurate information. Views of responsible officials and planned corrective actions – The input error was corrected prior to end of the audit. The credit union's CDFI analyst was contacted by the Chief Strategic Officer and the analyst opened the data field for editing in the AMIS system. The Chief Strategic Officer made the correction in the AMIS system and submitted the corrected information. The Chief Strategic Officer has assigned CDFI reporting responsibilities to the Director of Strategy. Future submissions will be performed by the Director of Strategy and reviewed by the Chief Strategic Officer prior to submission.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) 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 SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 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 Section 200.328 Financial Reporting and Section 200.329 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. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) 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 SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 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 Section 200.328 Financial Reporting and Section 200.329 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. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) 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 SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 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 Section 200.328 Financial Reporting and Section 200.329 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. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) 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 SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 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 Section 200.328 Financial Reporting and Section 200.329 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. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) 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 SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 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 Section 200.328 Financial Reporting and Section 200.329 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. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Finding 2022-004 Compliance Requirement: Internal Control over Compliance and Compliance with Reporting (Preparation of Schedule of Expenditures of Federal Awards) Prior Year Finding Number: N/A Program: ALN 14.267 U.S. Department of Housing and Urban Development – Continuum of Care Program ALN 16.575 U.S. Department of Justice – Victims of Crime Acts Program ALN 21.027 U.S. Department of Treasury – Victims of Crime Acts Program Criteria - The Code of Federal Regulation (CFR) Section 200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) 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 SEFA must provide total federal awards expended for each individual Federal program. In accordance with Section 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 Section 200.328 Financial Reporting and Section 200.329 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. Condition – The SEFA as prepared by management did not originally include one federal grant with federal expenditures during the year and one grant for which the Assistance Listing Number (ALN) did not match the grant documents. Cause - The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed due to new funding received in the current year. Effect – The original SEFA was incomplete. Questioned Costs: None. Context: The conditions outlined above are based on our testing of the Organization’s major program and our overall testing of the accuracy of the SEFA. The nature of this findings is detailed in the condition section above. Recommendation- We recommend management attend federal award trainings and information to ensure the documented policies and procedures can be performed as described. This will ensure the federal funds are reported accurately on the SEFA and that programs are reported under the correct ALN. Views of Responsible Officials – The Organization concurs with the auditor’s findings and recommendations. The Organization will continue to review federal award guidance and requirements to ensure compliance with current and future federal awards. Refer to the Organization’s corrective action plan for further details.
Criteria: In accordance with 2 CFR 200.328 and 2 CFR 200.329, the College is required to prepare and publicly post quarterly reports related to the student aid and institutional portions of HEERF expenditures. Condition: During our audit, we selected one of the four quarterly reports to test the accuracy of the reporting. Our testing indicated certain amounts on the quarterly report that did not agree to the expenditures for the quarter. Questioned Costs: None Effect: The College was not in compliance with HEERF reporting requirements. Cause: Certain HEERF I expenditures were improperly excluded from the report and some misunderstanding of requirements of certain items in the report. Recommendation: We recommend reconciliation of quarterly reports to related grant documentation and review of the reports by an appropriate team member to ensure accuracy. Views of responsible officials and planned corrective action: The College agrees with this finding and will adhere to the corrective action plan on page 34 in this audit report.
Criteria: In accordance with 2 CFR 200.328 and 2 CFR 200.329, the College is required to prepare and publicly post quarterly reports related to the student aid and institutional portions of HEERF expenditures. Condition: During our audit, we selected one of the four quarterly reports to test the accuracy of the reporting. Our testing indicated certain amounts on the quarterly report that did not agree to the expenditures for the quarter. Questioned Costs: None Effect: The College was not in compliance with HEERF reporting requirements. Cause: Certain HEERF I expenditures were improperly excluded from the report and some misunderstanding of requirements of certain items in the report. Recommendation: We recommend reconciliation of quarterly reports to related grant documentation and review of the reports by an appropriate team member to ensure accuracy. Views of responsible officials and planned corrective action: The College agrees with this finding and will adhere to the corrective action plan on page 34 in this audit report.
Criteria: In accordance with 2 CFR 200.328 and 2 CFR 200.329, the College is required to prepare and publicly post quarterly reports related to the student aid and institutional portions of HEERF expenditures. Condition: During our audit, we selected one of the four quarterly reports to test the accuracy of the reporting. Our testing indicated certain amounts on the quarterly report that did not agree to the expenditures for the quarter. Questioned Costs: None Effect: The College was not in compliance with HEERF reporting requirements. Cause: Certain HEERF I expenditures were improperly excluded from the report and some misunderstanding of requirements of certain items in the report. Recommendation: We recommend reconciliation of quarterly reports to related grant documentation and review of the reports by an appropriate team member to ensure accuracy. Views of responsible officials and planned corrective action: The College agrees with this finding and will adhere to the corrective action plan on page 34 in this audit report.
2 CFR § 300.1 states the Department of Health and Human Services adopts the Office of Management and Budget (OMB) Guidance in 2 CFR part 200, and has codified the text, with HHS-specific amendments in 45 CFR part 75. Thus, this part gives regulatory effect to the OMB guidance and supplements the guidance as needed for the Department. 2 CFR § 200.329(a) states the non-Federal entity is responsible for oversight of the operations of the Federal award supported activities. The non-Federal entity must monitor its activities under Federal awards to assure compliance with applicable Federal requirements and performance expectations are being achieved. Monitoring by the non-Federal entity must cover each program, function or activity. 45 CFR § 75.302(a) states each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other 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. Section (b) states, in part, 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. Federal program and Federal award identification must include, as applicable, the CFDA title and number, Federal award identification number and year, name of the HHS awarding agency, and name of the pass-through entity, if any. (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 §§ 75.341 and 75.342. (3) Records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. (4) Effective control over, and accountability for, all funds, property, and other assets. The non-Federal entity must adequately safeguard all assets and assure that they are used solely for authorized purposes. (5) Comparison of expenditures with budget amounts for each Federal award. (6) Written procedures to implement the requirements of § 75.305. (7) Written procedures for determining the allowability of costs in accordance with subpart E of this part and the terms and conditions of the Federal award. The COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution program is administered by the Health Resources and Services Administration (HRSA) and supports eligible health care providers in the battle against the COVID-19 pandemic by providing relief funds to eligible providers of health care services and support for health care-related expenses or lost revenues attributable to coronavirus. PRF recipients must only use payments for eligible expenses. 2022 OMB Compliance Supplement, Part 4, 93.498. Providers who accepted PRF and/or ARP payment(s) agreed to the Terms and Conditions of the program, which include a requirement to report on the use of the funds. See Reporting and Auditing, Health Resources & Services Administration, https://www.hrsa.gov/provider-relief/reporting-auditing. Entities receiving PRF funds are required to submit financial and other information in the Provider Relief Fund Reporting Portal. The PRF amounts to be reported on the County’s Schedule of Expenditures of Federal Awards (SEFA) are based on the PRF report. 2022 OMB Compliance Supplement. Reporting Entities are required to maintain adequate documentation to substantiate that the PRF funds were used for health care-related expenses or lost revenues that are attributable to coronavirus and COVID-19. See PRB Reporting and Auditing FAQ, Health Resources & Services Administration, https://www.hrsa.gov/provider-relief/faq/reporting?categories=210&keywords= . Logan County Logan Acres Care Center Department (the Center) completed and submitted its PRF report based solely on the amounts received; however, the Center did not submit and maintain detailed, complete financial records on the actual expenditures of the PRF funds. As a result, the exact expenditures associated with the grant were unidentifiable which was contrary to the requirements imposed on recipients of PRF funds. Logan County Logan Acres Care Center Department should implement procedures to verify grants are separately accounted for with respect to receipts and expenditures. Failure to maintain detailed financial records can result in unallowable federal grant expenditures and/or reimbursements to the grantor.
2 CFR 1000.10 provides that, except for the deviations set forth elsewhere in this Part, the Department of Treasury adopts the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards set forth at 2 CFR Part 200. 2 CFR 200.302(b) states, in part, that the financial management system of each non-Federal entity must provide for the 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.328 and 200.329. The City did not have proper internal controls in place to ensure the accurate submission of the Project and Expenditure Reports. During testing of Project and Expenditure Reports for the Coronavirus State and Local Fiscal Recovery Funds (AL #21.027), we noted that: ? The City did not properly report cumulative obligations on the report required by July 31, 2022. The City over-reported cumulative obligations due to including a funding project more than once for $880,000 to the Justice Center Design project; and ? The City did not properly report cumulative obligations nor current period expenditures on the report required by October 31, 2022. The City over-reported cumulative obligations by $880,000 due to including a funding project more than once to the Justice Center Design project. The City also over-reported current period expenditures due to including the current period expenditures of $175,741 for a funding project more than once to Rehiring Staff project. Failure to have the proper controls in place to ensure the timely and accurate submission of the Project and Expenditure Reports could result in Treasury taking action against the City for failure to comply with programmatic requirements. The City should implement and have controls in place to ensure the quarterly Project and Expenditure Reports are accurate.
2 CFR 1000.10 provides that, except for the deviations set forth elsewhere in this Part, the Department of Treasury adopts the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards set forth at 2 CFR Part 200. 2 CFR 200.302(b) states, in part, that the financial management system of each non-Federal entity must provide for the 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.328 and 200.329. The City did not have proper internal controls in place to ensure the accurate submission of the Project and Expenditure Reports. During testing of Project and Expenditure Reports for the Coronavirus State and Local Fiscal Recovery Funds (AL #21.027), we noted that: ? The City did not properly report cumulative obligations on the report required by July 31, 2022. The City over-reported cumulative obligations due to including a funding project more than once for $880,000 to the Justice Center Design project; and ? The City did not properly report cumulative obligations nor current period expenditures on the report required by October 31, 2022. The City over-reported cumulative obligations by $880,000 due to including a funding project more than once to the Justice Center Design project. The City also over-reported current period expenditures due to including the current period expenditures of $175,741 for a funding project more than once to Rehiring Staff project. Failure to have the proper controls in place to ensure the timely and accurate submission of the Project and Expenditure Reports could result in Treasury taking action against the City for failure to comply with programmatic requirements. The City should implement and have controls in place to ensure the quarterly Project and Expenditure Reports are accurate.
2 CFR 1000.10 provides that, except for the deviations set forth elsewhere in this Part, the Department of Treasury adopts the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards set forth at 2 CFR Part 200. 2 CFR 200.302(b) states, in part, that the financial management system of each non-Federal entity must provide for the 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.328 and 200.329. The City did not have proper internal controls in place to ensure the accurate submission of the Project and Expenditure Reports. During testing of Project and Expenditure Reports for the Coronavirus State and Local Fiscal Recovery Funds (AL #21.027), we noted that: ? The City did not properly report cumulative obligations on the report required by July 31, 2022. The City over-reported cumulative obligations due to including a funding project more than once for $880,000 to the Justice Center Design project; and ? The City did not properly report cumulative obligations nor current period expenditures on the report required by October 31, 2022. The City over-reported cumulative obligations by $880,000 due to including a funding project more than once to the Justice Center Design project. The City also over-reported current period expenditures due to including the current period expenditures of $175,741 for a funding project more than once to Rehiring Staff project. Failure to have the proper controls in place to ensure the timely and accurate submission of the Project and Expenditure Reports could result in Treasury taking action against the City for failure to comply with programmatic requirements. The City should implement and have controls in place to ensure the quarterly Project and Expenditure Reports are accurate.
2022-002 ? SIGNIFICANT DEFICIENCY ? Internal Controls over Reporting U.S. Department of Treasury ? Passed through the State of Alabama Department of Treasury ? COVID 19 Coronavirus State and Local Fiscal Recovery Fund ? ALN #21.027 ? Program Year 2022 Criteria ? Per 2 CFR Subpart D - 200.329(a), non-federal entities are responsible for oversight of the operations of federal award supported activities and must monitor its activities under federal awards to assure compliance with applicable federal requirements and performance expectations are being achieved. In addition, per CFR 200.303(a), non-federal entities are required to establish and maintain effective internal controls over federal awards. Condition ? The Foundation did not maintain supporting documentation of the proper review and approval of the required final report for the federal award program. Cause ? Appropriate policies and procedures were not implemented by the Foundation to maintain documentation of the review and approval of the final report for the federal award program. Effect ? Lack of documentation of monitoring could lead to improper monitoring of federal award activity and possible misuse of funds. Questioned Costs ? None Auditors? Recommendation ? Policies and procedures should be designed, implemented, and monitored to ensure that documentation is maintained for the Foundation?s monitoring of its federal award program in accordance with federal award requirements. Management response and current status ? See management corrective action plan
FINDING 2022-004 Subject: Staffing for Adequate Fire and Emergency Response (SAFER) - Cash Management Federal Agency: Department of Homeland Security Federal Program: Staffing for Adequate Fire and Emergency Response (SAFER) Assistance Listings Number: 97.083 Federal Award Number and Year (or Other Identifying Number): EMW-2019-FF-00944 Compliance Requirement: Cash Management Audit Findings: Material Weakness, Modified Opinion Condition and Context The Township submits request for reimbursements to the Federal Emergency Management Agency of the Department of Homeland Security. The reimbursement method of cash management requires the Township to retain supporting documentation that shows the costs for which reimbursement was requested were paid prior to the reimbursement date. The Township was awarded a SAFER grant to increase the number of firefighters and was approved for personnel and fringe benefits costs, which includes health insurance, for nine additional firefighters. The Township is self-insured and would make payments to third-party administrators and other benefit coordinators. The Township would pay a large dollar amount at the end of each year to its selfinsurance benefit coordinators for the next year's benefit, and then additional payments throughout the year as needed for employee's medical claim coverage. These payments were made from various Township funds and the Payroll Deductions fund. Additionally, the payroll deductions for health insurance, including those for employees paid from the grant, would accumulate in the Payroll Deductions fund, and be used for payments to the benefit coordinators as needed and the payment of the next year's required funding. The amount submitted for reimbursement for health insurance benefits were based upon a calculation. The Township did not have supporting documentation for the calculation of those benefits that were claimed. In addition, the health insurance benefits claimed for reimbursement were not paid out of the SAFER Grant Fund and were not at a transaction level in the ledger. The health insurance benefit submitted for reimbursement could not be tied to a specific payment; thus, we were unable to determine the Township's compliance for the health benefit reimbursements being incurred and paid prior to the Township's request for reimbursement. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302 states in part: "(a) Each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other 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. See also ? 200.450. (b) The financial management system of each non-Federal entity must provide for the following (see also ?? 200.334, 200.335, 200.336, and 200.337): (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number and year, name of the Federal agency, and name of the pass-through entity, if any. (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.328 and 200.329. If a Federal awarding agency requires reporting on an accrual basis from a recipient that maintains its records on other than an accrual basis, the recipient must not be required to establish an accrual accounting system. This recipient may develop accrual data for its reports on the basis of an analysis of the documentation on hand. Similarly, a pass-through entity must not require a subrecipient to establish an accrual accounting system and must allow the subrecipient to develop accrual data for its reports on the basis of an analysis of the documentation on hand. (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. (4) Effective control over, and accountability for, all funds, property, and other assets. The non-Federal entity must adequately safeguard all assets and assure that they are used solely for authorized purposes. See ? 200.303. . . ." Cause A system of internal controls was not designed or implemented by management of the Township which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect management's expectation of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, health insurance benefits were requested for reimbursement without adequate supporting documentation that the amount was paid prior to the request. Noncompliance with the grant agreement and the cash management compliance requirement could result in the loss of future federal funds to the Township. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the Township establish a proper system of internal controls and develop policies and procedures to ensure expenses are paid prior to requesting reimbursement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-005 Subject: Staffing for Adequate Fire and Emergency Response (SAFER) - Reporting Federal Agency: Department of Homeland Security Federal Program: Staffing for Adequate Fire and Emergency Response (SAFER) Assistance Listings Number: 97.083 Federal Award Number and Year (or Other Identifying Number): EMW-2019-FF-00944 Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context Recipients are required to submit Reimbursement Requests, Quarterly Performance Reports, and Semi-Annual SF-425 Federal Financial Reports to the Federal Emergency Management Agency (FEMA). The reporting periods, as well as the respective due dates are based on the calendar year, and recipients must begin to submit reports in the period following the beginning of their period of performance, and throughout the entire period of performance of the grant. Information to be reported includes expenditures for the appropriate reporting period. The Township submitted five reimbursement requests during the audit period. The Director of Finance prepared a sheet with the payroll and benefit amounts to be submitted for reimbursement and provided it to the Assistant Fire Chief. The reimbursement request was filed by the Assistant Fire Chief, without a review or oversight process in place to prevent, or detect and correct, errors and ensure compliance with the reporting compliance requirement. Additionally, the Township did not have a system of internal controls in place to ensure submission of required reports. The Township did not submit the Semi-Annual SF-425 Federal Financial Report that was due by July 30, 2022, or the four Quarterly Performance Reports that were due during the audit period. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.329 states in part: ". . . (b) Reporting program performance. The Federal awarding agency must use OMBapproved common information collections, as applicable, when providing financial and performance reporting information. As appropriate and in accordance with above mentioned information collections, the Federal awarding agency must require the recipient to relate financial data and accomplishments to performance goals and objectives of the Federal award. Also, in accordance with above mentioned common information collections, and when required by the terms and conditions of the Federal award, recipients must provide cost information to demonstrate cost effective practices (e.g., through unit cost data). In some instances (e.g., discretionary research awards), this will be limited to the requirement to submit technical performance reports (to be evaluated in accordance with Federal awarding agency policy). Reporting requirements must be clearly articulated such that, where appropriate, performance during the execution of the Federal award has a standard against which non-Federal entity performance can be measured. (c) Non-construction performance reports. The Federal awarding agency must use standard, governmentwide OMB-approved data elements for collection of performance information including performance progress reports, Research Performance Progress Reports. (1) The non-Federal entity must submit performance reports at the interval required by the Federal awarding agency or pass-through entity to best inform improvements in program outcomes and productivity. Intervals must be no less frequent than annually nor more frequent 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. Reports submitted annually by the non- Federal entity and/or pass-through entity must be due no later than 90 calendar days after the reporting period. Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. Alternatively, the Federal awarding agency or pass-through entity may require annual reports before the anniversary dates of multiple year Federal awards. The final performance report submitted by the non-Federal entity and/or pass-through entity must be due no later than 120 calendar days after the period of performance end date. A subrecipient must submit to the pass-through entity, no later than 90 calendar days after the period of performance end date, all final performance reports as required by the terms and conditions of the Federal award. See also ? 200.344. If a justified request is submitted by a non-Federal entity, the Federal agency may extend the due date for any performance report. . . ." Cause A system of internal controls was not designed or implemented by management of the Township which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be controls consisting of policies and procedures. Policies reflect the management's expectation of what should be done to effect internal control, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, reimbursement requests were completed and filed by one individual and the Semi-Annual SF-425 Federal Financial Report and the four Quarterly Performance Reports due during the audit period were not submitted as required. Noncompliance with the grant agreement and the reporting compliance requirement could result in the loss of future federal funds to the Township. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the Township design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place over reimbursement requestions. In addition, we recommended that management of the Township establish a proper system of internal controls and develop policies and procedures to ensure that all required reports are filed. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-004 Subject: Staffing for Adequate Fire and Emergency Response (SAFER) - Reporting Federal Agency: Department of Homeland Security Federal Program: Staffing for Adequate Fire and Emergency Response (SAFER) Assistance Listings Number: 97.083 Federal Award Numbers and Years (or Other Identifying Numbers): EMW-2017-FH-00374, EMW-2019-FF-01116 Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context Recipients are required to submit Reimbursement Requests, Quarterly Performance Reports, and Semi-Annual SF-425 Federal Financial Reports to the Federal Emergency Management Agency (FEMA). The reporting periods, as well as the respective due dates, are based on the calendar year, and recipients must begin to submit reports in the period following the beginning of their period of performance, and throughout the entire period of performance of the grant. Information to be reported includes expenditures for the appropriate reporting period. Reimbursement Requests The District submitted seven Reimbursement Requests during the audit period. The Financial Coordinator prepared a sheet with the payroll and benefit amounts to be submitted for reimbursement and provided it to the Fire Chief. The Reimbursement Requests were filed by the Fire Chief without a review or oversight process in place to prevent, or detect and correct, errors. Quarterly and Programmatic Performance Reports and Semi-Annual SF-425 Federal Financial Reports EMW-2017-FH-00374 (2017 grant) The District had not implemented or designed a system of internal controls to ensure submission of the Quarterly Performance Reports (quarterly reports) or the Semi-Annual SF-425 Federal Financial Reports. During the audit period, the District was required to submit three quarterly reports and two semi-annual reports. The submission dates for the three quarterly reports could not be determined. Additionally, the District did not submit the Semi-Annual SF-425 Federal Financial Reports that were due by January 30, 2022, and July 30, 2022, in a timely manner. The two reports due were submitted 18 and 19 days late, respectively. EMW-2019-FF-01116 (2019 grant) The District had not implemented or designed a system of internal controls to ensure submission of the Programmatic Performance Report (PPR) or the Semi-Annual SF-425 Federal Financial Report (semi-annual report). During the audit period, the District was required to submit one PPR and two semi-annual reports. The submission date for the PPR, that was due April 30, 2022, could not be determined. In addition, the District did not submit the semi-annual reports that were due by January 30, 2022, and July 30, 2022, in a timely manner. The two reports were submitted 30 and 13 days late, respectively. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.329(c)(1) states in part: "The non-Federal entity must submit performance reports at the interval required by the Federal awarding agency or pass-through entity to best inform improvements in program outcomes and productivity. Intervals must be no less frequent than annually nor more frequent 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. Reports submitted annually by the non-Federal entity and/or pass-through entity must be due no later than 90 calendar days after the reporting period. Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period. Alternatively, the Federal awarding agency or pass-through entity may require annual reports before the anniversary dates of multiple year Federal awards. . . ." Cause A system of internal controls was not designed or implemented by management of the District, which would include segregation of key functions. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect management's statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the seven Quarterly Performance Reports and the four Semi-Annual SF-425 Federal Financial Reports due during the audit period were either not submitted or not submitted timely. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the District. Questioned Costs There were no questioned costs. Recommendation We recommended that management of the District design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place over reimbursement requisitions. In addition, we recommended that management of the District establish a proper system of internal controls and develop policies and procedures to ensure that all required reports are filed and filed timely. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding 2022-002: Significant deficiency in internal control over reporting. Federal Agency Program: U.S. Department of Treasury, Passed through State of Oregon ? Department of Administrative Services Federal Program: 21.027 Coronavirus State and Local Fiscal Recovery Funds Award Period: January 1, 2022 ? December 31, 2022 Criteria: Title 2 U.S. Code of Federal Regulations (CFR) 200.329 requires that non-Federal entities submit performance reports at the interval required by the Federal awarding agency or pass-through entity. The grant agreement required quarterly and annual reports to be submitted. Condition: The quarterly reports and the annual reporting submitted for 2022 by the Organization did not agree to the quarterly information as per the Organization?s accounting records provided. Total award expenditures for the year agreed to the total annual amount reported. Context: Additional procedures were required to reconcile the Federal Award expenditures to the annual reporting submitted. Cause: The Organization received increased support during the year ended December 31, 2022, increasing the complexities of tracking and reporting of Federal expenditures. Policies and procedures over the review and approval of Federal award reporting were not adequately documented. Effect: Without adequate written policies and procedures over the review and approval of reporting of Federal award expenditures, total expenditures by Federal program may not be properly reported. Questioned costs: None. Repeat Finding: No. Recommendation: The Organization should update its written policies and procedures over the review and approval of Federal Award reporting to ensure complete and accurate reporting of award expenditures. Views of Responsible Officials: Management notes the details of this finding. Management will implement procedures to mitigate the outlined issues in our Corrective Action Plan.
2022-003 ? Performance Reporting Federal Agency: U.S. Small Business Administration Federal Program: Microloan Program Assistance Listing Numbers: 59.046 Federal Award Identification Number and Year: ? SBAOCAML210221 ? 2021 ? SBAOCAML220344 ? 2022 Award Period: January 1, 2022 ? December 31, 2022 Type of Finding: ? Significant Deficiency in Internal Control over Compliance ? Compliance - Other Matter Criteria or Specific Requirement: Federal regulations require submission of performance reports at an interval required by the federal awarding agency. Those reports submitted quarterly must be due no later than 30 calendar days after the reporting period. These requirements are outlined in 2 CFR 200.329(c) Monitoring and reporting program performance. Condition: During our testing, we tested two quarterly performance reports and it was noted both were submitted after the required due date outlined in the grant agreement. Questioned Costs: None Context: During our testing, it was noted the Organization did not have proper procedures in place for ensuring timely submission of the quarterly performance reports as required in the federal fund notice of awards. Cause: Management did not have a system in place to ensure the completion and submission of the required performance reporting by the specified due date. Effect: By submitting untimely performance reports, the Organization is not in compliance with the terms and conditions of the award. This did not result in any disallowed costs. Repeat Finding: No Recommendation: We recommend management develop procedures to ensure the required reporting is completed within the timeline allowed by the granting agency. Views of Responsible Officials: Management agrees with finding.