Finding 575043 (2024-002)

Significant Deficiency Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2024
Accepted
2025-08-28

AI Summary

  • Core Issue: Payroll software errors led to incorrect allocation of employee hours to federal programs, violating 2 CFR part 200.430(g)(1).
  • Impacted Requirements: Accurate records must reflect actual work performed and support salary distribution among various activities.
  • Recommended Follow-Up: Establish a review process for payroll allocations to ensure accurate wage distribution based on documented employee time across programs.

Finding Text

Criteria or specific requirement: Per 2 CFR part 200.430(g)(1), "Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed." Furthermore, 2 CFR 200.430(g)(1)(vi) indicates that these records must "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 a 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: (Aging) In a statistically valid sample, one of 40 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. (93.676) In a statistically valid sample, one of 60 payroll expenditures tested was in excess of the hours worked to the major program, per the employee's approved timesheet. Questioned costs: None Context: (Aging) In the deficient sample tested, an additional 10.98 hours were charged to the major program that should have been booked to a non-program code, per the approved timesheet. This was due to an allocation setup error in the payroll software. This setup issue only affected one employee, and the full-year impact was immaterial to the program. (93.676) In the deficient sample tested, an additional .88 hours were charged to the major program that should have been booked to another program code not belonging to the major program, per the approved timesheet. This was due to an allocation setup error in the payroll software. The allocation setup was corrected after the prior year audit, but due to timing of the audit recommendations, the issue persisted into part of FY24. The full-year impact was immaterial to the program. Cause: Excessive wages were booked to the major program due to an allocation setup error in the payroll software. The employees in question should have been moved to a holding home department. However, when that process was done for all other employees, these employees were missed. Effect: Inadequate allocation of wages to federal programs may result in noncompliance with grant regulations. This can also lead to overcharging or undercharging the federal grant, which may result in penalties or repayment obligations. Repeat Finding: 2023-001 Recommendation: CLA recommends implementing a review process over ADP allocations to ensure that employees who work across various programs have their wages allocated accurately based on the documented time and effort spent on each program. Views of responsible officials: There is no disagreement with the audit finding.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 575026 2024-001
    Significant Deficiency Repeat
  • 575027 2024-001
    Significant Deficiency Repeat
  • 575028 2024-001
    Significant Deficiency Repeat
  • 575029 2024-001
    Significant Deficiency Repeat
  • 575030 2024-001
    Significant Deficiency Repeat
  • 575031 2024-001
    Significant Deficiency Repeat
  • 575032 2024-001
    Significant Deficiency Repeat
  • 575033 2024-001
    Significant Deficiency Repeat
  • 575034 2024-001
    Significant Deficiency Repeat
  • 575035 2024-001
    Significant Deficiency Repeat
  • 575036 2024-001
    Significant Deficiency Repeat
  • 575037 2024-001
    Significant Deficiency Repeat
  • 575038 2024-001
    Significant Deficiency Repeat
  • 575039 2024-001
    Significant Deficiency Repeat
  • 575040 2024-001
    Significant Deficiency Repeat
  • 575041 2024-002
    Significant Deficiency Repeat
  • 575042 2024-002
    Significant Deficiency Repeat
  • 575044 2024-002
    Significant Deficiency Repeat
  • 575045 2024-002
    Significant Deficiency Repeat
  • 575046 2024-002
    Significant Deficiency Repeat
  • 575047 2024-002
    Significant Deficiency Repeat
  • 575048 2024-002
    Significant Deficiency Repeat
  • 575049 2024-002
    Significant Deficiency Repeat
  • 575050 2024-002
    Significant Deficiency Repeat
  • 575051 2024-002
    Significant Deficiency Repeat
  • 575052 2024-002
    Significant Deficiency Repeat
  • 575053 2024-002
    Significant Deficiency Repeat
  • 575054 2024-002
    Significant Deficiency Repeat
  • 575055 2024-002
    Significant Deficiency Repeat
  • 575056 2024-002
    Significant Deficiency Repeat
  • 575057 2024-002
    Significant Deficiency Repeat
  • 575058 2024-002
    Significant Deficiency Repeat
  • 575059 2024-002
    Significant Deficiency Repeat
  • 575060 2024-002
    Significant Deficiency Repeat
  • 575061 2024-002
    Significant Deficiency Repeat
  • 575062 2024-002
    Significant Deficiency Repeat
  • 575063 2024-002
    Significant Deficiency Repeat
  • 575064 2024-002
    Significant Deficiency Repeat
  • 575065 2024-002
    Significant Deficiency Repeat
  • 575066 2024-002
    Significant Deficiency Repeat
  • 575067 2024-003
    Significant Deficiency Repeat
  • 575068 2024-003
    Significant Deficiency Repeat
  • 1151468 2024-001
    Significant Deficiency Repeat
  • 1151469 2024-001
    Significant Deficiency Repeat
  • 1151470 2024-001
    Significant Deficiency Repeat
  • 1151471 2024-001
    Significant Deficiency Repeat
  • 1151472 2024-001
    Significant Deficiency Repeat
  • 1151473 2024-001
    Significant Deficiency Repeat
  • 1151474 2024-001
    Significant Deficiency Repeat
  • 1151475 2024-001
    Significant Deficiency Repeat
  • 1151476 2024-001
    Significant Deficiency Repeat
  • 1151477 2024-001
    Significant Deficiency Repeat
  • 1151478 2024-001
    Significant Deficiency Repeat
  • 1151479 2024-001
    Significant Deficiency Repeat
  • 1151480 2024-001
    Significant Deficiency Repeat
  • 1151481 2024-001
    Significant Deficiency Repeat
  • 1151482 2024-001
    Significant Deficiency Repeat
  • 1151483 2024-002
    Significant Deficiency Repeat
  • 1151484 2024-002
    Significant Deficiency Repeat
  • 1151485 2024-002
    Significant Deficiency Repeat
  • 1151486 2024-002
    Significant Deficiency Repeat
  • 1151487 2024-002
    Significant Deficiency Repeat
  • 1151488 2024-002
    Significant Deficiency Repeat
  • 1151489 2024-002
    Significant Deficiency Repeat
  • 1151490 2024-002
    Significant Deficiency Repeat
  • 1151491 2024-002
    Significant Deficiency Repeat
  • 1151492 2024-002
    Significant Deficiency Repeat
  • 1151493 2024-002
    Significant Deficiency Repeat
  • 1151494 2024-002
    Significant Deficiency Repeat
  • 1151495 2024-002
    Significant Deficiency Repeat
  • 1151496 2024-002
    Significant Deficiency Repeat
  • 1151497 2024-002
    Significant Deficiency Repeat
  • 1151498 2024-002
    Significant Deficiency Repeat
  • 1151499 2024-002
    Significant Deficiency Repeat
  • 1151500 2024-002
    Significant Deficiency Repeat
  • 1151501 2024-002
    Significant Deficiency Repeat
  • 1151502 2024-002
    Significant Deficiency Repeat
  • 1151503 2024-002
    Significant Deficiency Repeat
  • 1151504 2024-002
    Significant Deficiency Repeat
  • 1151505 2024-002
    Significant Deficiency Repeat
  • 1151506 2024-002
    Significant Deficiency Repeat
  • 1151507 2024-002
    Significant Deficiency Repeat
  • 1151508 2024-002
    Significant Deficiency Repeat
  • 1151509 2024-003
    Significant Deficiency Repeat
  • 1151510 2024-003
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
93.566 Unaccompanied Refugee Minors $1.24M
14.218 Community Development Block Grant-Note D $789,900
14.218 Kirkland Shelter-Note D $770,132
14.267 Home Connection $670,172
14.231 Nativity House Overnight Shelter $654,393
14.239 Home Investment Partnership Program-Note D $530,000
14.267 Clare's Place $439,072
93.676 Alien Unaccompanied Minors (long Term Fc) $402,290
14.267 Journey Home $381,635
93.045 Senior Nutrition-Home Delivered Meals $372,878
93.045 Senior Nutrition Program - Congregate $361,915
14.267 The Road Home $317,204
14.231 Ccs Shelter Rrh Pilot $316,441
93.045 Senior Nutrition Program-Home Delivered Meals $302,857
14.231 The Inn $300,000
93.045 Senior Nutrition-Congregate $278,576
14.231 Streets to Housing Esg-Cv Rrh $257,707
21.027 Streets to Housing $248,994
14.267 Homeless Families Home at Last $247,661
64.024 Supportive Services for Veterans Affairs $241,632
14.267 Meadowdale $220,651
64.033 Supportive Services for Veterans Affairs $214,717
14.231 Rapid Re-Housing - Esg $213,445
14.231 Esg Commerce - Rapid Rehousing $201,124
14.239 Devoe II Housing - Note D $200,000
21.027 Subsistence Svcs Related to City Cdbg-Cv $200,000
20.513 Volunteer Transportation Services Program $193,090
21.027 Ccs Rrh Jobs & Housing $177,021
93.959 Recovery and Community $172,825
14.267 The Inn Safe Haven $167,706
93.243 F-Sharp, Year 5 $161,167
21.027 Ccs of King County - Arpa $152,977
14.267 Nativity House - Continuum of Care $145,811
93.045 Senior Congregate Nutrition Services $144,142
14.267 Permanent Housing for Veterans $143,194
93.044 African Elders Program $134,863
14.231 Esg Hud Rapid Rehousing $125,968
93.958 Arrest and Jail Alternatives $117,229
93.788 Opiod Str $116,895
14.267 Rrh Emergency Housing Voucher Stability $115,189
14.267 Ozanam $109,440
14.218 Katherine's House-Note D $106,435
93.958 Adult Behavioral Health $90,000
14.267 Cea Regional Access Point $85,547
21.027 Arpa-New Bethlehem Programs-Hotel Sheltering $84,002
21.027 Rrh Single Adult $82,618
93.045 Senior Nutrition Program-Home Delivered Nutrition $79,807
93.959 North Sound Bho $75,000
93.224 H8f Counseling, Recovery and Wellness (crew) and Families in Shelter (fis) $74,445
21.027 Ccs-Arpa $71,645
20.513 Disabled Veteran's Transportation $60,247
14.218 Cdbg Pregnant and Parenting House $59,840
14.267 Coming Home $58,791
94.002 Retired Senior Volunteer Program (rsvp) $56,387
14.231 Kc Dchs Rapid Re-Housing Family $56,360
14.231 New Bethlehem Hotel $56,181
14.231 Esg-Cv Bridges Program $55,577
20.513 Thurston County Bus Buddies $54,297
14.231 Bunny Wilburn Shelter and Referral Center $54,000
14.218 Cea Regional Access Point $52,854
93.242 Scaling Low-Barrier Care to Engage People with Complex Needs in Hiv Treatment $42,892
93.053 Senior Congregate Nutrition Services $41,720
14.267 Patrick Place $39,597
93.053 Senior Nutrition-Home Delivered Meals-Nsip $39,547
14.218 Community Development Block Grant $38,500
14.267 Westlake $38,421
93.959 Matt Talbot, Jul 23 - Dec 23 $36,382
21.027 Coronavirus State and Local Fiscal Recovery Funds $35,905
93.959 Matt Talbot, Jan 24 - Jun 24 $35,736
14.231 Nativity House General Fund Inclement Weather $31,351
14.267 Noel $29,118
97.024 Emergency Food and Shelter Program (efsp)-Phase 40 $26,224
93.053 Senior Nutrition Program - Congregate Nsip $25,993
20.513 Consolidated Public Transportation Grant $25,965
14.231 Sdg Ehp/esg Commerce $24,443
14.267 Emergency Housing Voucher Navigation Services $21,156
21.027 African Elders Program $19,836
93.053 Senior Nutrition- Congregate Nsip $17,307
14.267 Thea Bowman Apartments $16,740
14.267 Drexel - Continuum of Care $16,163
20.513 Benefit Area (dba-C-Tran) for Volunteer Driver Program $14,711
14.267 Dchs/csd Homeless Housing Program $14,217
14.218 Katherine House $14,000
93.044 Transportation Services $13,106
14.881 Rapid Re-Housing Tha $12,672
14.218 Sacred Heart $12,102
14.228 Community Development Block Grant (cdbg-Cv) $8,857
93.053 Senior Nutrition Program-Nsip Home Delivered $8,403
14.267 Snohomish Young Adult Housing $6,862
93.778 African American Elders Program $5,256
97.024 Emergency Food and Shelter Program (efsp)-Phase 41 $3,825
14.218 Kc Housing Stability Program $3,410
14.267 Rol $2,831
93.052 African Elders Program $2,824
93.044 Volunteer Transportation Program $1,427