2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
100-1-1102 CLAIM ON CASH 130,771.56 156,847.12
100-1-1106 CASH ON HAND 0.00 200.00
100-1-1107 FRANCHISE TAX RECEIVABLE 1,442.49 89,420.44
100-1-1108 SALES TAX RECEIVABLE 55,621.35 571,804.88
100-1-1112 DUE FROM OTHER FUNDS 58,290.76 68,087.76
100-1-1113 POOLED CASH CD 1,007.26 226,277.23
100-1-1190 COURT FINES RECEIVABLE 15,281.01 186,859.78
100-1-1191 ALLOWANCE FOR UNCOLLECTABLE-CT 9,525.68 149,487.82
100-1-1192 A/R - ASSESSMENTS 115,009.84 643,899.67
100-1-1196 MISC RECIEVABLES 601.05 0.00
100-1-1200 TEXPOOL - GENERAL RESERVE 12.54 103,977.26
100-1-1201 PREPAID EXPENSES 3,207.61 25,721.00
100-1-1202 TEXSTAR - GENERAL RESERVE 114.08 1,036,355.08
100-1-1234 DUE FROM NEXTLINK 16,239.64 0.00
100-1-1300 PROPERTY INVESTMENTS 0.00 148,789.60
100-1-5200 TEXPOOL - SALES TAX RESERVE 20.38 168,105.75
______________ ______________ ______________ ______________
TOTAL ASSETS 145,481.79 261,663.46 3,426,345.57 149,487.82
============== ============== ============== ==============
LIABILITIES
===========
100-2-2000 ACCOUNTS PAYABLE CONTROL 9,092.02 8,407.92
100-2-2001 ACCOUNTS PAYABLE - 1999 212,248.16 438,680.10
100-2-2011 RETIREMENT (TMRS PAYABLE) 754.26 2,738.77
100-2-2012 HEALTH INSURANCE PAYABLE 628.58 2,799.29
100-2-2013 FLEX ACCOUNT PAYABLE 100.40 0.00
100-2-2014 CHILD SUPPORT PAYABLE 36.92 147.69
100-2-2015 DEFERRED COMP PAYABLE 45.45 111.08
100-2-2016 DENTAL/VISION PAYABLE 474.54 0.00
100-2-2018 DUE TO SPLASH KINGDOM 2,047.15 0.00
100-2-2020 UNITED WAY PAYABLE 18.92 38.00
100-2-2021 ACCRUED PAYROLL-GEN FUND 11,173.08 32,160.83
100-2-2023 DUE TO OMNIBASE 97.28 0.00
100-2-2025 LEADERS LIFE PAYABLE 13.80 13.78
100-2-2101 AP PENDING (DUE TO POOL CASH) 51,306.13 79,992.61
100-2-2102 DUE TO STATE-COURT COSTS 243.42 1,201.49
100-2-2103 DUE TO OTHER FUNDS 50,000.00 50,000.00
100-2-2107 DUE TO POLICE OFFICE ASSOC 14.00 56.00
100-2-3300 DEFERRED REVENUE 26,197.50 416,180.75
100-2-3301 DEFERRED ASSESSMENTS REVENUE 115,009.84 643,899.67
100-2-4100 FEDERAL WITHHOLDING 713.34 1,747.66
100-2-4200 MEDICARE PAYABLE 251.31 633.88
______________ ______________ ______________ ______________
TOTAL LIABILITIES 127,736.84 352,729.26 0.00 1,678,809.52
============== ============== ============== ==============
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
FUND BALANCE
============
100-3-1100 FUND BALANCE 5,002.86 1,351,252.47
100-3-1103 RESTRICTED FUND BALANCE-PEG 0.00 9,972.34
100-3-1104 NONSPENDABLE FUND BALANCE 4,764.86 25,721.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 4,764.86 5,002.86 0.00 1,386,945.81
============== ============== ============== ==============
REVENUES
========
100-4-01110-60-1001 TRANSFER IN 0.00 60,000.00
100-4-01420-31-1100 LOCAL SALES & USE TAX 298,754.47 2,841,336.34
100-4-01420-31-1101 ECON DEV SALES TAX 0.00 468,388.00
100-4-01420-31-1120 MIXED BEVERAGES TAX 0.00 12,691.49
100-4-01420-31-2000 PAYMENT IN LIEU OF TAXES 0.00 25,161.01
100-4-01420-31-2100 FRANCHISE FEES 1,951.79 184,245.41
100-4-01420-31-2200 IN-KIND PEG FEES 0.00 7.26
100-4-01420-32-3100 ALCOHOLIC BEVERAGE PERMITS 425.00 787.50
100-4-01420-33-2130 CORONAVIRUS RELIEF MONEY 0.00 25,201.00
100-4-01420-34-2100 PRINTING & DUPLICATION FEE 0.00 1.00
100-4-01420-36-1100 INTEREST REVENUE 1,154.26 30,365.75
100-4-01420-38-1100 MISCELLANEOUS REVENUE 81,983.46 118,054.34
100-4-01420-38-1200 CREDIT CARD REVENUE-MISC (FEE) 70.22 1,442.29
100-4-01420-38-2000 ROADWAY ASSESSMENTS 38,714.63 115,009.84
100-4-01420-39-4120 T-MOBILE GROUND LEASE 1,996.50 21,304.34
100-4-02110-35-1100 TRAFFIC FINES 403.70 10,036.95
100-4-02110-35-1200 ARREST FEES 10.00 267.83
100-4-02110-35-1300 COURT ADMINISTRATIVE FEES 0.00 47.40
100-4-02110-35-1400 WARRANT FEES 115.40 1,219.62
100-4-02110-35-1500 COURT SPECIAL EXPENSE FEE 0.00 200.00
100-4-02110-35-1600 TFC FEES 0.00 81.00
100-4-02110-35-1700 JFCI REVENUE 0.77 28.37
100-4-02110-35-1710 CIVIL JUSTICE FEE-COURT 0.00 0.12
100-4-02110-35-1900 CREDIT CARD REVENUE-COURT 6.27 366.03
100-4-03110-34-2201 MISCELLANEOUS REVENUE-POLICE 0.00 2,586.31
100-4-03410-33-4100 TCLEOSE EDUCATION ALLOWANCE 0.00 1,240.77
100-4-03410-33-4102 ESD#3 BUILDING LEASE 3,967.40 25,730.32
100-4-06110-32-3200 BUILDING PERMITS 26,384.85 272,477.57
100-4-06110-32-3300 OCCUPANCY PERMITS 300.00 2,000.00
100-4-06110-32-3400 SIGN PERMITS 207.75 4,880.25
100-4-06110-32-3420 BILLBOARD PERMITS 50.00 150.00
100-4-06210-34-1100 PLAT FEES 0.00 500.00
100-4-06210-34-1110 DEVELOPMENT REVIEW FEES 0.00 625.00
100-4-06210-34-1120 REPLAT FEES 0.00 250.00
100-4-06210-34-1140 ZONING FEES 0.00 1,000.00
100-4-06310-32-3500 WELL PERMITS 0.00 250.00
100-4-06310-32-3600 SEPTIC PERMITS 0.00 1,640.00
100-4-06310-32-3700 HEALTH PERMITS 700.00 14,215.00
100-4-08000-61-1200 CAPITAL LEASE PROCEEDS 50,606.00 50,606.00
100-4-08000-61-2140 INSURANCE PROCEEDS 0.00 68,529.18
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 507,802.47 0.00 4,362,923.29
============== ============== ============== ==============
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
EXPENDITURES
============
100-5-01110-51-1100 REGULAR PAY 29,941.57 298,859.56
100-5-01110-51-2100 MEDICAL INSURANCE 1,084.08 15,342.97
100-5-01110-51-2120 DENTAL INSURANCE 133.80 1,347.45
100-5-01110-51-2160 LIFE INSURANCE 15.24 251.46
100-5-01110-51-2180 AD&D INSURANCE 1.60 25.60
100-5-01110-51-2200 TMRS 2,676.21 36,492.48
100-5-01110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 3,000.00
100-5-01110-51-2520 MEDICARE TAXES 364.34 4,441.07
100-5-01110-51-2540 UNEMPLOYMENT INSURANCE 0.00 1,172.93
100-5-01110-51-2560 WORKER'S COMPENSATION 0.00 5,306.88
100-5-01110-52-1200 AUDITING & ACCOUNTING 0.00 2,374.00
100-5-01110-52-1300 PROFESSIONAL SERVICES 29,170.50 107,039.33
100-5-01110-52-1400 LEGAL FEES 3,807.52 35,306.66
100-5-01110-52-1620 HEALTH INSPECTIONS 0.00 4,050.00
100-5-01110-53-1100 GENERAL OFFICE SUPPLIES 351.55 5,378.40
100-5-01110-53-1200 COMPUTER SUPPLIES 50.88 2,695.63
100-5-01110-53-1300 MISCELLANEOUS SUPPLIES 114.75 3,602.83
100-5-01110-53-1301 MISCELLANEOUS EXPENSE 3,383.67 6,164.96
100-5-01110-54-1100 PRINTING 117.84 552.24
100-5-01110-54-1200 POSTAGE 441.99 2,438.77
100-5-01110-54-1400 BANK FEES 3.00 1,075.61
100-5-01110-54-2100 SEMINARS & TRAINING 0.00 4,269.03
100-5-01110-54-2110 COMMUNITY EVENTS 799.99 7,048.94
100-5-01110-54-2300 TRAVEL EXPENSE 581.16 0.00
100-5-01110-54-2400 MEALS & EXPENSES 341.75 3,154.24
100-5-01110-54-3100 DUES & SUBSCRIPTIONS 1,745.00 14,307.76
100-5-01110-54-4100 TELEPHONE 888.19 11,242.53
100-5-01110-54-4200 ELECTRIC UTILITIES 174.91 8,541.12
100-5-01110-54-5000 ECON DEV AGREEMENTS 253,680.10 359,786.71
100-5-01110-54-5100 SOFTWARE MAINTENANCE 15,397.15 56,971.47
100-5-01110-54-5400 GENERAL LIABILITY INSURANCE 0.00 4,474.77
100-5-01110-56-1200 OFFICE MACHINES 149.79 3,390.27
100-5-01110-56-2300 CITY HALL BUILDING 0.00 1,082.50
100-5-01110-60-1001 TRANSFER OUT 1,656.10 54,000.00
100-5-01210-54-1300 ADVERTISING & LEGAL NOTICES 585.30 3,304.54
100-5-01210-54-1310 FILING FEES 0.00 824.70
100-5-02110-51-1100 REGULAR PAY 2,288.28 25,928.27
100-5-02110-51-2100 MEDICAL INSURANCE 122.96 1,598.48
100-5-02110-51-2120 DENTAL INSURANCE 15.28 198.64
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 265.01 3,159.50
100-5-02110-51-2520 MEDICARE TAXES 30.25 362.37
100-5-02110-51-2540 UNEMPLOYMENT INSURANCE 0.00 177.94
100-5-02110-51-2560 WORKER'S COMPENSATION 0.00 499.50
100-5-02110-52-1100 CONTRACT LABOR 1,540.00 1,540.00
100-5-02110-52-1300 PROFESSIONAL SERVICES 400.00 9,566.58
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 4
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
100-5-02110-53-1300 MISCELLANEOUS EXPENSE 0.00 37.99
100-5-02110-54-1200 POSTAGE 0.00 9.46
100-5-02110-54-2100 SEMINARS & TRAINING 0.00 200.00
100-5-02110-54-3100 DUES & SUBSCRIPTIONS 0.00 130.00
100-5-02110-54-5100 SOFTWARE MAINTENANCE 238.48 6,328.47
100-5-02110-54-5400 GENERAL LIABILITY INSURANCE 0.00 141.12
100-5-03110-51-1100 REGULAR PAY 73,230.86 801,107.47
100-5-03110-51-1300 OVERTIME PAY 5,652.70 73,277.30
100-5-03110-51-2100 MEDICAL INSURANCE 4,011.01 47,193.54
100-5-03110-51-2120 DENTAL INSURANCE 420.42 5,064.15
100-5-03110-51-2160 LIFE INSURANCE 111.76 1,346.20
100-5-03110-51-2180 AD&D INSURANCE 16.00 208.80
100-5-03110-51-2200 TMRS 8,672.10 105,890.63
100-5-03110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 6,000.00
100-5-03110-51-2520 MEDICARE TAXES 961.53 11,805.58
100-5-03110-51-2540 UNEMPLOYMENT INSURANCE 0.00 1,779.35
100-5-03110-51-2560 WORKER'S COMPENSATION 0.00 14,984.92
100-5-03110-52-1100 CONTRACT LABOR 58.19 33,880.75
100-5-03110-52-1200 AUDITING & ACCOUNTING 0.00 4,833.00
100-5-03110-52-1300 PROFESSIONAL SVCS - PUB SAFET 0.00 155.00
100-5-03110-53-1100 GENERAL OFFICE SUPPLIES 0.00 1,938.05
100-5-03110-53-1200 COMPUTER SUPPLIES 0.00 2,401.08
100-5-03110-53-1300 MISCELLANEOUS EXPENSE 0.00 1,745.68
100-5-03110-53-1400 AMMUNITION 179.94 1,400.03
100-5-03110-53-1500 UNIFORMS 0.00 15,755.55
100-5-03110-54-1100 PRINTING 130.35 924.64
100-5-03110-54-1200 POSTAGE 0.00 160.13
100-5-03110-54-2100 SEMINARS & TRAINING 939.40 5,087.39
100-5-03110-54-2110 COMMUNITY EVENTS - PUB SAFETY 0.00 55.25
100-5-03110-54-2300 TRAVEL EXPENSES 0.00 4.13
100-5-03110-54-3100 DUES & SUBSCRIPTIONS 0.00 1,049.00
100-5-03110-54-4100 TELEPHONE 1,036.09 12,473.13
100-5-03110-54-4200 ELECTRIC UTILITIES 311.42 11,732.32
100-5-03110-54-5100 SOFTWARE MAINTENANCE 2,096.74 54,880.69
100-5-03110-54-5300 PRE-EMPLOYMENT SCREENING 0.00 165.00
100-5-03110-54-5400 GENERAL LIABILITY INSURANCE 0.00 22,377.27
100-5-03110-54-6100 INMATE HOUSING 0.00 141.00
100-5-03110-54-6200 DISPATCHER 17,499.94 35,000.12
100-5-03110-55-1100 VEHICLE MAINTENANCE 1,802.78 11,239.15
100-5-03110-55-1200 GAS & OIL 1,353.96 19,522.45
100-5-03110-55-2100 EQUIPMENT MAINTENANCE 0.00 520.00
100-5-03110-55-2200 OFFICE EQUIPMENT MAINTENANCE 20.52 2,316.36
100-5-03110-56-2200 VEHICLES 73,129.82 90,242.95
100-5-03110-56-2300 PUBLIC SAFETY BUILDING 0.00 2,296.55
100-5-03110-60-1200 CAPITAL LEASE - PRINCIPAL 1,233.57 27,012.18
100-5-03110-60-2200 CAPITAL LEASE - INTEREST 1,991.59 2,773.45
100-5-04110-51-1100 REGULAR PAY 2,862.86 38,101.03
100-5-04110-51-1300 OVERTIME PAY 15.61 5,258.30
100-5-04110-51-2100 MEDICAL INSURANCE 316.99 6,125.56
100-5-04110-51-2120 DENTAL INSURANCE 19.12 372.71
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 5
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
100-5-04110-51-2160 LIFE INSURANCE 5.08 99.06
100-5-04110-51-2180 AD&D INSURANCE 0.80 15.60
100-5-04110-51-2200 TMRS 392.11 7,549.87
100-5-04110-51-2520 MEDICARE TAXES 46.04 894.11
100-5-04110-51-2540 UNEMPLOYMENT INSURANCE 0.00 88.97
100-5-04110-51-2560 WORKERS COMPENSATION 0.00 624.36
100-5-04110-53-1300 MISCELLANEOUS EXPENSE 0.00 15,240.52
100-5-04110-54-5400 GENERAL LIABILITY INSURANCE 0.00 2,548.97
100-5-04110-60-1001 TRANSFER OUT/I-20 OFF RAMP 0.00 766,800.00
100-5-04210-51-2521 FICA TAXES 327.52 1,802.06
100-5-04210-52-1300 PROFESSIONAL SERVICES 5,500.00 87,777.73
100-5-04210-54-4200 ELECTRIC UTILITIES 1,062.66 3,560.74
100-5-04210-56-4100 STREET SIGNS 0.00 3,463.35
100-5-04210-56-4200 STREET IMPROVEMENTS 218,309.41 219,633.17
100-5-04210-56-4300 STREET REPAIRS 1,559.00 33,233.95
100-5-05110-51-1100 REGULAR PAY 2,596.80 30,153.60
100-5-05110-51-1300 OVERTIME PAY 53.50 1,864.74
100-5-05110-51-2200 TMRS 287.44 3,883.34
100-5-05110-51-2520 MEDICARE TAXES 33.80 459.61
100-5-05110-51-2540 UNEMPLOYMENT INSURANCE 0.00 88.97
100-5-05110-51-2560 WORKER'S COMPENSATION 0.00 624.36
100-5-05110-52-1100 CONTRACT LABOR 0.00 2,800.00
100-5-05110-54-5400 GENERAL LIABILITY INSURANCE 0.00 176.40
100-5-05110-55-2100 EQUIPMENT MAINTENANCE 0.00 337.00
100-5-05110-55-3100 GROUNDSKEEPING 8,886.72 48,480.39
100-5-05110-55-3200 BUILDING MAINTENANCE 2,607.38 23,365.78
100-5-05110-56-3100 PROPERTY 0.00 34,032.95
100-5-06110-52-1300 PROFESSIONAL SERVICES 7,570.00 36,299.33
100-5-06110-52-1600 BUILDING INSPECTIONS 11,399.40 110,345.44
100-5-06110-54-1100 PRINTING 0.00 2,657.54
100-5-06110-54-2100 SEMINARS & TRAINING 37.88 37.88
100-5-06110-54-3100 DUES & SUBSCRIPTIONS 0.00 135.00
100-5-06110-54-5000 ECON DEV AGREEMENTS 79,212.50 104,212.50
100-5-09110-53-1300 COMPUTERS & SUPPLIES 0.00 1,896.57
100-5-09110-54-1200 POSTAGE 0.00 26.14
100-5-09110-54-2110 COMMUNITY EVENTS 0.00 556.82
100-5-09110-54-2300 TRAVEL EXPENSE 0.00 2,336.40
100-5-09110-54-2400 MEALS & EXPENSES 182.25 1,412.98
100-5-09110-54-3100 DUES & SUBSCRIPTIONS 0.00 2,450.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 869,961.53 20,746.97 4,151,820.87 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 1,147,945.02 1,147,945.02 7,578,166.44 7,578,166.44
============== ============== ============== ==============
*** END OF REPORT ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
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 ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
210-COURT TECHNOLOGY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
210-1-1102 CLAIM ON CASH 8.86 1,579.24
______________ ______________ ______________ ______________
TOTAL ASSETS 8.86 0.00 1,579.24 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
210-3-1100 FUND BALANCE 0.00 1,350.38
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 1,350.38
============== ============== ============== ==============
REVENUES
========
210-4-02110-34-7100 COURT TECHNOLOGY FEES 8.86 228.86
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 8.86 0.00 228.86
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 8.86 8.86 1,579.24 1,579.24
============== ============== ============== ==============
*** END OF REPORT ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
215-COURT SECURITY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
215-1-1102 CLAIM ON CASH 9.83 12,555.65
______________ ______________ ______________ ______________
TOTAL ASSETS 9.83 0.00 12,555.65 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
215-3-1100 FUND BALANCE 0.00 12,367.22
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 12,367.22
============== ============== ============== ==============
REVENUES
========
215-4-02110-34-7200 COURT SECURITY FEES 9.83 188.43
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 9.83 0.00 188.43
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 9.83 9.83 12,555.65 12,555.65
============== ============== ============== ==============
*** END OF REPORT ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
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 2,924.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 2,924.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
============
220-5-05110-55-3100 GROUNDSKEEPING 0.00 9,576.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 9,576.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 12,500.00 12,500.00
============== ============== ============== ==============
*** END OF REPORT ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
225-SPECIAL EVENTS FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
225-1-1102 CLAIM ON CASH 158,686.46 0.00
225-1-1105 ACCOUNTS RECEIVABLE 22,065.00 0.00
225-1-1225 DUE FROM SPECIAL EVENTS 50,000.00 50,000.00
______________ ______________ ______________ ______________
TOTAL ASSETS 208,686.46 22,065.00 50,000.00 0.00
============== ============== ============== ==============
LIABILITIES
===========
225-2-2101 AP PENDING (DUE TO POOL CASH) 348.29 1,687.79
225-2-2110 DUE TO OTHER FUNDS 170,374.50 170,374.50
225-2-3300 DEFERRED REVENUE 22,065.00 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 22,065.00 170,722.79 0.00 172,062.29
============== ============== ============== ==============
FUND BALANCE
============
225-3-1100 FUND BALANCE 0.00 7,288.70
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 7,288.70 0.00
============== ============== ============== ==============
REVENUES
========
225-4-01110-60-1001 TRANSFER IN 50,000.00 50,000.00
225-4-01420-38-3100 SPONSORSHIPS - CRAFT & CORK 0.00 25,199.06
225-4-01420-38-3200 MERCHANDISE - CRAFT AND CORK 1,637.50 0.00
225-4-01520-38-3100 SPONSORSHIPS - BOOMIN 4TH 0.00 35,000.00
225-4-01520-38-3200 VENDOR CHARGES 225.00 225.00
225-4-01620-38-3100 SPONSORSHIPS - XMAS CORRIDOR 1,150.00 7,150.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 53,012.50 0.00 117,574.06
============== ============== ============== ==============
EXPENDITURES
============
225-5-01110-53-1200 COMPUTER SUPPLIES 649.79 699.78
225-5-01110-56-1300 OTHER OFFICE EQUIPMENT 0.00 13,263.80
225-5-01420-53-1100 ADVERTISING 575.00 1,435.00
225-5-01420-53-1300 MISCELLANEOUS SUPPLIES 6,362.29 15,858.55
225-5-01420-54-1400 BANK CHARGES 0.00 15.00
225-5-01420-54-2110 COMMUNITY EVENTS 6,423.75 46,205.36
225-5-01420-54-2120 EVENT RENTALS - CRAFT AND COR 1,038.00 26,778.66
225-5-01520-52-1100 CONTRACT LABOR 0.00 3,300.00
225-5-01520-53-1100 ADVERTISING - BOOMIN 4TH 0.00 26.77
225-5-01520-53-1300 MISCELLANEOUS SUPPLIES 0.00 296.56
225-5-01520-54-2110 COMMUNITY EVENTS - BOOMIN 4TH 0.00 52,318.24
225-5-01620-54-2110 COMMUNITY EVENTS - XMAS CORR 0.00 72,149.93
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 15,048.83 0.00 232,347.65 0.00
============== ============== ============== ==============
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
225-SPECIAL EVENTS FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 245,800.29 245,800.29 289,636.35 289,636.35
============== ============== ============== ==============
*** END OF REPORT ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
230-PID #1
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
230-1-1100 CASH - PID #1 0.22 1,781.39
230-1-1102 CLAIM ON CASH 6,634.66 0.11
230-1-1105 ACCOUNTS RECEIVABLE 5,467.43 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 6,634.88 5,467.43 1,781.50 0.00
============== ============== ============== ==============
LIABILITIES
===========
230-2-2300 DUE TO OTHER FUNDS 6,634.66 6,634.66
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 6,634.66 0.00 6,634.66
============== ============== ============== ==============
FUND BALANCE
============
230-3-1100 FUND BALANCE 0.00 22,141.27
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 22,141.27
============== ============== ============== ==============
REVENUES
========
230-4-01420-31-2001 PID #1 ASSESSMENT 5,467.43 32,916.15
230-4-04110-36-1100 INTEREST REVENUE 0.22 89.42
______________ ______________ ______________ ______________
TOTAL REVENUES 5,467.43 0.22 0.00 33,005.57
============== ============== ============== ==============
EXPENDITURES
============
230-5-04110-60-1001 TRANSFER OUT 0.00 60,000.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 60,000.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 12,102.31 12,102.31 61,781.50 61,781.50
============== ============== ============== ==============
*** END OF REPORT ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
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.00 0.50
310-1-1101 UTILITY DEBT SERVICE CASH 176,380.41 134,651.03
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 0.00 4,333,489.13
310-1-1115 WATER DISTRIBUTION 50,116.85 5,202,485.53
310-1-1116 EQUIPMENT 0.00 158,537.27
310-1-1117 OFFICE EQUIPMENT 0.00 2,224.46
310-1-1118 AUTOMOBILES 49,303.31 171,995.76
310-1-1119 CONSTRUCTION IN PROGRESS 6,986,103.84 6,986,103.84
310-1-1120 SEWER SYSTEM 7,150.00 3,840,683.35
310-1-1121 ACCUMULATED DEPRECIATION 493,338.99 6,454,396.95
310-1-1123 BUILDINGS 0.00 46,412.97
310-1-1220 DUE FROM OTHER FUNDS 0.00 2,799.50
______________ ______________ ______________ ______________
TOTAL ASSETS 7,092,674.00 669,719.40 22,227,136.49 6,454,396.95
============== ============== ============== ==============
LIABILITIES
===========
310-2-2000 ACCOUNTS PAYABLE 9,397.00 0.00
310-2-2006 ACCRUED INTEREST PAYABLE 8,703.10 18,134.40
310-2-2100 DUE TO OTHER FUNDS 22,903.62 63,452.82
310-2-5051 GENERAL OBLIGATION UTIL 2010 0.00 1,245,000.00
310-2-5054 CERT OF OBLI UTIL PREMIUM 41,090.71 41,090.71
310-2-5075 2020 REFUNDING DYEGARD 0.00 2,109,300.00
310-2-5076 2020 GO REFUNDING WATER 0.00 260,700.00
310-2-5077 LOAN PAYABLE - 48% OF FW WATER 6,986,103.84 6,986,103.84
310-2-5103 CERT OF OBLIGATION UTIL SEWER 165,000.00 710,000.00
310-2-5150 AUTOMOBILE LEASES 50,839.98 50,839.98
______________ ______________ ______________ ______________
TOTAL LIABILITIES 183,100.10 7,100,938.15 0.00 11,484,621.75
============== ============== ============== ==============
FUND BALANCE
============
310-3-1100 FUND BALANCE 0.00 4,287,338.14
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 4,287,338.14
============== ============== ============== ==============
REVENUES
========
310-4-04110-60-1001 TRANSFER IN 98,169.36 694,869.36
310-4-07000-36-1100 INTEREST REVENUE 25.84 1,266.89
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 98,195.20 0.00 696,136.25
============== ============== ============== ==============
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
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 22,142.41 28,548.36
310-5-04410-58-1100 DEPRECIATION EXPENSE 483,190.63 483,190.63
310-5-07000-60-2100 INTEREST - C.O. SERIES 2012 5,779.93 38,604.93
310-5-07000-60-2400 BOND ISSUANCE COSTS 60,466.33 60,466.33
310-5-07001-60-2100 INTEREST - GEN OBLI 2010 3,612.86 3,587.14
310-5-07002-60-2100 INTEREST - 2010 CERT OF OBLIG 18,245.80 28,204.20
310-5-07003-60-2100 INTEREST - 2014 CERT OF OBLIG 8,815.00 18,212.00
310-5-07005-60-2100 INTEREST - LEASES 886.74 886.74
310-5-07007-60-2100 INTEREST - 2020 CERT OF OBLI 8,133.19 8,133.19
310-5-07008-60-2100 INTEREST - 48% FW WATER LINE 25,523.08 25,523.08
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 614,937.31 21,858.66 695,356.60 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 7,890,711.41 7,890,711.41 22,922,493.09 22,922,493.09
============== ============== ============== ==============
*** END OF REPORT ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
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 7,637.11 103,474.39
311-1-1202 TEXSTAR - CAPITAL PROJ RESERVE 1.72 15,374.68
______________ ______________ ______________ ______________
TOTAL ASSETS 7,638.83 0.00 118,849.07 0.00
============== ============== ============== ==============
LIABILITIES
===========
311-2-2000 ACCOUNTS PAYABLE 118,366.81 142,773.93
311-2-2100 DUE TO OTHER FUNDS 0.00 24,242.68
______________ ______________ ______________ ______________
TOTAL LIABILITIES 118,366.81 0.00 0.00 167,016.61
============== ============== ============== ==============
FUND BALANCE
============
311-3-1100 FUND BALANCE 0.00 48,541.60
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 48,541.60 0.00
============== ============== ============== ==============
REVENUES
========
311-4-04110-36-1100 INTEREST REVENUE 14.45 1,876.05
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 14.45 0.00 1,876.05
============== ============== ============== ==============
EXPENDITURES
============
311-5-04120-52-1300 PROFESSIONAL SERVICES 0.00 1,519.99
311-5-04120-54-2530 CONSTRUCTION - OAKEY 125,991.19 18.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 125,991.19 1,519.99 18.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 126,005.64 126,005.64 168,910.66 168,910.66
============== ============== ============== ==============
*** END OF REPORT ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
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 0.15 918.45
410-1-1220 DUE FROM OTHER FUNDS 13,506.62 53,506.62
______________ ______________ ______________ ______________
TOTAL ASSETS 13,506.77 0.00 54,425.07 0.00
============== ============== ============== ==============
LIABILITIES
===========
410-2-2100 DUE TO OTHER FUNDS 51,656.10 54,855.60
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 51,656.10 0.00 54,855.60
============== ============== ============== ==============
FUND BALANCE
============
410-3-1100 FUND BALANCE 0.00 52,638.33
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 52,638.33
============== ============== ============== ==============
REVENUES
========
410-4-01110-60-1001 TRANSFER IN 0.00 770,800.00
410-4-04110-38-1101 BOND PROCEEDS 125,000.00 125,000.00
410-4-07000-36-1100 INTEREST REVENUE 0.15 810.62
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 125,000.15 0.00 896,610.62
============== ============== ============== ==============
EXPENDITURES
============
410-5-04110-60-2400 BOND ISSUANCE COSTS 3,083.67 3,083.67
410-5-07000-60-3100 PAYMENT TO REFUNDING ESCROW A 121,916.33 121,916.33
410-5-07001-60-1100 PRINCIPAL - 2007 CERT OF OBLI 0.00 100,000.00
410-5-07001-60-2100 INTEREST - 2007 CERT OF OBLIG 400.00 37,320.00
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 5,350.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 9,487.50 22,937.50
410-5-07004-60-1100 PRINCIPAL - 2016A CERT OF OBL 0.00 175,000.00
410-5-07004-60-2100 INTEREST - 2016A CERT OF OBLI 0.00 97,200.00
410-5-07005-60-1100 PRINCIPAL - 2016B CERT OF OBL 0.00 55,000.00
410-5-07005-60-2100 INTEREST - 2016B CERT OF OBLI 0.00 54,935.00
410-5-07006-60-1100 PRINCIPAL - 2018 CERT OF OBLI 0.00 75,000.00
410-5-07006-60-2100 INTEREST - 2018 CERT OF OBLIG 47,425.00 96,725.00
410-5-07007-60-2100 INTEREST - 2020 CERT OF OBLI 211.98 211.98
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 173,036.98 9,887.50 949,679.48 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 186,543.75 186,543.75 1,004,104.55 1,004,104.55
============== ============== ============== ==============
*** END OF REPORT ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
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 ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
505-WATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
505-1-1102 CLAIM ON CASH 334,575.60 1,160,827.90
505-1-1103 TEXPOOL - ENTERPRISE RESERVE 11.23 92,769.52
505-1-1108 EARNED BUT UNBILLED-WATER 25,332.43 94,797.10
505-1-1115 WATER DISTRIBUTION 500.00 0.00
505-1-1197 UNAPPLIED CREDITS 160.21 9,909.66
505-1-1198 ALLOWANCE FOR UNCOLLECTABLE 2,350.31 14,512.72
505-1-1199 ACCOUNTS RECEIVABLE - WATER 31,635.81 124,832.31
505-1-1201 PREPAID EXPENSES 7,262.54 8,469.75
505-1-1221 DUE FROM DEVELOPERS 0.00 14,198.99
505-1-1250 DUE FROM WILLOW PARK 2,950.00 0.00
505-1-1300 DEFERRED OUTFLOW OF RESOURCES 32,016.00 54,910.80
505-1-1301 DEFERRED OUTFLOWS - OPEB 1,523.00 2,133.00
505-1-1400 RECEIVABLE (CREDIT) FROM WEATH 10,785.00 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 343,372.37 105,729.76 1,552,939.37 24,422.38
============== ============== ============== ==============
LIABILITIES
===========
505-2-2000 ACCOUNTS PAYABLE-AUDIT ACCRUAL 8,743.15 75,845.25
505-2-2005 COMPENSATED ABSENCES PAYABLE 10,708.58 33,428.76
505-2-2011 RETIREMENT (TMRS PAYABLE) 296.79 688.81
505-2-2012 HEALTH INSURANCE PAYABLE 181.24 541.49
505-2-2013 FLEX ACCOUNT PAYABLE 0.00 805.10
505-2-2015 DEFERRED COMP PAYABLE 4.00 36.00
505-2-2020 UNITED WAY PAYABLE 7.11 14.80
505-2-2024 ACCRUED PAYROLL 3,569.98 7,763.21
505-2-2025 LEADERS LIFE PAYABLE 2.30 20.69
505-2-2028 IMPACT FEES PAYABLE 12,942.00 0.00
505-2-2040 RENTER DEPOSITS 1,000.00 10,250.00
505-2-2101 AP PENDING (DUE TO POOL CASH) 55,673.76 47,869.55
505-2-2108 DUE TO WEATHERFORD 0.00 258,286.00
505-2-2200 DEFERRED INFLOWS OF RESOURCES 2,016.00 48,272.00
505-2-2300 NET PENSION LIABILITY 66,489.00 110,683.00
505-2-2301 OPEB LIABILITY 769.00 10,476.00
505-2-4100 FEDERAL WITHHOLDING 118.71 675.15
505-2-4200 MEDICARE PAYABLE 59.42 136.75
______________ ______________ ______________ ______________
TOTAL LIABILITIES 80,431.00 82,150.04 0.00 605,792.56
============== ============== ============== ==============
FUND BALANCE
============
505-3-1100 FUND BALANCE 16,475.34 633,186.04
505-3-1101 FUND BALANCE RESTRICTED-IMPACT 8,107.34 215,697.79
505-3-1120 PRIOR PERIOD ADJUSTMENT 8,466.00 0.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 16,475.34 16,573.34 0.00 848,883.83
============== ============== ============== ==============
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
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 25.00 65.00
505-4-04110-36-1120 INTEREST REVENUE 11.23 837.81
505-4-04410-34-4100 WATER SALES 149,851.86 1,573,014.91
505-4-04410-34-4110 UTGCD-HUDSON OAKS 4,776.07 38,889.40
505-4-04410-34-4200 SERVICE CHARGES 280.00 3,000.00
505-4-04410-34-4300 RECONNECT FEES 0.00 480.00
505-4-04410-34-4400 LATE PAYMENT PENALTIES 1,602.07 9,936.04
505-4-04410-34-4500 WATER IMPACT FEES 1,381.40 8,107.34
505-4-04410-34-4600 WATER TAP FEES 1,500.00 6,000.00
505-4-04410-34-4800 WIRELESS METER FEE 641.25 3,333.50
505-4-04420-38-1100 MISCELLANEOUS REVENUE 0.00 620.19
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 160,068.88 0.00 1,644,284.19
============== ============== ============== ==============
EXPENDITURES
============
505-5-04110-51-1100 REGULAR PAY 35,758.85 343,491.03
505-5-04110-51-1300 OVERTIME PAY-P.W. DEPT 2,322.63 18,098.68
505-5-04110-51-2100 MEDICAL INSURANCE-P.W. DEPT 1,567.58 16,767.07
505-5-04110-51-2120 DENTAL INSURANCE 175.78 1,807.65
505-5-04110-51-2160 LIFE INSURANCE 36.58 445.06
505-5-04110-51-2180 AD&D INSURANCE 4.96 64.08
505-5-04110-51-2200 TMRS-P.W. DEPT 30,972.67 2,664.61
505-5-04110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 2,500.00
505-5-04110-51-2520 MEDICARE TAXES 325.73 4,188.51
505-5-04110-51-2550 UNEMPLOYMENT INSURANCE 0.00 711.73
505-5-04110-51-2560 WORKERS COMPENSATION 0.00 6,368.58
505-5-04110-52-1100 CONTRACT LABOR 0.00 19,072.58
505-5-04110-52-1200 AUDITING & ACCOUNTING 0.00 4,834.00
505-5-04110-52-1300 PROFESSIONAL SERVICES 26,432.28 88,842.68
505-5-04110-52-1400 LEGAL FEES 7,757.35 14,057.35
505-5-04110-52-1700 WATER SAMPLING 3,037.69 12,803.26
505-5-04110-53-1100 GENERAL OFFICE SUPPLIES 0.00 1,176.96
505-5-04110-53-1200 COMPUTER SUPPLIES 0.00 1,682.21
505-5-04110-53-1300 MISCELLANEOUS EXPENSE 98.00 2,893.58
505-5-04110-53-1500 UNIFORMS 1,184.23 5,456.33
505-5-04110-53-1700 WATER SYSTEM SUPPLIES 18,895.88 45,334.98
505-5-04110-53-2100 CHEMICALS 1,895.44 8,243.89
505-5-04110-53-2200 METERS & COUPLINGS 594.36 24,049.66
505-5-04110-54-1100 PRINTING 364.51 8,145.86
505-5-04110-54-1200 POSTAGE 1,165.93 6,169.86
505-5-04110-54-1400 BANK CHARGES 1,420.12 16,153.42
505-5-04110-54-1800 REIMBURSEMENT 1,082.50 0.00
505-5-04110-54-2100 SEMINARS & TRAINING 0.00 245.00
505-5-04110-54-2300 TRAVEL EXPENSES 0.00 525.79
505-5-04110-54-2400 MEALS & EXPENSES 0.00 129.31
505-5-04110-54-3100 DUES & SUBSCRIPTIONS 0.00 333.32
505-5-04110-54-4100 TELEPHONE 640.18 8,035.70
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
505-WATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
505-5-04110-54-4200 ELECTRIC UTILITIES 2,598.90 1,661.03
505-5-04110-54-4220 WELL SITE UTILITIES 11,890.96 93,871.20
505-5-04110-54-5100 SOFTWARE MAINTENANCE 35,293.38 31,205.16
505-5-04110-54-5400 GENERAL LIABILITY INSURANCE 0.00 8,722.85
505-5-04110-55-1100 VEHICLE MAINTENANCE 340.37 10,509.07
505-5-04110-55-1200 GAS & OIL 929.48 8,764.93
505-5-04110-55-2100 EQUIPMENT MAINTENANCE 0.00 1,350.31
505-5-04110-55-3200 BUILDINGS 0.00 881.12
505-5-04110-55-4100 WATER PLANT MAINTENANCE 0.00 7,237.11
505-5-04110-55-4200 WATER DISTRIBUTION REPAIR 0.00 4,750.00
505-5-04110-55-4300 WATER WELL REPAIR 0.00 8,223.75
505-5-04110-56-2200 VEHICLES 375.00 0.00
505-5-04110-60-1001 TRANSFER OUT/DEBT SERVICE 157,542.92 261,702.51
505-5-04110-60-1200 CAPITAL LEASES - PRINCIPAL 16,863.33 0.00
505-5-04410-54-3200 UTGCD EXPENSE 11,188.21 24,116.24
505-5-04410-54-3300 REGIONAL WATER PURCHASES 11,819.54 155,381.26
505-5-04410-54-3310 REGIONAL DEMAND FEES 29,111.70 232,829.52
505-5-07000-60-2100 CAPITAL OUTLAY TRANSFER OUT 57,266.85 57,266.85
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 197,598.60 273,355.29 1,572,104.62 1,661.03
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 637,877.31 637,877.31 3,125,043.99 3,125,043.99
============== ============== ============== ==============
*** END OF REPORT ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
506-DEERCREEK FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
506-1-1102 CLAIM ON CASH 150,360.30 57,904.94
506-1-1112 DUE FROM OTHER FUNDS 170,374.50 170,923.70
506-1-1240 DUE FROM ANNETTA 11,227.84 47,639.61
506-1-1300 DEFERRED OUTFLOW OF RESOURCES 7,429.00 15,551.20
506-1-1301 DEFERRED OUTFLOWS - OPEB 492.00 644.00
______________ ______________ ______________ ______________
TOTAL ASSETS 182,094.34 157,789.30 292,663.45 0.00
============== ============== ============== ==============
LIABILITIES
===========
506-2-2000 ACCOUNTS PAYABLE 7,625.00 0.00
506-2-2005 COMPENSATED ABSENCES PAYABLE 201.74 6,291.12
506-2-2006 ACCRUED INTEREST PAYABLE 189.05 176.20
506-2-2011 RETIREMENT (TMRS PAYABLE) 52.59 193.33
506-2-2012 HEALTH INSURANCE PAYABLE-DC 45.05 67.63
506-2-2024 ACCRUED PAYROLL-DEER CREEK 615.53 2,196.18
506-2-2101 AP PENDING (DUE TO POOL CASH) 1,599.37 3,448.81
506-2-2200 DEFERRED INFLOWS 3,012.00 14,571.00
506-2-2300 NET PENSION LIABILITY 10,865.00 33,409.00
506-2-2301 OPEB LIABILITY 736.00 3,162.00
506-2-4100 FEDERAL WITHHOLDING 27.29 264.81
506-2-4200 MEDICARE PAYABLE 10.87 39.98
506-2-5150 AUTOMOBILE LEASES 8,377.38 8,466.83
______________ ______________ ______________ ______________
TOTAL LIABILITIES 18,679.05 14,677.82 0.00 72,286.89
============== ============== ============== ==============
FUND BALANCE
============
506-3-1100 FUND BALANCE 1,997.00 93,551.15
506-3-1120 PRIOR PERIOD ADJUSTMENT 1,997.00 0.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 1,997.00 1,997.00 0.00 93,551.15
============== ============== ============== ==============
REVENUES
========
506-4-04410-34-5000 ANNETTA CONTRACT CHARGES 41,154.28 246,925.68
506-4-04410-34-5100 ANNETTA MONTHLY OPERATION 25,051.66 0.00
______________ ______________ ______________ ______________
TOTAL REVENUES 25,051.66 41,154.28 0.00 246,925.68
============== ============== ============== ==============
EXPENDITURES
============
506-5-01110-53-1100 GENERAL OFFICE SUPPLIES 0.99 0.00
506-5-04110-51-1100 REGULAR PAY-DEERCREEK 6,622.06 75,894.06
506-5-04110-51-1300 OVERTIME PAY-DEERCREEK 722.49 9,249.29
506-5-04110-51-2100 MEDICAL INSURANCE-ANNETTA 614.76 7,991.88
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
506-DEERCREEK FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
506-5-04110-51-2120 DENTAL INSURANCE 38.22 496.86
506-5-04110-51-2160 LIFE INSURANCE 10.16 132.08
506-5-04110-51-2180 AD&D INSURANCE 1.60 20.80
506-5-04110-51-2200 TMRS-ANNETTA 1,222.07 10,747.94
506-5-04110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 1,000.00
506-5-04110-51-2520 MEDICARE TAXES 92.51 1,218.65
506-5-04110-51-2560 WORKERS COMPENSATION 0.00 2,497.50
506-5-04110-52-1300 PROFESSIONAL SERVICES 7,625.00 0.00
506-5-04110-52-1700 WATER SAMPLING-DC 600.00 0.00
506-5-04110-53-1300 MISC SUPPLIES-DEERCREEK 2,703.91 0.00
506-5-04110-53-1500 UNIFORMS-DEERCREEK 1,094.02 0.00
506-5-04110-53-1700 WATER SYSTEM SUPPLIES-DC 1,360.20 0.00
506-5-04110-53-2100 CHEMICALS-DEERCREEK 7,360.35 0.00
506-5-04110-54-1200 POSTAGE-DEERCREEK 179.29 189.29
506-5-04110-54-2100 SEMINARS & TRAINING 222.00 0.00
506-5-04110-54-5400 GENERAL LIABILITY INSURANCE 0.00 1,554.62
506-5-04110-55-1100 VEHICLE MAINTENANCE 140.02 48.02
506-5-04110-55-1200 GAS & OIL-DEERCREEK 725.38 8,453.28
506-5-04110-55-4100 WATER PLANT MAINTENANCE-DC 51.29 0.00
506-5-04110-55-4200 WASTEWATER PLANT MAINTENANCE 1,115.26 0.00
506-5-04110-60-1200 CAPITAL LEASES-PRINCIPAL (DC) 216.84 0.00
506-5-04110-60-2100 INTEREST EXPENSE 57.69 606.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 10,286.23 22,489.88 120,100.27 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 238,108.28 238,108.28 412,763.72 412,763.72
============== ============== ============== ==============
*** END OF REPORT ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
507-DYEGARD FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
507-1-1102 CLAIM ON CASH 32,397.58 138,748.07
507-1-1108 EARNED BUT UNBILLED-DYEGARD 2,957.88 16,269.21
507-1-1198 ALLOWANCE FOR UNCOLLECTABLE 82.52 1,770.36
507-1-1199 ACCOUNTS RECIEVABLE-DYE-WATER 3,921.70 26,744.77
______________ ______________ ______________ ______________
TOTAL ASSETS 32,397.58 6,962.10 181,762.05 1,770.36
============== ============== ============== ==============
LIABILITIES
===========
507-2-2000 ACCOUNTS PAYABLE-AUDIT 3,263.65 0.00
507-2-2101 AP PENDING (DUE TO POOL CASH) 221.58 221.58
______________ ______________ ______________ ______________
TOTAL LIABILITIES 3,263.65 221.58 0.00 221.58
============== ============== ============== ==============
FUND BALANCE
============
507-3-1100 FUND BALANCE 0.00 100,758.67
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 100,758.67
============== ============== ============== ==============
REVENUES
========
507-4-04410-34-4100 WATER SALES-DYEGARD 28,517.82 283,369.52
507-4-04410-34-4400 LATE PAYMENT PENALTIES-DYEGARD 293.39 1,998.47
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 28,811.21 0.00 285,367.99
============== ============== ============== ==============
EXPENDITURES
============
507-5-04110-52-1200 AUDITING AND ACCOUNTING-DYEGA 0.00 3,000.00
507-5-04110-52-1300 PROFESSIONAL SERVICES-DYE 2,500.00 2,982.65
507-5-04110-52-1700 WATER SAMPLING-DYEGARD 20.00 4,647.81
507-5-04110-53-2100 CHEMICALS-DYEGARD 204.44 556.93
507-5-04110-54-1100 PRINTING-DYEGARD 91.13 988.39
507-5-04110-54-1200 POSTAGE-DYEGARD 189.98 1,269.84
507-5-04110-54-4200 ELECTRIC UTILITES-DYEGARD 0.00 2,696.19
507-5-04110-54-4220 WELL SITE UTILITIES-DYEGARD 2,815.43 171.20
507-5-04110-54-5100 SOFTWARE MAINTENANCE 143.54 143.54
507-5-04110-60-1001 TRANSFER OUT-DYEGARD DEBT 0.00 189,900.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 3,149.09 2,815.43 206,356.55 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 38,810.32 38,810.32 388,118.60 388,118.60
============== ============== ============== ==============
*** END OF REPORT ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
510-WASTEWATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
510-1-1102 CLAIM ON CASH 34,697.33 621,867.09
510-1-1109 EARNED BUT UNBILLED-WASTEWATER 2,040.08 24,404.56
510-1-1190 A/R - ASSESSMENTS 6,055.05 106,436.89
510-1-1198 ALLOWANCE FOR UNCOLLECTABLE 3,793.29 403.55
510-1-1199 ACCOUNTS RECEIVABLE - SEWER 4,829.74 28,465.59
510-1-1202 TEXSTAR - WASTEWATER RESERVE 46.02 418,006.80
______________ ______________ ______________ ______________
TOTAL ASSETS 40,576.72 10,884.79 1,199,180.93 403.55
============== ============== ============== ==============
LIABILITIES
===========
510-2-2000 ACCOUNTS PAYABLE-AUDIT ACCRUAL 12,659.68 11,585.18
510-2-2028 SEWER IMPACT FEES PAYABLE 3,071.00 6,142.00
510-2-2101 AP PENDING (DUE TO POOL CASH) 2,738.47 3,149.79
______________ ______________ ______________ ______________
TOTAL LIABILITIES 12,659.68 5,809.47 0.00 20,876.97
============== ============== ============== ==============
FUND BALANCE
============
510-3-1100 FUND BALANCE 0.00 1,090,536.11
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 1,090,536.11
============== ============== ============== ==============
REVENUES
========
510-4-04110-36-1120 INTEREST REVENUE 46.02 3,643.01
510-4-04510-34-5100 WASTEWATER CHARGES 42,513.86 431,579.21
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 42,559.88 0.00 435,222.22
============== ============== ============== ==============
EXPENDITURES
============
510-5-04110-52-1300 PROFESSIONAL SERVICES 7,397.79 7,397.79
510-5-04510-54-2100 WASTEWATER TREATMENT SERVICES 1,874.03 152,126.25
510-5-04510-54-4200 ELECTRIC UTILITIES 258.02 1,286.72
510-5-04510-55-4202 SEWER MAINTENANCE 752.00 1,047.16
510-5-04510-60-1001 TRANSFER OUT/DEBT SERVICE 0.00 186,000.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 8,149.79 2,132.05 347,857.92 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 61,386.19 61,386.19 1,547,038.85 1,547,038.85
============== ============== ============== ==============
*** END OF REPORT ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
515-SOLID WASTE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
515-1-1102 CLAIM ON CASH 8,567.87 0.00
515-1-1198 ALLOWANCE FOR UNCOLLECTABLE 230.98 88.06
515-1-1199 ACCOUNTS RECEIVABLE - SW 192.59 12,663.80
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 8,991.44 12,663.80 88.06
============== ============== ============== ==============
LIABILITIES
===========
515-2-2013 SOLID WASTE PAYABLE 14,469.18 11,496.07
515-2-2014 SALES TAX PAYABLE - SW 5,477.74 1,079.67
______________ ______________ ______________ ______________
TOTAL LIABILITIES 14,469.18 5,477.74 0.00 12,575.74
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 14,469.18 14,469.18 12,663.80 12,663.80
============== ============== ============== ==============
*** END OF REPORT ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
520-STORMWATER UTILITY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
520-1-1101 STORMWATER DEBT SERVICE 2.22 18,038.36
520-1-1102 CLAIM ON CASH 18,141.29 136,361.24
520-1-1108 EARNED BUT UNBILLED-STORMWATER 1,235.19 10,646.24
520-1-1112 DUE FROM OTHER FUNDS 0.00 24,242.68
520-1-1119 CONSTRUCTION IN PROGRESS 270.38 546,817.70
520-1-1198 ALLOWANCE FOR UNCOLLECTIBLE 110.84 1,036.36
520-1-1199 ACCOUNTS RECEIVABLE 2,138.68 7,383.87
______________ ______________ ______________ ______________
TOTAL ASSETS 19,759.92 2,138.68 743,490.09 1,036.36
============== ============== ============== ==============
LIABILITIES
===========
520-2-2006 ACCRUED INTEREST PAYABLE 208.34 2,412.51
520-2-2030 SERIES 2016 A BONDS 0.00 460,000.00
520-2-2031 SERIES 2016 A PREMIUM 1,039.50 16,372.12
______________ ______________ ______________ ______________
TOTAL LIABILITIES 1,039.50 208.34 0.00 478,784.63
============== ============== ============== ==============
FUND BALANCE
============
520-3-1100 FUND BALANCE 0.00 103,346.40
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 103,346.40
============== ============== ============== ==============
REVENUES
========
520-4-04110-34-6000 STORMWATER FEE 17,348.64 179,998.95
520-4-07000-36-1100 INTEREST REVENUE 2.22 114.51
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 17,350.86 0.00 180,113.46
============== ============== ============== ==============
EXPENDITURES
============
520-5-04110-55-4500 DRAINAGE SYSTEM REPAIRS 270.38 7,727.02
520-5-04110-56-4300 STREET REPAIRS 0.00 94.90
520-5-04110-60-2200 DEBT SERVICE - INTEREST 831.16 11,968.84
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 1,101.54 19,790.76 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 20,799.42 20,799.42 763,280.85 763,280.85
============== ============== ============== ==============
*** END OF REPORT ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
610-PRIVATE PURPOSE TRUST
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
610-1-1102 CLAIM ON CASH 3,112.30 10,153.54
610-1-1196 MISCELLANEOUS RECEIVABLE 31,063.04 31,063.04
______________ ______________ ______________ ______________
TOTAL ASSETS 31,063.04 3,112.30 31,063.04 10,153.54
============== ============== ============== ==============
LIABILITIES
===========
610-2-2000 ACCOUNTS PAYABLE 20,909.50 20,909.50
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 20,909.50 0.00 20,909.50
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
610-4-01110-34-3000 FIDUCIARY INCOME 63,902.81 679,798.79
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 63,902.81 0.00 679,798.79
============== ============== ============== ==============
EXPENDITURES
============
610-5-01110-52-2220 FIDUCIARY EXPENSES 56,861.57 679,798.79
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 56,861.57 0.00 679,798.79 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 87,924.61 87,924.61 710,861.83 710,861.83
============== ============== ============== ==============
*** END OF REPORT ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
710-INTERNAL SERVICE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
710-1-1100 CASH & CASH EQUIVALENTS 1.26 10,283.23
______________ ______________ ______________ ______________
TOTAL ASSETS 1.26 0.00 10,283.23 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
710-3-1100 FUND BALANCE 0.00 12,825.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 12,825.00
============== ============== ============== ==============
REVENUES
========
710-4-01110-34-3000 HEALTH CHARGES 0.00 12,500.00
710-4-01110-36-1100 INTEREST REVENUE 1.26 55.15
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 1.26 0.00 12,555.15
============== ============== ============== ==============
EXPENDITURES
============
710-5-01110-51-2230 INSURANCE REIMBURSEMENTS 0.00 15,096.92
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 15,096.92 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 1.26 1.26 25,380.15 25,380.15
============== ============== ============== ==============
*** END OF REPORT ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
800-GENERAL FIXED ASSETS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
800-1-1200 LAND 93,904.12 942,382.40
800-1-1300 BUILDINGS 0.00 2,566,374.56
800-1-1400 AUTOMOBILES 72,818.10 313,340.38
800-1-1500 BUILDING IMPROVEMENTS 0.00 267,429.69
800-1-1600 EQUIPMENT 40,809.25 451,717.44
800-1-1700 OFFICE EQUIPMENT 0.00 22,373.11
800-1-1800 INFRASTRUCTURE 3,660,315.50 12,620,281.58
800-1-1900 FURNITURES & FIXTURES 0.00 5,511.05
800-1-1950 CONSTRUCTION IN PROGRESS 3,587,401.71 2,891,031.15
800-1-2000 ACCUMULATED DEPRECIATION 470,757.89 4,510,805.16
______________ ______________ ______________ ______________
TOTAL ASSETS 3,867,846.97 4,058,159.60 20,080,441.36 4,510,805.16
============== ============== ============== ==============
LIABILITIES
===========
800-2-2000 INVESTMENT IN CAPITAL ASSETS 255,142.26 17,363,666.39
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 255,142.26 0.00 17,363,666.39
============== ============== ============== ==============
FUND BALANCE
============
800-3-1100 FUND BALANCE 25,303.00 1,323,272.30
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 25,303.00 1,323,272.30 0.00
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
800-5-01110-51-2100 DEPRECIATION EXPENSE 138,681.90 138,681.90
800-5-03110-51-2100 DEPRECIATION EXPENSE 86,552.31 86,552.31
800-5-04110-51-2100 DEPRECIATION EXPENSE 245,523.68 245,523.68
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 470,757.89 0.00 470,757.89 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 4,338,604.86 4,338,604.86 21,874,471.55 21,874,471.55
============== ============== ============== ==============
*** END OF REPORT ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
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 23,615.02 9,124,727.08
______________ ______________ ______________ ______________
TOTAL ASSETS 23,615.02 0.00 9,124,727.08 0.00
============== ============== ============== ==============
LIABILITIES
===========
900-2-2100 2007 CERTIFICATES OF OBLIG 0.00 820,000.00
900-2-2120 2012 CERT OF OBLIG GF PORTION 0.00 680,000.00
900-2-2121 2012 CO PREMIUM ON BOND 0.00 15,197.95
900-2-2130 CO SERIES 2016 A 0.00 3,565,000.00
900-2-2131 CO SERIES 2016 A PREMIUM 0.00 125,031.42
900-2-2140 CO SERIES 2016 B BONDS 0.00 1,350,000.00
900-2-2141 CO SERIES 2016 B PREMIUM 0.00 55,460.32
900-2-2150 2018 CERT OF OBLIGATION PID 0.00 1,875,000.00
900-2-2151 2018 PID PREMIUM 0.00 86,301.25
900-2-2160 2018 CERT OF OBLIGATION FIBER 0.00 330,000.00
900-2-2161 2018 ADDITION FIBER PREMIUM 0.00 15,230.47
900-2-2170 2020 GO REFUNDING 0.00 125,000.00
900-2-2300 VEHICLE LEASES 29,507.60 71,812.95
900-2-2400 EQUIPMENT LEASES 5,892.58 10,692.72
______________ ______________ ______________ ______________
TOTAL LIABILITIES 5,892.58 29,507.60 0.00 9,124,727.08
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 29,507.60 29,507.60 9,124,727.08 9,124,727.08
============== ============== ============== ==============
*** END OF REPORT ***
2-26-2021 10:47 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2020
999-POOL CASH
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
999-1-1099 POOL CASH 292,339.58 2,283,049.26
999-1-1100 DUE FROM GENERAL FUND 51,306.13 79,992.61
999-1-1225 DUE FROM SPECIAL EVENTS 348.29 1,687.79
999-1-1505 DUE FROM WATER FUND 55,673.76 47,869.55
999-1-1506 DUE FROM DEERCREEK 1,599.37 3,448.81
999-1-1507 DUE FROM DYEGARD 221.58 221.58
999-1-1510 DUE FROM WASTEWATER FUND 2,738.47 3,149.79
______________ ______________ ______________ ______________
TOTAL ASSETS 404,227.18 0.00 2,419,419.39 0.00
============== ============== ============== ==============
LIABILITIES
===========
999-2-2000 ACCOUNTS PAYABLE 111,887.60 136,370.13
999-2-2100 DUE TO OTHER FUNDS 292,339.58 2,283,049.26
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 404,227.18 0.00 2,419,419.39
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 404,227.18 404,227.18 2,419,419.39 2,419,419.39
============== ============== ============== ==============
*** END OF REPORT ***