Finding Text
2024-003 – Schedule of Expenditures of Federal Awards Federal program information: Funding Agency: All major program funding agencies Title: All major programs Assistance Listing Number: All major program ALN’s Award Periods: All major program award periods Criteria: 2 CFR section 200.510 (b), requires the Department to prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the Department’s financial statements and the SEFA must include the total awards expended as determined in accordance with 2 CFR §200.502. Condition: Certain federal programs on the SEFA had inaccurate Assistance Listing Numbers (ALN) and/or ALN’s were not included on the initial client prepared SEFA. In addition, several audit adjustments were needed to correct the expenditures reported on the SEFA. Furthermore, significant adjustments were needed to correct the ending and beginning receivable/unearned revenue balances. Lastly, several programs with different ALN’s are included in the same fund and were not broken out on the SEFA. Additional effort was needed to break out the cash receipts and expenditures for each of the different ALN’s. Context: Based on review of the ALN’s and the amounts reported on the SEFA. Questioned Costs: None. Cause: Internal controls were not designed and implemented to ensure accurate preparation of the SEFA. Effect: Revisions were needed to accurately prepare the SEFA by ALN and to ensure expenditures and receivable/unearned revenue balances were properly reported. Without proper internal controls there is the risk that errors and misstatements could exist and not be prevented or detected and corrected on a timely basis. Auditors’ Recommendation: Internal control procedures should be established to ensure that an accurate SEFA is prepared in accordance with 2 CFR §200.502. The SEFA should be reviewed by someone independent from the preparer to verify the accuracy of the information. Beginning balances should agree to the prior year balances. Accrual entries and expense balances should be finalized before the preparation of the SEFA. For the BIE School Grant fund, ensure expenditures and cash receipts are broken out by the different ALN’s on the SEFA. Duckwater Shoshone Tribe Governmental Services Department Schedule of Findings and Questioned Costs — continued For the Year Ended December 31, 2024 Section III — Federal Award Findings and Questioned Costs – continued 2024-003 – Schedule of Expenditures of Federal Awards – continued Management Response: The Finance Department will begin close out work on the year under audit as soon as the year ends, so that all accounts, including expenditures will be accurately adjusted before the SEFA is prepared. Finance will verify all Assistance Listing Numbers on the SEFA. Once the SEFA is prepared, it will be independently reviewed by a contracted CPA before submitting the SEFA to the auditor.