Audit 299919

FY End
2023-06-30
Total Expended
$3.63M
Findings
2
Programs
6
Organization: Delta Human Resource Agency (TN)
Year: 2023 Accepted: 2024-03-28
Auditor: Crs CPAS

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
388089 2023-001 Significant Deficiency Yes AB
964531 2023-001 Significant Deficiency Yes AB

Contacts

Name Title Type
NKMRULK9GVL7 Nikki Gray Auditee
9014767474 Katie Little Auditor
No contacts on file

Notes to SEFA

Accounting Policies: Note 1 - Basis of Presentation The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal and state award activity of Delta Human Resource Agency under programs of federal and state governments for the year ended June 30, 2023. The information in the Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of Delta Human Resource Agency, it is not intended to and does not present the financial position and changes in net position of Delta Human Resource Agency. Note 2 - Summary of Significant Accounting Principles Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not available or are limited as to reimbursement. The net grant receivable/(unearned) ending balance at June 30, 2023 consists of the following: Grants Receivable/(Unearned): Grantor Receivables $975,579 Unearned Grant Revenue ($4,210) Commodities Inventory ($210,914) Net Grants Receivable/(Unearned) $760,455 Commodities reported as expenditures in the schedule represent the fair value of commodities distributed to participants. Grant revenues in the Statement of Revenues, Expenditures, and Changes in Fund Balance - Governmental Fund include the fair market value of such commodities when received. As a result, total federal cash and non-cash awards expended differ from federal grant revenues by $15,926. Note 3 - Emergency Food Assistance Nonmonetary assistance is reported in the schedule at fair value of the commodities received and disbursed. At June 30, 2023, Delta had food commodities totaling $210,914 in inventory. De Minimis Rate Used: N Rate Explanation: Note 1 - Basis of Presentation The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal and state award activity of Delta Human Resource Agency under programs of federal and state governments for the year ended June 30, 2023. The information in the Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of Delta Human Resource Agency, it is not intended to and does not present the financial position and changes in net position of Delta Human Resource Agency. Note 2 - Summary of Significant Accounting Principles Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not available or are limited as to reimbursement. The net grant receivable/(unearned) ending balance at June 30, 2023 consists of the following: Grants Receivable/(Unearned): Grantor Receivables $975,579 Unearned Grant Revenue ($4,210) Commodities Inventory ($210,914) Net Grants Receivable/(Unearned) $760,455 Commodities reported as expenditures in the schedule represent the fair value of commodities distributed to participants. Grant revenues in the Statement of Revenues, Expenditures, and Changes in Fund Balance - Governmental Fund include the fair market value of such commodities when received. As a result, total federal cash and non-cash awards expended differ from federal grant revenues by $15,926. Note 3 - Emergency Food Assistance Nonmonetary assistance is reported in the schedule at fair value of the commodities received and disbursed. At June 30, 2023, Delta had food commodities totaling $210,914 in inventory.

Finding Details

Finding: Several instances were noted where more hours than worked were turned in for reimbursement from the granting agency. In addition, an instance was noted where a USDA employee's time was charged to the transportation grant. Criteria: The Agency should only request funds they have earned from the granting agency. Cause: The program manager used a spreadsheet to recap the employees' time and did not always reduce the employees' time for the employees' lunch period. As reimbursement requests were prepared the spreadsheet was relied upon instead of the actual timesheet. The instance where the employee's time was charged to the wrong grant was just an oversight. Effect: The Agency received funds in excess of actual earned amounts. Our testing resulted in $694.08 of potential questioned costs. Recommendation: If the program manager is going to use a spreadsheet, extra caution needs to be taken to ensure the amounts are transferred correctly. Also the deputy director should either rely on the actual timesheet or verify the spreadsheet matches the timesheet prior to reimbursement request. The Agency needs to take extra caution reviewing employees time as it relates to each program. Management's Response: We concur with this finding.
Finding: Several instances were noted where more hours than worked were turned in for reimbursement from the granting agency. In addition, an instance was noted where a USDA employee's time was charged to the transportation grant. Criteria: The Agency should only request funds they have earned from the granting agency. Cause: The program manager used a spreadsheet to recap the employees' time and did not always reduce the employees' time for the employees' lunch period. As reimbursement requests were prepared the spreadsheet was relied upon instead of the actual timesheet. The instance where the employee's time was charged to the wrong grant was just an oversight. Effect: The Agency received funds in excess of actual earned amounts. Our testing resulted in $694.08 of potential questioned costs. Recommendation: If the program manager is going to use a spreadsheet, extra caution needs to be taken to ensure the amounts are transferred correctly. Also the deputy director should either rely on the actual timesheet or verify the spreadsheet matches the timesheet prior to reimbursement request. The Agency needs to take extra caution reviewing employees time as it relates to each program. Management's Response: We concur with this finding.