Import 3817dc38-ec4e-4c04-b233-3a85f8c92d72
Download
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
01 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
01-1100.01 CLAIM ON CASH 0.00 1,194,858.76
01-1102 LIBRARY PETTY CASH 0.00 140.00
01-1103 POOL PETTY CASH 0.00 100.00
01-1105 REC. CENTER PETTY CASH 0.00 186.50
01-1108 GOLF COURSE PETTY CASH 0.00 260.00
01-1109 CODES PETTY CASH 0.00 100.00
01-1121 CD INVESTMENTS 0.00 874,536.71
01-1122 MISC A/R 0.00 14,046.85
01-1127 NSF CHECKS 0.00 12,877.46
01-1128 SUSPENSE 0.00 36,532.71
01-1130 OVER/SHORT 0.00 0.11
01-1132 ACCTS. REC/FRANCHISE FEES 0.00 8,978.17
01-1133 A/R MIXED BEVERAGE TAX 0.00 504.43
01-1134 TAX RECEIVABLE/DELINQUENT 0.00 107,450.10
01-1135 ALLOWANCE FOR UNCOLLECTIB 0.00 16,117.52
01-1142 CURBING ACCOUNTS RECEIVEB 0.00 374.42
01-1143 GRANTS RECEIVABLE 0.00 1,412.05
01-1146 SALES TAX RECEIVABLE 0.00 377,527.62
01-1147 ALLOWANCE FOR UNCOLLECTIBLES 0.00 8,570.78
01-1150 ACCOUNTS RECEIVABLE 0.00 53,586.48
01-1164 PREPAID POSTAGE 0.00 4,345.73
01-1166 PREPAID RECORDING/FILING FEES 0.00 1,137.50
01-1167 PREPAID CITY SCOFFLAW 0.00 1,918.00
01-1200 ACCOUNTS PAYABLE 0.00 20.00
01-1200.01 AP PENDING 0.00 110,768.19
01-1201.04 TMRS 0.00 44,614.88
01-1201.05 INSURANCE PAYABLE 0.00 141,488.32
01-1201.09 TOBACCO SURCHARGE 0.00 42.54
01-1201.12 BENEFITS PAYMENT DIFFERENCE 0.00 51,852.61
01-1207 INSPECTION BONDS DEPOSIT 0.00 2,697.00
01-1208 REFUNDS DUE 0.00 726.41
01-1218 MUNICIPAL COURT STATE FEES 0.00 6,156.48
01-1226 OMNI FEES 0.00 225.90
01-1227 COLLECTION AGENCY FEE 0.00 6,322.35
01-1228 UNAPPLIED CREDITS 0.00 1,028.04
01-1232 SALES TAX PAYABLE/GOLF COURSE 0.00 693.81
01-1242 STREET CUT DEPOSITS 0.00 1,000.00
01-1243 COMMUNITY CENTER DEPOSITS 0.00 2,910.00
01-1244 CITY PARK DEPOSITS 0.00 4,995.00
01-1245 LOPEZ PARK KEY DEPOSIT 0.00 100.00
01-1246 POLITICAL DEPOSITS 0.00 100.00
01-1248 BASEBALL FIELD DEPOSITS 0.00 350.00
01-1250 PARKLAND FEE 0.00 3,142.00
01-1254 RECREATION CENTER DEPOSIT 0.00 9,478.00
01-1255 ACCRUED PAYROLL 0.00 167,785.20
01-1259 YOGA DEPOSIT/LESSONS 0.00 597.00
01-1260 DEFERRED REVENUE 0.00 91,332.59
01-1280 FUND BALANCE 0.00 1,936,680.52
01-1290 PAYROLL CLEARING 0.00 96,646.51
01-1302 CURRENT YEAR LEVY 0.00 1,121,536.44
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 2
AS OF: SEPTEMBER 30TH, 2019
01 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ACCOUNTS (CONTINUED)
--------------------
01-1304 DELINQUENT TAXES 0.00 20,772.46
01-1306 PENALTIES 0.00 13,789.80
01-1312 SALES TAX REVENUE 0.00 1,000,130.87
01-1313 SCHOOL RESOURCE OFFICER 0.00 78,978.55
01-1314 FRANCHISE FEES 0.00 27,661.78
01-1317 POOL PARTY RENT 0.00 5,130.00
01-1319 CREDIT CARD FEES GEN 0.00 7,808.40
01-1323 ZONING/SUBD. 0.00 3,100.00
01-1324 COMMUNITY CENTER RENTAL 0.00 15,105.00
01-1326 LICENSE & PERMITS 0.00 119,359.63
01-1328 ANIMAL FEES & ACCIDENT REP 0.00 5,995.00
01-1329 INSPECTION FEES 0.00 850.00
01-1330 ADMIN FEES/CUTOUTS 0.00 8,525.00
01-1332 MUNICIPAL COURT REVENUE 0.00 43,737.59
01-1333 CROSSING GUARD FUND 0.00 13,973.25
01-1335 LEAGUE FEES 0.00 15,056.30
01-1340 BRUSH OVER 8 CY 0.00 588.00
01-1346 CITY PARK USER FEE 0.00 4,665.00
01-1351 POOL CONCESSIONS 0.00 216.75
01-1353 LIBRARY BUILDING FUND DONATION 0.00 25,680.00
01-1354 SALE OF CEMETERY LOTS 0.00 4,600.00
01-1359 CITY EASEMENT USE 0.00 17,250.00
01-1362 P.I.L.O.T. - ELECTRIC 0.00 1,850,000.00
01-1363 RECREATIONAL FEES 0.00 29,868.10
01-1364 POOL REVENUE 0.00 4,525.00
01-1366 P.I.L.O.T. - WATER 0.00 161,000.00
01-1367 P.I.L.O.T. - WASTEWATER 0.00 92,325.36
01-1368 MISCELLANEOUS 0.00 4,378.28
01-1373 INTEREST INCOME 0.00 54,766.04
01-1374 MIXED BEVERAGE TAX 0.00 1,300.08
01-1378 TOBACCO/WELLNESS CONTRIBUTION 0.00 6,349.37
01-1379 GOLF COURSE REVENUE 0.00 37,317.34
01-1379.1 GOLF COURSE TREE DONATIONS 0.00 1.00
01-1380 LIBRARY REVENUE 0.00 12,399.59
01-1381 LIBRARY USED BOOKSTORE 0.00 2,307.40
01-1383 OH ALLOCATION FRM OTHER FUNDS 0.00 479,630.64
01-1385 POST OFFICE RENT 0.00 17,787.00
01-1387.1 HUTS FOR MUTTS DONATIONS 0.00 490.00
01-1389 VENDING MACHINE REVENUE 0.00 1,730.25
01-1399 TCLEOE GRANT 0.00 1,881.52
01-1592 SALE OF FIXED ASSETS/SURPLUS 0.00 18,508.22
01-1611 NIBRS GRANT 0.00 13,482.15
01-50110100 CITY COUNCIL FEES 0.00 20,000.00
01-50120200 OFFICE SUPPLIES 0.00 217.67
01-50120209 MEETINGS AND SEMINARS 0.00 3,097.92
01-50130311 MAYOR/PUBLIC RELATIONS 0.00 3,741.88
01-50130312 COMMUNITY CELEBRATIONS 0.00 565.22
01-50130313 YOUTH & ADULT ENGAGEMENT 0.00 7,190.12
01-50130338 MISCELLANEOUS 0.00 200.00
01-50210100 SALARY 0.00 146,026.94
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 3
AS OF: SEPTEMBER 30TH, 2019
01 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ACCOUNTS (CONTINUED)
--------------------
01-50210111 OVERTIME 0.00 3,854.79
01-50210116 LONGEVITY 0.00 684.00
01-50210125 SOCIAL SECURITY 0.00 11,922.31
01-50210126 UNEMPLOYMENT TAX 0.00 104.73
01-50210127 RETIREMENT PLAN 0.00 12,471.03
01-50210128 HEALTH & DENTAL INS 0.00 7,342.95
01-50210130 COBRA COMPLIANCE PREMIUM 0.00 12.66
01-50210135 WORKERS' COMPENSATION 0.00 719.34
01-50210149 AUTO ALLOWANCE CITY MANAGER 0.00 4,500.00
01-50210150 CELL PHONE ALLOWANCE 0.00 900.00
01-50220200 OFFICE SUPPLIES 0.00 5,307.66
01-50220201 BREAKROOM SUPPLIES 0.00 629.81
01-50220209 MEETINGS AND SEMINARS 0.00 4,566.40
01-50220216 EMPLOYEE RELATIONS 0.00 6,284.34
01-50220250 WELLNESS PROGRAM 0.00 2,646.27
01-50230300 UTILITIES 0.00 3,723.50
01-50230302 TELEPHONE 0.00 4,529.76
01-50230303 OFFICE EQUIPMENT LEASE PAYMENT 0.00 5,229.83
01-50230304 POSTAGE 0.00 26.15
01-50230306 PAYING AGENT FEES 0.00 1,800.00
01-50230309 MUSIC SERVICE 0.00 456.00
01-50230310 INSURANCE (C.G.L.) 0.00 13,685.28
01-50230312 MAINTENANCE AGREEMENTS 0.00 16,244.60
01-50230314 DUES & SUBSCRIPTIONS 0.00 5,164.57
01-50230316 LEGAL NOTICES 0.00 600.00
01-50230328 APPRAISAL FEES 0.00 3,850.00
01-50230330 CITY ATTORNEY 0.00 26,696.12
01-50230338 MISCELLANEOUS 0.00 1,723.35
01-50230341 CITY MANAGER/PROFESSIONAL FEES 0.00 960.00
01-50230362 JANITORIAL SUPPLIES 0.00 1,974.92
01-50230366 CONTINGENCY EXPENSE 0.00 3,707.51
01-50230382 INFO TECHNOLOGY PLAN 0.00 12,157.00
01-50230384 INSURANCE CONSULTANTS 0.00 13,052.80
01-50330323 APPRAISAL DISTRICT FEES 0.00 14,960.58
01-50330350 TAX COLLECTION FEES 0.00 500.00
01-50410100 SALARY 0.00 100,903.04
01-50410111 OVERTIME 0.00 1,574.05
01-50410116 LONGEVITY 0.00 288.00
01-50410125 SOCIAL SECURITY 0.00 6,991.23
01-50410126 UNEMPLOYMENT TAX 0.00 177.00
01-50410127 RETIREMENT PLAN 0.00 7,953.62
01-50410128 HEALTH & DENTAL INS 0.00 9,481.88
01-50410130 COBRA COMPLIANCE PREMIUM 0.00 18.81
01-50410135 WORKERS' COMPENSATION 0.00 501.81
01-50410150 CELL PHONE ALLOWANCE 0.00 450.00
01-50420200 OFFICE SUPPLIES 0.00 4,729.07
01-50420209 MEETINGS AND SEMINARS 0.00 1,574.45
01-50420221 APPLICANT PROCESSING 0.00 21.00
01-50430301 BANK ANALYSIS FEES 0.00 6,753.88
01-50430302 TELEPHONE 0.00 38.13
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 4
AS OF: SEPTEMBER 30TH, 2019
01 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ACCOUNTS (CONTINUED)
--------------------
01-50430303 JOB ANNOUNCEMENTS 0.00 1,157.40
01-50430304 POSTAGE 0.00 934.06
01-50430314 DUES & SUBSCRIPTIONS 0.00 1,007.00
01-50430326 AUDIT FEES 0.00 39,330.00
01-50430338 MISCELLANEOUS 0.00 2,666.94
01-50430361 RANDOM DRUG TESTING 0.00 62.60
01-50430370 CONTRACT LABOR 0.00 14,317.10
01-50430382 INFO TECHNOLOGY PLAN 0.00 1,528.00
01-50510100 SALARY 0.00 789,010.91
01-50510111 OVERTIME/CALL OUT 0.00 46,756.62
01-50510116 LONGEVITY 0.00 6,516.00
01-50510117 CERTIFICATE PAY 0.00 4,550.00
01-50510121 CROSSING GUARDS 0.00 17,853.00
01-50510125 SOCIAL SECURITY 0.00 62,907.82
01-50510126 UNEMPLOYMENT TAX 0.00 513.87
01-50510127 RETIREMENT PLAN 0.00 66,169.64
01-50510128 HEALTH & DENTAL INS 0.00 60,455.15
01-50510130 COBRA COMPLIANCE PREMIUM 0.00 125.05
01-50510135 WORKERS' COMPENSATION 0.00 25,508.12
01-50520200 OFFICE SUPPLIES 0.00 5,535.67
01-50520201 BREAKROOM SUPPLIES 0.00 409.66
01-50520202 FUEL & OIL 0.00 22,079.81
01-50520209 MEETINGS AND SEMINARS 0.00 6,782.60
01-50520210 EQUIPMENT MAINTENANCE 0.00 2,123.97
01-50520212 VEHICLE MAINTENANCE 0.00 9,861.57
01-50520215 SAFETY EQUIPMENT 0.00 3,361.66
01-50520217 RADIOS 0.00 579.00
01-50520227 BALLISTIC VESTS 0.00 1,040.00
01-50520228 K-9 EXPENSE 0.00 7,699.89
01-50520229 UNIFORMS 0.00 4,720.85
01-50520230 UNIFORM ALLOWANCE 0.00 1,221.07
01-50520232 OFFICE FURNITURE 0.00 5,245.61
01-50520240 PUBLIC EVENT SUPPLIES 0.00 1,259.10
01-50520241 CRIME PROCESSING 0.00 41.94
01-50520265 TIRES, TUBES & BATTERIES 0.00 459.68
01-50530300 UTILITIES 0.00 1,166.23
01-50530302 TELEPHONE 0.00 16,746.00
01-50530303 OFFICE EQUIPMENT LEASE PAYMENT 0.00 1,516.56
01-50530304 POSTAGE 0.00 899.81
01-50530310 INSURANCE (C.G.L.) 0.00 14,879.54
01-50530314 DUES & SUBSCRIPTIONS 0.00 1,014.50
01-50530317 TCLEOSE TRAINING 0.00 464.00
01-50530320 COMMUNITY OUTREACH 0.00 519.15
01-50530338 MISCELLANEOUS 0.00 3,464.85
01-50530344 MEDICAL SERVICE 0.00 200.00
01-50530360 INVESTIGATION EXPENSE 0.00 2,887.77
01-50530362 JANITORIAL SUPPLIES 0.00 751.84
01-50530382 INFO TECHNOLOGY PLAN 0.00 11,605.00
01-50540408 PURCHASED VEHICLES 0.00 87,887.30
01-50540412 PURCHASE NEW BUILDING 0.00 296,763.45
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 5
AS OF: SEPTEMBER 30TH, 2019
01 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ACCOUNTS (CONTINUED)
--------------------
01-50610100 SALARY 0.00 25,021.35
01-50610111 OVERTIME 0.00 540.50
01-50610115 COURT BAILIFF 0.00 41.33
01-50610116 LONGEVITY 0.00 144.00
01-50610125 SOCIAL SECURITY 0.00 1,963.83
01-50610127 RETIREMENT PLAN 0.00 2,035.09
01-50610128 HEALTH & DENTAL INS 0.00 3,180.57
01-50610130 COBRA COMPLIANCE PREMIUM 0.00 6.30
01-50610135 WORKERS' COMPENSATION 0.00 125.46
01-50620200 OFFICE SUPPLIES 0.00 612.87
01-50620209 MEETINGS AND SEMINARS 0.00 735.66
01-50630302 TELEPHONE 0.00 104.83
01-50630304 POSTAGE 0.00 220.87
01-50630307 CREDIT CARD FEES 0.00 1,954.75
01-50630314 DUES & SUBSCRIPTIONS 0.00 272.69
01-50630332 MUNICIPAL COURT JUDGE 0.00 20,000.00
01-50630336 PROSECUTOR 0.00 12,687.13
01-50630382 INFO TECHNOLOGY PLAN 0.00 10,212.00
01-50730300 UTILITIES 0.00 4.13
01-50730353 EMERGENCY OPERATION CONTINGENC 0.00 1,974.90
01-50730354 EMERGENCY NOTIFICATION SYSTEM 0.00 14,743.31
01-50740405 WATER TOWER RADIO BLDG 0.00 10,959.00
01-50810100 SALARY 0.00 39,875.00
01-50810111 CALL DUTY/OVERTIME 0.00 3,006.31
01-50810116 LONGEVITY 0.00 216.00
01-50810125 SOCIAL SECURITY 0.00 3,222.16
01-50810127 RETIREMENT PLAN 0.00 3,360.35
01-50810128 HEALTH & DENTAL INS 0.00 5,577.10
01-50810130 COBRA COMPLIANCE PREMIUM 0.00 10.56
01-50810135 WORKERS' COMPENSATION 0.00 1,882.62
01-50820200 OFFICE SUPPLIES 0.00 70.26
01-50820202 FUEL & OIL 0.00 1,824.65
01-50820204 ANIMAL SHELTER SUPPLIES 0.00 330.90
01-50820207 TAGS & HARDWARE 0.00 62.42
01-50820209 MEETINGS AND SEMINARS 0.00 502.01
01-50820210 EQUIPMENT MAINTENANCE 0.00 97.68
01-50820212 VEHICLE MAINTENANCE 0.00 14.50
01-50820214 STRUCTURE MAINTENANCE 0.00 615.54
01-50820215 SAFETY EQUIPMENT 0.00 48.49
01-50820229 UNIFORMS 0.00 539.81
01-50820265 TIRES, TUBES & BATTERIES 0.00 626.68
01-50830300 UTILITIES 0.00 465.74
01-50830302 TELEPHONE 0.00 458.22
01-50830308 VETERINARY FEES 0.00 570.44
01-50830310 INSURANCE (C.G.L.) 0.00 2,487.39
01-50830327 RENT-AFP 0.00 1,733.36
01-50830341 SPAY/NEUTER ANNUAL PROGRAM 0.00 2,500.00
01-50830362 JANITORIAL SUPPLIES 0.00 317.83
01-50830382 INFO TECHNOLOGY PLAN 0.00 2,188.00
01-50910100 SALARY 0.00 152,033.88
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 6
AS OF: SEPTEMBER 30TH, 2019
01 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ACCOUNTS (CONTINUED)
--------------------
01-50910111 OVERTIME/CALL OUT 0.00 2,297.95
01-50910116 LONGEVITY 0.00 1,728.00
01-50910125 SOCIAL SECURITY 0.00 11,814.26
01-50910126 UNEMPLOYMENT TAX 0.00 174.11
01-50910127 RETIREMENT PLAN 0.00 11,858.16
01-50910128 HEALTH & DENTAL INS 0.00 21,226.30
01-50910130 COBRA COMPLIANCE PREMIUM 0.00 42.57
01-50910135 WORKERS' COMPENSATION 0.00 17,720.97
01-50910150 CELL PHONE ALLOWANCE 0.00 450.00
01-50920200 OFFICE SUPPLIES 0.00 200.10
01-50920202 FUEL & OIL 0.00 10,904.48
01-50920203 SMALL TOOLS 0.00 55.98
01-50920207 STREET SIGNS 0.00 228.21
01-50920208 STREET SUPPLIES 0.00 1,033.69
01-50920209 MEETINGS AND SEMINARS 0.00 1,342.81
01-50920210 SMALL EQUIPMENT MAINTENANCE 0.00 566.92
01-50920212 VEHICLE MAINTENANCE 0.00 3,267.15
01-50920215 SAFETY EQUIPMENT 0.00 3,043.85
01-50920216 STREET REPAIRS 0.00 16,666.61
01-50920218 HEAVY EQUIPMENT MAINTENANCE 0.00 5,823.61
01-50920229 UNIFORMS 0.00 1,446.17
01-50920265 TIRES, TUBES & BATTERIES 0.00 465.01
01-50930300 UTILITIES 0.00 137.28
01-50930302 TELEPHONE 0.00 356.80
01-50930305 BUILDING SECURITY 0.00 179.13
01-50930310 INSURANCE (C.G.L.) 0.00 9,754.49
01-50930327 RENT-AFP 0.00 1,733.36
01-50930338 MISCELLANEOUS 0.00 15.66
01-50930362 JANITORIAL SUPPLIES 0.00 143.79
01-50930382 INFO TECHNOLOGY PLAN 0.00 6,485.00
01-50940401 STREET REHABILITATION 0.00 180,000.00
01-50940405 STORM DRAINAGE IMPROVEMENTS 0.00 80,000.00
01-50940409 CURB AND GUTTER REPAIR 0.00 80,000.00
01-51010100 SALARY 0.00 135,289.75
01-51010111 OVERTIME 0.00 3,691.26
01-51010116 LONGEVITY 0.00 252.00
01-51010125 SOCIAL SECURITY 0.00 10,673.87
01-51010126 UNEMPLOYMENT TAX 0.00 254.32
01-51010127 RETIREMENT PLAN 0.00 11,000.02
01-51010128 HEALTH & DENTAL INS 0.00 6,337.13
01-51010130 COBRA COMPLIANCE PREMIUM 0.00 20.67
01-51010135 WORKERS' COMPENSATION 0.00 460.98
01-51010150 CELL PHONE ALLOWANCE 0.00 850.00
01-51020200 OFFICE SUPPLIES 0.00 5,420.17
01-51020201 BREAKROOM SUPPLIES 0.00 621.47
01-51020202 AUDIO BOOK EXPENSES 0.00 1,524.99
01-51020204 STORY HOUR 0.00 1,400.45
01-51020205 BOOKS 0.00 13,116.69
01-51020207 MAGAZINES 0.00 454.68
01-51020208 SUMMER READING PROGRAM 0.00 657.67
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 7
AS OF: SEPTEMBER 30TH, 2019
01 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ACCOUNTS (CONTINUED)
--------------------
01-51020209 MEETINGS AND SEMINARS 0.00 1,729.33
01-51020210 EQUIPMENT MAINTENANCE 0.00 1,522.48
01-51020213 MILEAGE REIMBURSEMENT 0.00 41.97
01-51020220 COLLECTION DEVELOPMENT SUPP 0.00 2,063.73
01-51020221 AUDIO VISUAL MATERIAL 0.00 821.73
01-51020222 YOUTH OUTREACH 0.00 1,673.38
01-51020224 SENIOR OUTREACH 0.00 681.00
01-51020226 SPECIAL EVENTS 0.00 4,075.08
01-51020229 UNIFORMS 0.00 55.02
01-51020232 FURNITURE 0.00 2,726.15
01-51030302 TELEPHONE/BANDWITH 0.00 4,243.65
01-51030303 OFFICE EQUIPMENT LEASE PAYMENT 0.00 1,446.81
01-51030304 POSTAGE 0.00 556.51
01-51030307 CREDIT CARD FEES 0.00 967.50
01-51030310 INSURANCE (C.G.L.) 0.00 1,493.49
01-51030312 MAINTENANCE AGREEMENT 0.00 315.00
01-51030314 DUES & SUBSCRIPTIONS 0.00 3,165.05
01-51030319 MARKETING & ADVERTISING 0.00 1,298.40
01-51030338 MISCELLANEOUS 0.00 1,324.03
01-51030362 JANITORIAL SERVICES 0.00 1,295.36
01-51030382 INFO TECHNOLOGY PLAN 0.00 6,312.00
01-51110100 SALARY 0.00 251,266.77
01-51110111 OVERTIME 0.00 6,175.04
01-51110116 LONGEVITY 0.00 3,528.00
01-51110117 CERTIFICATE PAY 0.00 450.00
01-51110125 SOCIAL SECURITY 0.00 19,019.88
01-51110126 UNEMPLOYMENT TAX 0.00 68.97
01-51110127 RETIREMENT PLAN 0.00 20,522.12
01-51110128 HEALTH & DENTAL INS 0.00 34,658.82
01-51110130 COBRA COMPLIANCE PREMIUM 0.00 74.86
01-51110135 WORKERS' COMPENSATION 0.00 3,872.07
01-51110150 CELL PHONE ALLOWANCE 0.00 900.00
01-51120200 OFFICE SUPPLIES 0.00 190.13
01-51120201 BREAKROOM SUPPLIES 0.00 84.78
01-51120202 FUEL & OIL 0.00 11,737.55
01-51120208 SMALL TOOLS & SUPPLIES 0.00 6,040.36
01-51120209 MEETINGS AND SEMINARS 0.00 189.90
01-51120210 SMALL EQUIPMENT MAINTENANCE 0.00 5,084.53
01-51120212 VEHICLE MAINTENANCE 0.00 4,131.65
01-51120215 SAFETY EQUIPMENT 0.00 3,671.21
01-51120218 HEAVY EQUIPMENT MAINTENANCE 0.00 1,802.51
01-51120222 WORK SQUAD EXPENSES 0.00 488.03
01-51120229 UNIFORMS 0.00 2,179.02
01-51120241 CHEMICALS 0.00 2,185.70
01-51120265 TIRES, TUBES & BATTERIES 0.00 883.42
01-51120266 POWER TOOLS 0.00 2,477.86
01-51130300 UTILITIES 0.00 11,719.74
01-51130302 TELEPHONE 0.00 513.55
01-51130310 INSURANCE (C.G.L.) 0.00 10,251.44
01-51130314 DUES & SUBSCRIPTIONS 0.00 59.66
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 8
AS OF: SEPTEMBER 30TH, 2019
01 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ACCOUNTS (CONTINUED)
--------------------
01-51130327 RENT-AFP 0.00 1,733.36
01-51130338 MISCELLANEOUS 0.00 214.42
01-51130339 CITY PARK MAINTENANCE 0.00 4,467.79
01-51130342 LITTLE LEAGUE 0.00 5,603.53
01-51130343 SOCCER FIELDS 0.00 675.00
01-51130355 SOLID WASTE SERVICE 0.00 252.00
01-51130362 JANITORIAL SUPPLIES 0.00 3,148.47
01-51130366 CONTINGENCY EXPENSE 0.00 5,950.00
01-51130367 GROUNDS MAINTENANCE 0.00 6,718.67
01-51130382 INFO TECHNOLOGY PLAN 0.00 4,336.00
01-51140416 US 90 IRRIGATION 0.00 505.00
01-51140421 VEHICLE PURCHASE 0.00 26,106.50
01-51310100 SALARY 0.00 114,066.67
01-51310111 OVERTIME 0.00 1,216.48
01-51310116 LONGEVITY 0.00 684.00
01-51310125 SOCIAL SECURITY 0.00 8,303.40
01-51310126 UNEMPLOYMENT TAX 0.00 208.26
01-51310127 RETIREMENT PLAN 0.00 9,230.02
01-51310128 HEALTH & DENTAL INS 0.00 18,468.13
01-51310130 COBRA COMPLIANCE PREMIUM 0.00 35.97
01-51310135 WORKERS' COMPENSATION 0.00 5,805.21
01-51310150 CELL PHONE ALLOWANCE 0.00 450.00
01-51320200 OFFICE SUPPLIES 0.00 259.01
01-51320201 BREAKROOM SUPPLIES 0.00 67.82
01-51320202 FUEL & OIL 0.00 2,551.05
01-51320208 SMALL TOOLS & SUPPLIES 0.00 4,244.63
01-51320209 MEETINGS AND SEMINARS 0.00 79.60
01-51320210 EQUIPMENT MAINTENANCE 0.00 269.87
01-51320212 VEHICLE MAINTENANCE 0.00 1,610.48
01-51320215 SAFETY EQUIPMENT 0.00 1,997.79
01-51320221 WELDING SUPPLIES 0.00 1,056.56
01-51320222 WORK SQUAD EXPENSES 0.00 119.52
01-51320229 UNIFORMS 0.00 1,041.91
01-51320265 TIRES, TUBES & BATTERIES 0.00 366.00
01-51320266 POWER TOOLS 0.00 5,796.30
01-51330300 UTILITIES 0.00 426.94
01-51330302 TELEPHONE 0.00 454.91
01-51330305 BUILDING SECURITY 0.00 680.52
01-51330310 INSURANCE (C.G.L.) 0.00 5,101.34
01-51330311 ANIMAL CONTROL MAINT. 0.00 241.59
01-51330312 MAINTENANCE AGREEMENT 0.00 7,516.88
01-51330313 COMMUNITY CENTER MAINT. 0.00 15,554.64
01-51330315 DEMONTEL BUILDING MAINT. 0.00 221.87
01-51330316 BUILDING MAINTENANCE 0.00 8,014.34
01-51330317 CITY HALL MAINT. 0.00 2,718.08
01-51330318 LIBRARY BUILDING MAINT. 0.00 990.49
01-51330319 POST OFFICE MAINT. 0.00 423.08
01-51330320 POLICE DEPART. MAINT. 0.00 1,266.24
01-51330322 WATER DEPT. MAINT 0.00 136.04
01-51330323 WASTEWATER DEPT. MAINT. 0.00 194.13
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 9
AS OF: SEPTEMBER 30TH, 2019
01 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ACCOUNTS (CONTINUED)
--------------------
01-51330325 GOLF COURSE BUILDING MAINT. 0.00 167.51
01-51330326 RECREATION CENTER MAINT. 0.00 4,236.71
01-51330327 RENT-AFP 0.00 1,733.36
01-51330328 PUBLIC WORKS BLDG MAINT. 0.00 1,371.86
01-51330338 MISCELLANEOUS 0.00 74.91
01-51330349 STRTC MAINT. 0.00 1,057.37
01-51330350 SOUTHWEST FAMILY LIFE CTR 0.00 6,977.63
01-51330362 JANITORIAL SUPPLIES 0.00 399.50
01-51330382 INFO TECHNOLOGY PLAN 0.00 4,336.00
01-51510100 SALARY 0.00 124,189.98
01-51510111 OVERTIME 0.00 3,919.13
01-51510116 LONGEVITY 0.00 576.00
01-51510117 CERTIFICATE PAY 0.00 1,375.00
01-51510125 SOCIAL SECURITY 0.00 9,947.01
01-51510126 UNEMPLOYMENT TAX 0.00 837.84
01-51510127 RETIREMENT PLAN 0.00 9,748.12
01-51510128 HEALTH & DENTAL INS 0.00 9,477.18
01-51510130 COBRA COMPLIANCE PREMIUM 0.00 18.81
01-51510135 WORKERS' COMPENSATION 0.00 7,744.11
01-51510150 CELL PHONE ALLOWANCE 0.00 900.00
01-51520200 OFFICE SUPPLIES 0.00 1,021.37
01-51520202 FUEL & OIL 0.00 322.64
01-51520203 BREAKROOM SUPPLIES 0.00 167.68
01-51520209 MEETINGS AND SEMINARS 0.00 7,872.03
01-51520210 EQUIPMENT MAINTENANCE 0.00 1,824.37
01-51520212 VEHICLE MAINTENANCE 0.00 749.61
01-51520214 STRUCTURE MAINTENANCE 0.00 4,149.42
01-51520215 SAFETY EQUIPMENT 0.00 2,020.45
01-51520220 LANDSCAPING 0.00 268.02
01-51520221 POOL MAINTENANCE 0.00 5,205.00
01-51520223 CONCESSION SUPPLIES 0.00 1,862.61
01-51520226 ADULT LEAGUES 0.00 523.30
01-51520227 SPECIAL EVENTS 0.00 2,425.42
01-51520228 SPECIAL YOUTH LEAGUES 0.00 7,258.10
01-51520229 UNIFORMS 0.00 255.00
01-51520237 SUMMER CAMP PROGRAMS 0.00 250.00
01-51520238 RECREATION SUPPLIES 0.00 2,846.60
01-51520239 POOL SUPPLIES 0.00 390.00
01-51520241 CHEMICALS 0.00 6,716.00
01-51530300 UTILITIES 0.00 5,986.22
01-51530302 TELEPHONE 0.00 2,154.67
01-51530303 OFFICE EQUIPMENT LEASE PAYMENT 0.00 812.40
01-51530304 OFFICIAL FEES 0.00 9,516.20
01-51530305 BUILDING SECURITY 0.00 531.04
01-51530306 POSTAGE 0.00 2.28
01-51530307 REC CENTER IMPROVEMENTS 0.00 8,263.73
01-51530309 FITNESS EQUIPMENT 0.00 1,103.39
01-51530310 INSURANCE (C.G.L.) 0.00 746.09
01-51530314 DUES & SUBSCRIPTIONS 0.00 2,142.62
01-51530315 LIFEGUARD CERTIFICATION 0.00 56.00
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 10
AS OF: SEPTEMBER 30TH, 2019
01 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ACCOUNTS (CONTINUED)
--------------------
01-51530319 MARKETING & ADVERTISING 0.00 7,960.00
01-51530327 RENT-REC. CENTER LAND 0.00 1,400.00
01-51530338 MISCELLANEOUS 0.00 1,545.34
01-51530345 LICENSE & FEES 0.00 374.00
01-51530362 JANITORIAL SUPPLIES 0.00 3,742.91
01-51530370 CONTRACT LABOR 0.00 1,590.00
01-51530382 INFO TECHNOLOGY PLAN 0.00 4,055.00
01-51610100 SALARY 0.00 74,196.42
01-51610111 OVERTIME 0.00 601.31
01-51610116 LONGEVITY 0.00 180.00
01-51610125 SOCIAL SECURITY 0.00 5,678.75
01-51610126 UNEMPLOYMENT TAX 0.00 137.63
01-51610127 RETIREMENT PLAN 0.00 5,307.59
01-51610128 HEALTH & DENTAL INS 0.00 5,460.10
01-51610130 COBRA COMPLIANCE PREMIUM 0.00 10.61
01-51610135 WORKERS COMPENSATION 0.00 2,043.42
01-51610150 CELL PHONE ALLOWANCE 0.00 450.00
01-51620200 OFFICE SUPPLIES 0.00 165.78
01-51620202 FUEL & OIL 0.00 3,067.02
01-51620208 SMALL TOOLS & SUPPLIES 0.00 1,072.07
01-51620209 MEETINGS AND SEMINARS 0.00 30.00
01-51620210 EQUIPMENT MAINTENANCE 0.00 1,781.04
01-51620214 MERCHANDISE 0.00 7,025.54
01-51620227 SPRINKLER 0.00 1,222.12
01-51620229 UNIFORMS 0.00 284.90
01-51620231 CONCESSIONS 0.00 9,717.29
01-51620241 CHEMICALS 0.00 2,958.59
01-51620265 TIRES, TUBES & BATTERIES 0.00 625.43
01-51620266 POWER TOOLS 0.00 215.78
01-51630300 UTILITIES 0.00 2,027.10
01-51630302 TELEPHONE AND DSL LINE 0.00 2,059.17
01-51630303 GOLF CARTS LEASE 0.00 17,455.51
01-51630304 POSTAGE 0.00 1.41
01-51630305 BUILDING SECURITY 0.00 174.65
01-51630307 CREDIT CARD FEES 0.00 667.50
01-51630310 INSURANCE (C.G.L.) 0.00 1,083.54
01-51630314 DUES & SUBSCRIPTIONS 0.00 942.53
01-51630327 RENT 0.00 9,333.36
01-51630338 MISCELLANEOUS 0.00 1,423.63
01-51630345 LICENSE & FEES 0.00 607.50
01-51630362 JANITORIAL SUPPLIES 0.00 1,110.73
01-51630367 GROUNDS MAINTENANCE 0.00 9,066.14
01-51630382 INFO TECHNOLOGY PLAN 0.00 4,336.00
01-51640408 MULTIPURPOSE MOWER 0.00 8,119.36
01-51640409 CART PATH 0.00 7,862.00
01-51640422 GREENS EQUIPMENT 0.00 14,769.75
01-51710100 SALARY 0.00 118,870.40
01-51710111 OVERTIME 0.00 1,927.56
01-51710116 LONGEVITY 0.00 540.00
01-51710125 SOCIAL SECURITY 0.00 9,484.72
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 11
AS OF: SEPTEMBER 30TH, 2019
01 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ACCOUNTS (CONTINUED)
--------------------
01-51710127 RETIREMENT PLAN 0.00 9,760.23
01-51710128 HEALTH & DENTAL INS 0.00 12,319.69
01-51710130 COBRA COMPLIANCE PREMIUM 0.00 23.09
01-51710135 WORKERS COMPENSATION 0.00 471.90
01-51710149 AUTO ALLOWANCE 0.00 3,600.00
01-51710150 CELL PHONE ALLOWANCE 0.00 450.00
01-51720200 OFFICE SUPPLIES 0.00 1,328.97
01-51720201 BREAKROOM SUPPLIES 0.00 148.57
01-51720202 FUEL & OIL 0.00 684.03
01-51720208 SMALL TOOLS & SUPPLIES 0.00 9.97
01-51720209 MEETINGS AND SEMINARS 0.00 1,631.69
01-51720212 VEHICLE MAINTENANCE 0.00 928.17
01-51720215 SAFETY EQUIPMENT 0.00 233.35
01-51720229 UNIFORMS 0.00 594.51
01-51720265 TIRES, TUBES & BATTERIES 0.00 30.00
01-51730300 UTILITIES 0.00 74.76
01-51730302 TELEPHONE 0.00 2,055.03
01-51730303 OFFICE EQUIPMENT LEASE PAYMENT 0.00 982.87
01-51730304 POSTAGE 0.00 1,270.31
01-51730305 BUILDING SECURITY 0.00 384.22
01-51730306 CONTRACT INSPECTIONS 0.00 31,511.94
01-51730307 CREDIT CARD FEES 0.00 1,716.00
01-51730310 INSURANCE (C.G.L.) 0.00 373.04
01-51730314 DUES & SUBSCRIPTIONS 0.00 211.94
01-51730322 ENGINEERING FEES 0.00 8,295.00
01-51730327 RENT 0.00 4,800.00
01-51730330 LEGAL FEES 0.00 19,789.00
01-51730362 JANITORIAL SUPPLIES 0.00 454.80
01-51730382 INFO TECHNOLOGY PLAN 0.00 7,233.00
01-51810100 SALARY 0.00 94,002.88
01-51810111 OVERTIME 0.00 827.62
01-51810116 LONGEVITY 0.00 720.00
01-51810125 SOCIAL SECURITY 0.00 7,158.68
01-51810126 UNEMPLOYMENT TAX 0.00 38.55
01-51810127 RETIREMENT PLAN 0.00 7,641.72
01-51810128 HEALTH & DENTAL INS 0.00 12,256.76
01-51810130 COBRA COMPLIANCE PREMIUM 0.00 20.79
01-51810135 WORKER'S COMPENSATION 0.00 501.81
01-51820200 OFFICE SUPPLIES 0.00 6,686.98
01-51820209 MEETINGS AND SEMINARS 0.00 2,046.85
01-51820229 UNIFORMS 0.00 70.55
01-51830302 TELEPHONE 0.00 38.13
01-51830303 OFFICE EQUIPMENT LEASE PAYMENT 0.00 1,188.57
01-51830304 POSTAGE 0.00 12,546.03
01-51830307 CREDIT CARD FEES 0.00 1,286.21
01-51830310 INSURANCE (C.G.L.) 0.00 995.22
01-51830320 COLLECTION AGENCY FEES 0.00 2,862.58
01-51830338 MISCELLANEOUS 0.00 608.50
01-51830345 LICENSE & FEES 0.00 340.99
01-51830382 INFO TECHNOLOGY PLAN 0.00 1,681.00
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 12
AS OF: SEPTEMBER 30TH, 2019
01 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ACCOUNTS (CONTINUED)
--------------------
01-51910100 SALARY 0.00 60,999.69
01-51910111 OVERTIME 0.00 369.52
01-51910116 LONGEVITY 0.00 108.00
01-51910125 SOCIAL SECURITY 0.00 4,702.47
01-51910127 RETIREMENT 0.00 4,909.91
01-51910128 HEALTH & DENTAL INS 0.00 6,256.02
01-51910130 COBRA COMPLIANCE PREMIUM 0.00 12.54
01-51910135 WORKERS COMPENSATION 0.00 250.92
01-51910150 CELL PHONE ALLOWANCE 0.00 450.00
01-51920200 OFFICE SUPPLIES 0.00 3,484.03
01-51920205 BOARD AND COMMISSION SUPPLIES 0.00 33.90
01-51920207 PRINTING AND STATIONARY 0.00 51.14
01-51920209 MEETINGS AND SEMINARS 0.00 2,229.68
01-51920213 MILEAGE REIMBURSEMENT 0.00 1,277.24
01-51920231 OFFICE EQUIPMENT 0.00 30.12
01-51930302 TELEPHONE 0.00 38.13
01-51930304 POSTAGE 0.00 3,686.84
01-51930314 DUES & SUBSCRIPTIONS 0.00 874.75
01-51930316 LEGAL NOTICES 0.00 1,072.50
01-51930329 LEGAL FEES/CODIFI ORD 0.00 8,573.80
01-51930332 ELECTION EXPENSE 0.00 1,280.00
01-51930334 PLANNING & ZONING 0.00 138.20
01-51930338 MISCELLANEOUS 0.00 280.35
01-51930382 INFO TECHNOLOGY PLAN 0.00 1,373.00
01-52030302 NON-PROFIT GROUPS 0.00 7,035.00
01-52110100 SALARY 0.00 73,695.79
01-52110116 LONGEVITY 0.00 72.00
01-52110125 SOCIAL SECURITY 0.00 6,100.23
01-52110126 UNEMPLOYMENT TAX 0.00 255.02
01-52110127 RETIREMENT PLAN 0.00 6,624.30
01-52110128 HEALTH & DENTAL INS 0.00 1,418.34
01-52110130 COBRA COMPLIANCE PREMIUM 0.00 0.66
01-52110135 WORKERS COMPENSATION 0.00 250.92
01-52110149 AUTO ALLOWANCE 0.00 5,400.00
01-52110150 CELL PHONE ALLOWANCE 0.00 625.00
01-52120200 OFFICE SUPPLIES 0.00 375.86
01-52120209 MEETINGS AND SEMINARS 0.00 743.98
01-52130300 UTILITIES 0.00 108.90
01-52130302 TELEPHONE 0.00 177.88
01-52130304 POSTAGE 0.00 27.47
01-52130338 MISCELLANEOUS 0.00 219.02
______________ ______________ ______________ ______________
FUND TOTAL 0.00 0.00 7,861,343.81 7,861,343.81
============== ============== ============== ==============
*** END OF REPORT ***
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
02 -ELECTRIC FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
02-1100.01 CLAIM ON CASH 0.00 1,001,661.08
02-1102 CASH DRAWERS 0.00 220.00
02-1110 ELECTRIC CUSTOMER DEPOSITS 0.00 2,780.38
02-1132 ELECTRIC ACCTS RECEIVABLE 0.00 830,404.14
02-1133 SALES TAX RECEIVABLE 0.00 24,637.88
02-1134 ALLOW FOR DOUBTFUL ACCTS 0.00 32,335.37
02-1135 REFUNDS DUE 0.00 3,230.70
02-1137 MISC ELECTRIC A/R 0.00 17,924.16
02-1138 U/S UNAPPLIED CREDIT 0.00 63,559.10
02-1139 AMP RECEIVABLE 0.00 19,028.25
02-1140 UNBILLED RECEIVABLE 0.00 460,777.10
02-1148 DEFERRED PENSION OUT - CONTRIB 0.00 67,496.23
02-1148.10 DEFERRED TMRS OPEB OUTFLOWS 0.00 2,058.03
02-1162 INVENTORY 0.00 229,247.83
02-1164 TRANSFORMER INVENTORY 0.00 4,360.00
02-1172 LAND & RIGHT-OF-WAYS 0.00 137,103.61
02-1174 SUBSTATION & SYSTEM IMP 0.00 2,224,847.47
02-1176 POLES, TOWERS & FIXTURES 0.00 439,380.98
02-1178 METERS & INSTALLATION 0.00 325,900.25
02-1180 BUILDINGS 0.00 109,052.00
02-1182 AUTOS, TRUCKS & TRACTORS 0.00 762,328.34
02-1186 MOBILE RADIOS 0.00 22,154.15
02-1188 OFFICE EQUIPMENT 0.00 42,477.96
02-1194 HOSPITAL & HELIPORT LGH 0.00 1,503.00
02-1197 CONSTRUCTION IN PROGRESS 0.00 95,826.00
02-1198 ACCUMULATED DEPRECIATION 0.00 2,873,142.38
02-1200.01 AP PENDING 0.00 598,823.85
02-1201.04 TMRS 0.00 5,644.80
02-1201.05 INSURANCE PAYABLE 0.00 3,176.09
02-1208 ACCRUED INT PAYABLE 0.00 1,385.10
02-1217 UNAPPLIED CREDIT 0.00 395.25
02-1223 2016 BONDS - LONG-TERM PORTION 0.00 465,000.00
02-1224 2016 BONDS - CURRENT PORTION 0.00 50,000.00
02-1231 DEFERRED AMP REVENUE 0.00 19,100.66
02-1232 SALES TAX PAYABLE 0.00 24,177.19
02-1242 CUSTOMER DEPOSITS 0.00 298,848.26
02-1255 ACCRUED PAYROLL 0.00 21,800.85
02-1256 ACCRUED VACATION PAY 0.00 12,085.87
02-1257 OPEB LIABILITY 0.00 32,907.35
02-1258 NET PENSION LIABILITY 0.00 49,869.78
02-1258.10 TOTAL TMRS OPEB LIABILITY 0.00 27,853.63
02-1259 DEFERRED PENSION INFLO-EXPERNC 0.00 103,534.20
02-1279 PRIOR PERIOD ADJUSTMENT 0.00 30,148.22
02-1280 FUND BALANCE 0.00 1,107,257.12
02-1281 CONT. IN AID OF CONST 0.00 66,531.00
02-1288 NET INVESTMENT IN CAP ASSETS 0.00 772,431.00
02-1290 PAYROLL CLEARING 0.00 12,813.44
02-1302 RESIDENTIAL ELECTRIC 0.00 2,307,026.19
02-1304 COMMERCIAL ELECTRIC 0.00 2,617,611.55
02-1306 INDUSTRIAL ELECTRIC 0.00 436,630.54
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 2
AS OF: SEPTEMBER 30TH, 2019
02 -ELECTRIC FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ACCOUNTS (CONTINUED)
--------------------
02-1308 SECURITY LIGHTS 0.00 11,484.86
02-1310 PENALTIES 0.00 76,374.83
02-1312 RECONNECT FEE 0.00 4,875.00
02-1314 NEW SERVICE 0.00 2,000.00
02-1320 MISCELLANEOUS 0.00 1,400.11
02-1324 RETURN CHECK FEE 0.00 185.00
02-1330 NEW INSTALLS REVENUES 0.00 1,054.30
02-1368 MISCELLANEOUS 0.00 1,547.85
02-1378 TOBACCO/WELLNESS CONTRIBUTION 0.00 292.70
02-50010100 SALARY 0.00 298,015.46
02-50010111 OVERTIME/CALL OUT 0.00 23,815.39
02-50010116 LONGEVITY 0.00 1,476.00
02-50010125 SOCIAL SECURITY 0.00 23,212.97
02-50010127 RETIREMENT PLAN 0.00 25,512.34
02-50010128 HEALTH & DENTAL INS 0.00 31,406.30
02-50010130 COBRA COMPLIANCE PREMIUM 0.00 61.15
02-50010135 WORKERS' COMPENSATION 0.00 5,578.47
02-50010150 CELL PHONE ALLOWANCE 0.00 900.00
02-50020200 OFFICE SUPPLIES 0.00 893.02
02-50020201 BREAKROOM SUPPLIES 0.00 555.10
02-50020202 FUEL & OIL 0.00 8,976.31
02-50020208 SMALL TOOLS & SUPPLIES 0.00 15,747.39
02-50020209 MEETINGS AND SEMINARS 0.00 8,436.66
02-50020210 EQUIPMENT MAINTENANCE 0.00 3,656.29
02-50020211 SYSTEM MAINTENANCE 0.00 122,905.74
02-50020212 VEHICLE MAINTENANCE 0.00 7,785.45
02-50020213 SYSTEM IMPROVEMENTS 0.00 55,277.23
02-50020215 SAFETY EQUIPMENT 0.00 13,392.39
02-50020229 UNIFORMS 0.00 3,896.90
02-50020265 TIRES, TUBES & BATTERIES 0.00 300.74
02-50020267 SAFETY TRAINING MATERIALS 0.00 184.45
02-50030300 UTILITIES 0.00 700.68
02-50030301 COST OF POWER 0.00 2,101,376.29
02-50030302 TELEPHONE 0.00 2,960.14
02-50030304 POSTAGE 0.00 87.97
02-50030310 INSURANCE (C.G.L.) 0.00 14,930.96
02-50030314 DUES & SUBSCRIPTIONS 0.00 148.20
02-50030322 ENGINEER FEES 0.00 1,172.39
02-50030327 P.I.L.O.T. - GENERAL 0.00 1,850,000.00
02-50030338 MISCELLANEOUS 0.00 230.25
02-50030345 LICENSE & FEES 0.00 337.22
02-50030362 JANITORIAL SUPPLIES 0.00 643.35
02-50030382 INFO TECHNOLOGY PLAN 0.00 69,243.00
02-50030383 OH ALLOCATION FRM GENERAL FUND 0.00 205,594.00
02-50040468 PUBLIC WORKS BUILDING 0.00 306,644.40
02-50040469 BUCKET TRUCK 0.00 274.90
02-50050504 TRF OUT CO '16 PRIN 0.00 50,000.00
02-50050505 TRF OUT CO '16 INTEREST 0.00 4,155.30
______________ ______________ ______________ ______________
FUND TOTAL 0.00 0.00 12,109,093.89 12,109,093.89
============== ============== ============== ==============
*** END OF REPORT ***
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
03 -WATER & SEWER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
03-1100.01 CLAIM ON CASH 0.00 2,166,162.72
03-1102 PETTY CASH DRAWERS 0.00 110.00
03-1109 TWDB ESCROW 2017 BONDS 0.00 2,121,919.62
03-1110 WATER PETTY CASH (CUST DEPOSIT 0.00 1,408.28
03-1111 TWDB PLANNING & DESIGN ACCOUNT 0.00 51,080.50
03-1112 A/R TWDB CONSTRUCTION BONDS 0.00 27,526.90
03-1122 WATER RIGHTS - OWNED 0.00 199,540.60
03-1132 WATER ACCTS RECEIVABLE 0.00 247,789.48
03-1133 SEWER UTILITY ACCTS RECEL 0.00 113,649.55
03-1134 ALLOW FOR DOUBTFUL ACCTS 0.00 9,545.85
03-1135 REFUNDS DUE 0.00 296.04
03-1142 UNBILLED RECEIVABLE 0.00 186,021.75
03-1148 DEFERRED PENSION OUT - CONTRIB 0.00 53,636.88
03-1148.10 DEFERRED TMRS OPEB OUTFLOWS 0.00 2,116.46
03-1162 INVENTORY 0.00 140,585.23
03-1172 LAND & RIGHT-OF-WAYS 0.00 337,724.79
03-1182 INFRASTRUCTURE 0.00 14,997,375.74
03-1184 OTHER EQUIPMENT 0.00 598,583.93
03-1186 BUILDINGS 0.00 2,923,787.10
03-1187 AUTOS, TRUCKS, TRACTORS 0.00 185,776.64
03-1196 ACCUMULATED DEPRECIATION 0.00 9,808,758.40
03-1197 CONSTRUCTION IN PROGRESS 0.00 3,824,200.60
03-1200.01 AP PENDING 0.00 15,007.86
03-1201 WATER RESOURCE FEE 0.00 15,559.51
03-1201.04 TMRS 0.00 6,054.50
03-1201.05 INSURANCE PAYABLE 0.00 2,435.38
03-1205 C.O.'S INTEREST PAYABLE 0.00 28,495.00
03-1224 2014 REFUNDING - LONG TERM 0.00 381,840.00
03-1225 2014 REFUNDING - CURRENT PORTI 0.00 56,610.00
03-1230 2013 BONDS - LONG TERM 0.00 200,000.00
03-1231 2013 BONDS - CURRENT PORTION 0.00 50,000.00
03-1232 2015 BONDS - LONG TERM 0.00 1,195,000.00
03-1233 2015 BONDS - CURRENT PORTION 0.00 60,000.00
03-1236 2016 BONDS - LONG-TERM PORTION 0.00 465,000.00
03-1237 2016 BONDS - CURRENT PORTION 0.00 50,000.00
03-1238 2017 BONDS - LONG TERM 0.00 4,805,000.00
03-1239 2017 BONDS - CURRENT 0.00 240,000.00
03-1242 CUSTOMER DEPOSITS 0.00 100,085.00
03-1255 ACCRUED PAYROLL 0.00 21,466.66
03-1256 ACCRUED VACATION PAY 0.00 7,243.32
03-1257 OPEB LIABILITY 0.00 34,813.82
03-1258 NET PENSION LIABILITY 0.00 40,280.83
03-1258.10 TOTAL TMRS OPEB LIABILITY 0.00 28,644.37
03-1259 DEFERRED PENSION INFLO-EXPUENC 0.00 100,057.97
03-1260 DEFERRED REVENUE - TWDB 13 GRA 0.00 0.04
03-1279 PRIOR PERIOD ADJUSTMENT 0.00 31,004.09
03-1280 FUND BALANCE 0.00 1,350,805.10
03-1288 NET INVESTMENT IN CAP ASSETS 0.00 7,904,228.00
03-1290 PAYROLL CLEARING 0.00 12,105.89
03-1302 RESIDENTIAL WATER 0.00 746,142.45
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 2
AS OF: SEPTEMBER 30TH, 2019
03 -WATER & SEWER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ACCOUNTS (CONTINUED)
--------------------
03-1304 COMMERCIAL WATER 0.00 789,084.59
03-1307 EAA AQUIFER MANAGEMENT FEES 0.00 132,081.16
03-1310 PENALTIES 0.00 21,052.03
03-1312 RECONNECT FEES 0.00 3,800.00
03-1313 WATER METERS 0.00 9,056.00
03-1320 MISCELLANEOUS 0.00 3,910.00
03-1352 SEWER REVENUE 0.00 798,480.08
03-1356 SEWER PENALTY 0.00 12,423.84
03-1358 SEWER TAP FEES 0.00 8,000.00
03-1378 TOBACCO/WELLNESS CONTRIBUTION 0.00 1,653.90
03-1601 DWSRF GRANT REVENUES 0.00 625,937.90
03-50110100 SALARY 0.00 194,788.57
03-50110111 OVERTIME/CALL OUT 0.00 19,325.98
03-50110116 LONGEVITY 0.00 252.00
03-50110117 CERTIFICATE PAY 0.00 900.00
03-50110125 SOCIAL SECURITY 0.00 16,083.89
03-50110127 RETIREMENT PLAN 0.00 16,872.08
03-50110128 HEALTH & DENTAL INS 0.00 23,175.11
03-50110130 COBRA COMPLIANCE PREMIUM 0.00 44.46
03-50110135 WORKERS' COMPENSATION 0.00 4,974.06
03-50110150 CELL PHONE ALLOWANCE 0.00 1,350.00
03-50120200 OFFICE SUPPLIES 0.00 904.05
03-50120201 BREAKROOM SUPPLIES 0.00 167.64
03-50120202 FUEL & OIL 0.00 8,173.12
03-50120208 SMALL TOOLS & SUPPLIES 0.00 9,658.14
03-50120209 MEETINGS & SEMINARS 0.00 3,868.98
03-50120210 EQUIPMENT MAINTENANCE 0.00 1,685.16
03-50120211 SYSTEM MAINTENANCE 0.00 39,755.68
03-50120212 VEHICLE MAINTENANCE 0.00 4,896.48
03-50120213 SYSTEM IMPROVEMENTS 0.00 4,438.60
03-50120215 SAFETY EQUIPMENT 0.00 2,013.72
03-50120216 STRUCTURE MAINTENANCE 0.00 81.67
03-50120229 UNIFORMS 0.00 3,016.35
03-50120232 OFFICE FURNITURE 0.00 127.98
03-50120241 CHEMICALS 0.00 8,174.16
03-50120265 TIRES, TUBES & BATTERIES 0.00 1,574.55
03-50130300 UTILITIES 0.00 3,799.85
03-50130302 TELEPHONE 0.00 1,567.23
03-50130304 POSTAGE 0.00 33.74
03-50130305 BUILDING SECURITY 0.00 339.15
03-50130310 INSURANCE (C.G.L.) 0.00 18,662.70
03-50130313 EAA FEES 0.00 148,171.52
03-50130314 DUES & SUBSCRIPTIONS 0.00 148.20
03-50130322 ENGINEER FEES 0.00 285.00
03-50130327 P.I.L.O.T. - GENERAL 0.00 161,000.00
03-50130338 MISCELLANEOUS 0.00 589.90
03-50130340 INSPECTION FEES 0.00 2,050.00
03-50130345 LICENSE & FEES 0.00 462.00
03-50130361 WATER TESTING 0.00 2,950.71
03-50130362 JANITORIAL SUPPLIES 0.00 850.59
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 3
AS OF: SEPTEMBER 30TH, 2019
03 -WATER & SEWER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ACCOUNTS (CONTINUED)
--------------------
03-50130367 TECQ FEES 0.00 9,018.45
03-50130382 INFO TECHNOLOGY PLAN 0.00 11,297.00
03-50130383 OH ALLOCATION FRM GENERAL FUND 0.00 120,726.00
03-50130398 RAILROAD LAND LEASES 0.00 1,556.47
03-50140405 WATER METER REPLACEMENT 0.00 50,073.10
03-50140408 VACTRON 0.00 67,075.00
03-50140410 VEHICLE REPLACEMENT 0.00 33,332.40
03-50140411 DOWNTOWN ELEVATED TANK 0.00 2,672.00
03-50150508 2013 DWSRF PRINCIPAL 0.00 50,000.00
03-50150509 2013 DWSRF INTEREST 0.00 1,800.00
03-50150510 TRF OUT 2014 GO REFD BOND PRIN 0.00 56,610.00
03-50150511 TRF OUT 2014 GO REFD BOND INT 0.00 5,886.89
03-50150513 CO SERIES 2015 - INTEREST 0.00 16,692.25
03-50150514 2016 DWSRF LOAN PRINCIPAL 0.00 50,000.00
03-50150515 2016 DWSRF LOAN INTEREST 0.00 4,155.30
03-50150517 CO SERIES 2017 INTEREST 0.00 56,950.50
03-50199999 TRANSFER STREET REPAIRS 0.00 15,000.00
03-50210100 SALARY 0.00 103,682.84
03-50210111 OVERTIME/CALL OUT 0.00 15,454.29
03-50210116 LONGEVITY 0.00 180.00
03-50210117 CERTIFICATE PAY 0.00 150.00
03-50210125 SOCIAL SECURITY 0.00 8,581.51
03-50210126 UNEMPLOYMENT TAX 0.00 169.20
03-50210127 RETIREMENT PLAN 0.00 8,578.21
03-50210128 HEALTH & DENTAL INS 0.00 7,472.14
03-50210130 COBRA COMPLIANCE PREMIUM 0.00 20.88
03-50210135 WORKERS' COMPENSATION 0.00 2,942.22
03-50210150 CELL PHONE ALLOWANCE 0.00 450.00
03-50220200 OFFICE SUPPLIES 0.00 209.40
03-50220201 BREAKROOM SUPPLIES 0.00 500.12
03-50220202 FUEL & OIL 0.00 4,048.87
03-50220208 SMALL TOOLS & SUPPLIES 0.00 2,370.03
03-50220209 MEETINGS & SEMINARS 0.00 3,808.29
03-50220210 EQUIPMENT MAINTENANCE 0.00 4,022.27
03-50220211 SYSTEM MAINTENANCE 0.00 41,259.45
03-50220212 VEHICLE MAINTENANCE 0.00 821.16
03-50220215 SAFETY EQUIPMENT 0.00 6,855.96
03-50220229 UNIFORMS 0.00 1,175.21
03-50220241 CHEMICALS 0.00 37,288.01
03-50220250 LAB SUPPLIES 0.00 6,538.30
03-50220265 TIRES, TUBES & BATTERIES 0.00 38.99
03-50230300 UTILITIES 0.00 7,922.52
03-50230302 TELEPHONE 0.00 1,810.29
03-50230304 POSTAGE 0.00 0.65
03-50230310 INSURANCE (C.G.L.) 0.00 9,953.53
03-50230314 DUES & SUBSCRIPTIONS 0.00 255.00
03-50230323 SLUDGE REMOVAL 0.00 10,069.02
03-50230327 P.I.L.O.T. - GENERAL 0.00 92,325.36
03-50230338 MISCELLANEOUS 0.00 31.83
03-50230345 LICENSE & FEES 0.00 444.00
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 4
AS OF: SEPTEMBER 30TH, 2019
03 -WATER & SEWER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ACCOUNTS (CONTINUED)
--------------------
03-50230360 RENT 0.00 10,125.00
03-50230361 SEWER TESTING 0.00 14,795.71
03-50230362 JANITORIAL SUPPLIES 0.00 551.34
03-50230367 TCEQ PERMIT 0.00 13,280.60
03-50230382 INFO TECHNOLOGY PLAN 0.00 9,097.00
03-50230383 OH ALLOCATION FRM GENERAL FUND 0.00 58,510.64
03-50240401 SEWER PLANT IMPROVEMENTS 0.00 24,668.00
03-50240436 SSO SEWER IMPROVEMENTS 0.00 51,200.00
03-50942415 17 ADMIN FEES 0.00 12,000.00
03-50983460 WATER LINE CONSTRUCTION 0.00 54,694.89
03-50983470 NEW EST CONSTRUCTION 0.00 39,000.00
03-50983480 GST REHAB CONSTRUCTION 0.00 5,768.00
______________ ______________ ______________ ______________
FUND TOTAL 0.00 0.00 30,142,067.73 30,142,067.73
============== ============== ============== ==============
*** END OF REPORT ***
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
04 -AIRPORT FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
04-1100.01 CLAIM ON CASH 0.00 265,787.06
04-1132 ACCOUNTS RECEIVABLE 0.00 65,438.90
04-1134 ALLOW FOR DOUBTFUL ACCTS 0.00 24,529.82
04-1148 DEFERRED PENSION OUT - CONTRIB 0.00 25,976.38
04-1148.10 DEFERRED TMRS OPEB OUTFLOWS 0.00 821.87
04-1162 INVENTORY 0.00 27,099.64
04-1172 LAND & RIGHT-OF-WAYS 0.00 1,809,519.67
04-1174 BUILDINGS 0.00 15,464,024.27
04-1176 AUTOS, TRUCKS, TRACTORS 0.00 7,990.00
04-1183 EQUIPMENT 0.00 245,026.66
04-1185 INFRASTRUCTURE 0.00 5,365,503.15
04-1197 CONSTRUCTION IN PROGRESS 0.00 59,634.15
04-1198 ACCUMULATED DEPRECIATION 0.00 6,570,710.48
04-1200.01 AP PENDING 0.00 5,788.40
04-1201.04 TMRS 0.00 2,129.04
04-1201.05 INSURANCE PAYABLE 0.00 96.06
04-1217 UNAPPLIED CREDIT 0.00 7,773.91
04-1228 2016 BONDS - LONG-TERM PORTION 0.00 140,000.00
04-1229 2016 BONDS - CURRENT PORTION 0.00 15,000.00
04-1230 ACCRUED INTEREST PAYABLE 0.00 417.03
04-1255 ACCRUED PAYROLL 0.00 8,829.01
04-1256 ACCRUED VACATION PAY 0.00 2,385.26
04-1257 ACCRUED LIABILITY 0.00 13,081.70
04-1258 NET PENSION LIABILITY 0.00 17,047.35
04-1258.10 TOTAL TMRS OPEB LIABILITY 0.00 11,123.22
04-1259 DEFERRED PENSION INFLO-EXPERNC 0.00 42,228.05
04-1279 PRIOR PERIOD ADJUSTMENT 0.00 12,039.55
04-1280 FUND BALANCE 0.00 245,028.98
04-1288 NET INVESTMENT IN CAP ASSETS 0.00 16,225,987.00
04-1290 PAYROLL CLEARING 0.00 5,152.93
04-1302 AVGAS 100LL AVIATION FUEL 0.00 97,543.59
04-1304 JET A AVIATION FUEL 0.00 158,309.24
04-1315 OPEN T HANGARS 0.00 3,727.50
04-1317 ENCLOSED HANGAR RENT 0.00 46,738.59
04-1320 MISC SVC PARKING, GPU, CALLOUT 0.00 4,078.00
04-1325 AIRPORT SERVICES 0.00 935.00
04-1350 TERMINAL BLD. OFC. RENTAL 0.00 1,344.00
04-1368 MISCELLANEOUS 0.00 691.69
04-1377 HANGAR MR-2 0.00 1,494.00
04-1378 TOBACCO/WELLNESS CONTRIBUTION 0.00 40.00
04-1381 HANGAR ER-2 0.00 86,324.16
04-1382 HANGAR MR-3&4 0.00 51,750.00
04-1383 HANGAR ER-3 0.00 29,882.56
04-1384 HANGAR MR-7 0.00 9,856.00
04-1385 HANGAR MR-8 0.00 6,330.00
04-1386 HANGAR MR-9 0.00 8,000.00
04-1388 HANGAR MR-1 0.00 3,510.00
04-1389 HANGAR MR-5 0.00 1,430.72
04-1403 STREET RENT 0.00 1,733.36
04-1406 ANIMAL SHELTER RENT 0.00 1,733.36
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 2
AS OF: SEPTEMBER 30TH, 2019
04 -AIRPORT FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ACCOUNTS (CONTINUED)
--------------------
04-1408 PARKS RENT 0.00 1,733.36
04-1409 SERVICE DEPT. RENT 0.00 1,733.36
04-1410 RECREATION CENTER LAND/RENT 0.00 1,400.00
04-1411 DEMONTEL BUILDING RENT 0.00 4,800.00
04-1412 BUILDING RENT 0.00 100.00
04-1413 GOLF COURSE RENT 0.00 9,333.36
04-1414 FARM LAND LEASE 0.00 59,363.62
04-1420 WATER FUND - LEASE OF WATER 0.00 13,200.00
04-1463 HONDO ART LEAGUE 0.00 200.00
04-1487 ACI REFUSE 0.00 7,200.00
04-50110100 SALARY 0.00 116,884.81
04-50110111 OVERTIME 0.00 9,332.92
04-50110116 LONGEVITY 0.00 180.00
04-50110125 SOCIAL SECURITY 0.00 9,994.06
04-50110126 UNEMPLOYMENT TAX 0.00 174.14
04-50110127 RETIREMENT PLAN 0.00 8,396.20
04-50110128 HEALTH & DENTAL INS 0.00 12,282.90
04-50110130 COBRA COMPLIANCE PREMIUM 0.00 19.28
04-50110135 WORKERS COMPENSATION 0.00 2,792.94
04-50110149 AUTO ALLOWANCE 0.00 3,600.00
04-50110150 CELL PHONE ALLOWANCE 0.00 900.00
04-50120200 OFFICE SUPPLIES 0.00 1,347.70
04-50120201 BREAKROOM SUPPLIES 0.00 291.99
04-50120202 FUEL & OIL 0.00 3,416.98
04-50120204 OFFICE FURNITURE 0.00 384.00
04-50120208 SMALL TOOLS & SUPPLIES 0.00 1,711.22
04-50120209 MEETINGS & SEMINARS 0.00 2,298.23
04-50120210 EQUIPMENT MAINTENANCE 0.00 3,357.12
04-50120215 SAFETY EQUIPMENT 0.00 495.19
04-50120229 UNIFORMS 0.00 225.88
04-50120246 100LL AVIATION GASOLINE 0.00 80,896.24
04-50120247 JET A AVIATION FUEL 0.00 96,621.60
04-50120248 JET TRUCK LEASE 0.00 8,000.00
04-50120265 TIRES, TUBES & BATTERIES 0.00 902.91
04-50130300 UTILITIES 0.00 2,546.68
04-50130302 TELEPHONE 0.00 1,397.86
04-50130303 OFFICE EQUIPMENT LEASE PAYMENT 0.00 1,000.24
04-50130304 POSTAGE 0.00 211.74
04-50130307 CREDIT CARD FEES 0.00 8,358.78
04-50130310 INSURANCE (C.G.L.) 0.00 25,878.37
04-50130312 MAINTENANCE AGREEMENTS 0.00 738.64
04-50130314 DUES & SUBSCRIPTIONS 0.00 1,496.47
04-50130328 APPRAISAL FEES 0.00 15,400.00
04-50130330 LEGAL FEES 0.00 17,395.20
04-50130338 MISCELLANEOUS 0.00 29.00
04-50130342 ENVIRONMENTAL REMEDIATION 0.00 34,448.81
04-50130345 LICENSE & FEES 0.00 80.00
04-50130362 JANITORIAL SUPPLIES 0.00 1,293.13
04-50130366 CONTINGENCY EXPENSE 0.00 1,294.00
04-50130382 INFO TECHNOLOGY PLAN 0.00 12,944.00
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 3
AS OF: SEPTEMBER 30TH, 2019
04 -AIRPORT FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ACCOUNTS (CONTINUED)
--------------------
04-50130383 OH ALLOCATION TO GENERAL FUND 0.00 58,591.36
04-50140419 Z-TURN MOWER 0.00 9,912.92
04-50150504 TRF OUT TO CO 2016 PRIN 0.00 15,000.00
04-50150505 TRF OUT TO CO 2016 INTEREST 0.00 1,251.07
04-50220224 HONDO ART LEAGUE MAINT. 0.00 67.48
04-50220245 WATER/SEWER IMPROVEMENTS 0.00 25,403.85
04-50840700 13 RAMP GRANT 0.00 45,032.66
______________ ______________ ______________ ______________
FUND TOTAL 0.00 0.00 23,972,481.79 23,972,481.79
============== ============== ============== ==============
*** END OF REPORT ***
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
05 -SANITATION
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
05-1100.01 CLAIM ON CASH 0.00 246,816.97
05-1123 SANITATION ACCOUNTS RECEIVABL 0.00 133,923.98
05-1133 SALES TAX RECEIVABLE 0.00 9,111.73
05-1134 ALLOWANCE FOR DOUBTFUL ACCOUNT 0.00 5,724.26
05-1148 DEFERRED PENSION OUT - CONTRIB 0.00 1,539.35
05-1148.10 DEFERRED TMRS OPEB OUTFLOWS 0.00 53.89
05-1150 ACCOUNTS RECEIVABLE PERMITS 0.00 20.00
05-1217 UNAPPLIED CREDIT 0.00 20.00
05-1232 SALES TAX PAYABLE 0.00 7,737.01
05-1257 ACCRUED LIABILITIES 0.00 717.54
05-1258 NET PENSION LIABILITY 0.00 944.84
05-1258.10 TOTAL TMRS OPEB LIABILITY 0.00 729.33
05-1259 DEFERRED PENSION INFLO-EXPERNC 0.00 2,698.89
05-1279 PRIOR PERIOD ADJUSTMENT 0.00 789.42
05-1280 FUND BALANCE 0.00 214,852.75
05-1290 PAYROLL CLEARING 0.00 401.58
05-1302 RESIDENTIAL SANITATION 0.00 430,732.06
05-1304 COMMERCIAL SANITATION 0.00 481,237.49
05-1306 PENALTIES 0.00 12,170.22
05-1310 COLLECTION CENTER PERMITS 0.00 2,012.50
05-1320 MISCELLANEOUS 0.00 283.51
05-51210100 SALARY 0.00 459.74
05-51210125 SOCIAL SECURITY 0.00 35.17
05-51210127 RETIREMENT PLAN 0.00 127.04
05-51210135 WORKERS COMPENSATION 0.00 519.96
05-51230300 UTILITIES 0.00 0.96
05-51230302 TELEPHONE 0.00 0.96
05-51230351 RESIDENTIAL SOLID WASTE COLL 0.00 331,669.56
05-51230352 COMMERCIAL SOLID WASTE COLL 0.00 391,786.45
05-51230354 COLLECTION STATION 0.00 646.08
05-51230355 TIRE,TV AND SIMILAR PICKUPS 0.00 1,800.00
05-51230382 INFORMATION TECHNOLOGY 0.00 729.00
05-51230383 OH ALLOCATION FRM GENERAL FUND 0.00 36,208.64
______________ ______________ ______________ ______________
FUND TOTAL 0.00 0.00 1,158,250.44 1,158,250.44
============== ============== ============== ==============
*** END OF REPORT ***
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
06 -BOND & SINKING FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
06-1100.01 CLAIM ON CASH 0.00 337,533.32
06-1130 DELINQUENT TAXES RECE 0.00 32,878.38
06-1131 ALLOWANCE FOR DOUBTFUL AC 0.00 4,931.76
06-1260 DEFERRED REVENUE 0.00 27,946.62
06-1280 FUND BALANCE 0.00 151,209.92
06-1302 PROPERTY TAX REVENUE 0.00 379,364.84
06-1318 TRF IN FROM EDC 0.00 110,536.90
06-1322 TRF IN FROM ELECTRIC FUND 0.00 54,155.30
06-1323 TRF IN FROM WATER FUND 0.00 242,094.93
06-1324 TRF IN FROM AIRPORT FUND 0.00 16,251.08
06-50050402 2013 DWSRF PRINCIPAL 0.00 50,000.00
06-50050403 2013 DWSRF INTEREST 0.00 1,800.00
06-50050502 2010 SALES TAX BOND PRINCIPAL 0.00 45,000.00
06-50050503 2010 SALES TAX REV. BOND INTE 0.00 16,340.00
06-50050537 2014 REFUNDING PRINCIPAL 0.00 153,000.00
06-50050538 2014 REFUNDING INTEREST 0.00 15,910.50
06-50050539 2016 CO PRINCIPAL 0.00 220,000.00
06-50050540 2016 CO INTEREST 0.00 18,935.65
06-50050542 CO SERIES 2015 INTEREST 0.00 38,143.00
06-50050544 SERIES 2017 INTEREST 0.00 56,950.50
______________ ______________ ______________ ______________
FUND TOTAL 0.00 0.00 986,491.35 986,491.35
============== ============== ============== ==============
*** END OF REPORT ***
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
08 -PAYROLL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
08-1151 DUE FROM GENERAL FUND 0.00 96,646.51
08-1152 DUE FROM ELECTRIC 0.00 12,813.44
08-1153 DUE FROM WATER/SEWER 0.00 12,105.89
08-1154 DUE FROM AIRPORT 0.00 5,152.93
08-1155 DUE FROM SANITATION 0.00 401.58
08-1157 DUE FROM ECONOMIC DEVELOP 0.00 2,487.03
08-1220 WAGES PAYABLE 0.00 129,607.38
______________ ______________ ______________ ______________
FUND TOTAL 0.00 0.00 129,607.38 129,607.38
============== ============== ============== ==============
*** END OF REPORT ***
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
09 -COMMITTED/RESTRICTED FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
09-1100.01 CLAIM ON CASH 0.00 529,635.49
09-1280 FUND BALANCE 0.00 43,902.14
09-1281 SW FAMILY LIFE CT FUND BALANCE 0.00 2,499.61
09-1284 STORM DRAINAGE FUND BALANCE 0.00 55,000.45
09-1285 COURT TECHNOLOGY FUND BALANCE 0.00 8,236.51
09-1286 COURT SECURITY FUND BALANCE 0.00 16,904.28
09-1287 IT IMPROV PLAN FUND BALANCE 0.00 86,565.34
09-1316 CITY CONT FOR SWFLC 0.00 6,700.00
09-1319 COURT SECURITY FEE 0.00 829.00
09-1320 COURT TECHNOLOGY FEES 0.00 1,178.40
09-1341 CITY CONT FOR STREETS 0.00 180,000.00
09-1342 WATER CONT FOR STREETS 0.00 15,000.00
09-1345 CITY CONT FOR CURBS 0.00 80,000.00
09-1348 CITY CONT FOR STORM DRAINAGE 0.00 80,000.00
09-1370 INFORMATION TECHNOLOGY 0.00 211,147.00
09-50030316 SOUTHWEST FAMILY LIFE CENTER 0.00 1,652.77
09-50030319 COURT SECURITY FEE 0.00 199.00
09-50030320 COURT TECHNOLOGY 0.00 3,182.11
09-50030382 INFORMATION TECH ANNUAL MAINT 0.00 165,489.08
______________ ______________ ______________ ______________
FUND TOTAL 0.00 0.00 744,060.59 744,060.59
============== ============== ============== ==============
*** END OF REPORT ***
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
10 -POOLED CASH ACCOUNT
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
______________ ______________ ______________ ______________
============== ============== ============== ==============
*** END OF REPORT ***
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
11 -PERPETUAL CARE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
11-1100.01 CLAIM ON CASH 0.00 79,987.33
11-1111 PERPETUAL CARE MAINTENANCE FUN 0.00 124,369.67
11-1121 CD INVESTMENT 0.00 548,822.08
11-1278 NON-SPENDABLE FUND BALANCE 0.00 545,990.00
11-1280 FUND BALANCE 0.00 12,354.98
11-1305 REVENUE 0.00 13,300.00
11-1373 INTEREST INCOME 0.00 2,832.08
11-50023036 MOWING FEES TO GENERAL FUND 0.00 19,000.00
11-50030301 BANK FEES 0.00 148.00
11-50030311 CEMETERY CLEANUP 0.00 124.64
______________ ______________ ______________ ______________
FUND TOTAL 0.00 0.00 673,464.39 673,464.39
============== ============== ============== ==============
*** END OF REPORT ***
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
12 -FORFEITURE/SEIZURE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
12-1100.01 CLAIM ON CASH 0.00 2,216.96
12-1111 SEIZURE FUND 0.00 6,516.47
12-1112 FORFEITURE FUND 0.00 5,986.28
12-1200 ACCOUNTS PAYABLE 0.00 2,350.00
12-1221 SEIZED FUNDS 0.00 6,701.78
12-1280 FUND BALANCE 0.00 6,383.33
12-1340 FORFEITED FUNDS 0.00 253.80
12-50030321 DA AND DISTRICT CLERK FEES 0.00 169.20
12-50030360 INVESTIGATION EXPENSE 0.00 800.00
______________ ______________ ______________ ______________
FUND TOTAL 0.00 0.00 15,688.91 15,688.91
============== ============== ============== ==============
*** END OF REPORT ***
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
14 -'07 CERT OF OBLIGATION
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
14-1100.01 CLAIM ON CASH 0.00 0.33
14-1280 FUND BALANCE 0.00 0.33
______________ ______________ ______________ ______________
FUND TOTAL 0.00 0.00 0.33 0.33
============== ============== ============== ==============
*** END OF REPORT ***
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
16 -LIBRARY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
______________ ______________ ______________ ______________
============== ============== ============== ==============
*** END OF REPORT ***
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
17 -UNCLAIMED MONEY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
17-1100.01 CLAIM ON CASH 0.00 6,062.70
17-1121 CD INVESTMENTS 0.00 7,696.02
17-1200 DUE TO OTHERS 0.00 12,117.92
17-1280 FUND BALANCE 0.00 1,585.28
17-1373 INTEREST INCOME 0.00 40.52
17-50220202 CUSTOMER DEPOSITS 0.00 15.00
______________ ______________ ______________ ______________
FUND TOTAL 0.00 0.00 13,758.72 13,758.72
============== ============== ============== ==============
*** END OF REPORT ***
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
18 -ECONOMIC DEV FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
18-1100.01 CLAIM ON CASH 0.00 247,544.31
18-1110 ECONOMIC DEVELOPMENT FUND 0.00 520,296.84
18-1121 CD INVESTMENT 0.00 1,792,649.73
18-1146 SALES TAX RECEIVABLE 0.00 188,763.81
18-1200.01 AP PENDING 0.00 1,061.70
18-1201.04 TMRS 0.00 1,287.71
18-1255 ACCRUED PAYROLL 0.00 5,550.36
18-1280 FUND BALANCE 0.00 2,753,588.13
18-1290 PAYROLL CLEARING 0.00 2,487.03
18-1301 SALES TAX REVENUE 0.00 500,065.44
18-1306 EDA ANNEX GRANT 0.00 491,418.96
18-1373 INTEREST INCOME 0.00 9,423.31
18-50010100 SALARY 0.00 52,644.72
18-50010125 SOCIAL SECURITY 0.00 4,371.60
18-50010127 RETIREMENT 0.00 4,494.39
18-50010128 HEALTH & DENTAL INS 0.00 60.10
18-50010135 WORKERS COMP (TML) 0.00 125.46
18-50010149 AUTO ALLOWANCE EDC 0.00 4,050.00
18-50010150 CELL PHONE ALLOWANCE 0.00 450.00
18-50020200 OFFICE SUPPLIES 0.00 225.40
18-50030209 MEETINGS & SEMINARS 0.00 3,047.45
18-50030300 LEGAL SERVICES 0.00 1,060.00
18-50030302 TELEPHONE 0.00 897.51
18-50030304 POSTAGE 0.00 42.74
18-50030314 DUES & SUBSCRIPTIONS 0.00 610.99
18-50030316 EDUCATION PROJECTS 0.00 2,215.87
18-50030317 CHAMBER CONTRACT 0.00 13,333.28
18-50030319 MARKETING & ADVERTISING 0.00 8,193.73
18-50030382 INFORMATION TECH 0.00 30,000.00
18-50040411 STRTC VOC ANNEX EDA SHARE 0.00 497,766.90
18-50040412 STRTC VOCATIONAL ANNEX 0.00 261,700.91
18-50040414 CASTRO AVE REBUILD 90-CARTER 0.00 19,800.00
18-50050502 TRF OUT TO BOND SER 2010 PRIN 0.00 45,000.00
18-50050503 TRF OUT TO BOND SER 2010 INT 0.00 16,340.00
18-50050504 CO SERIES 2016 PRINCIPAL 0.00 45,000.00
18-50050505 CO SERIES 2016 INTEREST 0.00 4,196.90
______________ ______________ ______________ ______________
FUND TOTAL 0.00 0.00 3,764,882.64 3,764,882.64
============== ============== ============== ==============
*** END OF REPORT ***
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
19 -CITY OF HONDO INVESTMENT
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
______________ ______________ ______________ ______________
============== ============== ============== ==============
*** END OF REPORT ***
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
20 -SOUTH TEXAS REGIONAL TRAI
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
20-1100.01 CLAIM ON CASH 0.00 93,048.29
20-1110 STRTC GENERAL OP FND 0.00 46,014.48
20-1150 ACCOUNTS RECEIVABLE 0.00 24,798.55
20-1217 UNAPPLIED CREDIT 0.00 730.00
20-1242 CUSTOMER DEPOSIT 0.00 90.00
20-1280 FUND BALANCE 0.00 127,254.66
20-1301 SWTJC RENT 0.00 21,085.00
20-1302 ALAMO WRKFRCE OFFICE LEASE 0.00 17,934.92
20-1305 MONTHLY UTILITY 0.00 4,404.42
20-1310 ADMIN SVS & SUPPORT 0.00 11,960.00
20-1330 MISCELLANEOUS RENTALS 0.00 105.00
20-50220200 OFFICE SUPPLIES 0.00 724.56
20-50220201 BREAKROOM SUPPLIES 0.00 150.61
20-50220263 FURNITURE 0.00 4,940.66
20-50230300 UTILITIES 0.00 1,648.83
20-50230302 TELEPHONE 0.00 2,160.86
20-50230310 INSURANCE 0.00 3,295.42
20-50230312 MAINTENANCE AGREEMENTS 0.00 1,098.64
20-50230338 MISCELLANEOUS 0.00 203.96
20-50230350 BUILDING MAINTENANCE 0.00 3,787.65
20-50230362 JANITORIAL SUPPLIES 0.00 1,481.49
______________ ______________ ______________ ______________
FUND TOTAL 0.00 0.00 183,459.00 183,459.00
============== ============== ============== ==============
*** END OF REPORT ***
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
21 -HOTEL/MOTEL TAX FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
21-1100.01 CLAIM ON CASH 0.00 144,724.38
21-1132 HOT RECEIVABLE 0.00 31,022.03
21-1280 FUND BALANCE 0.00 142,130.28
21-1315 HOTEL/MOTEL TAX REVENUES 0.00 100,241.13
21-50230301 HONDO CHAMBER OF COMMERCE 0.00 48,500.00
21-50230302 MEDINA COUNTY FAIR ASSN. 0.00 5,000.00
21-50230303 MEDINA COUNTY MUSEUM 0.00 5,625.00
21-50230305 RODEO ASSOCIATION 0.00 5,000.00
21-50230312 STOL ROUNDUP 0.00 2,500.00
______________ ______________ ______________ ______________
FUND TOTAL 0.00 0.00 242,371.41 242,371.41
============== ============== ============== ==============
*** END OF REPORT ***
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
22 -WATER RESOURCE
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
22-1100.01 CLAIM ON CASH 0.00 140,591.00
22-1280 FUND BALANCE 0.00 135,424.00
22-1306 WATER RESOURCES REVENUE 0.00 5,167.00
______________ ______________ ______________ ______________
FUND TOTAL 0.00 0.00 140,591.00 140,591.00
============== ============== ============== ==============
*** END OF REPORT ***
6-02-2019 01:04 PM RAW TRIAL BALANCE PAGE: 1
AS OF: SEPTEMBER 30TH, 2019
99 -POOLED CASH FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
__________________________________________________________________________________________________________________________________
ALL ACCOUNTS
------------
99-1000 POOLED OPERATING ACCOUNT 0.00 5,390,302.55
99-1011 POOLED PAYROLL ACCOUNT 0.00 245,171.99
99-1101 DUE FROM GENERAL FUND 0.00 110,768.19
99-1102 DUE FROM ELECTRIC FUND 0.00 598,823.85
99-1103 DUE FROM WATER/SEWER FUND 0.00 15,007.86
99-1104 DUE FROM AIRPORT FUND 0.00 5,788.40
99-1118 DUE FROM ECONOMIC DEV FUND 0.00 1,061.70
99-1200 ACCOUNTS PAYABLE CONTROL 0.00 731,450.00
99-1210 DUE TO OTHER FUNDS 0.00 5,765,081.92
99-1220 WAGES PAYABLE 0.00 129,607.38
______________ ______________ ______________ ______________
FUND TOTAL 0.00 0.00 6,496,531.92 6,496,531.92
============== ============== ============== ==============
*** END OF REPORT ***