Finding 2022-001: Inadequate Financial Reporting Condition: We noted that fiscal year-end reconciling of the program advance liability and grants receivable were incorrectly prepared and required revision, also resulting in adjustments to CDT's unaudited financial statements. Criteria: CFR 200.303, Internal Controls, states that the non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Additionally, management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Cause: The Organization did not have in place a formal system of reconciling the billings to the funders and earned revenue. Effect: Significant adjustments were proposed by management during the audit for the grants receivable and program advance. Recommendation: We strongly recommend that on a monthly or quarterly (at a minimum) basis there is a reconciliation of the billings between the funders and the revenue/costs related to the contracts to determine if there are any unbilled grants receivable or a grants advance. We also recommend detailed reviews/approvals of all supporting schedules be performed. Questioned Costs: None identified. Context: After performing initial audit procedures, we requested management to perform a reconciliation of the two accounts to properly determine the grant revenue and related grants receivable and grants advance. The condition noted is deemed to be systemic in nature. Identification as a Repeat Finding: 2021-001 and 2020-001 Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that account and grant reconciliations are performed on a quarterly basis, at a minimum. Management will review and approve all reconciliations. New procedures are also being implemented to tighten the information flow between management and the accounting team to streamline all aspects of the coding, data entry, and billing process.
Information on the Federal Programs ? for all findings: Assistance Listing Number 19.345 Finding 2022-002: Lack of Internal Control over Schedule of Expenditures of Federal Awards (SEFA) Condition: During our audit, we noted that the SEFA did not reconcile to the amounts reported on its financial statements. As a result, the SEFA under reported more than $500,000 of expenditures for the period under audit. Criteria: CFR 200.510(b) states that the recipient organization must be able to ?prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements?. The SEFA is required to list the individual Federal programs by Federal agency, name of the pass-through entity, total amount expended, assistance listing number and amounts provided to subrecipients. Context, Effect and Cause: During the year, management does not prepare a SEFA or a reconciliation of Federal expenditures to the expenses reported on an accrual basis in its accounting system. As a result the SEFA was not accurately completed at year-end, which required additional effort to prepare an accurate auditable report. Questioned Costs: Undetermined. Identification as a Repeat Finding: 2021-002 and 2020-002 Recommendation: We recommend CDT establish policies and procedures with respect to SEFA preparation. We also recommend the SEFA be periodically prepared and reconciled with its accounting records. The SEFA should also be reviewed and approved by management, and evidence of such approval should be maintained in its accounting records. Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that an internal SEFA is prepared and reconciled on a quarterly basis, at a minimum. Management will review and approve all reconciliations.
Finding 2022-001: Inadequate Financial Reporting Condition: We noted that fiscal year-end reconciling of the program advance liability and grants receivable were incorrectly prepared and required revision, also resulting in adjustments to CDT's unaudited financial statements. Criteria: CFR 200.303, Internal Controls, states that the non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Additionally, management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Cause: The Organization did not have in place a formal system of reconciling the billings to the funders and earned revenue. Effect: Significant adjustments were proposed by management during the audit for the grants receivable and program advance. Recommendation: We strongly recommend that on a monthly or quarterly (at a minimum) basis there is a reconciliation of the billings between the funders and the revenue/costs related to the contracts to determine if there are any unbilled grants receivable or a grants advance. We also recommend detailed reviews/approvals of all supporting schedules be performed. Questioned Costs: None identified. Context: After performing initial audit procedures, we requested management to perform a reconciliation of the two accounts to properly determine the grant revenue and related grants receivable and grants advance. The condition noted is deemed to be systemic in nature. Identification as a Repeat Finding: 2021-001 and 2020-001 Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that account and grant reconciliations are performed on a quarterly basis, at a minimum. Management will review and approve all reconciliations. New procedures are also being implemented to tighten the information flow between management and the accounting team to streamline all aspects of the coding, data entry, and billing process.
Information on the Federal Programs ? for all findings: Assistance Listing Number 19.345 Finding 2022-002: Lack of Internal Control over Schedule of Expenditures of Federal Awards (SEFA) Condition: During our audit, we noted that the SEFA did not reconcile to the amounts reported on its financial statements. As a result, the SEFA under reported more than $500,000 of expenditures for the period under audit. Criteria: CFR 200.510(b) states that the recipient organization must be able to ?prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements?. The SEFA is required to list the individual Federal programs by Federal agency, name of the pass-through entity, total amount expended, assistance listing number and amounts provided to subrecipients. Context, Effect and Cause: During the year, management does not prepare a SEFA or a reconciliation of Federal expenditures to the expenses reported on an accrual basis in its accounting system. As a result the SEFA was not accurately completed at year-end, which required additional effort to prepare an accurate auditable report. Questioned Costs: Undetermined. Identification as a Repeat Finding: 2021-002 and 2020-002 Recommendation: We recommend CDT establish policies and procedures with respect to SEFA preparation. We also recommend the SEFA be periodically prepared and reconciled with its accounting records. The SEFA should also be reviewed and approved by management, and evidence of such approval should be maintained in its accounting records. Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that an internal SEFA is prepared and reconciled on a quarterly basis, at a minimum. Management will review and approve all reconciliations.
Finding 2022-001: Inadequate Financial Reporting Condition: We noted that fiscal year-end reconciling of the program advance liability and grants receivable were incorrectly prepared and required revision, also resulting in adjustments to CDT's unaudited financial statements. Criteria: CFR 200.303, Internal Controls, states that the non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Additionally, management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Cause: The Organization did not have in place a formal system of reconciling the billings to the funders and earned revenue. Effect: Significant adjustments were proposed by management during the audit for the grants receivable and program advance. Recommendation: We strongly recommend that on a monthly or quarterly (at a minimum) basis there is a reconciliation of the billings between the funders and the revenue/costs related to the contracts to determine if there are any unbilled grants receivable or a grants advance. We also recommend detailed reviews/approvals of all supporting schedules be performed. Questioned Costs: None identified. Context: After performing initial audit procedures, we requested management to perform a reconciliation of the two accounts to properly determine the grant revenue and related grants receivable and grants advance. The condition noted is deemed to be systemic in nature. Identification as a Repeat Finding: 2021-001 and 2020-001 Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that account and grant reconciliations are performed on a quarterly basis, at a minimum. Management will review and approve all reconciliations. New procedures are also being implemented to tighten the information flow between management and the accounting team to streamline all aspects of the coding, data entry, and billing process.
Information on the Federal Programs ? for all findings: Assistance Listing Number 19.345 Finding 2022-002: Lack of Internal Control over Schedule of Expenditures of Federal Awards (SEFA) Condition: During our audit, we noted that the SEFA did not reconcile to the amounts reported on its financial statements. As a result, the SEFA under reported more than $500,000 of expenditures for the period under audit. Criteria: CFR 200.510(b) states that the recipient organization must be able to ?prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements?. The SEFA is required to list the individual Federal programs by Federal agency, name of the pass-through entity, total amount expended, assistance listing number and amounts provided to subrecipients. Context, Effect and Cause: During the year, management does not prepare a SEFA or a reconciliation of Federal expenditures to the expenses reported on an accrual basis in its accounting system. As a result the SEFA was not accurately completed at year-end, which required additional effort to prepare an accurate auditable report. Questioned Costs: Undetermined. Identification as a Repeat Finding: 2021-002 and 2020-002 Recommendation: We recommend CDT establish policies and procedures with respect to SEFA preparation. We also recommend the SEFA be periodically prepared and reconciled with its accounting records. The SEFA should also be reviewed and approved by management, and evidence of such approval should be maintained in its accounting records. Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that an internal SEFA is prepared and reconciled on a quarterly basis, at a minimum. Management will review and approve all reconciliations.
Finding 2022-001: Inadequate Financial Reporting Condition: We noted that fiscal year-end reconciling of the program advance liability and grants receivable were incorrectly prepared and required revision, also resulting in adjustments to CDT's unaudited financial statements. Criteria: CFR 200.303, Internal Controls, states that the non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Additionally, management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Cause: The Organization did not have in place a formal system of reconciling the billings to the funders and earned revenue. Effect: Significant adjustments were proposed by management during the audit for the grants receivable and program advance. Recommendation: We strongly recommend that on a monthly or quarterly (at a minimum) basis there is a reconciliation of the billings between the funders and the revenue/costs related to the contracts to determine if there are any unbilled grants receivable or a grants advance. We also recommend detailed reviews/approvals of all supporting schedules be performed. Questioned Costs: None identified. Context: After performing initial audit procedures, we requested management to perform a reconciliation of the two accounts to properly determine the grant revenue and related grants receivable and grants advance. The condition noted is deemed to be systemic in nature. Identification as a Repeat Finding: 2021-001 and 2020-001 Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that account and grant reconciliations are performed on a quarterly basis, at a minimum. Management will review and approve all reconciliations. New procedures are also being implemented to tighten the information flow between management and the accounting team to streamline all aspects of the coding, data entry, and billing process.
Information on the Federal Programs ? for all findings: Assistance Listing Number 19.345 Finding 2022-002: Lack of Internal Control over Schedule of Expenditures of Federal Awards (SEFA) Condition: During our audit, we noted that the SEFA did not reconcile to the amounts reported on its financial statements. As a result, the SEFA under reported more than $500,000 of expenditures for the period under audit. Criteria: CFR 200.510(b) states that the recipient organization must be able to ?prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements?. The SEFA is required to list the individual Federal programs by Federal agency, name of the pass-through entity, total amount expended, assistance listing number and amounts provided to subrecipients. Context, Effect and Cause: During the year, management does not prepare a SEFA or a reconciliation of Federal expenditures to the expenses reported on an accrual basis in its accounting system. As a result the SEFA was not accurately completed at year-end, which required additional effort to prepare an accurate auditable report. Questioned Costs: Undetermined. Identification as a Repeat Finding: 2021-002 and 2020-002 Recommendation: We recommend CDT establish policies and procedures with respect to SEFA preparation. We also recommend the SEFA be periodically prepared and reconciled with its accounting records. The SEFA should also be reviewed and approved by management, and evidence of such approval should be maintained in its accounting records. Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that an internal SEFA is prepared and reconciled on a quarterly basis, at a minimum. Management will review and approve all reconciliations.
Finding 2022-001: Inadequate Financial Reporting Condition: We noted that fiscal year-end reconciling of the program advance liability and grants receivable were incorrectly prepared and required revision, also resulting in adjustments to CDT's unaudited financial statements. Criteria: CFR 200.303, Internal Controls, states that the non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Additionally, management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Cause: The Organization did not have in place a formal system of reconciling the billings to the funders and earned revenue. Effect: Significant adjustments were proposed by management during the audit for the grants receivable and program advance. Recommendation: We strongly recommend that on a monthly or quarterly (at a minimum) basis there is a reconciliation of the billings between the funders and the revenue/costs related to the contracts to determine if there are any unbilled grants receivable or a grants advance. We also recommend detailed reviews/approvals of all supporting schedules be performed. Questioned Costs: None identified. Context: After performing initial audit procedures, we requested management to perform a reconciliation of the two accounts to properly determine the grant revenue and related grants receivable and grants advance. The condition noted is deemed to be systemic in nature. Identification as a Repeat Finding: 2021-001 and 2020-001 Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that account and grant reconciliations are performed on a quarterly basis, at a minimum. Management will review and approve all reconciliations. New procedures are also being implemented to tighten the information flow between management and the accounting team to streamline all aspects of the coding, data entry, and billing process.
Information on the Federal Programs ? for all findings: Assistance Listing Number 19.345 Finding 2022-002: Lack of Internal Control over Schedule of Expenditures of Federal Awards (SEFA) Condition: During our audit, we noted that the SEFA did not reconcile to the amounts reported on its financial statements. As a result, the SEFA under reported more than $500,000 of expenditures for the period under audit. Criteria: CFR 200.510(b) states that the recipient organization must be able to ?prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements?. The SEFA is required to list the individual Federal programs by Federal agency, name of the pass-through entity, total amount expended, assistance listing number and amounts provided to subrecipients. Context, Effect and Cause: During the year, management does not prepare a SEFA or a reconciliation of Federal expenditures to the expenses reported on an accrual basis in its accounting system. As a result the SEFA was not accurately completed at year-end, which required additional effort to prepare an accurate auditable report. Questioned Costs: Undetermined. Identification as a Repeat Finding: 2021-002 and 2020-002 Recommendation: We recommend CDT establish policies and procedures with respect to SEFA preparation. We also recommend the SEFA be periodically prepared and reconciled with its accounting records. The SEFA should also be reviewed and approved by management, and evidence of such approval should be maintained in its accounting records. Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that an internal SEFA is prepared and reconciled on a quarterly basis, at a minimum. Management will review and approve all reconciliations.
Finding 2022-001: Inadequate Financial Reporting Condition: We noted that fiscal year-end reconciling of the program advance liability and grants receivable were incorrectly prepared and required revision, also resulting in adjustments to CDT's unaudited financial statements. Criteria: CFR 200.303, Internal Controls, states that the non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Additionally, management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Cause: The Organization did not have in place a formal system of reconciling the billings to the funders and earned revenue. Effect: Significant adjustments were proposed by management during the audit for the grants receivable and program advance. Recommendation: We strongly recommend that on a monthly or quarterly (at a minimum) basis there is a reconciliation of the billings between the funders and the revenue/costs related to the contracts to determine if there are any unbilled grants receivable or a grants advance. We also recommend detailed reviews/approvals of all supporting schedules be performed. Questioned Costs: None identified. Context: After performing initial audit procedures, we requested management to perform a reconciliation of the two accounts to properly determine the grant revenue and related grants receivable and grants advance. The condition noted is deemed to be systemic in nature. Identification as a Repeat Finding: 2021-001 and 2020-001 Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that account and grant reconciliations are performed on a quarterly basis, at a minimum. Management will review and approve all reconciliations. New procedures are also being implemented to tighten the information flow between management and the accounting team to streamline all aspects of the coding, data entry, and billing process.
Information on the Federal Programs ? for all findings: Assistance Listing Number 19.345 Finding 2022-002: Lack of Internal Control over Schedule of Expenditures of Federal Awards (SEFA) Condition: During our audit, we noted that the SEFA did not reconcile to the amounts reported on its financial statements. As a result, the SEFA under reported more than $500,000 of expenditures for the period under audit. Criteria: CFR 200.510(b) states that the recipient organization must be able to ?prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements?. The SEFA is required to list the individual Federal programs by Federal agency, name of the pass-through entity, total amount expended, assistance listing number and amounts provided to subrecipients. Context, Effect and Cause: During the year, management does not prepare a SEFA or a reconciliation of Federal expenditures to the expenses reported on an accrual basis in its accounting system. As a result the SEFA was not accurately completed at year-end, which required additional effort to prepare an accurate auditable report. Questioned Costs: Undetermined. Identification as a Repeat Finding: 2021-002 and 2020-002 Recommendation: We recommend CDT establish policies and procedures with respect to SEFA preparation. We also recommend the SEFA be periodically prepared and reconciled with its accounting records. The SEFA should also be reviewed and approved by management, and evidence of such approval should be maintained in its accounting records. Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that an internal SEFA is prepared and reconciled on a quarterly basis, at a minimum. Management will review and approve all reconciliations.
Finding 2022-001: Inadequate Financial Reporting Condition: We noted that fiscal year-end reconciling of the program advance liability and grants receivable were incorrectly prepared and required revision, also resulting in adjustments to CDT's unaudited financial statements. Criteria: CFR 200.303, Internal Controls, states that the non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Additionally, management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Cause: The Organization did not have in place a formal system of reconciling the billings to the funders and earned revenue. Effect: Significant adjustments were proposed by management during the audit for the grants receivable and program advance. Recommendation: We strongly recommend that on a monthly or quarterly (at a minimum) basis there is a reconciliation of the billings between the funders and the revenue/costs related to the contracts to determine if there are any unbilled grants receivable or a grants advance. We also recommend detailed reviews/approvals of all supporting schedules be performed. Questioned Costs: None identified. Context: After performing initial audit procedures, we requested management to perform a reconciliation of the two accounts to properly determine the grant revenue and related grants receivable and grants advance. The condition noted is deemed to be systemic in nature. Identification as a Repeat Finding: 2021-001 and 2020-001 Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that account and grant reconciliations are performed on a quarterly basis, at a minimum. Management will review and approve all reconciliations. New procedures are also being implemented to tighten the information flow between management and the accounting team to streamline all aspects of the coding, data entry, and billing process.
Information on the Federal Programs ? for all findings: Assistance Listing Number 19.345 Finding 2022-002: Lack of Internal Control over Schedule of Expenditures of Federal Awards (SEFA) Condition: During our audit, we noted that the SEFA did not reconcile to the amounts reported on its financial statements. As a result, the SEFA under reported more than $500,000 of expenditures for the period under audit. Criteria: CFR 200.510(b) states that the recipient organization must be able to ?prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements?. The SEFA is required to list the individual Federal programs by Federal agency, name of the pass-through entity, total amount expended, assistance listing number and amounts provided to subrecipients. Context, Effect and Cause: During the year, management does not prepare a SEFA or a reconciliation of Federal expenditures to the expenses reported on an accrual basis in its accounting system. As a result the SEFA was not accurately completed at year-end, which required additional effort to prepare an accurate auditable report. Questioned Costs: Undetermined. Identification as a Repeat Finding: 2021-002 and 2020-002 Recommendation: We recommend CDT establish policies and procedures with respect to SEFA preparation. We also recommend the SEFA be periodically prepared and reconciled with its accounting records. The SEFA should also be reviewed and approved by management, and evidence of such approval should be maintained in its accounting records. Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that an internal SEFA is prepared and reconciled on a quarterly basis, at a minimum. Management will review and approve all reconciliations.
Finding 2022-001: Inadequate Financial Reporting Condition: We noted that fiscal year-end reconciling of the program advance liability and grants receivable were incorrectly prepared and required revision, also resulting in adjustments to CDT's unaudited financial statements. Criteria: CFR 200.303, Internal Controls, states that the non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Additionally, management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Cause: The Organization did not have in place a formal system of reconciling the billings to the funders and earned revenue. Effect: Significant adjustments were proposed by management during the audit for the grants receivable and program advance. Recommendation: We strongly recommend that on a monthly or quarterly (at a minimum) basis there is a reconciliation of the billings between the funders and the revenue/costs related to the contracts to determine if there are any unbilled grants receivable or a grants advance. We also recommend detailed reviews/approvals of all supporting schedules be performed. Questioned Costs: None identified. Context: After performing initial audit procedures, we requested management to perform a reconciliation of the two accounts to properly determine the grant revenue and related grants receivable and grants advance. The condition noted is deemed to be systemic in nature. Identification as a Repeat Finding: 2021-001 and 2020-001 Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that account and grant reconciliations are performed on a quarterly basis, at a minimum. Management will review and approve all reconciliations. New procedures are also being implemented to tighten the information flow between management and the accounting team to streamline all aspects of the coding, data entry, and billing process.
Information on the Federal Programs ? for all findings: Assistance Listing Number 19.345 Finding 2022-002: Lack of Internal Control over Schedule of Expenditures of Federal Awards (SEFA) Condition: During our audit, we noted that the SEFA did not reconcile to the amounts reported on its financial statements. As a result, the SEFA under reported more than $500,000 of expenditures for the period under audit. Criteria: CFR 200.510(b) states that the recipient organization must be able to ?prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements?. The SEFA is required to list the individual Federal programs by Federal agency, name of the pass-through entity, total amount expended, assistance listing number and amounts provided to subrecipients. Context, Effect and Cause: During the year, management does not prepare a SEFA or a reconciliation of Federal expenditures to the expenses reported on an accrual basis in its accounting system. As a result the SEFA was not accurately completed at year-end, which required additional effort to prepare an accurate auditable report. Questioned Costs: Undetermined. Identification as a Repeat Finding: 2021-002 and 2020-002 Recommendation: We recommend CDT establish policies and procedures with respect to SEFA preparation. We also recommend the SEFA be periodically prepared and reconciled with its accounting records. The SEFA should also be reviewed and approved by management, and evidence of such approval should be maintained in its accounting records. Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that an internal SEFA is prepared and reconciled on a quarterly basis, at a minimum. Management will review and approve all reconciliations.
Finding 2022-001: Inadequate Financial Reporting Condition: We noted that fiscal year-end reconciling of the program advance liability and grants receivable were incorrectly prepared and required revision, also resulting in adjustments to CDT's unaudited financial statements. Criteria: CFR 200.303, Internal Controls, states that the non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Additionally, management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Cause: The Organization did not have in place a formal system of reconciling the billings to the funders and earned revenue. Effect: Significant adjustments were proposed by management during the audit for the grants receivable and program advance. Recommendation: We strongly recommend that on a monthly or quarterly (at a minimum) basis there is a reconciliation of the billings between the funders and the revenue/costs related to the contracts to determine if there are any unbilled grants receivable or a grants advance. We also recommend detailed reviews/approvals of all supporting schedules be performed. Questioned Costs: None identified. Context: After performing initial audit procedures, we requested management to perform a reconciliation of the two accounts to properly determine the grant revenue and related grants receivable and grants advance. The condition noted is deemed to be systemic in nature. Identification as a Repeat Finding: 2021-001 and 2020-001 Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that account and grant reconciliations are performed on a quarterly basis, at a minimum. Management will review and approve all reconciliations. New procedures are also being implemented to tighten the information flow between management and the accounting team to streamline all aspects of the coding, data entry, and billing process.
Information on the Federal Programs ? for all findings: Assistance Listing Number 19.345 Finding 2022-002: Lack of Internal Control over Schedule of Expenditures of Federal Awards (SEFA) Condition: During our audit, we noted that the SEFA did not reconcile to the amounts reported on its financial statements. As a result, the SEFA under reported more than $500,000 of expenditures for the period under audit. Criteria: CFR 200.510(b) states that the recipient organization must be able to ?prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements?. The SEFA is required to list the individual Federal programs by Federal agency, name of the pass-through entity, total amount expended, assistance listing number and amounts provided to subrecipients. Context, Effect and Cause: During the year, management does not prepare a SEFA or a reconciliation of Federal expenditures to the expenses reported on an accrual basis in its accounting system. As a result the SEFA was not accurately completed at year-end, which required additional effort to prepare an accurate auditable report. Questioned Costs: Undetermined. Identification as a Repeat Finding: 2021-002 and 2020-002 Recommendation: We recommend CDT establish policies and procedures with respect to SEFA preparation. We also recommend the SEFA be periodically prepared and reconciled with its accounting records. The SEFA should also be reviewed and approved by management, and evidence of such approval should be maintained in its accounting records. Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that an internal SEFA is prepared and reconciled on a quarterly basis, at a minimum. Management will review and approve all reconciliations.
Finding 2022-001: Inadequate Financial Reporting Condition: We noted that fiscal year-end reconciling of the program advance liability and grants receivable were incorrectly prepared and required revision, also resulting in adjustments to CDT's unaudited financial statements. Criteria: CFR 200.303, Internal Controls, states that the non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Additionally, management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Cause: The Organization did not have in place a formal system of reconciling the billings to the funders and earned revenue. Effect: Significant adjustments were proposed by management during the audit for the grants receivable and program advance. Recommendation: We strongly recommend that on a monthly or quarterly (at a minimum) basis there is a reconciliation of the billings between the funders and the revenue/costs related to the contracts to determine if there are any unbilled grants receivable or a grants advance. We also recommend detailed reviews/approvals of all supporting schedules be performed. Questioned Costs: None identified. Context: After performing initial audit procedures, we requested management to perform a reconciliation of the two accounts to properly determine the grant revenue and related grants receivable and grants advance. The condition noted is deemed to be systemic in nature. Identification as a Repeat Finding: 2021-001 and 2020-001 Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that account and grant reconciliations are performed on a quarterly basis, at a minimum. Management will review and approve all reconciliations. New procedures are also being implemented to tighten the information flow between management and the accounting team to streamline all aspects of the coding, data entry, and billing process.
Information on the Federal Programs ? for all findings: Assistance Listing Number 19.345 Finding 2022-002: Lack of Internal Control over Schedule of Expenditures of Federal Awards (SEFA) Condition: During our audit, we noted that the SEFA did not reconcile to the amounts reported on its financial statements. As a result, the SEFA under reported more than $500,000 of expenditures for the period under audit. Criteria: CFR 200.510(b) states that the recipient organization must be able to ?prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements?. The SEFA is required to list the individual Federal programs by Federal agency, name of the pass-through entity, total amount expended, assistance listing number and amounts provided to subrecipients. Context, Effect and Cause: During the year, management does not prepare a SEFA or a reconciliation of Federal expenditures to the expenses reported on an accrual basis in its accounting system. As a result the SEFA was not accurately completed at year-end, which required additional effort to prepare an accurate auditable report. Questioned Costs: Undetermined. Identification as a Repeat Finding: 2021-002 and 2020-002 Recommendation: We recommend CDT establish policies and procedures with respect to SEFA preparation. We also recommend the SEFA be periodically prepared and reconciled with its accounting records. The SEFA should also be reviewed and approved by management, and evidence of such approval should be maintained in its accounting records. Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that an internal SEFA is prepared and reconciled on a quarterly basis, at a minimum. Management will review and approve all reconciliations.
Finding 2022-001: Inadequate Financial Reporting Condition: We noted that fiscal year-end reconciling of the program advance liability and grants receivable were incorrectly prepared and required revision, also resulting in adjustments to CDT's unaudited financial statements. Criteria: CFR 200.303, Internal Controls, states that the non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Additionally, management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Cause: The Organization did not have in place a formal system of reconciling the billings to the funders and earned revenue. Effect: Significant adjustments were proposed by management during the audit for the grants receivable and program advance. Recommendation: We strongly recommend that on a monthly or quarterly (at a minimum) basis there is a reconciliation of the billings between the funders and the revenue/costs related to the contracts to determine if there are any unbilled grants receivable or a grants advance. We also recommend detailed reviews/approvals of all supporting schedules be performed. Questioned Costs: None identified. Context: After performing initial audit procedures, we requested management to perform a reconciliation of the two accounts to properly determine the grant revenue and related grants receivable and grants advance. The condition noted is deemed to be systemic in nature. Identification as a Repeat Finding: 2021-001 and 2020-001 Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that account and grant reconciliations are performed on a quarterly basis, at a minimum. Management will review and approve all reconciliations. New procedures are also being implemented to tighten the information flow between management and the accounting team to streamline all aspects of the coding, data entry, and billing process.
Information on the Federal Programs ? for all findings: Assistance Listing Number 19.345 Finding 2022-002: Lack of Internal Control over Schedule of Expenditures of Federal Awards (SEFA) Condition: During our audit, we noted that the SEFA did not reconcile to the amounts reported on its financial statements. As a result, the SEFA under reported more than $500,000 of expenditures for the period under audit. Criteria: CFR 200.510(b) states that the recipient organization must be able to ?prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements?. The SEFA is required to list the individual Federal programs by Federal agency, name of the pass-through entity, total amount expended, assistance listing number and amounts provided to subrecipients. Context, Effect and Cause: During the year, management does not prepare a SEFA or a reconciliation of Federal expenditures to the expenses reported on an accrual basis in its accounting system. As a result the SEFA was not accurately completed at year-end, which required additional effort to prepare an accurate auditable report. Questioned Costs: Undetermined. Identification as a Repeat Finding: 2021-002 and 2020-002 Recommendation: We recommend CDT establish policies and procedures with respect to SEFA preparation. We also recommend the SEFA be periodically prepared and reconciled with its accounting records. The SEFA should also be reviewed and approved by management, and evidence of such approval should be maintained in its accounting records. Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that an internal SEFA is prepared and reconciled on a quarterly basis, at a minimum. Management will review and approve all reconciliations.
Finding 2022-001: Inadequate Financial Reporting Condition: We noted that fiscal year-end reconciling of the program advance liability and grants receivable were incorrectly prepared and required revision, also resulting in adjustments to CDT's unaudited financial statements. Criteria: CFR 200.303, Internal Controls, states that the non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Additionally, management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Cause: The Organization did not have in place a formal system of reconciling the billings to the funders and earned revenue. Effect: Significant adjustments were proposed by management during the audit for the grants receivable and program advance. Recommendation: We strongly recommend that on a monthly or quarterly (at a minimum) basis there is a reconciliation of the billings between the funders and the revenue/costs related to the contracts to determine if there are any unbilled grants receivable or a grants advance. We also recommend detailed reviews/approvals of all supporting schedules be performed. Questioned Costs: None identified. Context: After performing initial audit procedures, we requested management to perform a reconciliation of the two accounts to properly determine the grant revenue and related grants receivable and grants advance. The condition noted is deemed to be systemic in nature. Identification as a Repeat Finding: 2021-001 and 2020-001 Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that account and grant reconciliations are performed on a quarterly basis, at a minimum. Management will review and approve all reconciliations. New procedures are also being implemented to tighten the information flow between management and the accounting team to streamline all aspects of the coding, data entry, and billing process.
Information on the Federal Programs ? for all findings: Assistance Listing Number 19.345 Finding 2022-002: Lack of Internal Control over Schedule of Expenditures of Federal Awards (SEFA) Condition: During our audit, we noted that the SEFA did not reconcile to the amounts reported on its financial statements. As a result, the SEFA under reported more than $500,000 of expenditures for the period under audit. Criteria: CFR 200.510(b) states that the recipient organization must be able to ?prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements?. The SEFA is required to list the individual Federal programs by Federal agency, name of the pass-through entity, total amount expended, assistance listing number and amounts provided to subrecipients. Context, Effect and Cause: During the year, management does not prepare a SEFA or a reconciliation of Federal expenditures to the expenses reported on an accrual basis in its accounting system. As a result the SEFA was not accurately completed at year-end, which required additional effort to prepare an accurate auditable report. Questioned Costs: Undetermined. Identification as a Repeat Finding: 2021-002 and 2020-002 Recommendation: We recommend CDT establish policies and procedures with respect to SEFA preparation. We also recommend the SEFA be periodically prepared and reconciled with its accounting records. The SEFA should also be reviewed and approved by management, and evidence of such approval should be maintained in its accounting records. Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that an internal SEFA is prepared and reconciled on a quarterly basis, at a minimum. Management will review and approve all reconciliations.
Finding 2022-001: Inadequate Financial Reporting Condition: We noted that fiscal year-end reconciling of the program advance liability and grants receivable were incorrectly prepared and required revision, also resulting in adjustments to CDT's unaudited financial statements. Criteria: CFR 200.303, Internal Controls, states that the non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Additionally, management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Cause: The Organization did not have in place a formal system of reconciling the billings to the funders and earned revenue. Effect: Significant adjustments were proposed by management during the audit for the grants receivable and program advance. Recommendation: We strongly recommend that on a monthly or quarterly (at a minimum) basis there is a reconciliation of the billings between the funders and the revenue/costs related to the contracts to determine if there are any unbilled grants receivable or a grants advance. We also recommend detailed reviews/approvals of all supporting schedules be performed. Questioned Costs: None identified. Context: After performing initial audit procedures, we requested management to perform a reconciliation of the two accounts to properly determine the grant revenue and related grants receivable and grants advance. The condition noted is deemed to be systemic in nature. Identification as a Repeat Finding: 2021-001 and 2020-001 Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that account and grant reconciliations are performed on a quarterly basis, at a minimum. Management will review and approve all reconciliations. New procedures are also being implemented to tighten the information flow between management and the accounting team to streamline all aspects of the coding, data entry, and billing process.
Information on the Federal Programs ? for all findings: Assistance Listing Number 19.345 Finding 2022-002: Lack of Internal Control over Schedule of Expenditures of Federal Awards (SEFA) Condition: During our audit, we noted that the SEFA did not reconcile to the amounts reported on its financial statements. As a result, the SEFA under reported more than $500,000 of expenditures for the period under audit. Criteria: CFR 200.510(b) states that the recipient organization must be able to ?prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements?. The SEFA is required to list the individual Federal programs by Federal agency, name of the pass-through entity, total amount expended, assistance listing number and amounts provided to subrecipients. Context, Effect and Cause: During the year, management does not prepare a SEFA or a reconciliation of Federal expenditures to the expenses reported on an accrual basis in its accounting system. As a result the SEFA was not accurately completed at year-end, which required additional effort to prepare an accurate auditable report. Questioned Costs: Undetermined. Identification as a Repeat Finding: 2021-002 and 2020-002 Recommendation: We recommend CDT establish policies and procedures with respect to SEFA preparation. We also recommend the SEFA be periodically prepared and reconciled with its accounting records. The SEFA should also be reviewed and approved by management, and evidence of such approval should be maintained in its accounting records. Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that an internal SEFA is prepared and reconciled on a quarterly basis, at a minimum. Management will review and approve all reconciliations.
Finding 2022-001: Inadequate Financial Reporting Condition: We noted that fiscal year-end reconciling of the program advance liability and grants receivable were incorrectly prepared and required revision, also resulting in adjustments to CDT's unaudited financial statements. Criteria: CFR 200.303, Internal Controls, states that the non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Additionally, management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Cause: The Organization did not have in place a formal system of reconciling the billings to the funders and earned revenue. Effect: Significant adjustments were proposed by management during the audit for the grants receivable and program advance. Recommendation: We strongly recommend that on a monthly or quarterly (at a minimum) basis there is a reconciliation of the billings between the funders and the revenue/costs related to the contracts to determine if there are any unbilled grants receivable or a grants advance. We also recommend detailed reviews/approvals of all supporting schedules be performed. Questioned Costs: None identified. Context: After performing initial audit procedures, we requested management to perform a reconciliation of the two accounts to properly determine the grant revenue and related grants receivable and grants advance. The condition noted is deemed to be systemic in nature. Identification as a Repeat Finding: 2021-001 and 2020-001 Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that account and grant reconciliations are performed on a quarterly basis, at a minimum. Management will review and approve all reconciliations. New procedures are also being implemented to tighten the information flow between management and the accounting team to streamline all aspects of the coding, data entry, and billing process.
Information on the Federal Programs ? for all findings: Assistance Listing Number 19.345 Finding 2022-002: Lack of Internal Control over Schedule of Expenditures of Federal Awards (SEFA) Condition: During our audit, we noted that the SEFA did not reconcile to the amounts reported on its financial statements. As a result, the SEFA under reported more than $500,000 of expenditures for the period under audit. Criteria: CFR 200.510(b) states that the recipient organization must be able to ?prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements?. The SEFA is required to list the individual Federal programs by Federal agency, name of the pass-through entity, total amount expended, assistance listing number and amounts provided to subrecipients. Context, Effect and Cause: During the year, management does not prepare a SEFA or a reconciliation of Federal expenditures to the expenses reported on an accrual basis in its accounting system. As a result the SEFA was not accurately completed at year-end, which required additional effort to prepare an accurate auditable report. Questioned Costs: Undetermined. Identification as a Repeat Finding: 2021-002 and 2020-002 Recommendation: We recommend CDT establish policies and procedures with respect to SEFA preparation. We also recommend the SEFA be periodically prepared and reconciled with its accounting records. The SEFA should also be reviewed and approved by management, and evidence of such approval should be maintained in its accounting records. Management Views and Corrective Action Plan: Management agrees with the finding and recommendation. Management is working with the accounting team to implement a new process to ensure that an internal SEFA is prepared and reconciled on a quarterly basis, at a minimum. Management will review and approve all reconciliations.