Finding 2024-023 U.S. Department of Health and Human Services AL No. 93.778 Medical Assistance Program (Medicaid; Title XIX) Material Weakness in Internal Controls in Noncompliance over Reporting Repeat Finding: Yes; 2023-019 Condition: For 4 out of 4 selections, we were unable to agree the expenditure details from the general ledger to the amounts reported on the Medical Assistance Transportation report, the Maryland Children Health Program (MCHP) - Eligibility report, the Administrative Care Coordination report and Supplemental Administrative Care Coordination 440 report to ensure completeness, accuracy and compliance with required accounting basis. Additionally, we were unable to verify if the Federal Funding Accountability and Transparency Act (FFATA) report was prepared and submitted. Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Under the requirements of the Federal Funding Accountability and Transparency Act (Pub. L. No. 109-282), as amended by Section 6202 of Pub. L. No. 110-252, hereafter referred as the “Transparency Act” that are codified in 2 CFR Part 170, recipients (i.e., direct recipients) of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). Cause: The agency could not reconcile information presented in the expenditure report to the general ledger. Finance and the agency use different parameters for generating reports and there was no documentation of the reconciling differences. BCHD does not have controls in place to ensure reporting requirements are met. Effect: Expenditures reported to the federal government could be inaccurate. BCHD may not be in compliance with the reporting requirements. Questioned Costs: Unknown Recommendation: We recommend the City establish and implement a process to reconcile reports used by the various departments for external reporting to the City’s internal records to validate compliance with reporting requirements. Additionally, there should be a process to ensure all reports are submitted timely. 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. DRAFT
Finding 2024-023 U.S. Department of Health and Human Services AL No. 93.778 Medical Assistance Program (Medicaid; Title XIX) Material Weakness in Internal Controls in Noncompliance over Reporting Repeat Finding: Yes; 2023-019 Condition: For 4 out of 4 selections, we were unable to agree the expenditure details from the general ledger to the amounts reported on the Medical Assistance Transportation report, the Maryland Children Health Program (MCHP) - Eligibility report, the Administrative Care Coordination report and Supplemental Administrative Care Coordination 440 report to ensure completeness, accuracy and compliance with required accounting basis. Additionally, we were unable to verify if the Federal Funding Accountability and Transparency Act (FFATA) report was prepared and submitted. Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Under the requirements of the Federal Funding Accountability and Transparency Act (Pub. L. No. 109-282), as amended by Section 6202 of Pub. L. No. 110-252, hereafter referred as the “Transparency Act” that are codified in 2 CFR Part 170, recipients (i.e., direct recipients) of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). Cause: The agency could not reconcile information presented in the expenditure report to the general ledger. Finance and the agency use different parameters for generating reports and there was no documentation of the reconciling differences. BCHD does not have controls in place to ensure reporting requirements are met. Effect: Expenditures reported to the federal government could be inaccurate. BCHD may not be in compliance with the reporting requirements. Questioned Costs: Unknown Recommendation: We recommend the City establish and implement a process to reconcile reports used by the various departments for external reporting to the City’s internal records to validate compliance with reporting requirements. Additionally, there should be a process to ensure all reports are submitted timely. 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. DRAFT
Finding 2024-023 U.S. Department of Health and Human Services AL No. 93.778 Medical Assistance Program (Medicaid; Title XIX) Material Weakness in Internal Controls in Noncompliance over Reporting Repeat Finding: Yes; 2023-019 Condition: For 4 out of 4 selections, we were unable to agree the expenditure details from the general ledger to the amounts reported on the Medical Assistance Transportation report, the Maryland Children Health Program (MCHP) - Eligibility report, the Administrative Care Coordination report and Supplemental Administrative Care Coordination 440 report to ensure completeness, accuracy and compliance with required accounting basis. Additionally, we were unable to verify if the Federal Funding Accountability and Transparency Act (FFATA) report was prepared and submitted. Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Under the requirements of the Federal Funding Accountability and Transparency Act (Pub. L. No. 109-282), as amended by Section 6202 of Pub. L. No. 110-252, hereafter referred as the “Transparency Act” that are codified in 2 CFR Part 170, recipients (i.e., direct recipients) of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). Cause: The agency could not reconcile information presented in the expenditure report to the general ledger. Finance and the agency use different parameters for generating reports and there was no documentation of the reconciling differences. BCHD does not have controls in place to ensure reporting requirements are met. Effect: Expenditures reported to the federal government could be inaccurate. BCHD may not be in compliance with the reporting requirements. Questioned Costs: Unknown Recommendation: We recommend the City establish and implement a process to reconcile reports used by the various departments for external reporting to the City’s internal records to validate compliance with reporting requirements. Additionally, there should be a process to ensure all reports are submitted timely. 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. DRAFT
Finding 2024-023 U.S. Department of Health and Human Services AL No. 93.778 Medical Assistance Program (Medicaid; Title XIX) Material Weakness in Internal Controls in Noncompliance over Reporting Repeat Finding: Yes; 2023-019 Condition: For 4 out of 4 selections, we were unable to agree the expenditure details from the general ledger to the amounts reported on the Medical Assistance Transportation report, the Maryland Children Health Program (MCHP) - Eligibility report, the Administrative Care Coordination report and Supplemental Administrative Care Coordination 440 report to ensure completeness, accuracy and compliance with required accounting basis. Additionally, we were unable to verify if the Federal Funding Accountability and Transparency Act (FFATA) report was prepared and submitted. Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Under the requirements of the Federal Funding Accountability and Transparency Act (Pub. L. No. 109-282), as amended by Section 6202 of Pub. L. No. 110-252, hereafter referred as the “Transparency Act” that are codified in 2 CFR Part 170, recipients (i.e., direct recipients) of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). Cause: The agency could not reconcile information presented in the expenditure report to the general ledger. Finance and the agency use different parameters for generating reports and there was no documentation of the reconciling differences. BCHD does not have controls in place to ensure reporting requirements are met. Effect: Expenditures reported to the federal government could be inaccurate. BCHD may not be in compliance with the reporting requirements. Questioned Costs: Unknown Recommendation: We recommend the City establish and implement a process to reconcile reports used by the various departments for external reporting to the City’s internal records to validate compliance with reporting requirements. Additionally, there should be a process to ensure all reports are submitted timely. 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. DRAFT
Finding 2024-023 U.S. Department of Health and Human Services AL No. 93.778 Medical Assistance Program (Medicaid; Title XIX) Material Weakness in Internal Controls in Noncompliance over Reporting Repeat Finding: Yes; 2023-019 Condition: For 4 out of 4 selections, we were unable to agree the expenditure details from the general ledger to the amounts reported on the Medical Assistance Transportation report, the Maryland Children Health Program (MCHP) - Eligibility report, the Administrative Care Coordination report and Supplemental Administrative Care Coordination 440 report to ensure completeness, accuracy and compliance with required accounting basis. Additionally, we were unable to verify if the Federal Funding Accountability and Transparency Act (FFATA) report was prepared and submitted. Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Under the requirements of the Federal Funding Accountability and Transparency Act (Pub. L. No. 109-282), as amended by Section 6202 of Pub. L. No. 110-252, hereafter referred as the “Transparency Act” that are codified in 2 CFR Part 170, recipients (i.e., direct recipients) of grants or cooperative agreements are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). Cause: The agency could not reconcile information presented in the expenditure report to the general ledger. Finance and the agency use different parameters for generating reports and there was no documentation of the reconciling differences. BCHD does not have controls in place to ensure reporting requirements are met. Effect: Expenditures reported to the federal government could be inaccurate. BCHD may not be in compliance with the reporting requirements. Questioned Costs: Unknown Recommendation: We recommend the City establish and implement a process to reconcile reports used by the various departments for external reporting to the City’s internal records to validate compliance with reporting requirements. Additionally, there should be a process to ensure all reports are submitted timely. 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. DRAFT
Finding 2024-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-024 U.S. Department of Health and Human Services AL No. 93.914 HIV Emergency Relief Project Grants Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-020 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the drawdown request form was approved by the Grant Service Director after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash management process are not operating effectively. Effect: Expenditures are not reviewed prior to submission of request in PMS. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-026 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-022 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the GL support provided included expenditures incurred after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director Conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash drawdown process are not operating effectively. The agency could not reconcile information presented in the expenditure report to the underlying records. Finance and the agency use different parameters for generating reports and there was no documentation of the reconciling differences. Effect: Expenditures are not reviewed prior to submission of request. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-027 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Material Weakness in Internal Controls and Noncompliance over Reporting Repeat Finding: Yes; 2023-023 Condition: For 1 out of 1 selection, we were unable to agree the expenditure details from the general ledger to the amount reported in the Federal Financial Report to ensure completeness, accuracy and compliance with required accounting basis. Additionally, we could not verify if the Final Performance Progress and Evaluation Report (PPER) was submitted. Criteria: In accordance with 2 CFR §200.303, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Additionally, the grant agreement requires the Federal Financial Report to be submitted through recipient online accounts in the Payment Management System and the Final Performance Progress and Evaluation Report (PPER) to be submitted via www.grantsolutions.gov. no later than 120 days after the period of performance end date. Cause: The agency could not reconcile information reported in the expenditure report to the state to the underlying records. Finance and the agency use different parameters for running reports and neither department reconciled the other reporting completed. BCHD does not have controls in place to ensure reporting requirements of the grant are met. Effect: Expenditures reported to the federal government could be inaccurate. BCHD may not be in compliance with the reporting requirements. Questioned Costs: Unknown. Recommendation: We recommend the City establish and implement a process to reconcile reports used by the various departments for external reporting to the City’s internal records to validate compliance with reporting requirements. Additionally, there should be a process to ensure all reports are submitted timely. 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-026 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-022 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the GL support provided included expenditures incurred after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director Conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash drawdown process are not operating effectively. The agency could not reconcile information presented in the expenditure report to the underlying records. Finance and the agency use different parameters for generating reports and there was no documentation of the reconciling differences. Effect: Expenditures are not reviewed prior to submission of request. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-027 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Material Weakness in Internal Controls and Noncompliance over Reporting Repeat Finding: Yes; 2023-023 Condition: For 1 out of 1 selection, we were unable to agree the expenditure details from the general ledger to the amount reported in the Federal Financial Report to ensure completeness, accuracy and compliance with required accounting basis. Additionally, we could not verify if the Final Performance Progress and Evaluation Report (PPER) was submitted. Criteria: In accordance with 2 CFR §200.303, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Additionally, the grant agreement requires the Federal Financial Report to be submitted through recipient online accounts in the Payment Management System and the Final Performance Progress and Evaluation Report (PPER) to be submitted via www.grantsolutions.gov. no later than 120 days after the period of performance end date. Cause: The agency could not reconcile information reported in the expenditure report to the state to the underlying records. Finance and the agency use different parameters for running reports and neither department reconciled the other reporting completed. BCHD does not have controls in place to ensure reporting requirements of the grant are met. Effect: Expenditures reported to the federal government could be inaccurate. BCHD may not be in compliance with the reporting requirements. Questioned Costs: Unknown. Recommendation: We recommend the City establish and implement a process to reconcile reports used by the various departments for external reporting to the City’s internal records to validate compliance with reporting requirements. Additionally, there should be a process to ensure all reports are submitted timely. 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-026 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-022 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the GL support provided included expenditures incurred after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director Conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash drawdown process are not operating effectively. The agency could not reconcile information presented in the expenditure report to the underlying records. Finance and the agency use different parameters for generating reports and there was no documentation of the reconciling differences. Effect: Expenditures are not reviewed prior to submission of request. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-027 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Material Weakness in Internal Controls and Noncompliance over Reporting Repeat Finding: Yes; 2023-023 Condition: For 1 out of 1 selection, we were unable to agree the expenditure details from the general ledger to the amount reported in the Federal Financial Report to ensure completeness, accuracy and compliance with required accounting basis. Additionally, we could not verify if the Final Performance Progress and Evaluation Report (PPER) was submitted. Criteria: In accordance with 2 CFR §200.303, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Additionally, the grant agreement requires the Federal Financial Report to be submitted through recipient online accounts in the Payment Management System and the Final Performance Progress and Evaluation Report (PPER) to be submitted via www.grantsolutions.gov. no later than 120 days after the period of performance end date. Cause: The agency could not reconcile information reported in the expenditure report to the state to the underlying records. Finance and the agency use different parameters for running reports and neither department reconciled the other reporting completed. BCHD does not have controls in place to ensure reporting requirements of the grant are met. Effect: Expenditures reported to the federal government could be inaccurate. BCHD may not be in compliance with the reporting requirements. Questioned Costs: Unknown. Recommendation: We recommend the City establish and implement a process to reconcile reports used by the various departments for external reporting to the City’s internal records to validate compliance with reporting requirements. Additionally, there should be a process to ensure all reports are submitted timely. 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-026 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-022 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the GL support provided included expenditures incurred after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director Conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash drawdown process are not operating effectively. The agency could not reconcile information presented in the expenditure report to the underlying records. Finance and the agency use different parameters for generating reports and there was no documentation of the reconciling differences. Effect: Expenditures are not reviewed prior to submission of request. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-027 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Material Weakness in Internal Controls and Noncompliance over Reporting Repeat Finding: Yes; 2023-023 Condition: For 1 out of 1 selection, we were unable to agree the expenditure details from the general ledger to the amount reported in the Federal Financial Report to ensure completeness, accuracy and compliance with required accounting basis. Additionally, we could not verify if the Final Performance Progress and Evaluation Report (PPER) was submitted. Criteria: In accordance with 2 CFR §200.303, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Additionally, the grant agreement requires the Federal Financial Report to be submitted through recipient online accounts in the Payment Management System and the Final Performance Progress and Evaluation Report (PPER) to be submitted via www.grantsolutions.gov. no later than 120 days after the period of performance end date. Cause: The agency could not reconcile information reported in the expenditure report to the state to the underlying records. Finance and the agency use different parameters for running reports and neither department reconciled the other reporting completed. BCHD does not have controls in place to ensure reporting requirements of the grant are met. Effect: Expenditures reported to the federal government could be inaccurate. BCHD may not be in compliance with the reporting requirements. Questioned Costs: Unknown. Recommendation: We recommend the City establish and implement a process to reconcile reports used by the various departments for external reporting to the City’s internal records to validate compliance with reporting requirements. Additionally, there should be a process to ensure all reports are submitted timely. 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-026 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-022 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the GL support provided included expenditures incurred after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director Conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash drawdown process are not operating effectively. The agency could not reconcile information presented in the expenditure report to the underlying records. Finance and the agency use different parameters for generating reports and there was no documentation of the reconciling differences. Effect: Expenditures are not reviewed prior to submission of request. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-027 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Material Weakness in Internal Controls and Noncompliance over Reporting Repeat Finding: Yes; 2023-023 Condition: For 1 out of 1 selection, we were unable to agree the expenditure details from the general ledger to the amount reported in the Federal Financial Report to ensure completeness, accuracy and compliance with required accounting basis. Additionally, we could not verify if the Final Performance Progress and Evaluation Report (PPER) was submitted. Criteria: In accordance with 2 CFR §200.303, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Additionally, the grant agreement requires the Federal Financial Report to be submitted through recipient online accounts in the Payment Management System and the Final Performance Progress and Evaluation Report (PPER) to be submitted via www.grantsolutions.gov. no later than 120 days after the period of performance end date. Cause: The agency could not reconcile information reported in the expenditure report to the state to the underlying records. Finance and the agency use different parameters for running reports and neither department reconciled the other reporting completed. BCHD does not have controls in place to ensure reporting requirements of the grant are met. Effect: Expenditures reported to the federal government could be inaccurate. BCHD may not be in compliance with the reporting requirements. Questioned Costs: Unknown. Recommendation: We recommend the City establish and implement a process to reconcile reports used by the various departments for external reporting to the City’s internal records to validate compliance with reporting requirements. Additionally, there should be a process to ensure all reports are submitted timely. 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-026 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-022 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the GL support provided included expenditures incurred after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director Conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash drawdown process are not operating effectively. The agency could not reconcile information presented in the expenditure report to the underlying records. Finance and the agency use different parameters for generating reports and there was no documentation of the reconciling differences. Effect: Expenditures are not reviewed prior to submission of request. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-027 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Material Weakness in Internal Controls and Noncompliance over Reporting Repeat Finding: Yes; 2023-023 Condition: For 1 out of 1 selection, we were unable to agree the expenditure details from the general ledger to the amount reported in the Federal Financial Report to ensure completeness, accuracy and compliance with required accounting basis. Additionally, we could not verify if the Final Performance Progress and Evaluation Report (PPER) was submitted. Criteria: In accordance with 2 CFR §200.303, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Additionally, the grant agreement requires the Federal Financial Report to be submitted through recipient online accounts in the Payment Management System and the Final Performance Progress and Evaluation Report (PPER) to be submitted via www.grantsolutions.gov. no later than 120 days after the period of performance end date. Cause: The agency could not reconcile information reported in the expenditure report to the state to the underlying records. Finance and the agency use different parameters for running reports and neither department reconciled the other reporting completed. BCHD does not have controls in place to ensure reporting requirements of the grant are met. Effect: Expenditures reported to the federal government could be inaccurate. BCHD may not be in compliance with the reporting requirements. Questioned Costs: Unknown. Recommendation: We recommend the City establish and implement a process to reconcile reports used by the various departments for external reporting to the City’s internal records to validate compliance with reporting requirements. Additionally, there should be a process to ensure all reports are submitted timely. 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-026 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-022 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the GL support provided included expenditures incurred after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director Conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash drawdown process are not operating effectively. The agency could not reconcile information presented in the expenditure report to the underlying records. Finance and the agency use different parameters for generating reports and there was no documentation of the reconciling differences. Effect: Expenditures are not reviewed prior to submission of request. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-027 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Material Weakness in Internal Controls and Noncompliance over Reporting Repeat Finding: Yes; 2023-023 Condition: For 1 out of 1 selection, we were unable to agree the expenditure details from the general ledger to the amount reported in the Federal Financial Report to ensure completeness, accuracy and compliance with required accounting basis. Additionally, we could not verify if the Final Performance Progress and Evaluation Report (PPER) was submitted. Criteria: In accordance with 2 CFR §200.303, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Additionally, the grant agreement requires the Federal Financial Report to be submitted through recipient online accounts in the Payment Management System and the Final Performance Progress and Evaluation Report (PPER) to be submitted via www.grantsolutions.gov. no later than 120 days after the period of performance end date. Cause: The agency could not reconcile information reported in the expenditure report to the state to the underlying records. Finance and the agency use different parameters for running reports and neither department reconciled the other reporting completed. BCHD does not have controls in place to ensure reporting requirements of the grant are met. Effect: Expenditures reported to the federal government could be inaccurate. BCHD may not be in compliance with the reporting requirements. Questioned Costs: Unknown. Recommendation: We recommend the City establish and implement a process to reconcile reports used by the various departments for external reporting to the City’s internal records to validate compliance with reporting requirements. Additionally, there should be a process to ensure all reports are submitted timely. 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-026 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-022 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the GL support provided included expenditures incurred after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director Conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash drawdown process are not operating effectively. The agency could not reconcile information presented in the expenditure report to the underlying records. Finance and the agency use different parameters for generating reports and there was no documentation of the reconciling differences. Effect: Expenditures are not reviewed prior to submission of request. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-027 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Material Weakness in Internal Controls and Noncompliance over Reporting Repeat Finding: Yes; 2023-023 Condition: For 1 out of 1 selection, we were unable to agree the expenditure details from the general ledger to the amount reported in the Federal Financial Report to ensure completeness, accuracy and compliance with required accounting basis. Additionally, we could not verify if the Final Performance Progress and Evaluation Report (PPER) was submitted. Criteria: In accordance with 2 CFR §200.303, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Additionally, the grant agreement requires the Federal Financial Report to be submitted through recipient online accounts in the Payment Management System and the Final Performance Progress and Evaluation Report (PPER) to be submitted via www.grantsolutions.gov. no later than 120 days after the period of performance end date. Cause: The agency could not reconcile information reported in the expenditure report to the state to the underlying records. Finance and the agency use different parameters for running reports and neither department reconciled the other reporting completed. BCHD does not have controls in place to ensure reporting requirements of the grant are met. Effect: Expenditures reported to the federal government could be inaccurate. BCHD may not be in compliance with the reporting requirements. Questioned Costs: Unknown. Recommendation: We recommend the City establish and implement a process to reconcile reports used by the various departments for external reporting to the City’s internal records to validate compliance with reporting requirements. Additionally, there should be a process to ensure all reports are submitted timely. 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-026 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Material Weakness in Internal Controls and Noncompliance over Cash Management Repeat Finding: Yes; 2023-022 Condition: For 1 out of 2 selections, the drawdown request forms did not have the approval of the Grant Service Director. For 1 out of 2 selections, the GL support provided included expenditures incurred after the request was submitted on Payment Management System (PMS). Criteria: In accordance with 2 CFR 200.303: Internal Control, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. According to AM 413-60, Grant Documentation, Grant Manager/Program Manager/Director Conducts ongoing monitoring and control of all reimbursement receipts and deposits until grant ends; as well as all program and sub-recipient (when applicable) documentation, to include: (1) program documentation; (2) timesheets; (3) deliverables; (4) activities; (5) vendor payments; (6) program data/charts/numbers; and (7) financial and compliance report. According to AM 413-61, Grant Management Financial Reporting, Grant Manager/Program Manager/Director maintains all documentation, either electronic or hard copy, for all Federally funded grants for the term of the grant for a minimum of seven years for review and audit by the granting agency or its designee. Cause: Controls surrounding the cash drawdown process are not operating effectively. The agency could not reconcile information presented in the expenditure report to the underlying records. Finance and the agency use different parameters for generating reports and there was no documentation of the reconciling differences. Effect: Expenditures are not reviewed prior to submission of request. Expenditures reported to the federal government could be inaccurate. Questioned Costs: Unknown. Recommendation: We recommend that the City review policies, procedures and practices in place over controls related to reviewing and approving drawdowns prior to submission in PMS. 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-027 U.S. Department of Health and Human Services AL No. 93.940 HIV Prevention Activities Health Department Based Material Weakness in Internal Controls and Noncompliance over Reporting Repeat Finding: Yes; 2023-023 Condition: For 1 out of 1 selection, we were unable to agree the expenditure details from the general ledger to the amount reported in the Federal Financial Report to ensure completeness, accuracy and compliance with required accounting basis. Additionally, we could not verify if the Final Performance Progress and Evaluation Report (PPER) was submitted. Criteria: In accordance with 2 CFR §200.303, 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.302: Financial management. (a) Each State must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state’s own funds. In addition, the state’s and the other non-Federal entity’s financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Additionally, the grant agreement requires the Federal Financial Report to be submitted through recipient online accounts in the Payment Management System and the Final Performance Progress and Evaluation Report (PPER) to be submitted via www.grantsolutions.gov. no later than 120 days after the period of performance end date. Cause: The agency could not reconcile information reported in the expenditure report to the state to the underlying records. Finance and the agency use different parameters for running reports and neither department reconciled the other reporting completed. BCHD does not have controls in place to ensure reporting requirements of the grant are met. Effect: Expenditures reported to the federal government could be inaccurate. BCHD may not be in compliance with the reporting requirements. Questioned Costs: Unknown. Recommendation: We recommend the City establish and implement a process to reconcile reports used by the various departments for external reporting to the City’s internal records to validate compliance with reporting requirements. Additionally, there should be a process to ensure all reports are submitted timely. 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.
Criteria: The auditee must prepare the Schedule of Expenditures of Federal Awards (SEFA) for the period under audit in accordance with the Uniform Guidance Sections 2 CFR 200.302(b) and 2 CFR 200.510(b). Condition: During our audit of the SEFA submitted by the Clinic, we noted that the Clinic inadvertently included nonfederal grants in the SEFA. Further, the Clinic inaccurately included out-of-performance period expenses in its SEFA due to inaccurate identification of the grant period during the SEFA preparation. The Clinic corrected the SEFA after the errors were brought to their attention. Cause: Wilmington was short-staffed and dealt with time constraints in the preparation and review of the SEFA. Effect: Inaccurate SEFA can lead to improper risk assessment and incorrect identification of major federal programs subject to audit. Revisions of the SEFA were necessary to ensure the completeness and accuracy of the federal expenditures reported. Questioned Costs: None. Recommendation: We recommend that the Clinic revisit its internal control processes over the preparation and review of the SEFA in conjunction with its other federal reporting requirements to ensure that the SEFA and all federal reports for internal and external purposes are accurate and complete. Views of responsible officials and planned corrective actions: The Clinic will be seeking professional consultation and guidance on a process to support and enforce monthly reconciliations of the amounts submitted for the grant with the amounts booked within the system, using appropriate grant-tracking schedules. Relevant staff will be retrained, and a monthly review will be completed by an appropriate professional and submitted to the Chief Executive Officer (CEO). Personnel responsible for implementation: Deborah Lerner, CEO and Board of Directors Date of implementation: July 1, 2025
Criteria: The auditee must prepare the Schedule of Expenditures of Federal Awards (SEFA) for the period under audit in accordance with the Uniform Guidance Sections 2 CFR 200.302(b) and 2 CFR 200.510(b). Condition: During our audit of the SEFA submitted by the Clinic, we noted that the Clinic inadvertently included nonfederal grants in the SEFA. Further, the Clinic inaccurately included out-of-performance period expenses in its SEFA due to inaccurate identification of the grant period during the SEFA preparation. The Clinic corrected the SEFA after the errors were brought to their attention. Cause: Wilmington was short-staffed and dealt with time constraints in the preparation and review of the SEFA. Effect: Inaccurate SEFA can lead to improper risk assessment and incorrect identification of major federal programs subject to audit. Revisions of the SEFA were necessary to ensure the completeness and accuracy of the federal expenditures reported. Questioned Costs: None. Recommendation: We recommend that the Clinic revisit its internal control processes over the preparation and review of the SEFA in conjunction with its other federal reporting requirements to ensure that the SEFA and all federal reports for internal and external purposes are accurate and complete. Views of responsible officials and planned corrective actions: The Clinic will be seeking professional consultation and guidance on a process to support and enforce monthly reconciliations of the amounts submitted for the grant with the amounts booked within the system, using appropriate grant-tracking schedules. Relevant staff will be retrained, and a monthly review will be completed by an appropriate professional and submitted to the Chief Executive Officer (CEO). Personnel responsible for implementation: Deborah Lerner, CEO and Board of Directors Date of implementation: July 1, 2025
Criteria: The auditee must prepare the Schedule of Expenditures of Federal Awards (SEFA) for the period under audit in accordance with the Uniform Guidance Sections 2 CFR 200.302(b) and 2 CFR 200.510(b). Condition: During our audit of the SEFA submitted by the Clinic, we noted that the Clinic inadvertently included nonfederal grants in the SEFA. Further, the Clinic inaccurately included out-of-performance period expenses in its SEFA due to inaccurate identification of the grant period during the SEFA preparation. The Clinic corrected the SEFA after the errors were brought to their attention. Cause: Wilmington was short-staffed and dealt with time constraints in the preparation and review of the SEFA. Effect: Inaccurate SEFA can lead to improper risk assessment and incorrect identification of major federal programs subject to audit. Revisions of the SEFA were necessary to ensure the completeness and accuracy of the federal expenditures reported. Questioned Costs: None. Recommendation: We recommend that the Clinic revisit its internal control processes over the preparation and review of the SEFA in conjunction with its other federal reporting requirements to ensure that the SEFA and all federal reports for internal and external purposes are accurate and complete. Views of responsible officials and planned corrective actions: The Clinic will be seeking professional consultation and guidance on a process to support and enforce monthly reconciliations of the amounts submitted for the grant with the amounts booked within the system, using appropriate grant-tracking schedules. Relevant staff will be retrained, and a monthly review will be completed by an appropriate professional and submitted to the Chief Executive Officer (CEO). Personnel responsible for implementation: Deborah Lerner, CEO and Board of Directors Date of implementation: July 1, 2025
Criteria: The auditee must prepare the Schedule of Expenditures of Federal Awards (SEFA) for the period under audit in accordance with the Uniform Guidance Sections 2 CFR 200.302(b) and 2 CFR 200.510(b). Condition: During our audit of the SEFA submitted by the Clinic, we noted that the Clinic inadvertently included nonfederal grants in the SEFA. Further, the Clinic inaccurately included out-of-performance period expenses in its SEFA due to inaccurate identification of the grant period during the SEFA preparation. The Clinic corrected the SEFA after the errors were brought to their attention. Cause: Wilmington was short-staffed and dealt with time constraints in the preparation and review of the SEFA. Effect: Inaccurate SEFA can lead to improper risk assessment and incorrect identification of major federal programs subject to audit. Revisions of the SEFA were necessary to ensure the completeness and accuracy of the federal expenditures reported. Questioned Costs: None. Recommendation: We recommend that the Clinic revisit its internal control processes over the preparation and review of the SEFA in conjunction with its other federal reporting requirements to ensure that the SEFA and all federal reports for internal and external purposes are accurate and complete. Views of responsible officials and planned corrective actions: The Clinic will be seeking professional consultation and guidance on a process to support and enforce monthly reconciliations of the amounts submitted for the grant with the amounts booked within the system, using appropriate grant-tracking schedules. Relevant staff will be retrained, and a monthly review will be completed by an appropriate professional and submitted to the Chief Executive Officer (CEO). Personnel responsible for implementation: Deborah Lerner, CEO and Board of Directors Date of implementation: July 1, 2025
Criteria: The auditee must prepare the Schedule of Expenditures of Federal Awards (SEFA) for the period under audit in accordance with the Uniform Guidance Sections 2 CFR 200.302(b) and 2 CFR 200.510(b). Condition: During our audit of the SEFA submitted by the Clinic, we noted that the Clinic inadvertently included nonfederal grants in the SEFA. Further, the Clinic inaccurately included out-of-performance period expenses in its SEFA due to inaccurate identification of the grant period during the SEFA preparation. The Clinic corrected the SEFA after the errors were brought to their attention. Cause: Wilmington was short-staffed and dealt with time constraints in the preparation and review of the SEFA. Effect: Inaccurate SEFA can lead to improper risk assessment and incorrect identification of major federal programs subject to audit. Revisions of the SEFA were necessary to ensure the completeness and accuracy of the federal expenditures reported. Questioned Costs: None. Recommendation: We recommend that the Clinic revisit its internal control processes over the preparation and review of the SEFA in conjunction with its other federal reporting requirements to ensure that the SEFA and all federal reports for internal and external purposes are accurate and complete. Views of responsible officials and planned corrective actions: The Clinic will be seeking professional consultation and guidance on a process to support and enforce monthly reconciliations of the amounts submitted for the grant with the amounts booked within the system, using appropriate grant-tracking schedules. Relevant staff will be retrained, and a monthly review will be completed by an appropriate professional and submitted to the Chief Executive Officer (CEO). Personnel responsible for implementation: Deborah Lerner, CEO and Board of Directors Date of implementation: July 1, 2025