Import 098282d1-8cb9-488d-9a54-91c1c4621e43
Download
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
010-GENERAL FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
010-1000 CASH-GENERAL FUND 1,947.37 0.00
010-1001 CLAIM ON CASH 974,708.80 579,824.31
010-1012 CASH-GENERAL UNC PROP 29.55 0.00
010-1018 CASH-DESGNTED RESRV @ TEXPOOL 1,921.50 441,213.39
010-1030 GF RESERVES TEXSTAR 4,378.70 1,007,573.89
010-1036 CASH-LEOSE FOR TRAINING 2,154.69 0.00
010-1155 CASH ON HAND-FITNESS 0.00 150.00
010-1160 CASH ON HAND-MUNICIPAL COURT 0.00 500.00
010-1168 CASH ON HAND-POLICE DEPT 0.00 50.00
010-1169 CASH ON HAND-PET ADOPTION 0.00 50.00
010-1180 CASH ON HAND-LIBRARY 0.00 50.00
010-1190 CASH ON HAND-PETTY CASH 0.00 500.00
010-1201 CASH-STREET I&S 493.46 0.00
010-1226 CURRENT PROP TAX REC 7,207.50 56,672.50
010-1227 DELIQUENT AV TAXES REC 34,392.86 65,778.08
010-1228 2018 TAXES RECEIVABLE 0.29 0.00
010-1229 2017 TAXES RECEIVABLE 0.34 0.00
010-1230 2016 TAXES RECEIVABLE 0.18 0.00
010-1231 2015 TAXES RECEIVABLE 0.44 0.00
010-1232 2014 TAXES RECEIVABLE 0.25 0.00
010-1233 2013 TAXES RECEIVABLE 0.38 0.00
010-1234 2012 TAXES RECEIVABLE 0.37 0.00
010-1235 2011 TAXES RECEIVABLE 0.05 0.00
010-1236 2010 & PRIOR TAXES RECEIVABLE 0.06 0.00
010-1300 ALLOWANCE FOR UNCOLL.ACCT 0.04 0.00
010-1302 ALLOWNC BAD ACCT-CRT 5,343.26 34,952.42
010-1380 GRANTS RECEIVABLE 823.73 0.00
010-1401 LEASE RECEIVABLE 3,518.49 10,989.51
010-1405 RECEIVABLE FRM GHS-SECRTY 0.00 1,218.08
010-1406 RECEIVABLE-OTHER ENTITIES 0.00 4,203.30
010-1412 SALES TAX RECEIVABLE 12,927.00 489,064.00
010-1413 FRANCHISE TAX RECEIVABLE 0.00 174,425.21
010-1414 Mixed Beverage Tax Receivable 1,309.00 1,155.00
010-1800 INVENTORY 0.00 27,661.15
010-1992 DUEto/frmGEN.RESTRCT FND 11,945.00 0.00
010-1999 COURT FINES RECEIVABLE 10,685.36 69,904.52
______________ ______________ ______________ ______________
TOTAL ASSETS 86,723.65 987,065.02 2,930,982.94 34,952.42
============== ============== ============== ==============
LIABILITIES
===========
010-2010 ACCOUNTS PAYABLE 36,599.34 0.00
010-2011 A/P PENDING 60,328.92 159,098.06
010-2080 RETIREMENT PAYABLE 6,233.30 5,735.86
010-2090 FED.W/H TAX PAYABLE 6,526.64 6,286.62
010-2100 INSURANCE PAYABLE 4,027.58 3,208.19
010-2101 DENTAL, VISION, LIFE INS PAY 1,278.55 1,655.22
010-2102 FLEX SPENDING ACCT 767.42 1,472.48
010-2104 TEXAS LIFE INS PAYABLE 0.00 363.01
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
010-GENERAL FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
010-2110 GARNISHMENT PAYABLE 1,540.55 1,540.55
010-2120 SOC.SEC./MEDCR PAYABLE 1,600.10 1,299.08
010-2121 SALES TAX PAYABLE 598.38 265.16
010-2144 UNCLAIMED PROPRTY PAYBLE 0.00 3,000.54
010-2145 AUDITOR'M DEPOSIT PAYABLE 197.20 897.20
010-2148 COURT FEES PAYBL TO STATE 27,572.40 15,284.61
010-2150 ACCRUED LIABILITIES 612.00 0.00
010-2151 BANK REC ADJUSTMENTS 0.05 0.00
010-2152 PAYABLE TO OMNIBASE 104.44 268.99
010-2153 COURT FEES PAY TO COLL AG 947.20 2,244.33
010-2154 CIVIC CENTER DEPOSIT PAYB 1,500.00 8,700.00
010-2155 UTILITY LIABILTIES 487.07 783.73
010-2157 457 FUNDS PAYABLE 291.60 291.60
010-2162 PAYABLE TO EMPLOYEES 64,998.58 92,859.58
010-2180 DEFERRED INCOME - TAXES 34,392.53 65,778.08
010-2182 Deferred Inflow of Resources 3,699.06 10,808.94
010-2190 DEFERRED INCOME - GRANT 823.73 0.00
010-2191 REVENUE SHARING 2,396.00 2,396.00
010-2199 DEFERRED REV.-COURT 5,343.26 34,953.25
010-2200 BAD CHECKS 442.00 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 101,062.67 162,245.23 3,448.72 415,742.36
============== ============== ============== ==============
FUND BALANCE
============
010-3000 FUND BALANCE 0.00 2,474,272.91
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 2,474,272.91
============== ============== ============== ==============
REVENUES
========
010-4-001-3879 CURRENT PROPERTY TAXES 13,232.00 2,773,039.58
010-4-001-3880 DELIQUENT PROPERTY TAXES 1,842.83 31,796.49
010-4-001-4060 A V TAX PENALTY/INTEREST 1,263.92 28,903.89
010-4-002-4091 BUSINESS PERS PROP REVENU 16.29 5,591.90
010-4-002-4100 FINES & FORFEITURES 18,165.28 153,959.20
010-4-002-4105 PD & ANIMAL CONTROL FINES 30.00 1,070.00
010-4-002-4150 SALES TAX 246,169.53 2,946,402.46
010-4-002-4200 FRANCHISE TAX 1,510.22 423,247.74
010-4-002-4201 FRANCHISE MUNI UTILITIES 40,458.22 475,791.81
010-4-002-4225 PILOT 0.00 4,760.45
010-4-002-4250 LIQUOR TAX 41.87 13,451.01
010-4-002-4270 ALCOHOL PERMIT FEES 0.00 450.00
010-4-002-4300 LICENSES & PERMITS 2,980.10 44,299.00
010-4-002-4320 PMT ON LOT CLEANING 4,072.36 8,765.40
010-4-002-4331 AUDITORIUM RENTAL 144.70 2,994.70
010-4-002-4400 INTEREST 6,638.72 32,170.51
010-4-002-4440 SALE OF CITY PROPERTY 1,174.80 41,184.80
010-4-002-4500 LIBRARY FINES,COPIES,ETC. 1,431.28 13,308.17
010-4-002-4546 PD FEES 136.81 1,304.33
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
010-GENERAL FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
010-4-002-4547 RECREATION FEES 8,072.87 160,505.69
010-4-002-4548 ANIMAL ADOPT/SURRENDER 120.00 1,732.00
010-4-002-4550 MISCELLANEOUS 3,054.68 12,792.55
010-4-002-4600 POOL RECEIPTS 646.31 47,688.65
010-4-002-4606 PROPERTY RENTAL 939.14 12,208.29
010-4-002-4608 FITNESS CENTER REVENUE 17,021.48 226,950.73
010-4-002-4609 CIVIC CENTER RENTAL 700.00 40,390.00
010-4-002-4610 SPECIAL EVENT REVENUE 291.90 291.90
010-4-002-4650 OVER / SHORT 17.10 0.00
010-4-002-4850 TRANSFER FROM W&S FUND 41,724.72 500,696.64
010-4-002-4880 TRANSF FROM OTHER FUNDS 0.00 2,410.00
010-4-002-4891 REIMB FROM GISD 0.00 35,581.64
010-4-002-4900 REIMB. ON DAMAGES 0.00 20,615.67
010-4-002-4901 PLANNING AND ZONING 256.00 1,286.00
______________ ______________ ______________ ______________
TOTAL REVENUES 646.31 411,506.82 0.00 8,065,641.20
============== ============== ============== ==============
EXPENDITURES
============
010-5-105-10010 SALARIES 12,656.82 127,185.50
010-5-105-10020 OVERTIME-SALARIES 7.46 201.11
010-5-105-10050 RETIREMENT 1,018.47 12,787.46
010-5-105-10070 SOCIAL SECURITY 277.30 4,071.97
010-5-105-10075 LIFE INS - EMPLOYER 17.20 139.75
010-5-105-10080 CONTRACT SERVICES 1,143.61 6,749.63
010-5-105-20010 UTILITIES 1,860.54 17,797.25
010-5-105-20015 BOOKS, VIDEOS, DVDS 14,593.94 30,913.64
010-5-105-20020 MAT., SUP., & PRINTING 1,015.65 7,298.69
010-5-105-20030 SCHOOL, TRAVEL & MEMBERSHIPS 544.19 1,820.02
010-5-105-20040 INSURANCE 3,898.94 12,472.53
010-5-105-20045 PROP, LIAB, WC INSURANCE 0.00 3,408.94
010-5-105-20050 MAILING EXPENSE 0.00 278.58
010-5-105-20090 EQUIPMENT PURCHASE 4,639.96 4,639.96
010-5-105-20140 EQUIPMENT RENTAL & LEASE 0.00 187.80
010-5-105-20170 CC FEES - LIBRARY 154.24 326.25
010-5-105-30021 GRANT EXPENSE 17.04 17.04
010-5-105-30025 SUBSCRIPTIONS 0.00 2,809.91
010-5-105-30070 MAINTENANCE AGREEMENT 0.00 5,078.31
010-5-105-50010 REPAIRS & MAINTENANCE 208.79 1,759.00
010-5-110-10010 SALARIES 46,762.77 435,129.94
010-5-110-10020 OVERTIME-SALARIES 109.08 1,356.86
010-5-110-10050 RETIREMENT 5,057.52 61,790.60
010-5-110-10070 SOCIAL SECURITY 472.37 6,272.93
010-5-110-10075 LIFE INS - EMPLOYER 43.00 426.56
010-5-110-10076 DEN/VIS/LIFE FOR CITY MGR 30.47 121.88
010-5-110-10080 CONTRACT SERVICES 19,638.29 183,289.44
010-5-110-20010 UTILITIES 1,672.27 14,760.11
010-5-110-20020 MAT., SUP., & PRINTING 935.71 14,771.69
010-5-110-20030 SCHOOL, TRAVEL & MEMBERSHIPS 263.94 17,902.64
010-5-110-20040 INSURANCE 4,065.98 41,346.11
010-5-110-20045 PROP, LIAB, WC INSURANCE 0.00 12,048.54
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 4
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
010-GENERAL FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
010-5-110-20050 MAILING EXPENSE 0.00 999.77
010-5-110-20070 AUDIT 26,500.00 96,132.82
010-5-110-20071 LEGAL 7,173.64 11,074.16
010-5-110-20080 TAX BOARD-CCAD 0.00 47,680.88
010-5-110-20090 EQUIPMENT PURCHASE 0.00 7,789.72
010-5-110-20140 EQUIPMENT RENTAL & LEASE 0.00 3,501.50
010-5-110-30020 MISCELLANEOUS 587.34 8,728.81
010-5-110-30035 PUBLIC NOTICES & ADVERTISING 1,180.00 4,631.30
010-5-110-30037 RECORDING FEES 0.00 54.00
010-5-110-30050 AMBULANCE 0.00 25,000.00
010-5-110-30070 MAINTENANCE AGREEMENT 0.00 32,622.00
010-5-110-30090 TAX COLLECTION FEE 0.00 12,090.00
010-5-110-30091 BANKING FEES 500.00 6,000.00
010-5-110-30092 ELECTION EXPENSES 0.00 349.25
010-5-110-50010 REPAIRS & MAINTENANCE 1,736.20 11,921.93
010-5-110-50034 SUBSTANDARD STRUCTURE ACTION 0.00 3,391.85
010-5-110-50070 FIREWORKS 0.00 25,000.00
010-5-113-10010 SALARIES 12,959.49 127,588.33
010-5-113-10020 OVERTIME-SALARIES 64.13 207.42
010-5-113-10050 RETIREMENT 1,436.09 18,392.36
010-5-113-10070 SOCIAL SECURITY 137.21 1,783.22
010-5-113-10075 LIFE INS - EMPLOYER 17.20 189.20
010-5-113-10080 CONTRACT SERVICES 0.00 6,000.00
010-5-113-20010 UTILITIES 0.00 482.36
010-5-113-20020 MATERIALS & SUPPLIES 0.00 3,832.75
010-5-113-20025 CEMETERY MATERIALS & SUPPLIES 0.00 580.56
010-5-113-20030 SCHOOL, TRAVEL & MEMBERSHIPS 1,272.37 2,939.27
010-5-113-20040 INSURANCE 2,039.16 13,609.48
010-5-113-20045 PROP, LIAB, WC INSURANCE 0.00 109.83
010-5-113-20140 EQUIPMENT RENTAL & LEASE 0.00 3,354.58
010-5-113-20170 CC FEES PLANNING/ZONING 105.05 402.62
010-5-113-30035 RECORDING FEES 32.00 699.82
010-5-113-30042 CENTEX EVENTS 477.51 477.51
010-5-113-50010 REPAIRS & MAINTENANCE 272.30 3,821.77
010-5-115-10010 SALARIES 119,667.43 1,436,123.52
010-5-115-10020 OVERTIME-SALARIES 16,996.65 172,319.17
010-5-115-10021 K9 STIPEND 0.00 6,703.07
010-5-115-10050 RETIREMENT 18,021.94 236,240.06
010-5-115-10070 SOCIAL SECURITY 1,760.52 22,804.05
010-5-115-10075 LIFE INS - EMPLOYER 215.00 2,373.60
010-5-115-10080 CONTRACT SERVICES 2,100.00 42,781.00
010-5-115-20010 UTILITIES 3,882.88 42,839.58
010-5-115-20020 MAT., SUP., & PRINTING 949.81 15,056.67
010-5-115-20030 SCHOOL, TRAVEL & MEMBERSHIPS 563.43 8,086.12
010-5-115-20040 INSURANCE 30,820.24 192,054.07
010-5-115-20045 PROP, LIAB, WC INSURANCE 0.00 47,728.14
010-5-115-20050 MAILING EXPENSE 0.00 923.63
010-5-115-20090 EQUIPMENT PURCHASE 0.00 27,866.74
010-5-115-20110 UNIFORMS 2,561.09 18,356.99
010-5-115-20140 EQUIPMENT RENTAL & LEASE 0.00 2,798.80
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 5
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
010-GENERAL FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
010-5-115-20230 VEHICLE LEASE 7,824.37 93,665.45
010-5-115-30010 GAS & OIL 7,047.80 53,056.05
010-5-115-30020 MISCELLANEOUS 964.00 4,105.79
010-5-115-30040 K-9 EXPENSE 56.99 5,418.92
010-5-115-40010 CAPITAL OUTLAY 0.00 12,399.99
010-5-115-50020 REPAIR & MAINT.-VEHICLES 2,943.68 38,297.82
010-5-115-50030 REP/MAINT.-NON VEHICLE 3,331.65 33,675.13
010-5-115-50100 MAINTENANCE CONTRACT 2,969.97 73,240.93
010-5-115-60500 RABIES CONTROL 0.00 250.30
010-5-115-60502 AMMUNITION 0.00 3,676.84
010-5-115-60503 PROMOTIONAL MATERIALS 180.00 3,035.96
010-5-115-60504 ANIMAL CONTROL 1,843.17 5,096.38
010-5-116-10010 SALARIES 10,513.53 108,322.39
010-5-116-10020 OVERTIME-SALARIES 624.73 2,431.29
010-5-116-10050 RETIREMENT 983.97 12,218.45
010-5-116-10070 SOCIAL SECURITY 251.43 3,073.50
010-5-116-10075 LIFE INS - EMPLOYER 25.80 283.80
010-5-116-10080 CONTRACT SERVICES 1,609.50 13,703.13
010-5-116-20020 MAT., SUP., & PRINTING 326.71 1,667.53
010-5-116-20030 SCHOOL, TRAVEL & MEMBERSHIPS 150.00 925.32
010-5-116-20040 INSURANCE 3,688.10 24,751.88
010-5-116-20045 PROP, LIAB, WC INSURANCE 0.00 992.17
010-5-116-20050 MAILING EXPENSE 0.00 467.77
010-5-116-20170 CREDIT CARD SERV FEE 1,449.81 9,340.56
010-5-116-30070 MAINTENANCE AGREEMENT 0.00 9,016.00
010-5-116-50010 REPAIRS & MAINTENANCE 299.23 3,228.95
010-5-117-10050 RETIREMENT 83.32 1,000.00
010-5-117-10080 CONTRACT SERVICES 3,000.00 33,000.00
010-5-117-20010 UTILITIES 1,970.15 24,478.29
010-5-117-20020 MAT., SUP., & PRINTING 0.00 1,318.86
010-5-117-20040 INSURANCE 0.00 93.55
010-5-117-20045 PROP, LIAB, WC INSURANCE 0.00 34,905.38
010-5-117-20050 MAILING EXPENSE 0.00 170.47
010-5-117-20090 EQUIPMENT PURCHASE 973.18 15,496.01
010-5-117-20141 TRAINING 1,759.97 10,484.99
010-5-117-30010 GAS & OIL 989.75 7,091.36
010-5-117-30020 MISCELLANEOUS 0.00 52.27
010-5-117-30070 MAINTENANCE AGREEMENT 0.00 11,554.17
010-5-117-40010 CAPITAL OUTLAY 0.00 18,000.00
010-5-117-50010 REPAIRS & MAINTENANCE 1,004.74 21,904.18
010-5-117-50013 BUILDING & OTHER R&M 0.00 406.00
010-5-117-60050 FIRE PREVENTION EXPENSE 0.00 205.25
010-5-117-70779 FIREMEN INCENTIVE PAY 0.00 25,000.00
010-5-120-10010 SALARIES 36,062.72 410,482.82
010-5-120-10020 OVERTIME-SALARIES 2,178.33 17,939.06
010-5-120-10050 RETIREMENT 4,155.68 61,794.34
010-5-120-10070 SOCIAL SECURITY 390.64 5,957.47
010-5-120-10075 LIFE INS - EMPLOYER 65.79 826.89
010-5-120-20010 UTILITIES 7,060.87 78,254.06
010-5-120-20040 INSURANCE 6,645.06 51,167.93
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 6
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
010-GENERAL FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
010-5-120-20045 PROP, LIAB, WC INSURANCE 0.00 24,673.35
010-5-120-20090 EQUIPMENT PURCHASE 0.00 818.98
010-5-120-20110 UNIFORMS 406.29 5,575.37
010-5-120-20230 VEHICLE LEASE 2,544.50 31,174.80
010-5-120-20245 HEAVY EQUIPMENT LEASE PRIN 1,169.26 97,674.48
010-5-120-20246 EQUIPMENT LEASE INT 1,169.26 24,762.30
010-5-120-30010 GAS & OIL 3,454.33 48,630.90
010-5-120-30020 MISCELLANEOUS 0.00 143.27
010-5-120-30091 MATERIAL & SUPPLIES 2,139.78 13,906.17
010-5-120-40045 STREET SWEEPER PRIN 0.00 37,272.96
010-5-120-40046 STREET SWEEPER INT 0.00 3,456.11
010-5-120-50010 REPAIRS & MAINTENANCE 129.95 829.38
010-5-120-50025 VEHICLE OR EQUIP REP & MAINT 2,030.81 41,017.35
010-5-120-50027 STREET REPAIR & MAINT 1,223.23 365,646.06
010-5-121-10010 SALARIES 5,918.42 55,410.17
010-5-121-10020 OVERTIME-SALARIES 362.33 3,616.23
010-5-121-10050 RETIREMENT 707.49 8,502.46
010-5-121-10070 SOCIAL SECURITY 64.72 788.92
010-5-121-10075 LIFE INS - EMPLOYER 8.60 94.60
010-5-121-20010 UTILITIES 980.37 9,593.59
010-5-121-20020 MAT., SUP., & PRINTING 1,349.01 9,559.08
010-5-121-20040 INSURANCE 1,647.94 11,141.43
010-5-121-20045 PROP, LIAB, WC INSURANCE 0.00 3,138.94
010-5-121-20090 EQUIPMENT PURCHASE 0.00 6,837.54
010-5-121-20110 UNIFORMS 0.00 197.53
010-5-121-20140 EQUIPMENT RENTAL 0.00 1,651.10
010-5-121-30020 MISCELLANEOUS 0.00 35.00
010-5-121-50010 REPAIRS & MAINTENANCE 140.95 4,634.59
010-5-125-10010 SALARIES 20,431.96 132,622.92
010-5-125-10020 OVERTIME-SALARIES 159.33 1,249.31
010-5-125-10050 RETIREMENT 2,917.64 19,647.46
010-5-125-10070 SOCIAL SECURITY 278.46 1,881.47
010-5-125-10075 LIFE INS - EMPLOYER 17.20 189.20
010-5-125-20010 UTILITIES 731.58 6,150.52
010-5-125-20030 SCHOOL, TRAVEL & MEMBERSHIPS 0.00 1,554.19
010-5-125-20040 INSURANCE 2,668.02 17,946.67
010-5-125-20045 PROP, LIAB, WC INSURANCE 0.00 4,736.91
010-5-125-20050 MAILING EXPENSE 0.00 170.47
010-5-125-20110 UNIFORMS 0.00 220.00
010-5-125-20230 VEHICLE LEASE 384.21 11,023.35
010-5-125-30010 GAS & OIL 308.25 2,865.60
010-5-125-30020 MISCELLANEOUS 0.00 35.00
010-5-125-30091 MATERIAL & SUPPLIES 0.00 137.35
010-5-125-50010 REPAIRS & MAINTENANCE 91.74 1,700.30
010-5-125-50025 VEHICLE OR EQUIP REP & MAINT 55.55 4,612.79
010-5-128-10010 SALARIES 34,857.10 330,204.84
010-5-128-10020 OVERTIME-SALARIES 391.27 4,868.48
010-5-128-10050 RETIREMENT 3,886.67 48,226.82
010-5-128-10070 SOCIAL SECURITY 356.70 4,481.76
010-5-128-10075 LIFE INS - EMPLOYER 60.20 636.40
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 7
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
010-GENERAL FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
010-5-128-10080 CONTRACT SERVICES 6,585.00 84,446.50
010-5-128-20010 UTILITIES 783.90 36,012.03
010-5-128-20020 MATERIALS & SUPPLIES 2,125.15 24,597.61
010-5-128-20030 SCHOOL, TRAVEL & MEMBERSHIPS 0.00 977.83
010-5-128-20035 LEAGUE FEES 0.00 2,697.59
010-5-128-20040 INSURANCE 9,183.00 62,757.70
010-5-128-20045 PROP, LIAB, WC INSURANCE 0.00 2,203.84
010-5-128-20050 MAILING EXPENSE 0.00 93.41
010-5-128-20090 EQUIPMENT PURCHASE 0.00 5,869.96
010-5-128-20110 UNIFORMS 0.00 2,070.29
010-5-128-20170 CC FEES PARKS AND REC 93.05 3,292.75
010-5-128-20180 T-SHIRTS & AWARDS 4,953.48 28,962.83
010-5-128-20230 VEHICLE LEASE 896.91 12,114.98
010-5-128-30010 GAS & OIL 713.27 7,439.94
010-5-128-30020 MISCELLANEOUS 0.00 2,798.58
010-5-128-40010 CAPITAL OUTLAY 0.00 16,411.44
010-5-128-50010 REPAIRS & MAINTENANCE 636.43 14,628.74
010-5-128-50015 FIELD IMPROVEMENTS 0.00 3,790.15
010-5-128-50016 PARK REPAIRS 150.75 2,917.90
010-5-128-50025 VEHICLE OR EQUIP REP & MAINT 362.66 2,926.03
010-5-130-10010 SALARIES 8,201.34 49,936.16
010-5-130-10050 RETIREMENT 565.06 5,433.02
010-5-130-10070 SOCIAL SECURITY 227.08 1,353.81
010-5-130-10075 LIFE INS - EMPLOYER 8.60 43.00
010-5-130-20010 UTILITIES 2,217.67 18,733.88
010-5-130-20020 MAT., SUP., & PRINTING 3,334.11 9,421.63
010-5-130-20030 SCHOOL, TRAVEL & MEMBERSHIPS 0.00 285.63
010-5-130-20040 INSURANCE 1,020.08 4,129.84
010-5-130-20045 PROP, LIAB, WC INSURANCE 0.00 2,588.58
010-5-130-50010 REPAIRS & MAINTENANCE 2,060.56 10,136.24
010-5-132-10010 SALARIES 0.00 55,946.95
010-5-132-10070 SOCIAL SECURITY 0.00 4,279.91
010-5-132-20010 UTILITIES 779.23 7,564.90
010-5-132-20020 MAT., SUP., & PRINTING 583.50 8,948.41
010-5-132-20030 SCHOOL, TRAVEL & MEMBERSHIPS 0.00 1,793.00
010-5-132-20040 INSURANCE 0.00 93.55
010-5-132-20045 PROP, LIAB, WC INSURANCE 0.00 1,480.02
010-5-132-20090 EQUIPMENT PURCHASE 0.00 1,351.27
010-5-132-20190 RETAIL ITEMS TO SELL 232.13 3,192.11
010-5-132-50010 REPAIRS & MAINTENANCE 0.00 14,207.78
010-5-165-60102 TRANSFER TO OTHER FUNDS 726,015.73 730,000.00
010-5-226-10010 Salaries 11,562.56 109,975.60
010-5-226-10050 RETIREMENT 647.33 8,316.12
010-5-226-10070 SOCIAL SECURITY 385.30 4,664.94
010-5-226-10075 LIFE INS - EMPLOYER 8.60 94.60
010-5-226-10080 CONTRACT SERVICES 4,485.00 34,530.00
010-5-226-20010 UTILITIES 2,703.76 25,775.72
010-5-226-20020 MAT.,SUP., & PRINTING 383.23 14,220.95
010-5-226-20030 SCHOOL, TRAVEL & MEMBERSHIP 11.46 697.72
010-5-226-20040 INSURANCE 1,646.94 11,140.43
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 8
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
010-GENERAL FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
010-5-226-20045 PROP, LIAB, WC INSURANCE 0.00 4,904.17
010-5-226-20050 MAILING EXPENSE 69.17 442.31
010-5-226-20090 EQUIPMENT PURCHASE 633.94 3,060.24
010-5-226-20140 EQUIPMENTLEASE 0.00 9,641.70
010-5-226-20170 CREDIT CARD SERV FEE 497.59 5,846.43
010-5-226-20190 RETAIL ITEMS TO SELL 462.71 10,844.77
010-5-226-30070 MAINTENANCE AGREEMENT 0.00 3,922.00
010-5-226-50010 REPAIRS & MAINTENANCE 168.92 14,920.15
010-5-226-50018 ADVERTISING 12.99 802.36
010-5-226-50019 EVENTS 0.00 4,922.19
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 1,374,697.31 2,312.87 8,056,177.23 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 1,563,129.94 1,563,129.94 10,990,608.89 10,990,608.89
============== ============== ============== ==============
*** END OF REPORT ***
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
020-ENTERPRISE FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
020-1000 CASH-W&S OPERATING 396.53 0.00
020-1001 CLAIM ON CASH 184,474.60 923,372.67
020-1012 CASH-W&S UNCL PROP 9.30 0.00
020-1030 CASH-WATER DEPOSIT 759.87 0.00
020-1031 WS RESERVES TEXSTAR 4,378.70 1,007,573.89
020-1050 WEALTH MGMT ACCT BOKF 37,267.20 8,752,435.32
020-1101 2022 CLFR FUNDS TRANCHE 2 4,132.46 1,524,707.26
020-1126 CASH-FT HOOD SWR RES 47.39 384,427.70
020-1134 CASH-2019 BOND RESERVE 9,222.19 462,040.59
020-1136 CASH-2020 WTR MTR BND I&S 16.47 133,622.04
020-1150 CASH ON HAND UTILITY DRAWERS 0.00 500.00
020-1299 DISCNT 99 CERT.OF OBL 0.25 0.00
020-1300 ALLOWANCE FOR UNCOLL.ACCT 0.00 399,846.86
020-1311 A/R ENTITIES (ACCRD EXP) 0.23 0.00
020-1331 ACCOUNTS RECEIVABLE 25,393.60 777,402.64
020-1332 UTIL CONVERSION A/R 0.45 0.00
020-1333 UNBILLED RECEIVABLE 16,682.96 454,185.60
020-1341 OTHER RECEIVABLES 67,736.73 99,395.92
020-1351 BAD CHECKS 0.00 9,519.20
020-1361 RECEIVABLE FROM FT.GATES 1,358.07 25,391.26
020-1371 RECEIVABLE FROM TDC 0.00 256,944.46
020-1372 UTIL CONVERSION A/R 0.26 0.00
020-1375 RECVBL FRM FLAT CUSTMRS 0.00 3,296.66
020-1380 GRANTS RECEIVABLE 0.00 405.50
020-1450 TDC - WATER LINES 0.14 0.00
020-1460 TDC - WATER TANKS 0.15 0.00
020-1470 TDC - PUMP STATION 0.25 0.00
020-1480 TDC - SEWER LINES 0.06 0.00
020-1485 TDC IMPROVEMENTS 0.50 0.00
020-1490 MEDICAL PLASTICS SEWER LN 0.33 0.00
020-1520 LBW- CEMENT PIPELINES 0.41 0.00
020-1530 LBW- PVC PIPELINES 0.41 0.00
020-1540 LBW- STORAGE TANKS 0.26 0.00
020-1550 LBW- MACHINERY & EQUIP. 0.11 0.00
020-1610 LAND & LAND RIGHTS 0.00 284,338.72
020-1620 IMPROVEMENTS 167,495.80 58,345,520.60
020-1630 MACHINERY & EQUIPMENT 148,420.04 5,686,595.18
020-1635 LEASE ASSET 38,749.16 295,093.80
020-1640 ACCUMULATED DEPRECIATION 1,620,517.50 41,801,180.83
020-1650 CONTRUCTION IN PROGRESS 1,491,234.30 2,727,079.07
020-1670 ACCUM.AMORTIZATION 15,659.33 76,555.60
020-1713 HANGAR RENT-J CARVER 0.00 600.00
020-1718 HANGAR RENT-B MCCARLEY 0.00 75.00
020-1728 HANGAR RENT-J MCLEAN 0.00 125.00
020-1729 HANGAR RENT-A LELLA 0.00 125.00
020-1735 AIRPORT RUNWAY PARKING 0.00 2.00
020-1738 HANGAR RENT K MALLACH 0.00 125.00
020-1800 INVENTORY 0.00 211,399.58
020-1851 DO SDBF ACCT DIFF 0.00 0.43
020-1852 DO SDBF CHANGES 0.00 13,453.50
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
020-ENTERPRISE FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
020-1853 DO SDBF CONTRIB 0.00 973.31
020-1854 DI-SDBF CHANGES 0.00 0.12
020-1855 DI SDBF DIFF EXP 0.00 7,178.07
020-1856 DO-OPEB ACCT DIFF 0.00 0.39
020-1857 DO OPEB CHANGES 0.00 0.08
020-1858 DO OPEB CONTRIB 0.00 5,002.90
020-1859 DI OPEB CHANGES 0.00 7,536.58
020-1860 DI OPEB DIFF 0.00 4,158.38
020-1861 DO PENSION CHANGES 0.00 9,607.89
020-1862 DO PENSION CONTRIB 0.00 124,971.82
020-1863 DI PENSION INVESTMENT 0.00 363,447.12
020-1864 DI PENSION ACCT DIFF 0.00 18,080.61
020-1900 DEF INC AMORTIZATION 101,908.91 521,302.81
______________ ______________ ______________ ______________
TOTAL ASSETS 2,314,949.22 1,620,915.70 83,049,371.77 42,670,225.19
============== ============== ============== ==============
LIABILITIES
===========
020-2001 WATER DEPOSITS PAYABLE 1,545.00 296,276.00
020-2006 LEASE LIABILITY 5,694.09 185,939.46
020-2010 ACCOUNTS PAYABLE 15,611.00 0.00
020-2011 A/P PENDING 340,815.56 652,156.06
020-2075 NOTE PAYABLE 45,370.12 604,257.07
020-2080 RETIREMENT PAYABLE 2,450.71 2,556.99
020-2090 FED.W/H TAX PAYABLE 2,630.77 2,630.77
020-2100 INSURANCE PAYABLE 1,776.09 1,210.82
020-2101 DENTAL, VISION, LIFE INS PAY 255.26 437.40
020-2102 FLEX SPENDING ACCT 240.60 289.08
020-2104 TEXAS LIFE INS PAYABLE 0.55 0.00
020-2110 GARNISHMENT PAYABLE 202.38 202.38
020-2120 SOC.SEC./MEDCR PAYABLE 509.01 509.01
020-2121 SALES TAX PAYABLE 329.24 45,978.69
020-2123 FIREPLUG METER DEP PAYBL 700.00 2,800.00
020-2125 FLATs WATER BILLING PAYBL 0.00 24.58
020-2133 FLATs MISC CHRGS PAYABLE 0.00 510.09
020-2135 FLATs MEMB'SHIP DUES PAYB 0.00 2,110.25
020-2136 FLAT'S TNRCC FEES PAYABLE 0.00 2,915.44
020-2137 FLATs PEN & INT PAYABLE 0.00 14,455.99
020-2141 GARB REV PAY WASTE MGMT 65,869.38 9,734.83
020-2144 UNCLAIMED PROPRTY PAYBLE 0.00 2,145.58
020-2149 PAYABLE ToFITNESS CENTER 0.00 244.62
020-2150 ACCRUED LIABILITIES 244.61 244.62
020-2151 BANK REC ADJUSTMENTS 151.62 0.00
020-2153 COLLECTION AGENCY 0.00 232.45
020-2157 457 FUNDS PAYABLE 320.40 320.40
020-2162 PAYABLE TO EMPLOYEES 25,116.06 35,010.06
020-2190 DEFERRED INCOME - GRANT 2,503.75 1,454,204.63
020-2201 ACCRUED INTEREST PAYABLE 4,553.63 37,200.73
020-2235 2019 BONDS PAYABLE 475,000.00 7,625,000.00
020-2237 2017 BONDS PAYABLE 235,000.00 3,595,000.00
020-2238 2020 WTR MTR BONDS PAYABLE 135,000.00 2,075,000.00
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
020-ENTERPRISE FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
020-2240 BONDS PAYABLE 4,725,000.00 5,925,000.00
020-2245 CURR.MATUR's LT DEBT 385,000.00 1,535,000.00
020-2251 CURRENT MAT-NOTES PAY 1,524.47 60,235.20
020-2255 ACCR COMP ABSENCES 0.00 95,864.89
020-2700 RETAINAGE LIAB 45,664.59 45,664.59
020-2950 Net Pension Liability 0.00 293,756.75
020-2951 OPEB SDBF Liability 0.00 89,807.00
020-2952 OPEB LIABILITY 0.00 73,073.28
______________ ______________ ______________ ______________
TOTAL LIABILITIES 902,133.66 5,616,945.23 18,619.74 24,749,379.97
============== ============== ============== ==============
FUND BALANCE
============
020-3000 FUND BALANCE 5,629,272.27 11,274,407.35
020-3020 FUND BAL.-GRANTS/CONT.CAP 0.00 2,611,136.11
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 5,629,272.27 0.00 0.00 13,885,543.46
============== ============== ============== ==============
REVENUES
========
020-4-002-4440 SALE OF CITY PROPERTY 1,174.80 0.00
020-4-002-4608 FIT CENTER EMPLOYEE DEDUCTION 285.21 0.00
020-4-011-4011 RESIDENTIAL IN TOWN 176,490.11 1,444,567.67
020-4-011-4101 RESIDENTIAL OUT OF TOWN 35,145.23 239,618.55
020-4-011-4201 COMMERCIAL IN TOWN 41,077.79 432,831.04
020-4-011-4301 COMMERCIAL OUT TOWN 2,428.63 26,346.67
020-4-011-4601 TDC-ORIGINAL UNITS 56,602.34 579,088.82
020-4-011-4701 TDC - HUGHES 54,107.79 619,394.11
020-4-011-4790 TDC - WOODMAN/MURRY UNITS 35,504.67 361,415.19
020-4-012-4015 RESIDENTIAL 110,889.89 1,230,883.02
020-4-012-4215 COMMERCIAL 30,202.85 324,268.87
020-4-012-4601 TDC-ORIGINAL UNITS 40,216.96 415,101.72
020-4-012-4701 TDC - HUGHES 20,266.49 478,332.58
020-4-012-4703 TDC- MURRY & WOODMAN 27,779.30 274,891.92
020-4-013-4011 RESIDENTIAL IN TOWN GARBAGE 71,826.67 708,275.46
020-4-030-4020 COR.CITY O & M REIMB. 44,865.57 385,488.45
020-4-030-4031 FLAT O & M REIMBURSEMENT 5,437.80 48,979.35
020-4-030-4041 GROVE O & M REIMBURSEMENT 9,888.75 77,830.20
020-4-030-4050 MOUNTAIN O & M REIMB. 13,297.50 89,575.20
020-4-030-4061 FORT HOOD O & M PMT 21,056.49 226,018.17
020-4-030-4071 FT. GATES O & M PMT 21,907.80 162,615.60
020-4-030-4502 REIMBURSEMENT ON DAMAGES 3,888.61 44,969.02
020-4-030-4550 MISCELLANEOUS 0.00 9,152.27
020-4-030-4551 GRANTS RECEIVED 206,333.19 294,739.48
020-4-034-4042 TURN ONS (WATER) 638.54 6,383.54
020-4-034-4048 2020 WTR MTR BOND INT 16.47 200.27
020-4-034-4051 PENALTIES 6,739.65 75,200.01
020-4-034-4102 INSTALLATIONS 600.00 19,643.00
020-4-034-4151 MISC(TRANserv/OLDdelqBAL) 816.17 28.83
020-4-034-4202 REV.CorC BOND,RIGHTS 11,498.20 137,978.40
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 4
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
020-ENTERPRISE FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
020-4-034-4210 REV.FLT BONDS,RIGHTS 3,946.31 23,767.32
020-4-034-4220 REV.GRV BONDS,RIGHTS 1,963.27 23,559.25
020-4-034-4230 REV.MTN BONDS,RIGHTS 3,032.32 36,387.84
020-4-034-4240 REV.FT.G.BONDS,RIGHTS 5,815.87 69,790.34
020-4-034-4245 REV. FT HOOD BONDS 1,212.87 14,544.22
020-4-034-4351 TRANSF FROM OTHER FUNDS 404,083.15 408,067.42
020-4-037-4042 TURN ONS (SEWER) 462.00 4,879.00
020-4-037-4043 INTEREST 10,803.15 82,183.62
020-4-037-4045 INT TWDB SEWER ACCT 37,267.20 359,791.05
020-4-037-4046 FT HOOD RESERVE INT 47.39 576.08
020-4-037-4051 PENALTIES 2,425.94 26,229.12
020-4-037-4102 INSTALLATIONS 0.00 2,130.00
020-4-037-4523 FT HOOD BONDS 31,152.66 373,831.92
020-4-037-4524 FT HOOD USAGE 2,739.85 54,302.97
020-4-037-4525 FT HOOD RESERVE FND 0.00 1,178.90
020-4-037-4543 TDC REVENUE FOR BOND PYMT 60,155.01 415,310.02
020-4-037-4750 INTERGOVERNMENT REV. 0.00 15,900.00
020-4-038-4043 INTEREST 56.96 596.63
020-4-038-4051 PENALTIES 222.69 1,434.96
020-4-038-4550 MISCELLANEOUS 27.92 286.10
020-4-038-4650 OVER / SHORT 14.76 0.00
______________ ______________ ______________ ______________
TOTAL REVENUES 228,059.69 1,388,353.10 0.00 10,628,564.17
============== ============== ============== ==============
EXPENDITURES
============
020-5-226-20010 UTILITIES 54.64 0.00
020-5-240-10010 SALARIES 42,855.07 514,303.18
020-5-240-10020 OVERTIME-SALARIES 6,292.78 58,722.59
020-5-240-10050 RETIREMENT 6,543.92 83,921.15
020-5-240-10070 SOCIAL SECURITY 597.94 7,848.38
020-5-240-10075 LIFE INSURANCE EMPLOYER 82.99 904.29
020-5-240-20010 UTILITIES 1,562.71 18,873.95
020-5-240-20020 MAT., SUP., & PRINTING 1,196.61 18,047.32
020-5-240-20030 SCHOOL, TRAVEL & MEMBERSHIPS 300.00 5,484.25
020-5-240-20040 INSURANCE 11,890.92 79,885.61
020-5-240-20045 PROP, LIAB, WC INSURANCE 0.00 19,823.06
020-5-240-20050 MAILING EXPENSE 5,015.33 25,081.64
020-5-240-20090 EQUIPMENT PURCHASE 0.00 7,847.98
020-5-240-20110 UNIFORMS 0.00 5,693.08
020-5-240-20140 EQUIPMENT RENTAL 0.00 11,164.52
020-5-240-20170 CREDIT CARD SERV FEE 4,396.51 50,930.32
020-5-240-20230 VEHICLE LEASE 33,687.02 0.00
020-5-240-20231 VEHICLE LEASE INT 3,321.99 3,321.99
020-5-240-30010 GAS & OIL 3,653.26 34,101.11
020-5-240-30020 MISCELLANEOUS 1.21 8.57
020-5-240-30040 COLLECTION AGENCY EXPENSE 177.87 753.94
020-5-240-30070 MAINTENANCE AGREEMENT 15,254.19 56,892.53
020-5-240-30075 LAB FEES 0.00 2,940.00
020-5-240-30110 WATER METERS 1,558.06 22,021.24
020-5-240-40010 CAPITAL OUTLAY 175,521.31 0.00
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 5
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
020-ENTERPRISE FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
020-5-240-40040 CLFRF TRANCHE 1 EXP 223,705.84 0.00
020-5-240-50010 REPAIRS & MAINTENANCE 23,883.41 141,291.20
020-5-240-50025 VEHICLE OR EQUIP REP & MAINT 539.36 27,063.59
020-5-240-60065 2020 WTR MTR BONDS PRINC 125,000.00 0.00
020-5-240-60066 2020 WTR MTR BONDS INT 611.42 58,863.58
020-5-240-60077 BOND AGENT FEES 0.00 600.00
020-5-240-60090 DEPRECIATION EXPENSE 447,338.10 447,338.10
020-5-240-61215 BOND AGENT FEE-2011 0.00 200.00
020-5-240-61415 GRANT EXPS DISTRIBUTION 7,000.00 0.00
020-5-240-70010 INTEREST 50,090.75 50,090.75
020-5-242-10010 SALARIES 32,312.51 314,203.98
020-5-242-10020 OVERTIME-SALARIES 2,674.19 34,254.28
020-5-242-10050 RETIREMENT 3,889.80 50,171.20
020-5-242-10070 SOCIAL SECURITY 365.05 4,767.33
020-5-242-10075 LIFE INSURANCE EMPLOYER 51.60 550.40
020-5-242-10080 CONTRACT SERVICES 0.00 9,839.50
020-5-242-20010 UTILITIES 69,376.68 571,172.29
020-5-242-20020 MAT., SUP., & PRINTING 8,747.37 448,434.65
020-5-242-20030 SCHOOL, TRAVEL & MEMBERSHIPS 0.00 2,711.25
020-5-242-20040 INSURANCE 7,759.98 52,227.94
020-5-242-20045 PROP, LIAB, WC INSURANCE 0.00 19,885.71
020-5-242-20050 MAILING EXPENSE 9.73 3,402.04
020-5-242-20090 EQUIPMENT PURCHASE 0.00 16,841.36
020-5-242-20110 UNIFORMS 152.15 1,866.21
020-5-242-20140 EQUIPMENT RENTAL 0.00 116.50
020-5-242-20230 VEHICLE LEASE 29,385.48 16,041.85
020-5-242-20231 VEHICLE LEASE INT 3,905.44 3,905.44
020-5-242-30010 GAS & OIL 669.00 6,246.88
020-5-242-30070 MAINTENANCE AGREEMENT 1,544.00 29,499.00
020-5-242-30075 LAB FEES 1,312.77 9,927.04
020-5-242-30085 PERMIT FEES 0.00 8,791.31
020-5-242-30140 WATER RIGHTS 0.00 791,319.77
020-5-242-40010 CAPITAL OUTLAY 201,331.77 0.00
020-5-242-40027 ENERGY DEBT 43,845.65 17,846.74
020-5-242-50010 REPAIRS & MAINTENANCE 2,582.08 74,648.86
020-5-242-50025 VEHICLE OR EQUIP REP & MAINT 8,094.65 11,859.14
020-5-242-50030 BOND AGENT FEE 2011 0.00 200.00
020-5-242-50031 2011 WATER PLANT BOND PRIN 370,000.00 0.00
020-5-242-50032 2011 WATER PLANT BOND INT 12,505.53 97,331.03
020-5-242-60075 2017 BONDS-PRINCIPAL 230,000.00 0.00
020-5-242-60076 2017 BONDS INTEREST 613.62 157,027.38
020-5-242-60077 2017 BOND AGENT FEES 0.00 200.00
020-5-242-60090 DEPRECIATION EXPENSE 582,208.71 582,208.71
020-5-242-61415 GRANT EXPS PRODUCTION 23,120.00 0.00
020-5-245-10010 SALARIES 35,392.46 353,405.94
020-5-245-10020 OVERTIME-SALARIES 5,862.18 48,454.79
020-5-245-10050 RETIREMENT 4,429.19 56,180.85
020-5-245-10070 SOCIAL SECURITY 483.40 6,247.36
020-5-245-10075 LIFE INSURANCE EMPLOYER 51.60 567.60
020-5-245-10080 CONTRACT SERVICES 0.00 2,500.00
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 6
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
020-ENTERPRISE FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
020-5-245-20010 UTILITIES 16,892.28 206,874.44
020-5-245-20020 MAT., SUP., & PRINTING 431.01 32,458.35
020-5-245-20023 CHEMICALS-STILLHOUSE PLANT 5,818.18 45,843.14
020-5-245-20026 CHEMICALS-LEON PLANT 6,207.55 47,411.01
020-5-245-20027 MAT & SUPP-STILLHOUSE PLANT 743.35 19,981.15
020-5-245-20028 MAT & SUPPL-LEON PLANT 6,218.91 28,944.91
020-5-245-20030 SCHOOL, TRAVEL & MEMBERSHIPS 92.55 3,540.54
020-5-245-20040 INSURANCE 6,356.12 42,605.03
020-5-245-20045 PROP, LIAB, WC INSURANCE 0.00 18,841.81
020-5-245-20050 MAILING EXPENSE 0.00 72.62
020-5-245-20090 EQUIPMENT PURCHASE 21,190.00 20,176.19
020-5-245-20110 UNIFORMS 0.00 1,418.02
020-5-245-20140 EQUIPMENT RENTAL 0.00 241.20
020-5-245-20230 VEHICLE LEASE 125.33 16,041.85
020-5-245-20231 VEHICLE LEASE INT 1,205.68 1,205.68
020-5-245-30010 GAS & OIL 1,284.21 13,244.57
020-5-245-30020 MISCELLANEOUS 0.00 31.91
020-5-245-30070 MAINTENANCE AGREEMENT 0.00 6,284.00
020-5-245-30076 LAB FEES-STILLHOUSE PLANT 8,535.00 30,307.67
020-5-245-30077 LAB FEES-LEON PLANT 6,751.00 29,697.67
020-5-245-30085 PERMIT FEES 2,015.00 32,867.95
020-5-245-30152 CONTRACT BILLING 477.83 5,192.25
020-5-245-40010 CAPITAL OUTLAY 197,770.80 0.00
020-5-245-50010 REPAIRS & MAINTENANCE 133.38 91,561.46
020-5-245-50016 FT HOOD EXPENSES 0.00 12,253.98
020-5-245-50020 REPAIRS & MAINT-STILLHOUSE PL 0.00 7,678.72
020-5-245-50022 REPAIRS & MAINT-LEON PLANT 895.01 5,042.15
020-5-245-50025 VEHICLE OR EQUIP REP & MAINT 439.86 10,988.18
020-5-245-50029 ENGINEERING 8,632.50 25,090.06
020-5-245-50050 LIFT STATION REPAIRS & MAINT 267.73 18,754.67
020-5-245-60071 2019 TWDB BONDS PRINCIPAL 475,000.00 0.00
020-5-245-60072 2019 TWDB BONDS INT 153.34 81,700.66
020-5-245-60090 DEPRECIATION EXPENSE 590,970.69 590,970.69
020-5-245-61211 BOND AGENT FEES-2007 0.00 200.00
020-5-245-61212 2019 BOND AGENT FEES 0.00 200.00
020-5-245-61220 2020 BONDS PRINCIPAL 320,000.00 0.00
020-5-245-61221 2020 BONDS INTEREST 702.26 19,756.94
020-5-245-61415 GRANT EXPS SEWER 195,508.34 0.00
020-5-250-30041 GARBAGE COLL. EXP. 67,804.42 695,135.42
020-5-250-30152 CONTRACT BILLING 477.82 5,192.25
020-5-250-30154 RECYCLING PROGRAM 0.00 12,147.14
020-5-260-60010 TRANSFER TO/FROM GENERAL 41,724.72 500,696.64
020-5-260-60100 FRANCHISE FEES 40,458.22 475,791.81
020-5-260-60102 TRANSFER TO OTHER FUNDS 0.00 182,490.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 2,225,946.04 2,674,146.85 8,881,763.13 16,041.85
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 11,300,360.88 11,300,360.88 91,949,754.64 91,949,754.64
============== ============== ============== ==============
*** END OF REPORT ***
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
022-MUNICIPAL COURT SECURITY
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
022-1001 CLAIM ON CASH 2,175.57 78,680.59
022-1046 CASH-COURT TECHN 0.02 0.00
022-1048 CASH-TRUANCY PREV & DIVERSN 0.29 0.00
022-1049 CASH-COURT JUROR REIMB ACCT 0.12 0.00
022-1050 CASH-PD FORFEITED FND 0.39 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 2,175.88 0.51 78,680.59 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
022-3000 FUND BALANCE 0.00 59,886.37
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 59,886.37
============== ============== ============== ==============
REVENUES
========
022-4-001-4341 TECHNOLOGY FINES @COURT 532.27 4,841.73
022-4-001-4342 COURT BLDG SECUR.FINES 648.39 5,842.61
022-4-001-4344 TRUANCY PREVENT & DIVERSION 654.69 5,817.70
022-4-001-4345 TIME PAYMENT FEES 316.13 3,439.89
022-4-001-4350 MUN JUROR REIMB OR SERVICES 13.13 116.32
022-4-001-4400 INTEREST 10.76 112.36
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 2,175.37 0.00 20,170.61
============== ============== ============== ==============
EXPENDITURES
============
022-5-002-20185 COURTROOM SECURITY 0.00 1,376.39
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 1,376.39 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 2,175.88 2,175.88 80,056.98 80,056.98
============== ============== ============== ==============
*** END OF REPORT ***
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
023-DONATIONS
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
023-1001 CLAIM ON CASH 4,476.61 48,744.24
______________ ______________ ______________ ______________
TOTAL ASSETS 4,476.61 0.00 48,744.24 0.00
============== ============== ============== ==============
LIABILITIES
===========
023-2011 A/P PENDING 2,897.33 4,187.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 2,897.33 0.00 4,187.00
============== ============== ============== ==============
FUND BALANCE
============
023-3000 EQUITY 0.00 39,438.66
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 39,438.66
============== ============== ============== ==============
REVENUES
========
023-4-001-4103 ANIMAL SHELTER DONATIONS 10,800.00 30,871.14
023-4-001-4108 REVENUE FOR BOOZAAR 0.00 850.00
023-4-001-4207 KEEP GATESVILLE BEAUTIFUL 0.00 200.00
023-4-001-4332 POLICE DEPT DONATIONS 0.00 7,685.35
023-4-001-4538 EARTH DAY DONATIONS 0.00 2,689.76
023-4-001-4544 CVB EVENTS 1,970.00 4,020.00
023-4-001-4548 RECREATION DONATIONS 0.00 18,715.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 12,770.00 0.00 65,031.25
============== ============== ============== ==============
EXPENDITURES
============
023-5-002-20506 KEEP GATESVILLE BEAUTIFUL 0.00 982.85
023-5-002-30100 TRANSFER TO OTHER FUNDS 0.00 2,410.00
023-5-002-40320 BOOZAAR EXPENSES 0.00 1,515.11
023-5-002-40544 CVB EVENT EXPENSES 6,452.00 6,452.00
023-5-002-60607 POLICE DONATION EXP 768.82 17,809.59
023-5-002-60609 EXP-DONATED RECREATION F 0.00 15,962.02
023-5-002-60610 ANIMAL SHELTER EXP 3,969.90 12,810.33
023-5-002-60618 EXPENSES FOR EARTH DAY 0.00 1,970.77
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 11,190.72 0.00 59,912.67 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 15,667.33 15,667.33 108,656.91 108,656.91
============== ============== ============== ==============
*** END OF REPORT ***
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
024-PUBLIC SAFETY FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
024-1001 CLAIM ON CASH 0.00 2,951.55
024-1050 CASH-PD FORFEITED FND 0.99 0.00
024-1056 CASH PD SEIZED FUNDS 0.00 33,273.63
______________ ______________ ______________ ______________
TOTAL ASSETS 0.99 0.00 36,225.18 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
024-3000 EQUITY 0.00 38,815.51
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 38,815.51
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
024-5-002-20305 PD USE OF FORFEITED FUNDS 0.99 2,590.33
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.99 2,590.33 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.99 0.99 38,815.51 38,815.51
============== ============== ============== ==============
*** END OF REPORT ***
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
034-FIREMEN'S TRUST
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
034-1000 CASH-FIREMAN'S TRUST 91.72 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 91.72 0.00 0.00 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
034-3000 FUND BALANCE 91.72 0.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 91.72 0.00 0.00
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 91.72 91.72 0.00 0.00
============== ============== ============== ==============
*** END OF REPORT ***
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
040-MOTEL OCCUPANCY
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
040-1001 CLAIM ON CASH 7,483.57 509,188.67
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 7,483.57 509,188.67 0.00
============== ============== ============== ==============
LIABILITIES
===========
040-2011 A/P PENDING 49,343.27 6,793.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 49,343.27 0.00 0.00 6,793.00
============== ============== ============== ==============
FUND BALANCE
============
040-3000 FUND BALANCE 0.00 268,916.07
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 268,916.07
============== ============== ============== ==============
REVENUES
========
040-4-008-4400 INTEREST 72.45 708.56
040-4-008-4950 HOTEL OCCUPANCY TAX 50,419.50 319,367.76
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 50,491.95 0.00 320,076.32
============== ============== ============== ==============
EXPENDITURES
============
040-5-138-60010 TRANSFER TO/FROM GENERAL 1,200.00 0.00
040-5-138-60065 NOTE PRINCIPLE 4.75 51,476.00
040-5-138-60066 NOTE INTEREST 4.75 3,560.27
040-5-138-61000 CVB CENTER EXPENSES 1,200.00 9,850.00
040-5-138-61010 ADVERTISING 7,932.25 20,703.20
040-5-138-61020 PROMOTION OF THE ARTS 700.00 1,007.25
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 9,837.00 1,204.75 86,596.72 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 59,180.27 59,180.27 595,785.39 595,785.39
============== ============== ============== ==============
*** END OF REPORT ***
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
050-CEMETERY MAINTENANCE
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
050-1001 CLAIM ON CASH 11,945.00 58,734.52
050-1992 DUE FROM 11,945.00 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 11,945.00 11,945.00 58,734.52 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
050-3000 FUND BALANCE 0.00 41,234.52
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 41,234.52
============== ============== ============== ==============
REVENUES
========
050-4-002-4350 SALE OF CEMETERY LOTS 2,000.00 19,500.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 2,000.00 0.00 19,500.00
============== ============== ============== ==============
EXPENDITURES
============
050-5-110-20025 CEMETERY MATERIALS & SUPPLIES 2,000.00 2,000.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 2,000.00 0.00 2,000.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 13,945.00 13,945.00 60,734.52 60,734.52
============== ============== ============== ==============
*** END OF REPORT ***
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
053-2011 WTR PLANT MDRN
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
053-1120 CASH-2011 WTR I&S 2,144.40 0.00
053-1900 DEF INC AMORTIZATION 164,666.33 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 2,144.40 164,666.33 0.00 0.00
============== ============== ============== ==============
LIABILITIES
===========
053-2240 BONDS PAYABLE 5,415,000.00 0.00
053-2245 CURR.MATUR's LT DEBT 370,000.00 0.00
053-2360 ACCRUED INT. PAYABLE 6,795.41 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 5,791,795.41 0.00 0.00 0.00
============== ============== ============== ==============
FUND BALANCE
============
053-3000 FUND BALANCE 5,629,273.48 0.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 5,629,273.48 0.00 0.00
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 5,793,939.81 5,793,939.81 0.00 0.00
============== ============== ============== ==============
*** END OF REPORT ***
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
055-LBW CAP PROJ FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
055-1181 PREMIUM ON 86 BONDS 0.11 0.00
055-1191 PREMIUM ON 85 BONDS 0.41 0.00
055-1501 ORIGINAL ISSUE COST 0.07 0.00
055-1511 AMORT.OF ORIG.ISS.DISCNT 0.17 0.00
055-1601 ISSUE COST ON 92 BONDS 0.42 0.00
055-1651 ISSUE COSTS ON 96 SERIES 0.35 0.00
055-1661 DISCOUNT 96 FOR 92 BONDS 0.10 0.00
055-1663 DEFER'D COST ADVAN.REFUND 0.09 0.00
055-1901 ACCUMULATIVE AMORTIZATION 0.06 0.00
055-1910 ACCUM. AMORT. 0.48 0.00
055-1911 ACCUM.DEPREC.OID 96series 0.16 0.00
055-1912 ACCUM.DEPREC.IssueCost96 0.09 0.00
055-1913 ACCUM.DEPREC.DeferCost92s 0.42 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 1.40 1.53 0.00 0.00
============== ============== ============== ==============
LIABILITIES
===========
055-2050 PAYBLEtoCorC.-BONDacctINT 0.41 0.00
055-2061 PAYBLEtoFLAT BONDacct INT 0.46 0.00
055-2070 PAYABLEtoFT.G.BONDacctINT 0.35 0.00
055-2081 PAYBLEtoGROVE BONDacctINT 0.01 0.00
055-2091 PAYABLEtoMNTN BONDacctINT 0.45 0.00
055-2151 PAYABLEtoCOR.C.RESacctINT 0.48 0.00
055-2161 PAYABLEtoFLAT RES.acctINT 0.49 0.00
055-2171 PAYABLEtoFT.G. RESacctINT 0.24 0.00
055-2181 PAYABLEtoGROVE RESacctINT 0.32 0.00
055-2191 PAYABLEtoMNTN RESacct INT 0.40 0.00
055-2240 BONDS PAYABLE 0.49 0.00
055-2301 DEFERR. INC.-CORYELL CITY 0.06 0.00
055-2310 DEFERR. INC. - FLAT 0.20 0.00
055-2320 DEFERR. INC. - FT. GATES 0.06 0.00
055-2330 DEFERR. INC. - THE GROVE 0.09 0.00
055-2340 DEFERR. INC. - MOUNTAIN 0.30 0.00
055-2350 DEFERR. INC. - FT. HOOD 0.15 0.00
055-2401 DEFERR.INC. AMORTIZATION 0.28 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 2.08 3.16 0.00 0.00
============== ============== ============== ==============
FUND BALANCE
============
055-3000 FUND BALANCE 1.21 0.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 1.21 0.00 0.00 0.00
============== ============== ============== ==============
11-17-2023 12:11 PM CITY OF GATESVILLE PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
055-LBW CAP PROJ FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 4.69 4.69 0.00 0.00
============== ============== ============== ==============
*** END OF REPORT ***
11-17-2023 12:12 PM CITY OF GATESVILLE PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
060-AIRPORT FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
060-1001 CLAIM ON CASH 4,427.64 124,803.51
060-1401 LEASE RECEIVABLE 22,381.57 0.00
060-1610 LAND & LAND RIGHTS 0.00 16,000.00
060-1620 IMPROVEMENTS 13,500.87 967,585.75
060-1640 ACCUMULATED DEPRECIATION 34,901.56 265,328.56
______________ ______________ ______________ ______________
TOTAL ASSETS 17,928.51 57,283.13 1,108,389.26 265,328.56
============== ============== ============== ==============
LIABILITIES
===========
060-2011 A/P PENDING 0.00 100.00
060-2013 A/R - PREPAID ITEMS 1,095.00 275.00
060-2182 Deferred Inflow of Resources 22,287.08 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 23,382.08 0.00 275.00 100.00
============== ============== ============== ==============
FUND BALANCE
============
060-3000 FUND BALANCE 0.00 868,539.95
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 868,539.95
============== ============== ============== ==============
REVENUES
========
060-4-011-4302 RECEIPTS OF HANGAR RENTAL 4,375.00 41,700.00
060-4-011-4400 INTEREST 76.35 90.81
060-4-011-4600 GRANT REIMBURSEMENTS 0.00 81,642.99
060-4-101-4203 RECEIPTS OF GAS/OIL SALE 1,946.88 19,473.60
______________ ______________ ______________ ______________
TOTAL REVENUES 76.35 6,321.88 0.00 142,907.40
============== ============== ============== ==============
EXPENDITURES
============
060-5-150-10080 CONTRACT SERVICES 100.00 1,143.29
060-5-150-20010 UTILITIES 627.50 6,955.54
060-5-150-20020 MAT., SUP., & PRINTING 0.00 204.00
060-5-150-20040 INSURANCE 0.00 924.00
060-5-150-20045 PROP., LIAB., WC INSURANCE 0.00 2,688.11
060-5-150-20170 CREDIT CARD SVC FEE 62.95 563.14
060-5-150-30010 GAS & OIL 0.00 446.30
060-5-150-30015 FUEL FOR RESALE 0.00 8,559.29
060-5-150-30020 MISCELLANEOUS 0.00 50.00
060-5-150-30070 MAINTENANCE AGREEMENT 0.00 5,966.00
060-5-150-40010 CAPITAL OUTLAY 13,500.00 0.00
060-5-150-50010 REPAIRS & MAINTENANCE 26.06 2,310.42
060-5-150-60090 DEPRECIATION EXP. 34,901.56 34,901.56
11-17-2023 12:12 PM CITY OF GATESVILLE PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
060-AIRPORT FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
060-5-150-61415 GRANT EXPENDITURES 0.00 103,500.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 35,718.07 13,500.00 168,211.65 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 77,105.01 77,105.01 1,276,875.91 1,276,875.91
============== ============== ============== ==============
*** END OF REPORT ***
11-17-2023 12:12 PM CITY OF GATESVILLE PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
077-GRANT FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
077-1001 CLAIM ON CASH 170.49 361,042.24
077-1100 2021 CLFR FUNDS 193,747.26 1,083,914.25
______________ ______________ ______________ ______________
TOTAL ASSETS 170.49 193,747.26 1,444,956.49 0.00
============== ============== ============== ==============
LIABILITIES
===========
077-2190 DEFERRED INCOME - GRANT 199,230.48 1,006,601.43
______________ ______________ ______________ ______________
TOTAL LIABILITIES 199,230.48 0.00 0.00 1,006,601.43
============== ============== ============== ==============
FUND BALANCE
============
077-3000 FUND BALANCE 0.00 376,927.45
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 376,927.45
============== ============== ============== ==============
REVENUES
========
077-4-001-4300 GRANT REVENUES RECIEVED 199,230.48 416,540.81
077-4-001-4336 PD GRANT FUNDS 0.00 1,677.75
077-4-001-4338 PD LEOSE FUNDS 0.00 1,830.27
077-4-001-4400 INTEREST 5,483.22 67,166.27
077-4-001-4531 TSLAC GRANT REVENUE 2,071.10 2,071.10
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 206,784.80 0.00 489,286.20
============== ============== ============== ==============
EXPENDITURES
============
077-5-002-40021 TSLAC LIBRARY GRANT EXP 2,071.10 2,071.10
077-5-002-40023 LIBRARY GRANT EXPENSE 227.49 0.00
077-5-002-40046 FEMA FAUNTLEROY 0.00 3,103.11
077-5-002-40048 EPA BROWNFIELDS 57.00 14,616.96
077-5-002-40050 TRANSFER TO OTHER FUNDS 199,230.48 408,067.42
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 201,358.58 227.49 427,858.59 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 400,759.55 400,759.55 1,872,815.08 1,872,815.08
============== ============== ============== ==============
*** END OF REPORT ***
11-17-2023 12:12 PM CITY OF GATESVILLE PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
088-DEBT SERVICE FUND
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
088-1001 CLAIM ON CASH 903.49 32,454.34
088-1227 DELIQUENT AV TAXES REC I&S 1,719.60 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 2,623.09 0.00 32,454.34 0.00
============== ============== ============== ==============
LIABILITIES
===========
088-2180 DEFERRED INCOME - TAXES I & S 1,719.60 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 1,719.60 0.00 0.00
============== ============== ============== ==============
FUND BALANCE
============
088-3000 FUND BALANCE 0.00 22,005.67
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 22,005.67
============== ============== ============== ==============
REVENUES
========
088-4-800-3879 CURRENT PROPERTY TAXES I&S 394.14 180,480.95
088-4-800-3880 DELIQUENT PROPERTY TAXES I & S 384.90 6,070.25
088-4-800-4060 A V TAX PENALTY/INTEREST I&S 124.45 3,310.85
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 903.49 0.00 189,862.05
============== ============== ============== ==============
EXPENDITURES
============
088-5-001-60001 DEBT SERVICE-PRINCIPAL 0.00 160,000.00
088-5-001-60002 DEBT SERVICE-INTEREST 0.00 19,413.38
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 179,413.38 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 2,623.09 2,623.09 211,867.72 211,867.72
============== ============== ============== ==============
*** END OF REPORT ***
11-17-2023 12:12 PM CITY OF GATESVILLE PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
090-CAP PROJ FUND-GEN
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
090-1001 CLAIM ON CASH 730,104.10 1,466,897.31
______________ ______________ ______________ ______________
TOTAL ASSETS 730,104.10 0.00 1,466,897.31 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
090-3000 FUND BALANCE 0.00 792,478.57
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 792,478.57
============== ============== ============== ==============
REVENUES
========
090-4-001-4351 TRANSF FROM OTHER FUNDS 730,000.00 730,000.00
090-4-001-4400 INTEREST 104.10 1,210.71
090-4-001-4611 LOAN PROCEEDS 0.00 650,000.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 730,104.10 0.00 1,381,210.71
============== ============== ============== ==============
EXPENDITURES
============
090-5-110-40010 CAPITAL OUTLAY 0.00 684,938.37
090-5-128-40010 CAPITAL OUTLAY 0.00 21,853.60
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 706,791.97 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 730,104.10 730,104.10 2,173,689.28 2,173,689.28
============== ============== ============== ==============
*** END OF REPORT ***
11-17-2023 12:12 PM CITY OF GATESVILLE PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
091-CAP PROJ FUND-W&S
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
091-1001 CLAIM ON CASH 130,489.02 136,761.25
091-1650 CONTRUCTION IN PROGRESS 425,486.96 691,153.42
______________ ______________ ______________ ______________
TOTAL ASSETS 425,486.96 130,489.02 827,914.67 0.00
============== ============== ============== ==============
LIABILITIES
===========
091-2011 A/P PENDING 3,137.01 3,137.01
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 3,137.01 0.00 3,137.01
============== ============== ============== ==============
FUND BALANCE
============
091-3000 FUND BALANCE 0.00 641,627.15
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 641,627.15
============== ============== ============== ==============
REVENUES
========
091-4-001-4351 TRANSF FROM OTHER FUNDS 0.00 182,490.00
091-4-001-4400 INTEREST 34.08 660.51
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 34.08 0.00 183,150.51
============== ============== ============== ==============
EXPENDITURES
============
091-5-245-40020 STILLHOUSE PLANT UPGRADES 291,826.85 0.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 291,826.85 0.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 425,486.96 425,486.96 827,914.67 827,914.67
============== ============== ============== ==============
*** END OF REPORT ***
11-17-2023 12:12 PM CITY OF GATESVILLE PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
800-LONG TERM DEBT
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
800-1401 LEASES RECEIVABLE 0.00 0.17
800-1851 Def Outflow OPEB SDBF contrib 0.00 2,521.00
800-1852 Def Outflow-Diff assump SDBF 0.00 34,857.00
800-1855 DI SDBF DIFF EXP 0.00 18,598.00
800-1858 DO OPEB CONTRIB 0.00 12,962.00
800-1859 DI OPEB CHANGES 0.00 19,526.00
800-1860 DI OPEB DIFF 0.00 10,772.00
800-1861 DO PENSION CHANGES 0.00 24,893.00
800-1862 DO PENSION CONTRIB 0.00 323,786.00
800-1863 DI PENSION INVESTMENT 0.00 941,641.00
800-1864 DI PENSION ACCT DIFF 0.00 46,847.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 445,866.17 990,537.00
============== ============== ============== ==============
LIABILITIES
===========
800-2006 LEASE LIABILITY 159,356.57 283,109.30
800-2011 COMPENSATED ABSENCES PAYABLE 0.00 232,240.64
800-2182 Deferred Inflow of Resources 0.00 0.17
800-2418 Notes Payable 87,057.52 45,743.88
800-2419 Current Portion of Notes Payab 1,691.98 87,056.68
800-2420 LEASES PAYABLE 122,669.86 351,946.19
800-2421 CURRENT PORTION LEASE PAYABLE 24,995.38 122,669.86
800-2601 Bonds Payable - General Obliga 165,000.00 0.00
800-2605 Current Portion - General Obli 5,000.00 165,000.00
800-2610 ACCRUED INTEREST PAYABLE 26,824.25 28,502.94
800-2611 Bond Payable - Tax Notes 575,000.00 575,000.00
800-2612 Current Portion - Tax Notes 100,000.00 100,000.00
800-2950 Net Pension Liability 0.00 761,082.00
800-2951 OPEB SDBF Liability 0.00 232,677.00
800-2952 OPEB LIABILITY 0.00 189,321.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 535,775.93 731,819.63 0.00 3,174,349.66
============== ============== ============== ==============
FUND BALANCE
============
800-3000 FUND BALANCE 196,043.70 3,719,020.49
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 196,043.70 0.00 3,719,020.49 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 731,819.63 731,819.63 4,164,886.66 4,164,886.66
============== ============== ============== ==============
*** END OF REPORT ***
11-17-2023 12:12 PM CITY OF GATESVILLE PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
900-CAPITAL ASSET GROUP
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
900-1610 LAND 0.00 636,543.00
900-1620 IMPROVEMENTS 706,792.00 9,772,007.72
900-1630 MACHINERY & EQUIPMENT 46,811.00 4,737,401.14
900-1635 LEASE ASSET 83,392.05 528,434.44
900-1640 ACCUMULATED DEPRECIATION 507,910.00 8,807,267.83
900-1650 CONSTRUCTION IN PROGRESS 0.00 84,846.42
900-1670 ACCUM.AMORTIZATION 85,450.39 315,734.15
______________ ______________ ______________ ______________
TOTAL ASSETS 753,603.00 676,752.44 15,759,232.72 9,123,001.98
============== ============== ============== ==============
FUND BALANCE
============
900-3000 FUND BALANCE 76,850.56 6,636,230.74
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 76,850.56 0.00 6,636,230.74
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 753,603.00 753,603.00 15,759,232.72 15,759,232.72
============== ============== ============== ==============
*** END OF REPORT ***
11-17-2023 12:12 PM CITY OF GATESVILLE PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
999-POOLED CASH
******* MONTH TO DATE ******* ******** YEAR TO DATE *******
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
999-1000 POOLED CASH 72,574.31 4,425,291.68
999-1901 DUE FROM GENERAL FUND 60,328.92 159,098.06
999-1902 DUE FROM WATER & SEWER 340,815.56 652,156.06
999-1923 DUE FROM DONATIONS 2,897.33 4,187.00
999-1940 DUE FROM HOT FUNDS 49,343.27 6,793.00
999-1960 DUE FROM AIRPORT 0.00 100.00
999-1991 DUE FROM W&S CAP PROJ FUND 3,137.01 3,137.01
______________ ______________ ______________ ______________
TOTAL ASSETS 346,849.90 182,246.50 5,250,762.81 0.00
============== ============== ============== ==============
LIABILITIES
===========
999-2000 ACCOUNTS PAYABLE CONTROL 237,177.71 825,471.13
999-2151 BANK ADJUSTMENTS 406.90 0.00
999-2162 WAGES PAYABLE 101,836.48 101,836.48
999-2900 DUE TO OTHER FUNDS 174,003.89 4,323,455.20
______________ ______________ ______________ ______________
TOTAL LIABILITIES 174,410.79 339,014.19 0.00 5,250,762.81
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 521,260.69 521,260.69 5,250,762.81 5,250,762.81
============== ============== ============== ==============
*** END OF REPORT ***