Bank Balances 07/31/23 Inflows Outflows 08/31/23
City Checking 100,605.39 232,967.27 (284,232.20) 49,340.46 City Share Account 25.36 - - 25.36
City Market Rate Account 1,359.69 1,359.69
Department Head Access Account 139.45 6,903.00 (7,021.01) 21.44 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
103,942.36 239,870.27 (291,253.21) 52,559.42
City of Point Arena
Schedule of Cash Balances
August 31, 2023
Type Date Num Name Memo Amount
1110 · City Checking
Issued:
Bill Pmt -Check 08/14/2023 14314 Allied Administrators Group ID #07917-06025: 9/1/23-9/30/23 -597.32 Bill Pmt -Check 08/14/2023 14315 Alpha Analytical Labratories, Inc. Lab Testing -940.00 Bill Pmt -Check 08/14/2023 14316 AquaFix Algae & Duckweed Control -1,220.29 Bill Pmt -Check 08/14/2023 14317 AT&T Acct #9391053227: 6/17/23-7/16/23 -217.43 Bill Pmt -Check 08/14/2023 14318 Charles Schwab & Co, Inc June & July 401k -3,481.61 Bill Pmt -Check 08/14/2023 14319 CIRA ADWRP/Cyber/Crime/Pollution 23-24 -1,835.42 Bill Pmt -Check 08/14/2023 14320 Dan Doyle Mileage reimbursement - MTA meetings -115.28 Bill Pmt -Check 08/14/2023 14321 Douglas Burkey - V Supplemental Insurance Reimbursement August 2023 -202.00 Bill Pmt -Check 08/14/2023 14322 Mendocino County Fire Safe Council VOID: Supplies 0.00 Bill Pmt -Check 08/14/2023 14323 Fort Bragg Electric, Inc. Installed new starter contactor -262.50 Bill Pmt -Check 08/14/2023 14324 Goija Post Bubble Zone supplies -139.08 Bill Pmt -Check 08/14/2023 14325 Independent Coast Observer Advertisements -432.00 Bill Pmt -Check 08/14/2023 14326 JJACPA, Inc Accounting Services:April 2023 June 2023 -12,000.00 Bill Pmt -Check 08/14/2023 14327 JR's Auto Care Auto parts -1,013.11 Bill Pmt -Check 08/14/2023 14328 Kathy Bienhoff Landscaping: 5/24/23-6/17/23 -672.00 Bill Pmt -Check 08/14/2023 14329 Mendocino Coast Chamber of Commerce Membership Dues -150.00 Bill Pmt -Check 08/14/2023 14330 Mendocino County Auditor-Controller LAFCO 2023-2024 -732.51 Bill Pmt -Check 08/14/2023 14331 Mendocino County Sheriff's COPS Law enforcement services for May 2023 -8,333.33 Bill Pmt -Check 08/14/2023 14332 North Coast Community Planning Consulting Services - LCP Amendment (May & Jun 2023) -20,198.75 Bill Pmt -Check 08/14/2023 14333 Patricia Schwindt, CPA Payroll Services: June 2023 -228.00 Bill Pmt -Check 08/14/2023 14334 Peter Bogdahn - V Sandblast skiff hoist -318.18 Bill Pmt -Check 08/14/2023 14335 PG&E July 2023 billings -8,360.67 Bill Pmt -Check 08/14/2023 14336 Point Arena Water Works, Inc. July Water Service -1,007.76 Bill Pmt -Check 08/14/2023 14337 Quill Office supplies -297.41 Bill Pmt -Check 08/14/2023 14338 S&B Supplies -753.52
Bill Pmt -Check 08/14/2023 14339 SHN Consulting Engineers & Geologists Planning services -24,520.00 Bill Pmt -Check 08/14/2023 14340 TIAA Commercial Finance, INC. Copier rental: Contract # 20420012 July 2023 -383.12 Bill Pmt -Check 08/14/2023 14341 Victoria Ignacio Booth deposit refund -100.00 Bill Pmt -Check 08/17/2023 14342 Cove Coffee CDBG Employee Retention Loan -30,000.00 Bill Pmt -Check 08/17/2023 14343 Good Food Club LLC CDBG Employee Retention Loan -18,000.00 Bill Pmt -Check 08/17/2023 14344 Pier Place CDBG Employee Retention Loan -30,000.00 Bill Pmt -Check 08/17/2023 14345 Point Arena Pizza CDBG Employee Retention Loan -30,000.00 Bill Pmt -Check 08/28/2023 14225 Mendocino County Fire Safe Council Supplies -1,636.75 Bill Pmt -Check 08/29/2023 14346 ESA Sea level Rise Study -31,298.00 Bill Pmt -Check 08/28/2023 EFT Blue Shield of Calif (Health) Health Insurance-222560013296 September 2023 -5,409.02 Check 08/04/2023 13822 2023-08-04 Payroll -1,398.08
Check 08/04/2023 13823 2023-08-04 Payroll -1,525.17
Check 08/04/2023 ACH Payroll Direct Deposits 2023-08-04 Payroll -10,815.30 Check 08/18/2023 13825 2023-08-18 Payroll -1,642.89
Check 08/18/2023 13830 2023-08-18 Payroll -92.35
Check 08/18/2023 13826 2023-08-18 Payroll -1,446.82
Check 08/18/2023 13831 2023-08-18 Payroll -69.26
Check 08/18/2023 13832 2023-08-18 Payroll -69.26
Check 08/18/2023 13833 2023-08-18 Payroll -69.26
Check 08/18/2023 13834 2023-08-18 Payroll -69.26
City of Point Arena
Schedule of Checking Account Transactions - Book Basis
August 2023
Type Date Num Name Memo Amount
Check 08/18/2023 13828 2023-08-18 Payroll -1,138.53
Check 08/18/2023 13827 2023-08-18 Payroll -1,449.50
Check 08/18/2023 ACH Payroll Direct Deposits 2023-08-18 Payroll -9,980.68 Check 08/09/2023 ACH Employment Development Department State Payroll Taxes -542.32 Check 08/23/2023 ACH Employment Development Department State Payroll Taxes -708.36 Check 08/09/2023 ACH US Treasury Federal Payroll Taxes -4,043.77 Check 08/23/2023 ACH US Treasury Federal Payroll Taxes -4,811.46 Check 08/09/2023 13824 CASDU -82.61
Check 08/22/2023 13829 CASDU -82.61
General Journal 08/16/2023 LOC-Int Transfer payment to LOC -2,439.65 Transfer 08/31/2023 Funds Transfer -6,900.00
Total Outflows - City Checking (284,232.20)
Inflows:
Deposit 08/01/2023 4202 · Gas Tax 2105 Deposit 2,446.49 Deposit 08/01/2023 4990 · Miscellaneous Sales & Services Deposit 40.00 Deposit 08/01/2023 6910 · Miscellaneous Expense Square Fee -1.14 Deposit 08/02/2023 4640 · Launch Fees Deposit 40.00
Deposit 08/02/2023 4990 · Miscellaneous Sales & Services Deposit 353.00 Deposit 08/02/2023 1202 · Year End Receivables - Sales Tax Deposit 18,783.75 Deposit 08/07/2023 1202 · Year End Receivables - TOT Deposit 12,304.20 Deposit 08/10/2023 4111 · Transient Occupancy Tax Deposit 193.08 Deposit 08/10/2023 4520-Rents and Concessions Deposit 4,800.00 Deposit 08/10/2023 Boat Storage Deposit 200.00
Deposit 08/10/2023 Sewer Billings:CalFire Deposit 138.24 Deposit 08/10/2023 Sewer Billings:SBC AT&T Engie Deposit 103.68 Deposit 08/11/2023 4640 · Launch Fees Deposit 40.00
Deposit 08/11/2023 4990 · Miscellaneous Sales & Services Square Fee -1.14 Deposit 08/15/2023 Ocean Fresh LLC 4620 · Fish Poundage Deposit 2,649.00 Deposit 08/15/2023 I&I Study 4360 · State Water Grants Deposit 17,014.00 Deposit 08/15/2023 Sewer Billings:Point Arena Schools Deposit 1,871.12 Deposit 08/15/2023 Sewer Billings:South Coast Day Care Deposit 24.50 Deposit 08/15/2023 4990 · Miscellaneous Sales & Services Deposit 309.11 Deposit 08/16/2023 4310 · Grants - CDBG Deposit 117,142.05 Deposit 08/22/2023 4250 · RMRA SB1 Funds Deposit 877.59 Deposit 08/22/2023 1202 · Year End Receivables - TOT Deposit 5,156.89 Deposit 08/25/2023 1202 · Year End Receivables- TOT Deposit 4,472.50 Deposit 08/25/2023 4990 · Miscellaneous Sales & Services Deposit 925.00 Deposit 08/25/2023 Sewer Billings:Pacific Community Charter SchoDeposit 369.25 Deposit 08/25/2023 4620 · Fish Poundage Deposit 547.05
Deposit 08/25/2023 4640 · Launch Fees Deposit 520.00
Deposit 08/25/2023 4990 · Miscellaneous Sales & Services Deposit 135.00 Deposit 08/28/2023 1202 · Year End Receivables - Sales Tax Deposit 8,052.26 Deposit 08/29/2023 GRANTS:Sea Level R 1202 · Year End Receivables Deposit 31,676.00 Deposit 08/29/2023 Sewer Billings:RCFPD Deposit 69.12
Deposit 08/29/2023 Boat Storage Deposit 100.00
Deposit 08/31/2023 4202 · Gas Tax 2105 Deposit 1,593.13 Deposit 08/31/2023 4510 · Interest Income Interest 23.54 Total Inflows - City Checking 232,967.27
1119 · Department Head Access Account
Check 08/01/2023 DH1 Further Reach Internet Fees -200.00 Check 08/01/2023 DH2 Further Reach Internet Fees -130.00
Type Date Num Name Memo Amount
Check 08/02/2023 DH4 Zoom.us Zoom Subscription -47.97
Check 08/03/2023 DH5 Hyatt Regency Conference -6.00
Check 08/05/2023 DH6 California Sun News Subscription -15.00 Check 08/06/2023 DH7 AT&T Cell Phone -151.17
Check 08/07/2023 DH8 Lighthouse Peddler Advertising -158.00 Check 08/10/2023 DH9 Mendocino Community Network Internet Fees: May - Aug 2023 -36.00 Check 08/10/2023 DH11 Home Depot Supplies -40.20
Check 08/12/2023 DH12 AT&T Misc Cell Phone Charge -3.96 Check 08/13/2023 DH13 Facebook Advertising -10.00
Check 08/14/2023 DH14 New York Times Subscription -20.00 Check 08/14/2023 DH15 Amazon.com Printer Ink -143.92
Check 08/14/2023 DH16 Amazon.com Park Cleanup Supplies -164.73 Check 08/15/2023 DH17 Amazon.com Park Cleanup Supplies -56.90 Check 08/15/2023 DH18 U.S. Postmaster Certified mail -8.56 Check 08/15/2023 DH19 Monarch Coin & Security Shower Tokens -314.00 Check 08/16/2023 DH20 U.S. Postmaster Postage -30.20
Check 08/17/2023 DH21 Amazon.com WWTP Gloves -124.62
Check 08/17/2023 DH22 Amazon.com PW Gloves -68.28
Check 08/20/2023 DH23 Google Google Subscription -72.99 Check 08/22/2023 DH24 US Cellular Cell phones -167.88
Check 08/22/2023 DH25 Center Street Market Water -15.43 Check 08/23/2023 DH26 Amazon.com Disinfectant Cleaning Solution -33.91 Check 08/23/2023 DH27 Amazon.com Janitorial Supplies -168.37 Check 08/23/2023 DH28 Acme Rigging & Supply Co. Hoist Repair -878.26 Check 08/24/2023 DH29 California Assoc for Local Economic Devt Workshop -50.00 Check 08/25/2023 DH30 ParcelQuest Mapping -199.95
Check 08/24/2023 DH31 United Rentals Boom Truck for Hoist Repair -1,882.72 Check 08/26/2023 DH32 Costco Storage Bins -31.00
Check 08/30/2023 DH33 Adobe Acrobat -54.99
Check 08/30/2023 DH34 U.S. Postmaster PO Box Renewal -211.00 Check 08/30/2023 DH35 Alliant Insurance Services, Inc. Insurance - FishFest -925.00 Check 08/31/2023 DH36 MTA Bus Tickets for testing -600.00 Total Outflows - Department Head Access Account (7,021.01) Deposit 08/02/2023 DH3 Deposit 2.99
Deposit 08/11/2023 DH10 Deposit 0.01
Transfer 08/31/2023 Funds Transfer 6,900.00
Total Inflows - Department Head Access Account 6,903.00 1150 · Local Agency Investment Fund
Total Inflows - LAIF -