2023-001 Implement System-Based Tracking of Federal Expenditures Assistance Listing Number: 93.566 Assistance Listing Program Title: Refugee and Entrant Assistance – State - Administered Programs Federal Agency: Department of Health and Human Services (HHS) Passed Through Entities: 1. California Department of Social Services 2. University of California, San Diego 3. California Rural Legal Assistance Foundation 4. San Diego Refugee Communities Coalition/United Women of East Africa Support Team Federal Award Numbers: ALSP22-0002-A1, PUR00533092, ALSP22-0001, and ACS22-05-CAIR-A1 Federal Award Year: 8/1/2022 to 3/31/2025 Compliance Requirement: Activities Allowed or Unallowed Criteria: Management is responsible for designing, implementing, and maintaining an internal control system that ensures accurate financial reporting. Effective internal control over financial reporting provides reasonable assurance regarding the completeness and accuracy of accounting records, and compliance with grantor requirements. 2 CFR 200.510 Financial Statements require auditees to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee's financial statements. This schedule must include the total Federal awards expended, as determined in accordance with 2 CFR 200.502. The information presented should be consistent with the accounting records (i.e., general ledger). In addition, Section 2 CFR 200.302(b)(1) provides that non-Federal entities must maintain effective control over and accountability for all funds, and must identify, in their accounts, all Federal awards received and expended. Condition: During our review of the SEFA, we noted that CAIR-CA currently utilizes workbooks outside of its accounting software to track federal expenditures. The external workbooks do not reconcile directly with the general ledger (GL) requiring management to prepare a separate reconciliation to support the SEFA amounts. Cause: This year marks CAIR-CA’s first Single Audit. As such, processes and internal controls over federal award tracking are still under development. The current system is not yet fully integrated to allow for automated or system-based tracking of federal expenditures by grant. Effect: Relying on manual workbooks to track federal expenditures can be inefficient and may result in inaccurate or incomplete reporting of federal expenditures. Questioned Cost: None Recommendation: We recommend that CAIR-CA enhance its accounting processes to enable the tracking of federal expenditures directly within its accounting software. This can be accomplished by implementing GL tracking codes or tags specifically designated for federal expenditures. Transitioning to a system based tracking approach will support consistency between the general ledger and the SEFA, simplify the process of generating financial reports, and improve the tracking of federal expenditures. Views of Responsible Officials and Corrective Action Plan: Management concurs with the finding and is currently in the process of updating the accounting system to incorporate grant-specific specific tracking codes to further align with federal reporting standards. As part of a layered approach to internal controls, Excel worksheets will continue to be used as a supplementary monitoring tool, providing an additional cross-check to the system-generated reports. Responsible person: Jackie Ramirez, Operations & Finance Associate Director Expected Implementation date: November 20, 2025
2023-001 Implement System-Based Tracking of Federal Expenditures Assistance Listing Number: 93.566 Assistance Listing Program Title: Refugee and Entrant Assistance – State - Administered Programs Federal Agency: Department of Health and Human Services (HHS) Passed Through Entities: 1. California Department of Social Services 2. University of California, San Diego 3. California Rural Legal Assistance Foundation 4. San Diego Refugee Communities Coalition/United Women of East Africa Support Team Federal Award Numbers: ALSP22-0002-A1, PUR00533092, ALSP22-0001, and ACS22-05-CAIR-A1 Federal Award Year: 8/1/2022 to 3/31/2025 Compliance Requirement: Activities Allowed or Unallowed Criteria: Management is responsible for designing, implementing, and maintaining an internal control system that ensures accurate financial reporting. Effective internal control over financial reporting provides reasonable assurance regarding the completeness and accuracy of accounting records, and compliance with grantor requirements. 2 CFR 200.510 Financial Statements require auditees to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee's financial statements. This schedule must include the total Federal awards expended, as determined in accordance with 2 CFR 200.502. The information presented should be consistent with the accounting records (i.e., general ledger). In addition, Section 2 CFR 200.302(b)(1) provides that non-Federal entities must maintain effective control over and accountability for all funds, and must identify, in their accounts, all Federal awards received and expended. Condition: During our review of the SEFA, we noted that CAIR-CA currently utilizes workbooks outside of its accounting software to track federal expenditures. The external workbooks do not reconcile directly with the general ledger (GL) requiring management to prepare a separate reconciliation to support the SEFA amounts. Cause: This year marks CAIR-CA’s first Single Audit. As such, processes and internal controls over federal award tracking are still under development. The current system is not yet fully integrated to allow for automated or system-based tracking of federal expenditures by grant. Effect: Relying on manual workbooks to track federal expenditures can be inefficient and may result in inaccurate or incomplete reporting of federal expenditures. Questioned Cost: None Recommendation: We recommend that CAIR-CA enhance its accounting processes to enable the tracking of federal expenditures directly within its accounting software. This can be accomplished by implementing GL tracking codes or tags specifically designated for federal expenditures. Transitioning to a system based tracking approach will support consistency between the general ledger and the SEFA, simplify the process of generating financial reports, and improve the tracking of federal expenditures. Views of Responsible Officials and Corrective Action Plan: Management concurs with the finding and is currently in the process of updating the accounting system to incorporate grant-specific specific tracking codes to further align with federal reporting standards. As part of a layered approach to internal controls, Excel worksheets will continue to be used as a supplementary monitoring tool, providing an additional cross-check to the system-generated reports. Responsible person: Jackie Ramirez, Operations & Finance Associate Director Expected Implementation date: November 20, 2025
2023-001 Implement System-Based Tracking of Federal Expenditures Assistance Listing Number: 93.566 Assistance Listing Program Title: Refugee and Entrant Assistance – State - Administered Programs Federal Agency: Department of Health and Human Services (HHS) Passed Through Entities: 1. California Department of Social Services 2. University of California, San Diego 3. California Rural Legal Assistance Foundation 4. San Diego Refugee Communities Coalition/United Women of East Africa Support Team Federal Award Numbers: ALSP22-0002-A1, PUR00533092, ALSP22-0001, and ACS22-05-CAIR-A1 Federal Award Year: 8/1/2022 to 3/31/2025 Compliance Requirement: Activities Allowed or Unallowed Criteria: Management is responsible for designing, implementing, and maintaining an internal control system that ensures accurate financial reporting. Effective internal control over financial reporting provides reasonable assurance regarding the completeness and accuracy of accounting records, and compliance with grantor requirements. 2 CFR 200.510 Financial Statements require auditees to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee's financial statements. This schedule must include the total Federal awards expended, as determined in accordance with 2 CFR 200.502. The information presented should be consistent with the accounting records (i.e., general ledger). In addition, Section 2 CFR 200.302(b)(1) provides that non-Federal entities must maintain effective control over and accountability for all funds, and must identify, in their accounts, all Federal awards received and expended. Condition: During our review of the SEFA, we noted that CAIR-CA currently utilizes workbooks outside of its accounting software to track federal expenditures. The external workbooks do not reconcile directly with the general ledger (GL) requiring management to prepare a separate reconciliation to support the SEFA amounts. Cause: This year marks CAIR-CA’s first Single Audit. As such, processes and internal controls over federal award tracking are still under development. The current system is not yet fully integrated to allow for automated or system-based tracking of federal expenditures by grant. Effect: Relying on manual workbooks to track federal expenditures can be inefficient and may result in inaccurate or incomplete reporting of federal expenditures. Questioned Cost: None Recommendation: We recommend that CAIR-CA enhance its accounting processes to enable the tracking of federal expenditures directly within its accounting software. This can be accomplished by implementing GL tracking codes or tags specifically designated for federal expenditures. Transitioning to a system based tracking approach will support consistency between the general ledger and the SEFA, simplify the process of generating financial reports, and improve the tracking of federal expenditures. Views of Responsible Officials and Corrective Action Plan: Management concurs with the finding and is currently in the process of updating the accounting system to incorporate grant-specific specific tracking codes to further align with federal reporting standards. As part of a layered approach to internal controls, Excel worksheets will continue to be used as a supplementary monitoring tool, providing an additional cross-check to the system-generated reports. Responsible person: Jackie Ramirez, Operations & Finance Associate Director Expected Implementation date: November 20, 2025
2023-001 Implement System-Based Tracking of Federal Expenditures Assistance Listing Number: 93.566 Assistance Listing Program Title: Refugee and Entrant Assistance – State - Administered Programs Federal Agency: Department of Health and Human Services (HHS) Passed Through Entities: 1. California Department of Social Services 2. University of California, San Diego 3. California Rural Legal Assistance Foundation 4. San Diego Refugee Communities Coalition/United Women of East Africa Support Team Federal Award Numbers: ALSP22-0002-A1, PUR00533092, ALSP22-0001, and ACS22-05-CAIR-A1 Federal Award Year: 8/1/2022 to 3/31/2025 Compliance Requirement: Activities Allowed or Unallowed Criteria: Management is responsible for designing, implementing, and maintaining an internal control system that ensures accurate financial reporting. Effective internal control over financial reporting provides reasonable assurance regarding the completeness and accuracy of accounting records, and compliance with grantor requirements. 2 CFR 200.510 Financial Statements require auditees to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee's financial statements. This schedule must include the total Federal awards expended, as determined in accordance with 2 CFR 200.502. The information presented should be consistent with the accounting records (i.e., general ledger). In addition, Section 2 CFR 200.302(b)(1) provides that non-Federal entities must maintain effective control over and accountability for all funds, and must identify, in their accounts, all Federal awards received and expended. Condition: During our review of the SEFA, we noted that CAIR-CA currently utilizes workbooks outside of its accounting software to track federal expenditures. The external workbooks do not reconcile directly with the general ledger (GL) requiring management to prepare a separate reconciliation to support the SEFA amounts. Cause: This year marks CAIR-CA’s first Single Audit. As such, processes and internal controls over federal award tracking are still under development. The current system is not yet fully integrated to allow for automated or system-based tracking of federal expenditures by grant. Effect: Relying on manual workbooks to track federal expenditures can be inefficient and may result in inaccurate or incomplete reporting of federal expenditures. Questioned Cost: None Recommendation: We recommend that CAIR-CA enhance its accounting processes to enable the tracking of federal expenditures directly within its accounting software. This can be accomplished by implementing GL tracking codes or tags specifically designated for federal expenditures. Transitioning to a system based tracking approach will support consistency between the general ledger and the SEFA, simplify the process of generating financial reports, and improve the tracking of federal expenditures. Views of Responsible Officials and Corrective Action Plan: Management concurs with the finding and is currently in the process of updating the accounting system to incorporate grant-specific specific tracking codes to further align with federal reporting standards. As part of a layered approach to internal controls, Excel worksheets will continue to be used as a supplementary monitoring tool, providing an additional cross-check to the system-generated reports. Responsible person: Jackie Ramirez, Operations & Finance Associate Director Expected Implementation date: November 20, 2025
2023-001 Internal Controls Over Compliance and Compliance with Reporting - Preparation of the Schedule of Expenditures of Federal Awards Information on the Major Federal Program - Federal Agency: Department of Health and Human Services Assistance Listing Number: 93.855 Assistance Listing Name: Research and Development Cluster Award Number: 1G20AI174721-01 Award Period: 09/16/2022 – 02/29/2024 Criteria: The Uniform Guidance in 2 CFR Section 200.510 (b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR Section 200.502 Basis for determining Federal awards expended.” The Schedule must provide total Federal awards expended for each individual Federal program. Condition: Expenditures for a grant under the Department of Health and Human Services program of approximately $1.3 million were incurred in 2023, but improperly not included in the Schedule. These expenditures were incurred but not billed to the federal awarding agency at December 31, 2023. Cause: The internal controls established for the review and reconciliation of the Schedule to the underlying accounting records were not consistently followed to ensure accurate reporting of expenditures to the Schedule. Questioned Costs: None. Context: We reviewed the Schedule and found the exception as noted in the condition. Effect: Failure to properly review and support expenditures reported in the Schedule can result in inaccurate reporting and non-compliance with laws and regulations. Repeat Finding: This is not a repeat finding. Recommendation: Internal controls should be designed to prevent, detect and correct errors and/or omissions in a timely manner. Without adequate controls, the Organization cannot provide reasonable assurance that the Schedule is fairly presented. See management’s response for further details.
Identification of the federal programs 12.800 - Air Force Defense Research Sciences Program - FA8650-20-2-5506. Criteria or Specific Requirement Per 2 CFR Part 200 Subpart F section 200.502, amounts provided to subrecipients should be reported as expended when the disbursement is made to the subrecipient. Condition The Organization recorded disbursements made to subrecipients in the incorrect fiscal year period on the Schedule of Expenditures of Federal Awards. Cause The Organization recorded the expenses in accordance with GAAP rather than with the CFR compliance on the Schedule of Expenditures of Federal Awards. As such the Organization incorrectly incurred expenses in the wrong fiscal year period for the purposes of the single audit. Effect or potential effect Subrecipient expenditures are recorded in the incorrect year. Questioned Costs None noted. Context The condition noted above was identified during the audit procedures related to Subrecipient Monitoring. Identification as a Repeat Finding None Recommendation The Organization should have a formal process put in place to ensure subrecipient expenditures are being recorded in the proper period. Views of Responsible Officials Management concurs with the finding. The Organization revised its review procedures and controls so that subrecipient expenditures are recorded in the proper accounting fiscal year according to 2 CFR Part 200 Subpart F section 200.502, whereby amounts will be reported as expended when the disbursement is made to the subrecipient for single audit purposes. These steps should correct the deficiency.
Finding 2023-001: Internal Controls over Compliance and Other Matters Identification of Federal Funds for Purposes of Assembling the Schedule of Expenditures of Federal Awards – Other U.S. DEPARTMENT OF TRANSPORTATION Highway Planning and Construction (Federal-Aid Highway Program) – ALN 20.205 U.S. DEPARTMENT OF TREASURY COVID-19 - Coronavirus State and Local Fiscal Recovery Funds – ALN 21.027 Criteria: Per 2 CFR 200.510(b) Schedule of expenditures of Federal awards, “the auditee must prepare a schedule of expenditures of federal awards for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for determining Federal awards expended. Condition: Prior to correction, certain federal expenditures were not properly identified on the schedule of expenditures of federal awards (SEFA). During our audit, it was determined total federal expenditures for the Highway Planning and Construction program were overstated by approximately $481,000 and federal expenditures for the Coronavirus State and Local Fiscal Recovery Funds program were understated by approximately $340,000 on the SEFA. Cause: Internal controls were not in place to ensure program related revenues (which are used to prepare the federal expenditures for the SEFA) were properly recorded for the Highway Planning and Construction program and that calculations for the Coronavirus State and Local Fiscal Recovery Funds program were reviewed for accuracy. Effect: By not having proper controls over SEFA preparation, there is a risk that the SEFA will not accurately reflect the total amount of federal dollars expended during a particular year. Context: The SEFA was originally overstated by $481,000 for the Highway Planning and Construction program due to reporting $377,000 of expenditures as federal instead of local, reporting $120,000 of remaining encumbrances as 2023 expenditures, and excluding $16,000 of expenditures incurred as a result of recording retainage on a project. The Coronavirus State and Local Fiscal Recovery Funds program expenditures were originally understated on the SEFA by $340,000 due to a formula error relating to the calculation of total federal expenditures for the program. Questioned Costs: $0 Identification of Repeat Finding: Not a repeat finding. Recommendation: We recommend staff review procedures related to revenue recognition of its highway construction programs to ensure amounts are properly reported on the SEFA, and that federal expenditure calculations are reviewed for accuracy. Views of Responsible Officials and Corrective Action Plan: Management agrees with this finding and is in the process of developing internal controls to ensure timely and appropriate actions are made on the deficiency noted. Additional details can be found in the City of Bloomington’s Corrective Action Plan.
Finding 2023-001: Internal Controls over Compliance and Other Matters Identification of Federal Funds for Purposes of Assembling the Schedule of Expenditures of Federal Awards – Other U.S. DEPARTMENT OF TRANSPORTATION Highway Planning and Construction (Federal-Aid Highway Program) – ALN 20.205 U.S. DEPARTMENT OF TREASURY COVID-19 - Coronavirus State and Local Fiscal Recovery Funds – ALN 21.027 Criteria: Per 2 CFR 200.510(b) Schedule of expenditures of Federal awards, “the auditee must prepare a schedule of expenditures of federal awards for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR 200.502, Basis for determining Federal awards expended. Condition: Prior to correction, certain federal expenditures were not properly identified on the schedule of expenditures of federal awards (SEFA). During our audit, it was determined total federal expenditures for the Highway Planning and Construction program were overstated by approximately $481,000 and federal expenditures for the Coronavirus State and Local Fiscal Recovery Funds program were understated by approximately $340,000 on the SEFA. Cause: Internal controls were not in place to ensure program related revenues (which are used to prepare the federal expenditures for the SEFA) were properly recorded for the Highway Planning and Construction program and that calculations for the Coronavirus State and Local Fiscal Recovery Funds program were reviewed for accuracy. Effect: By not having proper controls over SEFA preparation, there is a risk that the SEFA will not accurately reflect the total amount of federal dollars expended during a particular year. Context: The SEFA was originally overstated by $481,000 for the Highway Planning and Construction program due to reporting $377,000 of expenditures as federal instead of local, reporting $120,000 of remaining encumbrances as 2023 expenditures, and excluding $16,000 of expenditures incurred as a result of recording retainage on a project. The Coronavirus State and Local Fiscal Recovery Funds program expenditures were originally understated on the SEFA by $340,000 due to a formula error relating to the calculation of total federal expenditures for the program. Questioned Costs: $0 Identification of Repeat Finding: Not a repeat finding. Recommendation: We recommend staff review procedures related to revenue recognition of its highway construction programs to ensure amounts are properly reported on the SEFA, and that federal expenditure calculations are reviewed for accuracy. Views of Responsible Officials and Corrective Action Plan: Management agrees with this finding and is in the process of developing internal controls to ensure timely and appropriate actions are made on the deficiency noted. Additional details can be found in the City of Bloomington’s Corrective Action Plan.
PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (REPORTING, CASH MANAGEMENT AND ALLOWABLE COSTS/COST PRINCIPLES. PROGRAMS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.557; AWARD NUMBERS 50022 AND 50035, PASSED-THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; AWARD NUMBER 251126, PASSED-THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: THE CODE OF FEDERAL REGULATIONS (CFR) SECTION 200.303(B) REQUIRES NON-FEDERAL ENTITIES TO ESTABLISH AND MAINTAIN EFFECTIVE INTERNAL CONTROL OVER THE FEDERAL AWARD THAT PROVIDES REASONABLE ASSURANCE THAT THE NON-FEDERAL ENTITY IS MANAGING BY THE FEDERAL AWARD IN COMPLIANCE WITH FEDERAL STATUTES, REGULATIONS, AND TERMS AND CONDITIONS OF THE FEDERAL AWARD. CFR SECTION 200.502(A) STATES THAT THE DETERMINATION OF WHEN A FEDERAL AWARD IS EXPENDED SHOULD BE BASED ON WHEN THE ACTIVITY RELATED TO THE FEDERAL AWARD OCCURS. GENERALLY, THE ACTIVITY PERTAINS TO EVENTS THAT REQUIRE THE NON-FEDERAL ENTITY TO COMPLY WITH FEDERAL STATUTES, REGULATIONS, AND THE TERMS AND CONDITIONS OF FEDERAL AWARDS, SUCH AS EXPENDITURE/EXPENSE TRANSACTIONS ASSOCIATED WITH GRANT AWARDS. THE HEALTH DEPARTMENT REPORTS EXPENDITURES ON THE SEFA WHEN THE EXPENDITURE HAS BEEN INCURRED, OR ON THE ACCRUAL BASIS OF ACCOUNTING, IN ACCORDANCE WITH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. CFR SECTION 200.510(B) REQUIRES THE AUDITEE TO PREPARE A SEFA WHEN THE EXPENDITURE HAS BEEN INCURRED, OR ON THE ACCRUAL BASIS OF ACCOUNTING, IN ACCORDANCE WITH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. CFR SECTION 200.510(B) REQUIRES THE AUDITEE TO PREPARE A SEFA FOR THE PERIOD COVERED BY THE AUDITEE'S FINANCIAL STATEMENTS WHICH MUST INCLUDE TH TOTAL FEDERAL AWARDS EXPENDED AS DETERMINED IN ACCORANCE WITH CRF SECTION 200.502(A), AS STATED ABOVE, AND MUST RECONCILE AMOUNTS REPORTED IN THE SEFA TO THE AMOUNTS REPORTED IN THE AUDITEEE'S FINANCIAL STATEMENTS. CONDITION: THE SEFA WAS NOT APPROPRIATELY RECONCILED TO THE FEDERAL GRANT REVENUES AND EXPENDITURES RECORDED IN THE FINANCIAL STATEMENTS. CHANGES WERE MADE TO MAJOR PROGRAM EXPENDITURES, AS WELL AS EXPENDITURES OF OTHR PROGRAMS DURING THE CLOSING PROCESS AND DURING COMPLETION OF THE SINGLE AUDIT TO PROPERLY REPORT EXPENDITURES ON THE SEFA. CLOSING PROCEDURES SHOULD BE IN PLACE TO RECONCILE GRANT EXPENDITURES INCURRED AT YEAR-END, CONFIRM THE AMOUNT AS ELIGIBLE WITH THE GRANTOR, CLAIM THE GRANT REVENUES ON A TIMELY BASIS, RECONCILE THE CLAIM TO THE GENERAL LEDGER, AND ENSURE THE EXPENDITURES THAT WILL BE CLAIMED UNDER FEDERAL AWARDS ARE PROPERTLY REPORTED ON THE SEFA AND AUDITED FINANCIAL STATEMENTS PRIOR TO THE START OF THE SINGLE AUDIT. IF EXPENDITURES REPORTED ON THE SEFA ARE MISSTATED, THE COUNTY COULD FAIL TO HAVE A PROGRAM APPROPRIATELY INDENTIFIED AS A MAJOR PROGRAM AND TESTED AS A MAJOR PROGRAM DURING THE SINGLE AUDIT. FAILURE TO HAVE A PROGRAM AUDITED DURING THE SINGLE AUDIT WOULD RESULT IN NONCOMPLIANCE WITH TITLE 2 U.S. CODE OF FEDERAL REGULATIONS PART 200, UNIFORM ADMINISTRATIVE REQUIREMENTS, COST PRINCIPLES, AND AUDIT REQUIREMENTS FOR FEDERAL AWARDS (UNIFORM GUIDANCE). CAUSE: THE WAS THE HEALTH DEPARTMENT'S FIRST STANDALONE AUDIT AND MANAGEMENT HAD NOT PREPARED A SEFA IN THE PAST. EFFECT: THE SEFA RQUIRED MATERIAL ADJUSTMENTS TO INCLUDE ALL FEDERAL EXPENDITURES PRIOR TO THE SINGLE AUDIT BEGINNING, WHICH RESULTED IN A MISSTATED PRELIMINARY SEFA AND INEFFICIENCIES DURING THE SINGLE AUDIT. QUESTIONED COSTS: NO COSTS HAVE BEEN QUESTIONED AS A RESULT OF THIS FINDING. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT TRACT THEIR FEDERAL AWARDS MORE REGULARLY AND RECONCILE IT TO THE GENERAL LEDGER. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMENT WILL REVISIT THEIR PROCEDURES AND METHOD OF FEDERAL AWARDS.
PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (REPORTING, CASH MANAGEMENT AND ALLOWABLE COSTS/COST PRINCIPLES. PROGRAMS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.557; AWARD NUMBERS 50022 AND 50035, PASSED-THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; AWARD NUMBER 251126, PASSED-THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: THE CODE OF FEDERAL REGULATIONS (CFR) SECTION 200.303(B) REQUIRES NON-FEDERAL ENTITIES TO ESTABLISH AND MAINTAIN EFFECTIVE INTERNAL CONTROL OVER THE FEDERAL AWARD THAT PROVIDES REASONABLE ASSURANCE THAT THE NON-FEDERAL ENTITY IS MANAGING BY THE FEDERAL AWARD IN COMPLIANCE WITH FEDERAL STATUTES, REGULATIONS, AND TERMS AND CONDITIONS OF THE FEDERAL AWARD. CFR SECTION 200.502(A) STATES THAT THE DETERMINATION OF WHEN A FEDERAL AWARD IS EXPENDED SHOULD BE BASED ON WHEN THE ACTIVITY RELATED TO THE FEDERAL AWARD OCCURS. GENERALLY, THE ACTIVITY PERTAINS TO EVENTS THAT REQUIRE THE NON-FEDERAL ENTITY TO COMPLY WITH FEDERAL STATUTES, REGULATIONS, AND THE TERMS AND CONDITIONS OF FEDERAL AWARDS, SUCH AS EXPENDITURE/EXPENSE TRANSACTIONS ASSOCIATED WITH GRANT AWARDS. THE HEALTH DEPARTMENT REPORTS EXPENDITURES ON THE SEFA WHEN THE EXPENDITURE HAS BEEN INCURRED, OR ON THE ACCRUAL BASIS OF ACCOUNTING, IN ACCORDANCE WITH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. CFR SECTION 200.510(B) REQUIRES THE AUDITEE TO PREPARE A SEFA WHEN THE EXPENDITURE HAS BEEN INCURRED, OR ON THE ACCRUAL BASIS OF ACCOUNTING, IN ACCORDANCE WITH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. CFR SECTION 200.510(B) REQUIRES THE AUDITEE TO PREPARE A SEFA FOR THE PERIOD COVERED BY THE AUDITEE'S FINANCIAL STATEMENTS WHICH MUST INCLUDE TH TOTAL FEDERAL AWARDS EXPENDED AS DETERMINED IN ACCORANCE WITH CRF SECTION 200.502(A), AS STATED ABOVE, AND MUST RECONCILE AMOUNTS REPORTED IN THE SEFA TO THE AMOUNTS REPORTED IN THE AUDITEEE'S FINANCIAL STATEMENTS. CONDITION: THE SEFA WAS NOT APPROPRIATELY RECONCILED TO THE FEDERAL GRANT REVENUES AND EXPENDITURES RECORDED IN THE FINANCIAL STATEMENTS. CHANGES WERE MADE TO MAJOR PROGRAM EXPENDITURES, AS WELL AS EXPENDITURES OF OTHR PROGRAMS DURING THE CLOSING PROCESS AND DURING COMPLETION OF THE SINGLE AUDIT TO PROPERLY REPORT EXPENDITURES ON THE SEFA. CLOSING PROCEDURES SHOULD BE IN PLACE TO RECONCILE GRANT EXPENDITURES INCURRED AT YEAR-END, CONFIRM THE AMOUNT AS ELIGIBLE WITH THE GRANTOR, CLAIM THE GRANT REVENUES ON A TIMELY BASIS, RECONCILE THE CLAIM TO THE GENERAL LEDGER, AND ENSURE THE EXPENDITURES THAT WILL BE CLAIMED UNDER FEDERAL AWARDS ARE PROPERTLY REPORTED ON THE SEFA AND AUDITED FINANCIAL STATEMENTS PRIOR TO THE START OF THE SINGLE AUDIT. IF EXPENDITURES REPORTED ON THE SEFA ARE MISSTATED, THE COUNTY COULD FAIL TO HAVE A PROGRAM APPROPRIATELY INDENTIFIED AS A MAJOR PROGRAM AND TESTED AS A MAJOR PROGRAM DURING THE SINGLE AUDIT. FAILURE TO HAVE A PROGRAM AUDITED DURING THE SINGLE AUDIT WOULD RESULT IN NONCOMPLIANCE WITH TITLE 2 U.S. CODE OF FEDERAL REGULATIONS PART 200, UNIFORM ADMINISTRATIVE REQUIREMENTS, COST PRINCIPLES, AND AUDIT REQUIREMENTS FOR FEDERAL AWARDS (UNIFORM GUIDANCE). CAUSE: THE WAS THE HEALTH DEPARTMENT'S FIRST STANDALONE AUDIT AND MANAGEMENT HAD NOT PREPARED A SEFA IN THE PAST. EFFECT: THE SEFA RQUIRED MATERIAL ADJUSTMENTS TO INCLUDE ALL FEDERAL EXPENDITURES PRIOR TO THE SINGLE AUDIT BEGINNING, WHICH RESULTED IN A MISSTATED PRELIMINARY SEFA AND INEFFICIENCIES DURING THE SINGLE AUDIT. QUESTIONED COSTS: NO COSTS HAVE BEEN QUESTIONED AS A RESULT OF THIS FINDING. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT TRACT THEIR FEDERAL AWARDS MORE REGULARLY AND RECONCILE IT TO THE GENERAL LEDGER. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMENT WILL REVISIT THEIR PROCEDURES AND METHOD OF FEDERAL AWARDS.
PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (REPORTING, CASH MANAGEMENT AND ALLOWABLE COSTS/COST PRINCIPLES. PROGRAMS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.557; AWARD NUMBERS 50022 AND 50035, PASSED-THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; AWARD NUMBER 251126, PASSED-THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: THE CODE OF FEDERAL REGULATIONS (CFR) SECTION 200.303(B) REQUIRES NON-FEDERAL ENTITIES TO ESTABLISH AND MAINTAIN EFFECTIVE INTERNAL CONTROL OVER THE FEDERAL AWARD THAT PROVIDES REASONABLE ASSURANCE THAT THE NON-FEDERAL ENTITY IS MANAGING BY THE FEDERAL AWARD IN COMPLIANCE WITH FEDERAL STATUTES, REGULATIONS, AND TERMS AND CONDITIONS OF THE FEDERAL AWARD. CFR SECTION 200.502(A) STATES THAT THE DETERMINATION OF WHEN A FEDERAL AWARD IS EXPENDED SHOULD BE BASED ON WHEN THE ACTIVITY RELATED TO THE FEDERAL AWARD OCCURS. GENERALLY, THE ACTIVITY PERTAINS TO EVENTS THAT REQUIRE THE NON-FEDERAL ENTITY TO COMPLY WITH FEDERAL STATUTES, REGULATIONS, AND THE TERMS AND CONDITIONS OF FEDERAL AWARDS, SUCH AS EXPENDITURE/EXPENSE TRANSACTIONS ASSOCIATED WITH GRANT AWARDS. THE HEALTH DEPARTMENT REPORTS EXPENDITURES ON THE SEFA WHEN THE EXPENDITURE HAS BEEN INCURRED, OR ON THE ACCRUAL BASIS OF ACCOUNTING, IN ACCORDANCE WITH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. CFR SECTION 200.510(B) REQUIRES THE AUDITEE TO PREPARE A SEFA WHEN THE EXPENDITURE HAS BEEN INCURRED, OR ON THE ACCRUAL BASIS OF ACCOUNTING, IN ACCORDANCE WITH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. CFR SECTION 200.510(B) REQUIRES THE AUDITEE TO PREPARE A SEFA FOR THE PERIOD COVERED BY THE AUDITEE'S FINANCIAL STATEMENTS WHICH MUST INCLUDE TH TOTAL FEDERAL AWARDS EXPENDED AS DETERMINED IN ACCORANCE WITH CRF SECTION 200.502(A), AS STATED ABOVE, AND MUST RECONCILE AMOUNTS REPORTED IN THE SEFA TO THE AMOUNTS REPORTED IN THE AUDITEEE'S FINANCIAL STATEMENTS. CONDITION: THE SEFA WAS NOT APPROPRIATELY RECONCILED TO THE FEDERAL GRANT REVENUES AND EXPENDITURES RECORDED IN THE FINANCIAL STATEMENTS. CHANGES WERE MADE TO MAJOR PROGRAM EXPENDITURES, AS WELL AS EXPENDITURES OF OTHR PROGRAMS DURING THE CLOSING PROCESS AND DURING COMPLETION OF THE SINGLE AUDIT TO PROPERLY REPORT EXPENDITURES ON THE SEFA. CLOSING PROCEDURES SHOULD BE IN PLACE TO RECONCILE GRANT EXPENDITURES INCURRED AT YEAR-END, CONFIRM THE AMOUNT AS ELIGIBLE WITH THE GRANTOR, CLAIM THE GRANT REVENUES ON A TIMELY BASIS, RECONCILE THE CLAIM TO THE GENERAL LEDGER, AND ENSURE THE EXPENDITURES THAT WILL BE CLAIMED UNDER FEDERAL AWARDS ARE PROPERTLY REPORTED ON THE SEFA AND AUDITED FINANCIAL STATEMENTS PRIOR TO THE START OF THE SINGLE AUDIT. IF EXPENDITURES REPORTED ON THE SEFA ARE MISSTATED, THE COUNTY COULD FAIL TO HAVE A PROGRAM APPROPRIATELY INDENTIFIED AS A MAJOR PROGRAM AND TESTED AS A MAJOR PROGRAM DURING THE SINGLE AUDIT. FAILURE TO HAVE A PROGRAM AUDITED DURING THE SINGLE AUDIT WOULD RESULT IN NONCOMPLIANCE WITH TITLE 2 U.S. CODE OF FEDERAL REGULATIONS PART 200, UNIFORM ADMINISTRATIVE REQUIREMENTS, COST PRINCIPLES, AND AUDIT REQUIREMENTS FOR FEDERAL AWARDS (UNIFORM GUIDANCE). CAUSE: THE WAS THE HEALTH DEPARTMENT'S FIRST STANDALONE AUDIT AND MANAGEMENT HAD NOT PREPARED A SEFA IN THE PAST. EFFECT: THE SEFA RQUIRED MATERIAL ADJUSTMENTS TO INCLUDE ALL FEDERAL EXPENDITURES PRIOR TO THE SINGLE AUDIT BEGINNING, WHICH RESULTED IN A MISSTATED PRELIMINARY SEFA AND INEFFICIENCIES DURING THE SINGLE AUDIT. QUESTIONED COSTS: NO COSTS HAVE BEEN QUESTIONED AS A RESULT OF THIS FINDING. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT TRACT THEIR FEDERAL AWARDS MORE REGULARLY AND RECONCILE IT TO THE GENERAL LEDGER. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMENT WILL REVISIT THEIR PROCEDURES AND METHOD OF FEDERAL AWARDS.
PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (REPORTING, CASH MANAGEMENT AND ALLOWABLE COSTS/COST PRINCIPLES. PROGRAMS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.557; AWARD NUMBERS 50022 AND 50035, PASSED-THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; AWARD NUMBER 251126, PASSED-THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: THE CODE OF FEDERAL REGULATIONS (CFR) SECTION 200.303(B) REQUIRES NON-FEDERAL ENTITIES TO ESTABLISH AND MAINTAIN EFFECTIVE INTERNAL CONTROL OVER THE FEDERAL AWARD THAT PROVIDES REASONABLE ASSURANCE THAT THE NON-FEDERAL ENTITY IS MANAGING BY THE FEDERAL AWARD IN COMPLIANCE WITH FEDERAL STATUTES, REGULATIONS, AND TERMS AND CONDITIONS OF THE FEDERAL AWARD. CFR SECTION 200.502(A) STATES THAT THE DETERMINATION OF WHEN A FEDERAL AWARD IS EXPENDED SHOULD BE BASED ON WHEN THE ACTIVITY RELATED TO THE FEDERAL AWARD OCCURS. GENERALLY, THE ACTIVITY PERTAINS TO EVENTS THAT REQUIRE THE NON-FEDERAL ENTITY TO COMPLY WITH FEDERAL STATUTES, REGULATIONS, AND THE TERMS AND CONDITIONS OF FEDERAL AWARDS, SUCH AS EXPENDITURE/EXPENSE TRANSACTIONS ASSOCIATED WITH GRANT AWARDS. THE HEALTH DEPARTMENT REPORTS EXPENDITURES ON THE SEFA WHEN THE EXPENDITURE HAS BEEN INCURRED, OR ON THE ACCRUAL BASIS OF ACCOUNTING, IN ACCORDANCE WITH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. CFR SECTION 200.510(B) REQUIRES THE AUDITEE TO PREPARE A SEFA WHEN THE EXPENDITURE HAS BEEN INCURRED, OR ON THE ACCRUAL BASIS OF ACCOUNTING, IN ACCORDANCE WITH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. CFR SECTION 200.510(B) REQUIRES THE AUDITEE TO PREPARE A SEFA FOR THE PERIOD COVERED BY THE AUDITEE'S FINANCIAL STATEMENTS WHICH MUST INCLUDE TH TOTAL FEDERAL AWARDS EXPENDED AS DETERMINED IN ACCORANCE WITH CRF SECTION 200.502(A), AS STATED ABOVE, AND MUST RECONCILE AMOUNTS REPORTED IN THE SEFA TO THE AMOUNTS REPORTED IN THE AUDITEEE'S FINANCIAL STATEMENTS. CONDITION: THE SEFA WAS NOT APPROPRIATELY RECONCILED TO THE FEDERAL GRANT REVENUES AND EXPENDITURES RECORDED IN THE FINANCIAL STATEMENTS. CHANGES WERE MADE TO MAJOR PROGRAM EXPENDITURES, AS WELL AS EXPENDITURES OF OTHR PROGRAMS DURING THE CLOSING PROCESS AND DURING COMPLETION OF THE SINGLE AUDIT TO PROPERLY REPORT EXPENDITURES ON THE SEFA. CLOSING PROCEDURES SHOULD BE IN PLACE TO RECONCILE GRANT EXPENDITURES INCURRED AT YEAR-END, CONFIRM THE AMOUNT AS ELIGIBLE WITH THE GRANTOR, CLAIM THE GRANT REVENUES ON A TIMELY BASIS, RECONCILE THE CLAIM TO THE GENERAL LEDGER, AND ENSURE THE EXPENDITURES THAT WILL BE CLAIMED UNDER FEDERAL AWARDS ARE PROPERTLY REPORTED ON THE SEFA AND AUDITED FINANCIAL STATEMENTS PRIOR TO THE START OF THE SINGLE AUDIT. IF EXPENDITURES REPORTED ON THE SEFA ARE MISSTATED, THE COUNTY COULD FAIL TO HAVE A PROGRAM APPROPRIATELY INDENTIFIED AS A MAJOR PROGRAM AND TESTED AS A MAJOR PROGRAM DURING THE SINGLE AUDIT. FAILURE TO HAVE A PROGRAM AUDITED DURING THE SINGLE AUDIT WOULD RESULT IN NONCOMPLIANCE WITH TITLE 2 U.S. CODE OF FEDERAL REGULATIONS PART 200, UNIFORM ADMINISTRATIVE REQUIREMENTS, COST PRINCIPLES, AND AUDIT REQUIREMENTS FOR FEDERAL AWARDS (UNIFORM GUIDANCE). CAUSE: THE WAS THE HEALTH DEPARTMENT'S FIRST STANDALONE AUDIT AND MANAGEMENT HAD NOT PREPARED A SEFA IN THE PAST. EFFECT: THE SEFA RQUIRED MATERIAL ADJUSTMENTS TO INCLUDE ALL FEDERAL EXPENDITURES PRIOR TO THE SINGLE AUDIT BEGINNING, WHICH RESULTED IN A MISSTATED PRELIMINARY SEFA AND INEFFICIENCIES DURING THE SINGLE AUDIT. QUESTIONED COSTS: NO COSTS HAVE BEEN QUESTIONED AS A RESULT OF THIS FINDING. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT TRACT THEIR FEDERAL AWARDS MORE REGULARLY AND RECONCILE IT TO THE GENERAL LEDGER. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMENT WILL REVISIT THEIR PROCEDURES AND METHOD OF FEDERAL AWARDS.
PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (REPORTING, CASH MANAGEMENT AND ALLOWABLE COSTS/COST PRINCIPLES. PROGRAMS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.557; AWARD NUMBERS 50022 AND 50035, PASSED-THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; AWARD NUMBER 251126, PASSED-THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: THE CODE OF FEDERAL REGULATIONS (CFR) SECTION 200.303(B) REQUIRES NON-FEDERAL ENTITIES TO ESTABLISH AND MAINTAIN EFFECTIVE INTERNAL CONTROL OVER THE FEDERAL AWARD THAT PROVIDES REASONABLE ASSURANCE THAT THE NON-FEDERAL ENTITY IS MANAGING BY THE FEDERAL AWARD IN COMPLIANCE WITH FEDERAL STATUTES, REGULATIONS, AND TERMS AND CONDITIONS OF THE FEDERAL AWARD. CFR SECTION 200.502(A) STATES THAT THE DETERMINATION OF WHEN A FEDERAL AWARD IS EXPENDED SHOULD BE BASED ON WHEN THE ACTIVITY RELATED TO THE FEDERAL AWARD OCCURS. GENERALLY, THE ACTIVITY PERTAINS TO EVENTS THAT REQUIRE THE NON-FEDERAL ENTITY TO COMPLY WITH FEDERAL STATUTES, REGULATIONS, AND THE TERMS AND CONDITIONS OF FEDERAL AWARDS, SUCH AS EXPENDITURE/EXPENSE TRANSACTIONS ASSOCIATED WITH GRANT AWARDS. THE HEALTH DEPARTMENT REPORTS EXPENDITURES ON THE SEFA WHEN THE EXPENDITURE HAS BEEN INCURRED, OR ON THE ACCRUAL BASIS OF ACCOUNTING, IN ACCORDANCE WITH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. CFR SECTION 200.510(B) REQUIRES THE AUDITEE TO PREPARE A SEFA WHEN THE EXPENDITURE HAS BEEN INCURRED, OR ON THE ACCRUAL BASIS OF ACCOUNTING, IN ACCORDANCE WITH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. CFR SECTION 200.510(B) REQUIRES THE AUDITEE TO PREPARE A SEFA FOR THE PERIOD COVERED BY THE AUDITEE'S FINANCIAL STATEMENTS WHICH MUST INCLUDE TH TOTAL FEDERAL AWARDS EXPENDED AS DETERMINED IN ACCORANCE WITH CRF SECTION 200.502(A), AS STATED ABOVE, AND MUST RECONCILE AMOUNTS REPORTED IN THE SEFA TO THE AMOUNTS REPORTED IN THE AUDITEEE'S FINANCIAL STATEMENTS. CONDITION: THE SEFA WAS NOT APPROPRIATELY RECONCILED TO THE FEDERAL GRANT REVENUES AND EXPENDITURES RECORDED IN THE FINANCIAL STATEMENTS. CHANGES WERE MADE TO MAJOR PROGRAM EXPENDITURES, AS WELL AS EXPENDITURES OF OTHR PROGRAMS DURING THE CLOSING PROCESS AND DURING COMPLETION OF THE SINGLE AUDIT TO PROPERLY REPORT EXPENDITURES ON THE SEFA. CLOSING PROCEDURES SHOULD BE IN PLACE TO RECONCILE GRANT EXPENDITURES INCURRED AT YEAR-END, CONFIRM THE AMOUNT AS ELIGIBLE WITH THE GRANTOR, CLAIM THE GRANT REVENUES ON A TIMELY BASIS, RECONCILE THE CLAIM TO THE GENERAL LEDGER, AND ENSURE THE EXPENDITURES THAT WILL BE CLAIMED UNDER FEDERAL AWARDS ARE PROPERTLY REPORTED ON THE SEFA AND AUDITED FINANCIAL STATEMENTS PRIOR TO THE START OF THE SINGLE AUDIT. IF EXPENDITURES REPORTED ON THE SEFA ARE MISSTATED, THE COUNTY COULD FAIL TO HAVE A PROGRAM APPROPRIATELY INDENTIFIED AS A MAJOR PROGRAM AND TESTED AS A MAJOR PROGRAM DURING THE SINGLE AUDIT. FAILURE TO HAVE A PROGRAM AUDITED DURING THE SINGLE AUDIT WOULD RESULT IN NONCOMPLIANCE WITH TITLE 2 U.S. CODE OF FEDERAL REGULATIONS PART 200, UNIFORM ADMINISTRATIVE REQUIREMENTS, COST PRINCIPLES, AND AUDIT REQUIREMENTS FOR FEDERAL AWARDS (UNIFORM GUIDANCE). CAUSE: THE WAS THE HEALTH DEPARTMENT'S FIRST STANDALONE AUDIT AND MANAGEMENT HAD NOT PREPARED A SEFA IN THE PAST. EFFECT: THE SEFA RQUIRED MATERIAL ADJUSTMENTS TO INCLUDE ALL FEDERAL EXPENDITURES PRIOR TO THE SINGLE AUDIT BEGINNING, WHICH RESULTED IN A MISSTATED PRELIMINARY SEFA AND INEFFICIENCIES DURING THE SINGLE AUDIT. QUESTIONED COSTS: NO COSTS HAVE BEEN QUESTIONED AS A RESULT OF THIS FINDING. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT TRACT THEIR FEDERAL AWARDS MORE REGULARLY AND RECONCILE IT TO THE GENERAL LEDGER. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMENT WILL REVISIT THEIR PROCEDURES AND METHOD OF FEDERAL AWARDS.
PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (REPORTING, CASH MANAGEMENT AND ALLOWABLE COSTS/COST PRINCIPLES. PROGRAMS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.557; AWARD NUMBERS 50022 AND 50035, PASSED-THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; AWARD NUMBER 251126, PASSED-THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: THE CODE OF FEDERAL REGULATIONS (CFR) SECTION 200.303(B) REQUIRES NON-FEDERAL ENTITIES TO ESTABLISH AND MAINTAIN EFFECTIVE INTERNAL CONTROL OVER THE FEDERAL AWARD THAT PROVIDES REASONABLE ASSURANCE THAT THE NON-FEDERAL ENTITY IS MANAGING BY THE FEDERAL AWARD IN COMPLIANCE WITH FEDERAL STATUTES, REGULATIONS, AND TERMS AND CONDITIONS OF THE FEDERAL AWARD. CFR SECTION 200.502(A) STATES THAT THE DETERMINATION OF WHEN A FEDERAL AWARD IS EXPENDED SHOULD BE BASED ON WHEN THE ACTIVITY RELATED TO THE FEDERAL AWARD OCCURS. GENERALLY, THE ACTIVITY PERTAINS TO EVENTS THAT REQUIRE THE NON-FEDERAL ENTITY TO COMPLY WITH FEDERAL STATUTES, REGULATIONS, AND THE TERMS AND CONDITIONS OF FEDERAL AWARDS, SUCH AS EXPENDITURE/EXPENSE TRANSACTIONS ASSOCIATED WITH GRANT AWARDS. THE HEALTH DEPARTMENT REPORTS EXPENDITURES ON THE SEFA WHEN THE EXPENDITURE HAS BEEN INCURRED, OR ON THE ACCRUAL BASIS OF ACCOUNTING, IN ACCORDANCE WITH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. CFR SECTION 200.510(B) REQUIRES THE AUDITEE TO PREPARE A SEFA WHEN THE EXPENDITURE HAS BEEN INCURRED, OR ON THE ACCRUAL BASIS OF ACCOUNTING, IN ACCORDANCE WITH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. CFR SECTION 200.510(B) REQUIRES THE AUDITEE TO PREPARE A SEFA FOR THE PERIOD COVERED BY THE AUDITEE'S FINANCIAL STATEMENTS WHICH MUST INCLUDE TH TOTAL FEDERAL AWARDS EXPENDED AS DETERMINED IN ACCORANCE WITH CRF SECTION 200.502(A), AS STATED ABOVE, AND MUST RECONCILE AMOUNTS REPORTED IN THE SEFA TO THE AMOUNTS REPORTED IN THE AUDITEEE'S FINANCIAL STATEMENTS. CONDITION: THE SEFA WAS NOT APPROPRIATELY RECONCILED TO THE FEDERAL GRANT REVENUES AND EXPENDITURES RECORDED IN THE FINANCIAL STATEMENTS. CHANGES WERE MADE TO MAJOR PROGRAM EXPENDITURES, AS WELL AS EXPENDITURES OF OTHR PROGRAMS DURING THE CLOSING PROCESS AND DURING COMPLETION OF THE SINGLE AUDIT TO PROPERLY REPORT EXPENDITURES ON THE SEFA. CLOSING PROCEDURES SHOULD BE IN PLACE TO RECONCILE GRANT EXPENDITURES INCURRED AT YEAR-END, CONFIRM THE AMOUNT AS ELIGIBLE WITH THE GRANTOR, CLAIM THE GRANT REVENUES ON A TIMELY BASIS, RECONCILE THE CLAIM TO THE GENERAL LEDGER, AND ENSURE THE EXPENDITURES THAT WILL BE CLAIMED UNDER FEDERAL AWARDS ARE PROPERTLY REPORTED ON THE SEFA AND AUDITED FINANCIAL STATEMENTS PRIOR TO THE START OF THE SINGLE AUDIT. IF EXPENDITURES REPORTED ON THE SEFA ARE MISSTATED, THE COUNTY COULD FAIL TO HAVE A PROGRAM APPROPRIATELY INDENTIFIED AS A MAJOR PROGRAM AND TESTED AS A MAJOR PROGRAM DURING THE SINGLE AUDIT. FAILURE TO HAVE A PROGRAM AUDITED DURING THE SINGLE AUDIT WOULD RESULT IN NONCOMPLIANCE WITH TITLE 2 U.S. CODE OF FEDERAL REGULATIONS PART 200, UNIFORM ADMINISTRATIVE REQUIREMENTS, COST PRINCIPLES, AND AUDIT REQUIREMENTS FOR FEDERAL AWARDS (UNIFORM GUIDANCE). CAUSE: THE WAS THE HEALTH DEPARTMENT'S FIRST STANDALONE AUDIT AND MANAGEMENT HAD NOT PREPARED A SEFA IN THE PAST. EFFECT: THE SEFA RQUIRED MATERIAL ADJUSTMENTS TO INCLUDE ALL FEDERAL EXPENDITURES PRIOR TO THE SINGLE AUDIT BEGINNING, WHICH RESULTED IN A MISSTATED PRELIMINARY SEFA AND INEFFICIENCIES DURING THE SINGLE AUDIT. QUESTIONED COSTS: NO COSTS HAVE BEEN QUESTIONED AS A RESULT OF THIS FINDING. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT TRACT THEIR FEDERAL AWARDS MORE REGULARLY AND RECONCILE IT TO THE GENERAL LEDGER. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMENT WILL REVISIT THEIR PROCEDURES AND METHOD OF FEDERAL AWARDS.
PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (REPORTING, CASH MANAGEMENT AND ALLOWABLE COSTS/COST PRINCIPLES. PROGRAMS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.557; AWARD NUMBERS 50022 AND 50035, PASSED-THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; AWARD NUMBER 251126, PASSED-THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: THE CODE OF FEDERAL REGULATIONS (CFR) SECTION 200.303(B) REQUIRES NON-FEDERAL ENTITIES TO ESTABLISH AND MAINTAIN EFFECTIVE INTERNAL CONTROL OVER THE FEDERAL AWARD THAT PROVIDES REASONABLE ASSURANCE THAT THE NON-FEDERAL ENTITY IS MANAGING BY THE FEDERAL AWARD IN COMPLIANCE WITH FEDERAL STATUTES, REGULATIONS, AND TERMS AND CONDITIONS OF THE FEDERAL AWARD. CFR SECTION 200.502(A) STATES THAT THE DETERMINATION OF WHEN A FEDERAL AWARD IS EXPENDED SHOULD BE BASED ON WHEN THE ACTIVITY RELATED TO THE FEDERAL AWARD OCCURS. GENERALLY, THE ACTIVITY PERTAINS TO EVENTS THAT REQUIRE THE NON-FEDERAL ENTITY TO COMPLY WITH FEDERAL STATUTES, REGULATIONS, AND THE TERMS AND CONDITIONS OF FEDERAL AWARDS, SUCH AS EXPENDITURE/EXPENSE TRANSACTIONS ASSOCIATED WITH GRANT AWARDS. THE HEALTH DEPARTMENT REPORTS EXPENDITURES ON THE SEFA WHEN THE EXPENDITURE HAS BEEN INCURRED, OR ON THE ACCRUAL BASIS OF ACCOUNTING, IN ACCORDANCE WITH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. CFR SECTION 200.510(B) REQUIRES THE AUDITEE TO PREPARE A SEFA WHEN THE EXPENDITURE HAS BEEN INCURRED, OR ON THE ACCRUAL BASIS OF ACCOUNTING, IN ACCORDANCE WITH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. CFR SECTION 200.510(B) REQUIRES THE AUDITEE TO PREPARE A SEFA FOR THE PERIOD COVERED BY THE AUDITEE'S FINANCIAL STATEMENTS WHICH MUST INCLUDE TH TOTAL FEDERAL AWARDS EXPENDED AS DETERMINED IN ACCORANCE WITH CRF SECTION 200.502(A), AS STATED ABOVE, AND MUST RECONCILE AMOUNTS REPORTED IN THE SEFA TO THE AMOUNTS REPORTED IN THE AUDITEEE'S FINANCIAL STATEMENTS. CONDITION: THE SEFA WAS NOT APPROPRIATELY RECONCILED TO THE FEDERAL GRANT REVENUES AND EXPENDITURES RECORDED IN THE FINANCIAL STATEMENTS. CHANGES WERE MADE TO MAJOR PROGRAM EXPENDITURES, AS WELL AS EXPENDITURES OF OTHR PROGRAMS DURING THE CLOSING PROCESS AND DURING COMPLETION OF THE SINGLE AUDIT TO PROPERLY REPORT EXPENDITURES ON THE SEFA. CLOSING PROCEDURES SHOULD BE IN PLACE TO RECONCILE GRANT EXPENDITURES INCURRED AT YEAR-END, CONFIRM THE AMOUNT AS ELIGIBLE WITH THE GRANTOR, CLAIM THE GRANT REVENUES ON A TIMELY BASIS, RECONCILE THE CLAIM TO THE GENERAL LEDGER, AND ENSURE THE EXPENDITURES THAT WILL BE CLAIMED UNDER FEDERAL AWARDS ARE PROPERTLY REPORTED ON THE SEFA AND AUDITED FINANCIAL STATEMENTS PRIOR TO THE START OF THE SINGLE AUDIT. IF EXPENDITURES REPORTED ON THE SEFA ARE MISSTATED, THE COUNTY COULD FAIL TO HAVE A PROGRAM APPROPRIATELY INDENTIFIED AS A MAJOR PROGRAM AND TESTED AS A MAJOR PROGRAM DURING THE SINGLE AUDIT. FAILURE TO HAVE A PROGRAM AUDITED DURING THE SINGLE AUDIT WOULD RESULT IN NONCOMPLIANCE WITH TITLE 2 U.S. CODE OF FEDERAL REGULATIONS PART 200, UNIFORM ADMINISTRATIVE REQUIREMENTS, COST PRINCIPLES, AND AUDIT REQUIREMENTS FOR FEDERAL AWARDS (UNIFORM GUIDANCE). CAUSE: THE WAS THE HEALTH DEPARTMENT'S FIRST STANDALONE AUDIT AND MANAGEMENT HAD NOT PREPARED A SEFA IN THE PAST. EFFECT: THE SEFA RQUIRED MATERIAL ADJUSTMENTS TO INCLUDE ALL FEDERAL EXPENDITURES PRIOR TO THE SINGLE AUDIT BEGINNING, WHICH RESULTED IN A MISSTATED PRELIMINARY SEFA AND INEFFICIENCIES DURING THE SINGLE AUDIT. QUESTIONED COSTS: NO COSTS HAVE BEEN QUESTIONED AS A RESULT OF THIS FINDING. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT TRACT THEIR FEDERAL AWARDS MORE REGULARLY AND RECONCILE IT TO THE GENERAL LEDGER. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMENT WILL REVISIT THEIR PROCEDURES AND METHOD OF FEDERAL AWARDS.
PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS: FINDING TYPE: MATERIAL NONCOMPLIANCE/MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE (REPORTING, CASH MANAGEMENT AND ALLOWABLE COSTS/COST PRINCIPLES. PROGRAMS: SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN; ASSISTANCE LISTING NUMBER 10.557; AWARD NUMBERS 50022 AND 50035, PASSED-THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. ELC CONTRACT TRACING, INVESTIGATION, TESTING COORD., AND INFECTION PREVENTION; ASSISTANCE LISTING NUMBER 93.323; AWARD NUMBER 251126, PASSED-THROUGH THE MICHIGAN DEPARTMENT OF COMMUNITY HEALTH. CRITERIA: THE CODE OF FEDERAL REGULATIONS (CFR) SECTION 200.303(B) REQUIRES NON-FEDERAL ENTITIES TO ESTABLISH AND MAINTAIN EFFECTIVE INTERNAL CONTROL OVER THE FEDERAL AWARD THAT PROVIDES REASONABLE ASSURANCE THAT THE NON-FEDERAL ENTITY IS MANAGING BY THE FEDERAL AWARD IN COMPLIANCE WITH FEDERAL STATUTES, REGULATIONS, AND TERMS AND CONDITIONS OF THE FEDERAL AWARD. CFR SECTION 200.502(A) STATES THAT THE DETERMINATION OF WHEN A FEDERAL AWARD IS EXPENDED SHOULD BE BASED ON WHEN THE ACTIVITY RELATED TO THE FEDERAL AWARD OCCURS. GENERALLY, THE ACTIVITY PERTAINS TO EVENTS THAT REQUIRE THE NON-FEDERAL ENTITY TO COMPLY WITH FEDERAL STATUTES, REGULATIONS, AND THE TERMS AND CONDITIONS OF FEDERAL AWARDS, SUCH AS EXPENDITURE/EXPENSE TRANSACTIONS ASSOCIATED WITH GRANT AWARDS. THE HEALTH DEPARTMENT REPORTS EXPENDITURES ON THE SEFA WHEN THE EXPENDITURE HAS BEEN INCURRED, OR ON THE ACCRUAL BASIS OF ACCOUNTING, IN ACCORDANCE WITH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. CFR SECTION 200.510(B) REQUIRES THE AUDITEE TO PREPARE A SEFA WHEN THE EXPENDITURE HAS BEEN INCURRED, OR ON THE ACCRUAL BASIS OF ACCOUNTING, IN ACCORDANCE WITH GENERALLY ACCEPTED ACCOUNTING PRINCIPLES. CFR SECTION 200.510(B) REQUIRES THE AUDITEE TO PREPARE A SEFA FOR THE PERIOD COVERED BY THE AUDITEE'S FINANCIAL STATEMENTS WHICH MUST INCLUDE TH TOTAL FEDERAL AWARDS EXPENDED AS DETERMINED IN ACCORANCE WITH CRF SECTION 200.502(A), AS STATED ABOVE, AND MUST RECONCILE AMOUNTS REPORTED IN THE SEFA TO THE AMOUNTS REPORTED IN THE AUDITEEE'S FINANCIAL STATEMENTS. CONDITION: THE SEFA WAS NOT APPROPRIATELY RECONCILED TO THE FEDERAL GRANT REVENUES AND EXPENDITURES RECORDED IN THE FINANCIAL STATEMENTS. CHANGES WERE MADE TO MAJOR PROGRAM EXPENDITURES, AS WELL AS EXPENDITURES OF OTHR PROGRAMS DURING THE CLOSING PROCESS AND DURING COMPLETION OF THE SINGLE AUDIT TO PROPERLY REPORT EXPENDITURES ON THE SEFA. CLOSING PROCEDURES SHOULD BE IN PLACE TO RECONCILE GRANT EXPENDITURES INCURRED AT YEAR-END, CONFIRM THE AMOUNT AS ELIGIBLE WITH THE GRANTOR, CLAIM THE GRANT REVENUES ON A TIMELY BASIS, RECONCILE THE CLAIM TO THE GENERAL LEDGER, AND ENSURE THE EXPENDITURES THAT WILL BE CLAIMED UNDER FEDERAL AWARDS ARE PROPERTLY REPORTED ON THE SEFA AND AUDITED FINANCIAL STATEMENTS PRIOR TO THE START OF THE SINGLE AUDIT. IF EXPENDITURES REPORTED ON THE SEFA ARE MISSTATED, THE COUNTY COULD FAIL TO HAVE A PROGRAM APPROPRIATELY INDENTIFIED AS A MAJOR PROGRAM AND TESTED AS A MAJOR PROGRAM DURING THE SINGLE AUDIT. FAILURE TO HAVE A PROGRAM AUDITED DURING THE SINGLE AUDIT WOULD RESULT IN NONCOMPLIANCE WITH TITLE 2 U.S. CODE OF FEDERAL REGULATIONS PART 200, UNIFORM ADMINISTRATIVE REQUIREMENTS, COST PRINCIPLES, AND AUDIT REQUIREMENTS FOR FEDERAL AWARDS (UNIFORM GUIDANCE). CAUSE: THE WAS THE HEALTH DEPARTMENT'S FIRST STANDALONE AUDIT AND MANAGEMENT HAD NOT PREPARED A SEFA IN THE PAST. EFFECT: THE SEFA RQUIRED MATERIAL ADJUSTMENTS TO INCLUDE ALL FEDERAL EXPENDITURES PRIOR TO THE SINGLE AUDIT BEGINNING, WHICH RESULTED IN A MISSTATED PRELIMINARY SEFA AND INEFFICIENCIES DURING THE SINGLE AUDIT. QUESTIONED COSTS: NO COSTS HAVE BEEN QUESTIONED AS A RESULT OF THIS FINDING. RECOMMENDATION: WE RECOMMEND THAT THE HEALTH DEPARTMENT TRACT THEIR FEDERAL AWARDS MORE REGULARLY AND RECONCILE IT TO THE GENERAL LEDGER. VIEW OF RESPONSIBLE OFFICIALS: THE HEALTH DEPARTMENT WILL REVISIT THEIR PROCEDURES AND METHOD OF FEDERAL AWARDS.
Federal agency: All agencies in the SEFA Assistance Listing Number: See SEFA Award Period: 01/01/2023 to 12/31/2023 Type of Finding: Significant Deficiency in Internal Control Over Financial Reporting Criteria or Specific Requirement: 2 CFR Section C: Subpart F Audit Requirements § 200.510 Financial statements Part (b) states: The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502 – Basis for determining Federal awards expended. Condition: Adjustments to the SEFA were necessary due to the internal controls not recognizing and correcting expenditures initially reported in the SEFA provided for audit. The SEFA as presented has been adjusted and is correct. Cause: The internal preparation and review processes did not identify the misstatement of the SEFA prepared for audit purposes. Effect or potential effect: If the SEFA is misstated related to the programs and expenditures incurred for the program. This could impact the scope of the audit and therefore the federal agencies’ reliance on the audit results. In addition, inaccurate tracking of federal expenditures may prevent the Organization from identifying when an audit in accordance with Government Auditing Standards and Uniform Guidance is required. Repeat Finding: No Auditor’s Recommendation: We recommend the auditee prepare supporting documentation for the calculation of the SEFA programs and amounts. We also recommend that the supporting documentation is reviewed and agreed with the SEFA for completeness and accuracy. Finally, we recommend that the Organization include fiscal training related to Uniform Guidance if federal programs continue to be a source of revenue. Views of Responsible Officials and Planned Corrective Actions: We agree that, due to data entry errors, the SEFA provided at the start of the single audit did not include the appropriate and applicable federal expenditures. We will be more diligent in the preparation of the SEFA to help prevent the potential for inadvertently misrepresenting the total federal expenditures and avoid the necessity for adjustments to the SEFA in future audits. At the issuance of the reports, we have enhanced our internal controls and processes related to the preparation of the SEFA to prevent this situation in future years. Our goal is to eliminate any errors to ensure that all applicable federal expenditures are complete and accurate.
Federal agency: All agencies in the SEFA Assistance Listing Number: See SEFA Award Period: 01/01/2023 to 12/31/2023 Type of Finding: Significant Deficiency in Internal Control Over Financial Reporting Criteria or Specific Requirement: 2 CFR Section C: Subpart F Audit Requirements § 200.510 Financial statements Part (b) states: The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502 – Basis for determining Federal awards expended. Condition: Adjustments to the SEFA were necessary due to the internal controls not recognizing and correcting expenditures initially reported in the SEFA provided for audit. The SEFA as presented has been adjusted and is correct. Cause: The internal preparation and review processes did not identify the misstatement of the SEFA prepared for audit purposes. Effect or potential effect: If the SEFA is misstated related to the programs and expenditures incurred for the program. This could impact the scope of the audit and therefore the federal agencies’ reliance on the audit results. In addition, inaccurate tracking of federal expenditures may prevent the Organization from identifying when an audit in accordance with Government Auditing Standards and Uniform Guidance is required. Repeat Finding: No Auditor’s Recommendation: We recommend the auditee prepare supporting documentation for the calculation of the SEFA programs and amounts. We also recommend that the supporting documentation is reviewed and agreed with the SEFA for completeness and accuracy. Finally, we recommend that the Organization include fiscal training related to Uniform Guidance if federal programs continue to be a source of revenue. Views of Responsible Officials and Planned Corrective Actions: We agree that, due to data entry errors, the SEFA provided at the start of the single audit did not include the appropriate and applicable federal expenditures. We will be more diligent in the preparation of the SEFA to help prevent the potential for inadvertently misrepresenting the total federal expenditures and avoid the necessity for adjustments to the SEFA in future audits. At the issuance of the reports, we have enhanced our internal controls and processes related to the preparation of the SEFA to prevent this situation in future years. Our goal is to eliminate any errors to ensure that all applicable federal expenditures are complete and accurate.
FINDING 2023-001 Program Information: Temporary Assistance for Needy Families (ALN #93.558) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): L. Reporting- The auditee must prepare a schedule of expenditures of Federal awards (the “SEFA”) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For Research and Development (“R&D”), total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. (2) For Federal awards received as a subrecipient, the name of the passthrough entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the Assistance Listing number or other identifying number when the Assistance Listing information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in 2 CFR 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. (6) Include notes that describe that significant accounting policies used in preparing the schedule and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in 2 CFR 200.414. Condition: The SEFA as prepared by management did not originally include all expenditures for one federal grant. Cause: The Organization has a process where administrative expenses and management travel expenses are charged to a general fund code. A portion of those expenses related to the TANF program are then reclassed to the TANF fund code. We note some of those administrative and travel expenses did not get reclassed into the TANF fund code and as a result, the draft SEFA was not fully complete. Effect or Potential Effect: The original draft SEFA was incomplete. Questioned Costs: None. Context: During the process to compile and prepare the draft SEFA, certain administrative and travel costs were excluded from the draft SEFA, which resulted in the SEFA being understated by approximately $14,000. Identification as a Repeat Finding: Similar findings noted in the prior year. Recommendation: We recommend that the Alliance enhance its procedures and internal controls with respect to general ledger coding of expenses, preparation and review of the SEFA. Views of Responsible Officials and Planned Corrective Actions: Management will review SEFA for proper inclusion of all federal grant expenditures, and Alliance Director will ensure all invoices are properly coded to grants as applicable.
Federal Agency: Department of Housing and Urban Development Federal Program Title: Community Development Block Grants Assistance Listing Number: 14.228 Federal Award Identification Number and Year: B-21-DC-08-0001 2021 Pass-Through Agency: Colorado Department of Local Affairs Pass-Through Number: F20CDBG20630 Award Period: April 1, 2020 – March 31, 2024 Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or Specific Requirement: In accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles and Audit Requirements for Federal Awards (Uniform Guidance), the Council should report all federal expenditures in the schedule of expenditures of federal awards (SEFA) each fiscal year. Additionally, per 2 CFR section 200.502(a)-(d), the determination of when a federal award is expended must be based on when the activity related to the federal award occurs, including the value of new loans made during the audit period. Condition: In reviewing the expenditure detail and supporting documentation for the 2023 SEFA, the Council included $150,000 of excess federal expenditures that were not disbursed in 2023. Questioned Costs: None Context: The inclusion of excess expenditures to be reported in 2024 was identified during completeness testing of the current year major program. Cause: SEFA expenditures for the CDBG program were not reconciled to loan disbursements in 2023. Management misinterpreted the loan amount report provided by NLF’s loan management software. One loan for $150,000 was disbursed during 2023 and another $150,000 loan was disbursed to the same borrower in 2024. However, all $300,000 was initially reported on the 2023 SEFA. Effect: The 2023 SEFA was initially overstated by $150,000, and was subsequently adjusted. Repeat Finding: The finding is a repeat of a finding in the immediately prior year. Prior year finding number was 2022-003. Recommendation: We recommend that the Council record federal expenditures on the SEFA under the program in the year upon which the loan disbursement occurs using the proper report from NLF’s loan management software. Views of Responsible Officials: There is no disagreement with the audit finding.
Condition: This finding is repeated from the financial statement section. Before beginning the audit, inquiry was made of management about the amount of federal funds expended in the audit year ending December 31, 2023. Management indicated $160,000 in grant funds had been expended by forwarding an eamil from GWADD. In the course of our audit, we determined the district spent $1,764,760 in Federal loan funds, along with $6,933 in Rural Develoment grant proceeds. Managment was unable to provide evidence of proper internal controls over expenditures of Federal funds, i.e. written procedures. Criteria: 2 CFR 200.510 (b) states in part, "Schedule of expenditures of Federal awards. The auditee must also prepare a schedul of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as detrmined in accordance with 2 CFR 200.502." Effect: Failure to disclose the correct amount of federal funds expended. Cause: Failure to implement proper internal controls. Recommendation: We recommend the District implement proper internal controls over expenditures of Federal funds, including written procedures. We also recommend the District compete a schedule of expenditures of Federal awards (SEFA) in any year federal funds are expended.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
Significant Deficiency in Compliance and Internal Control over Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards). Criteria: CFR Section §200.510(b) states in part: “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with CFR Section §200.502 Basis for determining Federal awards expended.” For a cluster of programs, the schedule must provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For a cluster of programs, the total for the cluster must also be provided. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. BDO identified the following matters during our testing of the SEFA: During our testing of management’s preparation of the Schedule of Expenditures of Federal Awards (the SEFA), BDO identified 22 awards that were incorrectly classified as research and development. In each case, the federal awarding agency or pass-through entity noted in the award agreement the award was not classified or considered as research and development. Management subsequently updated the classifications on the SEFA and corrected the presentation of various programs presented as both clusters and nonclusters on the SEFA. The SEFA, as presented, includes the corrections made by management. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Any samples selected as part of the overall SEFA review were performed using a non-statistical method. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. Urban prepares the SEFA once per year in conjunction with the annual audit and did not include a procedure to properly identify research and development classification. Effect: The SEFA provided to BDO required several awards to be removed from the research and development cluster. Failure to present the SEFA correctly would have resulted in incorrect major program selection and an incorrect presentation of the overall SEFA. Repeat Finding: This is not a repeat finding. Recommendation: We recommend management continue to focus on training for both preparer and reviewers of the SEFA to ensure the identification of research and development classification from federal awarding agencies or pass-through entities is properly captured on the schedule. We suggest this review process begin before the Institute signs an award agreement to determine whether the agreement states whether it is considered to be research and development. The Institute would then be aware of the classification prior to committing to the terms of the award. This will ensure that the SEFA presents all relevant information as prescribed to ensure proper reporting on the SEFA and major program determination. Views of Responsible Officials: Management of the Institute agrees with the finding and recommendations set forth within and has developed a corrective action plan to address the instances of noncompliance identified and lapses in prescribed internal controls.
2023-001: Congressional Directives SEFA Reporting Federal Agency: Department of Health and Human Services (“HHS”), Health Resources and Services Administration (“HRSA”) Assistance Listing Program Title: Congressional Directives Federal Award Project Title: Community Project Funding/ Congressionally Directed Spending ‐ Construction Assistance Listing Number: 93.493 Federal Award Identification Numbers: CE146569, CE152406, CE152466 Criteria OMB Uniform Guidance 2 CFR 200.510(b)(3) requires that the auditee provide the Federal awards expended for each individual Federal program on the Schedule of Expenditures of Federal Awards (“SEFA”). In accordance with 2 CFR 200.502, the determination of when a Federal award is expended, and thereby reported on the SEFA, is generally based on when the activity related to the Federal award occurs. Condition The Congressional Directives grant is a cost reimbursement based grant that reimburses award recipients for expenditures incurred on projects that relate to the construction and renovation (including equipment) of health care facilities. Jamaica tracked expenditures for SEFA reporting purposes on the basis of reimbursement from the sponsor, rather than expenditures incurred by Jamaica. Request for reimbursement for this award has not been made as of the date of this report. As a result, the expenditures reported by Jamaica on its draft 2023 SEFA were understated by the entire amount of the Congressional Directive grant’s expenditures incurred in 2023. This has been corrected by management in the final SEFA included in this report. There was no impact to our audit scoping given this award was included on the final SEFA and included as a major program. Questioned Costs None Cause Jamaica did not apply the accrual basis of accounting for the Congressional Directives grant to ensure proper reporting on the SEFA. Effect The draft 2023 SEFA omitted all 2023 expenditures incurred for the Congressional Directives grant, resulting in the draft SEFA expenditures being underreported by $2,904,920. This was corrected in the final SEFA included in this report, such that major program determination and audit scoping for the 2023 audit was not impacted, however, it would have been impacted if the final SEFA was not corrected (and reported on the accrual basis of accounting for the Congressional Directives grant). Recommendation We recommend Jamaica enhance their controls around grant terms and expenditures of allowable funds under federal award agreements to determine the appropriate amounts to be accrued and reported on the annual SEFA (regardless of when cash reimbursement is requested from the granting agency). Management’s Views and Corrective Action Plan Management’s Views and Corrective Action Plan is included at the end of this report.
2023-001: Congressional Directives SEFA Reporting Federal Agency: Department of Health and Human Services (“HHS”), Health Resources and Services Administration (“HRSA”) Assistance Listing Program Title: Congressional Directives Federal Award Project Title: Community Project Funding/ Congressionally Directed Spending ‐ Construction Assistance Listing Number: 93.493 Federal Award Identification Numbers: CE146569, CE152406, CE152466 Criteria OMB Uniform Guidance 2 CFR 200.510(b)(3) requires that the auditee provide the Federal awards expended for each individual Federal program on the Schedule of Expenditures of Federal Awards (“SEFA”). In accordance with 2 CFR 200.502, the determination of when a Federal award is expended, and thereby reported on the SEFA, is generally based on when the activity related to the Federal award occurs. Condition The Congressional Directives grant is a cost reimbursement based grant that reimburses award recipients for expenditures incurred on projects that relate to the construction and renovation (including equipment) of health care facilities. Jamaica tracked expenditures for SEFA reporting purposes on the basis of reimbursement from the sponsor, rather than expenditures incurred by Jamaica. Request for reimbursement for this award has not been made as of the date of this report. As a result, the expenditures reported by Jamaica on its draft 2023 SEFA were understated by the entire amount of the Congressional Directive grant’s expenditures incurred in 2023. This has been corrected by management in the final SEFA included in this report. There was no impact to our audit scoping given this award was included on the final SEFA and included as a major program. Questioned Costs None Cause Jamaica did not apply the accrual basis of accounting for the Congressional Directives grant to ensure proper reporting on the SEFA. Effect The draft 2023 SEFA omitted all 2023 expenditures incurred for the Congressional Directives grant, resulting in the draft SEFA expenditures being underreported by $2,904,920. This was corrected in the final SEFA included in this report, such that major program determination and audit scoping for the 2023 audit was not impacted, however, it would have been impacted if the final SEFA was not corrected (and reported on the accrual basis of accounting for the Congressional Directives grant). Recommendation We recommend Jamaica enhance their controls around grant terms and expenditures of allowable funds under federal award agreements to determine the appropriate amounts to be accrued and reported on the annual SEFA (regardless of when cash reimbursement is requested from the granting agency). Management’s Views and Corrective Action Plan Management’s Views and Corrective Action Plan is included at the end of this report.
2023-001: Congressional Directives SEFA Reporting Federal Agency: Department of Health and Human Services (“HHS”), Health Resources and Services Administration (“HRSA”) Assistance Listing Program Title: Congressional Directives Federal Award Project Title: Community Project Funding/ Congressionally Directed Spending ‐ Construction Assistance Listing Number: 93.493 Federal Award Identification Numbers: CE146569, CE152406, CE152466 Criteria OMB Uniform Guidance 2 CFR 200.510(b)(3) requires that the auditee provide the Federal awards expended for each individual Federal program on the Schedule of Expenditures of Federal Awards (“SEFA”). In accordance with 2 CFR 200.502, the determination of when a Federal award is expended, and thereby reported on the SEFA, is generally based on when the activity related to the Federal award occurs. Condition The Congressional Directives grant is a cost reimbursement based grant that reimburses award recipients for expenditures incurred on projects that relate to the construction and renovation (including equipment) of health care facilities. Jamaica tracked expenditures for SEFA reporting purposes on the basis of reimbursement from the sponsor, rather than expenditures incurred by Jamaica. Request for reimbursement for this award has not been made as of the date of this report. As a result, the expenditures reported by Jamaica on its draft 2023 SEFA were understated by the entire amount of the Congressional Directive grant’s expenditures incurred in 2023. This has been corrected by management in the final SEFA included in this report. There was no impact to our audit scoping given this award was included on the final SEFA and included as a major program. Questioned Costs None Cause Jamaica did not apply the accrual basis of accounting for the Congressional Directives grant to ensure proper reporting on the SEFA. Effect The draft 2023 SEFA omitted all 2023 expenditures incurred for the Congressional Directives grant, resulting in the draft SEFA expenditures being underreported by $2,904,920. This was corrected in the final SEFA included in this report, such that major program determination and audit scoping for the 2023 audit was not impacted, however, it would have been impacted if the final SEFA was not corrected (and reported on the accrual basis of accounting for the Congressional Directives grant). Recommendation We recommend Jamaica enhance their controls around grant terms and expenditures of allowable funds under federal award agreements to determine the appropriate amounts to be accrued and reported on the annual SEFA (regardless of when cash reimbursement is requested from the granting agency). Management’s Views and Corrective Action Plan Management’s Views and Corrective Action Plan is included at the end of this report.
MATERIAL WEAKNESS IN INTERNAL CONTROL OVER COMPLIANCE – SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS 2023-003 Reporting Compliance Requirement Criteria – 2 CFR § 200.510 requires that the City prepare financial statements that reflect its financial position, results of operations or changes in net position, and, where appropriate, cash flows for the fiscal year audited, including the Schedule of Expenditures of Federal Awards (SEFA) for the year ended December 31, 2023, which must include the total federal awards expended as determined in accordance with 2 CFR § 200.502. Management is responsible for establishing and maintaining effective internal controls over compliance with requirements applicable to federal programs, including separately tracking federal expenditures within the finance system to provide for accurate preparation of the SEFA. Condition – During our audit, we noted the City did not have sufficient controls in place to ensure completeness of the SEFA and compliance with this requirement. The City’s SEFA was understated by $1,189,917 in federal expenditures related to the Highway Planning and Construction and COVID-19 – Coronavirus State and Local Fiscal Recovery Funds federal programs. Questioned Costs – Not applicable. Context – On the December 31, 2023 SEFA, $1,189,917 of $1,197,438 was initially unreported. Repeat Finding – This is a current year finding. Cause – This was an oversight by the City’s management. Effect – An incomplete SEFA could result in incorrect major program determination and could be seen as a violation of federal award agreements. Recommendation – We recommend that the City review its internal control procedures over reporting and verify completeness of expenditures reported on the SEFA in the future. View of Responsible Official and Planned Corrective Actions – The City agrees with the finding. The City has separately issued a Corrective Action Plan related to this finding.
Federal Agency U.S. Department of Health and Human Services Criteria 2 CFR section 200.303 requires that non-federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non-federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Additionally, 2 CFR section 200.510 requires the auditee to prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR section 200.502. Condition and Context In preparing the SEFA, Nemours management adjusted general ledger amounts for payroll adjustments recorded in the general ledger in fiscal year 2024 that related to fiscal year 2023 expenditures. These manual adjustments, were not material to the 2023 combined financial statements and related to correcting allocations of time and effort charged to federal grants. Through our allowability testing of payroll expenditures within the Research & Development Cluster, we determined the impact of these time and effort payroll corrections was not completely captured during the SEFA preparation process. As a result, adjustments to the SEFA were made of approximately $617,000. Possible Cause and Effect Because effort reporting changes were not timely identified and processed prior to the closing of the books and records for the fiscal year, there were payroll related changes impacting federal grants that were processed in the general ledger during 2024. As a result, management attempted to identify all of these changes and manually adjust the SEFA accordingly. Due to the manual nature of the process, a portion of the 2024 corrections which impacted the 2023 expenditures were not completely captured during the SEFA preparation process. Questioned Costs None Statistically Valid Sample Not applicable Repeat of Prior Finding No Recommendations Management should revise its process to ensure that effort reporting changes are timely identified and processed in the appropriate period. Additionally, should changes be identified subsequent to year end, the process to identify manual adjustments to the SEFA, if any, should be reviewed for completeness. View of Responsible Officials Management agrees with the noted finding. Management notes that all payroll adjustments were completed prior to reporting any final costs to the funding agencies.
Federal Agency U.S. Department of Health and Human Services Criteria 2 CFR section 200.303 requires that non-federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non-federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Additionally, 2 CFR section 200.510 requires the auditee to prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR section 200.502. Condition and Context In preparing the SEFA, Nemours management adjusted general ledger amounts for payroll adjustments recorded in the general ledger in fiscal year 2024 that related to fiscal year 2023 expenditures. These manual adjustments, were not material to the 2023 combined financial statements and related to correcting allocations of time and effort charged to federal grants. Through our allowability testing of payroll expenditures within the Research & Development Cluster, we determined the impact of these time and effort payroll corrections was not completely captured during the SEFA preparation process. As a result, adjustments to the SEFA were made of approximately $617,000. Possible Cause and Effect Because effort reporting changes were not timely identified and processed prior to the closing of the books and records for the fiscal year, there were payroll related changes impacting federal grants that were processed in the general ledger during 2024. As a result, management attempted to identify all of these changes and manually adjust the SEFA accordingly. Due to the manual nature of the process, a portion of the 2024 corrections which impacted the 2023 expenditures were not completely captured during the SEFA preparation process. Questioned Costs None Statistically Valid Sample Not applicable Repeat of Prior Finding No Recommendations Management should revise its process to ensure that effort reporting changes are timely identified and processed in the appropriate period. Additionally, should changes be identified subsequent to year end, the process to identify manual adjustments to the SEFA, if any, should be reviewed for completeness. View of Responsible Officials Management agrees with the noted finding. Management notes that all payroll adjustments were completed prior to reporting any final costs to the funding agencies.
Federal Agency U.S. Department of Health and Human Services Criteria 2 CFR section 200.303 requires that non-federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non-federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Additionally, 2 CFR section 200.510 requires the auditee to prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR section 200.502. Condition and Context In preparing the SEFA, Nemours management adjusted general ledger amounts for payroll adjustments recorded in the general ledger in fiscal year 2024 that related to fiscal year 2023 expenditures. These manual adjustments, were not material to the 2023 combined financial statements and related to correcting allocations of time and effort charged to federal grants. Through our allowability testing of payroll expenditures within the Research & Development Cluster, we determined the impact of these time and effort payroll corrections was not completely captured during the SEFA preparation process. As a result, adjustments to the SEFA were made of approximately $617,000. Possible Cause and Effect Because effort reporting changes were not timely identified and processed prior to the closing of the books and records for the fiscal year, there were payroll related changes impacting federal grants that were processed in the general ledger during 2024. As a result, management attempted to identify all of these changes and manually adjust the SEFA accordingly. Due to the manual nature of the process, a portion of the 2024 corrections which impacted the 2023 expenditures were not completely captured during the SEFA preparation process. Questioned Costs None Statistically Valid Sample Not applicable Repeat of Prior Finding No Recommendations Management should revise its process to ensure that effort reporting changes are timely identified and processed in the appropriate period. Additionally, should changes be identified subsequent to year end, the process to identify manual adjustments to the SEFA, if any, should be reviewed for completeness. View of Responsible Officials Management agrees with the noted finding. Management notes that all payroll adjustments were completed prior to reporting any final costs to the funding agencies.
Federal Agency U.S. Department of Health and Human Services Criteria 2 CFR section 200.303 requires that non-federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non-federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Additionally, 2 CFR section 200.510 requires the auditee to prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total federal awards expended as determined in accordance with 2 CFR section 200.502. Condition and Context In preparing the SEFA, Nemours management adjusted general ledger amounts for payroll adjustments recorded in the general ledger in fiscal year 2024 that related to fiscal year 2023 expenditures. These manual adjustments, were not material to the 2023 combined financial statements and related to correcting allocations of time and effort charged to federal grants. Through our allowability testing of payroll expenditures within the Research & Development Cluster, we determined the impact of these time and effort payroll corrections was not completely captured during the SEFA preparation process. As a result, adjustments to the SEFA were made of approximately $617,000. Possible Cause and Effect Because effort reporting changes were not timely identified and processed prior to the closing of the books and records for the fiscal year, there were payroll related changes impacting federal grants that were processed in the general ledger during 2024. As a result, management attempted to identify all of these changes and manually adjust the SEFA accordingly. Due to the manual nature of the process, a portion of the 2024 corrections which impacted the 2023 expenditures were not completely captured during the SEFA preparation process. Questioned Costs None Statistically Valid Sample Not applicable Repeat of Prior Finding No Recommendations Management should revise its process to ensure that effort reporting changes are timely identified and processed in the appropriate period. Additionally, should changes be identified subsequent to year end, the process to identify manual adjustments to the SEFA, if any, should be reviewed for completeness. View of Responsible Officials Management agrees with the noted finding. Management notes that all payroll adjustments were completed prior to reporting any final costs to the funding agencies.