Corrective Action Plans

Finding 499776 (2023-003)

Material Weakness 2023

Greenwich Communities (f/ka)housing Authority of the Town of Greenwich

CT

HUD Housing Programs Material Weakness Internal Control / Segregation of Duties

Management concurs with the finding and has updated the tenant waiting list for all projects in the Low Income Public Housing program. In addition, management established plans to provide additional training and review of the waiting lists going forward by the Director of Housing Management to ensur...

Management concurs with the finding and has updated the tenant waiting list for all projects in the Low Income Public Housing program. In addition, management established plans to provide additional training and review of the waiting lists going forward by the Director of Housing Management to ensure that waiting lists are maintained in accordance with the applicable regulations.

View Audit 322620

Finding 499775 (2023-002)

Material Weakness 2023

Greenwich Communities (f/ka)housing Authority of the Town of Greenwich

CT

HUD Housing Programs Eligibility Material Weakness

Management concurs with the finding and has established plans to provide additional training and review of tenant files going forward by the Director of Housing Management to ensure required tenant certifications are performed timely and completely, and all required tenant certification documentatio...

Management concurs with the finding and has established plans to provide additional training and review of tenant files going forward by the Director of Housing Management to ensure required tenant certifications are performed timely and completely, and all required tenant certification documentation is included in tenant files.

View Audit 322620

Finding 499753 (2023-004)

Material Weakness 2023

City of Lawrence

IN

Internal Control / Segregation of Duties Allowable Costs / Cost Principles Material Weakness § 200.1 § 200.303

FINDING 2023-004 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting Contact Person Responsible for Corrective Action: Humphrey Nagila Contact Phone Number: 317-542-4554 Views of Responsible Official: We agree with this finding. The City will create a policy and procedu...

FINDING 2023-004 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting Contact Person Responsible for Corrective Action: Humphrey Nagila Contact Phone Number: 317-542-4554 Views of Responsible Official: We agree with this finding. The City will create a policy and procedure to ensure appropriate segregation of duties and reviews, approvals, and oversight are in place for reporting. This policy will require that two staff members from the Controller's Office prepare the quarterly Project and Expenditure report (P&E report). One staff member shall be responsible for preparing the report and the other will complete a review and submission of the report. Anticipated Completion Date: 12/31/2024

View Audit 322579

Finding 499643 (2023-005)

Material Weakness 2023

City of New Castle

IN

Internal Control / Segregation of Duties Allowable Costs / Cost Principles Material Weakness § 200.303

FINDING 2023-005 Finding Subject: COVID-19 STATE AND LOCAL FISCAL RECOVERY REPORTING Summary of Finding: There were deficiencies in the internal control system of the City over the grant’s reporting requirements. Contact Person Responsible for Corrective Action: Ashley Huffman Contact Phone Number a...

FINDING 2023-005 Finding Subject: COVID-19 STATE AND LOCAL FISCAL RECOVERY REPORTING Summary of Finding: There were deficiencies in the internal control system of the City over the grant’s reporting requirements. Contact Person Responsible for Corrective Action: Ashley Huffman Contact Phone Number and Email Address: 765-521-6803 nccityclerk@gmail.com Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: Beginning Sept. 1, 2024, procedures put in place include the Clerk Treasurer and Deputy Clerk Treasurer verifying each other with the reporting. Internal controls are the Clerk Treasurer will review and include the information to prepare the required reports. Monthly receipt detail and disbursement detail reports will be included, with the Deputy reviewing that. Both will sign off after reviews and communication. Additionally, the monthly detail reports will be provided to the City's Finance Committee and Council who oversees the ARP funds. Anticipated completion date: September 1, 2024

View Audit 322522

Finding 499634 (2023-004)

Material Weakness 2023

Floyd County

IN

Internal Control / Segregation of Duties Allowable Costs / Cost Principles Material Weakness § 200.1 § 200.303

FINDING 2023-004 Finding Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting Summary of Finding: The County submitted four P&E reports during the audit period; however, the errors as identified below were noted on all four reports.  Quarterly Report: October 1, 2022 to...

FINDING 2023-004 Finding Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting Summary of Finding: The County submitted four P&E reports during the audit period; however, the errors as identified below were noted on all four reports.  Quarterly Report: October 1, 2022 to December 31, 2022 Current period expenditures reported 7 projects with errors totaling $77,234. Cumulative expenditures reported 22 projects with errors totaling $3,955,669.  Quarterly Report: January 1, 2023 to March 31, 2023 Current period expenditures reported 7 projects with errors totaling $173,169. Cumulative expenditures reported 25 projects with errors totaling $2,633,217.  Quarterly Report: April 1, 2023 to June 30, 2023 Current period expenditures reported 2 projects with errors totaling $0, since expenditures were posted to the incorrect project. Cumulative expenditures reported 24 projects with errors totaling $2,372,744.  Quarterly Report: July 1, 2023 to September 30, 2023 Current period expenditures reported 3 projects with errors totaling $13,412. Cumulative expenditures reported 26 projects with errors totaling $2,273,749. Contact Person Responsible for Corrective Action: Don Lopp, Director of Operations and County Planning Contact Phone Number and Email Address: 812-948-4110 and dlopp@floydcounty.in.gov Views of Responsible Officials: We concur with the finding Description of Corrective Action Plan: As Director of Operations and Planning, the American Rescue Plan quarterly reports are submitted through the office. During the last two audit, it appears data input errors have occurred with the reporting of total expenditures. The initial corrective action of review was not sufficient to correct the data input errors. During the recent July 2024 quarterly report, staff reviewed the items on line and believe that all reporting has been corrected. Starting with the September reporting, two staff members will review the data input Anticipated Completion Date: September 2024 – For the third quarter reporting period.

View Audit 322513

Finding 499553 (2023-002)

Material Weakness 2023

Putnam County

IN

Internal Control / Segregation of Duties Reporting Allowable Costs / Cost Principles § 200.1 § 200.303

FINDING 2023-002 Finding Subject: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds - Reporting Summary of Finding: The SLRF report did not include project information or amounts. Contact Person Responsible for Corrective Action: Auditor Contact Phone Number and Email Address: 765-653-551...

FINDING 2023-002 Finding Subject: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds - Reporting Summary of Finding: The SLRF report did not include project information or amounts. Contact Person Responsible for Corrective Action: Auditor Contact Phone Number and Email Address: 765-653-5513, auditor@putnam.in.us Views of Responsible Officials: We concur with the finding Description of Corrective Action Plan: We have reached out to Baker Tilly, who does the reports for the County, regarding our audit finding so they know the reporting requirements that will need to be done for the next project and expenditure report which is due to be filed by April 30, 2025. Once we receive the report from Baker Tilly we will have a county employee review for accuracy of the report. Anticipated Completion Date: April 30, 2025

View Audit 322406

Finding 499543 (2023-004)

Material Weakness 2023

Perry County

IN

Allowable Costs / Cost Principles Material Weakness Reporting § 200.1 § 200.303

FINDING 2023-004 Subject: COVID 19 - Coronavirus State and Local Fiscal Recovery Fund - Reporting Federal Summary of Finding: Perry County did not properly report period expenditures. The County submitted one P&E report during the audit period. Although the Deputy Auditor compiled the information fo...

FINDING 2023-004 Subject: COVID 19 - Coronavirus State and Local Fiscal Recovery Fund - Reporting Federal Summary of Finding: Perry County did not properly report period expenditures. The County submitted one P&E report during the audit period. Although the Deputy Auditor compiled the information for the report and the County Auditor reviewed and submitted the report, the internal controls were not effective in preventing, or detecting and correcting, errors. As a result, the P&E report contained errors. Contact Person Responsible for Corrective Action: Kristinia L. Hammack, Perry County Auditor Contact Phone Number: (812) 547-6427 Views of Responsible Officials: We concur with the audit finding. Description of Corrective Action Plan: The Auditor is now aware that the P&E Reporting Period is not calendar. All internal control will stay in place and this information will be noted for further SLFRF Reporting. The Auditor will review the reports prior to submission to ensure that the reporting period is not on a calendar year when reporting. Completion Date: March 1, 2025 INDIANA STATE

View Audit 322397

Finding 499541 (2023-004)

Material Weakness 2023

Tongue River Valley Joint Powers Board

WY

Material Weakness Internal Control / Segregation of Duties § 200.512

2023-004 Audit Report Submission to Federal Government Material Weakness in Internal Control over Compliance The Chairman of the Tongue River Valley Joint Powers Board will diligently comply with the Federal Reporting deadlines now that a consistent relationship has been established with an auditing...

2023-004 Audit Report Submission to Federal Government Material Weakness in Internal Control over Compliance The Chairman of the Tongue River Valley Joint Powers Board will diligently comply with the Federal Reporting deadlines now that a consistent relationship has been established with an auditing firm. Ongoing process.

View Audit 322395

Finding 499538 (2023-001)

Material Weakness 2023

Tongue River Valley Joint Powers Board

WY

Procurement, Suspension & Debarment Cash Management Material Weakness

2023-001 Inadequate Supporting Documentation Material Weakness The Chairman of the Tongue River Valley Joint Power Board will make two copies of all invoices. One set of invoices will be retained by the Chairman and the other will be retained by the treasurer to improve the necessary documentation. ...

2023-001 Inadequate Supporting Documentation Material Weakness The Chairman of the Tongue River Valley Joint Power Board will make two copies of all invoices. One set of invoices will be retained by the Chairman and the other will be retained by the treasurer to improve the necessary documentation. This process is becoming more streamlined now that the board is current on its invoices. This an ongoing process.

View Audit 322395

Finding 499532 (2023-013)

Material Weakness 2023

Hennepin County Minnesota

MN

Equipment & Real Property Management Material Weakness Matching / Level of Effort / Earmarking

Subject: Hennepin County’s 2023 Corrective Action Plan Finding# 2023-013 Equipment and Real Property Management Program: Congressional Directives (ALN 93.493) Type of Finding: Material Weakness in Internal Control over Compliance; Other Matter Compliance Finding Condition: The county hospital...

Subject: Hennepin County’s 2023 Corrective Action Plan Finding# 2023-013 Equipment and Real Property Management Program: Congressional Directives (ALN 93.493) Type of Finding: Material Weakness in Internal Control over Compliance; Other Matter Compliance Finding Condition: The county hospital does not have effective internal controls over the equipment and real property management requirement of the Congressional Directives program. In addition, during our testing we noted that while most items were listed with serial number and location, the other required information was not being consistently included. Hennepin County’s Corrective Action Planned in Response to Finding: Hennepin Healthcare System, Inc. (HHS) will establish a process to review records of property obtained with federal funds to update with complete information for existing and new property obtained. Hennepin County Employee Responsible for the CAP: Mike Armstrong Planned Completion Date for CAP: December 31, 2024

View Audit 322389

Finding 499526 (2023-007)

Material Weakness 2023

Hennepin County Minnesota

MN

Eligibility Subrecipient Monitoring Cash Management § 200.303

Subject: Hennepin County’s 2023 Corrective Action Plan Finding# 2023-007 Eligibility Program: Medical Assistance Program (ALN 93.778) Type of Finding: Material Weakness in Internal Control over Compliance; Other Matter Compliance Finding Condition: During our testing, we noted the following 8 in...

Subject: Hennepin County’s 2023 Corrective Action Plan Finding# 2023-007 Eligibility Program: Medical Assistance Program (ALN 93.778) Type of Finding: Material Weakness in Internal Control over Compliance; Other Matter Compliance Finding Condition: During our testing, we noted the following 8 instances of noncompliance in the sample of 120 case files tested: • Five MAXIS (eligibility determination system) case files had different bases of eligibility in MAXIS and MMIS (payment system). For three of the five cases, MAXIS indicated the beneficiary was “EX” (age 65 or older) while MMIS indicated the beneficiary was “DX” (disabled). For one of the five cases, MAXIS indicated the beneficiary was “1619(b)” (people who no longer receive an SSI cash benefit and maintain their disability status) while MMIS indicated the beneficiary was “DX” (disabled) and the final case indicated the beneficiary was “DC” (disabled child 18-20) in MAXIS while MMIS indicated the beneficiary was “DT” (disabled child under TEFRA option). • Two MAXIS case files did not have a signed application on file. • One MAXIS case file did not have citizenship verified. In addition, the County does not have a formalized supervisory case file review process in place to ensure accuracy and completeness of inputs into the two eligibility determination systems, MAXIS and METS. Hennepin County’s Corrective Action Planned in Response to Finding: Hennepin County will strengthen internal controls over inputs used to determine eligibility to ensure they are correctly entered and the information required by the contract is retained in the County’s records. Hennepin County Employee Responsible for the CAP: Vickie Goulette Planned Completion Date for CAP: December 31, 2024

View Audit 322389

Finding 499508 (2023-002)

Material Weakness 2023

City of Crawfordsville

IN

Internal Control / Segregation of Duties Allowable Costs / Cost Principles Material Weakness § 200.1 § 200.303

FINDING 2023-002 Subject: Coronavirus State and Local Fiscal Recovery Funds - Reporting Federal Agency: U.S. Department of Treasury Assistance Listing Number: 21.027 Federal Award Number: FY 2022 Pass-Through Entity: N/A Compliance Requirements: Reporting Audit Findings: Material Weakness, Modifie...

FINDING 2023-002 Subject: Coronavirus State and Local Fiscal Recovery Funds - Reporting Federal Agency: U.S. Department of Treasury Assistance Listing Number: 21.027 Federal Award Number: FY 2022 Pass-Through Entity: N/A Compliance Requirements: Reporting Audit Findings: Material Weakness, Modified Opinion Condition: The City had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties that would likely be effective in preventing, or detecting and correcting, noncompliance. Recipients are required to submit quarterly or annually Project and Expenditure (P&E) reports to the Department of 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 City was classified as a metropolitan city with a population below 250,000 residents that received an allocation of less than $10 million in Coronavirus State and Local Fiscal Recovery Funds (CSLFRF). As, annual reports are to cover one calendar year and must be submitted to the Treasury by April 30 each year. Context: The City submitted one P&E report during the audit period; however, a single employee prepared and submitted the P&E report without a review or oversight process in place to prevent, or detect and correct errors. In addition, the P&E report was not properly supported by the City’s records. All but $100,000 of the expenditures were reported under the Eligible Use Category of “Administrative Expenses.” However, the City’s expenditures during the audit period consisted of assistance to business and households, sewer infrastructure, and tourism support, none of which qualified as Administrative Expenses. Furthermore, the City reported that it was electing to take the Revenue Loss Standard Allowance, but the amount reported as Revenue Loss was $0. Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The City of Crawfordsville management will follow the following process. 1. Before processing request from designated organizations the Clerk Treasurer and Mayor or a designated person, will review documentation and approve for payment/claim processing. 2. After approval a claim will be submitted to the Clerk Treasurer office for payment. 3. Clerk Treasurer will prepare and submit monthly expenditure report to the Mayor or designated person. 4. Annually before the Clerk Treasurer, reports to the U.S. Treasury expenditures the Clerk Treasurer and Mayor, or designated person, will review and confirm expenditures. 5. Clerk Treasurer will submit report to U.S. Treasury following prompts. 6. Clerk Treasurer will notify Mayor of the annual report submission. Responsible Party and Timeline for Completion: Clerk Treasurer and the submission that takes place in 2024 (2023 report).

View Audit 322367

Finding 499499 (2023-002)

Material Weakness 2023

Wicomico County Housing Authority

MD

Special Tests & Provisions HUD Housing Programs Material Weakness

Recommendation: The Authority should review and enhance its internal controls to ensure: · the utility allowance schedules are reviewed and updated as necessary at least annually; and units are inspected annually under HQS. Explanation of disagreement with audit finding: There is no disagreement wit...

Recommendation: The Authority should review and enhance its internal controls to ensure: · the utility allowance schedules are reviewed and updated as necessary at least annually; and units are inspected annually under HQS. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: The Authority specialist responsible for file maintenance and recertifications during fiscal year 2022 and early 2023 is no longer with the Agency. The Authority has experienced staff now in place to perform these services. The Authority will revisit our policy and procedures over recertification, HQS, and file maintenance to ensure documentation is maintained and is in compliance with HUD regulations. Name(s) of the contact person(s) responsible for corrective action: Don Bibb, Executive Director Planned completion date for corrective action plan: December 31, 2024

View Audit 322360

Finding 499498 (2023-001)

Material Weakness 2023

Wicomico County Housing Authority

MD

HUD Housing Programs Eligibility Material Weakness

Recommendation: The Authority should review and enhance its internal controls to ensure: . management obtains and reviews documentation supporting United States of America citizenship; . tenants provide release forms prior to obtaining necessary documentation; . management verifies income listed on ...

Recommendation: The Authority should review and enhance its internal controls to ensure: . management obtains and reviews documentation supporting United States of America citizenship; . tenants provide release forms prior to obtaining necessary documentation; . management verifies income listed on the HUD Form 50058; and recertifications are consistently reviewed and approved. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: The Authority specialist responsible for file maintenance and recertifications during fiscal year 2022 and early 2023 is no longer with the Agency. The Authority has experienced staff now in place to perform these services. The Authority will revisit our policy and procedures over recertification and file maintenance to ensure documentation is maintained and is in compliance with HUD regulations. Name(s) of the contact person(s) responsible for corrective action: Don Bibb, Executive Director Planned completion date for corrective action plan: December 31, 2024

View Audit 322360

Finding 499473 (2023-004)

Material Weakness 2023

Housing Authority of Racine County

WI

HUD Housing Programs Material Weakness Internal Control / Segregation of Duties

Housing Choice Voucher Cluster – Assistance Listing No. 14.871 and 14.879 Recommendation: We recommend that the Authority review its system of internal control related to the policies and procedures in place to mitigate the risk of noncompliance with the requirements of the stated criteria. Explanat...

Housing Choice Voucher Cluster – Assistance Listing No. 14.871 and 14.879 Recommendation: We recommend that the Authority review its system of internal control related to the policies and procedures in place to mitigate the risk of noncompliance with the requirements of the stated criteria. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: In order to remedy and mitigate audit findings that have been building over the past several years, PHA has moved to a task-based model, and have begun using production trackers for transparency. After a program management staffing change in March 2024, PHA is now pulling SEMAP reports monthly and conducting internal file audits to monitor program compliance. Name(s) of the contact person(s) responsible for corrective action: Deborah Madsen, Executive Director Planned completion date for corrective action plan: 12/31/2024

View Audit 322309

Finding 499472 (2023-003)

Material Weakness 2023

Housing Authority of Racine County

WI

HUD Housing Programs Material Weakness Internal Control / Segregation of Duties

2023-003 Housing Choice Voucher Cluster – Assistance Listing No. 14.871 and 14.879 Recommendation: We recommend that the Authority review its system of internal control related to the policies and procedures in place to mitigate the risk of noncompliance with the requirements of the stated criteria....

2023-003 Housing Choice Voucher Cluster – Assistance Listing No. 14.871 and 14.879 Recommendation: We recommend that the Authority review its system of internal control related to the policies and procedures in place to mitigate the risk of noncompliance with the requirements of the stated criteria. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: In order to remedy and mitigate audit findings that have been building over the past several years, PHA has moved to a task-based model, and have begun using production trackers for transparency. After a program management staffing change in March 2024, PHA is now pulling SEMAP reports monthly and conducting internal file audits to monitor program compliance. Name(s) of the contact person(s) responsible for corrective action: Deborah Madsen, Executive Director Planned completion date for corrective action plan: 12/31/2024

View Audit 322309

Finding 499471 (2023-002)

Material Weakness 2023

Housing Authority of Racine County

WI

Internal Control / Segregation of Duties Special Tests & Provisions Eligibility

U.S. Department of Housing and Urban Development 2023-002 Housing Choice Voucher Cluster – All Programs Recommendation: We recommend that the Authority’s management reviews the accounting information which is the best means of preventing and detecting errors and irregularities. Explanation of disagr...

U.S. Department of Housing and Urban Development 2023-002 Housing Choice Voucher Cluster – All Programs Recommendation: We recommend that the Authority’s management reviews the accounting information which is the best means of preventing and detecting errors and irregularities. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: In order to remedy and mitigate audit findings that have been building over the past several years, PHA has moved to a task-based model, and have begun using production trackers for transparency. After a program management staffing change in March 2024, PHA is now pulling SEMAP reports monthly and conducting internal file audits to monitor program compliance. Name(s) of the contact person(s) responsible for corrective action: Deborah Madsen, Executive Director

View Audit 322309

Finding 499467 (2023-003)

Material Weakness 2023

City of Terre Haute

IN

Internal Control / Segregation of Duties Allowable Costs / Cost Principles Material Weakness § 200.303

FINDING 2023-003 Finding Subject: Coronavirus State and Local Fiscal Recovery Funds - Reporting Summary of Finding: Material Weakness, Modified Opinion Contact Person Responsible for Corrective Action: Jessica Thome, Controller Contact Phone Number and Email Address: (812) 244-2360 and Jessica.thome...

FINDING 2023-003 Finding Subject: Coronavirus State and Local Fiscal Recovery Funds - Reporting Summary of Finding: Material Weakness, Modified Opinion Contact Person Responsible for Corrective Action: Jessica Thome, Controller Contact Phone Number and Email Address: (812) 244-2360 and Jessica.thome@terrehaute.in.gov Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: We have utilized an outside consulting service to assist in the reconciliation of expenditures. Quarterly P&E Reports will be completed by the Controller and reviewed and approved by the Mayor. Anticipated Completion Date: Qtr3 P&E report required by end of Oct 2024

View Audit 322305

Finding 499466 (2023-002)

Material Weakness 2023

City of Terre Haute

IN

Questioned Costs Allowable Costs / Cost Principles Procurement, Suspension & Debarment § 200.303 § 200.308 § 200.403

FINDING 2023-002 Finding Subject: Coronavirus State and Local Fiscal Recovery Funds – Period of Performance Summary of Finding: Material Weakness, Modified Opinion Contact Person Responsible for Corrective Action: Jessica Thome, Controller Contact Phone Number and Email Address: (812) 244-2360 and J...

FINDING 2023-002 Finding Subject: Coronavirus State and Local Fiscal Recovery Funds – Period of Performance Summary of Finding: Material Weakness, Modified Opinion Contact Person Responsible for Corrective Action: Jessica Thome, Controller Contact Phone Number and Email Address: (812) 244-2360 and Jessica.thome@terrehaute.in.gov Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: Controller will review any previously entered contracts that are paid from our federal grants including ARP to ensure we are in compliance. Anticipated Completion Date: October 2024

View Audit 322305 Questioned Costs: $1

Finding 499408 (2023-002)

Material Weakness 2023

Western Wayne Family Health Centers

MI

Special Tests & Provisions Subrecipient Monitoring Eligibility

Recommendation – We recommend the Center provide proper training to employees to ensure that the sliding fee discounts are being properly applied and documented. In addition to implementing policies and procedures to ensure the sliding fee discounts are being properly monitored and supervised on a ...

Recommendation – We recommend the Center provide proper training to employees to ensure that the sliding fee discounts are being properly applied and documented. In addition to implementing policies and procedures to ensure the sliding fee discounts are being properly monitored and supervised on a periodic basis to ensure compliance. Action Taken – We concur with the audit finding. While the Center has a policy that meets the compliance requirements, management is responsible for the implementation and monitoring of those processes and procedures. Additional staff training on slide fee discounts is in place and monthly review and testing of compliance with Center sliding fee discount policy is ongoing.

View Audit 322256

Finding 499381 (2023-003)

Material Weakness 2023

Clinton County

IN

Internal Control / Segregation of Duties Allowable Costs / Cost Principles Material Weakness § 200.1 § 200.303

FINDING 2023-003 Finding Subject: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds - Reporting Summary of Finding: 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 we...

FINDING 2023-003 Finding Subject: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds - Reporting Summary of Finding: 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 on the type of recipient and the recipient’s 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 County was classified as a metropolitan county with a population below 250,000 residents that received an allocation of less than $10 million in State and Local Fiscal Recovery Funds. As such, the initial P&E report, covering the period from March 3, 2021 to March 31, 2022, was required to be submitted to the Treasury by April 30, 2022. The subsequent annual reports are to cover one calendar year and must be submitted to the Treasury by April 30 each year. The County submitted one P&E report during the audit period, which was obtained from the Treasury's website. Although one employee prepared the P&E report and another reviewed the entries, the system of internal controls was not effective in preventing, detecting, or correcting errors. The data submitted included amounts which should not have been included and amounts which were not supported by the County’s records. Errors identified included the following: • Total Cumulative Obligations were overstated by $907,630. • Total Cumulative Expenditures were overstated by $4,332,524. The lack of effective internal controls and noncompliance were isolated to the P&E Report submitted during the audit period. Contact Person Responsible for Corrective Action: Britt Ostler Contact Phone Number and Email Address: (765) 659-6330 Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: INDIANA STATE BOARD OF ACCOUNTS 29 The County received guidance from a consultant in regards to reporting the SLFRF. The consultant had advised “if the County planned to spend $5M, then the total cumulative “obligations” would be $5M. Per review of the SBOA, two figures in the 2023 P&E Report were miscalculated: Cumulative Obligations and Cumulative Expenditures. The Cumulative Obligations reported should be the amount contracted for the project plus any change orders. The Cumulative Expenditures should be the amount expended in prior years, if any, plus the amount expended until March 31st of the year the P&E Report is dated. The current period for the 2023 P&E Report covered April 1, 2022 to March 31, 2023. Future P&E Reports submitted for this grant will use this understanding of Cumulative Obligations and Cumulative Expenditures and will be prepared by the County Auditor and reviewed by a second individual prior to submission. Anticipated Completion Date: April 1, 2025

View Audit 322241

Finding 499359 (2023-004)

Material Weakness 2023

White County

IN

Internal Control / Segregation of Duties Allowable Costs / Cost Principles Material Weakness § 200.303

FINDING 2023-004 Finding Subject: COVID 19 Coronavirus State and Local Fiscal Recover Funds – Reporting Federal Agency: Department of the Treasury Summary of Finding: Material Weakness – The P&E report submitted in April 2023 was prepared and submitted by one employee without evidence of an oversigh...

FINDING 2023-004 Finding Subject: COVID 19 Coronavirus State and Local Fiscal Recover Funds – Reporting Federal Agency: Department of the Treasury Summary of Finding: Material Weakness – The P&E report submitted in April 2023 was prepared and submitted by one employee without evidence of an oversight or review process to ensure accuracy. Contact Person Responsible for Corrective Action: Elizabeth J Billue Contact Phone Number and Email Address: 574-583-1515 libby.billue@whitecounty.in.gov Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: All annual reporting will be reviewed as previously planned, prior to submission. However, a coversheet has also been created and will be completed for all future annual reporting has been created for use. The form includes documentation of the preparer, reviewer, and date of submission. This information will be kept in files within the Auditor’s office. Anticipated Completion Date: This plan will be implemented by April of 2025.

View Audit 322213

Finding 499340 (2023-003)

Material Weakness 2023

Bartholomew County

IN

Allowable Costs / Cost Principles Material Weakness Period of Performance § 200.1 § 200.303

FINDING 2023-003 Finding Subject: COVID-19 Coronavirus State and Local Fiscal Recovery Funds – Reporting Summary of Finding: The County did not have effective internal controls in place to ensure that P&E reports submitted were accurate. This allowed errors on P&E reports to remain undetected and un...

FINDING 2023-003 Finding Subject: COVID-19 Coronavirus State and Local Fiscal Recovery Funds – Reporting Summary of Finding: The County did not have effective internal controls in place to ensure that P&E reports submitted were accurate. This allowed errors on P&E reports to remain undetected and uncorrected. It was recommended that policies and procedures be put in place to ensure that all reports were complete and accurate. Contact Person Responsible for Corrective Action: Pia O’Connor Contact Phone Number and Email Address: 812-379-1510 and pia.oconnor@bartholomew.in.gov Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: The County implemented an additional procedure to ensure we have complete and accurate information for the P & E report. Beginning with the 3rd Quarter P&E report, the County had added a person to assist with these reports by creating the reports through our financial software and reviewing the figures and information before giving the reports to the Auditor. The County Auditor prepared the P & E reports and then the Commissioner’s reviewed before the Auditor submitted the report to the Treasury. Due to the financial software (Software Solutions), there were reporting issues between quarters. The Bartholomew County Auditor’s Office continuously strives to improve upon our process and during 2024, changed financial software to LOW Financial to help with reporting and will implement an additional check and balance prior to the Treasury. Anticipated Completion Date: December 31, 2024

View Audit 322177

Finding 499310 (2023-003)

Material Weakness 2023

Town of Randolph, Ma

MA

Internal Control / Segregation of Duties Material Weakness Period of Performance

Root Cause Analysis: 1. Report was incorrectly run in the accounting system. Report options were set to fiscal year view when it needed to be set to life-to-date view to see all expenditures of the grant. 2 I did not see on the DESE federal grant reporting instructions document anything stating the ...

Root Cause Analysis: 1. Report was incorrectly run in the accounting system. Report options were set to fiscal year view when it needed to be set to life-to-date view to see all expenditures of the grant. 2 I did not see on the DESE federal grant reporting instructions document anything stating the person completing the report and the authorized signature could not be the same person. In the Federal grant training I attended, it was not stated. I was added to the Commonwealth of MA Contract Authorized Signatory Listing (CASL) as a third authorized signature by the superintendent for this LEA. 3. Corrective Action(s): 1. A request for an amendment to the appropriate DESE staff member will be sent. 2. The Report will be completed by the Finance Department Accounting Clerk and I will be the authorized signature. If at any point I am the one completing the report I will have the Assistant Superintendent or the Superintendent serve as the authorized signature. 3. Action Item: o Description: A request for an amendment to the appropriate DESE staff member will be sent in June 2024. Once a response is received the report will be completed and filed. I expect it should be done by August 2024. o Responsible Person/Department: Director Finance for the Randolph Public Schools. o Expected Completion Date: August 30, 2024 o Description:The Report will be completed by the Finance Department Accounting Clerk and I will be the authorized signature. If at any point I am the one completing the report I will have the Assistant Superintendent or the Superintendent serve as the authorized signature. o Responsible Person/Department: Finance Department Accounting Clerk for the Randolph Public Schools and Director Finance for the Randolph Public Schools. o Expected Completion Date: Moving forward with all Final Financial Reports

View Audit 322147

Finding 499306 (2023-003)

Material Weakness 2023

Allen County

IN

Internal Control / Segregation of Duties Allowable Costs / Cost Principles Material Weakness § 200.303

FINDING 2023-003 Finding Subject: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds – Reporting Summary of Finding: The County submitted the four required quarterly P&E reports and the annual Recovery Plan Performance Report during the audit period; however, a single employee prepared and...

FINDING 2023-003 Finding Subject: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds – Reporting Summary of Finding: The County submitted the four required quarterly P&E reports and the annual Recovery Plan Performance Report during the audit period; however, a single employee prepared and submitted each report without a review or oversight process in place to prevent, or detect and correct, errors. Contact Person Responsible for Corrective Action: Chris Cloud, Chief of Staff Contact Phone Number and Email Address: 260-449-4752 / chris.cloud@allencounty.us Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: To correct Finding 2023-003, the Chief of Staff to the Board of Commissioners will have the Controller to the Board of Commissioners review the P&E Reports and the Recovery Plan Performance Report prior to being electronically submitted to the Department of Treasury via its State and Local Fiscal Recovery Funds portal. If errors are discovered by the Controller, the Chief of Staff will correct the electronic entry prior to submission. Anticipated Completion Date: This CAP will be completed by October 31, 2024, the deadline for submitting the third quarter 2024 P&E Report.

View Audit 322145

Corrective Action Plans

Filters