Audit 315155

FY End
2021-10-31
Total Expended
$26.56M
Findings
16
Programs
8
Year: 2021 Accepted: 2024-07-15

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
478526 2021-004 Material Weakness - B
478527 2021-005 Material Weakness - N
478528 2021-005 Material Weakness - N
478529 2021-005 Material Weakness - N
478530 2021-005 Material Weakness - N
478531 2021-005 Material Weakness - N
478532 2021-005 Material Weakness - N
478533 2021-005 Material Weakness - N
1054968 2021-004 Material Weakness - B
1054969 2021-005 Material Weakness - N
1054970 2021-005 Material Weakness - N
1054971 2021-005 Material Weakness - N
1054972 2021-005 Material Weakness - N
1054973 2021-005 Material Weakness - N
1054974 2021-005 Material Weakness - N
1054975 2021-005 Material Weakness - N

Contacts

Name Title Type
X3LDT2QDNVF9 Brenda Rivers Auditee
6143324019 Timothy Grant Auditor
No contacts on file

Notes to SEFA

Title: NOTE A – 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 Uniform Guidance wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: CDCFC has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal award activity of Child Development Council of Franklin County (CDCFC) under programs of the federal government for the year ended October 31, 2021. The information on this Schedule is prepared 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 CDCFC, it is not intended to and does not present the financial position, changes in net position, or cash flows of CDCFC.
Title: NOTE B – SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES 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 Uniform Guidance wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: CDCFC has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement.
Title: NOTE C – INDIRECT COST RATE 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 Uniform Guidance wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: CDCFC has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. CDCFC has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance.
Title: NOTE D - MATCHING REQUIREMENTS 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 Uniform Guidance wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: CDCFC has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. Certain Federal programs require CDCFC to contribute non-Federal funds (matching funds) to support the Federally-funded programs. CDCFC has met its matching requirements. The Schedule does not include the expenditure of non-Federal matching funds.
Title: NOTE E – CHILD NUTRITION CLUSTER 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 Uniform Guidance wherein certain types of expenditures may or may not be allowable or may be limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: CDCFC has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. CDCFC commingles cash receipts from the U.S. Department of Agriculture with similar State grants. When reporting expenditures on this Schedule, CDCFC assumes it expends federal monies first.

Finding Details

Payroll Processing - Condition:There was a lack of internal control oversight over the payroll process such that it allowed several instances and inconsistencies in the entity’s payroll records and processing. Cause: We noted for 3 out of 20 sample selections that the hours recorded in the timesheets did not match the hours paid per the payroll journal. Effect: CDCFC payroll internal controls did not prevent or detect errors in their payroll processing system and did not provide for the timely corrections of those errors. Management informed us that their payroll processing system locks timecards at the end of the payroll period each week. Once the timecards are locked, no further changes can be made to the timecards by managers or payroll administrators. CDCFC’s payroll process requires payroll administrators to confirm with supervisors that the hours reported in timecards are correct. Any changes are done directly to the pay grid. However, the confirmation process does not appear to adequately documents these revisions. CDCFC informed us that their process is done verbally by phone calls. Result: The payroll system is not adequately documenting any revisions in timecard processing. We believe this payroll processing could allow errors to occur. It was not practical to determine the rate of occurrence of these payroll processing overrides or to verify the proper corrections were being made.
Monitoring and Tracking Grant Expenses - Condition: During the audit of the Schedule of Expenditures of Federal Awards (SEFA), it was noted that CDCFC lacks proper monitoring mechanisms to accurately track and report expenditures by each specific program. Cause: Personnel responsible for program grant reporting and compliance may not have sufficient technical expertise, training or supervision due to significant change in the management team composition. Effect: Without adequate guidance, tracking and monitoring systems being in place, there is a risk of inaccurate reporting of federal expenditures, which could result in noncompliance with federal regulations and misallocation of funds. Result: We noted during the audit difficulties in management being able to provide us with supporting information that would allow the auditors to reconcile the SEFA to the financial statements based on the grant program involved. In addition, management’s basis for reporting expenses on a functional basis could not be verified. We noted significant allocation differences in expenses in 2021 as compared to prior year expense allocations.
Monitoring and Tracking Grant Expenses - Condition: During the audit of the Schedule of Expenditures of Federal Awards (SEFA), it was noted that CDCFC lacks proper monitoring mechanisms to accurately track and report expenditures by each specific program. Cause: Personnel responsible for program grant reporting and compliance may not have sufficient technical expertise, training or supervision due to significant change in the management team composition. Effect: Without adequate guidance, tracking and monitoring systems being in place, there is a risk of inaccurate reporting of federal expenditures, which could result in noncompliance with federal regulations and misallocation of funds. Result: We noted during the audit difficulties in management being able to provide us with supporting information that would allow the auditors to reconcile the SEFA to the financial statements based on the grant program involved. In addition, management’s basis for reporting expenses on a functional basis could not be verified. We noted significant allocation differences in expenses in 2021 as compared to prior year expense allocations.
Monitoring and Tracking Grant Expenses - Condition: During the audit of the Schedule of Expenditures of Federal Awards (SEFA), it was noted that CDCFC lacks proper monitoring mechanisms to accurately track and report expenditures by each specific program. Cause: Personnel responsible for program grant reporting and compliance may not have sufficient technical expertise, training or supervision due to significant change in the management team composition. Effect: Without adequate guidance, tracking and monitoring systems being in place, there is a risk of inaccurate reporting of federal expenditures, which could result in noncompliance with federal regulations and misallocation of funds. Result: We noted during the audit difficulties in management being able to provide us with supporting information that would allow the auditors to reconcile the SEFA to the financial statements based on the grant program involved. In addition, management’s basis for reporting expenses on a functional basis could not be verified. We noted significant allocation differences in expenses in 2021 as compared to prior year expense allocations.
Monitoring and Tracking Grant Expenses - Condition: During the audit of the Schedule of Expenditures of Federal Awards (SEFA), it was noted that CDCFC lacks proper monitoring mechanisms to accurately track and report expenditures by each specific program. Cause: Personnel responsible for program grant reporting and compliance may not have sufficient technical expertise, training or supervision due to significant change in the management team composition. Effect: Without adequate guidance, tracking and monitoring systems being in place, there is a risk of inaccurate reporting of federal expenditures, which could result in noncompliance with federal regulations and misallocation of funds. Result: We noted during the audit difficulties in management being able to provide us with supporting information that would allow the auditors to reconcile the SEFA to the financial statements based on the grant program involved. In addition, management’s basis for reporting expenses on a functional basis could not be verified. We noted significant allocation differences in expenses in 2021 as compared to prior year expense allocations.
Monitoring and Tracking Grant Expenses - Condition: During the audit of the Schedule of Expenditures of Federal Awards (SEFA), it was noted that CDCFC lacks proper monitoring mechanisms to accurately track and report expenditures by each specific program. Cause: Personnel responsible for program grant reporting and compliance may not have sufficient technical expertise, training or supervision due to significant change in the management team composition. Effect: Without adequate guidance, tracking and monitoring systems being in place, there is a risk of inaccurate reporting of federal expenditures, which could result in noncompliance with federal regulations and misallocation of funds. Result: We noted during the audit difficulties in management being able to provide us with supporting information that would allow the auditors to reconcile the SEFA to the financial statements based on the grant program involved. In addition, management’s basis for reporting expenses on a functional basis could not be verified. We noted significant allocation differences in expenses in 2021 as compared to prior year expense allocations.
Monitoring and Tracking Grant Expenses - Condition: During the audit of the Schedule of Expenditures of Federal Awards (SEFA), it was noted that CDCFC lacks proper monitoring mechanisms to accurately track and report expenditures by each specific program. Cause: Personnel responsible for program grant reporting and compliance may not have sufficient technical expertise, training or supervision due to significant change in the management team composition. Effect: Without adequate guidance, tracking and monitoring systems being in place, there is a risk of inaccurate reporting of federal expenditures, which could result in noncompliance with federal regulations and misallocation of funds. Result: We noted during the audit difficulties in management being able to provide us with supporting information that would allow the auditors to reconcile the SEFA to the financial statements based on the grant program involved. In addition, management’s basis for reporting expenses on a functional basis could not be verified. We noted significant allocation differences in expenses in 2021 as compared to prior year expense allocations.
Monitoring and Tracking Grant Expenses - Condition: During the audit of the Schedule of Expenditures of Federal Awards (SEFA), it was noted that CDCFC lacks proper monitoring mechanisms to accurately track and report expenditures by each specific program. Cause: Personnel responsible for program grant reporting and compliance may not have sufficient technical expertise, training or supervision due to significant change in the management team composition. Effect: Without adequate guidance, tracking and monitoring systems being in place, there is a risk of inaccurate reporting of federal expenditures, which could result in noncompliance with federal regulations and misallocation of funds. Result: We noted during the audit difficulties in management being able to provide us with supporting information that would allow the auditors to reconcile the SEFA to the financial statements based on the grant program involved. In addition, management’s basis for reporting expenses on a functional basis could not be verified. We noted significant allocation differences in expenses in 2021 as compared to prior year expense allocations.
Payroll Processing - Condition:There was a lack of internal control oversight over the payroll process such that it allowed several instances and inconsistencies in the entity’s payroll records and processing. Cause: We noted for 3 out of 20 sample selections that the hours recorded in the timesheets did not match the hours paid per the payroll journal. Effect: CDCFC payroll internal controls did not prevent or detect errors in their payroll processing system and did not provide for the timely corrections of those errors. Management informed us that their payroll processing system locks timecards at the end of the payroll period each week. Once the timecards are locked, no further changes can be made to the timecards by managers or payroll administrators. CDCFC’s payroll process requires payroll administrators to confirm with supervisors that the hours reported in timecards are correct. Any changes are done directly to the pay grid. However, the confirmation process does not appear to adequately documents these revisions. CDCFC informed us that their process is done verbally by phone calls. Result: The payroll system is not adequately documenting any revisions in timecard processing. We believe this payroll processing could allow errors to occur. It was not practical to determine the rate of occurrence of these payroll processing overrides or to verify the proper corrections were being made.
Monitoring and Tracking Grant Expenses - Condition: During the audit of the Schedule of Expenditures of Federal Awards (SEFA), it was noted that CDCFC lacks proper monitoring mechanisms to accurately track and report expenditures by each specific program. Cause: Personnel responsible for program grant reporting and compliance may not have sufficient technical expertise, training or supervision due to significant change in the management team composition. Effect: Without adequate guidance, tracking and monitoring systems being in place, there is a risk of inaccurate reporting of federal expenditures, which could result in noncompliance with federal regulations and misallocation of funds. Result: We noted during the audit difficulties in management being able to provide us with supporting information that would allow the auditors to reconcile the SEFA to the financial statements based on the grant program involved. In addition, management’s basis for reporting expenses on a functional basis could not be verified. We noted significant allocation differences in expenses in 2021 as compared to prior year expense allocations.
Monitoring and Tracking Grant Expenses - Condition: During the audit of the Schedule of Expenditures of Federal Awards (SEFA), it was noted that CDCFC lacks proper monitoring mechanisms to accurately track and report expenditures by each specific program. Cause: Personnel responsible for program grant reporting and compliance may not have sufficient technical expertise, training or supervision due to significant change in the management team composition. Effect: Without adequate guidance, tracking and monitoring systems being in place, there is a risk of inaccurate reporting of federal expenditures, which could result in noncompliance with federal regulations and misallocation of funds. Result: We noted during the audit difficulties in management being able to provide us with supporting information that would allow the auditors to reconcile the SEFA to the financial statements based on the grant program involved. In addition, management’s basis for reporting expenses on a functional basis could not be verified. We noted significant allocation differences in expenses in 2021 as compared to prior year expense allocations.
Monitoring and Tracking Grant Expenses - Condition: During the audit of the Schedule of Expenditures of Federal Awards (SEFA), it was noted that CDCFC lacks proper monitoring mechanisms to accurately track and report expenditures by each specific program. Cause: Personnel responsible for program grant reporting and compliance may not have sufficient technical expertise, training or supervision due to significant change in the management team composition. Effect: Without adequate guidance, tracking and monitoring systems being in place, there is a risk of inaccurate reporting of federal expenditures, which could result in noncompliance with federal regulations and misallocation of funds. Result: We noted during the audit difficulties in management being able to provide us with supporting information that would allow the auditors to reconcile the SEFA to the financial statements based on the grant program involved. In addition, management’s basis for reporting expenses on a functional basis could not be verified. We noted significant allocation differences in expenses in 2021 as compared to prior year expense allocations.
Monitoring and Tracking Grant Expenses - Condition: During the audit of the Schedule of Expenditures of Federal Awards (SEFA), it was noted that CDCFC lacks proper monitoring mechanisms to accurately track and report expenditures by each specific program. Cause: Personnel responsible for program grant reporting and compliance may not have sufficient technical expertise, training or supervision due to significant change in the management team composition. Effect: Without adequate guidance, tracking and monitoring systems being in place, there is a risk of inaccurate reporting of federal expenditures, which could result in noncompliance with federal regulations and misallocation of funds. Result: We noted during the audit difficulties in management being able to provide us with supporting information that would allow the auditors to reconcile the SEFA to the financial statements based on the grant program involved. In addition, management’s basis for reporting expenses on a functional basis could not be verified. We noted significant allocation differences in expenses in 2021 as compared to prior year expense allocations.
Monitoring and Tracking Grant Expenses - Condition: During the audit of the Schedule of Expenditures of Federal Awards (SEFA), it was noted that CDCFC lacks proper monitoring mechanisms to accurately track and report expenditures by each specific program. Cause: Personnel responsible for program grant reporting and compliance may not have sufficient technical expertise, training or supervision due to significant change in the management team composition. Effect: Without adequate guidance, tracking and monitoring systems being in place, there is a risk of inaccurate reporting of federal expenditures, which could result in noncompliance with federal regulations and misallocation of funds. Result: We noted during the audit difficulties in management being able to provide us with supporting information that would allow the auditors to reconcile the SEFA to the financial statements based on the grant program involved. In addition, management’s basis for reporting expenses on a functional basis could not be verified. We noted significant allocation differences in expenses in 2021 as compared to prior year expense allocations.
Monitoring and Tracking Grant Expenses - Condition: During the audit of the Schedule of Expenditures of Federal Awards (SEFA), it was noted that CDCFC lacks proper monitoring mechanisms to accurately track and report expenditures by each specific program. Cause: Personnel responsible for program grant reporting and compliance may not have sufficient technical expertise, training or supervision due to significant change in the management team composition. Effect: Without adequate guidance, tracking and monitoring systems being in place, there is a risk of inaccurate reporting of federal expenditures, which could result in noncompliance with federal regulations and misallocation of funds. Result: We noted during the audit difficulties in management being able to provide us with supporting information that would allow the auditors to reconcile the SEFA to the financial statements based on the grant program involved. In addition, management’s basis for reporting expenses on a functional basis could not be verified. We noted significant allocation differences in expenses in 2021 as compared to prior year expense allocations.
Monitoring and Tracking Grant Expenses - Condition: During the audit of the Schedule of Expenditures of Federal Awards (SEFA), it was noted that CDCFC lacks proper monitoring mechanisms to accurately track and report expenditures by each specific program. Cause: Personnel responsible for program grant reporting and compliance may not have sufficient technical expertise, training or supervision due to significant change in the management team composition. Effect: Without adequate guidance, tracking and monitoring systems being in place, there is a risk of inaccurate reporting of federal expenditures, which could result in noncompliance with federal regulations and misallocation of funds. Result: We noted during the audit difficulties in management being able to provide us with supporting information that would allow the auditors to reconcile the SEFA to the financial statements based on the grant program involved. In addition, management’s basis for reporting expenses on a functional basis could not be verified. We noted significant allocation differences in expenses in 2021 as compared to prior year expense allocations.