Audit 344101

FY End
2024-06-30
Total Expended
$4.63M
Findings
14
Programs
6
Year: 2024 Accepted: 2025-02-27

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
524664 2024-001 Material Weakness Yes P
524665 2024-002 - Yes P
524666 2024-003 Material Weakness Yes B
524667 2024-001 Material Weakness Yes P
524668 2024-002 - Yes P
524669 2024-003 Material Weakness Yes B
524670 2024-004 - Yes L
1101106 2024-001 Material Weakness Yes P
1101107 2024-002 - Yes P
1101108 2024-003 Material Weakness Yes B
1101109 2024-001 Material Weakness Yes P
1101110 2024-002 - Yes P
1101111 2024-003 Material Weakness Yes B
1101112 2024-004 - Yes L

Programs

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, 2024. 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 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, 2024 for loans described in 2 CFR section 200.502(b) are as follows: Assistance Listing Number 14.239 Pgrogram name Home Investment Partnerships Program Begin Balances of 06/30/23 $2,256,000 Outstanding Balnace 06/30/2024 $2,256,000 Assistance Listing Number 14.228 Community Development Block Grants/State's program and Non-Entitlement Grants in Hawaii Beginning balance as of 06/30/23 $917,713 Oustanding balance 06/30/24 $917,713 Assistance Listing Number 10.415 Rural Rental Housing Loans Begining balance of 06/30/23 $917,164 Oustanding balance of 06/30/24 $906,802
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, 2024, the CDP received and expensed $45,762 worth of non-cash interest credit subsidy under assistance listing 10.415 - Rural Rental Housing Loan Program. This amount is included in the amount presented on the Schedule of Expenditures of Federal Awards.

Finding Details

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: None noted 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
Annual Financial Reports Criteria: 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: None noted 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
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: None noted 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
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: None noted 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
Annual Financial Reports Criteria: 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: None noted 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
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: None noted 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
U.S. Department Of Agriculture (USDA) reporting Criteria: According to 7 CFR 3560.205 - 3560.303, and HB-2-3560, the CDP needs to comply with certain reporting requirements, to include annual submission of housing project budget and self-certification letter. Condition: The CDP did not submit an annual operating budget and self-certification letter to USDA as required by regulations. Cause: The CDP staff was not aware of and did not follow the guidelines for the annual submission of operating budget and self-certification letter to USDA Effect: Increased risk of allocating unallowable costs and/or unauthorized spending. Operating budget enables the CDP to increase rents, adjust utility allowances for residents, and create capital budget. Failure to submit an operating budget may impact the financial health of the project and its residents. Failure to submit a self- certification letter is a violation of USDA performance standards. Questioned Cost: None noted Recommendation: Management to reach out to USDA to clarify a reporting format and put procedures in place to ensure that the annual operating budget as well as interim budget modifications are sent to USDA for review and approval. Management to put procedures in place to ensure a self-certification letter is submitted along with the USDA required financial reports. 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
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: None noted 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
Annual Financial Reports Criteria: 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: None noted 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
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: None noted 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
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: None noted 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
Annual Financial Reports Criteria: 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: None noted 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
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: None noted 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
U.S. Department Of Agriculture (USDA) reporting Criteria: According to 7 CFR 3560.205 - 3560.303, and HB-2-3560, the CDP needs to comply with certain reporting requirements, to include annual submission of housing project budget and self-certification letter. Condition: The CDP did not submit an annual operating budget and self-certification letter to USDA as required by regulations. Cause: The CDP staff was not aware of and did not follow the guidelines for the annual submission of operating budget and self-certification letter to USDA Effect: Increased risk of allocating unallowable costs and/or unauthorized spending. Operating budget enables the CDP to increase rents, adjust utility allowances for residents, and create capital budget. Failure to submit an operating budget may impact the financial health of the project and its residents. Failure to submit a self- certification letter is a violation of USDA performance standards. Questioned Cost: None noted Recommendation: Management to reach out to USDA to clarify a reporting format and put procedures in place to ensure that the annual operating budget as well as interim budget modifications are sent to USDA for review and approval. Management to put procedures in place to ensure a self-certification letter is submitted along with the USDA required financial reports. 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