Audit 31873

FY End
2022-09-30
Total Expended
$111.71M
Findings
2
Programs
2
Year: 2022 Accepted: 2023-02-21
Auditor: Crowe LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
35516 2022-001 Material Weakness - P
611958 2022-001 Material Weakness - P

Programs

ALN Program Spent Major Findings
66.458 Capitalization Grants for Clean Water State Revolving Funds $111.68M Yes 1
66.460 Nonpoint Source Implementation Grants $8,902 - 0

Contacts

Name Title Type
GWLYHAYMS3K4 Holly Matthews Auditee
4696264375 Kevin W Smith Auditor
No contacts on file

Notes to SEFA

Title: Loan/loan guarantee outstanding balances Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards presents the activity of all federal award programs of the North Texas Municipal Water District (the "District") for the year ended September 30,2022. The District's reporting entity is defined in Note 1 of the District's Annual Comprehensive Financial Report. The accompanying notes are an integral part of this Schedule. All federal awards received directly by the primary government from federal agencies, as well as federal awards passed through other government agencies, are included in the scope of the Federal Single Audit requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) and are included on the Schedule of Expenditures of Federal Awards.The accompanying Schedule of Expenditures of Federal Awards is presented using the accrual basis of accounting. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. CAPITALIZATION GRANTS FOR CLEAN WATER STATE REVOLVING FUNDS (66.458) - Balances outstanding at the end of the audit period were 492100000.
Title: Relationship to Federal Financial Reports Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards presents the activity of all federal award programs of the North Texas Municipal Water District (the "District") for the year ended September 30,2022. The District's reporting entity is defined in Note 1 of the District's Annual Comprehensive Financial Report. The accompanying notes are an integral part of this Schedule. All federal awards received directly by the primary government from federal agencies, as well as federal awards passed through other government agencies, are included in the scope of the Federal Single Audit requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) and are included on the Schedule of Expenditures of Federal Awards.The accompanying Schedule of Expenditures of Federal Awards is presented using the accrual basis of accounting. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Grant expenditures reports as of September 30, 2022,which have been submitted to grantor agencies may differ slightly from amounts disclosed herein. The reports prepared for grantor agencies are typically prepared at a later date and often reflect estimated of year-end accruals. The reports will agree at termination of the grant as discrepancies noted are timing differences.

Finding Details

An organization should have a system of internal controls, which are sufficiently designed to allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct misstatements of the financial statements on a timely basis. An effective system of internal controls also needs to operate as designed. Formal written policies and procedures are an integral part of a system of internal controls. Such policies and procedures are established to ensure integrity over financial reporting and to safeguard assets. Significant audit adjustments were required to correct errors and improper presentation of capital asset financial information. These adjustments primarily related to agreements with third parties who also had responsibilities for the project. 1. When the District constructs assets, often they enter into interlocal agreements with other local governments whereby the other local government contributes an agreed upon amount to participate in the funding the project. In many cases the assets are owned by the District and the District has the responsibility to maintain and operate. When funds are received from participating entities, management erroneously recorded a decrease to the CIP cost basis of the asset rather than recognize the funds as contribution or nonoperating revenue. 2. The District received a reimbursement of a portion of funds the District had previously, in a prior year, contributed to a local entity in relation to a project. The previous contribution had been properly recorded as nonoperating expense. However, management incorrectly recorded the refunded amount as decrease to a CIP asset instead of recording it as an increase to nonoperating revenue. 3. A significant construction project which had primarily been placed in service, was still being carried in CIP. Upon inquiry and investigation, due to a number of unique and complex requirements in the agreement with another governmental entity, it was found to be correctly still included in CIP rather than moved to a capital asset category at this time. However, there was an initial lack of understanding of the contract milestones which will have significant impact on accounting treatment of the asset upon reaching the agreement milestones. 4. For large projects that have been completed, management's standard practice is to reclassify the majority of the project from CIP to the appropriate capital asset category once placed in service. A portion of the project which relates to the remaining retainage or accruals is left in CIP until it's paid, even though it's been placed in service, essentially using a cash basis versus accrual basis of accounting. There is no documented procedure around the review of this practice to ensure the portions of projects remaining in CIP and the related potential depreciation is immaterial to the period, nor to ensure a remaining project cost has not been overlooked in the capitalization process. Review of contracts and applicable entries, internal controls, policies and procedures were either not in place, not adequately documented, or not operating effectively or not followed.
An organization should have a system of internal controls, which are sufficiently designed to allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct misstatements of the financial statements on a timely basis. An effective system of internal controls also needs to operate as designed. Formal written policies and procedures are an integral part of a system of internal controls. Such policies and procedures are established to ensure integrity over financial reporting and to safeguard assets. Significant audit adjustments were required to correct errors and improper presentation of capital asset financial information. These adjustments primarily related to agreements with third parties who also had responsibilities for the project. 1. When the District constructs assets, often they enter into interlocal agreements with other local governments whereby the other local government contributes an agreed upon amount to participate in the funding the project. In many cases the assets are owned by the District and the District has the responsibility to maintain and operate. When funds are received from participating entities, management erroneously recorded a decrease to the CIP cost basis of the asset rather than recognize the funds as contribution or nonoperating revenue. 2. The District received a reimbursement of a portion of funds the District had previously, in a prior year, contributed to a local entity in relation to a project. The previous contribution had been properly recorded as nonoperating expense. However, management incorrectly recorded the refunded amount as decrease to a CIP asset instead of recording it as an increase to nonoperating revenue. 3. A significant construction project which had primarily been placed in service, was still being carried in CIP. Upon inquiry and investigation, due to a number of unique and complex requirements in the agreement with another governmental entity, it was found to be correctly still included in CIP rather than moved to a capital asset category at this time. However, there was an initial lack of understanding of the contract milestones which will have significant impact on accounting treatment of the asset upon reaching the agreement milestones. 4. For large projects that have been completed, management's standard practice is to reclassify the majority of the project from CIP to the appropriate capital asset category once placed in service. A portion of the project which relates to the remaining retainage or accruals is left in CIP until it's paid, even though it's been placed in service, essentially using a cash basis versus accrual basis of accounting. There is no documented procedure around the review of this practice to ensure the portions of projects remaining in CIP and the related potential depreciation is immaterial to the period, nor to ensure a remaining project cost has not been overlooked in the capitalization process. Review of contracts and applicable entries, internal controls, policies and procedures were either not in place, not adequately documented, or not operating effectively or not followed.