Audit 300283

FY End
2023-06-30
Total Expended
$2.17M
Findings
24
Programs
11
Year: 2023 Accepted: 2024-03-29

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
388588 2023-002 Significant Deficiency - ABFGLMN
388589 2023-002 Significant Deficiency - ABFGLMN
388590 2023-002 Significant Deficiency - ABFGLMN
388591 2023-002 Significant Deficiency - ABFGLMN
388592 2023-002 Significant Deficiency - ABFGLMN
388593 2023-002 Significant Deficiency - ABFGLMN
388594 2023-001 Significant Deficiency - ABFGLMN
388595 2023-001 Significant Deficiency - ABFGLMN
388596 2023-001 Significant Deficiency - ABFGLMN
388597 2023-001 Significant Deficiency - ABFGLMN
388598 2023-001 Significant Deficiency - ABFGLMN
388599 2023-001 Significant Deficiency - ABFGLMN
965030 2023-002 Significant Deficiency - ABFGLMN
965031 2023-002 Significant Deficiency - ABFGLMN
965032 2023-002 Significant Deficiency - ABFGLMN
965033 2023-002 Significant Deficiency - ABFGLMN
965034 2023-002 Significant Deficiency - ABFGLMN
965035 2023-002 Significant Deficiency - ABFGLMN
965036 2023-001 Significant Deficiency - ABFGLMN
965037 2023-001 Significant Deficiency - ABFGLMN
965038 2023-001 Significant Deficiency - ABFGLMN
965039 2023-001 Significant Deficiency - ABFGLMN
965040 2023-001 Significant Deficiency - ABFGLMN
965041 2023-001 Significant Deficiency - ABFGLMN

Programs

Contacts

Name Title Type
EMPWN5UCG1K7 Jennifer Pesanka Auditee
4128812227 Robert Coon Auditor
No contacts on file

Notes to SEFA

Title: NOTE 1 – BASIS OF PRESENTATION Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) includes the federal grant activity of the School District of Borough of Brentwood and is presented on the modified accrual basis of accounting. The information in the schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in the schedule may differ from amounts presented in, or used in the preparation of the basic financial statements. De Minimis Rate Used: N Rate Explanation: There are no indirect costs. The Schedule of Federal Awards reflects federal expenditures for all individual grants which were active during the fiscal year.
Title: NOTE 2 – BASIS OF ACCOUNTING Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) includes the federal grant activity of the School District of Borough of Brentwood and is presented on the modified accrual basis of accounting. The information in the schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in the schedule may differ from amounts presented in, or used in the preparation of the basic financial statements. De Minimis Rate Used: N Rate Explanation: There are no indirect costs. The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) includes the federal grant activity of the School District of Borough of Brentwood and is presented on the modified accrual basis of accounting. The information in the schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in the schedule may differ from amounts presented in, or used in the preparation of the basic financial statements.
Title: NOTE 3 – FOOD DONATION Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) includes the federal grant activity of the School District of Borough of Brentwood and is presented on the modified accrual basis of accounting. The information in the schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in the schedule may differ from amounts presented in, or used in the preparation of the basic financial statements. De Minimis Rate Used: N Rate Explanation: There are no indirect costs. Nonmonetary assistance is reported in the Schedule at the fair market value of the commodities received and disbursed.
Title: NOTE 4 – INDIRECT COST RATE Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) includes the federal grant activity of the School District of Borough of Brentwood and is presented on the modified accrual basis of accounting. The information in the schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in the schedule may differ from amounts presented in, or used in the preparation of the basic financial statements. De Minimis Rate Used: N Rate Explanation: There are no indirect costs. The District has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. No indirect costs were charged to the District’s Federal awards for the year ended June 30, 2023.
Title: NOTE 5 – ACCESS PROGRAM Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) includes the federal grant activity of the School District of Borough of Brentwood and is presented on the modified accrual basis of accounting. The information in the schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in the schedule may differ from amounts presented in, or used in the preparation of the basic financial statements. De Minimis Rate Used: N Rate Explanation: There are no indirect costs. The district participates in the ACCESS Program which is a medical assistance program that reimburses local educational agencies for direct eligible health-related services provided to enrolled special needs students. Reimbursements are federal source revenues but are classified ad fee-for-service and are not considered federal financial assistance. The amount of ACCESS funding recognized for the year ended June, 2023 was $132,269.

Finding Details

Condition: During our testing of the general ledger, we noted the general fund checking account was not reconciled to the balance sheet on a monthly basis. Criteria: Internal controls should be in place that provide reasonable assurance general fund checking account is reconciled to the balance sheet on a monthly basis. Cause: The District does not agree the cash reconciliation with the balance sheet. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reconciliations of general fund cash reconciliation to the balance sheet. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented
Condition: During our testing of the general ledger, we noted the general fund checking account was not reconciled to the balance sheet on a monthly basis. Criteria: Internal controls should be in place that provide reasonable assurance general fund checking account is reconciled to the balance sheet on a monthly basis. Cause: The District does not agree the cash reconciliation with the balance sheet. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reconciliations of general fund cash reconciliation to the balance sheet. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented
Condition: During our testing of the general ledger, we noted the general fund checking account was not reconciled to the balance sheet on a monthly basis. Criteria: Internal controls should be in place that provide reasonable assurance general fund checking account is reconciled to the balance sheet on a monthly basis. Cause: The District does not agree the cash reconciliation with the balance sheet. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reconciliations of general fund cash reconciliation to the balance sheet. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented
Condition: During our testing of the general ledger, we noted the general fund checking account was not reconciled to the balance sheet on a monthly basis. Criteria: Internal controls should be in place that provide reasonable assurance general fund checking account is reconciled to the balance sheet on a monthly basis. Cause: The District does not agree the cash reconciliation with the balance sheet. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reconciliations of general fund cash reconciliation to the balance sheet. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented
Condition: During our testing of the general ledger, we noted the general fund checking account was not reconciled to the balance sheet on a monthly basis. Criteria: Internal controls should be in place that provide reasonable assurance general fund checking account is reconciled to the balance sheet on a monthly basis. Cause: The District does not agree the cash reconciliation with the balance sheet. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reconciliations of general fund cash reconciliation to the balance sheet. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented
Condition: During our testing of the general ledger, we noted the general fund checking account was not reconciled to the balance sheet on a monthly basis. Criteria: Internal controls should be in place that provide reasonable assurance general fund checking account is reconciled to the balance sheet on a monthly basis. Cause: The District does not agree the cash reconciliation with the balance sheet. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reconciliations of general fund cash reconciliation to the balance sheet. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented
Condition: During our testing of the general ledger, we noted certain payroll liability accounts had incorrect balances. Criteria: Internal controls should be in place that provide reasonable assurance payroll liability accounts are properly recorded and adjusted as needed. Cause: The District does not reconcile the payroll withholding accounts in a timely manner. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reviews of the payroll liability withholding accounts and adjustments made as needed. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented.
Condition: During our testing of the general ledger, we noted certain payroll liability accounts had incorrect balances. Criteria: Internal controls should be in place that provide reasonable assurance payroll liability accounts are properly recorded and adjusted as needed. Cause: The District does not reconcile the payroll withholding accounts in a timely manner. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reviews of the payroll liability withholding accounts and adjustments made as needed. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented.
Condition: During our testing of the general ledger, we noted certain payroll liability accounts had incorrect balances. Criteria: Internal controls should be in place that provide reasonable assurance payroll liability accounts are properly recorded and adjusted as needed. Cause: The District does not reconcile the payroll withholding accounts in a timely manner. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reviews of the payroll liability withholding accounts and adjustments made as needed. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented.
Condition: During our testing of the general ledger, we noted certain payroll liability accounts had incorrect balances. Criteria: Internal controls should be in place that provide reasonable assurance payroll liability accounts are properly recorded and adjusted as needed. Cause: The District does not reconcile the payroll withholding accounts in a timely manner. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reviews of the payroll liability withholding accounts and adjustments made as needed. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented.
Condition: During our testing of the general ledger, we noted certain payroll liability accounts had incorrect balances. Criteria: Internal controls should be in place that provide reasonable assurance payroll liability accounts are properly recorded and adjusted as needed. Cause: The District does not reconcile the payroll withholding accounts in a timely manner. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reviews of the payroll liability withholding accounts and adjustments made as needed. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented.
Condition: During our testing of the general ledger, we noted certain payroll liability accounts had incorrect balances. Criteria: Internal controls should be in place that provide reasonable assurance payroll liability accounts are properly recorded and adjusted as needed. Cause: The District does not reconcile the payroll withholding accounts in a timely manner. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reviews of the payroll liability withholding accounts and adjustments made as needed. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented.
Condition: During our testing of the general ledger, we noted the general fund checking account was not reconciled to the balance sheet on a monthly basis. Criteria: Internal controls should be in place that provide reasonable assurance general fund checking account is reconciled to the balance sheet on a monthly basis. Cause: The District does not agree the cash reconciliation with the balance sheet. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reconciliations of general fund cash reconciliation to the balance sheet. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented
Condition: During our testing of the general ledger, we noted the general fund checking account was not reconciled to the balance sheet on a monthly basis. Criteria: Internal controls should be in place that provide reasonable assurance general fund checking account is reconciled to the balance sheet on a monthly basis. Cause: The District does not agree the cash reconciliation with the balance sheet. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reconciliations of general fund cash reconciliation to the balance sheet. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented
Condition: During our testing of the general ledger, we noted the general fund checking account was not reconciled to the balance sheet on a monthly basis. Criteria: Internal controls should be in place that provide reasonable assurance general fund checking account is reconciled to the balance sheet on a monthly basis. Cause: The District does not agree the cash reconciliation with the balance sheet. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reconciliations of general fund cash reconciliation to the balance sheet. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented
Condition: During our testing of the general ledger, we noted the general fund checking account was not reconciled to the balance sheet on a monthly basis. Criteria: Internal controls should be in place that provide reasonable assurance general fund checking account is reconciled to the balance sheet on a monthly basis. Cause: The District does not agree the cash reconciliation with the balance sheet. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reconciliations of general fund cash reconciliation to the balance sheet. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented
Condition: During our testing of the general ledger, we noted the general fund checking account was not reconciled to the balance sheet on a monthly basis. Criteria: Internal controls should be in place that provide reasonable assurance general fund checking account is reconciled to the balance sheet on a monthly basis. Cause: The District does not agree the cash reconciliation with the balance sheet. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reconciliations of general fund cash reconciliation to the balance sheet. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented
Condition: During our testing of the general ledger, we noted the general fund checking account was not reconciled to the balance sheet on a monthly basis. Criteria: Internal controls should be in place that provide reasonable assurance general fund checking account is reconciled to the balance sheet on a monthly basis. Cause: The District does not agree the cash reconciliation with the balance sheet. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reconciliations of general fund cash reconciliation to the balance sheet. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented
Condition: During our testing of the general ledger, we noted certain payroll liability accounts had incorrect balances. Criteria: Internal controls should be in place that provide reasonable assurance payroll liability accounts are properly recorded and adjusted as needed. Cause: The District does not reconcile the payroll withholding accounts in a timely manner. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reviews of the payroll liability withholding accounts and adjustments made as needed. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented.
Condition: During our testing of the general ledger, we noted certain payroll liability accounts had incorrect balances. Criteria: Internal controls should be in place that provide reasonable assurance payroll liability accounts are properly recorded and adjusted as needed. Cause: The District does not reconcile the payroll withholding accounts in a timely manner. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reviews of the payroll liability withholding accounts and adjustments made as needed. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented.
Condition: During our testing of the general ledger, we noted certain payroll liability accounts had incorrect balances. Criteria: Internal controls should be in place that provide reasonable assurance payroll liability accounts are properly recorded and adjusted as needed. Cause: The District does not reconcile the payroll withholding accounts in a timely manner. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reviews of the payroll liability withholding accounts and adjustments made as needed. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented.
Condition: During our testing of the general ledger, we noted certain payroll liability accounts had incorrect balances. Criteria: Internal controls should be in place that provide reasonable assurance payroll liability accounts are properly recorded and adjusted as needed. Cause: The District does not reconcile the payroll withholding accounts in a timely manner. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reviews of the payroll liability withholding accounts and adjustments made as needed. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented.
Condition: During our testing of the general ledger, we noted certain payroll liability accounts had incorrect balances. Criteria: Internal controls should be in place that provide reasonable assurance payroll liability accounts are properly recorded and adjusted as needed. Cause: The District does not reconcile the payroll withholding accounts in a timely manner. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reviews of the payroll liability withholding accounts and adjustments made as needed. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented.
Condition: During our testing of the general ledger, we noted certain payroll liability accounts had incorrect balances. Criteria: Internal controls should be in place that provide reasonable assurance payroll liability accounts are properly recorded and adjusted as needed. Cause: The District does not reconcile the payroll withholding accounts in a timely manner. Effect: District financial statements could be misstated according to accounting principles generally accepted in the United States of America. Recommendation: Procedures should be implemented requiring monthly reviews of the payroll liability withholding accounts and adjustments made as needed. Views of Responsible Officials and Planned Corrective Actions: School District Borough of Brentwood agrees with the finding and the recommended procedures have been implemented.