Bank Balances 9/30/22 Inflows Outflows 10/31/22
City Checking 749,426.42 668,292.23 (881,235.36) 536,483.29 City Share Account 25.00 25.00
City Market Rate Account 1,359.69 1,359.69
Department Head Access Account 6,032.21 13,141.01 (9,660.90) 9,512.32 Department Head Access Savings 91.01 91.01
Local Agency Investment Fund 90,944.93 - - 90,944.93
Cash on Hand - -
847,879.26 681,433.24 (890,896.26) 638,416.24
Book Balances
General Fund 349,158.12 3,459.63 352,617.75
Gas Tax (Streets) Fund (9,284.50) (5,761.91) (15,046.41) Used Oil Fund 5,981.42 928.49 6,909.91
Revolving Loan Funds 162,204.72 24,969.81 187,174.53
Capital Projects (Grants) (213,202.16) 91,223.43 (121,978.73) Pier Fund 259,471.40 (359,588.78) (100,117.38)
Wastewater Fund 5,716.65 118,228.07 123,944.72
560,045.65 - (126,541.26) 433,504.39
City of Point Arena
Schedule of Cash Balances
October 31, 2022
Date Num Name Memo Amount
1110 · City Checking
10/05/2022 13941 Caito Fisheries, Inc. Fish for HarborFest -2,715.40 10/05/2022 13942 Charles Schwab & Co, Inc IRA Group# 1411-1719: September 2022 -2,136.22 10/05/2022 13943 David Snow Roller Fabrication -315.00
10/05/2022 13944 Economic Development & Financing Co Business Loan Services -2,102.50 10/05/2022 13945 Ed Christensen Wastewater pond scraping -2,812.50 10/05/2022 13946 Gualala Building Supply Parts, supplies, & propane for September 2022 -400.74 10/05/2022 13947 Mendocino Coast Redwood Products Deposit for picnic tables -8,737.50 10/05/2022 13948 TIAA Commercial Finance, INC. Copier rental: 8/20/252-8/19/22 -420.31 10/05/2022 13949 S&B Acct# 11300: Wastewater supplies through 9/25/22 -126.11 10/05/2022 13950 S&B Acct # 11280: Pier supplies from 8/26/22 through 9/25/22 -321.97 10/13/2022 13952 Allied Administrators Group ID #07917-06025: 11/1/22-11/30/22 -476.56 10/13/2022 13953 Alpha Analytical Labratories, Inc. Waste Water Testing: September 2022 -1,220.00 10/13/2022 13954 Mendocino Community Network Internet Service 10/322-11/3/22 -9.00 10/13/2022 13955 Mendocino County Sheriff's COPS Law enforcement services for September 2022 -8,333.33 10/13/2022 13956 Peter Bogdahn - V Pier piling project and HarborFest -1,377.40 10/13/2022 13957 Point Arena Water Works, Inc. City Services for September 2022 -1,180.48 10/13/2022 13958 Quill Partition & office supplies -146.07 10/13/2022 13959 S&B General city supplies from 7/26/22 through 8/25/22 -274.51 10/13/2022 13960 SHN Consulting Engineers & Geologists Planning Services -9,301.25 10/13/2022 13961 US Cellular Acct #854104144: September billing -168.97 10/13/2022 13962 North Coast Community Planning Consulting Services - LCP Amendment (September 2022) -11,110.49 10/13/2022 13963 S&B Pier supplies from 7/26/22 through 8/25/22 Account 11280 -421.08 10/18/2022 13965 Independent Coast Observer RFP: Sea Level Rise -96.00 10/18/2022 13966 Mendocino Coast Chamber of Commerce Membership Dues -150.00 10/18/2022 13967 Patricia Schwindt, CPA Payroll Services -258.00 10/18/2022 13968 Point Arena Gas September 2022 -306.77 10/18/2022 13969 SHN Consulting Engineers & Geologists General Planning Services: Windy Hollow -4,535.00 10/25/2022 13970 AT&T Acct #9391053227: 9/17/22-10/16/22 -216.61 10/25/2022 13971 Blue Shield of Calif (Health) Health Insurance-222560013296 November 2022 -4,986.41 10/25/2022 13972 Kathy Bienhoff Landscaping: 6/21/22-10/19/22 -798.00 10/25/2022 13973 Tennant Company Street Sweeper Repair Parts -294.46 10/25/2022 13974 Advanced Locking Solutions Keys -191.82 10/27/2022 13980 SHN Consulting Engineers & Geologists Planning Services through 9/30/22: (Inv #s 114924,114925,114936,114901,117907,114906) -19,584.48 10/27/2022 13981 SHN Consulting Engineers & Geologists General Planning Services Through 9/30/22: I&I Study -34,138.75 10/27/2022 13982 SHN Consulting Engineers & Geologists General Planning Services Through 9/30/22 (Invoice 114935) -8,553.75 10/27/2022 13984 Daniel Steel & Machine, Inc. PW467 Piling installation + Retention -98,149.00 10/27/2022 13985 Douglas Burkey - V Supplemental Insurance Reimbursement June-October 2022 -750.00 10/27/2022 13986 Pitney Bowes Global Financial Serv LLC Late Fee Invoice -32.00 10/27/2022 13987 Purchase Power Postage: Acct# 8000-9000-0967-2662 -200.00 10/27/2022 13988 Alameida Architecture VOID: WWTP Generator 0.00 City of Point Arena
Schedule of Checking Account Transactions - Book Basis
Date Num Name Memo Amount
10/31/2022 13989 Alameida Architecture CDBG Vet's Hall -5,000.00 10/31/2022 13990 Defatte Equipment, Inc. WWTP Generator -85,941.38 10/31/2022 13991 Mendocino Coast Redwood Products Picnic tables (less prepaid deposit) -8,737.50 10/31/2022 13992 PG&E October 2022 billings -3,415.35
10/31/2022 13993 PumpMan Wastewater plumbing & valve replacement -4,940.00 10/31/2022 13994 Scott Phraner Company Sheriff's Office Rehab Materials -55.33 10/05/2022 13940 HealthEquity VOID: HSA Acct 2016-2380322 Andersen Employers Contribution July-Sept 2022 0.00 10/13/2022 13951 Mitch McFarland Reimbursement for fuel for recycling -104.17 10/18/2022 13964 Barbara Burkey - V Travel expenses: Long Beach Trip -563.99 10/27/2022 13975 HealthEquity Acct # 2380322, Andersen Employers Contribution July-Sept 2021 -550.00 10/27/2022 13976 HSA Employer Contribution: July-September 2022 -550.00 10/27/2022 13977 HSA Employer Contribution: Act #745104 July-September 2022 -550.00 10/27/2022 13978 HSA Employer Contribution: Act #751921 July-September 2022 -550.00 10/27/2022 13979 HSA Employer Contribution: Act #741938 July-September 2022 -550.00 10/27/2022 13983 Farmers Insurance Policy # 91424-68-43, Fuentes -961.00 10/14/2022 13733 2022-10-14 Payroll -69.26
10/14/2022 13734 2022-10-14 Payroll -1,310.75
10/14/2022 13735 2022-10-14 Payroll -69.26
10/14/2022 13736 2022-10-14 Payroll -1,119.04
10/14/2022 13737 2022-10-14 Payroll -1,456.71
10/14/2022 13738 2022-10-14 Payroll -69.26
10/14/2022 ACH Payroll Direct Deposits 2022-10-14 Payroll -10,948.18 10/28/2022 13739 2022-10-28 Payroll -1,301.15
10/28/2022 13740 2022-10-28 Payroll -1,215.32
10/28/2022 13741 2022-10-28 Payroll -1,543.68
10/28/2022 ACH Payroll Direct Deposits 2022-10-28 Payroll -11,574.43 10/05/2022 ACH Employment Development Department State Payroll Taxes -746.45 10/19/2022 ACH Employment Development Department State Payroll Taxes -673.10 10/19/2022 ACH US Treasury Federal Payroll Taxes -4,513.77 10/05/2022 ACH US Treasury Federal Payroll Taxes -4,807.84 10/03/2022 LOC-10 Redwood Credit Union Transfer payment to LOC -500,000.00 Total Outflows - City Checking (881,235.36)
10/04/2022 Boat Storage:Bob Smith Deposit 250.00
10/04/2022 6552 · Supplies & Tools Amazon return 16.22
10/05/2022 4340 · COP's AB1913 Allocation Deposit 72,689.51 10/05/2022 4420 · Business License Fee Deposit 44.00
10/05/2022 4590 · Principal Collected Deposit 568.53
10/05/2022 4510 · Interest Income Deposit 69.18
10/05/2022 2342 · Tax & Ins Escrow - Santillan Deposit 362.29 10/05/2022 4590 · Principal Collected Deposit 592.17
10/05/2022 4510 · Interest Income Deposit 75.82
10/05/2022 2343 · Tax & Ins Escrow - Fuentes Deposit 332.01 10/05/2022 4640 · Launch Fees Deposit 240.00
10/05/2022 4630 · Hoist Rental Deposit 70.00
10/05/2022 4620 · Fish Poundage Deposit 156.45
Date Num Name Memo Amount
10/05/2022 4810 · Donations and Contributions Deposit 60.00 10/07/2022 4590 · Principal Collected Deposit 233.44
10/07/2022 4510 · Interest Income Deposit 23.68
10/07/2022 4111 · Transient Occupancy Tax Deposit 176.76 10/07/2022 4810 · Donations and Contributions Deposit 30.00 10/07/2022 US Cellular credit overpayment Credit 223.55 10/07/2022 4200 · Gas Tax Deposit 1,422.94
10/12/2022 Programs:Capital:Mill Street 4325 · CalTrans Grants 338,682.76 10/12/2022 4640 · Launch Fees Deposit 38.86
10/13/2022 6561 · Utilities Reimbursement 600.00
10/13/2022 GRANTS:I&I Study 4360 · State Water Grants 17,216.00 10/13/2022 GRANTS:I&I Study 4360 · State Water Grants 3,086.00 10/13/2022 4630 · Hoist Rental Deposit 20.00
10/13/2022 4620 · Fish Poundage Deposit 182.00
10/13/2022 4620 · Fish Poundage Deposit 352.47
10/14/2022 6552 · Supplies & Tools Amazon return 172.32 10/17/2022 4640 · Launch Fees Deposit 292.10
10/17/2022 4640 Launch Fees Deposit 242.80
10/18/2022 4117 · TOT Measure AC Deposit 503.11
10/18/2022 4111 · Transient Occupancy Tax Deposit 2,515.57 10/18/2022 4117 · TOT Measure AC Deposit 223.06
10/18/2022 4111 · Transient Occupancy Tax Deposit 1,115.30 10/18/2022 Boat Storage:Tracy Buell Deposit 50.00
10/18/2022 4990 · Miscellaneous Sales & Services Deposit 50.00 10/18/2022 Sewer Billings:RCFPD Deposit 69.12
10/18/2022 Programs:Capital:Center Street 4330 · STP D1/Streets & Hwy Dis 199,998.00 10/21/2022 4111 · Transient Occupancy Tax Deposit 1,893.03 10/21/2022 4111 · Transient Occupancy Tax Deposit 949.26 10/21/2022 Boat Storage:Eric Gaona Deposit 200.00
10/28/2022 SF Chronicle.com 6330 · Dues & Memberships Refund 52.47 10/31/2022 4810 · Donations and Contributions Deposit 25.00 10/31/2022 Sewer Billings: Point Arena Schools Deposit 1,871.12 10/31/2022 4620 · Fish Poundage Deposit 600.00
10/31/2022 Boat Storage:Ross Kimsey Deposit 100.00
10/31/2022 Boat Storage:Bill Arana Deposit 50.00
10/31/2022 4420 · Business License Fee Deposit 44.00
10/31/2022 Interest income Deposit 95.15
10/21/2022 4250 · RMRA SB1 Funds Deposit 862.74
10/24/2022 6980 · CDBG Mini-grants Deposit 5,936.60
10/24/2022 6980 · CDBG Mini-grants Deposit 6,080.34
10/31/2022 4640 · Launch Fees Deposit 610.50
10/31/2022 6980 · CDBG Mini-grants Deposit 5,876.00
Total Inflows - City Checking 668,292.23
1119 · Department Head Access Account
10/01/2022 DH0974 SF Chronicle.com Subscription (90.09)
Date Num Name Memo Amount
10/01/2022 DH0975 Further Reach Internet charges (200.00) 10/01/2022 DH0976 Zoom.us Zoom Subscription (44.97)
10/02/2022 DH0977 Amazon.com Car Charger (97.52)
10/03/2022 DH0978 Adobe Acrobat (20.99)
10/04/2022 DH0979 U.S. Postmaster Certified mail (19.85) 10/04/2022 DH0980 SmartSign Sign maintenance (85.40)
10/05/2022 DH0981 League of California Cities Car Charger (750.00) 10/05/2022 DH0982 US Cellular Duplicate payment of October Invoice (243.13) 10/10/2022 DH0983 Amazon.com Swivel Hooks (16.03)
10/10/2022 DH0984 Amazon.com Deck Lights (133.28)
10/10/2022 DH0985 Motion Industries Hoist Bearings (89.11) 10/11/2022 DH0986 Traffic Safety Store Wheel Stops (409.89) 10/12/2022 DH0987 Redwood Credit Union Notary Fee (45.00) 10/12/2022 DH0988 Advanced Locking Solutions Keys (307.52) 10/13/2022 DH0989 AirMed Care Network Air Ambulance (910.00) 10/13/2022 DH0990 Amazon.com VHF Radio (201.56)
10/13/2022 DH0991 Lift Parts Unlimited Forklift Repair (39.02) 10/14/2022 DH0992 Webstaurant Store Pressure Hose (136.98) 10/14/2022 DH0993 Amazon.com Water Timer (26.00)
10/14/2022 DH0994 CalCities CalCities Conference Registration (500.00) 10/16/2022 DH0995 Northern Tool & Equipment Chainsaw (642.97) 10/18/2022 DH0996 Amazon.com Laminates (55.04)
10/18/2022 DH0997 Amazon.com Screening (86.47)
10/19/2022 DH0998 Crowd Signal CrowdSignal Survey (25.00) 10/20/2022 DH0999 Van Bebber Bros. Steel Bar: Project 467 (2,981.30) 10/21/2022 DH1000 Further Reach Internet charges (130.00) 10/23/2022 DH1001 SF Chronicle.com Subscription (0.99)
10/25/2022 DH1002 ParcelQuest ParcelQuest fee (184.90)
10/27/2022 DH1003 Amazon.com Christmas Lights: 2%TOT (62.34) 10/28/2022 DH1004 BestBuy.com Hybrid Meetings (497.61)
10/28/2022 DH1005 Redwood Credit Union Notary Fee (15.00) 10/28/2022 DH1006 Motion Industries Hoist Bearings (447.14) 10/30/2022 DH1007 Amazon.com Hybrid Meetings (165.80)
Total Outflows - Department Head Access Account (9,660.90) 10/03/2022 Deposit 16.22
10/14/2022 Deposit 172.32
10/28/2022 Deposit 52.47
10/31/2022 Funds Transfer 12,900.00
Total Inflows - Department Head Access Account 13,141.01