Audit 320097

FY End
2023-12-31
Total Expended
$2.72M
Findings
2
Programs
5
Year: 2023 Accepted: 2024-09-19

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
497361 2023-002 Material Weakness - L
1073803 2023-002 Material Weakness - L

Contacts

Name Title Type
U63BAAW8FP28 Michelle Holt Auditee
5099439185 Ruby Chung Auditor
No contacts on file

Notes to SEFA

Title: Program Costs Accounting Policies: This schedule is prepared on the same basis of accounting as the Council's financial statements. The Council uses the accrual basis. De Minimis Rate Used: N Rate Explanation: The Council has not elected to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. The amounts shown as current-year expenses represent only the federal grant portion of the program costs. Entire program costs, including the Council of Governments' portion, may be more than shown.
Title: Determination of Expenses for the CARES COVID Relief Revolving Loan Fund Accounting Policies: This schedule is prepared on the same basis of accounting as the Council's financial statements. The Council uses the accrual basis. De Minimis Rate Used: N Rate Explanation: The Council has not elected to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. The Council of Governments has a Revolving Loan Fund to provide loans due to the urgency of the COVID-19 pandemic. Under this federal grant, expenses are calculated as principal balance outstanding plus cash and investment balance of funds on hand plus loan-related expenses paid out of income during the fiscal year.
Title: Indirect Cost Allocation Plan Accounting Policies: This schedule is prepared on the same basis of accounting as the Council's financial statements. The Council uses the accrual basis. De Minimis Rate Used: N Rate Explanation: The Council has not elected to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. The Council of Governments has historically developed an Indirect Cost Allocation Plan (ICAP) annually based on the adopted agency budget for that calendar year. The ICAP is prepared to recover anticipated overhead expenses across all agency programs for the year, reflecting any overage (or shortage) from the prior year. This is referred to as a "Fixed Carryforward Rate. The fixed carryforward rate is based on an estimate of the costs that will be incurred during the period for which the rate applies. When the actual costs for such period have been determined, an adjustment will be made to the rate for a future period, if necessary, to compensate for the difference between the costs used to establish the fixed rate and the actual costs." The ICAP rate is applied to total direct salaries and wages, excluding fringe benefits, and applies to all programs administered by BFCOG. The Benton-Franklin Council of Governments (BFCOG) is a multipurpose agency responsible for using Federal funds from multiple sources. These include the US Department of Transportation, the US Department of Commerce, and the US Department of Agriculture. It was previously determined that the cognizant agency for BFCOG is the Department of Interior. The ICAP rate for 2023 was 156.42%.

Finding Details

The Council’s internal controls were inadequate for ensuring compliance with federal reporting requirements for the Economic Assistance Adjustment Program. Assistance Listing Number and Title: 11.307, COVID-19 Economic Adjustment Assistance Federal Grantor Name: U.S. Department of Commerce Economic Development Administration Federal Award/Contract Number: 07-79-07622 Pass-through Entity Name: N/A Pass-through Award/Contract Number: N/A Known Questioned Cost Amount: $0 Prior Year Audit Finding: N/A Background The primary objective of the Economic Adjustment Assistance program is to assist communities with revitalizing and expanding their physical and economic infrastructure and support the creation and retention of jobs for area residents by helping eligible recipients promote the economic development of their local economies. To carry out the program objective, the Council distributes business loans from the money it receives from the U.S. Economic Development Administration (EDA) using a revolving loan fund (RLF). Qualified businesses in Benton and Franklin counties can apply to this program for a financial assistance business loan. In 2023, the Council reported a $1,803,471 outstanding loan balance for its Economic Adjustment Assistance program. Federal regulations require recipients to establish and maintain internal controls that ensure compliance with program requirements. These controls include understanding program requirements and monitoring the effectiveness of established controls. The Council must submit semiannual financial reports to the EDA so it can monitor the Council’s management and use of program funds from the RLF. The EDA requires the Council to include in its reports key line items, or financial information the EDA considers critical in measuring how the Council manages program funds. Description of Condition The Council did not have internal controls to ensure the financial information it reported in the semiannual financial reports was accurate and supported. We consider this internal control deficiency to be a material weakness that led to material noncompliance. Cause of Condition The Council experienced staff turnover and did not provide the Council employee responsible for submitting the semiannual reports adequate training to complete the reports accurately. Additionally, because the Council had limited access to the EDA portal where the financial reports are submitted, it did not establish a process to review the reports before submitting them. Effect of Condition The ED-209 report documents the number of loans, amount loaned and outstanding principal of both active and written-off loans, capital base, income used for administrative expenses, income earned, leverage and loan leverage ratio. These semiannual reports include information the EDA uses to conduct risk analysis ratings of each RLF recipient’s RLF program to assess the strengths and weaknesses of each and to identify RLFs that require additional monitoring, technical assistance or other corrective action. Failing to submit accurate and complete information to the EDA diminishes the federal government’s ability to monitor the Council’s RLF program. Recommendation We recommend the Council establish and follow internal controls to ensure compliance with federal laws and regulations. Specifically, we recommend the Council provide adequate training to staff that prepare the semiannual reports, and review financial information reported for completeness and accuracy in compliance with the program’s requirements. Council’s Response BFCOG concurs with this finding. An unfortunate comedy of errors led to the creation, submission, and acceptance of the FY2023 Mid-Year and Year-End Financial Reports for the EDA CARES Revolving Loan Fund activities. These errors included changes in BFCOG key staff at the end of 2022 and again mid-way through 2023, a lack of understanding by BFCOG staff of the EDA Portal and the report's pre-population and cumulation functions, a lack of documentation to support the submitted reports, and a lack of review for accuracy by BOTH BFCOG and EDA. The internal financial reports necessary to accurately complete the EDA Financial Reports were readily available, as was training on the EDA Portal and Report functions. BFCOG, indeed, was lacking internal controls. It is important to note that the EDA RLF Administrator accepted both reports as submitted and without requesting correction, even though they had nearly identical data to the 2022 year-end report. Had either report been returned by EDA for correction, the problem could have been identified and corrected promptly. Auditor’s Remarks We appreciate the Council’s commitment to resolve this finding and thank the Council for its cooperation and assistance during the audit. We will review the corrective action taken during our next regular audit Applicable Laws and Regulations Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), section 516, Audit findings, establishes reporting requirements for audit findings. Title 2 CFR Part 200, Uniform Guidance, section 303, Internal controls, describes the requirements for auditees to maintain internal controls over federal programs and comply with federal program requirements. The American Institute of Certified Public Accountants defines significant deficiencies and material weaknesses in its Codification of Statements on Auditing Standards, section 935, Compliance Audits, paragraph 11.
The Council’s internal controls were inadequate for ensuring compliance with federal reporting requirements for the Economic Assistance Adjustment Program. Assistance Listing Number and Title: 11.307, COVID-19 Economic Adjustment Assistance Federal Grantor Name: U.S. Department of Commerce Economic Development Administration Federal Award/Contract Number: 07-79-07622 Pass-through Entity Name: N/A Pass-through Award/Contract Number: N/A Known Questioned Cost Amount: $0 Prior Year Audit Finding: N/A Background The primary objective of the Economic Adjustment Assistance program is to assist communities with revitalizing and expanding their physical and economic infrastructure and support the creation and retention of jobs for area residents by helping eligible recipients promote the economic development of their local economies. To carry out the program objective, the Council distributes business loans from the money it receives from the U.S. Economic Development Administration (EDA) using a revolving loan fund (RLF). Qualified businesses in Benton and Franklin counties can apply to this program for a financial assistance business loan. In 2023, the Council reported a $1,803,471 outstanding loan balance for its Economic Adjustment Assistance program. Federal regulations require recipients to establish and maintain internal controls that ensure compliance with program requirements. These controls include understanding program requirements and monitoring the effectiveness of established controls. The Council must submit semiannual financial reports to the EDA so it can monitor the Council’s management and use of program funds from the RLF. The EDA requires the Council to include in its reports key line items, or financial information the EDA considers critical in measuring how the Council manages program funds. Description of Condition The Council did not have internal controls to ensure the financial information it reported in the semiannual financial reports was accurate and supported. We consider this internal control deficiency to be a material weakness that led to material noncompliance. Cause of Condition The Council experienced staff turnover and did not provide the Council employee responsible for submitting the semiannual reports adequate training to complete the reports accurately. Additionally, because the Council had limited access to the EDA portal where the financial reports are submitted, it did not establish a process to review the reports before submitting them. Effect of Condition The ED-209 report documents the number of loans, amount loaned and outstanding principal of both active and written-off loans, capital base, income used for administrative expenses, income earned, leverage and loan leverage ratio. These semiannual reports include information the EDA uses to conduct risk analysis ratings of each RLF recipient’s RLF program to assess the strengths and weaknesses of each and to identify RLFs that require additional monitoring, technical assistance or other corrective action. Failing to submit accurate and complete information to the EDA diminishes the federal government’s ability to monitor the Council’s RLF program. Recommendation We recommend the Council establish and follow internal controls to ensure compliance with federal laws and regulations. Specifically, we recommend the Council provide adequate training to staff that prepare the semiannual reports, and review financial information reported for completeness and accuracy in compliance with the program’s requirements. Council’s Response BFCOG concurs with this finding. An unfortunate comedy of errors led to the creation, submission, and acceptance of the FY2023 Mid-Year and Year-End Financial Reports for the EDA CARES Revolving Loan Fund activities. These errors included changes in BFCOG key staff at the end of 2022 and again mid-way through 2023, a lack of understanding by BFCOG staff of the EDA Portal and the report's pre-population and cumulation functions, a lack of documentation to support the submitted reports, and a lack of review for accuracy by BOTH BFCOG and EDA. The internal financial reports necessary to accurately complete the EDA Financial Reports were readily available, as was training on the EDA Portal and Report functions. BFCOG, indeed, was lacking internal controls. It is important to note that the EDA RLF Administrator accepted both reports as submitted and without requesting correction, even though they had nearly identical data to the 2022 year-end report. Had either report been returned by EDA for correction, the problem could have been identified and corrected promptly. Auditor’s Remarks We appreciate the Council’s commitment to resolve this finding and thank the Council for its cooperation and assistance during the audit. We will review the corrective action taken during our next regular audit Applicable Laws and Regulations Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), section 516, Audit findings, establishes reporting requirements for audit findings. Title 2 CFR Part 200, Uniform Guidance, section 303, Internal controls, describes the requirements for auditees to maintain internal controls over federal programs and comply with federal program requirements. The American Institute of Certified Public Accountants defines significant deficiencies and material weaknesses in its Codification of Statements on Auditing Standards, section 935, Compliance Audits, paragraph 11.