Reference Number: 2021-002 Type of Finding: Material Weakness and Instance of Noncompliance Criteria Title 2 - Grants and Agreements. Subtitle A - Office of Management and Budget Guidance for Grants and Agreements. Chapter II - Office of Management and Budget Guidance. Part 200 - Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart D - Post Federal Award Requirements. Standards for Financial and Program Management. §200.303 Internal controls (2 CFR 200.303): The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Title 2 - Grants and Agreements. Subtitle A - Office of Management and Budget Guidance for Grants and Agreements. Chapter II - Office of Management and Budget Guidance. Part 200 - Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Subpart F - Audit Requirements. §200.510 Financial statements (2 CFR 200.510): (b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listings Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. Condition The State of California (State) has a decentralized financial reporting process, which requires State agencies and departments to provide specific financial information to the Department of Finance (Finance) in order to annually compile the Schedule of Expenditures of Federal Awards (Schedule). In its effort to more efficiently and accurately prepare the Schedule in accordance with the requirements of 2 CFR 200.510, Finance developed the Single Audit Expenditures Reporting Database (Database) to include all relevant data fields necessary to compile and produce the Schedule. Finance also created a Single Audit Database User Manual, which provides specific guidance to users for accessing and navigating through the database. Departments are given access to the centralized Database by Finance in order to upload and report federal award information for all federal award programs which they administer. The California Department of Public Health (Public Health) failed to include $479,996,082 of federal expenditures and $367,405,431 of subrecipient expenditures for the Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) program (ALN No. 93.323) in the Database, which Finance uses to prepare the State’s annual Schedule. The error resulted in an additional major program that had to be audited in accordance with the Uniform Guidance and the State having to re-issue its federal compliance audit report for the fiscal year ended June 30, 2021. Cause Public Health entered into a Bona Fide Agent Designation arrangement with Public Health Foundation Enterprises, Inc., dba Heluna Health, for the submission of a grant application under the State of California’s eligibility in lieu of a direct State application for the U.S. Department of Health and Human Services (HHS), Centers for Disease Control and Prevention (CDC) funding opportunity: Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Cooperative Agreement. Subsequent to the bona fide agent arrangement, Public Health entered into a separate subrecipient agreement with Heluna Health on March 2, 2021, to provide Heluna Health with certain services related to the performance of its obligations under the ELC program grant award received from HHS. Since Public Health is typically not a subrecipient of federal awards and the accounting control for ELC program revenues and expenditures was established within the State’s General Fund rather than the Federal Trust Fund, which is State standard operating procedure, Public Health failed to identify and report the $479,996,082 of federal expenditures in the Schedule. Effect Because of the ELC program’s inclusion in the State’s Schedule for the fiscal year ended June 30, 2021, the ELC program had to be audited as a major program under requirements of the Uniform Guidance and the State’s federal compliance report had to be reissued. Questioned Costs No questioned costs were identified. Recommendation When infrequent and unusual arrangements occur impacting processes and procedures surrounding federal award programs, Public Health should ensure there is sufficient identification and understanding of the administrative and operational changes from standard operating procedures. Public Health should then design appropriate internal controls commensurate with such changes to ensure adherence to applicable laws and regulations. Views of Responsible Officials and Corrective Action Plan Management's response is reported in "Management's Response and Corrective Action Plan" included in a separate section at the end of this report.
Finding 2021-008 Improper Preparation of Schedule of Expenditures of Federal Awards U.S. Department of Health and Human Services COVID-19: HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund – Assistance Listing Number 93.461 Criteria: In accordance with 2 CFR 200 200.510(b), the auditee must prepare a SEFA for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Condition: The Corporation’s SEFA for the year ended June 30, 2021, was initially prepared without federal expenditures totaling $1,222,859 for the HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund, Assistance Listing number 93.461. Cause: The federal program expenditures for the HRSA COVID-19 Claims Reimbursement for the Uninsured Program and the COVID-19 Coverage Assistance Fund, Assistance Listing number 93.461, were omitted from the SEFA due to an oversight in the preparation of the SEFA. Effect: Improper reporting of federal expenditures resulted in a material error on the SEFA leading to inaccurate major program determination by the auditors. In this instance, the error did result in the identification of an additional major program. Questioned costs: None. Identification as a repeat finding, if applicable: 2020-005 Recommendation: We recommend the Corporation enhance the process and internal controls around the timely identification of federal awards and preparation of the SEFA to ensure accuracy and completeness of the SEFA. View of responsible officials of the auditee: Management agrees with the finding and recommendation.
Finding 2021-010 – Lack of Internal Controls Over 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 – Reimbursement 2020; 4530-DR-OK 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 audit, we identified federal programs that were not listed accurately on the County’s Schedule of Expenditures of Federal Awards (SEFA). Federal expenditures were understated by $532,307. The following misstatements were noted: Expenditures: • The actual expenditures for Coronavirus Relief Fund, ALN 21.019, were $774,579, the County reported $241,966, which understated expenditures by $532,613. • The actual expenditures for Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027, were $2,437, the County reported $2,807, which overstated expenditures by $370. • The actual expenditures for FEMA – Public Assistance DR-4438, Disaster Grants – Public Assistance (Presidentially Declared Disasters), ALN 97.036, were $$60,394, the County reported $46,703, which understated expenditures by $13,691. • The actual expenditures of FEMA – Category B DR-4438 ALN 97.067 were $0, the County reported $8,342, which overstated expenditures by $8,342. • The actual expenditures for FEMA – Public Assistance OEM DR – 4453 ALN 97.036 were $0, the County reported $870, which overstated expenditures by $870. • The actual expenditures for COVID-19 FEMA-Public Assistance DR-4530, Disaster Grants – Public Assistance (Presidentially Declared Disasters), ALN 97.036, were $28,063, the County reported $21,047, which understated expenditures by $7,016. • The actual expenditures for Emergency Management Performance Grant, ALN 97.042, were $45,000, the County reported $56,250, which overstated expenditures by $11,250. • The actual expenditures for Fire Management Assistance Grand, ALN 97.046, were $0, the County reported $181, which overstated expenditures by $181. Cause of Condition: Policies and procedures have not been designed and implemented to ensure an accurate reporting of expenditures for federal awards. Effect of Condition: These conditions resulted in the misstatement of the expenditures reported on the County’s SEFA and could increase the potential for material noncompliance. Recommendation: OSAI recommends county officials and department heads gain an understanding of federal programs awarded to Washington 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. Management Response: District 1 County Commissioner: Not by way of excuse, but truly in response, the Federal programs associated with the COVID response were unnecessarily arduous and created confusion at all levels of government. While the monetary response was accepted, the premise of these programs was nothing more than an administrative shell game. From the outset of the response, guidance was termed as “interim”, then “final interim” and finally, “final” (redundancy intentional). The intent of our national level leadership became more apparent as these programs progressed with each iteration of programming being reliant on returned funds from the previous. Without grandstanding, I will simply say that no entity, regardless of their planning with these programs, will be found as fully compliant. As these programs have a sunset in the near term, I suspect these findings will disappear. District 2 County Commissioner: I was not in office at this time; however, I will work with other elected officials, county officials and department heads to ensure there is an understanding of federal programs awarded to Washington County, and the use of internal control procedures designed and implemented to ensure accurate reporting of expenditures and revenues on the SEFA and to ensure compliance with federal requirements. District 3 County Commissioner: These programs are temporary and difficult to navigate through. I will continue to press staff to report effectively as possible and to be responsive to specific requests that are made. County Clerk: I will work with the other Elected Officials to gain a better understanding of federal programs that are awarded to our County. I will work with the other offices to implement internal controls to ensure accurate reporting on the SEFA. County Sheriff: I have and will continue to work toward compliance in these areas of SEFA. I will continue to work with the other elected officials to gain proper understanding of Federal Programs and Requirements. Criteria: Title 2 CFR 200 § 200.210(a)(b) Financial Statements reads as follows: (a) Financial statements. The auditee must prepare financial statements that reflect its financial position, results of operations or changes in net assets, and where appropriate, cash flows for the fiscal year audited. The financial statements must be for the same organizational unit and fiscal year that is chosen to meet the requirements of this part. However, non-Federal entity-wide financial statements may also include departments, agencies, and other organizational units that have separate audits in accordance with §200.514 Scope of audit, paragraph (a) and prepare separate financial statements. (b) Schedule of expenditures of federal awards. The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statement, which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. 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. [….] 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 standardsetting 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.
2 CFR Subpart F § 200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the College’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the Schedule must: (1) List individual federal programs by Federal agency. (2) For federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total federal awards expended for each individual federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each federal program. (5) For loan or loan guarantee programs described in § 200.502 basis for determining federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the Schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The College’s internal control procedures did not identify $839,935 of expenses in the Schedule of Expenditures of Federal Awards related to the CARES Act grant. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. We recommend that management continue to analyze the federal revenues and expenditures and include them in the proper period for audit.
2 CFR Subpart F § 200.510(b) requires the auditee prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the College’s financial statements which must include the total federal awards expended as determined in accordance with § 200.502. At a minimum, the Schedule must: (1) List individual federal programs by Federal agency. (2) For federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total federal awards expended for each individual federal program and the ALN number or other identifying number when the ALN information is not available. (4) Include the total amount provided to subrecipients from each federal program. (5) For loan or loan guarantee programs described in § 200.502 basis for determining federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the Schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in § 200.414 Indirect (F&A) costs. The College’s internal control procedures did not identify $839,935 of expenses in the Schedule of Expenditures of Federal Awards related to the CARES Act grant. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. We recommend that management continue to analyze the federal revenues and expenditures and include them in the proper period for audit.
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 YEAR: 2021 CONTROL CATEGORY: Activities Allowed or Unallowed; Allowable Costs/Costs Principles; and Period of Performance QUESTIONED COSTS: $-0- Condition: During our review and reconciliation of the SEFA, as initially prepared by the County, we identified federal programs that were not reported accurately. These errors resulted in expenditures being understated by $3,828,046. 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 expenditures on the SEFA and could increase the potential for material noncompliance. 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 an accurate reporting of expenditures on the SEFA and to ensure compliance with federal requirements. Management Response: Board of County Commissioners: The BOCC is responsible for the overall fiscal concerns of the county. See OKLA. STAT. Title 19, § 345. The BOCC, 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 BOCC 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 BOCC 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, the SEFA; and 7) ensure compliance with all applicable federal and state laws, regulations, and/or codes. The BOCC is responsible for preparing the financial statements. See OKLA. STAT. Title 68, § 3002(A). At the end of fiscal year 2020, the BOCC chose not to renew the contract with the budget maker. Beginning in fiscal year 2021, the BOCC and the Rogers County Treasurer developed and implemented a plan for the preparation and presentation of the financial statements by the Rogers County Treasurer beginning in fiscal year 2021. The purpose of this plan was to increase communication, involvement and oversight regarding the County’s financial condition and for better accuracy and timeliness of the preparation and presentation of the financial statements. The BOCC, with the cooperation of all elected officials and officers responsible for the receipt or expenditure of county funds, will evaluate the processes and procedures currently in place to detect and identify material misstatements in Rogers County’s financial statements, detect fraud, and identify and address risks related to Rogers County’s financial reporting. Where deficiencies are identified, processes and procedures will be implemented to identify fraud, detect material misstatements in the financial statements, and address risks related to financial reporting. County Clerk: The County Clerk works with the BOCC and all elected officials to develop and implement policies and procedures to prevent material misstatements in Rogers County’s financial statements, detect fraud and identify and address risks related to Rogers County’s financial reporting. These policies are intended to ensure the accuracy of the County’s financial statements, Estimate of Needs, SEFA, and compliance with all applicable federal and state laws, regulations, and/or codes. The County Clerk will continue to perform the duties of her office in accordance with Oklahoma law. Where appropriate, the County Clerk will participate in the development and implementation of policies and procedures to prevent material misstatements in Rogers County’s financial statements, detect fraud and identify and address risks related to Rogers County’s financial reporting. County Treasurer: The County Treasurer was engaged to compile the SEFA report. Each department is responsible for reporting its own Federal revenues and expenditures. County Sheriff: The County Sheriff will work with the BOCC and all elected officials to develop and implement policies and procedures to ensure Rogers County’s SEFA is prepared timely and accurately. Criteria: 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. 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.
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 YEAR: 2021 CONTROL CATEGORY: Activities Allowed or Unallowed; Allowable Costs/Costs Principles; and Period of Performance QUESTIONED COSTS: $-0- Condition: During our review and reconciliation of the SEFA, as initially prepared by the County, we identified federal programs that were not reported accurately. These errors resulted in expenditures being understated by $3,828,046. 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 expenditures on the SEFA and could increase the potential for material noncompliance. 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 an accurate reporting of expenditures on the SEFA and to ensure compliance with federal requirements. Management Response: Board of County Commissioners: The BOCC is responsible for the overall fiscal concerns of the county. See OKLA. STAT. Title 19, § 345. The BOCC, 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 BOCC 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 BOCC 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, the SEFA; and 7) ensure compliance with all applicable federal and state laws, regulations, and/or codes. The BOCC is responsible for preparing the financial statements. See OKLA. STAT. Title 68, § 3002(A). At the end of fiscal year 2020, the BOCC chose not to renew the contract with the budget maker. Beginning in fiscal year 2021, the BOCC and the Rogers County Treasurer developed and implemented a plan for the preparation and presentation of the financial statements by the Rogers County Treasurer beginning in fiscal year 2021. The purpose of this plan was to increase communication, involvement and oversight regarding the County’s financial condition and for better accuracy and timeliness of the preparation and presentation of the financial statements. The BOCC, with the cooperation of all elected officials and officers responsible for the receipt or expenditure of county funds, will evaluate the processes and procedures currently in place to detect and identify material misstatements in Rogers County’s financial statements, detect fraud, and identify and address risks related to Rogers County’s financial reporting. Where deficiencies are identified, processes and procedures will be implemented to identify fraud, detect material misstatements in the financial statements, and address risks related to financial reporting. County Clerk: The County Clerk works with the BOCC and all elected officials to develop and implement policies and procedures to prevent material misstatements in Rogers County’s financial statements, detect fraud and identify and address risks related to Rogers County’s financial reporting. These policies are intended to ensure the accuracy of the County’s financial statements, Estimate of Needs, SEFA, and compliance with all applicable federal and state laws, regulations, and/or codes. The County Clerk will continue to perform the duties of her office in accordance with Oklahoma law. Where appropriate, the County Clerk will participate in the development and implementation of policies and procedures to prevent material misstatements in Rogers County’s financial statements, detect fraud and identify and address risks related to Rogers County’s financial reporting. County Treasurer: The County Treasurer was engaged to compile the SEFA report. Each department is responsible for reporting its own Federal revenues and expenditures. County Sheriff: The County Sheriff will work with the BOCC and all elected officials to develop and implement policies and procedures to ensure Rogers County’s SEFA is prepared timely and accurately. Criteria: 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. 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.
Finding 2021-004 – Internal Controls and Noncompliance Over the Schedule of Expenditures of Federal Awards (SEFA) PASS THROUGH GRANTOR: Oklahoma Office of Management and Enterprise Services FEDERAL AGENCY: U.S. Department of the Treasury ASSISTANCE LISTING: 21.019 FEDERAL PROGRAM NAME: Coronavirus Relief Fund FEDERAL AWARD YEAR: 2021 CONTROL CATEGORY: Activities Allowed or Unallowed; Allowable Costs/Cost Principles; Period of Performance QUESTIONED COSTS: $-0- 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 understated by $180,089. 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. This condition could result in the failure to identify Single Audit requirements. Recommendation: OSAI recommends county officials and department heads gain an understanding of federal programs awarded to Choctaw County. Internal control policies and procedures should be designed and implemented to ensure accurate reporting of expenditures on the SEFA and to ensure compliance with federal requirements. Management Response: Chairman of the Board of County Commissioners: We will adopt procedures and implement to ensure accurate reporting of expenditures on the SEFA and to ensure compliance with federal requirements. County Clerk: We will pay more attention to what is being put on SEFA schedule. County Treasurer: I will do my part in correcting this issue to make sure that all qualifying expenditures are reported accurately in the future. 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. Further, GAO Standards – Section 2 – Establishing an Effective Internal Control System - Objectives of an Entity - OV2.23 states in part: Compliance Objective 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.
Condition: The Bureau did not submit its Single Audit reporting package for the year ended June 30, 2021 to the Federal Audit Clearinghouse within the timeframe required by 2 CFR 200.512(a), submitting well after the nine-month deadline. Criteria: 2 CFR 200.512 requires recipients to submit the complete reporting package—including the financial statements and SEFA (200.510), summary schedule of prior audit findings (200.511), auditor’s reports (200.515), and corrective action plan (200.511(c))—to the FAC within 30 days of the auditor’s report or nine months after year-end. Context: While the Bureau filed timely for FY 2014–2015, it has repeatedly failed to meet filing deadlines since FY 2016; FY 2016 was submitted nearly two years late, FY 2017 was delayed but covered by FEMA administrative relief, and the reporting packages for FY 2018, FY 2019, and FY 2020 were submitted significantly past statutory limits. FY 2021 continued this pattern of late submission, indicating ineffective controls over the audit reporting timeline. Cause: The delay is related to systemic weaknesses in financial management and reporting processes described in Finding 2021-001, including the absence of an integrated financial system and excessive reliance on Excel spreadsheets, which hinder timely reconciliation, compilation, and audit preparation. Effect: Failure to comply with reporting deadlines may subject the Bureau to federal sanctions, including withholding or disallowance of indirect costs, suspension of funding until audit submission is complete, or termination of federal awards; repeated delinquency also undermines the Bureau’s credibility with federal agencies. Questioned Costs: None. Recommendation: Implement a formalized audit and reporting calendar to ensure required documents are compiled and ready for audit by March 31 each year, establish an integrated system supporting timely reporting, assign responsibility for monitoring the Single Audit submission timeline, and conduct periodic status reviews to ensure timely submission to the FAC under Uniform Guidance requirements. Management Response: See corrective action plan.
Assistance Listing Number, Federal Agency, and Program Name 21.019, U.S. Treasury, COVID 19 Coronavirus Relief Fund Federal Award Identification Number and Year 21.019 E20204557, 2020; E2020E4558, 2020 Pass through Entity 21.019 Michigan Department of Health and Human Services Finding Type Material weakness Repeat Finding No Criteria The Single Audit Act and Uniform Guidance requires a non federal entity that expends $750,000 or more of federal awards in a fiscal year to have a single or program specific audit. Additionally, 2 CFR §200.510(b) of Uniform Guidance requires an auditee to prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended. 2 CFR § 200.502 describes the basis for determining the timing of when Federal awards are deemed expended and therefore reportable on the schedule. Condition Controls in place were not sufficient to ensure the accuracy and completeness of the SEFA. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context During the fiscal year ended May 31, 2021, the Organization expended approximately $1.3 million of federal funding. The initial draft of the SEFA included the following inaccuracies: • ALN 21.019 (CRF) – The expenditures reported on the SEFA were understated by $706,921 The errors noted above have been corrected on the SEFA as of May 31, 2021. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate for the fiscal period under audit. The errors resulted in the understatement of federal expenditures as noted in the context above. Additionally, the understatement of federal expenditures on the SEFA resulted in the incorrect conclusion that federal activity was below $750,000 and therefore a single audit was not needed. Recommendation We recommend the Organization implement a process to ensure that the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan In order to assure the accurate classification of federal grant expenditures, the Federation staff implemented the following controls as part of their accounting review process: 1) The Senior Accountant responsible for grant accounting and the Senior Director of Finance will perform a complete review of all grant agreements, to determine whether the grants are funded with federal or state funds. 2) The quarterly workpapers will include a copy of the signed grant agreement, a current SEFA schedule, and a general ledger that correctly corresponds to the totals included on the included SEFA. 3) The staff will perform a quarterly review of the State of Michigan website (Michigan.gov/MDHHS) to confirm the funding sources of all existing grants.
Assistance Listing Number, Federal Agency, and Program Name 21.019, U.S. Treasury, COVID 19 Coronavirus Relief Fund Federal Award Identification Number and Year 21.019 E20204557, 2020; E2020E4558, 2020 Pass through Entity 21.019 Michigan Department of Health and Human Services Finding Type Material weakness Repeat Finding No Criteria The Single Audit Act and Uniform Guidance requires a non federal entity that expends $750,000 or more of federal awards in a fiscal year to have a single or program specific audit. Additionally, 2 CFR §200.510(b) of Uniform Guidance requires an auditee to prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended. 2 CFR § 200.502 describes the basis for determining the timing of when Federal awards are deemed expended and therefore reportable on the schedule. Condition Controls in place were not sufficient to ensure the accuracy and completeness of the SEFA. Questioned Costs None Identification of How Questioned Costs Were Computed N/A Context During the fiscal year ended May 31, 2021, the Organization expended approximately $1.3 million of federal funding. The initial draft of the SEFA included the following inaccuracies: • ALN 21.019 (CRF) – The expenditures reported on the SEFA were understated by $706,921 The errors noted above have been corrected on the SEFA as of May 31, 2021. Cause and Effect Controls in place did not ensure the SEFA was complete and accurate for the fiscal period under audit. The errors resulted in the understatement of federal expenditures as noted in the context above. Additionally, the understatement of federal expenditures on the SEFA resulted in the incorrect conclusion that federal activity was below $750,000 and therefore a single audit was not needed. Recommendation We recommend the Organization implement a process to ensure that the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan In order to assure the accurate classification of federal grant expenditures, the Federation staff implemented the following controls as part of their accounting review process: 1) The Senior Accountant responsible for grant accounting and the Senior Director of Finance will perform a complete review of all grant agreements, to determine whether the grants are funded with federal or state funds. 2) The quarterly workpapers will include a copy of the signed grant agreement, a current SEFA schedule, and a general ledger that correctly corresponds to the totals included on the included SEFA. 3) The staff will perform a quarterly review of the State of Michigan website (Michigan.gov/MDHHS) to confirm the funding sources of all existing grants.
Finding 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-003: Reconciliation of Accounts Federal 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: 1812860 (9/1/2018 – 8/31/2020), 1940925 (1/15/2020 – 12/31/2023) 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/2020. 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/2020, 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: $77,113 in total. Assistance listing number 47.076. Of this amount, $62,403 applies to award ID 1505278, which was closed before 1/1/2020 and did not have expenses or drawdowns in 2020 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 2020. The remaining amounts of $10,654 and $4,056 relate to award IDs 1812860, and 1940925, respectively, and were calculated in the same manner. The period of performance for award ID 1812860 ended on 8/31/2020. Award ID 1940925 was active through 12/31/2020. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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: October 15, 2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Federal 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: 1812860 (9/1/2018 – 8/31/2020), 1940925 (1/15/2020 – 12/31/2023) 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/2020. 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/2020, 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: $77,113 in total. Assistance listing number 47.076. Of this amount, $62,403 applies to award ID 1505278, which was closed before 1/1/2020 and did not have expenses or drawdowns in 2020 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 2020. The remaining amounts of $10,654 and $4,056 relate to award IDs 1812860, and 1940925, respectively, and were calculated in the same manner. The period of performance for award ID 1812860 ended on 8/31/2020. Award ID 1940925 was active through 12/31/2020. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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: October 15, 2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-001 Preparation of the Schedule Expenditures of Federal Awards – Material Weakness in Internal Control Over Compliance Program: U.S. Department of Health and Human Services HRSA COVID-19 Uninsured Program ALN 93.461 Award year: 2020 Criteria: The Uniform Guidance (2 CFR 200) Section 200.510 requires an auditee to “prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements [that]….at a minimum shall…list individual Federal programs by Federal agency…[and] provide total Federal awards expended for each individual Federal program and the Assistance Listing Number (ALN) number or other identifying number when the ALN information is not available.” In accordance with Uniform Guidance, Confluence Health (the Health System) is required to maintain a structure of internal control to ensure compliance with applicable reporting requirements. Condition/Cause: The Health System did not have sufficient controls to ensure the SEFA included all expenditures that qualified as an expenditure of a federal award during the period. Effect: The SEFA was revised to include $1,019,828 of expenditures related to ALN #93.461, HRSA COVID-19 Uninsured Program, which resulted in an additional major program and the reissuance of the 2020 reporting package. Questioned Costs: Not applicable. Context: Factors contributing to the condition included the high volume of activity related to new COVID-19 programs and the lack of understanding that the related payments represented grant expenditures from a Federal source that were required to be reported on the SEFA. Repeat Finding: Not applicable. Recommendation: We recommend the Health System develop and implement a review process through the year to ensure compliance with SEFA reporting requirements as outlined in the Uniform Guidance. Views of Responsible Officials: Processes will be put in place to compile the SEFA, reconcile to support, and perform a related review prior to audit. This will allow all grants from a Federal source to be identified and tracked, ensuring completeness.
Finding 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-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, 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/2020. 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/2020, 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: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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 2020-003: Reconciliation of Accounts Federal 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: 1812860 (9/1/2018 – 8/31/2020), 1940925 (1/15/2020 – 12/31/2023) 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/2020. 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/2020, 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: $77,113 in total. Assistance listing number 47.076. Of this amount, $62,403 applies to award ID 1505278, which was closed before 1/1/2020 and did not have expenses or drawdowns in 2020 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 2020. The remaining amounts of $10,654 and $4,056 relate to award IDs 1812860, and 1940925, respectively, and were calculated in the same manner. The period of performance for award ID 1812860 ended on 8/31/2020. Award ID 1940925 was active through 12/31/2020. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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: October 15, 2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Federal 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: 1812860 (9/1/2018 – 8/31/2020), 1940925 (1/15/2020 – 12/31/2023) 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/2020. 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/2020, 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: $77,113 in total. Assistance listing number 47.076. Of this amount, $62,403 applies to award ID 1505278, which was closed before 1/1/2020 and did not have expenses or drawdowns in 2020 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 2020. The remaining amounts of $10,654 and $4,056 relate to award IDs 1812860, and 1940925, respectively, and were calculated in the same manner. The period of performance for award ID 1812860 ended on 8/31/2020. Award ID 1940925 was active through 12/31/2020. Identification as a Repeat Finding, if Applicable: 2019-002 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 $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. 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: October 15, 2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-001 Preparation of the Schedule Expenditures of Federal Awards – Material Weakness in Internal Control Over Compliance Program: U.S. Department of Health and Human Services HRSA COVID-19 Uninsured Program ALN 93.461 Award year: 2020 Criteria: The Uniform Guidance (2 CFR 200) Section 200.510 requires an auditee to “prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements [that]….at a minimum shall…list individual Federal programs by Federal agency…[and] provide total Federal awards expended for each individual Federal program and the Assistance Listing Number (ALN) number or other identifying number when the ALN information is not available.” In accordance with Uniform Guidance, Confluence Health (the Health System) is required to maintain a structure of internal control to ensure compliance with applicable reporting requirements. Condition/Cause: The Health System did not have sufficient controls to ensure the SEFA included all expenditures that qualified as an expenditure of a federal award during the period. Effect: The SEFA was revised to include $1,019,828 of expenditures related to ALN #93.461, HRSA COVID-19 Uninsured Program, which resulted in an additional major program and the reissuance of the 2020 reporting package. Questioned Costs: Not applicable. Context: Factors contributing to the condition included the high volume of activity related to new COVID-19 programs and the lack of understanding that the related payments represented grant expenditures from a Federal source that were required to be reported on the SEFA. Repeat Finding: Not applicable. Recommendation: We recommend the Health System develop and implement a review process through the year to ensure compliance with SEFA reporting requirements as outlined in the Uniform Guidance. Views of Responsible Officials: Processes will be put in place to compile the SEFA, reconcile to support, and perform a related review prior to audit. This will allow all grants from a Federal source to be identified and tracked, ensuring completeness.
Finding 2020-007 Material Weakness in Internal Control over Compliance and Schedule of Expenditures of Federal Awards (SEFA) Preparation and Completeness Information on Federal Programs: Criteria: In accordance with 2 CFR §200.510(b) and §200.518(b), non-federal entities are required to prepare a complete and accurate Schedule of Expenditures of Federal Awards (SEFA) that properly reflects all federal awards expended during the fiscal year, including pass-through awards, and that reconciles to the underlying accounting records. Additionally, recipients are required to maintain adequate documentation to demonstrate compliance with federal program requirements. Conditions: During audit testing of the (SEFA) for the year ended December 31, 2020, the following errors related to the preparation of the SEFA were noted: 1) A direct program federal award under CFDA Number 93.498, COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distributions, administered by the U.S. Department of Health and Human Services was omitted from the SEFA. As a result, federal expenditures of $54,674 related to this grant were not initially reported and were subsequently added to the SEFA. Aside from this omission, the Center was unable to provide supporting documentation for acceptance of the grants terms and conditions and use of the funds for allowable COVID-related expenses or lost revenues. Section III – Federal Awards Findings and Questioned Costs (Continued) A. Current Year Findings and Questioned Costs – Major Federal Award Program Audit (Continued) Finding 2020-007 Material Weakness in Internal Control over Compliance and Schedule of Expenditures of Federal Awards (SEFA) Preparation and Completeness (Continued) Conditions (Continued): 2) A pass through federal award under CFDA Number 93.426 (Health Centers Program), administered by the Hawaii Primary Care Association (HPCA), was omitted from the SEFA. As a result, federal expenditures of $31,000 related to this grant were not initially reported and were subsequently added to the SEFA. 3) For the Coronavirus Relief Fund award (CFDA 21.019) under the U.S. Department of the Treasury, the SEFA initially reported total expenditures of $417,676. However, when auditors requested supporting detail, the detailed listing of expenditures totaled $442,216, resulting in an understatement of $24,540. The SEFA was revised to reflect the corrected expenditure amount. 4) For the same Coronavirus Relief Fund award (CFDA 21.019), approximately $251,483 of revenue received and recorded by the Center was not included in the total federal expenditures reported on the SEFA. An additional $251,483 was required to be added to the SEFA to properly present total expenditures for this program. Cause: The Center did not have adequate internal controls over the identification, tracing, and reporting of federal awards. Specifically, there was: • No formal process to ensure all federal awards, including pass-through funding, were captured in the SEFA. • Lack of reconciliation between the general ledger and SEFA. • Insufficient review procedures over the completeness and accuracy of the SEFA. • Inadequate documentation retention practices for federal compliance. Effect or Potential Effect: As a result of these deficiencies, the SEFA initially omitted two federal awards and understated federal expenditures, resulting in an inaccurate presentation of federal expenditures. These errors could affect the identification of major programs and compliance with Uniform Guidance reporting requirements if not detected and corrected. Questioned Costs: $54,974. Section III – Federal Awards Findings and Questioned Costs (Continued) A. Current Year Findings and Questioned Costs – Major Federal Award Program Audit (Continued) Finding 2020-007 Material Weakness in Internal Control over Compliance and Schedule of Expenditures of Federal Awards (SEFA) Preparation and Completeness (Continued) Recommendations: We recommend that management strengthen internal controls over the preparation and review of the SEFA by implementing the following procedures: • Develop and use a standardized SEFA preparation checklist that includes identification of all federal awards received during the year, including pass-through awards, verification of the correct CFDA Numbers, and confirmation of the appropriate federal awarding agencies. • Perform and document a reconciliation of the SEFA to the general ledger, grant revenue schedules, and detailed expenditure reports for each federal program to ensure completeness and accuracy of reported expenditures. • Establish procedures to compare federal revenue received to expenditures reported on the SEFA and investigate and resolve any significant variances to ensure that all eligible expenditures are properly included. View of Responsible Officials: Management understands and agrees with the finding and acknowledges deficiencies in SEFA preparation and reconciliation processes. Corrective actions include: • Implementing a standardized SEFA preparation checklist to identify all federal awards, including pass-through funding. • Requiring a documented reconciliation of the SEFA to the general ledger, grant schedules and supporting reports. • Establishing procedures to compare federal revenue to expenditures and investigate variances. • Strengthening documentation retention practices to support all reported federal expenditures. • Providing training to finance personnel on Uniform Guidance and SEFA requirements.
Finding Reference Number: 2020-001 - Reporting Federal Program Information U.S. Department of Housing and Urban Development Housing Trust Fund (ALN: 14.275) Criteria or specific requirement The Uniform Guidance 2 CFR section 200.303 states, “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).” The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare a schedule of expenditures of federal awards (SEFA) 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.” Condition The Agency omitted federally-funded expenditures required to be reported as part of the Schedule for the year ended October 31, 2020. Cause The Agency’s internal controls in place over the preparation of the Schedule were not sufficient to accurately report all expenditures of federal awards. Effect The omission of expenditures resulted in a major program not being identified in a timely manner. Section III –Federal Awards Findings and Questioned Costs (continued) Questioned Costs None. Context Expenditures of ALN 14.275 Housing Trust Fund were understated by $38.8 million. Identification as a Repeat Finding, if applicable The finding is a repeat finding – Finding 2019-001. Recommendation The Agency should review its internal controls over the process of accumulating and reporting expenditures of federal awards. Views of Responsible Officials The Agency agrees with the finding and has developed internal controls to ensure accurate and complete reporting of federal expenditures.
Finding 2020-001 Federal Program: Highway Planning and Construction CFDA Number: 20.205 Federal Agency: U.S. Department of Transportation Federal Award Year: 2020 Grant numbers: ACNH 7101 (807), BRLS-5108 (137) Pass-Through Entity: State of California Department of Transportation Compliance Requirement: Other – Inaccurate reporting of the Schedule of Expenditures of Federal Awards Criteria: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designated to reasonably ensure compliance with Federal laws, regulations and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately and completely reported on the SEFA. Conditions Found: The City did not have adequate internal controls related to the reporting of expenditures on the SEFA for the Highway Planning and Construction program. The Gerald Desmond Bridge (Harbor Bridge) reconstruction was a $1.6 billion design, development, and construction project that included multiple funding sources, including federal, state, and private funds. As part of the completeness and accuracy of the SEFA control, the City needed to timely prepare and review a reconciliation of all of the federal, state, and private funding sources received for the overall Harbor Bridge project year-to-date, and determine at a proper level of precision, which expenditures were being reimbursed with federal funding sources to determine what amounts to report on the SEFA for the year ended September 30, 2020. This overall year-to-date reconciliation was not timely performed and as a result, an additional $21,383,260 of federal expenditures related to the Highway Planning and Construction program should have been reported on the SEFA for the year ended September 30, 2020. Cause and Effect: In discussing these conditions with the City, they stated the error was primarily due to the control over the completeness and accuracy of the SEFA was not timely performed and designed at the appropriate precision level for multi-year and multi-funded construction projects. Failure to establish effective internal controls regarding financial reporting for the preparation of the Schedule may prevent the City from completing an audit in accordance with the timelines of Uniform Guidance. Questioned Costs: Not applicable. Statistical sampling: Not applicable. Repeat Finding: A similar finding was not reported in the prior year. Recommendation: We recommend the City implement a system of internal control that is designed and operating at a level of precision to ensure the Schedule is complete and accurate. View of Responsible Official: The Harbor Department acknowledges the finding. The Harbor Department believes this omission was the result of an internal miscommunication.