Import ba0c4edf-3570-4a3f-bf66-b8ec2c423a2a
Download
10-25-2022 09:54 AM BRAZOS REGIONAL PUA PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
01 -GENERAL FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
01-1102 CASH, CLAIM ON POOLED 24,217.51 1,208,610.40
01-1211 TEXPOOL, BRPUA PRIMARY ACCT 398.61 201,407.51
01-1212 TEXPOOL, BRPUA RESERVE ACCT 1,019.04 514,909.11
01-1301 ACCOUNTS RECEIVABLE 0.00 15,691.17
01-1504 PREPAID EXPENSES 794.64 15,682.95
______________ ______________ ______________ ______________
TOTAL ASSETS 25,635.16 794.64 1,956,301.14 0.00
============== ============== ============== ==============
LIABILITIES
===========
01-2205 ACCOUNTS PAYABLE 32,540.98 10,921.62
01-2371 PAYROLL INS PAYABLE, HEALTH 368.57 0.00
01-2373 PAYROLL INS PAYABLE, DENTAL 517.27 0.00
01-2375 PAYROLL INS PAYABLE, VISION 16.19 0.00
01-2381 PAYROLL INS PAYABLE, AD&D/LIFE 58.33 0.00
01-2389 PAYROLL OTHER PAYABLE 145.80 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 33,262.38 384.76 0.00 10,921.62
============== ============== ============== ==============
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 158,156.00 1,897,872.45
01-4114 ALLOCATION OPERATIONS, JCSUD 166,180.00 1,994,159.75
01-4413 MISC OPERATING REVENUE 0.00 4,477.17
01-4515 INTEREST EARNED, BRPUA 3,568.03 12,106.17
01-4919 MISCELLANEOUS REVENUE 0.00 28.75
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 327,904.03 0.00 3,908,644.29
============== ============== ============== ==============
EXPENDITURES
============
01-5-11-5011 PERSONNEL 81,785.87 763,335.21
01-5-11-5021 OVERTIME 3,463.15 18,733.46
01-5-11-5152 CONTRIBUTED, SOCIAL SECURITY 4,955.13 47,612.81
01-5-11-5153 CONTRIBUTED, MEDICARE 1,158.88 11,135.37
01-5-11-5161 CONTRIBUTED, RETIREMENT 7,516.93 76,065.20
01-5-11-5171 CONTRIBUTED, HEALTH INS 15,701.37 199,505.26
01-5-11-5172 CONTRIBUTED, HRA INS 13.12 10,286.90
01-5-11-5173 CONTRIBUTED, DENTAL INS 593.58 8,274.53
01-5-11-5175 CONTRIBUTED, VISION INS 95.28 1,053.36
10-25-2022 09:54 AM BRAZOS REGIONAL PUA PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
01 -GENERAL FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
01-5-11-5181 CONTRIBUTED, AD&D & LIFE INS 364.57 5,697.83
01-5-11-5183 CONTRIBUTED, LTD INS 357.38 4,505.03
01-5-11-5191 UNEMPLOYMENT INS, TEXAS 0.00 392.69
01-5-11-5420 OFFICE SUPPLIES 79.57 1,783.26
01-5-11-5474 POSTAGE & DELIVERY 13.25 374.21
01-5-11-5499 OTHER MISC. SUPPLIES 81.89 2,267.77
01-5-11-5515 M&R - EQUIPMENT 238.75 1,943.55
01-5-11-5545 M&R - COMPUTERS 1,928.00 23,601.13
01-5-11-5547 M&R - SOFTWARE 361.20 8,383.79
01-5-11-5701 PROFESSIONAL SERVICES 2,000.00 27,231.16
01-5-11-5703 AUDITS 0.00 16,500.00
01-5-11-5707 LEGAL SERVICES 9,560.75 16,283.25
01-5-11-5710 COMMUNICATION 1,054.46 14,566.93
01-5-11-5720 INSURANCE, GENERAL 33,751.50 136,420.65
01-5-11-5741 EMPLOYEE DUES & LICENSES 0.00 1,420.00
01-5-11-5765 TRAINING 0.00 2,628.75
01-5-11-5767 TRAVEL 0.00 307.54
01-5-11-5771 PERMITS & FEES 110.00 6,999.05
01-5-11-5799 OTHER MISC. SERVICES 91.05 905.71
01-5-25-5210.04 CAUSTIC SODA, 25% 0.00 96,059.68
01-5-25-5210.05 CHLORINE GAS 6,161.60 47,446.80
01-5-25-5210.08 SODIUM CHLORITE 0.00 59,317.76
01-5-25-5210.09 CHEMFLOC 1000 0.00 71,208.00
01-5-25-5210.10 CHEMFLOC 2400 0.00 20,501.00
01-5-25-5210.20 LIQUID AMMONIUM SULFATE 0.00 25,184.70
01-5-25-5210.24 VITEC 3000 6,648.63 39,619.14
01-5-25-5210.27 ABSORBIC ACID 0.00 1,131.48
01-5-25-5210.28 OXALIC ACID 0.00 964.51
01-5-25-5210.29 SODIUM HYPOCHLORITE 0.00 17,500.00
01-5-25-5380 UTILITY - ELECTRICITY 61,932.89 409,138.00
01-5-25-5420 OFFICE SUPPLIES 82.82 1,078.56
01-5-25-5425 SMALL TOOLS 0.00 246.18
01-5-25-5426 MINOR EQUIPMENT >500 & <5,000 64.53 422.73
01-5-25-5437 CARTRIDGE FILTERS 0.00 7,657.50
01-5-25-5445 FUEL 738.88 8,052.67
01-5-25-5473 JANITORIAL SUPPLIES 567.49 3,439.45
01-5-25-5478 UNIFORMS 467.24 4,676.77
01-5-25-5499 OTHER MISC. SUPPLIES 520.94 3,958.58
01-5-25-5510 M&R - GROUNDS 0.00 8,949.98
01-5-25-5514 M&R - PUMPS & PUMP MOTORS 0.00 6,490.65
01-5-25-5515 M&R - EQUIPMENT 8,062.95 39,449.13
01-5-25-5520 M&R - INSTRUMENTS 1,300.51 36,910.85
01-5-25-5525 M&R - VEHICLES 39.00 19,515.67
01-5-25-5547 M&R - SOFTWARE 0.00 10,546.00
01-5-25-5599 M&R - OTHER 24.96 8,157.60
01-5-25-5701 PROFESSIONAL SERVICES 704.00 1,936.00
01-5-25-5705 ENGINEERING SERVICES 6,506.25 37,114.25
01-5-25-5715 GARBAGE REMOVAL 1,140.75 12,533.83
01-5-25-5741 EMPLOYEE DUES & LICENSES 111.00 2,648.50
01-5-25-5765 TRAINING 350.00 5,038.69
10-25-2022 09:54 AM BRAZOS REGIONAL PUA PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
01 -GENERAL FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
01-5-25-5767 TRAVEL 2,358.50 2,441.21
01-5-25-5775 RENTAL OF EQUIPMENT 821.85 821.85
01-5-25-5799 OTHER MISC. SERVICES 0.00 151.71
01-5-27-5415 LAB SUPPLIES 5,388.72 34,809.52
01-5-27-5420 OFFICE SUPPLIES 0.00 84.16
01-5-27-5474 POSTAGE & DELIVERY 0.00 4.33
01-5-27-5478 UNIFORMS 0.00 192.00
01-5-27-5515 M&R - EQUIPMENT 0.00 14,872.00
01-5-27-5713 LAB SERVICES 916.70 5,076.95
01-5-27-5741 EMPLOYEE DUES & LICENSES 0.00 270.38
01-5-27-5765 TRAINING 0.00 325.00
01-5-27-5767 TRAVEL 0.00 106.60
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 270,185.89 0.00 2,474,264.77 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 329,083.43 329,083.43 4,430,565.91 4,430,565.91
============== ============== ============== ==============
*** END OF REPORT ***
10-25-2022 09:54 AM BRAZOS REGIONAL PUA PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
03 -DEBT SERVICE FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
03-1102 CASH, CLAIM ON POOLED 80,491.66 2,545.46
03-1214 TEXPOOL, AMUD DEBT SERVICE 1.37 712.03
03-1215 TEXPOOL, JCSUD DEBT SERVICE 79,015.87 78,436.31
03-1301 ACCOUNTS RECEIVABLE 427.08 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 80,920.11 79,015.87 81,693.80 0.00
============== ============== ============== ==============
LIABILITIES
===========
03-2457 DEFERRED REVENUE 1,291.66 1,291.66
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 1,291.66 0.00 1,291.66
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
03-4152 ALLOCATION DEBT SERVICE, AMUD 1,156.84 210,712.46
03-4154 ALLOCATION DEBT SERVICE, JCSUD 729.76 1,023,170.68
03-4516 INTEREST EARNED, AMUD 1.37 626.54
03-4517 INTEREST EARNED, JCSUD 184.13 3,942.46
______________ ______________ ______________ ______________
TOTAL REVENUES 729.76 1,342.34 0.00 1,238,452.14
============== ============== ============== ==============
EXPENDITURES
============
03-5-19-6512 DEBT PRINCIPAL , AMUD 0.00 200,000.00
03-5-19-6514 DEBT PRINCIPAL , JCSUD 0.00 910,000.00
03-5-19-6522 DEBT INTEREST , AMUD 0.00 10,750.00
03-5-19-6524 DEBT INTEREST , JCSUD 0.00 36,900.00
03-5-19-6542 DEBT SERVICE , AMUD 0.00 400.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 1,158,050.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 81,649.87 81,649.87 1,239,743.80 1,239,743.80
============== ============== ============== ==============
*** END OF REPORT ***
10-25-2022 09:54 AM BRAZOS REGIONAL PUA PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
07 -CAPITAL PROJECTS FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
07-1102 CASH, CLAIM ON POOLED 67,300.00 288,317.47
07-1216 TEXPOOL, AMUD CAPITAL RESERVE 923.06 466,398.71
07-1219 TEXPOOL, JCSUD CAPITAL RESERVE 86,740.56 1,088,611.60
07-1301 ACCOUNTS RECEIVABLE 0.00 16,771.90
______________ ______________ ______________ ______________
TOTAL ASSETS 154,963.62 0.00 1,860,099.68 0.00
============== ============== ============== ==============
LIABILITIES
===========
07-2206 ACCOUNTS PAYABLE ADJ 13,192.00 13,192.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 13,192.00 0.00 13,192.00
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
07-4122 ALTERNATE MEMBRANE, AMUD 6,045.00 72,540.00
07-4124 ALTERNATE MEMBRANE, JCSUD 6,955.00 83,460.00
07-4142 ALLOCATION CAPITAL, AMUD 62,755.00 766,613.04
07-4144 ALLOCATION CAPITAL, JCSUD 77,662.00 948,715.91
07-4516 INTEREST EARNED, AMUD 923.06 3,188.84
07-4517 INTEREST EARNED, JCSUD 2,123.56 6,464.42
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 156,463.62 0.00 1,880,982.21
============== ============== ============== ==============
EXPENDITURES
============
07-5-28-5948 CAPITAL - SWATS CAPACITY REST 14,692.00 34,074.53
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 14,692.00 0.00 34,074.53 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 169,655.62 169,655.62 1,894,174.21 1,894,174.21
============== ============== ============== ==============
*** END OF REPORT ***
10-25-2022 09:54 AM BRAZOS REGIONAL PUA PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
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 103,129.37 834,041.29
11-1931 F/A - WATER TREATMENT PLANT 0.00 26,677,469.54
11-1939 A/D - WATER PLANT 853,631.46 7,581,445.58
11-1941 F/A - EQUIPMENT 0.00 1,332,088.67
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 682,633.00
11-1949 A/D - EQUIPMENT 251,546.23 1,733,143.43
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 79,188.76 538,084.74
11-1961 CONSTRUCTION IN PROGRESS 36,284.53 224,642.23
______________ ______________ ______________ ______________
TOTAL ASSETS 36,284.53 1,287,495.82 32,961,512.83 10,686,715.04
============== ============== ============== ==============
FUND BALANCE
============
11-3911 NET INVESTED IN CAPITAL ASSETS 36,284.53 24,876,713.17
11-3999 UNASSIGNED FUND BALANCE 0.00 1,314,419.56
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 36,284.53 1,314,419.56 24,876,713.17
============== ============== ============== ==============
EXPENDITURES
============
11-5-11-5800 DEPRECIATION EXPENSE 1,287,495.82 1,287,495.82
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 1,287,495.82 0.00 1,287,495.82 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 1,323,780.35 1,323,780.35 35,563,428.21 35,563,428.21
============== ============== ============== ==============
*** END OF REPORT ***
10-25-2022 09:54 AM BRAZOS REGIONAL PUA PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
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 524,123.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 524,123.00 0.00
============== ============== ============== ==============
LIABILITIES
===========
13-2464 CURRENT BONDS PAYABLE 0.00 520,000.00
13-2843 PREMIUM ON BONDS - AMUD 0.00 1,179.00
13-2845 PREMIUM ON BONDS - JCSUD 0.00 2,944.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 0.00 524,123.00
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 524,123.00 524,123.00
============== ============== ============== ==============
*** END OF REPORT ***
10-25-2022 09:54 AM BRAZOS REGIONAL PUA PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
99 -POOLED CASH FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
99-1100 POOLED CASH - FFB CHECKING 174,457.73 1,281,752.05
99-1104 POOLED CASH - FFB RESERVE 276.42 220,446.26
99-1401 DUE FROM GENERAL FUND 32,540.98 10,921.62
______________ ______________ ______________ ______________
TOTAL ASSETS 174,734.15 32,540.98 1,513,119.93 0.00
============== ============== ============== ==============
LIABILITIES
===========
99-2100 AP CONTROL ACCOUNT 32,540.98 10,921.62
99-2105 DUE TO OTHER FUNDS 172,009.17 1,499,473.33
99-2110 WAGES PAYABLE 2,724.98 2,724.98
______________ ______________ ______________ ______________
TOTAL LIABILITIES 32,540.98 174,734.15 0.00 1,513,119.93
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 207,275.13 207,275.13 1,513,119.93 1,513,119.93
============== ============== ============== ==============
*** END OF REPORT ***