Import e951bb4e-fd3b-4e97-a608-b0ec099176a4
Download
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 1
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
ASSETS
======
1001 CLAIM ON CASH 972,770.69 1,825,818.24
1004 CLAIM ON CASH (EBT) 0.00 0.01
1005 HEALTH REIMB ARRANGEMENT ACCT 0.00 1,375.00
1014 PETTY CASH 0.00 3,174.15
1023 TEXPOOL 516,329.92 0.00
1024 TEXSTAR 317,063.79 2,701.19
1027 PINNACLE BANK 12 MO CD 756.19 130,711.02
1042 THE COMUNITY BANK-OCT MAT 0.00 104,066.75
1043 EECU - CD - NOV MATURITY 284.17 111,815.12
1050 TEXPOOL - RESTRICTED 0.00 115,627.66
1107 ACCRUED INTEREST RECEIVABLE 132.49 0.00
1110 NSF FEE RECEIVABLE 70.00 0.00
1111 SANITATION ACCOUNTS RECEIVABLE 897.27 39,740.26
1112 SANITATION TAX ACCTS RECEIVABL 73.88 3,266.91
1116 SANITATION ALLOWANCE FOR DOUBT 1,437.13 11,276.57
1119 ALLOWANCE FOR DOUBTFUL ACCTS 68.21 5,690.73
1120 TAXES RECEIVABLE(AD VALOREM) 327.52 27,324.76
1121 FRANCHISE TAX RECEIVABLE 0.00 203,163.93
1122 MUNICIPAL COURT FINES RECEIVAB 76,861.82 1,033,110.12
1123 ALLOWANCE FOR UNCOLL COURT FEE 61,489.46 826,653.56
1127 WATER TOWER - LEASE REC 21,701.91 202,557.75
1147 DUE FROM STATE(SALES TAX) 15,339.52 444,819.20
1408 PRE-PAID EXPENSES 28,835.45 0.00
1409 PREPAID POSTAGE 814.54 0.00
LIABILITIES AND FUND BALANCE
============================
2002 AP PENDING (DUE TO POOL CASH) 153,862.94 177,407.43
2008 SALES TAX PAYABLE 0.36 3,550.75
2009 CASH BONDS PAYABLE 245.10 0.00
2011 STATE SALES TAX PAYABLE 15.59 0.00
2012 YARD SALE SIGN DEP PAYABLE 72.50 0.00
2013 HEALTH INSPECTOR PAYABLE 35.00 0.00
2016 STATE-TIME PAY 1 51.99 0.00
2018 STATE FEES 10,808.05 31,823.65
2019 COURT OVERPAYMENT 427.50 0.00
2020 COLAGY 285.31 2,334.02
2030 PARK/TABERNACLE BRICKS PAYBL 0.00 3,668.00
2031 SPLASH PARK VENDING REFUND 6.00 0.00
2041 LIBRARY FINES PAYBL/RECVBL 38.98 0.00
2044 DEVELOPER ESCROW PAYABLE 369.00 0.00
2046 K-9 PROGRAM 0.00 7,285.20
2047 DEFERRED REVENUE 259.31 21,634.03
2049 DEFERED FRANCHISE TAX REC 0.00 12,909.17
2050 DEFERRED MUNICIPAL COURT REV 15,372.36 206,663.38
2052 DEFRRED REVENUE - TOWER LEASE 21,701.91 202,557.75
2061 VOLUNTEER CONTRIBUTION PAYABLE 876.00 0.00
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 2
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
LIABILITIES AND FUND BALANCE (CONT.)
====================================
2070 MISCELLANEOUS PAYABLES 13,652.90 0.00
2080 SANITATION PAYABLE 20,128.60 0.00
2205 WAGES PAYABLE 1,690.03 96,583.21
2207 RANK/ LONGEVITY PAY ACCRUAL 2,310.00 11,130.00
2209 LIFE INSURANCE PAYABLE 141.67 0.00
2230 LEGALSHIELD PAYABLE 19.30 0.00
2240 HEALTH INSURANCE PAYABLE 707.08 0.00
2241 DENTAL INSURANCE PAYABLE 261.64 0.00
3109 NET FUND BALANCE 4.37 2,584,730.00
REVENUES
=========
400-01-008 M & O CURRENT TAXES 631.16 1,022,973.89
400-01-010 M & O DELINQUENT PEN & INT 5.66 2,894.21
400-01-011 M & O DELINQUENT TAXES 19.44 11,206.13
400-01-014 M & O CURRENT PEN & INT 101.10 6,614.66
400-01-016 ALCOHOLIC BEVERAGE SALES TAX 750.02 8,534.53
400-01-017 STATE SALES TAX 229,745.91 2,552,630.20
400-01-020 ROYALTY 0.00 1,593.75
400-01-023 ELECTRIC - FRANCHISE 0.00 197,246.65
400-01-024 GAS - FRANCHISE 0.00 21,155.20
400-01-029 TELECOMMUNICATIONS - FRANCHISE 0.00 4,197.78
400-01-031 TOWER - FRANCHISE 13,718.29 24,101.91
400-01-032 CABLE - FRANCHISE 0.00 20,296.86
400-10-102 MECHANICAL REGISTRATION/PERMIT 730.72 5,114.86
400-10-103 PLUMBING REGISTRATION/PERMIT 451.00 17,308.46
400-10-104 POOL AND SPA PERMIT 0.00 1,250.00
400-10-105 BUILDING PERMIT 113,870.70 437,411.80
400-10-106 ELECTRICAL REGISTRATION/PERMIT 175.00 11,436.25
400-10-107 SOLICITOR PERMIT 0.00 350.00
400-10-108 CERTIFICATE OF OCCUPANCY 175.00 2,275.00
400-10-110 HEALTH PERMIT FEE 600.00 29,572.50
400-10-111 YARD SALE PERMIT 70.50 775.50
400-10-114 MISCELLANEOUS PERMIT 23.50 21,252.39
400-10-118 ROOFING PERMIT 0.00 1,400.00
400-20-205 ZONING REQUEST FEE 0.00 1,850.00
400-20-206 PLATTING FEES 315.00 8,935.00
400-20-208 CUSTOMER NSF FEE 0.00 630.00
400-20-211 SANITATION REVENUE 2,207.16 72,729.46
400-20-220 ANIMAL CONTROL 250.00 3,470.12
400-20-221 ANIMAL CONTROL DONATIONS 103.00 3,522.27
400-20-229 ACCIDENT REPORTS 66.00 868.42
400-20-230 IMPOUND FEES 1,160.00 14,184.26
400-23-233 ARREST FEE 500.18 5,764.40
400-23-235 COURT ADMINISTRATION FEE 21,842.43 169,746.01
400-23-237 10% CITY PORTION-STATE REVENUE 0.00 7,868.69
400-23-238 WARRANT FEES 1,000.00 11,579.47
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 3
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
REVENUES (CONT)
===============
400-23-239 STF/CITY 5% PORTION 0.00 1,677.93
400-24-259 CITIZEN COLLECTION CENTER 123.00 1,099.00
400-30-306 LIBRARY BOOK GRANT 257.15 257.15
400-30-309 LIBRARY DONATIONS 0.00 5,000.00
400-30-311 LIBRARY FINES 283.39 2,293.01
400-40-405 INTEREST 28,636.96 65,198.76
400-40-406 TIMELY PAYMENT DISCOUNT 11.51 119.31
400-40-407 CREDIT/DEBIT PROCESSING FEES 4,294.42 38,579.23
400-40-420 RESERVATION FEES 5.00 2,605.00
400-40-431 SISD RESOURCE OFFICER 0.00 120,106.73
400-40-433 COURT ORDERED RESTITUTIONS 0.00 110.00
400-40-438 TABERNACLE RESTORATION DONATIO 568.00 2,708.00
400-40-440 INSURANCE CLAIMS 0.00 44,882.65
400-40-445 CHRISTMAS ON THE SQUARE 150.00 12,185.00
400-40-452 SPECIAL EVENT REVENUE 1,145.00 4,045.00
400-40-456 TICKETS FOR TOYS DONATIONS 0.00 440.00
400-40-458 POLICE DEPARTMENT DONATIONS 1,000.00 3,720.00
400-40-460 MISC. REVENUE 2,297.50 15,729.16
EXPENDITURES
=============
500-99-951 TRANSFER TO FUND 700 0.00 937,211.00
500-99-953 TRANSFER TO FUND 720 0.00 234,303.00
510-01-005 SALARIES 84,101.33 805,606.66
510-01-008 OVERTIME 5,215.13 58,174.70
510-01-010 CERTIFICATION PAY 300.02 5,123.30
510-01-011 LONGEVITY PAY 420.00 3,330.00
510-01-014 WORKER'S COMP INSURANCE 0.00 15,911.20
510-01-017 UNEMPLOYMENT EXPENSE 0.00 1,220.67
510-01-020 MEDICARE 1,002.00 12,152.46
510-01-023 RETIREMENT 6,928.47 84,088.63
510-01-026 FICA 72.97 730.33
510-01-030 PHYSICAL EXAM/DRUG SCREEN 621.06 2,279.59
510-01-032 PSYCHOLOGICAL TESTING 0.00 665.00
510-01-034 EAP 0.00 840.00
510-01-036 LIFE INSURANCE 142.38 1,721.60
510-01-037 DENTAL INSURANCE 352.22 4,322.70
510-01-038 HEALTH INSURANCE 8,517.16 87,402.54
510-01-039 VISION INSURANCE 90.00 886.26
510-01-040 LONG TERM DISABILITY 148.27 1,795.20
510-10-105 OFFICE SUPPLIES 523.21 2,863.16
510-10-107 OPERATIONS EQUIPMENT < 5000 12,238.55 50,047.52
510-10-108 POSTAGE 98.11 724.68
510-10-111 GAS AND OIL 7,205.75 37,210.77
510-10-120 PARTS FOR EQUIPMENT 135.55 163.86
510-10-123 FIELD INVESTIGATION 0.00 2,897.16
510-10-125 UNIFORMS 3,495.28 14,434.88
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 4
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
510-10-130 SAFETY EQUIPMENT 2,402.00 7,979.16
510-10-136 JANITORIAL SUPPLIES 119.90 577.99
510-10-147 MISC MATERIALS AND SUPPLIES 97.98 752.98
510-20-204 VEHICLE MAINTENANCE/REPAIR 2,956.31 12,837.85
510-20-214 CONTRACT LABOR 0.00 1,293.75
510-20-216 TOWING SERVICES 1,125.00 8,000.00
510-20-220 DUES AND SUBSCRIPTIONS 4,966.98 12,058.11
510-20-223 EQUIPMENT RENTAL 5,250.00 5,250.00
510-20-224 SERVICE/MAINT AGREEMENT 2,308.01 24,843.56
510-20-226 UTILITIES 905.79 4,917.26
510-20-227 INTERNET SERVICE PROVIDERS 720.00 3,909.00
510-20-229 TELEPHONE 494.48 4,046.77
510-20-230 BUILDING MAINTENACE/REPAIR 13.57 10,073.07
510-20-231 BUILDING MAINT SERVICES 33.34 1,900.61
510-20-234 BUSINESS EXPENSE 3.31 26.29
510-20-253 TRAINING AND TRAVEL 16,396.15 30,533.65
510-20-254 EXPLORER POST CONTRIBUTION 0.00 1,540.90
510-20-261 CAPITAL LEASE INTEREST EXP 1,039.68 1,039.68
510-20-262 LEASE PURCHASE 8,874.71 14,600.58
510-20-264 EQUIPMENT MAINTENANCE/REPAIR 238.00 1,104.42
510-20-274 INMATE HOUSING 423.00 1,198.50
510-20-286 LIABILITY INSURANCE 0.00 28,586.11
510-20-348 MISCELLANEOUS SERVICES 0.00 250.00
510-40-419 OPERATIONS EQUIPMENT > 5000 14,461.33 14,461.33
530-01-005 SALARIES 5,842.95 70,793.61
530-01-008 OVERTIME 101.39 1,231.71
530-01-010 CERTIFICATION PAY 46.16 553.92
530-01-011 LONGEVITY PAY 120.00 710.00
530-01-014 WORKER'S COMP INSURANCE 0.00 1,834.12
530-01-020 MEDICARE 72.77 972.04
530-01-023 RETIREMENT 555.80 7,273.70
530-01-030 PHYSICAL EXAM/DRUG SCREEN 0.00 50.00
530-01-034 EAP 0.00 84.00
530-01-036 LIFE INSURANCE 16.53 193.60
530-01-037 DENTAL INSURANCE 64.04 768.48
530-01-038 HEALTH INSURANCE 1,402.86 16,929.98
530-01-039 VISION INSURANCE 12.00 138.94
530-01-040 LONG TERM DISABILITY 17.18 200.42
530-10-105 OFFICE SUPPLIES 18.31 1,688.77
530-10-108 POSTAGE 33.39 371.28
530-10-125 UNIFORMS 180.76 180.76
530-10-136 JANITORIAL SUPPLIES 20.43 292.11
530-20-220 DUES AND SUBSCRIPTIONS 0.00 256.99
530-20-224 SERVICE/MAINT AGREEMENT 107.48 1,223.98
530-20-237 MUNICIPAL JUDGE 850.00 8,100.00
530-20-241 LEGAL 1,881.22 11,573.02
530-20-253 TRAINING AND TRAVEL 50.00 657.01
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 5
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
530-40-462 BUILDINGS 0.00 477.25
540-01-005 SALARIES 8,341.90 91,127.74
540-01-011 LONGEVITY PAY 400.00 680.00
540-01-014 WORKER'S COMP INSURANCE 0.00 1,875.56
540-01-020 MEDICARE 110.84 1,286.86
540-01-023 RETIREMENT 588.01 6,513.87
540-01-026 FICA 119.91 1,596.06
540-01-030 PHYSICAL EXAM/DRUG SCREEN 9.71 19.67
540-01-034 EAP 0.00 168.00
540-01-036 LIFE INSURANCE 9.56 111.36
540-01-037 DENTAL INSURANCE 32.02 384.24
540-01-038 HEALTH INSURANCE 701.43 8,169.24
540-01-039 VISION INSURANCE 6.00 69.47
540-01-040 LONG TERM DISABILITY 9.99 116.52
540-10-105 OFFICE SUPPLIES 265.02 1,624.11
540-10-107 OPERATIONS EQUIPMENT 0.00 8,029.36
540-10-108 POSTAGE 4.14 4.14
540-10-132 BOOKS 931.74 7,191.32
540-10-136 JANITORIAL SUPPLIES 137.79 336.20
540-10-147 MISC MATERIALS AND SUPPLIES 0.00 1,089.48
540-20-214 CONTRACT LABOR 0.00 86.25
540-20-220 DUES AND SUBSCRIPTIONS 1,231.61 9,602.71
540-20-224 SERVICE/MAINT AGREEMENT 3,340.27 14,591.97
540-20-226 UTILITIES 1,027.06 5,297.19
540-20-227 INTERNET SERVICE PROVIDERS 120.00 719.99
540-20-229 TELEPHONE 70.00 965.06
540-20-230 BUILDING MAINTENANCE/REPAIR 0.00 60,815.46
540-20-231 BUILDING MAINT SERVICES 33.33 898.48
540-20-253 TRAINING AND TRAVEL 0.00 1,540.20
545-20-224 SERVICE/MAINT AGREEMENT 163.38 1,293.88
545-20-226 UTILITIES 558.83 2,820.47
545-20-229 TELEPHONE 146.94 874.58
545-20-230 BUILDING MAINTENANCE/REPAIR 1,360.95 3,933.32
545-20-231 BUILDING MAINT SERVICES 0.00 192.19
550-01-005 SALARIES 16,818.01 188,559.83
550-01-008 OVERTIME 0.00 12.94
550-01-011 LONGEVITY PAY 530.00 1,820.00
550-01-014 WORKER'S COMP INSURANCE 0.00 4,899.42
550-01-020 MEDICARE 197.20 3,120.85
550-01-023 RETIREMENT 1,416.08 21,622.24
550-01-026 FICA 0.00 352.16
550-01-034 EAP 0.00 84.00
550-01-036 LIFE INSURANCE 31.69 378.67
550-01-037 DENTAL INSURANCE 109.93 1,319.16
550-01-038 HEALTH INSURANCE 2,034.62 23,927.01
550-01-039 VISION INSURANCE 18.30 211.90
550-01-040 LONG TERM DISABILITY 33.29 396.54
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 6
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
550-10-105 OFFICE SUPPLIES 925.67 3,914.72
550-10-107 OPERATIONS EQUIPMENT < 5000 0.00 1,062.07
550-10-108 POSTAGE 214.84 42.29
550-10-120 PARTS FOR EQUIPMENT 9.90 9.90
550-10-125 UNIFORMS 168.58 328.83
550-10-130 SAFETY EQUIPMENT 0.00 39.99
550-10-136 JANITORIAL SUPPLIES 185.17 1,288.19
550-10-147 MISC MATERIALS AND SUPPLIES 298.90 298.90
550-20-204 VEHICLE MAINT. / REPAIR 26.80 130.54
550-20-214 CONTRACT LABOR 0.00 345.00
550-20-217 LEGAL NOTICE 900.00 1,137.60
550-20-220 DUES AND SUBSCRIPTIONS 5,526.84 26,539.75
550-20-224 SERVICE/MAINT AGREEMENT 1,286.72 9,774.07
550-20-226 UTILITIES 1,415.19 8,253.83
550-20-227 INTERNET SERVICE PROVIDERS 120.00 720.00
550-20-229 TELEPHONE 366.84 3,784.72
550-20-230 BUILDING MAINTENANCE/REPAIR 71.23 14,192.16
550-20-231 BUILDING MAINT SERVICES 451.54 1,487.93
550-20-234 BUSINESS EXPENSE 3,400.00 55,314.90
550-20-236 COUNCIL AND BOARD TRAINING 2,599.77 10,568.03
550-20-237 COUNCIL MEETINGS 151.19 1,430.74
550-20-240 RECORDS RETENTION 0.00 1,423.00
550-20-241 LEGAL 3,450.90 26,376.04
550-20-253 TRAINING AND TRAVEL 4,187.70 16,192.48
550-20-254 PUBLIC RELATIONS 1,486.56 9,009.12
550-20-255 HEALTH INSPECTOR 2,300.00 16,235.00
550-20-256 AUTO ALLOWANCE 461.54 6,000.02
550-20-262 LEASE PURCHASE 247.77 991.08
550-20-286 LIABILITY INSURANCE 0.00 19,028.44
550-20-289 ELECTION COSTS 0.00 4,580.54
550-20-295 BAD DEBT EXPENSE 0.00 10.20
550-20-321 SPECIAL EVENT 912.46 38,755.24
550-20-386 CONTINGENCY FUND 691.34 2,022.58
550-99-960 TRANSFER TO UTILITY FUND 95,791.63 0.00
551-01-005 SALARIES 7,192.23 77,769.46
551-01-011 LONGEVTIY PAY 120.00 610.00
551-01-014 WORKER'S COMP INSURANCE 0.00 1,290.41
551-01-020 MEDICARE 89.24 1,119.83
551-01-023 RETIREMENT 615.38 7,722.09
551-01-034 EAP 0.00 42.00
551-01-036 LIFE INSURANCE 18.64 169.85
551-01-037 DENTAL INSURANCE 32.02 384.24
551-01-038 HEALTH INSURANCE 0.00 229.00
551-01-039 VISION INSURANCE 6.00 69.47
551-01-040 LONG TERM DISABILITY 19.60 178.22
551-10-105 OFFICE SUPPLIES 423.96 1,115.73
551-10-107 OPERATIONS EQUIPMENT < 5000 87.98 181.52
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 7
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
551-10-108 POSTAGE 80.52 840.69
551-10-125 UNIFORMS 0.00 51.49
551-20-214 CONTRACT LABOR 8,000.00 48,000.00
551-20-217 LEGAL NOTICE 844.40 1,114.00
551-20-220 DUES AND SUBSCRIPTIONS 603.88 7,470.19
551-20-224 SERVICE/MAINT AGREEMENT 0.00 6,869.46
551-20-227 INTERNET SERVICE PROVIDERS 120.00 810.00
551-20-247 AUDITING 8,000.00 25,700.00
551-20-253 TRAINING AND TRAVEL 559.61 3,429.06
551-20-257 ACCOUNTING SERVICES 2,500.00 2,500.00
551-20-266 FEES AND RECONCILIATIONS 18.00 85.47
551-20-296 TAX COLLECTION 5,752.75 23,011.00
551-40-418 OFFICE EQUIPMENT >500 1,646.25 1,646.25
565-01-005 SALARIES 30,398.37 288,033.99
565-01-008 OVERTIME 657.99 19,905.89
565-01-010 CERTIFICATION PAY 92.32 1,038.60
565-01-011 LONGEVITY PAY 1,540.00 3,874.00
565-01-014 WORKER'S COMP INSURANCE 0.00 6,377.61
565-01-020 MEDICARE 348.20 4,351.25
565-01-023 RETIREMENT 2,453.59 29,764.40
565-01-026 FICA 0.00 866.66
565-01-030 PHYSICAL EXAM/DRUG SCREEN 0.00 209.32
565-01-034 EAP 0.00 378.00
565-01-036 LIFE INSURANCE 72.68 704.25
565-01-037 DENTAL INSURANCE 252.96 2,555.22
565-01-038 HEALTH INSURANCE 5,566.30 56,041.46
565-01-039 VISION INSURANCE 47.39 462.33
565-01-040 LONG TERM DISABILITY 75.55 729.65
565-10-105 OFFICE SUPPLIES 409.21 1,811.04
565-10-106 SHOP/LAB SUPPLIES 1,990.85 6,045.38
565-10-107 OPERATIONS EQUIPMENT < 5000 611.01 4,537.22
565-10-111 GAS AND OIL 5,240.32 21,880.52
565-10-114 CONST SUPPLY-REPR/REPLACE 3,924.37 28,243.95
565-10-117 CHEMICALS 0.00 3,063.86
565-10-120 PARTS FOR EQUIPMENT 2,474.98 9,744.14
565-10-125 UNIFORMS 1,706.56 8,454.48
565-10-126 STREET SIGNS 0.00 3,881.62
565-10-130 SAFETY EQUIPMENT 760.62 2,406.52
565-10-136 JANITORIAL SUPPLIES 612.83 1,317.42
565-10-137 AGRICULTURAL/BOTANICAL 604.71 3,981.88
565-10-144 TOOLS 963.91 2,495.52
565-10-147 MISC MATERIALS AND SUPPLIES 362.94 360.06
565-20-204 VEHICLE MAINTENANCE/REPAIR 1,194.41 7,407.57
565-20-214 CONTRACT LABOR 1,336.95 2,836.95
565-20-215 CONST REPAIR/MAINT SERVICES 0.00 9,000.00
565-20-217 LEGAL NOTICE 0.00 1,226.30
565-20-220 DUES AND SUBSCRIPTIONS 21.64 119.51
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 8
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
565-20-223 EQUIPMENT RENTAL 0.00 2,607.71
565-20-224 SERVICE MAINT AGREEMENT 107.50 725.63
565-20-226 UTILITIES 2,479.49 18,430.43
565-20-227 INTERNET SERVICE PROVIDERS 240.00 870.00
565-20-229 TELEPHONE 235.40 1,583.74
565-20-230 BUILDING MAINTENANCE/REPAIR 207.99 1,451.98
565-20-231 BUILDING MAINT/SERVICES 141.12 6,380.97
565-20-244 ENGINEERING 0.00 5,406.99
565-20-253 TRAINING AND TRAVEL 386.72 1,522.25
565-20-257 TOOL ALLOWANCE 160.00 2,080.00
565-20-264 EQUIPMENT MAINTENANCE/REPAIR 1,570.41 5,847.33
565-20-265 PARKS/PLAYGROUND M & R 3,233.35 8,761.72
565-20-280 STREET LIGHTING 7,895.31 46,413.69
565-20-310 TABERNACLE RESTORATION EXP 0.00 1,574.66
565-20-348 MISC SERVICES 0.00 3,500.00
565-40-419 OPERATIONS EQUIPMENT > 5000 0.00 18,441.14
570-01-005 SALARIES 6,200.64 6,200.64
570-01-020 MEDICARE 12.47 12.47
570-01-023 RETIREMENT 86.00 86.00
570-10-108 POSTAGE 15.99 15.99
580-01-005 SALARIES 4,055.11 92,702.04
580-01-008 OVERTIME 289.86 3,414.01
580-01-014 WORKER'S COMP INSURANCE 0.00 2,803.21
580-01-020 MEDICARE 100.41 1,304.92
580-01-023 RETIREMENT 466.81 7,972.58
580-01-026 FICA 139.97 1,176.22
580-01-030 PHYSICAL EXAM/DRUG SCREEN 56.00 973.78
580-01-034 EAP 0.00 84.00
580-01-036 LIFE INSURANCE 0.00 173.99
580-01-037 DENTAL INSURANCE 0.00 640.40
580-01-038 HEALTH INSURANCE 0.00 13,355.99
580-01-039 VISION INSURANCE 6.00 81.01
580-01-040 LONG TERM DISABILITY 0.00 180.55
580-10-105 OFFICE SUPPLIES 205.20 1,692.13
580-10-106 SHOP/LAB SUPPLIES 179.94 1,335.93
580-10-107 OPERATIONS EQUIPMENT < 5000 57.45 1,034.48
580-10-108 POSTAGE 0.00 418.08
580-10-111 GAS AND OIL 133.42 1,141.07
580-10-120 PARTS FOR EQUIPMENT 0.00 36.90
580-10-125 UNIFORMS 25.86 459.83
580-10-130 SAFETY EQUIPMENT 150.97 234.50
580-10-136 JANITORIAL SUPPLIES 511.76 1,808.30
580-10-144 TOOLS 0.00 33.26
580-10-147 MISC MATERIALS AND SUPPLIES 0.00 119.98
580-20-204 VEHICLE MAINTENANCE/REPAIR 0.00 787.02
580-20-217 LEGAL NOTICE 99.60 412.80
580-20-220 DUES AND SUBSCRIPTIONS 0.00 39.70
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 9
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
580-20-221 PERMITS AND LISCENSES 75.00 75.00
580-20-224 SERVICE/MAINT AGREEMENT 107.50 483.75
580-20-226 UTILITIES 872.80 5,594.48
580-20-227 INTERNET SERVICE PROVIDERS 180.00 810.00
580-20-229 TELEPHONE 167.24 1,003.56
580-20-230 BUILDING MAINT/REPAIR 0.00 7,047.32
580-20-231 BUILDING MAINT SERVICES 33.33 4,374.22
580-20-253 TRAINING AND TRAVEL 100.00 1,385.26
580-20-301 ANIMAL CONTROL 39,098.65 70,192.97
580-20-303 ORDINANCE ABATEMENT 0.00 1,859.93
590-01-005 SALARIES 15,405.02 163,517.87
590-01-008 OVERTIME 101.48 2,410.29
590-01-011 LONGEVITY PAY 240.00 930.00
590-01-014 WORKER'S COMP INSURANCE 0.00 2,947.80
590-01-020 MEDICARE 191.23 2,346.63
590-01-023 RETIREMENT 1,336.42 16,447.52
590-01-034 EAP 0.00 126.00
590-01-036 LIFE INSURANCE 37.75 374.17
590-01-037 DENTAL INSURANCE 64.04 768.48
590-01-038 HEALTH INSURANCE 1,402.86 19,798.48
590-01-039 VISION INSURANCE 12.00 173.56
590-01-040 LONG TERM DISABILITY 39.50 389.01
590-10-105 OFFICE SUPPLIES 89.51 936.47
590-10-108 POSTAGE 0.00 105.42
590-10-125 UNIFORMS 102.94 271.38
590-10-147 MISC MATERIALS AND SUPPLIES 0.00 150.76
590-20-214 CONTRACT LABOR 85,041.38 195,842.73
590-20-217 LEGAL NOTICE 113.00 1,042.10
590-20-220 DUES AND SUBSCRIPTIONS 6,278.03 8,033.22
590-20-221 PERMITS AND LICENSES 0.00 50.00
590-20-227 INTERNET SERVICE PROVIDERS 60.00 300.00
590-20-229 TELEPHONE 60.00 330.00
590-20-244 ENGINEERING 0.00 6,486.75
590-20-245 ECONOMIC DEVELOPMENT SERVICES 94.19 94.19
590-20-253 TRAINING AND TRAVEL 585.27 3,617.09
590-20-258 CELL PHONE ALLOWANCE 92.32 375.88
590-20-284 PLAT AND FILING FEES 0.00 279.49
______________ ______________ ______________ ______________
*** TOTALS *** 1,671,076.69 1,671,076.69CR 9,229,472.79 9,229,472.79CR
============== ============== ============== ==============
*** END OF REPORT ***
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 1
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
200-ENTERPRISE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
ASSETS
======
1001 CLAIM ON CASH 1,165,726.13 1,573,653.91
1002 CASH BNY MELLON TWDB 1,327,236.00 1,327,236.00
1004 CLAIM ON CASH (EBT) 0.00 0.01
1005 HEALTH REIMB ARRANGEMENT ACCT 0.00 1,375.00
1023 TEXPOOL 206,405.08 0.00
1024 TEXSTAR 200,820.12 0.00
1050 TEXPOOL - RESTRICTED 4,136,401.91 4,209,373.20
1051 TEXPOOL-EAST LOOP ESCROW 0.00 1.43
1102 SERVICE/EXT FEES RECEIVABLE 82.08 3,699.39
1103 TRANSFER FEES RECEIVABLE 0.00 61.08
1106 LATE CHARGES RECEIVABLE 273.97 4,631.83
1112 DOR PENSION-DEF OUTFLOW RES 12,017.00 45,052.00
1113 DOR OPEB-DEF OUTFLOW RES 3,039.00 4,958.00
1115 WATER ACCOUNTS RECEIVABLE 7,739.98 203,796.99
1116 UNAPPLIED CREDIT 467.76 18,253.45
1119 ALLOWANCE FOR DOUBTFUL ACCTS 10,244.31 86,095.00
1121 SEWER ACCOUNTS RECEIVABLE 8,128.31 118,763.54
1122 EARNED/UNBILLED RECEIVABLE 1,084.30 60,694.81
1145 DUE FROM OTHER FUNDS 13,109.25 0.00
1305 LAND 0.00 211,539.52
1308 LAND IMPROVEMENTS 0.00 9,109.29
1309 A/D - LAND IMPROVEMENTS 0.00 9,109.29
1312 BUILDING 0.00 563,535.76
1313 A/D-BUILDING 0.00 528,577.36
1324 AUTOMOTIVE EQUIPMENT 0.00 400,510.54
1325 A/D-AUTOMOTIVE EQUIPMENT 0.00 228,523.86
1328 OFFICE AND RADIO EQUIPMENT 0.00 23,353.39
1329 A/D-OFFICE AND RADIO EQUIPMENT 0.00 23,353.68
1332 MACHINERY AND EQUIPMENT 0.00 276,890.80
1333 A/D-MACHINERY AND EQUIPMENT 0.00 214,299.12
1336 WATER WELLS 0.00 175,371.23
1337 A/D-WATER WELLS 0.00 175,369.19
1340 WATER TOWER AND RESERVOIR 0.00 911,560.06
1341 A/D-WATER AND TOWER RESERVOIR 0.00 419,026.97
1344 WATER DISTRIBUTION 0.00 4,783,862.62
1345 A/D-WATER DISTRIBUTION 0.00 2,912,056.58
1346 WATER TREATMENT PLANT 0.00 1,293,404.68
1347 A/D WATER TREATMENT PLANT 0.00 394,267.23
1348 PUMPING SYSTEM 0.00 120,789.77
1349 A/D-PUMPING SYSTEM 0.00 108,224.36
1350 CONSTRUCTION IN PROGRESS 0.00 307,019.83
1356 SEWER LINES 0.00 2,458,686.85
1357 A/D-SEWER LINES 0.00 1,023,824.54
1360 SEWER TREATMENT PLANT 0.00 7,259,314.84
1361 A/D-SEWER TREATMENT PLANT 0.00 2,495,119.63
1406 '17 GO REFUND DIFF 541.00 5,914.00
LIABILITIES AND FUND BALANCE
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 2
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
200-ENTERPRISE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
============================
2002 AP PENDING (DUE TO POOL CASH) 166,525.83 181,700.30
2010 DEPOSITS PAYABLE 750.00 201,473.00
2036 '12A (TWDB) CO PAYABLE 1,975,000.00 0.00
2042 BONDS PAYABLE 9,480,000.00 11,815,000.00
2044 BOND PREMIUMS 46,836.00 189,965.00
2050 CURRENT BOND PAYABLE 125,000.00 355,000.00
2052 BOND DISCOUNTS 74,626.70 74,626.70
2111 NET PENSIONS 228,171.00 46,628.00
2112 DIR PENSIONS-DEF INFLOW RES 191,275.00 89,529.17
2113 NET OPEB 13,512.00 25,174.00
2114 DIR OPEBS - Def Inflow Resourc 10,038.00 12,753.00
2119 ACCRUED INTEREST PAYABLE 4,652.00 42,216.00
2121 '12A (TWDB) CO ACC INT PAYABLE 5,406.00 0.00
2205 WAGES PAYABLE 3,761.43 23,417.85
2206 VACATION/SICK ACCRUAL 12,431.09 44,124.25
2207 RANK/LONGEVITY PAY ACCRUAL 200.00 4,480.00
2209 LIFE INSURANCE PAYABLE 14.23 0.00
2230 LEGALSHIELD PAYABLE 33.90 0.00
2240 HEALTH INSURANCE PAYABLE 44.39 0.00
2241 DENTAL INSURANCE PAYABLE 173.03 0.00
3109 NET FUND BALANCE 1,285,301.10 4,964,944.00
REVENUES
=========
400-24-223 MISCELLANEOUS REVENUE 4.04 16,399.52
400-24-242 LATE CHARGES 4,336.10 43,828.14
400-24-243 SERVICE/EXTENSION FEE 575.00 6,175.00
400-24-245 NEW ACCOUNT PROCESSING FEE 810.00 9,660.00
400-24-251 WATER SALES 156,164.84 1,517,695.29
400-24-252 BULK WATER SALES 939.57 28,870.10
400-24-257 TAP FEES 4,844.43 26,268.33
400-24-263 SEWER CHARGES 84,916.49 955,030.61
400-40-405 INTEREST 225,958.91 243,841.26
400-40-440 INSURANCE CLAIMS 0.00 2,625.88
400-40-445 INFRASTRUCTURE FEE 3,929.98 30,110.22
400-99-930 CONTRIBUTION FROM CIP ENT FUND 95,791.63 0.00
EXPENDITURES
=============
560-01-005 SALARIES 17,917.18 244,677.12
560-01-008 OVERTIME 821.61 13,316.83
560-01-009 VACATION/SICK EXPENSE 8,547.22 8,547.22
560-01-010 CERTIFICATION PAY 219.26 2,619.58
560-01-011 LONGEVITY PAY 1,920.00 1,067.00
560-01-014 WORKER'S COMP INSURANCE 0.00 5,371.86
560-01-020 MEDICARE 268.60 3,632.39
560-01-023 RETIREMENT 15,376.80 39,633.38
560-01-030 PHYSICAL EXAM/DRUG SCREEN 0.00 281.19
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 3
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
200-ENTERPRISE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
560-01-034 EAP 0.00 168.00
560-01-036 LIFE INSURANCE 49.87 570.82
560-01-037 DENTAL INSURANCE 192.12 2,097.31
560-01-038 HEALTH INSURANCE 4,283.58 40,872.46
560-01-039 VISION INSURANCE 36.00 367.72
560-01-040 LONG TERM DISABILITY 52.21 591.37
560-10-105 OFFICE SUPPLIES 108.00 4,051.30
560-10-106 SHOP/LAB SUPPLIES 9,357.14 17,734.10
560-10-107 OPERATIONS EQUIPMENT <5000 2,611.09 10,255.55
560-10-108 POSTAGE 575.52 5,753.97
560-10-111 GAS AND OIL 3,439.97 17,098.78
560-10-114 CONST SUPPLY-REPR/REPLACE 5,439.82 82,212.26
560-10-117 CHEMICALS 5,689.48 59,397.15
560-10-120 PARTS FOR EQUIPMENT 6,323.52 13,911.03
560-10-125 UNIFORMS 505.06 4,608.65
560-10-130 SAFETY EQUIPMENT 726.63 1,834.72
560-10-136 JANITORIAL SUPPLIES 0.00 136.27
560-10-138 WATER PURCHASES 29,338.59 246,724.68
560-10-141 METERS AND BOXES 0.00 8,957.27
560-10-144 TOOLS 260.90 1,614.35
560-10-147 MISC MATERIALS AND SUPPLIES 0.00 2.33
560-20-204 VEHICLE MAINTENANCE/REPAIR 1,841.20 7,228.97
560-20-214 CONTRACT LABOR 1,336.95 25,934.45
560-20-217 LEGAL NOTICE 0.00 43.20
560-20-220 DUES AND SUBSCRIPTIONS 582.19 7,749.89
560-20-221 PERMITS AND LISCENSES 25.00 4,767.80
560-20-223 EQUIPMENT RENTAL 0.00 1,035.00
560-20-224 SERVICE/MAINT AGREEMENT 357.50 23,285.43
560-20-226 UTILITIES 20,803.77 113,148.18
560-20-227 INTERNET SERVICE PROVIDERS 580.92 2,051.99
560-20-229 TELEPHONE 626.74 4,621.82
560-20-230 BUILDING MAINTENANCE/REPAIR 7,476.15 15,409.79
560-20-231 BUILDING MAINT SERVICES 11.11 5,986.62
560-20-234 BUSINESS EXPENSE 0.00 39,427.90
560-20-253 TRAINING AND TRAVEL 590.32 5,148.36
560-20-264 EQUIPMENT MAINTENANCE/REPAIR 63,926.65 199,165.35
560-20-265 FINES AND FEES 10,079.00 0.00
560-20-286 LIABILITY INSURANCE 0.00 15,235.73
560-20-295 BAD DEBT EXPENSE 0.00 35.71
560-20-306 SANITATION CONTRACT 238.00 1,422.70
560-20-348 MISCELLANEOUS SERVICES 0.00 750.00
560-20-351 WATER TESTING 464.00 5,763.19
560-20-352 PLT/EQUIP INSPECTION & TESTING 2,271.12 8,041.52
560-20-353 WATER WELL AND TANK REPAIR 0.00 63,175.00
560-20-381 SLUDGE REMOVAL 4,112.50 8,886.09
560-40-244 ENGINEERING 207,863.88 207,863.88
560-40-408 MOBILE EQUIPMENT 33,394.50 33,394.50
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 4
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
200-ENTERPRISE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
560-40-465 CAPITAL IMPROVEMENT 18,900.00 20,957.22
560-40-466 SCADA UPGRADE 58,819.00 58,819.00
560-50-524 CO AGENT FEES 0.00 2,782.50
560-50-526 INTEREST - 2017 GO REFUNDING 11,446.00 81,954.00
560-50-529 INTEREST - 2017 TAX NOTES 630.00 1,170.00
560-50-531 INTEREST - 2017 CO (TWDB) 108.00 29,340.00
560-50-535 INTEREST - 2021 CO 3,798.00 123,154.26
570-01-005 SALARIES 19,196.20 205,898.69
570-01-008 OVERTIME 0.00 4,943.27
570-01-009 VACATION/SICK EXPENSE 3,883.87 3,883.87
570-01-010 CERTIFICATION PAY 138.48 1,892.56
570-01-011 LONGEVITY PAY 1,720.00 5,003.00
570-01-014 WORKER'S COMP INSURANCE 0.00 4,295.19
570-01-020 MEDICARE 221.78 3,007.43
570-01-023 RETIREMENT 12,520.34 32,182.57
570-01-030 PHYSICAL EXAM/DRUG SCREEN 0.00 50.00
570-01-034 EAP 0.00 126.00
570-01-036 LIFE INSURANCE 47.33 550.70
570-01-037 DENTAL INSURANCE 131.28 1,687.43
570-01-038 HEALTH INSURANCE 2,900.86 38,896.97
570-01-039 VISION INSURANCE 24.60 316.54
570-01-040 LONG TERM DISABILITY 49.17 572.24
570-10-105 OFFICE SUPPLIES 49.40 2,796.78
570-10-106 SHOP/LAB SUPPLIES 3,442.79 8,566.92
570-10-107 OPERATIONS EQUIPMENT <5000 1,749.72 8,138.67
570-10-108 POSTAGE 557.91 5,736.35
570-10-111 GAS AND OIL 2,790.17 14,458.56
570-10-114 CONST SUPPLY-REPR/REPLACE 0.00 4,305.56
570-10-117 CHEMICALS 1,072.96 50,874.39
570-10-120 PARTS FOR EQUIPMENT 1,750.85 24,730.03
570-10-125 UNIFORMS 550.56 4,703.40
570-10-130 SAFETY EQUIPMENT 726.63 1,274.86
570-10-136 JANITORIAL SUPPLIES 26.31 310.00
570-10-144 TOOLS 173.07 2,019.40
570-10-147 MISC MATERIALS AND SUPPLIES 0.00 55.05
570-20-204 VEHICLE MAINTENANCE/REPAIR 1,900.70 4,911.39
570-20-214 CONTRACT LABOR 23,799.03 25,299.03
570-20-220 DUES AND SUBSCRIPTIONS 182.18 1,098.62
570-20-221 PERMITS AND LICENSES 0.00 1,494.06
570-20-223 EQUIPMENT RENTAL 0.00 175.00
570-20-224 SERVICE/MAINT AGREEMENT 107.50 6,666.23
570-20-226 UTILITIES 15,201.23 88,071.91
570-20-227 INTERNET SERVICE PROVIDER 89.98 404.89
570-20-229 TELEPHONE 506.01 4,165.33
570-20-230 BUILDING MAINTENANCE/REPAIR 0.00 531.86
570-20-231 BUILDING MAINT SERVICES 11.11 336.62
570-20-253 TRAINING AND TRAVEL 685.00 1,192.84
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 5
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
200-ENTERPRISE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
570-20-264 EQUIPMENT MAINTENANCE/REPAIR 47,423.72 113,319.69
570-20-286 LIABILITY INSURANCE 0.00 14,235.73
570-20-295 BAD DEBT EXPENSE 0.00 23.05
570-20-351 WATER TESTING 12,835.20 62,034.00
570-20-381 SLUDGE REMOVAL 0.00 9,856.92
570-50-523 INTEREST - 2012A CO (TWDB) 396.00 42,855.00
570-50-524 PAYING AGENT FEES 300.00 1,155.00
570-50-533 INTEREST - 2018 CO 3,951.00 51,949.00
______________ ______________ ______________ ______________
*** TOTALS *** 11,010,397.25 11,010,397.25CR 29,379,352.78 29,379,352.78CR
============== ============== ============== ==============
*** END OF REPORT ***
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 1
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
300-GRANT FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
ASSETS
======
1001 GRANT FUND 176,001.72 595,561.68
1118 GRANTS RECEIVABLE 13,800.00 0.00
LIABILITIES AND FUND BALANCE
============================
2002 AP PENDING (DUE TO POOL CASH) 4,500.00 4,500.00
2047 DEFERRED REVENUE 13,800.00 0.00
2051 DEFERRED REVENUE - GRANTS 127,341.60 664,657.74
3109 NET FUND BALANCE 0.09 43,962.00
REVENUES
=========
400-40-405 INTEREST 2,576.31 3,127.22
400-40-417 2021 CDBG AVENUE C PROJECT 24,085.00 59,810.00
400-40-418 OTHER GRANT PROCEEDS 0.00 17,099.94
400-40-419 2020 CDBG AVE D PROJECT 0.00 387,444.32
400-40-420 ARPA REVENUE 127,341.60 127,341.60
EXPENDITURES
=============
500-40-401 GENERAL ADMINISTRATION 1,700.00 6,800.00
500-40-440 AMERICAN RESCUE EXPENSES 127,341.60 127,341.60
500-40-441 CDBG AVENUE C EXPENSES 9,847.50 57,718.89
500-40-442 CDBG AVE D EXPENSES 68,274.02 520,520.65
______________ ______________ ______________ ______________
*** TOTALS *** 348,304.72 348,304.72CR 1,307,942.82 1,307,942.82CR
============== ============== ============== ==============
*** END OF REPORT ***
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 1
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
400-IMPACT FEES
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
ASSETS
======
1001 CLAIM ON CASH 41,533.65 41,533.65
1011 PINNACLE BANK - IMPACT FEES 64,524.18 344,193.77
1050 TEXPOOL RESTRICTED 0.00 164,560.76
1145 DUE FROM OTHER FUNDS 13,109.25 0.00
LIABILITIES AND FUND BALANCE
============================
3109 NET FUND BALANCE 0.47 267,361.00
REVENUES
=========
400-24-260 WATER IMPACT FEES 16,500.00 64,520.00
400-24-261 SEWER IMPACT FEES 75,000.00 203,740.00
400-40-403 WATER IMPACT INTEREST 724.76 7,357.41
400-40-404 SEWER IMPACT INTEREST 724.29 7,309.77
EXPENDITURES
=============
______________ ______________ ______________ ______________
*** TOTALS *** 106,058.30 106,058.30CR 550,288.18 550,288.18CR
============== ============== ============== ==============
*** END OF REPORT ***
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 1
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
500-CIP ENTERPRISE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
ASSETS
======
1001 CLAIM ON CASH 817,654.77 0.00
1002 CASH BNY MELLON 2017 CO TRWD 1,327,236.00 0.00
1050 TEXPOOL - RESTRICTED 4,160,456.59 0.00
LIABILITIES AND FUND BALANCE
============================
2044 PREMIUM 707.00 0.00
2045 TWDB Bond Payable 2017 1,155,000.00 0.00
2046 BONDS PAYABLE CO 2018 1,280,000.00 0.00
2048 PREMIUM CO 2018 62,498.00 0.00
2050 CURRENT BOND PAYABLE 125,000.00 0.00
2051 Bonds Payable CO 2021 5,070,000.00 0.00
2052 DISCOUNT - CO 2021 78,475.70 0.00
3109 NET FUND BALANCE 1,285,303.61 0.00
REVENUES
=========
400-40-405 INTEREST 202,685.55 0.00
EXPENDITURES
=============
560-40-244 ENGINEERING 207,863.88 0.00
570-40-465 CAPITAL IMPROVEMENT - AMI 18,900.00 0.00
______________ ______________ ______________ ______________
*** TOTALS *** 7,895,890.55 7,895,890.55CR 0.00 0.00
============== ============== ============== ==============
*** END OF REPORT ***
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 1
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
600-CIP GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
ASSETS
======
1001 CLAIM ON CASH 9,046.73 1,052,788.31
1024 TEXSTAR 185,701.67 0.00
1050 TEXPOOL - RESTRICTED 0.00 116,682.87
LIABILITIES AND FUND BALANCE
============================
2006 RETAINAGE EXPENSE PAYABLE 0.04 0.00
3109 NET FUND BALANCE 0.13 304,833.00
REVENUES
=========
400-40-405 INTEREST 4,475.37 16,729.48
400-40-423 BOND PROCEEDS 0.00 1,050,000.00
400-40-424 BOND PREMIUM 0.00 2,039.10
EXPENDITURES
=============
500-40-478 BOND ISSUANCE COSTS 0.00 23,000.00
500-99-940 CONTRIBUTION TO ENTERPRISE FUN 181,130.40 181,130.40
______________ ______________ ______________ ______________
*** TOTALS *** 190,177.17 190,177.17CR 1,373,601.58 1,373,601.58CR
============== ============== ============== ==============
*** END OF REPORT ***
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 1
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
700-CAPITAL PROJECTS-RESERVE
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
ASSETS
======
1001 CLAIM ON CASH 494,478.87 4,873,972.98
1023 TEXPOOL 254,299.96 0.00
1024 TEXSTAR 42,911.04 0.00
LIABILITIES AND FUND BALANCE
============================
2006 RETAINAGE PAYABLE 7,260.27 7,260.27
3109 NET FUND BALANCE 0.26 809,067.00
REVENUES
=========
400-40-405 INTEREST 16,137.21 28,817.41
400-40-423 BOND PROCEEDS 0.00 3,150,000.00
400-40-424 BOND PREMIUMS 0.00 6,117.30
400-99-910 TRANSFER FROM GENERAL FUND 181,130.40 1,118,341.40
EXPENDITURES
=============
500-40-478 BOND ISSUANCE COSTS 0.00 69,000.00
565-40-244 ENGINEERING 0.00 31,425.00
565-40-426 STREET CONSTRUCTION 7,260.27 145,205.40
______________ ______________ ______________ ______________
*** TOTALS *** 501,739.14 501,739.14CR 5,119,603.38 5,119,603.38CR
============== ============== ============== ==============
*** END OF REPORT ***
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 1
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
710-ECONOMIC DEVELOP-RESERVES
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
ASSETS
======
1001 CLAIM ON CASH 245,741.35 555,750.62
1023 TEXPOOL 245,344.20 0.00
LIABILITIES AND FUND BALANCE
============================
3109 NET FUND BALANCE 0.29 570,557.00
REVENUES
=========
400-40-405 INTEREST 1,385.55 11,657.71
EXPENDITURES
=============
590-20-245 ECONOMIC DEVELOPMENT SVCS 988.11 26,464.09
______________ ______________ ______________ ______________
*** TOTALS *** 246,729.75 246,729.75CR 582,214.71 582,214.71CR
============== ============== ============== ==============
*** END OF REPORT ***
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 1
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
720-CAPITAL ASSETS-RESERVES
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
ASSETS
======
1001 CLAIM ON CASH 190,021.48 291,520.79
1023 TEXPOOL 83,682.18 0.00
1024 TEXSTAR 105,164.57 0.00
LIABILITIES AND FUND BALANCE
============================
2002 AP PENDING (DUE TO POOL CASH) 155,104.52 155,104.52
3109 NET FUND BALANCE 0.83 91,433.00
REVENUES
=========
400-40-405 INTEREST 570.30 8,282.18
400-40-441 PROCEEDS FROM CAPITAL LEASE 0.00 53,955.00
400-99-910 TRANSFER FROM GENERAL FUND 0.00 234,303.00
EXPENDITURES
=============
510-40-410 CAPITAL EQUIPMENT 43,100.99 53,955.00
510-40-458 LEASE PAYMENT - PRINCIPAL 37,313.30 37,313.30
510-40-459 LEASE PAYMENT - INTEREST 5,184.09 5,184.09
570-40-408 MOBILE EQUIPMENT 155,104.52 155,104.52
______________ ______________ ______________ ______________
*** TOTALS *** 387,623.39 387,623.39CR 543,077.70 543,077.70CR
============== ============== ============== ==============
*** END OF REPORT ***
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 1
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
800-COURT BLDG SECURITY
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
ASSETS
======
1001 CLAIM ON CASH 746.78 59,325.71
LIABILITIES AND FUND BALANCE
============================
3109 NET FUND BALANCE 0.22 54,431.00
REVENUES
=========
400-23-236 COURT BUILDING SECURITY FUND 534.28 6,229.63
400-40-405 INTEREST 212.28 249.19
EXPENDITURES
=============
530-20-224 SERVICE/MAINT AGREEMENT 0.00 826.11
530-40-417 BUILDING IMPROVEMENTS 0.00 758.00
______________ ______________ ______________ ______________
*** TOTALS *** 746.78 746.78CR 60,909.82 60,909.82CR
============== ============== ============== ==============
*** END OF REPORT ***
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 1
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
810-COURT TECHNOLOGY
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
ASSETS
======
1001 CLAIM ON CASH 402.79 9,503.11
LIABILITIES AND FUND BALANCE
============================
2002 AP PENDING (DUE TO POOL CASH 290.22 290.22
3109 NET FUND BALANCE 1.18 16,998.00
REVENUES
=========
400-23-232 COURT TECHNOLOGY 440.79 4,781.59
400-40-405 INTEREST 33.78 41.30
EXPENDITURES
=============
530-10-107 OPERATIONS EQUIPMENT < 5000 112.28 2,054.77
530-20-224 SERVICE/MAINT AGREEMENT 2,025.52 6,576.17
530-20-229 TELEPHONE 70.00 965.06
530-20-261 LEASE FINANCING INTEREST 78.60 78.60
530-20-262 LEASE FINANCING PRINCIPAL 2,933.40 2,933.40
______________ ______________ ______________ ______________
*** TOTALS *** 3,194.28 3,194.28CR 22,111.11 22,111.11CR
============== ============== ============== ==============
*** END OF REPORT ***
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 1
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
820-JUDICIAL EFFICIENCY
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
ASSETS
======
1001 CLAIM ON CASH 7.84 2,179.96
LIABILITIES AND FUND BALANCE
============================
3109 NET FUND BALANCE 0.26 2,169.00
REVENUES
=========
400-23-234 JUDICIAL EFFICIENCY 0.00 1.96
400-40-405 INTEREST 7.58 9.00
EXPENDITURES
=============
______________ ______________ ______________ ______________
*** TOTALS *** 7.84 7.84CR 2,179.96 2,179.96CR
============== ============== ============== ==============
*** END OF REPORT ***
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 1
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
830-POLICE FORFEITURE
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
ASSETS
======
1001 CLAIM ON CASH 0.00 2,388.19
LIABILITIES AND FUND BALANCE
============================
3109 NET FUND BALANCE 0.17 3,306.00
REVENUES
=========
400-40-405 INTEREST 0.17 0.17
EXPENDITURES
=============
510-01-011 PD SEIZURE EXPENSES 0.00 917.98
______________ ______________ ______________ ______________
*** TOTALS *** 0.17 0.17CR 3,306.17 3,306.17CR
============== ============== ============== ==============
*** END OF REPORT ***
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 1
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
840-LEOSE OFFICER TRAINING
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
ASSETS
======
1001 CLAIM ON CASH 18.76 5,214.50
LIABILITIES AND FUND BALANCE
============================
3109 NET FUND BALANCE 0.38 3,880.00
REVENUES
=========
400-40-405 INTEREST 19.14 22.24
400-40-432 LEOSE OFFICER TRAINING 0.00 1,312.26
EXPENDITURES
=============
______________ ______________ ______________ ______________
*** TOTALS *** 19.14 19.14CR 5,214.50 5,214.50CR
============== ============== ============== ==============
*** END OF REPORT ***
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 1
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
900-DEBT SERVICE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
ASSETS
======
1001 CLAIM ON CASH 82,450.50 172,968.85
1023 TEXPOOL 95,059.69 0.00
1024 TEXSTAR 30,888.63 0.00
1050 TEXPOOL RESTRICTED 44,114.98 0.00
1119 TAX ALLOWANCE 154.81 3,308.13
1120 TAXES RECEIVABLE(AD VALOREM) 743.35 15,884.42
LIABILITIES AND FUND BALANCE
============================
2047 DEFERRED REVENUE 588.54 12,576.29
3109 NET FUND BALANCE 0.24 179,644.00
REVENUES
=========
400-01-009 I & S CURRENT TAXES 289.02 468,421.78
400-01-012 I & S DELINQUENT TAXES 11.32 6,097.07
400-01-013 I & S DELINQUENT PEN & INT 3.31 1,598.66
400-01-015 I & S CURRENT PEN & INT 46.30 3,028.80
400-40-405 INTEREST 266.97 4,837.04
EXPENDITURES
=============
500-50-053 BOND AGENT FEES 0.00 862.50
500-50-060 PRINCIPAL - 2017 GO REFUNDING 0.00 60,000.00
500-50-061 INTEREST - 2017 GO REFUNDING 0.00 11,600.00
500-50-564 PRINCIPAL - 2018 CO 0.00 20,000.00
500-50-565 INTEREST - 2018 CO 0.00 21,700.00
500-50-570 PRINCIPAL - 2021 GO REFUNDING 0.00 290,000.00
500-50-571 INTEREST - 2021 GO REFUNDING 0.00 86,496.00
______________ ______________ ______________ ______________
*** TOTALS *** 127,308.83 127,308.83CR 679,511.77 679,511.77CR
============== ============== ============== ==============
*** END OF REPORT ***
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 1
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
995-GLTDA
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
LIABILITIES AND FUND BALANCE
============================
2206 COMP ABS PAYABLE 95,258.64 95,258.64
3109 NET FUND BALANCE 74,111.49 74,111.49
EXPENDITURES
=============
510-01-005 SALARIES 5.82 5.82
530-01-005 SALARIES 349.22 349.22
540-01-005 SALARIES 997.99 997.99
550-01-005 SALARIES 2,359.79 2,359.79
551-01-005 SALARIES 3,063.71 3,063.71
565-01-005 SALARIES 10,895.30 10,895.30
570-01-005 SALARIES 849.26 849.26
580-01-005 SALARIES 194.04 194.04
590-01-005 SALARIES 4,840.62 4,840.62
______________ ______________ ______________ ______________
*** TOTALS *** 96,462.94 96,462.94CR 96,462.94 96,462.94CR
============== ============== ============== ==============
*** END OF REPORT ***
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 1
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
998-EMP BENEFIT TRUST POOL
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
ASSETS
======
LIABILITIES AND FUND BALANCE
============================
EXPENDITURES
=============
______________ ______________ ______________ ______________
============== ============== ============== ==============
*** END OF REPORT ***
11-26-2023 09:54 AM CITY OF SPRINGTOWN PAGE: 1
TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
999-POOL CASH
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
_________________________________________________________________________________________________________________________________
ASSETS
======
1001 POOL CASH ACCOUNT 2,208,483.50 11,062,180.50
1010 DUE FROM GENERAL FUND 153,862.94 177,407.43
1020 DUE FROM WATER FUND 107,706.83 122,881.30
1072 DUE FROM CAPITAL ASSETS 155,104.52 155,104.52
1080 DUE FROM GRANT FUND 4,500.00 4,500.00
1081 DUE FROM COURT TECHNOLOGY 290.22 290.22
1091 DUE FROM CIP FUND 58,819.00 58,819.00
LIABILITIES AND FUND BALANCE
============================
2005 ACCOUNTS PAYABLE 480,283.51 519,002.47
2095 DUE TO OTHER FUNDS 2,208,483.50 11,062,180.50
EXPENDITURES
=============
______________ ______________ ______________ ______________
*** TOTALS *** 2,688,767.01 2,688,767.01CR 11,581,182.97 11,581,182.97CR
============== ============== ============== ==============
*** END OF REPORT ***