Criteria or specific requirement: 2 CFR 200.414(f) states that recipients may elect to charge a de minimis rate of up to 10 percent of modified total direct costs (MTDC). 2 CFR 200.1 “Modified Total Direct Cost (MTDC)” excludes equipment, capital expenditures, charges for patient care, rental costs, tuition remission, scholarships and fellowships, participant support costs, and the portion of each subaward in excess of $50,000. Condition: During testing of indirect costs, 4 of the 4 samples tested erroneously included rental costs in the calculation of Modified Total Direct Costs, resulting in an overcharge of indirect costs to the program. Questioned costs: None. Context: For allowable costs (indirect), a sample of 4 was made from a population of 12 reimbursement requests for the major program. Of the 4 sampled, all rental costs included in the calculation of Modified Total Direct Costs, resulting in a slightly higher indirect cost calculation. Cause: There is a misunderstanding of which costs should be excluded from the MTDC for this specific contract. Occupancy / Space Rental costs are identified but are not removed during the calculation of indirect costs. Effect: Inadequate allocation of indirect costs to federal programs may result in noncompliance with grant regulations, which could result in penalties or repayment obligations. Repeat Finding: 2023-002 Recommendation: CLA recommends that CCS work with the USCCB to update the Reimbursement Request form to include a section that removes items of selected cost from the calculation of indirect costs. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: 2 CFR 200.414(f) states that recipients may elect to charge a de minimis rate of up to 10 percent of modified total direct costs (MTDC). 2 CFR 200.1 “Modified Total Direct Cost (MTDC)” excludes equipment, capital expenditures, charges for patient care, rental costs, tuition remission, scholarships and fellowships, participant support costs, and the portion of each subaward in excess of $50,000. Condition: During testing of indirect costs, 4 of the 4 samples tested erroneously included rental costs in the calculation of Modified Total Direct Costs, resulting in an overcharge of indirect costs to the program. Questioned costs: None. Context: For allowable costs (indirect), a sample of 4 was made from a population of 12 reimbursement requests for the major program. Of the 4 sampled, all rental costs included in the calculation of Modified Total Direct Costs, resulting in a slightly higher indirect cost calculation. Cause: There is a misunderstanding of which costs should be excluded from the MTDC for this specific contract. Occupancy / Space Rental costs are identified but are not removed during the calculation of indirect costs. Effect: Inadequate allocation of indirect costs to federal programs may result in noncompliance with grant regulations, which could result in penalties or repayment obligations. Repeat Finding: 2023-002 Recommendation: CLA recommends that CCS work with the USCCB to update the Reimbursement Request form to include a section that removes items of selected cost from the calculation of indirect costs. Views of responsible officials: There is no disagreement with the audit finding.
2024 – 002: Schedule of Expenditure of Federal Awards (SEFA) Preparation Type of Finding: • Material Weakness in Internal Control Over Financial Reporting Condition: During testing, it was noted the School’s prepared SEFA did not properly reconcile to the underlying School records, which required additional adjustments of approximately $583,000. Criteria or specific requirement: 2 CFR 200.510(b) states: Schedule of expenditures of federal awards. The auditee must also prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502 Basis for determining federal awards expended. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a federal program has multiple federal award years, the auditee may list the amount of federal awards expended for each federal award year separately. At a minimum, the schedule must: • List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. For example, the National Institutes of Health is a major subdivision in the Department of Health and Human Services. • For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. • Provide total Federal awards expended for each individual Federal program and the Assistance Listing number or other identifying number when the Assistance Listing information is not available. For a cluster of programs also provide the total for the cluster. • Include the total amount provided to subrecipients from each Federal program. • For loan or loan guarantee programs described in §200.502 Basis for determining federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. • Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. Effect: Without a proper system of internal controls in place that operated effectively, material misstatements of the SEFA remained undetected. Cause: Management had not established an effective system of internal controls that would have ensured proper reporting of the SEFA. Repeat finding: Yes – 2023-004. Recommendation: We recommend the school implement internal controls over the SEFA including a reconciliation and review process before submission. Views of responsible officials and planned corrective actions: There is no disagreement with the audit finding.
Criteria or specific requirement: Per 2 CFR section 200.303(a), the Department 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). Title 2 – Grants and Agreements. Subtitle A – Office of Management and Budget Guidance for Grants and Agreements. Chapter II – Office of Management and Budget Guidance. Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart D – Post Federal Award Requirements. §200.332 Requirements for pass-through entities (2 CFR 200.332): All pass-through entities must: (a) Verify that the subrecipient is not excluded or disqualified in accordance with §180.300. Verification methods are provided in §180.300, which include confirming in SAM.gov that a potential subrecipient is not suspended, debarred, or otherwise excluded from receiving Federal funds. (b) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. 1) Federal award identification. a) Subrecipient name (which must match the name associated with its unique entity identifier); b) Subrecipient’s unique entity identifier; c) Federal Award Identification Number (FAIN); d) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; e) Subaward Period of Performance Start and End Date; f) Subaward Budget Period Start and End Date; g) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; h) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; i) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; j) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); k) Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; l) Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; m) Identification of whether the award is R&D; and n) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per §200.414. (c) Evaluate each subrecipient’s fraud risk and risk of noncompliance with a subaward to determine the appropriate subrecipient monitoring described in paragraphs (f) of this section. When evaluating a subrecipient’s risk, a passthrough entity should consider the following: 1) The subrecipient’s prior experience with the same or similar subawards: 2) The results of previous audits. This includes considering whether or not the subrecipient receives a Single Audit in accordance with Subpart F and the extent to which the same or similar subawards have been audited as a major program; 3) Whether the subrecipient has new personnel or new or substantially changed systems; and 4) The extent and results of Federal agency monitoring (for example, if the subrecipient also receives Federal awards directly from the Federal agency). Condition: Public Health established a formal risk assessment process over its subrecipients of federal awards by which to determine the frequency and extent of subrecipient monitoring to be performed, however the process was established after the period under audit and applied prospectively. In addition, Public Health used a Department Allocation Letter (DAL) for the COVID-19 program instead of an agreement or contract for the subaward to subrecipients. Certain required information for the subaward federal award information such as Assistance Listings number and Title and Federal Award Identification Number (FAIN) were not clearly identified in the DAL. Questioned costs: None Context: See “Condition.” Cause: Procedures to ensure that all relevant information is included in the grant agreements and risk assessments are performed were not in place at the time of the agreements which resulted in the oversight. Effect: By not properly evaluating the risk of noncompliance, Public Health may inadvertently award grant funds to subrecipients who lack the necessary mechanisms or understanding to comply with federal statutes. This increases the likelihood of noncompliance arising during the performance of the grant-funded activities. Furthermore, failure to provide the necessary documentation to subrecipients may result in misuse or misreporting of funding. Repeat Finding: This was reported in the previous year as finding 2023-009. Recommendation: Public Health should ensure every subaward includes all requirements imposed 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. Views of responsible officials: Management’s response is reported in “Management’s Response and Corrective Action Plan” included in a separate section at the end of this report.
FINDING 2023-001 Program Information: Temporary Assistance for Needy Families (ALN #93.558) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): L. Reporting- The auditee must prepare a schedule of expenditures of Federal awards (the “SEFA”) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For Research and Development (“R&D”), total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the passthrough entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listing number or other identifying number when the Assistance Listing information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in 2 CFR 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in 2 CFR 200.414. Condition: The SEFA as prepared by management did not originally include all expenditures for one federal grant. Cause: The Organization has a process where administrative expenses and management travel expenses are charged to a general fund code. A portion of those expenses related to the TANF program are then reclassed to the TANF fund code. We note some of those administrative and travel expenses did not get reclassed into the TANF fund code and as a result, the draft SEFA was not fully complete. Effect or Potential Effect: The original draft SEFA was incomplete. Questioned Costs: None. Context: During the process to compile and prepare the draft SEFA, certain administrative and travel costs were excluded from the draft SEFA, which resulted in the SEFA being understated by approximately $14,000. Identification as a Repeat Finding: Similar findings noted in the prior year. Recommendation: We recommend that the Alliance enhance its procedures and internal controls with respect to general ledger coding of expenses, preparation and review of the SEFA. Views of Responsible Officials and Planned Corrective Actions: Management will review SEFA for proper inclusion of all federal grant expenditures, and Alliance Director will ensure all invoices are properly coded to grants as applicable.
FINDING 2023-003 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Subrecipient Monitoring Federal Agency: Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Number and Year (or Other Identifying Number): FY 2023 Compliance Requirement: Subrecipient Monitoring Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-005. Condition and Context The County received a total State and Local Fiscal Recovery Funds (SLFRF) allocation of $13,177,707. During the audit period, the County provided subawards of SLFRF funds to other entities. As a pass-through entity, the County must: Identify the award and the applicable requirements to each subrecipient. Evaluate each subrecipient's risk of noncompliance for purposes of determining the appropriate subrecipient monitoring related to the subaward. Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for an authorized purpose, complies with the terms and conditions of the subaward, and achieves performance goals. Subawards, totaling $290,000, were provided to two different entities. Both subrecipient agreements associated with the subawards were selected for testing. For the two agreements tested, the following information was incomplete or missing: The federal award identification number (FAIN). The federal award date of award to the recipient by the federal agency. The name of the federal awarding agency, pass-through entity (auditee), and contact information for awarding official of the pass-through entity (auditee). The Assistance Listings Number and Title; the pass-through entity must identify the dollar amount made available under each federal award and the Assistance Listings Number at time of disbursement. Furthermore, the County did not have an evaluation of the subrecipients' risk of noncompliance or monitoring activities demonstrating compliance with the subrecipient monitoring requirement. The County did not request any financial or audit documentation from the subrecipients. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 21 BOONE COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) 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). . . ." 2 CFR 200.331(a) states: "Subrecipients. A subaward is for the purpose of carrying out a portion of a Federal award and creates a Federal assistance relationship with the subrecipient. See definition for Subaward in § 200.1 of this part. Characteristics which support the classification of the non-Federal entity as a subrecipient include when the non-Federal entity: (1) Determines who is eligible to receive what Federal assistance; (2) Has its performance measured in relation to whether objectives of a Federal program were met; (3) Has responsibility for programmatic decision-making; (4) Is responsible for adherence to applicable Federal program requirements specified in the Federal award; and (5) In accordance with its agreement, uses the Federal funds to carry out a program for a public purpose specified in authorizing statute, as opposed to providing goods or services for the benefit of the pass-through entity." 2 CFR 200.332 states in part: "All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward . . . (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; INDIANA STATE BOARD OF ACCOUNTS 22 BOONE COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the passthrough entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the passthrough entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; (xii) Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. (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 pass-through entity imposes on the subrecipient in order for the pass-through entity to meet its own responsibility to the Federal awarding agency including identification of any required financial and performance reports; (4) (i) An approved federally recognized indirect cost rate negotiated between the subrecipient and the Federal Government. If no approved rate exists, the passthrough entity must determine the appropriate rate in collaboration with the subrecipient, which is either: (A) The negotiated indirect cost rate between the pass-through entity and the subrecipient; which can be based on a prior negotiated rate between a different PTE and the same subrecipient. If basing the rate on a previously negotiated rate, the pass-through entity is not required to collect information justifying this rate, but may elect to do so; (B) The de minimis indirect cost rate. INDIANA STATE BOARD OF ACCOUNTS 23 BOONE COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (ii) The pass-through entity must not require use of a de minimis indirect cost rate if the subrecipient has a Federally approved rate. Subrecipients can elect to use the cost allocation method to account for indirect costs in accordance with § 200.405(d). (5) A requirement that the subrecipient permit the pass-through entity and auditors to have access to the subrecipient's records and financial statements as necessary for the pass-through entity to meet the requirements of this part; and (6) Appropriate terms and conditions concerning closeout of the subaward. (b) Evaluate each subrecipient's risk of noncompliance with Federal statues, regulations, and the terms and conditions of the subaward for purposes of determined the appropriate subrecipient monitoring . . . (d) Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved. Pass-through entity monitoring of the subrecipient must include: (1) Reviewing financial and performance reports required by the pass-through entity. (2) Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and written confirmation from the subrecipient, highlighting the status of actions planned or taken to address Single Audit findings related to the particular subaward. (3) Issuing a management decision for applicable audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by § 200.521. (4) The pass-through entity is responsible for resolving audit findings specifically related to the subaward and not responsible for resolving crosscutting findings. . . ." Cause The system of internal controls as established by the management of the County was not properly designed nor implemented. The County was unable to provide documentation that monitoring procedures were in place over subrecipients. Effect Without the proper implementation of an effectively designed system of internal controls, the County cannot be sure subrecipients are provided an adequate subaward agreement, with all required elements and are adequately monitored. As such, subaward agreements entered into by the County did not include all the required elements. In addition, the County did not properly monitor the non-profit to ensure proper spending of the federal funds. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the County. INDIANA STATE BOARD OF ACCOUNTS 24 BOONE COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the County design and implement a proper system of internal controls and develop policies and procedures to ensure subrecipients are provided with an adequate subaward agreement and monitored as appropriate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Federal Agency: Department of Justice Federal Assistance Listing Number: 16.756 Program: Court Appointed Special Advocates Award Number: 15JDP-21-GK-02762-CASA Criteria: The Uniform Guidance in 2 CFR §200.332 details requirements for pass-through entities in regard to subrecipient monitoring and management. Per 2 CFR §200.332, Requirements for Pass-Through Entities: “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the federal award and subaward. Required information includes: (1) Federal award identification. i. Subrecipient name (which must match the name associated with its unique entity identifier); ii. Subrecipient’s unique entity identifier; iii. Federal Award Identification Number (FAIN); iv. Federal Award Date (see the definition of federal award date in §200.1 of this part) of award to the recipient by the federal agency; v. Subaward Period of Performance Start and End Date; vi. Subaward Budget Period Start and End Date; vii. Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; viii. Total Amount of Federal Funds Obligated to the subrecipient by the pass through entity, including the current financial obligation; ix. Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; x. Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); xi. Name of federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; xii. Assistance Listings Number and Title; the pass-through entity must identify the dollar amount made available under each federal award and the Assistance Listings Number at time of disbursement; xiii. Identification of whether the award is R&D; and xiv. Indirect cost rate for the federal award (including if the de minimis rate is charged) per § 200.414. (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 pass-through entity imposes on the subrecipient in order for the pass-through entity to meet its own responsibility to the federal awarding agency, including identification of any required financial and performance reports; (4) i. An approved federally recognized indirect cost rate negotiated between the subrecipient and the Federal Government. If no approved rate exists, the pass-through entity must determine the appropriate rate in collaboration with the subrecipient, which is either: (A) The negotiated indirect cost rate between the pass-through entity and the subrecipient, which can be based on a prior negotiated rate between a different PTE and the same subrecipient. If basing the rate on a previously negotiated rate, the pass-through entity is not required to collect information justifying this rate, but may elect to do so; (B) The de minimis indirect cost rate. ii. The pass-through entity must not require use of a de minimis indirect cost rate if the subrecipient has a federally approved rate. Subrecipients can elect to use the cost allocation method to account for indirect costs in accordance with §200.405(d). (5) A requirement that the subrecipient permits the pass-through entity and auditors to have access to the subrecipient’s records and financial statements as necessary for the pass-through entity to meet the requirements of this part; and (6) Appropriate terms and conditions concerning closeout of the subaward.” Condition: National CASA/GAL’s subrecipient agreements do not contain a level of specificity to fully comply with federal subrecipient regulations. During our testing of subrecipient monitoring, we selected 16 subrecipient awards. For all awards tested, National CASA/GAL’s subaward agreements did not comply with 2 CFR §200.332, Requirements for Pass-Through Entities, as they do not contain a specific scope of work or project description. Cause: National CASA/GAL did not have the proper policies and procedures in place to ensure subaward agreements complied to relevant federal regulation, and that all required elements are located in subaward agreements, and not in the application or by reference to other documents. Effect or Potential Effect: Without adequate controls in place to ensure conformity with subaward requirements, grantees may not ensure compliance with any award special conditions or revised budgets agreed upon at contract implementation. Questioned Costs: None. Context: This is a condition identified per review of National CASA/GAL’s compliance with specified requirements using a non-statistically valid sample. The population consisted of 79 subawards made totaling to $2,428,200 provided to subrecipients in 2023. The sample consisted of 16 subawards totaling $515,618 provided to subrecipients in 2023. Identification as a Repeat Finding: 2022-005. Recommendation: We recommend establishing and maintaining written policies and procedures to ensure subaward agreements conform to the requirements outlined in 2 CFR §200.332. Views of Responsible Officials: Management agrees that subrecipient agreements in place in 2022 did not fully comply with 2 CFR §200.332. Updates were made to the policies and procedures as well to ensure subaward files contain the requisite components. Management has additionally implemented a Grant Master File Checklist to ensure compliance with terms and conditions required in subaward agreements.
Criteria: 2 CFR 200.332 notes, “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency;(v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; (xii) Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. (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; …” Condition: All three of the subawards selected for testing, the recipient’s UEI number was missing from the subaward. We consider this condition to be an instance of noncompliance relating to the Subrecipient Monitoring compliance requirement. Statistical sampling was not used in making sample selections. Questioned Costs :N/A Cause and effect: Without communication of the required information, subrecipients may overspend award amounts or incur unallowable expenses towards the grant. Recommendation: We recommend ACT evaluates policies and procedures to ensure all required information is communication with the subrecipient. Views of Responsible Officials and Planned Corrective Actions: Management agrees with this Single Audit Finding and response is included in the Corrective Action Plan.
Criteria: 2 CFR 200.332 notes, “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency;(v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; (xii) Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. (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; …” Condition: All three of the subawards selected for testing, the recipient’s UEI number was missing from the subaward. We consider this condition to be an instance of noncompliance relating to the Subrecipient Monitoring compliance requirement. Statistical sampling was not used in making sample selections. Questioned Costs :N/A Cause and effect: Without communication of the required information, subrecipients may overspend award amounts or incur unallowable expenses towards the grant. Recommendation: We recommend ACT evaluates policies and procedures to ensure all required information is communication with the subrecipient. Views of Responsible Officials and Planned Corrective Actions: Management agrees with this Single Audit Finding and response is included in the Corrective Action Plan.
METROPOLITAN TRANSPORTATION AUTHORITY (A Component Unit of the State of New York) SCHEDULE OF FINDINGS AND QUESTIONED COSTS- FEDERAL AWARDS (CONTINUED) YEAR ENDED DECEMBER 31, 2023 Reference Number: 2023-001 Federal Agency: U.S. Department of Homeland Security Federal Program: Rail and Transit Security Grant Program ALN Number: 97.075 Contract Number: FE2019-RA-00004; FE2020-RA-00005; FE2021-RA-00004; FE2022-RA-00006 Compliance Requirement: Subrecipient Monitoring Type of Finding: Deficiency-Non-Compliance 1. CRITERIA Subrecipient Monitoring - As stated in Uniform Grant Guidance - §200.331 Requirements for pass-through entities, all pass-through entities must: Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: • Subrecipient name (which must match the name associated with its unique entity identifier); • Subrecipient’s unique entity identifier; • Federal Award Identification Number (FAIN); • Assistance Listing Number (ALN) Number and Name; the pass-through entity must identify the dollar amount made available under each Federal award and the ALN number at time of disbursement; • Identification of whether the award is Research & Development; and • Indirect cost rate for the Federal award (including if the de minimis rate is charged per §200.414 Indirect (F&A) costs); 2. CONDITION/PERSPECTIVE Metropolitan Transportation Authority (“MTA”) has subrecipient monitoring procedures in place. MTA has corporate policies and procedures regarding subrecipient contracts. We reviewed Rail and Transit Security Grant Program’s subrecipient monitoring compliance. This program had one subrecipient. Based on our review of the subrecipient contract for this program, we noted that the subrecipient contract did not have all the required elements as stated in §200.331. 3. CAUSE MTA did not ensure that the contract between MTA and the subrecipient included the ALN and all other required elements as required by 2 CFR; §200.331. 4. EFFECT The Subrecipient may not identify an MTA contract as a federal program, and therefore may not follow the required federal award requirements. Additionally the subrecipient may not include the program in the Subrecipient’s schedule of expenditures of federal awards and the program may not be audited as part of the Subrecipient’s single audit. 5. REPEAT FINDING No 6. RECOMMENDATION We recommend that MTA implement policies and procedures to communicate the federal grant information to all subrecipients in accordance with Uniform Grant Guidance CFR 200.331 Subrecipient Requirements. 7. QUESTIONED COST None. 8. VIEWS OF RESPONSIBLE OFFICIAL The MTA Office of Security is acknowledging the sub-recipient agreement did not include the ALN Number – 97.075, Identification of whether the award is R&D and Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414 on the check list. The MTA does provide a copy of the award letter to our sub-recipient(s) and we perform yearly sub-recipient monitoring of our sub-recipient(s). Also, see “Corrective Action Plan”.
FINDING 2023-001 Program Information: Substance Abuse and Mental Health Services Projects (ALN #93.243) COVID-19 Education Stabilization Fund (ALN #84.425C) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): L. Reporting - The auditee must prepare a schedule of expenditures of Federal awards (the “SEFA”) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For Research and Development (“R&D”), total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the passthrough entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listing number or other identifying number when the Assistance Listing information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in 2 CFR 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in 2 CFR 200.414. FINDING 2023-001 Program Information: Substance Abuse and Mental Health Services Projects (ALN #93.243) COVID-19 Education Stabilization Fund (ALN #84.425C) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): L. Reporting - The auditee must prepare a schedule of expenditures of Federal awards (the “SEFA”) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For Research and Development (“R&D”), total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the passthrough entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listing number or other identifying number when the Assistance Listing information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in 2 CFR 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in 2 CFR 200.414. Condition: The SEFA, as prepared by management erroneously included expenditures previously incurred and reported in fiscal year 2022, resulting in an overstatement of $7,875 for the Substance Abuse and Mental Health Service Project. Additionally, COVID-19 Education Stabilization Fund expenditures were not complete, resulting in an understatement of $6,000 for the COVID-19 Education Stabilization Fund. Cause: Administrative oversight with respect to preparation of the SEFA. Effect or Potential Effect: The original draft SEFA was overstated. Questioned Costs: None Context: Due to an error in disbursing grant funds to an incorrect local club in fiscal year 2022, the Alliance attempted to correct this mistake by disbursing additional funds to the correct club in fiscal year 2023. The Alliance included the remedied disbursement on the 2023 SEFA, which resulted in a $7,875 overstatement of expenditures that had already been incurred and reported on the 2022 SEFA. The omission of costs allocated to the COVID-19 Education Stabilization Fund resulted in expenditures being understated by $6,000. Identification as a Repeat Finding: No similar findings noted in the prior year. Recommendation: We recommend that the Alliance enhance its procedures and internal controls with respect to preparation and review of the SEFA. Views of Responsible Officials and Planned Corrective Actions: Management will enhance procedures and internal controls with respect to the preparation and review of the SEFA, by reviewing the detail of expenses included in the prior year SEFA with current year expenses, to prevent duplicate entries being reported.
FINDING 2023-001 Program Information: Substance Abuse and Mental Health Services Projects (ALN #93.243) COVID-19 Education Stabilization Fund (ALN #84.425C) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): L. Reporting - The auditee must prepare a schedule of expenditures of Federal awards (the “SEFA”) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For Research and Development (“R&D”), total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the passthrough entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listing number or other identifying number when the Assistance Listing information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in 2 CFR 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in 2 CFR 200.414. FINDING 2023-001 Program Information: Substance Abuse and Mental Health Services Projects (ALN #93.243) COVID-19 Education Stabilization Fund (ALN #84.425C) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): L. Reporting - The auditee must prepare a schedule of expenditures of Federal awards (the “SEFA”) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For Research and Development (“R&D”), total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the passthrough entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listing number or other identifying number when the Assistance Listing information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in 2 CFR 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in 2 CFR 200.414. Condition: The SEFA, as prepared by management erroneously included expenditures previously incurred and reported in fiscal year 2022, resulting in an overstatement of $7,875 for the Substance Abuse and Mental Health Service Project. Additionally, COVID-19 Education Stabilization Fund expenditures were not complete, resulting in an understatement of $6,000 for the COVID-19 Education Stabilization Fund. Cause: Administrative oversight with respect to preparation of the SEFA. Effect or Potential Effect: The original draft SEFA was overstated. Questioned Costs: None Context: Due to an error in disbursing grant funds to an incorrect local club in fiscal year 2022, the Alliance attempted to correct this mistake by disbursing additional funds to the correct club in fiscal year 2023. The Alliance included the remedied disbursement on the 2023 SEFA, which resulted in a $7,875 overstatement of expenditures that had already been incurred and reported on the 2022 SEFA. The omission of costs allocated to the COVID-19 Education Stabilization Fund resulted in expenditures being understated by $6,000. Identification as a Repeat Finding: No similar findings noted in the prior year. Recommendation: We recommend that the Alliance enhance its procedures and internal controls with respect to preparation and review of the SEFA. Views of Responsible Officials and Planned Corrective Actions: Management will enhance procedures and internal controls with respect to the preparation and review of the SEFA, by reviewing the detail of expenses included in the prior year SEFA with current year expenses, to prevent duplicate entries being reported.
Program Information: Texas Statewide Youth Services Network Project (“SYSN”) (ALN #93.590) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): L. Reporting- The auditee must prepare a schedule of expenditures of Federal awards (the “SEFA”) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For Research and Development (“R&D”), total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the passthrough entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listing number or other identifying number when the Assistance Listing information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in 2 CFR 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in 2 CFR 200.414. Condition: The SEFA, as prepared by management, did not originally bifurcate grant expenditures between state and federal funding sources for the SYSN grant. Cause: The Organization did not properly identify separate state and federal funding sources as stated on the Notice of Award for the grant. Effect or Potential Effect: The original draft SEFA did not properly present both state and federal programs for the SYSN grant. Questioned Costs: None. Context: During the process to prepare the draft SEFA, management did not properly identify separate funding sources for one grant resulting in improper presentation of certain federal expenditures as state expenditures on the draft SEFA. Identification as a Repeat Finding: No. Recommendation: We recommend that the Alliance enhance its procedures and internal controls with respect to the preparation and review of the SEFA by comparing programs on the SEFA with corresponding grant agreements and notices of award. Views of Responsible Officials and Planned Corrective Actions: Review all federal grant contracts to determine if any separate funding sources should be listed for total funds received.
Assistance Listing Number, Federal Agency, and Program Name: Assistance Listing Number 93.600, Department of Health and Human Services, Head Start and Covid-19: Head Start ARP Federal Award Identification Number and Year: 05CH011937-03-03, 05HE000989-01-01 Pass-through Entity – N/A Finding Type – Significant deficiency in internal control over compliance Repeat Finding – No Criteria – Per 2 CFR 200.332 all pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of the Federal agency, pass-through entity, and contact information for awarding official of the pass-through entity; (xii) Assistance Listings title and number; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at the time of disbursement; (xiii) Identification of whether the Federal award is for research and development; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is used in accordance with § 200.414) Condition – During our test work, we noted that 3 out of 3 subaward agreements tested did not include the information as noted in 2 CFR 200.332. The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, were included in the grant agreement of its subrecipient. Identification of How Questioned Costs Were Computed – N/A Questioned Costs – None Cause/Effect – The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, were included in the grant agreement of its subrecipient. As a result, required information was omitted. Recommendation – We recommend that management review its procedures and controls to ensure the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, is included in all subawards to subrecipients. View of Responsible Officials and Corrective Action Plan –The Agency agrees with the finding. When granting funds as a subaward to a pass-through entity, the Agency will update its master templates for subawards to include the required information. In addition, when the sub agreements are routed for signature and reviewed by the Chief Financial Officer, they will be double-checked to ensure compliance with this requirement.
Assistance Listing Number, Federal Agency, and Program Name: Assistance Listing Number 93.600, Department of Health and Human Services, Head Start and Covid-19: Head Start ARP Federal Award Identification Number and Year: 05CH011937-03-03, 05HE000989-01-01 Pass-through Entity – N/A Finding Type – Significant deficiency in internal control over compliance Repeat Finding – No Criteria – Per 2 CFR 200.332 all pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of the Federal agency, pass-through entity, and contact information for awarding official of the pass-through entity; (xii) Assistance Listings title and number; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at the time of disbursement; (xiii) Identification of whether the Federal award is for research and development; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is used in accordance with § 200.414) Condition – During our test work, we noted that 3 out of 3 subaward agreements tested did not include the information as noted in 2 CFR 200.332. The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, were included in the grant agreement of its subrecipient. Identification of How Questioned Costs Were Computed – N/A Questioned Costs – None Cause/Effect – The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, were included in the grant agreement of its subrecipient. As a result, required information was omitted. Recommendation – We recommend that management review its procedures and controls to ensure the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, is included in all subawards to subrecipients. View of Responsible Officials and Corrective Action Plan –The Agency agrees with the finding. When granting funds as a subaward to a pass-through entity, the Agency will update its master templates for subawards to include the required information. In addition, when the sub agreements are routed for signature and reviewed by the Chief Financial Officer, they will be double-checked to ensure compliance with this requirement.
Assistance Listing Number, Federal Agency, and Program Name: Assistance Listing Number 64.033, Department of Veteran Affairs, VA Supportive Services for Veteran Families Program Federal Award Identification Number and Year: 21-MI-221, 22-MI-221, 20-MI-221-SS, 20-MI-221-LT, 20-MI-221 Pass-through Entity – N/A Finding Type – Significant deficiency in internal control over compliance Repeat Finding – No Criteria – Per 2 CFR 200.332 all pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity;(x) Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of the Federal agency, pass-through entity, and contact information for awarding official of the pass-through entity; (xii) Assistance Listings title and number; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at the time of disbursement; (xiii) Identification of whether the Federal award is for research and development; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is used in accordance with § 200.414) Condition – During our test work, we noted one instance where the subaward was not clearly identified to the subrecipient as a subaward and did not include the information as noted in 2 CFR 200.332. The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, was included in the grant agreement of its subrecipient. Identification of How Questioned Costs Were Computed – N/A Questioned Costs – None Cause/Effect – The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, were included in the grant agreement of its subrecipient. As a result, required information was omitted.Recommendation – We recommend that management review its procedures and controls to ensure the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, is included in all subawards to subrecipients. View of Responsible Officials and Corrective Action Plan –The Agency agrees with the finding. When granting funds as a subaward to a pass-through entity, the Agency will update its master templates for subawards to include the required information. In addition, when the sub agreements are routed for signature and reviewed by the Chief Financial Officer, they will be double-checked to ensure compliance with this requirement
Assistance Listing Number, Federal Agency, and Program Name: Assistance Listing Number 64.033, Department of Veteran Affairs, VA Supportive Services for Veteran Families Program Federal Award Identification Number and Year: 21-MI-221, 22-MI-221, 20-MI-221-SS, 20-MI-221-LT, 20-MI-221 Pass-through Entity – N/A Finding Type – Significant deficiency in internal control over compliance Repeat Finding – No Criteria – Per 2 CFR 200.332 all pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity;(x) Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of the Federal agency, pass-through entity, and contact information for awarding official of the pass-through entity; (xii) Assistance Listings title and number; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at the time of disbursement; (xiii) Identification of whether the Federal award is for research and development; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is used in accordance with § 200.414) Condition – During our test work, we noted one instance where the subaward was not clearly identified to the subrecipient as a subaward and did not include the information as noted in 2 CFR 200.332. The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, was included in the grant agreement of its subrecipient. Identification of How Questioned Costs Were Computed – N/A Questioned Costs – None Cause/Effect – The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, were included in the grant agreement of its subrecipient. As a result, required information was omitted.Recommendation – We recommend that management review its procedures and controls to ensure the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, is included in all subawards to subrecipients. View of Responsible Officials and Corrective Action Plan –The Agency agrees with the finding. When granting funds as a subaward to a pass-through entity, the Agency will update its master templates for subawards to include the required information. In addition, when the sub agreements are routed for signature and reviewed by the Chief Financial Officer, they will be double-checked to ensure compliance with this requirement
Assistance Listing Number, Federal Agency, and Program Name: Assistance Listing Number 64.033, Department of Veteran Affairs, VA Supportive Services for Veteran Families Program Federal Award Identification Number and Year: 21-MI-221, 22-MI-221, 20-MI-221-SS, 20-MI-221-LT, 20-MI-221 Pass-through Entity – N/A Finding Type – Significant deficiency in internal control over compliance Repeat Finding – No Criteria – Per 2 CFR 200.332 all pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity;(x) Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of the Federal agency, pass-through entity, and contact information for awarding official of the pass-through entity; (xii) Assistance Listings title and number; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at the time of disbursement; (xiii) Identification of whether the Federal award is for research and development; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is used in accordance with § 200.414) Condition – During our test work, we noted one instance where the subaward was not clearly identified to the subrecipient as a subaward and did not include the information as noted in 2 CFR 200.332. The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, was included in the grant agreement of its subrecipient. Identification of How Questioned Costs Were Computed – N/A Questioned Costs – None Cause/Effect – The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, were included in the grant agreement of its subrecipient. As a result, required information was omitted.Recommendation – We recommend that management review its procedures and controls to ensure the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, is included in all subawards to subrecipients. View of Responsible Officials and Corrective Action Plan –The Agency agrees with the finding. When granting funds as a subaward to a pass-through entity, the Agency will update its master templates for subawards to include the required information. In addition, when the sub agreements are routed for signature and reviewed by the Chief Financial Officer, they will be double-checked to ensure compliance with this requirement
Assistance Listing Number, Federal Agency, and Program Name: Assistance Listing Number 64.033, Department of Veteran Affairs, VA Supportive Services for Veteran Families Program Federal Award Identification Number and Year: 21-MI-221, 22-MI-221, 20-MI-221-SS, 20-MI-221-LT, 20-MI-221 Pass-through Entity – N/A Finding Type – Significant deficiency in internal control over compliance Repeat Finding – No Criteria – Per 2 CFR 200.332 all pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity;(x) Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of the Federal agency, pass-through entity, and contact information for awarding official of the pass-through entity; (xii) Assistance Listings title and number; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at the time of disbursement; (xiii) Identification of whether the Federal award is for research and development; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is used in accordance with § 200.414) Condition – During our test work, we noted one instance where the subaward was not clearly identified to the subrecipient as a subaward and did not include the information as noted in 2 CFR 200.332. The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, was included in the grant agreement of its subrecipient. Identification of How Questioned Costs Were Computed – N/A Questioned Costs – None Cause/Effect – The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, were included in the grant agreement of its subrecipient. As a result, required information was omitted.Recommendation – We recommend that management review its procedures and controls to ensure the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, is included in all subawards to subrecipients. View of Responsible Officials and Corrective Action Plan –The Agency agrees with the finding. When granting funds as a subaward to a pass-through entity, the Agency will update its master templates for subawards to include the required information. In addition, when the sub agreements are routed for signature and reviewed by the Chief Financial Officer, they will be double-checked to ensure compliance with this requirement
Assistance Listing Number, Federal Agency, and Program Name: Assistance Listing Number 64.033, Department of Veteran Affairs, VA Supportive Services for Veteran Families Program Federal Award Identification Number and Year: 21-MI-221, 22-MI-221, 20-MI-221-SS, 20-MI-221-LT, 20-MI-221 Pass-through Entity – N/A Finding Type – Significant deficiency in internal control over compliance Repeat Finding – No Criteria – Per 2 CFR 200.332 all pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity;(x) Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of the Federal agency, pass-through entity, and contact information for awarding official of the pass-through entity; (xii) Assistance Listings title and number; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at the time of disbursement; (xiii) Identification of whether the Federal award is for research and development; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is used in accordance with § 200.414) Condition – During our test work, we noted one instance where the subaward was not clearly identified to the subrecipient as a subaward and did not include the information as noted in 2 CFR 200.332. The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, was included in the grant agreement of its subrecipient. Identification of How Questioned Costs Were Computed – N/A Questioned Costs – None Cause/Effect – The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, were included in the grant agreement of its subrecipient. As a result, required information was omitted.Recommendation – We recommend that management review its procedures and controls to ensure the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, is included in all subawards to subrecipients. View of Responsible Officials and Corrective Action Plan –The Agency agrees with the finding. When granting funds as a subaward to a pass-through entity, the Agency will update its master templates for subawards to include the required information. In addition, when the sub agreements are routed for signature and reviewed by the Chief Financial Officer, they will be double-checked to ensure compliance with this requirement
Assistance Listing Number, Federal Agency, and Program Name: Assistance Listing Number 93.569, Department of Health and Human Services, Community Services Block Grant Federal Award Identification Number and Year: E20230009-001, E20230816-01/E20242466-10, E20234409-002, E20234742-00 Pass-through Entity – Michigan Department of Human Services Finding Type – Significant deficiency in internal control over compliance Repeat Finding – No Criteria – Per 2 CFR 200.332 all pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of the Federal agency, pass-through entity, and contact information for awarding official of the pass-through entity; (xii) Assistance Listings title and number; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at the time of disbursement; (xiii) Identification of whether the Federal award is for research and development; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is used in accordance with § 200.414) Condition – During our test work, we noted one instance where the subaward was not clearly identified to the subrecipient as a subaward and did not include the information as noted in 2 CFR 200.332. The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, was included in the grant agreement of its subrecipient. Identification of How Questioned Costs Were Computed – N/A Questioned Costs – None Cause/Effect – The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, were included in the grant agreement of its subrecipient. As a result, required information was omitted. Recommendation – We recommend that management review its procedures and controls to ensure the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, is included in all subawards to subrecipients. View of Responsible Officials and Corrective Action Plan –The Agency agrees with the finding. When granting funds as a subaward to a pass-through entity, the Agency will update its master templates for subawards to include the required information. In addition, when the sub agreements are routed for signature and reviewed by the Chief Financial Officer, they will be double-checked to ensure compliance with this requirement.
Assistance Listing Number, Federal Agency, and Program Name: Assistance Listing Number 93.569, Department of Health and Human Services, Community Services Block Grant Federal Award Identification Number and Year: E20230009-001, E20230816-01/E20242466-10, E20234409-002, E20234742-00 Pass-through Entity – Michigan Department of Human Services Finding Type – Significant deficiency in internal control over compliance Repeat Finding – No Criteria – Per 2 CFR 200.332 all pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of the Federal agency, pass-through entity, and contact information for awarding official of the pass-through entity; (xii) Assistance Listings title and number; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at the time of disbursement; (xiii) Identification of whether the Federal award is for research and development; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is used in accordance with § 200.414) Condition – During our test work, we noted one instance where the subaward was not clearly identified to the subrecipient as a subaward and did not include the information as noted in 2 CFR 200.332. The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, was included in the grant agreement of its subrecipient. Identification of How Questioned Costs Were Computed – N/A Questioned Costs – None Cause/Effect – The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, were included in the grant agreement of its subrecipient. As a result, required information was omitted. Recommendation – We recommend that management review its procedures and controls to ensure the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, is included in all subawards to subrecipients. View of Responsible Officials and Corrective Action Plan –The Agency agrees with the finding. When granting funds as a subaward to a pass-through entity, the Agency will update its master templates for subawards to include the required information. In addition, when the sub agreements are routed for signature and reviewed by the Chief Financial Officer, they will be double-checked to ensure compliance with this requirement.
Assistance Listing Number, Federal Agency, and Program Name: Assistance Listing Number 93.569, Department of Health and Human Services, Community Services Block Grant Federal Award Identification Number and Year: E20230009-001, E20230816-01/E20242466-10, E20234409-002, E20234742-00 Pass-through Entity – Michigan Department of Human Services Finding Type – Significant deficiency in internal control over compliance Repeat Finding – No Criteria – Per 2 CFR 200.332 all pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of the Federal agency, pass-through entity, and contact information for awarding official of the pass-through entity; (xii) Assistance Listings title and number; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at the time of disbursement; (xiii) Identification of whether the Federal award is for research and development; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is used in accordance with § 200.414) Condition – During our test work, we noted one instance where the subaward was not clearly identified to the subrecipient as a subaward and did not include the information as noted in 2 CFR 200.332. The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, was included in the grant agreement of its subrecipient. Identification of How Questioned Costs Were Computed – N/A Questioned Costs – None Cause/Effect – The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, were included in the grant agreement of its subrecipient. As a result, required information was omitted. Recommendation – We recommend that management review its procedures and controls to ensure the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, is included in all subawards to subrecipients. View of Responsible Officials and Corrective Action Plan –The Agency agrees with the finding. When granting funds as a subaward to a pass-through entity, the Agency will update its master templates for subawards to include the required information. In addition, when the sub agreements are routed for signature and reviewed by the Chief Financial Officer, they will be double-checked to ensure compliance with this requirement.
Assistance Listing Number, Federal Agency, and Program Name: Assistance Listing Number 93.569, Department of Health and Human Services, Community Services Block Grant Federal Award Identification Number and Year: E20230009-001, E20230816-01/E20242466-10, E20234409-002, E20234742-00 Pass-through Entity – Michigan Department of Human Services Finding Type – Significant deficiency in internal control over compliance Repeat Finding – No Criteria – Per 2 CFR 200.332 all pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of the Federal agency, pass-through entity, and contact information for awarding official of the pass-through entity; (xii) Assistance Listings title and number; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at the time of disbursement; (xiii) Identification of whether the Federal award is for research and development; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is used in accordance with § 200.414) Condition – During our test work, we noted one instance where the subaward was not clearly identified to the subrecipient as a subaward and did not include the information as noted in 2 CFR 200.332. The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, was included in the grant agreement of its subrecipient. Identification of How Questioned Costs Were Computed – N/A Questioned Costs – None Cause/Effect – The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, were included in the grant agreement of its subrecipient. As a result, required information was omitted. Recommendation – We recommend that management review its procedures and controls to ensure the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, is included in all subawards to subrecipients. View of Responsible Officials and Corrective Action Plan –The Agency agrees with the finding. When granting funds as a subaward to a pass-through entity, the Agency will update its master templates for subawards to include the required information. In addition, when the sub agreements are routed for signature and reviewed by the Chief Financial Officer, they will be double-checked to ensure compliance with this requirement.
Information on the federal program _ Assistance Listing Number 10.557, Special Supplemental Nutrition Program for Women, Infants, and Children, Department of Agriculture; Assistance Listing Number 93.676, Unaccompanied Alien Children Program, Department of Health and Human Services; Assistance Listing Number 93.870, Maternal, Infant and Early Childhood Home Visiting Grant Program, Department of Health and Human Services Criteria or specific requirement – As stated in 2 CFR §200.303, the non-federal entity (i.e., the Organization) 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 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 in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). According to 2 CFR §200.414 Subpart F, Appendix IV, Section C.2.f, the provisional and final rates must be negotiated where neither predetermined nor fixed rates are appropriate. Predetermined or fixed rates may replace provisional rates at any time prior to the close of the organization's fiscal year. If that event does not occur, a final rate will be established and upward or downward adjustments will be made based on the actual allowable costs incurred for the period involved. Condition – During our review of the Organization’s indirect cost rate calculation, we were unable to be provided with a true-up of actual indirect costs based on the final rates versus the provisional rates used by the Organization. Cause – The Organization did not have internal controls in place to ensure that the provisional rate utilized was in line with actual allowable costs incurred for the period involved. Effect or potential effect – Total indirect costs charged by the Organization may not be in line with the final rates determined by the oversight agency. Questioned costs – None Context – 3 out of 4 major programs tested did not have calculated indirect cost rates that agreed with their respective agreements. Identification as a repeat finding, if applicable – Is a repeat finding (2022-008) Recommendation – We recommend the Organization establish an internal control procedure to ensure that indirect costs charged to the federal program using the provisional rate are appropriately adjusted, if necessary, based on actual costs incurred. We recommend that on an annual basis, the Organization obtain an updated Nonprofit Rate Agreement from the federal government that shows final approved rates based on actual costs. Views of responsible officials and planned corrective actions – See separate auditee document for planned corrective action.
Information on the federal program _ Assistance Listing Number 10.557, Special Supplemental Nutrition Program for Women, Infants, and Children, Department of Agriculture; Assistance Listing Number 93.676, Unaccompanied Alien Children Program, Department of Health and Human Services; Assistance Listing Number 93.870, Maternal, Infant and Early Childhood Home Visiting Grant Program, Department of Health and Human Services Criteria or specific requirement – As stated in 2 CFR §200.303, the non-federal entity (i.e., the Organization) 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 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 in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). According to 2 CFR §200.414 Subpart F, Appendix IV, Section C.2.f, the provisional and final rates must be negotiated where neither predetermined nor fixed rates are appropriate. Predetermined or fixed rates may replace provisional rates at any time prior to the close of the organization's fiscal year. If that event does not occur, a final rate will be established and upward or downward adjustments will be made based on the actual allowable costs incurred for the period involved. Condition – During our review of the Organization’s indirect cost rate calculation, we were unable to be provided with a true-up of actual indirect costs based on the final rates versus the provisional rates used by the Organization. Cause – The Organization did not have internal controls in place to ensure that the provisional rate utilized was in line with actual allowable costs incurred for the period involved. Effect or potential effect – Total indirect costs charged by the Organization may not be in line with the final rates determined by the oversight agency. Questioned costs – None Context – 3 out of 4 major programs tested did not have calculated indirect cost rates that agreed with their respective agreements. Identification as a repeat finding, if applicable – Is a repeat finding (2022-008) Recommendation – We recommend the Organization establish an internal control procedure to ensure that indirect costs charged to the federal program using the provisional rate are appropriately adjusted, if necessary, based on actual costs incurred. We recommend that on an annual basis, the Organization obtain an updated Nonprofit Rate Agreement from the federal government that shows final approved rates based on actual costs. Views of responsible officials and planned corrective actions – See separate auditee document for planned corrective action.
Information on the federal program _ Assistance Listing Number 10.557, Special Supplemental Nutrition Program for Women, Infants, and Children, Department of Agriculture; Assistance Listing Number 93.676, Unaccompanied Alien Children Program, Department of Health and Human Services; Assistance Listing Number 93.870, Maternal, Infant and Early Childhood Home Visiting Grant Program, Department of Health and Human Services Criteria or specific requirement – As stated in 2 CFR §200.303, the non-federal entity (i.e., the Organization) 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 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 in the “Internal Control Integrated Framework” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). According to 2 CFR §200.414 Subpart F, Appendix IV, Section C.2.f, the provisional and final rates must be negotiated where neither predetermined nor fixed rates are appropriate. Predetermined or fixed rates may replace provisional rates at any time prior to the close of the organization's fiscal year. If that event does not occur, a final rate will be established and upward or downward adjustments will be made based on the actual allowable costs incurred for the period involved. Condition – During our review of the Organization’s indirect cost rate calculation, we were unable to be provided with a true-up of actual indirect costs based on the final rates versus the provisional rates used by the Organization. Cause – The Organization did not have internal controls in place to ensure that the provisional rate utilized was in line with actual allowable costs incurred for the period involved. Effect or potential effect – Total indirect costs charged by the Organization may not be in line with the final rates determined by the oversight agency. Questioned costs – None Context – 3 out of 4 major programs tested did not have calculated indirect cost rates that agreed with their respective agreements. Identification as a repeat finding, if applicable – Is a repeat finding (2022-008) Recommendation – We recommend the Organization establish an internal control procedure to ensure that indirect costs charged to the federal program using the provisional rate are appropriately adjusted, if necessary, based on actual costs incurred. We recommend that on an annual basis, the Organization obtain an updated Nonprofit Rate Agreement from the federal government that shows final approved rates based on actual costs. Views of responsible officials and planned corrective actions – See separate auditee document for planned corrective action.
Material Weakness/Noncompliance – Other 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a. List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. For example, the National Institutes of Health is a major subdivision in the Department of Health and Human Services. b. For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c. Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d. Include the total amount provided to subrecipients from each Federal program. e. For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f. Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The Village did not prepare a Schedule of Expenditures of Federal Awards. Not preparing the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the Village and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the Village review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Other 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a. List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. For example, the National Institutes of Health is a major subdivision in the Department of Health and Human Services. b. For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c. Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d. Include the total amount provided to subrecipients from each Federal program. e. For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f. Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The Village did not prepare a Schedule of Expenditures of Federal Awards. Not preparing the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the Village and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the Village review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Other 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a. List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. For example, the National Institutes of Health is a major subdivision in the Department of Health and Human Services. b. For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c. Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d. Include the total amount provided to subrecipients from each Federal program. e. For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f. Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The Village did not prepare a Schedule of Expenditures of Federal Awards. Not preparing the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the Village and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the Village review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Questioned Costs: $44,046 - The overbilled amount has been reclassified to a liability to the funder but has not been repaid or settled. Criteria: In accordance with 2 CFR § 200.403 and 2 CFR § 200.405, costs charged to federal awards must be allowable, allocable, and necessary to the performance of the federal award. Under the terms of a cost-reimbursement federal contract, as governed by 2 CFR § 200.403, § 200.404, and § 200.405, all costs charged to a federal award must be: • Actually incurred, • Allocable to the program, • Allowable under federal cost principles, and • Supported by adequate documentation. Under 2 CFR § 200.414 indirect costs may only be charged based on an approved rate (e.g., NICRA or de minimis), applied to the proper base and only if such costs are actually incurred during the performance period. Billing the full invoice amount of shared costs without allocating based on an approved indirect cost rate is not compliant with Uniform Guidance. Condition: The Organization billed indirect costs totaling $45,096 to a federal cost-reimbursement contract, despite not having incurred qualifying indirect costs during the contract period. The Organization charged entire invoice amounts for shared indirect costs. The billed amounts were based solely on the approved indirect cost rate applied to direct cost invoices, however, there is a maximum of $1,050 in actual indirect expenses for administrative support, or other shared costs incurred or allocated. Cause: The Organization misinterpreted the cost allocation rules and did not have an adequate process for applying the approved indirect cost rate. Billing practices defaulted to charging the entire invoice amount to federal awards when costs benefitted multiple programs. The Organization lacked adequate controls over indirect cost invoicing and did not perform timely reconciliations between budgeted and actual costs incurred. The outside accountant relied on budgeted percentages rather than actual expenses, and there was no final adjustment process in place to reconcile at year-end. Effect: The Organization received $44,046 in federal funds that were not supported by actual indirect costs incurred. These funds represent unallowable costs and are considered questioned costs under the Uniform Guidance. Identification of Repeat Finding ☐ Yes ☑ No Recommendation: We recommend that the Organization: • Implement policies and procedures to reconcile indirect costs billed to actual costs incurred. • Implement a post-invoicing reconciliation process to compare actual indirect costs with amounts billed. • Ensure that all invoicing for federal awards complies with the approved indirect cost rate agreement. • Return the $44,046 of unexpended indirect cost reimbursements to the granting agency. • Provide additional training to accounting and grants management staff on the treatment of indirect costs under 2 CFR Part 200.
Finding number: 2023-006 Significant Deficiency in Internal Control Over Compliance: Allowable Costs and Activities Federal Program #1 HIV Emergency Relief Project Grants: CFDA Number 93.914 Federal Program #2 HIV Care Formula Grants: CFDA Number 93.917 Federal Program #2 HIV Prevention Activities: CFDA Number: 93.941 Name of federal agency: U.S. Department of Health and Human Services (HHS) AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Name of pass-through entity: Multiple Repeat finding: No Criteria: 2 CFR §200.405 requires that costs be allocable to the federal program based on relative benefits received and be supported by appropriate documentation. For personnel costs, 2 CFR §200.430(i) requires that compensation for employees whose time is charged to federal awards be based on records that accurately reflect the work performed, such as time and effort reporting or equivalent documentation. For shared costs, 2 CFR §200.412-200.414 requires that cost allocations be based on documented methodologies that are reasonable and supported by underlying calculations. Condition: The Organization does not have formalized internal controls to support the rationale for allocation of shared costs and employee time across federal programs. Specifically: Time and effort is being tracked and maintained by employees, including hours charged to the specific efforts for the programs. Often, employees charge hours to specific programs in excess of amounts allocated to the program as expenditures. The specific amount of employee salaries and wages that are allocated to specific federal programs for reimbursement, and which are less than the amounts reflected in the time and effort records, are determined by members of the finance staff. The rationale for the amount actually allocated for reimbursement, if less than the amount reflected in the time and effort records, is not documented. Review and approval of the allocation of employee compensation to specific federal programs reimbursement requests is not maintained. Cause: The deficiency exists because the Organization has not implemented a structured process for documenting the extent to which allowable compensation costs will be allocated for reimbursement to specific federal programs in instances where the allowable compensation cost exceeds the amount allocated for reimbursement. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Possible effect: The absence of documented allocation methodologies in instances where allowable compensation costs exceed the amount allocated for reimbursement increases the risk that: Costs may be improperly allocated between federal programs, resulting in potential noncompliance with federal cost principles. Federal expenditures may be misstated, impacting financial and grant reporting. Although questioned costs were not identified, the lack of specific supporting documentation and controls represents a significant deficiency in internal control over compliance. Questioned cost: None identified at this time. Recommendation: We recommend that the Organization implement the following corrective actions: 1. Develop and Implement a Written Cost Allocation Policy – Establish a formal policy outlining the methodology for allocating shared costs and personnel time across programs, especially in instances where allowable costs exceed amounts allocated for reimbursement, ensuring compliance with 2 CFR Part 200 cost principles. 2. Document Allocation Methodologies for Shared Costs – Ensure that allocations for shared costs (e.g., rent, utilities, and administrative expenses) are based on a reasonable and documented methodology that can be reviewed and reperformed. 3. Retain Evidence of Implementation of Internal Controls - Implement review and approval controls over all requests for reimbursement, including review and approval of allocation of personnel and shared costs to specific funding sources. In circumstances where costs can be appropriately allocated to multiple funding sources, document the rationale for allocating the specific amount to each funding source. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Views of responsible officials: Management respectfully disagrees with this Finding. Under Condition, the finding states, “Time and effort is being tracked and maintained by employees, including hours charged to the specific efforts for the programs.…” This is not accurate. Employees report their time worked each day, including the amount of time they worked on different projects if applicable. Employees report this in our commercial HRIS/Payroll system, where it is maintained and where it is reviewed and approved by the employee’s manager. The employees report the time they worked and which project(s) they worked on, their managers review and approve the time and the distribution, and the data is tracked and maintained in our HRIS/Payroll system (ExponentHR). Also under Condition, the finding states, “The specific amount of employee salaries and wages that are allocated to specific federal programs for reimbursement, and which are less than the amounts reflected in time and effort records, are determined by members of the finance staff.” It is correct that we would have to invoice sponsors for less than the total cost of an employee’s allocated time and effort if a sponsor’s budget is not sufficient to cover that full amount. This is the correct procedure to follow. Employees correctly continue documenting their hours worked on a specific project even if the budget is expended and the accounting staff can no longer bill the sponsor. If a particular grant does not have sufficient sponsor funds, then the Grants Accounting staff reduce the bill accordingly. Also under Condition, the finding states, “The rationale for the amount actually allocated for reimbursement, if less than the amount reflected in time and effort records, is not documented”. This is incorrect. Our monthly invoices to each sponsor accumulate, with each invoice clearly showing not only that month’s expense but also the year-to-date expense and remaining balance, which forces the sponsor invoice to stop at an amount less than the total cost of employees’ time and effort when the budget is exhausted. Also under Condition, the finding states, “Review and approval of the allocation of employee compensation to specific federal programs reimbursement requests is not maintained.” Each employee records their hours worked, and the project(s) on which they worked those hours, in our HRIS/Payroll system. The employee’s manager reviews and approves both the hours worked and the projects on which the hours were worked. This review and approval is maintained in our HRIS/Payroll system. Financial staff calculate the amount to allocate to specific federal programs based on these HRIS/Payroll system records (or other records such as clinical units produced, based on the terms of each grant). Separate accounting staff review the sponsor invoice and post the Receivable once they deem the invoice correct. Under Cause, the finding states, “…..the Organization has not implemented a structured process for documenting the extent to which allowable [emphasis added] compensation costs will be allocated for reimbursement to specific federal programs in instances where the allowable compensation cost exceeds the amount allocated for reimbursement.” This means that we do not have a AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) process for documenting how much of a payroll expense already deemed allowable on a particular grant will actually be invoiced there. We disagree and believe that the presence and documentation of a limited sponsor budget, along with cumulative tracking and documentation of compensation expenses against that budget, proves and documents why sometimes full compensation costs are not charged to a grant. Under Possible Effect, the finding addresses possible effects of “the absence of documented allocation methodologies.” We don’t agree that our process could lead to improper allocation between federal programs (as the finding states) nor to misstating federal expenditures (as the finding states). When a sponsor’s budget is insufficient to cover its appropriately allocated compensation costs, those costs are paid from unrestricted, non-federal funds. As also noted in the finding, no questioned costs were identified.
Finding number: 2023-006 Significant Deficiency in Internal Control Over Compliance: Allowable Costs and Activities Federal Program #1 HIV Emergency Relief Project Grants: CFDA Number 93.914 Federal Program #2 HIV Care Formula Grants: CFDA Number 93.917 Federal Program #2 HIV Prevention Activities: CFDA Number: 93.941 Name of federal agency: U.S. Department of Health and Human Services (HHS) AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Name of pass-through entity: Multiple Repeat finding: No Criteria: 2 CFR §200.405 requires that costs be allocable to the federal program based on relative benefits received and be supported by appropriate documentation. For personnel costs, 2 CFR §200.430(i) requires that compensation for employees whose time is charged to federal awards be based on records that accurately reflect the work performed, such as time and effort reporting or equivalent documentation. For shared costs, 2 CFR §200.412-200.414 requires that cost allocations be based on documented methodologies that are reasonable and supported by underlying calculations. Condition: The Organization does not have formalized internal controls to support the rationale for allocation of shared costs and employee time across federal programs. Specifically: Time and effort is being tracked and maintained by employees, including hours charged to the specific efforts for the programs. Often, employees charge hours to specific programs in excess of amounts allocated to the program as expenditures. The specific amount of employee salaries and wages that are allocated to specific federal programs for reimbursement, and which are less than the amounts reflected in the time and effort records, are determined by members of the finance staff. The rationale for the amount actually allocated for reimbursement, if less than the amount reflected in the time and effort records, is not documented. Review and approval of the allocation of employee compensation to specific federal programs reimbursement requests is not maintained. Cause: The deficiency exists because the Organization has not implemented a structured process for documenting the extent to which allowable compensation costs will be allocated for reimbursement to specific federal programs in instances where the allowable compensation cost exceeds the amount allocated for reimbursement. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Possible effect: The absence of documented allocation methodologies in instances where allowable compensation costs exceed the amount allocated for reimbursement increases the risk that: Costs may be improperly allocated between federal programs, resulting in potential noncompliance with federal cost principles. Federal expenditures may be misstated, impacting financial and grant reporting. Although questioned costs were not identified, the lack of specific supporting documentation and controls represents a significant deficiency in internal control over compliance. Questioned cost: None identified at this time. Recommendation: We recommend that the Organization implement the following corrective actions: 1. Develop and Implement a Written Cost Allocation Policy – Establish a formal policy outlining the methodology for allocating shared costs and personnel time across programs, especially in instances where allowable costs exceed amounts allocated for reimbursement, ensuring compliance with 2 CFR Part 200 cost principles. 2. Document Allocation Methodologies for Shared Costs – Ensure that allocations for shared costs (e.g., rent, utilities, and administrative expenses) are based on a reasonable and documented methodology that can be reviewed and reperformed. 3. Retain Evidence of Implementation of Internal Controls - Implement review and approval controls over all requests for reimbursement, including review and approval of allocation of personnel and shared costs to specific funding sources. In circumstances where costs can be appropriately allocated to multiple funding sources, document the rationale for allocating the specific amount to each funding source. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Views of responsible officials: Management respectfully disagrees with this Finding. Under Condition, the finding states, “Time and effort is being tracked and maintained by employees, including hours charged to the specific efforts for the programs.…” This is not accurate. Employees report their time worked each day, including the amount of time they worked on different projects if applicable. Employees report this in our commercial HRIS/Payroll system, where it is maintained and where it is reviewed and approved by the employee’s manager. The employees report the time they worked and which project(s) they worked on, their managers review and approve the time and the distribution, and the data is tracked and maintained in our HRIS/Payroll system (ExponentHR). Also under Condition, the finding states, “The specific amount of employee salaries and wages that are allocated to specific federal programs for reimbursement, and which are less than the amounts reflected in time and effort records, are determined by members of the finance staff.” It is correct that we would have to invoice sponsors for less than the total cost of an employee’s allocated time and effort if a sponsor’s budget is not sufficient to cover that full amount. This is the correct procedure to follow. Employees correctly continue documenting their hours worked on a specific project even if the budget is expended and the accounting staff can no longer bill the sponsor. If a particular grant does not have sufficient sponsor funds, then the Grants Accounting staff reduce the bill accordingly. Also under Condition, the finding states, “The rationale for the amount actually allocated for reimbursement, if less than the amount reflected in time and effort records, is not documented”. This is incorrect. Our monthly invoices to each sponsor accumulate, with each invoice clearly showing not only that month’s expense but also the year-to-date expense and remaining balance, which forces the sponsor invoice to stop at an amount less than the total cost of employees’ time and effort when the budget is exhausted. Also under Condition, the finding states, “Review and approval of the allocation of employee compensation to specific federal programs reimbursement requests is not maintained.” Each employee records their hours worked, and the project(s) on which they worked those hours, in our HRIS/Payroll system. The employee’s manager reviews and approves both the hours worked and the projects on which the hours were worked. This review and approval is maintained in our HRIS/Payroll system. Financial staff calculate the amount to allocate to specific federal programs based on these HRIS/Payroll system records (or other records such as clinical units produced, based on the terms of each grant). Separate accounting staff review the sponsor invoice and post the Receivable once they deem the invoice correct. Under Cause, the finding states, “…..the Organization has not implemented a structured process for documenting the extent to which allowable [emphasis added] compensation costs will be allocated for reimbursement to specific federal programs in instances where the allowable compensation cost exceeds the amount allocated for reimbursement.” This means that we do not have a AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) process for documenting how much of a payroll expense already deemed allowable on a particular grant will actually be invoiced there. We disagree and believe that the presence and documentation of a limited sponsor budget, along with cumulative tracking and documentation of compensation expenses against that budget, proves and documents why sometimes full compensation costs are not charged to a grant. Under Possible Effect, the finding addresses possible effects of “the absence of documented allocation methodologies.” We don’t agree that our process could lead to improper allocation between federal programs (as the finding states) nor to misstating federal expenditures (as the finding states). When a sponsor’s budget is insufficient to cover its appropriately allocated compensation costs, those costs are paid from unrestricted, non-federal funds. As also noted in the finding, no questioned costs were identified.
Finding number: 2023-006 Significant Deficiency in Internal Control Over Compliance: Allowable Costs and Activities Federal Program #1 HIV Emergency Relief Project Grants: CFDA Number 93.914 Federal Program #2 HIV Care Formula Grants: CFDA Number 93.917 Federal Program #2 HIV Prevention Activities: CFDA Number: 93.941 Name of federal agency: U.S. Department of Health and Human Services (HHS) AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Name of pass-through entity: Multiple Repeat finding: No Criteria: 2 CFR §200.405 requires that costs be allocable to the federal program based on relative benefits received and be supported by appropriate documentation. For personnel costs, 2 CFR §200.430(i) requires that compensation for employees whose time is charged to federal awards be based on records that accurately reflect the work performed, such as time and effort reporting or equivalent documentation. For shared costs, 2 CFR §200.412-200.414 requires that cost allocations be based on documented methodologies that are reasonable and supported by underlying calculations. Condition: The Organization does not have formalized internal controls to support the rationale for allocation of shared costs and employee time across federal programs. Specifically: Time and effort is being tracked and maintained by employees, including hours charged to the specific efforts for the programs. Often, employees charge hours to specific programs in excess of amounts allocated to the program as expenditures. The specific amount of employee salaries and wages that are allocated to specific federal programs for reimbursement, and which are less than the amounts reflected in the time and effort records, are determined by members of the finance staff. The rationale for the amount actually allocated for reimbursement, if less than the amount reflected in the time and effort records, is not documented. Review and approval of the allocation of employee compensation to specific federal programs reimbursement requests is not maintained. Cause: The deficiency exists because the Organization has not implemented a structured process for documenting the extent to which allowable compensation costs will be allocated for reimbursement to specific federal programs in instances where the allowable compensation cost exceeds the amount allocated for reimbursement. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Possible effect: The absence of documented allocation methodologies in instances where allowable compensation costs exceed the amount allocated for reimbursement increases the risk that: Costs may be improperly allocated between federal programs, resulting in potential noncompliance with federal cost principles. Federal expenditures may be misstated, impacting financial and grant reporting. Although questioned costs were not identified, the lack of specific supporting documentation and controls represents a significant deficiency in internal control over compliance. Questioned cost: None identified at this time. Recommendation: We recommend that the Organization implement the following corrective actions: 1. Develop and Implement a Written Cost Allocation Policy – Establish a formal policy outlining the methodology for allocating shared costs and personnel time across programs, especially in instances where allowable costs exceed amounts allocated for reimbursement, ensuring compliance with 2 CFR Part 200 cost principles. 2. Document Allocation Methodologies for Shared Costs – Ensure that allocations for shared costs (e.g., rent, utilities, and administrative expenses) are based on a reasonable and documented methodology that can be reviewed and reperformed. 3. Retain Evidence of Implementation of Internal Controls - Implement review and approval controls over all requests for reimbursement, including review and approval of allocation of personnel and shared costs to specific funding sources. In circumstances where costs can be appropriately allocated to multiple funding sources, document the rationale for allocating the specific amount to each funding source. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Views of responsible officials: Management respectfully disagrees with this Finding. Under Condition, the finding states, “Time and effort is being tracked and maintained by employees, including hours charged to the specific efforts for the programs.…” This is not accurate. Employees report their time worked each day, including the amount of time they worked on different projects if applicable. Employees report this in our commercial HRIS/Payroll system, where it is maintained and where it is reviewed and approved by the employee’s manager. The employees report the time they worked and which project(s) they worked on, their managers review and approve the time and the distribution, and the data is tracked and maintained in our HRIS/Payroll system (ExponentHR). Also under Condition, the finding states, “The specific amount of employee salaries and wages that are allocated to specific federal programs for reimbursement, and which are less than the amounts reflected in time and effort records, are determined by members of the finance staff.” It is correct that we would have to invoice sponsors for less than the total cost of an employee’s allocated time and effort if a sponsor’s budget is not sufficient to cover that full amount. This is the correct procedure to follow. Employees correctly continue documenting their hours worked on a specific project even if the budget is expended and the accounting staff can no longer bill the sponsor. If a particular grant does not have sufficient sponsor funds, then the Grants Accounting staff reduce the bill accordingly. Also under Condition, the finding states, “The rationale for the amount actually allocated for reimbursement, if less than the amount reflected in time and effort records, is not documented”. This is incorrect. Our monthly invoices to each sponsor accumulate, with each invoice clearly showing not only that month’s expense but also the year-to-date expense and remaining balance, which forces the sponsor invoice to stop at an amount less than the total cost of employees’ time and effort when the budget is exhausted. Also under Condition, the finding states, “Review and approval of the allocation of employee compensation to specific federal programs reimbursement requests is not maintained.” Each employee records their hours worked, and the project(s) on which they worked those hours, in our HRIS/Payroll system. The employee’s manager reviews and approves both the hours worked and the projects on which the hours were worked. This review and approval is maintained in our HRIS/Payroll system. Financial staff calculate the amount to allocate to specific federal programs based on these HRIS/Payroll system records (or other records such as clinical units produced, based on the terms of each grant). Separate accounting staff review the sponsor invoice and post the Receivable once they deem the invoice correct. Under Cause, the finding states, “…..the Organization has not implemented a structured process for documenting the extent to which allowable [emphasis added] compensation costs will be allocated for reimbursement to specific federal programs in instances where the allowable compensation cost exceeds the amount allocated for reimbursement.” This means that we do not have a AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) process for documenting how much of a payroll expense already deemed allowable on a particular grant will actually be invoiced there. We disagree and believe that the presence and documentation of a limited sponsor budget, along with cumulative tracking and documentation of compensation expenses against that budget, proves and documents why sometimes full compensation costs are not charged to a grant. Under Possible Effect, the finding addresses possible effects of “the absence of documented allocation methodologies.” We don’t agree that our process could lead to improper allocation between federal programs (as the finding states) nor to misstating federal expenditures (as the finding states). When a sponsor’s budget is insufficient to cover its appropriately allocated compensation costs, those costs are paid from unrestricted, non-federal funds. As also noted in the finding, no questioned costs were identified.
Finding number: 2023-006 Significant Deficiency in Internal Control Over Compliance: Allowable Costs and Activities Federal Program #1 HIV Emergency Relief Project Grants: CFDA Number 93.914 Federal Program #2 HIV Care Formula Grants: CFDA Number 93.917 Federal Program #2 HIV Prevention Activities: CFDA Number: 93.941 Name of federal agency: U.S. Department of Health and Human Services (HHS) AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Name of pass-through entity: Multiple Repeat finding: No Criteria: 2 CFR §200.405 requires that costs be allocable to the federal program based on relative benefits received and be supported by appropriate documentation. For personnel costs, 2 CFR §200.430(i) requires that compensation for employees whose time is charged to federal awards be based on records that accurately reflect the work performed, such as time and effort reporting or equivalent documentation. For shared costs, 2 CFR §200.412-200.414 requires that cost allocations be based on documented methodologies that are reasonable and supported by underlying calculations. Condition: The Organization does not have formalized internal controls to support the rationale for allocation of shared costs and employee time across federal programs. Specifically: Time and effort is being tracked and maintained by employees, including hours charged to the specific efforts for the programs. Often, employees charge hours to specific programs in excess of amounts allocated to the program as expenditures. The specific amount of employee salaries and wages that are allocated to specific federal programs for reimbursement, and which are less than the amounts reflected in the time and effort records, are determined by members of the finance staff. The rationale for the amount actually allocated for reimbursement, if less than the amount reflected in the time and effort records, is not documented. Review and approval of the allocation of employee compensation to specific federal programs reimbursement requests is not maintained. Cause: The deficiency exists because the Organization has not implemented a structured process for documenting the extent to which allowable compensation costs will be allocated for reimbursement to specific federal programs in instances where the allowable compensation cost exceeds the amount allocated for reimbursement. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Possible effect: The absence of documented allocation methodologies in instances where allowable compensation costs exceed the amount allocated for reimbursement increases the risk that: Costs may be improperly allocated between federal programs, resulting in potential noncompliance with federal cost principles. Federal expenditures may be misstated, impacting financial and grant reporting. Although questioned costs were not identified, the lack of specific supporting documentation and controls represents a significant deficiency in internal control over compliance. Questioned cost: None identified at this time. Recommendation: We recommend that the Organization implement the following corrective actions: 1. Develop and Implement a Written Cost Allocation Policy – Establish a formal policy outlining the methodology for allocating shared costs and personnel time across programs, especially in instances where allowable costs exceed amounts allocated for reimbursement, ensuring compliance with 2 CFR Part 200 cost principles. 2. Document Allocation Methodologies for Shared Costs – Ensure that allocations for shared costs (e.g., rent, utilities, and administrative expenses) are based on a reasonable and documented methodology that can be reviewed and reperformed. 3. Retain Evidence of Implementation of Internal Controls - Implement review and approval controls over all requests for reimbursement, including review and approval of allocation of personnel and shared costs to specific funding sources. In circumstances where costs can be appropriately allocated to multiple funding sources, document the rationale for allocating the specific amount to each funding source. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Views of responsible officials: Management respectfully disagrees with this Finding. Under Condition, the finding states, “Time and effort is being tracked and maintained by employees, including hours charged to the specific efforts for the programs.…” This is not accurate. Employees report their time worked each day, including the amount of time they worked on different projects if applicable. Employees report this in our commercial HRIS/Payroll system, where it is maintained and where it is reviewed and approved by the employee’s manager. The employees report the time they worked and which project(s) they worked on, their managers review and approve the time and the distribution, and the data is tracked and maintained in our HRIS/Payroll system (ExponentHR). Also under Condition, the finding states, “The specific amount of employee salaries and wages that are allocated to specific federal programs for reimbursement, and which are less than the amounts reflected in time and effort records, are determined by members of the finance staff.” It is correct that we would have to invoice sponsors for less than the total cost of an employee’s allocated time and effort if a sponsor’s budget is not sufficient to cover that full amount. This is the correct procedure to follow. Employees correctly continue documenting their hours worked on a specific project even if the budget is expended and the accounting staff can no longer bill the sponsor. If a particular grant does not have sufficient sponsor funds, then the Grants Accounting staff reduce the bill accordingly. Also under Condition, the finding states, “The rationale for the amount actually allocated for reimbursement, if less than the amount reflected in time and effort records, is not documented”. This is incorrect. Our monthly invoices to each sponsor accumulate, with each invoice clearly showing not only that month’s expense but also the year-to-date expense and remaining balance, which forces the sponsor invoice to stop at an amount less than the total cost of employees’ time and effort when the budget is exhausted. Also under Condition, the finding states, “Review and approval of the allocation of employee compensation to specific federal programs reimbursement requests is not maintained.” Each employee records their hours worked, and the project(s) on which they worked those hours, in our HRIS/Payroll system. The employee’s manager reviews and approves both the hours worked and the projects on which the hours were worked. This review and approval is maintained in our HRIS/Payroll system. Financial staff calculate the amount to allocate to specific federal programs based on these HRIS/Payroll system records (or other records such as clinical units produced, based on the terms of each grant). Separate accounting staff review the sponsor invoice and post the Receivable once they deem the invoice correct. Under Cause, the finding states, “…..the Organization has not implemented a structured process for documenting the extent to which allowable [emphasis added] compensation costs will be allocated for reimbursement to specific federal programs in instances where the allowable compensation cost exceeds the amount allocated for reimbursement.” This means that we do not have a AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) process for documenting how much of a payroll expense already deemed allowable on a particular grant will actually be invoiced there. We disagree and believe that the presence and documentation of a limited sponsor budget, along with cumulative tracking and documentation of compensation expenses against that budget, proves and documents why sometimes full compensation costs are not charged to a grant. Under Possible Effect, the finding addresses possible effects of “the absence of documented allocation methodologies.” We don’t agree that our process could lead to improper allocation between federal programs (as the finding states) nor to misstating federal expenditures (as the finding states). When a sponsor’s budget is insufficient to cover its appropriately allocated compensation costs, those costs are paid from unrestricted, non-federal funds. As also noted in the finding, no questioned costs were identified.
Finding number: 2023-006 Significant Deficiency in Internal Control Over Compliance: Allowable Costs and Activities Federal Program #1 HIV Emergency Relief Project Grants: CFDA Number 93.914 Federal Program #2 HIV Care Formula Grants: CFDA Number 93.917 Federal Program #2 HIV Prevention Activities: CFDA Number: 93.941 Name of federal agency: U.S. Department of Health and Human Services (HHS) AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Name of pass-through entity: Multiple Repeat finding: No Criteria: 2 CFR §200.405 requires that costs be allocable to the federal program based on relative benefits received and be supported by appropriate documentation. For personnel costs, 2 CFR §200.430(i) requires that compensation for employees whose time is charged to federal awards be based on records that accurately reflect the work performed, such as time and effort reporting or equivalent documentation. For shared costs, 2 CFR §200.412-200.414 requires that cost allocations be based on documented methodologies that are reasonable and supported by underlying calculations. Condition: The Organization does not have formalized internal controls to support the rationale for allocation of shared costs and employee time across federal programs. Specifically: Time and effort is being tracked and maintained by employees, including hours charged to the specific efforts for the programs. Often, employees charge hours to specific programs in excess of amounts allocated to the program as expenditures. The specific amount of employee salaries and wages that are allocated to specific federal programs for reimbursement, and which are less than the amounts reflected in the time and effort records, are determined by members of the finance staff. The rationale for the amount actually allocated for reimbursement, if less than the amount reflected in the time and effort records, is not documented. Review and approval of the allocation of employee compensation to specific federal programs reimbursement requests is not maintained. Cause: The deficiency exists because the Organization has not implemented a structured process for documenting the extent to which allowable compensation costs will be allocated for reimbursement to specific federal programs in instances where the allowable compensation cost exceeds the amount allocated for reimbursement. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Possible effect: The absence of documented allocation methodologies in instances where allowable compensation costs exceed the amount allocated for reimbursement increases the risk that: Costs may be improperly allocated between federal programs, resulting in potential noncompliance with federal cost principles. Federal expenditures may be misstated, impacting financial and grant reporting. Although questioned costs were not identified, the lack of specific supporting documentation and controls represents a significant deficiency in internal control over compliance. Questioned cost: None identified at this time. Recommendation: We recommend that the Organization implement the following corrective actions: 1. Develop and Implement a Written Cost Allocation Policy – Establish a formal policy outlining the methodology for allocating shared costs and personnel time across programs, especially in instances where allowable costs exceed amounts allocated for reimbursement, ensuring compliance with 2 CFR Part 200 cost principles. 2. Document Allocation Methodologies for Shared Costs – Ensure that allocations for shared costs (e.g., rent, utilities, and administrative expenses) are based on a reasonable and documented methodology that can be reviewed and reperformed. 3. Retain Evidence of Implementation of Internal Controls - Implement review and approval controls over all requests for reimbursement, including review and approval of allocation of personnel and shared costs to specific funding sources. In circumstances where costs can be appropriately allocated to multiple funding sources, document the rationale for allocating the specific amount to each funding source. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Views of responsible officials: Management respectfully disagrees with this Finding. Under Condition, the finding states, “Time and effort is being tracked and maintained by employees, including hours charged to the specific efforts for the programs.…” This is not accurate. Employees report their time worked each day, including the amount of time they worked on different projects if applicable. Employees report this in our commercial HRIS/Payroll system, where it is maintained and where it is reviewed and approved by the employee’s manager. The employees report the time they worked and which project(s) they worked on, their managers review and approve the time and the distribution, and the data is tracked and maintained in our HRIS/Payroll system (ExponentHR). Also under Condition, the finding states, “The specific amount of employee salaries and wages that are allocated to specific federal programs for reimbursement, and which are less than the amounts reflected in time and effort records, are determined by members of the finance staff.” It is correct that we would have to invoice sponsors for less than the total cost of an employee’s allocated time and effort if a sponsor’s budget is not sufficient to cover that full amount. This is the correct procedure to follow. Employees correctly continue documenting their hours worked on a specific project even if the budget is expended and the accounting staff can no longer bill the sponsor. If a particular grant does not have sufficient sponsor funds, then the Grants Accounting staff reduce the bill accordingly. Also under Condition, the finding states, “The rationale for the amount actually allocated for reimbursement, if less than the amount reflected in time and effort records, is not documented”. This is incorrect. Our monthly invoices to each sponsor accumulate, with each invoice clearly showing not only that month’s expense but also the year-to-date expense and remaining balance, which forces the sponsor invoice to stop at an amount less than the total cost of employees’ time and effort when the budget is exhausted. Also under Condition, the finding states, “Review and approval of the allocation of employee compensation to specific federal programs reimbursement requests is not maintained.” Each employee records their hours worked, and the project(s) on which they worked those hours, in our HRIS/Payroll system. The employee’s manager reviews and approves both the hours worked and the projects on which the hours were worked. This review and approval is maintained in our HRIS/Payroll system. Financial staff calculate the amount to allocate to specific federal programs based on these HRIS/Payroll system records (or other records such as clinical units produced, based on the terms of each grant). Separate accounting staff review the sponsor invoice and post the Receivable once they deem the invoice correct. Under Cause, the finding states, “…..the Organization has not implemented a structured process for documenting the extent to which allowable [emphasis added] compensation costs will be allocated for reimbursement to specific federal programs in instances where the allowable compensation cost exceeds the amount allocated for reimbursement.” This means that we do not have a AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) process for documenting how much of a payroll expense already deemed allowable on a particular grant will actually be invoiced there. We disagree and believe that the presence and documentation of a limited sponsor budget, along with cumulative tracking and documentation of compensation expenses against that budget, proves and documents why sometimes full compensation costs are not charged to a grant. Under Possible Effect, the finding addresses possible effects of “the absence of documented allocation methodologies.” We don’t agree that our process could lead to improper allocation between federal programs (as the finding states) nor to misstating federal expenditures (as the finding states). When a sponsor’s budget is insufficient to cover its appropriately allocated compensation costs, those costs are paid from unrestricted, non-federal funds. As also noted in the finding, no questioned costs were identified.
Finding number: 2023-006 Significant Deficiency in Internal Control Over Compliance: Allowable Costs and Activities Federal Program #1 HIV Emergency Relief Project Grants: CFDA Number 93.914 Federal Program #2 HIV Care Formula Grants: CFDA Number 93.917 Federal Program #2 HIV Prevention Activities: CFDA Number: 93.941 Name of federal agency: U.S. Department of Health and Human Services (HHS) AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Name of pass-through entity: Multiple Repeat finding: No Criteria: 2 CFR §200.405 requires that costs be allocable to the federal program based on relative benefits received and be supported by appropriate documentation. For personnel costs, 2 CFR §200.430(i) requires that compensation for employees whose time is charged to federal awards be based on records that accurately reflect the work performed, such as time and effort reporting or equivalent documentation. For shared costs, 2 CFR §200.412-200.414 requires that cost allocations be based on documented methodologies that are reasonable and supported by underlying calculations. Condition: The Organization does not have formalized internal controls to support the rationale for allocation of shared costs and employee time across federal programs. Specifically: Time and effort is being tracked and maintained by employees, including hours charged to the specific efforts for the programs. Often, employees charge hours to specific programs in excess of amounts allocated to the program as expenditures. The specific amount of employee salaries and wages that are allocated to specific federal programs for reimbursement, and which are less than the amounts reflected in the time and effort records, are determined by members of the finance staff. The rationale for the amount actually allocated for reimbursement, if less than the amount reflected in the time and effort records, is not documented. Review and approval of the allocation of employee compensation to specific federal programs reimbursement requests is not maintained. Cause: The deficiency exists because the Organization has not implemented a structured process for documenting the extent to which allowable compensation costs will be allocated for reimbursement to specific federal programs in instances where the allowable compensation cost exceeds the amount allocated for reimbursement. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Possible effect: The absence of documented allocation methodologies in instances where allowable compensation costs exceed the amount allocated for reimbursement increases the risk that: Costs may be improperly allocated between federal programs, resulting in potential noncompliance with federal cost principles. Federal expenditures may be misstated, impacting financial and grant reporting. Although questioned costs were not identified, the lack of specific supporting documentation and controls represents a significant deficiency in internal control over compliance. Questioned cost: None identified at this time. Recommendation: We recommend that the Organization implement the following corrective actions: 1. Develop and Implement a Written Cost Allocation Policy – Establish a formal policy outlining the methodology for allocating shared costs and personnel time across programs, especially in instances where allowable costs exceed amounts allocated for reimbursement, ensuring compliance with 2 CFR Part 200 cost principles. 2. Document Allocation Methodologies for Shared Costs – Ensure that allocations for shared costs (e.g., rent, utilities, and administrative expenses) are based on a reasonable and documented methodology that can be reviewed and reperformed. 3. Retain Evidence of Implementation of Internal Controls - Implement review and approval controls over all requests for reimbursement, including review and approval of allocation of personnel and shared costs to specific funding sources. In circumstances where costs can be appropriately allocated to multiple funding sources, document the rationale for allocating the specific amount to each funding source. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Views of responsible officials: Management respectfully disagrees with this Finding. Under Condition, the finding states, “Time and effort is being tracked and maintained by employees, including hours charged to the specific efforts for the programs.…” This is not accurate. Employees report their time worked each day, including the amount of time they worked on different projects if applicable. Employees report this in our commercial HRIS/Payroll system, where it is maintained and where it is reviewed and approved by the employee’s manager. The employees report the time they worked and which project(s) they worked on, their managers review and approve the time and the distribution, and the data is tracked and maintained in our HRIS/Payroll system (ExponentHR). Also under Condition, the finding states, “The specific amount of employee salaries and wages that are allocated to specific federal programs for reimbursement, and which are less than the amounts reflected in time and effort records, are determined by members of the finance staff.” It is correct that we would have to invoice sponsors for less than the total cost of an employee’s allocated time and effort if a sponsor’s budget is not sufficient to cover that full amount. This is the correct procedure to follow. Employees correctly continue documenting their hours worked on a specific project even if the budget is expended and the accounting staff can no longer bill the sponsor. If a particular grant does not have sufficient sponsor funds, then the Grants Accounting staff reduce the bill accordingly. Also under Condition, the finding states, “The rationale for the amount actually allocated for reimbursement, if less than the amount reflected in time and effort records, is not documented”. This is incorrect. Our monthly invoices to each sponsor accumulate, with each invoice clearly showing not only that month’s expense but also the year-to-date expense and remaining balance, which forces the sponsor invoice to stop at an amount less than the total cost of employees’ time and effort when the budget is exhausted. Also under Condition, the finding states, “Review and approval of the allocation of employee compensation to specific federal programs reimbursement requests is not maintained.” Each employee records their hours worked, and the project(s) on which they worked those hours, in our HRIS/Payroll system. The employee’s manager reviews and approves both the hours worked and the projects on which the hours were worked. This review and approval is maintained in our HRIS/Payroll system. Financial staff calculate the amount to allocate to specific federal programs based on these HRIS/Payroll system records (or other records such as clinical units produced, based on the terms of each grant). Separate accounting staff review the sponsor invoice and post the Receivable once they deem the invoice correct. Under Cause, the finding states, “…..the Organization has not implemented a structured process for documenting the extent to which allowable [emphasis added] compensation costs will be allocated for reimbursement to specific federal programs in instances where the allowable compensation cost exceeds the amount allocated for reimbursement.” This means that we do not have a AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) process for documenting how much of a payroll expense already deemed allowable on a particular grant will actually be invoiced there. We disagree and believe that the presence and documentation of a limited sponsor budget, along with cumulative tracking and documentation of compensation expenses against that budget, proves and documents why sometimes full compensation costs are not charged to a grant. Under Possible Effect, the finding addresses possible effects of “the absence of documented allocation methodologies.” We don’t agree that our process could lead to improper allocation between federal programs (as the finding states) nor to misstating federal expenditures (as the finding states). When a sponsor’s budget is insufficient to cover its appropriately allocated compensation costs, those costs are paid from unrestricted, non-federal funds. As also noted in the finding, no questioned costs were identified.
Finding number: 2023-006 Significant Deficiency in Internal Control Over Compliance: Allowable Costs and Activities Federal Program #1 HIV Emergency Relief Project Grants: CFDA Number 93.914 Federal Program #2 HIV Care Formula Grants: CFDA Number 93.917 Federal Program #2 HIV Prevention Activities: CFDA Number: 93.941 Name of federal agency: U.S. Department of Health and Human Services (HHS) AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Name of pass-through entity: Multiple Repeat finding: No Criteria: 2 CFR §200.405 requires that costs be allocable to the federal program based on relative benefits received and be supported by appropriate documentation. For personnel costs, 2 CFR §200.430(i) requires that compensation for employees whose time is charged to federal awards be based on records that accurately reflect the work performed, such as time and effort reporting or equivalent documentation. For shared costs, 2 CFR §200.412-200.414 requires that cost allocations be based on documented methodologies that are reasonable and supported by underlying calculations. Condition: The Organization does not have formalized internal controls to support the rationale for allocation of shared costs and employee time across federal programs. Specifically: Time and effort is being tracked and maintained by employees, including hours charged to the specific efforts for the programs. Often, employees charge hours to specific programs in excess of amounts allocated to the program as expenditures. The specific amount of employee salaries and wages that are allocated to specific federal programs for reimbursement, and which are less than the amounts reflected in the time and effort records, are determined by members of the finance staff. The rationale for the amount actually allocated for reimbursement, if less than the amount reflected in the time and effort records, is not documented. Review and approval of the allocation of employee compensation to specific federal programs reimbursement requests is not maintained. Cause: The deficiency exists because the Organization has not implemented a structured process for documenting the extent to which allowable compensation costs will be allocated for reimbursement to specific federal programs in instances where the allowable compensation cost exceeds the amount allocated for reimbursement. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Possible effect: The absence of documented allocation methodologies in instances where allowable compensation costs exceed the amount allocated for reimbursement increases the risk that: Costs may be improperly allocated between federal programs, resulting in potential noncompliance with federal cost principles. Federal expenditures may be misstated, impacting financial and grant reporting. Although questioned costs were not identified, the lack of specific supporting documentation and controls represents a significant deficiency in internal control over compliance. Questioned cost: None identified at this time. Recommendation: We recommend that the Organization implement the following corrective actions: 1. Develop and Implement a Written Cost Allocation Policy – Establish a formal policy outlining the methodology for allocating shared costs and personnel time across programs, especially in instances where allowable costs exceed amounts allocated for reimbursement, ensuring compliance with 2 CFR Part 200 cost principles. 2. Document Allocation Methodologies for Shared Costs – Ensure that allocations for shared costs (e.g., rent, utilities, and administrative expenses) are based on a reasonable and documented methodology that can be reviewed and reperformed. 3. Retain Evidence of Implementation of Internal Controls - Implement review and approval controls over all requests for reimbursement, including review and approval of allocation of personnel and shared costs to specific funding sources. In circumstances where costs can be appropriately allocated to multiple funding sources, document the rationale for allocating the specific amount to each funding source. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Views of responsible officials: Management respectfully disagrees with this Finding. Under Condition, the finding states, “Time and effort is being tracked and maintained by employees, including hours charged to the specific efforts for the programs.…” This is not accurate. Employees report their time worked each day, including the amount of time they worked on different projects if applicable. Employees report this in our commercial HRIS/Payroll system, where it is maintained and where it is reviewed and approved by the employee’s manager. The employees report the time they worked and which project(s) they worked on, their managers review and approve the time and the distribution, and the data is tracked and maintained in our HRIS/Payroll system (ExponentHR). Also under Condition, the finding states, “The specific amount of employee salaries and wages that are allocated to specific federal programs for reimbursement, and which are less than the amounts reflected in time and effort records, are determined by members of the finance staff.” It is correct that we would have to invoice sponsors for less than the total cost of an employee’s allocated time and effort if a sponsor’s budget is not sufficient to cover that full amount. This is the correct procedure to follow. Employees correctly continue documenting their hours worked on a specific project even if the budget is expended and the accounting staff can no longer bill the sponsor. If a particular grant does not have sufficient sponsor funds, then the Grants Accounting staff reduce the bill accordingly. Also under Condition, the finding states, “The rationale for the amount actually allocated for reimbursement, if less than the amount reflected in time and effort records, is not documented”. This is incorrect. Our monthly invoices to each sponsor accumulate, with each invoice clearly showing not only that month’s expense but also the year-to-date expense and remaining balance, which forces the sponsor invoice to stop at an amount less than the total cost of employees’ time and effort when the budget is exhausted. Also under Condition, the finding states, “Review and approval of the allocation of employee compensation to specific federal programs reimbursement requests is not maintained.” Each employee records their hours worked, and the project(s) on which they worked those hours, in our HRIS/Payroll system. The employee’s manager reviews and approves both the hours worked and the projects on which the hours were worked. This review and approval is maintained in our HRIS/Payroll system. Financial staff calculate the amount to allocate to specific federal programs based on these HRIS/Payroll system records (or other records such as clinical units produced, based on the terms of each grant). Separate accounting staff review the sponsor invoice and post the Receivable once they deem the invoice correct. Under Cause, the finding states, “…..the Organization has not implemented a structured process for documenting the extent to which allowable [emphasis added] compensation costs will be allocated for reimbursement to specific federal programs in instances where the allowable compensation cost exceeds the amount allocated for reimbursement.” This means that we do not have a AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) process for documenting how much of a payroll expense already deemed allowable on a particular grant will actually be invoiced there. We disagree and believe that the presence and documentation of a limited sponsor budget, along with cumulative tracking and documentation of compensation expenses against that budget, proves and documents why sometimes full compensation costs are not charged to a grant. Under Possible Effect, the finding addresses possible effects of “the absence of documented allocation methodologies.” We don’t agree that our process could lead to improper allocation between federal programs (as the finding states) nor to misstating federal expenditures (as the finding states). When a sponsor’s budget is insufficient to cover its appropriately allocated compensation costs, those costs are paid from unrestricted, non-federal funds. As also noted in the finding, no questioned costs were identified.
Finding number: 2023-006 Significant Deficiency in Internal Control Over Compliance: Allowable Costs and Activities Federal Program #1 HIV Emergency Relief Project Grants: CFDA Number 93.914 Federal Program #2 HIV Care Formula Grants: CFDA Number 93.917 Federal Program #2 HIV Prevention Activities: CFDA Number: 93.941 Name of federal agency: U.S. Department of Health and Human Services (HHS) AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Name of pass-through entity: Multiple Repeat finding: No Criteria: 2 CFR §200.405 requires that costs be allocable to the federal program based on relative benefits received and be supported by appropriate documentation. For personnel costs, 2 CFR §200.430(i) requires that compensation for employees whose time is charged to federal awards be based on records that accurately reflect the work performed, such as time and effort reporting or equivalent documentation. For shared costs, 2 CFR §200.412-200.414 requires that cost allocations be based on documented methodologies that are reasonable and supported by underlying calculations. Condition: The Organization does not have formalized internal controls to support the rationale for allocation of shared costs and employee time across federal programs. Specifically: Time and effort is being tracked and maintained by employees, including hours charged to the specific efforts for the programs. Often, employees charge hours to specific programs in excess of amounts allocated to the program as expenditures. The specific amount of employee salaries and wages that are allocated to specific federal programs for reimbursement, and which are less than the amounts reflected in the time and effort records, are determined by members of the finance staff. The rationale for the amount actually allocated for reimbursement, if less than the amount reflected in the time and effort records, is not documented. Review and approval of the allocation of employee compensation to specific federal programs reimbursement requests is not maintained. Cause: The deficiency exists because the Organization has not implemented a structured process for documenting the extent to which allowable compensation costs will be allocated for reimbursement to specific federal programs in instances where the allowable compensation cost exceeds the amount allocated for reimbursement. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Possible effect: The absence of documented allocation methodologies in instances where allowable compensation costs exceed the amount allocated for reimbursement increases the risk that: Costs may be improperly allocated between federal programs, resulting in potential noncompliance with federal cost principles. Federal expenditures may be misstated, impacting financial and grant reporting. Although questioned costs were not identified, the lack of specific supporting documentation and controls represents a significant deficiency in internal control over compliance. Questioned cost: None identified at this time. Recommendation: We recommend that the Organization implement the following corrective actions: 1. Develop and Implement a Written Cost Allocation Policy – Establish a formal policy outlining the methodology for allocating shared costs and personnel time across programs, especially in instances where allowable costs exceed amounts allocated for reimbursement, ensuring compliance with 2 CFR Part 200 cost principles. 2. Document Allocation Methodologies for Shared Costs – Ensure that allocations for shared costs (e.g., rent, utilities, and administrative expenses) are based on a reasonable and documented methodology that can be reviewed and reperformed. 3. Retain Evidence of Implementation of Internal Controls - Implement review and approval controls over all requests for reimbursement, including review and approval of allocation of personnel and shared costs to specific funding sources. In circumstances where costs can be appropriately allocated to multiple funding sources, document the rationale for allocating the specific amount to each funding source. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Views of responsible officials: Management respectfully disagrees with this Finding. Under Condition, the finding states, “Time and effort is being tracked and maintained by employees, including hours charged to the specific efforts for the programs.…” This is not accurate. Employees report their time worked each day, including the amount of time they worked on different projects if applicable. Employees report this in our commercial HRIS/Payroll system, where it is maintained and where it is reviewed and approved by the employee’s manager. The employees report the time they worked and which project(s) they worked on, their managers review and approve the time and the distribution, and the data is tracked and maintained in our HRIS/Payroll system (ExponentHR). Also under Condition, the finding states, “The specific amount of employee salaries and wages that are allocated to specific federal programs for reimbursement, and which are less than the amounts reflected in time and effort records, are determined by members of the finance staff.” It is correct that we would have to invoice sponsors for less than the total cost of an employee’s allocated time and effort if a sponsor’s budget is not sufficient to cover that full amount. This is the correct procedure to follow. Employees correctly continue documenting their hours worked on a specific project even if the budget is expended and the accounting staff can no longer bill the sponsor. If a particular grant does not have sufficient sponsor funds, then the Grants Accounting staff reduce the bill accordingly. Also under Condition, the finding states, “The rationale for the amount actually allocated for reimbursement, if less than the amount reflected in time and effort records, is not documented”. This is incorrect. Our monthly invoices to each sponsor accumulate, with each invoice clearly showing not only that month’s expense but also the year-to-date expense and remaining balance, which forces the sponsor invoice to stop at an amount less than the total cost of employees’ time and effort when the budget is exhausted. Also under Condition, the finding states, “Review and approval of the allocation of employee compensation to specific federal programs reimbursement requests is not maintained.” Each employee records their hours worked, and the project(s) on which they worked those hours, in our HRIS/Payroll system. The employee’s manager reviews and approves both the hours worked and the projects on which the hours were worked. This review and approval is maintained in our HRIS/Payroll system. Financial staff calculate the amount to allocate to specific federal programs based on these HRIS/Payroll system records (or other records such as clinical units produced, based on the terms of each grant). Separate accounting staff review the sponsor invoice and post the Receivable once they deem the invoice correct. Under Cause, the finding states, “…..the Organization has not implemented a structured process for documenting the extent to which allowable [emphasis added] compensation costs will be allocated for reimbursement to specific federal programs in instances where the allowable compensation cost exceeds the amount allocated for reimbursement.” This means that we do not have a AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) process for documenting how much of a payroll expense already deemed allowable on a particular grant will actually be invoiced there. We disagree and believe that the presence and documentation of a limited sponsor budget, along with cumulative tracking and documentation of compensation expenses against that budget, proves and documents why sometimes full compensation costs are not charged to a grant. Under Possible Effect, the finding addresses possible effects of “the absence of documented allocation methodologies.” We don’t agree that our process could lead to improper allocation between federal programs (as the finding states) nor to misstating federal expenditures (as the finding states). When a sponsor’s budget is insufficient to cover its appropriately allocated compensation costs, those costs are paid from unrestricted, non-federal funds. As also noted in the finding, no questioned costs were identified.
Finding number: 2023-006 Significant Deficiency in Internal Control Over Compliance: Allowable Costs and Activities Federal Program #1 HIV Emergency Relief Project Grants: CFDA Number 93.914 Federal Program #2 HIV Care Formula Grants: CFDA Number 93.917 Federal Program #2 HIV Prevention Activities: CFDA Number: 93.941 Name of federal agency: U.S. Department of Health and Human Services (HHS) AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Name of pass-through entity: Multiple Repeat finding: No Criteria: 2 CFR §200.405 requires that costs be allocable to the federal program based on relative benefits received and be supported by appropriate documentation. For personnel costs, 2 CFR §200.430(i) requires that compensation for employees whose time is charged to federal awards be based on records that accurately reflect the work performed, such as time and effort reporting or equivalent documentation. For shared costs, 2 CFR §200.412-200.414 requires that cost allocations be based on documented methodologies that are reasonable and supported by underlying calculations. Condition: The Organization does not have formalized internal controls to support the rationale for allocation of shared costs and employee time across federal programs. Specifically: Time and effort is being tracked and maintained by employees, including hours charged to the specific efforts for the programs. Often, employees charge hours to specific programs in excess of amounts allocated to the program as expenditures. The specific amount of employee salaries and wages that are allocated to specific federal programs for reimbursement, and which are less than the amounts reflected in the time and effort records, are determined by members of the finance staff. The rationale for the amount actually allocated for reimbursement, if less than the amount reflected in the time and effort records, is not documented. Review and approval of the allocation of employee compensation to specific federal programs reimbursement requests is not maintained. Cause: The deficiency exists because the Organization has not implemented a structured process for documenting the extent to which allowable compensation costs will be allocated for reimbursement to specific federal programs in instances where the allowable compensation cost exceeds the amount allocated for reimbursement. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Possible effect: The absence of documented allocation methodologies in instances where allowable compensation costs exceed the amount allocated for reimbursement increases the risk that: Costs may be improperly allocated between federal programs, resulting in potential noncompliance with federal cost principles. Federal expenditures may be misstated, impacting financial and grant reporting. Although questioned costs were not identified, the lack of specific supporting documentation and controls represents a significant deficiency in internal control over compliance. Questioned cost: None identified at this time. Recommendation: We recommend that the Organization implement the following corrective actions: 1. Develop and Implement a Written Cost Allocation Policy – Establish a formal policy outlining the methodology for allocating shared costs and personnel time across programs, especially in instances where allowable costs exceed amounts allocated for reimbursement, ensuring compliance with 2 CFR Part 200 cost principles. 2. Document Allocation Methodologies for Shared Costs – Ensure that allocations for shared costs (e.g., rent, utilities, and administrative expenses) are based on a reasonable and documented methodology that can be reviewed and reperformed. 3. Retain Evidence of Implementation of Internal Controls - Implement review and approval controls over all requests for reimbursement, including review and approval of allocation of personnel and shared costs to specific funding sources. In circumstances where costs can be appropriately allocated to multiple funding sources, document the rationale for allocating the specific amount to each funding source. AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) Views of responsible officials: Management respectfully disagrees with this Finding. Under Condition, the finding states, “Time and effort is being tracked and maintained by employees, including hours charged to the specific efforts for the programs.…” This is not accurate. Employees report their time worked each day, including the amount of time they worked on different projects if applicable. Employees report this in our commercial HRIS/Payroll system, where it is maintained and where it is reviewed and approved by the employee’s manager. The employees report the time they worked and which project(s) they worked on, their managers review and approve the time and the distribution, and the data is tracked and maintained in our HRIS/Payroll system (ExponentHR). Also under Condition, the finding states, “The specific amount of employee salaries and wages that are allocated to specific federal programs for reimbursement, and which are less than the amounts reflected in time and effort records, are determined by members of the finance staff.” It is correct that we would have to invoice sponsors for less than the total cost of an employee’s allocated time and effort if a sponsor’s budget is not sufficient to cover that full amount. This is the correct procedure to follow. Employees correctly continue documenting their hours worked on a specific project even if the budget is expended and the accounting staff can no longer bill the sponsor. If a particular grant does not have sufficient sponsor funds, then the Grants Accounting staff reduce the bill accordingly. Also under Condition, the finding states, “The rationale for the amount actually allocated for reimbursement, if less than the amount reflected in time and effort records, is not documented”. This is incorrect. Our monthly invoices to each sponsor accumulate, with each invoice clearly showing not only that month’s expense but also the year-to-date expense and remaining balance, which forces the sponsor invoice to stop at an amount less than the total cost of employees’ time and effort when the budget is exhausted. Also under Condition, the finding states, “Review and approval of the allocation of employee compensation to specific federal programs reimbursement requests is not maintained.” Each employee records their hours worked, and the project(s) on which they worked those hours, in our HRIS/Payroll system. The employee’s manager reviews and approves both the hours worked and the projects on which the hours were worked. This review and approval is maintained in our HRIS/Payroll system. Financial staff calculate the amount to allocate to specific federal programs based on these HRIS/Payroll system records (or other records such as clinical units produced, based on the terms of each grant). Separate accounting staff review the sponsor invoice and post the Receivable once they deem the invoice correct. Under Cause, the finding states, “…..the Organization has not implemented a structured process for documenting the extent to which allowable [emphasis added] compensation costs will be allocated for reimbursement to specific federal programs in instances where the allowable compensation cost exceeds the amount allocated for reimbursement.” This means that we do not have a AIDS Arms, Inc. dba Prism Health North Texas and Subsidiary Schedule of Findings and Questioned Costs For the Year Ended December 31, 2023 SECTION III - SUMMARY OF FEDERAL AWARD FINDINGS AND QUESTIONED COSTS (continued) process for documenting how much of a payroll expense already deemed allowable on a particular grant will actually be invoiced there. We disagree and believe that the presence and documentation of a limited sponsor budget, along with cumulative tracking and documentation of compensation expenses against that budget, proves and documents why sometimes full compensation costs are not charged to a grant. Under Possible Effect, the finding addresses possible effects of “the absence of documented allocation methodologies.” We don’t agree that our process could lead to improper allocation between federal programs (as the finding states) nor to misstating federal expenditures (as the finding states). When a sponsor’s budget is insufficient to cover its appropriately allocated compensation costs, those costs are paid from unrestricted, non-federal funds. As also noted in the finding, no questioned costs were identified.
FINDING 2023-001 Program Information: Temporary Assistance for Needy Families (ALN #93.558) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): L. Reporting- The auditee must prepare a schedule of expenditures of Federal awards (the “SEFA”) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For Research and Development (“R&D”), total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the passthrough entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listing number or other identifying number when the Assistance Listing information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in 2 CFR 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in 2 CFR 200.414. Condition: The SEFA as prepared by management did not originally include all expenditures for one federal grant. Cause: The Organization has a process where administrative expenses and management travel expenses are charged to a general fund code. A portion of those expenses related to the TANF program are then reclassed to the TANF fund code. We note some of those administrative and travel expenses did not get reclassed into the TANF fund code and as a result, the draft SEFA was not fully complete. Effect or Potential Effect: The original draft SEFA was incomplete. Questioned Costs: None. Context: During the process to compile and prepare the draft SEFA, certain administrative and travel costs were excluded from the draft SEFA, which resulted in the SEFA being understated by approximately $14,000. Identification as a Repeat Finding: Similar findings noted in the prior year. Recommendation: We recommend that the Alliance enhance its procedures and internal controls with respect to general ledger coding of expenses, preparation and review of the SEFA. Views of Responsible Officials and Planned Corrective Actions: Management will review SEFA for proper inclusion of all federal grant expenditures, and Alliance Director will ensure all invoices are properly coded to grants as applicable.
FINDING 2023-003 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Subrecipient Monitoring Federal Agency: Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Number and Year (or Other Identifying Number): FY 2023 Compliance Requirement: Subrecipient Monitoring Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-005. Condition and Context The County received a total State and Local Fiscal Recovery Funds (SLFRF) allocation of $13,177,707. During the audit period, the County provided subawards of SLFRF funds to other entities. As a pass-through entity, the County must: Identify the award and the applicable requirements to each subrecipient. Evaluate each subrecipient's risk of noncompliance for purposes of determining the appropriate subrecipient monitoring related to the subaward. Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for an authorized purpose, complies with the terms and conditions of the subaward, and achieves performance goals. Subawards, totaling $290,000, were provided to two different entities. Both subrecipient agreements associated with the subawards were selected for testing. For the two agreements tested, the following information was incomplete or missing: The federal award identification number (FAIN). The federal award date of award to the recipient by the federal agency. The name of the federal awarding agency, pass-through entity (auditee), and contact information for awarding official of the pass-through entity (auditee). The Assistance Listings Number and Title; the pass-through entity must identify the dollar amount made available under each federal award and the Assistance Listings Number at time of disbursement. Furthermore, the County did not have an evaluation of the subrecipients' risk of noncompliance or monitoring activities demonstrating compliance with the subrecipient monitoring requirement. The County did not request any financial or audit documentation from the subrecipients. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 21 BOONE COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) 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). . . ." 2 CFR 200.331(a) states: "Subrecipients. A subaward is for the purpose of carrying out a portion of a Federal award and creates a Federal assistance relationship with the subrecipient. See definition for Subaward in § 200.1 of this part. Characteristics which support the classification of the non-Federal entity as a subrecipient include when the non-Federal entity: (1) Determines who is eligible to receive what Federal assistance; (2) Has its performance measured in relation to whether objectives of a Federal program were met; (3) Has responsibility for programmatic decision-making; (4) Is responsible for adherence to applicable Federal program requirements specified in the Federal award; and (5) In accordance with its agreement, uses the Federal funds to carry out a program for a public purpose specified in authorizing statute, as opposed to providing goods or services for the benefit of the pass-through entity." 2 CFR 200.332 states in part: "All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward . . . (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; INDIANA STATE BOARD OF ACCOUNTS 22 BOONE COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the passthrough entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the passthrough entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; (xii) Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. (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 pass-through entity imposes on the subrecipient in order for the pass-through entity to meet its own responsibility to the Federal awarding agency including identification of any required financial and performance reports; (4) (i) An approved federally recognized indirect cost rate negotiated between the subrecipient and the Federal Government. If no approved rate exists, the passthrough entity must determine the appropriate rate in collaboration with the subrecipient, which is either: (A) The negotiated indirect cost rate between the pass-through entity and the subrecipient; which can be based on a prior negotiated rate between a different PTE and the same subrecipient. If basing the rate on a previously negotiated rate, the pass-through entity is not required to collect information justifying this rate, but may elect to do so; (B) The de minimis indirect cost rate. INDIANA STATE BOARD OF ACCOUNTS 23 BOONE COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (ii) The pass-through entity must not require use of a de minimis indirect cost rate if the subrecipient has a Federally approved rate. Subrecipients can elect to use the cost allocation method to account for indirect costs in accordance with § 200.405(d). (5) A requirement that the subrecipient permit the pass-through entity and auditors to have access to the subrecipient's records and financial statements as necessary for the pass-through entity to meet the requirements of this part; and (6) Appropriate terms and conditions concerning closeout of the subaward. (b) Evaluate each subrecipient's risk of noncompliance with Federal statues, regulations, and the terms and conditions of the subaward for purposes of determined the appropriate subrecipient monitoring . . . (d) Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved. Pass-through entity monitoring of the subrecipient must include: (1) Reviewing financial and performance reports required by the pass-through entity. (2) Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and written confirmation from the subrecipient, highlighting the status of actions planned or taken to address Single Audit findings related to the particular subaward. (3) Issuing a management decision for applicable audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by § 200.521. (4) The pass-through entity is responsible for resolving audit findings specifically related to the subaward and not responsible for resolving crosscutting findings. . . ." Cause The system of internal controls as established by the management of the County was not properly designed nor implemented. The County was unable to provide documentation that monitoring procedures were in place over subrecipients. Effect Without the proper implementation of an effectively designed system of internal controls, the County cannot be sure subrecipients are provided an adequate subaward agreement, with all required elements and are adequately monitored. As such, subaward agreements entered into by the County did not include all the required elements. In addition, the County did not properly monitor the non-profit to ensure proper spending of the federal funds. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the County. INDIANA STATE BOARD OF ACCOUNTS 24 BOONE COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the County design and implement a proper system of internal controls and develop policies and procedures to ensure subrecipients are provided with an adequate subaward agreement and monitored as appropriate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Federal Agency: Department of Justice Federal Assistance Listing Number: 16.756 Program: Court Appointed Special Advocates Award Number: 15JDP-21-GK-02762-CASA Criteria: The Uniform Guidance in 2 CFR §200.332 details requirements for pass-through entities in regard to subrecipient monitoring and management. Per 2 CFR §200.332, Requirements for Pass-Through Entities: “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the federal award and subaward. Required information includes: (1) Federal award identification. i. Subrecipient name (which must match the name associated with its unique entity identifier); ii. Subrecipient’s unique entity identifier; iii. Federal Award Identification Number (FAIN); iv. Federal Award Date (see the definition of federal award date in §200.1 of this part) of award to the recipient by the federal agency; v. Subaward Period of Performance Start and End Date; vi. Subaward Budget Period Start and End Date; vii. Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; viii. Total Amount of Federal Funds Obligated to the subrecipient by the pass through entity, including the current financial obligation; ix. Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; x. Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); xi. Name of federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; xii. Assistance Listings Number and Title; the pass-through entity must identify the dollar amount made available under each federal award and the Assistance Listings Number at time of disbursement; xiii. Identification of whether the award is R&D; and xiv. Indirect cost rate for the federal award (including if the de minimis rate is charged) per § 200.414. (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 pass-through entity imposes on the subrecipient in order for the pass-through entity to meet its own responsibility to the federal awarding agency, including identification of any required financial and performance reports; (4) i. An approved federally recognized indirect cost rate negotiated between the subrecipient and the Federal Government. If no approved rate exists, the pass-through entity must determine the appropriate rate in collaboration with the subrecipient, which is either: (A) The negotiated indirect cost rate between the pass-through entity and the subrecipient, which can be based on a prior negotiated rate between a different PTE and the same subrecipient. If basing the rate on a previously negotiated rate, the pass-through entity is not required to collect information justifying this rate, but may elect to do so; (B) The de minimis indirect cost rate. ii. The pass-through entity must not require use of a de minimis indirect cost rate if the subrecipient has a federally approved rate. Subrecipients can elect to use the cost allocation method to account for indirect costs in accordance with §200.405(d). (5) A requirement that the subrecipient permits the pass-through entity and auditors to have access to the subrecipient’s records and financial statements as necessary for the pass-through entity to meet the requirements of this part; and (6) Appropriate terms and conditions concerning closeout of the subaward.” Condition: National CASA/GAL’s subrecipient agreements do not contain a level of specificity to fully comply with federal subrecipient regulations. During our testing of subrecipient monitoring, we selected 16 subrecipient awards. For all awards tested, National CASA/GAL’s subaward agreements did not comply with 2 CFR §200.332, Requirements for Pass-Through Entities, as they do not contain a specific scope of work or project description. Cause: National CASA/GAL did not have the proper policies and procedures in place to ensure subaward agreements complied to relevant federal regulation, and that all required elements are located in subaward agreements, and not in the application or by reference to other documents. Effect or Potential Effect: Without adequate controls in place to ensure conformity with subaward requirements, grantees may not ensure compliance with any award special conditions or revised budgets agreed upon at contract implementation. Questioned Costs: None. Context: This is a condition identified per review of National CASA/GAL’s compliance with specified requirements using a non-statistically valid sample. The population consisted of 79 subawards made totaling to $2,428,200 provided to subrecipients in 2023. The sample consisted of 16 subawards totaling $515,618 provided to subrecipients in 2023. Identification as a Repeat Finding: 2022-005. Recommendation: We recommend establishing and maintaining written policies and procedures to ensure subaward agreements conform to the requirements outlined in 2 CFR §200.332. Views of Responsible Officials: Management agrees that subrecipient agreements in place in 2022 did not fully comply with 2 CFR §200.332. Updates were made to the policies and procedures as well to ensure subaward files contain the requisite components. Management has additionally implemented a Grant Master File Checklist to ensure compliance with terms and conditions required in subaward agreements.
Criteria: 2 CFR 200.332 notes, “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency;(v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; (xii) Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. (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; …” Condition: All three of the subawards selected for testing, the recipient’s UEI number was missing from the subaward. We consider this condition to be an instance of noncompliance relating to the Subrecipient Monitoring compliance requirement. Statistical sampling was not used in making sample selections. Questioned Costs :N/A Cause and effect: Without communication of the required information, subrecipients may overspend award amounts or incur unallowable expenses towards the grant. Recommendation: We recommend ACT evaluates policies and procedures to ensure all required information is communication with the subrecipient. Views of Responsible Officials and Planned Corrective Actions: Management agrees with this Single Audit Finding and response is included in the Corrective Action Plan.
Criteria: 2 CFR 200.332 notes, “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency;(v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; (xii) Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. (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; …” Condition: All three of the subawards selected for testing, the recipient’s UEI number was missing from the subaward. We consider this condition to be an instance of noncompliance relating to the Subrecipient Monitoring compliance requirement. Statistical sampling was not used in making sample selections. Questioned Costs :N/A Cause and effect: Without communication of the required information, subrecipients may overspend award amounts or incur unallowable expenses towards the grant. Recommendation: We recommend ACT evaluates policies and procedures to ensure all required information is communication with the subrecipient. Views of Responsible Officials and Planned Corrective Actions: Management agrees with this Single Audit Finding and response is included in the Corrective Action Plan.
METROPOLITAN TRANSPORTATION AUTHORITY (A Component Unit of the State of New York) SCHEDULE OF FINDINGS AND QUESTIONED COSTS- FEDERAL AWARDS (CONTINUED) YEAR ENDED DECEMBER 31, 2023 Reference Number: 2023-001 Federal Agency: U.S. Department of Homeland Security Federal Program: Rail and Transit Security Grant Program ALN Number: 97.075 Contract Number: FE2019-RA-00004; FE2020-RA-00005; FE2021-RA-00004; FE2022-RA-00006 Compliance Requirement: Subrecipient Monitoring Type of Finding: Deficiency-Non-Compliance 1. CRITERIA Subrecipient Monitoring - As stated in Uniform Grant Guidance - §200.331 Requirements for pass-through entities, all pass-through entities must: Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: • Subrecipient name (which must match the name associated with its unique entity identifier); • Subrecipient’s unique entity identifier; • Federal Award Identification Number (FAIN); • Assistance Listing Number (ALN) Number and Name; the pass-through entity must identify the dollar amount made available under each Federal award and the ALN number at time of disbursement; • Identification of whether the award is Research & Development; and • Indirect cost rate for the Federal award (including if the de minimis rate is charged per §200.414 Indirect (F&A) costs); 2. CONDITION/PERSPECTIVE Metropolitan Transportation Authority (“MTA”) has subrecipient monitoring procedures in place. MTA has corporate policies and procedures regarding subrecipient contracts. We reviewed Rail and Transit Security Grant Program’s subrecipient monitoring compliance. This program had one subrecipient. Based on our review of the subrecipient contract for this program, we noted that the subrecipient contract did not have all the required elements as stated in §200.331. 3. CAUSE MTA did not ensure that the contract between MTA and the subrecipient included the ALN and all other required elements as required by 2 CFR; §200.331. 4. EFFECT The Subrecipient may not identify an MTA contract as a federal program, and therefore may not follow the required federal award requirements. Additionally the subrecipient may not include the program in the Subrecipient’s schedule of expenditures of federal awards and the program may not be audited as part of the Subrecipient’s single audit. 5. REPEAT FINDING No 6. RECOMMENDATION We recommend that MTA implement policies and procedures to communicate the federal grant information to all subrecipients in accordance with Uniform Grant Guidance CFR 200.331 Subrecipient Requirements. 7. QUESTIONED COST None. 8. VIEWS OF RESPONSIBLE OFFICIAL The MTA Office of Security is acknowledging the sub-recipient agreement did not include the ALN Number – 97.075, Identification of whether the award is R&D and Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414 on the check list. The MTA does provide a copy of the award letter to our sub-recipient(s) and we perform yearly sub-recipient monitoring of our sub-recipient(s). Also, see “Corrective Action Plan”.
FINDING 2023-001 Program Information: Substance Abuse and Mental Health Services Projects (ALN #93.243) COVID-19 Education Stabilization Fund (ALN #84.425C) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): L. Reporting - The auditee must prepare a schedule of expenditures of Federal awards (the “SEFA”) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For Research and Development (“R&D”), total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the passthrough entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listing number or other identifying number when the Assistance Listing information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in 2 CFR 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in 2 CFR 200.414. FINDING 2023-001 Program Information: Substance Abuse and Mental Health Services Projects (ALN #93.243) COVID-19 Education Stabilization Fund (ALN #84.425C) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): L. Reporting - The auditee must prepare a schedule of expenditures of Federal awards (the “SEFA”) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For Research and Development (“R&D”), total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the passthrough entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listing number or other identifying number when the Assistance Listing information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in 2 CFR 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in 2 CFR 200.414. Condition: The SEFA, as prepared by management erroneously included expenditures previously incurred and reported in fiscal year 2022, resulting in an overstatement of $7,875 for the Substance Abuse and Mental Health Service Project. Additionally, COVID-19 Education Stabilization Fund expenditures were not complete, resulting in an understatement of $6,000 for the COVID-19 Education Stabilization Fund. Cause: Administrative oversight with respect to preparation of the SEFA. Effect or Potential Effect: The original draft SEFA was overstated. Questioned Costs: None Context: Due to an error in disbursing grant funds to an incorrect local club in fiscal year 2022, the Alliance attempted to correct this mistake by disbursing additional funds to the correct club in fiscal year 2023. The Alliance included the remedied disbursement on the 2023 SEFA, which resulted in a $7,875 overstatement of expenditures that had already been incurred and reported on the 2022 SEFA. The omission of costs allocated to the COVID-19 Education Stabilization Fund resulted in expenditures being understated by $6,000. Identification as a Repeat Finding: No similar findings noted in the prior year. Recommendation: We recommend that the Alliance enhance its procedures and internal controls with respect to preparation and review of the SEFA. Views of Responsible Officials and Planned Corrective Actions: Management will enhance procedures and internal controls with respect to the preparation and review of the SEFA, by reviewing the detail of expenses included in the prior year SEFA with current year expenses, to prevent duplicate entries being reported.
FINDING 2023-001 Program Information: Substance Abuse and Mental Health Services Projects (ALN #93.243) COVID-19 Education Stabilization Fund (ALN #84.425C) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): L. Reporting - The auditee must prepare a schedule of expenditures of Federal awards (the “SEFA”) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For Research and Development (“R&D”), total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the passthrough entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listing number or other identifying number when the Assistance Listing information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in 2 CFR 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in 2 CFR 200.414. FINDING 2023-001 Program Information: Substance Abuse and Mental Health Services Projects (ALN #93.243) COVID-19 Education Stabilization Fund (ALN #84.425C) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): L. Reporting - The auditee must prepare a schedule of expenditures of Federal awards (the “SEFA”) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For Research and Development (“R&D”), total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the passthrough entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listing number or other identifying number when the Assistance Listing information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in 2 CFR 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in 2 CFR 200.414. Condition: The SEFA, as prepared by management erroneously included expenditures previously incurred and reported in fiscal year 2022, resulting in an overstatement of $7,875 for the Substance Abuse and Mental Health Service Project. Additionally, COVID-19 Education Stabilization Fund expenditures were not complete, resulting in an understatement of $6,000 for the COVID-19 Education Stabilization Fund. Cause: Administrative oversight with respect to preparation of the SEFA. Effect or Potential Effect: The original draft SEFA was overstated. Questioned Costs: None Context: Due to an error in disbursing grant funds to an incorrect local club in fiscal year 2022, the Alliance attempted to correct this mistake by disbursing additional funds to the correct club in fiscal year 2023. The Alliance included the remedied disbursement on the 2023 SEFA, which resulted in a $7,875 overstatement of expenditures that had already been incurred and reported on the 2022 SEFA. The omission of costs allocated to the COVID-19 Education Stabilization Fund resulted in expenditures being understated by $6,000. Identification as a Repeat Finding: No similar findings noted in the prior year. Recommendation: We recommend that the Alliance enhance its procedures and internal controls with respect to preparation and review of the SEFA. Views of Responsible Officials and Planned Corrective Actions: Management will enhance procedures and internal controls with respect to the preparation and review of the SEFA, by reviewing the detail of expenses included in the prior year SEFA with current year expenses, to prevent duplicate entries being reported.
Program Information: Texas Statewide Youth Services Network Project (“SYSN”) (ALN #93.590) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): L. Reporting- The auditee must prepare a schedule of expenditures of Federal awards (the “SEFA”) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For Research and Development (“R&D”), total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the passthrough entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listing number or other identifying number when the Assistance Listing information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in 2 CFR 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in 2 CFR 200.414. Condition: The SEFA, as prepared by management, did not originally bifurcate grant expenditures between state and federal funding sources for the SYSN grant. Cause: The Organization did not properly identify separate state and federal funding sources as stated on the Notice of Award for the grant. Effect or Potential Effect: The original draft SEFA did not properly present both state and federal programs for the SYSN grant. Questioned Costs: None. Context: During the process to prepare the draft SEFA, management did not properly identify separate funding sources for one grant resulting in improper presentation of certain federal expenditures as state expenditures on the draft SEFA. Identification as a Repeat Finding: No. Recommendation: We recommend that the Alliance enhance its procedures and internal controls with respect to the preparation and review of the SEFA by comparing programs on the SEFA with corresponding grant agreements and notices of award. Views of Responsible Officials and Planned Corrective Actions: Review all federal grant contracts to determine if any separate funding sources should be listed for total funds received.
Assistance Listing Number, Federal Agency, and Program Name: Assistance Listing Number 93.600, Department of Health and Human Services, Head Start and Covid-19: Head Start ARP Federal Award Identification Number and Year: 05CH011937-03-03, 05HE000989-01-01 Pass-through Entity – N/A Finding Type – Significant deficiency in internal control over compliance Repeat Finding – No Criteria – Per 2 CFR 200.332 all pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of the Federal agency, pass-through entity, and contact information for awarding official of the pass-through entity; (xii) Assistance Listings title and number; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at the time of disbursement; (xiii) Identification of whether the Federal award is for research and development; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is used in accordance with § 200.414) Condition – During our test work, we noted that 3 out of 3 subaward agreements tested did not include the information as noted in 2 CFR 200.332. The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, were included in the grant agreement of its subrecipient. Identification of How Questioned Costs Were Computed – N/A Questioned Costs – None Cause/Effect – The controls in place did not ensure that the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, were included in the grant agreement of its subrecipient. As a result, required information was omitted. Recommendation – We recommend that management review its procedures and controls to ensure the required information as prescribed by 2 CFR 200.332, Requirements for Pass-through Entities, is included in all subawards to subrecipients. View of Responsible Officials and Corrective Action Plan –The Agency agrees with the finding. When granting funds as a subaward to a pass-through entity, the Agency will update its master templates for subawards to include the required information. In addition, when the sub agreements are routed for signature and reviewed by the Chief Financial Officer, they will be double-checked to ensure compliance with this requirement.