Audit 332161

FY End
2024-06-30
Total Expended
$1.92M
Findings
12
Programs
6
Year: 2024 Accepted: 2024-12-12

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
513960 2024-003 Significant Deficiency Yes L
513961 2024-003 Significant Deficiency Yes L
513962 2024-003 Significant Deficiency Yes L
513963 2024-004 Significant Deficiency - B
513964 2024-004 Significant Deficiency - B
513965 2024-004 Significant Deficiency - B
1090402 2024-003 Significant Deficiency Yes L
1090403 2024-003 Significant Deficiency Yes L
1090404 2024-003 Significant Deficiency Yes L
1090405 2024-004 Significant Deficiency - B
1090406 2024-004 Significant Deficiency - B
1090407 2024-004 Significant Deficiency - B

Programs

Contacts

Name Title Type
QB3WLK4ANMZ2 Lora Papachek 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, 2024. 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 RECONCILATION 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, 2024 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 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, # 4995-LIHEAP21- 30, 5138-LIHEAP-ARPA-30, and 5195-LIHEAP23-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 #5131-LIHEAPEF22-30 and 5055-LIHEAPEF-ARPA-30) AL# 93.568 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, 2024, 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 2023-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, # 4995-LIHEAP21- 30, 5138-LIHEAP-ARPA-30, and 5195-LIHEAP23-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 #5131-LIHEAPEF22-30 and 5055-LIHEAPEF-ARPA-30) AL# 93.568 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, 2024, 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 2023-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, # 4995-LIHEAP21- 30, 5138-LIHEAP-ARPA-30, and 5195-LIHEAP23-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 #5131-LIHEAPEF22-30 and 5055-LIHEAPEF-ARPA-30) AL# 93.568 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, 2024, 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 2023-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 Health and Human Services – Low-Income Home Energy Assistance Program (passed through the North Dakota Division of Community Services, # 4995-LIHEAP21- 30, 5138-LIHEAP-ARPA-30, and 5195-LIHEAP23-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 #5131-LIHEAPEF22-30 and 5055-LIHEAPEF-ARPA-30) AL# 93.568 Criteria – Section 2 CFR sections 200.303 requires that the auditee establish and maintain internal control over federal awards to provide reasonable assurance that the auditee is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of federal awards. Condition – For the year ended June 30, 2024, we requested supporting documentation to test the review and approval of a sample of costs charged to the LIHEAP grant. In a sample of 60 expenditures, we noted one instance where a journal entry which allocated expenses to the grant was not approved. Cause – Internal controls were updated mid-year to require the review of all journal entries charged to and reimbursed under federal grants. Effect or Potential Effect – Federal expenditures may not be in accordance with the allowable cost/cost principles standards under Uniform Guidance. Questioned Costs – Undeterminable Context – The expenditure selected for testing was a journal entry allocated costs but occurred prior to the change in the internal control requiring review of all journal entries. Repeat Finding – This is a new finding. Recommendation – The auditee should review all journal entries that were charged to federal grants and approve retroactively and document in a memo. Any errors noted should be correcting with the appropriate granting agencies.
Information on Federal Programs U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program (passed through the North Dakota Division of Community Services, # 4995-LIHEAP21- 30, 5138-LIHEAP-ARPA-30, and 5195-LIHEAP23-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 #5131-LIHEAPEF22-30 and 5055-LIHEAPEF-ARPA-30) AL# 93.568 Criteria – Section 2 CFR sections 200.303 requires that the auditee establish and maintain internal control over federal awards to provide reasonable assurance that the auditee is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of federal awards. Condition – For the year ended June 30, 2024, we requested supporting documentation to test the review and approval of a sample of costs charged to the LIHEAP grant. In a sample of 60 expenditures, we noted one instance where a journal entry which allocated expenses to the grant was not approved. Cause – Internal controls were updated mid-year to require the review of all journal entries charged to and reimbursed under federal grants. Effect or Potential Effect – Federal expenditures may not be in accordance with the allowable cost/cost principles standards under Uniform Guidance. Questioned Costs – Undeterminable Context – The expenditure selected for testing was a journal entry allocated costs but occurred prior to the change in the internal control requiring review of all journal entries. Repeat Finding – This is a new finding. Recommendation – The auditee should review all journal entries that were charged to federal grants and approve retroactively and document in a memo. Any errors noted should be correcting with the appropriate granting agencies.
Information on Federal Programs U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program (passed through the North Dakota Division of Community Services, # 4995-LIHEAP21- 30, 5138-LIHEAP-ARPA-30, and 5195-LIHEAP23-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 #5131-LIHEAPEF22-30 and 5055-LIHEAPEF-ARPA-30) AL# 93.568 Criteria – Section 2 CFR sections 200.303 requires that the auditee establish and maintain internal control over federal awards to provide reasonable assurance that the auditee is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of federal awards. Condition – For the year ended June 30, 2024, we requested supporting documentation to test the review and approval of a sample of costs charged to the LIHEAP grant. In a sample of 60 expenditures, we noted one instance where a journal entry which allocated expenses to the grant was not approved. Cause – Internal controls were updated mid-year to require the review of all journal entries charged to and reimbursed under federal grants. Effect or Potential Effect – Federal expenditures may not be in accordance with the allowable cost/cost principles standards under Uniform Guidance. Questioned Costs – Undeterminable Context – The expenditure selected for testing was a journal entry allocated costs but occurred prior to the change in the internal control requiring review of all journal entries. Repeat Finding – This is a new finding. Recommendation – The auditee should review all journal entries that were charged to federal grants and approve retroactively and document in a memo. Any errors noted should be correcting with the appropriate granting agencies.
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, # 4995-LIHEAP21- 30, 5138-LIHEAP-ARPA-30, and 5195-LIHEAP23-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 #5131-LIHEAPEF22-30 and 5055-LIHEAPEF-ARPA-30) AL# 93.568 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, 2024, 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 2023-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, # 4995-LIHEAP21- 30, 5138-LIHEAP-ARPA-30, and 5195-LIHEAP23-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 #5131-LIHEAPEF22-30 and 5055-LIHEAPEF-ARPA-30) AL# 93.568 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, 2024, 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 2023-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, # 4995-LIHEAP21- 30, 5138-LIHEAP-ARPA-30, and 5195-LIHEAP23-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 #5131-LIHEAPEF22-30 and 5055-LIHEAPEF-ARPA-30) AL# 93.568 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, 2024, 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 2023-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 Health and Human Services – Low-Income Home Energy Assistance Program (passed through the North Dakota Division of Community Services, # 4995-LIHEAP21- 30, 5138-LIHEAP-ARPA-30, and 5195-LIHEAP23-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 #5131-LIHEAPEF22-30 and 5055-LIHEAPEF-ARPA-30) AL# 93.568 Criteria – Section 2 CFR sections 200.303 requires that the auditee establish and maintain internal control over federal awards to provide reasonable assurance that the auditee is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of federal awards. Condition – For the year ended June 30, 2024, we requested supporting documentation to test the review and approval of a sample of costs charged to the LIHEAP grant. In a sample of 60 expenditures, we noted one instance where a journal entry which allocated expenses to the grant was not approved. Cause – Internal controls were updated mid-year to require the review of all journal entries charged to and reimbursed under federal grants. Effect or Potential Effect – Federal expenditures may not be in accordance with the allowable cost/cost principles standards under Uniform Guidance. Questioned Costs – Undeterminable Context – The expenditure selected for testing was a journal entry allocated costs but occurred prior to the change in the internal control requiring review of all journal entries. Repeat Finding – This is a new finding. Recommendation – The auditee should review all journal entries that were charged to federal grants and approve retroactively and document in a memo. Any errors noted should be correcting with the appropriate granting agencies.
Information on Federal Programs U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program (passed through the North Dakota Division of Community Services, # 4995-LIHEAP21- 30, 5138-LIHEAP-ARPA-30, and 5195-LIHEAP23-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 #5131-LIHEAPEF22-30 and 5055-LIHEAPEF-ARPA-30) AL# 93.568 Criteria – Section 2 CFR sections 200.303 requires that the auditee establish and maintain internal control over federal awards to provide reasonable assurance that the auditee is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of federal awards. Condition – For the year ended June 30, 2024, we requested supporting documentation to test the review and approval of a sample of costs charged to the LIHEAP grant. In a sample of 60 expenditures, we noted one instance where a journal entry which allocated expenses to the grant was not approved. Cause – Internal controls were updated mid-year to require the review of all journal entries charged to and reimbursed under federal grants. Effect or Potential Effect – Federal expenditures may not be in accordance with the allowable cost/cost principles standards under Uniform Guidance. Questioned Costs – Undeterminable Context – The expenditure selected for testing was a journal entry allocated costs but occurred prior to the change in the internal control requiring review of all journal entries. Repeat Finding – This is a new finding. Recommendation – The auditee should review all journal entries that were charged to federal grants and approve retroactively and document in a memo. Any errors noted should be correcting with the appropriate granting agencies.
Information on Federal Programs U.S. Department of Health and Human Services – Low-Income Home Energy Assistance Program (passed through the North Dakota Division of Community Services, # 4995-LIHEAP21- 30, 5138-LIHEAP-ARPA-30, and 5195-LIHEAP23-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 #5131-LIHEAPEF22-30 and 5055-LIHEAPEF-ARPA-30) AL# 93.568 Criteria – Section 2 CFR sections 200.303 requires that the auditee establish and maintain internal control over federal awards to provide reasonable assurance that the auditee is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of federal awards. Condition – For the year ended June 30, 2024, we requested supporting documentation to test the review and approval of a sample of costs charged to the LIHEAP grant. In a sample of 60 expenditures, we noted one instance where a journal entry which allocated expenses to the grant was not approved. Cause – Internal controls were updated mid-year to require the review of all journal entries charged to and reimbursed under federal grants. Effect or Potential Effect – Federal expenditures may not be in accordance with the allowable cost/cost principles standards under Uniform Guidance. Questioned Costs – Undeterminable Context – The expenditure selected for testing was a journal entry allocated costs but occurred prior to the change in the internal control requiring review of all journal entries. Repeat Finding – This is a new finding. Recommendation – The auditee should review all journal entries that were charged to federal grants and approve retroactively and document in a memo. Any errors noted should be correcting with the appropriate granting agencies.