Bank Balances 10/31/22 Inflows Outflows 11/30/22
City Checking 203,851.55 421,697.32 (475,964.14) 149,584.73 - City Share Account 25.00 25.00
City Market Rate Account 1,359.69 1,359.69
Department Head Access Account - 9,512.32 (7,056.60) 2,455.72 Department Head Access Savings 91.01 91.01
Local Agency Investment Fund - 90,944.93 (90,000.00) 944.93 Cash on Hand - -
203,851.55 523,630.27 154,461.08 (573,020.74)
Fund Cash Balances Due From Due To
General Fund 352,617.75 17,481.20 370,098.95
Gas Tax (Streets) Fund 6,226.15 (15,046.41) (8,820.26)
Used Oil Fund (557.29) 6,909.91 6,352.62
Revolving Loan Funds (27,901.42) 187,174.53 159,273.11 224,868.01 Capital Projects (Grants) (355,020.00) (237,319.83) (592,339.83) Pier Fund (10,349.21) 12,406.64 2,057.43 224,868.01
Wastewater Fund (41,492.55) 123,944.72 82,452.17
- 430,687.31 (411,613.12) 19,074.19
Bank Balance 160,495.83
Outstanding checks:
12571 (2,245.87)
12702 (125.34)
13018 (69.26)
12842 (50.00)
13663 (398.90)
13691 (112.00)
14010 (235.56)
14011 (163.26)
14005 (108.00)
14015 (4,141.23)
Total outstanding checks (7,649.42)
Adjusted bank balance 152,846.41
Variance 1,614.67
City of Point Arena
Schedule of Cash Balances
November 30, 2022
Type Date Num Name Memo Amount
1110 ꞏ City Checking
Issued:Check 11/1/2022 13742 2022-11-01 Payroll -190.52Check 11/10/2022 13743 2022-11-10 Payroll -69.26Check 11/10/2022 13744 2022-11-10 Payroll -1,302.89Check 11/10/2022 13745 2022-11-10 Payroll -69.26Check 11/10/2022 13746 2022-11-10 Payroll -1,269.60Check 11/10/2022 13747 2022-11-10 Payroll -1,500.94Check 11/10/2022 13748 2022-11-10 Payroll -69.26Check 11/25/2022 13749 2022-11-25 Payroll -1,405.20Check 11/25/2022 13750 2022-11-25 Payroll -1,235.09Bill Pmt -Check 11/3/2022 13995 Aqua-Aerobic Systems Wastewater System Repairs: Pond Mixers -26,438.06Bill Pmt -Check 11/3/2022 13996 Gualala Building Supply Supplies & Propane: October 2022 -3,166.44Bill Pmt -Check 11/3/2022 13997 Mendocino County Sheriff's COPS Law enforcement services for October 2022 -8,333.33Bill Pmt -Check 11/3/2022 13998 Romero Rodriguez Clothing Reimbursement 2022 -174.78Bill Pmt -Check 11/3/2022 13999 S&B Account 11280 supplies from 9/26/22 through 10/25/22, plus balance forward -1,040.49Bill Pmt -Check 11/3/2022 14000 Van Bebber Bros. Steel Hoops -2,981.30Check 11/10/2022 14001 Mendocino County Tax Collector Parcels 027-082-4200 & 027-082-4300 -5,558.44Bill Pmt -Check 11/10/2022 14002 Allied Administrators Group ID #07917-06025: 12/1/22-12/31/22 -476.56Bill Pmt -Check 11/10/2022 14003 Alpha Analytical Labratories, Inc. Waste Water Testing: October 2022 -945Bill Pmt -Check 11/10/2022 14004 Charles Schwab & Co, Inc IRA Group# 1411-1719: October 2022 -1,832.53Bill Pmt -Check 11/10/2022 14005 Independent Coast Observer Public Hearing Notice -108 Bill Pmt -Check 11/10/2022 14006 League of California Cities Annual Conference 9/30/22 -50Bill Pmt -Check 11/10/2022 14007 Mendocino Community Network Internet Services -8 Bill Pmt -Check 11/10/2022 14008 MTA Tickets for WW -600Bill Pmt -Check 11/10/2022 14009 Point Arena Water Works, Inc. City Services for October 2022 -1,075.65Bill Pmt -Check 11/10/2022 14010 Quill Tissue, trash bags, & office supplies -235.56Bill Pmt -Check 11/10/2022 14011 Sean Robertson - V Clothing Reimbursement 2022 -163.26Bill Pmt -Check 11/10/2022 14012 Telecom Services Co Relocate Telecom at Sheriff's Substation -8,384.19 Bill Pmt -Check 11/10/2022 14013 TIAA Commercial Finance, INC. Copier rental: 9/20/252-10/19/22 Contract # 20420012 -377.5Bill Pmt -Check 11/10/2022 14014 Point Arena Gas Oct-22 -191.55Bill Pmt -Check 11/16/2022 14015 Mendocino County Sheriff's COPS Law enforcement services for October 2022 less credit for telecom -4,141.23Bill Pmt -Check 11/16/2022 14016 North Coast Community Planning Consulting Services - LCP Amendment (October 2022) -6,815.00Bill Pmt -Check 11/16/2022 14017 PumpMan Wastewater plumbing & valve replacement -2,500.00Bill Pmt -Check 11/16/2022 14018 Richard Sample Engineering Electrical engineering for generator -5,971.00Check 11/2/2022 ACH US Treasury Federal Payroll Taxes -4,991.75Check 11/16/2022 ACH Employment Development Department State Payroll Taxes -793.57Check 11/10/2022 ACH Payroll Direct Deposits 2022-11-10 Payroll -10,788.76Check 11/16/2022 ACH US Treasury Federal Payroll Taxes -4,701.04Check 11/16/2022 ACH Employment Development Department State Payroll Taxes -717.77Check 11/25/2022 ACH Payroll Direct Deposits 2022-11-25 Payroll -10,116.50Check 11/30/2022 ACH US Treasury Federal Payroll Taxes -4,493.32Check 11/30/2022 ACH Employment Development Department State Payroll Taxes -681.54Transfer 11/06/2022 LOC-11 Redwood Credit Union Transfer payment to LOC -350,000.00 Total Outflows - City Checking (475,964.14)
Inflows:
Deposit 11/03/2022 4111 - Transient Occupancy Tax Deposit 38,062.94Deposit 11/03/2022 4340 ꞏ COP's AB1913 Allocation Deposit 17,405.96Deposit 11/03/2022 6561 ꞏ Utilities Reimbursement 600.00Deposit 11/03/2022 4590 ꞏ Principal Collected Deposit 233.63Deposit 11/03/2022 4510 ꞏ Interest Income Deposit 23.49Deposit 11/03/2022 4590 ꞏ Principal Collected Deposit 593.65Deposit 11/03/2022 4510 ꞏ Interest Income Deposit 74.34Deposit 11/03/2022 2343 ꞏ Tax & Ins Escrow - Fuentes Deposit 332.01Deposit 11/04/2022 4590 ꞏ Principal Collected Deposit 569.95Deposit 11/04/2022 4510 ꞏ Interest Income Deposit 67.76Deposit 11/04/2022 2343 ꞏ Tax & Ins Escrow - Santillan Deposit 362.29Deposit 11/04/2022 4111 - Transient Occupancy Tax Deposit 17,167.37 City of Point Arena
Schedule of Checking Account Transactions - Book Basis
Type Date Num Name Memo Amount
Deposit 11/07/2022 4640 ꞏ Launch Fees Deposit 40.00Deposit 11/07/2022 6910 Miscellaneous Expense Square Fee -1.14Deposit 11/08/2022 4200 ꞏ Gas Tax Deposit 1,393.24Deposit 11/14/2022 4111 - Transient Occupancy Tax Deposit 5,844.00Deposit 11/14/2022 Sewer Billings: CalFire Deposit 552.96Deposit 11/14/2022 Sewer Billings: South Coast Day Care Deposit 84.00Credit 11/15/2022 4640 Launch Fees Deposit 120.00Deposit 11/15/2022 4630 ꞏ Hoist Rental Deposit 248.00Deposit 11/15/2022 4111 - Transient Occupancy Tax Deposit 26.80Deposit 11/16/2022 4111 - Transient Occupancy Tax Deposit 378.36Deposit 11/16/2022 4111 - Transient Occupancy Tax Deposit 284.76Deposit 11/16/2022 4990 - Miscellaneous Sales and Services Planning Projects 44140 Port Road 50.00Deposit 11/16/2022 4440 - Planning Fees/Permits Planning Projects 44140 Port Road 2,440.00 Deposit 11/16/2022 4640 ꞏ Launch Fees Deposit 40.00Deposit 11/16/2022 6910 Miscellaneous Expense Square Fee -1.14Deposit 11/17/2022 4990 - Miscellaneous Sales and Services Deposit 216.30Refund 11/21/2022 4620 ꞏ Fish Poundage Deposit 80.00Deposit 11/21/2022 6910 Miscellaneous Expense Square Fee -2.28Deposit 11/22/2022 4640 Launch Fees Deposit 1,240.00Deposit 11/22/2022 4630 ꞏ Hoist Rental Deposit 152.00Deposit 11/22/2022 4620 ꞏ Fish Poundage Deposit 153.75Deposit 11/22/2022 4810 ꞏ Donations and Contributions Planning Projects PG&E 5,000.00Deposit 11/22/2022 4420 ꞏ Business License Fee Deposit 70.00Deposit 11/22/2022 Sewer Billings: Point Arena Schools Deposit 1,871.12Deposit 11/22/2022 Sewer Billings: South Coast Day Care Deposit 38.50Deposit 11/22/2022 Boat Storage Deposit 300.00Deposit 11/22/2022 4250 ꞏ RMRA SB1 Funds Deposit 884.72Deposit 11/29/2022 4108 Sales Tax - General Deposit 9,717.82Deposit 11/29/2022 4109 Sales Tax - Streets Deposit 7,092.11Deposit 11/30/2022 Interest income Deposit 34.64Deposit 11/30/2022 4990 - Miscellaneous Sales and Services Deposit 10.00Deposit 11/30/2022 6910 Miscellaneous Expense Square Fee -0.36Transfer 11/21/2022 Funds Transfer Deposit 90,000.00 Total Inflows - City Checking 203,851.55
1119 ꞏ Department Head Access Account
Check 11/1/2022 DH1008 Further Reach Internet charges (200.00) Check 11/1/2022 DH1009 Zoom.us Zoom Subscription (44.97)Check 11/2/2022 DH1010 Amazon.com Hybrid Meetings (5.41)Check 11/2/2022 DH1011 Amazon.com Nitrile Gloves (157.36) Check 11/3/2022 DH1012 Ukiah Chevron Gas (25.00)Check 11/3/2022 DH1013 Mechanics Surplus Water Timer (47.22)Check 11/3/2022 DH1014 Home Depot Sheriff Lights (269.66) Check 11/3/2022 DH1015 Home Depot Sheriff Carpets (177.78) Check 11/3/2022 DH1016 Home Depot Sheriff Carpets (7.52)Check 11/4/2022 DH1017 Fire Safety Supply Fire Extinguishers (1,254.20)Check 11/4/2022 DH1018 Home Depot Sheriff Carpets (24.51)Check 11/4/2022 DH1019 Amazon.com Clamp meter (411.83) Check 11/6/2022 DH1020 Amazon.com Rug (71.52)Check 11/6/2022 DH1021 FreeConference Internet charges (8.21)Check 11/7/2022 DH1022 Microsoft Office subscription (450.00) Check 11/7/2022 DH1023 Intl City/County Mgmt Assn ICMA Membership (432.80) Check 11/8/2022 DH1024 Amazon.com Towel Dispenser Repairs (112.40)Check 11/9/2022 DH1025 Sacramento State University Seminar Registration (155.53) Check 11/9/2022 DH1026 Home Depot Sheriff Carpets (47.79)Check 11/10/2022 DH1027 Ukiah Chevron Gas (50.00)Check 11/11/2022 DH1028 Amazon.com Toilet Seat (22.54)Check 11/11/2022 DH1029 Amazon.com Work Boots (151.71) Check 11/15/2022 DH1030 Amazon.com Christmas Lights (119.10) Check 11/15/2022 DH1031 US Postmaster Certified mail (7.85)Check 11/15/2022 DH1032 SuperBreakers Breakers (223.92) Check 11/16/2022 DH1033 Amazon.com Membership Fee (13.68)
Type Date Num Name Memo Amount
Check 11/17/2022 DH1034 Staples Office supplies (53.33)Check 11/17/2022 DH1035 Quick Stop Fuel (5.03)Check 11/19/2022 DH1036 Quick Stop Fuel (30.23)Check 11/19/2022 DH1037 Hangar 39 Fuel (28.64)Check 11/19/2022 DH1038 Holiday Inn Meeting (167.96) Check 11/20/2022 DH1039 Amazon.com Batteries (13.06)Check 11/20/2022 DH1040 Further Reach Internet charges (130.00) Check 11/20/2022 DH1041 YouTube Membership Fee (64.99)Check 11/21/2022 DH1042 US Postmaster Certified mail (7.85)Check 11/22/2022 DH1043 Interstate Batteries Battery (157.24) Check 11/23/2022 DH1044 Acme Rigging & Supply Straps for Floating Dock (627.04)Check 11/23/2022 DH1045 Amazon.com Supplies (23.14)Check 11/23/2022 DH1046 Friedman's Home Improvement Tools (12.00)Check 11/23/2022 DH1047 Napa Auto Parts Chain Lube (58.43)Check 11/24/2022 DH1048 E-Rigging.com Anchor Shackles (167.68) Check Parcel Quest Parcel Quest Fee (159.95)
Check Outback Garden and Supply Plants (64.63)Check Home Depot Christmas Lights (81.60)Check Best Buy Monitor (145.88) Check Staples Computer (322.23)
Check Press Democrat Subscription (182.00)
Check Oriental Trading Company Decorations (61.18)
Total Outflows - Department Head Access Account (7,056.60) Total Inflows - Department Head Access Account -
1150 ꞏ Local Agency Investment Fund
Transfer 11/21/2022 Funds Transfer (90,000.00)
Total Inflows - LAIF (90,000.00)