Federal Program: ALN 93.575 Child Care and Development Block Grant (CCDBG) Category: Compliance Compliance requirements: Allowable costs Record retention Condition: The BGCPR did not maintain sufficient documentation to demonstrate compliance with employee background check requirements. Criteria: Pursuant to 2 CFR §200.430(a)(2), compensation costs are allowable when appointments are made in accordance with the recipient's written policies and procedures. Further, 2 CFR §200.303(a) requires recipients to establish and maintain effective internal controls to ensure compliance with applicable requirements. Additionally, 2 CFR §200.403(g) requires costs charged to Federal awards to be adequately documented. Moreover, pursuant to 2 CFR §200.334, recipients and subrecipients must retain all Federal award records, including financial records, supporting documentation, and statistical records, for a minimum of three years from the date of submission of the final financial report. If litigation, claims, or audit findings are initiated before the expiration of the retention period, the records must be retained until all such matters are resolved and final action has been taken. Per the BGCPR Human Resources Policies and Procedures Manual, specifically the Required Certifications and Background Check Policy, all employees and leaders must maintain current required certifications and documentation, including Criminal Record Certificate, Health Certificate, Law 300 Certificate, Educational Credentials, and Fingerprint Verification, and must successfully complete applicable background checks before perform their duties. Failure to comply with these requirements may result in restrictions from performing job responsibilities and may affect continued employment. Context: We found that two (2) of the four (4) sample employees lacked documentation, evidencing compliance with BGCPR's required background check procedures. Cause: For two (2) payroll-related items, the personnel files did not contain evidence demonstrating that required background checks had been completed in accordance with the BGCPR's hiring policies. For one employee, the background check was performed after the employee's recruitment date. For the second employee, the required background check documentation was not available in the personnel file at the time of the audit. Although management subsequently provided the documentation after the exception was identified, the evidence indicated that the background check report was printed in July 2026. Accordingly, the personnel files did not contain sufficient documentation to support compliance with the BGCPR's background check requirements during the audited period. Questioned cost: Amount is below the threshold to be considered a questioned cost. Effect or potential effect: As a result, BGCPR could not demonstrate that the employees were hired in accordance with established hiring requirements or that compensation costs charged to the Federal award were supported by adequate documentation. Recommendation: Ensure personnel records are complete, accurate, and maintained in accordance with established policies and procedures Views of officials responsible: BGCPR will provide additional training and guidance to Human Resources personnel to ensure consistent adherence to the internal procedures established. Anticipated completion date: September 30, 2026
FA 2025-001 Strengthen Controls over Expenditures Compliance Requirements: Activities Allowed or Unallowed Allowable Costs/Cost Principles Internal Control Impact: Material Weakness Compliance Impact: Material Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Number and Title: 84.010 – Title I Grants to Local Educational Agencies Federal Award Numbers: S010A240010 (Year: 2025), S010A230010 (Year: 2024) Questioned Costs: $127,026 Repeat of Prior Year Findings: FA 2024-001, FA 2023-001, FA 2022-001 Description: The policies and procedures of the School District were insufficient to provide adequate internal controls over expenditures as it related to the Title I Grants to Local Educational Agencies program. Background Information: The Title I Grants to Local Educational Agencies (Title I) program is authorized under the Elementary and Secondary Education Act of 1965 to help local educational agencies (LEAs) improve teaching and learning in highpoverty schools in particular for children failing or most at-risk of failing, to meet challenging state academic standards. LEAs may operate targeted assistance programs in which children who are failing or most at-risk of failing may be served or schoolwide programs in which all children in eligible schools may be served. Title I funding is granted to the Georgia Department of Education (GaDOE) by the U.S. Department of Education (ED), and GaDOE is responsible for distributing funds to LEAs and overseeing the expenditure of funds by LEAs. Title I funds totaling $621,294 were expended and reported on the Talbot County Board of Education’s Schedule of Expenditures of Federal Awards (SEFA) for fiscal year 2025. Criteria: As a recipient of federal awards, the School District is required to establish, document, and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 – Internal Controls. Additionally, provisions included in the Uniform Guidance, Section 200.403 – Factors Affecting Allowability of Costs state that “costs must meet the following criteria to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. (c) Be consistent with policies and procedures that apply uniformly to both federally financed and other activities of the recipient or subrecipient… (g) Be adequately documented…” Furthermore, provisions included in the Uniform Guidance, Section 200.430 – Compensation-Personal Services prescribe standards for documentation of personnel expenses and state, in part, that “(a) …Costs for compensation are allowable to the extent that they satisfy… specific requirements…, and that the total compensation for individual employees: (1) is reasonable for the services rendered and conforms to the established 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)…, [as follows:] (i) 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…” Condition: A sample of ten nonpersonal expenditures was randomly selected for testing using a nonstatistical sampling approach. These expenditures were reviewed to determine if appropriate internal controls were implemented and applicable compliance requirements were met. The following deficiencies were noted: • For three expenditures, evidence of review and approval was not reflected within the voucher package totaling $3,597. • For one expenditure, the amount recorded on the general ledger did not agree to supporting documentation resulting in a difference of $112. In addition, a sample of eleven employees was randomly selected for testing using a nonstatistical sampling approach. These employees were reviewed to determine if appropriate internal controls were implemented and applicable compliance requirements were met. The following deficiencies were noted: • For two employees, supporting documentation could not be provided to support payments totaling $126,674. • For one employee, the amount paid did not agree to the supporting documentation provided and resulted in an overpayment of $240. Questioned Costs: Upon testing a sample of $16,775 in nonpersonal services expenditures, known questioned costs of $112 were identified for expenditures not supported by adequate documentation. Using the total nonpersonal services expenditures population of $101,353, we project the likely questioned costs to be approximately $678. Upon testing a sample of $136,554 in personal services expenditures, known questioned costs of $126,914 were identified for expenditures not supported by adequate documentation. Using the total personal services expenditures population of $356,564, we project the likely questioned costs to be approximately $331,393. Cause: In discussing the deficiencies with the School District, they believe that these items are primarily due to improper documentation retention and oversight of approval processes. Effect: The School District was not in compliance with the Uniform Guidance and GaDOE guidance. Failure to ensure that expenditures and employee compensation payments associated with the Title I program are made for the appropriate amount and supported by appropriate documentation could result in the expenditure of funds for unallowable purposes. This may also expose the School District to unnecessary financial strains and shortages within the Title I program fund as GaDOE may require the School District to return funds associated with improperly documented expenditures. Recommendation: The School District should evaluate their internal control processes regarding the retention of documentation to support expenditures and employee compensation payments. Where vulnerable, the School District should develop and/or modify its policies and procedures to ensure that expenditures are appropriately documented and to ensure that Title I program employees are paid appropriately. Furthermore, management should develop and implement a monitoring process to ensure that these procedures are functioning properly. Views of Responsible Officials: We concur with this finding.
FA 2025-002 Strengthen Controls over Expenditures Compliance Requirements: Activities Allowed or Unallowed Allowable Costs/Cost Principles Internal Control Impact: Material Weakness Compliance Impact: Material Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Number and Title: COVID-19 – 84.425U – American Rescue Plan Elementary and Secondary School Emergency Relief Fund Federal Award Number: S425U210012 (Year: 2024) Questioned Costs: $20,040 Repeat of Prior Year Findings: FA 2024-002, FA 2023-002, FA 2022-002 Description: A review of expenditures charged to the Elementary and Secondary School Emergency Relief Fund Program revealed that the School District’s internal control procedures were not operating to ensure that expenditures were appropriately documented to support allowability. Background Information: On March 27, 2020, the Coronavirus Aid, Relief, and Economic Security (CARES) Act was signed into law. The CARES Act was designed to mitigate the economic effects of the COVID-19 pandemic in a variety of ways, including providing additional funding for local educational agencies (LEAs) navigating the impact of the COVID- 19 outbreak. Provisions included in Title VIII of the CARES Act created the Education Stabilization Fund to provide financial resources to educational entities to prevent, prepare for, and respond to the coronavirus. The CARES Act allocated $30.75 billion, the Coronavirus Response and Relief Supplemental Appropriations Act allocated an additional $81.9 billion, and the American Rescue Plan Act added $165.1 billion in funding to the Education Stabilization Fund. Multiple Education Stabilization Fund subprograms were created and allotted funding through the various COVID-19-related legislation. Of these programs, the Elementary and Secondary School Emergency Relief (ESSER) Fund was created to address the impact that COVID-19 has had, and continues to have, on elementary and secondary schools across the nation. ESSER funding was granted to the Georgia Department of Education (GaDOE) by the U.S. Department of Education (ED). GaDOE is responsible for distributing funds to LEAs and overseeing the expenditure of funds by LEAs. ESSER funds totaling $1,052,459 were expended and reported on the Talbot County School District’s Schedule of Expenditures of Federal Awards (SEFA) for fiscal year 2025. Criteria: As a recipient of federal awards, the School District is required to establish, document, and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 – Internal Controls. Provisions included in the Uniform Guidance, Section 200.403 – Factors Affecting Allowability of Costs state that “costs must meet the following criteria to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. (c) Be consistent with policies and procedures that apply uniformly to both federally financed and other activities of the recipient or subrecipient… (g) Be adequately documented…” Furthermore, provisions included in the Uniform Guidance, Section 200.430 – Compensation–Personal Services prescribe standards for documentation of personnel expenses and state, in part, that “(a) … Costs for compensation are allowable to the extent that they satisfy… specific requirements… and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the recipient or subrecipient consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a recipient’s or subrecipient’s laws, rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (g)…, [as follows:] (g) 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…” Condition: All journal entries and general ledger adjustments impacting program expenditures were selected for testing. The following deficiencies were noted: • For one of the four items tested, appropriate evidence of review and approval was not maintained. • Sufficient supporting documentation was not provided for one journal entry posted to reverse expenditure activity. • For one journal entry used to record expenditures totaling $7,046 in the ESSER fund, sufficient supporting documentation could not be provided to determine the allowability of $889 of the expenditures moved to the program. In addition, a sample of eight employees was randomly selected for testing using a nonstatistical sampling approach. These employees were reviewed to determine if appropriate internal controls were implemented and applicable compliance requirements met. The following deficiencies were noted: • Evidence of properly designed and implemented controls over personal services expenditures could not be provided. • For seven employees, supporting documentation was not maintained to support salaries totaling $19,151. Questioned Costs: Upon testing a sample of $31,426 in personal services expenditures, known questioned costs of $19,151 were identified for expenditures not supported by adequate documentation. Using the total personal services expenditures population of $121,406, we project the likely questioned costs to be approximately $73,985. In addition, known questioned costs of $889 were identified for expenditures not supported by adequate journal entry documentation and were not tested as part of a sample; therefore, there are no related projected questioned costs. Cause: In discussing these deficiencies with the School District, they believe these issues are due to improper documentation retention and the need for updated policies and procedures. Effect: The School District was not in compliance with the Uniform Guidance and GaDOE guidance. Failure to ensure that documentation exists to support the allowability of payments from the ESSER program could result in the expenditure of funds for unallowable purposes. This may also expose the School District to unnecessary financial strains and shortages within the ESSER program fund as GaDOE may require the School District to return funds associated with improperly documented expenditures. Recommendation: The School District should evaluate their current internal control processes related to ESSER program expenditures. Where vulnerable, the School District should develop and/or modify its policies and procedures to ensure that all expenditures reflect evidence of review and approval and are supported by appropriate documentation. Furthermore, management should develop and implement a monitoring process to ensure that these procedures are functioning properly.
Significant Deficiency 2025-001. Allowed Costs/Cost Principle United States Department of Education, Passed Through New York State, Department of Education: Special Education Cluster Special Education Grants to States: IDEA Part B ALN: 84.027 Special Education Preschool Grants: IDEA Preschool ALN: 84.173 Criteria: Salaries and wages charged to federal awards must be supported by documentation prescribed by the Uniform Guidance at Subpart E, 2 CFR §200.430. Condition: Subpart E, 2 CFR §200.430 of the Uniform Guidance requires that charges to “Federal awards for salaries and wages must be based on records that accurately reflect the work performed.” The documentation should support the distribution of the employee’s compensation among specific activities if the employee works on more than one federal award, or a federal award and non-federal award. The preparation of personnel activity reports (PAR) or periodic certifications or the equivalent is the most effective way to comply with this requirement. During the current year, the District did not prepare this documentation, and, therefore, did not comply with Subpart E, 2 CFR §200.430. Cause: The staff that were responsible for maintaining records that accurately reflect the work performed, as described in Subpart E, 2 CFR §200.430, to support salaries charged to federal awards, did not prepare PARs or certification reports related to work being completed. Effect: Noncompliance could result in the incorrect amount for services rendered being charged to the federal award. Questioned Costs: Dollar amount undetermined as adequate documentation was not available. Context: The District maintains time records for employees charged to federal awards in accordance with approved budgets, and determined that individuals assigned to provide services meet the criteria necessary in accordance with the grant requirements. Identification of a Repeat Finding: This is a repeat finding from the previous audit, item No. 2024-001 related to the Special Education Cluster. Recommendation: The District should revise its procedures to prepare documentation to support actual salaries and wages charged to federal awards after the work was performed in accordance with the requirements of the Uniform Guidance at Subpart E, 2 CFR §200.430. Views of Responsible Officials of Auditee: The District will adopt procedures to ensure appropriate documentation will be prepared to comply with Subpart E, 2 CFR §200.430.
Type of Finding: Significant Deficiency in Compliance and Internal Control over Compliance Federal Agency: Department of Housing and Urban Development; Department of Veterans Affairs Federal Program Name: Emergency Solutions Grant Program; Veterans Affairs Supportive Services for Veteran Families Program Assistance Listing Number: 14.231; 64.033 Federal Award Identification Number and Year: 14.231: HCS-24-31-2401-007, HCS-23-32-2301-007, HCS-24-32-2401-007, SC-111170, CW2254906, CW2259491, SC-111171 64.033: 20-WA-146 - 10/1/23-9/30/26, 2020-WA-146-LT - 8/19/22-9/30/26 Pass-Through Agency: 14.231: Snohomish County Office of Housing, Homelessness & County Development, City of Tacoma, Pierce County Human Services 64.033: N/A – Direct Pass-Through Number(s): 14.231: HCS-24-31-2401-007, HCS-23-32-2301-007, HCS-24-32-2401-007, SC-111170, SC-111171, CW2259491, CW2254906 64.033: N/A – Direct Award Period: 14.231: July 1, 2024 – June 30, 2025; October 1, 2023 – September 30, 2024; October 1, 2024 – September 30, 2025; November 1, 2022 – December 31, 2024; July 1, 2024 – June 30, 2026 64.033: October 1, 2023 – September 30, 2026; August 19, 2022 – September 30, 2026 Criteria or specific requirement: 2 CFR 200.430(g)(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." Condition: 14.231: 2 of 40 payroll expenditures tested was not subject to the timely use of internal control process that reasonably assures that the payroll charges were accurate, allowable, and properly allocated. For 64.033, there was 2 of 40 payroll expenditures tested that lacked appropriate and timely review. In total, there were 4/80 payroll transactions that lacked adequate documentation of the key control. Questioned costs: None Context: 14.231: During testing of payroll disbursements CLA noted that one employee's timecard was not approved by a manager for one pay period in September 2024. The internal control was eventually performed in November 2024, 44 days after CLA would expect to see management review & approval of the employees’ timecard. A second employee's timecard showed timecard review but not approval. 64.033: During testing of payroll disbursements CLA noted that 2 samples had timecards that were not subject to timely review & approval (lack of internal control). Cause: The lack of timely approval appears to have occurred due to an oversight by the person responsible for performing the internal control. Additionally, there was no internal process for ensuring that the internal control was performed by a different employee if the original employee responsible for performing the control separated from the entity. Upon separation of a manager who is responsible for performing this control, a temporary manager with sufficient knowledge of the employee's work, programs worked, and program requirements should be assigned to perform the control to ensure compliance with allowable costs and accurate billing of payroll expenses. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2024-002 Recommendation: CLA recommends implementing a process that ensures the control is performed timely by an alternative employee with sufficient understanding of the program requirements to accurately review and approve cost allocations that meet documented time and effort spent on each program. This will include ensuring an appropriate timesheet reviewer is assigned, and that an appropriate back-up reviewer is available. Views of responsible officials: There is no disagreement with the audit finding.
Federal programs Research and Development Cluster – National Institutes of Health – Drug Abuse and Addiction Research Programs AL #: 93.279 Award Year: 2024/2025 Type of finding Significant Deficiency and Noncompliance Compliance requirement Activities Allowed or Unallowed and Allowable Costs/Cost Principles Criteria Under 2 CFR section 200.430(i), costs of compensation for personal services are allowable to the extent the total compensation for individual employees is reasonable for the services rendered and conforms to the established written policies and practices, follows an appointment made in accordance with non-federal entities rules and written policies, and is determined and supported as provided in 2 CFR section 200.430(i), including that charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. Condition We noted one out of forty judgmentally selected payroll transactions included cost for an employee that did not relate to services performed in relation to the grant. Questioned costs $625 Context A portion of an employee’s benefits was improperly charged to the grant. Cause When the University changed their timekeeping platform an academic affairs employees’ compensation was improperly set up in the system which incorrectly allocated their vacation time to this grant. Effect The employee’s vacation time that occurred after the change in the University’s timekeeping platform in March 2025 until the discovery after year end was incorrectly included as compensation and benefits expense within the grant. Repeat finding No Recommendations We recommend that the University ensure controls are in place to adequately review all benefits pay charged to grants to ensure appropriate. View of responsible officials To safeguard from future errors and ensure data accuracy, Human Resources partnered with Enterprise Application Services department to develop an automated process that populates earnings codes and project account codes based on employee, job record and earnings code. This enhancement streamlines data entry by consolidating it into a single interface, reducing the risk of manual entry errors. Additionally, the HR Technology Manager has implemented a new monitoring report to track employees with multiple salary distribution accounts as a part of payroll process. The biweekly report will be automatically generated and sent via email to HR’s HRIS Consultants for review. The HRIS Consultants will analyze the report, resolve any discrepancies and escalate any issues to the HR Technology Manager or Lead Application Consultant as necessary. These processes will be routinely reviewed, with adjustments made as needed.
Item 2025-005 - Activities Allowed and Unallowed Costs - U.S. Department of Health and Human Services, Health Center Program Cluster (Assistance Listing Number 93.224/93.527) Notice of Award Number 6 H80CS00505-23-04, 6 H2ECS45602-02-04, 1 H8LCS50772-01-00 and 6 H8HCS46163-03-01 - (Material Weakness) Criteria: Per 2 CFR §200.430(i) - Standards for Documentation of Personnel Expenses, charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated, reflect actual time worked on specific federal programs and be incorporated into the official records of the non-federal entity. Statement of Condition: During our audit, we noted that LBUCC charged salaries to the Section 330 grant based on pre-determined allocations or budget rather than actual hours worked. LBUCC utilized timesheets that reflect the allocations as its time and effort documentation. Cause: LBUCC has not implemented a time and effort reporting system that captures actual hours worked on federal programs. Effect: Failure to maintain and monitor time and effort based on actual hours worked may lead to disallowed costs. Questioned Costs: None. Although salaries charged were based on allocations or budget, we determined that only one employee was charged to two grant-funded programs during one pay period. All other employees’ salaries were charged to one grant-funded program for each pay period during the year. For the employee whose salary was charged to more than one grant-funded program, we verified that the total of the employee’s salaries charged to each grant-funded program did not exceed 100% of her total salaries for the pay period. Context: LBUCC’s management meets monthly to discuss if the budgeted or allocated salaries per program for the month was reflective of actual hours worked. During this discussion, management ascertains if there is a need to adjust the budgeted or allocated salaries. However, this discussion and the approval of the final budget or salaries is not documented. Identification as a Repeat Finding: This is not a repeat finding. Recommendation: We recommend that LBUCC implement a time and effort reporting system that tracks actual hours worked on each program or grant. We recommend that they require supervisors to review and approve the actual time spent on grant activities and that such review and approval be documented. Management Response: Management agrees with the finding and will implement these steps to ensure compliance with the federal cost principles, strengthen internal controls, and reduce the risk of questioned costs.
2025-001: U.S. Department of Health and Human Services, National Institutes for Health Research and Development Cluster, Cancer Control, Assistance Listing #93.399; Lack of Required Written Policies Condition Montana Cancer Consortium (the Consortium) does not have written policies and procedures in place as required by 2 CFR § 200.302 and § 200.313. Specifically, the Consortium lacks documented policies for: • The timing of federal cash draws; • The allowability of costs charged to federal awards; and • Documentation of time-and-effort for personal services. Criteria 2 CFR § 200.302(b)(6)–(7) requires nonfederal entities to have written procedures for: (a) cash drawdowns and (b) determining cost allowability. § 200.305 requires written cash-management procedures that minimize the time between draw and disbursement. § 200.430 requires a written policy that is consistently applied to both federal and nonfederal activities for documentation of compensation for personal services. Context At the time of completion of the audit for the year ended May 31, 2025, the written policies were not in place. We noted that the policies were implemented on December 1, 2025, which was after the fiscal year under audit had ended. Cause The Consortium has not yet developed or adopted the required written policies due to limited administrative capacity and reliance on informal practices. Effect The absence of written policies increases the risk of noncompliance with federal requirements, mismanagement of federal funds, and audit findings in future periods. It may also impair the Consortium’s ability to consistently apply federal cost principles and properly safeguard assets. Recommendation We recommend that the Consortium develop and implement written policies and procedures that comply with the requirements of Uniform Guidance. Management Response See Corrective Action Plan.
Finding 2025-008 – Allowable Costs/Cost Principles and Matching, Level of Effort, and Earmarking Information on the federal program: Federal awarding agency: United States Department of Education (ED) Federal program: School Safely National Activities, Assistance Listing No. 84.184X Award year: 2024‐2025 Criteria or specific requirement (including statutory, regulatory or other citation): 2 CFR 200.303 requires that a non-federal entity must (a) establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States and the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). 2 CFR 200.430 (i) states “Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflected the work performed. These records must: (i) be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) be incorporated into the official records of the non-Federal entity; (iii) reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) encompass both federal assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; (v) comply with the established accounting policies and practices of the non-Federal entity.” Condition: The University did not have effective internal controls over the timely preparation and approval of employees’ time and effort certifications. Cause: The University did not execute their internal controls for the timely preparation and approval of employees’ time and effort certifications on a timely basis. Effect or potential effect: Unallowable and/or inaccurate payroll expenditures could be charged to the federal program due to the delay in the preparation and approval of the time and effort certifications. Level of effort per grant award notification and grant proposal documents may not be met as required for the applicable employees with level of effort requirements, the program director/principal investigator and co-investigators, for the School Safely National Activities Program. Questioned costs: None. Context: It is the University’s policy to have time and effort certifications prepared and approved for grant employees on a semesterly basis. For 9 of 14 payroll expenditures selected for testing, the University’s employees prepared their time and effort certifications between 4 and 10 months after the applicable semester ended, with approvals made after that time. The grant documents provide for level of effort requirements for the program for five employees, including the program director/principal investigator with a level of effort of 25% and 4 co-investigators with level of effort of 2.5%. The University’s total School Safely National Activities program expenditures were $1,310,305 for the year ended May 31, 2025. Of this amount, $209,270 related to payroll expenditures, including fringe benefits. Identification of a repeat finding: Not applicable. Recommendation: We recommend the University execute its internal controls to provide for the preparation and approval of employees’ time and effort certifications on a timely basis after the end of each semester. Views of responsible officials: Management agrees with the finding and has developed a corrective action plan in which the University updated the time and effort reporting form and the Grants Accounting Office will ensure the forms are completed timely. The corrective action was implemented by February 6, 2026.
. Finding 2025-004 (Material Weakness) Program: Coronavirus State and Local Fiscal Recovery Funds Federal Agency: United States Department of Treasury AL #: 21.027 Federal Award Identification Number and Year: Various – See SEFA Pass-through Entity: N/A Type of Compliance Finding: A) Activities Allowed or Unallowed and B) Allowable Costs/Cost Principles Criteria Recipients may use SLFRF payments for any eligible expenses subject to the restrictions set forth in sections 602 / 603 of the Social Security Act as added by section 9901 of the American Rescue Plan Act of 2021, codified at 42 USC sections 802 and 803, and as amended by the 2023 CAA. Per 2 CFR 200.430(g)(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 and (vi) support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one federal award. Condition Management did not provide sufficient evidence to support the charges for salaries and wages for five of the seven employee samples who work solely on one cost objective or multiple cost objectives. Cause Management does not have controls and processes in place to ensure that required documentation is maintained to support federal award charges for salaries and wages. Effect Unallowable salary expenses were charged to the federal award, which could result in the City not receiving federal assistance or repayment of grant funds. Questioned Costs $11,480 Context The total salaries and wages were $1,036,364 and likely questioned costs are $252,797. Is the finding a repeat finding No Recommendations We recommend management establish a process to ensure required documentation is maintained to support federal award salaries and wages. Views of Responsible Officials/ Planned Corrective Actions Management agrees with the finding. See Corrective Action Plan on Organization’s letterhead.
2025-002 - Lack of Written Federal Program Policies. Type: Material Weakness. Condition: The Village does not have documented policies and procedures specific to the administration of the Coronavirus State and Local Fiscal Recovery Funds program. This includes the absence of written guidance on key compliance areas such as payments, procurement, allowability of costs charged to federal programs, compensation, and travel costs under Uniform Guidance. Criteria: Per 2 CFR 200.303 and 200.331 of the Uniform Guidance, non-federal entities are required to establish and maintain effective internal controls and written policies to ensure compliance with federal statutes, regulations, and the terms and conditions of federal awards. These policies should be tailored to the specific requirements of each federal program. Cause: The entity has not developed formal written policies and procedures for the Coronavirus State and Local Fiscal Recovery Funds program, possibly due to reliance on informal practices or general administrative policies that do not address federal-specific requirements. Effect: Without documented policies, there is an increased risk of noncompliance with federal requirements, inconsistent program administration, and lack of accountability. This may result in questioned costs, audit findings, or potential repayment of federal funds. Recommendation: We recommend that the Village develop and implement written policies and procedures specific to the Coronavirus State and Local Fiscal Recovery Funds program. These should include: - Payments in accordance with §200.302 (6), - Procurement in accordance with §200.318, - Allowability of costs charged to federal programs in accordance with §200.302 (7), - Compensation in accordance with §200.430 and §200.431, - Travel costs in accordance with §200.474. Training should also be provided to staff responsible for administering the program to ensure consistent application of these policies. Views of Responsible Officials: Management acknowledges the auditor’s finding regarding the absence of formally documented federal program policies. We recognize the importance of maintaining written procedures to ensure consistent compliance with Uniform Guidance requirements and to strengthen internal controls over federal awards. While informal practices have historically guided our federal program administration, we agree that formalizing these policies will enhance transparency, accountability, and operational efficiency. Management is currently in the process of developing written policies covering key areas such as procurement, allowable costs, subrecipient monitoring, and cash management. We anticipate completing this documentation and implementing the policies by February 28, 2026. We are committed to continuous improvement and appreciate the auditor’s recommendations as part of our efforts to maintain strong compliance and stewardship of federal funds.
2 CFR §2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR §200.303(a) which states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).Furthermore, 2 CFR §200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. The “City of Columbus Fiscal Policies and Procedures for the Administration of HUD Grants Manual” Part II Section C – Standards for Documentation of Personal Services provides the following: All grant funded staff (both city staff and subrecipient staff) will utilize personal activity reports (timesheets). All timesheets will reflect total hours worked, identify the federal grant hours worked, and be signed by either the employee or the supervisor. Furthermore, the City of Columbus Department of Development has established a procedure of timesheet review which requires supervisors review employee timesheets within one week of the pay period end date. This review is evidenced by an electronic signature on the employee-completed timesheet.While the City does have an internal control policy in place in accordance with 2 CFR 430(i)(1)(i), supervisors were not always adhering to the policy which resulted in a deficiency in the application of the control process. During payroll control testing over AL #14.239 Home Investment Partnership Program, it was noted 3 out of the 5 selected worklogs (60%) were not signed by the supervisor within the one-week requirement as required by City policy. Supervisory sign offs occurred between 12 and 32 working days (not including weekends) following the end of the pay period.Failure to follow the established internal control policy and ensuring all time sheets are appropriately approved by a knowledgeable supervisor, within one week of the pay period end date, could result in unallowable costs being allocated to a federal program and could ultimately result in noncompliance and/or a questioned cost. The City should review established policies and procedures with supervisory personnel and evaluate if additional control procedures should be in place to ensure all timesheets are appropriately reviewed timely prior to allocation to a federal program.
2 CFR §2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR §200.303(a) which states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).Furthermore, 2 CFR §200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. The “City of Columbus Fiscal Policies and Procedures for the Administration of HUD Grants Manual” Part II Section C – Standards for Documentation of Personal Services provides the following: All grant funded staff (both city staff and subrecipient staff) will utilize personal activity reports (timesheets). All timesheets will reflect total hours worked, identify the federal grant hours worked, and be signed by either the employee or the supervisor. Furthermore, the City of Columbus Department of Development has established a procedure of timesheet review which requires supervisors review employee timesheets within one week of the pay period end date. This review is evidenced by an electronic signature on the employee-completed timesheet.While the City does have an internal control policy in place in accordance with 2 CFR 430(i)(1)(i), supervisors were not always adhering to the policy which resulted in a deficiency in the application of the control process. During payroll control testing over AL #14.239 Home Investment Partnership Program, it was noted 3 out of the 5 selected worklogs (60%) were not signed by the supervisor within the one-week requirement as required by City policy. Supervisory sign offs occurred between 12 and 32 working days (not including weekends) following the end of the pay period.Failure to follow the established internal control policy and ensuring all time sheets are appropriately approved by a knowledgeable supervisor, within one week of the pay period end date, could result in unallowable costs being allocated to a federal program and could ultimately result in noncompliance and/or a questioned cost. The City should review established policies and procedures with supervisory personnel and evaluate if additional control procedures should be in place to ensure all timesheets are appropriately reviewed timely prior to allocation to a federal program.
2 CFR §2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR §200.303(a) which states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).Furthermore, 2 CFR §200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. The “City of Columbus Fiscal Policies and Procedures for the Administration of HUD Grants Manual” Part II Section C – Standards for Documentation of Personal Services provides the following: All grant funded staff (both city staff and subrecipient staff) will utilize personal activity reports (timesheets). All timesheets will reflect total hours worked, identify the federal grant hours worked, and be signed by either the employee or the supervisor. Furthermore, the City of Columbus Department of Development has established a procedure of timesheet review which requires supervisors review employee timesheets within one week of the pay period end date. This review is evidenced by an electronic signature on the employee-completed timesheet.While the City does have an internal control policy in place in accordance with 2 CFR 430(i)(1)(i), supervisors were not always adhering to the policy which resulted in a deficiency in the application of the control process. During payroll control testing over AL #14.239 Home Investment Partnership Program, it was noted 3 out of the 5 selected worklogs (60%) were not signed by the supervisor within the one-week requirement as required by City policy. Supervisory sign offs occurred between 12 and 32 working days (not including weekends) following the end of the pay period.Failure to follow the established internal control policy and ensuring all time sheets are appropriately approved by a knowledgeable supervisor, within one week of the pay period end date, could result in unallowable costs being allocated to a federal program and could ultimately result in noncompliance and/or a questioned cost. The City should review established policies and procedures with supervisory personnel and evaluate if additional control procedures should be in place to ensure all timesheets are appropriately reviewed timely prior to allocation to a federal program.
2 CFR §2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR §200.303(a) which states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).Furthermore, 2 CFR §200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. The “City of Columbus Fiscal Policies and Procedures for the Administration of HUD Grants Manual” Part II Section C – Standards for Documentation of Personal Services provides the following: All grant funded staff (both city staff and subrecipient staff) will utilize personal activity reports (timesheets). All timesheets will reflect total hours worked, identify the federal grant hours worked, and be signed by either the employee or the supervisor. Furthermore, the City of Columbus Department of Development has established a procedure of timesheet review which requires supervisors review employee timesheets within one week of the pay period end date. This review is evidenced by an electronic signature on the employee-completed timesheet.While the City does have an internal control policy in place in accordance with 2 CFR 430(i)(1)(i), supervisors were not always adhering to the policy which resulted in a deficiency in the application of the control process. During payroll control testing over AL #14.239 Home Investment Partnership Program, it was noted 3 out of the 5 selected worklogs (60%) were not signed by the supervisor within the one-week requirement as required by City policy. Supervisory sign offs occurred between 12 and 32 working days (not including weekends) following the end of the pay period.Failure to follow the established internal control policy and ensuring all time sheets are appropriately approved by a knowledgeable supervisor, within one week of the pay period end date, could result in unallowable costs being allocated to a federal program and could ultimately result in noncompliance and/or a questioned cost. The City should review established policies and procedures with supervisory personnel and evaluate if additional control procedures should be in place to ensure all timesheets are appropriately reviewed timely prior to allocation to a federal program.
2 CFR §2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR §200.303(a) which states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).Furthermore, 2 CFR §200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. The “City of Columbus Fiscal Policies and Procedures for the Administration of HUD Grants Manual” Part II Section C – Standards for Documentation of Personal Services provides the following: All grant funded staff (both city staff and subrecipient staff) will utilize personal activity reports (timesheets). All timesheets will reflect total hours worked, identify the federal grant hours worked, and be signed by either the employee or the supervisor. Furthermore, the City of Columbus Department of Development has established a procedure of timesheet review which requires supervisors review employee timesheets within one week of the pay period end date. This review is evidenced by an electronic signature on the employee-completed timesheet.While the City does have an internal control policy in place in accordance with 2 CFR 430(i)(1)(i), supervisors were not always adhering to the policy which resulted in a deficiency in the application of the control process. During payroll control testing over AL #14.239 Home Investment Partnership Program, it was noted 3 out of the 5 selected worklogs (60%) were not signed by the supervisor within the one-week requirement as required by City policy. Supervisory sign offs occurred between 12 and 32 working days (not including weekends) following the end of the pay period.Failure to follow the established internal control policy and ensuring all time sheets are appropriately approved by a knowledgeable supervisor, within one week of the pay period end date, could result in unallowable costs being allocated to a federal program and could ultimately result in noncompliance and/or a questioned cost. The City should review established policies and procedures with supervisory personnel and evaluate if additional control procedures should be in place to ensure all timesheets are appropriately reviewed timely prior to allocation to a federal program.
2 CFR §2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR §200.303(a) which states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).Furthermore, 2 CFR §200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. The “City of Columbus Fiscal Policies and Procedures for the Administration of HUD Grants Manual” Part II Section C – Standards for Documentation of Personal Services provides the following: All grant funded staff (both city staff and subrecipient staff) will utilize personal activity reports (timesheets). All timesheets will reflect total hours worked, identify the federal grant hours worked, and be signed by either the employee or the supervisor. Furthermore, the City of Columbus Department of Development has established a procedure of timesheet review which requires supervisors review employee timesheets within one week of the pay period end date. This review is evidenced by an electronic signature on the employee-completed timesheet.While the City does have an internal control policy in place in accordance with 2 CFR 430(i)(1)(i), supervisors were not always adhering to the policy which resulted in a deficiency in the application of the control process. During payroll control testing over AL #14.239 Home Investment Partnership Program, it was noted 3 out of the 5 selected worklogs (60%) were not signed by the supervisor within the one-week requirement as required by City policy. Supervisory sign offs occurred between 12 and 32 working days (not including weekends) following the end of the pay period.Failure to follow the established internal control policy and ensuring all time sheets are appropriately approved by a knowledgeable supervisor, within one week of the pay period end date, could result in unallowable costs being allocated to a federal program and could ultimately result in noncompliance and/or a questioned cost. The City should review established policies and procedures with supervisory personnel and evaluate if additional control procedures should be in place to ensure all timesheets are appropriately reviewed timely prior to allocation to a federal program.
2 CFR §2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR §200.303(a) which states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).Furthermore, 2 CFR §200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. The “City of Columbus Fiscal Policies and Procedures for the Administration of HUD Grants Manual” Part II Section C – Standards for Documentation of Personal Services provides the following: All grant funded staff (both city staff and subrecipient staff) will utilize personal activity reports (timesheets). All timesheets will reflect total hours worked, identify the federal grant hours worked, and be signed by either the employee or the supervisor. Furthermore, the City of Columbus Department of Development has established a procedure of timesheet review which requires supervisors review employee timesheets within one week of the pay period end date. This review is evidenced by an electronic signature on the employee-completed timesheet.While the City does have an internal control policy in place in accordance with 2 CFR 430(i)(1)(i), supervisors were not always adhering to the policy which resulted in a deficiency in the application of the control process. During payroll control testing over AL #14.239 Home Investment Partnership Program, it was noted 3 out of the 5 selected worklogs (60%) were not signed by the supervisor within the one-week requirement as required by City policy. Supervisory sign offs occurred between 12 and 32 working days (not including weekends) following the end of the pay period.Failure to follow the established internal control policy and ensuring all time sheets are appropriately approved by a knowledgeable supervisor, within one week of the pay period end date, could result in unallowable costs being allocated to a federal program and could ultimately result in noncompliance and/or a questioned cost. The City should review established policies and procedures with supervisory personnel and evaluate if additional control procedures should be in place to ensure all timesheets are appropriately reviewed timely prior to allocation to a federal program.
2 CFR §2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR §200.303(a) which states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).Furthermore, 2 CFR §200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. The “City of Columbus Fiscal Policies and Procedures for the Administration of HUD Grants Manual” Part II Section C – Standards for Documentation of Personal Services provides the following: All grant funded staff (both city staff and subrecipient staff) will utilize personal activity reports (timesheets). All timesheets will reflect total hours worked, identify the federal grant hours worked, and be signed by either the employee or the supervisor. Furthermore, the City of Columbus Department of Development has established a procedure of timesheet review which requires supervisors review employee timesheets within one week of the pay period end date. This review is evidenced by an electronic signature on the employee-completed timesheet.While the City does have an internal control policy in place in accordance with 2 CFR 430(i)(1)(i), supervisors were not always adhering to the policy which resulted in a deficiency in the application of the control process. During payroll control testing over AL #14.239 Home Investment Partnership Program, it was noted 3 out of the 5 selected worklogs (60%) were not signed by the supervisor within the one-week requirement as required by City policy. Supervisory sign offs occurred between 12 and 32 working days (not including weekends) following the end of the pay period.Failure to follow the established internal control policy and ensuring all time sheets are appropriately approved by a knowledgeable supervisor, within one week of the pay period end date, could result in unallowable costs being allocated to a federal program and could ultimately result in noncompliance and/or a questioned cost. The City should review established policies and procedures with supervisory personnel and evaluate if additional control procedures should be in place to ensure all timesheets are appropriately reviewed timely prior to allocation to a federal program.
2 CFR §2400.101 gives regulatory effect to the Department of Housing and Urban Development for 2 CFR §200.303(a) which states that the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).Furthermore, 2 CFR §200.430(i)(1)(i) states "charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. The “City of Columbus Fiscal Policies and Procedures for the Administration of HUD Grants Manual” Part II Section C – Standards for Documentation of Personal Services provides the following: All grant funded staff (both city staff and subrecipient staff) will utilize personal activity reports (timesheets). All timesheets will reflect total hours worked, identify the federal grant hours worked, and be signed by either the employee or the supervisor. Furthermore, the City of Columbus Department of Development has established a procedure of timesheet review which requires supervisors review employee timesheets within one week of the pay period end date. This review is evidenced by an electronic signature on the employee-completed timesheet.While the City does have an internal control policy in place in accordance with 2 CFR 430(i)(1)(i), supervisors were not always adhering to the policy which resulted in a deficiency in the application of the control process. During payroll control testing over AL #14.239 Home Investment Partnership Program, it was noted 3 out of the 5 selected worklogs (60%) were not signed by the supervisor within the one-week requirement as required by City policy. Supervisory sign offs occurred between 12 and 32 working days (not including weekends) following the end of the pay period.Failure to follow the established internal control policy and ensuring all time sheets are appropriately approved by a knowledgeable supervisor, within one week of the pay period end date, could result in unallowable costs being allocated to a federal program and could ultimately result in noncompliance and/or a questioned cost. The City should review established policies and procedures with supervisory personnel and evaluate if additional control procedures should be in place to ensure all timesheets are appropriately reviewed timely prior to allocation to a federal program.
Criteria or Specific Requirement: Federal regulations (45 CFR 1635.4(a) and 2 CFR 200.430), state that federal award recipients must base allocations of salaries and wages costs to grants on records that accurately reflect the work performed. Federal regulations (45 CFR 1630.5 and 2 CFR 200.403) state that expenditures are allowable under an LSC (or federal) grant or contract only if the recipient can demonstrate that the cost was consistent with accounting policies and procedures that apply uniformly to both LSC (or, federal)-funded and non-LSC (of, federal) -funded activities. Condition: During our testing we noted: Payroll transactions: Eleven instances of errors totaling a net amount of $2,009 (an absolute value amount of $2,009) where the incorrect percentages were utilized in the allocation of the employee's pay, the incorrect employee's time was used in the allocation of the employee's pay, or there were unsupported amounts added to the allocation of the employee’s pay, and Payroll transactions: Seven instances of errors totaling a net amount of $109 (an absolute value amount of $4,405) where an unsupported allocation percentage was used to allocate the employee's pay to the grant - typically, employee salaries are allocated to LSC and two other private grants using an allocation base of a LSC cost driver for the period divided by the total cost driver coded to the Organization’s general fund. Fringe-benefit transactions: Two instances of an error totaling $91 where an unsupported allocation percentage was used to allocate employer-paid employee insurance costs to the grant - typically, costs are allocated to LSC and two other private grants using an allocation base of a LSC cost driver for the period divided by the total cost driver coded to the Organization’s general fund. Fringe-benefit transactions: Two instances of errors totaling $275 where employer-paid employee insurance and HSA contribution deductions per the employee's pay stub were allocated to the grant at a rate of 100%. Non-payroll and fringe transactions: one instance of an error totaling $884 where an unsupported allocation percentage was used to allocate general costs to the grant - typically, costs are allocated to LSC and two other private grants using an allocation base of a LSC cost driver for the period divided by the total cost driver coded to the Organization’s general fund. Additionally, we noted inconsistency in the general fund (LSC and two other private grants) allocation basis used during the year - grant hours and projected revenue were both utilized at different times during the year. Additionally, we noted that allocations in the general fund are done using projected revenue. However as revenue was recognized as expenses were incurred for the general fund the allocation based on revenue approximated an allocation method based on costs. As such, the costs mentioned above were allocated in an inconsistent manner to other grant costs and were not fully representative of the employees’ time and effort. However, we noted a lower frequency of differences in sample selections that occurred during the last several months of the year after management implemented a change to its allocation processes in response to the prior year audit. 2024 – 002: Cost Allocation of Expenses to LSC Grants (Continued) Questioned Costs: A net amount of $3,150 of allocated salary expense described above, which is related to Assistance Listing Number 09.706060. Context: These 23 instances were noting during testing of 55 disbursements. Cause: The Organization’s cost allocation methodology is primarily based on time and effort records, and periodic calculations of a LSC cost driver for the period divided by the total cost driver coded to the Organization’s general fund, but it often includes manual adjustments based on review of individual time records, expense and other data. Therefore, the methodology is challenging to apply consistently, document contemporaneously, and apply in accordance with federal regulations. Effect: The inclusion of frequent manual adjustments in the Organization’s cost allocation methodology could cause costs to be allocated to grants that are not reflective of the time and effort spent on grant activities and in a manner where costs are not applied uniformly to both LSC (or, federally)-funded and non-LSC (of, federally) -funded activities. Repeat Finding: The finding is a repeat of findings in the immediately prior year. The prior year finding numbers were 2023-003 and 2023-004. Recommendation: We recommend that the Organization consider updating its cost allocation methodology and process to reduce the frequency of manual adjustments based on review of individual time records and expense data and maximize the use of automated allocations that are calculated in a consistent manner that ensure costs are applied uniformly to respective benefited activities, and that are reflective on employees’ time and effort records Views of responsible officials: Management partially agrees with this finding. First, 45 CFR Part 1635 codifies the timekeeping requirement. CLS keeps track of every case and time dedicated by staff in strict compliance with this requirement. Additionally, the distribution of expenses in the general fund, which includes LSC and two other funding sources, represents a fair method and allocation. Regarding the questioned costs, CLS disagrees with the finding of material weakness given the extremely low total dollar value. Auditor’s Concluding Remarks: Management’s response did not persuade the auditor to revise the finding. Federal regulations state that expenditures are allowable under an LSC (or federal) grant or contract only if the recipient can demonstrate that the cost was consistent with accounting policies and procedures that apply uniformly to both LSC (or, federal)-funded and non-LSC (of, federal) -funded activities.
Criteria or Specific Requirement: Federal regulations (45 CFR 1635.4(a) and 2 CFR 200.430), state that federal award recipients must base allocations of salaries and wages costs to grants on records that accurately reflect the work performed. Federal regulations (45 CFR 1630.5 and 2 CFR 200.403) state that expenditures are allowable under an LSC (or federal) grant or contract only if the recipient can demonstrate that the cost was consistent with accounting policies and procedures that apply uniformly to both LSC (or, federal)-funded and non-LSC (of, federal) -funded activities. Condition: During our testing we noted: Payroll transactions: Eleven instances of errors totaling a net amount of $2,009 (an absolute value amount of $2,009) where the incorrect percentages were utilized in the allocation of the employee's pay, the incorrect employee's time was used in the allocation of the employee's pay, or there were unsupported amounts added to the allocation of the employee’s pay, and Payroll transactions: Seven instances of errors totaling a net amount of $109 (an absolute value amount of $4,405) where an unsupported allocation percentage was used to allocate the employee's pay to the grant - typically, employee salaries are allocated to LSC and two other private grants using an allocation base of a LSC cost driver for the period divided by the total cost driver coded to the Organization’s general fund. Fringe-benefit transactions: Two instances of an error totaling $91 where an unsupported allocation percentage was used to allocate employer-paid employee insurance costs to the grant - typically, costs are allocated to LSC and two other private grants using an allocation base of a LSC cost driver for the period divided by the total cost driver coded to the Organization’s general fund. Fringe-benefit transactions: Two instances of errors totaling $275 where employer-paid employee insurance and HSA contribution deductions per the employee's pay stub were allocated to the grant at a rate of 100%. Non-payroll and fringe transactions: one instance of an error totaling $884 where an unsupported allocation percentage was used to allocate general costs to the grant - typically, costs are allocated to LSC and two other private grants using an allocation base of a LSC cost driver for the period divided by the total cost driver coded to the Organization’s general fund. Additionally, we noted inconsistency in the general fund (LSC and two other private grants) allocation basis used during the year - grant hours and projected revenue were both utilized at different times during the year. Additionally, we noted that allocations in the general fund are done using projected revenue. However as revenue was recognized as expenses were incurred for the general fund the allocation based on revenue approximated an allocation method based on costs. As such, the costs mentioned above were allocated in an inconsistent manner to other grant costs and were not fully representative of the employees’ time and effort. However, we noted a lower frequency of differences in sample selections that occurred during the last several months of the year after management implemented a change to its allocation processes in response to the prior year audit. 2024 – 002: Cost Allocation of Expenses to LSC Grants (Continued) Questioned Costs: A net amount of $3,150 of allocated salary expense described above, which is related to Assistance Listing Number 09.706060. Context: These 23 instances were noting during testing of 55 disbursements. Cause: The Organization’s cost allocation methodology is primarily based on time and effort records, and periodic calculations of a LSC cost driver for the period divided by the total cost driver coded to the Organization’s general fund, but it often includes manual adjustments based on review of individual time records, expense and other data. Therefore, the methodology is challenging to apply consistently, document contemporaneously, and apply in accordance with federal regulations. Effect: The inclusion of frequent manual adjustments in the Organization’s cost allocation methodology could cause costs to be allocated to grants that are not reflective of the time and effort spent on grant activities and in a manner where costs are not applied uniformly to both LSC (or, federally)-funded and non-LSC (of, federally) -funded activities. Repeat Finding: The finding is a repeat of findings in the immediately prior year. The prior year finding numbers were 2023-003 and 2023-004. Recommendation: We recommend that the Organization consider updating its cost allocation methodology and process to reduce the frequency of manual adjustments based on review of individual time records and expense data and maximize the use of automated allocations that are calculated in a consistent manner that ensure costs are applied uniformly to respective benefited activities, and that are reflective on employees’ time and effort records Views of responsible officials: Management partially agrees with this finding. First, 45 CFR Part 1635 codifies the timekeeping requirement. CLS keeps track of every case and time dedicated by staff in strict compliance with this requirement. Additionally, the distribution of expenses in the general fund, which includes LSC and two other funding sources, represents a fair method and allocation. Regarding the questioned costs, CLS disagrees with the finding of material weakness given the extremely low total dollar value. Auditor’s Concluding Remarks: Management’s response did not persuade the auditor to revise the finding. Federal regulations state that expenditures are allowable under an LSC (or federal) grant or contract only if the recipient can demonstrate that the cost was consistent with accounting policies and procedures that apply uniformly to both LSC (or, federal)-funded and non-LSC (of, federal) -funded activities.
Criteria or Specific Requirement: Federal regulations (45 CFR 1635.4(a) and 2 CFR 200.430), state that federal award recipients must base allocations of salaries and wages costs to grants on records that accurately reflect the work performed. Federal regulations (45 CFR 1630.5 and 2 CFR 200.403) state that expenditures are allowable under an LSC (or federal) grant or contract only if the recipient can demonstrate that the cost was consistent with accounting policies and procedures that apply uniformly to both LSC (or, federal)-funded and non-LSC (of, federal) -funded activities. Condition: During our testing we noted: Payroll transactions: Eleven instances of errors totaling a net amount of $2,009 (an absolute value amount of $2,009) where the incorrect percentages were utilized in the allocation of the employee's pay, the incorrect employee's time was used in the allocation of the employee's pay, or there were unsupported amounts added to the allocation of the employee’s pay, and Payroll transactions: Seven instances of errors totaling a net amount of $109 (an absolute value amount of $4,405) where an unsupported allocation percentage was used to allocate the employee's pay to the grant - typically, employee salaries are allocated to LSC and two other private grants using an allocation base of a LSC cost driver for the period divided by the total cost driver coded to the Organization’s general fund. Fringe-benefit transactions: Two instances of an error totaling $91 where an unsupported allocation percentage was used to allocate employer-paid employee insurance costs to the grant - typically, costs are allocated to LSC and two other private grants using an allocation base of a LSC cost driver for the period divided by the total cost driver coded to the Organization’s general fund. Fringe-benefit transactions: Two instances of errors totaling $275 where employer-paid employee insurance and HSA contribution deductions per the employee's pay stub were allocated to the grant at a rate of 100%. Non-payroll and fringe transactions: one instance of an error totaling $884 where an unsupported allocation percentage was used to allocate general costs to the grant - typically, costs are allocated to LSC and two other private grants using an allocation base of a LSC cost driver for the period divided by the total cost driver coded to the Organization’s general fund. Additionally, we noted inconsistency in the general fund (LSC and two other private grants) allocation basis used during the year - grant hours and projected revenue were both utilized at different times during the year. Additionally, we noted that allocations in the general fund are done using projected revenue. However as revenue was recognized as expenses were incurred for the general fund the allocation based on revenue approximated an allocation method based on costs. As such, the costs mentioned above were allocated in an inconsistent manner to other grant costs and were not fully representative of the employees’ time and effort. However, we noted a lower frequency of differences in sample selections that occurred during the last several months of the year after management implemented a change to its allocation processes in response to the prior year audit. 2024 – 002: Cost Allocation of Expenses to LSC Grants (Continued) Questioned Costs: A net amount of $3,150 of allocated salary expense described above, which is related to Assistance Listing Number 09.706060. Context: These 23 instances were noting during testing of 55 disbursements. Cause: The Organization’s cost allocation methodology is primarily based on time and effort records, and periodic calculations of a LSC cost driver for the period divided by the total cost driver coded to the Organization’s general fund, but it often includes manual adjustments based on review of individual time records, expense and other data. Therefore, the methodology is challenging to apply consistently, document contemporaneously, and apply in accordance with federal regulations. Effect: The inclusion of frequent manual adjustments in the Organization’s cost allocation methodology could cause costs to be allocated to grants that are not reflective of the time and effort spent on grant activities and in a manner where costs are not applied uniformly to both LSC (or, federally)-funded and non-LSC (of, federally) -funded activities. Repeat Finding: The finding is a repeat of findings in the immediately prior year. The prior year finding numbers were 2023-003 and 2023-004. Recommendation: We recommend that the Organization consider updating its cost allocation methodology and process to reduce the frequency of manual adjustments based on review of individual time records and expense data and maximize the use of automated allocations that are calculated in a consistent manner that ensure costs are applied uniformly to respective benefited activities, and that are reflective on employees’ time and effort records Views of responsible officials: Management partially agrees with this finding. First, 45 CFR Part 1635 codifies the timekeeping requirement. CLS keeps track of every case and time dedicated by staff in strict compliance with this requirement. Additionally, the distribution of expenses in the general fund, which includes LSC and two other funding sources, represents a fair method and allocation. Regarding the questioned costs, CLS disagrees with the finding of material weakness given the extremely low total dollar value. Auditor’s Concluding Remarks: Management’s response did not persuade the auditor to revise the finding. Federal regulations state that expenditures are allowable under an LSC (or federal) grant or contract only if the recipient can demonstrate that the cost was consistent with accounting policies and procedures that apply uniformly to both LSC (or, federal)-funded and non-LSC (of, federal) -funded activities.
Significant deficiency in internal control over compliance and noncompliance related to allowable costs/cost principles compliance requirements. Federal Agency: U.S. Department of Treasury Pass-Through Entity: City and County of Denver Program Title: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Award Number: 202474319 Criteria Nonfederal entities must follow the standards for documentation of personnel expenses set out at 2 CFR section 200.430(i). Under those standards, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. Additionally, those standards require that the records a) reasonably reflect the total activity for which the employee is compensated by the nonfederal entity, not exceeding 100% of compensated activities; b) support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one federal award; a federal award and nonfederal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity; and c) budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards. Budget estimates may be used for interim account 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 and Context The Organization maintains a timekeeping and payroll system for charges to federal awards that documents approved wage and salary rates, time and effort certification, hours, and actual amounts paid to employees. The Organization is allocating payroll costs to federal programs for individual employees using budget estimates of time and effort on different activities. The Organization maintains after-the-fact review documentation of time spent for each employee to support the allocation in the form of “Time and Effort” certifications that are signed by all employees and supervisors to verify actual time spent on major program. During our testing we noted two pay-periods for one employee where the Organization did not maintain the “Time and Effort” certification. Section III - Reportable Findings and Questioned Costs for Federal Awards Cause The Organization’s management noted that the missing certifications were due to the employee leaving employment before the certifications were completed for the two pay periods. The Organization did not have a process in place to ensure alternate certification documentation was created and retained in the situation of terminated employees. Effect The effect is that the Organization is not in compliance with the requirements of 2 CFR section 200.430(i) for the two pay periods for this employee. For two pay-periods for one employee the payroll costs charged to the major program were not supported by documentation of after-the-fact review evidencing that those costs reasonably reflect the work actually performed on the activity. Questioned Costs The expenditures for the two pay periods for the one employee totaled of $8,846. Repeat Finding This is not a repeat finding. Recommendation We recommend management update its internal control process for employees who depart or are unable to certify their timesheets to ensure all time spent on federal programs is certified by employees and their supervisors. Views of Responsible Official and Corrective Action Plan Management agrees with the finding and has provided the accompanying corrective action plan.
Finding 2024-002 Payroll Information on the Federal Programs: 93.421 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Per 2 CFR 200.430(i) of the Uniform Guidance, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must support the distribution of employees’ salaries among specific activities or cost objectives as required. Condition: During our review of payroll charges to Federal awards, we noted that BCHC did not use timesheets from January 2024 to August 2024 and recorded salaries based on budgeted allocations. In August 2024, timesheets were implemented but we noted that the time recorded in the general ledger did not coincide with the allocation on the actual timesheets. Cause: BCHC relied on predetermined budget estimates for payroll allocation rather than using timesheets that reflected actual hours worked. Effect or Potential Effect: There is a risk that payroll costs charged to Federal programs may not accurately represent the true level of effort, potentially resulting in unallowable costs being charged to Federal awards. Questioned Costs: Indeterminate-The questioned costs relate to salary and wage expenditures charged to Federal programs without the required time and effort documentation in accordance with 2 CFR §200.430. Specifically, employees whose compensation was allocated to Federal awards did not maintain timesheets or equivalent records reflecting actual time worked on specific Federal activities. Due to the absence of these records, we were unable to determine the portion of personnel costs that may be unallowable under Uniform Guidance. Accordingly, the questioned costs are considered indeterminate. Context: We sampled 40 payroll transactions. All transactions were based on budgeted amounts. This issue was observed across all departments receiving Federal funds. Identification as a Repeat Finding, if Applicable: Not applicable Recommendation: While BCHC now maintains timesheets, we recommend ensuring that payroll costs charged to Federal awards are based on the actual time recorded, rather than budgeted estimates. The timesheet data should be used to support allocations in accordance with Uniform Guidance, and adjustments should be made as needed to reflect the actual effort expended on Federal programs.
Finding 2024-002 Payroll Information on the Federal Programs: 93.421 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Per 2 CFR 200.430(i) of the Uniform Guidance, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must support the distribution of employees’ salaries among specific activities or cost objectives as required. Condition: During our review of payroll charges to Federal awards, we noted that BCHC did not use timesheets from January 2024 to August 2024 and recorded salaries based on budgeted allocations. In August 2024, timesheets were implemented but we noted that the time recorded in the general ledger did not coincide with the allocation on the actual timesheets. Cause: BCHC relied on predetermined budget estimates for payroll allocation rather than using timesheets that reflected actual hours worked. Effect or Potential Effect: There is a risk that payroll costs charged to Federal programs may not accurately represent the true level of effort, potentially resulting in unallowable costs being charged to Federal awards. Questioned Costs: Indeterminate-The questioned costs relate to salary and wage expenditures charged to Federal programs without the required time and effort documentation in accordance with 2 CFR §200.430. Specifically, employees whose compensation was allocated to Federal awards did not maintain timesheets or equivalent records reflecting actual time worked on specific Federal activities. Due to the absence of these records, we were unable to determine the portion of personnel costs that may be unallowable under Uniform Guidance. Accordingly, the questioned costs are considered indeterminate. Context: We sampled 40 payroll transactions. All transactions were based on budgeted amounts. This issue was observed across all departments receiving Federal funds. Identification as a Repeat Finding, if Applicable: Not applicable Recommendation: While BCHC now maintains timesheets, we recommend ensuring that payroll costs charged to Federal awards are based on the actual time recorded, rather than budgeted estimates. The timesheet data should be used to support allocations in accordance with Uniform Guidance, and adjustments should be made as needed to reflect the actual effort expended on Federal programs.
Finding 2024-002 Payroll Information on the Federal Programs: 93.421 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Per 2 CFR 200.430(i) of the Uniform Guidance, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must support the distribution of employees’ salaries among specific activities or cost objectives as required. Condition: During our review of payroll charges to Federal awards, we noted that BCHC did not use timesheets from January 2024 to August 2024 and recorded salaries based on budgeted allocations. In August 2024, timesheets were implemented but we noted that the time recorded in the general ledger did not coincide with the allocation on the actual timesheets. Cause: BCHC relied on predetermined budget estimates for payroll allocation rather than using timesheets that reflected actual hours worked. Effect or Potential Effect: There is a risk that payroll costs charged to Federal programs may not accurately represent the true level of effort, potentially resulting in unallowable costs being charged to Federal awards. Questioned Costs: Indeterminate-The questioned costs relate to salary and wage expenditures charged to Federal programs without the required time and effort documentation in accordance with 2 CFR §200.430. Specifically, employees whose compensation was allocated to Federal awards did not maintain timesheets or equivalent records reflecting actual time worked on specific Federal activities. Due to the absence of these records, we were unable to determine the portion of personnel costs that may be unallowable under Uniform Guidance. Accordingly, the questioned costs are considered indeterminate. Context: We sampled 40 payroll transactions. All transactions were based on budgeted amounts. This issue was observed across all departments receiving Federal funds. Identification as a Repeat Finding, if Applicable: Not applicable Recommendation: While BCHC now maintains timesheets, we recommend ensuring that payroll costs charged to Federal awards are based on the actual time recorded, rather than budgeted estimates. The timesheet data should be used to support allocations in accordance with Uniform Guidance, and adjustments should be made as needed to reflect the actual effort expended on Federal programs.
Finding 2024-002 Payroll Information on the Federal Programs: 93.421 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Per 2 CFR 200.430(i) of the Uniform Guidance, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must support the distribution of employees’ salaries among specific activities or cost objectives as required. Condition: During our review of payroll charges to Federal awards, we noted that BCHC did not use timesheets from January 2024 to August 2024 and recorded salaries based on budgeted allocations. In August 2024, timesheets were implemented but we noted that the time recorded in the general ledger did not coincide with the allocation on the actual timesheets. Cause: BCHC relied on predetermined budget estimates for payroll allocation rather than using timesheets that reflected actual hours worked. Effect or Potential Effect: There is a risk that payroll costs charged to Federal programs may not accurately represent the true level of effort, potentially resulting in unallowable costs being charged to Federal awards. Questioned Costs: Indeterminate-The questioned costs relate to salary and wage expenditures charged to Federal programs without the required time and effort documentation in accordance with 2 CFR §200.430. Specifically, employees whose compensation was allocated to Federal awards did not maintain timesheets or equivalent records reflecting actual time worked on specific Federal activities. Due to the absence of these records, we were unable to determine the portion of personnel costs that may be unallowable under Uniform Guidance. Accordingly, the questioned costs are considered indeterminate. Context: We sampled 40 payroll transactions. All transactions were based on budgeted amounts. This issue was observed across all departments receiving Federal funds. Identification as a Repeat Finding, if Applicable: Not applicable Recommendation: While BCHC now maintains timesheets, we recommend ensuring that payroll costs charged to Federal awards are based on the actual time recorded, rather than budgeted estimates. The timesheet data should be used to support allocations in accordance with Uniform Guidance, and adjustments should be made as needed to reflect the actual effort expended on Federal programs.
Finding 2024-002 Payroll Information on the Federal Programs: 93.421 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Per 2 CFR 200.430(i) of the Uniform Guidance, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must support the distribution of employees’ salaries among specific activities or cost objectives as required. Condition: During our review of payroll charges to Federal awards, we noted that BCHC did not use timesheets from January 2024 to August 2024 and recorded salaries based on budgeted allocations. In August 2024, timesheets were implemented but we noted that the time recorded in the general ledger did not coincide with the allocation on the actual timesheets. Cause: BCHC relied on predetermined budget estimates for payroll allocation rather than using timesheets that reflected actual hours worked. Effect or Potential Effect: There is a risk that payroll costs charged to Federal programs may not accurately represent the true level of effort, potentially resulting in unallowable costs being charged to Federal awards. Questioned Costs: Indeterminate-The questioned costs relate to salary and wage expenditures charged to Federal programs without the required time and effort documentation in accordance with 2 CFR §200.430. Specifically, employees whose compensation was allocated to Federal awards did not maintain timesheets or equivalent records reflecting actual time worked on specific Federal activities. Due to the absence of these records, we were unable to determine the portion of personnel costs that may be unallowable under Uniform Guidance. Accordingly, the questioned costs are considered indeterminate. Context: We sampled 40 payroll transactions. All transactions were based on budgeted amounts. This issue was observed across all departments receiving Federal funds. Identification as a Repeat Finding, if Applicable: Not applicable Recommendation: While BCHC now maintains timesheets, we recommend ensuring that payroll costs charged to Federal awards are based on the actual time recorded, rather than budgeted estimates. The timesheet data should be used to support allocations in accordance with Uniform Guidance, and adjustments should be made as needed to reflect the actual effort expended on Federal programs.
Finding 2024-002 Payroll Information on the Federal Programs: 93.421 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Per 2 CFR 200.430(i) of the Uniform Guidance, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must support the distribution of employees’ salaries among specific activities or cost objectives as required. Condition: During our review of payroll charges to Federal awards, we noted that BCHC did not use timesheets from January 2024 to August 2024 and recorded salaries based on budgeted allocations. In August 2024, timesheets were implemented but we noted that the time recorded in the general ledger did not coincide with the allocation on the actual timesheets. Cause: BCHC relied on predetermined budget estimates for payroll allocation rather than using timesheets that reflected actual hours worked. Effect or Potential Effect: There is a risk that payroll costs charged to Federal programs may not accurately represent the true level of effort, potentially resulting in unallowable costs being charged to Federal awards. Questioned Costs: Indeterminate-The questioned costs relate to salary and wage expenditures charged to Federal programs without the required time and effort documentation in accordance with 2 CFR §200.430. Specifically, employees whose compensation was allocated to Federal awards did not maintain timesheets or equivalent records reflecting actual time worked on specific Federal activities. Due to the absence of these records, we were unable to determine the portion of personnel costs that may be unallowable under Uniform Guidance. Accordingly, the questioned costs are considered indeterminate. Context: We sampled 40 payroll transactions. All transactions were based on budgeted amounts. This issue was observed across all departments receiving Federal funds. Identification as a Repeat Finding, if Applicable: Not applicable Recommendation: While BCHC now maintains timesheets, we recommend ensuring that payroll costs charged to Federal awards are based on the actual time recorded, rather than budgeted estimates. The timesheet data should be used to support allocations in accordance with Uniform Guidance, and adjustments should be made as needed to reflect the actual effort expended on Federal programs.
2024-001 Twenty-First Century Community Learning Centers – Assistance Listing No. 84.287 Material Weakness in Internal Control Over Compliance and Noncompliance – Inadequate Payroll Documentation B. Allowable Costs/Cost Principles Criteria: Per 2 CFR § 200.430(g), charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed and are supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. As part of the Organization’s internal controls, time and effort documentation—such as timecards—should be reviewed and approved by the employee to confirm accuracy. Condition and Context: We selected 40 individuals paid in randomly selected pay periods for testing. Our sample was not statistically valid. During our testing of payroll expenses charged to the federal program, we noted that 2 out of 40 of the employee timecards selected for review were not signed or electronically certified by the respective employee. Without employee attestation, the accuracy of the reported time cannot be verified in accordance with Uniform Guidance requirements. This resulted in total questioned costs of $763. Based on an error rate of 3.23%, the likely questioned costs for the full payroll population are projected to be $14,578. Additionally, we identified 10 instances where the number of hours reported on employee timecards did not match the hours recorded in the payroll system and charged to the federal award. The total questioned costs for these discrepancies were $569. Based on an error rate of 2.41%, the likely questioned costs for the full payroll population are projected to be $10,878. This is a repeat finding of 2023-003. Cause and Effect: The lack of employee signatures appears to be due to inconsistent enforcement of timecard approval procedures. The discrepancies in the number of hours charged to the federal award appear to be due to a lack of effective reconciliation procedures between timekeeping and payroll records. As a result of these items noted above, the Organization charged unsubstantiated payroll costs to the federal award. Recommendation: We recommend that management ensure all employee timecards are signed or electronically certified by the employee in a timely manner. We also recommend a process is implemented to reconcile time charge to federal award to underlying payroll report. Internal controls should be reinforced to verify that no payroll costs are charged to federal programs without appropriate documentation and approval. Views of Responsible Officials and Planned Corrective Action: We agree with the recommendation and updated our written policy in 2024. The policy was reviewed by the Finance Committee and approved by the full Board of Directors in December 2024.
2024-001 Significant Deficiency in Internal Control and Compliance over Major Programs Funding Agency: Department of Treasury ALN: 21.027 Funding Agency: Department of Agriculture ALNs: 10.565, 10.568 & 10.569 Criteria Internal controls and other compliance knowledge should prevent the incorrect coding of employee hours worked. Per 2 CFR 200.430(g)(1), "charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed" and "be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable and properly allocated." Condition Internal controls and adherence to compliance were not followed with regards to an appropriate level of approval of management that is charged to the Coronavirus State and Local Recovery Funds program and the Food Cluster Program. Questioned costs Total questioned cost of $2,822 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Coronavirus State and Local Recovery Fund grant (ALN 21.027). Total questioned cost of $3,475 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Food Cluster Program (ALNs 10.565, 10.568, & 10.569). Context During our payroll testing, of the six executive director timesheets tested, none of them indicated a review or approval from the board president. Cause The error was caused by not applying an adequate number of controls necessary for the executive director's timesheet. Effect The Coronavirus State and Local Recovery Funds program and Food Cluster program and other federal programs could be incorrectly charged with unreasonable wages.Repeat Finding No. Auditor's Recommendation We recommend that the board president or other board member designee review the executive director's timesheet prior to submitting the wages for reimbursement from federal grants.
2024-001 Significant Deficiency in Internal Control and Compliance over Major Programs Funding Agency: Department of Treasury ALN: 21.027 Funding Agency: Department of Agriculture ALNs: 10.565, 10.568 & 10.569 Criteria Internal controls and other compliance knowledge should prevent the incorrect coding of employee hours worked. Per 2 CFR 200.430(g)(1), "charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed" and "be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable and properly allocated." Condition Internal controls and adherence to compliance were not followed with regards to an appropriate level of approval of management that is charged to the Coronavirus State and Local Recovery Funds program and the Food Cluster Program. Questioned costs Total questioned cost of $2,822 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Coronavirus State and Local Recovery Fund grant (ALN 21.027). Total questioned cost of $3,475 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Food Cluster Program (ALNs 10.565, 10.568, & 10.569). Context During our payroll testing, of the six executive director timesheets tested, none of them indicated a review or approval from the board president. Cause The error was caused by not applying an adequate number of controls necessary for the executive director's timesheet. Effect The Coronavirus State and Local Recovery Funds program and Food Cluster program and other federal programs could be incorrectly charged with unreasonable wages.Repeat Finding No. Auditor's Recommendation We recommend that the board president or other board member designee review the executive director's timesheet prior to submitting the wages for reimbursement from federal grants.
2024-001 Significant Deficiency in Internal Control and Compliance over Major Programs Funding Agency: Department of Treasury ALN: 21.027 Funding Agency: Department of Agriculture ALNs: 10.565, 10.568 & 10.569 Criteria Internal controls and other compliance knowledge should prevent the incorrect coding of employee hours worked. Per 2 CFR 200.430(g)(1), "charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed" and "be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable and properly allocated." Condition Internal controls and adherence to compliance were not followed with regards to an appropriate level of approval of management that is charged to the Coronavirus State and Local Recovery Funds program and the Food Cluster Program. Questioned costs Total questioned cost of $2,822 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Coronavirus State and Local Recovery Fund grant (ALN 21.027). Total questioned cost of $3,475 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Food Cluster Program (ALNs 10.565, 10.568, & 10.569). Context During our payroll testing, of the six executive director timesheets tested, none of them indicated a review or approval from the board president. Cause The error was caused by not applying an adequate number of controls necessary for the executive director's timesheet. Effect The Coronavirus State and Local Recovery Funds program and Food Cluster program and other federal programs could be incorrectly charged with unreasonable wages.Repeat Finding No. Auditor's Recommendation We recommend that the board president or other board member designee review the executive director's timesheet prior to submitting the wages for reimbursement from federal grants.
2024-001 Significant Deficiency in Internal Control and Compliance over Major Programs Funding Agency: Department of Treasury ALN: 21.027 Funding Agency: Department of Agriculture ALNs: 10.565, 10.568 & 10.569 Criteria Internal controls and other compliance knowledge should prevent the incorrect coding of employee hours worked. Per 2 CFR 200.430(g)(1), "charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed" and "be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable and properly allocated." Condition Internal controls and adherence to compliance were not followed with regards to an appropriate level of approval of management that is charged to the Coronavirus State and Local Recovery Funds program and the Food Cluster Program. Questioned costs Total questioned cost of $2,822 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Coronavirus State and Local Recovery Fund grant (ALN 21.027). Total questioned cost of $3,475 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Food Cluster Program (ALNs 10.565, 10.568, & 10.569). Context During our payroll testing, of the six executive director timesheets tested, none of them indicated a review or approval from the board president. Cause The error was caused by not applying an adequate number of controls necessary for the executive director's timesheet. Effect The Coronavirus State and Local Recovery Funds program and Food Cluster program and other federal programs could be incorrectly charged with unreasonable wages.Repeat Finding No. Auditor's Recommendation We recommend that the board president or other board member designee review the executive director's timesheet prior to submitting the wages for reimbursement from federal grants.
2024-001 Significant Deficiency in Internal Control and Compliance over Major Programs Funding Agency: Department of Treasury ALN: 21.027 Funding Agency: Department of Agriculture ALNs: 10.565, 10.568 & 10.569 Criteria Internal controls and other compliance knowledge should prevent the incorrect coding of employee hours worked. Per 2 CFR 200.430(g)(1), "charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed" and "be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable and properly allocated." Condition Internal controls and adherence to compliance were not followed with regards to an appropriate level of approval of management that is charged to the Coronavirus State and Local Recovery Funds program and the Food Cluster Program. Questioned costs Total questioned cost of $2,822 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Coronavirus State and Local Recovery Fund grant (ALN 21.027). Total questioned cost of $3,475 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Food Cluster Program (ALNs 10.565, 10.568, & 10.569). Context During our payroll testing, of the six executive director timesheets tested, none of them indicated a review or approval from the board president. Cause The error was caused by not applying an adequate number of controls necessary for the executive director's timesheet. Effect The Coronavirus State and Local Recovery Funds program and Food Cluster program and other federal programs could be incorrectly charged with unreasonable wages.Repeat Finding No. Auditor's Recommendation We recommend that the board president or other board member designee review the executive director's timesheet prior to submitting the wages for reimbursement from federal grants.
2024-001 Significant Deficiency in Internal Control and Compliance over Major Programs Funding Agency: Department of Treasury ALN: 21.027 Funding Agency: Department of Agriculture ALNs: 10.565, 10.568 & 10.569 Criteria Internal controls and other compliance knowledge should prevent the incorrect coding of employee hours worked. Per 2 CFR 200.430(g)(1), "charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed" and "be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable and properly allocated." Condition Internal controls and adherence to compliance were not followed with regards to an appropriate level of approval of management that is charged to the Coronavirus State and Local Recovery Funds program and the Food Cluster Program. Questioned costs Total questioned cost of $2,822 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Coronavirus State and Local Recovery Fund grant (ALN 21.027). Total questioned cost of $3,475 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Food Cluster Program (ALNs 10.565, 10.568, & 10.569). Context During our payroll testing, of the six executive director timesheets tested, none of them indicated a review or approval from the board president. Cause The error was caused by not applying an adequate number of controls necessary for the executive director's timesheet. Effect The Coronavirus State and Local Recovery Funds program and Food Cluster program and other federal programs could be incorrectly charged with unreasonable wages.Repeat Finding No. Auditor's Recommendation We recommend that the board president or other board member designee review the executive director's timesheet prior to submitting the wages for reimbursement from federal grants.
2024-001 Significant Deficiency in Internal Control and Compliance over Major Programs Funding Agency: Department of Treasury ALN: 21.027 Funding Agency: Department of Agriculture ALNs: 10.565, 10.568 & 10.569 Criteria Internal controls and other compliance knowledge should prevent the incorrect coding of employee hours worked. Per 2 CFR 200.430(g)(1), "charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed" and "be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable and properly allocated." Condition Internal controls and adherence to compliance were not followed with regards to an appropriate level of approval of management that is charged to the Coronavirus State and Local Recovery Funds program and the Food Cluster Program. Questioned costs Total questioned cost of $2,822 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Coronavirus State and Local Recovery Fund grant (ALN 21.027). Total questioned cost of $3,475 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Food Cluster Program (ALNs 10.565, 10.568, & 10.569). Context During our payroll testing, of the six executive director timesheets tested, none of them indicated a review or approval from the board president. Cause The error was caused by not applying an adequate number of controls necessary for the executive director's timesheet. Effect The Coronavirus State and Local Recovery Funds program and Food Cluster program and other federal programs could be incorrectly charged with unreasonable wages.Repeat Finding No. Auditor's Recommendation We recommend that the board president or other board member designee review the executive director's timesheet prior to submitting the wages for reimbursement from federal grants.
2024-001 Significant Deficiency in Internal Control and Compliance over Major Programs Funding Agency: Department of Treasury ALN: 21.027 Funding Agency: Department of Agriculture ALNs: 10.565, 10.568 & 10.569 Criteria Internal controls and other compliance knowledge should prevent the incorrect coding of employee hours worked. Per 2 CFR 200.430(g)(1), "charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed" and "be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable and properly allocated." Condition Internal controls and adherence to compliance were not followed with regards to an appropriate level of approval of management that is charged to the Coronavirus State and Local Recovery Funds program and the Food Cluster Program. Questioned costs Total questioned cost of $2,822 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Coronavirus State and Local Recovery Fund grant (ALN 21.027). Total questioned cost of $3,475 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Food Cluster Program (ALNs 10.565, 10.568, & 10.569). Context During our payroll testing, of the six executive director timesheets tested, none of them indicated a review or approval from the board president. Cause The error was caused by not applying an adequate number of controls necessary for the executive director's timesheet. Effect The Coronavirus State and Local Recovery Funds program and Food Cluster program and other federal programs could be incorrectly charged with unreasonable wages.Repeat Finding No. Auditor's Recommendation We recommend that the board president or other board member designee review the executive director's timesheet prior to submitting the wages for reimbursement from federal grants.
2024-001 Significant Deficiency in Internal Control and Compliance over Major Programs Funding Agency: Department of Treasury ALN: 21.027 Funding Agency: Department of Agriculture ALNs: 10.565, 10.568 & 10.569 Criteria Internal controls and other compliance knowledge should prevent the incorrect coding of employee hours worked. Per 2 CFR 200.430(g)(1), "charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed" and "be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable and properly allocated." Condition Internal controls and adherence to compliance were not followed with regards to an appropriate level of approval of management that is charged to the Coronavirus State and Local Recovery Funds program and the Food Cluster Program. Questioned costs Total questioned cost of $2,822 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Coronavirus State and Local Recovery Fund grant (ALN 21.027). Total questioned cost of $3,475 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Food Cluster Program (ALNs 10.565, 10.568, & 10.569). Context During our payroll testing, of the six executive director timesheets tested, none of them indicated a review or approval from the board president. Cause The error was caused by not applying an adequate number of controls necessary for the executive director's timesheet. Effect The Coronavirus State and Local Recovery Funds program and Food Cluster program and other federal programs could be incorrectly charged with unreasonable wages.Repeat Finding No. Auditor's Recommendation We recommend that the board president or other board member designee review the executive director's timesheet prior to submitting the wages for reimbursement from federal grants.
2024-001 Significant Deficiency in Internal Control and Compliance over Major Programs Funding Agency: Department of Treasury ALN: 21.027 Funding Agency: Department of Agriculture ALNs: 10.565, 10.568 & 10.569 Criteria Internal controls and other compliance knowledge should prevent the incorrect coding of employee hours worked. Per 2 CFR 200.430(g)(1), "charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed" and "be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable and properly allocated." Condition Internal controls and adherence to compliance were not followed with regards to an appropriate level of approval of management that is charged to the Coronavirus State and Local Recovery Funds program and the Food Cluster Program. Questioned costs Total questioned cost of $2,822 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Coronavirus State and Local Recovery Fund grant (ALN 21.027). Total questioned cost of $3,475 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Food Cluster Program (ALNs 10.565, 10.568, & 10.569). Context During our payroll testing, of the six executive director timesheets tested, none of them indicated a review or approval from the board president. Cause The error was caused by not applying an adequate number of controls necessary for the executive director's timesheet. Effect The Coronavirus State and Local Recovery Funds program and Food Cluster program and other federal programs could be incorrectly charged with unreasonable wages.Repeat Finding No. Auditor's Recommendation We recommend that the board president or other board member designee review the executive director's timesheet prior to submitting the wages for reimbursement from federal grants.
2024-001 Significant Deficiency in Internal Control and Compliance over Major Programs Funding Agency: Department of Treasury ALN: 21.027 Funding Agency: Department of Agriculture ALNs: 10.565, 10.568 & 10.569 Criteria Internal controls and other compliance knowledge should prevent the incorrect coding of employee hours worked. Per 2 CFR 200.430(g)(1), "charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed" and "be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable and properly allocated." Condition Internal controls and adherence to compliance were not followed with regards to an appropriate level of approval of management that is charged to the Coronavirus State and Local Recovery Funds program and the Food Cluster Program. Questioned costs Total questioned cost of $2,822 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Coronavirus State and Local Recovery Fund grant (ALN 21.027). Total questioned cost of $3,475 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Food Cluster Program (ALNs 10.565, 10.568, & 10.569). Context During our payroll testing, of the six executive director timesheets tested, none of them indicated a review or approval from the board president. Cause The error was caused by not applying an adequate number of controls necessary for the executive director's timesheet. Effect The Coronavirus State and Local Recovery Funds program and Food Cluster program and other federal programs could be incorrectly charged with unreasonable wages.Repeat Finding No. Auditor's Recommendation We recommend that the board president or other board member designee review the executive director's timesheet prior to submitting the wages for reimbursement from federal grants.
2024-001 Significant Deficiency in Internal Control and Compliance over Major Programs Funding Agency: Department of Treasury ALN: 21.027 Funding Agency: Department of Agriculture ALNs: 10.565, 10.568 & 10.569 Criteria Internal controls and other compliance knowledge should prevent the incorrect coding of employee hours worked. Per 2 CFR 200.430(g)(1), "charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed" and "be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable and properly allocated." Condition Internal controls and adherence to compliance were not followed with regards to an appropriate level of approval of management that is charged to the Coronavirus State and Local Recovery Funds program and the Food Cluster Program. Questioned costs Total questioned cost of $2,822 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Coronavirus State and Local Recovery Fund grant (ALN 21.027). Total questioned cost of $3,475 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Food Cluster Program (ALNs 10.565, 10.568, & 10.569). Context During our payroll testing, of the six executive director timesheets tested, none of them indicated a review or approval from the board president. Cause The error was caused by not applying an adequate number of controls necessary for the executive director's timesheet. Effect The Coronavirus State and Local Recovery Funds program and Food Cluster program and other federal programs could be incorrectly charged with unreasonable wages.Repeat Finding No. Auditor's Recommendation We recommend that the board president or other board member designee review the executive director's timesheet prior to submitting the wages for reimbursement from federal grants.
2024-001 Significant Deficiency in Internal Control and Compliance over Major Programs Funding Agency: Department of Treasury ALN: 21.027 Funding Agency: Department of Agriculture ALNs: 10.565, 10.568 & 10.569 Criteria Internal controls and other compliance knowledge should prevent the incorrect coding of employee hours worked. Per 2 CFR 200.430(g)(1), "charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed" and "be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable and properly allocated." Condition Internal controls and adherence to compliance were not followed with regards to an appropriate level of approval of management that is charged to the Coronavirus State and Local Recovery Funds program and the Food Cluster Program. Questioned costs Total questioned cost of $2,822 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Coronavirus State and Local Recovery Fund grant (ALN 21.027). Total questioned cost of $3,475 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Food Cluster Program (ALNs 10.565, 10.568, & 10.569). Context During our payroll testing, of the six executive director timesheets tested, none of them indicated a review or approval from the board president. Cause The error was caused by not applying an adequate number of controls necessary for the executive director's timesheet. Effect The Coronavirus State and Local Recovery Funds program and Food Cluster program and other federal programs could be incorrectly charged with unreasonable wages.Repeat Finding No. Auditor's Recommendation We recommend that the board president or other board member designee review the executive director's timesheet prior to submitting the wages for reimbursement from federal grants.
2024-001 Significant Deficiency in Internal Control and Compliance over Major Programs Funding Agency: Department of Treasury ALN: 21.027 Funding Agency: Department of Agriculture ALNs: 10.565, 10.568 & 10.569 Criteria Internal controls and other compliance knowledge should prevent the incorrect coding of employee hours worked. Per 2 CFR 200.430(g)(1), "charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed" and "be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable and properly allocated." Condition Internal controls and adherence to compliance were not followed with regards to an appropriate level of approval of management that is charged to the Coronavirus State and Local Recovery Funds program and the Food Cluster Program. Questioned costs Total questioned cost of $2,822 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Coronavirus State and Local Recovery Fund grant (ALN 21.027). Total questioned cost of $3,475 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Food Cluster Program (ALNs 10.565, 10.568, & 10.569). Context During our payroll testing, of the six executive director timesheets tested, none of them indicated a review or approval from the board president. Cause The error was caused by not applying an adequate number of controls necessary for the executive director's timesheet. Effect The Coronavirus State and Local Recovery Funds program and Food Cluster program and other federal programs could be incorrectly charged with unreasonable wages.Repeat Finding No. Auditor's Recommendation We recommend that the board president or other board member designee review the executive director's timesheet prior to submitting the wages for reimbursement from federal grants.
2024-001 Significant Deficiency in Internal Control and Compliance over Major Programs Funding Agency: Department of Treasury ALN: 21.027 Funding Agency: Department of Agriculture ALNs: 10.565, 10.568 & 10.569 Criteria Internal controls and other compliance knowledge should prevent the incorrect coding of employee hours worked. Per 2 CFR 200.430(g)(1), "charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed" and "be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable and properly allocated." Condition Internal controls and adherence to compliance were not followed with regards to an appropriate level of approval of management that is charged to the Coronavirus State and Local Recovery Funds program and the Food Cluster Program. Questioned costs Total questioned cost of $2,822 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Coronavirus State and Local Recovery Fund grant (ALN 21.027). Total questioned cost of $3,475 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Food Cluster Program (ALNs 10.565, 10.568, & 10.569). Context During our payroll testing, of the six executive director timesheets tested, none of them indicated a review or approval from the board president. Cause The error was caused by not applying an adequate number of controls necessary for the executive director's timesheet. Effect The Coronavirus State and Local Recovery Funds program and Food Cluster program and other federal programs could be incorrectly charged with unreasonable wages.Repeat Finding No. Auditor's Recommendation We recommend that the board president or other board member designee review the executive director's timesheet prior to submitting the wages for reimbursement from federal grants.
2024-001 Significant Deficiency in Internal Control and Compliance over Major Programs Funding Agency: Department of Treasury ALN: 21.027 Funding Agency: Department of Agriculture ALNs: 10.565, 10.568 & 10.569 Criteria Internal controls and other compliance knowledge should prevent the incorrect coding of employee hours worked. Per 2 CFR 200.430(g)(1), "charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed" and "be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable and properly allocated." Condition Internal controls and adherence to compliance were not followed with regards to an appropriate level of approval of management that is charged to the Coronavirus State and Local Recovery Funds program and the Food Cluster Program. Questioned costs Total questioned cost of $2,822 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Coronavirus State and Local Recovery Fund grant (ALN 21.027). Total questioned cost of $3,475 based on three payroll transactions tested that were not approved at the appropriate level but were charged to the Food Cluster Program (ALNs 10.565, 10.568, & 10.569). Context During our payroll testing, of the six executive director timesheets tested, none of them indicated a review or approval from the board president. Cause The error was caused by not applying an adequate number of controls necessary for the executive director's timesheet. Effect The Coronavirus State and Local Recovery Funds program and Food Cluster program and other federal programs could be incorrectly charged with unreasonable wages.Repeat Finding No. Auditor's Recommendation We recommend that the board president or other board member designee review the executive director's timesheet prior to submitting the wages for reimbursement from federal grants.
Finding No. 2024-001: Allowable Cost/Activities (Time and effort) Federal Program Title: U.S. Department of Health and Human Services Awards: ALN 93.527 Health Center Program Cluster Criteria: 2 CFR 200.430 established that all salaries and wages charged to Federal awards must be supported by a system of internal controls that provides reasonable assurance that the personnel costs incurred are accurate, allowable, and properly allocated. This includes a system to demonstrate that total compensation paid to individual employees is reasonable according to work performed. Condition: During audit procedures, we tested 40 payroll costs charged to the ALN 93.527 Health Center Program Cluster. Time and effort reporting could not be located for the 7 employees that were charged to Grant H2E for the period September – December 2024 which documented the distribution of the employee’s salary and wages among specific grants by work performed. Cause: The Organization did not follow the policies and procedures in place related to obtaining time and effort certifications from employees. Effect: The federal award may be overcharged or undercharged if actual effort differs from time charged to the award. Questioned Costs: $122,765 Context/Sampling: A sample of 40 payroll transactions were selected for testing. For each transaction, a timecard was obtained for all selected transactions which verified that the employees worked the hours to support the charges to the grant. While all timecards documented total hours worked, none included documentation of the specific time allocated to the federal program. Additionally, time and effort certifications were obtained for 33 of the 40 sampled employees. However, the Organization did not obtain time and effort certifications for the remaining 7 employees whose salaries were charged to the H2E grant. The sample was selected using non-statistical sampling methods and was not intended to be, nor should it be considered, a statistically valid sample. Repeat Finding: No Recommendation: Management should strengthen its internal controls over payroll charges to federal awards by ensuring consistent adherence to its time and effort certification policies as well as conduct periodic reviews of payroll documentation to verify compliance with established policies and federal requirements. Views of Responsible Officials and Planned Corrective Action: There is no disagreement with the audit finding.
2024-001 Allowable Compensation Costs Material Weakness in Internal Control Over Compliance 16.575 Crime Victim Assistance Criteria – 2 CFR Section 200.403 states that costs must be necessary and reasonable for the performance of the federal award. Costs must also conform to any limitations or exclusions set forth in the federal award as to types or amount of cost items. In addition, 2 CFR Section 200.430 states that charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Condition and Context – Through a financial review by a pass-through entity, compensation costs of $32,302 were identified as unallowed under the terms of the federal award for the budget period July 1, 2023 to June 30, 2024. These costs included $19,259 in calendar year 2023 and $13,043 in calendar year 2024. Cause – CCAHT did not have internal controls in place to ensure that salaries and wages claimed for reimbursement was accurate, allowable, and properly allocated. Effect – CCAHT submitted salaries and wages for reimbursement that were unallowed under the terms of the federal award. Questioned Costs – This resulted in known questioned costs of $32,302. Repeat Finding - No Recommendations – We recommend CCAHT implement internal controls to ensure all costs charged to the program are accurate, allowable, and properly allocated in accordance with the terms of the federal award, and that there is proper review and approval. Management’s Response – Management concurs with the audit recommendations. See Management’s Corrective Action Plan.
2024-001 Allowable Compensation Costs Material Weakness in Internal Control Over Compliance 16.575 Crime Victim Assistance Criteria – 2 CFR Section 200.403 states that costs must be necessary and reasonable for the performance of the federal award. Costs must also conform to any limitations or exclusions set forth in the federal award as to types or amount of cost items. In addition, 2 CFR Section 200.430 states that charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Condition and Context – Through a financial review by a pass-through entity, compensation costs of $32,302 were identified as unallowed under the terms of the federal award for the budget period July 1, 2023 to June 30, 2024. These costs included $19,259 in calendar year 2023 and $13,043 in calendar year 2024. Cause – CCAHT did not have internal controls in place to ensure that salaries and wages claimed for reimbursement was accurate, allowable, and properly allocated. Effect – CCAHT submitted salaries and wages for reimbursement that were unallowed under the terms of the federal award. Questioned Costs – This resulted in known questioned costs of $32,302. Repeat Finding - No Recommendations – We recommend CCAHT implement internal controls to ensure all costs charged to the program are accurate, allowable, and properly allocated in accordance with the terms of the federal award, and that there is proper review and approval. Management’s Response – Management concurs with the audit recommendations. See Management’s Corrective Action Plan.