City of Placentia
CITY TREASURER'S
REPORT
September 30, 2021
(Unaudited)
FISCAL YEAR
2021-2022
ATTACHMENT 3
CITY OF PLACENTIA
CASH AND INVESTMENT DETAIL - CITY
For the Month of September 2021
PLACENTIA
FINANCE
DEPARTMENT
HELD BY CITY
I
ICASH:
Bank of America - General Checking
iBank
of America - Workers' Comp
Bank of America - Healthcare
Banc of California - Successor Agency
Banc of California - General Checking
Total Cash
Agency
1 INVESTMENTS:
Local Agency Investment Fund
Time Value Investments
Time Value Investments
Time Value Investments
Total Investments
TOTAL CASH & INVESTMENTS HELD BY CITY
Agency
2013 Tax Allocation Refunding Bond
US Bank
12003 Certificate of Participation
1USBank
12020A Lease Revenue Bond - Pension
US Bank
Investment
Description
Account No.
XXXXXX-0221
Account No.
XXXXXX-0525
Account No.
XXXXXX-0513
Account No.
XXX -XXX -2728
Account No.
XXX -XXX -2660
City Account
No. XX -XX -XXX
Current
Yield
Purchase Maturity
Date I Date
Purchase Market
Price Value
N/A N/A On Demand $ 57,622.70 $ 57,622.70
N/A N/A On Demand $ 24,266.30 $ 24,266.30
N/A N/A On Demand $ 2,184.84 $ 2,184.84
N/A N/A On Demand $ 2,598,348.20 $ 2,598,348.20
N/A N/A On Demand $ 4,084,983.95 $ 4,084,983.95
$ 6,767,405.99 $ 6,767,405.991
Quantity Market Value
1.79% N/A an Demand $ 26,118,218.32 $ 26,118,218.32
Money Market 0.03% N/A On Demand $ 11,440.94 $ 11,440.94 Certificate of Deposit Various Various Various $ 496,000.00 $ 497,001.92 f US Government Bonds Various Various Various $ 1,000,000.00 $ 993,705.00 $ 27,625,659.26 $ 27,620,366.18
$ 34,393,065.25 $ 34,387,772.17
HELD BY FISCAL AGENT
Investment
Description
First American
Current Purchase
Yield Date
Treasury Fund ' 0.01% N/A
US Bank Money
Market
0.03%
N/A
First American
Treasury Fund 0.01% N/A
!TOTAL INVESTMENTS HELD BY FISCAL AGENT
1 Cash & Investments Held by City and Fiscal Agent - Market Value Maturity
Date
N/A
N/A
Purchase Market
Price Value
21.801 $
$ 488,521.23
21.80 $ 488,521.23
N/A $ 6,452,127.53 $ 6,452,127.53
$ 6,940,670.56 $ 6,940,670.56
$ 41,323,442.73
Submitted By: i
lrErland n[erim Finance Director Date
Approved By: Kevin A Larson, City Treasurer Date
///
ATTACHMENT 3
RPT Data
FUND FUND
NO. NO.
FUND
101 10 GENERAL FUND
105 11 POOLED CASH
201 16 UTILITY TAX FUND
205 17 GAS TAX FUND
210 18 MEASURE "M"FUND
215 19 AIR QUALITY FUND
225 21 ASSET SEIZURE FUND
230 22 COPS/SUPPL LAW ENFORCE. FUND
235 23 PARK DEVELOPMENT FUND
240 24 SEWER CONSTRUCTION FUND
244 68 CW AFORD HOUSING IMPACT FEE FUND
245 25 STORM DRAIN CONSTRUCTION FUND
250 26 THOROUGHFARE CONST. FUND
255 27 UNDERGROUND UTILITIES
260 28 PLACENTIA LIGHTING DISTRICT FUND
265 29 LANDSCAPE MAINT. DISTRICT
270 30 HOUSING & COMMUNITY DEVELOP.
401 33 CAPITAL PROJECTS FUND
405 34 IN -LIEU LOW/MOD HOUSING FUND
501 37 REFUSE FUND
601 39 HEALTH & WELFARE INS. FUND
605 40 RISK MANAGEMENT FUND
610 41 EQUIPMENT REPLACEMENT FUND
701 44 SPECIAL DEPOSITS
705 45 HCD REHABILITATION LOANS
715 47 COMMUNITY FAC. DISTRICT FUND
275 48 SEWER MAINTENANCE FUND
425 49 ORANGETHORPE CORRIDOR
280 50 MISC. GRANTS FUND
226 51 TRAFFIC OFFENDER FUND
206 52 GAS TAX BOND FUND
207 53 HOUSING AGENCY FUND
208 54 SUCCESSOR AGENCY FUND
261 55 PUBLIC SAFETY CFD 2014-01 FUND
241 57 PUBLIC SAFETY MITIGATION FUND
211 58 PEG FUND
116 59 REHAB REIMBURSEMENTS FUND
209 60 GAS TAX - RMRA FUND
228 61 NOC-PUBLIC SAFETY GRANT FUND
229 62 COMM. BASED TRANS. GRANT FUND
236 63 PARKS & RECREATION IMPACT FEES
238 65 CITY TRAFFIC IMPACT FEES FUND
239 66 CW STORMDRAIN IMPACT FEE
242 67 CITY PUB. SAFETY IMPACT FEE FUND
243 69 CITY QUIMBY IN LIEU FEE
246 70 TOD TRAFFIC IMPACT FEES
247 71 TOD SEWER IMPACT FEES FUND
248 72 TOD STREETSCAPE IMPACT FEE
233 74 GENERAL PLAN UPDATES
234 75 TECHNOLOGY IMPACT FEES
227 76 EXPLORER GRANT NOC FUND
281 77 OCATT FUND
231 78 PLACENTIA REG NAV CENTER
117 79 MEASURE U
118 81 COVID-19 RELIEFT FUNDS
302 82 PLANCENITA PUBLIC FINANCING AUTH
Pending Journal Entries
Timing Differences
Difference between GL & Bank
CITY OF PLACENTIA
BANK RECONCILIATION
For the Month of September 2021
GIL
BALANCE
10,057,248.95
104.00
222,682.26
325,162A6
621,575.72
153,057.55
352,116.71
152,452,28
20,152.11
21,978.25
196,420.66
1,406,995.89
24,518.58
5,568.02
(41,510 74)
(64,183.34)
(62,962.83)
(88,756.68)
(350,441.75)
(231,718.33)
346,115 58
(363,748.44)
1,940,490.88
109,749.73
1,173,315.68
290 47
51,316 08
775,220.40
13,697.99
(150,498.15)
1,309.22
79,427.69
260,779.28
627,928.77
31,061.97
(4,896.84)
(38,344.21)
86,850.12
1,149,448.45
136,013.22
(5,117.77)
2,003,011.16
178,632.39
12,340.20
922,051.55
740,783.99
1,619,862.88
1,312,669.35
738,557.90
350,452.73
163,324.98
(60.24)
(822,183.12)
3,844,892.71
4,544,465.27
(960 00)
(2,026.89)
$ ✓ 34,546,684.75
S
2021-09 Bank Reconciliation Worksheets Reconciliation 1 of 1
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
Certificates of Deposit
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)
TOTAL
57,622.70
24,266.30
2,184.84
4,084,983.95
2,598,348.20
26,118,218.32
1,502,147.86
3,084 21
(227,594.34)
(20,000.26)
(35,877.09)
(13,735 66)
460,158.14
(238 80)
(6,883.62)
/34,546,684.75
PREPARED BY: 7f lI
DATE: (/af Z 2
APPROVED BY:
DATE:
ATTACHMENT 3
CITY OF PLACENTIA
Changes in Cash Balances
For the Month of September 2021
POSTED ADJ CASH
RPT Data CASH BALANCE JOURNALS & BITECH CASH PENDING BALANCE FUND FUND FUND 8/31/2021 RECEIPTS DISBURSEMENTS VOIDS 9/30/2021 JOURNAL ENTRIES' 9/3012021 101 10 GENERAL FUND 10,589,555.49 1.621,760.64 (2,157,136,91) 3,069.73 10,057,248.95 (2,026.89) 10,055,222.06 105 11 POOLED CASH 104.00 . 104.00 10400
201 16 UTILITY TAX FUND 222,682.26 - 222,682.26 222,682.26 205 17 GAS TAX FUND 122,16143 223,821.95 (20,820,92) 325,162.46 325,162.46 210 18 MEASURE "M" FUND 659,941.33 104,172.79 (142,53840) 621,575.72 - 621,575.72 215 19 AIR QUALITY FUND 153,057.55 153,057.55 - 153,057.55 225 21 ASSET SEIZURE FUND 352,116.71 - - - 352,116.71 352,116.71 230 22 COPS/SUPPLLAW ENFORCE FUND 152,452.28 - - - 152,452.28 152,452.28 235 23 PARK DEVELOPMENT FUND 20,152.11 20,152.11 20,152.11 240 24 SEWER CONSTRUCTION FUND 21,978.25 - 21,97825 21,978.25 245 25 STORM DRAIN CONSTRUCTION FUND 1,428,733 00 (21,73711) 1,406,995.89 1,406,995.89 250 26 THOROUGHFARE CONST. FUND 24,518.58 - 24,518.56 24,518.58 255 27 UNDERGROUND UTILITIES 5,568.02 - 5,568.02 - 5,568.02 260 28 PLACENTIA LIGHTING DISTRICT FUND (737 06) 568 20 (41,341.88) (41,510.74) (41,510.74) 265 29 LANDSCAPE MAINT. OISTRICT (41,285.90) 179.28 (23,076.72) - (64,183.34) (64,183.34) 270 30 HOUSING & COMMUNITY DEVELOP (116,943.83) 97,681,00 (43,700.00) - (62,96283) (62,962.83) 401 33 CAPITAL PROJECTS FUND (87,633.71) (1,122.97) - (86,75666) (88,756.68) 405 34 IN -LIEU LOW/MOD HOUSING FUND (350,441.75) - - (350,441.75) - (350,441.75) 501 37 REFUSE FUND 55,19170 24,906,18 (311,81621) - (231,71833) (231,718.33) 601 39 HEALTH & WELFARE INS. FUND 216,625.32 44.75 129,445.51 346.11558 - 346,115.58 605 40 RISK MANAGEMENT FUND (349,684.57) (14,063.87) - (363,748 44) - (363,748.44) 610 41 EQUIPMENT REPLACEMENT FUND 1,940,490.88 - 1,940,49088 - 1,940,490.88 701 44 SPECIAL DEPOSITS 58,032.87 63,110.54 (11,393.68) - 109,749.73 - 109,749.73 705 45 HCD REHABILITATION LOANS 1,173,315.68 - 1,173,31568 1,173,315.68 715 47 COMMUNITY FAC. DISTRICT FUND 290.47 - 29047 290.47 275 48 SEWER MAINTENANCE FUND 48,868.66 82,678.20 (80,230 76) 51,31608 - 51,316.08 425 49 ORANGETHORPE CORRIDOR 775,220.40 775,22040 775,220.40 280 50 MISC. GRANTS FUND 168.00 29,878 18 (16,348.19) 13,697.99 13,697.99 226 51 TRAFFIC OFFENDER FUND (150,498.15) (150,49815) (150,498.15) 206 52 GAS TAX BOND FUND 4,559.22 - (3,250.00) 1,309.22 1,309.22 207 53 HOUSING AGENCY FUND 78,594.35 83334 79,427.69 79,427.69 208 54 SUCCESSOR AGENCY FUND 267,863.82 (7,084.54) 260,779.28 260,779.28 261 55 PUBLIC SAFETY CFD 2014-01 FUND 627,745.91 182 86 627,928.77 627,928.77 241 57 PUBLIC SAFETY MITIGATION FUND 31,061.97 - 31,061.97 31,061.97 211 58 PEG FUND (0.59) - (4,896 25) (4,89664) - (4,896.84) 116 59 REHAB REIMBURSEMENTS FUND (38,344.21) (38.344 21) (38,344.21) 209 60 GAS TAX - RMRA FUND 7.94 86,64218 86,850.12 86,850.12 228 61 NOC-PUBLIC SAFETY GRANT FUND 1,149,448.45 1,149,448.45 1,149,448.45 229 62 COMM. BASED TRANS. GRANT FUND 136,013.22 - 136,013,22 136,013.22 236 63 PARKS & RECREATION IMPACT FEES (117.77) - (5,000.00) - (5,117.77) (5,117.77) 238 65 CITY TRAFFIC IMPACT FEES FUND 2,003,01116 - - 2,003,011.16 2,003,011.16 239 66 CW STORMDRAIN IMPACT FEE 189,590-03 - (10,957 64) 178,632.39 - 178,632.39 242 67 CITY PUB. SAFETY IMPACT FEE FUND 12,340.20 - - 12,340.20 - 12,340.20 244 68 CW AFORD HOUSING IMPACT FEE FUND 196,420.66 - 196,420,86 - 196,420.66 243 69 CITY QUIMBY IN LIEU FEE 922,051.55 922,051.55 - 922,051.55 246 70 TODTRAFFICIMPACTFEES 750,943.99 - (10,16000) - 740,783.99 - 740,783.99 247 71 TOD SEWER IMPACT FEES FUND 1,619,862.88 1,619,862,68 1,619,862.88 248 72 TOD STREETSCAPE IMPACT FEE 1,312,669.35 - 1,312,669.35 - 1,312,669.35 233 74 GENERAL PLAN UPDATES 728,245.17 10,364.65 (52.12) - 738,557,90 738,557.90 234 75 TECHNOLOGY IMPACT FEES 344,375.35 6,087-00 (962) 350,452.73 - 350,452.73 227 76 EXPLORER GRANT NOC FUND 163,324.98 163,324.98 163,324.98 281 77 OCATT FUND (60,24) - (60.24) (60.24)
231 78 PLACENTIA REG NAV CENTER (821,985.16) (19796) (822,183.12) - (822,183.12) 117 79 MEASURE U 3,216,877.67 640,365.54 (12,350 50) - 3,844,892.71 - 3,844,892.71 118 81 COVID-19 RELIEFT FUNDS 4,544,465.27 - - - 4,544,465 27 - 4,544,465.27 302 82 PLANCENITA PUBLIC FINANCING AUTH (960 00) - (960.00) (960.00) TOTAL PER GENERAL LEDGER 34,362,965.19 2,993,477.48 (2,810,800.76) 3,069.73 34,548,711.64 (2,026.89) 34,546,684.75 'Journal entries may include interest income, budgeted transfers between funds, and expenses such as E -V Spark payments and bank fees ATTACHMENT 3