Finding 1131567 (2022-002)

Material Weakness Repeat Finding
Requirement
F
Questioned Costs
-
Year
2022
Accepted
2025-04-15

AI Summary

  • Core Issue: Significant deficiencies in internal controls over financial reporting and compliance, leading to inaccuracies in accrued payroll and asset tracking.
  • Impacted Requirements: Noncompliance with GAAP for payroll accruals and federal regulations for property records, including tracking and monitoring of federally funded assets.
  • Recommended Follow-Up: Management should enhance review processes for accrual entries and implement robust tracking systems for federally procured equipment to ensure compliance.

Finding Text

Type of Finding:  Significant Deficiency in Internal Control over Financial Reporting Condition: During testwork over accrued payroll accounts, CLA noted the year-end adjustments made for accrued payroll and accrued vacation were erroneously calculated. Criteria or specific requirement: Under generally accepted accounting principles, expenses should be accrued the period in which they relate (hours worked in the case of accrued payroll and related liabilities). Effect: Understatement and overstatement of expenses and related liabilities. Cause: The year-end entry was not reviewed for accuracy, resulting in accrued payroll being understated and accrued vacation being overstated. Repeat Finding: See prior year finding 2020-001. Recommendation: CLA recommends management review the accrual entries in detail to ensure accuracy prior to recording. Views of responsible officials and planned corrective actions: VSS agrees with CLA in creating internal controls over reviewing year end entries. We have hired an accountant, in addition to our Finance Director and Finance Coordinator to create a system of posting and review. Federal Program Title(s):  ALN 16.575 - Crime Victim Assistance Federal Agencies:  Department of Justice (ALN 16.575) Pass-Through Agencies:  New Mexico Crime Victims Reparation Commission (ALN 16.575) Award Numbers and Periods:  2021-VA-979 (10/1/2020-9/30/2021) (16.575)  2022-VA-180 (10/1/2021-9/30/2022) (16.575) Type of Finding:  Material Weakness in Internal Control over Compliance  Material Noncompliance (Modified Opinion) Criteria or specific requirement: Per §200.313, Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the Federal Award Identification Number (FAIN)), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Condition: During our testing, we noted that VSS internal controls were not sufficient or were not operating as designed to meet the federal requirements. Questioned costs: None. While VSS was not in compliance with the requirement for tracking and monitoring the federally procured equipment, there were no unallowed costs on equipment purchases made using federal funds. The material noncompliance relates to the context below, as there are no controls in place to ensure compliance with tracking and monitoring requirements. Context: The below issues were noted for both programs tested:  During our testwork we noted no physical inventory was taken during the fiscal year ended June 30, 2022.  The fixed asset listing does not contain the required information to properly identify purchases with federal funds.  VSS does not currently tag assets purchased with federal monies. As such, due to the limited information present on invoices, we were not able to physically inspect all assets.  -VSS does not have controls in place to track purchases with federal funds on a spreadsheet or similar.  Of the 3 assets tested during 2022, none of the listed asset purchases complied with federal requirements. Cause: Lack of established controls and procedures over allowable costs principals, federal requirements for purchases using federal funds, and tracking of purchases made with federal funds. Effect: Possible noncompliance with federal cost principals and monitoring of assets purchased using federal funds. Repeat Finding: 2021-002 Recommendation: We recommend that VSS reviews the current financial policies and procedures in order to better serve the organization in documenting compliance with federal cost principals and requirements. Views of responsible officials: VSS agrees with CLA and has updated our policies over equipment tracking and purchasing in FY 2023. We have created a tracking system and installed asset tags on all equipment over our capitalization amount. A physical inventory will be conducted at the end of the fiscal year to ensure equipment is accounted for and in use.

Categories

Equipment & Real Property Management

Other Findings in this Audit

  • 555124 2022-002
    Material Weakness Repeat
  • 555125 2022-002
    Material Weakness Repeat
  • 555126 2022-003
    Material Weakness Repeat
  • 555127 2022-003
    Material Weakness Repeat
  • 555128 2022-003
    Material Weakness Repeat
  • 555129 2022-003
    Material Weakness Repeat
  • 555130 2022-003
    Material Weakness Repeat
  • 555131 2022-004
    Material Weakness Repeat
  • 555132 2022-004
    Material Weakness Repeat
  • 555133 2022-004
    Material Weakness Repeat
  • 555134 2022-004
    Material Weakness Repeat
  • 555135 2022-004
    Material Weakness Repeat
  • 555136 2022-005
    Significant Deficiency Repeat
  • 555137 2022-005
    Significant Deficiency Repeat
  • 555138 2022-005
    Significant Deficiency Repeat
  • 555139 2022-005
    Significant Deficiency Repeat
  • 555140 2022-005
    Significant Deficiency Repeat
  • 555141 2022-006
    Significant Deficiency
  • 555142 2022-006
    Significant Deficiency
  • 555143 2022-006
    Significant Deficiency
  • 1131566 2022-002
    Material Weakness Repeat
  • 1131568 2022-003
    Material Weakness Repeat
  • 1131569 2022-003
    Material Weakness Repeat
  • 1131570 2022-003
    Material Weakness Repeat
  • 1131571 2022-003
    Material Weakness Repeat
  • 1131572 2022-003
    Material Weakness Repeat
  • 1131573 2022-004
    Material Weakness Repeat
  • 1131574 2022-004
    Material Weakness Repeat
  • 1131575 2022-004
    Material Weakness Repeat
  • 1131576 2022-004
    Material Weakness Repeat
  • 1131577 2022-004
    Material Weakness Repeat
  • 1131578 2022-005
    Significant Deficiency Repeat
  • 1131579 2022-005
    Significant Deficiency Repeat
  • 1131580 2022-005
    Significant Deficiency Repeat
  • 1131581 2022-005
    Significant Deficiency Repeat
  • 1131582 2022-005
    Significant Deficiency Repeat
  • 1131583 2022-006
    Significant Deficiency
  • 1131584 2022-006
    Significant Deficiency
  • 1131585 2022-006
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
16.575 State of Nm Crime Victims Reparatin Commission (voca) 2022-Va-180 $204,524
14.267 Continuum of Care Program: Nm0129d6b012002 (sah) Fy22 $146,782
14.267 Continuum of Care Program: Nm0056l6b012011 (lvn) $124,983
14.231 Mfa - Emergency Solutions Grant Cares Act (20-02-Vsh-Cae-001) $124,815
16.575 State of Nm Crime Victims Reparatin Commission (voca) 2021-Va-979 $95,574
14.267 Continuum of Care Program: Nm0129d6b011901 (sah) Fy21 $55,524
14.231 Mfa - Emergency Homeless Assistance Program (21-02-Vsh-Eha-001) $32,757
16.017 Sexual Assault Services Program (sasp-A) $32,400
93.671 Family Violence Prevention Services Act Grant (fvpsa) $26,128
14.231 Mfa - Rental Assistance Program (21-02-Vss-Rap-001) $25,391
93.671 Family Violence Prevention Services Act Grant (8581) $20,400
93.671 Family Violence Prevention Services Act Grant (8580) $16,300
93.671 Family Violence Prevention Services Act Grant (caresa) $13,999
16.758 Children's Advocacy Centers National Subgrants (nca) 15pjdp-21-Gk-02759-Jjvo $4,736