3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
100-1-1102 CLAIM ON CASH 622,140.98 1,307,628.96
100-1-1106 CASH ON HAND 0.00 200.00
100-1-1107 FRANCHISE TAX RECEIVABLE 6,456.18 91,519.45
100-1-1108 SALES TAX RECEIVABLE 61,611.42 754,467.66
100-1-1112 DUE FROM OTHER FUNDS 0.00 102,242.46
100-1-1113 POOLED CASH CD 0.00 228,953.53
100-1-1190 COURT FINES RECEIVABLE 5,464.75 180,618.55
100-1-1191 ALLOWANCE FOR UNCOLLECTABLE-CT 5,886.16 144,490.76
100-1-1192 A/R - ASSESSMENTS 115,009.77 413,880.16
100-1-1196 MISC RECIEVABLES 38,325.71 77,429.09
100-1-1200 TEXPOOL - GENERAL RESERVE 207.33 104,761.18
100-1-1201 PREPAID EXPENSES 3,135.48 15,994.89
100-1-1202 TEXSTAR - GENERAL RESERVE 1,963.51 1,043,489.04
100-1-1234 DUE FROM NEXTLINK 68,927.58 41,030.00
100-1-1250 LEASE RECEIVABLE 1,616,361.00 1,616,361.00
100-1-1300 PROPERTY INVESTMENTS 134,350.40 283,140.00
100-1-5200 TEXPOOL - SALES TAX RESERVE 335.19 169,372.81
______________ ______________ ______________ ______________
TOTAL ASSETS 2,559,700.94 120,474.52 6,431,088.78 144,490.76
============== ============== ============== ==============
LIABILITIES
===========
100-2-2000 ACCOUNTS PAYABLE CONTROL 23,774.76 75,259.25
100-2-2001 ACCOUNTS PAYABLE - 1999 32,782.46 213,816.64
100-2-2005 DUE TO TRUST & AGENCY FUND 0.00 303.00
100-2-2007 DUE TO COLLECTION AGENCY 0.00 19.81
100-2-2011 RETIREMENT (TMRS PAYABLE) 3,279.48 0.01
100-2-2012 HEALTH INSURANCE PAYABLE 3,183.15 17,527.19
100-2-2013 FLEX ACCOUNT PAYABLE 0.00 250.91
100-2-2014 CHILD SUPPORT PAYABLE 458.32 624.47
100-2-2015 DEFERRED COMP PAYABLE 49.50 606.99
100-2-2020 UNITED WAY PAYABLE 38.25 0.00
100-2-2021 ACCRUED PAYROLL-GEN FUND 35,840.20 0.00
100-2-2023 DUE TO OMNIBASE 24.00 7.74
100-2-2025 LEADERS LIFE PAYABLE 15.51 0.01
100-2-2101 AP PENDING (DUE TO POOL CASH) 116,766.80 152,393.43
100-2-2102 DUE TO STATE-COURT COSTS 410.80 1,862.28
100-2-2103 DUE TO OTHER FUNDS 0.00 7,737.64
100-2-2107 DUE TO POLICE OFFICE ASSOC 90.00 0.00
100-2-3300 DEFERRED REVENUE 4,793.06 483,416.72
100-2-3301 DEFERRED ASSESSMENTS REVENUE 115,009.77 413,880.16
100-2-3303 DEFERRED REVENUE - LEASES 1,616,361.00 1,616,361.00
100-2-4100 FEDERAL WITHHOLDING 1,130.00 3,714.48
100-2-4200 MEDICARE PAYABLE 14.87 810.16
______________ ______________ ______________ ______________
TOTAL LIABILITIES 214,497.88 1,739,524.05 0.01 2,988,591.88
============== ============== ============== ==============
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
FUND BALANCE
============
100-3-1100 FUND BALANCE 838.86 1,954,851.10
100-3-1103 RESTRICTED FUND BALANCE-PEG 9.93 9,982.00
100-3-1104 NONSPENDABLE FUND BALANCE 525.11 15,994.89
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 535.04 838.86 0.00 1,980,827.99
============== ============== ============== ==============
REVENUES
========
100-4-01110-60-1001 TRANSFER IN 565,955.23 565,955.23
100-4-01420-31-1100 LOCAL SALES & USE TAX 442,064.23 4,102,092.55
100-4-01420-31-1120 MIXED BEVERAGES TAX 1,587.91 13,482.40
100-4-01420-31-2000 PAYMENT IN LIEU OF TAXES 0.00 92,368.00
100-4-01420-31-2100 FRANCHISE FEES 3,706.83 189,869.36
100-4-01420-31-2200 IN-KIND PEG FEES 0.00 20.72
100-4-01420-32-3100 ALCOHOLIC BEVERAGE PERMITS 1,815.00 4,157.50
100-4-01420-33-2140 SOLID WASTE GRANT 10,735.50 25,302.80
100-4-01420-34-2100 PRINTING & DUPLICATION FEE 0.00 85.00
100-4-01420-36-1100 INTEREST REVENUE 213,750.51 235,499.24
100-4-01420-38-1100 MISCELLANEOUS REVENUE 31,093.03 43,879.06
100-4-01420-38-1200 CREDIT CARD REVENUE-MISC (FEE) 5.25 1,601.58
100-4-01420-38-2000 ROADWAY ASSESSMENTS 38,714.56 115,009.77
100-4-01420-39-4120 T-MOBILE GROUND LEASE 10,119.50 11,842.00
100-4-01620-34-1150 CONTRACTOR REGISTRATION FEE 1,700.00 3,450.00
100-4-02110-35-1100 TRAFFIC FINES 299.00 6,764.80
100-4-02110-35-1200 ARREST FEES 5.00 154.52
100-4-02110-35-1300 COURT ADMINISTRATIVE FEES 0.00 15.00
100-4-02110-35-1400 WARRANT FEES 0.00 753.59
100-4-02110-35-1500 COURT SPECIAL EXPENSE FEE 0.00 69.43
100-4-02110-35-1600 TFC FEES 0.00 18.00
100-4-02110-35-1700 JFCI REVENUE 0.00 1.80
100-4-02110-35-1900 CREDIT CARD REVENUE-COURT 12.96 226.07
100-4-03410-33-4100 TCLEOSE EDUCATION ALLOWANCE 0.00 1,092.25
100-4-03410-33-4102 ESD#3 BUILDING LEASE 4,201.73 50,935.87
100-4-06110-32-3200 BUILDING PERMITS 26,941.35 638,921.83
100-4-06110-32-3300 OCCUPANCY PERMITS 2,400.00 2,550.00
100-4-06110-32-3400 SIGN PERMITS 2,124.93 2,572.41
100-4-06110-32-3420 BILLBOARD PERMITS 100.00 100.00
100-4-06210-34-1100 PLAT FEES 0.00 9,358.25
100-4-06210-34-1110 DEVELOPMENT REVIEW FEES 500.00 9,896.75
100-4-06210-34-1120 REPLAT FEES 0.00 2,551.00
100-4-06310-32-3600 SEPTIC PERMITS 920.00 1,840.00
100-4-06310-32-3700 HEALTH PERMITS 350.00 14,700.00
100-4-06310-32-3710 HEALTH INSPECTIONS 200.00 200.00
100-4-08000-61-1200 CAPITAL LEASE PROCEEDS 0.00 25,193.00
100-4-08000-61-2140 INSURANCE PROCEEDS 5,104.05 5,104.05
______________ ______________ ______________ ______________
TOTAL REVENUES 10,119.50 1,354,287.07 0.00 6,177,633.83
============== ============== ============== ==============
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
EXPENDITURES
============
100-5-01110-51-1100 REGULAR PAY 45,823.06 457,683.34
100-5-01110-51-2100 MEDICAL INSURANCE 1,951.36 17,118.26
100-5-01110-51-2120 DENTAL INSURANCE 297.02 2,488.18
100-5-01110-51-2160 LIFE INSURANCE 499.40 782.96
100-5-01110-51-2180 AD&D INSURANCE 2.88 25.92
100-5-01110-51-2200 TMRS 6,617.86 54,906.04
100-5-01110-51-2230 INSURANCE POOL CONTRIBUTION 443.00 30,000.00
100-5-01110-51-2240 LONGEVITY PAY 0.00 1,296.00
100-5-01110-51-2520 MEDICARE TAXES 518.88 6,056.45
100-5-01110-51-2540 UNEMPLOYMENT INSURANCE 0.00 598.72
100-5-01110-51-2560 WORKER'S COMPENSATION 0.00 5,648.32
100-5-01110-51-2570 EMPLOYEE FITNESS PROGRAM 311.10 3,367.40
100-5-01110-52-1200 AUDITING & ACCOUNTING 2,500.00 7,633.00
100-5-01110-52-1300 PROFESSIONAL SERVICES 9,047.60 170,739.19
100-5-01110-52-1400 LEGAL FEES 8,191.08 43,417.22
100-5-01110-52-1500 EQUIPMENT RENTAL 0.00 522.15
100-5-01110-52-1600 BUILDING INSPECTIONS 4,292.38 0.00
100-5-01110-52-1620 HEALTH INSPECTIONS 415.00 11,395.00
100-5-01110-53-1100 GENERAL OFFICE SUPPLIES 445.92 5,206.60
100-5-01110-53-1200 COMPUTER SUPPLIES 165.76 912.78
100-5-01110-53-1300 MISCELLANEOUS SUPPLIES 0.00 2,386.81
100-5-01110-53-1301 MISCELLANEOUS EXPENSE 357.19 2,298.43
100-5-01110-54-1100 PRINTING 0.00 705.32
100-5-01110-54-1200 POSTAGE 0.00 1,169.77
100-5-01110-54-1400 BANK FEES 3.00 37.50
100-5-01110-54-2100 SEMINARS & TRAINING 595.00 3,886.36
100-5-01110-54-2110 COMMUNITY EVENTS 8.65 6,704.38
100-5-01110-54-2300 TRAVEL EXPENSE 1,023.66 7,573.66
100-5-01110-54-2400 MEALS & EXPENSES 222.34 3,915.09
100-5-01110-54-2500 CASH OVER/SHORT 0.00 1.15
100-5-01110-54-3100 DUES & SUBSCRIPTIONS 965.00 20,343.25
100-5-01110-54-4100 TELEPHONE 580.45 9,571.34
100-5-01110-54-4200 ELECTRIC UTILITIES 1,747.13 10,875.57
100-5-01110-54-5000 ECON DEV AGREEMENTS 85,865.33 164,891.79
100-5-01110-54-5100 SOFTWARE MAINTENANCE 6,900.83 64,601.24
100-5-01110-54-5400 GENERAL LIABILITY INSURANCE 0.00 5,750.32
100-5-01110-55-2200 OFFICE EQUIPMENT MAINTENANCE 0.00 15.89
100-5-01110-56-1200 OFFICE MACHINES 2,079.90 511.22
100-5-01110-60-1001 TRANSFER OUT - PID/FIBER 166,904.00 560,077.01
100-5-01110-60-1002 TRANSFER OUT-SPECIAL EVENTS 125,000.00 125,000.00
100-5-01110-60-1201 LEASE FINANCING - PRINCIPAL 1,864.00 1,864.00
100-5-01110-60-2201 LEASE FINANCING - INTEREST 50.48 50.48
100-5-01210-54-1300 ADVERTISING & LEGAL NOTICES 843.50 5,229.80
100-5-01210-54-1310 FILING FEES 0.00 579.00
100-5-01310-54-1400 ELECTION COSTS 0.00 5,613.21
100-5-02110-51-1100 REGULAR PAY 2,626.82 27,914.15
100-5-02110-51-2100 MEDICAL INSURANCE 205.62 1,063.40
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 4
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
100-5-02110-51-2120 DENTAL INSURANCE 20.85 192.48
100-5-02110-51-2160 LIFE INSURANCE 6.09 54.81
100-5-02110-51-2180 AD&D INSURANCE 0.96 8.64
100-5-02110-51-2200 TMRS 429.90 3,478.54
100-5-02110-51-2520 MEDICARE TAXES 29.44 384.89
100-5-02110-51-2560 WORKER'S COMPENSATION 0.00 502.07
100-5-02110-52-1300 PROFESSIONAL SERVICES 1,385.00 10,772.50
100-5-02110-54-2300 TRAVEL EXPENSE 0.00 236.00
100-5-02110-54-3100 DUES & SUBSCRIPTIONS 0.00 55.00
100-5-02110-54-5100 SOFTWARE MAINTENANCE 0.00 7,587.68
100-5-02110-54-5400 GENERAL LIABILITY INSURANCE 0.00 125.40
100-5-03110-51-1100 REGULAR PAY 68,536.17 797,720.07
100-5-03110-51-1300 OVERTIME PAY 6,687.05 109,212.55
100-5-03110-51-1900 CERTIFICATION PAY 1,190.94 10,718.46
100-5-03110-51-2100 MEDICAL INSURANCE 5,654.55 37,644.90
100-5-03110-51-2120 DENTAL INSURANCE 573.21 5,190.39
100-5-03110-51-2160 LIFE INSURANCE 121.92 1,107.44
100-5-03110-51-2180 AD&D INSURANCE 19.20 177.60
100-5-03110-51-2200 TMRS 12,867.12 114,808.93
100-5-03110-51-2240 LONGEVITY PAY 0.00 4,224.00
100-5-03110-51-2520 MEDICARE TAXES 992.12 12,500.99
100-5-03110-51-2560 WORKER'S COMPENSATION 0.00 15,062.21
100-5-03110-52-1100 CONTRACT LABOR 58.19 40,183.51
100-5-03110-52-1200 AUDITING & ACCOUNTING 2,500.00 7,633.00
100-5-03110-52-1300 PROFESSIONAL SVCS - PUB SAFET 0.00 330.00
100-5-03110-53-1100 GENERAL OFFICE SUPPLIES 377.80 2,324.26
100-5-03110-53-1200 COMPUTER SUPPLIES 564.95 2,210.78
100-5-03110-53-1300 MISCELLANEOUS EXPENSE 388.85 6,067.17
100-5-03110-53-1400 AMMUNITION 0.00 1,301.94
100-5-03110-53-1500 UNIFORMS 261.22 12,409.28
100-5-03110-54-1100 PRINTING 136.32 1,255.51
100-5-03110-54-1200 POSTAGE 4.60 80.08
100-5-03110-54-2100 SEMINARS & TRAINING 630.00 3,376.32
100-5-03110-54-3100 DUES & SUBSCRIPTIONS 0.00 1,132.00
100-5-03110-54-4100 TELEPHONE 603.86 8,447.53
100-5-03110-54-4200 ELECTRIC UTILITIES 1,106.81 15,515.75
100-5-03110-54-5100 SOFTWARE MAINTENANCE 7,471.80 44,678.90
100-5-03110-54-5300 PRE-EMPLOYMENT SCREENING 0.00 225.21
100-5-03110-54-5400 GENERAL LIABILITY INSURANCE 0.00 25,362.84
100-5-03110-54-6100 INMATE HOUSING 35.25 352.50
100-5-03110-54-6200 DISPATCHER 17,500.02 70,000.08
100-5-03110-54-6300 CRIME LAB FEES 0.00 490.00
100-5-03110-55-1100 VEHICLE MAINTENANCE 9,504.68 23,024.99
100-5-03110-55-1200 GAS & OIL 2,406.28 29,497.13
100-5-03110-55-2100 EQUIPMENT MAINTENANCE 0.00 1,518.00
100-5-03110-55-2200 OFFICE EQUIPMENT MAINTENANCE 1,550.24 495.87
100-5-03110-56-2200 VEHICLES 3,639.68 35,704.71
100-5-03110-56-2300 PUBLIC SAFETY BUILDING 3,851.80 4,376.80
100-5-03110-60-1001 TRANSFER OUT/CIP-FACILITIES 46,191.00 46,191.00
100-5-03110-60-1200 CAPITAL LEASE - PRINCIPAL 24,683.97 21,284.66
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 5
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
100-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
100-5-03110-60-1201 LEASE FINANCING - PRINCIPAL 9,654.00 9,654.00
100-5-03110-60-2200 CAPITAL LEASE - INTEREST 8,341.18 1,122.26
100-5-03110-60-2201 LEASE FINANCING - INTEREST 1,311.36 1,311.36
100-5-04110-51-1100 REGULAR PAY 1,040.84 13,923.80
100-5-04110-51-2100 MEDICAL INSURANCE 618.91 0.00
100-5-04110-51-2120 DENTAL INSURANCE 15.63 144.31
100-5-04110-51-2200 TMRS 187.71 1,741.24
100-5-04110-51-2520 MEDICARE TAXES 15.42 202.26
100-5-04110-51-2560 WORKERS COMPENSATION 0.00 1,255.18
100-5-04110-53-1300 MISCELLANEOUS EXPENSE 0.00 485.68
100-5-04110-54-5400 GENERAL LIABILITY INSURANCE 0.00 2,916.37
100-5-04110-60-1001 TRANSFER OUT/I-20 OFF RAMP 0.00 599,016.00
100-5-04210-51-2521 FICA TAXES 141.05 3,302.84
100-5-04210-52-1300 PROFESSIONAL SERVICES 3,410.00 144,516.50
100-5-04210-52-1500 EQUIPMENT RENTAL 0.00 132.40
100-5-04210-54-4200 ELECTRIC UTILITIES 568.29 5,766.86
100-5-04210-56-4100 STREET SIGNS 0.00 2,934.96
100-5-04210-56-4200 STREET IMPROVEMENTS 144,804.00 176,359.52
100-5-04210-56-4300 STREET REPAIRS 0.00 1,356.00
100-5-05110-51-1100 REGULAR PAY 3,832.07 70,147.25
100-5-05110-51-1300 OVERTIME PAY 439.24 3,786.12
100-5-05110-51-2100 MEDICAL INSURANCE 154.22 1,350.88
100-5-05110-51-2120 DENTAL INSURANCE 15.63 469.19
100-5-05110-51-2200 TMRS 741.86 9,148.09
100-5-05110-51-2240 LONGEVITY PAY 0.00 96.00
100-5-05110-51-2520 MEDICARE TAXES 60.21 1,021.70
100-5-05110-51-2560 WORKER'S COMPENSATION 0.00 1,882.79
100-5-05110-52-1300 PROFESSIONAL SERVICES 22,642.50 0.00
100-5-05110-53-1100 GENERAL OFFICE SUPPLIES 0.00 81.76
100-5-05110-53-1300 MISCELLANEOUS SUPPLIES 0.00 297.60
100-5-05110-54-2480 SOLID WASTE GRANT EXPENSES 0.00 25,674.50
100-5-05110-54-5400 GENERAL LIABILITY INSURANCE 0.00 459.16
100-5-05110-55-2100 EQUIPMENT MAINTENANCE 0.00 3,487.45
100-5-05110-55-3100 GROUNDSKEEPING 11,301.83 45,848.46
100-5-05110-55-3200 BUILDING MAINTENANCE 3,307.50 25,962.87
100-5-06110-52-1300 PROFESSIONAL SERVICES 60,518.36 60,080.00
100-5-06110-52-1600 BUILDING INSPECTIONS 11,250.53 242,887.51
100-5-06110-54-3100 DUES & SUBSCRIPTIONS 0.00 1,800.00
100-5-06110-54-5100 SOFTWARE MAINT - PLAN & DEVEL 6,000.00 6,000.00
100-5-09110-53-1300 COMPUTERS & SUPPLIES 888.32 1,352.24
100-5-09110-54-1100 PRINTING 0.00 143.58
100-5-09110-54-2110 COMMUNITY EVENTS 0.00 658.33
100-5-09110-54-2300 TRAVEL EXPENSE 0.00 1,502.19
100-5-09110-54-2400 MEALS & EXPENSES 0.00 385.63
100-5-09110-54-5100 SOFTWARE MAINTENANCE 0.00 127.79
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 711,439.42 281,168.28 4,860,455.67 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 3,496,292.78 3,496,292.78 11,291,544.46 11,291,544.46
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
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 ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
210-COURT TECHNOLOGY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
210-1-1102 CLAIM ON CASH 4.00 1,943.54
______________ ______________ ______________ ______________
TOTAL ASSETS 4.00 0.00 1,943.54 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
210-3-1100 FUND BALANCE 0.00 1,812.40
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 1,812.40
============== ============== ============== ==============
REVENUES
========
210-4-02110-34-7100 COURT TECHNOLOGY FEES 4.00 131.14
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 4.00 0.00 131.14
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 4.00 4.00 1,943.54 1,943.54
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
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 12,966.11
______________ ______________ ______________ ______________
TOTAL ASSETS 4.90 0.00 12,966.11 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
215-3-1100 FUND BALANCE 0.00 12,816.86
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 12,816.86
============== ============== ============== ==============
REVENUES
========
215-4-02110-34-7200 COURT SECURITY FEES 4.90 149.25
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 4.90 0.00 149.25
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 4.90 4.90 12,966.11 12,966.11
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
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 ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
225-SPECIAL EVENTS FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
225-1-1102 CLAIM ON CASH 143,181.52 43,129.83
225-1-1105 ACCOUNTS RECEIVABLE 12,000.00 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 143,181.52 12,000.00 43,129.83 0.00
============== ============== ============== ==============
LIABILITIES
===========
225-2-2101 AP PENDING (DUE TO POOL CASH) 77.55 2,597.49
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 77.55 0.00 2,597.49
============== ============== ============== ==============
FUND BALANCE
============
225-3-1100 FUND BALANCE 0.00 77,442.49
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 77,442.49 0.00
============== ============== ============== ==============
REVENUES
========
225-4-01110-60-1001 TRANSFER IN 125,000.00 125,000.00
225-4-01420-38-3000 TICKET SALES 23,081.46 25,081.46
225-4-01420-38-3100 SPONSORSHIPS - CRAFT & CORK 1,500.00 27,000.00
225-4-01520-38-3100 SPONSORSHIPS - BOOMIN 4TH 12,000.00 49,038.54
225-4-01620-38-3100 SPONSORSHIPS - XMAS CORRIDOR 1,000.00 3,500.00
______________ ______________ ______________ ______________
TOTAL REVENUES 12,000.00 150,581.46 0.00 229,620.00
============== ============== ============== ==============
EXPENDITURES
============
225-5-01420-51-1300 OVERTIME PAY 0.00 250.00
225-5-01420-51-2550 INSURANCE 4,250.00 4,250.00
225-5-01420-53-1100 ADVERTISING 0.00 75.00
225-5-01420-53-1300 MISCELLANEOUS SUPPLIES 126.31 1,641.86
225-5-01420-54-2110 COMMUNITY EVENTS 1,601.18 6,171.70
225-5-01420-54-2120 EVENT RENTALS - CRAFT AND COR 0.00 4,314.00
225-5-01520-52-1100 CONTRACT LABOR 0.00 8,140.00
225-5-01520-53-1100 ADVERTISING - BOOMIN 4TH 0.00 1,041.64
225-5-01520-53-1300 MISCELLANEOUS SUPPLIES 0.00 1,013.55
225-5-01520-54-2110 COMMUNITY EVENTS - BOOMIN 4TH 1,500.00 67,433.96
225-5-01620-54-2110 COMMUNITY EVENTS - XMAS CORR 0.00 17,313.46
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 7,477.49 0.00 111,645.17 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 162,659.01 162,659.01 232,217.49 232,217.49
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
230-PID #1
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
230-1-1102 CLAIM ON CASH 132,000.00 1,710.80
230-1-1105 ACCOUNTS RECEIVABLE 11.99 1,661.61
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 132,011.99 3,372.41 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
230-3-1100 FUND BALANCE 0.00 68,022.01
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 68,022.01
============== ============== ============== ==============
REVENUES
========
230-4-01420-31-2001 PID #1 ASSESSMENT 11.99 67,350.40
______________ ______________ ______________ ______________
TOTAL REVENUES 11.99 0.00 0.00 67,350.40
============== ============== ============== ==============
EXPENDITURES
============
230-5-04110-60-1001 TRANSFER OUT 132,000.00 132,000.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 132,000.00 0.00 132,000.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 132,011.99 132,011.99 135,372.41 135,372.41
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
235-AMERICAN RESCUE FUNDS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
235-1-1102 CLAIM ON CASH 307,737.67 615,475.35
______________ ______________ ______________ ______________
TOTAL ASSETS 307,737.67 0.00 615,475.35 0.00
============== ============== ============== ==============
LIABILITIES
===========
235-2-3302 UNEARNED GRANT REVENUE LIABILI 308,344.66 615,475.35
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 308,344.66 0.00 615,475.35
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
235-4-01420-33-2100 GRANT REVENUES 606.99 0.00
______________ ______________ ______________ ______________
TOTAL REVENUES 606.99 0.00 0.00 0.00
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 308,344.66 308,344.66 615,475.35 615,475.35
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
310-UTILITY CAPITAL PROJECTS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
310-1-1100 UTILITY CAP PROJECTS CASH 102,352.20 75.39
310-1-1101 UTILITY DEBT SERVICE CASH 5.78 2,920.40
310-1-1112 PCUD REGIONAL BUY-IN COSTS 0.00 787,885.71
310-1-1113 LAND 7,500.00 1,541,779.86
310-1-1114 WATER PLANT 0.00 4,333,489.13
310-1-1115 WATER DISTRIBUTION 0.00 5,202,485.53
310-1-1116 EQUIPMENT 0.00 158,537.27
310-1-1117 OFFICE EQUIPMENT 0.00 2,224.46
310-1-1118 AUTOMOBILES 0.00 171,995.76
310-1-1119 CONSTRUCTION IN PROGRESS 49,036.35 10,744,440.84
310-1-1120 SEWER SYSTEM 0.00 3,840,683.35
310-1-1121 ACCUMULATED DEPRECIATION 512,691.51 7,480,494.31
310-1-1123 BUILDINGS 0.00 46,412.97
310-1-1220 DUE FROM OTHER FUNDS 0.00 7,737.64
310-1-1305 DEFERRED AMOUNT OF REFUNDING 0.00 9,971.88
______________ ______________ ______________ ______________
TOTAL ASSETS 56,542.13 615,043.71 26,840,668.31 7,490,466.19
============== ============== ============== ==============
LIABILITIES
===========
310-2-2006 ACCRUED INTEREST PAYABLE 50,372.99 27,253.54
310-2-2100 DUE TO OTHER FUNDS 0.00 17,970.02
310-2-2107 RETAINAGE PAYABLE 37,436.85 37,436.85
310-2-5075 2020 REFUNDING DYEGARD 173,750.00 1,762,200.00
310-2-5076 2020 GO REFUNDING WATER 21,450.00 217,800.00
310-2-5077 LOAN PAYABLE - 48% OF FW WATER 156,499.20 6,532,890.24
310-2-5078 2021A REFUNDING 0.00 1,463,500.00
310-2-5079 LOAN PAYABLE #2 - FW WATER LIN 0.00 3,009,600.00
310-2-5150 AUTOMOBILE LEASES 16,947.21 17,393.83
______________ ______________ ______________ ______________
TOTAL LIABILITIES 262,520.20 193,936.05 0.00 13,086,044.48
============== ============== ============== ==============
FUND BALANCE
============
310-3-1100 FUND BALANCE 0.00 4,319,235.07
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 4,319,235.07
============== ============== ============== ==============
REVENUES
========
310-4-04110-60-1001 TRANSFER IN - DEBT 1,730,699.95 1,026,470.18
310-4-04110-60-1002 TRANSFER IN - CAPITAL 1,685,315.88 1,685,315.88
310-4-07000-36-1100 INTEREST REVENUE 81.17 1,917.91
______________ ______________ ______________ ______________
TOTAL REVENUES 1,730,699.95 1,685,397.05 0.00 2,713,703.97
============== ============== ============== ==============
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
310-UTILITY CAPITAL PROJECTS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
EXPENDITURES
============
310-5-04110-58-1200 AMORTIZATION EXPENSE 28,548.36 28,548.36
310-5-04110-60-1001 TRANSFER OUT-GENERAL FUND 195,000.00 80,000.00
310-5-04310-57-1301 MISC BANK CHARGES 0.00 25.00
310-5-04410-58-1100 DEPRECIATION EXPENSE 484,143.15 484,143.15
310-5-07005-60-2100 INTEREST - LEASES 422.99 422.99
310-5-07007-60-2100 INTEREST - 2020 CERT OF OBLI 16,706.06 35,351.06
310-5-07008-60-2100 INTEREST - 48% FW WATER LINE 97,244.04 114,446.23
310-5-07009-60-2100 INTEREST - 2021 REFUNDING 12,549.93 25,844.61
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 639,614.53 195,000.00 768,781.40 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 2,689,376.81 2,689,376.81 27,609,449.71 27,609,449.71
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
311-GENERAL CAPITAL PROJECTS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
311-1-1100 GENERAL CAP CASH ACCOUNT 36.65 18,530.50
311-1-1112 DUE FROM OTHER FUNDS 41,706.00 41,706.00
311-1-1202 TEXSTAR - CAPITAL PROJ RESERVE 0.04 30.04
______________ ______________ ______________ ______________
TOTAL ASSETS 41,742.69 0.00 60,266.54 0.00
============== ============== ============== ==============
LIABILITIES
===========
311-2-2000 ACCOUNTS PAYABLE 0.00 528,583.00
311-2-2100 DUE TO OTHER FUNDS 0.00 102,242.46
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 0.00 630,825.46
============== ============== ============== ==============
FUND BALANCE
============
311-3-1100 FUND BALANCE 0.00 831,428.70
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 831,428.70 0.00
============== ============== ============== ==============
REVENUES
========
311-4-04110-36-1100 INTEREST REVENUE 36.69 216.37
311-4-04110-60-1001 TRANSFER IN/GENERAL FUND 213,095.00 473,748.41
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 213,131.69 0.00 473,964.78
============== ============== ============== ==============
EXPENDITURES
============
311-5-04140-52-1300 PROFESSIONAL SERVICES 41,706.00 0.00
311-5-04150-54-2530 CONSTRUCTION - SIGNAGE & WAY 18,600.00 18,600.00
311-5-04180-54-2520 TRAIL SYSTEM ENGINEERING 46,191.00 46,191.00
311-5-05110-56-3100 PROPERTY 148,304.00 148,304.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 213,095.00 41,706.00 213,095.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 254,837.69 254,837.69 1,104,790.24 1,104,790.24
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
410-GENERAL DEBT SERVICE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
410-1-1100 CASH & CASH EQUIVALENTS 188.53 95,332.70
______________ ______________ ______________ ______________
TOTAL ASSETS 188.53 0.00 95,332.70 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
410-3-1100 FUND BALANCE 0.00 103.37
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 103.37
============== ============== ============== ==============
REVENUES
========
410-4-01110-60-1001 TRANSFER IN 175,186.50 886,381.42
410-4-07000-36-1100 INTEREST REVENUE 188.53 630.29
______________ ______________ ______________ ______________
TOTAL REVENUES 175,186.50 188.53 0.00 887,011.71
============== ============== ============== ==============
EXPENDITURES
============
410-5-07000-60-1099 BOND PAYING AGENT FEES 1,600.00 1,600.00
410-5-07000-60-1100 DEBT SERVICE PRINCIPAL 240,000.00 0.00
410-5-07000-60-2100 DEBT SERVICE INTEREST 30,957.50 0.00
410-5-07001-60-1100 PRINCIPAL - 2007 CERT OF OBLI 0.00 105,000.00
410-5-07001-60-2100 INTEREST - 2007 CERT OF OBLIG 14,543.61 29,303.61
410-5-07002-60-2100 INTEREST - 2010 GO REFUNDING 15,743.61 0.00
410-5-07004-60-1100 PRINCIPAL - 2016A CERT OF OBL 0.00 190,000.00
410-5-07004-60-2100 INTEREST - 2016A CERT OF OBLI 39,587.50 81,475.00
410-5-07006-60-1100 PRINCIPAL - 2018 CERT OF OBLI 0.00 85,000.00
410-5-07006-60-2100 INTEREST - 2018 CERT OF OBLIG 400.00 88,725.00
410-5-07007-60-1100 PRINCIPAL - 2020 CERT OF OBLI 45,000.00 45,000.00
410-5-07007-60-2100 INTEREST - 2020 CERT OF OBLI 1,402.50 1,402.50
410-5-07008-60-1100 2021 REFUNDING PRINCIPAL 0.00 80,000.00
410-5-07008-60-2100 INTEREST - 2021 REFUNDING BON 5,950.05 25,413.00
410-5-07009-60-1100 PRINCIPAL - 2021A GO 0.00 52,500.00
410-5-07009-60-2100 INTEREST - 2021A GO 3,830.95 6,363.27
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 111,914.61 287,101.11 791,782.38 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 287,289.64 287,289.64 887,115.08 887,115.08
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
420-UTILITY DEBT SERVICE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
______________ ______________ ______________ ______________
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
505-WATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
505-1-1102 CLAIM ON CASH 110,925.57 300,634.60
505-1-1103 TEXPOOL - ENTERPRISE RESERVE 184.97 93,469.05
505-1-1108 EARNED BUT UNBILLED-WATER 435.57 101,137.81
505-1-1197 UNAPPLIED CREDITS 6,126.29 22,955.64
505-1-1198 ALLOWANCE FOR UNCOLLECTABLE 9,904.02 23,790.65
505-1-1199 ACCOUNTS RECEIVABLE - WATER 31,469.20 115,812.94
505-1-1201 PREPAID EXPENSES 2,913.39 3,166.08
505-1-1220 DUE FROM OTHER FUNDS 0.00 17,970.02
505-1-1300 DEFERRED OUTFLOW OF RESOURCES 1,634.00 41,360.80
505-1-1301 DEFERRED OUTFLOWS - OPEB 602.00 3,458.00
______________ ______________ ______________ ______________
TOTAL ASSETS 114,023.93 50,171.08 677,009.30 46,746.29
============== ============== ============== ==============
LIABILITIES
===========
505-2-2000 ACCOUNTS PAYABLE-AUDIT ACCRUAL 3,205.83 3,205.83
505-2-2005 COMPENSATED ABSENCES PAYABLE 1,904.38 19,956.39
505-2-2011 RETIREMENT (TMRS PAYABLE) 602.91 0.00
505-2-2012 HEALTH INSURANCE PAYABLE 530.06 2,851.81
505-2-2013 FLEX ACCOUNT PAYABLE 0.00 1,198.78
505-2-2015 DEFERRED COMP PAYABLE 18.00 20.00
505-2-2020 UNITED WAY PAYABLE 11.25 4.80
505-2-2024 ACCRUED PAYROLL 6,438.41 0.00
505-2-2025 LEADERS LIFE PAYABLE 10.34 11.50
505-2-2028 IMPACT FEES PAYABLE-WFORD 17,864.00 17,864.00
505-2-2040 RENTER DEPOSITS 1,000.00 13,750.00
505-2-2101 AP PENDING (DUE TO POOL CASH) 64,301.17 69,190.59
505-2-2108 DUE TO WEATHERFORD 0.00 30.00
505-2-2200 DEFERRED INFLOWS OF RESOURCES 5,801.00 88,147.00
505-2-2300 NET PENSION LIABILITY 38,658.00 4,693.00
505-2-2301 OPEB LIABILITY 1,877.00 12,115.00
505-2-4100 FEDERAL WITHHOLDING 234.58 826.80
505-2-4200 MEDICARE PAYABLE 25.19 96.05
______________ ______________ ______________ ______________
TOTAL LIABILITIES 49,405.74 93,076.38 0.00 233,961.55
============== ============== ============== ==============
FUND BALANCE
============
505-3-1100 FUND BALANCE 63,192.18 833,985.58
505-3-1101 FUND BALANCE RESTRICTED-IMPACT 62,577.18 288,974.37
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 63,192.18 62,577.18 0.00 1,122,959.95
============== ============== ============== ==============
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
505-WATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
REVENUES
========
505-4-04110-34-9100 RETURNED CHECK FEE 0.00 40.00
505-4-04110-36-1120 INTEREST REVENUE 184.97 653.31
505-4-04110-60-1001 TRANSFER IN/DEBT SERVICE 5,312.50 43,014.50
505-4-04410-34-4100 WATER SALES 125,667.68 1,673,809.94
505-4-04410-34-4110 UTGCD-HUDSON OAKS 3,315.48 40,457.99
505-4-04410-34-4200 SERVICE CHARGES 360.00 2,640.00
505-4-04410-34-4300 RECONNECT FEES 0.00 240.00
505-4-04410-34-4400 LATE PAYMENT PENALTIES 955.17 11,264.49
505-4-04410-34-4500 WATER IMPACT FEES -COHO 3,963.14 62,577.18
505-4-04410-34-4600 WATER TAP FEE 1,000.00 15,000.00
505-4-04410-34-4700 METER FEES 1,780.00 18,715.00
505-4-04410-34-4800 WATER METER FEE 0.00 2,205.00
505-4-04420-38-1100 MISCELLANEOUS REVENUE 615.00 45,084.61
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 143,153.94 0.00 1,915,702.02
============== ============== ============== ==============
EXPENDITURES
============
505-5-04110-51-1100 REGULAR PAY 12,285.27 154,981.17
505-5-04110-51-1300 OVERTIME PAY-P.W. DEPT 468.97 37,330.04
505-5-04110-51-2100 MEDICAL INSURANCE-P.W. DEPT 1,182.29 3,332.94
505-5-04110-51-2120 DENTAL INSURANCE 119.86 1,173.59
505-5-04110-51-2160 LIFE INSURANCE 28.95 260.55
505-5-04110-51-2180 AD&D INSURANCE 3.36 30.24
505-5-04110-51-2200 TMRS-P.W. DEPT 30,144.80 8,385.92
505-5-04110-51-2240 LONGEVITY PAY 0.00 768.00
505-5-04110-51-2520 MEDICARE TAXES 177.25 2,699.75
505-5-04110-51-2560 WORKERS COMPENSATION 0.00 7,588.75
505-5-04110-52-1200 AUDITING & ACCOUNTING 2,500.00 7,634.00
505-5-04110-52-1300 PROFESSIONAL SERVICES 15,966.68 98,540.36
505-5-04110-52-1500 EQUIPMENT RENTAL 0.00 1,597.70
505-5-04110-52-1660 WELL TANK INSPECTIONS 0.00 2,310.00
505-5-04110-52-1700 WATER SAMPLING 650.10 6,136.73
505-5-04110-53-1100 GENERAL OFFICE SUPPLIES 0.00 786.56
505-5-04110-53-1200 COMPUTER SUPPLIES 0.00 37.98
505-5-04110-53-1300 MISCELLANEOUS EXPENSE 771.29 4,303.00
505-5-04110-53-1500 UNIFORMS 711.32 4,592.87
505-5-04110-53-1700 WATER SYSTEM SUPPLIES 6,504.80 34,770.98
505-5-04110-53-2100 CHEMICALS 2,053.58 7,372.89
505-5-04110-53-2200 METERS & COUPLINGS 19,006.74 52,112.54
505-5-04110-54-1100 PRINTING 301.67 6,648.83
505-5-04110-54-1200 POSTAGE 1,149.46 6,087.72
505-5-04110-54-1400 BANK CHARGES 3,372.99 27,212.92
505-5-04110-54-1800 REIMBURSEMENT 813.45 0.00
505-5-04110-54-2100 SEMINARS & TRAINING 813.45 3,191.83
505-5-04110-54-2400 MEALS & EXPENSES 0.00 35.00
505-5-04110-54-3100 DUES & SUBSCRIPTIONS 241.97 2,044.23
505-5-04110-54-4100 TELEPHONE 267.94 4,571.97
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
505-WATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
505-5-04110-54-4200 ELECTRIC UTILITIES 130.13 1,318.50
505-5-04110-54-4220 WELL SITE UTILITIES 12,817.21 122,115.33
505-5-04110-54-5100 SOFTWARE MAINTENANCE 2,771.56 28,487.83
505-5-04110-54-5400 GENERAL LIABILITY INSURANCE 0.00 7,143.50
505-5-04110-55-1100 VEHICLE MAINTENANCE 87.96 10,037.79
505-5-04110-55-1200 GAS & OIL 1,712.28 19,674.70
505-5-04110-55-2100 EQUIPMENT MAINTENANCE 746.82 969.47
505-5-04110-55-2200 OFFICE EQUIPMENT MAINTENANCE 0.00 170.00
505-5-04110-55-4100 WATER PLANT MAINTENANCE 90.99 4,588.86
505-5-04110-55-4110 WATER PLANT IMPROVEMENTS 0.00 78,297.77
505-5-04110-55-4300 WATER WELL REPAIR 0.00 33,220.75
505-5-04110-56-2200 VEHICLES 0.00 18.50
505-5-04110-60-1001 TRANSFER OUT/DEBT SERVICE 14,670.02 1,348,761.09
505-5-04110-60-1200 CAPITAL LEASES - PRINCIPAL 16,947.21 0.00
505-5-04110-60-2200 CAPITAL LEASES - INTEREST 1,022.81 0.00
505-5-04410-54-3200 UTGCD EXPENSE 0.00 38,644.09
505-5-04410-54-3300 REGIONAL WATER PURCHASES 45,494.64 209,032.66
505-5-04410-54-3310 REGIONAL DEMAND FEES 24,185.45 145,112.45
505-5-07000-60-2100 CAPITAL OUTLAY TRANSFER OUT 0.00 125,000.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 171,285.00 48,928.27 2,650,746.43 8,385.92
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 397,906.85 397,906.85 3,327,755.73 3,327,755.73
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
506-DEERCREEK FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
506-1-1102 CLAIM ON CASH 351,590.36 90,416.62
506-1-1240 DUE FROM ANNETTA 19,830.28 0.00
506-1-1300 DEFERRED OUTFLOW OF RESOURCES 1,314.00 11,957.20
506-1-1301 DEFERRED OUTFLOWS - OPEB 8.00 1,033.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 372,742.64 103,406.82 0.00
============== ============== ============== ==============
LIABILITIES
===========
506-2-2005 COMPENSATED ABSENCES PAYABLE 1,231.97 8,479.21
506-2-2011 RETIREMENT (TMRS PAYABLE) 223.69 0.00
506-2-2012 HEALTH INSURANCE PAYABLE-DC 217.28 91.88
506-2-2013 FLEX ACCOUNT PAYABLE 91.87 0.00
506-2-2024 ACCRUED PAYROLL-DEER CREEK 2,497.96 0.00
506-2-2101 AP PENDING (DUE TO POOL CASH) 1,211.03 2,297.83
506-2-2200 DEFERRED INFLOWS 5,203.00 26,319.00
506-2-2300 NET PENSION LIABILITY 9,715.00 1,401.00
506-2-2301 OPEB LIABILITY 29.00 3,617.00
506-2-4100 FEDERAL WITHHOLDING 124.67 178.23
506-2-4200 MEDICARE PAYABLE 12.51 33.15
______________ ______________ ______________ ______________
TOTAL LIABILITIES 12,791.11 7,766.87 91.88 42,325.42
============== ============== ============== ==============
FUND BALANCE
============
506-3-1100 FUND BALANCE 606.00 354,661.54
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 606.00 0.00 354,661.54
============== ============== ============== ==============
REVENUES
========
506-4-04410-34-5000 ANNETTA CONTRACT CHARGES 13,830.28 182,067.40
506-4-04410-34-5100 ANNETTA MONTHLY OPERATION 0.00 8,831.46
______________ ______________ ______________ ______________
TOTAL REVENUES 13,830.28 0.00 0.00 190,898.86
============== ============== ============== ==============
EXPENDITURES
============
506-5-04110-51-1100 REGULAR PAY-DEERCREEK 3,845.70 55,339.32
506-5-04110-51-1300 OVERTIME PAY-DEERCREEK 1,540.89 13,371.10
506-5-04110-51-2100 MEDICAL INSURANCE-ANNETTA 514.05 2,965.93
506-5-04110-51-2120 DENTAL INSURANCE 52.11 519.39
506-5-04110-51-2160 LIFE INSURANCE 15.24 137.16
506-5-04110-51-2180 AD&D INSURANCE 2.40 21.60
506-5-04110-51-2200 TMRS-ANNETTA 2,280.45 5,430.76
506-5-04110-51-2240 LONGEVITY PAY 0.00 576.00
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
506-DEERCREEK FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
506-5-04110-51-2520 MEDICARE TAXES 71.04 979.89
506-5-04110-51-2560 WORKERS COMPENSATION 0.00 1,950.68
506-5-04110-52-1300 PROFESSIONAL SERVICES 7,606.00 9,106.99
506-5-04110-52-1500 EQUIPMENT RENTAL-DC 0.00 460.09
506-5-04110-52-1700 WATER SAMPLING-DC 0.00 640.00
506-5-04110-53-1300 MISC SUPPLIES-DEERCREEK 0.00 687.27
506-5-04110-53-1500 UNIFORMS-DEERCREEK 0.00 403.27
506-5-04110-53-1700 WATER SYSTEM SUPPLIES-DC 0.00 326.20
506-5-04110-53-2100 CHEMICALS-DEERCREEK 0.00 3,616.41
506-5-04110-54-5400 GENERAL LIABILITY INSURANCE 0.00 1,207.07
506-5-04110-55-1100 VEHICLE MAINTENANCE 0.00 26.39
506-5-04110-55-1200 GAS & OIL-DEERCREEK 0.00 4,972.52
506-5-04110-55-4200 WASTEWATER PLANT MAINTENANCE 0.00 819.94
506-5-04110-60-1001 TRANSFER OUT 343,127.14 380,829.14
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 356,774.57 2,280.45 484,387.12 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 383,395.96 383,395.96 587,885.82 587,885.82
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
507-DYEGARD FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
507-1-1102 CLAIM ON CASH 30,606.71 194,155.52
507-1-1108 EARNED BUT UNBILLED-DYEGARD 1,163.82 19,580.57
507-1-1198 ALLOWANCE FOR UNCOLLECTABLE 553.66 2,324.02
507-1-1199 ACCOUNTS RECIEVABLE-DYE-WATER 10,536.68 23,398.04
______________ ______________ ______________ ______________
TOTAL ASSETS 31,770.53 11,090.34 237,134.13 2,324.02
============== ============== ============== ==============
LIABILITIES
===========
507-2-2101 AP PENDING (DUE TO POOL CASH) 189.69 189.69
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 189.69 0.00 189.69
============== ============== ============== ==============
FUND BALANCE
============
507-3-1100 FUND BALANCE 0.00 218,539.72
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 218,539.72
============== ============== ============== ==============
REVENUES
========
507-4-04410-34-4100 WATER SALES-DYEGARD 26,423.49 307,402.16
507-4-04410-34-4400 LATE PAYMENT PENALTIES-DYEGARD 497.63 2,461.38
507-4-04410-34-4600 WATER TAP FEES-DYEGARD 0.00 500.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 26,921.12 0.00 310,363.54
============== ============== ============== ==============
EXPENDITURES
============
507-5-04110-52-1300 PROFESSIONAL SERVICES-DYE 0.00 482.65
507-5-04110-52-1500 EQUIPMENT RENTAL-DYEGARD 0.00 112.86
507-5-04110-52-1660 WELL TANK INSPECTIONS & REPAI 0.00 150.00
507-5-04110-52-1700 WATER SAMPLING-DYEGARD 40.00 453.92
507-5-04110-53-2100 CHEMICALS-DYEGARD 268.54 774.53
507-5-04110-54-1100 PRINTING-DYEGARD 75.42 1,662.23
507-5-04110-54-1200 POSTAGE-DYEGARD 197.48 1,270.35
507-5-04110-54-4220 WELL SITE UTILITIES-DYEGARD 5,691.06 18,546.64
507-5-04110-54-5100 SOFTWARE MAINTENANCE 158.12 1,566.62
507-5-04110-55-4100 WATER PLANT MAINTENANCE-DYEGA 0.00 38,375.00
507-5-04110-60-1001 TRANSFER OUT-DYEGARD DEBT 0.00 230,888.04
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 6,430.62 0.00 294,282.84 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 38,201.15 38,201.15 531,416.97 531,416.97
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
510-WASTEWATER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
510-1-1102 CLAIM ON CASH 289,634.57 159,420.20
510-1-1109 EARNED BUT UNBILLED-WASTEWATER 5,950.46 31,257.08
510-1-1190 A/R - ASSESSMENTS 0.00 65,410.81
510-1-1198 ALLOWANCE FOR UNCOLLECTABLE 143.56 807.52
510-1-1199 ACCOUNTS RECEIVABLE - SEWER 668.33 25,165.24
510-1-1202 TEXSTAR - WASTEWATER RESERVE 249,593.62 170,498.18
______________ ______________ ______________ ______________
TOTAL ASSETS 295,585.03 250,405.51 451,751.51 807.52
============== ============== ============== ==============
LIABILITIES
===========
510-2-2000 ACCOUNTS PAYABLE-AUDIT ACCRUAL 23,807.77 0.60
510-2-2028 SEWER IMPACT FEES PAYABLE 7,416.00 13,558.00
510-2-2101 AP PENDING (DUE TO POOL CASH) 17,910.32 18,288.42
______________ ______________ ______________ ______________
TOTAL LIABILITIES 23,807.77 25,326.32 0.00 31,847.02
============== ============== ============== ==============
FUND BALANCE
============
510-3-1100 FUND BALANCE 10,878.03 1,187,000.68
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 10,878.03 0.00 1,187,000.68
============== ============== ============== ==============
REVENUES
========
510-4-04110-36-1120 INTEREST REVENUE 406.38 2,334.10
510-4-04510-34-5100 WASTEWATER CHARGES 52,745.50 564,250.20
510-4-04510-34-6100 SEWER TAP FEE 500.00 10,500.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 53,651.88 0.00 577,084.30
============== ============== ============== ==============
EXPENDITURES
============
510-5-04110-52-1700 WASTEWATER SAMPLING 0.00 1,027.00
510-5-04510-54-2100 WASTEWATER TREATMENT SERVICES 20,333.83 159,349.83
510-5-04510-54-4200 ELECTRIC UTILITIES 535.11 6,109.74
510-5-04510-55-4202 SEWER MAINTENANCE 0.00 378.10
510-5-04510-60-1001 TRANSFER OUT/DEBT SERVICE 0.00 196,210.92
510-5-04510-60-2100 CAPITAL OUTLAY TRANSFER OUT 0.00 981,912.42
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 20,868.94 0.00 1,344,988.01 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 340,261.74 340,261.74 1,796,739.52 1,796,739.52
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
515-SOLID WASTE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
515-1-1102 CLAIM ON CASH 53.06 10,398.63
515-1-1198 ALLOWANCE FOR UNCOLLECTABLE 0.00 88.06
515-1-1199 ACCOUNTS RECEIVABLE - SW 155.70 13,294.45
______________ ______________ ______________ ______________
TOTAL ASSETS 155.70 53.06 23,693.08 88.06
============== ============== ============== ==============
LIABILITIES
===========
515-2-2013 SOLID WASTE PAYABLE 50.07 22,385.69
515-2-2014 SALES TAX PAYABLE - SW 52.57 1,219.33
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 102.64 0.00 23,605.02
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 155.70 155.70 23,693.08 23,693.08
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
520-STORMWATER UTILITY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
520-1-1101 STORMWATER DEBT SERVICE 5,294.55 6,915.67
520-1-1102 CLAIM ON CASH 135,244.02 320,209.82
520-1-1108 EARNED BUT UNBILLED-STORMWATER 279.18 11,091.11
520-1-1116 EQUIPMENT 0.00 12,875.00
520-1-1118 INFRASTRUCTURE 0.00 546,817.70
520-1-1119 CONSTRUCTION IN PROGRESS 193,406.56 193,406.56
520-1-1121 ACCUMULATED DEPRECIATION 2,574.96 3,218.70
520-1-1198 ALLOWANCE FOR UNCOLLECTIBLE 251.69 1,424.35
520-1-1199 ACCOUNTS RECEIVABLE 122.93 10,464.06
______________ ______________ ______________ ______________
TOTAL ASSETS 193,808.67 143,365.22 1,101,779.92 4,643.05
============== ============== ============== ==============
LIABILITIES
===========
520-2-2006 ACCRUED INTEREST PAYABLE 83.33 1,704.17
520-2-2030 SERIES 2016 A BONDS 0.00 410,000.00
520-2-2031 SERIES 2016 A PREMIUM 1,039.50 14,293.12
520-2-2200 DUE TO OTHER FUNDS 41,706.00 41,706.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 1,122.83 41,706.00 0.00 467,703.29
============== ============== ============== ==============
FUND BALANCE
============
520-3-1100 FUND BALANCE 0.00 444,772.02
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 444,772.02
============== ============== ============== ==============
REVENUES
========
520-4-04110-34-6000 STORMWATER FEE 16,606.96 196,730.26
520-4-05110-60-1001 TRANSFER IN/OTHER FUNDS 45,100.00 0.00
520-4-07000-36-1100 INTEREST REVENUE 17.95 58.43
______________ ______________ ______________ ______________
TOTAL REVENUES 45,100.00 16,624.91 0.00 196,788.69
============== ============== ============== ==============
EXPENDITURES
============
520-5-04110-60-1099 BOND PAYING AGENT FEES 200.00 200.00
520-5-04110-60-2200 DEBT SERVICE - INTEREST 41,110.33 9,352.17
520-5-04410-58-1100 DEPRECIATION EXPENSE 2,574.96 2,574.96
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 2,774.96 41,110.33 12,127.13 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 242,806.46 242,806.46 1,113,907.05 1,113,907.05
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
610-PRIVATE PURPOSE TRUST
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
610-1-1102 CLAIM ON CASH 1,124.99 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 1,124.99 0.00 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
610-3-1100 FUND BALANCE 1,124.99 0.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 1,124.99 0.00 0.00 0.00
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 1,124.99 1,124.99 0.00 0.00
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
611-TRASH TRUST FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
______________ ______________ ______________ ______________
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
710-INTERNAL SERVICE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
710-1-1100 CASH & CASH EQUIVALENTS 266.12 269.79
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 266.12 269.79 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
710-3-1100 FUND BALANCE 0.00 5,673.33
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 5,673.33
============== ============== ============== ==============
REVENUES
========
710-4-01110-34-3000 HEALTH CHARGES 0.00 30,000.00
710-4-01110-36-1100 INTEREST REVENUE 0.55 24.18
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.55 0.00 30,024.18
============== ============== ============== ==============
EXPENDITURES
============
710-5-01110-51-2230 INSURANCE REIMBURSEMENTS 266.67 35,427.72
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 266.67 0.00 35,427.72 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 266.67 266.67 35,697.51 35,697.51
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
800-GENERAL FIXED ASSETS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
800-1-1200 LAND 0.00 942,382.40
800-1-1300 BUILDINGS 0.00 2,894,560.69
800-1-1400 AUTOMOBILES 33,840.10 397,353.58
800-1-1500 BUILDING IMPROVEMENTS 0.00 267,429.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 15,986,509.42
800-1-1900 FURNITURES & FIXTURES 0.00 5,511.05
800-1-1950 CONSTRUCTION IN PROGRESS 345,659.00 640,081.65
800-1-2000 ACCUMULATED DEPRECIATION 747,189.01 5,859,635.93
______________ ______________ ______________ ______________
TOTAL ASSETS 379,499.10 747,189.01 21,667,307.03 5,859,635.93
============== ============== ============== ==============
LIABILITIES
===========
800-2-2000 INVESTMENT IN CAPITAL ASSETS 379,499.10 18,950,532.06
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 379,499.10 0.00 18,950,532.06
============== ============== ============== ==============
FUND BALANCE
============
800-3-1100 FUND BALANCE 0.00 2,395,671.95
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 2,395,671.95 0.00
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
800-5-01110-51-2100 DEPRECIATION EXPENSE 252,578.50 252,578.50
800-5-03110-51-2100 DEPRECIATION EXPENSE 95,178.39 95,178.39
800-5-04110-51-2100 DEPRECIATION EXPENSE 399,432.12 399,432.12
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 747,189.01 0.00 747,189.01 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 1,126,688.11 1,126,688.11 24,810,167.99 24,810,167.99
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
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 575,606.40 7,976,592.82
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 575,606.40 7,976,592.82 0.00
============== ============== ============== ==============
LIABILITIES
===========
900-2-2100 2007 CERTIFICATES OF OBLIG 105,000.00 615,000.00
900-2-2130 CO SERIES 2016 A 190,000.00 3,190,000.00
900-2-2131 CO SERIES 2016 A PREMIUM 7,938.50 109,154.42
900-2-2150 2018 CERT OF OBLIGATION PID 70,000.00 1,735,000.00
900-2-2151 2018 PID PREMIUM 4,931.50 76,438.25
900-2-2160 2018 CERT OF OBLIGATION FIBER 15,000.00 305,000.00
900-2-2161 2018 ADDITION FIBER PREMIUM 870.31 13,489.85
900-2-2170 2020 GO REFUNDING 45,000.00 40,000.00
900-2-2180 2021A REFUNDING 52,500.00 591,500.00
900-2-2190 2021B REFUNDING 80,000.00 1,250,000.00
900-2-2300 VEHICLE LEASES 47.39 51,010.30
900-2-2400 EQUIPMENT LEASES 4,413.48 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 575,653.79 47.39 0.00 7,976,592.82
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 575,653.79 575,653.79 7,976,592.82 7,976,592.82
============== ============== ============== ==============
*** END OF REPORT ***
3-13-2023 11:00 AM CITY OF HUDSON OAKS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
999-POOL CASH
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
999-1-1099 POOL CASH 934,899.94 3,115,277.87
999-1-1100 DUE FROM GENERAL FUND 116,766.80 152,393.43
999-1-1225 DUE FROM SPECIAL EVENTS 77.55 2,597.49
999-1-1505 DUE FROM WATER FUND 64,301.17 69,190.61
999-1-1506 DUE FROM DEERCREEK 1,211.03 2,297.83
999-1-1507 DUE FROM DYEGARD 189.69 189.69
999-1-1510 DUE FROM WASTEWATER FUND 17,910.32 18,288.42
______________ ______________ ______________ ______________
TOTAL ASSETS 1,135,356.50 0.00 3,360,235.34 0.00
============== ============== ============== ==============
LIABILITIES
===========
999-2-2000 ACCOUNTS PAYABLE 200,456.56 244,957.47
999-2-2100 DUE TO OTHER FUNDS 884,223.49 3,064,601.42
999-2-2200 WAGES PAYABLE 50,676.45 50,676.45
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 1,135,356.50 0.00 3,360,235.34
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 1,135,356.50 1,135,356.50 3,360,235.34 3,360,235.34
============== ============== ============== ==============
*** END OF REPORT ***