Audit 1649

FY End
2022-06-30
Total Expended
$2.33M
Findings
16
Programs
18
Year: 2022 Accepted: 2023-10-27

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
871 2022-003 Significant Deficiency Yes N
872 2022-004 Significant Deficiency Yes L
873 2022-003 Significant Deficiency Yes N
874 2022-004 Significant Deficiency Yes L
875 2022-003 Significant Deficiency Yes N
876 2022-004 Significant Deficiency Yes L
877 2022-003 Significant Deficiency Yes N
878 2022-004 Significant Deficiency Yes L
577313 2022-003 Significant Deficiency Yes N
577314 2022-004 Significant Deficiency Yes L
577315 2022-003 Significant Deficiency Yes N
577316 2022-004 Significant Deficiency Yes L
577317 2022-003 Significant Deficiency Yes N
577318 2022-004 Significant Deficiency Yes L
577319 2022-003 Significant Deficiency Yes N
577320 2022-004 Significant Deficiency Yes L

Contacts

Name Title Type
MNA2NDEVH5W9 Kay Pedery Auditee
5035059724 Gerard Deblois Auditor
No contacts on file

Notes to SEFA

Accounting Policies: The accompanying schedule of expenditures of federal awards (the schedule) includes all federal grant activity of Native American Youth and Family Center under programs of the federal government for the year ended June 30, 2022. The information in this schedule is presented in accordance with the requirements of the 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 Native American Youth and Family Center, it is not intended to and does not present the financial position, changes in net assets or cash flows of Native American Youth and Family Center.Expenditures reported on the schedule are reported on the accrual basis of accounting. Such expenditures are recognized following cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: Native American Youth and Family Center has an agreed upon indirect cost rate and has not elected to use the 10 percent de minimis indirect cost rate as allowed under the Uniform Guidance.

Finding Details

Type: Federal Award, Significant Deficiency, Controls over Schedule of Expenditures of Federal Awards (SEFA) Assistance Listing Number: U.S. Department of Housing 14.218 Community Development Block Grant U.S. Department of Treasury 21.019 Coronavirus Relief Fund Criteria/Requirement: The Organization’s accounting system should clearly identify federal expenditures with minimal adjustments in accordance with 2 CFR 200.302. Condition/Context: The Organization did not identify all federal awards and significant audit adjustments were required to the SEFA prepared by management. Cause: The Organization received additional funding due to COVID-19 increasing the complexities of tracking by specific components of the award. A significant portion of the tracking is maintained in manual spreadsheets outside of the accounting system. Effect: Total expenditures by federal funding source may not be properly reported and Uniform Guidance reporting may be inaccurate. Questioned Costs: None. Recommendation: The Organization should implement additional procedures and controls to accurately capture all activity under federal awards in preparing the SEFA. Management’s Response: The Organization experienced disruption due to COVID-19 that had impacts on capacity. New contracts and source of funding are now being identified and recorded in the accounting system.
Type: Federal Award, Significant Deficiency, Noncompliance over Reporting CFDA Number: U.S. Department of Housing 14.218 Community Development Block Grant U.S. Department of Treasury 21.019 Coronavirus Relief Fund Criteria/Requirement: Quarterly and annual reports should be prepared, reviewed, and timely submitted to funding agencies. Condition/Context: Certain Quarterly and annual reporting were not reviewed and/or submitted; two out of two reports tested for 14.218 were submitted timely; however, no record of review prior to submission was provided. Final report for 21.019 program was not submitted. Cause: There was no control in place to monitor completion and document review and submission of the required reports. Effect: Reports may be inaccurate and not submitted timely to agencies. Questioned Costs: None. Recommendation: Controls, such as a calendar tracker, should be implemented to monitor timely completion and submission of required reports. In addition, there should be a documented review of the report data before submission. Management's Response: The Organization will fully utilize the spreadsheet /database that is in place with key federal contract requirements and deadlines. This document will be reviewed monthly by the program and finance team to ensure reports and submitted on a timely basis. Additional tools will be utilized to facilitate roles and responsibilities and reporting requirements.
Type: Federal Award, Significant Deficiency, Controls over Schedule of Expenditures of Federal Awards (SEFA) Assistance Listing Number: U.S. Department of Housing 14.218 Community Development Block Grant U.S. Department of Treasury 21.019 Coronavirus Relief Fund Criteria/Requirement: The Organization’s accounting system should clearly identify federal expenditures with minimal adjustments in accordance with 2 CFR 200.302. Condition/Context: The Organization did not identify all federal awards and significant audit adjustments were required to the SEFA prepared by management. Cause: The Organization received additional funding due to COVID-19 increasing the complexities of tracking by specific components of the award. A significant portion of the tracking is maintained in manual spreadsheets outside of the accounting system. Effect: Total expenditures by federal funding source may not be properly reported and Uniform Guidance reporting may be inaccurate. Questioned Costs: None. Recommendation: The Organization should implement additional procedures and controls to accurately capture all activity under federal awards in preparing the SEFA. Management’s Response: The Organization experienced disruption due to COVID-19 that had impacts on capacity. New contracts and source of funding are now being identified and recorded in the accounting system.
Type: Federal Award, Significant Deficiency, Noncompliance over Reporting CFDA Number: U.S. Department of Housing 14.218 Community Development Block Grant U.S. Department of Treasury 21.019 Coronavirus Relief Fund Criteria/Requirement: Quarterly and annual reports should be prepared, reviewed, and timely submitted to funding agencies. Condition/Context: Certain Quarterly and annual reporting were not reviewed and/or submitted; two out of two reports tested for 14.218 were submitted timely; however, no record of review prior to submission was provided. Final report for 21.019 program was not submitted. Cause: There was no control in place to monitor completion and document review and submission of the required reports. Effect: Reports may be inaccurate and not submitted timely to agencies. Questioned Costs: None. Recommendation: Controls, such as a calendar tracker, should be implemented to monitor timely completion and submission of required reports. In addition, there should be a documented review of the report data before submission. Management's Response: The Organization will fully utilize the spreadsheet /database that is in place with key federal contract requirements and deadlines. This document will be reviewed monthly by the program and finance team to ensure reports and submitted on a timely basis. Additional tools will be utilized to facilitate roles and responsibilities and reporting requirements.
Type: Federal Award, Significant Deficiency, Controls over Schedule of Expenditures of Federal Awards (SEFA) Assistance Listing Number: U.S. Department of Housing 14.218 Community Development Block Grant U.S. Department of Treasury 21.019 Coronavirus Relief Fund Criteria/Requirement: The Organization’s accounting system should clearly identify federal expenditures with minimal adjustments in accordance with 2 CFR 200.302. Condition/Context: The Organization did not identify all federal awards and significant audit adjustments were required to the SEFA prepared by management. Cause: The Organization received additional funding due to COVID-19 increasing the complexities of tracking by specific components of the award. A significant portion of the tracking is maintained in manual spreadsheets outside of the accounting system. Effect: Total expenditures by federal funding source may not be properly reported and Uniform Guidance reporting may be inaccurate. Questioned Costs: None. Recommendation: The Organization should implement additional procedures and controls to accurately capture all activity under federal awards in preparing the SEFA. Management’s Response: The Organization experienced disruption due to COVID-19 that had impacts on capacity. New contracts and source of funding are now being identified and recorded in the accounting system.
Type: Federal Award, Significant Deficiency, Noncompliance over Reporting CFDA Number: U.S. Department of Housing 14.218 Community Development Block Grant U.S. Department of Treasury 21.019 Coronavirus Relief Fund Criteria/Requirement: Quarterly and annual reports should be prepared, reviewed, and timely submitted to funding agencies. Condition/Context: Certain Quarterly and annual reporting were not reviewed and/or submitted; two out of two reports tested for 14.218 were submitted timely; however, no record of review prior to submission was provided. Final report for 21.019 program was not submitted. Cause: There was no control in place to monitor completion and document review and submission of the required reports. Effect: Reports may be inaccurate and not submitted timely to agencies. Questioned Costs: None. Recommendation: Controls, such as a calendar tracker, should be implemented to monitor timely completion and submission of required reports. In addition, there should be a documented review of the report data before submission. Management's Response: The Organization will fully utilize the spreadsheet /database that is in place with key federal contract requirements and deadlines. This document will be reviewed monthly by the program and finance team to ensure reports and submitted on a timely basis. Additional tools will be utilized to facilitate roles and responsibilities and reporting requirements.
Type: Federal Award, Significant Deficiency, Controls over Schedule of Expenditures of Federal Awards (SEFA) Assistance Listing Number: U.S. Department of Housing 14.218 Community Development Block Grant U.S. Department of Treasury 21.019 Coronavirus Relief Fund Criteria/Requirement: The Organization’s accounting system should clearly identify federal expenditures with minimal adjustments in accordance with 2 CFR 200.302. Condition/Context: The Organization did not identify all federal awards and significant audit adjustments were required to the SEFA prepared by management. Cause: The Organization received additional funding due to COVID-19 increasing the complexities of tracking by specific components of the award. A significant portion of the tracking is maintained in manual spreadsheets outside of the accounting system. Effect: Total expenditures by federal funding source may not be properly reported and Uniform Guidance reporting may be inaccurate. Questioned Costs: None. Recommendation: The Organization should implement additional procedures and controls to accurately capture all activity under federal awards in preparing the SEFA. Management’s Response: The Organization experienced disruption due to COVID-19 that had impacts on capacity. New contracts and source of funding are now being identified and recorded in the accounting system.
Type: Federal Award, Significant Deficiency, Noncompliance over Reporting CFDA Number: U.S. Department of Housing 14.218 Community Development Block Grant U.S. Department of Treasury 21.019 Coronavirus Relief Fund Criteria/Requirement: Quarterly and annual reports should be prepared, reviewed, and timely submitted to funding agencies. Condition/Context: Certain Quarterly and annual reporting were not reviewed and/or submitted; two out of two reports tested for 14.218 were submitted timely; however, no record of review prior to submission was provided. Final report for 21.019 program was not submitted. Cause: There was no control in place to monitor completion and document review and submission of the required reports. Effect: Reports may be inaccurate and not submitted timely to agencies. Questioned Costs: None. Recommendation: Controls, such as a calendar tracker, should be implemented to monitor timely completion and submission of required reports. In addition, there should be a documented review of the report data before submission. Management's Response: The Organization will fully utilize the spreadsheet /database that is in place with key federal contract requirements and deadlines. This document will be reviewed monthly by the program and finance team to ensure reports and submitted on a timely basis. Additional tools will be utilized to facilitate roles and responsibilities and reporting requirements.
Type: Federal Award, Significant Deficiency, Controls over Schedule of Expenditures of Federal Awards (SEFA) Assistance Listing Number: U.S. Department of Housing 14.218 Community Development Block Grant U.S. Department of Treasury 21.019 Coronavirus Relief Fund Criteria/Requirement: The Organization’s accounting system should clearly identify federal expenditures with minimal adjustments in accordance with 2 CFR 200.302. Condition/Context: The Organization did not identify all federal awards and significant audit adjustments were required to the SEFA prepared by management. Cause: The Organization received additional funding due to COVID-19 increasing the complexities of tracking by specific components of the award. A significant portion of the tracking is maintained in manual spreadsheets outside of the accounting system. Effect: Total expenditures by federal funding source may not be properly reported and Uniform Guidance reporting may be inaccurate. Questioned Costs: None. Recommendation: The Organization should implement additional procedures and controls to accurately capture all activity under federal awards in preparing the SEFA. Management’s Response: The Organization experienced disruption due to COVID-19 that had impacts on capacity. New contracts and source of funding are now being identified and recorded in the accounting system.
Type: Federal Award, Significant Deficiency, Noncompliance over Reporting CFDA Number: U.S. Department of Housing 14.218 Community Development Block Grant U.S. Department of Treasury 21.019 Coronavirus Relief Fund Criteria/Requirement: Quarterly and annual reports should be prepared, reviewed, and timely submitted to funding agencies. Condition/Context: Certain Quarterly and annual reporting were not reviewed and/or submitted; two out of two reports tested for 14.218 were submitted timely; however, no record of review prior to submission was provided. Final report for 21.019 program was not submitted. Cause: There was no control in place to monitor completion and document review and submission of the required reports. Effect: Reports may be inaccurate and not submitted timely to agencies. Questioned Costs: None. Recommendation: Controls, such as a calendar tracker, should be implemented to monitor timely completion and submission of required reports. In addition, there should be a documented review of the report data before submission. Management's Response: The Organization will fully utilize the spreadsheet /database that is in place with key federal contract requirements and deadlines. This document will be reviewed monthly by the program and finance team to ensure reports and submitted on a timely basis. Additional tools will be utilized to facilitate roles and responsibilities and reporting requirements.
Type: Federal Award, Significant Deficiency, Controls over Schedule of Expenditures of Federal Awards (SEFA) Assistance Listing Number: U.S. Department of Housing 14.218 Community Development Block Grant U.S. Department of Treasury 21.019 Coronavirus Relief Fund Criteria/Requirement: The Organization’s accounting system should clearly identify federal expenditures with minimal adjustments in accordance with 2 CFR 200.302. Condition/Context: The Organization did not identify all federal awards and significant audit adjustments were required to the SEFA prepared by management. Cause: The Organization received additional funding due to COVID-19 increasing the complexities of tracking by specific components of the award. A significant portion of the tracking is maintained in manual spreadsheets outside of the accounting system. Effect: Total expenditures by federal funding source may not be properly reported and Uniform Guidance reporting may be inaccurate. Questioned Costs: None. Recommendation: The Organization should implement additional procedures and controls to accurately capture all activity under federal awards in preparing the SEFA. Management’s Response: The Organization experienced disruption due to COVID-19 that had impacts on capacity. New contracts and source of funding are now being identified and recorded in the accounting system.
Type: Federal Award, Significant Deficiency, Noncompliance over Reporting CFDA Number: U.S. Department of Housing 14.218 Community Development Block Grant U.S. Department of Treasury 21.019 Coronavirus Relief Fund Criteria/Requirement: Quarterly and annual reports should be prepared, reviewed, and timely submitted to funding agencies. Condition/Context: Certain Quarterly and annual reporting were not reviewed and/or submitted; two out of two reports tested for 14.218 were submitted timely; however, no record of review prior to submission was provided. Final report for 21.019 program was not submitted. Cause: There was no control in place to monitor completion and document review and submission of the required reports. Effect: Reports may be inaccurate and not submitted timely to agencies. Questioned Costs: None. Recommendation: Controls, such as a calendar tracker, should be implemented to monitor timely completion and submission of required reports. In addition, there should be a documented review of the report data before submission. Management's Response: The Organization will fully utilize the spreadsheet /database that is in place with key federal contract requirements and deadlines. This document will be reviewed monthly by the program and finance team to ensure reports and submitted on a timely basis. Additional tools will be utilized to facilitate roles and responsibilities and reporting requirements.
Type: Federal Award, Significant Deficiency, Controls over Schedule of Expenditures of Federal Awards (SEFA) Assistance Listing Number: U.S. Department of Housing 14.218 Community Development Block Grant U.S. Department of Treasury 21.019 Coronavirus Relief Fund Criteria/Requirement: The Organization’s accounting system should clearly identify federal expenditures with minimal adjustments in accordance with 2 CFR 200.302. Condition/Context: The Organization did not identify all federal awards and significant audit adjustments were required to the SEFA prepared by management. Cause: The Organization received additional funding due to COVID-19 increasing the complexities of tracking by specific components of the award. A significant portion of the tracking is maintained in manual spreadsheets outside of the accounting system. Effect: Total expenditures by federal funding source may not be properly reported and Uniform Guidance reporting may be inaccurate. Questioned Costs: None. Recommendation: The Organization should implement additional procedures and controls to accurately capture all activity under federal awards in preparing the SEFA. Management’s Response: The Organization experienced disruption due to COVID-19 that had impacts on capacity. New contracts and source of funding are now being identified and recorded in the accounting system.
Type: Federal Award, Significant Deficiency, Noncompliance over Reporting CFDA Number: U.S. Department of Housing 14.218 Community Development Block Grant U.S. Department of Treasury 21.019 Coronavirus Relief Fund Criteria/Requirement: Quarterly and annual reports should be prepared, reviewed, and timely submitted to funding agencies. Condition/Context: Certain Quarterly and annual reporting were not reviewed and/or submitted; two out of two reports tested for 14.218 were submitted timely; however, no record of review prior to submission was provided. Final report for 21.019 program was not submitted. Cause: There was no control in place to monitor completion and document review and submission of the required reports. Effect: Reports may be inaccurate and not submitted timely to agencies. Questioned Costs: None. Recommendation: Controls, such as a calendar tracker, should be implemented to monitor timely completion and submission of required reports. In addition, there should be a documented review of the report data before submission. Management's Response: The Organization will fully utilize the spreadsheet /database that is in place with key federal contract requirements and deadlines. This document will be reviewed monthly by the program and finance team to ensure reports and submitted on a timely basis. Additional tools will be utilized to facilitate roles and responsibilities and reporting requirements.
Type: Federal Award, Significant Deficiency, Controls over Schedule of Expenditures of Federal Awards (SEFA) Assistance Listing Number: U.S. Department of Housing 14.218 Community Development Block Grant U.S. Department of Treasury 21.019 Coronavirus Relief Fund Criteria/Requirement: The Organization’s accounting system should clearly identify federal expenditures with minimal adjustments in accordance with 2 CFR 200.302. Condition/Context: The Organization did not identify all federal awards and significant audit adjustments were required to the SEFA prepared by management. Cause: The Organization received additional funding due to COVID-19 increasing the complexities of tracking by specific components of the award. A significant portion of the tracking is maintained in manual spreadsheets outside of the accounting system. Effect: Total expenditures by federal funding source may not be properly reported and Uniform Guidance reporting may be inaccurate. Questioned Costs: None. Recommendation: The Organization should implement additional procedures and controls to accurately capture all activity under federal awards in preparing the SEFA. Management’s Response: The Organization experienced disruption due to COVID-19 that had impacts on capacity. New contracts and source of funding are now being identified and recorded in the accounting system.
Type: Federal Award, Significant Deficiency, Noncompliance over Reporting CFDA Number: U.S. Department of Housing 14.218 Community Development Block Grant U.S. Department of Treasury 21.019 Coronavirus Relief Fund Criteria/Requirement: Quarterly and annual reports should be prepared, reviewed, and timely submitted to funding agencies. Condition/Context: Certain Quarterly and annual reporting were not reviewed and/or submitted; two out of two reports tested for 14.218 were submitted timely; however, no record of review prior to submission was provided. Final report for 21.019 program was not submitted. Cause: There was no control in place to monitor completion and document review and submission of the required reports. Effect: Reports may be inaccurate and not submitted timely to agencies. Questioned Costs: None. Recommendation: Controls, such as a calendar tracker, should be implemented to monitor timely completion and submission of required reports. In addition, there should be a documented review of the report data before submission. Management's Response: The Organization will fully utilize the spreadsheet /database that is in place with key federal contract requirements and deadlines. This document will be reviewed monthly by the program and finance team to ensure reports and submitted on a timely basis. Additional tools will be utilized to facilitate roles and responsibilities and reporting requirements.