Audit 54316

FY End
2022-06-30
Total Expended
$1.23M
Findings
52
Programs
8
Organization: Indigenous Peoples Task Force (MN)
Year: 2022 Accepted: 2023-02-10

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
57858 2022-001 Material Weakness - P
57859 2022-002 Material Weakness - P
57860 2022-001 Material Weakness - P
57861 2022-002 Material Weakness - P
57862 2022-001 Material Weakness - P
57863 2022-002 Material Weakness - P
57864 2022-001 Material Weakness - P
57865 2022-002 Material Weakness - P
57866 2022-001 Material Weakness - P
57867 2022-002 Material Weakness - P
57868 2022-001 Material Weakness - P
57869 2022-002 Material Weakness - P
57870 2022-001 Material Weakness - P
57871 2022-002 Material Weakness - P
57872 2022-003 Significant Deficiency - L
57873 2022-004 Significant Deficiency - B
57874 2022-001 Material Weakness - P
57875 2022-002 Material Weakness - P
57876 2022-003 Significant Deficiency - L
57877 2022-004 Significant Deficiency - B
57878 2022-001 Material Weakness - P
57879 2022-002 Material Weakness - P
57880 2022-001 Material Weakness - P
57881 2022-002 Material Weakness - P
57882 2022-001 Material Weakness - P
57883 2022-002 Material Weakness - P
634300 2022-001 Material Weakness - P
634301 2022-002 Material Weakness - P
634302 2022-001 Material Weakness - P
634303 2022-002 Material Weakness - P
634304 2022-001 Material Weakness - P
634305 2022-002 Material Weakness - P
634306 2022-001 Material Weakness - P
634307 2022-002 Material Weakness - P
634308 2022-001 Material Weakness - P
634309 2022-002 Material Weakness - P
634310 2022-001 Material Weakness - P
634311 2022-002 Material Weakness - P
634312 2022-001 Material Weakness - P
634313 2022-002 Material Weakness - P
634314 2022-003 Significant Deficiency - L
634315 2022-004 Significant Deficiency - B
634316 2022-001 Material Weakness - P
634317 2022-002 Material Weakness - P
634318 2022-003 Significant Deficiency - L
634319 2022-004 Significant Deficiency - B
634320 2022-001 Material Weakness - P
634321 2022-002 Material Weakness - P
634322 2022-001 Material Weakness - P
634323 2022-002 Material Weakness - P
634324 2022-001 Material Weakness - P
634325 2022-002 Material Weakness - P

Contacts

Name Title Type
UC4LQ8FNLQJ8 Sharon Day Auditee
6513258077 Elizabeth Barchenger Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: 1) Expenditures reported on the schedule are reported on the accrual basis of accounting. Such expenditures are recognized following, as applicable, either the cost principles contained in OMB Circular A-122, Cost Principles for Non-profit Organizations, or the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. 2) Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: IPTF has elected not to use the 10 percent de minimis cost rate allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards (the schedule) includes the federal grant activity of Indigenous Peoples Task Force (IPTF) under programs of the federal government for the year ended June 30, 2022. The information in this schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the Uniform Guidance).Because the schedule presents only a selected portion of the operations of IPTF, it is not intended to and does not present the financial position, changes in net assets, or cash flows of IPTF.

Finding Details

2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-003: Filing of Federal Reports SF-425 and OPR Federal Departments: Department of Health and Human Services Assistance Listing #: 93.612 Internal Controls Significant Deficiency Category of Finding ? Reporting Criteria ? IPTF is responsible to submit Federal Financial Reports (SF-425) and Ongoing Progress Reports (OPR) semi-annually within 30 days of period end. Condition ? The March 30, 2022 SF-425 and OPR were filed on June 1, 2022, outside the 30 day filing requirement. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. After taking over, the contract accountant was not aware of these federal reporting requirements, and that they were responsible for them. Additionally, the information needed for filing these reports was not ready on-time due to the contract accountant?s inability to provide reliable and timely financial reports. Effect ? Failure to submit reports within the required period may result in IPTF?s status to be delinquent and not be able to draw down funds on the award. Recommendation ? We recommend that management implement a formal process to ensure that federal reports are prepared and reviewed timely. Auditee?s comments and response ? IPTF has hired a new contract accountant, who will be responsible for ensuring that the accounting records are prepared accurately and to ensure that these required reports are submitted on time. Responsible party for corrective action: Sharon Day, Executive Director
2022-004: Lack of Controls Surrounding Allocation of Payroll Costs to Programs Federal Departments: Department of Health and Human Services Assistance Listing #: 93.612 Internal Controls Significant Deficiency Category of Finding ? Allowable Costs/ Cost Principles Criteria ? Federal awards must be expended for activities allowed under the grant and costs charged to the federal grants must be allowable and in accordance with applicable cost principles. Condition ? IPTF staff use timecards to track which programs they work on to ensure that costs are properly allocated to each grant. The timecards are provided to the Finance Director/contract accountant for input into the accounting software, which is used to prepare grant reimbursement requests. During testing, after the transition to a contract accountant, we noticed multiple payroll transactions where the amounts noted as worked on this grant during the period tested did not match the payroll that was allocated to the grant in the accounting software. Cause ? The contract accountant did not record payroll costs in the accounting software consistent with the timecards provided by staff. Effect ? Grants have been overcharged for payroll allocated to the wrong grant or over-recorded payroll costs. Recommendation ? We recommend that management design and implement a review process to ensure payroll allocated to grants is calculated and recorded properly. Auditee?s comments and response ? IPTF has hired a new contract accountant, who will be responsible for ensuring proper payroll allocation calculation and recording. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-003: Filing of Federal Reports SF-425 and OPR Federal Departments: Department of Health and Human Services Assistance Listing #: 93.612 Internal Controls Significant Deficiency Category of Finding ? Reporting Criteria ? IPTF is responsible to submit Federal Financial Reports (SF-425) and Ongoing Progress Reports (OPR) semi-annually within 30 days of period end. Condition ? The March 30, 2022 SF-425 and OPR were filed on June 1, 2022, outside the 30 day filing requirement. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. After taking over, the contract accountant was not aware of these federal reporting requirements, and that they were responsible for them. Additionally, the information needed for filing these reports was not ready on-time due to the contract accountant?s inability to provide reliable and timely financial reports. Effect ? Failure to submit reports within the required period may result in IPTF?s status to be delinquent and not be able to draw down funds on the award. Recommendation ? We recommend that management implement a formal process to ensure that federal reports are prepared and reviewed timely. Auditee?s comments and response ? IPTF has hired a new contract accountant, who will be responsible for ensuring that the accounting records are prepared accurately and to ensure that these required reports are submitted on time. Responsible party for corrective action: Sharon Day, Executive Director
2022-004: Lack of Controls Surrounding Allocation of Payroll Costs to Programs Federal Departments: Department of Health and Human Services Assistance Listing #: 93.612 Internal Controls Significant Deficiency Category of Finding ? Allowable Costs/ Cost Principles Criteria ? Federal awards must be expended for activities allowed under the grant and costs charged to the federal grants must be allowable and in accordance with applicable cost principles. Condition ? IPTF staff use timecards to track which programs they work on to ensure that costs are properly allocated to each grant. The timecards are provided to the Finance Director/contract accountant for input into the accounting software, which is used to prepare grant reimbursement requests. During testing, after the transition to a contract accountant, we noticed multiple payroll transactions where the amounts noted as worked on this grant during the period tested did not match the payroll that was allocated to the grant in the accounting software. Cause ? The contract accountant did not record payroll costs in the accounting software consistent with the timecards provided by staff. Effect ? Grants have been overcharged for payroll allocated to the wrong grant or over-recorded payroll costs. Recommendation ? We recommend that management design and implement a review process to ensure payroll allocated to grants is calculated and recorded properly. Auditee?s comments and response ? IPTF has hired a new contract accountant, who will be responsible for ensuring proper payroll allocation calculation and recording. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-003: Filing of Federal Reports SF-425 and OPR Federal Departments: Department of Health and Human Services Assistance Listing #: 93.612 Internal Controls Significant Deficiency Category of Finding ? Reporting Criteria ? IPTF is responsible to submit Federal Financial Reports (SF-425) and Ongoing Progress Reports (OPR) semi-annually within 30 days of period end. Condition ? The March 30, 2022 SF-425 and OPR were filed on June 1, 2022, outside the 30 day filing requirement. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. After taking over, the contract accountant was not aware of these federal reporting requirements, and that they were responsible for them. Additionally, the information needed for filing these reports was not ready on-time due to the contract accountant?s inability to provide reliable and timely financial reports. Effect ? Failure to submit reports within the required period may result in IPTF?s status to be delinquent and not be able to draw down funds on the award. Recommendation ? We recommend that management implement a formal process to ensure that federal reports are prepared and reviewed timely. Auditee?s comments and response ? IPTF has hired a new contract accountant, who will be responsible for ensuring that the accounting records are prepared accurately and to ensure that these required reports are submitted on time. Responsible party for corrective action: Sharon Day, Executive Director
2022-004: Lack of Controls Surrounding Allocation of Payroll Costs to Programs Federal Departments: Department of Health and Human Services Assistance Listing #: 93.612 Internal Controls Significant Deficiency Category of Finding ? Allowable Costs/ Cost Principles Criteria ? Federal awards must be expended for activities allowed under the grant and costs charged to the federal grants must be allowable and in accordance with applicable cost principles. Condition ? IPTF staff use timecards to track which programs they work on to ensure that costs are properly allocated to each grant. The timecards are provided to the Finance Director/contract accountant for input into the accounting software, which is used to prepare grant reimbursement requests. During testing, after the transition to a contract accountant, we noticed multiple payroll transactions where the amounts noted as worked on this grant during the period tested did not match the payroll that was allocated to the grant in the accounting software. Cause ? The contract accountant did not record payroll costs in the accounting software consistent with the timecards provided by staff. Effect ? Grants have been overcharged for payroll allocated to the wrong grant or over-recorded payroll costs. Recommendation ? We recommend that management design and implement a review process to ensure payroll allocated to grants is calculated and recorded properly. Auditee?s comments and response ? IPTF has hired a new contract accountant, who will be responsible for ensuring proper payroll allocation calculation and recording. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-003: Filing of Federal Reports SF-425 and OPR Federal Departments: Department of Health and Human Services Assistance Listing #: 93.612 Internal Controls Significant Deficiency Category of Finding ? Reporting Criteria ? IPTF is responsible to submit Federal Financial Reports (SF-425) and Ongoing Progress Reports (OPR) semi-annually within 30 days of period end. Condition ? The March 30, 2022 SF-425 and OPR were filed on June 1, 2022, outside the 30 day filing requirement. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. After taking over, the contract accountant was not aware of these federal reporting requirements, and that they were responsible for them. Additionally, the information needed for filing these reports was not ready on-time due to the contract accountant?s inability to provide reliable and timely financial reports. Effect ? Failure to submit reports within the required period may result in IPTF?s status to be delinquent and not be able to draw down funds on the award. Recommendation ? We recommend that management implement a formal process to ensure that federal reports are prepared and reviewed timely. Auditee?s comments and response ? IPTF has hired a new contract accountant, who will be responsible for ensuring that the accounting records are prepared accurately and to ensure that these required reports are submitted on time. Responsible party for corrective action: Sharon Day, Executive Director
2022-004: Lack of Controls Surrounding Allocation of Payroll Costs to Programs Federal Departments: Department of Health and Human Services Assistance Listing #: 93.612 Internal Controls Significant Deficiency Category of Finding ? Allowable Costs/ Cost Principles Criteria ? Federal awards must be expended for activities allowed under the grant and costs charged to the federal grants must be allowable and in accordance with applicable cost principles. Condition ? IPTF staff use timecards to track which programs they work on to ensure that costs are properly allocated to each grant. The timecards are provided to the Finance Director/contract accountant for input into the accounting software, which is used to prepare grant reimbursement requests. During testing, after the transition to a contract accountant, we noticed multiple payroll transactions where the amounts noted as worked on this grant during the period tested did not match the payroll that was allocated to the grant in the accounting software. Cause ? The contract accountant did not record payroll costs in the accounting software consistent with the timecards provided by staff. Effect ? Grants have been overcharged for payroll allocated to the wrong grant or over-recorded payroll costs. Recommendation ? We recommend that management design and implement a review process to ensure payroll allocated to grants is calculated and recorded properly. Auditee?s comments and response ? IPTF has hired a new contract accountant, who will be responsible for ensuring proper payroll allocation calculation and recording. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director
2022-001: Lack of Regular Preparation and Review of Reliable Internal Financial Statements Material Weakness Criteria ? Management is responsible for oversight of IPTF, which includes timely recording, processing, summarizing, and review of accounting data (i.e., maintaining and reviewing internal books and records). Good internal controls also requires the Board of Directors to meet regularly and review the financial status and results of operations of IPTF. Condition ? Monthly internal financial statements were not prepared or reviewed by management after the transition to an outside contract accountant beginning in January 2022. Management also only had board minutes indicating the board met twice during the year. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. During the transition, monthly internal financial statements were either not prepared by the contract accountant, or when prepared were done late and were full of errors. Corrections to reports with errors were not made on a timely basis. As relates to the board meetings, the Executive Director indicated that while the Board does not formally meet every quarter and in person, they stay in regular contact and are meeting via phone and email. No formal documentation of these phone and email meetings is currently maintained by IPTF as board minutes. Effect ? Without a regular review of financial statements, a misstatement could occur and not be detected by management. Without good documentation of meetings, it is easy for an issue to be missed or forgotten in later meeting. Recommendation ? We recommend that management implement a formal process to prepare and review internal financial statements for all reporting entities on a monthly basis. IPTF should also implement a process for ensuring the board meet at least quarterly, and that these meetings be properly documented. Auditee?s comments and response ? IPTF has hired a new contract accountant and will ensure they prepare internal financial statements on a monthly basis as required by their written financial policies and send to management for review. Also, the board will plan to meet quarterly and document meeting minutes. Responsible party for corrective action: Sharon Day, Executive Director
2022-002: Audit Adjustments and Oversight of the Financial Reporting Process Material Weakness Criteria ? Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition ? During the annual audit, nine adjustments were made to IPTF?s financial statements that in the aggregate, were material to the financial statements. Additionally, the financial statements for the year ended June 30, 2021 were restated during the current year due to a prior year error. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. The need for us to record significant audit adjustments indicates a break down in the internal controls related to preparing and reviewing the IPTF?s financial statements which we consider a material weakness because a misstatement of financial statements could occur and not be prevented or detected. Cause ? IPTF?s Finance Director retired during the year and an outside accounting firm was contracted to take over the role of the accounting department. This transition was not clean and certain closing entries that were typically made by the previous Finance Director were missed. Additionally, the existence of a multi-year pledge during the year ended June 30, 2020 was not properly communicated to the accounting department, resulting in the revenue being recorded when the payments were actually received instead of as revenue and receivable when originally pledged. Effect ? A material misstatement of the financial statement could occur and not be prevented or detected. Members of management using IPTF?s internal books and records may not have complete and accurate information throughout the year. Recommendation ? We recommend IPTF develop and implement a financial statement preparation, review and approval process to ensure that necessary adjustments and reconciliations are performed on a monthly basis. IPTF should also ensure that all documents related to pledges are obtained and communicated to the necessary member of management to ensure all transactions are recorded correctly. Auditee's comments and response ? IPTF has hired a new contract accountant and will ensure they establish the recommended procedures. Responsible party for corrective action: Sharon Day, Executive Director