Finding 980926 (2022-004)

Significant Deficiency
Requirement
AB
Questioned Costs
$1
Year
2022
Accepted
2024-06-28

AI Summary

  • Core Issue: There were clerical errors in payroll cost calculations leading to incorrect reimbursement requests for COVID-19 grant funds.
  • Impacted Requirements: Costs submitted must accurately reflect expenditures related to the public health emergency; inaccuracies can result in unallowable costs.
  • Recommended Follow-Up: Improve internal controls for reviewing reports to ensure accuracy in reimbursement requests.

Finding Text

FINDING 2022‐004 Significant Deficiency in Internal Controls and Compliance over Activities Allowed and Unallowed and Allowable Cost Principles Federal Agency: Department of Treasury Pass through Grantor: Multiple Federal Program(s): COVID‐19 Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number(s): 21.027 Criteria: Costs submitted to the grantor should be accurate representations of expenditures incurred in responding to the public health emergency with respect to COVID‐19 or its negative economic impacts. Condition: During our testing it was determined that one location of the Division requested reimbursement for costs of $52.04 (overstatement) and $82.40 (understatement) that were miscalculated due to a clerical error and therefore should not have been requested for reimbursement. Cause: One location of the Division had a clerical error in the workbook used to allocate payroll costs to grants, which resulted in certain payroll costs calculating incorrectly and the Division submitting an incorrect amount for reimbursement. Effect: Insufficient reviews can lead to clerical errors that result in unallowable costs charged to the grant and recognition of incorrect funding amounts. Questioned Costs: $82.40 (understatement) and $52.04 (overstatement). Likely questioned costs in excess of $25,000. Context or Perspective: We identified four (4) instances out of our total of sixty (60) selections which overstated the Schedule for the year ended September 30, 2022; and two (2) instances of our total of sixty (60) selections which understated the Schedule for the year ended September 30, 2022. These costs were related to allocation of fringe benefits that had been inaccurately calculated. Recommendation: The Division should enhance internal controls when reviewing internally generated reports, specifically over report parameters and clerical accuracy to ensure accurate reimbursement requests from grantors. Views of Responsible Officials: See Corrective Action Plan.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 404444 2022-002
    Significant Deficiency
  • 404445 2022-002
    Significant Deficiency
  • 404446 2022-002
    Significant Deficiency
  • 404447 2022-002
    Significant Deficiency
  • 404448 2022-002
    Significant Deficiency
  • 404449 2022-002
    Significant Deficiency
  • 404450 2022-002
    Significant Deficiency
  • 404451 2022-002
    Significant Deficiency
  • 404452 2022-002
    Significant Deficiency
  • 404453 2022-002
    Significant Deficiency
  • 404454 2022-002
    Significant Deficiency
  • 404455 2022-002
    Significant Deficiency
  • 404456 2022-002
    Significant Deficiency
  • 404457 2022-002
    Significant Deficiency
  • 404458 2022-002
    Significant Deficiency
  • 404459 2022-002
    Significant Deficiency
  • 404460 2022-002
    Significant Deficiency
  • 404461 2022-002
    Significant Deficiency
  • 404462 2022-002
    Significant Deficiency
  • 404463 2022-002
    Significant Deficiency
  • 404464 2022-002
    Significant Deficiency
  • 404465 2022-002
    Significant Deficiency
  • 404466 2022-002
    Significant Deficiency
  • 404467 2022-002
    Significant Deficiency
  • 404468 2022-002
    Significant Deficiency
  • 404469 2022-002
    Significant Deficiency
  • 404470 2022-002
    Significant Deficiency
  • 404471 2022-002
    Significant Deficiency
  • 404472 2022-002
    Significant Deficiency
  • 404473 2022-002
    Significant Deficiency
  • 404474 2022-002
    Significant Deficiency
  • 404475 2022-003
    Material Weakness
  • 404476 2022-003
    Material Weakness
  • 404477 2022-003
    Material Weakness
  • 404478 2022-003
    Material Weakness
  • 404479 2022-003
    Material Weakness
  • 404480 2022-003
    Material Weakness
  • 404481 2022-004
    Significant Deficiency
  • 404482 2022-004
    Significant Deficiency
  • 404483 2022-004
    Significant Deficiency
  • 404484 2022-004
    Significant Deficiency
  • 404485 2022-004
    Significant Deficiency
  • 404486 2022-004
    Significant Deficiency
  • 404487 2022-004
    Significant Deficiency
  • 404488 2022-004
    Significant Deficiency
  • 404489 2022-004
    Significant Deficiency
  • 404490 2022-004
    Significant Deficiency
  • 404491 2022-004
    Significant Deficiency
  • 404492 2022-004
    Significant Deficiency
  • 404493 2022-004
    Significant Deficiency
  • 404494 2022-004
    Significant Deficiency
  • 404495 2022-004
    Significant Deficiency
  • 404496 2022-004
    Significant Deficiency
  • 404497 2022-004
    Significant Deficiency
  • 404498 2022-004
    Significant Deficiency
  • 404499 2022-004
    Significant Deficiency
  • 404500 2022-004
    Significant Deficiency
  • 404501 2022-004
    Significant Deficiency
  • 404502 2022-004
    Significant Deficiency
  • 404503 2022-004
    Significant Deficiency
  • 404504 2022-004
    Significant Deficiency
  • 404505 2022-004
    Significant Deficiency
  • 404506 2022-005
    Material Weakness
  • 404507 2022-005
    Material Weakness
  • 404508 2022-005
    Material Weakness
  • 404509 2022-005
    Material Weakness
  • 404510 2022-005
    Material Weakness
  • 404511 2022-005
    Material Weakness
  • 404512 2022-005
    Material Weakness
  • 404513 2022-005
    Material Weakness
  • 404514 2022-005
    Material Weakness
  • 404515 2022-005
    Material Weakness
  • 404516 2022-005
    Material Weakness
  • 404517 2022-005
    Material Weakness
  • 980886 2022-002
    Significant Deficiency
  • 980887 2022-002
    Significant Deficiency
  • 980888 2022-002
    Significant Deficiency
  • 980889 2022-002
    Significant Deficiency
  • 980890 2022-002
    Significant Deficiency
  • 980891 2022-002
    Significant Deficiency
  • 980892 2022-002
    Significant Deficiency
  • 980893 2022-002
    Significant Deficiency
  • 980894 2022-002
    Significant Deficiency
  • 980895 2022-002
    Significant Deficiency
  • 980896 2022-002
    Significant Deficiency
  • 980897 2022-002
    Significant Deficiency
  • 980898 2022-002
    Significant Deficiency
  • 980899 2022-002
    Significant Deficiency
  • 980900 2022-002
    Significant Deficiency
  • 980901 2022-002
    Significant Deficiency
  • 980902 2022-002
    Significant Deficiency
  • 980903 2022-002
    Significant Deficiency
  • 980904 2022-002
    Significant Deficiency
  • 980905 2022-002
    Significant Deficiency
  • 980906 2022-002
    Significant Deficiency
  • 980907 2022-002
    Significant Deficiency
  • 980908 2022-002
    Significant Deficiency
  • 980909 2022-002
    Significant Deficiency
  • 980910 2022-002
    Significant Deficiency
  • 980911 2022-002
    Significant Deficiency
  • 980912 2022-002
    Significant Deficiency
  • 980913 2022-002
    Significant Deficiency
  • 980914 2022-002
    Significant Deficiency
  • 980915 2022-002
    Significant Deficiency
  • 980916 2022-002
    Significant Deficiency
  • 980917 2022-003
    Material Weakness
  • 980918 2022-003
    Material Weakness
  • 980919 2022-003
    Material Weakness
  • 980920 2022-003
    Material Weakness
  • 980921 2022-003
    Material Weakness
  • 980922 2022-003
    Material Weakness
  • 980923 2022-004
    Significant Deficiency
  • 980924 2022-004
    Significant Deficiency
  • 980925 2022-004
    Significant Deficiency
  • 980927 2022-004
    Significant Deficiency
  • 980928 2022-004
    Significant Deficiency
  • 980929 2022-004
    Significant Deficiency
  • 980930 2022-004
    Significant Deficiency
  • 980931 2022-004
    Significant Deficiency
  • 980932 2022-004
    Significant Deficiency
  • 980933 2022-004
    Significant Deficiency
  • 980934 2022-004
    Significant Deficiency
  • 980935 2022-004
    Significant Deficiency
  • 980936 2022-004
    Significant Deficiency
  • 980937 2022-004
    Significant Deficiency
  • 980938 2022-004
    Significant Deficiency
  • 980939 2022-004
    Significant Deficiency
  • 980940 2022-004
    Significant Deficiency
  • 980941 2022-004
    Significant Deficiency
  • 980942 2022-004
    Significant Deficiency
  • 980943 2022-004
    Significant Deficiency
  • 980944 2022-004
    Significant Deficiency
  • 980945 2022-004
    Significant Deficiency
  • 980946 2022-004
    Significant Deficiency
  • 980947 2022-004
    Significant Deficiency
  • 980948 2022-005
    Material Weakness
  • 980949 2022-005
    Material Weakness
  • 980950 2022-005
    Material Weakness
  • 980951 2022-005
    Material Weakness
  • 980952 2022-005
    Material Weakness
  • 980953 2022-005
    Material Weakness
  • 980954 2022-005
    Material Weakness
  • 980955 2022-005
    Material Weakness
  • 980956 2022-005
    Material Weakness
  • 980957 2022-005
    Material Weakness
  • 980958 2022-005
    Material Weakness
  • 980959 2022-005
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
64.024 Va Homeless Providers Grant and Per Diem Program $941,083
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $293,690
10.569 Emergency Food Assistance Program (food Commodities) $284,852
14.231 Emergency Solutions Grant Program $273,070
14.267 Continuum of Care Program $210,709
17.277 Workforce Investment Act (wia) National Emergency Grants $70,125
14.231 Covid-19 Emergency Solutions Grant Program $64,903
97.024 Emergency Food and Shelter National Board Program $45,032
10.559 Summer Food Service Program for Children $34,589
97.024 Covid-19 Emergency Food and Shelter National Board Program $28,466
10.558 Child and Adult Care Food Program $20,142
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $12,640
21.019 Covid-19 Coronavirus Relief Fund $11,587
14.239 Home Investment Partnerships Program $6,539
14.218 Community Development Block Grants/entitlement Grants $5,731
16.590 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program $5,398
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $2,248