11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
100-1-1102 CLAIM ON CASH 137,145.13 305,453.51
100-1-1106 CASH ON HAND 0.00 200.00
100-1-1107 FRANCHISE TAX RECEIVABLE 2,821.04 119,717.89
100-1-1108 SALES TAX RECEIVABLE 84,543.14 846,721.86
100-1-1111 RETURNED CHECKS 19,612.56 0.00
100-1-1113 POOLED CASH CD 0.00 232,504.59
100-1-1115 PILOT RECEIVABLE 0.00 17,490.00
100-1-1190 COURT FINES RECEIVABLE 165.21 168,502.72
100-1-1191 ALLOWANCE FOR UNCOLLECTABLE-CT 1,159.42 137,121.02
100-1-1192 A/R - ASSESSMENTS 38,714.63 260,155.80
100-1-1196 MISC RECIEVABLES 53,050.08 141,256.21
100-1-1200 TEXPOOL - GENERAL RESERVE 488.59 115,606.08
100-1-1201 PREPAID EXPENSES 9,224.50 9,224.50
100-1-1202 TEXSTAR - GENERAL RESERVE 13,345.89 3,178,020.37
100-1-1234 DUE FROM NEXTLINK 61,275.00 61,275.00
100-1-1250 LEASE RECEIVABLE 107,904.84 1,378,160.51
100-1-1300 PROPERTY INVESTMENTS 0.00 304,000.00
100-1-5200 TEXPOOL - SALES TAX RESERVE 789.92 186,906.58
______________ ______________ ______________ ______________
TOTAL ASSETS 362,848.50 167,391.45 7,325,195.62 137,121.02
============== ============== ============== ==============
LIABILITIES
===========
100-2-2001 ACCOUNTS PAYABLE - 1999 71,680.04 71,680.04
100-2-2011 RETIREMENT (TMRS PAYABLE) 4,296.00 0.09
100-2-2012 HEALTH INSURANCE PAYABLE 3,617.69 0.00
100-2-2013 FLEX ACCOUNT PAYABLE 383.59 0.00
100-2-2014 CHILD SUPPORT PAYABLE 624.48 900.64
100-2-2015 DEFERRED COMP PAYABLE 255.00 0.00
100-2-2016 DENTAL/VISION PAYABLE 348.87 0.00
100-2-2018 DUE TO SPLASH KINGDOM 0.00 3,832.05
100-2-2020 UNITED WAY PAYABLE 30.00 0.00
100-2-2021 ACCRUED PAYROLL-GEN FUND 46,760.29 0.00
100-2-2023 DUE TO OMNIBASE 12.00 13.73
100-2-2025 LEADERS LIFE PAYABLE 17.23 0.00
100-2-2101 AP PENDING (DUE TO POOL CASH) 401,214.26 471,524.53
100-2-2102 DUE TO STATE-COURT COSTS 298.80 2,045.78
100-2-2104 DUE TO OGM GROUP 41.55 0.00
100-2-2107 DUE TO POLICE OFFICE ASSOC 100.00 0.00
100-2-3300 DEFERRED REVENUE 24,452.52 521,065.46
100-2-3301 DEFERRED ASSESSMENTS REVENUE 38,714.63 260,155.80
100-2-3303 DEFERRED REVENUE - LEASES 107,904.84 1,378,160.51
100-2-3304 DEFERRED REVENUE - PILOT 0.00 17,490.00
100-2-4100 FEDERAL WITHHOLDING 9,135.15 937.74
100-2-4200 MEDICARE PAYABLE 832.17 992.64
______________ ______________ ______________ ______________
TOTAL LIABILITIES 237,824.81 472,894.30 0.00 2,728,799.01
============== ============== ============== ==============
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
FUND BALANCE
============
100-3-1100 FUND BALANCE 3.13 4,239,175.00
100-3-1103 RESTRICTED FUND BALANCE-PEG 0.00 9,982.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 3.13 0.00 4,249,157.00
============== ============== ============== ==============
REVENUES
========
100-4-01420-31-1100 LOCAL SALES & USE TAX 497,235.95 4,634,490.10
100-4-01420-31-1120 MIXED BEVERAGES TAX 2,139.14 20,006.84
100-4-01420-31-1130 OPIOID SETTLEMENT REVENUES 0.00 955.00
100-4-01420-31-2000 PAYMENT IN LIEU OF TAXES 0.00 491,403.88
100-4-01420-31-2100 FRANCHISE FEES 55,927.51 285,690.39
100-4-01420-31-2200 IN-KIND PEG FEES 0.00 149.80
100-4-01420-32-3100 ALCOHOLIC BEVERAGE PERMITS 0.00 1,377.50
100-4-01420-36-1100 INTEREST REVENUE 79,691.57 258,404.17
100-4-01420-38-1100 MISCELLANEOUS REVENUE 8,117.50 52,190.77
100-4-01420-38-2000 ROADWAY ASSESSMENTS 38,714.63 38,714.63
100-4-01420-39-4120 T-MOBILE GROUND LEASE 6,945.00 13,020.00
100-4-02110-35-1100 TRAFFIC FINES 344.00 3,826.07
100-4-02110-35-1200 ARREST FEES 5.00 115.10
100-4-02110-35-1300 COURT ADMINISTRATIVE FEES 0.00 9.90
100-4-02110-35-1400 WARRANT FEES 0.00 600.00
100-4-02110-35-1500 COURT SPECIAL EXPENSE FEE 0.00 22.63
100-4-02110-35-1600 TFC FEES 0.00 12.34
100-4-02110-35-1700 JFCI REVENUE 0.00 5.32
100-4-02110-35-1710 CIVIL JUSTICE FEE-COURT 0.00 0.01
100-4-02110-35-1900 CREDIT CARD REVENUE-COURT 0.00 13.77
100-4-03410-33-4100 TCLEOSE EDUCATION ALLOWANCE 0.00 2,125.12
100-4-03410-33-4102 ESD#3 BUILDING LEASE 10,567.34 65,567.34
100-4-06110-32-3200 BUILDING PERMITS 34,224.16 268,489.43
100-4-06110-32-3420 BILLBOARD PERMITS 150.00 150.00
100-4-06210-34-1100 PLAT FEES 0.00 1,253.50
100-4-06210-34-1110 DEVELOPMENT REVIEW FEES 0.00 3,725.50
100-4-06310-32-3700 HEALTH PERMITS 300.00 3,625.00
______________ ______________ ______________ ______________
TOTAL REVENUES 41,169.16 693,192.64 0.00 6,145,944.11
============== ============== ============== ==============
EXPENDITURES
============
100-5-01110-51-1100 REGULAR PAY 32,124.30 686,911.21
100-5-01110-51-2100 MEDICAL INSURANCE 11,757.00 62,660.56
100-5-01110-51-2120 DENTAL INSURANCE 1,221.36 6,520.95
100-5-01110-51-2160 LIFE INSURANCE 71.12 953.52
100-5-01110-51-2180 AD&D INSURANCE 16.00 214.40
100-5-01110-51-2200 TMRS 6,933.48 90,973.43
100-5-01110-51-2520 MEDICARE TAXES 739.24 10,579.51
100-5-01110-51-2540 UNEMPLOYMENT INSURANCE 0.00 3,471.49
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
100-5-01110-51-2560 WORKER'S COMPENSATION 0.00 9,756.12
100-5-01110-51-2570 EMPLOYEE FITNESS PROGRAM 13.85 781.87
100-5-01110-52-1200 AUDITING & ACCOUNTING 0.00 7,133.34
100-5-01110-52-1300 PROFESSIONAL SERVICES 11,957.10 110,789.21
100-5-01110-52-1400 LEGAL FEES 12,930.53 47,528.79
100-5-01110-52-1500 EQUIPMENT RENTAL 0.00 2,677.99
100-5-01110-52-1620 HEALTH INSPECTIONS 0.00 13,045.00
100-5-01110-53-1100 GENERAL OFFICE SUPPLIES 1,677.51 4,507.18
100-5-01110-53-1200 COMPUTER SUPPLIES 0.00 4,111.52
100-5-01110-53-1300 MISCELLANEOUS SUPPLIES 0.00 826.06
100-5-01110-53-1301 MISCELLANEOUS EXPENSE 19,681.66 5,592.17
100-5-01110-54-1100 PRINTING 0.00 1,183.76
100-5-01110-54-1200 POSTAGE 550.00 2,290.87
100-5-01110-54-1400 BANK FEES 0.00 93.67
100-5-01110-54-2100 SEMINARS & TRAINING 480.00 5,351.87
100-5-01110-54-2110 COMMUNITY EVENTS 0.00 710.36
100-5-01110-54-2300 TRAVEL EXPENSE 0.00 8,985.23
100-5-01110-54-2400 MEALS & EXPENSES 417.84 5,847.01
100-5-01110-54-3100 DUES & SUBSCRIPTIONS 485.00 21,129.84
100-5-01110-54-4100 TELEPHONE 0.00 6,578.55
100-5-01110-54-4200 ELECTRIC UTILITIES 995.66 10,088.39
100-5-01110-54-5000 ECON DEV AGREEMENTS 62,945.31 170,814.30
100-5-01110-54-5100 SOFTWARE MAINTENANCE 3,684.31 113,140.06
100-5-01110-54-5400 GENERAL LIABILITY INSURANCE 0.00 7,351.77
100-5-01110-56-1200 OFFICE MACHINES 145.05 2,394.08
100-5-01110-60-1001 TRANSFER OUT - PID/FIBER 33,254.63 187,112.00
100-5-01110-60-1002 TRANSFER OUT-SPECIAL EVENTS 0.00 123,845.00
100-5-01110-60-1201 LEASE FINANCING - PRINCIPAL 5,264.77 5,264.77
100-5-01110-60-2201 LEASE FINANCING - INTEREST 1,155.23 1,155.23
100-5-01210-54-1300 ADVERTISING & LEGAL NOTICES 480.80 2,560.28
100-5-01210-54-1310 FILING FEES 220.05 1,122.03
100-5-02110-51-1100 REGULAR PAY 1,302.05 0.00
100-5-02110-51-2100 MEDICAL INSURANCE 0.00 68.54
100-5-02110-51-2120 DENTAL INSURANCE 0.00 6.95
100-5-02110-51-2160 LIFE INSURANCE 0.00 2.03
100-5-02110-51-2180 AD&D INSURANCE 0.00 0.80
100-5-02110-51-2200 TMRS 0.00 163.41
100-5-02110-51-2520 MEDICARE TAXES 0.00 18.50
100-5-02110-52-1300 PROFESSIONAL SERVICES 625.00 4,772.50
100-5-02110-54-1200 POSTAGE 0.00 17.12
100-5-02110-54-5100 SOFTWARE MAINTENANCE 1.50 190.50
100-5-03110-51-1100 REGULAR PAY 48,862.35 1,148,179.63
100-5-03110-51-1300 OVERTIME PAY 1,222.79 91,692.75
100-5-03110-51-1900 CERTIFICATION PAY 1,793.29 24,963.74
100-5-03110-51-2100 MEDICAL INSURANCE 9,169.04 106,767.28
100-5-03110-51-2120 DENTAL INSURANCE 1,057.16 11,396.24
100-5-03110-51-2160 LIFE INSURANCE 132.08 1,842.84
100-5-03110-51-2180 AD&D INSURANCE 44.00 632.02
100-5-03110-51-2200 TMRS 12,559.06 172,983.07
100-5-03110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 14,000.00
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 4
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
100-5-03110-51-2520 MEDICARE TAXES 1,182.57 17,018.11
100-5-03110-51-2560 WORKER'S COMPENSATION 0.00 15,609.76
100-5-03110-52-1100 CONTRACT LABOR 119.88 38,027.32
100-5-03110-52-1200 AUDITING & ACCOUNTING 0.00 7,133.33
100-5-03110-52-1300 PROFESSIONAL SVCS - PUB SAFET 0.00 5,528.53
100-5-03110-53-1100 GENERAL OFFICE SUPPLIES 678.84 5,949.34
100-5-03110-53-1300 MISCELLANEOUS EXPENSE 384.66 979.44
100-5-03110-53-1400 AMMUNITION 0.00 1,083.65
100-5-03110-53-1500 UNIFORMS 4,606.36 18,825.56
100-5-03110-54-1100 PRINTING 98.03 488.52
100-5-03110-54-1200 POSTAGE 26.29 172.77
100-5-03110-54-2100 SEMINARS & TRAINING 0.00 1,467.97
100-5-03110-54-2300 TRAVEL EXPENSES 0.00 2,696.28
100-5-03110-54-3100 DUES & SUBSCRIPTIONS 120.00 1,222.94
100-5-03110-54-4100 TELEPHONE 0.00 5,202.22
100-5-03110-54-4200 ELECTRIC UTILITIES 1,413.55 15,693.80
100-5-03110-54-5100 SOFTWARE MAINTENANCE 36,407.37 14,007.70
100-5-03110-54-5400 GENERAL LIABILITY INSURANCE 0.00 28,639.96
100-5-03110-54-6100 INMATE HOUSING 0.00 211.50
100-5-03110-54-6200 DISPATCHER 0.00 68,975.25
100-5-03110-54-6300 CRIME LAB FEES 0.00 3,089.30
100-5-03110-55-1100 VEHICLE MAINTENANCE 2,904.29 13,624.75
100-5-03110-55-1200 GAS & OIL 2,664.26 29,249.66
100-5-03110-55-2100 EQUIPMENT MAINTENANCE 0.00 452.23
100-5-03110-55-2200 OFFICE EQUIPMENT MAINTENANCE 2,131.58 400.23
100-5-03110-56-2200 VEHICLES 50.00 28,192.49
100-5-03110-56-2300 PUBLIC SAFETY BUILDING 1,623.00 24,761.10
100-5-03110-60-1002 TRANSFER TO EQUIP REPLACEMENT 0.00 100,000.00
100-5-03110-60-1200 CAPITAL LEASE - PRINCIPAL 0.00 27,261.84
100-5-03110-60-1201 LEASE FINANCING - PRINCIPAL 36,892.98 36,892.98
100-5-03110-60-2200 CAPITAL LEASE - INTEREST 0.00 2,105.70
100-5-03110-60-2201 LEASE FINANCING - INTEREST 2,584.34 2,584.34
100-5-04110-51-1100 REGULAR PAY 99.26 91,857.16
100-5-04110-51-1300 OVERTIME PAY 0.00 13,153.02
100-5-04110-51-2100 MEDICAL INSURANCE 15.24 4,610.64
100-5-04110-51-2120 DENTAL INSURANCE 2.08 539.93
100-5-04110-51-2160 LIFE INSURANCE 0.26 97.82
100-5-04110-51-2180 AD&D INSURANCE 0.10 38.52
100-5-04110-51-2200 TMRS 16.78 13,915.48
100-5-04110-51-2520 MEDICARE TAXES 3.60 1,521.95
100-5-04110-51-2560 WORKERS COMPENSATION 0.00 813.00
100-5-04110-53-1200 COMPUTER SUPPLIES 0.00 240.28
100-5-04110-53-1300 MISCELLANEOUS EXPENSE 0.00 2,452.45
100-5-04110-53-1500 UNIFORMS 0.00 185.32
100-5-04110-54-5400 GENERAL LIABILITY INSURANCE 0.00 2,484.62
100-5-04110-60-1001 TRANSFER OUT DEBT SERVICE 687,024.36 0.00
100-5-04110-60-1002 TRANSFER OUT - GEN CAP PROJ 0.00 241,457.40
100-5-04210-51-2230 INSURANCE POOL CONTRIBUTION 0.00 1,000.00
100-5-04210-52-1300 PROFESSIONAL SERVICES 19,100.00 78,173.65
100-5-04210-52-1500 EQUIPMENT RENTAL 0.00 2,230.23
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 5
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
100-5-04210-54-100 PRINTING 0.00 3,807.70
100-5-04210-54-1200 POSTAGE 0.00 2,472.40
100-5-04210-54-1400 BANK CHARGES 0.00 25,756.28
100-5-04210-54-2100 SEMINARS AND TRAINING 0.00 1,334.40
100-5-04210-54-2300 TRAVEL EXPENSES 0.00 303.24
100-5-04210-54-3100 DUES AND SUBSCRIPTIONS 895.00 1,773.89
100-5-04210-54-4200 ELECTRIC UTILITIES 576.67 8,252.53
100-5-04210-56-4100 STREET SIGNS 585.00 2,778.45
100-5-04210-56-4200 STREET IMPROVEMENTS 283,746.26 362,194.28
100-5-04210-56-4300 STREET REPAIRS 63,296.03 69,718.03
100-5-04210-60-1001 TRANSFER OUT-STREET DEBT 689,790.00 689,790.00
100-5-04210-60-1002 TRANSFER TO EQUIP REPLACEMENT 0.00 50,000.00
100-5-05110-51-1100 REGULAR PAY 3,779.26 31,176.30
100-5-05110-51-1300 OVERTIME PAY 34.50 1,041.00
100-5-05110-51-2100 MEDICAL INSURANCE 741.36 6,127.35
100-5-05110-51-2120 DENTAL INSURANCE 83.40 691.51
100-5-05110-51-2160 LIFE INSURANCE 0.26 6.38
100-5-05110-51-2180 DENTAL, LIFE, AD&D INS-FACILI 0.10 2.52
100-5-05110-51-2200 TMRS 519.73 4,359.39
100-5-05110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 8,000.00
100-5-05110-51-2520 MEDICARE TAXES 49.66 380.75
100-5-05110-51-2560 WORKER'S COMPENSATION 0.00 487.80
100-5-05110-52-1300 PROFESSIONAL SERVICES 0.00 6,650.27
100-5-05110-53-1300 MISCELLANEOUS SUPPLIES 0.00 1,972.15
100-5-05110-54-5400 GENERAL LIABILITY INSURANCE 0.00 207.05
100-5-05110-55-2100 EQUIPMENT MAINTENANCE 0.00 2,645.80
100-5-05110-55-3100 GROUNDSKEEPING 14,420.00 92,315.60
100-5-05110-55-3200 BUILDING MAINTENANCE 1,103.00 62,538.69
100-5-05110-56-3100 PROPERTY 97,637.77 97,637.77
100-5-06110-52-1300 PROFESSIONAL SERVICES 0.00 19,890.75
100-5-06110-52-1600 BUILDING INSPECTIONS 5,170.18 77,533.10
100-5-09110-53-1300 COMPUTERS & SUPPLIES 2,694.37 2,694.37
100-5-09110-54-2110 COMMUNITY EVENTS 0.00 500.00
100-5-09110-54-2300 TRAVEL EXPENSE 0.00 4,714.42
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 1,471,440.70 779,801.65 5,935,825.52 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 2,113,283.17 2,113,283.17 13,261,021.14 13,261,021.14
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
205-POLICE FORFEITURE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
205-1-1102 CLAIM ON CASH 0.00 3,587.44
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 3,587.44 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
205-3-1100 FUND BALANCE 0.00 3,587.44
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 3,587.44
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 3,587.44 3,587.44
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
210-COURT TECHNOLOGY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
210-1-1102 CLAIM ON CASH 4.00 2,171.54
______________ ______________ ______________ ______________
TOTAL ASSETS 4.00 0.00 2,171.54 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
210-3-1100 FUND BALANCE 0.00 2,078.53
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 2,078.53
============== ============== ============== ==============
REVENUES
========
210-4-02110-34-7100 COURT TECHNOLOGY FEES 4.00 93.01
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 4.00 0.00 93.01
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 4.00 4.00 2,171.54 2,171.54
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
215-COURT SECURITY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
215-1-1102 CLAIM ON CASH 4.90 13,206.19
______________ ______________ ______________ ______________
TOTAL ASSETS 4.90 0.00 13,206.19 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
215-3-1100 FUND BALANCE 0.00 13,104.87
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 13,104.87
============== ============== ============== ==============
REVENUES
========
215-4-02110-34-7200 COURT SECURITY FEES 4.90 101.32
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 4.90 0.00 101.32
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 4.90 4.90 13,206.19 13,206.19
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
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 ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
225-SPECIAL EVENTS FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
225-1-1102 CLAIM ON CASH 8,000.01 16,699.89
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 8,000.01 16,699.89 0.00
============== ============== ============== ==============
LIABILITIES
===========
225-2-2101 AP PENDING (DUE TO POOL CASH) 0.00 8.27
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 0.00 8.27
============== ============== ============== ==============
FUND BALANCE
============
225-3-1100 FUND BALANCE 0.00 4,410.25
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 4,410.25 0.00
============== ============== ============== ==============
REVENUES
========
225-4-01110-60-1001 TRANSFER IN FROM GENERAL FUND 0.00 123,845.00
225-4-01520-38-3100 SPONSORSHIPS - BOOMIN 4TH 0.00 71,000.00
225-4-01620-38-3100 SPONSORSHIPS - XMAS CORRIDOR 0.00 5,500.00
225-4-01820-38-3100 SPONSORSHIPS - EASTER 0.00 2,870.00
225-4-01920-38-3100 SPONSORSHIPS - TRUNK OR TREAT 0.00 2,800.00
225-4-04110-36-1100 INTEREST REVENUE 51.16 1,441.55
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 51.16 0.00 207,456.55
============== ============== ============== ==============
EXPENDITURES
============
225-5-01110-51-2100 MEDICAL INSURANCE 0.00 469.13
225-5-01110-51-2120 DENTAL INSURANCE 0.00 50.24
225-5-01110-51-2160 LIFE INSURANCE 0.00 6.28
225-5-01110-51-2180 AD&D INSURANCE 0.00 1.98
225-5-01110-51-2200 TMRS 0.00 689.62
225-5-01110-51-2520 MEDICARE TAXES 0.00 68.90
225-5-01110-56-1300 OTHER OFFICE EQUIPMENT 0.00 129.91
225-5-01420-51-1300 OVERTIME PAY 0.00 5,093.50
225-5-01420-51-2550 INSURANCE 7,844.00 0.00
225-5-01420-53-1300 MISCELLANEOUS SUPPLIES 0.00 4,638.50
225-5-01520-52-1100 CONTRACT LABOR 0.00 11,952.50
225-5-01520-53-1300 MISCELLANEOUS SUPPLIES 0.00 385.68
225-5-01520-54-2110 COMMUNITY EVENTS - BOOMIN 4TH 0.00 123,256.80
225-5-01520-54-2120 EVENT RENTALS - BOOMIN 4TH 0.00 5,528.45
225-5-01620-54-2110 COMMUNITY EVENTS - XMAS CORR 0.00 25,659.10
225-5-01620-54-2111 EVENTS RENTALS - XMAS CORR 0.00 2,432.94
225-5-01620-54-2120 EVENT RENTALS-TRUNK OR TREAT 207.17 207.17
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
225-SPECIAL EVENTS FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
225-5-01820-54-2110 COMMUNITY EVENTS - EASTER 0.00 5,783.98
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 8,051.17 0.00 186,354.68 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 8,051.17 8,051.17 207,464.82 207,464.82
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
230-PID #1
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
230-1-1102 CLAIM ON CASH 421.01 203,700.75
230-1-1105 ACCOUNTS RECEIVABLE 0.00 1,661.61
______________ ______________ ______________ ______________
TOTAL ASSETS 421.01 0.00 205,362.36 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
230-3-1100 FUND BALANCE 0.00 207,206.52
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 207,206.52
============== ============== ============== ==============
REVENUES
========
230-4-01420-31-2001 PID #1 ASSESSMENT 0.00 104,499.33
230-4-04110-36-1100 INTEREST REVENUE 421.01 6,636.51
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 421.01 0.00 111,135.84
============== ============== ============== ==============
EXPENDITURES
============
230-5-04110-60-1001 TRANSFER OUT 0.00 112,980.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 112,980.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 421.01 421.01 318,342.36 318,342.36
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
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 ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
245-HOTEL OCCUPANCY TAX FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
310-UTILITY CAPITAL PROJECTS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
310-1-1102 CLAIM ON CASH 157,330.71 5,736.80
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 0.00 4,480,366.13
310-1-1115 WATER DISTRIBUTION 876,818.21 16,961,180.89
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 66,615.67 334,340.47
310-1-1120 SEWER SYSTEM 0.00 4,247,373.35
310-1-1121 ACCUMULATED DEPRECIATION 867,910.71 9,008,807.02
310-1-1123 BUILDINGS 0.00 46,412.97
310-1-1305 DEFERRED AMOUNT OF REFUNDING 4,986.00 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 881,804.21 1,091,857.09 28,732,096.87 9,014,543.82
============== ============== ============== ==============
LIABILITIES
===========
310-2-2006 ACCRUED INTEREST PAYABLE 1,861.80 31,231.37
310-2-2101 AP PENDING (DUE TO POOL CASH) 41,040.00 41,040.00
310-2-5075 2020 REFUNDING DYEGARD 120,150.00 1,468,300.00
310-2-5076 2020 GO REFUNDING WATER 14,850.00 181,700.00
310-2-5077 LOAN PAYABLE - 48% OF FW WATER 74,400.00 6,097,483.44
310-2-5078 2021A REFUNDING 289,000.00 887,250.00
310-2-5079 LOAN PAYABLE #2 - FW WATER LIN 74,400.00 2,935,200.00
310-2-5080 SERIES 2023 BOND 80,000.00 815,000.00
310-2-5081 SERIES 2023 PREMIUMS 3,175.25 60,329.71
______________ ______________ ______________ ______________
TOTAL LIABILITIES 583,437.05 115,440.00 0.00 12,517,534.52
============== ============== ============== ==============
FUND BALANCE
============
310-3-1100 FUND BALANCE 0.00 5,993,184.64
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 5,993,184.64
============== ============== ============== ==============
REVENUES
========
310-4-04110-60-1001 TRANSFER IN - DEBT 83,982.45 1,007,789.40
310-4-04110-60-1002 TRANSFER IN - CAPITAL 406,690.00 1,275,656.28
310-4-07000-36-1100 INTEREST REVENUE 435.98 4,568.15
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 491,108.43 0.00 2,288,013.83
============== ============== ============== ==============
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
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 706,489.83 0.00
310-5-04110-58-1200 AMORTIZATION EXPENSE 28,548.34 28,548.34
310-5-04410-58-1100 DEPRECIATION EXPENSE 839,362.37 839,362.37
310-5-07001-60-2100 INTEREST - GEN OBLI 2010 2,702.80 2,702.80
310-5-07007-60-2100 INTEREST - 2020 CERT OF OBLI 14,355.00 29,081.25
310-5-07008-60-2100 INTEREST - 48% FW WATER LINE 44,028.00 124,785.60
310-5-07009-60-2100 INTEREST - 2021 REFUNDING 32,295.17 13,746.83
310-5-07010-60-2100 INTEREST - SERIES 2023 CO 42,952.75 42,952.75
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 971,949.26 738,785.00 1,081,179.94 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 2,437,190.52 2,437,190.52 29,813,276.81 29,813,276.81
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
311-GENERAL CAPITAL PROJECTS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
311-1-1102 CLAIM ON CASH 406,682.54 403,079.87
311-1-1202 TEXSTAR - CAPITAL PROJ RESERVE 0.05 31.25
311-1-1203 TEXSTAR - 2023 CO 6,841.97 1,629,261.37
______________ ______________ ______________ ______________
TOTAL ASSETS 6,842.02 406,682.54 1,629,292.62 403,079.87
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
311-3-1100 FUND BALANCE 0.00 1,350,750.70
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 1,350,750.70
============== ============== ============== ==============
REVENUES
========
311-4-04110-36-1100 INTEREST REVENUE 6,849.48 85,233.74
311-4-04110-60-1001 TRANSFER IN/GENERAL FUND 0.00 241,457.40
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 6,849.48 0.00 326,691.14
============== ============== ============== ==============
EXPENDITURES
============
311-5-04110-60-1001 TRANSFER OUT/GENERAL FUND 406,690.00 406,690.00
311-5-05110-56-3100 PROPERTY 0.00 44,539.09
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 406,690.00 0.00 451,229.09 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 413,532.02 413,532.02 2,080,521.71 2,080,521.71
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
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 639,152.44 21,963.57
______________ ______________ ______________ ______________
TOTAL ASSETS 639,152.44 0.00 21,963.57 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
410-3-1100 FUND BALANCE 0.00 21,657.53
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 21,657.53
============== ============== ============== ==============
REVENUES
========
410-4-01110-60-1001 TRANSFER IN 30,488.99 876,902.00
410-4-01110-60-1002 TRANSFER IN - PID 0.00 112,980.00
410-4-07000-36-1100 INTEREST REVENUE 0.00 1,905.16
______________ ______________ ______________ ______________
TOTAL REVENUES 30,488.99 0.00 0.00 991,787.16
============== ============== ============== ==============
EXPENDITURES
============
410-5-07000-60-1099 BOND PAYING AGENT FEES 1,400.00 1,600.00
410-5-07000-60-2100 DEBT SERVICE INTEREST 800.00 0.00
410-5-07001-60-1100 PRINCIPAL - 2007 CERT OF OBLI 0.00 115,000.00
410-5-07001-60-2100 INTEREST - 2007 CERT OF OBLIG 0.00 20,705.00
410-5-07004-60-1100 PRINCIPAL - 2016A CERT OF OBLI 25,000.00 200,000.00
410-5-07004-60-2100 INTEREST - 2016A CERT OF OBLI 9,675.00 73,675.00
410-5-07006-60-1100 PRINCIPAL - 2018 CERT OF OBLI 0.00 95,000.00
410-5-07006-60-2100 INTEREST - 2018 CERT OF OBLIG 400.00 79,725.00
410-5-07007-60-1100 PRINCIPAL - 2020 CERT OF OBLIG 135,400.00 0.00
410-5-07007-60-2100 INTEREST - 2020 CERT OF OBLI 14,726.25 0.00
410-5-07008-60-2100 INTEREST - 2021 REFUNDING BOND 11,371.50 0.00
410-5-07009-60-1100 PRINCIPAL - 2021A GO 289,000.00 56,000.00
410-5-07009-60-2100 INTEREST - 2021A GO 7,679.88 3,691.62
410-5-07010-60-1100 SERIES 2023 CO - PRINCIPAL 100,000.00 65,000.00
410-5-07010-60-2100 SERIES 2023 CO - INTEREST 30,812.50 86,175.00
410-5-07013-60-1100 2021B GO - PRINCIPAL 0.00 80,000.00
410-5-07013-60-2100 2021B GO - INTEREST 0.00 22,359.50
410-5-07014-60-1100 2023 CO PID - PRINCIPAL 0.00 40,000.00
410-5-07014-60-2100 2023 CO PID - INTEREST 107,801.30 52,550.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 32,212.50 701,853.93 991,481.12 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 701,853.93 701,853.93 1,013,444.69 1,013,444.69
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
505-WATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
505-1-1102 CLAIM ON CASH 176,182.07 58,086.66
505-1-1103 TEXPOOL - ENTERPRISE RESERVE 435.88 103,145.01
505-1-1108 EARNED BUT UNBILLED-WATER 28,650.48 143,417.75
505-1-1197 UNAPPLIED CREDITS 4,855.43 13,447.51
505-1-1198 ALLOWANCE FOR UNCOLLECTABLE 0.00 25,949.56
505-1-1199 ACCOUNTS RECEIVABLE - WATER 60,414.03 271,052.49
505-1-1203 TEXSTAR - 2023 BOND CO 41.64 9,908.42
505-1-1250 DUE FROM WILLOW PARK 150,478.67 204,964.46
505-1-1300 DEFERRED OUTFLOW OF RESOURCES 0.00 96,333.00
505-1-1301 DEFERRED OUTFLOWS - OPEB 0.00 2,239.00
______________ ______________ ______________ ______________
TOTAL ASSETS 421,058.20 0.00 889,146.79 39,397.07
============== ============== ============== ==============
LIABILITIES
===========
505-2-2000 ACCOUNTS PAYABLE-AUDIT ACCRUAL 8,653.30 8,653.30
505-2-2005 COMPENSATED ABSENCES PAYABLE 4,875.09 30,519.69
505-2-2011 RETIREMENT (TMRS PAYABLE) 1,062.16 0.00
505-2-2012 HEALTH INSURANCE PAYABLE 390.30 0.00
505-2-2013 FLEX ACCOUNT PAYABLE 164.15 0.00
505-2-2015 DEFERRED COMP PAYABLE 161.10 0.00
505-2-2016 DENTAL/VISION PAYABLE 17.98 0.00
505-2-2024 ACCRUED PAYROLL 11,638.26 0.00
505-2-2025 LEADERS LIFE PAYABLE 11.49 0.00
505-2-2028 IMPACT FEES PAYABLE-WFORD 0.00 50,372.00
505-2-2029 IMPACT FEES PAYABLE- FTW 23,772.00 0.00
505-2-2040 RENTER DEPOSITS 1,000.00 14,250.00
505-2-2101 AP PENDING (DUE TO POOL CASH) 169,218.14 176,322.42
505-2-2200 DEFERRED INFLOWS OF RESOURCES 0.00 16,585.00
505-2-2300 NET PENSION LIABILITY 0.00 122,863.00
505-2-2301 OPEB LIABILITY 0.00 6,231.00
505-2-4100 FEDERAL WITHHOLDING 1,592.32 440.49
505-2-4200 MEDICARE PAYABLE 213.76 116.52
______________ ______________ ______________ ______________
TOTAL LIABILITIES 20,126.61 202,643.44 0.00 426,353.42
============== ============== ============== ==============
FUND BALANCE
============
505-3-1100 FUND BALANCE 0.00 709,607.27
505-3-1101 FUND BALANCE RESTRICTED-IMPACT 0.00 313,120.49
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 1,022,727.76
============== ============== ============== ==============
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
505-WATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
REVENUES
========
505-4-04110-36-1120 INTEREST REVENUE 477.52 41,859.13
505-4-04110-60-1001 TRANSFER IN/DEBT SERVICE 200,000.00 200,000.00
505-4-04410-34-4100 WATER SALES 273,608.21 1,929,903.91
505-4-04410-34-4110 UTGCD-HUDSON OAKS 7,221.48 47,675.84
505-4-04410-34-4200 SERVICE CHARGES 40.00 1,360.00
505-4-04410-34-4300 RECONNECT FEES 0.00 640.00
505-4-04410-34-4400 LATE PAYMENT PENALTIES 1,993.17 10,914.70
505-4-04410-34-4500 WATER IMPACT FEES -COHO 1,381.40 1,381.40
505-4-04410-34-4600 WATER TAP FEE 1,000.00 1,000.00
505-4-04410-34-4700 METER FEES 295.00 295.00
505-4-04410-34-4800 WATER METER FEE 199.00 199.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 486,215.78 0.00 2,235,228.98
============== ============== ============== ==============
EXPENDITURES
============
505-5-04110-51-1100 REGULAR PAY 1,211.62 155,010.80
505-5-04110-51-1300 OVERTIME PAY-P.W. DEPT 1,005.00 7,754.37
505-5-04110-51-2100 MEDICAL INSURANCE-P.W. DEPT 2,956.52 24,632.61
505-5-04110-51-2120 DENTAL INSURANCE 280.46 2,591.66
505-5-04110-51-2160 LIFE INSURANCE 29.96 377.89
505-5-04110-51-2180 AD&D INSURANCE 11.80 147.76
505-5-04110-51-2200 TMRS-P.W. DEPT 2,414.47 24,204.37
505-5-04110-51-2230 INSURANCE POOL CONTRIBUTION 0.00 4,000.00
505-5-04110-51-2520 MEDICARE TAXES 238.39 2,465.28
505-5-04110-51-2560 WORKERS COMPENSATION 0.00 8,455.28
505-5-04110-52-1200 AUDITING & ACCOUNTING 0.00 7,133.33
505-5-04110-52-1300 PROFESSIONAL SERVICES 5,715.00 47,904.87
505-5-04110-52-1500 EQUIPMENT RENTAL 84.49 3,030.27
505-5-04110-52-1660 WELL TANK INSPECTIONS 0.00 2,500.00
505-5-04110-52-1700 WATER SAMPLING 1,623.88 6,649.59
505-5-04110-53-1100 GENERAL OFFICE SUPPLIES 1,890.75 2,460.46
505-5-04110-53-1200 COMPUTER SUPPLIES 0.00 29.69
505-5-04110-53-1300 MISCELLANEOUS EXPENSE 786.68 4,617.70
505-5-04110-53-1500 UNIFORMS 680.22 8,324.67
505-5-04110-53-1700 WATER SYSTEM SUPPLIES 15,818.09 79,987.50
505-5-04110-53-2100 CHEMICALS 883.55 11,227.38
505-5-04110-53-2200 METERS & COUPLINGS 675.00 54,736.34
505-5-04110-54-1100 PRINTING 897.84 3,131.88
505-5-04110-54-1200 POSTAGE 1,878.19 5,664.46
505-5-04110-54-1400 BANK CHARGES 4,617.87 26,120.37
505-5-04110-54-2100 SEMINARS & TRAINING 0.00 1,278.75
505-5-04110-54-2300 TRAVEL EXPENSES 19.48 331.33
505-5-04110-54-3100 DUES & SUBSCRIPTIONS 252.50 571.65
505-5-04110-54-4100 TELEPHONE 0.00 4,264.53
505-5-04110-54-4200 ELECTRIC UTILITIES 161.12 7,553.15
505-5-04110-54-4220 WELL SITE UTILITIES 7,886.83 71,304.26
505-5-04110-54-5100 SOFTWARE MAINTENANCE 2,834.87 49,724.09
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
505-WATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
505-5-04110-54-5400 GENERAL LIABILITY INSURANCE 7,844.00 1,543.88
505-5-04110-55-1100 VEHICLE MAINTENANCE 8,206.15 20,953.00
505-5-04110-55-1200 GAS & OIL 2,013.67 20,187.74
505-5-04110-55-2100 EQUIPMENT MAINTENANCE 131.83 4,257.64
505-5-04110-55-3200 BUILDINGS 0.00 936.71
505-5-04110-55-4100 WATER PLANT MAINTENANCE 0.00 30,042.07
505-5-04110-55-4110 WATER PLANT IMPROVEMENTS 0.00 6,150.00
505-5-04110-55-4200 WATER DISTRIBUTION REPAIR 0.00 4,477.18
505-5-04110-55-4300 WATER WELL REPAIR 0.00 8,797.10
505-5-04110-56-2200 VEHICLES 105.00 130.58
505-5-04110-60-1001 TRANSFER OUT/DEBT SERVICE 55,364.61 664,375.32
505-5-04110-60-1002 TRANSFER OUT - CAPITAL 0.00 868,966.28
505-5-04410-54-3200 UTGCD EXPENSE 0.00 29,817.34
505-5-04410-54-3300 REGIONAL WATER PURCHASES 98,920.94 320,669.11
505-5-04410-54-3310 REGIONAL DEMAND FEES 40,354.87 225,070.20
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 257,735.03 10,060.62 2,834,560.44 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 698,919.84 698,919.84 3,723,707.23 3,723,707.23
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
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 ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
507-DYEGARD FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
507-1-1102 CLAIM ON CASH 180,245.93 161,273.40
507-1-1108 EARNED BUT UNBILLED-DYEGARD 2,694.15 23,259.97
507-1-1198 ALLOWANCE FOR UNCOLLECTABLE 0.00 2,399.24
507-1-1199 ACCOUNTS RECIEVABLE-DYE-WATER 5,321.30 40,223.88
______________ ______________ ______________ ______________
TOTAL ASSETS 8,015.45 180,245.93 224,757.25 2,399.24
============== ============== ============== ==============
LIABILITIES
===========
507-2-2101 AP PENDING (DUE TO POOL CASH) 782.84 782.84
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 782.84 0.00 782.84
============== ============== ============== ==============
FUND BALANCE
============
507-3-1100 FUND BALANCE 0.00 299,766.49
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 299,766.49
============== ============== ============== ==============
REVENUES
========
507-4-04410-34-4100 WATER SALES-DYEGARD 44,412.93 328,950.55
507-4-04410-34-4400 LATE PAYMENT PENALTIES-DYEGARD 227.67 2,258.69
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 44,640.60 0.00 331,209.24
============== ============== ============== ==============
EXPENDITURES
============
507-5-04110-52-1200 AUDITING AND ACCOUNTING-DYEGA 0.00 2,500.00
507-5-04110-52-1300 PROFESSIONAL SERVICES-DYE 0.00 12,602.65
507-5-04110-52-1660 WELL TANK INSPECTIONS & REPAI 0.00 900.00
507-5-04110-52-1700 WATER SAMPLING-DYEGARD 60.00 300.00
507-5-04110-54-1100 PRINTING-DYEGARD 224.46 1,400.20
507-5-04110-54-1200 POSTAGE-DYEGARD 332.05 1,808.84
507-5-04110-54-4220 WELL SITE UTILITIES-DYEGARD 4,365.27 41,772.14
507-5-04110-54-5100 SOFTWARE MAINTENANCE 475.25 1,534.05
507-5-04110-55-4100 WATER PLANT MAINTENANCE-DYEGA 0.00 220.00
507-5-04110-60-1001 TRANSFER OUT-DYEGARD DEBT 212,196.89 346,362.68
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 217,653.92 0.00 409,400.56 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 225,669.37 225,669.37 634,157.81 634,157.81
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
508-TRINITY WATER SALES
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
510-WASTEWATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
510-1-1102 CLAIM ON CASH 37,076.65 12,457,777.42
510-1-1109 EARNED BUT UNBILLED-WASTEWATER 31,009.15 65,026.81
510-1-1190 A/R - ASSESSMENTS 0.00 65,410.81
510-1-1198 ALLOWANCE FOR UNCOLLECTABLE 0.00 853.89
510-1-1199 ACCOUNTS RECEIVABLE - SEWER 33,602.31 89,005.17
510-1-1202 TEXSTAR - WASTEWATER RESERVE 789.92 188,098.74
510-1-1240 DUE FROM ALEDO ISD 10,000.00 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 112,478.03 0.00 12,865,318.95 853.89
============== ============== ============== ==============
LIABILITIES
===========
510-2-2006 ACCRUED INTEREST PAYABLE 100,589.76 135,077.68
510-2-2018 CO SERIES 2024 0.00 11,820,000.00
510-2-2025 BOND PREMIUMS 0.00 394,425.00
510-2-2028 SEWER IMPACT FEES PAYABLE 2,227.00 33,623.00
510-2-2101 AP PENDING (DUE TO POOL CASH) 24,845.94 27,266.17
510-2-4100 FEDERAL WITHHOLDING 0.00 280.41
510-2-4200 MEDICARE PAYABLE 0.00 39.80
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 127,662.70 0.00 12,410,712.06
============== ============== ============== ==============
FUND BALANCE
============
510-3-1100 FUND BALANCE 0.00 505,019.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 505,019.00
============== ============== ============== ==============
REVENUES
========
510-4-04110-36-1120 INTEREST REVENUE 25,294.87 72,793.60
510-4-04410-37-1200 CONTRACT LABOR - ALEDO ISD 15,000.00 58,300.00
510-4-04510-34-5100 WASTEWATER CHARGES 113,596.53 714,498.20
510-4-04510-51-1300 OVERTIME PAY 612.85 0.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 154,504.25 0.00 845,591.80
============== ============== ============== ==============
EXPENDITURES
============
510-5-04110-51-2100 MEDICAL INSURANCE 594.48 6,469.34
510-5-04110-51-2120 DENTAL INSURANCE 81.32 824.26
510-5-04110-51-2160 LIFE INSURANCE 10.16 132.08
510-5-04110-51-2180 AD&D INSURANCE 4.00 52.00
510-5-04110-51-2200 TMRS 758.24 10,305.14
510-5-04110-51-2520 MEDICARE TAXES 79.60 1,064.77
510-5-04110-52-1300 PROFESSIONAL SERVICES 715.00 38,928.75
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
510-WASTEWATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
510-5-04110-52-1700 WASTEWATER SAMPLING 0.00 1,862.00
510-5-04110-53-1700 WASTEWATER SYSTEM SUPPLIES 0.00 345.75
510-5-04510-51-1100 REGULAR PAY 5,600.00 68,269.35
510-5-04510-51-1300 OVERTIME PAY 612.85 9,336.97
510-5-04510-51-2230 INSURANCE POOL CONTRIBUTION 0.00 1,000.00
510-5-04510-54-2100 WASTEWATER TREATMENT SERVICES 44,007.77 241,654.82
510-5-04510-54-4200 ELECTRIC UTILITIES 214.79 4,546.41
510-5-04510-60-1001 TRANSFER OUT/DEBT SERVICE 16,420.95 197,051.40
510-5-04510-99 BOND ISSUANCE COSTS 0.00 214,425.00
510-5-07000-60-2100 INTEREST EXPENSE 100,589.76 100,589.76
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 169,688.92 0.00 896,857.80 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 282,166.95 282,166.95 13,762,176.75 13,762,176.75
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
515-SOLID WASTE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
515-1-1102 CLAIM ON CASH 51,901.03 15,423.70
515-1-1198 ALLOWANCE FOR UNCOLLECTABLE 0.00 88.06
515-1-1199 ACCOUNTS RECEIVABLE - SW 885.93 16,791.41
______________ ______________ ______________ ______________
TOTAL ASSETS 885.93 51,901.03 16,791.41 15,511.76
============== ============== ============== ==============
LIABILITIES
===========
515-2-2013 SOLID WASTE PAYABLE 51,011.40 0.00
515-2-2014 SALES TAX PAYABLE - SW 3.70 1,279.65
______________ ______________ ______________ ______________
TOTAL LIABILITIES 51,015.10 0.00 0.00 1,279.65
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 51,901.03 51,901.03 16,791.41 16,791.41
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
520-STORMWATER UTILITY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
520-1-1102 CLAIM ON CASH 95,144.10 1,215,003.16
520-1-1108 EARNED BUT UNBILLED-STORMWATER 702.33 11,809.32
520-1-1116 EQUIPMENT 0.00 12,875.00
520-1-1118 INFRASTRUCTURE 0.00 783,608.76
520-1-1121 ACCUMULATED DEPRECIATION 36,588.42 73,764.50
520-1-1198 ALLOWANCE FOR UNCOLLECTIBLE 0.00 1,853.90
520-1-1199 ACCOUNTS RECEIVABLE 6,116.48 17,508.37
______________ ______________ ______________ ______________
TOTAL ASSETS 6,818.81 131,732.52 2,040,804.61 75,618.40
============== ============== ============== ==============
LIABILITIES
===========
520-2-2006 ACCRUED INTEREST PAYABLE 283.33 6,237.50
520-2-2030 SERIES 2016 A BONDS 25,000.00 360,000.00
520-2-2031 SERIES 2016 A PREMIUM 1,039.50 12,214.12
520-2-2101 AP PENDING (DUE TO POOL CASH) 50,000.00 50,000.00
520-2-5080 SERIES 2023 CO 20,000.00 645,000.00
520-2-5081 SERIES 2023 PREMIUM 2,334.24 44,350.49
______________ ______________ ______________ ______________
TOTAL LIABILITIES 48,657.07 50,000.00 0.00 1,117,802.11
============== ============== ============== ==============
FUND BALANCE
============
520-3-1100 FUND BALANCE 0.00 764,573.42
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 764,573.42
============== ============== ============== ==============
REVENUES
========
520-4-04110-34-6000 STORMWATER FEE 18,420.76 215,860.14
520-4-07000-36-1100 INTEREST REVENUE 2,706.03 32,634.05
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 21,126.79 0.00 248,494.19
============== ============== ============== ==============
EXPENDITURES
============
520-5-04110-52-1300 PROFESSIONAL SERVICES 25,577.08 25,577.08
520-5-04110-55-4500 DRAINAGE SYSTEM REPAIRS 0.00 18,300.08
520-5-04110-56-4300 STREET REPAIRS 50,000.00 50,000.00
520-5-04110-60-2200 DEBT SERVICE - INTEREST 35,501.26 35,501.26
520-5-04410-58-1100 DEPRECIATION EXPENSE 36,588.42 36,588.42
520-5-05110-60-2200 DEBT SERVICE-INTEREST 283.33 283.33
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 147,666.76 283.33 165,966.84 283.33
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 203,142.64 203,142.64 2,206,771.45 2,206,771.45
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
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 166.41 87,170.99
______________ ______________ ______________ ______________
TOTAL ASSETS 166.41 0.00 87,170.99 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
============
611-3-1100 FUND BALANCE 0.00 5,272.65
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 5,272.65 0.00
============== ============== ============== ==============
REVENUES
========
611-4-01420-36-1100 INTEREST REVENUE 166.41 2,145.70
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 166.41 0.00 2,145.70
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 166.41 166.41 92,443.64 92,443.64
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
710-INTERNAL SERVICE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
710-1-1100 CASH & CASH EQUIVALENTS 2,584.91 9,688.25
______________ ______________ ______________ ______________
TOTAL ASSETS 2,584.91 0.00 9,688.25 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
710-3-1100 FUND BALANCE 0.00 1,710.19
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 1,710.19
============== ============== ============== ==============
REVENUES
========
710-4-01110-34-3000 HEALTH CHARGES 0.00 28,000.00
710-4-01110-36-1100 INTEREST REVENUE 13.70 299.74
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 13.70 0.00 28,299.74
============== ============== ============== ==============
EXPENDITURES
============
710-5-01110-51-2230 INSURANCE REIMBURSEMENTS 2,571.21 20,321.68
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 2,571.21 20,321.68 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 2,584.91 2,584.91 30,009.93 30,009.93
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
720-VEHICLE REPLACEMENT FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
720-1-1102 CLAIM ON CASH 0.00 98,845.50
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 98,845.50 0.00
============== ============== ============== ==============
LIABILITIES
===========
720-2-2101 AP PENDING (DUE TO POOLED CASH 98,010.00 98,010.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 98,010.00 0.00 98,010.00
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
720-4-01110-60-1000 TRANSFER FROM PUBLIC SAFETY 0.00 100,000.00
720-4-01110-60-1001 TRANSFER FROM PUBLIC WORKS 0.00 50,000.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 150,000.00
============== ============== ============== ==============
EXPENDITURES
============
720-5-03110-60-1001 VEHICLE PURCHASES - PD 98,010.00 98,010.00
720-5-04110-60-1001 VEHICLES PURCHASES PW 0.00 51,154.50
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 98,010.00 0.00 149,164.50 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 98,010.00 98,010.00 248,010.00 248,010.00
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
800-GENERAL FIXED ASSETS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
800-1-1200 LAND 142,176.86 1,405,413.24
800-1-1300 BUILDINGS 0.00 2,894,560.69
800-1-1400 AUTOMOBILES 192,665.00 527,820.71
800-1-1500 BUILDING IMPROVEMENTS 0.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 0.00 18,066,015.98
800-1-1900 FURNITURES & FIXTURES 0.00 5,511.05
800-1-1950 CONSTRUCTION IN PROGRESS 43,500.50 65,650.00
800-1-2000 ACCUMULATED DEPRECIATION 781,773.99 7,334,655.91
______________ ______________ ______________ ______________
TOTAL ASSETS 334,841.86 825,274.49 23,815,279.91 7,334,655.91
============== ============== ============== ==============
LIABILITIES
===========
800-2-2000 INVESTMENT IN CAPITAL ASSETS 291,341.36 21,160,702.81
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 291,341.36 0.00 21,160,702.81
============== ============== ============== ==============
FUND BALANCE
============
800-3-1100 FUND BALANCE 0.00 3,898,304.82
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 3,898,304.82 0.00
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
800-5-01110-51-2100 DEPRECIATION EXPENSE 234,777.85 234,777.85
800-5-03110-51-2100 DEPRECIATION EXPENSE 62,854.32 62,854.32
800-5-04110-51-2100 DEPRECIATION EXPENSE 476,468.64 476,468.64
800-5-05110-51-2100 DEPRECIATION EXPENSE 7,673.18 7,673.18
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 781,773.99 0.00 781,773.99 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 1,116,615.85 1,116,615.85 28,495,358.72 28,495,358.72
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
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 36,624.00 10,840,639.49
______________ ______________ ______________ ______________
TOTAL ASSETS 36,624.00 0.00 10,840,639.49 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 2,073.00 537,896.00
900-2-2190 2021B REFUNDING 34,551.00 1,249,227.00
900-2-2191 2023 CERT OF OBLIGATION 0.00 1,950,000.00
900-2-2192 2023 CO - PID PORTION 0.00 1,190,000.00
900-2-2193 2023 BOND PREMIUMS 0.00 220,036.11
900-2-2300 VEHICLE LEASES 0.00 58,138.17
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 36,624.00 0.00 10,840,639.49
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 36,624.00 36,624.00 10,840,639.49 10,840,639.49
============== ============== ============== ==============
*** END OF REPORT ***
11-14-2024 10:59 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
999-POOL CASH
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
999-1-1099 POOL CASH 99,527.23 14,815,150.38
999-1-1100 DUE FROM GENERAL FUND 401,214.26 471,524.53
999-1-1225 DUE FROM SPECIAL EVENTS 0.00 8.27
999-1-1310 DUE FROM UTIL CAP PROJECTS 41,040.00 41,040.00
999-1-1505 DUE FROM WATER FUND 169,218.14 176,322.42
999-1-1507 DUE FROM DYEGARD 782.84 782.84
999-1-1510 DUE FROM WASTEWATER FUND 24,845.94 27,266.17
999-1-1520 DUE FROM STORMWATER UTILITY 50,000.00 50,000.00
999-1-1720 DUE FROM VEHICLE REPLACEMENT 98,010.00 98,010.00
______________ ______________ ______________ ______________
TOTAL ASSETS 884,638.41 0.00 15,680,104.61 0.00
============== ============== ============== ==============
LIABILITIES
===========
999-2-2000 ACCOUNTS PAYABLE 785,111.18 864,954.23
999-2-2100 DUE TO OTHER FUNDS 95,949.82 14,751,928.01
999-2-2200 WAGES PAYABLE 3,577.41 63,222.37
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 884,638.41 0.00 15,680,104.61
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 884,638.41 884,638.41 15,680,104.61 15,680,104.61
============== ============== ============== ==============
*** END OF REPORT ***