Finding Number: 2022-001Prior Year Finding: 2021-005Federal Agency: U.S. Department of the TreasuryU.S. Department of EducationFederal Program: COVID-19 -Coronavirus State and Local Fiscal Recovery FundsCOVID-19 - Education Stabilization FundSupporting Effective Instruction State Grants (formerlyImproving Teacher Quality State Grants)Assistance Listing: 21.027, 84.425C,D,U,W, 84.367Pass-Through Entity: Maryland State Department of EducationPass-Through AwardNumber and Period:211838-01 (3/3/21 ? 12/31/24) 211815-01 (3/3/21 ? 12/31/24)211875-01 (3/3/21 ? 12/31/24) 201873-01 (3/13/20 ? 9/30/22)201787-01 (3/13/20 ? 9/30/22) 202233-01 (3/13/20 ? 9/30/22)191360-01 (7/1/18 ? 9/30/21) 201067-01 (7/1/19 ? 9/30/21)210781-01 (7/1/20 ? 6/30/22) 221052-01 (7/1/21 ? 6/30/23)Compliance Requirement: ReportingType of Finding Significant Deficiency in Internal Control over Compliance, OtherMattersCriteria or Specific Requirement:Compliance: Per 2 CFR section 200.302(b), financial management systems of non-Federal entitiesmust provide for accurate, current, and complete disclosure of the financial results of each Federalaward or program in accordance with program reporting requirements and provide records that identifyadequately the source and application of funds for federally funded activities. Per Part L of the OMBCompliance Supplement, financial reports must include all activity of the reporting period, be supportedby applicable accounting or performance records, and be fairly presented in accordance with governingrequirements.Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effectiveinternal control over the Federal award that provides reasonable assurance that the non-federal entityis managing the federal award in compliance with federal statutes, regulations, and the terms andconditions of the federal award. These internal controls should comply with the guidance in "Standardsfor Internal Control in the Federal Government" issued by the Comptroller General of the United Statesor the "Internal Control-Integrated Framework," issued by the Committee of Sponsoring Organizationsof the Treadway Commission (COSO). Condition/Context:The Board is required to submit monthly Financial Status Reports (FSR) to the Maryland StateDepartment of Education (MSDE). MSDE utilizes these reports as reimbursement requests andsubsequently submits payment to the board based on reported expenditures. The Final September2021 FSR and its related supporting documentation/reconciliations were not retained. Specifically, wenoted the following:? Education Stabilization Fund: 3 out of 23 grants; 1 out of 5 months? Coronavirus State and Local Fiscal Recovery Fund: 3 out of 16 grants; 1 out of 5 months? Supporting Effective Instruction State Grants: 4 out of 11 grants; 1 out of 3 monthsQuestioned Costs:Undetermined, due to lack of documentation.Cause:The Final September 2021 FSR Reimbursement Request and supporting documentation used toprepare it was not retained.Effect:The lack of reconciliations performed on the differences between the monthly FSR & GL Detail couldresult in inaccurate amounts reported and received for the Federal programs. In addition, the Board didnot have supporting documentation to show controls were in place over expenditure reporting andreimbursement requests.Recommendation:We recommend that the Board review its policies and procedures to ensure that ReimbursementRequests and the detail & accompanying reconciliations used to prepare it are retained for auditpurposes.Views of responsible officials:Management agrees with the finding.
FINDING 2022-002Subject: COVID-19 - Education Stabilization Fund - ReportingFederal Agency: Department of EducationFederal Program: COVID-19 - Education Stabilization FundAssistance Listings Number: 84.425DFederal Award Number and Year (or Other Identifying Number): S425D200013Pass-Through Entity: Indiana Department of EducationCompliance Requirement: ReportingAudit Findings: Material Weakness, Other MattersCondition and ContextAn effective internal control system was not in place at the School Corporation to ensure compliancewith requirements related to the grant agreement and the Reporting compliance requirement.INDIANA STATE BOARD OF ACCOUNTS17SOUTHWEST DUBOIS COUNTY SCHOOL CORPORATIONSCHEDULE OF FINDINGS AND QUESTIONED COSTS(Continued)One of five annual reports required to be completed during the audit period contained materialerrors. The Elementary and Secondary School Emergency Relief (ESSER I), Year 1 annual data reportoverstated total expenditures made between March 13, 2020, and September, 30, 2020, by $130,918. Inaddition, documentation provided for the number of full-time employee positions did not support theamounts reported.The lack of internal controls and noncompliance were systemic issues throughout the audit period.Criteria2 CFR 200.303 states in part:"The non-Federal entity must:(a) Establish and maintain effective internal control over the Federal award that providesreasonable assurance that the non-Federal entity is managing the Federal award incompliance with Federal statutes, regulations, and the terms and conditions of the Federalaward. These internal controls should be in compliance with guidance in 'Standards forInternal Control in the Federal Government' issued by the Comptroller General of theUnited States or the 'Internal Control Integrated Framework', issued by the Committee ofSponsoring Organizations of the Treadway Commission (COSO). . . ."2 CFR 200.334 states in part:"Financial records, supporting documents, statistical records, and all other non-Federal entityrecords pertinent to a Federal award must be retained for a period of three years from the dateof submission of the final expenditure report or, for Federal awards that are renewed quarterlyor annually, from the date of the submission of the quarterly or annual financial report,respectively, as reported to the Federal awarding agency or pass-through entity in the case ofa subrecipient. . . ."2 CFR 200.302(b) states in part:"The financial management system of each non-Federal entity must provide for the following:. . .(2) Accurate, current, and complete disclosure of the financial results of each Federalaward or program in accordance with the reporting requirements set forth in ?? 200.328and 200.329. . . .(3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federalawards, authorizations, obligations, unobligated balances, assets, expenditures,income and interest and be supported by source documentation. . . ."34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and formatthat assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out otherresponsibilities under the program."CauseManagement had not developed a system of internal controls that would have ensured compliancewith the Reporting compliance requirement.INDIANA STATE BOARD OF ACCOUNTS18SOUTHWEST DUBOIS COUNTY SCHOOL CORPORATIONSCHEDULE OF FINDINGS AND QUESTIONED COSTS(Continued)EffectThe failure to establish an effective internal control system enabled material noncompliance to goundetected. Noncompliance with the grant agreement and the Reporting compliance requirement couldresult in the loss of future federal funds to the School Corporation.Questioned CostsThere were no questioned costs identified.RecommendationWe recommended that the School Corporation's management establish internal controls to ensurecompliance and comply with the grant agreement and the Reporting compliance requirement.Views of Responsible OfficialsFor the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-002Subject: COVID-19 - Education Stabilization Fund - ReportingFederal Agency: Department of EducationFederal Program: COVID-19 - Education Stabilization FundAssistance Listings Number: 84.425DFederal Award Number and Year (or Other Identifying Number): S425D200013Pass-Through Entity: Indiana Department of EducationCompliance Requirement: ReportingAudit Findings: Material Weakness, Other MattersCondition and ContextAn effective internal control system was not in place at the School Corporation to ensure compliancewith requirements related to the grant agreement and the Reporting compliance requirement.INDIANA STATE BOARD OF ACCOUNTS17SOUTHWEST DUBOIS COUNTY SCHOOL CORPORATIONSCHEDULE OF FINDINGS AND QUESTIONED COSTS(Continued)One of five annual reports required to be completed during the audit period contained materialerrors. The Elementary and Secondary School Emergency Relief (ESSER I), Year 1 annual data reportoverstated total expenditures made between March 13, 2020, and September, 30, 2020, by $130,918. Inaddition, documentation provided for the number of full-time employee positions did not support theamounts reported.The lack of internal controls and noncompliance were systemic issues throughout the audit period.Criteria2 CFR 200.303 states in part:"The non-Federal entity must:(a) Establish and maintain effective internal control over the Federal award that providesreasonable assurance that the non-Federal entity is managing the Federal award incompliance with Federal statutes, regulations, and the terms and conditions of the Federalaward. These internal controls should be in compliance with guidance in 'Standards forInternal Control in the Federal Government' issued by the Comptroller General of theUnited States or the 'Internal Control Integrated Framework', issued by the Committee ofSponsoring Organizations of the Treadway Commission (COSO). . . ."2 CFR 200.334 states in part:"Financial records, supporting documents, statistical records, and all other non-Federal entityrecords pertinent to a Federal award must be retained for a period of three years from the dateof submission of the final expenditure report or, for Federal awards that are renewed quarterlyor annually, from the date of the submission of the quarterly or annual financial report,respectively, as reported to the Federal awarding agency or pass-through entity in the case ofa subrecipient. . . ."2 CFR 200.302(b) states in part:"The financial management system of each non-Federal entity must provide for the following:. . .(2) Accurate, current, and complete disclosure of the financial results of each Federalaward or program in accordance with the reporting requirements set forth in ?? 200.328and 200.329. . . .(3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federalawards, authorizations, obligations, unobligated balances, assets, expenditures,income and interest and be supported by source documentation. . . ."34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and formatthat assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out otherresponsibilities under the program."CauseManagement had not developed a system of internal controls that would have ensured compliancewith the Reporting compliance requirement.INDIANA STATE BOARD OF ACCOUNTS18SOUTHWEST DUBOIS COUNTY SCHOOL CORPORATIONSCHEDULE OF FINDINGS AND QUESTIONED COSTS(Continued)EffectThe failure to establish an effective internal control system enabled material noncompliance to goundetected. Noncompliance with the grant agreement and the Reporting compliance requirement couldresult in the loss of future federal funds to the School Corporation.Questioned CostsThere were no questioned costs identified.RecommendationWe recommended that the School Corporation's management establish internal controls to ensurecompliance and comply with the grant agreement and the Reporting compliance requirement.Views of Responsible OfficialsFor the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-010Subject: COVID-19 - Education Stabilization Fund - ReportingFederal Agency: Department of EducationFederal Program: COVID-19 - Education Stabilization FundAssistance Listings Numbers: 84.425D, 84.425UFederal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013,S425U210013Pass-Through Entity: Indiana Department of EducationCompliance Requirement: ReportingAudit Findings: Material Weakness, Modified OpinionINDIANA STATE BOARD OF ACCOUNTS33BLACKFORD COUNTY SCHOOLSSCHEDULE OF FINDINGS AND QUESTIONED COSTS(Continued)Condition and ContextAn effective internal control system was not designed or implemented at the School Corporation toensure compliance with requirements related to the grant agreement and the Reporting compliancerequirement.The School Corporation completed and submitted four annual Data Collection reports (Reports) forthe Elementary and Secondary School Emergency Relief (ESSER) grants. For three of the four Reportstested, the Reports were not supported by the unit's records. The financial information provided did notagree to the data submitted in the Reports; therefore, we could not determine the accuracy of the Reports.Additionally, seven of seven key line items selected for testing could not be traced to supporting documentation.The lack of internal controls and noncompliance were systemic issues throughout the audit period.Criteria2 CFR 200.303 states in part:"The non-Federal entity must:(a) Establish and maintain effective internal control over Federal award that providesreasonable assurance that the non-Federal entity is managing the Federal award incompliance with Federal statutes, regulations, and the terms and conditions of the Federalaward. These internal controls should be in compliance with guidance in 'Standards forInternal Control in the Federal Government' issued by the Comptroller General of theUnited States or the 'Internal Control Integrated Framework', issued by the Committee ofSponsoring Organizations of the Treadway Commission (COSO). . . ."2 CFR 200.302(b) states in part:"The financial management system of each non-Federal entity must provide for the following:. . .(2) Accurate, current, and complete disclosure of the financial results of each Federalaward or program in accordance with the reporting requirements set forth in?? 200.328 and 200.329. . . ."34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and formatthat assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out otherresponsibilities under the program."2 CFR 200.334 states in part:"Financial records, supporting documents, statistical records, and all other non-Federal entityrecords pertinent to a Federal award must be retained for a period of three years from the dateof submission of the final expenditure report or, for Federal awards that are renewed quarterlyor annually, from the date of the submission of the quarterly or annual financial report,respectively, as reported to the Federal awarding agency or pass-through entity in the case ofa subrecipient. . . ."INDIANA STATE BOARD OF ACCOUNTS34BLACKFORD COUNTY SCHOOLSSCHEDULE OF FINDINGS AND QUESTIONED COSTS(Continued)34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance withprogram requirements."CauseManagement had not developed a system of internal controls that would have ensured compliancewith the Reporting compliance requirement.EffectThe failure to design and implement an effective internal control system enabled noncompliance togo undetected with the Reporting compliance requirement.Questioned CostsThere were no questioned costs identified.RecommendationWe recommended that the School Corporation's management establish effective internal controlsto ensure compliance and comply with the grant agreement and the Reporting compliance requirement.Views of Responsible OfficialsFor the views of responsible officials, refer to the Corrective Action Plan that is part of this report.INDIANA STATE BOARD OF ACCOUNTS35
FINDING 2022-010Subject: COVID-19 - Education Stabilization Fund - ReportingFederal Agency: Department of EducationFederal Program: COVID-19 - Education Stabilization FundAssistance Listings Numbers: 84.425D, 84.425UFederal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013,S425U210013Pass-Through Entity: Indiana Department of EducationCompliance Requirement: ReportingAudit Findings: Material Weakness, Modified OpinionINDIANA STATE BOARD OF ACCOUNTS33BLACKFORD COUNTY SCHOOLSSCHEDULE OF FINDINGS AND QUESTIONED COSTS(Continued)Condition and ContextAn effective internal control system was not designed or implemented at the School Corporation toensure compliance with requirements related to the grant agreement and the Reporting compliancerequirement.The School Corporation completed and submitted four annual Data Collection reports (Reports) forthe Elementary and Secondary School Emergency Relief (ESSER) grants. For three of the four Reportstested, the Reports were not supported by the unit's records. The financial information provided did notagree to the data submitted in the Reports; therefore, we could not determine the accuracy of the Reports.Additionally, seven of seven key line items selected for testing could not be traced to supporting documentation.The lack of internal controls and noncompliance were systemic issues throughout the audit period.Criteria2 CFR 200.303 states in part:"The non-Federal entity must:(a) Establish and maintain effective internal control over Federal award that providesreasonable assurance that the non-Federal entity is managing the Federal award incompliance with Federal statutes, regulations, and the terms and conditions of the Federalaward. These internal controls should be in compliance with guidance in 'Standards forInternal Control in the Federal Government' issued by the Comptroller General of theUnited States or the 'Internal Control Integrated Framework', issued by the Committee ofSponsoring Organizations of the Treadway Commission (COSO). . . ."2 CFR 200.302(b) states in part:"The financial management system of each non-Federal entity must provide for the following:. . .(2) Accurate, current, and complete disclosure of the financial results of each Federalaward or program in accordance with the reporting requirements set forth in?? 200.328 and 200.329. . . ."34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and formatthat assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out otherresponsibilities under the program."2 CFR 200.334 states in part:"Financial records, supporting documents, statistical records, and all other non-Federal entityrecords pertinent to a Federal award must be retained for a period of three years from the dateof submission of the final expenditure report or, for Federal awards that are renewed quarterlyor annually, from the date of the submission of the quarterly or annual financial report,respectively, as reported to the Federal awarding agency or pass-through entity in the case ofa subrecipient. . . ."INDIANA STATE BOARD OF ACCOUNTS34BLACKFORD COUNTY SCHOOLSSCHEDULE OF FINDINGS AND QUESTIONED COSTS(Continued)34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance withprogram requirements."CauseManagement had not developed a system of internal controls that would have ensured compliancewith the Reporting compliance requirement.EffectThe failure to design and implement an effective internal control system enabled noncompliance togo undetected with the Reporting compliance requirement.Questioned CostsThere were no questioned costs identified.RecommendationWe recommended that the School Corporation's management establish effective internal controlsto ensure compliance and comply with the grant agreement and the Reporting compliance requirement.Views of Responsible OfficialsFor the views of responsible officials, refer to the Corrective Action Plan that is part of this report.INDIANA STATE BOARD OF ACCOUNTS35
FINDING 2022-010Subject: COVID-19 - Education Stabilization Fund - ReportingFederal Agency: Department of EducationFederal Program: COVID-19 - Education Stabilization FundAssistance Listings Numbers: 84.425D, 84.425UFederal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013,S425U210013Pass-Through Entity: Indiana Department of EducationCompliance Requirement: ReportingAudit Findings: Material Weakness, Modified OpinionINDIANA STATE BOARD OF ACCOUNTS33BLACKFORD COUNTY SCHOOLSSCHEDULE OF FINDINGS AND QUESTIONED COSTS(Continued)Condition and ContextAn effective internal control system was not designed or implemented at the School Corporation toensure compliance with requirements related to the grant agreement and the Reporting compliancerequirement.The School Corporation completed and submitted four annual Data Collection reports (Reports) forthe Elementary and Secondary School Emergency Relief (ESSER) grants. For three of the four Reportstested, the Reports were not supported by the unit's records. The financial information provided did notagree to the data submitted in the Reports; therefore, we could not determine the accuracy of the Reports.Additionally, seven of seven key line items selected for testing could not be traced to supporting documentation.The lack of internal controls and noncompliance were systemic issues throughout the audit period.Criteria2 CFR 200.303 states in part:"The non-Federal entity must:(a) Establish and maintain effective internal control over Federal award that providesreasonable assurance that the non-Federal entity is managing the Federal award incompliance with Federal statutes, regulations, and the terms and conditions of the Federalaward. These internal controls should be in compliance with guidance in 'Standards forInternal Control in the Federal Government' issued by the Comptroller General of theUnited States or the 'Internal Control Integrated Framework', issued by the Committee ofSponsoring Organizations of the Treadway Commission (COSO). . . ."2 CFR 200.302(b) states in part:"The financial management system of each non-Federal entity must provide for the following:. . .(2) Accurate, current, and complete disclosure of the financial results of each Federalaward or program in accordance with the reporting requirements set forth in?? 200.328 and 200.329. . . ."34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and formatthat assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out otherresponsibilities under the program."2 CFR 200.334 states in part:"Financial records, supporting documents, statistical records, and all other non-Federal entityrecords pertinent to a Federal award must be retained for a period of three years from the dateof submission of the final expenditure report or, for Federal awards that are renewed quarterlyor annually, from the date of the submission of the quarterly or annual financial report,respectively, as reported to the Federal awarding agency or pass-through entity in the case ofa subrecipient. . . ."INDIANA STATE BOARD OF ACCOUNTS34BLACKFORD COUNTY SCHOOLSSCHEDULE OF FINDINGS AND QUESTIONED COSTS(Continued)34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance withprogram requirements."CauseManagement had not developed a system of internal controls that would have ensured compliancewith the Reporting compliance requirement.EffectThe failure to design and implement an effective internal control system enabled noncompliance togo undetected with the Reporting compliance requirement.Questioned CostsThere were no questioned costs identified.RecommendationWe recommended that the School Corporation's management establish effective internal controlsto ensure compliance and comply with the grant agreement and the Reporting compliance requirement.Views of Responsible OfficialsFor the views of responsible officials, refer to the Corrective Action Plan that is part of this report.INDIANA STATE BOARD OF ACCOUNTS35
FINDING 2022-010Subject: COVID-19 - Education Stabilization Fund - ReportingFederal Agency: Department of EducationFederal Program: COVID-19 - Education Stabilization FundAssistance Listings Numbers: 84.425D, 84.425UFederal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013,S425U210013Pass-Through Entity: Indiana Department of EducationCompliance Requirement: ReportingAudit Findings: Material Weakness, Modified OpinionINDIANA STATE BOARD OF ACCOUNTS33BLACKFORD COUNTY SCHOOLSSCHEDULE OF FINDINGS AND QUESTIONED COSTS(Continued)Condition and ContextAn effective internal control system was not designed or implemented at the School Corporation toensure compliance with requirements related to the grant agreement and the Reporting compliancerequirement.The School Corporation completed and submitted four annual Data Collection reports (Reports) forthe Elementary and Secondary School Emergency Relief (ESSER) grants. For three of the four Reportstested, the Reports were not supported by the unit's records. The financial information provided did notagree to the data submitted in the Reports; therefore, we could not determine the accuracy of the Reports.Additionally, seven of seven key line items selected for testing could not be traced to supporting documentation.The lack of internal controls and noncompliance were systemic issues throughout the audit period.Criteria2 CFR 200.303 states in part:"The non-Federal entity must:(a) Establish and maintain effective internal control over Federal award that providesreasonable assurance that the non-Federal entity is managing the Federal award incompliance with Federal statutes, regulations, and the terms and conditions of the Federalaward. These internal controls should be in compliance with guidance in 'Standards forInternal Control in the Federal Government' issued by the Comptroller General of theUnited States or the 'Internal Control Integrated Framework', issued by the Committee ofSponsoring Organizations of the Treadway Commission (COSO). . . ."2 CFR 200.302(b) states in part:"The financial management system of each non-Federal entity must provide for the following:. . .(2) Accurate, current, and complete disclosure of the financial results of each Federalaward or program in accordance with the reporting requirements set forth in?? 200.328 and 200.329. . . ."34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and formatthat assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out otherresponsibilities under the program."2 CFR 200.334 states in part:"Financial records, supporting documents, statistical records, and all other non-Federal entityrecords pertinent to a Federal award must be retained for a period of three years from the dateof submission of the final expenditure report or, for Federal awards that are renewed quarterlyor annually, from the date of the submission of the quarterly or annual financial report,respectively, as reported to the Federal awarding agency or pass-through entity in the case ofa subrecipient. . . ."INDIANA STATE BOARD OF ACCOUNTS34BLACKFORD COUNTY SCHOOLSSCHEDULE OF FINDINGS AND QUESTIONED COSTS(Continued)34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance withprogram requirements."CauseManagement had not developed a system of internal controls that would have ensured compliancewith the Reporting compliance requirement.EffectThe failure to design and implement an effective internal control system enabled noncompliance togo undetected with the Reporting compliance requirement.Questioned CostsThere were no questioned costs identified.RecommendationWe recommended that the School Corporation's management establish effective internal controlsto ensure compliance and comply with the grant agreement and the Reporting compliance requirement.Views of Responsible OfficialsFor the views of responsible officials, refer to the Corrective Action Plan that is part of this report.INDIANA STATE BOARD OF ACCOUNTS35
FINDING 2022-005Subject: COVID-19 - Education Stabilization Fund - ReportingFederal Agency: Department of EducationFederal Program: COVID-19 - Education Stabilization FundAssistance Listings Number: 84.425DFederal Award Number and Year (or Other Identifying Number): S425D200013Pass-Through Entity: Indiana Department of EducationCompliance Requirement: ReportingAudit Findings: Material Weakness, Other MattersINDIANA STATE BOARD OF ACCOUNTS22MONROE COUNTY COMMUNITY SCHOOL CORPORATIONSCHEDULE OF FINDINGS AND QUESTIONED COSTS(Continued)Condition and ContextAn effective internal control system was not designed nor implemented at the School Corporationto ensure compliance with the requirements related to the grant agreement and the Reporting compliancerequirement.The School Corporation filed the four required Elementary and Secondary School EmergencyRelief (ESSER) annual data reports. However, the ESSER I, Year 1 and ESSER I, Year 2 reports werenot supported by the School Corporation's records. For each of the reports, two key line items wereselected for verification, none of the line items tested were supported by the School Corporation's records.For the ESSER I, Year 2 report the data included expenditures for two months beyond the reporting period.The lack of internal controls and noncompliance were applicable to the ESSER I grant during theaudit period.Criteria2 CFR 200.303 states in part:"The non-Federal entity must:(a) Establish and maintain effective internal control over the Federal award that providesreasonable assurance that the non-Federal entity is managing the Federal award incompliance with Federal statutes, regulations, and the terms and conditions of the Federalaward. These internal controls should be in compliance with guidance in 'Standards forInternal Control in the Federal Government' issued by the Comptroller General of theUnited States or the 'Internal Control Integrated framework', issued by the Committee ofSponsoring Organizations of the Treadway Commission (COSO). . . ."2 CFR 200.334 states in part:"Financial records, supporting documents, statistical records, and all other non-Federal entityrecords pertinent to a Federal award must be retained for a period of three years from the dateof submission of the final expenditure report or, for Federal awards that are renewed quarterlyor annually, from the date of the submission of the quarterly or annual financial report,respectively, as reported to the Federal awarding agency or pass-through entity in the case ofa subrecipient. . . ."2 CFR 200.302(b) states in part:"The financial management system of each non-Federal entity must provide for the following:. . .(2) Accurate, current, and complete disclosure of the financial results of each Federalaward or program in accordance with the reporting requirements set forth in ?? 200.328and 200.329. . . .(3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federalawards, authorizations, obligations, unobligated balances, assets, expenditures,income and interest and be supported by source documentation. . . ."INDIANA STATE BOARD OF ACCOUNTS23MONROE COUNTY COMMUNITY SCHOOL CORPORATIONSCHEDULE OF FINDINGS AND QUESTIONED COSTS(Continued)34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and formatthat assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out otherresponsibilities under the program."CauseManagement had not designed, nor implemented a system of internal controls that would haveensured compliance or that supporting documentation would have been maintained and available for auditrelated to the Reporting compliance requirement.EffectThe failure to retain and provide appropriate supporting documentation prevented the determination of the School Corporation's compliance with the Reporting compliance requirement. Noncompliancewith the grant agreement and the Reporting compliance requirement could result in the loss of future federalfunds to the School Corporation.Questioned CostsThere were no questioned costs identified.RecommendationWe recommended that the School Corporation's management establish a system of internal controls to ensure that documentation will be maintained and available for audit and comply with the grantagreement and the Reporting compliance requirement.Views of Responsible OfficialsFor the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-005Subject: COVID-19 - Education Stabilization Fund - ReportingFederal Agency: Department of EducationFederal Program: COVID-19 - Education Stabilization FundAssistance Listings Number: 84.425DFederal Award Number and Year (or Other Identifying Number): S425D200013Pass-Through Entity: Indiana Department of EducationCompliance Requirement: ReportingAudit Findings: Material Weakness, Other MattersINDIANA STATE BOARD OF ACCOUNTS22MONROE COUNTY COMMUNITY SCHOOL CORPORATIONSCHEDULE OF FINDINGS AND QUESTIONED COSTS(Continued)Condition and ContextAn effective internal control system was not designed nor implemented at the School Corporationto ensure compliance with the requirements related to the grant agreement and the Reporting compliancerequirement.The School Corporation filed the four required Elementary and Secondary School EmergencyRelief (ESSER) annual data reports. However, the ESSER I, Year 1 and ESSER I, Year 2 reports werenot supported by the School Corporation's records. For each of the reports, two key line items wereselected for verification, none of the line items tested were supported by the School Corporation's records.For the ESSER I, Year 2 report the data included expenditures for two months beyond the reporting period.The lack of internal controls and noncompliance were applicable to the ESSER I grant during theaudit period.Criteria2 CFR 200.303 states in part:"The non-Federal entity must:(a) Establish and maintain effective internal control over the Federal award that providesreasonable assurance that the non-Federal entity is managing the Federal award incompliance with Federal statutes, regulations, and the terms and conditions of the Federalaward. These internal controls should be in compliance with guidance in 'Standards forInternal Control in the Federal Government' issued by the Comptroller General of theUnited States or the 'Internal Control Integrated framework', issued by the Committee ofSponsoring Organizations of the Treadway Commission (COSO). . . ."2 CFR 200.334 states in part:"Financial records, supporting documents, statistical records, and all other non-Federal entityrecords pertinent to a Federal award must be retained for a period of three years from the dateof submission of the final expenditure report or, for Federal awards that are renewed quarterlyor annually, from the date of the submission of the quarterly or annual financial report,respectively, as reported to the Federal awarding agency or pass-through entity in the case ofa subrecipient. . . ."2 CFR 200.302(b) states in part:"The financial management system of each non-Federal entity must provide for the following:. . .(2) Accurate, current, and complete disclosure of the financial results of each Federalaward or program in accordance with the reporting requirements set forth in ?? 200.328and 200.329. . . .(3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federalawards, authorizations, obligations, unobligated balances, assets, expenditures,income and interest and be supported by source documentation. . . ."INDIANA STATE BOARD OF ACCOUNTS23MONROE COUNTY COMMUNITY SCHOOL CORPORATIONSCHEDULE OF FINDINGS AND QUESTIONED COSTS(Continued)34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and formatthat assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out otherresponsibilities under the program."CauseManagement had not designed, nor implemented a system of internal controls that would haveensured compliance or that supporting documentation would have been maintained and available for auditrelated to the Reporting compliance requirement.EffectThe failure to retain and provide appropriate supporting documentation prevented the determination of the School Corporation's compliance with the Reporting compliance requirement. Noncompliancewith the grant agreement and the Reporting compliance requirement could result in the loss of future federalfunds to the School Corporation.Questioned CostsThere were no questioned costs identified.RecommendationWe recommended that the School Corporation's management establish a system of internal controls to ensure that documentation will be maintained and available for audit and comply with the grantagreement and the Reporting compliance requirement.Views of Responsible OfficialsFor the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding 2022-002 Significant DeficiencyAssistance Listing: 84.351 C.A.R.E.Condition:Cleveland Play House does not have adequate documentation to support all charges to the federalprogram.Of the 40 payroll charges tested, 26 did not have adequate documentation. In addition, it was notedthat for 2 of the 37 non-payroll charges tested supporting documentation was unable to be located.In addition, management provided an Excel spreadsheet to support the charges that were made to theprogram rather than reporting from their financial management system that is compliant with Section200.302.Criteria:2 CFR 200.403(g) states that for costs to be allowed under Federal awards, they must be adequatelydocumented.In addition, Section 200.302 requires that the financial management system must provide for anidentification, in its accounts, of all federal awards received and expended and the federal programsunder which they were received; an accurate, current, and complete disclosure of the financial resultsof each federal award or program; and a comparison of expenditures with budget amounts for eachfederal award.Cause:Due to significant organizational turnover, individuals were not completing timesheets to documentlevel of effort for federal programs. Although management was verbally communicating with theseindividuals during the year and tracking the time they spent on the program within a spreadsheet, thisis not considered adequate documentation. In addition, and also a result of the turnover, certaindocumentation to support non-payroll expenditures was unable to be located.Effect:Cleveland Play House did not have adequate documentation to support all costs charged to the federalprogram. In addition, an ineffective financial management system could lead to incorrectidentification of costs charged to a federal program and an inability to substantiate that double-chargingdid not occur.Repeat finding:This is not a repeat finding.Questioned costs:Non-payroll: $974Payroll: $20,720Recommendation:We recommend that Cleveland Play House develop a policy and procedure to ensure that all hourssubmitted for federal reimbursement are supported with timesheets that are approved by a supervisor.In addition, staff should be made aware of the policy and procedures to ensure retention ofdocumentation for non-payroll expenditures.Views of responsible officials:Management concurs with this recommendation. See also corrective action plan.
FINDING 2022-005Subject: COVID-19 - Education Stabilization Fund - ReportingFederal Agency: Department of EducationFederal Program: COVID-19 - Education Stabilization FundAssistance Listings Numbers: 84.425D, 84.425UFederal Award Numbers and Years (or Other Identifying Numbers): S425D20013, S425D210013,S425U210013Pass-Through Entity: Indiana Department of EducationCompliance Requirement: ReportingAudit Findings: Material Weakness, Other MattersCondition and ContextAn effective internal control system was not designed, nor implemented, at the School Corporationto ensure compliance with requirements related to the grant agreement and the Reporting compliancerequirement.The School Corporation completed and submitted four annual Data Collection reports (Reports) forthe Elementary and Secondary School Emergency Relief (ESSER) grants. The Reports were prepared byone employee without an oversite or review process in place to prevent, or detect and correct, errors.Additionally, one of the four Reports tested was not supported by the School Corporation's records.The financial information provided did not agree to all the data submitted in the Report; therefore, we couldnot determine the accuracy of the Report. Additionally, two of six key line items selected for testing couldnot be traced to supporting documentation.The lack of internal controls and noncompliance were systemic issues throughout the audit period.Criteria2 CFR 200.303 states in part:"The non-Federal entity must:(a) Establish and maintain effective internal control over the Federal award that providesreasonable assurance that the non-Federal entity is managing the Federal award incompliance with Federal statutes, regulations, and the terms and conditions of the Federalaward. These internal controls should be in compliance with guidance in 'Standards forInternal Control in the Federal Government' issued by the Comptroller General of theUnited States or the 'Internal Control Integrated Framework', issued by the Committee ofSponsoring Organizations of the Treadway Commission (COSO). . . ."2 CFR 200.302(b) states in part:"The financial management system of each non-Federal entity must provide for the following:. . .(2) Accurate, current, and complete disclosure of the financial results of each Federalaward or program in accordance with the reporting requirements set forth in ?? 200.328and 200.329. . . ."34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and formatthat assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out otherresponsibilities under the program."2 CFR 200.334 states in part:"Financial records, supporting documents, statistical records, and all other non-Federal entityrecords pertinent to a Federal award must be retained for a period of three years from the dateof submission of the final expenditure report or, for Federal awards that are renewed quarterlyor annually, from the date of the submission of the quarterly or annual financial report, respectively,as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient.. . ."34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance withprogram requirements."CauseManagement had not developed a system of internal controls that would have ensured compliancewith the Reporting compliance requirement.EffectThe failure to establish an effective internal control system enabled noncompliance to go undetected.Noncompliance with the grant agreement and the Reporting compliance requirement could resultin the loss of future federal funds to the School Corporation.Questioned CostsThere were no questioned costs identified.RecommendationWe recommended that the School Corporation's management establish effective internal controlsto ensure compliance and comply with the grant agreement and the Reporting compliance requirement.Views of Responsible OfficialsFor the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-005Subject: COVID-19 - Education Stabilization Fund - ReportingFederal Agency: Department of EducationFederal Program: COVID-19 - Education Stabilization FundAssistance Listings Numbers: 84.425D, 84.425UFederal Award Numbers and Years (or Other Identifying Numbers): S425D20013, S425D210013,S425U210013Pass-Through Entity: Indiana Department of EducationCompliance Requirement: ReportingAudit Findings: Material Weakness, Other MattersCondition and ContextAn effective internal control system was not designed, nor implemented, at the School Corporationto ensure compliance with requirements related to the grant agreement and the Reporting compliancerequirement.The School Corporation completed and submitted four annual Data Collection reports (Reports) forthe Elementary and Secondary School Emergency Relief (ESSER) grants. The Reports were prepared byone employee without an oversite or review process in place to prevent, or detect and correct, errors.Additionally, one of the four Reports tested was not supported by the School Corporation's records.The financial information provided did not agree to all the data submitted in the Report; therefore, we couldnot determine the accuracy of the Report. Additionally, two of six key line items selected for testing couldnot be traced to supporting documentation.The lack of internal controls and noncompliance were systemic issues throughout the audit period.Criteria2 CFR 200.303 states in part:"The non-Federal entity must:(a) Establish and maintain effective internal control over the Federal award that providesreasonable assurance that the non-Federal entity is managing the Federal award incompliance with Federal statutes, regulations, and the terms and conditions of the Federalaward. These internal controls should be in compliance with guidance in 'Standards forInternal Control in the Federal Government' issued by the Comptroller General of theUnited States or the 'Internal Control Integrated Framework', issued by the Committee ofSponsoring Organizations of the Treadway Commission (COSO). . . ."2 CFR 200.302(b) states in part:"The financial management system of each non-Federal entity must provide for the following:. . .(2) Accurate, current, and complete disclosure of the financial results of each Federalaward or program in accordance with the reporting requirements set forth in ?? 200.328and 200.329. . . ."34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and formatthat assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out otherresponsibilities under the program."2 CFR 200.334 states in part:"Financial records, supporting documents, statistical records, and all other non-Federal entityrecords pertinent to a Federal award must be retained for a period of three years from the dateof submission of the final expenditure report or, for Federal awards that are renewed quarterlyor annually, from the date of the submission of the quarterly or annual financial report, respectively,as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient.. . ."34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance withprogram requirements."CauseManagement had not developed a system of internal controls that would have ensured compliancewith the Reporting compliance requirement.EffectThe failure to establish an effective internal control system enabled noncompliance to go undetected.Noncompliance with the grant agreement and the Reporting compliance requirement could resultin the loss of future federal funds to the School Corporation.Questioned CostsThere were no questioned costs identified.RecommendationWe recommended that the School Corporation's management establish effective internal controlsto ensure compliance and comply with the grant agreement and the Reporting compliance requirement.Views of Responsible OfficialsFor the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-005Subject: COVID-19 - Education Stabilization Fund - ReportingFederal Agency: Department of EducationFederal Program: COVID-19 - Education Stabilization FundAssistance Listings Numbers: 84.425D, 84.425UFederal Award Numbers and Years (or Other Identifying Numbers): S425D20013, S425D210013,S425U210013Pass-Through Entity: Indiana Department of EducationCompliance Requirement: ReportingAudit Findings: Material Weakness, Other MattersCondition and ContextAn effective internal control system was not designed, nor implemented, at the School Corporationto ensure compliance with requirements related to the grant agreement and the Reporting compliancerequirement.The School Corporation completed and submitted four annual Data Collection reports (Reports) forthe Elementary and Secondary School Emergency Relief (ESSER) grants. The Reports were prepared byone employee without an oversite or review process in place to prevent, or detect and correct, errors.Additionally, one of the four Reports tested was not supported by the School Corporation's records.The financial information provided did not agree to all the data submitted in the Report; therefore, we couldnot determine the accuracy of the Report. Additionally, two of six key line items selected for testing couldnot be traced to supporting documentation.The lack of internal controls and noncompliance were systemic issues throughout the audit period.Criteria2 CFR 200.303 states in part:"The non-Federal entity must:(a) Establish and maintain effective internal control over the Federal award that providesreasonable assurance that the non-Federal entity is managing the Federal award incompliance with Federal statutes, regulations, and the terms and conditions of the Federalaward. These internal controls should be in compliance with guidance in 'Standards forInternal Control in the Federal Government' issued by the Comptroller General of theUnited States or the 'Internal Control Integrated Framework', issued by the Committee ofSponsoring Organizations of the Treadway Commission (COSO). . . ."2 CFR 200.302(b) states in part:"The financial management system of each non-Federal entity must provide for the following:. . .(2) Accurate, current, and complete disclosure of the financial results of each Federalaward or program in accordance with the reporting requirements set forth in ?? 200.328and 200.329. . . ."34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and formatthat assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out otherresponsibilities under the program."2 CFR 200.334 states in part:"Financial records, supporting documents, statistical records, and all other non-Federal entityrecords pertinent to a Federal award must be retained for a period of three years from the dateof submission of the final expenditure report or, for Federal awards that are renewed quarterlyor annually, from the date of the submission of the quarterly or annual financial report, respectively,as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient.. . ."34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance withprogram requirements."CauseManagement had not developed a system of internal controls that would have ensured compliancewith the Reporting compliance requirement.EffectThe failure to establish an effective internal control system enabled noncompliance to go undetected.Noncompliance with the grant agreement and the Reporting compliance requirement could resultin the loss of future federal funds to the School Corporation.Questioned CostsThere were no questioned costs identified.RecommendationWe recommended that the School Corporation's management establish effective internal controlsto ensure compliance and comply with the grant agreement and the Reporting compliance requirement.Views of Responsible OfficialsFor the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-005Subject: COVID-19 - Education Stabilization Fund - ReportingFederal Agency: Department of EducationFederal Program: COVID-19 - Education Stabilization FundAssistance Listings Numbers: 84.425D, 84.425UFederal Award Numbers and Years (or Other Identifying Numbers): S425D20013, S425D210013,S425U210013Pass-Through Entity: Indiana Department of EducationCompliance Requirement: ReportingAudit Findings: Material Weakness, Other MattersCondition and ContextAn effective internal control system was not designed, nor implemented, at the School Corporationto ensure compliance with requirements related to the grant agreement and the Reporting compliancerequirement.The School Corporation completed and submitted four annual Data Collection reports (Reports) forthe Elementary and Secondary School Emergency Relief (ESSER) grants. The Reports were prepared byone employee without an oversite or review process in place to prevent, or detect and correct, errors.Additionally, one of the four Reports tested was not supported by the School Corporation's records.The financial information provided did not agree to all the data submitted in the Report; therefore, we couldnot determine the accuracy of the Report. Additionally, two of six key line items selected for testing couldnot be traced to supporting documentation.The lack of internal controls and noncompliance were systemic issues throughout the audit period.Criteria2 CFR 200.303 states in part:"The non-Federal entity must:(a) Establish and maintain effective internal control over the Federal award that providesreasonable assurance that the non-Federal entity is managing the Federal award incompliance with Federal statutes, regulations, and the terms and conditions of the Federalaward. These internal controls should be in compliance with guidance in 'Standards forInternal Control in the Federal Government' issued by the Comptroller General of theUnited States or the 'Internal Control Integrated Framework', issued by the Committee ofSponsoring Organizations of the Treadway Commission (COSO). . . ."2 CFR 200.302(b) states in part:"The financial management system of each non-Federal entity must provide for the following:. . .(2) Accurate, current, and complete disclosure of the financial results of each Federalaward or program in accordance with the reporting requirements set forth in ?? 200.328and 200.329. . . ."34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and formatthat assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out otherresponsibilities under the program."2 CFR 200.334 states in part:"Financial records, supporting documents, statistical records, and all other non-Federal entityrecords pertinent to a Federal award must be retained for a period of three years from the dateof submission of the final expenditure report or, for Federal awards that are renewed quarterlyor annually, from the date of the submission of the quarterly or annual financial report, respectively,as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient.. . ."34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance withprogram requirements."CauseManagement had not developed a system of internal controls that would have ensured compliancewith the Reporting compliance requirement.EffectThe failure to establish an effective internal control system enabled noncompliance to go undetected.Noncompliance with the grant agreement and the Reporting compliance requirement could resultin the loss of future federal funds to the School Corporation.Questioned CostsThere were no questioned costs identified.RecommendationWe recommended that the School Corporation's management establish effective internal controlsto ensure compliance and comply with the grant agreement and the Reporting compliance requirement.Views of Responsible OfficialsFor the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
2022-002 Preparation of Schedule of Expenditures and Federal Awards (?SEFA?) and timelysubmission to Federal Clearing HouseSignificant deficiency in internal control over complianceFederal Program(s) ? All programsFederal Award Year ? June 30, 2022Criteria:2 CFR 200.302(b)(1) states that the nonfederal entity must identify in its accounts all federal awardsreceived and expended, as well as the federal programs under which they were received. Federalprogram and award identification must include, as applicable, the assistance listing title and number,the federal award identification number and year, the name of the federal agency, and the name of thepass-through entity, if any. This information enables the auditee to reconcile amounts presented in thefinancial statements to related amounts in the schedule of expenditures of federal awards. Managementis responsible for the preparation of the SEFA and timely submission of the audited package to theFederal Clearing House.Condition/context:GRYC maintains grant agreements with various government funding pass-through entities. WhileGRYC may not always be subject to the Uniform Guidance report due to not meeting the fundingthreshold, in fiscal year 2022, GRYC exceeded the annual minimal reporting requirement of $750,000.GRYC?s Uniform Guidance audit package was due for submission to the Federal Clearing House byMarch 31, 2023. However, GRYC was unable to effectively determine funding from federal programsthat were subject to Uniform Guidance and as a result, it did not submit the audited package to theFederal Clearing House on time.Cause:Prior to fiscal 2022, GRYC was not subject to the Uniform Guidance audit. In addition, all GRYC?sfederal funding is considered pass-through. As a result, GRYC was under the impression that none oftheir funding was considered federal funding subject to Uniform Guidance. Consequently, GRYC wasunable to sufficiently generate information on all federal funding received during fiscal year 2022 andas a result there was insufficient information available, which led to a delay in the audit process andfiling with the Federal Clearing House.Effect:GRYC maintains its grant documentation internally, however, GRYC did not consider several grantsas being subject to Uniform Guidance in preparation of their SEFA. GRYC did not meet the March31st, 2023, deadline for Federal Clearing House filing.Auditors? Recommendation:We recommend that GRYC develop policies and procedures to ensure compliance with the UniformGuidance reporting requirements that includes proper and timely preparation of SEFA and the timelyfiling of the audit package to the Federal Clearing House. We recommend frequent communicationbetween GRYC and pass-through agencies (funding sources) to help identify federal programs. Inaddition, we recommend GRYC provides more training to grant management staff to both enhancethe skill in identifying pass through programs and ensure the accuracy and completeness of the SEFA.The above recommendation can also be achieved by reviewing all contracts thoroughly and lookingfor provisions that state whether the contracts are federal or state funded. Similarly, if a contract hasan Assistance Listing Number (?ALN?), this could potentially indicate that such grant is federallyfunded. GRYC should also develop better procedures to track all revenues and expenditures over thenext fiscal year to determine whether it exceeded the $750,000 threshold and will be subject to anUniform Guidance audit.Managements Response:GRYC acknowledges and agrees with the finding and is in process of reviewing and analyzing allcontracts and amendments to ensure that the SEFA includes all federally awarded programs. GRYCwill start implementing this recommendation during the year ended June 30, 2023, and plans to filethe 2023 Uniform Guidance report timely.
Reference Number:2022-018Prior Year Finding:NoFederal Agency:U.S. Department of Health and Human ServicesState Agency:Department of Community AffairsFederal Program:Low-Income Home Energy Assistance, COVID-19 - Low-Income Home Energy AssistanceAssistance Listing Number:93.568Award Number and Year:2102NJE5C6 (3/11/21 ? 9/30/22), 2001NJE5C3 (3/27/20 ? 9/30/21), G-1701NJLIEA (10/1/16 ? 9/30/18), G-1801NJLIEA (10/1/17 ? 9/30/19), 2202NJLIEA (10/1/21 ? 9/30/22), 2001NJLIEA (10/1/19 ? 9/30/22), 2102NJLIEA (10/1/20 ? 9/30/21)Compliance Requirement:Cash ManagementType of Finding:Significant Deficiency in Internal Control Over Compliance, Other MattersCriteria or specific requirement:Compliance: Per 2 CFR 200.302, each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award.Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).Condition:The Department of Community Affairs (Department) was not able to provide documentation that drawdown requests had been properly approved.Context:Two of eight drawdown requests selected did not have evidence of supervisory approval prior to submission of the requests to the federal agency. The amounts drawn down for the two samples were $282,956 and $74,916 respectively.Questioned costs:None noted.Cause:The Department?s procedures were not sufficient to ensure that drawdown requests were reviewed and approved prior to submission. Internal controls did not prevent or detect the errors.Effect:Without proper review and approval of drawdown requests, the amounts requested could be inaccurate which could result in the Department receiving program funds to which it is not entitled.Recommendation:We recommend that the Department review and enhance its procedures and controls to ensure that cash drawdowns are reviewed and approved prior to submission to the federal agency.Views of responsible officials:The Department of Community Affairs (DCA) staff responsible for the LIHEAP cash management function retired prior to this audit period without a proper transition of these tasks and there was also a delay in refilling the position. As recommended, the DCA has reviewed current procedures and controls regarding cash drawdown approvals and has developed a Policy Memo that details the Payment Management System (PMS) drawdown procedures going forward. For each request made, a Contract Administrator will produce a Business Object report for all transactions to be included in the drawdown and will send the report to the Program staff for review and approval that the amounts contained in the report are correct. Once the Program staff review is complete, the approved Business Object report will be forwarded with a cover email to the Division Fiscal Unit staff responsible for drawing down the funds in PMS for final processing.Views of responsible officials:
Reference Number:2022-018Prior Year Finding:NoFederal Agency:U.S. Department of Health and Human ServicesState Agency:Department of Community AffairsFederal Program:Low-Income Home Energy Assistance, COVID-19 - Low-Income Home Energy AssistanceAssistance Listing Number:93.568Award Number and Year:2102NJE5C6 (3/11/21 ? 9/30/22), 2001NJE5C3 (3/27/20 ? 9/30/21), G-1701NJLIEA (10/1/16 ? 9/30/18), G-1801NJLIEA (10/1/17 ? 9/30/19), 2202NJLIEA (10/1/21 ? 9/30/22), 2001NJLIEA (10/1/19 ? 9/30/22), 2102NJLIEA (10/1/20 ? 9/30/21)Compliance Requirement:Cash ManagementType of Finding:Significant Deficiency in Internal Control Over Compliance, Other MattersCriteria or specific requirement:Compliance: Per 2 CFR 200.302, each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award.Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).Condition:The Department of Community Affairs (Department) was not able to provide documentation that drawdown requests had been properly approved.Context:Two of eight drawdown requests selected did not have evidence of supervisory approval prior to submission of the requests to the federal agency. The amounts drawn down for the two samples were $282,956 and $74,916 respectively.Questioned costs:None noted.Cause:The Department?s procedures were not sufficient to ensure that drawdown requests were reviewed and approved prior to submission. Internal controls did not prevent or detect the errors.Effect:Without proper review and approval of drawdown requests, the amounts requested could be inaccurate which could result in the Department receiving program funds to which it is not entitled.Recommendation:We recommend that the Department review and enhance its procedures and controls to ensure that cash drawdowns are reviewed and approved prior to submission to the federal agency.Views of responsible officials:The Department of Community Affairs (DCA) staff responsible for the LIHEAP cash management function retired prior to this audit period without a proper transition of these tasks and there was also a delay in refilling the position. As recommended, the DCA has reviewed current procedures and controls regarding cash drawdown approvals and has developed a Policy Memo that details the Payment Management System (PMS) drawdown procedures going forward. For each request made, a Contract Administrator will produce a Business Object report for all transactions to be included in the drawdown and will send the report to the Program staff for review and approval that the amounts contained in the report are correct. Once the Program staff review is complete, the approved Business Object report will be forwarded with a cover email to the Division Fiscal Unit staff responsible for drawing down the funds in PMS for final processing.Views of responsible officials:
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. This is a repeat finding (2021-005) from the previous fiscal year. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. This is a repeat finding (2021-005) from the previous fiscal year. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: During my sample review of the District’s completion of its federal grant program ‘Quarterly Cash On Hand Reconciliations’ for the 2021-2022 4th fiscal quarter for the ESSER II and ARP ESSER grants, I noted that the amounts reported to date for ‘total disbursements’ could not be ascertained from the coding of these expenditures in the District’s general ledger (See Finding 2022-005) and did not reconcile to the separate spreadsheets maintained by the School District. This is a repeat finding (2021-006) from the previous fiscal year. CRITERIA: Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: The School District did not comply with Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance which prescribes the proper financial management system for the tracking of federal program expenditures. CAUSE: The School District did not utilize the federal source code tracking system as prescribed by the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts, which would have enabled the District to print reports from the accounting software system, by federal source program, to properly prepare the quarterly reconciliations. It was not readily determinable as to why the ‘total disbursements’ line on the quarterly cash on hand reconciliations did not match the separate spreadsheets the School District utilized for tracking federal program expenditures. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance, to allow for the proper completion of the ‘quarterly cash on hand reconciliations’. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. This is a repeat finding (2021-005) from the previous fiscal year. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: During my sample review of the District’s completion of its federal grant program ‘Quarterly Cash On Hand Reconciliations’ for the 2021-2022 4th fiscal quarter for the ESSER II and ARP ESSER grants, I noted that the amounts reported to date for ‘total disbursements’ could not be ascertained from the coding of these expenditures in the District’s general ledger (See Finding 2022-005) and did not reconcile to the separate spreadsheets maintained by the School District. This is a repeat finding (2021-006) from the previous fiscal year. CRITERIA: Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: The School District did not comply with Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance which prescribes the proper financial management system for the tracking of federal program expenditures. CAUSE: The School District did not utilize the federal source code tracking system as prescribed by the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts, which would have enabled the District to print reports from the accounting software system, by federal source program, to properly prepare the quarterly reconciliations. It was not readily determinable as to why the ‘total disbursements’ line on the quarterly cash on hand reconciliations did not match the separate spreadsheets the School District utilized for tracking federal program expenditures. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance, to allow for the proper completion of the ‘quarterly cash on hand reconciliations’. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. This is a repeat finding (2021-005) from the previous fiscal year. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: During my sample review of the District’s completion of its federal grant program ‘Quarterly Cash On Hand Reconciliations’ for the 2021-2022 4th fiscal quarter for the ESSER II and ARP ESSER grants, I noted that the amounts reported to date for ‘total disbursements’ could not be ascertained from the coding of these expenditures in the District’s general ledger (See Finding 2022-005) and did not reconcile to the separate spreadsheets maintained by the School District. This is a repeat finding (2021-006) from the previous fiscal year. CRITERIA: Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: The School District did not comply with Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance which prescribes the proper financial management system for the tracking of federal program expenditures. CAUSE: The School District did not utilize the federal source code tracking system as prescribed by the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts, which would have enabled the District to print reports from the accounting software system, by federal source program, to properly prepare the quarterly reconciliations. It was not readily determinable as to why the ‘total disbursements’ line on the quarterly cash on hand reconciliations did not match the separate spreadsheets the School District utilized for tracking federal program expenditures. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance, to allow for the proper completion of the ‘quarterly cash on hand reconciliations’. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: The District did not properly record its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs using the various federal funding source expenditure codes as prescribed by the Chart of Accounts for PA Local Educational Agencies maintained by the PA Office of the Budget, Office of Comptroller Operations. This is a repeat finding (2021-005) from the previous fiscal year. CRITERIA: The Pennsylvania Department of Education (PDE), through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts requires School Districts to utilize specific funding source codes for federal program expenditures. In addition, Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: By not using federal source codes to properly track its federal program expenditures for the GEER, ESSER, and ARP ESSER federal grant programs, the School District did not comply with the financial reporting standards for federal program expenditures as prescribed by the Pennsylvania Department of Education, through the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts and Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance. This situation significantly reduced the District’s internal controls over the ability to properly manage and account for these federal program expenditures in accordance with the compliance requirements of PDE and the Uniform Guidance. CAUSE: Management used proper funding source codes for the revenues received under the GEER, ESSER, and ARP ESSER federal grant programs, but erroneously did not realize the federal funding source coding applied to expenditures as well. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to 1) enhance internal controls for tracking and monitoring federal program expenditures and 2) comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance and PDE regulations. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
CONDITION: During my sample review of the District’s completion of its federal grant program ‘Quarterly Cash On Hand Reconciliations’ for the 2021-2022 4th fiscal quarter for the ESSER II and ARP ESSER grants, I noted that the amounts reported to date for ‘total disbursements’ could not be ascertained from the coding of these expenditures in the District’s general ledger (See Finding 2022-005) and did not reconcile to the separate spreadsheets maintained by the School District. This is a repeat finding (2021-006) from the previous fiscal year. CRITERIA: Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance requires non-federal organizations such as the School District to maintain financial records which account for federal funds in such a manner as to be able to properly track the identification and use of federal funds. EFFECT: The School District did not comply with Section 2 CFR 200.302(a) and 302(b) of the Uniform Guidance which prescribes the proper financial management system for the tracking of federal program expenditures. CAUSE: The School District did not utilize the federal source code tracking system as prescribed by the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts, which would have enabled the District to print reports from the accounting software system, by federal source program, to properly prepare the quarterly reconciliations. It was not readily determinable as to why the ‘total disbursements’ line on the quarterly cash on hand reconciliations did not match the separate spreadsheets the School District utilized for tracking federal program expenditures. QUESTIONED COSTS: None RECOMMENDATION: I am recommending that the School District properly follow the guidance contained within the PA Office of the Budget, Office of Comptroller Operations Chart of Accounts for recording all expenditures of the School District, most specifically, federal program grant expenditures to comply with the recordkeeping requirements for federal funds as specified in Section 2 CFR Part 200.302(a) and 302(b) of the Uniform Guidance, to allow for the proper completion of the ‘quarterly cash on hand reconciliations’. VIEWS OF RESPONSIBLE OFFICIALS: The School District concurs with the above noted finding and addresses this issue in the ‘Corrective Action Plan’ included within this report.
2022-002 Financial Management and Internal Controls Compliance Requirement Allowable Costs/Cost Principles Category Significant Deficiency in Internal Control and Noncompliance Federal Agency U.S. Department of the Treasury Pass-Through Entity Puerto Rico Fiscal Agency and Financial Advisory Authority ALN 21.027 Federal Program COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Criteria 2 CFR section 200.302 Financial management. (a) Each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. (b) ….. (1) ….. (2) ….. (3) ..... (5) ….. (6) ….. (7) Written procedures for determining the allowability of costs in accordance with subpart E of this part and the terms and conditions of the Federal award. 2 CFR section 200.303 Internal controls. The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). (b) Comply with the Federal statutes, regulations, and the terms and conditions of the Federal awards. (c) Evaluate and monitor the non-Federal entity's compliance with statutes, regulations and the terms and conditions of Federal awards. (d) Take prompt action when instances of noncompliance are identified including noncompliance identified in audit findings. Condition Written Policies The Corporation has no written policies for determining the activities allowed or unallowed and the allowability of costs as described in subpart E, Cost Principles of 2 CFR Part 200. Cause It is the first year for the Corporation to be subjected to a single audit compliance requirements. However, since the Commonwealth of Puerto Rico (the Commonwealth) filed for Title III under the PROMESA, all the instrumentalities of the Commonwealth had to reduce their staff as part of the Fiscal Plan to reduce expenditures. This has disrupted the segregation of duties, which is a key control. Effect The Corporation could incurred in unallowable costs failing to comply with 2 CFR sections 200.302 and 202.305, the Corporation could then be subjected to temporarily withholding of cash payments pending correction of the deficiency and/or withholding further federal awards for the program. Questioned Costs None Recommendations We recommend the Corporation obtain a thorough understanding of the provisions of federal statutes, regulations, or the terms and conditions of federal awards to prepare the required written policies under subpart E, Cost Principles of 2 CFR Part 200. Views of responsible officials Refer to Corrective Action Plan section.
Finding 2022-001 – B. Allowable Costs Federal Agency: U.S. Department of Health and Human Services Passthrough Entity: N/A Assistance Listing Number and Federal Program: 93.829 Section 223 Demonstration Programs to Improve Community Mental Health Services Criteria: In accordance with 2 CFR part 200.302, the Association is required to maintain financial management systems to trace funds to expenditures to establish that funds have been used according to Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system must provide for records that identify adequately the source and application of funds for federally funded activities, among other conditions. The reporting of the federal expenditures should be supported by these records. Amounts may not be expended from project funds on an arbitrary basis. Additionally, in accordance with 2 CFR 200.430, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records, among other things, should support the distribution of the employee’s salary or wages among specific activities if the employee works on a Federal award and non-Federal award. Budget estimates do not qualify as support for charges to Federal awards. Statement of Condition: During the course of our audit, supporting detail for expenses allocated and charged to the grant was not available and could not be determined. Salaries and benefits charged to the grant were based on estimates of employees’ expected workload and client needs, and not supported by records that accurately reflected the work performed on the Federal program. Additionally, the de minimis indirect cost rate was not correctly calculated and applied. The indirect cost charged to the grant was based on the indirect cost obligated by the Notice of Award rather than by calculating the indirect cost from the modified total direct cost base. Statement Cause: This is the first year the Association received this type of grant funding, coupled with significant growth experienced by the Association, the accounting system and staff were not yet prepared to effectively adhere to the requirements of the grant. Supporting documentation is not available for employees’ actual time spent and charged to the grants. Statement of Effect: Without proper accounting of expenditures and support of salaries and wages, grant expenditures can be over or understated on the drawdown requests. This could result in noncompliance with grant agreements which could lead to adverse conditions with the grantors. Questioned Costs: No questioned costs were identified. Identification of Repeat Findings: Not a repeat finding. Recommendations: Project codes or classes should be created within the accounting system, if available. This will allow for expenses to be properly segregated by grant or other funding. When expenses are properly segregated, the indirect cost can be properly calculated using the correct direct cost base. The Association should also implement that all employees submit personnel activity reports to provide documentation of their time allocated to the grant. Views of Responsible Official(s): The Association is in agreement with the finding and is continuing to expand their knowledge on grant expenditures and compliance as it relates to the new financial management software to aid in tracking grants. See corrective action plan.
Financial Management System- (Material Weakness) Criteria:According to 2 CFR 200.302, the financial management system of each non-Federal entity must provide records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Condition: Statement of financial position transactions were not allocated properly to programs/properties funded with federal funds. Cause: Due to a human error of individuals who were handling the accounting entries, some of transactions were not accurately allocated to the correct programs/properties. Effect: Improper allocation of transactions among various programs/properties could lead to comingling of funds from different projects. This could result in unallowable cost or in allowable cost charged simultaneously to two different programs/properties. Questioned Cost: Undetermined Recommendation: Establish an internal control procedures in place that provide for separate accountability for projects by allocating transactions properly and producing accurate financial reports for each federally funded programs/properties. Management's Views and Corrective Action Plan Management's response is included in "Management's View and Corrective Action Plan" at the end of this report after the schedule of findings and questioned cost
Finding 2022-006 Assistance Listing Number: 19.510 Program Title: U.S. Refugee Admissions Program Agency: U.S. Department of State Pass-Through Entity: United States Conference of Catholic Bishops Federal Award Identification Number: SPRMCO21CA3001, SPRMCO22CA0023 and SPRMCO21CA3291 Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles, Period of Performance Criteria: In accordance with Title 2 CFR Part 200.302, costs must be supported by source documentation. In accordance with Title 2 CFR Part 200.403, costs must be adequately documented to be allowable costs under the federal program. The Cooperative Agreement with the U.S. Department of State requires recipients to maintain a case file for each client that includes client acknowledgement of receipt of direct assistance. Condition: We tested fifty-two non-payroll expenditures charged to the federal program. Of the fifty-two expenditures, six expenditures did not have any supporting documentation that could be located. We tested forty non-payroll expenditures charged to the program to ensure the Client Acknowledgement of Receipt of Direct Assistance Form was obtained. Of the forty expenditures, two forms were missing. Therefore, an additional twenty-five expenditures charged to the program were selected, and one additional form was missing from the expanded sample. Cause: Catholic Charities was unable to locate supporting documentation for non-payroll expenditures charged to the federal program. Effect: Six non-payroll expenditures did not have any supporting documentation as required by Title 2 CFR Part 200.302 and Title I CFR Part 200.403. Three non-payroll expenditures did not have the Client Acknowledgement of Receipt of Direct Assistance Form. Questioned Costs: $2,541 Context: Total non-payroll expenditures charged to the federal program was $559,001. Repeat Finding: Not applicable. Recommendation: We recommend Catholic Charities maintain supporting documentation for all expenditures charged to the federal program. We also recommend Catholic Charities ensure the signed Client Acknowledgement of Receipt of Direct Assistance Form is maintained. Views of the Responsible Officials: Catholic Charities of Central and Northern Missouri agrees with this finding and while some of the problems which arose were related to a burst water pipe over an extended holiday that destroyed many of the records, All invoices and documentation related to expenditure of federal funds are now scanned and attached to the accounting entry recording the payable. With regards to the Client Acknowledgement of Receipt of Direct Assistance Forms, much of that issue was related to cultural issues where male refugees would not let their spouses sign any such documentation. We have taken steps to ensure that the documentation is signed at the time assistance is given and continue to work with the refugees as to the importance of having the proper paperwork on file.
Condition: The Municipality failed to identify, within their records, a list of transactions, nor could provide supporting documentation for the disbursement of $373,670 of program funds. Several inconsistencies between the disbursement and supporting documentation were observed for disbursements totaling $8,579. A total of $373,670 of program funds were transferred to other accounts of the Municipality. The Municipality did not provide us with supporting documentation for transactions totaling $373,670, therefore, we could not ascertain that these transactions complied with program regulations. Context: The Municipality received $758,218 of program funds during the fiscal year ended on June 30, 2022. A total of $1,526,593 was included in the schedule of expenditures of federal awards (SEFA) as program expenses. The Municipality did not provide sufficient and appropriate documentation for $373,670 of program expenses. This represents 24% of the expenses reported in the SEFA. The following situations were observed for disbursements totaling $8,579: Context, continued: Situation Number of transactions with situation Disbursement was made before the receipt of the related invoice 1 Duplicity of payments for the same invoice 2 Disbursement was made without the receipt of the related invoice nor the signoff of all required personnel. 1 Program regulation states that local governments are required to use payments from the Fund to cover: 1) Necessary expenditures incurred due to the public health emergency with respect to the Coronavirus Disease 2019 (Covid-19), 2) Costs that were not accounted in the governments’ most recently approved budget as of March 27, 2020, and 3) Costs that were incurred during the period that begins on March 1, 2020; and ends on December 31, 2021. Program Closure Report reminds the Municipality that as per 2 C.F.R. 200 and applicable federal regulations to the CRF Program, documentation that serves as evidence of any eligible expenditure reported under the CRF Program should be preserved and maintained for at least five years. We could not ascertain that these disbursements complied with program regulations. The Coronavirus Relief Fund is authorized by the Cares Act, Pub. L. No. 116-136, Division A, Title V (2020) (codified as 42 USC 81 et seq.) as amended by the Consolidated Appropriations Act, 201, Pub. L. No. 116-260 Division N, Title X, Section 1001. Criteria: Uniform Guidance states in 2 CFR 200.403 that otherwise authorized by statue, costs must be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles, be consistent with policies and procedures that apply uniformly to both federally financed and other activities of the non-Federal entity and be adequately documented. As per 2 CFR 200.302 the other non-Federal entity’s financial management system must provide for the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statues, regulations, and the terms and conditions of the Federal Award. Cause: The Municipality failed to provide documentation that served as evidence of eligible expenses for the CRF program for expenses totaling $373,670. The Municipality applied inconsistent internal control and program procedures to disbursement transactions totaling $8,579. Effect: Remedies for noncompliance are described in 2 CFR 200.339. Grantor may impose additional conditions as described in 2 CRF 200.208 or take one or more of the actions listed on 2 CRF 200.339 as appropriate in the circumstances. Auditor’s recommendation: The Municipality must strengthen internal controls and procedures to assure that disbursement of program funds is properly documented and allowed under program regulations. The Municipality must ensure that all documentation that serves as evidence for eligible expenses be preserved and maintained for at least five years. Views of Responsible officials and corrective actions: Evidence of AAFAF Funds closeout report was provided, there is no issue. Auditor Comments: The Coronavirus Relief Fund (CRF) Transfer Agreement – Assistance Program to Municipalities establishes the following on its grant agreement: 2.3 Recordkeeping: Transferee will maintain its books and records in a manner that will provide Transferor with sufficient detail to review Transferee’s receipts and expenditures relating to the Transfer. Transferee will make such records available for review by Transferor or its agent or designee upon reasonable notice during the Transfer Period and for five (5) years after the termination or expiration of this Agreement. 5.2 Compliance Audit Requirements E.: As applicable, Transferees required to have an audit must ensure the audits are performed in accordance with Generally Accepted Auditing Standards (GAAS) and Government Auditing Standards. The Assistance Program to Municipalities Program Closure Report that management refers to states the following: “Receipt of this notification means that your municipality does not need to provide further notifications or Use of Funds reports since the Program has been closed for your municipality. Your municipality is advised that all documentation that serves as evidence of any eligible expenditure reported under the CRF Program should be preserved and maintained for at least five (5) years, as indicated by federal regulation 2 C.F.R. 200 and applicable federal regulations to the CRF Program. Additionally, please be advised that your municipality will continue to be subject to revisions or audits by local, state or federal agencies pertaining to the use of funds in accordance with federal regulations applicable to the CRF program or the federal regulations regarding Federal Awards, 2 C.F.R. 200. Therefore, your municipality should expect and be prepared for a formal audit by the Government of Puerto Rico or by any pertinent federal agency”. Appendix XI to Part 200 – Compliance Supplement identifies Allowable Costs/Cost Principle as a compliance requirement. Except where otherwise authorized by statue, cost must meet the following general criteria in order to be allowable under federal awards: (1) Be necessary and reasonable for the performance of the federal award and be allocable thereto under the principles in 2 CFR Part 200, Subpart E., and (2) be adequately documented, among other things. The Assistance Program to Municipalities Program Closure Report does not constitute a list of transactions nor adequate supporting documentation of the transactions totaling $373,670. It also does not explain the inconsistencies in supporting documentation observed for disbursements totaling $8,579. Audit Status: Unresolved
Condition: The Municipality failed to identify, within their records, a list of transactions, nor could provide supporting documentation for the disbursement of $1,468,197 of program funds. Documentation for the disbursement of $17,565 of program funds was not identified by the Municipality nor provided for our review. A total of $1,468,197 of program funds were transferred to other accounts of the Municipality. The Municipality did not provide us with supporting documentation for transactions totaling $1,468,197, therefore, we could not ascertain that these transactions complied with program regulations. Context: The Municipality received $6,013,479 of program funds during the fiscal year ended on June 30, 2022. A total of $ 4,810,454 was included in the schedule of expenditures of federal awards (SEFA) as program expenses. The Municipality did not provide sufficient and appropriate documentation for $1,485,762 of program expenses. This represents 31% of the expenses reported in the SEFA. The Municipality indicated that Revenue Replacement was their only project expenditure category in their annual March 2022 SLFRF Compliance Report. Revenue loss in and of itself is not an eligible use. Instead, recipients calculate lost revenue based on the formula provided in the Interim Final Rule and Final Rule to determine the limit for funds that can be used for the provision of government services. Entities are expected to use the direct payments to meet pandemic response needs and rebuild a strong, more equitable economy as the country recovers. Interim and final regulations state that recipients may not use funds to pay interest or principal on outstanding debt, as these expenses would not address the needs of pandemic response or its negative economic impacts. Such expenses would also not be considered provision of government services, as these financing expenses do not directly provide services or aid to citizens. The Coronavirus State and Local Fiscal Recovery Funds program is authorized by sections 602 and 603 of the Social Security Act as added by section 9901 of the American Rescue Plan Act of 2021, Pub. L. No. 117-2 (Mar. 11, 2021). Recipients may use payments from the Fund to among other things, replace lost public sector revenue to provide government services. Criteria: Uniform Guidance states in 2 CFR 200.403 that otherwise authorized by statue, costs must be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles, be consistent with policies and procedures that apply uniformly to both federally financed and other activities of the non-Federal entity and be adequately documented. As per 2 CFR 200.302 the other non-Federal entity’s financial management system must provide for the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statues, regulations, and the terms: and conditions of the Federal Award. Further, Coronavirus Local Fiscal Recovery Fund Award terms and conditions state the following regarding the maintenance of and Access to Records 1. Recipient shall maintain records and financial documents sufficient to evidence compliance with section 603© of the Act, Treasury’s regulations implementing that section, and guidance issued by Treasury regarding the foregoing. 2. The Treasury Office of Inspector General and the Government Accountability Office, or their authorized representatives, shall have the right of access to records (electronic and otherwise) of Recipient in order to conduct audits or other investigations. 3. Records shall be maintained by the Recipient for a period of five (5) years after all funds have been expended or returned to the Treasury, whichever is later. Cause: The Municipality failed to provide documentation that served as evidence of eligible expenses for the program for expenses totaling $1,485,762. The Municipality applied inconsistent internal control and program procedures to disbursement transactions totaling $17,565. Effect: Coronavirus Local Fiscal Recovery Fund Award terms and conditions state the following regarding Remedial Actions: In the event of recipient’s noncompliance with section 603 of the Act, other applicable laws, Treasury’s implementing regulations, guidance , or any reporting or other program requirements, Treasury may impose additional conditions on the receipt of a subsequent tranche of future award funds, If any, or take other available remedies as set forth in 2 CFR 200.339 In the case of a violation of section 603 (c ) of the Act regarding the use of funds, previous payments shall be subject to recoupment as provided in section 603 ( C )of the Act. Auditor’s recommendation: The Municipality must strengthen internal controls and procedures to assure that disbursement of program funds is properly documented and allowed under program regulations. The Municipality must ensure that all documentation that serves as evidence for eligible expenses be preserved and maintained for at least five years. Views of Responsible officials and corrective actions: The accounting staff will continue searching for supporting documentation related to the disbursements amounting $17,565. The Coronavirus State & Local Fiscal Recovery Funds (CSLFR) Department of Treasury Final Rule of January 2022., offers a standard allowance for revenue loss of $10 million, allowing recipients to select between a standard amount of revenue loss or complete a full revenue loss calculation. Recipients that select the standard allowance may use that amount, in many cases their full award, for government services. The Municipality’s management selected the standard allowance, since the amount awarded of CSLFR funds were less than $10 million ad determined that the use of these funds was for governmental services, which are services traditionally provided by recipient governments. The Municipality determined that the payroll expenditures of several departments of the Municipality’s General Fund will be charged to the CSLFR fund as government services. The transfer of $1,468,197 of CSLFR to other Municipality’s bank accounts was to cover the payrolls related to governmental services accounted in the Municipality’s General Fund during the fiscal year 2021-2022. Due to an involuntary omission, these transfers were not recorded as expenditures in the CSLFR fund in the accounting system of the Municipality. To correct this accounting error the Municipality’s management gave instructions to the accounting staff to start reclassifying in the accounting system as soon as possible, these transfers to payroll expenditures accounts in the CSLFR fund. Municipality’s management believes that this finding should be related to an issue of reporting because the Municipality complied with the requirements of activities allowed or unallowed and allowable costs, since the Municipality disbursed CSLFR funds related to governmental services in accordance with the Department of Treasury Final Rule of January 2022. No actions are required related to this finding. Auditor Comments: The U.S Department of The Treasury Coronavirus Local Fiscal Recovery Fund Award Terms and Conditions establishes the following: Recipient shall maintain records and financial documents sufficient to evidence compliance with section 603 ( c ) of the Act, Treasury’s regulations implementing that section, and guidance issued by Treasury regarding the foregoing. Records shall be maintained by Recipient for a period of five (5) years after all funds have been expended or returned to Treasury, whichever is later. 2 CFR 200.302 states the other non-Federal entity’s financial management system must provide for the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statues, regulations, and the terms and conditions of the Federal Award. Appendix XI to Part 200 – Compliance Supplement identifies Allowable Costs/Cost Principle as a compliance requirement. Except where otherwise authorized by statue, cost must meet the following general criteria in order to be allowable under federal awards: (1) Be necessary and reasonable for the performance of the federal award and be allocable thereto under the principles in 2 CFR Part 200, Subpart E., and (2) be adequately documented, among other things. Although Government Services is an allowable expense category for the CSLFR program, and the Municipality’s management represent to us that the transfers to other accounts within the Municipality correspond to payroll expenditures, the Municipality did not provide us with a list of transactions, nor provided supporting documentation relating to these payroll transactions for the amount of $1,468,197. Program regulations states that records shall be maintained by the Recipient for a period of 5 years after all funds have been expended and federal regulation states that in order to be allowable, costs need to be properly documented. Audit Status: Unresolved
Condition: The Municipality could not provide supporting documentation for the disbursement of $173,454 of program funds. These disbursements were accounted for as increase in the due from other funds account. We could not ascertain that the disbursements of $173,454 complied with program regulations. Context: The Municipality received $123,938 of program funds during the fiscal year ended on June 30, 2022. A total of $173,454 of program funds were disbursed without sufficient and appropriate documentation. These funds were disbursed as electronic transfers to other municipal accounts and were accounted for as increases in the due from other funds account. The Municipality repaid during the current year the amount of $447,816 related to last year’s disbursements to the due from other funds account. As of June 30, 2022 the balance of the due from other funds account is $555,110. Program regulation states that costs must be directly tied to the performance of eligible work; adequately documented; reduced by all applicable credits, such as insurance proceeds and salvage values; authorized and not prohibited under Federal or State government laws or regulation; consistent with the applicant’s internal policies, regulations, and procedures that apply uniformly to both Federal awards and other activities of the applicant; and necessary and reasonable to accomplish the work properly and efficiently. We could not ascertain that these disbursements complied with program regulations. The Public Assistance Program is authorized under the Robert T. Stafford Disaster Relief and Emergency assistance Act, as Amended (Stafford Act). Assistance is provided so that communities can quickly respond to and recover from major disasters or emergencies declared by the President. The Municipality has approved grants for the Hurricane Irma and Maria disasters declared on September 2017 (disasters 3384EMPR, 4336 DRPR and 4339 DRPR). The program approves funding for debris removal, emergency protective measures, and the restoration of disaster-damaged, publicly owned facilities. It also encourages protection of damaged facilities from future incidents by providing assistance for hazard mitigation measures. Criteria: Uniform Guidance states in 2 CFR 200.403 that otherwise authorized by statue, costs must be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles, be consistent with policies and procedures that apply uniformly to both federally financed and other activities of the non-Federal entity and be adequately documented. As per 2 CFR 200.302 the other non-Federal entity’s financial management system must provide for the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statues, regulations, and the terms and conditions of the Federal Award. As per 44 CFR section 206.201 and 206.203, the public assistance program provides grant funding for emergency protective measures and debris removal (Emergency Work) and for permanent restoration of damaged facilities, including cost-effective hazard mitigation to protect facilities from future damage (Permanent Work). Cause: The Municipality applied inconsistent program procedures to the three disbursement transactions totaling $173,454. Effect: Remedies for noncompliance are described in 2 CFR 200.339. Grantor may impose additional conditions as described in 2 CRF 200.208 or take one or more of the actions listed on 2 CRF 200.339 as appropriate in the circumstances. Program regulations provide for recovery of assistance and penalty provisions on 44 CFR Part 206. Auditor’s recommendation: The Municipality must strengthen internal controls and procedures to assure that disbursement of program funds are properly documented, can be directly tied to the performance of eligible work, and is allowed under program regulations. Views of Responsible officials and corrective actions: The Municipality Administration is committed to identify the control of deficiency that allowed for the deficiency to happen. Additionally, the administration is committed to implementing the correct control structure to prevent the situation from happening in the future. The Municipality Management will continue the search of supporting documentation of the highlighted transactions. New proposed control structure to be evaluated by Municipality for adequacy. Audit Status: In process of completion.
FA 2022-003 Improve Controls over Cash Management Compliance Requirement: Cash Management Internal Control Impact: Material Weakness Compliance Impact: Material Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Number and Title: 84.010 –Title I Grants to Local Educational Agencies Federal Award Numbers: SO10A200010 (Year: 2021), S010A210010-21A (Year: 2022) Questioned Costs: None Identified Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Numbers and Titles: COVID-19 – 84.425D – Elementary and Secondary School Emergency Relief Fund COVID-19 – 84.425W – American Rescue Plan Elementary and Secondary School Emergency Relief Fund – Homeless Children and Youth Federal Award Numbers: S425D210012 (Year: 2021), S425W210011 (Year: 2021) Questioned Costs: None Identified Repeat of Prior Year Findings: FA 2021-001, FA 2020-001, FA 2019-001, FA 2018-001, FA 2017-002, FA 2016-001, FA 2015-002, FA 2014-003 Description: The School District made cash drawdowns in excess of immediate cash needs for the Title I Grants to Local Educational Agencies and Elementary and Secondary School Emergency Relief Fund programs. III FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Background Information: The School District may request Title I Grants to Local Educational Agencies (Title I) and Elementary and Secondary School Emergency Relief (ESSER) Fund program funds from the Georgia Department of Education (GaDOE) once per month. GaDOE requires the School District to submit DE-0147 – Requests for Reimbursement of Monthly Cash Disbursements through the Grants Accounting Online Reporting System to receive program funds. When a DE-0147 request is submitted and approved, the funds are typically disbursed to the School District through an electronic payment process the next week. The School District submitted DE-0147 requests to receive a total of $390,112 in Title I funds and a total of $498,996 in ESSER funds from GaDOE during the fiscal year under review. Criteria: As a recipient of federal awards, the School District is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 – Internal Controls. Provisions included in the Uniform Guidance Section 200.305(b) state that “For non-Federal entities other than states, payment methods must minimize the time elapsing between the transfer of funds… the pass-through entity and the disbursement by the non-Federal entity.” In addition, the Uniform Guidance Section 200.302(b)(6) requires the entity to develop written cash management procedures. Further, as noted in the Uniform Guidance Section 200.511, management is responsible for implementing reported corrective action to findings from previous audits. Condition: A review of all cash drawdowns and disbursements related to the Title I and ESSER programs was performed to determine if any excessive cash balances were maintained during the fiscal year under review. Cash balances in excess of program materiality were maintained for the Title I program for 365 days and the ESSER program for 121 days. Additionally, it was noted that the School District did not have appropriate internal controls in place over the cash drawdown process. Cause: In discussing this issue with the School District, they indicated that the lack of review of federal grants resulted in excess cash drawdown requests. Effect: The School District was not in compliance with the Uniform Guidance and GaDOE guidance. In addition, the School District could potentially accrue an interest liability that would be owed back to the federal government. Furthermore, when the School District cannot meet the requirement to minimize the time elapsing between the transfer of funds and disbursement of those funds, provisions included in the Uniform Guidance allow GaDOE to change the method by which the School District is transferred funds and delay the School District’s receipt of these funds. This may include a requirement by GaDOE to submit invoices prior to being reimbursed for program expenditures. III FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Recommendation: The School District should establish procedures to accurately forecast the cash needs of the Title I and ESSER programs and minimize the time elapsing between the transfer of funds from GaDOE and the disbursement of such funds by the School District. In addition, these procedures should be documented in writing in accordance with the Uniform Guidance Section 200.302(b)(6). Furthermore, management should develop and implement a monitoring process to ensure that these procedures are followed. Views of Responsible Officials: We concur with this finding.
FA 2022-003 Improve Controls over Cash Management Compliance Requirement: Cash Management Internal Control Impact: Material Weakness Compliance Impact: Material Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Number and Title: 84.010 –Title I Grants to Local Educational Agencies Federal Award Numbers: SO10A200010 (Year: 2021), S010A210010-21A (Year: 2022) Questioned Costs: None Identified Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Numbers and Titles: COVID-19 – 84.425D – Elementary and Secondary School Emergency Relief Fund COVID-19 – 84.425W – American Rescue Plan Elementary and Secondary School Emergency Relief Fund – Homeless Children and Youth Federal Award Numbers: S425D210012 (Year: 2021), S425W210011 (Year: 2021) Questioned Costs: None Identified Repeat of Prior Year Findings: FA 2021-001, FA 2020-001, FA 2019-001, FA 2018-001, FA 2017-002, FA 2016-001, FA 2015-002, FA 2014-003 Description: The School District made cash drawdowns in excess of immediate cash needs for the Title I Grants to Local Educational Agencies and Elementary and Secondary School Emergency Relief Fund programs. III FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Background Information: The School District may request Title I Grants to Local Educational Agencies (Title I) and Elementary and Secondary School Emergency Relief (ESSER) Fund program funds from the Georgia Department of Education (GaDOE) once per month. GaDOE requires the School District to submit DE-0147 – Requests for Reimbursement of Monthly Cash Disbursements through the Grants Accounting Online Reporting System to receive program funds. When a DE-0147 request is submitted and approved, the funds are typically disbursed to the School District through an electronic payment process the next week. The School District submitted DE-0147 requests to receive a total of $390,112 in Title I funds and a total of $498,996 in ESSER funds from GaDOE during the fiscal year under review. Criteria: As a recipient of federal awards, the School District is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 – Internal Controls. Provisions included in the Uniform Guidance Section 200.305(b) state that “For non-Federal entities other than states, payment methods must minimize the time elapsing between the transfer of funds… the pass-through entity and the disbursement by the non-Federal entity.” In addition, the Uniform Guidance Section 200.302(b)(6) requires the entity to develop written cash management procedures. Further, as noted in the Uniform Guidance Section 200.511, management is responsible for implementing reported corrective action to findings from previous audits. Condition: A review of all cash drawdowns and disbursements related to the Title I and ESSER programs was performed to determine if any excessive cash balances were maintained during the fiscal year under review. Cash balances in excess of program materiality were maintained for the Title I program for 365 days and the ESSER program for 121 days. Additionally, it was noted that the School District did not have appropriate internal controls in place over the cash drawdown process. Cause: In discussing this issue with the School District, they indicated that the lack of review of federal grants resulted in excess cash drawdown requests. Effect: The School District was not in compliance with the Uniform Guidance and GaDOE guidance. In addition, the School District could potentially accrue an interest liability that would be owed back to the federal government. Furthermore, when the School District cannot meet the requirement to minimize the time elapsing between the transfer of funds and disbursement of those funds, provisions included in the Uniform Guidance allow GaDOE to change the method by which the School District is transferred funds and delay the School District’s receipt of these funds. This may include a requirement by GaDOE to submit invoices prior to being reimbursed for program expenditures. III FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Recommendation: The School District should establish procedures to accurately forecast the cash needs of the Title I and ESSER programs and minimize the time elapsing between the transfer of funds from GaDOE and the disbursement of such funds by the School District. In addition, these procedures should be documented in writing in accordance with the Uniform Guidance Section 200.302(b)(6). Furthermore, management should develop and implement a monitoring process to ensure that these procedures are followed. Views of Responsible Officials: We concur with this finding.
FA 2022-003 Improve Controls over Cash Management Compliance Requirement: Cash Management Internal Control Impact: Material Weakness Compliance Impact: Material Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Number and Title: 84.010 –Title I Grants to Local Educational Agencies Federal Award Numbers: SO10A200010 (Year: 2021), S010A210010-21A (Year: 2022) Questioned Costs: None Identified Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Numbers and Titles: COVID-19 – 84.425D – Elementary and Secondary School Emergency Relief Fund COVID-19 – 84.425W – American Rescue Plan Elementary and Secondary School Emergency Relief Fund – Homeless Children and Youth Federal Award Numbers: S425D210012 (Year: 2021), S425W210011 (Year: 2021) Questioned Costs: None Identified Repeat of Prior Year Findings: FA 2021-001, FA 2020-001, FA 2019-001, FA 2018-001, FA 2017-002, FA 2016-001, FA 2015-002, FA 2014-003 Description: The School District made cash drawdowns in excess of immediate cash needs for the Title I Grants to Local Educational Agencies and Elementary and Secondary School Emergency Relief Fund programs. III FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Background Information: The School District may request Title I Grants to Local Educational Agencies (Title I) and Elementary and Secondary School Emergency Relief (ESSER) Fund program funds from the Georgia Department of Education (GaDOE) once per month. GaDOE requires the School District to submit DE-0147 – Requests for Reimbursement of Monthly Cash Disbursements through the Grants Accounting Online Reporting System to receive program funds. When a DE-0147 request is submitted and approved, the funds are typically disbursed to the School District through an electronic payment process the next week. The School District submitted DE-0147 requests to receive a total of $390,112 in Title I funds and a total of $498,996 in ESSER funds from GaDOE during the fiscal year under review. Criteria: As a recipient of federal awards, the School District is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 – Internal Controls. Provisions included in the Uniform Guidance Section 200.305(b) state that “For non-Federal entities other than states, payment methods must minimize the time elapsing between the transfer of funds… the pass-through entity and the disbursement by the non-Federal entity.” In addition, the Uniform Guidance Section 200.302(b)(6) requires the entity to develop written cash management procedures. Further, as noted in the Uniform Guidance Section 200.511, management is responsible for implementing reported corrective action to findings from previous audits. Condition: A review of all cash drawdowns and disbursements related to the Title I and ESSER programs was performed to determine if any excessive cash balances were maintained during the fiscal year under review. Cash balances in excess of program materiality were maintained for the Title I program for 365 days and the ESSER program for 121 days. Additionally, it was noted that the School District did not have appropriate internal controls in place over the cash drawdown process. Cause: In discussing this issue with the School District, they indicated that the lack of review of federal grants resulted in excess cash drawdown requests. Effect: The School District was not in compliance with the Uniform Guidance and GaDOE guidance. In addition, the School District could potentially accrue an interest liability that would be owed back to the federal government. Furthermore, when the School District cannot meet the requirement to minimize the time elapsing between the transfer of funds and disbursement of those funds, provisions included in the Uniform Guidance allow GaDOE to change the method by which the School District is transferred funds and delay the School District’s receipt of these funds. This may include a requirement by GaDOE to submit invoices prior to being reimbursed for program expenditures. III FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Recommendation: The School District should establish procedures to accurately forecast the cash needs of the Title I and ESSER programs and minimize the time elapsing between the transfer of funds from GaDOE and the disbursement of such funds by the School District. In addition, these procedures should be documented in writing in accordance with the Uniform Guidance Section 200.302(b)(6). Furthermore, management should develop and implement a monitoring process to ensure that these procedures are followed. Views of Responsible Officials: We concur with this finding.
FA 2022-003 Improve Controls over Cash Management Compliance Requirement: Cash Management Internal Control Impact: Material Weakness Compliance Impact: Material Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Number and Title: 84.010 –Title I Grants to Local Educational Agencies Federal Award Numbers: SO10A200010 (Year: 2021), S010A210010-21A (Year: 2022) Questioned Costs: None Identified Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Numbers and Titles: COVID-19 – 84.425D – Elementary and Secondary School Emergency Relief Fund COVID-19 – 84.425W – American Rescue Plan Elementary and Secondary School Emergency Relief Fund – Homeless Children and Youth Federal Award Numbers: S425D210012 (Year: 2021), S425W210011 (Year: 2021) Questioned Costs: None Identified Repeat of Prior Year Findings: FA 2021-001, FA 2020-001, FA 2019-001, FA 2018-001, FA 2017-002, FA 2016-001, FA 2015-002, FA 2014-003 Description: The School District made cash drawdowns in excess of immediate cash needs for the Title I Grants to Local Educational Agencies and Elementary and Secondary School Emergency Relief Fund programs. III FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Background Information: The School District may request Title I Grants to Local Educational Agencies (Title I) and Elementary and Secondary School Emergency Relief (ESSER) Fund program funds from the Georgia Department of Education (GaDOE) once per month. GaDOE requires the School District to submit DE-0147 – Requests for Reimbursement of Monthly Cash Disbursements through the Grants Accounting Online Reporting System to receive program funds. When a DE-0147 request is submitted and approved, the funds are typically disbursed to the School District through an electronic payment process the next week. The School District submitted DE-0147 requests to receive a total of $390,112 in Title I funds and a total of $498,996 in ESSER funds from GaDOE during the fiscal year under review. Criteria: As a recipient of federal awards, the School District is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 – Internal Controls. Provisions included in the Uniform Guidance Section 200.305(b) state that “For non-Federal entities other than states, payment methods must minimize the time elapsing between the transfer of funds… the pass-through entity and the disbursement by the non-Federal entity.” In addition, the Uniform Guidance Section 200.302(b)(6) requires the entity to develop written cash management procedures. Further, as noted in the Uniform Guidance Section 200.511, management is responsible for implementing reported corrective action to findings from previous audits. Condition: A review of all cash drawdowns and disbursements related to the Title I and ESSER programs was performed to determine if any excessive cash balances were maintained during the fiscal year under review. Cash balances in excess of program materiality were maintained for the Title I program for 365 days and the ESSER program for 121 days. Additionally, it was noted that the School District did not have appropriate internal controls in place over the cash drawdown process. Cause: In discussing this issue with the School District, they indicated that the lack of review of federal grants resulted in excess cash drawdown requests. Effect: The School District was not in compliance with the Uniform Guidance and GaDOE guidance. In addition, the School District could potentially accrue an interest liability that would be owed back to the federal government. Furthermore, when the School District cannot meet the requirement to minimize the time elapsing between the transfer of funds and disbursement of those funds, provisions included in the Uniform Guidance allow GaDOE to change the method by which the School District is transferred funds and delay the School District’s receipt of these funds. This may include a requirement by GaDOE to submit invoices prior to being reimbursed for program expenditures. III FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Recommendation: The School District should establish procedures to accurately forecast the cash needs of the Title I and ESSER programs and minimize the time elapsing between the transfer of funds from GaDOE and the disbursement of such funds by the School District. In addition, these procedures should be documented in writing in accordance with the Uniform Guidance Section 200.302(b)(6). Furthermore, management should develop and implement a monitoring process to ensure that these procedures are followed. Views of Responsible Officials: We concur with this finding.
FA 2022-004 Strengthen Controls over Financial Reporting Compliance Requirement: Reporting Internal Control Impact: Material Weakness Compliance Impact: Material Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Number and Title: 84.010 – Title I Grants to Local Educational Agencies Federal Award Numbers: S010A200010 (Year: 2021), S010A210010-21A (Year: 2022) Questioned Costs: $37,644 Repeat of Prior Year Findings: FA 2021-002, FA 2019-002 Description: The School District did not file accurate completion reports for the Title I Grants to Local Educational Agencies program. Background Information: The Georgia Department of Education (GaDOE) requires the School District to submit a completion report by October 30 after the 15-month period of performance associated with the Title I Grants to Local Educational Agencies (Title I) program ends. These completion reports are filed through the Grants Application section of the MyGaDOE web portal and reflect budgeted and actual expenditure information for the Title I program for the reporting period. If the total expenditures reflected on the completion report are more than the Title I program funds received by the School District for the grant period, a DE-0147 – Request for Reimbursement of Monthly Cash Disbursements will be automatically generated and the additional funds due to the School District will be disbursed appropriately. Conversely, if the total funds received for the grant period exceed the total expenditures reflected on the completion report, the Grants Application will prompt the School District to enter a check number for the required refund of excess funds drawn down. Therefore, it is imperative that completion reports are filed by the School District in an accurate and timely manner. III FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Criteria: As a recipient of federal awards, the Institution is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 – Internal Controls. Provisions included in the Uniform Guidance Section 200.302(a) state in part that “the non-Federal entity’s financial management systems must…be sufficient to permit the preparation of reports required by general and program-specific terms and conditions.” In addition, Provisions included in the Uniform Guidance Section 200.302(b)(2) state in part that the non-Federal entity’s financial management systems must provide for “accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements.” Further, as noted in the Uniform Guidance Section 200.511, management is responsible for implementing reported corrective action to findings from previous audits. Condition: A review of the School District’s accounting records and the completion report related to the Title I-A, Improving Academic Achievement of the Disadvantaged program for the period ending September 30, 2022, revealed that the expenditures were over reported by $37,644. Questioned Cost: Questioned cost of $37,644 were identified for cash drawdowns in excess of reimbursable expenditures. Cause: In discussing this deficiency with the School District, they stated these issues were a result of turnover within the Central Office. Effect: The School District was not in compliance with the Uniform Guidance and GaDOE guidance. Failure to accurately report federal award expenditures through the completion report process could lead to the filing of DE-0147 reimbursement requests with GaDOE that do not support actual expenditures. Therefore, the School District obtained more federal funding than they were eligible to receive. Additionally, this funding must be returned to GaDOE. Recommendation: The School District should establish internal control procedures to ensure that completion reports submitted to GaDOE are supported by the accounting records and DE-0147 reimbursement requests are prepared based upon actual expenditures incurred. In addition, management should develop and implement a monitoring process to ensure that control procedures are being followed. Views of Responsible Officials: We concur with this finding.
FA 2022-004 Strengthen Controls over Financial Reporting Compliance Requirement: Reporting Internal Control Impact: Material Weakness Compliance Impact: Material Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Number and Title: 84.010 – Title I Grants to Local Educational Agencies Federal Award Numbers: S010A200010 (Year: 2021), S010A210010-21A (Year: 2022) Questioned Costs: $37,644 Repeat of Prior Year Findings: FA 2021-002, FA 2019-002 Description: The School District did not file accurate completion reports for the Title I Grants to Local Educational Agencies program. Background Information: The Georgia Department of Education (GaDOE) requires the School District to submit a completion report by October 30 after the 15-month period of performance associated with the Title I Grants to Local Educational Agencies (Title I) program ends. These completion reports are filed through the Grants Application section of the MyGaDOE web portal and reflect budgeted and actual expenditure information for the Title I program for the reporting period. If the total expenditures reflected on the completion report are more than the Title I program funds received by the School District for the grant period, a DE-0147 – Request for Reimbursement of Monthly Cash Disbursements will be automatically generated and the additional funds due to the School District will be disbursed appropriately. Conversely, if the total funds received for the grant period exceed the total expenditures reflected on the completion report, the Grants Application will prompt the School District to enter a check number for the required refund of excess funds drawn down. Therefore, it is imperative that completion reports are filed by the School District in an accurate and timely manner. III FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Criteria: As a recipient of federal awards, the Institution is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 – Internal Controls. Provisions included in the Uniform Guidance Section 200.302(a) state in part that “the non-Federal entity’s financial management systems must…be sufficient to permit the preparation of reports required by general and program-specific terms and conditions.” In addition, Provisions included in the Uniform Guidance Section 200.302(b)(2) state in part that the non-Federal entity’s financial management systems must provide for “accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements.” Further, as noted in the Uniform Guidance Section 200.511, management is responsible for implementing reported corrective action to findings from previous audits. Condition: A review of the School District’s accounting records and the completion report related to the Title I-A, Improving Academic Achievement of the Disadvantaged program for the period ending September 30, 2022, revealed that the expenditures were over reported by $37,644. Questioned Cost: Questioned cost of $37,644 were identified for cash drawdowns in excess of reimbursable expenditures. Cause: In discussing this deficiency with the School District, they stated these issues were a result of turnover within the Central Office. Effect: The School District was not in compliance with the Uniform Guidance and GaDOE guidance. Failure to accurately report federal award expenditures through the completion report process could lead to the filing of DE-0147 reimbursement requests with GaDOE that do not support actual expenditures. Therefore, the School District obtained more federal funding than they were eligible to receive. Additionally, this funding must be returned to GaDOE. Recommendation: The School District should establish internal control procedures to ensure that completion reports submitted to GaDOE are supported by the accounting records and DE-0147 reimbursement requests are prepared based upon actual expenditures incurred. In addition, management should develop and implement a monitoring process to ensure that control procedures are being followed. Views of Responsible Officials: We concur with this finding.
2022-002 – INTERNAL CONTROL OVER COMPLIANCE MATERIAL WEAKNESS CRITERIA Per Uniform Guidance (2 CFR Part 200.302), the grantee must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the grantee is managing the Federal award in compliance with statutes, regulations, and the terms and conditions of the Federal award. CONDITION The Authority did not maintain proper supporting documentation of program expenses, and proper authorization of expenses could not be determined. CAUSE The Authority did not have proper controls over certain the Housing Choice Voucher program expenses. EFFECT This deficiency in internal controls resulted in unsupported transactions. QUESTIONED COSTS Likely questioned costs are estimated to be less than $25,000. CONTEXT We reviewed the Authority’s internal controls over compliance with federal awards. REPEAT FINDING Not a repeat finding. RECOMMENDATION We recommend the Authority’s management review its internal control practices and ensure proper program authorization of program expenses. AUDITEE’S RESPONSE AND PLANNED CORRECTIVE ACTION See Corrective Action Plan.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.