Finding 575660 (2024-002)

-
Requirement
H
Questioned Costs
$1
Year
2024
Accepted
2025-09-05
Audit: 365677
Organization: Chickahominy Indian Tribe (VA)

AI Summary

  • Core Issue: One expenditure of $13,604 under the CCDF ARP grant was not obligated by the required date.
  • Impacted Requirements: Funds must be obligated by the end of the succeeding federal fiscal year and expended by the end of the third fiscal year.
  • Recommended Follow-Up: Establish a formal policy on obligation and liquidation definitions, and ensure it is approved by the Council.

Finding Text

2024-002 Child Care Development Fund Cluster ALN 93.575 and 93,596 Condition There was one expenditure tested under the CCDF American Rescue Plan Act Child Care Supplementary Discretionary grant that did not get obligated by the required date. Criteria Funds should be obligated by the end of the succeeding federal fiscal year after award and expended by the end of the third federal fiscal year. Cause The CCDF ARP Supplementary Discretionary grant was the only grant that did not receive a federal extension or Tribal waiver. The Tribe was under the impression that all CCDF grants would have waivers. Effect One item was not obligated by the required date, total $13,604. Perspective Information One tested of one in the ARP discretionary, but one of 25 in all CCDF. Recommendation We recommend establishing a formal policy regarding definitions of obligation and liquidation. This should be formally approved by Council with a resolution. Views of Responsible Officials and Planned Corrective Action During a meeting prior to the end of the obligation period, we decided how we would use the referenced funds. We documented that decision in the meeting minutes and believed we had met the obligation requirements. The Funding Agency was satisfied with our explanation of the funds being considered obligated, as the Tribes can define obligation in their own terms. However, the actual contract wasn’t executed until after the obligation period was over. In addition, we also thought the obligation and liquidation periods for this particular grant had been extended along with those of similar grants that we have from this agency, but realized later they had not been. We immediately started a review at the beginning of each month of all grants to determine those whose obligation period ends that month. We also review at that time for grants whose liquidation period ends that month. When either of these occur, we issue a notification to Finance Staff to make them aware. We also notify the manager of those grants to ensure they are aware of the obligation and liquidation deadlines. We will also review our Finance Policy and clarify our definition of obligation as needed.

Corrective Action Plan

The Chickahominy Indian Tribe respectfully submits the following corrective action plan for the year ended December 31, 2024. Name and address of independent public accounting firm: Brown, Edwards & Company, L.L.P. 1909 Financial Drive Harrisonburg, Virginia 22801 Audit period: December 31, 2024 The findings from the December 31, 2024 Schedule of Findings and Questioned Costs (the “Schedule”) are discussed below. The findings are numbered consistently with the number assigned in the Schedule. FINDINGS – FINANCIAL STATEMENT AUDIT 2024-001: Material Audit Adjustments (Material Weakness) Condition: Multiple material audit adjustments were proposed. Criteria: Financial information should be materially correct. Cause: The Tribe switched from using an excel spreadsheet to an accounting software for tracking financial information in 2023. During the year, there were reconciliation issues between the software and the spreadsheet which did not get resolved. Material audit adjustments needed to be made to ensure the accuracy of the financial statement, but the cumulative effect of these entries was significantly less than in the prior year. Effect: Audit adjustments were required to ensure the financial statements are materially correct. Recommendation: We do not consider it necessary to reconcile between the Tribal Ledger and Abila; however, we strongly encourage adding a procedure to the monthly bank reconciliations. Bank deposits should be matched to Abila revenue, and bank disbursements to Abila expenses. This will ensure revenues and expenses are properly recorded in addition to ending cash balances being reconciled. Corrective Action: The accounting software is the only source of accounting information now. The Tribal Ledger is no longer being maintained. We continue to learn the intricacies of the new software and the proper way to use it. We are instituting a more formal schedule for review of accounting entries, to ensure they are done in a more timely manner. We have been developing a handbook which will list proper procedures, including proper entry of non- typical transactions. It will also include the procedure for bank reconciliation. We anticipate that material audit adjustments will not be required in the future. FINDINGS AND QUESTIONED COSTS – MAJOR FEDERAL AWARD PROGRAM AUDIT 2024-002: Child Care Development Fund Cluster ALN 93.575 and 93.596 Condition There was one expenditure tested under the CCDF American Rescue Plan Act Child Care Supplementary Discretionary grant that did not get obligated by the required date. Criteria Funds should be obligated by the end of the succeeding federal fiscal year after award and expended by the end of the third federal fiscal year. Cause The CCDF ARP Supplementary Discretionary grant was the only grant that did not receive a federal extension or Tribal waiver. The Tribe was under the impression that all CCDF grants would have waivers. Effect One item was not obligated by the required date, total $13,604. Perspective Information One tested of one in the ARP discretionary, but one of 25 in all CCDF. Recommendation We recommend establishing a formal policy regarding definitions of obligation and liquidation. This should be formally approved by Council with a resolution. Corrective Action: During a meeting prior to the end of the obligation period, we decided how we would use the referenced funds. We documented that decision in the meeting minutes and believed we had met the obligation requirements. The Funding Agency was satisfied with our explanation of the funds being considered obligated, as Tribes can define obligation in their own terms. However, the actual contract wasn’t executed until after the obligation period was over. In addition, we also thought the obligation and liquidation periods for this particular grant had been extended along with those of similar grants that we have from this agency, but realized later that they had not been. We immediately started a review at the beginning of each month of all grants to determine those whose obligation period ends that month. We also review at that time for grants whose liquidation period ends that month. When either of these occurs, I issue a notification to FinanceStaff to make them aware. I also notify the manager of those grants to ensure they are aware of the obligation and liquidation deadlines. We will also review our Financial Policy and clarify our definition of Obligation as needed. If the Federal Audit Clearinghouse has questions regarding this plan, please call Wayne Adkins, First Assistant Chief and Finance Officer at 804-829-2027. Sincerely yours, Wayne Adkins First Assistant Chief and Finance Officer

Categories

Questioned Costs

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $1.36M
93.445 Indian Health Service Sanitation Facilities Construction Program $355,897
93.575 Child Care and Development Block Grant $213,714
93.612 Native American Programs $196,586
93.762 A Comprehensive Approach to Good Health and Wellness in Indian County � Financed Solely by Prevention and Public Health $188,077
93.587 Promote the Survival and Continuing Vitality of Native American Languages $187,997
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $182,378
14.862 Indian Community Development Block Grant Program $181,358
15.024 Indian Self-Determination Contract Support $118,357
11.029 Tribal Broadband Connectivity Program $118,104
11.473 Office for Coastal Management $100,636
66.926 Indian Environmental General Assistance Program (gap) $89,231
15.141 Indian Housing Assistance $77,322
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $62,115
11.307 Economic Adjustment Assistance $57,868
15.020 Aid to Tribal Governments $55,826
93.237 Special Diabetes Program for Indians Diabetes Prevention and Treatment Projects $31,705
93.047 Special Programs for the Aging, Title Vi, Part A, Grants to Indian Tribes, Part B, Grants to Native Hawaiians $26,115
21.032 Local Assistance and Tribal Consistency Fund $21,915
15.041 Environmental Management Indian $20,248
14.867 Indian Housing Block Grants $17,098
21.026 Homeowner Assistance Fund $12,200
66.808 Solid Waste Management Assistance Grants $11,977
15.113 Indian Social Services Welfare Assistance $853