Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
13-R-06 Utility Debt Revenue Adjustments
RESOLUTION NO. 13 -R -06 A RESOLUTION BY THE CITY COUNCIL OF THE CITY OF SCHERTZ, TEXAS AUTHORIZING UTILITY BILLING DEBT REVENUE ADJUSTMENTS FOR INACTIVE OUTSTANDING ACCOUNTS RECEIVABLES AFTER 180 DAYS OF NON PAYMENT AND OTHER MATTERS IN CONNECTION THEREWITH WHEREAS, the City staff of the City of Schertz (the "City ") has recommended that the City maintains quarterly debt revenue adjustments for inactive outstanding accounts; and WHEREAS, the City Council has determined that it is in the best interest of the City that all inactive outstanding accounts after 180 days non payment will be sent to City Council for consideration of Utility Billing Debt Revenue Adjustments attached hereto as "Exhibit A ". (the " Write Off Audit Register "). BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SCHERTZ, TEXAS THAT: Section 1. The City Council hereby authorizes Utility Billing Debt Revenue Adjustment on the write off audit register, in substantially the form set forth on "Exhibit A ". Section 2. The recitals contained in the preamble hereof are hereby found to be true, and such recitals are hereby made a part of this Resolution for all purposes and are adopted as a part of the judgment and finding of the City Council. Section 3. All resolutions or parts thereof, which are in conflict or inconsistent with any provision of this Resolution are hereby repealed to the extent of such conflict, and the provisions of this Resolution shall be and remain controlling as to the matters resolved herein. Section 4. This Resolution shall be construed and enforced in accordance with the laws of the State of Texas and the United States of America. Section 5. If any provision of this Resolution or the application thereof to any person or circumstance shall be held to be invalid, the remainder of this Resolution and the application of such provision to other persons and circumstances shall nevertheless be valid, and the City Council hereby declares that this Resolution would have been enacted without such invalid provision. Section 6. It is officially found, determined, and declared that the meeting at which this Resolution is adopted was open to the public and public notice of the time, place, and subject matter of the public business to be considered at such meeting, including this Resolution, was given, all as required by Chapter 551, Texas Section 7. This Resolution shall be in force and effect from and after its final passage, and it is so resolved. PASSED AND ADOPTED, this 29th day of Januaryz2013. TEXAS Carpenter ATTEST: City Secretary, Brenda Dennis (CITY SEAL j 01 -18 -2013 12:56 PM W R I T E O F F A U D I T R E G I S T E R G/L FOSTING DATE: 1/18/2013 -* TRANSFER TO BAD DEBT ** PACKET: 42683 POSTING TYPE: BOTH COMMENT CODE: BDEBT -BAD DEBT ACCOUNT FLAG ACCOUNT: NO ACCOUNT NO = __________= NAME ------ 01- 0276 -02 -0 NESBITT, LANA '* LAST PAYMENT MADE: 12/29/2011 01- 0530 -13 -0 GARCIA SR, VICTOR '* LAST PAYMENT MADE: 3/19/2012 02- 0990 -02 -0 HOLDSWORTH, GARY '* LAST PAYMENT MADE: 5/31/2012 02- 1080 -04 -0 REESE, BRANDS '* LAST PAYMENT MADE: 4/30/2012 C2- 1580 -04 -0 LUTZ, BRENDA ** LAST PAYMENT MADE: 5/04/2012 J4- 0550 -14 -0 TREVINO, KIMBERLY " LAST PAYMENT MADE: 6/15/2012 05- 0660 -09-0 WASHINGTON, LARRY ** LAST PAYMENT MADE: 2/06/2012 06- 0720 -04 -0 MARTINEZ, RAUL " LAST PAYMENT MADE: 3/16/2012 08- 0320 -11 -0 CHAVEZ, RUBEN 6 ELVIA ** LAST PAYMENT MADE: 4/17/2012 08- 1070 -09 -0 SUAREZ, ANGEL ** LAST PAYMENT MADE: 11/21/2012 08- 1430 -07 -0 CRAPA, VERONICA ** LAST PAYMENT MADE: 4/26/2012 09- 0730 -00 -0 ASTRAN, EVA " LAST PAY14ENT MADE: 11/07/2011 09- 1720 -10 -0 FLORES, JACOB & SHANDRA " LAST PAYMENT MADE: 3/19/2012 i1- 0380 -06 -0 GILBERT, HANDFUL L TRACY ** LAST PAYMENT MADE: 3/02/2012 12- 0150 -08 -0 DEMENT, DIANE !A " LAST PAYMENT MADE: 2/01/2012 14- 0193 -00 -0 HERRERA, FRANCES C ** LAST PAYMENT MADE: 6/01/2012 14- 0205 -09 -0 FELSING, CHRIS - LAST PAYMENT MADE: 0 /00 /0000 BALANCE LAST BILL 990.27 100 -WATER 4/09/2012 350 -STAX 199.89 100 -WATER 4/03/2012 350 -STAX 192.29 100 -WATER 7/28/2012 316- EXTENS 500- PENALT .---------------- - - - - -- 80.07 100 -WATER 6/28/2012 350 -STAX 76.00 100 -WATER 4/03/2012 350 -STAX 23.69 100 -WATER 7/28/2012 350 -STAX 193.48 100 -WATER 5/28/2012 350 -STAX 96.49 L00 -WATER 4/28/2012 350 -STAX 118.97 100 -WATER 5/20/2012 300 - GARBAG 500- PENALT 76.36 100 -WATER 7/20/2012 350 -STAX 156.10 100 -WATER 6/20/2012 350 -STAX 254.24 100 -WATER 3/09/2012 300 - GARBAG 500- PENALT 29.05 100 -WATER 5/09/2012 350 -STAX 69.89 100 -WATER 3/28/2012 350 -STAX 69.92 100 -WATER 3/28/2012 350 -ST.AX 132.75 100 -WATER 7/03/2012 113.66 100 -WATER 4/03/2012 350 -STAX 450.33 200 -SEWER 13.48 500 - PENALT 104.92 200 -SEWER 2.59 400 - RECYCL 107.62 200 -SEWER 3.63 350 -STAX 7.82 32.50 200 -SEWER 1.26 400 - RECYCL 42.33 200 -SEWER 1.37 500- PENALT 11.97 200 -SEWER 0.34 400- RECYCL 91.30 200 -SEWER 2.60 400 - RECYCL 41.51 200 -SEWER 1.26 400 - RECYCL 56.58 200 -SEWER 19.86 350 -ST.AX 0.34 35.78 200 -SEWER 0.82 400- RECYCL 88.05 200 -SEWER 1.13 400- RECYCL 116.83 200 -SEWER 49.64 350 -STAX 17.55 13.97 200 -SEWER 0.46 400- RECYCL 30.73 200 -SEWER 0.99 400- RECYCL 36.44 200 -SEWER 0.95 400- RECYCL 113.42 200 -SEWER 93.90 200 -SEWER 1.99 400 - RECYCL 281.88 300 - GARBAG 81.18 44.77 300 - GARBAG 5.17 500 - PENALT 42.46 300 - GARBAG 2.04 400 - RECYCL 25.09 300 - GARBAG 2.51 500- PENALT 10.86 300 - GARBAG 4.85 6.62 300 - GARBAG 0.67 48.76 300 - GARBAG 5.18 500- PENALT 32.97 300 - GARBAG 2.51 500- PENALT 34.61 204- DRAINA 1.65 400 - RECYCL 25.29 300 - GARBAG 1.65 500 - PENALT 45.39 300 - GARBAG 2.24 500 - PE4ALT 45.39 204- DRAINA 4.10 400- RECYCL 7.56 300 - GARBAG 0.91 500- PENALT 24.12 300 - GARBAG 1.97 500- PENALT 19.14 300 - GARBAG 1.89 19.33 39.86 300- GARBAG 3.78 500- PENALT PAGE: 1 163.40 31.40 11.04 24.66 4.06 15.24 3.47 16.59 4.09 31.47 14.17 15.26 2.96 2.'06 3.27 10.03 2.79 13.0'3 5.0'6 12.55 8.18 5.49 0.66 12.01 0.07 11.50 24.13 10.00 01 -18 -2013 12:56 PM W R I T E O F F A U D I T R E G I S T E R PAGE: 2 G/L POSTING DATE: 1/18/2013 *' TRANSFER TO BAD DEBT i> PACKET: 42683 FOSTING TYPE: BOTH CCMENT CODE: BDEBT -BAD DEBT ACCOUNT FLAG ACCOUNT: NO BALANCE ACCOUNTNO == _= _______= NAME ___________= LAST BILL 14- 3102 -01 -0 KEIGHER, BEAU 47.60 __ 100 -WATER _--- 16.57 - - - - -_ _ 200 -SEWER 18.20 ------------------------- 204- DRAINA 2.71 ** LAST PAYMENT MADE: 3/14/2012 4/03/2012 300 - GARBAG 8.11 350 -STAX 0.67 400 - RECYCL 1.34 14- 3264 -01 -0 CLARK, LYNN 17.22 100 -WATER 9.01 200 -SEWER 4.77 300 - GARBAG 2.76 - LAST PAYMENT MADE: 5/16/2012 6/03/2012 350 -STAX 0.23 400 - RECYCL 0.45 14- 3650 -01 -0 LEBOWITZ, KENNETH A 99.39 -- --------- 100 -WATER ---------- .60.53 ------ - - - --- 200 -SEWER 18.16 _ __ 300 - GARBAG 14.37 __ ** LAST PAYMENT MADE: 5 /18/2012 7/03/2012 350 -STAX 1.19 400 - RECYCL 2.36 500 - PENALT 2.78 18- 0010 -09 -0 CAVALIER, JAYME S JOSHUA 19.51 100 -WATER 11.23 200 -SEWER -- --------- 4.67 ------ - --- -- 300 - GARBAG 2.89 - LAST PAYMENT MADE: 5/08/2012 6/15/2012 350 -STAX 0.24 400 - RECYCL 0.48 18- 1910 -04 -0 CRUMLING, DARRELL 116.83 100 -WATER 64.09 200 -SEWER 30.39 300- GARBAG 15.18 ** LAST PAYMENT MADE: 2/14/2012 3/15/2012 350 -STAX 1.26 400- RECYCL 2.50 500 - PENALT 3.41 18- 1940 -07 -0 GARZA, MARICELLA G. 39.83 100 -WATER 20.59 200 -SEWER 10.02 300 - GARBAG 6.30 - LAST PAYMENT MADE: 3/15/2012 6/15/2012 350 -$TAX 0.52 400- RECYCL 1.04 500- PENALT 1.36 18- 2700 -01 -0 WRIGHT, JEWELL __ 41.23 __ 100 -WATER 34.42 _ - -------- 204- DRAINA -- ----- 6.81 - - - --- _ " LAST PAYMENT MADE: 1/18/2012 3/15/2012 19- 0450 -09 -0 AL- ARAIBI, COLEEN 81.85 100 -WATER 39.17 200 -SEWER 24.11 300- GARBAG 13.26 ** LAST PAYMENT MADE: 3/16/2012 4/15/2012 350 -STAX 1.10 400- RECYCL 2.18 500- PENALT 2.03 19- 1190 -05 -0 STRILCHOK ** * * * *, EUGENE 6 JANIE _ '.89.69 __ 100 -WATER _---- 99.661 - - - -__ 200 -SEWER _---- 55.00 - - - -__ __ 300 - GARBAG 20.64 LAST PAYMENT MADE: 2/29/2012 4/15/2012 316 - EXTENS 2.98 350 -STAX 1.70 400- RECYCL 3.39 500- PENALT 6.37 19- 2240 -03 -0 ANDERSON, NICHOLAS 59.33 100 -WATER 29.24 200 -SEWER 16.02 300 - GARBAG 11.28 *' LAST PAYMENT MADE: 4 /16/2012 5/15/2012 350 -ST.AX 0.93 400- RECYCL 1.86 19- 2770 -14 -0 HALPHEN, GUSTAVO 6 REAGA 114.26 100 -WATER 51.72 200 -SEWER 34.37 204- DRAINA 4.69 ** LAST PAYMENT MADE: 5/22/2012 7/15/2012 300 - GARBAG 14.01 350 -ST.AX 1.16 400 - RECYCL 2.31 19- 3350 -02 -0 DANIEL, GARY _ 151.35 _ 100 -WATER __ 81.99 _ 200 -SEWER _ 33.65 _ 204- DRAINA _-- - - - 3.42 - -- ** LAST PAY14ENT MADE: 6/14/2012 7/15/2012 300 - GARBAG 19.63 350 -STAR 1.62 400 - RECYCL 3.23 500- PENALT 7.81 20- 0690 -09 -0 ROGERS, MICHELLE R. 238.17 100 -WATER 148.31 200 -SEWER 36.99 300 - GARBAG 22.24 ^ LAST PAYMENT MADE: 1/05/2012 4/20/2012 350 -STAR 1.84 400- RECYCL 3.65 500- PENALT 25.14 20- 0860 -07 -0 BOLIZ, SANDRA 24.10 100 -WATER 10.78 200 -SEWER 7.38 300 - GARBAG 4.56 ** LAST PAY14ENT MADE: 6/01/2012 7/20/2012 350 -STAX 0.37 400- RECYCL 0.75 500- PENALT 0.26 20- 0895 -12 -0 STROUP, KATIE __---- 111.93 - - - -__ 100 -WATER 52.67 _ _ 200 -SEWER _ 28.85 -------------------- 300 - GARBAG 18.72 ** LAST PAYMENT MADE: 3/23/2012 6/20/2012 350 -STAX 1.55 400- RECYCL 3.08 500- PENALT 7.06 20- 1060 -04 -0 REINA, RABID A 92.55 100 -WATER 41.77 200 -SEWER 21.57 204- DRAINA 6.18 -* LAST PAYMENT MADE: 3/12/2012 4/20/2012 300 - GARBAG 18.46 350 -STAX 1.53 400 - RECYCL 3.04 20 -- 110 -03 -0 HERNANDEZ, LEANNE _ 120.83 100 -WATER __---- 58.28 - - - -__ 200 -SEWER --------- 30.55 ------ - - - --- 300 - GARBAG 19.48 'o- LAST PAYMENT MADE: 3/23/2012 6/20/2012 350 -STAX 1.62 400- RECYCL 3.21 500 - PENALT 7.69 O1 -18 -2013 12:56 PM W R I T E O F F A U D I T R E G I S T E R PAGE: 3 C/L .POSTING DATE: 1/18/2013 °' TRANSFER TO BAD DEBT ++ PACKET: 42683 POSTING TYPE: BOTH COMMENT CODE: BDEBT -HAD DEBT ACCOUNT ?LAG ACCOUNT: NO BALANCE ACCOUNT N0 = ________= NAME ===== ------- LAST BILL 20- 1230 -03 -0 MARTINEZ, MODESTO 237.30 100 -WATER 95.23 200 -SEWER 74.38 300 - GARBAG 38.66 ** LAST PAYMENT MADE: 12/16/2011 4/20/2012 350 -STAX 3.20 400 - RECYCL 6.36 500 - PENALT 19.47 20- 1800 -08 -0 GARCIA, LILIANA 103.29 100 -WATER 57.66 200 -SEWER 24.18 300 - GARBAG 14.72 ** LAST PAYMENT MADE: 2/21/2012 4/03/2012 350 -STAR 1.22 400 - RECYCL 2.43 500 - PENALT 3.08 20- 2700 -02-0 MONFETTE, GWENDOLYN 258.03 100 -WATER 111.77 200 -SEWER 89.25 204- DRAINA 4,99 ** LAST PAYMENT MADE: 2/21/2012 4/20/2012 300 - GARBAG 31.19 350 -ST.AX 2.58 400 - RECYCL 5.13 500 - PENALT 13.12 21- 1338 -02 -0 TABOR, CHRISTINA & SKY 77.78 100 -WATER 36.77 200 -SEWER 19.45 204 - DRAINA 4.56 ** LAST PAYMENT MADE: 5/24/2012 4/03/2012 300 - GARBAG 13.63 350 -ST7,X 1.13 400 - RECYCL 2.24 22- 0242 -00 -0 CLARK, CAROL-- + -+ --l-- 19.47 100 -WATER 10.19 200 -SEWER 4.57 300 - GARBAG 3.78 +* LAST PAYMENT MADE: 6/01/2012 5/20/2012 350 -STAX 0.31 400 - RECYCL 0.62 23- 2430 -05 -0 LINDSEY ........ TAMARON 52.58 100 -WATER 23.87 200 -SEWER 17.61 300 - GARBAG 8.83 ** LAST PAYMENT MADE: 6/06/2012 7/09/2012 350-ST-AX 0.73 400- RECYCL 1.46 500- PENALT 0.08 24- 3620 -04 -0 GARCIA, KIMBERLY 109.77 100 -WATER 51.79 200 -SEWER 32.76 300 - GARBAG 16.30 +* LAST PAYMENT MADE: 3/06/2012 5/09/2012 350 -STAX 1.35 400- RECYCL 2.68 500 - PENALT 4.09 24- 3860 -07 -0 GALEY, LEAH 25.98 100 -WATER 12.27 200 -SEWER 8.74 300 - GARBAG 3.99 ** LAST PAYMENT MADE: 6/04/2012 7/09/2012 350-ST-AX 0.33 400- RECYCL 0.65 24- 3870 -08 -0 WILLIAMS, PATRICIA ANN 34.93 100 -WATER 16.24 200 -SEWER 9.46 300 - GARBAG 7.40 -- LAST PAYMENT MADE: 6/06/2012 7/09/2012 350 -ST.AX 0.661 400- RECYCL 1.22 24- 3872 -03 -0 MCGREW, BENNIE & KATHLE 18.77 100 -WATER 15.83 204- DRAINA _ -__ 2.94 _- _ - - - - -- *- LAST PAYMENT MADE: 6/11/2012 7/09/2012 24- 4320 -06 -0 ALBERIO * * * + * * * *, JESSE & TARA 256.92 100 -WATER 166.660 200 -SEWER 42.566 300 - GARBAG 26.32 ** LAST PAYMENT MADE: 5/07/2012 7/09/2012 350 -ST.AX 2.18 400- RECYCL 4.33 500 - PENALT 14.93 -5- 0555 -01 -0 MARTIN, JENNIFER 20.86 100 -WATER 11.99 300 - GARBAG 7.12 350 -STAX 0.58 ** LAST PAYMENT MADE: 2/21/2012 4/03/2012 400- RECYCL 1.17 25- 0595 -04 -0 PATTERSON, ALECIA 66.79 100 -WATER 51.96 300 - GARBAG 10.77 350 -ST.AX 0.89 +' LAST PAY14ENT MADE: 3/12/2012 6/03/2012 400- RECYCL 1.77 500 - PENALT 1.40 25- 1261 -00 -0 BOORD, TORRIE LYNN 48.00 300 - GARBAG 36.22 350 -STAX 3.00 400 - RECYCL 5.96 ** LAST PAYMENT MADE: 11/17/2011 3/03/2012 500- PENALT 2.82 25- 2155 -02 -0 HIDALGO, REBECCA 47.64 100 -WATER 32.667 300- GARBAG 10.33 350 -STAX 0.86 -* LAST PAYMENT MADE: 1/31/2012 4/03/2012 400- RECYCL 1.70 500 - PENALT 2.08 25- 2769-07-0 GONZALES, DELFINO 156.86 100 -WATER 144.98 500- PENALT 11.88 ** LAST PAYMENT MADE: 1/05/2012 4/03/2012 26- 0730 -02 -0 KELLERMAN, CONNIE 101.65 100 -WATER 53.35 200 -SEWER 23.63 204 - DRAINA 2.85 ** LAST PAYMENT MADE: 3/23/2012 4/20/2012 300- GARBAG 17.50 350 -STAX 1.44 400- RECYCL 2.86 01 -18 -2013 12:56 PM W R I T E O F F A U D I T R E G I S T E R G/L POSTING DATE: 1/18/2013 '* TRANSFER TO BAD DEBT *� PACKET: 42683 POSTING TYPE: BOTH COMMENT CODE: BDEBT -BAD DEBT ACCOUNT FLAG ACCOUNT: NO ACCCUNT NO =_ == ---- NAME =______ -------- 26- 1350 -05 -0 WARRIOR, SHANNON /TRENAR ** LAST PAY14ENT MADE: 5/22/2012 26- 16650 -03 -0 HORECKA, KRYSTAL " LAST PAYMENT MADE: 5/17/2012. 27- 4770 -04 -0 FITZGERALD, LAURA " LAST PAYMENT MADE: 4/05/2012 27- 4850 -07 -0 LAMBERT, SHEDRICK " LAST PAYMENT MADE: 2/21/2012 27- 5790 -08 -0 BRIAN AYERS, BENJAMIN MCDANI LAST PAYMENT MADE: 5/10/2012 29- 1160 -02 -0 LEAL, DOLORES C _* LAST PAYMENT MADE: 4/11/2012 29- 0700 -00 -0 MIZIN, SUSAN " LAST PAYMENT MADE: 2/06/2012 30- 2035 -03 -0 HILLHOUSE, LISE " LAST PAYMENT MADE: 5/02/2012 30- 2050 -03 -0 RAMIREZ, BEATRIZ ** LAST PAYMENT 14ADE: 2/15/2012 31- 2850 -00 -0 MORGA.N, RCGENIA ** LAST PA1_4ENT MADE: 3/05/2012 31- 4290 -04 -0 BULLOCK, JI.MMY '* LAST PAYMENT MADE: 2/17/2012 31- 5940 -05 -0 CARROLL, AMANDA `* LAST PAYMENT 14ADE: 2/01/2012 31- 66090 -06 -0 PORTER, LEZLIE " LAST PAYMENT MADE: 3/01/2012 2- 0400 -02 -0 DAVIS, WILLIAM A. *' LAST PAYMENT MADE: 9/15/2011 39- 0730 -02 -0 KLEIMAN, STEVE " LAST PAYMENT MADE: 3/29/2012 41- 0190 -03 -0 SELLARDS, MARK - LAST PAYMENT MADE: 4/10/2012 BALANCE LAST BILL 71.48 100 -WATER 7/20/2012 316 - EXTENS 500 - PENALT 47.52 100 -WATER 7/20/2012 350 -STAX 97.36 100 -WATER 4/20/2012 300 - GARBAG 295.71 100 -WATER 3/20/2012 204- DRAINA 400 - RECYCL 18.96 100 -WATER 6/20/2012 350 -STAX 227.40 100 -WATER 5/15/2012 300- GARBAG 400 - RECYCL 94.62 100 -WATER 4/09/2012 350 -STAX 70.40 100 -WATER 6/20/2012 350 -STIIX 38.30 100 -WATER 4/20/2012 350 -STAX 9.53 100 -WATER 3/20/2012 300 - GARBAG 668.78 100 -WATER 4/20/2012 350 -STAX 22.10 100 -WATER 4/20/2012 350 -ST.AX 224.17 100 -WATER 4/20/2012 300 - GARBAG 400 - RECYCL 158.33 100 -WATER 3/15/2012 207.666 100 -WATER 5/20/2012 350 -STAX 342.43 100 -WATER 7109/2012 350 -ST.AX 32.80 200 -SEWER 4.90 350 -ST.AX 2.32 23.03 200 -SEWER 1.03 400 - RECYCL 51.44 200 -SEWER 11.36 350 -STAX 668.12 152 -PAST D 2.04 300- GARBAG 3.79 500- PENALT ------------- - - - - -' 10.43 200 -SEVER 0.25 400 - RECYCL 92.07 200 -SEWER 31.25 314 -NSF F3 5.15 500- PENALT 51.46 200 -SEWER 1.43 400 - RECYCL 39.36 200 -SEWER 0.89 400- RECYCL 19.29 200 -SEWER 0.70 400- RECYCL 2.91 200 -SEWER 1.22 350 -STAX 30.93 200 -SEWER 1.16 400- RECYCL -------- - - - - -- 9.13 200 -SEWER 0.41 400- RECYCL 126.11 200 -SEWER 35.02 316- EXTENS 5.76 500 - PENALT 125.73 204 - DRAINA 110.44 200 -SEWER 1.86 400 - RECYCL 180.95 200 -SEWER 3.11 400- RECYCL 12.27 300 - GARBAG 1.27 400 - RECYCL 8.26 300 - GARBAG 2.04 500 - PENALT 21.95 204- DRAINA 0.94 400 - RECYCL 148.68 200 -SEWER 23.07 350 -STAN 1.75 4.81 300- GARBAG 0.49 62.37 204- DRAINA 20.00 350-ST-AX 7.47 18.12 300- GARBAG 2.85 500- PENALT 11.52 300- GARBAG 1.79 8.42 300 - GARBAG 1.40 4.63 204- DRAINA 0.10 400- RECYCL 17.43 300 - GARBAG 2.29 500- PENALT 6.566 300- GARBAG 0.82 500- PENALT 34.86 204 - DRAINA 5.00 350 -STAR 10.72 20.44 500- PENALT 62.25 300- GARBAG 3.70 500- PENALT 95.84 300- GARBAG 6.18 500- PENALT PAGE: 4 15.39 2.53 12.44 0.72 3.80 1.87 46.36 1.90 2.98 6.51 2.58 17.29 3.47 10.84 8.49 0.41 0.20 13.95 3.02 4.98 0.20 3.80 2.90 12.16 22.47 6.94 37.52 18.83 01 -18 -2013 12:56 PM W R I T E O F F A U D I T R E G I S T E R C/L POSTING DATE: 1 /18 /2013 +* TRANSFER TO BAD DEBT " PACKET: 42683 POSTING TYPE: BOTH COMMENT CODE: BDEBT -BAD DEBT ACCOUNT FLAG ACCOUNT: NO ACCOUNT NO = __________= NAME 41- 9600 -02-0 DURHAM, TRACY " LAST PAYMENT MADE: 2/07/2012 43- 0935 -03 -0 SESSUMS, STEVE & CHRISTI ' LAST PAYMENT MADE: 5/09/2012 43- 1300 -03 -0 DICKERSON, GREGORY " LAST PAYMENT MADE: 6/05/2012 43- 4010 -02 -0 ROBERTS, ROBIN J " LAST PAYMENT MADE: 3/02/2012 44- 0305 -01 -0 SHINE, TEXAS " LAST PAYMENT MADE: 3/12/2012 45- 2790 -02 -0 WESTON, PATRICK " -1--' " LAST PAYMENT MADE: 5/02/2012 47- 1540 -01 -0 CROUCH, APRIL " LAST PAYMENT MADE: 4/13/2012 49 -0374 -05 -0 NICHOLAS, CRAIG - LAST PAYMENT MADE: 4/17/2012 49-0462 -06 -0 PRIMM, DAVCN �' LAST PAYMENT MADE: 3/19/2012 49- 0790 -01 -0 REYNOSO, ANA MARIA " LAST PAYMENT MADE; 6/04/2012 49- 0838 -01 -0 NONP14AKER, SUSAN L " LAST PAYMENT MADE: 4/30/2012 49- 1060 -01 -0 MOSES, ADALE " LAST PAYMENT MADE: 3/15/2012 49- 1108 -01 -0 CORPENING, CHERIE " LAST PAYMENT MADE: 5/29/2012 50- 1010 -03 -0 MCCARLEY, DUSTIN ` LAST PAYMENT MADE: 5/01/2012 50- 4096 -08 -0 MARTINEZ, GREGORIO " LAST PAYMENT MADE: 3/29/2012 50- 4270 -05 -0 FREUND, DIANA " LAST PAYMENT MADE: 3/23/2012 50- 4450 -04 -0 RUIZ JR, JOHN R LAST PAYMENT MADE: 2/03/2012 BALANCE LAST BILL 76.45 100 -WATER 3/09/2012 350-ST-AX 42.55 100 -WATER 6/20/2012 350 -STAX 86.35 100 -WATER 6/20/2012 300 - GARBAG 663.35 100 -WATER 3/20/2012 300 - GARBAG 49.01 100 -WATER 4/20/2012 350 -STAX 90.25 100 -WATER 5/15/2012 350 -STAR 97.85 100 -WATER 6/15/2012 350 -ST.AX 662.43 100 -WATER 5/20/2012 350 -STAX 72.51 100 -WATER 6/20/2012 350 -STAX 88.49 100 -WATER 7/20/2012 300 - GARBAG 21.52 100 -WATER 5/20/2012 300 - GARBAG 169.166 100 -WATER 4/20/2012 300- GARBAG 500 - PENALT 48.662 100 -WATER 6/20/2012 300 - GARBAG 59.39 100 -WATER 7/09/2012 350 -STAX 158.05 100 -WATER 5/09/2012 300 - GARBAG 500- PENALT 23.55 100 -WATER 5/09/2012 350 -STAX 131.22 100 -WATER 66/09/2012 300 - GARBAG 500- PENALT 31.76 200 -SEWER 1.00 400 - RECYCL 22.91 200 -SEWER 0.43 400- RECYCL 47.43 200 -SEWER 8.62 350 -STAR 20.14 200 -SEWER 10.31 350 -STAX 5.90 200 -SEWER 2.85 78.93 200 -SEWER 0.36 400 - RECYCL 42.03 200 -SEWER 1.59 400 - RECYCL 30.19 200 -SEWER 0.88 400 - RECYCL 40.45 200 -SEWER 1.35 400 - RECYCL 40.16 200 -SEWER 13.85 350 -STAR 11.21 200 -SEWER 2.65 350 -STAX 88.47 200 -SEWER 23.00 350 -STAX 66.39 17.92 200 -SEWER 8.23 350 -STAR 21.72 200 -SEWER 0.72 400- RECYCL 668.89 200 -SEWER 24.97 350 -STAX 1.60 10.11 200 -SEWER 0.43 400 - RECYCL 70.52 200 -SEWER 22.72 350 -ST.AX 12.40 21.75 300 - GARBAG 1.99 500 - PENALT 13.16 300 - GARBAG 0.86 25.29 204- DRAINA 0.71 400 - RECYCL 29.68 204- DRAINA 0.85 400- RECYCL 5.866 300 - GAR13AG 5.93 300 - GARBAG 0.71 27.43 300 - GARBAG 3.18 500- PENALT 18.97 300 - GARBAG 1.74 500 - PENALT 9.31 300 - GARBAG 2.68 500- PENALT 266.42 204- DRAINA 1.15 400 - RECYCL 6.11 204- DRATNA 0.22 400 - RECYCL 41.94 204- DRAINA 1.90 400- RECYCL 17.669 204 - DRAINA 0.668 40C- RECYCL 24.40 300- GARBAG 1.43 500- PENALT 42.43 204- DRAINA 2.06 400 - RECYCL 7.00 300 - GARBAG 0.85 18.28 204 - DRAINA 1.88 400 - RECYCL PAGE: 5 12.09 1.86 5.19 2.88 1.42 0.668 1.669 34.46 4.32 19.27 4.35 10.57 0.08 16.31 2.41 4.63 2.28 0.89 0.44 3.666 3.78 2.75 1.35 8.68 2.44 7.99 4.11 5.16 7.60 3.74 01 -18 -2013 12:56 PM W A I T E O F F A U D I T R E G I S T E R PAGE: 6 G/L POSTING DATE: 1/18/2013 ** TRANSFER TO BAD DEBT *T PACKET: 42683 POSTING TYPE: BOTH COMMENT CODE: BDEBT -BAD DEBT ACCOUNT FLAG ACCOUNT: NO ENO OF REPORT -- BALANCE ACCOUNT NO ==_=== ------ NAME ___________= LAST BILL 50- 4710 -05 -0 GUTIERREZ, DOLORES 135.54 100 -WATER 67.19 200 -SEWER 41.85 300 - GARBAG 16.64 ** LAST PAYMENT MADE: 1/10/2012 3/09/2012 350 -STAX 1.38 400 - RECYCL 2.74 500 - PENALT 5.74 50- 6070 -01 -0 PIETRE', AUDREY 107.42 100 -WATER 46.74 200-SEWER 26.14 300- GARBAG 14.24 s. LAST PAYMENT 14ADE: 2/06/2012 6/09/2012 350 -STAX 1.18 400 - RECYCL 2.34 500- PENALT 16.78 50- 6370 -03 -0 HUNTER, RONALD 87.08 100 -WATER 50.19 200 -SEWER ----------------------------- 14.29 300- GARBAG 15.92 ** LAST PAYMENT MADE: 4/10/2012 6/09/2012 350 -STAX 1.32 400- RECYCL 2.62 500- PENALT 2.74 50- 6840 -03 -0 WILLIAMS, RANDY L 62.10 100 -WATER 26.93 200 -SEWER 20.40 300 - GARBAG 11.78 '* LAST PAYMENT MADE: 3/07/2012 4/09/2012 350 -STAR 0.97 400 - RECYCL 1.94 500- PENALT 0.08 51- 0004 -01 -0 GOMES, MARGO 45.00 100 -WATER 39.75 200 -SEWER - --------------- 0.91 --- - -- 204- DRAINA 0.92 �* LAST PAYMENT MADE: 3/29/2012 4/09/2012 300- GARBAG 2.74 350 -STAX 0.23 400- RECYCL 0.45 .,_- 0512 -04 -0 PEREZ, LUIS M 87.88 100 -WATER 42.62 200 -SEWER 21.90 300 - GAR9AG 15.83 ** LAST PAYMENT MADE: 4/06/2012 6/09/2012 350 -STAX 1.32 400- RECYCL 2.61 500- PENALT 3.60 51- 1250 -01 -0 HALL, MARY 76.17 100 -WATER 30.42 200 -SEWER 17.10 204- DRAINA 6.06 ** LAST PAYMENT MADE: 4/17/2012 6/09/2012 300- GARBAG 18.11 350 -STAX 1.50 400- RECYCL 2.98 _ -_- 1540 -04 -0 HCGAN III, FRANK 29.11 100 -WATER 15.08 200 -SEWER 8.02 300 - GARBAG 4.82 ** LAST PAYMENT MADE: 1/26/2012 3/09/2012 350 -STAX 0.40 400 - RECYCL 0.79 51- 1724 -01 -0 RIVETTO, MICHAEL 95.13 100 -WATER 43.73 200 -SEWER 15.46 204- DRAINA 7.60 *' LAST PAYMENT MADE: 4/24/2012 6/09/2012 300- GARBAG 22.72 350 -STAX 1.88 400- RECYCL 3.74 _ -- 1798 -06 -0 RODRIGUEZ, VICTORIA 116.92 100 -WATER 66.08 200 -SEWER 24.73 300 - GARBAG 17.34 ** LAST PAYMENT MADE: 1/13/2012 3/09/2012 350 -STAX 1.43 400- RECYCL 2.85 500 - PENALT 4.49 31- 1932 -01 -0 LOVE, TODD 65.10 100 -WATER 22.83 200 -SEWER 20.82 204 - DRAINA 4.54 ** LAST PAYMENT MADE: 5/23/2012 7/09/2012 300 - GARBAG 13.56 35C -STAX 1.12 400- RECYCL 2.23 36- 1188 -01 -0 GRINNELL, MONIQUE E 52.08 100 -WATER 25.27 200 -SEWER 11.11 300 - GARBAG 12.58 *s LAST PAYMENT MADE: 6/04/2012 5/28/2012 350 -STAX 1.04 400- RECYCL 2.06 "TOTALS ** NUMBER OF ACCOUNTS: 96 10,436.50 100 -WATER 5,303.16 152 -PAST D 148.68 200 -SEWER 2,467.42 204 - DRAINA 141.58 300 - GARBAG 1,552.00 314 -NSF FE 20.00 316- EXTENS 16.51 350-ST-AX 128.33 400 - RECYCL 219.94 500- PENALT 438.68 ACCOUNT SCUACE NAME AMOUNT 202- 000 - 119000 Accounts Receivable - Customer 10,294.92CR 202- 000 - 119100 Allowance for Had Debt 10,294.92 204- 000 - 119000 Accounts Receivable - Customer 141.58CR 204- 000 - 119100 Allowance for Bad Debt 141.58 'IARMINGS: U ERRORS: 0 ENO OF REPORT --