FA 2022-004 Strengthen Controls over Financial Reporting Compliance Requirement: Reporting Internal Control Impact: Material Weakness Compliance Impact: Material Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Number and Title: 84.010 – Title I Grants to Local Educational Agencies Federal Award Numbers: S010A200010 (Year: 2021), S010A210010-21A (Year: 2022) Questioned Costs: $37,644 Repeat of Prior Year Findings: FA 2021-002, FA 2019-002 Description: The School District did not file accurate completion reports for the Title I Grants to Local Educational Agencies program. Background Information: The Georgia Department of Education (GaDOE) requires the School District to submit a completion report by October 30 after the 15-month period of performance associated with the Title I Grants to Local Educational Agencies (Title I) program ends. These completion reports are filed through the Grants Application section of the MyGaDOE web portal and reflect budgeted and actual expenditure information for the Title I program for the reporting period. If the total expenditures reflected on the completion report are more than the Title I program funds received by the School District for the grant period, a DE-0147 – Request for Reimbursement of Monthly Cash Disbursements will be automatically generated and the additional funds due to the School District will be disbursed appropriately. Conversely, if the total funds received for the grant period exceed the total expenditures reflected on the completion report, the Grants Application will prompt the School District to enter a check number for the required refund of excess funds drawn down. Therefore, it is imperative that completion reports are filed by the School District in an accurate and timely manner. III FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Criteria: As a recipient of federal awards, the Institution is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 – Internal Controls. Provisions included in the Uniform Guidance Section 200.302(a) state in part that “the non-Federal entity’s financial management systems must…be sufficient to permit the preparation of reports required by general and program-specific terms and conditions.” In addition, Provisions included in the Uniform Guidance Section 200.302(b)(2) state in part that the non-Federal entity’s financial management systems must provide for “accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements.” Further, as noted in the Uniform Guidance Section 200.511, management is responsible for implementing reported corrective action to findings from previous audits. Condition: A review of the School District’s accounting records and the completion report related to the Title I-A, Improving Academic Achievement of the Disadvantaged program for the period ending September 30, 2022, revealed that the expenditures were over reported by $37,644. Questioned Cost: Questioned cost of $37,644 were identified for cash drawdowns in excess of reimbursable expenditures. Cause: In discussing this deficiency with the School District, they stated these issues were a result of turnover within the Central Office. Effect: The School District was not in compliance with the Uniform Guidance and GaDOE guidance. Failure to accurately report federal award expenditures through the completion report process could lead to the filing of DE-0147 reimbursement requests with GaDOE that do not support actual expenditures. Therefore, the School District obtained more federal funding than they were eligible to receive. Additionally, this funding must be returned to GaDOE. Recommendation: The School District should establish internal control procedures to ensure that completion reports submitted to GaDOE are supported by the accounting records and DE-0147 reimbursement requests are prepared based upon actual expenditures incurred. In addition, management should develop and implement a monitoring process to ensure that control procedures are being followed. Views of Responsible Officials: We concur with this finding.
FA 2022-004 Strengthen Controls over Financial Reporting Compliance Requirement: Reporting Internal Control Impact: Material Weakness Compliance Impact: Material Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Number and Title: 84.010 – Title I Grants to Local Educational Agencies Federal Award Numbers: S010A200010 (Year: 2021), S010A210010-21A (Year: 2022) Questioned Costs: $37,644 Repeat of Prior Year Findings: FA 2021-002, FA 2019-002 Description: The School District did not file accurate completion reports for the Title I Grants to Local Educational Agencies program. Background Information: The Georgia Department of Education (GaDOE) requires the School District to submit a completion report by October 30 after the 15-month period of performance associated with the Title I Grants to Local Educational Agencies (Title I) program ends. These completion reports are filed through the Grants Application section of the MyGaDOE web portal and reflect budgeted and actual expenditure information for the Title I program for the reporting period. If the total expenditures reflected on the completion report are more than the Title I program funds received by the School District for the grant period, a DE-0147 – Request for Reimbursement of Monthly Cash Disbursements will be automatically generated and the additional funds due to the School District will be disbursed appropriately. Conversely, if the total funds received for the grant period exceed the total expenditures reflected on the completion report, the Grants Application will prompt the School District to enter a check number for the required refund of excess funds drawn down. Therefore, it is imperative that completion reports are filed by the School District in an accurate and timely manner. III FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Criteria: As a recipient of federal awards, the Institution is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 – Internal Controls. Provisions included in the Uniform Guidance Section 200.302(a) state in part that “the non-Federal entity’s financial management systems must…be sufficient to permit the preparation of reports required by general and program-specific terms and conditions.” In addition, Provisions included in the Uniform Guidance Section 200.302(b)(2) state in part that the non-Federal entity’s financial management systems must provide for “accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements.” Further, as noted in the Uniform Guidance Section 200.511, management is responsible for implementing reported corrective action to findings from previous audits. Condition: A review of the School District’s accounting records and the completion report related to the Title I-A, Improving Academic Achievement of the Disadvantaged program for the period ending September 30, 2022, revealed that the expenditures were over reported by $37,644. Questioned Cost: Questioned cost of $37,644 were identified for cash drawdowns in excess of reimbursable expenditures. Cause: In discussing this deficiency with the School District, they stated these issues were a result of turnover within the Central Office. Effect: The School District was not in compliance with the Uniform Guidance and GaDOE guidance. Failure to accurately report federal award expenditures through the completion report process could lead to the filing of DE-0147 reimbursement requests with GaDOE that do not support actual expenditures. Therefore, the School District obtained more federal funding than they were eligible to receive. Additionally, this funding must be returned to GaDOE. Recommendation: The School District should establish internal control procedures to ensure that completion reports submitted to GaDOE are supported by the accounting records and DE-0147 reimbursement requests are prepared based upon actual expenditures incurred. In addition, management should develop and implement a monitoring process to ensure that control procedures are being followed. Views of Responsible Officials: We concur with this finding.
2022-002 – INTERNAL CONTROL OVER COMPLIANCE MATERIAL WEAKNESS CRITERIA Per Uniform Guidance (2 CFR Part 200.302), the grantee must establish and maintain effective internal control over the Federal award that provides reasonable assurance that the grantee is managing the Federal award in compliance with statutes, regulations, and the terms and conditions of the Federal award. CONDITION The Authority did not maintain proper supporting documentation of program expenses, and proper authorization of expenses could not be determined. CAUSE The Authority did not have proper controls over certain the Housing Choice Voucher program expenses. EFFECT This deficiency in internal controls resulted in unsupported transactions. QUESTIONED COSTS Likely questioned costs are estimated to be less than $25,000. CONTEXT We reviewed the Authority’s internal controls over compliance with federal awards. REPEAT FINDING Not a repeat finding. RECOMMENDATION We recommend the Authority’s management review its internal control practices and ensure proper program authorization of program expenses. AUDITEE’S RESPONSE AND PLANNED CORRECTIVE ACTION See Corrective Action Plan.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.
2022-002 Financial Statement Reconciliations/Tie-In Procedures Significant Deficiency CONDITION: A weakness existed in the overall reconciliation/tie-in procedures performed over the School’s financial statement accounts for the fiscal year ended June 30, 2022. Financial accounts were either reconciled untimely or in some cases, accounts were not reconciled at all. Most of these accounts should be reconciled on a monthly basis. The major areas where reconciliation procedures were weak included:A) Beginning Balances B) Cash Balances C) Account Receivables D) Grant Receivables/Unearned Revenues E) Accounts Payable F) Grant Revenue CRITERIA: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. CAUSE: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. EFFECT: In the course of performing the audit, the auditor recommended 10 adjusting journal entries be made to the financial statements for fiscal year ending June 30, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature.
Financial Reporting Head Start ALN# 93.600 US Department of Health & Human Services Federal Grant/Contract Number: 10CH011215-02; 10CH011215-03; 10HE000901-01 Grant period – 2021 & 2022 Criteria – 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. 2 CFR section 200.302(b))3) requires that nonfederal entities keep records that include info: pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation Condition – The Organization did not maintain proper documentation in support of financial reporting requirements. Cause – Supporting records used to populate the required financial reporting were not retained by the Agency. Effect – The agency could submit incorrect information. Questioned Costs – Not applicable. Recommendation – Documentation should be prepared, reviewed, and retained to support the required reporting. The documentation should clearly document who prepared the information, who reviewed the information, and that the reviewer considered whether the information was complete and accurate. Management’s Response – Management has reviewed and accepted the finding. See “Corrective Action Plan”.
Financial Reporting Head Start ALN# 93.600 US Department of Health & Human Services Federal Grant/Contract Number: 10CH011215-02; 10CH011215-03; 10HE000901-01 Grant period – 2021 & 2022 Criteria – 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. 2 CFR section 200.302(b))3) requires that nonfederal entities keep records that include info: pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation Condition – The Organization did not maintain proper documentation in support of financial reporting requirements. Cause – Supporting records used to populate the required financial reporting were not retained by the Agency. Effect – The agency could submit incorrect information. Questioned Costs – Not applicable. Recommendation – Documentation should be prepared, reviewed, and retained to support the required reporting. The documentation should clearly document who prepared the information, who reviewed the information, and that the reviewer considered whether the information was complete and accurate. Management’s Response – Management has reviewed and accepted the finding. See “Corrective Action Plan”.
Financial Reporting Head Start ALN# 93.600 US Department of Health & Human Services Federal Grant/Contract Number: 10CH011215-02; 10CH011215-03; 10HE000901-01 Grant period – 2021 & 2022 Criteria – 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. 2 CFR section 200.302(b))3) requires that nonfederal entities keep records that include info: pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation Condition – The Organization did not maintain proper documentation in support of financial reporting requirements. Cause – Supporting records used to populate the required financial reporting were not retained by the Agency. Effect – The agency could submit incorrect information. Questioned Costs – Not applicable. Recommendation – Documentation should be prepared, reviewed, and retained to support the required reporting. The documentation should clearly document who prepared the information, who reviewed the information, and that the reviewer considered whether the information was complete and accurate. Management’s Response – Management has reviewed and accepted the finding. See “Corrective Action Plan”.
Financial Reporting Head Start ALN# 93.600 US Department of Health & Human Services Federal Grant/Contract Number: 10CH011215-02; 10CH011215-03; 10HE000901-01 Grant period – 2021 & 2022 Criteria – 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. 2 CFR section 200.302(b))3) requires that nonfederal entities keep records that include info: pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation Condition – The Organization did not maintain proper documentation in support of financial reporting requirements. Cause – Supporting records used to populate the required financial reporting were not retained by the Agency. Effect – The agency could submit incorrect information. Questioned Costs – Not applicable. Recommendation – Documentation should be prepared, reviewed, and retained to support the required reporting. The documentation should clearly document who prepared the information, who reviewed the information, and that the reviewer considered whether the information was complete and accurate. Management’s Response – Management has reviewed and accepted the finding. See “Corrective Action Plan”.
Financial Reporting Head Start ALN# 93.600 US Department of Health & Human Services Federal Grant/Contract Number: 10CH011215-02; 10CH011215-03; 10HE000901-01 Grant period – 2021 & 2022 Criteria – 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. 2 CFR section 200.302(b))3) requires that nonfederal entities keep records that include info: pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation Condition – The Organization did not maintain proper documentation in support of financial reporting requirements. Cause – Supporting records used to populate the required financial reporting were not retained by the Agency. Effect – The agency could submit incorrect information. Questioned Costs – Not applicable. Recommendation – Documentation should be prepared, reviewed, and retained to support the required reporting. The documentation should clearly document who prepared the information, who reviewed the information, and that the reviewer considered whether the information was complete and accurate. Management’s Response – Management has reviewed and accepted the finding. See “Corrective Action Plan”.
Financial Reporting Head Start ALN# 93.600 US Department of Health & Human Services Federal Grant/Contract Number: 10CH011215-02; 10CH011215-03; 10HE000901-01 Grant period – 2021 & 2022 Criteria – 2 CFR section 200.303 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. 2 CFR section 200.302(b))3) requires that nonfederal entities keep records that include info: pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation Condition – The Organization did not maintain proper documentation in support of financial reporting requirements. Cause – Supporting records used to populate the required financial reporting were not retained by the Agency. Effect – The agency could submit incorrect information. Questioned Costs – Not applicable. Recommendation – Documentation should be prepared, reviewed, and retained to support the required reporting. The documentation should clearly document who prepared the information, who reviewed the information, and that the reviewer considered whether the information was complete and accurate. Management’s Response – Management has reviewed and accepted the finding. See “Corrective Action Plan”.
Condition: For the fiscal year ended June 30, 2022, we requested that Day One prepare and send us a Schedule of Expenditures of Federal Awards. Requested that the expenditures reported in the SEFA be reconciled to Day One’s accounting records. We reviewed the SEFA and compared them to the accounting records; we noted that the expenditures reported were inaccurate. Criteria: Recipients of federal awards are subject to requirements documented in section of the Uniform Guidance Sections 200.510, 200.502, and 200.302. The criteria for each are as follows: § 200.510 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 statements which must include the total Federal awards expended as determined in accordance with § 200.502.” § 200.502 Basis for determining Federal awards expended (a) Determining Federal awards expended. The determination of when a federal award is expended must be based on when the activity related to the Federal award occurs. Generally, the activity pertains to events that require the non-Federal entity to comply with Federal statutes, regulations, and the terms and conditions of Federal awards, such as: expenditure/expense transactions associated with awards including grants, cost-reimbursement contracts under the FAR, compacts with Indian Tribes, cooperative agreements, and direct appropriations; the disbursement of funds to subrecipients; the use of loan proceeds under loan and loan guarantee programs; the receipt of property; the receipt of surplus property; the receipt or use of program income; the distribution or use of food commodities; the disbursement of amounts entitling the non-Federal entity to an interest subsidy; and the period when insurance is in force. § 200.302 Financial management (a) Each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award.The financial management system of each non-Federal entity must provide for (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements…..” Questioned Costs: None Cause: The Organization has not implemented policies and procedures requiring that the Schedule of Federal Awards to complete and accurate. Effect and Context: The Organization reported expenditures that exceeded $750,000 for 2022. In determining the major program to be audited for 2022, the auditor could not rely on the SEFA provided because the SEFA was not complete and expenditures reported were inaccurate. Which could have lead to an inaccurate reporting of federal expenditures for the Organization for 2022. Recommendation: We recommend that management implement policies and procedures requiring all federal expenditures be accurately reported in the year end Schedule of Federal Awards. Management’s Response and Corrective Action Plan: See management’s responses documented on page 46-47.
Condition: For the fiscal year ended June 30, 2022, we requested that Day One prepare and send us a Schedule of Expenditures of Federal Awards. Requested that the expenditures reported in the SEFA be reconciled to Day One’s accounting records. We reviewed the SEFA and compared them to the accounting records; we noted that the expenditures reported were inaccurate. Criteria: Recipients of federal awards are subject to requirements documented in section of the Uniform Guidance Sections 200.510, 200.502, and 200.302. The criteria for each are as follows: § 200.510 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 statements which must include the total Federal awards expended as determined in accordance with § 200.502.” § 200.502 Basis for determining Federal awards expended (a) Determining Federal awards expended. The determination of when a federal award is expended must be based on when the activity related to the Federal award occurs. Generally, the activity pertains to events that require the non-Federal entity to comply with Federal statutes, regulations, and the terms and conditions of Federal awards, such as: expenditure/expense transactions associated with awards including grants, cost-reimbursement contracts under the FAR, compacts with Indian Tribes, cooperative agreements, and direct appropriations; the disbursement of funds to subrecipients; the use of loan proceeds under loan and loan guarantee programs; the receipt of property; the receipt of surplus property; the receipt or use of program income; the distribution or use of food commodities; the disbursement of amounts entitling the non-Federal entity to an interest subsidy; and the period when insurance is in force. § 200.302 Financial management (a) Each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award.The financial management system of each non-Federal entity must provide for (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements…..” Questioned Costs: None Cause: The Organization has not implemented policies and procedures requiring that the Schedule of Federal Awards to complete and accurate. Effect and Context: The Organization reported expenditures that exceeded $750,000 for 2022. In determining the major program to be audited for 2022, the auditor could not rely on the SEFA provided because the SEFA was not complete and expenditures reported were inaccurate. Which could have lead to an inaccurate reporting of federal expenditures for the Organization for 2022. Recommendation: We recommend that management implement policies and procedures requiring all federal expenditures be accurately reported in the year end Schedule of Federal Awards. Management’s Response and Corrective Action Plan: See management’s responses documented on page 46-47.
Section III - Federal Award Findings and Questioned Costs Finding 2022-002 Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Foster Care Title IV-E Federal Assistance Listing Number: 93.658 Name of Pass-through Entity: State of California Compliance Requirements: Activities allowed or unallowed, Allowable costs/Cost Principles Type of Finding: Material Weakness in Internal Control over Compliance Federal Award Identification Number and Year: 2201CAFOST 2022 Criteria: According to 2 CFR, Part 200.302(b)(3), recipients of federal awards are responsible for maintaining records that sufficiently identify the amount, source, and expenditure of Federal funds for Federal awards. These records must contain information necessary to identify Federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. Condition/Context: In connection with the Activities allowed or unallowed, and Allowable Costs/Cost Principles compliance requirements for the Foster Care Title IV-E grant we noted that management was unable to locate two approved invoices out of 40 items selected for test work. Cause: Due to turnover in the accounting department some accounting records became misplaced and current accounting staff could not locate these records. Effect or Potential Effect: Failure to ensure expenses are being accurately supported and recorded could result in non-compliance with the grant requirements or unallowable costs being charged. Questioned Costs: $54,928 Identification as a Repeat Finding This finding is not a repeat finding. Auditor's Recommendation: We recommend that management implement policies, procedures, and controls to ensure supporting documentation over expenses is properly retained and expenses charged to Federal awards are accurate. Views of Responsible Officials: Management understands the critical importance of maintaining proper documentation to ensure compliance with federal program requirements. To this end, the Organization will implement and reinforce a comprehensive system for retaining all invoices, payment records, and supporting documentation associated with federal awards. Additionally, the Organization will create and maintain a clear record retention policy. Invoice and Payment Documentation: • All invoices related to the federal program will be promptly reviewed and approved by the appropriate personnel to ensure they reflect allowable costs under the specific terms and conditions of the award. • Management will establish clear procedures for the proper recording and classification of payments, ensuring that they are linked directly to the corresponding federal program expenses. • All supporting documentation (e.g., purchase orders, contracts, receipts) will be retained in electronic formats within the accounting system, in accordance with the Organization’s record retention policy, ensuring availability for future audits or reviews. Retention and Accessibility: • The Organization will maintain a secure, organized filing system for all invoices and payments, ensuring that each record is easily accessible for audit purposes. This system will include electronic records that are stored in a centralized database, with restricted access to authorized personnel. • Retained invoices and payment documentation will be kept for the full duration required by federal regulations, typically for a period of at least seven years after the final expenditure report for the federal award has been submitted, or as otherwise required by the specific federal agency. Periodic Reviews and Monitoring: • To ensure ongoing compliance, Management will perform periodic reviews of federal program expenditures and documentation. This will include random sampling of invoices and payment records to confirm that they are complete, accurate, and in compliance with federal regulations. • In the event of any discrepancies or issues identified during these reviews, Management will take immediate corrective action to address the issue and prevent recurrence. By maintaining thorough records of all invoices and payments, the Organization aims to not only comply with federal audit requirements but also to ensure transparency, accountability, and sound financial management of federal funds.
Finding 2022.006: Cash Management - Material Weakness Name of Federal Agency: U.S. Department of Health and Human Services Federal Program Names: Health Center Program Cluster: Health Center Program (Community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) COVID-19 Health Center Program (Community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) Grants for New and Expanded Services under the Health Center Program Federal Assistance Listing Numbers: 93.224 and 93.527 Federal Award Identification Number and Year: H80CS26638 - 2022 and 2023, H8DCS35487 - 2021, and H8F40829 - 2023 Criteria In accordance with §200.305, Federal Payment, grantees and subgrantees that receive grant funds are responsible for maintaining controls regarding the management of federal program funds under the Uniform Guidance in 2 CFR 200.302 and 200.303. Condition The Center's drawdowns did not illustrate review and approval by management. Cause The Center did not have adequate controls to ensure drawdowns were properly approved and such approval is documented. Effect or Potential Effect The condition may lead to inaccurate or improper drawdowns. Questioned Costs None. Context We selected 9 drawdowns for testing of cash management. We noted there was no formal approval or evidence of review for all 9 drawdowns. Identification of Repeat Finding Yes, see finding 2021-006. Recommendation The Center should develop written procedures to review all drawdowns that occur in order to ensure accuracy. Views of Responsible Officials Management and the Board of Directors agree with the finding and will implement additional controls to ensure there is formal evidence of review being performed.
SIGNIFICANT DEFICIENCY 2022-007 - Cash Management Federal Program Information: ALN - 66.458 - Clean Water State Revolving Funds Criteria: The following CFR(s) apply to this finding: 2 CFR section 200.302(b)(6)) & 2 CFR section 200.305(b) (3). Condition: During audit procedures, it was identified that the Town did not have a cash management policy in place. Cause: The Town has experienced turnover in the Treasurer’s position over the past few years, which has delayed the policy implementation. Effect: The Town may not have adequate policy and procedures in place to safeguard its most liquid assets. Identification of Questioned Costs: None identified. Context: The population consisted of 12 out of the 30 pay requisition deposit of reimbursements from the fiscal year were examined. Out of the 12 selections only 4 deposits had backup documentation and those 4 were not properly recorded. The other 8 were lacking proof that deposits were recorded properly. Repeat Finding: This is a repeat finding of 2021-006. Recommendation: It is recommended that the Town adopt a cash management policy that follows the Uniform Guidance and that the Town implement internal control processes and procedures to ensure that the adopted policy is followed. Views of Responsible Officials and Corrective Action Plan: Client agrees with finding, and a version of their response can be found in the Corrective Action Plan. Please see the Corrective Action Plan issued by the Town of Livermore Falls.
Federal Agency: Department of Housing and Urban Development and Department of Veterans Affairs Federal Program Name: Emergency Solutions Grant Program and VA Homeless Providers Grant and Per Diem Program Assistance Listing Number: 14.231 and 64.024 Federal Award Identification Number and Year: E20DW37001-2022 and ODMH543-1306-659-PD-21 Pass-Through Agency: North Carolina Department of Health and Human Services, Division of Aging and Adult Services Pass-Through Number(s): 00041416 Award Period: 7/29/2020 – 6/30/2022 and 10/1/2021 – 9/30/2022 Type of Finding: - Material Weakness in Internal Control over Compliance - Material Noncompliance (Modified Opinion) Criteria or specific requirement: In accordance with 2 CFR 200.302(b)(3), the recipient’s financial management system must maintain records sufficient to identify the amount, source, and expenditure of federal funds for federal awards, These records must contain information necessary to identify federal awards, authorizations, financial obligations, unobligated balances, as well as assets, expenditures, income, and interest. All records must be supported by source documentation. In accordance with the Compliance Supplement, Part 6 – Internal Control, 2 CFR section 200.303 requires that non-Federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non-Federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. In accordance with 2 CFR 200.430 (a), costs of compensation are allowable to the extent that they satisfy the specific requirements of this part, and that the total compensation for individual employees: (1) Is reasonable for the services rendered and conforms to the established written policy of the non- Federal entity consistently applied to both Federal and non-Federal activities; (2) Follows an appointment made in accordance with a non-Federal entity's laws and/or rules or written policies and meets the requirements of Federal statute, where applicable; and (3) Is determined and supported as provided in paragraph (i) of this section, when applicable. In accordance with 2 CFR 200.430(g), charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. The records must: (1) Be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable, and properly allocated, (2) Be incorporated into the official records of the recipient (3) Reasonably reflect the total activity for which the employee is compensated. Condition: During our testing, we noted the Organization did not have adequate controls to ensure that expenditures of federal awards were properly supported, reasonably reflective of the work performed, and properly reviewed and approved. Questioned costs: Assistance listing number: 14.231 Federal award identification number: E20DW37001-2022 Known questioned costs: $18,419 Assistance listing number: 64.024 Federal award identification number: ODMH543-1306-659-PD-21 Known questioned costs: $49,676 Context: During our testing, we noted the following related to the VA Homeless Providers Grant and Per Diem Program: 40 out of 40 payroll transactions tested for allowable costs and allowable activities were not allocated based on actual time worked on the grant and lacked adequate records. 11 out of 40 tested for allowable costs and allowable activities did not have evidence showingexpenditures were allowable under the grant. 17 out of 40 tested for allowable costs and allowable activities lacked evidence of review and approval. During our testing, we noted the following related to the Emergency Solutions Grant Program: 18 of 40 tested for allowable costs and allowable activities lacked evidence showing the expenditures were allowable under the grant. 8 out of 11 payroll transactions tested for allowable costs and allowable activities were not allocated based on actual time worked on the grant and lacked adequate records. Cause: The Organization’s controls were not sufficient to ensure that expenditures of federal funds were supported, reasonably reflecting the work performed under the program, reviewed and approved, and only for allowable costs and allowable activities. Effect: The Organization could have incurred expenses that were not allowable under the grant beyond those identified. Repeat Finding: Yes Recommendation: We recommend the Organization develop a system of internal controls to ensure that salaries and related payroll expenses are tracked to reasonably reflect the actual time spent working on the programs. In addition we recommend that management retain all documents including evidence of review and approval for all expenditures of federal funds until the latter of the legally required retention period or completion of required audits. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: According to ?200.302 Financial management of 2 CFR Part 200, the non-Federal entity?s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions. Further, the financial management system of each non-Federal entity must provide accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements. According to ?200.303 Internal controls of 2 CFR Part 200, 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. Condition: We noted the Organization is not in compliance with requirements related to the reporting of grants. Questioned costs: None Context: During our testing, we noted the following exceptions: ? The Organization did not complete the indirect costs section of the annual Federal Financial Report submitted during the fiscal year. Auditor noted a total of $74,062 was drawn in indirect costs for fiscal year 2022. ? The Organization is not reporting the action in FSRS no later than the last day of the month following the month in which the subaward/subaward amendment obligation was made or the subcontract award/subcontract modification was made. Cause: The Organization lacks established internal controls and procedures over financial grant management to ensure submitted reports are complete, agree to supporting spreadsheets, submitted timely, and properly maintained in the files of the Organization. Effect: The auditor noted instances of noncompliance. Noncompliance can result in delayed reimbursement of eligible Federal expenditures or potential loss of Federal funding. Repeat Finding: Yes ? 2021-003 Recommendation: ? We recommend the Organization review the instructions for completion of the federal financial reports with training provided to the program staff preparing and reviewing the federal financial reports to ensure submitted reports are complete and timely. ? Specific to special reports for FFATA, we recommend the Organization provide training on the requirements to those employees responsible for reporting the action in FSRS. Views of responsible officials: The Organization was unaware of the FFATA reporting requirement. The Organization will register and submit the FFATA. Also, the Organization failed to report the indirect costs on the FFR. The Organization has notified the responsible parties to avoid future occurrences. The FFR?s have been completed to report indirect costs separately in fiscal year 2023. The FFATA was submitted in fiscal year 2023 and will be updated yearly.
Criteria or specific requirement: According to ?200.302 Financial management of 2 CFR Part 200, the non-Federal entity?s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions. Further, the financial management system of each non-Federal entity must provide accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements. According to ?200.303 Internal controls of 2 CFR Part 200, 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. Condition: We noted the Organization is not in compliance with requirements related to the reporting of grants. Questioned costs: $1,062,184 Context: During our testing, we noted the following exception: ? The Organization did not reduce the PRF expenses claimed by the amounts reimbursed by Medicare through the cost report. Auditor calculated the average amount reimbursed by MCR and noted an average MCR reimbursement rate of 26.8% and 28.1% in fiscal years 2021 and 2020, respectively. The calculated total of costs reimbursed by Medicare through the cost report is $1,062,184. Cause: The Organization lacks established internal controls and procedures over financial grant management to ensure submitted reports are complete, agree to supporting spreadsheets, submitted timely, and properly maintained in the files of the Organization. Effect: The auditor noted instances of noncompliance. Noncompliance can result in delayed reimbursement of eligible Federal expenditures or potential loss of Federal funding. Repeat Finding: No. Recommendation: We recommend the Organization evaluate its financial reporting processes and controls to determine whether additional controls over the preparation of any Provider Relief Fund reports are needed to ensure the reports are prepared in line with the Provider Relief Fund guidelines. Views of responsible officials: The Organization missed reducing the costs claimed against PRF by the amounts reimbursed through the Medicare cost report. The Organization did have additional lost revenues though that would offset these costs claimed and wouldn?t result in a repayment of the funds. We would look to HRSA for guidance on how you would like us to update our Phase 1 PRF report or how you would like to see this corrected. Also, the CFO will listen to webinars to receive education for Phase IV funds that were received by the Organization to ensure compliance with the reporting requirements.
Criteria or specific requirement: According to ?200.302 Financial management of 2 CFR Part 200, the non-Federal entity?s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions. Further, the financial management system of each non-Federal entity must provide accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements. According to ?200.303 Internal controls of 2 CFR Part 200, 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. Condition: We noted the Organization is not in compliance with requirements related to the reporting of grants. Questioned costs: None Context: During our testing, we noted the following exceptions: ? The Organization did not complete the indirect costs section of the annual Federal Financial Report submitted during the fiscal year. Auditor noted a total of $74,062 was drawn in indirect costs for fiscal year 2022. ? The Organization is not reporting the action in FSRS no later than the last day of the month following the month in which the subaward/subaward amendment obligation was made or the subcontract award/subcontract modification was made. Cause: The Organization lacks established internal controls and procedures over financial grant management to ensure submitted reports are complete, agree to supporting spreadsheets, submitted timely, and properly maintained in the files of the Organization. Effect: The auditor noted instances of noncompliance. Noncompliance can result in delayed reimbursement of eligible Federal expenditures or potential loss of Federal funding. Repeat Finding: Yes ? 2021-003 Recommendation: ? We recommend the Organization review the instructions for completion of the federal financial reports with training provided to the program staff preparing and reviewing the federal financial reports to ensure submitted reports are complete and timely. ? Specific to special reports for FFATA, we recommend the Organization provide training on the requirements to those employees responsible for reporting the action in FSRS. Views of responsible officials: The Organization was unaware of the FFATA reporting requirement. The Organization will register and submit the FFATA. Also, the Organization failed to report the indirect costs on the FFR. The Organization has notified the responsible parties to avoid future occurrences. The FFR?s have been completed to report indirect costs separately in fiscal year 2023. The FFATA was submitted in fiscal year 2023 and will be updated yearly.
Criteria or specific requirement: According to ?200.302 Financial management of 2 CFR Part 200, the non-Federal entity?s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions. Further, the financial management system of each non-Federal entity must provide accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements. According to ?200.303 Internal controls of 2 CFR Part 200, 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. Condition: We noted the Organization is not in compliance with requirements related to the reporting of grants. Questioned costs: $1,062,184 Context: During our testing, we noted the following exception: ? The Organization did not reduce the PRF expenses claimed by the amounts reimbursed by Medicare through the cost report. Auditor calculated the average amount reimbursed by MCR and noted an average MCR reimbursement rate of 26.8% and 28.1% in fiscal years 2021 and 2020, respectively. The calculated total of costs reimbursed by Medicare through the cost report is $1,062,184. Cause: The Organization lacks established internal controls and procedures over financial grant management to ensure submitted reports are complete, agree to supporting spreadsheets, submitted timely, and properly maintained in the files of the Organization. Effect: The auditor noted instances of noncompliance. Noncompliance can result in delayed reimbursement of eligible Federal expenditures or potential loss of Federal funding. Repeat Finding: No. Recommendation: We recommend the Organization evaluate its financial reporting processes and controls to determine whether additional controls over the preparation of any Provider Relief Fund reports are needed to ensure the reports are prepared in line with the Provider Relief Fund guidelines. Views of responsible officials: The Organization missed reducing the costs claimed against PRF by the amounts reimbursed through the Medicare cost report. The Organization did have additional lost revenues though that would offset these costs claimed and wouldn?t result in a repayment of the funds. We would look to HRSA for guidance on how you would like us to update our Phase 1 PRF report or how you would like to see this corrected. Also, the CFO will listen to webinars to receive education for Phase IV funds that were received by the Organization to ensure compliance with the reporting requirements.
2022-012 Financial Statement Reconciliations/Tie-In Procedures Material Weakness This is a repeat finding. The prior-year’s auditing finding number is 2021-012. Condition: A weakness existed in the overall reconciliation/tie-in procedures performed over the Housing Authority’s financial statement accounts for the fiscal year ended March 31, 2022. Financial accounts were not reconciled on a timely, monthly basis. The major areas where reconciliation procedures were weak included: A) Bank Reconciliations B) Grant Receivables C) Account Receivables and associated allowance for doubtful accounts D) Capital Assets E) Accounts Payable F) Payroll and Other Current Liabilities Criteria: OMB Uniform Guidance states the following in section 200.302, “(2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.327 Financial reporting and 200.328 Monitoring and reporting program performance. Cause: Lack of written policies and procedures over financial tie-in procedures that identify who is responsible for performing these tie-in/reconciliation procedures. Effect: In the course of performing the audit, the auditor recommended 4 adjusting journal entries be made to the financial statements for fiscal year ending March 31, 2022. Many of these adjustments could have been avoided if timely reconciliation and tie-in procedures had been conducted by the finance department. Many of these audit adjustments were material in nature. Recommendation: The Housing Authority should adopt written reconciliation and tie-in procedures into its financial policies and procedures manual. These policies should require timely reconciliations to take place as defined under policy. Views of Responsible Officials: See Corrective Action Plan.
#2021-007 – Significant Deficiency – Special Tests Criteria Uniform Guidance (UG) requires non-Federal entities that receive grant funding to have written policies in the following areas: Internal Controls (2CFR 200.303) Travel (2CFR 200.474) Financial Management and Accounting which includes Cash Management and Allowability (2CFR 200.302) Personnel Compensation – Time and Effort Reporting (2CFR 200.430(i)) Conflict of Interest/Disclosures (2CFR 200.318) Procurement (2CFR 200.319) Condition During the audit we noted that the Organization does not have written policies in place over these areas in accordance with Uniform Guidance. Cause The Organization was not aware of the requirement to have these written policies in place. Effect The potential effect of not having these policies in place is that Organization’s expenses are not in accordance with UGG. Questioned Costs None Perspective Information No policies or procedures were noted that are in accordance with Uniform Guidance. As a response to the prior year finding, the Organization noted that they will add policies to the fiscal manual for future compliance. Identification as a repeat finding A similar issue was noted in prior year finding #2020-007. Recommendation We recommend that the Organization update the fiscal manual to include policies that are compliant with Uniform Guidance. View of responsible officials and planned corrective action Policies will be placed and adopted by the agency that meet the UG code. These policies will be placed in the fiscal manual. The fiscal manual will be created by using federal guidelines and by using the DDAP fiscal manual as guidance.
#2021-007 – Significant Deficiency – Special Tests Criteria Uniform Guidance (UG) requires non-Federal entities that receive grant funding to have written policies in the following areas: Internal Controls (2CFR 200.303) Travel (2CFR 200.474) Financial Management and Accounting which includes Cash Management and Allowability (2CFR 200.302) Personnel Compensation – Time and Effort Reporting (2CFR 200.430(i)) Conflict of Interest/Disclosures (2CFR 200.318) Procurement (2CFR 200.319) Condition During the audit we noted that the Organization does not have written policies in place over these areas in accordance with Uniform Guidance. Cause The Organization was not aware of the requirement to have these written policies in place. Effect The potential effect of not having these policies in place is that Organization’s expenses are not in accordance with UGG. Questioned Costs None Perspective Information No policies or procedures were noted that are in accordance with Uniform Guidance. As a response to the prior year finding, the Organization noted that they will add policies to the fiscal manual for future compliance. Identification as a repeat finding A similar issue was noted in prior year finding #2020-007. Recommendation We recommend that the Organization update the fiscal manual to include policies that are compliant with Uniform Guidance. View of responsible officials and planned corrective action Policies will be placed and adopted by the agency that meet the UG code. These policies will be placed in the fiscal manual. The fiscal manual will be created by using federal guidelines and by using the DDAP fiscal manual as guidance.
Finding 2021-007 Program: Office for Coastal Management Federal Financial Assistance Listing: 11.473 Federal Grantor: U.S. Department of Commerce Passed-through: National Fish and Wildlife Foundation Award No. and Year: 0318.19.070225 (2020) Compliance Requirements: Reporting Type of Finding: Material Non-Compliance/Material Weakness Criteria: 2 CFR 200.302(b)(2) - Requirements state that there must be accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 and 200.329. Condition: Expenditures for one financial report that was selected for testing did not agree with the expenditures that were reported on the SEFA and recorded in the General Ledger (difference of $11,791), based on the dates requested in the report. CFSC did not include known operational expenses for the period that were program costs at the time the report was due, which resulted in underreporting expenditures by $11,791. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: Sampling was not used. We selected all four reports filed during year. The condition noted above was identified during our procedures over CFSC’s reporting provisions. Repeat Finding from Prior Year: No Effect: CFSC did not include all known expenditures at the time the report was submitted to the National Fish and Wildlife Foundation, increasing the risk of noncompliance. Cause: CFSC’s procedures did not consistently ensure that all known expenditures at the time the report was submitted were included. Recommendation: We recommend that CFSC modify and strengthen its current policies and procedures to ensure that all known expenditures are included at the time reports are required to be submitted. Views of Responsible Officials and Planned Corrective Actions: See Separate Corrective Action Plan.
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, and for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,978. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of AccountsFederal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1524963 (11/1/2015 – 9/30/2021), 1812860 (9/1/2018 – 8/31/2020) Material Weakness in Internal Control over Compliance, Material Noncompliance Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,822 in total. Assistance listing number 47.076. Of this amount, $62,403 applies to award ID 1505278, which was closed before 1/1/2021 and did not have expenses or drawdowns in 2021 but by the end of 2018 had $138,034 in federal funding provided to AAPT and $75,631 of reimbursable expenses. AAPT had not refunded the overpayment, such as by applying this $62,403 as a reduction in federal reimbursements drawn during 2021. The remaining amounts of $10,112 and $8,307 relate to award IDs 1812860, and 1524963, respectively, and were calculated in the same manner. The period of performance for award ID 1812860 ended on 8/31/2020. The period of performance for award ID 1524963 ended on 9/30/2021. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 10/15/2024 Responsible Official: Michael Brosnan, CFO
Finding 2021-003: Reconciliation of AccountsFederal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1524963 (11/1/2015 – 9/30/2021), 1812860 (9/1/2018 – 8/31/2020) Material Weakness in Internal Control over Compliance, Material Noncompliance Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2021. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2021, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $80,822 in total. Assistance listing number 47.076. Of this amount, $62,403 applies to award ID 1505278, which was closed before 1/1/2021 and did not have expenses or drawdowns in 2021 but by the end of 2018 had $138,034 in federal funding provided to AAPT and $75,631 of reimbursable expenses. AAPT had not refunded the overpayment, such as by applying this $62,403 as a reduction in federal reimbursements drawn during 2021. The remaining amounts of $10,112 and $8,307 relate to award IDs 1812860, and 1524963, respectively, and were calculated in the same manner. The period of performance for award ID 1812860 ended on 8/31/2020. The period of performance for award ID 1524963 ended on 9/30/2021. Identification as a Repeat Finding, if Applicable: 2020-003 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $80,978 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by July 31,2024. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 10/15/2024 Responsible Official: Michael Brosnan, CFO
Management did not have written internal control procedures for determining allowable costs and other requirements over federal awards specifically relating to the Uniform Guidance. 2 CFR 200, Subpart D, Section 200.302(b)(7) requires “written procedures for determining the allowability of costs in accordance with Subpart E – Cost Principles of this part and the terms and conditions of the Federal Award. no questioned costs. Lack of written controls to identify allowable costs and special tests and provisions. Costs may be disallowed and required to be repaid to the granting agency. Compliance requirements set forth in the grant agreements were not followed. Management should develop written internal control procedures in accordance with the Uniform Guidance. This was a repeat finding as Finding 2020-004.