2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
100-1-1102 CLAIM ON CASH 108,314.14 408,278.04
100-1-1106 CASH ON HAND 0.00 200.00
100-1-1107 FRANCHISE TAX RECEIVABLE 4,357.17 85,063.27
100-1-1108 SALES TAX RECEIVABLE 121,051.36 692,856.24
100-1-1112 DUE FROM OTHER FUNDS 102,242.46 102,242.46
100-1-1113 POOLED CASH CD 0.00 227,297.20
100-1-1190 COURT FINES RECEIVABLE 231.97 187,971.15
100-1-1191 ALLOWANCE FOR UNCOLLECTABLE-CT 889.10 150,376.92
100-1-1192 A/R - ASSESSMENTS 115,009.74 528,889.93
100-1-1193 A/R - CENTERPOINT ASSESSMENTS 1,370,254.21 1,370,254.21
100-1-1196 MISC RECIEVABLES 611.05 38,714.53
100-1-1200 TEXPOOL - GENERAL RESERVE 2.40 104,029.03
100-1-1201 PREPAID EXPENSES 7,375.06 16,519.76
100-1-1202 TEXSTAR - GENERAL RESERVE 8.46 1,036,745.77
100-1-1234 DUE FROM NEXTLINK 64,815.99 0.00
100-1-1300 PROPERTY INVESTMENTS 0.00 148,789.60
100-1-5200 TEXPOOL - SALES TAX RESERVE 3.86 168,189.40
______________ ______________ ______________ ______________
TOTAL ASSETS 1,658,378.74 236,788.23 5,116,040.59 150,376.92
============== ============== ============== ==============
LIABILITIES
===========
100-2-2000 ACCOUNTS PAYABLE CONTROL 130,337.76 130,337.76
100-2-2001 ACCOUNTS PAYABLE - 1999 61,599.10 246,599.10
100-2-2005 DUE TO TRUST & AGENCY FUND 0.00 303.00
100-2-2007 DUE TO COLLECTION AGENCY 0.00 19.81
100-2-2011 RETIREMENT (TMRS PAYABLE) 540.72 3,279.49
100-2-2012 HEALTH INSURANCE PAYABLE 383.86 3,183.15
100-2-2013 FLEX ACCOUNT PAYABLE 0.00 826.83
100-2-2014 CHILD SUPPORT PAYABLE 18.46 166.15
100-2-2015 DEFERRED COMP PAYABLE 61.58 656.49
100-2-2020 UNITED WAY PAYABLE 0.25 38.25
100-2-2021 ACCRUED PAYROLL-GEN FUND 3,679.37 35,840.20
100-2-2023 DUE TO OMNIBASE 30.00 7.74
100-2-2025 LEADERS LIFE PAYABLE 1.72 15.50
100-2-2101 AP PENDING (DUE TO POOL CASH) 104,265.67 174,809.63
100-2-2102 DUE TO STATE-COURT COSTS 911.98 1,734.85
100-2-2103 DUE TO OTHER FUNDS 7,737.64 7,737.64
100-2-2107 DUE TO POLICE OFFICE ASSOC 34.00 90.00
100-2-3300 DEFERRED REVENUE 62,442.91 478,623.66
100-2-3301 DEFERRED ASSESSMENTS REVENUE 115,009.74 528,889.93
100-2-3302 DEFERRED CENTERPT ASSES REVENU 1,370,254.21 1,370,254.21
100-2-4100 FEDERAL WITHHOLDING 1,287.44 2,584.48
100-2-4200 MEDICARE PAYABLE 161.41 795.29
______________ ______________ ______________ ______________
TOTAL LIABILITIES 116,013.30 1,742,744.52 826.83 2,985,966.33
============== ============== ============== ==============
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
FUND BALANCE
============
100-3-1100 FUND BALANCE 0.00 1,508,875.44
100-3-1103 RESTRICTED FUND BALANCE-PEG 0.00 9,981.79
100-3-1104 NONSPENDABLE FUND BALANCE 0.00 25,721.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 1,544,578.23
============== ============== ============== ==============
REVENUES
========
100-4-01110-60-1001 TRANSFER IN 0.00 37,727.78
100-4-01420-31-1100 LOCAL SALES & USE TAX 400,853.47 3,709,866.14
100-4-01420-31-1120 MIXED BEVERAGES TAX 1,104.30 18,463.61
100-4-01420-31-2000 PAYMENT IN LIEU OF TAXES 0.00 49,661.01
100-4-01420-31-2100 FRANCHISE FEES 2,723.34 177,394.94
100-4-01420-31-2200 IN-KIND PEG FEES 0.00 571.72
100-4-01420-32-3100 ALCOHOLIC BEVERAGE PERMITS 0.00 1,397.50
100-4-01420-33-2100 STATE GRANT REVENUES 307,130.69 49,523.45
100-4-01420-34-2100 PRINTING & DUPLICATION FEE 0.00 0.50
100-4-01420-36-1100 INTEREST REVENUE 397.50 5,358.56
100-4-01420-38-1100 MISCELLANEOUS REVENUE 92,197.22 103,000.06
100-4-01420-38-1200 CREDIT CARD REVENUE-MISC (FEE) 126.87 1,409.99
100-4-01420-38-2000 ROADWAY ASSESSMENTS 0.00 115,009.74
100-4-01420-39-4120 T-MOBILE GROUND LEASE 0.00 23,958.00
100-4-02110-35-1100 TRAFFIC FINES 417.41 13,377.05
100-4-02110-35-1200 ARREST FEES 9.27 269.69
100-4-02110-35-1300 COURT ADMINISTRATIVE FEES 9.90 64.80
100-4-02110-35-1400 WARRANT FEES 0.00 1,065.83
100-4-02110-35-1500 COURT SPECIAL EXPENSE FEE 60.98 310.98
100-4-02110-35-1600 TFC FEES 6.00 42.87
100-4-02110-35-1700 JFCI REVENUE 0.00 6.60
100-4-02110-35-1710 CIVIL JUSTICE FEE-COURT 0.00 0.01
100-4-02110-35-1900 CREDIT CARD REVENUE-COURT 11.82 414.18
100-4-02110-35-1910 OVERPAYMENT-COURT 0.00 50.00
100-4-03110-34-2201 MISCELLANEOUS REVENUE-POLICE 0.00 1,000.00
100-4-03410-33-4100 TCLEOSE EDUCATION ALLOWANCE 1,270.00 1,135.22
100-4-03410-33-4102 ESD#3 BUILDING LEASE 2,043.21 24,339.99
100-4-06110-32-3200 BUILDING PERMITS 108,435.64 360,318.68
100-4-06110-32-3300 OCCUPANCY PERMITS 150.00 1,250.00
100-4-06110-32-3420 BILLBOARD PERMITS 100.00 250.00
100-4-06210-34-1100 PLAT FEES 250.00 4,560.00
100-4-06210-34-1110 DEVELOPMENT REVIEW FEES 0.00 5,000.00
100-4-06210-34-1120 REPLAT FEES 0.00 608.02
100-4-06210-34-1140 ZONING FEES 0.00 250.00
100-4-06310-32-3500 WELL PERMITS 0.00 100.00
100-4-06310-32-3600 SEPTIC PERMITS 0.00 820.00
100-4-06310-32-3700 HEALTH PERMITS 300.00 12,675.00
100-4-08000-61-1200 CAPITAL LEASE PROCEEDS 0.00 25,193.00
100-4-08000-61-2140 INSURANCE PROCEEDS 2,316.00 16,474.50
______________ ______________ ______________ ______________
TOTAL REVENUES 308,400.69 611,512.93 0.00 4,762,919.42
============== ============== ============== ==============
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
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 30,536.05 341,873.35
100-5-01110-51-2100 MEDICAL INSURANCE 1,301.97 14,877.92
100-5-01110-51-2120 DENTAL INSURANCE 160.53 1,834.91
100-5-01110-51-2160 LIFE INSURANCE 17.28 275.26
100-5-01110-51-2180 AD&D INSURANCE 1.92 22.24
100-5-01110-51-2200 TMRS 3,224.49 36,109.06
100-5-01110-51-2220 HEALTH REIMBURSEMENT AGREEMEN 0.00 4,280.00
100-5-01110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 2,400.00
100-5-01110-51-2520 MEDICARE TAXES 379.30 4,541.28
100-5-01110-51-2540 UNEMPLOYMENT INSURANCE 0.00 6,992.66
100-5-01110-51-2560 WORKER'S COMPENSATION 0.00 5,332.87
100-5-01110-52-1200 AUDITING & ACCOUNTING 2,500.00 8,100.00
100-5-01110-52-1300 PROFESSIONAL SERVICES 40,676.90 95,410.89
100-5-01110-52-1400 LEGAL FEES 2,047.86 33,785.90
100-5-01110-52-1620 HEALTH INSPECTIONS 560.00 10,313.43
100-5-01110-53-1100 GENERAL OFFICE SUPPLIES 553.40 5,500.13
100-5-01110-53-1200 COMPUTER SUPPLIES 103.84 7,076.73
100-5-01110-53-1300 MISCELLANEOUS SUPPLIES 491.12 1,728.52
100-5-01110-53-1301 MISCELLANEOUS EXPENSE 25.71 269.91
100-5-01110-54-1100 PRINTING 116.28 1,447.42
100-5-01110-54-1200 POSTAGE 441.99 1,352.30
100-5-01110-54-1400 BANK FEES 1.50 37.50
100-5-01110-54-2100 SEMINARS & TRAINING 0.00 7,059.98
100-5-01110-54-2110 COMMUNITY EVENTS 493.33 6,520.69
100-5-01110-54-2300 TRAVEL EXPENSE 0.00 2,317.61
100-5-01110-54-2400 MEALS & EXPENSES 0.00 1,369.25
100-5-01110-54-3100 DUES & SUBSCRIPTIONS 265.00 15,041.05
100-5-01110-54-4100 TELEPHONE 1,528.55 8,441.85
100-5-01110-54-4200 ELECTRIC UTILITIES 698.42 8,315.52
100-5-01110-54-5000 ECON DEV AGREEMENTS 156,346.76 135,340.36
100-5-01110-54-5100 SOFTWARE MAINTENANCE 7,861.69 54,525.26
100-5-01110-54-5200 CRF EXPENDITURES 0.00 76,996.38
100-5-01110-54-5400 GENERAL LIABILITY INSURANCE 0.00 4,120.65
100-5-01110-55-2200 OFFICE EQUIPMENT MAINTENANCE 0.00 118.97
100-5-01110-56-1200 OFFICE MACHINES 386.38 3,364.97
100-5-01110-60-1001 TRANSFER OUT 0.00 61,226.10
100-5-01210-54-1300 ADVERTISING & LEGAL NOTICES 720.32 4,040.20
100-5-01210-54-1310 FILING FEES 0.00 1,558.73
100-5-02110-51-1100 REGULAR PAY 2,179.43 27,017.64
100-5-02110-51-2100 MEDICAL INSURANCE 122.96 1,721.43
100-5-02110-51-2120 DENTAL INSURANCE 15.28 213.92
100-5-02110-51-2160 LIFE INSURANCE 4.06 56.84
100-5-02110-51-2180 AD&D INSURANCE 0.64 8.64
100-5-02110-51-2200 TMRS 246.82 3,293.67
100-5-02110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 320.00
100-5-02110-51-2520 MEDICARE TAXES 28.42 378.47
100-5-02110-51-2560 WORKER'S COMPENSATION 0.00 454.49
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 4
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
100-5-02110-52-1200 AUDITING & ACCOUNTING 0.00 3,200.00
100-5-02110-52-1300 PROFESSIONAL SERVICES 765.00 7,495.00
100-5-02110-54-3100 DUES & SUBSCRIPTIONS 0.00 180.00
100-5-02110-54-5100 SOFTWARE MAINTENANCE 247.48 7,920.41
100-5-02110-54-5400 GENERAL LIABILITY INSURANCE 0.00 120.32
100-5-03110-51-1100 REGULAR PAY 59,761.74 801,073.46
100-5-03110-51-1300 OVERTIME PAY 3,387.08 68,675.54
100-5-03110-51-1900 CERTIFICATION PAY 793.96 1,587.92
100-5-03110-51-2100 MEDICAL INSURANCE 3,703.63 49,981.88
100-5-03110-51-2120 DENTAL INSURANCE 458.64 6,191.64
100-5-03110-51-2160 LIFE INSURANCE 91.44 1,270.00
100-5-03110-51-2180 AD&D INSURANCE 14.40 191.20
100-5-03110-51-2200 TMRS 7,366.30 106,721.48
100-5-03110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 10,400.00
100-5-03110-51-2520 MEDICARE TAXES 814.05 11,872.85
100-5-03110-51-2560 WORKER'S COMPENSATION 0.00 13,635.12
100-5-03110-52-1100 CONTRACT LABOR 116.38 33,067.56
100-5-03110-52-1200 AUDITING & ACCOUNTING 2,500.00 7,100.00
100-5-03110-52-1300 PROFESSIONAL SVCS - PUB SAFET 0.00 228.50
100-5-03110-53-1100 GENERAL OFFICE SUPPLIES 618.80 2,464.00
100-5-03110-53-1200 COMPUTER SUPPLIES 0.00 5,863.85
100-5-03110-53-1300 MISCELLANEOUS EXPENSE 1,100.96 2,259.81
100-5-03110-53-1400 AMMUNITION 0.00 1,430.47
100-5-03110-53-1500 UNIFORMS 25.00 10,546.61
100-5-03110-54-1100 PRINTING 0.00 647.44
100-5-03110-54-1200 POSTAGE 15.35 244.30
100-5-03110-54-2100 SEMINARS & TRAINING 1,270.00 3,423.06
100-5-03110-54-2300 TRAVEL EXPENSES 0.00 20.00
100-5-03110-54-3100 DUES & SUBSCRIPTIONS 0.00 1,074.00
100-5-03110-54-4100 TELEPHONE 203.71 10,472.68
100-5-03110-54-4200 ELECTRIC UTILITIES 983.28 12,932.74
100-5-03110-54-5100 SOFTWARE MAINTENANCE 1,382.15 49,530.62
100-5-03110-54-5400 GENERAL LIABILITY INSURANCE 0.00 20,300.45
100-5-03110-54-6100 INMATE HOUSING 0.00 141.00
100-5-03110-54-6200 DISPATCHER 17,500.02 87,500.10
100-5-03110-55-1100 VEHICLE MAINTENANCE 1,296.29 9,157.64
100-5-03110-55-1200 GAS & OIL 2,434.95 21,650.60
100-5-03110-55-2100 EQUIPMENT MAINTENANCE 0.00 2,026.35
100-5-03110-55-2200 OFFICE EQUIPMENT MAINTENANCE 193.78 1,837.11
100-5-03110-55-2300 RADIO REPAIR & MAINTENANCE 1,026.53 1,026.53
100-5-03110-56-2200 VEHICLES 52,173.10 52,173.10
100-5-03110-56-2300 PUBLIC SAFETY BUILDING 0.00 1,136.41
100-5-03110-60-1200 CAPITAL LEASE - PRINCIPAL 16,525.86 53,157.40
100-5-03110-60-2200 CAPITAL LEASE - INTEREST 581.15 2,492.47
100-5-04110-51-1100 REGULAR PAY 2,013.93 42,098.82
100-5-04110-51-2100 MEDICAL INSURANCE 178.66 4,062.42
100-5-04110-51-2120 DENTAL INSURANCE 21.02 491.35
100-5-04110-51-2160 LIFE INSURANCE 2.54 66.04
100-5-04110-51-2180 AD&D INSURANCE 0.40 10.40
100-5-04110-51-2200 TMRS 5,926.72 10,843.94
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 5
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
100-5-04110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 720.00
100-5-04110-51-2520 MEDICARE TAXES 41.07 621.44
100-5-04110-51-2560 WORKERS COMPENSATION 0.00 1,136.28
100-5-04110-53-1200 COMPUTER SUPPLIES 0.00 2,458.00
100-5-04110-53-1300 MISCELLANEOUS EXPENSE 118.99 942.97
100-5-04110-53-1500 UNIFORMS 110.00 210.00
100-5-04110-54-5400 GENERAL LIABILITY INSURANCE 0.00 3,092.24
100-5-04110-60-1001 TRANSFER OUT/I-20 OFF RAMP 0.00 807,000.00
100-5-04210-51-2521 FICA TAXES 368.53 4,675.40
100-5-04210-52-1300 PROFESSIONAL SERVICES 3,825.00 8,052.29
100-5-04210-52-1500 EQUIPMENT RENTAL 0.00 632.95
100-5-04210-54-4200 ELECTRIC UTILITIES 894.81 4,231.97
100-5-04210-56-4100 STREET SIGNS 3,364.17 6,621.92
100-5-04210-56-4200 STREET IMPROVEMENTS 0.00 178,305.77
100-5-04210-56-4300 STREET REPAIRS 868.00 49,997.80
100-5-05110-51-1100 REGULAR PAY 4,722.17 22,117.23
100-5-05110-51-1300 OVERTIME PAY 322.36 1,432.45
100-5-05110-51-2100 MEDICAL INSURANCE 92.21 1,106.56
100-5-05110-51-2120 DENTAL INSURANCE 49.68 290.48
100-5-05110-51-2200 TMRS 505.25 2,775.82
100-5-05110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 720.00
100-5-05110-51-2520 MEDICARE TAXES 54.23 305.70
100-5-05110-51-2560 WORKER'S COMPENSATION 0.00 1,704.38
100-5-05110-52-1300 PROFESSIONAL SERVICES 0.00 2,316.00
100-5-05110-53-1300 MISCELLANEOUS SUPPLIES 152.94 2,616.07
100-5-05110-54-5400 GENERAL LIABILITY INSURANCE 0.00 440.96
100-5-05110-55-2100 EQUIPMENT MAINTENANCE 594.09 4,694.33
100-5-05110-55-3100 GROUNDSKEEPING 6,858.29 47,265.43
100-5-05110-55-3200 BUILDING MAINTENANCE 1,992.33 103,749.32
100-5-05110-56-3100 PROPERTY 2,143.64 330,329.77
100-5-06110-52-1300 PROFESSIONAL SERVICES 57,537.75 29,747.50
100-5-06110-52-1600 BUILDING INSPECTIONS 109,368.78 142,717.41
100-5-06110-53-1300 MISCELLANEOUS SUPPLIES 0.00 69.95
100-5-06110-54-3100 DUES & SUBSCRIPTIONS 0.00 9,025.00
100-5-09110-53-1300 COMPUTERS & SUPPLIES 0.00 337.49
100-5-09110-54-1100 PRINTING 142.86 1,282.54
100-5-09110-54-2110 COMMUNITY EVENTS 0.00 2,688.65
100-5-09110-54-2300 TRAVEL EXPENSE 0.00 673.06
100-5-09110-54-2400 MEALS & EXPENSES 96.78 488.81
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 571,004.69 62,751.74 4,326,973.48 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 2,653,797.42 2,653,797.42 9,443,840.90 9,443,840.90
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
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-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
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.00 1,812.40
______________ ______________ ______________ ______________
TOTAL ASSETS 8.00 0.00 1,812.40 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
210-3-1100 FUND BALANCE 0.00 1,579.24
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 1,579.24
============== ============== ============== ==============
REVENUES
========
210-4-02110-34-7100 COURT TECHNOLOGY FEES 8.00 233.16
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 8.00 0.00 233.16
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 8.00 8.00 1,812.40 1,812.40
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
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.80 12,816.86
______________ ______________ ______________ ______________
TOTAL ASSETS 9.80 0.00 12,816.86 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
215-3-1100 FUND BALANCE 0.00 12,555.65
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 12,555.65
============== ============== ============== ==============
REVENUES
========
215-4-02110-34-7200 COURT SECURITY FEES 9.80 261.21
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 9.80 0.00 261.21
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 9.80 9.80 12,816.86 12,816.86
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
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 2,924.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 2,924.00
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 2,924.00 2,924.00
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
225-SPECIAL EVENTS FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
225-1-1102 CLAIM ON CASH 6,897.26 79,969.38
225-1-1105 ACCOUNTS RECEIVABLE 0.00 12,000.00
______________ ______________ ______________ ______________
TOTAL ASSETS 6,897.26 0.00 12,000.00 79,969.38
============== ============== ============== ==============
LIABILITIES
===========
225-2-2101 AP PENDING (DUE TO POOL CASH) 8,370.37 9,473.11
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 8,370.37 0.00 9,473.11
============== ============== ============== ==============
FUND BALANCE
============
225-3-1100 FUND BALANCE 0.00 122,062.29
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 122,062.29 0.00
============== ============== ============== ==============
REVENUES
========
225-4-01110-60-1001 TRANSFER IN 0.00 50,000.00
225-4-01420-38-3000 TICKET SALES 0.00 38,592.12
225-4-01520-38-3100 SPONSORSHIPS - BOOMIN 4TH 0.00 72,000.00
225-4-01520-38-3200 VENDOR CHARGES 0.00 4,326.50
225-4-01620-38-3100 SPONSORSHIPS - XMAS CORRIDOR 8,000.00 8,000.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 8,000.00 0.00 172,918.62
============== ============== ============== ==============
EXPENDITURES
============
225-5-01110-53-1200 COMPUTER SUPPLIES 0.00 71.07
225-5-01420-51-1300 OVERTIME PAY 0.00 2,503.63
225-5-01420-53-1100 ADVERTISING 22.00 1,621.00
225-5-01420-53-1300 MISCELLANEOUS SUPPLIES 0.00 1,077.17
225-5-01420-54-2110 COMMUNITY EVENTS 0.00 3,047.26
225-5-01520-52-1100 CONTRACT LABOR 0.00 7,275.00
225-5-01520-53-1100 ADVERTISING - BOOMIN 4TH 0.00 62.35
225-5-01520-53-1300 MISCELLANEOUS SUPPLIES 0.00 2,285.52
225-5-01520-54-2110 COMMUNITY EVENTS - BOOMIN 4TH 0.00 71,289.24
225-5-01520-54-2120 EVENT RENTALS - BOOMIN 4TH 0.00 6,925.50
225-5-01620-54-2110 COMMUNITY EVENTS - XMAS CORR 9,451.11 31,875.88
225-5-01620-54-2120 EVENT RENTALS-TRUNK OR TREAT 0.00 265.20
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 9,473.11 0.00 128,298.82 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 16,370.37 16,370.37 262,361.11 262,361.11
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
230-PID #1
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
230-1-1102 CLAIM ON CASH 0.00 66,348.41
230-1-1105 ACCOUNTS RECEIVABLE 0.00 1,673.60
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 68,022.01 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
230-3-1100 FUND BALANCE 0.00 0.84
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 0.84
============== ============== ============== ==============
REVENUES
========
230-4-01420-31-2001 PID #1 ASSESSMENT 0.00 68,021.17
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 68,021.17
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 68,022.01 68,022.01
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
235-AMERICAN RESCUE FUNDS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
235-1-1102 CLAIM ON CASH 307,130.69 307,130.69
______________ ______________ ______________ ______________
TOTAL ASSETS 307,130.69 0.00 307,130.69 0.00
============== ============== ============== ==============
LIABILITIES
===========
235-2-3302 UNEARNED GRANT REVENUE LIABILI 307,130.69 307,130.69
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 307,130.69 0.00 307,130.69
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 307,130.69 307,130.69 307,130.69 307,130.69
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
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 0.02 220.78
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 0.00 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 0.00 171,995.76
310-1-1119 CONSTRUCTION IN PROGRESS 3,009,600.00 9,995,703.84
310-1-1120 SEWER SYSTEM 0.00 3,840,683.35
310-1-1121 ACCUMULATED DEPRECIATION 513,405.85 6,967,802.80
310-1-1123 BUILDINGS 0.00 46,412.97
310-1-1220 DUE FROM OTHER FUNDS 7,737.64 7,737.64
310-1-1305 DEFERRED AMOUNT OF REFUNDING 9,971.88 9,971.88
______________ ______________ ______________ ______________
TOTAL ASSETS 3,017,337.66 523,377.73 25,107,244.38 6,977,774.68
============== ============== ============== ==============
LIABILITIES
===========
310-2-2006 ACCRUED INTEREST PAYABLE 59,492.13 77,626.53
310-2-2100 DUE TO OTHER FUNDS 17,970.02 17,970.02
310-2-5075 2020 REFUNDING DYEGARD 200.00 1,935,950.00
310-2-5076 2020 GO REFUNDING WATER 0.00 239,250.00
310-2-5077 LOAN PAYABLE - 48% OF FW WATER 17,806.80 6,759,497.04
310-2-5078 2021A REFUNDING 0.00 1,736,000.00
310-2-5079 LOAN PAYABLE #2 - FW WATER LIN 3,009,600.00 3,009,600.00
310-2-5150 AUTOMOBILE LEASES 16,498.94 34,341.04
______________ ______________ ______________ ______________
TOTAL LIABILITIES 16,498.94 3,105,068.95 0.00 13,810,234.63
============== ============== ============== ==============
FUND BALANCE
============
310-3-1100 FUND BALANCE 0.00 4,288,117.79
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 4,288,117.79
============== ============== ============== ==============
REVENUES
========
310-4-04110-60-1001 TRANSFER IN 25,924.15 825,253.85
310-4-07000-36-1100 INTEREST REVENUE 0.02 245.42
______________ ______________ ______________ ______________
TOTAL REVENUES 25,924.15 0.02 0.00 825,499.27
============== ============== ============== ==============
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
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.36 28,548.36
310-5-04110-60-1001 TRANSFER OUT-GENERAL FUND 0.00 87,526.99
310-5-04410-58-1100 DEPRECIATION EXPENSE 484,857.49 484,857.49
310-5-07000-60-2100 INTEREST - C.O. SERIES 2012 14,439.72 14,481.67
310-5-07000-60-2400 BOND ISSUANCE COSTS 15,952.27 38,517.14
310-5-07001-60-2100 INTEREST - GEN OBLI 2010 2,150.77 0.00
310-5-07002-60-2100 INTEREST - 2010 CERT OF OBLIG 17,401.73 0.00
310-5-07003-60-2100 INTEREST - 2014 CERT OF OBLIG 2,544.17 12,729.08
310-5-07005-60-2100 INTEREST - LEASES 1,184.16 1,184.16
310-5-07007-60-2100 INTEREST - 2020 CERT OF OBLI 19,216.24 39,168.74
310-5-07008-60-2100 INTEREST - 48% FW WATER LINE 76,391.67 76,391.67
310-5-07009-60-2100 INTEREST - 2021 REFUNDING 10,976.69 10,976.69
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 621,174.61 52,488.66 794,381.99 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 3,680,935.36 3,680,935.36 25,901,626.37 25,901,626.37
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
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 5.04 40,824.17
311-1-1202 TEXSTAR - CAPITAL PROJ RESERVE 0.00 30.00
______________ ______________ ______________ ______________
TOTAL ASSETS 5.04 0.00 40,854.17 0.00
============== ============== ============== ==============
LIABILITIES
===========
311-2-2000 ACCOUNTS PAYABLE 627,266.48 770,040.41
311-2-2100 DUE TO OTHER FUNDS 102,242.46 102,242.46
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 729,508.94 0.00 872,282.87
============== ============== ============== ==============
FUND BALANCE
============
311-3-1100 FUND BALANCE 18.00 0.46
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 18.00 0.00 0.00 0.46
============== ============== ============== ==============
REVENUES
========
311-4-04110-36-1100 INTEREST REVENUE 5.04 110.84
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 5.04 0.00 110.84
============== ============== ============== ==============
EXPENDITURES
============
311-5-04110-54-2522 CONSTRUCTION-CIP 627,248.48 627,248.48
311-5-04120-52-1300 PROFESSIONAL SERVICES 0.00 2,532.66
311-5-04180-54-2520 TRAIL SYSTEM ENGINEERING 102,242.46 201,758.86
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 729,490.94 0.00 831,540.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 729,513.98 729,513.98 872,394.17 872,394.17
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
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.02 103.37
410-1-1305 DEFERRED AMOUNT OF REFUNDING 46,873.87 46,873.87
______________ ______________ ______________ ______________
TOTAL ASSETS 0.02 46,873.87 103.37 46,873.87
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
410-3-1100 FUND BALANCE 0.00 0.53
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.53 0.00
============== ============== ============== ==============
REVENUES
========
410-4-01110-60-1001 TRANSFER IN 25,924.15 806,422.47
410-4-04110-38-1101 BOND PROCEEDS 1,974,000.00 1,974,000.00
410-4-07000-36-1100 INTEREST REVENUE 0.02 131.21
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 1,999,924.17 0.00 2,780,553.68
============== ============== ============== ==============
EXPENDITURES
============
410-5-04110-60-2400 BOND ISSUANCE COSTS 59,794.46 59,794.46
410-5-07000-60-3100 PAYMENT TO REFUNDING ESCROW A 1,993,408.25 1,993,408.25
410-5-07001-60-1100 PRINCIPAL - 2007 CERT OF OBLI 100,000.00 100,000.00
410-5-07001-60-2100 INTEREST - 2007 CERT OF OBLIG 100,000.00 33,620.00
410-5-07002-60-2100 INTEREST - 2010 GO REFUNDING 41,031.25 0.00
410-5-07003-60-1100 PRINCIPAL - 2012 CERT OF OBLI 0.00 47,250.00
410-5-07003-60-2100 INTEREST - 2012 CERT OF OBLIG 6,404.69 11,491.25
410-5-07004-60-1100 PRINCIPAL - 2016A CERT OF OBL 0.00 185,000.00
410-5-07004-60-2100 INTEREST - 2016A CERT OF OBLI 0.00 88,400.00
410-5-07005-60-1100 PRINCIPAL - 2016B CERT OF OBL 0.00 60,000.00
410-5-07005-60-2100 INTEREST - 2016B CERT OF OBLI 0.00 26,642.50
410-5-07006-60-1100 PRINCIPAL - 2018 CERT OF OBLI 0.00 80,000.00
410-5-07006-60-2100 INTEREST - 2018 CERT OF OBLIG 0.00 93,250.00
410-5-07007-60-1100 PRINCIPAL - 2020 CERT OF OBLI 40,000.00 40,000.00
410-5-07007-60-2100 INTEREST - 2020 CERT OF OBLI 1,031.25 2,062.50
410-5-07008-60-2100 INTEREST - 2021 REFUNDING BON 0.00 6,404.69
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 2,194,233.96 147,435.94 2,827,323.65 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 2,194,233.98 2,194,233.98 2,827,427.55 2,827,427.55
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
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-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
505-WATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
505-1-1102 CLAIM ON CASH 104,056.05 998,462.99
505-1-1103 TEXPOOL - ENTERPRISE RESERVE 2.08 92,815.74
505-1-1108 EARNED BUT UNBILLED-WATER 6,776.28 101,573.38
505-1-1197 UNAPPLIED CREDITS 3,015.99 13,470.53
505-1-1198 ALLOWANCE FOR UNCOLLECTABLE 626.09 13,886.63
505-1-1199 ACCOUNTS RECEIVABLE - WATER 47,645.14 115,935.99
505-1-1201 PREPAID EXPENSES 10,420.44 10,015.19
505-1-1220 DUE FROM OTHER FUNDS 17,970.02 17,970.02
505-1-1300 DEFERRED OUTFLOW OF RESOURCES 11,916.00 42,994.80
505-1-1301 DEFERRED OUTFLOWS - OPEB 1,927.00 4,060.00
______________ ______________ ______________ ______________
TOTAL ASSETS 141,777.96 62,577.13 1,383,828.11 27,357.16
============== ============== ============== ==============
LIABILITIES
===========
505-2-2005 COMPENSATED ABSENCES PAYABLE 15,376.75 18,052.01
505-2-2011 RETIREMENT (TMRS PAYABLE) 85.90 602.91
505-2-2012 HEALTH INSURANCE PAYABLE 11.44 530.05
505-2-2013 FLEX ACCOUNT PAYABLE 0.00 529.40
505-2-2015 DEFERRED COMP PAYABLE 2.00 38.00
505-2-2020 UNITED WAY PAYABLE 1.25 16.05
505-2-2024 ACCRUED PAYROLL 1,324.80 6,438.41
505-2-2025 LEADERS LIFE PAYABLE 1.15 21.84
505-2-2028 IMPACT FEES PAYABLE-WFORD 7,204.00 0.00
505-2-2040 RENTER DEPOSITS 1,250.00 9,000.00
505-2-2101 AP PENDING (DUE TO POOL CASH) 56,509.91 56,765.71
505-2-2108 DUE TO WEATHERFORD 0.00 30.00
505-2-2200 DEFERRED INFLOWS OF RESOURCES 34,074.00 82,346.00
505-2-2300 NET PENSION LIABILITY 67,332.00 43,351.00
505-2-2301 OPEB LIABILITY 3,516.00 13,992.00
505-2-4100 FEDERAL WITHHOLDING 386.23 1,061.38
505-2-4200 MEDICARE PAYABLE 15.51 121.24
______________ ______________ ______________ ______________
TOTAL LIABILITIES 91,350.40 95,740.54 0.00 232,896.00
============== ============== ============== ==============
FUND BALANCE
============
505-3-1100 FUND BALANCE 10,699.40 696,327.24
505-3-1101 FUND BALANCE RESTRICTED-IMPACT 10,699.40 226,397.19
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 10,699.40 10,699.40 0.00 922,724.43
============== ============== ============== ==============
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
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 40.00
505-4-04110-36-1120 INTEREST REVENUE 2.08 46.22
505-4-04110-60-1001 TRANSFER IN/DEBT SERVICE 0.00 87,526.99
505-4-04410-34-4100 WATER SALES 152,685.79 1,651,299.10
505-4-04410-34-4110 UTGCD-HUDSON OAKS 3,759.09 38,538.43
505-4-04410-34-4200 SERVICE CHARGES 320.00 3,000.00
505-4-04410-34-4300 RECONNECT FEES 0.00 1,520.00
505-4-04410-34-4400 LATE PAYMENT PENALTIES 1,292.84 10,179.09
505-4-04410-34-4500 WATER IMPACT FEES -COHO 864.02 10,699.40
505-4-04410-34-4600 WATER TAP FEE 1,000.00 5,600.00
505-4-04410-34-4700 METER FEES 960.00 2,845.00
505-4-04410-34-4800 WATER METER FEE 0.00 2,980.50
505-4-04420-38-1100 MISCELLANEOUS REVENUE 0.00 9,613.17
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 160,883.82 0.00 1,823,887.90
============== ============== ============== ==============
EXPENDITURES
============
505-5-04110-51-1100 REGULAR PAY 1,923.95 306,066.86
505-5-04110-51-1300 OVERTIME PAY-P.W. DEPT 2,675.64 24,266.49
505-5-04110-51-2100 MEDICAL INSURANCE-P.W. DEPT 937.48 18,734.09
505-5-04110-51-2120 DENTAL INSURANCE 116.58 2,749.46
505-5-04110-51-2160 LIFE INSURANCE 21.84 420.66
505-5-04110-51-2180 AD&D INSURANCE 2.64 55.52
505-5-04110-51-2200 TMRS-P.W. DEPT 23,439.61 16,991.66
505-5-04110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 4,560.00
505-5-04110-51-2520 MEDICARE TAXES 240.88 4,738.17
505-5-04110-51-2560 WORKERS COMPENSATION 0.00 6,363.05
505-5-04110-52-1100 CONTRACT LABOR 0.00 1,178.88
505-5-04110-52-1200 AUDITING & ACCOUNTING 2,000.00 8,000.00
505-5-04110-52-1300 PROFESSIONAL SERVICES 23,423.08 60,126.29
505-5-04110-52-1400 LEGAL FEES 0.00 2,281.90
505-5-04110-52-1500 EQUIPMENT RENTAL 107.97 1,298.80
505-5-04110-52-1700 WATER SAMPLING 590.10 16,357.54
505-5-04110-53-1100 GENERAL OFFICE SUPPLIES 0.00 2,021.26
505-5-04110-53-1200 COMPUTER SUPPLIES 0.00 3,832.23
505-5-04110-53-1300 MISCELLANEOUS EXPENSE 0.00 2,755.01
505-5-04110-53-1500 UNIFORMS 1,273.77 6,990.73
505-5-04110-53-1700 WATER SYSTEM SUPPLIES 1,522.99 34,264.16
505-5-04110-53-2100 CHEMICALS 1,056.67 7,049.17
505-5-04110-53-2200 METERS & COUPLINGS 5,281.00 40,660.99
505-5-04110-54-1100 PRINTING 562.08 4,290.89
505-5-04110-54-1200 POSTAGE 335.21 3,247.12
505-5-04110-54-1400 BANK CHARGES 1,747.97 19,029.02
505-5-04110-54-2100 SEMINARS & TRAINING 0.00 2,764.72
505-5-04110-54-2300 TRAVEL EXPENSES 18.23 443.23
505-5-04110-54-2400 MEALS & EXPENSES 0.00 808.30
505-5-04110-54-3100 DUES & SUBSCRIPTIONS 0.00 2,290.14
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
505-WATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
505-5-04110-54-4100 TELEPHONE 203.72 6,504.23
505-5-04110-54-4200 ELECTRIC UTILITIES 7.52 741.42
505-5-04110-54-4220 WELL SITE UTILITIES 11,829.30 95,878.71
505-5-04110-54-5100 SOFTWARE MAINTENANCE 8,634.39 29,134.95
505-5-04110-54-5400 GENERAL LIABILITY INSURANCE 0.00 5,982.66
505-5-04110-55-1100 VEHICLE MAINTENANCE 432.51 6,289.15
505-5-04110-55-1200 GAS & OIL 1,379.90 13,061.20
505-5-04110-55-2100 EQUIPMENT MAINTENANCE 0.00 5,097.62
505-5-04110-55-2200 OFFICE EQUIPMENT MAINTENANCE 0.00 151.88
505-5-04110-55-3200 BUILDINGS 0.00 1,683.22
505-5-04110-55-4100 WATER PLANT MAINTENANCE 0.00 22,040.23
505-5-04110-55-4200 WATER DISTRIBUTION REPAIR 0.00 74,204.25
505-5-04110-55-4300 WATER WELL REPAIR 0.00 9,242.90
505-5-04110-60-1001 TRANSFER OUT/DEBT SERVICE 0.00 400,378.00
505-5-04110-60-1200 CAPITAL LEASES - PRINCIPAL 16,498.94 0.00
505-5-04110-60-2200 CAPITAL LEASES - INTEREST 1,471.08 0.00
505-5-04410-54-3200 UTGCD EXPENSE 0.00 37,175.97
505-5-04410-54-3300 REGIONAL WATER PURCHASES 56,500.31 156,101.90
505-5-04410-54-3310 REGIONAL DEMAND FEES 25,788.75 154,732.75
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 138,048.62 51,975.49 1,623,037.38 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 381,876.38 381,876.38 3,006,865.49 3,006,865.49
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
506-DEERCREEK FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
506-1-1102 CLAIM ON CASH 30,276.12 332,473.05
506-1-1240 DUE FROM ANNETTA 57,747.05 60,758.34
506-1-1300 DEFERRED OUTFLOW OF RESOURCES 2,280.00 13,271.20
506-1-1301 DEFERRED OUTFLOWS - OPEB 397.00 1,041.00
______________ ______________ ______________ ______________
TOTAL ASSETS 88,420.17 2,280.00 407,543.59 0.00
============== ============== ============== ==============
LIABILITIES
===========
506-2-2005 COMPENSATED ABSENCES PAYABLE 956.12 7,247.24
506-2-2006 ACCRUED INTEREST PAYABLE 176.20 0.00
506-2-2011 RETIREMENT (TMRS PAYABLE) 30.36 223.69
506-2-2012 HEALTH INSURANCE PAYABLE-DC 57.77 125.40
506-2-2013 FLEX ACCOUNT PAYABLE 0.00 91.87
506-2-2024 ACCRUED PAYROLL-DEER CREEK 301.78 2,497.96
506-2-2101 AP PENDING (DUE TO POOL CASH) 2,183.48 7,317.07
506-2-2200 DEFERRED INFLOWS 6,545.00 21,116.00
506-2-2300 NET PENSION LIABILITY 22,293.00 11,116.00
506-2-2301 OPEB LIABILITY 426.00 3,588.00
506-2-4100 FEDERAL WITHHOLDING 38.09 302.90
506-2-4200 MEDICARE PAYABLE 5.68 45.66
506-2-5150 AUTOMOBILE LEASES 14.67 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 22,483.87 10,544.28 91.87 53,579.92
============== ============== ============== ==============
FUND BALANCE
============
506-3-1100 FUND BALANCE 0.00 220,376.56
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 220,376.56
============== ============== ============== ==============
REVENUES
========
506-4-04410-34-5000 ANNETTA CONTRACT CHARGES 92,185.52 261,741.12
506-4-04410-34-5100 ANNETTA MONTHLY OPERATION 6,725.01 10,314.15
______________ ______________ ______________ ______________
TOTAL REVENUES 6,725.01 92,185.52 0.00 272,055.27
============== ============== ============== ==============
EXPENDITURES
============
506-5-01110-53-1100 GENERAL OFFICE SUPPLIES 0.00 349.98
506-5-04110-51-1100 REGULAR PAY-DEERCREEK 8,259.96 80,979.84
506-5-04110-51-1300 OVERTIME PAY-DEERCREEK 372.62 11,887.93
506-5-04110-51-2100 MEDICAL INSURANCE-ANNETTA 614.76 8,299.26
506-5-04110-51-2120 DENTAL INSURANCE 76.44 1,031.94
506-5-04110-51-2160 LIFE INSURANCE 10.16 137.16
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
506-DEERCREEK FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
506-5-04110-51-2180 AD&D INSURANCE 1.60 21.60
506-5-04110-51-2200 TMRS-ANNETTA 12,343.28 2,011.42
506-5-04110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 1,600.00
506-5-04110-51-2520 MEDICARE TAXES 103.52 1,311.58
506-5-04110-51-2560 WORKERS COMPENSATION 0.00 2,272.51
506-5-04110-52-1300 PROFESSIONAL SERVICES 3,475.00 13,674.75
506-5-04110-52-1500 EQUIPMENT RENTAL-DC 63.45 0.00
506-5-04110-52-1700 WATER SAMPLING-DC 120.00 760.00
506-5-04110-53-1300 MISC SUPPLIES-DEERCREEK 4,008.57 0.00
506-5-04110-53-1500 UNIFORMS-DEERCREEK 176.22 1,023.66
506-5-04110-53-1700 WATER SYSTEM SUPPLIES-DC 2,495.71 0.00
506-5-04110-53-2100 CHEMICALS-DEERCREEK 7,285.45 0.00
506-5-04110-53-2200 METERS & COUPLINGS 55.89 2,334.05
506-5-04110-54-1200 POSTAGE-DEERCREEK 0.00 23.37
506-5-04110-54-2100 SEMINARS & TRAINING 0.00 268.19
506-5-04110-54-5400 GENERAL LIABILITY INSURANCE 0.00 1,600.48
506-5-04110-55-1100 VEHICLE MAINTENANCE 0.00 604.21
506-5-04110-55-1200 GAS & OIL-DEERCREEK 1,059.59 10,225.04
506-5-04110-55-3100 POND MAINTENANCE-SPLITRAIL 0.00 894.50
506-5-04110-55-4100 WATER PLANT MAINTENANCE-DC 1,000.00 1,000.00
506-5-04110-55-4200 WASTEWATER PLANT MAINTENANCE 1,445.90 0.00
506-5-04110-60-2100 INTEREST EXPENSE 190.87 87.66
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 15,269.87 27,889.12 140,387.71 2,011.42
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 132,898.92 132,898.92 548,023.17 548,023.17
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
507-DYEGARD FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
507-1-1102 CLAIM ON CASH 27,881.08 178,917.98
507-1-1108 EARNED BUT UNBILLED-DYEGARD 2,147.54 18,416.75
507-1-1198 ALLOWANCE FOR UNCOLLECTABLE 0.00 1,770.36
507-1-1199 ACCOUNTS RECIEVABLE-DYE-WATER 7,179.34 24,585.33
______________ ______________ ______________ ______________
TOTAL ASSETS 30,028.62 7,179.34 221,920.06 1,770.36
============== ============== ============== ==============
LIABILITIES
===========
507-2-2101 AP PENDING (DUE TO POOL CASH) 1,609.98 1,609.98
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 1,609.98 0.00 1,609.98
============== ============== ============== ==============
FUND BALANCE
============
507-3-1100 FUND BALANCE 0.00 179,770.11
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 179,770.11
============== ============== ============== ==============
REVENUES
========
507-4-04410-34-4100 WATER SALES-DYEGARD 29,168.49 279,677.47
507-4-04410-34-4400 LATE PAYMENT PENALTIES-DYEGARD 203.78 1,758.65
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 29,372.27 0.00 281,436.12
============== ============== ============== ==============
EXPENDITURES
============
507-5-04110-52-1200 AUDITING AND ACCOUNTING-DYEGA 500.00 3,500.00
507-5-04110-52-1300 PROFESSIONAL SERVICES-DYE 750.00 1,232.65
507-5-04110-52-1700 WATER SAMPLING-DYEGARD 273.92 4,516.74
507-5-04110-53-2100 CHEMICALS-DYEGARD 0.00 1,338.57
507-5-04110-53-2200 METERS-DYEGARD 5,491.00 5,491.00
507-5-04110-54-1100 PRINTING-DYEGARD 140.52 1,256.21
507-5-04110-54-1200 POSTAGE-DYEGARD 83.80 167.74
507-5-04110-54-4220 WELL SITE UTILITIES-DYEGARD 573.75 3,813.80
507-5-04110-54-5100 SOFTWARE MAINTENANCE 319.98 1,014.53
507-5-04110-55-2100 EQUIPMENT MAINTENANCE-DYE 0.00 87.27
507-5-04110-55-4100 WATER PLANT MAINTENANCE-DYEGA 0.00 11,448.00
507-5-04110-60-1001 TRANSFER OUT-DYEGARD DEBT 0.00 208,800.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 8,132.97 0.00 242,666.51 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 38,161.59 38,161.59 464,586.57 464,586.57
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
510-WASTEWATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
510-1-1102 CLAIM ON CASH 19,201.37 692,942.67
510-1-1109 EARNED BUT UNBILLED-WASTEWATER 902.06 25,306.62
510-1-1190 A/R - ASSESSMENTS 0.00 65,410.81
510-1-1198 ALLOWANCE FOR UNCOLLECTABLE 260.41 663.96
510-1-1199 ACCOUNTS RECEIVABLE - SEWER 857.25 26,493.43
510-1-1202 TEXSTAR - WASTEWATER RESERVE 3.36 418,164.08
______________ ______________ ______________ ______________
TOTAL ASSETS 20,964.04 260.41 1,228,317.61 663.96
============== ============== ============== ==============
LIABILITIES
===========
510-2-2000 ACCOUNTS PAYABLE-AUDIT ACCRUAL 23,808.37 23,808.37
510-2-2028 SEWER IMPACT FEES PAYABLE 3,071.00 6,142.00
510-2-2101 AP PENDING (DUE TO POOL CASH) 21,580.63 21,580.63
______________ ______________ ______________ ______________
TOTAL LIABILITIES 3,071.00 45,389.00 0.00 51,531.00
============== ============== ============== ==============
FUND BALANCE
============
510-3-1100 FUND BALANCE 0.00 1,177,900.41
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 1,177,900.41
============== ============== ============== ==============
REVENUES
========
510-4-04110-36-1120 INTEREST REVENUE 3.36 157.28
510-4-04510-34-5100 WASTEWATER CHARGES 38,504.71 446,026.00
510-4-04510-34-6100 SEWER TAP FEE 500.00 1,500.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 39,008.07 0.00 447,683.28
============== ============== ============== ==============
EXPENDITURES
============
510-5-04110-52-1300 PROFESSIONAL SERVICES 4,560.00 4,560.00
510-5-04410-60-1001 TRANSFER OUT/DEBT SERVICE 0.00 56,000.00
510-5-04510-54-2100 WASTEWATER TREATMENT SERVICES 47,091.08 156,779.22
510-5-04510-54-2520 WASTEWATER ENGINEERING 4,680.00 4,680.00
510-5-04510-54-4200 ELECTRIC UTILITIES 491.36 6,278.50
510-5-04510-55-4202 SEWER MAINTENANCE 3,800.00 35,163.32
510-5-04510-60-1001 TRANSFER OUT/DEBT SERVICE 0.00 186,000.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 60,622.44 0.00 449,461.04 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 84,657.48 84,657.48 1,677,778.65 1,677,778.65
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
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,932.86 11,407.68
515-1-1198 ALLOWANCE FOR UNCOLLECTABLE 0.00 88.06
515-1-1199 ACCOUNTS RECEIVABLE - SW 516.07 13,072.33
______________ ______________ ______________ ______________
TOTAL ASSETS 8,932.86 516.07 24,480.01 88.06
============== ============== ============== ==============
LIABILITIES
===========
515-2-2013 SOLID WASTE PAYABLE 8,415.68 23,268.63
515-2-2014 SALES TAX PAYABLE - SW 1.11 1,123.32
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 8,416.79 0.00 24,391.95
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 8,932.86 8,932.86 24,480.01 24,480.01
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
520-STORMWATER UTILITY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
520-1-1101 STORMWATER DEBT SERVICE 0.87 7,057.24
520-1-1102 CLAIM ON CASH 16,124.77 310,273.37
520-1-1108 EARNED BUT UNBILLED-STORMWATER 165.69 10,811.93
520-1-1116 EQUIPMENT 12,875.00 12,875.00
520-1-1118 INFRASTRUCTURE 546,817.70 546,817.70
520-1-1119 CONSTRUCTION IN PROGRESS 546,817.70 0.00
520-1-1121 ACCUMULATED DEPRECIATION 643.74 643.74
520-1-1198 ALLOWANCE FOR UNCOLLECTIBLE 136.30 1,172.66
520-1-1199 ACCOUNTS RECEIVABLE 64.60 10,873.30
______________ ______________ ______________ ______________
TOTAL ASSETS 576,048.63 547,597.74 898,708.54 1,816.40
============== ============== ============== ==============
LIABILITIES
===========
520-2-2006 ACCRUED INTEREST PAYABLE 625.01 1,787.50
520-2-2030 SERIES 2016 A BONDS 0.00 435,000.00
520-2-2031 SERIES 2016 A PREMIUM 1,039.50 15,332.62
______________ ______________ ______________ ______________
TOTAL LIABILITIES 1,664.51 0.00 0.00 452,120.12
============== ============== ============== ==============
FUND BALANCE
============
520-3-1100 FUND BALANCE 0.00 263,669.10
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 263,669.10
============== ============== ============== ==============
REVENUES
========
520-4-04110-34-6000 STORMWATER FEE 16,218.76 193,520.40
520-4-07000-36-1100 INTEREST REVENUE 0.87 11.75
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 16,219.63 0.00 193,532.15
============== ============== ============== ==============
EXPENDITURES
============
520-5-04110-53-1300 MISCELLANEOUS EXPENSE 12,875.00 0.00
520-5-04110-56-4300 STREET REPAIRS 0.00 2,100.00
520-5-04110-60-2200 DEBT SERVICE - INTEREST 1,664.51 9,685.49
520-5-04410-58-1100 DEPRECIATION EXPENSE 643.74 643.74
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 643.74 14,539.51 12,429.23 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 578,356.88 578,356.88 911,137.77 911,137.77
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
610-PRIVATE PURPOSE TRUST
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
610-1-1102 CLAIM ON CASH 0.00 1,124.99
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 1,124.99 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
610-4-01110-34-3000 FIDUCIARY INCOME 0.00 25,179.90
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 25,179.90
============== ============== ============== ==============
EXPENDITURES
============
610-5-01110-52-2220 FIDUCIARY EXPENSES 0.00 24,054.91
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 24,054.91 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 25,179.90 25,179.90
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
710-INTERNAL SERVICE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
710-1-1100 CASH & CASH EQUIVALENTS 190.78 5,673.33
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 190.78 5,673.33 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
710-3-1100 FUND BALANCE 0.00 10,283.23
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 10,283.23
============== ============== ============== ==============
REVENUES
========
710-4-01110-34-3000 HEALTH CHARGES 0.00 25,000.00
710-4-01110-36-1100 INTEREST REVENUE 1.72 11.66
710-4-07000-36-1100 INTEREST REVENUE 1.02 0.00
______________ ______________ ______________ ______________
TOTAL REVENUES 1.02 1.72 0.00 25,011.66
============== ============== ============== ==============
EXPENDITURES
============
710-5-01110-51-2220 HEALTH CARD AGREEMENT 0.00 10.00
710-5-01110-51-2230 INSURANCE REIMBURSEMENTS 191.48 29,611.56
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 191.48 0.00 29,621.56 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 192.50 192.50 35,294.89 35,294.89
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
800-GENERAL FIXED ASSETS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
800-1-1200 LAND 0.00 942,382.40
800-1-1300 BUILDINGS 328,186.13 2,894,560.69
800-1-1400 AUTOMOBILES 50,173.10 363,513.48
800-1-1500 BUILDING IMPROVEMENTS 0.00 267,429.69
800-1-1600 EQUIPMENT 59,388.00 511,105.44
800-1-1700 OFFICE EQUIPMENT 0.00 22,373.11
800-1-1800 INFRASTRUCTURE 3,366,227.84 15,986,509.42
800-1-1900 FURNITURES & FIXTURES 0.00 5,511.05
800-1-1950 CONSTRUCTION IN PROGRESS 2,596,608.50 294,422.65
800-1-2000 ACCUMULATED DEPRECIATION 601,641.76 5,112,446.92
______________ ______________ ______________ ______________
TOTAL ASSETS 3,803,975.07 3,198,250.26 21,287,807.93 5,112,446.92
============== ============== ============== ==============
LIABILITIES
===========
800-2-2000 INVESTMENT IN CAPITAL ASSETS 1,207,366.57 18,571,032.96
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 1,207,366.57 0.00 18,571,032.96
============== ============== ============== ==============
FUND BALANCE
============
800-3-1100 FUND BALANCE 0.00 1,794,030.19
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 1,794,030.19 0.00
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
800-5-01110-51-2100 DEPRECIATION EXPENSE 143,046.62 143,046.62
800-5-03110-51-2100 DEPRECIATION EXPENSE 85,961.66 85,961.66
800-5-04110-51-2100 DEPRECIATION EXPENSE 372,633.48 372,633.48
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 601,641.76 0.00 601,641.76 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 4,405,616.83 4,405,616.83 23,683,479.88 23,683,479.88
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
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 445,869.59 8,552,199.22
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 445,869.59 8,552,199.22 0.00
============== ============== ============== ==============
LIABILITIES
===========
900-2-2100 2007 CERTIFICATES OF OBLIG 100,000.00 720,000.00
900-2-2130 CO SERIES 2016 A 185,000.00 3,380,000.00
900-2-2131 CO SERIES 2016 A PREMIUM 7,938.50 117,092.92
900-2-2150 2018 CERT OF OBLIGATION PID 70,000.00 1,805,000.00
900-2-2151 2018 PID PREMIUM 4,931.50 81,369.75
900-2-2160 2018 CERT OF OBLIGATION FIBER 10,000.00 320,000.00
900-2-2161 2018 ADDITION FIBER PREMIUM 870.31 14,360.16
900-2-2170 2020 GO REFUNDING 40,000.00 85,000.00
900-2-2180 2021A REFUNDING 0.00 644,000.00
900-2-2190 2021B REFUNDING 0.00 1,330,000.00
900-2-2300 VEHICLE LEASES 20,850.04 50,962.91
900-2-2400 EQUIPMENT LEASES 6,279.24 4,413.48
______________ ______________ ______________ ______________
TOTAL LIABILITIES 445,869.59 0.00 0.00 8,552,199.22
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 445,869.59 445,869.59 8,552,199.22 8,552,199.22
============== ============== ============== ==============
*** END OF REPORT ***
2-21-2022 08:19 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2021
999-POOL CASH
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
999-1-1099 POOL CASH 412,203.86 3,248,531.19
999-1-1100 DUE FROM GENERAL FUND 104,265.67 174,809.63
999-1-1225 DUE FROM SPECIAL EVENTS 8,370.37 9,473.11
999-1-1505 DUE FROM WATER FUND 56,509.93 56,765.73
999-1-1506 DUE FROM DEERCREEK 2,183.48 7,317.07
999-1-1507 DUE FROM DYEGARD 1,609.98 1,609.98
999-1-1510 DUE FROM WASTEWATER FUND 21,580.63 21,580.63
______________ ______________ ______________ ______________
TOTAL ASSETS 606,723.92 0.00 3,520,087.34 0.00
============== ============== ============== ==============
LIABILITIES
===========
999-2-2000 ACCOUNTS PAYABLE 194,520.06 271,556.15
999-2-2100 DUE TO OTHER FUNDS 412,203.86 3,248,531.19
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 606,723.92 0.00 3,520,087.34
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 606,723.92 606,723.92 3,520,087.34 3,520,087.34
============== ============== ============== ==============
*** END OF REPORT ***