Corrective Action Plans

Finding 406051 (2023-006)

Material Weakness 2023

NM

Cash Management Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Corrective Action: NTU has established a monthly cash management schedule to track and identify all grant funds, detailing the total cash received in advance from grantors and amounts due to NTU. To increase cash balances, NTU will focus on the timely collection of outstanding grants receivable. Add...

Corrective Action: NTU has established a monthly cash management schedule to track and identify all grant funds, detailing the total cash received in advance from grantors and amounts due to NTU. To increase cash balances, NTU will focus on the timely collection of outstanding grants receivable. Additionally, NTU will analyze cash requirements and may liquidate investments held in the Capital Reserve fund to ensure adequate cash is available for grants received in advance. Person Responsible: Beverly Miller, Accounting Manager Estimated Completion Date: July 31, 2024

View Audit 311593

Finding 406012 (2023-004)

Material Weakness 2023

Oakland County, Michigan

MI

Subrecipient Monitoring Material Weakness Reporting § 200.303

Condition: The County did not have controls in place during the year under audit to ensure that the required certified payrolls were received by contractors and subcontractors. Planned Corrective Action: Develop a process with Neighborhood Housing and Development Department ensuring all appropriate ...

Condition: The County did not have controls in place during the year under audit to ensure that the required certified payrolls were received by contractors and subcontractors. Planned Corrective Action: Develop a process with Neighborhood Housing and Development Department ensuring all appropriate documentation has been reviewed and received. Contact person responsible for corrective action: Khadija Walker-Fobbs Anticipated Completion Date: 07/15/2024

View Audit 311580

Finding 405998 (2023-002)

None 2023

La Asociacion Nacional Pro Personas Mayores (the National Association for Hispanic Elderly)

CA

Questioned Costs Matching / Level of Effort / Earmarking

Management has discussed with DOL and requested relief from paying back the funds in question. The Association has also trained additional staff members to monitor more closely to ensure the percentage requirements are met on a monthly basis.

View Audit 311560 Questioned Costs: $1

Finding 405994 (2023-001)

Material Weakness 2023

Neighborhood Housing Services of the Black Hills, Inc.

SD

Reporting Internal Control / Segregation of Duties Matching / Level of Effort / Earmarking

Finding #2023-001 – Preparation of Financial Statements and Schedule of Expenditures of Federal Awards (SEFA) and Audit Adjustments Responsible Individuals: Mike Walker (CEO) and Kathleen Burnham (Accountant) Corrective Action Plan: The Organization has accepted the risk associated with requesting...

Finding #2023-001 – Preparation of Financial Statements and Schedule of Expenditures of Federal Awards (SEFA) and Audit Adjustments Responsible Individuals: Mike Walker (CEO) and Kathleen Burnham (Accountant) Corrective Action Plan: The Organization has accepted the risk associated with requesting the auditors to prepare the financial statements and SEFA and continues to plan for the auditors to prepare the reports. Due to the cost of hiring a full-time replacement staff accountant, the board of directors and management are willing to accept this degree of risk associated financial statement and SEFA preparation and will assist with additional internal oversight to limit risk accordingly. Anticipated Completion Date: Ongoing

View Audit 311542

Finding 405970 (2023-001)

Material Weakness 2023

Goodwill Industries of Middle Georgia, Inc. and Affiliates

GA

Student Financial Aid Special Tests & Provisions Matching / Level of Effort / Earmarking

Audit Finding Number: 2023-001-Enrollment Reporting: Management concurs with the finding. The College submitted enrollment reports over the past year according to our approved submission schedule, but the reports were rejected due to configuration issues with our student information system (SIS). W...

Audit Finding Number: 2023-001-Enrollment Reporting: Management concurs with the finding. The College submitted enrollment reports over the past year according to our approved submission schedule, but the reports were rejected due to configuration issues with our student information system (SIS). We worked diligently to resolve these issues with assistance from Anthology and the National Student Clearinghouse. All the reporting configuration issues that prevented timely and accurate reporting have been resolved and verified by the National Student Clearinghouse. The College has implemented a process whereby the Registrar reports graduation statuses at the conclusion of each term to the College's SIS for upload to the National Student Clearinghouse and subsequent transmission to NSLDS. The Registrar will create a separate report of students who have completed a program yet are continuing their education at the College. In addition, the Registrar will generate a weekly report from the College's SIS listing the last date of attendance for drops/withdrawals, leaves of absence, and standard periods of non-enrollment and upload to the National Student Clearinghouse with subsequent transmission to NSLDS monthly. As an internal control, submitting the report will be a joint venture between the Registrar, the Financial Aid Manager, and the Associate Vice President of Education. These individuals have completed all the required training to ensure accurate reporting. To ensure timely reporting, all will receive transmission and error reports, and submission dates will be set on outlook calendars as a constant reminder. Successful report submission will be a required report at the College's bi-weekly operations meeting. William H. Dindy, Associate Vice President of Education

View Audit 311527

Finding 405968 (2023-002)

Significant Deficiency 2023

Tech Corps Ohio

OH

Questioned Costs Allowable Costs / Cost Principles Subrecipient Monitoring § 200.308 § 200.309 § 200.403

We agree that the allocation being performed once annually does not create the most equitable allocation of costs between our individual programs. We will perform our indirect cost allocations more periodically during the course of the fiscal year to ensure that more appropriate times studies and a...

We agree that the allocation being performed once annually does not create the most equitable allocation of costs between our individual programs. We will perform our indirect cost allocations more periodically during the course of the fiscal year to ensure that more appropriate times studies and applicable participant hours are being utilized to limit the potential of allocating unrelated indirect costs from the year to individual programs, including the federally funded programs.

View Audit 311525 Questioned Costs: $1

Finding 405964 (2023-003)

Significant Deficiency 2023

Door County Economic Development Corporation

WI

Subrecipient Monitoring Reporting Significant Deficiency

Special Reporting Supporting Documentation Reporting – Economic Development Assistance–Revolving Loan Fund – CFDA No. 11.307 Recommendation: Door County Economic Development Corporation should create an internal monitoring system to document future review of the ED-209 reports and verify that suppo...

Special Reporting Supporting Documentation Reporting – Economic Development Assistance–Revolving Loan Fund – CFDA No. 11.307 Recommendation: Door County Economic Development Corporation should create an internal monitoring system to document future review of the ED-209 reports and verify that supporting documentation is attached and retained for review during future audits. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: Management will prepare future ED-209 reports well in advance of deadlines so that they can be verified by contracted accounting professionals prior to submittal to ensure accuracy. Name(s) of the contact person(s) responsible for corrective action: Michelle Lawrie Planned completion date for corrective action plan: Ongoing

View Audit 311523

Finding 405935 (2023-002)

Material Weakness 2023

Central Valley School District No. 356

WA

Subrecipient Monitoring Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

CORRECTIVE ACTION PLAN FOR FINDINGS REPORTED UNDER UNIFORM GUIDANCE Central Valley School District No. 356 September 1, 2022 through August 31, 2023 This schedule presents the corrective action the District is planning to take for findings included in this report in accordance with Title 2 U.S. Code...

CORRECTIVE ACTION PLAN FOR FINDINGS REPORTED UNDER UNIFORM GUIDANCE Central Valley School District No. 356 September 1, 2022 through August 31, 2023 This schedule presents the corrective action the District is planning to take for findings included in this report in accordance with Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Finding ref number: 2023-002 Finding caption: The District did not have adequate internal controls for ensuring compliance with federal wage rate requirements. Name, address, and telephone of District contact person: Mathew Knott, Director of Business Services 2218 N. Molter Road Liberty Lake, WA 99019 509-558-5437 Corrective action the auditee plans to take in response to the finding: The District agrees with the State Auditor’s Office that we did not have adequate internal controls for ensuring compliance with federal prevailing wage rate requirements as noted. The District used the same process as noted in this Finding in the 2020-2021 audit which did not have any exceptions noted by the State Auditor’s Office. In July 2023, the District ensured federal prevailing wage rate clauses were in any new contract entered into using federal funds and that weekly certified payroll reports were collected from contractors and subcontractors. Also, contracts before July 2023 were retroactively updated to include federal prevailing wage rate clauses. Anticipated date to complete the corrective action: July 2023

View Audit 311478

Finding 405927 (2023-002)

Material Weakness 2023

Impact Community Action Partnership, Inc.

IA

Internal Control / Segregation of Duties Material Weakness Reporting

Management’s Response: Management agrees with the finding. Contact Person Responsible for Corrective Action: Anne Bacon, CEO Corrective Action Plan: The auditor finding concludes that the cause of the finding is: “Rapid growth of new funding without a corresponding increase in fiscal personnel has r...

Management’s Response: Management agrees with the finding. Contact Person Responsible for Corrective Action: Anne Bacon, CEO Corrective Action Plan: The auditor finding concludes that the cause of the finding is: “Rapid growth of new funding without a corresponding increase in fiscal personnel has resulted in additional responsibilities placed on the Chief Financial Officer and Chief Operating Officer. The transition to remote working has also resulted in difficulties with handling electronic documentation and approvals.” An additional cause was the previous CFO’s decision to bypass the outlined process and not submit the journal entries for review. To address these causes, IMPACT Community Action Partnership will follow a rectifying course of action. 1. Remove CFO that was responsible for reconciliations (complete) 2. Hire an interim Controller to assess and rectify all fiscal internal controls (complete) 3. Do not grant check signing capability to the controller (complete) 4. Edit or official, board approved Fiscal Procedures to include process for the review of journal entries (August 2024) 5. Procure a more robust fiscal software that permits more efficient electronic record review. (complete) Anticipated Completion Date: August, 2024

View Audit 311459

Finding 405922 (2023-001)

Material Weakness 2023

Impact Community Action Partnership, Inc.

IA

Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Management’s Response: Management agrees with the finding. Contact Person Responsible for Corrective Action: Anne Bacon, CEO Corrective Action Plan: The auditor finding concludes that the cause of the finding is: “Rapid growth of new funding without a corresponding increase in fiscal personnel, comb...

Management’s Response: Management agrees with the finding. Contact Person Responsible for Corrective Action: Anne Bacon, CEO Corrective Action Plan: The auditor finding concludes that the cause of the finding is: “Rapid growth of new funding without a corresponding increase in fiscal personnel, combined with the late issuance of the September 30, 2022, audited financial statements resulted in significant delays in reconciliations and preparing for the September 30, 2023 audit..” In order to address these causes, IMPACT Community Action Partnership will follow a rectifying course of action. 1. Hire a Controller in order have a staff person focused entirely on the internal processes of the agency. (complete) 2. Procure a more robust fiscal software that will create efficiencies around reconciliations. (Procurement complete) 3. Contract with an accounting specialist to assure 2024 reconciliations are up to date and the transfer to the new accounting software is completed in a timelier manner (by July 15, 2024) Anticipated Completion Date: July, 2024

View Audit 311459

Finding 405882 (2023-001)

Material Weakness 2023

Every Woman's Place

MI

Internal Control / Segregation of Duties Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking

EWP has reviewed the current internal control system for financial management and re-implemented the review and approval process for all invoices and expenditures. Program staff are required to obtain pre-approval for expenses and the expenditure must be approved by the Program Supervisor, Program D...

EWP has reviewed the current internal control system for financial management and re-implemented the review and approval process for all invoices and expenditures. Program staff are required to obtain pre-approval for expenses and the expenditure must be approved by the Program Supervisor, Program Director, and Executive Director prior to purchase. During the audit period, the agency was moving toward a digital document retention system that had not yet been fully implemented. Currently, the agency has moved back to a paper approval system to ensure that the expense is walked through all levels of approval before purchase. While we do hope to pursue a digital system in the future, obtaining physical signatures for expenses has provide an extra level of internal control for the approval process.

View Audit 311449

Finding 405826 (2023-001)

Significant Deficiency 2023

Genesis Community Health, Inc.

FL

Questioned Costs Cash Management Significant Deficiency § 200.302

Additional preventive internal control procedures will be implemented, including an additional level of review of the reimbursement requests prior to submission. These procedures and internal controls have been implemented as of the date of this report.

View Audit 311441 Questioned Costs: $1

Finding 405787 (2023-001)

Significant Deficiency 2023

Nebraska Urban Indian Health Coalition, Inc.

NE

Period of Performance Significant Deficiency Matching / Level of Effort / Earmarking § 200.313

SECTION III – FINDINGS – FEDERAL AWARD FINDINGS Finding 2023-001 – Activities Allowed/Unallowed, Costs Principles, and Period of Performance (Internal Controls Over Compliance) Significant Deficiency Criteria: Uniform Guidance 2 CFR, Part §200.313(a) requires that non-federal entities must establish...

SECTION III – FINDINGS – FEDERAL AWARD FINDINGS Finding 2023-001 – Activities Allowed/Unallowed, Costs Principles, and Period of Performance (Internal Controls Over Compliance) Significant Deficiency Criteria: Uniform Guidance 2 CFR, Part §200.313(a) requires that non-federal entities must 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). Condition: During our review of the Coalition’s disbursements related to the Title V major program, we examined 40 transactions for internal controls over compliance. 2 of the 40 transactions examined did not contain sufficient evidence that a review and approval process was completed prior to payment being processed. Questioned Costs: None Cause: The Coalition does not have sufficiently established control policies and procedures to ensure proper approvals are obtained prior to the disbursement transactions being processed. Effect: Disbursements are being processed without proper approval, resulting in the possibility of disallowed expenditures. SECTION III – FINDINGS – FEDERAL AWARD FINDINGS Finding 2023-001 – Activities Allowed/Unallowed, Costs Principles, and Period of Performance (Internal Controls Over Compliance), continued Recommendation: We recommend the Coalition becomes familiar with requirements of 2 CFR, Part §200.313(a) and establishes appropriate internal control policies and procedures and that all staff be trained on those policies and procedures, so they are familiar with the requirements. We further recommend the Coalition does not process payment for disbursements that do not contain necessary approvals. Responsible Official: Carlett Gregory, CFO Corrective Action: In response to the finding regarding insufficient internal controls over compliance for disbursements related to the Title V major program, the Coalition will take the following corrective actions: 1. Review and Revise Policies and Procedures: o The Coalition will conduct a thorough review of our current internal control policies and procedures related to disbursements to ensure they align with the requirements of 2 CFR, Part §200.313(a). o We will revise and update our policies and procedures as necessary to ensure they are comprehensive and robust, providing clear guidelines for review and approval processes. 2. Training and Education: o We will provide additional training to all staff involved in the procurement process to ensure they are fully aware of the updated policies and procedures. o The training will cover the importance of obtaining proper approvals prior to processing payments and the specific requirements of 2 CFR, Part §200.313(a). 3. Implementation of Approval Controls: o We have implemented a standardized approval process for all disbursements, ensuring that each transaction is reviewed and approved by the designated authority before payment is processed. o We currently have in place a checklist to document the review and approval process for each transaction, ensuring that evidence of compliance is retained. 4. Monitoring and Compliance Checks: o We will establish regular monitoring and compliance checks to ensure adherence to the updated policies and procedures. o Quarterly internal audits will be conducted to verify that all disbursements are properly reviewed and approved according to the established guidelines. Timeline for Implementation: The corrective actions outlined above have been implemented. Training sessions will be part of the onboarding process and existing programs. It will also be reviewed as needed to address any changes.

View Audit 311425

Finding 405726 (2023-002)

Significant Deficiency 2023

New Mexico Coalition to End Homelessness

NM

Reporting Significant Deficiency Matching / Level of Effort / Earmarking § 200.303 § 200.502 § 200.510

2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presente...

2023-002 [2022‐002]—PREPARATION OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Federal Agency: All presented in the Schedule of Expenditures of Federal Awards. Program Name: All presented in the Schedule of Expenditures of Federal Awards. Assistance Listing Nos. and Program Expenditures: All presented in Schedule of Expenditures of Federal Awards. Award Number and Program Award Year: All presented in Schedule of Expenditures of Federal Awards. Compliance Requirement: Other – Schedule of Expenditures of Federal Awards preparation Statement of Condition During our audit, we reviewed the Coalition’s federal grants report for the fiscal year and identified the federal grants, Assistance Listing #s (AL#s) and the amounts of the federal expenditures and all of the other items required to properly present the Schedule of Expenditures of Federal Awards (SEFA). We then had the finance staff of the Coalition confirm the correctness of the SEFA. Despite the confirmation of accuracy, additional federal expenditures and grouping of grant expenditures were identified after several reviews of the SEFA.Criteria 2 CFR 200.510 indicates that the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for Determining Federal Awards Expended. Per 2 CFR 200.502, the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. Generally, the activity pertains to events that require the non-federal entity to comply with federal statutes, regulations, and the terms and conditions of federal awards, such as expenditure/expense transactions associated with awards. In addition, 2 CFR Part 200.303 requires the program to establish and maintain effective internal controls over federal awards that provides reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of federal awards. Effect Without an established process governed by effective internal controls, the Coalition may not prevent or detect material misstatements on its SEFA in a timely manner. In addition, the errors could result in improper selections of major program(s) for the single audit and a substandard single audit. Cause Historically, the Coalition has requested the auditor assist in identifying accruals related to federal grant expenditures as the organization has maintained these records on a cash basis. As the organization has taken more responsibility on maintaining its federal grant expenditures on an accrual basis, an incomplete SEFA has been provided. Recommendation We recommend the Coalition prepare the Schedule of Expenditures of Federal Awards and submit this to the auditor for testing. The SEFA should include the name of the grant, name of grantor, the AL #, the pass-through number if applicable and a reconciliation of the federal revenues and expenditures to the Coalition’s general ledger. The Coalition staff should perform more detailed reviews of the reports to ensure they properly reflect grant receipts and expenditures. This review should be performed by someone other than the preparer and should include documented evidence of agreeing the reported data to the accounting records. We further recommend training for those individuals involved in the preparation and review of the reports to ensure they are fully aware of the requirements. View of Responsible Officials and Corrective Action Plan: The corrective Action Plan will be carried out in the 2024 Fiscal Year and information will be given to the auditors when requested for the next audit. The Coalition will ensure that all information needed for the SEFA is kept and entered accurately (this process has already begun). When the fiscal year closes out, the Coalition will provide the auditors with a test SEFA to confirm that the information we are collecting throughout the year and are asserting are the correct numbers for our federal grants, is indeed the correct information. Corrective Action Plan Timeline: Completed by December 13, 2024 (Final copy of the SEFA will not be given to the auditors until requested for the 2024 Audit) Designation Of Employee Position Responsible For Meeting Deadline: Executive Director will oversee this project and work directly with NMCEH finance staff work closely with the auditors to make sure that the information saved and shared is correct. Type of Finding: (F) Significant Deficiency in Internal Control over Compliance of Federal Awards. Questioned Costs: None

View Audit 311401

Finding 405700 (2023-003)

Significant Deficiency 2023

Comprehensive Mental Health Center of Tacoma-Pierce County

WA

Cash Management Internal Control / Segregation of Duties Allowable Costs / Cost Principles

Finding: 2023-003 - Oversight over cash management compliance requirement. Contact Person(s): Dan Gehl, CFO (dgehl@cmhshare.org) Explanation and specific reasons for disagreement with the audit finding or that corrective action is not required (if applicable): No disagreements. Corrective action pla...

Finding: 2023-003 - Oversight over cash management compliance requirement. Contact Person(s): Dan Gehl, CFO (dgehl@cmhshare.org) Explanation and specific reasons for disagreement with the audit finding or that corrective action is not required (if applicable): No disagreements. Corrective action planned: In September 2023, CLR has addressed the finding that its policies and procedures over reimbursement requests for federal funds lacked proper documentation of approvals according to the Uniform Guidance for federal grants. We have added a step in the online submission process with the Substance Abuse and Mental Health Services Agency (SAMHSA) to capture a screenshot of the reimbursement form to be approved before submission. Due to the timing of the FY 2022 Single Audit completion and the ending of the CCBHC contract, we were limited in the execution of this new procedure, however it is now part of our Single Audit accounting Policies and Procedures Manual. Anticipated completion date: Completed September 2023.

View Audit 311356

Finding 405699 (2023-002)

Significant Deficiency 2023

Comprehensive Mental Health Center of Tacoma-Pierce County

WA

Allowable Costs / Cost Principles Procurement, Suspension & Debarment Significant Deficiency

Finding: 2023-002 - Written policies required by the Uniform Guidance Contact Person(s): Dan Gehl, CFO (dgehl@cmhshare.org) Explanation and specific reasons for disagreement with the audit finding or that corrective action is not required (if applicable): No disagreements. Corrective action planned:...

Finding: 2023-002 - Written policies required by the Uniform Guidance Contact Person(s): Dan Gehl, CFO (dgehl@cmhshare.org) Explanation and specific reasons for disagreement with the audit finding or that corrective action is not required (if applicable): No disagreements. Corrective action planned: In September 2023, CLR has implemented written policies and procedures for Single Audit accounting that comply with the Uniform Guidance for federal grant payments, procurement, allowable costs, and compensation. They will also be posted online via the company website for access by all staff. Going forward, these policies will be reviewed and updated as needed following the general CLR process for all policies and procedures. Anticipated completion date: Completed September 2023.

View Audit 311356

Finding 404938 (2023-001)

Significant Deficiency 2023

Action, Inc.

MA

Eligibility Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties § 200.303

Federal Agency: U.S. Department of Health and Human Services Federal Program: 93.568 Low Income Home Energy Assistance Responsible Official Jennifer Beloff, Chief Program Officer Plan Detail Action is in the process of taking the LIHEAP Operators Guide and creating an Action Policy/Procedure manual ...

Federal Agency: U.S. Department of Health and Human Services Federal Program: 93.568 Low Income Home Energy Assistance Responsible Official Jennifer Beloff, Chief Program Officer Plan Detail Action is in the process of taking the LIHEAP Operators Guide and creating an Action Policy/Procedure manual updating /highlighting findings from current and past audits for staff to keep current and for new staff to review when they start working in the LIHEAP program. At the start of the LIHEAP program year, the Energy Director will meet with all staff and review program highlights, changes and new instructions and have staff signoff having participated in the meeting. Anticipated Completion Date June 30, 2024

View Audit 311334

Finding 404936 (2023-002)

Material Weakness 2023

Anthem Strong Families

TX

Allowable Costs / Cost Principles Material Weakness Period of Performance

CORRECTIVE ACTION PLAN: The Organization will adopt procedures that allow for the timely tracking of refundable advances, to ensure funds are properly expended during the period of performance.

View Audit 311322

Finding 404862 (2023-004)

Material Weakness 2023

District Bridges

DC

Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking

Views of Responsible Officials: District Bridges is currently researching time-tracking options, specifically for employees whose salaries are covered, full or partially, by federally-funded grants.

View Audit 311249

Finding 404861 (2023-003)

Material Weakness 2023

District Bridges

DC

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

Views of Responsible Officials: During our FY22 audit, GRF expressly noted that for an organization our size, tracking grant expenses outside of Quickbooks was understandable and acceptable. During this FY23 audit, GRF changed its stance and said we had to report grant expenses in Quickbooks. This s...

Views of Responsible Officials: During our FY22 audit, GRF expressly noted that for an organization our size, tracking grant expenses outside of Quickbooks was understandable and acceptable. During this FY23 audit, GRF changed its stance and said we had to report grant expenses in Quickbooks. This should be removed as a finding, as District Bridges was following the advice of GRF from the FY22 audit. It is unconscionable to discredit an organization after they followed the firm's advice. Additionally, over the last few months, we have consulted several other nonprofit finance experts, as well as peer organizations that receive federal funds, to see tracking templates and procedures, and understand best practices. We are currently exploring more robust grant expense tracking softwares based on their recommendations, but they all noted that spreadsheet tracking was acceptable for an organization of our size.

View Audit 311249

Finding 404814 (2023-005)

Significant Deficiency 2023

Mobridge Regional Hospital

SD

Allowable Costs / Cost Principles Cash Management Eligibility § 200.303

Federal Agency Name: Department of Agriculture Program Name: Communities Facilities Loans and Grants Cluster Federal Financial Assistance Listing #10.766 Finding Summary: The Hospital’s requests for reimbursement under the Community Facilities Grant Agreement were not reviewed and approved by a sep...

Federal Agency Name: Department of Agriculture Program Name: Communities Facilities Loans and Grants Cluster Federal Financial Assistance Listing #10.766 Finding Summary: The Hospital’s requests for reimbursement under the Community Facilities Grant Agreement were not reviewed and approved by a separate individual. Responsible Individuals: Renae Karst, Chief Financial Officer Corrective Action Plan: Hospital personnel will compile the initial requests for reimbursement with the help of Management to provide proof of invoices and payments. The final request for reimbursement will then be verified by Management prior to requesting reimbursement to the Communities Facilities Grant Coordinator. Anticipated Completion Date: June 30, 2024

View Audit 311195

Finding 404811 (2023-004)

Material Weakness 2023

Mobridge Regional Hospital

SD

Special Tests & Provisions Subrecipient Monitoring Cash Management § 200.303

Federal Agency Name: Department of Agriculture Program Name: Communities Facilities Loans and Grants Cluster Federal Financial Assistance Listing #10.766 Finding Summary: Management maintained the reserve amount in the cash sweep general fund account which was not established as a separate bookkeep...

Federal Agency Name: Department of Agriculture Program Name: Communities Facilities Loans and Grants Cluster Federal Financial Assistance Listing #10.766 Finding Summary: Management maintained the reserve amount in the cash sweep general fund account which was not established as a separate bookkeeping account or as a separate bank account. The Hospital had excess cash available to cover the required reserve amount. Responsible Individuals: Renae Karst, Chief Financial Officer Corrective Action Plan: Management will establish a separate bookkeeping account in the general ledger to establish the correct reserve amount of cash within its general operating bank account. The reserve account will be part of total cash in the bank to maximize interest earned on the reserve balance. Anticipated Completion Date: June 30, 2024

View Audit 311195

Finding 404807 (2023-003)

Material Weakness 2023

Mobridge Regional Hospital

SD

Reporting Material Weakness Matching / Level of Effort / Earmarking

Federal Agency Name: Department of Agriculture Program Name: Communities Facilities Loans and Grants Cluster Federal Financial Assistance Listing #10.766 Federal Agency Name: Department of Health and Human Services Program Name: COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Dis...

Federal Agency Name: Department of Agriculture Program Name: Communities Facilities Loans and Grants Cluster Federal Financial Assistance Listing #10.766 Federal Agency Name: Department of Health and Human Services Program Name: COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Federal Financial Assistance Listing #93.498 Finding Summary: The Hospital does not have an internal control system designed to provide for a complete and accurate schedule of federal expenditures of federal awards being audited. As auditors, Eide Bailly LLP was requested to assist with the preparation of the schedule. Responsible Individuals: Renae Karst, Chief Financial Officer Corrective Action Plan: It is not cost effective to have an internal control system designed to prepare the schedule of expenditures of federal awards. We requested that our auditors, Eide Bailly LLP, to assist with the preparation of the schedule of expenditures of federal awards. We have designated a member of management to review the drafted schedule of expenditures of federal awards, and we have reviewed with and agree with the final Schedule of Expenditures of Federal Awards. A Grant Award Policy and Procedure Manual was implemented defining tracking and reporting of awards to ensure accurate and up-to-date communication of award requirements. This communication will include implementing additional processes to improve our internal controls over identifying and reporting of expenditures in compliance with the Schedule of Expenditures of Federal Awards (SEFA) if applicable. We will provide staff training annually for any updates or adjustments to the policy. Anticipated Completion Date: Ongoing

View Audit 311195

Finding 404799 (2023-004)

Significant Deficiency 2023

Baltimore County, Maryland

MD

Questioned Costs Reporting Significant Deficiency § 200.303

COVID-19 – Emergency Rental Assistance – Assistance Listing No. 21.023 Recommendation: We recommend that management review their policies and make revisions where necessary to ensure that documentation is maintained to support amounts reported by the County in their quarterly grant reporting. We al...

COVID-19 – Emergency Rental Assistance – Assistance Listing No. 21.023 Recommendation: We recommend that management review their policies and make revisions where necessary to ensure that documentation is maintained to support amounts reported by the County in their quarterly grant reporting. We also recommend that management review their policies and procedures and make changes necessary to ensure reports are filed timely. Explanation of disagreement with audit finding: The one instance when the County submitted its quarterly report after the due date occurred due to a technical problem with submission. The Treasury data system would not accept the County’s report on the due date. The County sent Treasury an email alerting them to the problem as soon as it was determined that the County was unable to submit. Once the issue was resolved, the County submitted a few days later with no adverse impact to the County or its use of federal ERA funding. As per the concern that audit staff could not verify key line items in the submitted quarterly report, the County completed all required line items in the reports, however, the Treasury report downloads with multiple blank items in report cells. The County cannot control this deficiency in the Treasury downloads. If any submitted report were incomplete, Treasury would have returned the incomplete report to a local jurisdiction for missing elements. No referenced reports were returned to the County for completion, thereby demonstrating that all reports were complete at the time of submission. The problem relates solely to the downloaded report from the Treasury website. Neither the County nor the audit staff were able to determine a workaround for the incomplete Treasury report downloads. Action taken in response to finding: No additional action is needed because the one late quarterly reporting problem was resolved and the report was uploaded as soon as the technical glitch was resolved. Name(s) of the contact person(s) responsible for corrective action: Colleen Mahoney Planned completion date for corrective action plan: Already Completed

View Audit 311187 Questioned Costs: $1

Finding 404783 (2023-002)

Material Weakness 2023

Allegany County Human Resources Development Commission, Inc.

MD

Questioned Costs Allowable Costs / Cost Principles Reporting

An excel workbook will be created to include all reports that need submitted. The workbook will have the program dates, how often it needs submitted and when, as well as the person responsible for completing and submitting the reports. This will be a part of the aforementioned accounting calendar an...

An excel workbook will be created to include all reports that need submitted. The workbook will have the program dates, how often it needs submitted and when, as well as the person responsible for completing and submitting the reports. This will be a part of the aforementioned accounting calendar and will also be outlined in the Finance Policies due in September as an appendix.

View Audit 311182 Questioned Costs: $1

Corrective Action Plans

Filters