Import f48b68ea-ead8-429e-b547-10778af10582
Download
8-09-2021 09:19 PM BRAZOS REGIONAL PUA PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
01 -GENERAL FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
01-1102 CASH, CLAIM ON POOLED 0.00 783,275.35
01-1211 TEXPOOL, BRPUA PRIMARY ACCT 0.00 530,958.93
01-1212 TEXPOOL, BRPUA RESERVE ACCT 0.00 289,142.37
01-1301 ACCOUNTS RECEIVABLE 0.00 354,667.34
01-1407 DUE FROM CAPITAL FUND 0.00 12,987.82
01-1442 RECEIVABLES, AMUD 0.00 0.09
01-1444 RECEIVABLES, JCSUD 0.00 300.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 1,971,331.90 0.00
============== ============== ============== ==============
LIABILITIES
===========
01-2107 DUE TO CAPITAL FUND 0.00 6,493.91
01-2244 CURRENT PAYABLE, JCSUD 0.00 2,126.52
01-2361 PAYROLL RETIREMENT PAYABLE 0.00 967.34
01-2371 PAYROLL INS PAYABLE, HEALTH 0.00 1,365.00
01-2373 PAYROLL INS PAYABLE, DENTAL 0.00 896.88
01-2375 PAYROLL INS PAYABLE, VISION 0.00 236.24
01-2381 PAYROLL INS PAYABLE, AD&D/LIFE 0.00 496.91
01-2383 PAYROLL INS PAYABLE, FSA 0.00 1,504.55
01-2389 PAYROLL OTHER PAYABLE 0.00 284.19
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 2,362.76 12,008.78
============== ============== ============== ==============
FUND BALANCE
============
01-3999 UNASSIGNED FUND BALANCE 0.00 511,000.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 511,000.00
============== ============== ============== ==============
REVENUES
========
01-4112 ALLOCATION OPERATIONS, AMUD 0.00 1,739,716.00
01-4114 ALLOCATION OPERATIONS, JCSUD 0.00 1,827,983.00
01-4413 MISC OPERATING REVENUE 0.00 32,819.55
01-4515 INTEREST EARNED, BRPUA 0.00 475.62
01-4915 SALE OF ASSETS 0.00 12,000.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 3,612,994.17
============== ============== ============== ==============
EXPENDITURES
============
01-5-11-5011 PERSONNEL 0.00 750,093.30
01-5-11-5021 OVERTIME 0.00 4,199.69
01-5-11-5152 CONTRIBUTED, SOCIAL SECURITY 0.00 46,982.51
01-5-11-5153 CONTRIBUTED, MEDICARE 0.00 10,987.71
8-09-2021 09:19 PM BRAZOS REGIONAL PUA PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
01 -GENERAL FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
01-5-11-5161 CONTRIBUTED, RETIREMENT 0.00 58,391.07
01-5-11-5171 CONTRIBUTED, HEALTH INS 0.00 175,108.49
01-5-11-5172 CONTRIBUTED, HRA INS 0.00 7,816.82
01-5-11-5173 CONTRIBUTED, DENTAL INS 0.00 5,489.10
01-5-11-5175 CONTRIBUTED, VISION INS 0.00 917.49
01-5-11-5181 CONTRIBUTED, AD&D & LIFE INS 0.00 3,581.40
01-5-11-5183 CONTRIBUTED, LTD INS 0.00 4,625.22
01-5-11-5191 UNEMPLOYMENT INS, TEXAS 0.00 4,498.30
01-5-11-5420 OFFICE SUPPLIES 0.00 2,181.43
01-5-11-5474 POSTAGE & DELIVERY 0.00 375.01
01-5-11-5499 OTHER MISC. SUPPLIES 0.00 1,750.02
01-5-11-5515 M&R - EQUIPMENT 0.00 1,315.77
01-5-11-5545 M&R - COMPUTERS 0.00 18,480.00
01-5-11-5547 M&R - SOFTWARE 0.00 11,449.88
01-5-11-5701 PROFESSIONAL SERVICES 0.00 34,961.17
01-5-11-5703 AUDITS 0.00 16,000.00
01-5-11-5707 LEGAL SERVICES 0.00 34,222.44
01-5-11-5710 COMMUNICATION 0.00 13,781.75
01-5-11-5720 INSURANCE, GENERAL 0.00 111,610.60
01-5-11-5741 EMPLOYEE DUES & LICENSES 0.00 451.00
01-5-11-5765 TRAINING 0.00 3,614.00
01-5-11-5767 TRAVEL 0.00 272.92
01-5-11-5771 PERMITS & FEES 0.00 7,808.05
01-5-11-5799 OTHER MISC. SERVICES 0.00 285.24
01-5-25-5210.04 CAUSTIC SODA, 25% 0.00 22,968.62
01-5-25-5210.05 CHLORINE GAS 0.00 9,410.00
01-5-25-5210.08 SODIUM CHLORITE 0.00 18,761.22
01-5-25-5210.09 CHEMFLOC 1000 0.00 29,317.73
01-5-25-5210.99 MISCELLANEOUS CHEMICALS 0.00 295.99
01-5-25-5380 UTILITY - ELECTRICITY 0.00 229,511.07
01-5-25-5415 LAB SUPPLIES 0.00 19,623.86
01-5-25-5420 OFFICE SUPPLIES 0.00 2,006.11
01-5-25-5425 SMALL TOOLS 0.00 1,674.70
01-5-25-5426 MINOR EQUIPMENT >500 & <5,000 0.00 982.07
01-5-25-5445 FUEL 0.00 9,081.23
01-5-25-5473 JANITORIAL SUPPLIES 0.00 3,183.77
01-5-25-5478 UNIFORMS 0.00 3,219.27
01-5-25-5499 OTHER MISC. SUPPLIES 0.00 4,662.83
01-5-25-5505 M&R - STRUCTURES 0.00 4,528.18
01-5-25-5510 M&R - GROUNDS 0.00 39,070.00
01-5-25-5514 M&R - PUMPS & PUMP MOTORS 0.00 15,391.68
01-5-25-5515 M&R - EQUIPMENT 0.00 50,814.74
01-5-25-5520 M&R - INSTRUMENTS 0.00 68,447.12
01-5-25-5525 M&R - VEHICLES 0.00 10,506.62
01-5-25-5547 M&R - SOFTWARE 0.00 5,763.75
01-5-25-5599 M&R - OTHER 0.00 11,047.78
01-5-25-5701 PROFESSIONAL SERVICES 0.00 1,560.00
01-5-25-5705 ENGINEERING SERVICES 0.00 34,019.68
01-5-25-5715 GARBAGE REMOVAL 0.00 7,173.59
01-5-25-5741 EMPLOYEE DUES & LICENSES 0.00 2,469.25
8-09-2021 09:19 PM BRAZOS REGIONAL PUA PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
01 -GENERAL FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
01-5-25-5765 TRAINING 0.00 4,504.00
01-5-25-5767 TRAVEL 0.00 226.12
01-5-25-5775 RENTAL OF EQUIPMENT 0.00 3,384.25
01-5-25-5781 SLUDGE HAULING / TRUCKING 0.00 5,545.00
01-5-25-5799 OTHER MISC. SERVICES 0.00 628.77
01-5-27-5210.99 MISCELLANEOUS CHEMICALS 0.00 1,305.61
01-5-27-5415 LAB SUPPLIES 0.00 13,996.57
01-5-27-5420 OFFICE SUPPLIES 0.00 1,746.81
01-5-27-5474 POSTAGE & DELIVERY 0.00 266.18
01-5-27-5478 UNIFORMS 0.00 39.96
01-5-27-5499 OTHER MISC. SUPPLIES 0.00 53.46
01-5-27-5515 M&R - EQUIPMENT 0.00 12,912.26
01-5-27-5701 PROFESSIONAL SERVICES 0.00 412.00
01-5-27-5713 LAB SERVICES 0.00 1,696.31
01-5-27-5741 EMPLOYEE DUES & LICENSES 0.00 140.00
01-5-27-5765 TRAINING 0.00 35.00
01-5-27-5799 OTHER MISC. SERVICES 0.00 98.70
01-5-28-5210.20 LIQUID AMMONIUM SULFATE 0.00 12,238.27
01-5-28-5210.24 VITEC 3000 0.00 16,404.82
01-5-28-5210.27 ASCORBIC ACID 0.00 868.06
01-5-28-5210.28 OXALIC ACID 0.00 308.64
01-5-28-5210.29 SODIUM HYPOCHLORITE 0.00 9,200.00
01-5-28-5415 LAB SUPPLIES 0.00 4,321.77
01-5-28-5425 SMALL TOOLS 0.00 1,900.72
01-5-28-5426 MINOR EQUIPMENT >500 & <5,000 0.00 81.24
01-5-28-5437 CARTRIDGE FILTERS 0.00 13,507.50
01-5-28-5473 JANITORIAL SUPPLIES 0.00 89.91
01-5-28-5478 UNIFORMS 0.00 1,212.33
01-5-28-5499 OTHER MISC. SUPPLIES 0.00 910.08
01-5-28-5505 M&R - STRUCTURES 0.00 9,938.19
01-5-28-5514 M&R - PUMPS & PUMP MOTORS 0.00 10,772.78
01-5-28-5515 M&R - EQUIPMENT 0.00 22,040.38
01-5-28-5520 M&R - INSTRUMENTS 0.00 42,324.35
01-5-28-5547 M&R - SOFTWARE 0.00 27,750.64
01-5-28-5599 M&R - OTHER 0.00 1,912.37
01-5-28-5741 EMPLOYEE DUES & LICENSES 0.00 280.00
01-5-28-5765 TRAINING 0.00 1,840.00
01-5-28-5767 TRAVEL 0.00 50.00
01-5-28-5799 OTHER MISC. SERVICES 0.00 624.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 2,162,308.29 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 4,136,002.95 4,136,002.95
============== ============== ============== ==============
*** END OF REPORT ***
8-09-2021 09:19 PM BRAZOS REGIONAL PUA PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
03 -DEBT SERVICE FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
03-1102 CASH, CLAIM ON POOLED 0.00 64,008.19
03-1214 TEXPOOL, AMUD DEBT SERVICE 0.00 103,384.55
03-1215 TEXPOOL, JCSUD DEBT SERVICE 0.00 778,520.94
03-1301 ACCOUNTS RECEIVABLE 0.00 189,168.03
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 1,135,081.71 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
03-4152 ALLOCATION DEBT SERVICE, AMUD 0.00 211,032.94
03-4154 ALLOCATION DEBT SERVICE, JCSUD 0.00 963,900.00
03-4516 INTEREST EARNED, AMUD 0.00 75.82
03-4517 INTEREST EARNED, JCSUD 0.00 35.45
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 1,175,044.21
============== ============== ============== ==============
EXPENDITURES
============
03-5-19-6522 DEBT INTEREST , AMUD 0.00 7,812.50
03-5-19-6524 DEBT INTEREST , JCSUD 0.00 31,950.00
03-5-19-6542 DEBT SERVICE , AMUD 0.00 200.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 39,962.50 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 1,175,044.21 1,175,044.21
============== ============== ============== ==============
*** END OF REPORT ***
8-09-2021 09:19 PM BRAZOS REGIONAL PUA PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
07 -CAPITAL PROJECTS FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
07-1102 CASH, CLAIM ON POOLED 0.00 150,587.82
07-1216 TEXPOOL, AMUD CAPITAL RESERVE 0.00 573,564.25
07-1219 TEXPOOL, JCSUD CAPITAL RESERVE 0.00 723,606.48
07-1301 ACCOUNTS RECEIVABLE 0.00 153,417.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 1,601,175.55 0.00
============== ============== ============== ==============
LIABILITIES
===========
07-2105 DUE TO OTHER FUNDS 0.00 12,987.82
07-2222 RETAINAGE PAYABLE 0.00 32,681.39
07-2244 CURRENT PAYABLE, JCSUD 0.00 1,063.26
07-2457 DEFERRED REVENUE 0.00 0.09
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 1,063.26 45,669.30
============== ============== ============== ==============
FUND BALANCE
============
07-3999 UNASSIGNED FUND BALANCE 0.00 648,610.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 648,610.00
============== ============== ============== ==============
REVENUES
========
07-4122 ALTERNATE MEMBRANE, AMUD 0.00 66,492.00
07-4124 ALTERNATE MEMBRANE, JCSUD 0.00 76,508.00
07-4142 ALLOCATION CAPITAL, AMUD 0.00 690,305.00
07-4144 ALLOCATION CAPITAL, JCSUD 0.00 854,278.00
07-4516 INTEREST EARNED, AMUD 0.00 286.52
07-4517 INTEREST EARNED, JCSUD 0.00 331.27
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 1,688,200.79
============== ============== ============== ==============
EXPENDITURES
============
07-5-25-5921 CAPITAL - STRUCTURES 0.00 234,030.79
07-5-25-5941 CAPITAL - EQUIPMENT 0.00 209,745.60
07-5-25-5945 CAPITAL - PUMPS 0.00 243,884.50
07-5-25-5947 CAPITAL - COMPUTERS/SOFTWARE 0.00 19,061.48
07-5-28-5931 CAPITAL - WATER PLANT 0.00 26,961.91
07-5-28-5941 CAPITAL - EQUIPMENT 0.00 28,557.00
07-5-28-5948 CAPITAL - SWATS CAPACITY REST 0.00 18,000.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 780,241.28 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 2,382,480.09 2,382,480.09
============== ============== ============== ==============
*** END OF REPORT ***
8-09-2021 09:19 PM BRAZOS REGIONAL PUA PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
11 -FIXED ASSET ACCOUNT GROUP
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
11-1911 F/A - LAND 0.00 251,873.44
11-1921 F/A - STRUCTURES 0.00 2,462,731.92
11-1929 A/D - STRUCTURES 0.00 627,169.35
11-1931 F/A - WATER TREATMENT PLANT 0.00 25,428,882.39
11-1939 A/D - WATER PLANT 0.00 5,894,362.45
11-1941 F/A - EQUIPMENT 0.00 1,413,130.62
11-1943 F/A - VEHICLES 0.00 116,148.36
11-1945 F/A - PUMPS 0.00 593,315.30
11-1947 F/A - COMPUTERS/SOFTWARE 0.00 663,571.52
11-1949 A/D - EQUIPMENT 0.00 1,239,438.93
11-1955 F/A - UF MEMBRANES 0.00 462,500.00
11-1957 F/A - RO MEMBRANES 0.00 158,110.37
11-1959 A/D - MEMBRANES 0.00 379,707.26
11-1961 CONSTRUCTION IN PROGRESS 0.00 601,951.56
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 32,152,215.48 8,140,677.99
============== ============== ============== ==============
FUND BALANCE
============
11-3911 NET INVESTED IN CAPITAL ASSETS 0.00 24,011,537.49
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 24,011,537.49
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 32,152,215.48 32,152,215.48
============== ============== ============== ==============
*** END OF REPORT ***
8-09-2021 09:19 PM BRAZOS REGIONAL PUA PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
13 -L/T DEBT ACCOUNT GROUP
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
13-1300 AMOUNT TO BE PROVIDED 0.00 2,765,686.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 2,765,686.00 0.00
============== ============== ============== ==============
LIABILITIES
===========
13-2464 CURRENT BONDS PAYABLE 0.00 1,095,000.00
13-2842 BONDS PAYABLE - AMUD 0.00 400,000.00
13-2843 PREMIUM ON BONDS - AMUD 0.00 6,832.00
13-2844 BONDS PAYABLE - JCSUD 0.00 1,230,000.00
13-2845 PREMIUM ON BONDS - JCSUD 0.00 33,854.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 0.00 2,765,686.00
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 2,765,686.00 2,765,686.00
============== ============== ============== ==============
*** END OF REPORT ***
8-09-2021 09:19 PM BRAZOS REGIONAL PUA PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
99 -POOLED CASH FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
99-1100 POOLED CASH - FFB CHECKING 0.00 778,399.50
99-1104 POOLED CASH - FFB RESERVE 0.00 219,471.86
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 997,871.36 0.00
============== ============== ============== ==============
LIABILITIES
===========
99-2105 DUE TO OTHER FUNDS 0.00 997,871.36
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 0.00 997,871.36
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 997,871.36 997,871.36
============== ============== ============== ==============
*** END OF REPORT ***