Condition: The Single Audit reporting package, as defined and required in 2 CRF 200.512 for fiscal year ended June 30, 2022, was not submitted timely. Context: Despite the Municipality’s best efforts to provide, on a timely basis, the information needed to complete the preparation and subsequent audit of their financial statements, the effects of the major disaster area declaration due to Hurricane Fiona delayed the submission of the Single Audit reporting package of the current year. Criteria: As per 2 CRF 200.512, the audit, data collection form, and reporting package must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report, or nine months after the end of the audit period. However, for any 2022 submissions with fiscal periods ending between January 1, 2022, and October 31, 2022, the requirement stating that single audits are due to the Federal Audit Clearinghouse 30 days after receipt of the auditor’s report(s), is waived. These audits will be considered on time if they are submitted within nine months after their fiscal period end date. Cause: On September 18, 2022, Puerto Rico was declared a major disaster area due to the passage of Hurricane Fiona. As a result of this declaration, the OMB granted a six-month extension for all single audits that cover recipients in Puerto Rico and have due dates between September 18, 2022 and December 31, 2022. For June 30, 2021, the extended due date was March 31, 2023. The Municipality benefited from this extension and submitted their financial statements and data collection form on March 17, 2023. The due date of the current fiscal year, June 30, 2022 however was not extended and was also due on March 31, 2023. This situation prevented the timely submission of the current fiscal year Single Audit reporting package. Effect: Because of the situation described above, the Municipality did not comply with the report submission requirement since the audit was not submitted within nine months after their fiscal period end date. Auditor’s recommendation: Management should continue to fulfill their auditee responsibilities as stated in 2 CRF 200.508 which among other things, require management to prepare appropriate financial statements and provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit to ensure that subsequent financial reporting packages are submitted timely. Views of Responsible officials and corrective actions: The Municipality Administration is committed to complying with all submissions and has ensured the proper signing of an external auditors firm to comply with such requirements. Auditor Comments: 2 CFR 200.501 states that a non-federal entity that expends $750,000 or more in Federal awards during the non-Federal entity’s fiscal year must have a single audit conducted in accordance with 2 CFR 200.514. 2 CFR 200.508 states that it is the auditee responsibility to (1) prepare financial statements, including, the schedule of expenditures of Federal awards in accordance with 2 CFR 200.510, (2) promptly follow up and take corrective action on audit findings, including preparing a summary schedule of prior audit findings and a corrective plan, and (3) provide the auditor access to personnel, accounts, books, records, supporting documentation, and any other information needed for the auditor to perform the audit required by this part, among other things. Audit Status: In process of completion.
ALN 84.425 Elementary and Secondary School Emergency Fund Program United States Department of Education Passed through State of Louisiana Department of Education 2022 Funding Criteria: In accordance with 2 CFR Part 200.303(a), the School must establish, document, and maintain effective internal control over Federal awards that provide reasonable assurance that the recipient of subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In addition, 2 CFR 200.508(d) requires that the auditee ‘provide the auditor access to personnel, accounts, books, records, supporting documentation, and any other information needed for the auditor to perform the audit required by this part.’ Condition: The School did not maintain documentation for amounts submitted for reimbursement through the program. As a result, we were unable to obtain sufficient, appropriate audit evidence to support $111,006, or approximately 25%, of the total expenditures reimbursed under the Education Stabilization Fund during the year ended June 30, 2022. Thus, we were unable to form a conclusion on the School’s compliance with direct and material requirements for a material portion of Federal award expenditures. Cause: The change in key finance department personnel caused misplacement of some of the documentation supporting the program expenditures. Effect: Amounts could be reimbursed that are not properly supported and the federal agency could request repayment of the unsupported reimbursement amounts. Questioned Costs: None Recommendation: We recommend that the School revise and implement controls to ensure consistent maintenance of all supporting documentation even if there are changes in personnel. Management Response: See corrective action plan on page 33.
ALN 84.425 Elementary and Secondary School Emergency Fund Program United States Department of Education Passed through State of Louisiana Department of Education 2022 Funding Criteria: In accordance with 2 CFR Part 200.303(a), the School must establish, document, and maintain effective internal control over Federal awards that provide reasonable assurance that the recipient of subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In addition, 2 CFR 200.508(d) requires that the auditee ‘provide the auditor access to personnel, accounts, books, records, supporting documentation, and any other information needed for the auditor to perform the audit required by this part.’ Condition: The School did not maintain documentation for amounts submitted for reimbursement through the program. As a result, we were unable to obtain sufficient, appropriate audit evidence to support $111,006, or approximately 25%, of the total expenditures reimbursed under the Education Stabilization Fund during the year ended June 30, 2022. Thus, we were unable to form a conclusion on the School’s compliance with direct and material requirements for a material portion of Federal award expenditures. Cause: The change in key finance department personnel caused misplacement of some of the documentation supporting the program expenditures. Effect: Amounts could be reimbursed that are not properly supported and the federal agency could request repayment of the unsupported reimbursement amounts. Questioned Costs: None Recommendation: We recommend that the School revise and implement controls to ensure consistent maintenance of all supporting documentation even if there are changes in personnel. Management Response: See corrective action plan on page 33.
ALN 84.425 Elementary and Secondary School Emergency Fund Program United States Department of Education Passed through State of Louisiana Department of Education 2022 Funding Criteria: In accordance with 2 CFR Part 200.303(a), the School must establish, document, and maintain effective internal control over Federal awards that provide reasonable assurance that the recipient of subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In addition, 2 CFR 200.508(d) requires that the auditee ‘provide the auditor access to personnel, accounts, books, records, supporting documentation, and any other information needed for the auditor to perform the audit required by this part.’ Condition: The School did not maintain documentation for amounts submitted for reimbursement through the program. As a result, we were unable to obtain sufficient, appropriate audit evidence to support $111,006, or approximately 25%, of the total expenditures reimbursed under the Education Stabilization Fund during the year ended June 30, 2022. Thus, we were unable to form a conclusion on the School’s compliance with direct and material requirements for a material portion of Federal award expenditures. Cause: The change in key finance department personnel caused misplacement of some of the documentation supporting the program expenditures. Effect: Amounts could be reimbursed that are not properly supported and the federal agency could request repayment of the unsupported reimbursement amounts. Questioned Costs: None Recommendation: We recommend that the School revise and implement controls to ensure consistent maintenance of all supporting documentation even if there are changes in personnel. Management Response: See corrective action plan on page 33.
Condition: During our review and reconciliation of the Schedule of Expenditures of Federal Awards (SEFA) as initially prepared by the County, we identified federal programs that were not listed accurately which resulted in federal expenditures being overstated stated by $2,412,977. • Expenditures reported on the SEFA for ALN 16.607 - Bulletproof Vest Partnership Program were $36,810. Actual federal expenditures obtained from the County’s records confirm $0 expended for a variance of $36,810. • Expenditures reported on the SEFA for ALN 21.019 - Coronavirus Relief Fund were $2,376,264. Actual federal expenditures obtained from the County’s records confirm $0 expended for a variance of $2,376,264. Expenditures reported on the SEFA for ALN 97.042 - Emergency Management Performance Grants were $24,864. Actual federal expenditures obtained from the County’s records confirm $24,961 expended for a variance of ($97). Additionally, the County failed to present $500,000 in subrecipient expenditures on the SEFA for ALN 21.027 - Coronavirus State and Local Fiscal Recovery Funds. Cause of Condition: Policies and procedures have not been designed and implemented to ensure accurate reporting of expenditures for all federal awards. Effect of Condition: This condition resulted in inaccurate recording of the federal expenditures on the SEFA. Recommendation: OSAI recommends county officials and department heads gain an understanding of federal programs awarded to Rogers County. Internal control procedures should be designed and implemented to ensure accurate reporting of expenditures on the SEFA and to ensure compliance with federal requirements. The Board of County Commissioners (BOCC) should review and approve the SEFA in an open meeting. Management Response: Board of County Commissioners: The Board of County Commissioners is responsible for the overall fiscal concerns of the county. See OKLA. STAT. Title 19, § 345. The Board of County Commissioners, with the cooperation and participation of all elected officials, reviews, develops and implements policies and procedures to create a strong internal control environment. Additionally, the Board of County Commissioners conducts meetings with all elected officials and officers responsible for the receipt and/or expenditure of county funds. These meetings address fiscal matters, including but not limited to, policy discussions and implementation, financial reports, budget oversight, SEFA reporting, and legal compliance. Policies and procedures, combined with fiscal oversight meetings, are intended to: 1) prevent or detect material misstatements in the financial statements; 2) prevent or detect fraud within the county; 3) increase communication between the Board of County Commissioners and those elected officials and officers responsible for the receipt and/or expenditure of public funds; 4) provide oversight over the fiscal concerns of the county; 5) identify and address risks related to financial reporting; 6) ensure the accuracy of Rogers County’s financial statements, Estimate of Needs, and the SEFA; and 7) ensure compliance with all applicable federal and state laws, regulations, and/or codes. The Board of County Commissioners, with the cooperation of all elected officials and officers responsible for the receipt or expenditure of federal funds, will evaluate the processes and procedures currently in place to ensure the accuracy of SEFA reporting and detect potential inaccuracies and/or misstatements. Criteria: 2 CFR § 200.303(a) Internal Controls reads as follows: The non-Federal entity must: 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.508(b) Auditee responsibilities reads as follows: The auditee must: Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. 2 CFR § 200.510(b) Financial statements reads, in part, as follows: 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. Further, GAO Standards – Section 2 – Objectives of an Entity - OV2.23 states in part: Compliance Objectives Management conducts activities in accordance with applicable laws and regulations. As part of specifying compliance objectives, the entity determines which laws and regulations apply to the entity. Management is expected to set objectives that incorporate these requirements.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
Material weakness in internal control and issues of non-compliance with state and federal laws and regulations Federal Program: 17.258, 17.259, 17.278 WIOA Cluster Criteria: The Uniform Guidance – 2 CFR 200.508(b) and 2 CFR 200.508(d) – state: “The auditee must: …(b) Prepare appropriate financial statements, including the schedule of Federal awards in accordance with §200.510…(d) Provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit required by this part.” Also, the Uniform Guidance §200.512 requires “the audit be completed and the data collection form described in paragraph (b) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report(s) , or nine months after the end of the audit period.” Condition: NEWDB had difficulty closing its accounting fiscal year in a timely manner due to budget revisions from the decertification of another Oklahoma workforce entity. The auditor did not receive a combined trial balance until January 24, 2023. Upon receipt of the trial balance, the auditor determined that the trial balance did not match the supporting general ledger or other subsidiary ledgers. On March 2, 2023, the auditor received an email stating that NEWDB would have to get with their software consultant in order to obtain updated reports from their software. As a result, the final trial balance and detailed general ledger were not received by the auditor until May 11, 2023. Additionally, there appears to be an overall lack of understanding with NEWDB accounting personnel of how the individual subledgers interact with the general ledger and trial balances as well as what would constitute program services – revenue and expense versus support services – revenue and expense. Cause and Effect: Inadequate control over month end and year end closing and financial statement preparation appear to be the cause of this issue along with inadequate training with the financial reporting software. Without accurate, timely information the financial statements and schedule of expenditures of federal awards could be misstated. Recommendation: Additional training should be provided for the accountants at NEWDB to allow them to properly run reports from their software. NEWDB should request “saved” reports that could be standardized to run monthly or annually with extra training to allow for the accountants to produce ad hoc information. We further recommend training be provided in governmental and fund accounting to assist accounting personnel’s understanding of the overall accounting processes. Responsible Official's Response: The NEWDB fiscal team will undergo supplementary training on MIP reporting procedures, which is currently in the scheduling phase and will occur within this quarter. Furthermore, as part of their ongoing professional development, the fiscal team will also engage in additional training related to governmental and fund accounting processes.
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.
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.