Audit 47350

FY End
2022-09-30
Total Expended
$16.28M
Findings
10
Programs
20
Year: 2022 Accepted: 2023-06-19

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
48950 2022-001 Material Weakness - B
48951 2022-001 Material Weakness - B
48952 2022-001 Material Weakness - B
48953 2022-001 Material Weakness - B
48954 2022-001 Material Weakness - B
625392 2022-001 Material Weakness - B
625393 2022-001 Material Weakness - B
625394 2022-001 Material Weakness - B
625395 2022-001 Material Weakness - B
625396 2022-001 Material Weakness - B

Programs

ALN Program Spent Major Findings
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $4.64M Yes 1
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $2.91M Yes 1
93.052 National Family Caregiver Support, Title Iii, Part E $1.10M - 0
93.569 Community Services Block Grant $969,914 Yes 1
93.778 Medical Assistance Program $341,398 - 0
93.332 Cooperative Agreement to Support Navigators in Federally-Facilitated and State Partnership Marketplaces $331,354 - 0
93.042 Special Programs for the Aging_title Vii, Chapter 2_long Term Care Ombudsman Services for Older Individuals $320,128 - 0
93.734 Empowering Older Adults and Adults with Disabilities Through Chronic Disease Self-Management Education Programs ? Financed by Prevention and Public Health Funds (pphf) $273,604 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $265,550 - 0
21.023 Emergency Rental Assistance Program $211,663 - 0
93.368 21st Century Cures Act - Precision Medicine Initiative $209,334 - 0
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $160,714 - 0
93.788 Opioid Str $117,705 - 0
93.324 State Health Insurance Assistance Program $106,423 - 0
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $82,920 - 0
93.071 Medicare Enrollment Assistance Program $41,351 - 0
97.024 Emergency Food and Shelter National Board Program $38,111 - 0
93.767 Children's Health Insurance Program $30,488 - 0
93.053 Nutrition Services Incentive Program $30,166 - 0
93.558 Temporary Assistance for Needy Families $5,389 - 0

Contacts

Name Title Type
M613NQYENRM6 Jafferali Jamal Auditee
2148715065 Kim Crawford Auditor
No contacts on file

Notes to SEFA

Title: Match Accounting Policies: The accompanying schedule of expenditures of federal and state awards (Schedule) includes the federal and state grant activity of Community Council of Greater Dallas (Council). 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) and the State of Texas Uniform Grant Management Standards (TxGMS). Because the Schedule presents only a selected portion of the operations of the Council, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the Council. Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles in the Uniform Guidance or the TxGMS, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The Council has not elected to use the 10 percent de minimis indirect cost rateas allowed under the Uniform Guidance. The Council is required to provide 10% or 25% matching funds to fulfill its Aging Cluster contracts, depending on contract type. These matching funds consist of contributions of volunteer hours. The Council claimed the following in matching funds for the following contracts for the year ended December 31, 2022: Special Programs for the Aging: Title III Grants for Supportive Services and Senior Centers $ 675,066 Special Programs for the Aging: Title III, Part C, Nutrition Services 614,137 Total $ 1,289,203

Finding Details

Finding 2022-001: Allowable costs ? material weakness in internal controls over compliance and compliance finding. The Aging Cluster ALN 93.044/93.045 Community Services Block Grant ALN 93.569 The Aging Cluster ? State General Revenue Medical Assistance Program ? State General Revenue Criteria: The Council?s internal control procedures over compliance specify that all employees maintain timesheets and hours and rates per timesheet agree to the payroll register and amount allocated to grant activities. Condition: During allowable costs testing for federal grants, 17 out of 50 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. During allowable costs testing for state grants, 7 out of 25 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. Cause: Prior to May 2023, percentage labor distributions were based on grant budgeted allocations in our payroll system for those employees working out of multiple service categories. Additionally, service category descriptions in the payroll system did not match 100% with the GL service category descriptions. Effect: The Council?s reporting of grant time and effort was not fully documented, in accordance with internal control over compliance procedures. Questioned Costs: None Recommendation: Management should ensure all timesheets are completed and agree to the payroll register before payroll is processed and reimbursement requests for the period are initiated. Management?s Response: See corrective action plan
Finding 2022-001: Allowable costs ? material weakness in internal controls over compliance and compliance finding. The Aging Cluster ALN 93.044/93.045 Community Services Block Grant ALN 93.569 The Aging Cluster ? State General Revenue Medical Assistance Program ? State General Revenue Criteria: The Council?s internal control procedures over compliance specify that all employees maintain timesheets and hours and rates per timesheet agree to the payroll register and amount allocated to grant activities. Condition: During allowable costs testing for federal grants, 17 out of 50 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. During allowable costs testing for state grants, 7 out of 25 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. Cause: Prior to May 2023, percentage labor distributions were based on grant budgeted allocations in our payroll system for those employees working out of multiple service categories. Additionally, service category descriptions in the payroll system did not match 100% with the GL service category descriptions. Effect: The Council?s reporting of grant time and effort was not fully documented, in accordance with internal control over compliance procedures. Questioned Costs: None Recommendation: Management should ensure all timesheets are completed and agree to the payroll register before payroll is processed and reimbursement requests for the period are initiated. Management?s Response: See corrective action plan
Finding 2022-001: Allowable costs ? material weakness in internal controls over compliance and compliance finding. The Aging Cluster ALN 93.044/93.045 Community Services Block Grant ALN 93.569 The Aging Cluster ? State General Revenue Medical Assistance Program ? State General Revenue Criteria: The Council?s internal control procedures over compliance specify that all employees maintain timesheets and hours and rates per timesheet agree to the payroll register and amount allocated to grant activities. Condition: During allowable costs testing for federal grants, 17 out of 50 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. During allowable costs testing for state grants, 7 out of 25 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. Cause: Prior to May 2023, percentage labor distributions were based on grant budgeted allocations in our payroll system for those employees working out of multiple service categories. Additionally, service category descriptions in the payroll system did not match 100% with the GL service category descriptions. Effect: The Council?s reporting of grant time and effort was not fully documented, in accordance with internal control over compliance procedures. Questioned Costs: None Recommendation: Management should ensure all timesheets are completed and agree to the payroll register before payroll is processed and reimbursement requests for the period are initiated. Management?s Response: See corrective action plan
Finding 2022-001: Allowable costs ? material weakness in internal controls over compliance and compliance finding. The Aging Cluster ALN 93.044/93.045 Community Services Block Grant ALN 93.569 The Aging Cluster ? State General Revenue Medical Assistance Program ? State General Revenue Criteria: The Council?s internal control procedures over compliance specify that all employees maintain timesheets and hours and rates per timesheet agree to the payroll register and amount allocated to grant activities. Condition: During allowable costs testing for federal grants, 17 out of 50 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. During allowable costs testing for state grants, 7 out of 25 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. Cause: Prior to May 2023, percentage labor distributions were based on grant budgeted allocations in our payroll system for those employees working out of multiple service categories. Additionally, service category descriptions in the payroll system did not match 100% with the GL service category descriptions. Effect: The Council?s reporting of grant time and effort was not fully documented, in accordance with internal control over compliance procedures. Questioned Costs: None Recommendation: Management should ensure all timesheets are completed and agree to the payroll register before payroll is processed and reimbursement requests for the period are initiated. Management?s Response: See corrective action plan
Finding 2022-001: Allowable costs ? material weakness in internal controls over compliance and compliance finding. The Aging Cluster ALN 93.044/93.045 Community Services Block Grant ALN 93.569 The Aging Cluster ? State General Revenue Medical Assistance Program ? State General Revenue Criteria: The Council?s internal control procedures over compliance specify that all employees maintain timesheets and hours and rates per timesheet agree to the payroll register and amount allocated to grant activities. Condition: During allowable costs testing for federal grants, 17 out of 50 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. During allowable costs testing for state grants, 7 out of 25 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. Cause: Prior to May 2023, percentage labor distributions were based on grant budgeted allocations in our payroll system for those employees working out of multiple service categories. Additionally, service category descriptions in the payroll system did not match 100% with the GL service category descriptions. Effect: The Council?s reporting of grant time and effort was not fully documented, in accordance with internal control over compliance procedures. Questioned Costs: None Recommendation: Management should ensure all timesheets are completed and agree to the payroll register before payroll is processed and reimbursement requests for the period are initiated. Management?s Response: See corrective action plan
Finding 2022-001: Allowable costs ? material weakness in internal controls over compliance and compliance finding. The Aging Cluster ALN 93.044/93.045 Community Services Block Grant ALN 93.569 The Aging Cluster ? State General Revenue Medical Assistance Program ? State General Revenue Criteria: The Council?s internal control procedures over compliance specify that all employees maintain timesheets and hours and rates per timesheet agree to the payroll register and amount allocated to grant activities. Condition: During allowable costs testing for federal grants, 17 out of 50 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. During allowable costs testing for state grants, 7 out of 25 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. Cause: Prior to May 2023, percentage labor distributions were based on grant budgeted allocations in our payroll system for those employees working out of multiple service categories. Additionally, service category descriptions in the payroll system did not match 100% with the GL service category descriptions. Effect: The Council?s reporting of grant time and effort was not fully documented, in accordance with internal control over compliance procedures. Questioned Costs: None Recommendation: Management should ensure all timesheets are completed and agree to the payroll register before payroll is processed and reimbursement requests for the period are initiated. Management?s Response: See corrective action plan
Finding 2022-001: Allowable costs ? material weakness in internal controls over compliance and compliance finding. The Aging Cluster ALN 93.044/93.045 Community Services Block Grant ALN 93.569 The Aging Cluster ? State General Revenue Medical Assistance Program ? State General Revenue Criteria: The Council?s internal control procedures over compliance specify that all employees maintain timesheets and hours and rates per timesheet agree to the payroll register and amount allocated to grant activities. Condition: During allowable costs testing for federal grants, 17 out of 50 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. During allowable costs testing for state grants, 7 out of 25 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. Cause: Prior to May 2023, percentage labor distributions were based on grant budgeted allocations in our payroll system for those employees working out of multiple service categories. Additionally, service category descriptions in the payroll system did not match 100% with the GL service category descriptions. Effect: The Council?s reporting of grant time and effort was not fully documented, in accordance with internal control over compliance procedures. Questioned Costs: None Recommendation: Management should ensure all timesheets are completed and agree to the payroll register before payroll is processed and reimbursement requests for the period are initiated. Management?s Response: See corrective action plan
Finding 2022-001: Allowable costs ? material weakness in internal controls over compliance and compliance finding. The Aging Cluster ALN 93.044/93.045 Community Services Block Grant ALN 93.569 The Aging Cluster ? State General Revenue Medical Assistance Program ? State General Revenue Criteria: The Council?s internal control procedures over compliance specify that all employees maintain timesheets and hours and rates per timesheet agree to the payroll register and amount allocated to grant activities. Condition: During allowable costs testing for federal grants, 17 out of 50 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. During allowable costs testing for state grants, 7 out of 25 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. Cause: Prior to May 2023, percentage labor distributions were based on grant budgeted allocations in our payroll system for those employees working out of multiple service categories. Additionally, service category descriptions in the payroll system did not match 100% with the GL service category descriptions. Effect: The Council?s reporting of grant time and effort was not fully documented, in accordance with internal control over compliance procedures. Questioned Costs: None Recommendation: Management should ensure all timesheets are completed and agree to the payroll register before payroll is processed and reimbursement requests for the period are initiated. Management?s Response: See corrective action plan
Finding 2022-001: Allowable costs ? material weakness in internal controls over compliance and compliance finding. The Aging Cluster ALN 93.044/93.045 Community Services Block Grant ALN 93.569 The Aging Cluster ? State General Revenue Medical Assistance Program ? State General Revenue Criteria: The Council?s internal control procedures over compliance specify that all employees maintain timesheets and hours and rates per timesheet agree to the payroll register and amount allocated to grant activities. Condition: During allowable costs testing for federal grants, 17 out of 50 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. During allowable costs testing for state grants, 7 out of 25 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. Cause: Prior to May 2023, percentage labor distributions were based on grant budgeted allocations in our payroll system for those employees working out of multiple service categories. Additionally, service category descriptions in the payroll system did not match 100% with the GL service category descriptions. Effect: The Council?s reporting of grant time and effort was not fully documented, in accordance with internal control over compliance procedures. Questioned Costs: None Recommendation: Management should ensure all timesheets are completed and agree to the payroll register before payroll is processed and reimbursement requests for the period are initiated. Management?s Response: See corrective action plan
Finding 2022-001: Allowable costs ? material weakness in internal controls over compliance and compliance finding. The Aging Cluster ALN 93.044/93.045 Community Services Block Grant ALN 93.569 The Aging Cluster ? State General Revenue Medical Assistance Program ? State General Revenue Criteria: The Council?s internal control procedures over compliance specify that all employees maintain timesheets and hours and rates per timesheet agree to the payroll register and amount allocated to grant activities. Condition: During allowable costs testing for federal grants, 17 out of 50 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. During allowable costs testing for state grants, 7 out of 25 timesheets tested did not agree to the number of hours worked on the payroll register and subsequently charged to the grant. Cause: Prior to May 2023, percentage labor distributions were based on grant budgeted allocations in our payroll system for those employees working out of multiple service categories. Additionally, service category descriptions in the payroll system did not match 100% with the GL service category descriptions. Effect: The Council?s reporting of grant time and effort was not fully documented, in accordance with internal control over compliance procedures. Questioned Costs: None Recommendation: Management should ensure all timesheets are completed and agree to the payroll register before payroll is processed and reimbursement requests for the period are initiated. Management?s Response: See corrective action plan