Audit 291508

FY End
2023-08-31
Total Expended
$1.69M
Findings
2
Programs
7
Year: 2023 Accepted: 2024-02-21

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
369991 2023-001 Significant Deficiency - P
946433 2023-001 Significant Deficiency - P

Contacts

Name Title Type
P3SZQX5CLH63 Dan Monson Auditee
9793619802 Nancy MacK Auditor
No contacts on file

Notes to SEFA

Title: GENERAL Accounting Policies: The Schedule of Revenues and Expenditures of State and Federal Awards is prepared on the modified accrual basis of accounting. The modified accrual basis of accounting is described in Note 3 of the basic financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or State of Texas Uniform Grant Management Standards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. State and federal grant funds are considered to be earned to the extent of expenditures made under the provisions of the grant, and, accordingly, when such funds are received, they are recorded as unearned revenues until earned. De Minimis Rate Used: N Rate Explanation: The Center has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidanc The Schedule of Revenues and Expenditures of State and Federal Awards presents the activity of all applicable state and federal awards of Mental Health Mental Retardation Authority of Brazos Valley (the Center). The Center's reporting entity is defined in Note 1 of the basic financial statements. State and federal awards received directly from federal and state agencies, as well as federal and state awards passed through other governmental agencies, are included on the Schedule of Revenues and Expenditures of State and Federal Awards.The information in the Schedule of Revenues and Expenditures of State and Federal Awards 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 of Revenues and Expenditures of State and Federal Awards present only a selected portion of the operations of the Center, it is not intended to and does not present the financial position, changes in financial position, or cash flows of the Center.
Title: BASIS OF ACCOUNTING Accounting Policies: The Schedule of Revenues and Expenditures of State and Federal Awards is prepared on the modified accrual basis of accounting. The modified accrual basis of accounting is described in Note 3 of the basic financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or State of Texas Uniform Grant Management Standards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. State and federal grant funds are considered to be earned to the extent of expenditures made under the provisions of the grant, and, accordingly, when such funds are received, they are recorded as unearned revenues until earned. De Minimis Rate Used: N Rate Explanation: The Center has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidanc The Schedule of Revenues and Expenditures of State and Federal Awards is prepared on the modified accrual basis of accounting. The modified accrual basis of accounting is described in Note 3 of the basic financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or State of Texas Uniform Grant Management Standards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. State and federal grant funds are considered to be earned to the extent of expenditures made under the provisions of the grant, and, accordingly, when such funds are received, they are recorded as unearned revenues until earned.
Title: RELATIONSHIP TO BASIC FINANCIAL STATEMENTS Accounting Policies: The Schedule of Revenues and Expenditures of State and Federal Awards is prepared on the modified accrual basis of accounting. The modified accrual basis of accounting is described in Note 3 of the basic financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or State of Texas Uniform Grant Management Standards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. State and federal grant funds are considered to be earned to the extent of expenditures made under the provisions of the grant, and, accordingly, when such funds are received, they are recorded as unearned revenues until earned. De Minimis Rate Used: N Rate Explanation: The Center has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidanc Certain state and federal programs have been excluded from the Schedule of Expenditures of State and Federal Awards, including monies received under vendor contract for Title XIX ICF/MR and Title XIX HCS/MR, and other Medicaid/Medicare funding earned from providing patient services. The state and federal monies excluded from the Schedule of Revenues and Expenditures of State and Federal Awards are not considered financial assistance as defined in the Uniform Guidance and are included in total local revenues in the basic financial statements. Texas Correctional Office on Offenders with Medical or Mental Impairments (TCOOMMI) and PASRR have been excluded from the Schedule of Revenues and Expenditures of State and Federal Awards as these monies are considered contracts, not state or federal awards.
Title: STATE AWARD GUIDELINES Accounting Policies: The Schedule of Revenues and Expenditures of State and Federal Awards is prepared on the modified accrual basis of accounting. The modified accrual basis of accounting is described in Note 3 of the basic financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or State of Texas Uniform Grant Management Standards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. State and federal grant funds are considered to be earned to the extent of expenditures made under the provisions of the grant, and, accordingly, when such funds are received, they are recorded as unearned revenues until earned. De Minimis Rate Used: N Rate Explanation: The Center has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidanc State awards are subject to HHSC's Guidelines for Annual Financial and Compliance Audits of Community MHMR Centers (21st Revision) as well as the Office of the Governor's State of Texas Single Audit Circular. Such guidelines are consistent with those required under the Single Audit Act of 1996, the Uniform Guidance and Government Auditing Standards, issued by the Comptroller General of the United States.
Title: INDIRECT COSTS Accounting Policies: The Schedule of Revenues and Expenditures of State and Federal Awards is prepared on the modified accrual basis of accounting. The modified accrual basis of accounting is described in Note 3 of the basic financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or State of Texas Uniform Grant Management Standards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. State and federal grant funds are considered to be earned to the extent of expenditures made under the provisions of the grant, and, accordingly, when such funds are received, they are recorded as unearned revenues until earned. De Minimis Rate Used: N Rate Explanation: The Center has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidanc The Center has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidanc
Title: IDD ARPA FUNDS Accounting Policies: The Schedule of Revenues and Expenditures of State and Federal Awards is prepared on the modified accrual basis of accounting. The modified accrual basis of accounting is described in Note 3 of the basic financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or State of Texas Uniform Grant Management Standards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. State and federal grant funds are considered to be earned to the extent of expenditures made under the provisions of the grant, and, accordingly, when such funds are received, they are recorded as unearned revenues until earned. De Minimis Rate Used: N Rate Explanation: The Center has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidanc The Center has received authorization to carryover remaining unspent IDD ARPA Funds to fiscal year 2024.

Finding Details

Condition: Certain general ledger accounts were not analyzed and reconciled on a timely basis. Criteria: Internal controls should be in place to ensure that all material general ledger accounts are critically analyzed and reconciled on a monthly or quarterly basis. Cause: The Center experienced turnover in some key accounting and IT positions. Additionally, there were new programs and an implementation of new software and current personnel are still in the process of being trained and becoming familiar with the programs. Effect: Because of the failure to have timely reconciled general ledger accounts, several adjustments had to be made during the audit process. Recommendation: The Center should continue to train existing employees on significant accounting matters and ensure that all material general ledger accounts are reconciled on a monthly basis. Views of Responsible Officials and Planned Corrective Actions: Management of the Center agrees with the finding and the recommended procedures will be implemented.
Condition: Certain general ledger accounts were not analyzed and reconciled on a timely basis. Criteria: Internal controls should be in place to ensure that all material general ledger accounts are critically analyzed and reconciled on a monthly or quarterly basis. Cause: The Center experienced turnover in some key accounting and IT positions. Additionally, there were new programs and an implementation of new software and current personnel are still in the process of being trained and becoming familiar with the programs. Effect: Because of the failure to have timely reconciled general ledger accounts, several adjustments had to be made during the audit process. Recommendation: The Center should continue to train existing employees on significant accounting matters and ensure that all material general ledger accounts are reconciled on a monthly basis. Views of Responsible Officials and Planned Corrective Actions: Management of the Center agrees with the finding and the recommended procedures will be implemented.