Corrective Action Plans

Browse how organizations respond to audit findings

Total CAPs
51,573
In database
Filtered Results
539
Matching current filters
Showing Page
8 of 22
25 per page

Filters

Clear
Active filters: § 200.510
2CFR 200.510(b) requires organizations to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total of federal awards as determined in accordance with 2 CFR 200.502. The original SEFA prepared by the School...
2CFR 200.510(b) requires organizations to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements, which must include the total of federal awards as determined in accordance with 2 CFR 200.502. The original SEFA prepared by the School District was not complete and accurate. The School District will implement a procedure to ensure that accounting records are closed timely, internal accounts are reconciled, and appropriate workpapers are prepared to support SEFA balances. The School District will implement these procedures for the 2025 fiscal year end.
2023 – 006: Reporting - Preparation of the Schedule of Expenditures of Federal Awards (SEFA) (Repeat Finding: 2021-007 and 2022-006) Condition: During fiscal year 2023, the Organization did not have adequate controls in place to ensure the SEFA accurately reflected each award's federal agency and as...
2023 – 006: Reporting - Preparation of the Schedule of Expenditures of Federal Awards (SEFA) (Repeat Finding: 2021-007 and 2022-006) Condition: During fiscal year 2023, the Organization did not have adequate controls in place to ensure the SEFA accurately reflected each award's federal agency and assistance listing number. There were differences between the SEFA and the grant agreements/compliance supplements, requiring adjustments to the SEFA. Corrective Action Plan: As of October 1, 2024, the start of FY25 QuickBooks has been the only software used, and Revenue and Disbursements are being classed by Fund. General ledgers are now reconciled monthly. Each grant will have its own folder and required information to assure an accurate SEFA can be completed will be included. Management will reconcile SEFA amounts to the general ledger and review federal agency names and assistance listing numbers against grant documentation.
2023 - 007: Reporting: Preparation of the Schedule of Expenditures and Federal Awards (SEFA) (Repeat Finding:2019-007 and 2020-007, 2021-006 and 2022-008) Condition: During fiscal year 2023, the Governmental Department did not have sufficient controls to ensure the SEFA accurately reflected each awa...
2023 - 007: Reporting: Preparation of the Schedule of Expenditures and Federal Awards (SEFA) (Repeat Finding:2019-007 and 2020-007, 2021-006 and 2022-008) Condition: During fiscal year 2023, the Governmental Department did not have sufficient controls to ensure the SEFA accurately reflected each award’s federal expenditures. There were differences noted in reconciling expenditures from the original SEFA to the trial balance. These errors were corrected through adjustments proposed as part of the audit, and the final version of the SEFA reconciles to the Governmental Department’s general ledger. Corrective Action Plan: Management of the Tribe realizes the importance of the SEFA and will be sure that the SEFA matches the general ledger and accurately reflects each awards federal expenses. With moving reconciliation processes to monthly from annual this will greatly increase the accuracy of the SEFA.
The Schedule of Expenditures of Federal Awards (SEFA) provided to the audit firm was incomplete due to two primary factors: (1) insufficient understanding by staff regarding the requirement to include federally funded capital expenditures, and (2) improper recording of property acquisitions. Managem...
The Schedule of Expenditures of Federal Awards (SEFA) provided to the audit firm was incomplete due to two primary factors: (1) insufficient understanding by staff regarding the requirement to include federally funded capital expenditures, and (2) improper recording of property acquisitions. Management acknowledges this oversight, which occurred during the implementation of a new program and at a time when staff were not fully aware that such expenditures must be reflected on the SEFA. Furthermore, certain capital expenditures paid directly through escrow were not recorded in the organization's accounting records. To remediate these issues, management has taken the following corrective actions: - Delivered targeted training to staff on the proper treatment and reporting of federally funded capital expenditures; - Updated internal closing and reporting procedures to incorporate a formal review of balance sheet activity; and - Updated internal closing and reporting procedures to incorporate a reconciliation to settlement statements when recording new property acquisitions; and - Strengthened internal controls to ensure all federally funded capital items are accurately captured in future SEFA submissions. Management is committed to maintaining compliance with federal reporting requirements and ensuring the completeness and accuracy of future SEFA filings.
Finding: 2023-002: Revised Schedule of Expenditures of Federal Awards (SEFA) Description of Finding: Expenditures reported on the SEFA required revision during the Single Audit due to some inaccuracies, including one omitted program, which occurred because review and reconciliation procedures were n...
Finding: 2023-002: Revised Schedule of Expenditures of Federal Awards (SEFA) Description of Finding: Expenditures reported on the SEFA required revision during the Single Audit due to some inaccuracies, including one omitted program, which occurred because review and reconciliation procedures were not fully sufficient. Cause: The underlying cause was insufficient internal controls over grant documentation review and the accounting of federal award activity. Statement of Concurrence or Nonconcurrence: SacAsian agrees with the finding. Corrective Action: SacAsian acknowledges the significance of this finding and the potential for noncompliance with Uniform Guidance with the grantors and Federal entities, as well as potential increased risk of omitted federal programs and incorrect major program determination. To remediate these issues, SacAsian will strengthen its internal controls over SEFA preparation by implementing a multi-layer review and reconciliation process. SEFA schedules will be prepared by the Director of Finance and reviewed by the newly engaged external CFO firm. Final review will be performed by the President & CEO. SacAsian will implement a more rigorous review of all grant agreements, including pass-through awards, to verify federal components and Assistance Listing Number (ALN) details to ensure all federally funded activity is fully identified and properly reported on the SEFA. The SEFA will be reconciled to the general ledger, federal award agreements, billings submitted, and other supporting documentation. In addition, directors overseeing federal programs will be required to confirm that all federal awards under their purview are completely and accurately reflected. These enhanced controls will be implemented for the 2024 audit and maintained for subsequent audit periods. Responsible Party: Ryan Fong, Director of Finance, 916-446-7883, rfong@sacasiancc.org Pat Fong Kushida, President & CEO, 916-446-7883, patfk@sacasiancc.org Projected Completion Date: December 2025
Finding Reference Number: 2023-003 Description of Finding: SEFA reporting Statement of Concurrence or Nonconcurrence: The California Asian Pacific Chamber of Commerce (CalAsian) agrees with the finding. Corrective Action: CalAsian acknowledges the significance of this finding and the potential for n...
Finding Reference Number: 2023-003 Description of Finding: SEFA reporting Statement of Concurrence or Nonconcurrence: The California Asian Pacific Chamber of Commerce (CalAsian) agrees with the finding. Corrective Action: CalAsian acknowledges the significance of this finding and the potential for noncompliance with Uniform Guidance with the grantors and Federal entities, as well as potential increased risk of omitted federal programs and incorrect major program determination. Moving forward, SEFA reporting will be reviewed and approved by multiple reviewers, including the President & CEO, Controller, and Director of Finance. Individual directors under relevant federal programs being reported on the SEFA will also be required to review that the information listed on the SEFA report is complete and accurate. This review process will be in place for the 2024 audit and subsequent audits. Name of Contact Person: Ryan Fong, Director of Finance, 916-446-7883, rfong@calasiancc.org Pat Fong Kushida, President & CEO, 916-446-7883, patfongkushida@calasiancc.org Projected Completion Date: September 2025
2023-009- Reporting Federal Agency: U.S. Department of the Treasury Federal Program Name: American Rescue Plan Act / Coronavirus State Fiscal Recovery Fund (ARPA) Assistance Listing Number: 23.027 Federal Award Identification Number and Year: Various Pass-Through Agency: Pennsylvania Department of H...
2023-009- Reporting Federal Agency: U.S. Department of the Treasury Federal Program Name: American Rescue Plan Act / Coronavirus State Fiscal Recovery Fund (ARPA) Assistance Listing Number: 23.027 Federal Award Identification Number and Year: Various Pass-Through Agency: Pennsylvania Department of Health and Human Services Pass-Through Number(s): Not Available Award Period: 1/1/2023 – 12/31/23 Type of Finding: Significant Deficiency in Internal Control Over Compliance Condition: Policies and controls in place regarding the completeness of the SEFA were not properly functioning. Within the supporting listing of expenses relating to ARPA expenditures, multiple transactions were identified as 2022 fiscal year expenditures that were included in the 2023 expenditure total. The County revised the 2023 SEFA to exclude the 2022 expenditures. Recommendation: We recommend management should review the process of recording federal expenditures to determine expenditures are being included in the appropriate fiscal year. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action planned and taken in response to finding: The reason for the finding’s recurrence is in part a result of the timing of when the finding was issued. For example, the 2022 Single Audit was issued in August 2024. At this point, the 2023 fiscal year was already complete. Additionally, the implementation of corrective actions are in progress, including providing training, oversight and guidance to departments administering the grants, but these efforts take time to complete and/or are ongoing. A Deputy Controller of Grant Accounting was hired in February 2023, and a Manager-Grant Accounting was hired in July 2024, after working in this capacity as a temporary staff member since mid-2023. The County approved an additional full-time grant accounting position in May 2025 and will begin recruiting for this position in June 2025. These positions are responsible for establishing accounting policies based on best practices for grant-related activities, developing and providing training and resources to grant- funded departments, reviewing grant-related accounting in the Infor system, preparation of the annual SEFA, and assisting in the facilitation and preparation of documents needed for the Single Audit. The work performed by these positions had been vacant since the departure of Internal Audit Staff who helped General Accounting prior to the 2021 audit as well as the SEFA. Several changes have been made since the grant accounting team was created including the following: The grant accounting team is developing streamlined and standardized SEFA templates for each department for SEFA preparation. The expenditures reported on each SEFA are being compared to the financial information in the GL where possible to ensure all appropriate expenditures are included. Additionally, we are incorporating tracking of lifetime grant expenditures into the SEFA process to ensure no expenditures are missed due to cut off or timing issues. In 2023, the grant accounting team created a Montgomery County Grant Repository. This repository is used to store all grant agreements awarded to the County. Departments submit grant information to the repository upon notification of grant award. The grant accounting team reviews the Grant Repository when preparing the SEFA to ensure no grant programs are inadvertently left off of the SEFA. Additionally, the availability of the Grant Repository enables members of the accounting, finance and grant departments to quickly access grant award information when needed for audits, reporting, or other requirements. The grant accounting team is continuing to review and update the County’s Grant Accounting policies and is working closely with departments to understand their utilization of Infor to account for grant- related activities. As these policies are formalized, we will continue to provide training and resources; in late 2023, the County hired an outside trainer to provide an in-depth training on the accrual method of accounting, grant accruals, and the treatment of grant revenue. The Grant Accountant provided training in April 2024 to explain and outline the SEFA and Single Audit processes. Grant-funded departments received a two-day training on utilization of the Grant Management components of Infor in February 2024. We are also providing guidance and education to departments on the differences in timing of various grant fiscal years and how these impact the financial audit, SEFA and Single Audit. For example, departments must understand how to report expenditures and receipts in the correct period regardless of the fiscal year associated to the contract (State: July-June; Federal: October-September; County: January-December) and understand how these amounts reconcile to the amounts reported to the funding agencies. The accounting department continues to work with departments to emphasize the importance of submitting financial documentation timely and reviewing what is in the General Ledger promptly at the end of each month. The Finance department is performing quarterly reviews with departments to go over financial status, including grant financials. Departments are continuing to utilize Project Codes and other components of Infor’s Grant Management System to ensure the proper accounting of grant-related expenses, receipts, and revenues in the GL. Name(s) of the contact person(s) responsible for corrective action: Thomas Landauer and Fonta Reilly Planned completion date for corrective action plan: September 2025
View Audit 370214 Questioned Costs: $1
2023-008 – Reporting Federal Agency: U.S. Department of the Treasury Federal Program Name: Emergency Rental Assistance Program (ERAP) Assistance Listing Number: 23.023 Federal Award Identification Number and Year: Various Pass-Through Agency: Pennsylvania Department of Health and Human Services Pass...
2023-008 – Reporting Federal Agency: U.S. Department of the Treasury Federal Program Name: Emergency Rental Assistance Program (ERAP) Assistance Listing Number: 23.023 Federal Award Identification Number and Year: Various Pass-Through Agency: Pennsylvania Department of Health and Human Services Pass-Through Number(s): Not Available Award Period: 1/1/2023 – 12/31/23 Type of Finding: Significant Deficiency in Internal Control Over Compliance Condition: Policies and controls in place regarding the completeness of the SEFA were not properly functioning. Within the supporting listing of expenses relating to ERAP expenditures, six transactions were identified as prior fiscal-year expenditures that were included in the unadjusted 2023 expenditure total. The County revised the 2023 SEFA to exclude the 2022 expenditures. Recommendation: We recommend management should review the process of recording federal expenditures to determine expenditures are being included in the appropriate fiscal year. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action planned and taken in response to finding: The reason for the finding’s recurrence is in part a result of the timing of when the finding was issued. For example, the 2022 Single Audit was issued in August 2024. At this point, the 2023 fiscal year was already complete. Additionally, the implementation of corrective actions are in progress, including providing training, oversight and guidance to departments administering the grants, but these efforts take time to complete and/or are ongoing. A Deputy Controller of Grant Accounting was hired in February 2023, and a Manager-Grant Accounting was hired in July 2024, after working in this capacity as a temporary staff member since mid-2023. The County approved an additional full-time grant accounting position in May 2025 and will begin recruiting for this position in June 2025. These positions are responsible for establishing accounting policies based on best practices for grant-related activities, developing and providing training and resources to grant- funded departments, reviewing grant-related accounting in the Infor system, preparation of the annual SEFA, and assisting in the facilitation and preparation of documents needed for the Single Audit. The work performed by these positions had been vacant since the departure of Internal Audit Staff who helped General Accounting prior to the 2021 audit as well as the SEFA. Several changes have been made since the grant accounting team was created including the following: The grant accounting team is developing streamlined and standardized SEFA templates for each department for SEFA preparation. The expenditures reported on each SEFA are being compared to the financial information in the GL where possible to ensure all appropriate expenditures are included. Additionally, we are incorporating tracking of lifetime grant expenditures into the SEFA process to ensure no expenditures are missed due to cut off or timing issues. In 2023, the grant accounting team created a Montgomery County Grant Repository. This repository is used to store all grant agreements awarded to the County. Departments submit grant information to the repository upon notification of grant award. The grant accounting team reviews the Grant Repository when preparing the SEFA to ensure no grant programs are inadvertently left off of the SEFA. Additionally, the availability of the Grant Repository enables members of the accounting, finance and grant departments to quickly access grant award information when needed for audits, reporting, or other requirements. The grant accounting team is continuing to review and update the County’s Grant Accounting policies and is working closely with departments to understand their utilization of Infor to account for grant- related activities. As these policies are formalized, we will continue to provide training and resources; in late 2023, the County hired an outside trainer to provide an in-depth training on the accrual method of accounting, grant accruals, and the treatment of grant revenue. The Grant Accountant provided training in April 2024 to explain and outline the SEFA and Single Audit processes. Grant-funded departments received a two-day training on utilization of the Grant Management components of Infor in February 2024. We are also providing guidance and education to departments on the differences in timing of various grant fiscal years and how these impact the financial audit, SEFA and Single Audit. For example, departments must understand how to report expenditures and receipts in the correct period regardless of the fiscal year associated to the contract (State: July-June; Federal: October-September; County: January-December) and understand how these amounts reconcile to the amounts reported to the funding agencies. The accounting department continues to work with departments to emphasize the importance of submitting financial documentation timely and reviewing what is in the General Ledger promptly at the end of each month. The Finance department is performing quarterly reviews with departments to go over financial status, including grant financials. Departments are continuing to utilize Project Codes and other components of Infor’s Grant Management System to ensure the proper accounting of grant-related expenses, receipts, and revenues in the GL. Name(s) of the contact person(s) responsible for corrective action: Thomas Landauer and Fonta Reilly Planned completion date for corrective action plan: September 2025
View Audit 370214 Questioned Costs: $1
To: FY2023 Uniform Guidance Reporting Package From: David Noble, Director, Grant Administration RE: 2023 Uniform Guidance Audit Corrective Action Plan Date: September 25, 2025 Finding 2023-003 Federal Agency: U.S. Department of Treasury U.S. Department of Homeland Security ALN: 21.027 / 97.036 Grady...
To: FY2023 Uniform Guidance Reporting Package From: David Noble, Director, Grant Administration RE: 2023 Uniform Guidance Audit Corrective Action Plan Date: September 25, 2025 Finding 2023-003 Federal Agency: U.S. Department of Treasury U.S. Department of Homeland Security ALN: 21.027 / 97.036 Grady Memorial Hospital Corporation’s CFO and VP of Fiscal Services/Controller have reviewed the reporting from KPMG relating to the Uniform Guidance. We understand the recommendation set forth by KPMG and will update our controls and processes to include additional review of expenses incurred during the relevant audit period. Grady’s corrective action plan: We have restated 2023 SEFA totals based on updates to the project funded within ALN 21.027 and for the project funded within 97.036. Going forward the SEFA will be reviewed to ensure that all related expenses for the audit period are incorporated. Contact person/s responsible for the corrective action: David Noble, Director, Grant Administration Anticipated Completion Date: Consistent with 2024 Financial Audit Reporting
To: FY2023 Uniform Guidance Reporting Package From: David Noble, Director, Grant Administration RE: 2023 Uniform Guidance Audit Corrective Action Plan Date: September 25, 2025 Finding 2023-002 (REVISED) Federal Program: Medicaid Assistance Program HIV Emergency Relief Project Grants ALN: 93.778 / 93...
To: FY2023 Uniform Guidance Reporting Package From: David Noble, Director, Grant Administration RE: 2023 Uniform Guidance Audit Corrective Action Plan Date: September 25, 2025 Finding 2023-002 (REVISED) Federal Program: Medicaid Assistance Program HIV Emergency Relief Project Grants ALN: 93.778 / 93.914 Grady Memorial Hospital Corporation’s CFO and VP of Fiscal Services/Controller have reviewed the reporting from KPMG relating to the Uniform Guidance. We understand the recommendation set forth by KPMG and will update our controls and processes to include additional review of expenses incurred during the relevant audit period. Grady’s corrective action plan: Going forward the SEFA will be reviewed to ensure that all related expenses for the audit period are incorporated. Contact person/s responsible for the corrective action: David Noble, Director, Grant Administration Anticipated Completion Date: Consistent with 2024 Financial Audit Reportin
The grant accounting and SEFA preparation process will be refined, improved and documented. Internal resources will be reallocated to ensure sufficient coverage of these processes, and the primary accountability and oversight will shift to System Accounting. Management will ensure that in preparatio...
The grant accounting and SEFA preparation process will be refined, improved and documented. Internal resources will be reallocated to ensure sufficient coverage of these processes, and the primary accountability and oversight will shift to System Accounting. Management will ensure that in preparation of the SEFA, (1) a team member will assemble the initial reconciliation, (2) management will review the initial reconciliation and review the consolidation from all BayCare entities to the combined SEFA, (3) A final review will be conducted by the Director of Accounting. Sign-off from each preparer/reviewer shall be required. Meetings will be conducted as needed with departments outside of Hospital Finance to ensure completeness and accuracy of data. Start September 2025, Finalized Q1 2026
Condition: Controls in place were not adequate to ensure the schedule of federal expenditures was complete and accurate. Planned Corrective Action: Management fully understands the importance of internal controls to ensure the schedule of federal expenditures is complete and accurate. The Grants Dep...
Condition: Controls in place were not adequate to ensure the schedule of federal expenditures was complete and accurate. Planned Corrective Action: Management fully understands the importance of internal controls to ensure the schedule of federal expenditures is complete and accurate. The Grants Department will amend its current written processes regarding award establishment to include requiring documentation indicating an award is federal funds prior to establishing the project in Infor CloudSuite Financials & Supply Management (Accounting software). Additionally, the Grants Department will routinely audit the database the department utilizes to record awards to ensure the field to note federal awards is properly updated. Furthermore, the SEFA will be reviewed with documented sign-off by each member of the Grants Team prior to submission. Contact person responsible for corrective action: Stephanie Cihon Anticipated Completion Date: October 31, 2025
Finding Number 2023-008 Subject Heading (Financial) or AL no. and program name (Federal) 93.778 Medicaid Cluster Planned Corrective Action The Schedule of Expenditures of Federal Awards (SEFA) errors were corrected on October 16, 2024. To ensure the support for the Schedule of Expenditures of Federa...
Finding Number 2023-008 Subject Heading (Financial) or AL no. and program name (Federal) 93.778 Medicaid Cluster Planned Corrective Action The Schedule of Expenditures of Federal Awards (SEFA) errors were corrected on October 16, 2024. To ensure the support for the Schedule of Expenditures of Federal Awards is transferred accurately from the calculation worksheets and the other GAAP packages, we will implement a GAAP Package Z – SEFA Reviewer Checklist that will be included with the backup data of the GAAP Z. This will ensure the sources of data for the Schedule of Expenditures of Federal Awards are transferred correctly and tied back to their original source. Anticipated Completion Date 10/31/2024 Responsible Contact Person Calvin Cole, Financial Manager III
Finding Number 2023-009 Subject Heading (Financial) or AL no. and program name (Federal) 93.767 Children’s Health Insurance Program Planned Corrective Action The Schedule of Expenditures of Federal Awards (SEFA) errors were corrected on October 16, 2024. To ensure the support for the Schedule of Exp...
Finding Number 2023-009 Subject Heading (Financial) or AL no. and program name (Federal) 93.767 Children’s Health Insurance Program Planned Corrective Action The Schedule of Expenditures of Federal Awards (SEFA) errors were corrected on October 16, 2024. To ensure the support for the Schedule of Expenditures of Federal Awards is transferred accurately from the calculation worksheets and the other GAAP packages, we will implement a GAAP Package Z – SEFA Reviewer Checklist that will be included with the backup data of the GAAP Z. This will ensure the sources of data for the Schedule of Expenditures of Federal Awards are transferred correctly and tie back to their original source. Anticipated Completion Date 10/31/2024 Responsible Contact Person Calvin Cole, Financial Manager III
Finding Number 2023-211 Subject Heading (Financial) or AL no. and program name (Federal) 93.323: Epidemiology and Laboratory Capacity for Infectious Diseases Planned Corrective Action Action planned/taken in response to finding: For the year ending June 30, 2024 OSDE implemented a robust reconciliat...
Finding Number 2023-211 Subject Heading (Financial) or AL no. and program name (Federal) 93.323: Epidemiology and Laboratory Capacity for Infectious Diseases Planned Corrective Action Action planned/taken in response to finding: For the year ending June 30, 2024 OSDE implemented a robust reconciliation process over the SEFA. With the new process, all federal expenditures and drawdowns reported on the SEFA / Schedule Z are reconciled to expenditure transactions and drawdown detail from the Statewide Accounting Software (PeopleSoft). The new process will ensure the SEFA / Schedule Z is appropriately supported by individual transactions and sufficient review is performed. The reconciliation is prepared by an OSDE contractor and reviewed and approved by the Comptroller before finalizing. Anticipated Completion Date 6/30/2024 Responsible Contact Person Shawn Richmond, Comptroller
View Audit 367158 Questioned Costs: $1
Finding Number 2023-207 Subject Heading (Financial) or AL no. and program name (Federal) 93.323: Epidemiology and Laboratory Capacity for Infectious Diseases Planned Corrective Action The overstatement of expenditures on the SEFA is due to incorrect amounts being included on the report due to using ...
Finding Number 2023-207 Subject Heading (Financial) or AL no. and program name (Federal) 93.323: Epidemiology and Laboratory Capacity for Infectious Diseases Planned Corrective Action The overstatement of expenditures on the SEFA is due to incorrect amounts being included on the report due to using incorrect PeopleSoft queries and a lack of proper staff training. As stated in the finding, transactions related to expenditures and draws on the grant are reported in incorrect accounting periods; this is due to general ledger entries not using a budget reference code causing an under/over statement of expenditures and revenues. To mitigate this issue going forward, management has established a cash report in Hyperion which is currently being used by the Accounting area to ensure grant draws are accurate. To ensure transactions are recorded in the correct accounting period, management is working to create a policy and procedure to ensure a budget reference code is used on all general ledger transactions. The budget reference code will also be added to the Hyperion cash report to ensure transactions are reported in the proper accounting period. Management is also actively seeking formal training opportunities for accounting staff related to the proper procedures for completing all ACFR schedules. Anticipated Completion Date 6/30/24 Responsible Contact Person Stefan Von Dollen, Interim CFO
View Audit 367158 Questioned Costs: $1
Finding Number 2023-206 Subject Heading (Financial) or AL no. and program name (Federal) 93.268: Immunizations Cooperative Agreements Planned Corrective Action The overstatement of expenditures on the SEFA is due to incorrect amounts being included on the report due to using incorrect PeopleSoft que...
Finding Number 2023-206 Subject Heading (Financial) or AL no. and program name (Federal) 93.268: Immunizations Cooperative Agreements Planned Corrective Action The overstatement of expenditures on the SEFA is due to incorrect amounts being included on the report due to using incorrect PeopleSoft queries and a lack of proper staff training. As stated in the finding, transactions related to expenditures and draws on the grant are reported in incorrect accounting periods; this is due to general ledger entries not using a budget reference code causing an under/over statement of expenditures and revenues. To mitigate this issue going forward, management has established a cash report in Hyperion which is currently being used by the Accounting area to ensure grant draws are accurate. To ensure transactions are recorded in the correct accounting period, management is working to create a policy and procedure to ensure a budget reference code is used on all general ledger transactions. The budget reference code will also be added to the Hyperion cash report to ensure transactions are reported in the proper accounting period. Management is also actively seeking formal training opportunities for accounting staff related to the proper procedures for completing all ACFR schedules. Anticipated Completion Date 6/30/24 Responsible Contact Person Stefan Von Dollen, Interim CFO
Finding Number 2023-202 Subject Heading (Financial) or AL no. and program name (Federal) ALN: 21.027 Federal Program name: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) Planned Corrective Action OWRB was granted approval by the legislature to use a custodial bank to ensure ARPA funds we...
Finding Number 2023-202 Subject Heading (Financial) or AL no. and program name (Federal) ALN: 21.027 Federal Program name: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) Planned Corrective Action OWRB was granted approval by the legislature to use a custodial bank to ensure ARPA funds were provided quickly and efficiently to ARPA recipients. Historically, OWRB has used this successful process for securing and transacting funds for its clean and drinking water state revolving fund loans and its financial assistance programs. OWRB understands the issue with ARPA expenditure reporting. The posting dates for expenditures booked in PeopleSoft versus the dates ARPA project funds were released from the custodial bank for payment differed. This was because; to transfer ARPA funds to the bank, expenditures were booked using a purchase order in the PeopleSoft system. The purchase order process was then used to transfer funds to the custodial bank. This results in actual project expenditures being booked in the incorrected period for reporting standards. After initial transfers were made through the PeopleSoft system to the custodial bank, ARPA funds released from the bank for specified projects were on a different date. Funds were only released from the custodial bank upon approval by OWRB after review. The release dates for the ARPA project payments would only be in the custodial bank's accounting system and in OWRB's internal records but would not be reflected in the PeopleSoft accounting system. OWRB will meet with OMES to seek a remedy for this. The current method for the transfer and release of funds meets all necessary controls, however; it isn't adequate in reflecting the custodian's release dates without preparing a manual adjusting entry into the PeopleSoft system. Anticipated Completion Date 06/30/2025 Responsible Contact Person Cleve Pierce, Chief of Administrativ e Services/CFO Jessica Billingsley, Comptroller/F inancial Manager
Finding Number 2023-056 Subject Heading (Financial) or AL no. and program name (Federal) ALN: 21.027 Federal Program name: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) Planned Corrective Action Management Response The Oklahoma Office of Management and Enterprise Services – Grants Manag...
Finding Number 2023-056 Subject Heading (Financial) or AL no. and program name (Federal) ALN: 21.027 Federal Program name: Coronavirus State And Local Fiscal Recovery Funds (CSLFRF) Planned Corrective Action Management Response The Oklahoma Office of Management and Enterprise Services – Grants Management Office (OMES-GMO), in coordination with the OMES Financial Reporting Unit (FRU), agrees with the finding. OMES agrees with the finding and concurs that the implementation of additional controls, along with clarity on process, is necessary to ensure accurate preparation and reporting of expenditures on the Schedule of Expenditures of Federal Awards (SEFA). OMES recognizes the importance of compliance with 2 CFR § 200.303, § 200.502(a), and § 200.510(b), which require entities to maintain effective internal controls and to accurately report federal expenditures based on when the underlying activities occur. Accurate SEFA reporting ensures transparency and accountability in the use of federal funds, including Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) under Assistance Listing #21.027. Actions Taken and Planned Improvements: • FY2024 Review and Remediation: OMES FRU is actively working with the agencies identified in this finding to review and, if necessary, amend their FY2024 GAAP Package Z submissions. Necessary updates to FY2024 SEFA will be made to reflect accurate expenditure reporting in line with federal requirements. OMES FRU will review specific instances with its partner agencies identified in the findings to substantiate or refute agency assertions concerning provided assistance and approvals received. •GAAP Package Z Template Enhancements (Effective FY2025): OMES FRU will revise the GAAP Package Z template to include a new reconciliation tab. This tab will require agencies to reconcile reported federal expenditures and cash balances to SRD (Summary of Receipts and Disbursements) reports. OMES FRU will review this reconciliation against data from PeopleSoft to verify accuracy. •Annual SEFA Training: Beginning in FY2025, OMES FRU will provide annual training to all agencies involved in federal reporting. The training will focus on SEFA requirements, GAAP Package Z completion, and reconciliation procedures. This timing aligns with agency preparation for the FY2025 GAAP Package submissions. Noteworthy Corrections: Agencies 340, 423, 677, 800, and 585 made SEFA corrections at the request of the State Auditor’s Office prior to the issuance of this finding. These amendments were submitted and processed in a timely manner and reflect the agencies' commitment to compliance. Agency-Specific Responses Individual responses have been submitted by several agencies listed in the finding, outlining corrective actions, reconciliations, and improvements made to internal controls. These responses are available upon request and have been reviewed by OMES FRU for accuracy and completeness. In addition, several agencies have submitted their own independent responses, which document internal improvements and provide additional context to their individual reporting discrepancies. The following agencies provided the following independent responses: 619: The 2023 SEFA was completed and submitted by OMES without the aid or approval of agency 619 and the ARPA Grant Manager. Agency 619 worked very closely with OMES on the 2024 SEFA to ensure that our internal records matched what is listed in PeopleSoft. Some edits had to be made but the SEFA was submitted with all parties in agreement. Agency 619 will continue to work closely with OMES in future reporting periods to ensure the most accurate expense totals are reported. 670: Agency 670 has taken corrective action by reviewing internal processes with assigned staff to ensure required forms are comprehensively reviewed for errors, omissions, and exceptions prior to filing with OMES CAR. agency 670 is willing and able to complete an updated OMES CAR form with accurate information. Anticipated Completion Date 06/30/2026 Responsible Contact Person OMES: Parker Wise, Felicia Clark 619: Sara Librandi, Kami Fullingim 670: Mike Powers, Mark Chronister, Erik Paulson
Finding Number 2023-011 Subject Heading (Financial) or AL no. and program name (Federal) 20.509 - Formula Grants for Rural Areas Planned Corrective Action We concur with the auditor’s recommendation. Staff will be trained on how to reconcile & identify discrepancies. Anticipated Completion Date Sept...
Finding Number 2023-011 Subject Heading (Financial) or AL no. and program name (Federal) 20.509 - Formula Grants for Rural Areas Planned Corrective Action We concur with the auditor’s recommendation. Staff will be trained on how to reconcile & identify discrepancies. Anticipated Completion Date September 2025 Responsible Contact Person Sam Ddamba
Finding Number: 2023-042 Finding Name: Inaccurate Reporting of Federal Expenditures Finding Condition(s): The Illinois Department of Employment Security (IDES) did not accurately report Federal expenditures under the Unemployment Insurance (UI) program. Name of Contact Person(s): Kelly McGrath, Mana...
Finding Number: 2023-042 Finding Name: Inaccurate Reporting of Federal Expenditures Finding Condition(s): The Illinois Department of Employment Security (IDES) did not accurately report Federal expenditures under the Unemployment Insurance (UI) program. Name of Contact Person(s): Kelly McGrath, Manager of Accounting and Reporting – Illinois Department of Employment Security, Accounting and Reporting Corrective Action(s): The IDES has worked with its bank to address one of the underlying issues that prompted these adjustments and has updating its procedures for its GAAP package preparation. The IDES reviewed and considered this finding when preparing its fiscal year 2024 GAAP package. Proposed Completion Date: March 31, 2025 – Completed
Finding Number: 2023-012 Finding Name: Inaccurate Reporting of Federal Expenditures Finding Condition(s): The Illinois Department of Human Services (IDHS) did not accurately report federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) C...
Finding Number: 2023-012 Finding Name: Inaccurate Reporting of Federal Expenditures Finding Condition(s): The Illinois Department of Human Services (IDHS) did not accurately report federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, the Supplemental Nutrition for Women, Infants, and Children (WIC) programs, the Vocational Rehabilitation (VR) program, the Temporary Assistance for Needy Families (TANF), the Child Care Development Funds (CCDF) Cluster, the Social Services Block Grants (SSBG), the Block Grants for Prevention and Treatment of Substance Abuse (SAPT) program, and the Disability Insurance/SSI (SSDI) Cluster. Specifically, the auditors noted differences between the expenditure amounts provided for audit by the IDHS and the Schedule of Expenditures of Federal Awards (SEFA) amounts reported to the IOC, differences relative to amounts provided to program subrecipients, the cash basis expenditures provided by the IDHS for audit procedures included accrued (not paid) expenditures, and amounts passed through to other State agencies from the IDHS provided by the IDHS for audit procedures included expenditures paid outside of the fiscal year. Finally, IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. Name of Contact Person(s): Sarah Eves, Bureau Chief – Illinois Department of Human Services, Bureau of General Accounting Corrective Action(s): The IDHS has created a spreadsheet with all federal expenditure data grouped by assistance listing numbers (ALN). The spreadsheet also contains a tab with only the major program expenditure data, which is compared the IDHS’ SEFA totals. Any discrepancies between the reporting methodologies are identified and researched. Proposed Completion Date: September 30, 2024 – Completed
The City will review the process for identifying federal awards to minimize the likelihood of errors in preparing the schedule of expenditures of federal awards to minimize the likelihood of errors in preparing the schedule of expenditures of federal awards. This will include inquiries of the Engine...
The City will review the process for identifying federal awards to minimize the likelihood of errors in preparing the schedule of expenditures of federal awards to minimize the likelihood of errors in preparing the schedule of expenditures of federal awards. This will include inquiries of the Engineer’s Office.
SHLNFB will ensure that all Federal Awards are carefully reviewed to confirm that the Federal Assistance Listing Number is accurately stated, the pass-through entity identifying numbers are correct, and are included in the correct Cluster.
SHLNFB will ensure that all Federal Awards are carefully reviewed to confirm that the Federal Assistance Listing Number is accurately stated, the pass-through entity identifying numbers are correct, and are included in the correct Cluster.
Corrective Actions Taken or Planned Management concurs with the finding and is currently in the process of updating the accounting system to incorporate grant-specific specific tracking codes to further align with federal reporting standards. As part of a layered approach to internal controls, Excel...
Corrective Actions Taken or Planned Management concurs with the finding and is currently in the process of updating the accounting system to incorporate grant-specific specific tracking codes to further align with federal reporting standards. As part of a layered approach to internal controls, Excel worksheets will continue to be used as a supplementary monitoring tool, providing an additional cross-check to the system-generated reports. Responsible person: Jackie Ramirez, Operations & Finance Associate Director Expected Implementation date: November 20, 2025
« 1 6 7 9 10 22 »