Bank Balances 08/31/23 Inflows Outflows 09/30/23
City Checking 49,340.46 233,342.15 (217,970.90) 64,711.71 City Share Account 25.36 - - 25.36
City Market Rate Account 1,359.69 1,359.69
Department Head Access Account 21.44 1,940.00 (1,898.56) 62.88 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
52,559.42 235,282.15 (219,869.46) 67,972.11
City of Point Arena
Schedule of Cash Balances
September 30, 2023
Type Date Num Name Memo Amount
1110 · City Checking
Issued:
Bill Pmt -Check 09/28/2023 14347 Akeff Construction Services, Inc. -56,573.00 Bill Pmt -Check 09/28/2023 14348 Allied Administrators Group ID #07917-06025: 101/23-10/31/30/23 -597.32 Bill Pmt -Check 09/28/2023 14349 Asbury Environmental Services -385.00 Bill Pmt -Check 09/28/2023 14350 AT&T -447.95
Bill Pmt -Check 09/28/2023 14351 ChargePoint Inc. Annual Cloud Storage Service -1,500.00 Bill Pmt -Check 09/28/2023 14352 Charles Schwab & Co, Inc IRA Group# 1411-1719: August 2023 -1,235.97 Bill Pmt -Check 09/28/2023 14353 CIRA Annual WC Contribution 23-24 -14,462.00 Bill Pmt -Check 09/28/2023 14354 Community Development Services CDBG and Related Services: July 2023 -2,062.50 Bill Pmt -Check 09/28/2023 14355 Douglas Burkey - V Supplemental Insurance Reimbursement Sept 2023 -202.00 Bill Pmt -Check 09/28/2023 14356 ESA Sea Level Rise Vulnerability Study -7,099.75 Bill Pmt -Check 09/28/2023 14357 Fort Bragg Electric, Inc. Replace Manual transfer switch WWTP -15,726.00 Bill Pmt -Check 09/28/2023 14358 Fort Bragg Septic City Hall Septic Inspection -700.00 Bill Pmt -Check 09/28/2023 14359 General Code, LLC Website Maintenance & Storage Fees -480.00 Bill Pmt -Check 09/28/2023 14360 Gualala Lions Club Parking Duties performed for Street Fair/Fireworks Event -1,000.00 Bill Pmt -Check 09/28/2023 14361 Independent Coast Observer -264.00 Bill Pmt -Check 09/28/2023 14362 North Coast Community Planning Consulting Services - LCP Amendment (September 2023) -3,752.50 Bill Pmt -Check 09/28/2023 14363 Patricia Schwindt, CPA Payroll Services: July 2023 -555.50 Bill Pmt -Check 09/28/2023 14364 PG&E August 2023 billings -6,822.38 Bill Pmt -Check 09/28/2023 14365 Point Arena Gas July 2023 -419.14 Bill Pmt -Check 09/28/2023 14366 Point Arena Water Works, Inc. September Water Service -1,262.54 Bill Pmt -Check 09/28/2023 14367 Sean Robertson - V Propane Reimbursement -36.00 Bill Pmt -Check 09/28/2023 14368 SHN Consulting Engineers & Geologists -18,917.50 Bill Pmt -Check 09/28/2023 14369 Suburban Propane -1,442.82 Bill Pmt -Check 09/28/2023 14370 TIAA Commercial Finance, INC. Copier rental: Contract # 20420012 August 2023 -412.85 Bill Pmt -Check 09/29/2023 14371 Alpha Analytical Labratories, Inc. -1,130.00 Bill Pmt -Check 09/29/2023 14372 CIRA Property Premium 23-24 -18,068.00 Bill Pmt -Check 09/26/2023 EFT Blue Shield of Calif (Health) Health Insurance-222560013296 October 2023 -5,409.02 Check 09/01/2023 13835 2023-09-01 Payroll -1,517.77
Check 09/01/2023 13836 2023-09-01 Payroll -805.57
Check 09/01/2023 13837 2023-09-01 Payroll -1,330.33
Check 09/01/2023 ACH Payroll Direct Deposits 2023-09-01 Payroll -11,136.55 Check 09/15/2023 13839 2023-09-15 Payroll -1,439.73
Check 09/15/2023 13840 2023-09-15 Payroll -814.16
Check 09/15/2023 13841 2023-09-15 Payroll -1,532.73
Check 09/15/2023 ACH Payroll Direct Deposits 2023-09-15 Payroll -10,061.12 Check 09/29/2023 13844 2023-09-29 Payroll -92.35
Check 09/29/2023 13845 2023-09-29 Payroll -1,605.85
Check 09/29/2023 13846 2023-09-29 Payroll -69.26
Check 09/29/2023 13847 2023-09-29 Payroll -69.26
Check 09/29/2023 13848 2023-09-29 Payroll -1,471.01
Check 09/29/2023 13849 2023-09-29 Payroll -1,523.27
Check 09/29/2023 ACH Payroll Direct Deposits 2023-09-29 Payroll -8,773.85 Check 09/06/2023 13838 CASDU -82.61
Check 09/27/2023 13842 CASDU -82.61
Check 09/27/2023 13843 CASDU -82.61
City of Point Arena
Schedule of Checking Account Transactions - Book Basis
September 2023
Type Date Num Name Memo Amount
Check 09/06/2023 ACH Employment Development Department State Payroll Taxes -706.31 Check 09/20/2023 ACH Employment Development Department State Payroll Taxes -581.35 Check 09/06/2023 ACH US Treasury Federal Payroll Taxes -4,655.94 Check 09/20/2023 ACH US Treasury Federal Payroll Taxes -4,167.33 Transfer 09/30/2023 Funds Transfer -1,900.00
General Journal 09/15/2023 LOC-Int Redwood Credit Union LOC Interest -2,505.59 Total Outflows - City Checking (217,970.90)
Inflows:
Deposit 09/19/2023 4111 · Transient Occupancy Tax Deposit 614.33 Deposit 09/19/2023 Sewer Billings:South Coast Day Care Deposit 28.00 Deposit 09/01/2023 Notes:Wormhoudt 4590 · Principal Collected Deposit 235.59 Deposit 09/01/2023 Notes:Wormhoudt 4510 · Interest Income Deposit 21.53 Deposit 09/01/2023 Notes:Santillan 4590 · Principal Collected Deposit 584.36 Deposit 09/01/2023 Notes:Santillan 4510 · Interest Income Deposit 53.35 Deposit 09/01/2023 Notes:Santillan 2342 · Tax & Ins Escrow Deposit 362.29 Deposit 09/01/2023 Notes:Fuentes 4590 · Principal Collected Deposit 608.66 Deposit 09/01/2023 Notes:Fuentes 4510 · Interest Income Deposit 59.33 Deposit 09/01/2023 Notes:Fuentes 2343 · Tax & Ins Escrow Deposit 332.01 Deposit 09/19/2023 4640 · Launch Fees Deposit 40.00
Deposit 09/19/2023 4990 · Miscellaneous Sales & Services Deposit 255.00 Deposit 09/19/2023 4620 · Fish Poundage Deposit 464.25
Deposit 09/29/2023 4520 · Rents & Concessions Deposit 1,012.13 Deposit 09/29/2023 4990 · Miscellaneous Sales & Services Deposit 40.00 Deposit 09/29/2023 4620 · Fish Poundage Deposit 2,499.10 Deposit 09/29/2023 4640 · Launch Fees Deposit 440.00
Deposit 09/29/2023 4990 · Miscellaneous Sales & Services Deposit 80.00 Deposit 09/29/2023 4620 · Fish Poundage Deposit 1,016.90 Deposit 09/29/2023 4620 · Fish Poundage Deposit 73.50
Deposit 09/29/2023 4640 · Launch Fees Deposit 300.00
Deposit 09/07/2023 4990 · Miscellaneous Sales & Services Deposit 272.27 Deposit 09/25/2023 4108 · Sales Tax - General Deposit 5,431.84 Deposit 09/25/2023 4109 · Sales Tax - Streets Deposit 5,292.75 Deposit 09/11/2023 4640 · Launch Fees Deposit 300.00
Deposit 09/11/2023 6910 · Miscellaneous Expense Square fee -7.90 Deposit 09/18/2023 4640 · Launch Fees Deposit 40.00
Deposit 09/18/2023 6910 · Miscellaneous Expense Square fee -1.14 Deposit 09/22/2023 4250 · RMRA SB1 Funds Deposit 967.22 Deposit 09/07/2023 4520 · Rents & Concessions Deposit 2,400.00 Deposit 09/07/2023 1202 · Year End Receivables Deposit 46,623.56 Deposit 09/07/2023 Boat Storage: Deposit 250.00
Deposit 09/07/2023 Sewer Billings:SBC AT&T Engie Deposit 103.68 Deposit 09/22/2023 4345 · Prop 68 Grant Deposit 13,492.00 Deposit 09/25/2023 4111 · Transient Occupancy Tax Deposit 402.12 Deposit 09/25/2023 4590 · Principal Collected Deposit 235.78 Deposit 09/25/2023 4510 · Interest Income Deposit 21.34 Deposit 09/25/2023 4520 · Rents & Concessions Deposit 640.00 Deposit 09/25/2023 4310 · Grants - CDBG Deposit 61,554.24 Deposit 09/26/2023 4990 · Miscellaneous Sales & Services Deposit 20.00 Deposit 09/26/2023 6910 · Miscellaneous Expense Square fee -0.62 Deposit 09/30/2023 4510 · Interest Income Interest 25.73 Deposit 09/25/2023 22-23 COPS COPS AB1913 Check#04381127 86,158.95 Total Inflows - City Checking 233,342.15
Type Date Num Name Memo Amount
1119 · Department Head Access Account
Check 09/01/2023 DH1 Further Reach Internet Fees -200.00 Check 09/01/2023 DH2 Further Reach Internet Fees -130.00 Check 09/01/2023 DH3 Zoom.us Zoom Subscription -47.97
Check 09/04/2023 DH4 California Sun News Subscription -25.00 Check 09/05/2023 DH5 U.S. Postmaster Postage -13.20
Check 09/09/2023 DH7 SF Chronicle.com Subscription -3.96 Check 09/08/2023 DH6 AT&T Phone -160.18
Check 09/08/2023 DH8 L & B Avalos Autoshop Propane for Pier -144.80 Check 09/11/2023 DH9 New York Times Subscription -20.00 Check 09/11/2023 DH10 Amazon.com Pressure Valves -119.27 Check 09/12/2023 DH11 U.S. Postmaster Postage for LCP Amendment Notices -66.00 Check 09/14/2023 DH12 U.S. Postmaster Postage for LCP Amendment Notices -132.00 Check 09/16/2023 DH13 Amazon.com Supplies -10.27
Check 09/17/2023 DH14 Microsoft Microsoft OneDrive Subscription -19.99 Check 09/17/2023 DH15 Amazon.com Park Supplies -18.29
Check 09/19/2023 DH16 Amazon.com Street Safety Supplies -21.66 Check 09/20/2023 DH17 Amazon.com Street Safety Supplies -33.23 Check 09/20/2023 DH18 Google Google Subscription Youtube TV -72.99 Check 09/21/2023 DH19 Amazon.com Tractor Brushings -14.08 Check 09/22/2023 DH20 US Cellular Cell phones -167.88
Check 09/22/2023 DH21 Bluehost.com Website Hosting -125.96 Check 09/23/2023 DH23 Arena Market & Cafe Coastal Cleanup Supplies -65.89 Check 09/23/2023 DH24 Gualala Bakery Coastal Cleanup -31.00 Check 09/24/2023 DH25 ParcelQuest ParcelQuest fee Mapping -199.95 Check 09/29/2023 DH26 Adobe Acrobat -54.99
Total Outflows - Department Head Access Account (1,898.56) Deposit 09/23/2023 DH22 Deposit - Refund for Supplies 40.00 Transfer 09/30/2023 Funds Transfer 1,900.00
Total Inflows - Department Head Access Account 1,940.00 1150 · Local Agency Investment Fund
Total Inflows - LAIF -