11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
100-1-1102 CLAIM ON CASH 245,801.78 258,683.61
100-1-1106 CASH ON HAND 0.00 200.00
100-1-1107 FRANCHISE TAX RECEIVABLE 632.92 87,977.95
100-1-1108 SALES TAX RECEIVABLE 129,113.89 516,183.53
100-1-1112 DUE FROM OTHER FUNDS 0.00 400.00
100-1-1113 POOLED CASH CD 1,125.34 223,042.52
100-1-1190 COURT FINES RECEIVABLE 15,697.68 198,766.88
100-1-1191 ALLOWANCE FOR UNCOLLECTABLE-CT 15,192.18 159,013.50
100-1-1196 MISC RECIEVABLES 554.95 0.00
100-1-1200 TEXPOOL - GENERAL RESERVE 182.88 103,038.22
100-1-1201 PREPAID EXPENSES 24,302.32 30,485.86
100-1-1202 TEXSTAR - GENERAL RESERVE 1,775.36 1,027,322.80
100-1-1234 DUE FROM NEXTLINK 445.87 0.00
100-1-1300 PROPERTY INVESTMENTS 0.00 148,789.60
100-1-5200 TEXPOOL - SALES TAX RESERVE 295.64 166,587.71
______________ ______________ ______________ ______________
TOTAL ASSETS 394,565.86 40,554.95 2,761,478.68 159,013.50
============== ============== ============== ==============
LIABILITIES
===========
100-2-2000 ACCOUNTS PAYABLE CONTROL 17,499.94 17,499.94
100-2-2001 ACCOUNTS PAYABLE - 1999 217,790.02 231,343.65
100-2-2005 DUE TO TRUST & AGENCY FUND 184.00 0.00
100-2-2011 RETIREMENT (TMRS PAYABLE) 699.31 1,984.51
100-2-2012 HEALTH INSURANCE PAYABLE 273.53 2,170.71
100-2-2014 CHILD SUPPORT PAYABLE 120.00 110.77
100-2-2015 DEFERRED COMP PAYABLE 90.03 176.53
100-2-2018 DUE TO SPLASH KINGDOM 0.00 53.68
100-2-2020 UNITED WAY PAYABLE 0.83 19.08
100-2-2021 ACCRUED PAYROLL-GEN FUND 7,324.35 20,987.75
100-2-2023 DUE TO OMNIBASE 24.00 78.78
100-2-2025 LEADERS LIFE PAYABLE 1.73 27.58
100-2-2101 AP PENDING (DUE TO POOL CASH) 255,020.53 350,257.16
100-2-2102 DUE TO STATE-COURT COSTS 163.40 2,161.72
100-2-2103 DUE TO OTHER FUNDS 37,056.44 0.00
100-2-2107 DUE TO POLICE OFFICE ASSOC 7.00 42.00
100-2-3300 DEFERRED REVENUE 67,935.55 389,983.25
100-2-4100 FEDERAL WITHHOLDING 870.46 2,461.00
100-2-4200 MEDICARE PAYABLE 84.15 382.57
______________ ______________ ______________ ______________
TOTAL LIABILITIES 37,177.27 567,968.00 0.00 1,019,740.68
============== ============== ============== ==============
FUND BALANCE
============
100-3-1100 FUND BALANCE 16,394.06 1,153,597.73
100-3-1102 ASSIGNED FUND BALANCE 0.00 185,000.00
100-3-1103 RESTRICTED FUND BALANCE-PEG 1,432.45 9,972.34
100-3-1104 NONSPENDABLE FUND BALANCE 14,961.61 30,215.86
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 16,394.06 16,394.06 0.00 1,378,785.93
============== ============== ============== ==============
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
REVENUES
========
100-4-01420-31-1100 LOCAL SALES & USE TAX 317,232.82 2,743,789.66
100-4-01420-31-1120 MIXED BEVERAGES TAX 0.00 11,443.17
100-4-01420-31-2000 PAYMENT IN LIEU OF TAXES 0.00 22,412.78
100-4-01420-31-2100 FRANCHISE FEES 5,256.38 191,751.96
100-4-01420-31-2200 IN-KIND PEG FEES 926.41 1,432.45
100-4-01420-32-3100 ALCOHOLIC BEVERAGE PERMITS 0.00 1,150.00
100-4-01420-33-2100 STATE GRANT REVENUES 695.00 0.00
100-4-01420-34-2100 PRINTING & DUPLICATION FEE 0.00 7.00
100-4-01420-36-1100 INTEREST REVENUE 6,544.12 65,254.73
100-4-01420-38-1100 MISCELLANEOUS REVENUE 46,540.20 1,801.64
100-4-01420-38-1200 CREDIT CARD REVENUE-MISC (FEE) 25.49 1,758.92
100-4-01420-38-2000 ROADWAY ASSESSMENTS 38,172.10 346,740.59
100-4-01420-39-4120 T-MOBILE GROUND LEASE 3,630.00 23,595.00
100-4-02110-35-1100 TRAFFIC FINES 1,135.23 16,218.06
100-4-02110-35-1200 ARREST FEES 6.58 557.74
100-4-02110-35-1300 COURT ADMINISTRATIVE FEES 0.00 140.60
100-4-02110-35-1400 WARRANT FEES 50.00 2,289.70
100-4-02110-35-1500 COURT SPECIAL EXPENSE FEE 0.00 691.11
100-4-02110-35-1600 TFC FEES 3.00 137.25
100-4-02110-35-1700 JFCI REVENUE 0.60 64.65
100-4-02110-35-1710 CIVIL JUSTICE FEE-COURT 0.00 0.22
100-4-02110-35-1900 CREDIT CARD REVENUE-COURT 15.30 398.72
100-4-02110-35-1910 OVERPAYMENT-COURT 0.00 38.52
100-4-03110-34-2201 MISCELLANEOUS REVENUE-POLICE 250.00 275.00
100-4-03410-33-4100 TCLEOSE EDUCATION ALLOWANCE 0.00 1,252.92
100-4-03410-33-4102 ESD#3 BUILDING LEASE 0.00 21,185.12
100-4-03410-33-4103 WEATHERFORD FIRE ACADEMY LEAS 0.00 5,185.00
100-4-06110-32-3200 BUILDING PERMITS 53,393.90 571,414.76
100-4-06110-32-3300 OCCUPANCY PERMITS 100.00 2,800.00
100-4-06110-32-3400 SIGN PERMITS 0.00 7,242.10
100-4-06110-32-3420 BILLBOARD PERMITS 0.00 150.00
100-4-06210-34-1110 DEVELOPMENT REVIEW FEES 0.00 3,445.32
100-4-06210-34-1120 REPLAT FEES 0.00 2,076.16
100-4-06210-34-1140 ZONING FEES 0.00 125.00
100-4-06310-32-3600 SEPTIC PERMITS 0.00 4,100.00
100-4-06310-32-3700 HEALTH PERMITS 0.00 13,000.00
100-4-06310-32-3720 HEALTH PERMITS-LATE PENALTY 0.00 300.00
100-4-08000-61-1200 CAPITAL LEASE PROCEEDS 21,459.90 21,459.90
______________ ______________ ______________ ______________
TOTAL REVENUES 47,675.43 447,761.60 0.00 4,085,685.75
============== ============== ============== ==============
EXPENDITURES
============
100-5-01110-51-1100 REGULAR PAY 23,863.76 285,252.54
100-5-01110-51-1300 OVERTIME PAY 0.00 171.12
100-5-01110-51-2100 MEDICAL INSURANCE 1,084.06 12,827.02
100-5-01110-51-2120 DENTAL INSURANCE 95.56 1,066.88
100-5-01110-51-2160 LIFE INSURANCE 25.40 289.56
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
100-5-01110-51-2180 AD&D INSURANCE 2.40 36.80
100-5-01110-51-2200 TMRS 2,628.96 32,554.98
100-5-01110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 1,000.00
100-5-01110-51-2520 MEDICARE TAXES 291.96 3,765.61
100-5-01110-51-2540 UNEMPLOYMENT INSURANCE 0.00 203.15
100-5-01110-51-2550 INSURANCE-P & L 0.00 2,505.69
100-5-01110-51-2560 WORKER'S COMPENSATION 0.00 3,833.86
100-5-01110-52-1100 CONTRACT LABOR 0.00 7,920.00
100-5-01110-52-1200 AUDITING & ACCOUNTING 0.00 6,377.00
100-5-01110-52-1300 PROFESSIONAL SERVICES 15,858.95 96,180.03
100-5-01110-52-1400 LEGAL FEES 2,728.06 37,884.48
100-5-01110-52-1500 EQUIPMENT RENTAL 0.00 241.10
100-5-01110-52-1600 BUILDING INSPECTIONS 0.00 90.00
100-5-01110-53-1100 GENERAL OFFICE SUPPLIES 1,298.04 7,398.30
100-5-01110-53-1200 COMPUTER SUPPLIES 72.66 5,882.63
100-5-01110-53-1300 MISCELLANEOUS SUPPLIES 2,175.75 9,185.04
100-5-01110-54-1100 PRINTING 51.84 1,307.14
100-5-01110-54-1200 POSTAGE 0.00 2,029.65
100-5-01110-54-1400 BANK FEES 2,219.17 466.65
100-5-01110-54-2100 SEMINARS & TRAINING 370.00 7,703.85
100-5-01110-54-2110 COMMUNITY EVENTS 1,200.00 14,721.99
100-5-01110-54-2300 TRAVEL EXPENSE 0.00 7,939.77
100-5-01110-54-2400 MEALS & EXPENSES 32.87 1,606.72
100-5-01110-54-3100 DUES & SUBSCRIPTIONS 1,326.11 9,397.82
100-5-01110-54-4100 TELEPHONE 965.00 13,609.41
100-5-01110-54-4200 ELECTRIC UTILITIES 682.38 7,753.29
100-5-01110-54-5000 ECON DEV AGREEMENTS 217,790.02 309,617.26
100-5-01110-54-5100 SOFTWARE MAINTENANCE 6,807.16 44,252.57
100-5-01110-54-5400 GENERAL LIABILITY INSURANCE 0.00 3,234.52
100-5-01110-55-2200 OFFICE EQUIPMENT MAINTENANCE 386.38 0.00
100-5-01110-56-1200 OFFICE MACHINES 566.44 3,373.01
100-5-01210-54-1300 ADVERTISING & LEGAL NOTICES 0.00 2,773.99
100-5-01210-54-1310 FILING FEES 300.91 5,543.65
100-5-02110-51-1100 REGULAR PAY 2,079.94 25,841.70
100-5-02110-51-2100 MEDICAL INSURANCE 122.96 1,604.83
100-5-02110-51-2120 DENTAL INSURANCE 15.28 197.95
100-5-02110-51-2160 LIFE INSURANCE 4.06 52.78
100-5-02110-51-2180 AD&D INSURANCE 0.64 8.32
100-5-02110-51-2200 TMRS 227.28 3,148.07
100-5-02110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 160.00
100-5-02110-51-2520 MEDICARE TAXES 26.28 359.55
100-5-02110-51-2560 WORKER'S COMPENSATION 0.00 556.20
100-5-02110-52-1300 PROFESSIONAL SERVICES 400.00 9,247.63
100-5-02110-54-2100 SEMINARS & TRAINING 0.00 200.00
100-5-02110-54-4100 TELEPHONE 0.00 111.68
100-5-02110-54-5100 SOFTWARE MAINTENANCE 3,136.43 7,050.59
100-5-02110-54-5400 GENERAL LIABILITY INSURANCE 0.00 131.04
100-5-03110-51-1100 REGULAR PAY 61,800.07 737,287.16
100-5-03110-51-1300 OVERTIME PAY 8,142.71 93,047.48
100-5-03110-51-2100 MEDICAL INSURANCE 3,397.62 43,198.40
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 4
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
100-5-03110-51-2120 DENTAL INSURANCE 420.42 5,293.44
100-5-03110-51-2160 LIFE INSURANCE 111.76 1,412.24
100-5-03110-51-2180 AD&D INSURANCE 17.60 222.40
100-5-03110-51-2200 TMRS 7,829.22 101,769.45
100-5-03110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 4,800.00
100-5-03110-51-2240 LONGEVITY PAY 0.00 4,811.04
100-5-03110-51-2520 MEDICARE TAXES 868.37 11,092.80
100-5-03110-51-2560 WORKER'S COMPENSATION 0.00 15,296.00
100-5-03110-52-1100 CONTRACT LABOR 675.00 34,002.15
100-5-03110-52-1200 AUDITING & ACCOUNTING 0.00 7,166.00
100-5-03110-53-1100 GENERAL OFFICE SUPPLIES 19.56 2,485.39
100-5-03110-53-1200 COMPUTER SUPPLIES 227.68 1,484.16
100-5-03110-53-1300 MISCELLANEOUS EXPENSE 231.12 2,075.35
100-5-03110-53-1400 AMMUNITION 0.00 2,341.62
100-5-03110-53-1500 UNIFORMS 2,911.89 11,641.29
100-5-03110-54-1100 PRINTING 0.00 584.70
100-5-03110-54-1200 POSTAGE 18.89 322.57
100-5-03110-54-2100 SEMINARS & TRAINING 575.00 5,688.13
100-5-03110-54-2110 COMMUNITY EVENTS - PUB SAFETY 0.00 1,200.00
100-5-03110-54-2300 TRAVEL EXPENSES 105.81 105.81
100-5-03110-54-3100 DUES & SUBSCRIPTIONS 0.00 1,101.00
100-5-03110-54-4100 TELEPHONE 835.81 11,438.62
100-5-03110-54-4200 ELECTRIC UTILITIES 1,016.02 13,063.50
100-5-03110-54-5100 SOFTWARE MAINTENANCE 3,538.81 37,546.86
100-5-03110-54-5300 PRE-EMPLOYMENT SCREENING 72.00 717.00
100-5-03110-54-5400 GENERAL LIABILITY INSURANCE 0.00 16,996.80
100-5-03110-54-6100 INMATE HOUSING 0.00 317.25
100-5-03110-54-6200 DISPATCHER 17,499.94 70,000.00
100-5-03110-55-1100 VEHICLE MAINTENANCE 4,801.44 12,349.60
100-5-03110-55-1200 GAS & OIL 2,386.84 25,541.34
100-5-03110-55-2200 OFFICE EQUIPMENT MAINTENANCE 199.44 2,369.59
100-5-03110-56-2200 VEHICLES 21,459.90 32,919.01
100-5-03110-56-2300 PUBLIC SAFETY BUILDING 0.00 2,035.00
100-5-03110-60-1200 CAPITAL LEASE - PRINCIPAL 6,481.47 45,918.70
100-5-03110-60-2200 CAPITAL LEASE - INTEREST 2,539.05 3,810.20
100-5-04110-51-1100 REGULAR PAY 6,930.80 24,518.05
100-5-04110-51-1300 OVERTIME PAY 1,172.11 3,516.53
100-5-04110-51-2100 MEDICAL INSURANCE 624.35 2,220.51
100-5-04110-51-2120 DENTAL INSURANCE 38.22 190.72
100-5-04110-51-2160 LIFE INSURANCE 10.16 50.87
100-5-04110-51-2180 AD&D INSURANCE 1.60 8.00
100-5-04110-51-2200 TMRS 796.85 3,224.90
100-5-04110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 240.00
100-5-04110-51-2520 MEDICARE TAXES 95.47 383.71
100-5-04110-51-2550 INSURANCE-P & L 0.00 75.00
100-5-04110-51-2560 WORKERS COMPENSATION 0.00 695.28
100-5-04110-53-1200 COMPUTER SUPPLIES 0.00 515.17
100-5-04110-53-1300 MISCELLANEOUS EXPENSE 539.70 1,687.29
100-5-04110-53-1500 UNIFORMS 0.00 146.13
100-5-04110-54-5400 GENERAL LIABILITY INSURANCE 0.00 4,129.64
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 5
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
100-5-04110-60-1001 TRANSFER OUT/I-20 OFF RAMP 122,657.14 692,242.86
100-5-04210-51-2521 FICA TAXES 0.00 867.90
100-5-04210-52-1300 PROFESSIONAL SERVICES 53,909.40 62,184.40
100-5-04210-54-4200 ELECTRIC UTILITIES 285.08 6,219.34
100-5-04210-56-4100 STREET SIGNS 3,547.15 5,648.70
100-5-04210-56-4200 STREET IMPROVEMENTS 165,469.97 264,195.18
100-5-04210-56-4300 STREET REPAIRS 1,800.00 91,188.11
100-5-05110-51-1100 REGULAR PAY 2,537.19 26,604.24
100-5-05110-51-1300 OVERTIME PAY 73.50 810.01
100-5-05110-51-2100 MEDICAL INSURANCE 0.00 1,536.98
100-5-05110-51-2120 DENTAL INSURANCE 0.00 190.17
100-5-05110-51-2160 LIFE INSURANCE 0.00 50.83
100-5-05110-51-2180 DENTAL, LIFE, AD&D INS-FACILI 0.00 8.00
100-5-05110-51-2200 TMRS 279.47 3,319.16
100-5-05110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 240.00
100-5-05110-51-2240 LONGEVITY PAY 0.00 478.70
100-5-05110-51-2520 MEDICARE TAXES 33.55 392.28
100-5-05110-51-2560 WORKER'S COMPENSATION 0.00 695.28
100-5-05110-52-1300 PROFESSIONAL SERVICES 0.00 1,570.00
100-5-05110-53-1100 GENERAL OFFICE SUPPLIES 234.05 623.01
100-5-05110-53-1300 MISCELLANEOUS SUPPLIES 0.00 186.09
100-5-05110-54-5400 GENERAL LIABILITY INSURANCE 0.00 163.76
100-5-05110-55-2100 EQUIPMENT MAINTENANCE 0.00 86.22
100-5-05110-55-3100 GROUNDSKEEPING 6,104.59 55,348.66
100-5-05110-55-3200 BUILDING MAINTENANCE 19,262.96 35,802.01
100-5-06110-52-1300 PROFESSIONAL SERVICES 2,055.90 17,175.84
100-5-06110-52-1600 BUILDING INSPECTIONS 1,788.12 205,638.54
100-5-06110-53-1300 MISCELLANEOUS SUPPLIES 0.00 6.78
100-5-06110-54-2400 MEALS & EXPENSES 0.00 23.66
100-5-09110-53-1300 COMPUTERS & SUPPLIES 0.00 27.00
100-5-09110-54-1100 PRINTING 0.00 65.50
100-5-09110-54-2100 SEMINARS & TRAINING 0.00 1,357.83
100-5-09110-54-2300 TRAVEL EXPENSE 0.00 1,412.87
100-5-09110-54-2400 MEALS & EXPENSES 123.89 1,666.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 702,128.68 125,262.69 3,881,747.18 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 1,197,941.30 1,197,941.30 6,643,225.86 6,643,225.86
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
205-POLICE FORFEITURE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
205-1-1102 CLAIM ON CASH 0.00 3,587.44
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 3,587.44 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
205-3-1100 FUND BALANCE 0.00 3,587.44
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 3,587.44
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 3,587.44 3,587.44
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
210-COURT TECHNOLOGY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
210-1-1102 CLAIM ON CASH 4.00 1,350.38
______________ ______________ ______________ ______________
TOTAL ASSETS 4.00 0.00 1,350.38 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
210-3-1100 FUND BALANCE 0.00 875.77
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 875.77
============== ============== ============== ==============
REVENUES
========
210-4-02110-34-7100 COURT TECHNOLOGY FEES 4.00 474.61
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 4.00 0.00 474.61
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 4.00 4.00 1,350.38 1,350.38
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
215-COURT SECURITY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
215-1-1102 CLAIM ON CASH 3.00 12,367.22
______________ ______________ ______________ ______________
TOTAL ASSETS 3.00 0.00 12,367.22 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
215-3-1100 FUND BALANCE 0.00 12,007.53
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 12,007.53
============== ============== ============== ==============
REVENUES
========
215-4-02110-34-7200 COURT SECURITY FEES 3.00 359.69
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 3.00 0.00 359.69
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 3.00 3.00 12,367.22 12,367.22
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
220-PARK DEDICATION FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
220-1-1102 CLAIM ON CASH 0.00 12,500.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 12,500.00 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
220-3-1100 FUND BALANCE 0.00 12,500.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 12,500.00
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 12,500.00 12,500.00
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
225-SPECIAL EVENTS FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
225-1-1102 CLAIM ON CASH 44,422.66 1,134.31
225-1-1105 ACCOUNTS RECEIVABLE 22,065.00 22,065.00
______________ ______________ ______________ ______________
TOTAL ASSETS 66,487.66 0.00 22,065.00 1,134.31
============== ============== ============== ==============
LIABILITIES
===========
225-2-2101 AP PENDING (DUE TO POOL CASH) 5,254.05 6,154.39
225-2-3300 DEFERRED REVENUE 22,065.00 22,065.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 27,319.05 0.00 28,219.39
============== ============== ============== ==============
FUND BALANCE
============
225-3-1100 FUND BALANCE 0.00 2,056.05
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 2,056.05 0.00
============== ============== ============== ==============
REVENUES
========
225-4-01110-60-1001 TRANSFER IN 50,000.00 50,000.00
225-4-01420-38-3000 TICKET SALES 600.00 46,356.92
225-4-01420-38-3100 SPONSORSHIPS - CRAFT & CORK 0.00 29,936.12
225-4-01420-38-3200 MERCHANDISE - CRAFT AND CORK 108.00 108.00
225-4-01520-38-3100 SPONSORSHIPS - BOOMIN 4TH 0.00 41,000.00
______________ ______________ ______________ ______________
TOTAL REVENUES 108.00 50,600.00 108.00 167,293.04
============== ============== ============== ==============
EXPENDITURES
============
225-5-01110-56-1300 OTHER OFFICE EQUIPMENT 0.00 2,539.17
225-5-01420-51-2550 INSURANCE 4,867.00 4,867.00
225-5-01420-53-1100 ADVERTISING 264.42 2,026.00
225-5-01420-53-1300 MISCELLANEOUS SUPPLIES 5,889.97 10,412.27
225-5-01420-54-1400 BANK CHARGES 0.00 40.00
225-5-01420-54-2110 COMMUNITY EVENTS 3,786.72 46,566.35
225-5-01420-54-2120 EVENT RENTALS - CRAFT AND COR 0.00 25,768.08
225-5-01520-52-1100 CONTRACT LABOR 3,284.72 3,975.00
225-5-01520-53-1100 ADVERTISING - BOOMIN 4TH 0.00 92.09
225-5-01520-53-1300 MISCELLANEOUS SUPPLIES 0.00 4,035.67
225-5-01520-54-2110 COMMUNITY EVENTS - BOOMIN 4TH 200.00 59,749.11
225-5-01620-54-2110 COMMUNITY EVENTS - XMAS CORR 0.00 12,346.95
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 14,808.11 3,484.72 172,417.69 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 81,403.77 81,403.77 196,646.74 196,646.74
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
230-PID #1
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
230-1-1100 CASH - PID #1 0.84 543.60
230-1-1105 ACCOUNTS RECEIVABLE 0.00 21,597.67
______________ ______________ ______________ ______________
TOTAL ASSETS 0.84 0.00 22,141.27 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
230-3-1100 FUND BALANCE 0.00 78,551.78
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 78,551.78
============== ============== ============== ==============
REVENUES
========
230-4-01420-31-2001 PID #1 ASSESSMENT 0.00 32,744.34
230-4-04110-36-1100 INTEREST REVENUE 0.84 845.15
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.84 0.00 33,589.49
============== ============== ============== ==============
EXPENDITURES
============
230-5-04110-60-1001 TRANSFER OUT 0.00 90,000.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 90,000.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.84 0.84 112,141.27 112,141.27
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
310-UTILITY CAPITAL PROJECTS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
310-1-1100 UTILITY CAP PROJECTS CASH 0.01 0.50
310-1-1101 UTILITY DEBT SERVICE CASH 37.95 24,565.39
310-1-1112 PCUD REGIONAL BUY-IN COSTS 0.00 787,885.71
310-1-1113 LAND 0.00 559,867.44
310-1-1114 WATER PLANT 208,977.50 4,333,489.13
310-1-1115 WATER DISTRIBUTION 0.00 5,152,368.68
310-1-1116 EQUIPMENT 0.00 158,537.27
310-1-1117 OFFICE EQUIPMENT 0.00 2,224.46
310-1-1118 AUTOMOBILES 0.00 122,692.45
310-1-1119 CONSTRUCTION IN PROGRESS 193,640.00 24,334.00
310-1-1120 SEWER SYSTEM 0.00 3,833,533.35
310-1-1121 ACCUMULATED DEPRECIATION 481,296.35 5,962,001.20
310-1-1123 BUILDINGS 0.00 46,412.97
310-1-1220 DUE FROM OTHER FUNDS 0.00 2,799.50
______________ ______________ ______________ ______________
TOTAL ASSETS 209,015.46 674,936.35 15,048,710.85 5,962,001.20
============== ============== ============== ==============
LIABILITIES
===========
310-2-2000 ACCOUNTS PAYABLE 15,337.50 15,337.50
310-2-2006 ACCRUED INTEREST PAYABLE 2,337.61 26,837.50
310-2-2100 DUE TO OTHER FUNDS 549.20 549.20
310-2-5051 GENERAL OBLIGATION UTIL 2010 0.00 1,330,000.00
310-2-5053 CERT OF OBLIGATION UTIL DEBT 0.00 260,000.00
310-2-5054 CERT OF OBLI UTIL PREMIUM 5,303.76 46,394.43
310-2-5073 CERT OF OBLIGATION UTIL DYEGAR 0.00 2,185,000.00
310-2-5074 CERT OF OBLIG DYE UTIL PREMIUM 3,262.47 52,199.62
310-2-5103 CERT OF OBLIGATION UTIL SEWER 155,000.00 875,000.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 165,903.84 15,886.70 0.00 4,791,318.25
============== ============== ============== ==============
FUND BALANCE
============
310-3-1100 FUND BALANCE 0.00 4,339,155.88
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 4,339,155.88
============== ============== ============== ==============
REVENUES
========
310-4-04110-60-1001 TRANSFER IN 0.00 597,000.00
310-4-07000-36-1100 INTEREST REVENUE 166,110.46 4,724.18
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 166,110.46 0.00 601,724.18
============== ============== ============== ==============
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
310-UTILITY CAPITAL PROJECTS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
EXPENDITURES
============
310-5-04110-58-1200 AMORTIZATION EXPENSE 28,548.30 28,548.30
310-5-04110-60-1001 TRANSFER OUT-GENERAL FUND 0.00 2,405.88
310-5-04410-58-1100 DEPRECIATION EXPENSE 452,748.05 452,748.05
310-5-07000-60-2100 INTEREST - C.O. SERIES 2012 4,240.56 39,771.94
310-5-07001-60-2100 INTEREST - GEN OBLI 2010 41,279.53 11,720.47
310-5-07002-60-2100 INTEREST - 2010 CERT OF OBLIG 35,720.86 88,720.86
310-5-07003-60-2100 INTEREST - 2014 CERT OF OBLIG 10,517.09 21,573.16
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 527,534.30 45,520.09 645,488.66 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 902,453.60 902,453.60 15,694,199.51 15,694,199.51
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
311-GENERAL CAPITAL PROJECTS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
311-1-1100 GENERAL CAP CASH ACCOUNT 55,708.46 221,601.20
311-1-1112 DUE FROM OTHER FUNDS 37,056.44 0.00
311-1-1202 TEXSTAR - CAPITAL PROJ RESERVE 26.36 15,240.62
______________ ______________ ______________ ______________
TOTAL ASSETS 55,734.82 37,056.44 236,841.82 0.00
============== ============== ============== ==============
LIABILITIES
===========
311-2-2000 ACCOUNTS PAYABLE 0.00 211,635.91
311-2-2100 DUE TO OTHER FUNDS 0.00 24,242.68
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 0.00 235,878.59
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
311-4-01420-38-1100 MISCELLANEOUS REVENUES 0.00 56,136.49
311-4-04110-36-1100 INTEREST REVENUE 334.38 4,661.79
311-4-04110-60-1001 TRANSFER IN/GENERAL FUND 36,688.00 36,688.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 37,022.38 0.00 97,486.28
============== ============== ============== ==============
EXPENDITURES
============
311-5-04110-60-1001 TRANSFER OUT/GENERAL FUND 0.00 2,521.93
311-5-04120-52-1300 PROFESSIONAL SERVICES 0.00 43,519.42
311-5-04120-54-2520 ENGINEERING - OAKEY 0.00 2,100.00
311-5-04120-54-2530 CONSTRUCTION - OAKEY 0.00 9,993.70
311-5-04130-54-2520 ENGINEERING - GREEN RIBBON 0.00 1,700.00
311-5-04150-54-2530 CONSTRUCTION - SIGNAGE & WAY 18,344.00 36,688.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 18,344.00 0.00 96,523.05 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 74,078.82 74,078.82 333,364.87 333,364.87
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
410-GENERAL DEBT SERVICE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
410-1-1100 CASH & CASH EQUIVALENTS 66,213.92 55,837.83
______________ ______________ ______________ ______________
TOTAL ASSETS 66,213.92 0.00 55,837.83 0.00
============== ============== ============== ==============
LIABILITIES
===========
410-2-2006 ACCRUED INTEREST PAYABLE 9,524.72 0.00
410-2-2100 DUE TO OTHER FUNDS 0.00 3,199.50
______________ ______________ ______________ ______________
TOTAL LIABILITIES 9,524.72 0.00 0.00 3,199.50
============== ============== ============== ==============
FUND BALANCE
============
410-3-1100 FUND BALANCE 0.00 21,145.11
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 21,145.11
============== ============== ============== ==============
REVENUES
========
410-4-01110-60-1001 TRANSFER IN 0.00 858,121.93
410-4-07000-36-1100 INTEREST REVENUE 106.41 2,145.23
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 106.41 0.00 860,267.16
============== ============== ============== ==============
EXPENDITURES
============
410-5-07000-60-2100 DEBT SERVICE INTEREST 0.00 400.00
410-5-07001-60-1100 PRINCIPAL - 2007 CERT OF OBLIG 95,000.00 95,000.00
410-5-07001-60-2100 INTEREST - 2007 CERT OF OBLIG 20,807.51 41,502.26
410-5-07002-60-1100 PRINCIPAL - 2010 GO REFUNDING 0.00 60,000.00
410-5-07002-60-2100 INTEREST - 2010 GO REFUNDING 400.00 10,550.00
410-5-07003-60-1100 PRINCIPAL - 2012 CERT OF OBLI 0.00 45,000.00
410-5-07003-60-2100 INTEREST - 2012 CERT OF OBLIG 11,918.75 23,837.50
410-5-07004-60-1100 PRINCIPAL - 2016A CERT OF OBL 0.00 165,000.00
410-5-07004-60-2100 INTEREST - 2016A CERT OF OBLI 11,918.75 105,700.00
410-5-07005-60-1100 PRINCIPAL - 2016B CERT OF OBL 0.00 50,000.00
410-5-07005-60-2100 INTEREST - 2016B CERT OF OBLI 0.00 58,085.00
410-5-07006-60-1100 PRINCIPAL - 2018 CERT OF OBLI 0.00 45,000.00
410-5-07006-60-2100 INTEREST - 2018 CERT OF OBLIG 39,775.28 128,699.18
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 52,094.03 127,726.26 828,773.94 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 127,832.67 127,832.67 884,611.77 884,611.77
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
420-UTILITY DEBT SERVICE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
______________ ______________ ______________ ______________
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
505-WATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
505-1-1102 CLAIM ON CASH 61,923.80 1,008,607.63
505-1-1103 TEXPOOL - ENTERPRISE RESERVE 163.21 91,931.71
505-1-1108 EARNED BUT UNBILLED-WATER 47,377.13 120,129.53
505-1-1197 UNAPPLIED CREDITS 1,597.59 10,427.34
505-1-1198 ALLOWANCE FOR UNCOLLECTABLE 567.24 12,162.41
505-1-1199 ACCOUNTS RECEIVABLE - WATER 58,644.79 143,234.40
505-1-1201 PREPAID EXPENSES 6,694.75 8,469.75
505-1-1221 DUE FROM DEVELOPERS 0.00 14,198.99
505-1-1250 DUE FROM WILLOW PARK 449.99 2,950.00
505-1-1300 DEFERRED OUTFLOW OF RESOURCES 0.00 39,520.00
505-1-1301 DEFERRED OUTFLOWS - OPEB 0.00 735.00
505-1-1400 RECEIVABLE (CREDIT) FROM WEATH 10,785.00 10,785.00
______________ ______________ ______________ ______________
TOTAL ASSETS 128,541.48 59,662.02 1,440,562.01 22,589.75
============== ============== ============== ==============
LIABILITIES
===========
505-2-2000 ACCOUNTS PAYABLE-AUDIT ACCRUAL 67.74 11,188.21
505-2-2005 COMPENSATED ABSENCES PAYABLE 8,944.90 22,720.18
505-2-2011 RETIREMENT (TMRS PAYABLE) 74.13 392.02
505-2-2012 HEALTH INSURANCE PAYABLE 42.86 360.25
505-2-2013 FLEX ACCOUNT PAYABLE 0.00 805.10
505-2-2015 DEFERRED COMP PAYABLE 2.00 12.00
505-2-2020 UNITED WAY PAYABLE 5.29 7.69
505-2-2024 ACCRUED PAYROLL 783.36 4,193.23
505-2-2025 LEADERS LIFE PAYABLE 1.15 18.39
505-2-2028 IMPACT FEES PAYABLE 16,523.00 0.00
505-2-2040 RENTER DEPOSITS 1,000.00 9,500.00
505-2-2101 AP PENDING (DUE TO POOL CASH) 108,876.23 34,544.00
505-2-2108 DUE TO WEATHERFORD 0.00 294,663.02
505-2-2200 DEFERRED INFLOWS OF RESOURCES 0.00 89,487.00
505-2-2300 NET PENSION LIABILITY 0.00 87,827.00
505-2-2301 OPEB LIABILITY 0.00 10,142.00
505-2-4100 FEDERAL WITHHOLDING 147.47 556.44
505-2-4200 MEDICARE PAYABLE 14.75 77.33
______________ ______________ ______________ ______________
TOTAL LIABILITIES 136,406.70 76.18 0.00 566,493.86
============== ============== ============== ==============
FUND BALANCE
============
505-3-1100 FUND BALANCE 0.00 302,099.91
505-3-1101 FUND BALANCE RESTRICTED-IMPACT 0.00 194,661.11
505-3-1120 PRIOR PERIOD ADJUSTMENT 0.00 8,466.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 8,466.00 496,761.02
============== ============== ============== ==============
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
505-WATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
REVENUES
========
505-4-04110-34-9100 RETURNED CHECK FEE 0.00 60.00
505-4-04110-36-1120 INTEREST REVENUE 163.21 2,101.09
505-4-04110-60-1001 TRANSFER IN/DEBT SERVICE 0.00 2,405.88
505-4-04410-34-4100 WATER SALES 234,485.31 1,485,471.72
505-4-04410-34-4110 UTGCD-HUDSON OAKS 5,060.88 33,211.36
505-4-04410-34-4200 SERVICE CHARGES 80.00 1,370.00
505-4-04410-34-4300 RECONNECT FEES 0.00 1,040.00
505-4-04410-34-4400 LATE PAYMENT PENALTIES 1,238.92 11,232.43
505-4-04410-34-4500 WATER IMPACT FEES 3,275.02 12,929.34
505-4-04410-34-4600 WATER TAP FEES 1,500.00 12,500.00
505-4-04410-34-4700 METER FEES 0.00 10,113.75
505-4-04410-34-4800 WIRELESS METER FEE 891.00 3,791.25
505-4-04420-38-1100 MISCELLANEOUS REVENUE 0.00 580.50
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 246,694.34 0.00 1,576,807.32
============== ============== ============== ==============
EXPENDITURES
============
505-5-04110-51-1100 REGULAR PAY 8,216.90 306,638.91
505-5-04110-51-1300 OVERTIME PAY-P.W. DEPT 814.67 14,255.09
505-5-04110-51-2100 MEDICAL INSURANCE-P.W. DEPT 952.86 17,484.16
505-5-04110-51-2120 DENTAL INSURANCE 118.48 2,162.36
505-5-04110-51-2160 LIFE INSURANCE 31.50 577.04
505-5-04110-51-2180 AD&D INSURANCE 4.96 90.88
505-5-04110-51-2200 TMRS-P.W. DEPT 2,299.47 40,677.48
505-5-04110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 1,960.00
505-5-04110-51-2520 MEDICARE TAXES 263.14 4,592.05
505-5-04110-51-2560 WORKERS COMPENSATION 0.00 7,091.80
505-5-04110-52-1100 CONTRACT LABOR 0.00 275.00
505-5-04110-52-1200 AUDITING & ACCOUNTING 0.00 7,167.00
505-5-04110-52-1300 PROFESSIONAL SERVICES 31,664.99 70,083.75
505-5-04110-52-1500 EQUIPMENT RENTAL 398.52 398.52
505-5-04110-52-1660 WELL TANK INSPECTIONS 0.00 500.00
505-5-04110-52-1700 WATER SAMPLING 40.00 5,389.88
505-5-04110-53-1100 GENERAL OFFICE SUPPLIES 32.24 712.28
505-5-04110-53-1300 MISCELLANEOUS EXPENSE 39.98 1,286.11
505-5-04110-53-1500 UNIFORMS 595.67 5,333.64
505-5-04110-53-1700 WATER SYSTEM SUPPLIES 46.03 34,710.61
505-5-04110-53-2100 CHEMICALS 368.26 8,580.66
505-5-04110-53-2200 METERS & COUPLINGS 8,579.00 37,669.94
505-5-04110-54-1100 PRINTING 828.10 7,699.24
505-5-04110-54-1200 POSTAGE 380.76 3,474.77
505-5-04110-54-1400 BANK CHARGES 3,428.44 12,583.49
505-5-04110-54-2100 SEMINARS & TRAINING 50.00 511.00
505-5-04110-54-2400 MEALS & EXPENSES 0.00 604.71
505-5-04110-54-3100 DUES & SUBSCRIPTIONS 0.00 613.00
505-5-04110-54-4100 TELEPHONE 639.96 8,488.97
505-5-04110-54-4200 ELECTRIC UTILITIES 128.51 1,228.30
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
505-WATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
505-5-04110-54-4210 WATER UTILITIES 41,015.06 0.00
505-5-04110-54-4220 WELL SITE UTILITIES 12,520.26 106,224.44
505-5-04110-54-5100 SOFTWARE MAINTENANCE 588.56 24,863.56
505-5-04110-54-5400 GENERAL LIABILITY INSURANCE 0.00 6,588.12
505-5-04110-55-1100 VEHICLE MAINTENANCE 24.90 5,272.78
505-5-04110-55-1200 GAS & OIL 1,227.32 10,227.12
505-5-04110-55-2100 EQUIPMENT MAINTENANCE 319.90 959.50
505-5-04110-55-3200 BUILDINGS 275.00 550.00
505-5-04110-55-4100 WATER PLANT MAINTENANCE 0.00 7,947.43
505-5-04110-55-4200 WATER DISTRIBUTION REPAIR 0.00 1,800.00
505-5-04110-55-4300 WATER WELL REPAIR 0.00 750.00
505-5-04110-56-2200 VEHICLES 19.00 0.00
505-5-04110-60-1001 TRANSFER OUT/DEBT SERVICE 0.00 226,200.00
505-5-04410-54-3200 UTGCD EXPENSE 67.74 29,168.78
505-5-04410-54-3300 REGIONAL WATER PURCHASES 8,749.42 181,753.33
505-5-04410-54-3310 REGIONAL DEMAND FEES 0.00 8,478.24
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 83,106.98 41,622.62 1,213,623.94 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 348,055.16 348,055.16 2,662,651.95 2,662,651.95
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
506-DEERCREEK FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
506-1-1102 CLAIM ON CASH 55,499.24 116,036.96
506-1-1112 DUE FROM OTHER FUNDS 549.20 549.20
506-1-1240 DUE FROM ANNETTA 1,442.93 56,822.20
506-1-1300 DEFERRED OUTFLOW OF RESOURCES 0.00 9,464.00
506-1-1301 DEFERRED OUTFLOWS - OPEB 0.00 173.00
______________ ______________ ______________ ______________
TOTAL ASSETS 1,992.13 55,499.24 183,045.36 0.00
============== ============== ============== ==============
LIABILITIES
===========
506-2-2005 COMPENSATED ABSENCES PAYABLE 1,000.37 6,089.38
506-2-2006 ACCRUED INTEREST PAYABLE 365.25 365.25
506-2-2011 RETIREMENT (TMRS PAYABLE) 22.98 140.74
506-2-2012 HEALTH INSURANCE PAYABLE-DC 0.88 22.58
506-2-2020 UNITED WAY PAYABLE - DEERCREEK 12.50 0.00
506-2-2024 ACCRUED PAYROLL-DEER CREEK 198.35 1,580.65
506-2-2101 AP PENDING (DUE TO POOL CASH) 1,264.65 5,760.22
506-2-2108 DUE TO WEATHERFORD 12.50 0.00
506-2-2200 DEFERRED INFLOWS 0.00 21,109.00
506-2-2300 NET PENSION LIABILITY 0.00 20,718.00
506-2-2301 OPEB LIABILITY 0.00 2,392.00
506-2-4100 FEDERAL WITHHOLDING 126.26 237.52
506-2-4200 MEDICARE PAYABLE 4.80 29.11
506-2-5150 AUTOMOBILE LEASES 795.27 24,183.95
______________ ______________ ______________ ______________
TOTAL LIABILITIES 1,025.37 2,778.44 0.00 82,628.40
============== ============== ============== ==============
FUND BALANCE
============
506-3-1100 FUND BALANCE 0.00 81,406.05
506-3-1120 PRIOR PERIOD ADJUSTMENT 0.00 1,997.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 1,997.00 81,406.05
============== ============== ============== ==============
REVENUES
========
506-4-04410-34-5000 ANNETTA CONTRACT CHARGES 39,955.62 239,733.72
506-4-04410-34-5100 ANNETTA MONTHLY OPERATION 13,520.07 0.00
______________ ______________ ______________ ______________
TOTAL REVENUES 13,520.07 39,955.62 0.00 239,733.72
============== ============== ============== ==============
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
506-DEERCREEK FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
EXPENDITURES
============
506-5-04110-51-1100 REGULAR PAY-DEERCREEK 4,744.91 73,985.72
506-5-04110-51-1300 OVERTIME PAY-DEERCREEK 1,008.00 12,951.98
506-5-04110-51-2100 MEDICAL INSURANCE-ANNETTA 614.76 7,850.89
506-5-04110-51-2120 DENTAL INSURANCE 38.22 892.95
506-5-04110-51-2160 LIFE INSURANCE 10.16 238.76
506-5-04110-51-2180 AD&D INSURANCE 1.60 37.60
506-5-04110-51-2200 TMRS-ANNETTA 776.15 10,782.06
506-5-04110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 800.00
506-5-04110-51-2520 MEDICARE TAXES 92.99 1,266.38
506-5-04110-51-2560 WORKERS COMPENSATION 0.00 2,781.08
506-5-04110-52-1100 CONTRACT LABOR-DEER CREEK 1,590.92 0.00
506-5-04110-52-1300 PROFESSIONAL SERVICES 3,110.60 0.00
506-5-04110-52-1700 WATER SAMPLING-DC 60.00 660.00
506-5-04110-53-1300 MISC SUPPLIES-DEERCREEK 1,569.61 0.00
506-5-04110-53-1500 UNIFORMS-DEERCREEK 109.40 1,000.29
506-5-04110-53-1700 WATER SYSTEM SUPPLIES-DC 1,796.25 0.00
506-5-04110-53-2100 CHEMICALS-DEERCREEK 4,941.38 2,789.28
506-5-04110-53-2200 METERS & COUPLINGS 0.00 293.38
506-5-04110-54-2100 SEMINARS & TRAINING 0.00 1,549.25
506-5-04110-54-2300 TRAVEL EXPENSES - ANNETTA 0.00 1,909.80
506-5-04110-54-5400 GENERAL LIABILITY INSURANCE 0.00 1,104.12
506-5-04110-55-1100 VEHICLE MAINTENANCE 93.00 1,859.87
506-5-04110-55-1200 GAS & OIL-DEERCREEK 908.04 7,856.88
506-5-04110-55-4200 WASTEWATER PLANT MAINTENANCE 300.06 395.02
506-5-04110-55-4400 WATER WELL REPAIR 752.00 0.00
506-5-04110-60-1001 TRANSFER OUT 86,688.00 86,688.00
506-5-04110-60-1200 CAPITAL LEASES-PRINCIPAL (DC) 421.18 0.00
506-5-04110-60-2100 INTEREST EXPENSE 1,032.50 1,032.50
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 96,177.73 14,482.00 218,725.81 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 112,715.30 112,715.30 403,768.17 403,768.17
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
507-DYEGARD FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
507-1-1102 CLAIM ON CASH 32,224.11 63,652.16
507-1-1108 EARNED BUT UNBILLED-DYEGARD 5,941.08 19,227.09
507-1-1198 ALLOWANCE FOR UNCOLLECTABLE 0.00 1,687.84
507-1-1199 ACCOUNTS RECIEVABLE-DYE-WATER 5,441.65 22,993.78
______________ ______________ ______________ ______________
TOTAL ASSETS 38,165.19 5,441.65 105,873.03 1,687.84
============== ============== ============== ==============
LIABILITIES
===========
507-2-2101 AP PENDING (DUE TO POOL CASH) 2,500.91 162.87
______________ ______________ ______________ ______________
TOTAL LIABILITIES 2,500.91 0.00 0.00 162.87
============== ============== ============== ==============
FUND BALANCE
============
507-3-1100 FUND BALANCE 0.00 53,585.56
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 53,585.56
============== ============== ============== ==============
REVENUES
========
507-4-04410-34-4100 WATER SALES-DYEGARD 36,712.29 261,077.27
507-4-04410-34-4400 LATE PAYMENT PENALTIES-DYEGAR 0.00 1,649.35
507-4-04420-38-1100 MISCELLANEOUS REVENUE-DYEGARD 0.00 180.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 36,712.29 0.00 262,906.62
============== ============== ============== ==============
EXPENDITURES
============
507-5-04110-52-1300 PROFESSIONAL SERVICES-DYE 0.00 2,500.00
507-5-04110-52-1700 WATER SAMPLING-DYEGARD 20.00 220.00
507-5-04110-53-1700 WATER SYSTEM SUPPLIES-DYEGARD 0.00 504.95
507-5-04110-53-2100 CHEMICALS-DYEGARD 0.00 221.51
507-5-04110-54-1100 PRINTING-DYEGARD 142.87 1,453.92
507-5-04110-54-1200 POSTAGE-DYEGARD 87.34 604.09
507-5-04110-54-4220 WELL SITE UTILITIES-DYEGARD 387.63 2,094.99
507-5-04110-55-4100 WATER PLANT MAINTENANCE-DYEGA 0.00 10,820.40
507-5-04110-55-4200 WATER DISTRIBUTION REPAIR 850.00 850.00
507-5-04110-60-1001 TRANSFER OUT-DYEGARD DEBT 0.00 193,200.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 1,487.84 0.00 212,469.86 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 42,153.94 42,153.94 318,342.89 318,342.89
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
510-WASTEWATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
510-1-1102 CLAIM ON CASH 45,123.23 475,153.34
510-1-1109 EARNED BUT UNBILLED-WASTEWATER 351.88 22,364.48
510-1-1190 A/R - ASSESSMENTS 6,055.05 186,797.89
510-1-1198 ALLOWANCE FOR UNCOLLECTABLE 89.82 4,196.84
510-1-1199 ACCOUNTS RECEIVABLE - SEWER 22,771.27 20,298.31
510-1-1202 TEXSTAR - WASTEWATER RESERVE 716.07 414,363.79
______________ ______________ ______________ ______________
TOTAL ASSETS 46,191.18 28,916.14 1,118,977.81 4,196.84
============== ============== ============== ==============
LIABILITIES
===========
510-2-2000 ACCOUNTS PAYABLE-AUDIT ACCRUAL 23,934.78 23,934.78
510-2-2028 SEWER IMPACT FEES PAYABLE 12,248.00 0.00
510-2-2101 AP PENDING (DUE TO POOL CASH) 5,000.00 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 17,248.00 23,934.78 0.00 23,934.78
============== ============== ============== ==============
FUND BALANCE
============
510-3-1100 FUND BALANCE 0.00 1,036,100.98
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 1,036,100.98
============== ============== ============== ==============
REVENUES
========
510-4-04110-36-1120 INTEREST REVENUE 716.07 9,450.92
510-4-04510-34-5100 WASTEWATER CHARGES 33,898.22 401,671.53
510-4-04510-34-5600 WASTEWATER TAP FEE 0.00 4,500.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 34,614.29 0.00 415,622.45
============== ============== ============== ==============
EXPENDITURES
============
510-5-04110-52-1300 PROFESSIONAL SERVICES 0.00 5,000.00
510-5-04510-54-2100 WASTEWATER TREATMENT SERVICES 23,934.78 156,806.03
510-5-04510-54-2520 WASTEWATER ENGINEERING 0.00 18,486.76
510-5-04510-54-4200 ELECTRIC UTILITIES 91.25 855.65
510-5-04510-55-4202 SEWER MAINTENANCE 0.00 2,128.80
510-5-04510-60-1001 TRANSFER OUT/DEBT SERVICE 0.00 177,600.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 24,026.03 0.00 360,877.24 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 87,465.21 87,465.21 1,479,855.05 1,479,855.05
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
515-SOLID WASTE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
515-1-1102 CLAIM ON CASH 2,361.26 7,117.56
515-1-1198 ALLOWANCE FOR UNCOLLECTABLE 0.00 142.92
515-1-1199 ACCOUNTS RECEIVABLE - SW 1,071.94 11,529.87
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 3,433.20 18,790.35 0.00
============== ============== ============== ==============
LIABILITIES
===========
515-2-2013 SOLID WASTE PAYABLE 3,248.71 6,170.49
515-2-2014 SALES TAX PAYABLE - SW 3.77 1,249.74
515-2-2101 AP PENDING (DUE TO POOL CASH) 180.72 11,370.12
______________ ______________ ______________ ______________
TOTAL LIABILITIES 3,433.20 0.00 0.00 18,790.35
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 3,433.20 3,433.20 18,790.35 18,790.35
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
520-STORMWATER UTILITY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
520-1-1101 STORMWATER DEBT SERVICE 26.77 17,323.85
520-1-1102 CLAIM ON CASH 88,525.47 4,283.51
520-1-1108 EARNED BUT UNBILLED-STORMWATER 76.71 9,411.05
520-1-1112 DUE FROM OTHER FUNDS 0.00 24,242.68
520-1-1119 CONSTRUCTION IN PROGRESS 0.00 546,547.32
520-1-1198 ALLOWANCE FOR UNCOLLECTIBLE 377.75 1,147.20
520-1-1199 ACCOUNTS RECEIVABLE 5,303.82 7,717.84
______________ ______________ ______________ ______________
TOTAL ASSETS 103.48 94,207.04 609,526.25 1,147.20
============== ============== ============== ==============
LIABILITIES
===========
520-2-2006 ACCRUED INTEREST PAYABLE 0.00 2,204.17
520-2-2030 SERIES 2016 A BONDS 0.00 485,000.00
520-2-2031 SERIES 2016 A PREMIUM 1,039.50 17,411.62
520-2-2101 AP PENDING (DUE TO POOL CASH) 416.86 416.86
______________ ______________ ______________ ______________
TOTAL LIABILITIES 1,039.50 416.86 0.00 505,032.65
============== ============== ============== ==============
FUND BALANCE
============
520-3-1100 FUND BALANCE 0.00 91,380.38
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 91,380.38
============== ============== ============== ==============
REVENUES
========
520-4-04110-34-6000 STORMWATER FEE 13,843.63 169,583.90
520-4-07000-36-1100 INTEREST REVENUE 26.77 290.44
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 13,870.40 0.00 169,874.34
============== ============== ============== ==============
EXPENDITURES
============
520-5-04110-52-1300 PROFESSIONAL SERVICES 9,137.00 9,137.00
520-5-04110-54-2510 DRAINAGE STUDY - BOR GRANT 9,137.00 0.00
520-5-04110-55-4500 DRAINAGE SYSTEM REPAIRS 8,390.82 8,390.82
520-5-04110-56-4300 STREET REPAIRS 100,000.00 127,370.00
520-5-04110-60-2200 DEBT SERVICE - INTEREST 1,039.50 13,010.50
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 117,527.82 10,176.50 157,908.32 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 118,670.80 118,670.80 767,434.57 767,434.57
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
710-INTERNAL SERVICE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
710-1-1100 CASH & CASH EQUIVALENTS 19.81 12,825.00
______________ ______________ ______________ ______________
TOTAL ASSETS 19.81 0.00 12,825.00 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
710-3-1100 FUND BALANCE 0.00 21,704.79
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 21,704.79
============== ============== ============== ==============
REVENUES
========
710-4-01110-34-3000 HEALTH CHARGES 0.00 9,200.00
710-4-01110-34-3100 HEALTH CARD FORFEITURES 0.00 1,078.41
710-4-01110-36-1100 INTEREST REVENUE 19.81 343.15
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 19.81 0.00 10,621.56
============== ============== ============== ==============
EXPENDITURES
============
710-5-01110-51-2230 INSURANCE REIMBURSEMENTS 0.00 19,501.35
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 19,501.35 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 19.81 19.81 32,326.35 32,326.35
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
800-GENERAL FIXED ASSETS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
800-1-1200 LAND 0.00 779,032.28
800-1-1300 BUILDINGS 0.00 2,566,374.56
800-1-1400 AUTOMOBILES 0.00 212,008.98
800-1-1500 BUILDING IMPROVEMENTS 0.00 267,429.69
800-1-1600 EQUIPMENT 0.00 410,908.19
800-1-1700 OFFICE EQUIPMENT 0.00 22,373.11
800-1-1800 INFRASTRUCTURE 0.00 6,572,992.49
800-1-1900 FURNITURES & FIXTURES 0.00 5,511.05
800-1-1950 CONSTRUCTION IN PROGRESS 44,124.11 8,749,322.39
800-1-2000 ACCUMULATED DEPRECIATION 399,986.71 3,960,481.48
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 444,110.82 19,585,952.74 3,960,481.48
============== ============== ============== ==============
LIABILITIES
===========
800-2-2000 INVESTMENT IN CAPITAL ASSETS 44,124.11 16,894,480.77
______________ ______________ ______________ ______________
TOTAL LIABILITIES 44,124.11 0.00 0.00 16,894,480.77
============== ============== ============== ==============
FUND BALANCE
============
800-3-1100 FUND BALANCE 0.00 869,022.80
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 869,022.80 0.00
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
800-5-01110-51-2100 DEPRECIATION EXPENSE 135,319.15 135,319.15
800-5-03110-51-2100 DEPRECIATION EXPENSE 87,883.10 87,883.10
800-5-04110-51-2100 DEPRECIATION EXPENSE 176,784.46 176,784.46
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 399,986.71 0.00 399,986.71 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 444,110.82 444,110.82 20,854,962.25 20,854,962.25
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
900-GENERAL LONG-TERM DEBT
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
900-1-1197 AMTS PROVIDED FOR LTD 477,405.40 9,650,226.36
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 477,405.40 9,650,226.36 0.00
============== ============== ============== ==============
LIABILITIES
===========
900-2-2100 2007 CERTIFICATES OF OBLIG 95,000.00 920,000.00
900-2-2110 2010 GO REFUNDING BONDS 60,000.00 180,000.00
900-2-2111 2010 GO PREMIUM ON BOND 0.00 7,058.14
900-2-2120 2012 CERT OF OBLIG GF PORTION 45,000.00 725,000.00
900-2-2121 2012 CO PREMIUM ON BOND 0.00 17,730.91
900-2-2130 CO SERIES 2016 A 165,000.00 3,740,000.00
900-2-2131 CO SERIES 2016 A PREMIUM 0.00 140,908.42
900-2-2140 CO SERIES 2016 B BONDS 50,000.00 1,405,000.00
900-2-2141 CO SERIES 2016 B PREMIUM 0.00 62,502.90
900-2-2150 2018 CERT OF OBLIGATION PID 40,000.00 1,940,000.00
900-2-2151 2018 PID PREMIUM 0.00 96,164.25
900-2-2160 2018 CERT OF OBLIGATION FIBER 5,000.00 340,000.00
900-2-2161 2018 ADDITION FIBER PREMIUM 0.00 16,971.09
900-2-2300 VEHICLE LEASES 11,875.72 42,305.35
900-2-2400 EQUIPMENT LEASES 5,529.68 16,585.30
______________ ______________ ______________ ______________
TOTAL LIABILITIES 477,405.40 0.00 0.00 9,650,226.36
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 477,405.40 477,405.40 9,650,226.36 9,650,226.36
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2019 10:17 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2019
999-POOL CASH
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
999-1-1099 POOL CASH 283,116.61 1,962,205.53
999-1-1100 DUE FROM GENERAL FUND 255,020.53 350,257.16
999-1-1225 DUE FROM SPECIAL EVENTS 5,254.05 6,154.39
999-1-1505 DUE FROM WATER FUND 108,876.23 34,544.00
999-1-1506 DUE FROM DEERCREEK 1,264.65 5,760.22
999-1-1507 DUE FROM DYEGARD 2,500.91 162.87
999-1-1510 DUE FROM WASTEWATER FUND 5,000.00 0.00
999-1-1515 DUE FROM SOLID WASTE FUND 180.72 11,370.12
999-1-1520 DUE FROM STORMWATER UTILITY 416.86 416.86
______________ ______________ ______________ ______________
TOTAL ASSETS 545,072.70 116,557.86 2,370,871.15 0.00
============== ============== ============== ==============
LIABILITIES
===========
999-2-2000 ACCOUNTS PAYABLE 145,398.23 408,665.62
999-2-2100 DUE TO OTHER FUNDS 283,116.61 1,962,205.53
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 428,514.84 0.00 2,370,871.15
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 545,072.70 545,072.70 2,370,871.15 2,370,871.15
============== ============== ============== ==============
*** END OF REPORT ***