Finding 1162716 (2024-004)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
$1
Year
2024
Accepted
2025-11-19
Audit: 372349
Organization: Dreaming Out Loud, Inc. (DC)

AI Summary

  • Core Issue: DOL is using estimates for salary allocations to Federal programs instead of actual time records, leading to inaccuracies.
  • Impacted Requirements: This violates CFR §200.430, which mandates that salary charges must be based on accurate documentation of work performed.
  • Recommended Follow-Up: Implement project-specific timesheets, ensure supervisor approvals, and train staff on compliance to improve accuracy and reduce questioned costs.

Finding Text

Finding: 2024-004 Time/Salary Allocations (Significant Deficiency) Information on the Federal Programs: ALN #21.027 Coronavirus State and Local Fiscal Recovery Funds Criteria or Specific Requirement (including Statutory, Regulatory, or Other Citation): CFR §200.430 Compensation—personal services. States; (g) Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. Criteria or Specific Requirement (including Statutory, Regulatory, or Other Citation) (continued): 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; (vii) Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Condition: During our audit of DOL’s compensation practices, we noted that salaries and benefits charged to Federal programs were allocated using predetermined estimates rather than contemporaneous records reflecting actual time spent. These allocations were not supported by detailed documentation, such as timekeeping records or personnel activity reports, and the only support available was in the form of internal memos recorded in the general ledger. Cause: DOL has not implemented a system for documenting time and effort in a manner that complies with Federal requirements. The current process relies on estimates rather than actual, verifiable work performed. Effect or Potential Effect: Without accurate and documented time and effort reporting, there is a risk that Federal awards are either overcharged or undercharged for salaries and benefits. This creates the potential for noncompliance with Federal cost principles, and could lead to disallowed costs in the event of a monitoring or program audit. For ALN #21.027, we identified $80,985 in questioned costs, representing the total amount of unsupported salary and benefit charges to this program. Such deficiencies could also impair the Organization's eligibility for future Federal funding. Questioned Costs: $80,985 (all salaries and benefits changed to ALN #21.027) Context: We tested a statistically valid sample of employee salaries charged to Federal awards. The deficiencies noted were consistent across the sample population, indicating a systemic issue rather than isolated exceptions. Identification as a Repeat Finding, if Applicable: N/A Recommendation: We recommend that DOL strengthen its payroll allocation procedures to ensure compliance with 2 CFR §200.430. Specifically, we advise the following steps: 1. Implement Time and Effort Reporting: All employees whose salaries are charged in whole or in part to Federal awards should complete project-specific timesheets that record actual time spent on each cost objective or funding source. 2. Certifications and Approvals: Timesheets should be signed by the employee and reviewed and certified by their direct supervisor to confirm accuracy. 3. Allocate Based on Actual Time: Salaries and benefits should be allocated to funding sources based on the proportion of actual time worked, as indicated in approved timesheets, rather than based on estimates. 4. Incorporate into Internal Controls: These procedures should be incorporated into DOL’s internal control system and formally documented in its accounting policies and procedures manual. 5. Training and Oversight: Staff responsible for managing payroll allocations and Federal reporting should receive training on Federal time and effort requirements. Periodic internal reviews should be conducted to ensure adherence. By implementing these practices, DOL will significantly reduce the risk of questioned costs, improve compliance with Federal grant requirements, and strengthen the reliability of its financial reporting.

Corrective Action Plan

Views of Responsible Officials: We agree with the auditor’s findings and recommendations. Intacct allows for the automatic allocation of salaries to grants directly which provides us with much better records. ADP Workforce now will put all the appropriate approvals in place, both employee and supervisor. We are discussing the right method for project-specific timesheets, but think that biweekly forms for staff to fill out are the best route. Staff would check off grant-allowable activities that they engaged in and then note the hours allocated to those activities.

Categories

Questioned Costs Allowable Costs / Cost Principles Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1162713 2024-004
    Material Weakness Repeat
  • 1162714 2024-005
    Material Weakness Repeat
  • 1162715 2024-006
    Material Weakness Repeat
  • 1162717 2024-005
    Material Weakness Repeat
  • 1162718 2024-006
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
10.177 REGIONAL FOOD SYSTEM PARTNERSHIPS $336,934
10.443 OUTREACH AND ASSISTANCE FOR SOCIALLY DISADVANTAGED AND VETERAN FARMERS AND RANCHERS $177,971
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $118,192
10.175 FARMERS MARKET AND LOCAL FOOD PROMOTION PROGRAM $100