Finding 612232 (2022-002)

Significant Deficiency
Requirement
B
Questioned Costs
$1
Year
2022
Accepted
2023-09-28
Audit: 25286

AI Summary

  • Core Issue: Significant deficiencies in internal controls over payroll allocations led to approximately $13,000 in questioned costs due to unapproved timesheets and incorrect allocation percentages.
  • Impacted Requirements: Noncompliance with federal standards for documentation of personal expenses, specifically regarding accurate reflection of work performed and proper allocation of salaries.
  • Recommended Follow-Up: Conduct regular reviews and reconciliations, provide training on timesheet accuracy, and redesign timesheets for better traceability to the general ledger.

Finding Text

2022?002?ALLOWABLE COSTS AND ACTIVITIES?PAYROLL AND RELATED ITEMS Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Special Programs for the Aging, Title IV, and Title II, Discretionary Projects Grants for New and Expanded Services under the Health Center Program Assistance Listing Number: 93.048 Federal Award Identification Number and Year: Multiple Award Period: Project period 06/01/2018-05/31/2023; Budget period: Multiple Questioned Costs: Approximately $13,000 Type of Finding ? Significant Deficiency in Internal Control Over Compliance of Federal Awards (E) ? Instances of Noncompliance related to Federal Awards (F) Statement of Condition During our audit, we noted instances in which timesheets were not approved, and inconsistent allocations were applied to the grants. In some instances, the percentages of allocations calculated in timesheets were incorrect and did not match the allocation in the general ledger. It appears that allocations are based mainly on budget rather than actual direct and indirect time spent on the grant. Context 20 payroll transactions out of 21 tested, including wages and payroll taxes, could not be traced in such a manner that provided reasonable assurance that the charges to the grant were accurate and properly allocated. It appears that salaries and taxes are allocated based on budget rather than direct time spent on grant. The dollar amount of the exceptions was approximately $13,000. Criteria According to ?75.430 (i) select standards for documentation of personal expenses are as follows: (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; (iv) Encompass both federally assisted, and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity and (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Effect The organization does not appear to have sufficient internal controls in place and does not appear to be in compliance with grant requirements as set forth in 45 CFR Part 75. A potential effect of noncompliance of the federal award or future funding decisions could result in disallowance of costs, suspension or termination of the award, or reduction of future allocations. Cause Internal controls over compliance do not appear to have been adequately implemented due to a lack of confirmation that the timesheet expenses match the general ledger. Recommendation We recommend the organization prevent recurrence of conducting regular reviews, and reconciliations, provide timesheets training and guidance to staff and monitoring compliance. We also recommend a re-design of the timesheets, so grant allocations and calculations for direct and indirect cost are more easily performed and traceable to the grant general ledger. View of Responsible Official We accept the finding. We have implemented a new timesheet for all employees that makes the match between allocations of time worked and allocation of compensation from different sources in the general ledger. Finding resolved timeline: The finding was resolved in September 2023. Designated of employee position responsible for meeting this deadline: Bruce Young Candelaria ? President / Ricardo A. Colon Padilla, Vice-President

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 35789 2022-001
    Significant Deficiency
  • 35790 2022-002
    Significant Deficiency
  • 612231 2022-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.048 Special Programs for the Aging_title Iv_and Title Ii_discretionary Projects $440,159
94.016 Senior Companion Program $237,585
10.443 Outreach and Assistance for Socially Disadvantaged and Veteran Farmers and Ranchers $88,928
94.002 Retired and Senior Volunteer Program $86,036
94.017 Senior Demonstration Program $17,234