FAC Explorer

Audit 318188

FY End
2022-06-30
Total Expended
$5.21M
Findings
10
Programs
6
Organization: Community Development Partnership (MA)
Year: 2022 Accepted: 2024-08-29
Auditor: Sanders Walsh & Eaton CPAS LLC

Organization Exclusion Status:

Findings

ID Ref Severity Repeat Requirement
485458 2022-001 Material Weakness Yes P
485459 2022-002 - Yes P
485460 2022-003 Material Weakness Yes B
485461 2022-004 Material Weakness - B
485462 2022-005 - Yes L
1061900 2022-001 Material Weakness Yes P
1061901 2022-002 - Yes P
1061902 2022-003 Material Weakness Yes B
1061903 2022-004 Material Weakness - B
1061904 2022-005 - Yes L

Programs

ALN Program Spent Major Findings
14.239 Home Investment Partnerships Program $2.26M - 0
10.415 Rural Rental Housing Loans $935,910 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $687,617 Yes 0
14.871 Section 8 Housing Choice Vouchers $282,362 - 0
10.427 Rural Rental Assistance Payments $89,398 - 0
10.415 Rural Rental Housing Loans - Interest Subsidy $40,863 - 0

Contacts

Name Title Type
SCKZF1LHJN63 Kathleen Boyce Auditee
5082900111 Ivan Tutov Auditor
No contacts on file

Notes to SEFA

Title: NOTE A - BASIS OF PRESENTATION: Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: CDP has elected not to use the 10% de minimums indirect cost rate allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of the Lower Cape Cod Community Development d/b/a Community Development Partnership (CDP) 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 of Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of CDP it is not intended to and does not present the financial position, changes in net assets, or cash flows of CDP.The dollar threshold used to distinguish Type A and Type B programs according to 2CFR 200.518(b)(1) is determined to be $750,000. There were no awards received that were passed through to subrecipients.
Title: NOTE D - NON CASH FEDERAL AWARDS: Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: CDP has elected not to use the 10% de minimums indirect cost rate allowed under the Uniform Guidance. The CDP receives an interest credit subsidy from USDA that does not result in cash receipts or disbursements. For the year ended June 30, 2022, the CDP received and expensed $40,863 worth of non-cash interest credit subsidy under CFDA # 10.415 - Rural Rental Housing Loan Program. This amount is included in the amount presented on the Schedule of Expenditures of Federal Awards.
Title: NOTE E - FEDERAL AWARDS EXPENDED FOR LOAN OR LOAN GUARANTEE PROGRAMS: Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: CDP has elected not to use the 10% de minimums indirect cost rate allowed under the Uniform Guidance. Balances of loans and loan guarantee programs outstanding as of June 30, 2022 for loans described in 2 CFR section 200.502(b) are as follow: Assistance Listing Program name Beginning balance as of 6/30/21 New loans from 7/1/21-6/30/22 Outstanding balance as of 6/30/22 14.239 Home Investment Partnerships Program $2,256,000 $- $2,256,000 14.228 Community Development Block Grants/State's program and Non-Entitlement Grants in Hawaii 917,773 - 917,773 10.415 Rural Rental Housing Loans 935,910 - 926,852 Total $4,109,683 $- $4,100,625

Finding Details

Finding 2022-001
2022-001 Separate accounting records for housing project operations - (Material Weakness)Criteria:According to 7 CFR 3560.302, borrowers must establish accounting and financial management procedures necessary to conduct housing project operations in a financially safe and sound manner. Borrowers must maintain records in a manner suitable for an audit, and must be able to report accurate operational results to the Rural Development (RD) from these accounts and records. Condition: The CDP accounting software is not set up to separate transactions for its RD project (Fred Bell Way) and to produce a separate statement of financial position and a general ledger. Cause: The CDP changed its accounting software and merge various accounts during the transition which made it difficult to separate projects' activities and financial records. Effect: Lack of accounting system that segregates and tracks funds for projects allows for comingling of funds from different projects Questioned Cost: Undetermined Recommendation: Establish an accounting system that provides for separate accountability for projects by segregating and tracking projects funds separately and producing separate financial records for each project. Management's Views and Corrective Action Plan Management's response is included in "Management's View and Corrective Action Plan" at the end of this report after the schedule of findings and questioned cost
Finding 2022-002
2022-002Annual Financial ReportsCriteria:According to 7 CFR 3560.308, to ensure that the project is in sound financial condition and is complying with the program financial management requirements, the RD requires annual financial reports to be submitted by each borrower. Condition: The required financial reports and forms for Fred Bell Way were not submitted to the RD. Cause: The CDP staff was not aware of and did not follow the guidelines for annual reporting. Effect: Failure to file annual reports to RD could result in the loss or withholding of rental assistance funds thereby putting a financial strain on the project. Questioned Cost: Undetermined Recommendation: Establish an understanding and initiate the requirements of the management and reporting of RD funds. Management's Views and Corrective Action Plan Management's response is included in "Management's View and Corrective Action Plan" at the end of this report after the schedule of findings and questioned cost
Finding 2022-003
Financial Management System- (Material Weakness) Criteria:According to 2 CFR 200.302, the financial management system of each non-Federal entity must provide records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Condition: Statement of financial position transactions were not allocated properly to programs/properties funded with federal funds. Cause: Due to a human error of individuals who were handling the accounting entries, some of transactions were not accurately allocated to the correct programs/properties. Effect: Improper allocation of transactions among various programs/properties could lead to comingling of funds from different projects. This could result in unallowable cost or in allowable cost charged simultaneously to two different programs/properties. Questioned Cost: Undetermined Recommendation: Establish an internal control procedures in place that provide for separate accountability for projects by allocating transactions properly and producing accurate financial reports for each federally funded programs/properties. Management's Views and Corrective Action Plan Management's response is included in "Management's View and Corrective Action Plan" at the end of this report after the schedule of findings and questioned cost
Finding 2022-004
2022-004Unsubstantiated methodology to allocate indirect costs charged to a federal program - (Material Weakness)Criteria:Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Condition: Expenditures were charged to the program based on different percentages applied to indirect bills that benefit the entire organization. There was not a substantiated methodology to arrive at these percentages. Cause: The CDP failed to implement consistent and reasonable methodology to allocate indirect costs. Effect: Indirect charges allocated to a program based on unsubstantiated methodology can result in federal reimbursements that are not reflective of actual costs. Indirect costs may be overcharged to the program. Questioned Cost: Undetermined Recommendation: Management needs to ensure the CDP establishes a reasonable and consistent allocation methodology. Ideally, the methodology should be statistically based. That methodology should be used entity-wide to consistently allocate indirect costs to various programs. Management's Views and Corrective Action Plan Management's response is included in "Management's View and Corrective Action Plan" at the end of this report after the schedule of findings and questioned cost
Finding 2022-005
Data Collection Form (Form SF-SAC)Criteria:According to 45 CFR 75.512, the audit must be completed and the data collection form (Form SF-SAC) must be submitted within the earlier of 30 calendar days after receipt of the auditor's report(s), or nine months after the end of the audit period. Condition: The CDP failed to submit to FAC the data collection form. Cause: The CDP failed to acquire the annual audit in a timely fashion resulting in a failure to file the data collection form. Effect: Failure to file data collection form could result in withholding of federal funds and jeopardize CDP's eligibility for federal awards. Questioned Cost: Undetermined Recommendation: Management needs to ensure the CDP can produce accurate and complete annual financial statements to ensure efficient audit process. Incomplete financial records will lead to increased testing which may result in delay of filing the data collection form. Management's Views and Corrective Action Plan Management's response is included in "Management's View and Corrective Action Plan" at the end of this report after the schedule of findings and questioned cost
Finding 2022-001
2022-001 Separate accounting records for housing project operations - (Material Weakness)Criteria:According to 7 CFR 3560.302, borrowers must establish accounting and financial management procedures necessary to conduct housing project operations in a financially safe and sound manner. Borrowers must maintain records in a manner suitable for an audit, and must be able to report accurate operational results to the Rural Development (RD) from these accounts and records. Condition: The CDP accounting software is not set up to separate transactions for its RD project (Fred Bell Way) and to produce a separate statement of financial position and a general ledger. Cause: The CDP changed its accounting software and merge various accounts during the transition which made it difficult to separate projects' activities and financial records. Effect: Lack of accounting system that segregates and tracks funds for projects allows for comingling of funds from different projects Questioned Cost: Undetermined Recommendation: Establish an accounting system that provides for separate accountability for projects by segregating and tracking projects funds separately and producing separate financial records for each project. Management's Views and Corrective Action Plan Management's response is included in "Management's View and Corrective Action Plan" at the end of this report after the schedule of findings and questioned cost
Finding 2022-002
2022-002Annual Financial ReportsCriteria:According to 7 CFR 3560.308, to ensure that the project is in sound financial condition and is complying with the program financial management requirements, the RD requires annual financial reports to be submitted by each borrower. Condition: The required financial reports and forms for Fred Bell Way were not submitted to the RD. Cause: The CDP staff was not aware of and did not follow the guidelines for annual reporting. Effect: Failure to file annual reports to RD could result in the loss or withholding of rental assistance funds thereby putting a financial strain on the project. Questioned Cost: Undetermined Recommendation: Establish an understanding and initiate the requirements of the management and reporting of RD funds. Management's Views and Corrective Action Plan Management's response is included in "Management's View and Corrective Action Plan" at the end of this report after the schedule of findings and questioned cost
Finding 2022-003
Financial Management System- (Material Weakness) Criteria:According to 2 CFR 200.302, the financial management system of each non-Federal entity must provide records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Condition: Statement of financial position transactions were not allocated properly to programs/properties funded with federal funds. Cause: Due to a human error of individuals who were handling the accounting entries, some of transactions were not accurately allocated to the correct programs/properties. Effect: Improper allocation of transactions among various programs/properties could lead to comingling of funds from different projects. This could result in unallowable cost or in allowable cost charged simultaneously to two different programs/properties. Questioned Cost: Undetermined Recommendation: Establish an internal control procedures in place that provide for separate accountability for projects by allocating transactions properly and producing accurate financial reports for each federally funded programs/properties. Management's Views and Corrective Action Plan Management's response is included in "Management's View and Corrective Action Plan" at the end of this report after the schedule of findings and questioned cost
Finding 2022-004
2022-004Unsubstantiated methodology to allocate indirect costs charged to a federal program - (Material Weakness)Criteria:Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statues, regulations, and the terms and conditions of the Federal award. Condition: Expenditures were charged to the program based on different percentages applied to indirect bills that benefit the entire organization. There was not a substantiated methodology to arrive at these percentages. Cause: The CDP failed to implement consistent and reasonable methodology to allocate indirect costs. Effect: Indirect charges allocated to a program based on unsubstantiated methodology can result in federal reimbursements that are not reflective of actual costs. Indirect costs may be overcharged to the program. Questioned Cost: Undetermined Recommendation: Management needs to ensure the CDP establishes a reasonable and consistent allocation methodology. Ideally, the methodology should be statistically based. That methodology should be used entity-wide to consistently allocate indirect costs to various programs. Management's Views and Corrective Action Plan Management's response is included in "Management's View and Corrective Action Plan" at the end of this report after the schedule of findings and questioned cost
Finding 2022-005
Data Collection Form (Form SF-SAC)Criteria:According to 45 CFR 75.512, the audit must be completed and the data collection form (Form SF-SAC) must be submitted within the earlier of 30 calendar days after receipt of the auditor's report(s), or nine months after the end of the audit period. Condition: The CDP failed to submit to FAC the data collection form. Cause: The CDP failed to acquire the annual audit in a timely fashion resulting in a failure to file the data collection form. Effect: Failure to file data collection form could result in withholding of federal funds and jeopardize CDP's eligibility for federal awards. Questioned Cost: Undetermined Recommendation: Management needs to ensure the CDP can produce accurate and complete annual financial statements to ensure efficient audit process. Incomplete financial records will lead to increased testing which may result in delay of filing the data collection form. Management's Views and Corrective Action Plan Management's response is included in "Management's View and Corrective Action Plan" at the end of this report after the schedule of findings and questioned cost