Bank Balances 1/31/23 Inflows Outflows 2/28/23
City Checking (12,436.60) 306,225.81 (121,952.10) 171,837.11 City Share Account 25.00 25.00
City Market Rate Account 1,359.69 1,359.69
Department Head Access Account 683.48 13,087.07 (5,475.86) 8,294.69 Department Head Access Savings 91.01 91.01
Local Agency Investment Fund 944.93 576.53 - 1,521.46
Cash on Hand - -
(31,896.00) 319,889.41 (127,427.96) 183,128.96
Fund Cash Balances
General Fund 361,297.68 (5,515.10) 355,782.58
Gas Tax (Streets) Fund (9,764.42) (8,168.92) (17,933.34) Used Oil Fund 6,059.81 (488.67) 5,571.14
Revolving Loan Funds 87,707.37 23,890.36 111,597.73
Capital Projects (Grants) (287,740.10) 134,691.39 (153,048.71) Pier Fund (62,836.02) (21,936.94) (84,772.96)
Wastewater Fund (244,263.66) 198,168.31 (46,095.35)
(149,539.34) - 320,640.43 171,101.09
Bank Balance 266,586.83
Outstanding checks:
Prior period
Current period (89,819.99)
Total outstanding checks (89,819.99)
Previous month adjustments 6,362.12
Adjusted bank balance 183,128.96
City of Point Arena
Schedule of Cash Balances
February 28, 2023
Type Date Num Name Memo Amount
1110 · City Checking
Issued:
Bill Pmt -Check 2/1/2023 14121 Chavan & Associates, LLP Audit Invoice C & A-17698 (11,000.00) Bill Pmt -Check 2/1/2023 14122 JR's Auto Care Auto parts (345.05) Bill Pmt -Check 2/1/2023 14123 Kathy Bienhoff Landscaping: 9/4/22-1/29/23 (812.00) Bill Pmt -Check 2/1/2023 14124 PG&E January 2023 billings (5,876.04) Bill Pmt -Check 2/1/2023 14125 Purchase Power Postage: Acct# 8000-9000-0967-2662 (200.00) Bill Pmt -Check 2/1/2023 14126 Redwood Credit Union-Line of Credit Monthly payment Loan #01 (2,275.05) Bill Pmt -Check 2/1/2023 14127 TIAA Commercial Finance, INC. Copier rental: Contract # 20420012 Jan 2023 (398.41) Bill Pmt -Check 2/10/2023 14128 Alpha Analytical Labratories, Inc. Testing (870.00) Bill Pmt -Check 2/10/2023 14129 Community Development Services CDBG and Related Services: January 2023 (4,625.00) Bill Pmt -Check 2/10/2023 14130 Ferrellgas Propane (1,684.90) Bill Pmt -Check 2/10/2023 14131 Kieran Martin Post Storm Cleanup (1,380.00) Bill Pmt -Check 2/10/2023 14132 Mendocino County Clerk Recorder Nov 2022 Election (1,004.98) Bill Pmt -Check 2/10/2023 14133 Mendocino County Sheriff's COPS Law enforcement services for January 2023 (8,333.33) Bill Pmt -Check 2/10/2023 14134 Point Arena Water Works, Inc. January Water Service (1,199.15) Bill Pmt -Check 2/10/2023 14135 Trill Nye Storm Tree Removal (660.00) Bill Pmt -Check 2/10/2023 14136 US Cellular Acct #854104144: January billing (167.51) Bill Pmt -Check 2/17/2023 14137 Supplemental Insurance Reimbursement November-February 2023 (600.00) Bill Pmt -Check 2/24/2023 14138 A & E Porta Potty Service Inv #' 2431 (442.93) Bill Pmt -Check 2/24/2023 14139 Allied Administrators Group ID #07917-06025: 3/1/23-3/31/23 (476.56) Bill Pmt -Check 2/24/2023 14140 Black Diamond Post-Storm Tree Removal (8,560.00) Bill Pmt -Check 2/24/2023 14141 Blue Shield of Calif (Health) Health Insurance-222560013296 Mar 2023 (4,403.39) Bill Pmt -Check 2/24/2023 14142 Charles Schwab & Co, Inc IRA Group# 1411-1719: January 2023 (1,873.90) Bill Pmt -Check 2/24/2023 14143 Dan Doyle MTA Meeting Mileage reimbursement (51.04) Bill Pmt -Check 2/24/2023 14144 Kieran Martin Post Storm Cleanup (412.50) Bill Pmt -Check 2/24/2023 14145 North Coast Community Planning Consulting Services - LCP Amendment (January 2023) (4,290.00) Bill Pmt -Check 2/24/2023 14146 Patricia Schwindt, CPA Payroll Services: 2022 YE & January 2023 (534.50) Bill Pmt -Check 2/24/2023 14147 Trill Nye Storm Tree Removal (275.00) Check 2/1/2023 13770 2023-02-01 Payroll (345.42)
Check 2/3/2023 13771 2023-02-03 Payroll (1,394.11)
Check 2/3/2023 13772 2023-02-03 Payroll (90.87)
Check 2/3/2023 13773 2023-02-03 Payroll (1,634.86)
Check 2/3/2023 ACH Payroll Direct Deposits 2023-02-03 Payroll (13,788.79) Check 2/17/2023 13774 2023-02-17 Payroll (92.35)
Check 2/17/2023 13775 2023-02-17 Payroll (1,446.82)
Check 2/17/2023 13776 2023-02-17 Payroll (207.79)
Check 2/17/2023 13777 2023-02-17 Payroll (69.26)
Check 2/17/2023 13778 2023-02-17 Payroll (1,523.28)
Check 2/17/2023 ACH Payroll Direct Deposits 2023-02-17 Payroll (12,113.81) Check 2/8/2023 ACH Employment Development Department State Payroll Taxes (1,130.06) Check 2/22/2023 ACH Employment Development Department State Payroll Taxes (710.42) Check 2/22/2023 ACH US Treasury Federal Payroll Taxes (4,572.34) Check 2/8/2023 ACH US Treasury Federal Payroll Taxes (5,605.63) General Journal 2/16/2023 LOC-Int Transfer payment to LOC (2,275.05) Transfer 2/28/2023 Funds Transfer (2,200.00)
Transfer 2/28/2023 Funds Transfer (10,000.00)
Total Outflows - City Checking (121,952.10)
Inflows:
Deposit 2/1/2023 4111 · Transient Occupancy Tax 308.33
City of Point Arena
Schedule of Checking Account Transactions - February
Type Date Num Name Memo Amount
Deposit 2/1/2023 4111 · Transient Occupancy Tax Deposit 430.00 Deposit 2/1/2023 4111 · Transient Occupancy Tax Deposit 1,087.02 Deposit 2/1/2023 4111 · Transient Occupancy Tax Deposit 3,925.20 Deposit 2/1/2023 4990 · Miscellaneous Sales & Services Deposit 53,460.80 Deposit 2/1/2023 4990 · Miscellaneous Sales & Services Deposit 68.35 Deposit 2/1/2023 4640 · Launch Fees Deposit 300.00
Deposit 2/1/2023 4990 · Miscellaneous Sales & Services Square Fee 1.84 Deposit 2/2/2023 4360 · State Water Grants GRANTS:I&I Study 29,183.00 Deposit 2/2/2023 4111 · Transient Occupancy Tax Deposit 59.36 Deposit 2/2/2023 4590 · Principal Collected Deposit 574.23 Deposit 2/2/2023 4510 · Interest Income Deposit 63.48
Deposit 2/2/2023 2342 · Tax & Ins Escrow - Santillan Deposit 362.29 Deposit 2/2/2023 4590 · Principal Collected Square Fee 598.12 Deposit 2/2/2023 4510 · Interest Income Deposit 69.87
Deposit 2/2/2023 2343 · Tax & Ins Escrow - Fuentes Deposit 332.01 Deposit 2/2/2023 4610 · Boat Storage Deposit 300.00
Deposit 2/2/2023 2400 · Unearned Revenue - Advanced payment Deposit 300.00 Deposit 2/2/2023 Sewer Billings:CalFire Deposit 138.24
Deposit 2/2/2023 Boat Storage:Ross Kimsey Deposit 50.00 Deposit 2/8/2023 4111 · Transient Occupancy Tax Deposit 11,352.70 Deposit 2/8/2023 4420 · Business License Fee Deposit 3,662.00 Deposit 2/10/2023 4360 · State Water Grants GRANTS:I&I Study 26,152.00 Deposit 2/10/2023 4990 · Miscellaneous Sales & Services Deposit 90.00 Deposit 2/10/2023 Boat Storage Deposit 50.00
Deposit 2/13/2023 4440 · Planning Fees/Permits Deposit 690.00 Deposit 2/13/2023 4310 · Grants - CDBG Deposit 9,280.00 Deposit 2/13/2023 4310 · Grants - CDBG Deposit 26,892.74 Refund 2/13/2023 4620 · Fish Poundage Deposit 1,833.45
Deposit 2/13/2023 4990 · Miscellaneous Sales & Services Deposit 38.00 Deposit 2/13/2023 4640 · Launch Fees Deposit 340.00
Deposit 2/15/2023 4420 · Business License Fee Deposit 726.80 Deposit 2/17/2023 4640 · Launch Fees Deposit 40.00
Deposit 2/17/2023 4630 · Hoist Rental Deposit 337.00
Deposit 2/17/2023 4620 · Fish Poundage Deposit 3,769.95 Deposit 2/17/2023 4111 · Transient Occupancy Tax Deposit 19,050.45 Deposit 2/17/2023 Boat Storage Deposit 50.00
Deposit 2/17/2023 4640 · Launch Fees Deposit 300.00
Deposit 2/17/2023 4620 · Fish Poundage Deposit 1,359.75 Deposit 2/17/2023 4990 · Miscellaneous Sales & Services Deposit 165.00 Deposit 2/17/2023 4420 · Business License Fee Deposit 70.00 Deposit 2/17/2023 6910 · Miscellaneous Expense Square Fee (2.60) Deposit 2/21/2023 4990 · Miscellaneous Sales & Services Deposit 20.00 Deposit 2/21/2023 6910 · Miscellaneous Expense Square Fee (0.62) Deposit 2/22/2023 4250 · RMRA SB1 Funds Deposit 842.34
Deposit 2/23/2023 4315 · OES Grant Deposit 72,721.93
Deposit 2/23/2023 Boat Storage:Eric Gaona:Amber Sea Deposit 150.00 Deposit 2/23/2023 Boat Storage:Eric Gaona:Pelican Deposit 150.00 Deposit 2/24/2023 4108 · Sales Tax - General Deposit 6,081.28 Deposit 2/24/2023 4109 · Sales Tax - Streets Deposit 7,091.03 Deposit 2/27/2023 4990 · Miscellaneous Sales & Services Deposit 199.10 Deposit 2/28/2023 4510 · Interest Income Deposit 32.22
Deposit 2/28/2023 4315 · OES Grant Deposit 18,571.23
Deposit 2/28/2023 4590 · Principal Collected Deposit 599.61 Deposit 2/28/2023 4510 · Interest Income Deposit 68.38
Deposit 2/28/2023 2343 · Tax & Ins Escrow - Fuentes Deposit 332.01 Deposit 2/28/2023 4590 · Principal Collected Deposit 575.67 Deposit 2/28/2023 4510 · Interest Income Deposit 62.04
Type Date Num Name Memo Amount
Deposit 2/28/2023 2342 · Tax & Ins Escrow - Santillan Deposit 362.29 Deposit 2/28/2023 4590 · Principal Collected Deposit 234.41 Deposit 2/28/2023 4510 · Interest Income Deposit 22.71
Deposit 2/28/2023 4710 · Sewer Service Fees Deposit 103.68 Deposit 2/28/2023 Sewer Billings:RCFPD Deposit 69.12
General Journal 2/28/2023 AJE228 Bank error - reversed in March 78.00 Total Inflows - City Checking 306,225.81
1119 · Department Head Access Account
Check 2/28/2023 DH1123 Rhoads Auto Parts Hoist Lubricant (117.45) Check 2/28/2023 DH1124 U-Haul Propane Tanks (500.80)
Check 2/28/2023 DH1125 Further Reach Internet Fees (200.00) Check 2/28/2023 DH1126 US Postmaster Certified Mail (25.23) Check 2/28/2023 DH1127 Amazon.com Tools (48.74)
Check 2/28/2023 DH1128 Zoom.us Zoom Subscription (44.97) Check 2/28/2023 DH1129 Amazon.com No receipt (6.51)
Check 2/28/2023 DH1130 Adobe Acrobat (20.99)
Check 2/28/2023 DH1131 Hi Lo Indus Trucks Co Forklift Repair (455.80) Check 2/28/2023 DH1133 Amazon.com Gloves (155.71)
Check 2/28/2023 DH1134 Further Reach Internet Fees (260.00) Check 2/28/2023 DH1135 Amazon.com Forklift repair (11.91) Check 2/28/2023 DH1136 California Rural Water Association WW Conference (575.00) Check 2/28/2023 DH1137 Amazon.com Meeting setup (19.50) Check 2/28/2023 DH1137 Amazon.com Meeting setup (33.59) Check 2/28/2023 DH1138 SmartSign Sign maintenance (95.80) Check 2/28/2023 DH1139 Amazon.com Storage bins (119.20) Check 2/28/2023 DH1140 Zoro Tools Inc Water line (269.88) Check 2/28/2023 DH1141 Amazon.com Wrenches (39.62)
Check 2/28/2023 DH1141 Amazon.com Circular saw (118.69) Check 2/28/2023 DH1143 Amazon.com Wrenches (20.96)
Check 2/28/2023 DH1144 Home Depot Lawn Mower (484.36)
Check 2/28/2023 DH1145 Hi Lo Indus Trucks Co Forklift Repair (1,379.98) Check 2/28/2023 DH1146 Harvey's CARW Conference (77.52) Check 2/28/2023 DH1147 ebay Truck Repair (33.59)
Check 2/28/2023 DH1148 YouTube Membership (64.99)
Check 2/28/2023 DH1149 US Postmaster CertifiBoathouse Code (8.13) Check 2/28/2023 DH1150 Microsoft Office Subscription (69.99) Check 2/28/2023 DH1151 ParcelQuest ParcelQuest fee Mapping (199.95) Check 2/28/2023 DH1152 New York Times Subscription (17.00) Total Outflows - Department Head Access Account (5,475.86) Deposit 2/28/2023 Hilton Hotel refund Deposit 608.07
Deposit 2/28/2023 Belkorp AG refund Deposit 279.00
Transfer 2/28/2023 Funds Transfer 2,200.00
Transfer 2/28/2023 Funds Transfer 10,000.00
Total Inflows - Department Head Access Account 13,087.07 1150 · Local Agency Investment Fund
Deposit 10/14/2022 Interest income Deposit 309.45
Deposit 01/13/2023 Interest income Deposit 267.08
Total Inflows - LAIF 576.53