Loading...
HomeMy WebLinkAbout101-Staff Report.pdfRECOMMENDED ACTION: Accounts Payable: June 13, 20, and 27, 2007 Payroll: June 21 and July 5, 2007 REPORT SUMMARY: Attached are the Check Registers for: Date Ending Check No. Accounts Payable 6/13/07 105230 105273 42 $167,080.30 6/7/07 6/7/07 105229 Accounts Payable 6/20/07 105274 105335 63 $448,212.10 6/22/07 6/13/07 105273 Accounts Payable 6/27/07 105336 105408 73 $151,401.24 6/29/07 6/20/07 105335 Payroll (Pay Period 13-07)6/21/07 32390 32412 23 $130,883.03 6/21/07 6/7/07 32389 Payroll (Pay Period 14-07)7/5/07 32413 32453 41 $137,939.58 7/5/07 6/21/07 32412 ########### AP Date Check # Issued to Dept.Purpose Amount 6/13/07 105240 AS IT Service/Consulting $16,189.00 6/13/07 105244 PW $94,185.68 6/13/07 105263 Various Water Service $14,992.05 6/13/07 105270 AS ASP H T E Mtc.$10,780.00 6/20/07 105287 CM Law Enforcement Svc.$283,296.46 6/20/07 105290 El Camino Paving, Inc.PW Pavement Mgt.$92,502.67 6/20/07 105293 Fehr & Peers Assoc.PW Sara.NTMP/Speed Srvy $15,281.61 SARATOGA CITY COUNCIL SUBJECT: Review of Accounts Payable and Payroll Check Registers. Amount Karen Caselli Ending Check No. Total Checks MEETING DATE: ORIGINATING DEPT: PREPARED BY: July 18, 2007 AGENDA ITEM: Prior Check Register Dave Anderson That the City Council accepts the Check Registers for: CITY MANAGER: FINANCE & ADMIN. SERVICES DIRECTOR Type of Checks Mary Furey Checks Released Finance & Admin. Services TOTAL City of Palo Alto Furlo & Furlo The following is a list of Accounts Payable checks issued for more than $10,000.00 and a brief description of the expenditure: Fund Congress Springs- Toilet/Water Lines Gen-MIS CIP Date Starting Check No. County of Santa Clara San Jose Water Co. Gen - Street Mtc. Various Various Sunguard H T E Inc.Internal Service-IT Gen-Police/Public Safety C:\DOCUME~1\cboyer\LOCALS~1\Temp\Staff Report 6/27/07 105382 Various Gas/Electric Service $13,826.19 6/27/07 105393 Shute, Mihaly & Wein.Various Attorney/Legal Services $18,438.22 6/27/07 105408 Wittwer & Parkin, LLP CD Legal Services $16,033.69 The following is a list of Accounts Payable checks that were voided or manually issued: AP Date Check # Issued to Amount 6/13/07 105128 ($1,800.00) 6/11/07 105231 $1,800.00 5/30/07 105185 Knapp Consulting ($575.00) 6/7/07 105230 $575.00 The following is a list of cash reduction by fund: Fund #AP 6/13 AP 6/20 AP 6/27 PR 6/21 PR 7/5 Total 001 General 45,174.92 426,929.15 66,581.39 29,137.13 31,804.80 599,627.39 150 Streets & Roads 603.10 1,958.12 2,132.34 16,690.40 17,283.42 38,667.38 201 Manor Drive Landscape - 202 Ferdericksburg Landscape 35.84 35.84 203 Greenbriar Landscape 118.99 465.00 583.99 204 Quito Lighting 1,209.83 1,209.83 205 Azule Lighting 1,219.99 264.24 1,484.23 206 Sarahills Lighting 288.50 288.50 207 Village Lighting 2,296.69 2,296.69 209 McCartysville Landscape 276.41 15.96 292.37 210 Tricia Woods Landscape 39.32 7.98 47.30 211 Arroyo de Saratoga Landscape 42.91 42.91 212 Leutar Court Landscape 47.10 47.10 215 Bonnet Way Landscape 119.01 328.04 447.05 216 Beauchamps Landscape 42.79 42.79 217 Sunland Park Landscape - 222 Prides Crossing Landscape 236.11 36.45 272.56 224 Village Commercial Landscape 605.86 605.86 225 Saratoga Legends Landscape - 226 Bellgrove Landscape 2,534.10 2,534.10 227 Cunningham/Glasgow Landscape 135.45 135.45 228 Kerwin Ranch Landscape - 229 Tollgate LLD 22.45 135.14 157.59 231 Horseshoe Landscape/Lighting 320.00 7.99 327.99 232 Gateway Landscape 207.29 207.29 250 Development Services 579.01 5,333.48 37,322.87 56,916.33 56,878.40 157,030.09 260 Environmental Program SRF 6,398.91 1,853.07 5,346.99 5,346.97 18,945.94 270 CDBG - Federal Grants - 290 Recreation 2,658.08 4,100.13 11,969.23 17,433.51 21,144.32 57,305.27 291 Teen Services 46.90 1,125.00 4,332.50 5,481.67 10,986.07 310 Park Dev Cap Proj Fund 24,038.91 24.44 1,910.79 25,974.14 Spec.Rev. & Deposit Reason Void -Incorrect Payee; Reissue Ck #105231CA Dept-Fish & Game Fund Description Clerk Recorder's Office Manual Check Void-Incorrect address; Reissue Ck #105230 Various Knapp Consulting Manual Check The following is a list of Accounts Payable checks issued for more than $10,000.00 and a brief description of the expenditure (continued): Pacific Gas & Electric Various C:\DOCUME~1\cboyer\LOCALS~1\Temp\Staff Report 320 - The following is a list of cash reduction by fund (continued): Fund #AP 6/13 AP 6/20 AP 6/27 PR 6/21 PR 7/5 Total 352 Infrastructure - 400 Library Bond Debt Service 795.00 795.00 420 Leonard Road - 501 Equipment Replacement ISF - 502 Information Technology 10,780.00 10,780.00 503 Facility Improvement - 604 Planning Deposit Pre 2006 234.38 234.38 605 Planning Deposit FY 2006 627.75 9,659.97 10,287.72 701 Traffic Safety 433.00 433.00 702 Highway 9 Safety - 703 Hakone ADA Improvements - 706 Sidewalk Annual Project 792.50 792.50 707 Aloha Street Safety Improvement - 716 Highway 9/Oak Pedestrain 1,026.17 1,026.17 727 El Quito Area Curb Replacement - 728 Book Go Round Drainage - 731 Storm Drain Upgrades 55,468.11 55,468.11 732 Median Landscape/Irrigation 7,474.00 7,474.00 734 Civic Center Landscape - 735 Village Lights (Zone 7A)- 736 Village Trees Lighting 302.62 302.62 738 Cox Ave Railroad Crossing - 741 Blaney Plaza Improvements - 743 Blaney Plaza Improvements/Cnstrc - 744 Village Sidewalk, Curb/Gutter - 746 Saratoga-Sunnyvale Gateway 960.00 834.58 1,794.58 748 El Ca Grante/Monta Vista 14,678.66 14,678.66 755 Warner Hutton House Improvement 2,269.42 2,269.42 758 Civic Center - CDD Offices - 762 North Campus/19848 Prospect 1,000.00 2,000.00 3,000.00 790 UPRR/De Anza Trail 146.67 1,989.67 2,136.34 791 Kevin Moran 3,200.69 844.84 4,045.53 792 Alternative Soccer Field - 793 Parks/Trails Repair 402.50 402.50 167,080.30 448,212.10 151,401.24 130,883.03 137,939.58 1,035,516.25 - - - - - - ALTERNATIVE ACTION: N/A FOLLOW UP ACTION: N/A ADVERTISING, NOTICING AND PUBLIC CONTACT: N/A ATTACHMENTS: TOTAL Fund Description Park Dev Capital Project C:\DOCUME~1\cboyer\LOCALS~1\Temp\Staff Report Check Register in the Expenditure Approval List format. C:\DOCUME~1\cboyer\LOCALS~1\Temp\Staff Report SARATOGA CITY COUNCIL MEETING DATE: ORIGINATIN G DEPT: Dave AndersonFINANCE PREPARED BY: SUBJECT: Payroll - 5/10, 5/24 RECOMMENDED ACTION: Accounts Payable- 5/9/2007, 5/16/07, 5/23/07/ 5/30/07 Payroll - 5/10, 5/24 REPORT SUMMARY: Attached are the Check Registers for: Check Date Checks Released Date Ending Check No. 5/9/07 5/10/07 5/1/07 104904 5/16/07 5/23/07 5/30/07 Payroll 5/10/07 5/10/07 4/26/07 32298 Payroll 5/24/07 5/24/07 Type of Checks Date Starting Check # Ending Check # Total Checks Amount Accounts Payable 5/9/07 104905 104970 65 $188,173.92 Accounts Payable 5/16/07 Accounts Payable 5/23/07 Accounts Payable 5/30/07 Payroll (pay period 10-07)5/10/07 32299 32339 41 $140,403.98 Payroll (Pay period 11-07)5/24/07 TOTAL $328,577.90 The following is a list of checks issued for more than $10,000.00 and a brief description of the expenditure: AP Date Check # Issued to Dept. 5/9 104956 Various 5/9 104967 PW-Eng. 5/16 5/23 Accounts Payable Purpose Gas/Electric Clean Water Program Pacific Gas & Electric West Valley Sanitation Dst. Accounts Payable Accounts Payable June 6, 2007 Administrative Services That the City Council accepts the Check Registers for: Check Registers for: Accounts Payable- 5/9/2007, 5/16/07, 5/23/07/ 5/30/07 Mary FureyKaren Caselli Accounts Payable AGENDA ITEM: CITY MANAGER: FINANCE & ADMIN. SERVICES DIRECTOR Prior Check Register Fund Various Environmental Svc. 5/30 The following is a list of checks that were voided/manually issued:. AP Date Check # Issued to Amount 5/9 104655 (11,614.53) 5/9 104905 3,773.88 5/9 104837 (8,475.83) 5/9 104872 (12,284.18) 5/9 104849 (250.00) 5/9 104970 250.00 5/16 5/23 5/30 The following is a list of cash reduction by fund: Fund #Fund Description A/P 5/9 AP 5/23 AP 5/30 PR 5/10 PR 5/24 001 General 31,675.21 39,642.67 150 Streets & Roads 1,891.70 17,508.24 201 Manor Drive Landscape 202 Ferdericksburg Landscape 203 Greenbriar Landscape 204 Quito Lighting 1,216.99 205 Azule Lighting 265.92 206 Sarahills Lighting 290.00 207 Village Lighting 2,401.98 209 McCartysville Landscape 15.96 210 Tricia Woods Landscape 1.80 211 Arroyo de Saratoga Landscape 96.55 212 Leutar Court Landscape 215 Bonnet Way Landscape 329.00 216 Beauchamps Landscape 48.50 217 Sunland Park Landscape 222 Prides Crossing Landscape 40.17 224 Village Commercial Landscape 225 Saratoga Legends Landscape 226 Bellgrove Landscape 88.12 227 Cunningham/Glasgow Landscape 6.18 228 Kerwin Ranch Landscape 229 Tollgate LLD 180.35 231 Horseshoe Landscape/Lighting 8.51 232 Gateway Landscape 250 Development Services 9,561.86 56,356.15 260 Environmental Program SRF 109,480.25 5,431.83 270 CDBG - Federal Grants 5,500.00 Fund #Fund Description A/P 5/9 AP 5/23 AP 5/30 PR 5/10 PR 5/24 Gachina Landscape Pacific Gas & Electric Casey, Kathleen Peck, Willys Pacific Gas & Electric D & M Traffic Svc. Purpose Void -See reissue 104956 Manual Void - See reissue 104931 Void-See reissues 104954-56 Void - See reissue 104970 Manual 290 Recreation 8,047.88 16,324.66 291 Teen Services 1,054.65 4,114.26 310 Park Dev Cap Proj Fund 480.00 320 Park Dev Capital Project 352 Infrastructure 400 Library Bond Debt Service 420 Leonard Road 501 Equipment Replacement ISF 502 Information Technology 503 Facility Improvement 604 Planning Deposit Pre 2006 2,582.30 605 Planning Deposit FY 2006 2,086.54 701 Traffic Safety 669.65 702 Highway 9 Safety 703 Hakone ADA Improvements 706 Sidewalk Annual Project 707 Aloha Street Safety Improvement 716 Highway 9/Oak Pedestrain 1,026.17 727 El Quito Area Curb Replacement 729.01 728 Book Go Round Drainage 731 Storm Drain Upgrades 732 Median Landscape/Irrigation 734 Civic Center Landscape 720.10 735 Village Lights (Zone 7A) 736 Village Trees Lighting 738 Cox Ave Railroad Crossing 741 Blaney Plaza Improvements 743 Blaney Plaza Improvements/Construc. 744 Village Sidewalk, Curb/Gutter 746 Saratoga-Sunnyvale Gateway 203.66 755 Warner Hutton House Improvement 758 Civic Center - CDD Offices 762 North Campus/19848 Prospect 790 UPRR/De Anza Trail 8,147.44 791 Kevin Moran 792 Alternative Soccer Field 793 Parks/Trails Repair 353.64 188,173.92 0.00 0.00 140,403.98 0.00 ALTERNATIVE ACTION: N/A FOLLOW UP ACTION: N/A ADVERTISING, NOTICING AND PUBLIC CONTACT: N/A ATTACHMENTS: Check Register in the Expenditure Approval List format. TOTAL Amount 11,614.53$ 109,480.25$ Total 71,317.88 19,399.94 0.00 0.00 0.00 1,216.99 265.92 290.00 2,401.98 15.96 1.80 96.55 0.00 329.00 48.50 0.00 40.17 0.00 0.00 88.12 6.18 0.00 180.35 8.51 0.00 65,918.01 114,912.08 5,500.00 Total 24,372.54 5,168.91 480.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,582.30 2,086.54 669.65 0.00 0.00 0.00 0.00 1,026.17 729.01 0.00 0.00 0.00 720.10 0.00 0.00 0.00 0.00 0.00 0.00 203.66 0.00 0.00 0.00 8,147.44 0.00 0.00 353.64 328,577.90