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