Audit 321596

FY End
2023-12-31
Total Expended
$1.03M
Findings
4
Programs
2
Organization: Town of Pendleton (IN)
Year: 2023 Accepted: 2024-09-27

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
498849 2023-002 Material Weakness - I
498850 2023-003 Material Weakness - L
1075291 2023-002 Material Weakness - I
1075292 2023-003 Material Weakness - L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $633,643 Yes 0
20.205 Highway Planning and Construction $130,657 - 0

Contacts

Name Title Type
CALWXPJNNL54 Town of Pendleton Auditee
7657787937 Beth Kelley, Cpa, Cfe Auditor
No contacts on file

Notes to SEFA

Title: Note 3. Coronavirus State and Local Fiscal Recovery Funds Accounting Policies: Note 1. Summary of Significant Accounting Policies A. Basis of Presentation The accompanying Schedule of Expenditures of Federal Awards (SEFA) includes the federal grant activity of the Town under programs of the federal government for the year ended December 31, 2023. The information in the SEFA is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the SEFA presents only a select portion of the operations of the Town, it is not intended to and does not present the financial position of the Town. B. Other Significant Accounting Policies Expenditures reported on the SEFA are reported on the cash basis of accounting. Such expenditures are recognized following, as applicable, either the cost principles in OMB Circular A-87, Cost Principles for State, Local, and Indian Tribal Governments, or the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowed or are limited as to reimbursement. When federal grants are received on a reimbursement basis, the federal awards are considered expended when the reimbursement is received. De Minimis Rate Used: N Rate Explanation: Note 2. Indirect Cost Rate The Town has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. The Town was awarded a State Water Infrastructure and Transportation & Storm Water Grant Programs (SWIF/TNSW) grant from the Indiana Finance Authority (IFA). The funding source for the SWIF/TNSW grant awards is the Coronavirus State and Local Fiscal Recovery Funds (SLFRF) grant. As the IFA maintained custody of the grant funds and disbursed them on the Town's behalf, some of the activity for the SLFRF grant that is presented on the SEFA is not presented as receipts and disbursements in the financial statement of the Town.

Finding Details

FINDING 2023-002 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Suspension and Debarment Federal Agency: Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Number and Year (or Other Identifying Number): FY 2023 Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Condition and Context Suspension and Debarment Prior to entering into subawards and covered transactions with State and Local Fiscal Recovery Funds (SLFRF), recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the Excluded Parties List System (EPLS), collecting a certification from that person, or adding a clause or condition to the covered transaction with that person. Due to the U.S. Department of the Treasury's (Treasury) determination that the revenue loss eligible use category does not give rise to subawards, the Town was only required to comply with suspension and debarment requirements related to covered transactions. INDIANA STATE BOARD OF ACCOUNTS 16 TOWN OF PENDLETON SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Upon inquiry of the Town, in order to review the procedures in place for verifying that an entity with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, the Town explained they were aware of the suspension and debarment requirements related to the SLFRF awards; however, the Town did not retain documentation of SAM.gov checks nor was a clause always included in a contract. A population of four covered transactions for goods or services, totaling $720,504, that equaled or exceeded $25,000 paid from SLFRF funds during the audit period was identified. A sample of two transactions, totaling $666,643, was selected for testing. For one of the two transactions, the Town did not verify the vendor's suspension and debarment status prior to payment. 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). . . ." 31 CFR 19.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you do business is not excluded or disqualified. You do this by: (a) Checking the EPLS; or (b) Collecting a certification from that person if allowed by this rule; or (c) Adding a clause or condition to the covered transaction with that person." Cause The Town was unable to provide documentation to demonstrate they checked SAM.gov to verify the contractor was not suspended or debarred. Although the Town verified the contractor's suspension and debarment status, no documentation was retained to document the search or results. Effect Without the proper implementation of an effectively designed system of internal controls, the Town cannot ensure the vendors paid with federal funds are eligible to participate in federal programs. Any program funds the Town used to pay vendors that have been suspended or debarred would be unallowable, and the funding agency could potentially recover them. INDIANA STATE BOARD OF ACCOUNTS 17 TOWN OF PENDLETON SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Questioned Costs There were no questioned costs identified. Recommendation We recommended that the Town strengthen its system of internal controls to ensure that all vendors that are paid $25,000 or more, all or in part with federal funds, are not suspended or debarred from participating in federal programs before entering into any covered transactions. In addition, we recommended strengthening policies and procedures to ensure appropriate supporting documentation for federal programs is retained to be presented for audit. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting Federal Agency: Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Number and Year (or Other Identifying Number): FY 2023 Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context Recipients are required to submit quarterly or annually Project and Expenditure (P&E) reports to the U.S. Department of the Treasury (Treasury). The reporting periods, as well as the respective due dates, are based upon type of recipient and its population, as well as the recipient's allocation amount. Information to be reported includes projects funded, expenditures, and contracts for the appropriate reporting period. The Town was classified as a Non-Entitlement Unit with a population below 250,000 residents that are allocated less than $10 million in Coronavirus State and Local Fiscal Recovery Funds (SLFRF). As such, the Town's P&E report, covering the period from April 1, 2022 to March 31, 2023, was required to be submitted to the Treasury by April 30, 2023. The Town timely submitted one P&E report during the audit period; however, the report was submitted without a review or oversight process in place to prevent, or detect and correct, errors. As a result, errors in reporting were identified. The Town reported current expenditures of $33,325, which did not agree with the accounting records. The lack of internal controls and noncompliance were isolated to the one annual P&E report. INDIANA STATE BOARD OF ACCOUNTS 18 TOWN OF PENDLETON SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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). . . ." Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, page 10, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary periodic reports providing detailed accounting of the uses of funds, . . ." The Indiana State Board of Accounts (SBOA) is required under Indiana Code 5-11-1-27(e) to define the acceptable minimum level of internal control standards. To provide clarifying guidance, the State Examiner compiled the standards contained in the manual, Uniform Internal Control Standards for Indiana Political Subdivisions. All political subdivisions subject to audit by SBOA are expected to adhere to these standards. The standards include adequate control activities. According to this manual: "Control activities are the actions and tools established through policies and procedures that help to detect, prevent, or reduce the identified risks that interfere with the achievement of objectives. Detection activities are designed to identify unfavorable events in a timely manner whereas prevention activities are designed to deter the occurrence of an unfavorable event. Examples of these activities include reconciliations, authorizations, approval processes, performance reviews, and verification processes. An integral part of the control activity component is segregation of duties. . . . There is an expectation of segregation of duties. If compensating controls are necessary, documentation should exist to identify both the areas where segregation of duties are not feasible or practical and the compensating controls implemented to mitigate the risk. . . ." INDIANA STATE BOARD OF ACCOUNTS 19 TOWN OF PENDLETON SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls over P&E reports was not implemented by the management of the Town to ensure that complete and accurate information related to the SLFRF awards was provided to the Treasury. 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. The Town incorrectly reported the current expenditures due to misunderstanding the line-item requirement. 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 such, errors, as identified in the Condition and Context, occurred and inaccurate information was provided to the Treasury. 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. In addition, not meeting the SLFRF reporting requirements increases the likelihood that the public will not have access to transparent and accurate information regarding expenditures of federal awards. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the Town design and implement a proper system of internal controls that would provide for segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Additionally, management should develop policies and procedures to ensure that the Town provides the Treasury with complete and accurate information for the P&E report. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. INDIANA STATE BOARD OF ACCOUNTS 20
FINDING 2023-002 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Suspension and Debarment Federal Agency: Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Number and Year (or Other Identifying Number): FY 2023 Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters Condition and Context Suspension and Debarment Prior to entering into subawards and covered transactions with State and Local Fiscal Recovery Funds (SLFRF), recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the Excluded Parties List System (EPLS), collecting a certification from that person, or adding a clause or condition to the covered transaction with that person. Due to the U.S. Department of the Treasury's (Treasury) determination that the revenue loss eligible use category does not give rise to subawards, the Town was only required to comply with suspension and debarment requirements related to covered transactions. INDIANA STATE BOARD OF ACCOUNTS 16 TOWN OF PENDLETON SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Upon inquiry of the Town, in order to review the procedures in place for verifying that an entity with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, the Town explained they were aware of the suspension and debarment requirements related to the SLFRF awards; however, the Town did not retain documentation of SAM.gov checks nor was a clause always included in a contract. A population of four covered transactions for goods or services, totaling $720,504, that equaled or exceeded $25,000 paid from SLFRF funds during the audit period was identified. A sample of two transactions, totaling $666,643, was selected for testing. For one of the two transactions, the Town did not verify the vendor's suspension and debarment status prior to payment. 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). . . ." 31 CFR 19.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you do business is not excluded or disqualified. You do this by: (a) Checking the EPLS; or (b) Collecting a certification from that person if allowed by this rule; or (c) Adding a clause or condition to the covered transaction with that person." Cause The Town was unable to provide documentation to demonstrate they checked SAM.gov to verify the contractor was not suspended or debarred. Although the Town verified the contractor's suspension and debarment status, no documentation was retained to document the search or results. Effect Without the proper implementation of an effectively designed system of internal controls, the Town cannot ensure the vendors paid with federal funds are eligible to participate in federal programs. Any program funds the Town used to pay vendors that have been suspended or debarred would be unallowable, and the funding agency could potentially recover them. INDIANA STATE BOARD OF ACCOUNTS 17 TOWN OF PENDLETON SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Questioned Costs There were no questioned costs identified. Recommendation We recommended that the Town strengthen its system of internal controls to ensure that all vendors that are paid $25,000 or more, all or in part with federal funds, are not suspended or debarred from participating in federal programs before entering into any covered transactions. In addition, we recommended strengthening policies and procedures to ensure appropriate supporting documentation for federal programs is retained to be presented for audit. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-003 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting Federal Agency: Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Number and Year (or Other Identifying Number): FY 2023 Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context Recipients are required to submit quarterly or annually Project and Expenditure (P&E) reports to the U.S. Department of the Treasury (Treasury). The reporting periods, as well as the respective due dates, are based upon type of recipient and its population, as well as the recipient's allocation amount. Information to be reported includes projects funded, expenditures, and contracts for the appropriate reporting period. The Town was classified as a Non-Entitlement Unit with a population below 250,000 residents that are allocated less than $10 million in Coronavirus State and Local Fiscal Recovery Funds (SLFRF). As such, the Town's P&E report, covering the period from April 1, 2022 to March 31, 2023, was required to be submitted to the Treasury by April 30, 2023. The Town timely submitted one P&E report during the audit period; however, the report was submitted without a review or oversight process in place to prevent, or detect and correct, errors. As a result, errors in reporting were identified. The Town reported current expenditures of $33,325, which did not agree with the accounting records. The lack of internal controls and noncompliance were isolated to the one annual P&E report. INDIANA STATE BOARD OF ACCOUNTS 18 TOWN OF PENDLETON SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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). . . ." Coronavirus State and Local Fiscal Recovery Funds Compliance and Reporting Guidance, page 10, states in part: ". . . 10. Reporting. All recipients of federal funds must complete financial, performance, and compliance reporting as required and outlined in Part 2 of this guidance. Expenditures may be reported on a cash or accrual basis, as long as the methodology is disclosed and consistently applied. Reporting must be consistent with the definition of expenditures pursuant to 2 CFR 200.1. Your organization should appropriately maintain accounting records for compiling and reporting accurate, compliant financial data, in accordance with appropriate accounting standards and principles. . . ." 31 CFR 35.4(c) states in part: "Reporting and requests for other information. During the period of performance, recipients shall provide to the Secretary periodic reports providing detailed accounting of the uses of funds, . . ." The Indiana State Board of Accounts (SBOA) is required under Indiana Code 5-11-1-27(e) to define the acceptable minimum level of internal control standards. To provide clarifying guidance, the State Examiner compiled the standards contained in the manual, Uniform Internal Control Standards for Indiana Political Subdivisions. All political subdivisions subject to audit by SBOA are expected to adhere to these standards. The standards include adequate control activities. According to this manual: "Control activities are the actions and tools established through policies and procedures that help to detect, prevent, or reduce the identified risks that interfere with the achievement of objectives. Detection activities are designed to identify unfavorable events in a timely manner whereas prevention activities are designed to deter the occurrence of an unfavorable event. Examples of these activities include reconciliations, authorizations, approval processes, performance reviews, and verification processes. An integral part of the control activity component is segregation of duties. . . . There is an expectation of segregation of duties. If compensating controls are necessary, documentation should exist to identify both the areas where segregation of duties are not feasible or practical and the compensating controls implemented to mitigate the risk. . . ." INDIANA STATE BOARD OF ACCOUNTS 19 TOWN OF PENDLETON SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls over P&E reports was not implemented by the management of the Town to ensure that complete and accurate information related to the SLFRF awards was provided to the Treasury. 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. The Town incorrectly reported the current expenditures due to misunderstanding the line-item requirement. 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 such, errors, as identified in the Condition and Context, occurred and inaccurate information was provided to the Treasury. 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. In addition, not meeting the SLFRF reporting requirements increases the likelihood that the public will not have access to transparent and accurate information regarding expenditures of federal awards. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the Town design and implement a proper system of internal controls that would provide for segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place. Additionally, management should develop policies and procedures to ensure that the Town provides the Treasury with complete and accurate information for the P&E report. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. INDIANA STATE BOARD OF ACCOUNTS 20