Import c76d6386-5826-4180-9714-14c471f3c578
Download
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
106-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
106-10000 Claim on Pooled Cash 213,457.08 42,141.58
106-10001 BOT Police Forfeiture 6519 0.00 8,504.85
106-10002 BOT Police Seizure 0.00 483.01
106-10030 Government Capital Lending 0.00 0.00
106-10151 TexStar General Fund 1111 0.00 0.00
106-10152 TexStar CIP 5104 0.00 2.60
106-10155 TexStar Operating 1112 0.00 0.00
106-10160 Petty Cash on Hand 0.00 910.00
106-10161 LOGIC General Fund 0.00 108,290.86
106-10162 LOGIC CIP 0.00 194,466.60
106-10163 Prosperity Bank 0.00 0.00
106-10164 Great Plains Bank 0.00 194,909.35
106-10170 BOT Police 0.00 0.00
106-10200 Property Tax Receivable 0.00 1,208.38
106-10201 Deliq Property Tax Receivable 0.00 83,260.91
106-10209 Property Tax Allowance for Bad 0.00 23,069.47
106-10210 Sales Tax Receivable 0.00 171,800.80
106-10217 Unbilled Receivables 0.00 12,767.07
106-10220 Mixed Beverage Receivable 0.00 5,315.36
106-10221 Liens Receivable 0.00 0.00
106-10229 Other Receivables 0.00 44.32
106-10230 Accrued Interest Receivable 0.00 716.14
106-10233 EDC Note Receivable 0.00 240,000.00
106-10250 Sanitation Service Receivable 22,847.61 51,641.89
106-10251 Sanitation Sales Tax Receivabl 1,843.74 4,209.25
106-10252 NSF Checks Receivable 0.00 20.00
106-10290 Allowance for Bad Debt-General 0.00 24,254.26
106-10399 Prepaid Insurance Trust 0.00 0.00
106-10509 Prepaid Expenses 0.00 80,816.26
106-10802 Due from CCPD Fund 0.00 0.00
106-10803 Due from EDC 0.00 5,000.00
106-10805 Due from Debt Svc Fd 0.00 3,492.69
106-10806 Due from W/S 0.00 0.00
106-10807 Due from TIF Fd 0.00 5,750.00
106-10809 Due From Insurance Trust 0.00 42,176.20
106-10840 Due from Cares Act Fd 0.00 0.00
106-10845 Due from ARPA Fd 0.00 0.00
106-10999 Reserve-Replacement & Mntce 0.00 0.00
106-12220 Grants Receivable 0.00 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 24,691.35 213,457.08 1,242,410.13 62,841.72
============== ============== ============== ==============
LIABILITIES
===========
106-20105 Accounts Payable Accrued 0.00 0.00
106-20110 Accounts Payable Control 52,865.71 49,120.73
106-20111 Accounts Payable Other 0.00 368.68
106-20114 Solid Waste Bins Payable 1,060.80 8,952.95
106-20115 Sales Tax - Collected 0.00 192,741.24
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
106-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
106-20116 Sales Tax-Uncollected 4,099.45 212,155.00
106-20117 Unapplied Credit 477.50 609.80
106-20122 State Tax - Child Safety Payab 5.04 361.01
106-20123 State Court Costs Payable 6,924.45 24,391.41
106-20124 Bonds Payable 507.00 13,837.49
106-20125 Bonds Payable-Other Agency 0.00 1,875.20
106-20200 Wages Payable 0.00 26,586.72
106-20201 FIT Withholding Payable 0.00 7,675.66
106-20202 FICA Taxes Payable 0.00 370.17
106-20203 TWC Payable 0.00 0.00
106-20204 TMRS Payable 0.00 255.00
106-20205 Workers Comp Payable 0.00 0.00
106-20206 Group Health Payable 0.00 1,580.06
106-20207 AFLAC Payable 0.00 0.00
106-20209 Vision Plan Payable 0.00 235.31
106-20210 Dental & Life Payable 0.00 295.85
106-20212 Misc. PY Deduction Payable 0.00 4,032.12
106-20214 LT Disability Payable 0.00 0.00
106-20215 FLEX SPENDING ACCT 0.00 0.00
106-20220 Child Support Payable 0.00 0.00
106-20301 Deferred Lien Revenue 0.00 0.00
106-20302 Deferred Tax Revenue 0.00 61,056.70
106-20303 Deferred Revenue - Grants 0.00 0.00
106-20305 Deferred Revenue-Other 0.00 0.00
106-20310 Employee Donations 0.00 0.00
106-20311 Brick Memorial Donations 0.00 100.00
106-20410 UNCLAIMED PROPERTY 0.00 1,856.56
106-20700 Police Property Held 0.00 3,483.01
106-20802 Due to CCPD Fund 0.00 0.00
106-20803 DUE TO EDC 0.00 48,684.95
106-20806 Due to W/S 0.00 0.00
106-20807 Due to TIF Fund 473,811.00 473,811.00
106-20809 Due To Insurance Trust 0.00 8,878.33
106-20814 Due to 44 Acre Development 0.00 362,296.81
106-20861 Due to W/S CIP 0.00 0.00
106-20906 EDC loan Payable 0.00 0.00
106-20990 Bank adjustment items 792.75 796.68
______________ ______________ ______________ ______________
TOTAL LIABILITIES 54,135.96 486,407.74 206,324.22 1,300,084.22
============== ============== ============== ==============
FUND BALANCE
============
106-30100 Fund Balance 0.00 686,570.75
106-30210 Encumbrances 0.00 0.00
106-39999 Adjusting Account 0.00 0.00
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 686,570.75
============== ============== ============== ==============
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
106-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
REVENUES
========
106-50000 Property Tax 473,811.00 1,173,974.82
106-50010 Delinquent Property Tax 0.00 51,948.96
106-50020 Property Tax P&I 0.00 21,657.18
106-50021 Property Tax Attorney Fees 0.00 0.00
106-50100 Sales Tax-General 0.00 735,746.35
106-50101 Sales Tax Street Improvements 0.00 183,858.36
106-50110 Mixed Beverage Tax 0.00 25,325.21
106-50200 Hotel/Motel Tax 337.32 4,345.75
106-50300 Franchise - Miscellaneous 0.00 0.00
106-50301 Franchise Tax - Electric 0.00 114,782.61
106-50302 Franchise Tax - Gas 0.00 45,688.11
106-50303 Franchise Tax - Sanitation 0.00 29,542.04
106-50304 Franchise Tax - Telephone 0.00 0.00
106-50305 Franchise Tax - Cable 0.00 25,479.02
106-50306 Franchise Fees - Wrecker Srvc 0.00 0.00
106-50400 Bingo Tax 0.00 0.00
106-50499 Tow & Storage Tax 0.00 0.00
106-51000 Business Permits 0.00 0.00
106-51001 Electrical Permits 1,571.50 14,725.09
106-51002 Certificate of Occupancy 500.00 12,175.00
106-51003 Mechanical Permits 642.25 7,201.95
106-51004 Plumbing Permits 1,139.42 18,375.42
106-51005 Building Permits 10,330.36 73,251.17
106-51006 Garage Sale Permits 200.00 1,640.00
106-51007 Other Permits 0.00 1,277.50
106-51008 License Registration Fee 1,050.00 9,000.00
106-51009 License Fees - Game Rooms 0.00 0.00
106-51010 Fire Inspections 2,550.00 12,125.00
106-51011 Alchohol Permits 0.00 0.00
106-52000 Zoning Fees 0.00 3,989.25
106-52004 Certfied Letter Fees 0.00 50.00
106-52005 Towing Fees 0.00 235.00
106-52006 Preservation Fees- Towing 0.00 20.00
106-52007 Impound Fees - Wrecker 0.00 0.00
106-52008 Storage Fees 0.00 360.00
106-52100 Sanitation Fees 49,753.31 294,745.74
106-52105 Mowing Fees 0.00 0.00
106-52110 CC Transaction Fees 0.00 0.00
106-52111 Returned Check Fees 35.00 70.00
106-52115 Copy Fees 30.00 595.63
106-52200 Contracted Fire Services 0.00 8,500.00
106-52800 Fingerprint Charges 0.00 0.00
106-52810 Lien Revenue 0.00 0.00
106-53000 Fines 14,993.68 128,681.61
106-53001 Fines- Late Charges 535.40 3,982.93
106-53002 Court T/P Late Fees 0.00 0.00
106-53003 COURT FEES 0.01 0.07
106-53004 Court Collection Fees 371.60 5,478.62
106-53005 LEOSE Funds 0.00 1,283.44
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 4
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
106-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
106-53010 Forfeited Property 0.00 0.00
106-53020 Forfeited Bond Revenue 0.00 0.00
106-53100 Jail Services- Other Cities 0.00 0.00
106-53102 Dispatch Services-Other Cities 0.00 0.00
106-53105 Warrant Services- Other Cities 0.00 0.00
106-53300 Animal Adoption Fees 0.00 0.00
106-53350 Animal Control Services 0.00 0.00
106-53900 Court Security Fees 0.00 0.00
106-53901 Court Technology Fees 0.00 0.00
106-54000 Interest Earnings 0.00 14,390.81
106-54001 Royalty Revenue 0.00 1,086.45
106-55000 Animal Shelter Donations 0.00 0.00
106-55001 Fire Dept. Donations 0.00 750.00
106-55500 Donations- General 0.00 1,150.00
106-55510 Donations-Help Your Neighbor 0.00 23.39
106-55520 Donations Halloween Event 0.00 0.00
106-55530 Donations Easter Event 0.00 0.00
106-55540 Donations Christmas Event 0.00 0.00
106-55550 Donations Officer Mino 0.00 0.00
106-56000 Grant Revenue-General 0.00 0.00
106-56001 Grant Revenue-Police 0.00 4,335.33
106-56002 Grant Revenue-Fire 0.00 500.00
106-57000 Miscellaneous Revenue 0.00 6,326.94
106-57001 Discounts Taken 0.00 506.64
106-57010 Community Center Rental 0.00 0.00
106-57100 Sale of Assets 0.00 12,187.00
106-57200 Jail Telephone Charges 0.00 0.00
106-57210 Hazardous Waste Charges 0.00 95.00
106-57300 Insurance Claims Revenue 0.00 87,828.73
106-57305 State Funding- Training 0.00 0.00
106-57800 Workers Comp Reimb 17,383.74 28,844.56
106-57900 Sale of Surplus Property 0.00 7,565.00
106-57901 Sale of Scrap 0.00 0.00
106-57902 Lease Revenue 0.00 0.00
106-58500 Loan/Lease Proceeds 0.00 0.00
106-58510 Use of Fund Balance 0.00 0.00
106-59901 Transfer from GF 0.00 0.00
106-59902 Transfer from CCPD Fund 0.00 0.00
106-59903 Transfer from EDC Fund 0.00 29,675.94
106-59906 Transfer from W/S Fund 0.00 233,333.33
106-59907 Transfer from TIF Fund 0.00 72,916.69
106-59908 Transfer from Debt Svc Fd 0.00 0.00
106-59936 Transfer from EDC Fund 0.00 0.00
106-59940 Transfer from CARES Act Fund 0.00 0.00
106-59945 Transfer from ARPA Fund 0.00 0.00
______________ ______________ ______________ ______________
TOTAL REVENUES 473,811.00 101,423.59 506.64 3,511,121.00
============== ============== ============== ==============
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 5
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
106-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
EXPENDITURES
============
106-600-8000-Debt Interest 0.00 0.00
106-600-8050-Debt Principal 0.00 0.00
106-600-8800-Capital Outlay 0.00 0.00
106-600-9700-Bad Debt Expense 883.98 9,346.94
106-600-9701-Conversion Expense 0.00 0.00
106-600-9902-Transfer to CCPD Fund 0.00 0.00
106-600-9903-Transfer to EDC Fund 0.00 0.00
106-600-9906-Transfer to W/S Fund 0.00 0.00
106-600-9916-Transfer to Cap Proj Fd 0.00 0.00
106-601-3900-Modular Lease 0.00 0.00
106-602-1000-Council Salaries 0.00 0.00
106-603-1000-COUNCIL SALARIES 2,261.54 30,000.02
106-603-1010-COUNCIL FICA 173.02 2,295.16
106-603-3300-TRAINING 0.00 0.00
106-603-3305-TRAVEL 0.00 0.00
106-611-1000-Salaries/Wages 0.00 0.00
106-611-1001-Overtime 0.00 0.00
106-611-1005-TMRS Retirement 0.00 0.00
106-611-1006-Health/Life/Dental Ins. 0.00 0.00
106-611-1010-FICA 0.00 0.00
106-611-1020-Miscellaneous Personnel Expens 0.00 0.00
106-611-1030-Unemployment Compensation-TWC 0.00 0.00
106-611-1031-Workers Comp. Insurance 0.00 0.00
106-611-2000-Office Supplies 0.00 0.00
106-611-2002-Janitorial Supplies 0.00 0.00
106-611-2004-Gasoline 0.00 0.00
106-611-2300-Uniforms 0.00 0.00
106-611-2800-Miscellaneous Supplies 0.00 0.00
106-611-2801-Miscellaneous Tools 0.00 0.00
106-611-2831-COVID-19 0.00 0.00
106-611-3300-Training 0.00 0.00
106-611-3301-Licensing Fees 0.00 0.00
106-611-3400-Attorney Fees 0.00 0.00
106-611-3404-Professional Services 0.00 53,041.70
106-611-3420-IT Technical Support 0.00 0.00
106-611-3440-Radio Services 0.00 0.00
106-611-3700-Liability Insurance 0.00 0.00
106-611-3755-Spay and Neuter Fees 0.00 0.00
106-611-3756-Waste Disposal Fee 0.00 0.00
106-611-3757-Animal Impound Expense 0.00 0.00
106-611-3850-Fines & Penalties 0.00 0.00
106-611-4000-Electricity 0.00 35.10
106-611-4001-Gas Service 0.00 0.00
106-611-4003-Telephone 0.00 0.00
106-611-5001-Building Maintenance 0.00 0.00
106-611-5002-Vehicle Maintenance 0.00 0.00
106-611-5006-Licensing & Maintenance Fees 0.00 0.00
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 6
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
106-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
106-611-5440-Radio Maintenance 0.00 0.00
106-611-5999-Reverse-Maintenance 0.00 0.00
106-611-8000-Debt Interest 0.00 0.00
106-611-8050-Debt Principal 0.00 0.00
106-611-8800-Capital Outlay 0.00 0.00
106-612-1000-Salaries/Wages 6,834.14 84,684.10
106-612-1001-Overtime 0.00 0.00
106-612-1005-TMRS Retirement 729.20 8,892.35
106-612-1006-Health/Life/Dental Ins. 1,116.42 9,667.65
106-612-1010-FICA 502.44 6,213.65
106-612-1020-Miscellaneous Personnel Expens 0.00 1,308.32
106-612-1030-Unemployment Compensation-TWC 0.00 5,468.15
106-612-1031-Workers Comp. Insurance 0.00 919.60
106-612-2000-Office/Janitorial Supplies 36.92 6,783.61
106-612-2001-Copier Supplies 0.00 814.78
106-612-2002-Janitorial Supplies 39.14 913.85
106-612-2003-Postage 0.00 83.62
106-612-2004-Gasoline 0.00 235.02
106-612-2100-Computer Equipment & Supplies 0.00 0.00
106-612-2400-Election Supplies 0.00 8,705.81
106-612-2800-Miscellaneous Supplies 0.00 121.55
106-612-2800-Hotel Occupancy Tax Exp 0.00 0.00
106-612-2820-Tourism Promotion 0.00 0.00
106-612-2831-COVID-19 0.00 0.00
106-612-3050-Appraisals & Collections 0.00 17,843.03
106-612-3051-Planning & Zoning Expense 140.00 14,436.14
106-612-3200-Community/Staff Programs 151.94 21,855.19
106-612-3200-Community Christmas Activities 0.00 79,237.80
106-612-3200-National Night Out 0.00 0.00
106-612-3300-Training 0.00 658.99
106-612-3305-Travel 3.00 1,279.48
106-612-3400-Attorney Fees 2,920.00 48,108.16
106-612-3401-Inspection Fees 5,075.00 9,755.00
106-612-3403-Audit Services 0.00 11,999.75
106-612-3404-Professional Services 2,000.00 26,324.73
106-612-3405-Engineering Services 0.00 280.00
106-612-3410-Codification Expenses 0.00 4,695.00
106-612-3411-Records Retention Supplies 0.00 0.00
106-612-3420-IT Technical Support 0.00 3,234.96
106-612-3421-Website 0.00 4,339.36
106-612-3430-Community Dev. Consultant 0.00 0.00
106-612-3600-Legal Publications 0.00 1,483.50
106-612-3601-Dues & Subscriptions 539.33 16,246.38
106-612-3602-Advertising 0.00 0.00
106-612-3606-Sales Tax Audit 0.00 0.00
106-612-3700-Liability Insurance 0.00 41,567.65
106-612-3701-Insurance Claim Expense 0.00 0.00
106-612-3750-380 Grant Agreements 0.00 0.00
106-612-3751-Sub-Standard Housing 0.00 0.00
106-612-3800-Bank Service Charges 0.00 35,037.07
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 7
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
106-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
106-612-3850-Fines & Penalties 0.00 0.00
106-612-3900-Modular Lease 0.00 0.00
106-612-3910-Copier Lease 0.00 2,160.02
106-612-4000-Electricity 0.00 3,293.05
106-612-4001-Gas Service 31.75 537.71
106-612-4003-Telephone 411.09 5,081.89
106-612-5000-Office Equip. Maintenance 0.00 149.98
106-612-5001-Building Maintenance 0.00 11,979.53
106-612-5006-Licensing & Maintenance Fees 0.00 9,112.40
106-612-6000-Interest Expense 0.00 0.00
106-612-8000-Debt Interest 0.00 0.00
106-612-8050-Debt Principal 0.00 0.00
106-612-8800-Capital Outlay 0.00 0.00
106-612-9700-Bad Debt Expense - Sanitation 0.00 0.00
106-612-9902-Transfer to CCPD Fund 0.00 0.00
106-613-1000-Salaries/Wages 79,164.55 921,749.43
106-613-1001-Overtime 1,582.85 24,181.53
106-613-1005-TMRS Retirement 8,492.83 97,931.87
106-613-1006-Health/Life/Dental Ins. 13,452.66 104,584.91
106-613-1010-FICA 6,047.55 70,850.71
106-613-1020-Miscellaneous Personnel Expens 0.00 225.00
106-613-1030-Unemployment Compensation-TWC 0.00 0.00
106-613-1031-Workers Comp. Insurance 0.00 39,600.65
106-613-2000-Office Supplies 0.00 3,602.22
106-613-2001-Copier Supplies 0.00 971.49
106-613-2002-Janitorial Supplies 0.00 780.77
106-613-2003-Postage 0.00 1,317.79
106-613-2004-Gasoline 0.00 37,116.65
106-613-2211-Jail Expenses 0.00 0.00
106-613-2300-Uniforms 0.00 738.34
106-613-2310-Radio Equipment 0.00 0.00
106-613-2800-Miscellaneous Supplies 19.99 294.45
106-613-2800-Misc. Supplies-Forfieture Exp 0.00 0.00
106-613-2800-Misc. Supplies-K-9 Expenses 0.00 336.58
106-613-2801-Range Supplies 0.00 0.00
106-613-2831-COVID-19 0.00 0.00
106-613-3200-Community/Staff Programs 0.00 804.13
106-613-3300-Training 206.50 2,355.22
106-613-3305-Travel 0.00 869.41
106-613-3400-Attorney Fees 980.00 13,457.52
106-613-3404-Professional Services 0.00 4,350.00
106-613-3410-White Settlement Dispatch 12,313.33 147,759.96
106-613-3420-IT Technical Support 0.00 23,565.51
106-613-3421-Website 0.00 0.00
106-613-3430-Lab Analysis/Reports 0.00 650.00
106-613-3440-Radio Services 0.00 19,159.85
106-613-3452-Warrants Serv/MSB/Officer 0.00 0.00
106-613-3500-Equipment Rental 0.00 0.00
106-613-3550-Wrecker Service 0.00 0.00
106-613-3601-Dues & Subscriptions 0.00 1,326.54
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 8
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
106-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
106-613-3602-Advertising 0.00 0.00
106-613-3700-Liability Insurance 0.00 0.00
106-613-3701-Insurance Claim Expense 0.00 0.00
106-613-3850-Fines & Penalties 0.00 0.00
106-613-3900-Modular Lease 0.00 0.00
106-613-3910-Copier Lease 0.00 4,984.37
106-613-3915-Vehicle Lease 938.00 65,330.77
106-613-3950-Forfeiture Fund Agency Share 0.00 0.00
106-613-4000-Electricity 0.00 2,377.00
106-613-4001-Gas Service 31.75 1,552.49
106-613-4002-Air Cards 0.00 0.00
106-613-4003-Telephone 751.00 15,475.87
106-613-5000-Office Equip. Maintenance 0.00 0.00
106-613-5001-Building Maintenance 2,715.01 10,594.44
106-613-5002-Vehicle Maintenance 2,269.17 31,757.09
106-613-5006-Computer Licensing & Mtnc. 0.00 14,240.27
106-613-5310-Radar Maintenance 0.00 0.00
106-613-8000-ROU Lease Interest 0.00 0.00
106-613-8050-ROU Lease Principal 0.00 0.00
106-613-8800-Capital Outlay 0.00 13,733.10
106-614-1000-Salaries/Wages 47,158.35 672,326.44
106-614-1001-Overtime 14,111.76 86,512.26
106-614-1003-Paid Reserve Firefighter 0.00 0.00
106-614-1005-TMRS Retirement 6,537.52 79,623.41
106-614-1006-Health/Life/Dental Ins. 8,943.70 75,538.31
106-614-1010-FICA EXPENSE 4,540.10 55,791.80
106-614-1020-Miscellaneous Personnel Expens 0.00 516.64
106-614-1025-Annual Physicals 0.00 5,436.00
106-614-1030-Unemployment Compensation-TWC 0.00 0.00
106-614-1031-Workers Comp. Insurance 0.00 29,669.41
106-614-1032-Volunteer Fireman's Insurance 0.00 0.00
106-614-2000-Office Supplies 0.00 1,119.90
106-614-2001-Copier Supplies 0.00 0.00
106-614-2002-Janitorial Supplies 82.38 1,274.16
106-614-2003-POSTAGE 0.00 50.00
106-614-2004-Gasoline 818.23 11,245.15
106-614-2200-EMS Equipment 521.17 1,622.21
106-614-2201-Fire Reporting/CAD 0.00 10,500.00
106-614-2202-Personal Protections Equipment 0.00 10,451.25
106-614-2203-Nozzles 617.42 1,453.02
106-614-2204-Power Tools 0.00 0.00
106-614-2205-Hand Tools 0.00 0.00
106-614-2206-Hoses/Adaptors 0.00 2,658.10
106-614-2207-SCBA Equipment 0.00 3,000.00
106-614-2208-Specialized Equipment 0.00 9,791.78
106-614-2215-Fire Marshall/EMC 0.00 3,549.40
106-614-2300-Uniforms 245.90 3,320.74
106-614-2310-Radio Equipment 0.00 27.84
106-614-2800-Miscellaneous Supplies 0.00 2,682.03
106-614-2801-Miscellaneous Tools 0.00 0.00
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 9
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
106-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
106-614-2831-COVID-19 0.00 0.00
106-614-3200-Community/Staff Programs 0.00 4,904.85
106-614-3300-Training 0.00 6,110.59
106-614-3305-Travel 0.00 1,627.47
106-614-3404-Professional Services 0.00 9,444.38
106-614-3410-FW Dispatch Services 2,838.05 21,948.05
106-614-3420-IT Technical Support 0.00 11,147.10
106-614-3421-Website 0.00 0.00
106-614-3440-Radio Services 0.00 4,646.00
106-614-3601-Dues & Subscriptions 0.00 14,382.71
106-614-3700-Liability Insurance 0.00 0.00
106-614-3701-Insurance Claim Expense 0.00 0.00
106-614-3850-Fines & Penalties 0.00 0.00
106-614-3915-Vehicle Lease 0.00 0.00
106-614-4000-Electricity 0.00 5,673.90
106-614-4001-Gas Service 0.00 0.00
106-614-4003-Telephone 150.77 2,583.99
106-614-5001-Building Maintenance 405.94 6,875.49
106-614-5002-Vehicle Maintenance 989.89 7,101.12
106-614-5003-Storage Rental 0.00 0.00
106-614-5006-Licensing & Maintenance Fees 1,038.09 6,015.07
106-614-5200-Equipment Testing 0.00 1,235.00
106-614-5202-Bunker Gear Clean/Repair 0.00 1,440.00
106-614-5207-SCBA Maintenance 0.00 1,935.00
106-614-5210-Fire Extinguisher Maintenance 0.00 781.18
106-614-5211-Fire Hydrant Maintenance 0.00 99.79
106-614-5300-Power Tool Maintenance 0.00 262.25
106-614-8000-Debt Interest 0.00 10,027.29
106-614-8010-Debt Issue Costs 0.00 0.00
106-614-8050-Debt Principal 0.00 29,626.37
106-614-8800-Capital Outlay 0.00 194.80
106-614-8800-Capital Outlay-Grants 0.00 0.00
106-615-2200-EMS Equipment 0.00 0.00
106-615-3220-Ambulance Contract 0.00 0.00
106-615-3300-Training 0.00 0.00
106-616-1000-Salaries/Wages 0.00 23,619.46
106-616-1001-Overtime 0.00 7,040.17
106-616-1005-TMRS Retirement 0.00 3,223.83
106-616-1006-Health/Life/Dental Ins. 0.00 3,323.98
106-616-1010-FICA 0.00 2,185.28
106-616-1020-Miscellaneous Personnel Expens 0.00 3.32
106-616-1030-Unemployment Compensation-TWC 0.00 0.00
106-616-1031-Workers Comp. Insurance 0.00 150.99
106-616-2000-Office Supplies 158.00 2,361.23
106-616-2003-Postage 0.00 1,700.00
106-616-2800-Miscellaneous Supplies 0.00 0.00
106-616-2831-COVID-19 0.00 0.00
106-616-3300-Training 0.00 856.42
106-616-3305-Travel 0.00 0.00
106-616-3400-Attorney Fees 0.00 0.00
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 10
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
106-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
106-616-3404-Professional Services 997.75 9,536.50
106-616-3420-IT Technical Support 0.00 0.00
106-616-3421-Website 0.00 0.00
106-616-3450-Magistrate 0.00 6,000.00
106-616-3451-Judge 0.00 22,850.00
106-616-3452-Court Security 0.00 0.00
106-616-3453-Court Technology 0.00 0.00
106-616-3454-Collection Fees 0.00 2,135.62
106-616-3601-Dues & Subscriptions 0.00 1,618.46
106-616-3800-Bank Service Charges 0.00 0.00
106-616-3810-Court Fine Refunds 0.00 0.00
106-616-3850-Fines & Penalties 0.00 0.00
106-616-4000-Electricity 0.00 0.00
106-616-4003-Telephone 0.00 1,499.08
106-616-5000-Office Equip. Maintenance 0.00 0.00
106-616-5006-Licensing & Maintenance Fees 0.00 5,682.18
106-616-8800-Capital Outlay 0.00 0.00
106-616-8800-Capital Outlay-Court Security 0.00 0.00
106-616-8800-Capital Outlay-Court Technolog 0.00 0.00
106-618-1000-Salaries/Wages 0.00 0.00
106-618-1001-Overtime 0.00 0.00
106-618-1005-TMRS Retirement 0.00 0.00
106-618-1006-Health/Life/Dental Ins. 0.00 0.00
106-618-1010-FICA 0.00 0.00
106-618-1020-Miscellaneous Personnel Expens 0.00 0.00
106-618-1030-Unemployment Compensation-TWC 0.00 0.00
106-618-1031-Workers Comp. Insurance 0.00 0.00
106-618-2004-Gasoline 124.59 2,449.11
106-618-2310-Radio Equipment 0.00 0.00
106-618-2800-Miscellaneous Supplies 0.00 250.23
106-618-2801-Miscellaneous Tools 0.00 0.00
106-618-2831-COVID-19 0.00 0.00
106-618-3404-Professional Services 0.00 0.00
106-618-3500-Equipment Rental 0.00 75.00
106-618-3700-Liability Insurance 0.00 0.00
106-618-5002-Vehicle Maintenance 0.00 66.54
106-618-5003-Machinery Maintenance 0.00 29.96
106-618-5006-Licensing & Maintenance Fees 0.00 0.00
106-618-5007-Street Signs 0.00 1,544.17
106-618-5100-Street Maintenance 0.00 28,968.76
106-618-5101-Asphalt/Seal Coating 0.00 15,030.13
106-618-5110-Roadway Landscaping Expense 400.00 2,400.00
106-618-8000-Debt Interest 95.93 1,547.50
106-618-8050-Debt Principal 283.13 10,071.17
106-618-8800-Capital Outlay 0.00 0.00
106-619-3725-Sanitation Contract 0.00 291,500.07
106-620-2800-Miscellaneous Supplies 20.46 7,130.92
106-620-3700-Liability Insurance 0.00 0.00
106-620-8800-Capital Outlay 0.00 3,883.49
106-621-2002-Janitorial Supplies 0.00 0.00
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 11
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
106-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
106-621-2800-Miscellaneous Supplies 0.00 0.00
106-621-3404-Professional Services 0.00 0.00
106-621-3752-Tarrant County Food Bank 0.00 0.00
106-621-4000-Electricity 0.00 0.00
106-621-4001-Gas Service 0.00 0.00
106-621-4003-Telephone 0.00 0.00
106-621-5001-Building Maintenance 0.00 0.00
106-622-1000-Salaries/Wages 1,674.40 22,532.65
106-622-1001-Overtime 92.77 1,984.10
106-622-1005-TMRS Retirement 188.56 2,575.44
106-622-1006-Health/Life/Dental 554.47 4,802.05
106-622-1010-FICA 133.40 1,852.31
106-622-1020-Miscellaneous Personnel Expens 0.00 0.00
106-622-1030-Unemployment Compensation 0.00 0.00
106-622-1031-Workers Comp. Insurance 0.00 546.36
106-622-2000-Office Supplies 0.00 1,364.50
106-622-2800-Miscellaneous Supplies 0.00 0.00
106-622-2831-COVID-19 0.00 0.00
106-622-3300-TRAINING 0.00 0.00
106-622-3305-Travel 0.00 0.00
106-622-3352-Background Checks 0.00 0.00
106-622-3401-Inspection Fees 0.00 42,600.00
106-622-3404-Professional Services 0.00 950.00
106-622-3420-IT Technical Support 0.00 2,318.07
106-622-3600-Legal Publications 0.00 0.00
106-623-1000-Salaries/Wages 3,852.56 44,882.01
106-623-1001-Overtime 26.76 819.93
106-623-1005-TMRS Retirement 413.92 4,792.21
106-623-1006-Health/Life/Dental Ins. 1,107.96 9,226.61
106-623-1010-FICA 294.47 3,468.01
106-623-1020-Miscellaneous Personnel Expens 0.00 0.00
106-623-1030-Unemployment Compensation-TWC 0.00 0.00
106-623-1031-Workers Comp. Insurance 0.00 286.31
106-623-2000-Office Supplies 15.99 331.13
106-623-2003-Postage 0.00 900.00
106-623-2004-Gasoline 0.00 932.02
106-623-2300-Uniforms 0.00 268.54
106-623-2310-Radio Equipment 0.00 0.00
106-623-2800-Miscellaneous Supplies 0.00 0.99
106-623-2831-COVID-19 0.00 0.00
106-623-3300-Training 0.00 250.00
106-623-3404-Professional Services 0.99 2.97
106-623-3420-IT Technical Support 0.00 2,144.24
106-623-3440-Radio Services 0.00 0.00
106-623-3570-Property Abatement 0.00 0.00
106-623-3850-Fines & Penalties 0.00 0.00
106-623-3915-Vehicle Lease 44.58 9,178.98
106-623-4003-Telephone 0.00 1,038.83
106-623-5000-Office Equip. Maintenance 0.00 0.00
106-623-5002-Vehicle Maintenance 0.00 593.70
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 12
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
106-GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
106-623-5006-Licensing & Maintenance Fees 0.00 2,390.66
106-623-8000-Debt Interest 0.00 0.00
106-623-8050-Debt Principal 0.00 0.00
106-623-8800-Capital Outlay 0.00 0.00
106-624-3420-IT Technical Support 0.00 0.00
106-626-3900-MODULAR LEASE 0.00 0.00
106-626-3901-MODULAR IMPROVEMENTS 0.00 0.00
106-626-5001-Building Maintenance 0.00 0.00
106-626-5008-Landscaping 0.00 0.00
106-626-8800-Capital Outlay 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 250,472.08 1,821.98 4,114,109.41 2,732.71
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 803,110.39 803,110.39 5,563,350.40 5,563,350.40
============== ============== ============== ==============
*** END OF REPORT ***
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
206-CRIME CONTROL DISTRICT
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
206-10000 Claim on Pooled Cash 13,454.04 362,330.18
206-10015 BOT CCPD 0.00 293,023.16
206-10016 Chase Bank - CCPD 0.00 0.00
206-1003 Government Capital Lending 0.00 0.00
206-10161 LOGIC CCPD Fund 0.00 1,124.12
206-10210 Sales Tax Receivable 0.00 63,492.49
206-10229 Other Receivables 0.00 11.08
206-10801 Due From General Fund 0.00 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 13,454.04 357,639.77 362,341.26
============== ============== ============== ==============
LIABILITIES
===========
206-20105 Accounts Payable Accrued 0.00 0.00
206-20110 Accounts Payable Control 208.12 518.11
206-20111 Accounts Payable Other 0.00 187.79
206-20200 Wages Payable 0.00 3,150.69
206-20201 FIT Payable 0.00 0.00
206-20202 FICA Payable 0.00 176.65
206-20203 TWC Payable 0.00 0.00
206-20204 TMRS Payable 0.00 25.20
206-20205 Workmans Comp Payable 0.00 0.00
206-20206 Health/Life/Dental Payable 0.00 114.27
206-20209 VISION PLAN PAYABLE 0.00 16.13
206-20210 Dental & Life Payable 0.00 13.23
206-20212 MISC PY DEDUCTION PAYABLE 0.00 744.42
206-20214 LT Disability Payable 0.00 0.00
206-20801 Due to GF 0.00 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 208.12 0.00 518.11 4,428.38
============== ============== ============== ==============
FUND BALANCE
============
206-30100 Fund Balance 0.00 99,616.36
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 99,616.36
============== ============== ============== ==============
REVENUES
========
206-50100 Sales Tax-General 0.00 230,476.51
206-54000 INTEREST 0.00 391.56
206-55000 Grant Revenue- General 0.00 0.00
206-57000 Miscellaneous Revenue 0.00 0.00
206-58500 Loan/Lease Proceeds 0.00 0.00
206-59901 Transfer from GF 0.00 0.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 230,868.07
============== ============== ============== ==============
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
206-CRIME CONTROL DISTRICT
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
EXPENDITURES
============
206-613-3300- 0.00 0.00
206-625-1000-Salaries/Wages 8,813.93 177,588.76
206-625-1001-Overtime 158.04 4,600.84
206-625-1005-TMRS Retirement 943.65 18,775.78
206-625-1006-Hlth/Life/Dental Ins 1,494.50 20,021.99
206-625-1010-FICA 671.95 13,647.56
206-625-1029-New Hire Testing & Physicals 0.00 2,910.00
206-625-1030-Unempl Comp Ins 0.00 0.00
206-625-1031-Wkr Comp Ins 0.00 1,717.50
206-625-2000-Office Supplies 0.00 181.04
206-625-2003-Postage 0.00 0.00
206-625-2004-Gasoline 0.00 0.00
206-625-2209-Safety Equipment 0.00 0.00
206-625-2211-Jail Expenses 0.00 0.00
206-625-2300-Uniforms 0.00 1,640.12
206-625-2310-Radio Equipment 0.00 0.00
206-625-2320-Car Equipment 0.00 0.00
206-625-2800-Miscellaneous Supplies 75.98 101.17
206-625-2801-Range Supplies 0.00 6,957.00
206-625-2831-COVID-19 0.00 0.00
206-625-3200-Citizens On Patrol Program 0.00 0.00
206-625-3200-Crime Watch Meetings 0.00 255.15
206-625-3200-National Night Out 0.00 2,150.66
206-625-3200-Community/Staff Programs 323.46 2,834.27
206-625-3300-Training 346.50 1,597.95
206-625-3305-Travel 0.00 0.00
206-625-3400-Attorney 0.00 0.00
206-625-3420-IT Technical Support 0.00 1,400.00
206-625-3430-Lab Analysis/ Reports 0.00 1,340.00
206-625-3500-Bike Patrol Supplies 0.00 0.00
206-625-3500-K-9 Supplies 213.16 4,149.57
206-625-3600-Online Sexual Crimes Unit 0.00 0.00
206-625-3601-Dues & Subscriptions 204.75 2,359.50
206-625-3602-Legal Publications 0.00 0.00
206-625-3606-Sales Tax Audit 0.00 0.00
206-625-3800-Bank Service Charges 0.00 0.00
206-625-3900-Modular Lease 0.00 0.00
206-625-4002-Air Cards 0.00 2,520.00
206-625-5002-Vehicle Maintenance 0.00 0.00
206-625-5006-Licensing & Maintenance Fees 0.00 72,347.33
206-625-8000-Debt Interest 0.00 0.00
206-625-8050-Debt Principal 0.00 0.00
206-625-8800-Capital Outlay 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 13,245.92 0.00 339,096.19 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 13,454.04 13,454.04 697,254.07 697,254.07
============== ============== ============== ==============
*** END OF REPORT ***
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
210-COURT SECURITY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
210-10000 Claim on Pooled Cash 416.39 65,982.57
______________ ______________ ______________ ______________
TOTAL ASSETS 416.39 0.00 65,982.57 0.00
============== ============== ============== ==============
LIABILITIES
===========
210-20110 Accounts Payable Control 0.00 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
FUND BALANCE
============
210-30100 Fund Balance 0.00 62,347.77
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 62,347.77
============== ============== ============== ==============
REVENUES
========
210-53900 COURT SECURITY FEES 416.39 3,634.80
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 416.39 0.00 3,634.80
============== ============== ============== ==============
EXPENDITURES
============
210-616-3452-Court Security 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 416.39 416.39 65,982.57 65,982.57
============== ============== ============== ==============
*** END OF REPORT ***
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
220-COURT TECHNOLOGY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
220-10000 Claim on Pooled Cash 44.45 9,266.83
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 44.45 9,266.83 0.00
============== ============== ============== ==============
LIABILITIES
===========
220-20105 Accounts Payable Accrued 0.00 0.00
220-20110 Accounts Payable Control 399.28 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 399.28 0.00 0.00 0.00
============== ============== ============== ==============
FUND BALANCE
============
220-30100 Fund Balance 0.00 9,148.88
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 9,148.88
============== ============== ============== ==============
REVENUES
========
220-53901 COURT TECHNOLOGY FEES 354.83 3,088.46
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 354.83 0.00 3,088.46
============== ============== ============== ==============
EXPENDITURES
============
220-616-3300-Training 0.00 0.00
220-616-3420-IT Technical Support 0.00 2,970.51
220-616-3453-Court Technology 0.00 0.00
220-616-5006-Licensing & Maintenance Fees 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 2,970.51 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 399.28 399.28 12,237.34 12,237.34
============== ============== ============== ==============
*** END OF REPORT ***
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
230-GRANT FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
230-10000 Claim on Pooled Cash 0.00 4,117.84
230-10229 Other Receivables 0.00 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 4,117.84 0.00
============== ============== ============== ==============
LIABILITIES
===========
230-20110 Accounts Payable Control 0.00 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
FUND BALANCE
============
230-30100 Fund Balance 0.00 4,117.84
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 4,117.84
============== ============== ============== ==============
REVENUES
========
230-55011 Tarrant Co 911 0.00 0.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
EXPENDITURES
============
230-613-2310-Radio Equipment 0.00 0.00
230-613-2800-Miscellaneous Supplies 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 4,117.84 4,117.84
============== ============== ============== ==============
*** END OF REPORT ***
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
240-CARES Act Fund
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
240-10000 Claim on Pooled Cash 0.00 19.59
240-10040 CARES Act BOT Cash 0.00 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 0.00 19.59
============== ============== ============== ==============
LIABILITIES
===========
240-20110 Accounts Payable Control 0.00 0.00
240-20801 Due to GF 0.00 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
FUND BALANCE
============
240-30100 Fund Balance 0.00 19.59
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 19.59 0.00
============== ============== ============== ==============
REVENUES
========
240-54000 Interest 0.00 0.00
240-56040 CARES Act Revenue 0.00 0.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
EXPENDITURES
============
240-612-9106-Transfer to General Fund 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 19.59 19.59
============== ============== ============== ==============
*** END OF REPORT ***
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
245-ARPA Fund
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
245-10000 Claim on Pooled Cash 0.00 0.00
245-10045 BOT ARPA Cash 0.00 139.14
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 139.14 0.00
============== ============== ============== ==============
LIABILITIES
===========
245-20110 Accounts Payable Control 0.00 0.00
245-20801 Due to General Fund 0.00 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
FUND BALANCE
============
245-30100 Fund Balance 0.00 0.00
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 0.00
============== ============== ============== ==============
REVENUES
========
245-54000 Interest 0.00 139.14
245-56045 ARPA Revenue 0.00 0.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 139.14
============== ============== ============== ==============
EXPENDITURES
============
245-612-9106-Transfer to General Fund 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 139.14 139.14
============== ============== ============== ==============
*** END OF REPORT ***
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
305-Texas Insurance Trust
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
305-10000 Claim on Pooled Cash 45,641.51 136,636.93
305-10509 Prepaid Expenses 0.00 0.00
305-10801 Due From General Fund 0.00 33,297.87
305-10806 Due from Utility Fund 0.00 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 45,641.51 0.00 136,636.93 33,297.87
============== ============== ============== ==============
LIABILITIES
===========
305-20110 Accounts Payable Control 126.48 126.48
305-20111 Accounts Payable Adjusting 40,434.23 31,687.94
305-20199 Ins Trust Trf Adj 0.00 0.00
305-20206 Health 2,486.88 36,260.25
305-20209 Vision 340.90 4,368.21
305-20210 Dental 635.74 8,804.31
305-20214 Long Term Disability 0.00 0.00
305-20215 FLEX SPENDING ACCT 1,617.28 22,191.35
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 45,641.51 0.00 103,438.54
============== ============== ============== ==============
FUND BALANCE
============
305-30100 Fund Balance 0.00 100.19
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 100.19 0.00
============== ============== ============== ==============
REVENUES
========
305-54000 Interest 0.00 18.66
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 18.66
============== ============== ============== ==============
EXPENDITURES
============
305-612-3800-Bank charges 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 45,641.51 45,641.51 136,737.12 136,755.07
============== ============== ============== ==============
*** AMOUNT OUT OF BALANCE *** 0.00 17.95CR
*** END OF REPORT ***
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
306-SANSOM PARK EDC
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
306-10000 Claim on Pooled Cash 179.80 3,462,718.38
306-10010 Bank of Texas EDC 0.00 0.00
306-10011 Wells Fargo EDC 4285 0.00 0.00
306-10012 CASH 3518 0.00 0.00
306-10161 LOGIC EDC Fund 0.00 68,631.16
306-10206 Loan Receivable 0.00 0.00
306-10210 Sales Tax Receivable 0.00 34,360.16
306-10509 Prepaid Expense 0.00 0.00
306-10801 Due from GF 0.00 48,684.95
306-10806 Due From The Water/Sewer Fund 0.00 0.00
306-11000 Equipment 0.00 9,994.00
306-11001 Street Improvements 0.00 96,861.00
306-11002 Land 0.00 1,274,817.30
306-11100 Accumulated Depreciation 0.00 106,855.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 179.80 4,996,066.95 106,855.00
============== ============== ============== ==============
LIABILITIES
===========
306-20105 Accounts Payable Accrued 0.00 0.00
306-20110 Accounts Payable 0.00 0.00
306-20130 Property Taxes Payable 0.00 71,826.25
306-20201 FIT Withholding Payable 0.00 0.00
306-20202 FICA Taxes Payable 0.00 0.00
306-20204 TMRS Payable 0.00 0.00
306-20410 Property Tax Payable 0.00 71,996.04
306-20801 Due to GF 0.00 235,000.00
306-20806 Due to Water and Sewer Fund 0.00 0.00
306-20900 LT Debt Current 0.00 0.00
306-20931 TX Mezzanine Payable 01 0.00 450,000.00
306-20932 TX Mezzanine Payable 0.00 435,000.00
306-20950 Accrued Interest Payable 0.00 439.89
306-21900 LT Debt Non-Current 0.00 3,309,125.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 71,826.25 4,501,560.93
============== ============== ============== ==============
FUND BALANCE
============
306-30100 Fund Balance 0.00 414,763.49
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 414,763.49
============== ============== ============== ==============
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
306-SANSOM PARK EDC
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
REVENUES
========
306-50100 Sales Tax-General 0.00 183,858.35
306-54000 Interest Earnings 0.00 2,529.15
306-56000 Grant Revenue 0.00 0.00
306-57000 Miscellaneous Revenue 0.00 11.16
306-57100 Sale of Assets 0.00 0.00
306-57900 Contributed Capital 0.00 0.00
306-58501 Debt Proceeds 0.00 0.00
306-58510 Use of Fund Balance 0.00 0.00
306-59901 Transfer from GF 0.00 0.00
306-59906 Transfer from W/S Fund 0.00 0.00
306-59907 Transfer from TIF Fund 0.00 0.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 186,398.66
============== ============== ============== ==============
EXPENDITURES
============
306-600-3402-Contract Labor 0.00 0.00
306-612-1006-Health/Life/Dental Ins. 0.00 0.00
306-612-2000-Office Supplies 0.00 0.00
306-612-2800-Miscellaneous Supplies 0.00 0.00
306-612-3051-Planning & Zoning 0.00 135.38
306-612-3200-COMMUNITY/ STAFF PROGRAMS 85.39 707.99
306-612-3300-Training 0.00 800.00
306-612-3305-Travel 0.00 0.00
306-612-3400-Attorney Fees 0.00 7,781.50
306-612-3402-Contract Labor 0.00 23,125.00
306-612-3404-Professional Services 0.00 10,068.75
306-612-3421-Website 0.00 0.00
306-612-3510-Rent Expense 0.00 0.00
306-612-3600-Legal Publications 0.00 130.00
306-612-3601-Dues & Subscriptions 0.00 0.00
306-612-3603-Marketing Expenses 94.41 15,219.79
306-612-3604-Property Tax Expense 0.00 2,555.53
306-612-3605-Incentive Expense 0.00 0.00
306-612-3606-Sales Tax Audit 0.00 0.00
306-612-3800-Bank Service Charges 0.00 0.00
306-612-4000-Electricity 0.00 0.00
306-612-5006-Licensing & Maintenance Fees 0.00 0.00
306-612-5110-Roadway Landscaping 0.00 0.00
306-612-5999-Reserve-Maintenance 0.00 0.00
306-612-8000-Debt Interest 0.00 0.00
306-612-8010-Debt Issue Costs 0.00 49,125.00
306-612-8050-Debt Principal 0.00 2,360.00
306-612-8800-Capital Outlay 0.00 0.00
306-612-8800-East Jacksboro Hwy Project 0.00 0.00
306-612-9106-Transfer to General Fund 0.00 29,675.94
306-612-9903-Transfer to General Fund 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 179.80 0.00 141,684.88 0.00
============== ============== ============== ==============
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
306-SANSOM PARK EDC
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 179.80 179.80 5,209,578.08 5,209,578.08
============== ============== ============== ==============
*** END OF REPORT ***
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
307-TAX INCREMENT FINANCING
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
307-10000 Claim On Pooled Cash 80.00 97,657.12
307-10070 CASH BOT TIF 0.00 1,230,508.63
307-10801 Due from General Fund 473,811.00 473,811.00
307-10805 Due from Debt Svc Fd 125,842.00 125,842.00
______________ ______________ ______________ ______________
TOTAL ASSETS 599,653.00 80.00 1,830,161.63 97,657.12
============== ============== ============== ==============
LIABILITIES
===========
307-20105 Accounts Payable Accrued 0.00 0.00
307-20110 Accounts Payable Control 0.00 0.00
307-20111 Accounts Payable Adjusting 0.00 0.00
307-20201 FIT Withholding Payable 0.00 0.00
307-20202 FICA Taxes Payable 0.00 0.00
307-20204 TMRS Payable 0.00 0.00
307-20801 Due to GF 0.00 5,750.00
307-20803 Due To General Fund 0.00 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 5,750.00 0.00
============== ============== ============== ==============
FUND BALANCE
============
307-30100 Fund Balance 0.00 1,202,564.81
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 1,202,564.81
============== ============== ============== ==============
REVENUES
========
307-50000 Property Tax City 599,653.00 599,653.00
307-50550 TIF Reimb - Tarrant Co College 0.00 0.00
307-50551 TIF Reimb - Tarrant Co 0.00 116,872.08
307-50552 TIF Reimb - Tarrant Co Hosp 0.00 90,669.07
307-54000 Interest 0.00 1,485.99
307-57000 Miscellaneous Income 0.00 0.00
307-58500 Loan/Lease Proceeds 0.00 0.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 599,653.00 0.00 808,680.14
============== ============== ============== ==============
EXPENDITURES
============
307-612-1006-Health/Life/Dental Ins. 0.00 0.00
307-612-3400-Attorney Fees 80.00 80.00
307-612-3404-Professional Services 0.00 2,968.75
307-612-3417-Admin Services 0.00 0.00
307-612-3605-Incentives 0.00 0.00
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
307-TAX INCREMENT FINANCING
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
307-612-3800-Bank Service Charges 0.00 0.00
307-612-3888-Developer Reimb 0.00 0.00
307-612-8000-Interest 0.00 9,725.00
307-612-8050-Principal 0.00 50,000.00
307-612-8055-Paying Agent 0.00 0.00
307-612-8867-Drainage Improvements 0.00 0.00
307-612-8868-Infrastructure Impv 0.00 0.00
307-612-8869-Commercial Site Impv 0.00 0.00
307-612-8870-Facade Impv Program 0.00 0.00
307-612-9106-Transfer to General Fd 0.00 72,916.69
307-612-9903-Transfer to EDC Fund 0.00 0.00
307-612-9907-Transfer to WS CIP Fund 0.00 137,300.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 80.00 0.00 272,990.44 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 599,733.00 599,733.00 2,108,902.07 2,108,902.07
============== ============== ============== ==============
*** END OF REPORT ***
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
406-CITY FACILITIES
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
406-10000 Claim on Pooled Cash 10,762.46 212,069.05
406-10146 LOGIC CIP St Impv 2021 CO 0.00 3,442,100.81
406-10147 LOGIC 2023 Tax Note 0.00 167,258.80
406-10804 Due From City Facilities 0.00 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 10,762.46 3,609,359.61 212,069.05
============== ============== ============== ==============
LIABILITIES
===========
406-20010 Accounts Payable Accruals 0.00 0.00
406-20110 Accounts Payable Control 0.00 0.00
406-20111 Accounts Payable Other 0.00 0.00
406-20125 Retainage 0.00 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
FUND BALANCE
============
406-30100 Fund Balance 0.00 3,560,120.61
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 3,560,120.61
============== ============== ============== ==============
REVENUES
========
406-50005 Intergov't Grant Revenue 0.00 0.00
406-54000 Interest Earnings 0.00 0.00
406-56005 Intergov't Grant Revenue 0.00 0.00
406-58500 Loan/Lease Proceeds 0.00 0.00
406-58520 Debt Issue Premium 0.00 968.03
406-59901 Transfer from Gen Fd 0.00 0.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 968.03
============== ============== ============== ==============
EXPENDITURES
============
406-612-3403-Retainage 0.00 0.00
406-612-3404-Professional Services 0.00 1,600.00
406-612-8000-Debt Interest 0.00 0.00
406-612-8010-Debt Issue Costs 0.00 0.00
406-612-8050-Debt Principal 0.00 0.00
406-612-8800-Capital Outlay 0.00 23,701.14
406-612-8855-Capital Outllay - Comm Ctr 0.00 0.00
406-612-8860-Skyline Engineering 10,762.46 99,651.97
406-612-8860-Skyline Construction 0.00 0.00
406-613-8800-Capital Outlay 0.00 31,661.74
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
406-CITY FACILITIES
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
406-614-8800-Capital Outlay 0.00 7,183.23
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 10,762.46 0.00 163,798.08 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 10,762.46 10,762.46 3,773,157.69 3,773,157.69
============== ============== ============== ==============
*** END OF REPORT ***
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
500-GENERAL LONG TERM DEBT
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
500-10260 Amount To Be Provided 0.00 5,380,071.78
500-19000 Net Pension Asset 0.00 109,863.06
500-19800 Def Outflow - OPEB SDBF Contri 0.00 3,635.64
500-19820 Def Outflow OPEB SDBF Exp 0.00 6,114.44
500-19860 DEF OUTFL Diff Assumpt OPEB SD 0.00 16,815.28
500-19900 Def Outflow - Pension Contrib 0.00 103,696.28
500-19950 Def Outflow - Pension Inv Exp 0.00 185,646.56
500-19960 Def Outflow - Diff Assumpt Chg 0.00 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 5,679,164.70 126,678.34
============== ============== ============== ==============
LIABILITIES
===========
500-20213 Compensated Absences Current 0.00 7,461.82
500-20820 Debt Issue Premium 0.00 74,416.39
500-20900 Lease Payable-ST 0.00 29,626.37
500-20910 Tax Notes-ST 0.00 85,000.00
500-20915 Loans-ST 0.00 0.00
500-20920 EDC Notes Payable-ST 0.00 0.00
500-20930 Bonds - ST 0.00 229,000.00
500-21213 Compensated Absences Non Curr 0.00 67,156.40
500-21900 Lease Payable-LT 0.00 275,858.51
500-21910 Tax Notes-LT 0.00 375,000.00
500-21915 Loans-LT 0.00 8,269.68
500-21920 EDC Notes Payable-LT 0.00 0.00
500-21930 Bonds-LT 0.00 4,347,000.00
500-29500 Def Inflow - Pension Actual v 0.00 2,429.38
500-29800 OPEB SDBF Liability 0.00 56,126.57
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 2,429.38 5,554,915.74
============== ============== ============== ==============
FUND BALANCE
============
500-30100 Fund Balance 0.00 0.00
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 5,681,594.08 5,681,594.08
============== ============== ============== ==============
*** END OF REPORT ***
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
506-STORMWATER
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
506-10000 Claim on Pooled Cash 14,373.62 387,110.38
506-10217 Unbilled Revenue Receivable 0.00 3,600.77
506-10229 Other Receivables 0.00 0.00
506-11003 MACHINERY & EQUIPMENT 0.00 71,604.00
506-11103 ACC DEPR MACH & EQUIP 0.00 22,497.87
______________ ______________ ______________ ______________
TOTAL ASSETS 14,373.62 0.00 462,315.15 22,497.87
============== ============== ============== ==============
LIABILITIES
===========
506-20105 Accrued Accounts Payable 0.00 0.00
506-20110 Accounts Payable Control 0.00 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
FUND BALANCE
============
506-30100 Fund Balance 0.00 383,269.57
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 383,269.57
============== ============== ============== ==============
REVENUES
========
506-52503 Stormwater Services Revenue 14,373.62 86,372.86
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 14,373.62 0.00 86,372.86
============== ============== ============== ==============
EXPENDITURES
============
506-605-3300-Training 0.00 0.00
506-605-3305-Travel 0.00 0.00
506-605-3400-Attorney Fees 0.00 0.00
506-605-3404-Professional Services 0.00 16,683.01
506-605-3600-Legal Publications 0.00 0.00
506-605-5009-Stormwater System Maintenance 0.00 2,580.00
506-605-9500-DEPRECIATION EXPENSE 0.00 0.00
506-605-9700-Bad Debt Expense 0.00 10,562.14
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 29,825.15 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 14,373.62 14,373.62 492,140.30 492,140.30
============== ============== ============== ==============
*** END OF REPORT ***
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
606-WATER/SEWER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
606-10000 Claim on Pooled Cash 133,138.48 389,562.46
606-10114 USDA Debt Service Reserve 0.00 0.00
606-10115 Prepaid USDA P&I 0.00 0.00
606-10116 Prepaid USDA Principal 0.00 0.00
606-10155 LOGIC Water & Sewer 0.00 964,096.47
606-10156 TexStar Water/Sewer 1031 0.00 0.00
606-10157 Customer Meter Deposits CD 0.00 0.00
606-10160 Petty Cash on Hand 0.00 530.00
606-10199 Cash Over/Short 0.00 1,235.12
606-10215 Water and Sewer Services Recei 229,826.74 412,028.59
606-10217 Unbilled Revenue Receivable 0.00 119,636.28
606-10219 Allowance for Bad Debts-W/S 0.00 136,087.45
606-10229 Other Receivables 0.00 25.34
606-10230 Accrued Interest Receivable 0.00 0.00
606-10232 NSF Checks Receivable 0.00 0.48
606-10255 USDA Receivable 0.00 0.00
606-10509 Prepaid Expenses 0.00 0.00
606-10510 Def Gain/Loss on Debt Ref 0.00 40,539.23
606-10801 Due from GF 0.00 0.00
606-10803 Due From EDC Fund 0.00 0.00
606-10809 Due From Insurance Trust 0.00 0.00
606-10999 Reserve-Maintenance 0.00 0.00
606-11001 Land 0.00 31,551.25
606-11002 Building and Building Improvem 0.00 0.00
606-11003 Machinery and Equipment 0.00 906,836.95
606-11007 Water Infrastructure 0.00 9,804,013.39
606-11008 Sewer Infrastructure 0.00 596,479.75
606-11009 Intangible Assets 0.00 0.00
606-11014 Construction in Progress 0.00 127,280.43
606-11102 Accum. Depreciation-Buildings 0.00 0.00
606-11103 Acc Depr - Equipment 0.00 1,026,919.96
606-11107 Acc Depr - W&S Infrastructure 0.00 4,272,162.12
606-11109 Accum Amortization-Intangibles 0.00 0.00
606-19000 Net Pension Asset 0.00 41,406.94
606-19800 DEF OUTFLOW OPEB SDBF Contri 0.00 1,251.36
606-19820 Def Outflow OPEB SDBF Exp 0.00 2,104.56
606-19860 DEF OUTFL Diff Assum Chg OPEB 0.00 5,787.72
606-19900 Def Outflow-Pension Contrib 0.00 39,082.82
606-19950 Def Outflow-Pension Invst Exp 0.00 69,969.44
606-19960 Def Outflow - Diff Assumpt Chg 0.00 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 362,965.22 0.00 13,506,223.44 5,482,364.67
============== ============== ============== ==============
LIABILITIES
===========
606-20105 Accounts Payable Accrued 0.00 0.00
606-20110 Accounts Payable Control 25,315.92 10,448.79
606-20111 Accounts Payable Other 0.00 208.00
606-20117 Unapplied Credit Liability 301.61 9,741.32
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
606-WATER/SEWER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
606-20118 Customer Meter Deposits Payabl 165.00 202,620.00
606-20119 UB Refunds Payable 663.06 20,875.74
606-20124 2011 Rev Bd Series A-1 0.00 0.00
606-20125 Waterworks Rev Bond Series A-2 0.00 0.00
606-20160 Due to Other Agencies 0.00 0.00
606-20200 Wages Payable 0.00 9,994.78
606-20201 FIT Withholding Payable 0.00 180.73
606-20202 FICA Taxes Payable 0.00 249.67
606-20203 TWC Payable 0.00 0.00
606-20204 TMRS Payable 0.00 3,000.00
606-20205 Workers Comp Payable 0.00 0.00
606-20206 Group Health & Life Payable 0.00 1,244.52
606-20207 AFLAC Payable 0.00 0.00
606-20208 Pre-paid Legal Payable 0.00 0.00
606-20209 Vision Plan Payable 0.00 78.78
606-20210 Dental & Life Payable 0.00 53.12
606-20211 Garnishments Payable 0.00 0.00
606-20212 Misc. PY Deduction Payable 0.00 3,953.18
606-20213 Compensated Absences Current 0.00 4,681.79
606-20214 LT Disability Payable 0.00 0.00
606-20215 FLEX SPENDING ACCT 0.00 0.00
606-20220 Child Support Payable 0.00 0.00
606-20299 Bank Overdraft Liability 0.00 0.00
606-20801 Due to GF 0.00 0.00
606-20803 Due to EDC 0.00 0.00
606-20809 Due To Insurance Trust 0.00 0.00
606-20900 Lease Payable-ST 0.00 0.00
606-20905 Bonds-ST 0.00 55,000.00
606-20910 Notes Payable ST 0.00 0.03
606-20920 Note Payable LT 0.00 0.00
606-20924 2011 Rev Bd Series A-1 Current 0.00 0.00
606-20925 2011 Rev Bd Series A-2 0.00 0.00
606-20930 Def Debt Issue Premium 0.00 46,479.96
606-20950 Accrued Interest 0.00 13,600.66
606-20990 Bank adjustment items 0.00 0.00
606-21213 Compensated Absences Non Curr 0.00 42,135.78
606-21900 Lease Payable-LT 0.00 31,081.82
606-21905 Bonds-LT 0.00 2,345,000.00
606-21955 TX Water Well Loan 0.00 403,449.99
606-29500 Def Inflow-Pension Actual v As 0.00 915.62
606-29800 OPEB SDBF Liability 0.00 19,318.43
______________ ______________ ______________ ______________
TOTAL LIABILITIES 25,782.53 663.06 1,096.38 3,223,216.33
============== ============== ============== ==============
FUND BALANCE
============
606-30100 Fund Balance 0.00 4,696,391.73
606-30210 Encumbrances 0.00 0.00
606-39999 Adjusting Account 0.00 0.00
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 4,696,391.73
============== ============== ============== ==============
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
606-WATER/SEWER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
REVENUES
========
606-52111 Returned Check Fees 35.00 105.00
606-52500 Water Services Revenue 251,579.47 1,392,078.49
606-52501 Sewer Services Revenue 235,303.25 1,389,410.79
606-52502 NORTHERN TRINITY 5,273.52 29,298.25
606-52503 STORMWATER 0.00 0.00
606-52510 Late Charges 4,000.00 50,720.00
606-52511 Meter Deposit Service Charge 375.00 4,250.00
606-52524 Water Tap Fees 3,400.00 11,247.50
606-52525 Sewer Tap Fees 13,184.00 17,212.00
606-52526 Ft. Worth Access Fees 0.00 0.00
606-52527 Tie-In Fees 0.00 3,000.00
606-52580 Transfer Fee 0.00 0.00
606-52581 Reconnect Charge 6,160.00 41,410.00
606-52582 Reconnect After-Hours 0.00 0.00
606-52585 Tampering Fee 100.00 2,000.00
606-52590 Temporary Service Revenue 0.00 0.00
606-54000 Interest Earnings 0.00 34,711.73
606-55901 Transfer In 0.00 0.00
606-55910 Transfer In WS CIP Fd 0.00 0.00
606-55911 Transfer from USDA Proj Fd 0.00 0.00
606-56000 Grant Revenue 0.00 0.00
606-57000 Miscellaneous Revenue 0.00 10.80
606-57300 Insurance Claims Revenue 0.00 0.00
606-57310 Contractor Reimbursements 2,370.00 2,482.95
606-57900 Sale of Surplus Property 0.00 30,730.00
606-57901 Sale of Scrap 0.00 1,940.65
606-58500 Loan/Lease Proceeds 0.00 0.00
606-58505 Contributed Capital 0.00 0.00
606-59901 Transfer from GF 0.00 0.00
606-59909 Transfer from TIF 0.00 0.00
606-59910 Transfer From Fd 610 0.00 0.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 521,780.24 0.00 3,010,608.16
============== ============== ============== ==============
EXPENDITURES
============
606-600-1005-TMRS Retirement 0.00 0.00
606-600-1006-Health/Life/Dental Ins. 0.00 0.00
606-600-1010-FICA 0.00 0.00
606-600-8050-Debt Principal 0.00 0.00
606-600-9700-Bad Debt Expense 0.00 0.00
606-600-9701-System Conversion 0.00 0.00
606-600-9901-Transfer to GF 0.00 0.00
606-600-9903-Transfer to EDC Fund 0.00 0.00
606-601-1000-Salaries/Wages 54,485.65 724,047.44
606-601-1001-Overtime 1,860.45 32,844.48
606-601-1005-TMRS Retirement 5,585.34 74,352.60
606-601-1006-Health/Life/Dental Ins. 12,776.00 107,709.04
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 4
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
606-WATER/SEWER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
606-601-1010-FICA 4,207.73 56,576.64
606-601-1020-PrePaid Legal 0.00 0.00
606-601-1021-Miscellaneous Personnel Expens 0.00 474.96
606-601-1030-Unemployment Compensation-TWC 0.00 0.00
606-601-1031-Workers Comp. Insurance 0.00 20,740.47
606-601-2000-Office Supplies 144.82 6,825.42
606-601-2001-Copier Supplies 0.00 1,413.65
606-601-2002-Janitorial Supplies 0.00 354.57
606-601-2003-Postage 930.15 14,515.22
606-601-2004-Gasoline 0.00 16,320.83
606-601-2005-Chemical Supplies 1,834.95 32,966.93
606-601-2100-Computer Equipment & Supplies 0.00 0.00
606-601-2111-Street Maint. Supplies 0.00 0.00
606-601-2300-Uniforms 32.46 3,920.29
606-601-2310-Radio Equipment 0.00 0.00
606-601-2800-Miscellaneous Supplies 448.37 7,043.22
606-601-2801-Miscellaneous Tools 7.73 4,415.64
606-601-2831-COVID-19 0.00 0.00
606-601-3200-Community/Staff Programs 362.35 8,610.31
606-601-3300-Training 211.00 1,683.77
606-601-3305-Travel 0.00 133.00
606-601-3400-Attorney Fees 0.00 4,141.25
606-601-3403-Audit Services 0.00 7,741.25
606-601-3404-Professional Services 2,000.00 32,888.76
606-601-3420-IT Technical Support 0.00 13,594.92
606-601-3421-Website 0.00 0.00
606-601-3430-Community Dev. Consultant 0.00 0.00
606-601-3500-Equipment Rental 0.00 1,318.71
606-601-3501-Postal Machine Rental 0.00 3,425.43
606-601-3510-Rent Expense 0.00 0.00
606-601-3600-Legal Publications 0.00 0.00
606-601-3601-Dues & Subscriptions 111.00 5,665.81
606-601-3700-Liability Insurance 0.00 38,525.06
606-601-3701-Insurance Claim Expense 0.00 0.00
606-601-3755-CDBG Supplement Expenses 0.00 0.00
606-601-3800-Bank Service Charges 0.00 78,995.31
606-601-3801-USDA Trust Services 0.00 0.00
606-601-3850-Fines & Penalties 0.00 0.00
606-601-3900-Modular Lease 0.00 0.00
606-601-3910-Copier Lease 0.00 2,392.55
606-601-3915-Vehicle Lease 707.19 57,337.48
606-601-3920-UB Billing Contract 925.31 12,010.81
606-601-4000-Electricity 0.00 160,002.47
606-601-4001-Gas Service 113.72 1,497.45
606-601-4002-Pagers 0.00 0.00
606-601-4003-Telephone 614.44 8,577.33
606-601-4400-Ft. Worth Access Fees 0.00 0.00
606-601-4401-Water Purchases 584.74 7,000.73
606-601-4402-Sewer Charges 36,373.25 591,508.44
606-601-4403-Groundwater Conservation Distr 0.00 33,897.15
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 5
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
606-WATER/SEWER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
606-601-4404-Stormwater 6.61 148.24
606-601-5000-Office Equip. Maintenance 0.00 0.00
606-601-5001-Building Maintenance 0.00 14,754.15
606-601-5002-Vehicle Maintenance 98.52 6,537.57
606-601-5003-Machinery Maintenance 819.79 6,020.04
606-601-5005-Water System Maintenance 9,445.86 221,424.55
606-601-5006-Licensing & Maintenance Fees 0.00 14,070.04
606-601-5211-Fire Hydrant Maintenance 0.00 0.00
606-601-5999-Reserve-Maintenance 0.00 0.00
606-601-6000-Interest Expense 0.00 0.00
606-601-8000-Debt Interest 95.93 43,661.23
606-601-8010-Debt Issue Costs 0.00 175.00
606-601-8050-Debt Principal 283.13 157,356.41
606-601-8051-USDA Debt Reserve 0.00 0.00
606-601-8800-Capital Outlay 0.00 16,268.75
606-601-8900-Loss on disposal of asset 0.00 0.00
606-601-9106-Transfer to General Fund 0.00 233,333.33
606-601-9500-Depreciation 0.00 0.00
606-601-9501-Amortization Expense 0.00 0.00
606-601-9700-Bad Debt Expense 0.00 445.56
606-601-9701-Conversion Expense 0.00 0.00
606-602-4405-WASTEWATER IMPACT FEES 0.00 3,084.00
606-602-5004-Sewer System Maintenance 240.48 12,512.81
606-602-8000-Amort. of Deferred Gain/Loss 0.00 0.00
606-613-5006-Licensing 0.00 0.00
606-626-3901-MODULAR IMPROVEMENTS 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 134,501.26 805.71 2,905,261.07 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 523,249.01 523,249.01 16,412,580.89 16,412,580.89
============== ============== ============== ==============
*** END OF REPORT ***
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
610-WATER & SEWER CAP. PROJ.
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
610-10000 Claim on Pooled Cash 0.00 32,775.00
610-10154 LOGIC Water & Sewer CAP PROJ 0.00 724,552.07
610-10510 Deferred Issue Costs 0.00 0.00
610-11014 CONSTRUCTION IN PROGRESS 0.00 214,327.62
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 971,654.69 0.00
============== ============== ============== ==============
LIABILITIES
===========
610-20110 Accounts Payable 0.00 0.00
610-20111 Accounts Payable Other 0.00 0.00
610-20905 Bonds-ST 0.00 65,000.00
610-20926 CO's Payable 0.00 2,155,000.00
610-20930 Deferred Debt Issue Premium 0.00 21,875.60
610-20950 Accrued Interest 0.00 15,250.28
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 0.00 2,257,125.88
============== ============== ============== ==============
FUND BALANCE
============
610-30100 Fund Balance 0.00 1,344,333.32
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 1,344,333.32 0.00
============== ============== ============== ==============
REVENUES
========
610-54000 INTEREST REVENUE 0.00 26,087.13
610-57510 Developer Contributions 0.00 0.00
610-58505 Capital Contributions 0.00 0.00
610-58515 Debt Issuance 0.00 0.00
610-59907 Transfer from TIF Fund 0.00 137,300.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 163,387.13
============== ============== ============== ==============
EXPENDITURES
============
610-601-9106-Trf to General Fund 0.00 0.00
610-612-3400-Attorney 0.00 0.00
610-612-3404-Professional Services 0.00 0.00
610-612-3405-Project Boicourt 0.00 0.00
610-612-3406-Sansom Ridge/Point 0.00 0.00
610-612-3600-Legal Publications 0.00 0.00
610-612-8000-Interest Expense 0.00 34,350.00
610-612-8010-Debt Issue Costs 0.00 175.00
610-612-8050-Principal 0.00 70,000.00
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
610-WATER & SEWER CAP. PROJ.
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
610-612-8800-Capital Outlay 0.00 0.00
610-612-8825-Boicourt Project 0.00 0.00
610-612-8826-Sansom Ridge Project 0.00 0.00
610-612-8830-Graham Site 0.00 0.00
610-612-8840-43 Acres Project A 0.00 0.00
610-612-8845-43 Acres Project B 0.00 0.00
610-612-9501-Debt Amortization 0.00 0.00
610-612-9906-Transfer to WS Operating Fd 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 104,525.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 2,420,513.01 2,420,513.01
============== ============== ============== ==============
*** END OF REPORT ***
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
611-USDA Water Project
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
611-10000 Claim on Pooled Cash 0.00 0.00
611-10114 BOT USDA PROJECT 0079 0.00 0.00
611-10115 USDA Debt Payment Reserve 0.00 0.00
611-10229 USDA Grant Receivable 0.00 0.00
611-10801 Due From General Fund 0.00 0.00
611-10806 Due From Water/Sewer 0.00 0.00
611-11014 Construction in Progress 0.00 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 0.00 0.00
============== ============== ============== ==============
LIABILITIES
===========
611-20105 Accounts Payable Accrued 0.00 0.00
611-20110 Accounts Payable 0.00 0.00
611-20111 Accounts Payable Adjusting 0.00 0.00
611-20112 Retention Payable 0.00 0.00
611-20123 Bond Sinking Account 0.00 0.00
611-20124 Waterworks Rev. Bond 2011 A-1 0.00 0.00
611-20125 Waterworks Rev Bond Series A-2 0.00 0.00
611-20801 Due To General Fund 0.00 0.00
611-20806 Due To Water/Sewer 0.00 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
FUND BALANCE
============
611-30100 Fund Balance 0.00 0.00
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 0.00
============== ============== ============== ==============
REVENUES
========
611-54000 INTEREST EARNINGS 0.00 0.00
611-57000 USDA Grant Revenue 0.00 0.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
EXPENDITURES
============
611-601-3400-Attorney 0.00 0.00
611-601-3404-Professional Services 0.00 0.00
611-612-3405-Contract A 0.00 0.00
611-612-3406-Contract B 0.00 0.00
611-612-3407-Contract C 0.00 0.00
611-612-3410-Retention 0.00 0.00
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
611-USDA Water Project
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
611-612-3600-LEGAL PUBLICATIONS 0.00 0.00
611-612-9906-Transfer to WS Operating Fd 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 0.00 0.00
============== ============== ============== ==============
*** END OF REPORT ***
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
750-44 ACRE DEVELOPMENT
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
750-10000 CLAIM ON POOLED CASH 0.00 0.00
750-10225 City Services Receivable 0.00 0.00
750-10801 Due from General Fund 0.00 362,296.81
750-10814 DUE FROM 44 ACRE DEVELOPMENT 0.00 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 362,296.81 0.00
============== ============== ============== ==============
LIABILITIES
===========
750-20110 ACCOUNTS PAYABLE CONTROL 0.00 0.00
750-20814 DUE TO 44 ACRE DEVELOPMENT 0.00 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
FUND BALANCE
============
750-30100 FUND BALANCE 0.00 362,296.81
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 362,296.81
============== ============== ============== ==============
REVENUES
========
750-51000 Business Permits 0.00 0.00
750-51001 Electrical Permits 0.00 0.00
750-51002 Certificate of Occupancy 0.00 0.00
750-51003 Mechanical Permits 0.00 0.00
750-51004 Plumbing Permits 0.00 0.00
750-51005 Building Permits 0.00 0.00
750-51007 Other Permits 0.00 0.00
750-51008 License Registration Fee 0.00 0.00
750-51010 Fire Inspections 0.00 0.00
750-52000 Zoning Fees 0.00 0.00
750-52300 City Services 0.00 0.00
750-53500 Public Improvements Fee 0.00 0.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
EXPENDITURES
============
750-612-3051-Planning & Zoning Expense 0.00 0.00
750-612-3400-Attorney Fees 0.00 0.00
750-612-3401-Inspection Fees 0.00 0.00
750-612-3405-Engineering Services 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
750-44 ACRE DEVELOPMENT
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 362,296.81 362,296.81
============== ============== ============== ==============
*** END OF REPORT ***
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
900-GENERAL FIXED ASSETS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
900-11001 Land 0.00 225,456.30
900-11002 Building & Building Improvemen 0.00 2,399,854.45
900-11003 Machinery & Equipment 0.00 3,386,186.02
900-11004 Vehicles 0.00 0.00
900-11005 Office Equipment 0.00 0.00
900-11006 Streets & Improvements 0.00 1,857,947.00
900-11009 Intangible Assets 0.00 0.00
900-11013 EDC Machinery & Equipment 0.00 0.00
900-11014 Construction in Progress 0.00 561,660.38
900-11016 EDC Impv other than Bldg 0.00 0.00
900-11102 Accum. Depreciation-Buildings 0.00 720,012.15
900-11103 Accum Deprec-Machinery & Equip 0.00 2,667,186.92
900-11104 Accum. Depreciation-Vehicles 0.00 0.00
900-11105 Accum Depreciation-Offic Equip 0.00 0.00
900-11106 Acc Depr - St Impv 0.00 1,689,274.69
900-11109 Accum Amortization-Intangilbes 0.00 0.00
900-11113 EDC Acc Dep Mach & Equip 0.00 0.00
900-11116 EDC Acc Dep IOTB 0.00 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 8,431,104.15 5,076,473.76
============== ============== ============== ==============
FUND BALANCE
============
900-30100 Fund Balance 0.00 293,046.56
900-30900 Investment In Fixed Assets 0.00 3,647,676.95
900-30910 EDC Invstmt in Fixed Assets 0.00 0.00
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 293,046.56 3,647,676.95
============== ============== ============== ==============
EXPENDITURES
============
900-601-8900-Depreciation Expense 0.00 0.00
900-611-8900-Depreciation Expense 0.00 0.00
900-612-8900-Decpreciation Expense 0.00 0.00
900-612-8990-Loss On Disposal Of Asset 0.00 0.00
900-612-9501-Amortization-Intangile Assets 0.00 0.00
900-613-8900-Depreciation Expenses 0.00 0.00
900-614-8900-Depreciation Expense 0.00 0.00
900-616-8900-Muncipal Courts 0.00 0.00
900-618-8900-Depreciation Expense 0.00 0.00
900-623-8900-Depreciation Expense 0.00 0.00
900-625-8900-Depreciation Expense 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 0.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 8,724,150.71 8,724,150.71
============== ============== ============== ==============
*** END OF REPORT ***
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
910-Interest & Sinking
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
910-10000 Claim On Pooled Cash 0.00 449,155.17
910-10201 Delinquent Property Tax Receiv 0.00 21,655.68
910-10209 Property Tax Allowance for Bad 0.00 4,536.64
910-10801 Due From General Fund 0.00 0.00
910-10806 Due From Water-Sewer Fund 0.00 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 470,810.85 4,536.64
============== ============== ============== ==============
LIABILITIES
===========
910-20110 Accounts Payable Control 0.00 0.00
910-20302 Deferred Revenue Property Tax 0.00 17,119.04
910-20801 Due To General Fund 0.00 0.00
910-20805 Due to General Fd 0.00 3,492.69
910-20806 Due To Water Sewer Fund 0.00 0.00
910-20807 Due to TIF Fund 125,842.00 125,842.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 125,842.00 3,492.69 142,961.04
============== ============== ============== ==============
FUND BALANCE
============
910-30100 Fund Balance 0.00 394,587.77
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 394,587.77
============== ============== ============== ==============
REVENUES
========
910-50000 Property Tax 125,842.00 311,075.86
910-50010 Property Tax Delinquent 0.00 12,306.08
910-50020 Property Tax P & I 0.00 5,474.20
910-50100 Propert Tax P&I 0.00 0.00
910-57000 Miscellaneous Revenue 0.00 0.00
______________ ______________ ______________ ______________
TOTAL REVENUES 125,842.00 0.00 0.00 328,856.14
============== ============== ============== ==============
EXPENDITURES
============
910-612-8000-Debt Interest 0.00 132,463.05
910-612-8050-Debt Principal 0.00 264,000.00
910-612-8055-Paying Agent 0.00 175.00
910-612-9700-Bad Debt Expense 0.00 0.00
910-612-9904-Transfer Out 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 396,638.05 0.00
============== ============== ============== ==============
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
910-Interest & Sinking
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 125,842.00 125,842.00 870,941.59 870,941.59
============== ============== ============== ==============
*** END OF REPORT ***
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
999-POOLED CASH
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
999-10000 Pooled Cash In Bank 157,946.26 894,885.71
999-10003 BOT Payroll Cash Account 201,348.56 282,201.04
999-10004 BOT Insurance Trust 0.00 263,819.51
999-10005 BOT EDC Cash Account 0.00 3,438,112.02
999-10006 BOT USDA Debt Service 0.00 0.00
999-10801 DUE FROM GENERAL FUND 52,865.71 49,120.73
999-10802 DUE FROM CRIME CONTROL 208.12 518.11
999-10803 Due From TIF 0.00 0.00
999-10804 Due From City Facilities 0.00 0.00
999-10806 DUE FROM WATER/SEWER 28,315.92 10,448.79
999-10807 Due From USDA Project Fund 0.00 0.00
999-10808 Due From Interest & Sinking 0.00 0.00
999-10809 Due From Insurance Trust 1,486.73 126.48
999-10810 Due from Stormwater Fund 0.00 0.00
999-10811 Due from W&S Capital Projects 0.00 0.00
999-10813 Due From EDC 0.00 0.00
999-10814 DUE FROM 44 ACRES DEVELOPMENT 0.00 0.00
999-10815 Due From Court Security Fund 0.00 0.00
999-10820 Due from Court Technology Fund 399.28 0.00
999-10830 Due from Grant Fund 0.00 0.00
999-10840 Due from CARES Act Fund 0.00 0.00
999-10845 Due from ARPA Fund 0.00 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 157,946.26 284,624.32 4,656,513.24 282,719.15
============== ============== ============== ==============
LIABILITIES
===========
999-20100 ACCOUNTS PAYABLE 82,252.28 66,402.89
999-20200 Payroll Payables 0.00 0.00
999-20201 Federal Tax Payable 0.00 0.00
999-20202 FICA Payable 0.00 0.00
999-20801 Due To GF 213,457.08 1,919,441.97
999-20802 Due to Crime Control 13,454.04 264,710.37
999-20803 Due To TIF 80.00 36,286.14
999-20804 Due to City Facilities 10,762.46 109,562.66
999-20806 Due To W/S 133,138.48 3,331,625.56
999-20807 Due To USDA Project Fund 0.00 178,942.68
999-20808 Due To Interest & Sinking 0.00 258,532.46
999-20809 Due To Insurance Trust 45,641.51 1,539,864.48
999-20810 Due to Stormwater Fund 14,373.62 387,110.38
999-20811 Due to W&S Capital Projects 0.00 160,931.66
999-20813 Due to EDC 179.80 3,359,991.26
999-20814 DUE TO 44 ACRE DEVELOPMENT 0.00 189,894.82
999-20815 Due to Court Security Fund 416.39 76,871.71
999-20820 Due to Court Technology Fund 44.45 13,877.22
999-20830 Due to Grant Fund 0.00 352.84
999-20840 Due to CARES Act Fund 0.00 0.91
999-20845 Due to ARPA Fund 0.00 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 320,230.11 193,570.00 3,760,302.96 8,134,097.05
============== ============== ============== ==============
10-22-2024 05:15 PM CITY OF SANSOM PARK PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2024
999-POOLED CASH
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
FUND BALANCE
============
999-30100 Fund Balance 0.00 0.00
999-39999 Adjusting Account 0.00 0.00
______________ ______________ ______________ ______________
TOTAL BEGINNING FUND BALANCE 0.00 0.00 0.00 0.00
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 478,176.37 478,194.32 8,416,816.20 8,416,816.20
============== ============== ============== ==============
*** AMOUNT OUT OF BALANCE *** 17.95CR 0.00
*** END OF REPORT ***