EIN: 746000089
UEI: JCJBPTJXYXH9
Data as of August 20, 2026
Management decision deadline — for entities that funded this organization
The FAC accepted this audit on March 23, 2023. Under 2 CFR 200.521(d), a pass-through entity that provided federal funds to this organization for this audit period must issue a management decision on these findings by September 23, 2023, which was (1062 days ago).
What is a management decision? →2022-001 Activities Allowed or Unallowed, Allowable Costs/ Cost Principles ? Indirect Costs Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Temporary Assistance for Needy Families (TANF) ALN: 93.558 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXTANF, 2201TXTAN3 October 1, 2021 ? September 30, 2022 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the nonFederal 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: DFPS utilizes four basic methods to develop allocated project IDs that are used to allocate indirect costs: Paid-Full Time Equivalents (PFTE), random moment time study, case counts by client eligibility, and service unit counts. To ensure allocated project IDs are complete and accurate, project allocation percentage forms are signed and dated by the preparer, 1st Proofer, 2nd Proofer, Entered By, and Enter Proofed By individuals. During our testing of 40 indirect costs, 12 transactions did not have full approval for the project allocation. The project allocation documentation was missing the approval for Entry Proofed By. This approval is to ensure the allocation entered into the system agrees to the project allocation documentation. All 12 transactions were allocated to the same project ID. Questioned costs: None Context: See ?Condition.? Cause: The exception was caused by management oversight. Effect: Failure to complete adequate reviews over project IDs may result in incorrect allocation of costs and questioned costs. Repeat Finding: No Recommendation: We recommend DFPS strengthen its existing internal controls over the review of project IDs to ensure all approvals are obtained on the project allocation percentage forms. Views of responsible officials: Management agrees with the finding.
Corrective action plan: Management will strengthen agency?s existing internal control over the review of project IDs to ensure all approvals are obtained on the project allocation percentage forms. Implementation date(s): May 31, 2023 Responsible persons: Maura Flores
2022-002 Eligibility Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Temporary Assistance for Needy Families (TANF) ALN: 93.558 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXTANF, 2201TXTAN3, 2101TXTANF, 2101TXTAN3, 2001TXTANF, 2001TXTAN3 October 1, 2021 ? September 30, 2022, October 1, 2020 ? September 30, 2021 and October 1, 2019 ? September 30, 2020 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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). Per 45 CFR 263.2(b), An ?eligible family? as defined by the State, must: (1) Be comprised of citizens or non-citizens who: (i) Are eligible for TANF assistance; (ii) Would be eligible for TANF assistance, but for the time limit on the receipt of federally funded assistance; or (iii) Are lawfully present in the United States and would be eligible for assistance, but for the application of title IV of PRWORA; (2) Include a child living with a custodial parent or other adult caretaker relative (or consist of a pregnant individual); and (3) Be financially eligible according to the appropriate income and resource (when applicable) standards established by the State and contained in its TANF plan. Condition: According to the DFPS?s Child Protective Services Handbook 2720 Responding to the Eligibility Statements CPS June 2020, IMPACT automatically makes the EA Eligibility Application/Determination section available when the caseworker completes the Risk Assessment tool and the risk level is `high? or `very high.? The caseworker completes this section, which contains three statements that each require a response of `yes? or `no?. For one of 40 payments to program participants, we noted two of the three statements were not answered in IMPACT, resulting in a determination that the child does not meet the emergency assistance eligibility criteria. The DFPS?s sandbox database reflects a conclusion that the child does meet the emergency assistance eligibility criteria indicating that the three statements had a response of `yes `at the time of stage closure. However, we were unable to verify a response of `yes? for the three statements in IMPACT. According to the DFPS?s Child Protective Services Handbook 2714 Documentation CPS June 2020, the caseworker documents the following information in the contact narrative in IMPACT: ? The names of the people whose income the caseworker counted in the family?s total annual income. ? The information that the caseworker gathered to determine the family?s total annual income. ? The sources of information that the caseworker used (including the FCAA, if DFPS has removed a child). ? The family?s total annual income (before taxes and other similar deductions). For two of 40 payments to program participants, we noted the following exceptions in the documentation of the family's income: ? One participant had an annual family income range selected of $0 - $10,000. However, the investigation report had $20,640 as annual family income. ? One participant had an annual family income range selected of $10,000 - $20,000. No income information was documented in the investigation report. According to the DFPS?s TANF School Allowance Kinship Program, the Pandemic Emergency Assistance Fund (PEAF) awards are disbursed through two payments ? (1) a spring allocation of $250 and (2) a fall allocation of $250 to be used cover the cost of clothing and school supplies for the school year. The maximum number of disbursements to be made for each participant is two disbursements. For three of seven payments to program participants under the TANF PEAF, three payments were made rather than two, resulting in total overpayments of $750. Questioned costs: $9,119 Context: See ?Condition.? Cause: Exceptions related to missing statements in IMPACT were caused by system limitations. Exceptions related to documentation of family income were due to management oversight. Exceptions related to PEAF are a result of DFPS not having an existing process to disburse payments under the new grant. The individuals were mistakenly captured twice for the 2nd payment. Effect: Failure to review and maintain accurate information may result in payments made to ineligible participants or overpayments to eligible participants. Repeat Finding: No Recommendation: DFPS should strengthen its internal controls and remedy system limitations to ensure accurate data is maintained in IMPACT. EA Application/Determination Views of responsible officials: Although these questions can currently be answered by reviewing the Investigation Report for the participant to show that the participant was eligible. DFPS acknowledges and agrees with the finding two of the three EA questions regarding a participant do not show currently answered. DFPS acknowledges and agrees with the finding regarding the incorrect documentation of income for two of the participants. PEAF Views of responsible officials: This is not a regular DFPS payment, therefore there is not an existing automatic process to disburse payments. As a result, a process was developed by which qualifying children were captured and paid through a batch process. It appears that the subject children were mistakenly captured twice for the 75U payment. DFPS?s TANF School Allowance was a one-time allocation of COVID funding for the school allowance effort. The allocation allowed for two (2) disbursements of $250 per child in a kinship home. Because it is a one-time allocation, there currently is no future plan of a second TANF School Allowance allocation.
EA Application/Determination Corrective action plan: DFPS will ensure that INV/AR staff receive ongoing communication/training regarding EA and how to correctly document and record income within the IMPACT. DFPS will update the current EA policy and publishing a new resource guide for staff. DFPS staff will be provided training, tip sheets and ongoing support regarding the new policy and resource guide. The policy will be published by April 1, 2023. DFPS will continue to strengthen our internal quality assurance review of cases eligible for EA to ensure that INV/AR staff are complying with federal guidelines and internal policies. DFPS has submitted an IT ticket request to resolve the condition for the participant that had the incorrect income range of $0-$10,000 selected to the correct income range of $20,550 to $40,549 to align with the investigation report. The participant remains eligible for assistance regardless as the family unit makes less than $63,000. CPI will initiate a request for an IT project to conduct analysis of any limitations with verifying Emergency Assistance eligibility in the IMPACT system regarding why two of the three EA statements now show not answered. DFPS staff will be researching the issue to determine next steps by 2nd quarter FY 2024. Implementation date(s): Ongoing communication ? will vary, first communication by April 1, 2023; IMPACT research January 31, 2024. Responsible persons: Jerome Green PEAF Corrective action plan: DFPS uses an established recoupment process to address overpayments. A Kinship Development Worker writes a letter to the kinship caregiver regarding the overpayment and details the steps needed to return funds. This letter is also sent to accounting for follow up. DFPS maintains a proactive approach to strengthening/enhancing IMPACT limitations to ensure accurate data is maintained for accurate payments/disbursements through continuous program improvement. Implementation date(s): On January 13, 2023 ? staff initiated the above described recoupment process to recoup the second payment for the subject children. Responsible persons: Debbie Bouldin
2022-003 Reporting ? ACF-196R Expenditure Misclassifications Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Temporary Assistance for Needy Families (TANF) ALN: 93.558 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXTANF, 2201TXTAN3, 2101TXTANF, 2101TXTAN3, 2001TXTANF, 2001TXTAN3 October 1, 2021 ? September 30, 2022, October 1, 2020 ? September 30, 2021 and October 1, 2019 ? September 30, 2020 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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). Pursuant to 45 CFR 265.3(a)(1) each State must collect on a monthly basis, and file on a quarterly basis, the data specified in the TANF Data Report and the TANF Financial Report (or, as applicable, the Territorial Financial Report). More specifically, Form ACF-196R is used by States administering the Temporary Assistance for Needy Families (TANF) program to report quarterly expenditure data and to request quarterly grant funds. Condition: Audit procedures included testing of three quarterly ACF-196R reports. Three of the three reports reported Relative and Other Designated Caretaker (RODC) program costs incorrectly on line 19 as follows: ? Grant Year 2020 ACF-196R for the quarter-ended 9/30/2021 - $2,909 ? Grant Year 2021 ACF-196R for the quarter-ended 12/31/2021 - $175,862 ? Grant Year 2022 ACF-196R for the quarter-ended 3/31/2022 - $803,324 The purpose of the DFPS?s RODC program is promoting stability for children in the conservatorship of DFPS. It additionally provides financial assistance through a monthly payment to eligible kinship caregivers. Monthly reimbursement payments are time-limited and may be paid for up to twelve (12) months. However, if DFPS determines there is good cause for an exception, payments may be made for up to an additional six (6) months. As these benefits are short-term by nature, these costs should have been reported on line 15, Non-recurrent Short -Term Benefits. Questioned costs: None Context: See ?Condition.? Cause: Management misinterpreted the guidance provided for reporting specific activities on certain line items of the ACF-196R report. Effect: Failure to collect the accurate data could compromise the Office of Family Assistance (OFA) and the ACF?s ability to monitor TANF expenditures and compliance with statutory requirements. These data are also needed to estimate outlays and to prepare reports and budget submissions for Congress. Repeat Finding: No Recommendation: DFPS should revise its policies and procedures related to the ACF-196R report review process to ensure all expenditure amounts are being properly classified. Views of responsible officials: Management agrees with the finding.
Corrective action plan: DFPS will revise its policies and procedures related to the ACF-196R report review process to ensure all expenditure amounts are being properly classified. Implementation date(s): May 31, 2023 Responsible persons: Maura Flores
2022-004 Period of Performance Federal Agency: U.S. Department of Homeland Security Federal Program Title: Homeland Security Grant Program (HSGP) ALN: 97.067 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 3708603, 3902402, 4164001 3/1/2020 ? 630/2022, 4/1/2020 ? 5/31/2022, 9/1/2020 ? 2/28/2022 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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). Per 2 CFR 200.403(h) cost must be incurred during the approved budget period. The Federal awarding agency is authorized, at its discretion, to waive prior written approvals to carry forward unobligated balances to subsequent budget periods pursuant to ? 200.308(e)(3). Condition: The Office of the Texas Governor (OOG) is the prime recipient of federal awards for the Homeland Security Grant Program. The Department of Public Safety (DPS) receives allocations of these funds for individual projects. A Statement of Grant Award (SOGA) is issued by OOG to DPS for each project with start, end, and liquidation dates. For projects with period of performance ending dates during the fiscal year, as stipulated by OOG, audit procedures included testing transactions posted to the general ledger during the last month and after the period of performance end date. We noted the following instances of noncompliance: ? For the twelve sampled transactions, totaling $1,240,691, five of the expenditures, totaling $78,749, were related to costs incurred after the period of performance end date or liquidated after the liquidation period end date. Questioned costs: $78,749 Context: See ?Condition.? Cause: Current controls are not at the correct precision level to detect costs charged outside of the period of performance or paid after the liquidation date as specified in the project grant agreement. Effect: Ineffective internal controls may result in questioned costs and noncompliance with the terms of the grant. Repeat Finding: No Recommendation: DPS should enhance and/or modify existing controls (both manual and automated) to ensure that costs are not charged to a project unless (1) the service dates fall within the period of performance stated in the SOGA, and (2) the costs have been paid prior to the liquidation period end date. Views of responsible officials: The Department of Public Safety acknowledges and agrees with the findings. Through analysis of the exceptions identified in the audit, the Department of Public Safety will work to develop and implement corrective action to further improve the processes.
Corrective action plan: DPS will update the profile setup process in CAPPS to ensure the Service/Receipt Date Indicator box is checked in CAPPS on all profile setups relating to Grants. DPS Grants staff will receive training on how to fill out a Profile Setup Form to ensure the Service/Receipt Date Indicator Box is checked at the time the project is setup in CAPPS. The Grants staff will run a monthly report from CAPPS to see if all active projects have the service date indicator box checked. Implementation date(s): March 1, 2023 Responsible persons: Grants Manager, Deputy Administrator, Financial Reporting
2022-005 Reporting ? SF-425 Federal Financial Reports Federal Agency: U.S. Department of Homeland Security Federal Program Title: Homeland Security Grant Program (HSGP) ALN: 97.067 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 3834802, 3834803, 3865603, 3902402, 3912003, 3920803 1/1/2020 ? 2/28/2022, 3/1/2021 ? 5/31/2023, 3/1/2021 ? 5/31/2023, 4/1/2020 ? 5/31/2022, 3/1/2021 ? 5/31/2023, 3/1/2021 ? 5/31/2023 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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: Audit procedures included a sample of three SF-425 reports submitted during fiscal year 2022. For two of the three reports tested, DPS expenditures reported on the SF-425 did not agree to the general ledger. The following variances were identified: See Schedule of Findings and Questioned Costs for chart/table We noted that amounts reported on the SF-425 were accurate, however, the corresponding expenditures were not recorded on the general ledger. Management subsequently made corrections to its general ledger and schedule of expenditures of federal awards. Questioned costs: None Context: See ?Condition.? Cause: Expenditures not recorded in the general ledger were in-kind expenditures related to blade hours incurred and thus did not follow the normal accounts payable process. Management reconciled amounts reported on the SF-425 to federal revenues rather than federal expenditures. The discrepancies were not identified as internal controls were not designed properly. Effect: Improperly designed internal controls over reporting may result in a misstatement of amounts reported on the schedule of expenditures of federal awards or federal reports. Repeat Finding: No Recommendation: We recommend management revise its internal controls to reconcile expenditures reported on federal reports to federal expenditures in the general ledger rather than federal revenue to account for in-kind expenditures. Views of responsible officials: The Department of Public Safety acknowledges and agrees with the findings. Through analysis of the exceptions identified in the audit, the Department of Public Safety will work to develop and implement corrective action to further improve the processes.
Corrective action plan: DPS will ensure booking of year-end accruals for all outstanding expenses for the Homeland Security Grant Program according to the Financial Reporting Requirements established by the Comptroller of Public Accounts. Implementation date(s): September 1, 2023 Responsible persons: Grants Manager, Deputy Administrator, Financial Reporting
2022-006 Activities Allowed or Unallowed, Allowable Costs/ Cost Principles Federal Agency: U.S. Department of the Treasury Federal Program Title: Coronavirus State and Local Fiscal Recovery Funds ALN: 21.027 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2021-CS-21027 3/3/2021 ? 1/1/2023 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the nonFederal 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). In section 4 of the 2021 Texas Senate Bill 8, the Department of State Health Services (DSHS) was appropriated money received by Texas from the Coronavirus State Fiscal Recovery Fund for the following purposes related to costs incurred during the period beginning March 3, 2021 and ending January 1, 2023, due to the coronavirus pandemic: (1) Providing funding for surge staffing at state and local hospitals, long-term care facilities, psychiatric hospitals, and nursing facilities; (2) Purchasing therapeutic drugs, including drugs for monoclonal antibody treatments; and (3) Providing funding for the operation of regional infusion centers Condition: During our testing, we selected 60 expenditures, totaling $31,017,511, incurred during the fiscal year to validate allowability with the grant award. We noted that ten out of the 60 samples, totaling $648,086 were not for goods or services allowed by the grant award. Questioned costs: $648,086 Context: See ?Condition.? Cause: While unallowable expenditures may have been initially charged to the grant, DSHS planned to complete a final reconciliation at the close of the grant and return any unallowable costs. Effect: Unallowable costs charged to the grant may result in material noncompliance. Additionally, not maintaining accurate records throughout the year prohibits the federal granting agency to monitor the progress of the grant. Repeat Finding: No Recommendation: DSHS should enhance controls related to review of expenditures for compliance with allowable costs and activities unallowed requirements to ensure unallowed costs are not charged to the grant. Views of responsible officials: During the COVID-19 pandemic, there was a surge of COVID-19 cases in hospitals throughout the State of Texas and an immediate and emergent need to serve Texans. DSHS previously identified the need to ensure costs are allowable and align with required parameters. To strengthen requirements, DSHS will address through policy revision.
Corrective action plan: To strengthen requirements related to unique disaster funding, DSHS will amend DSHS Policy AA-3301: Monitoring and Management of the Operating Budget to establish roles and responsibilities for ensuring expenditures are reviewed and within grant parameters. We anticipate policy revisions to be drafted by July 31, 2023. Implementation date(s): July 31, 2023 Responsible persons: Chief Financial Officer
2022-007 Period of Performance Federal Agency: U.S. Department of the Treasury Federal Program Title: Coronavirus State and Local Fiscal Recovery Funds ALN: 21.027 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2021-CS-21027 3/3/2021 ? 1/1/2023 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the nonFederal 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). Per section 602(g)(1) of the Social Security Act as added by section 9901 of the American Rescue Plan Act of 2021, Pub. L. No. 117-2 and Treasury?s Interim Final Rule and Final Rule at 31 CFR section 35.5(a), State and Local Fiscal Recovery Funds (SLFRF) may only be used for costs incurred within a specific time period, beginning March 3, 2021, with all funds obligated by December 31, 2024 and all funds spent by December 31, 2026. Condition: The Department of State Health Service received a grant award for SLFRF funds on February 28, 2022. Audit procedures performed included a sample of ten transactions totaling $817,008 posted to the general ledger with service dates prior to April 2, 2021. For three samples, we noted expenditures totaling $348,874 that were incurred prior to March 3, 2021. Questioned costs: $348,874 Context: See ?Condition.? Cause: As the grant was awarded subsequent to the beginning of the period of performance, DSHS transferred expenditures previously paid for with state funds to the federal award based on the invoice date. However, the underlying services were partially incurred prior to March 3, 2021. Effect: Failure to review expenditures at a detail level could result in unallowable costs or expenditures claimed outside of the award?s period of performance. Repeat Finding: No Recommendation: We recommend DSHS add an additional process to review the underlying service dates for invoices near the beginning and end dates of the period of performance to ensure costs incurred outside of this period are not charged to the federal award. Views of responsible officials: During the COVID-19 pandemic, there was a surge of COVID-19 cases in hospitals throughout the State of Texas and an immediate and emergent need to serve Texans. DSHS previously identified the need to ensure costs are allowable and align with required parameters. To strengthen requirements, DSHS will address through policy revision.
Corrective action plan: To strengthen requirements related to unique disaster funding, DSHS will amend DSHS Policy AA-3301: Monitoring and Management of the Operating Budget to establish roles and responsibilities for ensuring expenditures are reviewed and within grant parameters. We anticipate policy revisions to be drafted by July 31, 2023. Implementation date(s): July 31, 2023 Responsible persons: Chief Financial Officer
2022-008 Reporting ? FFATA Subawards Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response ALN: 93.354 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: NU90TP922165, NU90TP922067 7/1/2021 ? 6/30/2023, 3/5/2020 ? 3/15/2023 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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). Under the requirements of the Federal Funding Accountability and Transparency Act (FFATA) (Pub. L. No. 109- 282), as amended by Section 6202 of Public Law 110-252, recipients (i.e., direct recipients) of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS) no later than the last day of the month following the month in which the subaward/subaward amendment obligation was made or the subcontract award/subcontract modification was made. Condition: In conjunction with the Finance Team within the Contract Management Section (CMS), the FFATA Coordinator coordinates the FFATA reporting process for all required submissions at the Department of State Health Services (DSHS). On a monthly basis, the DSHS FFATA Coordinator identifies FFATA subawards of $30,000 or more. Information for all relevant data elements is documented on the Data Validation Checklist and reviewed and approved by the FFATA Coordinator prior to being submitted to the CMS Finance Team to enter into FSRS by the end of the subsequent month. During our testing, we noted that there was no evidence of review on the Data Validation Checklist by the FFATA Coordinator for three of the four monthly submissions selected for testing during the fiscal year. Additionally, we noted the following instances of noncompliance: See Schedule of Findings and Questioned Costs for chart/table Questioned costs: None Context: See ?Condition.? Cause: Program personnel lack established internal controls and procedures over FFATA reporting to ensure the relevant subawards are submitted accurately and timely. Effect: Failure to verify FFATA submissions for completeness and accuracy may lead to inaccurate information being reported in FSRS. Repeat Finding: No Recommendation: DSHS should enhance FFATA policies and procedures including the current controls in place to formally document the verification FFATA reports for completeness and accuracy prior to submission. DSHS should also maintain all relevant documentation which supports the key data elements reported. Views of responsible officials: DSHS implemented a new procedure and a FFATA checklist to include controls and to formally document verification of FFATA reports for completeness and accuracy on March 1, 2022. The records reviewed under this audit were submitted prior to the implementation of the procedure and checklist. The Contract Management Section has fully implemented this recommendation and agree that this is a finding for FY22 based on the overlap in fiscal years and is based solely on timing.
Corrective action plan: DSHS will continue to utilize the updated procedure and FFATA checklist that was implemented on March 1, 2022 to ensure the verification of FFATA reports are formally documented prior to submission. DSHS will continue to maintain all relevant documentation to support that the key data elements were reported within the required timeframes. Implementation date(s): March 1, 2022 Responsible persons: FFATA Coordinator
2022-009 Activities Allowed or Unallowed, Allowable Costs/ Cost Principles, Eligibility, Matching, Level of Effort, and Earmarking, Reporting, Subrecipient Monitoring, Special Tests ? Information Technology ? Password Configuration Federal Agency: U.S. Department of Agriculture U.S. Department of Health and Human Services Federal Program Title: Medicaid Cluster Supplemental Nutrition Assistance Program (SNAP) Cluster Temporary Assistance for Needy Families (TANF) Coronavirus Relief Fund (nonmajor) Block Grants for Community Mental Health Services (nonmajor) Aging Cluster (nonmajor) Presidential Declared Disaster Assistance to Individuals and Households - Other Needs (nonmajor) Special Supplemental Nutrition Program for Women, Infants, and Children (WIC) (nonmajor) Social Services Block Grant (nonmajor) Children?s Health Insurance Program (CHIP) (nonmajor) Block Grants for Prevention and Treatment of Substance Abuse (nonmajor) Disability Insurance/SSI Cluster (nonmajor) Foster Care-Title IV-E (nonmajor) Adoption Assistance (nonmajor) Immunization Cooperative Agreements (nonmajor) ALN: 93.775, 93.777, 93.778 10.551, 10.561 93.558 21.019 (nonmajor) 93.958 (nonmajor) 93.044, 93.045, 93.053 (nonmajor) 97.050 (nonmajor) 10.557 (nonmajor) 93.667 (nonmajor) 93.767 (nonmajor) 93.959 (nonmajor) 96.001, 96.006 (nonmajor) 93.658 (nonmajor) 93.659 (nonmajor) 93.268 (nonmajor) Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Numbers and Periods: Medicaid Cluster 2105TX5ADM, 2105TX5MAP, 2105TXIMPL, 2105TXINCT, 2205TX5ADM, 2205TX5MAP, 2205TXIMPL, 2205TXINCT October 1, 2020 ? September 30, 2021 and October 1, 2021 ? September 30, 2022 SNAP Cluster 6TX400105, 6TX400106, 6TX400108, 6TX430165, 6TX430176, 6TX460001, 6TX460002 October 1, 2020 ? September 30, 2021, March 11, 2021 ? September 2021, October 1, 2020 ? September 30, 2022, October 1, 2021 ? September 30, 2022, October 1, 2021 ? September 30, 2023 TANF 2201TXTANF, 2201TXTAN3, 2101TXTANF, and 2101TXTAN3 October 1, 2021 ? September 30, 2022 and October 1, 2020 ? September 30, 2022 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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: The password management at HHSC is not consistently adhering to the password parameters as stated in the HHSC Information Security Policy. During our testing we noted the following deviations: ? TIERS: The password minimum age was set to 0 days. Per the HHSC Information Security Policy - Password Based Authentication, the minimum password age should be set to 1 day. Questioned costs: None Context: ?See Condition? Cause: HHSC did not have processes in place to enforce password policies as outlined in the HHSC Information Security Policy. Effect: Failure to following HHSC?s password policies increases the risk of inappropriate access. Repeat Finding: 2020-012, 2021-003 Recommendation: We recommend that HHSC update password configurations for TIERS to be compliant with its internal policies. Views of responsible officials: Agree
Corrective action plan: Texas Integrated Eligibility Redesign System (TIERS) - In order to bring password settings into compliance with the HHSC Information Security (IS) Security Policy, the TIERS Operations team released tool/method (113.0) successfully into production without any adverse impact. This release was completed on 09/24/2022 and contained the security requirements to restrict minimum allowed password changes from zero (unlimited) to one meaning users are allowed "only" one password change a day. This was verified by CliftonLarsonAllen LLP (CLA) auditors on 12/21/22. Screenshots were also provided to CLA auditors. Implementation date(s): September 24, 2022 Responsible Persons: Director, Information Technology (IT) Infrastructure Services
2021-003
2022-010 Activities Allowed or Unallowed, Allowable Costs/ Cost Principles ? Cost Allocation Plan Federal Agency: U.S. Department of Agriculture U.S. Department of Health and Human Services Federal Program Title: Medicaid Cluster Supplemental Nutrition Assistance Program (SNAP) Cluster Temporary Assistance for Needy Families (TANF) Aging Cluster (nonmajor) Block Grants for Community Mental Health Services (nonmajor) Special Supplemental Nutrition Program for Women, Infants, and Children (WIC) (nonmajor) Social Services Block Grant (nonmajor) Children?s Health Insurance Program (CHIP) (nonmajor) Block Grants for Prevention and Treatment of Substance Abuse (nonmajor) Disability Insurance/SSI Cluster (nonmajor) Money Follows the Person Rebalancing Demonstration (nonmajor) CCDF Cluster (nonmajor) Special Education-Grants for Infants and Families (nonmajor) ALN: 93.775, 93.777, 93.778 10.551, 10.561 93.558 93.044, 93.045, 93.053 (nonmajor) 93.958 (nonmajor) 10.557 (nonmajor) 93.667 (nonmajor) 93.767 (nonmajor) 93.959 (nonmajor) 96.001, 96.006 (nonmajor) 93.791 (nonmajor) 93.575, 93.596, 93.489 (nonmajor) 84.181 (nonmajor) Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: Medicaid Cluster 2105TX5ADM, 2105TX5MAP, 2105TXIMPL, 2105TXINCT, 2205TX5ADM, 2205TX5MAP, 2205TXIMPL, 2205TXINCT October 1, 2020 ? September 30, 2021 and October 1, 2021 ? September 30, 2022 SNAP Cluster 6TX400105, 6TX400106, 6TX400108, 6TX430165, 6TX430176, 6TX460001, 6TX460002 October 1, 2020 ? September 30, 2021, March 11, 2021 ? September 2021, October 1, 2020 ? September 30, 2022, October 1, 2021 ? September 30, 2022, October 1, 2021 ? September 30, 2023 TANF 2201TXTANF, 2201TXTAN3, 2101TXTANF, and 2101TXTAN3 October 1, 2021 ? September 30, 2022 and October 1, 2020 ? September 30, 2022 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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). Per 45 CFR Section 95.507, the State shall submit a cost allocation plan for the State agency to the Director, Division of Cost Allocation (DCA), in the appropriate HHS Regional Office. The plan shall describe the procedures used to identify, measure, and allocate all costs to each of the programs operated by the State agency. The cost allocation plan shall contain the procedures used to identify, measure, and allocate all costs to each benefitting program and activity. Per 45 CFR Section 95.509, the State shall promptly amend the cost allocation plan and submit the amended plan to the Director, DCA, if any of the following events occur, including if other changes occur which make the allocation basis or procedures in the approval cost allocation plan invalid. Condition: HHSC?s approved Public Assistance Cost Allocation Plan (PACAP) expenditures and revenues are initially allocated based on an estimate of Project ID percentages. After actual base statistical data is available, expenditures are reallocated and adjustments between estimated and actual costs are made. The adjustments will result in costs claimed for each period being allocated based on actual base statistics for the same period. Data is updated by voucher, either monthly, quarterly, semi-annually, or annually, depending on the Project ID. For 29 of 60 samples tested for proper reallocation of estimates, the project ID percentages as calculated by HHSC did not match the percentages in the reallocation entries that were posted in CAPPS, HHSC?s financial system. Questioned costs: Unknown Context: See ?Condition.? Cause: During the fiscal year, a formula error occurred that altered several links within multiple workbooks that changed reallocation percentages covering several months. Due to time and resource constraints, an outdated reallocation journal tool was utilized during the interim and verification reports were not being run after changes were made to the calculation spreadsheet to ensure reallocation percentages match. Effect: Failure to accurately calculate indirect costs may result in incorrect amounts being charged to the grant and noncompliance with grant terms and conditions. Repeat Finding: 2021-004, 2020-016, 2019-006, 2018-005, 2017-009, and 2016-024 Recommendation: HHSC should enhance existing reallocation procedures to include an additional review to ensure that the percentages in the entry made in CAPPS match the percentages in the calculation spreadsheet. Views of responsible officials: The Texas Health and Human Services Commission (HHSC) acknowledges and agrees with the finding. The issues are primarily associated with a non-automated process to compare entered calculations into Centralized Accounting and Payroll/Personnel System (CAPPS) Financials. These issues are the result of manual errors and formula errors.
Corrective action plan: The formula error was identified, corrected and reallocations are now correct. Also, the outdated reallocation journal tool is no longer used. The new journal reallocation tool includes edits to identify discrepancies before a reallocation journal is posted. As an additional verification step, which began with March 2022 reallocations, a new verification report (Fund Source Allocation Compare Report) is run that compares the date the factor was updated to the date the reallocation journal was entered to ensure no changes have been made to the factor. HHSC Accounting will work with Chief Financial Officer (CFO) Operation Support to establish an automated process to strengthen existing verifications. Implementation date(s): August, 31, 2023 Responsible persons: Director, Funds Management
2021-004
2022-011 Earmarking Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Temporary Assistance for Needy Families (TANF) ALN: 93.558 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXTANF, 2201TXTAN3, 2101TXTANF, and 2101TXTAN3 October 1, 2021 ? September 30, 2022 and October 1, 2020 ? September 30, 2022 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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). Pursuant to 45 CFR 264.1(a), (b), and (c): (a) (1) Subject to the exceptions in this section, no State may use any of its Federal TANF funds to provide assistance (as defined in ? 260.31 of this chapter) to a family that includes an adult head-of-household or a spouse of the head-of-household who has received Federal assistance for a total of five years (i.e., 60 cumulative months, whether or not consecutive). (2) The provision in paragraph (a)(1) of this section also applies to a family that includes a pregnant minor head-of-household, minor parent head-of-household, or spouse of such a head-of-household who has received Federal assistance for a total of five years. (3) Notwithstanding the provisions of paragraphs (a)(1) and (a)(2) of this section, a State may provide assistance under WtW, pursuant to section 403(a)(5) of the Act, to a family that is ineligible for TANF solely because it has reached the five-year time limit. (b) (1) States must not count toward the five-year limit: (i) Any month of receipt of assistance by an individual who is not the head-of-household or married to the head-of-household; (ii) Any month of receipt of assistance by an adult while living in Indian country (as defined in section 1151 of title 18, United States Code) or a Native Alaskan Village where at least 50 percent of the adults were not employed; and (iii) Any month for which an individual receives only noncash assistance provided under WtW, pursuant to section 403(a)(5) of the Act. (2) Only months of assistance that are paid for with Federal TANF funds (in whole or in part) count towards the five-year time limit. (c) States have the option to extend assistance paid for by Federal TANF funds beyond the five-year limit for up to 20 percent of the average monthly number of families receiving assistance during the fiscal year or the immediately preceding fiscal year, whichever the State elects. States are permitted to extend assistance to families only on the basis of: (1) Hardship, as defined by the State; or (2) The fact that the family includes someone who has been battered, or subject to extreme cruelty based on the fact that the individual has been subjected to: (i) Physical acts that resulted in, or threatened to result in, physical injury to the individual; (ii) Sexual abuse; (iii) Sexual activity involving a dependent child; (iv) Being forced as the caretaker relative of a dependent child to engage in nonconsensual sexual acts or activities; (v) Threats of, or attempts at, physical or sexual abuse; (vi) Mental abuse; or (vii) Neglect or deprivation of medical care. Condition: In order to monitor the earmarking requirement, the Health and Human Service Commission?s (HHSC) Data Analytics and Performance (DAP) Department maintains a tracking worksheet that is updated monthly, which contains relevant data derived from the TIERS benefit payment query and other source files. Key data used in the calculation include the following: ? Report month ? Number of clients who received their 60th monthly benefit payment in the report month ? Number of clients who received a hardship exemption in the report month ? Total number of clients receiving benefit payments as of the report month ? Total number of clients with a hardship exemption as of the report month The final monthly calculation takes the total number of clients with a hardship exemption as of the report month (i.e. those families that have received more than 60 months of benefit payments) divided by the total number of clients receiving benefit payments as of the report month. Audit procedures included a sample of five clients who received their 60th monthly benefit payment and a hardship exemption in a given month during the fiscal year. Individual monthly benefit payments noted per the results of the TIERS benefit payments query were compared to the TANF Time Limit screens which show each monthly benefit payment made. For all five sampled clients, there were discrepancies noted between the two data sets as to which months were counted as payments. Questioned costs: None Context: See ?Condition.? Cause: The TIERS benefit payment query is not configured to pull accurate data for purposes of monitoring the earmarking requirement. Effect: Inaccurate inputs used for monitoring earmarking requirements could result in noncompliance with federal requirements. Repeat Finding: No Recommendation: We recommend that HHSC update the parameters used in the TIERS benefit payment query to ensure it is pulling the accurate benefit payment fields in TIERS in order to assess compliance with earmarking requirements. Views of responsible officials: We agree with this finding and appreciate the audit team bringing this issue to our attention. This issue was discovered and communicated to us late in the audit process. As such, we have not had enough time to ensure we understand the root cause of the errors and have no assurance the cause lies in the query being used.
Corrective action plan: The Office of Data Analytics and Performance (DAP) will continue to work with IT - Social Services Applications (IT SSA) to determine the root cause of the errors. Once that has been established, corrective action will be implemented to correct that root cause. After corrections are made, DAP will continue to work with IT SSA to ensure the corrective action has eliminated the errors. Implementation date(s): August 31, 2024 Responsible persons: Director, Strategic Decision Support Director, DAP Aging & Disability
2022-012 Reporting ? ACF-196R Expenditure Misclassifications Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Temporary Assistance for Needy Families (TANF) ALN: 93.558 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXTANF, 2201TXTAN3, 2101TXTANF, and 2101TXTAN3 October 1, 2021 ? September 30, 2022 and October 1, 2020 ? September 30, 2022 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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). Pursuant to 45 CFR 265.3(a)(1) each State must collect on a monthly basis, and file on a quarterly basis, the data specified in the TANF Data Report and the TANF Financial Report (or, as applicable, the Territorial Financial Report). More specifically, Form ACF-196R is used by States administering the Temporary Assistance for Needy Families (TANF) program to report quarterly expenditure data and to request quarterly grant funds. Condition: Audit procedures included testing of three quarterly ACF-196R reports. Two of the three reports reported Early Childhood Intervention (ECI) expenditures incorrectly on line 22a as follows: ? Grant Year 2021 ACF-196R for the quarter-ended 12/31/2021 - $2,485,091 ? Grant Year 2022 ACF-196R for the quarter-ended 3/31/2022 - $1,625,367 The purpose of the HHSC?s ECI services program is to ensure that all eligible children under the age of three and their families receive quality early intervention services, resources and support needed to reach their developmental goals. Thus, these expenditures should have been reported on line 16, Supportive Services as they are supportive services and not administrative costs. Additionally, as the designated state agency of the TANF award, HHSC is responsible for verifying the accuracy of data submitted by other state agencies administering TANF funds. We noted HHSC included misclassified data as reported by other state agencies on three of the three quarterly ACF 196R reports submitted to the Administration for Children and Families (ACF). Questioned costs: None Context: See ?Condition.? Cause: Management misinterpreted the guidance provided for reporting specific activities on certain line items of the ACF-196R report. Additionally, management did not provide adequate training or guidance to ensure data submitted by other state agencies was accurate. Effect: Failure to collect the accurate data could compromise the Office of Family Assistance (OFA) and the ACF?s ability to monitor TANF expenditures and compliance with statutory requirements. These data are also needed to estimate outlays and to prepare reports and budget submissions for Congress. Repeat Finding: No Recommendation: HHSC should revise its policies and procedures related to the ACF-196R report review process to ensure all expenditure amounts are being properly classified. Additionally, we recommend HHSC provide adequate training and oversight and establish formal processes on preparing the ACF-196R report to other state agencies in order to ensure the information submitted to the ACF is accurate. Views of responsible officials: The Texas Health and Human Services Commission (HHSC) acknowledges and agrees with the finding. Through analysis of the exceptions identified in the audit, HHSC has developed and implemented corrective action to further improve the processes.
Corrective action plan: HHSC Accounting has implemented the reporting of Early Childhood Intervention (ECI) expenditures on Line 16 of the Administration for Children and Families (ACF) 196R. The HHSC Accounting policies and procedures related to the ACF 196R were revised and corrected for all open years. Implementation date(s): August 31, 2022 Responsible persons: Manager, State and Federal Reporting
2022-013 Reporting ? FFATA Subawards Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Temporary Assistance for Needy Families ALN: 93.558 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXTANF, 2201TXTAN3, 2101TXTANF, and 2101TXTAN3 October 1, 2021 ? September 30, 2022 and October 1, 2020 ? September 30, 2022 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Material Weakness in Internal Control over Compliance and Material Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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). Under the requirements of the Federal Funding Accountability and Transparency Act (FFATA) (Pub. L. No. 109- 282), as amended by Section 6202 of Public Law 110-252, recipients (i.e., direct recipients) of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS) no later than the last day of the month following the month in which the subaward/subaward amendment obligation was made or the subcontract award/subcontract modification was made. Condition: Per review of HHSC?s FFATA Reporting Policy, program departments must submit the FFATA Reporting Template to the Federal Funds Office (FFO) team by the 15th of the month to be included in that month?s agency submission. Program departments review the submission, as evidenced by the reviewer?s signature on the FFATA Reporting Template. The FFO team will collect FFATA Reporting Templates and submit the data to the FFATA Subaward Reporting System (FSRS) by the end of every month. During our testing, we noted that The FFATA Reporting Template was not completed for 14 of the 16 subawards selected. The remaining two templates were completed and signed by the reviewer but contained errors. Additionally, we noted the following instances of noncompliance: See Schedule of Findings and Questioned Costs for chart/table Questioned costs: None Context: See ?Condition.? Cause: HHSC experienced resource challenges during the fiscal year as well as challenges related to the transition of the FFATA reporting process to the FFO at the beginning of the fiscal year 2022, which caused subawards to not be identified and/ or reported in the FSRS. Additionally, controls related to the review of each subaward?s key elements are not at the precision level to detect inaccurate data. Effect: Failure to report all subawards $30,000 or greater in FSRS will result in noncompliance with terms of the federal grant guidelines. Additionally, failure to verify FFATA submissions for completeness and accuracy may lead to inaccurate information being reported in FSRS. Repeat Finding: No Recommendation: HHSC should establish processes to ensure that all subawards are identified and submitted in FSRS as required. Additionally, HHSC should enhance existing controls related to the verification of key elements prior to submission. Views of responsible officials: Accepted.
Corrective action plan: In December 2022, the Federal Funds Office (FFO) identified all prime awards with a potential subaward action date of 10/1/2021 or later. FFO is in the process of determining which of these have issued subawards for which no Federal Funding Accountability and Transparency Act (FFATA) reporting has been received from the program areas. In addition, FFO has revised the subaward reporting templates for programs. The goal of the revised templates is to 1) clearly state instructions for the information requested and 2) delineate between a) earlier subawards that are being reported late and b) subawards that fall into the current reporting period. These changes will assist FFO in maintaining current reporting and bringing all past due reporting up to date. The goal is to have all past due subawards from 10/1/2021 forward submitted to FFATA Subaward Reporting System (FSRS) by 12/31/2023. Implementation date(s): December 1, 2022 Responsible persons: Director, Federal Funds
2022-014 Special Tests and Provisions ? Provider Eligibility ? Lack of Documentation Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Medicaid Cluster ALN: 93.775, 93.777, 93.778 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2105TX5ADM, 2105TX5MAP, 2105TXIMPL, 2105TXINCT; 2205TX5ADM, 2205TX5MAP, 2205TXIMPL, 2205TXINCT October 1, 2020 ? September 30, 2021, October 1, 2021 ? September 30, 2022 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Material Weakness in Internal Control over Compliance and Material Noncompliance Criteria or specific requirement: Per 2 CFR 200.303, Health and Human Services Commission (HHSC) must establish and maintain effective internal controls over federal awards that provide reasonable assurance they are managing federal awards in compliance with federal statutes, regulations, and the provisions of contracts or grant agreements that could have a material effect on each of its federal programs. Per 2 CFR 200.334, financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. Federal awarding agencies and pass-through entities must not impose any other record retention requirements upon non-Federal entities. In order to comply with federal provider eligibility requirements, HHSC must adhere to various subsections of 42 CFR Section 455 including but not limited to: ? 455.104 ? HHSC must require that disclosing entities, fiscal agents, and managed care entities provide the following disclosures: ? The name and address of any person (individual or corporation) with an ownership or control interest in the disclosing entity, fiscal agent, or managed care entity. The address for corporate entities must include as applicable primary business address, every business location, and P.O. Box address. ? Date of birth and Social Security Number (in the case of an individual) ? Other tax identification number (in the case of a corporation) with an ownership or control interest in the disclosing entity (or fiscal agent or managed care entity) or in any subcontractor in which the disclosing entity (or fiscal agent or managed care entity) has a 5 percent or more interest. ? Whether the person (individual or corporation) with an ownership or control interest in the disclosing entity (or fiscal agent or managed care entity) is related to another person with ownership or control interest in the disclosing entity as a spouse, parent, child, or sibling; or whether the person (individual or corporation) with an ownership or control interest in any subcontractor in which the disclosing entity (or fiscal agent or managed care entity) has a 5 percent or more interest is related to another person with ownership or control interest in the disclosing entity as a spouse, parent, child, or sibling. ? The name of any other disclosing entity (or fiscal agent or managed care entity) in which an owner of the disclosing entity (or fiscal agent or managed care entity) has an ownership or control interest. ? The name, address, date of birth, and Social Security Number of any managing employee of the disclosing entity (or fiscal agent or managed care entity). ? 455.105 ? HHSC must enter into an agreement with each provider under which the provider agrees to furnish to it the following information related to business transactions within 35 days of request: ? The ownership of any subcontractor with whom the provider has had business transactions totaling more than $25,000 during the 12-month period ending on the date of the request; and ? Any significant business transactions between the provider and any wholly owned supplier, or between the provider and any subcontractor, during the 5-year period ending on the date of the request. ? 455.106 ? Before HHSC enters into or renews a provider agreement, or at any time upon written request by HHSC, the provider must disclose to HHSC the identity of any person who: ? Has ownership or control interest in the provider, or is an agent or managing employee of the provider; and ? Has been convicted of a criminal offense related to that person's involvement in any program under Medicare, Medicaid, or the title XX services program since the inception of those programs. ? 455.410 ? HHSC must require all ordering or referring physicians or other professionals providing services under the State plan or under a waiver of the plan to be enrolled as participating providers. ? 455.412 ? HHSC must: ? Have a method for verifying that any provider purporting to be licensed in accordance with the laws of any State is licensed by such State ? Confirm that the provider's license has not expired and that there are no current limitations on the provider's license ? 455.414 ? HHSC must revalidate the enrollment of all providers regardless of provider type at least every five years. ? 455.432 ? HHSC must: ? Conduct pre-enrollment and post-enrollment site visits of providers who are designated as ?moderate? or ?high? categorical risks to the Medicaid program. ? Require any enrolled provider to permit CMS, its agents, its designated contractors, or HHSC to conduct unannounced on-site inspections of any and all provider locations. ? 455.434 ? HHSC must: ? Require providers to consent to criminal background checks including fingerprinting when required to do so under State law or by the level of screening based on risk of fraud, waste or abuse as determined for that category of provider.? Establish categorical risk levels for providers and provider categories who pose an increased financial risk of fraud, waste or abuse to the Medicaid program. ? Upon HHSC determining that a provider, or a person with a 5 percent or more direct or indirect ownership interest in the provider, meets HHSC's criteria hereunder for criminal background checks as a ?high? risk to the Medicaid program, HHSC will require that each such provider or person submit fingerprints, in a form and manner to be determined by HHSC, within 30 days upon request from CMS or HHSC. ? 455.436 ? HHSC must confirm the identity and determine the exclusion status of providers and any person with an ownership or control interest or who is an agent or managing employee of the provider through routine checks of Federal databases. Upon enrollment and reenrollment, HHSC must check the Social Security Administration's Death Master File (SSADMF), the National Plan and Provider Enumeration System (NPPES), the List of Excluded Individuals/Entities (LEIE), the Excluded Parties List System (EPLS), and any such other databases as the Secretary may prescribe. During the period the provider is enrolled, HHSC must check the LEIE and EPLS no less frequently than monthly. ? 455.434 ? HHSC must screen all initial applications, including applications for a new practice location, and any applications received in response to a re-enrollment or revalidation of enrollment request based on a categorical risk level of ?limited,? ?moderate,? or ?high.? If a provider could fit within more than one risk level described in this section, the highest level of screening is applicable. Condition: Various departments within and contractors of HHSC are responsible for ensuring medical providers are properly licensed, screened, and enrolled in the Medicaid Program including Contract Administration and Provider Monitoring (CAPM), Access and Eligibility Services (AES), Procurement and Contracting Services, and the Texas Medicaid and Healthcare Partnership. Audit procedures included a review of 40 long-term care providers, which resulted in the following: ? For 11 samples, a copy of the completed Medicaid application was not included in the file. ? For 12 samples, enrollment of the provider was not completed within the last 5 years. ? For 20 samples, verification of the provider?s license was not included in the file. ? For 15 samples, required information on ownership and control was not disclosed. ? For 20 samples, supporting documentation was not included in the file indicating the SSADMF database was checked at the time of the most recent enrollment. ? For 16 samples, supporting documentation was not included in the file indicating the NPPES database was checked at the time of the most recent enrollment. ? For 11 samples, supporting documentation was not included in the file indicating the LEIE database was checked at the time of the most recent enrollment. ? For 14 samples, supporting documentation was not included in the file indicating the EPLS database was checked at the time of the most recent enrollment. ? For 20 samples, supporting documentation was not included in the file indicating the LEIE and EPLS databases were checked at least monthly during the enrollment period. ? For 20 samples, supporting documentation was not included in the file indicating the provider was categorized during screening as limited, moderate, or high risk. ? For 19 samples, a copy of the provider agreement was not included in the files. ? For 20 samples, supporting documentation was not included indicating a pre- or post-enrollment site visit was conducted as required for providers designated as moderate or high risk. ? For 11 samples, supporting documentation was not included indicating the provider disclosed the identity of any person who had been convicted of a criminal offense related to that person's involvement in any program under Medicare, Medicaid, or the Title XX services program since the inception of those programs. Questioned costs: NoneContext: See ?Condition.? Cause: HHSC does not have adequate procedures in place to ensure required documentation is obtained and maintained to comply with federal provider eligibility requirements. Effect: Failure to obtain and maintain adequate documentation during the provider screening and enrollment process may result in otherwise ineligible or fraudulent providers receiving Medicaid funds. Repeat Finding: 2021-008 Recommendation: HHSC should implement controls to ensure: ? Documentation is maintained for at least the length of the providers? current enrollment period or three years, whichever is greater in accordance with 2 CFR 200.334. ? Provider licenses are verified during enrollment. ? Providers are re-enrolled at least once every five years. ? Provider agreements are obtained, and the proper disclosures are made. ? Providers are categorized according to risk level and pre- and post-enrollment site visits are conducted as required for those deemed moderate or high risk. ? Relevant federal databases are checked during initial enrollment and at least monthly for all providers currently enrolled in Medicaid. Views of responsible officials: Agree.
Corrective action plan: In December 2021, HHSC implemented the Texas Medicaid & Healthcare Partnership (TMHP) Provider Enrollment Management System (PEMS), an automated system that is the single tool for provider enrollment, re-enrollment, revalidation, and maintenance requests (maintaining and updating provider enrollment record information). HHSC is confident that as the LTC providers are enrolled and re-validated through PEMS, the errors for documentation will be corrected. The LTC process will mirror the sampled acute care providers which were found to be 100 percent compliant during this review, further supporting that the process is working. Implementation date(s): December 2021 Responsible persons: Deputy Associate Commissioner, Operations Management
2021-008
2022-015 Special Tests and Provisions ? Medical Loss Ratio (MLR) ? Missing Data Elements Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Medicaid Cluster ALN: 93.775, 93.777, 93.778 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2105TX5ADM, 2105TX5MAP, 2105TXIMPL, 2105TXINCT; 2205TX5ADM, 2205TX5MAP, 2205TXIMPL, 2205TXINCT October 1, 2020 ? September 30, 2021, October 1, 2021 ? September 30, 2022 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: For all contracts, the state must ensure that each MCO, PIHP, and PAHP submits a report with the data elements specified in 42 CFR sections 438.8(k) and 438.8(n). The report should contain the required 13 data elements in the regulation, reflect the correct reporting years, and contain an attestation of accuracy regarding the calculation of the MLR. The state should have a policy and procedure to indicate when the report(s) are due from plans and should not accept multiple submissions from plans unless the capitation payments are revised retroactively. Per 2 CFR 200.303, Health and Human Services Commission (HHSC) must establish and maintain effective internal controls over federal awards that provide reasonable assurance they are managing federal awards in compliance with federal statutes, regulations, and the provisions of contracts or grant agreements that could have a material effect on each of its federal programs. Per 42 CFR section 438.8(k) - The State, through its contracts, must require each MCO, PIHP, or PAHP to submit a report to the State that includes at least the following information for each Medical Loss Ratio (MLR) reporting year: (i) Total incurred claims. (ii) Expenditures on quality improving activities. (iii) Fraud prevention activities as defined in paragraph (e)(4) of this section. (iv) Non-claims costs. (v) Premium revenue. (vi) Taxes, licensing and regulatory fees. (vii) Methodology(ies) for allocation of expenditures. (viii) Any credibility adjustment applied. (ix) The calculated MLR. (x) Any remittance owed to the State, if applicable. (xi) A comparison of the information reported in this paragraph with the audited financial report required under ? 438.3(m). (xii) A description of the aggregation method used under paragraph (i) of this section. (xiii) The number of member months. Condition: The Financial Reporting and Audit Coordination (FRAC) group at HHSC receives and reviews the MLR reports to verify the reports contain the required data elements. The MLR report template that is used by MCOs for this requirement is created and maintained by FRAC. Audit procedures included a review of six MLR reports submitted to FRAC during the fiscal year. Six of six (6) reports did not contain three of the thirteen required elements as follows: ? Methodology(ies) for allocation of expenditures ? A comparison of the information reported in this paragraph with the audited financial report required under ? 438.3(m). ? A description of the aggregation method used under paragraph (i) of this section Questioned costs: None Context: See ?Condition.? Cause: The current MLR report template provided to MCOs does not contain all thirteen (13) of the required data elements. Effect: Failure to obtain required information from MCOs pertinent to a federal award may result in noncompliance with grant terms and conditions. Repeat Finding: 2021-010 Recommendation: The FRAC should update the MLR report template to reflect all required elements as per 42 CFR 438.8(k). Views of responsible officials: HHSC agrees with the finding. It should be noted that the missing elements describe how the report was developed and do not impact the accuracy of the report or the Medical Loss Ratio (MLR) percentage.
Corrective action plan: HHSC ? Medicaid and CHIP Services - FRAC identified the missing requirements and updated the MLR report template and instructions in August 2022. Unfortunately, work was not completed in time for the Managed Care Organizations (MCO) to use the new template for reports submitted in August 2022. MCOs will use the new template with reports submitted in August 2023. Implementation date(s): Fully implemented August 2022. Responsible persons: Director, Medicaid and CHIP Services ? FRAC
2021-010
2022-016 Reporting ? FFATA Subawards Federal Agency: U.S. Department of Justice U.S. Department of Homeland Security Federal Program Title: Crime Victim Assistance Homeland Security Grant Program ALN: 16.575 97.067 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: Crime Victim Assistance 15POVC-21-GG-00600-ASSI, 2020-V2-GX-0004, 2019-V2-GX-0011, 2018-V2- GX-0040 10/1/2020 ? 9/30/2024, 10/1/2019 ? 9/30/2023, 10/1/2018 ? 9/30/2022, 10/1/2017 ? 9/30/2022 Homeland Security Grant Program EMW-2020-SS-00054, EMW-2021-SS-00062 9/1/2020 ? 8/31/2023, 9/1/2021 ? 8/31/2024 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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). Under the requirements of the Federal Funding Accountability and Transparency Act (FFATA) (Pub. L. No. 109- 282), as amended by Section 6202 of Public Law 110-252, recipients (i.e., direct recipients) of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS) no later than the last day of the month following the month in which the subaward/subaward amendment obligation was made or the subcontract award/subcontract modification was made. Condition: The Office of the Governor (OOG) uploads subaward information on a monthly basis via a batch upload to FSRS due to the volume of subawards in certain months. We noted the following instances of noncompliance for the Crime Victim Assistance Program, all of which were part of the May 2022 batch upload: See Schedule of Findings and Questioned Costs for chart/table We noted the following instances of noncompliance for the Homeland Security Grant Program, all of which were part of the May 2022 batch upload: See Schedule of Findings and Questioned Costs for chart/table The May 2022 batch included subawards granted in April 2022, however, were reported in FSRS on June 7, 2022. Questioned costs: None Context: See ?Condition.? Cause: The reports were not submitted timely due to staff turnover in OOG?s Public Safety Office. Effect: Failure to submit FFATA subawards timely may lead to noncompliance with federal requirements. Repeat Finding: No Recommendation: We recommend that management establish standard operating procedures in order to transition responsibilities in the event of staff turnover to ensure timely submission of required reports. Views of responsible officials: The Office of the Governor (OOG) management agrees with the finding that the May 2022 Federal Funding Accountability and Transparency Act (FFATA) report was submitted on June 7, 2022, which is 7 days after the May 31, 2022 due date.
Corrective action plan: The OOG?s Public Safety Office (PSO) Performance and Records Coordinator staff position, which is the position responsible for submitting the FFATA reports into the federal reporting system, was vacant at the time the May 2022 report was due. This position is now filled and PSO updated the written policy and procedure to include additional staff positions that will prepare the FFATA report in the event the Coordinator is unavailable. In addition, the FFATA policy has been updated to include dates by which certain steps in the process should be met. See excerpt from revised PSO Policy 5.40 FFATA: ?FFATA Reports are prepared by the Grants Administration Performance and Records Coordinator and will be reviewed by the appropriate Program Manager(s). The Grants Administration Director will review and approve reports prior to submission in the FFATA Subaward Reporting System (FSRS). In the event the Performance and Records Coordinator is not available to prepare the FFATA reports, either the Grants Administration Business Operations Specialist or the Grants Administration Compliance and Operations Administrator will prepare and route the reports for review. On or about the 5th day of the month in which the report is due, the Performance and Records Coordinator, or backup, will pull new award data and grant adjustment data from eGrants. On or about the 10th day of the month in which the report is due, the Records and Performance Coordinator, or backup, will route the report to the appropriate Program Manager(s) for review. On or about the 15th day of the month the report will be routed to the Grants Administration Director for review and approval. Monthly reports will be prepared and submitted at https://www.fsrs.gov/ no later than the last day of the current month for awards made during the prior month.? Implementation date(s): The vacant Performance and Records Coordinator position was filled in July 2022. The FFATA policy was updated February 3, 2023. Responsible persons: Zach Lohbauer, Performance and Records Coordinator Angie Martin, Director of Grants Administration
2022-017 Activities Allowed or Unallowed, Allowable Costs/ Cost Principles, Cash Management, Period of Performance, Suspension and Debarment ? Information Technology ? User Access Federal Agency: Environmental Protection Agency Federal Program Title: Drinking Water State Revolving Fund (DWSRF) Cluster ALN: 66.468, 66.483 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Numbers and Periods: 582-22-30745 9/1/2021 ? 8/31/2022 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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: The Texas Commission on Environmental Quality (TCEQ) utilizes the Budget Accounting and Monitoring System (BAMS) as its financial application for vendor disbursements and procurement. During our testing, we noted the following: ? We sampled seven terminated users to verify whether their access was removed in accordance with the TCEQ Access Control Policy (Policy). Four of the seven terminated users did not have their access to BAMS revoked in accordance with the Policy. Questioned Costs: None Context: ?See Condition? Cause: TCEQ did not follow the account management process as outlined in the TCEQ Access Control Policy. Effect: Failure to disable user accounts timely could increase the risk of inappropriate access. Repeat Finding: No Recommendation: We recommend TCEQ strengthen its internal controls to ensure terminated BAMS users? access is disabled and archived in accordance with its Access Control Policy. Views of responsible officials: The four IDs referenced in this finding did not have access to the BAMS application; the BAMS application is only accessible to agency staff with Oracle database user accounts. The report listing these IDs was from the application?s record of roles. Access to BAMS was terminated when the users? database accounts were removed.
Corrective action plan: The four IDs referenced in this finding did not have access to the BAMS application; the BAMS application is only accessible to agency staff with Oracle database user accounts. The report listing these IDs was from the application?s record of roles. Access to BAMS was terminated when the users? database accounts were removed. Implementation date(s): March 28, 2023 for refresher training to staff. CAPPS: September 1, 2023. Responsible Persons: Lynn Varian, Deputy Director of Information Resources Division
2022-018 Activities Allowed or Unallowed, Allowable Costs/ Cost Principles - Payroll Federal Agency: Environmental Protection Agency Federal Program Title: Drinking Water State Revolving Fund (DWSRF) Cluster ALN: 66.468, 66.483 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 582-22-30745 9/1/2021 ? 8/31/2022 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR 200.430 (i-vii), the Texas Commission on Environmental Quality must ensure that charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) be incorporated into the official records of the non-Federal entity; (iii) reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) encompass federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy; (v) comply with the established accounting policies and practices of the non-Federal entity; and (vii) support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition: During our testing, we selected 40 payroll-related expenditures incurred during the fiscal year totaling $134,012 to validate allowability and proper documentation of time and effort. We noted that for three out of the 40 samples, wages charged to the federal program were overstated by $27. Questioned costs: $27 Context: See ?Condition.? Cause: Hours incorrectly charged to the grant are a result of system and manual errors when allocating time to federal grants. Effect: Unallowable costs charged to the grant will result in noncompliance with the grant terms and questioned costs. Repeat Finding: No Recommendation: TCEQ should strengthen its controls related to review of payroll expenditures for compliance with federal time and effort requirements to ensure unallowed costs are not charged to the grant. Views of responsible officials: Federally funded and site-specific employees are required to record their time accurately and to charge to grants correctly. Supervisors are required to implement the quality control measures necessary to ensure that salaries and wages are based on records that accurately reflect the work performed.
Corrective action plan: TCEQ will provide refresher training to staff and supervisors and review its standard operating procedures to ensure that staff record time and charge to grants accurately, and that calculated allocations of staff time are accurate. The overall objective will be to ensure that salaries and wages are based on records that correctly reflect the work performed. Implementation date(s): March 1,2023 Responsible persons: Yolanda Davis, Deputy Director of Financial Administration Division
2022-019 Period of Performance Federal Agency: Environmental Protection Agency Federal Program Title: Drinking Water State Revolving Fund (DWSRF) Cluster ALN: 66.468, 66.483 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Numbers and Periods: 582-22-30745 9/1/2021 ? 8/31/2022 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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 testing of the Texas Commission on Environmental Quality?s (TCEQ) controls over the period of performance, we noted that the fiscal year 2022 grant ended on August 31, 2022. The closeout period for this grant ended on December 31, 2022, at which time all PCAs associated with that grant should have been closed in USAS in order to prevent costs being charged outside of the period of performance in accordance with TCEQ?s policies and procedures. However, we noted that PCAs were still open subsequent December 31, 2022. Questioned Costs: None Context: ?See Condition? Cause: TCEQ personnel misinterpreted policies and procedures in place over period of performance requirements. Effect: Failure to enforce internal controls over period of performance requirements may result in expenditures charged to the grant outside of the period of performance resulting in noncompliance and questioned costs. Repeat Finding: No Recommendation: We recommend TCEQ document its internal controls over period of performance requirements and clearly define roles and responsibilities within those policies. Additionally, we recommend TCEQ perform periodic reviews to verify that those controls are operating effectively. Views of responsible officials: The Federal Funds Section of the Budget and Planning Division maintains a Federal Funds Instruction Guide which outlines Close Out Items in Chapter 14. Those items are required when closing out a grant. This chapter does not specifically reference when Program Cost Accounts (PCAs) should be inactivated.
Corrective action plan: The Federal Funds Instruction Guide will be revised to require that PCAs associated with closed grants are inactivated by the end of the approved close-out period. Budget and Planning management will discuss the revised guidance with staff to ensure proper implementation. TCEQ will implement the Centralized Accounting and Payroll/Personnel System (CAPPS) in September of 2023; grant numbers will include beginning and ending dates at the time the grant is created and will not require inactivation. TCEQ will ensure thorough documentation of its internal controls and the associated staff roles and responsibilities and will conduct periodic reviews of its controls. Implementation date(s): April 11. 2023 for update of the Federal Funds Instruction Guide and training staff. CAPPS: September 1, 2023. Responsible Persons: TBD, Federal Funds Section Manager; Stephanie Robinson, Assistant Deputy Director of Budget and Planning Division; Jene Bearse, Deputy Director of Budget and Planning Division
2022-020 Cash Management, Eligibility, Special Tests and Provisions- Accountability for USDA Foods ? Information Technology ? Vendor Management Federal Agency: U.S. Department of Agriculture Federal Program Title: Food Distribution Cluster ALN: 10.565, 10.568, 10.569 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 6TX10877, 6TX810816, 6TX810817, 6TX810830, 6TX810821 October 1, 2020 ? September 30, 2021 and October 1, 2021 ? September 30, 2022. Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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: TDA utilizes TXUNPS, a web application that allows TDA personnel and subrecipients to submit and approve documents. TXUNPS manages information regarding subrecipient contracts, entitlement, inventory, orders and other Food Distribution Cluster (?FDC?) functions. Specific functions of TXUNPS include submitting and tracking commodity orders, viewing or declining commodity allocations, viewing invoices, and submitting and maintaining annual commodity contract packets and contract entitlements. TDA currently outsources the hosting, maintenance and enhancement over TXUNPS to a third-party service organization. TDA did not obtain assurance over the operating effectiveness of internal controls of these functions performed by the service organization for the fiscal period. Questioned costs: None Context: See "Condition" Cause: While management requested that the third-party vendor provide a Service Organization Controls 1 (?SOC 1?) Type 2 report that would validate the suitability of design and operating effectiveness of the vendor?s controls, a report had not been provided to TDA. Effect: Validating the internal controls over functions outsourced to a third-party vendor is critical to ensure that the service organization has the required controls infrastructure in place to process and secure TDA?s data. Repeat Finding: No Recommendation: TDA should obtain assurance over the operating effectiveness of internal controls of its third party service organizations for the fiscal period. This may be achieved by obtaining and reviewing SOC reports for each third-party vendor that provide services over critical applications within a timeline to allow TDA to evaluate whether they can rely on the third party?s overall control structure. In addition, TDA should review and test the complementary user entity controls included in each SOC report and document the results of those procedures. Views of responsible officials: TDA agrees with the finding.
Corrective action plan: TDA maintains an internal policy that requires SOC reports to be reviewed annually and document complementary user entity controls included in each SOC report. TDA?s contract with Colyar LLC requires the vendor to produce a SOC report annually. The vendor was late in providing the SOC report as a 2022 contract deliverable. TDA took actions to ensure vendor accountability for submitting the late contract deliverable and the vendor was required to complete a corrective action plan. TDA will review and assess the SOC report as soon as it is delivered by the vendor to ensure CLA?s recommendations can be followed and will consider additional procedures to ensure internal controls are assessed in the absence of a SOC report. Implementation date(s): June 2023 Responsible persons: Chief Information Officer and the Director for Food and Nutrition Program Support
2022-021 Activities Allowed or Unallowed, Allowable Costs/ Cost Principles, Cash Management, Eligibility, Earmarking, Period of Performance, Reporting, Subrecipient Monitoring, and Special Tests and Provisions ? Information Technology ? User Access Federal Agency: U.S. Department of Treasury U.S. Department of Health and Human Services Federal Program Title: Emergency Rental Assistance Program Low-Income Home Energy Assistance ALN: 21.023 93.558 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 1505-0266 ? 2021, 1505-0270 ? 2021 January 6, 2022?December 29, 2022 and May 5, 2021? September 30, 2025 2201TXLIEA ? 2022, 2101TXE5C6 ? 2021, 2101TXLWC5 2021 October 1, 2021 ?September 30, 2023, March 11, 2021 ?September 30, 2022, and May 5, 2021 ? September 30 2023 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR ?200.303(a), a non-Federal entity 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 testing of the Active Directory (Network) and CAPPS Financial, we noted the following: ? TDHCA did not perform a user access review service accounts for the Network. ? User access reviews for CAPPS Financials were not performed during the fiscal year. However, the review was completed subsequent to fiscal year end. Questioned Costs: None Cause: There were no policies established to address a periodic review of Network service accounts. Additionally, management planned to complete user access reviews of CAPPS Financial users, however, it was not until after the fiscal year end. Effect: Failure to perform user access reviews of service accounts could result in inappropriate access or inappropriate changes to the application. Additionally, failure to complete user access reviews on an annual basis may result in undetected inappropriate access to systems. Repeat Finding: 2021-013 Recommendation: We recommend management implement policies and procedures to complete user access reviews of Network service accounts and establish a policy to complete user access reviews of CAPPS Financial, at a minimum, on an annual basis each fiscal year. Views of responsible officials: Management acknowledges the recommendation and will update its current policies to better define terms and processes which will clarify its intent to document compliance.
Corrective action plan: Although the Department performed a partial review of service accounts during the review period and has current policies in place, a review and update of its policies will ensure the completeness and timeliness of future reviews and allow for improved documentation. Management intends to implement a list of all applicable systems to be reviewed, an associated scheduled timeline and allow for the documentation of its review and approval. SOP 1264.03 which is the policy that management intended to address the review of service accounts will be revised to better define the systems that are to be reviewed. In the SOP, the term ?System accounts? was intended to include all accounts not directly assigned to an employee, which are required for the functionality of TDHCA Information Technology (IT) systems. ?System accounts? could be used synonymously with the term ?Service accounts? and the agency will modify the policy to specifically refer to service accounts. Implementation date(s): August 2023 Responsible Persons: Director of Information Systems
2021-013
2022-022 Eligibility Federal Agency: U.S. Department of the Treasury Federal Program Title: Emergency Rental Assistance Program ALN: 21.023 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 1505-0266 ? 2021, 1505-0270 ? 2021. January 6, 2022 ? December 29, 2022 and May 5, 2021 ? September 30, 2025 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: According to Treasury?s Emergency Rental Assistance (ERA) Frequently Asked Questions (FAQs) Revised August 25, 2021, in ERA1, grantees must make reasonable efforts to obtain the cooperation of landlords and utility providers to accept payments from the ERA program. Outreach will be considered complete if (i) a request for participation is sent in writing, by mail, to the landlord or utility provider, and the addressee does not respond to the request within seven calendar days after mailing; (ii) the grantee has made at least three attempts by phone, text, or e-mail over a five calendar-day period to request the landlord or utility provider?s participation; or (iii) a landlord confirms in writing that the landlord does not wish to participate. The final outreach attempt or notice to the landlord must be documented. According to Treasury?s ERA Frequently Asked Questions (FAQs) Revised August 25, 2021, Grantees must obtain, if available, a current lease, signed by the applicant and the landlord or sublessor, that identifies the unit where the applicant resides and establishes the rental payment amount. If a household does not have a signed lease, documentation of residence may include evidence of paying utilities for the residential unit, an attestation by a landlord who can be identified as the verified owner or management agent of the unit, or other reasonable documentation as determined by the grantee. In the absence of a signed lease, evidence of the amount of a rental payment may include bank statements, check stubs, or other documentation that reasonably establishes a pattern of paying rent, a written attestation by a landlord who can be verified as the legitimate owner or management agent of the unit, or other reasonable documentation as defined by the grantee in its policies and procedures. According to the Texas Rent Relief Program Policies effective June 21, 2021, a household can request and receive rent assistance up to the total amount of monthly contracted rent listed on the lease. In the rare cases in which a tenant is applying without landlord cooperation, AND a lease does not exist, the tenant will be required to provide receipts for their 3 most recent rent payments in order to establish a pattern. According to Treasury?s ERA Frequently Asked Questions (FAQs) Revised August 25, 2021, all payments for utilities and home energy costs should be supported by a bill, invoice, or evidence of payment to the provider of the utility or home energy service. According to the Texas Rent Relief Program Policies Version I, Assistance payments for arrears and current month utilities will be based on actual bills. Condition: During our testing of 60 individual payments to program participants, we noted the following the following instances of noncompliance: ? The landlord outreach was not completed for two ERA 1 tenant payments, totaling $7,116. ? The monthly rent paid did not agree to the monthly rent on the lease for two tenant payments resulting in a total overpayment of $3,390. ? The monthly rent paid did not agree to the payment receipt for one tenant payment resulting in an overpayment of $900. ? The monthly rent paid did not agree to the tenant ledger for one tenant payment resulting in an overpayment of $6,739. ? The date and amount on the electricity bill for one tenant was not supported by adequate documentation as the bill was illegible. Total payment for electricity was $510. Questioned costs: $11,916 Context: See "Condition" Cause: Exceptions were due to management oversight. The processing vendor miscalculated the rental assistance. The reviewer neglected to complete and electronically sign the Landlord Application Review. Effect: Failure to accurately calculate and review rental assistance under the program may result in overpayments to tenants or payments to ineligible tenants. Repeat Finding: 2021-012 Recommendation: We recommend management to perform a thorough review of the documentation submitted to the Texas Rent Relief Program and pay according to the current lease or other verification of rental expense. Additionally, we recommend management ensure that appropriate documentation related to review of applications is maintained in the files. Views of responsible officials: Management agrees with the finding and recommendation
Corrective action plan: To prevent similar errors from occurring until program closure, TRR management shared these findings with the external application review vendor on January 26, 2023, reiterating the processes for reviewing and approving rental assistance according to all program policies and procedures and ensuring that appropriate documentation related to review of applications is maintained in the files. Eligibility errors are expected in all programs, and TRR has developed different processes to address errors when identified. For these particular cases, TRR management requested the vendor take corrective action for each case as applicable (e.g., by requesting a return of funds for overpayment or by requesting additional information from applicants). Implementation date(s): January 26, 2023 Responsible persons: Danny Shea, TRR Senior Program Manager
2021-012
2022-023 Reporting ? Monthly Compliance Reports Federal Agency: U.S. Department of the Treasury Federal Program Title: Emergency Rental Assistance Program ALN: 21.023 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 1505-0266 ? 2021, 1505-0270 ? 2021 January 6, 2022?December 29, 2022 and May 5, 2021? September 30, 2025 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: According to ?200.302 Financial management of 2 CFR Part 200, the nonFederal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Further, the financial management system of each non-Federal entity must provide accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements. Condition: The Texas Department of Housing and Community Affairs (TDHCA) is required to submit ERA 1 and ERA 2 Monthly Compliance Reports, which include the total number of participating households that receive ERA assistance of any kind, and the total amount of ERA funds expended by TDHCA to or for participating households on behalf of eligible households. During our testing of three ERA 1 and three ERA 2 Monthly Compliance Reports, we noted the following: ? TDHCA was unable to provide source data for the October 2021 ERA 1 Monthly Compliance Report. The reported total number of participating households that receive ERA assistance was 42,607 and total amount of ERA funds expended was $197,113,340. ? For the December 2021 ERA 1 Monthly Compliance Report, the number of unique households reported to the Treasury was 1,175. However, the number of unique households was 1,170 based on the supporting documentation provided. ? For the November 2021 ERA 2 Monthly Compliance Report, the number of unique households reported to the Treasury was 78,378. However, the number of unique households was 78,332 based on the supporting documentation provided. TDHCA is also required to submit quarterly reports with reporting periods of one calendar quarter and several cumulative fields covering all activity from the date of award through the quarter close. These reports provide financial and performance data regarding TDHCA?s administration of their ERA projects and capture program design in addition to program status data elements. Key line items include the cumulative amount obligated and the cumulative amount expended by TDHCA. During our testing of three quarterly ERA 1 reports and two quarterly ERA 2 reports, we noted that no support was provided to validate the cumulative obligations and expenditures to date. Questioned costs: None Context: See "Condition" Cause: While management maintained dashboards to support reported information, they did not maintain the underlying supporting documentation. Effect: Failure to accurately report information on federal reports inhibits Treasury?s ability to accurately calculate reallocations and capture other key information in order to assess the performance of the program. Repeat Finding: No Recommendation: We recommend management adopt policies and procedures to ensure supporting documentation for federal reports is maintained, including any reconciling calculations or adjustments to support information reported on the federal reports. Views of responsible officials: Management agrees with the finding and recommendation.
Corrective action plan: ? For Source Data, the program has developed policies and procedures to document source data. ? For Cumulative Calculations, auditors specifically requested from TDHCA reports submitted to the Treasury from different periods to specifically be able to calculate cumulative figures for obligations and expenditures. TDHCA explained that the methodology the Treasury has requested for grantees to use will not allow the quarterly obligations and expenditures reported to be summed to equal the current cumulative amount due to adjustments for recaptured funds. This is an unavoidable reality of the Emergency Rental Assistance (ERA) program and federal reporting system and can only be rectified in the final report to Treasury. Certain aspects of the Treasury?s design of the program, most significantly the recapture of funds from beneficiaries, can cause the draw/transaction data for a given period, e.g. Q3 2022, to change after that quarter is complete. Per Treasury guidance, TDHCA will be able to resubmit expenditure and obligation figures for each quarter in the final report. For the December 2021 ERA 1 Monthly Compliance Report and November 2021 ERA 2 Monthly Compliance Report, the total number of households served were off by 0.4% and 0.05% due to inadvertently including households who were initially served but later had all of the funds recaptured and therefore should have been excluded. TDHCA has updated internal procedures for calculating these reports to ensure these are excluded from future reports. Implementation date(s): Implemented as of February 8, 2023 Responsible persons: David Johnson, Project Manager ? Process Mgmt. /Data Analytics
2022-024 Reporting ? FFATA and Annual Report Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Low-Income Home Energy Assistance ALN: 93.568 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2201TXLIEA ? 2022, 2101TXE5C6 ? 2021, 2101TXLWC5 2021 October 1, 2021 ?September 30, 2023, March 11, 2021 ?September 30, 2022, and May 5, 2021 ? September 30, 2023 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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). 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 Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). The action is to be reported in FSRS no later than the last day of the month following the month in which the subaward/subaward amendment obligation was made or the subcontract award/subcontract modification was made. Pursuant to 45 CFR 96.82(a) each grantee which is a State or an insular area which receives an annual allotment of at least $200,000 shall submit to the Department, as part of its LIHEAP grant application, the data required by section 2605(c)(1)(G) of Public Law 97-35 (42 U.S.C. 8624(c)(1)(G)) for the 12-month period corresponding to the Federal fiscal year (October 1-September 30) preceding the fiscal year for which funds are requested. The data shall be reported separately for LIHEAP heating, cooling, crisis, and weatherization assistance. Condition: During our testing of special reporting for FFATA, we noted there is no review and approval process in place over the submitted reports to ensure accuracy and completeness. Additionally, we noted the following instances of noncompliance: See Schedule of Findings and Questioned Costs for chart/table TDHCA submits the Annual Report on Households Assisted by LIHEAP (Annual Report), which includes key lines items in Section 1 and 2 of the report. During our testing of Annual Report submitted for Federal Fiscal Year 2021, we noted several variances between the Annual Report and supporting detail provided. The following variances were noted during our testing: ? Section I - Line 2 - Heating (CARES Act funding only) - Variance of 8,937 ? Section I - Line 4 - Cooling - Variance of 48 ? Section I - Line 7a - Year Round - Variance of 17 ? Section I - Line 11 - Any type of LIHEAP assistance - Variance of 574 ? Section I - Line 12 - Any type of LIHEAP assistance (CARES Act funding only) - Variance of 22,858 ? Section I - Line 14 - Bill Payment Assistance - Variance of 48 ? Section I - Line 15 - Bill Payment Assistance (CARES Act funding only) - Variance of 22,267 ? Section IV - Line 7j - Emergency Furnace Repair & Assistance - Variance of (1,752) ? Section IV - Line 7k - Emergency Furnace Repair & Assistance (CARES Act funding only) - Variance of (457) ? Section IV - Line 8 - Weatherization - Variance of (715) ? Section IV - Line 9 - Weatherization (CARES Act funding only) - Variance of (56,821) Questioned costs: None Context: See "Condition" Cause: FFATA reporting exceptions were primarily due to management oversight. Specifically, to the subawards not reported, incorrect subawards were linked to the FAIN. As such FFATA reports for subaward obligations for those months were not submitted in FSRS. Variances in the Annual Report were due to manual errors in transferring data from TDHCA?s system reports to the Annual Report. Effect: Failure to report all subawards $30,000 or greater in FSRS will result in noncompliance with terms of the federal grant guidelines. Failure to verify FFATA submissions for completeness and accuracy may lead to inaccurate information being reported in FSRS. Additionally, reporting inaccurate information on other federal reports inhibits the federal agency?s ability to accurately capture key information in order to assess the performance of the program. Repeat Finding: No Recommendation: We recommend management implement a review and approval process to ensure accurate and complete information is submitted in FSRS and subaward information is reported timely. Additionally, we recommend management establish a review process to ensure information submitted on the Annual Report is complete and accurate. Views of responsible officials: Management concurs with the control deficiency.
Corrective action plan: ? For FFATA, Community Affairs Division (CAD) is currently updating Standard Operating Procedure (SOP) to include two review and approval processes that will take place prior to the submission in the FSFR system. The two additional review and approval process will be performed by the Team Lead, Laura White in CAD and Elizabeth Yevich, Director of Housing Resource Center (HRC). The two additional reviews will strengthen the process to ensure accurate and timely submission of monthly FFATA reporting. ? For Annual Financial Report, CAD is currently working with the Information System Division (IS) to correct issues identified in the data pulls to the summary sheets used for the submission of the Annual Report. CAD has identified that these issues emerged when federal funding sources began requesting data by individual grants. In order to address the identified issues, CAD and IS will continue to correct and test the data queries and formulas to ensure accurate reporting is achieved. Implementation date(s): ? For FFATA, March 2023 ? For Annual Financial Report, August 2023 Responsible persons: ? For FFATA, Director of Housing Resource Center and Team Leader of Community Affairs. ? For Annual Financial Report, Manager of Fiscal & Reporting and Team Leader of Community Affairs.
2022-025 Special Tests and Provisions Testing ? ERA Funds Reallocation Federal Agency: U.S. Department of the Treasury Federal Program Title: Emergency Rental Assistance Program ALN: 21.023 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 1505-0266 ? 2021 January 6, 2022 ? December 29, 2022 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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). According to Treasury?s ERA 1 Reallocation Guidance Updated March 30, 2022, Treasury will begin accepting requests from Grantees for reallocated funds, on a form to be published by Treasury, on October 15, 2021. As the ERA 1 statute requires, reallocated funds will only be available to Grantees that have obligated at least 65% of their own initial ERA 1 allocations. Each funding request will be required to indicate the amount requested and confirm the need for such funds in the Grantee?s jurisdiction. Condition: TDHCA submitted two allocation requests during fiscal year 2022. For 2 of 2 reallocation requests tested, the Department was unable to provide supporting documentation to validate the information that informed Treasury of the obligation amounts for the reallocation requests submitted on January 13, 2022, and June 10, 2022. Questioned costs: None Context: See "Condition" Cause: Failure to maintain adequate documentation was caused by management oversight. Effect: Failure to maintain adequate documentation to support submissions to the federal agency may result in inaccurate information being submitted inhibiting the federal agency from making make key decisions. Repeat Finding: Yes Recommendation: We recommend management adopt policies and procedures to ensure supporting documentation for federal submissions are maintained, including any reconciling calculations or adjustments to support information. Views of responsible officials: Management agrees with the finding and recommendation.
Corrective action plan: Program management adopted policies and procedures to ensure supporting documentation for federal submissions are maintained, including any reconciling calculations or adjustments to support information. Implementation date(s): Implemented as of February 8, 2023 Responsible persons: Mariana Salazar, Texas Rent Relief Director
2022-026 Activities Allowed or Unallowed, Allowable Costs/ Cost Principles, Eligibility, Reporting, Special Tests and Provisions ? Information Technology ? User Access Federal Agency: U.S. Department of Labor Federal Program Title: Unemployment Insurance ALN: 17.225 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Numbers and Periods: Unemployment Insurance UI-38249-22-55-A-48, UI-38008-22-60-A-48, UI-35972-21-60-A-48, UI-37309-22- 55-A-48, UI-37093-21-55-A-48, UI-37252-22-55-A-48, UI-35733-21-55-A-48, UI 34523-20-60-A-48, UI-34885-20-55-A-48, UI-35677-21-55-A-48, UI-34087-20- 55-A-48, UI-32628-19-55-A-48, UI-34744-20-55-A-48 January 1, 2022 ? March 31, 2024, January 1, 2022 ? September 30, 2023, January 1, 2021 ? September 30, 2022, October 1, 2021 ? September 30, 2022, September 1, 2021 ? August 31, 2023, October 1, 2021 ? December 31, 2024, October 1, 2020 ? September 30, 2021, January 1, 2020 ? September 30, 2021, April 1, 2020 ? June30, 2022, 2021 October 1, 2020 ? December 31, 2023, October 1, 2019 ? December 31, 2022, October 1, 2018 ? December 31, 2021, and October 1, 2018 ? June 30, 2023 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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: TWC is not consistently adhering to the guidelines for issuing and managing accounts to ensure security controls are in place, effective, and are not bypassed as stated in section 3.2.15 Account Management of the TWC Information Security Manual (ISM) dated September 24, 2021. During our testing we noted the following deviations: ? UI Benefits: An annual review of user access was not completed during the fiscal year. Additionally, we noted that two developers had the ability to promote code change into production. Questioned Costs: None Context: ?See Condition? Cause: TWC did not follow the account management process as outlined in the TWC Information Security Manual. Effect: Failure to perform an annual user access review could increase the risk of inappropriate access. Repeat Finding: No Recommendation: We recommend that TWC should perform annual review of user access to be compliant with its internal policies. Views of responsible officials: For the annual UI access review, TWC agrees we need to perform annual reviews of user access. In 2022, TWC shifted our annual access reviews from what was then a manual process, usually documented on paper, to an improved process embedded in our Peoplesoft HR system called Centralized Accounting and Payroll/Personnel System (CAPPS). The new CAPPS Systems Access Privileges Certification provides a centralized place to track pending and completed access reviews to TWC systems. Since this was the first year the new process was used, there was some confusion by reviewers, which we believe led to some incomplete reviews and lack of monitoring this effort to completion. TWC acknowledges that two IT staff inappropriately had system access to both make code changes and promote changes to production. Although business processes, assigned job duties and staffs? skill sets limited them to using only one role or the other, they did have both accesses assigned in the system. Both named employees are no longer with the agency.
Corrective action plan: For the annual UI access review, TWC will monitor the annual CAPPS Systems Access Privileges Certification in CAPPS to ensure timely completion. For the code developer/promoter system roles, IT will implement a new quarterly review of developer roles to ensure no staff member has both roles assigned to ensure separation of duties in the system roles. We are also looking at potential technical solutions that would automate and prevent staff being assigned certain roles based on separation of duties. Implementation date(s): February 28,2023 Responsible Persons: Heather Hall, CIO
2022-027 Reporting ? ACF-196R and ACF-204 Reports ? Inaccurate Reporting Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Temporary Assistance for Needy Families (TANF) ALN: 93.558 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2001TXTANF, 2101TXTANF and 2201TXTANF October 1, 2019 ? September 30, 2022, October 1, 2020 ? September 30, 2023, October 1, 2021 ? September 30, 2024, Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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). Pursuant to 45 CFR 265.3(a)(1) each State must collect on a monthly basis, and file on a quarterly basis, the data specified in the TANF Data Report and the TANF Financial Report (or, as applicable, the Territorial Financial Report). More specifically, Form ACF-196R is used by States administering the Temporary Assistance for Needy Families (TANF) program to report quarterly expenditure data and to request quarterly grant funds. Per 2 CFR 200.329(b) Reporting program performance, the Federal awarding agency must use OMB-approved common information collections, as applicable, when providing financial and performance reporting information. As appropriate and in accordance with above mentioned information collections, the Federal awarding agency must require the recipient to relate financial data and accomplishments to performance goals and objectives of the Federal award. Condition: Audit procedures over financial reports included testing of three quarterly ACF-196R reports. All three reports had expenditures incorrectly reported as follows: ? Grant Year 2020 ACF-196R for the quarter-ended 9/30/2021 Line 9b, Education and Training was understated by $987,108 Line 9c, Additional Work Activities was overstated by $5,079,845 Line 17, Services for Children and Youth was understated by $4,092,737 ? Grant Year 2021 ACF-196R for the quarter-ended 3/31/2022 Line 9b, Education and Training was understated by $716,670 Line 9c, Additional Work Activities was overstated by $4,555,850 Line 17, Services for Children and Youth was understated by $3,839,180 ? Grant Year 2022 ACF-196R for the quarter-ended 3/31/2022 Line 9b, Education and Training was overstated by $137,683 Line 9c, Additional Work Activities was overstated by $950,355 Line 17, Services for Children and Youth was understated by $1,088,038 Audit procedures over special reports included testing of the ACF-204, Annual Report including the Annual Report on State Maintenance-of-Effort Programs (OMB No. 0970-0248) for federal fiscal year 2021, which requires TWC to file an annual report containing information on the TANF program and the state?s MOE programs for that year, including strategies to implement the Family Violence Option, state diversion programs, and other program characteristics. Key line items include line 8 for the total number of families served under the program with MOE funds. We noted that this line was overstated by 9,784 families. Questioned costs: None Context: See ?Condition.? Cause: The ACF-196R and ACF-204 are populated from data retrieved through preset queries from CAPP and TWIST, respectively. Queries were written incorrectly and thus did not output accurate information. Effect: Failure to report accurate data on the ACF-196R could compromise the Office of Family Assistance (OFA) and the ACF?s ability to monitor TANF expenditures and compliance with statutory requirements. These data are also needed to estimate outlays and to prepare reports and budget submissions for Congress. Additionally, failure to report accurate data on the ACF-204 inhibits ACF?s ability to monitor the nature of State and Territory expenditures used to meet States and Territories MOE requirements. Repeat Finding: No Recommendation: TWC should perform a review of all queries used to retrieve data when populating the ACF 196R and ACF-204 reports to ensure accurate data is being outputted in accordance with the requirements of the respective reports. Views of responsible officials: The Texas Workforce Commission acknowledges and agrees with the findings. Through analysis of report criteria, the Texas Workforce Commission has developed and implemented corrective action to address this finding.
Corrective action plan: TWC has already reviewed all ACF-196R and ACF-204 Report queries and made the appropriate criteria modifications to appropriately reflect and report Agency activities. The query review and modifications were completed in October 2022, and subsequent Federal Financial Reports, for active TWC grants, were modified to reflect accurate cumulative activities. Implementation date(s): October 31, 2022 Responsible persons: Teri Goodwin, Financial Reporting Manager
2022-028 Reporting ? FFATA Subawards Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Child Care and Development Fund (CCDF) Cluster ALN: 93.489,93.575 and 93.596 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 2101TXCCDF and 2201TXCCDF October 1, 2020 ? September 30, 2023 and October 1, 2021 ? September 30, 2024 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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). Under the requirements of the Federal Funding Accountability and Transparency Act (FFATA) (Pub. L. No. 109- 282), as amended by Section 6202 of Public Law 110-252, recipients (i.e., direct recipients) of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS) no later than the last day of the month following the month in which the subaward/subaward amendment obligation was made or the subcontract award/subcontract modification was made. Condition: Per review of TWC?s FFATA reporting procedures, the FFATA reports are derived from a set of queries that captures all the subaward information during the respective month. The Financial Reporting supervisor periodically reviews queries to ensure continued accuracy of the data. The Financial Reporting Accountant runs the set of queries after the 25th of each month and creates a batch file to be uploaded to FSRS. We noted the following instances of noncompliance, all of which were part of the December 2021 batch upload: See Schedule of Findings and Questioned Costs for chart/table The December 2021 batch included subawards granted in September and October 2021, however, were reported in FSRS on December 28, 2021. Questioned costs: None Context: See ?Condition.? Cause: TWC failed to submit monthly FFATA reports timely due to management oversight. Effect: Failure to report all subawards $30,000 or greater in FSRS timely will result in noncompliance with terms of the federal grant guidelines. Repeat Finding: No Recommendation: TWC should establish processes to ensure that all subawards are identified and submitted in FSRS in a timely manner. Views of responsible officials: The Texas Workforce Commission acknowledges and agrees with the finding.
Corrective action plan: The Texas Workforce Commission will initiate a formal and documented review procedure to ensure that FFATA reports are submitted timely. Implementation date(s): March 1, 2023 Responsible persons: Teri Goodwin, Financial Reporting Manager
2022-029 Special Tests and Provisions ? Fraud Detection and Repayment Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Child Care Development Fund (CCDF) Cluster ALN: 93.489, 93.575, 93.596 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Numbers and Periods: 2201TXCCDF, 2201TXCCDD, 2101TXCCC5, 2101TXCSC6, 2101TXCDC6, 2101TXCCDF, 2001TXCCC3, 2001TXCCDF, 2001TXCCDM, 2001TXCCDD, 1901TXCCDD, 1901TXCCDM, 1901CCDF October 1, 2021 ? September 2024, December 27, 202 ? September 30, 2023, October 1, 2020 ? September 30, 2023, March 27, 2020 ? September 30, 2023, October 1, 2019 ? September 30, 2022, and October 1, 2018 ? September 30, 2021 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR section 200.303(a), a non-Federal entity 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). Per 45 CFR 98.60(i), Lead Agencies shall recover childcare payments that are the result of fraud. These payments shall be recovered from the party responsible for committing the fraud. Additionally, pursuant to TWC?s Childcare Services Guide (April 2022), section G.600: Recovery of Improper Payments, Local Workforce Development Boards (Boards) must attempt recovery of all improper payments. The Texas Workforce Commission (TWC) must not pay for improper payments. Board recovery of improper payments must be managed in accordance with TWC policies and procedures. Condition: When an improper payment is identified by a Board, the Board must issue a notice of determination (RID-58) that notifies the participant that they were found to be ineligible to receive assistance for the time period and amount in question as well as the reason for ineligibility. If the improper payment is caused by fraud, the Board issues a 1st collection letter (RID-64) to attempt to recoup the ineligible amount. If amounts are not collected or on an active payment plan, the Board issues a final collection letter (RID-65) and refers the participant to TWC for warrant hold, which will bar future services to the individual until the recoupment is collected. Letters issued by the Board are maintained in the Program Integrity Reporting Tracking System (PIRTS), the tool for Board use in reporting and tracking childcare fact-finding, fraud determinations, and recoupments. TWC monitors the Boards? compliance with the recovery of improper payments through its subrecipient monitoring procedures. However, we noted that TWC is not consistently adhering to the guidelines for monitoring the policies and procedures issued to the Boards. We noted the following exceptions in the 40 cases selected for testing: ? Determination letters were not maintained in PIRTS for nine of the 40 cases tested. ? 1st collection letters were not maintained in PIRTS for 12 of the 40 cases tested. ? Final collection letters were not maintained in PIRTS for 11 of the 40 cases tested. Improper payments for which the determination letter, 1st collection letter and/ or final collection letter were not retained totaled $79,339 of the total improper payments of $188,299 tested. Recoupment efforts were still in process for the cases noted above. Questioned costs: None Context: ?See Condition? Cause: Management is not adhering to the subrecipient monitoring procedures to ensure determination letters, 1st collection letters and final collection letters are obtained by the Boards and maintained in PIRTS. Effect: Failure to obtain documentation of collection efforts may result in improper payments not being recouped. Repeat Finding: No Recommendation: We recommend management implement a process to ensure subrecipient reviews follow its subrecipient monitoring policies to verify that Boards are maintaining the appropriate documentation in PIRTS as required by TWC?s Childcare Services Guide (April 2022). Views of responsible officials: The Texas Workforce Commission (TWC) acknowledges and agrees with the finding and concurs with the recommendation. The TWC?s Division of Fraud Deterrence and Compliance Monitoring?s Office of Investigation (FDCM/OI) oversees all matters related to fraud, waste, and abuse with respect to Federal programs the TWC passes to its subrecipients, primarily the 28 local workforce development boards (Board). This includes the subsidized childcare program provided for in the above-cited Federal awards. FDCM/OI has historically maintained rigorous internal controls to address fraud in all programs. However, during the COVID-19 pandemic, FDCM/OI was inundated with unprecedented ID fraud claims investigations associated to the CARES Act unemployment compensation (UC) programs. During the scope of this audit, the majority of FDCM/OI?s investigator resources were deployed to address UC ID fraud matters. FDCM/OI relied on the TWC?s Subrecipient Monitoring Department (SRM) to test Board compliance with respect to childcare improper payment reporting and recoupment. Historically, this is an area in which SRM monitors are not subject-matter experts. FDCM/OI is now in a position to devote more investigator resources to this area.
Corrective action plan: FDCM/OI investigators will review PIRTS reports on a regularly scheduled basis to ensure that Boards are uploading all required documentation related to childcare improper payments and taking collection efforts. The PIRTS system is in the process of being updated and is currently undergoing User Acceptance Testing. The updated system should allow for more robust reporting and controls. Additionally, FDCM/OI will provide more robust training and retraining to Boards that fall out of compliance. FDCM/OI will also develop an escalation policy in cases where Boards are not responsive to investigators? requests for status updates or document uploads into PIRTS. FDCM/OI investigators will ensure that SRM monitors are fully briefed on childcare improper payment cases at a Board as part of SRM?s annual monitoring review of the Board. Finally, FDCM/OI will ensure that all relevant controlling documents, e.g. Workforce Development Letter 21-16, Change 3 and its attached Child Care Fact-Finder?s Desk Aid; and the TWC?s Child Care Services Guide are updated to incorporate these new procedures. Implementation date(s): June 1, 2023 Responsible Persons: Jason Stalinsky, Deputy Division Director, Division of Fraud Deterrence and Compliance Monitoring
2022-101 Activities Allowed or Unallowed Allowable Costs/Cost Principles Reporting Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution, Cross-cutting Assistance Listing Number: 93.498, Cross-cutting Pass-Through Agency: N/A Pass-Through Number: N/A Award Number: Unavailable, Cross-cutting Award Period: July 1, 2020 to December 31, 2020, Cross-cutting Statistically Valid Sample: No and not intended to be a statistically valid sample Type of Finding: Significant Deficiency Questioned Costs: None Repeat Finding: No General Controls Institutions must establish and maintain effective internal control over federal awards that provides reasonable assurance that the institution is managing federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal award (Title 2, Code of Federal Regulations (CFR), Section 200.303(a)). The University of Texas M.D. Anderson Cancer Center (Cancer Center) did not appropriately restrict user access to certain information resources that it uses to manage federal awards. Specifically, the Cancer Center did not always promptly remove user accounts when an employee transferred to a new position or otherwise did not require access. The Cancer Center also did not consistently ensure that administrative access was limited to appropriate account types. The Cancer Center has policies in place to periodically review and modify user access to information resources, including upon an employee?s role change. However, the Cancer Center did not conduct effective user access reviews for all system levels to verify that access was appropriately restricted. After auditors brought these issues to the Cancer Center?s attention, it removed the inappropriate access. Allowing users inappropriate access to information resources increases the risk of unauthorized changes to those systems. In addition, the Cancer Center did not ensure that user access settings for all administrative accounts complied with policy requirements. The Cancer Center?s policies require certain settings to help restrict access for administrative accounts. However, auditors identified certain accounts that did not meet those requirements. Not ensuring that all settings meet minimum requirements increases the risk of data loss or tampering. Recommendations: The Cancer Center should: ? Appropriately limit user access to information resources and strengthen its user access review process for all system levels. ? Ensure that user access settings for administrative accounts align with policy requirements. Views of Responsible Officials: The Cancer Center acknowledges and agrees with the findings. Through analysis of the exceptions identified in the audit, the Cancer Center will work to develop and implement corrective action to mitigate further issues.
Corrective Action Plan: The Cancer Center will establish the following processes to enhance security procedures surrounding user access: ? IT personnel at the Cancer Center will review server admin groups on an annual basis per existing policies and procedures ? Annual reviews will coincide with the Cancer Center?s fiscal year start every September as part of our existing GRC reviews ? During the year, automated notifications will be setup to alert the proper IT teams when server admin group changes occur during the year that need to be reviewed prior to the annual review ? Outcomes from each annual review will be documented for historical reference as needed The finding concerning user access settings has been mitigated through the additional step to user profiles in the system. All admin group security access profiles are now in compliance with the Cancer Center?s policies. No additional steps are necessary to mitigate this finding. The team will continue to monitor per policy. Implementation Date: August 2023 Responsible Person: Craig Owen
Management decision deadline — for entities that funded this organization
The FAC accepted this audit on March 20, 2022. Under 2 CFR 200.521(d), a pass-through entity that provided federal funds to this organization for this audit period must issue a management decision on these findings by September 20, 2022, which was (1430 days ago).
What is a management decision? →2021 ? 001 Allowable Costs/Cost Principles ? Indirect Cost Reimbursements Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Epidemiology and Laboratory Capacity for Infectious Diseases ALN: 93.323 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: NU50CK000501 8/1/2019 ? 7/31/2024 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR ?200.303(a), a non-Federal entity 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: The Federal Funds Reporting Manager performs calculations throughout the fiscal year for indirect cost reimbursements based on approved federal rates. Once complete, a memo is sent to the Cash Management Branch Manager detailing the project codes, funding sources, and amounts to be processed and drawn for reimbursement. Audit procedures included a sample of seven indirect cost calculations. For one calculation, the supporting documentation contained a formula error that resulted in double counting certain costs. As a result, the agency had overdrawn $64,669 in indirect cost reimbursements as of the date of the calculation. For two samples, the agency was unable to provide supporting documentation of the calculation. Questioned costs: None. Cause: DSHS does not currently have a process in place to review the calculations for completeness and accuracy. Effect: The agency was reimbursed for $64,669 of costs in excess of what was allowed at the time of the calculation. Repeat Finding: No Recommendation: DSHS should implement a formally documented review process over the completeness and accuracy of the indirect cost reimbursement calculations. Views of responsible officials: DSHS acknowledges and agrees with the recommendation on the indirect cost drawn for ELC ALN 93.323. Through analysis of the exception identified in the audit, DSHS will work to develop and implement corrective action to further improve the process for review of the indirect cost calculations.
Corrective action plan: DSHS will implement process review enhancements in this area. DSHS will implement manager review processes for the Indirect Cost calculations before being submitted to Cash Management for the draw of indirect cost reimbursements. Implementation dates: March 2022 Responsible persons: Leslie Aguilar, Accounting Director
2021 ? 002 Reporting ? FFATA Subawards Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Epidemiology and Laboratory Capacity for Infectious Diseases ALN: 93.323 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: NU50CK000501 8/1/2019 ? 7/31/2024 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR ?200.303(a), a non-Federal entity 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). Under the requirements of the Federal Funding Accountability and Transparency Act (FFATA) (Pub. L. No. 109- 282), as amended by Section 6202 of Public Law 110-252, recipients (i.e., direct recipients) of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS) no later than the last day of the month following the month in which the subaward/subaward amendment obligation was made or the subcontract award/subcontract modification was made. Condition: In conjunction with the Finance Team within the Contract Management Section (CMS), the FFATA Coordinator coordinates the FFATA reporting process for all required submissions at the Department of State Health Services (DSHS). On a monthly basis, the DSHS FFATA Coordinator identifies FFATA subawards of $30,000 or more. Information for all relevant data elements is populated in an Excel template and submitted to the CMS Finance Team to enter into FSRS by the end of the subsequent month. Under the current process and for quality assurance purposes, the DSHS FFATA Coordinator must verify each FFATA report against each Excel spreadsheet and corrections are made if necessary. Audit procedures included a sample of two monthly FFATA submissions. For one of the two submissions, there was no evidence of verification of the data submitted in FSRS. Questioned costs: None. Cause: DSHS failed to maintain evidence of the verification of the data submitted in September 2020 in the FSRS. Effect: Failure to verify FFATA submissions for completeness and accuracy may lead to inaccurate information being reported in FSRS. Repeat Finding: No Recommendation: DSHS should enhance FFATA policies and procedures including the current controls in place to formally document the verification of FFATA reports for completeness and accuracy prior to submission. Views of responsible officials: DSHS agrees with this recommendation. Existing FFATA reporting procedures should be formalized and enhanced.
Corrective action plan: DSHS Contract Management Section has a process to ensure FFATA reports submitted every month are complete and accurate, however, it is not formally documented. DSHS Contract Management Section is currently developing a checklist between the FFATA Coordinator and the Contract Management Section Finance Team to document processes and controls established by each area to ensure complete and accurate reported data, to include a final signoff verifying review. Subsequently, the Contract Management Section will update existing procedures to incorporate the checklist by March 1, 2022. Implementation dates: March 1, 2022 Responsible persons: Patty Melchior, Director, Contract Management Section
2021 ? 003 Allowable Costs/ Cost Principles ? Information Technology ? Password Configuration Health and Human Services Commission / Department of Family and Protective Services/ Department of State Health Services Federal Agency: U.S. Department of Health and Human Services U.S. Department of Treasury U.S. Department of Homeland Security U.S. Department of Agriculture Social Security Administration Federal Program Title: Medicaid Cluster Coronavirus Relief Fund Block Grants for Community Mental Health Services Aging Cluster Presidential Declared Disaster Assistance to Individuals and Households - Other Needs Special Supplemental Nutrition Program for Women, Infants, and Children (WIC) (nonmajor) Social Services Block Grant (nonmajor) Children?s Health Insurance Program (CHIP) (nonmajor) Block Grants for Prevention and Treatment of Substance Abuse (nonmajor) Disability Insurance/SSI Cluster (nonmajor) Foster Care-Title IV-E (nonmajor) Adoption Assistance (nonmajor) Immunization Cooperative Agreements (nonmajor) ALN: 93.775, 93.777, 93.778 21.019 93.958 93.044, 93.045, 93.053 97.050 10.557 (nonmajor) 93.667 (nonmajor) 93.767 (nonmajor) 93.959 (nonmajor) 96.001, 96.006 (nonmajor) 93.658 (nonmajor) 93.659 (nonmajor) 93.268 (nonmajor) Pass-Through Agency: Office of the Governor (Coronavirus Relief Fund only) Pass-Through Number(s): N/A Award Numbers and Periods: Medicaid Cluster 2005TXINCT, 2005TX5MAP, 2005TX5ADM, 2005TXIMPL, 2105TX5021, 2105TX5ADM, 2105TX5MAP, 2105TXIMPL, 2105TXINCT 10/1/2019 ? 9/30/2020, 10/1/2020 ? 9/30/2021 Coronavirus Relief Fund 2020-CF-21019 4/15/2019-12/31/2021 Block Grants for Community Mental Health Services B09SM083830, B09SM083999, B09SM082632, B09SM010051 10/01/2020 ? 09/30/2022, 03/15/2021 ? 03/14/2023, 10/01/2019 ? 09/30/2021, 10/01/2018 ? 09/30/2020 Aging Cluster 1901TXOASS, 2001TXOASS, 2101TXOASS, 1901TXOACM, 2001TXOACM, 2101TXOACM, 1901TXOAHD, 2001TXOAHD, 2101TXOAHD, 1901TXOANS, 2001TXOANS, 2101TXOANS 10/01/2018-09/30/2021, 10/01/2019-09/30/2022, 10/01/2020-09/30/2022 Presidential Declared Disaster Assistance to Individuals and Households ? Other Needs FEMA-4586-DR-TX, FEMA-4454-DR-TX, FEMA-4466-DR-TX 02/19/2021-08/19/2022, 07/17/2019-01/17/2021, 10/4/2019-2/4/2021 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR ?200.303(a), a non-Federal entity 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: The password management at HHSC is not consistently adhering to the password parameters as stated in the HHSC Information Security Policy. During our testing we noted the following deviations: ? CAPPS FIN: The minimum password length was set to eight characters and the password history was set to five days. Since CAPPS FIN is defined as a high-risk system, per the HHSC Information Security Policy IA-05(01) Password Based Authentication, the minimum password length needs to meet or exceed 15 characters and password history of 12 days. Additionally, the password age is set to zero days. Per section 3.2.20 the minimum password age should be one day. The CAPPS FIN password length and history was updated on August 9, 2021 to be compliant with the HHSC Information Security Policy. ? RMS: The password minimum age was set to zero days. Per the HHSC Information Security Policy - Password Based Authentication, the minimum password age should be set to one day. ? TIERS: The password minimum age was set to zero days. Per the HHSC Information Security Policy - Password Based Authentication, the minimum password age should be set to one day. Questioned Costs: None. Cause: HHSC did not have processes in place to enforce password policies as outlined in the HHSC Information Security Policy. Effect: Failure to follow HHSC?s password policies increases the risk of inappropriate access. Repeat Finding: 2020 ? 012 Recommendation: We recommend that HHSC update password configurations for TIERS and RMS to be compliant with its internal policies. CAPPS FIN was updated on August 9, 2021. Views of responsible officials: Agree
Corrective action plan: CAPPS FIN - The CAPPS FIN team has implemented Password and other Security requirements as of August 9, 2021. To align with HHS IS Security Policy, the CAPPS FIN team has implemented the following: password setting has been changed from eight characters to 15 characters; extended password generations for password reuse has been changed from five to 12 generations; and the system will lock after three failed login attempts. RMS - In order to comply with the HHSC IS Security Policy, HHS has submitted a change request form to our RMS vendor, Interactive Voice Applications, Inc. requesting a password configuration change as of 11/2/2021. The change request was completed on 12/9/2021 and accepted by HHS on 12/16/2021. TIERS - In order to bring password settings into compliance with the HHSC IS Security Policy, TIERS Operations will work with the TIERS SSA Development team to replace the current IBM Security Access Manager (ISAM) tool with the IBM Security Identity Manager (ISIM) tool. This change will allow for password age customizations to be implemented by 1/31/2023. Milestone 1: The TIERS Social Services Applications (SSA) Development team will direct users to the ISIM tool instead of the ISAM tool. Development and testing will happen between (September ? December 2022) Milestone 2: ISIM password changes will be released into production by January 2023. Implementation dates: CAPPS FIN - 8/9/2021; RMS - 12/15/2021; TIERS - 1/31/2023 Responsible persons: Leatha Marr, Director, IT Application Services Jan Amazeen, Manager WM & RMS Unit Daniel Kellogg, Director, IT Infrastructure Services
2020-012
2021 ? 004 Allowable Costs/Cost Principles ? Cost Allocation Plan Federal Agency: U.S. Department of Health and Human Services U.S. Department of Agriculture U.S. Department of Education Social Security Administration Federal Program Title: Aging Cluster Medicaid Cluster Block Grants for Community Mental Health Services Social Services Block Grant (nonmajor) Children?s Health Insurance Program (CHIP) (nonmajor) Block Grants for Prevention and Treatment of Substance Abuse (nonmajor) Disability Insurance/SSI Cluster (nonmajor) Money Follows the Person Rebalancing Demonstration (nonmajor) TANF (nonmajor) CCDF Cluster (nonmajor) SNAP Cluster (nonmajor) Special Supplemental Nutrition Program for Women, Infants, and Children (WIC) (nonmajor) Special Education-Grants for Infants and Families (nonmajor) ALN: 93.044, 93.045, 93.053 93.775, 93.777, 93.778 93.958 93.667 (nonmajor) 93.767 (nonmajor) 93.959 (nonmajor) 96.001, 96.006 (nonmajor) 93.791 (nonmajor) 93.558 (nonmajor) 93.575, 93.596, 93.489 (nonmajor) 10.551, 10.561 (nonmajor) 10.557 (nonmajor) 84.181 (nonmajor) Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Numbers and Periods: Aging Cluster 1901TXOASS, 2001TXOASS, 2101TXOASS, 1901TXOACM, 2001TXOACM, 2101TXOACM, 1901TXOAHD, 2001TXOAHD, 2101TXOAHD, 1901TXOANS, 2001TXOANS, 2101TXOANS 10/01/2018-09/30/2021, 10/01/2019-09/30/2022, 10/01/2020-09/30/2022 Medicaid Cluster 2005TXINCT, 2005TX5MAP, 2005TX5ADM, 2005TXIMPL, 2105TX5021, 2105TX5ADM, 2105TX5MAP, 2105TXIMPL, 2105TXINCT 10/1/2019 ? 9/30/2020, 10/1/2020 ? 9/30/2021 Block Grants for Community Mental Health Services B09SM083830, B09SM083999, B09SM082632, B09SM010051 10/01/2020 ? 09/30/2022, 03/15/2021 ? 03/14/2023, 10/01/2019 ? 09/30/2021, 10/01/2018 ? 09/30/2020 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: with Per 2 CFR ?200.303(a), a non-Federal entity 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). Per 45 CFR ?95.507, the State shall submit a cost allocation plan for the State agency as required below to the Director, Division of Cost Allocation (DCA), in the appropriate HHS Regional Office. The plan shall describe the procedures used to identify, measure, and allocate all costs to each of the programs operated by the State agency. The cost allocation plan shall contain the procedures used to identify, measure, and allocate all costs to each benefitting program and activity. Per 45 CFR ?95.509, the State shall promptly amend the cost allocation plan and submit the amended plan to the Director, DCA, if any of the following events occur, including if other changes occur which make the allocation basis or procedures in the approval cost allocation plan invalid. HHSC?s approved Public Assistance Cost Allocation Plan (PACAP) expenditures and revenues are initially allocated based on an estimate of Project ID percentages. After actual base statistical data is available, expenditures are reallocated and adjustments between estimated and actual costs are made. The adjustments will result in costs claimed for each period being allocated based on actual base statistics for the same period. Data is updated either by voucher, monthly, quarterly, semi-annually, or annually, depending on the Project ID. Condition: During testing over the application of the 2021 PACAP, the following items were noted: ? The PACAP does not include all department codes that HHSC is using to charge items. For two of 60 samples tested, the departments were not included in the PACAP and could not be tied to an allocation method. ? For one of 60 samples tested for proper reallocation of estimates, the incorrect percentages were applied in the reallocation journal entry when adjusting costs to actual. Questioned costs: None. Cause: (1) Department IDs ? HHSC is not reviewing and updating its PACAP plan on a regular basis. (2) Reallocation entry ? Between the time the supporting calculations were prepared and the time the entries were made in the system, the percentages were altered and subsequently entered improperly. Effect: Failure to accurately record indirect costs may result in noncompliance with grant terms and conditions. Repeat Finding: 2020-016, 2019-006, 2018-005, 2017-009, and 2016-024 Recommendation: (1) HHSC should review and update the cost allocation plan to ensure that the PACAP accurately describes how costs will be allocated between the federal programs and the state. (2) HHSC should minimize the time between preparing the supporting calculations and entering into the system to ensure proper recording. Views of responsible officials: Bullet point one: HHSC acknowledges the findings. New Dept IDs are added to the PACAP based on whether a Dept ID is in use in the system of record (CAPPS-Fin) on the PACAP submission effective date. The ?missing? Dept IDs used service dates before the PACAP effective date. However, these Dept IDs were setup and had transactions processed after the PACAP effective date, and therefore showed up in the audit samples as missing from the PACAP. This is expected as a normal part of HHSC?s operations, since new Dept IDs may be setup and transactions may be processed against the new Dept IDs well after a cost has been accrued for a variety of reasons. HHSC will further improve communication about HHSC?s business operations to address this finding. Bullet point two: The Texas Health and Human Services Commission (HHSC) acknowledges and agree with the findings. Through analysis of the exceptions identified in the audit, HHSC will work to develop and implement corrective action to further improve the processes.
Corrective action plan: Bullet point one: The following information was added to the FY 2022 PACAP to help clarify HHSC?s business operations. ?HHSC must promptly revise its PACAP whenever the procedures described in the existing plan become outdated. This situation can occur as a result of changes to the State Plan for one of the public assistance programs, organizational changes, changes in program operations or when other changes occur which make the procedures in the approved PACAP invalid. It can also result from changes in Federal law or regulations affecting the validity of the approved cost allocation procedures, or when a material defect in the PACAP is disclosed by either the State or the Cost Allocation Services (CAS) (formerly the Division of Cost Allocation (DCA)).? - Section I, pg. 7. ?The information contained in Texas HHSC?s PACAP is based on information queried from HHSC?s system of record at a point in time; the effective date noted in this document. The estimates shown in the Fiscal Impact Statement are based on information that has been entered into the system of record as of the PACAP effective date.? - Section I, pg. 8 ?Department IDs included in the PACAP represent all non-client services and non- subrecipient budgets or expenditures in open state appropriation years (current state appropriation year and past two state appropriation years) as of the PACAP effective date.? - Section I, pg. 9. The following additional clarifying language will be added to the next PACAP submission to clarify why this happens as a normal part of HHSC?s operations. ?A new Dept ID may be charged for costs accrued before the PACAP effective date in accordance with the service date of the allowable good or service, and this could cause the Dept ID to appear to be missing from the PACAP when it was actually not in use by the effective date and therefore excluded from the submission. After completion of a PACAP submission, new Dept IDs are added to the next PACAP submission as a part of the normal course of HHSC?s business operations.? Bullet point two: Fund Accounting will work with CFO Operations Support to implement an automated post reallocation verification of factor percentages ensuring that the correct actual percentages are allocated on the journal and posted in CAPPS. Implementation dates: Bullet point one: 8/31/2022; Bullet point two: 8/31/2022 Responsible persons: Bullet point one: Racheal Kane, Federal Funds Director Bullet point two: Racheal Kane, Federal Funds Director and Derrick Payton, Fund Accounting Manager
2020-016
2021 ? 006 Subrecipient Monitoring ? Subaward Agreements Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Block Grants for Community Mental Health Services Social Services Block Grant (nonmajor) Block Grants for Prevention and Treatment of Substance Abuse (nonmajor) TANF (nonmajor) ALN: 93.958 93.667 (nonmajor) 93.959 (nonmajor) 93.558 (nonmajor) Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Numbers and Periods: Block Grants for Community Mental Health Services B09SM083830, B09SM083999, B09SM082632, B09SM010051 10/01/2020 ? 09/30/2022, 03/15/2021 ? 03/14/2023, 10/01/2019 ? 09/30/2021, 10/01/2018 ? 09/30/2020 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: The Behavioral Health Services Section coordinates the subrecipient monitoring process for the Mental Health Block Grant (MHBG) at the Health and Human Services Commission (HHSC). Per 2 CFR ?200.303(a), a non-Federal entity 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). Per 2 CFR ?200.331, all pass-through entities must ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the certain information at the time of the subaward and if any of these data elements change, include the changes in the subsequent award modification. Required information includes the indirect cost rate for the federal award (including if the de minimis rate is charged). In addition, the approved federally recognized indirect cost rate negotiated between the subrecipient and the federal government should be used, or, if no such rate exists, either a rate negotiated between the pass-through entity and the subrecipient (in compliance with this part), or a de minimis indirect cost rate. Condition: HHSC is not applying the correct indirect cost rates for federal awards per the regulations when the subrecipient has an existing federally recognized indirect cost rate. When the subrecipient does not have a federally recognized indirect cost rate, HHSC is negotiating methodologies for applying indirect costs rather than rates. These methodologies are only being validated through periodic onsite reviews. For nine of the nine contracts selected for testing for the Mental Health Block Grant, federally negotiated indirect cost rates had not been incorporated into the contracts. Questioned costs: None. Cause: HHSC continues to incorporate indirect cost rates into current contract, which is a multi-year process. Effect: Failure to incorporate indirect cost rates into executed contracts may lead to noncompliance with grant terms and conditions. Repeat Finding: 2020-021, 2018-012, 2017-021 Recommendation: HHSC should continue to apply federally negotiated indirect cost rates to subrecipient contracts who have a federally negotiated rate. For subrecipients who do not have a federally negotiated indirect cost rate, HHSC should work with the subrecipient to obtain an indirect cost rate or determine if the subrecipient is eligible for the de minimis 10% rate. Views of responsible officials: Accepted.
Corrective action plan: The Federal Funds Office Indirect Cost Rate Group continues to accept, negotiate, and acknowledge Indirect Cost rates for the Health and Human Services system cost reimbursement contracts. Once a rate is established, the contracting area incorporates the rate into the cost reimbursement contract. HHSC IDDBHS will incorporate approved indirect cost rates into cost reimbursement contracts. Implementation dates: 9/30/2022 Responsible persons: Ariana Torres, Manager, Federal Funds Office Indirect Cost Group Roderick Swan, Associate Commissioner, IDD-BH Contract Operations
2020-021
2021 ? 007 Reporting ? Submission of FFATA Subawards Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Block Grants for Community Mental Health Services ALN: 93.958 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Numbers and Periods: Block Grants for Community Mental Health Services B09SM083830, B09SM083999, B09SM082632, B09SM010051 10/01/2020 ? 09/30/2022, 03/15/2021 ? 03/14/2023, 10/01/2019 ? 09/30/2021, 10/01/2018 ? 09/30/2020 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: In conjunction with responsible program personnel, the Federal Funds Office (FFO) coordinates FFATA Reporting at the Health and Human Services Commission (HHSC). Per 2 CFR ?200.303(a), a non-Federal entity 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). Under the requirements of the Federal Funding Accountability and Transparency Act (Pub. L. No. 109-282), as amended by Section 6202 of Public Law 110-252, recipients (i.e., direct recipients) of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS) no later than the last day of the month following the month in which the subaward/subaward amendment obligation was made or the subcontract award/subcontract modification was made. Condition: During the fiscal year, a total of $139,476,688 was awarded and obligated to HHSC for the program. Additionally, $56,980,096 or 97% of total program expenditures were passed through to 61 subrecipients during the fiscal year. However, the agency did not submit any subawards of $30,000 or more in the FSRS throughout the year. Questioned costs: None. Cause: Program personnel lack established internal controls and procedures over FFATA reporting to ensure the relevant subawards are submitted accurately and timely. Effect: Failure to report all subawards $30,000 or greater in FSRS will result in noncompliance with terms of the federal grant guidelines. Repeat Finding: No Recommendation: Program personnel should implement policies and procedures related to FFATA Reporting to ensure the required subawards are being provided the Federal Funds Office when required in order to be submitted accurately and timely in FSRS. Views of responsible officials: Accepted.
Corrective action plan: Effective October 1, 2021, HHSC updated policies and procedures related to FFATA reporting to ensure the required subawards are submitted accurately and timely for all departments. Through the new process, Federal Funds Office (FFO) will collect and report the data provided from departments to FSRS. Implementation dates: 10/1/2021 Responsible persons: Ed Sinclair, Director, IDD-BH Business Operations HHSC Racheal Kane, Federal Funds Director, HHSC
2021 ? 012 Eligibility Federal Agency: U.S. Department of Treasury Federal Program Title: Emergency Rental Assistance Program ALN: 21.023 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 1505 ? 0266 01/06/2021 ? 12/31/2021 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Per 2 CFR ?200.303(a), a non-Federal entity 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: Under the ERA1 program, payment shall be used to provide financial assistance to eligible households, including the payment of (i) rent; (ii) rental arrears; (iii) utilities and home energy costs; (iv) utilities and home energy costs arrears; and (v) other expenses related to housing incurred due, directly or indirectly, to the novel corona virus disease (COVID-19) outbreak, as defined by the Secretary. According to the U.S. Department of the Treasury Emergency Rental Assistance Frequently Asked Questions Revised August 25, 2021, for ERA funds used for rent and rental arrears, grantees must obtain, if available, a current lease, signed by the applicant and the landlord or sublessor, that identifies the unit where the applicant resides and establishes the rental payment amount. According to the Texas Rent Relief Program Policies (Effective 04/21/21), eligible rent expenses can be verified through any of the following: ? Current lease, signed by both applicant and landlord/sublessor, ? Lease dates, monthly rent amount, and past due rent provided by the landlord in the landlord application, or ? Evidence of the three most recent payments of rent: bank statements or check stubs, or rent receipt from landlord. According to the Texas Rent Relief Program Policies Version I (03/29/21), an application for assistance is initiated by either a landlord or a tenant. Payment will not be made on behalf of an applicant until an applicant certification, landlord certification (if participating) and utility certification (if participating) have been received. A tenant Reviewer Checklist and Landlord Application Review, as applicable, are completed based on information in the Tenant Application, Landlord Application, as applicable, and documentation submitted to the Texas Rent Relief Program. Each checklist is electronically signed by the reviewer. During our testing of payments to participants, we noted the following: ? For one of the 60 payments (Tenant Case ID 527731), TDHCA made an overpayment of $144 to the landlord for rent assistance and rental arrears. The total payment was $4,356 for four months at $1,089 per month. However, the lease calls for a monthly amount of $1,053, resulting in an overpayment for each month of $36. ? For one of the 60 payments (Tenant Case ID 512404), the Landlord Application Review was not completed nor electronically signed. However, TDHCA made a payment to the landlord for rental assistance in the amount of $4,200. Questioned Costs: $144 Cause: Management oversight. The processing vendor miscalculated the rental assistance. The reviewer neglected to complete and electronically sign the Landlord Application Review. Effect: Failure to accurately calculate and review rental assistance under the program may result in overpayments to tenants or payments to ineligible tenants. Repeat Finding: No Recommendation: We recommend management to perform a thorough review of the documentation submitted to the Texas Rent Relief Program and pay according to the current lease or other verification of rental expense. We recommend management ensure that appropriate documentation related to review of applications is maintained in the files. Views of responsible officials: Management agrees with the finding and recommendation.
Corrective action plan: To prevent similar errors from occurring until program closure, TRR management shared these findings with the external application review vendor on February 10, 2022, reiterating the processes for reviewing and approving rental assistance according to all program policies and procedures and ensuring that appropriate documentation related to review of applications is maintained in the files. Implementation date: February 10, 2022 Responsible Persons: Danny Shea, TRR Senior Program Manager
2021 ? 013 Eligibility, Reporting ? Information Technology ? User Access, Change Management, and Vendor Management Federal Agency: U.S. Department of Treasury Federal Program Title: Emergency Rental Assistance Program ALN: 21.023 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: 1505 ? 0266 01/06/2021 ? 12/31/2021 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR ?200.303(a), a non-Federal entity 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: The Texas Department of Housing and Community Affairs (TDHCA) utilizes the following information technology (IT) applications for the administration of the Emergency Rental Assistance program: ? Active Directory (Network) ? This application is used to grant network access to TDHCA personnel. ? Neighborly ? This application is used host and process the agency?s program data. It is used to determine eligibility of program participants, verify that the payments to program participants fall within the program?s period of performance and extract data used to prepare reports necessary meet reporting requirements to the federal agency. THDCA utilizes a third-party consultant to manage its use of Neighborly and make eligibility and period of performance determinations. Users of this application include both TDHCA users and the third-party consultant. ? Bill.com ? This application is used to make payments to program participants that are deemed eligible. TDHCA utilizes the same third-party consultant as it does for Neighborly to make payments via Bill.com to eligible program participants. Users of this application include both TDHCA users and the third-party consultant. During our testing of the Network, Neighborly and Bill.com, we noted the following: ? User Access Reviews: TDHCA did not perform a periodic access review of users for the Network, which would include a review of privileged users? access. In addition, while the third-party consultant completed user access reviews of its users of Neighborly and Bill.com, TDHCA did not perform a periodic access review of the agency?s users of the two applications. We noted that management completed a user access review of TDHCA users of Neighborly and Bill.com subsequent to fiscal year end. ? Change Management: Requests for changes to Neighborly and Bill.com are processed through change management tickets that are submitted by the agency to the third-party consultant. The third-party consultant subsequently submits the change requests to Neighborly or Bill.com. Change tickets may include configuration changes, enhancements, etc. TDHCA did not maintain a centralized tracking of all change requests submitted during the fiscal year. As a result, we were unable to perform testing over change management. ? Vendor Management: TDHCA did not obtain assurance over the internal controls of Neighborly during the fiscal year. Questioned Costs: None. Cause: There were no policies established to address a periodic review of user accounts. Additionally, while management had a process in place to request and submit change tickets, there was no process in place to maintain a log of those requests. Furthermore, as Neighborly was a new system used in fiscal year 2021, management did not have processes in place to obtain assurance over its internal controls. Effect: Failure to perform user access reviews, track change management requests and obtain assurance over the internal controls of vendors hosting the agency?s data could result in inappropriate access or inappropriate changes to the application. Repeat Finding: No Recommendation: User Access: We recommend management implement policies and procedures to complete user access reviews of the Network, Neighborly and Bill.com periodically, but not less than once a fiscal year to ensure all user accounts are appropriate. Change Management: We recommend management maintain a log of change management requests for Neighborly and Bill.com and periodically review the log to verify that all requests were appropriate. Vendor Management: We recommend that management obtain assurance over Neighborly?s internal controls as it relates to hosting and processing the agency?s data. This can be completed through an internal review of their internal controls, periodic audits of its processes or obtaining a SOC 1 Type 2 or SOC 2 Type 2 report and reviewing any complementary user controls and applicable findings. Views of responsible officials: Management agrees with the finding and recommendation
Corrective action plan: ? User Access: TDHCA management implemented a Neighborly and Bill.com User Access Policy & Procedures December 17, 2021 that applies to TDHCA and all vendor users, which requires TDHCA management to complete user access reviews on a quarterly basis and requires all vendors to conduct regular audits of the user log to ensure unauthorized users do not have access to systems. The policy requires deprovisioning of a user within 24 hours of the user leaving the project. TDHCA management completed a user access review in January 2022. TDHCA Information Systems staff is in the process of updating all policies, processes and procedures related to user access reviews of the Network and have completed a user access review on February 3, 2022. ? Change Management: TDHCA will implement and maintain a centralized tracking of all change requests to Neighborly and Bill.com. ? Vendor Management: TDHCA has received and reviewed a Neighborly SOC 1 Type report and requested assurance over the internal controls of Neighborly in the form of a SOC 1 Type 2 report. TDHCA is anticipating the report in the coming months. TDHCA will review the SOC 2 Type report 2 once received using a review checklist developed with criteria from ISACA. Implementation date: ? For User Access, we will continue to follow Neighborly and Bill.com User Access Policy & Procedures. Updated policies, processes and procedures related to user access reviews of the Network will be implemented by March 31, 2022. ? For Change Management, we will implement a new tracking system by March 31, 2022 to be used from that point forward until program closure. ? For Vendor Management, review of the Neighborly SOC 1 Type 2 report will be completed within 30 days of receipt of the report. Responsible Persons: ? User Access: Monica McCarthy, Texas Rent Relief Project Manager; Larry Mercadel, Director of Information Systems ? For Change Management, Monica McCarthy, Texas Rent Relief Project Manager ? For Vendor Management, DeAnn Kiser, Texas Rent Relief Financial Reporting Manager
2021 ? 014 Reporting- Internal Control Finding Federal Agency: U.S. Department of Education Federal Program Title: Education Stabilization Fund ALN: 84.425 Pass-Through Agency: Office of the Governor (OOG) Pass-Through Number(s): N/A Award Number and Periods: 2020-GE-84425C 07/01/2020 ? 08/31/2021, 09/01/2020 ? 06/30/2022, 06/01/2021 ? 06/30/2022 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR ?200.303(a), a non-Federal entity 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). Per 2 CFR ?200.334 Retention requirements for records, Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. Federal awarding agencies and pass-through entities must not impose any other record retention requirements upon non-Federal entities. Condition: THECB is required to submit quarterly Progress Reports to its pass-through entity for each of its Governor?s Emergency Education Relief Fund (GEER) awards. Information is compiled from THECB?s Business Management System (BMS), and submission is completed through the pass-through entity?s eGrants system wherein THECB enters the data and submits directly via eGrants. Of the 12 Progress Reports submitted in fiscal year 2021, management was unable to provide supporting documentation from BMS for nine of the reports. Additionally, we noted that all 12 reports were prepared, reviewed and submitted in eGrants by the same individual. Questioned Costs: None. Cause: Management was unable provide copies of the data from BMS used to prepare the Progress Reports from the inception of the grant through June 2021. Information could not be recreated from BMS and management did not maintain copies of the supporting documentation for that time period. Additionally, due to the restrictions on the number of users allowed in eGrants only certain management personnel had access to submit reports during the fiscal year. Furthermore, due to the complexity of the new reporting requirements, management did not delegate the responsibilities over the preparation of the reports to accounting and finance staff. That responsibility remained with management, which significantly decreased the number of individuals that had the knowledge to prepare and review the report and access to submit the report. Effect: Lack of supporting documentation or appropriate segregation of duties in the preparation, review and submission of Progress Reports could result in inaccurate information to the pass-through entity. Repeat Finding: No Recommendation: We recommend that management retain information used to prepare the Progress Reports until the retention period for records has expired. Furthermore, we recommend that management separate the duties of preparing, and reviewing/submitting the Progress Reports to reduce the risk of inaccurate information submitted to the pass-through entity. Views of responsible officials: Management agrees with the auditor?s recommendation to develop (and strengthen existing) procedures for all federal performance measures, including retention of documentation of reports submitted.
Corrective action plan: Data is downloaded from BMS quarterly into an Excel file. This data is then filtered to generate the appropriate report information. Reporting for the progress report is retained by saving the Excel file on a network drive where all GEER related administrative files are to be saved. The agency will hire a federal grant accountant and change access to the eGrants system from the Project Lead to this position to enter data and the CFO will review the reports prior to submission. Implementation date: July 1, 2021: October 2021 progress report containing July-September 2021 data. Estimated March 2022 to hire a new position to perform reporting function. Responsible Persons: Ken Martin, Chief Financial Officer
2021 ? 015 Subrecipient Monitoring Federal Agency: U.S. Department of Education Federal Program Title: Education Stabilization Fund ALN: 84.425 Pass-Through Agency: Office of the Governor (OOG) Pass-Through Number(s): N/A Award Number and Periods: 2020-GE-84425C 07/01/2020 ? 08/31/2021, 09/01/2020 ? 06/30/2022, 06/01/2021 ? 06/30/2022 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: All pass-through entities must communicate each of the required elements in 2 CFR ?200.332 within their subaward agreements. Required information includes 1) Federal award identification which includes the Federal Award Date of award to the recipient by the Federal agency and Federal Award Identification Number (FAIN). Condition: THECB obtains signed subaward agreements from all subrecipients to communicate and acknowledge the subrecipient?s understanding of the terms and conditions of the grant. For 17 of the subrecipients tested, seven subaward agreements between THECB and the subrecipient did not include the federal award dates or identification numbers. In fiscal year 2021, THECB passed through approximately 93% of GEER funds to subrecipients. Questioned Costs: None. Cause: Management did not have internal controls in place to ensure a review of subaward agreements was taking place to verify that all required elements per 2 CFR 200 ?200.332 were included. Effect: Providing incomplete information to subrecipients may result in inaccurate reporting by the subrecipients and ultimately by THECB. Repeat Finding: No Recommendation: We recommend management establish policies to require a review of all subaward agreements to ensure that all pass-through agreements from THECB include each of the required elements by 2 CFR ?200.332. Views of responsible officials: Management agrees with the auditor?s recommendation to develop (and strengthen existing) policies to require a review of all subaward agreements to ensure that all pass-through agreements from THECB include each of the required elements by 2 CFR ?200.332.
Corrective action plan: In October 2021, THECB revised its federal templates to ensure all required coding, including the federal award dates or identification numbers, appeared on the contracts. Also, THECB added the missing award numbers and identification numbers upon amendment when possible. THECB staff has communicated the need to ensure complete federal award information across the Office of General Counsel staff responsible for final review of federal awards. Implementation date: October 2021 Responsible Persons: Linda Natal, Director Contracts and Procurements
2021 ? 016 Allowable Costs/ Cost Principles ? Information Technology ? Password Management Federal Agency: U.S. Department of Labor U.S. Department of Homeland Security U.S. Department of Education Federal Program Title: Unemployment Insurance Workforce Innovation and Opportunity Act Cluster (WIOA Cluster) Presidential Declared Disaster Assistance to Individuals and Households ? Other Needs Rehabilitation Services - Vocational Rehabilitation Grants to States ALN: 17.225 17.258, 17.259, 17.278 97.050 84.126 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Numbers and Periods: Unemployment Insurance Various Various WIOA Cluster 4485DRTXSPLW 07/25/2020 ? 03/27/2022 Presidential Declared Disaster Assistance to Individuals and Households H126A210092 10/01/2020 ? 09/30/2021 Rehabilitation Services - Vocational Rehabilitation Grants to States AA-32205-18-A-48, AA-32258-19-A-48, AA-34797-20-55-A-48 04/01/2018 ? 06/30/2021, 04/01/2019 ? 06/30/2022, 04/01/2020 ? 06/30/2023 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR ?200.303(a), a non-Federal entity 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: The password management at TWC is not consistently adhering to the password parameters as stated in section 3.2.20 Identification and Authentication of the TWC Information Security Manual (ISM) dated August 30, 2021. During our testing we noted the following deviations: ? Network: The Network password configuration for TWC minimum password age does not align with the TWC password policy. ? Rehab Works, UI Benefits, UI Tax, and the Cash Draw and Monthly Expenditure Report (CDER): The password settings do not align with the TWC password policy. ? TWIST: The password settings do not align with the TWC password policy. A security exception was granted for TWIST for the period August 5, 2021, through December 31, 2021, regarding not being in compliance with TWC?s password management policy. Questioned Costs: None. Cause: TWC did not have processes in place to enforce password policies as outlined in the TWC Information Security Manual. Effect: Failure to follow TWC?s password policies could increase the risk of inappropriate access. Repeat Finding: 2020 ? 034 Recommendation: We recommend that TWC should update password configurations for their Network, Rehab Works, UI Benefits, UI Tax, CDER, and TWIST to be compliant with its internal policies. Views of responsible officials: The Agency acknowledges and agrees with the finding. The Agency has determined that the network and these systems (Rehab Works, TWIST and RACF (including UI Benefits, UI Tax, and CDER), will need a password policy exception following the process outlined in the TWC ISM for exceptions. These systems are in the process of being replaced.
Corrective action plan: The Agency will process password policy exceptions to the TWC ISM for the network, as well as the following applications which are in the process of being replaced: Rehab Works, TWIST and RACF (UI Benefits, UI Tax, and CDER). Implementation date: February 28, 2022 Responsible Persons: Heather Hall , Chief Information Officer
2020-034
2021 ? 017 Allowable Costs/ Cost Principles ? MEUC Program Implementation Federal Agency: U.S. Department of Labor Federal Program Title: Unemployment Insurance ALN: 17.225 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: UI-34744-20-55-A-48 01/01/2021 ? 09/06/2021 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: Section 2104 of the CARES Act and the Continued Assistance Act allows for unemployment compensation to be paid to claimants under the Self-Employment Assistance Program and MEUC, respectively. Condition: In January 2021, the Texas Workforce Commission (TWC) signed an addendum with the Department of Labor to administer the Mixed Earners Unemployment Compensation (MEUC) program. Under this agreement, each state is required to operate the program as required by any statutory amendments and the Department of Labor?s guidance. MEUC provides an additional $100 per week in supplemental benefits through weeks of unemployment ending on or before September 6, 2021, to individuals receiving certain unemployment insurance benefits who received at least $5,000 of self-employment income in the most recent taxable year ending prior to the individual?s application for regular unemployment compensation. Individuals who receive Pandemic Unemployment Assistance were ineligible for MEUC benefits. We noted that TWC did not implement the MEUC program during fiscal year 2021. TWC gave notice to the Department of Labor on June 26, 2021, to terminate the MEUC program, however, the Department of Labor has not issued a waiver. Questioned Costs: None. Cause: TWC did not implement the MEUC program because it lacked sufficient programming resources to configure its system for the MEUC program. Effect: A delay in implementing federal unemployment programs may diminish the number of claimants that will apply for MEUC and prevent the payment of benefits to eligible claimants contemporaneous to their weeks that claimants experienced a lack of income due to their unemployment. Repeat Finding: No Recommendation: We recommend that TWC should implement the required programs retroactively and/or obtain a waiver from the Department of Labor. Views of responsible officials: The Texas Workforce Commission acknowledges that it has not implemented the Mixed Earners Unemployment Compensation (MEUC) program. Texas exited the pandemic unemployment programs effective benefit week ending June 26, 2021, and the expiration of the programs became effective on September 6, 2021.
Corrective action plan: TWC has communicated with the Department of Labor (DOL) on this topic as recently as January 3, 2022 and will continue communicating with DOL as appropriate. Implementation date: N/A Responsible Persons: Clay Cole, Unemployment Insurance Division Director
2021 ? 018 Eligibility, Special Tests and Provisions ? UI Program Integrity ? Overpayments ? Improper Payment of Benefits Federal Agency: U.S. Department of Labor Federal Program Title: Unemployment Insurance ALN: 17.225 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Numbers and Periods: UI-34193-20-55-A-48, UI-35733-21-55-A-48 10/01/2019 ? 9/30/2020, 10/01/2020 ? 09/30/2021 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or specific requirement: 20 CFR ?618.720 Qualifying requirements for Basic Trade Readjustment Allowances (TRA). To qualify for Basic TRA for a week of unemployment, an AAW must meet each of the requirements in paragraphs (a) through (g) of this section: (g) Participation in approved training. (1) As a condition for receiving Basic TRA, except as provided for in ?618.730, the AAW, after a total or partial separation from the adversely affected employment within the certification period, and by the applicable deadlines in ?618.725 must: (i) Be enrolled in training, as defined in subpart A of this part; (ii) Be participating in approved training (as defined in ?618.705); or (iii) Have a waiver granted under ?618.735 in effect. (2) An AAW who has not met the requirements in paragraph (g)(1) of this section may, if otherwise eligible, receive Basic TRA before expiration of the applicable training enrollment deadline in ?618.725. Once the training enrollment deadline is reached, the training requirements in paragraph (g)(1) of this section must be met. Basic TRA payments must cease beginning the first week for which the requirements in paragraph (g)(1) of this section were required but not met. (3) The requirements in paragraph (g)(1) of this section do not apply to an AAW with respect to claims for Basic TRA for weeks of unemployment beginning before the filing of an initial claim for TRA after publication of the certification of the appropriate worker group as provided in ?618.715(a), nor for any week that begins before the AAW is notified that he or she is covered by a certification and is fully informed of the requirements of this section. (4) An AAW who meets the participation in approved training requirement in paragraph (g)(1) of this section by the applicable deadlines in ?618.725 may continue to receive Basic TRA after the AAW has completed training, even if such participation in training was on a part-time basis, provided that the worker meets all other eligibility requirements for Basic TRA. Condition: During our testing, we noted that one out of 60 claimants tested for UI eligibility requirements was not enrolled in an approved training to be eligible to receive TRA benefits. The claimant had a denial of payment decision placed on their record in the UI system, based on the fact that the claimant graduated from an approved training program. A TWC analyst removed the denial in error, allowing the system to process two weeks of TRA benefit payments of $378 per week to the individual. Additionally, as this amount was not identified as an overpayment by TWC, it was not included in the overpayments listing as of August 31, 2021. Questioned Costs: $756 Cause: A denial of payment decision is manually entered when a claimant is no longer eligible for TRA benefits. A TWC employee, unfamiliar with the TRA eligibility requirements, erroneously removed the payment decision in the UI system as all weeks of TRA benefits had not been paid to the claimant. This allowed the payment to be processed by the UI system in error. Effect: Due to the volume of claims, a lack of familiarity with eligibility requirements by employees making eligibility determinations could lead to payment of ineligible claims and material noncompliance. Repeat Finding: No Recommendation: We recommend that TWC provide additional training over eligibility requirements to individuals with access to make eligibility determinations in the UI system. Views of responsible officials: The Texas Workforce Commission (TWC) acknowledges and agrees with the cause noted. TWC did take action and provided additional training as recommended.
Corrective action plan: TWC has provided additional training as recommended. Implementation date: October 2022 Responsible Persons: Eric Holen, Unemployment Insurance Administration & Operational Support Director
2021 ? 019 Eligibility, Special Tests and Provisions ? UI Program Integrity ? Overpayments ? Improper Payment of Benefits Federal Agency: U.S. Department of Labor U.S. Department of Homeland Security Federal Program Title: Unemployment Insurance Presidential Declared Disaster Assistance to Individuals and Households ? Other Needs ALN: 17.225 97.050 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Numbers and Periods: Unemployment Insurance Various Various Presidential Declared Disaster Assistance to Individuals and Households 4485DRTXSPLW 07/25/2020 ? 03/27/2022 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Material Weakness in Internal Control over Compliance and Material Noncompliance Criteria or specific requirement: Per 2 CFR ?200 Appendix XI, State responsibilities include: (1) establishing specific, detailed policies and operating procedures which comply with the requirements of federal laws and regulations; (2) determining the state UI tax structure; (3) collecting state UI contributions from employers (commonly called ?unemployment taxes?); (4) determining claimant eligibility and disqualification provisions; (5) making payment of UI benefits to claimants; (6) managing the program?s revenue and benefit administrative functions; (7) administering the programs in accordance with established policies and procedures; and (8) enacting state UC law that conforms with federal UC law and that state law and operations substantially comply with federal law. UIPL 16-21 - When a state obtains information through automated systems or other sources that question whether the name and/or SSN used to file a claim belong to the individual who is filing the claim, the state must act quickly to: i) provide the individual with proper notice and an opportunity to provide information to resolve the issue; ii) decide whether or not sufficient information has been provided to verify the individual?s ID; and iii) issue a written determination. When such issues arise, states must act promptly to verify an individual?s ID in order to meet the requirement of section 301(a)(1), SSA, that the state have methods of administration reasonably calculated to ensure full payment of UI when due. For new claims, payment ?when due? means that qualified and eligible individuals receive their first benefit payments as soon as administratively feasible. UIPL No. 04-01 interprets the ?when due? requirement to also require states to ensure that payment of benefits is not made when payment is not due. Investigations of fraudulent imposter claims involving claimants, employers, and/or state staff are necessary for the proper administration of the UI program. States must have processes in place to ensure benefits are only paid to the individual whose identity has been verified. However, once a claim has been established and payments have been issued, there is a presumption of eligibility (refer to UIPL 04-01). Therefore, there must be evidence on the record that substantiates a reasonable basis for stopping payments once a determination of eligibility has been made and payments have been issued. Internal Control ? Per 2 CFR ?200.303(a), a non-Federal entity 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: On March 27, 2020, the President signed the CARES Act that authorized additional funding under the unemployment insurance program. This pandemic-related funding was significant and expanded the eligible individuals to support changes in employment status caused by COVID-19. These benefits extended into 2021. Additionally, on August 21, 2020, the Federal Emergency Management Agency (FEMA) provided supplemental payments for lost wages funds to enable TWC to provide $300 weekly supplemental payments to individuals unemployed due to COVID-19 pursuant to FEMA-DR-4485-TX. There was a priority on distributing funds under self-attestation strategy with limited verification to expedite disbursement of funds and support individuals in greatest need. However, several states experienced significant fraudulent claims. The U.S. Department of Labor and TWC have partnered to investigate the extent and methods used to perpetrate the fraud. For TWC, given the extent and circumstances, eligibility determinations made by the management were following the existing policies and procedures for this pandemic funding; however, to meet Federal and State expectations regarding the quick payment of federal pandemic benefits, the policies and procedures were not adequate to completely prevent fraudulent claims related to stolen identities (e.g., identity theft). Condition (Continued): TWC?s detective control did identify abnormal claim activity, however, not before payments were made. During our testing of 60 claims for supplemental payments for lost wages, we identified five claims that were considered potential identity theft as the claimants had not identified themselves through the identity verification process. The claims included benefit payments under UI, Disaster Unemployment Assistance (DUA), Pandemic Unemployment Assistance (PUA), Federal Pandemic Unemployment Compensation - ARPA and CARES (FPUC), and/ or Lost Wage Assistance (LWA). While these claims have been placed in an open period ineligibility status through a contact request to stop any future payments until TWC can speak with the claimant and resolve the potential ID theft issue, benefits in the amount of $55,224 were paid to these five claimants without appropriate identity verification. Per United States Department of Labor (USDOL) guidance through Unemployment Insurance Program Letter 16- 21, ?While an individual?s failure to respond is sufficient to prevent additional benefits from being paid until the individual responds, failure to respond in and of itself is not sufficient to establish an overpayment. The state must consider the evidence supporting suspicious activity, in addition to the individual?s failure to respond to the state?s attempt to verify identity, and determine if, under state law, the evidence in the record is sufficient to establish an overpayment.? TWC has stopped claims that it deems suspicious and potential ID theft, however, did not establish an overpayment as there was no corroboration from the claimant or an employer that actual ID theft occurred. Questioned Costs: Undetermined and under investigation by both federal and local authorities Cause: TWC experienced unprecedented claims volume with increased funding and additional program requirements with a priority for efficient distribution from both the U.S. Department of Labor and State officials. TWC?s existing identity verification protocols and vendor services were not adequate to timely identify and stop the onslaught of imposter claims caused by identity theft. Effect: A lack of internal controls over eligibility determinations may make the programs more vulnerable to fraudulent claims. Repeat Finding: No Recommendation: We recommend that TWC continue to review, monitor, and enhance eligibility procedures to detect and/or prevent fraudulent claimants from receiving benefits. Also, TWC should continue to enhance its assessment of risk related to the eligibility process and implement internal controls to help mitigate future identify theft frauds. Views of responsible officials: The Texas Workforce Commission (TWC) acknowledges and agrees with the finding and concurs with the recommendation. TWC has historically maintained strong internal controls to address fraud and identity theft in the Regular program as well as the long-established Federal programs (Unemployment Compensation for Ex-Service Members; Unemployment Compensation for Federal Employees; DUA, etc.). TWC has implemented all required and recommended data crossmatches from the U.S. Department of Labor and was an early adopter of the fraud-fighting services, protocols, and best practices of the National Association of State Workforce Agencies? UI Integrity Center. TWC was inundated with unprecedented claims volumes associated to the CARES Act programs. In addition to the sheer volume, the Pandemic Unemployment Assistance (PUA) program exacerbated the scourge of fraudulent imposter claims. Unlike true unemployment insurance programs such as Regular State benefits and Pandemic Emergency Unemployment Compensation, PUA was designed primarily to provide for payments to individuals who were not eligible for traditional unemployment compensation, e.g., individuals who were selfemployed or who had very limited work history. Congress mirrored the PUA program on the existing Disaster Unemployment Assistance (DUA) program. Like DUA, the PUA program was an emergency program activated in response to a crisis and designed to provide benefits to certain individuals who were ineligible for regular unemployment compensation or extended benefits. By its very nature, the PUA program bypassed core internal controls in the Regular program designed to ensure integrity in the system. Because PUA addressed the selfemployed or recently employed, it did not generally rely on past wages that exist in states? unemployment insurance systems as employer-reported quarterly employee wage records. Likewise, PUA eligibility was predicated on criteria related to the COVID-19 pandemic (UIPL 16-20 ?4(a)) rather than a traditional jobseparation analysis based on a claim response from an employer. The employer claim notice and response control is vital to a bona fide unemployment insurance system because it serves, in part, as verification of the worker?s identity and past employment with the employer. It is not unexpected, then, that of the 60 claims tested as part of this audit, the 5 which were identified as potentially ID theft imposter claims were each PUA claims. While acknowledging that some amount of fraudulent ID theft claims were paid, TWC in general was successful in identifying and stopping the large majority of these claims prior to payment. Since the beginning of the pandemic in March 2020, approximately 5 million total unemployment benefit claims were filed and $54 billion in total net benefits were paid. Of that population, more than 159,000 claims have been confirmed as ID theft. Of that, a little over 10,000 claimants were paid benefits in the amount of approximately $56 million, or 0.1 percent of all benefit payouts. TWC protocols prevented an estimated $827 million in payouts to confirmed ID theft claims. Additionally, TWC claim-verification processes identified roughly 627,000 potential ID theft claims that had no benefits paid at all. Regarding these claims, TWC estimates that approximately $3.5 billion in potentially fraudulent benefits were prevented from paying out. All told, TWC stopped nearly $4.3 billion in potential ID theft payments. In summary, TWC is committed to the integrity of the unemployment compensation program and continues to commit significant resources to the on-going effort to eliminate fraud, waste, and abuse in the program.
Corrective action plan: TWC is continuing the work it began in FFY2020 to enhance and augment internal controls related to benefit fraud and ID theft fraud detection and prevention. That work includes aggressive data analytics analysis and leveraging tools available in-house and through vendors to accurately prevent fraudulent claims as early in the claims-filing process as possible. This work will be documented through divisional policy and program letters intended to clearly establish TWC?s risk assessment processes and stipulate the appropriate internal controls to address the risk. TWC is also continuing to analyze and investigate all claims deemed to be suspicious and to appropriately assess overpayments in accordance with USDOL directives. Implementation date: Ongoing Responsible Persons: Chuck Ross, Director, Division of Fraud Deterrence and Compliance Monitoring
2021 ? 020 Special Tests and Provisions ? UI Program Integrity ? Overpayments ? Lack of Data Collection Federal Agency: U.S. Department of Labor U.S. Department of Homeland Security Federal Program Title: Unemployment Insurance Presidential Declared Disaster Assistance to Individuals and Households ? Other Needs ALN: 17.225 97.050 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Numbers and Periods: Unemployment Insurance Various Various Presidential Declared Disaster Assistance to Individuals and Households 4485DRTXSPLW 07/25/2020 ? 03/27/2022 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Material Weakness in Internal Control over Compliance and Material Noncompliance Criteria or specific requirement: Sections UIPL 15-20 and UIPL 16-20, Recovery Provisions, require a State agency to properly identify, handle and recover amounts overpaid to claimants. State agencies must have systems in place to capture overpayment data in order for recovery procedures to be conducted. SEC. 262. Lost Wages Assistance Recoupment Fairness. (b) Waiver Authority For State Liability. In the case of any individual who has received amounts of covered assistance to which the individual is not entitled, the State shall require the individual to repay the amounts of such assistance to the State agency, except that the State agency may waive such repayment if the State agency determines that (1) the payment of such covered assistance was without fault on the part of the individual; and (2) such repayment would be contrary to equity and good conscience. Condition: Under the CARES Act and amidst the COVID-19 pandemic, TWC administered a number of unemployment insurance programs to provide unemployment benefits for persons impacted by COVID-19. Among these programs were the PUA, FPUC, and LWA programs that provided the following benefits: See Schedule of Findings and Questioned Costs for chart/table During these weeks, TWC processed an unprecedented number of claims in order to provide benefits to claimants impacted by COVID-19 in a timely manner. During these weeks, we noted that TWC did not implement overpayment data collection procedures in its UI system for these programs. As a result, potential overpayments were not being calculated during this time period. Overpayments were retroactively calculated for the PUA and FPUC programs in May 2021 and December 2021, respectively. However, overpayments have not been calculated for the LWA program as of the fiscal year end. Questioned Costs: Undetermined Cause: TWC experienced unprecedented claims volume with increased funding and additional program requirements with a priority for efficient distribution from both the U.S. Department of Labor and State officials. Due to the volume of claims and the expectation to meet demand, TWC did not implement adequate program changes to its system to calculate potential overpayments for the new program. Effect: The passage of time diminishes TWC's ability to recover overpaid amounts. Additionally, overpaid balances for the Lost Wages Assistance are not properly accounted for as they are not captured in TWC's financial statements. Repeat Finding: No Recommendation: We recommend that TWC develop a plan to capture and collect overpayment data. Views of responsible officials: The Texas Workforce Commission (TWC) acknowledges and agrees with the finding of not programming overpayments associated with the Lost Wage Assistance (LWA) program. TWC has implemented overpayment tracking to capture and collect Pandemic Unemployment Assistance (PUA) and Federal Pandemic Unemployment Compensation (FPUC) overpayments, however programming for Lost Wage Assistance (LWA) is still pending.
Corrective action plan: The TWC implemented PUA and FPUC overpayment programming in May 2021 (waivers only) and December 2021 and communicated this to the Department of Labor January 3, 2022. TWC is trying to introduce programming for LWA overpayments prior to the FEMA close out period. Implementation date: May 2021 for PUA waivers; December 2021 for FPUC and TBD for LWA Responsible Persons: Clay Cole, Unemployment Insurance Division Director
2021 ? 021 Period of Performance ? Application of Program Income Federal Agency: U.S. Department of Education Federal Program Title: Rehabilitation Services - Vocational Rehabilitation Grants to States ALN: 84.126 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Number and Period: H126A210092 10/01/2020 ? 09/30/2021 Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR ?200.303(a), a non-Federal entity 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: TWC applies expenditures to program income on a weekly basis in order to spend program income prior to drawing down additional federal funds. Management queries a report from WRAPS (Workforce, Reporting, Accounting and Purchasing System) to retrieve all program expenditures by accounting period. Program expenditures for the current accounting period, up to the amount of program income is applied to program income. We noted that the accounting period per the WRAPS report used by management does not coincide with the underlying service date of the expenditures. We tested 25 out of 17,218 expenditures that were expended during the first month of the grant award period, or September 24, 2020 through October 31, 2020. Six out of 25 samples tested were entries to apply expenditures to program income based on the process described above. Upon review of the underlying expenditures, we noted that $1,481,904 out of $6,141,146 in expenditures had services dates in September 2020, prior to the grant period of performance and were incorrectly charged to the grant. Management corrected the error and reclassified the expenditures. Questioned Costs: None. Cause: The systematic approach in which management applied program income was incorrect as it used the accounting date rather than the service date of the expenditures. Effect: Reliance on internal controls that are not designed properly may result in errors and questioned costs. Repeat Finding: No Recommendation: We recommend TWC update its process to apply expenditures to program income to use the service date of the expenditure rather than the WRAPS accounting date. Views of responsible officials: The Texas Workforce Commission acknowledges and agrees with the findings. Through analysis of the exceptions identified in the audit, the Texas Workforce Commission has developed and implemented corrective action to address this finding.
Corrective action plan: The Texas Workforce Commission has already implemented necessary process enhancements in this area. The procedure for spending program income has been updated to include the service dates when collecting expenditure data to be transferred. Implementation date: July 15, 2021 Responsible Persons: Teri Goodwin, Financial Reporting Grant Accountant
2021 ? 023 Cash Management, Subrecipient Monitoring, Special Tests and Provisions ? Quality Assurance ? Information Technology ? User Access and Password Management Federal Agency: U.S. Department of Transportation Federal Program Title: Highway Planning and Construction Cluster Formula Grants for Rural Areas ALN: 20.205, 20.219, 20.224, 23.003 20.509 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Numbers and Periods: Various Various Statistically Valid Sample: No, and not intended to be a statistically valid sample Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: Per 2 CFR ?200.303(a), a non-Federal entity 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: SiteManager (SMGR) automates the contract administration functions for construction and maintenance projects and the materials and tests administration functions, which include aspects of project administration from the time a contract is awarded through finalization of the project. eGrants is a TxDOT-wide enterprise system managed by the Information Technology Division (ITD) and used by the Aviation (AVN) and Public Transportation (PTN) Divisions to manage grants to subgrantees across Texas for federal and State funded grants. During our testing of SGMR and EGrants, we noted the following: ? Password Management: During our testing, we noted that there is no set password expiration or lockout configurations set for SGMR, which is not in accordance with the password standards in the Texas Department of Transportation (TXDOT) Information Security Policy (Policy). The policy states that passwords must be changed periodically and that lockout attempts should be configured in accordance with the Information Security and Privacy Controls Catalog. ? User Access Reviews: During our testing, we noted that TXDOT did not perform a documented periodic access review of users for SGMR, which would include a review of privileged users? access. In addition, during our testing we noted that TXDOT did not perform a documented periodic access review of users for the EGrants application, which would include a review of privileged users? access. We tested thirtythree (33) users with privilege access in EGrants to verify whether access was restricted to those who have business needs. Of the 33 users, TXDOT was unable to provide the business purpose for 19 of the privilege access users. The 19 accounts were noted as vendor accounts. Management corrected the password configuration matter subsequent to August 31, 2021 by adding the Active Directory login function to SGMR. As of December 17, 2021, the Active Directory credentials are used for all users? login into SMGR. Questioned Costs: None. Cause: Password configurations were not in accordance with the TXDOT Information Security Policy and Information Security and Privacy Controls Catalog due to management oversight. Additionally, TxDOT does not have established policies and procedures that require user access reviews over user accounts for all applications. Effect: Failure to set password configurations and password lockout configurations increases the risk of inappropriate access. Failure to perform user access reviews increases the risk that suspicious activities may not be identified and investigated. Repeat Finding: 2018 ? 038 Recommendation: We recommend TXDOT configure SGMR password configurations to be in accordance with the established TXDOT Information Security Policy and Information Security and Privacy Controls Catalog. In addition, we recommend that TXDOT implement policies and procedures in relation to SGMR and EGrants to complete documented user access reviews, including a review of all privileged accounts on a periodic basis to verify that all active accounts supported by a business purpose. Views of responsible officials: The Department concurs with the recommendations. The Department implemented corrective action in December 2021 to resolve the password configuration finding. ITD is responsible for reviewing user access for its Division and vendors supporting those ITD functions within eGrants. AVN and PTN are responsible for reviewing user access for their respective divisions? employees and subgrantee staffs.
Corrective action plan: SiteManager- The Construction Division (CST) and ITD will work together to implement annual SiteManager user access reviews. ? ITD will produce a User Access Review Report. ? CST will distribute instructions for managers to use the User Access Review Report to validate users under their direction. ? CST will follow up with managers as necessary to ensure the review is completed. CST will continue to work with ITD on improvements to the process based on feedback from the current year?s review. eGrants - ITD, AVN and PTN will implement policies and procedures to complete documented eGrants user access review, including review of all privileged accounts, at a minimum of once per year to verify all active accounts supported by their divisions? respective business purposes. These policies and procedures will be in accordance with State information security requirements. Implementation date: SiteManager user access reviews - April 2022 eGrants user access reviews - April 2022 Responsible Persons: SiteManager - Duane S. Milligan, P.E. - Director, CST eGrants - Scott Rogillio - IT Applications Section Manager, ITD Dan Harmon - Director, AVN Mark Sprick - Administration and Program Support Section Director, PTN
2021 ? 101 Equipment and Real Property Management Federal Program Title: Research and Development Cluster Federal Agencies: U.S. Department of Defense, U.S. Department of Health and Human Services, National Science Foundation Award years: See below Award numbers: See below Statistically valid sample: No and not intended to be a statistically valid sample Type of finding: Significant Deficiency and Non-Compliance Questioned Costs: $0 Repeat Finding: No A recipient?s property records for equipment acquired with federal funds must be maintained accurately and include all of the following: a description of the equipment; serial number or other identification number; the source of funding for the equipment, including the federal award identification number; who holds the title; acquisition date and cost of the equipment; the percentage of federal participation in the cost of the equipment; the location, use, and condition of the equipment; and ultimate disposition data, including the date of disposal and sale price (Title 2, Code of Federal Regulations (CFR), Section 200.313(d)(1)). A control system must be developed to ensure that adequate safeguards are in place to prevent loss, damage, or theft of the equipment. Any loss, damage, or theft must be investigated (Title 2, CFR, Section 200.313(d)(3)). Texas A&M University (University) did not maintain accurate and complete property records for 4 (6 percent) of 65 equipment items tested. Specifically: ? For three items, the property record contained an incorrect location. For one item, the location was not updated before it was deployed to an off-campus location. For the second item, the location in the property record did not match the location where the item was currently in use. That item is mobile; however, the location was not updated in the property record when the item was moved. For the third item, the property record did not reflect the location where the item was stored until it could be installed. ? For one other item, the University did not follow its policy to affix an inventory tag before the item was transferred to an off-campus location. That item also did not have a serial number noted in the property record. While there was not a specific serial number located on the item, there was another number that could have been entered into the property record to help identify the item. In addition, the University was unable to locate 1 (2 percent) of 62 equipment items selected for physical inspection. The University did not identify that the item was missing and file a missing property report until auditors selected that item for testing. Not maintaining accurate and complete property records and not adequately safeguarding equipment increases the risk that equipment may be misused, lost, or stolen. The following awards were affected by the equipment issues discussed above: See Schedule of Findings and Questioned Costs for chart/table Recommendations: The University should strengthen controls to ensure that it: ? Maintains accurate and complete property records for all equipment acquired with federal funds. ? Adequately safeguards its equipment to prevent loss or theft of equipment. Views of Responsible Officials: The University acknowledges and agrees with the finding. Texas A&M University will work to develop and implement corrective action.
Corrective Action Plan: Texas A&M University Property Management will remind departments of the importance of updating location information, documenting serial numbers or other identifying information, affixing inventory tags, and promptly reporting missing assets. The reminder will include specific policy recommendations or examples of situations that need additional attention. The Property Management office will also work with those departments that had exceptions identified in the audit to increase compliance with 2 CFR 200. Property Management will continue the annual spot audit process to verify the accuracy of the location and serial number of federally funded assets. Implementation Date: January 2022 Responsible Person: Todd Gregory
2021 ? 102 Subrecipient Monitoring Federal Program Title: Research and Development Cluster Federal Agencies: U.S. Department of Education, National Science Foundation Award year: See below Award number: See below Statistically valid sample: No and not intended to be a statistically valid sample Type of finding: Significant Deficiency and Non-Compliance Questioned Costs: $0 Repeat Finding: No Award Identification At the time of the subaward, the pass-through entity must communicate to the subrecipient: (1) federal award identification information, including the assistance listing number and title, federal award number, subrecipient?s unique entity identifier, and whether the award is research and development; (2) all requirements imposed by the pass-through entity on the subrecipient so that the federal award is used in accordance with federal statutes, regulations, and the terms and conditions of the federal award; (3) any additional requirements that the passthrough entity imposes on the subrecipient in order for the pass-through entity to meet its own responsibility to the federal awarding agency; (4) an approved federally recognized indirect cost rate negotiated between the subrecipient and the federal government; (5) a requirement that the subrecipient permit the pass-through entity and auditors to have access to the subrecipient?s records and financial statements; and (6) appropriate terms and conditions concerning closeout of the subaward (Title 2, Code of Federal Regulations (CFR), Section 200.332(a)). For 2 (7 percent) of 30 subawards tested, Texas A&M University (University) did not provide all required information to the subrecipient. Specifically, the University did not communicate one or more of the following required elements: assistance listing number and title, the subrecipient?s unique identifier, or whether the award is research and development. For one of those subawards, the pass-through entity did not communicate all of the required information to the University and the University relied on that information when creating its own subaward. In addition, for that same award, the University used an old subaward template that had not been updated to include all of the required information. For the other subaward, the University created the subaward using a generic assistance listing number. Not providing all required award information increases the risk that subrecipients will not comply with all applicable statutes, regulations, and terms and conditions of the federal award. Risk Assessment Pass-through entities are required to evaluate each subrecipient?s risk of noncompliance with federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring. The pass-through entity may consider such factors as (1) the subrecipient?s prior experience with the same or similar subawards, (2) the results of previous audits, (3) whether the subrecipient has new personnel or new or substantially changed systems, and (4) the extent and results of federal awarding agency monitoring (Title 2, CFR, Section 200.332 (b)). When establishing a new subaward, the University uses a subrecipient risk assessment template that allows it to assess risk based on criteria such as the amount of a subaward, scope of work, place of performance, and previous audit findings. Based on the results of the risk assessment, the University determines for the subrecipient an overall risk level of acceptable risk or high risk. For 1 (3 percent) of 30 subawards tested, the University could not provide evidence that it had performed a risk assessment for the subrecipient. As a result, auditors were unable to determine whether the University would have needed to perform additional monitoring activities in accordance with its policies. When auditors brought the issue to the University?s attention, it was unable to determine whether the risk assessment had not been performed or if the risk assessment was performed but not documented in the subrecipient?s file. The following awards were affected by the issues discussed above. See Schedule of Findings and Questioned Costs for chart/table Recommendations: The University should: ? Ensure that it communicates all required information to subrecipients. ? Follow its policies for assessing subrecipient risk and document that assessment in the subrecipient?s file. Views of Responsible Officials: The University acknowledges and agrees with the finding. Texas A&M University will work to develop and implement corrective action.
Corrective Action Plan: Texas A&M Sponsored Research Services (SRS) will ensure that the revised subaward agreement long form is used on all applicable subaward agreements so that subrecipients receive all information required in 2 CFR 200. In addition, contract negotiators will be reminded of the requirement to complete and document a subrecipient risk assessment as described in the procedure manual. Implementation Date: March 2022 Responsible Person: Crissy Stratta
2021 ? 103 Equipment and Real Property Management Federal Program Title: Research and Development Cluster Federal Agencies: U.S. Department of Defense, National Science Foundation, U.S. Department of Energy, U.S. Department of Education, U.S. Department of Health and Human Services Award years: See below Award numbers: See below Statistically valid sample: No and not intended to be a statistically valid sample Type of finding: Significant Deficiency and Non-Compliance Questioned Costs: $0 Repeat Finding: 2018-109, 2015-134, 2014-155, 2013-176, 13-161, and 12-170 Equipment Property Records A recipient?s property records for equipment acquired with federal funds must be maintained accurately and include all of the following: a description of the equipment; serial number or other identification number; the source of funding for the equipment, including the federal award identification number; who holds the title; acquisition date and cost of the equipment; the percentage of federal participation in the cost of the equipment; the location, use, and condition of the equipment; and ultimate disposition data, including the date of disposal and sale price (Title 2, Code of Federal Regulations (CFR), Section 200.313(d)(1)). The University of Texas at Austin (University) did not maintain accurate and complete property records for 6 (9 percent) of 64 equipment items tested. Specifically, for each of those items, the property record was inaccurate or did not contain one of the following elements: serial number or other identification number, cost of equipment, item location, or disposition information. The University relies on unit administrators within each University department to provide the required information in the equipment property records. Those errors occurred because the University either (1) did not enter property records accurately and completely into its asset management system or (2) did not always follow its policies and procedures to update property records as needed. Not maintaining accurate and complete property records increases the risk that equipment may be misused, lost, or stolen. The following awards were affected by the equipment issues discussed above: See Schedule of Findings and Questioned Costs for chart/table Physical Inventory A recipient must conduct a physical inventory of equipment and reconcile the results with its property records at least once every two years. A control system also must be developed to ensure that adequate safeguards are in place to prevent loss, damage, or theft of equipment. Any loss, damage, or theft of equipment must be investigated (Title 2, CFR, Section 200.313(d)(2) and (3)). The University?s Handbook of Business Procedures (Handbook) states that an annual physical inventory will be conducted and that when a unit administrator becomes aware that an item of equipment is missing, a diligent search must be performed until the equipment is found or until it is established that it has been lost or stolen. The University conducted a physical inventory of equipment during fiscal year 2021; however, 28 (8 percent) of 332 departments did not complete the physical inventory as required. Specifically: ? For 25 departments, documentation was provided to explain why the physical inventory was not completed, which was generally attributable to the COVID-19 pandemic. ? For three departments, no documentation was provided to explain why the physical inventory was not completed. Not requiring all departments to complete an annual inventory increases the risk that equipment purchased with federal funds may be lost, stolen, or improperly disposed. Recommendations: The University should strengthen controls to ensure that it: ? Maintains accurate and complete property records for all equipment acquired with federal funds. ? Requires departments to conduct an annual physical inventory of equipment. Views of Responsible Officials: The University concurs with the findings.
Corrective Action Plan: The University has implemented significant process enhancements in the areas noted in the findings. Inventory compliance has been emphasized to all departments through one-on-one trainings and frequent communications from inventory services. The Hand Book of Business Policy (HBP) will be revised to include detailed procedures to ensure that the University is in compliance with the requirements. Implementation Date: August 2022 Responsible Person: Lori Peterson
2021 ? 106 Activities Allowed or Unallowed Allowable Costs/Cost Principles Period of Performance Special Tests and Provisions ? Key Personnel Federal Program Title: Research and Development Cluster Federal Agencies: Federal agencies that award Research and Development Cluster funds Award years: Multiple Award numbers: Multiple Statistically valid sample: No and not intended to be a statistically valid sample Type of finding: Significant Deficiency Questioned Costs: $0 Repeat Finding: No General Controls Institutions must establish and maintain effective internal control over federal awards that provides reasonable assurance that the institution is managing federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal award (Title 2, Code of Federal Regulations (CFR), Section 200.303). The University of Texas M.D. Anderson Cancer Center (Cancer Center) did not appropriately update certain systems it uses to manage its federal research and development awards. The Cancer Center asserted that the updates were not made due to other competing priorities. Not ensuring that systems are updated and supported increases the risk of data loss or breach. After auditors brought the issue to the Cancer Center?s attention, it updated those systems. Recommendation: The Cancer Center should update and support all systems it uses to manage federal awards. Views of Responsible Officials: MD Anderson Cancer Center (MDACC) acknowledges and agrees with the finding. Through analysis of the exceptions identified in the audit, MDACC will work to develop and implement a corrective action to further improve the processes.
Corrective Action Plan: MDACC has implemented process enhancements to help ensure that our systems stay updated. Information Systems (IT Engineering) will send an annual report by August 31st to the Information Systems application owners and Information Security of any server operating systems that need to be updated in the upcoming fiscal year. Implementation Date: January 2022 Responsible Person: Emil Patel
2021 ? 107 Equipment and Real Property Management Federal Program Title: Research and Development Cluster Federal Agencies: U.S. Department of Defense, U.S. Department of Veterans Affairs, U.S. Department of Health and Human Services Award years: See below Award numbers: See below Statistically valid sample: No and not intended to be a statistically valid sample Type of finding: Significant Deficiency and Non-Compliance Questioned Costs: $0 Repeat Finding: 2018-119 A recipient?s property records for equipment acquired with federal funds must be maintained accurately and include all of the following: a description of the equipment; serial number or other identification number; the source of funding for the equipment, including the federal award identification number; who holds the title; acquisition date and cost of the equipment; the percentage of federal participation in the cost of the equipment; the location, use, and condition of the equipment; and ultimate disposition data, including the date of disposal and sale price (Title 2, Code of Federal Regulations (CFR), Section 200.313(d)(1)). A control system must be developed to ensure that adequate safeguards are in place to prevent loss, damage, or theft of the equipment. Any loss, damage, or theft must be investigated (Title 2, CFR, Section 200.313(d)(3)). The University of Texas M.D. Anderson Cancer Center (Cancer Center) did not maintain accurate and complete property records for 22 (36 percent) of 61 equipment items tested. Specifically: ? For 17 items, the property record contained an incorrect location. The Cancer Center relies on its annual inventory process to verify that the property record accurately reflects the location of equipment items. Due to the COVID-19 pandemic, the Cancer Center did not complete the fiscal year 2020 inventory and was in the process of performing the fiscal year 2021 inventory at the time of the audit. As a result, the property records were not updated to reflect the items? current locations. ? For two items, the property record indicated that the items were in-service; however, those items were no longer in use. After auditors selected those items for testing, the Cancer Center submitted a request for disposal. ? For two items, the property record did not contain the item?s serial number or the serial number was recorded incorrectly. ? For one item, the property record did not contain the item?s serial number and the location of the item was also incorrect. In addition, the Cancer Center was unable to locate 1 (2 percent) of 61 equipment items selected for inspection. The Cancer Center did not file a missing property report until auditors selected that item for testing. The errors discussed above occurred because the Cancer Center (1) did not enter information accurately or completely when creating the property records or (2) did not update the property records when changes to the items were made. Not maintaining accurate and complete property records and not adequately safeguarding equipment increases the risk that equipment may be misused, lost, or stolen. The following awards were affected by the equipment issues discussed above: See Schedule of Findings and Questioned Costs for chart/table Recommendations: The Cancer Center should strengthen controls to ensure that it: ? Maintains accurate and complete property records for all equipment acquired with federal funds. ? Adequately safeguards its equipment to prevent loss, or theft of equipment. Views of Responsible Officials: MD Anderson Cancer Center (MDACC) acknowledges and agrees with the finding. Through analysis of the exceptions identified in the audit, MDACC will work to develop and implement a corrective action to further improve the processes.
Corrective Action Plan: ? The Cancer Center will emphasize bi-annually via communication to Property Officers and Administrators the importance on capturing correct and timely asset information. This includes keeping accurate and timely information on the location, serial number and disposition of assets. ? The Cancer Center will communicate during the annual inventory process the importance of validating current data in the system and request updates via the Asset Control team. Implementation Date: Ongoing throughout FY 2022 Responsible Person: Freddy Garcia
Data source: This information comes from the Federal Audit Clearinghouse, the official repository of Single Audit data. All data is public domain. Verify this organization's audit history at fac.gov.
Track your findings and corrective action plans across audit cycles.
Start tracking findings →Monitor subrecipient audit findings and compliance status.
Start monitoring →Single Audit Intelligence is an independent tool powered by Federal Audit Clearinghouse data. Not affiliated with GSA, OMB, or any federal agency.