City of Placentia
CITY TREASURER'S
REPORT
March 31, 2021
(Unaudited)
FISCAL YEAR
2020-2021
ATTACHMENT 1
CITY OF PLACENTIA
CASH AND INVESTMENT DETAIL - CITY
For the Month of March 2021
PLACENTIA
FINANCE
DEP4RTMEN1
HELD BY CITY
Agency
CASH:
Bank of America - General Checking
Bank of America - Workers' Comp
Bank of America - Healthcare
Banc of California - Successor Agency
Banc of California -General Checking
Multi -Bank Securities Cash Account
Total Cash
Agency
'INVESTMENTS:
Local Agency Investment Fund
Time Value Investment ("TVI")
Time Value Investment ("TVI")
Time Value Investment ("TVI")
Total Investments
TOTAL CASH & INVESTMENTS HELD BY CITY
Investment
Description
Account No.
XXXXXX-0221
Account No.
XXXXXX-0525
Account No.
XXXXXX-0513
Account No.
XXX -XXX -2728
Account No.
XXX -XXX -2660
ICash / Bank Deposits
Current
Yield
Purchase
Date
Maturity
Date
N/A N/A On Demand $
N/A N/A On Demand $
N/A N/A On Demand $
Purchase
Price
55,598.13) $
24,266.30 $
2,184.84 $
Market
Value
55,598.13
24,266.30
2,184.84
N/A N/A On Demand $ 1,957,916.20 $ 1,957,916.20
N/A N/A On Demand $ 15,023,096.45 $ 15,023,096.45
N/A N/A On Demand $
Investment Ce
Description Yieldurrnt
City Account
No. XX -XX -XXX
Government Bonds
Fixed Income
Money Market
Agency
12011 Gas Tax Certificates of Participation
Wells Fargo
201.3 Tax Allocation Refunding Bond
)US Bank
12003 Certificate of Participation
)US Bank
120204 Lease Revenue Bond - Pension
US Bank
TOTAL INVESTMENTS HELD BY FISCAL AGENT
$ 17,063,061.92 $ 17,063,061.92
Purchase Maturity Purchase Market
Date Date Quantity Value
1.79% N/A On Demand $ 10,093,324.15
Various Various Various $ 1,000,000.00
Various Various Various $ 495,000.00
Various Various Various $ 7,239-89
HELD BY FISCAL AGENT
Investment
Description
Wells Fargo Money
Market
First American
Treasury Fund
US Bank Money
Market
First American
Treasury Fund
Cash & Investments Held by City and Fiscal Agent - Market Value 10,093,324.15
991,190.00
$ 496,477.30
$ 7,239.89
$ 11,595,564.04 $ 11,588,231.34
$ 28,658,625.96 $ 28,651,293.26
Current Purchase
Yield Date
0.03% I N/A
0.01% N/A
0.03% N/A
0.01% N/A
Submitted By: Je ca Brown, Finance Director
Approved By:
Kevin A. Larson, City Treasurer
Maturity
Date
N/A
N/A
N/A
N/A
I$
)$
I$
)$
Purchase
Price
4,021,891.22) $
635,006.021 $
479,735.13) $
6,541,923.31 $
Market
Value
4,021,891.22
635,006.02
479,735.13
6,541,923.31
$ 11,678,555.68 $ 11,678,555.68
$ 40,329,848.94
Date'
8/25/2021
Date
ATTACHMENT 1
RPT Data
FUND FUND
NO. NO.
101 10
105 11
201 16
205 17
210 18
215 19
225 21
230 22
235 23
240 24
244 68
245 25
250 26
255 27
260 28
265 29
270 30
401 33
405 34
501 37
601 39
605 40
610 41
701 44
705 45
715 47
275 48
425 49
280 50
226 51
206 52
207 53
208 54
261 55
241 57
211 58
116 59
209 60
228 61
229 62
236 63
238 65
239 66
242 67
243 69
246 70
247 71
248 72
224 73
233 74
234 75
227 76
281 77
231 78
117 79
118 81
302 82
FUND
GENERAL FUND
POOLED CASH
UTILITY TAX FUND
GAS TAX FUND
MEASURE "M" FUND
AIR QUALITY FUND
ASSET SEIZURE FUND
COPS/SUPPL LAW ENFORCE. FUND
PARK DEVELOPMENT FUND
SEWER CONSTRUCTION FUND
CW AFORD HOUSING IMPACT FEE FUND
STORM DRAIN CONSTRUCTION FUND
THOROUGHFARE CONST. FUND
UNDERGROUND UTILITIES
PLACENTIA LIGHTING DISTRICT FUND
LANDSCAPE MAINT. DISTRICT
HOUSING & COMMUNITY DEVELOP.
CAPITAL PROJECTS FUND
IN -LIEU LOW/MOD HOUSING FUND
REFUSE FUND
HEALTH & WELFARE INS. FUND
RISK MANAGEMENT FUND
EQUIPMENT REPLACEMENT FUND
SPECIAL DEPOSITS
HCD REHABILITATION LOANS
COMMUNITY FAC. DISTRICT FUND
SEWER MAINTENANCE FUND
ORANGETHORPE CORRIDOR
MISC. GRANTS FUND
TRAFFIC OFFENDER FUND
GAS TAX BOND FUND
HOUSING AGENCY FUND
SUCCESSOR AGENCY FUND
PUBLIC SAFETY CFD 2014-01 FUND
PUBLIC SAFETY MITIGATION FUND
PEG FUND
REHAB REIMBURSEMENTS FUND
GAS TAX - RMRA FUND
NOC-PUBLIC SAFETY GRANT FUND
COMM. BASED TRANS. GRANT FUND
PARKS & RECREATION IMPACT FEES
CITY TRAFFIC IMPACT FEES FUND
CW STORMDRAIN IMPACT FEE
CITY PUB. SAFETY IMPACT FEE FUND
CITY QUIMBY IN LIEU FEE
TOD TRAFFIC IMPACT FEES
TOD SEWER IMPACT FEES FUND
TOD STREETSCAPE IMPACT FEE
ASSET SEIZURE 15% TRAINING
GENERAL PLAN UPDATES
TECHNOLOGY IMPACT FEES
EXPLORER GRANT NOC FUND
OCATT FUND
PLACENTIA REG NAV CENTER
MEASURE U
COVID-19 RELIEFT FUNDS
PLANCENITA PUBLIC FINANCING AUTH
Pending Journal Entries
Timing Differences
CITY OF PLACENTIA
BANK RECONCILIATION
For the Month of March 2021
2021-03 BankDecroeuebetnwearGL &e c $
econciliation
GIL
BALANCE
7,945,487.92
104.00
222,682.26
(269,144.38)
587,971.65
118,225.81
393,821.58
176,435.98
20,072.70
21,890.90
1,344,000,00
24,423.28
11,064.71
(737.06)
(15,823.91)
(88,227.52)
(427,590.48)
(402,929.79)
54,659.63
170,755.12
92,817.39
2,236,108.61
38,876.87
2,353,613.46
290.47
48,678.07
748,018.03
168.00
10,834.97
4,543.34
392,342.82
213,305.14
450,961.23
15,977.23
(34,129.59)
(38,628.88)
3,095.50
762,981.16
227,058.32
(103,857.49)
1,962,185.52
172,906.91
12,308.43
406,572.79
859,528.45
749,379.56
1,585,180.32
1,309,715.19
682,986.43
342,230.69
173,758.07
(260.43)
(281,506.67)
1,802,545.74
1,118,005.27
28,205,733.32
3of4
END BALANCE PER BANK
Bank of America Checking/CITY 0221
Bank of America Checking/CITY 0525
Bank of America Checking/CITY 0513
Bank of California Checking/CITY 2660
Bank of California Checking/CITY 2677
Bank of California Checking/CITY 2694
Bank of California Checking/CITY 2711
Bank of California Checking/SA 2728
Bank of California Checking/CITY 2745
Local Agency Investment Fund
TVI Investments
Less: Unrecorded Gain
Less: A/P O/S Checks
Less: Payroll O/S Checks
Less: EP O/S Checks
Less: Worker's Comp O/S Checks
Less: Bank Deposits in Transit
Transfer from 2660 to 2694 (In transit)
Transfer from 2660 to 2677 (in transit)
Transfer from 2660 to 2711 (in transit)
PREPARED BY:
DATE:
APPROVED BY:
DATE:
TOTAL
55,598.13
24,266.30
2,184.84
15,023,096.45
1,957,916.20
10,093,324.15
1,494,907.19
5,092.81
(525,002.82)
(12,535.23)
(161,809.85)
(10,808.32)
259,802.05
(229,00)
(69.58)
28,205,733.32
ATTACHMENT 1
CITY OF PLACENTIA
Changes in Cash Balances
For the Month of March 2021
POSTED ADI CASH
RPT Data CASH BALANCE JOURNALS & BITECH CASH PENDING BALANCE FUND FUND FUND 2/28/2021 RECEIPTS DISBURSEMENTS VOIDS 3/31/2021 JOURNAL ENTRIES' 3/31/2021 101 10 GENERAL FUND 6,191,992.61 3,707,983.59 (2,478,876 44) 524,388.16 7,945,487.92 7,945,487.92 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 520,257.94 154,24060 (9.14292) (934,50000) (269,144 313) (269,1.44.38) 210 18 MEASURE "M" FUND 645,018.63 89,031 28 (146,07826) 587,971 65 587,971.65 215 19 AIR QUALITY FUND 134,142.96 15,692 85 (31,610,00) 118,225.81 118,225.81 225 21 ASSET SEIZURE FUND 452,592.35 (58,830 77) 60.00 393,021 58 393,821.58 230 22 COPS/SUPPL LAW ENFORCE. FUND 250,975.76 460,22 (75,000.00) 176,435.98 176,435.98 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 508,000.00 836,000.00 1,344,000.00 1,344,000.00 245 25 STORM DRAIN CONSTRUCTION FUND 24,423.28 24,42326 24,423,28 250 26 THOROUGHFARE CONST. FUND 11,064.71 - - 11,064 71 11,064.71 255 27 UNDERGROUND UTILITIES (737.06) (737.06) (737.06) 260 28 PLACENTIA LIGHTING DISTRICT FUND (187,472.45) 8,514.26 (43,115.72) 206,250.00 (15,823.91) (15,823.91) 265 29 LANDSCAPE MAINT, DISTRICT (70,840.07) 29,007.10 (46,335.50) (59.05) (88,227 52) (813,227.52) 270 30 HOUSING & COMMUNITY DEVELOP. (182,905.48) (171;410.00) (73,275 00) (427,590.48) - (427,590.48) 401 33 CAPITAL PROJECTS FUND (519,654.11) (6,41794) 123,14226 (402,929 79) - (402,929.79) 405 34 IN -LIEU LOW/MOD HOUSING FUND 54,659.63 - 54,65963 54,659.63 501 37 REFUSE FUND 446,487.00 304,837.66 (580,250.10) (31944) 170,755.12 170,755.12 601 39 HEALTH & WELFARE INS. FUND (448,159.12) 52.57 (316,700.06) 857,624 00 92,817.39 92,817.39 605 40 RISK MANAGEMENT FUND 1,140,911.39 3,375.78 (71,505.06) 1,183,326.50 2,236,10861 2,236,108.61 610 41 EQUIPMENT REPLACEMENT FUND (10,018.90) 48,895.77 • 38,876.87 - 38,876.87 701 44 SPECIAL DEPOSITS 1,150,987.89 1,211,821.00 (9,19543) 2,353,613.46 2,353,613.46 705 45 HCD REHABILITATION LOANS 290.47 290.47 290.47
715 47 COMMUNITY FAC. DISTRICT FUND 48,678.07 - • 40,878 07 - 48,678.07 275 48 SEWER MAINTENANCE FUND 791,261 25 69,528.42 (33,663.55) (79,108.09) 748,018.03 748,018.03 425 49 ORANGETHORPE CORRIDOR 168.00 168.00 168.00
280 50 MISC. GRANTS FUND 11,717.45 (882.48) 10,834 97 - 10,834.97 226 51 TRAFFIC OFFENDER FUND 4,543.34 4,543 34 4,543.34 206 52 GAS TAX BOND FUND (92,157-18) 464,500.00 392,342 02 392,342.82 207 53 HOUSING AGENCY FUND 212,305.14 1,000.00 213,305.14 213,305.14 208 54 SUCCESSOR AGENCY FUND 531,769.64 (14,409.65) (66,398.76) 450,961 23 450,961.23 261 55 PUBLIC SAFETY CFD 2014-01 FUND 13,873.02 4,224 21 (2,120.00) 15,977 23 15,977.23 241 57 PUBLIC SAFETY MITIGATION FUND (34,129.59) - - - (34,129 59) - (34,129.59) 211 58 PEG FUND (31,528.88) (7,100.00) (38,628 68) (38,628.88) 116 59 REHAB REIMBURSEMENTS FUND 3,095.50 - 3,095.50 3,095.50 209 60 GAS TAX - RMRAFUND 695,985.11 88,994.05 (1,998.00) 762,98116 - 762,981.16 228 61 NOC-PUBLIC SAFETY GRANT FUND 243,855.47 (16,225.65) (571 50) 227,058.32 227,058.32 229 62 COMM. BASED TRANS. GRANT FUND (103,857.49) • (103,857.49) (103,857.49) 236 63 PARKS & RECREATION IMPACT FEES 785,390.52 1,176,795.00 - 1,962,185.52 - 1,962,185.52 238 65 CITY TRAFFIC IMPACT FEES FUND 246,321.35 1,411.00 (74,825.44) 172,906.91 - 172,906.91 239 66 CW STORMDRAIN IMPACT FEE 12,308.43 - 12,30843 - 12,308.43 242 67 CITY PUB. SAFETY IMPACT FEE FUND 58,053.37 396,761 24 (87,650.00) 39,400 18 406,572 79 - 406,572.79 243 69 CITY QUIMBY IN LIEU FEE 859,528.45 - 859,528.45 - 859,528.45 246 70 TOD TRAFFIC IMPACT FEES 225,466.42 523,913 14 - 749,37956 - 749,379.56 247 71 TOD SEWER IMPACT FEES FUND 169,838.34 1,415,341.90 - 1,585,180.32 1,585,180.32 248 72 TODSTREETSCAPE IMPACT FEE 477,711.42 832,00377 - 1,309,71519 1,309,715.19 224 73 ASSET SEIZURE 15% TRAINING .
233 74 GENERAL PLAN UPDATES 394,234.13 288,908 30 (156.00) 882,98643 - 682,986.43 234 75 TECHNOLOGY IMPACT FEES 238,305.19 167,76650 (91.00) (63,750 00) 342,230.69 - 342,230.69 227 76 EXPLORER GRANT NOC FUND 173,758.07 • 173,758.07 - 173,758.07 281 77 OCATT FUND (260.43) (260.43) (260.43)
231 78 PLACENTIA REG NAV CENTER 15,427.93 127,180 36 (413 375.96) (10,739 00) (281,506.67) (281,506.67) 117 79 MEASURE U 3,293,232.38 1,281,288.16 (193,624.80) (2,578,350.00) 1,802,545.74 1802,545.74 118 81 COVID-19 RELIEFT FUNDS 635,803.00 - (635,803 00) - 302 82 PLANCENITA PUBLIC FINANCING AUTH 25,00000 1,093,005.27 1,118,005.27 1,118,005.27 TOTAL PER GENERAL LEDGER 20,257,464.71 12,790,028.81 (4,815,590.73) (26,169.47) 28,205,733.32 28,205,733.32 "Journal entries may include interest income, budgeted transfers between funds, and expenses such as E -V Spark payments and bank fees ATTACHMENT 1