Corrective Action Plans

Browse how organizations respond to audit findings

Total CAPs
48,663
In database
Filtered Results
8,482
Matching current filters
Showing Page
218 of 340
25 per page

Filters

Clear
Condition: The Organization’s controls in place for reporting submissions did not identify that the General and Targeted Distribution Post-Payment Notice of Reporting Requirements guidelines were not followed related to expense amounts reported in the Organization’s period 2 portal submissions. P...
Condition: The Organization’s controls in place for reporting submissions did not identify that the General and Targeted Distribution Post-Payment Notice of Reporting Requirements guidelines were not followed related to expense amounts reported in the Organization’s period 2 portal submissions. Planned Corrective Action: The Organization will review its processes surrounding the quantification of expenses reported and will implement additional levels of review to ensure that the expense amounts are validated for future reporting periods. Contact person responsible for corrective action: Tom Garvey, Interim CFO Anticipated Completion Date: 9/30/2023
View Audit 316928 Questioned Costs: $1
Condition: The Organization’s lacked effective controls to ensure documentation for expenses reported within the Organization’s period 2 portal submission were retained. The Organization was able to produce documentation for total expenses of $7,516,920, while the Organization had reporting to HRSA ...
Condition: The Organization’s lacked effective controls to ensure documentation for expenses reported within the Organization’s period 2 portal submission were retained. The Organization was able to produce documentation for total expenses of $7,516,920, while the Organization had reporting to HRSA that it had incurred $8,509,978 of expenses. As a result, the Organization was unable to provide support for $993,058 of the total expenses reported. Planned Corrective Action: The Organization will review its processes surrounding the retention of documentation used to report expenses and will implement additional levels of review to ensure that the proper documentation is retained for future reporting period portal submissions. Contact person responsible for corrective action: Tom Garvey, Interim CFO Anticipated Completion Date: 9/30/2023
View Audit 316928 Questioned Costs: $1
Finding 480686 (2022-001)
Significant Deficiency 2022
Finding 2022-001 – Special Education Cluster – AL No.’s 84.027 & 84.173 Department of Education Massachusetts Department of Elementary and Secondary Education and the Massachusetts Department of Early Education and Care Noncompliance and Significant Deficiency Relat...
Finding 2022-001 – Special Education Cluster – AL No.’s 84.027 & 84.173 Department of Education Massachusetts Department of Elementary and Secondary Education and the Massachusetts Department of Early Education and Care Noncompliance and Significant Deficiency Related to Internal Control over Compliance of the Major Programs Criteria: Grantees must provide reasonable assurance that federal awards are expended only for allowable activities and that the costs of goods and services charged to federal awards are allowable and in accordance with the applicable cost principles. Management of the Town is also responsible for establishing and maintaining effective internal control over compliance with federal requirements that have a direct and material effect on a federal program. A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, noncompliance with a type of compliance requirement of a federal program on a timely basis. Condition and Context: Control deficiencies related to disbursements were noted as a result of the testing of internal controls over payroll. Specifically, a sample of payroll disbursements charged to the programs were tested in order to determine if adequate internal controls were in place. As a result of the testing of payroll disbursements charged to the programs, all of the employees tested were found to not have adequately approved employee payroll rate agreements. Cause: Weaknesses in the design and operation of controls. Effect or Potential Effect: Due to the weaknesses in internal controls noted above, there is a risk of inappropriate salaries and wages being paid. Identification as a Repeat Finding: Yes, finding number 2021-001 Questioned Costs: Questioned costs are reported equal to $256,796.58, calculated as payroll charged to the programs. Recommendation: The Town should improve internal controls over Activities Allowed/Allowable Costs by ensuring employee’s payroll rate agreements are approved by an appropriate level of management and in a timely manner. Managements Response: Though we believe that Finding 2022-001occured due to staff turnover at the time of the rate agreement approval, the Town and the Schools will assure federal awards are expended only for allowable activities. Consistent with State and Federal requirements and as in Acushnet’s updated Federal Grant Procedures Manual (February 2023), the Town will maintain source documentation (invoices, time sheets, payroll stubs, etc.) – including approved payroll rate agreements – that support federal expenditures. Responsible for Corrective Plan: Patrick McIntyre, School Business Manager Estimated Completion Date: Fiscal Year 2023 Action Taken: All employee’s payroll rate agreements are approved by an appropriate level of management and in a timely manner.
View Audit 316915 Questioned Costs: $1
2022-006 – Allowable Costs Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Immunization Cooperation Agreements Assistance Listing Number: 93.268 Federal Award Identification Number and Year: FY 21/22 and 22/23 Pass-Through Agency: Pennsylvania Department of Health...
2022-006 – Allowable Costs Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Immunization Cooperation Agreements Assistance Listing Number: 93.268 Federal Award Identification Number and Year: FY 21/22 and 22/23 Pass-Through Agency: Pennsylvania Department of Health Pass-Through Number(s): None Award Period: 1/1/2022 – 12/31/22 Type of Finding: Material Weakness in Internal Control Over Compliance, Material Noncompliance (Modified Opinion) Condition and Context: While testing allowable costs relating to payroll expenditures, sixteen out of forty transactions were identified that could not be appropriately re-calculated per the amount that was charged to the grant. The County was not able to provide support for payroll expenditure amounts charged to the grant for part-time hourly employees. Recommendation: We recommend management should review the process of timekeeping for grant eligible employees for daily time input, as well as grant authorized wages. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: The Grant Accountant met with department staff to review the time tracking process for grant-eligible employees to ensure that all payroll expenditures charged to the grant are eligible, authorized, and charged on an individual employee basis. Project codes in Infor allow salary distribution and personnel information to be assigned to each grant. Where possible, this function is to assist in supporting the amounts charged to the grant program. The department will maintain documentation to support the amounts and allowability of the charges applied to the grant for payroll. The County is evaluating new time tracking systems to be implemented in 2025 that will allow for time tracking and reporting at a grant/program level. Name(s) of the contact person(s) responsible for corrective action: Thomas Landauer and Dean Dortone Planned completion date for corrective action plan: March 2025
View Audit 316613 Questioned Costs: $1
Finding #SA2022-008: Accurate Review and Payment of Vendor Reimbursement Requests Assistance Listing Number: 14.218 Assistance Listing Title: COVID-19 - Community Development Block Grants/Entitlement Grants Name of Federal Agency: Department of Housing and Urban Development Pass Through Entity...
Finding #SA2022-008: Accurate Review and Payment of Vendor Reimbursement Requests Assistance Listing Number: 14.218 Assistance Listing Title: COVID-19 - Community Development Block Grants/Entitlement Grants Name of Federal Agency: Department of Housing and Urban Development Pass Through Entity: San Joaquin County Community Development Department Federal Award Identification Number: A-93-916 • Name(s) of the contact person: Shay Narayan, Director of Finance; Carmen Gusman, Deputy Director of Finance • Corrective Action Plan: The City will develop procedures to ensure accurate review and payment of vendor reimbursement requests, including providing training to administrative staff as necessary. • Anticipated Completion Date: 06/30/24
View Audit 316559 Questioned Costs: $1
TINDLEY ACTION PLAN 1. Develop and implement Procurement Policy (completed and on-going by CFO/Accounting Manager/Accountant/Grants Manager/Network President/Department Heads) a. Enhance written procedures for procurement and accounts payable. i. Purchases between $15,000-$25,000 will require two qu...
TINDLEY ACTION PLAN 1. Develop and implement Procurement Policy (completed and on-going by CFO/Accounting Manager/Accountant/Grants Manager/Network President/Department Heads) a. Enhance written procedures for procurement and accounts payable. i. Purchases between $15,000-$25,000 will require two quotes for all new vendors; purchases between $25,000-$75,000 will require three quotes for all vendors; and purchases over $75,000 will require a competitive bid process for all vendors. ii. Establish a Master Vendor list. 1. Master Vendors may be used for up to $20,000 for regular services and products in the normal course of business with dual approval by the Network President and CFO. b. Require vendor bids/quotes for services. c. Segregate purchasing duties. 2. Research new vendors prior to utilization (implemented and ongoing by CFO/Accountant) a. Are these vendors commonly known in the industry or the community? b. Does the vendor have a valid website, phone number, address and email address? 3. Conduct Periodic/Continuous Fraud-Detection Monitoring (CFO – at every fiscal year end) a. Annually identify (1) Tindley’s top 20 vendors, (2) all Tindley vendors receiving annual payments totaling more than $10,000, and (3) any new vendors receiving annual payments totaling more than $5,000. i. Ensure there are valid and updated contracts for these vendors. ii. Ensure the description for services on the corresponding. invoices are detailed and complete. iii. Assess multiple corresponding invoices that have the same total amounts. 4. Refine and codify job descriptions/job duties for Network President, CFO, Grants & Compliance Manager, and Director of Development (HR/Board to be completed by 9/30/24) a. Keep these job descriptions in a database to ensure a smooth transition in the event of a departure or retirement. b. The job descriptions should highlight the financial compliance aspects of each position. 5. Change reporting structure for CFO (to be implemented by HR/Board 9/30/24) a. CFO will report directly to the Board with a dotted line to the Network President. 6. Provide anti-fraud training for Network President, CFO, Director of Development, Grants & Compliance Manager, and in-house accounting professionals (to be implemented by Network President/CFO and completed by 11/30/24) 7. Establish a Whistleblower/Ethics hotline to report suspected fraud (to be implemented by HR 9/30/24) a. Ensure employees understand that it is available to report suspected fraud. b. Develop procedures for responding to whistleblower allegations. PROCUREMENT POLICIES AND PROCEDURES I. INTRODUCTION AND PURPOSE Tindley should adhere to strict ethical and legal standards to prevent fraud and ensure accountability. This procurement policy should be cross-referenced with current local, state, and federal laws. II. CODE OF CONDUCT A. Conflict of Interest Tindley purchasers shall not participate in the selection, award, or administration of a contract if they have a real or apparent conflict of interest. Such a conflict arises when the Tindley purchaser; any immediate family member (spouse, child, parent, parent in law, sibling, or sibling in law); partner; or an organization that employs, or is about to employ, any of the above has a direct or indirect financial or other interest in, or will receive a tangible personal benefit from, a firm or individual considered for the contract award. An “organizational conflict of interest” is created because of a relationship that a Tindley employee has with a parent, affiliate, or subsidiary organization that is involved in the transaction such that the Tindley employee is or appears to be unable to be impartial in conducting a procurement action involving the related organization. B. Gifts, Money, Gratuities Tindley employees involved in the purchasing process shall not solicit or accept gifts, money, gratuities, favors, or anything of monetary value, except unsolicited items or services of nominal value from vendors, prospective vendors, parties to subcontracts, or any other person or entity that receives, or may receive compensation for providing goods or performing services to Tindley. All Tindley purchasers shall review and comply with Tindley’s procedures for disclosing, reviewing, and addressing actual and potential conflicts of interest. III. PROCUREMENT PROCEDURES A. Procurement Procedure See chart at the end of document B. Bid Procedures All procurement shall be conducted in a manner that provides, to the maximum extent practical, a full and open competition. Tindley bid procedures should always follow local, state, and federal requirements. Procurement Processes should include the following: 1. Assemble a Procurement Committee consisting of the Network President, CFO, Grant Manager, and the requestor of the product or service. i. In the event that the requestor of the product or service is the Network President, a Tindley Board member of the applicable committee that corresponds to the request will be asked to participate. 2. Pre-Bid Phase. i. If an outside vendor is needed to develop the bid specifications for a bid project, the vendor, or related parties to the vendor cannot participate in the bid. ii. The procurement committee should have specific criteria of the bid specifications including how bids will be judged based on price, quality, experience of vendors, etc. iii. All solicitations shall incorporate a clear and accurate description of the technical requirements for products or services to be procured. iv. Identify all requirements which offerors must fulfill and all other factors to be used in evaluating bids and proposals. v. If required by local, state, and or federal laws, Tindley should publicly announce in advance of projects that require a competitive bid process. vi. Vendors should not be allowed to interface with Tindley procurement committee members before any public bids are announced, and post-bid announcement, interactions should occur only as part of the formal bid process (questions and answers in writing, face-to-face walk-throughs, proposal phases, and actual bid submissions). 3. Bid Phase. i. All bidders should have adequate time to respond to a bid, including Q&A sessions, and a face-to-face walk-through if necessary. ii. The Tindley employee sending out bid packages including specifications, should not be the same person receiving the vendor bid submissions. iii. The Tindley employee receiving the bid submissions should time and date stamp each bid received and the committee should exclude any bids submitted after the bid deadline. iv. Tindley employees are forbidden to disclose to vendors information about other bidders, including bid proposal contents such as pricing. 4. Bid Selection Phase. i. The procurement committee should develop a bid template and checklist that ranks bids based on criteria developed by the committee and ensures bid procedures are followed. ii. If the procurement committee chooses the winning bid on criteria other than what is stated in the original specifications, the committee must document the reasons why. For example, if the winning bid was not the lowest price, the committee must justify in writing why the vendor was selected. C. Competition All procurement shall be conducted in a manner that provides, to the maximum extent practical, a full and open competition. 1. Procurements shall avoid noncompetitive practices that may restrict or eliminate competition, including but not limited to: a. Unreasonable qualification requirements. b. Unnecessary experience and excessive bonding requirements. c. Non-competitive pricing practices between firms or affiliated companies. d. Non-competitive contracts to consultants on retainer contracts e. Organizational conflicts of interest. f. Specifying “brand name” only instead of allowing “an equal to product.” 2. Procurements shall not intentionally split a single purchase into two or more separate purchases to avoid dollar thresholds that require more formal procurement methods. 3. Procurements shall include in any pre-qualified list an adequate number of current qualified vendors firms or products. 4. Procurements shall not preclude potential bidders from qualifying during the solicitation period. 5. Procurements shall not use any geographic preferences (state local or tribal) in the evaluation of bid proposals except where expressly mandated or encouraged by applicable federal statutes. 6. The procurement team must find, when possible, bidders to compete that were not provided by the Tindley requester. 7. The procurement committee must use independent judgment and notify the Board of Directors and ethics hotline if the requester of products or services is attempting to use undue influence for the team to select specific vendors. D. Considerations Tindley purchasers should take the following actions when procuring goods and services. 1. Conduct a lease versus purchase analysis when appropriate, including for property and large equipment. 2. Consolidate or break out procurements to obtain a more economical purchase if possible. 3. Use state and local intergovernmental or inter-entity agreements, or common or shared goods and services, where appropriate. 4. Use federal excess and surplus property in lieu of purchasing new equipment and property if it is feasible and reduces project costs. 5. Use time and materials contracts only if no other contract is suitable and the contract includes a ceiling price that the contractor exceeds at their own risk. If such a contract is negotiated and awarded, Tindley must assert a high degree of oversight to obtain reasonable assurance that the contractor is using efficient methods and effective cost controls. IV. PROCUREMENT METHODS A. All procurements made under this policy shall: 1. Be necessary, at a reasonable cost, documented, not prohibited by law or the applicable funding source, and made in accordance with this policy. 2. Avoid acquiring unnecessary or duplicative items. 3. Engage responsible vendors who possess the ability to perform successfully under the terms and conditions of a proposed procurement. 4. Tindley purchasers shall consider vendor integrity, public policy compliance, past performance record, and financial and technical resources. B. Procurement Parameters For all transactions, Tindley shall follow the applicable procurement method set forth in Appendix 1 C. Exceptions to Standards Methods Solicitation of a proposal from a single source may only be used if the following apply and are documented: 1. The item is only available from single source. 2. Public exigency or emergency will not permit any delay. 3. The Federal awarding agency or pass-through expressly authorizes the sole source in response to a Tindley request. 4. After soliciting a number of sources, competition is determined inadequate. V. DOCUMENTATION A. Records Tindley shall maintain records sufficient to detail the history of each procurement transaction. These records must include, but are not limited to: 1. A description and supporting documentation showing the rationale for the procurement method (e.g., cost estimates). 2. Selection of contract type. 3. Written price or rate quotations (such as catalog price, online price, e-mail or written quote), if applicable. 4. Copies of advertisements, requests for proposals, bid sheets or bid proposal packets. 5. Reasons for vendor selection or rejection, including Finance Committee and Board Minutes, rejection letters, and award letters. 6. And the basis for the contract price. VI. COMPLIANCE WITH THIS POLICY Program directors and, where applicable, the purchasing committee, shall maintain oversight to ensure that contractors and vendors perform in accordance with the terms, conditions, and specifications of contracts or purchase orders. Violations of this policy may result in disciplinary action, up to and including termination. VII. VENDOR SELECTION CRITERIA For vendors that have been selected in a competitive bid or that will provide critical services to the school, Tindley should evaluate them based on cost, quality, past performance, experience, and financial stability. Before providing services or products, the selected vendor can be asked to provide references, allow for background checks, and provide documentation such as certificate of insurance, certificate standing, adherence to anti-fraud policies, and contracts with right-toaudit clauses.
View Audit 316515 Questioned Costs: $1
The Organization has taken steps to ensure that the calculation of indirect costs is executed properly and reviewed for compliance in accordance with the contract agreement. Management brought the error in the contracted indirect rate to the funders attention initially, but unfortunately a misstep b...
The Organization has taken steps to ensure that the calculation of indirect costs is executed properly and reviewed for compliance in accordance with the contract agreement. Management brought the error in the contracted indirect rate to the funders attention initially, but unfortunately a misstep back to the original contract terms was made before close-out. The development and application of indirect rates will be conducted by the Sr. Director of Finance with oversight by the Chief Financial & Operating Officer and is in place as of the date of this corrective action plan.
View Audit 316339 Questioned Costs: $1
Management acknowledges that it is necessary to more specifically itemize employee time that is applicable to the federal grants and contracts that partially fund broad programs and services and has instituted infrastructure to ensure that this is done and documented correctly in the future. The nec...
Management acknowledges that it is necessary to more specifically itemize employee time that is applicable to the federal grants and contracts that partially fund broad programs and services and has instituted infrastructure to ensure that this is done and documented correctly in the future. The necessary codes are in place in our payroll system and guidance and leadership of the timesheet process will be provided by all program executives (EVP, VP) to all staff that are impacted, with oversight by the Chief Financial & Operating Officer and Sr. Director of Finance. This is in place as of the date of this corrective action plan.
View Audit 316339 Questioned Costs: $1
All SEFA grants will be tracked thoroughly in FundEZ and annotated with their own cost center code to allow tracking them to be easier. The Director of Finance, Ethan Terrio, will reconcile these awards and expenses once a month to ensure that the numbers tie out in the general ledger. Should there ...
All SEFA grants will be tracked thoroughly in FundEZ and annotated with their own cost center code to allow tracking them to be easier. The Director of Finance, Ethan Terrio, will reconcile these awards and expenses once a month to ensure that the numbers tie out in the general ledger. Should there be any issues, he will contact the respective Division Director, either Susan Cody or Roxane Carpenter, to determine the cause of the variance, and how to correct the entry to be accurate.
View Audit 316102 Questioned Costs: $1
Finding 2022-001 – Education Stabilization Fund – AL No.’s 84.425D & 84.425U Department of Education Massachusetts Department of Elementary and Secondary Education Noncompliance and Significant Deficiency Related to Internal Control over Compliance of the Major Programs Criter...
Finding 2022-001 – Education Stabilization Fund – AL No.’s 84.425D & 84.425U Department of Education Massachusetts Department of Elementary and Secondary Education Noncompliance and Significant Deficiency Related to Internal Control over Compliance of the Major Programs Criteria: Grantees must provide reasonable assurance that federal awards are expended only for allowable activities and that the costs of goods and services charged to federal awards are allowable and in accordance with the applicable cost principles. Management of the Town is also responsible for establishing and maintaining effective internal control over compliance with federal requirements that have a direct and material effect on a federal program. A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, noncompliance with a type of compliance requirement of a federal program on a timely basis. Condition and Context: Control deficiencies related to disbursements were noted as a result of the testing of internal controls over payroll. Specifically, a sample of payroll disbursements charged to the Accelerated Literacy Learning Grant were tested in order to determine if adequate internal controls were in place. As a result of the testing of payroll disbursements charged to the programs, employees tested were found to not have adequately approved and or documented employee payroll rate agreements. Cause: The School Department failed to produce copies of documented appointment letters to support pay rates of pay and/or wages paid. Effect or Potential Effect: Due to the weaknesses in internal controls noted above, there is a risk of inappropriate rate of pay and/or wages being paid. Identification as a Repeat Finding: N/A Questioned Costs: Questioned costs could not be determined. Recommendation: The Town should improve internal controls over Activities Allowed/Allowable Costs by ensuring employee’s payroll rate agreements are approved by an appropriate level of management and in a timely manner. Responsible for Corrective Plan: Director of Finance, Schools Estimated Completion Date: March 2024 Action Taken: School management will ensure that documented appointment letters from management will support payments.
Finding 2022-003 – Education Stabilization Fund – AL No.’s 84.425D & 84.425U Department of Education Massachusetts Department of Elementary and Secondary Education Noncompliance and Significant Deficiency Related to Internal Control over Compliance of the Major Programs Conditi...
Finding 2022-003 – Education Stabilization Fund – AL No.’s 84.425D & 84.425U Department of Education Massachusetts Department of Elementary and Secondary Education Noncompliance and Significant Deficiency Related to Internal Control over Compliance of the Major Programs Condition: During our test of controls over compliance it was noted that payroll for Nurses was posted to the Education Stabilization ESSER II major program grant, however an English Language Learning Teacher was charged to the Education Stabilization ESSER II major program grant, however not included as part of the original or amended grant application. Criteria: Costs charged to the Education Stabilization ESSER II major program should meet the requirements as set forth by Uniform Guidance 2 CFR Part 200, subpart E (Cost Principles). Context: During our review of payroll transactions posted to the Education Stabilization ESSER II major program it was noted that an English Language Learning Teacher was charged to the Education Stabilization ESSER II major program grant and was not included as part of the original or amended grant application. Effect: Town of Bellingham was not in compliance with the allowable costs/ cost principals requirement as set forth by the Uniform Guidance 2 CFR Part 200, subpart E (Cost Principles). Questioned Costs: Could not be determined. Cause: Amendments to the grant were not posted at the time of change. Identification as a Repeat Finding: N/A Recommendation: We recommend the Town of Bellingham follow procedures to ensure that expenditures charged to the grants are allowable costs as set forth by Uniform Guidance 2 CFR Part 200, subpart E (Cost Principles) Responsible for Corrective Plan: Director of Finance, Schools Estimated Completion Date: March 2024 Action Taken: Management will ensure that all amendments are processed at the time of the occurrence.
2022-010 Moving to Work Demonstration Program – Assistance Listing No. 14.881 Recommendation: We recommend management review the record-keeping practices to ensure that personnel documentation related to employee pay rates can be easily accessed. Explanation of disagreement with audit finding: Th...
2022-010 Moving to Work Demonstration Program – Assistance Listing No. 14.881 Recommendation: We recommend management review the record-keeping practices to ensure that personnel documentation related to employee pay rates can be easily accessed. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken or planned in response to finding: In 2024 the Authority converted to the Kronos Pro payroll system, and is utilizing the software to its fullest capacity. This conversion will ensure that personnel documentation related to employee pay rates can be easily accessed and is audit-ready. The OFM shall include quality monitoring in its updated policies and procedures. The OAC shall oversee the quality monitoring process quarterly. Name of the contact person responsible for corrective action: Heather Mueller Planned completion date for corrective action plan: 9/30/2024.
View Audit 315592 Questioned Costs: $1
Federal Program Education Stabilization Fund - Passed through the Pennsylvania Department of Education COVID-19 - Governor's Emergency Education Relief Fund ALN 84.425C; Contract #252-20-0141; Grant Period 03/13/20 - 09/30/22 COVID-19 - Elementary and Secondary School Emergency Relief Fund (ESSER II...
Federal Program Education Stabilization Fund - Passed through the Pennsylvania Department of Education COVID-19 - Governor's Emergency Education Relief Fund ALN 84.425C; Contract #252-20-0141; Grant Period 03/13/20 - 09/30/22 COVID-19 - Elementary and Secondary School Emergency Relief Fund (ESSER II) ALN 84.425D; Contract #200- 21-0141; Grant Period 03/13/20 - 09/30/23 COVID-19 - ARP ESSER ALN 84.425U; Contract #223-21-0141; Grant Period 03/13/20 - 09/30/24 COVID-19 - ARP ESSER After School Set Aside ALN 84.425U; Contract #225-21-0141; Grant Period 03/13/20 - 09/30/24 Criteria In accordance with Uniform Guidance cost principles, the District is not allowed to charge costs to a grant that are reimbursed by another funding source. Condition The District charged over 100% of the employer paid retirement costs to the grants. The Pennsylvania Department of Education (PDE) reimburses the District approximately 55% of the retirement costs annually. As a result, the District is only permitted to charge the unreimbursed 45% of retirement costs to the grants. Cause The District did not have the review procedures in place to identify the errors in journal entries or to monitor that only 45% of the retirement costs were allowed to be charged to the grants. Effect Unallowable costs were charged to the grants. Questioned Costs ALN 84.425C; Contract #252-20-0141 - $2,373 ALN 84.425D; Contract #200-21-0141 - $78,902 ALN 84.425U; Contract #223-21-0141- $44,757 ALN 84.425U; Contract #225-21-0141 - $250 Context Total retirement costs associated with the salaries charged to the grants was $206,218. Of this amount approximately 55% was reimbursed by PDE, leaving $92,798 allowed to be charged to the grants. The District charged a total of $219,080 retirement expense to the grants, resulting in $126,282 unallowable costs charged to the grants. Repeat Finding No. Recommendation We recommend the District identify all funding streams and have a process in place to ensure that allowable costs are only charged to one funding stream. We also recommend a procedure to be put in place to have a person independent of report preparation review cost reports and underlying expenditures. Management Response Exeter Township School District had turnover in their business office including the Assistant Business Manager, Payroll Clerk, and Accountant positions during FY22 and first part of FY23. All of these positions have been replaced with new hires and training has been provided to all, as well as creating backups for all of these positions. The new assistant Business Manager is undergoing training in grant management, allowable costs, funding streams and report preparation. The Business Administrator will review all cost reports including detailed backup before the report is submitted to make sure only allowable costs are submitted. Exeter Township has additional allowable expenditures that can be charged to the grants to replace the unallowed costs. These expenditures were within the grant period and can be reclassified for contracts: 252-20-0141 and 200-21-0141. For contracts 223-21-0141 and 225-21-0141 the grant period is still in process and the unallowed costs will be replaced with allowed costs.
View Audit 315563 Questioned Costs: $1
Recommendation: We recommend the Coalition continuously monitor its expenditures of federal funds and begin the process of engaging an Auditor in a timely manner when the Coalition is aware that it will exceed the threshold triggering a single audit. Views of Responsible Officials: Per management,...
Recommendation: We recommend the Coalition continuously monitor its expenditures of federal funds and begin the process of engaging an Auditor in a timely manner when the Coalition is aware that it will exceed the threshold triggering a single audit. Views of Responsible Officials: Per management, they will make it a priority to be aware of all deadlines related to the submission of quarterly and annual reports for federal awards and submit these on time.
Recommendation: We recommend the Coalition develop additional policies and procedures that ensure all reporting requirements are met on an annual basis. If the Coalition lacks sufficient internal resources, they should consult with an external resource to draft the procurement policy. Views of Res...
Recommendation: We recommend the Coalition develop additional policies and procedures that ensure all reporting requirements are met on an annual basis. If the Coalition lacks sufficient internal resources, they should consult with an external resource to draft the procurement policy. Views of Responsible Officials: Per management, they will make it a priority to be aware of all deadlines related to the submission of quarterly and annual reports for federal awards and submit these on time.
➢ 2022-003 Compliance Deficiencies, (General Ledger): The organization agrees and has transitioned from the rarely used Abila system of FY 2022 to the QuickBooks automated system. This allowed the Accounting Manager to record expenditures in the General Ledger as well as update and restructure our ...
➢ 2022-003 Compliance Deficiencies, (General Ledger): The organization agrees and has transitioned from the rarely used Abila system of FY 2022 to the QuickBooks automated system. This allowed the Accounting Manager to record expenditures in the General Ledger as well as update and restructure our Chart of Accounts. In addition, the Accounting Manager has assigned project codes that facilitate segregation between restricted and unrestricted accounts. Our Executive Team has also worked with the Payroll provider, One Digital, to update our Time and Effort system to ensure accurate reporting of employee time. This ensures that time is captured and charged to the correct program. The following summary represents procedural updates to our General Ledger and Chart of Accounts: Opening/Closing the General Ledger: 1. The Accounting Manager accesses Quickbooks. a. Process: Go to (B-D) below. b. Select Account and Settings c. Advances d. Accounting e. The first month of the fiscal year “January” f. First month of revenue tax year “same as the fiscal year” g. Accounting Method – “Accrual” h. Close the books “1/31/2022” Example i. Allow changes are viewing a warning and SAVE. Financial Statements: At the request of the Chief Executive Officer, the Accounting Manager prepares a monthly Balance Sheet and Profit and Loss statements which are available with Quickbooks. This is shared with the Board at its monthly meeting. Bank Reconciliation: 2. The Accounting Manager prepares the monthly bank reconciliation through the Quick Books “Reconcile” tab. Updated Via Hope Chart of Accounts: Revenue 80110 Amplify Austin 80115 Fees & Registrations 80120 Contributions 80125 Indirect Revenue 80130 Sales 80135 Grant Other Income Total Revenue Gross Profit Expenditures 60000 Payroll and Benefits 60101 Fringe Transfer 60102 Payroll - 401K 60103 Payroll - Benefits 60104 Payroll - Fees 60105 Payroll - Legal 60106 Payroll - Social Security and Other Taxes 60107 Payroll - W/C 60108 Payroll - Wages 60110 Wage Transfer 60111 Wages - Other Total 60000 Payroll and Benefits 60112 Payroll Fee 66106 Social Security and Other Taxes 70101 Bank Fees 70102 Chargebacks 70200 Contractors 70201 Apprentice 70202 Certification 70203 Consultant 70204 Consultant (RI) 70205 Contract Training 70206 Evaluation 70207 Labor - Payroll 70208 Placement Services 70209 Stipend 70210 Supervisor 70211 Workshop Total 70200 Contractors 70301 Donation 70305 Equipment 70401 Memberships & subscriptions 70501 Professional Fees 70502 Insurance 70600 Operating Supplies 70601 Postage and Shipping 70602 Printing/Fax 70603 Supplies Total 70600 Operating Supplies 70700 Travel and Other 70701 Airlines 70702 Events 70703 Lodging 70704 Meals/Catering 70705 Travel Total 70700 Travel and Other 70801 Libraries for Health 70805 Marketing 70810 Recovery Institute 70815 Scholarships 70820 Storage 70825 Training 70835 Utilities 70840 Website 70850 Miscellaneous 70855 Software Total Expenditures Net Operating Revenue Net Revenue This represents a summary of the corrective steps taken to strengthen our internal controls and satisfy auditor findings. 3. Attached is a listing of our current chart of Accounts:
View Audit 315276 Questioned Costs: $1
2022-003 Reporting U.S. Department of Treasury Recommendation: We recommend the County implement internal control to ensure that reporting requirements are performed. Explanation of disagreement with audit finding: There are no disagreement with the audit finding. Action planned/taken in respo...
2022-003 Reporting U.S. Department of Treasury Recommendation: We recommend the County implement internal control to ensure that reporting requirements are performed. Explanation of disagreement with audit finding: There are no disagreement with the audit finding. Action planned/taken in response to finding: The County will identify all federal awards that financial reporting is required. Once programs subject to financial reporting are identified, the County will then determine what financial reports are required to be prepared and submitted. Name(s) of the contact person(s) responsible for corrective action: Debi Reynolds Planned completion date for corrective action plan: June 30, 2024
1. All related administrative and program operational costs have been appropriately classified and documented in QuickBooks beginning in March 2022. 2. Monthly review of administrative and program operational costs is performed by management and grant awarders.
1. All related administrative and program operational costs have been appropriately classified and documented in QuickBooks beginning in March 2022. 2. Monthly review of administrative and program operational costs is performed by management and grant awarders.
View Audit 315179 Questioned Costs: $1
1. Processes related to the program stating roles of each individual involved in the process were documented and implemented in September 2022. 2. Regular risk assessment and monitoring functions are performed by management and grant awarders.
1. Processes related to the program stating roles of each individual involved in the process were documented and implemented in September 2022. 2. Regular risk assessment and monitoring functions are performed by management and grant awarders.
Corrective Action Planned: The City has engaged a Certified Public Accountant (CPA) to prepare the fiscal year 2023 annual financial report and an audit firm to perform the fiscal year 2023 audit, which is expected to be completed in summer 2024. Name(s) of Contact Person(s) Responsible for Correct...
Corrective Action Planned: The City has engaged a Certified Public Accountant (CPA) to prepare the fiscal year 2023 annual financial report and an audit firm to perform the fiscal year 2023 audit, which is expected to be completed in summer 2024. Name(s) of Contact Person(s) Responsible for Corrective Action: City Clerk, Kami Hoerning. City Treasurer, Karen Kipp. City Mayor, John McGinley. Anticipated Completion Date: Summer 2024
Corrective Action Planned: The City Clerk and Mayor, with help from the Treasurer, will develop and implement documented procurement procedures that conform to the procurement standards relating to Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principle...
Corrective Action Planned: The City Clerk and Mayor, with help from the Treasurer, will develop and implement documented procurement procedures that conform to the procurement standards relating to Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) 200.317 through 200.327 Name(s) of Contact Person(s) Responsible for Corrective Action: City Clerk, Kami Hoerning. City Treasurer, Karen Kipp. City Mayor, John McGinley. Anticipated Completion Date: Summer 2024
Following the completion of the 2021 Single Audit, we adjusted the Organization's Accounting Policies & Procedure Manual to include detailed information outlined in HUD's electronic Line of Credit Control System (eLOCCS) inclusive of the roles and responsibilities of the system's Users and Approving...
Following the completion of the 2021 Single Audit, we adjusted the Organization's Accounting Policies & Procedure Manual to include detailed information outlined in HUD's electronic Line of Credit Control System (eLOCCS) inclusive of the roles and responsibilities of the system's Users and Approving Official. Specifically, Accounting Department Leadership (i.e., the Chief Financial Officer), designated accounting personnel (i.e., Accountants), and/or agency Executive Leadership (i.e., CEO/Executive Director), must be cognizant of a grant's period of performance.
View Audit 315097 Questioned Costs: $1
Individual(s) Responsible: Rob Coverdale, Superintendent; Anthony Barker, Business Manager Action: Review Policies and Procedures to ensure that management has implemented control processes to comply with the federal requirements and can provide documentation to support the transactions. Anticipated...
Individual(s) Responsible: Rob Coverdale, Superintendent; Anthony Barker, Business Manager Action: Review Policies and Procedures to ensure that management has implemented control processes to comply with the federal requirements and can provide documentation to support the transactions. Anticipated Completion Date: September 30, 2024
Individual(s) Responsible: Anthony Barker, Business Manager; Business Office Personnel Action: Adequate documentation will be retained in order to support the review process. Anticipated Completion Date: June 30, 2024
Individual(s) Responsible: Anthony Barker, Business Manager; Business Office Personnel Action: Adequate documentation will be retained in order to support the review process. Anticipated Completion Date: June 30, 2024
View Audit 314870 Questioned Costs: $1
Finding 478017 (2022-008)
Significant Deficiency 2022
Audit Finding Reference: 2022-008 Improve Internal Controls Over Reporting (Significant Deficiency) Planned Corrective Action: The City contracted with a third party to report our COVID spending. The City was made aware of the discrepancy and will use MUNIS in the future to validate expenses accor...
Audit Finding Reference: 2022-008 Improve Internal Controls Over Reporting (Significant Deficiency) Planned Corrective Action: The City contracted with a third party to report our COVID spending. The City was made aware of the discrepancy and will use MUNIS in the future to validate expenses accordingly. Completion Date Stephen T. Spencer, City of Lynn Comptroller December 31, 2024
« 1 216 217 219 220 340 »