Audit 320076

FY End
2023-12-31
Total Expended
$768,404
Findings
12
Programs
4
Year: 2023 Accepted: 2024-09-19
Auditor: Sikich CPA LLC

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
497352 2023-005 Significant Deficiency - AB
497353 2023-006 Significant Deficiency - AB
497354 2023-005 Significant Deficiency - AB
497355 2023-006 Significant Deficiency - AB
497356 2023-006 Significant Deficiency - AB
497357 2023-006 Significant Deficiency - AB
1073794 2023-005 Significant Deficiency - AB
1073795 2023-006 Significant Deficiency - AB
1073796 2023-005 Significant Deficiency - AB
1073797 2023-006 Significant Deficiency - AB
1073798 2023-006 Significant Deficiency - AB
1073799 2023-006 Significant Deficiency - AB

Contacts

Name Title Type
LNHJMU2BVEM1 Dave Maynard Auditee
3302833020 Lisa Denholm Auditor
No contacts on file

Notes to SEFA

Title: SUBRECIPIENTS Accounting Policies: Basis of Presentation – The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal grant activity of The Well Community Development Corporation and Affiliates (the Organization) under programs of the federal government for the year ended December 31, 2023. The information in this Schedule is presented in accordance with the requirements of the Uniform Guidance. Because the Schedule presents only a selected portion of the operations of the Organization, it is not intended to and does not present the financial position, changes in net assets, functional expenses, or cash flows of the Organization. Basis of Accounting – 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: The Organization did not elect to use the de minimis rate of 10% for the year ended December 31, 2023. The Organization did not provide federal awards to subrecipients during the year ended December 31, 2023.
Title: NON‐CASH ASSISTANCE, LOANS OUTSTANDING, AND INSURANCE Accounting Policies: Basis of Presentation – The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal grant activity of The Well Community Development Corporation and Affiliates (the Organization) under programs of the federal government for the year ended December 31, 2023. The information in this Schedule is presented in accordance with the requirements of the Uniform Guidance. Because the Schedule presents only a selected portion of the operations of the Organization, it is not intended to and does not present the financial position, changes in net assets, functional expenses, or cash flows of the Organization. Basis of Accounting – 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: The Organization did not elect to use the de minimis rate of 10% for the year ended December 31, 2023. The Organization did not receive any federal non‐cash assistance, federal loans or federal insurancefor the year ended December 31, 2023.

Finding Details

Significant Deficiency: Payroll Allocation True Up Related to Construction Management Fees Condition: During our testing of federal expenditures, we noted payroll expenses related to construction management fees were allocated and billed to the federal grant based on the Organization’s budgeted time allocations determined at the beginning of the year with no reconciliation to actual time allocations during 2023. We consider this instance to be a significant deficiency over compliance relating to allowable costs and the cost principles. Criteria: Expenditures charged to the federal grant must follow the cost principles outlined in 2 CFR Part 200, Subpart E including “Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles.” Cause: Internal billings were not updated for actual 2023 payroll allocations and management did not perform reconciliation of budgeted allocations to actual time incurred. Effect: As a result of the deficiency noted, the federal grant could be charged in excess of actual expenditures necessary and reasonable to run the programs. Recommendation: We recommend management review their calculations of payroll allocations for the federal grant on a periodic basis to ensure the amounts being billed to the federal grant are reasonable and in line with actual costs incurred.
Significant Deficiency: Maintain Documentation on Approval of Invoices Related to Federal Expenditures Condition: During our review of controls over expenditures of federal awards, we noted that the program managers review the billing reports, including supporting documentation (vendor invoices) for allowability under the grant agreements and the Uniform Guidance; however, support of their review of the expenditures reported on the SEFA that are unbilled at year-end is not maintained by the Organization. Criteria: The Organization’s internal control system should be properly designed to ensure that allowable costs charged to grants are receiving the appropriate level of oversight and review. Cause: The Organization’s internal control policies require approval of all invoices prior to payment; however, support for these approvals was not maintained by the Organization outside of the program manager’s approval at the time of billing. Effect: Out of a sample of 37 expenditures, we noted 6 did not have support of the required approval by the program manager. Statistical sampling was not used in making sample selections. Our testing did not identify any questioned costs as a result of this deficiency in control. Recommendation: We recommend management implement a process to ensure that documentation on the approval of expenditures be maintained and that the review by the program manager occurs in a timely manner, not just at the time the expenditures are billed to the grantors.
Significant Deficiency: Payroll Allocation True Up Related to Construction Management Fees Condition: During our testing of federal expenditures, we noted payroll expenses related to construction management fees were allocated and billed to the federal grant based on the Organization’s budgeted time allocations determined at the beginning of the year with no reconciliation to actual time allocations during 2023. We consider this instance to be a significant deficiency over compliance relating to allowable costs and the cost principles. Criteria: Expenditures charged to the federal grant must follow the cost principles outlined in 2 CFR Part 200, Subpart E including “Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles.” Cause: Internal billings were not updated for actual 2023 payroll allocations and management did not perform reconciliation of budgeted allocations to actual time incurred. Effect: As a result of the deficiency noted, the federal grant could be charged in excess of actual expenditures necessary and reasonable to run the programs. Recommendation: We recommend management review their calculations of payroll allocations for the federal grant on a periodic basis to ensure the amounts being billed to the federal grant are reasonable and in line with actual costs incurred.
Significant Deficiency: Maintain Documentation on Approval of Invoices Related to Federal Expenditures Condition: During our review of controls over expenditures of federal awards, we noted that the program managers review the billing reports, including supporting documentation (vendor invoices) for allowability under the grant agreements and the Uniform Guidance; however, support of their review of the expenditures reported on the SEFA that are unbilled at year-end is not maintained by the Organization. Criteria: The Organization’s internal control system should be properly designed to ensure that allowable costs charged to grants are receiving the appropriate level of oversight and review. Cause: The Organization’s internal control policies require approval of all invoices prior to payment; however, support for these approvals was not maintained by the Organization outside of the program manager’s approval at the time of billing. Effect: Out of a sample of 37 expenditures, we noted 6 did not have support of the required approval by the program manager. Statistical sampling was not used in making sample selections. Our testing did not identify any questioned costs as a result of this deficiency in control. Recommendation: We recommend management implement a process to ensure that documentation on the approval of expenditures be maintained and that the review by the program manager occurs in a timely manner, not just at the time the expenditures are billed to the grantors.
Significant Deficiency: Maintain Documentation on Approval of Invoices Related to Federal Expenditures Condition: During our review of controls over expenditures of federal awards, we noted that the program managers review the billing reports, including supporting documentation (vendor invoices) for allowability under the grant agreements and the Uniform Guidance; however, support of their review of the expenditures reported on the SEFA that are unbilled at year-end is not maintained by the Organization. Criteria: The Organization’s internal control system should be properly designed to ensure that allowable costs charged to grants are receiving the appropriate level of oversight and review. Cause: The Organization’s internal control policies require approval of all invoices prior to payment; however, support for these approvals was not maintained by the Organization outside of the program manager’s approval at the time of billing. Effect: Out of a sample of 37 expenditures, we noted 6 did not have support of the required approval by the program manager. Statistical sampling was not used in making sample selections. Our testing did not identify any questioned costs as a result of this deficiency in control. Recommendation: We recommend management implement a process to ensure that documentation on the approval of expenditures be maintained and that the review by the program manager occurs in a timely manner, not just at the time the expenditures are billed to the grantors.
Significant Deficiency: Maintain Documentation on Approval of Invoices Related to Federal Expenditures Condition: During our review of controls over expenditures of federal awards, we noted that the program managers review the billing reports, including supporting documentation (vendor invoices) for allowability under the grant agreements and the Uniform Guidance; however, support of their review of the expenditures reported on the SEFA that are unbilled at year-end is not maintained by the Organization. Criteria: The Organization’s internal control system should be properly designed to ensure that allowable costs charged to grants are receiving the appropriate level of oversight and review. Cause: The Organization’s internal control policies require approval of all invoices prior to payment; however, support for these approvals was not maintained by the Organization outside of the program manager’s approval at the time of billing. Effect: Out of a sample of 37 expenditures, we noted 6 did not have support of the required approval by the program manager. Statistical sampling was not used in making sample selections. Our testing did not identify any questioned costs as a result of this deficiency in control. Recommendation: We recommend management implement a process to ensure that documentation on the approval of expenditures be maintained and that the review by the program manager occurs in a timely manner, not just at the time the expenditures are billed to the grantors.
Significant Deficiency: Payroll Allocation True Up Related to Construction Management Fees Condition: During our testing of federal expenditures, we noted payroll expenses related to construction management fees were allocated and billed to the federal grant based on the Organization’s budgeted time allocations determined at the beginning of the year with no reconciliation to actual time allocations during 2023. We consider this instance to be a significant deficiency over compliance relating to allowable costs and the cost principles. Criteria: Expenditures charged to the federal grant must follow the cost principles outlined in 2 CFR Part 200, Subpart E including “Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles.” Cause: Internal billings were not updated for actual 2023 payroll allocations and management did not perform reconciliation of budgeted allocations to actual time incurred. Effect: As a result of the deficiency noted, the federal grant could be charged in excess of actual expenditures necessary and reasonable to run the programs. Recommendation: We recommend management review their calculations of payroll allocations for the federal grant on a periodic basis to ensure the amounts being billed to the federal grant are reasonable and in line with actual costs incurred.
Significant Deficiency: Maintain Documentation on Approval of Invoices Related to Federal Expenditures Condition: During our review of controls over expenditures of federal awards, we noted that the program managers review the billing reports, including supporting documentation (vendor invoices) for allowability under the grant agreements and the Uniform Guidance; however, support of their review of the expenditures reported on the SEFA that are unbilled at year-end is not maintained by the Organization. Criteria: The Organization’s internal control system should be properly designed to ensure that allowable costs charged to grants are receiving the appropriate level of oversight and review. Cause: The Organization’s internal control policies require approval of all invoices prior to payment; however, support for these approvals was not maintained by the Organization outside of the program manager’s approval at the time of billing. Effect: Out of a sample of 37 expenditures, we noted 6 did not have support of the required approval by the program manager. Statistical sampling was not used in making sample selections. Our testing did not identify any questioned costs as a result of this deficiency in control. Recommendation: We recommend management implement a process to ensure that documentation on the approval of expenditures be maintained and that the review by the program manager occurs in a timely manner, not just at the time the expenditures are billed to the grantors.
Significant Deficiency: Payroll Allocation True Up Related to Construction Management Fees Condition: During our testing of federal expenditures, we noted payroll expenses related to construction management fees were allocated and billed to the federal grant based on the Organization’s budgeted time allocations determined at the beginning of the year with no reconciliation to actual time allocations during 2023. We consider this instance to be a significant deficiency over compliance relating to allowable costs and the cost principles. Criteria: Expenditures charged to the federal grant must follow the cost principles outlined in 2 CFR Part 200, Subpart E including “Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles.” Cause: Internal billings were not updated for actual 2023 payroll allocations and management did not perform reconciliation of budgeted allocations to actual time incurred. Effect: As a result of the deficiency noted, the federal grant could be charged in excess of actual expenditures necessary and reasonable to run the programs. Recommendation: We recommend management review their calculations of payroll allocations for the federal grant on a periodic basis to ensure the amounts being billed to the federal grant are reasonable and in line with actual costs incurred.
Significant Deficiency: Maintain Documentation on Approval of Invoices Related to Federal Expenditures Condition: During our review of controls over expenditures of federal awards, we noted that the program managers review the billing reports, including supporting documentation (vendor invoices) for allowability under the grant agreements and the Uniform Guidance; however, support of their review of the expenditures reported on the SEFA that are unbilled at year-end is not maintained by the Organization. Criteria: The Organization’s internal control system should be properly designed to ensure that allowable costs charged to grants are receiving the appropriate level of oversight and review. Cause: The Organization’s internal control policies require approval of all invoices prior to payment; however, support for these approvals was not maintained by the Organization outside of the program manager’s approval at the time of billing. Effect: Out of a sample of 37 expenditures, we noted 6 did not have support of the required approval by the program manager. Statistical sampling was not used in making sample selections. Our testing did not identify any questioned costs as a result of this deficiency in control. Recommendation: We recommend management implement a process to ensure that documentation on the approval of expenditures be maintained and that the review by the program manager occurs in a timely manner, not just at the time the expenditures are billed to the grantors.
Significant Deficiency: Maintain Documentation on Approval of Invoices Related to Federal Expenditures Condition: During our review of controls over expenditures of federal awards, we noted that the program managers review the billing reports, including supporting documentation (vendor invoices) for allowability under the grant agreements and the Uniform Guidance; however, support of their review of the expenditures reported on the SEFA that are unbilled at year-end is not maintained by the Organization. Criteria: The Organization’s internal control system should be properly designed to ensure that allowable costs charged to grants are receiving the appropriate level of oversight and review. Cause: The Organization’s internal control policies require approval of all invoices prior to payment; however, support for these approvals was not maintained by the Organization outside of the program manager’s approval at the time of billing. Effect: Out of a sample of 37 expenditures, we noted 6 did not have support of the required approval by the program manager. Statistical sampling was not used in making sample selections. Our testing did not identify any questioned costs as a result of this deficiency in control. Recommendation: We recommend management implement a process to ensure that documentation on the approval of expenditures be maintained and that the review by the program manager occurs in a timely manner, not just at the time the expenditures are billed to the grantors.
Significant Deficiency: Maintain Documentation on Approval of Invoices Related to Federal Expenditures Condition: During our review of controls over expenditures of federal awards, we noted that the program managers review the billing reports, including supporting documentation (vendor invoices) for allowability under the grant agreements and the Uniform Guidance; however, support of their review of the expenditures reported on the SEFA that are unbilled at year-end is not maintained by the Organization. Criteria: The Organization’s internal control system should be properly designed to ensure that allowable costs charged to grants are receiving the appropriate level of oversight and review. Cause: The Organization’s internal control policies require approval of all invoices prior to payment; however, support for these approvals was not maintained by the Organization outside of the program manager’s approval at the time of billing. Effect: Out of a sample of 37 expenditures, we noted 6 did not have support of the required approval by the program manager. Statistical sampling was not used in making sample selections. Our testing did not identify any questioned costs as a result of this deficiency in control. Recommendation: We recommend management implement a process to ensure that documentation on the approval of expenditures be maintained and that the review by the program manager occurs in a timely manner, not just at the time the expenditures are billed to the grantors.