City of Placentia
CITY TREASURER"S
REPORT
June 30,, 2021
(Unaudited)
FISCAL YEAR
2020-2021
&ftd
PLACENTIA
At L AMERICA CITY
ATTACHMENT 2
CITY OF PLACENTIA
CASH AND INVESTMENT DETAIL- CITY
For the Month of lune 2021
P L A C E N T I A
FINANCE
DEPA RTN%ENT
Submitted By:
JpOpKlErlart55lerlm Finance Director
Approved By: Kevin A. Larson, City Treasurer
/--1
Date
1/18/2022
Date
ATTACHMENT 2
Agency Investment Current Purchase Maturity Purchase Market Description Yield Date Date Price Value
.CASH:
Bank of America - General Checking
Account No.
N/A
N/A
On Demand'
$ 61,758.80
$ 61,758.80
XXXXXX-0221
Bank of America - Workers' Comp
Account No.
N/A
N/A
On Demand
$ 24,266.30
$ 24,266.30
XXXXXX-0525
Bank of America - Healthcare
Account No.
N/A
N/A
On Demand
$ 2,184.84
$ 2,184.84
XXXXXX-0513
Banc of California - Successor Agency
Account No.
N/A
N/A
On Demand
$ 2,598,348.20
$ 2,598,348.20
XXX -XXX -2728
Banc of California - General Checking
Account No.
N/A
N/A
On Demand
$ 5,814,523.13
$ 5,814,523.13
XXX -XXX -2660
Total Cash
$ 8,501,081.27
$ 8,501,081.27
INVESTMENTS:
Local Agency Investment Fund
City Account
1.79%
N/A
On Demand
$ 26,104,350.86
$ 26,104,3SO.86
No. XX -XX -XXX
Time Value Investments
Money Market
0.03%
N/A
On Demand
$ 7,239.42
$ 7,239.42
Time Value Investments
Certificate of Deposit
'Various
Various
Various
$ 495,000.00
$ 496,945.21
Time Value Investments
US GovernmentBonds
Various
Various
Various
$ 1,000,000.00
$ 995,635.00
Total Investments
$ 26,606,590.28
$ 26,608,535.49
TOTAL CASH & INVESTMENTS HELD BY CITY
$ 35,107,671.55
$ 35,109,616.76
---------------
HELD BY
Agency Investment Current Purchase Maturity
Purchase
Market
Description Yield Date Date
Price
Value
2011 Gas Tax Certificates of Participation
Wells Fargo
Wells Fargo Money
0.03%
N/A
N/A
$ $
Market
2013 Tax Allocation Refunding Bond
US Bank First American
0.01%
N/A
N/A
$ 829,501.38
$ 829,501.38
Treasury Fund
:2003 Certificate of Participation
US Bank
US Bank Money
0.03%
N/A
N/A
$ 556,083.55
$ 556,083.55
Market
2020A Lease Revenue Bond - Pension
US Bank First American 0.01%
N/A
N/A
$ 6,542,028.61
$ 6,542,028.61
Treasury Fund
TOTAL INVESTMENTS HELD BY FISCAL AGENT $ 7,927,613.54
$ 7,927,613.54
Cash & Investments Field by Cty and Fiscal Agent - Market Value $ 43,037,230.30 Submitted By:
JpOpKlErlart55lerlm Finance Director
Approved By: Kevin A. Larson, City Treasurer
/--1
Date
1/18/2022
Date
ATTACHMENT 2
CITY OF PLACENTIA
BANK RECONCILIATION
For the Month of June 2021
RPT
FUND
NO.
Data
FUND
NO.
FUND
GIL
BALANCE
END BALANCE PER BANK
TOTAL
101
10 GENERAL FUND
11,993,177.98
Bank of America Checking/CITY 0221
61,758 80
105
11 POOLED CASH
104.00
Bank of America Checking/CITY 0525
24,266.30
201
16 UTILITY TAX FUND
222,682.26
Bank of America Checking/CITY 0513
2,184.84
205
17 GAS TAX FUND
(44,534.00)
Bank of California Checking/CITY 2660
5,814,523 13
210
18 MEASURE "M" FUND
568,622.94
Bank of California Checking/CITY 2677
-
215
19 AIR QUALITY FUND
135,468.03
Bank of California Checking/CITY 2694
225
21 ASSET SEIZURE FUND
363,829.21
Bank of California Checking/CITY 2711
230
22 COPS/SUPPL LAW ENFORCE. FUND
176,761 39
Bank of California Checking/SA 2728
2,598,348.20
235
23 PARK DEVELOPMENT FUND
20,072.70
Bank of California Checking/CITY 2745
240
24 SEWER CONSTRUCTION FUND
21,890.90
Local Agency Investment Fund
26,104,350.86
244
68 CW AFORD HOUSING IMPACT FEE FUND
1,424,000.00
Certificates of Deposit
1,499,819.63
245
25 STORM DRAIN CONSTRUCTION FUND
24,423.28
Less: Unrecorded Gain
203.79
250
26 THOROUGHFARE CONST. FUND
5,496.55
Less: A/P CIS Checks
(268,367.73)
255
27 UNDERGROUND UTILITIES
(737.06)
Less: Payroll CIS Checks
(7,825.34)
260
28 PLACENTIA LIGHTING DISTRICT FUND
(93,432.46)
Less: EP O/S Checks
(216.46)
265
29 LANDSCAPE MAINT. DISTRICT
(14,126.15)
Less: Worker's Comp CIS Checks
(30,569.29)
270
30 HOUSING & COMMUNITY DEVELOP.
(62,358.71)
Less: Bank Deposits in Transit
159,459.70
401
33 CAPITAL PROJECTS FUND
(349,568.33)
Transfer from 2660 to 2694 (in transit)
(29 12)
405
34 IN -LIEU LOW/MOD HOUSING FUND
54,659.63
Transfer from 2660 to 2677 (in transit)
501
37 REFUSE FUND
490,822.18
Transfer from 2660 to 2711 (in transit)
601
39 HEALTH & WELFARE INS. FUND
32,325.62
605
40 RISK MANAGEMENT FUND
1,925,569.15
35,957,907.31
610
41 EQUIPMENT REPLACEMENT FUND
38,876.87
701
44 SPECIAL DEPOSITS
1,190,680.38
705
45 HCD REHABILITATION LOANS
290.47
715
47 COMMUNITY FAC. DISTRICT FUND
48,678.07
275
48 SEWER MAINTENANCE FUND
786,830 57
425
49 ORANGETHORPE CORRIDOR
168.00
280
50 MISC. GRANTS FUND
(39,796.33)
226
51 TRAFFIC OFFENDER FUND
4,543.34
206
52 GAS TAX BOND FUND
78,395.82
207
53 HOUSING AGENCY FUND
266,863.82
208
54 SUCCESSOR AGENCY FUND
622,568 88
261
55 PUBLIC SAFETY CFD 2014-01 FUND
29,559.22
241
57 PUBLIC SAFETY MITIGATION FUND
(34,129.59)
211
58 PEG FUND
(40,947.75)
116
59 REHAB REIMBURSEMENTS FUND
3,09550
209
60 GAS TAX - RMRA FUND
968,923.01
228
61 NOC-PUBLIC SAFETY GRANT FUND
171,576.19
229
62 COMM. BASED TRANS. GRANT FUND
(104,309.65)
236
63 PARKS & RECREATION IMPACT FEES
1,993,080.52
PREPARED BY:
238
65 CITY TRAFFIC IMPACT FEES FUND
212,213.17
239
66 CW STORMDRAIN IMPACT FEE
12,308.43
DATE:
242
67 CITY PUB. SAFETY IMPACT FEE FUND
322,250.21
243
69 CITY QUIMBY IN LIEU FEE
919,224.45
246
70 TOD TRAFFIC IMPACT FEES
749,379.56
247
71 TOD SEWER IMPACT FEES FUND
1,615,969.34
APPROVED BY:
248
72 TOD STREETSCAPE IMPACT FEE
1,309,715.19
224
73 ASSET SEIZURE 15% TRAINING
-
DATE:
233
74 GENERAL PLAN UPDATES
707,334.81
234
75 TECHNOLOGY IMPACT FEES
354,853.44
227
76 EXPLORER GRANT NOC FUND
167,367.14
281
77 OCATT FUND
(224.88)
231
78 PLACENTIA REG NAV CENTER
(821,745.01)
117
79 MEASURE U
7,528,541.23
118
81 COVID-19 RELIEFT FUNDS
302
82 PLANCENITA PUBLIC FINANCING AUTH
Pending Journal Entries 623.78
Timing Differences -
p� C� b lwea L nk $ 35,957,907.31
2021-06 Bank Reconciliation Worksheets Reconciliation $ 3 of4
ATTACHMENT
CITY OF PLACENTIA
Changes In Cash Balances
For the Month of June 2021
118 81 COVID-19RELIEFTFUND5
302 82 PLANCENITA PUBLIC FINANCING AUTH
TOTAL PER GENERAL LEDGER 33,273,498,52 7,503,041.14 (4,824,609.40) 5,353.27 35,957,283.53 623.78 35,957,907.31 "Journal entries may include interest income, budgeted transfers between funds, and expenses such as E -V Spark payments and bank Fees ATTACHMENT 2
POSTED
ADJ CASH
RPT
Data
CASH BALANCE
JOURNALS &
BITECH CASH PENDING
BALANCE
FUND FUND FUND
5/5112021
RECEIPTS
DISBURSEMENTS
VOIDS
6/20/20n JOURNAL ENTRIE5'
6/90/2021
101
10 GENERAL FUND
12,817,838.67
1,892,556.31
(2,722,502.57)
5,285.57
11,993,177.98 623.78
11,993,8D1.76
105
11 POOLED CASH
104.00
-
-
104-00
104.00
201
16 UTILITY TAX FUND
222,682.26
_
_
222,682-26 -
222,682.26
205
17 GAS TAX FUND
(222,200.99)
186,809.91
(9,142.92)
-
(44,534.00) -
(44,534.00)
210
18 MEASURE "M" FUND
613,707.00
(45,084.06)
566,622.94
568,622.94
215
19 AIR QUALITY FUND
118,225.81
17,242.22
-
-
135,468.03
135,468.03
225
21 ASSET SEIZURE FUND
386,383.14
(22,621.63)
67-70
363,62921
363,829.21
230
22 COPS/SUPPL LAW ENFORCE. FUND
176,717.41
43.98 -
176,761.39
176,761.39
235
23 PARK DEVELOPMENT FUND
20,072.70
-
20,072.70
20,072.70
240
24 SEWER CONSTRUCTION FUND
21,890.90
21,890.90
21,890.90
244
68 CW AFORD HOUSING IMPACT FEE FUND
1,424,000.00
-
-
1,424,000-00 -
1,424,000.00
245
25 STORM DRAIN CONSTRUCTION FUND
24,423.28
-
24,423.26
24,423.28
250
26 THOROUGHFARE CONST. FUND
5,496.55
-
5,496.55
5,496.55
255
27 UNDERGROUND UTILITIES
(737.06)
(737.06)
(737.06)
260
28 PLACENTIA LIGHTING DISTRICT FUND
(13,543.14)
-
(79,869.32)
(93,432.46) -
(93,432.46)
265
29 LANDSCAPE MAINT. DISTRICT
23,820.64
-
(37,94679)
-
(14,126.15)
(14,126.15)
270
30 HOUSING & COMMUNITY DEVELOP
(62,358.71)
-
-
-
(62,358-71)
(62,358,71)
401
33 CAPITAL PROJECTS FUND
(340,465.66)
(9.10267)
(349,568.33)
(349,568.33)
405
34 IN -LIEU LOW/MOD HOUSING FUND
54,659.63
-
-
-
54,659.63
54,659.63
501
37 REFUSE FUND
763,422.74
37,533.06
(310,13364)
490,822.18
490,822.18
601
39 HEALTH & WELFARE INS. FUND
110,791.65
52.57 (78,516.60)
-
32,325.62 -
32,325.62
605
40 RISK MANAGEMENT FUND
2,150,053.98
32,627.18
(257,112-01)
1,925,569.15
1,925,569.15
610
41 EQUIPMENT REPLACEMENT FUND
38,876.87
-
-
38,876.87
38,876.87
701
44 SPECIAL DEPOSITS
1,163,466.45
36,824.26
(9,610.33)
-
1,190,680.38
1,190,680,38
705
45 HCD REHABILITATION LOANS
290.47
-
-
290-47
290.47
715
47 COMMUNITY FAC, DISTRICT FUND
48,678.07
-
-
48,678.07 -
48,678.07
275
48 SEWER MAINTENANCE FUND
773,295.12
57,329.28
(43,793.83)
-
786,830.57 -
786,830.57
425
49 ORANGETHORPE CORRIDOR
168.00
-
-
168.00 -
168.00
280
50 MISC. GRANTS FUND
(30,683.04)
12,305.50
(21,418.79)
(39,796.33) -
(39,796.33)
226
51 TRAFFIC OFFENDER FUND
4,543.34
4,543.34 -
4,543.34
206
52 GAS TAX BOND FUND
79,178.82
-
(783.00)
-
78,395.82 -
78,395.82
207
53 HOUSING AGENCY FUND
265,030.48
1,83334
-
-
266,863.82 -
266,863.82
208
54 SUCCESSOR AGENCY FUND
830,616.82
-
(208,04794)
622,568, BB -
622,568.88
261
55 PUBLIC SAFETY CFD 2014-01 FUND
29,559.22
-
-
29,559.22 -
29,559.22
241
57 PUBLIC SAFETY MITIGATION FUND
(34,129.59)
-
(34,129.59)
(34,129.59)
211
58 PEG FUND
(28,384.35)
-
(12,563.40)
(40,947.75) -
(40,947.75)
116
59 REHAB REIMBURSEMENTS FUND
3,095.50
-
3,095.50
3,095.50
209
60 GAS TAX - RMRA FUND
894,980.39
73,942.62
968,923.01
968,923.01
228
61 NOC-PUBLIC SAFETY GRANT FUND
188,701.95
-
(17,125.76)
-
171,576.19 -
171,576.19
229
62 COMM. BASED TRANS. GRANT FUND
(104,309.65)
-
(104,309.65) -
(104,309.65)
236
63 PARKS & RECREATION IMPACT FEES
1,993,080.52
_
1,993,080.52
1,993,080.52
238
65 CITY TRAFFIC IMPACT FEES FUND
212,213.17
212,213.17
212,213.17
239
66 CW STORMDRAIN IMPACT FEE
12,308.43
-
12,308.43
12,308.43
242
67 CITY PUB. SAFETY IMPACT FEE FUND
423,997.87
-
(101,747.66)
322,250.21
322,250.21
243
69 CITY QUIMBY IN LIEU FEE
919,224.45
-
-
919,224.45
919,224.45
246
70 TOD TRAFFIC IMPACT FEES
749,379.56
-
749,379.56 -
749,379.56
247
71 TOD SEWER IMPACT FEES FUND
1,615,969.34
-
-
1,615,969.34
1,615,969.34
248
72 TOD STREETSCAPE IMPACT FEE
1,309,715.19
-
-
1,309,715.19
1,309,715.19
224
73 ASSET SEIZURE 15% TRAINING
233
74 GENERAL PLAN UPDATES
695,089.40
12,382.41
(117.00)
-
707,334 81 -
707,334.81
234
75 TECHNOLOGY IMPACT FEES
348,935,19
5,986.50
(68.25)
-
354,85344 -
354,853.44
227
76 EXPLORER GRANT NOC FUND
168,440.40
(1,073.26)
167,367.14
167,367.14
281
77 OCATT FUND
(224.88)
(224.68)
(224.88)
231
78 PLACENTIA REG NAV CENTER
(287,843.01)
-
(533,902.00)
-
(821,745.01) -
(821,745.01)
117
79 MEASURE U
2,695,253.22
5,135,591 98
(302,303.97)
-
7,528,541 23 -
7,528,54123
118 81 COVID-19RELIEFTFUND5
302 82 PLANCENITA PUBLIC FINANCING AUTH
TOTAL PER GENERAL LEDGER 33,273,498,52 7,503,041.14 (4,824,609.40) 5,353.27 35,957,283.53 623.78 35,957,907.31 "Journal entries may include interest income, budgeted transfers between funds, and expenses such as E -V Spark payments and bank Fees ATTACHMENT 2