Audit 336457

FY End
2023-12-31
Total Expended
$1.89M
Findings
32
Programs
7
Year: 2023 Accepted: 2025-01-08
Auditor: Rbt Cpa's LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
518138 2023-012 Material Weakness Yes L
518139 2023-012 Material Weakness Yes L
518140 2023-012 Material Weakness Yes L
518141 2023-012 Material Weakness Yes L
518142 2023-012 Material Weakness Yes L
518143 2023-013 Material Weakness Yes G
518144 2023-013 Material Weakness Yes G
518145 2023-013 Material Weakness Yes G
518146 2023-014 Material Weakness Yes H
518147 2023-014 Material Weakness Yes H
518148 2023-014 Material Weakness Yes H
518149 2023-015 Material Weakness Yes I
518150 2023-015 Material Weakness Yes I
518151 2023-015 Material Weakness Yes I
518152 2023-016 Material Weakness - A
518153 2023-016 Material Weakness - A
1094580 2023-012 Material Weakness Yes L
1094581 2023-012 Material Weakness Yes L
1094582 2023-012 Material Weakness Yes L
1094583 2023-012 Material Weakness Yes L
1094584 2023-012 Material Weakness Yes L
1094585 2023-013 Material Weakness Yes G
1094586 2023-013 Material Weakness Yes G
1094587 2023-013 Material Weakness Yes G
1094588 2023-014 Material Weakness Yes H
1094589 2023-014 Material Weakness Yes H
1094590 2023-014 Material Weakness Yes H
1094591 2023-015 Material Weakness Yes I
1094592 2023-015 Material Weakness Yes I
1094593 2023-015 Material Weakness Yes I
1094594 2023-016 Material Weakness - A
1094595 2023-016 Material Weakness - A

Programs

ALN Program Spent Major Findings
16.575 Crime Victim Compensation $240,723 Yes 2
93.788 Opioid Str $167,964 - 0
93.558 Temporary Assistance for Needy Families $83,666 - 0
14.267 Continuum of Care Program $60,880 Yes 4
94.006 Americorps $46,346 - 0
16.588 Violence Against Women Formula Grants $15,921 - 0
10.558 Child and Adult Care Food Program $9,431 - 0

Contacts

Name Title Type
C18RELCPK343 David Rossetti Auditee
5188284619 Tonia Crown, CPA Auditor
No contacts on file

Notes to SEFA

Title: 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: The Organization uses a cost allocation methodology to recover administrative and other shared indirect costs that benefit multiple programs and functions. The Cost Allocation Plan is described in the Organization’s fiscal policies and procedures. The Organization has elected not to use the 10% deminimis Indirect Cost Rate and has not negotiated an Indirect Cost Rate as allowed under the Uniform Guidance applied to overall expenses. The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) includes the federal award activity of Mental Health Association of Columbia-Greene Counties and Subsidiaries under programs of the federal government for the year ended December 31, 2023. Federal awards received directly from the federal agencies as well as federal awards passed through other government agencies are included in the Schedule. 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 (“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 financial position, or cash flows of the Organization.
Title: Matching Costs 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: The Organization uses a cost allocation methodology to recover administrative and other shared indirect costs that benefit multiple programs and functions. The Cost Allocation Plan is described in the Organization’s fiscal policies and procedures. The Organization has elected not to use the 10% deminimis Indirect Cost Rate and has not negotiated an Indirect Cost Rate as allowed under the Uniform Guidance applied to overall expenses. Matching costs (the Organization's share of certain program costs) are not included in the reported expenditures. The basis of accounting varies by federal program consistent with the underlying regulations pertaining to each program. The amounts reported as federal expenditures were obtained from the federal financial reports for the applicable program and periods. The amounts reported in these reports are prepared from records maintained for each program, which are reconciled with the Organization's financial reporting system.
Title: Insurance 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: The Organization uses a cost allocation methodology to recover administrative and other shared indirect costs that benefit multiple programs and functions. The Cost Allocation Plan is described in the Organization’s fiscal policies and procedures. The Organization has elected not to use the 10% deminimis Indirect Cost Rate and has not negotiated an Indirect Cost Rate as allowed under the Uniform Guidance applied to overall expenses. No insurance is carried specifically to cover equipment purchased with federal funds. Any equipment purchased with federal funds has only a nominal value and is covered by the Organization's casualty insurance policies.
Title: Reconciliation to the Financial Statements 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: The Organization uses a cost allocation methodology to recover administrative and other shared indirect costs that benefit multiple programs and functions. The Cost Allocation Plan is described in the Organization’s fiscal policies and procedures. The Organization has elected not to use the 10% deminimis Indirect Cost Rate and has not negotiated an Indirect Cost Rate as allowed under the Uniform Guidance applied to overall expenses. Federal Expenditures as reported in the SEFA of $1,894,357 plus $3,866,508 of grants and other suppot from other non-federal sources equals $5,760,865 revenue of contracts and grants reported in the Consolidated Statements of Activities.

Finding Details

2023-012 Reporting Assistance Listing No.: 14.267 Continuum of Care Program, 16.575 Crime Victims Assistance Condition: The Organization did not prepare a complete Schedule of Expenditures of Federal Awards that was able to be verified and tied to the trial balance. Criteria: The Schedule of Expenditures of Federal Awards ("SEFA") is required under federal regulations to be prepared by the Auditee by funding organization when spending $750,000 or more in federal funds. Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls over the tracking of federal and state expenditures and reconciliations to the general ledger. Effect: The Organization could have expenditures reported on the SEFA that should not be or ones that should have been reported but were not reported on the SEFA. Perspective This is a systemic issue in that controls over the requirement have not been developed to ensure no issues arise Repeat Finding: This is a repeat finding. See finding 2022-014. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management develop a method to track federal grant funds and the use of those funds and reconcile both to the general ledger. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-012 Reporting Assistance Listing No.: 14.267 Continuum of Care Program, 16.575 Crime Victims Assistance Condition: The Organization did not prepare a complete Schedule of Expenditures of Federal Awards that was able to be verified and tied to the trial balance. Criteria: The Schedule of Expenditures of Federal Awards ("SEFA") is required under federal regulations to be prepared by the Auditee by funding organization when spending $750,000 or more in federal funds. Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls over the tracking of federal and state expenditures and reconciliations to the general ledger. Effect: The Organization could have expenditures reported on the SEFA that should not be or ones that should have been reported but were not reported on the SEFA. Perspective This is a systemic issue in that controls over the requirement have not been developed to ensure no issues arise Repeat Finding: This is a repeat finding. See finding 2022-014. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management develop a method to track federal grant funds and the use of those funds and reconcile both to the general ledger. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-012 Reporting Assistance Listing No.: 14.267 Continuum of Care Program, 16.575 Crime Victims Assistance Condition: The Organization did not prepare a complete Schedule of Expenditures of Federal Awards that was able to be verified and tied to the trial balance. Criteria: The Schedule of Expenditures of Federal Awards ("SEFA") is required under federal regulations to be prepared by the Auditee by funding organization when spending $750,000 or more in federal funds. Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls over the tracking of federal and state expenditures and reconciliations to the general ledger. Effect: The Organization could have expenditures reported on the SEFA that should not be or ones that should have been reported but were not reported on the SEFA. Perspective This is a systemic issue in that controls over the requirement have not been developed to ensure no issues arise Repeat Finding: This is a repeat finding. See finding 2022-014. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management develop a method to track federal grant funds and the use of those funds and reconcile both to the general ledger. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-012 Reporting Assistance Listing No.: 14.267 Continuum of Care Program, 16.575 Crime Victims Assistance Condition: The Organization did not prepare a complete Schedule of Expenditures of Federal Awards that was able to be verified and tied to the trial balance. Criteria: The Schedule of Expenditures of Federal Awards ("SEFA") is required under federal regulations to be prepared by the Auditee by funding organization when spending $750,000 or more in federal funds. Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls over the tracking of federal and state expenditures and reconciliations to the general ledger. Effect: The Organization could have expenditures reported on the SEFA that should not be or ones that should have been reported but were not reported on the SEFA. Perspective This is a systemic issue in that controls over the requirement have not been developed to ensure no issues arise Repeat Finding: This is a repeat finding. See finding 2022-014. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management develop a method to track federal grant funds and the use of those funds and reconcile both to the general ledger. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-012 Reporting Assistance Listing No.: 14.267 Continuum of Care Program, 16.575 Crime Victims Assistance Condition: The Organization did not prepare a complete Schedule of Expenditures of Federal Awards that was able to be verified and tied to the trial balance. Criteria: The Schedule of Expenditures of Federal Awards ("SEFA") is required under federal regulations to be prepared by the Auditee by funding organization when spending $750,000 or more in federal funds. Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls over the tracking of federal and state expenditures and reconciliations to the general ledger. Effect: The Organization could have expenditures reported on the SEFA that should not be or ones that should have been reported but were not reported on the SEFA. Perspective This is a systemic issue in that controls over the requirement have not been developed to ensure no issues arise Repeat Finding: This is a repeat finding. See finding 2022-014. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management develop a method to track federal grant funds and the use of those funds and reconcile both to the general ledger. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-013 Matching, Level of Effort, Earmarking Assistance Listing No.: 14.267 Continuum of Care Program (“CoC’) Condition: The Organization was unable to demonstrate controls over the matching and earmarking requirements. Criteria: The recipient or subrecipient must match all grant funds, except for leasing funds, with no less than 25 percent of cash or in-kind contributions from other sources. For CoC geographic areas in which there is more than one grant agreement, the 25 percent match must be provided on a grant-by-grant basis. Recipients that are a UFA or are the sole recipient for their Continuum may provide match on a Continuum-wide basis (24 CFR section 578.73(a)).No more than 10 percent of any grant awarded may be used for paying costs of administering the assistance. Administrative costs include the costs associated with general management oversight, and coordination, training on the CoC program requirements, and environmental review. Administrative costs do not include costs for CoC planning activities and UFA cost (24 CRR section 578.59). Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls to ensure that the matching and earmarking requirements were met. Effect: It is more likely that the Organization will not meet the percent matching requirements and earmarking since there is no formal set of controls over the requirements. Perspective: This is a systemic issue in that controls over the requirements have not been developed to ensure the reported information is accurate Repeat Finding: This is a repeat finding. See finding 2022-016. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management develop a set of controls to ensure that they are meeting 25% match and 10% earmarking requirements. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-013 Matching, Level of Effort, Earmarking Assistance Listing No.: 14.267 Continuum of Care Program (“CoC’) Condition: The Organization was unable to demonstrate controls over the matching and earmarking requirements. Criteria: The recipient or subrecipient must match all grant funds, except for leasing funds, with no less than 25 percent of cash or in-kind contributions from other sources. For CoC geographic areas in which there is more than one grant agreement, the 25 percent match must be provided on a grant-by-grant basis. Recipients that are a UFA or are the sole recipient for their Continuum may provide match on a Continuum-wide basis (24 CFR section 578.73(a)).No more than 10 percent of any grant awarded may be used for paying costs of administering the assistance. Administrative costs include the costs associated with general management oversight, and coordination, training on the CoC program requirements, and environmental review. Administrative costs do not include costs for CoC planning activities and UFA cost (24 CRR section 578.59). Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls to ensure that the matching and earmarking requirements were met. Effect: It is more likely that the Organization will not meet the percent matching requirements and earmarking since there is no formal set of controls over the requirements. Perspective: This is a systemic issue in that controls over the requirements have not been developed to ensure the reported information is accurate Repeat Finding: This is a repeat finding. See finding 2022-016. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management develop a set of controls to ensure that they are meeting 25% match and 10% earmarking requirements. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-013 Matching, Level of Effort, Earmarking Assistance Listing No.: 14.267 Continuum of Care Program (“CoC’) Condition: The Organization was unable to demonstrate controls over the matching and earmarking requirements. Criteria: The recipient or subrecipient must match all grant funds, except for leasing funds, with no less than 25 percent of cash or in-kind contributions from other sources. For CoC geographic areas in which there is more than one grant agreement, the 25 percent match must be provided on a grant-by-grant basis. Recipients that are a UFA or are the sole recipient for their Continuum may provide match on a Continuum-wide basis (24 CFR section 578.73(a)).No more than 10 percent of any grant awarded may be used for paying costs of administering the assistance. Administrative costs include the costs associated with general management oversight, and coordination, training on the CoC program requirements, and environmental review. Administrative costs do not include costs for CoC planning activities and UFA cost (24 CRR section 578.59). Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls to ensure that the matching and earmarking requirements were met. Effect: It is more likely that the Organization will not meet the percent matching requirements and earmarking since there is no formal set of controls over the requirements. Perspective: This is a systemic issue in that controls over the requirements have not been developed to ensure the reported information is accurate Repeat Finding: This is a repeat finding. See finding 2022-016. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management develop a set of controls to ensure that they are meeting 25% match and 10% earmarking requirements. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-014 Period of Performance Assistance Listing No.: 14.267 Continuum of Care Program Condition: The Organization was unable to demonstrate consistent controls over the period of performance requirement. Criteria: The requirements for the period of performance are contained in 2 CFR section 200.1 Definitions for “budget period,” “financial obligations,” “period of performance,” 2 CFR section 200.308 (revision of budget and program plans), 2 CFR section 200.309 (modifications to period of performance), 2 CFR section 200.344 (closeout), program legislation, federal awarding agency regulations; and the terms and conditions of the award. Questioned Costs There are no questioned costs. Cause: The Organization did not have good controls on ensuring the period of performance requirement was met due to staff turn over. Effect: The Organization could have grant expenditures outside the grant period. Perspective: Thirty-one of forty items selected for testing did not have documentation of the control over compliance with the period of performance requirement. Repeat Finding: This is a repeat finding. See finding 2022-017. Recommendation: In order to prevent future occurences of this deficiency, we recommend that management expand controls to ensure that they are able to demonstrate that all expenses meet their procurement policy. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-014 Period of Performance Assistance Listing No.: 14.267 Continuum of Care Program Condition: The Organization was unable to demonstrate consistent controls over the period of performance requirement. Criteria: The requirements for the period of performance are contained in 2 CFR section 200.1 Definitions for “budget period,” “financial obligations,” “period of performance,” 2 CFR section 200.308 (revision of budget and program plans), 2 CFR section 200.309 (modifications to period of performance), 2 CFR section 200.344 (closeout), program legislation, federal awarding agency regulations; and the terms and conditions of the award. Questioned Costs There are no questioned costs. Cause: The Organization did not have good controls on ensuring the period of performance requirement was met due to staff turn over. Effect: The Organization could have grant expenditures outside the grant period. Perspective: Thirty-one of forty items selected for testing did not have documentation of the control over compliance with the period of performance requirement. Repeat Finding: This is a repeat finding. See finding 2022-017. Recommendation: In order to prevent future occurences of this deficiency, we recommend that management expand controls to ensure that they are able to demonstrate that all expenses meet their procurement policy. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-014 Period of Performance Assistance Listing No.: 14.267 Continuum of Care Program Condition: The Organization was unable to demonstrate consistent controls over the period of performance requirement. Criteria: The requirements for the period of performance are contained in 2 CFR section 200.1 Definitions for “budget period,” “financial obligations,” “period of performance,” 2 CFR section 200.308 (revision of budget and program plans), 2 CFR section 200.309 (modifications to period of performance), 2 CFR section 200.344 (closeout), program legislation, federal awarding agency regulations; and the terms and conditions of the award. Questioned Costs There are no questioned costs. Cause: The Organization did not have good controls on ensuring the period of performance requirement was met due to staff turn over. Effect: The Organization could have grant expenditures outside the grant period. Perspective: Thirty-one of forty items selected for testing did not have documentation of the control over compliance with the period of performance requirement. Repeat Finding: This is a repeat finding. See finding 2022-017. Recommendation: In order to prevent future occurences of this deficiency, we recommend that management expand controls to ensure that they are able to demonstrate that all expenses meet their procurement policy. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-015 Procurement and Suspension and Debarment Assistance Listing No.: 14.267 Continuum of Care Program Condition: The Organization was unable to demonstrate consistent controls over the procurement requirement. Criteria: The requirements that apply to procurement under grants and cooperative agreements are contained in 2 CFR sections 200.317 through 200.326, program legislation, federal awarding agency regulations, and the terms and conditions of the award. The requirements that apply to procurement under cost-reimbursement contracts under the FAR are contained in 48 CFR parts 03, 15, 44 and the clauses at 48 CFR sections 52.244-2, 52.244-5, 52.203-13, 52.203- 16, and 52.215-12; agency FAR Supplements; and the terms and conditions of the contract. Questioned Costs There is no questioned cost. Cause: The Organization did not have sufficient controls to ensure that the procurement requirement was met due to staff turnover. Effect: The Organization could have expenditures that were paid that did not meet its own procurement policy. Perspective: Thirty-one of the forty items selected for testing did not have documentation of the control over compliance with the procurement and suspension and debartment requirement. Repeat Finding: This is a repeat finding. See finding 2022-018. Recommendation: In order to prevent future occurences of this deficiency, we recommend that management expand controls to ensure that they are able to demonstrate that all expenses meet their procurement policy. Auditee Response: The Organization agrees with the finding. See attached corrective action plan.
2023-015 Procurement and Suspension and Debarment Assistance Listing No.: 14.267 Continuum of Care Program Condition: The Organization was unable to demonstrate consistent controls over the procurement requirement. Criteria: The requirements that apply to procurement under grants and cooperative agreements are contained in 2 CFR sections 200.317 through 200.326, program legislation, federal awarding agency regulations, and the terms and conditions of the award. The requirements that apply to procurement under cost-reimbursement contracts under the FAR are contained in 48 CFR parts 03, 15, 44 and the clauses at 48 CFR sections 52.244-2, 52.244-5, 52.203-13, 52.203- 16, and 52.215-12; agency FAR Supplements; and the terms and conditions of the contract. Questioned Costs There is no questioned cost. Cause: The Organization did not have sufficient controls to ensure that the procurement requirement was met due to staff turnover. Effect: The Organization could have expenditures that were paid that did not meet its own procurement policy. Perspective: Thirty-one of the forty items selected for testing did not have documentation of the control over compliance with the procurement and suspension and debartment requirement. Repeat Finding: This is a repeat finding. See finding 2022-018. Recommendation: In order to prevent future occurences of this deficiency, we recommend that management expand controls to ensure that they are able to demonstrate that all expenses meet their procurement policy. Auditee Response: The Organization agrees with the finding. See attached corrective action plan.
2023-015 Procurement and Suspension and Debarment Assistance Listing No.: 14.267 Continuum of Care Program Condition: The Organization was unable to demonstrate consistent controls over the procurement requirement. Criteria: The requirements that apply to procurement under grants and cooperative agreements are contained in 2 CFR sections 200.317 through 200.326, program legislation, federal awarding agency regulations, and the terms and conditions of the award. The requirements that apply to procurement under cost-reimbursement contracts under the FAR are contained in 48 CFR parts 03, 15, 44 and the clauses at 48 CFR sections 52.244-2, 52.244-5, 52.203-13, 52.203- 16, and 52.215-12; agency FAR Supplements; and the terms and conditions of the contract. Questioned Costs There is no questioned cost. Cause: The Organization did not have sufficient controls to ensure that the procurement requirement was met due to staff turnover. Effect: The Organization could have expenditures that were paid that did not meet its own procurement policy. Perspective: Thirty-one of the forty items selected for testing did not have documentation of the control over compliance with the procurement and suspension and debartment requirement. Repeat Finding: This is a repeat finding. See finding 2022-018. Recommendation: In order to prevent future occurences of this deficiency, we recommend that management expand controls to ensure that they are able to demonstrate that all expenses meet their procurement policy. Auditee Response: The Organization agrees with the finding. See attached corrective action plan.
2023-016 Allowable and Unallowable Costs Assistance Listing No.: 16.576 Crime Victims Assistance Condition: The Organization did not have controls over allowable and unallowable costs requirements. Criteria: The expenditures were necessary and reasonable for performance of the federal award and allowable costs under grants and cooperative agreements are contained in 2 CFR sections 200 subpart E. Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls to ensure that the allowable and unallowable costs equirement was met due to staff turnover. Effect: The Organization could have expenditures that were paid that did not meet its own procurement policy and were unallowable under the grant. Perspective: Twenty-seven of the forty items selected for testing did not have documentation of the control over compliance with the allowable and unallowable cost requirement. Repeat Finding: This is not a repeat finding. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management expand controls to ensure that they are able to demonstrate that all expenses meet their procurement policy and are allowable under the grant. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-016 Allowable and Unallowable Costs Assistance Listing No.: 16.576 Crime Victims Assistance Condition: The Organization did not have controls over allowable and unallowable costs requirements. Criteria: The expenditures were necessary and reasonable for performance of the federal award and allowable costs under grants and cooperative agreements are contained in 2 CFR sections 200 subpart E. Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls to ensure that the allowable and unallowable costs equirement was met due to staff turnover. Effect: The Organization could have expenditures that were paid that did not meet its own procurement policy and were unallowable under the grant. Perspective: Twenty-seven of the forty items selected for testing did not have documentation of the control over compliance with the allowable and unallowable cost requirement. Repeat Finding: This is not a repeat finding. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management expand controls to ensure that they are able to demonstrate that all expenses meet their procurement policy and are allowable under the grant. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-012 Reporting Assistance Listing No.: 14.267 Continuum of Care Program, 16.575 Crime Victims Assistance Condition: The Organization did not prepare a complete Schedule of Expenditures of Federal Awards that was able to be verified and tied to the trial balance. Criteria: The Schedule of Expenditures of Federal Awards ("SEFA") is required under federal regulations to be prepared by the Auditee by funding organization when spending $750,000 or more in federal funds. Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls over the tracking of federal and state expenditures and reconciliations to the general ledger. Effect: The Organization could have expenditures reported on the SEFA that should not be or ones that should have been reported but were not reported on the SEFA. Perspective This is a systemic issue in that controls over the requirement have not been developed to ensure no issues arise Repeat Finding: This is a repeat finding. See finding 2022-014. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management develop a method to track federal grant funds and the use of those funds and reconcile both to the general ledger. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-012 Reporting Assistance Listing No.: 14.267 Continuum of Care Program, 16.575 Crime Victims Assistance Condition: The Organization did not prepare a complete Schedule of Expenditures of Federal Awards that was able to be verified and tied to the trial balance. Criteria: The Schedule of Expenditures of Federal Awards ("SEFA") is required under federal regulations to be prepared by the Auditee by funding organization when spending $750,000 or more in federal funds. Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls over the tracking of federal and state expenditures and reconciliations to the general ledger. Effect: The Organization could have expenditures reported on the SEFA that should not be or ones that should have been reported but were not reported on the SEFA. Perspective This is a systemic issue in that controls over the requirement have not been developed to ensure no issues arise Repeat Finding: This is a repeat finding. See finding 2022-014. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management develop a method to track federal grant funds and the use of those funds and reconcile both to the general ledger. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-012 Reporting Assistance Listing No.: 14.267 Continuum of Care Program, 16.575 Crime Victims Assistance Condition: The Organization did not prepare a complete Schedule of Expenditures of Federal Awards that was able to be verified and tied to the trial balance. Criteria: The Schedule of Expenditures of Federal Awards ("SEFA") is required under federal regulations to be prepared by the Auditee by funding organization when spending $750,000 or more in federal funds. Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls over the tracking of federal and state expenditures and reconciliations to the general ledger. Effect: The Organization could have expenditures reported on the SEFA that should not be or ones that should have been reported but were not reported on the SEFA. Perspective This is a systemic issue in that controls over the requirement have not been developed to ensure no issues arise Repeat Finding: This is a repeat finding. See finding 2022-014. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management develop a method to track federal grant funds and the use of those funds and reconcile both to the general ledger. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-012 Reporting Assistance Listing No.: 14.267 Continuum of Care Program, 16.575 Crime Victims Assistance Condition: The Organization did not prepare a complete Schedule of Expenditures of Federal Awards that was able to be verified and tied to the trial balance. Criteria: The Schedule of Expenditures of Federal Awards ("SEFA") is required under federal regulations to be prepared by the Auditee by funding organization when spending $750,000 or more in federal funds. Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls over the tracking of federal and state expenditures and reconciliations to the general ledger. Effect: The Organization could have expenditures reported on the SEFA that should not be or ones that should have been reported but were not reported on the SEFA. Perspective This is a systemic issue in that controls over the requirement have not been developed to ensure no issues arise Repeat Finding: This is a repeat finding. See finding 2022-014. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management develop a method to track federal grant funds and the use of those funds and reconcile both to the general ledger. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-012 Reporting Assistance Listing No.: 14.267 Continuum of Care Program, 16.575 Crime Victims Assistance Condition: The Organization did not prepare a complete Schedule of Expenditures of Federal Awards that was able to be verified and tied to the trial balance. Criteria: The Schedule of Expenditures of Federal Awards ("SEFA") is required under federal regulations to be prepared by the Auditee by funding organization when spending $750,000 or more in federal funds. Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls over the tracking of federal and state expenditures and reconciliations to the general ledger. Effect: The Organization could have expenditures reported on the SEFA that should not be or ones that should have been reported but were not reported on the SEFA. Perspective This is a systemic issue in that controls over the requirement have not been developed to ensure no issues arise Repeat Finding: This is a repeat finding. See finding 2022-014. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management develop a method to track federal grant funds and the use of those funds and reconcile both to the general ledger. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-013 Matching, Level of Effort, Earmarking Assistance Listing No.: 14.267 Continuum of Care Program (“CoC’) Condition: The Organization was unable to demonstrate controls over the matching and earmarking requirements. Criteria: The recipient or subrecipient must match all grant funds, except for leasing funds, with no less than 25 percent of cash or in-kind contributions from other sources. For CoC geographic areas in which there is more than one grant agreement, the 25 percent match must be provided on a grant-by-grant basis. Recipients that are a UFA or are the sole recipient for their Continuum may provide match on a Continuum-wide basis (24 CFR section 578.73(a)).No more than 10 percent of any grant awarded may be used for paying costs of administering the assistance. Administrative costs include the costs associated with general management oversight, and coordination, training on the CoC program requirements, and environmental review. Administrative costs do not include costs for CoC planning activities and UFA cost (24 CRR section 578.59). Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls to ensure that the matching and earmarking requirements were met. Effect: It is more likely that the Organization will not meet the percent matching requirements and earmarking since there is no formal set of controls over the requirements. Perspective: This is a systemic issue in that controls over the requirements have not been developed to ensure the reported information is accurate Repeat Finding: This is a repeat finding. See finding 2022-016. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management develop a set of controls to ensure that they are meeting 25% match and 10% earmarking requirements. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-013 Matching, Level of Effort, Earmarking Assistance Listing No.: 14.267 Continuum of Care Program (“CoC’) Condition: The Organization was unable to demonstrate controls over the matching and earmarking requirements. Criteria: The recipient or subrecipient must match all grant funds, except for leasing funds, with no less than 25 percent of cash or in-kind contributions from other sources. For CoC geographic areas in which there is more than one grant agreement, the 25 percent match must be provided on a grant-by-grant basis. Recipients that are a UFA or are the sole recipient for their Continuum may provide match on a Continuum-wide basis (24 CFR section 578.73(a)).No more than 10 percent of any grant awarded may be used for paying costs of administering the assistance. Administrative costs include the costs associated with general management oversight, and coordination, training on the CoC program requirements, and environmental review. Administrative costs do not include costs for CoC planning activities and UFA cost (24 CRR section 578.59). Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls to ensure that the matching and earmarking requirements were met. Effect: It is more likely that the Organization will not meet the percent matching requirements and earmarking since there is no formal set of controls over the requirements. Perspective: This is a systemic issue in that controls over the requirements have not been developed to ensure the reported information is accurate Repeat Finding: This is a repeat finding. See finding 2022-016. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management develop a set of controls to ensure that they are meeting 25% match and 10% earmarking requirements. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-013 Matching, Level of Effort, Earmarking Assistance Listing No.: 14.267 Continuum of Care Program (“CoC’) Condition: The Organization was unable to demonstrate controls over the matching and earmarking requirements. Criteria: The recipient or subrecipient must match all grant funds, except for leasing funds, with no less than 25 percent of cash or in-kind contributions from other sources. For CoC geographic areas in which there is more than one grant agreement, the 25 percent match must be provided on a grant-by-grant basis. Recipients that are a UFA or are the sole recipient for their Continuum may provide match on a Continuum-wide basis (24 CFR section 578.73(a)).No more than 10 percent of any grant awarded may be used for paying costs of administering the assistance. Administrative costs include the costs associated with general management oversight, and coordination, training on the CoC program requirements, and environmental review. Administrative costs do not include costs for CoC planning activities and UFA cost (24 CRR section 578.59). Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls to ensure that the matching and earmarking requirements were met. Effect: It is more likely that the Organization will not meet the percent matching requirements and earmarking since there is no formal set of controls over the requirements. Perspective: This is a systemic issue in that controls over the requirements have not been developed to ensure the reported information is accurate Repeat Finding: This is a repeat finding. See finding 2022-016. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management develop a set of controls to ensure that they are meeting 25% match and 10% earmarking requirements. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-014 Period of Performance Assistance Listing No.: 14.267 Continuum of Care Program Condition: The Organization was unable to demonstrate consistent controls over the period of performance requirement. Criteria: The requirements for the period of performance are contained in 2 CFR section 200.1 Definitions for “budget period,” “financial obligations,” “period of performance,” 2 CFR section 200.308 (revision of budget and program plans), 2 CFR section 200.309 (modifications to period of performance), 2 CFR section 200.344 (closeout), program legislation, federal awarding agency regulations; and the terms and conditions of the award. Questioned Costs There are no questioned costs. Cause: The Organization did not have good controls on ensuring the period of performance requirement was met due to staff turn over. Effect: The Organization could have grant expenditures outside the grant period. Perspective: Thirty-one of forty items selected for testing did not have documentation of the control over compliance with the period of performance requirement. Repeat Finding: This is a repeat finding. See finding 2022-017. Recommendation: In order to prevent future occurences of this deficiency, we recommend that management expand controls to ensure that they are able to demonstrate that all expenses meet their procurement policy. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-014 Period of Performance Assistance Listing No.: 14.267 Continuum of Care Program Condition: The Organization was unable to demonstrate consistent controls over the period of performance requirement. Criteria: The requirements for the period of performance are contained in 2 CFR section 200.1 Definitions for “budget period,” “financial obligations,” “period of performance,” 2 CFR section 200.308 (revision of budget and program plans), 2 CFR section 200.309 (modifications to period of performance), 2 CFR section 200.344 (closeout), program legislation, federal awarding agency regulations; and the terms and conditions of the award. Questioned Costs There are no questioned costs. Cause: The Organization did not have good controls on ensuring the period of performance requirement was met due to staff turn over. Effect: The Organization could have grant expenditures outside the grant period. Perspective: Thirty-one of forty items selected for testing did not have documentation of the control over compliance with the period of performance requirement. Repeat Finding: This is a repeat finding. See finding 2022-017. Recommendation: In order to prevent future occurences of this deficiency, we recommend that management expand controls to ensure that they are able to demonstrate that all expenses meet their procurement policy. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-014 Period of Performance Assistance Listing No.: 14.267 Continuum of Care Program Condition: The Organization was unable to demonstrate consistent controls over the period of performance requirement. Criteria: The requirements for the period of performance are contained in 2 CFR section 200.1 Definitions for “budget period,” “financial obligations,” “period of performance,” 2 CFR section 200.308 (revision of budget and program plans), 2 CFR section 200.309 (modifications to period of performance), 2 CFR section 200.344 (closeout), program legislation, federal awarding agency regulations; and the terms and conditions of the award. Questioned Costs There are no questioned costs. Cause: The Organization did not have good controls on ensuring the period of performance requirement was met due to staff turn over. Effect: The Organization could have grant expenditures outside the grant period. Perspective: Thirty-one of forty items selected for testing did not have documentation of the control over compliance with the period of performance requirement. Repeat Finding: This is a repeat finding. See finding 2022-017. Recommendation: In order to prevent future occurences of this deficiency, we recommend that management expand controls to ensure that they are able to demonstrate that all expenses meet their procurement policy. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-015 Procurement and Suspension and Debarment Assistance Listing No.: 14.267 Continuum of Care Program Condition: The Organization was unable to demonstrate consistent controls over the procurement requirement. Criteria: The requirements that apply to procurement under grants and cooperative agreements are contained in 2 CFR sections 200.317 through 200.326, program legislation, federal awarding agency regulations, and the terms and conditions of the award. The requirements that apply to procurement under cost-reimbursement contracts under the FAR are contained in 48 CFR parts 03, 15, 44 and the clauses at 48 CFR sections 52.244-2, 52.244-5, 52.203-13, 52.203- 16, and 52.215-12; agency FAR Supplements; and the terms and conditions of the contract. Questioned Costs There is no questioned cost. Cause: The Organization did not have sufficient controls to ensure that the procurement requirement was met due to staff turnover. Effect: The Organization could have expenditures that were paid that did not meet its own procurement policy. Perspective: Thirty-one of the forty items selected for testing did not have documentation of the control over compliance with the procurement and suspension and debartment requirement. Repeat Finding: This is a repeat finding. See finding 2022-018. Recommendation: In order to prevent future occurences of this deficiency, we recommend that management expand controls to ensure that they are able to demonstrate that all expenses meet their procurement policy. Auditee Response: The Organization agrees with the finding. See attached corrective action plan.
2023-015 Procurement and Suspension and Debarment Assistance Listing No.: 14.267 Continuum of Care Program Condition: The Organization was unable to demonstrate consistent controls over the procurement requirement. Criteria: The requirements that apply to procurement under grants and cooperative agreements are contained in 2 CFR sections 200.317 through 200.326, program legislation, federal awarding agency regulations, and the terms and conditions of the award. The requirements that apply to procurement under cost-reimbursement contracts under the FAR are contained in 48 CFR parts 03, 15, 44 and the clauses at 48 CFR sections 52.244-2, 52.244-5, 52.203-13, 52.203- 16, and 52.215-12; agency FAR Supplements; and the terms and conditions of the contract. Questioned Costs There is no questioned cost. Cause: The Organization did not have sufficient controls to ensure that the procurement requirement was met due to staff turnover. Effect: The Organization could have expenditures that were paid that did not meet its own procurement policy. Perspective: Thirty-one of the forty items selected for testing did not have documentation of the control over compliance with the procurement and suspension and debartment requirement. Repeat Finding: This is a repeat finding. See finding 2022-018. Recommendation: In order to prevent future occurences of this deficiency, we recommend that management expand controls to ensure that they are able to demonstrate that all expenses meet their procurement policy. Auditee Response: The Organization agrees with the finding. See attached corrective action plan.
2023-015 Procurement and Suspension and Debarment Assistance Listing No.: 14.267 Continuum of Care Program Condition: The Organization was unable to demonstrate consistent controls over the procurement requirement. Criteria: The requirements that apply to procurement under grants and cooperative agreements are contained in 2 CFR sections 200.317 through 200.326, program legislation, federal awarding agency regulations, and the terms and conditions of the award. The requirements that apply to procurement under cost-reimbursement contracts under the FAR are contained in 48 CFR parts 03, 15, 44 and the clauses at 48 CFR sections 52.244-2, 52.244-5, 52.203-13, 52.203- 16, and 52.215-12; agency FAR Supplements; and the terms and conditions of the contract. Questioned Costs There is no questioned cost. Cause: The Organization did not have sufficient controls to ensure that the procurement requirement was met due to staff turnover. Effect: The Organization could have expenditures that were paid that did not meet its own procurement policy. Perspective: Thirty-one of the forty items selected for testing did not have documentation of the control over compliance with the procurement and suspension and debartment requirement. Repeat Finding: This is a repeat finding. See finding 2022-018. Recommendation: In order to prevent future occurences of this deficiency, we recommend that management expand controls to ensure that they are able to demonstrate that all expenses meet their procurement policy. Auditee Response: The Organization agrees with the finding. See attached corrective action plan.
2023-016 Allowable and Unallowable Costs Assistance Listing No.: 16.576 Crime Victims Assistance Condition: The Organization did not have controls over allowable and unallowable costs requirements. Criteria: The expenditures were necessary and reasonable for performance of the federal award and allowable costs under grants and cooperative agreements are contained in 2 CFR sections 200 subpart E. Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls to ensure that the allowable and unallowable costs equirement was met due to staff turnover. Effect: The Organization could have expenditures that were paid that did not meet its own procurement policy and were unallowable under the grant. Perspective: Twenty-seven of the forty items selected for testing did not have documentation of the control over compliance with the allowable and unallowable cost requirement. Repeat Finding: This is not a repeat finding. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management expand controls to ensure that they are able to demonstrate that all expenses meet their procurement policy and are allowable under the grant. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.
2023-016 Allowable and Unallowable Costs Assistance Listing No.: 16.576 Crime Victims Assistance Condition: The Organization did not have controls over allowable and unallowable costs requirements. Criteria: The expenditures were necessary and reasonable for performance of the federal award and allowable costs under grants and cooperative agreements are contained in 2 CFR sections 200 subpart E. Questioned Costs There are no questioned costs. Cause: The Organization did not have sufficient controls to ensure that the allowable and unallowable costs equirement was met due to staff turnover. Effect: The Organization could have expenditures that were paid that did not meet its own procurement policy and were unallowable under the grant. Perspective: Twenty-seven of the forty items selected for testing did not have documentation of the control over compliance with the allowable and unallowable cost requirement. Repeat Finding: This is not a repeat finding. Recommendation: In order to prevent future occurrences of this deficiency, we recommend that management expand controls to ensure that they are able to demonstrate that all expenses meet their procurement policy and are allowable under the grant. Auditee's Response: The Organization agrees with the finding. See attached corrective action plan.