Loading...
HomeMy WebLinkAbout03) Customer Aged A/R Report5/17/05 3:37:13 PM ACCOUNT NAME JEFFERSONVILLE SEWER DEPARTMENT CUSTOMER AGED A/R REPORT AGING AS OF 5/17/2005 SORTED BY ACCOUNT CURRENT 30 DAY 60 DAY 90+ DAY SEW 130,662.34 -2,005.03 139,697.90 ELC 19,676.25 696.66 15,064.44 MSC 14.84 0.00 29.68 ADJ 248.72 .I00.00 125.00 UNA -2.59 0.00 0.00 TOT(18269) 150,599.56 -1,208.37 1.54,917.02 188,089.44 36,066.23 58.78 12,837.36' 0.00 237,051.81 # Of Accts 0 0 0 0 < < < END OF AGED A/R REPORT > > > BALANCE 456,444.65 71,503.58 103.30 13,311.08 -2.59 541,360.02 18269 PAGE NO: 1 BY: GO USAGE 142160 42252500 0 0 0 Printed 6/3/2005 Account 101.601 101.602 101.603 101.604 101.605 101.606 101.610 101.620 102.606 103.606 113.610 115.600 115.606 115.610 125.606 126.602 126.603 126.605 126.607 143.610 149.606 '149.610 149.620 149.630 150.606 161.600 162.600 162.606 163.606 164.600 164.606 164.607 164.610 165.606 166.606 202.600 202.607 203.600 231.606 231.641 231.642 23 i .646 ' 237.602 264.610 264.620 264.630 272.600 272.606 City of Jeffersonville - Wastewater Utility Summary Trial Balance Entries From 4/1/2005 Through 4/30/2005 Description Operating and Maintenance Construction Fund Sinking Fund Cumulative Improvement Fu Reserve Fund Drainage Operating & Main Petty Cash Fund Change Fund Drainage ConstructiOn Fun Drainage Sinking Fund Accounts Receivable- Tap 'Accounts Receivable Drainage Accounts Receiva Delinquency Acnts in Trea Drainage Del Accts in Tre A/R Redev-Due From Redev- Due From Redev - Inner Ci Due From City Woehrle Roa Due From Redev- Quadrang Prepaid Expanses Drainage Unamortized Bond Unamortized Bond-Issuance De/fen'al of Loss on Refun Unamortized Discount Unamortized Bond Issue Co Land Building & Improvement Drainage Improvement Dr Const Projects in Prog Equipment Equipment Construction Work In Prog Accumulative Depreciation Allowance for Depreciatio Dr Imp-Allowance for Dep Accounts Payable Contracts Payable Due To City From Sewer De Drainage Bonds 2003 Sewage Works Revenue Bond Sewage Works Ref. Rev. Bo Sewage Works Rev Bond 199 Capital Lease-Catpil Exca Contributions From State Contributions From Federa Contributions FrOm City G Retained Earnings Drainage Retained Earning Previous Balance 382,415.56 269,024.73 380,206.11 -91,951.41 i,761,203.80 836,292.93 331.25 300.00 2,201,125.27 41,161.76 4,365.00 968,359.83 109,259.78 197,175.38 9,926.41 119,713.01 20,038.84 189,980.00 100,000.00 70,121.12 75,000.01 254,837.25 316,143.33 14,185.88 42,187:50 876,703.00 41,005,619.26 83,365.00 1,298,282.52 801,156.60 96,464.55 10,227.73 -16,328,301.62 - 19,100.25 -1,056.00 -83,092.57 -10,227.73 -21,998.72 -3,110,000.00 -3,947,957.11 -4,500,000.00 -2,892,716.50 -118,112.75 ,4,102,847.36 - 11,504,696.00 -673,431.00 -2,629,043.23 -1,617,884.34 Page 1 Activity Ending Balance '~-2-2-,-~.-~~ ~ 504,575.34~/''~ '0.00 269,024.735 421,938.30' 41,732.19 30,682.14 -61,269.27'~/ 946.67 1,762,150.47v/ 220,382.08 1,056,675.01 v 0.00 331.25 0.00 300.00 -228,348.00 1,972,777.27 ~/ 38,560.00 79,721.76~/ 0.00 4,365.00 -178,475.26 789,884.57~/ 12,776.98 122,036.76~ -462.06 196,713.32 -61.60 9,864.81 0.00 119,713.01 0.00 20,038.84 0.00 189,980.00 0.00 100,000.00 0.00 70,121.12 -333.33 74,666.68 -2,695.25 252,142.00 -4,584.75 311,558.58 -202.58 13,983.30 -187.50 42,000.00 0.00 876,703.00 25,392.86 41,031,012.12 0.00 83,365.00 0.00 1,298,282.52 0.00 801,156.60 0.00 96,464.55 0.00 10,227.73 -63,875.33 -16,392,176.95 -1,607.75 -20,708.00 -352.00 -1,408.00 0.00 -83,092.57 0.00 -10,227.73 0.00 -21,998.72 0.00 -3,110,000.00 0.00 -3,947,957.11 0.00 -4,500,000.00 0.00 -2,892,716.50 0.00 -! 18,112.75 0.00 -4,102,847.36 0.00 - 11,504,696.00 0.00 -673,431.00 0.00 -2,629,043.23 127,060.24 - 1,490,824.10 Printed 6/3/2005 Account 522.606 522.620 536.606 536.610 536.620 536.630 536.640 536.650 536.690 538.606 701.606 701.610 701.680 704.606 704.610 710.606 714.606 715.610 715.650 716.606 718.606 719.606 720.606 720.610 720.650 720.670 720.680 721.606 727.670 730.606 734.650 750.610 775.610 775.650 775.670 775.680 776.680 779.606 780.606 781.606 782.606 785.606 787.606 801.600 803.600 811.606 City of Jeffersonville- Wastewater Utility Summary Trial Balance Entries From 4/1/2005 Through 4/30/2005 Description Previous Balance Drainage Operating Revenu Operating Revenues Drainage Penalties Penalties Tap In Fees Inspection Fees Interest on Investments Income Others Availability Fee Drainage Int. on Investme Salaries and Wages Sewer Mntc Salaries Salaries Employee Benefits Employee Pension-Benefits Maintenance & Office Supp Truck & Equipment Repair Purchased Power Purchased Power- Plant Pipe & Catch Basin Materi Job Contracted Projects Materials- Stone & Other Maintenance Repair Contra Material/Supplies-Lift St Material & Supplies- Pla Materials & Supplies-Cust Offices Materials Supplie Fuel Expense Postage-Cust Acct Mobile Phone Contracted Services- EMC Repair & Mntc- Vehicle & Other Expenses- Lift Stat Other Expenses - Plant Other Expenses-Cust Acct Other Expenses - Admin & Depreciation Expenses Dep Exp-Drainage Improvem Dep Exp-Drainage Equipmen Unamortized Bond Discount Unamortized Bond Issue Co Professional Services Phase II Comp-Engineer Se Interest on Bonds Amortization-Bond Issuanc Interest Expense on Bonds -224,843.85 -1,572,245.75 -3,513.36 -21,914.30 -173,600'.00 -1,950.00 -8,084.01 -12,796.94 -6,500.00 -22,256.57 28,469.98 38,705.56 60,962.60 4,354.87 16,189.15 1,270.69 279.49 59,412.77 39,200.94 2,400.79 3,000.00 2,554.30 1,179.05 16,941.71 15,650.32 4,363.13 1,905.81 3,559.72 10,000.00 684.59 369,375.99 95.00 16,475.32 70,690.68 13,905.00 11,411.61 191,625.99 1,056.00 -9,454.75 999.99 562.50 903.50 22,429.68 14,361.99 8,085.75 141,338.24 Page 2 Activity Ending Balance -74,984.48 -228,154.46 -1,313.64 -9,623.61 -55,525.00 -55O.00 --2,977.79 -4,845.00 0.00 0.00 12,495.96 16,593.14 22,946.43 -2,932.84 10,493.04 1,213.55 1,175.02 17,588.24 5,768.45 0.00 0.00 1,779.20 788.19 252.53 1,648.22 0.00 118.60 643.05 3,500.00 715.06 123,125.33 0.00 1,665.29 16,249.47 540.O0 39,210.80 63,875.33 352.00 15,885.75 333.33 187.50 9,335.79 1,910.00 4,787.33 2,695.25 -141,338.24 -299,828.33 -1,800,400.21 -4,827.00 -31,537.91 -2.29,125.00 -2,50O.00 -11,061.80 -17,641.94 -6,500.00 -22,256.57 40,965.94 55,298.70 83,909.03 7,287.71 26,682.19 2,484.24 1,454.51 77,001.01 44,969.39 2,400.79 3,000.00 4,333.50 1,967.24 17,194.24 17,298.54 4,363.13 2,024.41 4,202.77 13,500.00 1,399.65 492,501.32 95.00 18,140.61 86,940.15 14,445.00 50,622.41 255,501.32 1,408.00 6,431.00 1,333.32 750.00 10,239.29 24,339.68 19,149.32 10,781.00 0.00 Printed 6/3/2005 Account City of Jeffersonville- Wastewater Utility Summary Trial Balance Entries From 4/1/2005 Through 4/30/2005 Description Previous Activity Balance Page 3 Ending Balance 0.00 0.00 0.00 << End of Summary Trial Balance >> Printed 6/3/2005 City of Jeffersonville - Wastewater Utility Balance Sheet Reporting As Of 4/30/2005 · ASSETS Operating and Maintenance Fund Construction Fund Sinking Fund Cumulative Improvement Fund Reserve Fund Drainage Operating & Maint Fun Petty Cash Fund Change Fund Drainage Construction Fund Drainage Sinking Fund Accounts Receivable- Tap-Ins Accounts Receivable Drainage Accounts Receivable Delinquency Acnts in Treas Off Drainage Del Accts in Treasure A/R Redev-Due From Redev-Vogt Due From Redev - Inner City Rd Due From City Woehrle Road Due From Redev- Quadrangle Prepaid Expanses Drainage Unamortized Bond Issu Unamortized Bond-Issuance Cost Deferral of Loss on Refunding Unamortized Discount Unamortized Bond IssUe Cost-Dr Land Building & Improvement Drainage Improvement Dr Const Projects in Progress Equipment Equipment Construction Work In Progress Accumulative Depreciation Allowance for Depreciation Dr Imp-Allowance for Dep TOTAL ASSETS Page I 504,575.34 269,024.73 421,938.30 -61,269.27 1,762,150.47 1,056,675.01 331.25 300.00 1,972,777.27 79,721.76 4,365.00 789,884.57 122,036.76 196,713.32 9,864.81 119,713.01 20,038.84 189,980.00 100,000.00. 70,121.12 74,666.68 252,142.00 311',558.58 13,983.30 42,000.00 876,703.00 41,031,012.12 83,365.00 1,298,282.52 801,156.60 96,464.55 10,227.73 .16,392,176.95 -20,708.00 -1,408.00 36,106,211.42 LIABILITIES Accounts Payable Contracts Payable Due To City From Sewer Dept Drainage Bonds 2003 Sewage Works Revenue Bond 1998 Sewage Works Ref. Rev. Bond 95 Sewage Works Rev Bond 1999 SRF Capital Lease-Catpil Excavator 83,092.57 10,227.73 21,998.72 3,110,000.00 3,947,957.11 4,500,000.00 2,892,716.50 118,112.75 Printed 6/3/2005 City of Jeffersonville - Wastewater Utility Balance Sheet Reporting As Of 4/30/2005 TOTAL LIABILITIES EQUITY/FUND BALANCE Contributions From State Gov. Contributions From Federal Gov Contributions From City Gov. Retained Earnings Drainage Retained Earnings Y-T-D Net Income TOTAL EQUITY/FUND BALANCE TOTAL LIABILITIES AND EQUITY/FUND BALANCE Page 2 14,684,105.38 4,102,847.36 1'1,504,696.00 673,431.00 2,629,043.23 1,490,824.10 1,021,264.35 21,422,106.04 36,106,211.42 Printed 6/3/2005 City of Jeffersonville- Wastewater Utility Income Statement Reporting 4/1/2005 To 4/30/2005 Period Activity Page 1 End BalanCe INCOME Drainage Operating Revenue Operating Revenues Drainage Penalties Penalties T ap In Fees Inspection Fees Interest on Investments Income Others Availability Fee Drainage Int. on Investments TOTAL INCOME EXPENSES Salaries and Wages Sewer Mntc Salaries Salaries Employee Benefits Employee Pension-Benefits Ins Maintenance & Office Supplies Truck & Equipment Repair Purchased Power Purchased Power- Plant Pipe & Catch Basin Materials Job Contracted Projects Materials- Stone & Other Maintenance Repair Contracts Material/Supplies-Lift Station Material & Supplies- Plant Materials & Supplies-Cust Acct Offices Materials Supplies Fuel Expense Postage-Cust Acct Mobile Phone Contracted Services - EMC Repair & Mntc- Vehicle & Equip Other Expenses- Lift Station Other Expenses - Plant Other Expenses-Cust Acct Other Expenses - Admin &Gen Depreciation Expenses Dep Exp-Drainage Improvements Dep Exp-Drainage Equipment Unamortized Bond Discount Exp Unamortized Bond Issue Cost Professional Services Phase II Comp-Engineer Service 74,984.48 228,154.46 1,313.64 9,623.61 55,525.00 550.00 2,977.79 4,845.00 0.00 0.00 377,973.98 12,495.96 16,593.14 22,946.43 2,932.84 10,493.04 1,213.55 1,175.02 17,588.24 5,768.45 0.00 0.00 1,779.20 788.19 252.53 1,648.22 0.00 118.60 643.05 3,500.00 715.06 123,125.33 0.00 1,665.29 16,249.47 540.00 39,210.80 63,875.33 352.00 15,885.75 333.33 187.50 9,335.79 1,910.00 299,828.33 1,800,400.21 4,827.00 31,537.91 229,125.00 2,500.00 11,061.80 17,641.94 6,500.00 22,256.57 2,425,678.76 40,965.94 55,298.70 83,909.03 7,287.71 26,682.19 2,484.24 1,454.51 77,001.01 44,969.39 2,400.79 3,000.00 4,333.50 1,967.24 17,194.24 17,298.54 4,363.13 2,024.41 4,202.77 13,500.00 1,399.65 492,501.32 95.00 18,140.61 86,940.15 14,445.00 50,622.41 255,501.32 1,408.00 6,431.00 1,333.32 750.00 10,239.29 24,339.68 Printed 6/3/2005 Interest on Bonds Amortization-Bond Issuance Exp Interest Expense on Bonds TOTAL EXPENSES City of Jeffersonville - Wastewater Utility Income Statement Reporting 4/1/2005 To 4/30/2005 Period Activity 4,787.33 2,695.25 -141,338.24 239,466.45 Page 2 End Balance 19,149.32 10,78i.00 0.00 1,404,414.41 TOTAL INCOME TOTAL INCOME LEss EXPENSES 377,973.98 138,507.53 2,425,678.76 1,021,264.35 Printed 6/3/2005 Account 101.601 4/15/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/3'0/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 City of Jeffersonville - Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 ThrOugh 4/30/2005 Description Transactions-Date Operating and Maintenance (AP) 3404 Sewage Departme (AP) 5965 Water Works Sup (AP) 5966 Don Meredith (AP) 5967 Ed Schindler (AP) 5968 Denny Yahr (AP) 5969 Scott Grooms (AP) 5934 PERF (AP) 5947 Clark County Re (AP) 5949 EMC of Indiana, (AP) 5952 J.R. HOE & SONS (AP) 5953 Interstate Batt (AP) 5954 Indiana America (AP) 5955 Jacobi Sales, I (AP) 5957 Liters Quarry (AP) 5958 NAPA AUTO PARTS (AP) 5959 Office Supply (AP) 5960 Harping Steel I (AP) 5960 Harping Steel I (AP) 5961 REPUBLIC DIESEL (AP) 5962 SIMMS WHOLESALE (AP) 5963 Sinking and Int (AP) 5964 AMS-TMS (AP) 5970 Dominion Homes (AP) 5971 Evening News (AP) 5991 All-State Ford (AP) 5992 Bumper to Bumpe (AP) 5993 Chlorination Co (AP) 5994 Consolidated El (AP) 5995 Construction Ma (AP) 5996 CSX Transportat (AP) 5997 Cinergy (AP) 5998 Clark County Co (AP) 5999 Clark County Re '(AP) 6000 ECL Contracting (AP) 6111 G.D. Estes (AP) 6222 G & K Services (AP) 6333 Heuser Hardware (AP) 6444 Harping Steel I (AP) 6555 Elise Jackson (AP) 66666 Mountian Valle (AP) 6777 NAPA AUTO PARTS (AP) 6888 Nextel (AP) 6999 Office Supply (AP) 60010 RSC (AP) 60011 REMC (AP) 60012 S inking and In (AP) 60013 Straeffer Pump (AP) 60014 Tetra Tech Inc Prev Bal Debit 382,415.56 406,916.14 Credit -108.66 -21.00 -1,041.00 -50.54 -30.62 -7,353.60 -250.00 -123,125.33 -1,320.00 -29.33 -250.00 -440.30 -511.73 -356.22 -109.99 -2,940.00 -1,176.00 -2.37 -274.64 -20,570.00 -3,500.00 -267.84 -48.95 -44.50 -42.19 -1,663.11 -180.62 -285.57 -10.00 -21,815.72 -150.80 -40.00 -500.00 -75:00 -467.85 -51.76 -368.00 -550.00 -10.00 -15.33 -909.16 -8.61 .-45.9'6 -1,540.97 -20,570.00 -4,637.00 -39,050.00 Page 1 Ending Balance Printed 6/3/2005 City of JeffersonVille-.Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 Through 4/30/2005 Page 2 Account 101.601 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/29/2005 101.601 Description Transactions-Date Debit Operating and Maintenance(Cont'd) (AP) 60015 Water Works Su (AP) 100010 Republic Bank (AP) 10011 Republic Bank (AP) 100012 Republic Bank (AP) 10013 Republic Bank (AP) 10014 Republic Bank (AP) 10015 Republic Bank (AP) 10016 Republic Bank (AP) 10017 Republic Bank (AP) 10018 Republic Bank (AP) 10019 Republic Bank (AP) 10020 Republic Bank (AP) 10021 Republic Bank (AP) 10023 Republic Bank (AP) 10024 Republic Bank (AP) 5973 PERF (AP) 5951 Hughes Supply (IC) REF INTEREST (IC) REV CORRECTION ON 4/ ACCOUNT TOTAL 1,438.93 14,993.25 423,348.32 Credit Ending Balance -97.00 -6,226.02 -5,225.52 -5,812.82 -5,705.73 -5,925.92 -4,925.52 -5,718.04 -476.25 -397.49 -428.99 -420.92 -437.84 -378.26 -414.66 -1'85.03 -1,602.26 '301,188.54 o 504,575.34 101.602 101.602 Coiastruction Fund Prev Bal ACCOUNT TOTAI. 269,024.73 0.00 ' 0.00 269,024.73 101.603 4/15/2005 4/15/2005 4/30/2005 101.603 Sinking Fund Prev Bal 380,206.11 (AP) 3424 Sinking and Int 20,570.00 (AP) 3424 Sinking and Int 20,570.00 (IC) REF INTEREST 592.19 ACCOUNT TOTAIJ 41,732.19 0.00 421,938.30 101.604 4/15/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 101.604 Cumulative Improvement Fu (AP) 3529 Sewage Improvem (AP) 5956 Jacobi, Toombs (AP) 5950 PEH Engineers (AP) 5988 B & G Enterpris (AP) 5989 Consolidated E1 (AP) 5990 Chase Equipment ACCOUNT TOTAIJ Prev Bal " -91,951.41 56,075.00 -6,657.70 -9,930.01 -2,000.00 -178.45 -6,626.70 56,075'.00 -25,392.86 -61,269.27 101.605. 4/3O/2005 101.605 Reserve Fund (IC) REF INTEREST ACCOUNT TOTAIJ Prev Bal 1,761,203.80 946.67 946.67 0.00 1,762,150.47 101.606 4/15/2005 4/30/2005 4/30/2005 4/30/2005 Drainage Operating & Main (AP) 0763 City Drainage F (AP) 700 Republic Bank (AP) 701 Republic Bank (AP) 702 Republic Bank Prev Bal 836,292.93 78,575.'99 -2,108.40 -2,048.40 -2,108.40 Printed 6/3/2005 Account 101.606 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/20O5 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2O05 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/29/20O5 City of Jeffersonville- Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 Through 4/30/2005 Page 3 Description Transactions-Date Drainage Operating & Main(Cont'd) (AP) 5935 Best One Giant (AP) 5936 Vehicle Maintea (AP) 5937 DON MEREDITH (AP) 5938 Drainage Sinkin (AP) 5938 Drainage Sinkin (AP) 5939 ECL Contracting (AP) 5940 Falls City Elec (AP) 5940 Falls City Elec (AP) 5941 Fuller, Mossbar (AP) 5942 Jacobi, Toombs (AP) 5942 Jacobi, Toombs (AP) 5942 Jacobi, Toombs (AP) 5943 Liters Quarry (AP) 5944 NAPA AUTO PARTS (AP) 5945 Nextel (AP) 5946 SIMMS WHOLESALE (AP) 5976 Clark County So (AP) 5977 Falls City Elec (AP) 5978 Heuser Hardware (AP) 5978 Heuser Hardware (AP) 5978 Heuser Hardware (AP) 5978 Heuser Hardware (AP) 5979 VECTREN . (AP) 5980 Liters Quarry (AP) 5981 Bob Miller (AP) 5982 NAPA AUTO PARTS (AP) 5982 NAPA AUTO PARTS (AP) 5983 NEW ALBANY TRAC (AP) 5984 Office Supply (AP) 5985 Ohio Valley Rea (AP) 5985 Ohio Valley Rea (AP) 5986 Stemler Plumbin (AP) 5987 ECL Contracting (AP) 10000 Republic Bank (AP) 10001 Republic Bank (AP) 10002 Republic Bank (AP) 10003 Republic Bank (AP) 10004 Republic Bank (AP) 10006 Republic Bank (AP) 10007 Republic Bank (AP) 10008 Republic Bank (AP) 10009 Republic Bank (AP) 5934 PERF (AP) 5975 Copy Copy of In (IC) REV CLAIM CORRECTION (IC) REV CORRECTION ON 4/ Debi't Credit Ending Balance 228,348.00 -35.00 -643.05 -137.00 -19,280.00 -19,280.00 -1,250.00 -63.81 -240.30 - 1,910.00 -4,419.29 -1,067.00 -1,312.50 -107.01 -279.58 -715.06 -576.00 -788.19 -116.32 -4.99 -62.96 -6.18 -36.97 -371.10 -194.87 -200.00 -42.98 -31.76 -209.70 . -31.14 -359.00 -1,013.40 -6.95 -1,150.00 -2,048.40 -2,133.96 -2,048.40 -161.33 -148.73 -153.32 -148.73 -147.50 -147.20 -2,026.03 -177.75 -14,993.25 Printed 6/3/2005 Account 101.606 City of Jeffersonville- Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 Through 4/30/2005 Page 4 Description Debit Credit Ending Balance Transactions-Date ACCOUNT TOTAIJ 306,923.99 -86,54i.91 1,056,675.01 101.607 4/3O/20O5 4/30/2005 4/30/2005 4/5/2005 4/8/2005 4/12/2005 4/21/2005 4/29/2005 4/8/2005 4/5/2005 4/5/2005 4/8/2005 4/8/2005 4/12/2005 4/12/2005 4/12/2005 4/12/2005 4/29/2005 4/29/2005 4/1/2005 4/1/2005 4/1/2005 4/1/2005 4/1/2005 4/1/2005 4/4/2005 4/4/2005 4/5/2005 4/5/2005 4/6/2005 4/6/2005 4/8/2005 4/4/2005 4/7/2005 4/7/2005 4/12/2005 4/12/2005 4/8/2005 4/8/2005 4/13/2005 4/13/2005 4/19/2005 4/19/2005 4/21/2005 4/21/2005 4/22/2005 Sewage Revenue Fund (AP) 10025 City Drainage (AP) 10022 SeWage Improve (AP) 10026 Sewage Departm (IC) REV RECORDING FEE 10 Prev Bal 0.00 (IC) REV RECORDING FEE 10 (IC) REV RECORDING FEE 11 (lC) REV RECO~ING FEE 10 (IC) REV RECORDING FEE 10 (IC) REV ANNUAL SAMPLING (IC) REV PERMIT #8693-94, (IC) REV PERMIT #8693-94, (IC) REV PERMIT #8699-03 (IC) REV PERMIT #8699-03 (IC) REV PERMIT #8704-07 (IC) REV PERMIT #8704-07 (IC) REV PERMIT #8710-12, (IC) REV PERMIT #8710-12, (IC) REV PERMIT #8713-15 (IC) REV PERMIT #8713-15 (lC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION (lC) REV DAILY COLLECTION .... (IC) REV DAILY COLLECTION (lC) REV DAILY COLLECTION (lC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION (lC) REV DAILY COLLECTION (IC).REV DAILY COLLECTION (IC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION (lC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION (lC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION. (lC) REV DAILY COLLECTION (lC) REV DAILY COLLECTION 19.00 19.00 19.00 19.00 19.00 4,500.00 13,500.00 1.25.00 12,000.00 125.00 10,500.00 100.00 10,525.00 125.00 9,000.00 75.00 1,939.36 19,333.41 2,659.90 42,139.25 3,341.48 20,237.22 2,828.51 12,908.65 7,031.09 45,549.35 2,357.65 21,423.87 2,492.10 2,758.00 3,115.61 12,405.13 6,771.94 70,055.08 3,547.99 24,353.42 1,711.83 9,89.5.98 5,939.12 25,332.28 1,469.59 9,152.89 745.27 -78,575.99 -56,O75.OO -406',916.14 Printed 6/3/2005 Account 101.607 4/22/2005 4/25/2005 4/25/2005 4/25/2005 4/25/2005 4/27/2005 4/27/2005 4/28/2005 4/28/2005 4/29/2005 4/29/2005 4/1/2005 4/1/2005 4/I/2005 4/1/2005 4/1/2005 4/1/2005 4/6/2005 4/6/2005 4/12/2005 4/12/2005 4/12/2005 4/19/2005 4/19/2005 4/19/2005 4/19/2005 4/21/2005 4/21/2005 101.607 City of Jeffersonville - Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 Through 4/30/2005 Description Debit Transactions-Date Sewage Revenue Fund(Cont'd) (IC) REV DAILY COLLECTION 4,981.07' (IC) REV'DAILY COLLECTION 2,292.84 (IC) REV DAILY COLLECTION 10,783.54 (IC) REV DAILY COLLECTION 2,731.02 (IC) REV DAILY COLLECTION 14,446.57 (IC) REV DAILY COLLECTION 2,020.89 (lC) REV DAILY COLLECTION 10,532.90 (IC) REV DAILY COLLECTION 4,401.74 (IC) REV DAILY COLLECTION 40,733.03 (lC) REV DAILY COLLECTION 5,974.91 (IC) REV DAILY COLLECTION 20,968.16 (lC) REV NSF CHECK 114473 (IC) REV NSF CHECK 114473 (IC) REV NSF CHECK 117429 (IC) REV NSF CHECK 117429 (IC) REV NSF CHECK 115886 (IC) REV NSF CHECK 115886 (IC) REV NSF CHECK 115678 (lC) REV NSF CHECK 115678 (lC) REV NSF CHECK 106599 (lC) REV NSF CHECK 106599 (IC) REV NSF CHECK 104119 (IC) REV NSF CHECK 118180 (lC) REV NSF CHECK 118180 (IC) REV NSF CHECK 106907 (IC) REV NSF CHECK 106907 (IC) REV NSF CHECK 101286 (IC) REV NSF CHECK 101286 'ACCOUNT TOTAIJ 541,962.64 Credit -3.50 -23.52 -3.50 -39.85 -3.50 -56.50 ~3.50 - 11.66 -3.50 -15.13 -23.05 -3.50 -13.18 -3.50 -26.88 -31.50 -129.74 -541,962.64 Page 5 Ending Balance 0.00 101.610 101.610 Petty Cash Fund Prev Bal 331.25 ACCOUNT TOTAL 0.00 0.00 331.25 101.620 101.620 Change Fund Prev Bal 300.00 ACCOUNT TOTAI. 0.00 0.00 300.00 102.606 4/30/2005 102.606 Drainage Construction Fun (IC) REV CLAIM CORRECTION ACCOUNT TOTAL Prev Bal 2,201,125.27 0.00 -228,348.00 -22'8,348.00 '1',972,777.27 103.606 4/15/2005 4/15/2'005 103.606 Drainage Sinking Fund (AP) 0751 Drainage Sinkin (AP) 0751 Drainage Sinkin ACCOUNT TOTAL Prev Bal 41,161.76 19,280.00 19,280.00 38,560.00 0.00 79,721.76 Printed 6/3/2005 Account 113.610 113.610 City of Jeffersonville- Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 Through 4/30/2005 Description Transactions-Date Accounts Receivable- Tap ACCOUNT TOTAL Page 6 Debit Credit Ending Balance Prev Bal 4,365.00 0.00 0.00 4,3.65.00 115.60O 4/15/2005 4/15/2005 4/15/2005 4/1/2005 4/1/2005 4/1/2005 4/4/2005 4/5/2005 4/6/2005 4/8/2005 4/7/2005 4/12/2005 4/8/2005 4/13/2005 4/19/2005 4/21/2005 4/22/2005 4/25/2005 4/25/2005 4/27/2005 4/28/2005 4/29/2005 4/1/2005 4/I/2005 4/1/2005 4/6/2005 4/12/2005 4/12/2005 4/19/2005 4/19/2005 4/21/2005 4/13/2005 4/13/2005 4/18/2005 4/28/2005 4/28/2005 4/18/2005 4/18/2005 4/21/2005 4/29/2005 115.600 Accounts Receivable (AP) 9662 Denny Yahr (AP) 9663 Scott Grooms (AP) 5970 Dominion Homes (IC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION (IC) REV DALLY COLLECTION (IC) REV DAILY COLLECTION (lC) REV DAILY COLLECTION (lC) REv DAILY COLLECTION (lC) REV DAILY COLLECTION (lC) REV DAILY COLLECTION (lC) REV DAILY COLLECTION (lC) REV DAILY COLLECTION (lC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION (lC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION (lC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION (IC) REV DAILY'COLLECTION (lC) REV DAILY COLLECTION (IC) REV DAILY COLLECTION (IC) REV NSF CHECK 114473 (IC) REV NSF CHECK 117429 (lC) REV NSF CHECK 115886 (lC) REV NSF CHECK 115678 (lC) REV NSF CHECK 106599 (IC) REV NSF CHECK 104119 (IC) REV NSF CHECK 118180 '(IC) REV NSF CHECK 106907 (IC) REV NSF CHECK 101286 (IC) REV ADJUSTMENTS (IC) REV ADJUSTMENTS (IC) REV ADJUSTMENTS (lC) REV ADJUSTMENTS (IC) REV ADJUSTMENTS (IC) REV LATE CHARGES (IC) REV BILLING (IC) REV SURCHARGES (IC) REV NSF CHECK CHARGE ACCOUNT TOTAL Prev Bal 968,359.83 50.54 30.62 267.84 23.52 39.85 56.50 11.66 15.13 23.05 13.18 26.88 129.74 1,482.92 389.49 9,623.61 404,684.56 89,012.94 250.00 506,132.03 -19,333.41 -42,139.25 -20,237.22 -12,908.65 -45,549.35 -21,423.87 -2,492.10 -12,405.13 -70,055.O8 -24,353.42 -9,825.98 -25,332.28 -9,152.89 -4,981.07 -10,783.54 -14,446.57 -10,532.90 -40,733.03 -20,968.16 -245,385.30 -13,155.56 -8,412.53 -684,607.29 789,884.57 Printed 6/3/2005 Account 115.606 4/1/2005 4/1/2005 4/1/2005 4/4/2005 4/5/2005 4/6/2005 4/4/2005 4/7/2005 4/12/2005 4/8/2005 4/13/2005 4/19/2005 4/21/2005 4/22/2005 4/25/2005 4/25/2005 4/27/2005 4/28/2005 4/29/2005 4/1/2005 4/1/2005 4/1/2005 4/6/2005 4/12/2005 4/19/2005 4/19/2005 4/21/2005 4/13/2005 4/13/2005 4/18/2005 4/28/2005 4/28/2005 4/18/2005 4/18/2005 115.606 City of Jeffersonville - Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 Through 4/30/2005 Page 7 Description Transactions-Date Drainage Accounts Receiva (IC) REV DAILY COLLECTION DAILY DAILY DAILY DAILY DAILY DAILY DAILY DAILY DAILY DAILY DAILY DAILY DAILY DAILY DAILY DAILY DAILY DAILY COLLECTION COLLECTION COLLECTION COLLECTION COLLECTION COLLECTION COLLECTION COLLECTION COLLECTION COLLECTION COLLECTION COLLECTION COLLECTION COLLECTION COLLECTION COLLECTION COLLECTION COLLECTION (~c) R~V (IC) REV (~c) R~V (IC) REV (IC) REV (IC) REV (IC) REV (IC) REV (IC) REV (~c) P~V (IC) REV (IC) REV (IC) REV (IC) REV (IC) REV (IC) REV (IC) REV (IC) REV (IC) REV NSF CHECK 114473 (IC) REV NSF CHECK 117429 (IC) REV NSF CHECK 115886 (IC) REV NSF CHECK 115678 (IC) REV NSF CHECK 106599 (lC) REV NSF CHECK 118180 (IC) REV NSF CHECK 106907 (IC) REV NSF CHECK 101286 (IC) REV ADJUSTMENTS (lC) REV ADJUSTMENTS (IC) REV ADJUSTMENTS (IC) REV ADJUSTMENTS (IC) REV ADJUSTMENTS (IC) REV LATE CHARGES (IC) REV BILLING ACCOUNT TOTAIJ Debit Credit Ending Balance Prev Bal 109,259.78 3.50 3.50 3.50 3.50 3.50 3.50 3.50 31.50 61.60 7.00 1,313.64 76,086.50 77,524.74 -1,939.36 -2,659.90 -3,341.48 -2,828.51 -7,031.09 -2,357.65 -2,758.00 -3,115.61 -6,771.94 -3,547.99 -1,711.83 -5,939.12 -1,469.59 -745-.27 -2,292.84 -2,731.02 -2,020.89 -4,401.74 -5,974191 -578.78 -222.79 -307~45 -64,747.76 122,036.76 ......... ,' ' ~-~ --- ,.-. ........ ........ ....... -~:~'v?~'--~' - ,~ ':-":~,--:'--;~: '"-~: '~: ~- :-;~- '-'~ -- :~:'- -' :~ :~,-, ~:,'-~-'..7-'~-~i:-~/~ ~-:.7'I~:,~ '-.-7',, ~ ..... ~ '~. 115.610 4/30/20O5 115.610 Delinquency Acnts in Trea (lC) REV RELEASED CERTIFI ACCOUNT TOTAL Prev Bal 197,175.38 -462.06 0.00 -462.06 196,713.32 125.606 4/30/2005 125.606 Drainage Del .Accts in Tre (IC) REV RELEASED CERTIFI ACCOUNT TOTAL . Prev Bal 9,926.41 -61.60 0.00 -61.60 ' 9,864.81 Printed 6/3/2005 Account 126.602 126.602 City of Jeffersonville - Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 Through 4/30/2005 Description Transactions-Date A/R Redev-Due From Redev- ACCOUNT TOTAL Page 8 Debit Credit Ending Balance Prev Bal 119,713.01 0.00 0.00 119,713.01 126.603 126.603 Due From Redev - Inner Ci ACCOUNT TOTAL Prev Bal 20,038.84 0.00 0.00 20,038.84 126.605 126.605 Due From City Woehrle Roa ACCOUNT TOTAL Prey Bal 189,980.00 0.00 0.00 189,980.00 126.607 126.607 143.610 143.610 Due From Redev- Quadrang ACCOUNT TOTAL Prepaid Expanses ACCOUNT TOTAL Prev Bal 100,000.00 0.00 0.00 100,000.00 Prev Bal 70,121.12 0.00 0.00 70,121.12 149.606 4/30/2005 149.606 Drainage Unamortized Bond (IC) REV AMORTIZATION EXP ACCOUNT TOTAL Prey Bal 75,000.01 -333.33 0.00 -333.33 74,666.68 149.610 4/30/2005 149.610 Unamortized Bond-Issuance (IC) REV AMORTIZATION EXP ACCOUNT TOTAL ~Prev Bal 254,837.25 -2,695.25 0.00 -2,695.25 252,142.00 149.620 4/30/2005 149.620 , Deferral of Loss on Refun (IC) REV SALE OF BONDS ACCOUNT TOTAL Prev Bal 316,143.33 -4,584.75 0.00 . -4,584.75 311,558.58 149.630 4/30/2005 149.630 Unamortized Discount (lC) REV BOND DISCOUNT ACCOUNT TOTAL Prev Bal 14,185.88 0.00 -202.58 -202.58 13,983.30_ 150.606 4/3O/2OO5 150.606 Unamortized Bond Issue'Co (lC) REV AMORTIZATION EXP ACCOUNT TOTAL Prev Bal 42,187.50 0.00 -187.50 -187.50 42,000.00 161.600 161.600 162.600 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 162.600 Land ACCOUNT TOTAL Prev Bal 876,703.00 oloo Building & Improvement (AP) 1900 Jacobi, Toombs (AP) 2948 PEH Engineers (AP) 0311 B & G Enterpris (AP) 0441 Consolidated E1 (AP) 0491 Chase Equipment ACCOUNT TOTAL Prev Bal 41,005,619.26 6,657.70 9,930.01 2,000.00 178.45 6,626.70 25,392.86' 0.00 876,703.00 -. 0.00 41,031,012.12 Printed 6/3/2005 Account 162.606 162.606 City of Jeffersonville - Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 Through 4/30/2005 Description Transacti°ns-Date Drainage Improvement ACCOUNT TOTAL Prey Bal Debit Credit 83,365.00 0.00 0.00 Page 9 Ending Balance 83,365.00 163.606 163.606 Dr Const Projects in Prog ACCOUNT TOTAL Prev Bal 1,298,282.52 0.00 0.00 1,298,282.52 164.600 164.600 Equipment ACCOUNT TOTAL Prev Bal 801,156.60 0.00 0,00 801,156.60 164.606 164.606 Equipment ACCOUNT TOTAL Prev Bal 96,464.55 0.00 0.00 96,464.55 164.607 164.607 , 164.610 4/30/2005 164.610 Construction Work In Prog ACCOUNT TOTAL __ Accumulative Depreciation (lC) REV DEPRECIATION EXP ACCOUNT TOTAL Prev Bal Prev Bal 10,227.73 o.oo o.oo _16,328,301.62 -63,875.33 0.00 -63,875.33 10,227.73 -16,392,176.95 165.606 4/30/2005 165.606 Allowance for Depreciatio (lC) REV DEPRECIATION EXP ACCOUNT TOTAL Prev Bal 0.00 -19,100.25 -1,607.75 -1,607.75 -20,708.00 166.606 4/3O/20O5 166.606 Dr Imp-Allowance for Dep (lC) REV DEPRECIATION EXP ACCOUNT TOTAL Prev Bal 0.00 -1,056.00 -352.00 -352.00 -1,408.00 202.600 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 Accounts Payable (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 4029 Water Works Sup (AP) 9627 Don Meredith (AP) 9659 Ed Schindler (AP) 9662 Denny Yahr (AP) 9663 Scott Grooms (AP) 2906 PERF (AP) 0357 Best One Giant (AP) 0731 Vehicle Maintea (AP) 0742 DON MEREDITH (AP) 0751 Drainage Sinkin (AP) 0751 Drainage Sinkin (AP) 0947 ECL Contracting (AP) 1125 Falls City Elec (AP) 1125 Falls City Elec (AP) 1178 Fuller, Mossbar (AP) 1900 Jacobi, Toombs (AP) 1900 Jacobi, Toombs (AP) 2213 Liters Quarry Prev Bal -83,092.57 -2,108.40 -2,048.40 -2,108.40 '108.66 -21.00 -1,041.00 -50.54 -30.62 -7,353.60 -35.00 -643.05 -137.00 -19,280.00 -19,280.00 -1,250.00 -63.81 -240.30 -1,910.00 -4,419.29 -6,657.70 -511.73 Printed 6/3/2005 Account 202.600 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 City of Jeffersonville - Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 Through 4/30/2005 Description Transactions-Date Accounts Payable(Cont'd) (AP) 2603 NAPA AUTO PARTS (AP) 2800 Office Supply (AP) 1514 Harping Steel I (AP) 1514 Harping Steel I (AP) 2948 PEH Engineers (AP) 3251 REPUBLIC DIESEL (AP) 3327 SIMMS WHOLESALE (AP) 3424 Sinking and Int (AP) 3800 AMS-TMS (AP) 5970 Dominion Homes (AP) 2603 NAPA AUTO PARTS (AP) 2603 NAPA AUTO PARTS (AP) 2630 NEW ALBANY TRAC (AP) 2800 Office Supply (AP) 2801 Ohio Valley Rea (AP) 2801 Ohio Valley Rea (AP) 3414 Stemler Plumbin (AP) 0947 ECL Contracting (AP) 0311 B & G Enterpris (AP) 0441 Consolidated E1 (AP) 0491 Chase Equipment (AP) 0148 All-State Ford (AP) 0271 Bumper to Bumpe (AP) 0409 Chlorination Co (AP) 0441 Consolidated El (AP) 0474 Construction Ma (AP) 0557 CSX Transportat (AP) 0595 Cinergy (AP) 0601 Clark County Co (AP) 0645 Clark County Re (AP) 0945 ECL Contracting (AP) 1339 G.D. Estes (AP) 1347 G & K Services (AP) 1501 Heuser Hardware (AP) 1514 Harping Steel I (AP) 1915 Elise Jackson (AP) 2481 Mountian Valley (AP) 2603 NAPA AUTO PARTS (AP) 2643 Nextel (AP) 2800 Office Supply (AP) 3286 RSC (AP) 3290 REMC (AP) 3424 Sinking and Iht (AP) 3431 Straeffer Pump (AP) 3718 Tetra Tech Inc. (AP) 4029 Water Works Sup (AP) 1900 Jacobi, Toombs (AP) 1900 Jacobi, Toombs Debit Page 10 Credit Ending Balance -356.22 -109.99 -2,940.00 -1,176.00 -9,930.01 -2.37 -274.64 -20,570.00 -3,500.00 -267.84 -42.98 -31.76 -209.70 -31.14 -359.00 -1,013.40 -6.95 -1,150.00 -2,000.00 -178.45 -6,626.70 -44.50 -42.19 -1,663~11 -180.62 -285.57 -10.00 -21,815.72 -150.80 -40.00 -500.00 -75.00 -467.85 -51.76 -368.00 -550.00 -10.00 -15.33 -909.16 -8.61 -45.96 -1,540.97 -20,570,00 -4,63.7.00 -39,050.00 -97.00 -1,067.00' -1,312.50 Printed 6/3/2005 Account 202.600 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 City of Jeffersonville - Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 Through 4/30/2005 Description Transactions-Date Accoums Payable(Cont'd) (AP) 2213 Liters Quarry (AP) 2603 NAPA AUTO PARTS (AP) 2643 Nextel (AP) 3327 SIMMS WHOLESALE (AP) 0645 Clark County Re (AP) 0969 EMC of Indiana, (AP) 1609 J.R. HOE & SONS (AP) 1796 Interstate Batt (AP) 1824 Indiana America (AP) 1896 Jacobi Sales, I (AP) 0963 Evening News (AP) 0691 Clark County So (AP) 1125 Falls City Elec (AP) 1501 Heuser Hardware (AP) 1501 Heuser Hardware (AP) 1501 Heuser Hardware (AP) 1501 Heuser Hardware (AP) 4645 VECTREN (AP) 2213 Liters Quarry (AP) 2460 Bob Miller (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299' Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 0763 City Drainage F (AP) 3529 Sewage Improvem (AP) 3404 Sewage Departme (AP) 2906 PERF (AP) 2906 PERF Debit Page .11 Credit Ending Balance c, .: -107.01 -279.58 -715.06 -576.00 -250.00 -123,125.33 -1,320.00 -29.33 -250.00 -440.30 -48.95 -788.19 -116.32 -4.99 -62.96 -6.18 -36.97 -371.10 -194.87 -200.00 -2,048.40 -2,133.96 -2,048.40 -161~33 -148.73 -153.32 -148.73 -147.50 -147.20 -6,226.02 -5,225.52 -5,812.82 -5,705.73 -5,925.92 -4,925.52 -5,718.04 -476.25 -397.49 -428.99 -420.92 -437.84 -378.26 -414.66 -78,575.99 -56,075.00 -406,916.14 -2,026.03 -18'5.03 Printed 6/3/2005 Account 202.600 4/15/2005 4/15/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 City of Jeffersonville- Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 ThrOugh 4/30/2005 Description Transactions-Date Accounts Payable(Cont'd) (AP) 0507 Copy Copy of In (AP) 1554 Hughes Supply (AP) 700 Republic Bank (AP) 701 Republic Bank (AP) 702 Republic Bank (AP) 5965 Water Works Sup (AP) 5966 Don Meredith (AP) 5967 Ed Schindler (AP) 5968 Denny Yahr (AP) 5969 Scott Grooms (AP) 5934 PERF (AP) 5935 Best One Giant (AP) 5936 Vehicle Maintea (AP) 5937 DON MEREDITH (AP) 5938 Drainage Sinkin (AP) 5938 Drainage Sinkin (AP) 5939 ECL Contracting (AP) 5940 Falls City Elec (AP) 5940 Falls City Elec (AP) 5941 Fuller, Mossbar (AP) 5942 Jacobi, Toombs (AP) 5942 Jacobi, Toombs (AP) 5942 Jacobi, Toombs (AP) 5943 Liters Quarry (AP) 5944 NAPA AUTO PARTS (AP) 5945 Nextel (AP) 5946 SIMMS WHOLESALE (AP) 5947 Clark County Re (AP) 5949 EMC of Indiana, (AP) 5952 J.R. HOE & SONS (AP) 5953 Interstate Batt (AP) 5954 Indiana America (AP) 5955 Jacobi Sales, I (AP) 5956 Jacobi, Toombs (AP) 5957 Liters Quarry (AP) 5958 NAPA AUTO PARTS (AP) 5959 Office Supply (AP) 5960 Harping Steel I (AP) 5960 Harping Steel I (AP) 5950 PEH Engineers (AP) 5961 REPUBLIC DIESEL (AP) 5962 SIMMS WHOLESALE (AP) 5963 Sinking and Int (AP) 5964 AMS-TMS (AP) 5970 Dominion Homes (AP) 5971 Evening News (AP) 5976 Clark County So (AP) 5977 Falls City Elec Debit 2,108.40 2,048.;~0' 2,108.40 108.66 21.00 1,041.00 50.54 30.62 7,353.60 35.00 643.05 137.00 19,280.00 19,280.00 1,250.00 63.81 240.30 1,910.00 4,419.29 1,067.00 1,312.50 107.01 279.58 715.06 576.00 250.00 123,125.33 1,320.00 29.33 250.00 440.30 6,657.70 511.73 356.22 109.99 2,940.00 1,176.00 9,930.01 2.37 274.64 20,570.00 3,500.00 267.84 48.95 788.19 116.32 Page 12 Credit Ending Balance -177.75 -1,602.26 Printed 6/3/2005 Account 202.600 4/30/20O5 4/30/2005 4/30/20O5 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 City of JefferSonville - Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 Through 4/30/2005 Description Trans ac tio ns-Date Accounts Payable(Cont'd) (AP) 5978 Heuser Hardware (AP) 5978 Heuser Hardware (AP) 5978 Heuser Hardware (AP) 5978 Heuser Hardware (AP) 5979 VECTREN (AP) 5980 Liters Quarry (AP) 5981 Bob Miller (AP) 5982 NAPA AUTO PARTS (AP) 5982 NAPA AUTO PARTS (AP) 5983 NEW ALBANY TRAC (AP) 5984 Office Supply (AP) 5985 Ohio Valley Rea (AP) 5985 Ohio Valley Rea (AP) 5986 Stemler Plumbin (AP) 5987 ECL Contracting (AP) 5988 B & G Enterpris (AP) 5989 Consolidated E1 (AP) 5990 Chase Equipment (AP) 5991 All-State Ford (AP) 5992 Bumper to Bumpe (AP) 5993 Chlorination Co (AP) 5994 Consolidated E1 (AP) 5995 Construction Ma (AP) 5996 CSX Transportat (AP) 5997 Cinergy (AP) 5998 Clark County Co (AP) 5999 Clark County Re (AP) 6000 ECL Contracting (AP) 6111 G.D. Estes (AP) 6222 G & K Services (AP) 6333 Heuser Hardware. (AP) 6444 Harping Steel I (AP) 6555 Elise Jackson (AP) 66666 Mountian Valle (AP) 6777 NAPA AUTO PARTS (AP) 6888 Nextel (AP) 6999 Office Supply (AP) 60010 RSC (AP) 60011 REMC (AP) 60012 S inking and In (AP) 60013 Straeffer Pump (AP) 60014 Tetra Tech Inc (AP) 60015 Water Works Su (AP) 10000 Republic Bank (AP) 10001 Republic Bank (AP) 10002 Republic Bank (AP) 10003 Republic Bank (AP) 10004 Republic Bank Debit Page 13~ Credit Ending Balance. 4.99 62.96 6.18 36.97 371.10 194.87 200.00 42.98 31.76 209.70 31.14 359.00 1,013.40 6.95 1,150.00 2,000.00 178.45 6,626.70 44.50 42.19 1,663.11 180.62 285.57 10.00 21',815.72 150.80 40.00 500.00 75.00 467.85 51.76 368.00 550.00 10.00 15.33 909.16' 8.61 45.96 1,540.97 20,570.00 4,637.00 39,050.00 97.00 2,048.40 2,133.96 2,048.40 161.33 148.73 Printed 6/3/2005 City of Jeffersonville- Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 Through 4/30/2005 Page 14 Account 202.600 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4~30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 4/30/2005 202.600 Description Transactions-Date Accounts Payable(Cont'd) (AP) 10006 Republic Bank (AP) 10007 Republic Bank (AP) 10008 Republic Bank (AP) 10009 Republic Bank (AP) 100010 Republic Bank (AP) 10011 Republic Bank (AP) 100012 Republic Bank (AP) 10013 Republic Bank (AP) 10014 Republic'Bank (AP) 10015 Republic Bank (AP) 10016 Republic Bank (AP) 10017 Republic Bank (AP) 10018 Republic Bank (AP)~ 10019 Republic Bank (AP) 10020 Republic Bank (AP) 10021 Republic Bank (AP) 10023 Republic Bank (AP) 10024 Republic Bank (AP) 10025 City Drainage (AP) 10022 Sewage Improve (AP) 10026 Sewage Departm (AP) 5934 PERF (AP) 5973 PERF (AP) 5975 Copy Copy of In (AP) 5951 Hughes Supply ACCOUNT TOTAL Debit Credit Ending Balance 153.32 148.73 147.50 147.20 6,226.02 5,225.52 5,812.82 5,705.73 5,925.92 '4,925..52 5,718.04 476.25 397.49 428.99 420.92 437.84 378.26 414.66 78,575.99 56,075.00 406,916.14 2,026.03 185.03 177.75 1,602.26 939,697.19 -939,697.19 -83,092.57 202.607 202.607 Contracts Payable Prev Bal -10,227.73 ACCOUNT TOTAI~ 0.00 0.00 -10,227.73 203.600 203.60O Due To City From Sewer De Prev Bal -21,99'8.72 ACCOUNT TOTAL · 0.00 0.00 -21,998.72' ......... t ............... ' ~. -~-~: .~ .~- .~,. ...... ,.. ..... ~ ......... ~ .~ :: ..... · .... ~: -:~-' ..... -,~ :4 ~, ~ .~ ,, ....... ;.::, ',%-:-.':. :'7 .~:~:~/: ~.:,,: ~. ~ 231.606 231.606 231.641 Drainage Bonds 2003 Prev Bal ACCOUNT TOTAl. Sewage Works Revenue Bond Prev Bal -3,110,000.00 0.00 0.00 -3,110,000.00 -3,947,957.11 231.641 231.642 ACCOUNT TOTAI, 0.00 0.00 Sewage Works Ref. R v Bo Prev.Bal -3,947,957.11 231.642 ACCOUNT TOTAL -4,500,000.00 0.00 0.00 -4,500,000.00 231.646 231.646 Sewage Works Rev Bond 199 ACCOUNT TOTAI. Prev Bal 0.00 -2,892,716.50 0.00 -2,892,716.50 Printed 6/3/2005 City of Jeffersonville - Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 Through 4/3'0/2005 Page 15 Account 237.602 237.602 264.610 264.610 Description Debit Credit Ending Balance Transactions-Date Capital Lease-Catpil Exca Prey Bal -118,112.75 ACCOUNT TOTAL - 0.00 0.00 -118,112.75 Contributions From State Prev Bal -4,102,847.36. ACCOUNT TOTAL 0.00 0.00 -4,102,847.36 264.620 264.620 Contributions From Federa Prev Bal ACCOUNT TOTAL 0.00 -11,504,696.00 0,00 - 11,504,696.00 264.63O 264.630 Contributions From City G ACCOUNT TOTAL Prey Bal 0.00 -673,431.00 0.00 -673,431.00 272.600 272.600 Retained Eamings ACCOUNT TOTAL Prey Bal -2,629,043.23 0.00 0.00 -2,629,043.23 272.606 4/30/2005 4/30/2005 272.606 522.606 4/30/2005 4/13/2005 4/13/2005 4/18/2005 4/28/2005 4/28/2005 4/18/2005 522.606 Drainage Retained Earning (IC) REV CORRECTIONS 12/3 (IC) REV CORRECTIONS 12/3 ACCOUNT TOTAL Prey Bal - 1,617,884.34 -14,278.00 141,338.24 141,338.24 -14,278.00 -1,490,824.10 Drainage Operating Revenu (lC) REV RELEASED CERTIFI (IC) REV ADJUSTMENTS (IC) REV ADJUSTMENTS (lC) REV ADJUSTMENTS (IC) REV ADJUSTMENTS (lC) REV ADJUSTMENTS (IC) REV BILLING Prev Bal -224,843.85 61.60 '578.78 222.79 307.45 -61.60 -7.00 -76,086.50 ACCOUNT TOTAL 1,170.62 -76,155.10 -299,828.33 522.620 4/30/2005 4/13/2005 4/13/2005 4/I 8/2005 4/28/2005 4/28/2005 Operating Revenues (lC) REV RELEASED CERTIFI (IC) REV ADJUSTMENTS (IC) REV ADJUSTMENTS (IC) REV ADJUSTMENTS (IC) REV ADJUSTMENTS (IC) REV ADJUSTMENTS Prev Bal -1,572,245.75 462~06 245,385.30 13,155.56 8,412.53 -1,482.92 -389.49 4/18/2005 (lC) REV BILLING -404,684.56 4/21/2005 (lC) REV SURCHARGES -89,012.94 522.620 ACCOUNT TOTAL 267,415.45 -495,569.91 -1,800,400.21 536.606 Drainage Penalties Prey Bal -3,513.36 4/18/2005 (IC) REV LATE CHARGES -1,313.64 536.606 ACCOUNT TOTAL 0.00 -1,313.64 -4,827.00 Printed 6/3/2005 Account 536.610 4/18/2005 536.610 , 536.620 4/5/2005 4/8/2005 4/12/2005 4/12/2005 4/29/2005 536.620 City of Jeffersonville - Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 Through 4/30/2005 Description Transactions-Date Penalties (IC) REV LATE CHARGES ACCOUNT TOTAI. .... Page 16 Tap In Fees (IC) REV PERMIT #8693-94, (IC) REV PERMIT #8699-03 (IC) REV PERMIT #8704-07 (IC) REV PERMIT #8710-12, (lC) REV PERMIT #8713-15 ACCOUNT TOTAl. Debit Credit Ending Balance ============ ============ . - Prev Bal -21,914.30 -9,623.61 0.00 -9,623.61 -31,537.91 P~v Bal -173,600.00 -13,500.00 -12,000.00 -10,500.00 -10,525.00 -9,000.00 · 0.00 -55,525.00 -229,125.00 . : ~ · ,.~ · .- . .... '~,~:- -..' ~.:., .. -: !~ :., ~ :, ~ : --:: ~;~i,: ,:'~: :7:: ?',( :'71.~ ' ~' ~ ~''' 'J ''-'~'- ~:~ -.'~ ' 536.630 4/5/2005 4/8/2005 4/12/2005 4/12/2005 4/29/2005 536.630 Inspection Fees (IC) REV PERMIT #8693-94, (IC) REV PERMIT #8699-03 (lC) REV PERMIT #8704-07 (lC) REV PERMIT #8710-12, (IC) REV PERMIT #8713-15 ACCOUNT TOTAL Prev Bal 0.00 -1,950.00 -125.00 -125.00 -100.00 -125.00 -75.00 -550.00 -2,500.00 536.640 4/30/2005 4/30/2005 4/30/2005 536.640 Interest on Investments (IC) KEF INTEREST (IC) KEF INTEREST (IC) REF INTEREST ACCOUNT TOTAl, Prev Bal 0.00 -8,084.01 -1,438.93 -592.19 -946.67 -2,977.79 -. 11',061.80 536.650 4/5/2005 4/8/2005 4/12/2005 4/21/2005 4/29/2005 4/8/2005 4/29/2005 536.650 Income Others (lC) REV RECORDING FEE 10 (IC) REV RECORDING FEE 10 (lC) REV RECORDING FEE 11 (IC) REV RECORDING FEE 10 (lC) REV RECORDING FEE 10 (IC) REV ANNUAL SAMPLING (lC) REV NSF CHECK CHARGE ACCOUNT TOTAL Prev Bal 0.00 -12,796.94 -19.00 -19.00 -19.00 -19.00 -19.00-4,500.00 -250.00-4,845.00 -17,641.94 536.690 536.690 Availability Fee Prev Bal -6,500.00 ACCOUNT TOTAL 0.00 0.00 -6,500.00 538.606 538.606 Drainage Int. on Investme ACCOUNT 'TOTAL Prev Bal 0.00 -22,256.57 0.00 -22,256.57 701.606 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 Salaries and Wages (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank (AP) 3299 Republic Bank Prev Bal 28,469.98 2,108.40 2,048.40 2,108.40 2,048.40 2,133.96 2,048.40 Printed 6/3/2005 City of Jeffersonville - Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 Through 4/30/2005 Account Description Debit Transactions-Date 701.606 ACCOUNT TOTAL 12'495'96 Page 17 Credit Ending Balance 0.00 701.610 Sewer Mntc Salaries Prev Bal 38,705.56 4/15/2005 (AP) 3299 Republic Bank 3,669.36 4/15/2005 (AP) 3299 Republic Bank 3,171.56 4/15/2005 (AP) 3299 Republic Bank 3,173.24 4/15/2005 (AP) 3299 Republic Bank 3,393.43 4/15/2005 (AP) 3299 Republic Bank 3,185.55 701.610 ACCOUNT TOTAL 16,593.14 40,965.94 0.00 55,298.70 701.680 Salaries Prey Bal 60,962.60 4/15/2005 (AP) 3299 Republic Bank 2,556.66 4/15/2005 (AP) 3299 Republic Bank 5,225.52 4/15/2005 (AP) 3299 Republic Bank 2,641.26 4/15/2005 (AP) 3299 Republic Bank 2,532.49 4/15/2005 (AP) 3299 Republic Bank 2,532.49 4/15/2005 (AP) 3299 Republic Bank 4,925.52 4/15/2005 (AP) 3299 Republic Bank 2,532.49 701.680 ACCOUNT TOTAL 22,946.43 0.00 83,909.03 704.606 Employee Benefits Prev Bal 4,354.87 4/15/2005 (AP) 3299 Republic Bank 161.33 4/15/2005 (AP) 3299 Republic Bank 148.73 4/15/2005 (AP) 3299 Republic Bank 153.32 4/15/2005 (AP) 3299 Republic Bank 148.73 4/15/2005 (AP) 3299 Republic Bank 147.50 4/15/2005 (AP) 3'299 Republic Bank 147.20 4/15/2005 (AP) 2906 PERF 2,026.03 704.606 ACCOUNT TOTAL 2,932.84 0.00 7,287.71 704.610 Employee Pension-Benefits Prey Bal 16,189.15 4/15/2005 (AP) 2906 PERF 7,353.60 4/15/2005 (AP) 3299 Republic Bank 476.25 4/15/2005 (AP) 3299 Republic Bank 397.49 4/15/2005 (AP) 3299 Republic Bank 428.99 4/15/2005 (AP) 3299 Republic Bank 420.92 4/15/2005 (AP) 3299 Republic Bank 437.84 4/15/2005 (AP) 3299 Republic Bank 378.26 4/15/2005 (AP) 3299 Republic Bank 414.66 4/15/2005 (AP) 2906 PERF 185.03 704.610 ACCOUNT TOTAL 10,493.04 0.00 26,682.19 710.606 Maintenance & Office Supp Prev Bal 1,270.69 4/15/2005 (AP) 1125 Falls City Elec 63.8'1. 4/15/2005 (AP) 1125 Falls City Elec 240.30 4/15/2005 (AP) 2800 Office Supply 31.14 4/15/2005 (AP) 3414 Stemler Plumbin 6.95 4/15/2005 (AP) 1125 Falls City Elec 116.32 4/15/2005 (AP) 1501 Heuser Hardware · 6.18 Printed 6/3/2005 Account 710.606 4/15/2005 4/15/2005 4/15/2005 710.606 City of Jeffersonville - Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 Through 4/30/2005 Description Transactions-Date 'Maintenance & Office Supp(Cont'd) (AP) 4645 VECTREN (AP) 2460 Bob Miller (AP) 0507 Copy Copy of In ACCOUNT TOTAL Debit 371.10 200.00 177.75 1,213.55 Page 18 Credit Ending Balance 0.00 2,484.24 714.606 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 714.606 715.610 4/15/2005 4/15/2005 715.610 Track & Equipment Repair (AP) 0357 Best One Giant (AP) 2603 NAPA AUTO PARTS (AP) 2603 NAPA AUTO PARTS (AP) 2630 NEW ALBANY TRAC (AP) 2603 NAPA AUTO PARTS (AP) 3327 SIMMS WHOLESALE Prev Bal 279.49 35.00 42.98 31.76 209.70 279.58 576.00 1 175.02 0.00 1,454.51 ACCOUNT TOTAL ' . . Purchased Power Prev Bal 59,412.77 (AP) 0595 Cinergy 16,047.27 (AP) 3290'REMC 1,540.97 ACCOUNT TOTAL 17,588.24 0.00 77,001.01 715.650 4/15/2005 715.650 Purchased Power - Plant ,(AP) 0595 Cinergy ACCOUNT TOTAL Prev Bal 39,200.94 5,768.45 5,768.45 0.00 44,969.39 716.606 716.606 Pipe & Catch Basin Mated ACCOUNT TOTAL Prev Bal 2,400.79 0.00 0.00 2,400.79 718.606 718.606 719.606 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 719.606 Job Contracted Projects Prev Bal 3,000.00 0.00 0.00 3,000.00 ACCOUNT TOTAL . Materials - Stone & Other (AP) 2801 Ohio Valley Rea (AP) 2801 Ohio Valley Rea (AP) 2213 Liters Quarry (AP) 1501 Heuser Hardware (AP) 1501 Heuser Hardware (AP) 1501 Heuser Hardware (AP) 2213 Liters Quarry ACCOUNT TOTAL Prev Bal 2,554.30 359.00 1,013.40 107.01 4.99 62.96 36.97 194.87 1,779.20 0.00 4,333.50 720.606 4/15/2005 720.606 Maintenance Repair Contra (AP) 0691 Clark County So ACCOUNT TOTAL Prev Bal 1,179.05 788.19 788.19 0.00 1,967.24 720.610 4/15/2005 4/15/2005 4/15/2005 4/15/2005 Material/Supplies-Lift St (AP) 4029 Water Works Sup (AP) 3251 REPUBLIC DIESEL (AP) 0148 All-State Ford (AP) 4029 Water Works Sup Prev Bal 16,941.71 108.66 2.37 44.50 97.00 Printed 6/3/2005 Account 720.610 City of Jeffersonville - Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 Through 4/30/2005 Description Transactions-Date ACCOUNT TOTAL Debit 252.53 Page 19 credit Ending Balance 0.00 17,194:24 720.650 4/15/2005 4/15/2005 720.650 Material & Supplies- Pla (AP) 3286 RSC (AP) 1554 Hughes Supply ACCOUNT TOTAL Prev Bal 15,650.32 45.96 1,602.26 1,648.22 0.00 17,298.54 720.670 720.670 Materials & Supplies-Cust ACCOUNT TOTAL Prev Bal 4,363.13 0.00 0.00 4,363.13 720.680 4/15/2005 4/15/2005 720.680 Offices Materials Supplie (AP) 2800 Office Supply (AP) 2800 Office Supply ACCOUNT TOTAL Prev Bal 1,905.81 109.99 8.61 118.60 0.00 2,024.41 721.606 4/15/2005 721.606 Fuel Expense (AP) 0731 Vehicle Maintea ACCOUNT TOTAL Prev Bal 3,559.72 643~.05 643.05 0.00 4,202.77 727.670 4/15/2005 727.670 Postage-Cust Acct (AP) 3800 AMS-TMS ACCOUNT TOTAIJ Prev Bal 10,000.00 3,500.00 3,500.00 0.00 13,500..00 730.606 4/15/2005 730.606 · Mobile Phone (AP) 2643 Nextel ACCOUNT TOTAL Prev Bal 684.59 715.06 715.06 0.00 1,399.65 734.650 4/15/2005 734.650 Contracted Services - EMc (AP) 0969 EMC of Indiana, ACCOUNT TOTAL Prev Bal 369,375.99 123,125.33 123,125.33 0.00 492,501.32 750.610 750.610 Repair & Mntc- Vehicle & ACCOUNT TOTAL Prev Bal 95.00 0.00 0.00 95.00 775.610 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 775.610 Other Expenses- Lift Stat (AP) 2213 Liters Quarry (AP) 0557 CSX Transportat (..Ap) 0945 ECL Contracting (AP) 1339 G.D. Estes (AP) 1347 G & K Services (AP) 1501 Heuser Hardware (AP) 0963 Evening News ACCOUNT TOTAL Prev Bal 16,475.32 511.73 1.0.00 500.00 75.00 467.85 51.76 48.95 1,665.29 0:00 18,140.61 775.650 4/15/2005 4/15/2005 4/15/2005 4/15/2005 Other Expenses - Plant (AP) 9627 Don Meredith (AP) 9659 Ed Schindler (AP) 2603 NAPA AUTO PARTS (AP) 1514 Harping Steel I Prev Bal 70,690.68 21.00 1,041.00 356.22 2,940.00 Printed 6/3/2005 Account 775.650 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 775.650 City of Jeffersonville - Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 Through 4/30/2005 Description Transactions-Date Other Expenses - Plant(Cont'd) (AP) 1514 Harping Steel I (AP) 3327 SIMMS WHOLESALE (AP) 0271 Bumper to Bumpe (AP) 0409 Chlorination Co (AP) 0441 Consolidated E1 (AP) 0474 Construction Ma (AP) 1514 Harping Steel I (AP) 1915 Elise Jackson (AP) 2603 NAPA AUTO PARTS (AP) 2643 Nextel (AP) 3431 Straeffer Pump (AP) 1609 J.R. HOE & SONS (AP) 1796 Interstate Batt (AP) 1896 Jacobi Sales, I ACCOUNT TOTAL Debit 1,176.00 274.64 42.19 1,663.11 180.62 285.57 368.00 550.00 15.33 909.16 4,637.00 1,320.00 29.33 440.30 16,249.47 Page 20 Credit Ending Balance 0.00 86,940.15 775.670 4/15/2005 4/15/2005 4/15/2005 775.670 Other Expenses-Cust Acct (AP) 0645 Clark County Re (AP) 0645 Clark County Re (AP) 1824 Indiana America ACCOUNT TOTAL Prev Bal 13,905.00 40:00 250.00 250.00 540.00 - 0.00 14,445.00 775.680 4/15/2005 4/15/2005 4/15/2005 775.680 Other Expenses- Admin & (AP) 0601 Clark County Co (AP) 2481 Mountian Valley (AP) 3718 Tetra Tech Inc. ACCOUNT TOTAL Prev Bal 11,411.61 150.80 10.00 39,050.00 39,210.80 0.00 50,622.41. 776.680 4/30/2005 776.680 DePreciation Expenses (lC) REV DEPRECIATION EXP ACCOUNT TOTAL Prev Bal 191,625.99 63,875.33 63,875.33 0.00 255,501.32 779.606 4/30/2005- 779.606 Dep Exp-Drainage Improvem (IC) REV DEPRECIATION EXP ACCOUNT TOTAL Prev Bal 1,056.00 352.00 352.0O 0.00 1,408.00 780.606 4/30/2005 4/30/2005 780.606 Dep Exp-Drainage Equipmen (IC) REV CORRECTIONS 12/3 (IC) REV DEPRECIATION EXP ACCOUNT TOTAL Prev Bal 14,278100 1,607.75 15,885.75 -9,454.75 0.00 6,431.00 781.606 4/3O/2005 781.606 Unamortized Bond Discount (IC) REV AMORTIZATION EXP ACCOUNT TOTAL Prev Bal 999.99 333.33 333.33 0.00 1,333.32 Printed 6/3/2005 Account 782.606 4/30/2005 782.606 City of Jeffersonville - Wastewater Utility Detailed Trial Balance Entries From 4/1/2005 Through 4/30/2005 Description Transactions-Date Unamortized Bond Issue Co (IC) REV AMORTIZATION EXP ACCOUNT TOTAL Prev Bal Debit Page 21 Credit Ending Balance 562.50 187.50 187.50 0.00 750.00 785.606 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 4/15/2005 785.606 Professional Services (AP) 0742 DON MEREDITH (AP) 0947 ECL Contracting (AP) 1900 Jacobi, Toombs (AP) 0947 ECL Contracting (AP) 1900 Jacobi, Toombs (AP) 1900 Jacobi, Toombs ACCOUNT TOTAL Prev Bal 903.50 137.00 1,250.00 4,419.29 1,150.00 1,067.00 1,312.50 9,335.79 0.00 1'0,239.29 787.606 Phase II Comp,Engineer Se Prev Bal 4/15/2005 (AP) 1178 Fuller, Mossbar 787.606 ACCOUNT TOTAL 801.600 Interest on Bonds i.' Prev Bal 4/30/2005 (IC) REV BOND DISCOUNT 4/30/2005 (lC) REV SALE OF BONDS 801.600 ACCOUNT TOTAL · 803.600 Amortization-Bond Issuanc Prev Bal 4/30/2005 (lC) REV AMORTIZATION. EXP 803.600 ACCOUNT TOTAL 22,429.68 1,910.00 1,910.'00 14,361.99 202.58 4,584..75 4,787.3_ 3 8,085.75 2,695.25 2,695.25 0.00 24,339.68 0.00 19,149.3'2 0.00 10,781.00 811.606 4/3O/2005 811.606 Interest Expense on Bonds (lC) REV CORRECTIONS 12/3 ACCOUNT TOTAL Prev Bal 141,338.24 0.00 -141,338.24 -141,338.24 0,00 Entry Count: << End of Detail Trial Balance >> 3,749,024.63 690 -3,749,024.63 0.00 Printed 5/26/2005 Check # 5934 5947 5949 5951 5952 5953 5954 5955 5957 5958 5959 5960 5961 5962 5963 5964 5965 5966 5967 5968 5969 5970 5971 5973 5991 5992 5993 5994 5995 5996 5997 5998 5999 6000 6111 6222 6333 6444 6555 6777 6888 6999 10011 10013 10014 10015 1O016 10017 10018 10019 10020 CITY OF JEFFERSONVILLE SEWAGE DEPT. AP Check Register - 101.601 Checks Issued 4/1/2005 To 4/30/2005 Date Vendor 4/30/2005 PERF 4/30/2005 Clark County Recorder 4/30/2005 EMC of Indiana, LCC 4/30/2005 Hughes Supply 4/30/2005 J.R. HOE & SONS 4/30/2005 Interstate Batteries 4/30/2005 Indiana America Water 4/30/2005 Jacobi Sales, Inc. 4/30/2005 Liters Quarry 4/30/2005 NAPA AUTO PARTS ' 4/30/2005 Office Supply' 4/30/2005 Harping Steel Inc 4/30/2005 REPUBLIC DIESEL 4/30/2005 SIMMS WHOLESALE 4/30/2005 Sinking and Interest Fund 4/30/2005 AMS-TMS 4/30/2005 Water Works Supplies 4/30/2005 Don Mei'edith 4/30/2005 Ed Schindler 4/30/2005 Denny Yahr 4/30/2005 Scott Grooms 4/30/2005 Dominion Homes 4/30/2005 Evening News '4/30/2005 PERF 4/30/2005 All-State Ford Truck 4/30/2005 Bumper to Bumper 4/30/2005 Chlorination Co., Inc. 4/30/2005 Consolidated Electrical Distributors 4/30/2005 Construction Machinery Co. 4/30/2005 CSX Transportation 4/30/2005 Cinergy 4/30/2005 Clark County Commissioner 4/30/2005 Clark County Recorder 4/30/2005 ECL Contracting 4/30/2005 G.D. Estes 4/30/2005 G & K Services 4/30/2005 Heuser Hardware 4/30/2005 Harping Steel Inc 4/30/2005 Elise Jackson 4/30/2005 NAPA AUTO PARTS 4/30/2005 Nextel 4/30/2005 Office Supply 4/30/2005 Republic Bank 4/30/2005 Republic Bank 4/30/2005 Republic Bank 4/30/2005 Republic Bank 4/30/2005 Republic Bank 4/30/2005 Republic Bank 4/30/2005 Republic Bank 4/30/2005 Republic Bank 4/30/2005 Republic Bank Page Sub-Totals Page 1 Check Total 7,353.60 250.00 123,125.33 1,602.26 1,320.00 29.33 250.00 440.30 511.73 356.22 109.99 4,116.00 · 2.37 274.64 20,570.00 3,500.O0 108.66 21.00 1,041.00 50.54 30.62 267.84 48.95 185.03 44.50 42.19 1,663.11 180.62 285.57 10.00 21,815.72 150.80 40.00 50o.oo 75.00 467.85 51'.76 368.00 550.00 15.33 909.16 8.61 5,225.52 5,705.73 5,925.92. 4,925.52 5,718.04 476.25 397.49 428.99 420.92 221,968,01 Man £ Man C 'Man £ Man £ Man £ Man C Man ( Man ( Man C Man ( Man Man £ Man Man (. Man £ Man £ Man £ Man £ Man ( Man £ Man C Man Man Man Man Man Man Man C Man M~n Man Man Man Man ( 'Man ( Man ( Man Man Man'( Man Man~ Man Man~ Man ' Man Man Man Man Man Man Man Printed 5/26/2005 CITY OF JEFFERSONVILLE SEWAGE DEPT. AP Check Register - 101.601 Checks Issued 4/1/2005 To 4/30/2005 Check # 10021 10023 10024 .6001.0 60011 60012 60013 60014 60015 66666 100010 100012 D~ate Vendor 4/30/2005 Republic Bank 4/30/2005 Republic Bank 4/30/2005 Republic Bank 4/30~2005 RSC 4/30/2005 REMC 4/30/2005 Sinking and Interest Fund 4/30/2005 Straeffer Pump & Supply, Inc. 4/30/2005 Tetra Tech Inc. 4/30/2005 Water Works Supplies 4/30/2005 Mountian Valley Water 4/30/2005 Republic Bank 4/30/2005 Republic Bank Page Sub-Totals Grand Totals Number of Checks Printed: Number of Checks Voided: * Indicates a Skip in Check Sequence Page 2 Check Total 437.84 378.26 414.66 45.96 1,540.97 20,570.00 4,637.00 39,050.00 97.00 10.00 6,226.02 5,812.82 79,220.53 301,188.54¥// 63 0 Man C Man C Man ( Man C Man C Man C Man C Man C Man C Man C Man C Man C Printed 5/26/2005 CITY OF JEFFERSONVILLE SEWAGE DEPT. AP Check Register - 101.604 Checks Issued 4/1/2005 To 4/30/2005 Check # Date 5950 4/30/2005 5956 4/30/2005 5988 4/30/2005 5989 4/30/2005 5990 4/30/2005 Vendor PEH Engineers Jacobi, Toombs & Lanz B & G Enterprise, Inc. Consolidated Electrical Distributors Chase Equipment Grand Totals Number of Checks Printed: Number of Checks Voided: Page 1 Check Total 9,930.01 ' 6,657.70 2,000.00 178.45 6,626.70 25,392.86 5 0 Man f2 Man 12 Man £ .Man £ Man £ * Indicates a Skip in Check Sequence Printed 5/26/2005 CITY OF JEFFERSONVILLE SEWAGE DEPT. AP Check Register - 101.606 Checks Issued 4/1/2005 To 4/30/2005 Check # Date 700 4/30/2005 701 4/30/2005 702 4/30/2005 5934 4/30/2005 5935 4/30/2005 5936 4/30/2005 5937 4/30/2005 5938 4/30/2005 5939 4/30/2005 5940 4/30/2005 5941 4/30/2005 5942 4/30/2005 5943 4/30/2005 5944 4/30/2005 5945 4/30/2005 5946 4/30/2005 5975 4/30/2005 5976 4/30/2005 5977 4/30/2005 5978 4/30/2005 5979 4/30/2005 5980 4/30/2005 5981 4/30/2005 5982 4/30/2005 5983 4/30/2005 5984 4/30/2005 5985 4/30/2005 5986 4/30/2005 5987 4/30/2005 10000 4/30/2005 10001 4/30/2005 10002 4/30/2005 10003 4/30/2005 10004 4/30/2005 10006 4/30/2005 10007 4/30/2005 10008 4/30/2005 10009 4/30/2005 Vendor Republic Bank Republic Bank Republic Bank PERF Best One Giant Tire 0 Vehicle Mainteance DON MEREDITH Drainage Sinking ECL Contracting Falls City Electric Supply Fuller, Mossbarger, Scott, & May Eng Jacobi, Toombs & Lanz Liters Quarry NAPA AUTO PARTS Nextel SIMMS WHOLESALE Copy Copy of Indiana Clark County Solid Waste Falls City Electric Supply Heuser Hardware VECTREN Liters Quarry Bob Miller NAPA AUTO PARTS NEW ALBANY TRACTOR Office Supply Ohio Valley Ready Mix Stemler Plumbing ECL Contracting Republic Bank Republic Bank Republic Bank Republic Bank Republic Bank Republic Bank Republic Bank Republic Bank Republic Bank Grand Totals Number of Checks Printed: Number of Checks Voided: * Indicates a Skip in Check Sequence Page 1 Check Total 2,108.40 2,048.40 2,108.40 2,026.03 35.00 643.05 137.00 38,560.00 1,250.00 304.11 1,910.00 6,798.79 107.01 279.58 715.06 576.00 177.75 788.19 116.32 111.10 371.10 194.87 200.'00 74.74 209.70 - 31.14 1,372.40 6.95 1,150.00 2,048.40 2,133.96 2,048.40 161.33 148.73 153.32 .148.73 147.50 147.20 71,548.66 38 0 Man (2 Man £ Man £ Man {2 Man £ Man 12 Man 12 Man £ Man 12 Man 12 Man 12 Man £ Man £ Man ( Man C Man 12 Man £ Man C 'Man £ Man ( Man 12 Man £ Man £ Man 12 Man £ Man ( Man ( Man ( Man ( Man ( Man ( Man ( Man ( Man ~ Man~ Man~ Man ~ Man~ Printed 5/26/2005 CITY OF JEFFERSONVILLE SEWAGE DEPT. AP Check Register - 101.607 Checks Issued 4/1/2005 To 4/30/2005 Check # Date 10022 4/30/2005 10025 4/30/2005 10026 4/30/2005 Vendor Sewage Improvement Fund City Drainage Fund Sewage Department Grand Totals Number of Checks Printed: Number of Checks Voided: Page 1 Check Total 56,075.00 78,575.99 406,916.14 - 541,567.13v/ 3 0 Man C Man C Man C * Indicates a Skip in Check Sequence ... 0 0 0 CD 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ~ . ~ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ...4 t'~ 0 ~ 0 0 0 0 ~.4 t,~ ~ ~ Oh O0 ~C~ '~-i 4:~ ..-.I u~ r.~ 0 0 -.4 ~-' 0 0 - .o., .,--' -4. .o o ,o o ~ o t.,-, o o,, u-, ,.o u~ ~ o ~ --.I ~ ~ t~ o t.~ -.4 o o o 0 - o o 0 o o 0 o o (:D 0 0 Ox ox clx ,.. o t,~ I,,o ~ -..4 -.,-.' -,-41 o ~ to t.~ o o 0 t.,o o 0 0 U~ U,~ U~ ~ ~ -1~ 0 0 0'~ O- 0 -~ '-4 0 0 0 ~" ,--., 0 0 0 U~ U'~ 0'~ 0 0 0 0 0 .0 0 ~ -.....1 0 0 0 0 0 4~ (Do (Do Oo Oh (~ Oh 4~ t~ Oh ~,~ ~'~ U~ u~ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ~ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - 0 o o o ~ ~ '~ o o o o o 0 0 0 0 0 0 0 0 0 0 0 0 .~ 0 0 0 0 0 0 0 0 0 0 0 0 0 I',,.) 0 --4 I'~ ~ ~ 0 0 ~'~ 0 0 ~ ~ ~ ~'l (..,~ ' ~,~ ~ ~ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Oh' 0 O0 -.4 0 ~.~ 0 ~ t~ 4~ 0'~ O0 0 0 cD -..4 0 O0 0 O0 ! o ~D 0 0 0 0 0 '0 o 0 0 0 0 0 0 o o I,,...) o o A A A > V V V o o t~ o o o o ..4 o c~ o o o o 0 o o o