Corrective Action Plans

Finding 30017 (2022-002)

Material Weakness 2022

Boone County

IN

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

Finding 2022-002 Contact Person Responsible for Corrective Action: Debbie Morton-Crum, County Auditor Contact Phone Number: 765-482-2940 View of Responsible Official: We concur with the finding. Description of Corrective Action Plan: We are working putting Internal Controls in place specific to gran...

Finding 2022-002 Contact Person Responsible for Corrective Action: Debbie Morton-Crum, County Auditor Contact Phone Number: 765-482-2940 View of Responsible Official: We concur with the finding. Description of Corrective Action Plan: We are working putting Internal Controls in place specific to grants like the Covid-19 Coronavirus State and Local Fiscal Recovery Funds grant. We will put a checklist together, including review and approval of disbursement by the governing body, that has to be met before the claim or the project can be processed. Anticipated Completion Date: October 1, 2023

View Audit 31370

Finding 29984 (2022-003)

Material Weakness 2022

Clarkson University

NY

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

Management accepts the finding and notes that the prior year finding was not reported until near the end of the current audit period, contributing to the repeat finding. Effective in June 2022, payroll authorizations were directed through the PeopleSoft system to the Payroll Manager who prepared and...

Management accepts the finding and notes that the prior year finding was not reported until near the end of the current audit period, contributing to the repeat finding. Effective in June 2022, payroll authorizations were directed through the PeopleSoft system to the Payroll Manager who prepared and documented the necessary allocation calculation. This calculation, along with a copy of the original payroll authorization for the employee and the superseding payroll authorization were sent to the Associate Controller for review and verification. This secondary review was marked approved and returned to the Payroll Manager for final entry in the payroll system and records archiving. Further, a campus committee with representatives from the offices of; Controller, Information Technology, Sponsored Research Services, Payroll and Academic Affairs Operations was formed to further review and address this prior year finding. The Committee has developed a form within PeopleSoft that will allow for entering payroll authorization data, system calculation of applicable fringe adjustments, and a system driven workflow review and approval process from initial entry by the Principal Investigator to approval by Sponsored Research Services to the approval by either the Research Accountant or the Associate Controller for posting of all prior period reallocations. Any adjustments affecting future periods will be processed through the existing payroll authorization process and system entered by the Payroll Office. System testing of this reallocation process is currently taking place with implementation scheduled for April 1, 2023. A further enhancement of automating the related journal entry posting upon final approval by the Research Accountant or Associate Controller is expected to be implemented by May 1, 2023. InAnticipated Completion Date June 30, 2023 Responsible Person Keith Rosser, Controller William McGarry, Chief Financial Officer light of the repeat finding, the University will further engage an outside firm to conduct an internal audit of the Payroll Department with a focus on reviewing current processes from employee set up through issuance of compensation and filing of state and federal forms. This expected outcome of this review will be to identify areas of potential weakness, process improvement, and current utilization of existing financial systems and tools.

View Audit 30456

Finding 29831 (2022-003)

Significant Deficiency 2022

Adelanto Elementary School District

CA

Questioned Costs Allowable Costs / Cost Principles HUD Housing Programs § 200.303 § 200.430

Finding 2022-003: Inadequate Support for Salaries and Wages-Time Certifications not maintained (5000) Federal Agency: U.S. Department of Education Pass through Entity: California Department of Education Program Names: Elementary and Secondary School Emergency Relief I, II, III (ESSER, ESSER II...

Finding 2022-003: Inadequate Support for Salaries and Wages-Time Certifications not maintained (5000) Federal Agency: U.S. Department of Education Pass through Entity: California Department of Education Program Names: Elementary and Secondary School Emergency Relief I, II, III (ESSER, ESSER II, ESSER III) (Assistance Listing 84.425, C, D, U), Title I (Assistance Listing 84.010) Criteria: 2 CFR 200.430 requires that an LEA must maintain time and effort distribution records that support the distribution of the employee?s salary or wages among specific activities or cost objectives. 2 CFR, section 225, appendix B, Section 8(h) states in part: Support of salaries and wages- These standards regarding time distribution are in addition to the standards for payroll documentation. (1) Charges to Federal awards for salaries and wages, whether treated as direct or indirect costs, will be based on payrolls documented in accordance with the generally accepted practice of the governmental unit and approved by a responsible official(s) of the governmental unit. (2) No further documentation is required for salaries and wages of employees who work in a single indirect cost activity. (3) Where employees are expected to work solely on a single Federal award or cost objective, charges for their salaries and wages will be supported by periodic certifications that the employee worked solely on that program for the period covered by the certification. These certifications will be prepared at least semi-annually and will be signed by the employee or supervisory official having first-hand knowledge of the work performed by the employee. CSAM Procedure 905 states, in part: Periodic (Semiannual) Certification Employees who work solely on a single federal award or cost objective need only complete a periodic certification. The periodic certification must: Be prepared at least semi-annually. Be signed by the employee or the supervisory official having firsthand knowledge of the work performed by the employee. State the employee worked solely on that single federal program or cost objective during the period covered by the certification. Where multiple employees work on the same cost objective, a blanket certification may be used as the documentation for all employees who worked on the cost objective?. Personnel Activity Report Except as provided in ?Substitute Systems for Time Accounting,? employees who work on multiple activities or cost objectives of which at least one is federal must complete a personnel activity report (PAR) or equivalent documentation. A PAR may be as detailed as a document that identifies the employee?s activity daily by hours, or it may be as simple as a report of the total hours or percentage of hours spent in each categorical program or cost objective. The level of detail can generally be determined by the diversity and variation of the employee?s work activities. The safest approach is to provide more documentation rather than less. Finding: The District provided approved time sheets for only 3 employees out of 20 selected that were paid from ESSER funding. The District provided 9 of 10-time accounting records that included PARS for Title I. Cause: The District does not have adequate controls in place to ensure that time certification documentation is prepared and maintained to support all employees who are paid with federal funds. Effect: The District did not provide time certification records for 17 of the 20 employees selected for review, who were paid with Education Stabilization Funds. As a result, the amount of $736,116.27 is in question. The District did not provide time certification records for 1 of 8 employees selected for review, who was paid with Title I funds, as a result, the amount of $ 91,794, is in question. Recommendation: We recommend the District comply with Title 2, CFR 200.303, and CSAM Procedure 905 which require that employee time certification forms be maintained for employees who charge time to federal programs. Action: Management will ensure that the District does have adequate controls in place and comply with Federal rules and guidelines. Completion Date: Effective immediately. Contact: Zach Klemish, Director of Fiscal Services, Adelanto Elementary School District, (760) 246-8691

View Audit 32260 Questioned Costs: $1

Finding 29826 (2022-002)

Material Weakness 2022

Hibiscus Childrens Center, Inc.

FL

Questioned Costs Allowable Costs / Cost Principles § 200.303 § 200.403

Management Response: Hibiscus is using eCR data verifying time value related services based on VOCA allowable cost. In addition, updates were made on time sheet for providers detailing actual percentage of services. Cost reimbursements submitted were reviewed, verified, and approved by VOCA.

View Audit 35599 Questioned Costs: $1

Finding 29509 (2022-003)

Significant Deficiency 2022

Prentiss County School District

MS

Questioned Costs Internal Control / Segregation of Duties Allowable Costs / Cost Principles § 200.302 § 200.303

Finding 2022-03: Allowed and unallowed costs. District Response: A. Federal budgets will be reviewed on a monthly basis and revised as needed. B. Kim Hamm: Federal Programs Director and Julie Clark: Special Services Director C. July 1, 2023

View Audit 25360 Questioned Costs: $1

Finding 29500 (2022-008)

Material Weakness 2022

Monroe County Board of Education

AL

Questioned Costs Allowable Costs / Cost Principles Subrecipient Monitoring § 200.303

All compensation and supplement rates are included in the Board approved salary schedule. The list of personnel receiving supplements must be Board approved. This applies to all programs regardless of the funding source. The Board action is shared with the payroll department after each board meet...

All compensation and supplement rates are included in the Board approved salary schedule. The list of personnel receiving supplements must be Board approved. This applies to all programs regardless of the funding source. The Board action is shared with the payroll department after each board meeting to ensure compensation is correct. The payroll department has been trained/advised that no compensation for supplements can be made without Board approval and a signed/approved time sheet documenting that the required work/duties has been performed. The Monroe County Board of Education is not currently participating in or receiving funds from the Twenty-First Century Community Learning Centers Program. The Alabama State Department investigation into the actions discovered in this program is ongoing. The Board will comply with any future findings and recommendations at the conclusion of this investigation.

View Audit 25358 Questioned Costs: $1

Finding 29362 (2022-004)

Material Weakness 2022

Hot Springs County School District #1

WY

Allowable Costs / Cost Principles § 200.303

SECTION III - FEDERAL AWARDS FINDINGS 2022-004 - Expenditure Controls - Material Weakness The business office was recently restructured and changes will take effect starting January 1, 2022. With the changes taking effect, the business office has spread out the duties and responsibilities for managi...

SECTION III - FEDERAL AWARDS FINDINGS 2022-004 - Expenditure Controls - Material Weakness The business office was recently restructured and changes will take effect starting January 1, 2022. With the changes taking effect, the business office has spread out the duties and responsibilities for managing transactions controls. Specifically, purchases will be required to go through the requisition process and be approved prior to purchases being made. This process has already been initiated but will be further emphasized in the coming year. Kathy Groh - federal grant financial manager, Chauncy Johnson - Outgoing business manager, and Jessica Benefiel - incoming business manager will oversee these changes and ensure compliance in purchasing procedures.

View Audit 24793

Finding 29198 (2022-005)

Material Weakness 2022

Carroll Consolidated School Corporation

IN

Cash Management Internal Control / Segregation of Duties Subrecipient Monitoring § 200.303

FINDING 2022-005 Information on the federal program: Subject: COVID-19 ? Education Stabilization Fund ? Cash Management, Other Matters Federal Agency: Department of Education Federal Program: Elementary and Secondary School Emergency Relief (ESSER II) Fund Assistance Listing Number: 84.425D Pass-Thr...

FINDING 2022-005 Information on the federal program: Subject: COVID-19 ? Education Stabilization Fund ? Cash Management, Other Matters Federal Agency: Department of Education Federal Program: Elementary and Secondary School Emergency Relief (ESSER II) Fund Assistance Listing Number: 84.425D Pass-Through Entity: Indiana Department of Education Compliance Requirement: Cash Management Audit Finding: Material Weakness, Noncompliance, Other Matters Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the cash management compliance requirements for the COVID-19 ? Education Stabilization Fund. Context: During our audit procedures, we noted that in fiscal year 2021, the School Corporation had drawn down $108,445 more in ESSER II funds than what they had expended. The School Corporation received $297,500 of ESSER II funds during fiscal year 2021, but had only disbursed $189,055. The School Corporation spent $107,361 of the remaining funds during fiscal year 2022 and had an ending balance of $1,084 as of June 30, 2022. The ESSER II grant is a cost reimbursement grant and therefore, the School Corporation should not have drawn down these funds prior to the expenses being incurred. Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The Superintendent and/or the Superintendent?s designees will not request funds from reimbursable grants before expenditures have been made by the corporation. Responsible Party and Timeline for Completion: The responsible parties are the Superintendent and/or the Superintendent?s designees. The corrective action will take place immediately (3/15/2023).

View Audit 25373

Finding 29197 (2022-004)

Material Weakness 2022

Carroll Consolidated School Corporation

IN

School Nutrition Programs Cash Management Material Weakness § 200.303

FINDING 2022-004 Information on the federal program: Subject: Child Nutrition Cluster ? Internal Controls Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program Assistance Listing Number: 10.553, 10.555 Pass-Through Entity: Indiana Departme...

FINDING 2022-004 Information on the federal program: Subject: Child Nutrition Cluster ? Internal Controls Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program Assistance Listing Number: 10.553, 10.555 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the reporting compliance requirement. Context: We noted that for two claims in a sample of four, there was no formal evidence of the sponsor claim reimbursement summary being reviewed by someone independent of who prepared the sponsor claim reimbursement summary prior to submission. We noted that for one claim in a sample of four, the meal counts were over/under claimed for the month. We noted that in October 2020 the School Corporation had overclaimed lunches by 175 meals and underclaimed breakfast by 156 meals. Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The Superintendent is now utilizing the personalized login on CNP Web to review claims before final submission. The superintendent will also email approval of claims to the FSMC Food Service Director upon submission and approval by the superintendent on CNP Web. Responsible Party and Timeline for Completion: The Superintendent and FSMC Food Service Director will be the responsible parties and the corrective action will take place immediately (3/15/2023).

View Audit 25373

Finding 29196 (2022-003)

Material Weakness 2022

Carroll Consolidated School Corporation

IN

Procurement, Suspension & Debarment School Nutrition Programs § 200.303

FINDING 2022-003 Information on the federal program: Subject: Child Nutrition Cluster ? Internal Controls Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program Assistance Listing Number: 10.553, 10.555 Pass-Through Entity: Indiana Departme...

FINDING 2022-003 Information on the federal program: Subject: Child Nutrition Cluster ? Internal Controls Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program Assistance Listing Number: 10.553, 10.555 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Procurement and Suspension and Debarment Audit Finding: Material Weakness Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the Child Nutrition Program and Procurement and Suspension and Debarment compliance requirements for purchases made outside of the purchasing cooperative. Context: During the audit period, the School Corporation had purchases between $10,000 and $150,000 from four vendors which fall under the small purchase method for federal and state procurement regulations and were charged to Fund 0800 ? School Lunch Fund. For one vendor selected for testing, documentation was not presented to verify the School Corporation had performed checks to assure the vendor was not suspended or debarred prior to entering into the transaction in order to satisfy the suspended and debarment requirements. Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Moving forward, the SAMS website will be utilized to confirm that purchases from vendors that are between the $10,000 and $150,000 threshold are not suspended or debarred prior to entering into transactions. Responsible Party and Timeline for Completion: The Superintendent or Superintendent?s designee will be the responsible party. This correction will be put into effect 3/15/2023.

View Audit 25373

Finding 29195 (2022-002)

Material Weakness 2022

Carroll Consolidated School Corporation

IN

School Nutrition Programs Allowable Costs / Cost Principles Internal Control / Segregation of Duties § 200.303

FINDING 2022-002 Information on the federal program: Subject: Child Nutrition Cluster - Internal Controls Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program Assistance Listing Number: 10.553, 10.555 Pass-Through Entity: Indiana Departme...

FINDING 2022-002 Information on the federal program: Subject: Child Nutrition Cluster - Internal Controls Federal Agency: Department of Agriculture Federal Program: School Breakfast Program, National School Lunch Program Assistance Listing Number: 10.553, 10.555 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Finding: Material Weakness Condition: An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Allowable Costs/Cost Principles compliance requirements. Context: During testing of 12 vendor disbursements for allowable costs/cost principles, we noted there was one month where there was no documented review by the School Corporation?s Business Manager of expenditures paid to the Food Service Management Company by the School Corporation?s Business Manager. The only review was performed by the Food Services Director, who is a Food Service Management company employee. We tested six other monthly submissions of Food Service Management company disbursements and noted they were all appropriately reviewed by the School Corporation with supporting documentation attached. Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The missing signature appears to be an uncommon oversight within our current system of internal controls. The Superintendent and FSMC Food Service Director will make it a point to review signature pages for both signatures at each monthly financial review. Responsible Party and Timeline for Completion: Superintendent and FSMC Food Service Director discussed this finding on 3/15/2023 and will put corrective action in place immediately.

View Audit 25373

Finding 29185 (2022-001)

Significant Deficiency 2022

Bluffton-Harrison Metropolitan School District

IN

Matching / Level of Effort / Earmarking Allowable Costs / Cost Principles § 200.208 § 200.303 § 200.403

FINDING 2022-001 Information on the federal program: Subject: Special Education Cluster (IDEA) - Earmarking Federal Agency: Department of Education Federal Program: Special Education Grants to States Assistance Listing Number: 84.027 Federal Award Number: 20611-001-PN01 Pass-Through Entity: ...

FINDING 2022-001 Information on the federal program: Subject: Special Education Cluster (IDEA) - Earmarking Federal Agency: Department of Education Federal Program: Special Education Grants to States Assistance Listing Number: 84.027 Federal Award Number: 20611-001-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Findings: Significant Deficiency Condition: The School Corporation is a member of the Adams Wells Special Services Cooperative (Cooperative). During fiscal year 2021-2022, the Cooperative operated the special education programs and spent the federal money on behalf of all its member schools. As the grant agreements were between the Indiana Department of Education (IDOE) and each member school, the school corporation was responsible for ensuring and providing oversight of the Cooperative. There was inadequate oversight performed by the School Corporation in order to ensure compliance with the Matching, Level of Effort, Earmarking compliance requirement. The School Corporation did not have internal controls in place to ensure that the Cooperative complied with the earmarking requirements. The Cooperative did not have adequate procedures in place to ensure that the required level of expenditures for non-public school students with disabilities was met for each member school. The Cooperative did not have effective internal controls to ensure non-public school expenditures were appropriately identified and reported. Context: The Non-Public Proportionate Share expenditures for the 20611-001-PN01 grant award could not be verified for the individual member schools. Total non-public expenditures were posted as expended. The member school proportionate share expenditures were then determined by applying a budgeted percentage to the total non-public expenditures. These were the amounts reported to IDOE. As such, we were unable to identify if the minimum amount per member school was expended and properly reported to IDOE as required. The School Corporation?s Non-Public Proportionate Share for the 20611-001-PN01 grant application was $10,523. Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: Co-ops cannot combine proportionate share funds. Funds must be spent within each LEA?s geographic boundary. We will not receive a repeat finding for FY21. We will correct for FY22 and forward. Time & Effort Logs are being completed to show how many hours personnel are servicing Non-Pub school students with a service plan. If materials and Equipment are purchased for a specific student?s need, per the service plan, then those expenditures are 100% school specific. Per the DOE, Materials used by our Speech Language Pathologist for Speech Therapy for all six school corporations, those expenditures are split evenly across all school corporations with a non-pub proportionate share allocation. Responsible Party and Timeline for Completion: Adams-Wells Special Services Cooperative is the responsible party for the timeline completion. No later than January 2023, the Cooperative will have corrected proportionate share monitoring workbooks for FY22 and the ARP grants.

View Audit 25372

Finding 29182 (2022-002)

Significant Deficiency 2022

Linn County

IA

Reporting Significant Deficiency Internal Control / Segregation of Duties § 200.303

Finding 2022-002 Reporting Federal Agency Name: Department of the Treasury Program Name: Emergency Rental Assistance Program and Coronavirus State and Local Fiscal Recovery Funds CFDA #: 21.023 and 21.027 Finding Summary: The County?s reports submitted to the Department of Treasury were not revie...

Finding 2022-002 Reporting Federal Agency Name: Department of the Treasury Program Name: Emergency Rental Assistance Program and Coronavirus State and Local Fiscal Recovery Funds CFDA #: 21.023 and 21.027 Finding Summary: The County?s reports submitted to the Department of Treasury were not reviewed and approved by a separate individual outside of the preparer. Responsible Individual: Dawn Jindrich, Finance Director Corrective Action Plan: Moving forward, the Senior Accountant will prepare the reports and the Finance Director will approve the final page of each report with a signature and date prior to submission by the Senior Account. Anticipated Completion Date: June 30, 2023

View Audit 25101

Finding 29173 (2022-001)

Material Weakness 2022

Triton School Corporation

IN

School Nutrition Programs Internal Control / Segregation of Duties Cash Management § 200.303

CORRECTIVE ACTION PLAN OF CURRENT AUDIT FINDINGS June 30, 2022 Finding 2022-001 ? Child Nutrition Cluster ? Reporting Contact Person Responsible for Corrective Action: Thomas McFarland Contact Phone Number: 574-342-2255 Views of Responsible Official: We do not concur with the finding. Des...

CORRECTIVE ACTION PLAN OF CURRENT AUDIT FINDINGS June 30, 2022 Finding 2022-001 ? Child Nutrition Cluster ? Reporting Contact Person Responsible for Corrective Action: Thomas McFarland Contact Phone Number: 574-342-2255 Views of Responsible Official: We do not concur with the finding. Description of Corrective Action Plan: While the claim does not have a second signature indicating review before submission, the procedures that Triton follows, which include segregation of duties, justify that someone else reviewed the data, before submission. The data is compiled by the building secretary and submitted to the Business Manager. The Business Manager reviews the claim and logs into the online submission website with a secure user name and password to enter the data. While we believe that the secure user name and password is just as much proof as a signature that the data has been reviewed, we will begin having the document signed by a second person in order to satisfy this requirement Anticipated Completion Date: 3/15/23

View Audit 29737

Finding 29132 (2022-003)

Material Weakness 2022

Bloomfield School District

IN

School Nutrition Programs Internal Control / Segregation of Duties Cash Management § 200.303

Contact Person Responsible for Corrective Action: Michelle Keene Contact Phone Number: (812) 384-4386 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The School Corporation will implement a formal review of the Education Stabilization Annual Repor...

Contact Person Responsible for Corrective Action: Michelle Keene Contact Phone Number: (812) 384-4386 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The School Corporation will implement a formal review of the Education Stabilization Annual Report and ensure the amounts reported agree to the underlying records. Anticipated Completion Date: Effective for the next Annual Report due

View Audit 29735

Finding 29100 (2022-002)

Material Weakness 2022

Eventide

MN

Allowable Costs / Cost Principles § 200.303

Finding 2022-002 Federal Agency Name: Department of Health and Human Services Program Name: COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution CFDA #93.498 Finding Summary: There was no formal documentation of review and approval for the final expenditure listing...

Finding 2022-002 Federal Agency Name: Department of Health and Human Services Program Name: COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution CFDA #93.498 Finding Summary: There was no formal documentation of review and approval for the final expenditure listing. There was also no formal review over tracking of other sources of funding to ensure that expenses claimed for the program were not claimed by other funding sources. The Organization's calculation of lost revenue claimed under the federal program as an allowable cost contained no formal review or approval by a separate individual outside of the preparer. Responsible Individuals: Darin Ohe, CFO Corrective Action Plan: All tracking documents that have calculations will be reviewed by the Vice President of Finance if the CFO compiles for accuracy and vice versa. The reviewer will sign off by email that they have reviewed and agree with the calculations. Use of funds reports that are prepared for submission to HRSA will be reviewed by the CEO. That review will be formalized by an acknowledgement email. These processes were implemented with our Report 3. Anticipated Completion Date: 7/1/22

View Audit 24566

Finding 29099 (2022-002)

Material Weakness 2022

Jackson Municipal Airport Authority

MS

Subrecipient Monitoring Material Weakness Matching / Level of Effort / Earmarking § 200.303 § 200.326

2022-002 Material Weakness - Davis-Bacon Act Planned Corrective Action Proper documentation not maintained by the Authority to verify compliance with Davis Bacon, due to the lack of monitoring of contractor compliance and adequate records retention by project management. A new system of checks and b...

2022-002 Material Weakness - Davis-Bacon Act Planned Corrective Action Proper documentation not maintained by the Authority to verify compliance with Davis Bacon, due to the lack of monitoring of contractor compliance and adequate records retention by project management. A new system of checks and balance was created between Finance, Capital Project, and Procurement Departments to reconcile, evaluate, and manage construction projects on a monthly basis to ensure proper documentation and tracking. Management will add an additional requirement to include this as part of the accounts payable process. Anticipated Completion Date Complete by September 30, 2022 Responsible Contact Person Rico Owens, Senior Accountant

View Audit 24564

Finding 29059 (2022-002)

Significant Deficiency 2022

Catholic Charities Archdiocese of Washington, INC and Affiliates

DC

Internal Control / Segregation of Duties Special Tests & Provisions HUD Housing Programs § 200.303

2022-002 Internal Control over Compliance and Compliance ? Special Tests and Provisions Contact: Reginald Gregory Title: Executive Director/Controller Phone Number: 202-772-4300 Estimated completion date: June 30, 2023 Corrective Action: Program management will ensure that Case Management te...

2022-002 Internal Control over Compliance and Compliance ? Special Tests and Provisions Contact: Reginald Gregory Title: Executive Director/Controller Phone Number: 202-772-4300 Estimated completion date: June 30, 2023 Corrective Action: Program management will ensure that Case Management team and staff who are responsible for selecting housing units for the Fortitude MD program receive training on how to determine if the proposed rent meets the fair market rent (FMR). For leases that include utilities within the base rent, Case Management will make sure that there is a breakdown of the total proposed rent that shows the Base Rent Rate, Utility Portion, and Other miscellaneous expenses is appropriately documented. At time of sign off on the Lease Up packet, the Fortitude MD Sr. Program Manager will review the lease and confirm that the proposed rent does not exceed the FMR. The completed Lease-up Packet will be submitted to HHS management for final review, approval and submission to Finance for processing Monthly, the Sr. Program Manager will review the rent roster that will include a column for the current FMR and confirm that the rent being paid does not exceed the FMR.

View Audit 29991

Finding 29033 (2022-005)

Material Weakness 2022

Southwestern Jefferson County Consolidated School Corporation

IN

Matching / Level of Effort / Earmarking Special Tests & Provisions § 200.303

FINDING 2022-005 Contact Person Responsible for Corrective Action: Jason R. Watson, Assistant Superintendent Contact Phone Number: O?ce: 812-866-6244 Cell: 812-599-0627 Contact Email: jwatson@swjcs.us Views of Responsible O?cial: We concur with this audit finding. Description of Corrective Action P...

FINDING 2022-005 Contact Person Responsible for Corrective Action: Jason R. Watson, Assistant Superintendent Contact Phone Number: O?ce: 812-866-6244 Cell: 812-599-0627 Contact Email: jwatson@swjcs.us Views of Responsible O?cial: We concur with this audit finding. Description of Corrective Action Plan: Action taken in an e?ort to remedy finding 2022-005 includes, but is not limited to, the following: ? Beginning January 1, 2023, an e?ective internal control system will be implemented related to the grant agreement and the Special Tests and Provisions - Wage Rate Requirement compliance requirement ? Any contract entered into which is in excess of $2,000.00 and is for actual construction, alteration, and/or repair, including painting and decorating; and is financed in whole or part by Federal funds will require the following: > A signed contract. > Certification that the vendor is in compliance with the Department of Labor?s (DOL) Wage Rate Requirements and related regulations. > Certification that the vendor is in compliance with the Davis-Bacon Act > Weekly submission of the vendor?s payroll and statement of compliance for each week in which contract work was performed submitted to the Treasurer. ? Southwestern Je?erson County Consolidated School Corporation (SWJCS) will implement the following process as an e?ective internal control system > The Treasurer will create a DocuSign Envelope containing the weekly submission of the vendor?s payroll, and supporting documentation to be shared and reviewed for compliance. His/ her eSignature indicates the completion of the initial review. > The DocuSign Envelope will then be routed to the Deputy Treasurer for the secondary review. His/her eSignature indicates its completion. > The Superintendent monitors the internal controls by confirming that both the Treasurer and Deputy Treasurer have completed their review and indicates as such via eSignatures. > The Chief Financial O?cer receives a carbon copy of the completed DocuSign Envelope. Anticipated Completion Date: January 1, 2023

View Audit 29468

Finding 29032 (2022-004)

Material Weakness 2022

Southwestern Jefferson County Consolidated School Corporation

IN

Equipment & Real Property Management Internal Control / Segregation of Duties § 200.303 § 200.313

FINDING 2022-004 CORRECTIVE ACTION PLAN Contact Person Responsible for Corrective Action: Jason R. Watson, Assistant Superintendent Contact Phone Number: O?ce: 812-866-6244 Cell: 812-599-0627 Contact Email: jwatson@swjcs.us Views of Responsible O?cial: We concur with this audit finding. Description...

FINDING 2022-004 CORRECTIVE ACTION PLAN Contact Person Responsible for Corrective Action: Jason R. Watson, Assistant Superintendent Contact Phone Number: O?ce: 812-866-6244 Cell: 812-599-0627 Contact Email: jwatson@swjcs.us Views of Responsible O?cial: We concur with this audit finding. Description of Corrective Action Plan: Action taken in an e?ort to remedy finding 2022-004 includes, but is not limited to, the following: ? Beginning March 8, 2023, an e?ective internal control system will be implemented related to equipment and real property management compliance requirements. ? In November of 2021, Southwestern Je?erson County Consolidated Schools (SWJCS) contracted with Asset Control Solutions, Inc. (ACS), a professional fixed asset inventory and management services that creates and maintains an accurate and detailed record of our corporation?s property, and ensures that SWJCS is properly insured with an on-site and in-depth insurance valuation for our agent. ? ACS provides the corporation with a SharePoint site to access and manage all of the equipment and real property data. This site allows for the addition and deletion of inventory by selected corporation sta? to ensure its accuracy. ? The smart boards mentioned in this finding had not been received at the time of the November assessment by ACS and the corporation was advised not to include these items in the inventory until they had actually been received on site. ? These items have been added to the inventory, properly tagged, and are reflected in updated reports recently received. ? Beginning March 8, 2023, SWJCS will begin the use of Boyce School Financial (BSF) for our financial software. This cloud-based system provides import and export abilities that were not available in the DOS based system that was in use at the time of the audit period. ? As a result of the capabilities of the BSF System, we will begin March 8th with the most current data from ACS in BSF. ? Moving forward, the process for items meeting the capital assets threshold will include, but is not limited to, the following: > When item(s) meeting the capital assets threshold are received, the recipient will a?x the proper inventory sticker to the item(s) and complete the inventory change form either digitally or hard copy and submit to the Treasurer for processing.FINDING 2022-004: Corrective Action Plan Continued > The Treasurer will enter the data provided by the recipient into the BSF System and provide the inventory change form to the Assistant Superintendent. > The Assistant Superintendent will confirm that the item(s) have been accurately entered into BSF and enter the information in the ACS system through SharePoint. > The inventory change form will then be provided to the Deputy Treasurer. > The Deputy Treasurer will confirm that the item(s) have been accurately entered into BSF and SharePoint. > Every two years, tentatively scheduled for November of 2023, ACS will return and complete a thorough GASB 34 Compliant Capital Asset Inventory and provide the corporation with the resulting reports. > The Assistant Superintendent will complete a change form for any resulting corrections needed and update BSF with these changes. The change form be routed to the Treasurer. > The Treasurer will confirm that the item(s) have been accurately entered into BSF and send the form to the Deputy Treasurer. > This process will be documented using DocuSign by following a similar process as outlined in Finding 2022-001 and 2022-003. Anticipated Completion Date: March?31,?2023?

View Audit 29468

Finding 29028 (2022-003)

Material Weakness 2022

Southwestern Jefferson County Consolidated School Corporation

IN

Internal Control / Segregation of Duties Subrecipient Monitoring Material Weakness § 200.302 § 200.303 § 200.328 § 200.329

FINDING 2022-003 Contact Person Responsible for Corrective Action: Jason R. Watson, Assistant Superintendent Contact Phone Number: O?ce 812-866-6244 Cell: 812-599-0627 Contact Email: jwatson@swjcs.us Views of Responsible O?cial: We concur with this audit finding. Description of Corrective Action Pl...

FINDING 2022-003 Contact Person Responsible for Corrective Action: Jason R. Watson, Assistant Superintendent Contact Phone Number: O?ce 812-866-6244 Cell: 812-599-0627 Contact Email: jwatson@swjcs.us Views of Responsible O?cial: We concur with this audit finding. Description of Corrective Action Plan: Action taken in an e?ort to remedy finding 2022-003 includes, but is not limited to, the following: ? Beginning December 27, 2022, an e?ective internal control system was implemented related to grant agreement and the reporting compliance requirements. ? The Assistant Superintendent prepares and formats the data for required reporting. ? The prepared and formatted data, and supporting documentation is shared via a DocuSign Envelope to be reviewed for accuracy. ? The DocuSign Envelope is routed to the Treasurer for the initial review. His/her eSignature indicates its completion. ? It is then routed to the Deputy Treasurer for a second review. His/her eSignature indicates its completion. ? The DocuSign envelope is then routed back to the Assistant Superintendent for submission, barring any required corrections. ? In the event that corrections to the report are required, the Assistant Superintendent?s eSignature in the appropriate location indicates that corrections are needed prior to submission. ? A second DocuSign Envelope, with the needed corrections, is then generated and proceeds through the process again. ? When the report is o?cially submitted, the Assistant Superintendent indicates its completion by eSignature in the appropriate location. ? The Superintendent monitors the internal controls by confirming that both the Treasurer and Deputy Treasurer have completed their review and indicates as such via eSignatures. ? The Chief Financial O?cer receives a carbon copy of the completed DocuSign Envelope. Anticipated Completion Date: December?27,?2022?

View Audit 29468

Finding 29024 (2022-006)

Material Weakness 2022

Southwestern Jefferson County Consolidated School Corporation

IN

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

FINDING 2022-006 Contact Person Responsible for Corrective Action: Laura Boldery, CFO/Corporation Treasurer Contact Phone Number: 812-866-6253 or Cell: 812-801-9070 Contact Email: laurab@swjcs.us Views of Responsible O?cial: We concur with this audit finding. Description of Corrective Action Plan: A...

FINDING 2022-006 Contact Person Responsible for Corrective Action: Laura Boldery, CFO/Corporation Treasurer Contact Phone Number: 812-866-6253 or Cell: 812-801-9070 Contact Email: laurab@swjcs.us Views of Responsible O?cial: We concur with this audit finding. Description of Corrective Action Plan: Action taken in an e?ort to remedy finding 2022-006 includes, but is not limited to, the following: ? We will review or internal controls again and try to implement a process to ensure it is being monitored and completed. ? We will have all invoices monitored before submission. Revenue will be monitored and checked with invoices when received. Anticipated Completion Date: February 1, 2023

View Audit 29468

Finding 29018 (2022-007)

Material Weakness 2022

Southwestern Jefferson County Consolidated School Corporation

IN

Procurement, Suspension & Debarment § 200.1 § 200.303 § 200.317 § 200.318 § 200.319

FINDING 2022-007 Contact Person Responsible for Corrective Action: Katie King, Director of Child Nutrition Contact Phone Number: 812-866-6254 Contact Email: kking@swjcs.us Views of Responsible O?cial: We concur with this audit finding. Description of Corrective Action Plan: Action taken in an e?ort ...

FINDING 2022-007 Contact Person Responsible for Corrective Action: Katie King, Director of Child Nutrition Contact Phone Number: 812-866-6254 Contact Email: kking@swjcs.us Views of Responsible O?cial: We concur with this audit finding. Description of Corrective Action Plan: Action taken in an e?ort to remedy finding 2022-007 includes, but is not limited to, the following: ? Informal procurement methods (small purchase procedures) will be followed for any purchases made by, or on behalf of, the Nutrition Services Department exceeding $10,000.00 up to $150,000.00. Quotes from at least three qualified vendors/contractors will be required. Any purchases made on behalf of the Nutrition Services Department (for example, Maintenance contracting work for kitchen appliance repairs) will need prior approval from the Director of Child Nutrition. ? Wilson Education Center was not an approved co-op for school year, 2020-2021, but was retroactively approved to be a co-op for school year 2021-2022. Therefore, the correction has been made. Anticipated Completion Date: February 1, 2023

View Audit 29468

Finding 28849 (2022-001)

Significant Deficiency 2022

The Tower Theatre Foundation, Inc.

OR

Internal Control / Segregation of Duties Significant Deficiency § 200.303

Responsible Official?s Response: Management of the Theatre is continuing to monitor for opportunities to add an additional permanent employee to the accounting department, and is currently utilizing staff from other departments to segregate accounting duties to the greatest extent possible.

View Audit 28932

Finding 28843 (2022-001)

Material Weakness 2022

Greensburg Community Schools

IN

Internal Control / Segregation of Duties Subrecipient Monitoring Material Weakness § 200.303

FINDING 2022-001 Contact Person Responsible for Corrective Action: Andrea Phillips Contact Phone Number: (812) 663-4774 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The ESSER Annual Data Collection Report will be prepared by the Treasurer and then...

FINDING 2022-001 Contact Person Responsible for Corrective Action: Andrea Phillips Contact Phone Number: (812) 663-4774 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: The ESSER Annual Data Collection Report will be prepared by the Treasurer and then reviewed and approved by the Superintendent and/or the Grant Administrator. During the secondary review, the Superintendent and/or Grant Administrator will compare the ESSER Report to Komputrol Reports and/or calculations prepared by Treasurer, check mark or highlight numbers verified, and signoff on the reports. The Treasurer and Superintendent and/or Grant Administrator will review compliance requirements related to the grant agreement and signoff that all requirements were met. Anticipated Completion Date: April 2023

View Audit 28930

Corrective Action Plans

Filters