Noncompliance/Material Weakness – 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 District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the 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.
Noncompliance/Material Weakness – 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 District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the 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.
Noncompliance/Material Weakness – 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 District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the 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.
Noncompliance/Material Weakness – 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 District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the 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.
Noncompliance/Material Weakness – 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 District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the 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.
Noncompliance/Material Weakness – 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 District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the 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.
Noncompliance/Material Weakness – 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 District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the 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.
Noncompliance/Material Weakness – 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 District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the 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.
Noncompliance/Material Weakness – 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 District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the 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.
Noncompliance/Material Weakness – 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 District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the 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.
Noncompliance/Material Weakness – 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 District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the 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.
Noncompliance/Material Weakness – 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 District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the 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.
Noncompliance/Material Weakness – 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 District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the 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.
Noncompliance/Material Weakness – 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 District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the 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.
Noncompliance/Material Weakness – 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 District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the 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.
Noncompliance/Material Weakness – 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 District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the 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.
Noncompliance/Material Weakness – 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 District did prepare a Schedule of Expenditures of Federal Awards; however, total federal expenditures were understated by $4,752,800. Inaccurate completion of the Schedule of Expenditures of Federal Awards could lead to inaccurate reporting of federal expenditures by the District and could jeopardize future federal funding. Adjustments were made to the Schedule of Expenditures of Federal Awards. We recommend the 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-001 Preparation of and Internal controls over Schedule of Expenditures of Federal Awards -(Material Weakness) Federal Agency: U.S Department of Education Program Name: Child Nutrition Cluster Assistance Listing Numbers: 10.553, 10.555 and 10.559 Award Period: June 30, 2022 Criteria: According to 2 CFR 200, Subpart F, the District is required to prepare a schedule of federal expenditures, which must include the total federal awards expended as determined in accordance with §200.502. An effective internal control system exists if controls are effective in preventing or detecting material misstatements in the preparation of the schedule of federal expenditures of federal awards (the schedule). It provides reasonable assurance for the reliability of financial information and compliance with laws and regulations. Condition: We have determined that there was an inadequate design of internal control over the preparation of the schedule during the fiscal year ended June 30, 2022. The current financial reporting process does not ensure accuracy and completeness in the preparation of the schedule by the District, as required by Uniform Guidance. Cause: The District’s policies and procedures were not designed to ensure the District’s preparation of the schedule in conformity with Uniform Guidance. Effect: The District did not prepare the schedule in conformity with Uniform Guidance. This increases the likelihood of a material misstatement and noncompliance with laws and regulations. Recommendation: We recommend the Board of Education and management review the financial reporting process. Once this review is complete, the District should then perform a risk assessment to determine the best way to implement appropriate internal controls over financial reporting to ensure that the District prepares the schedule conformity with Uniform Guidance. Questioned Costs: None. Repeat Finding: No. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and plans to develop proper written policies and procedures for the internal control over compliance to ensure accuracy and completeness in the District’s preparation of the schedule as required by Uniform Guidance.
2022-001 Preparation of and Internal controls over Schedule of Expenditures of Federal Awards -(Material Weakness) Federal Agency: U.S Department of Education Program Name: Child Nutrition Cluster Assistance Listing Numbers: 10.553, 10.555 and 10.559 Award Period: June 30, 2022 Criteria: According to 2 CFR 200, Subpart F, the District is required to prepare a schedule of federal expenditures, which must include the total federal awards expended as determined in accordance with §200.502. An effective internal control system exists if controls are effective in preventing or detecting material misstatements in the preparation of the schedule of federal expenditures of federal awards (the schedule). It provides reasonable assurance for the reliability of financial information and compliance with laws and regulations. Condition: We have determined that there was an inadequate design of internal control over the preparation of the schedule during the fiscal year ended June 30, 2022. The current financial reporting process does not ensure accuracy and completeness in the preparation of the schedule by the District, as required by Uniform Guidance. Cause: The District’s policies and procedures were not designed to ensure the District’s preparation of the schedule in conformity with Uniform Guidance. Effect: The District did not prepare the schedule in conformity with Uniform Guidance. This increases the likelihood of a material misstatement and noncompliance with laws and regulations. Recommendation: We recommend the Board of Education and management review the financial reporting process. Once this review is complete, the District should then perform a risk assessment to determine the best way to implement appropriate internal controls over financial reporting to ensure that the District prepares the schedule conformity with Uniform Guidance. Questioned Costs: None. Repeat Finding: No. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and plans to develop proper written policies and procedures for the internal control over compliance to ensure accuracy and completeness in the District’s preparation of the schedule as required by Uniform Guidance.
2022-001 Preparation of and Internal controls over Schedule of Expenditures of Federal Awards -(Material Weakness) Federal Agency: U.S Department of Education Program Name: Child Nutrition Cluster Assistance Listing Numbers: 10.553, 10.555 and 10.559 Award Period: June 30, 2022 Criteria: According to 2 CFR 200, Subpart F, the District is required to prepare a schedule of federal expenditures, which must include the total federal awards expended as determined in accordance with §200.502. An effective internal control system exists if controls are effective in preventing or detecting material misstatements in the preparation of the schedule of federal expenditures of federal awards (the schedule). It provides reasonable assurance for the reliability of financial information and compliance with laws and regulations. Condition: We have determined that there was an inadequate design of internal control over the preparation of the schedule during the fiscal year ended June 30, 2022. The current financial reporting process does not ensure accuracy and completeness in the preparation of the schedule by the District, as required by Uniform Guidance. Cause: The District’s policies and procedures were not designed to ensure the District’s preparation of the schedule in conformity with Uniform Guidance. Effect: The District did not prepare the schedule in conformity with Uniform Guidance. This increases the likelihood of a material misstatement and noncompliance with laws and regulations. Recommendation: We recommend the Board of Education and management review the financial reporting process. Once this review is complete, the District should then perform a risk assessment to determine the best way to implement appropriate internal controls over financial reporting to ensure that the District prepares the schedule conformity with Uniform Guidance. Questioned Costs: None. Repeat Finding: No. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and plans to develop proper written policies and procedures for the internal control over compliance to ensure accuracy and completeness in the District’s preparation of the schedule as required by Uniform Guidance.
2022-001 Preparation of and Internal controls over Schedule of Expenditures of Federal Awards -(Material Weakness) Federal Agency: U.S Department of Education Program Name: Child Nutrition Cluster Assistance Listing Numbers: 10.553, 10.555 and 10.559 Award Period: June 30, 2022 Criteria: According to 2 CFR 200, Subpart F, the District is required to prepare a schedule of federal expenditures, which must include the total federal awards expended as determined in accordance with §200.502. An effective internal control system exists if controls are effective in preventing or detecting material misstatements in the preparation of the schedule of federal expenditures of federal awards (the schedule). It provides reasonable assurance for the reliability of financial information and compliance with laws and regulations. Condition: We have determined that there was an inadequate design of internal control over the preparation of the schedule during the fiscal year ended June 30, 2022. The current financial reporting process does not ensure accuracy and completeness in the preparation of the schedule by the District, as required by Uniform Guidance. Cause: The District’s policies and procedures were not designed to ensure the District’s preparation of the schedule in conformity with Uniform Guidance. Effect: The District did not prepare the schedule in conformity with Uniform Guidance. This increases the likelihood of a material misstatement and noncompliance with laws and regulations. Recommendation: We recommend the Board of Education and management review the financial reporting process. Once this review is complete, the District should then perform a risk assessment to determine the best way to implement appropriate internal controls over financial reporting to ensure that the District prepares the schedule conformity with Uniform Guidance. Questioned Costs: None. Repeat Finding: No. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and plans to develop proper written policies and procedures for the internal control over compliance to ensure accuracy and completeness in the District’s preparation of the schedule as required by Uniform Guidance.
Program - Various, including AL 10.923 – Emergency Watershed Protection Program – Reporting Grant Number & Year - Various, including NR216526XXXXC004, December 7, 2020, through August 6, 2021 Federal Grantor Agency - Various, including U.S. Department of Agriculture Pass-Through Entity - Various Criteria - Title 2 of the U.S. Code of Federal Regulations (CFR) § 200.510(b) (January 1, 2022) states, in part, the following: 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. 2 CFR § 200.512(a)(1) (January 1, 2022) states the following: The audit must be completed and the data collection form described in paragraph (b) ofthis section and reporting package described in paragraph (c) of this section must besubmitted within the earlier of 30 calendar days after receipt of the auditor’s report(s),or nine months after the end of the audit period. If the due date falls on a Saturday,Sunday, or Federal holiday, the reporting package is due the next business day. 2 CFR § 200.508 (January 1, 2022) states, in part, the following: The auditee must: (a) Procure or otherwise arrange for the audit required by this part in accordance with §200.509, and ensure it is properly performed and submitted when due in accordance with §200.512. 2 CFR § 200.303 (January 1, 2022) states the following, in relevant part: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ‘‘Standards for Internal Control in the Federal Government’’ issued by the Comptroller General of the United States or the ‘‘Internal Control Integrated Framework’’, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). A good internal control plan requires adequate procedures to ensure the Schedule of Expenditures Federal Awards (SEFA) is presented properly and includes all Federal expenditures made by the County during the fiscal year. Additionally, those same procedures should ensure the Federal audit is completed and submitted to the Federal Audit Clearinghouse within the time frame required by Title 2 CFR § 200.512. Condition - The County did not have adequate procedures in place to monitor Federal expenditures and ensure the Schedule of Expenditures of Federal Awards (SEFA) was completed and submitted to the Federal Audit Clearinghouse in accordance with Title 2 CFR § 200.512. Repeat Finding - No Questioned Costs - None Statistical Sample - No Context - The County had a basic financial statement audit completed for the fiscal year ending June 30, 2022, which was issued on January 4, 2023, but that audit did not include the additional information necessary to meet Uniform Guidance and Single Audit Act requirements. When the audit for the fiscal year ending June 30, 2023, was completed, the Auditor of Public Accounts identified that the County should have had a Single Audit completed for the fiscal year ending June 30, 2022. Cause - Administration of Federal awards is decentralized, with each County office operating independently without any centralized reporting procedures in place to ensure all Federal expenditures of the County are reported accurately during the annual financial statement audit. Additionally, there is an overall lack of knowledge by County personnel related to Federal reporting requirements. Effect - Noncompliance with Federal regulations and an increased risk for the SEFA to be inaccurate, which could lead to Federal sanctions and Single Audits not being completed when required. Recommendation - We recommend the County establish written procedures to ensure the SEFA is complete and accurate. Such procedures may include, among other things, a requirement that all offices in the County responsible for administering Federal grants report their grant expenditures, as well as related information, to a single individual in the County with overall responsibility for Federal reporting requirements. That individual should be knowledgeable of all Federal reporting and compliance requirements, and review expenditures provided by each office to ensure all amounts are accurate and include all Federal expenditures of the County. Further, we recommend the County obtain necessary training related to Federal reporting requirements and ensure a Single Audit is completed and submitted to the Federal Audit Clearinghouse within the time frame required by Title 2 CFR § 200.512. View of Officials - The County will ensure County personnel obtain training to ensure there is a proper understanding of the Federal reporting requirements and preparation of the Schedule of Federal Awards.
Criteria: In accordance with 2 CFR 200.200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (Schedule) for the period covered by the auditee's financial statements which must include the total Federal Awards expended as determined in accordance with 2 CFR 200.502. Condition: The University’s Schedule of Expenditures for Federal Awards for the year ended June 30, 2022, was restated to include federal expenditures totaling $3,035,255 for the Disaster Grants - Public Assistance (Presidentially Declared Disasters), Assistance Listing Number 97.036, resulting in total expenditures of $3,030,346. Cause: The federal program activity for the Disaster Grants - Public Assistance (Presidentially Declared Disasters), Assistance Listing Number 97.036, was omitted from the Schedule of Expenditures for Federal Awards due to an oversight in the preparation of the Schedule. Effect: Improper reporting of federal expenditures can result in material errors on the Schedule leading to inaccurate major program determination by the auditors. In this instance, an error did result in the identification of an additional major program. Questioned Cost: None. Context: The University improperly excluded grant expenditures for the Disaster Grants - Public Assistance (Presidentially Declared Disasters) program on the original Schedule for the year ended June 30, 2022 in the amount of $3,035,255 resulting in total expenditures of $3,030,346 for the program and, therefore, the single audit report was reissued for the correction of the error. Recommendation: We recommend the University enhance the process and internal controls around the timely identification of federal awards and preparation of the Schedule to ensure accuracy and completeness of the Schedule. Views of responsible officials: We agree with the compliance finding. See the Corrective Action Plan at pages 71-72.
EMPLOYMENT DEVELOPMENT DEPARTMENT Reference Number: 2022-001 Type of Finding: Material Weakness and Material Instance of Noncompliance Criteria Title 2 - Grants and Agreements. Subtitle A - Office of Management and Budget Guidance for Grants and Agreements. Chapter II - Office of Management and Budget Guidance. Part 200 - Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart D - Post Federal Award Requirements. Standards for Financial and Program Management. §200.303 Internal controls (2 CFR 200.303): The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Title 2 - Grants and Agreements. Subtitle A - Office of Management and Budget Guidance for Grants and Agreements. Chapter II - Office of Management and Budget Guidance. Part 200 - Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart F - Audit Requirements. §200.510 Financial statements (2 CFR 200.510): (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: (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings 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. Condition The State of California (State) has a decentralized financial reporting process, which requires State agencies and departments to provide specific financial information to the Department of Finance (Finance) in order to annually compile the Schedule of Expenditures of Federal Awards (Schedule). In its effort to more efficiently and accurately prepare the Schedule in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Finance developed the Single Audit Expenditures Reporting Database (Database). Finance developed the Database to include all of the relevant data fields necessary to compile and produce the Schedule. Finance also created a Single Audit Database User Manual, which provides specific guidance to users for accessing and navigating through the database. Due to the unprecedented impacts from the COVID-19 pandemic, the Employment Development Department (EDD) was unable to timely report to Finance through the Database with accurate and reliable federal cash basis expenditures for its largest federal award program that it administers, the Unemployment Insurance (ALN 17.225) program. The delay resulted in Finance being unable to compile and produce a complete and final approved Schedule until December 2023. Although an initial estimated expenditure amount was reported by EDD of $27.0 billion, the final amount reported in the Schedule was $23.3 billion. Cause Given the substantial increase in claimants seeking assistance under the Unemployment Insurance program resulting from the COVID-19 pandemic, EDD was overwhelmed with the administration of the Unemployment Insurance program. Effect The difficulties that EDD encountered from the COVID-19 pandemic, resulted in the late reporting and submission of final federal cash basis expenditures to Finance. The untimely submission continued to limit and constrain Finance from compiling and producing a final complete and accurate Schedule. Questioned Costs Questioned costs were not determinable. Recommendation EDD should continue to evaluate existing processes and controls related to its ability to properly report, and timely submit complete and accurate federal award cash basis expenditures to the Database, which affords Finance the ability to timely compile and produce a final Schedule pursuant to the Uniform Guidance. Views of Responsible Officials and Corrective Action Plan EDD agrees with this finding. The deferred transition to FI$Cal and the difficulties experienced thereafter have continued to cause EDD to be late with submitting year-end financials and its ability to submit timely the cash basis expenditures into the Single Audit Expenditures Reporting Database (Database). In addition, the onset of the COVID-19 pandemic created additional issues which ultimately impacted the EDD’s ability to submit timely year-end financials. However, the EDD continues to make progress to gain ground in the department’s efforts to follow the State’s deadlines for submitting year-end financials and entering the cash basis expenditures into the Database. During fiscal year 2022-23, the EDD completed a restructuring within the accounting area which realigned workload amongst the units and provided additional resources in critical areas. These changes will have a lasting effect and help the department to be better positioned going forward in processing the accounting workload and ultimately be able to catch up and submit year-end financials and enter the cash basis expenditures into the Database by the State’s deadlines. In addition, the EDD took lessons learned from the financial audits from the prior two fiscal years to update processes and procedures and applied that knowledge going forward. Also, staff continue to participate in various trainings offered by the Department of Finance and the Department of FI$Cal. In addition, staff work with the control agencies when issues arise that would impact our accounting functions.
EMPLOYMENT DEVELOPMENT DEPARTMENT Reference Number: 2022-001 Type of Finding: Material Weakness and Material Instance of Noncompliance Criteria Title 2 - Grants and Agreements. Subtitle A - Office of Management and Budget Guidance for Grants and Agreements. Chapter II - Office of Management and Budget Guidance. Part 200 - Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart D - Post Federal Award Requirements. Standards for Financial and Program Management. §200.303 Internal controls (2 CFR 200.303): The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Title 2 - Grants and Agreements. Subtitle A - Office of Management and Budget Guidance for Grants and Agreements. Chapter II - Office of Management and Budget Guidance. Part 200 - Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart F - Audit Requirements. §200.510 Financial statements (2 CFR 200.510): (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: (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings 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. Condition The State of California (State) has a decentralized financial reporting process, which requires State agencies and departments to provide specific financial information to the Department of Finance (Finance) in order to annually compile the Schedule of Expenditures of Federal Awards (Schedule). In its effort to more efficiently and accurately prepare the Schedule in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Finance developed the Single Audit Expenditures Reporting Database (Database). Finance developed the Database to include all of the relevant data fields necessary to compile and produce the Schedule. Finance also created a Single Audit Database User Manual, which provides specific guidance to users for accessing and navigating through the database. Due to the unprecedented impacts from the COVID-19 pandemic, the Employment Development Department (EDD) was unable to timely report to Finance through the Database with accurate and reliable federal cash basis expenditures for its largest federal award program that it administers, the Unemployment Insurance (ALN 17.225) program. The delay resulted in Finance being unable to compile and produce a complete and final approved Schedule until December 2023. Although an initial estimated expenditure amount was reported by EDD of $27.0 billion, the final amount reported in the Schedule was $23.3 billion. Cause Given the substantial increase in claimants seeking assistance under the Unemployment Insurance program resulting from the COVID-19 pandemic, EDD was overwhelmed with the administration of the Unemployment Insurance program. Effect The difficulties that EDD encountered from the COVID-19 pandemic, resulted in the late reporting and submission of final federal cash basis expenditures to Finance. The untimely submission continued to limit and constrain Finance from compiling and producing a final complete and accurate Schedule. Questioned Costs Questioned costs were not determinable. Recommendation EDD should continue to evaluate existing processes and controls related to its ability to properly report, and timely submit complete and accurate federal award cash basis expenditures to the Database, which affords Finance the ability to timely compile and produce a final Schedule pursuant to the Uniform Guidance. Views of Responsible Officials and Corrective Action Plan EDD agrees with this finding. The deferred transition to FI$Cal and the difficulties experienced thereafter have continued to cause EDD to be late with submitting year-end financials and its ability to submit timely the cash basis expenditures into the Single Audit Expenditures Reporting Database (Database). In addition, the onset of the COVID-19 pandemic created additional issues which ultimately impacted the EDD’s ability to submit timely year-end financials. However, the EDD continues to make progress to gain ground in the department’s efforts to follow the State’s deadlines for submitting year-end financials and entering the cash basis expenditures into the Database. During fiscal year 2022-23, the EDD completed a restructuring within the accounting area which realigned workload amongst the units and provided additional resources in critical areas. These changes will have a lasting effect and help the department to be better positioned going forward in processing the accounting workload and ultimately be able to catch up and submit year-end financials and enter the cash basis expenditures into the Database by the State’s deadlines. In addition, the EDD took lessons learned from the financial audits from the prior two fiscal years to update processes and procedures and applied that knowledge going forward. Also, staff continue to participate in various trainings offered by the Department of Finance and the Department of FI$Cal. In addition, staff work with the control agencies when issues arise that would impact our accounting functions.
DDEPARTMENT OF PUBLIC HEALTH Reference Number: 2022-002 Type of Finding: Material Weakness and Instance of Noncompliance Criteria Title 2 - Grants and Agreements. Subtitle A - Office of Management and Budget Guidance for Grants and Agreements. Chapter II - Office of Management and Budget Guidance. Part 200 - Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart D - Post Federal Award Requirements. Standards for Financial and Program Management. §200.303 Internal controls (2 CFR 200.303): The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Title 2 - Grants and Agreements. Subtitle A - Office of Management and Budget Guidance for Grants and Agreements. Chapter II - Office of Management and Budget Guidance. Part 200 - Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart F - Audit Requirements. §200.510 Financial statements (2 CFR 200.510): (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: (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings 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. (4) Include the total amount provided to subrecipients from each Federal program. Condition The State of California (State) has a decentralized financial reporting process, which requires State agencies and departments to provide specific financial information to the Department of Finance (Finance) in order to annually compile the Schedule of Expenditures of Federal Awards (Schedule). In its effort to more efficiently and accurately prepare the Schedule in accordance with the requirements of 2 CFR 200.510, Finance developed the Single Audit Expenditures Reporting Database (Database) to include all relevant data fields necessary to compile and produce the Schedule. Finance also created a Single Audit Database User Manual, which provides specific guidance to users for accessing and navigating through the database. Departments are given access to the centralized Database by Finance in order to upload and report federal award information for all federal award programs which they administer. The California Department of Public Health (Public Health) understated federal expenditures and overstated amounts passed through to subrecipients for the Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) program (ALN No. 93.323). The error, which was subsequently corrected, is indicative of a lack of sufficient controls for ensuring the Schedule’s completeness and accuracy prior to submission to Finance. Cause Public Health was a subrecipient of federal funds provided by their bona fide agent, Heluna Health, during the fiscal year ended June 30, 2022. Initially, the ELC program funds were not identified and recognized as federal expenditures until January 2023. During its compilation of federal award expenditures for reporting in Finance’s Database, Public Health did not properly analyze and capture all relevant financial transactions related to the ELC program. Effect Federal expenditures originally reported in the Schedule by Public Health for the ELC program were understated by $154,155,192 and the amounts passed through to subrecipients were overstated by $516,650,718. Questioned Costs No questioned costs were identified. Recommendation Public Health should establish a more thorough internal review and communication process between ELC program administration and accounting personnel to ensure information submitted to Finance for compilation of the Schedule is complete and accurate. Views of Responsible Officials and Corrective Action Plan Public Health’s Accounting Office will generate the FI$Cal Year End Close report (KK_12 expenditure) and collaborate with the ELC program to ensure that all expenditures captured are complete and accurate, ensuring timely reporting of the SEFA data for FY 2023-24 and beyond. Please note that the ELC program has been reported in the FY 2022-23 SEFA. Additionally, we will update the procedures to document the SEFA reporting for the ELC program. Estimated Implementation Date: September 2024 Contact: Jennifer Chan, Accounting Administrator II Federal Reporting Unit, Financial Management Division California Department of Public Health
2022-002 Reporting ? Schedule of Expenditures of Federal AwardsIdentification as a Repeat Finding: Repeat of Finding 2021-004.Finding:The SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards.Criteria:The Organization is responsible for maintaining accurate information about all federal programs and reporting requirements. The Organization is responsible for using this information to comply with the Uniform Guidance in carrying out federal programs.Sample Size and Population: N/ACondition and Context:The original SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards including the following:? 21.019 Coronavirus Relief Fund excluded. Contracts 4120 & 8328 passed through by the United Way of King County & the contract passed through by the Washington State Housing Finance Commission (WSHFC) totaled $205,822 but were not included in the original SEFA provided.? 21.023 Emergency Rental Assistance Program Contract 9395 passed through by the United Way of King County understated by $341,000.? 21.023 Emergency Rental Assistance Program Contract excluded. Contract 8366 passed through by the United Way of King County included $8,274,601 of federal funds that were not included on the original SEFA provided for audit.? 21.026 Homeowner Assistance Fund contact #HAF0025 passed through by WSHFC overstated by $124,710.? 91.024 Emergency Food and Shelter contract #889000-033 passed through by United Way of King County overstated by $66,542.? 17.258 WIOA Title 1b Adult Services contract #21-115-ADU passed through by Workforce Development Council of King County not identified as part of the WIOA Cluster.Additionally, the prior year SEFA was overstated by $704,017 for the 20.019 Coronavirus Relief Fund Contracts #4120 and #8328 passed through by the United Way of King County due to the accounting error identified in Finding 2022-001.Effect:Inaccurate identification of programs subject to the Single Audit increases the risk that the Organization will not comply with the terms and conditions of federal programs.Cause:As noted in Finding 2022-001, the Organization did not correctly account for advanced federal funds and as noted in Finding 2022-003, the Organization has not implemented a policy for advanced federal funds that complies with 2 CFR 200.305. These gaps in internal control resulted in cut-off errors in SEFA reporting for FY21 & FY22. Additionally, the Organization has not been applying the guidance of Section 200.502 of the Uniform Guidance in preparing the SEFA. Lastly, the program manager of the pass through agency of the 21.023 Emergency Rental Assistance Program Contract #8366 incorrectly informed the Organization that it had no responsibility for reporting the contract as a subrecipient of federal funds.Recommendation:The Organization must continue to increase its familiarity with federal grant compliance requirements and establish a process for timely identification of federal programs and a system for tracking contracts in order to ensure compliance with federal award programs and to completeness and accuracy in SEFA reporting.Questioned Costs: NoneManagement Response and Corrective Action Plan: See Corrective Action PlanContact Person: Mansour Camara, CFO
2022-002 Reporting ? Schedule of Expenditures of Federal AwardsIdentification as a Repeat Finding: Repeat of Finding 2021-004.Finding:The SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards.Criteria:The Organization is responsible for maintaining accurate information about all federal programs and reporting requirements. The Organization is responsible for using this information to comply with the Uniform Guidance in carrying out federal programs.Sample Size and Population: N/ACondition and Context:The original SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards including the following:? 21.019 Coronavirus Relief Fund excluded. Contracts 4120 & 8328 passed through by the United Way of King County & the contract passed through by the Washington State Housing Finance Commission (WSHFC) totaled $205,822 but were not included in the original SEFA provided.? 21.023 Emergency Rental Assistance Program Contract 9395 passed through by the United Way of King County understated by $341,000.? 21.023 Emergency Rental Assistance Program Contract excluded. Contract 8366 passed through by the United Way of King County included $8,274,601 of federal funds that were not included on the original SEFA provided for audit.? 21.026 Homeowner Assistance Fund contact #HAF0025 passed through by WSHFC overstated by $124,710.? 91.024 Emergency Food and Shelter contract #889000-033 passed through by United Way of King County overstated by $66,542.? 17.258 WIOA Title 1b Adult Services contract #21-115-ADU passed through by Workforce Development Council of King County not identified as part of the WIOA Cluster.Additionally, the prior year SEFA was overstated by $704,017 for the 20.019 Coronavirus Relief Fund Contracts #4120 and #8328 passed through by the United Way of King County due to the accounting error identified in Finding 2022-001.Effect:Inaccurate identification of programs subject to the Single Audit increases the risk that the Organization will not comply with the terms and conditions of federal programs.Cause:As noted in Finding 2022-001, the Organization did not correctly account for advanced federal funds and as noted in Finding 2022-003, the Organization has not implemented a policy for advanced federal funds that complies with 2 CFR 200.305. These gaps in internal control resulted in cut-off errors in SEFA reporting for FY21 & FY22. Additionally, the Organization has not been applying the guidance of Section 200.502 of the Uniform Guidance in preparing the SEFA. Lastly, the program manager of the pass through agency of the 21.023 Emergency Rental Assistance Program Contract #8366 incorrectly informed the Organization that it had no responsibility for reporting the contract as a subrecipient of federal funds.Recommendation:The Organization must continue to increase its familiarity with federal grant compliance requirements and establish a process for timely identification of federal programs and a system for tracking contracts in order to ensure compliance with federal award programs and to completeness and accuracy in SEFA reporting.Questioned Costs: NoneManagement Response and Corrective Action Plan: See Corrective Action PlanContact Person: Mansour Camara, CFO
2022-002 Reporting ? Schedule of Expenditures of Federal AwardsIdentification as a Repeat Finding: Repeat of Finding 2021-004.Finding:The SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards.Criteria:The Organization is responsible for maintaining accurate information about all federal programs and reporting requirements. The Organization is responsible for using this information to comply with the Uniform Guidance in carrying out federal programs.Sample Size and Population: N/ACondition and Context:The original SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards including the following:? 21.019 Coronavirus Relief Fund excluded. Contracts 4120 & 8328 passed through by the United Way of King County & the contract passed through by the Washington State Housing Finance Commission (WSHFC) totaled $205,822 but were not included in the original SEFA provided.? 21.023 Emergency Rental Assistance Program Contract 9395 passed through by the United Way of King County understated by $341,000.? 21.023 Emergency Rental Assistance Program Contract excluded. Contract 8366 passed through by the United Way of King County included $8,274,601 of federal funds that were not included on the original SEFA provided for audit.? 21.026 Homeowner Assistance Fund contact #HAF0025 passed through by WSHFC overstated by $124,710.? 91.024 Emergency Food and Shelter contract #889000-033 passed through by United Way of King County overstated by $66,542.? 17.258 WIOA Title 1b Adult Services contract #21-115-ADU passed through by Workforce Development Council of King County not identified as part of the WIOA Cluster.Additionally, the prior year SEFA was overstated by $704,017 for the 20.019 Coronavirus Relief Fund Contracts #4120 and #8328 passed through by the United Way of King County due to the accounting error identified in Finding 2022-001.Effect:Inaccurate identification of programs subject to the Single Audit increases the risk that the Organization will not comply with the terms and conditions of federal programs.Cause:As noted in Finding 2022-001, the Organization did not correctly account for advanced federal funds and as noted in Finding 2022-003, the Organization has not implemented a policy for advanced federal funds that complies with 2 CFR 200.305. These gaps in internal control resulted in cut-off errors in SEFA reporting for FY21 & FY22. Additionally, the Organization has not been applying the guidance of Section 200.502 of the Uniform Guidance in preparing the SEFA. Lastly, the program manager of the pass through agency of the 21.023 Emergency Rental Assistance Program Contract #8366 incorrectly informed the Organization that it had no responsibility for reporting the contract as a subrecipient of federal funds.Recommendation:The Organization must continue to increase its familiarity with federal grant compliance requirements and establish a process for timely identification of federal programs and a system for tracking contracts in order to ensure compliance with federal award programs and to completeness and accuracy in SEFA reporting.Questioned Costs: NoneManagement Response and Corrective Action Plan: See Corrective Action PlanContact Person: Mansour Camara, CFO
2022-002 Reporting ? Schedule of Expenditures of Federal AwardsIdentification as a Repeat Finding: Repeat of Finding 2021-004.Finding:The SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards.Criteria:The Organization is responsible for maintaining accurate information about all federal programs and reporting requirements. The Organization is responsible for using this information to comply with the Uniform Guidance in carrying out federal programs.Sample Size and Population: N/ACondition and Context:The original SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards including the following:? 21.019 Coronavirus Relief Fund excluded. Contracts 4120 & 8328 passed through by the United Way of King County & the contract passed through by the Washington State Housing Finance Commission (WSHFC) totaled $205,822 but were not included in the original SEFA provided.? 21.023 Emergency Rental Assistance Program Contract 9395 passed through by the United Way of King County understated by $341,000.? 21.023 Emergency Rental Assistance Program Contract excluded. Contract 8366 passed through by the United Way of King County included $8,274,601 of federal funds that were not included on the original SEFA provided for audit.? 21.026 Homeowner Assistance Fund contact #HAF0025 passed through by WSHFC overstated by $124,710.? 91.024 Emergency Food and Shelter contract #889000-033 passed through by United Way of King County overstated by $66,542.? 17.258 WIOA Title 1b Adult Services contract #21-115-ADU passed through by Workforce Development Council of King County not identified as part of the WIOA Cluster.Additionally, the prior year SEFA was overstated by $704,017 for the 20.019 Coronavirus Relief Fund Contracts #4120 and #8328 passed through by the United Way of King County due to the accounting error identified in Finding 2022-001.Effect:Inaccurate identification of programs subject to the Single Audit increases the risk that the Organization will not comply with the terms and conditions of federal programs.Cause:As noted in Finding 2022-001, the Organization did not correctly account for advanced federal funds and as noted in Finding 2022-003, the Organization has not implemented a policy for advanced federal funds that complies with 2 CFR 200.305. These gaps in internal control resulted in cut-off errors in SEFA reporting for FY21 & FY22. Additionally, the Organization has not been applying the guidance of Section 200.502 of the Uniform Guidance in preparing the SEFA. Lastly, the program manager of the pass through agency of the 21.023 Emergency Rental Assistance Program Contract #8366 incorrectly informed the Organization that it had no responsibility for reporting the contract as a subrecipient of federal funds.Recommendation:The Organization must continue to increase its familiarity with federal grant compliance requirements and establish a process for timely identification of federal programs and a system for tracking contracts in order to ensure compliance with federal award programs and to completeness and accuracy in SEFA reporting.Questioned Costs: NoneManagement Response and Corrective Action Plan: See Corrective Action PlanContact Person: Mansour Camara, CFO
2022-002 Reporting ? Schedule of Expenditures of Federal AwardsIdentification as a Repeat Finding: Repeat of Finding 2021-004.Finding:The SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards.Criteria:The Organization is responsible for maintaining accurate information about all federal programs and reporting requirements. The Organization is responsible for using this information to comply with the Uniform Guidance in carrying out federal programs.Sample Size and Population: N/ACondition and Context:The original SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards including the following:? 21.019 Coronavirus Relief Fund excluded. Contracts 4120 & 8328 passed through by the United Way of King County & the contract passed through by the Washington State Housing Finance Commission (WSHFC) totaled $205,822 but were not included in the original SEFA provided.? 21.023 Emergency Rental Assistance Program Contract 9395 passed through by the United Way of King County understated by $341,000.? 21.023 Emergency Rental Assistance Program Contract excluded. Contract 8366 passed through by the United Way of King County included $8,274,601 of federal funds that were not included on the original SEFA provided for audit.? 21.026 Homeowner Assistance Fund contact #HAF0025 passed through by WSHFC overstated by $124,710.? 91.024 Emergency Food and Shelter contract #889000-033 passed through by United Way of King County overstated by $66,542.? 17.258 WIOA Title 1b Adult Services contract #21-115-ADU passed through by Workforce Development Council of King County not identified as part of the WIOA Cluster.Additionally, the prior year SEFA was overstated by $704,017 for the 20.019 Coronavirus Relief Fund Contracts #4120 and #8328 passed through by the United Way of King County due to the accounting error identified in Finding 2022-001.Effect:Inaccurate identification of programs subject to the Single Audit increases the risk that the Organization will not comply with the terms and conditions of federal programs.Cause:As noted in Finding 2022-001, the Organization did not correctly account for advanced federal funds and as noted in Finding 2022-003, the Organization has not implemented a policy for advanced federal funds that complies with 2 CFR 200.305. These gaps in internal control resulted in cut-off errors in SEFA reporting for FY21 & FY22. Additionally, the Organization has not been applying the guidance of Section 200.502 of the Uniform Guidance in preparing the SEFA. Lastly, the program manager of the pass through agency of the 21.023 Emergency Rental Assistance Program Contract #8366 incorrectly informed the Organization that it had no responsibility for reporting the contract as a subrecipient of federal funds.Recommendation:The Organization must continue to increase its familiarity with federal grant compliance requirements and establish a process for timely identification of federal programs and a system for tracking contracts in order to ensure compliance with federal award programs and to completeness and accuracy in SEFA reporting.Questioned Costs: NoneManagement Response and Corrective Action Plan: See Corrective Action PlanContact Person: Mansour Camara, CFO
2022-002 Reporting ? Schedule of Expenditures of Federal AwardsIdentification as a Repeat Finding: Repeat of Finding 2021-004.Finding:The SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards.Criteria:The Organization is responsible for maintaining accurate information about all federal programs and reporting requirements. The Organization is responsible for using this information to comply with the Uniform Guidance in carrying out federal programs.Sample Size and Population: N/ACondition and Context:The original SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards including the following:? 21.019 Coronavirus Relief Fund excluded. Contracts 4120 & 8328 passed through by the United Way of King County & the contract passed through by the Washington State Housing Finance Commission (WSHFC) totaled $205,822 but were not included in the original SEFA provided.? 21.023 Emergency Rental Assistance Program Contract 9395 passed through by the United Way of King County understated by $341,000.? 21.023 Emergency Rental Assistance Program Contract excluded. Contract 8366 passed through by the United Way of King County included $8,274,601 of federal funds that were not included on the original SEFA provided for audit.? 21.026 Homeowner Assistance Fund contact #HAF0025 passed through by WSHFC overstated by $124,710.? 91.024 Emergency Food and Shelter contract #889000-033 passed through by United Way of King County overstated by $66,542.? 17.258 WIOA Title 1b Adult Services contract #21-115-ADU passed through by Workforce Development Council of King County not identified as part of the WIOA Cluster.Additionally, the prior year SEFA was overstated by $704,017 for the 20.019 Coronavirus Relief Fund Contracts #4120 and #8328 passed through by the United Way of King County due to the accounting error identified in Finding 2022-001.Effect:Inaccurate identification of programs subject to the Single Audit increases the risk that the Organization will not comply with the terms and conditions of federal programs.Cause:As noted in Finding 2022-001, the Organization did not correctly account for advanced federal funds and as noted in Finding 2022-003, the Organization has not implemented a policy for advanced federal funds that complies with 2 CFR 200.305. These gaps in internal control resulted in cut-off errors in SEFA reporting for FY21 & FY22. Additionally, the Organization has not been applying the guidance of Section 200.502 of the Uniform Guidance in preparing the SEFA. Lastly, the program manager of the pass through agency of the 21.023 Emergency Rental Assistance Program Contract #8366 incorrectly informed the Organization that it had no responsibility for reporting the contract as a subrecipient of federal funds.Recommendation:The Organization must continue to increase its familiarity with federal grant compliance requirements and establish a process for timely identification of federal programs and a system for tracking contracts in order to ensure compliance with federal award programs and to completeness and accuracy in SEFA reporting.Questioned Costs: NoneManagement Response and Corrective Action Plan: See Corrective Action PlanContact Person: Mansour Camara, CFO
2022-002 Reporting ? Schedule of Expenditures of Federal AwardsIdentification as a Repeat Finding: Repeat of Finding 2021-004.Finding:The SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards.Criteria:The Organization is responsible for maintaining accurate information about all federal programs and reporting requirements. The Organization is responsible for using this information to comply with the Uniform Guidance in carrying out federal programs.Sample Size and Population: N/ACondition and Context:The original SEFA provided for audit contained errors in identifying programs, program clusters and expenditures of federal awards including the following:? 21.019 Coronavirus Relief Fund excluded. Contracts 4120 & 8328 passed through by the United Way of King County & the contract passed through by the Washington State Housing Finance Commission (WSHFC) totaled $205,822 but were not included in the original SEFA provided.? 21.023 Emergency Rental Assistance Program Contract 9395 passed through by the United Way of King County understated by $341,000.? 21.023 Emergency Rental Assistance Program Contract excluded. Contract 8366 passed through by the United Way of King County included $8,274,601 of federal funds that were not included on the original SEFA provided for audit.? 21.026 Homeowner Assistance Fund contact #HAF0025 passed through by WSHFC overstated by $124,710.? 91.024 Emergency Food and Shelter contract #889000-033 passed through by United Way of King County overstated by $66,542.? 17.258 WIOA Title 1b Adult Services contract #21-115-ADU passed through by Workforce Development Council of King County not identified as part of the WIOA Cluster.Additionally, the prior year SEFA was overstated by $704,017 for the 20.019 Coronavirus Relief Fund Contracts #4120 and #8328 passed through by the United Way of King County due to the accounting error identified in Finding 2022-001.Effect:Inaccurate identification of programs subject to the Single Audit increases the risk that the Organization will not comply with the terms and conditions of federal programs.Cause:As noted in Finding 2022-001, the Organization did not correctly account for advanced federal funds and as noted in Finding 2022-003, the Organization has not implemented a policy for advanced federal funds that complies with 2 CFR 200.305. These gaps in internal control resulted in cut-off errors in SEFA reporting for FY21 & FY22. Additionally, the Organization has not been applying the guidance of Section 200.502 of the Uniform Guidance in preparing the SEFA. Lastly, the program manager of the pass through agency of the 21.023 Emergency Rental Assistance Program Contract #8366 incorrectly informed the Organization that it had no responsibility for reporting the contract as a subrecipient of federal funds.Recommendation:The Organization must continue to increase its familiarity with federal grant compliance requirements and establish a process for timely identification of federal programs and a system for tracking contracts in order to ensure compliance with federal award programs and to completeness and accuracy in SEFA reporting.Questioned Costs: NoneManagement Response and Corrective Action Plan: See Corrective Action PlanContact Person: Mansour Camara, CFO
FINDING 2022-207The amount reported as passed through to subrecipients on the Schedule of Expenditures of Federal Awards (SEFA) closing package was overstated by $331,500.Type of Finding: Significant DeficiencyAssistance Listing Title: Sport Fish Restoration; Wildlife Restoration and Basic Hunter EducationAssistance Listing Number: 15.605; 15.611Federal Award Number: F19AF00026; F19AF00093; F22AF00371; F14AF01014; F20AF11918; F22AF00372; F20AF11578; F21AF03374; F21AF03986; F21AF03986Program Year: January 1, 2019 ? December 31, 2021; January 1, 2019 ? December 31, 2021; January 1, 2022 ? December 31, 2024; August 1, 2014 ? June 30, 2022; July 1, 2020 ? June 30, 2021; January 1, 2022 ? December 31, 2024; July 1, 2020 ? June 30, 2021; July 1, 2021 ? June 30, 2023; July 1, 2021 ? June 30, 2022; July 1, 2021 ? June 30, 2022Federal Agency: Department of the InteriorCompliance Requirement: Code of Federal Regulations (CRF) 2 CFR 200.510(b)Questioned Costs: NoneCriteria: The Internal Control Integrated Framework published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) provides a basis for organizations to design internal control procedures to ensure reliable financial reporting, effective and efficient operations, and compliance with applicable laws and regulations. Components of this framework include risk assessment, control activities, and information and communication. Risk assessment is the identification and analysis of various risks entities face because of changing economic, industry, regulatory, and operating conditions. It provides a basis to develop appropriate responses to manage those risks. Control activities are policies and procedures that help ensure management directives are carried out and risks are mitigated. Verifications, approvals, reconciliations, authorizations, and segregation of duties are all control activities that support this objective. Information and communication relate to obtaining quality information and effective internal and external communication of that information to achieve management objectives.Management objectives should include the preparation and fair presentation of the SEFA in relation to the basic financial statements as a whole and in compliance with requirements contained in the U.S. Code of Federal Regulations (CFR), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) 2 CFR ?200.510(b), which states it must include:? Total federal awards expended as determined in accordance with 2 CFR ?200.502, and? Total amount provided to subrecipients from each federal programCondition: The Department completed a SEFA closing package to report federal grant expenditures. The amount reported as passed through to subrecipients was overstated by a total of $331,500. The Sport Fish Restoration Program (Assistance Listing Number 15.605) payments to subrecipients were overstated by $10,513, and the Wildlife Restoration Program (Assistance Listing Number 16.611) payments to subrecipients were overstated by $320,987.Cause: The Department made payments to entities who received subawards under the grants and also provided specific vendor services for the grants. The person compiling the SEFA closing package was new to that process and included all payments to the entities as payments to subrecipients, even though some of the payments were for vendor services and should not have been included. The SEFA closing package was reviewed for accuracy prior to being submitted to the Office of the State Controller, but this review did not detect the error.Effect: The Department?s SEFA closing package overstated the amount passed through to subrecipients by $331,500. The total expenditures for the grant programs were $7,196,361 in the Sport Fish Restoration Program and $15,479,486 in the Wildlife Restoration Program. Subrecipient payments make up a small portion of the overall grant expenditures comprising $31,539 in the Sport Fish Restoration Program (0.44 percent of the total) and $520,630 in the Wildlife Restoration Program (3.36 percent of the total). The effect is limited because the trivial materiality for the statewide SEFA is $1.9 million. The Department submitted a corrected SEFA closing package to correct the error.Recommendation: We recommend that the Department design and implement procedures to ensure amounts passed through to subrecipients are accurately reported on the SEFA closing package.Management?s View: The Department has reviewed its reporting of subrecipient expenditures on the State Fiscal Year 2022 Schedule of Expenditure of Federal Awards (?SEFA?) and agrees with the finding that an overstatement was made.Corrective Action: The Department will provide additional training and update its procedural documentation to ensure that expenses are thoroughly vetted before they are reported as subrecipient expenditures on the SEFA. Each expenditure identified as a subrecipient expense will be tied back to a specific subaward, further limiting the possibility of non-subaward expenses being reported in the subrecipient portion of the SEFA. This corrective action plan will be implemented by the end of August 2023.Auditor?s Concluding Remarks: We thank the Department for its cooperation and assistance throughout the audit.
FINDING 2022-207The amount reported as passed through to subrecipients on the Schedule of Expenditures of Federal Awards (SEFA) closing package was overstated by $331,500.Type of Finding: Significant DeficiencyAssistance Listing Title: Sport Fish Restoration; Wildlife Restoration and Basic Hunter EducationAssistance Listing Number: 15.605; 15.611Federal Award Number: F19AF00026; F19AF00093; F22AF00371; F14AF01014; F20AF11918; F22AF00372; F20AF11578; F21AF03374; F21AF03986; F21AF03986Program Year: January 1, 2019 ? December 31, 2021; January 1, 2019 ? December 31, 2021; January 1, 2022 ? December 31, 2024; August 1, 2014 ? June 30, 2022; July 1, 2020 ? June 30, 2021; January 1, 2022 ? December 31, 2024; July 1, 2020 ? June 30, 2021; July 1, 2021 ? June 30, 2023; July 1, 2021 ? June 30, 2022; July 1, 2021 ? June 30, 2022Federal Agency: Department of the InteriorCompliance Requirement: Code of Federal Regulations (CRF) 2 CFR 200.510(b)Questioned Costs: NoneCriteria: The Internal Control Integrated Framework published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) provides a basis for organizations to design internal control procedures to ensure reliable financial reporting, effective and efficient operations, and compliance with applicable laws and regulations. Components of this framework include risk assessment, control activities, and information and communication. Risk assessment is the identification and analysis of various risks entities face because of changing economic, industry, regulatory, and operating conditions. It provides a basis to develop appropriate responses to manage those risks. Control activities are policies and procedures that help ensure management directives are carried out and risks are mitigated. Verifications, approvals, reconciliations, authorizations, and segregation of duties are all control activities that support this objective. Information and communication relate to obtaining quality information and effective internal and external communication of that information to achieve management objectives.Management objectives should include the preparation and fair presentation of the SEFA in relation to the basic financial statements as a whole and in compliance with requirements contained in the U.S. Code of Federal Regulations (CFR), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) 2 CFR ?200.510(b), which states it must include:? Total federal awards expended as determined in accordance with 2 CFR ?200.502, and? Total amount provided to subrecipients from each federal programCondition: The Department completed a SEFA closing package to report federal grant expenditures. The amount reported as passed through to subrecipients was overstated by a total of $331,500. The Sport Fish Restoration Program (Assistance Listing Number 15.605) payments to subrecipients were overstated by $10,513, and the Wildlife Restoration Program (Assistance Listing Number 16.611) payments to subrecipients were overstated by $320,987.Cause: The Department made payments to entities who received subawards under the grants and also provided specific vendor services for the grants. The person compiling the SEFA closing package was new to that process and included all payments to the entities as payments to subrecipients, even though some of the payments were for vendor services and should not have been included. The SEFA closing package was reviewed for accuracy prior to being submitted to the Office of the State Controller, but this review did not detect the error.Effect: The Department?s SEFA closing package overstated the amount passed through to subrecipients by $331,500. The total expenditures for the grant programs were $7,196,361 in the Sport Fish Restoration Program and $15,479,486 in the Wildlife Restoration Program. Subrecipient payments make up a small portion of the overall grant expenditures comprising $31,539 in the Sport Fish Restoration Program (0.44 percent of the total) and $520,630 in the Wildlife Restoration Program (3.36 percent of the total). The effect is limited because the trivial materiality for the statewide SEFA is $1.9 million. The Department submitted a corrected SEFA closing package to correct the error.Recommendation: We recommend that the Department design and implement procedures to ensure amounts passed through to subrecipients are accurately reported on the SEFA closing package.Management?s View: The Department has reviewed its reporting of subrecipient expenditures on the State Fiscal Year 2022 Schedule of Expenditure of Federal Awards (?SEFA?) and agrees with the finding that an overstatement was made.Corrective Action: The Department will provide additional training and update its procedural documentation to ensure that expenses are thoroughly vetted before they are reported as subrecipient expenditures on the SEFA. Each expenditure identified as a subrecipient expense will be tied back to a specific subaward, further limiting the possibility of non-subaward expenses being reported in the subrecipient portion of the SEFA. This corrective action plan will be implemented by the end of August 2023.Auditor?s Concluding Remarks: We thank the Department for its cooperation and assistance throughout the audit.
FINDING 2022-203Errors in the elimination process for federal grants between State agencies resulted in misstatements to the Schedule of Expenditures of Federal Awards (SEFA) totaling $14,656,928 for direct awards and $14,278,362 provided to subrecipients.Type of Finding: Significant Deficiency, SEFA MisstatementAssistance Listing Title: State and Local Fiscal Recovery Fund; Gaining Early Awareness and Readiness for Undergraduate ProgramsAssistance Listing Number: 21.027; 84.334SFederal Award Number: 20-1982-0-1-806; PS334S110016Program Year: March 3, 2021 - December 31, 2024; September 26, 2011 - September 25, 2018Federal Agency: Department of Treasury; Department of EducationCompliance Requirement: Code of Federal Regulations (CRF) 2 CFR 200.510(b)Questioned Costs: NoneCriteria: The Internal Control Integrated Framework published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) provides a basis for organizations to design internal control procedures to ensure reliable financial reporting, effective and efficient operations, and compliance with applicable laws and regulations. Components of this framework include risk assessment, control activities, and information and communication. Risk assessment is the identification and analysis of various risks entities face because of changing economic, industry, regulatory, and operating conditions. It provides a basis to develop appropriate responses to manage those risks. Control activities are policies and procedures that help ensure management directives are carried out and risks are mitigated. Verifications, approvals, reconciliations, authorizations, and segregation of duties are all control activities that support this objective. Information and communication relate to obtaining quality information and effective internal and external communication of that information to achieve management objectives.Management objectives should include the preparation and fair presentation of the SEFA in relation to the basic financial statements as a whole and in compliance with requirements contained in the U.S. Code of Federal Regulations (CFR), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) (2 CFR ?200.510(b)), which states it must include:? Total federal awards expended as determined in accordance with 2 CFR ?200.502? Total amount provided to subrecipients from each federal programCondition: The SEFA submitted for audit purposes included misstatements for Direct Awards and Amounts Provided to Subrecipients for Assistance Listing (AL) Number 21.027 (Coronavirus State and Local Fiscal Recovery Fund (CSLFRF)) and 84.334S (Gaining Early Awareness and Readiness for Undergraduate Programs (GEARUP)). We noted the following errors:? Amounts for AL Number 21.027 were overstated by $12,534,055 for Direct Award Expenditures and by $12,171,845 for Amounts Provided to Subrecipients? Amounts for AL Number 84.334S were understated by $2,122,873 for Direct Expenditures and by $2,106,517 for Amounts Provided to SubrecipientsCause: Each year, State agencies report the total of federal awards expended on a closing package. The Office uses these closing packages to compile the SEFA. Federal funds received by one State agency and then passed on to another State agency get reported on both State agencies? SEFA closing package. The Office completes eliminations to avoid double counting expenditures for the same federal program. The Office?s review procedures over this process did not detect or prevent the duplicate expenditures for AL Number 21.027 and did not prevent the erroneous elimination of actual expenditures for AL Number 84.334S.Effect: The SEFA submitted for audit contained misstatements; however, these errors have been corrected.Recommendation: We recommend that the Office design and implement procedures to ensure amounts are properly reported and proper adjustments are made when federal funds are shared between State agencies.Management?s View: The Office agrees with this finding.Corrective Action: We will improve our elimination and reporting process by adding the following steps:? We will add an additional tab to our SEFA Master file to cross check all COVID-19 related funding to ensure agencies are not double reporting expenditures.? We will add additional steps to our SEFA preparation and review checklist outlining specific steps for completing the subrecipient elimination process, and identify higher risk areas that require the most scrutiny.? We will also improve our current elimination tab (awards received from other state agencies) and reconciliation procedures for subrecipients.Auditor?s Concluding Remarks: We thank the Office for its cooperation and assistance throughout the audit.
FINDING 2022-203Errors in the elimination process for federal grants between State agencies resulted in misstatements to the Schedule of Expenditures of Federal Awards (SEFA) totaling $14,656,928 for direct awards and $14,278,362 provided to subrecipients.Type of Finding: Significant Deficiency, SEFA MisstatementAssistance Listing Title: State and Local Fiscal Recovery Fund; Gaining Early Awareness and Readiness for Undergraduate ProgramsAssistance Listing Number: 21.027; 84.334SFederal Award Number: 20-1982-0-1-806; PS334S110016Program Year: March 3, 2021 - December 31, 2024; September 26, 2011 - September 25, 2018Federal Agency: Department of Treasury; Department of EducationCompliance Requirement: Code of Federal Regulations (CRF) 2 CFR 200.510(b)Questioned Costs: NoneCriteria: The Internal Control Integrated Framework published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) provides a basis for organizations to design internal control procedures to ensure reliable financial reporting, effective and efficient operations, and compliance with applicable laws and regulations. Components of this framework include risk assessment, control activities, and information and communication. Risk assessment is the identification and analysis of various risks entities face because of changing economic, industry, regulatory, and operating conditions. It provides a basis to develop appropriate responses to manage those risks. Control activities are policies and procedures that help ensure management directives are carried out and risks are mitigated. Verifications, approvals, reconciliations, authorizations, and segregation of duties are all control activities that support this objective. Information and communication relate to obtaining quality information and effective internal and external communication of that information to achieve management objectives.Management objectives should include the preparation and fair presentation of the SEFA in relation to the basic financial statements as a whole and in compliance with requirements contained in the U.S. Code of Federal Regulations (CFR), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) (2 CFR ?200.510(b)), which states it must include:? Total federal awards expended as determined in accordance with 2 CFR ?200.502? Total amount provided to subrecipients from each federal programCondition: The SEFA submitted for audit purposes included misstatements for Direct Awards and Amounts Provided to Subrecipients for Assistance Listing (AL) Number 21.027 (Coronavirus State and Local Fiscal Recovery Fund (CSLFRF)) and 84.334S (Gaining Early Awareness and Readiness for Undergraduate Programs (GEARUP)). We noted the following errors:? Amounts for AL Number 21.027 were overstated by $12,534,055 for Direct Award Expenditures and by $12,171,845 for Amounts Provided to Subrecipients? Amounts for AL Number 84.334S were understated by $2,122,873 for Direct Expenditures and by $2,106,517 for Amounts Provided to SubrecipientsCause: Each year, State agencies report the total of federal awards expended on a closing package. The Office uses these closing packages to compile the SEFA. Federal funds received by one State agency and then passed on to another State agency get reported on both State agencies? SEFA closing package. The Office completes eliminations to avoid double counting expenditures for the same federal program. The Office?s review procedures over this process did not detect or prevent the duplicate expenditures for AL Number 21.027 and did not prevent the erroneous elimination of actual expenditures for AL Number 84.334S.Effect: The SEFA submitted for audit contained misstatements; however, these errors have been corrected.Recommendation: We recommend that the Office design and implement procedures to ensure amounts are properly reported and proper adjustments are made when federal funds are shared between State agencies.Management?s View: The Office agrees with this finding.Corrective Action: We will improve our elimination and reporting process by adding the following steps:? We will add an additional tab to our SEFA Master file to cross check all COVID-19 related funding to ensure agencies are not double reporting expenditures.? We will add additional steps to our SEFA preparation and review checklist outlining specific steps for completing the subrecipient elimination process, and identify higher risk areas that require the most scrutiny.? We will also improve our current elimination tab (awards received from other state agencies) and reconciliation procedures for subrecipients.Auditor?s Concluding Remarks: We thank the Office for its cooperation and assistance throughout the audit.
FINDING 2022-203Errors in the elimination process for federal grants between State agencies resulted in misstatements to the Schedule of Expenditures of Federal Awards (SEFA) totaling $14,656,928 for direct awards and $14,278,362 provided to subrecipients.Type of Finding: Significant Deficiency, SEFA MisstatementAssistance Listing Title: State and Local Fiscal Recovery Fund; Gaining Early Awareness and Readiness for Undergraduate ProgramsAssistance Listing Number: 21.027; 84.334SFederal Award Number: 20-1982-0-1-806; PS334S110016Program Year: March 3, 2021 - December 31, 2024; September 26, 2011 - September 25, 2018Federal Agency: Department of Treasury; Department of EducationCompliance Requirement: Code of Federal Regulations (CRF) 2 CFR 200.510(b)Questioned Costs: NoneCriteria: The Internal Control Integrated Framework published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) provides a basis for organizations to design internal control procedures to ensure reliable financial reporting, effective and efficient operations, and compliance with applicable laws and regulations. Components of this framework include risk assessment, control activities, and information and communication. Risk assessment is the identification and analysis of various risks entities face because of changing economic, industry, regulatory, and operating conditions. It provides a basis to develop appropriate responses to manage those risks. Control activities are policies and procedures that help ensure management directives are carried out and risks are mitigated. Verifications, approvals, reconciliations, authorizations, and segregation of duties are all control activities that support this objective. Information and communication relate to obtaining quality information and effective internal and external communication of that information to achieve management objectives.Management objectives should include the preparation and fair presentation of the SEFA in relation to the basic financial statements as a whole and in compliance with requirements contained in the U.S. Code of Federal Regulations (CFR), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) (2 CFR ?200.510(b)), which states it must include:? Total federal awards expended as determined in accordance with 2 CFR ?200.502? Total amount provided to subrecipients from each federal programCondition: The SEFA submitted for audit purposes included misstatements for Direct Awards and Amounts Provided to Subrecipients for Assistance Listing (AL) Number 21.027 (Coronavirus State and Local Fiscal Recovery Fund (CSLFRF)) and 84.334S (Gaining Early Awareness and Readiness for Undergraduate Programs (GEARUP)). We noted the following errors:? Amounts for AL Number 21.027 were overstated by $12,534,055 for Direct Award Expenditures and by $12,171,845 for Amounts Provided to Subrecipients? Amounts for AL Number 84.334S were understated by $2,122,873 for Direct Expenditures and by $2,106,517 for Amounts Provided to SubrecipientsCause: Each year, State agencies report the total of federal awards expended on a closing package. The Office uses these closing packages to compile the SEFA. Federal funds received by one State agency and then passed on to another State agency get reported on both State agencies? SEFA closing package. The Office completes eliminations to avoid double counting expenditures for the same federal program. The Office?s review procedures over this process did not detect or prevent the duplicate expenditures for AL Number 21.027 and did not prevent the erroneous elimination of actual expenditures for AL Number 84.334S.Effect: The SEFA submitted for audit contained misstatements; however, these errors have been corrected.Recommendation: We recommend that the Office design and implement procedures to ensure amounts are properly reported and proper adjustments are made when federal funds are shared between State agencies.Management?s View: The Office agrees with this finding.Corrective Action: We will improve our elimination and reporting process by adding the following steps:? We will add an additional tab to our SEFA Master file to cross check all COVID-19 related funding to ensure agencies are not double reporting expenditures.? We will add additional steps to our SEFA preparation and review checklist outlining specific steps for completing the subrecipient elimination process, and identify higher risk areas that require the most scrutiny.? We will also improve our current elimination tab (awards received from other state agencies) and reconciliation procedures for subrecipients.Auditor?s Concluding Remarks: We thank the Office for its cooperation and assistance throughout the audit.
FINDING 2022-203Errors in the elimination process for federal grants between State agencies resulted in misstatements to the Schedule of Expenditures of Federal Awards (SEFA) totaling $14,656,928 for direct awards and $14,278,362 provided to subrecipients.Type of Finding: Significant Deficiency, SEFA MisstatementAssistance Listing Title: State and Local Fiscal Recovery Fund; Gaining Early Awareness and Readiness for Undergraduate ProgramsAssistance Listing Number: 21.027; 84.334SFederal Award Number: 20-1982-0-1-806; PS334S110016Program Year: March 3, 2021 - December 31, 2024; September 26, 2011 - September 25, 2018Federal Agency: Department of Treasury; Department of EducationCompliance Requirement: Code of Federal Regulations (CRF) 2 CFR 200.510(b)Questioned Costs: NoneCriteria: The Internal Control Integrated Framework published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) provides a basis for organizations to design internal control procedures to ensure reliable financial reporting, effective and efficient operations, and compliance with applicable laws and regulations. Components of this framework include risk assessment, control activities, and information and communication. Risk assessment is the identification and analysis of various risks entities face because of changing economic, industry, regulatory, and operating conditions. It provides a basis to develop appropriate responses to manage those risks. Control activities are policies and procedures that help ensure management directives are carried out and risks are mitigated. Verifications, approvals, reconciliations, authorizations, and segregation of duties are all control activities that support this objective. Information and communication relate to obtaining quality information and effective internal and external communication of that information to achieve management objectives.Management objectives should include the preparation and fair presentation of the SEFA in relation to the basic financial statements as a whole and in compliance with requirements contained in the U.S. Code of Federal Regulations (CFR), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) (2 CFR ?200.510(b)), which states it must include:? Total federal awards expended as determined in accordance with 2 CFR ?200.502? Total amount provided to subrecipients from each federal programCondition: The SEFA submitted for audit purposes included misstatements for Direct Awards and Amounts Provided to Subrecipients for Assistance Listing (AL) Number 21.027 (Coronavirus State and Local Fiscal Recovery Fund (CSLFRF)) and 84.334S (Gaining Early Awareness and Readiness for Undergraduate Programs (GEARUP)). We noted the following errors:? Amounts for AL Number 21.027 were overstated by $12,534,055 for Direct Award Expenditures and by $12,171,845 for Amounts Provided to Subrecipients? Amounts for AL Number 84.334S were understated by $2,122,873 for Direct Expenditures and by $2,106,517 for Amounts Provided to SubrecipientsCause: Each year, State agencies report the total of federal awards expended on a closing package. The Office uses these closing packages to compile the SEFA. Federal funds received by one State agency and then passed on to another State agency get reported on both State agencies? SEFA closing package. The Office completes eliminations to avoid double counting expenditures for the same federal program. The Office?s review procedures over this process did not detect or prevent the duplicate expenditures for AL Number 21.027 and did not prevent the erroneous elimination of actual expenditures for AL Number 84.334S.Effect: The SEFA submitted for audit contained misstatements; however, these errors have been corrected.Recommendation: We recommend that the Office design and implement procedures to ensure amounts are properly reported and proper adjustments are made when federal funds are shared between State agencies.Management?s View: The Office agrees with this finding.Corrective Action: We will improve our elimination and reporting process by adding the following steps:? We will add an additional tab to our SEFA Master file to cross check all COVID-19 related funding to ensure agencies are not double reporting expenditures.? We will add additional steps to our SEFA preparation and review checklist outlining specific steps for completing the subrecipient elimination process, and identify higher risk areas that require the most scrutiny.? We will also improve our current elimination tab (awards received from other state agencies) and reconciliation procedures for subrecipients.Auditor?s Concluding Remarks: We thank the Office for its cooperation and assistance throughout the audit.
FINDING 2022-204COVID-19 funds in the amount of $196,247,971 were not properly identified on the statewide Schedule of Expenditures of Federal Awards (SEFA), as required.Type of Finding: Noncompliance, Material Weakness, SEFA MisstatementAssistance Listing Title: Supplemental Nutrition Assistance Program (SNAP); WIC Special Supplemental Nutrition Program for Women, Infants, and Children; State Administrative Matching Grants for the Supplemental Nutrition Assistance Program; Grants to States for Construction of State Home Facilities; Special Education - Grants for Infants and Families; Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises; Community-Based Child Abuse Prevention Grants; Block Grants for Community Mental Health Services; Sexually Transmitted Diseases (STD) Prevention and Control Grants; Disaster Grants ? Public Assistance (Presidentially Declared Disasters)Assistance Listing Number: 10.551; 10.557; 10.561; 64.005; 84.181; 93.391; 93.497; 93.590; 93.958; 93.977; 97.036Federal Award Number: 22ID35051692301; 217IDID7W7003; 227IDID7F1003; FAI 16-012; FAI 16-013; H181X21016; NH75OT000105; 2202IDFSC6; 2101IDBCC6; B09SM083970; NH25PS005171; 4534DRIP00000001Program Year: October 1, 2021 ? September 30, 2022; October 1, 2020 ? September 30, 2021; October 1, 2021 ? September 30, 2021; May 8, 2021 ? June 30, 2022; June 28, 2021 ? June 30, 2022; July 1, 2021 ? September 30, 2022; June 1, 2021 ? May 31, 2023; October 1, 2020 ? September 30, 2025; October 1, 2020 ? September 30, 2025; March 15, 2021 ? March 14, 2023; January 1, 2019 ? December 31, 2023; May 8, 2020 ? June 30, 2022Federal Agency: Department of Agriculture; Department of Veterans Affairs; Department of Education; Health and Human Services; Department of Homeland SecurityCompliance Requirement: Code of Federal Regulations (CRF) 2 CFR 200.510(b)Questioned Costs: NoneCriteria: The Internal Control Integrated Framework published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) provides a basis for organizations to design internal control procedures to ensure reliable financial reporting, effective and efficient operations, and compliance with applicable laws and regulations. Components of this framework include risk assessment, control activities, and information and communication. Risk assessment is the identification and analysis of various risks entities face because of changing economic, industry, regulatory, and operating conditions, and provides a basis to develop appropriate responses to manage those risks. Control activities are policies and procedures that help ensure management directives are carried out and risks are mitigated. Verifications, approvals, reconciliations, authorizations, and segregation of duties are all control activities that support this objective. Information and communication relate to obtaining quality information and effective internal and external communication of that information to achieve management objectives.Management objectives should include the preparation and fair presentation of the SEFA in relation to the basic financial statements as a whole and in compliance with requirements contained in the U.S. Code of Federal Regulations (CFR), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) (2 CFR ?200.510(b)), which states it must include:? Total federal awards expended as determined in accordance with 2 CFR ?200.502? Total amount provided to subrecipients from each federal programAdditionally, the Office of Management and Budget (OMB) Memorandum M-20-26 instructed recipients and subrecipients to separately identify the COVID-19 Emergency Acts expenditures on the SEFA.Condition: Several assistance listings (AL) were not properly identified as COVID-19 funds on the SEFA submitted for audit. The following items were identified by the auditors and communicated to management during the audit process:? Supplemental Nutrition Assistance Program (AL Number 10.551) $38,370,588? Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises (AL Number 93.391) $3,387,573? Special Education - Grants for Infants and Families (AL Number 84.181) $265,777? Family Violence Prevention and Services/Sexual Assault/Rape Crisis Services and Supports (AL Number 93.497) $183,807? WIC Special Supplemental Nutrition Program for Women, Infants, and Children (AL Number 10.557) $1,547,158? State Administrative Matching Grants for the Supplemental Nutrition Assistance Program (AL Number 10.561) $354,983? Community-Based Child Abuse Prevention Grants (AL Number 93.590) $156,539? Block Grants for Community Mental Health Services (AL Number 93.958) $389,232? Sexually Transmitted Diseases (STD) Prevention and Control Grants (AL Number 93.977) $156,712? State Veterans Home Construction (AL Number 64.005) $1,513,996? Education Stabilization Fund - Emergency Assistance for Non-Public Schools (AL Number 84.425R) $3,145,463? Disaster Grants ? Public Assistance (Presidentially Declared Disasters) (AL Number 97.036) $146,776,143Cause: The Office has not developed procedures to ensure amounts reported by State agencies on closing packages properly identifies all funds related to COVID-19. The Office relies on State agencies to self-report federal expenditures, programs, and identify if these programs are related to COVID-19 funding through the closing package process. Current procedures do not include verifying that the COVID-19 designation is appropriately included.Additionally, review procedures did not identify an error that occurred while compiling the SEFA that did not include the COVID-19 designation for AL Number 84.425R. Internal reviews did not identify this error as this information was correctly included on the agency closing package.Effect: The SEFA submitted for audit did not properly identify $196,247,971 as COVID-19 funds on the SEFA; however, these errors have been corrected.Recommendation: We recommend that the Office implement procedures and controls to ensure funds related to the COVID-19 pandemic are properly identified on the SEFA.Management?s View: The Office agrees with this finding.Corrective Action: Since the State began receiving COVID-19 funding, we diligently provided training and resources to the agencies regarding the funding and how it should be reported on the SEFA closing package. This includes a discussion in our annual closing package training, online resources regarding COVID-19 funds, an FAQ document, and being available to discuss questions and concerns. In addition to the steps we are currently taking, we will reiterate the importance of designating COVID-19 related expenditures on the SEFA closing package during our annual closing package training. We will review STARS activity in the COVID-19 related funds and compare to the agency submitted closing packages for reasonableness. Recognizing that not all agencies utilize these specific funds, we will also review COVID-19 related expenditures on an external online source that reports federal grant expenditures. We will then use this information to compare to what is reported on agency closing packages for reasonableness.Auditor?s Concluding Remarks: We thank the Office for its cooperation and assistance throughout the audit.
FINDING 2022-204COVID-19 funds in the amount of $196,247,971 were not properly identified on the statewide Schedule of Expenditures of Federal Awards (SEFA), as required.Type of Finding: Noncompliance, Material Weakness, SEFA MisstatementAssistance Listing Title: Supplemental Nutrition Assistance Program (SNAP); WIC Special Supplemental Nutrition Program for Women, Infants, and Children; State Administrative Matching Grants for the Supplemental Nutrition Assistance Program; Grants to States for Construction of State Home Facilities; Special Education - Grants for Infants and Families; Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises; Community-Based Child Abuse Prevention Grants; Block Grants for Community Mental Health Services; Sexually Transmitted Diseases (STD) Prevention and Control Grants; Disaster Grants ? Public Assistance (Presidentially Declared Disasters)Assistance Listing Number: 10.551; 10.557; 10.561; 64.005; 84.181; 93.391; 93.497; 93.590; 93.958; 93.977; 97.036Federal Award Number: 22ID35051692301; 217IDID7W7003; 227IDID7F1003; FAI 16-012; FAI 16-013; H181X21016; NH75OT000105; 2202IDFSC6; 2101IDBCC6; B09SM083970; NH25PS005171; 4534DRIP00000001Program Year: October 1, 2021 ? September 30, 2022; October 1, 2020 ? September 30, 2021; October 1, 2021 ? September 30, 2021; May 8, 2021 ? June 30, 2022; June 28, 2021 ? June 30, 2022; July 1, 2021 ? September 30, 2022; June 1, 2021 ? May 31, 2023; October 1, 2020 ? September 30, 2025; October 1, 2020 ? September 30, 2025; March 15, 2021 ? March 14, 2023; January 1, 2019 ? December 31, 2023; May 8, 2020 ? June 30, 2022Federal Agency: Department of Agriculture; Department of Veterans Affairs; Department of Education; Health and Human Services; Department of Homeland SecurityCompliance Requirement: Code of Federal Regulations (CRF) 2 CFR 200.510(b)Questioned Costs: NoneCriteria: The Internal Control Integrated Framework published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) provides a basis for organizations to design internal control procedures to ensure reliable financial reporting, effective and efficient operations, and compliance with applicable laws and regulations. Components of this framework include risk assessment, control activities, and information and communication. Risk assessment is the identification and analysis of various risks entities face because of changing economic, industry, regulatory, and operating conditions, and provides a basis to develop appropriate responses to manage those risks. Control activities are policies and procedures that help ensure management directives are carried out and risks are mitigated. Verifications, approvals, reconciliations, authorizations, and segregation of duties are all control activities that support this objective. Information and communication relate to obtaining quality information and effective internal and external communication of that information to achieve management objectives.Management objectives should include the preparation and fair presentation of the SEFA in relation to the basic financial statements as a whole and in compliance with requirements contained in the U.S. Code of Federal Regulations (CFR), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) (2 CFR ?200.510(b)), which states it must include:? Total federal awards expended as determined in accordance with 2 CFR ?200.502? Total amount provided to subrecipients from each federal programAdditionally, the Office of Management and Budget (OMB) Memorandum M-20-26 instructed recipients and subrecipients to separately identify the COVID-19 Emergency Acts expenditures on the SEFA.Condition: Several assistance listings (AL) were not properly identified as COVID-19 funds on the SEFA submitted for audit. The following items were identified by the auditors and communicated to management during the audit process:? Supplemental Nutrition Assistance Program (AL Number 10.551) $38,370,588? Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises (AL Number 93.391) $3,387,573? Special Education - Grants for Infants and Families (AL Number 84.181) $265,777? Family Violence Prevention and Services/Sexual Assault/Rape Crisis Services and Supports (AL Number 93.497) $183,807? WIC Special Supplemental Nutrition Program for Women, Infants, and Children (AL Number 10.557) $1,547,158? State Administrative Matching Grants for the Supplemental Nutrition Assistance Program (AL Number 10.561) $354,983? Community-Based Child Abuse Prevention Grants (AL Number 93.590) $156,539? Block Grants for Community Mental Health Services (AL Number 93.958) $389,232? Sexually Transmitted Diseases (STD) Prevention and Control Grants (AL Number 93.977) $156,712? State Veterans Home Construction (AL Number 64.005) $1,513,996? Education Stabilization Fund - Emergency Assistance for Non-Public Schools (AL Number 84.425R) $3,145,463? Disaster Grants ? Public Assistance (Presidentially Declared Disasters) (AL Number 97.036) $146,776,143Cause: The Office has not developed procedures to ensure amounts reported by State agencies on closing packages properly identifies all funds related to COVID-19. The Office relies on State agencies to self-report federal expenditures, programs, and identify if these programs are related to COVID-19 funding through the closing package process. Current procedures do not include verifying that the COVID-19 designation is appropriately included.Additionally, review procedures did not identify an error that occurred while compiling the SEFA that did not include the COVID-19 designation for AL Number 84.425R. Internal reviews did not identify this error as this information was correctly included on the agency closing package.Effect: The SEFA submitted for audit did not properly identify $196,247,971 as COVID-19 funds on the SEFA; however, these errors have been corrected.Recommendation: We recommend that the Office implement procedures and controls to ensure funds related to the COVID-19 pandemic are properly identified on the SEFA.Management?s View: The Office agrees with this finding.Corrective Action: Since the State began receiving COVID-19 funding, we diligently provided training and resources to the agencies regarding the funding and how it should be reported on the SEFA closing package. This includes a discussion in our annual closing package training, online resources regarding COVID-19 funds, an FAQ document, and being available to discuss questions and concerns. In addition to the steps we are currently taking, we will reiterate the importance of designating COVID-19 related expenditures on the SEFA closing package during our annual closing package training. We will review STARS activity in the COVID-19 related funds and compare to the agency submitted closing packages for reasonableness. Recognizing that not all agencies utilize these specific funds, we will also review COVID-19 related expenditures on an external online source that reports federal grant expenditures. We will then use this information to compare to what is reported on agency closing packages for reasonableness.Auditor?s Concluding Remarks: We thank the Office for its cooperation and assistance throughout the audit.
FINDING 2022-204COVID-19 funds in the amount of $196,247,971 were not properly identified on the statewide Schedule of Expenditures of Federal Awards (SEFA), as required.Type of Finding: Noncompliance, Material Weakness, SEFA MisstatementAssistance Listing Title: Supplemental Nutrition Assistance Program (SNAP); WIC Special Supplemental Nutrition Program for Women, Infants, and Children; State Administrative Matching Grants for the Supplemental Nutrition Assistance Program; Grants to States for Construction of State Home Facilities; Special Education - Grants for Infants and Families; Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises; Community-Based Child Abuse Prevention Grants; Block Grants for Community Mental Health Services; Sexually Transmitted Diseases (STD) Prevention and Control Grants; Disaster Grants ? Public Assistance (Presidentially Declared Disasters)Assistance Listing Number: 10.551; 10.557; 10.561; 64.005; 84.181; 93.391; 93.497; 93.590; 93.958; 93.977; 97.036Federal Award Number: 22ID35051692301; 217IDID7W7003; 227IDID7F1003; FAI 16-012; FAI 16-013; H181X21016; NH75OT000105; 2202IDFSC6; 2101IDBCC6; B09SM083970; NH25PS005171; 4534DRIP00000001Program Year: October 1, 2021 ? September 30, 2022; October 1, 2020 ? September 30, 2021; October 1, 2021 ? September 30, 2021; May 8, 2021 ? June 30, 2022; June 28, 2021 ? June 30, 2022; July 1, 2021 ? September 30, 2022; June 1, 2021 ? May 31, 2023; October 1, 2020 ? September 30, 2025; October 1, 2020 ? September 30, 2025; March 15, 2021 ? March 14, 2023; January 1, 2019 ? December 31, 2023; May 8, 2020 ? June 30, 2022Federal Agency: Department of Agriculture; Department of Veterans Affairs; Department of Education; Health and Human Services; Department of Homeland SecurityCompliance Requirement: Code of Federal Regulations (CRF) 2 CFR 200.510(b)Questioned Costs: NoneCriteria: The Internal Control Integrated Framework published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) provides a basis for organizations to design internal control procedures to ensure reliable financial reporting, effective and efficient operations, and compliance with applicable laws and regulations. Components of this framework include risk assessment, control activities, and information and communication. Risk assessment is the identification and analysis of various risks entities face because of changing economic, industry, regulatory, and operating conditions, and provides a basis to develop appropriate responses to manage those risks. Control activities are policies and procedures that help ensure management directives are carried out and risks are mitigated. Verifications, approvals, reconciliations, authorizations, and segregation of duties are all control activities that support this objective. Information and communication relate to obtaining quality information and effective internal and external communication of that information to achieve management objectives.Management objectives should include the preparation and fair presentation of the SEFA in relation to the basic financial statements as a whole and in compliance with requirements contained in the U.S. Code of Federal Regulations (CFR), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) (2 CFR ?200.510(b)), which states it must include:? Total federal awards expended as determined in accordance with 2 CFR ?200.502? Total amount provided to subrecipients from each federal programAdditionally, the Office of Management and Budget (OMB) Memorandum M-20-26 instructed recipients and subrecipients to separately identify the COVID-19 Emergency Acts expenditures on the SEFA.Condition: Several assistance listings (AL) were not properly identified as COVID-19 funds on the SEFA submitted for audit. The following items were identified by the auditors and communicated to management during the audit process:? Supplemental Nutrition Assistance Program (AL Number 10.551) $38,370,588? Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises (AL Number 93.391) $3,387,573? Special Education - Grants for Infants and Families (AL Number 84.181) $265,777? Family Violence Prevention and Services/Sexual Assault/Rape Crisis Services and Supports (AL Number 93.497) $183,807? WIC Special Supplemental Nutrition Program for Women, Infants, and Children (AL Number 10.557) $1,547,158? State Administrative Matching Grants for the Supplemental Nutrition Assistance Program (AL Number 10.561) $354,983? Community-Based Child Abuse Prevention Grants (AL Number 93.590) $156,539? Block Grants for Community Mental Health Services (AL Number 93.958) $389,232? Sexually Transmitted Diseases (STD) Prevention and Control Grants (AL Number 93.977) $156,712? State Veterans Home Construction (AL Number 64.005) $1,513,996? Education Stabilization Fund - Emergency Assistance for Non-Public Schools (AL Number 84.425R) $3,145,463? Disaster Grants ? Public Assistance (Presidentially Declared Disasters) (AL Number 97.036) $146,776,143Cause: The Office has not developed procedures to ensure amounts reported by State agencies on closing packages properly identifies all funds related to COVID-19. The Office relies on State agencies to self-report federal expenditures, programs, and identify if these programs are related to COVID-19 funding through the closing package process. Current procedures do not include verifying that the COVID-19 designation is appropriately included.Additionally, review procedures did not identify an error that occurred while compiling the SEFA that did not include the COVID-19 designation for AL Number 84.425R. Internal reviews did not identify this error as this information was correctly included on the agency closing package.Effect: The SEFA submitted for audit did not properly identify $196,247,971 as COVID-19 funds on the SEFA; however, these errors have been corrected.Recommendation: We recommend that the Office implement procedures and controls to ensure funds related to the COVID-19 pandemic are properly identified on the SEFA.Management?s View: The Office agrees with this finding.Corrective Action: Since the State began receiving COVID-19 funding, we diligently provided training and resources to the agencies regarding the funding and how it should be reported on the SEFA closing package. This includes a discussion in our annual closing package training, online resources regarding COVID-19 funds, an FAQ document, and being available to discuss questions and concerns. In addition to the steps we are currently taking, we will reiterate the importance of designating COVID-19 related expenditures on the SEFA closing package during our annual closing package training. We will review STARS activity in the COVID-19 related funds and compare to the agency submitted closing packages for reasonableness. Recognizing that not all agencies utilize these specific funds, we will also review COVID-19 related expenditures on an external online source that reports federal grant expenditures. We will then use this information to compare to what is reported on agency closing packages for reasonableness.Auditor?s Concluding Remarks: We thank the Office for its cooperation and assistance throughout the audit.
FINDING 2022-204COVID-19 funds in the amount of $196,247,971 were not properly identified on the statewide Schedule of Expenditures of Federal Awards (SEFA), as required.Type of Finding: Noncompliance, Material Weakness, SEFA MisstatementAssistance Listing Title: Supplemental Nutrition Assistance Program (SNAP); WIC Special Supplemental Nutrition Program for Women, Infants, and Children; State Administrative Matching Grants for the Supplemental Nutrition Assistance Program; Grants to States for Construction of State Home Facilities; Special Education - Grants for Infants and Families; Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises; Community-Based Child Abuse Prevention Grants; Block Grants for Community Mental Health Services; Sexually Transmitted Diseases (STD) Prevention and Control Grants; Disaster Grants ? Public Assistance (Presidentially Declared Disasters)Assistance Listing Number: 10.551; 10.557; 10.561; 64.005; 84.181; 93.391; 93.497; 93.590; 93.958; 93.977; 97.036Federal Award Number: 22ID35051692301; 217IDID7W7003; 227IDID7F1003; FAI 16-012; FAI 16-013; H181X21016; NH75OT000105; 2202IDFSC6; 2101IDBCC6; B09SM083970; NH25PS005171; 4534DRIP00000001Program Year: October 1, 2021 ? September 30, 2022; October 1, 2020 ? September 30, 2021; October 1, 2021 ? September 30, 2021; May 8, 2021 ? June 30, 2022; June 28, 2021 ? June 30, 2022; July 1, 2021 ? September 30, 2022; June 1, 2021 ? May 31, 2023; October 1, 2020 ? September 30, 2025; October 1, 2020 ? September 30, 2025; March 15, 2021 ? March 14, 2023; January 1, 2019 ? December 31, 2023; May 8, 2020 ? June 30, 2022Federal Agency: Department of Agriculture; Department of Veterans Affairs; Department of Education; Health and Human Services; Department of Homeland SecurityCompliance Requirement: Code of Federal Regulations (CRF) 2 CFR 200.510(b)Questioned Costs: NoneCriteria: The Internal Control Integrated Framework published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) provides a basis for organizations to design internal control procedures to ensure reliable financial reporting, effective and efficient operations, and compliance with applicable laws and regulations. Components of this framework include risk assessment, control activities, and information and communication. Risk assessment is the identification and analysis of various risks entities face because of changing economic, industry, regulatory, and operating conditions, and provides a basis to develop appropriate responses to manage those risks. Control activities are policies and procedures that help ensure management directives are carried out and risks are mitigated. Verifications, approvals, reconciliations, authorizations, and segregation of duties are all control activities that support this objective. Information and communication relate to obtaining quality information and effective internal and external communication of that information to achieve management objectives.Management objectives should include the preparation and fair presentation of the SEFA in relation to the basic financial statements as a whole and in compliance with requirements contained in the U.S. Code of Federal Regulations (CFR), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) (2 CFR ?200.510(b)), which states it must include:? Total federal awards expended as determined in accordance with 2 CFR ?200.502? Total amount provided to subrecipients from each federal programAdditionally, the Office of Management and Budget (OMB) Memorandum M-20-26 instructed recipients and subrecipients to separately identify the COVID-19 Emergency Acts expenditures on the SEFA.Condition: Several assistance listings (AL) were not properly identified as COVID-19 funds on the SEFA submitted for audit. The following items were identified by the auditors and communicated to management during the audit process:? Supplemental Nutrition Assistance Program (AL Number 10.551) $38,370,588? Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises (AL Number 93.391) $3,387,573? Special Education - Grants for Infants and Families (AL Number 84.181) $265,777? Family Violence Prevention and Services/Sexual Assault/Rape Crisis Services and Supports (AL Number 93.497) $183,807? WIC Special Supplemental Nutrition Program for Women, Infants, and Children (AL Number 10.557) $1,547,158? State Administrative Matching Grants for the Supplemental Nutrition Assistance Program (AL Number 10.561) $354,983? Community-Based Child Abuse Prevention Grants (AL Number 93.590) $156,539? Block Grants for Community Mental Health Services (AL Number 93.958) $389,232? Sexually Transmitted Diseases (STD) Prevention and Control Grants (AL Number 93.977) $156,712? State Veterans Home Construction (AL Number 64.005) $1,513,996? Education Stabilization Fund - Emergency Assistance for Non-Public Schools (AL Number 84.425R) $3,145,463? Disaster Grants ? Public Assistance (Presidentially Declared Disasters) (AL Number 97.036) $146,776,143Cause: The Office has not developed procedures to ensure amounts reported by State agencies on closing packages properly identifies all funds related to COVID-19. The Office relies on State agencies to self-report federal expenditures, programs, and identify if these programs are related to COVID-19 funding through the closing package process. Current procedures do not include verifying that the COVID-19 designation is appropriately included.Additionally, review procedures did not identify an error that occurred while compiling the SEFA that did not include the COVID-19 designation for AL Number 84.425R. Internal reviews did not identify this error as this information was correctly included on the agency closing package.Effect: The SEFA submitted for audit did not properly identify $196,247,971 as COVID-19 funds on the SEFA; however, these errors have been corrected.Recommendation: We recommend that the Office implement procedures and controls to ensure funds related to the COVID-19 pandemic are properly identified on the SEFA.Management?s View: The Office agrees with this finding.Corrective Action: Since the State began receiving COVID-19 funding, we diligently provided training and resources to the agencies regarding the funding and how it should be reported on the SEFA closing package. This includes a discussion in our annual closing package training, online resources regarding COVID-19 funds, an FAQ document, and being available to discuss questions and concerns. In addition to the steps we are currently taking, we will reiterate the importance of designating COVID-19 related expenditures on the SEFA closing package during our annual closing package training. We will review STARS activity in the COVID-19 related funds and compare to the agency submitted closing packages for reasonableness. Recognizing that not all agencies utilize these specific funds, we will also review COVID-19 related expenditures on an external online source that reports federal grant expenditures. We will then use this information to compare to what is reported on agency closing packages for reasonableness.Auditor?s Concluding Remarks: We thank the Office for its cooperation and assistance throughout the audit.
FINDING 2022-204COVID-19 funds in the amount of $196,247,971 were not properly identified on the statewide Schedule of Expenditures of Federal Awards (SEFA), as required.Type of Finding: Noncompliance, Material Weakness, SEFA MisstatementAssistance Listing Title: Supplemental Nutrition Assistance Program (SNAP); WIC Special Supplemental Nutrition Program for Women, Infants, and Children; State Administrative Matching Grants for the Supplemental Nutrition Assistance Program; Grants to States for Construction of State Home Facilities; Special Education - Grants for Infants and Families; Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises; Community-Based Child Abuse Prevention Grants; Block Grants for Community Mental Health Services; Sexually Transmitted Diseases (STD) Prevention and Control Grants; Disaster Grants ? Public Assistance (Presidentially Declared Disasters)Assistance Listing Number: 10.551; 10.557; 10.561; 64.005; 84.181; 93.391; 93.497; 93.590; 93.958; 93.977; 97.036Federal Award Number: 22ID35051692301; 217IDID7W7003; 227IDID7F1003; FAI 16-012; FAI 16-013; H181X21016; NH75OT000105; 2202IDFSC6; 2101IDBCC6; B09SM083970; NH25PS005171; 4534DRIP00000001Program Year: October 1, 2021 ? September 30, 2022; October 1, 2020 ? September 30, 2021; October 1, 2021 ? September 30, 2021; May 8, 2021 ? June 30, 2022; June 28, 2021 ? June 30, 2022; July 1, 2021 ? September 30, 2022; June 1, 2021 ? May 31, 2023; October 1, 2020 ? September 30, 2025; October 1, 2020 ? September 30, 2025; March 15, 2021 ? March 14, 2023; January 1, 2019 ? December 31, 2023; May 8, 2020 ? June 30, 2022Federal Agency: Department of Agriculture; Department of Veterans Affairs; Department of Education; Health and Human Services; Department of Homeland SecurityCompliance Requirement: Code of Federal Regulations (CRF) 2 CFR 200.510(b)Questioned Costs: NoneCriteria: The Internal Control Integrated Framework published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) provides a basis for organizations to design internal control procedures to ensure reliable financial reporting, effective and efficient operations, and compliance with applicable laws and regulations. Components of this framework include risk assessment, control activities, and information and communication. Risk assessment is the identification and analysis of various risks entities face because of changing economic, industry, regulatory, and operating conditions, and provides a basis to develop appropriate responses to manage those risks. Control activities are policies and procedures that help ensure management directives are carried out and risks are mitigated. Verifications, approvals, reconciliations, authorizations, and segregation of duties are all control activities that support this objective. Information and communication relate to obtaining quality information and effective internal and external communication of that information to achieve management objectives.Management objectives should include the preparation and fair presentation of the SEFA in relation to the basic financial statements as a whole and in compliance with requirements contained in the U.S. Code of Federal Regulations (CFR), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) (2 CFR ?200.510(b)), which states it must include:? Total federal awards expended as determined in accordance with 2 CFR ?200.502? Total amount provided to subrecipients from each federal programAdditionally, the Office of Management and Budget (OMB) Memorandum M-20-26 instructed recipients and subrecipients to separately identify the COVID-19 Emergency Acts expenditures on the SEFA.Condition: Several assistance listings (AL) were not properly identified as COVID-19 funds on the SEFA submitted for audit. The following items were identified by the auditors and communicated to management during the audit process:? Supplemental Nutrition Assistance Program (AL Number 10.551) $38,370,588? Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises (AL Number 93.391) $3,387,573? Special Education - Grants for Infants and Families (AL Number 84.181) $265,777? Family Violence Prevention and Services/Sexual Assault/Rape Crisis Services and Supports (AL Number 93.497) $183,807? WIC Special Supplemental Nutrition Program for Women, Infants, and Children (AL Number 10.557) $1,547,158? State Administrative Matching Grants for the Supplemental Nutrition Assistance Program (AL Number 10.561) $354,983? Community-Based Child Abuse Prevention Grants (AL Number 93.590) $156,539? Block Grants for Community Mental Health Services (AL Number 93.958) $389,232? Sexually Transmitted Diseases (STD) Prevention and Control Grants (AL Number 93.977) $156,712? State Veterans Home Construction (AL Number 64.005) $1,513,996? Education Stabilization Fund - Emergency Assistance for Non-Public Schools (AL Number 84.425R) $3,145,463? Disaster Grants ? Public Assistance (Presidentially Declared Disasters) (AL Number 97.036) $146,776,143Cause: The Office has not developed procedures to ensure amounts reported by State agencies on closing packages properly identifies all funds related to COVID-19. The Office relies on State agencies to self-report federal expenditures, programs, and identify if these programs are related to COVID-19 funding through the closing package process. Current procedures do not include verifying that the COVID-19 designation is appropriately included.Additionally, review procedures did not identify an error that occurred while compiling the SEFA that did not include the COVID-19 designation for AL Number 84.425R. Internal reviews did not identify this error as this information was correctly included on the agency closing package.Effect: The SEFA submitted for audit did not properly identify $196,247,971 as COVID-19 funds on the SEFA; however, these errors have been corrected.Recommendation: We recommend that the Office implement procedures and controls to ensure funds related to the COVID-19 pandemic are properly identified on the SEFA.Management?s View: The Office agrees with this finding.Corrective Action: Since the State began receiving COVID-19 funding, we diligently provided training and resources to the agencies regarding the funding and how it should be reported on the SEFA closing package. This includes a discussion in our annual closing package training, online resources regarding COVID-19 funds, an FAQ document, and being available to discuss questions and concerns. In addition to the steps we are currently taking, we will reiterate the importance of designating COVID-19 related expenditures on the SEFA closing package during our annual closing package training. We will review STARS activity in the COVID-19 related funds and compare to the agency submitted closing packages for reasonableness. Recognizing that not all agencies utilize these specific funds, we will also review COVID-19 related expenditures on an external online source that reports federal grant expenditures. We will then use this information to compare to what is reported on agency closing packages for reasonableness.Auditor?s Concluding Remarks: We thank the Office for its cooperation and assistance throughout the audit.
FINDING 2022-204COVID-19 funds in the amount of $196,247,971 were not properly identified on the statewide Schedule of Expenditures of Federal Awards (SEFA), as required.Type of Finding: Noncompliance, Material Weakness, SEFA MisstatementAssistance Listing Title: Supplemental Nutrition Assistance Program (SNAP); WIC Special Supplemental Nutrition Program for Women, Infants, and Children; State Administrative Matching Grants for the Supplemental Nutrition Assistance Program; Grants to States for Construction of State Home Facilities; Special Education - Grants for Infants and Families; Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises; Community-Based Child Abuse Prevention Grants; Block Grants for Community Mental Health Services; Sexually Transmitted Diseases (STD) Prevention and Control Grants; Disaster Grants ? Public Assistance (Presidentially Declared Disasters)Assistance Listing Number: 10.551; 10.557; 10.561; 64.005; 84.181; 93.391; 93.497; 93.590; 93.958; 93.977; 97.036Federal Award Number: 22ID35051692301; 217IDID7W7003; 227IDID7F1003; FAI 16-012; FAI 16-013; H181X21016; NH75OT000105; 2202IDFSC6; 2101IDBCC6; B09SM083970; NH25PS005171; 4534DRIP00000001Program Year: October 1, 2021 ? September 30, 2022; October 1, 2020 ? September 30, 2021; October 1, 2021 ? September 30, 2021; May 8, 2021 ? June 30, 2022; June 28, 2021 ? June 30, 2022; July 1, 2021 ? September 30, 2022; June 1, 2021 ? May 31, 2023; October 1, 2020 ? September 30, 2025; October 1, 2020 ? September 30, 2025; March 15, 2021 ? March 14, 2023; January 1, 2019 ? December 31, 2023; May 8, 2020 ? June 30, 2022Federal Agency: Department of Agriculture; Department of Veterans Affairs; Department of Education; Health and Human Services; Department of Homeland SecurityCompliance Requirement: Code of Federal Regulations (CRF) 2 CFR 200.510(b)Questioned Costs: NoneCriteria: The Internal Control Integrated Framework published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) provides a basis for organizations to design internal control procedures to ensure reliable financial reporting, effective and efficient operations, and compliance with applicable laws and regulations. Components of this framework include risk assessment, control activities, and information and communication. Risk assessment is the identification and analysis of various risks entities face because of changing economic, industry, regulatory, and operating conditions, and provides a basis to develop appropriate responses to manage those risks. Control activities are policies and procedures that help ensure management directives are carried out and risks are mitigated. Verifications, approvals, reconciliations, authorizations, and segregation of duties are all control activities that support this objective. Information and communication relate to obtaining quality information and effective internal and external communication of that information to achieve management objectives.Management objectives should include the preparation and fair presentation of the SEFA in relation to the basic financial statements as a whole and in compliance with requirements contained in the U.S. Code of Federal Regulations (CFR), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) (2 CFR ?200.510(b)), which states it must include:? Total federal awards expended as determined in accordance with 2 CFR ?200.502? Total amount provided to subrecipients from each federal programAdditionally, the Office of Management and Budget (OMB) Memorandum M-20-26 instructed recipients and subrecipients to separately identify the COVID-19 Emergency Acts expenditures on the SEFA.Condition: Several assistance listings (AL) were not properly identified as COVID-19 funds on the SEFA submitted for audit. The following items were identified by the auditors and communicated to management during the audit process:? Supplemental Nutrition Assistance Program (AL Number 10.551) $38,370,588? Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises (AL Number 93.391) $3,387,573? Special Education - Grants for Infants and Families (AL Number 84.181) $265,777? Family Violence Prevention and Services/Sexual Assault/Rape Crisis Services and Supports (AL Number 93.497) $183,807? WIC Special Supplemental Nutrition Program for Women, Infants, and Children (AL Number 10.557) $1,547,158? State Administrative Matching Grants for the Supplemental Nutrition Assistance Program (AL Number 10.561) $354,983? Community-Based Child Abuse Prevention Grants (AL Number 93.590) $156,539? Block Grants for Community Mental Health Services (AL Number 93.958) $389,232? Sexually Transmitted Diseases (STD) Prevention and Control Grants (AL Number 93.977) $156,712? State Veterans Home Construction (AL Number 64.005) $1,513,996? Education Stabilization Fund - Emergency Assistance for Non-Public Schools (AL Number 84.425R) $3,145,463? Disaster Grants ? Public Assistance (Presidentially Declared Disasters) (AL Number 97.036) $146,776,143Cause: The Office has not developed procedures to ensure amounts reported by State agencies on closing packages properly identifies all funds related to COVID-19. The Office relies on State agencies to self-report federal expenditures, programs, and identify if these programs are related to COVID-19 funding through the closing package process. Current procedures do not include verifying that the COVID-19 designation is appropriately included.Additionally, review procedures did not identify an error that occurred while compiling the SEFA that did not include the COVID-19 designation for AL Number 84.425R. Internal reviews did not identify this error as this information was correctly included on the agency closing package.Effect: The SEFA submitted for audit did not properly identify $196,247,971 as COVID-19 funds on the SEFA; however, these errors have been corrected.Recommendation: We recommend that the Office implement procedures and controls to ensure funds related to the COVID-19 pandemic are properly identified on the SEFA.Management?s View: The Office agrees with this finding.Corrective Action: Since the State began receiving COVID-19 funding, we diligently provided training and resources to the agencies regarding the funding and how it should be reported on the SEFA closing package. This includes a discussion in our annual closing package training, online resources regarding COVID-19 funds, an FAQ document, and being available to discuss questions and concerns. In addition to the steps we are currently taking, we will reiterate the importance of designating COVID-19 related expenditures on the SEFA closing package during our annual closing package training. We will review STARS activity in the COVID-19 related funds and compare to the agency submitted closing packages for reasonableness. Recognizing that not all agencies utilize these specific funds, we will also review COVID-19 related expenditures on an external online source that reports federal grant expenditures. We will then use this information to compare to what is reported on agency closing packages for reasonableness.Auditor?s Concluding Remarks: We thank the Office for its cooperation and assistance throughout the audit.
FINDING 2022-204COVID-19 funds in the amount of $196,247,971 were not properly identified on the statewide Schedule of Expenditures of Federal Awards (SEFA), as required.Type of Finding: Noncompliance, Material Weakness, SEFA MisstatementAssistance Listing Title: Supplemental Nutrition Assistance Program (SNAP); WIC Special Supplemental Nutrition Program for Women, Infants, and Children; State Administrative Matching Grants for the Supplemental Nutrition Assistance Program; Grants to States for Construction of State Home Facilities; Special Education - Grants for Infants and Families; Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises; Community-Based Child Abuse Prevention Grants; Block Grants for Community Mental Health Services; Sexually Transmitted Diseases (STD) Prevention and Control Grants; Disaster Grants ? Public Assistance (Presidentially Declared Disasters)Assistance Listing Number: 10.551; 10.557; 10.561; 64.005; 84.181; 93.391; 93.497; 93.590; 93.958; 93.977; 97.036Federal Award Number: 22ID35051692301; 217IDID7W7003; 227IDID7F1003; FAI 16-012; FAI 16-013; H181X21016; NH75OT000105; 2202IDFSC6; 2101IDBCC6; B09SM083970; NH25PS005171; 4534DRIP00000001Program Year: October 1, 2021 ? September 30, 2022; October 1, 2020 ? September 30, 2021; October 1, 2021 ? September 30, 2021; May 8, 2021 ? June 30, 2022; June 28, 2021 ? June 30, 2022; July 1, 2021 ? September 30, 2022; June 1, 2021 ? May 31, 2023; October 1, 2020 ? September 30, 2025; October 1, 2020 ? September 30, 2025; March 15, 2021 ? March 14, 2023; January 1, 2019 ? December 31, 2023; May 8, 2020 ? June 30, 2022Federal Agency: Department of Agriculture; Department of Veterans Affairs; Department of Education; Health and Human Services; Department of Homeland SecurityCompliance Requirement: Code of Federal Regulations (CRF) 2 CFR 200.510(b)Questioned Costs: NoneCriteria: The Internal Control Integrated Framework published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) provides a basis for organizations to design internal control procedures to ensure reliable financial reporting, effective and efficient operations, and compliance with applicable laws and regulations. Components of this framework include risk assessment, control activities, and information and communication. Risk assessment is the identification and analysis of various risks entities face because of changing economic, industry, regulatory, and operating conditions, and provides a basis to develop appropriate responses to manage those risks. Control activities are policies and procedures that help ensure management directives are carried out and risks are mitigated. Verifications, approvals, reconciliations, authorizations, and segregation of duties are all control activities that support this objective. Information and communication relate to obtaining quality information and effective internal and external communication of that information to achieve management objectives.Management objectives should include the preparation and fair presentation of the SEFA in relation to the basic financial statements as a whole and in compliance with requirements contained in the U.S. Code of Federal Regulations (CFR), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) (2 CFR ?200.510(b)), which states it must include:? Total federal awards expended as determined in accordance with 2 CFR ?200.502? Total amount provided to subrecipients from each federal programAdditionally, the Office of Management and Budget (OMB) Memorandum M-20-26 instructed recipients and subrecipients to separately identify the COVID-19 Emergency Acts expenditures on the SEFA.Condition: Several assistance listings (AL) were not properly identified as COVID-19 funds on the SEFA submitted for audit. The following items were identified by the auditors and communicated to management during the audit process:? Supplemental Nutrition Assistance Program (AL Number 10.551) $38,370,588? Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises (AL Number 93.391) $3,387,573? Special Education - Grants for Infants and Families (AL Number 84.181) $265,777? Family Violence Prevention and Services/Sexual Assault/Rape Crisis Services and Supports (AL Number 93.497) $183,807? WIC Special Supplemental Nutrition Program for Women, Infants, and Children (AL Number 10.557) $1,547,158? State Administrative Matching Grants for the Supplemental Nutrition Assistance Program (AL Number 10.561) $354,983? Community-Based Child Abuse Prevention Grants (AL Number 93.590) $156,539? Block Grants for Community Mental Health Services (AL Number 93.958) $389,232? Sexually Transmitted Diseases (STD) Prevention and Control Grants (AL Number 93.977) $156,712? State Veterans Home Construction (AL Number 64.005) $1,513,996? Education Stabilization Fund - Emergency Assistance for Non-Public Schools (AL Number 84.425R) $3,145,463? Disaster Grants ? Public Assistance (Presidentially Declared Disasters) (AL Number 97.036) $146,776,143Cause: The Office has not developed procedures to ensure amounts reported by State agencies on closing packages properly identifies all funds related to COVID-19. The Office relies on State agencies to self-report federal expenditures, programs, and identify if these programs are related to COVID-19 funding through the closing package process. Current procedures do not include verifying that the COVID-19 designation is appropriately included.Additionally, review procedures did not identify an error that occurred while compiling the SEFA that did not include the COVID-19 designation for AL Number 84.425R. Internal reviews did not identify this error as this information was correctly included on the agency closing package.Effect: The SEFA submitted for audit did not properly identify $196,247,971 as COVID-19 funds on the SEFA; however, these errors have been corrected.Recommendation: We recommend that the Office implement procedures and controls to ensure funds related to the COVID-19 pandemic are properly identified on the SEFA.Management?s View: The Office agrees with this finding.Corrective Action: Since the State began receiving COVID-19 funding, we diligently provided training and resources to the agencies regarding the funding and how it should be reported on the SEFA closing package. This includes a discussion in our annual closing package training, online resources regarding COVID-19 funds, an FAQ document, and being available to discuss questions and concerns. In addition to the steps we are currently taking, we will reiterate the importance of designating COVID-19 related expenditures on the SEFA closing package during our annual closing package training. We will review STARS activity in the COVID-19 related funds and compare to the agency submitted closing packages for reasonableness. Recognizing that not all agencies utilize these specific funds, we will also review COVID-19 related expenditures on an external online source that reports federal grant expenditures. We will then use this information to compare to what is reported on agency closing packages for reasonableness.Auditor?s Concluding Remarks: We thank the Office for its cooperation and assistance throughout the audit.
FINDING 2022-204COVID-19 funds in the amount of $196,247,971 were not properly identified on the statewide Schedule of Expenditures of Federal Awards (SEFA), as required.Type of Finding: Noncompliance, Material Weakness, SEFA MisstatementAssistance Listing Title: Supplemental Nutrition Assistance Program (SNAP); WIC Special Supplemental Nutrition Program for Women, Infants, and Children; State Administrative Matching Grants for the Supplemental Nutrition Assistance Program; Grants to States for Construction of State Home Facilities; Special Education - Grants for Infants and Families; Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises; Community-Based Child Abuse Prevention Grants; Block Grants for Community Mental Health Services; Sexually Transmitted Diseases (STD) Prevention and Control Grants; Disaster Grants ? Public Assistance (Presidentially Declared Disasters)Assistance Listing Number: 10.551; 10.557; 10.561; 64.005; 84.181; 93.391; 93.497; 93.590; 93.958; 93.977; 97.036Federal Award Number: 22ID35051692301; 217IDID7W7003; 227IDID7F1003; FAI 16-012; FAI 16-013; H181X21016; NH75OT000105; 2202IDFSC6; 2101IDBCC6; B09SM083970; NH25PS005171; 4534DRIP00000001Program Year: October 1, 2021 ? September 30, 2022; October 1, 2020 ? September 30, 2021; October 1, 2021 ? September 30, 2021; May 8, 2021 ? June 30, 2022; June 28, 2021 ? June 30, 2022; July 1, 2021 ? September 30, 2022; June 1, 2021 ? May 31, 2023; October 1, 2020 ? September 30, 2025; October 1, 2020 ? September 30, 2025; March 15, 2021 ? March 14, 2023; January 1, 2019 ? December 31, 2023; May 8, 2020 ? June 30, 2022Federal Agency: Department of Agriculture; Department of Veterans Affairs; Department of Education; Health and Human Services; Department of Homeland SecurityCompliance Requirement: Code of Federal Regulations (CRF) 2 CFR 200.510(b)Questioned Costs: NoneCriteria: The Internal Control Integrated Framework published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) provides a basis for organizations to design internal control procedures to ensure reliable financial reporting, effective and efficient operations, and compliance with applicable laws and regulations. Components of this framework include risk assessment, control activities, and information and communication. Risk assessment is the identification and analysis of various risks entities face because of changing economic, industry, regulatory, and operating conditions, and provides a basis to develop appropriate responses to manage those risks. Control activities are policies and procedures that help ensure management directives are carried out and risks are mitigated. Verifications, approvals, reconciliations, authorizations, and segregation of duties are all control activities that support this objective. Information and communication relate to obtaining quality information and effective internal and external communication of that information to achieve management objectives.Management objectives should include the preparation and fair presentation of the SEFA in relation to the basic financial statements as a whole and in compliance with requirements contained in the U.S. Code of Federal Regulations (CFR), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) (2 CFR ?200.510(b)), which states it must include:? Total federal awards expended as determined in accordance with 2 CFR ?200.502? Total amount provided to subrecipients from each federal programAdditionally, the Office of Management and Budget (OMB) Memorandum M-20-26 instructed recipients and subrecipients to separately identify the COVID-19 Emergency Acts expenditures on the SEFA.Condition: Several assistance listings (AL) were not properly identified as COVID-19 funds on the SEFA submitted for audit. The following items were identified by the auditors and communicated to management during the audit process:? Supplemental Nutrition Assistance Program (AL Number 10.551) $38,370,588? Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises (AL Number 93.391) $3,387,573? Special Education - Grants for Infants and Families (AL Number 84.181) $265,777? Family Violence Prevention and Services/Sexual Assault/Rape Crisis Services and Supports (AL Number 93.497) $183,807? WIC Special Supplemental Nutrition Program for Women, Infants, and Children (AL Number 10.557) $1,547,158? State Administrative Matching Grants for the Supplemental Nutrition Assistance Program (AL Number 10.561) $354,983? Community-Based Child Abuse Prevention Grants (AL Number 93.590) $156,539? Block Grants for Community Mental Health Services (AL Number 93.958) $389,232? Sexually Transmitted Diseases (STD) Prevention and Control Grants (AL Number 93.977) $156,712? State Veterans Home Construction (AL Number 64.005) $1,513,996? Education Stabilization Fund - Emergency Assistance for Non-Public Schools (AL Number 84.425R) $3,145,463? Disaster Grants ? Public Assistance (Presidentially Declared Disasters) (AL Number 97.036) $146,776,143Cause: The Office has not developed procedures to ensure amounts reported by State agencies on closing packages properly identifies all funds related to COVID-19. The Office relies on State agencies to self-report federal expenditures, programs, and identify if these programs are related to COVID-19 funding through the closing package process. Current procedures do not include verifying that the COVID-19 designation is appropriately included.Additionally, review procedures did not identify an error that occurred while compiling the SEFA that did not include the COVID-19 designation for AL Number 84.425R. Internal reviews did not identify this error as this information was correctly included on the agency closing package.Effect: The SEFA submitted for audit did not properly identify $196,247,971 as COVID-19 funds on the SEFA; however, these errors have been corrected.Recommendation: We recommend that the Office implement procedures and controls to ensure funds related to the COVID-19 pandemic are properly identified on the SEFA.Management?s View: The Office agrees with this finding.Corrective Action: Since the State began receiving COVID-19 funding, we diligently provided training and resources to the agencies regarding the funding and how it should be reported on the SEFA closing package. This includes a discussion in our annual closing package training, online resources regarding COVID-19 funds, an FAQ document, and being available to discuss questions and concerns. In addition to the steps we are currently taking, we will reiterate the importance of designating COVID-19 related expenditures on the SEFA closing package during our annual closing package training. We will review STARS activity in the COVID-19 related funds and compare to the agency submitted closing packages for reasonableness. Recognizing that not all agencies utilize these specific funds, we will also review COVID-19 related expenditures on an external online source that reports federal grant expenditures. We will then use this information to compare to what is reported on agency closing packages for reasonableness.Auditor?s Concluding Remarks: We thank the Office for its cooperation and assistance throughout the audit.
FINDING 2022-204COVID-19 funds in the amount of $196,247,971 were not properly identified on the statewide Schedule of Expenditures of Federal Awards (SEFA), as required.Type of Finding: Noncompliance, Material Weakness, SEFA MisstatementAssistance Listing Title: Supplemental Nutrition Assistance Program (SNAP); WIC Special Supplemental Nutrition Program for Women, Infants, and Children; State Administrative Matching Grants for the Supplemental Nutrition Assistance Program; Grants to States for Construction of State Home Facilities; Special Education - Grants for Infants and Families; Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises; Community-Based Child Abuse Prevention Grants; Block Grants for Community Mental Health Services; Sexually Transmitted Diseases (STD) Prevention and Control Grants; Disaster Grants ? Public Assistance (Presidentially Declared Disasters)Assistance Listing Number: 10.551; 10.557; 10.561; 64.005; 84.181; 93.391; 93.497; 93.590; 93.958; 93.977; 97.036Federal Award Number: 22ID35051692301; 217IDID7W7003; 227IDID7F1003; FAI 16-012; FAI 16-013; H181X21016; NH75OT000105; 2202IDFSC6; 2101IDBCC6; B09SM083970; NH25PS005171; 4534DRIP00000001Program Year: October 1, 2021 ? September 30, 2022; October 1, 2020 ? September 30, 2021; October 1, 2021 ? September 30, 2021; May 8, 2021 ? June 30, 2022; June 28, 2021 ? June 30, 2022; July 1, 2021 ? September 30, 2022; June 1, 2021 ? May 31, 2023; October 1, 2020 ? September 30, 2025; October 1, 2020 ? September 30, 2025; March 15, 2021 ? March 14, 2023; January 1, 2019 ? December 31, 2023; May 8, 2020 ? June 30, 2022Federal Agency: Department of Agriculture; Department of Veterans Affairs; Department of Education; Health and Human Services; Department of Homeland SecurityCompliance Requirement: Code of Federal Regulations (CRF) 2 CFR 200.510(b)Questioned Costs: NoneCriteria: The Internal Control Integrated Framework published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) provides a basis for organizations to design internal control procedures to ensure reliable financial reporting, effective and efficient operations, and compliance with applicable laws and regulations. Components of this framework include risk assessment, control activities, and information and communication. Risk assessment is the identification and analysis of various risks entities face because of changing economic, industry, regulatory, and operating conditions, and provides a basis to develop appropriate responses to manage those risks. Control activities are policies and procedures that help ensure management directives are carried out and risks are mitigated. Verifications, approvals, reconciliations, authorizations, and segregation of duties are all control activities that support this objective. Information and communication relate to obtaining quality information and effective internal and external communication of that information to achieve management objectives.Management objectives should include the preparation and fair presentation of the SEFA in relation to the basic financial statements as a whole and in compliance with requirements contained in the U.S. Code of Federal Regulations (CFR), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) (2 CFR ?200.510(b)), which states it must include:? Total federal awards expended as determined in accordance with 2 CFR ?200.502? Total amount provided to subrecipients from each federal programAdditionally, the Office of Management and Budget (OMB) Memorandum M-20-26 instructed recipients and subrecipients to separately identify the COVID-19 Emergency Acts expenditures on the SEFA.Condition: Several assistance listings (AL) were not properly identified as COVID-19 funds on the SEFA submitted for audit. The following items were identified by the auditors and communicated to management during the audit process:? Supplemental Nutrition Assistance Program (AL Number 10.551) $38,370,588? Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises (AL Number 93.391) $3,387,573? Special Education - Grants for Infants and Families (AL Number 84.181) $265,777? Family Violence Prevention and Services/Sexual Assault/Rape Crisis Services and Supports (AL Number 93.497) $183,807? WIC Special Supplemental Nutrition Program for Women, Infants, and Children (AL Number 10.557) $1,547,158? State Administrative Matching Grants for the Supplemental Nutrition Assistance Program (AL Number 10.561) $354,983? Community-Based Child Abuse Prevention Grants (AL Number 93.590) $156,539? Block Grants for Community Mental Health Services (AL Number 93.958) $389,232? Sexually Transmitted Diseases (STD) Prevention and Control Grants (AL Number 93.977) $156,712? State Veterans Home Construction (AL Number 64.005) $1,513,996? Education Stabilization Fund - Emergency Assistance for Non-Public Schools (AL Number 84.425R) $3,145,463? Disaster Grants ? Public Assistance (Presidentially Declared Disasters) (AL Number 97.036) $146,776,143Cause: The Office has not developed procedures to ensure amounts reported by State agencies on closing packages properly identifies all funds related to COVID-19. The Office relies on State agencies to self-report federal expenditures, programs, and identify if these programs are related to COVID-19 funding through the closing package process. Current procedures do not include verifying that the COVID-19 designation is appropriately included.Additionally, review procedures did not identify an error that occurred while compiling the SEFA that did not include the COVID-19 designation for AL Number 84.425R. Internal reviews did not identify this error as this information was correctly included on the agency closing package.Effect: The SEFA submitted for audit did not properly identify $196,247,971 as COVID-19 funds on the SEFA; however, these errors have been corrected.Recommendation: We recommend that the Office implement procedures and controls to ensure funds related to the COVID-19 pandemic are properly identified on the SEFA.Management?s View: The Office agrees with this finding.Corrective Action: Since the State began receiving COVID-19 funding, we diligently provided training and resources to the agencies regarding the funding and how it should be reported on the SEFA closing package. This includes a discussion in our annual closing package training, online resources regarding COVID-19 funds, an FAQ document, and being available to discuss questions and concerns. In addition to the steps we are currently taking, we will reiterate the importance of designating COVID-19 related expenditures on the SEFA closing package during our annual closing package training. We will review STARS activity in the COVID-19 related funds and compare to the agency submitted closing packages for reasonableness. Recognizing that not all agencies utilize these specific funds, we will also review COVID-19 related expenditures on an external online source that reports federal grant expenditures. We will then use this information to compare to what is reported on agency closing packages for reasonableness.Auditor?s Concluding Remarks: We thank the Office for its cooperation and assistance throughout the audit.
FINDING 2022-204COVID-19 funds in the amount of $196,247,971 were not properly identified on the statewide Schedule of Expenditures of Federal Awards (SEFA), as required.Type of Finding: Noncompliance, Material Weakness, SEFA MisstatementAssistance Listing Title: Supplemental Nutrition Assistance Program (SNAP); WIC Special Supplemental Nutrition Program for Women, Infants, and Children; State Administrative Matching Grants for the Supplemental Nutrition Assistance Program; Grants to States for Construction of State Home Facilities; Special Education - Grants for Infants and Families; Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises; Community-Based Child Abuse Prevention Grants; Block Grants for Community Mental Health Services; Sexually Transmitted Diseases (STD) Prevention and Control Grants; Disaster Grants ? Public Assistance (Presidentially Declared Disasters)Assistance Listing Number: 10.551; 10.557; 10.561; 64.005; 84.181; 93.391; 93.497; 93.590; 93.958; 93.977; 97.036Federal Award Number: 22ID35051692301; 217IDID7W7003; 227IDID7F1003; FAI 16-012; FAI 16-013; H181X21016; NH75OT000105; 2202IDFSC6; 2101IDBCC6; B09SM083970; NH25PS005171; 4534DRIP00000001Program Year: October 1, 2021 ? September 30, 2022; October 1, 2020 ? September 30, 2021; October 1, 2021 ? September 30, 2021; May 8, 2021 ? June 30, 2022; June 28, 2021 ? June 30, 2022; July 1, 2021 ? September 30, 2022; June 1, 2021 ? May 31, 2023; October 1, 2020 ? September 30, 2025; October 1, 2020 ? September 30, 2025; March 15, 2021 ? March 14, 2023; January 1, 2019 ? December 31, 2023; May 8, 2020 ? June 30, 2022Federal Agency: Department of Agriculture; Department of Veterans Affairs; Department of Education; Health and Human Services; Department of Homeland SecurityCompliance Requirement: Code of Federal Regulations (CRF) 2 CFR 200.510(b)Questioned Costs: NoneCriteria: The Internal Control Integrated Framework published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) provides a basis for organizations to design internal control procedures to ensure reliable financial reporting, effective and efficient operations, and compliance with applicable laws and regulations. Components of this framework include risk assessment, control activities, and information and communication. Risk assessment is the identification and analysis of various risks entities face because of changing economic, industry, regulatory, and operating conditions, and provides a basis to develop appropriate responses to manage those risks. Control activities are policies and procedures that help ensure management directives are carried out and risks are mitigated. Verifications, approvals, reconciliations, authorizations, and segregation of duties are all control activities that support this objective. Information and communication relate to obtaining quality information and effective internal and external communication of that information to achieve management objectives.Management objectives should include the preparation and fair presentation of the SEFA in relation to the basic financial statements as a whole and in compliance with requirements contained in the U.S. Code of Federal Regulations (CFR), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) (2 CFR ?200.510(b)), which states it must include:? Total federal awards expended as determined in accordance with 2 CFR ?200.502? Total amount provided to subrecipients from each federal programAdditionally, the Office of Management and Budget (OMB) Memorandum M-20-26 instructed recipients and subrecipients to separately identify the COVID-19 Emergency Acts expenditures on the SEFA.Condition: Several assistance listings (AL) were not properly identified as COVID-19 funds on the SEFA submitted for audit. The following items were identified by the auditors and communicated to management during the audit process:? Supplemental Nutrition Assistance Program (AL Number 10.551) $38,370,588? Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises (AL Number 93.391) $3,387,573? Special Education - Grants for Infants and Families (AL Number 84.181) $265,777? Family Violence Prevention and Services/Sexual Assault/Rape Crisis Services and Supports (AL Number 93.497) $183,807? WIC Special Supplemental Nutrition Program for Women, Infants, and Children (AL Number 10.557) $1,547,158? State Administrative Matching Grants for the Supplemental Nutrition Assistance Program (AL Number 10.561) $354,983? Community-Based Child Abuse Prevention Grants (AL Number 93.590) $156,539? Block Grants for Community Mental Health Services (AL Number 93.958) $389,232? Sexually Transmitted Diseases (STD) Prevention and Control Grants (AL Number 93.977) $156,712? State Veterans Home Construction (AL Number 64.005) $1,513,996? Education Stabilization Fund - Emergency Assistance for Non-Public Schools (AL Number 84.425R) $3,145,463? Disaster Grants ? Public Assistance (Presidentially Declared Disasters) (AL Number 97.036) $146,776,143Cause: The Office has not developed procedures to ensure amounts reported by State agencies on closing packages properly identifies all funds related to COVID-19. The Office relies on State agencies to self-report federal expenditures, programs, and identify if these programs are related to COVID-19 funding through the closing package process. Current procedures do not include verifying that the COVID-19 designation is appropriately included.Additionally, review procedures did not identify an error that occurred while compiling the SEFA that did not include the COVID-19 designation for AL Number 84.425R. Internal reviews did not identify this error as this information was correctly included on the agency closing package.Effect: The SEFA submitted for audit did not properly identify $196,247,971 as COVID-19 funds on the SEFA; however, these errors have been corrected.Recommendation: We recommend that the Office implement procedures and controls to ensure funds related to the COVID-19 pandemic are properly identified on the SEFA.Management?s View: The Office agrees with this finding.Corrective Action: Since the State began receiving COVID-19 funding, we diligently provided training and resources to the agencies regarding the funding and how it should be reported on the SEFA closing package. This includes a discussion in our annual closing package training, online resources regarding COVID-19 funds, an FAQ document, and being available to discuss questions and concerns. In addition to the steps we are currently taking, we will reiterate the importance of designating COVID-19 related expenditures on the SEFA closing package during our annual closing package training. We will review STARS activity in the COVID-19 related funds and compare to the agency submitted closing packages for reasonableness. Recognizing that not all agencies utilize these specific funds, we will also review COVID-19 related expenditures on an external online source that reports federal grant expenditures. We will then use this information to compare to what is reported on agency closing packages for reasonableness.Auditor?s Concluding Remarks: We thank the Office for its cooperation and assistance throughout the audit.
FINDING 2022-204COVID-19 funds in the amount of $196,247,971 were not properly identified on the statewide Schedule of Expenditures of Federal Awards (SEFA), as required.Type of Finding: Noncompliance, Material Weakness, SEFA MisstatementAssistance Listing Title: Supplemental Nutrition Assistance Program (SNAP); WIC Special Supplemental Nutrition Program for Women, Infants, and Children; State Administrative Matching Grants for the Supplemental Nutrition Assistance Program; Grants to States for Construction of State Home Facilities; Special Education - Grants for Infants and Families; Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises; Community-Based Child Abuse Prevention Grants; Block Grants for Community Mental Health Services; Sexually Transmitted Diseases (STD) Prevention and Control Grants; Disaster Grants ? Public Assistance (Presidentially Declared Disasters)Assistance Listing Number: 10.551; 10.557; 10.561; 64.005; 84.181; 93.391; 93.497; 93.590; 93.958; 93.977; 97.036Federal Award Number: 22ID35051692301; 217IDID7W7003; 227IDID7F1003; FAI 16-012; FAI 16-013; H181X21016; NH75OT000105; 2202IDFSC6; 2101IDBCC6; B09SM083970; NH25PS005171; 4534DRIP00000001Program Year: October 1, 2021 ? September 30, 2022; October 1, 2020 ? September 30, 2021; October 1, 2021 ? September 30, 2021; May 8, 2021 ? June 30, 2022; June 28, 2021 ? June 30, 2022; July 1, 2021 ? September 30, 2022; June 1, 2021 ? May 31, 2023; October 1, 2020 ? September 30, 2025; October 1, 2020 ? September 30, 2025; March 15, 2021 ? March 14, 2023; January 1, 2019 ? December 31, 2023; May 8, 2020 ? June 30, 2022Federal Agency: Department of Agriculture; Department of Veterans Affairs; Department of Education; Health and Human Services; Department of Homeland SecurityCompliance Requirement: Code of Federal Regulations (CRF) 2 CFR 200.510(b)Questioned Costs: NoneCriteria: The Internal Control Integrated Framework published by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) provides a basis for organizations to design internal control procedures to ensure reliable financial reporting, effective and efficient operations, and compliance with applicable laws and regulations. Components of this framework include risk assessment, control activities, and information and communication. Risk assessment is the identification and analysis of various risks entities face because of changing economic, industry, regulatory, and operating conditions, and provides a basis to develop appropriate responses to manage those risks. Control activities are policies and procedures that help ensure management directives are carried out and risks are mitigated. Verifications, approvals, reconciliations, authorizations, and segregation of duties are all control activities that support this objective. Information and communication relate to obtaining quality information and effective internal and external communication of that information to achieve management objectives.Management objectives should include the preparation and fair presentation of the SEFA in relation to the basic financial statements as a whole and in compliance with requirements contained in the U.S. Code of Federal Regulations (CFR), Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) (2 CFR ?200.510(b)), which states it must include:? Total federal awards expended as determined in accordance with 2 CFR ?200.502? Total amount provided to subrecipients from each federal programAdditionally, the Office of Management and Budget (OMB) Memorandum M-20-26 instructed recipients and subrecipients to separately identify the COVID-19 Emergency Acts expenditures on the SEFA.Condition: Several assistance listings (AL) were not properly identified as COVID-19 funds on the SEFA submitted for audit. The following items were identified by the auditors and communicated to management during the audit process:? Supplemental Nutrition Assistance Program (AL Number 10.551) $38,370,588? Activities to Support State, Tribal, Local and Territorial (STLT) Health Department Response to Public Health or Healthcare Crises (AL Number 93.391) $3,387,573? Special Education - Grants for Infants and Families (AL Number 84.181) $265,777? Family Violence Prevention and Services/Sexual Assault/Rape Crisis Services and Supports (AL Number 93.497) $183,807? WIC Special Supplemental Nutrition Program for Women, Infants, and Children (AL Number 10.557) $1,547,158? State Administrative Matching Grants for the Supplemental Nutrition Assistance Program (AL Number 10.561) $354,983? Community-Based Child Abuse Prevention Grants (AL Number 93.590) $156,539? Block Grants for Community Mental Health Services (AL Number 93.958) $389,232? Sexually Transmitted Diseases (STD) Prevention and Control Grants (AL Number 93.977) $156,712? State Veterans Home Construction (AL Number 64.005) $1,513,996? Education Stabilization Fund - Emergency Assistance for Non-Public Schools (AL Number 84.425R) $3,145,463? Disaster Grants ? Public Assistance (Presidentially Declared Disasters) (AL Number 97.036) $146,776,143Cause: The Office has not developed procedures to ensure amounts reported by State agencies on closing packages properly identifies all funds related to COVID-19. The Office relies on State agencies to self-report federal expenditures, programs, and identify if these programs are related to COVID-19 funding through the closing package process. Current procedures do not include verifying that the COVID-19 designation is appropriately included.Additionally, review procedures did not identify an error that occurred while compiling the SEFA that did not include the COVID-19 designation for AL Number 84.425R. Internal reviews did not identify this error as this information was correctly included on the agency closing package.Effect: The SEFA submitted for audit did not properly identify $196,247,971 as COVID-19 funds on the SEFA; however, these errors have been corrected.Recommendation: We recommend that the Office implement procedures and controls to ensure funds related to the COVID-19 pandemic are properly identified on the SEFA.Management?s View: The Office agrees with this finding.Corrective Action: Since the State began receiving COVID-19 funding, we diligently provided training and resources to the agencies regarding the funding and how it should be reported on the SEFA closing package. This includes a discussion in our annual closing package training, online resources regarding COVID-19 funds, an FAQ document, and being available to discuss questions and concerns. In addition to the steps we are currently taking, we will reiterate the importance of designating COVID-19 related expenditures on the SEFA closing package during our annual closing package training. We will review STARS activity in the COVID-19 related funds and compare to the agency submitted closing packages for reasonableness. Recognizing that not all agencies utilize these specific funds, we will also review COVID-19 related expenditures on an external online source that reports federal grant expenditures. We will then use this information to compare to what is reported on agency closing packages for reasonableness.Auditor?s Concluding Remarks: We thank the Office for its cooperation and assistance throughout the audit.