Import 78bd6295-92dd-4b06-a075-40dcccfaad3f
Download
11-12-2023 10:43 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
10 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
10-1-0000-0101 CLAIM ON CASH 43,802.07 1,215,476.99
10-1-0000-0103 PINNBANK-GF OPERATING (1609) 174,667.20 2,425,551.02
10-1-0000-0123 PINNBANK CASH-MERP (4810) 565.13 17,756.36
10-1-0000-0133 TEXAS TERM DAILY INVESTMENTS 0.00 12,331.98
10-1-0000-0134 TEXPOOL-GENERAL FUND 5,991.45 3,027,384.97
10-1-0000-0139 CASH DRAWER #1 0.00 200.00
10-1-0000-0140 CASH DRAWER #2 0.00 200.00
10-1-0000-0141 CASH DRAWER #3 0.00 200.00
10-1-0000-0142 PETTY CASH 0.00 100.00
10-1-0000-0193 FINES & FEES RECEIVABLE 0.00 1,024,987.00
10-1-0000-0194 ALLOWANCE FOR UNCOLLECTIBLES 0.00 922,488.00
10-1-0000-0195 SALES TAX RECEIVABLE 12,597.22 149,197.17
10-1-0000-0196 FRANCHISE TAX RECEIVABLE 0.00 14,169.77
10-1-0000-0198 AR-DELINQUENT TAXES 0.00 25,765.65
10-1-0000-0199 ALLOW FOR UNCOLLECT ACCTS 0.00 11,296.88
10-1-0000-0202 INTEREST RECEIVABLE 0.00 2,253.99
10-1-0000-0301 DUE TO PID FEES FUND 0.00 1,632,500.00
10-1-0000-0302 DEVELOPER RECEIVABLES 51,001.82 51,001.82
10-1-0000-1450 PREPAID EXPENSES 4,774.05 12,843.74
______________ ______________ ______________ ______________
TOTAL ASSETS 118,166.61 175,232.33 6,763,943.47 3,781,761.87
============== ============== ============== ==============
LIABILITIES
===========
10-2-0000-0201 A/P PENDING 5,163.81 175,311.07
10-2-0000-0202 ACCOUNTS PAYABLE - AUDITOR 279,418.12 279,418.12
10-2-0000-0205 CLEARING 0.00 159.06
10-2-0000-0206 ACCRUED PAYROLL LIABILITIES 10,947.35 15,602.29
10-2-0000-0210 FICA/MC TAX WITHHOLDING 5,493.88 0.00
10-2-0000-0212 FED W/H PAYABLE 5,559.70 0.00
10-2-0000-0213 HEALTH INSURANCE PAYABLE 198.03 274.43
10-2-0000-0217 CHILD SUPPORT PAYABLE 1,148.45 97.24
10-2-0000-0222 BOND ESCROW 0.00 1,250.00
10-2-0000-0223 BONDS PAYABLE 0.00 250.00
10-2-0000-0225 JURY FUND LIABILITY 4.80 115.40
10-2-0000-0227 TXSBLT PAYABLE 208.00 0.00
10-2-0000-0228 STATE FEES PAYABLE 8,140.89 0.00
10-2-0000-0230 HRA FUNDING ACCOUNT 565.13 17,756.36
10-2-0000-0246 UNUM PAYABLE 12.52 108.82
10-2-0000-0248 NNNS VOL POLICE PROGRAM 64.20 874.20
10-2-0000-0251 COLONIAL PAYABLE 0.20 153.86
10-2-0000-0252 DEARBORN LIFE PAYABLE 8.21 15.43
10-2-0000-0255 DEFERRED REV-FINES & FEES 0.00 102,499.00
10-2-0000-0260 DEFERRED REVENUE-PROPERTY TAX 0.00 16,472.04
10-2-0000-0271 ESCHEATED CHECKS 0.00 163.55
10-2-0000-0275 REF COMM CTR DEPOSIT 0.00 900.00
10-2-0000-0276 SPECIAL EVENT DEPOSIT (COC) 0.00 500.00
10-2-0000-0301 PSA - CHARLEY'S 82.50 82.50
10-2-0000-0302 PSA - HERITAGE TRAILS 111.42 0.00
11-12-2023 10:43 AM CITY OF VENUS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
10 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
10-2-0000-0303 PSA - HERITAGE HILLS PH II 11,840.30 9,459.20
10-2-0000-0304 PSA - ALLIED DEVELOPMENT 0.00 15,000.00
10-2-0000-0305 PSA - STALLION RANCH (LGI) 3,059.55 0.00
10-2-0000-0306 PSA - STARLIGHT MEADOWS (BLOOM 7,251.25 0.00
10-2-0000-0307 PSA - NGUYEN 272.25 272.25
10-2-0000-0308 PSA - HORIZONS AT BANKSTON 3,301.95 0.00
10-2-0000-0309 PSA - SCHIFANO TRACT 277.50 277.50
10-2-0000-0311 PSA - HAWK RIDGE (BUFFALO HILL 9,140.40 9,140.40
10-2-0000-0312 PSA - PATRIOT ESTATES PH 8 & 9 16,304.88 16,304.88
10-2-0000-0313 PSA - JMJ DEVELOPMENTS 27,184.46 27,184.46
10-2-0000-0314 PSA - BRAHMAN RANCH I 5,416.77 5,416.77
______________ ______________ ______________ ______________
TOTAL LIABILITIES 21,967.06 379,209.46 1,189.99 693,868.84
============== ============== ============== ==============
FUND BALANCE
============
10-3-0000-0301 CURRENT FUND BALANCE 617.04 2,332,306.00
10-3-0000-0305 FUND BALANCE-RESTRICTED 7,171.00 0.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 7,171.00 617.04 0.00 2,332,306.00
============== ============== ============== ==============
REVENUES
========
10-4-0000-0321 ACCIDENT REPORT 10.00 425.00
10-4-0000-0322 COMMUNITY CENTER RENTAL 75.00 6,270.00
10-4-0000-0323 PARK RENTALS 25.00 7,105.00
10-4-0000-0324 COPY MACHINE 8.69 114.07
10-4-0000-0327 SPECIAL EVENT APPLICATION FEE 65.00 1,120.00
10-4-0000-0329 RESTITUTIONS 32.15 1,522.40
10-4-0000-0331 ADMINISTRATIVE/OTHER FEES 618.00 34,893.09
10-4-0000-0333 MUNICIPAL COURT BLDG FUND 0.00 50.00
10-4-0000-0334 FINES 6,335.07 59,812.75
10-4-0000-0335 TIME PAYMENT 106.00 773.00
10-4-0000-0337 ALARM FINES 50.00 850.00
10-4-0000-0340 FRANCHISE TAX 0.00 128,593.46
10-4-0000-0342 PENALTY & INTEREST 1,435.57 12,901.76
10-4-0000-0343 DELINQUENT PROPERTY TAXES 335.24 13,871.69
10-4-0000-0344 CURRENT PROPERTY TAX 5,746.17 2,017,192.37
10-4-0000-0346 SALES TAX 62,049.67 664,221.19
10-4-0000-0347 SALES TAX (PT RELIEF) 12,363.12 162,906.03
10-4-0000-0351 PAYMENT IN LIEU OF TAXES 0.00 122,696.00
10-4-0000-0355 VCSDC CONTRIBUTIONS 7,804.96 158,943.61
10-4-0000-0360 INTEREST 6,324.25 30,628.27
10-4-0000-0361 ALCOHOL PERMITS 0.00 437.50
10-4-0000-0363 ZONING FEES 0.00 3,000.00
10-4-0000-0364 ANIMAL REGISTRATION 60.00 180.00
10-4-0000-0365 DEVELOPMENT FEES 0.00 15,572.00
10-4-0000-0366 LICENSE & PERMITS 42,142.36 485,081.93
10-4-0000-0368 PARK FEES 0.00 575.00
10-4-0000-0369 RESIDENTIAL RENTAL PROPERTY 400.00 3,325.00
11-12-2023 10:43 AM CITY OF VENUS PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
10 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
10-4-0000-0372 INSURANCE PROCEEDS 0.00 2,004.48
10-4-0000-0373 MISCELLANEOUS 603.45 3,412.20
10-4-0000-0375 TML WC INS PROCEEDS 0.00 6,504.27
10-4-0000-0376 CASH OVER (SHORT) 0.00 254.16
10-4-0000-0377 DONATIONS 0.00 30,000.00
10-4-0000-0381 GRANT REVENUE 0.00 1,025.27
10-4-0000-0382 JOHNSON CO ESD CONTRACT 14,792.17 100,119.79
10-4-0000-0383 JOHNSON CO EMP INCENTIVES 2,013.33 7,986.97
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 163,395.20 0.00 4,084,368.26
============== ============== ============== ==============
EXPENDITURES
============
10-5-0000-0506 CAPITAL LEASE - PRINCIPAL 0.00 77,784.75
10-5-0000-0507 CAPITAL LEASE-INTEREST 0.00 6,546.07
10-5-0000-0510 LEASE PAYMENT - FIRE 252,860.74 266,404.24
10-5-0000-0674 HR OFFICE RENOVATION 0.00 4,194.00
10-5-0000-0675 FUEL STATION & SOFTWARE 0.00 10,368.30
10-5-0000-0676 WEATHER SIREN UPGRADES 26,327.98 26,327.98
10-5-0000-0677 DRAINAGE TRACTOR 0.00 32,898.00
10-5-0000-0678 MOWER 0.00 9,618.25
10-5-0000-0679 CITY HALL SEPTIC SYSTEM 0.00 8,562.33
10-5-0000-0680 CAPITAL EXPENDITURES - FIRE 10,935.00 10,935.00
10-5-0000-0681 EXTRACTOR & DRYING CABINET 0.00 18,105.00
10-5-0000-0682 LAND PURCHASE 0.00 80,762.53
10-5-0000-0751 TRANSFER TO (FROM) OTHER FUNDS 4,558.31 21,884.59
10-5-0010-0400 SALARIES & WAGES 4,632.53 55,426.64
10-5-0010-0401 SOCIAL SECURITY TAXES 391.56 3,388.66
10-5-0010-0402 STATE UNEMPLOYMENT TAXES 0.00 9.00
10-5-0010-0403 MEDICARE TAXES 91.58 792.52
10-5-0010-0404 RETIREMENT (TMRS) 455.44 5,908.61
10-5-0010-0406 WORKERS COMPENSATION 0.00 144.00
10-5-0010-0410 HEALTH INSURANCE 418.54 5,022.52
10-5-0010-0412 HRA 0.00 250.00
10-5-0010-0416 TRAVEL & TRAINING 0.00 1,137.27
10-5-0010-0420 UNIFORMS 0.00 52.97
10-5-0010-0421 OFFICE SUPPLIES 0.00 931.69
10-5-0010-0423 POSTAGE 15.81 56.23
10-5-0010-0426 GAS & OIL 28.21 389.80
10-5-0010-0430 CELL PHONES & MIFI 70.86 699.39
10-5-0010-0433 SMALL EQUIPMENT<$5,000 0.00 1,368.88
10-5-0010-0445 VEHICLE R&M 0.00 347.81
10-5-0010-0462 LEGAL SERVICES 5,200.00 62,400.00
10-5-0010-0468 INFORMATION TECHNOLOGY 0.00 995.00
10-5-0010-0485 MAYOR'S PROJECTS 0.00 4,589.48
10-5-0010-0495 CITY ADMIN SPECIAL PROJECTS 0.00 8,621.93
10-5-0010-0562 VEHICLE MAINT PLAN 6.00 42.21
10-5-0015-0400 SALARIES & WAGES 5,844.64 70,363.28
10-5-0015-0401 SOCIAL SECURITY TAXES 498.86 4,330.73
10-5-0015-0402 STATE UNEMPLOYMENT TAXES 0.00 9.00
10-5-0015-0403 MEDICARE TAXES 116.66 1,012.76
11-12-2023 10:43 AM CITY OF VENUS PAGE: 4
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
10 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
10-5-0015-0404 RETIREMENT (TMRS) 578.10 7,499.07
10-5-0015-0406 WORKERS COMPENSATION 0.00 156.00
10-5-0015-0410 HEALTH INSURANCE 785.43 9,421.44
10-5-0015-0412 HRA 0.00 500.00
10-5-0015-0416 EMPLOYEE TRAINING 642.46 1,549.09
10-5-0015-0417 CITY COUNCIL TRAINING 1,033.64 2,667.43
10-5-0015-0418 DUES & MEMBERSHIPS 0.00 150.00
10-5-0015-0421 OFFICE SUPPLIES 0.00 101.35
10-5-0015-0423 POSTAGE 30.77 97.76
10-5-0015-0429 DEPARTMENT SUPPLIES 0.00 12.78
10-5-0015-0430 CELL PHONES & MIFI 92.11 1,129.46
10-5-0015-0433 SMALL EQUIPMENT<$5,000 0.00 3,008.60
10-5-0015-0468 INFORMATION TECHNOLOGY 4,774.05 4,635.00
10-5-0015-0490 ELECTION EXPENSES 0.00 6,262.83
10-5-0015-0491 LEGAL NOTICES 1,077.50 4,500.86
10-5-0015-0492 RECORDING/FILING FEES 31.50 611.19
10-5-0015-0493 COUNCIL MISCELLANEOUS 223.80 350.85
10-5-0015-0494 CODIFICATION 0.00 3,655.00
10-5-0020-0400 SALARIES & WAGES 15,399.97 167,004.18
10-5-0020-0401 SOCIAL SECURITY TAXES 1,310.24 9,853.89
10-5-0020-0402 STATE UNEMPLOYMENT TAXES 0.00 296.14
10-5-0020-0403 MEDICARE TAXES 306.42 2,304.50
10-5-0020-0404 RETIREMENT (TMRS) 1,585.64 17,853.62
10-5-0020-0405 OVERTIME 14.35 638.48
10-5-0020-0406 WORKERS COMP 0.00 460.00
10-5-0020-0410 HEALTH INSURANCE 3,390.68 30,985.50
10-5-0020-0412 HRA 0.00 1,500.00
10-5-0020-0416 EMPLOYEE TRAINING 608.00 4,115.27
10-5-0020-0418 DUES & MEMBERSHIPS 0.00 138.05
10-5-0020-0421 OFFICE SUPPLIES 270.86 3,425.15
10-5-0020-0423 POSTAGE 858.80 1,812.83
10-5-0020-0426 GAS & OIL 227.17 773.27
10-5-0020-0429 DEPARTMENT SUPPLIES 204.31 508.08
10-5-0020-0430 CELL PHONES & MIFI 117.19 1,284.89
10-5-0020-0433 SMALL EQUIPMENT<$5,000 0.00 1,795.72
10-5-0020-0460 OTHER CONTRACTED SERVICES 170.82 35,479.93
10-5-0020-0462 LEGAL SERVICES 500.00 6,552.32
10-5-0020-0464 ENGINEERING SERVICES 39,053.09 9,606.10
10-5-0020-0465 NON-CIVIL INSPECTIONS 5,069.10 24,159.67
10-5-0020-0467 HEALTH INSPECTIONS 0.00 5,825.00
10-5-0020-0468 INFORMATION TECHNOLOGY 19.98 10,731.70
10-5-0020-0488 MERCHANT SERVICE FEES 333.98 1,887.27
10-5-0020-0491 LEGAL NOTICES 186.90 626.65
10-5-0020-0492 RECORDING/FILING FEES 0.00 48.30
10-5-0020-0495 SPECIAL PROJECTS 0.00 47,095.16
10-5-0020-0560 VEHICLE LEASE PAYMENTS 697.57 4,738.19
10-5-0020-0562 VEHICLE MAINT PLAN 29.67 577.49
10-5-0025-0400 SALARIES & WAGES 6,376.67 68,522.39
10-5-0025-0401 SOCIAL SECURITY TAXES 602.35 3,649.62
10-5-0025-0402 STATE UNEMPLOYMENT TAXES 9.00 18.00
11-12-2023 10:43 AM CITY OF VENUS PAGE: 5
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
10 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
10-5-0025-0403 MEDICARE TAXES 140.88 1,094.28
10-5-0025-0404 RETIREMENT (TMRS) 673.92 6,819.79
10-5-0025-0405 OVERTIME 302.94 1,303.13
10-5-0025-0406 WORKERS COMPENSATION 0.00 154.01
10-5-0025-0410 HEALTH INSURANCE 946.99 7,805.74
10-5-0025-0412 HRA 0.00 375.00
10-5-0025-0416 EMPLOYEE TRAINING 0.00 1,642.50
10-5-0025-0418 DUES & MEMBERSHIPS 544.40 1,164.40
10-5-0025-0421 OFFICE SUPPLIES 58.26 210.18
10-5-0025-0423 POSTAGE 146.98 804.31
10-5-0025-0429 DEPARTMENT SUPPLIES 430.40 1,077.27
10-5-0025-0459 AUDIT SERVICES 6,625.00 8,125.00
10-5-0025-0463 APPRAISAL/COLLECTION FEES 6,018.07 31,694.50
10-5-0025-0468 INFORMATION TECHNOLOGY 0.00 3,816.09
10-5-0025-0499 LATE FEES 1,044.02 2,494.23
10-5-0030-0400 SALARIES & WAGES 5,075.90 50,994.66
10-5-0030-0401 SOCIAL SECURITY TAXES 487.43 3,471.32
10-5-0030-0402 STATE UNEMPLOYMENT TAXES 0.00 9.00
10-5-0030-0403 MEDICARE TAXES 113.99 811.83
10-5-0030-0404 RETIREMENT (TMRS) 530.10 6,002.39
10-5-0030-0405 OVERTIME 302.94 5,379.41
10-5-0030-0406 WORKERS COMPENSATION 0.00 112.00
10-5-0030-0410 HEALTH INSURANCE 73.65 808.35
10-5-0030-0412 HRA 0.00 500.00
10-5-0030-0416 EMPLOYEE TRAINING 0.00 505.00
10-5-0030-0418 DUES & MEMBERSHIPS 85.00 414.00
10-5-0030-0421 OFFICE SUPPLIES 161.09 984.92
10-5-0030-0423 POSTAGE 0.00 10.54
10-5-0030-0429 DEPARTMENT SUPPLIES 0.00 216.40
10-5-0030-0430 CELL PHONES & MIFI 43.43 333.69
10-5-0030-0433 SMALL EQUIPMENT<$5,000 169.17 3,311.07
10-5-0030-0460 OTHER CONTRACTED SERVICES 185.40 2,726.90
10-5-0030-0468 INFORMATION TECHNOLOGY 46.00 635.20
10-5-0030-0475 EMPLOYEE RELATIONS 47.50 6,339.54
10-5-0030-0476 NEW HIRE SCREENING 557.00 7,805.00
10-5-0030-0495 SPECIAL PROJECTS 0.00 14,250.00
10-5-0035-0400 SALARIES & WAGES 2,048.66 34,786.86
10-5-0035-0401 SOCIAL SECURITY TAXES 151.13 2,152.73
10-5-0035-0402 STATE UNEMPLOYMENT TAXES 0.00 185.40
10-5-0035-0403 MEDICARE TAXES 35.35 503.48
10-5-0035-0404 RETIREMENT (TMRS) 201.77 3,643.19
10-5-0035-0410 HEALTH INSURANCE 0.00 220.05
10-5-0035-0412 HRA 0.00 500.00
10-5-0045-0400 SALARIES & WAGES 434.54 434.54
10-5-0050-0400 SALARIES & WAGES 66,914.83 816,861.33
10-5-0050-0401 SOCIAL SECURITY TAXES 5,749.06 49,922.90
10-5-0050-0402 STATE UNEMPLOYMENT TAXES 0.00 234.42
10-5-0050-0403 MEDICARE TAXES 1,344.54 11,675.64
10-5-0050-0404 RETIREMENT (TMRS) 6,744.30 88,485.95
10-5-0050-0405 OVERTIME 669.47 13,832.32
11-12-2023 10:43 AM CITY OF VENUS PAGE: 6
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
10 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
10-5-0050-0406 WORKERS COMPENSATION 0.00 19,204.00
10-5-0050-0410 HEALTH INSURANCE 12,152.45 148,641.13
10-5-0050-0412 HRA 0.00 7,000.00
10-5-0050-0415 POLICE TRAINING 2,508.34 8,794.45
10-5-0050-0416 POLICE LEOSE TRAINING 0.00 650.00
10-5-0050-0418 DUES & MEMBERSHIPS 0.00 829.11
10-5-0050-0420 UNIFORMS 2,247.05 13,589.30
10-5-0050-0421 OFFICE SUPPLIES 1,040.02 3,030.71
10-5-0050-0423 POSTAGE 0.00 130.42
10-5-0050-0425 COPIERS 211.56 1,239.16
10-5-0050-0426 GAS & OIL 7,454.26 44,890.77
10-5-0050-0429 DEPARTMENT SUPPLIES 3,755.61 13,608.53
10-5-0050-0430 CELL PHONES/MIFI 613.86 7,267.96
10-5-0050-0431 TELEPHONES 77.21 702.34
10-5-0050-0433 SMALL EQUIPMENT<$5,000 6,129.32 6,129.32
10-5-0050-0442 BUILDING R&M 69.57 403.57
10-5-0050-0445 VEHICLE R&M 558.21 15,470.09
10-5-0050-0446 EQUIPMENT R&M 0.00 370.00
10-5-0050-0460 CONTRACTED SERVICES 3,526.56 23,622.97
10-5-0050-0465 DISPATCH SERVICES 0.00 65,608.66
10-5-0050-0468 INFORMATION TECHNOLOGY 0.00 23,243.22
10-5-0050-0469 LIABILITY & PROPERTY 0.00 14,389.00
10-5-0050-0562 VEHICLE MAINT PLAN 78.00 548.73
10-5-0055-0400 SALARIES & WAGES 3,792.96 46,184.59
10-5-0055-0401 SOCIAL SECURITY TAXES 308.70 2,601.20
10-5-0055-0402 STATE UNEMPLOYMENT TAXES 0.00 9.00
10-5-0055-0403 MEDICARE TAXES 72.19 608.33
10-5-0055-0404 RETIREMENT (TMRS) 381.42 4,923.15
10-5-0055-0405 OVERTIME 0.00 8.11
10-5-0055-0406 WORKERS COMPENSATION 0.00 1,565.00
10-5-0055-0410 HEALTH INSURANCE 1,129.65 13,553.43
10-5-0055-0412 HRA 0.00 500.00
10-5-0055-0416 EMPLOYEE TRAINING 0.00 100.00
10-5-0055-0418 DUES & MEMBERSHIPS 111.00 161.00
10-5-0055-0420 UNIFORMS 3.97 3.97
10-5-0055-0421 OFFICE SUPPLIES 0.00 39.32
10-5-0055-0423 POSTAGE 530.15 1,257.85
10-5-0055-0426 GAS & OIL 354.48 1,184.34
10-5-0055-0429 DEPARTMENT SUPPLIES 117.88 1,159.30
10-5-0055-0430 CELL PHONES & MIFI 49.84 580.69
10-5-0055-0445 VEHICLE R&M 496.64 2,241.07
10-5-0055-0460 CONTRACTED SERVICES 420.00 1,960.00
10-5-0055-0468 INFORMATION TECHNOLOGY 0.00 3,394.10
10-5-0055-0469 LIABILITY & PROPERTY 0.00 465.00
10-5-0055-0562 VEHICLE MAINT PLAN 6.00 36.19
10-5-0060-0400 COURT SALARIES 4,219.20 49,181.89
10-5-0060-0401 COURT SOCIAL SECURITY 394.37 2,959.42
10-5-0060-0402 COURT UNEMPLOYMENT TAXES 0.00 9.00
10-5-0060-0403 COURT MEDICARE 92.24 692.12
10-5-0060-0404 COURT TMRS 463.50 5,323.45
11-12-2023 10:43 AM CITY OF VENUS PAGE: 7
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
10 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
10-5-0060-0405 COURT OVERTIME 394.90 1,030.64
10-5-0060-0406 COURT WORKERS COMPENSATION 0.00 126.00
10-5-0060-0410 COURT INSURANCE 772.97 10,977.28
10-5-0060-0412 COURT HRA 0.00 500.00
10-5-0060-0416 COURT TRAINING 0.00 478.27
10-5-0060-0418 COURT DUES & MEMBERSHIPS 0.00 110.00
10-5-0060-0421 COURT OFFICE SUPPLIES 0.00 457.53
10-5-0060-0423 COURT POSTAGE 52.53 392.95
10-5-0060-0430 CELL PHONES & MIFI 31.25 388.20
10-5-0060-0433 SMALL EQUIPMENT<$5,000 0.00 999.98
10-5-0060-0461 OTHER CONTRACTED SERVICES 800.00 13,200.00
10-5-0060-0468 INFORMATION TECHNOLOGY 148.00 6,630.51
10-5-0060-0488 MERCHANT SERVICE FEES 394.90 2,664.38
10-5-0070-0400 SALARIES & WAGES 19,368.59 141,343.27
10-5-0070-0401 SOCIAL SECURITY TAXES 1,666.40 8,704.19
10-5-0070-0402 STATE UNEMPLOYMENT TAXES 36.29 79.89
10-5-0070-0403 MEDICARE TAXES 389.71 2,035.60
10-5-0070-0404 RETIREMENT (TMRS) 761.82 7,275.30
10-5-0070-0406 WORKERS COMPENSATION 0.00 8,341.00
10-5-0070-0410 HEALTH INSURANCE 57.08 399.56
10-5-0070-0412 HRA 0.00 500.00
10-5-0070-0416 EMPLOYEE TRAINING 444.25 6,465.97
10-5-0070-0418 DUES & MEMBERSHIPS 265.00 4,255.50
10-5-0070-0420 UNIFORMS 14,209.88 61,314.99
10-5-0070-0421 OFFICE SUPPLIES 34.63 1,039.51
10-5-0070-0423 POSTAGE 1,375.13 1,420.96
10-5-0070-0426 GAS & OIL 2,403.65 9,993.11
10-5-0070-0429 DEPARTMENT SUPPLIES 0.00 4,294.27
10-5-0070-0430 CELL PHONES & MIFI 259.47 1,702.37
10-5-0070-0432 UTILITIES 464.38 4,455.61
10-5-0070-0433 SMALL EQUIPMENT<$5,000 1,418.00 20,772.43
10-5-0070-0442 BUILDING MAINTENANCE 65.00 12,487.47
10-5-0070-0445 VEHICLE R&M 8,042.81 44,778.77
10-5-0070-0446 EQUIPMENT R&M 0.00 9,644.35
10-5-0070-0468 INFORMATION TECHNOLOGY 280.33 995.52
10-5-0070-0469 LIABILITY & PROPERTY 0.00 4,654.00
10-5-0070-0475 COMMUNITY OUTREACH 0.00 1,368.67
10-5-0070-0495 SPECIAL PROJECTS 24.20 100.23
10-5-0070-0560 VEHICLE LEASE PAYMENTS 975.73 3,284.96
10-5-0070-0561 VEHICLE MAKE READY 0.00 8,386.39
10-5-0070-0562 VEHICLE MAINT PLAN 49.77 221.94
10-5-0070-0661 LIFEPAK DEFIB/MONITOR 0.00 28,080.35
10-5-0080-0400 SALARIES & WAGES 6,464.04 92,460.34
10-5-0080-0401 SOCIAL SECURITY 634.29 5,867.35
10-5-0080-0402 STATE UNEMPLOYMENT TAX 5.37 25.03
10-5-0080-0403 MEDICARE TAXES 148.34 1,374.18
10-5-0080-0404 RETIREMENT (TMRS) 722.59 10,267.16
10-5-0080-0405 OVERTIME 633.60 4,125.00
10-5-0080-0406 WORKERS COMPENSATION 0.00 4,991.00
10-5-0080-0410 HEALTH INSURANCE 1,870.92 21,151.31
11-12-2023 10:43 AM CITY OF VENUS PAGE: 8
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
10 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
10-5-0080-0412 HRA 0.00 1,250.00
10-5-0080-0416 TRAINING 965.00 2,461.39
10-5-0080-0420 UNIFORMS 69.11 2,254.17
10-5-0080-0421 OFFICE SUPPLIES 35.99 364.75
10-5-0080-0426 GAS & OIL 1,699.80 7,612.90
10-5-0080-0429 DEPARTMENT SUPPLIES 1,032.49 5,358.46
10-5-0080-0430 CELL PHONES & MIFI 161.62 1,622.75
10-5-0080-0432 UTILITIES 3,237.07 39,447.87
10-5-0080-0433 SMALL EQUIPMENT<$5,000 332.11 3,693.73
10-5-0080-0434 RENTAL EQUIPMENT 0.00 572.18
10-5-0080-0442 BUILDING R&M 10.00 1,570.85
10-5-0080-0445 VEHICLE R&M 0.00 1,238.17
10-5-0080-0446 EQUIPMENT R&M 1,904.90 3,508.85
10-5-0080-0464 ENGINEERING 185.00 5,764.91
10-5-0080-0469 LIABILITY & PROPERTY INS 0.00 2,066.18
10-5-0080-0470 STREET SIGNS 0.00 5,862.07
10-5-0080-0472 DRAINAGE MATERIAL 0.00 6,325.86
10-5-0080-0495 SPECIAL PROJECTS 0.00 26,000.00
10-5-0080-0562 VEHICLE MAINT PLAN 7.50 52.77
10-5-0090-0400 SALARIES & WAGES 7,805.95 111,511.31
10-5-0090-0401 SOCIAL SECURITY TAXES 687.67 7,037.83
10-5-0090-0402 STATE UNEMPLOYMENT TAXES 0.00 18.00
10-5-0090-0403 MEDICARE TAXES 160.83 1,646.04
10-5-0090-0404 RETIREMENT (TMRS) 786.97 12,228.10
10-5-0090-0405 OVERTIME 195.85 3,672.40
10-5-0090-0406 WORKERS COMPENSATION 0.00 2,582.00
10-5-0090-0410 HEALTH INSURANCE 1,778.18 24,266.40
10-5-0090-0412 HRA 0.00 1,250.00
10-5-0090-0416 EMPLOYEE TRAINING 470.00 1,302.35
10-5-0090-0420 UNIFORMS 69.11 1,653.67
10-5-0090-0421 OFFICE SUPPLIES 149.68 198.83
10-5-0090-0426 GAS & OIL 981.71 5,803.97
10-5-0090-0429 DEPARTMENT SUPPLIES 681.67 3,675.79
10-5-0090-0430 CELL PHONES & MIFI 129.79 1,440.85
10-5-0090-0432 UTILITIES 189.58 3,357.41
10-5-0090-0433 SMALL EQUIPMENT<$5,000 332.10 2,690.45
10-5-0090-0442 BUILDING R&M 0.00 1,984.63
10-5-0090-0445 VEHICLE R&M 107.93 570.67
10-5-0090-0446 EQUIPMENT R&M 0.00 1,627.03
10-5-0090-0448 PARK MAINTENANCE 0.00 9,284.50
10-5-0090-0464 ENGINEERING SERVICES 0.00 1,295.00
10-5-0090-0469 GEN LIAB & PROPERTY INSURAN 0.00 1,650.00
10-5-0090-0488 MERCHANT SERVICE FEES 75.00 312.88
10-5-0090-0495 SPECIAL PROJECTS 0.00 350.00
10-5-0090-0562 VEHICLE MAINT PLAN 7.50 52.76
10-5-0095-0400 SALARIES & WAGES 2,160.00 8,160.00
10-5-0095-0401 SOCIAL SECURITY 209.61 510.94
10-5-0095-0402 STATE UNEMPLOYMENT TAX 8.24 8.24
10-5-0095-0403 MEDICARE TAXES 49.02 119.49
10-5-0095-0404 RETIREMENT (TMRS) 233.14 880.99
11-12-2023 10:43 AM CITY OF VENUS PAGE: 9
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
10 -GENERAL FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
10-5-0095-0405 OVERTIME 5.63 50.63
10-5-0095-0410 HEALTH INSURANCE 823.30 1,524.24
10-5-0095-0416 EMPLOYEE TRAINING 0.00 1,940.83
10-5-0095-0418 DUES & MEMBERSHIPS 0.00 3,385.88
10-5-0095-0420 UNIFORMS 45.92 387.55
10-5-0095-0421 OFFICE SUPPLIES 86.76 2,468.92
10-5-0095-0423 POSTAGE 1,427.11 1,447.28
10-5-0095-0425 COPIERS 290.31 3,216.56
10-5-0095-0426 GAS & OIL 166.72 236.06
10-5-0095-0429 DEPARTMENT SUPPLIES 877.69 7,177.27
10-5-0095-0430 CELL PHONES & MIFI 62.50 890.53
10-5-0095-0431 TELEPHONE SYSTEM 1,656.10 7,402.72
10-5-0095-0432 UTILITIES 2,049.66 20,175.34
10-5-0095-0442 BUILDING R&M 305.51 30,023.50
10-5-0095-0445 VEHICLE R&M 7.00 12.00
10-5-0095-0460 OTHER CONTRACTED SERVICES 0.00 482.70
10-5-0095-0468 INFORMATION TECHNOLOGY 753.99 57,112.18
10-5-0095-0469 GEN LIAB & PROPERTY INSURAN 0.00 13,490.73
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 616,909.33 45,759.97 4,127,171.51 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 764,214.00 764,214.00 10,892,304.97 10,892,304.97
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:44 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
11 -CPF-2020 BOND PROCEEDS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
11-1-0000-0101 CLAIM ON CASH 3,097.35 22,352.92
11-1-0000-0105 TEXPOOL-2020 BOND PROCEEDS 7,871.38 3,977,308.96
______________ ______________ ______________ ______________
TOTAL ASSETS 7,871.38 3,097.35 3,977,308.96 22,352.92
============== ============== ============== ==============
LIABILITIES
===========
11-2-0000-0201 A/P PENDING 4,216.40 7,313.75
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 4,216.40 0.00 7,313.75
============== ============== ============== ==============
FUND BALANCE
============
11-3-0000-0305 FUND BALANCE-RESTRICTED 0.00 4,057,233.39
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 4,057,233.39
============== ============== ============== ==============
REVENUES
========
11-4-0000-0360 INTEREST EARNINGS 7,871.38 27,818.36
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 7,871.38 0.00 27,818.36
============== ============== ============== ==============
EXPENDITURES
============
11-5-0000-0667 CAP OUT-ENGINEERING 7,313.75 137,409.46
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 7,313.75 0.00 137,409.46 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 15,185.13 15,185.13 4,114,718.42 4,114,718.42
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:44 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
12 -CPF-LGI/PE SEWER FORCE MA
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
12-1-0000-0164 WATER/SEWER INFRASTRUCTURE 0.00 1,411,906.13
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 1,411,906.13 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
12-3-0000-0305 FUND BALANCE-RESTRICTED 0.00 1,384,853.66
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 1,384,853.66
============== ============== ============== ==============
REVENUES
========
12-4-0000-0360 INTEREST EARNINGS 0.00 91.64
12-4-0000-0450 CAPITAL CONTRIBUTION-HERITAGE 0.00 31,746.05
12-4-0000-0451 CAPITAL CONTRIBUTION-LGI 0.00 61,353.43
12-4-0000-0452 CONTRIBUTIONS 0.00 120,060.31
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 93,099.48 120,151.95
============== ============== ============== ==============
EXPENDITURES
============
12-5-0000-0663 CONSTRUCTION 0.00 29,651.22
12-5-0000-0664 OTHER COSTS 0.00 29,651.22
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 29,651.22 29,651.22
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 1,534,656.83 1,534,656.83
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:44 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
13 -VVFD FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
13-1-0000-0101 CLAIM ON CASH 0.00 4,793.46
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 4,793.46 0.00
============== ============== ============== ==============
LIABILITIES
===========
13-2-0000-0203 A/P PENDING 33,487.79 33,487.79
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 33,487.79 0.00 33,487.79
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
13-4-0000-0356 VVFD CONTRIBUTIONS 0.00 50,157.91
13-4-0000-0359 VVFD DONATIONS 0.00 50,000.00
13-4-0000-0380 VVFD GRANT REVENUE 0.00 25,735.00
13-4-0000-0381 JOHNSON CO ESD CONTRACT 0.00 24,648.26
13-4-0000-0382 JOHNSON CO ESD INCENTIVES 0.00 2,434.17
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 152,975.34
============== ============== ============== ==============
EXPENDITURES
============
13-5-0000-0426 GAS & OIL 0.00 1,016.89
13-5-0000-0429 DEPARTMENT SUPPLIES 0.00 135.93
13-5-0000-0430 CELL PHONES & MIFI 0.00 220.44
13-5-0000-0432 UTILITIES 0.00 688.73
13-5-0000-0433 SMALL EQUIPMENT (<$5,000) 0.00 2,947.00
13-5-0000-0442 BUILDING R&M 0.00 4.99
13-5-0000-0446 EQUIPMENT R&M 0.00 135.00
13-5-0000-0501 LOAN PRINCIPAL 27,331.18 35,732.24
13-5-0000-0510 LEASE PAYMENT-FIRE 0.00 13,543.50
13-5-0000-0511 LOAN INTEREST 6,156.61 7,475.40
13-5-0000-0665 COMPRESSOR & FILL STATION 0.00 32,351.00
13-5-0000-0667 LIFEPAK 15 0.00 30,842.55
13-5-0000-0668 SCBA - FIRE EQUIPMENT 0.00 56,576.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 33,487.79 0.00 181,669.67 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 33,487.79 33,487.79 186,463.13 186,463.13
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:44 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
20 -DEBT SERVICE FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
20-1-0000-0101 CLAIM ON CASH 2,100.33 12,662.97
20-1-0000-0198 A/R - PROPERTY TAXES 0.00 2,230.86
______________ ______________ ______________ ______________
TOTAL ASSETS 2,100.33 0.00 14,893.83 0.00
============== ============== ============== ==============
LIABILITIES
===========
20-2-0000-0201 A/P PENDING 0.00 325.00
20-2-0000-0260 DEFERRED REV-PROPERTY TAXES 0.00 1,426.19
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 0.00 0.00 1,751.19
============== ============== ============== ==============
FUND BALANCE
============
20-3-0000-0305 FUND BALANCE-RESTRICTED 0.00 8,765.82
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 8,765.82
============== ============== ============== ==============
REVENUES
========
20-4-0000-0342 PENALTIES & INTEREST 394.88 3,020.69
20-4-0000-0343 DELINQUENT I&S TAXES 70.35 2,755.90
20-4-0000-0344 CURRENT PROPERTY TAXES 1,635.10 574,000.23
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 2,100.33 0.00 579,776.82
============== ============== ============== ==============
EXPENDITURES
============
20-5-0000-0466 OTHER CONTRACT SERVICES 0.00 600.00
20-5-0000-0503 BOND PRINCIPAL 0.00 190,000.00
20-5-0000-0504 BOND INTEREST 0.00 164,800.00
20-5-0000-0760 TRANSFER OUT - W/S FUND 0.00 220,000.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 575,400.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 2,100.33 2,100.33 590,293.83 590,293.83
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:44 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
30 -VCSDC
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
30-1-0000-0101 CLAIM ON CASH 9,872.14 16,148.02
30-1-0000-0103 PINNBANK CHECKING-VCSDC (4828) 0.00 291,314.59
30-1-0000-0130 TEXPOOL-VCSDC 153.64 77,636.64
30-1-0000-0195 SALES TAX RECEIVABLE 5,038.89 59,678.87
______________ ______________ ______________ ______________
TOTAL ASSETS 15,064.67 0.00 444,778.12 0.00
============== ============== ============== ==============
LIABILITIES
===========
30-2-0000-0201 A/P PENDING 474.65 819.90
30-2-0000-0203 ACCOUNTS PAYABLE 3,413.20 3,413.20
30-2-0000-0206 ACCRUED PAYROLL LIABILITIES 0.00 146.73
______________ ______________ ______________ ______________
TOTAL LIABILITIES 474.65 3,413.20 0.00 4,379.83
============== ============== ============== ==============
FUND BALANCE
============
30-3-0000-0305 FUND BALANCE-RESTRICTED 0.00 398,517.99
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 398,517.99
============== ============== ============== ==============
REVENUES
========
30-4-0000-0360 SRF/VCSDC INTEREST 153.64 789.83
30-4-0000-0365 SALES TAX REVENUES 29,765.13 330,850.96
30-4-0000-0375 CLEANING FEES (PASS-THROUGH) 0.00 5,920.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 29,918.77 0.00 337,560.79
============== ============== ============== ==============
EXPENDITURES
============
30-5-0000-0408 CITY CONTR - EDC PERSONNEL 2,275.75 41,830.55
30-5-0000-0411 CITY CONTR-PARK PERSONNEL 4,654.77 55,857.25
30-5-0000-0416 TRAINING 0.00 573.65
30-5-0000-0421 OFFICE SUPPLIES 0.00 1,828.23
30-5-0000-0426 GAS & OIL 0.00 64.98
30-5-0000-0429 DEPARTMENT SUPPLIES 199.99 351.95
30-5-0000-0430 CELL PHONE & MIFI 40.72 330.97
30-5-0000-0432 UTILITIES 1,157.79 13,593.26
30-5-0000-0442 BUILDING R&M 684.59 4,405.35
30-5-0000-0448 PARK MAINTENANCE 0.00 4,494.72
30-5-0000-0459 AUDIT SERVICES 0.00 2,000.00
30-5-0000-0462 LEGAL EXPENSES 300.00 3,600.00
30-5-0000-0465 CLEANING SERVICES 0.00 7,310.00
30-5-0000-0466 CITY CONTR-ADMIN COSTS 874.44 10,493.28
30-5-0000-0469 LIABILITY & PROPERTY INS 0.00 933.82
11-12-2023 10:44 AM CITY OF VENUS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
30 -VCSDC
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
30-5-0000-0485 MARKETING & PROMOTIONAL 4,451.45 4,451.45
30-5-0000-0491 CITY CONTR-SPECIAL EVENTS 3,153.15 20,000.00
30-5-0000-0492 CITY CONTR-LAND PURCHASE 0.00 50,762.53
30-5-0000-0660 SPECIAL PROJECTS 0.00 35,564.00
30-5-0000-0674 PARKS SHADE CANOPIES 0.00 37,234.50
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 17,792.65 0.00 295,680.49 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 33,331.97 33,331.97 740,458.61 740,458.61
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:45 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
35 -SPECIAL EVENTS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
35-1-0000-0101 CLAIM ON CASH 44.07 879.07
35-1-0000-1444 PREPAID EXPENSES 1,294.15 3,794.15
______________ ______________ ______________ ______________
TOTAL ASSETS 1,294.15 44.07 4,673.22 0.00
============== ============== ============== ==============
LIABILITIES
===========
35-2-0000-0201 A/P PENDING 1,205.20 2,128.34
35-2-0000-0213 HEALTH INSURANCE PAYABLE 34.28 34.28
35-2-0000-0246 UNUM PAYABLE 4.20 4.20
35-2-0000-0248 NNNS VOL POLICE PROGRAM 0.80 0.80
35-2-0000-0252 DEARBORN PAYABLE 5.60 5.60
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 1,250.08 0.00 2,173.22
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
35-4-0000-0376 VCSDC CONTRIBUTIONS 3,153.15 20,000.00
35-4-0000-0377 DONATIONS 250.00 6,850.00
35-4-0000-0378 VENDOR BOOTHS 0.00 195.00
35-4-0000-0379 CONCESSION SALES 0.00 817.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 3,403.15 0.00 27,862.00
============== ============== ============== ==============
EXPENDITURES
============
35-5-0000-0401 SOCIAL SECURITY TAXES 110.96 242.90
35-5-0000-0403 MEDICARE TAXES 25.95 54.87
35-5-0000-0404 RETIREMENT (TMRS) 195.45 421.04
35-5-0000-0405 OVERTIME 1,816.66 3,966.13
35-5-0000-0491 STREET DANCE 0.00 833.65
35-5-0000-0492 TRUNK & TREAT 0.00 237.50
35-5-0000-0493 TURKEY GIVEAWAY 0.00 4,904.97
35-5-0000-0494 CHRISTMAS ON THE SQUARE 0.00 13,020.14
35-5-0000-0496 EASTER EVENT 0.00 1,021.32
35-5-0000-0497 NATIONAL NIGHT OUT 5,812.44 9,311.83
35-5-0000-0498 JULY 4TH EVENT 0.00 13,232.24
35-5-0000-0741 TRANSFER TO (FROM) OTHER FUNDS 4,558.31 21,884.59
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 7,961.46 4,558.31 47,246.59 21,884.59
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 9,255.61 9,255.61 51,919.81 51,919.81
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:45 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
40 -ARPA GRANT FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
40-1-0000-0101 CLAIM ON CASH 519,258.05 955,201.46
40-1-0000-3070 DUE TO/DUE FROM CO2018 9,437.51 9,437.51
______________ ______________ ______________ ______________
TOTAL ASSETS 528,695.56 0.00 964,638.97 0.00
============== ============== ============== ==============
LIABILITIES
===========
40-2-0000-0201 A/P PENDING 22,282.13 44,715.48
40-2-0000-0205 DEFERRED REV-ARPA GRANT 7,499.97 413,954.52
40-2-0000-0210 RETAINAGE PAYABLE-PRATER ELECT 472.50 92.50
______________ ______________ ______________ ______________
TOTAL LIABILITIES 7,972.47 22,282.13 0.00 458,762.50
============== ============== ============== ==============
FUND BALANCE
============
40-3-0000-0305 FUND BALANCE-RESTRICTED 0.00 0.62
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 0.62
============== ============== ============== ==============
REVENUES
========
40-4-0000-0360 GRANT FUNDS-ARPA 549,733.99 661,075.52
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 549,733.99 0.00 661,075.52
============== ============== ============== ==============
EXPENDITURES
============
40-5-0000-0429 DEPARTMENT SUPPLIES 7,499.97 7,499.97
40-5-0000-0448 CONTRACTED SYSTEM R&M 0.00 73,550.00
40-5-0000-0621 STORM SEWER CAPACITY EVAL 0.00 9,103.00
40-5-0000-0622 WATER LINE CONTROL VAULT 1,018.58 5,138.46
40-5-0000-0624 DRIVEWAY REHAB 209 VISTA RIDGE 0.00 9,800.00
40-5-0000-0625 LONE STAR AVE REPAIR 36,267.05 36,267.05
40-5-0000-0628 SCADA SYSTEM 9,437.51 1,634.81
40-5-0000-0630 DRONE 0.00 15,476.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 44,785.60 9,437.51 156,834.48 1,634.81
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 581,453.63 581,453.63 1,121,473.45 1,121,473.45
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:45 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
41 -GRANTS FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
41-1-0000-0101 CLAIM ON CASH 4,329.16 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 4,329.16 0.00 0.00 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
41-4-0050-0381 GRANT REVENUE 4,329.16 4,329.16
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 4,329.16 0.00 4,329.16
============== ============== ============== ==============
EXPENDITURES
============
41-5-0050-0420 UNIFORMS 0.00 4,329.16
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 4,329.16 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 4,329.16 4,329.16 4,329.16 4,329.16
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:45 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
45 -COURT TECHNOLOGY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
45-1-0000-0101 CLAIM ON CASH 44.00 44.00
______________ ______________ ______________ ______________
TOTAL ASSETS 44.00 0.00 44.00 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
45-4-0000-0332 COURT TECHNOLOGY FEES 192.00 2,716.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 192.00 0.00 2,716.00
============== ============== ============== ==============
EXPENDITURES
============
45-5-0060-0468 INFORMATION TECHNOLOGY 148.00 2,672.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 148.00 0.00 2,672.00 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 192.00 192.00 2,716.00 2,716.00
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:45 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
46 -COURT SECURITY FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
46-1-0000-0101 CLAIM ON CASH 215.60 6,432.03
______________ ______________ ______________ ______________
TOTAL ASSETS 215.60 0.00 6,432.03 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
46-3-0000-0305 FUND BALANCE-RESTRICTED 0.00 3,181.53
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 3,181.53
============== ============== ============== ==============
REVENUES
========
46-4-0000-0333 BUILDING SECURITY FEES 215.60 3,250.50
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 215.60 0.00 3,250.50
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 215.60 215.60 6,432.03 6,432.03
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:45 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
47 -TRUANCY PREVENTION FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
47-1-0000-0101 CLAIM ON CASH 227.60 5,774.20
______________ ______________ ______________ ______________
TOTAL ASSETS 227.60 0.00 5,774.20 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
47-3-0000-0305 FUND BALANCE-RESTRICTED 0.00 2,599.20
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 2,599.20
============== ============== ============== ==============
REVENUES
========
47-4-0000-0339 TRUANCY PREVENTION FEES 227.60 3,175.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 227.60 0.00 3,175.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 227.60 227.60 5,774.20 5,774.20
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:45 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
50 -STREET TAX MAINT FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
50-1-0000-0101 CLAIM ON CASH 12,363.12 146,329.61
50-1-0000-0195 SALES TAX RECEIVABLE 2,519.45 29,839.44
______________ ______________ ______________ ______________
TOTAL ASSETS 14,882.57 0.00 176,169.05 0.00
============== ============== ============== ==============
LIABILITIES
===========
50-2-0000-0201 A/P PENDING 2,392.61 2,392.61
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 2,392.61 0.00 2,392.61
============== ============== ============== ==============
FUND BALANCE
============
50-3-0000-0305 FUND BALANCE-RESTRICTED 0.00 63,154.32
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 63,154.32
============== ============== ============== ==============
REVENUES
========
50-4-0000-0346 SALES TAX REVENUE 14,882.57 165,425.48
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 14,882.57 0.00 165,425.48
============== ============== ============== ==============
EXPENDITURES
============
50-5-0080-0447 STREET REPAIRS 1,150.00 44,375.30
50-5-0080-0448 STREET MATERIALS 1,242.61 2,802.91
50-5-0080-0660 ROAD ASSESSMENT SOFTWARE 0.00 7,625.15
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 2,392.61 0.00 54,803.36 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 17,275.18 17,275.18 230,972.41 230,972.41
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:45 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
51 -STREET TAX CIP FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
51-1-0000-0101 CLAIM ON CASH 0.00 260,000.03
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 260,000.03 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
51-3-0000-0305 FUND BALANCE-RESTRICTED 0.00 260,000.03
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 260,000.03
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 260,000.03 260,000.03
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:45 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
52 -TIRZ #1
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
______________ ______________ ______________ ______________
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:45 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
53 -ALLIED PID
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
______________ ______________ ______________ ______________
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:45 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
55 -BLUE STEM PID
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
55-1-0000-0101 CLAIM ON CASH 12,097.77 12,097.77
55-1-0000-0106 PB - CASH BLUESTEM PID (4836) 833.34 43,133.52
______________ ______________ ______________ ______________
TOTAL ASSETS 12,097.77 833.34 55,231.29 0.00
============== ============== ============== ==============
LIABILITIES
===========
55-2-0000-0202 ACCOUNTS PAYABLE 416.67 416.67
55-2-0000-0205 PREPAID ASSESS-150 CLIFF RIDGE 0.00 11,526.94
55-2-0000-0206 PREPAID ASSESS-340 CLIFF RIDGE 0.00 11,792.48
55-2-0000-0207 PREPAID 0.00 12,824.23
55-2-0000-0208 PREPAID - 211 HIGHGATE DR 12,097.77 12,097.77
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 12,514.44 0.00 48,658.09
============== ============== ============== ==============
FUND BALANCE
============
55-3-0000-0305 FUND BALANCE-RESTRICTED 0.00 9,131.28
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 9,131.28
============== ============== ============== ==============
REVENUES
========
55-4-0000-0342 PENALTIES & INTEREST 0.00 2,444.15
55-4-0000-0345 CURRENT PID ASSESSMENTS 0.00 62,605.96
55-4-0000-0346 LATE PID ASSESSMENTS 0.00 1,155.00
55-4-0000-0360 INTEREST INCOME 0.00 62.80
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 66,267.91
============== ============== ============== ==============
EXPENDITURES
============
55-5-0000-0421 OFFICE SUPPLIES 0.00 96.95
55-5-0000-0466 CONTRACTED SERVICES 1,250.01 5,683.79
55-5-0000-0492 FILING/RECORDING FEES 0.00 94.00
55-5-0000-0498 BANK FEES 0.00 15.00
55-5-0000-0501 DEVELOEPR REIMBURSEMENT 0.00 62,936.25
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 1,250.01 0.00 68,825.99 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 13,347.78 13,347.78 124,057.28 124,057.28
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:45 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
56 -BRAHMAN RANCH I PID
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
56-1-0000-0101 CLAIM ON CASH 33,266.50 21,422.50
56-1-0000-0302 DEVELOPER RECEIVABLE 19,120.73 19,120.73
______________ ______________ ______________ ______________
TOTAL ASSETS 19,120.73 33,266.50 19,120.73 21,422.50
============== ============== ============== ==============
LIABILITIES
===========
56-2-0000-0201 A/P PENDING 22,123.23 6,096.50
56-2-0000-0203 AUDIT A/P 0.00 2,481.00
56-2-0000-0275 DEFERRED REVENUE-PSA 7,977.46 10,879.27
______________ ______________ ______________ ______________
TOTAL LIABILITIES 22,123.23 7,977.46 10,879.27 8,577.50
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
56-4-0000-0350 DEVELOPER CONTRIBUTIONS-PSA 5,726.50 46,055.31
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 5,726.50 0.00 46,055.31
============== ============== ============== ==============
EXPENDITURES
============
56-5-0000-0463 CONTRACT SERVICES 0.00 20,891.23
56-5-0000-0464 ENGINEERING 264.00 6,900.23
56-5-0000-0465 INSPECTIONS 5,462.50 17,955.00
56-5-0000-0467 ENGINEERING SERVICES 0.00 308.85
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 5,726.50 0.00 46,055.31 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 46,970.46 46,970.46 76,055.31 76,055.31
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:45 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
57 -PATRIOT ESTATES PID
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
57-1-0000-0101 CLAIM ON CASH 17,507.38 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 17,507.38 0.00 0.00
============== ============== ============== ==============
LIABILITIES
===========
57-2-0000-0275 DEFERRED REVENUE-PSA 17,507.38 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 17,507.38 0.00 0.00 0.00
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
57-4-0000-0350 DEVELOPER CONTIBUTIONS 0.00 7,783.33
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 7,783.33
============== ============== ============== ==============
EXPENDITURES
============
57-5-0000-0464 ENGINEERING 0.00 957.00
57-5-0000-0466 CONTRACT SERVICES 0.00 6,672.80
57-5-0000-0492 PLAT FILING FEES 0.00 153.53
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 7,783.33 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 17,507.38 17,507.38 7,783.33 7,783.33
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:45 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
58 -JMJ DEVELOPMENTS PSA
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
58-1-0000-0101 CLAIM ON CASH 30,836.30 370.00
58-1-0000-0130 DEVELOPER RECEIVABLE- JMJ 0.00 27,043.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 30,836.30 27,413.00 0.00
============== ============== ============== ==============
LIABILITIES
===========
58-2-0000-0201 A/P PENDING 3,651.84 370.00
58-2-0000-0211 DEFERRED PSA REV - NORTHSTAR 17,275.54 0.00
58-2-0000-0212 DEFERRED PSA REV - BERKOWITZ 14,820.00 0.00
58-2-0000-0213 DEFERRED PSA REV - GRIFFIN 14,820.00 0.00
58-2-0000-0214 DEFERRED PSA REV - JOHNSTON 14,820.00 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 48,111.84 17,275.54 0.00 370.00
============== ============== ============== ==============
FUND BALANCE
============
58-3-0000-0305 FUND BALANCE-RESTRICTED 0.00 27,043.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 27,043.00
============== ============== ============== ==============
REVENUES
========
58-4-0000-0311 DEV CONTR - NORTHSTAR 0.00 14,779.35
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 14,779.35
============== ============== ============== ==============
EXPENDITURES
============
58-5-0011-0464 ENGINEERING SERVICES 0.00 8,881.74
58-5-0011-0466 CONTRACT SERVICES 0.00 5,897.61
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 14,779.35 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 48,111.84 48,111.84 42,192.35 42,192.35
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:45 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
60 -WATER & SEWER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
60-1-0000-0101 CLAIM ON CASH 29,025.51 274,510.02
60-1-0000-0103 PINNBANK SAVINGS - W/S (1617) 31.48 249,833.16
60-1-0000-0106 PINNBANK SAVINGS-I&S W/S (1757 55.80 442,786.26
60-1-0000-0116 TEX-POOL INVESTMENT - W/S 1,259.24 636,272.31
60-1-0000-0119 W/S CD #2 - CNB 0.00 28,105.74
60-1-0000-0120 ACCOUNTS RECEIVABLE 20,463.02 422,014.31
60-1-0000-0122 UNAPPLIED CREDITS 341.54 1,732.20
60-1-0000-0124 UNBILLED ACCOUNTS RECEIVABLE 10,200.08 38,996.98
60-1-0000-0125 ALLOWANCE FOR DOUBTFUL ACCTS 0.00 51,952.66
60-1-0000-0140 TRA OPERATING RESERVE 0.00 0.23
60-1-0000-0151 ACCUMULATED DEPRECIATION 0.00 3,309,520.09
60-1-0000-0160 CONSTRUCTION IN PROGRESS 0.00 77,128.72
60-1-0000-0161 LAND 0.00 25,269.98
60-1-0000-0162 BUILDINGS 0.00 71,099.21
60-1-0000-0163 IMPROVEMENTS 0.00 343,738.24
60-1-0000-0164 WATER AND SEWER SYSTEM 0.00 6,539,689.97
60-1-0000-0165 EQUIPMENT 0.00 376,256.75
60-1-0000-0170 DEFERRED OUTFLOWS-CONTRIBUTION 0.00 26,747.28
60-1-0000-0190 NET PENSION ASSET 0.00 13,019.00
60-1-0000-0194 TRA BUY-IN 0.00 464,700.00
60-1-0000-0195 MCWRS BUY-IN 0.00 1,550,000.00
60-1-0000-0196 ACCUMULATED AMORTIZATION 0.00 213,510.22
60-1-0000-0197 ACCUMULATED AMORTIZATION 0.00 930,000.00
60-1-0000-1445 PREPAID EXPENSES 158,773.00 162,291.51
______________ ______________ ______________ ______________
TOTAL ASSETS 191,124.16 29,025.51 11,742,459.44 4,506,715.40
============== ============== ============== ==============
LIABILITIES
===========
60-2-0000-0201 A/P PENDING 23,195.07 213,347.28
60-2-0000-0206 ACCRUED PAYROLL LIABILITIES 3,324.91 4,560.97
60-2-0000-0210 FICA/MC TAX WITHHOLDING 1,086.78 0.00
60-2-0000-0212 FED W/H PAYABLE 728.49 0.00
60-2-0000-0213 HEALTH INSURANCE PAYABLE 176.59 99.91
60-2-0000-0215 ACCRUED INTEREST 8,725.00 29,642.77
60-2-0000-0221 LEASE PAYABLE 20,826.00 0.00
60-2-0000-0246 UNUM PAYABLE 16.89 69.92
60-2-0000-0250 COMPENSATED ABSENCES 3,412.62 10,643.55
60-2-0000-0251 COLONIAL PAYABLE 0.20 86.64
60-2-0000-0252 DEARBORN LIFE PAYABLE 45.17 1.43
60-2-0000-0261 NOTE PAYABLE-TRA (MCWRS) 155,000.00 465,000.00
60-2-0000-0265 CUSTOMER DEPOSITS 2,300.00 106,250.00
60-2-0000-0266 SALES TAX PAYABLE 2,799.64 11,095.83
60-2-0000-0267 CUSTOMER DEPOSIT REFUNDS PAY 86.22 363.35
60-2-0000-0268 2016 GEN OBLIGATION REF BOND 377,000.00 0.00
60-2-0000-0269 2018 TAX AND REV CO 75,000.00 1,780,000.00
60-2-0000-0270 ESCHEATED CHECKS 0.00 610.57
60-2-0000-0285 MP DISCONNECT PAYABLE 100.00 0.00
60-2-0000-0290 DEFERRED INFLOWS-ACTUAL VS A 0.00 18,670.90
11-12-2023 10:45 AM CITY OF VENUS PAGE: 2
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
60 -WATER & SEWER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
60-2-0000-0501 2018 CO PREMIUM 8,481.53 89,056.06
60-2-0001-0221 LEASE PAYABLE - DUE IN ONE YEA 21,513.00 0.00
60-2-0001-0261 MCMWRS - DUE IN ONE YEAR 0.00 77,500.00
60-2-0001-0268 2016 GO - DUE IN ONE YEAR 4,000.00 192,000.00
60-2-0001-0269 2019 CO - DUE IN ONE YEAR 0.00 40,000.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 668,723.81 39,094.30 99.91 3,038,899.27
============== ============== ============== ==============
FUND BALANCE
============
60-3-0000-0295 UNRESERVED FUND BALANCE 331,344.64 331,344.64
60-3-0000-0301 CURRENT FUND BALANCE 0.00 1,094,334.41
60-3-0000-0305 FUND BALANCE-RESTRICTED 0.00 338,780.00
60-3-0000-0310 NET INVESTED IN CAPITAL ASSETS 0.00 2,007,965.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 331,344.64 0.00 3,772,424.05
============== ============== ============== ==============
REVENUES
========
60-4-0000-0300 WATER SALES 113,520.22 1,255,671.69
60-4-0000-0302 WATER TAPS 0.00 1,750.00
60-4-0000-0303 WATER METERS 0.00 1,575.00
60-4-0000-0304 BULK WATER SALES 0.00 2,120.00
60-4-0000-0310 SEWER SALES 172,178.49 1,784,491.10
60-4-0000-0312 SEWER TAPS 0.00 2,000.00
60-4-0000-0315 SEWER CONNECTIONS 0.00 1,000.00
60-4-0000-0326 COMMERCIAL GARBAGE 39,861.41 449,516.97
60-4-0000-0328 RESIDENTIAL GARBAGE 0.00 49,386.38
60-4-0000-0329 GARBAGE MISCELLANEOUS 0.00 226.07
60-4-0000-0330 LATE CHARGES 6,367.75 35,242.83
60-4-0000-0332 NSF CHARGES 25.00 395.00
60-4-0000-0335 RECONNECT FEES 2,120.00 1,466.44
60-4-0000-0360 INTEREST EARNINGS 1,346.52 6,985.16
60-4-0000-0362 MISCELLANEOUS 0.00 8.00
60-4-0000-0368 CASH OVER (SHORT) 21,022.78 0.00
60-4-0000-0381 4% CIVIL INSPECTION FEES 0.00 122,532.35
______________ ______________ ______________ ______________
TOTAL REVENUES 23,142.78 333,299.39 8.00 3,714,358.99
============== ============== ============== ==============
EXPENDITURES
============
60-5-0000-0408 ACCRUED COMP EXPENSES 1,611.93 1,611.93
60-5-0000-0506 BOND PRINCIPAL 228,000.00 0.00
60-5-0000-0507 BOND INTEREST 2,931.00 70,651.40
60-5-0000-0508 CAPITAL LEASE 21,513.00 0.00
60-5-0000-0509 TRA BUY-IN 77,500.00 0.00
60-5-0000-0510 CAPITAL LEASE INTEREST 342.00 369.50
60-5-0000-0511 NOTE PAYABLE INTEREST 963.00 33,137.00
60-5-0000-0512 AMORTIZATION EXPENSE 4,240.76 4,240.76
11-12-2023 10:45 AM CITY OF VENUS PAGE: 3
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
60 -WATER & SEWER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
60-5-0000-0672 AMI SYSTEM 0.00 50,572.59
60-5-0000-0674 VAC PURCHASE 0.00 60,489.60
60-5-0000-0720 TRANSFER (IN) OUT - DSF 0.00 220,000.00
60-5-0045-0400 SALARIES & WAGES 19,591.48 200,598.09
60-5-0045-0401 SOCIAL SECURITY TAXES 1,757.51 12,891.47
60-5-0045-0402 STATE UNEMPLOYMENT TAXES 10.70 552.81
60-5-0045-0403 MEDICARE TAXES 411.03 2,606.64
60-5-0045-0404 RETIREMENT (TMRS) 1,997.39 22,274.06
60-5-0045-0405 OVERTIME 524.87 2,662.02
60-5-0045-0406 WORKERS COMPENSATION 0.00 445.99
60-5-0045-0410 HEALTH INSURANCE 2,396.80 28,786.61
60-5-0045-0412 HRA 0.00 1,375.00
60-5-0045-0416 EMPLOYEE TRAINING 0.00 671.83
60-5-0045-0420 UNIFORMS 0.00 592.85
60-5-0045-0421 OFFICE SUPPLIES 0.00 2,537.26
60-5-0045-0423 POSTAGE 1,932.48 9,621.12
60-5-0045-0426 GAS & OIL 610.59 2,142.32
60-5-0045-0429 DEPARTMENT SUPPLIES 0.00 445.43
60-5-0045-0430 CELL PHONES & MIFI 69.27 893.07
60-5-0045-0431 TELEPHONE SYSTEM 0.00 586.29
60-5-0045-0432 UTILITIES 13.56 179.52
60-5-0045-0433 SMALL EQUIPMENT (<$5,000) 0.00 1,099.99
60-5-0045-0442 BUILDING R&M 134.98 8,121.88
60-5-0045-0445 VEHICLE R&M 0.00 100.45
60-5-0045-0451 MT PEAK BILLING FEES 0.00 19,342.92
60-5-0045-0458 DATA PROSE SERVICES 728.53 6,658.85
60-5-0045-0459 AUDIT SERVICES 6,625.00 11,625.00
60-5-0045-0465 CIVIL INSPECTIONS 332.50 64,361.25
60-5-0045-0468 INFORMATION TECHNOLOGY 4,737.25 21,570.73
60-5-0045-0486 MISCELLANEOUS 0.00 477.76
60-5-0045-0488 MERCHANT SERVICE FEES 1,971.90 15,044.56
60-5-0045-0495 SPECIAL PROJECTS 0.00 13,609.20
60-5-0045-0562 VEHICLE MAINT PLAN 6.00 42.21
60-5-0065-0400 SALARIES & WAGES 4,593.33 93,665.39
60-5-0065-0401 SOCIAL SECURITY TAXES 402.09 5,804.92
60-5-0065-0402 STATE UNEMPLOYMENT TAXES 8.75 62.66
60-5-0065-0403 MEDICARE TAXES 94.04 1,357.57
60-5-0065-0404 RETIREMENT (TMRS) 484.28 10,258.64
60-5-0065-0405 OVERTIME 352.48 2,675.45
60-5-0065-0406 WORKERS COMPENSATION 0.00 2,544.00
60-5-0065-0410 HEALTH INSURANCE 790.45 15,745.64
60-5-0065-0412 HRA 0.00 1,000.00
60-5-0065-0416 EMPLOYEE TRAINING 0.00 2,171.85
60-5-0065-0418 DUES & MEMBERSHIPS 0.00 119.00
60-5-0065-0420 UNIFORMS 247.77 1,854.48
60-5-0065-0421 OFFICE SUPPLIES 53.98 494.62
60-5-0065-0426 GAS & OIL 1,053.89 5,690.61
60-5-0065-0429 DEPARTMENT SUPPLIES 319.25 2,955.87
60-5-0065-0430 CELL PHONES & MIFI 191.28 2,007.48
60-5-0065-0432 UTILITIES 407.17 4,932.20
11-12-2023 10:45 AM CITY OF VENUS PAGE: 4
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
60 -WATER & SEWER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
60-5-0065-0433 SMALL EQUIPMENT (<$5,000) 332.10 332.10
60-5-0065-0442 BUILDING R&M 0.00 212.50
60-5-0065-0445 VEHICLE R&M 0.00 2,146.64
60-5-0065-0446 EQUIPMENT R&M 0.00 4,034.68
60-5-0065-0448 CONTRACTED SYSTEM R&M 3,840.00 6,452.50
60-5-0065-0449 SYSTEM PARTS & SUPP (INV) 0.00 30,516.38
60-5-0065-0450 MIDLOTHIAN WATER PURCHASES 62,496.00 760,368.00
60-5-0065-0464 ENGINEERING SERVICES 0.00 7,550.42
60-5-0065-0469 GEN LIAB & PROPERTY INSURAN 0.00 4,082.22
60-5-0065-0477 WATER SAMPLES 482.66 3,209.83
60-5-0065-0484 TCEQ PERMITS 0.00 3,035.55
60-5-0065-0486 MISCELLANEOUS 0.00 80.00
60-5-0065-0495 SPECIAL PROJECTS 0.00 10,500.00
60-5-0065-0562 VEHICLE MAINT PLAN 10.50 73.87
60-5-0075-0456 COMMERCIAL GARBAGE 16,036.77 206,143.52
60-5-0075-0457 RESIDENTIAL GARBAGE 27,334.12 297,775.99
60-5-0085-0400 SALARIES & WAGES 4,550.75 77,631.87
60-5-0085-0401 SOCIAL SECURITY TAXES 391.15 4,819.74
60-5-0085-0402 STATE UNEMPLOYMENT TAXES 2.76 18.00
60-5-0085-0403 MEDICARE TAXES 91.48 1,127.02
60-5-0085-0404 RETIREMENT (TMRS) 479.98 8,547.65
60-5-0085-0405 OVERTIME 352.53 2,675.86
60-5-0085-0406 WORKERS COMPENSATION 0.00 2,543.99
60-5-0085-0410 HEALTH INSURANCE 1,520.92 12,182.29
60-5-0085-0412 HRA 0.00 1,000.00
60-5-0085-0416 EMPLOYEE TRAINING 0.00 1,728.62
60-5-0085-0418 DUES & MEMBERSHIPS 0.00 119.00
60-5-0085-0420 UNIFORMS 65.55 1,637.70
60-5-0085-0421 OFFICE SUPPLIES 35.99 477.35
60-5-0085-0426 GAS & OIL 476.73 4,421.35
60-5-0085-0429 DEPARTMENT SUPPLIES 346.54 5,605.62
60-5-0085-0430 CELL PHONES & MIFI 159.31 1,798.05
60-5-0085-0432 UTILITIES 6,924.38 42,543.52
60-5-0085-0433 SMALL EQUIPMENT (<$5,000) 332.10 551.09
60-5-0085-0442 BUILDING R&M 0.00 212.50
60-5-0085-0445 VEHICLE R&M 0.00 428.27
60-5-0085-0446 EQUIPMENT R&M 0.00 3,509.54
60-5-0085-0448 CONTRACTED SYSTEM R&M 0.00 23,614.44
60-5-0085-0449 SYSTEM PARTS & SUPP (INV) 544.48 8,079.58
60-5-0085-0453 TRA FEES 0.00 1,103,555.86
60-5-0085-0464 ENGINEERING SERVICES 6,713.36 28,192.43
60-5-0085-0469 GEN LIAB & PROPERTY INSURAN 0.00 1,526.72
60-5-0085-0482 CHEMICALS 499.52 499.52
60-5-0085-0484 TCEQ PERMIT FEES 0.00 620.00
60-5-0085-0487 BNSF RAILROAD LEASES 0.00 4,991.97
60-5-0085-0495 SPECIAL PROJECTS 0.00 14,000.00
60-5-0085-0562 VEHICLE MAINT PLAN 4.50 31.65
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 186,874.78 337,101.69 3,515,683.05 225,852.69
============== ============== ============== ==============
11-12-2023 10:45 AM CITY OF VENUS PAGE: 5
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
60 -WATER & SEWER FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
EXPENDITURES (CONT)
====================
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 1,069,865.53 1,069,865.53 15,258,250.40 15,258,250.40
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:46 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
61 -WATER IMPACT FEES FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
61-1-0000-0101 CLAIM ON CASH 0.00 7,000.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 7,000.00 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
61-4-0000-0311 WATER IMPACT FEES 0.00 7,000.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 7,000.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 7,000.00 7,000.00
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:46 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
62 -SEWER IMPACT FEES FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
62-1-0000-0101 CLAIM ON CASH 0.00 7,000.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 7,000.00 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
62-4-0000-0312 SEWER IMPACT FEES 0.00 7,000.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 7,000.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 7,000.00 7,000.00
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:46 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
63 -PID FEES FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
63-1-0000-0301 DUE FROM GENERAL FUND 0.00 1,632,500.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 1,632,500.00 0.00
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
63-4-0000-0320 PID FEES 0.00 1,632,500.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 1,632,500.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 1,632,500.00 1,632,500.00
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:46 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
64 -W/S CPF - 2018 CO BONDS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
64-1-0000-0101 CLAIM ON CASH 25,729.48 134,407.55
64-1-0000-0105 TEXPOOL-2018 W/S CO BONDS 799.75 404,111.33
64-1-0000-0160 CONSTRUCTION IN PROGRESS 0.00 355,185.00
______________ ______________ ______________ ______________
TOTAL ASSETS 799.75 25,729.48 759,296.33 134,407.55
============== ============== ============== ==============
LIABILITIES
===========
64-2-0000-0201 A/P PENDING 28,258.36 60,178.57
64-2-0000-0211 RETAINAGE PAYABLE-PRATER 2,350.00 2,350.00
64-2-0000-2000 DUE TO OTHER FUNDS 9,437.51 9,437.51
______________ ______________ ______________ ______________
TOTAL LIABILITIES 0.00 40,045.87 0.00 71,966.08
============== ============== ============== ==============
FUND BALANCE
============
64-3-0000-0305 FUND BALANCE-RESTRICTED 300.01 1,285,975.50
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 300.01 0.00 0.00 1,285,975.50
============== ============== ============== ==============
REVENUES
========
64-4-0000-0360 INTEREST EARNINGS 799.75 4,464.75
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 799.75 0.00 4,464.75
============== ============== ============== ==============
EXPENDITURES
============
64-5-0000-0615 GEN/ATS MAIN LIFT STATION 39,114.60 66,831.91
64-5-0000-0616 12" WATER LINE FM157 0.00 174,010.30
64-5-0000-0620 CIP-PUMP STATION ENGINEERING 13,374.00 38,670.40
64-5-0000-0621 ELEVATED STORAGE TANK 2,689.65 103,327.53
64-5-0000-0663 WATER METER PROJECT 0.00 11,357.00
64-5-0000-0665 CITY HALL SEWER LINE 0.00 3,450.00
64-5-0000-0674 CITY HALL PARKING LOT 1,159.59 1,159.59
64-5-0000-0675 SCADA SYSTEM 9,137.50 9,137.50
64-5-0000-0770 TRANSFER TO CPF 70 0.00 329,573.32
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 65,475.34 0.00 737,517.55 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 66,575.10 66,575.10 1,496,813.88 1,496,813.88
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:46 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
66 -BRAHMAN RANCH WTPP
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
66-1-0000-0101 CLAIM ON CASH 14,029.75 297,082.61
66-1-0000-3050 WTPP PREPAID RENT 0.00 29,500.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 14,029.75 326,582.61 0.00
============== ============== ============== ==============
LIABILITIES
===========
66-2-0000-0201 A/P PENDING 143,617.03 158,596.78
66-2-0000-0203 AUDIT A/P 2,482.00 0.00
66-2-0000-0280 DEFERRED REVENUE-WTPP 5,861.78 292,752.83
______________ ______________ ______________ ______________
TOTAL LIABILITIES 5,861.78 146,099.03 0.00 451,349.61
============== ============== ============== ==============
FUND BALANCE
============
66-3-0000-0305 FUND BALANCE-RESTRICTED 0.00 29,500.00
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 29,500.00
============== ============== ============== ==============
REVENUES
========
66-4-0000-0351 DEV CONTRIBUTIONS-WTPP 5,861.78 81,734.03
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 5,861.78 0.00 81,734.03
============== ============== ============== ==============
EXPENDITURES
============
66-5-0000-0464 ENGINEERING SERVICES 8,343.78 24,116.03
66-5-0000-0620 WTPP ACCESS ROAD 0.00 60,100.00
66-5-0000-0661 CONSTRUCTION 151,785.00 151,785.00
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 160,128.78 0.00 236,001.03 0.00
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 165,990.56 165,990.56 562,583.64 562,583.64
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:46 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
70 -GF CPF - 2018 CO BONDS
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
70-1-0000-0101 CLAIM ON CASH 6,808.67 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 6,808.67 0.00 0.00
============== ============== ============== ==============
LIABILITIES
===========
70-2-0000-0201 A/P PENDING 6,808.67 0.00
______________ ______________ ______________ ______________
TOTAL LIABILITIES 6,808.67 0.00 0.00 0.00
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
70-4-0000-0372 INSURANCE PROCEEDS 0.00 50,000.00
______________ ______________ ______________ ______________
TOTAL REVENUES 0.00 0.00 0.00 50,000.00
============== ============== ============== ==============
EXPENDITURES
============
70-5-0000-0663 CITY HALL PARKING LOT 0.00 26,822.88
70-5-0000-0665 FIRE DEPT BLDG IMPROVEMENTS 0.00 13,479.98
70-5-0000-0671 OLD POLICE BLDG REMODEL PH 1 0.00 62,558.48
70-5-0000-0672 OLD PD RENOVATION-PHASE 2 0.00 276,711.98
70-5-0000-0764 TRANSFER FROM CPF 64 0.00 329,573.32
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 0.00 0.00 379,573.32 329,573.32
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 6,808.67 6,808.67 379,573.32 379,573.32
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:46 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
71 -2022 CO BOND FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
______________ ______________ ______________ ______________
============== ============== ============== ==============
LIABILITIES
===========
______________ ______________ ______________ ______________
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:46 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
75 -GFAAG
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
75-1-0000-0151 ACCUMULATED DEPRECIATION 0.00 1,631,650.35
75-1-0000-0160 CONSTRUCTION IN PROGRESS 0.00 42,293.53
75-1-0000-0161 LAND 0.00 445,032.00
75-1-0000-0162 BUILDINGS & IMPROVEMENTS 0.00 2,250,769.63
75-1-0000-0163 INFRASTRUCTURE 0.00 2,732,787.40
75-1-0000-0164 VEHICLES & EQUIPMENT 0.00 625,010.64
75-1-0000-0165 COMPUTER EQUIPMENT 0.00 207,107.43
75-1-0000-0166 OTHER EQUIPMENT 0.00 29,301.23
75-1-0000-0167 PARKS 0.00 633,183.87
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 6,965,485.73 1,631,650.35
============== ============== ============== ==============
FUND BALANCE
============
75-3-0000-0310 INCANORD 0.00 5,333,835.38
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 0.00 0.00 5,333,835.38
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 0.00 0.00 6,965,485.73 6,965,485.73
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:46 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
76 -GLTDAG
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
76-1-0000-0170 DOOR - CONTRIBUTIONS 0.00 82,930.08
76-1-0000-0171 DOOR - INVESTMENT 0.00 75,510.39
76-1-0000-0172 DOOR - ASSUMPTIONS 0.00 193.05
76-1-0000-0173 DOOR - ACTUARIAL EXP 0.00 20,224.19
______________ ______________ ______________ ______________
TOTAL ASSETS 0.00 0.00 178,857.71 0.00
============== ============== ============== ==============
LIABILITIES
===========
76-2-0000-0204 BONDS PAYABLE- 2018 CO 60,000.00 2,155,000.00
76-2-0000-0205 2018 CO BOND PREMIUM 10,656.28 111,890.96
76-2-0000-0206 2020 CO BONDS PAYABLE 130,000.00 4,045,000.00
76-2-0000-0207 2020 CO BOND PREMIUM 11,078.22 127,399.48
76-2-0000-0215 INTEREST PAYABLE 1,827.00 38,381.05
76-2-0000-0220 PROMISSORY NOTE PAYABLE 46,256.35 145,161.32
76-2-0000-0221 LEASE PAYABLE 116,034.66 161,998.25
76-2-0000-0250 COMPENSATED ABSENCES 11,486.94 75,278.34
76-2-0000-0260 DEFERRED REV-PROPERTY TAXES 0.00 17,898.23
76-2-0000-0280 NET PENSION LIABILITY 0.00 114,589.89
76-2-0000-0290 DIOR - ACTUAL VA 0.00 11,030.23
______________ ______________ ______________ ______________
TOTAL LIABILITIES 259,817.85 127,521.60 17,898.23 6,985,729.52
============== ============== ============== ==============
FUND BALANCE
============
76-3-0000-0301 FUND BALANCE 0.00 4,142,063.44
76-3-0000-0305 FUND BALANCE-RESTRICTED 0.00 40,208.05
76-3-0000-0310 ICANORD 122,048.69 2,616,949.65
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
TOTAL EQUITY/FUND BALANCE 0.00 122,048.69 6,799,221.14 0.00
============== ============== ============== ==============
REVENUES
========
______________ ______________ ______________ ______________
============== ============== ============== ==============
EXPENDITURES
============
76-5-0000-0512 AMORTIZATION EXPENSE 21,734.50 21,734.50
76-5-0060-0408 ACCRUED COMP EXPENDITURE 11,486.94 11,486.94
______________ ______________ ______________ ______________
TOTAL EXPENDITURES 11,486.94 21,734.50 11,486.94 21,734.50
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 271,304.79 271,304.79 7,007,464.02 7,007,464.02
============== ============== ============== ==============
*** END OF REPORT ***
11-12-2023 10:46 AM CITY OF VENUS PAGE: 1
BASE TRIAL BALANCE
AS OF: SEPTEMBER 30TH, 2022
99 -POOLED CASH FUND
*** MONTH TO DATE *** *** YEAR TO DATE ***
ACCT# ACCOUNT NAME DEBITS CREDITS DEBITS CREDITS
______________________________________________________________________________________________________________________
ASSETS
======
99-1-0000-0100 POOLED CASH (8172) 367,597.90 635,788.21
99-1-0000-1010 DUE FROM GENERAL FUND 5,163.81 175,311.07
99-1-0000-1011 DUE FROM CPF 2020 CO 4,216.40 7,313.75
99-1-0000-1020 DUE FROM DEBT SERVICE FUND 0.00 325.00
99-1-0000-1030 DUE FROM VENUS COMM DEVELOP 474.65 819.90
99-1-0000-1035 DUE FROM SPECIAL EVENTS 1,205.20 2,128.34
99-1-0000-1040 DUE FROM ARPA GRANT FUND 22,282.13 44,715.48
99-1-0000-1050 DUE FROM STREET TAX FUND 2,392.61 2,392.61
99-1-0000-1056 DUE FROM BRAHMAN RANCH PID 22,123.23 6,096.50
99-1-0000-1058 DUE FROM JMJ DEV PIDS 3,651.84 370.00
99-1-0000-1059 DUE FROM BRAHMAN RANCH II 787.50 0.00
99-1-0000-1060 DUE FROM WATER & SEWER FUND 23,195.07 213,347.28
99-1-0000-1064 DUE FROM W/S CPF 2018 CO 28,258.36 60,178.57
99-1-0000-1066 DUE FROM BRAHMAN WTPP 143,617.03 158,596.78
99-1-0000-1070 DUE FROM GF CPF 2018 CO 6,808.67 0.00
______________ ______________ ______________ ______________
TOTAL ASSETS 597,928.51 33,845.89 1,307,383.49 0.00
============== ============== ============== ==============
LIABILITIES
===========
99-2-0000-0200 ACCOUNTS PAYABLE CONTROL 196,484.72 671,595.28
99-2-0000-0209 WAGES PAYABLE 66,439.03 0.00
99-2-0000-2000 DUE TO OTHER FUNDS 434,036.93 635,788.21
______________ ______________ ______________ ______________
TOTAL LIABILITIES 66,439.03 630,521.65 0.00 1,307,383.49
============== ============== ============== ==============
FUND BALANCE
============
______________ ______________ ______________ ______________
______________ ______________ ______________ ______________
============== ============== ============== ==============
______________________________________________________________________________
_________________________________________
*** TOTALS BALANCE *** 664,367.54 664,367.54 1,307,383.49 1,307,383.49
============== ============== ============== ==============
*** END OF REPORT ***