2022-003 Department of Education and Passed through State of South Dakota Department of Education Federal Financial Assistance Listing #84.425C, 2021G-798, 03/13/2020 ? 09/30/2022 COVID-19 Education Stabilization Fund - Governor?s Emergency Education Relief (GEER) Fund Federal Financial Assistance Listing #84.287C, 21-80064-22, 21-80064-23, 7/1/2021 ? 6/30/2022, 7/1/2022 ? 6/30/2023 Twenty-First Century Community Learning Centers Program Activities Allowed or Unallowed and Allowable Costs/Cost Principles Significant Deficiency in Internal Control over Compliance Criteria: The Organization is required to have procedures in place to ensure that federal awards are expended only for allowable costs in accordance with Subpart E ? Cost Principles of the Uniform Guidance. Allowable costs are supported by appropriate documentation and correctly charged as to account, amount, and period. 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. 2 CFR 200.430(i) establishes the standards for documentation of personnel expenses including charges to Federal awards for salaries and wages. Charges must be based on records that accurately reflect the work performed with the records meeting the following standards: a) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. b) Be incorporated into the official records of the non-Federal entity. c) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities. d) Encompass both federally assisted, and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity?s written policy. e) Comply with the established accounting policies and practices of the non-Federal entity. f) Support the distribution of the employee?s salary or wages among specific activities or cost objectives. g) Budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes. Condition: The amount of payroll taxes allocated to the GEER program exceeded the amount of payroll taxes actually paid for two of two employees tested. Additionally, one instance in which an employee?s overtime hours was not charged to the Twenty First Century Program. Lastly, one instance in which one employee?s biweekly wages were not charged to the Twenty First Century Program. Cause: Tracking of grant-related payroll is a manual process which increases the likelihood of error. Effect: Payroll and related costs were not properly reported by an insignificant amount. Questioned Costs: None reported Context: For the GEER program, a non-statistical sample of 6 employees were selected for testing of approximately 17 total employees whose time was charged to the federal award. The 6 employees selected for testing accounted for $53,784 of the $146,073 payroll costs charged to the federal award in the fiscal year. For the Twenty First Century Community Learning Centers Program, a non-statistical sample of 60 expenditures were selected for testing, including 56 payroll transactions and 4 nonpayroll transactions. The 56 payroll transactions accounted for $35,585 of $213,359 total payroll costs charged to the federal award. Repeat Finding from Prior Year: Yes, prior year finding 2021-003 Recommendation: We recommend management implement procedures and control processes to comply with the federal requirements noted above. Views of Responsible Officials: Management is in agreement.
2022-003 Department of Education and Passed through State of South Dakota Department of Education Federal Financial Assistance Listing #84.425C, 2021G-798, 03/13/2020 ? 09/30/2022 COVID-19 Education Stabilization Fund - Governor?s Emergency Education Relief (GEER) Fund Federal Financial Assistance Listing #84.287C, 21-80064-22, 21-80064-23, 7/1/2021 ? 6/30/2022, 7/1/2022 ? 6/30/2023 Twenty-First Century Community Learning Centers Program Activities Allowed or Unallowed and Allowable Costs/Cost Principles Significant Deficiency in Internal Control over Compliance Criteria: The Organization is required to have procedures in place to ensure that federal awards are expended only for allowable costs in accordance with Subpart E ? Cost Principles of the Uniform Guidance. Allowable costs are supported by appropriate documentation and correctly charged as to account, amount, and period. 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. 2 CFR 200.430(i) establishes the standards for documentation of personnel expenses including charges to Federal awards for salaries and wages. Charges must be based on records that accurately reflect the work performed with the records meeting the following standards: a) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. b) Be incorporated into the official records of the non-Federal entity. c) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities. d) Encompass both federally assisted, and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity?s written policy. e) Comply with the established accounting policies and practices of the non-Federal entity. f) Support the distribution of the employee?s salary or wages among specific activities or cost objectives. g) Budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes. Condition: The amount of payroll taxes allocated to the GEER program exceeded the amount of payroll taxes actually paid for two of two employees tested. Additionally, one instance in which an employee?s overtime hours was not charged to the Twenty First Century Program. Lastly, one instance in which one employee?s biweekly wages were not charged to the Twenty First Century Program. Cause: Tracking of grant-related payroll is a manual process which increases the likelihood of error. Effect: Payroll and related costs were not properly reported by an insignificant amount. Questioned Costs: None reported Context: For the GEER program, a non-statistical sample of 6 employees were selected for testing of approximately 17 total employees whose time was charged to the federal award. The 6 employees selected for testing accounted for $53,784 of the $146,073 payroll costs charged to the federal award in the fiscal year. For the Twenty First Century Community Learning Centers Program, a non-statistical sample of 60 expenditures were selected for testing, including 56 payroll transactions and 4 nonpayroll transactions. The 56 payroll transactions accounted for $35,585 of $213,359 total payroll costs charged to the federal award. Repeat Finding from Prior Year: Yes, prior year finding 2021-003 Recommendation: We recommend management implement procedures and control processes to comply with the federal requirements noted above. Views of Responsible Officials: Management is in agreement.
2022-004 Department of Education and Passed through State of South Dakota Department of Education Federal Financial Assistance Listing / CFDA #84.425C, 2021G-798, 03/13/2020 ? 09/30/2022 COVID-19 Education Stabilization Fund - Governor?s Emergency Education Relief (GEER) Fund Activities Allowed or Unallowed and Allowable Costs/Cost Principles Significant Deficiency in Internal Control over Compliance Criteria: The Organization is required to have procedures in place to ensure that federal awards are expended only for allowable costs in accordance with Subpart E ? Cost Principles of the Uniform Guidance. Allowable costs are supported by appropriate documentation and correctly charged as to account, amount, and period. 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition: Four instances identified in which documentation could not be provided to support a formal review and approval of the expenditures prior to payment. Cause: Documentation to support the review of expenditures prior to payment was not retained. Effect: Without documentation to support of the review and approval of disbursements, demonstrating that costs comply with laws, regulations, and other compliance requirements is difficult. Questioned Costs: None reported. Context: A non-statistical sample of 12 non-payroll transactions were selected for testing out of approximately 60 total nonpayroll transactions, accounting for approximately $135,799 of $206,855 total nonpayroll costs charged to the federal award. Repeat Finding from Prior Year: Yes, prior year finding 2021-004 Recommendation: We recommend that management retain documentation to support the review process was performed. Views of Responsible Officials: Management is in agreement.
2022-003 Department of Education and Passed through State of South Dakota Department of Education Federal Financial Assistance Listing #84.425C, 2021G-798, 03/13/2020 ? 09/30/2022 COVID-19 Education Stabilization Fund - Governor?s Emergency Education Relief (GEER) Fund Federal Financial Assistance Listing #84.287C, 21-80064-22, 21-80064-23, 7/1/2021 ? 6/30/2022, 7/1/2022 ? 6/30/2023 Twenty-First Century Community Learning Centers Program Activities Allowed or Unallowed and Allowable Costs/Cost Principles Significant Deficiency in Internal Control over Compliance Criteria: The Organization is required to have procedures in place to ensure that federal awards are expended only for allowable costs in accordance with Subpart E ? Cost Principles of the Uniform Guidance. Allowable costs are supported by appropriate documentation and correctly charged as to account, amount, and period. 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. 2 CFR 200.430(i) establishes the standards for documentation of personnel expenses including charges to Federal awards for salaries and wages. Charges must be based on records that accurately reflect the work performed with the records meeting the following standards: a) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. b) Be incorporated into the official records of the non-Federal entity. c) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities. d) Encompass both federally assisted, and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity?s written policy. e) Comply with the established accounting policies and practices of the non-Federal entity. f) Support the distribution of the employee?s salary or wages among specific activities or cost objectives. g) Budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes. Condition: The amount of payroll taxes allocated to the GEER program exceeded the amount of payroll taxes actually paid for two of two employees tested. Additionally, one instance in which an employee?s overtime hours was not charged to the Twenty First Century Program. Lastly, one instance in which one employee?s biweekly wages were not charged to the Twenty First Century Program. Cause: Tracking of grant-related payroll is a manual process which increases the likelihood of error. Effect: Payroll and related costs were not properly reported by an insignificant amount. Questioned Costs: None reported Context: For the GEER program, a non-statistical sample of 6 employees were selected for testing of approximately 17 total employees whose time was charged to the federal award. The 6 employees selected for testing accounted for $53,784 of the $146,073 payroll costs charged to the federal award in the fiscal year. For the Twenty First Century Community Learning Centers Program, a non-statistical sample of 60 expenditures were selected for testing, including 56 payroll transactions and 4 nonpayroll transactions. The 56 payroll transactions accounted for $35,585 of $213,359 total payroll costs charged to the federal award. Repeat Finding from Prior Year: Yes, prior year finding 2021-003 Recommendation: We recommend management implement procedures and control processes to comply with the federal requirements noted above. Views of Responsible Officials: Management is in agreement.
2022-003 Department of Education and Passed through State of South Dakota Department of Education Federal Financial Assistance Listing #84.425C, 2021G-798, 03/13/2020 ? 09/30/2022 COVID-19 Education Stabilization Fund - Governor?s Emergency Education Relief (GEER) Fund Federal Financial Assistance Listing #84.287C, 21-80064-22, 21-80064-23, 7/1/2021 ? 6/30/2022, 7/1/2022 ? 6/30/2023 Twenty-First Century Community Learning Centers Program Activities Allowed or Unallowed and Allowable Costs/Cost Principles Significant Deficiency in Internal Control over Compliance Criteria: The Organization is required to have procedures in place to ensure that federal awards are expended only for allowable costs in accordance with Subpart E ? Cost Principles of the Uniform Guidance. Allowable costs are supported by appropriate documentation and correctly charged as to account, amount, and period. 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. 2 CFR 200.430(i) establishes the standards for documentation of personnel expenses including charges to Federal awards for salaries and wages. Charges must be based on records that accurately reflect the work performed with the records meeting the following standards: a) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. b) Be incorporated into the official records of the non-Federal entity. c) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities. d) Encompass both federally assisted, and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity?s written policy. e) Comply with the established accounting policies and practices of the non-Federal entity. f) Support the distribution of the employee?s salary or wages among specific activities or cost objectives. g) Budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes. Condition: The amount of payroll taxes allocated to the GEER program exceeded the amount of payroll taxes actually paid for two of two employees tested. Additionally, one instance in which an employee?s overtime hours was not charged to the Twenty First Century Program. Lastly, one instance in which one employee?s biweekly wages were not charged to the Twenty First Century Program. Cause: Tracking of grant-related payroll is a manual process which increases the likelihood of error. Effect: Payroll and related costs were not properly reported by an insignificant amount. Questioned Costs: None reported Context: For the GEER program, a non-statistical sample of 6 employees were selected for testing of approximately 17 total employees whose time was charged to the federal award. The 6 employees selected for testing accounted for $53,784 of the $146,073 payroll costs charged to the federal award in the fiscal year. For the Twenty First Century Community Learning Centers Program, a non-statistical sample of 60 expenditures were selected for testing, including 56 payroll transactions and 4 nonpayroll transactions. The 56 payroll transactions accounted for $35,585 of $213,359 total payroll costs charged to the federal award. Repeat Finding from Prior Year: Yes, prior year finding 2021-003 Recommendation: We recommend management implement procedures and control processes to comply with the federal requirements noted above. Views of Responsible Officials: Management is in agreement.
2022-004 Department of Education and Passed through State of South Dakota Department of Education Federal Financial Assistance Listing / CFDA #84.425C, 2021G-798, 03/13/2020 ? 09/30/2022 COVID-19 Education Stabilization Fund - Governor?s Emergency Education Relief (GEER) Fund Activities Allowed or Unallowed and Allowable Costs/Cost Principles Significant Deficiency in Internal Control over Compliance Criteria: The Organization is required to have procedures in place to ensure that federal awards are expended only for allowable costs in accordance with Subpart E ? Cost Principles of the Uniform Guidance. Allowable costs are supported by appropriate documentation and correctly charged as to account, amount, and period. 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition: Four instances identified in which documentation could not be provided to support a formal review and approval of the expenditures prior to payment. Cause: Documentation to support the review of expenditures prior to payment was not retained. Effect: Without documentation to support of the review and approval of disbursements, demonstrating that costs comply with laws, regulations, and other compliance requirements is difficult. Questioned Costs: None reported. Context: A non-statistical sample of 12 non-payroll transactions were selected for testing out of approximately 60 total nonpayroll transactions, accounting for approximately $135,799 of $206,855 total nonpayroll costs charged to the federal award. Repeat Finding from Prior Year: Yes, prior year finding 2021-004 Recommendation: We recommend that management retain documentation to support the review process was performed. Views of Responsible Officials: Management is in agreement.