Audit 57267

FY End
2022-06-30
Total Expended
$5.13M
Findings
4
Programs
3
Year: 2022 Accepted: 2023-03-29

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
61701 2022-001 Material Weakness - P
61702 2022-001 Material Weakness - P
638143 2022-001 Material Weakness - P
638144 2022-001 Material Weakness - P

Programs

ALN Program Spent Major Findings
12.600 Community Investment $4.23M Yes 1
97.039 Hazard Mitigation Grant $838,903 Yes 1
10.683 National Fish and Wildlife Foundation $62,077 - 0

Contacts

Name Title Type
CKCDV2K4LVE3 Brian Zahn Auditee
8055254431 Cristy Canieda Auditor
No contacts on file

Notes to SEFA

Accounting Policies: NOTE 1BASIS FOR PRESENTATIONThe accompanying Schedule of Expenditures of Federal Awards (SEFA) summarizes the federal awards activity of United Water Conservation District (the District) under programs of the federal government for the year ended June 30, 2022. The information in the SEFA 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 SEFA presents only a selected portion of the operations of the District, it is not intended to, and does not present the financial position, changes in net assets, or cash flows of the District as of and for the year ended June 30, 2022.NOTE 2BASIS OF ACCOUNTINGExpenditures reported on the SEFA are recognized 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. The District has elected to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. NOTE 3RELATIONSHIP OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS TO THE FINANCIAL STATEMENTSConsistent with management's policy, federal awards are recorded in various revenue categories. As a result, the amount of total federal awards reported on the SEFA does not agree with total grants and contributions revenue on the Statement of Revenues, Expenses and Changes in Net position as presented in the District's audited financial statements as of and for the year ended June 30, 2022. De Minimis Rate Used: Y Rate Explanation: The auditee used the de minimis cost rate.

Finding Details

Finding No. 2022-001 ? Schedule of Expenditures of Federal Awards (SEFA) Criteria or Specific Requirement The SEFA, which is prepared by the auditee and considered supplementary information to the financial statements, is a key part of the reporting package required by the Uniform Guidance. The SEFA also serves as the primary basis that auditors use to determine which programs will be audited as part of the single audit. Therefore, the auditee?s responsibility for preparing an accurate and complete SEFA is critical. Specifically, ?200.510(b) of the Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee?s financial statements which must include the total federal awards expended as determined in accordance with ?200.502 of the Uniform Guidance, ?Basis for Determining Federal Awards Expended.? The auditee?s responsibility to prepare a complete and accurate SEFA is the foundation for a smooth audit. If the SEFA includes errors or omissions, it will surely result in audit inefficiencies, duplicate audit efforts by auditors and revision of the risk assessment process in order to determine major programs, the potential for audit restatement, and/or additional audit costs. Condition As discussed above, the SEFA is expenditure driven as opposed to revenue driven. The District initially reported the federal expenditures for ALN 12.600 - Defense Community Infrastructure Pilot program and ALN 97.039 ? Hazard Mitigation Grant program based on the federal funds received as opposed to expenditures incurred during the fiscal year 2022. The following material adjustments were made to the SEFA to comply with the Uniform Guidance: Program Name Original Reported Amount Adjustments Made Revised Expenditures ALN 12.600 ? Defense Community Infrastructure Pilot $643,635 $3,586,498 $4,230,133 ALN 97.039 ? Hazard Mitigation Grant $583,020 $255,883 $838,903 Cause and Effect The potential causes for the above errors are as follows: ? Lack of training. ? Lack of controls to ascertain that all federal expenditures are properly included in the SEFA. Questioned Costs Not applicable. Recommendation We recommend the District revisit its current SEFA preparation process and develop a detailed SEFA preparation checklist to comply with the Uniform Guidance requirements. The District should consider incorporating the SEFA preparation checklist within the monthly and year-end closing process. This will help ensure the completeness and accuracy of the SEFA and help monitor compliance with federal guidelines.
Finding No. 2022-001 ? Schedule of Expenditures of Federal Awards (SEFA) Criteria or Specific Requirement The SEFA, which is prepared by the auditee and considered supplementary information to the financial statements, is a key part of the reporting package required by the Uniform Guidance. The SEFA also serves as the primary basis that auditors use to determine which programs will be audited as part of the single audit. Therefore, the auditee?s responsibility for preparing an accurate and complete SEFA is critical. Specifically, ?200.510(b) of the Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee?s financial statements which must include the total federal awards expended as determined in accordance with ?200.502 of the Uniform Guidance, ?Basis for Determining Federal Awards Expended.? The auditee?s responsibility to prepare a complete and accurate SEFA is the foundation for a smooth audit. If the SEFA includes errors or omissions, it will surely result in audit inefficiencies, duplicate audit efforts by auditors and revision of the risk assessment process in order to determine major programs, the potential for audit restatement, and/or additional audit costs. Condition As discussed above, the SEFA is expenditure driven as opposed to revenue driven. The District initially reported the federal expenditures for ALN 12.600 - Defense Community Infrastructure Pilot program and ALN 97.039 ? Hazard Mitigation Grant program based on the federal funds received as opposed to expenditures incurred during the fiscal year 2022. The following material adjustments were made to the SEFA to comply with the Uniform Guidance: Program Name Original Reported Amount Adjustments Made Revised Expenditures ALN 12.600 ? Defense Community Infrastructure Pilot $643,635 $3,586,498 $4,230,133 ALN 97.039 ? Hazard Mitigation Grant $583,020 $255,883 $838,903 Cause and Effect The potential causes for the above errors are as follows: ? Lack of training. ? Lack of controls to ascertain that all federal expenditures are properly included in the SEFA. Questioned Costs Not applicable. Recommendation We recommend the District revisit its current SEFA preparation process and develop a detailed SEFA preparation checklist to comply with the Uniform Guidance requirements. The District should consider incorporating the SEFA preparation checklist within the monthly and year-end closing process. This will help ensure the completeness and accuracy of the SEFA and help monitor compliance with federal guidelines.
Finding No. 2022-001 ? Schedule of Expenditures of Federal Awards (SEFA) Criteria or Specific Requirement The SEFA, which is prepared by the auditee and considered supplementary information to the financial statements, is a key part of the reporting package required by the Uniform Guidance. The SEFA also serves as the primary basis that auditors use to determine which programs will be audited as part of the single audit. Therefore, the auditee?s responsibility for preparing an accurate and complete SEFA is critical. Specifically, ?200.510(b) of the Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee?s financial statements which must include the total federal awards expended as determined in accordance with ?200.502 of the Uniform Guidance, ?Basis for Determining Federal Awards Expended.? The auditee?s responsibility to prepare a complete and accurate SEFA is the foundation for a smooth audit. If the SEFA includes errors or omissions, it will surely result in audit inefficiencies, duplicate audit efforts by auditors and revision of the risk assessment process in order to determine major programs, the potential for audit restatement, and/or additional audit costs. Condition As discussed above, the SEFA is expenditure driven as opposed to revenue driven. The District initially reported the federal expenditures for ALN 12.600 - Defense Community Infrastructure Pilot program and ALN 97.039 ? Hazard Mitigation Grant program based on the federal funds received as opposed to expenditures incurred during the fiscal year 2022. The following material adjustments were made to the SEFA to comply with the Uniform Guidance: Program Name Original Reported Amount Adjustments Made Revised Expenditures ALN 12.600 ? Defense Community Infrastructure Pilot $643,635 $3,586,498 $4,230,133 ALN 97.039 ? Hazard Mitigation Grant $583,020 $255,883 $838,903 Cause and Effect The potential causes for the above errors are as follows: ? Lack of training. ? Lack of controls to ascertain that all federal expenditures are properly included in the SEFA. Questioned Costs Not applicable. Recommendation We recommend the District revisit its current SEFA preparation process and develop a detailed SEFA preparation checklist to comply with the Uniform Guidance requirements. The District should consider incorporating the SEFA preparation checklist within the monthly and year-end closing process. This will help ensure the completeness and accuracy of the SEFA and help monitor compliance with federal guidelines.
Finding No. 2022-001 ? Schedule of Expenditures of Federal Awards (SEFA) Criteria or Specific Requirement The SEFA, which is prepared by the auditee and considered supplementary information to the financial statements, is a key part of the reporting package required by the Uniform Guidance. The SEFA also serves as the primary basis that auditors use to determine which programs will be audited as part of the single audit. Therefore, the auditee?s responsibility for preparing an accurate and complete SEFA is critical. Specifically, ?200.510(b) of the Uniform Guidance requires the auditee to prepare a SEFA for the period covered by the auditee?s financial statements which must include the total federal awards expended as determined in accordance with ?200.502 of the Uniform Guidance, ?Basis for Determining Federal Awards Expended.? The auditee?s responsibility to prepare a complete and accurate SEFA is the foundation for a smooth audit. If the SEFA includes errors or omissions, it will surely result in audit inefficiencies, duplicate audit efforts by auditors and revision of the risk assessment process in order to determine major programs, the potential for audit restatement, and/or additional audit costs. Condition As discussed above, the SEFA is expenditure driven as opposed to revenue driven. The District initially reported the federal expenditures for ALN 12.600 - Defense Community Infrastructure Pilot program and ALN 97.039 ? Hazard Mitigation Grant program based on the federal funds received as opposed to expenditures incurred during the fiscal year 2022. The following material adjustments were made to the SEFA to comply with the Uniform Guidance: Program Name Original Reported Amount Adjustments Made Revised Expenditures ALN 12.600 ? Defense Community Infrastructure Pilot $643,635 $3,586,498 $4,230,133 ALN 97.039 ? Hazard Mitigation Grant $583,020 $255,883 $838,903 Cause and Effect The potential causes for the above errors are as follows: ? Lack of training. ? Lack of controls to ascertain that all federal expenditures are properly included in the SEFA. Questioned Costs Not applicable. Recommendation We recommend the District revisit its current SEFA preparation process and develop a detailed SEFA preparation checklist to comply with the Uniform Guidance requirements. The District should consider incorporating the SEFA preparation checklist within the monthly and year-end closing process. This will help ensure the completeness and accuracy of the SEFA and help monitor compliance with federal guidelines.