Audit 352116

Criteria or Specific Requirement: The Code of Federal Regulations (CFR) Section 200.302 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition: Management's grant tracking of expenditures for the federal awards was not clearly classified during the year. Questioned costs: n/a Context: Management was not able to provide a schedule of government grants for a significant period of time after audit fieldwork started. Cause: Due to continued staff turnover, sufficient training for preparing grant tracking spreadsheets is still necessary for new staff and the details of the federal awards received during the year were not clearly defined. At the start of audit fieldwork, it was unknown as to what the actual expenditures for each program were for the year. Effect: Unallowable costs could be charged to federal awards and not be detected and corrected. Repeat Finding: Yes. Finding 2023-002. Recommendation: We recommend the Organization provide training to staff responsible for tracking federal and state awards and utilize another member of management to review and approve the grant tracking spreadsheets routinely. Additionally, we recommend reconciliations be performed monthly between the grant spreadsheets and the financial reporting software. A tracking of the federal expenditures needs to be kept and classified to the proper federal and state programs. Views of Responsible Officials: There is no disagreement with the audit finding.

Criteria or Specific Requirement: Wages should be allocated to federal and state programs on the basis of time spent in each program. Condition: Based on review of timesheets, there were discrepancies between wages that were charged to the grant and the wages that should have been charged to the grant based on the number of hours worked. Questioned costs: $1,187. Context: Of the 30 items in our payroll sample, 18 had differences between the wages that were charged to the grant and the wages that should have been charged to the grant based on the number of hours worked. The finding was specific to payroll costs. Payroll costs accounted for 11% of the total costs applied to the grant. Cause: Staff incorrectly coded their time to general case management instead of the specific grant funding code. Effect: Wages could be charged to the wrong federal awards and not be detected and corrected. Repeat Finding: No Recommendation: We recommend the Organization provide training to staff regarding time entry and utilize another member of management to review and approve the timesheets routinely. Views of Responsible Officials: There is no disagreement with the audit finding.

Criteria or Specific Requirement: The Code of Federal Regulations (CFR) Section 200.302 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition: Management's grant tracking of expenditures for the federal awards was not clearly classified during the year. Questioned costs: n/a Context: Management was not able to provide a schedule of government grants for a significant period of time after audit fieldwork started. Cause: Due to continued staff turnover, sufficient training for preparing grant tracking spreadsheets is still necessary for new staff and the details of the federal awards received during the year were not clearly defined. At the start of audit fieldwork, it was unknown as to what the actual expenditures for each program were for the year. Effect: Unallowable costs could be charged to federal awards and not be detected and corrected. Repeat Finding: Yes. Finding 2023-002. Recommendation: We recommend the Organization provide training to staff responsible for tracking federal and state awards and utilize another member of management to review and approve the grant tracking spreadsheets routinely. Additionally, we recommend reconciliations be performed monthly between the grant spreadsheets and the financial reporting software. A tracking of the federal expenditures needs to be kept and classified to the proper federal and state programs. Views of Responsible Officials: There is no disagreement with the audit finding.

Criteria or Specific Requirement: Wages should be allocated to federal and state programs on the basis of time spent in each program. Condition: Based on review of timesheets, there were discrepancies between wages that were charged to the grant and the wages that should have been charged to the grant based on the number of hours worked. Questioned costs: $1,187. Context: Of the 30 items in our payroll sample, 18 had differences between the wages that were charged to the grant and the wages that should have been charged to the grant based on the number of hours worked. The finding was specific to payroll costs. Payroll costs accounted for 11% of the total costs applied to the grant. Cause: Staff incorrectly coded their time to general case management instead of the specific grant funding code. Effect: Wages could be charged to the wrong federal awards and not be detected and corrected. Repeat Finding: No Recommendation: We recommend the Organization provide training to staff regarding time entry and utilize another member of management to review and approve the timesheets routinely. Views of Responsible Officials: There is no disagreement with the audit finding.