Finding 501031 (2023-003)

Significant Deficiency
Requirement
P
Questioned Costs
$1
Year
2023
Accepted
2024-09-30
Audit: 323277
Organization: Suffolk County, New York (NY)

AI Summary

  • Core Issue: Suffolk County Department of Labor reported $373,855 in expenditures from the prior year in the 2023 financial statements, violating the requirement to record expenses in the correct year.
  • Impacted Requirements: The Department did not comply with Uniform Guidance, which mandates that expenditures be reported when they occur and reconciled with the Schedule of Expenditures of Federal Awards (SEFA).
  • Recommended Follow-Up: Implement processes to ensure timely and accurate reporting of expenditures on the SEFA, including regular reconciliations and proper year-end accrual procedures.

Finding Text

OTHER - BASIS OF ACCOUNTING – SIGNIFICANT DEFICIENCY WIOA CLUSTER: WIOA ADULT PROGRAM - ALN 17.258 WIOA YOUTH ACTIVITIES - ALN 17.259 WIOA DISLOCATED WORKER FORMULA GRANTS - ALN 17.278 STATE AGENCY: NEW YORK STATE DEPARTMENT OF LABOR IDENTIFICATION NUMBER(S): VARIOUS AND AA-36336-21-55-A-36 FEDERAL AGENCY: U.S. DEPARTMENT OF LABOR COUNTY AGENCY: SUFFFOLK COUNTY DEPARTMENT OF LABOR 1. CRITERIA Basis of Accounting — Uniform Guidance states the basis of accounting used may be a special purpose framework. However, it does state that the determination of when an award is expended must be based on when the activity related to the federal award occurs. Uniform Guidance also states for grants, cost reimbursement contracts, cooperative agreements, and direct appropriation type of contracts, the federal expenditure or expense should be reported when the transaction occurs. Uniform Guidance further states, the auditee should also be able to reconcile amounts presented in the financial statements to related amounts in the Schedule of Expenditures of Federal Awards (the “SEFA”). 2. CONDITION/PERSPECTIVE The Suffolk County Department of Labor (the “Department”) receives WIOA Adult; Youth and Dislocated Worker Formula Grants from New York State Department of Labor (the “Agency”). The Department reports to the Agency on an accrual basis, as required by the Agency. The County’s SEFA is presented on the accrual basis of accounting. The Department provides all supporting documents to the Agency for reimbursement. We noted that the Department included expenditures in the amount of $373,855, which were incurred and dated in the prior year. The Department recorded the expenditures and revenue in the 2023 financial statements. These expenditures were also added to the SEFA in calendar year ended December 31, 2023. 3. CAUSE The Departments did not ensure that all program expenditures were reported in the correct year in the County’s SEFA. 4. EFFECT The Pass-through agency may consider Suffolk County noncompliant. 5. REPEAT FINDING No. 6. RECOMMENDATION We recommend the Department report expenditures on the SEFA on the accrual basis of accounting, which is the basis the County utilizes for other federal programs. 7. QUESTIONED COST Cannot be determined. 8. VIEWS OF RESPONSIBLE OFFICIAL The Department will enact additional processes to ensure that expenditures and revenues are reported in the year in which they incurred. As noted in the Department’s Corrective Action Plan, throughout the year, the Department will regularly reconcile vouchers to ensure that expenditures and associated revenue are reported in the correct year on the SEFA. Two staff members in the Department (one as the primary, the other as the alternate) will be assigned the responsibility of tracking the SEFA reconciliation process. When preparing the annual SEFA, the Department will reconcile expenditure reports with the expenditure reported on the annual SEFA. During year-end processing, the Department, when entering vouchers into the financial system, will ensure items to be accrued will contain the letter “A” as a prefix to the voucher number. The Department will also check to ensure all items that should be accrued, are in fact accrued prior to year-end closing. In addition, the Department will confirm the date entered in the financial system, reflects the proper year in which the expenditure and associated revenue should be recorded.

Categories

Questioned Costs Reporting Cash Management Significant Deficiency

Other Findings in this Audit

  • 501029 2023-003
    Significant Deficiency
  • 501030 2023-003
    Significant Deficiency
  • 501032 2023-003
    Significant Deficiency
  • 1077471 2023-003
    Significant Deficiency
  • 1077472 2023-003
    Significant Deficiency
  • 1077473 2023-003
    Significant Deficiency
  • 1077474 2023-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.558 Temporary Assistance for Needy Families $79.30M
97.039 Hazard Mitigation Grant $75.27M
93.575 Child Care and Development Block Grant $57.57M
93.568 Low-Income Home Energy Assistance $26.44M
21.027 Covid-19: Coronavirus State and Local Fiscal Recovery Funds $23.51M
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $23.49M
93.778 Medical Assistance Program $19.77M
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $19.17M
20.507 Covid-19: Federal Transit_formula Grants $19.00M
14.269 Hurricane Sandy Community Development Block Grant Disaster Recovery Grants (cdbg-Dr) $15.73M
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $15.16M
93.658 Foster Care_title IV-E $9.22M
93.563 Child Support Enforcement $7.28M
93.659 Adoption Assistance $6.30M
16.606 State Criminal Alien Assistance Program $5.59M
93.667 Social Services Block Grant $5.38M
93.323 Covid-19: Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $4.45M
16.U00 Housing & Transportation of Federal Adult Prisoners $4.31M
97.067 Homeland Security Grant Program $3.60M
17.258 Wioa Adult Program $2.97M
93.958 Block Grants for Community Mental Health Services $2.51M
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $2.38M
17.259 Wioa Youth Activities $1.94M
11.307 Economic Adjustment Assistance $1.92M
20.513 Covid-19: Enhanced Mobility of Seniors and Individuals with Disabilities $1.81M
14.218 Community Development Block Grants/entitlement Grants $1.79M
20.507 Federal Transit_formula Grants $1.76M
93.045 Covid-19: Special Programs for the Aging_title Iii, Part C_nutrition Services $1.74M
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $1.16M
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $1.12M
20.237 Motor Carrier Safety Assistance High Priority Activities Grants and Cooperative Agreements $1.03M
93.767 Children's Health Insurance Program $992,368
93.354 Covid-19: Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $875,821
16.609 Project Safe Neighborhoods $810,306
93.052 National Family Caregiver Support, Title Iii, Part E $748,946
84.181A Special Education-Grants for Infants and Families $744,484
14.239 Home Investment Partnerships Program $660,000
93.069 Public Health Emergency Preparedness $641,629
16.922 Equitable Sharing Program $616,820
10.561 Covid-19: State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $607,707
97.056 Port Security Grant Program $593,881
21.016 Equitable Sharing $582,558
93.044 Covid-19: Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $574,602
16.738 Edward Byrne Memorial Justice Assistance Grant Program $511,951
20.106 Airport Improvement Program $507,785
93.053 Nutrition Services Incentive Program $501,560
97.042 Emergency Management Performance Grants $491,812
16.123 Community-Based Violence Prevention Program $460,799
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $386,356
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $355,647
20.205 Highway Planning and Construction $315,712
93.052 Covid-19: National Family Caregiver Support, Title Iii, Part E $304,189
16.741 Dna Backlog Reduction Program $285,111
16.320 Services for Trafficking Victims $279,135
17.277 Wioa National Dislocated Worker Grants / Wia National Emergency Grants $263,959
16.575 Crime Victim Assistance $260,990
93.090 Guardianship Assistance $246,452
20.600 State and Community Highway Safety $244,544
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $226,651
16.734 Special Data Collections and Statistical Studies $205,911
16.817 Byrne Criminal Justice Innovation Program $203,745
93.136 Injury Prevention and Control Research and State and Community Based Programs $178,326
93.994 Maternal and Child Health Services Block Grant to the States $171,575
93.558 Covid-19: Temporary Assistance for Needy Families $160,800
14.228 Covid-19: Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $152,393
66.605 Performance Partnership Grants $146,070
93.575 Covid-19: Child Care and Development Block Grant $144,674
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $143,677
84.425 Education Stabilization Fund $138,000
66.456 National Estuary Program $131,874
97.083 Staffing for Adequate Fire and Emergency Response (safer) $128,288
16.710 Public Safety Partnership and Community Policing Grants $128,145
17.278 Wioa Dislocated Worker Formula Grants $120,147
16.590 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program $112,459
66.472 Beach Monitoring and Notification Program Implementation Grants $108,296
93.914 Hiv Emergency Relief Project Grants $97,303
93.959 Covid-19: Block Grants for Prevention and Treatment of Substance Abuse $76,377
93.268 Immunization Cooperative Agreements $75,506
93.071 Medicare Enrollment Assistance Program $74,822
16.585 Treatment Court Discretionary Grant Program $69,358
93.U01 Mammography Inspection $68,236
21.023 Covid-19: Emergency Rental Assistance Program $63,230
93.779 Centers for Medicare and Medicaid Services (cms) Research, Demonstrations and Evaluations $51,477
15.608 Fish and Wildlife Management Assistance $50,000
16.588 Violence Against Women Formula Grants $48,750
93.747 Covid-19: Elder Abuse Prevention Interventions Program $42,739
93.268 Covid-19: Immunization Cooperative Agreements $41,608
96.006 Supplemental Security Income $38,600
14.218 Covid-19: Community Development Block Grants/entitlement Grants $37,107
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $34,317
93.008 Medical Reserve Corps Small Grant Program $33,291
93.043 Covid-19: Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $31,244
97.106 Securing the Cities Program $26,869
16.735 Prea Program: Strategic Support for Prea Implementation $17,218
93.150 Projects for Assistance in Transition From Homelessness (path) $7,829
14.239 Covid-19: Home Investment Partnerships Program $7,689
93.103 Food and Drug Administration_research $7,682
17.245 Trade Adjustment Assistance $7,293
15.616 Clean Vessel Act Program $5,825
93.279 Drug Abuse and Addiction Research Programs $4,102
20.616 National Priority Safety Programs $3,301
20.219 Recreational Trails Program $2,658
16.034 Covid-19: Coronavirus Emergency Supplemental Funding Program $2,185