Loading...
HomeMy WebLinkAbout02 RATIFICATION OF DEMANDS & PAYROLL 11-20-07MEETING DATE TO: FROM: SUBJECT: AGENDA REPORT NOVEMBER 20, 2007 WILLIAM A. HUSTON, CITY MANAGER RONALD A. NAULT, FINANCE DIRECTOR RATIFICATION OF DEMANDS Agenda Item 2 Reviewed: City Manager Finance Directo`�w SUMMARY: The City Council has approved the use of Government Code Section 37208 to expedite the payment of City of Tustin and Tustin Community Redevelopment Agency obligations that are in accordance with the approved budget or continued operations authorizations. RECOMMENDATION: Confirm and approve as submitted the following listing of demands issued on behalf of the City and the Tustin Community Redevelopment Agency in accordance with Government Code Section 37208. Type of Listing Date/Total Amount Accounts Payable NOVEMBER 2, 2007 WARRANT RUN $ 923,435. 4 EFT $ 8 824.0 Total $ 932,259. Exceptions: NONE AFFIDAVIT OF DEMANDS In accordance with Government Code Section 37208, I , reby certify that the referenced demands conform to the approved budget except as o d and have beeyn paid. These demands are h reby submitted to the City Council for your i spe o onf ati . A/l/a Date: �irector of Financ DISCUSSION: In September of 1972, the City Council approved the use of Government Code Section 37208 which expedites payment of City payroll and accounts payable obligations which are in accordance with an approved budget. Under this procedure, each purchase is reviewed at the time of purchase and the invoice is reviewed by the Finance Department prior to payment to insure that it conforms to the approved budget. The City Council/Agency is then provided a listing at each Council meeting of the payroll and general warrants issued since the last report so that it can ins Z/1' and confirm these warrants. Date: ,ZReviewed By: it Treasurer r MEETING DATE: TO: FROM: SUBJECT: gym NOVEMBER 20, 2007 WILLIAM A. HUSTON, CITY MANAGER RONALD A. NAULT, FINANCE DIRECTOR RATIFICATION OF DEMANDS Agenda Item Reviewed: City Manager Finance Director SUMMARY: The City Council has approved the use of Government Code Section 37208 to expedite the payment of City of Tustin and Tustin Community Redevelopment Agency obligations that are in accordance with the approved budget or continued operations authorizations. RECOMMENDATION: Confirm and approve as submitted the following listing of demands issued on behalf of the City and the Tustin Community Redevelopment Agency in accordance with Government Code Section 37208. Type of Listing Date/Total Amount Accounts Payable NOVEMBER 9, 2007 WARRANT RUN $ 650,661.2 EFT $ 78.4 Total $ 650,739.6 Exceptions: NONE AFFIDAVIT OF DEMANDS In accordance with Government Code Section 37208, 1 hereby certify that the referenced demands conform to the approved budget except as noted and have been paid. These demands are hereby submitted to the City Council for your inspection an confirmation. Date: Director of Fi7fance DISCUSSION: In September of 1972, the City Council approved the use of Government Code Section 37208 which expedites payment of City payroll and accounts payable obligations which are in accordance with an approved budget. Under this procedure, each purchase is reviewed at the time of purchase and the invoice is reviewed by the Finance Department prior to payment to insure that it conforms to the approved budget. The City Council/Agency is then provided a listing at each Council meeting of the payroll and general warrants issued since the last report so that it can. in pect and confirm these warrants. Date: / C> Review ty Treasurer MEETING DATE: NOVEMBER 20, 2007 TO: WILLIAM A. HUSTON, CITY MANAGER FROM: RONALD A. NAULT, FINANCE DIRECTOR SUBJECT: RATIFICATION OF DEMANDS SUMMARY: The City Council has approved the use of Government Code Section 37208 to expedite the payment of City of Tustin and Tustin Community Redevelopment Agency obligations that are in accordance with the approved budget or continued operations authorizations. RECOMMENDATION: Confirm and approve as submitted the following listing of demands issued on behalf of the City and the Tustin Community Redevelopment Agency in accordance with Government Code Section 37208. Type of Listing Accounts Payable Exceptions: Date/Total Amount OCTOBER 31, 2007 NONE AFFIDAVIT OF DEMANDS Reversals $257,061.99 In accordance with Government Code Section 37208, 1 h reby certify that the referenced demands conform to the approved budget except as no and have been 9GId. These demands are herjeW submitted to the City Council for your pecti a m i n. Date: il,161 ector of Finance DISCUSSION: In September of 1972, the City Council approved the use of Government Code Section 37208 which expedites payment of City payroll and accounts payable obligations which are in accordance with an approved budget. Under this procedure, each purchase is reviewed at the time of purchase and the invoice is reviewed by the Finance Department prior to payment to insure that it conforms to the approved budget. The City Council/Agency is then provided a listing at each Council meeting of the payroll and general warrants issued since the last report so that it can inspec and confirm these warrants. Date: 6.7 Reviewed ity r surer AGENDA REPORT MEETING DATE: November 20, 2007 TO: WILLIAM A. HUSTON, CITY MANAGER FROM: RONALD A. NAULT, FINANCE DIRECTOR SUBJECT: RATIFICATION OF PAYROLL Agenda Item Reviewed: City Manager Finance Director SUMMARY: The City Council has approved the use of Government Code Section 37208 to expedite the payment of City of Tustin and Redevelopment Agency obligations that are in accordance with the approved budget or continued operations authorization. RECOMMENDATION: Confirm and approve as submitted the following Payroll listing in accordance with Government Code Section 37208. Type of Listing Date Total Amou t Payroll 11/02/2007 $642,605.24 Exceptions: AFFIDAVIT OF PAYROLL In accordance with Government Code Section 37208, 1 hereby certify that the referenced Payroll listing conforms to the approved budget exceit as noted and has been paid. Date: �� D D-irector-ok Finance DISCUSSION: In September of 1972, the City Council approved the use of Government Code Section 37208 which expedites payment of City Payroll which is in accordance with an approved budget. Under this procedure, each Payroll is reviewed by the Finance Department prior to payment to insure that it conforms to the approved budget. The City Council is then provided a listing at each Council meeting of the Payrolls issued since the last report so that it may inspect and confirm their payments. Date: C)7 Reviewed By: City Treasurer City of Tustin THU, NOV 01, 2007, Check Payee ID. 11/01/07 0 H 8:17 AM --req: TBERARDI--leg: GL Payee Name C H E C JL--loc: Date K R E G I S T E R CHECK REGISTER Page TUSTIN ---- job: 269581 #S020----prog: BK200 cl.23>--report id: CKREG--1 Check Amount Type Subs Rel To Note AP00111052✓'V16457 A -LAM -COR 11/02/07 1,212.75 MW OH ---_ AP00111053 V13340 ADVANCED SECURITY PRODUCTS 11/02/07 580.48 MW OH AP00111054 V13441 AFLAC FLEX ONE 11/02/07 3,433.25, --MW OH AP00111055�V13719 ALL AMERICAN BALLOON SUPPLY 11/02/07 57.88 MW OH AP00111056 !V11932 ALL CITY MANAGEMENT SERVICES 11/02/07 20,365.15 MW OH AP00111057 413671 ALVES, SANDY 11/02/07 29.00 MW OH EX AP00111058IV16258 ANDERSON, GENEVIEVE 11/02/07 56.00 MW OH EX AP001110591VO0331 AP00111060�1611 AP0011106� V13164 ANSWER CALIFORNIA ARAMARK UNIFORM SERVICES AT&T/MCI 11/02/07 11/02/07 11/02/07 228.10 MW 53.20 MW 17,066.29 --MW OH OH OH AP00111062 V14250 AZZARA'S GOURMET CATERING 11/02/07 630.33 MW OH AP00111063 V16454 BRYCE, MARYLYNN 11/02/07 75.00 MW OH AP00111064 D00902 CALIFORNIA HEART CONNECTION 11/02/07 150.05 MW OH AP00111065 V00633 CALIFORNIA POLICE CHIEFS ASSO 11/02/07 125.00 MW OH AP001110i66 V02068 CALIFORNIA PUBLIC EMPLOYEES 11/02/07 209,284.5-V'MW OH AP00111067 V11228 CARROLL, WILLIAM J 11/02/07 150.00 MW OH AP00111068 V00557 COUNTY OF ORANGE 11/02/07 116,959.23.MW OH AP00111069 V14709 CSG CONSULTANTS INC 11/02/07 4,762.50, -MW OH AP0011107QAV12518 DEFRUITER, CHUCK 11/02/07 101.20 MW OH AP00111071 V00944 DELL MARKETING LP 11/02/07 6,877.1 Y MW OH AP00111072 V11435 DEPARTMENT OF JUSTICE 11/02/07 162.00 MW OH AP0011107� V14294 DLT SOLUTIONS INC 11/02/07 1,467.80 MW OH City of Tustin THU, NOV 01, 2007, 11/01/07 0 H 8:17 AM --req: TBERARDI--Ieg: GL C H E C JL--loc: K R E G I S T E R CHECK REGISTER Page 2 TUSTIN----job: 269581 #S020 ---- prog: BK200 <1.23> --report id: CKREG--- Check Payee ID. --------- AP00111074((-V12344 Payee Name -------- -------- - Date -- Check Amount Type -____ Subs Rel To Note DONAHUE & COMPANY INC 11/02/07 9,275.E -MW _____ OH - AP001110751V11661 DOOLEY ENTERPRISES INC 11/02/07 630.34 MW OH AP00111076 V01073 ECONOLITE CONTROL PRODUCTS IN 11/02/07 16,244.39 MW OH AP00111077 V01055 ENTENMANN-ROVIN CO 11/02/07 103.85 MW OH AP00111078 V13742 FALCO ENTERPRISES INC 11/02/07 400.79 MW OH AP00111079 V01525 G W JEFFRIES & ASSOCIATES INC 11/02/07 4,000.00, MW OH AP00111080X00033 GALLAGHER, ALAN 11/02/07 350..000 MW OH AP0011108� V02648 GALLS/LB UNIFORM CO 11/02/07 381.21 MW OH AP00111082 V16455 GIDDINGS, STEVE 11/02/07 64.02 MW OH EX AP00111083 V01198 GOLDEN WEST COLLEGE 11/02/07 2,910.0 fMW OH AP00111084 V00081 GORA, DAVID 11/02/07 150.00 MW OH AP00111085 V00281 GRASSINI, FABIAN 11/02/07 7,454.20_,,4W OH AP00111086 V13702 HANSON, JAMI LOU 11/02/07 126.00 MW OH AP00111087 V15946 HARLEY-DAVIDSON OF FULLERTON 11/02/07 77.26 MW OH AP00111088 V01330 HARTZOG & CRABILL INC. 11/02/07 14,815.00 Iw OH AP00111089 V11238 HAWKINS, MONYA F 11/02/07 74.10 MW OH AP00111090X01307 HUNTINGTON BEACH, CITY OF 11/02/07 110.00 MW OH AP00111091 V01459 I INITIAL 11/02/07 45.26 MW OH AP00111092 V14176 I T ASSOCIATES INC 11/02/07 6,107.51 --MW OH AP00111093 V16112 INTERWEST CONSULTING GROUP 11/02/07 10,025.50 My OH AP00111094 V01418 AP0011109� IRVINE RANCH WATER DISTRICT 11/02/07 188.89 MW OH v14366 JACOBS INC 11/02/07 8835.33 W 88,835.33,,14'w' OH City of Tustin THU, NOV 01, 2007, 11/01/07 0 H 8:17 AM --req: TBERARDI--leg: GL C H E C JL--loc: K R E G I TUSTIN----job: S T E R CHECK REGISTER Page 3 269581 #SO20---- prog: BK2O0 <1.23> --report id: CKREG--- Check Payee ID. AP0011109 VO1542 AP00111097)V09502 Payee Name KIPLINGER LETTER THE LAND FORMS LANDSCAPE CONSTRUC Date 11/02/07 11/02/07 Check Amount 89.00 62,605.13, Type MW --MW Subs Rel To Note OH ----- OH APOO111O98 VO1676 LINARES, MIKE 11/02/07 2,775.00 MW OH AP00111O99 V01639 APO01111O0�/VO1645 LOS ANGELES TIMES LUTZ, AUGUSTUS 11/02/07 11/02/07 35.88 101.20 MW MW OH OH APO01111O1)VO1727 MCCANTS, LAURA 11/02/07 656.90 MW OH AP00111102,V01841 MCFADDEN-DALE IND HARDWARE CO 11/02/07 139.32 MW OH AP00111103;V00188 MEDER, BRYAN 11/02/07 150.00 MW OH APO01111O4 VO1823 APO01111O5VOO134 MERRIMAC ENERGY GROUP MIRARCHI, JOHN 11/02/07 11/02/07 22,577.01 MW 150.00 MW OH OH APOO1111O6 VOO122 MORS, GAIL 11/02/07 169.20 MW OH AP001111O7 V01894 NATIONAL EMERGENCY NUMBER 11/02/07 120.00 MW OH AP001111O8 V15279 APOO1111O9�4183 NGUYEN, FAWN NOVAPRO RISK SOLUTIONS LP 11/02/07 11/02/07 400.00 75.00 MW MW OH EX OH APOO11111O,111834 OCNOA 11/02/07 75.00 MW OH APO011111'h VO1999 OCTA 11/02/07 410.29 MW OH APOO111112;VO0191 OHMAN, JANICE 11/02/07 150.00 MW OH AP00111113V15864 ORTIZ, RUBY 11/02/07 57.05 MW OH EX AP00111114'D01094 PAYNE, CARRIE 11/02/07 150.00 MW OH APOO111115 V14213 PR DIAMOND PRODUCTS INC 11/02/07 428.00 MW OH AP -00111116 V13066 PRINT TO MAIL/PTM DOCUMENT SY 11/02/07 114.66 MW OH AP0011111¢jV16266 PUBLIC RELATIONS SOCIETY OF A 11/02/07 30.00 MW OH City of Tustin 11/01/07 0 H C H E C K . R E G I S T E R CHECK REGISTER THU, NOV 01, 2007, 8:17 AM --req: TBERARDI--leg: GL JL--loc: Page 4 TUSTIN ---- job: 269581 #S020 ---- prog: BK200 0.23> --report id: CKREG--- Check Payee ID. Payee Name Date Check Amount Type Subs Rel To Note AP0011111�02166====== RED WING SHOE 'YP_ STORES 11/02/07 112 06 MW OH AP00111119 V15779 REPUBLIC ITS 11/02/07 6,920.00, --MW OH AP0011112g/'*V'00193 REYES, BARBARA 11/02/07 169.20 MW OH AP0011112� V16456 SAN DIEGO ASSOCIATION OF PUBL 11/02/07 50.00 MW OH AP00111122 D00951 SEIKO POOLS 11/02/07 3,000.00e -"MW OH AP00111123 V16360 SENDIO INC 11/02/07 12,249.61 ,MW OH AP00111124 V12592 SHAVER, JOAN 11/02/07 101.20 MW OH AP00111125 V16071 SHAW STRATEGIC SOLUTIONS GROU 11/02/07 129,272.32,,, -NW OH AP00111126 V02658 SIGNATURE PARTY RENTALS 11/02/07 311.76 MW OH AP00111127 V02512 SILICONAVE.COM 11/02/07 2,117.50 MW OH AP00111128 V16137 SO CAL SANDBAGS INC 11/02/07 4,038.80. --MW OH AP00111129 V07379 SPECTRUM CARE LANDSCAPE 11/02/07 52,456.00' MW OH AP00111130/02266 STANDARD INSURANCE CO 11/02/07 1,441.20 MW OH AP00111131 V12485 STANDARD INSURANCE COMPANY 11/02/07 14,992.87 .,MW OH 1 AP00111132 V13763 STAPLES INC 11/02/07 993.37 MW OH AP00111133 V13453 STATE COMPENSATION INSURANCE 11/02/07 4,977.65✓ --MW OH AP00111134 V15854 STATE DISBURSEMENT UNIT 11/02/07 1,986.67 MW OH AP00111135 V00539 SUNGARD BI -TECH SOFTWARE INC 11/02/07 750.00 MW OH AP00111136 V12755 TASER INTERNATIONAL 11/02/07 50.00 MW OH AP00111137 V16115 THE LAW OFFICES OF MARK A WAS 11/02/07 7,338.24,,4w' OH AP00111138 V02555 TOTAL IMAGE PRINTING 11/02/07 106.68 MW OH AP00111139 V02545 TUSTIN AUTO WASH 8 76 GAS STA 11/02/07 118.67 MW OH City of Tustin 11/01/07 0 H C H E C K R E G I S T E R THU, NOV 01, 2007, 8:17 AM --req: TBERARDI--leg: GL JL--loc: CHECK REGISTER Page 5 TUSTIN----job: 269581 #SO2O---- BK2OO prog: 0.23>--report id: CKREG--- Check Payee ID. AP 140 Payee Name Date Check Amount Type Subs Rel To Note 02577 TUSTIN AWARDS 11/02/07 117.29 MW ON ---- AP00111141 [)01009 TUSTIN CORPORATE CENTER LLC 11/02/07 3,000.00/MW ON APOO111142 VO2267 TUSTIN IRVINE MEDICAL GROUP 11/02/07 403.66 MW ON MH AP00111143V02546 TUSTIN LOCK AND SAFE INC 11/02/07 85.66 MW ON APOO111144 VO2553 TUSTIN MUNICIPAL EMPLOYEE ACC 11/02/07 1,133.00 MW ON APOO111145 VO2537 TUSTIN POLICE OFFICERS ASSOC 11/02/07 3,846.37-MW ON APOO111146 VO264O TUSTIN POLICE SUPPORT SERVICE 11/02/07 693.00 MW ON APOO111147 VO9647 TUSTIN PUBLIC SCHOOLS 11/02/07 5,000.00/MW ON APOO111148 V15O98 UNITED RENTALS NORTHWEST INC 11/02/07 297.39 MW ON APOO111149 V02672 URBAN LAND INSTITUTE 11/02/07 20.00 MW ON APOO11115 V02655 US POSTMASTER 11/02/07 4,217.63,/MW ON APOO111151(VOOOO8 VALLEVIENI, GEORGE 11/02/07 150.00 MW ON. APOO111152''V118O1 VERIZON WIRELESS 11/02/07 8,486.97 BMW ON APOO111153V14148 VERTEX COMMUNICATIONS 11/02/07 1,188.57 MW ON AP00111154V15497 VINCI, SUE' 11/02/07 58.50 MW ON APOO111155 V11O5O i VULCAN MATERIALS COMPANY 11/02/07 2,332.92 MW ON APOO111156, V11662 WC FRIEND COMPANY INC 11/02/07 189.64 MW ON APOO111157 VO0O92 WELLER, RALPH EDWARD 11/02/07 150.00 MW ON APOO111156 V02755 WELLS SUPPLY CO 11/02/07 1,254.21 MW,. ON APOO111159 VO2752 WILLDAN ASSOCIATES 11/02/07 3,920.00 Aw ON APOO11116, 158O2 WILLUMSON„ DIANE 11/02/07 169.20 MW ON APOO111161 V12132 WILSON, DAVID 11/02/07 546.73 MW ON EX City of Tustin 11/01/07 0 H C H E C K R E G I S T E R CHECK REGISTER Page 6 THU, NOV 01, 2007, 8:17 AM --req: TBERARDI--leg: GL JL--loc: TUSTIN----job: 269581 #S020----prog: BK200 <1.23> --report id: CKREG--- Check Payee ID. Payee Name Date Check Amount Type Subs Rel To Note AP00111162 V02773====== WIN/WIN PROMOTIONS LLC=_===_= 11/02/07 =====4=,966_===50 MW OH ` _ __-___ ------"--"'--- S U B T 0 T A L S: Total Void Machine Written 0.00 Number of Checks Processed: 0 Total Void Hand Written 0.00 Number of Checks Processed: 0 Total Machine Written 923,435.13 Number of Checks Processed: 111 Total Hand Written 0.00 Number of Checks Processed: 0 Total Reversals 0.00 Number of Checks Processed: 0 Total Cancelled 0.00 ,Number of Checks Processed: 0 S U B T O T A L923,435.13 City of Tustin THU, NOV 01, 2007, 11/01/07 0 H 8:17 AM --req: TBERARDI--leg: GL C H E C JL--loc: K R E G I TUSTIN----job: S T E R CHECK REGISTER Page 7 269581 #S020 ---- prog: BK200 <1.23> --report id: CKREG --- Check Payee ID. ---------------------- Payee Name -------------------------- Date Check Amount Type Subs Rel To Note EP 16 V16160 ---- ---- ------ ------------------------- ----------------------- ALLEN, RICHARD11/02/07 169.20 CX ---------- OH EP00000169 V11855 BAKHTIARI, NANCY 11/02/07 150.00 CX OH EP00000179/,'V00009 BERGOUIST, MARK 11/02/07 250.00 CX OH EP00000171 V12688 BOUTON, TOM 11/02/07 101.20 CX OH EP00000172 V00094 BRANDT, GLORIA 11/02/07 169.20 CX OH EP00000173 V15955 CAMPBELL, CAROLYN 11/02/07 169.20 CX OH EP00000174 V00053 CARVAJAL, CHARLES 11/02/07 150.00 CX OH EP00000175 V00079 CORREA, BETTIE 11/02/07 250.00 CX OH EP00000176 V00067 CRABILL, VALERIE 11/02/07 200.00 CX OH EP00000177 V02888 CRANE, CHARLES 11/02/07 200.00 CX OH EP00000178 V02646 DAVIDER, LINDA 11/02/07 169.20 CX OH EP00000179 V13917 DELAMETER, MARVIN 11/02/07 150.00 CX OH EP0000018 VV00934 DRAUGHON, JAMES A 11/02/07 350.00 CX OH EP0000018T V00010 ELLETT, EDWIN 11/02/07 269.20 CX OH EP00000182 V00005 FISHER, WILLIAM 11/02/07 250.00 CX OH EP00000183 V00022 FOSTER, STEVE 11/02/07 300.00 CX OH EP00.000184 V00071 FRANKS, W DOUGLAS 11/02/07 200.00 CX OH EP00000185 V02821 GARVIN, LAURA 11/02/07 169.20 CX OH EP00000186 V04043 HALL, PEGGY 11/02/07 169.20 CX OH EP00000187 V14227 HAZARD, TALBOT 11/02/07 300.00 CX OH EP00000188 V00170 HOWARD, DOUGLAS 11/02/07 269.20 CX OH EP00000189 V00013 KREYLING, DAVID 11/02/07 250.00 CX OH City of Tustin THU, NOV 01, 2007, 11/01/07 0 H 8:17 AM --req: TBERARDI--leg: GL C H E C K R E G I JL--Loc: TUSTIN----job: S T E R CHECK REGISTER Page 8 269581 #S020---- prog: BK200 0 .23>--report id: CKREG--- Check Payee ID. Payee Name Date Check Amount Type Subs Rel To Note ----------------- EP V00028 LEDENDECKER, ROBERT 11/02/07 150.00 CX --------------- OH EP0000019�1 V12668 OTTESON, GERALD 11/02/07 150.00 CX OH EP00000192 V12220 PAGE, BILL FRED 11/02/07 250.00 CX OH EP00000193 V00102 PEERY, JAMES 11/02/07 269.20 CX OH EP00000194 V00074 POSPISIL, KATHY 11/02/07 150.00 CX OH EP00000195 V00153 RUANE, CAROL 11/02/07 150.00 CX OH EP00000196 V07423 SANCHEZ, PATRICK 11/02/07 350.00 CX OH EP0000019.7 V00018 SCHOENKOPF, ROBERT 11/02/07 300.00 CX OH EP0000019$ V00017 SEMELSBERGER, FRANCIS 11/02/07 300.00 CX OH EP00000198 V00019 SHANAHAN, MICHAEL 11/02/07 350.00 CX OH EP0000020 Q'`V02619 TOOHEY, BILL 11/02/07 150.00 CX OH EP00000201 V11782 VEER, GARY R 11/02/07 200.00 CX OH EP00000202 V00004 WAKEFIELD, FREDERICK 11/02/07 300.00 CX OH EP00000203 V00044 WEDEMEYER, WALT 11/02/07 200.00 CX OH EP00000204 V00080 WESTFIELD, RITA 11/02/07 250.00 CX OH EP00000205 V03918 WILCOX, ROBERT 11/02/07 200.00 CX OH EP00000206 V00003 WILLIAMS, HOUSTON 11/02/07 200.00 CX OH EP00000207 V00020 ZICARELLI, BRENT 11/02/07 250,00 CX OH City of Tustin 11/01/07 0 H C H E C K R E G I S T E R CHECK REGISTER Page THU, NOV 01, 2007, 8:17 AM --req: TBERARDI--leg: GL JL--loc: TUSTIN----job: 269581 #S020----prog: BK200 <l.23> --report id: CKREG--9 Check Payee ID. Payee Name Date Check Amount Type Subs Rel To Note -------- -------- ------------- ------ ---- ---- ---- ------ ------------------- B T O T A L S: --- - -- Total Void Machine Written 0.00 Number of Checks Processed: 0 Total Void Hand Written 0.00 Number of Checks Processed: 0 Total Machine Written 0.00 Number of Checks Processed: 0 Total Hand Written 0.00 Number of Checks Processed: 0 Total Reversals 0.00 Number of Checks Processed: 0 Total Cancelled 8,824.0 Number of Checks Processed: 4 S U B T 0 T A L 8,824.0 City of Tustin 11/01/07 0 H C H E C K R E G I S T E R CHECK REGISTER Page 10 THU, NOV 01, 2007, 8:17 AM --req: TBERARDI--leg: GL JL--loc: TUSTIN----job: 269581 #S020 ---- prog: BK200 <1.23> --report id: CKREG--- Check Payee ID. Payee Name Date Check Amount Type Subs Rel To Note ------------- ---- ---- - ____------------- -- - G R R A N D T 0 T A L S: Total Void Machine Written 0.00 Number of Checks Processed: 0 Total Void Hand Written 0.00 Number of Checks Processed: 0 Total Machine Written 923 435.13 Number of Checks Processed. 111 Total Hand Written 0.00 Number of Checks Processed: 0 Total Reversals 0.00 Number of Checks Processed: 0 Total Cancelled 8,824.00 Number of Checks Processed: 40 G R A N D T 0 T A L 932, 259. 1 J 7 City of Tustin 11/08/07 0 H C H E C K R E G I S T E R CHECK REGISTER Page 1 THU, NOV 08, 2007, 9:50 AM --req: TBERARDI--leg: GL JL--loc: TUSTIN----job: 269976 #S020 ---- prog: BK200 <1.23> --report id: CKREG--- CheckP�'yee_ID__-_ Payee Name Date Check Amount Type Subs Ret To Note______-_____-_-__---_-_--__-______ AP00111163 V13102 AFLAC 11/09/07 30220.72 ,MW OH AP00111164 V00562 AMERICAN ROTARY BROOM CO INC 11/09/07 239.69 MW OH AP00111165 V11152 ANDERSON & HOWARD ELECTRIC IN 11/09/07 150.00 MW OH AP00111166 V15940 ANDREN, MICHAEL 11/09/07 72.00 MW OH AP00111167 V14863 APEX DRUM CO INC 11/09/07 743.05 MW OH AP00111168 V00330 ARAMARK CORPORATION 11/09/07 90.00 MW OH AP00111169 V16062 ARROWHEAD WATER 11/09/07 45.47 MW OH AP0011117VV00059 AT&T 11/09/07 361.71 MW OH AP00111171'V13030 B & M LAWN & GARDEN INC 11/09/07 4,909.09 ---M--W OH AP00111172 V00444 BEE MAN, THE 11/09/07 150.00 MW OH AP00111173 V15618 BILL'S BODY WORKS INC 11/09/07 18'873.09 MW OH AP00111174 V00254 BISHOP COMPANY 11/09/07 11423.04 MW OH AP00111175 V01052 BOB HICKS TURF EQUIPMENT CO 11/09/07 12,121.44 /'MW OH AP00111176 V00564 CALIFORNIA PARK & RECREATION 11/09/07 270.00 MW OH AP00111177 V02020 CALIFORNIA PUBLIC EMPLOYEES 11/09/07 187,477.97,,e/MW OH AP00111178 V12894 CARMEN'S UNIFORMS INC 11/09/07 641.82 MW OH AP00111179 V00563 CHEVRON & TEXACO CARD SERVICE 11/09/07 1,652.39 MW OH AP00111180,1�02179 CLASSIC PARTY RENTALS 11/09/07 634.99 MW OH AP00111181 V16459 COLE, DAVID 11/09/07 59.21 OH EX COLONIAL LIFE & ACCIDENT 11/09/07 %MV AP00111182 V00709 INS 5,652.72 MW ON AP00111183 00559 CONSOLIDATED REPROGRAPHICS 11/09/07 385.15 MW OH AP001111 V16069 COPY INC 11/09/07 88.65 MW OH City of Tustin 11/08/07 0 H C H E C K R E G I S T E R CHECK REGISTER Page 2 THU, NOV 08, 2007, 9:50 AM --req: TBERARDI--Ieg: GL JL --Loc: TUSTIN----job: 269976 #SO20---- prog: BK200 <1.23> --report id: CKREG--- Check ID. Payee Name Date Check Amount Type Subs Rel To Note -Payee ==== ====22 AP0011118g V005' 7'5 COUNTY OF ORANGE 11/09/07 398.001""MW OH= AP001111861V13174 COURT CLEAN 11/09/07 116.66 MW OH AP0011118T V12127 CRAIG, DAVID 11/09/07 72.00 MW OH AP00111188 V12775 CRANE ARCHITECTURAL GROUP 11/09/07 8,446.581-. OH AP00111189 V11635 CRAWFORD, JOHN 11/09/07 72.00 MW OH AP00111190.1I00699 CREATIVE MANAGEMENT SOLUTIONS 11/09/07 1,040.00 MW OH AP00111191)V16290 CSUF 11/09/07 9,800.00,A W OH AP00111192 V15868 DANG-LIBUNAO, HY 11/09/07 37.41 MW OH EX AP00111193 V00900 DEKRA-LITE 11/09/07 1,434.02 MW OH AP00111194 V16460 DELGADO, LORI 11/09/07 75.00 MW OH AP00111195 V00944 DELL MARKETING LP 11/09/07 8,564.39/MW OH AP00111196 V15530 DELTA DENTAL 11/09/07 11,673.91,,/(IW OH AP00111197 V15528 DELTACARE USA 11/09/07 2,741.53 MW OH AP00111198 V00915 DON'S LAWNMOWER SHOP INC 11/09/07 30.54 MW OH AP00111199 V11689 DUKE SERVICE CO 11/09/07 189.95 MW OH AP00111200/V12621 DURHAM SCHOOL SERVICES 11/09/07 330.32 MW OH AP00111201 V01068 EAST ORANGE COUNTY WATER DIST 11/09/07 482.96 MW OH AP00111202 V01120 FEDEX CORP 11/09/07 11.35 MW OH AP00111203 V00030 FERGUSON WATERWORKS #1082 11/09/07 661.53 MW OH AP00111204 V115485 FOX, JOE ANN 11/09/07 200.00 MW OH AP00111205 115644 FUN WITH HORSES 11/09/07 234.00 MW OH AP00111206 V15787 FUSCOE ENGINEERING INC 11/09/07 5,497.50,,*W OH City of Tustin 11/08/07 0 H C H E C K R E G I S T E R CHECK REGISTER Page 3 THU, NOV 08, 2007, 9:50 AM --req: TBERARDI--leg: GL JL--loc: TUSTIN----job: 269976 #S020 ---- prog: BK200 <1.23> --report id: CKREG--- Check Payee ID. Payee Name Date Check Amount Type Subs Rel To Note V 2648====== =OH_ AP0011120.7 GALLS/LB UNIFORM CO========== 11/09/07 77.47 MW AP0011120& V01233 GCR PARAMOUNT TRUCK TIRE CTR 11/09/07 11011.38 MW OH AP00111209 V15037 GLOBALSTAR USA 11/09/07 54.09 MW OH AP0011121 q/h1198 GOLDEN WEST COLLEGE 11/09/07 400.95 MW OH AP00111211IV01314 HAAKER EQUIPMENT CO 11/09/07 886.46 MW OH AP00111212'V01321 HOME DEPOT CREDIT SERVICES 11/09/07 263.14 MW OH AP00111213 V01350 HOME DEPOT CREDIT SERVICES 11/09/07 80.46 MW OH AP00111214 V01332 HUEBNER, ELIZABETH 11/09/07 1,014.00 MW OH AP00111215 V01301 HYDRO-SCAPE PRODUCTS INC 11/09/07 350.19 MW OH AP00111216 V01441 INNER CONNECTION 11/09/07 457.29 MW OH AP00111217 V01431 IRVINE PIPE AND SUPPLY 11/09/07 859.14 MW OH AP00111218 V01418 IRVINE RANCH WATER DISTRICT 11/09/07 29,555.3V --"MW OH AP00111219 V14366 JACOBS INC 11/09/07 117,606.93 /*W OH AP0011122�15013 KASDAN, DANA 11/09/07 125.00 MW OH EX AP00111221 V15811 KATZ & ASSOCIATES INC 11/09/07 6,288.72✓MW OH AP00111222 V15924 LUCADO, PAM 11/09/07 2,200.00 MW OH AP00111223 V12146 MANAGED HEALTH NETWORK 11/09/07 812.24 MW OH AP00111224 V01769 MARATHON PRINTING INC 11/09/07 230.42 MW OH AP00111225 V00190 MASSE, SHAWN 11/09/07 2,732.63 MW OH AP00111226 V13842 MATT CHLOR INC 11/09/07 406.11 MW OH AP00111227 V01 55 MCDONALD, JOHN 11/09/07 72.00 MW OH AP00111228 01841 MCFADDEN-DALE IND HARDWARE CO 11/09/07 104.03 MW OH City of Tustin 11/08/07 0 H C H E C K R E G I S T E R CHECK REGISTER Page 4 THU, NOV 08, 2007, 9:50 AM --req: TBERARDI--leg: GL JL--loc: TUSTIN----job: 269976 #S020---- prog: BK200 <1.23>--report id: CKREG--- Check Payee ID. Payee Name Date Check Amount Type Subs Rel To Note AP00111229'V12276 MCGUIRE, JOHN 11/09/07 596.25 MW- _OH- _-_-__-____---__--___-_-_-_----------------_ AP00111230 V01823 MERRIMAC ENERGY GROUP 11/09/07 21,787.78 /IOW OH AP00111231 V13765 i MINORITIES & SUCCESS 11/09/07 495.00 MW OH AP00111232 V14489 MONTELEONE, ANTHONY J 11/09/07 144.00 MW OH AP00111233 V00158 MORELAND & ASSOCIATES 11/09/07 10,854.80,,.,-frIW OH AP00111234 V01707 MUTUAL LIQUID GAS & 11/09/07 1,209.42 MW OH AP00111235 V15851 NISSAN MOTOR ACCEPTANCE CORPO 11/09/07 605.54 MW OH AP00111236 V01919 NORTH STAR ELECTRONICS 11/09/07 584.55 MW OH AP00111237 V01065 OFFICE DEPOT 11/09/07 67.21 MW OH AP00111238 V11218 ORANGE COUNTY LOCKSMITH SERVI 11/09/07 497.28 MW OH AP00111239 V01939 ORANGE COUNTY TRANSPORTATION 11/09/07 151.32 MW OH AP00111240 V01955 ORIENTAL TRADING COMPANY INC 11/09/07 204.45 MW OH AP001112411VO1965 OXYGEN SERVICE COMPANY 11/09/07 50.30 MW OH PERRY, AP00111242?V15845 ANTHONY 11/09/07 307.32 MW OH EX AP00111243 V02117 PERS LONG TERM CARE PROGRAM 11/09/07 248.26 MW OH AP00111244 V15887 PLESET2, DALE 11/09/07 72.00 MW OH AP00111245 V01745 POWER FORD 11/09/07 688.52 MW OH AP00111246 V12486 PROFESSIONAL SPORTS FIELD MAI 11/09/07 2,495.00, MW OH AP00111247 V15332 PROFORCE MARKETING INC 11/09/07 606.09 MW OH AP00111248 V02154 QUICK SIGNS 11/09/07 221.45 MW OH AP00111249 V02166 RED WING SHOE STORES 11/09/07 276.28 MW OH AP00111250 y,C(0117 REEKSTIN, SCOTT 11/09/07 37.35 MW OH EX City of Tustin 11/08/07 0 H C H E C K R E G I S T E R CHECK REGISTER Page 5 THU, NOV 08, 2007, 9:50 AM --req: TBERARDI--leg: GL JL--loc: TUSTIN ---- job: 269976 #S020----prog: BK200 <1.23> --report id: CKREG--- Check Payee ID. Payee Name Date Check Amount Type Subs Rel To Note AP00111251'V14334 ROUGH -FIT OUTDOOR FITNESS INC 11/09/07 885.00 MW ON AP00111252AV02455 S&S.WORLDWIDE 11/09/07 995.07 MW ON AP00111253 V02300 SAFETY-KLEEN CORP. 11/09/07 174.88 MW ON AP00111254 V00209 SCAFATI, FRANK RAY 11/09/07 1,500.00 MW ON AP00111255 V02526 SHAMROCK SUPPLY COMPANY 11/09/07 186.20 MW ON AP00111256 V14467 SHAPE PRODUCTS 11/09/07 463.66 MW ON AP00111257 V02512 SILICONAVE.COM 11/09/07 27,476.25 MW ON AP00111258 V02297 SIRCHIE FINGERPRINT LABS 11/09/07 92.80 MW ON AP00111259 VO2275 SMART & FINAL IRIS CO 11/09/07 1,147.06 MW ON AP00111260X02345 SMITH PIPE & SUPPLY INC 11/09/07 152.98 MW ON AP00111261"V16137 SO CAL SANDBAGS INC 11/09/07 1,271.09 MW ON AP00111262 V02265 SOUTHERN CALIFORNIA EDISON CO 11/09/07 8,352.99/FIW ON AP00111263 V11047 SOUTHERN CALIFORNIA EDISON CO 11/09/07 470.61 MW ON AP00111264 V00457 SPORT SUPPLY GROUP INC 11/09/07 1,539.79 MW ON AP00111265 V13763 STAPLES INC 11/09/07 2,922.94 MW ON AP00111266 V02433 STEVEN ENTERPRISES INC 11/09/07 604.80 MW ON AP00111267 V14042 SYED, ALIA 11/09/07 134.19 MW ON EX AP00111268 V02106 TANGRAM 11/09/07 15,695.40/MW ON AP00111269 V13753 TANK SPECIALISTS OF CALIFORNI 11/09/07 192.60 MW ON AP00111270/ V02580 TRAFFIC CONTROL SERVICE INC 11/09/07 754.25 MW ON AP00111271 V02589 TRISKELION PROFESSIONAL AUDIO 11/09/07 1,125.00 MW ON AP00111272 Vj-6068 TRUXAW & ASSOCIATES, JOSEPH C 11/09/07 1,581.25 MW ON City of Tustin 11/08/07 0 H C H E C K R E G I S T E R CHECK REGISTER Page 6 THU, NOV 08, 2007, 9:50 AM --req: TBERARDI--leg: GL JL--Loc: TUSTIN ----job: 269976 #S020---- prog: BK200 <1.23>--report id: CKREG --- Check Pa ee ID. Payee Name =FOUNDATION Date Check Amount Type Subs Rel To Note AP00111273� V02604====== TUSTIN COMMUNITY 11/09/07 270.00 MW OH AP00111274 V02604 TUSTIN COMMUNITY FOUNDATION 11/09/07 630.00 MW OH AP00111275 V02624 TUSTIN COMMUNITY FOUNDATION 11/09/07 45.00 MW OH AP00111276 V02624 TUSTIN COMMUNITY FOUNDATION 11/09/07 450.00 MW OH AP00111277 V02624 TUSTIN COMMUNITY FOUNDATION 11/09/07 90.00 MW OH AP00111278 V02267 TUSTIN IRVINE MEDICAL GROUP 11/09/07 644.66 MW OH MH AP00111279 V02546 TUSTIN LOCK AND SAFE INC 11/09/07 23.71 MW OH AP0011128dAD01044 TUSTIN TILLER'S BOY'S BASKETB 11/09/07 500.00 MW OH AP0011126 V00571 TUSTIN WATER SERVICE,CITY OF 11/09/07 8,413.9W OH AP0011128 D00907 TUSTIN WOODCARVERS 11/09/07 150.00 MW OH AP00111283 V02707 UNIVAR USA 11/09/07 2,677.96 MW OH AP00111284 V13791 US BANK 11/09/07 2,200.00 MW OH AP00111285 V02890 US POSTMASTER 11/09/07 139.30 MW OH AP00111286 V02661 US TOY CO INC 11/09/07 765.96 MW OH AP00111287 V11050 VULCAN MATERIALS COMPANY 11/09/07 1,469.71 MW OH AP00111288 V14924 WASHINGTON GROUP INTERNATIONA 11/09/07 15,113.5% MW OH AP00111289 V02755 WELLS SUPPLY CO 11/09/07 38178.95/ MW OH AP00111290/402751 WEST COAST ARBORISTS 11/09/07 41,659.80 W OH AP00111291 V11000 WESTERN PRESS 11/09/07 215.87 MW OH AP00111292 V14293 WILEY, BRADFORD 11/09/07 144.00 MW OH City of Tustin 11/08/07 0 H C H E C K R E G I S T E R CHECK REGISTER Page 7 THU, NOV 08, 2007, 9:50 AM --req: TBERARDI--leg: GL JL--loc: TUSTIN----job: 269976 #S020 ---- prog: BK200 <1.23> --report id: CKREG--- Check Payee ID. Payee Name Date Check Amount Type Subs Rel To Note -------------------------------- S U B T 0 T A L S: Total Void Machine Written 0.00 Number of Checks Processed: 0 Total Void Hand Written 0.0Number of Checks Processed: 0 Total Machine Written 650,661.23 Number of Checks Processed: 130 Total Hand Written 0.00 Number of Checks Processed: 0 Total Reversals 0.00 Number of Checks Processed: 0 Total Cancelled 0.00 Number of Checks Processed: 0 S U B T 0 T A L 650,661.23 City of Tustin 11/08/07 0 H C H E C K R E G I S T E R CHECK REGISTER Page 8 THU, NOV 08, 2007, 9:50 AM --req: TBERARDI--leg: GL JL--loc: TUSTIN----job: 269976 #S020----prog: BK200 <1.23>--report id: CKREG--- Check Payee ID. Payee'Name Date Check Amount Type Subs Rel To Note EP00000208 V15511 DELGADILLO, RAUL 11/09/07 78.45 CX OH EX S U B T 0 T A L S: Total Void Machine Written 0.00 Number of Checks Processed: 0 Total Void Hand Written 0.00 Number of Checks Processed: 0 Total Machine Written 0.00 Number of Checks Processed: 0 Total Hand Written 0.00 Number of Checks Processed: 0 Total Reversals 0.00 mbar of Checks Processed: 0 Total Cancelled 78.45 Number of Checks Processed: 1 S U B T 0 T A L 78.45 City of Tustin 11/08/07 0 H C H E C K R E G I S T E R CHECK REGISTER Page 9 THU, NOV 08, 2007, 9:50 AM --req: TBERARDI--leg: GL JL--loc: TUSTIN----job: 269976 #S020 ---- prog: BK200 <1.23> --report id: CKREG--- Check Payee ID. Payee Name Date Check Amount Type Subs Rel To Note G R. A N D T 0 T A L S: ------------ Total Void Machine Written 0.00 Number of Checks Processed: 0 Total Void Hand Written 0.00umber of Checks Processed: 0 Total Machine Written 650,661.23 Number of Checks Processed: 130 Total. Hand Written 0.00 Number of Checks Processed: 0 Total Reversals 0.00 Number of Checks Processed: 0 Total Cancelled 78.45 Number of Checks Processed: 1 G R A N D T 0 T A L 650, 739.68 City of Tustin 10/31/07 VOID, TYPED R REVERSED A/P CHECK REGISTER Page 1 WED, OLT 31, 2UUi, 11:42 AM -- req: TBEkARDI--leg: GL JL--loc. TUSTIN----job: 269525 #J1898---prog. BK200 <1.23>--repurL id: CKREG--- Check P_yee_ID_Payee Name AP00107663 V02166 RED WING SHOE STORES Date 10/29/07 Check Amount Ty�(ie 168.95 RV Subs Re[ TR To Note______________-______-_-___-_____- Reversed AP00108561(V14687 REGER, BRENT 10/29/07 402.50 RV TR Reversed AP00109176/0 4687 REGER, BRENT 10/29/07 322.00 RV TR Reversed AP00109306-'V15149 SENA CONSTRUCTION INC 10/29/07 255,095.14e/KV TR Reversed AP00109542✓ V00270 BRABECK, JAMES 10/29/07 50.40/ RV TR EX Reversed AP00109784{D00989 ROSAS, DAVID 10/29/07 997.00 RV TR Reversed AP00110400/V15047 ORANGE, CITY OF 10/29/07 26.00/RV TR Reversed G R A N D T 0 T A L S: Total Void Machine Written 0.00 Number of Checks Processed: 0 Total Void Hand Written 0.00 Number of Checks Processed: 0 Total Machine Written 0.00 Number of Checks Processed: 0 Total Hand Written 0.00 Number of Checks Processed: 0 Total Reversals 2571061.99 Number of Checks Processed: 7 Total Cancelled 0.00 Number of Checks Processed: G R A N D T 0 T A L 257, 061 .99 City of Tustin PAYROLL EFT REPORT Pay Period: 10/15/2007-10/28/2007 for the EFT file created 10/31/2007 4:10 PM EFT Effective Date: 11/02/2007 Employee ID Deposit Amount 1187 1,567.95 859 1,859.70 50 962.89 336 3,822.21 930 1,573.80 882 2,212.11 450 3,277.36 1279 1,531.35 1275 1,577.98 863 3,839.40 1106 1,564.44 1228 109.37 1009 2,740.25 1273 1,806.48 323 1,870.30 798 2,100.14 1296 692.57 671 2,813.09 415 1,588.92 1266 1,605.64 1037 979.20 1260 1,997.11 190 3,166.69 86 1,150.00 90 1,434.68 1116 1,129.60 623 3,866.95 362 2,799.01 601 1,912.55 258 3,265.48 1098 2,175.29 978 1,732.55 905 165.20 711 2,396.48 1271 1,608.81 990 2,952.18 823 1,982.27 1259 2,152.27 957 1,710.54 955 2,969.35 1185 411.43 434 2,950.70 1186 378.17 1077 1,561.65 1216 1,728.45 1067 2,185.51 261 2,411.52 321 2,451.97 482 1,284.99 421 3,680.12 S:\Payroll\EFT File Reports\EFTFILE701022.xis: EFTFILE 701022 10/31/2007 Page 1 of 7 City of Tustin PAYROLL EFT REPORT Pay Period: 10/15/2007-10/28/2007 for the EFT file created 10/31/2007 4:10 PM EFT Effective Date: 11102/2007 Employee ID Deposit Amount 668 2,370.77 1158 1,561.98 1283 1,575.61 925 2,451.46 1285 1,369.22 1160 1,699.19 1176 1,968.41 1128 1,313.81 1280 1,721.14 1278 1,355.13 1312 3,305.61 351 1,795.20 110 1,621.99 363 1,718.05 968 1,073.78 1140 1,611.11 1024 244.44 26 1,386.79 1244 1,283.67 1117 2,112.43 1198 2,051.14 832 2,047.31 27 1,258.36 1086 1,541.09 233 1,464.22 113 889.14 1276 1,436.84 1054 1,899.98 889 1,592.78 621 1,929.00 1236 1,141.30 854 1,576.96 341 3,916.83 31 1,051.51 207 3,015.41 115 2,726.78 846 1,688.36 208 1,591.64 6 3,868.61 982 2,395.80 916 1,746.80 784 2,259.39 1199 2,250.25 1058 1,548.47 1289 1,753.35 1291 79.08 1078 1,884.65 924 2,384.30 319 1,654.05 604 2,446.68 S:\Payroll\EFT File Reports\EFTFILE701022.xls: EFTFILE 701022 10/31/2007 Page 2 of 7 City of Tustin PAYROLL EFT REPORT Pay Period: 10/15/2007-10/28/2007 for the EFT file created 10/31/2007 4:10 PM EFT Effective Date: 11/02/2007 Employee ID Deposit Amount 626 2,163.49 888 1,811.43 92 25.00 1091 1,235.47 120 5,922.70 121 4,863.28 1235 1,299.97 1111 2,631.61 1290 1,189.43 123 2,552.45 64 200.00 1202 1,932.15 125 3,109.64 931 2,814.00 1064 2,069.49 518 305.00 337 1,773.64 1179 2,478.24 259 546.00 932 2,103.19 1183 2,995.03 763 2,822.08 1052 2,559.62 238 1,490.56 18 4,869.32 1203 1,623.02 1 1,669.32 1022 986.43 679 1,188.27 1127 1,357.48 1178 2,149.73 1159 1,557.58 35 1,723.94 130 2,886.54 1200 1,216.78 274 2,930.65 1220 243.37 303 2,537.24 131 2,206.43 352 1,396.88 1066 2,017.82 1256 1,285.49 801 2,132.64 1145 1,639.53 279 1,197.87 1125 1,540.85 20 330.00 1245 395.39 613 2,179.27 1308 1,274.38 SAPayroll\EFT File Reports\EFTFILE701022.xis: EFTFILE 701022 10/31/2007 Page 3 of 7 City of Tustin PAYROLL EFT REPORT Pay Period: 10/15/2007-10/28/2007 for the EFT file created 10/31/2007 4:10 PM EFT Effective Date: 11/02/2007 Employee ID Deposit Amount 970 2,107.08 1286 266.29 1314 1,613.72 1268 1,522.05 927 2,471.52 101 3,736.34 1238 2,360.52 1197 2,462.69 779 1,554.47 474 500.00 1023 1,169.60 1094 2,704.71 706 503.89 777 2,241.70 792 1,667.41 381 2,325.42 55 2,265.90 347 2,389.46 614 3,791.35 88 1,581.95 1189 2,516.49 749 1,349.78 66 1,816.61 145 2,515.50 1243 331.47 579 2,472.67 1309 839.58 1242 1,355.95 1019 2,248.89 1217 2,486.79 993 407.21 923 997.26 1033 4,129.28 1104 2,482.50 1205 1,997.41 1208 2,141.84 1234 273.53 21 3,776.53 816 3,040.09 954 2,397.09 1188 1,965.57 1195 272.06 720 2,080.66 1109 2,930.53 1126 1,343.00 556 1,963.38 963 2,598.78 804 2,187.68 452 1,167.67 1194 681.55 SAPayroll\EFT File Reports\EFTFILE701022.xis: EFTFILE 701022 10/31/2007 Page 4 of 7 City of Tustin PAYROLL EFT REPORT Pay Period: 10/15/2007-10/28/2007 for the EFT file created 10/31/2007 4:10 PM EFT Effective Date: 11/02/2007 Employee ID Deposit Amount 404 3,322.04 1035 2,061.66 1247 1,406.23 1182 1,597.05 867 1,660.39 353 1,960.62 22 1,516.29 1250 1,809.10 1026 861.05 912 1,735.96 969 2,212.33 75 1,507.26 155 3,023.54 84 1,131.69 1137 3,211.06 1184 209.46 742 2,938.30 959 1,435.39 1193 3,513.54 386 2,966.63 734 2,695.89 1288 1,548.90 23 1,232.72 159 2,770.93 1123 2,194.39 834 1,345.72 540 1,435.54 1101 1,345.55 1306 1,706.54 1065 2,283.03 1013 1,989.57 672 3,729.97 994 915.87 675 1,222.66 1028 2,650.83 3 2,660.48 218 2,480.43 1272 236.34 165 1,910.28 554 3,577.38 1190 2,229.07 166 1,125.31 1249 2,127.41 398 1,360.07 1270 516.01 497 3,702.37 960 497.35 326 2,204.29 1300 1,286.58 219 1,605.09 SAPayroll\EFT File Reports\EFTFILE701022.xis: EFTFILE 701022 10/31/2007 Page 5 of 7 City of Tustin PAYROLL EFT REPORT Pay Period: 10/15/2007-10/28/2007 for the EFT file created 10/31/2007 4:10 PM EFT Effective Date: 11/02/2007 Employee ID Deposit Amount 1254 1,565.43 1124 418.23 1305 182.18 1269 700.63 1080 1,794.69 203 3,088.29 892 1,520.86 612 103.25 562 3,596.22 1177 2,217.40 85 1,912.50 1147 1,558.36 1038 1,631.10 275 2,852.75 898 2,398.80 966 2,188.44 390 2,307.72 878 392.50 495 1,877.52 1261 1,972.24 669 2,207.89 1251 3,175.35 281 2,557.49 291 2,497.48 1274 1,432.48 855 2,657.07 1092 389.19 461 1,291.36 96 286.00 985 431.14 89 1,585.44 746 3,345.32 769 1,798.88 293 1,949.60 182 2,731.31 974 3,777.39 961 2,175.23 803 3,151.35 600 1,400.20 762 1,611.10 723 2,572.21 895 3,176.46 1207 2,157.45 1281 2,062.73 1253 1,760.14 1257 2,914.70 545 1,669.10 345 2,042.16 1282 1,732.73 1237 2,215.66 SAPayroll\EFT File Reports\EFTFILE701022.xls: EFTFILE 701022 10/31/2007 Page 6 of 7 City of Tustin Employee ID Deposit Amount 1068 2,029.74/- 577,499.2 301 J. PAYROLL EFT REPORT Pay Period: 10/15/2007-10/28/2007 for the EFT file created 10/31/2007 4:10 PM EFT Effective Date: 11/02/2007 SAPayroll\EFT File Reports\EFTFILE701022.xls: EFTFILE 701022 10/31/2007 Page 7 of 7 city of Tustin PY Positive Pav Report Check # Tye_ Date PEID Check Amount 364.01 PY )0015931 'HK 11/02/2007 1118 364.01 240.17 PY )0015932 'HK [1/02/2007 906 240.17 0.00 PY )0015933 'HK [1/02/2007 1255 0.00 3,882.44 PY )0015934 'HK [1/02/2007 39 3,882.44 560.34 PY )0015935 'HK [1/02/2007 20 560.34 5,768.67 PY )0015936 'HK [ 1/02/2007 659 5,768.67 1,763.39 PY )0015937 'HK [ 1/02/2007 865 1,763.39 2,222.02 PY )0015938 'HK L I/02/2007 833 2,222.02 1,740.86 PY )0015939 'HK 11/02/2007 956 1,740.86 1,833.92 PY )0015940 'HK 11/02/2007 1311 1,833.92 1,347.39 PY )0015941 'HK 11/02/2007 1020 1,347.39 1,390.21 PY )0015942 'HK [1/02/2007 911 1,390.21 1,674.35 PY )0015943 'HK' L1/02/2007 64 1,674.35 1,705.66 PY )0015944 'HK [1/02/2007 69 1,705.66 1,679.80 PY )0015945 'HK [1/02/2007 70 1,679.80 888.48 PY )0015946 'HK L1/02/2007 86 888.48 1,358.79 PY )0015947 'HK 11/02/2007 92 1,358.79 1,184.34 PY )0015948 'HK L1/02/2007 1315 1,184.34 3,818.20 PY )0015949 'HK L1/02/2007 1180 3,818.20 1,557.51 PY )0015950 'HK L1/02/2007 325 1,557.51 2,768.03 PY )0015951 'HK 11/02/2007 474 2,768.03 3,868.57 PY )0015952 'HK L 1/02/2007 1121 3,868.57 1,285.01 PY )0015953 'HK L1/02/2007 1071 1,285.01 2,397.02 User: Sandy Alves Page 1 Report: PY_BK_POSPAY_01_TJP PY Positive Pay Report Reference 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP 01022 -DP Current Date: 11/0 1 /07 Time: 09:56:06 City ofTu-stin Check # Type PY Positive Pay Report Date PEID Check Amount _Reference- PY )0015954 'HK [1/02/2007 116 2,397.02 1,894.08 01022 -DP PY )0015955 'HK [1/02/2007 1284 1,894.08 2,275.63 01022-L)P PY )0015956 'HK [1/02/2007 518 2,275.63 2,113.87 01022 -DP PY )0015957 'HK [1/02/2007 151 2,113.87 217.82 01022 -DP PY )0015958 'HK [1/02/2007 622 217.82 401.90 01022 -DP PY )0015959 'HK [1/02/2007 179 401.90 40.19 01022 -DP PY )0015960 'HK L1/02/2007 185 40.19 1,883.38 01022 -DP PY )0015961 'HK [1/02/2007 952 1,883.38 264.89 01022 -DP PY )0015962 'HK 11/02/2007 1316 264.89 1,538.20 01022 -DP PY )0015963 'HK [ 1/02/2007 500 1,538.20 74.91 01022 -DP PY )00f 5964 'HK [1/02/2007 1299 74.91 301.03 01022 -DP PY )0015965 'HK [1/02/2007 1224 301.03 185.32 01022 -DP PY )0015966 'HK [ 1/02/2007 858 185.32 108.14 01022 -DP PY )0015967 'HK [ 1/02/2007 813 108.14 357.93 01022 -DP PY )0015968 'HK [ 1/02/2007 1155 357.93 197.13 01022 -DP PY )0015969 'HK [ 1/02/2007 1297 197.13 404.64 01022 -DP PY )0015970 'HK [ 1/02/2007 1301 404.64 292.02 01022 -DP PY )0015971 'HK 11/02/2007 1041 292.02 425.70 01022 -DP PY )0015972 HK [1/02/2007 1294 425.70 452.76 01022 -DP PY )0015973 'HK [ 1/02/2007 1212 452.76 268.42 01022 -DP PY )0015974 'HK 11/02/2007 1151 268.42 212.18 01022 -DP PY )0015975 'HK 11/02/2007 1218 212.18 492.25 01022 -DP PY )0015976 'HK [1/02/2007 1213 492.25 186.08 01022 -DP PY )0015977 'HK [1/02/2007 1085 186.08 User: Sandy Alves Page 2 Report: PY-BK POSPAY_01_TJP PY Positive Pay Report Current Date: 11/01/07 Time: 09:56:06 City of Tustin j Check # Type PY Positive Pay Report Date PEID Check Amount Reference _ _ _._ _--_ - 133.99 01022 -DP PY )0015978 'HK [1/02/2007 1230 133.99 268.19 01022 -DP PY )0015979 'HK [1/02/2007 1287 268.19 227.49 01022 -DP PY )0015980 'HK [1/02/2007 1263 227.49 1,064.97 01022 -DP PY )0015981 'HK [ 1/02/2007 96 1,064.97 596.61 01022 -DP PY )0015982 'HK [ 1/02/2007 819 596.61 317.31 01022 -DP PY )0015983 'HK [1/02/2007 1152 317.31 512.44 01022 -DP PY )0015984 'HK 11/02/2007 1154 512.44 253.87 01022 -DP PY )0015985 'HK [ 1/02/2007 1210 253.87 511.99 01022 -DP PY )0015986 'HK [ 1/02/2007 1044 511.99 437.37 01022 -DP PY )0015987 'HK ll/02/2007 1051 437.37 109.37 01022 -DP PY )0015988 'HK 11/02/2007 1232 109.37 474.31 01022 -DP PY )0015989 'HK ll/02/2007 1005 474.31 158.14 01022 -DP PY )0015990 'HK [ 1/02/2007 1262 158.14 152.27 01022 -DP PY )0015991 'HK 11/02/2007 1264 152.27 Total of 61 eck(s): 65,105.97 End of Report User: Sandy Alves Page 3 Current Date: 11/0 1 /07 Report: PY—BK POSPAY_O1_TJP PY Positive Pay Report Time: 09:56:06