Audit 292503

FY End
2021-12-31
Total Expended
$1.08M
Findings
72
Programs
7
Year: 2021 Accepted: 2024-02-27

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
370813 2021-001 Significant Deficiency - L
370814 2021-002 Significant Deficiency - B
370815 2021-003 Significant Deficiency - ABC
370816 2021-004 Significant Deficiency - ABC
370817 2021-001 Significant Deficiency - L
370818 2021-002 Significant Deficiency - B
370819 2021-003 Significant Deficiency - ABC
370820 2021-004 Significant Deficiency - ABC
370821 2021-001 Significant Deficiency - L
370822 2021-002 Significant Deficiency - B
370823 2021-003 Significant Deficiency - ABC
370824 2021-004 Significant Deficiency - ABC
370825 2021-001 Significant Deficiency - L
370826 2021-002 Significant Deficiency - B
370827 2021-003 Significant Deficiency - ABC
370828 2021-004 Significant Deficiency - ABC
370829 2021-001 Significant Deficiency - L
370830 2021-002 Significant Deficiency - B
370831 2021-003 Significant Deficiency - ABC
370832 2021-004 Significant Deficiency - ABC
370833 2021-001 Significant Deficiency - L
370834 2021-002 Significant Deficiency - B
370835 2021-003 Significant Deficiency - ABC
370836 2021-004 Significant Deficiency - ABC
370837 2021-001 Significant Deficiency - L
370838 2021-002 Significant Deficiency - B
370839 2021-003 Significant Deficiency - ABC
370840 2021-004 Significant Deficiency - ABC
370841 2021-001 Significant Deficiency - L
370842 2021-002 Significant Deficiency - B
370843 2021-003 Significant Deficiency - ABC
370844 2021-004 Significant Deficiency - ABC
370845 2021-001 Significant Deficiency - L
370846 2021-002 Significant Deficiency - B
370847 2021-003 Significant Deficiency - ABC
370848 2021-004 Significant Deficiency - ABC
947255 2021-001 Significant Deficiency - L
947256 2021-002 Significant Deficiency - B
947257 2021-003 Significant Deficiency - ABC
947258 2021-004 Significant Deficiency - ABC
947259 2021-001 Significant Deficiency - L
947260 2021-002 Significant Deficiency - B
947261 2021-003 Significant Deficiency - ABC
947262 2021-004 Significant Deficiency - ABC
947263 2021-001 Significant Deficiency - L
947264 2021-002 Significant Deficiency - B
947265 2021-003 Significant Deficiency - ABC
947266 2021-004 Significant Deficiency - ABC
947267 2021-001 Significant Deficiency - L
947268 2021-002 Significant Deficiency - B
947269 2021-003 Significant Deficiency - ABC
947270 2021-004 Significant Deficiency - ABC
947271 2021-001 Significant Deficiency - L
947272 2021-002 Significant Deficiency - B
947273 2021-003 Significant Deficiency - ABC
947274 2021-004 Significant Deficiency - ABC
947275 2021-001 Significant Deficiency - L
947276 2021-002 Significant Deficiency - B
947277 2021-003 Significant Deficiency - ABC
947278 2021-004 Significant Deficiency - ABC
947279 2021-001 Significant Deficiency - L
947280 2021-002 Significant Deficiency - B
947281 2021-003 Significant Deficiency - ABC
947282 2021-004 Significant Deficiency - ABC
947283 2021-001 Significant Deficiency - L
947284 2021-002 Significant Deficiency - B
947285 2021-003 Significant Deficiency - ABC
947286 2021-004 Significant Deficiency - ABC
947287 2021-001 Significant Deficiency - L
947288 2021-002 Significant Deficiency - B
947289 2021-003 Significant Deficiency - ABC
947290 2021-004 Significant Deficiency - ABC

Contacts

Name Title Type
KQ6GEX6EHNE3 Greg Dreveny Auditee
3348722335 Clint Wilkinson Iii, CPA Auditor
No contacts on file

Notes to SEFA

Accounting Policies: The Schedule is presented using the accrual basis of accounting De Minimis Rate Used: Both Rate Explanation: For the major programs Dallas County System of Services uses the de minimis 10% allocation of indirect administrative costs if indirect administrative costs are allowed for the grant. If not allowed for the grant, they are built in the approved grant budget at a rate lower than the 10% allowed.

Finding Details

Type of Finding: Significant weakness in internal control over financials reporting, other matters Condition: The Organization did not file the single audit reporting package within 9 months after the year end. In addition, the Organization did not file annual audited financial statements within the required timeframe, including extensions, 2 CFR 200.512 Criteria: Based on the requirement in 2 CFR 200.512, report submission, the Organization is required to submit single audit reporting package within nine months after the Organization’s year end. Context: The Organization was unaware of the requirements for filing single audit reporting package within 9 months of the Organization’s year end being the first year they were required to have a Single Audit. Cause: Co-vid created a delay in having their annual audit in a timely matter due for both the Organization and the Auditor. Recommendation: We recommend that the organization improve the process for timely financial reporting Planned Corrective Action The organization agrees with the findings and is making every effort to catchup the time of completion of the Data collection form and the audit to be in compliance with financial reporting and single audit requirements.
Type of Finding: Significant weakness in allocation of administrative costs for financial reporting. Condition: For the major programs selected Dallas County System of Services, Inc. uses the de minimis 10% allocation of indirect administrative costs if indirect administrative costs are allowed for the grant. If not allowed for the grant, they are built in the approved grant budget at a rate lower than 10% allowed, so there is no reportable weakness for major programs. For financial reporting, there is no formal explainable allocation of administrative costs which could distort proper allocation of administrative costs. Costs are allocated for the administrative and accounting salaries at the budget level based on estimated time spent on programs and the remaining costs are posted to management and general for the program based on estimated non explainable allocations. Also noted in management and general, some costs that could be considered joint program costs (i.e. rent and occupancy for buildings which program supervisors are located) which could be spread to program costs of the grant based on square footages used by the program. Criteria: Under the Uniform Guidance (2 CFR 200) the organization has elected the 10 percent de minimis cost rate. Normally if the de minimis rate is elected under Uniform Guidance requires that you use the Modified Direct cost as your cost base which the Organization does on its grant budgets for federal costs. However, for financial reporting purposes there is no formal explainable allocation of indirect (administrative) costs which could distort the cost to run each program of the organization. Context: For financial reporting purposes the Organization is still using the same allocation method it used when there were only 4 grants with 1 large grant. With additional grants this allocation method may not be effective, and it is not easily explainable and there is no formal allocation of indirect costs to each program. Cause: Additional grants received by the Organization made the old allocation method not effective and not explainable. Recommendation: Come up with a formal allocation method to allocated indirect costs to each program using an explainable method (i.e. direct program costs to total direct costs) and review posting to administrative costs for joint program costs (i.e. Rent and Occupancy) and spread these costs to programs used based on an explainable method (i.e. square footage of program to total square footage). Planned corrective actions The organization agrees with the findings and will start implementing procedures to make their allocation of indirect costs using an explainable method allowed by uniform guidance and consistent with all programs.
Type of finding: Significant weakness in Internal Controls over cash disbursements. Condition: The Organization’s internal controls require a purchase order and or a check request for all non-payroll cash disbursements. When testing cash disbursements, it was noted this procedure was not always followed; however they did have an overriding control of review of bill, and allowability to budget before any checks were signed. Criteria: Strong internal controls requires authorization and approval of all purchases made by the Organization. Context: The Organization’s internal controls require authorization and approval for all non-payroll cash disbursements but they were not always followed. Cause Not following all the authorization and approval could allow an improper payment to be made. Recommendation: Require all non-payroll purchases to have a purchase order and/or a check request. Planned corrective actions: The Organization had implemented a new purchase order system and have simplified the check requests to make it easier to follow and will use for all non payroll, and non reoccurring purchases.
Type of finding: Lack of separation of duties Condition- Given the Organizations small size and limited staff created challenges in achieving robust segregation of duties especially within the disbursements and payroll process. Criteria: Proper segregation of duties is essential for minimizing errors, preventing fraud, and maintaining financial integrity within the Organization. Cause: Limited number of staff Recommendation: The organization needs to spread the duties to best separate the duties of authorizing the transaction, from entering the transaction, from paying the transaction, from reconciling the transaction, from reporting the transaction. Planned Corrective Action The organization agrees with the finding and has hired a new employee to separate the payroll from the disbursement and to further separate the duties of authorization, from data entry, to payment, from reconciling, and will perform additional overriding controls for timely reviewing the monthly reports.
Type of Finding: Significant weakness in internal control over financials reporting, other matters Condition: The Organization did not file the single audit reporting package within 9 months after the year end. In addition, the Organization did not file annual audited financial statements within the required timeframe, including extensions, 2 CFR 200.512 Criteria: Based on the requirement in 2 CFR 200.512, report submission, the Organization is required to submit single audit reporting package within nine months after the Organization’s year end. Context: The Organization was unaware of the requirements for filing single audit reporting package within 9 months of the Organization’s year end being the first year they were required to have a Single Audit. Cause: Co-vid created a delay in having their annual audit in a timely matter due for both the Organization and the Auditor. Recommendation: We recommend that the organization improve the process for timely financial reporting Planned Corrective Action The organization agrees with the findings and is making every effort to catchup the time of completion of the Data collection form and the audit to be in compliance with financial reporting and single audit requirements.
Type of Finding: Significant weakness in allocation of administrative costs for financial reporting. Condition: For the major programs selected Dallas County System of Services, Inc. uses the de minimis 10% allocation of indirect administrative costs if indirect administrative costs are allowed for the grant. If not allowed for the grant, they are built in the approved grant budget at a rate lower than 10% allowed, so there is no reportable weakness for major programs. For financial reporting, there is no formal explainable allocation of administrative costs which could distort proper allocation of administrative costs. Costs are allocated for the administrative and accounting salaries at the budget level based on estimated time spent on programs and the remaining costs are posted to management and general for the program based on estimated non explainable allocations. Also noted in management and general, some costs that could be considered joint program costs (i.e. rent and occupancy for buildings which program supervisors are located) which could be spread to program costs of the grant based on square footages used by the program. Criteria: Under the Uniform Guidance (2 CFR 200) the organization has elected the 10 percent de minimis cost rate. Normally if the de minimis rate is elected under Uniform Guidance requires that you use the Modified Direct cost as your cost base which the Organization does on its grant budgets for federal costs. However, for financial reporting purposes there is no formal explainable allocation of indirect (administrative) costs which could distort the cost to run each program of the organization. Context: For financial reporting purposes the Organization is still using the same allocation method it used when there were only 4 grants with 1 large grant. With additional grants this allocation method may not be effective, and it is not easily explainable and there is no formal allocation of indirect costs to each program. Cause: Additional grants received by the Organization made the old allocation method not effective and not explainable. Recommendation: Come up with a formal allocation method to allocated indirect costs to each program using an explainable method (i.e. direct program costs to total direct costs) and review posting to administrative costs for joint program costs (i.e. Rent and Occupancy) and spread these costs to programs used based on an explainable method (i.e. square footage of program to total square footage). Planned corrective actions The organization agrees with the findings and will start implementing procedures to make their allocation of indirect costs using an explainable method allowed by uniform guidance and consistent with all programs.
Type of finding: Significant weakness in Internal Controls over cash disbursements. Condition: The Organization’s internal controls require a purchase order and or a check request for all non-payroll cash disbursements. When testing cash disbursements, it was noted this procedure was not always followed; however they did have an overriding control of review of bill, and allowability to budget before any checks were signed. Criteria: Strong internal controls requires authorization and approval of all purchases made by the Organization. Context: The Organization’s internal controls require authorization and approval for all non-payroll cash disbursements but they were not always followed. Cause Not following all the authorization and approval could allow an improper payment to be made. Recommendation: Require all non-payroll purchases to have a purchase order and/or a check request. Planned corrective actions: The Organization had implemented a new purchase order system and have simplified the check requests to make it easier to follow and will use for all non payroll, and non reoccurring purchases.
Type of finding: Lack of separation of duties Condition- Given the Organizations small size and limited staff created challenges in achieving robust segregation of duties especially within the disbursements and payroll process. Criteria: Proper segregation of duties is essential for minimizing errors, preventing fraud, and maintaining financial integrity within the Organization. Cause: Limited number of staff Recommendation: The organization needs to spread the duties to best separate the duties of authorizing the transaction, from entering the transaction, from paying the transaction, from reconciling the transaction, from reporting the transaction. Planned Corrective Action The organization agrees with the finding and has hired a new employee to separate the payroll from the disbursement and to further separate the duties of authorization, from data entry, to payment, from reconciling, and will perform additional overriding controls for timely reviewing the monthly reports.
Type of Finding: Significant weakness in internal control over financials reporting, other matters Condition: The Organization did not file the single audit reporting package within 9 months after the year end. In addition, the Organization did not file annual audited financial statements within the required timeframe, including extensions, 2 CFR 200.512 Criteria: Based on the requirement in 2 CFR 200.512, report submission, the Organization is required to submit single audit reporting package within nine months after the Organization’s year end. Context: The Organization was unaware of the requirements for filing single audit reporting package within 9 months of the Organization’s year end being the first year they were required to have a Single Audit. Cause: Co-vid created a delay in having their annual audit in a timely matter due for both the Organization and the Auditor. Recommendation: We recommend that the organization improve the process for timely financial reporting Planned Corrective Action The organization agrees with the findings and is making every effort to catchup the time of completion of the Data collection form and the audit to be in compliance with financial reporting and single audit requirements.
Type of Finding: Significant weakness in allocation of administrative costs for financial reporting. Condition: For the major programs selected Dallas County System of Services, Inc. uses the de minimis 10% allocation of indirect administrative costs if indirect administrative costs are allowed for the grant. If not allowed for the grant, they are built in the approved grant budget at a rate lower than 10% allowed, so there is no reportable weakness for major programs. For financial reporting, there is no formal explainable allocation of administrative costs which could distort proper allocation of administrative costs. Costs are allocated for the administrative and accounting salaries at the budget level based on estimated time spent on programs and the remaining costs are posted to management and general for the program based on estimated non explainable allocations. Also noted in management and general, some costs that could be considered joint program costs (i.e. rent and occupancy for buildings which program supervisors are located) which could be spread to program costs of the grant based on square footages used by the program. Criteria: Under the Uniform Guidance (2 CFR 200) the organization has elected the 10 percent de minimis cost rate. Normally if the de minimis rate is elected under Uniform Guidance requires that you use the Modified Direct cost as your cost base which the Organization does on its grant budgets for federal costs. However, for financial reporting purposes there is no formal explainable allocation of indirect (administrative) costs which could distort the cost to run each program of the organization. Context: For financial reporting purposes the Organization is still using the same allocation method it used when there were only 4 grants with 1 large grant. With additional grants this allocation method may not be effective, and it is not easily explainable and there is no formal allocation of indirect costs to each program. Cause: Additional grants received by the Organization made the old allocation method not effective and not explainable. Recommendation: Come up with a formal allocation method to allocated indirect costs to each program using an explainable method (i.e. direct program costs to total direct costs) and review posting to administrative costs for joint program costs (i.e. Rent and Occupancy) and spread these costs to programs used based on an explainable method (i.e. square footage of program to total square footage). Planned corrective actions The organization agrees with the findings and will start implementing procedures to make their allocation of indirect costs using an explainable method allowed by uniform guidance and consistent with all programs.
Type of finding: Significant weakness in Internal Controls over cash disbursements. Condition: The Organization’s internal controls require a purchase order and or a check request for all non-payroll cash disbursements. When testing cash disbursements, it was noted this procedure was not always followed; however they did have an overriding control of review of bill, and allowability to budget before any checks were signed. Criteria: Strong internal controls requires authorization and approval of all purchases made by the Organization. Context: The Organization’s internal controls require authorization and approval for all non-payroll cash disbursements but they were not always followed. Cause Not following all the authorization and approval could allow an improper payment to be made. Recommendation: Require all non-payroll purchases to have a purchase order and/or a check request. Planned corrective actions: The Organization had implemented a new purchase order system and have simplified the check requests to make it easier to follow and will use for all non payroll, and non reoccurring purchases.
Type of finding: Lack of separation of duties Condition- Given the Organizations small size and limited staff created challenges in achieving robust segregation of duties especially within the disbursements and payroll process. Criteria: Proper segregation of duties is essential for minimizing errors, preventing fraud, and maintaining financial integrity within the Organization. Cause: Limited number of staff Recommendation: The organization needs to spread the duties to best separate the duties of authorizing the transaction, from entering the transaction, from paying the transaction, from reconciling the transaction, from reporting the transaction. Planned Corrective Action The organization agrees with the finding and has hired a new employee to separate the payroll from the disbursement and to further separate the duties of authorization, from data entry, to payment, from reconciling, and will perform additional overriding controls for timely reviewing the monthly reports.
Type of Finding: Significant weakness in internal control over financials reporting, other matters Condition: The Organization did not file the single audit reporting package within 9 months after the year end. In addition, the Organization did not file annual audited financial statements within the required timeframe, including extensions, 2 CFR 200.512 Criteria: Based on the requirement in 2 CFR 200.512, report submission, the Organization is required to submit single audit reporting package within nine months after the Organization’s year end. Context: The Organization was unaware of the requirements for filing single audit reporting package within 9 months of the Organization’s year end being the first year they were required to have a Single Audit. Cause: Co-vid created a delay in having their annual audit in a timely matter due for both the Organization and the Auditor. Recommendation: We recommend that the organization improve the process for timely financial reporting Planned Corrective Action The organization agrees with the findings and is making every effort to catchup the time of completion of the Data collection form and the audit to be in compliance with financial reporting and single audit requirements.
Type of Finding: Significant weakness in allocation of administrative costs for financial reporting. Condition: For the major programs selected Dallas County System of Services, Inc. uses the de minimis 10% allocation of indirect administrative costs if indirect administrative costs are allowed for the grant. If not allowed for the grant, they are built in the approved grant budget at a rate lower than 10% allowed, so there is no reportable weakness for major programs. For financial reporting, there is no formal explainable allocation of administrative costs which could distort proper allocation of administrative costs. Costs are allocated for the administrative and accounting salaries at the budget level based on estimated time spent on programs and the remaining costs are posted to management and general for the program based on estimated non explainable allocations. Also noted in management and general, some costs that could be considered joint program costs (i.e. rent and occupancy for buildings which program supervisors are located) which could be spread to program costs of the grant based on square footages used by the program. Criteria: Under the Uniform Guidance (2 CFR 200) the organization has elected the 10 percent de minimis cost rate. Normally if the de minimis rate is elected under Uniform Guidance requires that you use the Modified Direct cost as your cost base which the Organization does on its grant budgets for federal costs. However, for financial reporting purposes there is no formal explainable allocation of indirect (administrative) costs which could distort the cost to run each program of the organization. Context: For financial reporting purposes the Organization is still using the same allocation method it used when there were only 4 grants with 1 large grant. With additional grants this allocation method may not be effective, and it is not easily explainable and there is no formal allocation of indirect costs to each program. Cause: Additional grants received by the Organization made the old allocation method not effective and not explainable. Recommendation: Come up with a formal allocation method to allocated indirect costs to each program using an explainable method (i.e. direct program costs to total direct costs) and review posting to administrative costs for joint program costs (i.e. Rent and Occupancy) and spread these costs to programs used based on an explainable method (i.e. square footage of program to total square footage). Planned corrective actions The organization agrees with the findings and will start implementing procedures to make their allocation of indirect costs using an explainable method allowed by uniform guidance and consistent with all programs.
Type of finding: Significant weakness in Internal Controls over cash disbursements. Condition: The Organization’s internal controls require a purchase order and or a check request for all non-payroll cash disbursements. When testing cash disbursements, it was noted this procedure was not always followed; however they did have an overriding control of review of bill, and allowability to budget before any checks were signed. Criteria: Strong internal controls requires authorization and approval of all purchases made by the Organization. Context: The Organization’s internal controls require authorization and approval for all non-payroll cash disbursements but they were not always followed. Cause Not following all the authorization and approval could allow an improper payment to be made. Recommendation: Require all non-payroll purchases to have a purchase order and/or a check request. Planned corrective actions: The Organization had implemented a new purchase order system and have simplified the check requests to make it easier to follow and will use for all non payroll, and non reoccurring purchases.
Type of finding: Lack of separation of duties Condition- Given the Organizations small size and limited staff created challenges in achieving robust segregation of duties especially within the disbursements and payroll process. Criteria: Proper segregation of duties is essential for minimizing errors, preventing fraud, and maintaining financial integrity within the Organization. Cause: Limited number of staff Recommendation: The organization needs to spread the duties to best separate the duties of authorizing the transaction, from entering the transaction, from paying the transaction, from reconciling the transaction, from reporting the transaction. Planned Corrective Action The organization agrees with the finding and has hired a new employee to separate the payroll from the disbursement and to further separate the duties of authorization, from data entry, to payment, from reconciling, and will perform additional overriding controls for timely reviewing the monthly reports.
Type of Finding: Significant weakness in internal control over financials reporting, other matters Condition: The Organization did not file the single audit reporting package within 9 months after the year end. In addition, the Organization did not file annual audited financial statements within the required timeframe, including extensions, 2 CFR 200.512 Criteria: Based on the requirement in 2 CFR 200.512, report submission, the Organization is required to submit single audit reporting package within nine months after the Organization’s year end. Context: The Organization was unaware of the requirements for filing single audit reporting package within 9 months of the Organization’s year end being the first year they were required to have a Single Audit. Cause: Co-vid created a delay in having their annual audit in a timely matter due for both the Organization and the Auditor. Recommendation: We recommend that the organization improve the process for timely financial reporting Planned Corrective Action The organization agrees with the findings and is making every effort to catchup the time of completion of the Data collection form and the audit to be in compliance with financial reporting and single audit requirements.
Type of Finding: Significant weakness in allocation of administrative costs for financial reporting. Condition: For the major programs selected Dallas County System of Services, Inc. uses the de minimis 10% allocation of indirect administrative costs if indirect administrative costs are allowed for the grant. If not allowed for the grant, they are built in the approved grant budget at a rate lower than 10% allowed, so there is no reportable weakness for major programs. For financial reporting, there is no formal explainable allocation of administrative costs which could distort proper allocation of administrative costs. Costs are allocated for the administrative and accounting salaries at the budget level based on estimated time spent on programs and the remaining costs are posted to management and general for the program based on estimated non explainable allocations. Also noted in management and general, some costs that could be considered joint program costs (i.e. rent and occupancy for buildings which program supervisors are located) which could be spread to program costs of the grant based on square footages used by the program. Criteria: Under the Uniform Guidance (2 CFR 200) the organization has elected the 10 percent de minimis cost rate. Normally if the de minimis rate is elected under Uniform Guidance requires that you use the Modified Direct cost as your cost base which the Organization does on its grant budgets for federal costs. However, for financial reporting purposes there is no formal explainable allocation of indirect (administrative) costs which could distort the cost to run each program of the organization. Context: For financial reporting purposes the Organization is still using the same allocation method it used when there were only 4 grants with 1 large grant. With additional grants this allocation method may not be effective, and it is not easily explainable and there is no formal allocation of indirect costs to each program. Cause: Additional grants received by the Organization made the old allocation method not effective and not explainable. Recommendation: Come up with a formal allocation method to allocated indirect costs to each program using an explainable method (i.e. direct program costs to total direct costs) and review posting to administrative costs for joint program costs (i.e. Rent and Occupancy) and spread these costs to programs used based on an explainable method (i.e. square footage of program to total square footage). Planned corrective actions The organization agrees with the findings and will start implementing procedures to make their allocation of indirect costs using an explainable method allowed by uniform guidance and consistent with all programs.
Type of finding: Significant weakness in Internal Controls over cash disbursements. Condition: The Organization’s internal controls require a purchase order and or a check request for all non-payroll cash disbursements. When testing cash disbursements, it was noted this procedure was not always followed; however they did have an overriding control of review of bill, and allowability to budget before any checks were signed. Criteria: Strong internal controls requires authorization and approval of all purchases made by the Organization. Context: The Organization’s internal controls require authorization and approval for all non-payroll cash disbursements but they were not always followed. Cause Not following all the authorization and approval could allow an improper payment to be made. Recommendation: Require all non-payroll purchases to have a purchase order and/or a check request. Planned corrective actions: The Organization had implemented a new purchase order system and have simplified the check requests to make it easier to follow and will use for all non payroll, and non reoccurring purchases.
Type of finding: Lack of separation of duties Condition- Given the Organizations small size and limited staff created challenges in achieving robust segregation of duties especially within the disbursements and payroll process. Criteria: Proper segregation of duties is essential for minimizing errors, preventing fraud, and maintaining financial integrity within the Organization. Cause: Limited number of staff Recommendation: The organization needs to spread the duties to best separate the duties of authorizing the transaction, from entering the transaction, from paying the transaction, from reconciling the transaction, from reporting the transaction. Planned Corrective Action The organization agrees with the finding and has hired a new employee to separate the payroll from the disbursement and to further separate the duties of authorization, from data entry, to payment, from reconciling, and will perform additional overriding controls for timely reviewing the monthly reports.
Type of Finding: Significant weakness in internal control over financials reporting, other matters Condition: The Organization did not file the single audit reporting package within 9 months after the year end. In addition, the Organization did not file annual audited financial statements within the required timeframe, including extensions, 2 CFR 200.512 Criteria: Based on the requirement in 2 CFR 200.512, report submission, the Organization is required to submit single audit reporting package within nine months after the Organization’s year end. Context: The Organization was unaware of the requirements for filing single audit reporting package within 9 months of the Organization’s year end being the first year they were required to have a Single Audit. Cause: Co-vid created a delay in having their annual audit in a timely matter due for both the Organization and the Auditor. Recommendation: We recommend that the organization improve the process for timely financial reporting Planned Corrective Action The organization agrees with the findings and is making every effort to catchup the time of completion of the Data collection form and the audit to be in compliance with financial reporting and single audit requirements.
Type of Finding: Significant weakness in allocation of administrative costs for financial reporting. Condition: For the major programs selected Dallas County System of Services, Inc. uses the de minimis 10% allocation of indirect administrative costs if indirect administrative costs are allowed for the grant. If not allowed for the grant, they are built in the approved grant budget at a rate lower than 10% allowed, so there is no reportable weakness for major programs. For financial reporting, there is no formal explainable allocation of administrative costs which could distort proper allocation of administrative costs. Costs are allocated for the administrative and accounting salaries at the budget level based on estimated time spent on programs and the remaining costs are posted to management and general for the program based on estimated non explainable allocations. Also noted in management and general, some costs that could be considered joint program costs (i.e. rent and occupancy for buildings which program supervisors are located) which could be spread to program costs of the grant based on square footages used by the program. Criteria: Under the Uniform Guidance (2 CFR 200) the organization has elected the 10 percent de minimis cost rate. Normally if the de minimis rate is elected under Uniform Guidance requires that you use the Modified Direct cost as your cost base which the Organization does on its grant budgets for federal costs. However, for financial reporting purposes there is no formal explainable allocation of indirect (administrative) costs which could distort the cost to run each program of the organization. Context: For financial reporting purposes the Organization is still using the same allocation method it used when there were only 4 grants with 1 large grant. With additional grants this allocation method may not be effective, and it is not easily explainable and there is no formal allocation of indirect costs to each program. Cause: Additional grants received by the Organization made the old allocation method not effective and not explainable. Recommendation: Come up with a formal allocation method to allocated indirect costs to each program using an explainable method (i.e. direct program costs to total direct costs) and review posting to administrative costs for joint program costs (i.e. Rent and Occupancy) and spread these costs to programs used based on an explainable method (i.e. square footage of program to total square footage). Planned corrective actions The organization agrees with the findings and will start implementing procedures to make their allocation of indirect costs using an explainable method allowed by uniform guidance and consistent with all programs.
Type of finding: Significant weakness in Internal Controls over cash disbursements. Condition: The Organization’s internal controls require a purchase order and or a check request for all non-payroll cash disbursements. When testing cash disbursements, it was noted this procedure was not always followed; however they did have an overriding control of review of bill, and allowability to budget before any checks were signed. Criteria: Strong internal controls requires authorization and approval of all purchases made by the Organization. Context: The Organization’s internal controls require authorization and approval for all non-payroll cash disbursements but they were not always followed. Cause Not following all the authorization and approval could allow an improper payment to be made. Recommendation: Require all non-payroll purchases to have a purchase order and/or a check request. Planned corrective actions: The Organization had implemented a new purchase order system and have simplified the check requests to make it easier to follow and will use for all non payroll, and non reoccurring purchases.
Type of finding: Lack of separation of duties Condition- Given the Organizations small size and limited staff created challenges in achieving robust segregation of duties especially within the disbursements and payroll process. Criteria: Proper segregation of duties is essential for minimizing errors, preventing fraud, and maintaining financial integrity within the Organization. Cause: Limited number of staff Recommendation: The organization needs to spread the duties to best separate the duties of authorizing the transaction, from entering the transaction, from paying the transaction, from reconciling the transaction, from reporting the transaction. Planned Corrective Action The organization agrees with the finding and has hired a new employee to separate the payroll from the disbursement and to further separate the duties of authorization, from data entry, to payment, from reconciling, and will perform additional overriding controls for timely reviewing the monthly reports.
Type of Finding: Significant weakness in internal control over financials reporting, other matters Condition: The Organization did not file the single audit reporting package within 9 months after the year end. In addition, the Organization did not file annual audited financial statements within the required timeframe, including extensions, 2 CFR 200.512 Criteria: Based on the requirement in 2 CFR 200.512, report submission, the Organization is required to submit single audit reporting package within nine months after the Organization’s year end. Context: The Organization was unaware of the requirements for filing single audit reporting package within 9 months of the Organization’s year end being the first year they were required to have a Single Audit. Cause: Co-vid created a delay in having their annual audit in a timely matter due for both the Organization and the Auditor. Recommendation: We recommend that the organization improve the process for timely financial reporting Planned Corrective Action The organization agrees with the findings and is making every effort to catchup the time of completion of the Data collection form and the audit to be in compliance with financial reporting and single audit requirements.
Type of Finding: Significant weakness in allocation of administrative costs for financial reporting. Condition: For the major programs selected Dallas County System of Services, Inc. uses the de minimis 10% allocation of indirect administrative costs if indirect administrative costs are allowed for the grant. If not allowed for the grant, they are built in the approved grant budget at a rate lower than 10% allowed, so there is no reportable weakness for major programs. For financial reporting, there is no formal explainable allocation of administrative costs which could distort proper allocation of administrative costs. Costs are allocated for the administrative and accounting salaries at the budget level based on estimated time spent on programs and the remaining costs are posted to management and general for the program based on estimated non explainable allocations. Also noted in management and general, some costs that could be considered joint program costs (i.e. rent and occupancy for buildings which program supervisors are located) which could be spread to program costs of the grant based on square footages used by the program. Criteria: Under the Uniform Guidance (2 CFR 200) the organization has elected the 10 percent de minimis cost rate. Normally if the de minimis rate is elected under Uniform Guidance requires that you use the Modified Direct cost as your cost base which the Organization does on its grant budgets for federal costs. However, for financial reporting purposes there is no formal explainable allocation of indirect (administrative) costs which could distort the cost to run each program of the organization. Context: For financial reporting purposes the Organization is still using the same allocation method it used when there were only 4 grants with 1 large grant. With additional grants this allocation method may not be effective, and it is not easily explainable and there is no formal allocation of indirect costs to each program. Cause: Additional grants received by the Organization made the old allocation method not effective and not explainable. Recommendation: Come up with a formal allocation method to allocated indirect costs to each program using an explainable method (i.e. direct program costs to total direct costs) and review posting to administrative costs for joint program costs (i.e. Rent and Occupancy) and spread these costs to programs used based on an explainable method (i.e. square footage of program to total square footage). Planned corrective actions The organization agrees with the findings and will start implementing procedures to make their allocation of indirect costs using an explainable method allowed by uniform guidance and consistent with all programs.
Type of finding: Significant weakness in Internal Controls over cash disbursements. Condition: The Organization’s internal controls require a purchase order and or a check request for all non-payroll cash disbursements. When testing cash disbursements, it was noted this procedure was not always followed; however they did have an overriding control of review of bill, and allowability to budget before any checks were signed. Criteria: Strong internal controls requires authorization and approval of all purchases made by the Organization. Context: The Organization’s internal controls require authorization and approval for all non-payroll cash disbursements but they were not always followed. Cause Not following all the authorization and approval could allow an improper payment to be made. Recommendation: Require all non-payroll purchases to have a purchase order and/or a check request. Planned corrective actions: The Organization had implemented a new purchase order system and have simplified the check requests to make it easier to follow and will use for all non payroll, and non reoccurring purchases.
Type of finding: Lack of separation of duties Condition- Given the Organizations small size and limited staff created challenges in achieving robust segregation of duties especially within the disbursements and payroll process. Criteria: Proper segregation of duties is essential for minimizing errors, preventing fraud, and maintaining financial integrity within the Organization. Cause: Limited number of staff Recommendation: The organization needs to spread the duties to best separate the duties of authorizing the transaction, from entering the transaction, from paying the transaction, from reconciling the transaction, from reporting the transaction. Planned Corrective Action The organization agrees with the finding and has hired a new employee to separate the payroll from the disbursement and to further separate the duties of authorization, from data entry, to payment, from reconciling, and will perform additional overriding controls for timely reviewing the monthly reports.
Type of Finding: Significant weakness in internal control over financials reporting, other matters Condition: The Organization did not file the single audit reporting package within 9 months after the year end. In addition, the Organization did not file annual audited financial statements within the required timeframe, including extensions, 2 CFR 200.512 Criteria: Based on the requirement in 2 CFR 200.512, report submission, the Organization is required to submit single audit reporting package within nine months after the Organization’s year end. Context: The Organization was unaware of the requirements for filing single audit reporting package within 9 months of the Organization’s year end being the first year they were required to have a Single Audit. Cause: Co-vid created a delay in having their annual audit in a timely matter due for both the Organization and the Auditor. Recommendation: We recommend that the organization improve the process for timely financial reporting Planned Corrective Action The organization agrees with the findings and is making every effort to catchup the time of completion of the Data collection form and the audit to be in compliance with financial reporting and single audit requirements.
Type of Finding: Significant weakness in allocation of administrative costs for financial reporting. Condition: For the major programs selected Dallas County System of Services, Inc. uses the de minimis 10% allocation of indirect administrative costs if indirect administrative costs are allowed for the grant. If not allowed for the grant, they are built in the approved grant budget at a rate lower than 10% allowed, so there is no reportable weakness for major programs. For financial reporting, there is no formal explainable allocation of administrative costs which could distort proper allocation of administrative costs. Costs are allocated for the administrative and accounting salaries at the budget level based on estimated time spent on programs and the remaining costs are posted to management and general for the program based on estimated non explainable allocations. Also noted in management and general, some costs that could be considered joint program costs (i.e. rent and occupancy for buildings which program supervisors are located) which could be spread to program costs of the grant based on square footages used by the program. Criteria: Under the Uniform Guidance (2 CFR 200) the organization has elected the 10 percent de minimis cost rate. Normally if the de minimis rate is elected under Uniform Guidance requires that you use the Modified Direct cost as your cost base which the Organization does on its grant budgets for federal costs. However, for financial reporting purposes there is no formal explainable allocation of indirect (administrative) costs which could distort the cost to run each program of the organization. Context: For financial reporting purposes the Organization is still using the same allocation method it used when there were only 4 grants with 1 large grant. With additional grants this allocation method may not be effective, and it is not easily explainable and there is no formal allocation of indirect costs to each program. Cause: Additional grants received by the Organization made the old allocation method not effective and not explainable. Recommendation: Come up with a formal allocation method to allocated indirect costs to each program using an explainable method (i.e. direct program costs to total direct costs) and review posting to administrative costs for joint program costs (i.e. Rent and Occupancy) and spread these costs to programs used based on an explainable method (i.e. square footage of program to total square footage). Planned corrective actions The organization agrees with the findings and will start implementing procedures to make their allocation of indirect costs using an explainable method allowed by uniform guidance and consistent with all programs.
Type of finding: Significant weakness in Internal Controls over cash disbursements. Condition: The Organization’s internal controls require a purchase order and or a check request for all non-payroll cash disbursements. When testing cash disbursements, it was noted this procedure was not always followed; however they did have an overriding control of review of bill, and allowability to budget before any checks were signed. Criteria: Strong internal controls requires authorization and approval of all purchases made by the Organization. Context: The Organization’s internal controls require authorization and approval for all non-payroll cash disbursements but they were not always followed. Cause Not following all the authorization and approval could allow an improper payment to be made. Recommendation: Require all non-payroll purchases to have a purchase order and/or a check request. Planned corrective actions: The Organization had implemented a new purchase order system and have simplified the check requests to make it easier to follow and will use for all non payroll, and non reoccurring purchases.
Type of finding: Lack of separation of duties Condition- Given the Organizations small size and limited staff created challenges in achieving robust segregation of duties especially within the disbursements and payroll process. Criteria: Proper segregation of duties is essential for minimizing errors, preventing fraud, and maintaining financial integrity within the Organization. Cause: Limited number of staff Recommendation: The organization needs to spread the duties to best separate the duties of authorizing the transaction, from entering the transaction, from paying the transaction, from reconciling the transaction, from reporting the transaction. Planned Corrective Action The organization agrees with the finding and has hired a new employee to separate the payroll from the disbursement and to further separate the duties of authorization, from data entry, to payment, from reconciling, and will perform additional overriding controls for timely reviewing the monthly reports.
Type of Finding: Significant weakness in internal control over financials reporting, other matters Condition: The Organization did not file the single audit reporting package within 9 months after the year end. In addition, the Organization did not file annual audited financial statements within the required timeframe, including extensions, 2 CFR 200.512 Criteria: Based on the requirement in 2 CFR 200.512, report submission, the Organization is required to submit single audit reporting package within nine months after the Organization’s year end. Context: The Organization was unaware of the requirements for filing single audit reporting package within 9 months of the Organization’s year end being the first year they were required to have a Single Audit. Cause: Co-vid created a delay in having their annual audit in a timely matter due for both the Organization and the Auditor. Recommendation: We recommend that the organization improve the process for timely financial reporting Planned Corrective Action The organization agrees with the findings and is making every effort to catchup the time of completion of the Data collection form and the audit to be in compliance with financial reporting and single audit requirements.
Type of Finding: Significant weakness in allocation of administrative costs for financial reporting. Condition: For the major programs selected Dallas County System of Services, Inc. uses the de minimis 10% allocation of indirect administrative costs if indirect administrative costs are allowed for the grant. If not allowed for the grant, they are built in the approved grant budget at a rate lower than 10% allowed, so there is no reportable weakness for major programs. For financial reporting, there is no formal explainable allocation of administrative costs which could distort proper allocation of administrative costs. Costs are allocated for the administrative and accounting salaries at the budget level based on estimated time spent on programs and the remaining costs are posted to management and general for the program based on estimated non explainable allocations. Also noted in management and general, some costs that could be considered joint program costs (i.e. rent and occupancy for buildings which program supervisors are located) which could be spread to program costs of the grant based on square footages used by the program. Criteria: Under the Uniform Guidance (2 CFR 200) the organization has elected the 10 percent de minimis cost rate. Normally if the de minimis rate is elected under Uniform Guidance requires that you use the Modified Direct cost as your cost base which the Organization does on its grant budgets for federal costs. However, for financial reporting purposes there is no formal explainable allocation of indirect (administrative) costs which could distort the cost to run each program of the organization. Context: For financial reporting purposes the Organization is still using the same allocation method it used when there were only 4 grants with 1 large grant. With additional grants this allocation method may not be effective, and it is not easily explainable and there is no formal allocation of indirect costs to each program. Cause: Additional grants received by the Organization made the old allocation method not effective and not explainable. Recommendation: Come up with a formal allocation method to allocated indirect costs to each program using an explainable method (i.e. direct program costs to total direct costs) and review posting to administrative costs for joint program costs (i.e. Rent and Occupancy) and spread these costs to programs used based on an explainable method (i.e. square footage of program to total square footage). Planned corrective actions The organization agrees with the findings and will start implementing procedures to make their allocation of indirect costs using an explainable method allowed by uniform guidance and consistent with all programs.
Type of finding: Significant weakness in Internal Controls over cash disbursements. Condition: The Organization’s internal controls require a purchase order and or a check request for all non-payroll cash disbursements. When testing cash disbursements, it was noted this procedure was not always followed; however they did have an overriding control of review of bill, and allowability to budget before any checks were signed. Criteria: Strong internal controls requires authorization and approval of all purchases made by the Organization. Context: The Organization’s internal controls require authorization and approval for all non-payroll cash disbursements but they were not always followed. Cause Not following all the authorization and approval could allow an improper payment to be made. Recommendation: Require all non-payroll purchases to have a purchase order and/or a check request. Planned corrective actions: The Organization had implemented a new purchase order system and have simplified the check requests to make it easier to follow and will use for all non payroll, and non reoccurring purchases.
Type of finding: Lack of separation of duties Condition- Given the Organizations small size and limited staff created challenges in achieving robust segregation of duties especially within the disbursements and payroll process. Criteria: Proper segregation of duties is essential for minimizing errors, preventing fraud, and maintaining financial integrity within the Organization. Cause: Limited number of staff Recommendation: The organization needs to spread the duties to best separate the duties of authorizing the transaction, from entering the transaction, from paying the transaction, from reconciling the transaction, from reporting the transaction. Planned Corrective Action The organization agrees with the finding and has hired a new employee to separate the payroll from the disbursement and to further separate the duties of authorization, from data entry, to payment, from reconciling, and will perform additional overriding controls for timely reviewing the monthly reports.
Type of Finding: Significant weakness in internal control over financials reporting, other matters Condition: The Organization did not file the single audit reporting package within 9 months after the year end. In addition, the Organization did not file annual audited financial statements within the required timeframe, including extensions, 2 CFR 200.512 Criteria: Based on the requirement in 2 CFR 200.512, report submission, the Organization is required to submit single audit reporting package within nine months after the Organization’s year end. Context: The Organization was unaware of the requirements for filing single audit reporting package within 9 months of the Organization’s year end being the first year they were required to have a Single Audit. Cause: Co-vid created a delay in having their annual audit in a timely matter due for both the Organization and the Auditor. Recommendation: We recommend that the organization improve the process for timely financial reporting Planned Corrective Action The organization agrees with the findings and is making every effort to catchup the time of completion of the Data collection form and the audit to be in compliance with financial reporting and single audit requirements.
Type of Finding: Significant weakness in allocation of administrative costs for financial reporting. Condition: For the major programs selected Dallas County System of Services, Inc. uses the de minimis 10% allocation of indirect administrative costs if indirect administrative costs are allowed for the grant. If not allowed for the grant, they are built in the approved grant budget at a rate lower than 10% allowed, so there is no reportable weakness for major programs. For financial reporting, there is no formal explainable allocation of administrative costs which could distort proper allocation of administrative costs. Costs are allocated for the administrative and accounting salaries at the budget level based on estimated time spent on programs and the remaining costs are posted to management and general for the program based on estimated non explainable allocations. Also noted in management and general, some costs that could be considered joint program costs (i.e. rent and occupancy for buildings which program supervisors are located) which could be spread to program costs of the grant based on square footages used by the program. Criteria: Under the Uniform Guidance (2 CFR 200) the organization has elected the 10 percent de minimis cost rate. Normally if the de minimis rate is elected under Uniform Guidance requires that you use the Modified Direct cost as your cost base which the Organization does on its grant budgets for federal costs. However, for financial reporting purposes there is no formal explainable allocation of indirect (administrative) costs which could distort the cost to run each program of the organization. Context: For financial reporting purposes the Organization is still using the same allocation method it used when there were only 4 grants with 1 large grant. With additional grants this allocation method may not be effective, and it is not easily explainable and there is no formal allocation of indirect costs to each program. Cause: Additional grants received by the Organization made the old allocation method not effective and not explainable. Recommendation: Come up with a formal allocation method to allocated indirect costs to each program using an explainable method (i.e. direct program costs to total direct costs) and review posting to administrative costs for joint program costs (i.e. Rent and Occupancy) and spread these costs to programs used based on an explainable method (i.e. square footage of program to total square footage). Planned corrective actions The organization agrees with the findings and will start implementing procedures to make their allocation of indirect costs using an explainable method allowed by uniform guidance and consistent with all programs.
Type of finding: Significant weakness in Internal Controls over cash disbursements. Condition: The Organization’s internal controls require a purchase order and or a check request for all non-payroll cash disbursements. When testing cash disbursements, it was noted this procedure was not always followed; however they did have an overriding control of review of bill, and allowability to budget before any checks were signed. Criteria: Strong internal controls requires authorization and approval of all purchases made by the Organization. Context: The Organization’s internal controls require authorization and approval for all non-payroll cash disbursements but they were not always followed. Cause Not following all the authorization and approval could allow an improper payment to be made. Recommendation: Require all non-payroll purchases to have a purchase order and/or a check request. Planned corrective actions: The Organization had implemented a new purchase order system and have simplified the check requests to make it easier to follow and will use for all non payroll, and non reoccurring purchases.
Type of finding: Lack of separation of duties Condition- Given the Organizations small size and limited staff created challenges in achieving robust segregation of duties especially within the disbursements and payroll process. Criteria: Proper segregation of duties is essential for minimizing errors, preventing fraud, and maintaining financial integrity within the Organization. Cause: Limited number of staff Recommendation: The organization needs to spread the duties to best separate the duties of authorizing the transaction, from entering the transaction, from paying the transaction, from reconciling the transaction, from reporting the transaction. Planned Corrective Action The organization agrees with the finding and has hired a new employee to separate the payroll from the disbursement and to further separate the duties of authorization, from data entry, to payment, from reconciling, and will perform additional overriding controls for timely reviewing the monthly reports.
Type of Finding: Significant weakness in internal control over financials reporting, other matters Condition: The Organization did not file the single audit reporting package within 9 months after the year end. In addition, the Organization did not file annual audited financial statements within the required timeframe, including extensions, 2 CFR 200.512 Criteria: Based on the requirement in 2 CFR 200.512, report submission, the Organization is required to submit single audit reporting package within nine months after the Organization’s year end. Context: The Organization was unaware of the requirements for filing single audit reporting package within 9 months of the Organization’s year end being the first year they were required to have a Single Audit. Cause: Co-vid created a delay in having their annual audit in a timely matter due for both the Organization and the Auditor. Recommendation: We recommend that the organization improve the process for timely financial reporting Planned Corrective Action The organization agrees with the findings and is making every effort to catchup the time of completion of the Data collection form and the audit to be in compliance with financial reporting and single audit requirements.
Type of Finding: Significant weakness in allocation of administrative costs for financial reporting. Condition: For the major programs selected Dallas County System of Services, Inc. uses the de minimis 10% allocation of indirect administrative costs if indirect administrative costs are allowed for the grant. If not allowed for the grant, they are built in the approved grant budget at a rate lower than 10% allowed, so there is no reportable weakness for major programs. For financial reporting, there is no formal explainable allocation of administrative costs which could distort proper allocation of administrative costs. Costs are allocated for the administrative and accounting salaries at the budget level based on estimated time spent on programs and the remaining costs are posted to management and general for the program based on estimated non explainable allocations. Also noted in management and general, some costs that could be considered joint program costs (i.e. rent and occupancy for buildings which program supervisors are located) which could be spread to program costs of the grant based on square footages used by the program. Criteria: Under the Uniform Guidance (2 CFR 200) the organization has elected the 10 percent de minimis cost rate. Normally if the de minimis rate is elected under Uniform Guidance requires that you use the Modified Direct cost as your cost base which the Organization does on its grant budgets for federal costs. However, for financial reporting purposes there is no formal explainable allocation of indirect (administrative) costs which could distort the cost to run each program of the organization. Context: For financial reporting purposes the Organization is still using the same allocation method it used when there were only 4 grants with 1 large grant. With additional grants this allocation method may not be effective, and it is not easily explainable and there is no formal allocation of indirect costs to each program. Cause: Additional grants received by the Organization made the old allocation method not effective and not explainable. Recommendation: Come up with a formal allocation method to allocated indirect costs to each program using an explainable method (i.e. direct program costs to total direct costs) and review posting to administrative costs for joint program costs (i.e. Rent and Occupancy) and spread these costs to programs used based on an explainable method (i.e. square footage of program to total square footage). Planned corrective actions The organization agrees with the findings and will start implementing procedures to make their allocation of indirect costs using an explainable method allowed by uniform guidance and consistent with all programs.
Type of finding: Significant weakness in Internal Controls over cash disbursements. Condition: The Organization’s internal controls require a purchase order and or a check request for all non-payroll cash disbursements. When testing cash disbursements, it was noted this procedure was not always followed; however they did have an overriding control of review of bill, and allowability to budget before any checks were signed. Criteria: Strong internal controls requires authorization and approval of all purchases made by the Organization. Context: The Organization’s internal controls require authorization and approval for all non-payroll cash disbursements but they were not always followed. Cause Not following all the authorization and approval could allow an improper payment to be made. Recommendation: Require all non-payroll purchases to have a purchase order and/or a check request. Planned corrective actions: The Organization had implemented a new purchase order system and have simplified the check requests to make it easier to follow and will use for all non payroll, and non reoccurring purchases.
Type of finding: Lack of separation of duties Condition- Given the Organizations small size and limited staff created challenges in achieving robust segregation of duties especially within the disbursements and payroll process. Criteria: Proper segregation of duties is essential for minimizing errors, preventing fraud, and maintaining financial integrity within the Organization. Cause: Limited number of staff Recommendation: The organization needs to spread the duties to best separate the duties of authorizing the transaction, from entering the transaction, from paying the transaction, from reconciling the transaction, from reporting the transaction. Planned Corrective Action The organization agrees with the finding and has hired a new employee to separate the payroll from the disbursement and to further separate the duties of authorization, from data entry, to payment, from reconciling, and will perform additional overriding controls for timely reviewing the monthly reports.
Type of Finding: Significant weakness in internal control over financials reporting, other matters Condition: The Organization did not file the single audit reporting package within 9 months after the year end. In addition, the Organization did not file annual audited financial statements within the required timeframe, including extensions, 2 CFR 200.512 Criteria: Based on the requirement in 2 CFR 200.512, report submission, the Organization is required to submit single audit reporting package within nine months after the Organization’s year end. Context: The Organization was unaware of the requirements for filing single audit reporting package within 9 months of the Organization’s year end being the first year they were required to have a Single Audit. Cause: Co-vid created a delay in having their annual audit in a timely matter due for both the Organization and the Auditor. Recommendation: We recommend that the organization improve the process for timely financial reporting Planned Corrective Action The organization agrees with the findings and is making every effort to catchup the time of completion of the Data collection form and the audit to be in compliance with financial reporting and single audit requirements.
Type of Finding: Significant weakness in allocation of administrative costs for financial reporting. Condition: For the major programs selected Dallas County System of Services, Inc. uses the de minimis 10% allocation of indirect administrative costs if indirect administrative costs are allowed for the grant. If not allowed for the grant, they are built in the approved grant budget at a rate lower than 10% allowed, so there is no reportable weakness for major programs. For financial reporting, there is no formal explainable allocation of administrative costs which could distort proper allocation of administrative costs. Costs are allocated for the administrative and accounting salaries at the budget level based on estimated time spent on programs and the remaining costs are posted to management and general for the program based on estimated non explainable allocations. Also noted in management and general, some costs that could be considered joint program costs (i.e. rent and occupancy for buildings which program supervisors are located) which could be spread to program costs of the grant based on square footages used by the program. Criteria: Under the Uniform Guidance (2 CFR 200) the organization has elected the 10 percent de minimis cost rate. Normally if the de minimis rate is elected under Uniform Guidance requires that you use the Modified Direct cost as your cost base which the Organization does on its grant budgets for federal costs. However, for financial reporting purposes there is no formal explainable allocation of indirect (administrative) costs which could distort the cost to run each program of the organization. Context: For financial reporting purposes the Organization is still using the same allocation method it used when there were only 4 grants with 1 large grant. With additional grants this allocation method may not be effective, and it is not easily explainable and there is no formal allocation of indirect costs to each program. Cause: Additional grants received by the Organization made the old allocation method not effective and not explainable. Recommendation: Come up with a formal allocation method to allocated indirect costs to each program using an explainable method (i.e. direct program costs to total direct costs) and review posting to administrative costs for joint program costs (i.e. Rent and Occupancy) and spread these costs to programs used based on an explainable method (i.e. square footage of program to total square footage). Planned corrective actions The organization agrees with the findings and will start implementing procedures to make their allocation of indirect costs using an explainable method allowed by uniform guidance and consistent with all programs.
Type of finding: Significant weakness in Internal Controls over cash disbursements. Condition: The Organization’s internal controls require a purchase order and or a check request for all non-payroll cash disbursements. When testing cash disbursements, it was noted this procedure was not always followed; however they did have an overriding control of review of bill, and allowability to budget before any checks were signed. Criteria: Strong internal controls requires authorization and approval of all purchases made by the Organization. Context: The Organization’s internal controls require authorization and approval for all non-payroll cash disbursements but they were not always followed. Cause Not following all the authorization and approval could allow an improper payment to be made. Recommendation: Require all non-payroll purchases to have a purchase order and/or a check request. Planned corrective actions: The Organization had implemented a new purchase order system and have simplified the check requests to make it easier to follow and will use for all non payroll, and non reoccurring purchases.
Type of finding: Lack of separation of duties Condition- Given the Organizations small size and limited staff created challenges in achieving robust segregation of duties especially within the disbursements and payroll process. Criteria: Proper segregation of duties is essential for minimizing errors, preventing fraud, and maintaining financial integrity within the Organization. Cause: Limited number of staff Recommendation: The organization needs to spread the duties to best separate the duties of authorizing the transaction, from entering the transaction, from paying the transaction, from reconciling the transaction, from reporting the transaction. Planned Corrective Action The organization agrees with the finding and has hired a new employee to separate the payroll from the disbursement and to further separate the duties of authorization, from data entry, to payment, from reconciling, and will perform additional overriding controls for timely reviewing the monthly reports.
Type of Finding: Significant weakness in internal control over financials reporting, other matters Condition: The Organization did not file the single audit reporting package within 9 months after the year end. In addition, the Organization did not file annual audited financial statements within the required timeframe, including extensions, 2 CFR 200.512 Criteria: Based on the requirement in 2 CFR 200.512, report submission, the Organization is required to submit single audit reporting package within nine months after the Organization’s year end. Context: The Organization was unaware of the requirements for filing single audit reporting package within 9 months of the Organization’s year end being the first year they were required to have a Single Audit. Cause: Co-vid created a delay in having their annual audit in a timely matter due for both the Organization and the Auditor. Recommendation: We recommend that the organization improve the process for timely financial reporting Planned Corrective Action The organization agrees with the findings and is making every effort to catchup the time of completion of the Data collection form and the audit to be in compliance with financial reporting and single audit requirements.
Type of Finding: Significant weakness in allocation of administrative costs for financial reporting. Condition: For the major programs selected Dallas County System of Services, Inc. uses the de minimis 10% allocation of indirect administrative costs if indirect administrative costs are allowed for the grant. If not allowed for the grant, they are built in the approved grant budget at a rate lower than 10% allowed, so there is no reportable weakness for major programs. For financial reporting, there is no formal explainable allocation of administrative costs which could distort proper allocation of administrative costs. Costs are allocated for the administrative and accounting salaries at the budget level based on estimated time spent on programs and the remaining costs are posted to management and general for the program based on estimated non explainable allocations. Also noted in management and general, some costs that could be considered joint program costs (i.e. rent and occupancy for buildings which program supervisors are located) which could be spread to program costs of the grant based on square footages used by the program. Criteria: Under the Uniform Guidance (2 CFR 200) the organization has elected the 10 percent de minimis cost rate. Normally if the de minimis rate is elected under Uniform Guidance requires that you use the Modified Direct cost as your cost base which the Organization does on its grant budgets for federal costs. However, for financial reporting purposes there is no formal explainable allocation of indirect (administrative) costs which could distort the cost to run each program of the organization. Context: For financial reporting purposes the Organization is still using the same allocation method it used when there were only 4 grants with 1 large grant. With additional grants this allocation method may not be effective, and it is not easily explainable and there is no formal allocation of indirect costs to each program. Cause: Additional grants received by the Organization made the old allocation method not effective and not explainable. Recommendation: Come up with a formal allocation method to allocated indirect costs to each program using an explainable method (i.e. direct program costs to total direct costs) and review posting to administrative costs for joint program costs (i.e. Rent and Occupancy) and spread these costs to programs used based on an explainable method (i.e. square footage of program to total square footage). Planned corrective actions The organization agrees with the findings and will start implementing procedures to make their allocation of indirect costs using an explainable method allowed by uniform guidance and consistent with all programs.
Type of finding: Significant weakness in Internal Controls over cash disbursements. Condition: The Organization’s internal controls require a purchase order and or a check request for all non-payroll cash disbursements. When testing cash disbursements, it was noted this procedure was not always followed; however they did have an overriding control of review of bill, and allowability to budget before any checks were signed. Criteria: Strong internal controls requires authorization and approval of all purchases made by the Organization. Context: The Organization’s internal controls require authorization and approval for all non-payroll cash disbursements but they were not always followed. Cause Not following all the authorization and approval could allow an improper payment to be made. Recommendation: Require all non-payroll purchases to have a purchase order and/or a check request. Planned corrective actions: The Organization had implemented a new purchase order system and have simplified the check requests to make it easier to follow and will use for all non payroll, and non reoccurring purchases.
Type of finding: Lack of separation of duties Condition- Given the Organizations small size and limited staff created challenges in achieving robust segregation of duties especially within the disbursements and payroll process. Criteria: Proper segregation of duties is essential for minimizing errors, preventing fraud, and maintaining financial integrity within the Organization. Cause: Limited number of staff Recommendation: The organization needs to spread the duties to best separate the duties of authorizing the transaction, from entering the transaction, from paying the transaction, from reconciling the transaction, from reporting the transaction. Planned Corrective Action The organization agrees with the finding and has hired a new employee to separate the payroll from the disbursement and to further separate the duties of authorization, from data entry, to payment, from reconciling, and will perform additional overriding controls for timely reviewing the monthly reports.
Type of Finding: Significant weakness in internal control over financials reporting, other matters Condition: The Organization did not file the single audit reporting package within 9 months after the year end. In addition, the Organization did not file annual audited financial statements within the required timeframe, including extensions, 2 CFR 200.512 Criteria: Based on the requirement in 2 CFR 200.512, report submission, the Organization is required to submit single audit reporting package within nine months after the Organization’s year end. Context: The Organization was unaware of the requirements for filing single audit reporting package within 9 months of the Organization’s year end being the first year they were required to have a Single Audit. Cause: Co-vid created a delay in having their annual audit in a timely matter due for both the Organization and the Auditor. Recommendation: We recommend that the organization improve the process for timely financial reporting Planned Corrective Action The organization agrees with the findings and is making every effort to catchup the time of completion of the Data collection form and the audit to be in compliance with financial reporting and single audit requirements.
Type of Finding: Significant weakness in allocation of administrative costs for financial reporting. Condition: For the major programs selected Dallas County System of Services, Inc. uses the de minimis 10% allocation of indirect administrative costs if indirect administrative costs are allowed for the grant. If not allowed for the grant, they are built in the approved grant budget at a rate lower than 10% allowed, so there is no reportable weakness for major programs. For financial reporting, there is no formal explainable allocation of administrative costs which could distort proper allocation of administrative costs. Costs are allocated for the administrative and accounting salaries at the budget level based on estimated time spent on programs and the remaining costs are posted to management and general for the program based on estimated non explainable allocations. Also noted in management and general, some costs that could be considered joint program costs (i.e. rent and occupancy for buildings which program supervisors are located) which could be spread to program costs of the grant based on square footages used by the program. Criteria: Under the Uniform Guidance (2 CFR 200) the organization has elected the 10 percent de minimis cost rate. Normally if the de minimis rate is elected under Uniform Guidance requires that you use the Modified Direct cost as your cost base which the Organization does on its grant budgets for federal costs. However, for financial reporting purposes there is no formal explainable allocation of indirect (administrative) costs which could distort the cost to run each program of the organization. Context: For financial reporting purposes the Organization is still using the same allocation method it used when there were only 4 grants with 1 large grant. With additional grants this allocation method may not be effective, and it is not easily explainable and there is no formal allocation of indirect costs to each program. Cause: Additional grants received by the Organization made the old allocation method not effective and not explainable. Recommendation: Come up with a formal allocation method to allocated indirect costs to each program using an explainable method (i.e. direct program costs to total direct costs) and review posting to administrative costs for joint program costs (i.e. Rent and Occupancy) and spread these costs to programs used based on an explainable method (i.e. square footage of program to total square footage). Planned corrective actions The organization agrees with the findings and will start implementing procedures to make their allocation of indirect costs using an explainable method allowed by uniform guidance and consistent with all programs.
Type of finding: Significant weakness in Internal Controls over cash disbursements. Condition: The Organization’s internal controls require a purchase order and or a check request for all non-payroll cash disbursements. When testing cash disbursements, it was noted this procedure was not always followed; however they did have an overriding control of review of bill, and allowability to budget before any checks were signed. Criteria: Strong internal controls requires authorization and approval of all purchases made by the Organization. Context: The Organization’s internal controls require authorization and approval for all non-payroll cash disbursements but they were not always followed. Cause Not following all the authorization and approval could allow an improper payment to be made. Recommendation: Require all non-payroll purchases to have a purchase order and/or a check request. Planned corrective actions: The Organization had implemented a new purchase order system and have simplified the check requests to make it easier to follow and will use for all non payroll, and non reoccurring purchases.
Type of finding: Lack of separation of duties Condition- Given the Organizations small size and limited staff created challenges in achieving robust segregation of duties especially within the disbursements and payroll process. Criteria: Proper segregation of duties is essential for minimizing errors, preventing fraud, and maintaining financial integrity within the Organization. Cause: Limited number of staff Recommendation: The organization needs to spread the duties to best separate the duties of authorizing the transaction, from entering the transaction, from paying the transaction, from reconciling the transaction, from reporting the transaction. Planned Corrective Action The organization agrees with the finding and has hired a new employee to separate the payroll from the disbursement and to further separate the duties of authorization, from data entry, to payment, from reconciling, and will perform additional overriding controls for timely reviewing the monthly reports.
Type of Finding: Significant weakness in internal control over financials reporting, other matters Condition: The Organization did not file the single audit reporting package within 9 months after the year end. In addition, the Organization did not file annual audited financial statements within the required timeframe, including extensions, 2 CFR 200.512 Criteria: Based on the requirement in 2 CFR 200.512, report submission, the Organization is required to submit single audit reporting package within nine months after the Organization’s year end. Context: The Organization was unaware of the requirements for filing single audit reporting package within 9 months of the Organization’s year end being the first year they were required to have a Single Audit. Cause: Co-vid created a delay in having their annual audit in a timely matter due for both the Organization and the Auditor. Recommendation: We recommend that the organization improve the process for timely financial reporting Planned Corrective Action The organization agrees with the findings and is making every effort to catchup the time of completion of the Data collection form and the audit to be in compliance with financial reporting and single audit requirements.
Type of Finding: Significant weakness in allocation of administrative costs for financial reporting. Condition: For the major programs selected Dallas County System of Services, Inc. uses the de minimis 10% allocation of indirect administrative costs if indirect administrative costs are allowed for the grant. If not allowed for the grant, they are built in the approved grant budget at a rate lower than 10% allowed, so there is no reportable weakness for major programs. For financial reporting, there is no formal explainable allocation of administrative costs which could distort proper allocation of administrative costs. Costs are allocated for the administrative and accounting salaries at the budget level based on estimated time spent on programs and the remaining costs are posted to management and general for the program based on estimated non explainable allocations. Also noted in management and general, some costs that could be considered joint program costs (i.e. rent and occupancy for buildings which program supervisors are located) which could be spread to program costs of the grant based on square footages used by the program. Criteria: Under the Uniform Guidance (2 CFR 200) the organization has elected the 10 percent de minimis cost rate. Normally if the de minimis rate is elected under Uniform Guidance requires that you use the Modified Direct cost as your cost base which the Organization does on its grant budgets for federal costs. However, for financial reporting purposes there is no formal explainable allocation of indirect (administrative) costs which could distort the cost to run each program of the organization. Context: For financial reporting purposes the Organization is still using the same allocation method it used when there were only 4 grants with 1 large grant. With additional grants this allocation method may not be effective, and it is not easily explainable and there is no formal allocation of indirect costs to each program. Cause: Additional grants received by the Organization made the old allocation method not effective and not explainable. Recommendation: Come up with a formal allocation method to allocated indirect costs to each program using an explainable method (i.e. direct program costs to total direct costs) and review posting to administrative costs for joint program costs (i.e. Rent and Occupancy) and spread these costs to programs used based on an explainable method (i.e. square footage of program to total square footage). Planned corrective actions The organization agrees with the findings and will start implementing procedures to make their allocation of indirect costs using an explainable method allowed by uniform guidance and consistent with all programs.
Type of finding: Significant weakness in Internal Controls over cash disbursements. Condition: The Organization’s internal controls require a purchase order and or a check request for all non-payroll cash disbursements. When testing cash disbursements, it was noted this procedure was not always followed; however they did have an overriding control of review of bill, and allowability to budget before any checks were signed. Criteria: Strong internal controls requires authorization and approval of all purchases made by the Organization. Context: The Organization’s internal controls require authorization and approval for all non-payroll cash disbursements but they were not always followed. Cause Not following all the authorization and approval could allow an improper payment to be made. Recommendation: Require all non-payroll purchases to have a purchase order and/or a check request. Planned corrective actions: The Organization had implemented a new purchase order system and have simplified the check requests to make it easier to follow and will use for all non payroll, and non reoccurring purchases.
Type of finding: Lack of separation of duties Condition- Given the Organizations small size and limited staff created challenges in achieving robust segregation of duties especially within the disbursements and payroll process. Criteria: Proper segregation of duties is essential for minimizing errors, preventing fraud, and maintaining financial integrity within the Organization. Cause: Limited number of staff Recommendation: The organization needs to spread the duties to best separate the duties of authorizing the transaction, from entering the transaction, from paying the transaction, from reconciling the transaction, from reporting the transaction. Planned Corrective Action The organization agrees with the finding and has hired a new employee to separate the payroll from the disbursement and to further separate the duties of authorization, from data entry, to payment, from reconciling, and will perform additional overriding controls for timely reviewing the monthly reports.
Type of Finding: Significant weakness in internal control over financials reporting, other matters Condition: The Organization did not file the single audit reporting package within 9 months after the year end. In addition, the Organization did not file annual audited financial statements within the required timeframe, including extensions, 2 CFR 200.512 Criteria: Based on the requirement in 2 CFR 200.512, report submission, the Organization is required to submit single audit reporting package within nine months after the Organization’s year end. Context: The Organization was unaware of the requirements for filing single audit reporting package within 9 months of the Organization’s year end being the first year they were required to have a Single Audit. Cause: Co-vid created a delay in having their annual audit in a timely matter due for both the Organization and the Auditor. Recommendation: We recommend that the organization improve the process for timely financial reporting Planned Corrective Action The organization agrees with the findings and is making every effort to catchup the time of completion of the Data collection form and the audit to be in compliance with financial reporting and single audit requirements.
Type of Finding: Significant weakness in allocation of administrative costs for financial reporting. Condition: For the major programs selected Dallas County System of Services, Inc. uses the de minimis 10% allocation of indirect administrative costs if indirect administrative costs are allowed for the grant. If not allowed for the grant, they are built in the approved grant budget at a rate lower than 10% allowed, so there is no reportable weakness for major programs. For financial reporting, there is no formal explainable allocation of administrative costs which could distort proper allocation of administrative costs. Costs are allocated for the administrative and accounting salaries at the budget level based on estimated time spent on programs and the remaining costs are posted to management and general for the program based on estimated non explainable allocations. Also noted in management and general, some costs that could be considered joint program costs (i.e. rent and occupancy for buildings which program supervisors are located) which could be spread to program costs of the grant based on square footages used by the program. Criteria: Under the Uniform Guidance (2 CFR 200) the organization has elected the 10 percent de minimis cost rate. Normally if the de minimis rate is elected under Uniform Guidance requires that you use the Modified Direct cost as your cost base which the Organization does on its grant budgets for federal costs. However, for financial reporting purposes there is no formal explainable allocation of indirect (administrative) costs which could distort the cost to run each program of the organization. Context: For financial reporting purposes the Organization is still using the same allocation method it used when there were only 4 grants with 1 large grant. With additional grants this allocation method may not be effective, and it is not easily explainable and there is no formal allocation of indirect costs to each program. Cause: Additional grants received by the Organization made the old allocation method not effective and not explainable. Recommendation: Come up with a formal allocation method to allocated indirect costs to each program using an explainable method (i.e. direct program costs to total direct costs) and review posting to administrative costs for joint program costs (i.e. Rent and Occupancy) and spread these costs to programs used based on an explainable method (i.e. square footage of program to total square footage). Planned corrective actions The organization agrees with the findings and will start implementing procedures to make their allocation of indirect costs using an explainable method allowed by uniform guidance and consistent with all programs.
Type of finding: Significant weakness in Internal Controls over cash disbursements. Condition: The Organization’s internal controls require a purchase order and or a check request for all non-payroll cash disbursements. When testing cash disbursements, it was noted this procedure was not always followed; however they did have an overriding control of review of bill, and allowability to budget before any checks were signed. Criteria: Strong internal controls requires authorization and approval of all purchases made by the Organization. Context: The Organization’s internal controls require authorization and approval for all non-payroll cash disbursements but they were not always followed. Cause Not following all the authorization and approval could allow an improper payment to be made. Recommendation: Require all non-payroll purchases to have a purchase order and/or a check request. Planned corrective actions: The Organization had implemented a new purchase order system and have simplified the check requests to make it easier to follow and will use for all non payroll, and non reoccurring purchases.
Type of finding: Lack of separation of duties Condition- Given the Organizations small size and limited staff created challenges in achieving robust segregation of duties especially within the disbursements and payroll process. Criteria: Proper segregation of duties is essential for minimizing errors, preventing fraud, and maintaining financial integrity within the Organization. Cause: Limited number of staff Recommendation: The organization needs to spread the duties to best separate the duties of authorizing the transaction, from entering the transaction, from paying the transaction, from reconciling the transaction, from reporting the transaction. Planned Corrective Action The organization agrees with the finding and has hired a new employee to separate the payroll from the disbursement and to further separate the duties of authorization, from data entry, to payment, from reconciling, and will perform additional overriding controls for timely reviewing the monthly reports.
Type of Finding: Significant weakness in internal control over financials reporting, other matters Condition: The Organization did not file the single audit reporting package within 9 months after the year end. In addition, the Organization did not file annual audited financial statements within the required timeframe, including extensions, 2 CFR 200.512 Criteria: Based on the requirement in 2 CFR 200.512, report submission, the Organization is required to submit single audit reporting package within nine months after the Organization’s year end. Context: The Organization was unaware of the requirements for filing single audit reporting package within 9 months of the Organization’s year end being the first year they were required to have a Single Audit. Cause: Co-vid created a delay in having their annual audit in a timely matter due for both the Organization and the Auditor. Recommendation: We recommend that the organization improve the process for timely financial reporting Planned Corrective Action The organization agrees with the findings and is making every effort to catchup the time of completion of the Data collection form and the audit to be in compliance with financial reporting and single audit requirements.
Type of Finding: Significant weakness in allocation of administrative costs for financial reporting. Condition: For the major programs selected Dallas County System of Services, Inc. uses the de minimis 10% allocation of indirect administrative costs if indirect administrative costs are allowed for the grant. If not allowed for the grant, they are built in the approved grant budget at a rate lower than 10% allowed, so there is no reportable weakness for major programs. For financial reporting, there is no formal explainable allocation of administrative costs which could distort proper allocation of administrative costs. Costs are allocated for the administrative and accounting salaries at the budget level based on estimated time spent on programs and the remaining costs are posted to management and general for the program based on estimated non explainable allocations. Also noted in management and general, some costs that could be considered joint program costs (i.e. rent and occupancy for buildings which program supervisors are located) which could be spread to program costs of the grant based on square footages used by the program. Criteria: Under the Uniform Guidance (2 CFR 200) the organization has elected the 10 percent de minimis cost rate. Normally if the de minimis rate is elected under Uniform Guidance requires that you use the Modified Direct cost as your cost base which the Organization does on its grant budgets for federal costs. However, for financial reporting purposes there is no formal explainable allocation of indirect (administrative) costs which could distort the cost to run each program of the organization. Context: For financial reporting purposes the Organization is still using the same allocation method it used when there were only 4 grants with 1 large grant. With additional grants this allocation method may not be effective, and it is not easily explainable and there is no formal allocation of indirect costs to each program. Cause: Additional grants received by the Organization made the old allocation method not effective and not explainable. Recommendation: Come up with a formal allocation method to allocated indirect costs to each program using an explainable method (i.e. direct program costs to total direct costs) and review posting to administrative costs for joint program costs (i.e. Rent and Occupancy) and spread these costs to programs used based on an explainable method (i.e. square footage of program to total square footage). Planned corrective actions The organization agrees with the findings and will start implementing procedures to make their allocation of indirect costs using an explainable method allowed by uniform guidance and consistent with all programs.
Type of finding: Significant weakness in Internal Controls over cash disbursements. Condition: The Organization’s internal controls require a purchase order and or a check request for all non-payroll cash disbursements. When testing cash disbursements, it was noted this procedure was not always followed; however they did have an overriding control of review of bill, and allowability to budget before any checks were signed. Criteria: Strong internal controls requires authorization and approval of all purchases made by the Organization. Context: The Organization’s internal controls require authorization and approval for all non-payroll cash disbursements but they were not always followed. Cause Not following all the authorization and approval could allow an improper payment to be made. Recommendation: Require all non-payroll purchases to have a purchase order and/or a check request. Planned corrective actions: The Organization had implemented a new purchase order system and have simplified the check requests to make it easier to follow and will use for all non payroll, and non reoccurring purchases.
Type of finding: Lack of separation of duties Condition- Given the Organizations small size and limited staff created challenges in achieving robust segregation of duties especially within the disbursements and payroll process. Criteria: Proper segregation of duties is essential for minimizing errors, preventing fraud, and maintaining financial integrity within the Organization. Cause: Limited number of staff Recommendation: The organization needs to spread the duties to best separate the duties of authorizing the transaction, from entering the transaction, from paying the transaction, from reconciling the transaction, from reporting the transaction. Planned Corrective Action The organization agrees with the finding and has hired a new employee to separate the payroll from the disbursement and to further separate the duties of authorization, from data entry, to payment, from reconciling, and will perform additional overriding controls for timely reviewing the monthly reports.
Type of Finding: Significant weakness in internal control over financials reporting, other matters Condition: The Organization did not file the single audit reporting package within 9 months after the year end. In addition, the Organization did not file annual audited financial statements within the required timeframe, including extensions, 2 CFR 200.512 Criteria: Based on the requirement in 2 CFR 200.512, report submission, the Organization is required to submit single audit reporting package within nine months after the Organization’s year end. Context: The Organization was unaware of the requirements for filing single audit reporting package within 9 months of the Organization’s year end being the first year they were required to have a Single Audit. Cause: Co-vid created a delay in having their annual audit in a timely matter due for both the Organization and the Auditor. Recommendation: We recommend that the organization improve the process for timely financial reporting Planned Corrective Action The organization agrees with the findings and is making every effort to catchup the time of completion of the Data collection form and the audit to be in compliance with financial reporting and single audit requirements.
Type of Finding: Significant weakness in allocation of administrative costs for financial reporting. Condition: For the major programs selected Dallas County System of Services, Inc. uses the de minimis 10% allocation of indirect administrative costs if indirect administrative costs are allowed for the grant. If not allowed for the grant, they are built in the approved grant budget at a rate lower than 10% allowed, so there is no reportable weakness for major programs. For financial reporting, there is no formal explainable allocation of administrative costs which could distort proper allocation of administrative costs. Costs are allocated for the administrative and accounting salaries at the budget level based on estimated time spent on programs and the remaining costs are posted to management and general for the program based on estimated non explainable allocations. Also noted in management and general, some costs that could be considered joint program costs (i.e. rent and occupancy for buildings which program supervisors are located) which could be spread to program costs of the grant based on square footages used by the program. Criteria: Under the Uniform Guidance (2 CFR 200) the organization has elected the 10 percent de minimis cost rate. Normally if the de minimis rate is elected under Uniform Guidance requires that you use the Modified Direct cost as your cost base which the Organization does on its grant budgets for federal costs. However, for financial reporting purposes there is no formal explainable allocation of indirect (administrative) costs which could distort the cost to run each program of the organization. Context: For financial reporting purposes the Organization is still using the same allocation method it used when there were only 4 grants with 1 large grant. With additional grants this allocation method may not be effective, and it is not easily explainable and there is no formal allocation of indirect costs to each program. Cause: Additional grants received by the Organization made the old allocation method not effective and not explainable. Recommendation: Come up with a formal allocation method to allocated indirect costs to each program using an explainable method (i.e. direct program costs to total direct costs) and review posting to administrative costs for joint program costs (i.e. Rent and Occupancy) and spread these costs to programs used based on an explainable method (i.e. square footage of program to total square footage). Planned corrective actions The organization agrees with the findings and will start implementing procedures to make their allocation of indirect costs using an explainable method allowed by uniform guidance and consistent with all programs.
Type of finding: Significant weakness in Internal Controls over cash disbursements. Condition: The Organization’s internal controls require a purchase order and or a check request for all non-payroll cash disbursements. When testing cash disbursements, it was noted this procedure was not always followed; however they did have an overriding control of review of bill, and allowability to budget before any checks were signed. Criteria: Strong internal controls requires authorization and approval of all purchases made by the Organization. Context: The Organization’s internal controls require authorization and approval for all non-payroll cash disbursements but they were not always followed. Cause Not following all the authorization and approval could allow an improper payment to be made. Recommendation: Require all non-payroll purchases to have a purchase order and/or a check request. Planned corrective actions: The Organization had implemented a new purchase order system and have simplified the check requests to make it easier to follow and will use for all non payroll, and non reoccurring purchases.
Type of finding: Lack of separation of duties Condition- Given the Organizations small size and limited staff created challenges in achieving robust segregation of duties especially within the disbursements and payroll process. Criteria: Proper segregation of duties is essential for minimizing errors, preventing fraud, and maintaining financial integrity within the Organization. Cause: Limited number of staff Recommendation: The organization needs to spread the duties to best separate the duties of authorizing the transaction, from entering the transaction, from paying the transaction, from reconciling the transaction, from reporting the transaction. Planned Corrective Action The organization agrees with the finding and has hired a new employee to separate the payroll from the disbursement and to further separate the duties of authorization, from data entry, to payment, from reconciling, and will perform additional overriding controls for timely reviewing the monthly reports.