Federal Agency: U.S. Department of Education Federal Program Name: Title III English Language Acquisition State Grant Assistance Listing Number: 84.365 Federal Award Identification Number and Year: S365A220020 Pass-Through Agency: Maryland Department of Education (MSDE) Pass-Through Number(s): 241230-02 Award Period: 7/1/2022–9/30/2024 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Criteria or specific requirement: Compliance: Per 2 CFR Section 200.430 (8)(i) Standards for Documentation of Personnel Expenses states that: Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (vi) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (vii) Be incorporated into the official records of the non-Federal entity; (viii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (ix) Encompass both federally assisted, and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy; (x) Comply with the established accounting policies and practices of the non-Federal entity; (viii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. 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 comply with the 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/Context: For three of forty timesheets selected for testing, the Board was unable to provide documentation to substantiate that the time and effort was dedicated to the federal program. The Board did not have effective controls in place for monitoring and obtaining adequate support to validate actual payroll expenses charged to the federal program. Questioned costs: $15,233 Cause: Controls were not operating effectively to ensure that time and effort reporting was performed and documented in a timely manner, in accordance with federal requirements. Effect: There is an increased risk of charging unallowed payroll costs to the program. Repeat Finding: No. Recommendation: We recommend that the Board reevaluate its current process, implement proper controls, and perform additional training over time and effort reporting. The Board should not seek federal reimbursement unless it can substantiate that the time and effort was dedicated to the federal program. Documentation should be readily available for audit. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or Specific Requirements The Uniform Guidance states that allowable personnel costs charged to federal programs may include reasonable amounts for activities contributing and directly related to work under an agreement (2 CFR 200.430(i)(1)(i)). Charges to federal awards for salaries and wages must be based on records that accurate reflect the work performed (2 CFR 200.430(g)(1)). Condition Material Weakness in Internal Control over Compliance – Time-and-effort reporting, or another similar internal control activity to retroactively verify employee time spent on the program was not reviewed and approved or not performed for the year ending June 30, 2024. During testing over Activities Allowed or Unallowed and Allowable Cost requirements, the following deficiencies were noted: For the Career and Technical Education program, 14 out of 14 employees selected for testing do not have time-and-effort record reflecting the distribution of the employee’s salary and wages for the federal program. For the Title III and V programs, we noted the following – o 25 out of 30 employees selected for testing did not have time-and-effort record reflecting the distribution of the employee’s salary and wages for the federal program. o 5 out of 30 employees selected for testing had time-and-effort records, however, there were no evidence of review and approval. 2 of the 5 employees also had incomplete time-and-effort reports (i.e. only for half of the fiscal year, or a few months). Questioned Costs Career Technical Education – Basic Grants to States known questioned costs: $749,547. Higher Education Institutional Aid programs known questioned costs: $1,431,770. Context The Career Technical Education program reference above had a total of $2,355,332 in expenditures for the year ended June 30, 2024, of which $1,108,453 were associated with salaries and benefits. There was a total population of 66 employees charged to the program in the fiscal year ended June 30, 2024. The Title III and V programs referenced above had a total of $2,865,454 in expenditures for the year ended June 30, 2024, of which $2,248,191 associated with salaries and benefits. There was a total population of 148 employees charged to the program in the fiscal year ended June 30, 2024. Effect Without effective internal controls in place over personnel costs, the District risks noncompliance for program costs that could be material. Cause The District does not have policies and procedures in place to review personnel charges to identify the employee costs that should and should not be charged to the federal program referenced above. Repeat Finding (Yes or No) No Recommendation The District should monitor personnel costs charged to federal programs in accordance with the Uniform Guidance. The District should review personnel costs on a regular basis to ensure that costs charged are supported by allowable activities directly related to the program. Additionally, adequate supporting documentation should be retained for personnel costs charged to the federal programs. Views of Responsible Officials and Corrective Action Plan The District and campus staff will work together to develop processes to capture proper and relevant time and effort activities. This will ensure documentation can be provided regarding personnel expenses to identify employee costs charged to federal programs.
Criteria or Specific Requirements The Uniform Guidance states that allowable personnel costs charged to federal programs may include reasonable amounts for activities contributing and directly related to work under an agreement (2 CFR 200.430(i)(1)(i)). Charges to federal awards for salaries and wages must be based on records that accurate reflect the work performed (2 CFR 200.430(g)(1)). Condition Material Weakness in Internal Control over Compliance – Time-and-effort reporting, or another similar internal control activity to retroactively verify employee time spent on the program was not reviewed and approved or not performed for the year ending June 30, 2024. During testing over Activities Allowed or Unallowed and Allowable Cost requirements, the following deficiencies were noted: For the Career and Technical Education program, 14 out of 14 employees selected for testing do not have time-and-effort record reflecting the distribution of the employee’s salary and wages for the federal program. For the Title III and V programs, we noted the following – o 25 out of 30 employees selected for testing did not have time-and-effort record reflecting the distribution of the employee’s salary and wages for the federal program. o 5 out of 30 employees selected for testing had time-and-effort records, however, there were no evidence of review and approval. 2 of the 5 employees also had incomplete time-and-effort reports (i.e. only for half of the fiscal year, or a few months). Questioned Costs Career Technical Education – Basic Grants to States known questioned costs: $749,547. Higher Education Institutional Aid programs known questioned costs: $1,431,770. Context The Career Technical Education program reference above had a total of $2,355,332 in expenditures for the year ended June 30, 2024, of which $1,108,453 were associated with salaries and benefits. There was a total population of 66 employees charged to the program in the fiscal year ended June 30, 2024. The Title III and V programs referenced above had a total of $2,865,454 in expenditures for the year ended June 30, 2024, of which $2,248,191 associated with salaries and benefits. There was a total population of 148 employees charged to the program in the fiscal year ended June 30, 2024. Effect Without effective internal controls in place over personnel costs, the District risks noncompliance for program costs that could be material. Cause The District does not have policies and procedures in place to review personnel charges to identify the employee costs that should and should not be charged to the federal program referenced above. Repeat Finding (Yes or No) No Recommendation The District should monitor personnel costs charged to federal programs in accordance with the Uniform Guidance. The District should review personnel costs on a regular basis to ensure that costs charged are supported by allowable activities directly related to the program. Additionally, adequate supporting documentation should be retained for personnel costs charged to the federal programs. Views of Responsible Officials and Corrective Action Plan The District and campus staff will work together to develop processes to capture proper and relevant time and effort activities. This will ensure documentation can be provided regarding personnel expenses to identify employee costs charged to federal programs.
Criteria or Specific Requirements The Uniform Guidance states that allowable personnel costs charged to federal programs may include reasonable amounts for activities contributing and directly related to work under an agreement (2 CFR 200.430(i)(1)(i)). Charges to federal awards for salaries and wages must be based on records that accurate reflect the work performed (2 CFR 200.430(g)(1)). Condition Material Weakness in Internal Control over Compliance – Time-and-effort reporting, or another similar internal control activity to retroactively verify employee time spent on the program was not reviewed and approved or not performed for the year ending June 30, 2024. During testing over Activities Allowed or Unallowed and Allowable Cost requirements, the following deficiencies were noted: For the Career and Technical Education program, 14 out of 14 employees selected for testing do not have time-and-effort record reflecting the distribution of the employee’s salary and wages for the federal program. For the Title III and V programs, we noted the following – o 25 out of 30 employees selected for testing did not have time-and-effort record reflecting the distribution of the employee’s salary and wages for the federal program. o 5 out of 30 employees selected for testing had time-and-effort records, however, there were no evidence of review and approval. 2 of the 5 employees also had incomplete time-and-effort reports (i.e. only for half of the fiscal year, or a few months). Questioned Costs Career Technical Education – Basic Grants to States known questioned costs: $749,547. Higher Education Institutional Aid programs known questioned costs: $1,431,770. Context The Career Technical Education program reference above had a total of $2,355,332 in expenditures for the year ended June 30, 2024, of which $1,108,453 were associated with salaries and benefits. There was a total population of 66 employees charged to the program in the fiscal year ended June 30, 2024. The Title III and V programs referenced above had a total of $2,865,454 in expenditures for the year ended June 30, 2024, of which $2,248,191 associated with salaries and benefits. There was a total population of 148 employees charged to the program in the fiscal year ended June 30, 2024. Effect Without effective internal controls in place over personnel costs, the District risks noncompliance for program costs that could be material. Cause The District does not have policies and procedures in place to review personnel charges to identify the employee costs that should and should not be charged to the federal program referenced above. Repeat Finding (Yes or No) No Recommendation The District should monitor personnel costs charged to federal programs in accordance with the Uniform Guidance. The District should review personnel costs on a regular basis to ensure that costs charged are supported by allowable activities directly related to the program. Additionally, adequate supporting documentation should be retained for personnel costs charged to the federal programs. Views of Responsible Officials and Corrective Action Plan The District and campus staff will work together to develop processes to capture proper and relevant time and effort activities. This will ensure documentation can be provided regarding personnel expenses to identify employee costs charged to federal programs.
Criteria or Specific Requirements The Uniform Guidance states that allowable personnel costs charged to federal programs may include reasonable amounts for activities contributing and directly related to work under an agreement (2 CFR 200.430(i)(1)(i)). Charges to federal awards for salaries and wages must be based on records that accurate reflect the work performed (2 CFR 200.430(g)(1)). Condition Material Weakness in Internal Control over Compliance – Time-and-effort reporting, or another similar internal control activity to retroactively verify employee time spent on the program was not reviewed and approved or not performed for the year ending June 30, 2024. During testing over Activities Allowed or Unallowed and Allowable Cost requirements, the following deficiencies were noted: For the Career and Technical Education program, 14 out of 14 employees selected for testing do not have time-and-effort record reflecting the distribution of the employee’s salary and wages for the federal program. For the Title III and V programs, we noted the following – o 25 out of 30 employees selected for testing did not have time-and-effort record reflecting the distribution of the employee’s salary and wages for the federal program. o 5 out of 30 employees selected for testing had time-and-effort records, however, there were no evidence of review and approval. 2 of the 5 employees also had incomplete time-and-effort reports (i.e. only for half of the fiscal year, or a few months). Questioned Costs Career Technical Education – Basic Grants to States known questioned costs: $749,547. Higher Education Institutional Aid programs known questioned costs: $1,431,770. Context The Career Technical Education program reference above had a total of $2,355,332 in expenditures for the year ended June 30, 2024, of which $1,108,453 were associated with salaries and benefits. There was a total population of 66 employees charged to the program in the fiscal year ended June 30, 2024. The Title III and V programs referenced above had a total of $2,865,454 in expenditures for the year ended June 30, 2024, of which $2,248,191 associated with salaries and benefits. There was a total population of 148 employees charged to the program in the fiscal year ended June 30, 2024. Effect Without effective internal controls in place over personnel costs, the District risks noncompliance for program costs that could be material. Cause The District does not have policies and procedures in place to review personnel charges to identify the employee costs that should and should not be charged to the federal program referenced above. Repeat Finding (Yes or No) No Recommendation The District should monitor personnel costs charged to federal programs in accordance with the Uniform Guidance. The District should review personnel costs on a regular basis to ensure that costs charged are supported by allowable activities directly related to the program. Additionally, adequate supporting documentation should be retained for personnel costs charged to the federal programs. Views of Responsible Officials and Corrective Action Plan The District and campus staff will work together to develop processes to capture proper and relevant time and effort activities. This will ensure documentation can be provided regarding personnel expenses to identify employee costs charged to federal programs.
Criteria or Specific Requirements The Uniform Guidance states that allowable personnel costs charged to federal programs may include reasonable amounts for activities contributing and directly related to work under an agreement (2 CFR 200.430(i)(1)(i)). Charges to federal awards for salaries and wages must be based on records that accurate reflect the work performed (2 CFR 200.430(g)(1)). Condition Material Weakness in Internal Control over Compliance – Time-and-effort reporting, or another similar internal control activity to retroactively verify employee time spent on the program was not reviewed and approved or not performed for the year ending June 30, 2024. During testing over Activities Allowed or Unallowed and Allowable Cost requirements, the following deficiencies were noted: For the Career and Technical Education program, 14 out of 14 employees selected for testing do not have time-and-effort record reflecting the distribution of the employee’s salary and wages for the federal program. For the Title III and V programs, we noted the following – o 25 out of 30 employees selected for testing did not have time-and-effort record reflecting the distribution of the employee’s salary and wages for the federal program. o 5 out of 30 employees selected for testing had time-and-effort records, however, there were no evidence of review and approval. 2 of the 5 employees also had incomplete time-and-effort reports (i.e. only for half of the fiscal year, or a few months). Questioned Costs Career Technical Education – Basic Grants to States known questioned costs: $749,547. Higher Education Institutional Aid programs known questioned costs: $1,431,770. Context The Career Technical Education program reference above had a total of $2,355,332 in expenditures for the year ended June 30, 2024, of which $1,108,453 were associated with salaries and benefits. There was a total population of 66 employees charged to the program in the fiscal year ended June 30, 2024. The Title III and V programs referenced above had a total of $2,865,454 in expenditures for the year ended June 30, 2024, of which $2,248,191 associated with salaries and benefits. There was a total population of 148 employees charged to the program in the fiscal year ended June 30, 2024. Effect Without effective internal controls in place over personnel costs, the District risks noncompliance for program costs that could be material. Cause The District does not have policies and procedures in place to review personnel charges to identify the employee costs that should and should not be charged to the federal program referenced above. Repeat Finding (Yes or No) No Recommendation The District should monitor personnel costs charged to federal programs in accordance with the Uniform Guidance. The District should review personnel costs on a regular basis to ensure that costs charged are supported by allowable activities directly related to the program. Additionally, adequate supporting documentation should be retained for personnel costs charged to the federal programs. Views of Responsible Officials and Corrective Action Plan The District and campus staff will work together to develop processes to capture proper and relevant time and effort activities. This will ensure documentation can be provided regarding personnel expenses to identify employee costs charged to federal programs.
Criteria or Specific Requirements The Uniform Guidance states that allowable personnel costs charged to federal programs may include reasonable amounts for activities contributing and directly related to work under an agreement (2 CFR 200.430(i)(1)(i)). Charges to federal awards for salaries and wages must be based on records that accurate reflect the work performed (2 CFR 200.430(g)(1)). Condition Material Weakness in Internal Control over Compliance – Time-and-effort reporting, or another similar internal control activity to retroactively verify employee time spent on the program was not reviewed and approved or not performed for the year ending June 30, 2024. During testing over Activities Allowed or Unallowed and Allowable Cost requirements, the following deficiencies were noted: For the Career and Technical Education program, 14 out of 14 employees selected for testing do not have time-and-effort record reflecting the distribution of the employee’s salary and wages for the federal program. For the Title III and V programs, we noted the following – o 25 out of 30 employees selected for testing did not have time-and-effort record reflecting the distribution of the employee’s salary and wages for the federal program. o 5 out of 30 employees selected for testing had time-and-effort records, however, there were no evidence of review and approval. 2 of the 5 employees also had incomplete time-and-effort reports (i.e. only for half of the fiscal year, or a few months). Questioned Costs Career Technical Education – Basic Grants to States known questioned costs: $749,547. Higher Education Institutional Aid programs known questioned costs: $1,431,770. Context The Career Technical Education program reference above had a total of $2,355,332 in expenditures for the year ended June 30, 2024, of which $1,108,453 were associated with salaries and benefits. There was a total population of 66 employees charged to the program in the fiscal year ended June 30, 2024. The Title III and V programs referenced above had a total of $2,865,454 in expenditures for the year ended June 30, 2024, of which $2,248,191 associated with salaries and benefits. There was a total population of 148 employees charged to the program in the fiscal year ended June 30, 2024. Effect Without effective internal controls in place over personnel costs, the District risks noncompliance for program costs that could be material. Cause The District does not have policies and procedures in place to review personnel charges to identify the employee costs that should and should not be charged to the federal program referenced above. Repeat Finding (Yes or No) No Recommendation The District should monitor personnel costs charged to federal programs in accordance with the Uniform Guidance. The District should review personnel costs on a regular basis to ensure that costs charged are supported by allowable activities directly related to the program. Additionally, adequate supporting documentation should be retained for personnel costs charged to the federal programs. Views of Responsible Officials and Corrective Action Plan The District and campus staff will work together to develop processes to capture proper and relevant time and effort activities. This will ensure documentation can be provided regarding personnel expenses to identify employee costs charged to federal programs.
Criteria or Specific Requirements The Uniform Guidance states that allowable personnel costs charged to federal programs may include reasonable amounts for activities contributing and directly related to work under an agreement (2 CFR 200.430(i)(1)(i)). Charges to federal awards for salaries and wages must be based on records that accurate reflect the work performed (2 CFR 200.430(g)(1)). Condition Material Weakness in Internal Control over Compliance – Time-and-effort reporting, or another similar internal control activity to retroactively verify employee time spent on the program was not reviewed and approved or not performed for the year ending June 30, 2024. During testing over Activities Allowed or Unallowed and Allowable Cost requirements, the following deficiencies were noted: For the Career and Technical Education program, 14 out of 14 employees selected for testing do not have time-and-effort record reflecting the distribution of the employee’s salary and wages for the federal program. For the Title III and V programs, we noted the following – o 25 out of 30 employees selected for testing did not have time-and-effort record reflecting the distribution of the employee’s salary and wages for the federal program. o 5 out of 30 employees selected for testing had time-and-effort records, however, there were no evidence of review and approval. 2 of the 5 employees also had incomplete time-and-effort reports (i.e. only for half of the fiscal year, or a few months). Questioned Costs Career Technical Education – Basic Grants to States known questioned costs: $749,547. Higher Education Institutional Aid programs known questioned costs: $1,431,770. Context The Career Technical Education program reference above had a total of $2,355,332 in expenditures for the year ended June 30, 2024, of which $1,108,453 were associated with salaries and benefits. There was a total population of 66 employees charged to the program in the fiscal year ended June 30, 2024. The Title III and V programs referenced above had a total of $2,865,454 in expenditures for the year ended June 30, 2024, of which $2,248,191 associated with salaries and benefits. There was a total population of 148 employees charged to the program in the fiscal year ended June 30, 2024. Effect Without effective internal controls in place over personnel costs, the District risks noncompliance for program costs that could be material. Cause The District does not have policies and procedures in place to review personnel charges to identify the employee costs that should and should not be charged to the federal program referenced above. Repeat Finding (Yes or No) No Recommendation The District should monitor personnel costs charged to federal programs in accordance with the Uniform Guidance. The District should review personnel costs on a regular basis to ensure that costs charged are supported by allowable activities directly related to the program. Additionally, adequate supporting documentation should be retained for personnel costs charged to the federal programs. Views of Responsible Officials and Corrective Action Plan The District and campus staff will work together to develop processes to capture proper and relevant time and effort activities. This will ensure documentation can be provided regarding personnel expenses to identify employee costs charged to federal programs.
2024–003 ALLOWABILITY‐PAYROLL Federal Program Information: Federal Agency and Program Name Assistance Listing # U.S. Department of Housing and Urban Development Community Development Block Grants/Entitlement Grants 14.218 Criteria: 2 CFR 200.303 requires that a 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 and the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). 2 CFR 200.430(g)(1) states, “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 that provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the recipient or subrecipient; (iii) Reasonably reflect the total activity for which the employee is compensated by the recipient or subrecipient, not exceeding 100 percent of compensated activities (for IHEs, this is the IBS); (iv) Encompass federally‐assisted and all other activities compensated by the recipient or subrecipient on an integrated basis but may include the use of subsidiary records as defined in the recipient's or subrecipient's written policy; (v) Comply with the established accounting policies and procedures of the recipient or subrecipient (See paragraph (i)(1)(ii) of this section for treatment of incidental work for IHEs.); and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non‐Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. 2 CFR 200.403 indicates that costs must “be consistent with policies and procedures that apply uniformly to both federally‐financed and other activities of the non‐Federal entity” and must “be adequately documented”. Condition: For 6 of the 17 payroll transactions selected for testing the individual’s hourly rate of pay charged to the federal program was not consistent with actual pay rates. Documentation supporting the difference in rate paid and rate reimbursed from the federal program was not available. Questioned Costs: $69 Context: Total federal expenditures for the Community Development Block Grant program were $3,436,560. The 6 payroll transactions represent $8,906 of the total payroll transactions tested of $24,915 for the program. Total payroll charged to the grant was $292,826. Cause: The City does not have adequate internal controls and policies and procedures in place to ensure that the payroll amounts reimbursed from the federal funds correspond to the payroll rates in the underlying payroll accounting records. Effect: The City is not be in compliance with federal statues, regulations, and terms of the conditions of the federal award. Expenditures were paid that are not allowable. The Authority may not identify noncompliance with federal statues, regulations, and terms of the conditions of the federal award including allowability. Recommendation: We recommend that City enhance internal controls to ensure that expenditures charged to the federal awards are properly reviewed and supported. Views of Responsible Officials: Management acknowledges the finding. See corrective action plan.
2024–003 ALLOWABILITY‐PAYROLL Federal Program Information: Federal Agency and Program Name Assistance Listing # U.S. Department of Housing and Urban Development Community Development Block Grants/Entitlement Grants 14.218 Criteria: 2 CFR 200.303 requires that a 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 and the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). 2 CFR 200.430(g)(1) states, “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 that provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the recipient or subrecipient; (iii) Reasonably reflect the total activity for which the employee is compensated by the recipient or subrecipient, not exceeding 100 percent of compensated activities (for IHEs, this is the IBS); (iv) Encompass federally‐assisted and all other activities compensated by the recipient or subrecipient on an integrated basis but may include the use of subsidiary records as defined in the recipient's or subrecipient's written policy; (v) Comply with the established accounting policies and procedures of the recipient or subrecipient (See paragraph (i)(1)(ii) of this section for treatment of incidental work for IHEs.); and (vi) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non‐Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. 2 CFR 200.403 indicates that costs must “be consistent with policies and procedures that apply uniformly to both federally‐financed and other activities of the non‐Federal entity” and must “be adequately documented”. Condition: For 6 of the 17 payroll transactions selected for testing the individual’s hourly rate of pay charged to the federal program was not consistent with actual pay rates. Documentation supporting the difference in rate paid and rate reimbursed from the federal program was not available. Questioned Costs: $69 Context: Total federal expenditures for the Community Development Block Grant program were $3,436,560. The 6 payroll transactions represent $8,906 of the total payroll transactions tested of $24,915 for the program. Total payroll charged to the grant was $292,826. Cause: The City does not have adequate internal controls and policies and procedures in place to ensure that the payroll amounts reimbursed from the federal funds correspond to the payroll rates in the underlying payroll accounting records. Effect: The City is not be in compliance with federal statues, regulations, and terms of the conditions of the federal award. Expenditures were paid that are not allowable. The Authority may not identify noncompliance with federal statues, regulations, and terms of the conditions of the federal award including allowability. Recommendation: We recommend that City enhance internal controls to ensure that expenditures charged to the federal awards are properly reviewed and supported. Views of Responsible Officials: Management acknowledges the finding. See corrective action plan.
Finding 2024-011 – B. Allowable Costs/Cost Principles Information on Federal Program(s) – Research and Development Cluster (ALN 43.009, ALN 93.859) Criteria or Specific Requirement - 2 CFR §200.430(i)(1)(i) indicates that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Additionally, 2 CFR §200 requires that costs charged to programs are adequately documented. Condition – The summary level hourly documentation retained for payroll expenditures charged to the program was not formally supported with an adequate system of internal controls. Additionally, for certain non-payroll expenditures selected for testing, the University was unable to provide documentation adequately supporting the amount charged to the federal award. Cause - Administrative oversight and insufficient internal controls. Effect or Potential Effect – Noncompliance with documentation of personnel expense standards. Questioned Costs – Below reportable threshold. Context – Context is as follows: Expenditures: For 7 of 8 employees tested, the summary level hourly documentation retained was not formally supported with an adequate system of internal controls. Indication of Repeat Finding - This is a repeat of prior year Finding 2023-013. Recommendation – We recommend that the University enhance its internal controls over compliance to ensure that time and effort records are appropriately maintained. Views of Responsible Officials – The University acknowledges that the records to substantiate the payroll costs were insufficient and lacking internal controls. Going forward the University plans to implement a strategic process to document time and effort associated with research and development cluster and it’s federal grants. All employees that work with the Challenger Learning Center will continue to have their hours worked documented in the Paycom payroll software. Payroll is processed on a biweekly basis, and therefore on biweekly basis the payroll costs from the Challenger Learning Center will be reimbursed to the University from the various Challenger Learning Center bank accounts. This will be done as a percentage of time worked for the NIH Grant, the NASA Grant, and the general Challenger Learning Center functions.
Finding 2024-011 – B. Allowable Costs/Cost Principles Information on Federal Program(s) – Research and Development Cluster (ALN 43.009, ALN 93.859) Criteria or Specific Requirement - 2 CFR §200.430(i)(1)(i) indicates that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Additionally, 2 CFR §200 requires that costs charged to programs are adequately documented. Condition – The summary level hourly documentation retained for payroll expenditures charged to the program was not formally supported with an adequate system of internal controls. Additionally, for certain non-payroll expenditures selected for testing, the University was unable to provide documentation adequately supporting the amount charged to the federal award. Cause - Administrative oversight and insufficient internal controls. Effect or Potential Effect – Noncompliance with documentation of personnel expense standards. Questioned Costs – Below reportable threshold. Context – Context is as follows: Expenditures: For 7 of 8 employees tested, the summary level hourly documentation retained was not formally supported with an adequate system of internal controls. Indication of Repeat Finding - This is a repeat of prior year Finding 2023-013. Recommendation – We recommend that the University enhance its internal controls over compliance to ensure that time and effort records are appropriately maintained. Views of Responsible Officials – The University acknowledges that the records to substantiate the payroll costs were insufficient and lacking internal controls. Going forward the University plans to implement a strategic process to document time and effort associated with research and development cluster and it’s federal grants. All employees that work with the Challenger Learning Center will continue to have their hours worked documented in the Paycom payroll software. Payroll is processed on a biweekly basis, and therefore on biweekly basis the payroll costs from the Challenger Learning Center will be reimbursed to the University from the various Challenger Learning Center bank accounts. This will be done as a percentage of time worked for the NIH Grant, the NASA Grant, and the general Challenger Learning Center functions.
Significant Deficiency in Allowable Costs and Cost Principles Federal Award Identification Assistance Listing Program Title: Formula Grants for Rural Areas Assistance Listing Program Number: 20.509 Federal Award ID Number and Year: Various Federal Agency: U.S. Department of Transportation Pass-Through Entity: Nebraska Department of Transportation Criteria Standards for documentation of personnel expenses at 2 CFR 200.430(i)(1) require that charges to federal awards for salaries and wages be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly documented. The Organization must establish and maintain effective internal control over the Federal award that provides reasonable assurance that they are managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal Award (2 CFR 200.303). Condition The Organization lacked adequate documentation to support approved rates of pay. Repeat Finding Yes, 2023-005. Cause Procedures within the Organization were inadequate to ensure that personnel expenses were adequately documented. Effect or Potential Effect Increased potential for errors or misuse of funds. Questioned Costs No. Statistical Sample No. Context Auditor randomly selected 60 payroll transactions covering the entire fiscal year for testing and judgmentally selected one additional payroll transaction for testing. Of the 61 transactions that were tested, there were frequent errors regarding: - Personnel files lacking (approved) rates of pay. - Rates of pay documented in personnel files that did not match the actual rates of pay. Recommendation We recommend the Organization establish a system of internal control consisting of policies and procedures whereby personnel files contain appropriately reviewed and approved documentation to support employee rates of pay. Views of Responsible Officials See Corrective Action Plan, below.
Program: Coronavirus State and Local Fiscal Recovery Funds Federal Financial Assistance Listing No.: 21.027 Federal Agency: U.S. Department of Treasury Passed-through: California Department of Finance Award Number and Year: CSLFRF Compliance Requirement: Allowable Costs Type of Finding: Material Weakness in Internal Control over Compliance, Instance of Noncompliance Criteria: 2 CFR 200.430(g)(vii) states that budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: a) the system for establishing the estimates produces reasonable approximations of the activity performed; b) significant changes in the related work activity (as defined by the recipient’s written policies) are promptly identified and entered in to the records, and c) the recipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: We found that although the City charged 50% of the budgeted amount of an employees compensation to the program, the City did not perform a lookback to ensure that only 50% of the employees actual compensation was charged to the program. Cause: The City did not have procedures in place to perform a lookback of budgeted costs charged to grant programs. Effect: The City overcharged the program by the excess of the budgeted costs against the actual costs. Questioned Costs: None reported. Context/Sampling: We selected 100% of the City’s payroll costs of the program. Repeat Finding from Prior Year(s): No. Recommendation: We recommend that the City establish procedures to perform a lookback of budgeted expenditures charged to grants. Views of Responsible Officials: Management agrees with the finding. See separate corrective action plan.
FINDING 2024-003 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program Assistance Listings Numbers: 10.553, 10.555 Federal Award Number and Year (or Other Identifying Number): FY 2024 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-003. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Allowable Costs/Cost Principles compliance requirement. During the audit period, there was not an approved salary ordinance for noncertified staff for fiscal year 2023-2024. Of the nine paychecks selected for testing, three did not have hourly rates approved by the governing body. It was further determined that all noncertified staff employees did not have the hourly rates approved by the governing body for 2023-2024. Therefore, we were not able to determine if the amounts paid to these employees were appropriate. The lack of internal controls and noncompliance was limited to payroll disbursements of noncertified employees during 2024. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(g)(1) states in part: "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 that provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the recipient or subrecipient; (iii) Reasonably reflect the total activity for which the employee is compensated by the recipient or subrecipient, not exceeding 100 percent of compensated activities (for IHEs, this is the IBS); (iv) Encompass federally-assisted and all other activities compensated by the recipient or subrecipient on an integrated basis but may include the use of subsidiary records as defined in the recipient's or subrecipient's written policy; (v) Comply with the established accounting policies and procedures of the recipient or subrecipient (See paragraph (i)(1)(ii) of this section for treatment of incidental work for IHEs.); and . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (meaning, estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient's or subrecipient's written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient's or subrecipient's system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. (ix) Because practices vary as to the activity constituting a full workload (for example, the Institutional Base Salary (IBS) for IHEs), records may reflect categories of activities expressed as a percentage distribution of total activities. (x) It is recognized that teaching, research, service, and administration are often inextricably intermingled in an academic setting. Therefore, a precise assessment of factors contributing to costs is not required when IHEs record salaries and wages charged to Federal awards . . ." Cause Management had not established an effective system of internal controls that would have ensured compliance with the grant agreement and the Allowable Costs/Cost Principles compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Allowable Costs/Cost Principles compliance requirement could have resulted in the loss of federal funds to the School Corporation. Questioned Costs The total of known questioned costs was $219,188. Recommendation We recommended that the School Corporation's management establish an effective system of internal controls to ensure compliance and comply with the grant agreement and Allowable Costs/Cost Principles compliance requirement. An internal control system, including segregation of duties, should be designed and operate effectively to provide reasonable assurance that material noncompliance with the grant agreement or a compliance requirement of a federal program will be prevented, or detected and corrected, on a timely basis. In order to have an effective internal control system, it is important to have proper segregation of duties. This is accomplished by making sure proper oversight, reviews, and approvals take place and to have a separation of functions over certain activities related to the program. The fundamental premise of segregation of duties is that an individual or small group of individuals should not be in a position to initiate, approve, undertake, and review the same activity. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-003 Subject: Child Nutrition Cluster - Allowable Costs/Cost Principles Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program Assistance Listings Numbers: 10.553, 10.555 Federal Award Number and Year (or Other Identifying Number): FY 2024 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-003. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the Allowable Costs/Cost Principles compliance requirement. During the audit period, there was not an approved salary ordinance for noncertified staff for fiscal year 2023-2024. Of the nine paychecks selected for testing, three did not have hourly rates approved by the governing body. It was further determined that all noncertified staff employees did not have the hourly rates approved by the governing body for 2023-2024. Therefore, we were not able to determine if the amounts paid to these employees were appropriate. The lack of internal controls and noncompliance was limited to payroll disbursements of noncertified employees during 2024. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(g)(1) states in part: "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 that provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the recipient or subrecipient; (iii) Reasonably reflect the total activity for which the employee is compensated by the recipient or subrecipient, not exceeding 100 percent of compensated activities (for IHEs, this is the IBS); (iv) Encompass federally-assisted and all other activities compensated by the recipient or subrecipient on an integrated basis but may include the use of subsidiary records as defined in the recipient's or subrecipient's written policy; (v) Comply with the established accounting policies and procedures of the recipient or subrecipient (See paragraph (i)(1)(ii) of this section for treatment of incidental work for IHEs.); and . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (meaning, estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity performed; (B) Significant changes in the related work activity (as defined by the recipient's or subrecipient's written policies) are promptly identified and entered into the records. Short-term (such as one or two months) fluctuations between workload categories do not need to be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The recipient's or subrecipient's system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal award based on budget estimates. All necessary adjustments must be made so that the final amount charged to the Federal award is accurate, allowable, and properly allocated. (ix) Because practices vary as to the activity constituting a full workload (for example, the Institutional Base Salary (IBS) for IHEs), records may reflect categories of activities expressed as a percentage distribution of total activities. (x) It is recognized that teaching, research, service, and administration are often inextricably intermingled in an academic setting. Therefore, a precise assessment of factors contributing to costs is not required when IHEs record salaries and wages charged to Federal awards . . ." Cause Management had not established an effective system of internal controls that would have ensured compliance with the grant agreement and the Allowable Costs/Cost Principles compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Allowable Costs/Cost Principles compliance requirement could have resulted in the loss of federal funds to the School Corporation. Questioned Costs The total of known questioned costs was $219,188. Recommendation We recommended that the School Corporation's management establish an effective system of internal controls to ensure compliance and comply with the grant agreement and Allowable Costs/Cost Principles compliance requirement. An internal control system, including segregation of duties, should be designed and operate effectively to provide reasonable assurance that material noncompliance with the grant agreement or a compliance requirement of a federal program will be prevented, or detected and corrected, on a timely basis. In order to have an effective internal control system, it is important to have proper segregation of duties. This is accomplished by making sure proper oversight, reviews, and approvals take place and to have a separation of functions over certain activities related to the program. The fundamental premise of segregation of duties is that an individual or small group of individuals should not be in a position to initiate, approve, undertake, and review the same activity. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding 2024-001 – Allowable Costs/Cost Principles Identification of the federal program: Health Resources and Services Administration HIV Emergency Relief Project Grants Assistance Listing No. 93.914 Pass Through Numbers Pass Through Entity Grant Period PH-002898 County of Los Angeles 01/11/2011–02/28/2025 PH-002375 County of Los Angeles 12/01/2012–06/30/2025 PH-003746 County of Los Angeles 12/01/2012–06/30/2025 PH-003802 County of Los Angeles 01/01/2013–06/30/2025 H-208518 County of Los Angeles 04/01/2006–07/31/2025 PH-004205 County of Los Angeles 06/01/2020–02/28/2025 10126 PREV King County Public Health 03/01/2023–02/29/2024 11987 PREV King County Public Health 03/01/2024–02/28/2025 St. Mary Medical Center – Long Beach Bailey-Boushay House Criteria or specific requirement (including statutory, regulatory, or other citation): 2 CFR 200.303(a) requires that a 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 and the “Internal Control Integrated Framework”, issued by the Bailey-Boushay House Committee of Sponsoring Organizations of the Treadway Commission (COSO).” 2 CFR 200.430 (i) states “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflected the work performed. These records must: (i) be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) be incorporated into the official records of the non-Federal entity; (iii) reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) encompass both federal assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) comply with the established accounting policies and practices of the non-Federal entity.” Only expenditures incurred related to the federal program should be requested for reimbursement. Condition: St. Mary Medical Center – Long Beach and Bailey-Boushay House did not have effective internal controls addressing the requirements of 2 CFR 200.303(a) and 2 CFR 200.430, including consistent approval of employees’ timecards. At Bailey-Boushay House, one employee’s salary that was charged to the grant was not supported by the underlying timesheet for the respective pay period and the related expenditures should not have been charged to the grant and requested for reimbursement. Cause: St. Mary Medical Center – Long Beach and Bailey-Boushay House management have been developing and implementing internal controls in response to the prior year finding; however, controls were not implemented during the entire period under audit. For one employee at Bailey-Boushay House, the timecard reflected zero hours for grant award 10126-PREV. There was a clerical error whereby the hours transferred from the timecard were reported to the wrong grant, resulting in an overcharge to the federal grant. Effect or potential effect: Unallowable and/or inaccurate payroll expenditures could be charged to the federal program. Questioned costs: $504, calculated as the amount charged to the grant that was not supported by the underlying time sheet for one employee. Context: We issued a material weakness for St. Mary Medical Center – Long Beach and Bailey-Boushay House related to internal controls in the prior year. Based upon the implementation date for the corrective action provided by management, the finding related to this internal control had not been remediated for the full period under audit. As such, we did not test the operating effectiveness of this control and are issuing a material weakness consistent with the prior year finding. For one employee, the clerical error resulted in an overcharge to the grant. Total payroll expenditures for St. Mary Medical Center – Long Beach were approximately $1.1 million and represent 24% of the total HIV Emergency Relief Project Grants expenditures of approximately $4.6 million. Total payroll expenditures, including fringe benefits, for Bailey-Boushay House were approximately $1.4 million and represent 30% of the total HIV Emergency Relief Project Grants expenditures of approximately $4.6 million. We selected a sample of 43 payroll expenditures totaling $52,706 to perform compliance testing. Of the 43 samples, 18 samples totaling $18,451 and 25 samples totaling $34,255 were obtained from Bailey-Boushay House and St. Mary Medical Center – Long Beach, respectively. For 1 of the 18 samples selected from Bailey-Boushay House, comprising $403 in salary and $101 in related fringe benefit expense, for a total of $504, the expenditures were not supported by the related employee timesheet. Identification of a repeat finding: This is a repeat finding for St. Mary Medical Center – Long Beach – Finding 2023-003. For internal controls, this is a repeat finding for Bailey-Boushay House – Findings 2023-003, 2022-007, and 2021-008, but this current year finding is the first time noncompliance has been noted in our testing. Recommendation: We recommend management at St. Mary Medical Center – Long Beach and Bailey-Boushay House execute its processes to properly approve all time charged to federal grants in accordance with 2 CFR 200.430. Additionally, we recommend management execute and retain evidence of its internal controls over the allowability of payroll expenditures. At Bailey-Boushay House, we recommend that only expenses supported by an underlying timesheet be charged to the grant. Views of responsible officials: Management agrees with the finding. Corrective action over timecard approval was implemented in April 2024. For the noncompliance noted at Bailey-Boushay House, Bailey-Boushay House will return the funds to the grantor for amounts that were not supported by an underlying timesheet.
Finding 2024-001 – Allowable Costs/Cost Principles Identification of the federal program: Health Resources and Services Administration HIV Emergency Relief Project Grants Assistance Listing No. 93.914 Pass Through Numbers Pass Through Entity Grant Period PH-002898 County of Los Angeles 01/11/2011–02/28/2025 PH-002375 County of Los Angeles 12/01/2012–06/30/2025 PH-003746 County of Los Angeles 12/01/2012–06/30/2025 PH-003802 County of Los Angeles 01/01/2013–06/30/2025 H-208518 County of Los Angeles 04/01/2006–07/31/2025 PH-004205 County of Los Angeles 06/01/2020–02/28/2025 10126 PREV King County Public Health 03/01/2023–02/29/2024 11987 PREV King County Public Health 03/01/2024–02/28/2025 St. Mary Medical Center – Long Beach Bailey-Boushay House Criteria or specific requirement (including statutory, regulatory, or other citation): 2 CFR 200.303(a) requires that a 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 and the “Internal Control Integrated Framework”, issued by the Bailey-Boushay House Committee of Sponsoring Organizations of the Treadway Commission (COSO).” 2 CFR 200.430 (i) states “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflected the work performed. These records must: (i) be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) be incorporated into the official records of the non-Federal entity; (iii) reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) encompass both federal assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) comply with the established accounting policies and practices of the non-Federal entity.” Only expenditures incurred related to the federal program should be requested for reimbursement. Condition: St. Mary Medical Center – Long Beach and Bailey-Boushay House did not have effective internal controls addressing the requirements of 2 CFR 200.303(a) and 2 CFR 200.430, including consistent approval of employees’ timecards. At Bailey-Boushay House, one employee’s salary that was charged to the grant was not supported by the underlying timesheet for the respective pay period and the related expenditures should not have been charged to the grant and requested for reimbursement. Cause: St. Mary Medical Center – Long Beach and Bailey-Boushay House management have been developing and implementing internal controls in response to the prior year finding; however, controls were not implemented during the entire period under audit. For one employee at Bailey-Boushay House, the timecard reflected zero hours for grant award 10126-PREV. There was a clerical error whereby the hours transferred from the timecard were reported to the wrong grant, resulting in an overcharge to the federal grant. Effect or potential effect: Unallowable and/or inaccurate payroll expenditures could be charged to the federal program. Questioned costs: $504, calculated as the amount charged to the grant that was not supported by the underlying time sheet for one employee. Context: We issued a material weakness for St. Mary Medical Center – Long Beach and Bailey-Boushay House related to internal controls in the prior year. Based upon the implementation date for the corrective action provided by management, the finding related to this internal control had not been remediated for the full period under audit. As such, we did not test the operating effectiveness of this control and are issuing a material weakness consistent with the prior year finding. For one employee, the clerical error resulted in an overcharge to the grant. Total payroll expenditures for St. Mary Medical Center – Long Beach were approximately $1.1 million and represent 24% of the total HIV Emergency Relief Project Grants expenditures of approximately $4.6 million. Total payroll expenditures, including fringe benefits, for Bailey-Boushay House were approximately $1.4 million and represent 30% of the total HIV Emergency Relief Project Grants expenditures of approximately $4.6 million. We selected a sample of 43 payroll expenditures totaling $52,706 to perform compliance testing. Of the 43 samples, 18 samples totaling $18,451 and 25 samples totaling $34,255 were obtained from Bailey-Boushay House and St. Mary Medical Center – Long Beach, respectively. For 1 of the 18 samples selected from Bailey-Boushay House, comprising $403 in salary and $101 in related fringe benefit expense, for a total of $504, the expenditures were not supported by the related employee timesheet. Identification of a repeat finding: This is a repeat finding for St. Mary Medical Center – Long Beach – Finding 2023-003. For internal controls, this is a repeat finding for Bailey-Boushay House – Findings 2023-003, 2022-007, and 2021-008, but this current year finding is the first time noncompliance has been noted in our testing. Recommendation: We recommend management at St. Mary Medical Center – Long Beach and Bailey-Boushay House execute its processes to properly approve all time charged to federal grants in accordance with 2 CFR 200.430. Additionally, we recommend management execute and retain evidence of its internal controls over the allowability of payroll expenditures. At Bailey-Boushay House, we recommend that only expenses supported by an underlying timesheet be charged to the grant. Views of responsible officials: Management agrees with the finding. Corrective action over timecard approval was implemented in April 2024. For the noncompliance noted at Bailey-Boushay House, Bailey-Boushay House will return the funds to the grantor for amounts that were not supported by an underlying timesheet.
Finding 2024-001 – Allowable Costs/Cost Principles Identification of the federal program: Health Resources and Services Administration HIV Emergency Relief Project Grants Assistance Listing No. 93.914 Pass Through Numbers Pass Through Entity Grant Period PH-002898 County of Los Angeles 01/11/2011–02/28/2025 PH-002375 County of Los Angeles 12/01/2012–06/30/2025 PH-003746 County of Los Angeles 12/01/2012–06/30/2025 PH-003802 County of Los Angeles 01/01/2013–06/30/2025 H-208518 County of Los Angeles 04/01/2006–07/31/2025 PH-004205 County of Los Angeles 06/01/2020–02/28/2025 10126 PREV King County Public Health 03/01/2023–02/29/2024 11987 PREV King County Public Health 03/01/2024–02/28/2025 St. Mary Medical Center – Long Beach Bailey-Boushay House Criteria or specific requirement (including statutory, regulatory, or other citation): 2 CFR 200.303(a) requires that a 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 and the “Internal Control Integrated Framework”, issued by the Bailey-Boushay House Committee of Sponsoring Organizations of the Treadway Commission (COSO).” 2 CFR 200.430 (i) states “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflected the work performed. These records must: (i) be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) be incorporated into the official records of the non-Federal entity; (iii) reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) encompass both federal assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) comply with the established accounting policies and practices of the non-Federal entity.” Only expenditures incurred related to the federal program should be requested for reimbursement. Condition: St. Mary Medical Center – Long Beach and Bailey-Boushay House did not have effective internal controls addressing the requirements of 2 CFR 200.303(a) and 2 CFR 200.430, including consistent approval of employees’ timecards. At Bailey-Boushay House, one employee’s salary that was charged to the grant was not supported by the underlying timesheet for the respective pay period and the related expenditures should not have been charged to the grant and requested for reimbursement. Cause: St. Mary Medical Center – Long Beach and Bailey-Boushay House management have been developing and implementing internal controls in response to the prior year finding; however, controls were not implemented during the entire period under audit. For one employee at Bailey-Boushay House, the timecard reflected zero hours for grant award 10126-PREV. There was a clerical error whereby the hours transferred from the timecard were reported to the wrong grant, resulting in an overcharge to the federal grant. Effect or potential effect: Unallowable and/or inaccurate payroll expenditures could be charged to the federal program. Questioned costs: $504, calculated as the amount charged to the grant that was not supported by the underlying time sheet for one employee. Context: We issued a material weakness for St. Mary Medical Center – Long Beach and Bailey-Boushay House related to internal controls in the prior year. Based upon the implementation date for the corrective action provided by management, the finding related to this internal control had not been remediated for the full period under audit. As such, we did not test the operating effectiveness of this control and are issuing a material weakness consistent with the prior year finding. For one employee, the clerical error resulted in an overcharge to the grant. Total payroll expenditures for St. Mary Medical Center – Long Beach were approximately $1.1 million and represent 24% of the total HIV Emergency Relief Project Grants expenditures of approximately $4.6 million. Total payroll expenditures, including fringe benefits, for Bailey-Boushay House were approximately $1.4 million and represent 30% of the total HIV Emergency Relief Project Grants expenditures of approximately $4.6 million. We selected a sample of 43 payroll expenditures totaling $52,706 to perform compliance testing. Of the 43 samples, 18 samples totaling $18,451 and 25 samples totaling $34,255 were obtained from Bailey-Boushay House and St. Mary Medical Center – Long Beach, respectively. For 1 of the 18 samples selected from Bailey-Boushay House, comprising $403 in salary and $101 in related fringe benefit expense, for a total of $504, the expenditures were not supported by the related employee timesheet. Identification of a repeat finding: This is a repeat finding for St. Mary Medical Center – Long Beach – Finding 2023-003. For internal controls, this is a repeat finding for Bailey-Boushay House – Findings 2023-003, 2022-007, and 2021-008, but this current year finding is the first time noncompliance has been noted in our testing. Recommendation: We recommend management at St. Mary Medical Center – Long Beach and Bailey-Boushay House execute its processes to properly approve all time charged to federal grants in accordance with 2 CFR 200.430. Additionally, we recommend management execute and retain evidence of its internal controls over the allowability of payroll expenditures. At Bailey-Boushay House, we recommend that only expenses supported by an underlying timesheet be charged to the grant. Views of responsible officials: Management agrees with the finding. Corrective action over timecard approval was implemented in April 2024. For the noncompliance noted at Bailey-Boushay House, Bailey-Boushay House will return the funds to the grantor for amounts that were not supported by an underlying timesheet.
Finding 2024-001 – Allowable Costs/Cost Principles Identification of the federal program: Health Resources and Services Administration HIV Emergency Relief Project Grants Assistance Listing No. 93.914 Pass Through Numbers Pass Through Entity Grant Period PH-002898 County of Los Angeles 01/11/2011–02/28/2025 PH-002375 County of Los Angeles 12/01/2012–06/30/2025 PH-003746 County of Los Angeles 12/01/2012–06/30/2025 PH-003802 County of Los Angeles 01/01/2013–06/30/2025 H-208518 County of Los Angeles 04/01/2006–07/31/2025 PH-004205 County of Los Angeles 06/01/2020–02/28/2025 10126 PREV King County Public Health 03/01/2023–02/29/2024 11987 PREV King County Public Health 03/01/2024–02/28/2025 St. Mary Medical Center – Long Beach Bailey-Boushay House Criteria or specific requirement (including statutory, regulatory, or other citation): 2 CFR 200.303(a) requires that a 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 and the “Internal Control Integrated Framework”, issued by the Bailey-Boushay House Committee of Sponsoring Organizations of the Treadway Commission (COSO).” 2 CFR 200.430 (i) states “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflected the work performed. These records must: (i) be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) be incorporated into the official records of the non-Federal entity; (iii) reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) encompass both federal assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) comply with the established accounting policies and practices of the non-Federal entity.” Only expenditures incurred related to the federal program should be requested for reimbursement. Condition: St. Mary Medical Center – Long Beach and Bailey-Boushay House did not have effective internal controls addressing the requirements of 2 CFR 200.303(a) and 2 CFR 200.430, including consistent approval of employees’ timecards. At Bailey-Boushay House, one employee’s salary that was charged to the grant was not supported by the underlying timesheet for the respective pay period and the related expenditures should not have been charged to the grant and requested for reimbursement. Cause: St. Mary Medical Center – Long Beach and Bailey-Boushay House management have been developing and implementing internal controls in response to the prior year finding; however, controls were not implemented during the entire period under audit. For one employee at Bailey-Boushay House, the timecard reflected zero hours for grant award 10126-PREV. There was a clerical error whereby the hours transferred from the timecard were reported to the wrong grant, resulting in an overcharge to the federal grant. Effect or potential effect: Unallowable and/or inaccurate payroll expenditures could be charged to the federal program. Questioned costs: $504, calculated as the amount charged to the grant that was not supported by the underlying time sheet for one employee. Context: We issued a material weakness for St. Mary Medical Center – Long Beach and Bailey-Boushay House related to internal controls in the prior year. Based upon the implementation date for the corrective action provided by management, the finding related to this internal control had not been remediated for the full period under audit. As such, we did not test the operating effectiveness of this control and are issuing a material weakness consistent with the prior year finding. For one employee, the clerical error resulted in an overcharge to the grant. Total payroll expenditures for St. Mary Medical Center – Long Beach were approximately $1.1 million and represent 24% of the total HIV Emergency Relief Project Grants expenditures of approximately $4.6 million. Total payroll expenditures, including fringe benefits, for Bailey-Boushay House were approximately $1.4 million and represent 30% of the total HIV Emergency Relief Project Grants expenditures of approximately $4.6 million. We selected a sample of 43 payroll expenditures totaling $52,706 to perform compliance testing. Of the 43 samples, 18 samples totaling $18,451 and 25 samples totaling $34,255 were obtained from Bailey-Boushay House and St. Mary Medical Center – Long Beach, respectively. For 1 of the 18 samples selected from Bailey-Boushay House, comprising $403 in salary and $101 in related fringe benefit expense, for a total of $504, the expenditures were not supported by the related employee timesheet. Identification of a repeat finding: This is a repeat finding for St. Mary Medical Center – Long Beach – Finding 2023-003. For internal controls, this is a repeat finding for Bailey-Boushay House – Findings 2023-003, 2022-007, and 2021-008, but this current year finding is the first time noncompliance has been noted in our testing. Recommendation: We recommend management at St. Mary Medical Center – Long Beach and Bailey-Boushay House execute its processes to properly approve all time charged to federal grants in accordance with 2 CFR 200.430. Additionally, we recommend management execute and retain evidence of its internal controls over the allowability of payroll expenditures. At Bailey-Boushay House, we recommend that only expenses supported by an underlying timesheet be charged to the grant. Views of responsible officials: Management agrees with the finding. Corrective action over timecard approval was implemented in April 2024. For the noncompliance noted at Bailey-Boushay House, Bailey-Boushay House will return the funds to the grantor for amounts that were not supported by an underlying timesheet.
Finding 2024-001 – Allowable Costs/Cost Principles Identification of the federal program: Health Resources and Services Administration HIV Emergency Relief Project Grants Assistance Listing No. 93.914 Pass Through Numbers Pass Through Entity Grant Period PH-002898 County of Los Angeles 01/11/2011–02/28/2025 PH-002375 County of Los Angeles 12/01/2012–06/30/2025 PH-003746 County of Los Angeles 12/01/2012–06/30/2025 PH-003802 County of Los Angeles 01/01/2013–06/30/2025 H-208518 County of Los Angeles 04/01/2006–07/31/2025 PH-004205 County of Los Angeles 06/01/2020–02/28/2025 10126 PREV King County Public Health 03/01/2023–02/29/2024 11987 PREV King County Public Health 03/01/2024–02/28/2025 St. Mary Medical Center – Long Beach Bailey-Boushay House Criteria or specific requirement (including statutory, regulatory, or other citation): 2 CFR 200.303(a) requires that a 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 and the “Internal Control Integrated Framework”, issued by the Bailey-Boushay House Committee of Sponsoring Organizations of the Treadway Commission (COSO).” 2 CFR 200.430 (i) states “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflected the work performed. These records must: (i) be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) be incorporated into the official records of the non-Federal entity; (iii) reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) encompass both federal assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) comply with the established accounting policies and practices of the non-Federal entity.” Only expenditures incurred related to the federal program should be requested for reimbursement. Condition: St. Mary Medical Center – Long Beach and Bailey-Boushay House did not have effective internal controls addressing the requirements of 2 CFR 200.303(a) and 2 CFR 200.430, including consistent approval of employees’ timecards. At Bailey-Boushay House, one employee’s salary that was charged to the grant was not supported by the underlying timesheet for the respective pay period and the related expenditures should not have been charged to the grant and requested for reimbursement. Cause: St. Mary Medical Center – Long Beach and Bailey-Boushay House management have been developing and implementing internal controls in response to the prior year finding; however, controls were not implemented during the entire period under audit. For one employee at Bailey-Boushay House, the timecard reflected zero hours for grant award 10126-PREV. There was a clerical error whereby the hours transferred from the timecard were reported to the wrong grant, resulting in an overcharge to the federal grant. Effect or potential effect: Unallowable and/or inaccurate payroll expenditures could be charged to the federal program. Questioned costs: $504, calculated as the amount charged to the grant that was not supported by the underlying time sheet for one employee. Context: We issued a material weakness for St. Mary Medical Center – Long Beach and Bailey-Boushay House related to internal controls in the prior year. Based upon the implementation date for the corrective action provided by management, the finding related to this internal control had not been remediated for the full period under audit. As such, we did not test the operating effectiveness of this control and are issuing a material weakness consistent with the prior year finding. For one employee, the clerical error resulted in an overcharge to the grant. Total payroll expenditures for St. Mary Medical Center – Long Beach were approximately $1.1 million and represent 24% of the total HIV Emergency Relief Project Grants expenditures of approximately $4.6 million. Total payroll expenditures, including fringe benefits, for Bailey-Boushay House were approximately $1.4 million and represent 30% of the total HIV Emergency Relief Project Grants expenditures of approximately $4.6 million. We selected a sample of 43 payroll expenditures totaling $52,706 to perform compliance testing. Of the 43 samples, 18 samples totaling $18,451 and 25 samples totaling $34,255 were obtained from Bailey-Boushay House and St. Mary Medical Center – Long Beach, respectively. For 1 of the 18 samples selected from Bailey-Boushay House, comprising $403 in salary and $101 in related fringe benefit expense, for a total of $504, the expenditures were not supported by the related employee timesheet. Identification of a repeat finding: This is a repeat finding for St. Mary Medical Center – Long Beach – Finding 2023-003. For internal controls, this is a repeat finding for Bailey-Boushay House – Findings 2023-003, 2022-007, and 2021-008, but this current year finding is the first time noncompliance has been noted in our testing. Recommendation: We recommend management at St. Mary Medical Center – Long Beach and Bailey-Boushay House execute its processes to properly approve all time charged to federal grants in accordance with 2 CFR 200.430. Additionally, we recommend management execute and retain evidence of its internal controls over the allowability of payroll expenditures. At Bailey-Boushay House, we recommend that only expenses supported by an underlying timesheet be charged to the grant. Views of responsible officials: Management agrees with the finding. Corrective action over timecard approval was implemented in April 2024. For the noncompliance noted at Bailey-Boushay House, Bailey-Boushay House will return the funds to the grantor for amounts that were not supported by an underlying timesheet.
Finding 2024-001 – Allowable Costs/Cost Principles Identification of the federal program: Health Resources and Services Administration HIV Emergency Relief Project Grants Assistance Listing No. 93.914 Pass Through Numbers Pass Through Entity Grant Period PH-002898 County of Los Angeles 01/11/2011–02/28/2025 PH-002375 County of Los Angeles 12/01/2012–06/30/2025 PH-003746 County of Los Angeles 12/01/2012–06/30/2025 PH-003802 County of Los Angeles 01/01/2013–06/30/2025 H-208518 County of Los Angeles 04/01/2006–07/31/2025 PH-004205 County of Los Angeles 06/01/2020–02/28/2025 10126 PREV King County Public Health 03/01/2023–02/29/2024 11987 PREV King County Public Health 03/01/2024–02/28/2025 St. Mary Medical Center – Long Beach Bailey-Boushay House Criteria or specific requirement (including statutory, regulatory, or other citation): 2 CFR 200.303(a) requires that a 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 and the “Internal Control Integrated Framework”, issued by the Bailey-Boushay House Committee of Sponsoring Organizations of the Treadway Commission (COSO).” 2 CFR 200.430 (i) states “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflected the work performed. These records must: (i) be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) be incorporated into the official records of the non-Federal entity; (iii) reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) encompass both federal assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) comply with the established accounting policies and practices of the non-Federal entity.” Only expenditures incurred related to the federal program should be requested for reimbursement. Condition: St. Mary Medical Center – Long Beach and Bailey-Boushay House did not have effective internal controls addressing the requirements of 2 CFR 200.303(a) and 2 CFR 200.430, including consistent approval of employees’ timecards. At Bailey-Boushay House, one employee’s salary that was charged to the grant was not supported by the underlying timesheet for the respective pay period and the related expenditures should not have been charged to the grant and requested for reimbursement. Cause: St. Mary Medical Center – Long Beach and Bailey-Boushay House management have been developing and implementing internal controls in response to the prior year finding; however, controls were not implemented during the entire period under audit. For one employee at Bailey-Boushay House, the timecard reflected zero hours for grant award 10126-PREV. There was a clerical error whereby the hours transferred from the timecard were reported to the wrong grant, resulting in an overcharge to the federal grant. Effect or potential effect: Unallowable and/or inaccurate payroll expenditures could be charged to the federal program. Questioned costs: $504, calculated as the amount charged to the grant that was not supported by the underlying time sheet for one employee. Context: We issued a material weakness for St. Mary Medical Center – Long Beach and Bailey-Boushay House related to internal controls in the prior year. Based upon the implementation date for the corrective action provided by management, the finding related to this internal control had not been remediated for the full period under audit. As such, we did not test the operating effectiveness of this control and are issuing a material weakness consistent with the prior year finding. For one employee, the clerical error resulted in an overcharge to the grant. Total payroll expenditures for St. Mary Medical Center – Long Beach were approximately $1.1 million and represent 24% of the total HIV Emergency Relief Project Grants expenditures of approximately $4.6 million. Total payroll expenditures, including fringe benefits, for Bailey-Boushay House were approximately $1.4 million and represent 30% of the total HIV Emergency Relief Project Grants expenditures of approximately $4.6 million. We selected a sample of 43 payroll expenditures totaling $52,706 to perform compliance testing. Of the 43 samples, 18 samples totaling $18,451 and 25 samples totaling $34,255 were obtained from Bailey-Boushay House and St. Mary Medical Center – Long Beach, respectively. For 1 of the 18 samples selected from Bailey-Boushay House, comprising $403 in salary and $101 in related fringe benefit expense, for a total of $504, the expenditures were not supported by the related employee timesheet. Identification of a repeat finding: This is a repeat finding for St. Mary Medical Center – Long Beach – Finding 2023-003. For internal controls, this is a repeat finding for Bailey-Boushay House – Findings 2023-003, 2022-007, and 2021-008, but this current year finding is the first time noncompliance has been noted in our testing. Recommendation: We recommend management at St. Mary Medical Center – Long Beach and Bailey-Boushay House execute its processes to properly approve all time charged to federal grants in accordance with 2 CFR 200.430. Additionally, we recommend management execute and retain evidence of its internal controls over the allowability of payroll expenditures. At Bailey-Boushay House, we recommend that only expenses supported by an underlying timesheet be charged to the grant. Views of responsible officials: Management agrees with the finding. Corrective action over timecard approval was implemented in April 2024. For the noncompliance noted at Bailey-Boushay House, Bailey-Boushay House will return the funds to the grantor for amounts that were not supported by an underlying timesheet.
Finding 2024-001 – Allowable Costs/Cost Principles Identification of the federal program: Health Resources and Services Administration HIV Emergency Relief Project Grants Assistance Listing No. 93.914 Pass Through Numbers Pass Through Entity Grant Period PH-002898 County of Los Angeles 01/11/2011–02/28/2025 PH-002375 County of Los Angeles 12/01/2012–06/30/2025 PH-003746 County of Los Angeles 12/01/2012–06/30/2025 PH-003802 County of Los Angeles 01/01/2013–06/30/2025 H-208518 County of Los Angeles 04/01/2006–07/31/2025 PH-004205 County of Los Angeles 06/01/2020–02/28/2025 10126 PREV King County Public Health 03/01/2023–02/29/2024 11987 PREV King County Public Health 03/01/2024–02/28/2025 St. Mary Medical Center – Long Beach Bailey-Boushay House Criteria or specific requirement (including statutory, regulatory, or other citation): 2 CFR 200.303(a) requires that a 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 and the “Internal Control Integrated Framework”, issued by the Bailey-Boushay House Committee of Sponsoring Organizations of the Treadway Commission (COSO).” 2 CFR 200.430 (i) states “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflected the work performed. These records must: (i) be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) be incorporated into the official records of the non-Federal entity; (iii) reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) encompass both federal assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) comply with the established accounting policies and practices of the non-Federal entity.” Only expenditures incurred related to the federal program should be requested for reimbursement. Condition: St. Mary Medical Center – Long Beach and Bailey-Boushay House did not have effective internal controls addressing the requirements of 2 CFR 200.303(a) and 2 CFR 200.430, including consistent approval of employees’ timecards. At Bailey-Boushay House, one employee’s salary that was charged to the grant was not supported by the underlying timesheet for the respective pay period and the related expenditures should not have been charged to the grant and requested for reimbursement. Cause: St. Mary Medical Center – Long Beach and Bailey-Boushay House management have been developing and implementing internal controls in response to the prior year finding; however, controls were not implemented during the entire period under audit. For one employee at Bailey-Boushay House, the timecard reflected zero hours for grant award 10126-PREV. There was a clerical error whereby the hours transferred from the timecard were reported to the wrong grant, resulting in an overcharge to the federal grant. Effect or potential effect: Unallowable and/or inaccurate payroll expenditures could be charged to the federal program. Questioned costs: $504, calculated as the amount charged to the grant that was not supported by the underlying time sheet for one employee. Context: We issued a material weakness for St. Mary Medical Center – Long Beach and Bailey-Boushay House related to internal controls in the prior year. Based upon the implementation date for the corrective action provided by management, the finding related to this internal control had not been remediated for the full period under audit. As such, we did not test the operating effectiveness of this control and are issuing a material weakness consistent with the prior year finding. For one employee, the clerical error resulted in an overcharge to the grant. Total payroll expenditures for St. Mary Medical Center – Long Beach were approximately $1.1 million and represent 24% of the total HIV Emergency Relief Project Grants expenditures of approximately $4.6 million. Total payroll expenditures, including fringe benefits, for Bailey-Boushay House were approximately $1.4 million and represent 30% of the total HIV Emergency Relief Project Grants expenditures of approximately $4.6 million. We selected a sample of 43 payroll expenditures totaling $52,706 to perform compliance testing. Of the 43 samples, 18 samples totaling $18,451 and 25 samples totaling $34,255 were obtained from Bailey-Boushay House and St. Mary Medical Center – Long Beach, respectively. For 1 of the 18 samples selected from Bailey-Boushay House, comprising $403 in salary and $101 in related fringe benefit expense, for a total of $504, the expenditures were not supported by the related employee timesheet. Identification of a repeat finding: This is a repeat finding for St. Mary Medical Center – Long Beach – Finding 2023-003. For internal controls, this is a repeat finding for Bailey-Boushay House – Findings 2023-003, 2022-007, and 2021-008, but this current year finding is the first time noncompliance has been noted in our testing. Recommendation: We recommend management at St. Mary Medical Center – Long Beach and Bailey-Boushay House execute its processes to properly approve all time charged to federal grants in accordance with 2 CFR 200.430. Additionally, we recommend management execute and retain evidence of its internal controls over the allowability of payroll expenditures. At Bailey-Boushay House, we recommend that only expenses supported by an underlying timesheet be charged to the grant. Views of responsible officials: Management agrees with the finding. Corrective action over timecard approval was implemented in April 2024. For the noncompliance noted at Bailey-Boushay House, Bailey-Boushay House will return the funds to the grantor for amounts that were not supported by an underlying timesheet.
Finding 2024-002 – Allowable Costs/Cost Principles Identification of the federal program: U.S. Department of Health and Human Services Medicaid Cluster Assistance Listing No. 93.778 Medical Assistance Program Passed through County of Los Angeles Department of Public Health Pass Through Number Pass Through Entity Grant Period PH-004983 County of Los Angeles 10/1/2022–06/30/2025 Dignity Community Care, DBA California Hospital Medical Center Criteria or specific requirement (including statutory, regulatory, or other citation): 2 CFR 200.303(a) requires that a 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 and the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” 2 CFR 200.430 (i) states “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflected the work performed. These records must: (i) be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) be incorporated into the official records of the non-Federal entity; (iii) reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) encompass both federal assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) comply with the established accounting policies and practices of the non-Federal entity.” Condition: At California Hospital Medical Center, internal controls over the required allowability criteria with regard to payroll expense were not performed for 3 of 60 employees selected for testing. Cause: California Hospital Medical Center management did not consistently perform the necessary internal control procedures addressing the requirements of 2 CFR 200.303(a) and 2 CFR 200.430. Effect or potential effect: Unallowable and/or inaccurate payroll expenditures could be charged to the federal program. Questioned costs: None. Context: For 3 of 60 payroll expenditures selected for testing, California Hospital Medical Center management did not properly approve the employee timecard for time charged to the grant in accordance with the practices of California Hospital Medical Center. Total payroll expenditures for California Hospital Medical Center were approximately $0.2 million and represent 7% of the total Medical Assistance Program expenditures of approximately $3.3 million. Identification of a repeat finding: This is not a repeat finding. Recommendation: We recommend management execute its processes to properly approve all time charged to federal grants in accordance with 2 CFR 200.430. Additionally, we recommend management execute and retain evidence of its internal controls over the allowability of payroll expenditures. Views of responsible officials: Management agrees with the finding and implemented corrective action in July 2024, to require approval of timecards.
Finding 2024-006 – Allowable Costs/Cost Principles Identification of the federal program: U.S. Department of Treasury Assistance Listing No. 21.027 COVID-19 Coronavirus State and Local Fiscal Recovery Funds Pass-through entity: County of Los Angeles Pass-through number: PH-005009 St. Mary Medical Center – Long Beach Criteria or specific requirement (including statutory, regulatory, or other citation): 2 CFR 200.303(a) requires that a 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 and the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” 2 CFR 200.430 (i) states “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflected the work performed. These records must: (i) be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) be incorporated into the official records of the non-Federal entity; (iii) reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) encompass both federal assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) comply with the established accounting policies and practices of the non-Federal entity.” Condition: St. Mary Medical Center – Long Beach did not have effective internal controls addressing the requirements of 2 CFR 200.303(a) and 2 CFR 200.430, including consistent approval of employees’ timecards. Cause: St. Mary Medical Center – Long Beach did not have controls in place to ensure that all timecards were approved. Effect or potential effect: Unallowable and/or inaccurate payroll expenditures could be charged to the federal program. Questioned costs: No questioned costs. Context: We selected 25 payroll transactions totaling $8,621. Of the 25 transactions selected for testing, 2 timecards with supporting payroll expenditures of $246 were not appropriately approved. We did not note any noncompliance with 2 CFR 200.430. Total payroll expenditures for St. Mary Medical Center – Long Beach were $80,190 and represent approximately 6% of the total program expenditures of approximately $1.4 million. Identification of a repeat finding: This is a not a repeat finding as this program was not previously subject to audit. Recommendation: We recommend management at St. Mary Medical Center – Long Beach execute its processes to properly approve all time charged to federal grants in accordance with 2 CFR 200.430. Additionally, we recommend management execute and retain evidence of its internal controls over the allowability of payroll expenditures. Views of responsible officials: Management agrees with the finding. Corrective action over timecard approval was implemented in April 2024.
Criteria If a school operating a schoolwide program does not consolidate federal funds with state and local funds in a consolidated schoolwide pool, an employee who works, in whole or in part, on a federal program or cost objective must document time and effort as follows: (a) For an employee who works solely on a single cost objective (e.g., a single federal program whose funds have not been consolidated or federal programs whose funds have been consolidated but not with State and local funds), an LEA is not required to maintain records reflecting the distribution of the employee’s salary and wages, including among the Federal programs included in the consolidation, if applicable. (b) For an employee who works on multiple activities or cost objectives (e.g., in part on a federal program whose funds have not been consolidated in a consolidated schoolwide pool and in part on federal programs supported with funds consolidated in a schoolwide pool or on activities that are not part of the same cost objective), an LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: (i) The federal program or cost objective; and (ii) Each other program or cost objective supported by consolidated federal funds or other revenue sources. Condition/Context We haphazardly sampled thirteen employees who received compensation under the Title I grant. We viewed the employee time sheet and payroll certifications and annual certifications determining that the employee’s time and effort and payroll certifications are reviewed and approved. We noted that eight of the employees that spent less than 100% of their time on the grant did not indicate how much of their time was allocated to the grant. Therefore, we were unable to verify these employees’ time and effort. We also noted two employees that had missing payroll certifications. Therefore, we were unable to verify approval of the certification had occurred. The sampling methodology used was not statistically valid. Cause Time and effort statements were not prepared in all cases and adequate oversight of the employee’s payroll certification was not in place in order to identify mistakes approved pay. Effect Without demonstrable, documented controls supporting compliance with Title I compliance standards, compliance with the requirements may not be assured. Questioned Costs Known and likely questioned costs were not determinable. Recommendation We recommend that the School District institute additional procedures to ensure that employee’s time and effort, for those with less than 100% allocated to the grant, and payroll certifications are documented and reviewed for accuracy. View of Responsible Officials The School District will institute additional procedures to ensure that time and effort determinations are reviewed and accurate.
Criteria If a school operating a schoolwide program does not consolidate federal funds with state and local funds in a consolidated schoolwide pool, an employee who works, in whole or in part, on a federal program or cost objective must document time and effort as follows: (a) For an employee who works solely on a single cost objective (e.g., a single federal program whose funds have not been consolidated or federal programs whose funds have been consolidated but not with State and local funds), an LEA is not required to maintain records reflecting the distribution of the employee’s salary and wages, including among the Federal programs included in the consolidation, if applicable. (b) For an employee who works on multiple activities or cost objectives (e.g., in part on a federal program whose funds have not been consolidated in a consolidated schoolwide pool and in part on federal programs supported with funds consolidated in a schoolwide pool or on activities that are not part of the same cost objective), an LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: (i) The federal program or cost objective; and (ii) Each other program or cost objective supported by consolidated federal funds or other revenue sources. Condition/Context We haphazardly sampled thirteen employees who received compensation under the Title I grant. We viewed the employee time sheet and payroll certifications and annual certifications determining that the employee’s time and effort and payroll certifications are reviewed and approved. We noted that eight of the employees that spent less than 100% of their time on the grant did not indicate how much of their time was allocated to the grant. Therefore, we were unable to verify these employees’ time and effort. We also noted two employees that had missing payroll certifications. Therefore, we were unable to verify approval of the certification had occurred. The sampling methodology used was not statistically valid. Cause Time and effort statements were not prepared in all cases and adequate oversight of the employee’s payroll certification was not in place in order to identify mistakes approved pay. Effect Without demonstrable, documented controls supporting compliance with Title I compliance standards, compliance with the requirements may not be assured. Questioned Costs Known and likely questioned costs were not determinable. Recommendation We recommend that the School District institute additional procedures to ensure that employee’s time and effort, for those with less than 100% allocated to the grant, and payroll certifications are documented and reviewed for accuracy. View of Responsible Officials The School District will institute additional procedures to ensure that time and effort determinations are reviewed and accurate.
Criteria If a school operating a schoolwide program does not consolidate federal funds with state and local funds in a consolidated schoolwide pool, an employee who works, in whole or in part, on a federal program or cost objective must document time and effort as follows: (a) For an employee who works solely on a single cost objective (e.g., a single federal program whose funds have not been consolidated or federal programs whose funds have been consolidated but not with State and local funds), an LEA is not required to maintain records reflecting the distribution of the employee’s salary and wages, including among the Federal programs included in the consolidation, if applicable. (b) For an employee who works on multiple activities or cost objectives (e.g., in part on a federal program whose funds have not been consolidated in a consolidated schoolwide pool and in part on federal programs supported with funds consolidated in a schoolwide pool or on activities that are not part of the same cost objective), an LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: (i) The federal program or cost objective; and (ii) Each other program or cost objective supported by consolidated federal funds or other revenue sources. Condition/Context We haphazardly sampled thirteen employees who received compensation under the Title I grant. We viewed the employee time sheet and payroll certifications and annual certifications determining that the employee’s time and effort and payroll certifications are reviewed and approved. We noted that eight of the employees that spent less than 100% of their time on the grant did not indicate how much of their time was allocated to the grant. Therefore, we were unable to verify these employees’ time and effort. We also noted two employees that had missing payroll certifications. Therefore, we were unable to verify approval of the certification had occurred. The sampling methodology used was not statistically valid. Cause Time and effort statements were not prepared in all cases and adequate oversight of the employee’s payroll certification was not in place in order to identify mistakes approved pay. Effect Without demonstrable, documented controls supporting compliance with Title I compliance standards, compliance with the requirements may not be assured. Questioned Costs Known and likely questioned costs were not determinable. Recommendation We recommend that the School District institute additional procedures to ensure that employee’s time and effort, for those with less than 100% allocated to the grant, and payroll certifications are documented and reviewed for accuracy. View of Responsible Officials The School District will institute additional procedures to ensure that time and effort determinations are reviewed and accurate.
Criteria If a school operating a schoolwide program does not consolidate federal funds with state and local funds in a consolidated schoolwide pool, an employee who works, in whole or in part, on a federal program or cost objective must document time and effort as follows: (a) For an employee who works solely on a single cost objective (e.g., a single federal program whose funds have not been consolidated or federal programs whose funds have been consolidated but not with State and local funds), an LEA is not required to maintain records reflecting the distribution of the employee’s salary and wages, including among the Federal programs included in the consolidation, if applicable. (b) For an employee who works on multiple activities or cost objectives (e.g., in part on a federal program whose funds have not been consolidated in a consolidated schoolwide pool and in part on federal programs supported with funds consolidated in a schoolwide pool or on activities that are not part of the same cost objective), an LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: (i) The federal program or cost objective; and (ii) Each other program or cost objective supported by consolidated federal funds or other revenue sources. Condition/Context We haphazardly sampled thirteen employees who received compensation under the Title I grant. We viewed the employee time sheet and payroll certifications and annual certifications determining that the employee’s time and effort and payroll certifications are reviewed and approved. We noted that eight of the employees that spent less than 100% of their time on the grant did not indicate how much of their time was allocated to the grant. Therefore, we were unable to verify these employees’ time and effort. We also noted two employees that had missing payroll certifications. Therefore, we were unable to verify approval of the certification had occurred. The sampling methodology used was not statistically valid. Cause Time and effort statements were not prepared in all cases and adequate oversight of the employee’s payroll certification was not in place in order to identify mistakes approved pay. Effect Without demonstrable, documented controls supporting compliance with Title I compliance standards, compliance with the requirements may not be assured. Questioned Costs Known and likely questioned costs were not determinable. Recommendation We recommend that the School District institute additional procedures to ensure that employee’s time and effort, for those with less than 100% allocated to the grant, and payroll certifications are documented and reviewed for accuracy. View of Responsible Officials The School District will institute additional procedures to ensure that time and effort determinations are reviewed and accurate.
Criteria If a school operating a schoolwide program does not consolidate federal funds with state and local funds in a consolidated schoolwide pool, an employee who works, in whole or in part, on a federal program or cost objective must document time and effort as follows: (a) For an employee who works solely on a single cost objective (e.g., a single federal program whose funds have not been consolidated or federal programs whose funds have been consolidated but not with State and local funds), an LEA is not required to maintain records reflecting the distribution of the employee’s salary and wages, including among the Federal programs included in the consolidation, if applicable. (b) For an employee who works on multiple activities or cost objectives (e.g., in part on a federal program whose funds have not been consolidated in a consolidated schoolwide pool and in part on federal programs supported with funds consolidated in a schoolwide pool or on activities that are not part of the same cost objective), an LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: (i) The federal program or cost objective; and (ii) Each other program or cost objective supported by consolidated federal funds or other revenue sources. Condition/Context We haphazardly sampled thirteen employees who received compensation under the Title I grant. We viewed the employee time sheet and payroll certifications and annual certifications determining that the employee’s time and effort and payroll certifications are reviewed and approved. We noted that eight of the employees that spent less than 100% of their time on the grant did not indicate how much of their time was allocated to the grant. Therefore, we were unable to verify these employees’ time and effort. We also noted two employees that had missing payroll certifications. Therefore, we were unable to verify approval of the certification had occurred. The sampling methodology used was not statistically valid. Cause Time and effort statements were not prepared in all cases and adequate oversight of the employee’s payroll certification was not in place in order to identify mistakes approved pay. Effect Without demonstrable, documented controls supporting compliance with Title I compliance standards, compliance with the requirements may not be assured. Questioned Costs Known and likely questioned costs were not determinable. Recommendation We recommend that the School District institute additional procedures to ensure that employee’s time and effort, for those with less than 100% allocated to the grant, and payroll certifications are documented and reviewed for accuracy. View of Responsible Officials The School District will institute additional procedures to ensure that time and effort determinations are reviewed and accurate.
Criteria If a school operating a schoolwide program does not consolidate federal funds with state and local funds in a consolidated schoolwide pool, an employee who works, in whole or in part, on a federal program or cost objective must document time and effort as follows: (a) For an employee who works solely on a single cost objective (e.g., a single federal program whose funds have not been consolidated or federal programs whose funds have been consolidated but not with State and local funds), an LEA is not required to maintain records reflecting the distribution of the employee’s salary and wages, including among the Federal programs included in the consolidation, if applicable. (b) For an employee who works on multiple activities or cost objectives (e.g., in part on a federal program whose funds have not been consolidated in a consolidated schoolwide pool and in part on federal programs supported with funds consolidated in a schoolwide pool or on activities that are not part of the same cost objective), an LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: (i) The federal program or cost objective; and (ii) Each other program or cost objective supported by consolidated federal funds or other revenue sources. Condition/Context We haphazardly sampled thirteen employees who received compensation under the Title I grant. We viewed the employee time sheet and payroll certifications and annual certifications determining that the employee’s time and effort and payroll certifications are reviewed and approved. We noted that eight of the employees that spent less than 100% of their time on the grant did not indicate how much of their time was allocated to the grant. Therefore, we were unable to verify these employees’ time and effort. We also noted two employees that had missing payroll certifications. Therefore, we were unable to verify approval of the certification had occurred. The sampling methodology used was not statistically valid. Cause Time and effort statements were not prepared in all cases and adequate oversight of the employee’s payroll certification was not in place in order to identify mistakes approved pay. Effect Without demonstrable, documented controls supporting compliance with Title I compliance standards, compliance with the requirements may not be assured. Questioned Costs Known and likely questioned costs were not determinable. Recommendation We recommend that the School District institute additional procedures to ensure that employee’s time and effort, for those with less than 100% allocated to the grant, and payroll certifications are documented and reviewed for accuracy. View of Responsible Officials The School District will institute additional procedures to ensure that time and effort determinations are reviewed and accurate.
Criteria If a school operating a schoolwide program does not consolidate federal funds with state and local funds in a consolidated schoolwide pool, an employee who works, in whole or in part, on a federal program or cost objective must document time and effort as follows: (a) For an employee who works solely on a single cost objective (e.g., a single federal program whose funds have not been consolidated or federal programs whose funds have been consolidated but not with State and local funds), an LEA is not required to maintain records reflecting the distribution of the employee’s salary and wages, including among the Federal programs included in the consolidation, if applicable. (b) For an employee who works on multiple activities or cost objectives (e.g., in part on a federal program whose funds have not been consolidated in a consolidated schoolwide pool and in part on federal programs supported with funds consolidated in a schoolwide pool or on activities that are not part of the same cost objective), an LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: (i) The federal program or cost objective; and (ii) Each other program or cost objective supported by consolidated federal funds or other revenue sources. Condition/Context We haphazardly sampled thirteen employees who received compensation under the Title I grant. We viewed the employee time sheet and payroll certifications and annual certifications determining that the employee’s time and effort and payroll certifications are reviewed and approved. We noted that eight of the employees that spent less than 100% of their time on the grant did not indicate how much of their time was allocated to the grant. Therefore, we were unable to verify these employees’ time and effort. We also noted two employees that had missing payroll certifications. Therefore, we were unable to verify approval of the certification had occurred. The sampling methodology used was not statistically valid. Cause Time and effort statements were not prepared in all cases and adequate oversight of the employee’s payroll certification was not in place in order to identify mistakes approved pay. Effect Without demonstrable, documented controls supporting compliance with Title I compliance standards, compliance with the requirements may not be assured. Questioned Costs Known and likely questioned costs were not determinable. Recommendation We recommend that the School District institute additional procedures to ensure that employee’s time and effort, for those with less than 100% allocated to the grant, and payroll certifications are documented and reviewed for accuracy. View of Responsible Officials The School District will institute additional procedures to ensure that time and effort determinations are reviewed and accurate.
Criteria If a school operating a schoolwide program does not consolidate federal funds with state and local funds in a consolidated schoolwide pool, an employee who works, in whole or in part, on a federal program or cost objective must document time and effort as follows: (a) For an employee who works solely on a single cost objective (e.g., a single federal program whose funds have not been consolidated or federal programs whose funds have been consolidated but not with State and local funds), an LEA is not required to maintain records reflecting the distribution of the employee’s salary and wages, including among the Federal programs included in the consolidation, if applicable. (b) For an employee who works on multiple activities or cost objectives (e.g., in part on a federal program whose funds have not been consolidated in a consolidated schoolwide pool and in part on federal programs supported with funds consolidated in a schoolwide pool or on activities that are not part of the same cost objective), an LEA must maintain time and effort distribution records in accordance with 2 CFR section 200.430(i)(1)(vii) that support the portion of time and effort dedicated to: (i) The federal program or cost objective; and (ii) Each other program or cost objective supported by consolidated federal funds or other revenue sources. Condition/Context We haphazardly sampled thirteen employees who received compensation under the Title I grant. We viewed the employee time sheet and payroll certifications and annual certifications determining that the employee’s time and effort and payroll certifications are reviewed and approved. We noted that eight of the employees that spent less than 100% of their time on the grant did not indicate how much of their time was allocated to the grant. Therefore, we were unable to verify these employees’ time and effort. We also noted two employees that had missing payroll certifications. Therefore, we were unable to verify approval of the certification had occurred. The sampling methodology used was not statistically valid. Cause Time and effort statements were not prepared in all cases and adequate oversight of the employee’s payroll certification was not in place in order to identify mistakes approved pay. Effect Without demonstrable, documented controls supporting compliance with Title I compliance standards, compliance with the requirements may not be assured. Questioned Costs Known and likely questioned costs were not determinable. Recommendation We recommend that the School District institute additional procedures to ensure that employee’s time and effort, for those with less than 100% allocated to the grant, and payroll certifications are documented and reviewed for accuracy. View of Responsible Officials The School District will institute additional procedures to ensure that time and effort determinations are reviewed and accurate.
2024 – 003: Allowable Costs Federal Agency: U.S. Department Education Federal Program Name: Education Stabilization Fund Assistance Listing Number: 84.425 Pass-Through Agency: Indiana Department of Education Pass-Through Numbers: S425D210013, S425D210013, S425W210015 Award Period: July 1, 2023 – June 30, 2024 Type of Finding: • Significant Deficiency in Internal Control Over Compliance • Other Matters Criteria or specific requirement: The Compliance Supplement requires that compensation for personal services be charged to the federal grant based upon approved actual time worked on the program and not based on an allocation or budget (2 CFR 200.430(i)). Condition: While performing audit procedures, it was noted that payroll expenses were charged to the grant program but were not supported with time and effort documentation and was for an employee bonus. Questioned costs: $6,631 Context: During the process of obtaining an understanding of internal controls and processing of payroll expenditures, we noted payroll charge to the grant did not have time and effort documentation for amounts charged to the grant and included a bonus employee charged to the grant inaccurately. Cause: Salary figures for salaried employees were charged to the federal grant based on unsupported work actually performed for the program and inaccurate payroll costs were charged to the grant for an employee bonus. Effect: NWILCS has not fully followed compliance attributes with the allowable costs principles set forth by the Compliance Supplement related to allocation of salaries being charged based on approved time worked for a program. Personnel need to reinforce policies to ensure control procedures are in place to ensure salaries charged to a grant are appropriately based on actual approved time worked in a program. Repeat finding: No. Recommendation: We recommend NWILCS ensure policies and procedures for payroll expenditures for grant programs be charged to the federal grant based on approved hours worked in the program. Views of responsible officials: There is no disagreement with the audit finding.
2024 – 003: Allowable Costs Federal Agency: U.S. Department Education Federal Program Name: Education Stabilization Fund Assistance Listing Number: 84.425 Pass-Through Agency: Indiana Department of Education Pass-Through Numbers: S425D210013, S425D210013, S425W210015 Award Period: July 1, 2023 – June 30, 2024 Type of Finding: • Significant Deficiency in Internal Control Over Compliance • Other Matters Criteria or specific requirement: The Compliance Supplement requires that compensation for personal services be charged to the federal grant based upon approved actual time worked on the program and not based on an allocation or budget (2 CFR 200.430(i)). Condition: While performing audit procedures, it was noted that payroll expenses were charged to the grant program but were not supported with time and effort documentation and was for an employee bonus. Questioned costs: $6,631 Context: During the process of obtaining an understanding of internal controls and processing of payroll expenditures, we noted payroll charge to the grant did not have time and effort documentation for amounts charged to the grant and included a bonus employee charged to the grant inaccurately. Cause: Salary figures for salaried employees were charged to the federal grant based on unsupported work actually performed for the program and inaccurate payroll costs were charged to the grant for an employee bonus. Effect: NWILCS has not fully followed compliance attributes with the allowable costs principles set forth by the Compliance Supplement related to allocation of salaries being charged based on approved time worked for a program. Personnel need to reinforce policies to ensure control procedures are in place to ensure salaries charged to a grant are appropriately based on actual approved time worked in a program. Repeat finding: No. Recommendation: We recommend NWILCS ensure policies and procedures for payroll expenditures for grant programs be charged to the federal grant based on approved hours worked in the program. Views of responsible officials: There is no disagreement with the audit finding.
2024 – 003: Allowable Costs Federal Agency: U.S. Department Education Federal Program Name: Education Stabilization Fund Assistance Listing Number: 84.425 Pass-Through Agency: Indiana Department of Education Pass-Through Numbers: S425D210013, S425D210013, S425W210015 Award Period: July 1, 2023 – June 30, 2024 Type of Finding: • Significant Deficiency in Internal Control Over Compliance • Other Matters Criteria or specific requirement: The Compliance Supplement requires that compensation for personal services be charged to the federal grant based upon approved actual time worked on the program and not based on an allocation or budget (2 CFR 200.430(i)). Condition: While performing audit procedures, it was noted that payroll expenses were charged to the grant program but were not supported with time and effort documentation and was for an employee bonus. Questioned costs: $6,631 Context: During the process of obtaining an understanding of internal controls and processing of payroll expenditures, we noted payroll charge to the grant did not have time and effort documentation for amounts charged to the grant and included a bonus employee charged to the grant inaccurately. Cause: Salary figures for salaried employees were charged to the federal grant based on unsupported work actually performed for the program and inaccurate payroll costs were charged to the grant for an employee bonus. Effect: NWILCS has not fully followed compliance attributes with the allowable costs principles set forth by the Compliance Supplement related to allocation of salaries being charged based on approved time worked for a program. Personnel need to reinforce policies to ensure control procedures are in place to ensure salaries charged to a grant are appropriately based on actual approved time worked in a program. Repeat finding: No. Recommendation: We recommend NWILCS ensure policies and procedures for payroll expenditures for grant programs be charged to the federal grant based on approved hours worked in the program. Views of responsible officials: There is no disagreement with the audit finding.
Subject: Title I Grants to Local Educational Agencies - Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listing Number: 84.010A Federal Award Numbers and Years (or Other Identifying Numbers): S010A210014, S010A220014, S010A230014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Finding: Material Weakness, Other Matters Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.430 states in part: (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity (See paragraph (h)(1)(ii) above for treatment of incidental work for IHEs.); and vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the activities allowed or unallowed and allowable costs/cost principle compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: $5,705 (Known questioned costs) Context: For 5 selections, in a sample of 40 payroll transactions, the School Corporation did not have time and effort logs to support the portion of the employees’ time charged to the grant. The employees’ time was split with another federal grant, however the School Corporation did not have support for the allocation of the time charged to the Title I grant. Additionally, for three selections, the School Corporation charged a higher percentage to the Title I grant than what the time and effort log percentage showed. Identification as a repeat finding: This is a repeat finding from the immediately prior audit. The prior finding number was 2022-008. Recommendation: We recommend management ensure semi-annual certifications are completed for all employees charged to the grant awards at 100% and time and effort logs are maintained for all employees not charged at 100% to support work performed and charged to the grant awards. We recommend management establish a documented review by management of semi-annual certifications and time and effort logs to ensure time charged to grant awards is allowable and allocable based on work performed in accordance with grant requirements. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Subject: Title I Grants to Local Educational Agencies - Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listing Number: 84.010A Federal Award Numbers and Years (or Other Identifying Numbers): S010A210014, S010A220014, S010A230014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Finding: Material Weakness, Other Matters Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.430 states in part: (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity (See paragraph (h)(1)(ii) above for treatment of incidental work for IHEs.); and vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the activities allowed or unallowed and allowable costs/cost principle compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: $5,705 (Known questioned costs) Context: For 5 selections, in a sample of 40 payroll transactions, the School Corporation did not have time and effort logs to support the portion of the employees’ time charged to the grant. The employees’ time was split with another federal grant, however the School Corporation did not have support for the allocation of the time charged to the Title I grant. Additionally, for three selections, the School Corporation charged a higher percentage to the Title I grant than what the time and effort log percentage showed. Identification as a repeat finding: This is a repeat finding from the immediately prior audit. The prior finding number was 2022-008. Recommendation: We recommend management ensure semi-annual certifications are completed for all employees charged to the grant awards at 100% and time and effort logs are maintained for all employees not charged at 100% to support work performed and charged to the grant awards. We recommend management establish a documented review by management of semi-annual certifications and time and effort logs to ensure time charged to grant awards is allowable and allocable based on work performed in accordance with grant requirements. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Subject: Title I Grants to Local Educational Agencies - Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listing Number: 84.010A Federal Award Numbers and Years (or Other Identifying Numbers): S010A210014, S010A220014, S010A230014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Finding: Material Weakness, Other Matters Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.430 states in part: (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity (See paragraph (h)(1)(ii) above for treatment of incidental work for IHEs.); and vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the activities allowed or unallowed and allowable costs/cost principle compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: $5,705 (Known questioned costs) Context: For 5 selections, in a sample of 40 payroll transactions, the School Corporation did not have time and effort logs to support the portion of the employees’ time charged to the grant. The employees’ time was split with another federal grant, however the School Corporation did not have support for the allocation of the time charged to the Title I grant. Additionally, for three selections, the School Corporation charged a higher percentage to the Title I grant than what the time and effort log percentage showed. Identification as a repeat finding: This is a repeat finding from the immediately prior audit. The prior finding number was 2022-008. Recommendation: We recommend management ensure semi-annual certifications are completed for all employees charged to the grant awards at 100% and time and effort logs are maintained for all employees not charged at 100% to support work performed and charged to the grant awards. We recommend management establish a documented review by management of semi-annual certifications and time and effort logs to ensure time charged to grant awards is allowable and allocable based on work performed in accordance with grant requirements. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Information on the federal program: Subject: Education Stabilization Fund - Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U, 84.425W Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013, S425W210015 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Finding: Material Weakness, Other Matters Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.430 states in part: (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity (See paragraph (h)(1)(ii) above for treatment of incidental work for IHEs.); and vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the activities allowed or unallowed and allowable costs/cost principle compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: $1,426 (Known questioned costs) Context: For 1 selection, in a sample of 40 payroll transactions, the School Corporation did not have time and effort logs to support the portion of the employees’ time charged to the grant. The employees’ time was split with another federal grant; however, the School Corporation did not have support for the allocation of the time charged to the Education Stabilization Fund grant. Identification as a repeat finding: This is a repeat finding from the immediately prior audit. The prior finding number was 2022-009. Recommendation: We recommend management ensure semi-annual certifications are completed for all employees charged to the grant awards at 100% and time and effort logs are maintained for all employees not charged at 100% to support work performed and charged to the grant awards. We recommend management establish a documented review by management of semi-annual certifications and time and effort logs to ensure time charged to grant awards is allowable and allocable based on work performed in accordance with grant requirements. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Information on the federal program: Subject: Education Stabilization Fund - Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U, 84.425W Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013, S425W210015 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Finding: Material Weakness, Other Matters Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.430 states in part: (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity (See paragraph (h)(1)(ii) above for treatment of incidental work for IHEs.); and vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the activities allowed or unallowed and allowable costs/cost principle compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: $1,426 (Known questioned costs) Context: For 1 selection, in a sample of 40 payroll transactions, the School Corporation did not have time and effort logs to support the portion of the employees’ time charged to the grant. The employees’ time was split with another federal grant; however, the School Corporation did not have support for the allocation of the time charged to the Education Stabilization Fund grant. Identification as a repeat finding: This is a repeat finding from the immediately prior audit. The prior finding number was 2022-009. Recommendation: We recommend management ensure semi-annual certifications are completed for all employees charged to the grant awards at 100% and time and effort logs are maintained for all employees not charged at 100% to support work performed and charged to the grant awards. We recommend management establish a documented review by management of semi-annual certifications and time and effort logs to ensure time charged to grant awards is allowable and allocable based on work performed in accordance with grant requirements. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Information on the federal program: Subject: Education Stabilization Fund - Activities Allowed or Unallowed, Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U, 84.425W Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013, S425W210015 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Audit Finding: Material Weakness, Other Matters Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.430 states in part: (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity (See paragraph (h)(1)(ii) above for treatment of incidental work for IHEs.); and vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the activities allowed or unallowed and allowable costs/cost principle compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: $1,426 (Known questioned costs) Context: For 1 selection, in a sample of 40 payroll transactions, the School Corporation did not have time and effort logs to support the portion of the employees’ time charged to the grant. The employees’ time was split with another federal grant; however, the School Corporation did not have support for the allocation of the time charged to the Education Stabilization Fund grant. Identification as a repeat finding: This is a repeat finding from the immediately prior audit. The prior finding number was 2022-009. Recommendation: We recommend management ensure semi-annual certifications are completed for all employees charged to the grant awards at 100% and time and effort logs are maintained for all employees not charged at 100% to support work performed and charged to the grant awards. We recommend management establish a documented review by management of semi-annual certifications and time and effort logs to ensure time charged to grant awards is allowable and allocable based on work performed in accordance with grant requirements. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2024-001: Payroll Allocations Information on the Federal Program: 93.073 - Centers for Disease Control and Prevention: Birth Defects and Developmental Disabilities, Prevention and Surveillance. See Finding 2024-001. Criteria or Specific Requirement: Under Uniform Guidance (2 CFR Part 200), specifically § 200.430 (Compensation – Personal Services), labor costs must be allocated to programs based on actual time worked by employees on those specific programs. The guidance also mandates that overtime pay must be allocated in proportion to the time worked across the different programs. Failure to properly allocate employee time and overtime costs could result in non-compliance with Federal grant requirements, misreporting of program costs, and inaccurate financial statements. Condition: During the audit for the fiscal year ended June 30, 2024, it was found that employee time worked, including overtime hours, was not being properly allocated to the various programs. Specifically, overtime hours worked by employees were not included in the program allocations, resulting in the misallocation of labor costs. In several cases, overtime worked by employees on specific programs was omitted or incorrectly allocated, leading to a misrepresentation of actual program costs. Cause: Overtime hours were excluded from program allocations entirely. Effect or Potential Effect: Due to incorrect allocation of hours, including overtime, the financial statements inaccurately reflect the costs of various programs or projects. Many programs, especially those funded by grants or other restricted funding sources, require accurate reporting of labor costs. The failure to allocate overtime to the appropriate programs could result in non-compliance with the terms of those grants or funding agreements, potentially leading to audits, penalties, or the loss of funding. Questioned Costs: None. Context: CHADD misallocated time to programs for any employee that worked overtime for the fiscal year ending June 30, 2024. Identification as a Repeat Finding, if Applicable: Not applicable. Recommendation: The payroll system should be updated to automatically calculate and allocate overtime hours to the correct program or project. This should be integrated with the standard time allocation processes, ensuring that overtime pay is properly distributed across programs.
2024-004 (2023-004) – Activities Allowed, Allowable Costs over Payroll (Significant Deficiency in Internal Controls over Compliance) (Repeated/Modified) Federal Program Information Federal Award Title and ALN: Airport Improvement Program, 20.106 Federal Awarding Agency: Department of Transportation, Federal Aviation Administration Federal Award ID Number: SAF-SWG-3-35-0037-057-2021 Federal Award Year: 2024 Condition: Two payroll checks were duplicated and included in the request for reimbursement. These checks totaled $2,694, out of a total of $876,014 in payroll charged to the program. Management’s Progress on Repeat Findings: Some progress made from prior year. Criteria: Per 2 CFR 200.303(a), the non-federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR section 200.430(f) – Factors affecting allowability of costs, costs charged to Federal programs may not be included as a cost or used to meet cost sharing or matching requirements of any other federally-financed program in either the current or a prior period. Cause: The City does not have sufficient controls in place to ensure the accuracy of the amounts listed on the general ledger as charged to the grant. Questioned Cost: Known and likely questioned costs of $2,694 Effect: The City requested and received reimbursement for duplicate transactions not properly allocable to the program in the amount of $2,694.
2024-004 (2023-004) – Activities Allowed, Allowable Costs over Payroll (Significant Deficiency in Internal Controls over Compliance) (Repeated/Modified) Federal Program Information Federal Award Title and ALN: Airport Improvement Program, 20.106 Federal Awarding Agency: Department of Transportation, Federal Aviation Administration Federal Award ID Number: SAF-SWG-3-35-0037-057-2021 Federal Award Year: 2024 Condition: Two payroll checks were duplicated and included in the request for reimbursement. These checks totaled $2,694, out of a total of $876,014 in payroll charged to the program. Management’s Progress on Repeat Findings: Some progress made from prior year. Criteria: Per 2 CFR 200.303(a), the non-federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Per 2 CFR section 200.430(f) – Factors affecting allowability of costs, costs charged to Federal programs may not be included as a cost or used to meet cost sharing or matching requirements of any other federally-financed program in either the current or a prior period. Cause: The City does not have sufficient controls in place to ensure the accuracy of the amounts listed on the general ledger as charged to the grant. Questioned Cost: Known and likely questioned costs of $2,694 Effect: The City requested and received reimbursement for duplicate transactions not properly allocable to the program in the amount of $2,694.
2024-002 U.S. Department of Education, Assistance Listing #84.027/84.173 Special Education Cluster (IDEA) for the period of July 1, 2023 through June 30, 2024 Criteria: Uniform Guidance section 2 CFR 200.430(g) Standards for Documentation of Personnel Expenses requires records to support the distribution of employee salaries or wages when they are allocated amongst more than one Federal award or a Federal award and a non-Federal award. Budget estimates alone do not qualify as support for charges to Federal awards. Condition: During our testing of payroll expenditures at the School Department over the Special Education Cluster (IDEA), we were unable to obtain actual time worked for employees split between multiple grants or Federal and non-Federal activities. Employee time was allocated based on budget estimates throughout the year. Cause: There is currently no system in place to require staff split between multiple grants or Federal and non-Federal activities to maintain weekly timesheets reflecting actual time worked. Effect: Actual time worked could differ from budgeted estimates. Without adequate support, payroll charges could be deemed unallowable. Known Questioned Costs: $1,243 Likely Questioned Costs: $7,394 Recommendation: We recommend a timesheet system be implemented to ensure that employees split between multiple grants or Federal and non-Federal activities are charging actual time worked to the applicable Federal grant.
2024-002 U.S. Department of Education, Assistance Listing #84.027/84.173 Special Education Cluster (IDEA) for the period of July 1, 2023 through June 30, 2024 Criteria: Uniform Guidance section 2 CFR 200.430(g) Standards for Documentation of Personnel Expenses requires records to support the distribution of employee salaries or wages when they are allocated amongst more than one Federal award or a Federal award and a non-Federal award. Budget estimates alone do not qualify as support for charges to Federal awards. Condition: During our testing of payroll expenditures at the School Department over the Special Education Cluster (IDEA), we were unable to obtain actual time worked for employees split between multiple grants or Federal and non-Federal activities. Employee time was allocated based on budget estimates throughout the year. Cause: There is currently no system in place to require staff split between multiple grants or Federal and non-Federal activities to maintain weekly timesheets reflecting actual time worked. Effect: Actual time worked could differ from budgeted estimates. Without adequate support, payroll charges could be deemed unallowable. Known Questioned Costs: $1,243 Likely Questioned Costs: $7,394 Recommendation: We recommend a timesheet system be implemented to ensure that employees split between multiple grants or Federal and non-Federal activities are charging actual time worked to the applicable Federal grant.
2024-002 U.S. Department of Education, Assistance Listing #84.027/84.173 Special Education Cluster (IDEA) for the period of July 1, 2023 through June 30, 2024 Criteria: Uniform Guidance section 2 CFR 200.430(g) Standards for Documentation of Personnel Expenses requires records to support the distribution of employee salaries or wages when they are allocated amongst more than one Federal award or a Federal award and a non-Federal award. Budget estimates alone do not qualify as support for charges to Federal awards. Condition: During our testing of payroll expenditures at the School Department over the Special Education Cluster (IDEA), we were unable to obtain actual time worked for employees split between multiple grants or Federal and non-Federal activities. Employee time was allocated based on budget estimates throughout the year. Cause: There is currently no system in place to require staff split between multiple grants or Federal and non-Federal activities to maintain weekly timesheets reflecting actual time worked. Effect: Actual time worked could differ from budgeted estimates. Without adequate support, payroll charges could be deemed unallowable. Known Questioned Costs: $1,243 Likely Questioned Costs: $7,394 Recommendation: We recommend a timesheet system be implemented to ensure that employees split between multiple grants or Federal and non-Federal activities are charging actual time worked to the applicable Federal grant.
2024-001 U.S. Department of Treasury, Assistance Listing #21.027 Coronavirus State and Local Fiscal Recovery Funds Program for the period of July 1, 2023 through June 30, 2024 Criteria: Uniform Guidance section 2 CFR 200.430(g) Standards for Documentation of Personnel Expenses requires records to support the distribution of employee salaries or wages when they are allocated amongst more than one Federal award or a Federal award and a non-Federal award. Budget estimates alone do not qualify as support for charges to Federal awards. Condition: During our testing of payroll expenditures at the School Department over the Coronavirus State and Local Fiscal Recovery Funds Program, we were unable to obtain actual time worked for employees split between multiple grants or Federal and non-Federal activities. Employee time was allocated based on budget estimates throughout the year. Cause: There is currently no system in place to require staff split between multiple grants or Federal and non-Federal activities to maintain weekly timesheets reflecting actual time worked. Effect: Actual time worked could differ from budgeted estimates. Without adequate support, payroll charges could be deemed unallowable. Known Questioned Costs: $4,422 Likely Questioned Costs: $31,105 Recommendation: We recommend a timesheet system be implemented to ensure that employees split between multiple grants or Federal and non-Federal activities are charging actual time worked to the applicable Federal grant.
2024-001 U.S. Department of Treasury, Assistance Listing #21.027 Coronavirus State and Local Fiscal Recovery Funds Program for the period of July 1, 2023 through June 30, 2024 Criteria: Uniform Guidance section 2 CFR 200.430(g) Standards for Documentation of Personnel Expenses requires records to support the distribution of employee salaries or wages when they are allocated amongst more than one Federal award or a Federal award and a non-Federal award. Budget estimates alone do not qualify as support for charges to Federal awards. Condition: During our testing of payroll expenditures at the School Department over the Coronavirus State and Local Fiscal Recovery Funds Program, we were unable to obtain actual time worked for employees split between multiple grants or Federal and non-Federal activities. Employee time was allocated based on budget estimates throughout the year. Cause: There is currently no system in place to require staff split between multiple grants or Federal and non-Federal activities to maintain weekly timesheets reflecting actual time worked. Effect: Actual time worked could differ from budgeted estimates. Without adequate support, payroll charges could be deemed unallowable. Known Questioned Costs: $4,422 Likely Questioned Costs: $31,105 Recommendation: We recommend a timesheet system be implemented to ensure that employees split between multiple grants or Federal and non-Federal activities are charging actual time worked to the applicable Federal grant.