Audit 12080

FY End
2023-06-30
Total Expended
$1.87M
Findings
10
Programs
6
Year: 2023 Accepted: 2024-01-17

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
8808 2023-003 Significant Deficiency - J
8809 2023-004 Significant Deficiency - J
8810 2023-003 Significant Deficiency Yes L
8811 2023-003 Significant Deficiency Yes L
8812 2023-003 Significant Deficiency Yes L
585250 2023-003 Significant Deficiency - J
585251 2023-004 Significant Deficiency - J
585252 2023-003 Significant Deficiency Yes L
585253 2023-003 Significant Deficiency Yes L
585254 2023-003 Significant Deficiency Yes L

Programs

Contacts

Name Title Type
QB3WLK4ANMZ2 Lora Papchek Auditee
7016626500 Ashley Engel Auditor
No contacts on file

Notes to SEFA

Title: BASIS OF PRESENTATION Accounting Policies: Expenditures reported in the schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: Dakota Prairie Community Action Agency, Inc. has not elected the minimum indirect cost rate provided for by the Uniform Guidance, which allows for the allocation of 10% of modified total direct costs (direct salaries and wages, applicable fringe benefits, materials and supplies, services and travel). The accompanying schedule of expenditures of federal awards (the schedule) includes the federal award activity of the Dakota Prairie Community Action Agency, Inc. under programs of the federal government for the year ended June 30, 2023. The information is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the schedule presents only a selected portion of the operations of Dakota Prairie Community Action Agency, Inc., it is not intended to and does not present the financial position, changes in net assets, or cash flows of Dakota Prairie Community Action Agency, Inc.
Title: FINANCIAL STATEMENT RECONCILIATION Accounting Policies: Expenditures reported in the schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: Dakota Prairie Community Action Agency, Inc. has not elected the minimum indirect cost rate provided for by the Uniform Guidance, which allows for the allocation of 10% of modified total direct costs (direct salaries and wages, applicable fringe benefits, materials and supplies, services and travel). Government grant review per the Statement of Activities for the year ended June 30, 2023 has been reconciled to the total federal expenditures per the Schedule of Expenditures of Federal Awards as follows: "See the Notes to the SEFA for chart/table"

Finding Details

Information on Federal Program: U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program (passed through the North Dakota Division of Community Services, # 4570-LIHEAP19- 30, 4773-LIHEAP20-30, and 4995-LIHEAP21-30) U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program – Emergency Furnace Repair (passed through the North Dakota Division of Community Services, Award #4780-LIHEAPEF20-30, 4988-LIHEAPEF21-30, 5131- LIHEAPEF22-30, 5055-LIHEAPEF-ARPA-30) AL# 93.568 U.S. Department of Energy - Weatherization Assistance for Low-Income Persons (passed through the North Dakota Division of Community Services, Award # 5073-DOE22-30) AL# 81.042 Criteria – Section 200.507 (b) (2) of the Uniform Guidance requires that the auditee prepare the schedule of expenditure of federal awards (SEFA). Internal controls should be adequately designed and implemented to allow for the accurate and timely preparation of the SEFA. Condition – For the year ended June 30, 2023, we reconciled the auditee prepared SEFA to underlying general ledger amounts and other records. In doing this, we noted that the expenditures were misstated. Cause – Internal controls are not designed to allow for the reconciliation of fund expenses to grant awards. Effect or Potential Effect – As the entity’s auditors, we were requested to assist in the preparation of the SEFA and required notes. Questioned Costs – None noted. Context – The auditee-prepared SEFA listed expenditures for the entire grant award regardless of the fiscal year and all expenses incurred after the grant funds were exhausted. Repeat Finding – This is a repeat finding of 2022-003 from the prior year. Recommendation – The entity should pull the internal fund income statements by fiscal year and reconcile to the grant awards on a regular basis.
Information on Federal Programs U.S. Department of Energy - Weatherization Assistance for Low-Income Persons (passed through the North Dakota Division of Community Services, Award # 5073-DOE22-30) AL# 81.042 Criteria – Section 2 CFR sections 200.320(a) and (b) of the Uniform Guidance requires that the auditee following specific guidelines for selection of vendors in excess of the micro-purchase threshold which includes maintaining documentation related to their rationale for selections and agreement for goods and services to be provided. Condition – For the year ended June 30, 2023, we requested the entities documentation supporting rationale for a selection of vendors and signed contracts for expenditures in excess of the micro-purchase threshold. In a sample of 11 vendors selected for testing, one vendor did not have proper documentation rationale for selection and a signed contract. Cause – Internal controls are not designed to allow for the appropriate retention of documentation to support that appropriate procurement standards have been met. Effect or Potential Effect – Federal expenditures may be paid to vendors that are not in compliance with procurement standards under Uniform Guidance. Questioned Costs – Undeterminable Context – The vendor selected for testing was a long-standing relationship and while appropriate documentation may have been obtained at the start of the agreement, it was not maintained for the year under audit. Repeat Finding – This is a new finding. Recommendation – The entity should review their list of vendors to determine which fall under the Procurement, Suspension and Debarment standards and obtain any additional missing support or contracts to establish compliance.
Information on Federal Program: U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program (passed through the North Dakota Division of Community Services, # 4570-LIHEAP19- 30, 4773-LIHEAP20-30, and 4995-LIHEAP21-30) U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program – Emergency Furnace Repair (passed through the North Dakota Division of Community Services, Award #4780-LIHEAPEF20-30, 4988-LIHEAPEF21-30, 5131- LIHEAPEF22-30, 5055-LIHEAPEF-ARPA-30) AL# 93.568 U.S. Department of Energy - Weatherization Assistance for Low-Income Persons (passed through the North Dakota Division of Community Services, Award # 5073-DOE22-30) AL# 81.042 Criteria – Section 200.507 (b) (2) of the Uniform Guidance requires that the auditee prepare the schedule of expenditure of federal awards (SEFA). Internal controls should be adequately designed and implemented to allow for the accurate and timely preparation of the SEFA. Condition – For the year ended June 30, 2023, we reconciled the auditee prepared SEFA to underlying general ledger amounts and other records. In doing this, we noted that the expenditures were misstated. Cause – Internal controls are not designed to allow for the reconciliation of fund expenses to grant awards. Effect or Potential Effect – As the entity’s auditors, we were requested to assist in the preparation of the SEFA and required notes. Questioned Costs – None noted. Context – The auditee-prepared SEFA listed expenditures for the entire grant award regardless of the fiscal year and all expenses incurred after the grant funds were exhausted. Repeat Finding – This is a repeat finding of 2022-003 from the prior year. Recommendation – The entity should pull the internal fund income statements by fiscal year and reconcile to the grant awards on a regular basis.
Information on Federal Program: U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program (passed through the North Dakota Division of Community Services, # 4570-LIHEAP19- 30, 4773-LIHEAP20-30, and 4995-LIHEAP21-30) U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program – Emergency Furnace Repair (passed through the North Dakota Division of Community Services, Award #4780-LIHEAPEF20-30, 4988-LIHEAPEF21-30, 5131- LIHEAPEF22-30, 5055-LIHEAPEF-ARPA-30) AL# 93.568 U.S. Department of Energy - Weatherization Assistance for Low-Income Persons (passed through the North Dakota Division of Community Services, Award # 5073-DOE22-30) AL# 81.042 Criteria – Section 200.507 (b) (2) of the Uniform Guidance requires that the auditee prepare the schedule of expenditure of federal awards (SEFA). Internal controls should be adequately designed and implemented to allow for the accurate and timely preparation of the SEFA. Condition – For the year ended June 30, 2023, we reconciled the auditee prepared SEFA to underlying general ledger amounts and other records. In doing this, we noted that the expenditures were misstated. Cause – Internal controls are not designed to allow for the reconciliation of fund expenses to grant awards. Effect or Potential Effect – As the entity’s auditors, we were requested to assist in the preparation of the SEFA and required notes. Questioned Costs – None noted. Context – The auditee-prepared SEFA listed expenditures for the entire grant award regardless of the fiscal year and all expenses incurred after the grant funds were exhausted. Repeat Finding – This is a repeat finding of 2022-003 from the prior year. Recommendation – The entity should pull the internal fund income statements by fiscal year and reconcile to the grant awards on a regular basis.
Information on Federal Program: U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program (passed through the North Dakota Division of Community Services, # 4570-LIHEAP19- 30, 4773-LIHEAP20-30, and 4995-LIHEAP21-30) U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program – Emergency Furnace Repair (passed through the North Dakota Division of Community Services, Award #4780-LIHEAPEF20-30, 4988-LIHEAPEF21-30, 5131- LIHEAPEF22-30, 5055-LIHEAPEF-ARPA-30) AL# 93.568 U.S. Department of Energy - Weatherization Assistance for Low-Income Persons (passed through the North Dakota Division of Community Services, Award # 5073-DOE22-30) AL# 81.042 Criteria – Section 200.507 (b) (2) of the Uniform Guidance requires that the auditee prepare the schedule of expenditure of federal awards (SEFA). Internal controls should be adequately designed and implemented to allow for the accurate and timely preparation of the SEFA. Condition – For the year ended June 30, 2023, we reconciled the auditee prepared SEFA to underlying general ledger amounts and other records. In doing this, we noted that the expenditures were misstated. Cause – Internal controls are not designed to allow for the reconciliation of fund expenses to grant awards. Effect or Potential Effect – As the entity’s auditors, we were requested to assist in the preparation of the SEFA and required notes. Questioned Costs – None noted. Context – The auditee-prepared SEFA listed expenditures for the entire grant award regardless of the fiscal year and all expenses incurred after the grant funds were exhausted. Repeat Finding – This is a repeat finding of 2022-003 from the prior year. Recommendation – The entity should pull the internal fund income statements by fiscal year and reconcile to the grant awards on a regular basis.
Information on Federal Program: U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program (passed through the North Dakota Division of Community Services, # 4570-LIHEAP19- 30, 4773-LIHEAP20-30, and 4995-LIHEAP21-30) U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program – Emergency Furnace Repair (passed through the North Dakota Division of Community Services, Award #4780-LIHEAPEF20-30, 4988-LIHEAPEF21-30, 5131- LIHEAPEF22-30, 5055-LIHEAPEF-ARPA-30) AL# 93.568 U.S. Department of Energy - Weatherization Assistance for Low-Income Persons (passed through the North Dakota Division of Community Services, Award # 5073-DOE22-30) AL# 81.042 Criteria – Section 200.507 (b) (2) of the Uniform Guidance requires that the auditee prepare the schedule of expenditure of federal awards (SEFA). Internal controls should be adequately designed and implemented to allow for the accurate and timely preparation of the SEFA. Condition – For the year ended June 30, 2023, we reconciled the auditee prepared SEFA to underlying general ledger amounts and other records. In doing this, we noted that the expenditures were misstated. Cause – Internal controls are not designed to allow for the reconciliation of fund expenses to grant awards. Effect or Potential Effect – As the entity’s auditors, we were requested to assist in the preparation of the SEFA and required notes. Questioned Costs – None noted. Context – The auditee-prepared SEFA listed expenditures for the entire grant award regardless of the fiscal year and all expenses incurred after the grant funds were exhausted. Repeat Finding – This is a repeat finding of 2022-003 from the prior year. Recommendation – The entity should pull the internal fund income statements by fiscal year and reconcile to the grant awards on a regular basis.
Information on Federal Programs U.S. Department of Energy - Weatherization Assistance for Low-Income Persons (passed through the North Dakota Division of Community Services, Award # 5073-DOE22-30) AL# 81.042 Criteria – Section 2 CFR sections 200.320(a) and (b) of the Uniform Guidance requires that the auditee following specific guidelines for selection of vendors in excess of the micro-purchase threshold which includes maintaining documentation related to their rationale for selections and agreement for goods and services to be provided. Condition – For the year ended June 30, 2023, we requested the entities documentation supporting rationale for a selection of vendors and signed contracts for expenditures in excess of the micro-purchase threshold. In a sample of 11 vendors selected for testing, one vendor did not have proper documentation rationale for selection and a signed contract. Cause – Internal controls are not designed to allow for the appropriate retention of documentation to support that appropriate procurement standards have been met. Effect or Potential Effect – Federal expenditures may be paid to vendors that are not in compliance with procurement standards under Uniform Guidance. Questioned Costs – Undeterminable Context – The vendor selected for testing was a long-standing relationship and while appropriate documentation may have been obtained at the start of the agreement, it was not maintained for the year under audit. Repeat Finding – This is a new finding. Recommendation – The entity should review their list of vendors to determine which fall under the Procurement, Suspension and Debarment standards and obtain any additional missing support or contracts to establish compliance.
Information on Federal Program: U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program (passed through the North Dakota Division of Community Services, # 4570-LIHEAP19- 30, 4773-LIHEAP20-30, and 4995-LIHEAP21-30) U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program – Emergency Furnace Repair (passed through the North Dakota Division of Community Services, Award #4780-LIHEAPEF20-30, 4988-LIHEAPEF21-30, 5131- LIHEAPEF22-30, 5055-LIHEAPEF-ARPA-30) AL# 93.568 U.S. Department of Energy - Weatherization Assistance for Low-Income Persons (passed through the North Dakota Division of Community Services, Award # 5073-DOE22-30) AL# 81.042 Criteria – Section 200.507 (b) (2) of the Uniform Guidance requires that the auditee prepare the schedule of expenditure of federal awards (SEFA). Internal controls should be adequately designed and implemented to allow for the accurate and timely preparation of the SEFA. Condition – For the year ended June 30, 2023, we reconciled the auditee prepared SEFA to underlying general ledger amounts and other records. In doing this, we noted that the expenditures were misstated. Cause – Internal controls are not designed to allow for the reconciliation of fund expenses to grant awards. Effect or Potential Effect – As the entity’s auditors, we were requested to assist in the preparation of the SEFA and required notes. Questioned Costs – None noted. Context – The auditee-prepared SEFA listed expenditures for the entire grant award regardless of the fiscal year and all expenses incurred after the grant funds were exhausted. Repeat Finding – This is a repeat finding of 2022-003 from the prior year. Recommendation – The entity should pull the internal fund income statements by fiscal year and reconcile to the grant awards on a regular basis.
Information on Federal Program: U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program (passed through the North Dakota Division of Community Services, # 4570-LIHEAP19- 30, 4773-LIHEAP20-30, and 4995-LIHEAP21-30) U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program – Emergency Furnace Repair (passed through the North Dakota Division of Community Services, Award #4780-LIHEAPEF20-30, 4988-LIHEAPEF21-30, 5131- LIHEAPEF22-30, 5055-LIHEAPEF-ARPA-30) AL# 93.568 U.S. Department of Energy - Weatherization Assistance for Low-Income Persons (passed through the North Dakota Division of Community Services, Award # 5073-DOE22-30) AL# 81.042 Criteria – Section 200.507 (b) (2) of the Uniform Guidance requires that the auditee prepare the schedule of expenditure of federal awards (SEFA). Internal controls should be adequately designed and implemented to allow for the accurate and timely preparation of the SEFA. Condition – For the year ended June 30, 2023, we reconciled the auditee prepared SEFA to underlying general ledger amounts and other records. In doing this, we noted that the expenditures were misstated. Cause – Internal controls are not designed to allow for the reconciliation of fund expenses to grant awards. Effect or Potential Effect – As the entity’s auditors, we were requested to assist in the preparation of the SEFA and required notes. Questioned Costs – None noted. Context – The auditee-prepared SEFA listed expenditures for the entire grant award regardless of the fiscal year and all expenses incurred after the grant funds were exhausted. Repeat Finding – This is a repeat finding of 2022-003 from the prior year. Recommendation – The entity should pull the internal fund income statements by fiscal year and reconcile to the grant awards on a regular basis.
Information on Federal Program: U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program (passed through the North Dakota Division of Community Services, # 4570-LIHEAP19- 30, 4773-LIHEAP20-30, and 4995-LIHEAP21-30) U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program – Emergency Furnace Repair (passed through the North Dakota Division of Community Services, Award #4780-LIHEAPEF20-30, 4988-LIHEAPEF21-30, 5131- LIHEAPEF22-30, 5055-LIHEAPEF-ARPA-30) AL# 93.568 U.S. Department of Energy - Weatherization Assistance for Low-Income Persons (passed through the North Dakota Division of Community Services, Award # 5073-DOE22-30) AL# 81.042 Criteria – Section 200.507 (b) (2) of the Uniform Guidance requires that the auditee prepare the schedule of expenditure of federal awards (SEFA). Internal controls should be adequately designed and implemented to allow for the accurate and timely preparation of the SEFA. Condition – For the year ended June 30, 2023, we reconciled the auditee prepared SEFA to underlying general ledger amounts and other records. In doing this, we noted that the expenditures were misstated. Cause – Internal controls are not designed to allow for the reconciliation of fund expenses to grant awards. Effect or Potential Effect – As the entity’s auditors, we were requested to assist in the preparation of the SEFA and required notes. Questioned Costs – None noted. Context – The auditee-prepared SEFA listed expenditures for the entire grant award regardless of the fiscal year and all expenses incurred after the grant funds were exhausted. Repeat Finding – This is a repeat finding of 2022-003 from the prior year. Recommendation – The entity should pull the internal fund income statements by fiscal year and reconcile to the grant awards on a regular basis.