Reference Number:2022-010Prior Year Finding:NoFederal Agency:U.S. Department of the TreasuryState Agency:Department of Community AffairsFederal Program:COVID-19 - Homeowner Assistance FundAssistance Listing Number:21.026Award Number and Year:HAF0019 (2021)Compliance Requirement:Subrecipient MonitoringType of FindingSignificant Deficiency in Internal Control over Compliance, Other MattersCriteria or specific requirement:Compliance ? Per 2 CFR section 200.332(a), 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: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; andxiv. Indirect cost rate for the Federal award (including if the de minimis rate is charged) per section 200.414.2 CFR section 200.332 also states that pass-through entities must:(d) Evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section, which may include consideration of such factors as:1) The subrecipient's prior experience with the same or similar subawards;2) The results of previous audits including whether or not the subrecipient receives a Single Audit in accordance with Subpart F - Audit Requirements of this part, and the extent to which the same or similar subaward has been audited as a major program;3) Whether the subrecipient has new personnel or new or substantially changed systems;4) The extent and results of Federal awarding agency monitoring (e.g., if the subrecipient also receives Federal awards directly from a Federal awarding agency).(e) 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 other means.(3) Issuing a management decision for audit findings pertaining to the Federal award provided to the subrecipient from the pass-through entity as required by ? 200.521 Management decision.(f) Verify that every subrecipient is audited as required by Subpart F - Audit Requirements of this part when it is expected that the subrecipient's Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in ? 200.501 Audit requirements.Control ? Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).Condition:The Department of Community Affairs (Department) did not comply with subrecipient monitoring requirements for the program.Context:The Department issued one subaward under the program and it was noted that the subaward did not include all required Federal Award information, nor did the Department perform a risk assessment of the subrecipient or perform monitoring activities for the award.Questioned costs:None noted.Cause:The Department?s procedures and controls were not effective to ensure the subaward was issued in compliance with Federal requirements, nor that it performed a risk assessment or timely monitoring of subrecipient.Effect:Excluding the required federal grant award information at the time of the subaward may cause subrecipients and their auditors to be uninformed about specific program and other regulations that apply to the funds they receive. There is also the potential for subrecipients to have incomplete Schedules of Expenditures of Federal Awards (SEFA) in their Single Audit reports, and federal funds may not be properly audited at the subrecipient level in accordance with the Uniform Guidance.Not conducting during the award monitoring may result in a failure of the Division to detect that its subrecipients used subawards for unauthorized purposes, managed them in violation of the terms and conditions of the subawards, or that subaward performance goals were not achieved.Without ensuring subrecipients have obtained audits as required by Subpart F, there is an increased risk that subrecipients could be inappropriately spending and/or inaccurately tracking and reporting federal funds over multiple year periods, and these discrepancies may not be properly monitored, detected, and corrected by Division personnel on a timely basis.Recommendation:The Department should review and enhance internal controls and procedures to ensure that all required information is included in all subawards, that proper subrecipient monitoring is conducted, and that evaluation of independent audits is performed.Views of responsible officials:As recommended, the Department of Community Affairs (DCA) will review current procedures to ensure that all subaward information required by the federal Uniform Guidance is included in all subaward contracts and grant agreements. The DCA has also reviewed its current subrecipient monitoring procedures for standard subawards made by the agency and has determined that no internal control enhancements are required. The HAF award was a unique grant relationship for DCA in that the entire award was passed through to another New Jersey State government agency that is a direct affiliate of the Department. Monitoring procedures were determined based on the close working relationship with our affiliate organization and the fact that less than 1 percent of the grant award was expended through June 30, 2022. Current procedures included a risk assessment of the subrecipient and performance of the single audit desk review of the independent audit report. In addition, the Director of Audit, and the Executive Director of the subgrantee affiliate participate in weekly meetings where updates on the program status can be determined. DCA?s subrecipient monitoring plan also includes the hiring of an Integrity Monitor to oversee and monitor the use of the HAF funds as well as compliance with all HAF program reporting requirements. As program disbursement activity is continuing to increase with the HAF program(s) created more fully up and running, DCA is currently targeting the Integrity Monitor hire to take place sometime within the next three to six months.
Department of Health and Human Services Temporary Assistance for Needy Families (TANF), Federal Assistance Listing # 93.558 Pass Through Fairfax County, Pass Through Entity Identifying Number 440009926 Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance with Federal Awards Criteria: The Organization should have processes and procedures in place to properly calculate and drawdown the allowed amount, per 2 CFR 200.414. Condition: During our audit, we noted that the Organization charged more than the allowed indirect rate of 10%, leading to noncompliance with the program. Context: During testing, the Organization requested reimbursement for funds in excess of the allowed indirect rate in the amount of $2,735. The sample was not intended to be, and was not, a statistically valid sample. Cause/Effect: Internal control processes over proper calculation and drawdowns of funds were not operating effectively. Questioned Costs: $2,735, which was calculated by applying the 10% de minimis rate to total direct costs and comparing to the indirect costs charged to the grant per the financial reports. Identification of Repeat Finding: N/A Recommendation: We recommend that the Organization implement review procedures to ensure proper calculation of indirect costs charged to federal programs. Views of Responsible Officials and Correction Action: Management’s response is reported in “Management’s Views and Corrective Action Plan” included at the end of this report.
Department of Health and Human Services Temporary Assistance for Needy Families (TANF), Federal Assistance Listing # 93.558 Pass Through Fairfax County, Pass Through Entity Identifying Number 440009926 Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance with Federal Awards Criteria: The Organization should have processes and procedures in place to properly calculate and drawdown the allowed amount, per 2 CFR 200.414. Condition: During our audit, we noted that the Organization charged more than the allowed indirect rate of 10%, leading to noncompliance with the program. Context: During testing, the Organization requested reimbursement for funds in excess of the allowed indirect rate in the amount of $2,735. The sample was not intended to be, and was not, a statistically valid sample. Cause/Effect: Internal control processes over proper calculation and drawdowns of funds were not operating effectively. Questioned Costs: $2,735, which was calculated by applying the 10% de minimis rate to total direct costs and comparing to the indirect costs charged to the grant per the financial reports. Identification of Repeat Finding: N/A Recommendation: We recommend that the Organization implement review procedures to ensure proper calculation of indirect costs charged to federal programs. Views of Responsible Officials and Correction Action: Management’s response is reported in “Management’s Views and Corrective Action Plan” included at the end of this report.
2 CFR Subpart F § 200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the District’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) 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. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) 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. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The District’s internal control procedures did not identify $258,972 of expenses in the Schedule of Expenditures of Federal Awards related to the Elementary and Secondary School Emergency Relief Funds. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
2 CFR Subpart F § 200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the District’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) 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. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) 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. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The District’s internal control procedures did not identify $258,972 of expenses in the Schedule of Expenditures of Federal Awards related to the Elementary and Secondary School Emergency Relief Funds. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
2 CFR Subpart F § 200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the District’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) 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. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) 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. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The District’s internal control procedures did not identify $258,972 of expenses in the Schedule of Expenditures of Federal Awards related to the Elementary and Secondary School Emergency Relief Funds. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
Finding 2022-006 Internal Control and Compliance over Subrecipient Monitoring Information on the Federal Program: Assistance Listing Number(s): 17.258, 17.259, 17.278 Federal Program Name: Workforce Innovation and Opportunity Act (WIOA) Federal Agency: U.S. Department of Labor Pass-Through Entity: California Employment Development Department Federal Award Number and Award Year: AA311008 - FY21-22 Criteria: 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. Standards for Financial and Program Management. §200.303 Internal controls (2 CFR 200.303): 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). 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, Subrecipient Monitoring and Management, §200.331 Requirements for pass-through entities (2 CFR 200.331): 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 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; 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, Subrecipient Monitoring and Management, §200.332 Requirements for pass-through entities (2 CFR 200.332): All pass-through entities must: (a) Evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section, which may include consideration of such factors as: (1) The subrecipient's prior experience with the same or similar subawards; (2) The results of previous audits including whether or not the subrecipient receives a Single Audit in accordance with Subpart F of this part, and the extent to which the same or similar subaward has 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 awarding agency monitoring (e.g., if the subrecipient also receives Federal awards directly from a Federal awarding agency). Condition: During our testing of the Imperial County Workforce Development Office’s (ICWDO) provisions for subrecipient monitoring under the WIOA Cluster, we noted the following instances: For one (1) of the one (1) subrecipient selected for testing, there was no review or approval over the monitoring procedures performed by ICWDO monitoring staff. The entire population of one (1) subrecipient. • The following information was not provided at the time of the subaward for one (1) of the one (1) subaward selected for testing: o Federal award identification number o Federal award date of award to recipient by the Federal agency o Name of federal awarding agency o Federal Financial Assistance Listing/CFDA Number o Identification of whether the award is research and development • The County did not document their evaluation of each subrecipient’s risk of noncompliance Cause: The County’s ICWDO department does not have a formal procedure in place for the department’s review and approval over the monitoring procedures performed by the department over its subrecipients. The ICWDO department did not ensure that the required award information and applicable requirements were communicated to the subrecipients and did not maintain documentation of their evaluation of each subrecipient’s risk of noncompliance. Effect: The County’s ICWDO department did not review and approve monitoring procedures performed over its subrecipients. Additionally, the ICWDO department did not maintain policies and procedures to align with the Subrecipient Monitoring requirements in 2 CFR 200.332 (a) and 200.332(b). Identification as a Repeat Finding, If Applicable: Yes. See Finding 2021-008. Questioned Costs: No questioned costs were identified. Recommendation: Social Services should continue to monitor compliance with its policies to ensure case workers follow the established guidelines for redetermination of the recipients of need and amount of assistance and retain acceptable documentation to support the determinations. View of Responsible Officials and Planned Corrective Action: See separate Corrective Action Plan.
Finding 2022-006 Internal Control and Compliance over Subrecipient Monitoring Information on the Federal Program: Assistance Listing Number(s): 17.258, 17.259, 17.278 Federal Program Name: Workforce Innovation and Opportunity Act (WIOA) Federal Agency: U.S. Department of Labor Pass-Through Entity: California Employment Development Department Federal Award Number and Award Year: AA311008 - FY21-22 Criteria: 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. Standards for Financial and Program Management. §200.303 Internal controls (2 CFR 200.303): 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). 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, Subrecipient Monitoring and Management, §200.331 Requirements for pass-through entities (2 CFR 200.331): 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 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; 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, Subrecipient Monitoring and Management, §200.332 Requirements for pass-through entities (2 CFR 200.332): All pass-through entities must: (a) Evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section, which may include consideration of such factors as: (1) The subrecipient's prior experience with the same or similar subawards; (2) The results of previous audits including whether or not the subrecipient receives a Single Audit in accordance with Subpart F of this part, and the extent to which the same or similar subaward has 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 awarding agency monitoring (e.g., if the subrecipient also receives Federal awards directly from a Federal awarding agency). Condition: During our testing of the Imperial County Workforce Development Office’s (ICWDO) provisions for subrecipient monitoring under the WIOA Cluster, we noted the following instances: For one (1) of the one (1) subrecipient selected for testing, there was no review or approval over the monitoring procedures performed by ICWDO monitoring staff. The entire population of one (1) subrecipient. • The following information was not provided at the time of the subaward for one (1) of the one (1) subaward selected for testing: o Federal award identification number o Federal award date of award to recipient by the Federal agency o Name of federal awarding agency o Federal Financial Assistance Listing/CFDA Number o Identification of whether the award is research and development • The County did not document their evaluation of each subrecipient’s risk of noncompliance Cause: The County’s ICWDO department does not have a formal procedure in place for the department’s review and approval over the monitoring procedures performed by the department over its subrecipients. The ICWDO department did not ensure that the required award information and applicable requirements were communicated to the subrecipients and did not maintain documentation of their evaluation of each subrecipient’s risk of noncompliance. Effect: The County’s ICWDO department did not review and approve monitoring procedures performed over its subrecipients. Additionally, the ICWDO department did not maintain policies and procedures to align with the Subrecipient Monitoring requirements in 2 CFR 200.332 (a) and 200.332(b). Identification as a Repeat Finding, If Applicable: Yes. See Finding 2021-008. Questioned Costs: No questioned costs were identified. Recommendation: Social Services should continue to monitor compliance with its policies to ensure case workers follow the established guidelines for redetermination of the recipients of need and amount of assistance and retain acceptable documentation to support the determinations. View of Responsible Officials and Planned Corrective Action: See separate Corrective Action Plan.
Finding 2022-006 Internal Control and Compliance over Subrecipient Monitoring Information on the Federal Program: Assistance Listing Number(s): 17.258, 17.259, 17.278 Federal Program Name: Workforce Innovation and Opportunity Act (WIOA) Federal Agency: U.S. Department of Labor Pass-Through Entity: California Employment Development Department Federal Award Number and Award Year: AA311008 - FY21-22 Criteria: 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. Standards for Financial and Program Management. §200.303 Internal controls (2 CFR 200.303): 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). 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, Subrecipient Monitoring and Management, §200.331 Requirements for pass-through entities (2 CFR 200.331): 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 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; 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, Subrecipient Monitoring and Management, §200.332 Requirements for pass-through entities (2 CFR 200.332): All pass-through entities must: (a) Evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section, which may include consideration of such factors as: (1) The subrecipient's prior experience with the same or similar subawards; (2) The results of previous audits including whether or not the subrecipient receives a Single Audit in accordance with Subpart F of this part, and the extent to which the same or similar subaward has 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 awarding agency monitoring (e.g., if the subrecipient also receives Federal awards directly from a Federal awarding agency). Condition: During our testing of the Imperial County Workforce Development Office’s (ICWDO) provisions for subrecipient monitoring under the WIOA Cluster, we noted the following instances: For one (1) of the one (1) subrecipient selected for testing, there was no review or approval over the monitoring procedures performed by ICWDO monitoring staff. The entire population of one (1) subrecipient. • The following information was not provided at the time of the subaward for one (1) of the one (1) subaward selected for testing: o Federal award identification number o Federal award date of award to recipient by the Federal agency o Name of federal awarding agency o Federal Financial Assistance Listing/CFDA Number o Identification of whether the award is research and development • The County did not document their evaluation of each subrecipient’s risk of noncompliance Cause: The County’s ICWDO department does not have a formal procedure in place for the department’s review and approval over the monitoring procedures performed by the department over its subrecipients. The ICWDO department did not ensure that the required award information and applicable requirements were communicated to the subrecipients and did not maintain documentation of their evaluation of each subrecipient’s risk of noncompliance. Effect: The County’s ICWDO department did not review and approve monitoring procedures performed over its subrecipients. Additionally, the ICWDO department did not maintain policies and procedures to align with the Subrecipient Monitoring requirements in 2 CFR 200.332 (a) and 200.332(b). Identification as a Repeat Finding, If Applicable: Yes. See Finding 2021-008. Questioned Costs: No questioned costs were identified. Recommendation: Social Services should continue to monitor compliance with its policies to ensure case workers follow the established guidelines for redetermination of the recipients of need and amount of assistance and retain acceptable documentation to support the determinations. View of Responsible Officials and Planned Corrective Action: See separate Corrective Action Plan.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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 – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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 – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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 – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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 – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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 – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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 – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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 – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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 – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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 – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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 – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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 – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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 – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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 – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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 – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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 – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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 – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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 – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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 – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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 – Schedule of Expenditures of Federal Awards 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. 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 School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District 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.
2022-005 Indirect Cost Allocations - Activities Allowed or Unallowed and Allowable Costs/Cost Principles Federal Program: Research and Development Cluster (ALN 47.041, Award Period 9/1/19 – 8/31/22) Federal Agency: National Science Foundation Criteria: Program costs for allocation of indirect costs were based on percentage of total costs at year end and not allocated based on specific allocations of costs incurred and approved in a timely manner as required by 2 CFR 200.414. Condition: Our testing noted that program charges include journal entries allocate indirect costs without necessary review and approvals to ensure allowability of the costs to program activities. Cause: The Organization lacks written policies, approval procedures and documentation to allocate indirect costs to the program. Effect: The Organization is not compliant with 2 CFR 2 CFR 200.414 which requires accurate, and complete disclosure of financial results including the allocation of approved and identified actual indirect costs incurred to the program in accordance with 2 CFR 200.414. Identification as a repeat finding, if applicable: The finding is a repeat of Finding 2021-006 in the prior year. Recommendation: We recommend the Organization establish policy and procedures to identify and approve allowable indirect costs chargeable to the program on a monthly basis and report this allocation in the accounting ledger separately from the general expenses of the company. Response: The Organization will allocate indirect costs to program costs based on incurred costs. Monthly allocations will be approved by the program administrator and separately reported in the general ledger. Questioned Costs: $78,400 – This is the amount of indirect costs charged to the program.
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) 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. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) 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. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs' compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) 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. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) 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. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs' compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) 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. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) 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. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs' compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) 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. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) 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. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs' compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) 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. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) 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. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs' compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) 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. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) 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. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs' compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
2022-005 Indirect Cost Allocations - Activities Allowed or Unallowed and Allowable Costs/Cost Principles Federal Program: Research and Development Cluster (ALN 47.041-Engineering, Award 1940055, Award Period 9/1/19 – 8/31/22) Federal Agency: National Science Foundation Criteria: Program costs for allocation of indirect costs were based on percentage of total costs at year end and not allocated based on specific allocations of costs incurred and approved in a timely manner as required by 2 CFR 200.414. Condition: Our testing noted that program charges include journal entries to allocate indirect costs without necessary review and approvals to ensure allowability of the costs to program activities. Cause: The Organization lacks written policies, approval procedures and documentation to allocate indirect costs to the program. Effect: The Organization is not compliant with 2 CFR 2 CFR 200.414 which requires accurate, and complete disclosure of financial results including the allocation of approved and identified actual indirect costs incurred to the program in accordance with 2 CFR 200.414. Without a policy of reviewing and approving indirect costs on a regular basis, there is a risk that unallowable costs are allocated to the program. Identification as a repeat finding, if applicable: The finding is a repeat of Finding 2021-006 in the prior year. Recommendation: We recommend the Organization establish policy and procedures to identify and approve allowable indirect costs chargeable to the program on a monthly basis and report this allocation in the accounting ledger separately from the general expenses of the company. Response: The Organization will allocate indirect costs to program costs based on incurred costs. Monthly allocations will be approved by the program administrator and separately reported in the general ledger. Questioned Costs: $78,400 – This is the amount of indirect costs charged to the program.
Criteria: Title 2 of the Code of Federal Regulations (2 CFR), Part 200, Subpart E defines and discusses the federal cost principles that apply to federal awards administered by nonprofit organizations. The applicable sections of these cost principes are as follows: • 2 CFR 200.403 Factors affecting allowability of costs • 2 CFR 200.404 Reasonable costs • 2 CFR 200.405 Allocable costs • 2 CFR 200.413 Direct costs • 2 CFR 200.414 Indirect (F&A) costs Condition: The following were noted as related to compliance with allowable costs, cost allocation and federal cost principles: • Internal control on time spent by employees related to administrative functions or other indirect cost activities has not been properly designed or implemented. • All employee time, including employees and professional services contractors are being recorded directly to programs. Time spent on indirect activities is not being properly identified or properly allocated to programs. • A portion of time of the Operations Manager (Chief Executive of the Organization) is spent related to administrative time or other indirect cost activities. However, none of that time has been identified or charged as indirect costs. • The time card for the Operations Manager (Chief Executive of the Organization) is not reviewed or approved by a board member or other senior executive of the Organization. • The accounting services of AIRS is being provided by a third-party outsourced accountant. The costs related to these services were improperly recorded as direct personnel costs to the program rather than properly classified as indirect costs. • Payroll taxes, employee benefits and other allowable employee related expenses were allocated to the program in a manner that does not accurately reflect the relative benefits received. These costs were allocated to the program as a percentage of total payroll costs, however, the percentage used exceeds that actual percentage of these costs as a percentage of total payroll costs. • A reasonable, consistent and uniform cost allocation methodology has not been properly designed or implemented. Costs that benefit both federal programs, non-federal programs and indirect costs are not being allocated properly across and to federal programs, non-federal programs and indirect costs in a reasonable, consistent and uniform manner. • Certain direct costs charged to the program were not based on actual costs incurred and the amounts charged were not adequately supported. • Indirect costs were not properly identified and segregated from direct costs. • Allowable indirect costs were not charged to the federal program. Cause: AIRS accounting staff and senior management do not appear to have a full and complete understanding of Uniform Guidance or of the applicable federal cost principles. Management has not properly applied the applicable federal costs principles in 2 CFR, Part 200, Subpart E to the costs charged to the federal program. Effect: Payroll costs and allowable employee related expenses, certain direct costs, allocable direct costs and indirect costs were not properly charged to the federal program. In order to estimate the questioned costs, the auditor, with the assistance of management, developed a costs allocation methodology that charges costs to the federal program in a reasonable, consistent and uniform manner in compliance with the costs principles contained in 2 CFR, Part 200, Subpart E. The primarily characteristics of this methodology are as follows: • Based upon discussions with management, review of the job description, roles and responsibilities of the Operations Manager and using prior experience and comparison to similar nonprofit organizations; an estimate of the percentage of time spent by the Operations Manager related to administration and other indirect activities was developed. • The time for the outsourced accounting services provider was removed from direct personnel costs and charged to indirect costs. • After the above revisions were made, the auditor assisted management in reallocating payroll costs across all federal and nonfederal programs and to indirect costs in a reasonable, consistent and uniform manner. • Allowable payroll taxes, benefits and other employee related expense charges were estimated using the actual percentage of these expenses as a percentage of total allowable payroll costs. • Non-allocable direct costs were charged to the program at the actual amount of those costs incurred. • Allocable direct costs charges were estimated by allocating those costs to the federal program on the basis of allowable payroll costs charged to program as a percentage of total allowable payroll costs (percentage of payroll methodology). This methodology is in compliance with the requirements of 2 CFR 200.405 and appears to produce a result that reasonably estimates the proportional benefit of these costs to all federal and non-federal programs, and to indirect cost activities. • Indirect costs were estimated and charged to the program using the 10% de minimis indirect cost rate as defined in 2 CFR 200.414. Questioned Costs: Using the methodology described above, the auditor has estimated total federal expenditures allowable to the program of $247,119. However, AIRS has charged federal expenditures of $272,781 to the program. Therefore, the estimated questioned costs related to this program are $25,662. Repeat Finding from Prior Year: No Recommendation: Senior management and accounting personnel should create procedures to ensure that direct program costs are charged at the actual amounts incurred, develop a payroll cost allocation methodology, and an allocable direct cost allocation methodology that ensures that costs are reasonably, consistently and uniformly charged to and across all federal and non-federal programs and to indirect costs relative to the proportional benefit of those costs, and in compliance with the applicable federal cost principles in 2 CFR, Part 200, Subpart E. Management and the board should consider providing senior management, accounting personnel and applicable program personnel additional training and education related to the proper application of and compliance with the federal costs principles as defined in 2 CFR, Part 200, Subpart E. Management and the board may also want to consider engaging a third-party CPA or other accounting professional who has extensive prior skills, knowledge and experience related to Uniform Guidance and federal cost principles. Views of Responsible Officials: Management concurs with this audit finding.
Federal Agency: U.S. Department of Interior Federal Program Name: National Park Service Conservation, Protection, Outreach, and Education (POE) Research and Development Cluster (RDC) Assistance Listing Number: 15.954 (POE) 15.608 and 15.945 (RDC) Award Period: June 2020 through August 2024 (POE) September 2019 through January 2024 (RDC) Statistically Valid Sample: No, and not intended to be a Statistically Valid Sample. Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or Specific Requirement: In accordance with 2 CFR 200.414 Indirect Costs, any nonfederal entity that does not have current negotiated rate and elects the 10% de minimis rate must be applied to modified total direct costs (MTDC) indefinitely and in accordance with 2 CFR 200 UG, costs of compensation are allowable to the extent that they satisfy the specific requirements of the UG, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the nonfederal entity consistently applied to both federal and nonfederal activities; (2) Follows an appointment made in accordance with a nonfederal entity's laws and/or rules or written policies and meets the requirements of federal statute, where applicable; and (3) Is determined and supported as provided in accordance with the UG, Standards for Documentation of Personnel Expenses, when applicable. Charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the nonfederal entity, (iv) Encompass both federally assisted and all other activities compensated by the nonfederal entity on an integrated basis, but may include the use of subsidiary records as defined in the nonfederal entity's written policy; (v) Comply with the established accounting policies and practices of the nonfederal entity; and (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a federal award and nonfederal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition/Context: We noted instances where an indirect rate of 17.5 percent was charged to federal awards instead of the 10 percent de minimis rate approved in the budgets. Additionally, we were unable to obtain evidence of federal approval of a 1.8 percent administration fee charged to gross wages as follows: • POE & RDC - For 4 of the 4 months tested, 17.5 percent of indirect rate was charged to various awards instead of the 10 percent de minimis rate. • POE - For 12 of the 36 items tested, we noted a 1.8 percent administration fee charged to gross wages. • RDC - For 22 of the 22 items tested, we noted a 1.8 percent administration fee charged to gross wages. Questioned Costs: None greater than $25,000 per major program. Cause: Not aware of the requirements. Effect: Failure to comply with 2 CFR 200 can lead to improper payments charged to programs. Repeat Finding: No Recommendation: We recommend management incorporate review control procedures to ensure the 10 percent de minimis rate is properly applied in accordance with UG and ensure appropriate costs are charged to the awards consistent with their federally approved budgets. Views of Responsible Officials: There is no disagreement with the audit finding. See corrective action plan.
Federal Agency: U.S. Department of Interior Federal Program Name: National Park Service Conservation, Protection, Outreach, and Education (POE) Research and Development Cluster (RDC) Assistance Listing Number: 15.954 (POE) 15.608 and 15.945 (RDC) Award Period: June 2020 through August 2024 (POE) September 2019 through January 2024 (RDC) Statistically Valid Sample: No, and not intended to be a Statistically Valid Sample. Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or Specific Requirement: In accordance with 2 CFR 200.414 Indirect Costs, any nonfederal entity that does not have current negotiated rate and elects the 10% de minimis rate must be applied to modified total direct costs (MTDC) indefinitely and in accordance with 2 CFR 200 UG, costs of compensation are allowable to the extent that they satisfy the specific requirements of the UG, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the nonfederal entity consistently applied to both federal and nonfederal activities; (2) Follows an appointment made in accordance with a nonfederal entity's laws and/or rules or written policies and meets the requirements of federal statute, where applicable; and (3) Is determined and supported as provided in accordance with the UG, Standards for Documentation of Personnel Expenses, when applicable. Charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the nonfederal entity, (iv) Encompass both federally assisted and all other activities compensated by the nonfederal entity on an integrated basis, but may include the use of subsidiary records as defined in the nonfederal entity's written policy; (v) Comply with the established accounting policies and practices of the nonfederal entity; and (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a federal award and nonfederal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition/Context: We noted instances where an indirect rate of 17.5 percent was charged to federal awards instead of the 10 percent de minimis rate approved in the budgets. Additionally, we were unable to obtain evidence of federal approval of a 1.8 percent administration fee charged to gross wages as follows: • POE & RDC - For 4 of the 4 months tested, 17.5 percent of indirect rate was charged to various awards instead of the 10 percent de minimis rate. • POE - For 12 of the 36 items tested, we noted a 1.8 percent administration fee charged to gross wages. • RDC - For 22 of the 22 items tested, we noted a 1.8 percent administration fee charged to gross wages. Questioned Costs: None greater than $25,000 per major program. Cause: Not aware of the requirements. Effect: Failure to comply with 2 CFR 200 can lead to improper payments charged to programs. Repeat Finding: No Recommendation: We recommend management incorporate review control procedures to ensure the 10 percent de minimis rate is properly applied in accordance with UG and ensure appropriate costs are charged to the awards consistent with their federally approved budgets. Views of Responsible Officials: There is no disagreement with the audit finding. See corrective action plan.
Federal Agency: U.S. Department of Interior Federal Program Name: National Park Service Conservation, Protection, Outreach, and Education (POE) Research and Development Cluster (RDC) Assistance Listing Number: 15.954 (POE) 15.608 and 15.945 (RDC) Award Period: June 2020 through August 2024 (POE) September 2019 through January 2024 (RDC) Statistically Valid Sample: No, and not intended to be a Statistically Valid Sample. Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or Specific Requirement: In accordance with 2 CFR 200.414 Indirect Costs, any nonfederal entity that does not have current negotiated rate and elects the 10% de minimis rate must be applied to modified total direct costs (MTDC) indefinitely and in accordance with 2 CFR 200 UG, costs of compensation are allowable to the extent that they satisfy the specific requirements of the UG, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the nonfederal entity consistently applied to both federal and nonfederal activities; (2) Follows an appointment made in accordance with a nonfederal entity's laws and/or rules or written policies and meets the requirements of federal statute, where applicable; and (3) Is determined and supported as provided in accordance with the UG, Standards for Documentation of Personnel Expenses, when applicable. Charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the nonfederal entity, (iv) Encompass both federally assisted and all other activities compensated by the nonfederal entity on an integrated basis, but may include the use of subsidiary records as defined in the nonfederal entity's written policy; (v) Comply with the established accounting policies and practices of the nonfederal entity; and (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a federal award and nonfederal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition/Context: We noted instances where an indirect rate of 17.5 percent was charged to federal awards instead of the 10 percent de minimis rate approved in the budgets. Additionally, we were unable to obtain evidence of federal approval of a 1.8 percent administration fee charged to gross wages as follows: • POE & RDC - For 4 of the 4 months tested, 17.5 percent of indirect rate was charged to various awards instead of the 10 percent de minimis rate. • POE - For 12 of the 36 items tested, we noted a 1.8 percent administration fee charged to gross wages. • RDC - For 22 of the 22 items tested, we noted a 1.8 percent administration fee charged to gross wages. Questioned Costs: None greater than $25,000 per major program. Cause: Not aware of the requirements. Effect: Failure to comply with 2 CFR 200 can lead to improper payments charged to programs. Repeat Finding: No Recommendation: We recommend management incorporate review control procedures to ensure the 10 percent de minimis rate is properly applied in accordance with UG and ensure appropriate costs are charged to the awards consistent with their federally approved budgets. Views of Responsible Officials: There is no disagreement with the audit finding. See corrective action plan.
Federal Agency: U.S. Department of Interior Federal Program Name: National Park Service Conservation, Protection, Outreach, and Education (POE) Research and Development Cluster (RDC) Assistance Listing Number: 15.954 (POE) 15.608 and 15.945 (RDC) Award Period: June 2020 through August 2024 (POE) September 2019 through January 2024 (RDC) Statistically Valid Sample: No, and not intended to be a Statistically Valid Sample. Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or Specific Requirement: In accordance with 2 CFR 200.414 Indirect Costs, any nonfederal entity that does not have current negotiated rate and elects the 10% de minimis rate must be applied to modified total direct costs (MTDC) indefinitely and in accordance with 2 CFR 200 UG, costs of compensation are allowable to the extent that they satisfy the specific requirements of the UG, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the nonfederal entity consistently applied to both federal and nonfederal activities; (2) Follows an appointment made in accordance with a nonfederal entity's laws and/or rules or written policies and meets the requirements of federal statute, where applicable; and (3) Is determined and supported as provided in accordance with the UG, Standards for Documentation of Personnel Expenses, when applicable. Charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the nonfederal entity, (iv) Encompass both federally assisted and all other activities compensated by the nonfederal entity on an integrated basis, but may include the use of subsidiary records as defined in the nonfederal entity's written policy; (v) Comply with the established accounting policies and practices of the nonfederal entity; and (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a federal award and nonfederal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition/Context: We noted instances where an indirect rate of 17.5 percent was charged to federal awards instead of the 10 percent de minimis rate approved in the budgets. Additionally, we were unable to obtain evidence of federal approval of a 1.8 percent administration fee charged to gross wages as follows: • POE & RDC - For 4 of the 4 months tested, 17.5 percent of indirect rate was charged to various awards instead of the 10 percent de minimis rate. • POE - For 12 of the 36 items tested, we noted a 1.8 percent administration fee charged to gross wages. • RDC - For 22 of the 22 items tested, we noted a 1.8 percent administration fee charged to gross wages. Questioned Costs: None greater than $25,000 per major program. Cause: Not aware of the requirements. Effect: Failure to comply with 2 CFR 200 can lead to improper payments charged to programs. Repeat Finding: No Recommendation: We recommend management incorporate review control procedures to ensure the 10 percent de minimis rate is properly applied in accordance with UG and ensure appropriate costs are charged to the awards consistent with their federally approved budgets. Views of Responsible Officials: There is no disagreement with the audit finding. See corrective action plan.
Federal Agency: U.S. Department of Interior Federal Program Name: National Park Service Conservation, Protection, Outreach, and Education (POE) Research and Development Cluster (RDC) Assistance Listing Number: 15.954 (POE) 15.608 and 15.945 (RDC) Award Period: June 2020 through August 2024 (POE) September 2019 through January 2024 (RDC) Statistically Valid Sample: No, and not intended to be a Statistically Valid Sample. Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or Specific Requirement: In accordance with 2 CFR 200.414 Indirect Costs, any nonfederal entity that does not have current negotiated rate and elects the 10% de minimis rate must be applied to modified total direct costs (MTDC) indefinitely and in accordance with 2 CFR 200 UG, costs of compensation are allowable to the extent that they satisfy the specific requirements of the UG, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the nonfederal entity consistently applied to both federal and nonfederal activities; (2) Follows an appointment made in accordance with a nonfederal entity's laws and/or rules or written policies and meets the requirements of federal statute, where applicable; and (3) Is determined and supported as provided in accordance with the UG, Standards for Documentation of Personnel Expenses, when applicable. Charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the nonfederal entity, (iv) Encompass both federally assisted and all other activities compensated by the nonfederal entity on an integrated basis, but may include the use of subsidiary records as defined in the nonfederal entity's written policy; (v) Comply with the established accounting policies and practices of the nonfederal entity; and (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a federal award and nonfederal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition/Context: We noted instances where an indirect rate of 17.5 percent was charged to federal awards instead of the 10 percent de minimis rate approved in the budgets. Additionally, we were unable to obtain evidence of federal approval of a 1.8 percent administration fee charged to gross wages as follows: • POE & RDC - For 4 of the 4 months tested, 17.5 percent of indirect rate was charged to various awards instead of the 10 percent de minimis rate. • POE - For 12 of the 36 items tested, we noted a 1.8 percent administration fee charged to gross wages. • RDC - For 22 of the 22 items tested, we noted a 1.8 percent administration fee charged to gross wages. Questioned Costs: None greater than $25,000 per major program. Cause: Not aware of the requirements. Effect: Failure to comply with 2 CFR 200 can lead to improper payments charged to programs. Repeat Finding: No Recommendation: We recommend management incorporate review control procedures to ensure the 10 percent de minimis rate is properly applied in accordance with UG and ensure appropriate costs are charged to the awards consistent with their federally approved budgets. Views of Responsible Officials: There is no disagreement with the audit finding. See corrective action plan.
Federal Agency: U.S. Department of Interior Federal Program Name: National Park Service Conservation, Protection, Outreach, and Education (POE) Research and Development Cluster (RDC) Assistance Listing Number: 15.954 (POE) 15.608 and 15.945 (RDC) Award Period: June 2020 through August 2024 (POE) September 2019 through January 2024 (RDC) Statistically Valid Sample: No, and not intended to be a Statistically Valid Sample. Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or Specific Requirement: In accordance with 2 CFR 200.414 Indirect Costs, any nonfederal entity that does not have current negotiated rate and elects the 10% de minimis rate must be applied to modified total direct costs (MTDC) indefinitely and in accordance with 2 CFR 200 UG, costs of compensation are allowable to the extent that they satisfy the specific requirements of the UG, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the nonfederal entity consistently applied to both federal and nonfederal activities; (2) Follows an appointment made in accordance with a nonfederal entity's laws and/or rules or written policies and meets the requirements of federal statute, where applicable; and (3) Is determined and supported as provided in accordance with the UG, Standards for Documentation of Personnel Expenses, when applicable. Charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the nonfederal entity, (iv) Encompass both federally assisted and all other activities compensated by the nonfederal entity on an integrated basis, but may include the use of subsidiary records as defined in the nonfederal entity's written policy; (v) Comply with the established accounting policies and practices of the nonfederal entity; and (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a federal award and nonfederal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition/Context: We noted instances where an indirect rate of 17.5 percent was charged to federal awards instead of the 10 percent de minimis rate approved in the budgets. Additionally, we were unable to obtain evidence of federal approval of a 1.8 percent administration fee charged to gross wages as follows: • POE & RDC - For 4 of the 4 months tested, 17.5 percent of indirect rate was charged to various awards instead of the 10 percent de minimis rate. • POE - For 12 of the 36 items tested, we noted a 1.8 percent administration fee charged to gross wages. • RDC - For 22 of the 22 items tested, we noted a 1.8 percent administration fee charged to gross wages. Questioned Costs: None greater than $25,000 per major program. Cause: Not aware of the requirements. Effect: Failure to comply with 2 CFR 200 can lead to improper payments charged to programs. Repeat Finding: No Recommendation: We recommend management incorporate review control procedures to ensure the 10 percent de minimis rate is properly applied in accordance with UG and ensure appropriate costs are charged to the awards consistent with their federally approved budgets. Views of Responsible Officials: There is no disagreement with the audit finding. See corrective action plan.
Federal Agency: U.S. Department of Interior Federal Program Name: National Park Service Conservation, Protection, Outreach, and Education (POE) Research and Development Cluster (RDC) Assistance Listing Number: 15.954 (POE) 15.608 and 15.945 (RDC) Award Period: June 2020 through August 2024 (POE) September 2019 through January 2024 (RDC) Statistically Valid Sample: No, and not intended to be a Statistically Valid Sample. Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or Specific Requirement: In accordance with 2 CFR 200.414 Indirect Costs, any nonfederal entity that does not have current negotiated rate and elects the 10% de minimis rate must be applied to modified total direct costs (MTDC) indefinitely and in accordance with 2 CFR 200 UG, costs of compensation are allowable to the extent that they satisfy the specific requirements of the UG, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the nonfederal entity consistently applied to both federal and nonfederal activities; (2) Follows an appointment made in accordance with a nonfederal entity's laws and/or rules or written policies and meets the requirements of federal statute, where applicable; and (3) Is determined and supported as provided in accordance with the UG, Standards for Documentation of Personnel Expenses, when applicable. Charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the nonfederal entity, (iv) Encompass both federally assisted and all other activities compensated by the nonfederal entity on an integrated basis, but may include the use of subsidiary records as defined in the nonfederal entity's written policy; (v) Comply with the established accounting policies and practices of the nonfederal entity; and (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a federal award and nonfederal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition/Context: We noted instances where an indirect rate of 17.5 percent was charged to federal awards instead of the 10 percent de minimis rate approved in the budgets. Additionally, we were unable to obtain evidence of federal approval of a 1.8 percent administration fee charged to gross wages as follows: • POE & RDC - For 4 of the 4 months tested, 17.5 percent of indirect rate was charged to various awards instead of the 10 percent de minimis rate. • POE - For 12 of the 36 items tested, we noted a 1.8 percent administration fee charged to gross wages. • RDC - For 22 of the 22 items tested, we noted a 1.8 percent administration fee charged to gross wages. Questioned Costs: None greater than $25,000 per major program. Cause: Not aware of the requirements. Effect: Failure to comply with 2 CFR 200 can lead to improper payments charged to programs. Repeat Finding: No Recommendation: We recommend management incorporate review control procedures to ensure the 10 percent de minimis rate is properly applied in accordance with UG and ensure appropriate costs are charged to the awards consistent with their federally approved budgets. Views of Responsible Officials: There is no disagreement with the audit finding. See corrective action plan.
Federal Agency: U.S. Department of Interior Federal Program Name: National Park Service Conservation, Protection, Outreach, and Education (POE) Research and Development Cluster (RDC) Assistance Listing Number: 15.954 (POE) 15.608 and 15.945 (RDC) Award Period: June 2020 through August 2024 (POE) September 2019 through January 2024 (RDC) Statistically Valid Sample: No, and not intended to be a Statistically Valid Sample. Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or Specific Requirement: In accordance with 2 CFR 200.414 Indirect Costs, any nonfederal entity that does not have current negotiated rate and elects the 10% de minimis rate must be applied to modified total direct costs (MTDC) indefinitely and in accordance with 2 CFR 200 UG, costs of compensation are allowable to the extent that they satisfy the specific requirements of the UG, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the nonfederal entity consistently applied to both federal and nonfederal activities; (2) Follows an appointment made in accordance with a nonfederal entity's laws and/or rules or written policies and meets the requirements of federal statute, where applicable; and (3) Is determined and supported as provided in accordance with the UG, Standards for Documentation of Personnel Expenses, when applicable. Charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the nonfederal entity, (iv) Encompass both federally assisted and all other activities compensated by the nonfederal entity on an integrated basis, but may include the use of subsidiary records as defined in the nonfederal entity's written policy; (v) Comply with the established accounting policies and practices of the nonfederal entity; and (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a federal award and nonfederal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition/Context: We noted instances where an indirect rate of 17.5 percent was charged to federal awards instead of the 10 percent de minimis rate approved in the budgets. Additionally, we were unable to obtain evidence of federal approval of a 1.8 percent administration fee charged to gross wages as follows: • POE & RDC - For 4 of the 4 months tested, 17.5 percent of indirect rate was charged to various awards instead of the 10 percent de minimis rate. • POE - For 12 of the 36 items tested, we noted a 1.8 percent administration fee charged to gross wages. • RDC - For 22 of the 22 items tested, we noted a 1.8 percent administration fee charged to gross wages. Questioned Costs: None greater than $25,000 per major program. Cause: Not aware of the requirements. Effect: Failure to comply with 2 CFR 200 can lead to improper payments charged to programs. Repeat Finding: No Recommendation: We recommend management incorporate review control procedures to ensure the 10 percent de minimis rate is properly applied in accordance with UG and ensure appropriate costs are charged to the awards consistent with their federally approved budgets. Views of Responsible Officials: There is no disagreement with the audit finding. See corrective action plan.
Federal Agency: U.S. Department of Interior Federal Program Name: National Park Service Conservation, Protection, Outreach, and Education (POE) Research and Development Cluster (RDC) Assistance Listing Number: 15.954 (POE) 15.608 and 15.945 (RDC) Award Period: June 2020 through August 2024 (POE) September 2019 through January 2024 (RDC) Statistically Valid Sample: No, and not intended to be a Statistically Valid Sample. Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or Specific Requirement: In accordance with 2 CFR 200.414 Indirect Costs, any nonfederal entity that does not have current negotiated rate and elects the 10% de minimis rate must be applied to modified total direct costs (MTDC) indefinitely and in accordance with 2 CFR 200 UG, costs of compensation are allowable to the extent that they satisfy the specific requirements of the UG, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the nonfederal entity consistently applied to both federal and nonfederal activities; (2) Follows an appointment made in accordance with a nonfederal entity's laws and/or rules or written policies and meets the requirements of federal statute, where applicable; and (3) Is determined and supported as provided in accordance with the UG, Standards for Documentation of Personnel Expenses, when applicable. Charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the nonfederal entity, (iv) Encompass both federally assisted and all other activities compensated by the nonfederal entity on an integrated basis, but may include the use of subsidiary records as defined in the nonfederal entity's written policy; (v) Comply with the established accounting policies and practices of the nonfederal entity; and (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a federal award and nonfederal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition/Context: We noted instances where an indirect rate of 17.5 percent was charged to federal awards instead of the 10 percent de minimis rate approved in the budgets. Additionally, we were unable to obtain evidence of federal approval of a 1.8 percent administration fee charged to gross wages as follows: • POE & RDC - For 4 of the 4 months tested, 17.5 percent of indirect rate was charged to various awards instead of the 10 percent de minimis rate. • POE - For 12 of the 36 items tested, we noted a 1.8 percent administration fee charged to gross wages. • RDC - For 22 of the 22 items tested, we noted a 1.8 percent administration fee charged to gross wages. Questioned Costs: None greater than $25,000 per major program. Cause: Not aware of the requirements. Effect: Failure to comply with 2 CFR 200 can lead to improper payments charged to programs. Repeat Finding: No Recommendation: We recommend management incorporate review control procedures to ensure the 10 percent de minimis rate is properly applied in accordance with UG and ensure appropriate costs are charged to the awards consistent with their federally approved budgets. Views of Responsible Officials: There is no disagreement with the audit finding. See corrective action plan.
Federal Agency: U.S. Department of Interior Federal Program Name: National Park Service Conservation, Protection, Outreach, and Education (POE) Research and Development Cluster (RDC) Assistance Listing Number: 15.954 (POE) 15.608 and 15.945 (RDC) Award Period: June 2020 through August 2024 (POE) September 2019 through January 2024 (RDC) Statistically Valid Sample: No, and not intended to be a Statistically Valid Sample. Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or Specific Requirement: In accordance with 2 CFR 200.414 Indirect Costs, any nonfederal entity that does not have current negotiated rate and elects the 10% de minimis rate must be applied to modified total direct costs (MTDC) indefinitely and in accordance with 2 CFR 200 UG, costs of compensation are allowable to the extent that they satisfy the specific requirements of the UG, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the nonfederal entity consistently applied to both federal and nonfederal activities; (2) Follows an appointment made in accordance with a nonfederal entity's laws and/or rules or written policies and meets the requirements of federal statute, where applicable; and (3) Is determined and supported as provided in accordance with the UG, Standards for Documentation of Personnel Expenses, when applicable. Charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the nonfederal entity, (iv) Encompass both federally assisted and all other activities compensated by the nonfederal entity on an integrated basis, but may include the use of subsidiary records as defined in the nonfederal entity's written policy; (v) Comply with the established accounting policies and practices of the nonfederal entity; and (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a federal award and nonfederal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition/Context: We noted instances where an indirect rate of 17.5 percent was charged to federal awards instead of the 10 percent de minimis rate approved in the budgets. Additionally, we were unable to obtain evidence of federal approval of a 1.8 percent administration fee charged to gross wages as follows: • POE & RDC - For 4 of the 4 months tested, 17.5 percent of indirect rate was charged to various awards instead of the 10 percent de minimis rate. • POE - For 12 of the 36 items tested, we noted a 1.8 percent administration fee charged to gross wages. • RDC - For 22 of the 22 items tested, we noted a 1.8 percent administration fee charged to gross wages. Questioned Costs: None greater than $25,000 per major program. Cause: Not aware of the requirements. Effect: Failure to comply with 2 CFR 200 can lead to improper payments charged to programs. Repeat Finding: No Recommendation: We recommend management incorporate review control procedures to ensure the 10 percent de minimis rate is properly applied in accordance with UG and ensure appropriate costs are charged to the awards consistent with their federally approved budgets. Views of Responsible Officials: There is no disagreement with the audit finding. See corrective action plan.
Federal Agency: U.S. Department of Interior Federal Program Name: National Park Service Conservation, Protection, Outreach, and Education (POE) Research and Development Cluster (RDC) Assistance Listing Number: 15.954 (POE) 15.608 and 15.945 (RDC) Award Period: June 2020 through August 2024 (POE) September 2019 through January 2024 (RDC) Statistically Valid Sample: No, and not intended to be a Statistically Valid Sample. Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or Specific Requirement: In accordance with 2 CFR 200.414 Indirect Costs, any nonfederal entity that does not have current negotiated rate and elects the 10% de minimis rate must be applied to modified total direct costs (MTDC) indefinitely and in accordance with 2 CFR 200 UG, costs of compensation are allowable to the extent that they satisfy the specific requirements of the UG, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the nonfederal entity consistently applied to both federal and nonfederal activities; (2) Follows an appointment made in accordance with a nonfederal entity's laws and/or rules or written policies and meets the requirements of federal statute, where applicable; and (3) Is determined and supported as provided in accordance with the UG, Standards for Documentation of Personnel Expenses, when applicable. Charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the nonfederal entity, (iv) Encompass both federally assisted and all other activities compensated by the nonfederal entity on an integrated basis, but may include the use of subsidiary records as defined in the nonfederal entity's written policy; (v) Comply with the established accounting policies and practices of the nonfederal entity; and (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a federal award and nonfederal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition/Context: We noted instances where an indirect rate of 17.5 percent was charged to federal awards instead of the 10 percent de minimis rate approved in the budgets. Additionally, we were unable to obtain evidence of federal approval of a 1.8 percent administration fee charged to gross wages as follows: • POE & RDC - For 4 of the 4 months tested, 17.5 percent of indirect rate was charged to various awards instead of the 10 percent de minimis rate. • POE - For 12 of the 36 items tested, we noted a 1.8 percent administration fee charged to gross wages. • RDC - For 22 of the 22 items tested, we noted a 1.8 percent administration fee charged to gross wages. Questioned Costs: None greater than $25,000 per major program. Cause: Not aware of the requirements. Effect: Failure to comply with 2 CFR 200 can lead to improper payments charged to programs. Repeat Finding: No Recommendation: We recommend management incorporate review control procedures to ensure the 10 percent de minimis rate is properly applied in accordance with UG and ensure appropriate costs are charged to the awards consistent with their federally approved budgets. Views of Responsible Officials: There is no disagreement with the audit finding. See corrective action plan.
Federal Agency: U.S. Department of Interior Federal Program Name: National Park Service Conservation, Protection, Outreach, and Education (POE) Research and Development Cluster (RDC) Assistance Listing Number: 15.954 (POE) 15.608 and 15.945 (RDC) Award Period: June 2020 through August 2024 (POE) September 2019 through January 2024 (RDC) Statistically Valid Sample: No, and not intended to be a Statistically Valid Sample. Type of Finding: Significant Deficiency in Internal Control over Compliance and Noncompliance Criteria or Specific Requirement: In accordance with 2 CFR 200.414 Indirect Costs, any nonfederal entity that does not have current negotiated rate and elects the 10% de minimis rate must be applied to modified total direct costs (MTDC) indefinitely and in accordance with 2 CFR 200 UG, costs of compensation are allowable to the extent that they satisfy the specific requirements of the UG, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the nonfederal entity consistently applied to both federal and nonfederal activities; (2) Follows an appointment made in accordance with a nonfederal entity's laws and/or rules or written policies and meets the requirements of federal statute, where applicable; and (3) Is determined and supported as provided in accordance with the UG, Standards for Documentation of Personnel Expenses, when applicable. Charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the nonfederal entity, (iv) Encompass both federally assisted and all other activities compensated by the nonfederal entity on an integrated basis, but may include the use of subsidiary records as defined in the nonfederal entity's written policy; (v) Comply with the established accounting policies and practices of the nonfederal entity; and (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a federal award and nonfederal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition/Context: We noted instances where an indirect rate of 17.5 percent was charged to federal awards instead of the 10 percent de minimis rate approved in the budgets. Additionally, we were unable to obtain evidence of federal approval of a 1.8 percent administration fee charged to gross wages as follows: • POE & RDC - For 4 of the 4 months tested, 17.5 percent of indirect rate was charged to various awards instead of the 10 percent de minimis rate. • POE - For 12 of the 36 items tested, we noted a 1.8 percent administration fee charged to gross wages. • RDC - For 22 of the 22 items tested, we noted a 1.8 percent administration fee charged to gross wages. Questioned Costs: None greater than $25,000 per major program. Cause: Not aware of the requirements. Effect: Failure to comply with 2 CFR 200 can lead to improper payments charged to programs. Repeat Finding: No Recommendation: We recommend management incorporate review control procedures to ensure the 10 percent de minimis rate is properly applied in accordance with UG and ensure appropriate costs are charged to the awards consistent with their federally approved budgets. Views of Responsible Officials: There is no disagreement with the audit finding. See corrective action plan.