Audit 38739

FY End
2022-06-30
Total Expended
$1.16M
Findings
2
Programs
11
Year: 2022 Accepted: 2023-03-28

Organization Exclusion Status:

Checking exclusion status...

Contacts

Name Title Type
ZUKLNUHJ41V1 Michelle Walsh Auditee
6365286117 Michele Graham, CPA Auditor
No contacts on file

Notes to SEFA

Title: Note 3 - Basis of Presentation Accounting Policies: 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 as to reimbursements. Some amounts on the Schedule were expended in the year before the Department was awarded the related federal aid. These amounts are included in the Schedule in the period the Department was notified of the award. De Minimis Rate Used: Y Rate Explanation: The Lincoln County Health Department has elected to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Lincoln County Health Department (LCHD) 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 Lincoln County Health Department, it is not intended to and does not present the financial position, or changes in net position of Lincoln County Health Department.
Title: Note 4 - Sub-Recipients Accounting Policies: 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 as to reimbursements. Some amounts on the Schedule were expended in the year before the Department was awarded the related federal aid. These amounts are included in the Schedule in the period the Department was notified of the award. De Minimis Rate Used: Y Rate Explanation: The Lincoln County Health Department has elected to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. There were no awards passed through to sub-recipients.

Finding Details

2022-003 U.S. Department of Health and Human Services, AL No 93.268 Allowable Costs/Cost Principles; Reporting SIGNIFICANT DEFICIENCY IN INTERNAL CONTROL Condition: Controls in place did not provide for the accuracy of the calculated personnel expenses used in program reporting. During our testing, we identified 6 employee pay periods, of the 60 tested with personnel costs incorrectly calculated and reported for the program. As a result amounts reported and requested for reimbursement were not accurate. Criteria: Effective controls over grants insures allowable grant expenses are accurately captured and documented to support reimbursement requests and other reporting requirements. Internal worksheets and other documents prepared for reimbursement and other reporting should be reviewed for accuracy, prior to preparation and submission of the monthly reimbursement request. Cause: LCHD lacked adequate procedures over the accuracy and reporting of COVID-19 program related personnel expenses. This was a result of the immediate emergency response required due to COVID-19 and community needs, putting greater demand and limitations on staff resources. Effect: The testing identified 6 inaccurate pay calculations, resulting in a net $13.17 overbilled to the program in the testing sample. Unallowable costs could be required to be repaid to the grantor. Recommendation: Management should continue to evaluate procedures for capturing, reporting, and maintaining personnel and other expenses related to their various federal award programs. In order to insure accurate information is requested and reported. Procedures should include additional oversight and monitoring over original source data and monthly reporting. Grantee?s Response: Management concurs. During the period under audit management implemented changes to the capturing and reporting of the program personnel costs for the COVID-19 related programs. Changes included; separate time codes to identify the separate COVID-19 personnel costs; and improvements to personnel reports used to calculate and report program personnel costs. No errors were identified in this program after the changes were implemented. LCHD will continue to evaluate their controls with respect to current federal awards and requirements to insure accurate information captured and reported.
2022-003 U.S. Department of Health and Human Services, AL No 93.268 Allowable Costs/Cost Principles; Reporting SIGNIFICANT DEFICIENCY IN INTERNAL CONTROL Condition: Controls in place did not provide for the accuracy of the calculated personnel expenses used in program reporting. During our testing, we identified 6 employee pay periods, of the 60 tested with personnel costs incorrectly calculated and reported for the program. As a result amounts reported and requested for reimbursement were not accurate. Criteria: Effective controls over grants insures allowable grant expenses are accurately captured and documented to support reimbursement requests and other reporting requirements. Internal worksheets and other documents prepared for reimbursement and other reporting should be reviewed for accuracy, prior to preparation and submission of the monthly reimbursement request. Cause: LCHD lacked adequate procedures over the accuracy and reporting of COVID-19 program related personnel expenses. This was a result of the immediate emergency response required due to COVID-19 and community needs, putting greater demand and limitations on staff resources. Effect: The testing identified 6 inaccurate pay calculations, resulting in a net $13.17 overbilled to the program in the testing sample. Unallowable costs could be required to be repaid to the grantor. Recommendation: Management should continue to evaluate procedures for capturing, reporting, and maintaining personnel and other expenses related to their various federal award programs. In order to insure accurate information is requested and reported. Procedures should include additional oversight and monitoring over original source data and monthly reporting. Grantee?s Response: Management concurs. During the period under audit management implemented changes to the capturing and reporting of the program personnel costs for the COVID-19 related programs. Changes included; separate time codes to identify the separate COVID-19 personnel costs; and improvements to personnel reports used to calculate and report program personnel costs. No errors were identified in this program after the changes were implemented. LCHD will continue to evaluate their controls with respect to current federal awards and requirements to insure accurate information captured and reported.