Import 61b6a106-647b-47ca-a88d-965c60257248
Download
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
01 -GENERAL FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
1100.01 CLAIM ON CASH 62,556.21 1,095,735.99
1102 LIBRARY PETTY CASH 0.00 140.00
1103 POOL PETTY CASH 0.00 100.00
1105 REC. CENTER PETTY CASH 0.00 186.50
1108 GOLF COURSE PETTY CASH 0.00 260.00
1109 CODES PETTY CASH 0.00 100.00
1121 CD INVESTMENTS 0.00 877,030.63
1122 MISC A/R 13,973.25 73.60
1127 NSF CHECKS 20.67 13,399.62
1128 SUSPENSE 0.00 39,471.16
1130 OVER/SHORT 0.00 0.11
1132 ACCTS. REC/FRANCHISE FEES 36.52 8,941.65
1133 A/R MIXED BEVERAGE TAX 0.00 504.43
1134 TAX RECEIVABLE/DELINQUENT 0.00 107,450.10
1135 ALLOWANCE FOR UNCOLLECTIB 0.00 16,117.52
1142 CURBING ACCOUNTS RECEIVEB 0.00 374.42
1143 GRANTS RECEIVABLE 0.00 1,412.05
1146 SALES TAX RECEIVABLE 0.00 377,527.62
1147 ALLOWANCE FOR UNCOLLECTIBLES 0.00 8,570.78
1150 ACCOUNTS RECEIVABLE 0.00 53,586.48
1164 PREPAID POSTAGE 516.96 3,000.16
1166 PREPAID RECORDING/FILING FEES 0.00 1,137.50
1167 PREPAID CITY SCOFFLAW 0.00 1,918.00
LIABILITIES AND FUND BALANCE
1200 ACCOUNTS PAYABLE 0.00 20.00
1200.01 AP PENDING 95,104.66 203,583.89
1201.04 TMRS 0.00 24,034.46
1201.05 INSURANCE PAYABLE 13,468.72 138,236.08
1201.09 TOBACCO SURCHARGE 0.00 42.54
1201.12 BENEFITS PAYMENT DIFFERENCE 0.00 51,401.89
1207 INSPECTION BONDS DEPOSIT 532.00 3,229.00
1208 REFUNDS DUE 0.00 726.41
1218 MUNICIPAL COURT STATE FEES 1,974.90 8,131.38
1226 OMNI FEES 54.00 279.90
1227 COLLECTION AGENCY FEE 3,138.62 3,183.73
1228 UNAPPLIED CREDITS 0.00 1,028.04
1232 SALES TAX PAYABLE/GOLF COURSE 66.75 627.06
1242 STREET CUT DEPOSITS 0.00 1,000.00
1243 COMMUNITY CENTER DEPOSITS 100.00 2,710.00
1244 CITY PARK DEPOSITS 50.00 4,645.00
1245 LOPEZ PARK KEY DEPOSIT 0.00 100.00
1246 POLITICAL DEPOSITS 0.00 100.00
1248 BASEBALL FIELD DEPOSITS 0.00 350.00
1250 PARKLAND FEE 0.00 3,142.00
1254 RECREATION CENTER DEPOSIT 567.00 8,911.00
1255 ACCRUED PAYROLL 0.00 167,785.20
1259 YOGA DEPOSIT/LESSONS 0.00 597.00
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 2
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
01 -GENERAL FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
1260 DEFERRED REVENUE 0.00 91,332.59
1280 FUND BALANCE 0.00 1,936,680.52
1290 PAYROLL CLEARING 0.00 96,646.51
SANITATION
REVENUES
1302 CURRENT YEAR LEVY 5,321.13 1,133,965.37
1304 DELINQUENT TAXES 953.08 23,011.72
1306 PENALTIES 1,096.34 15,859.75
1312 SALES TAX REVENUE 85,518.13 1,085,649.00
1313 SCHOOL RESOURCE OFFICER 0.00 36,576.49
1314 FRANCHISE FEES 13.40 27,675.18
1317 POOL PARTY RENT 1,850.00 6,980.00
1319 CREDIT CARD FEES GEN 1,042.61 8,851.01
1323 ZONING/SUBD. 2,938.00 6,038.00
1324 COMMUNITY CENTER RENTAL 1,332.50 16,437.50
1326 LICENSE & PERMITS 6,576.89 125,936.52
1328 ANIMAL FEES & ACCIDENT REP 403.00 6,398.00
1329 INSPECTION FEES 0.00 850.00
1330 ADMIN FEES/CUTOUTS 675.00 9,200.00
1332 MUNICIPAL COURT REVENUE 3,306.15 47,043.74
1333 CROSSING GUARD FUND 0.00 13,973.25
1335 LEAGUE FEES 0.00 15,056.30
1340 BRUSH OVER 8 CY 0.00 588.00
1346 CITY PARK USER FEE 575.00 5,240.00
1351 POOL CONCESSIONS 3,612.00 3,828.75
1353 LIBRARY BUILDING FUND DONATION 3,150.00 28,830.00
1354 SALE OF CEMETERY LOTS 700.00 5,300.00
1359 CITY EASEMENT USE 0.00 17,250.00
1362 P.I.L.O.T. - ELECTRIC 231,250.00 2,081,250.00
1363 RECREATIONAL FEES 7,798.00 37,666.10
1364 POOL REVENUE 7,043.25 11,568.25
1366 P.I.L.O.T. - WATER 20,125.00 181,125.00
1367 P.I.L.O.T. - WASTEWATER 11,540.67 103,866.03
1368 MISCELLANEOUS 284.32 4,562.60
1373 INTEREST INCOME 7,701.85 16,615.54
1374 MIXED BEVERAGE TAX 0.00 1,300.08
1378 TOBACCO/WELLNESS CONTRIBUTION 496.67 6,846.04
1379 GOLF COURSE REVENUE 7,611.44 44,928.78
1379.1 GOLF COURSE TREE DONATIONS 0.00 1.00
1380 LIBRARY REVENUE 1,380.42 12,780.01
1381 LIBRARY USED BOOKSTORE 205.70 2,513.10
1383 OH ALLOCATION FRM OTHER FUNDS 59,953.83 539,584.47
1385 POST OFFICE RENT 5,082.00 22,869.00
1387 K9 FOR COPS GRANT 0.00 42,402.06
1387.1 HUTS FOR MUTTS DONATIONS 0.00 590.00
1389 VENDING MACHINE REVENUE 231.00 1,961.25
1399 TCLEOE GRANT 0.00 1,881.52
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 3
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
01 -GENERAL FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
REVENUES (CONT)
1592 SALE OF FIXED ASSETS/SURPLUS 0.00 18,508.22
1611 NIBRS GRANT 0.00 13,482.15
1620 LIBRARY TECHNOLOGY GRANT 0.00 1,333.85
EXPENSES
50110100 CITY COUNCIL FEES 2,500.00 22,500.00
50120200 OFFICE SUPPLIES 0.00 217.67
50120209 MEETINGS AND SEMINARS 0.00 3,097.92
50130311 MAYOR/PUBLIC RELATIONS 999.40 2,857.73
50130312 COMMUNITY CELEBRATIONS 7,804.17 8,569.39
50130313 YOUTH & ADULT ENGAGEMENT 0.00 8,049.60
50130338 MISCELLANEOUS 0.00 200.00
50210100 SALARY 16,333.89 162,360.83
50210111 OVERTIME 294.00 4,148.79
50210116 LONGEVITY 0.00 684.00
50210125 SOCIAL SECURITY 1,292.75 13,215.06
50210126 UNEMPLOYMENT TAX 0.00 131.73
50210127 RETIREMENT PLAN 1,481.53 16,147.77
50210128 HEALTH & DENTAL INS 100.00 8,321.71
50210130 COBRA COMPLIANCE PREMIUM 0.00 13.98
50210135 WORKERS' COMPENSATION 0.00 719.34
50210149 AUTO ALLOWANCE CITY MANAGER 500.00 5,000.00
50210150 CELL PHONE ALLOWANCE 100.00 1,000.00
50220200 OFFICE SUPPLIES 9.88 6,109.25
50220201 BREAKROOM SUPPLIES 56.92 711.87
50220209 MEETINGS AND SEMINARS 292.90 6,513.55
50220215 SAFETY EQUIPMENT 0.00 7,379.00
50220216 EMPLOYEE RELATIONS 859.86 6,407.45
50220250 WELLNESS PROGRAM 0.00 3,196.91
50230300 UTILITIES 734.52 4,458.02
50230302 TELEPHONE 460.93 5,477.01
50230303 OFFICE EQUIPMENT LEASE PAYMENT 1,124.38 6,354.21
50230304 POSTAGE 0.00 26.15
50230306 PAYING AGENT FEES 11.58 1,811.58
50230309 MUSIC SERVICE 57.25 513.25
50230310 INSURANCE (C.G.L.) 0.00 13,685.28
50230312 MAINTENANCE AGREEMENTS 1,871.85 18,116.45
50230314 DUES & SUBSCRIPTIONS 40.50 4,382.07
50230316 LEGAL NOTICES 323.00 923.00
50230328 APPRAISAL FEES 0.00 3,850.00
50230330 CITY ATTORNEY 0.00 30,947.08
50230338 MISCELLANEOUS 0.00 506.35
50230341 CITY MANAGER/PROFESSIONAL FEES 0.00 960.00
50230362 JANITORIAL SUPPLIES 125.83 2,145.78
50230366 CONTINGENCY EXPENSE 2,109.57 6,022.02
50230382 INFO TECHNOLOGY PLAN 0.00 12,157.00
50230384 INSURANCE CONSULTANTS 0.00 13,052.80
50330323 APPRAISAL DISTRICT FEES 7,480.28 22,440.86
50330350 TAX COLLECTION FEES 5,041.40 5,541.40
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 4
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
01 -GENERAL FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
EXPENSES (CONT)
50410100 SALARY 10,913.30 111,816.34
50410111 OVERTIME 121.34 1,695.39
50410116 LONGEVITY 0.00 288.00
50410125 SOCIAL SECURITY 733.89 7,725.12
50410126 UNEMPLOYMENT TAX 0.00 202.96
50410127 RETIREMENT PLAN 947.73 10,325.97
50410128 HEALTH & DENTAL INS 0.00 10,797.40
50410130 COBRA COMPLIANCE PREMIUM 0.00 20.79
50410135 WORKERS' COMPENSATION 0.00 501.81
50410150 CELL PHONE ALLOWANCE 50.00 500.00
50420200 OFFICE SUPPLIES 351.29 5,160.03
50420209 MEETINGS AND SEMINARS 0.00 1,574.45
50420221 APPLICANT PROCESSING 0.00 21.00
50430301 BANK ANALYSIS FEES 779.99 8,235.56
50430302 TELEPHONE 4.86 42.99
50430303 JOB ANNOUNCEMENTS 0.00 1,437.40
50430304 POSTAGE 110.30 1,149.66
50430314 DUES & SUBSCRIPTIONS 0.00 1,007.00
50430326 AUDIT FEES 0.00 39,330.00
50430338 MISCELLANEOUS 0.00 2,311.23
50430361 RANDOM DRUG TESTING 0.00 62.60
50430370 CONTRACT LABOR 0.00 14,317.10
50430382 INFO TECHNOLOGY PLAN 0.00 1,528.00
50510100 SALARY 89,082.13 878,093.04
50510111 OVERTIME/CALL OUT 4,194.27 50,950.89
50510116 LONGEVITY 0.00 6,516.00
50510117 CERTIFICATE PAY 475.00 5,025.00
50510121 CROSSING GUARDS 425.25 18,278.25
50510125 SOCIAL SECURITY 6,782.92 69,690.74
50510126 UNEMPLOYMENT TAX 0.00 727.10
50510127 RETIREMENT PLAN 8,015.74 86,631.20
50510128 HEALTH & DENTAL INS 0.00 69,207.97
50510130 COBRA COMPLIANCE PREMIUM 0.00 137.07
50510135 WORKERS' COMPENSATION 0.00 25,508.12
50520200 OFFICE SUPPLIES 1,146.21 7,796.55
50520201 BREAKROOM SUPPLIES 0.00 655.70
50520202 FUEL & OIL 2,985.70 25,065.51
50520209 MEETINGS AND SEMINARS 0.00 8,905.28
50520210 EQUIPMENT MAINTENANCE 0.00 2,148.96
50520212 VEHICLE MAINTENANCE 569.95 11,847.79
50520215 SAFETY EQUIPMENT 0.00 3,361.66
50520217 RADIOS 0.00 579.00
50520227 BALLISTIC VESTS 755.51 2,833.51
50520228 K-9 EXPENSE 29.00 7,826.87
50520229 UNIFORMS 92.00 4,812.85
50520230 UNIFORM ALLOWANCE 187.88 1,408.95
50520232 OFFICE FURNITURE 5,060.00 10,305.61
50520240 PUBLIC EVENT SUPPLIES 0.00 1,325.10
50520241 CRIME PROCESSING 0.00 41.94
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 5
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
01 -GENERAL FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
EXPENSES (CONT)
50520265 TIRES, TUBES & BATTERIES 0.00 489.68
50530300 UTILITIES 509.52 1,675.75
50530302 TELEPHONE 424.33 18,868.01
50530303 OFFICE EQUIPMENT LEASE PAYMENT 189.57 1,706.13
50530304 POSTAGE 109.74 1,152.18
50530310 INSURANCE (C.G.L.) 0.00 14,879.54
50530314 DUES & SUBSCRIPTIONS 75.50 1,090.00
50530317 TCLEOSE TRAINING 365.00 979.00
50530320 COMMUNITY OUTREACH 279.92 799.07
50530338 MISCELLANEOUS 633.27 2,110.62
50530344 MEDICAL SERVICE 1,000.00 1,200.00
50530360 INVESTIGATION EXPENSE 0.00 3,945.77
50530362 JANITORIAL SUPPLIES 22.96 809.24
50530382 INFO TECHNOLOGY PLAN 11.48 11,616.48
50540407 EQUIPMENT UPGRADES 0.00 2,063.00
50540408 PURCHASED VEHICLES 0.00 87,887.30
50540412 PURCHASE NEW BUILDING 0.00 296,763.45
50610100 SALARY 2,821.85 27,843.20
50610111 OVERTIME 52.93 593.43
50610115 COURT BAILIFF 0.00 41.33
50610116 LONGEVITY 0.00 144.00
50610125 SOCIAL SECURITY 217.37 2,181.20
50610126 UNEMPLOYMENT TAX 0.00 8.63
50610127 RETIREMENT PLAN 245.79 2,647.30
50610128 HEALTH & DENTAL INS 0.00 3,617.33
50610130 COBRA COMPLIANCE PREMIUM 0.00 6.96
50610135 WORKERS' COMPENSATION 0.00 125.46
50620200 OFFICE SUPPLIES 200.00 891.25
50620209 MEETINGS AND SEMINARS 0.00 735.66
50630302 TELEPHONE 7.97 112.80
50630304 POSTAGE 33.50 329.37
50630307 CREDIT CARD FEES 0.00 1,954.75
50630314 DUES & SUBSCRIPTIONS 0.00 272.69
50630332 MUNICIPAL COURT JUDGE 2,500.00 22,500.00
50630336 PROSECUTOR 0.00 14,480.26
50630338 MISCELLANEOUS 0.00 30.00
50630382 INFO TECHNOLOGY PLAN 0.00 10,212.00
50730300 UTILITIES 0.95 5.08
50730353 EMERGENCY OPERATION CONTINGENC 0.00 19,006.89
50730354 EMERGENCY NOTIFICATION SYSTEM 532.69 15,808.69
50740405 WATER TOWER RADIO BLDG 0.00 10,959.00
50810100 SALARY 5,073.10 44,948.10
50810111 CALL DUTY/OVERTIME 283.61 3,289.92
50810116 LONGEVITY 0.00 216.00
50810125 SOCIAL SECURITY 373.10 3,595.26
50810126 UNEMPLOYMENT TAX 0.00 14.16
50810127 RETIREMENT PLAN 458.00 4,486.44
50810128 HEALTH & DENTAL INS 0.00 6,232.24
50810130 COBRA COMPLIANCE PREMIUM 0.00 11.55
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 6
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
01 -GENERAL FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
EXPENSES (CONT)
50810135 WORKERS' COMPENSATION 0.00 1,882.62
50820200 OFFICE SUPPLIES 0.00 70.26
50820202 FUEL & OIL 150.80 1,975.45
50820204 ANIMAL SHELTER SUPPLIES 53.74 522.87
50820207 TAGS & HARDWARE 0.00 62.42
50820209 MEETINGS AND SEMINARS 0.00 502.01
50820210 EQUIPMENT MAINTENANCE 0.00 152.59
50820212 VEHICLE MAINTENANCE 0.00 1,119.18
50820214 STRUCTURE MAINTENANCE 0.00 615.54
50820215 SAFETY EQUIPMENT 0.00 48.49
50820229 UNIFORMS 7.23 664.44
50820265 TIRES, TUBES & BATTERIES 0.00 626.68
50830300 UTILITIES 222.93 688.67
50830302 TELEPHONE 86.19 584.40
50830308 VETERINARY FEES 0.00 570.44
50830310 INSURANCE (C.G.L.) 0.00 2,487.39
50830327 RENT-AFP 216.67 1,950.03
50830341 SPAY/NEUTER ANNUAL PROGRAM 0.00 2,500.00
50830362 JANITORIAL SUPPLIES 32.43 383.47
50830382 INFO TECHNOLOGY PLAN 0.00 2,188.00
50910100 SALARY 20,098.17 172,132.05
50910111 OVERTIME/CALL OUT 184.67 2,482.62
50910116 LONGEVITY 0.00 1,728.00
50910125 SOCIAL SECURITY 1,537.42 13,351.68
50910126 UNEMPLOYMENT TAX 0.00 228.63
50910127 RETIREMENT PLAN 1,738.46 16,239.64
50910128 HEALTH & DENTAL INS 0.00 24,908.20
50910130 COBRA COMPLIANCE PREMIUM 0.00 47.18
50910135 WORKERS' COMPENSATION 0.00 17,720.97
50910150 CELL PHONE ALLOWANCE 50.00 500.00
50920200 OFFICE SUPPLIES 0.00 218.46
50920201 BREAKROOM SUPPLIES 0.00 178.68
50920202 FUEL & OIL 1,692.56 12,597.04
50920203 SMALL TOOLS 0.00 78.47
50920207 STREET SIGNS 0.00 228.21
50920208 STREET SUPPLIES 3.99 1,128.48
50920209 MEETINGS AND SEMINARS 0.00 1,342.81
50920210 SMALL EQUIPMENT MAINTENANCE 0.00 626.90
50920212 VEHICLE MAINTENANCE 946.34 4,213.49
50920215 SAFETY EQUIPMENT 79.00 3,724.07
50920216 STREET REPAIRS 5,226.39 22,056.53
50920218 HEAVY EQUIPMENT MAINTENANCE 237.79 6,218.56
50920229 UNIFORMS 57.55 1,670.42
50920241 CHEMICALS 335.00 335.00
50920265 TIRES, TUBES & BATTERIES 1,455.00 1,920.01
50920266 POWER TOOLS 0.00 149.99
50930300 UTILITIES 38.63 175.91
50930302 TELEPHONE 70.48 462.27
50930305 BUILDING SECURITY 0.00 179.13
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 7
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
01 -GENERAL FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
EXPENSES (CONT)
50930310 INSURANCE (C.G.L.) 0.00 9,754.49
50930327 RENT-AFP 216.67 1,950.03
50930338 MISCELLANEOUS 0.00 111.83
50930362 JANITORIAL SUPPLIES 10.68 161.59
50930382 INFO TECHNOLOGY PLAN 0.00 6,485.00
50940401 STREET REHABILITATION 0.00 180,000.00
50940405 STORM DRAINAGE IMPROVEMENTS 0.00 80,000.00
50940409 CURB AND GUTTER REPAIR 0.00 80,000.00
51010100 SALARY 15,266.62 150,556.37
51010111 OVERTIME 302.08 3,993.34
51010116 LONGEVITY 0.00 252.00
51010125 SOCIAL SECURITY 1,194.74 11,868.61
51010126 UNEMPLOYMENT TAX 0.00 301.93
51010127 RETIREMENT PLAN 1,339.66 14,367.12
51010128 HEALTH & DENTAL INS 0.00 7,213.65
51010130 COBRA COMPLIANCE PREMIUM 0.00 22.65
51010135 WORKERS' COMPENSATION 0.00 460.98
51010150 CELL PHONE ALLOWANCE 100.00 950.00
51020200 OFFICE SUPPLIES 127.04 5,910.38
51020201 BREAKROOM SUPPLIES 15.94 658.72
51020202 AUDIO BOOK EXPENSES 467.99 2,083.13
51020204 STORY HOUR 2.00 1,443.96
51020205 BOOKS 546.93 13,498.31
51020207 MAGAZINES 0.00 459.08
51020208 SUMMER READING PROGRAM 20.00 1,171.62
51020209 MEETINGS AND SEMINARS 588.12 1,231.21
51020210 EQUIPMENT MAINTENANCE 0.00 1,522.48
51020213 MILEAGE REIMBURSEMENT 0.00 41.97
51020220 COLLECTION DEVELOPMENT SUPP 0.00 2,200.08
51020221 AUDIO VISUAL MATERIAL 19.96 841.69
51020222 YOUTH OUTREACH 0.00 1,673.38
51020224 SENIOR OUTREACH 0.00 681.00
51020226 SPECIAL EVENTS 18.60 4,237.85
51020229 UNIFORMS 0.00 55.02
51020232 FURNITURE 0.00 1,726.15
51030300 UTILITIES 73.37 73.37
51030302 TELEPHONE/BANDWITH 261.29 5,514.57
51030303 OFFICE EQUIPMENT LEASE PAYMENT 206.20 1,653.01
51030304 POSTAGE 84.01 716.54
51030307 CREDIT CARD FEES 0.00 967.50
51030310 INSURANCE (C.G.L.) 0.00 1,493.49
51030312 MAINTENANCE AGREEMENT 351.00 666.00
51030314 DUES & SUBSCRIPTIONS 40.50 3,205.55
51030319 MARKETING & ADVERTISING 0.00 1,328.40
51030338 MISCELLANEOUS 6.74 113.77
51030362 JANITORIAL SERVICES 226.94 1,522.30
51030382 INFO TECHNOLOGY PLAN 0.00 6,312.00
51110100 SALARY 29,212.94 280,479.71
51110111 OVERTIME 702.95 6,877.99
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 8
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
01 -GENERAL FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
EXPENSES (CONT)
51110116 LONGEVITY 0.00 3,528.00
51110117 CERTIFICATE PAY 50.00 500.00
51110125 SOCIAL SECURITY 2,194.79 21,214.67
51110126 UNEMPLOYMENT TAX 0.00 146.92
51110127 RETIREMENT PLAN 2,570.63 26,941.58
51110128 HEALTH & DENTAL INS 0.00 39,031.66
51110130 COBRA COMPLIANCE PREMIUM 0.00 81.12
51110135 WORKERS' COMPENSATION 0.00 4,218.07
51110150 CELL PHONE ALLOWANCE 100.00 1,000.00
51120200 OFFICE SUPPLIES 24.84 233.33
51120201 BREAKROOM SUPPLIES 49.22 134.00
51120202 FUEL & OIL 1,769.09 13,575.32
51120208 SMALL TOOLS & SUPPLIES 402.49 7,354.84
51120209 MEETINGS AND SEMINARS 0.00 264.90
51120210 SMALL EQUIPMENT MAINTENANCE 171.65 6,074.61
51120212 VEHICLE MAINTENANCE 92.21 4,223.86
51120215 SAFETY EQUIPMENT 306.88 4,477.94
51120218 HEAVY EQUIPMENT MAINTENANCE 3,304.33 5,106.84
51120222 WORK SQUAD EXPENSES 229.22 935.77
51120229 UNIFORMS 284.06 2,577.11
51120241 CHEMICALS 192.20 4,904.07
51120265 TIRES, TUBES & BATTERIES 599.10 1,482.52
51120266 POWER TOOLS 0.00 2,477.86
51130300 UTILITIES 3,467.75 15,187.49
51130302 TELEPHONE 100.88 659.42
51130310 INSURANCE (C.G.L.) 0.00 10,251.44
51130314 DUES & SUBSCRIPTIONS 0.00 59.66
51130327 RENT-AFP 216.67 1,950.03
51130336 EQUIPMENT RENTAL 241.15 241.15
51130338 MISCELLANEOUS 0.00 214.42
51130339 CITY PARK MAINTENANCE 0.00 4,476.96
51130342 LITTLE LEAGUE 0.00 5,603.53
51130343 SOCCER FIELDS 0.00 675.00
51130355 SOLID WASTE SERVICE 0.00 252.00
51130360 LAND LEASE/UNION PACIFIC 28,592.41 28,592.41
51130362 JANITORIAL SUPPLIES 896.45 4,056.68
51130366 CONTINGENCY EXPENSE 0.00 5,950.00
51130367 GROUNDS MAINTENANCE 23.50 7,271.17
51130382 INFO TECHNOLOGY PLAN 5.88 4,341.88
51140416 US 90 IRRIGATION 0.00 505.00
51140421 VEHICLE PURCHASE 0.00 26,106.50
51310100 SALARY 11,020.18 125,086.85
51310111 OVERTIME 247.67 1,464.15
51310116 LONGEVITY 0.00 684.00
51310125 SOCIAL SECURITY 816.48 9,119.88
51310126 UNEMPLOYMENT TAX 0.00 245.27
51310127 RETIREMENT PLAN 967.66 11,801.18
51310128 HEALTH & DENTAL INS 0.00 20,859.41
51310130 COBRA COMPLIANCE PREMIUM 0.00 39.60
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 9
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
01 -GENERAL FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
EXPENSES (CONT)
51310135 WORKERS' COMPENSATION 0.00 5,805.21
51310150 CELL PHONE ALLOWANCE 50.00 500.00
51320200 OFFICE SUPPLIES 27.28 286.29
51320201 BREAKROOM SUPPLIES 0.00 67.82
51320202 FUEL & OIL 220.88 2,771.93
51320208 SMALL TOOLS & SUPPLIES 59.99 4,304.62
51320209 MEETINGS AND SEMINARS 0.00 79.60
51320210 EQUIPMENT MAINTENANCE 0.00 284.16
51320212 VEHICLE MAINTENANCE 406.62 2,017.10
51320215 SAFETY EQUIPMENT 0.00 2,117.79
51320221 WELDING SUPPLIES 0.00 1,056.56
51320229 UNIFORMS 82.04 1,188.96
51320265 TIRES, TUBES & BATTERIES 0.00 366.00
51320266 POWER TOOLS 0.00 5,796.30
51330300 UTILITIES 94.98 521.92
51330302 TELEPHONE 82.30 567.20
51330305 BUILDING SECURITY 71.27 751.79
51330310 INSURANCE (C.G.L.) 0.00 5,101.34
51330311 ANIMAL CONTROL MAINT. 0.00 241.59
51330312 MAINTENANCE AGREEMENT 575.00 8,091.88
51330313 COMMUNITY CENTER MAINT. 33.48 15,611.61
51330315 DEMONTEL BUILDING MAINT. 0.00 221.87
51330316 BUILDING MAINTENANCE 247.82 9,732.55
51330317 CITY HALL MAINT. 0.00 2,723.07
51330318 LIBRARY BUILDING MAINT. 114.99 1,105.48
51330319 POST OFFICE MAINT. 0.00 423.08
51330320 POLICE DEPART. MAINT. 248.93 1,653.89
51330322 WATER DEPT. MAINT 0.00 141.58
51330323 WASTEWATER DEPT. MAINT. 0.00 194.13
51330325 GOLF COURSE BUILDING MAINT. 0.00 167.51
51330326 RECREATION CENTER MAINT. 89.37 4,787.27
51330327 RENT-AFP 216.67 1,950.03
51330328 PUBLIC WORKS BLDG MAINT. 140.94 1,512.80
51330338 MISCELLANEOUS 0.00 94.81
51330349 STRTC MAINT. 592.96 1,989.62
51330350 SOUTHWEST FAMILY LIFE CTR 277.63 6,700.00
51330362 JANITORIAL SUPPLIES 115.35 533.73
51330382 INFO TECHNOLOGY PLAN 0.00 4,336.00
51510100 SALARY 31,691.24 155,881.22
51510111 OVERTIME 773.16 4,692.29
51510116 LONGEVITY 0.00 576.00
51510117 CERTIFICATE PAY 125.00 1,500.00
51510125 SOCIAL SECURITY 2,491.90 12,438.91
51510126 UNEMPLOYMENT TAX 0.00 875.21
51510127 RETIREMENT PLAN 1,161.61 12,692.93
51510128 HEALTH & DENTAL INS 0.00 10,789.46
51510130 COBRA COMPLIANCE PREMIUM 0.00 20.79
51510135 WORKERS' COMPENSATION 0.00 7,744.11
51510150 CELL PHONE ALLOWANCE 100.00 1,000.00
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 10
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
01 -GENERAL FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
EXPENSES (CONT)
51520200 OFFICE SUPPLIES 120.59 1,510.14
51520202 FUEL & OIL 49.82 372.46
51520203 BREAKROOM SUPPLIES 100.42 356.44
51520209 MEETINGS AND SEMINARS 0.00 7,872.03
51520210 EQUIPMENT MAINTENANCE 0.00 1,824.37
51520212 VEHICLE MAINTENANCE 0.00 749.61
51520214 STRUCTURE MAINTENANCE 0.00 4,489.42
51520215 SAFETY EQUIPMENT 62.03 1,203.05
51520220 LANDSCAPING 0.00 268.02
51520221 POOL MAINTENANCE 810.00 8,216.72
51520223 CONCESSION SUPPLIES 1,042.57 3,302.27
51520226 ADULT LEAGUES 118.22 1,132.60
51520227 SPECIAL EVENTS 395.00 2,820.42
51520228 SPECIAL YOUTH LEAGUES 0.00 7,415.35
51520229 UNIFORMS 0.00 994.51
51520237 SUMMER CAMP PROGRAMS 0.00 277.92
51520238 RECREATION SUPPLIES 178.18 3,326.14
51520239 POOL SUPPLIES 50.00 1,430.08
51520241 CHEMICALS 839.50 7,555.50
51530300 UTILITIES 2,775.20 8,761.42
51530302 TELEPHONE 391.98 2,701.63
51530303 OFFICE EQUIPMENT LEASE PAYMENT 101.55 913.95
51530304 OFFICIAL FEES 0.00 9,516.20
51530305 BUILDING SECURITY 67.56 598.60
51530306 POSTAGE 0.00 2.93
51530307 REC CENTER IMPROVEMENTS 425.00 8,688.73
51530309 FITNESS EQUIPMENT 155.00 6,459.54
51530310 INSURANCE (C.G.L.) 0.00 746.09
51530314 DUES & SUBSCRIPTIONS 0.00 2,292.62
51530315 LIFEGUARD CERTIFICATION 27.90 569.10
51530319 MARKETING & ADVERTISING 0.00 8,136.00
51530327 RENT-REC. CENTER LAND 175.00 1,575.00
51530338 MISCELLANEOUS 0.00 328.34
51530345 LICENSE & FEES 47.00 421.00
51530362 JANITORIAL SUPPLIES 573.49 4,924.02
51530370 CONTRACT LABOR 265.00 2,100.00
51530382 INFO TECHNOLOGY PLAN 0.00 4,055.00
51610100 SALARY 8,994.51 83,190.93
51610111 OVERTIME 12.39 613.70
51610116 LONGEVITY 0.00 180.00
51610125 SOCIAL SECURITY 656.36 6,335.11
51610126 UNEMPLOYMENT TAX 0.00 163.23
51610127 RETIREMENT PLAN 774.36 7,274.05
51610128 HEALTH & DENTAL INS 0.00 6,310.82
51610130 COBRA COMPLIANCE PREMIUM 0.00 11.93
51610135 WORKERS COMPENSATION 0.00 2,043.42
51610150 CELL PHONE ALLOWANCE 50.00 500.00
51620200 OFFICE SUPPLIES 0.00 165.78
51620202 FUEL & OIL 474.96 3,541.98
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 11
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
01 -GENERAL FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
EXPENSES (CONT)
51620208 SMALL TOOLS & SUPPLIES 0.00 1,332.98
51620209 MEETINGS AND SEMINARS 0.00 30.00
51620210 EQUIPMENT MAINTENANCE 310.24 5,202.00
51620214 MERCHANDISE 0.00 7,025.54
51620227 SPRINKLER 0.00 984.21
51620229 UNIFORMS 0.00 509.90
51620231 CONCESSIONS 2,080.30 12,171.64
51620241 CHEMICALS 0.00 3,043.30
51620265 TIRES, TUBES & BATTERIES 0.00 1,051.43
51620266 POWER TOOLS 0.00 215.78
51630300 UTILITIES 505.75 2,532.85
51630302 TELEPHONE AND DSL LINE 445.00 2,724.16
51630303 GOLF CARTS LEASE 1,900.00 19,355.51
51630304 POSTAGE 0.00 1.41
51630305 BUILDING SECURITY 0.00 174.65
51630307 CREDIT CARD FEES 0.00 667.50
51630310 INSURANCE (C.G.L.) 0.00 1,083.54
51630314 DUES & SUBSCRIPTIONS 129.50 1,207.00
51630327 RENT 1,166.67 10,500.03
51630338 MISCELLANEOUS 0.00 226.51
51630345 LICENSE & FEES 0.00 607.50
51630362 JANITORIAL SUPPLIES 0.00 1,433.28
51630367 GROUNDS MAINTENANCE 0.00 10,711.03
51630382 INFO TECHNOLOGY PLAN 0.00 4,336.00
51640408 MULTIPURPOSE MOWER 1,014.92 9,134.28
51640409 CART PATH 0.00 7,862.00
51640422 GREENS EQUIPMENT 0.00 14,769.75
51710100 SALARY 13,245.24 132,115.64
51710111 OVERTIME 0.00 1,927.56
51710116 LONGEVITY 0.00 540.00
51710125 SOCIAL SECURITY 1,034.65 10,519.37
51710126 UNEMPLOYMENT TAX 0.00 38.23
51710127 RETIREMENT PLAN 1,170.95 12,803.02
51710128 HEALTH & DENTAL INS 0.00 14,051.79
51710130 COBRA COMPLIANCE PREMIUM 0.00 25.73
51710135 WORKERS COMPENSATION 0.00 471.90
51710149 AUTO ALLOWANCE 400.00 4,000.00
51710150 CELL PHONE ALLOWANCE 50.00 500.00
51720200 OFFICE SUPPLIES 0.00 1,482.61
51720201 BREAKROOM SUPPLIES 0.00 172.45
51720202 FUEL & OIL 54.76 738.79
51720208 SMALL TOOLS & SUPPLIES 0.00 9.97
51720209 MEETINGS AND SEMINARS 0.00 1,631.69
51720212 VEHICLE MAINTENANCE 0.00 967.67
51720215 SAFETY EQUIPMENT 0.00 233.35
51720229 UNIFORMS 52.75 671.16
51720265 TIRES, TUBES & BATTERIES 0.00 30.00
51730300 UTILITIES 27.19 101.95
51730302 TELEPHONE 322.60 2,545.61
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 12
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
01 -GENERAL FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
EXPENSES (CONT)
51730303 OFFICE EQUIPMENT LEASE PAYMENT 122.86 1,105.73
51730304 POSTAGE 76.30 1,394.21
51730305 BUILDING SECURITY 192.11 576.33
51730306 CONTRACT INSPECTIONS 0.00 32,511.94
51730307 CREDIT CARD FEES 0.00 1,716.00
51730310 INSURANCE (C.G.L.) 0.00 373.04
51730314 DUES & SUBSCRIPTIONS 356.00 567.94
51730322 ENGINEERING FEES 0.00 8,295.00
51730327 RENT 600.00 5,400.00
51730330 LEGAL FEES 0.00 24,477.00
51730338 MISCELLANEOUS 0.00 60.00
51730362 JANITORIAL SUPPLIES 32.20 517.82
51730382 INFO TECHNOLOGY PLAN 0.00 7,233.00
51810100 SALARY 10,682.29 104,685.17
51810111 OVERTIME 47.66 875.28
51810116 LONGEVITY 0.00 720.00
51810125 SOCIAL SECURITY 801.95 7,960.63
51810126 UNEMPLOYMENT TAX 0.00 67.30
51810127 RETIREMENT PLAN 917.41 9,937.27
51810128 HEALTH & DENTAL INS 0.00 14,006.80
51810130 COBRA COMPLIANCE PREMIUM 0.00 22.77
51810135 WORKER'S COMPENSATION 0.00 501.81
51820200 OFFICE SUPPLIES 0.00 7,020.02
51820209 MEETINGS AND SEMINARS 0.00 2,482.82
51820229 UNIFORMS 0.00 70.55
51830302 TELEPHONE 4.86 42.99
51830303 OFFICE EQUIPMENT LEASE PAYMENT 148.57 1,337.14
51830304 POSTAGE 1,409.78 14,171.76
51830307 CREDIT CARD FEES 0.00 1,286.21
51830310 INSURANCE (C.G.L.) 0.00 995.22
51830320 COLLECTION AGENCY FEES 1,073.68 3,936.26
51830345 LICENSE & FEES 0.00 340.99
51830382 INFO TECHNOLOGY PLAN 0.00 1,681.00
51910100 SALARY 6,858.76 67,858.45
51910111 OVERTIME 0.00 369.52
51910116 LONGEVITY 0.00 108.00
51910125 SOCIAL SECURITY 527.66 5,230.13
51910126 UNEMPLOYMENT TAX 0.00 9.00
51910127 RETIREMENT 590.70 6,391.34
51910128 HEALTH & DENTAL INS 0.00 7,118.14
51910130 COBRA COMPLIANCE PREMIUM 0.00 13.86
51910135 WORKERS COMPENSATION 0.00 250.92
51910150 CELL PHONE ALLOWANCE 50.00 500.00
51920200 OFFICE SUPPLIES 0.00 3,624.40
51920205 BOARD AND COMMISSION SUPPLIES 53.35 126.85
51920207 PRINTING AND STATIONARY 0.00 51.14
51920209 MEETINGS AND SEMINARS 330.00 2,189.68
51920213 MILEAGE REIMBURSEMENT 49.30 1,326.54
51930302 TELEPHONE 4.86 42.99
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 13
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
01 -GENERAL FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
EXPENSES (CONT)
51930304 POSTAGE 14.00 4,023.24
51930314 DUES & SUBSCRIPTIONS 0.00 911.75
51930316 LEGAL NOTICES 0.00 1,420.70
51930329 LEGAL FEES/CODIFI ORD 0.00 9,173.80
51930332 ELECTION EXPENSE 0.00 11,264.98
51930334 PLANNING & ZONING 0.00 138.20
51930338 MISCELLANEOUS 7.88 265.67
51930362 JANITORIAL SUPPLIES 16.91 16.91
51930382 INFO TECHNOLOGY PLAN 0.00 1,373.00
52030302 NON-PROFIT GROUPS 2,345.00 9,380.00
52110100 SALARY 6,153.92 79,849.71
52110116 LONGEVITY 0.00 72.00
52110125 SOCIAL SECURITY 509.02 6,609.25
52110126 UNEMPLOYMENT TAX 0.00 280.49
52110127 RETIREMENT PLAN 568.92 8,046.60
52110128 HEALTH & DENTAL INS 0.00 1,418.34
52110130 COBRA COMPLIANCE PREMIUM 0.00 0.66
52110135 WORKERS COMPENSATION 0.00 250.92
52110149 AUTO ALLOWANCE 450.00 5,850.00
52110150 CELL PHONE ALLOWANCE 50.00 675.00
52120200 OFFICE SUPPLIES 0.00 375.86
52120209 MEETINGS AND SEMINARS 0.00 743.98
52130300 UTILITIES 60.46 169.36
52130302 TELEPHONE 28.69 243.78
52130304 POSTAGE 0.00 27.47
52130322 ENGINEERING FEES 0.00 1,330.00
52130338 MISCELLANEOUS 0.00 249.02
*** TOTALS *** 568,951.43 568,951.43CR 8,371,807.99 8,371,807.99CR
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
02 -ELECTRIC FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
1100.01 CLAIM ON CASH 44,272.47 383,445.89
1102 CASH DRAWERS 0.00 220.00
1110 ELECTRIC CUSTOMER DEPOSITS 0.00 2,780.38
1132 ELECTRIC ACCTS RECEIVABLE 91,198.24 921,602.38
1133 SALES TAX RECEIVABLE 5,554.06 30,191.94
1134 ALLOW FOR DOUBTFUL ACCTS 803.54 33,138.91
1135 REFUNDS DUE 600.00 3,830.70
1137 MISC ELECTRIC A/R 0.00 17,924.16
1138 U/S UNAPPLIED CREDIT 27,447.39 36,111.71
1139 AMP RECEIVABLE 1,864.66 17,163.59
1140 UNBILLED RECEIVABLE 0.00 460,777.10
1148 DEFERRED PENSION OUT - CONTRIB 0.00 67,496.23
1148.10 DEFERRED TMRS OPEB OUTFLOWS 0.00 2,058.03
1162 INVENTORY 2,547.51 233,996.11
1164 TRANSFORMER INVENTORY 0.00 4,360.00
1172 LAND & RIGHT-OF-WAYS 0.00 137,103.61
1174 SUBSTATION & SYSTEM IMP 0.00 2,224,847.47
1176 POLES, TOWERS & FIXTURES 0.00 439,380.98
1178 METERS & INSTALLATION 0.00 325,900.25
1180 BUILDINGS 0.00 109,052.00
1182 AUTOS, TRUCKS & TRACTORS 0.00 762,328.34
1186 MOBILE RADIOS 0.00 22,154.15
1188 OFFICE EQUIPMENT 0.00 42,477.96
1194 HOSPITAL & HELIPORT LGH 0.00 1,503.00
1197 CONSTRUCTION IN PROGRESS 0.00 95,826.00
1198 ACCUMULATED DEPRECIATION 0.00 2,873,142.38
LIABILITIES AND FUND BALANCE
1200.01 AP PENDING 34,867.83 67,200.78
1201.04 TMRS 0.00 2,947.18
1201.05 INSURANCE PAYABLE 3,200.72 3,883.90
1208 ACCRUED INT PAYABLE 0.00 1,385.10
1217 UNAPPLIED CREDIT 0.00 395.25
1223 2016 BONDS - LONG-TERM PORTION 0.00 465,000.00
1224 2016 BONDS - CURRENT PORTION 0.00 50,000.00
1231 DEFERRED AMP REVENUE 1,864.66 17,236.00
1232 SALES TAX PAYABLE 5,664.68 29,841.87
1242 CUSTOMER DEPOSITS 900.00 299,748.26
1255 ACCRUED PAYROLL 0.00 21,800.85
1256 ACCRUED VACATION PAY 0.00 12,085.87
1257 OPEB LIABILITY 0.00 32,907.35
1258 NET PENSION LIABILITY 0.00 49,869.78
1258.10 TOTAL TMRS OPEB LIABILITY 0.00 27,853.63
1259 DEFERRED PENSION INFLO-EXPERNC 0.00 103,534.20
1279 PRIOR PERIOD ADJUSTMENT 0.00 30,148.22
1280 FUND BALANCE 0.00 1,107,257.12
1281 CONT. IN AID OF CONST 0.00 66,531.00
1288 NET INVESTMENT IN CAP ASSETS 0.00 772,431.00
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 2
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
02 -ELECTRIC FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
1290 PAYROLL CLEARING 0.00 12,813.44
SANITATION
REVENUES
1302 RESIDENTIAL ELECTRIC 362,044.20 2,669,070.39
1304 COMMERCIAL ELECTRIC 337,686.54 2,955,298.09
1306 INDUSTRIAL ELECTRIC 73,267.01 509,897.55
1308 SECURITY LIGHTS 1,542.55 13,027.41
1310 PENALTIES 9,022.01 85,396.84
1312 RECONNECT FEE 250.00 5,125.00
1314 NEW SERVICE - TAP 0.00 2,000.00
1320 MISCELLANEOUS 2,533.82 3,933.93
1324 RETURN CHECK FEE 0.00 185.00
1330 NEW INSTALLS REVENUES 0.00 1,054.30
1368 MISCELLANEOUS 1,547.85 0.00
1373 INTEREST INCOME 737.91 7,557.86
1378 TOBACCO/WELLNESS CONTRIBUTION 52.54 345.24
EXPENSES
50010100 SALARY 33,754.03 331,769.49
50010111 OVERTIME/CALL OUT 2,301.05 26,116.44
50010116 LONGEVITY 0.00 1,476.00
50010125 SOCIAL SECURITY 2,553.74 25,766.71
50010126 UNEMPLOYMENT TAX 0.00 84.62
50010127 RETIREMENT PLAN 3,091.28 33,216.53
50010128 HEALTH & DENTAL INS 0.00 35,767.74
50010130 COBRA COMPLIANCE PREMIUM 0.00 66.75
50010135 WORKERS' COMPENSATION 0.00 5,578.47
50010150 CELL PHONE ALLOWANCE 100.00 1,000.00
50020200 OFFICE SUPPLIES 0.00 1,063.53
50020201 BREAKROOM SUPPLIES 34.96 590.06
50020202 FUEL & OIL 1,223.35 10,199.66
50020208 SMALL TOOLS & SUPPLIES 171.00 16,058.10
50020209 MEETINGS AND SEMINARS 47.02 8,450.46
50020210 EQUIPMENT MAINTENANCE 821.00 4,752.19
50020211 SYSTEM MAINTENANCE 223.55 123,129.29
50020212 VEHICLE MAINTENANCE 3,001.08 11,963.03
50020213 SYSTEM IMPROVEMENTS 79.47 119,580.38
50020214 STRUCTURE MAINTENANCE 0.00 50.54
50020215 SAFETY EQUIPMENT 754.03 14,852.96
50020218 POLES 10,635.00 10,635.00
50020229 UNIFORMS 364.05 4,625.00
50020265 TIRES, TUBES & BATTERIES 0.00 434.73
50020267 SAFETY TRAINING MATERIALS 184.45 0.00
50030300 UTILITIES 204.84 905.52
50030301 COST OF POWER 362,678.01 2,464,054.30
50030302 TELEPHONE 420.37 3,679.87
50030304 POSTAGE 0.00 87.97
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 3
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
02 -ELECTRIC FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
EXPENSES (CONT)
50030310 INSURANCE (C.G.L.) 0.00 14,930.96
50030314 DUES & SUBSCRIPTIONS 0.00 148.20
50030322 ENGINEER FEES 0.00 1,172.39
50030327 P.I.L.O.T. - GENERAL 231,250.00 2,081,250.00
50030338 MISCELLANEOUS 0.00 230.25
50030345 LICENSE & FEES 0.00 337.22
50030362 JANITORIAL SUPPLIES 63.03 769.41
50030382 INFO TECHNOLOGY PLAN 50.29 69,293.29
50030383 OH ALLOCATION FRM GENERAL FUND 25,699.25 231,293.25
50040468 PUBLIC WORKS BUILDING 173.20 306,980.43
50050504 TRF OUT CO '16 PRIN 0.00 50,000.00
50050505 TRF OUT CO '16 INTEREST 0.00 4,155.30
*** TOTALS *** 844,674.12 844,674.12CR 12,346,545.86 12,346,545.86CR
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
03 -WATER & SEWER FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
1100.01 CLAIM ON CASH 148,156.88 2,338,872.87
1102 PETTY CASH DRAWERS 0.00 110.00
1109 TWDB ESCROW 2017 BONDS 0.00 2,119,211.62
1110 WATER PETTY CASH (CUST DEPOSIT 0.00 1,408.28
1111 TWDB PLANNING & DESIGN ACCOUNT 0.00 53,788.50
1112 A/R TWDB CONSTRUCTION BONDS 0.00 27,526.90
1122 WATER RIGHTS - OWNED 0.00 199,540.60
1132 WATER ACCTS RECEIVABLE 23,498.39 271,287.87
1133 SEWER UTILITY ACCTS RECEL 8,361.95 122,011.50
1134 ALLOW FOR DOUBTFUL ACCTS 776.29 10,322.14
1135 REFUNDS DUE 0.00 296.04
1142 UNBILLED RECEIVABLE 0.00 186,021.75
1148 DEFERRED PENSION OUT - CONTRIB 0.00 53,636.88
1148.10 DEFERRED TMRS OPEB OUTFLOWS 0.00 2,116.46
1162 INVENTORY 0.00 140,585.23
1172 LAND & RIGHT-OF-WAYS 0.00 337,724.79
1182 INFRASTRUCTURE 0.00 14,997,375.74
1184 OTHER EQUIPMENT 0.00 598,583.93
1186 BUILDINGS 0.00 2,923,787.10
1187 AUTOS, TRUCKS, TRACTORS 0.00 185,776.64
1196 ACCUMULATED DEPRECIATION 0.00 9,808,758.40
1197 CONSTRUCTION IN PROGRESS 0.00 3,824,200.60
LIABILITIES AND FUND BALANCE
1200.01 AP PENDING 145,941.97 36,743.62
1201 WATER RESOURCE FEE 0.00 15,559.51
1201.04 TMRS 0.00 3,161.22
1201.05 INSURANCE PAYABLE 2,352.92 2,992.94
1205 C.O.'S INTEREST PAYABLE 0.00 28,495.00
1224 2014 REFUNDING - LONG TERM 0.00 381,840.00
1225 2014 REFUNDING - CURRENT PORTI 0.00 56,610.00
1230 2013 BONDS - LONG TERM 0.00 200,000.00
1231 2013 BONDS - CURRENT PORTION 0.00 50,000.00
1232 2015 BONDS - LONG TERM 0.00 1,195,000.00
1233 2015 BONDS - CURRENT PORTION 0.00 60,000.00
1236 2016 BONDS - LONG-TERM PORTION 0.00 465,000.00
1237 2016 BONDS - CURRENT PORTION 0.00 50,000.00
1238 2017 BONDS - LONG TERM 0.00 4,805,000.00
1239 2017 BONDS - CURRENT 0.00 240,000.00
1242 CUSTOMER DEPOSITS 150.00 99,935.00
1255 ACCRUED PAYROLL 0.00 21,466.66
1256 ACCRUED VACATION PAY 0.00 7,243.32
1257 OPEB LIABILITY 0.00 34,813.82
1258 NET PENSION LIABILITY 0.00 40,280.83
1258.10 TOTAL TMRS OPEB LIABILITY 0.00 28,644.37
1259 DEFERRED PENSION INFLO-EXPUENC 0.00 100,057.97
1260 DEFERRED REVENUE - TWDB 13 GRA 0.00 0.04
1279 PRIOR PERIOD ADJUSTMENT 0.00 31,004.09
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 2
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
03 -WATER & SEWER FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
1280 FUND BALANCE 0.00 1,350,805.10
1288 NET INVESTMENT IN CAP ASSETS 0.00 7,904,228.00
1290 PAYROLL CLEARING 0.00 12,105.89
SANITATION
REVENUES
1302 RESIDENTIAL WATER 106,100.29 852,242.74
1304 COMMERCIAL WATER 117,926.67 907,011.26
1307 EAA AQUIFER MANAGEMENT FEES 21,303.10 153,384.26
1310 PENALTIES 1,912.87 22,964.90
1312 RECONNECT FEES 160.00 3,960.00
1313 WATER METERS 0.00 9,056.00
1320 MISCELLANEOUS 515.00 4,425.00
1352 SEWER REVENUE 112,273.17 910,753.25
1356 SEWER PENALTY 1,254.15 13,677.99
1358 SEWER TAP FEES 0.00 8,000.00
1373 INTEREST INCOME 4,776.50 29,334.97
1378 TOBACCO/WELLNESS CONTRIBUTION 195.16 1,849.06
1601 DWSRF GRANT REVENUES 0.00 625,937.90
1726 17 CDBG GRANT REVENUE 100,268.59 100,268.59
EXPENSES
50110100 SALARY 22,938.35 217,726.92
50110111 OVERTIME/CALL OUT 1,495.51 20,821.49
50110116 LONGEVITY 0.00 252.00
50110117 CERTIFICATE PAY 125.00 1,025.00
50110125 SOCIAL SECURITY 1,829.84 17,913.73
50110126 UNEMPLOYMENT TAX 0.00 70.25
50110127 RETIREMENT PLAN 2,112.61 22,219.80
50110128 HEALTH & DENTAL INS 0.00 26,651.63
50110130 COBRA COMPLIANCE PREMIUM 0.00 48.74
50110135 WORKERS' COMPENSATION 0.00 4,974.06
50110150 CELL PHONE ALLOWANCE 150.00 1,500.00
50120200 OFFICE SUPPLIES 32.66 936.71
50120201 BREAKROOM SUPPLIES 0.00 167.64
50120202 FUEL & OIL 912.40 9,104.47
50120208 SMALL TOOLS & SUPPLIES 0.00 15,046.24
50120209 MEETINGS & SEMINARS 90.70 4,460.27
50120210 EQUIPMENT MAINTENANCE 0.00 1,593.02
50120211 SYSTEM MAINTENANCE 8,581.35 66,357.21
50120212 VEHICLE MAINTENANCE 14.50 5,201.45
50120213 SYSTEM IMPROVEMENTS 0.00 4,438.60
50120215 SAFETY EQUIPMENT 0.00 2,730.35
50120216 STRUCTURE MAINTENANCE 0.00 81.67
50120229 UNIFORMS 373.38 3,707.38
50120232 OFFICE FURNITURE 0.00 127.98
50120241 CHEMICALS 0.00 9,051.60
50120265 TIRES, TUBES & BATTERIES 0.00 1,637.55
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 3
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
03 -WATER & SEWER FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
EXPENSES (CONT)
50130300 UTILITIES 1,698.06 5,497.91
50130302 TELEPHONE 155.59 1,875.76
50130304 POSTAGE 2.40 36.14
50130305 BUILDING SECURITY 0.00 339.15
50130310 INSURANCE (C.G.L.) 0.00 18,662.70
50130313 EAA FEES 18,521.44 166,692.96
50130314 DUES & SUBSCRIPTIONS 0.00 148.20
50130322 ENGINEER FEES 0.00 285.00
50130327 P.I.L.O.T. - GENERAL 20,125.00 181,125.00
50130336 EQUIPMENT RENTAL 1,354.79 1,354.79
50130338 MISCELLANEOUS 92.02 681.92
50130340 INSPECTION FEES 0.00 2,050.00
50130345 LICENSE & FEES 0.00 542.00
50130361 WATER TESTING 0.00 3,210.71
50130362 JANITORIAL SUPPLIES 68.93 973.37
50130367 TECQ FEES 0.00 9,018.45
50130382 INFO TECHNOLOGY PLAN 0.00 11,297.00
50130383 OH ALLOCATION FRM GENERAL FUND 15,090.75 135,816.75
50130398 RAILROAD LAND LEASES 0.00 2,078.32
50140405 WATER METER REPLACEMENT 0.00 55,533.10
50140408 VACTRON 0.00 67,075.00
50140410 VEHICLE REPLACEMENT 0.00 33,332.40
50140411 DOWNTOWN ELEVATED TANK 0.00 2,672.00
50150508 2013 DWSRF PRINCIPAL 0.00 50,000.00
50150509 2013 DWSRF INTEREST 0.00 1,800.00
50150510 TRF OUT 2014 GO REFD BOND PRIN 0.00 56,610.00
50150511 TRF OUT 2014 GO REFD BOND INT 0.00 5,886.89
50150513 CO SERIES 2015 - INTEREST 0.00 16,692.25
50150514 2016 DWSRF LOAN PRINCIPAL 0.00 50,000.00
50150515 2016 DWSRF LOAN INTEREST 0.00 4,155.30
50150517 CO SERIES 2017 INTEREST 0.00 56,950.50
50199999 TRANSFER STREET REPAIRS 0.00 15,000.00
50210100 SALARY 11,425.77 115,108.61
50210111 OVERTIME/CALL OUT 1,384.76 16,839.05
50210116 LONGEVITY 0.00 180.00
50210117 CERTIFICATE PAY 0.00 150.00
50210125 SOCIAL SECURITY 885.52 9,467.03
50210126 UNEMPLOYMENT TAX 0.00 200.85
50210127 RETIREMENT PLAN 1,099.58 11,390.17
50210128 HEALTH & DENTAL INS 0.00 8,799.06
50210130 COBRA COMPLIANCE PREMIUM 0.00 23.52
50210135 WORKERS' COMPENSATION 0.00 2,942.22
50210150 CELL PHONE ALLOWANCE 50.00 500.00
50220200 OFFICE SUPPLIES 30.79 258.55
50220201 BREAKROOM SUPPLIES 0.00 317.12
50220202 FUEL & OIL 317.67 4,366.54
50220208 SMALL TOOLS & SUPPLIES 245.00 3,250.57
50220209 MEETINGS & SEMINARS 0.00 3,808.29
50220210 EQUIPMENT MAINTENANCE 0.00 4,057.52
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 4
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
03 -WATER & SEWER FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
EXPENSES (CONT)
50220211 SYSTEM MAINTENANCE 0.00 43,719.53
50220212 VEHICLE MAINTENANCE 14.50 906.55
50220213 SYSTEM IMPROVEMENTS 7,050.00 7,050.00
50220215 SAFETY EQUIPMENT 0.00 6,992.17
50220229 UNIFORMS 165.42 1,463.06
50220241 CHEMICALS 542.61 38,584.03
50220250 LAB SUPPLIES 868.90 7,662.05
50220265 TIRES, TUBES & BATTERIES 0.00 221.99
50230300 UTILITIES 2,104.75 10,027.27
50230302 TELEPHONE 141.37 2,122.80
50230304 POSTAGE 0.00 0.65
50230310 INSURANCE (C.G.L.) 0.00 9,953.53
50230314 DUES & SUBSCRIPTIONS 0.00 255.00
50230323 SLUDGE REMOVAL 1,120.03 12,512.80
50230327 P.I.L.O.T. - GENERAL 11,540.67 103,866.03
50230338 MISCELLANEOUS 0.00 31.83
50230345 LICENSE & FEES 0.00 484.00
50230360 RENT 0.00 10,125.00
50230361 SEWER TESTING 1,388.82 17,697.53
50230362 JANITORIAL SUPPLIES 250.25 992.99
50230367 TCEQ PERMIT 0.00 13,280.60
50230382 INFO TECHNOLOGY PLAN 0.00 9,107.72
50230383 OH ALLOCATION FRM GENERAL FUND 7,313.83 65,824.47
50240401 SEWER PLANT IMPROVEMENTS 0.00 24,668.00
50240436 SSO SEWER IMPROVEMENTS 0.00 51,200.00
50942415 17 ADMIN FEES 0.00 12,000.00
50942417 17 CONSTRUCTION 0.00 112,768.00
50983460 WATER LINE CONSTRUCTION 0.00 54,694.89
50983470 NEW EST CONSTRUCTION 0.00 39,000.00
50983480 GST REHAB CONSTRUCTION 0.00 5,768.00
*** TOTALS *** 469,814.71 469,814.71CR 30,653,338.03 30,653,338.03CR
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
04 -AIRPORT FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
1100.01 CLAIM ON CASH 21,390.71 259,506.37
1132 ACCOUNTS RECEIVABLE 12,438.67 77,877.57
1134 ALLOW FOR DOUBTFUL ACCTS 0.00 24,529.82
1148 DEFERRED PENSION OUT - CONTRIB 0.00 25,976.38
1148.10 DEFERRED TMRS OPEB OUTFLOWS 0.00 821.87
1162 INVENTORY 0.00 27,099.64
1172 LAND & RIGHT-OF-WAYS 0.00 1,809,519.67
1174 BUILDINGS 0.00 15,464,024.27
1176 AUTOS, TRUCKS, TRACTORS 0.00 7,990.00
1183 EQUIPMENT 0.00 245,026.66
1185 INFRASTRUCTURE 0.00 5,365,503.15
1197 CONSTRUCTION IN PROGRESS 0.00 59,634.15
1198 ACCUMULATED DEPRECIATION 0.00 6,570,710.48
LIABILITIES AND FUND BALANCE
1200.01 AP PENDING 33,648.29 33,882.13
1201.04 TMRS 0.00 1,071.93
1201.05 INSURANCE PAYABLE 102.04 148.86
1217 UNAPPLIED CREDIT 647.63 7,126.28
1228 2016 BONDS - LONG-TERM PORTION 0.00 140,000.00
1229 2016 BONDS - CURRENT PORTION 0.00 15,000.00
1230 ACCRUED INTEREST PAYABLE 0.00 417.03
1255 ACCRUED PAYROLL 0.00 8,829.01
1256 ACCRUED VACATION PAY 0.00 2,385.26
1257 ACCRUED LIABILITY 0.00 13,081.70
1258 NET PENSION LIABILITY 0.00 17,047.35
1258.10 TOTAL TMRS OPEB LIABILITY 0.00 11,123.22
1259 DEFERRED PENSION INFLO-EXPERNC 0.00 42,228.05
1279 PRIOR PERIOD ADJUSTMENT 0.00 12,039.55
1280 FUND BALANCE 0.00 245,028.98
1288 NET INVESTMENT IN CAP ASSETS 0.00 16,225,987.00
1290 PAYROLL CLEARING 0.00 5,152.93
SANITATION
REVENUES
1302 AVGAS 100LL AVIATION FUEL 15,768.02 119,555.88
1304 JET A AVIATION FUEL 17,531.66 199,755.43
1315 OPEN T HANGARS 525.00 4,252.50
1317 ENCLOSED HANGAR RENT 6,057.61 52,796.20
1320 MISC SVC PARKING, GPU, CALLOUT 400.00 5,663.00
1350 TERMINAL BLD. OFC. RENTAL 168.00 1,512.00
1368 MISCELLANEOUS 0.00 691.69
1377 HANGAR MR-2 186.75 1,680.75
1378 TOBACCO/WELLNESS CONTRIBUTION 5.00 45.00
1381 HANGAR ER-2 10,790.52 97,114.68
1382 HANGAR MR-3&4 6,468.75 58,218.75
1383 HANGAR ER-3 3,735.32 33,617.88
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 2
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
04 -AIRPORT FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
REVENUES (CONT)
1384 HANGAR MR-7 1,232.00 11,088.00
1385 HANGAR MR-8 791.25 7,121.25
1386 HANGAR MR-9 1,000.00 9,000.00
1388 HANGAR MR-1 438.75 3,948.75
1389 HANGAR MR-5 178.84 1,609.56
1403 STREET RENT 216.67 1,950.03
1406 ANIMAL SHELTER RENT 216.67 1,950.03
1408 PARKS RENT 216.67 1,950.03
1409 SERVICE DEPT. RENT 216.67 1,950.03
1410 RECREATION CENTER LAND/RENT 175.00 1,575.00
1411 DEMONTEL BUILDING RENT 600.00 5,400.00
1412 BUILDING RENT 0.00 100.00
1413 GOLF COURSE RENT 1,166.67 10,500.03
1414 FARM LAND LEASE 0.00 59,363.62
1420 WATER FUND - LEASE OF WATER 0.00 13,200.00
1463 HONDO ART LEAGUE 25.00 225.00
1487 ACI REFUSE 900.00 8,100.00
EXPENSES
50110100 SALARY 14,427.08 131,311.89
50110111 OVERTIME 1,064.07 10,396.99
50110116 LONGEVITY 0.00 180.00
50110125 SOCIAL SECURITY 1,255.29 11,249.35
50110126 UNEMPLOYMENT TAX 0.00 208.02
50110127 RETIREMENT PLAN 1,405.71 11,609.55
50110128 HEALTH & DENTAL INS 0.00 14,015.58
50110130 COBRA COMPLIANCE PREMIUM 0.00 21.92
50110135 WORKERS COMPENSATION 0.00 2,792.94
50110149 AUTO ALLOWANCE 400.00 4,000.00
50110150 CELL PHONE ALLOWANCE 550.00 1,450.00
50120200 OFFICE SUPPLIES 163.48 1,563.39
50120201 BREAKROOM SUPPLIES 94.36 386.35
50120202 FUEL & OIL 757.85 4,174.83
50120204 OFFICE FURNITURE 0.00 384.00
50120208 SMALL TOOLS & SUPPLIES 0.00 2,074.47
50120209 MEETINGS & SEMINARS 76.56 2,721.70
50120210 EQUIPMENT MAINTENANCE 408.00 4,120.29
50120214 TERMINAL BUILDING MAINT 1,139.99 1,139.99
50120215 SAFETY EQUIPMENT 0.00 495.19
50120229 UNIFORMS 33.04 291.10
50120246 100LL AVIATION GASOLINE 0.00 107,347.15
50120247 JET A AVIATION FUEL 0.00 116,493.76
50120248 JET TRUCK LEASE 1,000.00 9,000.00
50120265 TIRES, TUBES & BATTERIES 0.00 902.91
50130300 UTILITIES 841.88 3,388.56
50130302 TELEPHONE 266.75 1,784.60
50130303 OFFICE EQUIPMENT LEASE PAYMENT 125.03 1,125.27
50130304 POSTAGE 23.96 265.96
50130307 CREDIT CARD FEES 1,007.59 10,360.55
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 3
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
04 -AIRPORT FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
EXPENSES (CONT)
50130310 INSURANCE (C.G.L.) 0.00 25,878.37
50130312 MAINTENANCE AGREEMENTS 0.00 738.64
50130314 DUES & SUBSCRIPTIONS 117.48 1,899.95
50130328 APPRAISAL FEES 0.00 15,400.00
50130330 LEGAL FEES 0.00 18,892.97
50130338 MISCELLANEOUS 0.00 29.00
50130342 ENVIRONMENTAL REMEDIATION 1,435.00 35,883.81
50130345 LICENSE & FEES 10.00 90.00
50130362 JANITORIAL SUPPLIES 56.34 1,430.75
50130366 CONTINGENCY EXPENSE 0.00 1,894.26
50130370 COMMUNITY OUTREACH & MKTG 0.00 350.00
50130382 INFO TECHNOLOGY PLAN 0.00 12,944.00
50130383 OH ALLOCATION TO GENERAL FUND 7,323.92 65,915.28
50130399 CONSULTING/ENGINEERING FEES 8,325.00 8,325.00
50140419 Z-TURN MOWER 0.00 9,912.92
50150504 TRF OUT TO CO 2016 PRIN 0.00 15,000.00
50150505 TRF OUT TO CO 2016 INTEREST 0.00 1,251.07
50220224 HONDO ART LEAGUE MAINT. 0.00 67.48
50220245 WATER/SEWER IMPROVEMENTS 0.00 25,403.85
50840700 13 RAMP GRANT 1,460.60 54,856.96
*** TOTALS *** 90,503.57 90,503.57CR 24,092,062.51 24,092,062.51CR
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
05 -SANITATION
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
1100.01 CLAIM ON CASH 3,848.01 253,700.98
1123 SANITATION ACCOUNTS RECEIVABL 5,887.20 139,811.18
1133 SALES TAX RECEIVABLE 63.01 9,174.74
1134 ALLOWANCE FOR DOUBTFUL ACCOUNT 164.88 5,889.14
1148 DEFERRED PENSION OUT - CONTRIB 0.00 1,539.35
1148.10 DEFERRED TMRS OPEB OUTFLOWS 0.00 53.89
1150 ACCOUNTS RECEIVABLE PERMITS 0.00 20.00
LIABILITIES AND FUND BALANCE
1200.01 AP PENDING 443.85 106,196.51
1217 UNAPPLIED CREDIT 0.00 20.00
1232 SALES TAX PAYABLE 44.61 7,781.62
1257 ACCRUED LIABILITIES 0.00 717.54
1258 NET PENSION LIABILITY 0.00 944.84
1258.10 TOTAL TMRS OPEB LIABILITY 0.00 729.33
1259 DEFERRED PENSION INFLO-EXPERNC 0.00 2,698.89
1279 PRIOR PERIOD ADJUSTMENT 0.00 789.42
1280 FUND BALANCE 0.00 214,852.75
1290 PAYROLL CLEARING 0.00 401.58
SANITATION
REVENUES
1302 RESIDENTIAL SANITATION 53,645.28 484,377.34
1304 COMMERCIAL SANITATION 65,395.19 546,632.68
1306 PENALTIES 1,187.75 13,357.97
1310 COLLECTION CENTER PERMITS 0.00 2,012.50
1320 MISCELLANEOUS 38.72 322.23
1373 INTEREST INCOME 488.23 3,178.23
EXPENSES
51210100 SALARY 0.00 459.74
51210125 SOCIAL SECURITY 0.00 35.17
51210127 RETIREMENT PLAN 0.00 127.04
51210135 WORKERS COMPENSATION 0.00 173.96
51230300 UTILITIES 0.00 0.96
51230302 TELEPHONE 0.00 0.96
51230351 RESIDENTIAL SOLID WASTE COLL 48,912.24 429,494.04
51230352 COMMERCIAL SOLID WASTE COLL 57,284.27 506,798.84
51230354 COLLECTION STATION 0.00 646.08
51230355 TIRE,TV AND SIMILAR PICKUPS 0.00 1,800.00
51230382 INFORMATION TECHNOLOGY 0.00 729.00
51230383 OH ALLOCATION FRM GENERAL FUND 4,526.08 40,734.72
*** TOTALS *** 120,964.66 120,964.66CR 1,388,101.61 1,388,101.61CR
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
06 -BOND & SINKING FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
1100.01 CLAIM ON CASH 2,692.58 346,377.31
1130 DELINQUENT TAXES RECE 0.00 32,878.38
1131 ALLOWANCE FOR DOUBTFUL AC 0.00 4,931.76
LIABILITIES AND FUND BALANCE
1260 DEFERRED REVENUE 0.00 27,946.62
1280 FUND BALANCE 0.00 151,209.92
SANITATION
REVENUES
1302 PROPERTY TAX REVENUE 2,026.00 383,974.28
1318 TRF IN FROM EDC 0.00 110,536.90
1322 TRF IN FROM ELECTRIC FUND 0.00 54,155.30
1323 TRF IN FROM WATER FUND 0.00 242,094.93
1324 TRF IN FROM AIRPORT FUND 0.00 16,251.08
1373 INTEREST INCOME 666.58 4,234.55
EXPENSES
50050402 2013 DWSRF PRINCIPAL 0.00 50,000.00
50050403 2013 DWSRF INTEREST 0.00 1,800.00
50050502 2010 SALES TAX BOND PRINCIPAL 0.00 45,000.00
50050503 2010 SALES TAX REV. BOND INTE 0.00 16,340.00
50050537 2014 REFUNDING PRINCIPAL 0.00 153,000.00
50050538 2014 REFUNDING INTEREST 0.00 15,910.50
50050539 2016 CO PRINCIPAL 0.00 220,000.00
50050540 2016 CO INTEREST 0.00 18,935.65
50050542 CO SERIES 2015 INTEREST 0.00 38,143.00
50050544 SERIES 2017 INTEREST 0.00 56,950.50
*** TOTALS *** 2,692.58 2,692.58CR 995,335.34 995,335.34CR
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
08 -PAYROLL FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
1151 DUE FROM GENERAL FUND 0.00 96,646.51
1152 DUE FROM ELECTRIC 0.00 12,813.44
1153 DUE FROM WATER/SEWER 0.00 12,105.89
1154 DUE FROM AIRPORT 0.00 5,152.93
1155 DUE FROM SANITATION 0.00 401.58
1157 DUE FROM ECONOMIC DEVELOP 0.00 2,487.03
LIABILITIES AND FUND BALANCE
1220 WAGES PAYABLE 0.00 129,607.38
SANITATION
REVENUES
EXPENSES
*** TOTALS *** 0.00 0.00 129,607.38 129,607.38CR
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
09 -COMMITTED/RESTRICTED FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
1100.01 CLAIM ON CASH 3,811.78 530,436.39
LIABILITIES AND FUND BALANCE
1200.01 AP PENDING 4,692.04 8,938.00
1280 FUND BALANCE 0.00 43,902.14
1281 SW FAMILY LIFE CT FUND BALANCE 0.00 2,499.61
1284 STORM DRAINAGE FUND BALANCE 0.00 55,000.45
1285 COURT TECHNOLOGY FUND BALANCE 0.00 8,236.51
1286 COURT SECURITY FUND BALANCE 0.00 16,904.28
1287 IT IMPROV PLAN FUND BALANCE 0.00 86,565.34
SANITATION
REVENUES
1316 CITY CONT FOR SWFLC 0.00 6,700.00
1319 COURT SECURITY FEE 72.00 901.00
1320 COURT TECHNOLOGY FEES 104.00 1,282.40
1341 CITY CONT FOR STREETS 0.00 180,000.00
1342 WATER CONT FOR STREETS 0.00 15,000.00
1345 CITY CONT FOR CURBS 0.00 80,000.00
1348 CITY CONT FOR STORM DRAINAGE 0.00 80,000.00
1370 INFORMATION TECHNOLOGY 0.00 211,147.00
1373 INTEREST INCOME 1,020.79 5,633.47
EXPENSES
50030316 SOUTHWEST FAMILY LIFE CENTER 282.61 1,935.38
50030319 COURT SECURITY FEE 0.00 199.00
50030320 COURT TECHNOLOGY 0.00 3,182.11
50030382 INFORMATION TECH ANNUAL MAINT 9,418.00 179,153.04
*** TOTALS *** 9,700.61 9,700.61CR 758,808.06 758,808.06CR
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
10 -POOLED CASH ACCOUNT
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
LIABILITIES AND FUND BALANCE
SANITATION
REVENUES
EXPENSES
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
11 -PERPETUAL CARE FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
1100.01 CLAIM ON CASH 224.97 80,212.30
1111 PERPETUAL CARE MAINTENANCE FUN 1,100.00 125,469.67
1121 CD INVESTMENT 0.00 551,023.50
LIABILITIES AND FUND BALANCE
1200.01 AP PENDING 164.91 0.00
1278 NON-SPENDABLE FUND BALANCE 0.00 545,990.00
1280 FUND BALANCE 0.00 12,354.98
SANITATION
REVENUES
1305 REVENUE 1,100.00 14,400.00
1373 INTEREST INCOME 0.00 5,033.50
EXPENSES
50023036 MOWING FEES TO GENERAL FUND 0.00 19,000.00
50030301 BANK FEES 0.00 148.00
50030311 CEMETERY CLEANUP 60.06 349.61
*** TOTALS *** 1,324.97 1,324.97CR 676,990.78 676,990.78CR
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
12 -FORFEITURE/SEIZURE FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
1100.01 CLAIM ON CASH 0.00 2,216.96
1111 SEIZURE FUND 0.00 6,516.47
1112 FORFEITURE FUND 0.00 5,986.28
LIABILITIES AND FUND BALANCE
1200 ACCOUNTS PAYABLE 0.00 2,350.00
1221 SEIZED FUNDS 0.00 6,701.78
1280 FUND BALANCE 0.00 6,383.33
SANITATION
REVENUES
1340 FORFEITED FUNDS 0.00 253.80
EXPENSES
50030321 DA AND DISTRICT CLERK FEES 0.00 169.20
50030360 INVESTIGATION EXPENSE 0.00 800.00
*** TOTALS *** 0.00 0.00 15,688.91 15,688.91CR
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
14 -'07 CERT OF OBLIGATION
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
1100.01 CLAIM ON CASH 0.00 0.33
LIABILITIES AND FUND BALANCE
1280 FUND BALANCE 0.00 0.33
SANITATION
REVENUES
EXPENSES
*** TOTALS *** 0.00 0.00 0.33 0.33CR
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
16 -LIBRARY FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
LIABILITIES AND FUND BALANCE
SANITATION
REVENUES
EXPENSES
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
17 -UNCLAIMED MONEY FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
1100.01 CLAIM ON CASH 11.84 6,151.47
1121 CD INVESTMENTS 0.00 7,727.52
LIABILITIES AND FUND BALANCE
1200 DUE TO OTHERS 0.00 12,117.92
1280 FUND BALANCE 0.00 1,585.28
SANITATION
REVENUES
1373 INTEREST INCOME 11.84 160.79
EXPENSES
50220202 CUSTOMER DEPOSITS 0.00 15.00
*** TOTALS *** 11.84 11.84CR 13,878.99 13,878.99CR
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
18 -ECONOMIC DEV FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
1100.01 CLAIM ON CASH 44,458.11 290,926.15
1110 ECONOMIC DEVELOPMENT FUND 74,439.43 445,857.41
1121 CD INVESTMENT 0.00 1,799,974.62
1146 SALES TAX RECEIVABLE 0.00 188,763.81
LIABILITIES AND FUND BALANCE
1200 ACCOUNTS PAYABLE 56,698.64 1,092.08
1200.01 AP PENDING 4,754.23 870.74
1201.04 TMRS 0.00 806.69
1255 ACCRUED PAYROLL 0.00 5,550.36
1280 FUND BALANCE 0.00 2,753,588.13
1290 PAYROLL CLEARING 0.00 2,487.03
SANITATION
REVENUES
1301 SALES TAX REVENUE 42,759.07 542,824.51
1306 EDA ANNEX GRANT 0.00 491,418.96
1373 INTEREST INCOME 0.00 16,748.20
EXPENSES
50010100 SALARY 5,913.52 58,558.24
50010125 SOCIAL SECURITY 490.64 4,862.24
50010126 UNEMPLOYMENT TAX 0.00 16.27
50010127 RETIREMENT 548.36 5,865.29
50010128 HEALTH & DENTAL INS 0.00 60.10
50010135 WORKERS COMP (TML) 0.00 125.46
50010149 AUTO ALLOWANCE EDC 450.00 4,500.00
50010150 CELL PHONE ALLOWANCE 50.00 500.00
50020200 OFFICE SUPPLIES 0.00 225.40
50030209 MEETINGS & SEMINARS 1,305.00 4,768.96
50030300 LEGAL SERVICES 0.00 1,140.00
50030302 TELEPHONE 157.06 1,255.58
50030304 POSTAGE 0.00 42.74
50030314 DUES & SUBSCRIPTIONS 0.00 1,110.99
50030316 EDUCATION PROJECTS 0.00 3,157.30
50030317 CHAMBER CONTRACT 1,666.66 14,999.94
50030319 MARKETING & ADVERTISING 706.28 11,735.80
50030382 INFORMATION TECH 0.00 30,000.00
50040411 STRTC VOC ANNEX EDA SHARE 0.00 554,902.59
50040412 STRTC VOCATIONAL ANNEX 0.00 261,700.91
50040414 CASTRO AVE REBUILD 90-CARTER 0.00 19,800.00
50050502 TRF OUT TO BOND SER 2010 PRIN 0.00 45,000.00
50050503 TRF OUT TO BOND SER 2010 INT 0.00 16,340.00
50050504 CO SERIES 2016 PRINCIPAL 0.00 45,000.00
50050505 CO SERIES 2016 INTEREST 0.00 4,196.90
*** TOTALS *** 117,198.50 117,198.50CR 3,815,386.70 3,815,386.70CR
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
19 -CITY OF HONDO INVESTMENT
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
LIABILITIES AND FUND BALANCE
SANITATION
REVENUES
EXPENSES
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
20 -SOUTH TEXAS REGIONAL TRAI
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
1100.01 CLAIM ON CASH 1,848.40 94,971.75
1110 STRTC GENERAL OP FND 2,850.64 45,732.56
1150 ACCOUNTS RECEIVABLE 993.66 25,792.21
LIABILITIES AND FUND BALANCE
1200 ACCOUNTS PAYABLE 404.22 1,411.49
1200.01 AP PENDING 41.67 209.99
1217 UNAPPLIED CREDIT 5,287.56 4,557.56
1242 CUSTOMER DEPOSIT 0.00 90.00
1280 FUND BALANCE 0.00 127,254.66
SANITATION
REVENUES
1301 SWTJC RENT 2,565.00 23,650.00
1302 ALAMO WRKFRCE OFFICE LEASE 1,978.90 21,892.72
1305 MONTHLY UTILITY 262.32 4,891.62
1310 ADMIN SVS & SUPPORT 1,440.00 13,840.00
1330 MISCELLANEOUS RENTALS 35.00 70.00
EXPENSES
50220200 OFFICE SUPPLIES 21.26 1,484.63
50220201 BREAKROOM SUPPLIES 0.00 296.90
50220210 EQUIPMENT MAINTENANCE 351.00 351.00
50220263 FURNITURE 0.00 4,844.81
50230300 UTILITIES 726.26 2,375.09
50230302 TELEPHONE 209.99 2,831.17
50230310 INSURANCE 0.00 3,295.42
50230312 MAINTENANCE AGREEMENTS 0.00 1,098.64
50230338 MISCELLANEOUS 0.00 203.96
50230350 BUILDING MAINTENANCE 0.00 3,787.65
50230362 JANITORIAL SUPPLIES 56.28 1,547.13
*** TOTALS *** 9,536.08 9,536.08CR 193,240.48 193,240.48CR
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
21 -HOTEL/MOTEL TAX FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
1100.01 CLAIM ON CASH 20,875.00 123,849.38
1132 HOT RECEIVABLE 0.00 31,022.03
LIABILITIES AND FUND BALANCE
1200.01 AP PENDING 0.00 2,500.00
1280 FUND BALANCE 0.00 142,130.28
SANITATION
REVENUES
1315 HOTEL/MOTEL TAX REVENUES 0.00 100,241.13
EXPENSES
50230301 HONDO CHAMBER OF COMMERCE 16,500.00 65,000.00
50230302 MEDINA COUNTY FAIR ASSN. 2,500.00 10,000.00
50230303 MEDINA COUNTY MUSEUM 1,875.00 7,500.00
50230305 RODEO ASSOCIATION 0.00 5,000.00
50230312 STOL ROUNDUP 0.00 2,500.00
*** TOTALS *** 20,875.00 20,875.00CR 244,871.41 244,871.41CR
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
22 -WATER RESOURCE
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
1100.01 CLAIM ON CASH 2,576.00 143,167.00
LIABILITIES AND FUND BALANCE
1280 FUND BALANCE 0.00 135,424.00
SANITATION
REVENUES
1306 WATER RESOURCES REVENUE 2,576.00 7,743.00
EXPENSES
*** TOTALS *** 2,576.00 2,576.00CR 143,167.00 143,167.00CR
7-09-2019 06:40 PM C I T Y O F H O N D O PAGE: 1
TRIAL BALANCE
AS OF: JUNE 30TH, 2019
99 -POOLED CASH FUND
**** MONTH TO DATE **** ***** YEAR TO DATE *****
ACCOUNT NO# TITLE DEBITS CREDITS DEBITS CREDITS
ASSETS
1000 POOLED OPERATING ACCOUNT 70,981.55 4,915,757.48
1011 POOLED PAYROLL ACCOUNT 19,612.07 225,677.74
1101 DUE FROM GENERAL FUND 95,104.66 203,583.89
1102 DUE FROM ELECTRIC FUND 34,867.83 67,200.78
1103 DUE FROM WATER/SEWER FUND 145,941.97 36,743.62
1104 DUE FROM AIRPORT FUND 33,648.29 33,882.13
1105 DUE FROM SANITATION FUND 443.85 106,196.51
1109 DUE FROM COMMITTED/RESTRICTED 4,692.04 8,938.00
1111 DUE FROM PERPETUAL CARE FUND 164.91 0.00
1118 DUE FROM ECONOMIC DEV FUND 4,754.23 870.74
1120 DUE FROM STRTC FUND 41.67 209.99
1121 DUE FROM HOT FUND 0.00 2,500.00
LIABILITIES AND FUND BALANCE
1200 ACCOUNTS PAYABLE CONTROL 310,275.37 460,125.66
1201 PURCHASING CARD LIABILITY 908.80 908.80
1210 DUE TO OTHER FUNDS 50,460.68 5,270,133.80
1220 WAGES PAYABLE 0.00 129,607.38
SANITATION
REVENUES
EXPENSES
*** TOTALS *** 385,948.96 385,948.96CR 5,731,168.26 5,731,168.26CR