Audit 235552

FY End
2022-06-30
Total Expended
$2.75M
Findings
4
Programs
7
Year: 2022 Accepted: 2023-01-20
Auditor: Bergankdv LTD

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
254944 2022-001 Significant Deficiency - B
254945 2022-001 Significant Deficiency - B
831386 2022-001 Significant Deficiency - B
831387 2022-001 Significant Deficiency - B

Contacts

Name Title Type
FHRNABBHKXC1 Candice Lanning Auditee
3193521108 Brian Aronson Auditor
No contacts on file

Notes to SEFA

Accounting Policies: The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Cedar Valley Friends of the Family, Inc. d/b/a Friends of the Family (the Organization) under programs of the federal government for the year ended June 30, 2022. The information in this 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 the Organization, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the Organization. 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 allowable or are limited to reimbursement. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.

Finding Details

Federal Program: Assistance listing number 14.231, Emergency Solutions Grant Program ? United States Department of Housing and Urban Development. Compliance Requirement: Allowable Costs Criteria: A properly designed system of internal control over compliance allows entities to meet those requirements set forth by the federal government. The Organization is required to ensure that costs are adequately documented. Condition: As part of the Organization's internal controls, all payroll changes are documented with a written letter to employees, a copy of which is maintained in the employee personnel file. Our audit results, which included the testing of twenty-five payroll transactions, indicated the following: - Two items tested had hourly rates paid that did not agree to the letters in the personnel files. These employees were paid the correct approved rates and the letters were determined to be incorrect. - Two items tested had an employee that was not paid at the correct rate, resulting in payroll in excess of approved rates of approximately $127. - One item tested did not have documentation in the personnel file. It was determined that this employee was paid at the correct rate. Cause: As updates are made, there is no review after the fact of the payroll changes and the amounts entered into the payroll system. Questioned Costs: The results of this noncompliance did not result in any questioned costs. Potential Effect: Disqualification from the Emergency Solutions Grant Program. Recommendation: The Organization should establish procedures to ensure wage approval letters are accurate and match payroll records, and all support for pay rates are maintained in personnel files. Responsible Official's Response: Management agrees with the finding and the recommendation.
Federal Program: Assistance listing number 14.231, Emergency Solutions Grant Program ? United States Department of Housing and Urban Development. Compliance Requirement: Allowable Costs Criteria: A properly designed system of internal control over compliance allows entities to meet those requirements set forth by the federal government. The Organization is required to ensure that costs are adequately documented. Condition: As part of the Organization's internal controls, all payroll changes are documented with a written letter to employees, a copy of which is maintained in the employee personnel file. Our audit results, which included the testing of twenty-five payroll transactions, indicated the following: - Two items tested had hourly rates paid that did not agree to the letters in the personnel files. These employees were paid the correct approved rates and the letters were determined to be incorrect. - Two items tested had an employee that was not paid at the correct rate, resulting in payroll in excess of approved rates of approximately $127. - One item tested did not have documentation in the personnel file. It was determined that this employee was paid at the correct rate. Cause: As updates are made, there is no review after the fact of the payroll changes and the amounts entered into the payroll system. Questioned Costs: The results of this noncompliance did not result in any questioned costs. Potential Effect: Disqualification from the Emergency Solutions Grant Program. Recommendation: The Organization should establish procedures to ensure wage approval letters are accurate and match payroll records, and all support for pay rates are maintained in personnel files. Responsible Official's Response: Management agrees with the finding and the recommendation.
Federal Program: Assistance listing number 14.231, Emergency Solutions Grant Program ? United States Department of Housing and Urban Development. Compliance Requirement: Allowable Costs Criteria: A properly designed system of internal control over compliance allows entities to meet those requirements set forth by the federal government. The Organization is required to ensure that costs are adequately documented. Condition: As part of the Organization's internal controls, all payroll changes are documented with a written letter to employees, a copy of which is maintained in the employee personnel file. Our audit results, which included the testing of twenty-five payroll transactions, indicated the following: - Two items tested had hourly rates paid that did not agree to the letters in the personnel files. These employees were paid the correct approved rates and the letters were determined to be incorrect. - Two items tested had an employee that was not paid at the correct rate, resulting in payroll in excess of approved rates of approximately $127. - One item tested did not have documentation in the personnel file. It was determined that this employee was paid at the correct rate. Cause: As updates are made, there is no review after the fact of the payroll changes and the amounts entered into the payroll system. Questioned Costs: The results of this noncompliance did not result in any questioned costs. Potential Effect: Disqualification from the Emergency Solutions Grant Program. Recommendation: The Organization should establish procedures to ensure wage approval letters are accurate and match payroll records, and all support for pay rates are maintained in personnel files. Responsible Official's Response: Management agrees with the finding and the recommendation.
Federal Program: Assistance listing number 14.231, Emergency Solutions Grant Program ? United States Department of Housing and Urban Development. Compliance Requirement: Allowable Costs Criteria: A properly designed system of internal control over compliance allows entities to meet those requirements set forth by the federal government. The Organization is required to ensure that costs are adequately documented. Condition: As part of the Organization's internal controls, all payroll changes are documented with a written letter to employees, a copy of which is maintained in the employee personnel file. Our audit results, which included the testing of twenty-five payroll transactions, indicated the following: - Two items tested had hourly rates paid that did not agree to the letters in the personnel files. These employees were paid the correct approved rates and the letters were determined to be incorrect. - Two items tested had an employee that was not paid at the correct rate, resulting in payroll in excess of approved rates of approximately $127. - One item tested did not have documentation in the personnel file. It was determined that this employee was paid at the correct rate. Cause: As updates are made, there is no review after the fact of the payroll changes and the amounts entered into the payroll system. Questioned Costs: The results of this noncompliance did not result in any questioned costs. Potential Effect: Disqualification from the Emergency Solutions Grant Program. Recommendation: The Organization should establish procedures to ensure wage approval letters are accurate and match payroll records, and all support for pay rates are maintained in personnel files. Responsible Official's Response: Management agrees with the finding and the recommendation.