Finding Text
Finding 2023-006 Lack of Internal Control over Cash Management Federal Agency: U.S. Department of the Interior and U.S. Department of the Treasury Federal Program: Aid to Tribal Governments (ATG); Consolidated Tribal Government (CTG); and Coronavirus State and Local Fiscal Recovery Funds (CSLFRF), respectively ALN: 15.020 (ATG); 15.021 (CTG); and 21.027 (CSLFRF), respectively Award Numbers: A19AV00203 (ATG); A19AV00203 and A22AV00218 (CTG); and SLFRP4178/4850 (CSLFRF), respectively Award Year: 2021 (ATG); 2021 and 2022 (CTG); and 2021 (CSLFRF), respectively Type of Finding: Material weakness in internal control over compliance and material noncompliance. Criteria: The requirement for cash management as contained in 2 CFR 200.305, states advanced cash payments must be used only for applicable grant programs. Condition and Context: Procedures related to cash management were inadequate to ensure that grant funds drawn down were used for grant expenditures in the applicable program. We compared the unearned revenue balances of the grant funds with the available cash balances at year end. The Village’s cash balances for all governmental funds amounted to $7,546,844 at December 31, 2023. The unearned revenues were $8,138,199 which resulted in a shortfall of $591,355. The ATG and CTG programs had unearned revenue balances of $552,928, and the CSLFRF program had an unearned revenue balance of $6,624,359 as of December 31, 2023. Cause: Lack of internal control over cash management. Effect: The Village requested and received advances for various federal programs to cover expenditures. Cash advances were used to fund other unrelated programs of the Village. Questioned Costs: $591,355, which is the shortfall between cash and cash equivalents and the unearned revenue balances. Repeat Finding: This is a repeat of Finding 2022-003, and since it is a repeat finding we believe this to be a systemic issue. Recommendation: We recommend that the Village monitor grant budgets and drawdowns throughout the year and ensure that program funds are not being lent or borrowed between programs to ensure that unearned revenue balances do not exceed total cash and cash equivalents. Management’s Response: Management concurs with this finding. See corrective action plan.