Finding 2023-002: U.S. Department of Agriculture ALN #10.542, Pandemic EBT Food Benefits (P-EBT) (COVID-19) Grant #Not Applicable ALN #10.551 and 10.561, Supplemental Nutrition Assistance Program Cluster (SNAP) Grant #Various Criteria: Federal regulation, 2 CFR 200.303, requires non-Federal entities to, among other things, 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. Condition: The Department of Public Health and Human Services (department) did not have sufficient internal controls in place to ensure accounting records for SNAP and P-EBT were accurate and adequate to trace expenditures to each federal program. Questioned Costs: No questioned costs identified. Context: The P-EBT program was established in 2021 in response to the pandemic. When the initial accounting for the program was set up, it was co-mingled with SNAP funds on the accounting records. The department made correcting entries to separate the activity between the P-EBT and SNAP programs. The initial error and subsequent corrections resulted in SEFA misstatements in fiscal years 2021 and 2022. This issue is discussed in finding 2023-11. While we did not identify any reportable errors related to the SEFA in fiscal year 2023, underlying accounting records contained multiple errors due to additional clean-up and numerous correcting entries. As a result of these accounting errors and adjustments, financial activity in both programs was also misstated in both years of the audit period. Our analysis of the P-EBT and SNAP activity involved a review of revenue and expenditure totals at the end of each fiscal years 2021, 2022, and 2023. We compared ending totals on the accounting records to amounts of benefits issued and settled from a separate system. We did not review the individual accounting transactions made throughout the year. As state accounting policy allows for prior year corrections, we considered the need for correcting entries as part of our analysis. Based on our analysis, we projected the cumulative errors remaining in each program. The table below summarizes these errors in revenue and expenditures at the end of fiscal year 2023. See the Schedule of Findings and Questioned Costs for chart/table. As a result of the initial co-mingled funds, the department is not in compliance with federal regulation 2 CFR 200.302 which in part requires the state’s financial management system be able to trace expenditures adequately and identify the source and application of funds for each federal program. Department personnel provided additional reports separate from the accounting records that allowed us to distinguish activity by program. Therefore, we do not consider this to be material noncompliance for either PEBT or SNAP. Effect: Without adequate internal control over the accounting for federal programs, the department is at risk of noncompliance with federal regulations. Additionally, since the state uses accounting records to compile the Schedule of Expenditures of Federal Awards (SEFA), corresponding misstatements on the SEFA could impact major federal program determinations. Misstating expenditures could also result in federal revenues drawn in advance of actual expenditures, which doesn’t follow federal regulations for reimbursement grants. Cause: Per the department, the initial accounting for P-EBT was not set up correctly and was co-mingled with SNAP due to limited award guidance received. Additionally, the original pandemic-related budget authority was initially insufficient to cover actual issuances and redemptions under the program, resulting in the department using SNAP budget authority until additional P-EBT authorization was obtained. As part of clean-up and corrections for this activity, numerous journal entries were made, resulting in additional errors. Recommendation: We recommend the Department of Public Health and Human Services enhance internal controls to ensure accounting records accurately reflect the financial activity of a federal program. Views of Responsible Officials: The department conditionally concurs with this recommendation. The department disagrees with our position that they were not in compliance with 2 CFR 200.302, as they tracked activity by program in a separate system. Rebuttal of Views of Responsible Officials: We considered the department’s conditional concurrence, however, since the system used to track program activity was not the state’s financial management system, it is our position that the department’s internal controls are not adequate to ensure compliance with 2 CFR 200.302. As such, our recommendation stands.
Finding 2023-002: U.S. Department of Agriculture ALN #10.542, Pandemic EBT Food Benefits (P-EBT) (COVID-19) Grant #Not Applicable ALN #10.551 and 10.561, Supplemental Nutrition Assistance Program Cluster (SNAP) Grant #Various Criteria: Federal regulation, 2 CFR 200.303, requires non-Federal entities to, among other things, 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. Condition: The Department of Public Health and Human Services (department) did not have sufficient internal controls in place to ensure accounting records for SNAP and P-EBT were accurate and adequate to trace expenditures to each federal program. Questioned Costs: No questioned costs identified. Context: The P-EBT program was established in 2021 in response to the pandemic. When the initial accounting for the program was set up, it was co-mingled with SNAP funds on the accounting records. The department made correcting entries to separate the activity between the P-EBT and SNAP programs. The initial error and subsequent corrections resulted in SEFA misstatements in fiscal years 2021 and 2022. This issue is discussed in finding 2023-11. While we did not identify any reportable errors related to the SEFA in fiscal year 2023, underlying accounting records contained multiple errors due to additional clean-up and numerous correcting entries. As a result of these accounting errors and adjustments, financial activity in both programs was also misstated in both years of the audit period. Our analysis of the P-EBT and SNAP activity involved a review of revenue and expenditure totals at the end of each fiscal years 2021, 2022, and 2023. We compared ending totals on the accounting records to amounts of benefits issued and settled from a separate system. We did not review the individual accounting transactions made throughout the year. As state accounting policy allows for prior year corrections, we considered the need for correcting entries as part of our analysis. Based on our analysis, we projected the cumulative errors remaining in each program. The table below summarizes these errors in revenue and expenditures at the end of fiscal year 2023. See the Schedule of Findings and Questioned Costs for chart/table. As a result of the initial co-mingled funds, the department is not in compliance with federal regulation 2 CFR 200.302 which in part requires the state’s financial management system be able to trace expenditures adequately and identify the source and application of funds for each federal program. Department personnel provided additional reports separate from the accounting records that allowed us to distinguish activity by program. Therefore, we do not consider this to be material noncompliance for either PEBT or SNAP. Effect: Without adequate internal control over the accounting for federal programs, the department is at risk of noncompliance with federal regulations. Additionally, since the state uses accounting records to compile the Schedule of Expenditures of Federal Awards (SEFA), corresponding misstatements on the SEFA could impact major federal program determinations. Misstating expenditures could also result in federal revenues drawn in advance of actual expenditures, which doesn’t follow federal regulations for reimbursement grants. Cause: Per the department, the initial accounting for P-EBT was not set up correctly and was co-mingled with SNAP due to limited award guidance received. Additionally, the original pandemic-related budget authority was initially insufficient to cover actual issuances and redemptions under the program, resulting in the department using SNAP budget authority until additional P-EBT authorization was obtained. As part of clean-up and corrections for this activity, numerous journal entries were made, resulting in additional errors. Recommendation: We recommend the Department of Public Health and Human Services enhance internal controls to ensure accounting records accurately reflect the financial activity of a federal program. Views of Responsible Officials: The department conditionally concurs with this recommendation. The department disagrees with our position that they were not in compliance with 2 CFR 200.302, as they tracked activity by program in a separate system. Rebuttal of Views of Responsible Officials: We considered the department’s conditional concurrence, however, since the system used to track program activity was not the state’s financial management system, it is our position that the department’s internal controls are not adequate to ensure compliance with 2 CFR 200.302. As such, our recommendation stands.
Finding 2023-002: U.S. Department of Agriculture ALN #10.542, Pandemic EBT Food Benefits (P-EBT) (COVID-19) Grant #Not Applicable ALN #10.551 and 10.561, Supplemental Nutrition Assistance Program Cluster (SNAP) Grant #Various Criteria: Federal regulation, 2 CFR 200.303, requires non-Federal entities to, among other things, 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. Condition: The Department of Public Health and Human Services (department) did not have sufficient internal controls in place to ensure accounting records for SNAP and P-EBT were accurate and adequate to trace expenditures to each federal program. Questioned Costs: No questioned costs identified. Context: The P-EBT program was established in 2021 in response to the pandemic. When the initial accounting for the program was set up, it was co-mingled with SNAP funds on the accounting records. The department made correcting entries to separate the activity between the P-EBT and SNAP programs. The initial error and subsequent corrections resulted in SEFA misstatements in fiscal years 2021 and 2022. This issue is discussed in finding 2023-11. While we did not identify any reportable errors related to the SEFA in fiscal year 2023, underlying accounting records contained multiple errors due to additional clean-up and numerous correcting entries. As a result of these accounting errors and adjustments, financial activity in both programs was also misstated in both years of the audit period. Our analysis of the P-EBT and SNAP activity involved a review of revenue and expenditure totals at the end of each fiscal years 2021, 2022, and 2023. We compared ending totals on the accounting records to amounts of benefits issued and settled from a separate system. We did not review the individual accounting transactions made throughout the year. As state accounting policy allows for prior year corrections, we considered the need for correcting entries as part of our analysis. Based on our analysis, we projected the cumulative errors remaining in each program. The table below summarizes these errors in revenue and expenditures at the end of fiscal year 2023. See the Schedule of Findings and Questioned Costs for chart/table. As a result of the initial co-mingled funds, the department is not in compliance with federal regulation 2 CFR 200.302 which in part requires the state’s financial management system be able to trace expenditures adequately and identify the source and application of funds for each federal program. Department personnel provided additional reports separate from the accounting records that allowed us to distinguish activity by program. Therefore, we do not consider this to be material noncompliance for either PEBT or SNAP. Effect: Without adequate internal control over the accounting for federal programs, the department is at risk of noncompliance with federal regulations. Additionally, since the state uses accounting records to compile the Schedule of Expenditures of Federal Awards (SEFA), corresponding misstatements on the SEFA could impact major federal program determinations. Misstating expenditures could also result in federal revenues drawn in advance of actual expenditures, which doesn’t follow federal regulations for reimbursement grants. Cause: Per the department, the initial accounting for P-EBT was not set up correctly and was co-mingled with SNAP due to limited award guidance received. Additionally, the original pandemic-related budget authority was initially insufficient to cover actual issuances and redemptions under the program, resulting in the department using SNAP budget authority until additional P-EBT authorization was obtained. As part of clean-up and corrections for this activity, numerous journal entries were made, resulting in additional errors. Recommendation: We recommend the Department of Public Health and Human Services enhance internal controls to ensure accounting records accurately reflect the financial activity of a federal program. Views of Responsible Officials: The department conditionally concurs with this recommendation. The department disagrees with our position that they were not in compliance with 2 CFR 200.302, as they tracked activity by program in a separate system. Rebuttal of Views of Responsible Officials: We considered the department’s conditional concurrence, however, since the system used to track program activity was not the state’s financial management system, it is our position that the department’s internal controls are not adequate to ensure compliance with 2 CFR 200.302. As such, our recommendation stands.
Finding 2023-002: U.S. Department of Agriculture ALN #10.542, Pandemic EBT Food Benefits (P-EBT) (COVID-19) Grant #Not Applicable ALN #10.551 and 10.561, Supplemental Nutrition Assistance Program Cluster (SNAP) Grant #Various Criteria: Federal regulation, 2 CFR 200.303, requires non-Federal entities to, among other things, 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. Condition: The Department of Public Health and Human Services (department) did not have sufficient internal controls in place to ensure accounting records for SNAP and P-EBT were accurate and adequate to trace expenditures to each federal program. Questioned Costs: No questioned costs identified. Context: The P-EBT program was established in 2021 in response to the pandemic. When the initial accounting for the program was set up, it was co-mingled with SNAP funds on the accounting records. The department made correcting entries to separate the activity between the P-EBT and SNAP programs. The initial error and subsequent corrections resulted in SEFA misstatements in fiscal years 2021 and 2022. This issue is discussed in finding 2023-11. While we did not identify any reportable errors related to the SEFA in fiscal year 2023, underlying accounting records contained multiple errors due to additional clean-up and numerous correcting entries. As a result of these accounting errors and adjustments, financial activity in both programs was also misstated in both years of the audit period. Our analysis of the P-EBT and SNAP activity involved a review of revenue and expenditure totals at the end of each fiscal years 2021, 2022, and 2023. We compared ending totals on the accounting records to amounts of benefits issued and settled from a separate system. We did not review the individual accounting transactions made throughout the year. As state accounting policy allows for prior year corrections, we considered the need for correcting entries as part of our analysis. Based on our analysis, we projected the cumulative errors remaining in each program. The table below summarizes these errors in revenue and expenditures at the end of fiscal year 2023. See the Schedule of Findings and Questioned Costs for chart/table. As a result of the initial co-mingled funds, the department is not in compliance with federal regulation 2 CFR 200.302 which in part requires the state’s financial management system be able to trace expenditures adequately and identify the source and application of funds for each federal program. Department personnel provided additional reports separate from the accounting records that allowed us to distinguish activity by program. Therefore, we do not consider this to be material noncompliance for either PEBT or SNAP. Effect: Without adequate internal control over the accounting for federal programs, the department is at risk of noncompliance with federal regulations. Additionally, since the state uses accounting records to compile the Schedule of Expenditures of Federal Awards (SEFA), corresponding misstatements on the SEFA could impact major federal program determinations. Misstating expenditures could also result in federal revenues drawn in advance of actual expenditures, which doesn’t follow federal regulations for reimbursement grants. Cause: Per the department, the initial accounting for P-EBT was not set up correctly and was co-mingled with SNAP due to limited award guidance received. Additionally, the original pandemic-related budget authority was initially insufficient to cover actual issuances and redemptions under the program, resulting in the department using SNAP budget authority until additional P-EBT authorization was obtained. As part of clean-up and corrections for this activity, numerous journal entries were made, resulting in additional errors. Recommendation: We recommend the Department of Public Health and Human Services enhance internal controls to ensure accounting records accurately reflect the financial activity of a federal program. Views of Responsible Officials: The department conditionally concurs with this recommendation. The department disagrees with our position that they were not in compliance with 2 CFR 200.302, as they tracked activity by program in a separate system. Rebuttal of Views of Responsible Officials: We considered the department’s conditional concurrence, however, since the system used to track program activity was not the state’s financial management system, it is our position that the department’s internal controls are not adequate to ensure compliance with 2 CFR 200.302. As such, our recommendation stands.
Finding 2023-002: U.S. Department of Agriculture ALN #10.542, Pandemic EBT Food Benefits (P-EBT) (COVID-19) Grant #Not Applicable ALN #10.551 and 10.561, Supplemental Nutrition Assistance Program Cluster (SNAP) Grant #Various Criteria: Federal regulation, 2 CFR 200.303, requires non-Federal entities to, among other things, 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. Condition: The Department of Public Health and Human Services (department) did not have sufficient internal controls in place to ensure accounting records for SNAP and P-EBT were accurate and adequate to trace expenditures to each federal program. Questioned Costs: No questioned costs identified. Context: The P-EBT program was established in 2021 in response to the pandemic. When the initial accounting for the program was set up, it was co-mingled with SNAP funds on the accounting records. The department made correcting entries to separate the activity between the P-EBT and SNAP programs. The initial error and subsequent corrections resulted in SEFA misstatements in fiscal years 2021 and 2022. This issue is discussed in finding 2023-11. While we did not identify any reportable errors related to the SEFA in fiscal year 2023, underlying accounting records contained multiple errors due to additional clean-up and numerous correcting entries. As a result of these accounting errors and adjustments, financial activity in both programs was also misstated in both years of the audit period. Our analysis of the P-EBT and SNAP activity involved a review of revenue and expenditure totals at the end of each fiscal years 2021, 2022, and 2023. We compared ending totals on the accounting records to amounts of benefits issued and settled from a separate system. We did not review the individual accounting transactions made throughout the year. As state accounting policy allows for prior year corrections, we considered the need for correcting entries as part of our analysis. Based on our analysis, we projected the cumulative errors remaining in each program. The table below summarizes these errors in revenue and expenditures at the end of fiscal year 2023. See the Schedule of Findings and Questioned Costs for chart/table. As a result of the initial co-mingled funds, the department is not in compliance with federal regulation 2 CFR 200.302 which in part requires the state’s financial management system be able to trace expenditures adequately and identify the source and application of funds for each federal program. Department personnel provided additional reports separate from the accounting records that allowed us to distinguish activity by program. Therefore, we do not consider this to be material noncompliance for either PEBT or SNAP. Effect: Without adequate internal control over the accounting for federal programs, the department is at risk of noncompliance with federal regulations. Additionally, since the state uses accounting records to compile the Schedule of Expenditures of Federal Awards (SEFA), corresponding misstatements on the SEFA could impact major federal program determinations. Misstating expenditures could also result in federal revenues drawn in advance of actual expenditures, which doesn’t follow federal regulations for reimbursement grants. Cause: Per the department, the initial accounting for P-EBT was not set up correctly and was co-mingled with SNAP due to limited award guidance received. Additionally, the original pandemic-related budget authority was initially insufficient to cover actual issuances and redemptions under the program, resulting in the department using SNAP budget authority until additional P-EBT authorization was obtained. As part of clean-up and corrections for this activity, numerous journal entries were made, resulting in additional errors. Recommendation: We recommend the Department of Public Health and Human Services enhance internal controls to ensure accounting records accurately reflect the financial activity of a federal program. Views of Responsible Officials: The department conditionally concurs with this recommendation. The department disagrees with our position that they were not in compliance with 2 CFR 200.302, as they tracked activity by program in a separate system. Rebuttal of Views of Responsible Officials: We considered the department’s conditional concurrence, however, since the system used to track program activity was not the state’s financial management system, it is our position that the department’s internal controls are not adequate to ensure compliance with 2 CFR 200.302. As such, our recommendation stands.
Finding 2023-002: U.S. Department of Agriculture ALN #10.542, Pandemic EBT Food Benefits (P-EBT) (COVID-19) Grant #Not Applicable ALN #10.551 and 10.561, Supplemental Nutrition Assistance Program Cluster (SNAP) Grant #Various Criteria: Federal regulation, 2 CFR 200.303, requires non-Federal entities to, among other things, 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. Condition: The Department of Public Health and Human Services (department) did not have sufficient internal controls in place to ensure accounting records for SNAP and P-EBT were accurate and adequate to trace expenditures to each federal program. Questioned Costs: No questioned costs identified. Context: The P-EBT program was established in 2021 in response to the pandemic. When the initial accounting for the program was set up, it was co-mingled with SNAP funds on the accounting records. The department made correcting entries to separate the activity between the P-EBT and SNAP programs. The initial error and subsequent corrections resulted in SEFA misstatements in fiscal years 2021 and 2022. This issue is discussed in finding 2023-11. While we did not identify any reportable errors related to the SEFA in fiscal year 2023, underlying accounting records contained multiple errors due to additional clean-up and numerous correcting entries. As a result of these accounting errors and adjustments, financial activity in both programs was also misstated in both years of the audit period. Our analysis of the P-EBT and SNAP activity involved a review of revenue and expenditure totals at the end of each fiscal years 2021, 2022, and 2023. We compared ending totals on the accounting records to amounts of benefits issued and settled from a separate system. We did not review the individual accounting transactions made throughout the year. As state accounting policy allows for prior year corrections, we considered the need for correcting entries as part of our analysis. Based on our analysis, we projected the cumulative errors remaining in each program. The table below summarizes these errors in revenue and expenditures at the end of fiscal year 2023. See the Schedule of Findings and Questioned Costs for chart/table. As a result of the initial co-mingled funds, the department is not in compliance with federal regulation 2 CFR 200.302 which in part requires the state’s financial management system be able to trace expenditures adequately and identify the source and application of funds for each federal program. Department personnel provided additional reports separate from the accounting records that allowed us to distinguish activity by program. Therefore, we do not consider this to be material noncompliance for either PEBT or SNAP. Effect: Without adequate internal control over the accounting for federal programs, the department is at risk of noncompliance with federal regulations. Additionally, since the state uses accounting records to compile the Schedule of Expenditures of Federal Awards (SEFA), corresponding misstatements on the SEFA could impact major federal program determinations. Misstating expenditures could also result in federal revenues drawn in advance of actual expenditures, which doesn’t follow federal regulations for reimbursement grants. Cause: Per the department, the initial accounting for P-EBT was not set up correctly and was co-mingled with SNAP due to limited award guidance received. Additionally, the original pandemic-related budget authority was initially insufficient to cover actual issuances and redemptions under the program, resulting in the department using SNAP budget authority until additional P-EBT authorization was obtained. As part of clean-up and corrections for this activity, numerous journal entries were made, resulting in additional errors. Recommendation: We recommend the Department of Public Health and Human Services enhance internal controls to ensure accounting records accurately reflect the financial activity of a federal program. Views of Responsible Officials: The department conditionally concurs with this recommendation. The department disagrees with our position that they were not in compliance with 2 CFR 200.302, as they tracked activity by program in a separate system. Rebuttal of Views of Responsible Officials: We considered the department’s conditional concurrence, however, since the system used to track program activity was not the state’s financial management system, it is our position that the department’s internal controls are not adequate to ensure compliance with 2 CFR 200.302. As such, our recommendation stands.
Finding 2023-002: U.S. Department of Agriculture ALN #10.542, Pandemic EBT Food Benefits (P-EBT) (COVID-19) Grant #Not Applicable ALN #10.551 and 10.561, Supplemental Nutrition Assistance Program Cluster (SNAP) Grant #Various Criteria: Federal regulation, 2 CFR 200.303, requires non-Federal entities to, among other things, 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. Condition: The Department of Public Health and Human Services (department) did not have sufficient internal controls in place to ensure accounting records for SNAP and P-EBT were accurate and adequate to trace expenditures to each federal program. Questioned Costs: No questioned costs identified. Context: The P-EBT program was established in 2021 in response to the pandemic. When the initial accounting for the program was set up, it was co-mingled with SNAP funds on the accounting records. The department made correcting entries to separate the activity between the P-EBT and SNAP programs. The initial error and subsequent corrections resulted in SEFA misstatements in fiscal years 2021 and 2022. This issue is discussed in finding 2023-11. While we did not identify any reportable errors related to the SEFA in fiscal year 2023, underlying accounting records contained multiple errors due to additional clean-up and numerous correcting entries. As a result of these accounting errors and adjustments, financial activity in both programs was also misstated in both years of the audit period. Our analysis of the P-EBT and SNAP activity involved a review of revenue and expenditure totals at the end of each fiscal years 2021, 2022, and 2023. We compared ending totals on the accounting records to amounts of benefits issued and settled from a separate system. We did not review the individual accounting transactions made throughout the year. As state accounting policy allows for prior year corrections, we considered the need for correcting entries as part of our analysis. Based on our analysis, we projected the cumulative errors remaining in each program. The table below summarizes these errors in revenue and expenditures at the end of fiscal year 2023. See the Schedule of Findings and Questioned Costs for chart/table. As a result of the initial co-mingled funds, the department is not in compliance with federal regulation 2 CFR 200.302 which in part requires the state’s financial management system be able to trace expenditures adequately and identify the source and application of funds for each federal program. Department personnel provided additional reports separate from the accounting records that allowed us to distinguish activity by program. Therefore, we do not consider this to be material noncompliance for either PEBT or SNAP. Effect: Without adequate internal control over the accounting for federal programs, the department is at risk of noncompliance with federal regulations. Additionally, since the state uses accounting records to compile the Schedule of Expenditures of Federal Awards (SEFA), corresponding misstatements on the SEFA could impact major federal program determinations. Misstating expenditures could also result in federal revenues drawn in advance of actual expenditures, which doesn’t follow federal regulations for reimbursement grants. Cause: Per the department, the initial accounting for P-EBT was not set up correctly and was co-mingled with SNAP due to limited award guidance received. Additionally, the original pandemic-related budget authority was initially insufficient to cover actual issuances and redemptions under the program, resulting in the department using SNAP budget authority until additional P-EBT authorization was obtained. As part of clean-up and corrections for this activity, numerous journal entries were made, resulting in additional errors. Recommendation: We recommend the Department of Public Health and Human Services enhance internal controls to ensure accounting records accurately reflect the financial activity of a federal program. Views of Responsible Officials: The department conditionally concurs with this recommendation. The department disagrees with our position that they were not in compliance with 2 CFR 200.302, as they tracked activity by program in a separate system. Rebuttal of Views of Responsible Officials: We considered the department’s conditional concurrence, however, since the system used to track program activity was not the state’s financial management system, it is our position that the department’s internal controls are not adequate to ensure compliance with 2 CFR 200.302. As such, our recommendation stands.
Finding 2023-002: U.S. Department of Agriculture ALN #10.542, Pandemic EBT Food Benefits (P-EBT) (COVID-19) Grant #Not Applicable ALN #10.551 and 10.561, Supplemental Nutrition Assistance Program Cluster (SNAP) Grant #Various Criteria: Federal regulation, 2 CFR 200.303, requires non-Federal entities to, among other things, 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. Condition: The Department of Public Health and Human Services (department) did not have sufficient internal controls in place to ensure accounting records for SNAP and P-EBT were accurate and adequate to trace expenditures to each federal program. Questioned Costs: No questioned costs identified. Context: The P-EBT program was established in 2021 in response to the pandemic. When the initial accounting for the program was set up, it was co-mingled with SNAP funds on the accounting records. The department made correcting entries to separate the activity between the P-EBT and SNAP programs. The initial error and subsequent corrections resulted in SEFA misstatements in fiscal years 2021 and 2022. This issue is discussed in finding 2023-11. While we did not identify any reportable errors related to the SEFA in fiscal year 2023, underlying accounting records contained multiple errors due to additional clean-up and numerous correcting entries. As a result of these accounting errors and adjustments, financial activity in both programs was also misstated in both years of the audit period. Our analysis of the P-EBT and SNAP activity involved a review of revenue and expenditure totals at the end of each fiscal years 2021, 2022, and 2023. We compared ending totals on the accounting records to amounts of benefits issued and settled from a separate system. We did not review the individual accounting transactions made throughout the year. As state accounting policy allows for prior year corrections, we considered the need for correcting entries as part of our analysis. Based on our analysis, we projected the cumulative errors remaining in each program. The table below summarizes these errors in revenue and expenditures at the end of fiscal year 2023. See the Schedule of Findings and Questioned Costs for chart/table. As a result of the initial co-mingled funds, the department is not in compliance with federal regulation 2 CFR 200.302 which in part requires the state’s financial management system be able to trace expenditures adequately and identify the source and application of funds for each federal program. Department personnel provided additional reports separate from the accounting records that allowed us to distinguish activity by program. Therefore, we do not consider this to be material noncompliance for either PEBT or SNAP. Effect: Without adequate internal control over the accounting for federal programs, the department is at risk of noncompliance with federal regulations. Additionally, since the state uses accounting records to compile the Schedule of Expenditures of Federal Awards (SEFA), corresponding misstatements on the SEFA could impact major federal program determinations. Misstating expenditures could also result in federal revenues drawn in advance of actual expenditures, which doesn’t follow federal regulations for reimbursement grants. Cause: Per the department, the initial accounting for P-EBT was not set up correctly and was co-mingled with SNAP due to limited award guidance received. Additionally, the original pandemic-related budget authority was initially insufficient to cover actual issuances and redemptions under the program, resulting in the department using SNAP budget authority until additional P-EBT authorization was obtained. As part of clean-up and corrections for this activity, numerous journal entries were made, resulting in additional errors. Recommendation: We recommend the Department of Public Health and Human Services enhance internal controls to ensure accounting records accurately reflect the financial activity of a federal program. Views of Responsible Officials: The department conditionally concurs with this recommendation. The department disagrees with our position that they were not in compliance with 2 CFR 200.302, as they tracked activity by program in a separate system. Rebuttal of Views of Responsible Officials: We considered the department’s conditional concurrence, however, since the system used to track program activity was not the state’s financial management system, it is our position that the department’s internal controls are not adequate to ensure compliance with 2 CFR 200.302. As such, our recommendation stands.
Finding 2023-002: U.S. Department of Agriculture ALN #10.542, Pandemic EBT Food Benefits (P-EBT) (COVID-19) Grant #Not Applicable ALN #10.551 and 10.561, Supplemental Nutrition Assistance Program Cluster (SNAP) Grant #Various Criteria: Federal regulation, 2 CFR 200.303, requires non-Federal entities to, among other things, 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. Condition: The Department of Public Health and Human Services (department) did not have sufficient internal controls in place to ensure accounting records for SNAP and P-EBT were accurate and adequate to trace expenditures to each federal program. Questioned Costs: No questioned costs identified. Context: The P-EBT program was established in 2021 in response to the pandemic. When the initial accounting for the program was set up, it was co-mingled with SNAP funds on the accounting records. The department made correcting entries to separate the activity between the P-EBT and SNAP programs. The initial error and subsequent corrections resulted in SEFA misstatements in fiscal years 2021 and 2022. This issue is discussed in finding 2023-11. While we did not identify any reportable errors related to the SEFA in fiscal year 2023, underlying accounting records contained multiple errors due to additional clean-up and numerous correcting entries. As a result of these accounting errors and adjustments, financial activity in both programs was also misstated in both years of the audit period. Our analysis of the P-EBT and SNAP activity involved a review of revenue and expenditure totals at the end of each fiscal years 2021, 2022, and 2023. We compared ending totals on the accounting records to amounts of benefits issued and settled from a separate system. We did not review the individual accounting transactions made throughout the year. As state accounting policy allows for prior year corrections, we considered the need for correcting entries as part of our analysis. Based on our analysis, we projected the cumulative errors remaining in each program. The table below summarizes these errors in revenue and expenditures at the end of fiscal year 2023. See the Schedule of Findings and Questioned Costs for chart/table. As a result of the initial co-mingled funds, the department is not in compliance with federal regulation 2 CFR 200.302 which in part requires the state’s financial management system be able to trace expenditures adequately and identify the source and application of funds for each federal program. Department personnel provided additional reports separate from the accounting records that allowed us to distinguish activity by program. Therefore, we do not consider this to be material noncompliance for either PEBT or SNAP. Effect: Without adequate internal control over the accounting for federal programs, the department is at risk of noncompliance with federal regulations. Additionally, since the state uses accounting records to compile the Schedule of Expenditures of Federal Awards (SEFA), corresponding misstatements on the SEFA could impact major federal program determinations. Misstating expenditures could also result in federal revenues drawn in advance of actual expenditures, which doesn’t follow federal regulations for reimbursement grants. Cause: Per the department, the initial accounting for P-EBT was not set up correctly and was co-mingled with SNAP due to limited award guidance received. Additionally, the original pandemic-related budget authority was initially insufficient to cover actual issuances and redemptions under the program, resulting in the department using SNAP budget authority until additional P-EBT authorization was obtained. As part of clean-up and corrections for this activity, numerous journal entries were made, resulting in additional errors. Recommendation: We recommend the Department of Public Health and Human Services enhance internal controls to ensure accounting records accurately reflect the financial activity of a federal program. Views of Responsible Officials: The department conditionally concurs with this recommendation. The department disagrees with our position that they were not in compliance with 2 CFR 200.302, as they tracked activity by program in a separate system. Rebuttal of Views of Responsible Officials: We considered the department’s conditional concurrence, however, since the system used to track program activity was not the state’s financial management system, it is our position that the department’s internal controls are not adequate to ensure compliance with 2 CFR 200.302. As such, our recommendation stands.
Uniform Guidance 2 CFR 200.302 requires districts must ensure that expenditures are charged to the proper budget accounts and that a system is in place to prevent over budgeted expenditures.
Uniform Guidance 2 CFR 200.302 requires districts must ensure that expenditures are charged to the proper budget accounts and that a system is in place to prevent over budgeted expenditures.
Uniform Guidance 2 CFR 200.302 requires districts must ensure that expenditures are charged to the proper budget accounts and that a system is in place to prevent over budgeted expenditures.
Uniform Guidance 2 CFR 200.302 requires districts must ensure that expenditures are charged to the proper budget accounts and that a system is in place to prevent over budgeted expenditures.
1. Site Claim Reporting Finding Number: 2023-002 Assistance Listing Number and Title: AL # 10.555/10.553 Child Nutrition Cluster Federal Award Identification Number / Year: 2023 Federal Agency: U.S. Department of Agriculture Compliance Requirement: Reporting Pass-Through Entity: Ohio Department of Education and Workforce Repeat Finding from Prior Audit? No Noncompliance and Material Weakness 2 CFR § 400.1 gives regulatory effect to the Department of Agriculture for 2 CFR §200.302(b)(3) which provides that the financial management system of each non-Federal entity must provide for 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. 2 CFR § 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. 7 CFR §§ 210.7(c), 210.8(c), and 225.9(d)) provide that at a minimum, a claim must include the number of reimbursable meals/milk served by category and type during the period (generally a month) covered by the claim. All meals claimed for reimbursement must (a) be of types authorized by the school food authority’s, institution’s, or sponsor’s administering agency; (b) be served to eligible children; and (c) be supported by accurate meal counts and records indicating the number of meals served by category and type. 20% percent of the site claim form submissions during fiscal year 2023 did not agree to underlying supporting documentation. These inaccurate submissions resulted in an under-reimbursement of $6,047. The School District contacted the Ohio Department of Education and Workforce in April 2024 and were granted a One-Time-Exception for the one month's underreporting of $6,275. These errors occurred due to a weakness in internal controls, which failed to ensure site claim forms for reimbursable meals served at each building and submitted by the Center to the Ohio Department of Education were entered correctly. The School District should implement policies and procedures to help ensure that monthly site claim forms are reviewed and submitted to reflect actual counts for reimbursable meals served. Further, measures should be taken to ensure staff completing the site claim forms are adequately trained.
1. Site Claim Reporting Finding Number: 2023-002 Assistance Listing Number and Title: AL # 10.555/10.553 Child Nutrition Cluster Federal Award Identification Number / Year: 2023 Federal Agency: U.S. Department of Agriculture Compliance Requirement: Reporting Pass-Through Entity: Ohio Department of Education and Workforce Repeat Finding from Prior Audit? No Noncompliance and Material Weakness 2 CFR § 400.1 gives regulatory effect to the Department of Agriculture for 2 CFR §200.302(b)(3) which provides that the financial management system of each non-Federal entity must provide for 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. 2 CFR § 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. 7 CFR §§ 210.7(c), 210.8(c), and 225.9(d)) provide that at a minimum, a claim must include the number of reimbursable meals/milk served by category and type during the period (generally a month) covered by the claim. All meals claimed for reimbursement must (a) be of types authorized by the school food authority’s, institution’s, or sponsor’s administering agency; (b) be served to eligible children; and (c) be supported by accurate meal counts and records indicating the number of meals served by category and type. 20% percent of the site claim form submissions during fiscal year 2023 did not agree to underlying supporting documentation. These inaccurate submissions resulted in an under-reimbursement of $6,047. The School District contacted the Ohio Department of Education and Workforce in April 2024 and were granted a One-Time-Exception for the one month's underreporting of $6,275. These errors occurred due to a weakness in internal controls, which failed to ensure site claim forms for reimbursable meals served at each building and submitted by the Center to the Ohio Department of Education were entered correctly. The School District should implement policies and procedures to help ensure that monthly site claim forms are reviewed and submitted to reflect actual counts for reimbursable meals served. Further, measures should be taken to ensure staff completing the site claim forms are adequately trained.
1. Site Claim Reporting Finding Number: 2023-002 Assistance Listing Number and Title: AL # 10.555/10.553 Child Nutrition Cluster Federal Award Identification Number / Year: 2023 Federal Agency: U.S. Department of Agriculture Compliance Requirement: Reporting Pass-Through Entity: Ohio Department of Education and Workforce Repeat Finding from Prior Audit? No Noncompliance and Material Weakness 2 CFR § 400.1 gives regulatory effect to the Department of Agriculture for 2 CFR §200.302(b)(3) which provides that the financial management system of each non-Federal entity must provide for 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. 2 CFR § 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. 7 CFR §§ 210.7(c), 210.8(c), and 225.9(d)) provide that at a minimum, a claim must include the number of reimbursable meals/milk served by category and type during the period (generally a month) covered by the claim. All meals claimed for reimbursement must (a) be of types authorized by the school food authority’s, institution’s, or sponsor’s administering agency; (b) be served to eligible children; and (c) be supported by accurate meal counts and records indicating the number of meals served by category and type. 20% percent of the site claim form submissions during fiscal year 2023 did not agree to underlying supporting documentation. These inaccurate submissions resulted in an under-reimbursement of $6,047. The School District contacted the Ohio Department of Education and Workforce in April 2024 and were granted a One-Time-Exception for the one month's underreporting of $6,275. These errors occurred due to a weakness in internal controls, which failed to ensure site claim forms for reimbursable meals served at each building and submitted by the Center to the Ohio Department of Education were entered correctly. The School District should implement policies and procedures to help ensure that monthly site claim forms are reviewed and submitted to reflect actual counts for reimbursable meals served. Further, measures should be taken to ensure staff completing the site claim forms are adequately trained.
1. Site Claim Reporting Finding Number: 2023-002 Assistance Listing Number and Title: AL # 10.555/10.553 Child Nutrition Cluster Federal Award Identification Number / Year: 2023 Federal Agency: U.S. Department of Agriculture Compliance Requirement: Reporting Pass-Through Entity: Ohio Department of Education and Workforce Repeat Finding from Prior Audit? No Noncompliance and Material Weakness 2 CFR § 400.1 gives regulatory effect to the Department of Agriculture for 2 CFR §200.302(b)(3) which provides that the financial management system of each non-Federal entity must provide for 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. 2 CFR § 200.303 requires that non-Federal entities receiving Federal awards (i.e., auditee management) establish and maintain internal control designed to reasonably ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. 7 CFR §§ 210.7(c), 210.8(c), and 225.9(d)) provide that at a minimum, a claim must include the number of reimbursable meals/milk served by category and type during the period (generally a month) covered by the claim. All meals claimed for reimbursement must (a) be of types authorized by the school food authority’s, institution’s, or sponsor’s administering agency; (b) be served to eligible children; and (c) be supported by accurate meal counts and records indicating the number of meals served by category and type. 20% percent of the site claim form submissions during fiscal year 2023 did not agree to underlying supporting documentation. These inaccurate submissions resulted in an under-reimbursement of $6,047. The School District contacted the Ohio Department of Education and Workforce in April 2024 and were granted a One-Time-Exception for the one month's underreporting of $6,275. These errors occurred due to a weakness in internal controls, which failed to ensure site claim forms for reimbursable meals served at each building and submitted by the Center to the Ohio Department of Education were entered correctly. The School District should implement policies and procedures to help ensure that monthly site claim forms are reviewed and submitted to reflect actual counts for reimbursable meals served. Further, measures should be taken to ensure staff completing the site claim forms are adequately trained.
Finding 2023-001 – B. Allowable Costs Federal Agency: U.S. Department of Health and Human Services Passthrough Entity: N/A Assistance Listing Number and Federal Program: 93.829 Section 223 Demonstration Programs to Improve Community Mental Health Services Criteria: In accordance with 2 CFR part 200.302, the Association is required to maintain financial management systems to trace funds to expenditures to establish that funds have been used according to Federal statutes, regulations, and the terms and conditions of the Federal award. The financial management system must provide for records that identify adequately the source and application of funds for federally funded activities, among other conditions. The reporting of the federal expenditures should be supported by these records. Amounts may not be expended from project funds on an arbitrary basis. Additionally, in accordance with 2 CFR 200.430, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records, among other things, should support the distribution of the employee’s salary or wages among specific activities if the employee works on a Federal award and non-Federal award. Budget estimates do not qualify as support for charges to Federal awards. Statement of Condition: During the course of our audit, supporting detail for expenses allocated and charged to the grant was not available and could not be determined. Salaries and benefits charged to the grant were based on estimates of employees’ expected workload and client needs, and not supported by records that accurately reflected the work performed on the Federal program. Additionally, the de minimis indirect cost rate was not correctly calculated and applied. The indirect cost charged to the grant was based on the indirect cost obligated by the Notice of Award rather than by calculating the indirect cost from the modified total direct cost base. Statement Cause: This is the second year the Association received this type of grant funding, coupled with significant growth experienced by the Association, the accounting system and staff were not yet prepared to effectively adhere to the requirements of the grant. Supporting documentation is not available for employees’ actual time spent and charged to the grants. Statement of Effect: Without proper accounting of expenditures and support of salaries and wages, grant expenditures can be over or understated on the drawdown requests. This could result in noncompliance with grant agreements which could lead to adverse conditions with the grantors. Questioned Costs: No questioned costs were identified. Identification of Repeat Findings: 2022-001 Recommendations: Project codes or classes should be created within the accounting system, if available. This will allow for expenses to be properly segregated by grant or other funding. When expenses are properly segregated, the indirect cost can be properly calculated using the correct direct cost base. The Association should also implement that all employees submit personnel activity reports to provide documentation of their time allocated to the grant. Views of Responsible Official(s): The Association is in agreement with the finding and is continuing to expand their knowledge on grant expenditures and compliance as it relates to the new financial management software to aid in tracking grants. See corrective action plan.
Condition -The Municipality’s staff could not provide us with the officially prepared and certified reports that supported compliance with the filing or submission of reports and financial information, as required by federal award and regulatory agreements. Likewise, reconciliations were not provided between the information used to prepare the required and submitted reports with the formal information presented and accounted for in the official Municipality’s accounting system. Criteria - The state is required to make an accounting to FEMA of eligible costs. Similarly, the subrecipient must make an accounting to the state. In submitting the accounting, the entity is required to certify that reported costs were incurred in performance of eligible work, that the approved work was completed, that the project in in compliance with the provisions of the FEMA-State Agreement, all grants conditions were met, ant the provisions for that project were made in accordance with the applicable payment provisions. Also, as established in the 2 CFR Section 200.302 (a) of the Uniform Guidance, 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, 2 CFR Section 200.403, states that otherwise authorized by statue, costs must be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles, be consistent with policies and procedures that apply uniformly to both federally financed and other activities of the non-Federal entity and be adequately documented. Cause - There is a lack of knowledge and training to the personnel assigned to the management and reports preparation, as required by this federal award. Additionally, the Municipality does not have an adequate monitoring and internal control regarding the activity, filing and custody of reports, as required by the federal awards and the pass-through entity, and in a way that documents and supports the compliance with reporting requirements. Effect - The program is exposed to not being in compliance with the Reporting Requirements as established in agreement. Also, the Municipality is exposed to the Grantor questioning the use of funds. Recommendation - We recommend that the staff or department in charge locate and document all required reports that were filed according to the requirements of the grant agreement, including the reconciliation thereof with the official Municipality’s accounting subsidiaries. Also, it is absolutely necessary for the Municipality to design, document, establish and provide the necessary and required training, including guidelines and procedures, to all personnel who work directly or indirectly with the management of these federal funds. Questioned Costs - None
Condition -The Municipality’s staff could not provide us with the officially prepared and certified reports that supported compliance with the filing or submission of reports and financial information, as required by federal award and regulatory agreements. Likewise, reconciliations were not provided between the information used to prepare the required and submitted reports with the formal information presented and accounted for in the official Municipality’s accounting system. Criteria - The state is required to make an accounting to FEMA of eligible costs. Similarly, the subrecipient must make an accounting to the state. In submitting the accounting, the entity is required to certify that reported costs were incurred in performance of eligible work, that the approved work was completed, that the project in in compliance with the provisions of the FEMA-State Agreement, all grants conditions were met, ant the provisions for that project were made in accordance with the applicable payment provisions. Also, as established in the 2 CFR Section 200.302 (a) of the Uniform Guidance, 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, 2 CFR Section 200.403, states that otherwise authorized by statue, costs must be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles, be consistent with policies and procedures that apply uniformly to both federally financed and other activities of the non-Federal entity and be adequately documented. Cause - There is a lack of knowledge and training to the personnel assigned to the management and reports preparation, as required by this federal award. Additionally, the Municipality does not have an adequate monitoring and internal control regarding the activity, filing and custody of reports, as required by the federal awards and the pass-through entity, and in a way that documents and supports the compliance with reporting requirements. Effect - The program is exposed to not being in compliance with the Reporting Requirements as established in agreement. Also, the Municipality is exposed to the Grantor questioning the use of funds. Recommendation - We recommend that the staff or department in charge locate and document all required reports that were filed according to the requirements of the grant agreement, including the reconciliation thereof with the official Municipality’s accounting subsidiaries. Also, it is absolutely necessary for the Municipality to design, document, establish and provide the necessary and required training, including guidelines and procedures, to all personnel who work directly or indirectly with the management of these federal funds. Questioned Costs - None
Condition -The Municipality’s staff could not provide us with the officially prepared and certified reports that supported compliance with the filing or submission of reports and financial information, as required by federal award and regulatory agreements. Likewise, reconciliations were not provided between the information used to prepare the required and submitted reports with the formal information presented and accounted for in the official Municipality’s accounting system. Criteria - The state is required to make an accounting to FEMA of eligible costs. Similarly, the subrecipient must make an accounting to the state. In submitting the accounting, the entity is required to certify that reported costs were incurred in performance of eligible work, that the approved work was completed, that the project in in compliance with the provisions of the FEMA-State Agreement, all grants conditions were met, ant the provisions for that project were made in accordance with the applicable payment provisions. Also, as established in the 2 CFR Section 200.302 (a) of the Uniform Guidance, 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, 2 CFR Section 200.403, states that otherwise authorized by statue, costs must be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles, be consistent with policies and procedures that apply uniformly to both federally financed and other activities of the non-Federal entity and be adequately documented. Cause - There is a lack of knowledge and training to the personnel assigned to the management and reports preparation, as required by this federal award. Additionally, the Municipality does not have an adequate monitoring and internal control regarding the activity, filing and custody of reports, as required by the federal awards and the pass-through entity, and in a way that documents and supports the compliance with reporting requirements. Effect - The program is exposed to not being in compliance with the Reporting Requirements as established in agreement. Also, the Municipality is exposed to the Grantor questioning the use of funds. Recommendation - We recommend that the staff or department in charge locate and document all required reports that were filed according to the requirements of the grant agreement, including the reconciliation thereof with the official Municipality’s accounting subsidiaries. Also, it is absolutely necessary for the Municipality to design, document, establish and provide the necessary and required training, including guidelines and procedures, to all personnel who work directly or indirectly with the management of these federal funds. Questioned Costs - None
Condition -The Municipality’s staff could not provide us with the officially prepared and certified reports that supported compliance with the filing or submission of reports and financial information, as required by federal award and regulatory agreements. Likewise, reconciliations were not provided between the information used to prepare the required and submitted reports with the formal information presented and accounted for in the official Municipality’s accounting system. Criteria - The state is required to make an accounting to FEMA of eligible costs. Similarly, the subrecipient must make an accounting to the state. In submitting the accounting, the entity is required to certify that reported costs were incurred in performance of eligible work, that the approved work was completed, that the project in in compliance with the provisions of the FEMA-State Agreement, all grants conditions were met, ant the provisions for that project were made in accordance with the applicable payment provisions. Also, as established in the 2 CFR Section 200.302 (a) of the Uniform Guidance, 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, 2 CFR Section 200.403, states that otherwise authorized by statue, costs must be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles, be consistent with policies and procedures that apply uniformly to both federally financed and other activities of the non-Federal entity and be adequately documented. Cause - There is a lack of knowledge and training to the personnel assigned to the management and reports preparation, as required by this federal award. Additionally, the Municipality does not have an adequate monitoring and internal control regarding the activity, filing and custody of reports, as required by the federal awards and the pass-through entity, and in a way that documents and supports the compliance with reporting requirements. Effect - The program is exposed to not being in compliance with the Reporting Requirements as established in agreement. Also, the Municipality is exposed to the Grantor questioning the use of funds. Recommendation - We recommend that the staff or department in charge locate and document all required reports that were filed according to the requirements of the grant agreement, including the reconciliation thereof with the official Municipality’s accounting subsidiaries. Also, it is absolutely necessary for the Municipality to design, document, establish and provide the necessary and required training, including guidelines and procedures, to all personnel who work directly or indirectly with the management of these federal funds. Questioned Costs - None
FINDING 2023-002 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425U Federal Award Number and Year (or Other Identifying Number): S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-003. Condition and Context The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditure, and expenditures per activity. During the audit period, the School Corporation submitted one ESSER I report, one ESSER II report, and one ESSER III report, for a total of three reports. The annual data reports were prepared by the Director of Grants and reviewed by the Chief Academic Officer; however, this process did not allow for the prevention, or detection and corrections, of errors prior to submission. Due to the lack of effective internal controls, one of the three annual data reports was not supported by the School Corporation's records. For the ESSER III report, which covered the period of July 1, 2021 to June 30, 2022, total expenses per the report were $6,026,425. However, the ledger had total expenses for the award, for that period, of $6,686,286. The lack of effective internal controls and noncompliance were isolated to the ESSER III report. 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) states in part: "The financial management system of each non-Federal entity must provide for the following: . . . INDIANA STATE BOARD OF ACCOUNTS 21 METROPOLITAN SCHOOL DISTRICT OF LAWRENCE TOWNSHIP SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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. . . ." 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." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporations management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the ESSER III report was not supported by the School Corporation's records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding by the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and strengthen its policies and procedures to ensure all reports submitted on behalf of the Education Stabilization Fund program funds are accurate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Finding 2023-002 - Source Documentation (Significant Deficiency) CFDA Title and Number: 20.513 (5310) Enhanced Mobility of Seniors and Individuals with Disabilities. Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Management CFDA Title and Number: 20.509 (5311) CARES 5311 Operating Assistance. Formula Grants for Rural. 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 disclosure of the fi-nancial results of each Federal award or program in accordance with the reporting requirements set forth in 200.328 and 200.329. Condition: The District prepared reimbursement calculations according to an internally developed spreadsheet tool, rather than using amounts directly obtained from the general ledger and supporting documentation Cause: General ledger data used to prepare spreadsheets, then used to complete reimbursement requests added unnecessary complexity and potential for errors in the reimbursement and request and grant reporting process. Internal control procedures assuring accurate and timely review of reports and filing of the reimbursement re-quests were not designed or implemented. Effect or Potential Effect: The lack of effective internal control activities over financial reporting could allow for inadvertent errors, such as calculation errors, payments for unauthorized purposes, and result in improper grant accounting, reporting, and reimbursement. Questioned Cost: No Context: Internal disputes regarding grant reimbursement request procedures were evident. The weak or nonex-istent controls over the reimbursement request procedures created a potential for inaccurate, incomplete report-ing. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2022-003 Recommendation: The District should continue to improve grant accounting efforts, and establish a more simplified and effective process for the review and approval of grant accounting and reimbursement requests. Additional training of management should occur to ensure they fully understand all compliance regulations and have the skills to assist in designing and implementing effective controls. Monitoring of the control procedures related to the grant accounting and reimbursement request should be performed regularly to ensure reports are filed accurately and timely. Information and communication regarding identified weaknesses and opportunities to improve the policies and procedures should occur among management and the individual performing the monitoring of the procedures. District's Response: The District’s Finance Manager and District Manager are working towards using general ledger reporting exclusively for reimbursement request reporting. General ledger activity became more timely as improvements were implemented based on prior year findings. Management acknowledges delays in that pro-cess that continued as a result, to some extent, of the use of the self-developed spreadsheet reports then used for completing grant reimbursement requests. Corrective Action Plan: The District’s Finance Manager will continue to make improvements in general ledg-er recording and reporting systems so that those reports can then be used without intermediary report methods to prepare reimbursement request forms. Review of the reimbursement requests will take place within data re-ports generated directly from the general ledger. The district will engage an individual or firm to ensure that the timing and overall processes related to grant reimbursement and reporting does not result in reporting errors or omissions. . Planned Implementation Date: September 30, 2024 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2023-002 - Source Documentation (Significant Deficiency) CFDA Title and Number: 20.513 (5310) Enhanced Mobility of Seniors and Individuals with Disabilities. Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Management CFDA Title and Number: 20.509 (5311) CARES 5311 Operating Assistance. Formula Grants for Rural. 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 disclosure of the fi-nancial results of each Federal award or program in accordance with the reporting requirements set forth in 200.328 and 200.329. Condition: The District prepared reimbursement calculations according to an internally developed spreadsheet tool, rather than using amounts directly obtained from the general ledger and supporting documentation Cause: General ledger data used to prepare spreadsheets, then used to complete reimbursement requests added unnecessary complexity and potential for errors in the reimbursement and request and grant reporting process. Internal control procedures assuring accurate and timely review of reports and filing of the reimbursement re-quests were not designed or implemented. Effect or Potential Effect: The lack of effective internal control activities over financial reporting could allow for inadvertent errors, such as calculation errors, payments for unauthorized purposes, and result in improper grant accounting, reporting, and reimbursement. Questioned Cost: No Context: Internal disputes regarding grant reimbursement request procedures were evident. The weak or nonex-istent controls over the reimbursement request procedures created a potential for inaccurate, incomplete report-ing. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2022-003 Recommendation: The District should continue to improve grant accounting efforts, and establish a more simplified and effective process for the review and approval of grant accounting and reimbursement requests. Additional training of management should occur to ensure they fully understand all compliance regulations and have the skills to assist in designing and implementing effective controls. Monitoring of the control procedures related to the grant accounting and reimbursement request should be performed regularly to ensure reports are filed accurately and timely. Information and communication regarding identified weaknesses and opportunities to improve the policies and procedures should occur among management and the individual performing the monitoring of the procedures. District's Response: The District’s Finance Manager and District Manager are working towards using general ledger reporting exclusively for reimbursement request reporting. General ledger activity became more timely as improvements were implemented based on prior year findings. Management acknowledges delays in that pro-cess that continued as a result, to some extent, of the use of the self-developed spreadsheet reports then used for completing grant reimbursement requests. Corrective Action Plan: The District’s Finance Manager will continue to make improvements in general ledg-er recording and reporting systems so that those reports can then be used without intermediary report methods to prepare reimbursement request forms. Review of the reimbursement requests will take place within data re-ports generated directly from the general ledger. The district will engage an individual or firm to ensure that the timing and overall processes related to grant reimbursement and reporting does not result in reporting errors or omissions. . Planned Implementation Date: September 30, 2024 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2023-002 - Source Documentation (Significant Deficiency) CFDA Title and Number: 20.513 (5310) Enhanced Mobility of Seniors and Individuals with Disabilities. Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Management CFDA Title and Number: 20.509 (5311) CARES 5311 Operating Assistance. Formula Grants for Rural. 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 disclosure of the fi-nancial results of each Federal award or program in accordance with the reporting requirements set forth in 200.328 and 200.329. Condition: The District prepared reimbursement calculations according to an internally developed spreadsheet tool, rather than using amounts directly obtained from the general ledger and supporting documentation Cause: General ledger data used to prepare spreadsheets, then used to complete reimbursement requests added unnecessary complexity and potential for errors in the reimbursement and request and grant reporting process. Internal control procedures assuring accurate and timely review of reports and filing of the reimbursement re-quests were not designed or implemented. Effect or Potential Effect: The lack of effective internal control activities over financial reporting could allow for inadvertent errors, such as calculation errors, payments for unauthorized purposes, and result in improper grant accounting, reporting, and reimbursement. Questioned Cost: No Context: Internal disputes regarding grant reimbursement request procedures were evident. The weak or nonex-istent controls over the reimbursement request procedures created a potential for inaccurate, incomplete report-ing. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2022-003 Recommendation: The District should continue to improve grant accounting efforts, and establish a more simplified and effective process for the review and approval of grant accounting and reimbursement requests. Additional training of management should occur to ensure they fully understand all compliance regulations and have the skills to assist in designing and implementing effective controls. Monitoring of the control procedures related to the grant accounting and reimbursement request should be performed regularly to ensure reports are filed accurately and timely. Information and communication regarding identified weaknesses and opportunities to improve the policies and procedures should occur among management and the individual performing the monitoring of the procedures. District's Response: The District’s Finance Manager and District Manager are working towards using general ledger reporting exclusively for reimbursement request reporting. General ledger activity became more timely as improvements were implemented based on prior year findings. Management acknowledges delays in that pro-cess that continued as a result, to some extent, of the use of the self-developed spreadsheet reports then used for completing grant reimbursement requests. Corrective Action Plan: The District’s Finance Manager will continue to make improvements in general ledg-er recording and reporting systems so that those reports can then be used without intermediary report methods to prepare reimbursement request forms. Review of the reimbursement requests will take place within data re-ports generated directly from the general ledger. The district will engage an individual or firm to ensure that the timing and overall processes related to grant reimbursement and reporting does not result in reporting errors or omissions. . Planned Implementation Date: September 30, 2024 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2023-002 - Source Documentation (Significant Deficiency) CFDA Title and Number: 20.513 (5310) Enhanced Mobility of Seniors and Individuals with Disabilities. Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Management CFDA Title and Number: 20.509 (5311) CARES 5311 Operating Assistance. Formula Grants for Rural. 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 disclosure of the fi-nancial results of each Federal award or program in accordance with the reporting requirements set forth in 200.328 and 200.329. Condition: The District prepared reimbursement calculations according to an internally developed spreadsheet tool, rather than using amounts directly obtained from the general ledger and supporting documentation Cause: General ledger data used to prepare spreadsheets, then used to complete reimbursement requests added unnecessary complexity and potential for errors in the reimbursement and request and grant reporting process. Internal control procedures assuring accurate and timely review of reports and filing of the reimbursement re-quests were not designed or implemented. Effect or Potential Effect: The lack of effective internal control activities over financial reporting could allow for inadvertent errors, such as calculation errors, payments for unauthorized purposes, and result in improper grant accounting, reporting, and reimbursement. Questioned Cost: No Context: Internal disputes regarding grant reimbursement request procedures were evident. The weak or nonex-istent controls over the reimbursement request procedures created a potential for inaccurate, incomplete report-ing. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2022-003 Recommendation: The District should continue to improve grant accounting efforts, and establish a more simplified and effective process for the review and approval of grant accounting and reimbursement requests. Additional training of management should occur to ensure they fully understand all compliance regulations and have the skills to assist in designing and implementing effective controls. Monitoring of the control procedures related to the grant accounting and reimbursement request should be performed regularly to ensure reports are filed accurately and timely. Information and communication regarding identified weaknesses and opportunities to improve the policies and procedures should occur among management and the individual performing the monitoring of the procedures. District's Response: The District’s Finance Manager and District Manager are working towards using general ledger reporting exclusively for reimbursement request reporting. General ledger activity became more timely as improvements were implemented based on prior year findings. Management acknowledges delays in that pro-cess that continued as a result, to some extent, of the use of the self-developed spreadsheet reports then used for completing grant reimbursement requests. Corrective Action Plan: The District’s Finance Manager will continue to make improvements in general ledg-er recording and reporting systems so that those reports can then be used without intermediary report methods to prepare reimbursement request forms. Review of the reimbursement requests will take place within data re-ports generated directly from the general ledger. The district will engage an individual or firm to ensure that the timing and overall processes related to grant reimbursement and reporting does not result in reporting errors or omissions. . Planned Implementation Date: September 30, 2024 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2023-002 - Source Documentation (Significant Deficiency) CFDA Title and Number: 20.513 (5310) Enhanced Mobility of Seniors and Individuals with Disabilities. Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Management CFDA Title and Number: 20.509 (5311) CARES 5311 Operating Assistance. Formula Grants for Rural. 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 disclosure of the fi-nancial results of each Federal award or program in accordance with the reporting requirements set forth in 200.328 and 200.329. Condition: The District prepared reimbursement calculations according to an internally developed spreadsheet tool, rather than using amounts directly obtained from the general ledger and supporting documentation Cause: General ledger data used to prepare spreadsheets, then used to complete reimbursement requests added unnecessary complexity and potential for errors in the reimbursement and request and grant reporting process. Internal control procedures assuring accurate and timely review of reports and filing of the reimbursement re-quests were not designed or implemented. Effect or Potential Effect: The lack of effective internal control activities over financial reporting could allow for inadvertent errors, such as calculation errors, payments for unauthorized purposes, and result in improper grant accounting, reporting, and reimbursement. Questioned Cost: No Context: Internal disputes regarding grant reimbursement request procedures were evident. The weak or nonex-istent controls over the reimbursement request procedures created a potential for inaccurate, incomplete report-ing. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2022-003 Recommendation: The District should continue to improve grant accounting efforts, and establish a more simplified and effective process for the review and approval of grant accounting and reimbursement requests. Additional training of management should occur to ensure they fully understand all compliance regulations and have the skills to assist in designing and implementing effective controls. Monitoring of the control procedures related to the grant accounting and reimbursement request should be performed regularly to ensure reports are filed accurately and timely. Information and communication regarding identified weaknesses and opportunities to improve the policies and procedures should occur among management and the individual performing the monitoring of the procedures. District's Response: The District’s Finance Manager and District Manager are working towards using general ledger reporting exclusively for reimbursement request reporting. General ledger activity became more timely as improvements were implemented based on prior year findings. Management acknowledges delays in that pro-cess that continued as a result, to some extent, of the use of the self-developed spreadsheet reports then used for completing grant reimbursement requests. Corrective Action Plan: The District’s Finance Manager will continue to make improvements in general ledg-er recording and reporting systems so that those reports can then be used without intermediary report methods to prepare reimbursement request forms. Review of the reimbursement requests will take place within data re-ports generated directly from the general ledger. The district will engage an individual or firm to ensure that the timing and overall processes related to grant reimbursement and reporting does not result in reporting errors or omissions. . Planned Implementation Date: September 30, 2024 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2023-002 - Source Documentation (Significant Deficiency) CFDA Title and Number: 20.513 (5310) Enhanced Mobility of Seniors and Individuals with Disabilities. Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Management CFDA Title and Number: 20.509 (5311) CARES 5311 Operating Assistance. Formula Grants for Rural. 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 disclosure of the fi-nancial results of each Federal award or program in accordance with the reporting requirements set forth in 200.328 and 200.329. Condition: The District prepared reimbursement calculations according to an internally developed spreadsheet tool, rather than using amounts directly obtained from the general ledger and supporting documentation Cause: General ledger data used to prepare spreadsheets, then used to complete reimbursement requests added unnecessary complexity and potential for errors in the reimbursement and request and grant reporting process. Internal control procedures assuring accurate and timely review of reports and filing of the reimbursement re-quests were not designed or implemented. Effect or Potential Effect: The lack of effective internal control activities over financial reporting could allow for inadvertent errors, such as calculation errors, payments for unauthorized purposes, and result in improper grant accounting, reporting, and reimbursement. Questioned Cost: No Context: Internal disputes regarding grant reimbursement request procedures were evident. The weak or nonex-istent controls over the reimbursement request procedures created a potential for inaccurate, incomplete report-ing. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2022-003 Recommendation: The District should continue to improve grant accounting efforts, and establish a more simplified and effective process for the review and approval of grant accounting and reimbursement requests. Additional training of management should occur to ensure they fully understand all compliance regulations and have the skills to assist in designing and implementing effective controls. Monitoring of the control procedures related to the grant accounting and reimbursement request should be performed regularly to ensure reports are filed accurately and timely. Information and communication regarding identified weaknesses and opportunities to improve the policies and procedures should occur among management and the individual performing the monitoring of the procedures. District's Response: The District’s Finance Manager and District Manager are working towards using general ledger reporting exclusively for reimbursement request reporting. General ledger activity became more timely as improvements were implemented based on prior year findings. Management acknowledges delays in that pro-cess that continued as a result, to some extent, of the use of the self-developed spreadsheet reports then used for completing grant reimbursement requests. Corrective Action Plan: The District’s Finance Manager will continue to make improvements in general ledg-er recording and reporting systems so that those reports can then be used without intermediary report methods to prepare reimbursement request forms. Review of the reimbursement requests will take place within data re-ports generated directly from the general ledger. The district will engage an individual or firm to ensure that the timing and overall processes related to grant reimbursement and reporting does not result in reporting errors or omissions. . Planned Implementation Date: September 30, 2024 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2023-002 - Source Documentation (Significant Deficiency) CFDA Title and Number: 20.513 (5310) Enhanced Mobility of Seniors and Individuals with Disabilities. Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Management CFDA Title and Number: 20.509 (5311) CARES 5311 Operating Assistance. Formula Grants for Rural. 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 disclosure of the fi-nancial results of each Federal award or program in accordance with the reporting requirements set forth in 200.328 and 200.329. Condition: The District prepared reimbursement calculations according to an internally developed spreadsheet tool, rather than using amounts directly obtained from the general ledger and supporting documentation Cause: General ledger data used to prepare spreadsheets, then used to complete reimbursement requests added unnecessary complexity and potential for errors in the reimbursement and request and grant reporting process. Internal control procedures assuring accurate and timely review of reports and filing of the reimbursement re-quests were not designed or implemented. Effect or Potential Effect: The lack of effective internal control activities over financial reporting could allow for inadvertent errors, such as calculation errors, payments for unauthorized purposes, and result in improper grant accounting, reporting, and reimbursement. Questioned Cost: No Context: Internal disputes regarding grant reimbursement request procedures were evident. The weak or nonex-istent controls over the reimbursement request procedures created a potential for inaccurate, incomplete report-ing. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2022-003 Recommendation: The District should continue to improve grant accounting efforts, and establish a more simplified and effective process for the review and approval of grant accounting and reimbursement requests. Additional training of management should occur to ensure they fully understand all compliance regulations and have the skills to assist in designing and implementing effective controls. Monitoring of the control procedures related to the grant accounting and reimbursement request should be performed regularly to ensure reports are filed accurately and timely. Information and communication regarding identified weaknesses and opportunities to improve the policies and procedures should occur among management and the individual performing the monitoring of the procedures. District's Response: The District’s Finance Manager and District Manager are working towards using general ledger reporting exclusively for reimbursement request reporting. General ledger activity became more timely as improvements were implemented based on prior year findings. Management acknowledges delays in that pro-cess that continued as a result, to some extent, of the use of the self-developed spreadsheet reports then used for completing grant reimbursement requests. Corrective Action Plan: The District’s Finance Manager will continue to make improvements in general ledg-er recording and reporting systems so that those reports can then be used without intermediary report methods to prepare reimbursement request forms. Review of the reimbursement requests will take place within data re-ports generated directly from the general ledger. The district will engage an individual or firm to ensure that the timing and overall processes related to grant reimbursement and reporting does not result in reporting errors or omissions. . Planned Implementation Date: September 30, 2024 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2023-003 – Fiscal Management System (Material Weakness) Criteria: CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial management 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, current, and complete disclosure of the financial results of each Federal award or program. Condition: The District prepared reimbursement calculations according to an internally developed spreadsheet tool, rather than using amounts directly obtained from the general ledger and supporting documentation. The reimbursement reports were to be reviewed by the District Manager prior to submission. Approval of the reimbursement requests and supporting reports by the District Manager were often delayed. Cause: General ledger data used to prepare spreadsheets, then used to complete reimbursement requests added unnecessary complexity and potential for errors in the reimbursement and request and grant reporting process. Internal control procedures assuring timely review of reports and filing of the reimbursement requests were not designed or implemented. Effect or Potential Effect: The lack of effective internal control activities over financial reporting could allow for inadvertent errors, such as calculation errors, payments for unauthorized purposes, and result in improper financial reporting. Lack of timely filing of reimbursement requests could result in overstating accounts receivable balances and critical revenues lost due to cutoff terms of the grant award. Questioned Cost: No Context: Delays in filing reimbursement claims and internal disputes regarding grant reimbursement request procedures were evident. The weak or nonexistent controls over the reimbursement request procedures resulted in lost revenues and delayed recognition of revenue, which required adjustments to correct the financial statements. Repeat of a Prior-Year Finding: Yes, Financial Statement Findings 2022-001 Recommendation: The District should establish a more simplified and effective process for the review and approval of GAAP basis reporting and grant reimbursement requests and grant reporting. As part of this process, supporting general ledger reports and supporting data should be subject to a qualified individual to review and approval on a timely basis. Monitoring of the control procedures related to the grant accounting and reimbursement request should be performed regularly to ensure reports are filed accurately and timely. Information and communication regarding identified weaknesses and opportunities to improve the policies and procedures should occur among management and the individual performing the monitoring of the procedures. District's Response: The District’s Finance Manager and District Manager are working towards using general ledger reporting exclusively for reimbursement request reporting. General ledger activity became more timely as improvements were implemented based on prior year findings. Management acknowledges delays in that process that continued as a result, to some extent, of the use of the self-developed spreadsheet reports then used for completing grant reimbursement requests. Corrective Action Plan: The District’s Finance Manager will continue to make improvements in general ledger recording and reporting systems so that those reports can then be used without intermediary report methods to prepare reimbursement request forms. Review of the reimbursement requests will take place within data reports generated directly from the general ledger. The district will engage an individual or firm to ensure that the timing and overall processes related to grant reimbursement and reporting does not result in reporting errors or omissions. Planned Implementation Date: September 30, 2024 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2023-003 – Fiscal Management System (Material Weakness) Criteria: CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial management 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, current, and complete disclosure of the financial results of each Federal award or program. Condition: The District prepared reimbursement calculations according to an internally developed spreadsheet tool, rather than using amounts directly obtained from the general ledger and supporting documentation. The reimbursement reports were to be reviewed by the District Manager prior to submission. Approval of the reimbursement requests and supporting reports by the District Manager were often delayed. Cause: General ledger data used to prepare spreadsheets, then used to complete reimbursement requests added unnecessary complexity and potential for errors in the reimbursement and request and grant reporting process. Internal control procedures assuring timely review of reports and filing of the reimbursement requests were not designed or implemented. Effect or Potential Effect: The lack of effective internal control activities over financial reporting could allow for inadvertent errors, such as calculation errors, payments for unauthorized purposes, and result in improper financial reporting. Lack of timely filing of reimbursement requests could result in overstating accounts receivable balances and critical revenues lost due to cutoff terms of the grant award. Questioned Cost: No Context: Delays in filing reimbursement claims and internal disputes regarding grant reimbursement request procedures were evident. The weak or nonexistent controls over the reimbursement request procedures resulted in lost revenues and delayed recognition of revenue, which required adjustments to correct the financial statements. Repeat of a Prior-Year Finding: Yes, Financial Statement Findings 2022-001 Recommendation: The District should establish a more simplified and effective process for the review and approval of GAAP basis reporting and grant reimbursement requests and grant reporting. As part of this process, supporting general ledger reports and supporting data should be subject to a qualified individual to review and approval on a timely basis. Monitoring of the control procedures related to the grant accounting and reimbursement request should be performed regularly to ensure reports are filed accurately and timely. Information and communication regarding identified weaknesses and opportunities to improve the policies and procedures should occur among management and the individual performing the monitoring of the procedures. District's Response: The District’s Finance Manager and District Manager are working towards using general ledger reporting exclusively for reimbursement request reporting. General ledger activity became more timely as improvements were implemented based on prior year findings. Management acknowledges delays in that process that continued as a result, to some extent, of the use of the self-developed spreadsheet reports then used for completing grant reimbursement requests. Corrective Action Plan: The District’s Finance Manager will continue to make improvements in general ledger recording and reporting systems so that those reports can then be used without intermediary report methods to prepare reimbursement request forms. Review of the reimbursement requests will take place within data reports generated directly from the general ledger. The district will engage an individual or firm to ensure that the timing and overall processes related to grant reimbursement and reporting does not result in reporting errors or omissions. Planned Implementation Date: September 30, 2024 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2023-003 – Fiscal Management System (Material Weakness) Criteria: CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial management 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, current, and complete disclosure of the financial results of each Federal award or program. Condition: The District prepared reimbursement calculations according to an internally developed spreadsheet tool, rather than using amounts directly obtained from the general ledger and supporting documentation. The reimbursement reports were to be reviewed by the District Manager prior to submission. Approval of the reimbursement requests and supporting reports by the District Manager were often delayed. Cause: General ledger data used to prepare spreadsheets, then used to complete reimbursement requests added unnecessary complexity and potential for errors in the reimbursement and request and grant reporting process. Internal control procedures assuring timely review of reports and filing of the reimbursement requests were not designed or implemented. Effect or Potential Effect: The lack of effective internal control activities over financial reporting could allow for inadvertent errors, such as calculation errors, payments for unauthorized purposes, and result in improper financial reporting. Lack of timely filing of reimbursement requests could result in overstating accounts receivable balances and critical revenues lost due to cutoff terms of the grant award. Questioned Cost: No Context: Delays in filing reimbursement claims and internal disputes regarding grant reimbursement request procedures were evident. The weak or nonexistent controls over the reimbursement request procedures resulted in lost revenues and delayed recognition of revenue, which required adjustments to correct the financial statements. Repeat of a Prior-Year Finding: Yes, Financial Statement Findings 2022-001 Recommendation: The District should establish a more simplified and effective process for the review and approval of GAAP basis reporting and grant reimbursement requests and grant reporting. As part of this process, supporting general ledger reports and supporting data should be subject to a qualified individual to review and approval on a timely basis. Monitoring of the control procedures related to the grant accounting and reimbursement request should be performed regularly to ensure reports are filed accurately and timely. Information and communication regarding identified weaknesses and opportunities to improve the policies and procedures should occur among management and the individual performing the monitoring of the procedures. District's Response: The District’s Finance Manager and District Manager are working towards using general ledger reporting exclusively for reimbursement request reporting. General ledger activity became more timely as improvements were implemented based on prior year findings. Management acknowledges delays in that process that continued as a result, to some extent, of the use of the self-developed spreadsheet reports then used for completing grant reimbursement requests. Corrective Action Plan: The District’s Finance Manager will continue to make improvements in general ledger recording and reporting systems so that those reports can then be used without intermediary report methods to prepare reimbursement request forms. Review of the reimbursement requests will take place within data reports generated directly from the general ledger. The district will engage an individual or firm to ensure that the timing and overall processes related to grant reimbursement and reporting does not result in reporting errors or omissions. Planned Implementation Date: September 30, 2024 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2023-003 – Fiscal Management System (Material Weakness) Criteria: CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial management 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, current, and complete disclosure of the financial results of each Federal award or program. Condition: The District prepared reimbursement calculations according to an internally developed spreadsheet tool, rather than using amounts directly obtained from the general ledger and supporting documentation. The reimbursement reports were to be reviewed by the District Manager prior to submission. Approval of the reimbursement requests and supporting reports by the District Manager were often delayed. Cause: General ledger data used to prepare spreadsheets, then used to complete reimbursement requests added unnecessary complexity and potential for errors in the reimbursement and request and grant reporting process. Internal control procedures assuring timely review of reports and filing of the reimbursement requests were not designed or implemented. Effect or Potential Effect: The lack of effective internal control activities over financial reporting could allow for inadvertent errors, such as calculation errors, payments for unauthorized purposes, and result in improper financial reporting. Lack of timely filing of reimbursement requests could result in overstating accounts receivable balances and critical revenues lost due to cutoff terms of the grant award. Questioned Cost: No Context: Delays in filing reimbursement claims and internal disputes regarding grant reimbursement request procedures were evident. The weak or nonexistent controls over the reimbursement request procedures resulted in lost revenues and delayed recognition of revenue, which required adjustments to correct the financial statements. Repeat of a Prior-Year Finding: Yes, Financial Statement Findings 2022-001 Recommendation: The District should establish a more simplified and effective process for the review and approval of GAAP basis reporting and grant reimbursement requests and grant reporting. As part of this process, supporting general ledger reports and supporting data should be subject to a qualified individual to review and approval on a timely basis. Monitoring of the control procedures related to the grant accounting and reimbursement request should be performed regularly to ensure reports are filed accurately and timely. Information and communication regarding identified weaknesses and opportunities to improve the policies and procedures should occur among management and the individual performing the monitoring of the procedures. District's Response: The District’s Finance Manager and District Manager are working towards using general ledger reporting exclusively for reimbursement request reporting. General ledger activity became more timely as improvements were implemented based on prior year findings. Management acknowledges delays in that process that continued as a result, to some extent, of the use of the self-developed spreadsheet reports then used for completing grant reimbursement requests. Corrective Action Plan: The District’s Finance Manager will continue to make improvements in general ledger recording and reporting systems so that those reports can then be used without intermediary report methods to prepare reimbursement request forms. Review of the reimbursement requests will take place within data reports generated directly from the general ledger. The district will engage an individual or firm to ensure that the timing and overall processes related to grant reimbursement and reporting does not result in reporting errors or omissions. Planned Implementation Date: September 30, 2024 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2023-003 – Fiscal Management System (Material Weakness) Criteria: CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial management 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, current, and complete disclosure of the financial results of each Federal award or program. Condition: The District prepared reimbursement calculations according to an internally developed spreadsheet tool, rather than using amounts directly obtained from the general ledger and supporting documentation. The reimbursement reports were to be reviewed by the District Manager prior to submission. Approval of the reimbursement requests and supporting reports by the District Manager were often delayed. Cause: General ledger data used to prepare spreadsheets, then used to complete reimbursement requests added unnecessary complexity and potential for errors in the reimbursement and request and grant reporting process. Internal control procedures assuring timely review of reports and filing of the reimbursement requests were not designed or implemented. Effect or Potential Effect: The lack of effective internal control activities over financial reporting could allow for inadvertent errors, such as calculation errors, payments for unauthorized purposes, and result in improper financial reporting. Lack of timely filing of reimbursement requests could result in overstating accounts receivable balances and critical revenues lost due to cutoff terms of the grant award. Questioned Cost: No Context: Delays in filing reimbursement claims and internal disputes regarding grant reimbursement request procedures were evident. The weak or nonexistent controls over the reimbursement request procedures resulted in lost revenues and delayed recognition of revenue, which required adjustments to correct the financial statements. Repeat of a Prior-Year Finding: Yes, Financial Statement Findings 2022-001 Recommendation: The District should establish a more simplified and effective process for the review and approval of GAAP basis reporting and grant reimbursement requests and grant reporting. As part of this process, supporting general ledger reports and supporting data should be subject to a qualified individual to review and approval on a timely basis. Monitoring of the control procedures related to the grant accounting and reimbursement request should be performed regularly to ensure reports are filed accurately and timely. Information and communication regarding identified weaknesses and opportunities to improve the policies and procedures should occur among management and the individual performing the monitoring of the procedures. District's Response: The District’s Finance Manager and District Manager are working towards using general ledger reporting exclusively for reimbursement request reporting. General ledger activity became more timely as improvements were implemented based on prior year findings. Management acknowledges delays in that process that continued as a result, to some extent, of the use of the self-developed spreadsheet reports then used for completing grant reimbursement requests. Corrective Action Plan: The District’s Finance Manager will continue to make improvements in general ledger recording and reporting systems so that those reports can then be used without intermediary report methods to prepare reimbursement request forms. Review of the reimbursement requests will take place within data reports generated directly from the general ledger. The district will engage an individual or firm to ensure that the timing and overall processes related to grant reimbursement and reporting does not result in reporting errors or omissions. Planned Implementation Date: September 30, 2024 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2023-003 – Fiscal Management System (Material Weakness) Criteria: CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial management 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, current, and complete disclosure of the financial results of each Federal award or program. Condition: The District prepared reimbursement calculations according to an internally developed spreadsheet tool, rather than using amounts directly obtained from the general ledger and supporting documentation. The reimbursement reports were to be reviewed by the District Manager prior to submission. Approval of the reimbursement requests and supporting reports by the District Manager were often delayed. Cause: General ledger data used to prepare spreadsheets, then used to complete reimbursement requests added unnecessary complexity and potential for errors in the reimbursement and request and grant reporting process. Internal control procedures assuring timely review of reports and filing of the reimbursement requests were not designed or implemented. Effect or Potential Effect: The lack of effective internal control activities over financial reporting could allow for inadvertent errors, such as calculation errors, payments for unauthorized purposes, and result in improper financial reporting. Lack of timely filing of reimbursement requests could result in overstating accounts receivable balances and critical revenues lost due to cutoff terms of the grant award. Questioned Cost: No Context: Delays in filing reimbursement claims and internal disputes regarding grant reimbursement request procedures were evident. The weak or nonexistent controls over the reimbursement request procedures resulted in lost revenues and delayed recognition of revenue, which required adjustments to correct the financial statements. Repeat of a Prior-Year Finding: Yes, Financial Statement Findings 2022-001 Recommendation: The District should establish a more simplified and effective process for the review and approval of GAAP basis reporting and grant reimbursement requests and grant reporting. As part of this process, supporting general ledger reports and supporting data should be subject to a qualified individual to review and approval on a timely basis. Monitoring of the control procedures related to the grant accounting and reimbursement request should be performed regularly to ensure reports are filed accurately and timely. Information and communication regarding identified weaknesses and opportunities to improve the policies and procedures should occur among management and the individual performing the monitoring of the procedures. District's Response: The District’s Finance Manager and District Manager are working towards using general ledger reporting exclusively for reimbursement request reporting. General ledger activity became more timely as improvements were implemented based on prior year findings. Management acknowledges delays in that process that continued as a result, to some extent, of the use of the self-developed spreadsheet reports then used for completing grant reimbursement requests. Corrective Action Plan: The District’s Finance Manager will continue to make improvements in general ledger recording and reporting systems so that those reports can then be used without intermediary report methods to prepare reimbursement request forms. Review of the reimbursement requests will take place within data reports generated directly from the general ledger. The district will engage an individual or firm to ensure that the timing and overall processes related to grant reimbursement and reporting does not result in reporting errors or omissions. Planned Implementation Date: September 30, 2024 Responsible Person: General Manager, Umpqua Public Transit District
Finding 2023-003 – Fiscal Management System (Material Weakness) Criteria: CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial management 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, current, and complete disclosure of the financial results of each Federal award or program. Condition: The District prepared reimbursement calculations according to an internally developed spreadsheet tool, rather than using amounts directly obtained from the general ledger and supporting documentation. The reimbursement reports were to be reviewed by the District Manager prior to submission. Approval of the reimbursement requests and supporting reports by the District Manager were often delayed. Cause: General ledger data used to prepare spreadsheets, then used to complete reimbursement requests added unnecessary complexity and potential for errors in the reimbursement and request and grant reporting process. Internal control procedures assuring timely review of reports and filing of the reimbursement requests were not designed or implemented. Effect or Potential Effect: The lack of effective internal control activities over financial reporting could allow for inadvertent errors, such as calculation errors, payments for unauthorized purposes, and result in improper financial reporting. Lack of timely filing of reimbursement requests could result in overstating accounts receivable balances and critical revenues lost due to cutoff terms of the grant award. Questioned Cost: No Context: Delays in filing reimbursement claims and internal disputes regarding grant reimbursement request procedures were evident. The weak or nonexistent controls over the reimbursement request procedures resulted in lost revenues and delayed recognition of revenue, which required adjustments to correct the financial statements. Repeat of a Prior-Year Finding: Yes, Financial Statement Findings 2022-001 Recommendation: The District should establish a more simplified and effective process for the review and approval of GAAP basis reporting and grant reimbursement requests and grant reporting. As part of this process, supporting general ledger reports and supporting data should be subject to a qualified individual to review and approval on a timely basis. Monitoring of the control procedures related to the grant accounting and reimbursement request should be performed regularly to ensure reports are filed accurately and timely. Information and communication regarding identified weaknesses and opportunities to improve the policies and procedures should occur among management and the individual performing the monitoring of the procedures. District's Response: The District’s Finance Manager and District Manager are working towards using general ledger reporting exclusively for reimbursement request reporting. General ledger activity became more timely as improvements were implemented based on prior year findings. Management acknowledges delays in that process that continued as a result, to some extent, of the use of the self-developed spreadsheet reports then used for completing grant reimbursement requests. Corrective Action Plan: The District’s Finance Manager will continue to make improvements in general ledger recording and reporting systems so that those reports can then be used without intermediary report methods to prepare reimbursement request forms. Review of the reimbursement requests will take place within data reports generated directly from the general ledger. The district will engage an individual or firm to ensure that the timing and overall processes related to grant reimbursement and reporting does not result in reporting errors or omissions. Planned Implementation Date: September 30, 2024 Responsible Person: General Manager, Umpqua Public Transit District
Finding Reference 2023-005 Federal Agency: U.S. Department of Homeland Security Pass-Through Agency: Central Office of Recovery, Reconstruction and Resiliency of Puerto Rico (COR3) Program: Disaster Grants – Public Assistance (Presidentially Declared Disaster) (ALN 97.036) Compliance Requirement: Reporting (L) Type of Finding: Significant Deficiency in Internal Controls (SD), Instance of Noncompliance (NC) Statement of Condition In our Reporting Test, we evaluated the Quarterly Progress Reports of a total of nine (9) projects for two quarters of fiscal year 2022-2023. During our audit procedures, we noted that the reports did not agree with the accounting and project records. Criteria 2 CFR 200.302 (a) stated that the state’s and the other non-Federal entity’s financial management system, 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, 2 CFR 200.302 (b) (2) states that the financial management system of each non-Federal entity must provide 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 of Condition The Municipality accounting controls and procedures fail to ensure accurate, current and complete disclosure of the financial results of federal assisted activities. Effect of Condition The expenses reported in the Quarterly Progress Reports do not agree with the accounting records. Recommendation We recommend that Program Administrators to reconcile the differences between the quarterly report and the accounting records before the submission of the next submission to the pass-through entity. Questioned Cost None Prior Year Finding No Views of Responsible Officials and Planned Corrective Action We concur with the finding. Quarterly Progress Reports for large projects will be prospectively adjusted to reflect expenditures incurred over the reporting period Implementation Date: March 31, 2025 Responsible Person: Belinda Álvarez Finance Director
2023-002 Incorrect Allocation of Program Expense and Inadequate Documentation Program Name/ Assistance Listing Number: 93. 959 Block Grants for Prevention and Treatment of Substance Abuse Federal Agency: Department of Health and Human Services Federal Award Identification: Unknown Type of Finding: Material Weakness Compliance Requirement: Allowable Costs/Cost Principles Criteria: According to 2 CFR §200.302, entities receiving federal funds must have effective internal controls over the use of funds to ensure compliance with federal statutes, regulations, and the terms and conditions of the federal award. Furthermore, 2 CFR §200.403 states that costs must be adequately documented and be allocable to the respective federal award to be considered allowable. Condition: During the testing of 60 expense transactions, the auditor identified the following exceptions: - 5 transactions were allocated to the incorrect grant. - 3 transactions were assigned to the incorrect expense program. - 4 transactions lacked the required invoice and payment approval documentation as per the organization’s internal controls. Cause of Condition: The identified issues likely stem from a lack of adherence to established internal control procedures and inadequate oversight or training regarding the correct allocation of expenses. Additionally, there may be deficiencies in the document retention process, leading to incomplete records. Effect: The misallocation of expenses could result in non-compliance with the terms and conditions of federal grants, leading to potential questioned costs and the need for reimbursement of funds. The lack of supporting documentation further increases the risk of noncompliance and reduces the audit trail, which could impair the organization’s ability to justify its use of federal funds. Questioned Cost: $24,464 Recommendation: The organization should reinforce its internal controls over expense allocation and documentation retention by providing additional training to staff involved in the financial management of grants. Implementing periodic reviews and reconciliations of grant allocations and ensuring that all supporting documentation is complete and properly filed will help mitigate the risk of misallocations and incomplete records in the future. Description of the Nature and Extent of Issues Reported: We consider the following materiality for consideration of material noncompliance for the major program 93.959 at 5% of the total awards expended amounting to $51,253. View of Responsible Official: Management agrees with the finding and will implement corrective action.
2023-004 Late Submission of and Discrepancies within Final Expenditure Reports Program Name/ Assistance Listing Number: 93. 959 Block Grants for Prevention and Treatment of Substance Abuse Federal Agency: Department of Health and Human Services Federal Award Identification: Unknown Type of Finding: Material Weakness Compliance Requirement: Reporting Criteria: According to 2 CFR §200.302, entities that receive federal awards must have accurate financial management systems that allow for the preparation of reports that reflect accurate, current, and complete disclosure of financial results. Additionally, 2 CFR §200.415(a) requires that financial reports must be based on the accounting records and accurately reflect the actual expenditures incurred. Furthermore, 2 CFR §200.328(b)(1) states that federal grant recipients are required to submit performance and financial reports within 90 days following the end of the grant period, unless an extension has been granted by the funding agency. Timely submission of these reports is essential to demonstrate compliance with grant terms and conditions. Condition: The auditor noted that certain expenditures in the final expenditures report submitted by the Organization exceeded the actual expenditures recorded in the general ledger and/or exceeded the grant budget. In addition, the auditor also noted that final reports were submitted to funding sources at least 5 months (150 days) after the end of the grant period. This suggests that Cleveland UMADAOP did not submit the reports within the required timeframe and may not have an effective process in place to track and meet reporting deadlines. Cause of Condition: The discrepancies appear to be the result of inadequate reconciliation processes between the general ledger and the financial reports. This may have been compounded by the misunderstanding of reporting requirements, leading to the inclusion of inaccurate figures in the final expenditures report. In addition, the late submission of final reports appears to result from the absence of a robust process for monitoring and tracking reporting deadlines. This may also indicate inadequate internal controls or insufficient staffing dedicated to managing grant compliance and reporting responsibilities. Effect: Reporting expenditures in excess of actual amounts may lead to non-compliance with federal grant requirements, and could result in questioned costs and potential disallowance of funds. Moreover, such inaccuracies undermine the reliability of financial reports and could impair the organization’s credibility with federal agencies and other stakeholders. In addition, failure to submit timely reports can lead to non-compliance with grant agreements, which may result in funding delays, penalties, or even the potential loss of future funding opportunities. Furthermore, late submissions may strain relationships with funding sources and damage the Organization’s reputation. Questioned Cost: $114,860 Recommendation: Cleveland UMADAOP should enhance its reconciliation procedures to ensure that reported expenditures accurately reflect actual amounts spent as recorded in the general ledger. Implementing a robust review process prior to the submission of final expenditure reports will help prevent discrepancies and ensure compliance with federal grant requirements. Additionally, the Organization should implement a formal process to track and monitor all reporting deadlines associated with its grants. This process could include a centralized calendar, regular reminders, and a designated individual or team responsible for ensuring that all reports are completed and submitted on time. Additionally, the Organization should consider conducting training for staff involved in grant management and financial reporting to reinforce the importance of adhering to reporting deadlines andcompliance to requirements. Description of the Nature and Extent of Issues Reported: We consider the following materiality for consideration of materialnoncompliance for the major program 93.959 at 5% of the totalawards expended amounting to $51,253. View of Responsible Official: Management agrees with the finding and will implement corrective action.
Finding 2023-004 Internal Control Over Allowable Activities/Allowable Costs – Payroll Expenditures Identification of the Federal Programs: Assistance Listing Number: 20.507 Assistance Listing Title: Federal Transit Cluster Federal Agency: U.S. Department of Transportation Pass-Through Entity: N/A Federal Award Identification Number: CA-2017-149-00; CA-90-Z085-00; CA-90-Y974-00; CA -2019- 033-00; CA -90-Y900-00; CA-2020-177-00; CA-2021-169-01; CA-2022-041-00; CA-2021-075-00 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): In accordance with 2 CFR §200.303 Internal Controls, the non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Under §200.302 Financial Management, (b) (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, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Under §200.430(i) Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity. Condition: During the audit, we reviewed payroll period ended September 24, 2022, December 17, 2022, February 25, 2023, and April 22, 2023. Except for the payroll period ended April 22, 2023, we could not verify if the Bus Operators’ and all other Federal Transit employee’s timecards were approved by their supervisors. The timecard reports were uploaded from the time entry system to the payroll module by the supervisors; however, there were no records on who reviewed the timecard reports or who completed the upload of the timecard reports to the payroll module. Cause: Although the City has been working on implementing the necessary approvals, these efforts had not taken full effect for the most part of the fiscal year 2023 until April 2023. Effect or Potential Effect: Without review or approval of time cards, inaccurate payroll expenditures could be charged to the federal programs. Questioned Costs: None noted. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: 2022-007. Recommendation: We recommend that the City ensure the full implementation and consistent application of the established timecard approval policies for all Federal Transit employees and strengthen its monitoring mechanisms to verify that supervisors review and approve timecards for every payroll period, ensuring compliance with the policies throughout the entire fiscal year. Views of Responsible Officials: The City has implemented the recommendation first contained in 2022-007. There is a process in place where supervisor review and approval of timesheets is completed and documented. That process continues and will be in place for the entirety of the fiscal year ending June 30, 2024.
Finding 2023-004 Internal Control Over Allowable Activities/Allowable Costs – Payroll Expenditures Identification of the Federal Programs: Assistance Listing Number: 20.507 Assistance Listing Title: Federal Transit Cluster Federal Agency: U.S. Department of Transportation Pass-Through Entity: N/A Federal Award Identification Number: CA-2017-149-00; CA-90-Z085-00; CA-90-Y974-00; CA -2019- 033-00; CA -90-Y900-00; CA-2020-177-00; CA-2021-169-01; CA-2022-041-00; CA-2021-075-00 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): In accordance with 2 CFR §200.303 Internal Controls, the non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Under §200.302 Financial Management, (b) (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, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Under §200.430(i) Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity. Condition: During the audit, we reviewed payroll period ended September 24, 2022, December 17, 2022, February 25, 2023, and April 22, 2023. Except for the payroll period ended April 22, 2023, we could not verify if the Bus Operators’ and all other Federal Transit employee’s timecards were approved by their supervisors. The timecard reports were uploaded from the time entry system to the payroll module by the supervisors; however, there were no records on who reviewed the timecard reports or who completed the upload of the timecard reports to the payroll module. Cause: Although the City has been working on implementing the necessary approvals, these efforts had not taken full effect for the most part of the fiscal year 2023 until April 2023. Effect or Potential Effect: Without review or approval of time cards, inaccurate payroll expenditures could be charged to the federal programs. Questioned Costs: None noted. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: 2022-007. Recommendation: We recommend that the City ensure the full implementation and consistent application of the established timecard approval policies for all Federal Transit employees and strengthen its monitoring mechanisms to verify that supervisors review and approve timecards for every payroll period, ensuring compliance with the policies throughout the entire fiscal year. Views of Responsible Officials: The City has implemented the recommendation first contained in 2022-007. There is a process in place where supervisor review and approval of timesheets is completed and documented. That process continues and will be in place for the entirety of the fiscal year ending June 30, 2024.
Finding 2023-004 Internal Control Over Allowable Activities/Allowable Costs – Payroll Expenditures Identification of the Federal Programs: Assistance Listing Number: 20.507 Assistance Listing Title: Federal Transit Cluster Federal Agency: U.S. Department of Transportation Pass-Through Entity: N/A Federal Award Identification Number: CA-2017-149-00; CA-90-Z085-00; CA-90-Y974-00; CA -2019- 033-00; CA -90-Y900-00; CA-2020-177-00; CA-2021-169-01; CA-2022-041-00; CA-2021-075-00 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): In accordance with 2 CFR §200.303 Internal Controls, the non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Under §200.302 Financial Management, (b) (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, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Under §200.430(i) Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity. Condition: During the audit, we reviewed payroll period ended September 24, 2022, December 17, 2022, February 25, 2023, and April 22, 2023. Except for the payroll period ended April 22, 2023, we could not verify if the Bus Operators’ and all other Federal Transit employee’s timecards were approved by their supervisors. The timecard reports were uploaded from the time entry system to the payroll module by the supervisors; however, there were no records on who reviewed the timecard reports or who completed the upload of the timecard reports to the payroll module. Cause: Although the City has been working on implementing the necessary approvals, these efforts had not taken full effect for the most part of the fiscal year 2023 until April 2023. Effect or Potential Effect: Without review or approval of time cards, inaccurate payroll expenditures could be charged to the federal programs. Questioned Costs: None noted. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: 2022-007. Recommendation: We recommend that the City ensure the full implementation and consistent application of the established timecard approval policies for all Federal Transit employees and strengthen its monitoring mechanisms to verify that supervisors review and approve timecards for every payroll period, ensuring compliance with the policies throughout the entire fiscal year. Views of Responsible Officials: The City has implemented the recommendation first contained in 2022-007. There is a process in place where supervisor review and approval of timesheets is completed and documented. That process continues and will be in place for the entirety of the fiscal year ending June 30, 2024.
Finding 2023-004 Internal Control Over Allowable Activities/Allowable Costs – Payroll Expenditures Identification of the Federal Programs: Assistance Listing Number: 20.507 Assistance Listing Title: Federal Transit Cluster Federal Agency: U.S. Department of Transportation Pass-Through Entity: N/A Federal Award Identification Number: CA-2017-149-00; CA-90-Z085-00; CA-90-Y974-00; CA -2019- 033-00; CA -90-Y900-00; CA-2020-177-00; CA-2021-169-01; CA-2022-041-00; CA-2021-075-00 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): In accordance with 2 CFR §200.303 Internal Controls, the non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Under §200.302 Financial Management, (b) (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, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Under §200.430(i) Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity. Condition: During the audit, we reviewed payroll period ended September 24, 2022, December 17, 2022, February 25, 2023, and April 22, 2023. Except for the payroll period ended April 22, 2023, we could not verify if the Bus Operators’ and all other Federal Transit employee’s timecards were approved by their supervisors. The timecard reports were uploaded from the time entry system to the payroll module by the supervisors; however, there were no records on who reviewed the timecard reports or who completed the upload of the timecard reports to the payroll module. Cause: Although the City has been working on implementing the necessary approvals, these efforts had not taken full effect for the most part of the fiscal year 2023 until April 2023. Effect or Potential Effect: Without review or approval of time cards, inaccurate payroll expenditures could be charged to the federal programs. Questioned Costs: None noted. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: 2022-007. Recommendation: We recommend that the City ensure the full implementation and consistent application of the established timecard approval policies for all Federal Transit employees and strengthen its monitoring mechanisms to verify that supervisors review and approve timecards for every payroll period, ensuring compliance with the policies throughout the entire fiscal year. Views of Responsible Officials: The City has implemented the recommendation first contained in 2022-007. There is a process in place where supervisor review and approval of timesheets is completed and documented. That process continues and will be in place for the entirety of the fiscal year ending June 30, 2024.
Finding 2023-004 Internal Control Over Allowable Activities/Allowable Costs – Payroll Expenditures Identification of the Federal Programs: Assistance Listing Number: 20.507 Assistance Listing Title: Federal Transit Cluster Federal Agency: U.S. Department of Transportation Pass-Through Entity: N/A Federal Award Identification Number: CA-2017-149-00; CA-90-Z085-00; CA-90-Y974-00; CA -2019- 033-00; CA -90-Y900-00; CA-2020-177-00; CA-2021-169-01; CA-2022-041-00; CA-2021-075-00 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): In accordance with 2 CFR §200.303 Internal Controls, the non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Under §200.302 Financial Management, (b) (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, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Under §200.430(i) Standards for Documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity. Condition: During the audit, we reviewed payroll period ended September 24, 2022, December 17, 2022, February 25, 2023, and April 22, 2023. Except for the payroll period ended April 22, 2023, we could not verify if the Bus Operators’ and all other Federal Transit employee’s timecards were approved by their supervisors. The timecard reports were uploaded from the time entry system to the payroll module by the supervisors; however, there were no records on who reviewed the timecard reports or who completed the upload of the timecard reports to the payroll module. Cause: Although the City has been working on implementing the necessary approvals, these efforts had not taken full effect for the most part of the fiscal year 2023 until April 2023. Effect or Potential Effect: Without review or approval of time cards, inaccurate payroll expenditures could be charged to the federal programs. Questioned Costs: None noted. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: 2022-007. Recommendation: We recommend that the City ensure the full implementation and consistent application of the established timecard approval policies for all Federal Transit employees and strengthen its monitoring mechanisms to verify that supervisors review and approve timecards for every payroll period, ensuring compliance with the policies throughout the entire fiscal year. Views of Responsible Officials: The City has implemented the recommendation first contained in 2022-007. There is a process in place where supervisor review and approval of timesheets is completed and documented. That process continues and will be in place for the entirety of the fiscal year ending June 30, 2024.
2023-008 – Inadequate Policies and Procedures (Significant Deficiency in Internal Controls over Compliance) Federal Program Information Federal Award Title and ALN: COVID-19 Coronavirus State and Local Fiscal Recovery Funds, 21.027 Federal Awarding Agency: U.S. Department of the Treasury Federal Award ID Number: N/A Federal Award Year: 2023 Federal Award Title and ALN: Formula Grants for Rural Areas and Tribal Transit Program, 20.509 Federal Awarding Agency: U.S. Department of the Transportation Pass-Through Entity: New Mexico Department of Transportation Federal Award ID Number: N/A Federal Award Year: 2023 Condition - The County does not maintain written procedures as required by 2 CFR 200, Subparts D and E of the Uniform Guidance. Criteria - Per 2 CFR 200.302(b)(6), Financial Management, the financial management system of each non-federal entity must provide the following: Written procedures to implement the requirements of 200.305 Federal Payment. Per 2 CFR 200.302(b)(7), Financial Management, the financial management system of each nonfederal entity must provide the following: Written procedures for determining the allowability of costs in accordance with Subpart E – Cost Principles of this part and the terms and conditions of the Federal award. Cause - The County does not have written procedures for the federal program's financial management requirements. Effect - Not having written procedures for the aforementioned puts the County in direct violation of Federal requirements over Federal programs under the Uniform Guidance, which could result in a loss of programs, funds and/or repayment of federal monies already awarded back to the Federal government. Auditor’s Recommendation - The County should establish the required written procedures for federal monies and have them available to all personnel who work with federal programs. Views of Responsible Officials and Planned Corrective Action – The County will have written procedures for the federal program financial management requirements submitted to the Grant County Board of Commissioners for approval and implemented by all personnel. Responsible Official – Andrea Montoya, Deputy County Manager and Robert Placencio, Finance Director Timeline and Estimated Completion Date – No later than August 31, 2024.
2023-008 – Inadequate Policies and Procedures (Significant Deficiency in Internal Controls over Compliance) Federal Program Information Federal Award Title and ALN: COVID-19 Coronavirus State and Local Fiscal Recovery Funds, 21.027 Federal Awarding Agency: U.S. Department of the Treasury Federal Award ID Number: N/A Federal Award Year: 2023 Federal Award Title and ALN: Formula Grants for Rural Areas and Tribal Transit Program, 20.509 Federal Awarding Agency: U.S. Department of the Transportation Pass-Through Entity: New Mexico Department of Transportation Federal Award ID Number: N/A Federal Award Year: 2023 Condition - The County does not maintain written procedures as required by 2 CFR 200, Subparts D and E of the Uniform Guidance. Criteria - Per 2 CFR 200.302(b)(6), Financial Management, the financial management system of each non-federal entity must provide the following: Written procedures to implement the requirements of 200.305 Federal Payment. Per 2 CFR 200.302(b)(7), Financial Management, the financial management system of each nonfederal entity must provide the following: Written procedures for determining the allowability of costs in accordance with Subpart E – Cost Principles of this part and the terms and conditions of the Federal award. Cause - The County does not have written procedures for the federal program's financial management requirements. Effect - Not having written procedures for the aforementioned puts the County in direct violation of Federal requirements over Federal programs under the Uniform Guidance, which could result in a loss of programs, funds and/or repayment of federal monies already awarded back to the Federal government. Auditor’s Recommendation - The County should establish the required written procedures for federal monies and have them available to all personnel who work with federal programs. Views of Responsible Officials and Planned Corrective Action – The County will have written procedures for the federal program financial management requirements submitted to the Grant County Board of Commissioners for approval and implemented by all personnel. Responsible Official – Andrea Montoya, Deputy County Manager and Robert Placencio, Finance Director Timeline and Estimated Completion Date – No later than August 31, 2024.
2023-008 – Inadequate Policies and Procedures (Significant Deficiency in Internal Controls over Compliance) Federal Program Information Federal Award Title and ALN: COVID-19 Coronavirus State and Local Fiscal Recovery Funds, 21.027 Federal Awarding Agency: U.S. Department of the Treasury Federal Award ID Number: N/A Federal Award Year: 2023 Federal Award Title and ALN: Formula Grants for Rural Areas and Tribal Transit Program, 20.509 Federal Awarding Agency: U.S. Department of the Transportation Pass-Through Entity: New Mexico Department of Transportation Federal Award ID Number: N/A Federal Award Year: 2023 Condition - The County does not maintain written procedures as required by 2 CFR 200, Subparts D and E of the Uniform Guidance. Criteria - Per 2 CFR 200.302(b)(6), Financial Management, the financial management system of each non-federal entity must provide the following: Written procedures to implement the requirements of 200.305 Federal Payment. Per 2 CFR 200.302(b)(7), Financial Management, the financial management system of each nonfederal entity must provide the following: Written procedures for determining the allowability of costs in accordance with Subpart E – Cost Principles of this part and the terms and conditions of the Federal award. Cause - The County does not have written procedures for the federal program's financial management requirements. Effect - Not having written procedures for the aforementioned puts the County in direct violation of Federal requirements over Federal programs under the Uniform Guidance, which could result in a loss of programs, funds and/or repayment of federal monies already awarded back to the Federal government. Auditor’s Recommendation - The County should establish the required written procedures for federal monies and have them available to all personnel who work with federal programs. Views of Responsible Officials and Planned Corrective Action – The County will have written procedures for the federal program financial management requirements submitted to the Grant County Board of Commissioners for approval and implemented by all personnel. Responsible Official – Andrea Montoya, Deputy County Manager and Robert Placencio, Finance Director Timeline and Estimated Completion Date – No later than August 31, 2024.
2023-002 Timely Submission of Single Audit Report and Inaccurate Performance Report Numbers Reported Assistance Listing Number: 16.575 Federal Agency: United States Department of Justice Federal Award Identification: Unknown Type of Finding: Material Weakness Compliance Requirement: Reporting Criteria: According to the OMB Compliance Supplement, Part 6 and 2 CFR 200.512 (a)(1), non-federal entities that expend $750,000 or more in federal awards during a fiscal year are required to submit a complete and accurate Data Collection Form (DCF) and a Single Audit report package to the Federal Audit Clearinghouse (FAC) within the earlier of 30 calendar days after receipt of the auditor’s report or nine months after the end of the audit period. The DCF is a critical element in ensuring transparency and accountability for the use of federal funds. Additionally, per the Uniform Guidance (200.302) nonfederal entities are required to maintain effective internal controls and proper records to support the financial and performance data used in reporting to federal agencies. This includes maintaining records and documentation to substantiate reported performance and financial information to ensure accuracy, completeness and reliability. Condition: The Agency did not submit the required DCF for the fiscal year ended June 30, 2023, by the required deadline. The Agency also submitted inaccurate reporting for the following grants and timeframes: DV20201438 (4th Quarter), DV22221438 (1st & 2nd Quarters), RC21321438 (3rd Quarter), and RC22331438 (2nd & 3rd Quarter). Cause of Condition: The Agency failed to appropriately monitor and assess its federal expenditures, resulting in the oversight of surpassing the threshold that necessitates a single audit. As a consequence, they have missed the deadline for submission of the required DCF. Also, the Agency's database is not locked from editing and is susceptible to changes leading to inaccuracies when regenerating the report. Counselors responsible for recording their intake numbers are not submitting their numbers on time resulting in untimely recording. The Agency does not have a formal process or procedure in place to ensure that supporting documentation and schedules used in the preparation of performance reports are retained and organized for future reference and audit purposes. Potential Effect of Condition: Failure to submit the DCF on time resulted in noncompliance with federal regulations, which could lead to the potential withholding of future federal funding or other sanctions. It also undermines the Agency's compliance status and may affect the entity's standing with grantor agencies and other stakeholders. Without proper documentation, there is an increased risk of inaccurate or incomplete performance reporting, which may lead to noncompliance with grant requirements. Additionally, the lack of substantiation for reported amounts impairs the Agency's ability to demonstrate compliance with grant objectives and may result in potential audit findings. Questioned Costs: Not quantifiable. Recommendation: We recommend that the Agency implements stronger internal controls and procedures to ensure timely submission of the DCF. This could include designating a responsible party for tracking and submitting the DCF, creating a timeline and checklist for required submissions, and conducting periodic reviews to ensure compliance with deadlines. Additionally, the Agency should provide training to relevant staff on the importance of meeting federal compliance requirements. The client has already implemented a new database system to avoid the cumbersomeness of generating accurate numbers from the old system; however, we recommend a designated employee to ensure counselors are inputting their performance numbers on time. We also recommend a quarterly review of performance numbers before they are reported. Views of Responsible Official: Management agrees with the finding and will implement corrective action.
2023-002 Timely Submission of Single Audit Report and Inaccurate Performance Report Numbers Reported Assistance Listing Number: 16.575 Federal Agency: United States Department of Justice Federal Award Identification: Unknown Type of Finding: Material Weakness Compliance Requirement: Reporting Criteria: According to the OMB Compliance Supplement, Part 6 and 2 CFR 200.512 (a)(1), non-federal entities that expend $750,000 or more in federal awards during a fiscal year are required to submit a complete and accurate Data Collection Form (DCF) and a Single Audit report package to the Federal Audit Clearinghouse (FAC) within the earlier of 30 calendar days after receipt of the auditor’s report or nine months after the end of the audit period. The DCF is a critical element in ensuring transparency and accountability for the use of federal funds. Additionally, per the Uniform Guidance (200.302) nonfederal entities are required to maintain effective internal controls and proper records to support the financial and performance data used in reporting to federal agencies. This includes maintaining records and documentation to substantiate reported performance and financial information to ensure accuracy, completeness and reliability. Condition: The Agency did not submit the required DCF for the fiscal year ended June 30, 2023, by the required deadline. The Agency also submitted inaccurate reporting for the following grants and timeframes: DV20201438 (4th Quarter), DV22221438 (1st & 2nd Quarters), RC21321438 (3rd Quarter), and RC22331438 (2nd & 3rd Quarter). Cause of Condition: The Agency failed to appropriately monitor and assess its federal expenditures, resulting in the oversight of surpassing the threshold that necessitates a single audit. As a consequence, they have missed the deadline for submission of the required DCF. Also, the Agency's database is not locked from editing and is susceptible to changes leading to inaccuracies when regenerating the report. Counselors responsible for recording their intake numbers are not submitting their numbers on time resulting in untimely recording. The Agency does not have a formal process or procedure in place to ensure that supporting documentation and schedules used in the preparation of performance reports are retained and organized for future reference and audit purposes. Potential Effect of Condition: Failure to submit the DCF on time resulted in noncompliance with federal regulations, which could lead to the potential withholding of future federal funding or other sanctions. It also undermines the Agency's compliance status and may affect the entity's standing with grantor agencies and other stakeholders. Without proper documentation, there is an increased risk of inaccurate or incomplete performance reporting, which may lead to noncompliance with grant requirements. Additionally, the lack of substantiation for reported amounts impairs the Agency's ability to demonstrate compliance with grant objectives and may result in potential audit findings. Questioned Costs: Not quantifiable. Recommendation: We recommend that the Agency implements stronger internal controls and procedures to ensure timely submission of the DCF. This could include designating a responsible party for tracking and submitting the DCF, creating a timeline and checklist for required submissions, and conducting periodic reviews to ensure compliance with deadlines. Additionally, the Agency should provide training to relevant staff on the importance of meeting federal compliance requirements. The client has already implemented a new database system to avoid the cumbersomeness of generating accurate numbers from the old system; however, we recommend a designated employee to ensure counselors are inputting their performance numbers on time. We also recommend a quarterly review of performance numbers before they are reported. Views of Responsible Official: Management agrees with the finding and will implement corrective action.