Bank Balances 06/30/23 Inflows Outflows 07/31/23
City Checking 110,012.73 112,442.41 (105,052.41) 117,402.73 City Share Account 25.36 - - 25.36
City Market Rate Account 1,359.69 1,359.69
Department Head Access Account 5.85 2,800.00 (2,666.40) 139.45 Department Head Access Savings 91.01 - - 91.01
Local Agency Investment Fund 1,521.46 - - 1,521.46
Cash on Hand 200.00 - - 200.00
113,216.10 115,242.41 (107,718.81) 120,739.70
Fund Cash Balances
General Fund 344,429.86 (96,931.13) 247,498.73
Gas Tax (Streets) Fund (24,027.68) (5,453.41) (29,481.09) Used Oil Fund 9,758.49 (496.25) 9,262.24
Revolving Loan Funds 160,138.61 39,160.38 199,298.99
Capital Projects (Grants) (207,225.39) (11,434.84) (218,660.23) Pier Fund (56,481.42) (4,410.65) (60,892.07)
Wastewater Fund (9,361.40) (68,210.39) (77,571.79)
217,231.07 - (147,776.29) 69,454.78
City of Point Arena
Schedule of Cash Balances
July 31, 2023
Type Date Num Name Memo Amount
1110 · City Checking
Issued:
Bill Pmt -Check 7/7/2023 14284 North Coast Community Planning Consulting Services - LCP Amendment (Mar & Apr 2023) $ (8,802.50) Bill Pmt -Check 7/7/2023 14285 PG&E June 2023 billings $ (5,693.46) Bill Pmt -Check 7/7/2023 14286 Ryan Process, Inc. Chlor Plus Briquettes $ (4,265.64) Bill Pmt -Check 7/17/2023 14287 A & E Porta Potty Service Inv #' 2816 $ (2,420.00) Bill Pmt -Check 7/17/2023 14288 Allied Administrators Group ID #07917-06025: 8/1/23-8/31/23 $ (665.12) Bill Pmt -Check 7/17/2023 14289 Alpha Analytical Labratories, Inc. $ (1,560.00) Bill Pmt -Check 7/17/2023 14290 Arena Theater Association Screen Ads $ (285.00) Bill Pmt -Check 7/17/2023 14291 AT&T Acct #9391053227: 5/17/23-6/16/23 $ (214.45) Bill Pmt -Check 7/17/2023 14292 Barbara Burkey Mileage reimbursement $ (207.63) Bill Pmt -Check 7/17/2023 14293 Community Development Services CDBG and Related Services: June 2023 $ (3,375.00) Bill Pmt -Check 7/17/2023 14294 Douglas Burkey - V Supplemental Insurance Reimbursement July 2023 $ (202.00) Bill Pmt -Check 7/17/2023 14295 Independent Coast Observer Job Ad - Clerical Asst $ (211.40) Bill Pmt -Check 7/17/2023 14296 John Biglow Clothing reimbursement $ (185.07) Bill Pmt -Check 7/17/2023 14297 League of California Cities RED Meeting 5/12/23 $ (50.00) Bill Pmt -Check 7/17/2023 14298 McMaster-Carr Supply Co. Piling Repair $ (78.55) Bill Pmt -Check 7/17/2023 14299 Mendocino County Department of Ag Acct #657-01 2023 Device Registration $ (182.20) Bill Pmt -Check 7/17/2023 14300 Mendocino County Sheriff's COPS Law enforcement services for June 2023 $ (8,333.33) Bill Pmt -Check 7/17/2023 14301 Patricia Schwindt, CPA Payroll Services: May 2023 $ (416.00) Bill Pmt -Check 7/17/2023 14302 Point Arena Gas $ (1,145.00) Bill Pmt -Check 7/17/2023 14303 Point Arena Water Works, Inc. June Water Service $ (1,133.49) Bill Pmt -Check 7/17/2023 14304 S&B Account 11280 supplies through 05/16/23 $ (653.59) Bill Pmt -Check 7/17/2023 14305 SHN Consulting Engineers & Geologists Planning Services April 2023 $ (7,722.50) Bill Pmt -Check 7/17/2023 14306 Sonoma State University $ (150.00) Bill Pmt -Check 7/17/2023 14307 TIAA Commercial Finance, INC. Copier rental: Contract # 20420012 June 2023 $ (377.43) Bill Pmt -Check 7/17/2023 14308 Ukiah Paper Supply, Inc. $ (357.87) Bill Pmt -Check 7/25/2023 14309 HealthEquity Employer Contribution 2023 HSA $ (550.00) Bill Pmt -Check 7/25/2023 14310 HSA Employer Contribution 2023 $ (879.99) Bill Pmt -Check 7/25/2023 14311 HSA Employer Contribution 2023 $ (550.00) Bill Pmt -Check 7/25/2023 14312 HSA Employer Contribution 2023 $ (550.00) Bill Pmt -Check 7/25/2023 14313 HSA Employer Contribution 2023 $ (550.00) Bill Pmt -Check 7/26/2023 EFT Blue Shield of Calif (Health) Health Insurance-222560013296 August 2023 $ (5,409.02) Bill Pmt -Check 7/26/2023 EFT Quill Office Supplies $ (359.69) Check 7/7/2023 13812 2023-07-07 Payroll $ (1,451.90)
Check 7/7/2023 13813 2023-07-07 Payroll $ (1,920.10)
Check 7/7/2023 ACH Payroll Direct Deposits 2023-07-07 Payroll $ (13,294.63) Check 7/13/2023 13815 2023-07-13 Payroll $ (2,553.80)
Check 7/21/2023 13816 2023-07-21 Payroll $ (92.35)
Check 7/21/2023 13817 2023-07-21 Payroll $ (1,556.30)
Check 7/21/2023 13818 2023-07-21 Payroll $ (69.26)
Check 7/21/2023 13819 2023-07-21 Payroll $ (69.26)
Check 7/21/2023 13820 2023-07-21 Payroll $ (1,608.41)
Check 7/21/2023 ACH Payroll Direct Deposits 2023-07-21 Payroll $ (12,069.84) Check 7/12/2023 ACH Employment Development Department State Payroll Taxes $ (885.44) Check 7/12/2023 ACH US Treasury Federal Payroll Taxes $ (5,454.64) Check 7/19/2023 ACH US Treasury Federal Payroll Taxes $ (872.65) Check 7/19/2023 ACH Employment Development Department State Payroll Taxes $ (103.45) Check 7/26/2023 ACH Employment Development Department State Payroll Taxes $ (662.54) Check 7/26/2023 ACH US Treasury Federal Payroll Taxes $ (4,674.23) Check 7/12/2023 13814 CASDU $ (88.84)
Check 7/31/2023 13821 CASDU $ (88.84)
Total Outflows - City Checking $ (105,052.41)
City of Point Arena
Schedule of Checking Account Transactions - Book Basis
July 2023
Type Date Num Name Memo Amount
Inflows:
Deposit 7/3/2023 4810 · Donations and Contributions July 4th Event Proceeds $ 9,015.00 Deposit 7/3/2023 6910 · Miscellaneous Expense Square Fees $ (243.89) Deposit 7/5/2023 4810 · Donations and Contributions Contribution July 4th $ 120.00 Deposit 7/5/2023 4990 · Miscellaneous Sales & Services July 4th Event Proceeds $ 20,689.00 Deposit 7/5/2023 4590 · Principal Collected Notes $ 581.45 Deposit 7/5/2023 4510 · Interest Income Notes $ 56.26
Deposit 7/5/2023 2342 · Tax & Ins Escrow Notes $ 362.29 Deposit 7/5/2023 1250 · Deposits Receivable Return of change funds $ 6,700.00 Deposit 7/6/2023 4810 · Donations and Contributions Contribution July 4th $ 920.00 Deposit 7/6/2023 4202 · Gas Tax 2105 Gas Tax allocation $ 1,424.12 Deposit 7/7/2023 4520 · Rents & Concessions Booth rental $ 150.00 Deposit 7/7/2023 4410 · Franchise Fees Franchise fees $ 6,000.00 Deposit 7/7/2023 12000 · Undeposited Funds Sewer Billings:Point Arena Schools $ 3,742.24 Deposit 7/7/2023 12000 · Undeposited Funds Sewer Billings:SBC AT&T Engie $ 103.68 Deposit 7/14/2023 4810 · Donations and Contributions Contribution July 4th $ 250.00 Deposit 7/14/2023 4620 · Fish Poundage Landings $ 174.00 Deposit 7/14/2023 4640 · Launch Fees Launches $ 40.00
Deposit 7/14/2023 12000 · Undeposited Funds Sewer Billings:Point Arena Schools:Arena Union Elementary School $ 875.00 Deposit 7/14/2023 12000 · Undeposited Funds Sewer Billings:Point Arena Schools:Point Arena District Office $ 69.12 Deposit 7/14/2023 12000 · Undeposited Funds Sewer Billings:Point Arena Schools:Point Arena Joint Union High $ 927.00 Deposit 7/14/2023 4990 · Miscellaneous Sales & Services Showers $ 30.00 Deposit 7/14/2023 1202 · Year End Receivables TOT $ 1,676.44 Deposit 7/14/2023 1202 · Year End Receivables Pier Landings April - June $ 4,884.50 Deposit 7/17/2023 4990 · Miscellaneous Sales & Services Pier sales and showers $ 241.65 Deposit 7/21/2023 4420 · Business License Fee Business license $ 1,630.00 Deposit 7/21/2023 4250 · RMRA SB1 Funds RMRA July $ 921.33 Deposit 7/24/2023 4990 · Miscellaneous Sales & Services Pier Showers $ 20.00 Deposit 7/24/2023 4109 · Sales Tax - Streets Sales tax $ 5,605.44 Deposit 7/24/2023 6910 · Miscellaneous Expense Square fees $ (0.62) Deposit 7/24/2023 1202 · Year End Receivables Sales tax - May 23 $ 5,149.41 Deposit 7/25/2023 4420 · Business License Fee Business license $ 80.00 Deposit 7/25/2023 4620 · Fish Poundage Landings $ 42.75 Deposit 7/25/2023 4993 · Cash Over and Short Pier cash shortage $ (0.80) Deposit 7/25/2023 12000 · Undeposited Funds Sewer Billings:RCFPD $ 69.12 Deposit 7/25/2023 1202 · Year End Receivables CDBG Loan Fubds $ 5,000.00 Deposit 7/25/2023 1202 · Year End Receivables TOT $ 2,363.09 Deposit 7/25/2023 1202 · Year End Receivables TOT $ 3,400.80 Deposit 7/27/2023 4990 · Miscellaneous Sales & Services Pier showers $ 50.00 Deposit 7/27/2023 12000 · Undeposited Funds Sewer Billings:Pacific Community Charter School $ 369.25 Deposit 7/27/2023 1202 · Year End Receivables TOT $ 313.78 Deposit 7/27/2023 1202 · Year End Receivables TOT $ 493.92 Deposit 7/27/2023 1202 · Year End Receivables HCD Admin Cost reimb $ 1,207.50 Deposit 7/31/2023 4510 · Interest Income Account interest $ 20.60 Deposit 7/31/2023 4590 · Principal Collected Notes: $ 607.15 Deposit 7/31/2023 4510 · Interest Income Notes $ 60.84
Deposit 7/31/2023 2343 · Tax & Ins Escrow - Fuentes Notes $ 332.01 Deposit 7/31/2023 4590 · Principal Collected Notes $ 582.90 Deposit 7/31/2023 4510 · Interest Income Notes $ 54.81
Deposit 7/31/2023 2342 · Tax & Ins Escrow - Santillan Notes $ 362.29 Deposit 7/31/2023 4590 · Principal Collected Notes $ 235.39 Deposit 7/31/2023 4510 · Interest Income Notes $ 21.73
Deposit 7/31/2023 1202 · Year End Receivables TOT $ 261.27 Deposit 7/31/2023 1202 · Year End Receivables TOT $ 304.44 Deposit 7/31/2023 1202 · Year End Receivables TOT $ 24,096.15 Total Inflows - City Checking $ 112,442.41
Type Date Num Name Memo Amount
1119 · Department Head Access Account
Check 7/1/2023 DH1 Further Reach Internet Fees $ (200.00) Check 7/1/2023 DH2 Further Reach Internet Fees $ (130.00) Check 7/1/2023 DH3 Zoom.us Zoom Subscription $ (47.97)
Check 7/1/2023 DH4 Facebook $ (175.00)
Check 7/7/2023 DH5 Pitney Bowes Global Financial Serv LLC Postage $ (155.75) Check 7/7/2023 DH6 AT&T Cell Phone $ (151.11)
Check 7/7/2023 DH7 Amazon.com Gloves $ (56.88)
Check 7/7/2023 DH8 Facebook $ (25.00)
Check 7/7/2023 DH9 Silkscreen Express Shirts $ (350.72) Check 7/7/2023 DH10 SF Chronicle.com Subscription $ (0.33) Check 7/14/2023 DH11 New York Times Subscription $ (20.00) Check 7/14/2023 DH12 Amazon.com Striping Paint $ (87.66) Check 7/14/2023 DH13 YouTube Membership $ (72.99)
Check 7/14/2023 DH14 US Cellular Cell phones $ (167.87) Check 7/14/2023 DH15 Amazon.com Tarps $ (60.85)
Check 7/14/2023 DH16 Signs.com Banners $ (60.33)
Check 7/25/2023 DH17 ParcelQuest ParcelQuest fee Mapping $ (199.95) Check 7/25/2023 DH18 New York Times Subscription $ (19.97) Check 7/25/2023 DH19 California City Management Foundation Dues $ (400.00) Check 7/25/2023 DH20 Amazon.com Subscription $ (150.64) Check 7/25/2023 DH21 Adobe Acrobat $ (54.99)
Check 7/25/2023 DH22 Staples Office supplies $ (17.50)
Check 7/25/2023 DH23 Chevron Fuel $ (50.00)
Check 7/25/2023 DH24 Credit card suspense Suspicious charges $ (10.89) Total Outflows - Department Head Access Account $ (2,666.40) Deposit 7/14/2023
League of CA Cities refund - Conference
cancellation Deposit $ 1,300.00
Transfer 7/31/2023 Funds Transfer $ 1,500.00
Total Inflows - Department Head Access Account $ 2,800.00 1150 · Local Agency Investment Fund
Total Inflows - LAIF $ -