12-03-2023 02:05 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
100-1-1102 CLAIM ON CASH 826,116.61 257,624.42
100-1-1106 CASH ON HAND 0.00 200.00
100-1-1107 FRANCHISE TAX RECEIVABLE 0.00 91,519.45
100-1-1108 SALES TAX RECEIVABLE 7,711.06 762,178.72
100-1-1113 POOLED CASH CD 0.00 231,479.57
100-1-1190 COURT FINES RECEIVABLE 16,375.92 169,952.00
100-1-1191 ALLOWANCE FOR UNCOLLECTABLE-CT 8,529.16 135,961.60
100-1-1192 A/R - ASSESSMENTS 115,009.73 298,870.43
100-1-1196 MISC RECIEVABLES 5,500.00 82,929.09
100-1-1200 TEXPOOL - GENERAL RESERVE 477.40 109,616.26
100-1-1201 PREPAID EXPENSES 24,082.06 0.00
100-1-1202 TEXSTAR - GENERAL RESERVE 512,736.83 3,013,942.80
100-1-1234 DUE FROM NEXTLINK 81,520.00 95,712.31
100-1-1250 LEASE RECEIVABLE 130,295.65 1,486,065.35
100-1-1300 PROPERTY INVESTMENTS 0.00 283,132.00
100-1-1901 EQUIPMENT 587.96 0.00
100-1-5200 TEXPOOL - SALES TAX RESERVE 771.81 177,222.41
______________ ______________ ______________ ______________
TOTAL ASSETS 617,834.22 1,111,879.97 7,060,444.81 135,961.60
============== ============== ============== ==============
LIABILITIES
===========
100-2-2000 ACCOUNTS PAYABLE CONTROL 26,543.57 26,543.57
100-2-2001 ACCOUNTS PAYABLE - 1999 186,532.43 26,476.57
100-2-2018 DUE TO SPLASH KINGDOM 0.00 844.35
100-2-2023 DUE TO OMNIBASE 24.00 7.74
100-2-2101 AP PENDING (DUE TO POOL CASH) 186,068.29 259,094.28
100-2-2102 DUE TO STATE-COURT COSTS 0.00 2,865.39
100-2-3300 DEFERRED REVENUE 36,723.65 520,140.37
100-2-3301 DEFERRED ASSESSMENTS REVENUE 115,009.73 298,870.43
100-2-3303 DEFERRED REVENUE - LEASES 130,295.65 1,486,065.35
100-2-4100 FEDERAL WITHHOLDING 901.22 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 431,861.81 250,236.73 0.00 2,620,908.05
============== ============== ============== ==============
FUND BALANCE
============
100-3-1100 FUND BALANCE 15,994.89 3,288,024.15
100-3-1103 RESTRICTED FUND BALANCE-PEG 0.00 9,982.00
100-3-1104 NONSPENDABLE FUND BALANCE 15,994.89 0.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 15,994.89 15,994.89 0.00 3,298,006.15
============== ============== ============== ==============
12-03-2023 02:05 PM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
REVENUES
========
100-4-01420-31-1100 LOCAL SALES & USE TAX 336,297.78 4,604,045.80
100-4-01420-31-1120 MIXED BEVERAGES TAX 1,756.90 21,857.23
100-4-01420-31-1130 OPIOID SETTLEMENT REVENUES 0.00 4,908.94
100-4-01420-31-2000 PAYMENT IN LIEU OF TAXES 0.00 187,180.00
100-4-01420-31-2100 FRANCHISE FEES 12,416.89 231,351.72
100-4-01420-32-3100 ALCOHOLIC BEVERAGE PERMITS 1,582.50 2,597.50
100-4-01420-36-1100 INTEREST REVENUE 85,501.67 240,464.18
100-4-01420-38-1100 MISCELLANEOUS REVENUE 13,530.76 44,471.61
100-4-01420-38-1200 CREDIT CARD REVENUE-MISC (FEE 0.00 108.43
100-4-01420-38-2000 ROADWAY ASSESSMENTS 0.00 115,009.73
100-4-01420-39-4120 T-MOBILE GROUND LEASE 9,544.50 12,417.00
100-4-01620-34-1150 CONTRACTOR REGISTRATION FEE 5,200.00 7,150.00
100-4-02110-35-1100 TRAFFIC FINES 0.00 6,338.51
100-4-02110-35-1200 ARREST FEES 0.00 139.86
100-4-02110-35-1300 COURT ADMINISTRATIVE FEES 0.00 9.90
100-4-02110-35-1400 WARRANT FEES 0.00 681.03
100-4-02110-35-1500 COURT SPECIAL EXPENSE FEE 0.00 74.60
100-4-02110-35-1600 TFC FEES 0.00 23.24
100-4-02110-35-1700 JFCI REVENUE 0.00 6.00
100-4-02110-35-1900 CREDIT CARD REVENUE-COURT 0.00 228.96
100-4-02110-35-2000 DUE FROM ANNETTA - COURT 0.00 250.00
100-4-03110-34-2201 MISCELLANEOUS REVENUE-POLICE 0.00 445.00
100-4-03410-33-4100 TCLEOSE EDUCATION ALLOWANCE 1,880.00 1,028.81
100-4-03410-33-4102 ESD#3 BUILDING LEASE 8,529.64 63,529.64
100-4-06110-32-3200 BUILDING PERMITS 160,586.68 468,396.98
100-4-06110-32-3300 OCCUPANCY PERMITS 2,100.00 3,150.00
100-4-06110-32-3400 SIGN PERMITS 4,853.74 6,030.89
100-4-06110-32-3420 BILLBOARD PERMITS 1,200.00 1,250.00
100-4-06210-34-1100 PLAT FEES 0.00 3,154.00
100-4-06210-34-1110 DEVELOPMENT REVIEW FEES 0.00 5,810.50
100-4-06310-32-3600 SEPTIC PERMITS 920.00 2,300.00
100-4-06310-32-3700 HEALTH PERMITS 2,575.00 18,000.00
100-4-08000-61-1220 PROCEEDS FROM SALE OF ASSETS 0.00 10,426.50
100-4-08000-61-2140 INSURANCE PROCEEDS 28,929.00 28,929.00
______________ ______________ ______________ ______________
TOTAL REVENUES 170,131.18 507,273.88 0.00 6,091,765.56
============== ============== ============== ==============
EXPENDITURES
============
100-5-01110-51-1100 REGULAR PAY 38,833.54 498,268.83
100-5-01110-51-1300 OVERTIME PAY 0.00 2,723.06
100-5-01110-51-2100 MEDICAL INSURANCE 1,610.70 19,574.49
100-5-01110-51-2120 DENTAL INSURANCE 198.02 2,527.35
100-5-01110-51-2160 LIFE INSURANCE 57.92 678.28
100-5-01110-51-2180 AD&D INSURANCE 12.80 92.80
100-5-01110-51-2200 TMRS 4,779.16 59,991.38
100-5-01110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 15,000.00
100-5-01110-51-2520 MEDICARE TAXES 1,462.86 8,966.16
12-03-2023 02:05 PM CITY OF HUDSON OAKS PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
100-5-01110-51-2540 UNEMPLOYMENT INSURANCE 0.00 247.15
100-5-01110-51-2560 WORKER'S COMPENSATION 0.00 9,097.95
100-5-01110-51-2570 EMPLOYEE FITNESS PROGRAM 417.05 3,760.55
100-5-01110-52-1200 AUDITING & ACCOUNTING 0.00 4,966.67
100-5-01110-52-1300 PROFESSIONAL SERVICES 13,141.58 66,202.67
100-5-01110-52-1400 LEGAL FEES 7,244.92 36,015.80
100-5-01110-52-1500 EQUIPMENT RENTAL 0.00 1,170.00
100-5-01110-52-1620 HEALTH INSPECTIONS 5,890.00 23,270.00
100-5-01110-53-1100 GENERAL OFFICE SUPPLIES 3,225.91 10,799.96
100-5-01110-53-1200 COMPUTER SUPPLIES 599.00 3,181.94
100-5-01110-53-1300 MISCELLANEOUS SUPPLIES 1,405.42 2,870.14
100-5-01110-53-1301 MISCELLANEOUS EXPENSE 0.00 3,025.92
100-5-01110-54-1100 PRINTING 0.00 2,678.46
100-5-01110-54-1200 POSTAGE 0.00 1,252.60
100-5-01110-54-1400 BANK FEES 3.00 43.45
100-5-01110-54-2100 SEMINARS & TRAINING 0.00 6,141.25
100-5-01110-54-2110 COMMUNITY EVENTS 0.00 4,353.53
100-5-01110-54-2300 TRAVEL EXPENSE 0.00 7,627.91
100-5-01110-54-2400 MEALS & EXPENSES 46.80 3,311.51
100-5-01110-54-2500 CASH OVER/SHORT 0.06 0.00
100-5-01110-54-3100 DUES & SUBSCRIPTIONS 525.00 14,426.52
100-5-01110-54-4100 TELEPHONE 850.68 9,590.44
100-5-01110-54-4200 ELECTRIC UTILITIES 1,159.43 9,572.05
100-5-01110-54-5000 ECON DEV AGREEMENTS 70,661.36 179,213.97
100-5-01110-54-5100 SOFTWARE MAINTENANCE 26,273.36 130,402.16
100-5-01110-54-5400 GENERAL LIABILITY INSURANCE 0.00 6,900.39
100-5-01110-55-2200 OFFICE EQUIPMENT MAINTENANCE 0.00 16.99
100-5-01110-56-1200 OFFICE MACHINES 211.62 2,535.57
100-5-01110-60-1001 TRANSFER OUT - PID/FIBER 7,227.08 86,724.96
100-5-01110-60-1002 TRANSFER OUT-SPECIAL EVENTS 0.00 100,000.00
100-5-01210-54-1300 ADVERTISING & LEGAL NOTICES 1,450.45 4,895.75
100-5-01210-54-1310 FILING FEES 0.00 1,289.97
100-5-01310-54-1400 ELECTION COSTS 0.00 4,581.01
100-5-02110-51-1100 REGULAR PAY 2,204.10 27,989.89
100-5-02110-51-2100 MEDICAL INSURANCE 137.08 1,576.42
100-5-02110-51-2120 DENTAL INSURANCE 13.90 173.75
100-5-02110-51-2160 LIFE INSURANCE 4.06 50.75
100-5-02110-51-2180 AD&D INSURANCE 1.60 12.80
100-5-02110-51-2200 TMRS 276.62 3,454.67
100-5-02110-51-2520 MEDICARE TAXES 31.20 418.38
100-5-02110-51-2560 WORKER'S COMPENSATION 0.00 494.46
100-5-02110-52-1300 PROFESSIONAL SERVICES 1,715.00 10,130.00
100-5-02110-54-5100 SOFTWARE MAINTENANCE 1.50 8,480.03
100-5-02110-54-5400 GENERAL LIABILITY INSURANCE 0.00 132.96
100-5-03110-51-1100 REGULAR PAY 67,224.95 828,633.32
100-5-03110-51-1300 OVERTIME PAY 9,952.19 82,809.64
100-5-03110-51-1900 CERTIFICATION PAY 655.48 8,608.94
100-5-03110-51-2100 MEDICAL INSURANCE 4,070.40 44,669.53
100-5-03110-51-2120 DENTAL INSURANCE 416.88 5,054.02
100-5-03110-51-2160 LIFE INSURANCE 121.92 1,254.57
12-03-2023 02:05 PM CITY OF HUDSON OAKS PAGE: 4
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
100-5-03110-51-2180 AD&D INSURANCE 44.00 308.32
100-5-03110-51-2200 TMRS 9,768.00 113,592.72
100-5-03110-51-2520 MEDICARE TAXES 1,067.52 13,036.21
100-5-03110-51-2560 WORKER'S COMPENSATION 0.00 19,184.85
100-5-03110-52-1100 CONTRACT LABOR 3,360.00 46,827.03
100-5-03110-52-1200 AUDITING & ACCOUNTING 0.00 4,966.67
100-5-03110-52-1300 PROFESSIONAL SVCS - PUB SAFET 49.10 81.09
100-5-03110-53-1100 GENERAL OFFICE SUPPLIES 714.31 3,931.61
100-5-03110-53-1200 COMPUTER SUPPLIES 0.00 2,057.81
100-5-03110-53-1300 MISCELLANEOUS EXPENSE 266.91 3,244.50
100-5-03110-53-1400 AMMUNITION 0.00 2,026.57
100-5-03110-53-1500 UNIFORMS 2,107.97 14,938.26
100-5-03110-54-1100 PRINTING 0.00 750.71
100-5-03110-54-1200 POSTAGE 0.00 182.93
100-5-03110-54-2100 SEMINARS & TRAINING 2,000.00 7,368.24
100-5-03110-54-2300 TRAVEL EXPENSES 116.07 235.09
100-5-03110-54-3100 DUES & SUBSCRIPTIONS 0.00 1,060.75
100-5-03110-54-4100 TELEPHONE 850.68 9,449.71
100-5-03110-54-4200 ELECTRIC UTILITIES 1,933.83 16,502.71
100-5-03110-54-5100 SOFTWARE MAINTENANCE 1,061.16 40,716.71
100-5-03110-54-5400 GENERAL LIABILITY INSURANCE 0.00 31,171.78
100-5-03110-54-6100 INMATE HOUSING 0.00 141.00
100-5-03110-54-6200 DISPATCHER 0.00 77,048.00
100-5-03110-54-6300 CRIME LAB FEES 55.00 285.00
100-5-03110-55-1100 VEHICLE MAINTENANCE 7,678.17 12,181.31
100-5-03110-55-1200 GAS & OIL 2,932.54 27,178.25
100-5-03110-55-2100 EQUIPMENT MAINTENANCE 0.00 2,856.96
100-5-03110-55-2200 OFFICE EQUIPMENT MAINTENANCE 0.00 1,747.47
100-5-03110-56-2200 VEHICLES 0.00 21,145.36
100-5-03110-56-2300 PUBLIC SAFETY BUILDING 50,638.89 62,917.93
100-5-03110-60-1200 CAPITAL LEASE - PRINCIPAL 2,000.00 31,828.85
100-5-03110-60-2200 CAPITAL LEASE - INTEREST 0.00 1,533.67
100-5-04110-51-1100 REGULAR PAY 98.69 8,327.30
100-5-04110-51-2100 MEDICAL INSURANCE 8.37 724.44
100-5-04110-51-2120 DENTAL INSURANCE 0.85 78.63
100-5-04110-51-2160 LIFE INSURANCE 0.25 13.83
100-5-04110-51-2180 AD&D INSURANCE 0.10 2.88
100-5-04110-51-2200 TMRS 12.39 1,017.08
100-5-04110-51-2520 MEDICARE TAXES 1.43 128.06
100-5-04110-51-2560 WORKERS COMPENSATION 0.00 799.36
100-5-04110-53-1200 COMPUTER SUPPLIES 0.00 318.00
100-5-04110-53-1300 MISCELLANEOUS EXPENSE 220.08 818.84
100-5-04110-53-1500 UNIFORMS 13.98 40.98
100-5-04110-54-5400 GENERAL LIABILITY INSURANCE 0.00 2,471.50
100-5-04110-60-1001 TRANSFER OUT DEBT SERVICE 53,111.36 652,336.32
100-5-04110-60-1002 TRANSFER OUT - GEN CAP PROJ 0.00 650,000.00
100-5-04210-52-1300 PROFESSIONAL SERVICES 840.00 74,356.88
100-5-04210-52-1500 EQUIPMENT RENTAL 0.00 4,982.69
100-5-04210-54-4200 ELECTRIC UTILITIES 705.32 9,131.13
100-5-04210-56-4100 STREET SIGNS 0.00 272.73
12-03-2023 02:05 PM CITY OF HUDSON OAKS PAGE: 5
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
100-5-04210-56-4200 STREET IMPROVEMENTS 50,606.09 272,083.84
100-5-04210-56-4300 STREET REPAIRS 47,142.72 52,063.36
100-5-05110-51-1100 REGULAR PAY 98.69 31,238.26
100-5-05110-51-1300 OVERTIME PAY 0.00 2,591.29
100-5-05110-51-2100 MEDICAL INSURANCE 8.37 1,872.44
100-5-05110-51-2120 DENTAL INSURANCE 0.85 234.97
100-5-05110-51-2160 LIFE INSURANCE 0.25 59.57
100-5-05110-51-2180 DENTAL, LIFE, AD&D INS-FACILI 0.10 10.08
100-5-05110-51-2200 TMRS 12.39 4,133.81
100-5-05110-51-2520 MEDICARE TAXES 1.43 520.11
100-5-05110-52-1300 PROFESSIONAL SERVICES 3,302.25 6,777.25
100-5-05110-53-1100 GENERAL OFFICE SUPPLIES 0.00 95.74
100-5-05110-53-1300 MISCELLANEOUS SUPPLIES 229.77 6,709.33
100-5-05110-54-3100 DUES & SUBSCRIPTIONS 0.00 487.39
100-5-05110-54-5400 GENERAL LIABILITY INSURANCE 0.00 13.20
100-5-05110-55-2100 EQUIPMENT MAINTENANCE 0.00 3,735.93
100-5-05110-55-3100 GROUNDSKEEPING 14,212.31 73,884.94
100-5-05110-55-3200 BUILDING MAINTENANCE 857.04 26,882.97
100-5-06110-52-1300 PROFESSIONAL SERVICES 45,575.10 49,205.04
100-5-06110-52-1600 BUILDING INSPECTIONS 75,317.68 201,930.08
100-5-06110-54-3100 DUES & SUBSCRIPTIONS 0.00 1,799.02
100-5-09110-53-1300 COMPUTERS & SUPPLIES 0.00 329.87
100-5-09110-53-1500 UNIFORMS 380.66 380.66
100-5-09110-54-2110 COMMUNITY EVENTS 0.00 168.18
100-5-09110-54-2400 MEALS & EXPENSES 46.10 608.99
100-5-09110-54-5100 SOFTWARE MAINTENANCE 0.00 127.79
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 651,563.37 2,000.00 5,086,196.55 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 1,887,385.47 1,887,385.47 12,146,641.36 12,146,641.36
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:05 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
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 ***
12-03-2023 02:05 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
210-COURT TECHNOLOGY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
210-1-1102 CLAIM ON CASH 0.00 2,078.53
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 2,078.53 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
210-3-1100 FUND BALANCE 0.00 1,943.54
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 1,943.54
============== ============== ============== ==============
REVENUES
========
210-4-02110-34-7100 COURT TECHNOLOGY FEES 0.00 134.99
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 134.99
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 2,078.53 2,078.53
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:05 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
215-COURT SECURITY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
215-1-1102 CLAIM ON CASH 0.00 13,104.87
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 13,104.87 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
215-3-1100 FUND BALANCE 0.00 12,966.11
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 12,966.11
============== ============== ============== ==============
REVENUES
========
215-4-02110-34-7200 COURT SECURITY FEES 0.00 138.76
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 138.76
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 13,104.87 13,104.87
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:05 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
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 ***
12-03-2023 02:05 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
225-SPECIAL EVENTS FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
225-1-1102 CLAIM ON CASH 1,539.24 5,617.98
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 1,539.24 5,617.98 0.00
============== ============== ============== ==============
LIABILITIES
===========
225-2-2101 AP PENDING (DUE TO POOL CASH) 3,927.82 5,028.23
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 3,927.82 0.00 5,028.23
============== ============== ============== ==============
FUND BALANCE
============
225-3-1100 FUND BALANCE 0.00 40,532.34
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 40,532.34
============== ============== ============== ==============
REVENUES
========
225-4-01110-60-1001 TRANSFER IN FROM GENERAL FUND 0.00 100,000.00
225-4-01420-38-3000 TICKET SALES - CRAFT & CORK 0.00 14,328.15
225-4-01420-38-3100 SPONSORSHIPS - CRAFT & CORK 0.00 1,598.10
225-4-01520-38-3100 SPONSORSHIPS - BOOMIN 4TH 0.00 32,950.00
225-4-01520-38-3200 VENDOR CHARGES 1,675.00 1,725.00
225-4-01620-38-3100 SPONSORSHIPS - XMAS CORRIDOR 0.00 4,250.00
225-4-01820-38-3100 SPONSORSHIPS - EASTER 0.00 3,930.00
225-4-04110-36-1100 INTEREST REVENUE 15.17 496.61
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 1,690.17 0.00 159,277.86
============== ============== ============== ==============
EXPENDITURES
============
225-5-01110-51-2100 MEDICAL INSURANCE 0.00 177.81
225-5-01110-51-2120 DENTAL INSURANCE 0.00 18.02
225-5-01110-51-2160 LIFE INSURANCE 0.00 5.27
225-5-01110-51-2180 AD&D INSURANCE 0.00 2.08
225-5-01110-51-2200 TMRS 0.00 431.54
225-5-01110-51-2520 MEDICARE TAXES 0.00 47.45
225-5-01110-54-1100 PRINTING 0.00 283.69
225-5-01110-56-1300 OTHER OFFICE EQUIPMENT 0.00 36.80
225-5-01420-51-1300 OVERTIME PAY 0.00 3,438.68
225-5-01420-53-1300 MISCELLANEOUS SUPPLIES 0.00 4,371.93
225-5-01420-54-2110 COMMUNITY EVENTS - CRAFT & CO 0.00 50,460.22
225-5-01420-54-2120 EVENT RENTALS - CRAFT AND COR 0.00 550.00
225-5-01520-52-1100 CONTRACT LABOR 0.00 5,730.00
225-5-01520-53-1100 ADVERTISING - BOOMIN 4TH 0.00 793.68
225-5-01520-53-1300 MISCELLANEOUS SUPPLIES 0.00 763.84
12-03-2023 02:05 PM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
225-SPECIAL EVENTS FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
225-5-01520-54-2110 COMMUNITY EVENTS - BOOMIN 4TH 2,129.00 103,397.17
225-5-01520-54-2120 EVENT RENTALS - BOOMIN 4TH 0.00 2,217.72
225-5-01620-54-2110 COMMUNITY EVENTS - XMAS CORR 5,028.23 20,156.01
225-5-01620-54-2111 EVENTS RENTALS - XMAS CORR 0.00 1,240.78
225-5-01620-54-2120 EVENT RENTALS-TRUNK OR TREAT 0.00 558.12
225-5-01820-54-2110 COMMUNITY EVENTS - EASTER 0.00 4,539.64
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 7,157.23 0.00 199,220.45 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 7,157.23 7,157.23 204,838.43 204,838.43
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:05 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
230-PID #1
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
230-1-1102 CLAIM ON CASH 185,068.06 205,544.91
230-1-1105 ACCOUNTS RECEIVABLE 0.00 1,661.61
______________ ______________ ______________ ______________
TOTAL ASSETS 185,068.06 0.00 207,206.52 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
230-3-1100 FUND BALANCE 0.00 3,372.41
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 3,372.41
============== ============== ============== ==============
REVENUES
========
230-4-01420-31-2001 PID #1 ASSESSMENT 0.00 68,216.72
230-4-04110-36-1100 INTEREST REVENUE 68.06 663.52
230-4-04110-38-1101 BOND PROCEEDS 0.00 1,215,000.00
230-4-04110-38-1102 PREMIUMS/DISCOUNTS 0.00 83,414.63
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 68.06 0.00 1,367,294.87
============== ============== ============== ==============
EXPENDITURES
============
230-5-04110-54-2530 CONSTRUCTION - HEB PUBLIC IMPR 185,000.00 1,060,890.00
230-5-04110-60-1001 TRANSFER OUT 0.00 68,000.00
230-5-04110-60-2400 BOND ISSUANCE COSTS 0.00 34,570.76
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 185,000.00 1,163,460.76 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 185,068.06 185,068.06 1,370,667.28 1,370,667.28
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:05 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
235-AMERICAN RESCUE FUNDS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
235-1-1102 CLAIM ON CASH 0.00 615,475.35
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 615,475.35 0.00
============== ============== ============== ==============
LIABILITIES
===========
235-2-3302 UNEARNED GRANT REVENUE LIABILI 0.00 615,475.35
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 0.00 615,475.35
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 615,475.35 615,475.35
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:05 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
310-UTILITY CAPITAL PROJECTS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
310-1-1102 CLAIM ON CASH 63,885.13 53,907.13
310-1-1112 PCUD REGIONAL BUY-IN COSTS 0.00 787,885.71
310-1-1113 LAND 0.00 1,541,779.86
310-1-1114 WATER PLANT 146,877.00 4,480,366.13
310-1-1115 WATER DISTRIBUTION 10,881,877.15 16,084,362.68
310-1-1116 EQUIPMENT 0.00 158,537.27
310-1-1117 OFFICE EQUIPMENT 0.00 2,224.46
310-1-1118 AUTOMOBILES 0.00 171,995.76
310-1-1119 CONSTRUCTION IN PROGRESS 10,787,327.15 241,427.00
310-1-1120 SEWER SYSTEM 0.00 3,840,683.35
310-1-1121 ACCUMULATED DEPRECIATION 660,402.00 8,140,896.31
310-1-1123 BUILDINGS 0.00 46,412.97
310-1-1305 DEFERRED AMOUNT OF REFUNDING 0.00 9,971.88
______________ ______________ ______________ ______________
TOTAL ASSETS 11,092,639.28 11,447,729.15 27,409,582.32 8,150,868.19
============== ============== ============== ==============
LIABILITIES
===========
310-2-2006 ACCRUED INTEREST PAYABLE 9,767.81 40,105.03
310-2-2101 AP PENDING (DUE TO POOL CASH) 1,783.80 1,783.80
310-2-5075 2020 REFUNDING DYEGARD 0.00 1,588,450.00
310-2-5076 2020 GO REFUNDING WATER 0.00 196,550.00
310-2-5077 LOAN PAYABLE - 48% OF FW WATER 0.00 6,306,283.44
310-2-5078 2021A REFUNDING 0.00 1,176,250.00
310-2-5079 LOAN PAYABLE #2 - FW WATER LIN 0.00 3,009,600.00
310-2-5080 SERIES 2023 BOND 0.00 895,000.00
310-2-5081 SERIES 2023 PREMIUMS 0.00 63,504.96
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 11,551.61 0.00 13,277,527.23
============== ============== ============== ==============
FUND BALANCE
============
310-3-1100 FUND BALANCE 0.00 6,264,157.64
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 6,264,157.64
============== ============== ============== ==============
REVENUES
========
310-4-04110-60-1001 TRANSFER IN - DEBT 72,698.17 872,378.04
310-4-04110-60-1002 TRANSFER IN - CAPITAL 97,881.33 552,298.68
310-4-07000-36-1100 INTEREST REVENUE 281.64 0.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 170,861.14 0.00 1,424,676.72
============== ============== ============== ==============
12-03-2023 02:05 PM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
310-UTILITY CAPITAL PROJECTS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
EXPENDITURES
============
310-5-04110-55-4400 AMI SYSTEM 132,667.19 0.00
310-5-04110-58-1200 AMORTIZATION EXPENSE 28,548.36 28,548.36
310-5-04110-60-1001 TRANSFER OUT-GENERAL FUND 0.00 832,602.15
310-5-04410-58-1100 DEPRECIATION EXPENSE 631,853.64 631,853.64
310-5-07000-60-2400 BOND ISSUANCE COSTS 0.00 26,319.30
310-5-07001-60-1100 GEN OBLIG 2010 9,767.81 9,767.81
310-5-07005-60-2100 INTEREST - LEASES 0.00 507.74
310-5-07007-60-2100 INTEREST - 2020 CERT OF OBLI 0.00 32,740.00
310-5-07008-60-2100 INTEREST - 48% FW WATER LINE 0.00 108,094.80
310-5-07009-60-2100 INTEREST - 2021 REFUNDING 0.00 22,756.44
310-5-07010-60-2100 INTEREST - SERIES 2023 CO 0.00 14,457.22
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 670,169.81 132,667.19 1,707,647.46 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 11,762,809.09 11,762,809.09 29,117,229.78 29,117,229.78
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:06 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
311-GENERAL CAPITAL PROJECTS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
311-1-1102 CLAIM ON CASH 155.81 47,032.95
311-1-1202 TEXSTAR - CAPITAL PROJ RESERVE 0.06 30.63
311-1-1203 TEXSTAR - 2023 CO 6,714.90 1,545,144.52
______________ ______________ ______________ ______________
TOTAL ASSETS 6,870.77 0.00 1,592,208.10 0.00
============== ============== ============== ==============
LIABILITIES
===========
311-2-2000 ACCOUNTS PAYABLE 45,668.19 241,457.40
______________ ______________ ______________ ______________
TOTAL LIABILITIES 45,668.19 0.00 0.00 241,457.40
============== ============== ============== ==============
FUND BALANCE
============
311-3-1100 FUND BALANCE 0.00 570,558.92
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 570,558.92 0.00
============== ============== ============== ==============
REVENUES
========
311-4-04110-36-1100 INTEREST REVENUE 6,870.77 27,751.99
311-4-04110-37-1100 CONTRIBUTIONS 45,668.19 45,668.19
311-4-04110-38-1101 BOND PROCEEDS 0.00 1,990,000.00
311-4-04110-38-1102 BOND PREMIUMS/DISCOUNTS 0.00 136,621.48
311-4-04110-60-1001 TRANSFER IN/GENERAL FUND 0.00 650,000.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 52,538.96 0.00 2,850,041.66
============== ============== ============== ==============
EXPENDITURES
============
311-5-04110-60-2400 BOND ISSUANCE COSTS 0.00 56,622.06
311-5-05110-56-3100 PROPERTY 0.00 317,353.98
311-5-05110-56-3300 GREYSTAR ROAD IMPROVEMENTS 0.00 554,756.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 928,732.04 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 52,538.96 52,538.96 3,091,499.06 3,091,499.06
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:06 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
410-GENERAL DEBT SERVICE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
410-1-1102 CLAIM ON CASH 60,410.19 21,657.53
______________ ______________ ______________ ______________
TOTAL ASSETS 60,410.19 0.00 21,657.53 0.00
============== ============== ============== ==============
LIABILITIES
===========
410-2-2006 ACCRUED INTEREST PAYABLE 0.00 10,684.53
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 0.00 10,684.53
============== ============== ============== ==============
FUND BALANCE
============
410-3-1100 FUND BALANCE 0.00 95,332.70
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 95,332.70
============== ============== ============== ==============
REVENUES
========
410-4-01110-60-1001 TRANSFER IN 60,338.44 807,061.28
410-4-07000-36-1100 INTEREST REVENUE 71.75 1,565.47
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 60,410.19 0.00 808,626.75
============== ============== ============== ==============
EXPENDITURES
============
410-5-07000-60-1099 BOND PAYING AGENT FEES 0.00 400.00
410-5-07000-60-2100 DEBT SERVICE INTEREST 0.00 800.00
410-5-07001-60-1100 PRINCIPAL - 2007 CERT OF OBLI 0.00 110,000.00
410-5-07001-60-2100 INTEREST - 2007 CERT OF OBLIG 0.00 25,215.00
410-5-07004-60-1100 PRINCIPAL - 2016A CERT OF OBL 0.00 195,000.00
410-5-07004-60-2100 INTEREST - 2016A CERT OF OBLI 0.00 77,625.00
410-5-07006-60-1100 PRINCIPAL - 2018 CERT OF OBLI 0.00 90,000.00
410-5-07006-60-2100 INTEREST - 2018 CERT OF OBLIG 0.00 84,750.00
410-5-07007-60-1100 PRINCIPAL - 2020 CERT OF OBLI 0.00 40,000.00
410-5-07007-60-2100 INTEREST - 2020 CERT OF OBLI 0.00 990.00
410-5-07008-60-1100 2021 REFUNDING PRINCIPAL 0.00 75,000.00
410-5-07008-60-2100 INTEREST - 2021 REFUNDING BON 0.00 23,886.25
410-5-07009-60-1100 PRINCIPAL - 2021A GO 0.00 57,750.00
410-5-07009-60-2100 INTEREST - 2021A GO 0.00 4,575.06
410-5-07010-60-1100 SERIES 2023 CO - PRINCIPAL 0.00 65,000.00
410-5-07010-60-2100 SERIES 2023 CO - INTEREST 0.00 41,995.14
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 892,986.45 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 60,410.19 60,410.19 914,643.98 914,643.98
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:06 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
505-WATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
505-1-1102 CLAIM ON CASH 480,684.28 263,190.16
505-1-1103 TEXPOOL - ENTERPRISE RESERVE 425.96 97,800.82
505-1-1108 EARNED BUT UNBILLED-WATER 13,629.46 114,767.27
505-1-1197 UNAPPLIED CREDITS 633.07 13,924.76
505-1-1198 ALLOWANCE FOR UNCOLLECTABLE 2,158.91 25,949.56
505-1-1199 ACCOUNTS RECEIVABLE - WATER 8,875.37 186,322.79
505-1-1201 PREPAID EXPENSES 5,708.92 0.00
505-1-1203 TEXSTAR - 2023 BOND CO 128,894.18 846,150.02
505-1-1250 DUE FROM WILLOW PARK 20,242.03 75,232.60
505-1-1300 DEFERRED OUTFLOW OF RESOURCES 6,300.00 47,018.00
505-1-1301 DEFERRED OUTFLOWS - OPEB 2,197.00 2,294.00
______________ ______________ ______________ ______________
TOTAL ASSETS 520,690.65 149,058.53 1,632,775.66 39,874.32
============== ============== ============== ==============
LIABILITIES
===========
505-2-2005 COMPENSATED ABSENCES PAYABLE 6,959.18 35,394.78
505-2-2028 IMPACT FEES PAYABLE-WFORD 78,518.00 56,890.00
505-2-2029 IMPACT FEES PAYABLE- FTW 16,480.00 10,536.00
505-2-2040 RENTER DEPOSITS 750.00 11,250.00
505-2-2101 AP PENDING (DUE TO POOL CASH) 338,287.55 352,412.31
505-2-2200 DEFERRED INFLOWS OF RESOURCES 149,847.00 35,381.00
505-2-2300 NET PENSION LIABILITY 121,627.00 127,721.00
505-2-2301 OPEB LIABILITY 9,254.00 6,478.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 176,331.00 545,391.73 45,917.00 590,146.09
============== ============== ============== ==============
FUND BALANCE
============
505-3-1100 FUND BALANCE 799.92 169,300.29
505-3-1101 FUND BALANCE RESTRICTED-IMPACT 0.00 288,974.37
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 799.92 0.00 458,274.66
============== ============== ============== ==============
REVENUES
========
505-4-04110-34-9100 RETURNED CHECK FEE 0.00 100.00
505-4-04110-36-1120 INTEREST REVENUE 3,844.63 20,069.96
505-4-04110-60-1001 TRANSFER IN/DEBT SERVICE 0.00 832,602.15
505-4-04410-34-4100 WATER SALES 242,709.96 1,803,002.36
505-4-04410-34-4110 UTGCD-HUDSON OAKS 6,752.21 43,653.73
505-4-04410-34-4200 SERVICE CHARGES 200.00 1,960.00
505-4-04410-34-4300 RECONNECT FEES 0.00 720.00
505-4-04410-34-4400 LATE PAYMENT PENALTIES 1,859.70 11,156.35
505-4-04410-34-4500 WATER IMPACT FEES -COHO 13,798.52 23,282.10
505-4-04410-34-4600 WATER TAP FEE 4,000.00 7,500.00
505-4-04410-34-4700 METER FEES 5,005.00 8,783.00
12-03-2023 02:06 PM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
505-WATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
505-4-04420-38-1100 MISCELLANEOUS REVENUE 0.00 16,493.60
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 278,170.02 0.00 2,769,323.25
============== ============== ============== ==============
EXPENDITURES
============
505-5-04110-51-1100 REGULAR PAY 33,268.90 253,721.72
505-5-04110-51-1300 OVERTIME PAY-P.W. DEPT 2,583.47 37,262.01
505-5-04110-51-2100 MEDICAL INSURANCE-P.W. DEPT 2,347.88 15,241.60
505-5-04110-51-2120 DENTAL INSURANCE 238.00 1,953.12
505-5-04110-51-2160 LIFE INSURANCE 49.28 477.73
505-5-04110-51-2180 AD&D INSURANCE 17.40 114.24
505-5-04110-51-2200 TMRS-P.W. DEPT 25,350.90 6,176.73
505-5-04110-51-2520 MEDICARE TAXES 409.91 4,135.21
505-5-04110-51-2560 WORKERS COMPENSATION 0.00 6,683.38
505-5-04110-52-1200 AUDITING & ACCOUNTING 0.00 4,966.66
505-5-04110-52-1300 PROFESSIONAL SERVICES 57,341.25 85,545.72
505-5-04110-52-1500 EQUIPMENT RENTAL 0.00 2,209.09
505-5-04110-52-1660 WELL TANK INSPECTIONS 0.00 2,500.00
505-5-04110-52-1700 WATER SAMPLING 120.00 6,375.21
505-5-04110-53-1100 GENERAL OFFICE SUPPLIES 0.00 941.60
505-5-04110-53-1200 COMPUTER SUPPLIES 0.00 179.99
505-5-04110-53-1300 MISCELLANEOUS EXPENSE 1,559.63 8,160.66
505-5-04110-53-1500 UNIFORMS 478.55 5,995.42
505-5-04110-53-1700 WATER SYSTEM SUPPLIES 9,686.50 72,810.79
505-5-04110-53-2100 CHEMICALS 1,705.91 12,112.17
505-5-04110-53-2200 METERS & COUPLINGS 5,557.19 33,760.83
505-5-04110-54-1100 PRINTING 453.00 4,795.68
505-5-04110-54-1200 POSTAGE 400.82 5,832.27
505-5-04110-54-1400 BANK CHARGES 4,606.54 40,841.27
505-5-04110-54-2100 SEMINARS & TRAINING 0.00 100.00
505-5-04110-54-2400 MEALS & EXPENSES 0.00 421.16
505-5-04110-54-3100 DUES & SUBSCRIPTIONS 113.75 1,410.09
505-5-04110-54-4100 TELEPHONE 850.69 5,801.06
505-5-04110-54-4200 ELECTRIC UTILITIES 190.38 1,599.36
505-5-04110-54-4220 WELL SITE UTILITIES 6,274.88 119,468.16
505-5-04110-54-5100 SOFTWARE MAINTENANCE 2,850.60 46,348.54
505-5-04110-54-5400 GENERAL LIABILITY INSURANCE 0.00 6,899.95
505-5-04110-55-1100 VEHICLE MAINTENANCE 2,639.48 10,323.76
505-5-04110-55-1200 GAS & OIL 2,425.68 16,320.36
505-5-04110-55-2100 EQUIPMENT MAINTENANCE 0.00 7,743.31
505-5-04110-55-2200 OFFICE EQUIPMENT MAINTENANCE 0.00 126.29
505-5-04110-55-3200 BUILDINGS 0.00 17,328.57
505-5-04110-55-4100 WATER PLANT MAINTENANCE 0.00 22,031.11
505-5-04110-55-4110 WATER PLANT IMPROVEMENTS 0.00 12,415.00
505-5-04110-55-4200 WATER DISTRIBUTION REPAIR 4,737.82 4,737.82
505-5-04110-55-4300 WATER WELL REPAIR 0.00 8,516.00
505-5-04110-56-2200 VEHICLES 11.99 273.72
505-5-04110-60-1001 TRANSFER OUT/DEBT SERVICE 39,045.07 468,540.84
505-5-04110-60-1002 TRANSFER OUT - CAPITAL 0.00 454,417.35
505-5-04410-54-3200 UTGCD EXPENSE 0.00 34,191.06
12-03-2023 02:06 PM CITY OF HUDSON OAKS PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
505-WATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
505-5-04410-54-3300 REGIONAL WATER PURCHASES 110,532.56 186,477.40
505-5-04410-54-3310 REGIONAL DEMAND FEES 28,067.90 140,641.65
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 310,157.24 33,758.69 2,178,925.66 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 1,007,178.89 1,007,178.89 3,857,618.32 3,857,618.32
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:06 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
506-DEERCREEK FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
______________ ______________ ______________ ______________
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:06 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
507-DYEGARD FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
507-1-1102 CLAIM ON CASH 16,209.23 246,851.32
507-1-1108 EARNED BUT UNBILLED-DYEGARD 985.25 20,565.82
507-1-1198 ALLOWANCE FOR UNCOLLECTABLE 75.22 2,399.24
507-1-1199 ACCOUNTS RECIEVABLE-DYE-WATER 2,785.54 35,359.05
______________ ______________ ______________ ______________
TOTAL ASSETS 19,980.02 75.22 302,776.19 2,399.24
============== ============== ============== ==============
LIABILITIES
===========
507-2-2101 AP PENDING (DUE TO POOL CASH) 610.46 610.46
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 610.46 0.00 610.46
============== ============== ============== ==============
FUND BALANCE
============
507-3-1100 FUND BALANCE 0.00 234,620.42
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 234,620.42
============== ============== ============== ==============
REVENUES
========
507-4-04410-34-4100 WATER SALES-DYEGARD 43,621.89 308,509.50
507-4-04410-34-4400 LATE PAYMENT PENALTIES-DYEGARD 351.70 2,461.13
507-4-04410-34-4500 WATER IMPACT FEES-DYEGARD 0.00 517.38
507-4-04410-34-4700 METER FEES-DYEGARD 0.00 199.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 43,973.59 0.00 311,687.01
============== ============== ============== ==============
EXPENDITURES
============
507-5-04110-52-1200 AUDITING AND ACCOUNTING-DYEGA 0.00 1,000.00
507-5-04110-52-1300 PROFESSIONAL SERVICES-DYE 0.00 2,696.65
507-5-04110-52-1660 WELL TANK INSPECTIONS & REPAI 0.00 900.00
507-5-04110-52-1700 WATER SAMPLING-DYEGARD 40.00 240.00
507-5-04110-53-1700 WATER SYSTEM SUPPLIES-DYEGARD 0.00 253.95
507-5-04110-53-2100 CHEMICALS-DYEGARD 0.00 1,691.89
507-5-04110-53-2200 METERS-DYEGARD 0.00 3,738.16
507-5-04110-54-1100 PRINTING-DYEGARD 113.25 1,177.98
507-5-04110-54-1200 POSTAGE-DYEGARD 100.20 1,115.78
507-5-04110-54-4220 WELL SITE UTILITIES-DYEGARD 6,949.81 17,186.00
507-5-04110-54-5100 SOFTWARE MAINTENANCE 590.46 2,449.67
507-5-04110-55-4100 WATER PLANT MAINTENANCE-DYEGA 0.00 11,464.50
507-5-04110-60-1001 TRANSFER OUT-DYEGARD DEBT 16,885.53 202,626.36
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 24,679.25 0.00 246,540.94 0.00
============== ============== ============== ==============
12-03-2023 02:06 PM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
507-DYEGARD FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 44,659.27 44,659.27 549,317.13 549,317.13
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:06 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
510-WASTEWATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
510-1-1102 CLAIM ON CASH 35,060.80 291,828.57
510-1-1109 EARNED BUT UNBILLED-WASTEWATER 2,760.58 34,017.66
510-1-1190 A/R - ASSESSMENTS 0.00 65,410.81
510-1-1198 ALLOWANCE FOR UNCOLLECTABLE 46.37 853.89
510-1-1199 ACCOUNTS RECEIVABLE - SEWER 3,568.34 7,331.27
510-1-1202 TEXSTAR - WASTEWATER RESERVE 775.23 178,387.38
______________ ______________ ______________ ______________
TOTAL ASSETS 38,596.61 3,614.71 576,975.69 853.89
============== ============== ============== ==============
LIABILITIES
===========
510-2-2000 ACCOUNTS PAYABLE-AUDIT ACCRUAL 0.60 0.00
510-2-2028 SEWER IMPACT FEES PAYABLE 51,885.75 53,573.75
510-2-2101 AP PENDING (DUE TO POOL CASH) 3,020.00 3,020.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.60 54,905.75 0.00 56,593.75
============== ============== ============== ==============
FUND BALANCE
============
510-3-1100 FUND BALANCE 0.00 419,096.97
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 419,096.97
============== ============== ============== ==============
REVENUES
========
510-4-04110-36-1120 INTEREST REVENUE 1,578.19 11,415.42
510-4-04410-37-1200 CONTRACT LABOR - ALEDO ISD 0.00 54,000.00
510-4-04410-37-1201 REIMBURSEABLE EXP - ALEDO ISD 0.00 2,595.10
510-4-04510-34-5100 WASTEWATER CHARGES 15,617.11 483,943.41
510-4-04510-34-6100 SEWER TAP FEE 1,500.00 3,000.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 18,695.30 0.00 554,953.93
============== ============== ============== ==============
EXPENDITURES
============
510-5-04110-52-1300 PROFESSIONAL SERVICES 2,790.00 0.00
510-5-04110-52-1700 WASTEWATER SAMPLING 3,577.00 3,577.00
510-5-04110-53-1700 WASTEWATER SYSTEM SUPPLIES 0.00 215.00
510-5-04510-34-5101 WASTEWATER EXP - ALEDO ISD 1,300.00 3,695.00
510-5-04510-54-2100 WASTEWATER TREATMENT SERVICES 15,173.63 141,861.49
510-5-04510-54-2520 WASTEWATER ENGINEERING 94,050.00 0.00
510-5-04510-54-4200 ELECTRIC UTILITIES 759.02 5,602.19
510-5-04510-55-4202 SEWER MAINTENANCE 0.00 480.00
510-5-04510-60-1001 TRANSFER OUT/DEBT SERVICE 16,767.57 201,210.84
510-5-04510-60-2100 CAPITAL OUTLAY TRANSFER OUT 97,881.33 97,881.33
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 135,458.55 96,840.00 454,522.85 0.00
============== ============== ============== ==============
12-03-2023 02:06 PM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
510-WASTEWATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 174,055.76 174,055.76 1,031,498.54 1,031,498.54
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:06 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
515-SOLID WASTE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
515-1-1102 CLAIM ON CASH 2,056.14 18,604.71
515-1-1198 ALLOWANCE FOR UNCOLLECTABLE 0.00 88.06
515-1-1199 ACCOUNTS RECEIVABLE - SW 258.66 14,060.44
______________ ______________ ______________ ______________
TOTAL ASSETS 2,056.14 258.66 32,665.15 88.06
============== ============== ============== ==============
LIABILITIES
===========
515-2-2013 SOLID WASTE PAYABLE 1,781.52 31,377.64
515-2-2014 SALES TAX PAYABLE - SW 15.96 1,199.45
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 1,797.48 0.00 32,577.09
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 2,056.14 2,056.14 32,665.15 32,665.15
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:06 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
520-STORMWATER UTILITY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
520-1-1102 CLAIM ON CASH 22,421.63 1,103,524.41
520-1-1108 EARNED BUT UNBILLED-STORMWATER 15.88 11,106.99
520-1-1116 EQUIPMENT 0.00 12,875.00
520-1-1118 INFRASTRUCTURE 236,791.06 783,608.76
520-1-1119 CONSTRUCTION IN PROGRESS 193,406.56 0.00
520-1-1121 ACCUMULATED DEPRECIATION 33,957.38 37,176.08
520-1-1198 ALLOWANCE FOR UNCOLLECTIBLE 429.55 1,853.90
520-1-1199 ACCOUNTS RECEIVABLE 2,116.89 8,947.42
______________ ______________ ______________ ______________
TOTAL ASSETS 259,228.57 229,910.38 1,920,062.58 39,029.98
============== ============== ============== ==============
LIABILITIES
===========
520-2-2006 ACCRUED INTEREST PAYABLE 4,816.66 8,787.75
520-2-2030 SERIES 2016 A BONDS 0.00 385,000.00
520-2-2031 SERIES 2016 A PREMIUM 0.00 13,253.62
520-2-5080 SERIES 2023 CO 0.00 665,000.00
520-2-5081 SERIES 2023 PREMIUM 0.00 46,684.73
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 4,816.66 0.00 1,118,726.10
============== ============== ============== ==============
FUND BALANCE
============
520-3-1100 FUND BALANCE 0.00 629,433.58
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 629,433.58
============== ============== ============== ==============
REVENUES
========
520-4-04110-34-6000 STORMWATER FEE 16,269.79 201,662.29
520-4-07000-36-1100 INTEREST REVENUE 3,621.28 7,190.08
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 19,891.07 0.00 208,852.37
============== ============== ============== ==============
EXPENDITURES
============
520-5-04110-53-1300 MISCELLANEOUS EXPENSE 0.00 19,348.24
520-5-04110-55-4500 DRAINAGE SYSTEM REPAIRS 43,384.50 0.00
520-5-04110-60-2200 DEBT SERVICE - INTEREST 4,816.66 22,673.83
520-5-04410-58-1100 DEPRECIATION EXPENSE 33,957.38 33,957.38
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 38,774.04 43,384.50 75,979.45 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 298,002.61 298,002.61 1,996,042.03 1,996,042.03
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:06 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
611-TRASH TRUST FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
611-1-1100 TRASH TRUST FUND CASH 180.15 85,025.29
______________ ______________ ______________ ______________
TOTAL ASSETS 180.15 0.00 85,025.29 0.00
============== ============== ============== ==============
LIABILITIES
===========
611-2-2100 AMOUNTS HELD FOR OTHER CITIES 0.00 90,297.94
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 0.00 90,297.94
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
611-4-01420-36-1100 INTEREST REVENUE 180.15 1,560.20
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 180.15 0.00 1,560.20
============== ============== ============== ==============
EXPENDITURES
============
611-5-01110-52-1400 LEGAL FEES 0.00 6,832.85
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 6,832.85 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 180.15 180.15 91,858.14 91,858.14
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:06 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
710-INTERNAL SERVICE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
710-1-1100 CASH & CASH EQUIVALENTS 337.11 1,710.19
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 337.11 1,710.19 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
710-3-1100 FUND BALANCE 0.00 269.79
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 269.79
============== ============== ============== ==============
REVENUES
========
710-4-01110-34-3000 HEALTH CHARGES 0.00 15,000.00
710-4-01110-36-1100 INTEREST REVENUE 3.71 168.06
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 3.71 0.00 15,168.06
============== ============== ============== ==============
EXPENDITURES
============
710-5-01110-51-2230 INSURANCE REIMBURSEMENTS 340.82 13,727.66
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 340.82 0.00 13,727.66 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 340.82 340.82 15,437.85 15,437.85
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:06 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
720-VEHICLE REPLACEMENT FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:06 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
800-GENERAL FIXED ASSETS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
800-1-1200 LAND 320,853.98 1,263,236.38
800-1-1300 BUILDINGS 0.00 2,894,560.69
800-1-1400 AUTOMOBILES 62,197.87 335,155.71
800-1-1500 BUILDING IMPROVEMENTS 49,400.00 316,829.69
800-1-1600 EQUIPMENT 0.00 511,105.44
800-1-1700 OFFICE EQUIPMENT 0.00 22,373.11
800-1-1800 INFRASTRUCTURE 1,934,702.56 17,921,211.98
800-1-1900 FURNITURES & FIXTURES 0.00 5,511.05
800-1-1950 CONSTRUCTION IN PROGRESS 617,406.65 22,675.00
800-1-2000 ACCUMULATED DEPRECIATION 693,245.99 6,552,881.92
______________ ______________ ______________ ______________
TOTAL ASSETS 2,304,956.54 1,372,850.51 23,292,659.05 6,552,881.92
============== ============== ============== ==============
LIABILITIES
===========
800-2-2000 INVESTMENT IN CAPITAL ASSETS 1,687,549.89 20,638,081.95
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 1,687,549.89 0.00 20,638,081.95
============== ============== ============== ==============
FUND BALANCE
============
800-3-1100 FUND BALANCE 0.00 3,142,860.96
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 3,142,860.96 0.00
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
800-5-01110-51-2100 DEPRECIATION EXPENSE 246,649.25 246,649.25
800-5-03110-51-2100 DEPRECIATION EXPENSE 68,778.14 68,778.14
800-5-04110-51-2100 DEPRECIATION EXPENSE 440,016.47 440,016.47
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 755,443.86 0.00 755,443.86 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 3,060,400.40 3,060,400.40 27,190,963.87 27,190,963.87
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:06 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
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 3,360,036.11 10,755,138.62
______________ ______________ ______________ ______________
TOTAL ASSETS 3,360,036.11 0.00 10,755,138.62 0.00
============== ============== ============== ==============
LIABILITIES
===========
900-2-2100 2007 CERTIFICATES OF OBLIG 0.00 505,000.00
900-2-2130 CO SERIES 2016 A 0.00 2,995,000.00
900-2-2131 CO SERIES 2016 A PREMIUM 0.00 101,215.92
900-2-2150 2018 CERT OF OBLIGATION PID 0.00 1,660,000.00
900-2-2151 2018 PID PREMIUM 0.00 71,506.75
900-2-2160 2018 CERT OF OBLIGATION FIBER 0.00 290,000.00
900-2-2161 2018 ADDITION FIBER PREMIUM 0.00 12,619.54
900-2-2180 2021A REFUNDING 0.00 533,750.00
900-2-2190 2021B REFUNDING 0.00 1,175,000.00
900-2-2191 2023 CERT OF OBLIGATION 1,950,000.00 1,950,000.00
900-2-2192 2023 CO - PID PORTION 1,190,000.00 1,190,000.00
900-2-2193 2023 BOND PREMIUMS 220,036.11 220,036.11
900-2-2300 VEHICLE LEASES 0.00 51,010.30
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 3,360,036.11 0.00 10,755,138.62
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 3,360,036.11 3,360,036.11 10,755,138.62 10,755,138.62
============== ============== ============== ==============
*** END OF REPORT ***
12-03-2023 02:06 PM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2023
999-POOL CASH
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
999-1-1099 POOL CASH 38,295.42 3,152,554.28
999-1-1100 DUE FROM GENERAL FUND 186,068.29 259,094.28
999-1-1225 DUE FROM SPECIAL EVENTS 3,927.82 5,028.23
999-1-1505 DUE FROM WATER FUND 338,287.55 352,412.31
999-1-1507 DUE FROM DYEGARD 610.46 610.46
999-1-1510 DUE FROM WASTEWATER FUND 3,020.00 3,020.00
999-1-3100 DUE FROM UTIL CAP PROJECTS 1,783.80 1,783.80
______________ ______________ ______________ ______________
TOTAL ASSETS 571,993.34 0.00 3,774,503.36 0.00
============== ============== ============== ==============
LIABILITIES
===========
999-2-2000 ACCOUNTS PAYABLE 533,697.92 621,949.08
999-2-2100 DUE TO OTHER FUNDS 38,295.42 3,152,554.28
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 571,993.34 0.00 3,774,503.36
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 571,993.34 571,993.34 3,774,503.36 3,774,503.36
============== ============== ============== ==============
*** END OF REPORT ***