Audit 305999

FY End
2023-08-31
Total Expended
$14.96M
Findings
4
Programs
20
Organization: Aberdeen School District No. 5 (WA)
Year: 2023 Accepted: 2024-05-10

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
396423 2023-001 Material Weakness - B
396424 2023-001 Material Weakness - B
972865 2023-001 Material Weakness - B
972866 2023-001 Material Weakness - B

Contacts

Name Title Type
KNQKL9KQBNJ7 Elyssa Louderback Auditee
3605382007 Lisa Carrell Auditor
No contacts on file

Notes to SEFA

Title: Basis of Accounting Accounting Policies: The Schedule of Expenditures of Federal Awards is prepared on the same basis of accounting as the Aberdeen School District's financial statements. The Aberdeen School District uses the modified accrual basis of accounting. Expenditures represent only the federally funded portions of the program. District records accounting. Expenditures represent only the federally funded portions of the program. District records De Minimis Rate Used: N Rate Explanation: The Aberdeen School District has not elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The district used the federal restricted rate of 3.12%. The Aberdeen School District used a fixed rate of 2.30 percent for this program. (Indian Educ) The Aberdeen School District used a fixed rate of 15.33 for this program. (ESSER II, ESSER III, ESSER III) The Aberdeen School district used a fixed rate of 19.76 for this program. (ESSER ASP) The Schedule of Expenditures of Federal Awards is prepared on the same basis of accounting as the Aberdeen School District's financial statements. The Aberdeen School District uses the modified accrual basis of accounting. Expenditures represent only the federally funded portions of the program. District records should be consulted to determine amounts expended or matched from non-federal sources.
Title: Federal De Minimus Indirect Rate Accounting Policies: The Schedule of Expenditures of Federal Awards is prepared on the same basis of accounting as the Aberdeen School District's financial statements. The Aberdeen School District uses the modified accrual basis of accounting. Expenditures represent only the federally funded portions of the program. District records accounting. Expenditures represent only the federally funded portions of the program. District records De Minimis Rate Used: N Rate Explanation: The Aberdeen School District has not elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The district used the federal restricted rate of 3.12%. The Aberdeen School District used a fixed rate of 2.30 percent for this program. (Indian Educ) The Aberdeen School District used a fixed rate of 15.33 for this program. (ESSER II, ESSER III, ESSER III) The Aberdeen School district used a fixed rate of 19.76 for this program. (ESSER ASP) The Aberdeen School District has not elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The district used the federal restricted rate of 3.12%
Title: Program Costs / Matching Contributions Accounting Policies: The Schedule of Expenditures of Federal Awards is prepared on the same basis of accounting as the Aberdeen School District's financial statements. The Aberdeen School District uses the modified accrual basis of accounting. Expenditures represent only the federally funded portions of the program. District records accounting. Expenditures represent only the federally funded portions of the program. District records De Minimis Rate Used: N Rate Explanation: The Aberdeen School District has not elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The district used the federal restricted rate of 3.12%. The Aberdeen School District used a fixed rate of 2.30 percent for this program. (Indian Educ) The Aberdeen School District used a fixed rate of 15.33 for this program. (ESSER II, ESSER III, ESSER III) The Aberdeen School district used a fixed rate of 19.76 for this program. (ESSER ASP) The amounts shown as current year expenses represent only the federal award portion of the program costs. Entire program costs, including the Aberdeen School District's local matching share, may be more than shown. Such expenditures are recognized following the cost principles contained in the Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Costs Principles, and Audit Requirements for Federal Awards, wherein certain types of expenditures are not allowable or are limited as to reimbursement.
Title: Noncash Awards Accounting Policies: The Schedule of Expenditures of Federal Awards is prepared on the same basis of accounting as the Aberdeen School District's financial statements. The Aberdeen School District uses the modified accrual basis of accounting. Expenditures represent only the federally funded portions of the program. District records accounting. Expenditures represent only the federally funded portions of the program. District records De Minimis Rate Used: N Rate Explanation: The Aberdeen School District has not elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The district used the federal restricted rate of 3.12%. The Aberdeen School District used a fixed rate of 2.30 percent for this program. (Indian Educ) The Aberdeen School District used a fixed rate of 15.33 for this program. (ESSER II, ESSER III, ESSER III) The Aberdeen School district used a fixed rate of 19.76 for this program. (ESSER ASP) The amount of commodities reported on the schedule is the value of commodities distributed by the Aberdeen School District during the current year and priced as prescribed by OSPI.
Title: Schoolwide Programs Accounting Policies: The Schedule of Expenditures of Federal Awards is prepared on the same basis of accounting as the Aberdeen School District's financial statements. The Aberdeen School District uses the modified accrual basis of accounting. Expenditures represent only the federally funded portions of the program. District records accounting. Expenditures represent only the federally funded portions of the program. District records De Minimis Rate Used: N Rate Explanation: The Aberdeen School District has not elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The district used the federal restricted rate of 3.12%. The Aberdeen School District used a fixed rate of 2.30 percent for this program. (Indian Educ) The Aberdeen School District used a fixed rate of 15.33 for this program. (ESSER II, ESSER III, ESSER III) The Aberdeen School district used a fixed rate of 19.76 for this program. (ESSER ASP) The Aberdeen School District operates a “schoolwide program” in four elementary buildings, one middle school and one alternative high school. Using federal funding, schoolwide programs are designed to upgrade an entire educational program within a school for all students, rather than limit services to certain targeted students. The following federal program amounts were expended by the Aberdeen School District in its schoolwide programs. Title I (84.010) - $1,537,719.40
Title: Federal Indirect Rate Accounting Policies: The Schedule of Expenditures of Federal Awards is prepared on the same basis of accounting as the Aberdeen School District's financial statements. The Aberdeen School District uses the modified accrual basis of accounting. Expenditures represent only the federally funded portions of the program. District records accounting. Expenditures represent only the federally funded portions of the program. District records De Minimis Rate Used: N Rate Explanation: The Aberdeen School District has not elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The district used the federal restricted rate of 3.12%. The Aberdeen School District used a fixed rate of 2.30 percent for this program. (Indian Educ) The Aberdeen School District used a fixed rate of 15.33 for this program. (ESSER II, ESSER III, ESSER III) The Aberdeen School district used a fixed rate of 19.76 for this program. (ESSER ASP) The Aberdeen School District used a fixed rate of 2.30 percent for this program. (Indian Educ)
Title: Federal Indirect Rate Accounting Policies: The Schedule of Expenditures of Federal Awards is prepared on the same basis of accounting as the Aberdeen School District's financial statements. The Aberdeen School District uses the modified accrual basis of accounting. Expenditures represent only the federally funded portions of the program. District records accounting. Expenditures represent only the federally funded portions of the program. District records De Minimis Rate Used: N Rate Explanation: The Aberdeen School District has not elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The district used the federal restricted rate of 3.12%. The Aberdeen School District used a fixed rate of 2.30 percent for this program. (Indian Educ) The Aberdeen School District used a fixed rate of 15.33 for this program. (ESSER II, ESSER III, ESSER III) The Aberdeen School district used a fixed rate of 19.76 for this program. (ESSER ASP) The Aberdeen School District used a fixed rate of 15.33 for this program. (ESSER II, ESSER III, ESSER III)
Title: Federal Indirect Rate Accounting Policies: The Schedule of Expenditures of Federal Awards is prepared on the same basis of accounting as the Aberdeen School District's financial statements. The Aberdeen School District uses the modified accrual basis of accounting. Expenditures represent only the federally funded portions of the program. District records accounting. Expenditures represent only the federally funded portions of the program. District records De Minimis Rate Used: N Rate Explanation: The Aberdeen School District has not elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The district used the federal restricted rate of 3.12%. The Aberdeen School District used a fixed rate of 2.30 percent for this program. (Indian Educ) The Aberdeen School District used a fixed rate of 15.33 for this program. (ESSER II, ESSER III, ESSER III) The Aberdeen School district used a fixed rate of 19.76 for this program. (ESSER ASP) The Aberdeen School district used a fixed rate of 19.76 for this program. (ESSER ASP)
Title: Federal Indirect Rate Accounting Policies: The Schedule of Expenditures of Federal Awards is prepared on the same basis of accounting as the Aberdeen School District's financial statements. The Aberdeen School District uses the modified accrual basis of accounting. Expenditures represent only the federally funded portions of the program. District records accounting. Expenditures represent only the federally funded portions of the program. District records De Minimis Rate Used: N Rate Explanation: The Aberdeen School District has not elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The district used the federal restricted rate of 3.12%. The Aberdeen School District used a fixed rate of 2.30 percent for this program. (Indian Educ) The Aberdeen School District used a fixed rate of 15.33 for this program. (ESSER II, ESSER III, ESSER III) The Aberdeen School district used a fixed rate of 19.76 for this program. (ESSER ASP) The following 2022 expenditures were erroneously omitted from the 2022 Schedule of Expenditures of Federal Awards. The expenditure has been included in the expenditure amounts reported on the 2023 Schedule of Expenditures of Federal Awards -- An amount of 3597.90 expended in 2022 under ALN 10.582 "Farm to Schools" .

Finding Details

2023-001    The District’s internal controls were inadequate for ensuring compliance with time and effort requirements. Assistance Listing Number and Title: 84.027, Special Education Grants to States 84.173, Special Education Preschool Grants Federal Grantor Name: U.S. Department of Education Federal Award/Contract Number: N/A Pass-through Entity Name: Office of Superintendent of Public Instruction (OSPI) Pass-through Award/Contract Number: 307823/367215   Known Questioned Cost Amount: N/A Prior Year Audit Finding: N/A     Background During fiscal year 2023, the District spent $865,457 of its Special Education Program funds. This program ensures students with disabilities receive free and appropriate public education with specially designed instruction that addresses their unique needs. Federal regulations require recipients to establish and maintain internal controls that ensure compliance with program requirements. Those controls include understanding program requirements and monitoring the effectiveness of established controls. The District is responsible for ensuring it supports all payroll costs it charges to the program with adequate time and effort documentation, as required by federal regulations and the awarding agency. Depending on the number and type of activities employees perform, time and effort documentation can be a semiannual certification or a monthly personnel activity report, such as a detailed timesheet. Time and effort documentation must also be signed and dated after the work is completed. Description of Condition The District’s internal controls were ineffective for ensuring it supported all salaries and benefits it charged to the program with appropriate time and effort documentation, as federal regulations and OSPI require. We consider this deficiency in internal controls to be a material weakness that led to material noncompliance. Cause of Condition Turnover in the District’s key positions responsible for managing the program  resulted in an oversight in ensuring compliance with time and effort requirements. Effect of Condition The District did not obtain time and effort documentation for all employees whose payroll and benefits costs it charged to the program, totaling $696,887.  Without adequate time and effort documentation, the District cannot demonstrate compliance with the awarding agency’s documentation requirements that support costs charged to federal programs. Further, the District cannot assure federal grantors that payroll costs it charged to the program were accurate and valid. During the audit, the District obtained and provided the signed time and effort records to support the payroll costs it charged to the program; therefore, we are not questioning these costs. Recommendation We recommend the District establish and follow internal controls to ensure it complies with federal and OSPI requirements for obtaining signed time and effort documentation timely. District’s Response The district was in transition with staff overseeing time and effort for the year inquestion. Staff salaries were reviewed at the end of the year by the Business Office with communication from the buildings to verify staff were paid from the appropriate programs. The building staff that were requested to sign the Semi Annual certification forms for time and effort documentation after the close of the fiscal year and date them for the time period that they were specific to. In the future, the district will request staff sign the Semi Annual certification forms and date them for the day they are being signed. Auditor’s Remarks We thank the District for its cooperation throughout the audit and the steps it is taking to address these concerns. We will review the status of the District’s corrective action during our next audit. Applicable Laws and Regulations Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), section 516, Audit findings, establishes reporting requirements for audit findings. Title 2 CFR Part 200, Uniform Guidance, section 303, Internal controls, describes the requirements for auditees to maintain internal controls over federal programs and comply with federal program requirements. The American Institute of Certified Public Accountants defines significant deficiencies and material weaknesses in its Codification of Statements on Auditing Standards, section 935, Compliance Audits, paragraph 11. Title 2 CFR Part 200, Uniform Guidance, Subpart E, Cost Principles, establishes requirements for determining allowable costs and supporting costs allocated to federal programs. Office of Superintendent of Public Instruction Addendum to Bulletin 048-17, establishes requirements for documenting time and effort.
2023-001    The District’s internal controls were inadequate for ensuring compliance with time and effort requirements. Assistance Listing Number and Title: 84.027, Special Education Grants to States 84.173, Special Education Preschool Grants Federal Grantor Name: U.S. Department of Education Federal Award/Contract Number: N/A Pass-through Entity Name: Office of Superintendent of Public Instruction (OSPI) Pass-through Award/Contract Number: 307823/367215   Known Questioned Cost Amount: N/A Prior Year Audit Finding: N/A     Background During fiscal year 2023, the District spent $865,457 of its Special Education Program funds. This program ensures students with disabilities receive free and appropriate public education with specially designed instruction that addresses their unique needs. Federal regulations require recipients to establish and maintain internal controls that ensure compliance with program requirements. Those controls include understanding program requirements and monitoring the effectiveness of established controls. The District is responsible for ensuring it supports all payroll costs it charges to the program with adequate time and effort documentation, as required by federal regulations and the awarding agency. Depending on the number and type of activities employees perform, time and effort documentation can be a semiannual certification or a monthly personnel activity report, such as a detailed timesheet. Time and effort documentation must also be signed and dated after the work is completed. Description of Condition The District’s internal controls were ineffective for ensuring it supported all salaries and benefits it charged to the program with appropriate time and effort documentation, as federal regulations and OSPI require. We consider this deficiency in internal controls to be a material weakness that led to material noncompliance. Cause of Condition Turnover in the District’s key positions responsible for managing the program  resulted in an oversight in ensuring compliance with time and effort requirements. Effect of Condition The District did not obtain time and effort documentation for all employees whose payroll and benefits costs it charged to the program, totaling $696,887.  Without adequate time and effort documentation, the District cannot demonstrate compliance with the awarding agency’s documentation requirements that support costs charged to federal programs. Further, the District cannot assure federal grantors that payroll costs it charged to the program were accurate and valid. During the audit, the District obtained and provided the signed time and effort records to support the payroll costs it charged to the program; therefore, we are not questioning these costs. Recommendation We recommend the District establish and follow internal controls to ensure it complies with federal and OSPI requirements for obtaining signed time and effort documentation timely. District’s Response The district was in transition with staff overseeing time and effort for the year inquestion. Staff salaries were reviewed at the end of the year by the Business Office with communication from the buildings to verify staff were paid from the appropriate programs. The building staff that were requested to sign the Semi Annual certification forms for time and effort documentation after the close of the fiscal year and date them for the time period that they were specific to. In the future, the district will request staff sign the Semi Annual certification forms and date them for the day they are being signed. Auditor’s Remarks We thank the District for its cooperation throughout the audit and the steps it is taking to address these concerns. We will review the status of the District’s corrective action during our next audit. Applicable Laws and Regulations Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), section 516, Audit findings, establishes reporting requirements for audit findings. Title 2 CFR Part 200, Uniform Guidance, section 303, Internal controls, describes the requirements for auditees to maintain internal controls over federal programs and comply with federal program requirements. The American Institute of Certified Public Accountants defines significant deficiencies and material weaknesses in its Codification of Statements on Auditing Standards, section 935, Compliance Audits, paragraph 11. Title 2 CFR Part 200, Uniform Guidance, Subpart E, Cost Principles, establishes requirements for determining allowable costs and supporting costs allocated to federal programs. Office of Superintendent of Public Instruction Addendum to Bulletin 048-17, establishes requirements for documenting time and effort.
2023-001    The District’s internal controls were inadequate for ensuring compliance with time and effort requirements. Assistance Listing Number and Title: 84.027, Special Education Grants to States 84.173, Special Education Preschool Grants Federal Grantor Name: U.S. Department of Education Federal Award/Contract Number: N/A Pass-through Entity Name: Office of Superintendent of Public Instruction (OSPI) Pass-through Award/Contract Number: 307823/367215   Known Questioned Cost Amount: N/A Prior Year Audit Finding: N/A     Background During fiscal year 2023, the District spent $865,457 of its Special Education Program funds. This program ensures students with disabilities receive free and appropriate public education with specially designed instruction that addresses their unique needs. Federal regulations require recipients to establish and maintain internal controls that ensure compliance with program requirements. Those controls include understanding program requirements and monitoring the effectiveness of established controls. The District is responsible for ensuring it supports all payroll costs it charges to the program with adequate time and effort documentation, as required by federal regulations and the awarding agency. Depending on the number and type of activities employees perform, time and effort documentation can be a semiannual certification or a monthly personnel activity report, such as a detailed timesheet. Time and effort documentation must also be signed and dated after the work is completed. Description of Condition The District’s internal controls were ineffective for ensuring it supported all salaries and benefits it charged to the program with appropriate time and effort documentation, as federal regulations and OSPI require. We consider this deficiency in internal controls to be a material weakness that led to material noncompliance. Cause of Condition Turnover in the District’s key positions responsible for managing the program  resulted in an oversight in ensuring compliance with time and effort requirements. Effect of Condition The District did not obtain time and effort documentation for all employees whose payroll and benefits costs it charged to the program, totaling $696,887.  Without adequate time and effort documentation, the District cannot demonstrate compliance with the awarding agency’s documentation requirements that support costs charged to federal programs. Further, the District cannot assure federal grantors that payroll costs it charged to the program were accurate and valid. During the audit, the District obtained and provided the signed time and effort records to support the payroll costs it charged to the program; therefore, we are not questioning these costs. Recommendation We recommend the District establish and follow internal controls to ensure it complies with federal and OSPI requirements for obtaining signed time and effort documentation timely. District’s Response The district was in transition with staff overseeing time and effort for the year inquestion. Staff salaries were reviewed at the end of the year by the Business Office with communication from the buildings to verify staff were paid from the appropriate programs. The building staff that were requested to sign the Semi Annual certification forms for time and effort documentation after the close of the fiscal year and date them for the time period that they were specific to. In the future, the district will request staff sign the Semi Annual certification forms and date them for the day they are being signed. Auditor’s Remarks We thank the District for its cooperation throughout the audit and the steps it is taking to address these concerns. We will review the status of the District’s corrective action during our next audit. Applicable Laws and Regulations Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), section 516, Audit findings, establishes reporting requirements for audit findings. Title 2 CFR Part 200, Uniform Guidance, section 303, Internal controls, describes the requirements for auditees to maintain internal controls over federal programs and comply with federal program requirements. The American Institute of Certified Public Accountants defines significant deficiencies and material weaknesses in its Codification of Statements on Auditing Standards, section 935, Compliance Audits, paragraph 11. Title 2 CFR Part 200, Uniform Guidance, Subpart E, Cost Principles, establishes requirements for determining allowable costs and supporting costs allocated to federal programs. Office of Superintendent of Public Instruction Addendum to Bulletin 048-17, establishes requirements for documenting time and effort.
2023-001    The District’s internal controls were inadequate for ensuring compliance with time and effort requirements. Assistance Listing Number and Title: 84.027, Special Education Grants to States 84.173, Special Education Preschool Grants Federal Grantor Name: U.S. Department of Education Federal Award/Contract Number: N/A Pass-through Entity Name: Office of Superintendent of Public Instruction (OSPI) Pass-through Award/Contract Number: 307823/367215   Known Questioned Cost Amount: N/A Prior Year Audit Finding: N/A     Background During fiscal year 2023, the District spent $865,457 of its Special Education Program funds. This program ensures students with disabilities receive free and appropriate public education with specially designed instruction that addresses their unique needs. Federal regulations require recipients to establish and maintain internal controls that ensure compliance with program requirements. Those controls include understanding program requirements and monitoring the effectiveness of established controls. The District is responsible for ensuring it supports all payroll costs it charges to the program with adequate time and effort documentation, as required by federal regulations and the awarding agency. Depending on the number and type of activities employees perform, time and effort documentation can be a semiannual certification or a monthly personnel activity report, such as a detailed timesheet. Time and effort documentation must also be signed and dated after the work is completed. Description of Condition The District’s internal controls were ineffective for ensuring it supported all salaries and benefits it charged to the program with appropriate time and effort documentation, as federal regulations and OSPI require. We consider this deficiency in internal controls to be a material weakness that led to material noncompliance. Cause of Condition Turnover in the District’s key positions responsible for managing the program  resulted in an oversight in ensuring compliance with time and effort requirements. Effect of Condition The District did not obtain time and effort documentation for all employees whose payroll and benefits costs it charged to the program, totaling $696,887.  Without adequate time and effort documentation, the District cannot demonstrate compliance with the awarding agency’s documentation requirements that support costs charged to federal programs. Further, the District cannot assure federal grantors that payroll costs it charged to the program were accurate and valid. During the audit, the District obtained and provided the signed time and effort records to support the payroll costs it charged to the program; therefore, we are not questioning these costs. Recommendation We recommend the District establish and follow internal controls to ensure it complies with federal and OSPI requirements for obtaining signed time and effort documentation timely. District’s Response The district was in transition with staff overseeing time and effort for the year inquestion. Staff salaries were reviewed at the end of the year by the Business Office with communication from the buildings to verify staff were paid from the appropriate programs. The building staff that were requested to sign the Semi Annual certification forms for time and effort documentation after the close of the fiscal year and date them for the time period that they were specific to. In the future, the district will request staff sign the Semi Annual certification forms and date them for the day they are being signed. Auditor’s Remarks We thank the District for its cooperation throughout the audit and the steps it is taking to address these concerns. We will review the status of the District’s corrective action during our next audit. Applicable Laws and Regulations Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), section 516, Audit findings, establishes reporting requirements for audit findings. Title 2 CFR Part 200, Uniform Guidance, section 303, Internal controls, describes the requirements for auditees to maintain internal controls over federal programs and comply with federal program requirements. The American Institute of Certified Public Accountants defines significant deficiencies and material weaknesses in its Codification of Statements on Auditing Standards, section 935, Compliance Audits, paragraph 11. Title 2 CFR Part 200, Uniform Guidance, Subpart E, Cost Principles, establishes requirements for determining allowable costs and supporting costs allocated to federal programs. Office of Superintendent of Public Instruction Addendum to Bulletin 048-17, establishes requirements for documenting time and effort.