Corrective Action Plans

Browse how organizations respond to audit findings

Total CAPs
48,628
In database
Filtered Results
393
Matching current filters
Showing Page
11 of 16
25 per page

Filters

Clear
Active filters: § 200.1
Condition: On the March 31, 2023 Project and Expenditure report the Town reported $625,231 of obligations for items that did not meet the definition of an obligation. Corrective Action Planned: Correct in next open reporting period Anticipated Completion Date: March 31, 2024 Contact: Apri...
Condition: On the March 31, 2023 Project and Expenditure report the Town reported $625,231 of obligations for items that did not meet the definition of an obligation. Corrective Action Planned: Correct in next open reporting period Anticipated Completion Date: March 31, 2024 Contact: April Steward, Town Administrator
FINDING 2023-003 Finding Subject: Subject: Child Nutrition Cluster - Procurement Summary of Finding: An adequate number of quotes were not obtained for small purchases. Contact Person Responsible for Corrective Action: Kellie Romer (Corporation Treasurer/Finance Director), Shelley Gardner (Corporati...
FINDING 2023-003 Finding Subject: Subject: Child Nutrition Cluster - Procurement Summary of Finding: An adequate number of quotes were not obtained for small purchases. Contact Person Responsible for Corrective Action: Kellie Romer (Corporation Treasurer/Finance Director), Shelley Gardner (Corporation School Food Authority) Contact Phone Number and Email Address: 765-653-9771 Ext. 1010, kromer@greencastle.k12.in.us, 765-653-9771 Ext. 1011, sgardner@greencastle.k12.in.us Views of Responsible Officials: We concur with the finding Description of Corrective Action Plan: The procurement (small and micro purchases) will be verified by a two-person internal control; the food services director and food services assistant, finance director or deputy treasurer. We will also establish a process to address small and micro purchases. This would include acquiring bids for any combined expenditure(s) over a $150,000, acquiring quotes for any small purchase(s) between $10,000 and $150,000, and documenting equitable distribution among vendors concerning any micro purchases under $10,000. All vendor contracts will be approved yearly. All quotes and purchases will be verified by two-person internal control. Anticipated Completion Date: Immediately 2/8/2024
Continuum of Care – Assistance Listing No. 14.267 Recommendation: We recommend the Organization put procedures in place to identify the performance period when charging invoices to grants, particularly during the start and end of the period of performance. Explanation of disagreement with audit find...
Continuum of Care – Assistance Listing No. 14.267 Recommendation: We recommend the Organization put procedures in place to identify the performance period when charging invoices to grants, particularly during the start and end of the period of performance. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: Additional and recurring training will be provided to both program and accounting staff. Grant procedures will be updated to expand review and monitoring of expenditures at beginning and end of grant periods for all federal grants. This will include hiring of an additional oversight position over all federal grants. Name(s) of the contact person(s) responsible for corrective action: Drew Erickson, Controller Planned completion date for corrective action plan: 04/30/2024
View Audit 291833 Questioned Costs: $1
RE: Single Audit Finding 2023-001 I provide the following information regarding the Town of Lincoln’s Corrective Action Plan: Finding 2023-001 Condition: Obligations were overstated by $1,435,098 on March 31, 2023 Project and Expenditure report. Corrective Action Planned: The Town now has a cle...
RE: Single Audit Finding 2023-001 I provide the following information regarding the Town of Lincoln’s Corrective Action Plan: Finding 2023-001 Condition: Obligations were overstated by $1,435,098 on March 31, 2023 Project and Expenditure report. Corrective Action Planned: The Town now has a clear understanding of the reporting requirements for obligations, and will report the correct amounts in the next report. Anticipated Completion Date: March 31, 2024 Contact: Colleen Wilkins, Finance Director/Town Accountant, wilkinsc@lincolntown.org 781-259-2673 Please let me know if you have any questions or if you need additional information. Sincerely, Colleen Wilkins Finance Director/Town Accountant Town of Lincoln 16 Lincoln Rd. Lincoln, MA 01773
Federal Program Name: • Coronavirus State and Local Fiscal Recovery Funds – ALN 21.027 • Block Grants for Prevention and Treatment of Substance Abuse – ALN 93.959 Recommendation: Our auditors recommended the Organization update their method of allocating expenditures to federal awards based on the ...
Federal Program Name: • Coronavirus State and Local Fiscal Recovery Funds – ALN 21.027 • Block Grants for Prevention and Treatment of Substance Abuse – ALN 93.959 Recommendation: Our auditors recommended the Organization update their method of allocating expenditures to federal awards based on the incurred date, rather than paid date. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: Management concurs with the audit finding. The previous process for grant salary, fringe, and indirect billings was based on salary paid date and therefore on a cash basis rather than accrual. The policy and process were immediately updated when the issue was identified during the fiscal year 2022 audit to bill based on period incurred rather than paid date, but the issue was identified after the invoices in question were sent. Revised invoices were not sent as total costs incurred during the period of the award, excluding the amounts noted in the finding, were still well over and above the award amount. All questioned costs were allowable but were outside the grant period and there are other eligible expenses during the period of performance which could have been billed to fully draw down on the award. Name(s) of the contact person(s) responsible for corrective action: CFO, Controller, and Grants Manager Planned completion date for corrective action plan: Will implement in fiscal year 2024
View Audit 11825 Questioned Costs: $1
Condition: Obligations were overstated by $9,341,064 on the June 30, 2023 Project and Expenditure report. Corrective Action Planned: Only obligated expenditures that meet the Federal criteria will be reported on the Project and Expenditure Report. Anticipated Completion Date: January 2024 when ...
Condition: Obligations were overstated by $9,341,064 on the June 30, 2023 Project and Expenditure report. Corrective Action Planned: Only obligated expenditures that meet the Federal criteria will be reported on the Project and Expenditure Report. Anticipated Completion Date: January 2024 when the Project and Expenditure Report for Q4 2023 is due Contact: Diane Smith, City Auditor
Finding 6539 (2023-006)
Significant Deficiency 2023
State Agency: Housing Trust Fund Corporation (Office of Resilient Homes and Communities) Single Audit Contact: Katie Brennan Title: Executive Director Telephone: (212) 480-7191 E-mail Address: Katie.Brennan@hcr.ny.gov Federal Program(s) (ALN # [s]): CDBG Disaster Recovery Grants – Pub. L. No. 113-2 ...
State Agency: Housing Trust Fund Corporation (Office of Resilient Homes and Communities) Single Audit Contact: Katie Brennan Title: Executive Director Telephone: (212) 480-7191 E-mail Address: Katie.Brennan@hcr.ny.gov Federal Program(s) (ALN # [s]): CDBG Disaster Recovery Grants – Pub. L. No. 113-2 Cluster (14.269/14.272) Audit Report Reference: 2023-006 Anticipated Completion Date: Corrective Action being implemented as of 11/20/23. Corrective Action Planned: Internal procedures have been amended and are being implemented to allow for corrective and accurate reporting of grants or cooperative agreements for first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS) pursuant to the Federal Funding Accountability and Transparency Act (FFATA) (Pub. L. No. 109-282), as amended by Section 6202 of Public Law 110-252, herein referred to as the "Transparency Act" that are codified in 2 CFR Part 170.
Finding No.: 2022-045 AL Program: 97.039 - Hazard Mitigation Grant Program Area: Allowable Costs/Cost Principles Questioned Costs: $99,924 Contact Person(s): Patrick Guerrero, Governor’s Authorized Rep., PAO Corrective Action Plan: The Hazard Mitigation Grant Program (HMGP) agrees with this finding....
Finding No.: 2022-045 AL Program: 97.039 - Hazard Mitigation Grant Program Area: Allowable Costs/Cost Principles Questioned Costs: $99,924 Contact Person(s): Patrick Guerrero, Governor’s Authorized Rep., PAO Corrective Action Plan: The Hazard Mitigation Grant Program (HMGP) agrees with this finding. During the audit submission process, HMGP provided the support documents for the journal entries and reversals associated with the $99,923.27 to the auditor, as requested. However, it was only upon receiving this audit finding # 2022-049, that the discrepancy of a duplicate audit drawdown was called into question. HMGP’s ledger for this project as well as the Munis drawdown history does not indicate a remaining balance of $99,923.73 and the project related to this finding has already been closed out. To address this audit finding that HMGP received this last week on September 17th, HMGP reached out to the Department of Finance to provide related documents for the drawdowns. Based on the documents provided by DOF, the questioned cost was not a direct result of the duplicate drawdown but as a result of the reverse journal entries made by Tyler Munis staff in an effort to correct the duplicate drawdown. HMGP accurately completed all required steps to process and provided the necessary justification to process a total of $99,923.73 for professional services and submitted it to DOF. Based on the supporting documents, the $99,923.73 was comprised of: • $53,451.01- under Request for Payment Application #11, letter reference # GAR22-HM-005 received by DOF on 10/18/2021 and requested to be charged to M142352.62060. • $46,472.72- under Request for Payment Application #12, letter reference # GAR22-HM-031 received by DOF on 11/05/2021 and requested to be charged to M142352.62060. Both HMGP payment application requests show the project string was meant to be charged to 62060 which stands for Professional Services and was submitted to DOF for processing. Since the new Munis financial system portal was launch in the CNMI a month prior, HMGP personnel were not able to enter transactions directly, unlike the current process. However, when the transaction was processed on Munis, it was entered in by a Tyler Munis representative, as identified by the staff initials SMD, who was assigned to assist DOF employees with data input during the transition period and, according to the Munis transaction history, accidentally entered the debit for the $99,923.27 under the Construction project string instead of Professional Services on 12/2/2021. On 12/13/2021, SMD credited the $99,923.27 back to Construction and debited $99,923.27 to Professional Services with Journal entry # 2125. The Munis transaction history also shows various entries and reversals made under the project account that serve to correct the same journal error. HMGP personnel would not be able to review the transactions entered prior to posting, and based on the transaction logs, even after the transactions were posted, HMGP would see that those involved in processing the transactions corrected their errors. Additionally, the supporting documents associated with the drawdowns on Munis display a bank statement with a lumpsum total of various project accounts. Furthermore, most of the journal entries during the time in question either contained the same supporting documents or indicated “access denied” when selected by HMGP personnel with Munis access. The document provided to HMGP on 9/24/2025 indicated the final two transactions related to this expense was entered by Tyler Munis staff on August of 2022. In an effort to reverse the duplicate drawdowns that occurred in Professional Services, SMD reversed the $99,923.27 from professional services labeled as "REV JE 2125 DONE IN ERROR". Journal Entry (JE) 2125 refers to the debit they initially made on 12/13/2021. This credit effectively canceled out and corrected one of the two drawdowns that occurred within the Professional Services Project String. However, on the same day, SMD made a second journal entry reversal under the Construction project string with an identical PA journal comment ""REV JE 2125 DONE IN ERROR."" It is unclear as to why this transaction occurred given that original error under construction was made and corrected on December 2021. Since this incorrect journal entry was made as a debit to construction and the correct journal entry was made as a credit to professional services, the net draw would have been $0. Since $0 worth of funds were paid out and no check was cut as a result, this additional debit would not have been conspicuous to HMGP or the DOF staff. HMGP is prepared to provide the additional documentation upon request. Additionally, acknowledging that the second debit to construction in August of 2022 for $99,923.73 was recorded and was not corrected for this project, HMGP will work with DOF to correct the journal entry and return the funds to FEMA. To address the finding, a significant action step already taken is the transition that occurred in 2024 for agencies to initiate their own drawdowns. This drawdown process ensures HMGP’s direct oversight of all expenditures moving forward to reduce the risk of future duplications. HMGP created an internal drawdown tracker upon DOF’s transition to agency-initiated drawdown requests for 2024 expenses to present. HMGP will work with DOF to correct the journal entry on Munis in relation to the questioned cost and process the return of funds to FEMA. HMGP will create a tracker for all requested transactions made to DOF, such as reversals or corrections if needed as that function cannot be completed on Munis by HMGP. HMGP will review the tracker on a bi-weekly basis to ensure that all MUNIS journal entries and transfers related to HMGP to ensure expenditures are completed accurately and on a timely basis to avoid future misclassifications or duplications. HMGP will continue to ensure that all payments are correctly coded and submitted into Munis with the appropriate documentation and supporting details. HMGP will update the financial management portion of the HMGP standard operating procedures to reflect these action items. Proposed Completion Date: September 30, 2026
View Audit 371187 Questioned Costs: $1
Finding No.: 2022-028 AL Program: 21.027 - Coronavirus State and Local Fiscal Recovery Funds Area: Activities Allowed or Unallowed and Allowable Costs/Cost Principles Questioned Costs: $33,815,438 Contact Person(s): Tracy B. Norita, Secretary of Finance Corrective Action Plan: Condition 1&6: The Dep...
Finding No.: 2022-028 AL Program: 21.027 - Coronavirus State and Local Fiscal Recovery Funds Area: Activities Allowed or Unallowed and Allowable Costs/Cost Principles Questioned Costs: $33,815,438 Contact Person(s): Tracy B. Norita, Secretary of Finance Corrective Action Plan: Condition 1&6: The Department of Finance agrees with this finding. It is important to note that the issue occurred during FY22, a period marked by the transition from the legacy financial system (JDE) to the new Tyler Munis platform. During this time, processes for retaining and reconciling supporting documents had not been standardized, resulting in inconsistencies and a heightened risk of missing or improperly uploaded records. Furthermore, the Program Manager previously responsible for overseeing this grant is no longer with the Department. Due to internal scheduling constraints and the compressed timeline required to complete the FY22 audit, the requested documents were not submitted by the specified deadline, which contributed to this finding. Nevertheless, the Department is committed to provide relevant supporting documentation upon request from the Grantor. Proposed Completion Date: Ongoing Condition 2-5, 7&8: The Department of Finance respectfully disagrees with this finding. Due to internal scheduling constraints and the compressed timeline required to complete the FY22 audit, the requested documents were not submitted by the specified deadline, resulting in this finding. However, the office maintains all relevant supporting documentation and is prepared to provide it upon request from the Grantor. Proposed Completion Date: Ongoing Condition 9: The Department of Finance agrees with the findings. Following the legal opinion from the CNMI Attorney General’s Office in August 2025, we secured all necessary documentation from the Municipality of Tinian to ensure proper recording and reconciliation of transactions in our financial system. Proposed Completion Date: December 31, 2025
View Audit 371187 Questioned Costs: $1
Finding No.: 2022-019 AL Program: 15.875 - Economic, Social, and Political Development of the Territories Area: Subrecipient Monitoring Questioned Costs: $549,849 Contact Person(s): Nerissa B. Karakaya, CIP COTR / Angelina Phillips, Office of Management and Budget (OMB) Corrective Action Plan: Condi...
Finding No.: 2022-019 AL Program: 15.875 - Economic, Social, and Political Development of the Territories Area: Subrecipient Monitoring Questioned Costs: $549,849 Contact Person(s): Nerissa B. Karakaya, CIP COTR / Angelina Phillips, Office of Management and Budget (OMB) Corrective Action Plan: Condition 1 (N. Karakaya): CIP agrees with this finding. The address this finding, CIP will implement the following: 1. Establish Written Procedures: CNMI has developed and will initiate the implementation of formal written procedures requiring that all potential subrecipients be checked in SAM.gov prior to award and that verification is documented and retained in the official files. 2. Standardized Documentation: A standardized risk assessment checklist will be used for all subrecipients to confirm they are not suspended, debarred, or excluded under 2 CFR §180.300. 3. Staff Training: All staff responsible for subrecipient monitoring will receive training on federal requirements for exclusion checks and proper documentation procedures. 4. Monitoring and Review: CIP will conduct periodic reviews to ensure that SAM.gov checks are consistently performed and documented for all new and existing subrecipients. Condition 2 (N. Karakaya): CIP respectfully disagrees with this finding. The subrecipient was not required to submit the required project narrative report; instead, the report was prepared and submitted by the project manager responsible for managing the project as assigned by the Capital Improvement Program. In accordance with 2 CFR §200.328 – Monitoring and Reporting Program Performance, subrecipients are required to provide performance reports to the pass-through entity that document the status and progress of activities in accordance with the approved scope of work. To correct this issue, the subrecipient will implement a formal internal procedure designating the Program Coordinator as responsible for preparing, reviewing, and submitting all project narrative reports. Additionally, mandatory training will be conducted for all relevant subrecipient staff on federal reporting requirements and proper submission procedures, and all future narrative reports will include a certification by the authorized subrecipient representative confirming proper submission. The Capital Improvement Program will monitor submissions quarterly for the next 12 months to ensure full compliance. Corrective Actions: 1. Implement a formal internal reporting procedure requiring the subrecipient’s Program Coordinator to prepare, review, and submit all project narrative reports. 2. Conduct mandatory training for subrecipient staff on federal reporting requirements, documentation standards, and submission procedures. 3. Include a certification statement on all future narrative reports, signed by the subrecipient’s authorized representative, confirming proper submission. 4. Conduct quarterly monitoring of subrecipient submissions for the next 12 months to ensure compliance with reporting requirements. Proposed Completion Date: December 31, 2025 Condition 3 (N. Karakaya): We acknowledge the finding that documentation was not provided to verify whether eight subrecipients were subject to the audit requirements. The Capital Improvement Program will strengthen its subrecipient monitoring procedures to ensure compliance with 2 CFR 200.331(f) and related audit requirements. Corrective actions will include: 1. Policy Implementation: Adopt and disseminate the newly established Subrecipient Monitoring Policy and Procedures, which specify verification of subrecipients’ audit requirements. 2. Training: Provide training for program and grants management staff on the updated procedures and audit verification process. 3. Documentation: Maintain written evidence of audit requirement verifications for all subrecipients as part of the grant administration files. 4. Ongoing Monitoring: Incorporate periodic review of subrecipient audit status into the regular monitoring schedule to ensure continued compliance. These steps will be implemented immediately and will be applied to all current and future awards to prevent recurrence of this issue. Proposed Completion Date: December 31, 2025
View Audit 371187 Questioned Costs: $1
The Government concurs with the auditor's findings and recommendations. The office of Management and Budget will work with the Department of Finance to implement control measures that will prevent the approval of transaction beyond the period of performance.
The Government concurs with the auditor's findings and recommendations. The office of Management and Budget will work with the Department of Finance to implement control measures that will prevent the approval of transaction beyond the period of performance.
View Audit 369907 Questioned Costs: $1
Period of Performance Child Care and Development Block Grant – Assistance Listing No. 93.575 Recommendation: The auditors recommend the Organization design, implement, and monitor internal controls over allocations as well as maintain source documentation to support amounts charged to the grant. E...
Period of Performance Child Care and Development Block Grant – Assistance Listing No. 93.575 Recommendation: The auditors recommend the Organization design, implement, and monitor internal controls over allocations as well as maintain source documentation to support amounts charged to the grant. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: Management will review the current internal controls over allocations and source documentation to identify any gaps or weaknesses and develop a plan to address any identified gaps or weaknesses, including updating policies and procedures as necessary. Management will also communicate the updated policies and procedures to all relevant employees and provide training as needed. Monitoring and testing procedures will be implemented to ensure that the updated policies and procedures are being followed. There will also be regular reviews and updates to the policies and procedures as needed to ensure ongoing effectiveness. Management will assign responsibility for maintaining source documentation to a specific individual or team and develop a system for organizing and storing source documentation, such as a centralized electronic database. Monitoring and testing procedures will be implemented to ensure that source documentation is being maintained and is readily accessible. Lastly, there will be regular reviews and updates to the system for organizing and storing source documentation as needed to ensure ongoing effectiveness. Name of the contact person responsible for corrective action: Lyn Elliot, CEO Planned completion date for corrective action plan: 7/1/2025
Finding 573717 (2022-010)
Significant Deficiency 2022
The Board of County Commissioners, with the cooperation and participation of all elected officials, reviews, develops and implements policies and procedures to create a strong internal control environment. The Board of County Commissioners will work with all elected officials, the third-party admini...
The Board of County Commissioners, with the cooperation and participation of all elected officials, reviews, develops and implements policies and procedures to create a strong internal control environment. The Board of County Commissioners will work with all elected officials, the third-party administrator, and federal, state and local partners to develop policies, procedures, and internal controls designed to accurately track grants, including the application process, verification, oversight, and reporting of grant requirements. To assist in this process, the Board of County Commissioners engaged a third-party administrator to oversee the grant process, including application, eligibility, review, requirements, contracting, recipient tracking and oversight, and documentation and reporting. The Board of County Commissioners will work with the third-party administrator to ensure proper grant administration.
Finding 559023 (2022-005)
Significant Deficiency 2022
Response of Responsible Society Official: We will review 2 CFR 200 Subpart E - Cost Principle to in an effort to refamiliarize ourselves with the Cost Principles.
Response of Responsible Society Official: We will review 2 CFR 200 Subpart E - Cost Principle to in an effort to refamiliarize ourselves with the Cost Principles.
View Audit 355287 Questioned Costs: $1
Significant Deficiency in Internal Control over Compliance, Other Matters Description of Finding Coventry Public School’s procurement standards do not include the essential elements as outlined in 2 CFR sections 200.318 through 200.326. Statement of Concurrence or Nonconcurrence Management concurs...
Significant Deficiency in Internal Control over Compliance, Other Matters Description of Finding Coventry Public School’s procurement standards do not include the essential elements as outlined in 2 CFR sections 200.318 through 200.326. Statement of Concurrence or Nonconcurrence Management concurs with the finding. Corrective Action Coventry Public Schools will review the district’s current purchasing policy and make sure that it is following the criteria as set out in the 2 CFR sections 200.318 and 200.326. The policy will then be updated and communicated to all personnel involved in the procurement process. Name of Contact Person Christopher Deverna, CPA, Director of Finance, Coventry Public Schools Projected Completion Date June 30, 2025
FINDING 2022-005 Finding Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting Summary of Finding: Material Weakness, Modified Opinion The County did not have an effective internal control system to ensure compliance with the Reporting compliance requirement. Recipients a...
FINDING 2022-005 Finding Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting Summary of Finding: Material Weakness, Modified Opinion The County did not have an effective internal control system to ensure compliance with the Reporting compliance requirement. Recipients are required to submit quarterly or annually Project and Expenditure (P&E) Reports to the Department of the Treasury (Treasury). The County submitted four quarterly P&E Reports during the audit period. The County's process for the completion and submission of the P&E Reports was that the County Auditor prepared each P&E Report based on the County's Financial Ledgers, without a proper oversight or review process in place prior to submission. All four quarterly reports that were due during the audit period were not properly supported by the County's records Contact Person Responsible for Corrective Action: Timothy Stabosz Contact Phone Number and Email Address: 219-326-6808 x2226 tstabosz@laporteco.in.gov Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: To correct this finding, we will require one person to complete the report and another to review the report prior to submission. Anticipated Completion Date: We will begin requirement a review prior to submission as of November 21, 2024.
Finding 504820 (2022-005)
Material Weakness 2022
FINDING 2022-005 Finding Subject: CDBG ‐ Entitlement Grants Cluster ‐ Period of Performance Summary of Finding: The county did not have properly designed internal controls in order to prevent or detect errors in the general ledger for activities related to adjustments to Community Development Block ...
FINDING 2022-005 Finding Subject: CDBG ‐ Entitlement Grants Cluster ‐ Period of Performance Summary of Finding: The county did not have properly designed internal controls in order to prevent or detect errors in the general ledger for activities related to adjustments to Community Development Block Grant funds during the transition and implementation of the Oracle accounting system. Contact Person Responsible for Corrective Action: Dan Ciecierski, Comptroller Contact Phone Number and Email Address: 219-755-3137 | ciecidx@lakecountyin.org Views of Responsible Officials: We concur with the finding. Explanation and Reasons for Disagreement: N/A Description of Corrective Action Plan: Lake County has begun execution of a comprehensive strategy in order to address the lack of internal controls around its financial transactions and reporting in a number of ways. The following will address control issues identified in these areas: - Financial Transactions and Reporting - Employee Benefit Accrual (EBA) Fund - Cash and Investments - Receipts - Journal Entries - Financial Statement & Reporting First, a more qualified consulting firm has been hired to assist on two important fronts related to the new accounting system: 1. The first is the reimplementation of the Oracle accounting software which is inclusive of correcting data and poor configurations from the prior consultant, and deploying additional appropriate functionality to allow the County to optimize Oracle to suit the accounting needs from a process standpoint as well as an internal control perspective. Oracle in and of itself allows the county to implement strategic preventative internal controls via role-based access features. Said differently, Oracle has a more robust and granular ability to automatically create separation of INDIANA STATE BOARD OF ACCOUNTS 41 duties among employees and departments simply by restricting the ability to perform actions which should be naturally segregated to mitigate risk of error. 2. Secondly, the managed services portion of the consulting contract will aid the County in running the business activities related to both the Oracle Human Capital Management (HCM) module and the Enterprise Resource Planning (ERP) module (Purchasing, Accounts Receivable, Accounts Payable, and General Accounting). Another initiative being executed to address the lack of internal controls is to attract, and hire qualified professionals who have years of real world, practical experience in the field for which a job relates to. During the original implementation of the Oracle system there was no one who fully understood, nor had a background in the professional field of accounting in the Auditor’s Office. The County has hired a Comptroller who passed the CPA, and has spent their entire career in the field of accounting. This individual has worked in the corporate utility and banking industries and has experience in GAAP reporting, regulatory reporting, internal controls, and overall general accounting. Additionally, the Comptroller has been involved with internal and external audit compliance as well as the installation, user acceptance testing, and transition of new accounting software. In order to mitigate the risk of error for any adjusting entries made which are recommended by consultants, the Comptroller of Finance must review and approve these entries. Anticipated Completion Date: 1. This process has already been put into place and is being executed.
Finding 504818 (2022-004)
Material Weakness 2022
FINDING 2022-004 Finding Subject: CDBG – Entitlement Grants Cluster—Reporting Summary of Finding: Condition and Context: The County did not have internal control procedures over the Quarterly Reports (PR29), IDIS Section 3 Performance Report, and NSP Quarterly Reports. One individual prepared or gen...
FINDING 2022-004 Finding Subject: CDBG – Entitlement Grants Cluster—Reporting Summary of Finding: Condition and Context: The County did not have internal control procedures over the Quarterly Reports (PR29), IDIS Section 3 Performance Report, and NSP Quarterly Reports. One individual prepared or generated the report without a review or oversight process. Additionally, the County’s internal controls were not consistently documented over the draw down requests for the CDBG grant during the audit period. The draw down requests were entered into IDIS, which then becomes the basis for several of the reports. The control presented by the County was that one individual prepared and entered the request, which would then be printed, and another individual would review and sign the printed request to document the review. Of the thirteen reimbursement requests tested, control documentation for eight of the requests were printed and signed during current period, after the documentation was requested. The creation of documentation of the control procedure did not support that internal controls were effective during the audit period. Recommendation: We recommended that the County's management design and implement a proper system of internal controls, and retain documentation of its system of internal controls, to ensure compliance with reporting requirements. Contact Person Responsible for Corrective Action: Timothy A. Brown Contact Phone Number and Email Address: 219-755-3225 and brownta@lakecountyin.org Views of Responsible Officials: LCCEDD concurs with the audit finding. Concurrence: The Fiscal Officer from the Audit Period was new to the position and her training was focused on the changes to the financial systems at the county over the DRGR quarterly reporting of NSP actions. Further, Finding 2022-003 also caused some of the reporting issues with CDBG of having two CDBG funds and posting errors to these funds. The current LCCEDD Fiscal Officer found the problems during the audit and corrective actions were done retroactively to address this part of the finding with the drawdown requests. The CDBG drawdowns were submitted into IDIS by the Fiscal Officer who printed out the drawdown request. These printouts were then given to the Executive Director or the Deputy Director who then went into IDIS and approved the drawdown request, then print out the IDIS drawdown approval and return the request and the signed approval back to the Fiscal Officer. LAKE COUNTY COMMUNITY ECONOMIC DEVELOPMENT DEPARTMENT 2293 N. Main Street - Crown Point, In 46307 Tel. (219) 755-3225 www.lakecountyin.org INDIANA STATE BOARD OF ACCOUNTS 38 Description of Corrective Action Plan: LCCEDD staff have already adopted changes in internal controls to correct the CDBG reporting deficiencies as described in Finding 2022-003. Further, management will oversee compliance with current policies and the new quarterly reconciliations. LCCEDD policies will be updated to make the following changes: General Management and Oversight: On an on-going basis, the Director will meet with Department staff to determine if training or technical assistance is needed to complete HUD reporting requirements in a timely and accurate manner. NSP Quarterly Reports: To be followed until the HUD field office indicates QPR reports are no longer needed due to grant closeout: 1. Before the close of each month, the Fiscal Officer will create receipts and draws as needed in HUD’s DRGR system to reflect funds receipted or expended by the County. 2. At the close of each quarter, the Fiscal Officer will prepare and submit the quarterly report in DRGR for the NSP1 and NSP3 grant allocation. To prepare the report, the Fiscal Officer will reconcile all expenses and receipts posted in the County’s general ledger system for the NSP programs with the receipts and drawdown requests recorded in in HUD’s DRGR reporting system. 3. Before submitting the NSP QPR Report in the DRGR system, the Deputy Director will review and approve the prepared reconciliation and QPR Report. Any discrepancies between the two systems will be reported to the Auditor and the Department Director to determine corrective actions. 4. Within 30 days of the close of each calendar quarter, the Fiscal Officer will submit the NSP QPR Report via DRGR. The Fiscal Officer will maintain a copy of the NSP QPR and the corresponding reconciliation in their program files. Cash on Hand Reports: 1. At the close of each quarter, the Fiscal Officer will prepare and submit the Cash on Hand Report within thirty days of the close of the quarter. The Fiscal Officer will reconcile all expenses and receipts posted in the County’s general ledger system with the receipts (report PR09) and drawdown requests (report PR07) in HUD’s IDIS Online reporting system. 2. Before submitting the Cash on Hand Report in the IDIS Online system, the Deputy Director will review and approve the prepared reconciliation and Cash on Hand Report. Any discrepancies between the two systems will be reported to the Auditor and the Department Director to determine corrective actions. 3. Within 30 days of the close of each calendar quarter, the Fiscal Officer will submit the Cash on Hand Report via IDIS Online. The Fiscal Officer will maintain a copy of the Cash on Hand report and the corresponding reconciliation in their program files. INDIANA STATE BOARD OF ACCOUNTS 39 Section 3 Reporting: 1. As part of the application review, the Deputy Director will determine the applicability of the Section 3 requirements for each proposed project. 2. For projects where Section 3 is applicable, the Deputy Director will ensure that staff administering the project are familiar with the Section 3 requirements and understand the forms and reporting required to properly report Section 3, including the determination of total labor hours worked, labors hours worked by Section 3 and Targeted Section 3 workers, and corresponding certifications. 3. The County will collect Section 3 reports from subrecipients administering projects throughout the period of performance. If the project meets Section 3 benchmarks, the County will consider the activity to be in full compliance with Section 3. If the project does not meet one of the Section 3 benchmarks, the County will require reporting on the qualitative efforts that the subrecipient made to try to reach the benchmarks. 4. Section 3 information collected for each project will be reported in IDIS Online. The Section 3 information must be reported annually before the submission of the annual report (CAPER) to HUD. Anticipated Completion Date: Part of the corrections have already been put into place and the Policy and Procedure Manual will be amended in April of 2025 after the Lake County Redevelopment Commission adopts appropriate changes.
Finding 504817 (2022-003)
Material Weakness 2022
FINDING 2022-003 Finding Subject: CDBG – Entitlement Grants Cluster—Program Income Summary of Finding: Condition and Context: The County received program income through various loan programs it offered to qualifying individuals. Once the County received a loan payment, the receipt was posted into th...
FINDING 2022-003 Finding Subject: CDBG – Entitlement Grants Cluster—Program Income Summary of Finding: Condition and Context: The County received program income through various loan programs it offered to qualifying individuals. Once the County received a loan payment, the receipt was posted into the financial accounting system of the County and recorded in a grant fund. The amount received was also to be recorded in the Department of Housing and Urban Development’s (HUD) Integrated Disbursement & Information System (IDIS) website. The recorded program income in IDIS would then appear on the Drawdown Report by Voucher Number report (PR07). No internal control process had been established over the program income compliance requirement. One individual was responsible for notifying the Auditor's office when program income money was received, in order for it to be receipted in the County’s financial accounting system. The same individual was also responsible for reporting the same on IDIS site. No controls were established to ensure the program income that was recorded in the financial accounting system was also reported on IDIS site and the PR07 report. Additionally, four receipts totaling $38,960 were selected for testing from the County’s receipt ledger. These four receipts were unable to be located on the PR07 report provided for audit. One of the four receipts was recorded in the IDIS system after information regarding the receipt was requested. The receipt was not in the PR07 report that had been provided for audit when we were provided information documenting it being recorded in IDIS. Furthermore, we were unable to verify the total amount recorded in receipt ledger to the total reported on PR07 report. The County’s ledger was greater than the PR07 report by $30,324 and is primarily attributed to under reporting of program income in IDIS as identified above. Recommendation: We recommended that the management of the County establish a system of internal controls to ensure that all program income received is properly reported in the IDIS system and expended prior to drawing down federal awards. Contact Person Responsible for Corrective Action: Timothy A. Brown Contact Phone Number and Email Address: 219-755-3225 and brownta@lakecountyin.org Views of Responsible Officials: LCCEDD concurs with the audit finding. LAKE COUNTY COMMUNITY ECONOMIC DEVELOPMENT DEPARTMENT 2293 N. Main Street - Crown Point, In 46307 Tel. (219) 755-3225 www.lakecountyin.org INDIANA STATE BOARD OF ACCOUNTS 36 Description of Corrective Action Plan: LCCEDD staff have already adopted changes in internal controls to correct the Program Income reporting deficiencies. The process is as follows: 1. All incoming checks into the department are first reviewed by the Deputy Director. The Deputy Director determines the source of income (i.e. CDBG, HOME, NSP) and the correct receipt type (program income, repayment, homebuyer). The Deputy Director records the IDIS number of the project on the check before giving it to the Fiscal Officer. 2. The Fiscal Officer records the receipt on an internal schedule of receipts and submits the check to the County Auditor with the check deposit form with the IDIS number and correct fund and account number for deposit. 3. Once the County Auditor posts the receipt to the County’s general ledger, the Fiscal Officer records the Auditor’s receipt into HUD’s IDIS Online reporting system. 4. At the close of each quarter, the Fiscal Officer will prepare and submit the Cash on Hand Report within thirty days of the close of the quarter. The Fiscal Officer will reconcile all expenses and receipts posted in the County’s general ledger system with the receipts (report PR09) and drawdown requests (report PR07) in HUD’s IDIS Online reporting system. Before submitting the Cash on Hand Report in the IDIS Online system, the Deputy Director will review and approve the prepared reconciliation and Cash on Hand Report. Any discrepancies between the two systems will be reported to the Auditor and the Department Director to determine corrective actions. 5. Within 30 days of the close of each calendar quarter, the Fiscal Officer will submit the Cash on Hand Report via IDIS Online. The Fiscal Officer will maintain a copy of the Cash on Hand report and the corresponding reconciliation in their program files. 6. On an on-going basis, the Director will meet with Department staff to determine if training or technical assistance is needed to complete HUD reporting requirements in a timely and accurate manner. Anticipated Completion Date: A policy and procedure amendment will be written by the end of this year and presented to the Lake County Redevelopment Commission for their March 2025 meeting for adoption.
2022-006 Program: WIOA Cluster Federal Financial Assistance Listing Number: 17.258, 17.259, 17.277, 17.278 Federal Grantor: U.S. Department of Labor Pass-Through: California Department of Employment Development Award No. and Year: AA011008 and 2019 Compliance Requirements: Subrecipient Monitoring T...
2022-006 Program: WIOA Cluster Federal Financial Assistance Listing Number: 17.258, 17.259, 17.277, 17.278 Federal Grantor: U.S. Department of Labor Pass-Through: California Department of Employment Development Award No. and Year: AA011008 and 2019 Compliance Requirements: Subrecipient Monitoring Type of Finding: Material Weakness Management’s or Department’s Response: Imperial County Workforce Development Office (ICWDO) agrees with the finding. Views of Responsible Officials and Corrective Action Plan: The questions from finding 2021-008 relate to a formalization of the fiscal processes and protocols. ICWDO operates under WIOA guidelines and follows Imperial County’s fiscal policies. Internal policy will be formally updated to reflect compliance with WIOA regulations, as well as Imperial County policies. These policies will include formal controls and procedures to evaluate each subrecipient’s risk of noncompliance. Once the formal procedure is drafted, it will go through the ICWDO Policy Committee for comment and direction, and then finally reviewed and approved for implementation by the full Workforce Development Board. Additionally, for any future Memorandums of Understanding (MOUs) between this Imperial County department and any outside agency, there will be an additional step to include review by Imperial County Counsel to reflect that recital around the funding source will specify the following required information: • Federal Award Identification Number • Federal award date of award to recipient by the Federal agency • Name of Federal awarding agency • CFDA Number • Specific identification of whether the award is research and development ICWDO will develop internal policies for formalizing all subrecipient monitoring process. ICWDO operates under WIOA guidelines for monitoring; therefore a formal internal policy for future contracts will be developed and implemented using the usual review and approval procedures followed by the department. ICWDO will develop a formal internal documentation system, with appropriate checks and signatures, for the evaluation and assessment of each subrecipient’s risk of noncompliance. ICWDO will utilize this formal process to properly document the risk assessment of all subrecipients. ICWDO anticipates to implement the corrective action by December 31, 2023. Name of Responsible Person: Priscilla A Lopez, ICWDB Director Implementation Date: December 31, 2023
Responsible: Denice Hairston, Chief Quality, Compliance and Accountability Officer Corrective Actions: Update subrecipient award agreements to ensure the final approved scope of work or project description is specified. Completion Date: March 29, 2023 Explanation: Policies and procedures were ...
Responsible: Denice Hairston, Chief Quality, Compliance and Accountability Officer Corrective Actions: Update subrecipient award agreements to ensure the final approved scope of work or project description is specified. Completion Date: March 29, 2023 Explanation: Policies and procedures were updated in 2023 in response to an OJJDP/OCFO recommendation to ensure subaward files contain the requisite components for the award agreement. In addition to these updates, which include a master file checklist, National CASA/GAL has updated the subrecipient Terms & Conditions agreement to include CFR requirements as recommended.
Invoices that are received will be scanned to “invoices”. This will direct them to our electronic software, Docuware. The item will then be forwarded to the appropriate Program Director for approval, and they will indicate the appropriate cost centers / allocations. Bookers will then review the ap...
Invoices that are received will be scanned to “invoices”. This will direct them to our electronic software, Docuware. The item will then be forwarded to the appropriate Program Director for approval, and they will indicate the appropriate cost centers / allocations. Bookers will then review the approved coding and entered fiscal software. If there is a question or concern about approved coding by the bookkeeper they will speak with Director of Finance, Ethan Terrio. Once invoices are entered into fiscal software, checks will be printed. The check stub and invoice will be attached to each other and filed in the fiscal department. Paper documents will continue to be maintained in fiscal until we go 100% paperless, then all documents will be stored in Docuware.
View Audit 316102 Questioned Costs: $1
Finding 452400 (2022-010)
Significant Deficiency 2022
FINDING # 2022-010No finding in prior yearAs recommended, the DCA will review current procedures to ensure that all subaward information required by the federal Uniform Guidance is included in all subaward contracts and grant agreements. The DCA has also reviewed its current subrecipient monitoring...
FINDING # 2022-010No finding in prior yearAs recommended, the DCA will review current procedures to ensure that all subaward information required by the federal Uniform Guidance is included in all subaward contracts and grant agreements. The DCA has also reviewed its current subrecipient monitoring procedures for standard subawards made by the agency and has determined that no internal control enhancements are required. The HAF award was a unique grant relationship for DCA in that the entire award was passed through to another New Jersey State government agency that is a direct affiliate of the Department. Monitoring procedures were determined based on the close working relationship with our affiliate organization and the fact that less than 1 percent of the grant award was expended through June 30, 2022. Current procedures included a risk assessment of the subrecipient and performance of the single audit desk review of the independent audit report. In addition, the Director of Audit, and the Executive Director of the subgrantee affiliate participate in weekly meetings where updates on the program status can be determined. DCA?s subrecipient monitoring plan also includes the hiring of an Integrity Monitor to oversee and monitor the use of the HAF funds as well as compliance with all HAF program reporting requirements. As program disbursement activity is continuing to increase with the HAF program(s) created more fully up and running, DCA is currently targeting the Integrity Monitor hire to take place sometime within the next three to six months.COMPLETION DATE/CONTACT PERSON Fiscal Years 2023 and 2024John Alexy(609) 913.4385John.Alexy@dca.nj.gov
FINDING 2022-005Subject: Child Nutrition Cluster - Procurement and Suspension and DebarmentFederal Agency: Department of AgricultureFederal Programs: School Breakfast Program, COVID-19 ? School Breakfast Program, National SchoolLunch Program, COVID-19 ? National School Lunch Program, Summer Food Ser...
FINDING 2022-005Subject: Child Nutrition Cluster - Procurement and Suspension and DebarmentFederal Agency: Department of AgricultureFederal Programs: School Breakfast Program, COVID-19 ? School Breakfast Program, National SchoolLunch Program, COVID-19 ? National School Lunch Program, Summer Food Service Program, COVID-19 ?Summer Food Service ProgramALN Numbers: 10.553, 10.555, 10.559Federal Award Numbers and Years (or Other Identifying Numbers): FY21, FY22Pass-Through Entity: Indiana Department of EducationCompliance Requirements: Procurement and Suspension and DebarmentAudit Findings: Material Weakness, Other MattersContact Person Responsible for Corrective Action: Chad Yencer - SuperintendentContact Phone Number: 765-348-7550Views of Responsible Official: We concur with this findingDescription of Corrective Action Plan:BCS has established the following internal controls to ensure compliance:1. Internal Control: When a purchase is made at $10,000 or more using Federal Funds, thesuperintendent will require that any vendors selected are in compliance with theProcurement and Suspension and Debarment compliance requirement by completing one ofthe following quality checks with each vendor prior to purchase:a. Checking the federal System for Award Management (SAM) database athttps://sam.gov/content/exclusions and maintain a screenshot of the search results.b. Collect a certification from the vendor directlyc. Add a clause or condition to the covered transaction with the vendorAnticipated Completion Date:This corrective action will be implemented and completed immediately with any purchase made that meets theabove threshold.
FINDING 2022-002Contact Person Responsible for Corrective Action: Janetta C HardyContact Phone Number: 812-752-4343 X222Views of Responsible Official:I concur with the finding.Description of Corrective Action Plan:In April of 2022 the City of Scottsburg?s annual reporting of COVID 19 ? State and Loc...
FINDING 2022-002Contact Person Responsible for Corrective Action: Janetta C HardyContact Phone Number: 812-752-4343 X222Views of Responsible Official:I concur with the finding.Description of Corrective Action Plan:In April of 2022 the City of Scottsburg?s annual reporting of COVID 19 ? State and Local Fiscal RecoveryFunds for 2021 provided the Common Council?s allocated expenditures for the reporting period instead ofactual expenditures for the reporting period. This error was corrected in the 2023 reporting for April 1,2022 ? Mar 31, 2023 expenditures. However the cumulative obligations and the current periodobligations were again reported as the total grant award. This will be corrected in the April 2024reporting.In regards to this finding, as clerk treasurer I reviewed the report created by Tish Richey and submittedwith inaccurate numbers. I qualify this under human error, commonly known as a mistake. In the future, Iwill do my best to not make a mistake in reporting and retain the initialed documentation for what issubmitted. Lastly, this was the first year for federal reporting of these funds and the instructions wereambiguous at best.Anticipated Completion Date: April 2024
« 1 9 10 12 13 16 »