Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes, 2022-006 Condition: 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. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not separately tracked in the general ledger. 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. (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. 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. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2023 fiscal year. Effect: The determination of which major programs will be audited is 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 and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Expenditures of Federal awards, which prevented the City from meeting the March 31, 2024 deadline with the Federal clearinghouse. 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. 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.
Timely Financial Statements and Audit-Material Weakness in Internal Control and Failure to Comply with State and Federal Requirements of Grants and Contracts. 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: The delay in finalization of the audit report was directly related to circumstances experienced by the prior audit firm. During this timeframe the audit firm lost two audit staff, one auditor with experience since 1986 retired and another left due to family matters. These personnel were key to the audit firm’s operations and thus far, the audit firm has been unsuccessful in replacing these staff members. Further, a co-owner of the audit firm had surgery, and the recuperative time has taken longer than expected. The co-owner was recently hospitalized again for issues related to the surgery. The combination of these circumstances lead to the prior audit firm closing and resigning it’s engagement. Subsequently the Southern Workforce Board, Inc. was required to begin procurement procedures through it’s request for proposal process. The procurement process, selection of an audit firm and timing of predecessor audit firm schedule directly impacted the completion of the audit. Cause/Effect: Southern Workforce Board, Inc. is out of compliance with the reporting deadline for the audit. Recommendation: Southern Workforce Board, Inc. financial records were finalized, complete, closed, reconciled and available for audit in sufficient time to meet the audit submission requirements of Uniform Guidance. The late submission was due to no fault of Southern Workforce Board, Inc. as they were prepared for the audit as they have been consistently over the years. Reply: See corrective action plan.
Timely Financial Statements and Audit-Material Weakness in Internal Control and Failure to Comply with State and Federal Requirements of Grants and Contracts. 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: The delay in finalization of the audit report was directly related to circumstances experienced by the prior audit firm. During this timeframe the audit firm lost two audit staff, one auditor with experience since 1986 retired and another left due to family matters. These personnel were key to the audit firm’s operations and thus far, the audit firm has been unsuccessful in replacing these staff members. Further, a co-owner of the audit firm had surgery, and the recuperative time has taken longer than expected. The co-owner was recently hospitalized again for issues related to the surgery. The combination of these circumstances lead to the prior audit firm closing and resigning it’s engagement. Subsequently the Southern Workforce Board, Inc. was required to begin procurement procedures through it’s request for proposal process. The procurement process, selection of an audit firm and timing of predecessor audit firm schedule directly impacted the completion of the audit. Cause/Effect: Southern Workforce Board, Inc. is out of compliance with the reporting deadline for the audit. Recommendation: Southern Workforce Board, Inc. financial records were finalized, complete, closed, reconciled and available for audit in sufficient time to meet the audit submission requirements of Uniform Guidance. The late submission was due to no fault of Southern Workforce Board, Inc. as they were prepared for the audit as they have been consistently over the years. Reply: See corrective action plan.
Timely Financial Statements and Audit-Material Weakness in Internal Control and Failure to Comply with State and Federal Requirements of Grants and Contracts. 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: The delay in finalization of the audit report was directly related to circumstances experienced by the prior audit firm. During this timeframe the audit firm lost two audit staff, one auditor with experience since 1986 retired and another left due to family matters. These personnel were key to the audit firm’s operations and thus far, the audit firm has been unsuccessful in replacing these staff members. Further, a co-owner of the audit firm had surgery, and the recuperative time has taken longer than expected. The co-owner was recently hospitalized again for issues related to the surgery. The combination of these circumstances lead to the prior audit firm closing and resigning it’s engagement. Subsequently the Southern Workforce Board, Inc. was required to begin procurement procedures through it’s request for proposal process. The procurement process, selection of an audit firm and timing of predecessor audit firm schedule directly impacted the completion of the audit. Cause/Effect: Southern Workforce Board, Inc. is out of compliance with the reporting deadline for the audit. Recommendation: Southern Workforce Board, Inc. financial records were finalized, complete, closed, reconciled and available for audit in sufficient time to meet the audit submission requirements of Uniform Guidance. The late submission was due to no fault of Southern Workforce Board, Inc. as they were prepared for the audit as they have been consistently over the years. Reply: See corrective action plan.
Timely Financial Statements and Audit-Material Weakness in Internal Control and Failure to Comply with State and Federal Requirements of Grants and Contracts. 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: The delay in finalization of the audit report was directly related to circumstances experienced by the prior audit firm. During this timeframe the audit firm lost two audit staff, one auditor with experience since 1986 retired and another left due to family matters. These personnel were key to the audit firm’s operations and thus far, the audit firm has been unsuccessful in replacing these staff members. Further, a co-owner of the audit firm had surgery, and the recuperative time has taken longer than expected. The co-owner was recently hospitalized again for issues related to the surgery. The combination of these circumstances lead to the prior audit firm closing and resigning it’s engagement. Subsequently the Southern Workforce Board, Inc. was required to begin procurement procedures through it’s request for proposal process. The procurement process, selection of an audit firm and timing of predecessor audit firm schedule directly impacted the completion of the audit. Cause/Effect: Southern Workforce Board, Inc. is out of compliance with the reporting deadline for the audit. Recommendation: Southern Workforce Board, Inc. financial records were finalized, complete, closed, reconciled and available for audit in sufficient time to meet the audit submission requirements of Uniform Guidance. The late submission was due to no fault of Southern Workforce Board, Inc. as they were prepared for the audit as they have been consistently over the years. Reply: See corrective action plan.
Timely Financial Statements and Audit-Material Weakness in Internal Control and Failure to Comply with State and Federal Requirements of Grants and Contracts. 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: The delay in finalization of the audit report was directly related to circumstances experienced by the prior audit firm. During this timeframe the audit firm lost two audit staff, one auditor with experience since 1986 retired and another left due to family matters. These personnel were key to the audit firm’s operations and thus far, the audit firm has been unsuccessful in replacing these staff members. Further, a co-owner of the audit firm had surgery, and the recuperative time has taken longer than expected. The co-owner was recently hospitalized again for issues related to the surgery. The combination of these circumstances lead to the prior audit firm closing and resigning it’s engagement. Subsequently the Southern Workforce Board, Inc. was required to begin procurement procedures through it’s request for proposal process. The procurement process, selection of an audit firm and timing of predecessor audit firm schedule directly impacted the completion of the audit. Cause/Effect: Southern Workforce Board, Inc. is out of compliance with the reporting deadline for the audit. Recommendation: Southern Workforce Board, Inc. financial records were finalized, complete, closed, reconciled and available for audit in sufficient time to meet the audit submission requirements of Uniform Guidance. The late submission was due to no fault of Southern Workforce Board, Inc. as they were prepared for the audit as they have been consistently over the years. Reply: See corrective action plan.
Timely Financial Statements and Audit-Material Weakness in Internal Control and Failure to Comply with State and Federal Requirements of Grants and Contracts. 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: The delay in finalization of the audit report was directly related to circumstances experienced by the prior audit firm. During this timeframe the audit firm lost two audit staff, one auditor with experience since 1986 retired and another left due to family matters. These personnel were key to the audit firm’s operations and thus far, the audit firm has been unsuccessful in replacing these staff members. Further, a co-owner of the audit firm had surgery, and the recuperative time has taken longer than expected. The co-owner was recently hospitalized again for issues related to the surgery. The combination of these circumstances lead to the prior audit firm closing and resigning it’s engagement. Subsequently the Southern Workforce Board, Inc. was required to begin procurement procedures through it’s request for proposal process. The procurement process, selection of an audit firm and timing of predecessor audit firm schedule directly impacted the completion of the audit. Cause/Effect: Southern Workforce Board, Inc. is out of compliance with the reporting deadline for the audit. Recommendation: Southern Workforce Board, Inc. financial records were finalized, complete, closed, reconciled and available for audit in sufficient time to meet the audit submission requirements of Uniform Guidance. The late submission was due to no fault of Southern Workforce Board, Inc. as they were prepared for the audit as they have been consistently over the years. Reply: See corrective action plan.
Timely Financial Statements and Audit-Material Weakness in Internal Control and Failure to Comply with State and Federal Requirements of Grants and Contracts. 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: The delay in finalization of the audit report was directly related to circumstances experienced by the prior audit firm. During this timeframe the audit firm lost two audit staff, one auditor with experience since 1986 retired and another left due to family matters. These personnel were key to the audit firm’s operations and thus far, the audit firm has been unsuccessful in replacing these staff members. Further, a co-owner of the audit firm had surgery, and the recuperative time has taken longer than expected. The co-owner was recently hospitalized again for issues related to the surgery. The combination of these circumstances lead to the prior audit firm closing and resigning it’s engagement. Subsequently the Southern Workforce Board, Inc. was required to begin procurement procedures through it’s request for proposal process. The procurement process, selection of an audit firm and timing of predecessor audit firm schedule directly impacted the completion of the audit. Cause/Effect: Southern Workforce Board, Inc. is out of compliance with the reporting deadline for the audit. Recommendation: Southern Workforce Board, Inc. financial records were finalized, complete, closed, reconciled and available for audit in sufficient time to meet the audit submission requirements of Uniform Guidance. The late submission was due to no fault of Southern Workforce Board, Inc. as they were prepared for the audit as they have been consistently over the years. Reply: See corrective action plan.
Timely Financial Statements and Audit-Material Weakness in Internal Control and Failure to Comply with State and Federal Requirements of Grants and Contracts. 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: The delay in finalization of the audit report was directly related to circumstances experienced by the prior audit firm. During this timeframe the audit firm lost two audit staff, one auditor with experience since 1986 retired and another left due to family matters. These personnel were key to the audit firm’s operations and thus far, the audit firm has been unsuccessful in replacing these staff members. Further, a co-owner of the audit firm had surgery, and the recuperative time has taken longer than expected. The co-owner was recently hospitalized again for issues related to the surgery. The combination of these circumstances lead to the prior audit firm closing and resigning it’s engagement. Subsequently the Southern Workforce Board, Inc. was required to begin procurement procedures through it’s request for proposal process. The procurement process, selection of an audit firm and timing of predecessor audit firm schedule directly impacted the completion of the audit. Cause/Effect: Southern Workforce Board, Inc. is out of compliance with the reporting deadline for the audit. Recommendation: Southern Workforce Board, Inc. financial records were finalized, complete, closed, reconciled and available for audit in sufficient time to meet the audit submission requirements of Uniform Guidance. The late submission was due to no fault of Southern Workforce Board, Inc. as they were prepared for the audit as they have been consistently over the years. Reply: See corrective action plan.
Timely Financial Statements and Audit-Material Weakness in Internal Control and Failure to Comply with State and Federal Requirements of Grants and Contracts. 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: The delay in finalization of the audit report was directly related to circumstances experienced by the prior audit firm. During this timeframe the audit firm lost two audit staff, one auditor with experience since 1986 retired and another left due to family matters. These personnel were key to the audit firm’s operations and thus far, the audit firm has been unsuccessful in replacing these staff members. Further, a co-owner of the audit firm had surgery, and the recuperative time has taken longer than expected. The co-owner was recently hospitalized again for issues related to the surgery. The combination of these circumstances lead to the prior audit firm closing and resigning it’s engagement. Subsequently the Southern Workforce Board, Inc. was required to begin procurement procedures through it’s request for proposal process. The procurement process, selection of an audit firm and timing of predecessor audit firm schedule directly impacted the completion of the audit. Cause/Effect: Southern Workforce Board, Inc. is out of compliance with the reporting deadline for the audit. Recommendation: Southern Workforce Board, Inc. financial records were finalized, complete, closed, reconciled and available for audit in sufficient time to meet the audit submission requirements of Uniform Guidance. The late submission was due to no fault of Southern Workforce Board, Inc. as they were prepared for the audit as they have been consistently over the years. Reply: See corrective action plan.
Timely Financial Statements and Audit-Material Weakness in Internal Control and Failure to Comply with State and Federal Requirements of Grants and Contracts. 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: The delay in finalization of the audit report was directly related to circumstances experienced by the prior audit firm. During this timeframe the audit firm lost two audit staff, one auditor with experience since 1986 retired and another left due to family matters. These personnel were key to the audit firm’s operations and thus far, the audit firm has been unsuccessful in replacing these staff members. Further, a co-owner of the audit firm had surgery, and the recuperative time has taken longer than expected. The co-owner was recently hospitalized again for issues related to the surgery. The combination of these circumstances lead to the prior audit firm closing and resigning it’s engagement. Subsequently the Southern Workforce Board, Inc. was required to begin procurement procedures through it’s request for proposal process. The procurement process, selection of an audit firm and timing of predecessor audit firm schedule directly impacted the completion of the audit. Cause/Effect: Southern Workforce Board, Inc. is out of compliance with the reporting deadline for the audit. Recommendation: Southern Workforce Board, Inc. financial records were finalized, complete, closed, reconciled and available for audit in sufficient time to meet the audit submission requirements of Uniform Guidance. The late submission was due to no fault of Southern Workforce Board, Inc. as they were prepared for the audit as they have been consistently over the years. Reply: See corrective action plan.
Timely Financial Statements and Audit-Material Weakness in Internal Control and Failure to Comply with State and Federal Requirements of Grants and Contracts. 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: The delay in finalization of the audit report was directly related to circumstances experienced by the prior audit firm. During this timeframe the audit firm lost two audit staff, one auditor with experience since 1986 retired and another left due to family matters. These personnel were key to the audit firm’s operations and thus far, the audit firm has been unsuccessful in replacing these staff members. Further, a co-owner of the audit firm had surgery, and the recuperative time has taken longer than expected. The co-owner was recently hospitalized again for issues related to the surgery. The combination of these circumstances lead to the prior audit firm closing and resigning it’s engagement. Subsequently the Southern Workforce Board, Inc. was required to begin procurement procedures through it’s request for proposal process. The procurement process, selection of an audit firm and timing of predecessor audit firm schedule directly impacted the completion of the audit. Cause/Effect: Southern Workforce Board, Inc. is out of compliance with the reporting deadline for the audit. Recommendation: Southern Workforce Board, Inc. financial records were finalized, complete, closed, reconciled and available for audit in sufficient time to meet the audit submission requirements of Uniform Guidance. The late submission was due to no fault of Southern Workforce Board, Inc. as they were prepared for the audit as they have been consistently over the years. Reply: See corrective action plan.
Timely Financial Statements and Audit-Material Weakness in Internal Control and Failure to Comply with State and Federal Requirements of Grants and Contracts. 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: The delay in finalization of the audit report was directly related to circumstances experienced by the prior audit firm. During this timeframe the audit firm lost two audit staff, one auditor with experience since 1986 retired and another left due to family matters. These personnel were key to the audit firm’s operations and thus far, the audit firm has been unsuccessful in replacing these staff members. Further, a co-owner of the audit firm had surgery, and the recuperative time has taken longer than expected. The co-owner was recently hospitalized again for issues related to the surgery. The combination of these circumstances lead to the prior audit firm closing and resigning it’s engagement. Subsequently the Southern Workforce Board, Inc. was required to begin procurement procedures through it’s request for proposal process. The procurement process, selection of an audit firm and timing of predecessor audit firm schedule directly impacted the completion of the audit. Cause/Effect: Southern Workforce Board, Inc. is out of compliance with the reporting deadline for the audit. Recommendation: Southern Workforce Board, Inc. financial records were finalized, complete, closed, reconciled and available for audit in sufficient time to meet the audit submission requirements of Uniform Guidance. The late submission was due to no fault of Southern Workforce Board, Inc. as they were prepared for the audit as they have been consistently over the years. Reply: See corrective action plan.
Timely Financial Statements and Audit-Material Weakness in Internal Control and Failure to Comply with State and Federal Requirements of Grants and Contracts. 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: The delay in finalization of the audit report was directly related to circumstances experienced by the prior audit firm. During this timeframe the audit firm lost two audit staff, one auditor with experience since 1986 retired and another left due to family matters. These personnel were key to the audit firm’s operations and thus far, the audit firm has been unsuccessful in replacing these staff members. Further, a co-owner of the audit firm had surgery, and the recuperative time has taken longer than expected. The co-owner was recently hospitalized again for issues related to the surgery. The combination of these circumstances lead to the prior audit firm closing and resigning it’s engagement. Subsequently the Southern Workforce Board, Inc. was required to begin procurement procedures through it’s request for proposal process. The procurement process, selection of an audit firm and timing of predecessor audit firm schedule directly impacted the completion of the audit. Cause/Effect: Southern Workforce Board, Inc. is out of compliance with the reporting deadline for the audit. Recommendation: Southern Workforce Board, Inc. financial records were finalized, complete, closed, reconciled and available for audit in sufficient time to meet the audit submission requirements of Uniform Guidance. The late submission was due to no fault of Southern Workforce Board, Inc. as they were prepared for the audit as they have been consistently over the years. Reply: See corrective action plan.
Timely Financial Statements and Audit-Material Weakness in Internal Control and Failure to Comply with State and Federal Requirements of Grants and Contracts. 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: The delay in finalization of the audit report was directly related to circumstances experienced by the prior audit firm. During this timeframe the audit firm lost two audit staff, one auditor with experience since 1986 retired and another left due to family matters. These personnel were key to the audit firm’s operations and thus far, the audit firm has been unsuccessful in replacing these staff members. Further, a co-owner of the audit firm had surgery, and the recuperative time has taken longer than expected. The co-owner was recently hospitalized again for issues related to the surgery. The combination of these circumstances lead to the prior audit firm closing and resigning it’s engagement. Subsequently the Southern Workforce Board, Inc. was required to begin procurement procedures through it’s request for proposal process. The procurement process, selection of an audit firm and timing of predecessor audit firm schedule directly impacted the completion of the audit. Cause/Effect: Southern Workforce Board, Inc. is out of compliance with the reporting deadline for the audit. Recommendation: Southern Workforce Board, Inc. financial records were finalized, complete, closed, reconciled and available for audit in sufficient time to meet the audit submission requirements of Uniform Guidance. The late submission was due to no fault of Southern Workforce Board, Inc. as they were prepared for the audit as they have been consistently over the years. Reply: See corrective action plan.
Timely Financial Statements and Audit-Material Weakness in Internal Control and Failure to Comply with State and Federal Requirements of Grants and Contracts. 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: The delay in finalization of the audit report was directly related to circumstances experienced by the prior audit firm. During this timeframe the audit firm lost two audit staff, one auditor with experience since 1986 retired and another left due to family matters. These personnel were key to the audit firm’s operations and thus far, the audit firm has been unsuccessful in replacing these staff members. Further, a co-owner of the audit firm had surgery, and the recuperative time has taken longer than expected. The co-owner was recently hospitalized again for issues related to the surgery. The combination of these circumstances lead to the prior audit firm closing and resigning it’s engagement. Subsequently the Southern Workforce Board, Inc. was required to begin procurement procedures through it’s request for proposal process. The procurement process, selection of an audit firm and timing of predecessor audit firm schedule directly impacted the completion of the audit. Cause/Effect: Southern Workforce Board, Inc. is out of compliance with the reporting deadline for the audit. Recommendation: Southern Workforce Board, Inc. financial records were finalized, complete, closed, reconciled and available for audit in sufficient time to meet the audit submission requirements of Uniform Guidance. The late submission was due to no fault of Southern Workforce Board, Inc. as they were prepared for the audit as they have been consistently over the years. Reply: See corrective action plan.
Timely Financial Statements and Audit-Material Weakness in Internal Control and Failure to Comply with State and Federal Requirements of Grants and Contracts. 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: The delay in finalization of the audit report was directly related to circumstances experienced by the prior audit firm. During this timeframe the audit firm lost two audit staff, one auditor with experience since 1986 retired and another left due to family matters. These personnel were key to the audit firm’s operations and thus far, the audit firm has been unsuccessful in replacing these staff members. Further, a co-owner of the audit firm had surgery, and the recuperative time has taken longer than expected. The co-owner was recently hospitalized again for issues related to the surgery. The combination of these circumstances lead to the prior audit firm closing and resigning it’s engagement. Subsequently the Southern Workforce Board, Inc. was required to begin procurement procedures through it’s request for proposal process. The procurement process, selection of an audit firm and timing of predecessor audit firm schedule directly impacted the completion of the audit. Cause/Effect: Southern Workforce Board, Inc. is out of compliance with the reporting deadline for the audit. Recommendation: Southern Workforce Board, Inc. financial records were finalized, complete, closed, reconciled and available for audit in sufficient time to meet the audit submission requirements of Uniform Guidance. The late submission was due to no fault of Southern Workforce Board, Inc. as they were prepared for the audit as they have been consistently over the years. Reply: See corrective action plan.
Timely Financial Statements and Audit-Material Weakness in Internal Control and Failure to Comply with State and Federal Requirements of Grants and Contracts. 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: The delay in finalization of the audit report was directly related to circumstances experienced by the prior audit firm. During this timeframe the audit firm lost two audit staff, one auditor with experience since 1986 retired and another left due to family matters. These personnel were key to the audit firm’s operations and thus far, the audit firm has been unsuccessful in replacing these staff members. Further, a co-owner of the audit firm had surgery, and the recuperative time has taken longer than expected. The co-owner was recently hospitalized again for issues related to the surgery. The combination of these circumstances lead to the prior audit firm closing and resigning it’s engagement. Subsequently the Southern Workforce Board, Inc. was required to begin procurement procedures through it’s request for proposal process. The procurement process, selection of an audit firm and timing of predecessor audit firm schedule directly impacted the completion of the audit. Cause/Effect: Southern Workforce Board, Inc. is out of compliance with the reporting deadline for the audit. Recommendation: Southern Workforce Board, Inc. financial records were finalized, complete, closed, reconciled and available for audit in sufficient time to meet the audit submission requirements of Uniform Guidance. The late submission was due to no fault of Southern Workforce Board, Inc. as they were prepared for the audit as they have been consistently over the years. Reply: See corrective action plan.
Timely Financial Statements and Audit-Material Weakness in Internal Control and Failure to Comply with State and Federal Requirements of Grants and Contracts. 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: The delay in finalization of the audit report was directly related to circumstances experienced by the prior audit firm. During this timeframe the audit firm lost two audit staff, one auditor with experience since 1986 retired and another left due to family matters. These personnel were key to the audit firm’s operations and thus far, the audit firm has been unsuccessful in replacing these staff members. Further, a co-owner of the audit firm had surgery, and the recuperative time has taken longer than expected. The co-owner was recently hospitalized again for issues related to the surgery. The combination of these circumstances lead to the prior audit firm closing and resigning it’s engagement. Subsequently the Southern Workforce Board, Inc. was required to begin procurement procedures through it’s request for proposal process. The procurement process, selection of an audit firm and timing of predecessor audit firm schedule directly impacted the completion of the audit. Cause/Effect: Southern Workforce Board, Inc. is out of compliance with the reporting deadline for the audit. Recommendation: Southern Workforce Board, Inc. financial records were finalized, complete, closed, reconciled and available for audit in sufficient time to meet the audit submission requirements of Uniform Guidance. The late submission was due to no fault of Southern Workforce Board, Inc. as they were prepared for the audit as they have been consistently over the years. Reply: See corrective action plan.
Timely Financial Statements and Audit-Material Weakness in Internal Control and Failure to Comply with State and Federal Requirements of Grants and Contracts. 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: The delay in finalization of the audit report was directly related to circumstances experienced by the prior audit firm. During this timeframe the audit firm lost two audit staff, one auditor with experience since 1986 retired and another left due to family matters. These personnel were key to the audit firm’s operations and thus far, the audit firm has been unsuccessful in replacing these staff members. Further, a co-owner of the audit firm had surgery, and the recuperative time has taken longer than expected. The co-owner was recently hospitalized again for issues related to the surgery. The combination of these circumstances lead to the prior audit firm closing and resigning it’s engagement. Subsequently the Southern Workforce Board, Inc. was required to begin procurement procedures through it’s request for proposal process. The procurement process, selection of an audit firm and timing of predecessor audit firm schedule directly impacted the completion of the audit. Cause/Effect: Southern Workforce Board, Inc. is out of compliance with the reporting deadline for the audit. Recommendation: Southern Workforce Board, Inc. financial records were finalized, complete, closed, reconciled and available for audit in sufficient time to meet the audit submission requirements of Uniform Guidance. The late submission was due to no fault of Southern Workforce Board, Inc. as they were prepared for the audit as they have been consistently over the years. Reply: See corrective action plan.
Finding 2023-004 - Accounting for Grants, Schedule of Expenditures of Federal Awards, and Fiscal Manage-ment (Material Weakness) CFDA Title and Number 84.425 Education Stabilization Fund Name of Federal Agency: U.S. Department of Education Criteria: CFR Part 200.508, CFR Part 200.510, Auditee Responsibilities state that the auditee must prepare the Schedule of Expenditures of Federal Awards, which must list individual Federal awards by Federal Agency, in-cluding the total Federal awards expended, name of the pass-through entity, CFDA number, and total amount pro-vided to subrecipients. The information contained in the Schedule of Expenditures of Federal Awards should be derived from and relate directly to the underlying accounting and other records used to prepare the financial state-ments. Condition: The Schedule of Expenditures of Federal Awards (SEFA) was presented for audit with values that were not reconciled with the general ledger. Cause: The District relied on individuals with insufficient training or support to prepare the SEFA and ensure that it was reconciled with general ledger amounts. District management did not have sufficient training or monitoring policies to recognize and correct the deficiency. Effect or Potential Effect: Errors in recording and reporting of revenues and expenditures of federal awards may not be detected and/or corrected. Because the Auditee’s SEFA that was presented for audit was completed incor-rectly, and not reconciled to the general ledger, the SEFA was materially misstated, prior to auditors’ correction recommendations. Questioned Cost: No Context: Lack of adequate controls over the Schedule of Expenditures of Federal Awards and related accounting resulted in the following: • SEFA was originally presented for auditors with incorrect information. • Inadequate reconciliation between federal expenditures reported on the GL and the SEFA was presented. Repeat of a Prior-Year Finding: No Recommendation: We recommend that the District establish policies and procedures to ensure that all Federal awards are identified and reported accurately on future SEFAs. Internal controls should be designed to prevent, detect, or correct errors in a timely manner by performing periodic reconciliations of the SEFA information to the general ledger throughout the fiscal year. The District should provide appropriate training to staff who are assigned to prepare and review the SEFA. District’s Response: The District acknowledges the deficiencies. Corrective Action Plan: The District will establish policies and procedures to ensure that all Federal awards are identified and reported accurately on future SEFAs. Planned Implementation Date: November 1, 2024 Responsible Person: District Business Manager
Finding 2023-004 - Accounting for Grants, Schedule of Expenditures of Federal Awards, and Fiscal Manage-ment (Material Weakness) CFDA Title and Number 84.425 Education Stabilization Fund Name of Federal Agency: U.S. Department of Education Criteria: CFR Part 200.508, CFR Part 200.510, Auditee Responsibilities state that the auditee must prepare the Schedule of Expenditures of Federal Awards, which must list individual Federal awards by Federal Agency, in-cluding the total Federal awards expended, name of the pass-through entity, CFDA number, and total amount pro-vided to subrecipients. The information contained in the Schedule of Expenditures of Federal Awards should be derived from and relate directly to the underlying accounting and other records used to prepare the financial state-ments. Condition: The Schedule of Expenditures of Federal Awards (SEFA) was presented for audit with values that were not reconciled with the general ledger. Cause: The District relied on individuals with insufficient training or support to prepare the SEFA and ensure that it was reconciled with general ledger amounts. District management did not have sufficient training or monitoring policies to recognize and correct the deficiency. Effect or Potential Effect: Errors in recording and reporting of revenues and expenditures of federal awards may not be detected and/or corrected. Because the Auditee’s SEFA that was presented for audit was completed incor-rectly, and not reconciled to the general ledger, the SEFA was materially misstated, prior to auditors’ correction recommendations. Questioned Cost: No Context: Lack of adequate controls over the Schedule of Expenditures of Federal Awards and related accounting resulted in the following: • SEFA was originally presented for auditors with incorrect information. • Inadequate reconciliation between federal expenditures reported on the GL and the SEFA was presented. Repeat of a Prior-Year Finding: No Recommendation: We recommend that the District establish policies and procedures to ensure that all Federal awards are identified and reported accurately on future SEFAs. Internal controls should be designed to prevent, detect, or correct errors in a timely manner by performing periodic reconciliations of the SEFA information to the general ledger throughout the fiscal year. The District should provide appropriate training to staff who are assigned to prepare and review the SEFA. District’s Response: The District acknowledges the deficiencies. Corrective Action Plan: The District will establish policies and procedures to ensure that all Federal awards are identified and reported accurately on future SEFAs. Planned Implementation Date: November 1, 2024 Responsible Person: District Business Manager
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 $929,420 • Expenditures reported on the SEFA for ALN 16.607 - Bulletproof Vest Partnership Program were $0. Actual federal expenditures obtained from the County’s records confirm $17,235 expended for a variance of ($17,235). • Expenditures reported on the SEFA for ALN 16.554 - National Criminal History Improvement Program (NCHIP) were $0. Actual federal expenditures obtained from the County’s records confirm $1,788 expended for a variance of ($1,788). • Expenditures reported on the SEFA for ALN 21.019 - Coronavirus Relief Fund were $1,100,510. Actual federal expenditures obtained from the County’s records confirm $0 expended for a variance of $1,100,510. • Expenditures reported on the SEFA for ALN 97.036 - Disaster Grants - Public Assistance (Presidentially Declared Disasters) - DR-4530 were $0. Actual federal expenditures obtained from the County’s records confirm $144,826 expended for a variance of ($144,826). • Expenditures reported on the SEFA for ALN 97.036 - Disaster Grants - Public Assistance (Presidentially Declared Disasters) - DR-4530 were $0. Actual federal expenditures obtained from the County’s records confirm $7,241 expended for a variance of ($7,241). Additionally, the County failed to present $4,199,136 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 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.
2022-004 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness – All Awards) Criteria: Per 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, £200.508 (b), the auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Condition and Context: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The SEFA did not include the following programs: o U.S. Department of Labor 17.225 Unemployment Insurance Navigator o U.S. Treasury 21.027 Workforce Navigator o U.S. Department of Health and Human Services 93.268 Immunization Services • U.S. Treasury 21.023 Emergency Rental Assistance expenditures were understated by $402,678 • U.S. Treasury 21.027 Housing Navigator expenditures were understated by $3,265 Questioned Costs – None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Views of Responsible Officials and Planned Corrective Actions: This is the first year the Organization required a Single Audit and the first time a SEFA was prepared. Accounting staff will prepare the SEFA according to mandated guidelines and will work with an experienced accounting consultant to provide additional training for staff on Uniform Guidance requirements and review the SEFA prior to filing.
2022-004 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness – All Awards) Criteria: Per 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, £200.508 (b), the auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Condition and Context: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The SEFA did not include the following programs: o U.S. Department of Labor 17.225 Unemployment Insurance Navigator o U.S. Treasury 21.027 Workforce Navigator o U.S. Department of Health and Human Services 93.268 Immunization Services • U.S. Treasury 21.023 Emergency Rental Assistance expenditures were understated by $402,678 • U.S. Treasury 21.027 Housing Navigator expenditures were understated by $3,265 Questioned Costs – None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Views of Responsible Officials and Planned Corrective Actions: This is the first year the Organization required a Single Audit and the first time a SEFA was prepared. Accounting staff will prepare the SEFA according to mandated guidelines and will work with an experienced accounting consultant to provide additional training for staff on Uniform Guidance requirements and review the SEFA prior to filing.
2022-004 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness – All Awards) Criteria: Per 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, £200.508 (b), the auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Condition and Context: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The SEFA did not include the following programs: o U.S. Department of Labor 17.225 Unemployment Insurance Navigator o U.S. Treasury 21.027 Workforce Navigator o U.S. Department of Health and Human Services 93.268 Immunization Services • U.S. Treasury 21.023 Emergency Rental Assistance expenditures were understated by $402,678 • U.S. Treasury 21.027 Housing Navigator expenditures were understated by $3,265 Questioned Costs – None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Views of Responsible Officials and Planned Corrective Actions: This is the first year the Organization required a Single Audit and the first time a SEFA was prepared. Accounting staff will prepare the SEFA according to mandated guidelines and will work with an experienced accounting consultant to provide additional training for staff on Uniform Guidance requirements and review the SEFA prior to filing.
2022-004 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness – All Awards) Criteria: Per 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, £200.508 (b), the auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Condition and Context: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The SEFA did not include the following programs: o U.S. Department of Labor 17.225 Unemployment Insurance Navigator o U.S. Treasury 21.027 Workforce Navigator o U.S. Department of Health and Human Services 93.268 Immunization Services • U.S. Treasury 21.023 Emergency Rental Assistance expenditures were understated by $402,678 • U.S. Treasury 21.027 Housing Navigator expenditures were understated by $3,265 Questioned Costs – None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Views of Responsible Officials and Planned Corrective Actions: This is the first year the Organization required a Single Audit and the first time a SEFA was prepared. Accounting staff will prepare the SEFA according to mandated guidelines and will work with an experienced accounting consultant to provide additional training for staff on Uniform Guidance requirements and review the SEFA prior to filing.
2022-004 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness – All Awards) Criteria: Per 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, £200.508 (b), the auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Condition and Context: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The SEFA did not include the following programs: o U.S. Department of Labor 17.225 Unemployment Insurance Navigator o U.S. Treasury 21.027 Workforce Navigator o U.S. Department of Health and Human Services 93.268 Immunization Services • U.S. Treasury 21.023 Emergency Rental Assistance expenditures were understated by $402,678 • U.S. Treasury 21.027 Housing Navigator expenditures were understated by $3,265 Questioned Costs – None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Views of Responsible Officials and Planned Corrective Actions: This is the first year the Organization required a Single Audit and the first time a SEFA was prepared. Accounting staff will prepare the SEFA according to mandated guidelines and will work with an experienced accounting consultant to provide additional training for staff on Uniform Guidance requirements and review the SEFA prior to filing.
2022-004 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness – All Awards) Criteria: Per 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, £200.508 (b), the auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Condition and Context: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The SEFA did not include the following programs: o U.S. Department of Labor 17.225 Unemployment Insurance Navigator o U.S. Treasury 21.027 Workforce Navigator o U.S. Department of Health and Human Services 93.268 Immunization Services • U.S. Treasury 21.023 Emergency Rental Assistance expenditures were understated by $402,678 • U.S. Treasury 21.027 Housing Navigator expenditures were understated by $3,265 Questioned Costs – None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Views of Responsible Officials and Planned Corrective Actions: This is the first year the Organization required a Single Audit and the first time a SEFA was prepared. Accounting staff will prepare the SEFA according to mandated guidelines and will work with an experienced accounting consultant to provide additional training for staff on Uniform Guidance requirements and review the SEFA prior to filing.
2022-004 Internal Controls over Preparation of the Schedule of Expenditures of Federal Awards (Material Weakness – All Awards) Criteria: Per 2 CFR 200, Uniform Administrative Requirements, Cost Principals, and Audit Requirements for Federal Awards, £200.508 (b), the auditee must prepare appropriate statements including an accurate Schedule of Expenditures of Federal Awards (SEFA) in accordance with £200.510, Financial Statements. Condition and Context: Audit procedures noted several errors in the client provided SEFA. Cause: Insufficient training and internal controls over the preparation and review process for the SEFA. Effect: The following errors were noted and corrected as a result of auditing procedures on the SEFA: • The SEFA did not include the following programs: o U.S. Department of Labor 17.225 Unemployment Insurance Navigator o U.S. Treasury 21.027 Workforce Navigator o U.S. Department of Health and Human Services 93.268 Immunization Services • U.S. Treasury 21.023 Emergency Rental Assistance expenditures were understated by $402,678 • U.S. Treasury 21.027 Housing Navigator expenditures were understated by $3,265 Questioned Costs – None Recommendation: Management should seek appropriate training for the fiscal department on preparation of the SEFA standards. In addition, review processes over the SEFA should be strengthened. Management should consider contracting with an experienced accounting consultant should they identify areas that require additional expertise and review after the drafting of the SEFA and prior to the submission for audit. Views of Responsible Officials and Planned Corrective Actions: This is the first year the Organization required a Single Audit and the first time a SEFA was prepared. Accounting staff will prepare the SEFA according to mandated guidelines and will work with an experienced accounting consultant to provide additional training for staff on Uniform Guidance requirements and review the SEFA prior to filing.
Finding 2022-001 Criteria or Specific Requirement: Management is responsible for establishing policies and procedures for creating an appropriate financial management system to track federal grants in accordance with 2 CFR 200.508, including the preparation and presentation of the schedule of expenditures of federal awards. Condition: Grant revenue in the prior year was not accrued to present reimbursement grants in accordance with generally accepted accounting principles. Cause: Management records grant revenue at the time of the drawdown request without regard to the period the expenditures were incurred. Effect or Potential Effect: Grant revenue was presented in the incorrect period causing a misstatement in the schedule of expenditures of federal awards. Recommendation: We recommend the Organization implement a process to perform a financial close, including accruing expected grant revenue based on expenditures incurred during the reporting period. We also recommend the Organization implement a process to ensure the schedule of federal expenditures of federal awards is presented fairly. Views of responsible officials: Management agrees with the finding and will implement a process to review its financial closing procedures.
Finding 2022-001 Criteria or Specific Requirement: Management is responsible for establishing policies and procedures for creating an appropriate financial management system to track federal grants in accordance with 2 CFR 200.508, including the preparation and presentation of the schedule of expenditures of federal awards. Condition: Grant revenue in the prior year was not accrued to present reimbursement grants in accordance with generally accepted accounting principles. Cause: Management records grant revenue at the time of the drawdown request without regard to the period the expenditures were incurred. Effect or Potential Effect: Grant revenue was presented in the incorrect period causing a misstatement in the schedule of expenditures of federal awards. Recommendation: We recommend the Organization implement a process to perform a financial close, including accruing expected grant revenue based on expenditures incurred during the reporting period. We also recommend the Organization implement a process to ensure the schedule of federal expenditures of federal awards is presented fairly. Views of responsible officials: Management agrees with the finding and will implement a process to review its financial closing procedures.
Finding 2022-001 Criteria or Specific Requirement: Management is responsible for establishing policies and procedures for creating an appropriate financial management system to track federal grants in accordance with 2 CFR 200.508, including the preparation and presentation of the schedule of expenditures of federal awards. Condition: Grant revenue in the prior year was not accrued to present reimbursement grants in accordance with generally accepted accounting principles. Cause: Management records grant revenue at the time of the drawdown request without regard to the period the expenditures were incurred. Effect or Potential Effect: Grant revenue was presented in the incorrect period causing a misstatement in the schedule of expenditures of federal awards. Recommendation: We recommend the Organization implement a process to perform a financial close, including accruing expected grant revenue based on expenditures incurred during the reporting period. We also recommend the Organization implement a process to ensure the schedule of federal expenditures of federal awards is presented fairly. Views of responsible officials: Management agrees with the finding and will implement a process to review its financial closing procedures.
Finding 2022-001 Criteria or Specific Requirement: Management is responsible for establishing policies and procedures for creating an appropriate financial management system to track federal grants in accordance with 2 CFR 200.508, including the preparation and presentation of the schedule of expenditures of federal awards. Condition: Grant revenue in the prior year was not accrued to present reimbursement grants in accordance with generally accepted accounting principles. Cause: Management records grant revenue at the time of the drawdown request without regard to the period the expenditures were incurred. Effect or Potential Effect: Grant revenue was presented in the incorrect period causing a misstatement in the schedule of expenditures of federal awards. Recommendation: We recommend the Organization implement a process to perform a financial close, including accruing expected grant revenue based on expenditures incurred during the reporting period. We also recommend the Organization implement a process to ensure the schedule of federal expenditures of federal awards is presented fairly. Views of responsible officials: Management agrees with the finding and will implement a process to review its financial closing procedures.
Finding 2022-001 Criteria or Specific Requirement: Management is responsible for establishing policies and procedures for creating an appropriate financial management system to track federal grants in accordance with 2 CFR 200.508, including the preparation and presentation of the schedule of expenditures of federal awards. Condition: Grant revenue in the prior year was not accrued to present reimbursement grants in accordance with generally accepted accounting principles. Cause: Management records grant revenue at the time of the drawdown request without regard to the period the expenditures were incurred. Effect or Potential Effect: Grant revenue was presented in the incorrect period causing a misstatement in the schedule of expenditures of federal awards. Recommendation: We recommend the Organization implement a process to perform a financial close, including accruing expected grant revenue based on expenditures incurred during the reporting period. We also recommend the Organization implement a process to ensure the schedule of federal expenditures of federal awards is presented fairly. Views of responsible officials: Management agrees with the finding and will implement a process to review its financial closing procedures.
Finding 2022-001 Criteria or Specific Requirement: Management is responsible for establishing policies and procedures for creating an appropriate financial management system to track federal grants in accordance with 2 CFR 200.508, including the preparation and presentation of the schedule of expenditures of federal awards. Condition: Grant revenue in the prior year was not accrued to present reimbursement grants in accordance with generally accepted accounting principles. Cause: Management records grant revenue at the time of the drawdown request without regard to the period the expenditures were incurred. Effect or Potential Effect: Grant revenue was presented in the incorrect period causing a misstatement in the schedule of expenditures of federal awards. Recommendation: We recommend the Organization implement a process to perform a financial close, including accruing expected grant revenue based on expenditures incurred during the reporting period. We also recommend the Organization implement a process to ensure the schedule of federal expenditures of federal awards is presented fairly. Views of responsible officials: Management agrees with the finding and will implement a process to review its financial closing procedures.
Finding 2022-002: SEFA Preparation Agency U.S. Department of Treasury pass-through from City of Alexandria ALN 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number 55-547-8853 Criteria In accordance with 2 CFR 200.508(b), the auditee is required to prepare appropriate financial statements, including the schedule of expenditures of Federal awards (SEFA) in accordance with ?200.510. Condition and Context During our audit, we identified a conditional contribution that ACT had recorded as revenue upon receipt of the advanced funds and before the applicable barrier to recognition had been satisfied. In addition, the full amount of advanced funds was presented on the schedule of expenditures of SEFA. As a result, net assets without donor restrictions were overstated in the financial statements and expenditures were overstated on the SEFA. Cause Controls and processes were not effectively designed to ensure conditional contributions are properly recorded within the general ledger and that the SEFA is complete and accurate. Effect Net assets without donor restrictions and expenses on the SEFA were overstated by $44,999 at December 31, 2022. Repeat Finding No Recommendation We recommend management review policies and procedures over contributions received to ensure timely and effective review for any barriers to recognition and over preparation of the SEFA to ensure completeness and accuracy of the SEFA. Views of Responsible Officials of the Auditee Management agrees with the finding. See corrective action plan. Questioned Cost None.
Finding 2022-002: SEFA Preparation Agency U.S. Department of Treasury pass-through from City of Alexandria ALN 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number 55-547-8853 Criteria In accordance with 2 CFR 200.508(b), the auditee is required to prepare appropriate financial statements, including the schedule of expenditures of Federal awards (SEFA) in accordance with ?200.510. Condition and Context During our audit, we identified a conditional contribution that ACT had recorded as revenue upon receipt of the advanced funds and before the applicable barrier to recognition had been satisfied. In addition, the full amount of advanced funds was presented on the schedule of expenditures of SEFA. As a result, net assets without donor restrictions were overstated in the financial statements and expenditures were overstated on the SEFA. Cause Controls and processes were not effectively designed to ensure conditional contributions are properly recorded within the general ledger and that the SEFA is complete and accurate. Effect Net assets without donor restrictions and expenses on the SEFA were overstated by $44,999 at December 31, 2022. Repeat Finding No Recommendation We recommend management review policies and procedures over contributions received to ensure timely and effective review for any barriers to recognition and over preparation of the SEFA to ensure completeness and accuracy of the SEFA. Views of Responsible Officials of the Auditee Management agrees with the finding. See corrective action plan. Questioned Cost None.
2022-002 Material Weakness - Preparation of Schedule of Expenditures of Federal Awards (?SEFA?) Statement Condition: Under Uniform Guidance 2 CFR Section 200.508 reporting compliance, it is the auditee?s responsibility to prepare the Schedule of Expenditures of Federal Awards statement. The Uniform Guidance 2 CFR Section 200.502 requires the proper tracking and accounting of federal expenditures incurred under the same basis of accounting as the basic financial statements to ensure proper cut-off and timely reporting to the Federal Audit Clearinghouse. Criteria: Procedures should be in place to create a materially accurate schedule of expenditures of federal awards statement based on the cash basis of accounting specifically tracking expenses when they are paid. Cause: The procedures in place did not create a materially accurate schedule of expenditures of federal awards financial statement for major program compliance. For CFDA #66.458, the SEFA provided by the Authority did not represent expenditures as paid. This was a result of the bifurcation between loan and grant disbursements, as well as presentation of loan balances on the SEFA. Uniform Guidance states that SEFA loan balances should be reported as prior year outstanding loan balance plus current year borrowings. Effect: The fund used to track the expenditures did not properly reflect the federal expenditures incurred in 2022. Recommendation: Procedures should be implemented to create a materially accurate schedule of expenditures of federal award financial statement, which should include ascertaining between loan and grant expenditures, and understanding the process for reporting loan balances on the SEFA. Views of Responsible Officials and Planned Corrective Actions: In order to create a materially accurate schedule of expenditures of federal award financial statement, the Authority will establish procedures to ascertain loan and grant expenditures, as well as taking into account the Uniform Guidance requirement for presenting loan balances on the SEFA.
2022-002 Material Weakness - Preparation of Schedule of Expenditures of Federal Awards (?SEFA?) Statement Condition: Under Uniform Guidance 2 CFR Section 200.508 reporting compliance, it is the auditee?s responsibility to prepare the Schedule of Expenditures of Federal Awards statement. The Uniform Guidance 2 CFR Section 200.502 requires the proper tracking and accounting of federal expenditures incurred under the same basis of accounting as the basic financial statements to ensure proper cut-off and timely reporting to the Federal Audit Clearinghouse. Criteria: Procedures should be in place to create a materially accurate schedule of expenditures of federal awards statement based on the cash basis of accounting specifically tracking expenses when they are paid. Cause: The procedures in place did not create a materially accurate schedule of expenditures of federal awards financial statement for major program compliance. For CFDA #66.458, the SEFA provided by the Authority did not represent expenditures as paid. This was a result of the bifurcation between loan and grant disbursements, as well as presentation of loan balances on the SEFA. Uniform Guidance states that SEFA loan balances should be reported as prior year outstanding loan balance plus current year borrowings. Effect: The fund used to track the expenditures did not properly reflect the federal expenditures incurred in 2022. Recommendation: Procedures should be implemented to create a materially accurate schedule of expenditures of federal award financial statement, which should include ascertaining between loan and grant expenditures, and understanding the process for reporting loan balances on the SEFA. Views of Responsible Officials and Planned Corrective Actions: In order to create a materially accurate schedule of expenditures of federal award financial statement, the Authority will establish procedures to ascertain loan and grant expenditures, as well as taking into account the Uniform Guidance requirement for presenting loan balances on the SEFA.
2022-002 Material Weakness - Preparation of Schedule of Expenditures of Federal Awards (?SEFA?) Statement Condition: Under Uniform Guidance 2 CFR Section 200.508 reporting compliance, it is the auditee?s responsibility to prepare the Schedule of Expenditures of Federal Awards statement. The Uniform Guidance 2 CFR Section 200.502 requires the proper tracking and accounting of federal expenditures incurred under the same basis of accounting as the basic financial statements to ensure proper cut-off and timely reporting to the Federal Audit Clearinghouse. Criteria: Procedures should be in place to create a materially accurate schedule of expenditures of federal awards statement based on the cash basis of accounting specifically tracking expenses when they are paid. Cause: The procedures in place did not create a materially accurate schedule of expenditures of federal awards financial statement for major program compliance. For CFDA #66.458, the SEFA provided by the Authority did not represent expenditures as paid. This was a result of the bifurcation between loan and grant disbursements, as well as presentation of loan balances on the SEFA. Uniform Guidance states that SEFA loan balances should be reported as prior year outstanding loan balance plus current year borrowings. Effect: The fund used to track the expenditures did not properly reflect the federal expenditures incurred in 2022. Recommendation: Procedures should be implemented to create a materially accurate schedule of expenditures of federal award financial statement, which should include ascertaining between loan and grant expenditures, and understanding the process for reporting loan balances on the SEFA. Views of Responsible Officials and Planned Corrective Actions: In order to create a materially accurate schedule of expenditures of federal award financial statement, the Authority will establish procedures to ascertain loan and grant expenditures, as well as taking into account the Uniform Guidance requirement for presenting loan balances on the SEFA.
Assistance Listing Number, Federal Agency, and Program Name - 20.106, Federal Aviation Administration, Airport Improvement Program Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on ($1,815,968) and excluded from ($882,831) the SEFA related to ALN 20.106 (Airport Improvement Program). Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in an inaccurate schedule of expenditures of federal awards provided for audit. Recommendation - Internal control procedures should be evaluated and revised to ensure that the schedule of expenditures of federal awards is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored.
Assistance Listing Number, Federal Agency, and Program Name - 20.106, Federal Aviation Administration, Airport Improvement Program Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on ($1,815,968) and excluded from ($882,831) the SEFA related to ALN 20.106 (Airport Improvement Program). Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in an inaccurate schedule of expenditures of federal awards provided for audit. Recommendation - Internal control procedures should be evaluated and revised to ensure that the schedule of expenditures of federal awards is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored.
Assistance Listing Number, Federal Agency, and Program Name - 20.106, Federal Aviation Administration, Airport Improvement Program Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on ($1,815,968) and excluded from ($882,831) the SEFA related to ALN 20.106 (Airport Improvement Program). Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in an inaccurate schedule of expenditures of federal awards provided for audit. Recommendation - Internal control procedures should be evaluated and revised to ensure that the schedule of expenditures of federal awards is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored.
Assistance Listing Number, Federal Agency, and Program Name - 20.106, Federal Aviation Administration, Airport Improvement Program Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on ($1,815,968) and excluded from ($882,831) the SEFA related to ALN 20.106 (Airport Improvement Program). Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in an inaccurate schedule of expenditures of federal awards provided for audit. Recommendation - Internal control procedures should be evaluated and revised to ensure that the schedule of expenditures of federal awards is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored.
Assistance Listing Number, Federal Agency, and Program Name - 20.106, Federal Aviation Administration, Airport Improvement Program Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on ($1,815,968) and excluded from ($882,831) the SEFA related to ALN 20.106 (Airport Improvement Program). Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in an inaccurate schedule of expenditures of federal awards provided for audit. Recommendation - Internal control procedures should be evaluated and revised to ensure that the schedule of expenditures of federal awards is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored.
Assistance Listing Number, Federal Agency, and Program Name - 20.106, Federal Aviation Administration, Airport Improvement Program Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on ($1,815,968) and excluded from ($882,831) the SEFA related to ALN 20.106 (Airport Improvement Program). Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in an inaccurate schedule of expenditures of federal awards provided for audit. Recommendation - Internal control procedures should be evaluated and revised to ensure that the schedule of expenditures of federal awards is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored.
Assistance Listing Number, Federal Agency, and Program Name - 20.106, Federal Aviation Administration, Airport Improvement Program Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on ($1,815,968) and excluded from ($882,831) the SEFA related to ALN 20.106 (Airport Improvement Program). Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in an inaccurate schedule of expenditures of federal awards provided for audit. Recommendation - Internal control procedures should be evaluated and revised to ensure that the schedule of expenditures of federal awards is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored.
Assistance Listing Number, Federal Agency, and Program Name - 20.106, Federal Aviation Administration, Airport Improvement Program Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on ($1,815,968) and excluded from ($882,831) the SEFA related to ALN 20.106 (Airport Improvement Program). Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in an inaccurate schedule of expenditures of federal awards provided for audit. Recommendation - Internal control procedures should be evaluated and revised to ensure that the schedule of expenditures of federal awards is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored.
Assistance Listing Number, Federal Agency, and Program Name - 20.106, Federal Aviation Administration, Airport Improvement Program Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on ($1,815,968) and excluded from ($882,831) the SEFA related to ALN 20.106 (Airport Improvement Program). Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in an inaccurate schedule of expenditures of federal awards provided for audit. Recommendation - Internal control procedures should be evaluated and revised to ensure that the schedule of expenditures of federal awards is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored.