Audit 29562

FY End
2022-06-30
Total Expended
$1.17M
Findings
8
Programs
6
Organization: Health Partners Initiative (NE)
Year: 2022 Accepted: 2023-01-29
Auditor: Hbe LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
33377 2022-001 Significant Deficiency Yes AB
33378 2022-002 Significant Deficiency Yes L
33379 2022-001 Significant Deficiency Yes AB
33380 2022-002 Significant Deficiency Yes L
609819 2022-001 Significant Deficiency Yes AB
609820 2022-002 Significant Deficiency Yes L
609821 2022-001 Significant Deficiency Yes AB
609822 2022-002 Significant Deficiency Yes L

Contacts

Name Title Type
UJPHHHUFL4L9 Robert Rauner Auditee
4024309940 Krystal Siebrandt Auditor
No contacts on file

Notes to SEFA

Accounting Policies: Basis of Presentation. The accompanying schedule of federal awards includes the federal grant activity of Health Partners Initiative dba Partnership for a Healthy Lincoln, Partnership for a Healthy Nebraska, and Nebraska Breastfeeding Coalition and is presented on the accrual basis of accounting. Grant awards are considered expended when the expense transactions associated with the grant occur. The information in this schedule is presented in accordance with the requirements of the Uniform Guidance. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in preparation of, the financial statements.Subrecipients. The Organization provided federal awards to subrecipients as presented in the schedule. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.

Finding Details

2022-001 - Significant Deficiency in Internal Controls over Compliance for Allowable Costs Identification data: U.S. Department of Health and Human Services (HHS) ? Centers for Disease Control and Prevention (CDC), PPHF: Racial and Ethnic Approaches to Community Health Program finance solely by Public Prevention and Health Funds, Assistance Listing No. 93.738, Agreement Identifying No. 18NU58DP006575 and 18NU58DP006575C5. Criteria: The Organization's agreements with the CDC provide for allowable costs to be claimed for eligible program activities, including payroll-related expenses for program and administrative personnel. Condition: The Organization provides for the allocation of program and administrative personnel costs to the program on the basis of time and effort. Inconsistencies and weaknesses in the methodology and documentation supporting such allocations were identified, including the lack of audit trail documentation that connects time study results with allocation determinations utilized within the Organization?s accounting system. Additionally, the Organization does not have a formal method for determining whether allocations based on estimated time and effort reflect actual results. Cause: A breakdown in the Organization?s internal controls over allowable costs did not allow the Organization to maintain complete and thorough documentation to support allocations of salaries costs to the program. Effect or potential effect: The control deficiency is a significant deficiency that prevented the Organization from maintaining sufficient documentation to support salary cost allocations to the program. Identification of a Repeat Finding: Repeat finding of 2021-001. Recommendation: The Organization should review its system of internal controls over allowable costs, specifically related to allocation methods for payroll-related costs, to determine improvements that can be made to ensure the Organization is maintaining sufficient, complete, and clear documentation to support its allocation methodologies. Additionally, if the Organization utilizes estimates of time and effort in its allocations, a look-back review should be performed to determine appropriateness of such estimates compared to actual results. Time study data, if utilized, should be performed on a routine basis to mitigate risks of inaccuracies. Views of Responsible Officials: The Organization updated their time study evaluations in response to the last single audit to increase the frequency of time study evaluations. However, because of the timing of the last audit being completed in the second quarter of the Organization?s fiscal year, it was found the first quarter of the fiscal year did not reflect the updated procedures. In response to the audit recommendation to increase in the frequency and formality of the time study evaluation and audit trail documentation, the Organization has adopted a more frequent schedule to consistently evaluate staff time through formally documented time study evaluations and will regularly adjust charged salary allocations to ensure a clear connection between time study results and allocation of costs within the Organization?s accounting system.
2022-002 - Noncompliance and Significant Deficiency in Internal Controls over Compliance for Reporting Identification data: U.S. Department of Health and Human Services (HHS) ? Centers for Disease Control and Prevention (CDC), PPHF: Racial and Ethnic Approaches to Community Health Program finance solely by Public Prevention and Health Funds, Assistance Listing No. 93.738, Agreement Identifying No. 18NU58DP006575 and 18NU58DP006575C5. Criteria: Appendix A to Part 170 of Title 2 CFR, Subtitle A, Chapter 1 describes the first-tier subaward reporting requirements under the Federal Funding Accountability and Transparency Act (FFATA), which requires prime recipients to report first-tier subawards to non-Federal entities equal to or exceeding $30,000 within 30 days. Condition: The Organization failed to report its first-tier subawards subject to FFATA requirements within the 30 day period. Cause: A breakdown in the Organization?s internal controls over reporting did not allow the Organization to meet the reporting requirements of the program. Effect or potential effect: The control deficiency is a significant deficiency that prevented the Organization from complying with the reporting requirements of the program. Identification of a Repeat Finding: Repeat finding of 2021-002. Recommendation: The Organization should review its system of internal controls over reporting to determine improvements that can be made to ensure the Organization actively tracks and adheres to reporting requirements outlined in its award agreements and included in the CFR. Views of Responsible Officials: The Organization was not able to gain login access to process the required FFATA first-tier subawards reporting timely. Accurate and functioning access to the FSRS system has since been obtained, calendar reminders have been set and a central reporting schedule has been established to ensure better monitoring of and compliance with reporting requirements of award agreements. The Organization has reviewed FFATA reporting requirements and has adopted a procedure to ensure such reporting is completed as required.
2022-001 - Significant Deficiency in Internal Controls over Compliance for Allowable Costs Identification data: U.S. Department of Health and Human Services (HHS) ? Centers for Disease Control and Prevention (CDC), PPHF: Racial and Ethnic Approaches to Community Health Program finance solely by Public Prevention and Health Funds, Assistance Listing No. 93.738, Agreement Identifying No. 18NU58DP006575 and 18NU58DP006575C5. Criteria: The Organization's agreements with the CDC provide for allowable costs to be claimed for eligible program activities, including payroll-related expenses for program and administrative personnel. Condition: The Organization provides for the allocation of program and administrative personnel costs to the program on the basis of time and effort. Inconsistencies and weaknesses in the methodology and documentation supporting such allocations were identified, including the lack of audit trail documentation that connects time study results with allocation determinations utilized within the Organization?s accounting system. Additionally, the Organization does not have a formal method for determining whether allocations based on estimated time and effort reflect actual results. Cause: A breakdown in the Organization?s internal controls over allowable costs did not allow the Organization to maintain complete and thorough documentation to support allocations of salaries costs to the program. Effect or potential effect: The control deficiency is a significant deficiency that prevented the Organization from maintaining sufficient documentation to support salary cost allocations to the program. Identification of a Repeat Finding: Repeat finding of 2021-001. Recommendation: The Organization should review its system of internal controls over allowable costs, specifically related to allocation methods for payroll-related costs, to determine improvements that can be made to ensure the Organization is maintaining sufficient, complete, and clear documentation to support its allocation methodologies. Additionally, if the Organization utilizes estimates of time and effort in its allocations, a look-back review should be performed to determine appropriateness of such estimates compared to actual results. Time study data, if utilized, should be performed on a routine basis to mitigate risks of inaccuracies. Views of Responsible Officials: The Organization updated their time study evaluations in response to the last single audit to increase the frequency of time study evaluations. However, because of the timing of the last audit being completed in the second quarter of the Organization?s fiscal year, it was found the first quarter of the fiscal year did not reflect the updated procedures. In response to the audit recommendation to increase in the frequency and formality of the time study evaluation and audit trail documentation, the Organization has adopted a more frequent schedule to consistently evaluate staff time through formally documented time study evaluations and will regularly adjust charged salary allocations to ensure a clear connection between time study results and allocation of costs within the Organization?s accounting system.
2022-002 - Noncompliance and Significant Deficiency in Internal Controls over Compliance for Reporting Identification data: U.S. Department of Health and Human Services (HHS) ? Centers for Disease Control and Prevention (CDC), PPHF: Racial and Ethnic Approaches to Community Health Program finance solely by Public Prevention and Health Funds, Assistance Listing No. 93.738, Agreement Identifying No. 18NU58DP006575 and 18NU58DP006575C5. Criteria: Appendix A to Part 170 of Title 2 CFR, Subtitle A, Chapter 1 describes the first-tier subaward reporting requirements under the Federal Funding Accountability and Transparency Act (FFATA), which requires prime recipients to report first-tier subawards to non-Federal entities equal to or exceeding $30,000 within 30 days. Condition: The Organization failed to report its first-tier subawards subject to FFATA requirements within the 30 day period. Cause: A breakdown in the Organization?s internal controls over reporting did not allow the Organization to meet the reporting requirements of the program. Effect or potential effect: The control deficiency is a significant deficiency that prevented the Organization from complying with the reporting requirements of the program. Identification of a Repeat Finding: Repeat finding of 2021-002. Recommendation: The Organization should review its system of internal controls over reporting to determine improvements that can be made to ensure the Organization actively tracks and adheres to reporting requirements outlined in its award agreements and included in the CFR. Views of Responsible Officials: The Organization was not able to gain login access to process the required FFATA first-tier subawards reporting timely. Accurate and functioning access to the FSRS system has since been obtained, calendar reminders have been set and a central reporting schedule has been established to ensure better monitoring of and compliance with reporting requirements of award agreements. The Organization has reviewed FFATA reporting requirements and has adopted a procedure to ensure such reporting is completed as required.
2022-001 - Significant Deficiency in Internal Controls over Compliance for Allowable Costs Identification data: U.S. Department of Health and Human Services (HHS) ? Centers for Disease Control and Prevention (CDC), PPHF: Racial and Ethnic Approaches to Community Health Program finance solely by Public Prevention and Health Funds, Assistance Listing No. 93.738, Agreement Identifying No. 18NU58DP006575 and 18NU58DP006575C5. Criteria: The Organization's agreements with the CDC provide for allowable costs to be claimed for eligible program activities, including payroll-related expenses for program and administrative personnel. Condition: The Organization provides for the allocation of program and administrative personnel costs to the program on the basis of time and effort. Inconsistencies and weaknesses in the methodology and documentation supporting such allocations were identified, including the lack of audit trail documentation that connects time study results with allocation determinations utilized within the Organization?s accounting system. Additionally, the Organization does not have a formal method for determining whether allocations based on estimated time and effort reflect actual results. Cause: A breakdown in the Organization?s internal controls over allowable costs did not allow the Organization to maintain complete and thorough documentation to support allocations of salaries costs to the program. Effect or potential effect: The control deficiency is a significant deficiency that prevented the Organization from maintaining sufficient documentation to support salary cost allocations to the program. Identification of a Repeat Finding: Repeat finding of 2021-001. Recommendation: The Organization should review its system of internal controls over allowable costs, specifically related to allocation methods for payroll-related costs, to determine improvements that can be made to ensure the Organization is maintaining sufficient, complete, and clear documentation to support its allocation methodologies. Additionally, if the Organization utilizes estimates of time and effort in its allocations, a look-back review should be performed to determine appropriateness of such estimates compared to actual results. Time study data, if utilized, should be performed on a routine basis to mitigate risks of inaccuracies. Views of Responsible Officials: The Organization updated their time study evaluations in response to the last single audit to increase the frequency of time study evaluations. However, because of the timing of the last audit being completed in the second quarter of the Organization?s fiscal year, it was found the first quarter of the fiscal year did not reflect the updated procedures. In response to the audit recommendation to increase in the frequency and formality of the time study evaluation and audit trail documentation, the Organization has adopted a more frequent schedule to consistently evaluate staff time through formally documented time study evaluations and will regularly adjust charged salary allocations to ensure a clear connection between time study results and allocation of costs within the Organization?s accounting system.
2022-002 - Noncompliance and Significant Deficiency in Internal Controls over Compliance for Reporting Identification data: U.S. Department of Health and Human Services (HHS) ? Centers for Disease Control and Prevention (CDC), PPHF: Racial and Ethnic Approaches to Community Health Program finance solely by Public Prevention and Health Funds, Assistance Listing No. 93.738, Agreement Identifying No. 18NU58DP006575 and 18NU58DP006575C5. Criteria: Appendix A to Part 170 of Title 2 CFR, Subtitle A, Chapter 1 describes the first-tier subaward reporting requirements under the Federal Funding Accountability and Transparency Act (FFATA), which requires prime recipients to report first-tier subawards to non-Federal entities equal to or exceeding $30,000 within 30 days. Condition: The Organization failed to report its first-tier subawards subject to FFATA requirements within the 30 day period. Cause: A breakdown in the Organization?s internal controls over reporting did not allow the Organization to meet the reporting requirements of the program. Effect or potential effect: The control deficiency is a significant deficiency that prevented the Organization from complying with the reporting requirements of the program. Identification of a Repeat Finding: Repeat finding of 2021-002. Recommendation: The Organization should review its system of internal controls over reporting to determine improvements that can be made to ensure the Organization actively tracks and adheres to reporting requirements outlined in its award agreements and included in the CFR. Views of Responsible Officials: The Organization was not able to gain login access to process the required FFATA first-tier subawards reporting timely. Accurate and functioning access to the FSRS system has since been obtained, calendar reminders have been set and a central reporting schedule has been established to ensure better monitoring of and compliance with reporting requirements of award agreements. The Organization has reviewed FFATA reporting requirements and has adopted a procedure to ensure such reporting is completed as required.
2022-001 - Significant Deficiency in Internal Controls over Compliance for Allowable Costs Identification data: U.S. Department of Health and Human Services (HHS) ? Centers for Disease Control and Prevention (CDC), PPHF: Racial and Ethnic Approaches to Community Health Program finance solely by Public Prevention and Health Funds, Assistance Listing No. 93.738, Agreement Identifying No. 18NU58DP006575 and 18NU58DP006575C5. Criteria: The Organization's agreements with the CDC provide for allowable costs to be claimed for eligible program activities, including payroll-related expenses for program and administrative personnel. Condition: The Organization provides for the allocation of program and administrative personnel costs to the program on the basis of time and effort. Inconsistencies and weaknesses in the methodology and documentation supporting such allocations were identified, including the lack of audit trail documentation that connects time study results with allocation determinations utilized within the Organization?s accounting system. Additionally, the Organization does not have a formal method for determining whether allocations based on estimated time and effort reflect actual results. Cause: A breakdown in the Organization?s internal controls over allowable costs did not allow the Organization to maintain complete and thorough documentation to support allocations of salaries costs to the program. Effect or potential effect: The control deficiency is a significant deficiency that prevented the Organization from maintaining sufficient documentation to support salary cost allocations to the program. Identification of a Repeat Finding: Repeat finding of 2021-001. Recommendation: The Organization should review its system of internal controls over allowable costs, specifically related to allocation methods for payroll-related costs, to determine improvements that can be made to ensure the Organization is maintaining sufficient, complete, and clear documentation to support its allocation methodologies. Additionally, if the Organization utilizes estimates of time and effort in its allocations, a look-back review should be performed to determine appropriateness of such estimates compared to actual results. Time study data, if utilized, should be performed on a routine basis to mitigate risks of inaccuracies. Views of Responsible Officials: The Organization updated their time study evaluations in response to the last single audit to increase the frequency of time study evaluations. However, because of the timing of the last audit being completed in the second quarter of the Organization?s fiscal year, it was found the first quarter of the fiscal year did not reflect the updated procedures. In response to the audit recommendation to increase in the frequency and formality of the time study evaluation and audit trail documentation, the Organization has adopted a more frequent schedule to consistently evaluate staff time through formally documented time study evaluations and will regularly adjust charged salary allocations to ensure a clear connection between time study results and allocation of costs within the Organization?s accounting system.
2022-002 - Noncompliance and Significant Deficiency in Internal Controls over Compliance for Reporting Identification data: U.S. Department of Health and Human Services (HHS) ? Centers for Disease Control and Prevention (CDC), PPHF: Racial and Ethnic Approaches to Community Health Program finance solely by Public Prevention and Health Funds, Assistance Listing No. 93.738, Agreement Identifying No. 18NU58DP006575 and 18NU58DP006575C5. Criteria: Appendix A to Part 170 of Title 2 CFR, Subtitle A, Chapter 1 describes the first-tier subaward reporting requirements under the Federal Funding Accountability and Transparency Act (FFATA), which requires prime recipients to report first-tier subawards to non-Federal entities equal to or exceeding $30,000 within 30 days. Condition: The Organization failed to report its first-tier subawards subject to FFATA requirements within the 30 day period. Cause: A breakdown in the Organization?s internal controls over reporting did not allow the Organization to meet the reporting requirements of the program. Effect or potential effect: The control deficiency is a significant deficiency that prevented the Organization from complying with the reporting requirements of the program. Identification of a Repeat Finding: Repeat finding of 2021-002. Recommendation: The Organization should review its system of internal controls over reporting to determine improvements that can be made to ensure the Organization actively tracks and adheres to reporting requirements outlined in its award agreements and included in the CFR. Views of Responsible Officials: The Organization was not able to gain login access to process the required FFATA first-tier subawards reporting timely. Accurate and functioning access to the FSRS system has since been obtained, calendar reminders have been set and a central reporting schedule has been established to ensure better monitoring of and compliance with reporting requirements of award agreements. The Organization has reviewed FFATA reporting requirements and has adopted a procedure to ensure such reporting is completed as required.