Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
Material Weakness/Noncompliance – Schedule of Expenditures of Federal Awards 2 CFR § 200.510(b) states, in part, that the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a) List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c) Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d) Include the total amount provided to subrecipients from each Federal program. e) For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. The School District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $1,559,951. Adjustments were made to the Schedule of Expenditures of Federal Awards. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the School District and could jeopardize future federal funding. We recommend the School District review/update their current policies and procedures, including, prior to submitting the federal schedule to the auditors, a second review of data, support and amounts be reported, to help ensure accurate information is provided.
2022-005 Indirect Cost Allocations - Activities Allowed or Unallowed and Allowable Costs/Cost Principles Federal Program: Research and Development Cluster (ALN 47.041, Award Period 9/1/19 – 8/31/22) Federal Agency: National Science Foundation Criteria: Program costs for allocation of indirect costs were based on percentage of total costs at year end and not allocated based on specific allocations of costs incurred and approved in a timely manner as required by 2 CFR 200.414. Condition: Our testing noted that program charges include journal entries allocate indirect costs without necessary review and approvals to ensure allowability of the costs to program activities. Cause: The Organization lacks written policies, approval procedures and documentation to allocate indirect costs to the program. Effect: The Organization is not compliant with 2 CFR 2 CFR 200.414 which requires accurate, and complete disclosure of financial results including the allocation of approved and identified actual indirect costs incurred to the program in accordance with 2 CFR 200.414. Identification as a repeat finding, if applicable: The finding is a repeat of Finding 2021-006 in the prior year. Recommendation: We recommend the Organization establish policy and procedures to identify and approve allowable indirect costs chargeable to the program on a monthly basis and report this allocation in the accounting ledger separately from the general expenses of the company. Response: The Organization will allocate indirect costs to program costs based on incurred costs. Monthly allocations will be approved by the program administrator and separately reported in the general ledger. Questioned Costs: $78,400 – This is the amount of indirect costs charged to the program.
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs' compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs' compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs' compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs' compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs' compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
2 CFR 2900.4 gives regulatory effect to the Department of Labor for 2 CFR Subpart F § 200.510(b) which requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the Consortium’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The Consortium chose to report their Schedule of Federal Awards on a cash basis. The fiscal agent's accounting system operated on a full accrual basis and the federal schedule that was presented for audit was taken from the CFIS system for tracking federal expenditures for the Ohio Department of Job and Family Services. However, the Consortium was not able to provide support from the accounting system to reconcile the amounts reported on the Schedule to the accounting system. Due to the lack of support for the federal schedule, we were unable to ensure that activity upon which we based our testing of the compliance for major federal programs was complete and therefore we could not obtain the necessary assurances to form an opinion over the major federal programs' compliance. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. Management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The Consortium should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the Consortium is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
2022-005 Indirect Cost Allocations - Activities Allowed or Unallowed and Allowable Costs/Cost Principles Federal Program: Research and Development Cluster (ALN 47.041-Engineering, Award 1940055, Award Period 9/1/19 – 8/31/22) Federal Agency: National Science Foundation Criteria: Program costs for allocation of indirect costs were based on percentage of total costs at year end and not allocated based on specific allocations of costs incurred and approved in a timely manner as required by 2 CFR 200.414. Condition: Our testing noted that program charges include journal entries to allocate indirect costs without necessary review and approvals to ensure allowability of the costs to program activities. Cause: The Organization lacks written policies, approval procedures and documentation to allocate indirect costs to the program. Effect: The Organization is not compliant with 2 CFR 2 CFR 200.414 which requires accurate, and complete disclosure of financial results including the allocation of approved and identified actual indirect costs incurred to the program in accordance with 2 CFR 200.414. Without a policy of reviewing and approving indirect costs on a regular basis, there is a risk that unallowable costs are allocated to the program. Identification as a repeat finding, if applicable: The finding is a repeat of Finding 2021-006 in the prior year. Recommendation: We recommend the Organization establish policy and procedures to identify and approve allowable indirect costs chargeable to the program on a monthly basis and report this allocation in the accounting ledger separately from the general expenses of the company. Response: The Organization will allocate indirect costs to program costs based on incurred costs. Monthly allocations will be approved by the program administrator and separately reported in the general ledger. Questioned Costs: $78,400 – This is the amount of indirect costs charged to the program.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.
Finding 2022-006 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes Condition: During our fiscal year 2022 audit, we observed that the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. We were not able to determine if the Federal expenditures and subrecipient payments for all grants from the City was complete. Additionally, there were unreconciled amounts passed through to subrecipients. Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. Per discussion with Finance, we became aware that grant information and documents are not maintained by Finance. Grant documents are necessary for Finance to obtain required information for the Schedule, such as AL titles and numbers, pass through identification information and subrecipient information. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with ?200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with ?200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. Finding 2022-006 (continued) Criteria: (continued) (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in ?200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2022 fiscal year. Effect: The determination of which major Federal programs will be audited are affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City?s financial information could occur. As a result, individual program reports throughout the year could have inaccurate information. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor?s Conclusion: Finding remains as stated.