FINDING 2022-003 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children, COVID-19 - Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2020-2021, 2021-2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed or implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. INDIANA STATE BOARD OF ACCOUNTS 23 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Monthly Sponsor Claims for Reimbursement (Claims) were submitted to the Indiana Department of Education (IDOE) based upon meals served for the month. The Claims were prepared by the Food Service Manager or Chief Financial Officer without an oversight or review process in place to prevent, or detect and correct, errors. For three of the six Claims tested, there were differences between the Claims submitted and the School Corporation's summary meal count reports. The three Claims had less meals served than the School Corporation's summary meal count reports, which resulted in underclaimed meals totaling $9,735. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "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). . . ." 2 CFR 200.302(b) (Uniform Guidance) 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 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. . . ." 2 CFR 200.302(b) (Revised Uniform Guidance) 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . ." Cause Management had not designed or implemented a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. INDIANA STATE BOARD OF ACCOUNTS 24 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-003 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children, COVID-19 - Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2020-2021, 2021-2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed or implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. INDIANA STATE BOARD OF ACCOUNTS 23 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Monthly Sponsor Claims for Reimbursement (Claims) were submitted to the Indiana Department of Education (IDOE) based upon meals served for the month. The Claims were prepared by the Food Service Manager or Chief Financial Officer without an oversight or review process in place to prevent, or detect and correct, errors. For three of the six Claims tested, there were differences between the Claims submitted and the School Corporation's summary meal count reports. The three Claims had less meals served than the School Corporation's summary meal count reports, which resulted in underclaimed meals totaling $9,735. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "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). . . ." 2 CFR 200.302(b) (Uniform Guidance) 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 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. . . ." 2 CFR 200.302(b) (Revised Uniform Guidance) 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . ." Cause Management had not designed or implemented a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. INDIANA STATE BOARD OF ACCOUNTS 24 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-003 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children, COVID-19 - Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2020-2021, 2021-2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed or implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. INDIANA STATE BOARD OF ACCOUNTS 23 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Monthly Sponsor Claims for Reimbursement (Claims) were submitted to the Indiana Department of Education (IDOE) based upon meals served for the month. The Claims were prepared by the Food Service Manager or Chief Financial Officer without an oversight or review process in place to prevent, or detect and correct, errors. For three of the six Claims tested, there were differences between the Claims submitted and the School Corporation's summary meal count reports. The three Claims had less meals served than the School Corporation's summary meal count reports, which resulted in underclaimed meals totaling $9,735. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "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). . . ." 2 CFR 200.302(b) (Uniform Guidance) 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 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. . . ." 2 CFR 200.302(b) (Revised Uniform Guidance) 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . ." Cause Management had not designed or implemented a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. INDIANA STATE BOARD OF ACCOUNTS 24 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-003 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children, COVID-19 - Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2020-2021, 2021-2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed or implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. INDIANA STATE BOARD OF ACCOUNTS 23 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Monthly Sponsor Claims for Reimbursement (Claims) were submitted to the Indiana Department of Education (IDOE) based upon meals served for the month. The Claims were prepared by the Food Service Manager or Chief Financial Officer without an oversight or review process in place to prevent, or detect and correct, errors. For three of the six Claims tested, there were differences between the Claims submitted and the School Corporation's summary meal count reports. The three Claims had less meals served than the School Corporation's summary meal count reports, which resulted in underclaimed meals totaling $9,735. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "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). . . ." 2 CFR 200.302(b) (Uniform Guidance) 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 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. . . ." 2 CFR 200.302(b) (Revised Uniform Guidance) 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . ." Cause Management had not designed or implemented a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. INDIANA STATE BOARD OF ACCOUNTS 24 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-003 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children, COVID-19 - Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2020-2021, 2021-2022 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed or implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. INDIANA STATE BOARD OF ACCOUNTS 23 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Monthly Sponsor Claims for Reimbursement (Claims) were submitted to the Indiana Department of Education (IDOE) based upon meals served for the month. The Claims were prepared by the Food Service Manager or Chief Financial Officer without an oversight or review process in place to prevent, or detect and correct, errors. For three of the six Claims tested, there were differences between the Claims submitted and the School Corporation's summary meal count reports. The three Claims had less meals served than the School Corporation's summary meal count reports, which resulted in underclaimed meals totaling $9,735. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "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). . . ." 2 CFR 200.302(b) (Uniform Guidance) 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 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. . . ." 2 CFR 200.302(b) (Revised Uniform Guidance) 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . ." Cause Management had not designed or implemented a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective system of internal controls enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. INDIANA STATE BOARD OF ACCOUNTS 24 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal controls to ensure compliance and comply with the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Criteria: 2 CFR section 200.302 stipulates that the financial management system of the nonfederal entity must provide for written procedures for determining the allowability of costs in accordance with subpart E (cost principles) and the terms and conditions of the Federal award. Condition: UCAP has no written procedures for determining the allowability of costs in accordance with subpart E (cost principles) and the terms and conditions of the Federal award. Context: This is a condition identified based on review of Uniform Guidance requirements. Questioned Cost: $ 0 The known and likely questioned costs are less than the reportable threshold. Cause: No written procedures were established, therefore the procedures for determining the allowability of costs were not performed consistently. Effect: We noted instances where unallowable costs were charged to the federal grant. Identification of a Repeat Finding: This is not a repeat finding. Recommendation: We suggest that the procedures for determining the allowability of costs in accordance with cost principles be written so that the compliance requirement as explained in 2 CFR Section 200 Subpart D section 200.302 can be satisfied, and we suggest that such procedures to be followed consistently. Views of Responsible Officials and Planned Corrective Action Plan: UCAP agrees with the finding. Planned Corrective Action: UCAP has set up written procedures and descriptions of costs which was submitted to all executive and program staff to be used prior to submission of program expenditures. This was provided to program managers in order to ensure that the cost allocations are followed according to procedures. We have also implemented an internal policy in our financial reporting department to ensure that unallowable costs are not charged to expenditures in error through a thorough two-party review of all expenditures charged to grants. With the several layers of review, it will ensure that no unallowable costs are charged to federal grants. Responsible Official: Maryland Hutchinson, Fiscal Manager. Anticipated Completion Date: This was completed as of 3/31/2023.
FINDING 2022-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the four Elementary and Secondary School Emergency Relief (ESSER) annual data reports (Reports) and the two Governor's Emergency Education Relief Fund (GEER) annual data reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, the GEER I, Year 1 report was not supported by the School Corporation's records. Two key line items chosen for review and verification were determined to be incorrectly reported. The FTE Position as of September 13, 2020, was reported as zero, and Funds Expended Total was overstated by $18,958. The lack of internal controls and noncompliance were systemic issued throughout the audit period. Criteria 2 CFR 200.303 states in part: "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). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or 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. . . ." 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, 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 format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the four Elementary and Secondary School Emergency Relief (ESSER) annual data reports (Reports) and the two Governor's Emergency Education Relief Fund (GEER) annual data reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, the GEER I, Year 1 report was not supported by the School Corporation's records. Two key line items chosen for review and verification were determined to be incorrectly reported. The FTE Position as of September 13, 2020, was reported as zero, and Funds Expended Total was overstated by $18,958. The lack of internal controls and noncompliance were systemic issued throughout the audit period. Criteria 2 CFR 200.303 states in part: "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). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or 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. . . ." 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, 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 format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the four Elementary and Secondary School Emergency Relief (ESSER) annual data reports (Reports) and the two Governor's Emergency Education Relief Fund (GEER) annual data reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, the GEER I, Year 1 report was not supported by the School Corporation's records. Two key line items chosen for review and verification were determined to be incorrectly reported. The FTE Position as of September 13, 2020, was reported as zero, and Funds Expended Total was overstated by $18,958. The lack of internal controls and noncompliance were systemic issued throughout the audit period. Criteria 2 CFR 200.303 states in part: "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). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or 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. . . ." 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, 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 format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the four Elementary and Secondary School Emergency Relief (ESSER) annual data reports (Reports) and the two Governor's Emergency Education Relief Fund (GEER) annual data reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, the GEER I, Year 1 report was not supported by the School Corporation's records. Two key line items chosen for review and verification were determined to be incorrectly reported. The FTE Position as of September 13, 2020, was reported as zero, and Funds Expended Total was overstated by $18,958. The lack of internal controls and noncompliance were systemic issued throughout the audit period. Criteria 2 CFR 200.303 states in part: "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). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or 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. . . ." 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, 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 format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the four Elementary and Secondary School Emergency Relief (ESSER) annual data reports (Reports) and the two Governor's Emergency Education Relief Fund (GEER) annual data reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, the GEER I, Year 1 report was not supported by the School Corporation's records. Two key line items chosen for review and verification were determined to be incorrectly reported. The FTE Position as of September 13, 2020, was reported as zero, and Funds Expended Total was overstated by $18,958. The lack of internal controls and noncompliance were systemic issued throughout the audit period. Criteria 2 CFR 200.303 states in part: "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). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or 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. . . ." 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, 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 format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the four Elementary and Secondary School Emergency Relief (ESSER) annual data reports (Reports) and the two Governor's Emergency Education Relief Fund (GEER) annual data reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, the GEER I, Year 1 report was not supported by the School Corporation's records. Two key line items chosen for review and verification were determined to be incorrectly reported. The FTE Position as of September 13, 2020, was reported as zero, and Funds Expended Total was overstated by $18,958. The lack of internal controls and noncompliance were systemic issued throughout the audit period. Criteria 2 CFR 200.303 states in part: "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). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or 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. . . ." 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, 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 format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2022-004 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the four Elementary and Secondary School Emergency Relief (ESSER) annual data reports (Reports) and the two Governor's Emergency Education Relief Fund (GEER) annual data reports (Reports) were complete and accurately submitted. The Reports were prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Additionally, the GEER I, Year 1 report was not supported by the School Corporation's records. Two key line items chosen for review and verification were determined to be incorrectly reported. The FTE Position as of September 13, 2020, was reported as zero, and Funds Expended Total was overstated by $18,958. The lack of internal controls and noncompliance were systemic issued throughout the audit period. Criteria 2 CFR 200.303 states in part: "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). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or 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. . . ." 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, 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 format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding 2022-003 Information on the federal program: Subject: Education Stabilization Fund (ESSER) ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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). . . ." 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER and GEER grant awards. The first report was for the period of March 13, 2020, to September 30, 2020, and was due by January 21, 2021. The second report was for the period of October 1, 2020, to June 30, 2021, and was due by May 13, 2022. For each report submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Additionally, the amount reported on the GEER Report did not agree to underlying detail. The amounts reported on the annual data report for the ESSER funds did agree to the underlying detail without issue. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-003 Information on the federal program: Subject: Education Stabilization Fund (ESSER) ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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). . . ." 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER and GEER grant awards. The first report was for the period of March 13, 2020, to September 30, 2020, and was due by January 21, 2021. The second report was for the period of October 1, 2020, to June 30, 2021, and was due by May 13, 2022. For each report submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Additionally, the amount reported on the GEER Report did not agree to underlying detail. The amounts reported on the annual data report for the ESSER funds did agree to the underlying detail without issue. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-003 Information on the federal program: Subject: Education Stabilization Fund (ESSER) ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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). . . ." 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER and GEER grant awards. The first report was for the period of March 13, 2020, to September 30, 2020, and was due by January 21, 2021. The second report was for the period of October 1, 2020, to June 30, 2021, and was due by May 13, 2022. For each report submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Additionally, the amount reported on the GEER Report did not agree to underlying detail. The amounts reported on the annual data report for the ESSER funds did agree to the underlying detail without issue. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-003 Information on the federal program: Subject: Education Stabilization Fund (ESSER) ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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). . . ." 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER and GEER grant awards. The first report was for the period of March 13, 2020, to September 30, 2020, and was due by January 21, 2021. The second report was for the period of October 1, 2020, to June 30, 2021, and was due by May 13, 2022. For each report submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Additionally, the amount reported on the GEER Report did not agree to underlying detail. The amounts reported on the annual data report for the ESSER funds did agree to the underlying detail without issue. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-02 ? Fiscal Management System, Ensure Compliance with Federal Regulations Over Ac-counting Systems (Material Weakness) Criteria: Management is responsible for establishing and maintaining effective internal control over finan-cial reporting. Internal controls should allow management or employees in the normal course of perform-ing their assigned functions to prevent or detect material misstatements in the financial reporting of all dis-trict funds. The Internal Control ? Integrated Framework, published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) and the U.S. Government Accountability Office Standards for Internal Control in the Federal Government specify that a satisfactory control environment is only effective when there are adequate control activities in place. Effective control activities dictate that a review is performed to verify the accuracy and completeness of financial information reported. The Federal Grant Activity Schedule captures amounts that must be accurate and complete in order to ensure the accuracy of the fi-nancial and federal information reported on such schedule to verify the accuracy and completeness of fi-nancial information reported. CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial management sys-tem of each non-Federal entity provide the following. Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Accurate, current, and complete disclosure of the financial results of each Federal award or program. Condition: During the audit of Umpqua Public Transportation District for Fiscal Year 2021-2022, the dis-trict provided auditor with Separate and Identifiable General Ledger reports using QuickBooks Jobs fea-ture, that showed identification between individual grant expenditures and revenues. Entries were prepared or recorded using the jobs feature, but not on a timely basis throughout the year, as portions were complet-ed retroactively, and general ledger restated for the entire fiscal year. This deficiency was instrumental in causing the general ledger to be inadequate for financial and Federal Award Reporting for a large portion of the year. Cause: The District had relied on inadequately trained individuals to record activities and setup of their general ledger. The accounting records were retroactively constructed to meet Federal award reporting pur-poses, but late in the fiscal year. District management did not have sufficient training or monitoring poli-cies to recognize and correct the deficiency. Effect or Potential Effect: Failure to record transactions timely into the general ledger for Umpqua Public Transportation District, and lack of proper accounting structure separating revenues and expenditures into each Federal and State or Local grant may result in transactions not being properly included in the district?s financial statements. The potential for incorrect financial reporting, and untimely results, with the inability to rely on the general ledger for correct and timely information, may also cause misstatement of financial statements, and inappropriate reporting of federal awards. Questioned Cost: No Context: Restatement of the general ledger was necessary for proper reporting of grants for the Schedule of Federal Awards. Tracking of matching local and state grants remains ineffective. Repeat of a Prior-Year Finding: Yes, Financial Statement Findings 2021-4 Recommendation: We recommend that Umpqua Public Transportation District improve their general ledg-er structure to meet the requirement for separate accounts for Federal awards for program revenues and program expenditures. In addition, we recommend that the district establish policies and procedures to en-sure that all required matching of grant expenditures be recorded in sufficient detail tracking to ensure that all matching program revenues and expenditures are reported correctly in the fiscal year. We also recom-mend that the district continue training program, policies and procedures for staff and management for ad-ministering and recording Federal Grant revenues and expenditures. District's Response: The District concurs with the recommendation. General ledger accounts separating Federal, State, and Local revenues and related expenditures will be adhered to and further training imple-mented. Corrective Action Plan: The District hired a Finance Manager to oversee the day-to-day financial opera-tions of the district. The Finance Manager retroactively created accounting records to separate grant reve-nues and related expenditures, for both Federal grant records as well as State grant records. The Finance Manager will improve the general ledger to allow the recording of the matching identification for each fed-eral grant. This will allow the activities of the district to be recorded in a manner that allows for reporting in compliance with federal requirements. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit Distric
Finding 2022-03 - Source Documentation (Significant Deficiency) CFDA Title and Number: 20.513 (5310) Enhanced Mobility of Seniors and Individuals with Disabili-ties. Grant Agreement 33573 (City of Reedsport). Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Manage-ment CFDA Title and Number: 20.509 (5311) CARES 5311 Operating Assistance. Formula Grants for Rural Areas and Tribal Transit Program. Grant Agreement 34196. Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Management Criteria: 2 CFR Part 200.302(b)(1) The financial management system of each non-federal entity must provide for the following: Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. 200.302(b)(2) Accurate, current, and complete dis-closure of the financial results of each Federal award or program in accordance with the reporting require-ments set forth in 200.328 and 200.329. Condition: The District prepared drawdown calculations according to an internal reconciliation spread-sheet tool outside of the General Ledger rather than utilizing proper General Ledger expenditure and sup-porting backup information. Cause: General ledger reconciling procedures were not enforced or completed. Effect or Potential Effect: Activities or costs that are allowed or allowable could potentially be overpaid or underpaid. Questioned Cost: No Context: During our testing of expenditures, we found no Federal drawdown reimbursement requests se-lected for testing that did not reconcile to their corresponding expenditures. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2021-8 Recommendation: The District should establish policies and procedures to ensure that each drawdown is reconciled with supporting expenditure documents and general ledger postings prior to reimbursement be-ing requested. District's Response: The District had relied on inadequately skilled or trained individuals for recording activity in the general ledger. General ledger activity was not available timely, or in sufficient quality such that the General Manager could rely upon the general ledger to gather information for reporting to grantors. Consequently, the General Manager developed and relied upon their own spreadsheet records for grant re-imbursement requests. Corrective Action Plan: The District has hired a Finance Manager to oversee the day-to-day financial operations of the District. The Finance Manager has made improvements in the general ledger recording and reporting for federal award requirements, but had not yet been able to eliminate the reliance upon the General Manager?s spreadsheet tool for grant management. The Finance Manager will continue to develop the general ledger procedures such that all necessary federal and state grant reporting requirements will be met within the general ledger. This will allow the activities of the district to be recorded and managed on a timely basis. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2022-04 ? Fiscal Management System (Material Weakness) Criteria: CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial manage-ment system of each non-Federal entity provide the following. Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Accurate, cur-rent, and complete disclosure of the financial results of each Federal award or program. Condition: During the audit of Umpqua Public Transportation District for Fiscal Year 2021-2022, the dis-trict provided auditor with Separate and Identifiable General Ledger reports that showed a clear division be-tween Federal, State and Local expenditures and revenues. However, the separation was done retroactivity and was not been completed for the entire fiscal year or life of grants. This deficiency was instrumental in causing the general ledger to be inadequate for financial and Federal Award Reporting. Cause: The District had originally relied on unskilled individuals for structuring and recording activities in their general ledger. District management did not have sufficient staff or monitoring policies to recognize and correct the deficiency. While trained staff have been hired at Umpqua Public Transportation District, and improvements made to the general ledger and recording of Federal grants, improvements are still nec-essary to meet the full requirements of CFR Part 200.302.b Auditee Responsibilities. Effect or Potential Effect: Potential for incorrect financial reporting, and untimely results, with the inabil-ity to rely on the general ledger for correct and timely information. Questioned Cost: No Context: While federal grant revenues and expenditures are now tracked using the general ledger ?jobs? indicators, additional recording is needed to track the matching portions of the costs and revenues of those federal grants. The lack of completed effort at separating revenues or expenditures by grant may lead to er-rors in reporting expenditures for Federal Awards. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2021-11 Recommendation: We recommend that Umpqua Public Transportation District improve their general ledg-er structure to meet the requirement for separate accounts for Federal awards for program revenues and program expenditures. We also recommend that the district establish policies and procedures to ensure that all program revenues and expenditures are reported in the correct fiscal year. In addition, we recommend that the district establish a training program and policies and procedures for staff and management to re-ceive appropriate training for administering and recording Federal Grant revenues and expenditures. District's Response: The District concurs with the recommendation. General ledger accounts separating Federal, State, and Local revenues and related expenditures will be designed and implemented. Corrective Action Plan: The District has hired a Finance Manager to oversee the day-to-day financial operations of the district. The Finance Manager has developed an accounting system for separating Feder-al, State, and Local revenues and related expenditures. This will allow the activities of the district to be rec-orded in a manner that allows for reporting in compliance with federal requirements. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2022-02 ? Fiscal Management System, Ensure Compliance with Federal Regulations Over Ac-counting Systems (Material Weakness) Criteria: Management is responsible for establishing and maintaining effective internal control over finan-cial reporting. Internal controls should allow management or employees in the normal course of perform-ing their assigned functions to prevent or detect material misstatements in the financial reporting of all dis-trict funds. The Internal Control ? Integrated Framework, published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) and the U.S. Government Accountability Office Standards for Internal Control in the Federal Government specify that a satisfactory control environment is only effective when there are adequate control activities in place. Effective control activities dictate that a review is performed to verify the accuracy and completeness of financial information reported. The Federal Grant Activity Schedule captures amounts that must be accurate and complete in order to ensure the accuracy of the fi-nancial and federal information reported on such schedule to verify the accuracy and completeness of fi-nancial information reported. CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial management sys-tem of each non-Federal entity provide the following. Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Accurate, current, and complete disclosure of the financial results of each Federal award or program. Condition: During the audit of Umpqua Public Transportation District for Fiscal Year 2021-2022, the dis-trict provided auditor with Separate and Identifiable General Ledger reports using QuickBooks Jobs fea-ture, that showed identification between individual grant expenditures and revenues. Entries were prepared or recorded using the jobs feature, but not on a timely basis throughout the year, as portions were complet-ed retroactively, and general ledger restated for the entire fiscal year. This deficiency was instrumental in causing the general ledger to be inadequate for financial and Federal Award Reporting for a large portion of the year. Cause: The District had relied on inadequately trained individuals to record activities and setup of their general ledger. The accounting records were retroactively constructed to meet Federal award reporting pur-poses, but late in the fiscal year. District management did not have sufficient training or monitoring poli-cies to recognize and correct the deficiency. Effect or Potential Effect: Failure to record transactions timely into the general ledger for Umpqua Public Transportation District, and lack of proper accounting structure separating revenues and expenditures into each Federal and State or Local grant may result in transactions not being properly included in the district?s financial statements. The potential for incorrect financial reporting, and untimely results, with the inability to rely on the general ledger for correct and timely information, may also cause misstatement of financial statements, and inappropriate reporting of federal awards. Questioned Cost: No Context: Restatement of the general ledger was necessary for proper reporting of grants for the Schedule of Federal Awards. Tracking of matching local and state grants remains ineffective. Repeat of a Prior-Year Finding: Yes, Financial Statement Findings 2021-4 Recommendation: We recommend that Umpqua Public Transportation District improve their general ledg-er structure to meet the requirement for separate accounts for Federal awards for program revenues and program expenditures. In addition, we recommend that the district establish policies and procedures to en-sure that all required matching of grant expenditures be recorded in sufficient detail tracking to ensure that all matching program revenues and expenditures are reported correctly in the fiscal year. We also recom-mend that the district continue training program, policies and procedures for staff and management for ad-ministering and recording Federal Grant revenues and expenditures. District's Response: The District concurs with the recommendation. General ledger accounts separating Federal, State, and Local revenues and related expenditures will be adhered to and further training imple-mented. Corrective Action Plan: The District hired a Finance Manager to oversee the day-to-day financial opera-tions of the district. The Finance Manager retroactively created accounting records to separate grant reve-nues and related expenditures, for both Federal grant records as well as State grant records. The Finance Manager will improve the general ledger to allow the recording of the matching identification for each fed-eral grant. This will allow the activities of the district to be recorded in a manner that allows for reporting in compliance with federal requirements. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit Distric
Finding 2022-03 - Source Documentation (Significant Deficiency) CFDA Title and Number: 20.513 (5310) Enhanced Mobility of Seniors and Individuals with Disabili-ties. Grant Agreement 33573 (City of Reedsport). Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Manage-ment CFDA Title and Number: 20.509 (5311) CARES 5311 Operating Assistance. Formula Grants for Rural Areas and Tribal Transit Program. Grant Agreement 34196. Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Management Criteria: 2 CFR Part 200.302(b)(1) The financial management system of each non-federal entity must provide for the following: Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. 200.302(b)(2) Accurate, current, and complete dis-closure of the financial results of each Federal award or program in accordance with the reporting require-ments set forth in 200.328 and 200.329. Condition: The District prepared drawdown calculations according to an internal reconciliation spread-sheet tool outside of the General Ledger rather than utilizing proper General Ledger expenditure and sup-porting backup information. Cause: General ledger reconciling procedures were not enforced or completed. Effect or Potential Effect: Activities or costs that are allowed or allowable could potentially be overpaid or underpaid. Questioned Cost: No Context: During our testing of expenditures, we found no Federal drawdown reimbursement requests se-lected for testing that did not reconcile to their corresponding expenditures. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2021-8 Recommendation: The District should establish policies and procedures to ensure that each drawdown is reconciled with supporting expenditure documents and general ledger postings prior to reimbursement be-ing requested. District's Response: The District had relied on inadequately skilled or trained individuals for recording activity in the general ledger. General ledger activity was not available timely, or in sufficient quality such that the General Manager could rely upon the general ledger to gather information for reporting to grantors. Consequently, the General Manager developed and relied upon their own spreadsheet records for grant re-imbursement requests. Corrective Action Plan: The District has hired a Finance Manager to oversee the day-to-day financial operations of the District. The Finance Manager has made improvements in the general ledger recording and reporting for federal award requirements, but had not yet been able to eliminate the reliance upon the General Manager?s spreadsheet tool for grant management. The Finance Manager will continue to develop the general ledger procedures such that all necessary federal and state grant reporting requirements will be met within the general ledger. This will allow the activities of the district to be recorded and managed on a timely basis. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2022-04 ? Fiscal Management System (Material Weakness) Criteria: CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial manage-ment system of each non-Federal entity provide the following. Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Accurate, cur-rent, and complete disclosure of the financial results of each Federal award or program. Condition: During the audit of Umpqua Public Transportation District for Fiscal Year 2021-2022, the dis-trict provided auditor with Separate and Identifiable General Ledger reports that showed a clear division be-tween Federal, State and Local expenditures and revenues. However, the separation was done retroactivity and was not been completed for the entire fiscal year or life of grants. This deficiency was instrumental in causing the general ledger to be inadequate for financial and Federal Award Reporting. Cause: The District had originally relied on unskilled individuals for structuring and recording activities in their general ledger. District management did not have sufficient staff or monitoring policies to recognize and correct the deficiency. While trained staff have been hired at Umpqua Public Transportation District, and improvements made to the general ledger and recording of Federal grants, improvements are still nec-essary to meet the full requirements of CFR Part 200.302.b Auditee Responsibilities. Effect or Potential Effect: Potential for incorrect financial reporting, and untimely results, with the inabil-ity to rely on the general ledger for correct and timely information. Questioned Cost: No Context: While federal grant revenues and expenditures are now tracked using the general ledger ?jobs? indicators, additional recording is needed to track the matching portions of the costs and revenues of those federal grants. The lack of completed effort at separating revenues or expenditures by grant may lead to er-rors in reporting expenditures for Federal Awards. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2021-11 Recommendation: We recommend that Umpqua Public Transportation District improve their general ledg-er structure to meet the requirement for separate accounts for Federal awards for program revenues and program expenditures. We also recommend that the district establish policies and procedures to ensure that all program revenues and expenditures are reported in the correct fiscal year. In addition, we recommend that the district establish a training program and policies and procedures for staff and management to re-ceive appropriate training for administering and recording Federal Grant revenues and expenditures. District's Response: The District concurs with the recommendation. General ledger accounts separating Federal, State, and Local revenues and related expenditures will be designed and implemented. Corrective Action Plan: The District has hired a Finance Manager to oversee the day-to-day financial operations of the district. The Finance Manager has developed an accounting system for separating Feder-al, State, and Local revenues and related expenditures. This will allow the activities of the district to be rec-orded in a manner that allows for reporting in compliance with federal requirements. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2022-02 ? Fiscal Management System, Ensure Compliance with Federal Regulations Over Ac-counting Systems (Material Weakness) Criteria: Management is responsible for establishing and maintaining effective internal control over finan-cial reporting. Internal controls should allow management or employees in the normal course of perform-ing their assigned functions to prevent or detect material misstatements in the financial reporting of all dis-trict funds. The Internal Control ? Integrated Framework, published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) and the U.S. Government Accountability Office Standards for Internal Control in the Federal Government specify that a satisfactory control environment is only effective when there are adequate control activities in place. Effective control activities dictate that a review is performed to verify the accuracy and completeness of financial information reported. The Federal Grant Activity Schedule captures amounts that must be accurate and complete in order to ensure the accuracy of the fi-nancial and federal information reported on such schedule to verify the accuracy and completeness of fi-nancial information reported. CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial management sys-tem of each non-Federal entity provide the following. Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Accurate, current, and complete disclosure of the financial results of each Federal award or program. Condition: During the audit of Umpqua Public Transportation District for Fiscal Year 2021-2022, the dis-trict provided auditor with Separate and Identifiable General Ledger reports using QuickBooks Jobs fea-ture, that showed identification between individual grant expenditures and revenues. Entries were prepared or recorded using the jobs feature, but not on a timely basis throughout the year, as portions were complet-ed retroactively, and general ledger restated for the entire fiscal year. This deficiency was instrumental in causing the general ledger to be inadequate for financial and Federal Award Reporting for a large portion of the year. Cause: The District had relied on inadequately trained individuals to record activities and setup of their general ledger. The accounting records were retroactively constructed to meet Federal award reporting pur-poses, but late in the fiscal year. District management did not have sufficient training or monitoring poli-cies to recognize and correct the deficiency. Effect or Potential Effect: Failure to record transactions timely into the general ledger for Umpqua Public Transportation District, and lack of proper accounting structure separating revenues and expenditures into each Federal and State or Local grant may result in transactions not being properly included in the district?s financial statements. The potential for incorrect financial reporting, and untimely results, with the inability to rely on the general ledger for correct and timely information, may also cause misstatement of financial statements, and inappropriate reporting of federal awards. Questioned Cost: No Context: Restatement of the general ledger was necessary for proper reporting of grants for the Schedule of Federal Awards. Tracking of matching local and state grants remains ineffective. Repeat of a Prior-Year Finding: Yes, Financial Statement Findings 2021-4 Recommendation: We recommend that Umpqua Public Transportation District improve their general ledg-er structure to meet the requirement for separate accounts for Federal awards for program revenues and program expenditures. In addition, we recommend that the district establish policies and procedures to en-sure that all required matching of grant expenditures be recorded in sufficient detail tracking to ensure that all matching program revenues and expenditures are reported correctly in the fiscal year. We also recom-mend that the district continue training program, policies and procedures for staff and management for ad-ministering and recording Federal Grant revenues and expenditures. District's Response: The District concurs with the recommendation. General ledger accounts separating Federal, State, and Local revenues and related expenditures will be adhered to and further training imple-mented. Corrective Action Plan: The District hired a Finance Manager to oversee the day-to-day financial opera-tions of the district. The Finance Manager retroactively created accounting records to separate grant reve-nues and related expenditures, for both Federal grant records as well as State grant records. The Finance Manager will improve the general ledger to allow the recording of the matching identification for each fed-eral grant. This will allow the activities of the district to be recorded in a manner that allows for reporting in compliance with federal requirements. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit Distric
Finding 2022-03 - Source Documentation (Significant Deficiency) CFDA Title and Number: 20.513 (5310) Enhanced Mobility of Seniors and Individuals with Disabili-ties. Grant Agreement 33573 (City of Reedsport). Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Manage-ment CFDA Title and Number: 20.509 (5311) CARES 5311 Operating Assistance. Formula Grants for Rural Areas and Tribal Transit Program. Grant Agreement 34196. Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Management Criteria: 2 CFR Part 200.302(b)(1) The financial management system of each non-federal entity must provide for the following: Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. 200.302(b)(2) Accurate, current, and complete dis-closure of the financial results of each Federal award or program in accordance with the reporting require-ments set forth in 200.328 and 200.329. Condition: The District prepared drawdown calculations according to an internal reconciliation spread-sheet tool outside of the General Ledger rather than utilizing proper General Ledger expenditure and sup-porting backup information. Cause: General ledger reconciling procedures were not enforced or completed. Effect or Potential Effect: Activities or costs that are allowed or allowable could potentially be overpaid or underpaid. Questioned Cost: No Context: During our testing of expenditures, we found no Federal drawdown reimbursement requests se-lected for testing that did not reconcile to their corresponding expenditures. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2021-8 Recommendation: The District should establish policies and procedures to ensure that each drawdown is reconciled with supporting expenditure documents and general ledger postings prior to reimbursement be-ing requested. District's Response: The District had relied on inadequately skilled or trained individuals for recording activity in the general ledger. General ledger activity was not available timely, or in sufficient quality such that the General Manager could rely upon the general ledger to gather information for reporting to grantors. Consequently, the General Manager developed and relied upon their own spreadsheet records for grant re-imbursement requests. Corrective Action Plan: The District has hired a Finance Manager to oversee the day-to-day financial operations of the District. The Finance Manager has made improvements in the general ledger recording and reporting for federal award requirements, but had not yet been able to eliminate the reliance upon the General Manager?s spreadsheet tool for grant management. The Finance Manager will continue to develop the general ledger procedures such that all necessary federal and state grant reporting requirements will be met within the general ledger. This will allow the activities of the district to be recorded and managed on a timely basis. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2022-04 ? Fiscal Management System (Material Weakness) Criteria: CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial manage-ment system of each non-Federal entity provide the following. Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Accurate, cur-rent, and complete disclosure of the financial results of each Federal award or program. Condition: During the audit of Umpqua Public Transportation District for Fiscal Year 2021-2022, the dis-trict provided auditor with Separate and Identifiable General Ledger reports that showed a clear division be-tween Federal, State and Local expenditures and revenues. However, the separation was done retroactivity and was not been completed for the entire fiscal year or life of grants. This deficiency was instrumental in causing the general ledger to be inadequate for financial and Federal Award Reporting. Cause: The District had originally relied on unskilled individuals for structuring and recording activities in their general ledger. District management did not have sufficient staff or monitoring policies to recognize and correct the deficiency. While trained staff have been hired at Umpqua Public Transportation District, and improvements made to the general ledger and recording of Federal grants, improvements are still nec-essary to meet the full requirements of CFR Part 200.302.b Auditee Responsibilities. Effect or Potential Effect: Potential for incorrect financial reporting, and untimely results, with the inabil-ity to rely on the general ledger for correct and timely information. Questioned Cost: No Context: While federal grant revenues and expenditures are now tracked using the general ledger ?jobs? indicators, additional recording is needed to track the matching portions of the costs and revenues of those federal grants. The lack of completed effort at separating revenues or expenditures by grant may lead to er-rors in reporting expenditures for Federal Awards. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2021-11 Recommendation: We recommend that Umpqua Public Transportation District improve their general ledg-er structure to meet the requirement for separate accounts for Federal awards for program revenues and program expenditures. We also recommend that the district establish policies and procedures to ensure that all program revenues and expenditures are reported in the correct fiscal year. In addition, we recommend that the district establish a training program and policies and procedures for staff and management to re-ceive appropriate training for administering and recording Federal Grant revenues and expenditures. District's Response: The District concurs with the recommendation. General ledger accounts separating Federal, State, and Local revenues and related expenditures will be designed and implemented. Corrective Action Plan: The District has hired a Finance Manager to oversee the day-to-day financial operations of the district. The Finance Manager has developed an accounting system for separating Feder-al, State, and Local revenues and related expenditures. This will allow the activities of the district to be rec-orded in a manner that allows for reporting in compliance with federal requirements. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2022-02 ? Fiscal Management System, Ensure Compliance with Federal Regulations Over Ac-counting Systems (Material Weakness) Criteria: Management is responsible for establishing and maintaining effective internal control over finan-cial reporting. Internal controls should allow management or employees in the normal course of perform-ing their assigned functions to prevent or detect material misstatements in the financial reporting of all dis-trict funds. The Internal Control ? Integrated Framework, published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) and the U.S. Government Accountability Office Standards for Internal Control in the Federal Government specify that a satisfactory control environment is only effective when there are adequate control activities in place. Effective control activities dictate that a review is performed to verify the accuracy and completeness of financial information reported. The Federal Grant Activity Schedule captures amounts that must be accurate and complete in order to ensure the accuracy of the fi-nancial and federal information reported on such schedule to verify the accuracy and completeness of fi-nancial information reported. CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial management sys-tem of each non-Federal entity provide the following. Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Accurate, current, and complete disclosure of the financial results of each Federal award or program. Condition: During the audit of Umpqua Public Transportation District for Fiscal Year 2021-2022, the dis-trict provided auditor with Separate and Identifiable General Ledger reports using QuickBooks Jobs fea-ture, that showed identification between individual grant expenditures and revenues. Entries were prepared or recorded using the jobs feature, but not on a timely basis throughout the year, as portions were complet-ed retroactively, and general ledger restated for the entire fiscal year. This deficiency was instrumental in causing the general ledger to be inadequate for financial and Federal Award Reporting for a large portion of the year. Cause: The District had relied on inadequately trained individuals to record activities and setup of their general ledger. The accounting records were retroactively constructed to meet Federal award reporting pur-poses, but late in the fiscal year. District management did not have sufficient training or monitoring poli-cies to recognize and correct the deficiency. Effect or Potential Effect: Failure to record transactions timely into the general ledger for Umpqua Public Transportation District, and lack of proper accounting structure separating revenues and expenditures into each Federal and State or Local grant may result in transactions not being properly included in the district?s financial statements. The potential for incorrect financial reporting, and untimely results, with the inability to rely on the general ledger for correct and timely information, may also cause misstatement of financial statements, and inappropriate reporting of federal awards. Questioned Cost: No Context: Restatement of the general ledger was necessary for proper reporting of grants for the Schedule of Federal Awards. Tracking of matching local and state grants remains ineffective. Repeat of a Prior-Year Finding: Yes, Financial Statement Findings 2021-4 Recommendation: We recommend that Umpqua Public Transportation District improve their general ledg-er structure to meet the requirement for separate accounts for Federal awards for program revenues and program expenditures. In addition, we recommend that the district establish policies and procedures to en-sure that all required matching of grant expenditures be recorded in sufficient detail tracking to ensure that all matching program revenues and expenditures are reported correctly in the fiscal year. We also recom-mend that the district continue training program, policies and procedures for staff and management for ad-ministering and recording Federal Grant revenues and expenditures. District's Response: The District concurs with the recommendation. General ledger accounts separating Federal, State, and Local revenues and related expenditures will be adhered to and further training imple-mented. Corrective Action Plan: The District hired a Finance Manager to oversee the day-to-day financial opera-tions of the district. The Finance Manager retroactively created accounting records to separate grant reve-nues and related expenditures, for both Federal grant records as well as State grant records. The Finance Manager will improve the general ledger to allow the recording of the matching identification for each fed-eral grant. This will allow the activities of the district to be recorded in a manner that allows for reporting in compliance with federal requirements. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit Distric
Finding 2022-03 - Source Documentation (Significant Deficiency) CFDA Title and Number: 20.513 (5310) Enhanced Mobility of Seniors and Individuals with Disabili-ties. Grant Agreement 33573 (City of Reedsport). Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Manage-ment CFDA Title and Number: 20.509 (5311) CARES 5311 Operating Assistance. Formula Grants for Rural Areas and Tribal Transit Program. Grant Agreement 34196. Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Management Criteria: 2 CFR Part 200.302(b)(1) The financial management system of each non-federal entity must provide for the following: Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. 200.302(b)(2) Accurate, current, and complete dis-closure of the financial results of each Federal award or program in accordance with the reporting require-ments set forth in 200.328 and 200.329. Condition: The District prepared drawdown calculations according to an internal reconciliation spread-sheet tool outside of the General Ledger rather than utilizing proper General Ledger expenditure and sup-porting backup information. Cause: General ledger reconciling procedures were not enforced or completed. Effect or Potential Effect: Activities or costs that are allowed or allowable could potentially be overpaid or underpaid. Questioned Cost: No Context: During our testing of expenditures, we found no Federal drawdown reimbursement requests se-lected for testing that did not reconcile to their corresponding expenditures. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2021-8 Recommendation: The District should establish policies and procedures to ensure that each drawdown is reconciled with supporting expenditure documents and general ledger postings prior to reimbursement be-ing requested. District's Response: The District had relied on inadequately skilled or trained individuals for recording activity in the general ledger. General ledger activity was not available timely, or in sufficient quality such that the General Manager could rely upon the general ledger to gather information for reporting to grantors. Consequently, the General Manager developed and relied upon their own spreadsheet records for grant re-imbursement requests. Corrective Action Plan: The District has hired a Finance Manager to oversee the day-to-day financial operations of the District. The Finance Manager has made improvements in the general ledger recording and reporting for federal award requirements, but had not yet been able to eliminate the reliance upon the General Manager?s spreadsheet tool for grant management. The Finance Manager will continue to develop the general ledger procedures such that all necessary federal and state grant reporting requirements will be met within the general ledger. This will allow the activities of the district to be recorded and managed on a timely basis. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2022-04 ? Fiscal Management System (Material Weakness) Criteria: CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial manage-ment system of each non-Federal entity provide the following. Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Accurate, cur-rent, and complete disclosure of the financial results of each Federal award or program. Condition: During the audit of Umpqua Public Transportation District for Fiscal Year 2021-2022, the dis-trict provided auditor with Separate and Identifiable General Ledger reports that showed a clear division be-tween Federal, State and Local expenditures and revenues. However, the separation was done retroactivity and was not been completed for the entire fiscal year or life of grants. This deficiency was instrumental in causing the general ledger to be inadequate for financial and Federal Award Reporting. Cause: The District had originally relied on unskilled individuals for structuring and recording activities in their general ledger. District management did not have sufficient staff or monitoring policies to recognize and correct the deficiency. While trained staff have been hired at Umpqua Public Transportation District, and improvements made to the general ledger and recording of Federal grants, improvements are still nec-essary to meet the full requirements of CFR Part 200.302.b Auditee Responsibilities. Effect or Potential Effect: Potential for incorrect financial reporting, and untimely results, with the inabil-ity to rely on the general ledger for correct and timely information. Questioned Cost: No Context: While federal grant revenues and expenditures are now tracked using the general ledger ?jobs? indicators, additional recording is needed to track the matching portions of the costs and revenues of those federal grants. The lack of completed effort at separating revenues or expenditures by grant may lead to er-rors in reporting expenditures for Federal Awards. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2021-11 Recommendation: We recommend that Umpqua Public Transportation District improve their general ledg-er structure to meet the requirement for separate accounts for Federal awards for program revenues and program expenditures. We also recommend that the district establish policies and procedures to ensure that all program revenues and expenditures are reported in the correct fiscal year. In addition, we recommend that the district establish a training program and policies and procedures for staff and management to re-ceive appropriate training for administering and recording Federal Grant revenues and expenditures. District's Response: The District concurs with the recommendation. General ledger accounts separating Federal, State, and Local revenues and related expenditures will be designed and implemented. Corrective Action Plan: The District has hired a Finance Manager to oversee the day-to-day financial operations of the district. The Finance Manager has developed an accounting system for separating Feder-al, State, and Local revenues and related expenditures. This will allow the activities of the district to be rec-orded in a manner that allows for reporting in compliance with federal requirements. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2022-02 ? Fiscal Management System, Ensure Compliance with Federal Regulations Over Ac-counting Systems (Material Weakness) Criteria: Management is responsible for establishing and maintaining effective internal control over finan-cial reporting. Internal controls should allow management or employees in the normal course of perform-ing their assigned functions to prevent or detect material misstatements in the financial reporting of all dis-trict funds. The Internal Control ? Integrated Framework, published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) and the U.S. Government Accountability Office Standards for Internal Control in the Federal Government specify that a satisfactory control environment is only effective when there are adequate control activities in place. Effective control activities dictate that a review is performed to verify the accuracy and completeness of financial information reported. The Federal Grant Activity Schedule captures amounts that must be accurate and complete in order to ensure the accuracy of the fi-nancial and federal information reported on such schedule to verify the accuracy and completeness of fi-nancial information reported. CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial management sys-tem of each non-Federal entity provide the following. Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Accurate, current, and complete disclosure of the financial results of each Federal award or program. Condition: During the audit of Umpqua Public Transportation District for Fiscal Year 2021-2022, the dis-trict provided auditor with Separate and Identifiable General Ledger reports using QuickBooks Jobs fea-ture, that showed identification between individual grant expenditures and revenues. Entries were prepared or recorded using the jobs feature, but not on a timely basis throughout the year, as portions were complet-ed retroactively, and general ledger restated for the entire fiscal year. This deficiency was instrumental in causing the general ledger to be inadequate for financial and Federal Award Reporting for a large portion of the year. Cause: The District had relied on inadequately trained individuals to record activities and setup of their general ledger. The accounting records were retroactively constructed to meet Federal award reporting pur-poses, but late in the fiscal year. District management did not have sufficient training or monitoring poli-cies to recognize and correct the deficiency. Effect or Potential Effect: Failure to record transactions timely into the general ledger for Umpqua Public Transportation District, and lack of proper accounting structure separating revenues and expenditures into each Federal and State or Local grant may result in transactions not being properly included in the district?s financial statements. The potential for incorrect financial reporting, and untimely results, with the inability to rely on the general ledger for correct and timely information, may also cause misstatement of financial statements, and inappropriate reporting of federal awards. Questioned Cost: No Context: Restatement of the general ledger was necessary for proper reporting of grants for the Schedule of Federal Awards. Tracking of matching local and state grants remains ineffective. Repeat of a Prior-Year Finding: Yes, Financial Statement Findings 2021-4 Recommendation: We recommend that Umpqua Public Transportation District improve their general ledg-er structure to meet the requirement for separate accounts for Federal awards for program revenues and program expenditures. In addition, we recommend that the district establish policies and procedures to en-sure that all required matching of grant expenditures be recorded in sufficient detail tracking to ensure that all matching program revenues and expenditures are reported correctly in the fiscal year. We also recom-mend that the district continue training program, policies and procedures for staff and management for ad-ministering and recording Federal Grant revenues and expenditures. District's Response: The District concurs with the recommendation. General ledger accounts separating Federal, State, and Local revenues and related expenditures will be adhered to and further training imple-mented. Corrective Action Plan: The District hired a Finance Manager to oversee the day-to-day financial opera-tions of the district. The Finance Manager retroactively created accounting records to separate grant reve-nues and related expenditures, for both Federal grant records as well as State grant records. The Finance Manager will improve the general ledger to allow the recording of the matching identification for each fed-eral grant. This will allow the activities of the district to be recorded in a manner that allows for reporting in compliance with federal requirements. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit Distric
Finding 2022-03 - Source Documentation (Significant Deficiency) CFDA Title and Number: 20.513 (5310) Enhanced Mobility of Seniors and Individuals with Disabili-ties. Grant Agreement 33573 (City of Reedsport). Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Manage-ment CFDA Title and Number: 20.509 (5311) CARES 5311 Operating Assistance. Formula Grants for Rural Areas and Tribal Transit Program. Grant Agreement 34196. Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Management Criteria: 2 CFR Part 200.302(b)(1) The financial management system of each non-federal entity must provide for the following: Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. 200.302(b)(2) Accurate, current, and complete dis-closure of the financial results of each Federal award or program in accordance with the reporting require-ments set forth in 200.328 and 200.329. Condition: The District prepared drawdown calculations according to an internal reconciliation spread-sheet tool outside of the General Ledger rather than utilizing proper General Ledger expenditure and sup-porting backup information. Cause: General ledger reconciling procedures were not enforced or completed. Effect or Potential Effect: Activities or costs that are allowed or allowable could potentially be overpaid or underpaid. Questioned Cost: No Context: During our testing of expenditures, we found no Federal drawdown reimbursement requests se-lected for testing that did not reconcile to their corresponding expenditures. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2021-8 Recommendation: The District should establish policies and procedures to ensure that each drawdown is reconciled with supporting expenditure documents and general ledger postings prior to reimbursement be-ing requested. District's Response: The District had relied on inadequately skilled or trained individuals for recording activity in the general ledger. General ledger activity was not available timely, or in sufficient quality such that the General Manager could rely upon the general ledger to gather information for reporting to grantors. Consequently, the General Manager developed and relied upon their own spreadsheet records for grant re-imbursement requests. Corrective Action Plan: The District has hired a Finance Manager to oversee the day-to-day financial operations of the District. The Finance Manager has made improvements in the general ledger recording and reporting for federal award requirements, but had not yet been able to eliminate the reliance upon the General Manager?s spreadsheet tool for grant management. The Finance Manager will continue to develop the general ledger procedures such that all necessary federal and state grant reporting requirements will be met within the general ledger. This will allow the activities of the district to be recorded and managed on a timely basis. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2022-04 ? Fiscal Management System (Material Weakness) Criteria: CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial manage-ment system of each non-Federal entity provide the following. Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Accurate, cur-rent, and complete disclosure of the financial results of each Federal award or program. Condition: During the audit of Umpqua Public Transportation District for Fiscal Year 2021-2022, the dis-trict provided auditor with Separate and Identifiable General Ledger reports that showed a clear division be-tween Federal, State and Local expenditures and revenues. However, the separation was done retroactivity and was not been completed for the entire fiscal year or life of grants. This deficiency was instrumental in causing the general ledger to be inadequate for financial and Federal Award Reporting. Cause: The District had originally relied on unskilled individuals for structuring and recording activities in their general ledger. District management did not have sufficient staff or monitoring policies to recognize and correct the deficiency. While trained staff have been hired at Umpqua Public Transportation District, and improvements made to the general ledger and recording of Federal grants, improvements are still nec-essary to meet the full requirements of CFR Part 200.302.b Auditee Responsibilities. Effect or Potential Effect: Potential for incorrect financial reporting, and untimely results, with the inabil-ity to rely on the general ledger for correct and timely information. Questioned Cost: No Context: While federal grant revenues and expenditures are now tracked using the general ledger ?jobs? indicators, additional recording is needed to track the matching portions of the costs and revenues of those federal grants. The lack of completed effort at separating revenues or expenditures by grant may lead to er-rors in reporting expenditures for Federal Awards. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2021-11 Recommendation: We recommend that Umpqua Public Transportation District improve their general ledg-er structure to meet the requirement for separate accounts for Federal awards for program revenues and program expenditures. We also recommend that the district establish policies and procedures to ensure that all program revenues and expenditures are reported in the correct fiscal year. In addition, we recommend that the district establish a training program and policies and procedures for staff and management to re-ceive appropriate training for administering and recording Federal Grant revenues and expenditures. District's Response: The District concurs with the recommendation. General ledger accounts separating Federal, State, and Local revenues and related expenditures will be designed and implemented. Corrective Action Plan: The District has hired a Finance Manager to oversee the day-to-day financial operations of the district. The Finance Manager has developed an accounting system for separating Feder-al, State, and Local revenues and related expenditures. This will allow the activities of the district to be rec-orded in a manner that allows for reporting in compliance with federal requirements. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2022-02 ? Fiscal Management System, Ensure Compliance with Federal Regulations Over Ac-counting Systems (Material Weakness) Criteria: Management is responsible for establishing and maintaining effective internal control over finan-cial reporting. Internal controls should allow management or employees in the normal course of perform-ing their assigned functions to prevent or detect material misstatements in the financial reporting of all dis-trict funds. The Internal Control ? Integrated Framework, published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) and the U.S. Government Accountability Office Standards for Internal Control in the Federal Government specify that a satisfactory control environment is only effective when there are adequate control activities in place. Effective control activities dictate that a review is performed to verify the accuracy and completeness of financial information reported. The Federal Grant Activity Schedule captures amounts that must be accurate and complete in order to ensure the accuracy of the fi-nancial and federal information reported on such schedule to verify the accuracy and completeness of fi-nancial information reported. CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial management sys-tem of each non-Federal entity provide the following. Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Accurate, current, and complete disclosure of the financial results of each Federal award or program. Condition: During the audit of Umpqua Public Transportation District for Fiscal Year 2021-2022, the dis-trict provided auditor with Separate and Identifiable General Ledger reports using QuickBooks Jobs fea-ture, that showed identification between individual grant expenditures and revenues. Entries were prepared or recorded using the jobs feature, but not on a timely basis throughout the year, as portions were complet-ed retroactively, and general ledger restated for the entire fiscal year. This deficiency was instrumental in causing the general ledger to be inadequate for financial and Federal Award Reporting for a large portion of the year. Cause: The District had relied on inadequately trained individuals to record activities and setup of their general ledger. The accounting records were retroactively constructed to meet Federal award reporting pur-poses, but late in the fiscal year. District management did not have sufficient training or monitoring poli-cies to recognize and correct the deficiency. Effect or Potential Effect: Failure to record transactions timely into the general ledger for Umpqua Public Transportation District, and lack of proper accounting structure separating revenues and expenditures into each Federal and State or Local grant may result in transactions not being properly included in the district?s financial statements. The potential for incorrect financial reporting, and untimely results, with the inability to rely on the general ledger for correct and timely information, may also cause misstatement of financial statements, and inappropriate reporting of federal awards. Questioned Cost: No Context: Restatement of the general ledger was necessary for proper reporting of grants for the Schedule of Federal Awards. Tracking of matching local and state grants remains ineffective. Repeat of a Prior-Year Finding: Yes, Financial Statement Findings 2021-4 Recommendation: We recommend that Umpqua Public Transportation District improve their general ledg-er structure to meet the requirement for separate accounts for Federal awards for program revenues and program expenditures. In addition, we recommend that the district establish policies and procedures to en-sure that all required matching of grant expenditures be recorded in sufficient detail tracking to ensure that all matching program revenues and expenditures are reported correctly in the fiscal year. We also recom-mend that the district continue training program, policies and procedures for staff and management for ad-ministering and recording Federal Grant revenues and expenditures. District's Response: The District concurs with the recommendation. General ledger accounts separating Federal, State, and Local revenues and related expenditures will be adhered to and further training imple-mented. Corrective Action Plan: The District hired a Finance Manager to oversee the day-to-day financial opera-tions of the district. The Finance Manager retroactively created accounting records to separate grant reve-nues and related expenditures, for both Federal grant records as well as State grant records. The Finance Manager will improve the general ledger to allow the recording of the matching identification for each fed-eral grant. This will allow the activities of the district to be recorded in a manner that allows for reporting in compliance with federal requirements. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit Distric
Finding 2022-03 - Source Documentation (Significant Deficiency) CFDA Title and Number: 20.513 (5310) Enhanced Mobility of Seniors and Individuals with Disabili-ties. Grant Agreement 33573 (City of Reedsport). Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Manage-ment CFDA Title and Number: 20.509 (5311) CARES 5311 Operating Assistance. Formula Grants for Rural Areas and Tribal Transit Program. Grant Agreement 34196. Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Management Criteria: 2 CFR Part 200.302(b)(1) The financial management system of each non-federal entity must provide for the following: Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. 200.302(b)(2) Accurate, current, and complete dis-closure of the financial results of each Federal award or program in accordance with the reporting require-ments set forth in 200.328 and 200.329. Condition: The District prepared drawdown calculations according to an internal reconciliation spread-sheet tool outside of the General Ledger rather than utilizing proper General Ledger expenditure and sup-porting backup information. Cause: General ledger reconciling procedures were not enforced or completed. Effect or Potential Effect: Activities or costs that are allowed or allowable could potentially be overpaid or underpaid. Questioned Cost: No Context: During our testing of expenditures, we found no Federal drawdown reimbursement requests se-lected for testing that did not reconcile to their corresponding expenditures. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2021-8 Recommendation: The District should establish policies and procedures to ensure that each drawdown is reconciled with supporting expenditure documents and general ledger postings prior to reimbursement be-ing requested. District's Response: The District had relied on inadequately skilled or trained individuals for recording activity in the general ledger. General ledger activity was not available timely, or in sufficient quality such that the General Manager could rely upon the general ledger to gather information for reporting to grantors. Consequently, the General Manager developed and relied upon their own spreadsheet records for grant re-imbursement requests. Corrective Action Plan: The District has hired a Finance Manager to oversee the day-to-day financial operations of the District. The Finance Manager has made improvements in the general ledger recording and reporting for federal award requirements, but had not yet been able to eliminate the reliance upon the General Manager?s spreadsheet tool for grant management. The Finance Manager will continue to develop the general ledger procedures such that all necessary federal and state grant reporting requirements will be met within the general ledger. This will allow the activities of the district to be recorded and managed on a timely basis. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2022-04 ? Fiscal Management System (Material Weakness) Criteria: CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial manage-ment system of each non-Federal entity provide the following. Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Accurate, cur-rent, and complete disclosure of the financial results of each Federal award or program. Condition: During the audit of Umpqua Public Transportation District for Fiscal Year 2021-2022, the dis-trict provided auditor with Separate and Identifiable General Ledger reports that showed a clear division be-tween Federal, State and Local expenditures and revenues. However, the separation was done retroactivity and was not been completed for the entire fiscal year or life of grants. This deficiency was instrumental in causing the general ledger to be inadequate for financial and Federal Award Reporting. Cause: The District had originally relied on unskilled individuals for structuring and recording activities in their general ledger. District management did not have sufficient staff or monitoring policies to recognize and correct the deficiency. While trained staff have been hired at Umpqua Public Transportation District, and improvements made to the general ledger and recording of Federal grants, improvements are still nec-essary to meet the full requirements of CFR Part 200.302.b Auditee Responsibilities. Effect or Potential Effect: Potential for incorrect financial reporting, and untimely results, with the inabil-ity to rely on the general ledger for correct and timely information. Questioned Cost: No Context: While federal grant revenues and expenditures are now tracked using the general ledger ?jobs? indicators, additional recording is needed to track the matching portions of the costs and revenues of those federal grants. The lack of completed effort at separating revenues or expenditures by grant may lead to er-rors in reporting expenditures for Federal Awards. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2021-11 Recommendation: We recommend that Umpqua Public Transportation District improve their general ledg-er structure to meet the requirement for separate accounts for Federal awards for program revenues and program expenditures. We also recommend that the district establish policies and procedures to ensure that all program revenues and expenditures are reported in the correct fiscal year. In addition, we recommend that the district establish a training program and policies and procedures for staff and management to re-ceive appropriate training for administering and recording Federal Grant revenues and expenditures. District's Response: The District concurs with the recommendation. General ledger accounts separating Federal, State, and Local revenues and related expenditures will be designed and implemented. Corrective Action Plan: The District has hired a Finance Manager to oversee the day-to-day financial operations of the district. The Finance Manager has developed an accounting system for separating Feder-al, State, and Local revenues and related expenditures. This will allow the activities of the district to be rec-orded in a manner that allows for reporting in compliance with federal requirements. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit District
Criteria: 2 CFR Part 200.302(b)(7) requires the financial management system to include written procedures for determining the allowability of costs. Condition: Lakewood Theatre Company has not developed written procedures for determining the allowability of costs. Cause: Administration did not have written procedures for determining the allowability of costs. Effect: Unallowable costs could be charged to the program. Questioned Costs: None Recommendations: Management should develop written procedures as required by 2 CFR Part 200.302(b)(7). Views of Responsible Officials: Management notes that, as this is their first time receiving significant federal funding and this was one-time emergency funding rather than an ongoing award, they do not have these procedures in writing. However, they reviewed the award allowability guidelines, assigned costs directly in accordance with those guidelines, discussed any costs with uncertain allowability with the awarding agency, and submitted the cost report along with supporting documentation directly to the awarding agency. While they do not anticipate receiving federal funding in the future, if this does occur, they will develop written procedures at that point.
Finding 2022-003 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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). . . ." 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The Annual Data Reports required to be submitted during the audit period could have incomplete or inaccurate without a secondary, documented review in place. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards and the GEER grant award. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-003 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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). . . ." 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The Annual Data Reports required to be submitted during the audit period could have incomplete or inaccurate without a secondary, documented review in place. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards and the GEER grant award. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-003 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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). . . ." 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The Annual Data Reports required to be submitted during the audit period could have incomplete or inaccurate without a secondary, documented review in place. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards and the GEER grant award. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding 2022-003 Information on the federal program: Subject: Education Stabilization Fund ? Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 ? Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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). . . ." 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 Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The Annual Data Reports required to be submitted during the audit period could have incomplete or inaccurate without a secondary, documented review in place. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards and the GEER grant award. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. We noted for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
SECTION III ? FEDERAL AWARD FINDINGS AND QUESTIONED COSTS _____________________________________________________________________________________________________________________ FINDING NUMBER 2022-006 FEDERAL PROGRAM CORONAVIRUS RELIEF FUND (ASSISTANCE LISTING NUMBER 21.019) PASS-THROUGH PUERTO RICO FISCAL AGENCY AND FINANCIAL ADVISORY AUTHORITY U.S. DEPARTMENT OF THE TREASURY AWARD NUMBER TRANSFER AGREEMENTS PHASES I/ II/ III TYPE OF FINDING COMPLIANCE AND INTERNAL CONTROL COMPLIANCE REQUIREMENT REPORTING CONDITION As part of the reporting test, the final accumulated expenditures report submitted to the pass-through entity was examined. I noted that the Municipality reported the amount of $2,069,123 in the final accumulated expenditures report, which is $147,992 less than the amount of expenditures recorded in the accounting records of the Municipality. CRITERIA As established in the Uniform Guidance, 2 CFR Section 200.302, Financial Management, (a) the 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. Also, Clause 2.3, Recordkeeping, of the Coronavirus Relief Fund (CRF) Transfer Agreement for the Assistance Program to Municipalities, established that the 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. Also, Clause 5.1, Compliance Reporting Requirements, of the Coronavirus Relief Fund (CRF) Transfer Agreement for the Assistance Program to Municipalities, established that the Transferee shall submit reports as the Transferor determines are needed to verify use of the funds and compliance with conditions that are imposed on the Transfer, and such reports shall be in such form, which such content, as specified by the Transferor in the Transfer Plan and future program instructions directed to all Recipients. CAUSE The Municipality?s internal controls and procedures failed to ensure the accuracy and correctness of the reports submitted to the pass-through entity. EFFECT Possible inaccurate financial information could have been submitted to the pass-through entity that can lead the Municipality to be in noncompliance with the reporting requirements established in the transfer agreements. RECOMMENDATION I recommend the Municipality to continue strengthening the internal controls and monitoring procedures to ensure the accuracy and completeness of accounting records and the correct preparation and timely submission of the financial reports. QUESTIONED COSTS None PRIOR YEAR FINDING This finding is a prior year audit finding identified as 2021-005. VIEWS OF RESPONSIBLE OFFICIALS AND PLANNED CORRECTIVE ACTION We gave instructions to the finance department accounting staff to strengthening internal procedures and controls to ensure accurate preparation and submission of financial reports.
SECTION III ? FEDERAL AWARD FINDINGS AND QUESTIONED COSTS _____________________________________________________________________________________________________________________ FINDING NUMBER 2022-008 FEDERAL PROGRAM HEAD START CLUSTER (ASSISTANCE LISTING NUMBER 93.356/ 93.600) PASS-THROUGH PUERTO RICO ADMINISTRATION FOR THE CHILDHOOD CARE AND INTEGRAL DEVELOPMENT U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 241-2022-000653/ 241-2021-000444/ 241-2021-000226/ 241-2020- 000139 TYPE OF FINDING COMPLIANCE AND INTERNAL CONTROL COMPLIANCE REQUIREMENT REPORTING CONDITION During the reporting test, a sample was selected of the monthly disbursement reports, including the Federal Financial Report (SF-425) and the final liquidation reports of the program year 2021-2022 of the Head Start/ Early Head Start grants and found the following situations: 1) For the Head Start/ Early Head Start programs, I selected a sample of the monthly disbursement reports, including the Federal Financial Report (SF-425), of November 2021 and February 2022 and the final liquidation reports of the program year 2021-2022 and noted that; a) for the monthly reports of November 2021 and February 2022, the Program did not provide evidence of the date in which the reports were submitted to the pass-through entity; b) certain differences in the revenues and expenditures were noted between the SF-425 and the accounting records of the Programs; c) the Program did not provide evidence of the preparation and submission of the final liquidation report of the program year 2021-2022 to the pass-through entity. 2) For the Head Start Disaster Recovery program, I selected for evaluation the Federal Financial Report (SF-425) of February 2022, related to the final liquidation report of the grant and noted that; 1) the Program did not provide evidence of the date in which the reports were submitted to the pass-through entity; b) certain differences were noted between the final liquidation report submitted to the passthrough entity and the accounting records of the Program; 3) as of June 30, 2022, the bank account of the Program maintain a cash balance of $3,288,516, which has not been return to the pass-through entity. 3) For the Head Start Cares Act program, I selected the Federal Financial Report (SF-425), of August 2021, related to the final liquidation report of the grant and noted that the Program did not provide evidence of the date in which the final liquidation report was submitted to the pass-through entity. 4) The Programs? accounting personnel did not maintain complete and adequate set of accounting records of the financial transactions of the Programs, that permits the tracing to the monthly and closing reports submitted to the pass-through entity. CRITERIA As established in the Uniform Guidance, 2 CFR Section 200.302, Financial Management, (a) the 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. In addition, clause Eight of the grant agreement between the passthrough entity and the Municipality establish that the Municipality should submit the monthly disbursements report on or before the first ten (10) days of the next month. Also, clause Eight states that after the closing of the program year, the Municipality should submit the following documents and reports: 1) a trial balance and a statement of revenues and expenditures on or before the first fifteen (15) days after the closing of the program; 2) a Federal Financial Report (SF-425) on or before the first fifteen (15) days after the closing of the program; and 3) a liquidation funds report at the closing of the fiscal operations must be submitted on or before the first fifteen (15) days after the closing of the program year and at the end of the term of the ninety (90) days to liquidate the outstanding obligations. CAUSE Adequate internal controls and monitoring procedures do not exist to ensure the timely submission and correctness of the monthly reports and the Federal Financial Reports (SF-425) submitted to the pass-through entity. EFFECT The Municipality and the Programs? accountants has not kept proper accounting records of the financial transactions of the Programs as required by Federal regulations and the grant agreements. Also, the Municipality was not in compliance with the accounting and reporting requirements and reporting deadlines established in the grant agreements with the pass-through entity. RECOMMENDATION I recommend that technical training must be provided to the accounting staff to improve the recordkeeping of the financial transactions of the Programs in order to maintain complete and accurate accounting records. QUESTIONED COSTS None PRIOR YEAR FINDING This finding is a prior year audit finding identified as 2021-004. VIEWS OF RESPONSIBLE OFFICIALS AND PLANNED CORRECTIVE ACTION On May 3, 2021, the Grantee inform the Municipality about the determination to temporarily submit to a partial protective intervention the programmatic and administrative function of the delegated agency of Pe?uelas. As a direct consequence of such a determination, since May 3, 2021, up to July 31, 2022 (grant termination date), two employees of the Grantee had interference in all fiscal and programmatic transactions of the delegated agency, requiring their authorization for fiscal or programmatic transactions to be carried out. During this timeframe, key personnel of the delegated agency, such as the Program Director, the Program Accountant, the Property Manager, among others, resigned or were required to be replaced by the Grantee?s representatives, altering the programmatic and fiscal operations of the delegated agency. About the program year 2021-2022 closing, the Municipality of Pe?uelas return the funds surplus after the end of the period of liquidation of obligations, including the $3,288,516 related to Head Start Disaster Recovery program retained in the Program restricted cash account as instructed by a Grantee?s representative. Related to the program year prematurely terminated by the Grantee (program year 2022-2023), the Municipality?s Finance Department staff reconciled the program fiscal transactions registered in the Municipality?s computerized accounting system, with the grant awards, as amended, and prepare a liquidation report of each grant award. Such reports will be submitted to the Grantee to discuss the steps for liquidation of obligations with third parties, and the reimbursement of payroll and other expenditures financed by the Municipality?s General Fund.
SECTION III ? FEDERAL AWARD FINDINGS AND QUESTIONED COSTS _____________________________________________________________________________________________________________________ FINDING NUMBER 2022-008 FEDERAL PROGRAM HEAD START CLUSTER (ASSISTANCE LISTING NUMBER 93.356/ 93.600) PASS-THROUGH PUERTO RICO ADMINISTRATION FOR THE CHILDHOOD CARE AND INTEGRAL DEVELOPMENT U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 241-2022-000653/ 241-2021-000444/ 241-2021-000226/ 241-2020- 000139 TYPE OF FINDING COMPLIANCE AND INTERNAL CONTROL COMPLIANCE REQUIREMENT REPORTING CONDITION During the reporting test, a sample was selected of the monthly disbursement reports, including the Federal Financial Report (SF-425) and the final liquidation reports of the program year 2021-2022 of the Head Start/ Early Head Start grants and found the following situations: 1) For the Head Start/ Early Head Start programs, I selected a sample of the monthly disbursement reports, including the Federal Financial Report (SF-425), of November 2021 and February 2022 and the final liquidation reports of the program year 2021-2022 and noted that; a) for the monthly reports of November 2021 and February 2022, the Program did not provide evidence of the date in which the reports were submitted to the pass-through entity; b) certain differences in the revenues and expenditures were noted between the SF-425 and the accounting records of the Programs; c) the Program did not provide evidence of the preparation and submission of the final liquidation report of the program year 2021-2022 to the pass-through entity. 2) For the Head Start Disaster Recovery program, I selected for evaluation the Federal Financial Report (SF-425) of February 2022, related to the final liquidation report of the grant and noted that; 1) the Program did not provide evidence of the date in which the reports were submitted to the pass-through entity; b) certain differences were noted between the final liquidation report submitted to the passthrough entity and the accounting records of the Program; 3) as of June 30, 2022, the bank account of the Program maintain a cash balance of $3,288,516, which has not been return to the pass-through entity. 3) For the Head Start Cares Act program, I selected the Federal Financial Report (SF-425), of August 2021, related to the final liquidation report of the grant and noted that the Program did not provide evidence of the date in which the final liquidation report was submitted to the pass-through entity. 4) The Programs? accounting personnel did not maintain complete and adequate set of accounting records of the financial transactions of the Programs, that permits the tracing to the monthly and closing reports submitted to the pass-through entity. CRITERIA As established in the Uniform Guidance, 2 CFR Section 200.302, Financial Management, (a) the 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. In addition, clause Eight of the grant agreement between the passthrough entity and the Municipality establish that the Municipality should submit the monthly disbursements report on or before the first ten (10) days of the next month. Also, clause Eight states that after the closing of the program year, the Municipality should submit the following documents and reports: 1) a trial balance and a statement of revenues and expenditures on or before the first fifteen (15) days after the closing of the program; 2) a Federal Financial Report (SF-425) on or before the first fifteen (15) days after the closing of the program; and 3) a liquidation funds report at the closing of the fiscal operations must be submitted on or before the first fifteen (15) days after the closing of the program year and at the end of the term of the ninety (90) days to liquidate the outstanding obligations. CAUSE Adequate internal controls and monitoring procedures do not exist to ensure the timely submission and correctness of the monthly reports and the Federal Financial Reports (SF-425) submitted to the pass-through entity. EFFECT The Municipality and the Programs? accountants has not kept proper accounting records of the financial transactions of the Programs as required by Federal regulations and the grant agreements. Also, the Municipality was not in compliance with the accounting and reporting requirements and reporting deadlines established in the grant agreements with the pass-through entity. RECOMMENDATION I recommend that technical training must be provided to the accounting staff to improve the recordkeeping of the financial transactions of the Programs in order to maintain complete and accurate accounting records. QUESTIONED COSTS None PRIOR YEAR FINDING This finding is a prior year audit finding identified as 2021-004. VIEWS OF RESPONSIBLE OFFICIALS AND PLANNED CORRECTIVE ACTION On May 3, 2021, the Grantee inform the Municipality about the determination to temporarily submit to a partial protective intervention the programmatic and administrative function of the delegated agency of Pe?uelas. As a direct consequence of such a determination, since May 3, 2021, up to July 31, 2022 (grant termination date), two employees of the Grantee had interference in all fiscal and programmatic transactions of the delegated agency, requiring their authorization for fiscal or programmatic transactions to be carried out. During this timeframe, key personnel of the delegated agency, such as the Program Director, the Program Accountant, the Property Manager, among others, resigned or were required to be replaced by the Grantee?s representatives, altering the programmatic and fiscal operations of the delegated agency. About the program year 2021-2022 closing, the Municipality of Pe?uelas return the funds surplus after the end of the period of liquidation of obligations, including the $3,288,516 related to Head Start Disaster Recovery program retained in the Program restricted cash account as instructed by a Grantee?s representative. Related to the program year prematurely terminated by the Grantee (program year 2022-2023), the Municipality?s Finance Department staff reconciled the program fiscal transactions registered in the Municipality?s computerized accounting system, with the grant awards, as amended, and prepare a liquidation report of each grant award. Such reports will be submitted to the Grantee to discuss the steps for liquidation of obligations with third parties, and the reimbursement of payroll and other expenditures financed by the Municipality?s General Fund.
SECTION III ? FEDERAL AWARD FINDINGS AND QUESTIONED COSTS _____________________________________________________________________________________________________________________ FINDING NUMBER 2022-008 FEDERAL PROGRAM HEAD START CLUSTER (ASSISTANCE LISTING NUMBER 93.356/ 93.600) PASS-THROUGH PUERTO RICO ADMINISTRATION FOR THE CHILDHOOD CARE AND INTEGRAL DEVELOPMENT U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES AWARD NUMBERS 241-2022-000653/ 241-2021-000444/ 241-2021-000226/ 241-2020- 000139 TYPE OF FINDING COMPLIANCE AND INTERNAL CONTROL COMPLIANCE REQUIREMENT REPORTING CONDITION During the reporting test, a sample was selected of the monthly disbursement reports, including the Federal Financial Report (SF-425) and the final liquidation reports of the program year 2021-2022 of the Head Start/ Early Head Start grants and found the following situations: 1) For the Head Start/ Early Head Start programs, I selected a sample of the monthly disbursement reports, including the Federal Financial Report (SF-425), of November 2021 and February 2022 and the final liquidation reports of the program year 2021-2022 and noted that; a) for the monthly reports of November 2021 and February 2022, the Program did not provide evidence of the date in which the reports were submitted to the pass-through entity; b) certain differences in the revenues and expenditures were noted between the SF-425 and the accounting records of the Programs; c) the Program did not provide evidence of the preparation and submission of the final liquidation report of the program year 2021-2022 to the pass-through entity. 2) For the Head Start Disaster Recovery program, I selected for evaluation the Federal Financial Report (SF-425) of February 2022, related to the final liquidation report of the grant and noted that; 1) the Program did not provide evidence of the date in which the reports were submitted to the pass-through entity; b) certain differences were noted between the final liquidation report submitted to the passthrough entity and the accounting records of the Program; 3) as of June 30, 2022, the bank account of the Program maintain a cash balance of $3,288,516, which has not been return to the pass-through entity. 3) For the Head Start Cares Act program, I selected the Federal Financial Report (SF-425), of August 2021, related to the final liquidation report of the grant and noted that the Program did not provide evidence of the date in which the final liquidation report was submitted to the pass-through entity. 4) The Programs? accounting personnel did not maintain complete and adequate set of accounting records of the financial transactions of the Programs, that permits the tracing to the monthly and closing reports submitted to the pass-through entity. CRITERIA As established in the Uniform Guidance, 2 CFR Section 200.302, Financial Management, (a) the 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. In addition, clause Eight of the grant agreement between the passthrough entity and the Municipality establish that the Municipality should submit the monthly disbursements report on or before the first ten (10) days of the next month. Also, clause Eight states that after the closing of the program year, the Municipality should submit the following documents and reports: 1) a trial balance and a statement of revenues and expenditures on or before the first fifteen (15) days after the closing of the program; 2) a Federal Financial Report (SF-425) on or before the first fifteen (15) days after the closing of the program; and 3) a liquidation funds report at the closing of the fiscal operations must be submitted on or before the first fifteen (15) days after the closing of the program year and at the end of the term of the ninety (90) days to liquidate the outstanding obligations. CAUSE Adequate internal controls and monitoring procedures do not exist to ensure the timely submission and correctness of the monthly reports and the Federal Financial Reports (SF-425) submitted to the pass-through entity. EFFECT The Municipality and the Programs? accountants has not kept proper accounting records of the financial transactions of the Programs as required by Federal regulations and the grant agreements. Also, the Municipality was not in compliance with the accounting and reporting requirements and reporting deadlines established in the grant agreements with the pass-through entity. RECOMMENDATION I recommend that technical training must be provided to the accounting staff to improve the recordkeeping of the financial transactions of the Programs in order to maintain complete and accurate accounting records. QUESTIONED COSTS None PRIOR YEAR FINDING This finding is a prior year audit finding identified as 2021-004. VIEWS OF RESPONSIBLE OFFICIALS AND PLANNED CORRECTIVE ACTION On May 3, 2021, the Grantee inform the Municipality about the determination to temporarily submit to a partial protective intervention the programmatic and administrative function of the delegated agency of Pe?uelas. As a direct consequence of such a determination, since May 3, 2021, up to July 31, 2022 (grant termination date), two employees of the Grantee had interference in all fiscal and programmatic transactions of the delegated agency, requiring their authorization for fiscal or programmatic transactions to be carried out. During this timeframe, key personnel of the delegated agency, such as the Program Director, the Program Accountant, the Property Manager, among others, resigned or were required to be replaced by the Grantee?s representatives, altering the programmatic and fiscal operations of the delegated agency. About the program year 2021-2022 closing, the Municipality of Pe?uelas return the funds surplus after the end of the period of liquidation of obligations, including the $3,288,516 related to Head Start Disaster Recovery program retained in the Program restricted cash account as instructed by a Grantee?s representative. Related to the program year prematurely terminated by the Grantee (program year 2022-2023), the Municipality?s Finance Department staff reconciled the program fiscal transactions registered in the Municipality?s computerized accounting system, with the grant awards, as amended, and prepare a liquidation report of each grant award. Such reports will be submitted to the Grantee to discuss the steps for liquidation of obligations with third parties, and the reimbursement of payroll and other expenditures financed by the Municipality?s General Fund.
Finding 2022-001 Year-End Close Process/Account Reconciliations Information on the Federal Programs: CFDA 14.235 Criteria or Specific Requirement: In accordance with CFR 200.302 the financial management system of each non-Federal entity must provide for effective control over, and accountability for, all funds, property, and other assets. The non-Federal entity must adequately safeguard all assets and assure that they are used solely for authorized purposes. Condition: The initial financial information provided for the audit was not accurate, resulting in delays in the audit process. In addition, we noted that certain schedules/reconciliations were not properly prepared in advance of the audit. Cause: NEW transitioned to a new accounting software during the fiscal year. We noted that NEW encountered certain difficulties during this process. Effect or Potential Effect: If each account is not reconciled regularly, it increases the risk of loss of Federal funds. Questioned Costs: None Context: The transition to the new accounting system resulted in certain challenges. Identification as a Repeat Finding, if Applicable: Not applicable Recommendation: We recommend that NEW complete the transition to the new system and ensure that each account is properly reconciled on a monthly basis.
Finding 2022-002: Support for Schedule of Expenditures of Federal Awards in the Accounting System Information on the Federal Programs: CFDA 14.235 Criteria or Specific Requirement: In accordance with CFR 200.302 (financial management) the auditee must be able to identify all Federal awards received and expenses and the Federal programs under which they were received. Condition: We noted that in the transition from the previous accounting system, certain expenditures had not been properly classified in the new system. As a result, although detailed invoices were available to support the amounts reported on the SEFA, the expenses had not been accurately classified by award within the general ledger. Cause: NEW transitioned to a new accounting software during the fiscal year. We noted that NEW encountered certain difficulties during this process. Effect or Potential Effect: If the information on the SEFA cannot be traced back to the information within the accounting system, there is an increased potential for inaccurate reporting. Questioned Costs: Indeterminable Context: The transition to the new accounting system resulted in certain challenges. Identification as a Repeat Finding, if Applicable: Not applicable Recommendation: We recommend that NEW complete the transition to the new system and ensure that each account is properly reconciled on a monthly basis.
Finding 2022-001 Year-End Close Process/Account Reconciliations Information on the Federal Programs: CFDA 14.235 Criteria or Specific Requirement: In accordance with CFR 200.302 the financial management system of each non-Federal entity must provide for effective control over, and accountability for, all funds, property, and other assets. The non-Federal entity must adequately safeguard all assets and assure that they are used solely for authorized purposes. Condition: The initial financial information provided for the audit was not accurate, resulting in delays in the audit process. In addition, we noted that certain schedules/reconciliations were not properly prepared in advance of the audit. Cause: NEW transitioned to a new accounting software during the fiscal year. We noted that NEW encountered certain difficulties during this process. Effect or Potential Effect: If each account is not reconciled regularly, it increases the risk of loss of Federal funds. Questioned Costs: None Context: The transition to the new accounting system resulted in certain challenges. Identification as a Repeat Finding, if Applicable: Not applicable Recommendation: We recommend that NEW complete the transition to the new system and ensure that each account is properly reconciled on a monthly basis.
Finding 2022-002: Support for Schedule of Expenditures of Federal Awards in the Accounting System Information on the Federal Programs: CFDA 14.235 Criteria or Specific Requirement: In accordance with CFR 200.302 (financial management) the auditee must be able to identify all Federal awards received and expenses and the Federal programs under which they were received. Condition: We noted that in the transition from the previous accounting system, certain expenditures had not been properly classified in the new system. As a result, although detailed invoices were available to support the amounts reported on the SEFA, the expenses had not been accurately classified by award within the general ledger. Cause: NEW transitioned to a new accounting software during the fiscal year. We noted that NEW encountered certain difficulties during this process. Effect or Potential Effect: If the information on the SEFA cannot be traced back to the information within the accounting system, there is an increased potential for inaccurate reporting. Questioned Costs: Indeterminable Context: The transition to the new accounting system resulted in certain challenges. Identification as a Repeat Finding, if Applicable: Not applicable Recommendation: We recommend that NEW complete the transition to the new system and ensure that each account is properly reconciled on a monthly basis.
Finding 2022-001 Year-End Close Process/Account Reconciliations Information on the Federal Programs: CFDA 14.235 Criteria or Specific Requirement: In accordance with CFR 200.302 the financial management system of each non-Federal entity must provide for effective control over, and accountability for, all funds, property, and other assets. The non-Federal entity must adequately safeguard all assets and assure that they are used solely for authorized purposes. Condition: The initial financial information provided for the audit was not accurate, resulting in delays in the audit process. In addition, we noted that certain schedules/reconciliations were not properly prepared in advance of the audit. Cause: NEW transitioned to a new accounting software during the fiscal year. We noted that NEW encountered certain difficulties during this process. Effect or Potential Effect: If each account is not reconciled regularly, it increases the risk of loss of Federal funds. Questioned Costs: None Context: The transition to the new accounting system resulted in certain challenges. Identification as a Repeat Finding, if Applicable: Not applicable Recommendation: We recommend that NEW complete the transition to the new system and ensure that each account is properly reconciled on a monthly basis.
Finding 2022-002: Support for Schedule of Expenditures of Federal Awards in the Accounting System Information on the Federal Programs: CFDA 14.235 Criteria or Specific Requirement: In accordance with CFR 200.302 (financial management) the auditee must be able to identify all Federal awards received and expenses and the Federal programs under which they were received. Condition: We noted that in the transition from the previous accounting system, certain expenditures had not been properly classified in the new system. As a result, although detailed invoices were available to support the amounts reported on the SEFA, the expenses had not been accurately classified by award within the general ledger. Cause: NEW transitioned to a new accounting software during the fiscal year. We noted that NEW encountered certain difficulties during this process. Effect or Potential Effect: If the information on the SEFA cannot be traced back to the information within the accounting system, there is an increased potential for inaccurate reporting. Questioned Costs: Indeterminable Context: The transition to the new accounting system resulted in certain challenges. Identification as a Repeat Finding, if Applicable: Not applicable Recommendation: We recommend that NEW complete the transition to the new system and ensure that each account is properly reconciled on a monthly basis.