HomeMy WebLinkAbout05.D-Finance 5.0 JAI
• I �
DOC ID: 1986
CITY OF SAN BERNARDINO—REQUEST FOR COUNCIL ACTION
Claims and Payroll
From: Jason Simpson M/CC Meeting Date: 09/17/2012
Prepared by: Veronica Martinez, (909) 384-
5242
Dept: Finance Ward(s): All
Subject:
Approval of Commercial Checks and Payroll Checks
Financial Impact:
Motion: Approve the claims and payroll and authorize the issuance of warrants as listed.
Approve the register of demands dated:
May 29, 2012 11/2012 #57 $1,056,774.10
June 5, 2012 11/2012 #58 770,813.27
June 6, 2012 11/2012#59 999,730.00
June 7, 2012 11/2012#60 982,643.00
June 12, 2012 11/2012 #61 1,006,628.02
June 19, 2012 11/2012 #62 844,770.59
Grand Total Register of Demands $5,661,358.98
Approve the total payroll:
Semi Monthly Gross Payroll 6/16/2012 - 6/30/2012 $3,941,490.29
Semi Monthly Gross Payroll 7/1/2012 - 7/15/2012 4,213,048.47
Monthly Gross Payroll 6/16/2012 - 7/15/2012 7,100.00
Grand Total Gross Payroll: $8,161,638.76
Supporting Documents:
I Packet Pg 21
Updated:9/10/2012 by Linda Sutherland Page 1
DOC ID: 1986
CITY OF SAN BERNARDINO—REQUEST FOR COUNCIL ACTION
Claims and Payroll
From: Jason Simpson M/CC Meeting Date: 09/17/2012
Prepared by: Veronica Martinez, (909) 384-
5242
Dept: Finance Ward(s): All
Subject:
Approval of Commercial Checks and Payroll Checks
Motion: Approve the claims and payroll and authorize the issuance of warrants as listed.
Approve the register of demands dated:
May 29, 2012 11/2012 #57 $1,056,774.10
June 5, 2012 11/2012 #58 770,813.27
June 6, 2012. 11/2012 #59 999,730.00
June 7, 2012 11/2012 #60 982,643.00
June 12, 2012 11/2012 #61 1,006,628.02
June 19, 2012 11/2012 #62 844,770.59
Grand Total Register of Demands $5,661,358.98
Approve the total payroll:
Semi Monthly Gross Payroll 6/16/2012 - 6/30/2012 $3,941,490.29
Semi Monthly Gross Payroll 7/1/2012 - 7/15/2012 4,213,048.47
Monthly Gross Payroll 6/16/2012 - 7/15/2012 7,100.00
Grand Total Gross Payroll: $8,161,638.76
Supporting Documents:
CITY OF SAN BERNARDINO
PAYROLL SUMMARY REPORT
PERIOD ENDING DATE 30 1), DATE PAID (pl of /,� f PP No. I c,C
CHECK NUMBERS USED: t 5 1°_ 1� j ; �) 3 -a ? k } 3-a -t,
CHECK NUMBERS VOIDED: t-7J\ 5 7- \ l V
CHECK NUMBERS CANCELLED: \ 5 _7 �, ) 5 g 5 3✓"
EARNINGS:
rr'f
' Regular Gross: 3 (j LIB 41f s
Adjustments:
Total Adjusted Gross Payroll 3/ '` L1 r t 1WLO
DEDUCTIONS: l L
Total(Without Adjustments) j O J 5 • ss6
Adjustments:
Total Adjusted Deductions 7 �j, 3 q" 5. �y c� S v
Net Payroll 15(0 l
APPROVALS FOR PAYMENT
4AILIUkS)3
DIRECTOR OF FINANCE SECRETARY OF CIVIL SERVICE BOARD
Mayor and Common Council on the Day of ,20
The Following Vote To-Wit: Absent
Ayes
Noes
City Clerk
CITY OF SAN BERNARDINO—Finance Department
DISTRIBUTION:WHITE—City Clerk CANARY—Payroll
CITY OF SAN BERNARDINO
PAYROLL SUMMARY REPORT
PERIOD ENDING DATE 1/4/A, DATE PAID / 4.-t; PP No. / 3
CHECK NUMBERS USED: /3�3 1,57 /3.51046 &617093,2
CHECK NUMBERS VOIDED: 1 �? /2J— /3?'S 2-e
CHECK NUMBERS CANCELLED: / g'71' , 0Y3'
EARNINGS:
Regular Gross:
//,c2/3 C9$. 7
Adjustments:
Total Adjusted Gross Payroll /, 2-/3/ Ozi 17
DEDUCTIONS:
Ar
Total (Without Adjustments)
Adjustments:* C� 5�
Total Adjusted Deductions Od a, 52)5-, �q
N , } Net Payroll
a N ("C. APPROVALS FOR PAYMENT
DIR R OF FINANCE SECRETARY OF CIVIL SERVICE BOARD
Mayor and Common Council on the Day of ,20
The Following Vote To-Wit: Absent
Ayes
Noes
City Clerk
CITY OF SAN BERNARDINO—Finance Department
DISTRIBUTION:WHITE—City Clerk CANARY--Payroll
CITY OF SAN BERNARDINO
PAYROLL SUMMARY REPORT
PERIOD ENDING DATE /S/,2 ' DATE PAID 1424z,/ PP No. /7/93 i
CHECK NUMBERS USED: / ..:302 3 bp = %3.;.- 3/7T
CHECK NUMBERS VOIDED: /3 367 g' 1/.3� 3
CHECK NUMBERS CANCELLED: 0 r
EARNINGS: ��
Regular Gross: 7/ 1(X) • ir
<;}..: .. Ac tments:
r/ ;'.# Total Adjusted Gross Payroll 1, / OO, 00 -act
DEDUZ!ONv C)
9 Tc (Without Adjustments) (4 ( j q y. '7
'_- _Adjustments:
E,3 �/
Total Adjusted Deductions 40, ) -! 7< 170
Net Payroll 90—C: -.5 0
APPROVALS FOR PAYMENT
616' CR OF FINANCE SECRETARY OF CIVIL SERVICE BOARD
Mayor and Common Council on the Day of ,20
The Following Vote To-Wit: Absent
Ayes
Noes
City Clerk
CITY OF SAN BERNARDINO—Finance Department
DISTRIBUTION:WHITE—City Clerk CANARY—Payroll
CERTIFICATE
OF
DECLARATION
STATE OF CALIFORNIA
ss.
COUNTY OF SAN BERNARDINO )
I, the Director of Finance of the City of San Bernardino, the undersigned
declare:
That the attached Register of Demands dated MAY 29, 2012
has been audited as required by Sections 37202 and 37208 of the Government Code and
San Bernardino City Resolution No. 11549; said demands are accurate and correct; that
there are adequate funds to pay the demands in the bank pursuant to the Bank Balance
Adjustment Reports.
Executed on MAY 29, 2012 at San Bernardino,
California.
I declare under penalty of perjury that the foregoing is true and correct.
Director of Finance
DISTRIBUTION: WHITE—City Clerk YELLOW—Treasurer
City of San Bernardino
Finance Department
ACCOUNTS PAYABLE SUMMARY
Date Paid MAY 29, 2012
Claim Register Number #57 2011/2012
Check No. 822367 Through 822619
Void: No.
Check No. No.
Total Amount Approved $ 1,056,774.10
Approved for Payment:
Director of Finance 1_ :�1 c.e m
Mayor and Common Council on the Day of 19
By the following vote to-wit: AYES
NOES
Absent:
City Clerk
REGISTER 1,056,774.10
Distribution: WHITE-City Clerk CANARY-Treasurer PINK-Cash Reconcile GOLD-AP REGISTER CEr'rrw.°f SANnrBc n'�D1ce"s
FINC-3.01 0-00)
#58
CERTIFICATE
OF
DECLARATION
STATE OF CALIFORNIA
ss.
COUNTY OF SAN BERNARDINO )
I, the Director of Finance of the City of San Bernardino, the undersigned
declare:
That the attached Register of Demands dated JUNE 5, 2012
has been audited as required by Sections 37202 and 37208 of the Government Code and
San Bernardino City Resolution No. 11549; said demands are accurate and correct; that
there are adequate funds to pay the demands in the bank pursuant to the Bank Balance
Adjustment Reports.
Executed on JUNE `: 9012 at San Bernardino,
California.
I declare under penalty of perjury that the foregoing is true and correct.
41■{1(11C(IDTh
Director of Finance
DISTRIBUTION: WHITE—City Clerk YELLOW—Treasurer
•
City of San Bernardino
Finance Department
ACCOUNTS PAYABLE SUMMARY
Date Paid JUNE 5, 2012
Claim Register Number #58 2011/2012
Check No. 822620 Through 822842
Void: No.
Check No. No.
Total Amount Approved $ 770,813.27
Approved for Payment:
Director of Finance ---��
Mayor and Common Council on the Day of 19
By the following vote to-wit: AYES
NOES
Absent:
City Clerk
REGISTER $826,563.15
CANCELLED $( 55,749. 88)
TOTAL $770, 813. 27
Distribution: WHITE-City Clerk CANARY-Treasurer PINK-Cash Reconcile GOLD-AP REGISTER CITY OF SAN SERNARICES
FINC-3.ot 14-901 CITY a P SAN NARDINS
CERTIFICATE
OF
DECLARATION
STATE OF CALIFORNIA
ss.
COUNTY OF SAN BERNARDINO )
I, the Director of Finance of the City of San Bernardino, the undersigned
declare:
That the attached Register of Demands dated JUNE 6, 2 012
has been audited as required by Sections 37202 and 37208 of the Government Code and
San Bernardino City Resolution No. 11549; said demands are accurate and correct;that
there are adequate funds to pay the demands in the bank pursuant to the Bank Balance
Adjustment Reports.
Executed on JUNE 6, 2 012 at San Bernardino,
California.
I declare under penalty of perjury that the foregoing is true and correct.
Akxi
Director of Finance
DISTRIBUTION: WHITE—City Clerk YELLOW—Treasurer
•
City of San Bernardino
Finance Department
ACCOUNTS PAYABLE SUMMARY
Date Paid JUNE 6, 2012
Claim Register Number #59 2011/2012
Check No. 822843 Through 822843
Void: No.
Check No. No.
Total Amount Approved $ 999,730. 00
Approved for Payment: 4 ---
Director of
Finance
Mayor and Common Council on the Day of 19.
By the following vote to-wit: AYES
NOES
Absent:
City Clerk
REGISTER 1,000,000. 00
CANCELLED (270. 00)
TOTAL 999,730. 00
Distribution: WHITE-City Clerk CANARY-Treasurer PINK-Cash Reconcile GOLD-AP REGISTER CITY of SAN BG SERVICES
FINC3.01 (4-901 CENTRAL PPoNT BERNAR INO
CERTIFICATE
OF
DECLARATION
STATE OF CALIFORNIA )
. ss.
COUNTY OF SAN BERNARDINO )
I, the Director of Finance of the City of San Bernardino, the undersigned
declare:
That the attached Register of Demands dated JUNE 7, 2012
has been audited as required by Sections 37202 and 37208 of the Government Code and
San Bernardino City Resolution No. 11549; said demands are accurate and correct;that
there are adequate funds to pay the demands in the bank pursuant to the Bank Balance
Adjustment Reports.
Executed on JUNE 7, 2012 at San Bernardino,
California.
I declare under penalty of perjury that the foregoing is true and correct.
Director of Finance
DISTRIBUTION: WHITE—City Clerk YELLOW—Treasurer
City of San Bernardino
Finance Department
ACCOUNTS PAYABLE SUMMARY
Date Paid JUNE 7, 2012
Claim Register Number #60 2011/2012
Check No. 822844 Through 827846
Void: No.
Check No. No.
Total Amount Approved $ 982,643. 00
Approved for Payment:
Director of Finance jaJU
Mayor and Common Council on the Day of 19
By the following vote to-wit: AYES
NOES
Absent:
City Clerk
REGISTER 982,643. 00
Distribution: WHITE-City Clerk CANARY-Treasurer PINK-Cash Reconcile GOLD-AP REGISTER GJ M SAN eG SERVICES ES
FINC-3.Ot 14-901 `E""iALP1°N""c�gN6
CERTIFICATE
OF
DECLARATION
STATE OF CALIFORNIA )
ss.
COUNTY OF SAN BERNARDINO )
I, the Director of Finance of the City of San Bernardino, the undersigned
declare:
That the attached Register of Demands dated JUNE 12, 2012
has been audited as required by Sections 37202 and 37208 of the Government Code and
San Bernardino City Resolution No. 11549; said demands are accurate and correct;that
there are adequate funds to pay the demands in the bank pursuant to the Bank Balance
Adjustment Reports.
Executed on JUNE 12, 2012 at San Bernardino,
California.
I declare under penalty of perjury that the foregoing is true and correct.
Director of Finance
DISTRIBUTION; WHITE—City Clerk YELLOW—Treasurer
City of San Bernardino
Finance Department
BANK BALANCE ADJUSTMENT REPORT
Month: JUNE Page Number: 61
Account Name: Commercial Date: JUNE 12, 2012
Account Number: 206-698-020 Reporting Period: 2011/2012
Book Balance Forward: 50,000.00
• Deposits—Total Amount: + 1,006,628. 02
• New Checks—Total Amount: - 1, 006,628. 02
Check Numbers
822847 thru 823179
• Checks Cancelled—Total Amount: + –0–
Check Numbers:
• Checks Voided—Amount as Applicable
Check Numbers: + –0–
SUB TOTAL 50,000.00
Bank Adjustments:
*New Book Balance I 50,000.00 I
Submitted By LINDA SOUTH
Approved By l�lt� � _ '
. _.
'Carry forward to next page
CITY OF SAN BERNAROINO
CENTRAL PRINTING SERVICES
Distribution — WHITE-Treasurer CANARY-Check File PINK-AP File GOLD-Cash Reconcile FINC-3.02 (1.96)
City of San Bernardino
Finance Department
ACCOUNTS PAYABLE SUMMARY
Date Paid JUNE 12, 701
Claim Register Number #61 2011/2012
Check No. 822847 Through
Void: No.
Check No. No.
Total Amount Approved $ 1,006,628. 02
Approved for Payment: -,
Director of Finance
Mayor and Common Council on the
Day of 19.
By the following vote to-wit: AYES
NOES
Absent:
City Clerk
REGISTER 1,006,628.02
Distribution: WHITE-City Clerk CANARY-Treasurer PINK-Cash Reconcile GOLD-AP REGISTER FINC-3.ot (4-90) CEN1TIAI MOOING SERVICES
•
#62
CERTIFICATE
OF
DECLARATION
STATE OF CALIFORNIA
ss.
COUNTY OF SAN BERNARDINO )
I, the Director of Finance of the City of San Bernardino, the undersigned
declare:
That the attached Register of Demands dated JUNE 19, 2012
has been audited as required by Sections 37202 and 37208 of the Government Code and
San Bernardino City Resolution No. 11549; said demands are accurate and correct;that
there are adequate funds to pay the demands in the bank pursuant to the Bank Balance
Adjustment Reports.
Executed on JUNE 1 9, 2 01 2 at San Bernardino,
California.
I declare under penalty of perjury that the foregoing is true and correct.
Director of Finance
DISTRIBUTION: WHITE—City Clerk YELLOW—Treasurer
City of San Bernardino
Finance Department
ACCOUNTS PAYABLE SUMMARY
Date Paid JUNE 19, 2012
Claim Register Number
#62 2011/2012
Check No.
823180 Through 823409
Void: No.
Check No. No.
Total Amount Approved $ 844,770. 59
Approved for Payment:
Director of Finance
Mayor and Common Council on the Day of 19
By the following vote to-wit: AYES
NOES
Absent:
City Clerk
REGISTER $ 846,913.14
CANCELLED (2,142. 55)
TOTAL $ 844,770. 59
G7Y OF SAN OEgNARGNO
Distribution: WHITE-City Clerk CANARY-Treasurer PINK-Cash Reconcile GOLD-AP REGISTER FINC-3.01 (4-901 CENTRAL AMINE NARESNS
;;,.
Finah+ � t
z <� ;; p+
vi a, 1.\ 'f ,, +A ., y \ X :,.:',.,..'1.yam ,
' ,dr �k . `
f,r t ^';'t ' r#sr
1 W9y}C+ Z,,a i ".'1.'',,i,,,=;
.. '�" .,1+ -r
r
'rY
i^'1 f f r % Y`t s ; " � �A,f,--.. I v v,r ' S - S• 2, t_is '.1 i."1!J.,, ., ,- , .-- { y i d { 1 L A
cyr .1 .t5 :` >. .i2.k'''-r',.'t'-,,.,4 _ _ - .. ,a
f+F` 1: �
';-:::::',,`,,i.,.;'.'1-, a >, f ry r St ��,r.e L.d
-
--:'1'-''' II - f , r r ?' L•
'+ `A 4 ..:f4".-='
; �1f: s Sri lE`� . E �� ,yt �,• �z� } .-..'1;.:1.".i":-. a x�r.
:► xx ::::::-71.:;-4
= 1•s - .. ,'!t -i- ''-- A L 4kyf k u
I ' 1 i I r,-.--,;e.
r C k � •ter n l 'fiat''� 6 �.
[:.- { # •+y. 4 r, .•4'�ir 3 �'4` R 'f "�t �` i!y, 1
<
s..
� ` k (�i 0.0 '1 „ _ .,"ms < x :a,.' Y '• -' e
' qFF` -'is` l ( CF
f t- .,s �' K 4F��.7s.i9�:!\r+�"���',lu7�fi�. ,.bs•ran.�s.�.`C �_I �S J '... z x
"3 f s :.s si 1 ai,`" t .-� •°•tee-Hr {
r. •
IY :Yr�> t ''yy��..�� r, y •� 7►+ ��fiti eQ-,..'+szi 1,...314;.:%.?i' 0 r' "1e 7' '; 4: - #`'`
4 k c ,
i,a' foin+vatd l»nextplpe cnv ov a�n a wwoeb
ctinn�►fnr+rrx+eEmn�s
plbfflbutw +-WHITE.4001,10'
r.RWN1 CANMAY-t:Mck RIO PINK•APRs GOLD•Cash RecOnc FiNC 3.Q2 11.86) •