Condition: During our review of Federal Financial Reports (SF-425) for the Emergency Management Performance Grant (EMPG) covering program years 2018, 2019, and 2020, we noted multiple reporting deficiencies across all four reports reviewed, including late submissions (in some cases more than one year late), undated reports with no evidence of submission timeliness, incomplete financial data where federal cash receipts or disbursements were reported as zero despite active grant activity, inconsistent or missing expenditure information, incorrect or missing recipient share (matching funds), unreconciled balances between SF-425 reports and PRIFAS or the SEFA, lack of supporting documentation or reconciliation schedules, and no evidence of internal review or approval controls. Criteria: Under 2 CFR 200.327–200.329 and 2 CFR 200.302(b)(6), non-Federal entities must submit accurate, complete, timely performance and financial reports supported by accounting records; SF-425 reports must reflect financial results of each award, be supported by the accounting records, include federal and recipient share, and be submitted no later than 30 days after the end of the reporting period. Context: All four EMPG SF-425 reports reviewed exhibited at least one of the identified deficiencies, indicating systemic noncompliance with federal reporting requirements and insufficient monitoring over the reporting process. Cause: The Bureau lacks effective internal controls and supervisory review over the preparation, reconciliation, and submission of SF-425 reports, including inadequate coordination between accounting and grants management areas and no formal process to ensure reconciliation to PRIFAS accounting data prior to submission. Effect: The absence of timely, accurate, and reconciled financial reporting increases the risk of misstated federal program expenditures, may result in grantor sanctions such as withholding or suspension of federal funds, and impairs the Bureau’s ability to demonstrate compliance with Uniform Guidance reporting requirements. Recommendation: Establish and document formal procedures to ensure timely preparation, review, and submission of SF-425 reports; implement a reconciliation checklist requiring agreement of reported data to PRIFAS and SEFA records; ensure each report includes federal and recipient share, drawdown activity, and unliquidated obligations; designate an official responsible for review and approval prior to filing with retained evidence of submission; and provide staff training on federal reporting requirements under 2 CFR 200.327–200.329. Questioned Costs: None. Management Response: See corrective action plan.
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
The Organization did not establish written procedures as required by 2 CFR section 200.305 (Federal payment ‐ advances) [2 CFR section 200.302(b)(6)].
The Organization did not establish written procedures as required by 2 CFR section 200.305 (Federal payment ‐ advances) [2 CFR section 200.302(b)(6)].
Finding 2020-003: Reconciliation of Accounts Federal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1812860 (9/1/2018 – 8/31/2020), 1940925 (1/15/2020 – 12/31/2023) Material Weakness in Internal Control over Compliance, Material Noncompliance Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113 in total. Assistance listing number 47.076. Of this amount, $62,403 applies to award ID 1505278, which was closed before 1/1/2020 and did not have expenses or drawdowns in 2020 but by the end of 2018 had $138,034 in federal funding provided to AAPT and $75,631 of reimbursable expenses. AAPT had not refunded the overpayment, such as by applying this $62,403 as a reduction in federal reimbursements drawn during 2020. The remaining amounts of $10,654 and $4,056 relate to award IDs 1812860, and 1940925, respectively, and were calculated in the same manner. The period of performance for award ID 1812860 ended on 8/31/2020. Award ID 1940925 was active through 12/31/2020. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: October 15, 2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Federal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1812860 (9/1/2018 – 8/31/2020), 1940925 (1/15/2020 – 12/31/2023) Material Weakness in Internal Control over Compliance, Material Noncompliance Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113 in total. Assistance listing number 47.076. Of this amount, $62,403 applies to award ID 1505278, which was closed before 1/1/2020 and did not have expenses or drawdowns in 2020 but by the end of 2018 had $138,034 in federal funding provided to AAPT and $75,631 of reimbursable expenses. AAPT had not refunded the overpayment, such as by applying this $62,403 as a reduction in federal reimbursements drawn during 2020. The remaining amounts of $10,654 and $4,056 relate to award IDs 1812860, and 1940925, respectively, and were calculated in the same manner. The period of performance for award ID 1812860 ended on 8/31/2020. Award ID 1940925 was active through 12/31/2020. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: October 15, 2024 Responsible Official: Michael Brosnan, CFO
FINDING 2020-003 Subject: Water and Waste Disposal Systems for Rural Communities - Reporting Federal Agency: Department of Agriculture Federal Program: Water and Waste Disposal Systems for Rural Communities Assistance Listings Number: 10.760 Federal Award Number and Year (or Other Identifying Number): CY2020 Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context Annual financial reports are to be filed with the awarding agency. The Town was required to file two reports during the audit period, the Statement of Budget, Income and Equity (Form RD 442-2) and the Balance Sheet (Form RD 442-3) with the U.S. Department of Agriculture (USDA). The Form RD 442-2 covers financial operations relating to the Town's water main replacement project and the Form RD 442-3 presents the financial status of the project. In both instances, a borrower may submit the financial data on other forms, provided the forms are in a similar format and signed and dated by the organization's official to certify the correctness of the information. Alternatively, an annual audit may be submitted in lieu of the forms. The Town did not prepare or file the required reports, submit financial data on other forms, or submit an annual audit in lieu of the forms to the USDA. As such, we could not substantiate the financial operations or the financial status of the project. Additionally, the Town did not obtain a written waiver from the USDA to allow the Town not to file the reports. The lack of internal controls and noncompliance were systemic issues, which occurred throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 16 TOWN OF MONROEVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (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.328 and 200.329. . . ." 7 CFR 1780.47(e) states: "Borrowers exempt from audits. All borrowers who are exempt from audits, will, within 60 days following the end of each fiscal year, furnish the RUS with annual financial statements, consisting of a verification of the organization's balance sheet and statement of income and expense by an appropriate official of the organization. Forms RD 442-2, 'Statement of Budget, Income and Equity,' and 442-3 may be used." Cause Management of the Town had not established an effective system of internal controls that segregated key functions and would have ensured compliance with reporting requirements of the grant. As a result, Form 442-2 and Form 442-3 were not filed. The Town did not obtain a written waiver from the USDA to support the reports not being filed. Effect Without the proper implementation of an effectively designed system of internal controls, the Town cannot ensure the required reports were filed with the awarding agency. As such, the USDA does not have accurate and current information to discern the financial status of the Town's project. Furthermore, noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the Town. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the Town's management establish a proper system of internal controls and develop policies and procedures to ensure required reports, or allowable alternatives, are completed and filed with the USDA. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
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 not a repeat finding.
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Material Weakness Federal Programs: Research and Development Cluster: 47.076 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: 05/01/2024 Responsible Official: Michael Brosnan, CFO
The Organization did not establish written procedures as required by 2 CFR section 200.305 (Federal payment ‐ advances) [2 CFR section 200.302(b)(6)].
The Organization did not establish written procedures as required by 2 CFR section 200.305 (Federal payment ‐ advances) [2 CFR section 200.302(b)(6)].
Finding 2020-003: Reconciliation of Accounts Federal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1812860 (9/1/2018 – 8/31/2020), 1940925 (1/15/2020 – 12/31/2023) Material Weakness in Internal Control over Compliance, Material Noncompliance Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113 in total. Assistance listing number 47.076. Of this amount, $62,403 applies to award ID 1505278, which was closed before 1/1/2020 and did not have expenses or drawdowns in 2020 but by the end of 2018 had $138,034 in federal funding provided to AAPT and $75,631 of reimbursable expenses. AAPT had not refunded the overpayment, such as by applying this $62,403 as a reduction in federal reimbursements drawn during 2020. The remaining amounts of $10,654 and $4,056 relate to award IDs 1812860, and 1940925, respectively, and were calculated in the same manner. The period of performance for award ID 1812860 ended on 8/31/2020. Award ID 1940925 was active through 12/31/2020. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: October 15, 2024 Responsible Official: Michael Brosnan, CFO
Finding 2020-003: Reconciliation of Accounts Federal Program: Research and Development Cluster (Education and Human Resources) Assistance Listing Number and Title: 47.076 STEM Education Name of Federal Agency, Pass Through Entity (when applicable), Award Number and Year: National Science Foundation: 1812860 (9/1/2018 – 8/31/2020), 1940925 (1/15/2020 – 12/31/2023) Material Weakness in Internal Control over Compliance, Material Noncompliance Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): According to 2 CFR 200.508 "Auditee Responsibilities" the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 "Financial statements"). Title 2 CFR 200.510 "financial statements" requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee's financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 "Financial management", the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. Condition: The year-end schedules for federal grants receivable, for net assets, and for vacation payable were not reconciled and needed to be revised and updated. Cause: Errors in transferring balances between years occurred, which impacted carry-over amounts and the ending balances as of 12/31/2020. Related to vacation payables, the schedule had not been properly adjusted to account for the number of days in the last pay period. Effect or Potential Effect: Three federal grant accounts were overdrawn as of 12/31/2020, creating a liability to the federal government. The related grant receivable and liability balances were not properly stated before adjustment as a result. Questioned Costs: $77,113 in total. Assistance listing number 47.076. Of this amount, $62,403 applies to award ID 1505278, which was closed before 1/1/2020 and did not have expenses or drawdowns in 2020 but by the end of 2018 had $138,034 in federal funding provided to AAPT and $75,631 of reimbursable expenses. AAPT had not refunded the overpayment, such as by applying this $62,403 as a reduction in federal reimbursements drawn during 2020. The remaining amounts of $10,654 and $4,056 relate to award IDs 1812860, and 1940925, respectively, and were calculated in the same manner. The period of performance for award ID 1812860 ended on 8/31/2020. Award ID 1940925 was active through 12/31/2020. Identification as a Repeat Finding, if Applicable: 2019-002 Recommendation: We recommend AAPT staff prepare schedules used to prepare entries into the accounting information system or which the information in the schedules will otherwise be used to initiate financial transactions, and the transactions and schedules be reviewed by a supervisor. Views of Responsible Officials and Planned Corrective Actions: The outstanding liability due to NSF of $73,057 will be reimbursed when AAPT files the next drawn down request. Anticipated date of drawn down will be by April, 30,2024 The remaining balance was earned in 2021. The senior accountant will be trained to prepare entries previously prepared by the CFO The senior accountant will reconcile accounts, and provide updated current schedules. The CFO will review and approve the entries and schedules prepared by the Senior accountant. Anticipated Completion Date: October 15, 2024 Responsible Official: Michael Brosnan, CFO
FINDING 2020-003 Subject: Water and Waste Disposal Systems for Rural Communities - Reporting Federal Agency: Department of Agriculture Federal Program: Water and Waste Disposal Systems for Rural Communities Assistance Listings Number: 10.760 Federal Award Number and Year (or Other Identifying Number): CY2020 Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context Annual financial reports are to be filed with the awarding agency. The Town was required to file two reports during the audit period, the Statement of Budget, Income and Equity (Form RD 442-2) and the Balance Sheet (Form RD 442-3) with the U.S. Department of Agriculture (USDA). The Form RD 442-2 covers financial operations relating to the Town's water main replacement project and the Form RD 442-3 presents the financial status of the project. In both instances, a borrower may submit the financial data on other forms, provided the forms are in a similar format and signed and dated by the organization's official to certify the correctness of the information. Alternatively, an annual audit may be submitted in lieu of the forms. The Town did not prepare or file the required reports, submit financial data on other forms, or submit an annual audit in lieu of the forms to the USDA. As such, we could not substantiate the financial operations or the financial status of the project. Additionally, the Town did not obtain a written waiver from the USDA to allow the Town not to file the reports. The lack of internal controls and noncompliance were systemic issues, which occurred throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 16 TOWN OF MONROEVILLE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following . . . (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.328 and 200.329. . . ." 7 CFR 1780.47(e) states: "Borrowers exempt from audits. All borrowers who are exempt from audits, will, within 60 days following the end of each fiscal year, furnish the RUS with annual financial statements, consisting of a verification of the organization's balance sheet and statement of income and expense by an appropriate official of the organization. Forms RD 442-2, 'Statement of Budget, Income and Equity,' and 442-3 may be used." Cause Management of the Town had not established an effective system of internal controls that segregated key functions and would have ensured compliance with reporting requirements of the grant. As a result, Form 442-2 and Form 442-3 were not filed. The Town did not obtain a written waiver from the USDA to support the reports not being filed. Effect Without the proper implementation of an effectively designed system of internal controls, the Town cannot ensure the required reports were filed with the awarding agency. As such, the USDA does not have accurate and current information to discern the financial status of the Town's project. Furthermore, noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the Town. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the Town's management establish a proper system of internal controls and develop policies and procedures to ensure required reports, or allowable alternatives, are completed and filed with the USDA. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
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 not a repeat finding.
2020-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 monitoring, communication and control activities to ensure adherence to the Authority’s key administrative policies including procurement, occupancy and the HCV administrative plan. The Authority outsourced the management of the Housing Choice Voucher and Mainstream Voucher programs and did not properly monitor the activities of the those programs. The third party management company adopted and maintained policies and procedures for the Authority without board approval. CAUSE The Authority did not have proper oversight of their Housing Choice Voucher and Mainstream Voucher programs. EFFECT This deficiency in internal controls resulted in material noncompliance, which could affect the Authority's ability to manage and report on Federal awards accurately. QUESTIONED COSTS None noted. 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 take an active role in reviewing the their policies and monitoring the Authority’s compliance with those policies. AUDITEE’S RESPONSE AND PLANNED CORRECTIVE ACTION See Corrective Action Plan.
2020-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 monitoring, communication and control activities to ensure adherence to the Authority’s key administrative policies including procurement, occupancy and the HCV administrative plan. The Authority outsourced the management of the Housing Choice Voucher and Mainstream Voucher programs and did not properly monitor the activities of the those programs. The third party management company adopted and maintained policies and procedures for the Authority without board approval. CAUSE The Authority did not have proper oversight of their Housing Choice Voucher and Mainstream Voucher programs. EFFECT This deficiency in internal controls resulted in material noncompliance, which could affect the Authority's ability to manage and report on Federal awards accurately. QUESTIONED COSTS None noted. 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 take an active role in reviewing the their policies and monitoring the Authority’s compliance with those policies. AUDITEE’S RESPONSE AND PLANNED CORRECTIVE ACTION See Corrective Action Plan.
2020-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 monitoring, communication and control activities to ensure adherence to the Authority’s key administrative policies including procurement, occupancy and the HCV administrative plan. The Authority outsourced the management of the Housing Choice Voucher and Mainstream Voucher programs and did not properly monitor the activities of the those programs. The third party management company adopted and maintained policies and procedures for the Authority without board approval. CAUSE The Authority did not have proper oversight of their Housing Choice Voucher and Mainstream Voucher programs. EFFECT This deficiency in internal controls resulted in material noncompliance, which could affect the Authority's ability to manage and report on Federal awards accurately. QUESTIONED COSTS None noted. 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 take an active role in reviewing the their policies and monitoring the Authority’s compliance with those policies. AUDITEE’S RESPONSE AND PLANNED CORRECTIVE ACTION See Corrective Action Plan.
2020-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 monitoring, communication and control activities to ensure adherence to the Authority’s key administrative policies including procurement, occupancy and the HCV administrative plan. The Authority outsourced the management of the Housing Choice Voucher and Mainstream Voucher programs and did not properly monitor the activities of the those programs. The third party management company adopted and maintained policies and procedures for the Authority without board approval. CAUSE The Authority did not have proper oversight of their Housing Choice Voucher and Mainstream Voucher programs. EFFECT This deficiency in internal controls resulted in material noncompliance, which could affect the Authority's ability to manage and report on Federal awards accurately. QUESTIONED COSTS None noted. 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 take an active role in reviewing the their policies and monitoring the Authority’s compliance with those policies. AUDITEE’S RESPONSE AND PLANNED CORRECTIVE ACTION See Corrective Action Plan.
2020-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 monitoring, communication and control activities to ensure adherence to the Authority’s key administrative policies including procurement, occupancy and the HCV administrative plan. The Authority outsourced the management of the Housing Choice Voucher and Mainstream Voucher programs and did not properly monitor the activities of the those programs. The third party management company adopted and maintained policies and procedures for the Authority without board approval. CAUSE The Authority did not have proper oversight of their Housing Choice Voucher and Mainstream Voucher programs. EFFECT This deficiency in internal controls resulted in material noncompliance, which could affect the Authority's ability to manage and report on Federal awards accurately. QUESTIONED COSTS None noted. 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 take an active role in reviewing the their policies and monitoring the Authority’s compliance with those policies. AUDITEE’S RESPONSE AND PLANNED CORRECTIVE ACTION See Corrective Action Plan.
2020-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 monitoring, communication and control activities to ensure adherence to the Authority’s key administrative policies including procurement, occupancy and the HCV administrative plan. The Authority outsourced the management of the Housing Choice Voucher and Mainstream Voucher programs and did not properly monitor the activities of the those programs. The third party management company adopted and maintained policies and procedures for the Authority without board approval. CAUSE The Authority did not have proper oversight of their Housing Choice Voucher and Mainstream Voucher programs. EFFECT This deficiency in internal controls resulted in material noncompliance, which could affect the Authority's ability to manage and report on Federal awards accurately. QUESTIONED COSTS None noted. 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 take an active role in reviewing the their policies and monitoring the Authority’s compliance with those policies. AUDITEE’S RESPONSE AND PLANNED CORRECTIVE ACTION See Corrective Action Plan.
2020-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 monitoring, communication and control activities to ensure adherence to the Authority’s key administrative policies including procurement, occupancy and the HCV administrative plan. The Authority outsourced the management of the Housing Choice Voucher and Mainstream Voucher programs and did not properly monitor the activities of the those programs. The third party management company adopted and maintained policies and procedures for the Authority without board approval. CAUSE The Authority did not have proper oversight of their Housing Choice Voucher and Mainstream Voucher programs. EFFECT This deficiency in internal controls resulted in material noncompliance, which could affect the Authority's ability to manage and report on Federal awards accurately. QUESTIONED COSTS None noted. 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 take an active role in reviewing the their policies and monitoring the Authority’s compliance with those policies. AUDITEE’S RESPONSE AND PLANNED CORRECTIVE ACTION See Corrective Action Plan.