Receivables not accrued for reimbursement grants subject to Uniform Guidance and the tracking of federal grant expenditures was not sufficient so that an accurate Schedule of Federal Expenditures (SEFA) could be prepared by the School (Significant Deficiency in Controls and Non-compliance) Condition: Vision Preparatory Charter School, Inc. tracked grant expenditures paid for several federal grants subject to Uniform Guidance by the date the reimbursement request was submitted instead of by the date the expenditure was paid and eligible for reimbursement. As a result of grant reimbursement requests not being properly accrued, the SEFA was understated by $35,580 for the Education Stabilization Fund Program. Also, the schedule did not include all ALN numbers. Criteria: Uniform Guidance requires the SEFA be prepared using eligible expenditures paid in the reporting year for federal funds subject to the Uniform Guidance. CFR Part 200.508 Auditee responsibilities state that the auditee must prepare the Schedule of Expenditures of Federal Awards, which must list the individual Federal Awards by Federal Agency, including the Federal Awards expended, name of passthrough entity, ALN number, and total amount provided to recipients. The information contained in the Schedule of Federal Awards should be derived from and relate directly to the underlying accounting and other records used to prepare the financial statements.Cause: The School tracked the federal funds expenditures on a reimbursement request basis rather than an eligibility/paid basis and did not reconcile the amounts reported on the Schedule of Federal Awards with the amounts reported in the School’s general ledger. Effect: Receivables were not accrued for these expenditures and the Schedule of Federal Expenditures prepared by the School did not reflect all of the expenditures paid in the fiscal year ended June 30, 2022 and the Schedule of Federal Awards was incorrectly prepared. Questioned Cost: None Context: The SEFA presented for audit was understated by $35,580 for the major program audited (Education Stabilization Fund Grant). Recommendation: We recommend the School track the expenditures in Quickbooks as the expenditures are paid and we recommend the School record receivables for all of the qualifying expenditures paid but not reimbursed by year end and reconcile the Schedule of Federal Awards with the general ledger.
Assistance Listing, Federal Agency, and Program Name - Assistance Listing 66.443, Environmental Protection Agency, Reducing Lead in Drinking Water Federal Award Identification Number and Year - OOE02968, 2021 Pass-through Entity - n/a Finding Type - Material weakness Repeat Finding - No Criteria - 2 CFR 200.508 requires the City to prepare appropriate financial statements, including the schedule of expenditures of federal awards (SEFA) in accordance with 2 CFR 200.510. The SEFA must list individual federal programs as required by 2 CFR 200.501(b)(1). The SEFA is the basis for the auditor determination of major programs as required by 2 CFR 200.518. Condition - The original SEFA prepared for audit purposes did not include all federal expenditures that should have been reported under ALN 66.443. Questioned Costs - None Identification of How Questioned Costs Were Computed - n/a Context - Approximately $864,000 of federal expenditures were not included in the original SEFA prepared for audit purposes under ALN 66.443. Cause and Effect - The City's controls over reconciling the SEFA to federal revenue did not detect the missing expenditures because federal revenue was not appropriately accrued by $864,000. As a result, ALN 66.443 was not originally identified as a major program. Recommendation - The City should review its controls over preparation of the SEFA and reconciling the SEFA to federal expenditures per the general ledger to ensure the appropriate amount of federal expenditures are reported on the SEFA. Views of Responsible Officials and Corrective Action Plan - We agree with the auditor’s recommendation. Changes have been implemented to ensure all programs with both federal and state/local funding will be examined to ensure correct expenditure by funding source is properly recorded.
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.
2022-001. US Department of AgricultureSchool Food Service Program CFDA No. 10.553, 10.555, and 10.559 (repeat finding #2016-1 and #2017-1 from prior years).Criteria: 2 CFR ?200.508(a) requires the auditee to ensure that an audit is properly performed and submitted when due in accordance with ? 200.512(a)(1) Report submission.Condition: Yeshiva Imrei Chaim Viznitz ? School Food Service Program did submit the annual report on a timely basis.Questioned Costs: None.Effect: Yeshiva Imrei Chaim Viznitz ? School Food Service Program did fulfill its requirement of timely submission of the annual reports.Context: Previous period audits of the timing of submittal of the audit report indicated that those reports were not submitted on a timely basis.Auditor?s Recommendation: Yeshiva Imrei Chaim Viznitz - School Food Service Program should maintain its newly established procedures to ensure that all future reports can be submitted on a timely basis as was done this year.Views of the responsible officials and planned corrective actions: Management has successfully implemented procedures which ensure that reports are submitted on a timely basis. While procedures were instituted in the preceding reporting period to eliminate the causes of previous period delays, new issues related to ongoing Covid-19 restrictions cropped up which inhibited the timely filing of the aforementioned period?s reports. Management tweaked the reporting process in the previous period in order to account for those obstacles as well. As such, Management is able to submit the report for 6/30/2022 in a timely manner, by 3/31/2023 or earlier.
2022-001. US Department of AgricultureSchool Food Service Program CFDA No. 10.553, 10.555, and 10.559 (repeat finding #2016-1 and #2017-1 from prior years).Criteria: 2 CFR ?200.508(a) requires the auditee to ensure that an audit is properly performed and submitted when due in accordance with ? 200.512(a)(1) Report submission.Condition: Yeshiva Imrei Chaim Viznitz ? School Food Service Program did submit the annual report on a timely basis.Questioned Costs: None.Effect: Yeshiva Imrei Chaim Viznitz ? School Food Service Program did fulfill its requirement of timely submission of the annual reports.Context: Previous period audits of the timing of submittal of the audit report indicated that those reports were not submitted on a timely basis.Auditor?s Recommendation: Yeshiva Imrei Chaim Viznitz - School Food Service Program should maintain its newly established procedures to ensure that all future reports can be submitted on a timely basis as was done this year.Views of the responsible officials and planned corrective actions: Management has successfully implemented procedures which ensure that reports are submitted on a timely basis. While procedures were instituted in the preceding reporting period to eliminate the causes of previous period delays, new issues related to ongoing Covid-19 restrictions cropped up which inhibited the timely filing of the aforementioned period?s reports. Management tweaked the reporting process in the previous period in order to account for those obstacles as well. As such, Management is able to submit the report for 6/30/2022 in a timely manner, by 3/31/2023 or earlier.
2022-001. US Department of AgricultureSchool Food Service Program CFDA No. 10.553, 10.555, and 10.559 (repeat finding #2016-1 and #2017-1 from prior years).Criteria: 2 CFR ?200.508(a) requires the auditee to ensure that an audit is properly performed and submitted when due in accordance with ? 200.512(a)(1) Report submission.Condition: Yeshiva Imrei Chaim Viznitz ? School Food Service Program did submit the annual report on a timely basis.Questioned Costs: None.Effect: Yeshiva Imrei Chaim Viznitz ? School Food Service Program did fulfill its requirement of timely submission of the annual reports.Context: Previous period audits of the timing of submittal of the audit report indicated that those reports were not submitted on a timely basis.Auditor?s Recommendation: Yeshiva Imrei Chaim Viznitz - School Food Service Program should maintain its newly established procedures to ensure that all future reports can be submitted on a timely basis as was done this year.Views of the responsible officials and planned corrective actions: Management has successfully implemented procedures which ensure that reports are submitted on a timely basis. While procedures were instituted in the preceding reporting period to eliminate the causes of previous period delays, new issues related to ongoing Covid-19 restrictions cropped up which inhibited the timely filing of the aforementioned period?s reports. Management tweaked the reporting process in the previous period in order to account for those obstacles as well. As such, Management is able to submit the report for 6/30/2022 in a timely manner, by 3/31/2023 or earlier.
2022-001. US Department of AgricultureSchool Food Service Program CFDA No. 10.553, 10.555, and 10.559 (repeat finding #2016-1 and #2017-1 from prior years).Criteria: 2 CFR ?200.508(a) requires the auditee to ensure that an audit is properly performed and submitted when due in accordance with ? 200.512(a)(1) Report submission.Condition: Yeshiva Imrei Chaim Viznitz ? School Food Service Program did submit the annual report on a timely basis.Questioned Costs: None.Effect: Yeshiva Imrei Chaim Viznitz ? School Food Service Program did fulfill its requirement of timely submission of the annual reports.Context: Previous period audits of the timing of submittal of the audit report indicated that those reports were not submitted on a timely basis.Auditor?s Recommendation: Yeshiva Imrei Chaim Viznitz - School Food Service Program should maintain its newly established procedures to ensure that all future reports can be submitted on a timely basis as was done this year.Views of the responsible officials and planned corrective actions: Management has successfully implemented procedures which ensure that reports are submitted on a timely basis. While procedures were instituted in the preceding reporting period to eliminate the causes of previous period delays, new issues related to ongoing Covid-19 restrictions cropped up which inhibited the timely filing of the aforementioned period?s reports. Management tweaked the reporting process in the previous period in order to account for those obstacles as well. As such, Management is able to submit the report for 6/30/2022 in a timely manner, by 3/31/2023 or earlier.
2022-001. US Department of AgricultureSchool Food Service Program CFDA No. 10.553, 10.555, and 10.559 (repeat finding #2016-1 and #2017-1 from prior years).Criteria: 2 CFR ?200.508(a) requires the auditee to ensure that an audit is properly performed and submitted when due in accordance with ? 200.512(a)(1) Report submission.Condition: Yeshiva Imrei Chaim Viznitz ? School Food Service Program did submit the annual report on a timely basis.Questioned Costs: None.Effect: Yeshiva Imrei Chaim Viznitz ? School Food Service Program did fulfill its requirement of timely submission of the annual reports.Context: Previous period audits of the timing of submittal of the audit report indicated that those reports were not submitted on a timely basis.Auditor?s Recommendation: Yeshiva Imrei Chaim Viznitz - School Food Service Program should maintain its newly established procedures to ensure that all future reports can be submitted on a timely basis as was done this year.Views of the responsible officials and planned corrective actions: Management has successfully implemented procedures which ensure that reports are submitted on a timely basis. While procedures were instituted in the preceding reporting period to eliminate the causes of previous period delays, new issues related to ongoing Covid-19 restrictions cropped up which inhibited the timely filing of the aforementioned period?s reports. Management tweaked the reporting process in the previous period in order to account for those obstacles as well. As such, Management is able to submit the report for 6/30/2022 in a timely manner, by 3/31/2023 or earlier.
Condition: The Single Audit reporting package, as defined and required in 2 CRF 200.512 for fiscal year ended June 30, 2022, was not submitted timely. Context: Despite the Municipality’s best efforts to provide, on a timely basis, the information needed to complete the preparation and subsequent audit of their financial statements, the effects of the major disaster area declaration due to Hurricane Fiona delayed the submission of the Single Audit reporting package of the current year. Criteria: As per 2 CRF 200.512, the audit, data collection form, and reporting package must be submitted within the earlier of 30 calendar days after receipt of the auditor’s report, or nine months after the end of the audit period. However, for any 2022 submissions with fiscal periods ending between January 1, 2022, and October 31, 2022, the requirement stating that single audits are due to the Federal Audit Clearinghouse 30 days after receipt of the auditor’s report(s), is waived. These audits will be considered on time if they are submitted within nine months after their fiscal period end date. Cause: On September 18, 2022, Puerto Rico was declared a major disaster area due to the passage of Hurricane Fiona. As a result of this declaration, the OMB granted a six-month extension for all single audits that cover recipients in Puerto Rico and have due dates between September 18, 2022 and December 31, 2022. For June 30, 2021, the extended due date was March 31, 2023. The Municipality benefited from this extension and submitted their financial statements and data collection form on March 17, 2023. The due date of the current fiscal year, June 30, 2022 however was not extended and was also due on March 31, 2023. This situation prevented the timely submission of the current fiscal year Single Audit reporting package. Effect: Because of the situation described above, the Municipality did not comply with the report submission requirement since the audit was not submitted within nine months after their fiscal period end date. Auditor’s recommendation: Management should continue to fulfill their auditee responsibilities as stated in 2 CRF 200.508 which among other things, require management to prepare appropriate financial statements and provide the auditor with access to personnel, accounts, books, records, supporting documentation, and other information as needed for the auditor to perform the audit to ensure that subsequent financial reporting packages are submitted timely. Views of Responsible officials and corrective actions: The Municipality Administration is committed to complying with all submissions and has ensured the proper signing of an external auditors firm to comply with such requirements. Auditor Comments: 2 CFR 200.501 states that a non-federal entity that expends $750,000 or more in Federal awards during the non-Federal entity’s fiscal year must have a single audit conducted in accordance with 2 CFR 200.514. 2 CFR 200.508 states that it is the auditee responsibility to (1) prepare financial statements, including, the schedule of expenditures of Federal awards in accordance with 2 CFR 200.510, (2) promptly follow up and take corrective action on audit findings, including preparing a summary schedule of prior audit findings and a corrective plan, and (3) provide the auditor access to personnel, accounts, books, records, supporting documentation, and any other information needed for the auditor to perform the audit required by this part, among other things. Audit Status: In process of completion.
ALN 84.425 Elementary and Secondary School Emergency Fund Program United States Department of Education Passed through State of Louisiana Department of Education 2022 Funding Criteria: In accordance with 2 CFR Part 200.303(a), the School must establish, document, and maintain effective internal control over Federal awards that provide reasonable assurance that the recipient of subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In addition, 2 CFR 200.508(d) requires that the auditee ‘provide the auditor access to personnel, accounts, books, records, supporting documentation, and any other information needed for the auditor to perform the audit required by this part.’ Condition: The School did not maintain documentation for amounts submitted for reimbursement through the program. As a result, we were unable to obtain sufficient, appropriate audit evidence to support $111,006, or approximately 25%, of the total expenditures reimbursed under the Education Stabilization Fund during the year ended June 30, 2022. Thus, we were unable to form a conclusion on the School’s compliance with direct and material requirements for a material portion of Federal award expenditures. Cause: The change in key finance department personnel caused misplacement of some of the documentation supporting the program expenditures. Effect: Amounts could be reimbursed that are not properly supported and the federal agency could request repayment of the unsupported reimbursement amounts. Questioned Costs: None Recommendation: We recommend that the School revise and implement controls to ensure consistent maintenance of all supporting documentation even if there are changes in personnel. Management Response: See corrective action plan on page 33.
ALN 84.425 Elementary and Secondary School Emergency Fund Program United States Department of Education Passed through State of Louisiana Department of Education 2022 Funding Criteria: In accordance with 2 CFR Part 200.303(a), the School must establish, document, and maintain effective internal control over Federal awards that provide reasonable assurance that the recipient of subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In addition, 2 CFR 200.508(d) requires that the auditee ‘provide the auditor access to personnel, accounts, books, records, supporting documentation, and any other information needed for the auditor to perform the audit required by this part.’ Condition: The School did not maintain documentation for amounts submitted for reimbursement through the program. As a result, we were unable to obtain sufficient, appropriate audit evidence to support $111,006, or approximately 25%, of the total expenditures reimbursed under the Education Stabilization Fund during the year ended June 30, 2022. Thus, we were unable to form a conclusion on the School’s compliance with direct and material requirements for a material portion of Federal award expenditures. Cause: The change in key finance department personnel caused misplacement of some of the documentation supporting the program expenditures. Effect: Amounts could be reimbursed that are not properly supported and the federal agency could request repayment of the unsupported reimbursement amounts. Questioned Costs: None Recommendation: We recommend that the School revise and implement controls to ensure consistent maintenance of all supporting documentation even if there are changes in personnel. Management Response: See corrective action plan on page 33.
ALN 84.425 Elementary and Secondary School Emergency Fund Program United States Department of Education Passed through State of Louisiana Department of Education 2022 Funding Criteria: In accordance with 2 CFR Part 200.303(a), the School must establish, document, and maintain effective internal control over Federal awards that provide reasonable assurance that the recipient of subrecipient is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. In addition, 2 CFR 200.508(d) requires that the auditee ‘provide the auditor access to personnel, accounts, books, records, supporting documentation, and any other information needed for the auditor to perform the audit required by this part.’ Condition: The School did not maintain documentation for amounts submitted for reimbursement through the program. As a result, we were unable to obtain sufficient, appropriate audit evidence to support $111,006, or approximately 25%, of the total expenditures reimbursed under the Education Stabilization Fund during the year ended June 30, 2022. Thus, we were unable to form a conclusion on the School’s compliance with direct and material requirements for a material portion of Federal award expenditures. Cause: The change in key finance department personnel caused misplacement of some of the documentation supporting the program expenditures. Effect: Amounts could be reimbursed that are not properly supported and the federal agency could request repayment of the unsupported reimbursement amounts. Questioned Costs: None Recommendation: We recommend that the School revise and implement controls to ensure consistent maintenance of all supporting documentation even if there are changes in personnel. Management Response: See corrective action plan on page 33.
Condition: During our review and reconciliation of the Schedule of Expenditures of Federal Awards (SEFA) as initially prepared by the County, we identified federal programs that were not listed accurately which resulted in federal expenditures being overstated stated by $2,412,977. • Expenditures reported on the SEFA for ALN 16.607 - Bulletproof Vest Partnership Program were $36,810. Actual federal expenditures obtained from the County’s records confirm $0 expended for a variance of $36,810. • Expenditures reported on the SEFA for ALN 21.019 - Coronavirus Relief Fund were $2,376,264. Actual federal expenditures obtained from the County’s records confirm $0 expended for a variance of $2,376,264. Expenditures reported on the SEFA for ALN 97.042 - Emergency Management Performance Grants were $24,864. Actual federal expenditures obtained from the County’s records confirm $24,961 expended for a variance of ($97). Additionally, the County failed to present $500,000 in subrecipient expenditures on the SEFA for ALN 21.027 - Coronavirus State and Local Fiscal Recovery Funds. Cause of Condition: Policies and procedures have not been designed and implemented to ensure accurate reporting of expenditures for all federal awards. Effect of Condition: This condition resulted in inaccurate recording of the federal expenditures on the SEFA. Recommendation: OSAI recommends county officials and department heads gain an understanding of federal programs awarded to Rogers County. Internal control procedures should be designed and implemented to ensure accurate reporting of expenditures on the SEFA and to ensure compliance with federal requirements. The Board of County Commissioners (BOCC) should review and approve the SEFA in an open meeting. Management Response: Board of County Commissioners: The Board of County Commissioners is responsible for the overall fiscal concerns of the county. See OKLA. STAT. Title 19, § 345. The Board of County Commissioners, with the cooperation and participation of all elected officials, reviews, develops and implements policies and procedures to create a strong internal control environment. Additionally, the Board of County Commissioners conducts meetings with all elected officials and officers responsible for the receipt and/or expenditure of county funds. These meetings address fiscal matters, including but not limited to, policy discussions and implementation, financial reports, budget oversight, SEFA reporting, and legal compliance. Policies and procedures, combined with fiscal oversight meetings, are intended to: 1) prevent or detect material misstatements in the financial statements; 2) prevent or detect fraud within the county; 3) increase communication between the Board of County Commissioners and those elected officials and officers responsible for the receipt and/or expenditure of public funds; 4) provide oversight over the fiscal concerns of the county; 5) identify and address risks related to financial reporting; 6) ensure the accuracy of Rogers County’s financial statements, Estimate of Needs, and the SEFA; and 7) ensure compliance with all applicable federal and state laws, regulations, and/or codes. The Board of County Commissioners, with the cooperation of all elected officials and officers responsible for the receipt or expenditure of federal funds, will evaluate the processes and procedures currently in place to ensure the accuracy of SEFA reporting and detect potential inaccuracies and/or misstatements. Criteria: 2 CFR § 200.303(a) Internal Controls reads as follows: The non-Federal entity must: 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). 2 CFR § 200.508(b) Auditee responsibilities reads as follows: The auditee must: Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. 2 CFR § 200.510(b) Financial statements reads, in part, as follows: 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. Further, GAO Standards – Section 2 – Objectives of an Entity - OV2.23 states in part: Compliance Objectives Management conducts activities in accordance with applicable laws and regulations. As part of specifying compliance objectives, the entity determines which laws and regulations apply to the entity. Management is expected to set objectives that incorporate these requirements.
Criteria: CFR Part 200.508 Auditee Responsibilities state that the auditee must prepare the schedule of expenditures of federal awards. The information contained in the schedule of expenditures of federal awards should be reconciled to the underlying accounting and other records used to prepare financial statements, such that it is a fairly stated representation of federal awards expended by their respective federal agency and CFDA number. Condition: The amount of expenditures reported for the HS/EHS program on the schedule of expenditures of federal awards had various offsetting variances, netting to total misstatement that was not considered material to the overall financial statements or to the major federal program. Individually, improper expenditures included were depreciation, expenditures covered by program income, and allocation of a workers compensation refund received to offset workers compensation expenditures. Expenditures improperly excluded were current program capital expenditures and a payroll for a pay period in which the payroll was voided and re-issued, but the re-issued payroll was excluded from the final payroll expenditures reported for the major program. Cause: The Organization does not have effective internal control processes or procedures over the preparation of the schedule of expenditures of federal awards. The Organization did not reconcile the expenditures reported on the schedule to the relevant and complete costs and grant amounts drawn down as reported on the general ledger. Effect or Potential Effect: Potential understatement or overstatement of expenditures could exist in the schedule of expenditures of federal awards and not be detected and corrected. Questioned Cost: None. Repeat of a Prior-Year Finding: No. Recommendation: The Organization should establish policies and procedures to reconcile amounts reported in the financial statements and on the schedule of expenditures of federal awards in a timely manner after the period-end. Accounting personnel should take relevant training in the preparation of financial statements and the schedule of expenditures of federal awards, with particular focus on costs to be included and documentation to be retained in processing grant drawdowns and in preparing reconciliations of significant accounts and grants, grant financial reporting, and the reporting of amounts on the schedule of expenditures of federal awards. The Organization should also consider contracting with an external accounting firm to help oversee the year-end close, audit preparedness, as well as grant financial reporting. Organization's Response 2022 and Corrective Action Plan: The Organization concurs with the recommendation and had already released updated financial policies and procedures as of September 2022. Further revisions will be made in 2023 and include specific instructions for particular grants including federal and state. Additional training is needed for all levels of the fiscal team as well as for program managers to better understand the fiscal requirements of each grant. It is acknowledged that the fiscal team must be expanded and restructured and we have already started the process of recruiting a new CFO. The new CFO will be expected to consistently maintain a comprehensive matrix including all grant requirements. During this time we are seeking a consultant to help us establish better processes, controls and systems and assist until a permanent CFO is established. Other consultants may be obtained for supportive services as needed/recommended in the future. All applicable staff (fiscal and management) will be trained regarding procedures to review grant expenditures for compliance with terms of the grant, and to maintain sufficient records that reconcile to amounts reported as grant expenditures. Further, a new accounting system, Blackbaud, with enhanced cost recording, reporting and budgeting capabilities, has been approved by our Board of Directors to be implemented at the start of the next fiscal year. This implementation includes extensive training for fiscal and program staff. The fiscal committee and the Board will receive monthly updates on the progress being made in these areas. (Current responsible party: Renee Hungerford, Executive Director/CEO) Auditor's Response to Organization's Response 2022 and Corrective Plan: We have noted the Organization's response which appears sufficient and appropriate in the circumstances, and we further note the certain referenced steps already taken in discussion with management.
Criteria: CFR Part 200.508 Auditee Responsibilities state that the auditee must prepare the schedule of expenditures of federal awards. The information contained in the schedule of expenditures of federal awards should be reconciled to the underlying accounting and other records used to prepare financial statements, such that it is a fairly stated representation of federal awards expended by their respective federal agency and CFDA number. Condition: The amount of expenditures reported for the HS/EHS program on the schedule of expenditures of federal awards had various offsetting variances, netting to total misstatement that was not considered material to the overall financial statements or to the major federal program. Individually, improper expenditures included were depreciation, expenditures covered by program income, and allocation of a workers compensation refund received to offset workers compensation expenditures. Expenditures improperly excluded were current program capital expenditures and a payroll for a pay period in which the payroll was voided and re-issued, but the re-issued payroll was excluded from the final payroll expenditures reported for the major program. Cause: The Organization does not have effective internal control processes or procedures over the preparation of the schedule of expenditures of federal awards. The Organization did not reconcile the expenditures reported on the schedule to the relevant and complete costs and grant amounts drawn down as reported on the general ledger. Effect or Potential Effect: Potential understatement or overstatement of expenditures could exist in the schedule of expenditures of federal awards and not be detected and corrected. Questioned Cost: None. Repeat of a Prior-Year Finding: No. Recommendation: The Organization should establish policies and procedures to reconcile amounts reported in the financial statements and on the schedule of expenditures of federal awards in a timely manner after the period-end. Accounting personnel should take relevant training in the preparation of financial statements and the schedule of expenditures of federal awards, with particular focus on costs to be included and documentation to be retained in processing grant drawdowns and in preparing reconciliations of significant accounts and grants, grant financial reporting, and the reporting of amounts on the schedule of expenditures of federal awards. The Organization should also consider contracting with an external accounting firm to help oversee the year-end close, audit preparedness, as well as grant financial reporting. Organization's Response 2022 and Corrective Action Plan: The Organization concurs with the recommendation and had already released updated financial policies and procedures as of September 2022. Further revisions will be made in 2023 and include specific instructions for particular grants including federal and state. Additional training is needed for all levels of the fiscal team as well as for program managers to better understand the fiscal requirements of each grant. It is acknowledged that the fiscal team must be expanded and restructured and we have already started the process of recruiting a new CFO. The new CFO will be expected to consistently maintain a comprehensive matrix including all grant requirements. During this time we are seeking a consultant to help us establish better processes, controls and systems and assist until a permanent CFO is established. Other consultants may be obtained for supportive services as needed/recommended in the future. All applicable staff (fiscal and management) will be trained regarding procedures to review grant expenditures for compliance with terms of the grant, and to maintain sufficient records that reconcile to amounts reported as grant expenditures. Further, a new accounting system, Blackbaud, with enhanced cost recording, reporting and budgeting capabilities, has been approved by our Board of Directors to be implemented at the start of the next fiscal year. This implementation includes extensive training for fiscal and program staff. The fiscal committee and the Board will receive monthly updates on the progress being made in these areas. (Current responsible party: Renee Hungerford, Executive Director/CEO) Auditor's Response to Organization's Response 2022 and Corrective Plan: We have noted the Organization's response which appears sufficient and appropriate in the circumstances, and we further note the certain referenced steps already taken in discussion with management.
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of AccountsFederal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1524963 (11/1/2015 – 9/30/2021), 1812860 (9/1/2018 – 8/31/2020) Material Weakness in Internal Control over Compliance, Material Noncompliance Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,822 in total. Assistance listing number 47.076. Of this amount, $62,403 applies to award ID 1505278, which was closed before 1/1/2021 and did not have expenses or drawdowns in 2021 but by the end of 2018 had $138,034 in federal funding provided to AAPT and $75,631 of reimbursable expenses. AAPT had not refunded the overpayment, such as by applying this $62,403 as a reduction in federal reimbursements drawn during 2021. The remaining amounts of $10,112 and $8,307 relate to award IDs 1812860, and 1524963, respectively, and were calculated in the same manner. The period of performance for award ID 1812860 ended on 8/31/2020. The period of performance for award ID 1524963 ended on 9/30/2021. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 10/15/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of AccountsFederal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1524963 (11/1/2015 – 9/30/2021), 1812860 (9/1/2018 – 8/31/2020) Material Weakness in Internal Control over Compliance, Material Noncompliance Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,822 in total. Assistance listing number 47.076. Of this amount, $62,403 applies to award ID 1505278, which was closed before 1/1/2021 and did not have expenses or drawdowns in 2021 but by the end of 2018 had $138,034 in federal funding provided to AAPT and $75,631 of reimbursable expenses. AAPT had not refunded the overpayment, such as by applying this $62,403 as a reduction in federal reimbursements drawn during 2021. The remaining amounts of $10,112 and $8,307 relate to award IDs 1812860, and 1524963, respectively, and were calculated in the same manner. The period of performance for award ID 1812860 ended on 8/31/2020. The period of performance for award ID 1524963 ended on 9/30/2021. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 10/15/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of AccountsFederal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1524963 (11/1/2015 – 9/30/2021), 1812860 (9/1/2018 – 8/31/2020) Material Weakness in Internal Control over Compliance, Material Noncompliance Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,822 in total. Assistance listing number 47.076. Of this amount, $62,403 applies to award ID 1505278, which was closed before 1/1/2021 and did not have expenses or drawdowns in 2021 but by the end of 2018 had $138,034 in federal funding provided to AAPT and $75,631 of reimbursable expenses. AAPT had not refunded the overpayment, such as by applying this $62,403 as a reduction in federal reimbursements drawn during 2021. The remaining amounts of $10,112 and $8,307 relate to award IDs 1812860, and 1524963, respectively, and were calculated in the same manner. The period of performance for award ID 1812860 ended on 8/31/2020. The period of performance for award ID 1524963 ended on 9/30/2021. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 10/15/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of AccountsFederal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1524963 (11/1/2015 – 9/30/2021), 1812860 (9/1/2018 – 8/31/2020) Material Weakness in Internal Control over Compliance, Material Noncompliance Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,822 in total. Assistance listing number 47.076. Of this amount, $62,403 applies to award ID 1505278, which was closed before 1/1/2021 and did not have expenses or drawdowns in 2021 but by the end of 2018 had $138,034 in federal funding provided to AAPT and $75,631 of reimbursable expenses. AAPT had not refunded the overpayment, such as by applying this $62,403 as a reduction in federal reimbursements drawn during 2021. The remaining amounts of $10,112 and $8,307 relate to award IDs 1812860, and 1524963, respectively, and were calculated in the same manner. The period of performance for award ID 1812860 ended on 8/31/2020. The period of performance for award ID 1524963 ended on 9/30/2021. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 10/15/2024 Responsible Official: Michael Brosnan, CFO
Finding # 2021-002 Program: Various, including AL 97.036 – Disaster Grants - Public Assistance (Presidentially Declared Disasters) – Reporting Grant Number & Year: Various Federal Grantor Agency: Various, including U.S. Department of Homeland Security Pass-Through Entity: Various, including Nebraska Military Department Criteria: Title 2 of the U.S. Code of Federal Regulations (CFR) § 200.512(a)(1) (January 1, 2021) states the following: The audit must be completed and the data collection form described in paragraph (b) of this section and reporting package described in paragraph (c) of this section must be submitted 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. Title 2 CFR § 200.508 (January 1, 2021) 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. Title 2 CFR § 200.303 (January 1, 2021) 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 audit is completed and submitted to the Federal Audit Clearinghouse within the time frame required by Title 2 CFR § 200.512. Condition: Garfield County did not have adequate procedures in place to monitor Federal expenditures and ensure a Single Audit was completed and submitted to the Federal Audit Clearinghouse in accordance with Title 2 CFR § 200.512. Consequently, the County had a basic financial statement audit completed for the fiscal year ending June 30, 2021, which was issued on September 15, 2021, 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, 2022 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, 2021. Repeat Finding: No Questioned Costs: None Statistical Sample: No Cause: Overall lack of knowledge and experience by County personnel related to Federal reporting and compliance requirements; misunderstanding of when expenditures for AL # 97.036 were required to be reported on the Schedule of Expenditures of Federal Awards. Effect: Noncompliance with Federal regulations, which could lead to Federal sanctions, and Single Audits not being completed when required. Recommendation: We recommend the County obtain necessary training related to Federal reporting requirements, establish written procedures for closely monitoring Federal expenditures, 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 plans to make sure and have proper education and obtain training to ensure County personnel are aware of Federal reporting requirements and understanding of the schedule of expenditures of Federal awards.
PASS-THROUGH GRANTOR: Oklahoma Department of Emergency Management; Oklahoma Office of Management and Enterprise Services FEDERAL AGENCY: U.S. Department of Treasury ASSISTANCE LISTING: 21.019 FEDERAL PROGRAM NAME: Coronavirus Relief Fund FEDERAL AWARD NUMBER: Oklahoma CARES PPE; SA-2242 FEDERAL AWARD YEAR: 2020 CONTROL CATEGORY: Activities Allowed or Unallowed; Allowable Costs/Costs Principles; and Period of Performance QUESTIONED COSTS: $-0- Condition: During our review of the County’s fiscal year 2021 Schedule of Expenditures of Federal Awards (SEFA), we identified federal programs that were not listed accurately on the County’s SEFA resulting in federal expenditures being understated by $1,175,736. The following misstatements were noted: • The actual expenditures for National Wildlife Refuge Fund, ALN 15.659, were $6,767, the County reported $12,071, which overstated expenditures by $5,304. • The actual expenditures for Highway Planning and Construction, ALN 20.205 were $9,226, the County reported $0, which understated expenditures by $9,226. • The actual expenditures for Coronavirus Relief Fund, ALN 21.019, were $1,269,227, the County reported $0, which understated expenditures by $1,269,227. • The actual expenditures for Emergency Management Performance Grants, ALN 97.042 were $25,000, the County reported $30,183, which overstated expenditures by $5,183. Additionally, the County reported $92,231 in expenditures for various grants that were not federal grants of the County, overstating federal expenditures by $92,230. Furthermore, the County did not prepare Notes to the SEFA. Cause of Condition: Policies and procedures have not been designed and implemented to ensure an accurate reporting of federal expenditures and that the Notes to the SEFA are prepared as required. Effect of Condition: These conditions resulted in the material misstatement of the SEFA and the Notes to the SEFA. Recommendation: OSAI recommends County Officials and department heads gain an understanding of federal programs awarded to Okmulgee County. Internal control procedures should be designed and implemented to ensure an accurate reporting of expenditures on the SEFA, the Notes to the SEFA are prepared, and compliance with all applicable federal requirements. Management Response: District 1 County Commissioner: My tenure as an Okmulgee County Commissioner began, October 3, 2022. I will work with the other elected County Officials to review/follow OSAI recommendations. District 2 County Commissioner: I will work with the other elected officials to ensure that the federal revenues and expenditures are reported correctly on the SEFA by requiring all offices that receive federal grants to prepare a SEFA for their individual office and provide that SEFA and all supporting documentation for revenues and expenditures reported to the designated compiler of the SEFA. I will also work with the other elected officials to ensure the notes to the SEFA are prepared and that the SEFA and the Notes to the SEFA are reviewed for accuracy prior to being approved by the BOCC and presented to OSAI. District 3 County Commissioner: I took office January 3, 2023, I will work with the other County Officials and departments heads to gain an understanding of federal programs awarded to Okmulgee County and to design and implement internal control procedures to ensure an accurate reporting of revenues and expenditures on the SEFA, that the notes to the SEFA are prepared, and compliance with all applicable federal requirements. County Clerk: I did not take office until April, 2022; however, I will work with the other elected officials to get a better understanding of the grants that are being reported and establish and maintain an effective internal control over the SEFA. County Treasurer: I did not take office until July 3, 2023. However, I will work with the other elected officials to ensure compliance with applicable federal requirements and to ensure the SEFA and the Notes to the SEFA are timely prepared and reviewed for accuracy. County Sheriff: I will continue to work with the other elected officials to ensure the SEFA is accurately and timely prepared. Criteria: 2 CFR § 200.303(a) Internal Controls reads as follows: The non-Federal entity must: 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). 2 CFR § 200.508(b) Auditee responsibilities reads as follows: The auditee must: Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. 2 CFR § 200.510 (b) Financial statements reads as follows: 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. [….] 2 CFR § 200.510 (b) 6 provides that the auditee must also “include notes that describe that significant accounting policies used in preparing the schedule…” Additionally, GAO Standards – Section 2 – Establishing an Effective Internal Control System – OV2.23 states in part: Objectives of an Entity – Compliance Objectives Management conducts activities in accordance with applicable laws and regulations. As part of specifying compliance objectives, the entity determines which laws and regulations apply to the entity. Management is expected to set objectives that incorporate these requirements. Furthermore, GAO Standards – Principle 6 – Define Objectives and Risk Tolerances – 6.05 states: Definitions of Objectives Management considers external requirements and internal expectations when defining objectives to enable the design of internal control. Legislators, regulators, and standard-setting bodies set external requirements by establishing the laws, regulations, and standards with which the entity is required to comply. Management identifies, understands, and incorporates these requirements into the entity’s objectives. Management sets internal expectations and requirements through the established standards of conduct, oversight structure, organizational structure, and expectations of competence as part of the control environment.
PASS-THROUGH GRANTOR: Oklahoma Department of Emergency Management; Oklahoma Office of Management and Enterprise Services FEDERAL AGENCY: U.S. Department of Treasury ASSISTANCE LISTING: 21.019 FEDERAL PROGRAM NAME: Coronavirus Relief Fund FEDERAL AWARD NUMBER: Oklahoma CARES PPE; SA-2242 FEDERAL AWARD YEAR: 2020 CONTROL CATEGORY: Activities Allowed or Unallowed; Allowable Costs/Costs Principles; and Period of Performance QUESTIONED COSTS: $-0- Condition: During our review of the County’s fiscal year 2021 Schedule of Expenditures of Federal Awards (SEFA), we identified federal programs that were not listed accurately on the County’s SEFA resulting in federal expenditures being understated by $1,175,736. The following misstatements were noted: • The actual expenditures for National Wildlife Refuge Fund, ALN 15.659, were $6,767, the County reported $12,071, which overstated expenditures by $5,304. • The actual expenditures for Highway Planning and Construction, ALN 20.205 were $9,226, the County reported $0, which understated expenditures by $9,226. • The actual expenditures for Coronavirus Relief Fund, ALN 21.019, were $1,269,227, the County reported $0, which understated expenditures by $1,269,227. • The actual expenditures for Emergency Management Performance Grants, ALN 97.042 were $25,000, the County reported $30,183, which overstated expenditures by $5,183. Additionally, the County reported $92,231 in expenditures for various grants that were not federal grants of the County, overstating federal expenditures by $92,230. Furthermore, the County did not prepare Notes to the SEFA. Cause of Condition: Policies and procedures have not been designed and implemented to ensure an accurate reporting of federal expenditures and that the Notes to the SEFA are prepared as required. Effect of Condition: These conditions resulted in the material misstatement of the SEFA and the Notes to the SEFA. Recommendation: OSAI recommends County Officials and department heads gain an understanding of federal programs awarded to Okmulgee County. Internal control procedures should be designed and implemented to ensure an accurate reporting of expenditures on the SEFA, the Notes to the SEFA are prepared, and compliance with all applicable federal requirements. Management Response: District 1 County Commissioner: My tenure as an Okmulgee County Commissioner began, October 3, 2022. I will work with the other elected County Officials to review/follow OSAI recommendations. District 2 County Commissioner: I will work with the other elected officials to ensure that the federal revenues and expenditures are reported correctly on the SEFA by requiring all offices that receive federal grants to prepare a SEFA for their individual office and provide that SEFA and all supporting documentation for revenues and expenditures reported to the designated compiler of the SEFA. I will also work with the other elected officials to ensure the notes to the SEFA are prepared and that the SEFA and the Notes to the SEFA are reviewed for accuracy prior to being approved by the BOCC and presented to OSAI. District 3 County Commissioner: I took office January 3, 2023, I will work with the other County Officials and departments heads to gain an understanding of federal programs awarded to Okmulgee County and to design and implement internal control procedures to ensure an accurate reporting of revenues and expenditures on the SEFA, that the notes to the SEFA are prepared, and compliance with all applicable federal requirements. County Clerk: I did not take office until April, 2022; however, I will work with the other elected officials to get a better understanding of the grants that are being reported and establish and maintain an effective internal control over the SEFA. County Treasurer: I did not take office until July 3, 2023. However, I will work with the other elected officials to ensure compliance with applicable federal requirements and to ensure the SEFA and the Notes to the SEFA are timely prepared and reviewed for accuracy. County Sheriff: I will continue to work with the other elected officials to ensure the SEFA is accurately and timely prepared. Criteria: 2 CFR § 200.303(a) Internal Controls reads as follows: The non-Federal entity must: 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). 2 CFR § 200.508(b) Auditee responsibilities reads as follows: The auditee must: Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. 2 CFR § 200.510 (b) Financial statements reads as follows: 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. [….] 2 CFR § 200.510 (b) 6 provides that the auditee must also “include notes that describe that significant accounting policies used in preparing the schedule…” Additionally, GAO Standards – Section 2 – Establishing an Effective Internal Control System – OV2.23 states in part: Objectives of an Entity – Compliance Objectives Management conducts activities in accordance with applicable laws and regulations. As part of specifying compliance objectives, the entity determines which laws and regulations apply to the entity. Management is expected to set objectives that incorporate these requirements. Furthermore, GAO Standards – Principle 6 – Define Objectives and Risk Tolerances – 6.05 states: Definitions of Objectives Management considers external requirements and internal expectations when defining objectives to enable the design of internal control. Legislators, regulators, and standard-setting bodies set external requirements by establishing the laws, regulations, and standards with which the entity is required to comply. Management identifies, understands, and incorporates these requirements into the entity’s objectives. Management sets internal expectations and requirements through the established standards of conduct, oversight structure, organizational structure, and expectations of competence as part of the control environment.