FINDING 2024-004 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 Numbers and Years (or Other Identifying Numbers): 92-02, 92-03, 92-04, 92-05 Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context As part of sound management of the federal award, the City was responsible for implementing a system of internal controls that would ensure compliance with the applicable requirements. The City had not properly designed or implemented such a system, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The City was required to submit two annual data reports to the Department of Agriculture. The Statement of Budget, Income and Equity (Form RD 442-2) report data to be submitted included, but was not limited to, current income and expenditures and budgeted amounts. The Balance Sheet (Form RD 442-3) report data to be submitted included, but was not limited to, current year assets and liabilities. Per the USDA Rural Utilities Service Borrower's Guide, both reports also required inclusion of comparative information for the prior year. Both reports were selected for testing. We were unable to trace either report to the City's records, nor could we verify the accuracy and completeness of either report. The following errors were identified: • The Form RD 442-2, which covered calendar year 2023, reported total income and expenses of $3,792,018 and $1,615,582, respectively. However, the City's ledger for the same period had total income and expenses of $3,985,851 and $3,740,788, respectively. This resulted in net income being overstated by $2,319,039. Additionally, only one amount was reported as comparative data for prior year activity. We were unable to determine what this amount represented and were unable to verify it to the prior period report or to the City's records. • The Form RD 442-3, which covered calendar year 2023, reported total assets and liabilities of $18,229,653 and $10,503,419, respectively. However, the City's records for the same period had total assets and liabilities of $39,216,648 and $12,758498, respectively. Additionally, no comparative amounts from the prior year were reported. 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. . . ." 7 CFR 1780.47 states in part: "(a) Borrowers are required to provide RUS an annual audit or financial statements. . . . (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.) • The Form RD 442-3, which covered calendar year 2023, reported total assets and liabilities of $18,229,653 and $10,503,419, respectively. However, the City's records for the same period had total assets and liabilities of $39,216,648 and $12,758498, respectively. Additionally, no comparative amounts from the prior year were reported. 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. . . ." 7 CFR 1780.47 states in part: "(a) Borrowers are required to provide RUS an annual audit or financial statements. . . . (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.)• The Form RD 442-3, which covered calendar year 2023, reported total assets and liabilities of $18,229,653 and $10,503,419, respectively. However, the City's records for the same period had total assets and liabilities of $39,216,648 and $12,758498, respectively. Additionally, no comparative amounts from the prior year were reported. 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. . . ." 7 CFR 1780.47 states in part: "(a) Borrowers are required to provide RUS an annual audit or financial statements. . . . (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. . . ." Cause The Clerk-Treasurer had served in the position for less than two years when the reports for 2024 were due and was inexperienced with the reporting requirements of the award. As a result, the Clerk-Treasurer did not properly prepare the reports. Additionally, the Clerk-Treasurer was solely responsible for preparing and submitting the reports with no oversight, review, or approval process that would have allowed for prevention, or detection and correction, of the noncompliance. Effect Without a proper system of internal controls in place that operated effectively, the City did not file an accurate and complete report for either annual report required under the federal award. As a result, material noncompliance occurred and remained undetected. By not reporting the comparative data, all information needed to determine the financial status of the City was not readily available. 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 the City's management establish a proper system of internal controls and develop and implement reporting policies and procedures to ensure that all required reports are filed timely, accurately, and contain all the required information. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.