Audit 35030

FY End
2022-06-30
Total Expended
$24.62M
Findings
4
Programs
7
Year: 2022 Accepted: 2022-12-08

Organization Exclusion Status:

Checking exclusion status...

Contacts

Name Title Type
KFM2U56JK8P3 Ellen Parr Auditee
2146685188 Debbie Rollins Auditor
No contacts on file

Notes to SEFA

Title: Non-Cash Assistance Accounting Policies: The accompanying Schedules of Expenditures of Federal and State Awards (the Schedule) presents the activity of all applicable federal and state awards of United Way of Metropolitan Dallas, Inc. (United Way).Direct federal awards and those federal awards passed through other government agencies are included. The accompanying Schedules of Expenditures of Federal and State Awards are presented using the accrual basis of accounting. The information in the Schedule of Expenditures of Federal and State Awards is presented in accordance with the requirements of the State of Texas Single Audit Circular included in the Uniform Grant Management Standards issued by the Governors Office of Budget and Planning of the State of Texas. Therefore, some amounts presented in this schedule may differ from amounts presented in, orused in the preparation of, the consolidated financial statements. De Minimis Rate Used: Y Rate Explanation: The auditee used the de minimis cost rate. United Way has not received any non-cash assistance, such as commodities, food stamps, or surplus property, insurance provided by a federal or state agency, or federal or state loans and/or loan guarantees.

Finding Details

Federal Agency: Department of Health and Human Services Federal Program: Cooperative Agreement to Support Navigators in Federally-facilitated and State Partnership Marketplaces Federal Award Number: 93.332 Award Year: 2022 Type of Finding: Control Deficiency Compliance Requirement: Cash Management Criteria: Per 2022 Compliance Supplement part III subpart C, for cost reimbursement contracts under the Federal Acquisition Regulation (?FAR?), reimbursement payment is the predominant method of funding. Advance payments under FAR-based contracts are rare. The FAR clause at 48 CFR section 52.216-7 applies to reimbursement payment. Paragraph (b)(1) of that clause requires that the non-federal entity request reimbursement for (a) only allocable, allowable, and reasonable contract costs that have already been paid, or (b) if the non-federal entity is not delinquent in paying costs of contract performance in the ordinary course of business, costs incurred, but not necessarily paid. As defined in 48 CFR section 52.216-7(b)(1), with relation to supplies and services purchased for use on the contract, ?ordinary course of business? would be in accordance with the terms and conditions of a subcontract or invoice, and ordinarily within 30 days of the request to the federal government for reimbursement. Condition: For one of the two selected reimbursement requests judgmentally selected for testing, an exception was noted for lack of formal documentation of the review and approval over the reimbursement requests. Per review of the entire population, the first five of the nine reimbursement requests did not have formal documentation of review and approval. However, we noted upon the hiring of a new controller the remaining four requests did have documentation of the review and approval. Questioned Costs: None Context: The application of UWMD?s policy to maintain documentation of the review and approval of reimbursement requests for this contract was not effective for the first six months of the year. Subsequent to March 31, 2022, we noted the policy was effective and documentation of review and approval was maintained. Cause: Management failed to have a policy in place throughout the audit period to ensure documentation of the timely review and approval of reimbursement requests was maintained. Effect or potential effect: Failure to ensure reimbursement requests are timely reviewed and approved by appropriate personnel could result in unallowable costs being submitted for reimbursement. Repeat Finding: No Recommendations: We note that management implemented a process requiring the documentation of the review and approval of reimbursement requests is maintained. We recommend that management consider the need to review UWMD?s comprehensive policies to ensure all current and future state and federal grants are addressed by this policy and increase training efforts for all personnel responsible and involved in its grant program management to ensure proper awareness and understanding of cash management controls. Views of responsible officials: The new UWMD Controller transitioned in January of 2022 and noticed in April that she was not receiving formal approval requests to approve disbursement requests against the grant. She immediately implemented a formal review process that was in place for the second six months of the fiscal year and are permanently in place. She also retroactively reviewed disbursements for the first six months of the grant and observed that all were made in line with grant guidelines and were appropriate. The UWMD Controller has also reviewed the accountant?s checklist for all grants ensuring that the approval is a documented step in the process and has provided training to the UWMD team.
Federal Agency: Department of Health and Human Services Federal Program: Cooperative Agreement to Support Navigators in Federally-facilitated and State Partnership Marketplaces Federal Award Number: 93.332 Award Year: 2022 Type of Finding: Control Deficiency and Noncompliance Compliance Requirement: Reporting Criteria: Per 2022 Compliance Supplement under the requirements of the Federal Funding Accountability and Transparency Act (Pub. L. No. 109-282), as amended by Section 6202 of Pub. L. No. 110-252, hereafter referred as the ?Transparency Act? that are codified in 2 CFR Part 170, recipients (i.e., direct recipients) of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Transparency Act Subaward Reporting System (FSRS). Condition: We noted United Way had first-tier subawards greater than $30,000 and did not report the required information in the FSRS system in compliance with the Transparency Act. Questioned Costs: None Context: United Way failed to submit information required under The Transparency Act. Cause: Management did not have controls in place to ensure the required documentation was reported in the FSRS system. Effect or potential effect: Failure to comply with the compliance requirements could result in subaward information not being appropriately reported. Repeat Finding: No Recommendations: We recommend management ensure controls are in place to adhere to reporting requirements within grant agreements. Views of responsible officials: The grant accounting team will develop a Master Grants Checklist to help manage the grant operations process and help the team ensure compliance and reporting requirements are met for each grant. The grant accounting Team will submit information on first-tier subawards to the FSRS for eligible grants by December 31, 2022.
Federal Agency: Department of Health and Human Services Federal Program: Cooperative Agreement to Support Navigators in Federally-facilitated and State Partnership Marketplaces Federal Award Number: 93.332 Award Year: 2022 Type of Finding: Control Deficiency Compliance Requirement: Cash Management Criteria: Per 2022 Compliance Supplement part III subpart C, for cost reimbursement contracts under the Federal Acquisition Regulation (?FAR?), reimbursement payment is the predominant method of funding. Advance payments under FAR-based contracts are rare. The FAR clause at 48 CFR section 52.216-7 applies to reimbursement payment. Paragraph (b)(1) of that clause requires that the non-federal entity request reimbursement for (a) only allocable, allowable, and reasonable contract costs that have already been paid, or (b) if the non-federal entity is not delinquent in paying costs of contract performance in the ordinary course of business, costs incurred, but not necessarily paid. As defined in 48 CFR section 52.216-7(b)(1), with relation to supplies and services purchased for use on the contract, ?ordinary course of business? would be in accordance with the terms and conditions of a subcontract or invoice, and ordinarily within 30 days of the request to the federal government for reimbursement. Condition: For one of the two selected reimbursement requests judgmentally selected for testing, an exception was noted for lack of formal documentation of the review and approval over the reimbursement requests. Per review of the entire population, the first five of the nine reimbursement requests did not have formal documentation of review and approval. However, we noted upon the hiring of a new controller the remaining four requests did have documentation of the review and approval. Questioned Costs: None Context: The application of UWMD?s policy to maintain documentation of the review and approval of reimbursement requests for this contract was not effective for the first six months of the year. Subsequent to March 31, 2022, we noted the policy was effective and documentation of review and approval was maintained. Cause: Management failed to have a policy in place throughout the audit period to ensure documentation of the timely review and approval of reimbursement requests was maintained. Effect or potential effect: Failure to ensure reimbursement requests are timely reviewed and approved by appropriate personnel could result in unallowable costs being submitted for reimbursement. Repeat Finding: No Recommendations: We note that management implemented a process requiring the documentation of the review and approval of reimbursement requests is maintained. We recommend that management consider the need to review UWMD?s comprehensive policies to ensure all current and future state and federal grants are addressed by this policy and increase training efforts for all personnel responsible and involved in its grant program management to ensure proper awareness and understanding of cash management controls. Views of responsible officials: The new UWMD Controller transitioned in January of 2022 and noticed in April that she was not receiving formal approval requests to approve disbursement requests against the grant. She immediately implemented a formal review process that was in place for the second six months of the fiscal year and are permanently in place. She also retroactively reviewed disbursements for the first six months of the grant and observed that all were made in line with grant guidelines and were appropriate. The UWMD Controller has also reviewed the accountant?s checklist for all grants ensuring that the approval is a documented step in the process and has provided training to the UWMD team.
Federal Agency: Department of Health and Human Services Federal Program: Cooperative Agreement to Support Navigators in Federally-facilitated and State Partnership Marketplaces Federal Award Number: 93.332 Award Year: 2022 Type of Finding: Control Deficiency and Noncompliance Compliance Requirement: Reporting Criteria: Per 2022 Compliance Supplement under the requirements of the Federal Funding Accountability and Transparency Act (Pub. L. No. 109-282), as amended by Section 6202 of Pub. L. No. 110-252, hereafter referred as the ?Transparency Act? that are codified in 2 CFR Part 170, recipients (i.e., direct recipients) of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Transparency Act Subaward Reporting System (FSRS). Condition: We noted United Way had first-tier subawards greater than $30,000 and did not report the required information in the FSRS system in compliance with the Transparency Act. Questioned Costs: None Context: United Way failed to submit information required under The Transparency Act. Cause: Management did not have controls in place to ensure the required documentation was reported in the FSRS system. Effect or potential effect: Failure to comply with the compliance requirements could result in subaward information not being appropriately reported. Repeat Finding: No Recommendations: We recommend management ensure controls are in place to adhere to reporting requirements within grant agreements. Views of responsible officials: The grant accounting team will develop a Master Grants Checklist to help manage the grant operations process and help the team ensure compliance and reporting requirements are met for each grant. The grant accounting Team will submit information on first-tier subawards to the FSRS for eligible grants by December 31, 2022.