Audit 53600

FY End
2022-06-30
Total Expended
$6.66M
Findings
14
Programs
12
Organization: Clintondale Community Schools (MI)
Year: 2022 Accepted: 2022-11-02
Auditor: Lewis & Knopf PC

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
50644 2022-003 Material Weakness - C
50645 2022-004 Material Weakness - B
50646 2022-004 Material Weakness - B
50647 2022-004 Material Weakness - B
50648 2022-004 Material Weakness - B
50649 2022-002 Material Weakness - C
50650 2022-002 Material Weakness - C
627086 2022-003 Material Weakness - C
627087 2022-004 Material Weakness - B
627088 2022-004 Material Weakness - B
627089 2022-004 Material Weakness - B
627090 2022-004 Material Weakness - B
627091 2022-002 Material Weakness - C
627092 2022-002 Material Weakness - C

Contacts

Name Title Type
UEWXM9NZWUH3 Rodriguez Broadnax Auditee
5867916300 Akshay Kapoor, CPA Auditor
No contacts on file

Notes to SEFA

Accounting Policies: Summary of Significant Accounting Policies - Expenditures reported on the schedule are reported on the modified accrual basis of accounting. Expenditures are recognized following the cost principles in the Uniform Guidance as applicable, wherein certain types of expenditures are not allowable or are limited as to reimbursement.Negative amounts (if any) shown on the schedule represent adjustments or credits made in the normal courseof business to amounts reported as expenditures in prior years. Pass-through entity identifying numbersare presented where available.Noncash Assistance - The value of noncash assistance received was determined in accordance with the provisionsof the Uniform Guidance. The grantee received no noncash assistance during the year ended June 30, 2022 thatis not included on the schedule of expenditures of federal awards.The District did not pass-through any federal awards to sub recipients.The District made adjustments of $18,758 to correct amounts incorrectly recorded to deferred revenue.($16,776 was for the Title I ALN 84.010 and $1,982 for the GSRP ALN 84.425) De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.

Finding Details

Finding 2022-003 Program Name ? GSRP State Fiscal Recovery Funds (ALN 84.425) Pass-through Entity ?? Macomb ISD Finding Type ? Cash Management (Material Weakness) Criteria ? Requests for cash reimbursements for the program should not occur before expenditures have been incurred. Amounts for payroll related expenditures were requested before they were actually incurred. Condition ? The District requested cash reimbursement in excess of expenditures for the program listed above. Questioned Costs ? $1,982 Context ? Subsequent to the final draw request, the District posted journal entries to remove 147c retirement expenses that were accrued. This resulted in a reduction of total GSRP expenses that caused the grant revenues to be greater than expenses. Cause/Effect ? The District requested cash in excess of expenditures in the amount of $1,982. Recommendation: We recommend that the District has an additional responsible party who has knowledge of the grant review the transactions and any adjustments to the amounts charged to the grant before reimbursement requests are made.
Finding 2022-004 Program Name ? Special Education Cluster (ALN 84.027/84.173) Pass-through Entity ?? Macomb ISD Finding Type ? Allowable Costs (Material Weakness) Criteria ? District had material weakness with Allowable Costs requirement of preparing time certifications for employees charged to federal grants. Condition ? The District could not provide semi-annual time certs/PARs. Questioned Costs ? Undeterminable Context ? Due to turnover of key positions, the District neglected to prepare time certifications during the 21-22 year. Cause/Effect ? The potential misstatement is undeterminable Recommendation: We recommend that the District has a responsible party who has knowledge of the federal grants prepare time certifications semi-annually for employees charged to the federal grants.
Finding 2022-004 Program Name ? Special Education Cluster (ALN 84.027/84.173) Pass-through Entity ?? Macomb ISD Finding Type ? Allowable Costs (Material Weakness) Criteria ? District had material weakness with Allowable Costs requirement of preparing time certifications for employees charged to federal grants. Condition ? The District could not provide semi-annual time certs/PARs. Questioned Costs ? Undeterminable Context ? Due to turnover of key positions, the District neglected to prepare time certifications during the 21-22 year. Cause/Effect ? The potential misstatement is undeterminable Recommendation: We recommend that the District has a responsible party who has knowledge of the federal grants prepare time certifications semi-annually for employees charged to the federal grants.
Finding 2022-004 Program Name ? Special Education Cluster (ALN 84.027/84.173) Pass-through Entity ?? Macomb ISD Finding Type ? Allowable Costs (Material Weakness) Criteria ? District had material weakness with Allowable Costs requirement of preparing time certifications for employees charged to federal grants. Condition ? The District could not provide semi-annual time certs/PARs. Questioned Costs ? Undeterminable Context ? Due to turnover of key positions, the District neglected to prepare time certifications during the 21-22 year. Cause/Effect ? The potential misstatement is undeterminable Recommendation: We recommend that the District has a responsible party who has knowledge of the federal grants prepare time certifications semi-annually for employees charged to the federal grants.
Finding 2022-004 Program Name ? Special Education Cluster (ALN 84.027/84.173) Pass-through Entity ?? Macomb ISD Finding Type ? Allowable Costs (Material Weakness) Criteria ? District had material weakness with Allowable Costs requirement of preparing time certifications for employees charged to federal grants. Condition ? The District could not provide semi-annual time certs/PARs. Questioned Costs ? Undeterminable Context ? Due to turnover of key positions, the District neglected to prepare time certifications during the 21-22 year. Cause/Effect ? The potential misstatement is undeterminable Recommendation: We recommend that the District has a responsible party who has knowledge of the federal grants prepare time certifications semi-annually for employees charged to the federal grants.
Finding 2022-002 Program Name ? Title I (ALN 84.010) Pass-through Entity ?? Michigan Department of Education Finding Type ? Cash Management (Material Weakness) Criteria ? Requests for cash reimbursements for the program should not occur before expenditures have been incurred. Amounts for payroll related expenditures were requested before they were actually incurred. Condition ? The District requested cash reimbursement in excess of expenditures for the program listed above. Questioned Costs ? $16,776 Context ? The District had previously overdrawn the 19-20 Title I grant, but was able to still correct the final draw as it was discovered prior to 9/30/20. It appears that the District had included this amount in their 20-21 grant, thus overdrawing the 20-21 year as they did not have sufficient expenses to support the total draws requested. Cause/Effect ? The District requested cash in excess of expenditures in the amount of $16,776. Recommendation: We recommend that the District has an additional responsible party who has knowledge of the grant review the transactions and any adjustments to the amounts charged to the grant before reimbursement requests are made.
Finding 2022-002 Program Name ? Title I (ALN 84.010) Pass-through Entity ?? Michigan Department of Education Finding Type ? Cash Management (Material Weakness) Criteria ? Requests for cash reimbursements for the program should not occur before expenditures have been incurred. Amounts for payroll related expenditures were requested before they were actually incurred. Condition ? The District requested cash reimbursement in excess of expenditures for the program listed above. Questioned Costs ? $16,776 Context ? The District had previously overdrawn the 19-20 Title I grant, but was able to still correct the final draw as it was discovered prior to 9/30/20. It appears that the District had included this amount in their 20-21 grant, thus overdrawing the 20-21 year as they did not have sufficient expenses to support the total draws requested. Cause/Effect ? The District requested cash in excess of expenditures in the amount of $16,776. Recommendation: We recommend that the District has an additional responsible party who has knowledge of the grant review the transactions and any adjustments to the amounts charged to the grant before reimbursement requests are made.
Finding 2022-003 Program Name ? GSRP State Fiscal Recovery Funds (ALN 84.425) Pass-through Entity ?? Macomb ISD Finding Type ? Cash Management (Material Weakness) Criteria ? Requests for cash reimbursements for the program should not occur before expenditures have been incurred. Amounts for payroll related expenditures were requested before they were actually incurred. Condition ? The District requested cash reimbursement in excess of expenditures for the program listed above. Questioned Costs ? $1,982 Context ? Subsequent to the final draw request, the District posted journal entries to remove 147c retirement expenses that were accrued. This resulted in a reduction of total GSRP expenses that caused the grant revenues to be greater than expenses. Cause/Effect ? The District requested cash in excess of expenditures in the amount of $1,982. Recommendation: We recommend that the District has an additional responsible party who has knowledge of the grant review the transactions and any adjustments to the amounts charged to the grant before reimbursement requests are made.
Finding 2022-004 Program Name ? Special Education Cluster (ALN 84.027/84.173) Pass-through Entity ?? Macomb ISD Finding Type ? Allowable Costs (Material Weakness) Criteria ? District had material weakness with Allowable Costs requirement of preparing time certifications for employees charged to federal grants. Condition ? The District could not provide semi-annual time certs/PARs. Questioned Costs ? Undeterminable Context ? Due to turnover of key positions, the District neglected to prepare time certifications during the 21-22 year. Cause/Effect ? The potential misstatement is undeterminable Recommendation: We recommend that the District has a responsible party who has knowledge of the federal grants prepare time certifications semi-annually for employees charged to the federal grants.
Finding 2022-004 Program Name ? Special Education Cluster (ALN 84.027/84.173) Pass-through Entity ?? Macomb ISD Finding Type ? Allowable Costs (Material Weakness) Criteria ? District had material weakness with Allowable Costs requirement of preparing time certifications for employees charged to federal grants. Condition ? The District could not provide semi-annual time certs/PARs. Questioned Costs ? Undeterminable Context ? Due to turnover of key positions, the District neglected to prepare time certifications during the 21-22 year. Cause/Effect ? The potential misstatement is undeterminable Recommendation: We recommend that the District has a responsible party who has knowledge of the federal grants prepare time certifications semi-annually for employees charged to the federal grants.
Finding 2022-004 Program Name ? Special Education Cluster (ALN 84.027/84.173) Pass-through Entity ?? Macomb ISD Finding Type ? Allowable Costs (Material Weakness) Criteria ? District had material weakness with Allowable Costs requirement of preparing time certifications for employees charged to federal grants. Condition ? The District could not provide semi-annual time certs/PARs. Questioned Costs ? Undeterminable Context ? Due to turnover of key positions, the District neglected to prepare time certifications during the 21-22 year. Cause/Effect ? The potential misstatement is undeterminable Recommendation: We recommend that the District has a responsible party who has knowledge of the federal grants prepare time certifications semi-annually for employees charged to the federal grants.
Finding 2022-004 Program Name ? Special Education Cluster (ALN 84.027/84.173) Pass-through Entity ?? Macomb ISD Finding Type ? Allowable Costs (Material Weakness) Criteria ? District had material weakness with Allowable Costs requirement of preparing time certifications for employees charged to federal grants. Condition ? The District could not provide semi-annual time certs/PARs. Questioned Costs ? Undeterminable Context ? Due to turnover of key positions, the District neglected to prepare time certifications during the 21-22 year. Cause/Effect ? The potential misstatement is undeterminable Recommendation: We recommend that the District has a responsible party who has knowledge of the federal grants prepare time certifications semi-annually for employees charged to the federal grants.
Finding 2022-002 Program Name ? Title I (ALN 84.010) Pass-through Entity ?? Michigan Department of Education Finding Type ? Cash Management (Material Weakness) Criteria ? Requests for cash reimbursements for the program should not occur before expenditures have been incurred. Amounts for payroll related expenditures were requested before they were actually incurred. Condition ? The District requested cash reimbursement in excess of expenditures for the program listed above. Questioned Costs ? $16,776 Context ? The District had previously overdrawn the 19-20 Title I grant, but was able to still correct the final draw as it was discovered prior to 9/30/20. It appears that the District had included this amount in their 20-21 grant, thus overdrawing the 20-21 year as they did not have sufficient expenses to support the total draws requested. Cause/Effect ? The District requested cash in excess of expenditures in the amount of $16,776. Recommendation: We recommend that the District has an additional responsible party who has knowledge of the grant review the transactions and any adjustments to the amounts charged to the grant before reimbursement requests are made.
Finding 2022-002 Program Name ? Title I (ALN 84.010) Pass-through Entity ?? Michigan Department of Education Finding Type ? Cash Management (Material Weakness) Criteria ? Requests for cash reimbursements for the program should not occur before expenditures have been incurred. Amounts for payroll related expenditures were requested before they were actually incurred. Condition ? The District requested cash reimbursement in excess of expenditures for the program listed above. Questioned Costs ? $16,776 Context ? The District had previously overdrawn the 19-20 Title I grant, but was able to still correct the final draw as it was discovered prior to 9/30/20. It appears that the District had included this amount in their 20-21 grant, thus overdrawing the 20-21 year as they did not have sufficient expenses to support the total draws requested. Cause/Effect ? The District requested cash in excess of expenditures in the amount of $16,776. Recommendation: We recommend that the District has an additional responsible party who has knowledge of the grant review the transactions and any adjustments to the amounts charged to the grant before reimbursement requests are made.