2 CFR ? 1000 gives regulatory effect to the United States Department of Treasury for 2 CFR ? 200.328 and 329 which states, in part, that unless otherwise approved by OMB, the Federal awarding agency must solicit only the OMB-approved governmentwide data elements for collection of financial information at time of publication the Federal Financial Report or such future, OMB-approved, governmentwide data elements available from the OMB-designated standards lead. This information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly. Additionally, program-specific reporting requirements under the Emergency Rental Assistance Program 1 & 2 (ERA) and State and Local Fiscal Recovery Funds (SLFRF), requires all ERA and SLFRF grantees must submit quarterly reports with reporting periods of one calendar quarter and several cumulative fields covering all activity from the date of award through the quarter close. The key line items in the form are: 1. The cumulative amount obligated by the grantee; and 2. The cumulative amount expended by the grantee Additionally, 2 CFR Subpart F ? 200.510(b) requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the County?s financial statements which must include the total federal awards expended as determined in accordance with ? 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in ? 200.414 Indirect (F&A) costs. Testing over the County's quarterly reporting requirements for the ERA program identified the following: "See Schedule of Findings for table" Furthermore, testing over the County's quarterly reporting requirements for the SLFRF program identified the following: "See Schedule of Findings for table" Furthermore, the lack of effective controls over this compliance requirement resulted in the Schedule being misstated. As a result of the cumulative expenditure amounts being incorrectly reported for the SLFRF program, the County's Schedule of Expenditures of Federal Awards (Schedule) was overstated by $3,091,886. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. County management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The County should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the County is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
2 CFR ? 1000 gives regulatory effect to the United States Department of Treasury for 2 CFR ? 200.328 and 329 which states, in part, that unless otherwise approved by OMB, the Federal awarding agency must solicit only the OMB-approved governmentwide data elements for collection of financial information at time of publication the Federal Financial Report or such future, OMB-approved, governmentwide data elements available from the OMB-designated standards lead. This information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly. Additionally, program-specific reporting requirements under the Emergency Rental Assistance Program 1 & 2 (ERA) and State and Local Fiscal Recovery Funds (SLFRF), requires all ERA and SLFRF grantees must submit quarterly reports with reporting periods of one calendar quarter and several cumulative fields covering all activity from the date of award through the quarter close. The key line items in the form are: 1. The cumulative amount obligated by the grantee; and 2. The cumulative amount expended by the grantee Additionally, 2 CFR Subpart F ? 200.510(b) requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the County?s financial statements which must include the total federal awards expended as determined in accordance with ? 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in ? 200.414 Indirect (F&A) costs. Testing over the County's quarterly reporting requirements for the ERA program identified the following: "See Schedule of Findings for table" Furthermore, testing over the County's quarterly reporting requirements for the SLFRF program identified the following: "See Schedule of Findings for table" Furthermore, the lack of effective controls over this compliance requirement resulted in the Schedule being misstated. As a result of the cumulative expenditure amounts being incorrectly reported for the SLFRF program, the County's Schedule of Expenditures of Federal Awards (Schedule) was overstated by $3,091,886. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. County management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The County should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the County is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
FINDING 2022-003 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Subrecipient Monitoring Federal Agency: Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Number or Year (or Other Identifying Number): CY2021 Compliance Requirement: Subrecipient Monitoring Audit Findings: Material Weakness, Modified Opinion Condition and Context The City received a total State and Local Fiscal Recovery Funds (SLFRF) allocation of $18,042,360. The City enlisted a non-profit, Heart City Health Center, Inc., to assist with public health information and paid them $50,000. The payment was made under the Responding to Public Health and Economic Impacts of COVID-19 eligible use category. Documentation to support the payment included an invoice from the Heart City Health Center, Inc., Board of Works Resolution 21-R-19, and Ordinance 5861. The Board of Works approved Resolution 21-R-19 on December 28, 2021. The resolution states in part, "Heart City Health Center is a separate legal entity from the City of Elkhart and as a separate legal entity, requires the formation of a subrecipient agreement to transfer funds from the City's ARPA Coronavirus State and Local Fiscal Recovery Funds allocation to Heart City Health . . . now, therefore be it resolved, the Board of Public Works approves Heart City Health Center Inc. as a subrecipient of fifty thousand dollars in ARPA state and local fiscal recovery funds, and authorizes the Department of Law to prepare an appropriates subrecipient agreement for execution by the Board of Works and Heart City Health Center Inc. for the purposes approved herein . . ." The City provided SLFRF award funds to the Heart City Health Center, Inc. to carry out a program on the City's behalf, making the Heart City Health Center, Inc. a subrecipient of the City, as noted in their resolution, and, therefore, subject to subrecipient monitoring. The City was unable provide a copy of the subaward agreement or other supporting documentation to show evaluation of the subrecipient's risk of noncompliance or monitoring activities demonstrating compliance with the subrecipient monitoring requirement. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.331(a) states in part: "Subrecipients. A subaward is for the purpose of carrying out a portion of a Federal award and creates a Federal assistance relationship with the subrecipient. . . . Characteristics which support the classification of the non-Federal entity as a subrecipient include when the non- Federal entity: (1) Determines who is eligible to receive what Federal assistance; (2) Has its performance measured in relation to whether objectives of a Federal program were met; (3) Has responsibility for programmatic decision-making; (4) Is responsible for adherence to applicable Federal program requirements specified in the Federal award; and . . ." 2 CFR 200.332 states in part: "All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward . . . (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in ? 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the passthrough entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the passthrough entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; (xii) Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per ? 200.414. (2) All requirements imposed by the pass-through entity on the subrecipient so that the Federal award is used in accordance with Federal statutes, regulations and the terms and conditions of the Federal award; (3) Any additional requirements that the pass-through entity imposes on the subrecipient in order for the pass-through entity to meet its own responsibility to the Federal awarding agency including identification of any required financial and performance reports; (4) (i) An approved federally recognized indirect cost rate negotiated between the subrecipient and the Federal Government. If no approved rate exists, the passthrough entity must determine the appropriate rate in collaboration with the subrecipient, which is either: (A) The negotiated indirect cost rate between the pass-through entity and the subrecipient; which can be based on a prior negotiated rate between a different PTE and the same subrecipient. If basing the rate on a previously negotiated rate, the pass-through entity is not required to collect information justifying this rate, but may elect to do so; (B) The de minimis indirect cost rate. (ii) The pass-through entity must not require use of a de minimis indirect cost rate if the subrecipient has a Federally approved rate. Subrecipients can elect to use the cost allocation method to account for indirect costs in accordance with ? 200.405(d). (5) A requirement that the subrecipient permit the pass-through entity and auditors to have access to the subrecipient's records and financial statements as necessary for the pass-through entity to meet the requirements of this part; and (6) Appropriate terms and conditions concerning closeout of the subaward. . . . (b) Evaluate each subrecipient's risk of noncompliance with Federal statues, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring . . . (d) Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved. Pass-through entity monitoring of the subrecipient must include: (1) Reviewing financial and performance reports required by the passthrough entity. (2) Following-up and ensuring that the subrecipient takes timely and appropriate action on all deficiencies pertaining to the Federal award provided to the subrecipient from the pass-through entity detected through audits, on-site reviews, and written confirmation from the subrecipient, highlighting the status of actions planned or taken to address Single Audit findings related to the particular subaward. (3) Issuing a management decision for applicable audit findings pertaining only to the Federal award provided to the subrecipient from the pass-through entity as required by ? 200.521. (4) The pass-through entity is responsible for resolving audit findings specifically related to the subaward and not responsible for resolving crosscutting findings. . . ." Cause The system of internal controls as established by management of the City was not properly designed nor implemented. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the City's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. The City was responsible for providing a subaward agreement and monitoring the nonprofit. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the City. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the City design and implement a proper system of internal controls and develop policies and procedures to ensure subrecipients are provided with an adequate subaward agreement and monitored as appropriate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Criteria: 2 CFR 200.332 notes, ?All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in ? 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; (xii) Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per ? 200.414. (2) All requirements imposed by the pass-through entity on the subrecipient so that the Federal award is used in accordance with Federal statutes, regulations and the terms and conditions of the Federal award; ?? Condition: For all four subawards selected for testing, the identification of the award being Research and Development (R&D) was not noted. Further, two of the four subawards selected for testing, had information missing from the subaward including (1) Recipient DUNS number (2) Unique Federal Award Identification Number (FAIN) (3) Assistance Listing number (4) Indirect Cost Rate. Lastly, one subaward did not include the following information: (a) Period of Performance of subaward (b) Amount of federal funds obligated and awarded (c) General terms and conditions of subaward (d) Federal award project description (e) Name of Federal awarding agency. Condition (Continued): We consider this condition to be an instance of noncompliance relating to the Subrecipient Monitoring compliance requirement. Statistical sampling was not used in making sample selections. Questioned Costs: N/A. Cause and Effect: Without communication of the required information, subrecipients may overspend award amounts or incur unallowable expenses towards the grant. Recommendation: We recommend the Organization evaluates policies and procedures to ensure all required information is communication with the subrecipient. Views of Responsible Officials: Management agrees with this Single Audit Finding and response is included in the Corrective Action Plan.
Criteria: 2 CFR 200.332 notes, ?All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in ? 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; (xii) Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per ? 200.414. (2) All requirements imposed by the pass-through entity on the subrecipient so that the Federal award is used in accordance with Federal statutes, regulations and the terms and conditions of the Federal award; ?? Condition: For all four subawards selected for testing, the identification of the award being Research and Development (R&D) was not noted. Further, two of the four subawards selected for testing, had information missing from the subaward including (1) Recipient DUNS number (2) Unique Federal Award Identification Number (FAIN) (3) Assistance Listing number (4) Indirect Cost Rate. Lastly, one subaward did not include the following information: (a) Period of Performance of subaward (b) Amount of federal funds obligated and awarded (c) General terms and conditions of subaward (d) Federal award project description (e) Name of Federal awarding agency. Condition (Continued): We consider this condition to be an instance of noncompliance relating to the Subrecipient Monitoring compliance requirement. Statistical sampling was not used in making sample selections. Questioned Costs: N/A. Cause and Effect: Without communication of the required information, subrecipients may overspend award amounts or incur unallowable expenses towards the grant. Recommendation: We recommend the Organization evaluates policies and procedures to ensure all required information is communication with the subrecipient. Views of Responsible Officials: Management agrees with this Single Audit Finding and response is included in the Corrective Action Plan.
Criteria: 2 CFR 200.332 notes, ?All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification. (i) Subrecipient name (which must match the name associated with its unique entity identifier); (ii) Subrecipient's unique entity identifier; (iii) Federal Award Identification Number (FAIN); (iv) Federal Award Date (see the definition of Federal award date in ? 200.1 of this part) of award to the recipient by the Federal agency; (v) Subaward Period of Performance Start and End Date; (vi) Subaward Budget Period Start and End Date; (vii) Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; (viii) Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; (ix) Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; (x) Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); (xi) Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; (xii) Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; (xiii) Identification of whether the award is R&D; and (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per ? 200.414. (2) All requirements imposed by the pass-through entity on the subrecipient so that the Federal award is used in accordance with Federal statutes, regulations and the terms and conditions of the Federal award; ?? Condition: For all four subawards selected for testing, the identification of the award being Research and Development (R&D) was not noted. Further, two of the four subawards selected for testing, had information missing from the subaward including (1) Recipient DUNS number (2) Unique Federal Award Identification Number (FAIN) (3) Assistance Listing number (4) Indirect Cost Rate. Lastly, one subaward did not include the following information: (a) Period of Performance of subaward (b) Amount of federal funds obligated and awarded (c) General terms and conditions of subaward (d) Federal award project description (e) Name of Federal awarding agency. Condition (Continued): We consider this condition to be an instance of noncompliance relating to the Subrecipient Monitoring compliance requirement. Statistical sampling was not used in making sample selections. Questioned Costs: N/A. Cause and Effect: Without communication of the required information, subrecipients may overspend award amounts or incur unallowable expenses towards the grant. Recommendation: We recommend the Organization evaluates policies and procedures to ensure all required information is communication with the subrecipient. Views of Responsible Officials: Management agrees with this Single Audit Finding and response is included in the Corrective Action Plan.
Finding 2022-001 – Allowable Costs Federal Agency: U.S. Department of Health and Human Services Federal Program title: Health Center Program Cluster Assistance Listing Number: 93.224 and 93.527 Federal Award Identification Number: H80CS00834-20; H80CS00834-21; H8FCS40554-01 Award Periods: March 1, 2021 – February 28, 2022; March 1, 2022 – February 28, 2023; April 1, 2021 - March 31, 2023, respectively Type of Finding: Significant deficiency in internal control over compliance Criteria: Appendix IV to Part 200—Indirect (F&A) Costs Identification and Assignment, and Rate Determination for Nonprofit Organizations - Section C. Negotiation and Approval of Indirect Cost Rates - Subsection 2. Negotiation and approval of Rates - Clause "c:" Unless approved by the cognizant agency for indirect costs in accordance with § 200.414(g), organizations that have previously established indirect cost rates must submit a new indirect cost proposal to the cognizant agency for indirect costs within six months after the close of each fiscal year; and Clause "g:" The results of each negotiation must be formalized in a written agreement between the cognizant agency for indirect costs and the nonprofit organization. The cognizant agency for indirect costs must make available copies of the agreement to all concerned Federal agencies. Condition: ACCESS requested reimbursement of indirect costs during a six-month period in which its indirect cost rate had expired. Questioned Costs: None. Context: ACCESS’ indirect cost rate expired on June 30, 2022, however, the Organization did not request an extension until October 2022. In January 2023, ACCESS received a response to its extension request in which it was denied with the cited reason being that the indirect cost rate was no longer current. The Organization subsequently submitted an indirect cost rate proposal in January 2023 and in May 2023 the Cognizant agency for indirect costs (the Agency) did provide written notice to ACCESS that it could continue using its previous indirect cost rate until the Agency completed its review of the proposal and a new rate was established. Cause: Oversight. Effect: Unallowable indirect costs could be charged to a grant if the organization does not submit an updated indirect cost rate agreement application within a timely manner. Repeat Finding: No. Recommendation: Management should refine its processes and controls over indirect costs to more closely monitor whether indirect costs being allocated to a grant are based on its current federally negotiated indirect cost rate. This may include identifying the expiration date of the current indirect cost rate during the grant budget preparation process and requesting an extension before the rate expires, or preparing and submitting a new indirect cost rate proposal at the earliest opportunity. Views of responsible officials: There is no disagreement with the audit finding.
Federal Agency: Department of Justice Federal Assistance Listing Numbers: 16.756, 16.726 Programs: Court Appointed Special Advocates, Juvenile Mentoring Program Award/Pass-Through Entity Identifying Numbers: 2018-CH-BX-K001, 15PJDP-21-GK-02762-CASA, 2019-MU-FX-0004, 2020-JU-FX-0028 Criteria: The Uniform Guidance in 2 CFR §200.332 details requirements for pass-through entities in regard to subrecipient monitoring and management. Per 2 CFR §200.332, Requirements for Pass-Through Entities: “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the federal award and subaward. Required information includes: (1) Federal award identification. i. Subrecipient name (which must match the name associated with its unique entity identifier); ii. Subrecipient’s unique entity identifier; iii. Federal Award Identification Number (FAIN); iv. Federal Award Date (see the definition of federal award date in §200.1 of this part) of award to the recipient by the federal agency; v. Subaward Period of Performance Start and End Date; vi. Subaward Budget Period Start and End Date; vii. Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; viii. Total Amount of Federal Funds Obligated to the subrecipient by the pass through entity, including the current financial obligation; ix. Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; x. Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); xi. Name of federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; xii. Assistance Listings Number and Title; the pass-through entity must identify the dollar amount made available under each federal award and the Assistance Listings Number at time of disbursement; xiii. Identification of whether the award is R&D; and xiv. Indirect cost rate for the federal award (including if the de minimis rate is charged) per § 200.414. (2) All requirements imposed by the pass-through entity on the subrecipient so that the federal award is used in accordance with federal statutes, regulations, and the terms and conditions of the federal award; (3) Any additional requirements that the pass-through entity imposes on the subrecipient in order for the pass-through entity to meet its own responsibility to the federal awarding agency, including identification of any required financial and performance reports; (4) i. An approved federally recognized indirect cost rate negotiated between the subrecipient and the Federal Government. If no approved rate exists, the pass-through entity must determine the appropriate rate in collaboration with the subrecipient, which is either: (A) The negotiated indirect cost rate between the pass-through entity and the subrecipient, which can be based on a prior negotiated rate between a different PTE and the same subrecipient. If basing the rate on a previously negotiated rate, the pass-through entity is not required to collect information justifying this rate, but may elect to do so; (B) The de minimis indirect cost rate. ii. The pass-through entity must not require use of a de minimis indirect cost rate if the subrecipient has a federally approved rate. Subrecipients can elect to use the cost allocation method to account for indirect costs in accordance with §200.405(d). (5) A requirement that the subrecipient permits the pass-through entity and auditors to have access to the subrecipient’s records and financial statements as necessary for the pass-through entity to meet the requirements of this part; and (6) Appropriate terms and conditions concerning closeout of the subaward.” Condition: National CASA/GAL’s subrecipient agreements do not contain a level of specificity to fully comply with federal subrecipient regulations. During our testing of subrecipient monitoring, we selected 20 subrecipient awards within Court Appointed Special Advocates and 17 subrecipient awards within the Juvenile Mentoring Program. For all awards tested, National CASA/GAL’s subaward agreements did not comply with 2 CFR §200.332, Requirements for Pass-Through Entities, as they do not contain a specific scope of work or project description. Cause: National CASA/GAL did not have the proper policies and procedures in place to ensure subaward agreements complied to relevant federal regulation, and that all required elements are located in subaward agreements, and not in the application or by reference to other documents. Effect or Potential Effect: Without adequate controls in place to ensure conformity with subaward requirements, grantees may not ensure compliance with any award special conditions or revised budgets agreed upon at contract implementation. Questioned Costs: None. Context: This is a condition identified per review of National CASA/GAL’s compliance with specified requirements using a non-statistically valid sample. For the Court Appointed Special Advocates Program, the population consisted of 100 subawards made totaling to $1,471,827 provided to subrecipients in 2022. The sample consisted of 20 subawards totaling $410,352 provided to subrecipients in 2022. For the Juvenile Mentoring Program, the population consisted of 83 subawards totaling to $2,339,039 provided to subrecipients in 2022. The sample consisted of 17 subawards totaling $441,399 provided to subrecipients in 2022. Identification as a Repeat Finding: Not a repeat finding. Recommendation: We recommend establishing and maintaining written policies and procedures to ensure subaward agreements conform to the requirements outlined in 2 CFR §200.332. Views of Responsible Officials: Management agrees that subrecipient agreements in place in 2022 did not fully comply with 2 CFR §200.332. Updates were made to the policies and procedures as well to ensure subaward files contain the requisite components. Management has additionally implemented a Grant Master File Checklist to ensure compliance with terms and conditions required in subaward agreements.
Federal Agency: Department of Justice Federal Assistance Listing Numbers: 16.756, 16.726 Programs: Court Appointed Special Advocates, Juvenile Mentoring Program Award/Pass-Through Entity Identifying Numbers: 2018-CH-BX-K001, 15PJDP-21-GK-02762-CASA, 2019-MU-FX-0004, 2020-JU-FX-0028 Criteria: The Uniform Guidance in 2 CFR §200.332 details requirements for pass-through entities in regard to subrecipient monitoring and management. Per 2 CFR §200.332, Requirements for Pass-Through Entities: “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the federal award and subaward. Required information includes: (1) Federal award identification. i. Subrecipient name (which must match the name associated with its unique entity identifier); ii. Subrecipient’s unique entity identifier; iii. Federal Award Identification Number (FAIN); iv. Federal Award Date (see the definition of federal award date in §200.1 of this part) of award to the recipient by the federal agency; v. Subaward Period of Performance Start and End Date; vi. Subaward Budget Period Start and End Date; vii. Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; viii. Total Amount of Federal Funds Obligated to the subrecipient by the pass through entity, including the current financial obligation; ix. Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; x. Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); xi. Name of federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; xii. Assistance Listings Number and Title; the pass-through entity must identify the dollar amount made available under each federal award and the Assistance Listings Number at time of disbursement; xiii. Identification of whether the award is R&D; and xiv. Indirect cost rate for the federal award (including if the de minimis rate is charged) per § 200.414. (2) All requirements imposed by the pass-through entity on the subrecipient so that the federal award is used in accordance with federal statutes, regulations, and the terms and conditions of the federal award; (3) Any additional requirements that the pass-through entity imposes on the subrecipient in order for the pass-through entity to meet its own responsibility to the federal awarding agency, including identification of any required financial and performance reports; (4) i. An approved federally recognized indirect cost rate negotiated between the subrecipient and the Federal Government. If no approved rate exists, the pass-through entity must determine the appropriate rate in collaboration with the subrecipient, which is either: (A) The negotiated indirect cost rate between the pass-through entity and the subrecipient, which can be based on a prior negotiated rate between a different PTE and the same subrecipient. If basing the rate on a previously negotiated rate, the pass-through entity is not required to collect information justifying this rate, but may elect to do so; (B) The de minimis indirect cost rate. ii. The pass-through entity must not require use of a de minimis indirect cost rate if the subrecipient has a federally approved rate. Subrecipients can elect to use the cost allocation method to account for indirect costs in accordance with §200.405(d). (5) A requirement that the subrecipient permits the pass-through entity and auditors to have access to the subrecipient’s records and financial statements as necessary for the pass-through entity to meet the requirements of this part; and (6) Appropriate terms and conditions concerning closeout of the subaward.” Condition: National CASA/GAL’s subrecipient agreements do not contain a level of specificity to fully comply with federal subrecipient regulations. During our testing of subrecipient monitoring, we selected 20 subrecipient awards within Court Appointed Special Advocates and 17 subrecipient awards within the Juvenile Mentoring Program. For all awards tested, National CASA/GAL’s subaward agreements did not comply with 2 CFR §200.332, Requirements for Pass-Through Entities, as they do not contain a specific scope of work or project description. Cause: National CASA/GAL did not have the proper policies and procedures in place to ensure subaward agreements complied to relevant federal regulation, and that all required elements are located in subaward agreements, and not in the application or by reference to other documents. Effect or Potential Effect: Without adequate controls in place to ensure conformity with subaward requirements, grantees may not ensure compliance with any award special conditions or revised budgets agreed upon at contract implementation. Questioned Costs: None. Context: This is a condition identified per review of National CASA/GAL’s compliance with specified requirements using a non-statistically valid sample. For the Court Appointed Special Advocates Program, the population consisted of 100 subawards made totaling to $1,471,827 provided to subrecipients in 2022. The sample consisted of 20 subawards totaling $410,352 provided to subrecipients in 2022. For the Juvenile Mentoring Program, the population consisted of 83 subawards totaling to $2,339,039 provided to subrecipients in 2022. The sample consisted of 17 subawards totaling $441,399 provided to subrecipients in 2022. Identification as a Repeat Finding: Not a repeat finding. Recommendation: We recommend establishing and maintaining written policies and procedures to ensure subaward agreements conform to the requirements outlined in 2 CFR §200.332. Views of Responsible Officials: Management agrees that subrecipient agreements in place in 2022 did not fully comply with 2 CFR §200.332. Updates were made to the policies and procedures as well to ensure subaward files contain the requisite components. Management has additionally implemented a Grant Master File Checklist to ensure compliance with terms and conditions required in subaward agreements.
Federal Agency: Department of Justice Federal Assistance Listing Numbers: 16.756, 16.726 Programs: Court Appointed Special Advocates, Juvenile Mentoring Program Award/Pass-Through Entity Identifying Numbers: 2018-CH-BX-K001, 15PJDP-21-GK-02762-CASA, 2019-MU-FX-0004, 2020-JU-FX-0028 Criteria: The Uniform Guidance in 2 CFR §200.332 details requirements for pass-through entities in regard to subrecipient monitoring and management. Per 2 CFR §200.332, Requirements for Pass-Through Entities: “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the federal award and subaward. Required information includes: (1) Federal award identification. i. Subrecipient name (which must match the name associated with its unique entity identifier); ii. Subrecipient’s unique entity identifier; iii. Federal Award Identification Number (FAIN); iv. Federal Award Date (see the definition of federal award date in §200.1 of this part) of award to the recipient by the federal agency; v. Subaward Period of Performance Start and End Date; vi. Subaward Budget Period Start and End Date; vii. Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; viii. Total Amount of Federal Funds Obligated to the subrecipient by the pass through entity, including the current financial obligation; ix. Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; x. Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); xi. Name of federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; xii. Assistance Listings Number and Title; the pass-through entity must identify the dollar amount made available under each federal award and the Assistance Listings Number at time of disbursement; xiii. Identification of whether the award is R&D; and xiv. Indirect cost rate for the federal award (including if the de minimis rate is charged) per § 200.414. (2) All requirements imposed by the pass-through entity on the subrecipient so that the federal award is used in accordance with federal statutes, regulations, and the terms and conditions of the federal award; (3) Any additional requirements that the pass-through entity imposes on the subrecipient in order for the pass-through entity to meet its own responsibility to the federal awarding agency, including identification of any required financial and performance reports; (4) i. An approved federally recognized indirect cost rate negotiated between the subrecipient and the Federal Government. If no approved rate exists, the pass-through entity must determine the appropriate rate in collaboration with the subrecipient, which is either: (A) The negotiated indirect cost rate between the pass-through entity and the subrecipient, which can be based on a prior negotiated rate between a different PTE and the same subrecipient. If basing the rate on a previously negotiated rate, the pass-through entity is not required to collect information justifying this rate, but may elect to do so; (B) The de minimis indirect cost rate. ii. The pass-through entity must not require use of a de minimis indirect cost rate if the subrecipient has a federally approved rate. Subrecipients can elect to use the cost allocation method to account for indirect costs in accordance with §200.405(d). (5) A requirement that the subrecipient permits the pass-through entity and auditors to have access to the subrecipient’s records and financial statements as necessary for the pass-through entity to meet the requirements of this part; and (6) Appropriate terms and conditions concerning closeout of the subaward.” Condition: National CASA/GAL’s subrecipient agreements do not contain a level of specificity to fully comply with federal subrecipient regulations. During our testing of subrecipient monitoring, we selected 20 subrecipient awards within Court Appointed Special Advocates and 17 subrecipient awards within the Juvenile Mentoring Program. For all awards tested, National CASA/GAL’s subaward agreements did not comply with 2 CFR §200.332, Requirements for Pass-Through Entities, as they do not contain a specific scope of work or project description. Cause: National CASA/GAL did not have the proper policies and procedures in place to ensure subaward agreements complied to relevant federal regulation, and that all required elements are located in subaward agreements, and not in the application or by reference to other documents. Effect or Potential Effect: Without adequate controls in place to ensure conformity with subaward requirements, grantees may not ensure compliance with any award special conditions or revised budgets agreed upon at contract implementation. Questioned Costs: None. Context: This is a condition identified per review of National CASA/GAL’s compliance with specified requirements using a non-statistically valid sample. For the Court Appointed Special Advocates Program, the population consisted of 100 subawards made totaling to $1,471,827 provided to subrecipients in 2022. The sample consisted of 20 subawards totaling $410,352 provided to subrecipients in 2022. For the Juvenile Mentoring Program, the population consisted of 83 subawards totaling to $2,339,039 provided to subrecipients in 2022. The sample consisted of 17 subawards totaling $441,399 provided to subrecipients in 2022. Identification as a Repeat Finding: Not a repeat finding. Recommendation: We recommend establishing and maintaining written policies and procedures to ensure subaward agreements conform to the requirements outlined in 2 CFR §200.332. Views of Responsible Officials: Management agrees that subrecipient agreements in place in 2022 did not fully comply with 2 CFR §200.332. Updates were made to the policies and procedures as well to ensure subaward files contain the requisite components. Management has additionally implemented a Grant Master File Checklist to ensure compliance with terms and conditions required in subaward agreements.
Federal Agency: Department of Justice Federal Assistance Listing Numbers: 16.756, 16.726 Programs: Court Appointed Special Advocates, Juvenile Mentoring Program Award/Pass-Through Entity Identifying Numbers: 2018-CH-BX-K001, 15PJDP-21-GK-02762-CASA, 2019-MU-FX-0004, 2020-JU-FX-0028 Criteria: The Uniform Guidance in 2 CFR §200.332 details requirements for pass-through entities in regard to subrecipient monitoring and management. Per 2 CFR §200.332, Requirements for Pass-Through Entities: “All pass-through entities must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the federal award and subaward. Required information includes: (1) Federal award identification. i. Subrecipient name (which must match the name associated with its unique entity identifier); ii. Subrecipient’s unique entity identifier; iii. Federal Award Identification Number (FAIN); iv. Federal Award Date (see the definition of federal award date in §200.1 of this part) of award to the recipient by the federal agency; v. Subaward Period of Performance Start and End Date; vi. Subaward Budget Period Start and End Date; vii. Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; viii. Total Amount of Federal Funds Obligated to the subrecipient by the pass through entity, including the current financial obligation; ix. Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; x. Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); xi. Name of federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; xii. Assistance Listings Number and Title; the pass-through entity must identify the dollar amount made available under each federal award and the Assistance Listings Number at time of disbursement; xiii. Identification of whether the award is R&D; and xiv. Indirect cost rate for the federal award (including if the de minimis rate is charged) per § 200.414. (2) All requirements imposed by the pass-through entity on the subrecipient so that the federal award is used in accordance with federal statutes, regulations, and the terms and conditions of the federal award; (3) Any additional requirements that the pass-through entity imposes on the subrecipient in order for the pass-through entity to meet its own responsibility to the federal awarding agency, including identification of any required financial and performance reports; (4) i. An approved federally recognized indirect cost rate negotiated between the subrecipient and the Federal Government. If no approved rate exists, the pass-through entity must determine the appropriate rate in collaboration with the subrecipient, which is either: (A) The negotiated indirect cost rate between the pass-through entity and the subrecipient, which can be based on a prior negotiated rate between a different PTE and the same subrecipient. If basing the rate on a previously negotiated rate, the pass-through entity is not required to collect information justifying this rate, but may elect to do so; (B) The de minimis indirect cost rate. ii. The pass-through entity must not require use of a de minimis indirect cost rate if the subrecipient has a federally approved rate. Subrecipients can elect to use the cost allocation method to account for indirect costs in accordance with §200.405(d). (5) A requirement that the subrecipient permits the pass-through entity and auditors to have access to the subrecipient’s records and financial statements as necessary for the pass-through entity to meet the requirements of this part; and (6) Appropriate terms and conditions concerning closeout of the subaward.” Condition: National CASA/GAL’s subrecipient agreements do not contain a level of specificity to fully comply with federal subrecipient regulations. During our testing of subrecipient monitoring, we selected 20 subrecipient awards within Court Appointed Special Advocates and 17 subrecipient awards within the Juvenile Mentoring Program. For all awards tested, National CASA/GAL’s subaward agreements did not comply with 2 CFR §200.332, Requirements for Pass-Through Entities, as they do not contain a specific scope of work or project description. Cause: National CASA/GAL did not have the proper policies and procedures in place to ensure subaward agreements complied to relevant federal regulation, and that all required elements are located in subaward agreements, and not in the application or by reference to other documents. Effect or Potential Effect: Without adequate controls in place to ensure conformity with subaward requirements, grantees may not ensure compliance with any award special conditions or revised budgets agreed upon at contract implementation. Questioned Costs: None. Context: This is a condition identified per review of National CASA/GAL’s compliance with specified requirements using a non-statistically valid sample. For the Court Appointed Special Advocates Program, the population consisted of 100 subawards made totaling to $1,471,827 provided to subrecipients in 2022. The sample consisted of 20 subawards totaling $410,352 provided to subrecipients in 2022. For the Juvenile Mentoring Program, the population consisted of 83 subawards totaling to $2,339,039 provided to subrecipients in 2022. The sample consisted of 17 subawards totaling $441,399 provided to subrecipients in 2022. Identification as a Repeat Finding: Not a repeat finding. Recommendation: We recommend establishing and maintaining written policies and procedures to ensure subaward agreements conform to the requirements outlined in 2 CFR §200.332. Views of Responsible Officials: Management agrees that subrecipient agreements in place in 2022 did not fully comply with 2 CFR §200.332. Updates were made to the policies and procedures as well to ensure subaward files contain the requisite components. Management has additionally implemented a Grant Master File Checklist to ensure compliance with terms and conditions required in subaward agreements.
U.S. Department of Agriculture Passed through the Kansas Department of Health and Environment Special Supplemental Nutrition Program for Women, Infants, and Children - 10.557 - Award number 202222W100643 Criteria or Specific Requirement – Allowable Costs/Cost Principles and Significant Deficiency Per 2 CFR 200.412 costs may be classified as direct or indirect costs and the charging of indirect costs are further governed by 2 CFR 200.414. The Unified Government has not elected to use the De Minimus indirect cost rate as allowed under the regulations nor do they have a federally negotiated indirect cost rate agreement. Per the WIC Policy and Procedures Manual, Expenses Section, 15.b., the Unified Government should negotiate a rate with the State Agency (SA) annually. As part of the negotiation, the Local Agency (LA) must submit an Indirect Cost Rate (ICR) proposal, including all documents and calculations used to determine the ICR, to the SA with the annual budget. The rate negotiated by the SA will be equal to or less than the indirect rate approved by the U.S. Dept. of Health and Human Services for KDHE. Per 2 CFR 200.303, the non-Federal entities receiving federal awards (i.e., auditee management) establish and maintain internal control design to reasonably ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Condition: For the Unified Government's Special Supplemental Nutrition Program for Women, Infants, and Children grant, for specific indirect cost rate was negotiated and approved by the Kansas Department of Health for the period July 1, 2021 through June 30, 2022. The Unified Government was unable to find a subsequent renewal or change in the negotiated rate governing such charges to the award. Questioned Costs – $37,931 related to the award number 202222W100643 for the grant period of October 1, 2021 through September 30, 2022. An approved indirect cost rate was not available for the period of July 1, 2022 through September 30, 2022. Context: In the absence of an updated agreement, the Unified Government used the indirect cost rate from its most recent agreement, which covered the period of July 2021 to June 2022 for periods outside of the agreed upon time (July 2022 through September 2022). Given an updated agreement was not present, it was uncertain if such charges were allowable or accurately charged to the award. Identification of Prior Year Finding: N/A Effect: Inappropriate indirect costs may be charged to the award based on unapproved agreements. Cause: The Unified Government does not have proper controls in place to monitor indirect costs and timing of when new negotiations may be required to support ongoing indirect costs. Recommendation: We recommend the Unified Government appropriately store records where department personnel can access them when needed. Views of Responsible Official and Planned Corrective Actions: Management will work internally to complete the annual calculation of the indirect rate and develop a solution, a shared document solution to provide indirect rate information to departments in a consistent and timely manner.
2 CFR Subpart F § 200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the District’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The District’s internal control procedures did not identify $1,943,931 of expenses in the Schedule of Expenditures of Federal Awards related to the Highway Planning and Construction funds. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
2 CFR Subpart F § 200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the District’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The District’s internal control procedures did not identify $1,943,931 of expenses in the Schedule of Expenditures of Federal Awards related to the Highway Planning and Construction funds. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
2 CFR Subpart F § 200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the District’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The District’s internal control procedures did not identify $1,943,931 of expenses in the Schedule of Expenditures of Federal Awards related to the Highway Planning and Construction funds. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agencies in addition to an inaccurate assessment of major federal programs that would be subjected to audit.
Material Weakness/Noncompliance – Other 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a. List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. For example, the National Institutes of Health is a major subdivision in the Department of Health and Human Services. b. For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c. Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d. Include the total amount provided to subrecipients from each Federal program. e. For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f. Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The Township did not prepare a Schedule of Expenditures of Federal Awards. Not preparing the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the Township and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the Township review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Other 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a. List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. For example, the National Institutes of Health is a major subdivision in the Department of Health and Human Services. b. For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c. Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d. Include the total amount provided to subrecipients from each Federal program. e. For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f. Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The Township did not prepare a Schedule of Expenditures of Federal Awards. Not preparing the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the Township and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the Township review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Other 2 CFR §200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a. List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. For example, the National Institutes of Health is a major subdivision in the Department of Health and Human Services. b. For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c. Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d. Include the total amount provided to subrecipients from each Federal program. e. For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f. Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The Township did not prepare a Schedule of Expenditures of Federal Awards. Not preparing the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the Township and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the Township review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Federal Agency: United States Department of Commerce Federal Program Name: Office for Coastal Management Assistance Listing Number: 11.473 Federal Award Identification Year: 2020 Pass-Through Agency: National Fish and Wildlife Grant Agreement Award Period: 9/1/20-08/31/23 Type of Finding: Other Matters – Material Weakness in Internal Control Criteria: 2 CFR 200.414(c) - Federal award recipients must negotiate an indirect cost rate with the cognizant agency for indirect costs, which is typically the federal agency that provides the most funding to the recipient.2 CFR 200.403(d) - The negotiated rate must be applied consistently across all federal awards to ensure uniformity in cost allocation. 2 CFR 200.302(b)(3) - Recipients must maintain adequate documentation to support the indirect costs charged to federal awards, ensuring compliance with the cost principles outlined in the regulation. Condition: For two reimbursement requests from the grantor, an indirect cost rate was used, for which CSFC did not have a provisional or final rate agreement from the USDA. Context: Of the 2 reimbursements invoiced, 2 were selected for testing for the Office for Coastal Management program. The condition noted above was identified during our procedures over CFSC’s subrecipients. Effect: CFSC did not identify the error to be able to make the appropriate corrections before receiving reimbursement for incorrect indirect cost rate invoiced. Cause: CFSC’s procedures did not ensure that the negotiated provisional rate was invoiced properly. Repeat Finding: The finding is not a repeat finding. Recommendation: We recommend that CFSC modify and strengthen its current policies and procedures to perform review over the indirect cost rate utilized when submitting invoices to the grantor. Management’s Views: See separate corrective action plan.
Compliance Requirement: A/B Condition: I noted that an indirect rate of 17.5% percent was charged to federal awards instead of the 10% rate approved in the grant awards. Criteria: 2 CFR 200.414, Indirect Costs, require non-Federal entities to apply the negotiated indirect cost rate, or the de minimis rate of 10% of modified total direct costs (MTDC) if elected and applicable, consistently to all eligible federal awards. Cause and effect: The application of the incorrect indirect cost rate has resulted in unallowable charges to the federal award. Recommendation: I recommend management ensure that the proper indirect cost rate is properly applied in accordance with the Uniform Guidance and ensures that appropriate costs are charged to the awards consistent with their federally approved budgets. Views of Responsible Officials: Upon conducting the FY21 audit, TAS’ Director of Finance was informed that the inclusion of the Biological Expertise line item on federal budgets (approximately 7.5% additional uplift) was not allowable as it was currently being calculated. TAS is allowed a 10% de minimus rate on noted FY22 Federal awards some of which also included a Biological Expertise line item that is budgeted as an hourly rate. TAS had been calculating uplift amounts owed by simply adding the Biological Expertise (7.5%) to the de minimus rate (10%) for a total uplift of 17.5%. This was done at the direction and approval of our federal partners. However, due to Biological Expertise being entered in the federal and approved budgets as an hourly line item and not a percentage TAS was considered out of compliance by using this method of calculation. Moving forward TAS will be billing the de minimus rate (10%) as a percentage, unless otherwise noted in the agreement.
Compliance Requirement: A/B Condition: I noted that an indirect rate of 17.5% percent was charged to federal awards instead of the 10% rate approved in the grant awards. Criteria: 2 CFR 200.414, Indirect Costs, require non-Federal entities to apply the negotiated indirect cost rate, or the de minimis rate of 10% of modified total direct costs (MTDC) if elected and applicable, consistently to all eligible federal awards. Cause and effect: The application of the incorrect indirect cost rate has resulted in unallowable charges to the federal award. Recommendation: I recommend management ensure that the proper indirect cost rate is properly applied in accordance with the Uniform Guidance and ensures that appropriate costs are charged to the awards consistent with their federally approved budgets. Views of Responsible Officials: Upon conducting the FY21 audit, TAS’ Director of Finance was informed that the inclusion of the Biological Expertise line item on federal budgets (approximately 7.5% additional uplift) was not allowable as it was currently being calculated. TAS is allowed a 10% de minimus rate on noted FY22 Federal awards some of which also included a Biological Expertise line item that is budgeted as an hourly rate. TAS had been calculating uplift amounts owed by simply adding the Biological Expertise (7.5%) to the de minimus rate (10%) for a total uplift of 17.5%. This was done at the direction and approval of our federal partners. However, due to Biological Expertise being entered in the federal and approved budgets as an hourly line item and not a percentage TAS was considered out of compliance by using this method of calculation. Moving forward TAS will be billing the de minimus rate (10%) as a percentage, unless otherwise noted in the agreement.
Compliance Requirement: A/B Condition: I noted that an indirect rate of 17.5% percent was charged to federal awards instead of the 10% rate approved in the grant awards. Criteria: 2 CFR 200.414, Indirect Costs, require non-Federal entities to apply the negotiated indirect cost rate, or the de minimis rate of 10% of modified total direct costs (MTDC) if elected and applicable, consistently to all eligible federal awards. Cause and effect: The application of the incorrect indirect cost rate has resulted in unallowable charges to the federal award. Recommendation: I recommend management ensure that the proper indirect cost rate is properly applied in accordance with the Uniform Guidance and ensures that appropriate costs are charged to the awards consistent with their federally approved budgets. Views of Responsible Officials: Upon conducting the FY21 audit, TAS’ Director of Finance was informed that the inclusion of the Biological Expertise line item on federal budgets (approximately 7.5% additional uplift) was not allowable as it was currently being calculated. TAS is allowed a 10% de minimus rate on noted FY22 Federal awards some of which also included a Biological Expertise line item that is budgeted as an hourly rate. TAS had been calculating uplift amounts owed by simply adding the Biological Expertise (7.5%) to the de minimus rate (10%) for a total uplift of 17.5%. This was done at the direction and approval of our federal partners. However, due to Biological Expertise being entered in the federal and approved budgets as an hourly line item and not a percentage TAS was considered out of compliance by using this method of calculation. Moving forward TAS will be billing the de minimus rate (10%) as a percentage, unless otherwise noted in the agreement.
Compliance Requirement: A/B Condition: I noted that an indirect rate of 17.5% percent was charged to federal awards instead of the 10% rate approved in the grant awards. Criteria: 2 CFR 200.414, Indirect Costs, require non-Federal entities to apply the negotiated indirect cost rate, or the de minimis rate of 10% of modified total direct costs (MTDC) if elected and applicable, consistently to all eligible federal awards. Cause and effect: The application of the incorrect indirect cost rate has resulted in unallowable charges to the federal award. Recommendation: I recommend management ensure that the proper indirect cost rate is properly applied in accordance with the Uniform Guidance and ensures that appropriate costs are charged to the awards consistent with their federally approved budgets. Views of Responsible Officials: Upon conducting the FY21 audit, TAS’ Director of Finance was informed that the inclusion of the Biological Expertise line item on federal budgets (approximately 7.5% additional uplift) was not allowable as it was currently being calculated. TAS is allowed a 10% de minimus rate on noted FY22 Federal awards some of which also included a Biological Expertise line item that is budgeted as an hourly rate. TAS had been calculating uplift amounts owed by simply adding the Biological Expertise (7.5%) to the de minimus rate (10%) for a total uplift of 17.5%. This was done at the direction and approval of our federal partners. However, due to Biological Expertise being entered in the federal and approved budgets as an hourly line item and not a percentage TAS was considered out of compliance by using this method of calculation. Moving forward TAS will be billing the de minimus rate (10%) as a percentage, unless otherwise noted in the agreement.
Compliance Requirement: A/B Condition: I noted that an indirect rate of 17.5% percent was charged to federal awards instead of the 10% rate approved in the grant awards. Criteria: 2 CFR 200.414, Indirect Costs, require non-Federal entities to apply the negotiated indirect cost rate, or the de minimis rate of 10% of modified total direct costs (MTDC) if elected and applicable, consistently to all eligible federal awards. Cause and effect: The application of the incorrect indirect cost rate has resulted in unallowable charges to the federal award. Recommendation: I recommend management ensure that the proper indirect cost rate is properly applied in accordance with the Uniform Guidance and ensures that appropriate costs are charged to the awards consistent with their federally approved budgets. Views of Responsible Officials: Upon conducting the FY21 audit, TAS’ Director of Finance was informed that the inclusion of the Biological Expertise line item on federal budgets (approximately 7.5% additional uplift) was not allowable as it was currently being calculated. TAS is allowed a 10% de minimus rate on noted FY22 Federal awards some of which also included a Biological Expertise line item that is budgeted as an hourly rate. TAS had been calculating uplift amounts owed by simply adding the Biological Expertise (7.5%) to the de minimus rate (10%) for a total uplift of 17.5%. This was done at the direction and approval of our federal partners. However, due to Biological Expertise being entered in the federal and approved budgets as an hourly line item and not a percentage TAS was considered out of compliance by using this method of calculation. Moving forward TAS will be billing the de minimus rate (10%) as a percentage, unless otherwise noted in the agreement.
Compliance Requirement: A/B Condition: I noted that an indirect rate of 17.5% percent was charged to federal awards instead of the 10% rate approved in the grant awards. Criteria: 2 CFR 200.414, Indirect Costs, require non-Federal entities to apply the negotiated indirect cost rate, or the de minimis rate of 10% of modified total direct costs (MTDC) if elected and applicable, consistently to all eligible federal awards. Cause and effect: The application of the incorrect indirect cost rate has resulted in unallowable charges to the federal award. Recommendation: I recommend management ensure that the proper indirect cost rate is properly applied in accordance with the Uniform Guidance and ensures that appropriate costs are charged to the awards consistent with their federally approved budgets. Views of Responsible Officials: Upon conducting the FY21 audit, TAS’ Director of Finance was informed that the inclusion of the Biological Expertise line item on federal budgets (approximately 7.5% additional uplift) was not allowable as it was currently being calculated. TAS is allowed a 10% de minimus rate on noted FY22 Federal awards some of which also included a Biological Expertise line item that is budgeted as an hourly rate. TAS had been calculating uplift amounts owed by simply adding the Biological Expertise (7.5%) to the de minimus rate (10%) for a total uplift of 17.5%. This was done at the direction and approval of our federal partners. However, due to Biological Expertise being entered in the federal and approved budgets as an hourly line item and not a percentage TAS was considered out of compliance by using this method of calculation. Moving forward TAS will be billing the de minimus rate (10%) as a percentage, unless otherwise noted in the agreement.
Compliance Requirement: A/B Condition: I noted that an indirect rate of 17.5% percent was charged to federal awards instead of the 10% rate approved in the grant awards. Criteria: 2 CFR 200.414, Indirect Costs, require non-Federal entities to apply the negotiated indirect cost rate, or the de minimis rate of 10% of modified total direct costs (MTDC) if elected and applicable, consistently to all eligible federal awards. Cause and effect: The application of the incorrect indirect cost rate has resulted in unallowable charges to the federal award. Recommendation: I recommend management ensure that the proper indirect cost rate is properly applied in accordance with the Uniform Guidance and ensures that appropriate costs are charged to the awards consistent with their federally approved budgets. Views of Responsible Officials: Upon conducting the FY21 audit, TAS’ Director of Finance was informed that the inclusion of the Biological Expertise line item on federal budgets (approximately 7.5% additional uplift) was not allowable as it was currently being calculated. TAS is allowed a 10% de minimus rate on noted FY22 Federal awards some of which also included a Biological Expertise line item that is budgeted as an hourly rate. TAS had been calculating uplift amounts owed by simply adding the Biological Expertise (7.5%) to the de minimus rate (10%) for a total uplift of 17.5%. This was done at the direction and approval of our federal partners. However, due to Biological Expertise being entered in the federal and approved budgets as an hourly line item and not a percentage TAS was considered out of compliance by using this method of calculation. Moving forward TAS will be billing the de minimus rate (10%) as a percentage, unless otherwise noted in the agreement.
Material Weakness/Noncompliance – Other 2 CFR §200.510(b) states, in part, that the auditee must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a. List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b. For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c. Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d. Include the total amount provided to subrecipients from each Federal program. e. For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f. Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. Subsequent to the original issuance of the 2022 audit report dated November 17, 2023, with the assistance of the pass-through entity, it was determined that the City omitted a federally funded program under the Highway Planning and Construction Cluster (Highway Planning and Construction - AUG CR 25A 3.29 - ALN 20.205). The related expenditures of $1,484,064, were excluded from the City’s originally provided SEFA. The City failed to properly identify/communicate the federal designation of the project. Inaccurate completion of the SEFA could lead to inaccurate reporting of federal expenditures by the City and could jeopardize future federal funding. The City’s originally provided SEFA for 2022 was materially misstated by the exclusion of the Highway Planning and Construction Cluster (Highway Planning and Construction - AUG CR 25A 3.29 - ALN 20.205), in the amount of $1,484,064. We recommend that the City review the process for identifying federal awards to minimize the likelihood of errors in the reporting process. Officials Response: See Corrective Action Plan
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.