Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
Finding 2024-007 Programs: All Material Weakness over Schedule of Expenditures of Federal Awards (SEFA) Reporting Repeat Finding: Yes; 2023-006 Condition: Finance is responsible for preparing the schedule of expenditures of Federal awards based upon grant information obtained from the financial accounting records and other information provided by each department or agency. In many instances, the detail expenditure information in the accounting software differed from the expenditures reported by various City departments. Additionally, expenditures related to sub-recipients, subcontractors, and beneficiaries are not adequately tracked in the general ledger. Criteria: In accordance with 2 CFR 200.303, Internal controls: The non-Federal entity must: (a) 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. In accordance with 2 CFR 200.508, Auditee responsibilities: The auditee must: (b) Prepare appropriate financial statements, including the schedule of expenditures of Federal awards in accordance with §200.510 Financial statements. In accordance with 2 CFR 200.510, Financial statements: (b) Schedule of expenditures of Federal awards: the auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. While not required, the auditee may choose to provide information requested by Federal awarding agencies and pass-through entities to make the schedule easier to use. For example, when a Federal program has multiple Federal award years, the auditee may list the amount of Federal awards expended for each Federal award year separately. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. For a cluster of programs, also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total federal awards expended for loan or loan guarantee programs in the schedule; and (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the non-Federal entity elected to use the 10% de minimis cost rate as covered in §200.414 Indirect (F&A) costs. Cause: The City does not maintain a centralized grant accounting function or standardized policies and procedures, including requirements to periodically submit and reconcile expenditures; instead, each department maintains its own grant information. The lack of submission of grant documents and accurate information by the various agencies and departments to Finance weakens internal controls over grant reporting and hinders the ability of Finance to accurately prepare the Schedule. Internal controls over financial reporting should be designed to prevent, detect or correct errors in a timely manner. Without adequate controls, the City cannot provide reasonable assurance that the Schedule is fairly presented. Controls have not been established by the City to ensure complete and accurate reporting for the Schedule for the 2024 fiscal year. Effect: The determination of which major programs will be audited is affected by the accuracy of the Schedule at the time of audit. Without proper internal controls over financial reporting, inaccurate reporting of the City’s financial information could occur, and the City cannot provide reasonable assurance that the SEFA is fairly presented. As a result, individual program reports throughout the year could have inaccurate information. There were also significant delays in the preparation of the Schedule of Federal awards, which prevented the City from meeting the March 31, 2025 deadline with the Federal clearinghouse. Questioned Costs: Unknown. Recommendation: We recommend that Finance establish policies and procedures to ensure that the Federal funds are properly identified and reported accurately in the Schedule in accordance with Uniform Guidance requirements. We also recommend that individuals responsible for administering Federal assistance programs with the City receive training in grant administration. Auditee Response and Corrective Action Plan: Management agrees with the finding. Refer to the corrective action plan on current findings in Part V of this report. Auditor’s Conclusion: Finding remains as stated.
2024-002: Allocation of Costs Other Than Payroll Criteria or specific requirement: In accordance with Title 2 U.S. Code of Federal Regulations (CFR) Part 200.414, the Alliance must allocate indirect costs appropriately. Condition and context: The Alliance allocates certain shared costs, other than payroll, using an approach that details the full-time equivalents performing work on each grant. During the year ended June 30, 2024, costs were allocation using a schedule that did not agree to actual underlying payroll data. Additionally, the schedule that was used was not reviewed by the Executive Director. Cause: The Alliance does not have adequate staffing in place to ensure that the proper allocations were used. Effect or potential effect: Without adequate controls over this process, the Alliance could charge unallowable costs to the HIV Formula Grants. Questioned costs: None. Identification as a repeat finding, if applicable: Not applicable. Recommendation: The Alliance should ensure that internal control processes for the allocation of cost are consistently followed. A review process should be in place to ensure that accurate allocations are used. The Alliance could also consider the use of the de minimis cost rate, which would alleviate the need to create an allocation approach for shared costs. Effective October 1, 2024, the de minimis cost rate increased to 15%. Views of responsible officials: Refer to the Corrective Action Plan prepared by the Alliance in regard to this matter.
2024-002: Allocation of Costs Other Than Payroll Criteria or specific requirement: In accordance with Title 2 U.S. Code of Federal Regulations (CFR) Part 200.414, the Alliance must allocate indirect costs appropriately. Condition and context: The Alliance allocates certain shared costs, other than payroll, using an approach that details the full-time equivalents performing work on each grant. During the year ended June 30, 2024, costs were allocation using a schedule that did not agree to actual underlying payroll data. Additionally, the schedule that was used was not reviewed by the Executive Director. Cause: The Alliance does not have adequate staffing in place to ensure that the proper allocations were used. Effect or potential effect: Without adequate controls over this process, the Alliance could charge unallowable costs to the HIV Formula Grants. Questioned costs: None. Identification as a repeat finding, if applicable: Not applicable. Recommendation: The Alliance should ensure that internal control processes for the allocation of cost are consistently followed. A review process should be in place to ensure that accurate allocations are used. The Alliance could also consider the use of the de minimis cost rate, which would alleviate the need to create an allocation approach for shared costs. Effective October 1, 2024, the de minimis cost rate increased to 15%. Views of responsible officials: Refer to the Corrective Action Plan prepared by the Alliance in regard to this matter.
2024-002: Allocation of Costs Other Than Payroll Criteria or specific requirement: In accordance with Title 2 U.S. Code of Federal Regulations (CFR) Part 200.414, the Alliance must allocate indirect costs appropriately. Condition and context: The Alliance allocates certain shared costs, other than payroll, using an approach that details the full-time equivalents performing work on each grant. During the year ended June 30, 2024, costs were allocation using a schedule that did not agree to actual underlying payroll data. Additionally, the schedule that was used was not reviewed by the Executive Director. Cause: The Alliance does not have adequate staffing in place to ensure that the proper allocations were used. Effect or potential effect: Without adequate controls over this process, the Alliance could charge unallowable costs to the HIV Formula Grants. Questioned costs: None. Identification as a repeat finding, if applicable: Not applicable. Recommendation: The Alliance should ensure that internal control processes for the allocation of cost are consistently followed. A review process should be in place to ensure that accurate allocations are used. The Alliance could also consider the use of the de minimis cost rate, which would alleviate the need to create an allocation approach for shared costs. Effective October 1, 2024, the de minimis cost rate increased to 15%. Views of responsible officials: Refer to the Corrective Action Plan prepared by the Alliance in regard to this matter.
2024-002: Allocation of Costs Other Than Payroll Criteria or specific requirement: In accordance with Title 2 U.S. Code of Federal Regulations (CFR) Part 200.414, the Alliance must allocate indirect costs appropriately. Condition and context: The Alliance allocates certain shared costs, other than payroll, using an approach that details the full-time equivalents performing work on each grant. During the year ended June 30, 2024, costs were allocation using a schedule that did not agree to actual underlying payroll data. Additionally, the schedule that was used was not reviewed by the Executive Director. Cause: The Alliance does not have adequate staffing in place to ensure that the proper allocations were used. Effect or potential effect: Without adequate controls over this process, the Alliance could charge unallowable costs to the HIV Formula Grants. Questioned costs: None. Identification as a repeat finding, if applicable: Not applicable. Recommendation: The Alliance should ensure that internal control processes for the allocation of cost are consistently followed. A review process should be in place to ensure that accurate allocations are used. The Alliance could also consider the use of the de minimis cost rate, which would alleviate the need to create an allocation approach for shared costs. Effective October 1, 2024, the de minimis cost rate increased to 15%. Views of responsible officials: Refer to the Corrective Action Plan prepared by the Alliance in regard to this matter.
2024-002: Allocation of Costs Other Than Payroll Criteria or specific requirement: In accordance with Title 2 U.S. Code of Federal Regulations (CFR) Part 200.414, the Alliance must allocate indirect costs appropriately. Condition and context: The Alliance allocates certain shared costs, other than payroll, using an approach that details the full-time equivalents performing work on each grant. During the year ended June 30, 2024, costs were allocation using a schedule that did not agree to actual underlying payroll data. Additionally, the schedule that was used was not reviewed by the Executive Director. Cause: The Alliance does not have adequate staffing in place to ensure that the proper allocations were used. Effect or potential effect: Without adequate controls over this process, the Alliance could charge unallowable costs to the HIV Formula Grants. Questioned costs: None. Identification as a repeat finding, if applicable: Not applicable. Recommendation: The Alliance should ensure that internal control processes for the allocation of cost are consistently followed. A review process should be in place to ensure that accurate allocations are used. The Alliance could also consider the use of the de minimis cost rate, which would alleviate the need to create an allocation approach for shared costs. Effective October 1, 2024, the de minimis cost rate increased to 15%. Views of responsible officials: Refer to the Corrective Action Plan prepared by the Alliance in regard to this matter.
Criteria or specific requirement: 2 CFR 200.414(f) states that recipients may elect to charge a de minimis rate of up to 10 percent of modified total direct costs (MTDC). 2 CFR 200.1 “Modified Total Direct Cost (MTDC)” excludes equipment, capital expenditures, charges for patient care, rental costs, tuition remission, scholarships and fellowships, participant support costs, and the portion of each subaward in excess of $50,000. Condition: During testing of indirect costs, 4 of the 4 samples tested erroneously included rental costs in the calculation of Modified Total Direct Costs, resulting in an overcharge of indirect costs to the program. Questioned costs: None. Context: For allowable costs (indirect), a sample of 4 was made from a population of 12 reimbursement requests for the major program. Of the 4 sampled, all rental costs included in the calculation of Modified Total Direct Costs, resulting in a slightly higher indirect cost calculation. Cause: There is a misunderstanding of which costs should be excluded from the MTDC for this specific contract. Occupancy / Space Rental costs are identified but are not removed during the calculation of indirect costs. Effect: Inadequate allocation of indirect costs to federal programs may result in noncompliance with grant regulations, which could result in penalties or repayment obligations. Repeat Finding: 2023-002 Recommendation: CLA recommends that CCS work with the USCCB to update the Reimbursement Request form to include a section that removes items of selected cost from the calculation of indirect costs. Views of responsible officials: There is no disagreement with the audit finding.
Criteria or specific requirement: 2 CFR 200.414(f) states that recipients may elect to charge a de minimis rate of up to 10 percent of modified total direct costs (MTDC). 2 CFR 200.1 “Modified Total Direct Cost (MTDC)” excludes equipment, capital expenditures, charges for patient care, rental costs, tuition remission, scholarships and fellowships, participant support costs, and the portion of each subaward in excess of $50,000. Condition: During testing of indirect costs, 4 of the 4 samples tested erroneously included rental costs in the calculation of Modified Total Direct Costs, resulting in an overcharge of indirect costs to the program. Questioned costs: None. Context: For allowable costs (indirect), a sample of 4 was made from a population of 12 reimbursement requests for the major program. Of the 4 sampled, all rental costs included in the calculation of Modified Total Direct Costs, resulting in a slightly higher indirect cost calculation. Cause: There is a misunderstanding of which costs should be excluded from the MTDC for this specific contract. Occupancy / Space Rental costs are identified but are not removed during the calculation of indirect costs. Effect: Inadequate allocation of indirect costs to federal programs may result in noncompliance with grant regulations, which could result in penalties or repayment obligations. Repeat Finding: 2023-002 Recommendation: CLA recommends that CCS work with the USCCB to update the Reimbursement Request form to include a section that removes items of selected cost from the calculation of indirect costs. Views of responsible officials: There is no disagreement with the audit finding.
CONDITION The State Treasurer's Office did not make subrecipients aware of all required grant award information for the Mineral Leasing Act. CRITERIA 2 CFR 200.332 requires pass-through entities to communicate specific required information to subrecipients. Required information includes: - Subrecipients name (Must match the name associated with its unique entity identifier) - Subrecipients unique entity identifier - Federal award identification number (FAIN) - Federal award date - Subaward period of performance start and end date - Amount of Federal funds obligated in the subaward - Total amount of Federal funds obligated to the subrecipient by the pass-through entity, including the current financial obligation - Total amount of the Federal award committed to the subrecipient by the pass-through entity - Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA) - Name of the Federal agency, pass-through entity, and contact information for awarding official of the pass-through entity - Assistance listings title and number; the pass-through entity must identify the dollar amount made available under each federal award and the Assistance listings number at the time of disbursement - Identification of whether the Federal award is for research and development - Indirect cost rate for the Federal award (including if the de minimis rate is used) - All requirements of the subaward, including requirements imposed by federal statutes, regulations, and the terms and condition of the Federal award 2 CFR 200.303 requires non-Federal entities, in part, to 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. CAUSE Not all grant agreement requirements were included in the grant award template. EFFECT Subrecipients may not have been aware of all necessary grant information and requirements. CONTEXT There were 40 awards during the audit period of 7/1/2022 - 6/30/2024. There were 8 awards tested with 8 errors noted. The following criteria were missing: - (ii) Subrecipient's unique entity identifier; - (iii) Federal Award Identification Number (FAIN); - (xiii) Identification of whether the award is R&D; and - (xiv) Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. - (4) (i) An approved federally recognized indirect cost rate negotiated between the subrecipient and the Federal Government. If no approved rate exists, the pass-through entity must determine the appropriate rate in collaboration with the subrecipient, which is either: (A) The negotiated indirect cost rate between the pass-through entity and the subrecipient; which can be based on a prior negotiated rate between a different PTE and the same subrecipient. If basing the rate on a previously negotiated rate, the pass-through entity is not required to collect information justifying this rate, but may elect to do so; (B) The de minimus indirect cost rate. (ii) The pass-through entity must not require use of a de minimis indirect cost rate if the subrecipient has a Federally approved rate. Subrecipients can elect to use the cost allocation method to account for indirect costs in accordance with § 200.405(d). - (6) Appropriate terms and conditions concerning closeout of the subaward. Where sampling was performed, the audit used a non-statistical sampling method. IDENTIFICATION AS A REPEAT FINDING Not a repeat finding. RECOMMENDATION We recommend the State Treasurer's Office update its grant award templates to ensure that subrecipients are made award of all required grant award information. STATE TREASURER’S OFFICE RESPONSE The Office of the State Treasurer does agree with finding that our grant award template did not make subrecipients aware of all required grant award information for the Mineral Leasing Act as required. See “Management’s Response and Corrective Action” section of this report.
Criteria – 2 CFR §200.414 Indirect Costs – Entities must maintain accurate records and apply indirect costs consistently across all federal awards. They must also ensure that subrecipient indirect costs are managed in accordance with federal regulations. Condition/context – Indirect costs are not being requested, applied, billed, or reported consistently by the Organization. Indirect costs are not being applied to subrecipients consistently. We observed numerous errors in the application of indirect costs by the Organization, including: not requesting indirect costs in grant applications, negotiating non-de minimis rates with passthrough agencies after electing a de minimis rate, billing indirect costs in excess of indirect costs awarded in the grant agreement, erroneously including passthrough awards greater than $25,000 per subrecipient in the modified total direct cost base, approving indirect cost rates for subrecipients that did not match the subrecipient's elected de minimis rate, and including subrecipient indirect costs in the section of SF-425 reports reserved for reporting its own indirect costs. Questioned costs – $27,467 Cause/effect – The Organization has decentralized grant controls which are not designed to ensure compliance over indirect costs and consistency of application across all federal awards. Indirect costs in excess of allowable indirect costs were billed to federal awards. Repeat finding – No. Recommendation – The Organization should develop procedures and internal controls to ensure indirect cost rates are requested, applied, billed, and reported consistently across all federal awards using the same rate. The Organization should develop similar procedures to ensure it is awarding and reporting subrecipient indirect costs accurately. The Organization should ensure individuals responsible for these controls are adequately trained.
Criteria – 2 CFR §200.414 Indirect Costs – Entities must maintain accurate records and apply indirect costs consistently across all federal awards. They must also ensure that subrecipient indirect costs are managed in accordance with federal regulations. Condition/context – Indirect costs are not being requested, applied, billed, or reported consistently by the Organization. Indirect costs are not being applied to subrecipients consistently. We observed numerous errors in the application of indirect costs by the Organization, including: not requesting indirect costs in grant applications, negotiating non-de minimis rates with passthrough agencies after electing a de minimis rate, billing indirect costs in excess of indirect costs awarded in the grant agreement, erroneously including passthrough awards greater than $25,000 per subrecipient in the modified total direct cost base, approving indirect cost rates for subrecipients that did not match the subrecipient's elected de minimis rate, and including subrecipient indirect costs in the section of SF-425 reports reserved for reporting its own indirect costs. Questioned costs – $27,467 Cause/effect – The Organization has decentralized grant controls which are not designed to ensure compliance over indirect costs and consistency of application across all federal awards. Indirect costs in excess of allowable indirect costs were billed to federal awards. Repeat finding – No. Recommendation – The Organization should develop procedures and internal controls to ensure indirect cost rates are requested, applied, billed, and reported consistently across all federal awards using the same rate. The Organization should develop similar procedures to ensure it is awarding and reporting subrecipient indirect costs accurately. The Organization should ensure individuals responsible for these controls are adequately trained.
Criteria – 2 CFR §200.414 Indirect Costs – Entities must maintain accurate records and apply indirect costs consistently across all federal awards. They must also ensure that subrecipient indirect costs are managed in accordance with federal regulations. Condition/context – Indirect costs are not being requested, applied, billed, or reported consistently by the Organization. Indirect costs are not being applied to subrecipients consistently. We observed numerous errors in the application of indirect costs by the Organization, including: not requesting indirect costs in grant applications, negotiating non-de minimis rates with passthrough agencies after electing a de minimis rate, billing indirect costs in excess of indirect costs awarded in the grant agreement, erroneously including passthrough awards greater than $25,000 per subrecipient in the modified total direct cost base, approving indirect cost rates for subrecipients that did not match the subrecipient's elected de minimis rate, and including subrecipient indirect costs in the section of SF-425 reports reserved for reporting its own indirect costs. Questioned costs – $27,467 Cause/effect – The Organization has decentralized grant controls which are not designed to ensure compliance over indirect costs and consistency of application across all federal awards. Indirect costs in excess of allowable indirect costs were billed to federal awards. Repeat finding – No. Recommendation – The Organization should develop procedures and internal controls to ensure indirect cost rates are requested, applied, billed, and reported consistently across all federal awards using the same rate. The Organization should develop similar procedures to ensure it is awarding and reporting subrecipient indirect costs accurately. The Organization should ensure individuals responsible for these controls are adequately trained.
Criteria – 2 CFR §200.414 Indirect Costs – Entities must maintain accurate records and apply indirect costs consistently across all federal awards. They must also ensure that subrecipient indirect costs are managed in accordance with federal regulations. Condition/context – Indirect costs are not being requested, applied, billed, or reported consistently by the Organization. Indirect costs are not being applied to subrecipients consistently. We observed numerous errors in the application of indirect costs by the Organization, including: not requesting indirect costs in grant applications, negotiating non-de minimis rates with passthrough agencies after electing a de minimis rate, billing indirect costs in excess of indirect costs awarded in the grant agreement, erroneously including passthrough awards greater than $25,000 per subrecipient in the modified total direct cost base, approving indirect cost rates for subrecipients that did not match the subrecipient's elected de minimis rate, and including subrecipient indirect costs in the section of SF-425 reports reserved for reporting its own indirect costs. Questioned costs – $27,467 Cause/effect – The Organization has decentralized grant controls which are not designed to ensure compliance over indirect costs and consistency of application across all federal awards. Indirect costs in excess of allowable indirect costs were billed to federal awards. Repeat finding – No. Recommendation – The Organization should develop procedures and internal controls to ensure indirect cost rates are requested, applied, billed, and reported consistently across all federal awards using the same rate. The Organization should develop similar procedures to ensure it is awarding and reporting subrecipient indirect costs accurately. The Organization should ensure individuals responsible for these controls are adequately trained.
Criteria – 2 CFR §200.414 Indirect Costs – Entities must maintain accurate records and apply indirect costs consistently across all federal awards. They must also ensure that subrecipient indirect costs are managed in accordance with federal regulations. Condition/context – Indirect costs are not being requested, applied, billed, or reported consistently by the Organization. Indirect costs are not being applied to subrecipients consistently. We observed numerous errors in the application of indirect costs by the Organization, including: not requesting indirect costs in grant applications, negotiating non-de minimis rates with passthrough agencies after electing a de minimis rate, billing indirect costs in excess of indirect costs awarded in the grant agreement, erroneously including passthrough awards greater than $25,000 per subrecipient in the modified total direct cost base, approving indirect cost rates for subrecipients that did not match the subrecipient's elected de minimis rate, and including subrecipient indirect costs in the section of SF-425 reports reserved for reporting its own indirect costs. Questioned costs – $27,467 Cause/effect – The Organization has decentralized grant controls which are not designed to ensure compliance over indirect costs and consistency of application across all federal awards. Indirect costs in excess of allowable indirect costs were billed to federal awards. Repeat finding – No. Recommendation – The Organization should develop procedures and internal controls to ensure indirect cost rates are requested, applied, billed, and reported consistently across all federal awards using the same rate. The Organization should develop similar procedures to ensure it is awarding and reporting subrecipient indirect costs accurately. The Organization should ensure individuals responsible for these controls are adequately trained.
Significant Deficiency Other Noncompliance Program: Assistance Listing: 10.553/10.555 – Child Nutrition Cluster Assistance Listing: 84.425D – Elementary and Secondary School Emergency Relief Fund (ESSER II) Repeat Finding: No Criteria: 2 CFR 200.303 requires that a non-federal entity establish, document and maintain effective internal control over a federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statues, regulations, and the terms and conditions of the federal award. These internal controls should align with the 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). 7 CFR 210.14(g) also requires school food authorities to follow fair and consistent methodologies to identify and allocate allowable indirect costs to the nonprofit school food service account, in accordance with 2 CFR part 200 as implemented by 2 CFR part 400. Condition: Our procedures indicate that the District’s internal control system is inadequate for ensuring that indirect costs charged to various federal grant programs are adequately documented and accurately calculated. Specifically: Child Nutrition Cluster: The District could not provide documentation of its calculation to support the $25,000 per quarter requested as reimbursement for indirect costs. Elementary and Secondary School Emergency Relief (ESSER II): The District used an indirect cost rate from a prior year to calculate indirect costs charged to the ESSER II program which resulted in an overcharge of $68,829. Our procedures indicate that the District’s internal control system is insufficient to ensure that the indirect cost charged to the program is accurately calculated and based on calculations that meet the requirements outlined in Sections 2 CFR 200.303, 2 CFR 200.414 and Appendix VII to Part 200. Context/ Perspective: This finding arises from our audit procedures on internal control, where attempted to obtain documentation of the District's calculation and subsequent approval of reimbursement for indirect costs as well as other procedures performed by us recalculating indirect costs charged to certain federal grant programs. Cause: The District lacks the necessary internal controls to ensure that requests for reimbursement of indirect costs are accurately calculated, properly documented and approved by the appropriate director. Effect: The lack of adequate internal controls over the calculation of indirect cost reimbursement may increase the risk of misappropriation or loss of public funds. It could also result in inappropriate charges to the federal award, potentially leading to disallowed costs being applied to the program. Questioned Costs: $68,829 (Elementary and Secondary School Emergency Relief II) Recommendation: The District should implement stronger internal controls to ensure that indirect cost reimbursements are accurately calculated, properly documented, and approved by the appropriate federal grant program director. Views of Responsible Officials: The Auditee’s Corrective Action Plan lists the District’s response to the findings.
Significant Deficiency Other Noncompliance Program: Assistance Listing: 10.553/10.555 – Child Nutrition Cluster Assistance Listing: 84.425D – Elementary and Secondary School Emergency Relief Fund (ESSER II) Repeat Finding: No Criteria: 2 CFR 200.303 requires that a non-federal entity establish, document and maintain effective internal control over a federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statues, regulations, and the terms and conditions of the federal award. These internal controls should align with the 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). 7 CFR 210.14(g) also requires school food authorities to follow fair and consistent methodologies to identify and allocate allowable indirect costs to the nonprofit school food service account, in accordance with 2 CFR part 200 as implemented by 2 CFR part 400. Condition: Our procedures indicate that the District’s internal control system is inadequate for ensuring that indirect costs charged to various federal grant programs are adequately documented and accurately calculated. Specifically: Child Nutrition Cluster: The District could not provide documentation of its calculation to support the $25,000 per quarter requested as reimbursement for indirect costs. Elementary and Secondary School Emergency Relief (ESSER II): The District used an indirect cost rate from a prior year to calculate indirect costs charged to the ESSER II program which resulted in an overcharge of $68,829. Our procedures indicate that the District’s internal control system is insufficient to ensure that the indirect cost charged to the program is accurately calculated and based on calculations that meet the requirements outlined in Sections 2 CFR 200.303, 2 CFR 200.414 and Appendix VII to Part 200. Context/ Perspective: This finding arises from our audit procedures on internal control, where attempted to obtain documentation of the District's calculation and subsequent approval of reimbursement for indirect costs as well as other procedures performed by us recalculating indirect costs charged to certain federal grant programs. Cause: The District lacks the necessary internal controls to ensure that requests for reimbursement of indirect costs are accurately calculated, properly documented and approved by the appropriate director. Effect: The lack of adequate internal controls over the calculation of indirect cost reimbursement may increase the risk of misappropriation or loss of public funds. It could also result in inappropriate charges to the federal award, potentially leading to disallowed costs being applied to the program. Questioned Costs: $68,829 (Elementary and Secondary School Emergency Relief II) Recommendation: The District should implement stronger internal controls to ensure that indirect cost reimbursements are accurately calculated, properly documented, and approved by the appropriate federal grant program director. Views of Responsible Officials: The Auditee’s Corrective Action Plan lists the District’s response to the findings.
Significant Deficiency Other Noncompliance Program: Assistance Listing: 10.553/10.555 – Child Nutrition Cluster Assistance Listing: 84.425D – Elementary and Secondary School Emergency Relief Fund (ESSER II) Repeat Finding: No Criteria: 2 CFR 200.303 requires that a non-federal entity establish, document and maintain effective internal control over a federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statues, regulations, and the terms and conditions of the federal award. These internal controls should align with the 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). 7 CFR 210.14(g) also requires school food authorities to follow fair and consistent methodologies to identify and allocate allowable indirect costs to the nonprofit school food service account, in accordance with 2 CFR part 200 as implemented by 2 CFR part 400. Condition: Our procedures indicate that the District’s internal control system is inadequate for ensuring that indirect costs charged to various federal grant programs are adequately documented and accurately calculated. Specifically: Child Nutrition Cluster: The District could not provide documentation of its calculation to support the $25,000 per quarter requested as reimbursement for indirect costs. Elementary and Secondary School Emergency Relief (ESSER II): The District used an indirect cost rate from a prior year to calculate indirect costs charged to the ESSER II program which resulted in an overcharge of $68,829. Our procedures indicate that the District’s internal control system is insufficient to ensure that the indirect cost charged to the program is accurately calculated and based on calculations that meet the requirements outlined in Sections 2 CFR 200.303, 2 CFR 200.414 and Appendix VII to Part 200. Context/ Perspective: This finding arises from our audit procedures on internal control, where attempted to obtain documentation of the District's calculation and subsequent approval of reimbursement for indirect costs as well as other procedures performed by us recalculating indirect costs charged to certain federal grant programs. Cause: The District lacks the necessary internal controls to ensure that requests for reimbursement of indirect costs are accurately calculated, properly documented and approved by the appropriate director. Effect: The lack of adequate internal controls over the calculation of indirect cost reimbursement may increase the risk of misappropriation or loss of public funds. It could also result in inappropriate charges to the federal award, potentially leading to disallowed costs being applied to the program. Questioned Costs: $68,829 (Elementary and Secondary School Emergency Relief II) Recommendation: The District should implement stronger internal controls to ensure that indirect cost reimbursements are accurately calculated, properly documented, and approved by the appropriate federal grant program director. Views of Responsible Officials: The Auditee’s Corrective Action Plan lists the District’s response to the findings.
Finding Number: 2024-009 State/Educational Agency(s): Arkansas Department of Commerce – Arkansas Economic Development Commission Pass-Through Entity: Not Applicable ALN Number(s) and Program Title(s): 21.027 – COVID 19: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Federal Awarding Agency: U.S. Department of the Treasury Federal Award Number(s): SLFRP3627 Federal Award Year(s): 2021 Compliance Requirement(s) Affected: Subrecipient Monitoring Type of Finding: Material Noncompliance and Material Weakness Repeat Finding: A similar issue was reported in prior-year finding 2023-008. Criteria: In accordance with 2 CFR § 200.332(a)(1), all pass-through entities must ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward: i. Subrecipient name (which must match the name associated with its unique entity identifier). ii. Subrecipient's unique entity identifier. iii. Federal Award Identification Number (FAIN). iv. Federal award date. v. Subaward Period of Performance start and end date. vi. Subaward budget period start and end date. vii. Amount of federal funds obligated to the subrecipient. viii. Total amount of federal funds obligated to the subrecipient by the pass-through entity, including the current financial obligation. ix. Total amount of the federal award committed to the subrecipient by the pass-through entity. x. Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA). xi. Name of federal agency, pass-through entity, and contact information for awarding official of the pass-through entity. xii. Assistance listings title and number (ALN); the pass-through entity must identify the dollar amount made available under each federal award and the ALN at the time of disbursement. xiii. Identification of whether the federal award is research and development. xiv. Indirect cost rate for the federal award (including if the de minimis rate is used in accordance with § 200.414). In addition, 2 CFR § 200.332(a)(4) requires an approved, federally recognized indirect cost rate between the subrecipient and the federal awarding agency. Condition and Context: ALA staff reviewed seven executed grant agreements, totaling $42,681,880, to determine if they met the Uniform Guidance criteria. Five of these grant agreements were selected randomly, and the remaining two were selected based upon concerns communicated to ALA by the Agency. The following deficiencies were noted in the two grant agreements selected based upon Agency concerns: • The agreements, which totaled $6,549,322, did not include all required terms, specifically items ii, iii, v, xii, xiii, and xiv from the criteria noted above. • The agreements did not include indirect cost rate agreements. Statistically Valid Sample: Not a statistically valid sample Questioned Costs: None Cause: The Agency did not ensure staff were trained and knowledgeable regarding Uniform Guidance requirements for subrecipients. Effect: Without a proper grant agreement, subrecipients may be unaware that their award is subject to federal compliance requirements, and the Agency risks noncompliance with subrecipient monitoring requirements. Recommendation: ALA staff recommend the Agency provide training to appropriate staff to ensure adherence to Uniform Guidance regarding subrecipient monitoring. Views of Responsible Officials and Planned Corrective Action: In 2023, ASBO sent out Amendment #1 for all SLFRF subgrants. This amendment was a one-page sheet providing information for all the requirements listed in 2 CFR § 200.332(a)(1). The subrecipient listed in this finding, Extreme Broadband, did not acknowledge or return their amendment. We will begin to request acknowledgement from this provider on a continuous quarterly basis. Anticipated Completion Date: March 4, 2025 Contact Person: Glen Howie, Jr. Director, Ark State Broadband Office Department of Commerce 1 Commerce Way Little Rock, AR 72202 (501) 682-1123 Glen.Howie@Arkansas.gov
Finding Number: 2024-010 State/Educational Agency(s): Arkansas Department of Agriculture – Natural Resources Division Pass-Through Entity: Not Applicable ALN Number(s) and Program Title(s): 21.027 – COVID 19: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Federal Awarding Agency: U.S. Department of the Treasury Federal Award Number(s): SLFRP3627 Federal Award Year(s): 2021 Compliance Requirement(s) Affected: Subrecipient Monitoring Type of Finding: Material Noncompliance and Material Weakness Repeat Finding: Not applicable Criteria: In accordance with 2 CFR § 200.332(a)(1), all pass-through entities must: ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward: i. Subrecipient name (which must match the name associated with its unique entity identifier). ii. Subrecipient's unique entity identifier. iii. Federal Award Identification Number (FAIN). iv. Federal award date. v. Subaward Period of Performance start and end date. vi. Subaward budget period start and end date. vii. Amount of federal funds obligated in the subaward. viii. Total amount of federal funds obligated to the subrecipient by the pass-through entity, including the current financial obligation. ix. Total amount of the federal award committed to the subrecipient by the pass-through entity. x. Federal award project description, as required by the Federal Funding Accountability and Transparency Act (FFATA). xi. Name of federal agency, pass-through entity, and contact information for awarding official of the pass-through entity. xii. Assistance listings title and number (ALN); the pass-through entity must identify the dollar amount made available under each federal award and the ALN at the time of disbursement. xiii. Identification of whether the federal award is research and development. xiv. Indirect cost rate for the federal award (including if the de minimis rate is used in accordance with § 200.414). In addition, 2 CFR § 200.332(a)(4) requires an approved, federally recognized indirect cost rate between the subrecipient and the federal awarding agency. Condition and Context: ALA staff reviewed 13 executed grant agreements, totaling $29,342,709, to determine if they met the Uniform Guidance criteria. The following deficiencies were noted: • The 13 grant agreements did not include all required terms, specifically items ii, iii, v, vi, xi, xii, xiii, and xiv from the criteria noted above. • An indirect cost rate agreement could not be provided. Statistically Valid Sample: Not a statistically valid sample Questioned Costs: None Cause: The Agency did not ensure staff were trained and knowledgeable regarding Uniform Guidance requirements for subrecipients. Effect: Without a proper grant agreement, subrecipients may be unaware that their award is subject to federal compliance requirements, and the Agency risks noncompliance with subrecipient monitoring requirements. Recommendation: ALA staff recommend the Agency provide training to appropriate staff to ensure adherence to Uniform Guidance regarding subrecipient monitoring. Views of Responsible Officials and Planned Corrective Action: The Department will execute an amendment to the grant agreements for all ARPA funding not disbursed as of 7/1/2024 to include the missing data as detailed in the finding. Staff will be trained on Uniform Guidance requirements. Anticipated Completion Date: June 30, 2025 Contact Person: Debby Dickson Water Development Division Manager Arkansas Department of Agriculture-Natural Resources Division 1 Natural Resources Drive Little Rock, AR 72205 (501) 225-1598 Debra.Dickson@agriculture.arkansas.gov
2024-002 Indirect Costs Federal Agency: Department of Labor Federal Programs: 17.258/17.259/17.278 Workforce Innovation Opportunity Act (WIOA) Cluster (Passed through MassHire Department of Career Services (MDCS)) Condition: The Organization over billed grant awards under the WIOA Cluster $37,790 for indirect costs. Criteria: 2 CFR 200.414(f) of the Uniform Guidance allows entities that do not have a current negotiated indirect cost rate to charge federal awards a de minimus rate of 10% of modified total direct costs. The Uniform Guidance defines modified total direct costs as all direct salaries and wages, applicable fringe benefits, materials and supplies, services, travel, and up to the first $25,000 of each subaward. Cause: The Organization did not properly calculate its modified total direct costs for each federal award under the WIOA cluster resulting in the calculated indirect costs being overstated. Effect: The Organization has over billed grant awards under the WIOA cluster. Context: Modified total direct costs under the WIOA Cluster grant awards were $781,730 for the year ended June 30, 2024. The WIOA Cluster grants were billed for $115,963 in indirect costs for the year ended June 30, 2024. Questioned Costs: $37,790 Recommendation: We recommend that management return the over billed costs to the grantor and review its policies and procedures to ensure indirect costs are properly calculated and billed under the Uniform Guidance. Management Response: Management agrees with the finding. See management’s attached corrective action plan.
2024-002 Indirect Costs Federal Agency: Department of Labor Federal Programs: 17.258/17.259/17.278 Workforce Innovation Opportunity Act (WIOA) Cluster (Passed through MassHire Department of Career Services (MDCS)) Condition: The Organization over billed grant awards under the WIOA Cluster $37,790 for indirect costs. Criteria: 2 CFR 200.414(f) of the Uniform Guidance allows entities that do not have a current negotiated indirect cost rate to charge federal awards a de minimus rate of 10% of modified total direct costs. The Uniform Guidance defines modified total direct costs as all direct salaries and wages, applicable fringe benefits, materials and supplies, services, travel, and up to the first $25,000 of each subaward. Cause: The Organization did not properly calculate its modified total direct costs for each federal award under the WIOA cluster resulting in the calculated indirect costs being overstated. Effect: The Organization has over billed grant awards under the WIOA cluster. Context: Modified total direct costs under the WIOA Cluster grant awards were $781,730 for the year ended June 30, 2024. The WIOA Cluster grants were billed for $115,963 in indirect costs for the year ended June 30, 2024. Questioned Costs: $37,790 Recommendation: We recommend that management return the over billed costs to the grantor and review its policies and procedures to ensure indirect costs are properly calculated and billed under the Uniform Guidance. Management Response: Management agrees with the finding. See management’s attached corrective action plan.
2024-002 Indirect Costs Federal Agency: Department of Labor Federal Programs: 17.258/17.259/17.278 Workforce Innovation Opportunity Act (WIOA) Cluster (Passed through MassHire Department of Career Services (MDCS)) Condition: The Organization over billed grant awards under the WIOA Cluster $37,790 for indirect costs. Criteria: 2 CFR 200.414(f) of the Uniform Guidance allows entities that do not have a current negotiated indirect cost rate to charge federal awards a de minimus rate of 10% of modified total direct costs. The Uniform Guidance defines modified total direct costs as all direct salaries and wages, applicable fringe benefits, materials and supplies, services, travel, and up to the first $25,000 of each subaward. Cause: The Organization did not properly calculate its modified total direct costs for each federal award under the WIOA cluster resulting in the calculated indirect costs being overstated. Effect: The Organization has over billed grant awards under the WIOA cluster. Context: Modified total direct costs under the WIOA Cluster grant awards were $781,730 for the year ended June 30, 2024. The WIOA Cluster grants were billed for $115,963 in indirect costs for the year ended June 30, 2024. Questioned Costs: $37,790 Recommendation: We recommend that management return the over billed costs to the grantor and review its policies and procedures to ensure indirect costs are properly calculated and billed under the Uniform Guidance. Management Response: Management agrees with the finding. See management’s attached corrective action plan.
2 CFR § 3474.1 gives regulatory effect to the Department of Education for 2 CFR § 200.332, which established requirements over subawards for pass-through entities and states, in part: All pass-through entities must: a) Verify that the subrecipient is not excluded or disqualified in accordance with § 180.300. Verification methods are provided in § 180.300, which include confirming in SAM.gov that a potential subrecipient is not suspended, debarred, or otherwise excluded from receiving Federal funds. b) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: 1. Federal award identification. i. Subrecipient name (which must match the name associated with its unique entity identifier); ii. Subrecipient's unique entity identifier; iii. Federal Award Identification Number (FAIN); iv. Federal Award Date (see the definition of Federal award date in §200.1 of this part) of award to the recipient by the Federal agency; v. Subaward Period of Performance Start and End Date; vi. Subaward Budget Period Start and End Date; vii. Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; viii. Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; ix. Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; x. Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); xi. Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; xii. Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; xiii. Identification of whether the award is R&D; and xiv. Indirect cost rate for the Federal award (including if the de minimis rate is charged) per §200.414. c) Evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraph (f) of this section; d) If appropriate, consider implementing specific conditions in a subaward as described in § 200.208 and notify the Federal agency of the specific conditions. e) Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved; f) Depending upon the pass-through entity's assessment of risk posed by the subrecipient (as described in paragraph (c) of this section), the CFR lists monitoring tools that may be useful for the pass-through entity to ensure proper accountability and compliance with program requirements and achievement of performance goals. We noted the District did not perform a subrecipient checklist prior to allocating funds. Additionally, the District did not complete monitoring procedures for subrecipients. Further, we noted the District signed a service agreement with the subrecipient; however, the agreement did not specifically identify the subrecipient as a subrecipient or include all award information as required above. Per inquiry of the Treasurer, the District does not review audit reports of the subrecipient for any noted deficiencies. The District should implement procedures to verify that all required reviews and any additional required follow ups are completed and accurately documented. Further, the District should ensure all required information is included in the subrecipient agreement. We recommend that the District request copies of annual audit reports of the subrecipient to review the report for any potential deficiencies.
2 CFR § 3474.1 gives regulatory effect to the Department of Education for 2 CFR § 200.332, which established requirements over subawards for pass-through entities and states, in part: All pass-through entities must: a) Verify that the subrecipient is not excluded or disqualified in accordance with § 180.300. Verification methods are provided in § 180.300, which include confirming in SAM.gov that a potential subrecipient is not suspended, debarred, or otherwise excluded from receiving Federal funds. b) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: 1. Federal award identification. i. Subrecipient name (which must match the name associated with its unique entity identifier); ii. Subrecipient's unique entity identifier; iii. Federal Award Identification Number (FAIN); iv. Federal Award Date (see the definition of Federal award date in §200.1 of this part) of award to the recipient by the Federal agency; v. Subaward Period of Performance Start and End Date; vi. Subaward Budget Period Start and End Date; vii. Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; viii. Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; ix. Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; x. Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); xi. Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; xii. Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; xiii. Identification of whether the award is R&D; and xiv. Indirect cost rate for the Federal award (including if the de minimis rate is charged) per §200.414. c) Evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraph (f) of this section; d) If appropriate, consider implementing specific conditions in a subaward as described in § 200.208 and notify the Federal agency of the specific conditions. e) Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved; f) Depending upon the pass-through entity's assessment of risk posed by the subrecipient (as described in paragraph (c) of this section), the CFR lists monitoring tools that may be useful for the pass-through entity to ensure proper accountability and compliance with program requirements and achievement of performance goals. We noted the District did not perform a subrecipient checklist prior to allocating funds. Additionally, the District did not complete monitoring procedures for subrecipients. Further, we noted the District signed a service agreement with the subrecipient; however, the agreement did not specifically identify the subrecipient as a subrecipient or include all award information as required above. Per inquiry of the Treasurer, the District does not review audit reports of the subrecipient for any noted deficiencies. The District should implement procedures to verify that all required reviews and any additional required follow ups are completed and accurately documented. Further, the District should ensure all required information is included in the subrecipient agreement. We recommend that the District request copies of annual audit reports of the subrecipient to review the report for any potential deficiencies.
Reference Number: 2024-006 – Subrecipient Monitoring Federal Program Title: WIOA Cluster Federal Assistance Listing Number: 17.258 BWC Federal Agency: Department of Labor (DOL) Pass-Through Entity: State of California Employment Development Department Federal Award Number and Year: AA211079 Fiscal Year 2023-2024 Category of Finding: Subrecipient Monitoring Type of Finding: Material Weakness in Internal Control over Compliance, Instance of Noncompliance Criteria In accordance with Title 2 U.S. Code of Federal Regulations (CFR) § 200.332, all pass-through entities (PTE) must: (a) Ensure that every subaward is clearly identified to the subrecipient as a subaward and includes the following information at the time of the subaward and if any of these data elements change, include the changes in subsequent subaward modification. When some of this information is not available, the pass-through entity must provide the best information available to describe the Federal award and subaward. Required information includes: (1) Federal award identification: i. Subrecipient name (which must match the name associated with its unique entity identifier); ii. Subrecipient's unique entity identifier; iii. Federal Award Identification Number (FAIN); iv. Federal Award Date (see the definition of Federal award date in § 200.1 of this part) of award to the recipient by the Federal agency; v. Subaward Period of Performance Start and End Date; vi. Subaward Budget Period Start and End Date; vii. Amount of Federal Funds Obligated by this action by the pass-through entity to the subrecipient; viii. Total Amount of Federal Funds Obligated to the subrecipient by the pass-through entity including the current financial obligation; ix. Total Amount of the Federal Award committed to the subrecipient by the pass-through entity; x. Federal award project description, as required to be responsive to the Federal Funding Accountability and Transparency Act (FFATA); xi. Name of Federal awarding agency, pass-through entity, and contact information for awarding official of the Pass-through entity; xii. Assistance Listings number and Title; the pass-through entity must identify the dollar amount made available under each Federal award and the Assistance Listings Number at time of disbursement; xiii. Identification of whether the award is R&D; and xiv. Indirect cost rate for the Federal award (including if the de minimis rate is charged) per § 200.414. (b) Evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section. (c) Monitor the activities of the subrecipient as necessary to ensure that the subaward is used for authorized purposes, in compliance with Federal statutes, regulations, and the terms and conditions of the subaward; and that subaward performance goals are achieved. (d) Verify that every subrecipient is audited as required by Subpart F of this part when it is expected that the subrecipient's Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in § 200.501. Condition During our audit of compliance with subrecipient monitoring, we noted that for one (1) subrecipient agreement, the agreement did not include one or more of the required elements defined in 2 CFR § 200.332 (a)(1) in the subrecipient’s agreement. For the same one (1) subrecipient, the Organization did not perform the risk assessment procedures defined in 2 CFR § 200.332 (b) or verify that the subrecipient should be audited as defined in 2 CFR § 200.332 (d). Cause Due to significant turnover in key personnel in the Organization’s finance department and management in past years, the Organization has no documented policies and procedures for subrecipient monitoring. Effect Not providing sufficient documentation to auditors to demonstrate compliance with federal compliance results in an audit scope limitation. Failure to provide all the required subaward information may result in subrecipients incorrectly reporting on federal pass-through awards in their Single Audit reports. Failure to document subrecipient risk assessment and verifying the subrecipient audit requirement result in noncompliance with the subrecipient monitoring requirements 2 CFR § 200.332. Questioned Costs Questioned costs were not determinable. Context For one (1) subrecipient selected for testing, with total expenditures of $325,977, from a population of one (1) subrecipient, the Company did not communicate all of the required subaward data elements, did not perform subrecipient risk assessment, and did not verify if subrecipient received audit. The sample was not a statistically valid sample. Recommendation We recommend that the Organization perform the following: (1) Develop procedures for future subrecipient agreements to ensure agreements will include all the required elements of 2 CFR § 200.332 (a)(1). (2) For existing subrecipients that were not provided the required elements, provide a letter or amended agreement to include all the required elements of 2 CFR § 200.332 (a)(1). (3) Maintain sufficient records of subrecipient risk assessment and monitoring subrecipients in accordance with subrecipient monitoring requirements noted in 2 CFR § 200.332 (b) – (d). Views of Responsible Officials and Planned Corrective Action Person responsible: Leona Smith Di Faustino, Interim Executive Director Corrective Action Plan: The Organization will update its subrecipient monitoring policies to ensure all required elements as defined in 2 CFR § 200.332 (a)(1) are included in subrecipient agreements, Additionally, a checklist will be established to perform a risk assessment process to evaluate subrecipient risk prior to contract execution and annually thereafter and to verify each subrecipient’s that meets the audit threshold and if required has a current Single Audit on file or is otherwise in compliance. Anticipated Implementation Date: July 1, 2025
Finding Reference Number: 2024-008 NH Fish and Game Department Fish and Wildlife Cluster (Assistance Listing #15.605, #15.611, #15.626) Federal Award Numbers: F22AF00995-00, F22AF00929-00, F23AF03086-00, F22AF00514-01, F22AF02616-02, F21AF04100-02, F21AF03886-03 Federal Award Year: 2021, 2022, 2023 U.S. Department of Interior Compliance Requirement: Matching Type of Finding: Material Weakness and Material Noncompliance Prior Year Finding: N/A Statistically Valid Sample: The sample was not intended to be, and was not, a statistically valid sample. Criteria In-kind match requirement is to test records to corroborate the values placed on in-kind contributions (including third party in-kind contributions) are in accordance with 2 CFR 200.306, 200.434, and 200.414, and the terms and conditions of the award. Additionally, per 2 CFR section 200.303, non-federal entities must establish and maintain effective internal control over federal awards that provide 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. Condition To meet the federal match required under the program, the New Hampshire Fish and Game Department (the Department) utilizes in-kind match that is earned from volunteer hours and costs contributed by its third party subrecipient. During our testwork over in-kind match, we identified the following: A. For 7 of 9 subrecipient invoices selected for testwork used to support the Department’s in-kind match, we were unable to obtain documentation to support the amount of the in-kind match earned. For each of the 7 sample selections, the value of the in-kind contribution was handwritten on the subrecipient's invoice for unrelated services. There was no documentation obtained to support the accuracy of this handwritten amount. Upon inquiry, the Department confirmed that no further verification was performed to ensure the subrecipient's in-kind match was accurate and based upon costs in support of the grant associated with the in-kind match. B. For 1 of 4 volunteer in-kind match contribution calculations, the Department incorrectly allocated volunteer hours using the prior fiscal year rates, resulting in an excess of in-kind match being recorded as earned. In addition, we were unable to verify the existence of 1 of the volunteer timesheets used in this calculation for this sample selection. Cause The cause of the condition found is primarily due to insufficient internal controls to ensure that the value of the match contributed by its subrecipient is complete and accurate. Due to the long-standing and collaborative relationship between the Department and the subrecipient, the Department has not developed or implemented formalized policies and procedures related to validating the existence of in-kind match earned. Further, related to the volunteer hours, the cause of the condition is due to human error. With over 250 timesheets to process, the volume of data and calculations are susceptible to error. Effect The effect of the condition found is that the Department did not have appropriate documentation to support the in-kind match earned and applied against its federal award in support of federal funds that were drawn. This could lead to unallowable costs being charged to the grant if the sufficient match was not made. Questioned Costs: $201,250 Recommendation We recommend that the Department implement written policies and procedures surrounding the tracking of in-kind match. Internal controls should be implemented to ensure the accuracy of the in-kind match earned, including ensuring that there is supporting documentation to substantiate the amount earned. The existing policies and procedures should also be enhanced related to volunteer time to monitor to ensure that all required timesheets are completed before using the volunteer time in support of its matching requirement and that the appropriate rate is used when determining the value of the volunteer in-kind match. View of Responsible Officials: Management concurs with this finding except for the questioned cost amount. Rejoinder: As documented within the condition found, we were unable to obtain sufficient documentation to support in-kind matching costs. As a result of our audit procedures, we identified questioned costs of $201,250.
Finding Reference Number: 2024-008 NH Fish and Game Department Fish and Wildlife Cluster (Assistance Listing #15.605, #15.611, #15.626) Federal Award Numbers: F22AF00995-00, F22AF00929-00, F23AF03086-00, F22AF00514-01, F22AF02616-02, F21AF04100-02, F21AF03886-03 Federal Award Year: 2021, 2022, 2023 U.S. Department of Interior Compliance Requirement: Matching Type of Finding: Material Weakness and Material Noncompliance Prior Year Finding: N/A Statistically Valid Sample: The sample was not intended to be, and was not, a statistically valid sample. Criteria In-kind match requirement is to test records to corroborate the values placed on in-kind contributions (including third party in-kind contributions) are in accordance with 2 CFR 200.306, 200.434, and 200.414, and the terms and conditions of the award. Additionally, per 2 CFR section 200.303, non-federal entities must establish and maintain effective internal control over federal awards that provide 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. Condition To meet the federal match required under the program, the New Hampshire Fish and Game Department (the Department) utilizes in-kind match that is earned from volunteer hours and costs contributed by its third party subrecipient. During our testwork over in-kind match, we identified the following: A. For 7 of 9 subrecipient invoices selected for testwork used to support the Department’s in-kind match, we were unable to obtain documentation to support the amount of the in-kind match earned. For each of the 7 sample selections, the value of the in-kind contribution was handwritten on the subrecipient's invoice for unrelated services. There was no documentation obtained to support the accuracy of this handwritten amount. Upon inquiry, the Department confirmed that no further verification was performed to ensure the subrecipient's in-kind match was accurate and based upon costs in support of the grant associated with the in-kind match. B. For 1 of 4 volunteer in-kind match contribution calculations, the Department incorrectly allocated volunteer hours using the prior fiscal year rates, resulting in an excess of in-kind match being recorded as earned. In addition, we were unable to verify the existence of 1 of the volunteer timesheets used in this calculation for this sample selection. Cause The cause of the condition found is primarily due to insufficient internal controls to ensure that the value of the match contributed by its subrecipient is complete and accurate. Due to the long-standing and collaborative relationship between the Department and the subrecipient, the Department has not developed or implemented formalized policies and procedures related to validating the existence of in-kind match earned. Further, related to the volunteer hours, the cause of the condition is due to human error. With over 250 timesheets to process, the volume of data and calculations are susceptible to error. Effect The effect of the condition found is that the Department did not have appropriate documentation to support the in-kind match earned and applied against its federal award in support of federal funds that were drawn. This could lead to unallowable costs being charged to the grant if the sufficient match was not made. Questioned Costs: $201,250 Recommendation We recommend that the Department implement written policies and procedures surrounding the tracking of in-kind match. Internal controls should be implemented to ensure the accuracy of the in-kind match earned, including ensuring that there is supporting documentation to substantiate the amount earned. The existing policies and procedures should also be enhanced related to volunteer time to monitor to ensure that all required timesheets are completed before using the volunteer time in support of its matching requirement and that the appropriate rate is used when determining the value of the volunteer in-kind match. View of Responsible Officials: Management concurs with this finding except for the questioned cost amount. Rejoinder: As documented within the condition found, we were unable to obtain sufficient documentation to support in-kind matching costs. As a result of our audit procedures, we identified questioned costs of $201,250.
Finding Reference Number: 2024-008 NH Fish and Game Department Fish and Wildlife Cluster (Assistance Listing #15.605, #15.611, #15.626) Federal Award Numbers: F22AF00995-00, F22AF00929-00, F23AF03086-00, F22AF00514-01, F22AF02616-02, F21AF04100-02, F21AF03886-03 Federal Award Year: 2021, 2022, 2023 U.S. Department of Interior Compliance Requirement: Matching Type of Finding: Material Weakness and Material Noncompliance Prior Year Finding: N/A Statistically Valid Sample: The sample was not intended to be, and was not, a statistically valid sample. Criteria In-kind match requirement is to test records to corroborate the values placed on in-kind contributions (including third party in-kind contributions) are in accordance with 2 CFR 200.306, 200.434, and 200.414, and the terms and conditions of the award. Additionally, per 2 CFR section 200.303, non-federal entities must establish and maintain effective internal control over federal awards that provide 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. Condition To meet the federal match required under the program, the New Hampshire Fish and Game Department (the Department) utilizes in-kind match that is earned from volunteer hours and costs contributed by its third party subrecipient. During our testwork over in-kind match, we identified the following: A. For 7 of 9 subrecipient invoices selected for testwork used to support the Department’s in-kind match, we were unable to obtain documentation to support the amount of the in-kind match earned. For each of the 7 sample selections, the value of the in-kind contribution was handwritten on the subrecipient's invoice for unrelated services. There was no documentation obtained to support the accuracy of this handwritten amount. Upon inquiry, the Department confirmed that no further verification was performed to ensure the subrecipient's in-kind match was accurate and based upon costs in support of the grant associated with the in-kind match. B. For 1 of 4 volunteer in-kind match contribution calculations, the Department incorrectly allocated volunteer hours using the prior fiscal year rates, resulting in an excess of in-kind match being recorded as earned. In addition, we were unable to verify the existence of 1 of the volunteer timesheets used in this calculation for this sample selection. Cause The cause of the condition found is primarily due to insufficient internal controls to ensure that the value of the match contributed by its subrecipient is complete and accurate. Due to the long-standing and collaborative relationship between the Department and the subrecipient, the Department has not developed or implemented formalized policies and procedures related to validating the existence of in-kind match earned. Further, related to the volunteer hours, the cause of the condition is due to human error. With over 250 timesheets to process, the volume of data and calculations are susceptible to error. Effect The effect of the condition found is that the Department did not have appropriate documentation to support the in-kind match earned and applied against its federal award in support of federal funds that were drawn. This could lead to unallowable costs being charged to the grant if the sufficient match was not made. Questioned Costs: $201,250 Recommendation We recommend that the Department implement written policies and procedures surrounding the tracking of in-kind match. Internal controls should be implemented to ensure the accuracy of the in-kind match earned, including ensuring that there is supporting documentation to substantiate the amount earned. The existing policies and procedures should also be enhanced related to volunteer time to monitor to ensure that all required timesheets are completed before using the volunteer time in support of its matching requirement and that the appropriate rate is used when determining the value of the volunteer in-kind match. View of Responsible Officials: Management concurs with this finding except for the questioned cost amount. Rejoinder: As documented within the condition found, we were unable to obtain sufficient documentation to support in-kind matching costs. As a result of our audit procedures, we identified questioned costs of $201,250.