2024-106 Lack of Time and Effort Documentation Policy (Initially reported 2024) Assistance Listing Number: 93.224, 93.527 and 93.211. Name of Federal Agency: Department of Health and Human Services, HRSA Program Title: Health Center Program (Community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) and Grants for New and Expanded Services Under the Health Center Program, and Rural Telemedicine Grants Compliance Requirement: Allowable Activities and Allowable Costs Pass-through Entity: N/A Federal Grant/Contract Number and Grant Year: H8006452 (2024 and 2023), H2E45500 (2022), H8K49674 (2023), COVID-19 H2E50094 (2023), H8N53812 (2024), H8L50549 (2023), COVID-19 H8G48569 (2022), GA142923 (2021), G2846293(2022) and G3949501 (2023) Finding Type: Material Weakness in Internal Control Questioned Costs: $0 Condition: Time and effort reporting on actual hours spent on individual grant projects used to support the budgeted allocations of employee salary for each grant are not being kept. This is a systemic issue as a procedure for documenting time and effort by employee to justify the allocation of salaries across grants has not been put in place. This is a systematic issue. Criteria: 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Also, under eCFR 2 CFR 200.430 – Compensation – personal services budget estimates do not qualify as support for charges to federal awards. Cause: The Organization has not put into practice a procedure where records are kept with employee salaries spent by hour on individual grants to substantiate the amount of budgeted FTE used on the reimbursement requests. Effect: Budgeted FTE used for reimbursement requests may be inaccurate resulting in incorrect amounts being requested for reimbursement. Recommendation: The Organization should put in place procedures to accurately document employee hours spent on each of the federal awards to support the budgeted FTE used on the reimbursement requests. Views of Responsible Officials and Planned Corrective Action: We acknowledge the finding and have adopted a formal Time and Effort Reporting Policy. Standardized timesheets will be implemented and staff trained within 60 days, with supervisors reviewing submissions. The Finance Manager will monitor records monthly and conduct quarterly reviews to ensure compliance going forward.
2024-107 Incorrect Costs were Submitted for Reimbursement (Initially reported 2024) Assistance Listing Number: 93.211 Name of Federal Agency: Department of Health and Human Services, HRSA Program Title: Rural Telemedicine Grants Compliance Requirement: Allowable Costs Pass-through Entity: N/A Federal Grant/Contract Number and Grant Year: GA142923 (2021), G2846293 (2022), and GA3949501 (2023) Finding Type: Significant Deficiency in Internal Control Questioned Costs: $68 known and $589 likely Condition: The September 2024 reimbursement request included one instance, out of 37 items tested, where calculations of personnel expenditures allocable to the grant used an inaccurate amount, resulting in an overcharge of personnel expenditures. In calculating the allocable expenditure, wages for the month of August, which had previously been charged to the grant, were used to calculate the amount allocable to the grant for the month of September. Gross wages for August exceeded gross wages for September. Wages for both months were allowable and allocable to the grant. This is not a systemic problem but an isolated occurrence resulting in an immaterial difference in the amount reimbursed and the amount that should have been requested for September 2024 wages paid. The sample was not statistically valid. Criteria: 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Per 2 CFR 200.430(g), costs charged to federal awards must be supported by records that- support the distribution of salaries and wages among specific activities, while reflecting the total activity of the employee, not to exceed 100% of compensated activities. Cause: Wages requested for reimbursement in September 2024 reflected the wages paid in August 2024 in error and were not detected during the review process over the reimbursement request. Effect: Personnel costs charged to the award were based on amounts exceeding 100% of the employee’s compensation for one month, resulting in an overcharge to the award. Recommendation: Review of costs allocated and requested for reimbursement should incorporate consideration of the period the costs were incurred. Views of Responsible Officials and Planned Corrective Action: We acknowledge the finding and have strengthened our review process for reimbursement requests to prevent similar errors. Finance staff verify payroll periods against reimbursement periods before submission, and supervisors perform an additional review. This process includes careful cross-checking against the appropriate pay periods. This was an isolated occurrence with immaterial impact, but corrective steps will ensure accuracy in future requests.
2024-106 Lack of Time and Effort Documentation Policy (Initially reported 2024) Assistance Listing Number: 93.224, 93.527 and 93.211. Name of Federal Agency: Department of Health and Human Services, HRSA Program Title: Health Center Program (Community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) and Grants for New and Expanded Services Under the Health Center Program, and Rural Telemedicine Grants Compliance Requirement: Allowable Activities and Allowable Costs Pass-through Entity: N/A Federal Grant/Contract Number and Grant Year: H8006452 (2024 and 2023), H2E45500 (2022), H8K49674 (2023), COVID-19 H2E50094 (2023), H8N53812 (2024), H8L50549 (2023), COVID-19 H8G48569 (2022), GA142923 (2021), G2846293(2022) and G3949501 (2023) Finding Type: Material Weakness in Internal Control Questioned Costs: $0 Condition: Time and effort reporting on actual hours spent on individual grant projects used to support the budgeted allocations of employee salary for each grant are not being kept. This is a systemic issue as a procedure for documenting time and effort by employee to justify the allocation of salaries across grants has not been put in place. This is a systematic issue. Criteria: 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Also, under eCFR 2 CFR 200.430 – Compensation – personal services budget estimates do not qualify as support for charges to federal awards. Cause: The Organization has not put into practice a procedure where records are kept with employee salaries spent by hour on individual grants to substantiate the amount of budgeted FTE used on the reimbursement requests. Effect: Budgeted FTE used for reimbursement requests may be inaccurate resulting in incorrect amounts being requested for reimbursement. Recommendation: The Organization should put in place procedures to accurately document employee hours spent on each of the federal awards to support the budgeted FTE used on the reimbursement requests. Views of Responsible Officials and Planned Corrective Action: We acknowledge the finding and have adopted a formal Time and Effort Reporting Policy. Standardized timesheets will be implemented and staff trained within 60 days, with supervisors reviewing submissions. The Finance Manager will monitor records monthly and conduct quarterly reviews to ensure compliance going forward.
2024-107 Incorrect Costs were Submitted for Reimbursement (Initially reported 2024) Assistance Listing Number: 93.211 Name of Federal Agency: Department of Health and Human Services, HRSA Program Title: Rural Telemedicine Grants Compliance Requirement: Allowable Costs Pass-through Entity: N/A Federal Grant/Contract Number and Grant Year: GA142923 (2021), G2846293 (2022), and GA3949501 (2023) Finding Type: Significant Deficiency in Internal Control Questioned Costs: $68 known and $589 likely Condition: The September 2024 reimbursement request included one instance, out of 37 items tested, where calculations of personnel expenditures allocable to the grant used an inaccurate amount, resulting in an overcharge of personnel expenditures. In calculating the allocable expenditure, wages for the month of August, which had previously been charged to the grant, were used to calculate the amount allocable to the grant for the month of September. Gross wages for August exceeded gross wages for September. Wages for both months were allowable and allocable to the grant. This is not a systemic problem but an isolated occurrence resulting in an immaterial difference in the amount reimbursed and the amount that should have been requested for September 2024 wages paid. The sample was not statistically valid. Criteria: 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Per 2 CFR 200.430(g), costs charged to federal awards must be supported by records that- support the distribution of salaries and wages among specific activities, while reflecting the total activity of the employee, not to exceed 100% of compensated activities. Cause: Wages requested for reimbursement in September 2024 reflected the wages paid in August 2024 in error and were not detected during the review process over the reimbursement request. Effect: Personnel costs charged to the award were based on amounts exceeding 100% of the employee’s compensation for one month, resulting in an overcharge to the award. Recommendation: Review of costs allocated and requested for reimbursement should incorporate consideration of the period the costs were incurred. Views of Responsible Officials and Planned Corrective Action: We acknowledge the finding and have strengthened our review process for reimbursement requests to prevent similar errors. Finance staff verify payroll periods against reimbursement periods before submission, and supervisors perform an additional review. This process includes careful cross-checking against the appropriate pay periods. This was an isolated occurrence with immaterial impact, but corrective steps will ensure accuracy in future requests.
2024-001 Compensation for Personal Services Head Start Cluster – Assistance Listing No. 93.600 Award Numbers: 08CH010736-06 – Award Period: December 1, 2023 through June 30, 2024 08CH012759-01 – Award Period: July 1, 2024 through November 30, 2024 MOEAI-202366770 – Award Period: July 1, 2023 through June 30, 2024 MOEAI-202474487 – Award Period: July 1, 2024 through June 30, 2025 Maternal, Infant and Early Childhood Home Visiting Grant – Assistance Listing No. 93.870 Award Numbers: CTGG1 QAAA 2024*2428 – Award Period: October 1, 2023 through September 30, 2024 CTGG1 QAAA 2025*2585 – Award Period: October 1, 2024 through September 30, 2025 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Condition: During our testing of time and effort records we noted that although timesheets were kept, they do not identify time spent working on different funding sources/cost objectives, so they were not used to calculate wages charged to the Federal awards tested. Instead, budgeted allocations were used, and the Organization could not support the allocation methodology(ies) applied to four out of the ten sampled employees. Criteria: According to 2 CFR Part 200.430(i)(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, not exceeding 100% of compensated activities (for IHE, this per the IHE's definition of IBS); (iv) Encompass federally-assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity (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. (viii) Budget estimates (i.e., 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 actually performed; C. FINDINGS AND QUESTIONED COSTS – MAJOR FEDERAL AWARD PROGRAMS AUDIT (Continued) Criteria (Concluded): (B) Significant changes in the corresponding work activity (as defined by the non-Federal entity's written policies) are identified and entered into the records in a timely manner. Short term (such as one or two months) fluctuation between workload categories need not be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The non-Federal entity's system of internal controls includes processes to review after-the-fact interim charges made to a Federal award based on budget estimates. All necessary adjustment must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Questioned Costs: Not determinable. Cause: The Organization did not document allocation methodology(ies) reflecting reasonable approximations of the activity actually performed for sampled employees in positions other than teachers and teaching assistants. Budget estimates were used for interim accounting purposes, however, there was no documented process to perform periodic after-the-fact reviews of interim charges nor adjustments made to ensure final amounts charged were properly allocated. Effect: Costs for salaries and wages were not fully supported by documentation in accordance with 2 CFR Part 200.430. Allowable costs could potentially be overpaid or underpaid or disallowed and required to be paid back to the Federal awarding agency (and/or pass-through entity). Recommendation: The Organization should strengthen policies and procedures to support a system of internal control which provides a reasonable assurance that the charges to Federal awards for salaries and wages are accurate, allowable, and properly allocated. This might include: 1. Enhance timesheet tracking to charge actual time spent working on different funding sources/cost objectives, or 2. Establishing a process to periodically review after-the-fact interim charges made to Federal awards based on budget estimates, make timely adjustments to ensure final amounts charged to Federal awards are accurate, allowable, and properly allocated, and document their reconciliation. Views of Responsible Officials and Planned Corrective Actions: Family Star acknowledges the FY24 finding related to labor allocation. During that fiscal year, the organization experienced several operational challenges, including insufficient documentation and oversight of labor allocation reporting. These administrative issues were contributing factors in a broader leadership restructuring, which included the elimination of five middle management positions. As a result, responsibilities for labor allocation were reassigned to ensure proper oversight. Since that time, Family Star has taken intentional steps to strengthen internal controls and improve the accuracy and consistency of key administrative functions. Labor time reporting is now aligned with organizational slot distribution across programs and funding sources to ensure compliance and transparency moving forward. To further reinforce accountability, we have implemented a new monthly monitoring procedure. On the first Wednesday of each month, the Senior Director of Community Partnerships and the HR Specialist jointly review and archive labor allocation records. This process ensures allocations are preserved, updates are made in a timely and compliant manner, and labor costs are supported by accurate documentation. These measures are designed to increase transparency, enhance internal controls, and ensure labor allocations are properly managed going forward.
2024-001 Compensation for Personal Services Head Start Cluster – Assistance Listing No. 93.600 Award Numbers: 08CH010736-06 – Award Period: December 1, 2023 through June 30, 2024 08CH012759-01 – Award Period: July 1, 2024 through November 30, 2024 MOEAI-202366770 – Award Period: July 1, 2023 through June 30, 2024 MOEAI-202474487 – Award Period: July 1, 2024 through June 30, 2025 Maternal, Infant and Early Childhood Home Visiting Grant – Assistance Listing No. 93.870 Award Numbers: CTGG1 QAAA 2024*2428 – Award Period: October 1, 2023 through September 30, 2024 CTGG1 QAAA 2025*2585 – Award Period: October 1, 2024 through September 30, 2025 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Condition: During our testing of time and effort records we noted that although timesheets were kept, they do not identify time spent working on different funding sources/cost objectives, so they were not used to calculate wages charged to the Federal awards tested. Instead, budgeted allocations were used, and the Organization could not support the allocation methodology(ies) applied to four out of the ten sampled employees. Criteria: According to 2 CFR Part 200.430(i)(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, not exceeding 100% of compensated activities (for IHE, this per the IHE's definition of IBS); (iv) Encompass federally-assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity (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. (viii) Budget estimates (i.e., 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 actually performed; C. FINDINGS AND QUESTIONED COSTS – MAJOR FEDERAL AWARD PROGRAMS AUDIT (Continued) Criteria (Concluded): (B) Significant changes in the corresponding work activity (as defined by the non-Federal entity's written policies) are identified and entered into the records in a timely manner. Short term (such as one or two months) fluctuation between workload categories need not be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The non-Federal entity's system of internal controls includes processes to review after-the-fact interim charges made to a Federal award based on budget estimates. All necessary adjustment must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Questioned Costs: Not determinable. Cause: The Organization did not document allocation methodology(ies) reflecting reasonable approximations of the activity actually performed for sampled employees in positions other than teachers and teaching assistants. Budget estimates were used for interim accounting purposes, however, there was no documented process to perform periodic after-the-fact reviews of interim charges nor adjustments made to ensure final amounts charged were properly allocated. Effect: Costs for salaries and wages were not fully supported by documentation in accordance with 2 CFR Part 200.430. Allowable costs could potentially be overpaid or underpaid or disallowed and required to be paid back to the Federal awarding agency (and/or pass-through entity). Recommendation: The Organization should strengthen policies and procedures to support a system of internal control which provides a reasonable assurance that the charges to Federal awards for salaries and wages are accurate, allowable, and properly allocated. This might include: 1. Enhance timesheet tracking to charge actual time spent working on different funding sources/cost objectives, or 2. Establishing a process to periodically review after-the-fact interim charges made to Federal awards based on budget estimates, make timely adjustments to ensure final amounts charged to Federal awards are accurate, allowable, and properly allocated, and document their reconciliation. Views of Responsible Officials and Planned Corrective Actions: Family Star acknowledges the FY24 finding related to labor allocation. During that fiscal year, the organization experienced several operational challenges, including insufficient documentation and oversight of labor allocation reporting. These administrative issues were contributing factors in a broader leadership restructuring, which included the elimination of five middle management positions. As a result, responsibilities for labor allocation were reassigned to ensure proper oversight. Since that time, Family Star has taken intentional steps to strengthen internal controls and improve the accuracy and consistency of key administrative functions. Labor time reporting is now aligned with organizational slot distribution across programs and funding sources to ensure compliance and transparency moving forward. To further reinforce accountability, we have implemented a new monthly monitoring procedure. On the first Wednesday of each month, the Senior Director of Community Partnerships and the HR Specialist jointly review and archive labor allocation records. This process ensures allocations are preserved, updates are made in a timely and compliant manner, and labor costs are supported by accurate documentation. These measures are designed to increase transparency, enhance internal controls, and ensure labor allocations are properly managed going forward.
2024-001 Compensation for Personal Services Head Start Cluster – Assistance Listing No. 93.600 Award Numbers: 08CH010736-06 – Award Period: December 1, 2023 through June 30, 2024 08CH012759-01 – Award Period: July 1, 2024 through November 30, 2024 MOEAI-202366770 – Award Period: July 1, 2023 through June 30, 2024 MOEAI-202474487 – Award Period: July 1, 2024 through June 30, 2025 Maternal, Infant and Early Childhood Home Visiting Grant – Assistance Listing No. 93.870 Award Numbers: CTGG1 QAAA 2024*2428 – Award Period: October 1, 2023 through September 30, 2024 CTGG1 QAAA 2025*2585 – Award Period: October 1, 2024 through September 30, 2025 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matters Condition: During our testing of time and effort records we noted that although timesheets were kept, they do not identify time spent working on different funding sources/cost objectives, so they were not used to calculate wages charged to the Federal awards tested. Instead, budgeted allocations were used, and the Organization could not support the allocation methodology(ies) applied to four out of the ten sampled employees. Criteria: According to 2 CFR Part 200.430(i)(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, not exceeding 100% of compensated activities (for IHE, this per the IHE's definition of IBS); (iv) Encompass federally-assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity (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. (viii) Budget estimates (i.e., 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 actually performed; C. FINDINGS AND QUESTIONED COSTS – MAJOR FEDERAL AWARD PROGRAMS AUDIT (Continued) Criteria (Concluded): (B) Significant changes in the corresponding work activity (as defined by the non-Federal entity's written policies) are identified and entered into the records in a timely manner. Short term (such as one or two months) fluctuation between workload categories need not be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The non-Federal entity's system of internal controls includes processes to review after-the-fact interim charges made to a Federal award based on budget estimates. All necessary adjustment must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Questioned Costs: Not determinable. Cause: The Organization did not document allocation methodology(ies) reflecting reasonable approximations of the activity actually performed for sampled employees in positions other than teachers and teaching assistants. Budget estimates were used for interim accounting purposes, however, there was no documented process to perform periodic after-the-fact reviews of interim charges nor adjustments made to ensure final amounts charged were properly allocated. Effect: Costs for salaries and wages were not fully supported by documentation in accordance with 2 CFR Part 200.430. Allowable costs could potentially be overpaid or underpaid or disallowed and required to be paid back to the Federal awarding agency (and/or pass-through entity). Recommendation: The Organization should strengthen policies and procedures to support a system of internal control which provides a reasonable assurance that the charges to Federal awards for salaries and wages are accurate, allowable, and properly allocated. This might include: 1. Enhance timesheet tracking to charge actual time spent working on different funding sources/cost objectives, or 2. Establishing a process to periodically review after-the-fact interim charges made to Federal awards based on budget estimates, make timely adjustments to ensure final amounts charged to Federal awards are accurate, allowable, and properly allocated, and document their reconciliation. Views of Responsible Officials and Planned Corrective Actions: Family Star acknowledges the FY24 finding related to labor allocation. During that fiscal year, the organization experienced several operational challenges, including insufficient documentation and oversight of labor allocation reporting. These administrative issues were contributing factors in a broader leadership restructuring, which included the elimination of five middle management positions. As a result, responsibilities for labor allocation were reassigned to ensure proper oversight. Since that time, Family Star has taken intentional steps to strengthen internal controls and improve the accuracy and consistency of key administrative functions. Labor time reporting is now aligned with organizational slot distribution across programs and funding sources to ensure compliance and transparency moving forward. To further reinforce accountability, we have implemented a new monthly monitoring procedure. On the first Wednesday of each month, the Senior Director of Community Partnerships and the HR Specialist jointly review and archive labor allocation records. This process ensures allocations are preserved, updates are made in a timely and compliant manner, and labor costs are supported by accurate documentation. These measures are designed to increase transparency, enhance internal controls, and ensure labor allocations are properly managed going forward.
Finding 2024.004: Activities Allowed or Unallowed - Significant Deficiency Grantor: U.S. Department of Health and Human Services Federal Program Names: Health Center Program Cluster, COVID-19 Health Center Program (Community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care), Grants for New and Expanded Services under the Health Center Program, COVID-19 Grants for New and Expanded Services under the Health Center Program. Federal Assistance Listing Numbers: 93.224 and 93.527 Federal Award Identification Number and Year: H80CS00132-2022 and 2023 Criteria According to 2 CFR, Part 200.430(i)(1) charges to Federal awards for salaries and wages must be based on records that accurately reflect the actual work performed, which must, among other things: (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) and reasonably reflect the total activity for which the employee is compensated by the non-Federal entity. Condition Charges to Federal Awards for salaries and wages were not supported by properly approved timesheets that agreed to payroll registers. Cause The Center's internal controls over payroll were not consistently followed. Effect or Potential Effect Unallowable expenses could be charged to the grant. Questioned Costs None. Context Out of the 25 payroll transactions selected for testing, we noted one instance in which the timesheet did not agree to the payroll register. Identification as a Repeat Finding Yes - Finding 2023.002. Recommendation We recommend that the Organization consistently enforce its internal controls over payroll to ensure that timesheets are reviewed and approved by the appropriate supervisor and ensure that they agree to the payroll register. Views of Responsible Officials and Planned Corrective Actions Management agrees with the audit finding and will implement additional controls to ensure payroll expenditures are being formally reviewed and approved.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-003: Allowable Costs/Cost Principles—Payroll Calculation Errors—Significant Deficiency in Controls over Compliance and Noncompliance Federal Program: Coronavirus State and Local Fiscal Recovery Funds—ALN 21.027 Year(s): 2024 Federal Agency: U.S. Department of Treasury Contract—DHA SA-01-22/A2 Pass-Through Entity: Sacramento County Criteria—In accordance with 2 CFR 200.430 (g)(1) and (g)(1)(i) charges to Federal awards for salaries and wages must be based on accurate records and calculations. Condition/Context—Out of 31 payroll selections, 6 selections had calculation errors. In the process of recording the payroll cost for the grant, spreadsheet related errors were made in transferring the general ledger data into the reimbursement requests which were then used to populate the schedule of federal awards of expenditures. Questions Costs—Under the reportable threshold, hence not applicable Cause—The control to review the recording of the payroll general ledger details into the reimbursement request was not precise enough to identify the calculation errors. Effect—Incorrect cost can be charged to the grant which can lead to the potential disallowance of costs. Recommendation—We recommend the Division implement a more detailed and precise review process to ensure the accuracy and completeness of the reimbursement request. Views of the Responsible Officials—See Corrective Action Plan
Federal Agency: Department of Health and Human Services Federal Program Name: Substance Abuse and Mental Health Services Projects of Regional and National Significance Assistance Listing Number: 93.243 Federal Award Identification Number and Year: 1H79SM087513-01 - 2024 Award Period: September 30, 2023 through September 29, 2027 Type of Finding: • Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: According to the grant agreement and 2 CFR 200.430(g), charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. In additions, according to 2 CFR 200.430(g)(1)(vii), budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that the system for establishing the estimates produces reasonable approximations of activity performed, significant changes in work activity are promptly identified and entered into the records, and the recipient’s system of internal controls includes processes to perform periodic after-the-fact reviews of interim charges made to a Federal awards based on budget estimates. All necessary adjustments must be made so that the final amount charges to the Federal award is accurate, allowable, and properly allocated. Condition: During our review of the grant expenditures, it was noted that budgeted amounts were charged to the grant instead of the actual costs incurred. This practice was observed in multiple instances, leading to discrepancies between the reported expenditures and the actual costs. Management did not review time and effort to make after-the-fact adjustments to the amounts charged to the grant. Questioned costs: None Context: The Organization had generally spent more than was funded for salaries and benefits under federal grants or would have expenses that would not be reimbursable under the program. Due to the actual salary amount expended exceeded the total grant budgeted amount, the Organization only charged the monthly budgeted amount instead of the actual amount expended. Cause: The incorrect charging of budgeted amounts instead of actual costs appears to be due to a lack of proper oversight and understanding of the grant requirements by the personnel responsible for financial reporting and grant management. Effect: Charging budgeted amounts instead of actual costs can result in non-compliance with grant requirements, potential disallowance of costs, and inaccurate financial reporting. This could also lead to financial penalties and affect the organization's ability to secure future funding. Recommendation: We recommend that the Organization establish a review process to ensure that all costs charged to the grant are based on actual expenditures and are properly documented. Views of responsible officials: There is no disagreement with the audit finding.
2024-001 – Child Support Services - Unallowable Costs Finding Type: Significant deficiency in internal controls and immaterial noncompliance Criteria: Per 2 CFR § 200.303 (Internal Controls), non-federal entities must establish and maintain effective internal controls over federal awards that provide reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of the award. Additionally, 2 CFR § 200.430 (Compensation—Personal Services) requires that payroll costs charged to federal awards must be based on records that accurately reflect the work performed and be supported by adequate documentation. Condition/Finding: During our audit of Manistee County’s Child Support Services federal grant expenditures, it was determined that the County lacked effectively operating controls to ensure that salary and wage expenses charged to the Child Support Services program were allowable and properly allocated. Cause: The County’s internal controls were not adequately designed or implemented to ensure compliance with federal grant requirements. Effect: As a result, the County received an overpayment of federal funds of $5,528.41 during FY 2024. Recommendation: We recommend that the County take actions to strengthen internal controls over payroll expenditures related to federal grants to ensure compliance with federal cost principles and proper expense allocation. View of Responsible Officials (Corrective Action): See corrective action plan.
2024-001 – Child Support Services - Unallowable Costs Finding Type: Significant deficiency in internal controls and immaterial noncompliance Criteria: Per 2 CFR § 200.303 (Internal Controls), non-federal entities must establish and maintain effective internal controls over federal awards that provide reasonable assurance of compliance with federal statutes, regulations, and the terms and conditions of the award. Additionally, 2 CFR § 200.430 (Compensation—Personal Services) requires that payroll costs charged to federal awards must be based on records that accurately reflect the work performed and be supported by adequate documentation. Condition/Finding: During our audit of Manistee County’s Child Support Services federal grant expenditures, it was determined that the County lacked effectively operating controls to ensure that salary and wage expenses charged to the Child Support Services program were allowable and properly allocated. Cause: The County’s internal controls were not adequately designed or implemented to ensure compliance with federal grant requirements. Effect: As a result, the County received an overpayment of federal funds of $5,528.41 during FY 2024. Recommendation: We recommend that the County take actions to strengthen internal controls over payroll expenditures related to federal grants to ensure compliance with federal cost principles and proper expense allocation. View of Responsible Officials (Corrective Action): See corrective action plan.
Finding 2024-002 – Allowable costs – payroll Assistance Listing #: 93.243 Criteria: In accordance with the Uniform Guidance’s compensation requirements (2 CFR 200.430), payroll systems must be based on records that accurately reflect the work performed and supported by a system of internal controls that provides reasonable assurances that charges are accurate; allowable and reasonable; and properly allocated. The Uniform Guidance allows for use of budget estimates on an interim basis. When using budget estimates on an interim basis, grantees must reconcile estimates against actual time or effort on a regular basis to ensure that estimates conform to actual staff activity. Grantees must make adjustments in the payroll distribution to align with actual time. Condition: During fiscal year 2024, the Organization charged payroll costs to the federal award programs using a set percentage based on budget and not based on employee’s actual time or effort amongst various programs. Cause: Management was made aware that using budget estimates was not allowed without further reconciliation against actual time or effort activities during the fiscal year 2022 audit which was completed in April 2024. Management has not yet implemented changes to its internal processes to address the identified issue. Effect: The salary costs charged to the federal programs may have been under or over reported based on the actual level of effort. Questioned Costs: N/A Repeat Finding: Yes Recommendation: We recommend the Organization make changes overall its timekeeping processes to ensure that payroll costs accurately reflect the work performed and if budget estimates are utilized, that they are reconciled and trued up on a consistent basis. Response: The Organization is acting upon different guidance it has received. As of the date this audit is released, the contract this finding addresses is currently scheduled to end on 08/30/2025. NFFCMH will continue our current practice through the end of the current contract, and will review any potential change to same with any renewal of this contract.
Finding 2024-002 – Allowable costs – payroll Assistance Listing #: 93.243 Criteria: In accordance with the Uniform Guidance’s compensation requirements (2 CFR 200.430), payroll systems must be based on records that accurately reflect the work performed and supported by a system of internal controls that provides reasonable assurances that charges are accurate; allowable and reasonable; and properly allocated. The Uniform Guidance allows for use of budget estimates on an interim basis. When using budget estimates on an interim basis, grantees must reconcile estimates against actual time or effort on a regular basis to ensure that estimates conform to actual staff activity. Grantees must make adjustments in the payroll distribution to align with actual time. Condition: During fiscal year 2024, the Organization charged payroll costs to the federal award programs using a set percentage based on budget and not based on employee’s actual time or effort amongst various programs. Cause: Management was made aware that using budget estimates was not allowed without further reconciliation against actual time or effort activities during the fiscal year 2022 audit which was completed in April 2024. Management has not yet implemented changes to its internal processes to address the identified issue. Effect: The salary costs charged to the federal programs may have been under or over reported based on the actual level of effort. Questioned Costs: N/A Repeat Finding: Yes Recommendation: We recommend the Organization make changes overall its timekeeping processes to ensure that payroll costs accurately reflect the work performed and if budget estimates are utilized, that they are reconciled and trued up on a consistent basis. Response: The Organization is acting upon different guidance it has received. As of the date this audit is released, the contract this finding addresses is currently scheduled to end on 08/30/2025. NFFCMH will continue our current practice through the end of the current contract, and will review any potential change to same with any renewal of this contract.
Finding Number: 2024-034 Prior Year Finding Number: N/A Compliance Requirement: Activities Allowed or Unallowed and Allowable Costs/Cost Principles Program: U.S. Department of Health and Human Services Block Grants for Substance Use Prevention, Treatment, and Recovery Services ALN: 93.959 Award #: Various Award Years: 10/01/2022 – 09/30/2024; 03/15/2021 – 03/14/2025 Government Department/Agency: Department of Behavioral Health (DBH) Criteria - The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 2 CFR Section 200.430 Compensation – Personal Services: “Costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the establish written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity’s laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable.” 2 CFR Section 200.430 (g): Standards for Documentation of Personnel Expenses. (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 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; (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; (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. (vii) 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. Condition – We noted that the DBH allocated payroll expenditures to the Block Grants for Substance Use Prevention, Treatment and Recovery Services (SUPTRS) during fiscal year 2024 based on budgeted percentages. These percentages were entered into the PeopleSoft Human Resources/Payroll System (PeopleSoft) at the beginning of the fiscal year and were based on management’s estimate of the respective employee’s level of effort for each program. PeopleSoft calculated the payroll costs every payroll cycle for each employee and program based on the predetermined percentage, and reported it through the Labor Distribution Report (485 Report). However, management cannot provide supporting documentation regarding the periodic comparison of actual costs to the budgeted costs as required by 2 CFR Section 200.430. Specifically, 17 out of 60 sampled payroll items tested for the SUPTRS program were recorded based on estimated hours and not actual hours. For the other 43 sampled items, these individuals worked 100% of their time on SUPTRS, therefore, there is no possibility of error. Questioned Costs – Known amount is $43,235. Context – This is a condition identified per review of DBH’s compliance with specified requirements using a statistically valid sample. Payroll costs, including fringe benefits, for the SUPTRS program in fiscal year 2024 totaled $4,667,478. Effect – DBH was unable to demonstrate that the payroll expenditures charged to the SUPTRS program accurately reflected the actual time incurred on the program and such expenditures were properly supported in accordance with 2 CFR Section 200.430, Compensation – Personal Services. Cause – DBH does not have policies and procedures in place to review and reconcile the estimated amount of payroll expenditures charged to the SUPTRS Program to the actual expenditures incurred. Recommendation – We recommend that DBH deploy policies and procedures to periodically compare employees’ estimated hours per the 485 Report to the actual hours incurred, and make any necessary adjustments as required by 2 CFR Section 200.430. Related Noncompliance – Material noncompliance. Views of Responsible Officials and Planned Corrective Actions – DBH agrees with the findings and will put controls in place to resolve the issue. The District’s corrective action is described in the Management’s Corrective Action Plan included as Appendix B of the attached Management’s Section.
Finding Number: 2024-034 Prior Year Finding Number: N/A Compliance Requirement: Activities Allowed or Unallowed and Allowable Costs/Cost Principles Program: U.S. Department of Health and Human Services Block Grants for Substance Use Prevention, Treatment, and Recovery Services ALN: 93.959 Award #: Various Award Years: 10/01/2022 – 09/30/2024; 03/15/2021 – 03/14/2025 Government Department/Agency: Department of Behavioral Health (DBH) Criteria - The Uniform Guidance in 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Per 2 CFR Section 200.430 Compensation – Personal Services: “Costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the establish written policy of the non-Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity’s laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, Standards for Documentation of Personnel Expenses, when applicable.” 2 CFR Section 200.430 (g): Standards for Documentation of Personnel Expenses. (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 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; (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; (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. (vii) 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. Condition – We noted that the DBH allocated payroll expenditures to the Block Grants for Substance Use Prevention, Treatment and Recovery Services (SUPTRS) during fiscal year 2024 based on budgeted percentages. These percentages were entered into the PeopleSoft Human Resources/Payroll System (PeopleSoft) at the beginning of the fiscal year and were based on management’s estimate of the respective employee’s level of effort for each program. PeopleSoft calculated the payroll costs every payroll cycle for each employee and program based on the predetermined percentage, and reported it through the Labor Distribution Report (485 Report). However, management cannot provide supporting documentation regarding the periodic comparison of actual costs to the budgeted costs as required by 2 CFR Section 200.430. Specifically, 17 out of 60 sampled payroll items tested for the SUPTRS program were recorded based on estimated hours and not actual hours. For the other 43 sampled items, these individuals worked 100% of their time on SUPTRS, therefore, there is no possibility of error. Questioned Costs – Known amount is $43,235. Context – This is a condition identified per review of DBH’s compliance with specified requirements using a statistically valid sample. Payroll costs, including fringe benefits, for the SUPTRS program in fiscal year 2024 totaled $4,667,478. Effect – DBH was unable to demonstrate that the payroll expenditures charged to the SUPTRS program accurately reflected the actual time incurred on the program and such expenditures were properly supported in accordance with 2 CFR Section 200.430, Compensation – Personal Services. Cause – DBH does not have policies and procedures in place to review and reconcile the estimated amount of payroll expenditures charged to the SUPTRS Program to the actual expenditures incurred. Recommendation – We recommend that DBH deploy policies and procedures to periodically compare employees’ estimated hours per the 485 Report to the actual hours incurred, and make any necessary adjustments as required by 2 CFR Section 200.430. Related Noncompliance – Material noncompliance. Views of Responsible Officials and Planned Corrective Actions – DBH agrees with the findings and will put controls in place to resolve the issue. The District’s corrective action is described in the Management’s Corrective Action Plan included as Appendix B of the attached Management’s Section.
Finding 2024-003: Unsupported Payroll Charges and Improper Drawdown of Federal Funds Compliance Requirements: Allowable Costs/Cost Principles; Cash Management; Reporting Type: Material Weakness in Internal Control over Compliance and Material Noncompliance Federal Agency: U.S. Department of Health and Human Services (Centers for Disease Control and Prevention) AL Numbers and Titles: 93.809 – National Organizations for Chronic Disease Prevention and Health Promotion Federal Award Number: NU58DP007562 Questioned Costs: $423,094 Repeat Finding: No Criteria: In accordance with 2 CFR §200.403 and §200.405, costs charged to a federal award must be necessary, reasonable, and allocable, and must conform to the terms and conditions of the award. Per 2 CFR §200.430(i), charges for salaries and wages must be supported by records that accurately reflect the work performed and be supported by a system of internal control. Furthermore, 2 CFR §200.305(b) requires that non-federal entities minimize the time between federal fund drawdown and disbursement, and limits advances to amounts needed for the immediate cash requirements of the program. Condition: During our testing of payroll-related transactions charged to the 93.809 federal program, we identified a significant reallocation of personnel costs from unrestricted funds to the federal grant that occurred late in the audit period. These charges related to multiple employees whose compensation was not included in the originally approved budget for the federal program. At the time of our testing, no formal budget revision had been submitted to the awarding agency, and the names of these staff had not been recorded in the federal grant reporting system as required by the award terms. Additionally, the auditee was unable to provide any documentation, such as certifications, labor distribution reports, calendars, or other records, to support that these employees worked on activities allocable to the federal program. We further noted that the auditee drew down federal funds prior to the recording of these payroll charges, at a time when the costs in question had neither been incurred nor documented. This resulted in federal funds being drawn in advance of need, contrary to federal cash management requirements. Cause: The auditee did not have adequate internal controls to ensure that only appropriately budgeted and documented payroll costs were charged to the federal award. In addition, the organization lacked procedures to confirm that federal funds were drawn only for costs that were allowable, incurred, and supported at the time of drawdown. These weaknesses allowed significant payroll reallocations to be processed retroactively without timely budget amendments or sufficient documentation of allocability. Effect: As a result of these control deficiencies, a total of $423,094 in personnel-related costs, including direct salaries, fringe benefits, and associated indirect costs, was charged to the federal program without appropriate budget authorization or time and effort support. These unsupported costs were also used as the basis for a drawdown of federal funds that occurred before the expenditures were recorded or substantiated. This resulted in noncompliance with both cost principles and cash management requirements and exposes the auditee to potential disallowance or repayment of federal funds. Recommendation: We recommend that the auditee enhance internal controls related to grant budgeting, payroll allocations, and cash management. These controls should ensure that payroll costs charged to federal awards are included in the approved budget or are formally revised and submitted to the grantor, are supported by accurate time and effort documentation, and that federal funds are drawn only when actual, allowable costs have been incurred and documented. We further recommend that the auditee consult with the awarding agency to determine whether any retroactive budget revision or corrective action is available or whether repayment of questioned costs will be required. Views of Responsible Officials Corrective Actions: Management agrees with this finding. Please refer to the Corrective Action Plan.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.
Finding 2024-001 (Considered a significant deficiency in control compliance for allowable costs and activities) Federal Agency: United Stated Department of Health and Human Services Assistance Listing Numbers: 93.558, 17.258, 17.259, 17.278 Criteria: The Code of Federal Regulations (CFR), particularly 2 CFR § 200.430 (Compensation - Personal Services), requires that charges to federal awards for personnel costs must be based on accurate timekeeping records, and that those records should be properly mapped and reviewed to ensure costs are correctly allocated. Federal award recipients must have sufficient internal controls in place to ensure accurate billing to grants and proper review of payroll data, including verifying the proper mapping of timesheets to funding sources. Condition: For 2 out of 25 transactions for Temporary Assistance for Needy Families and 1 out of 25 transactions for Work Innovation and Opportunity Act Cluster, time reported by a sample of employees on their timesheets for work performed on the grant was not accurately mapped when imported into the payroll system. Specifically, the timesheets showed the amount of time employees spent working on the federal grant, but when this data was entered into the payroll system for processing, it was incorrectly allocated across other funding sources. Cause: The misallocation of time was caused by a failure in the internal controls related to the mapping process between timesheets and the payroll system. Specifically, the integration process between the timesheet reporting system and the payroll system did not correctly map time worked on federal grants to the appropriate funding sources. This error was not identified by the Organization's internal review controls. Effect: As a result of the mapping error, the Organization charged excess costs to the federal grant, leading to overbilling for labor costs. Questioned Costs: Known - $173. Recommendation: The Organization should review and adjust the mapping process between timesheet data and the payroll system to ensure that time worked on the federal grant is properly allocated. This may include updating software interfaces or implementing manual checks to ensure correct mapping. Management's View: The Organization concurs with the facts of this finding and is implementing procedures to prevent this in the future.