Bank Balances 3/31/23 Inflows Outflows 04/30/23
City Checking 70,326.94 313,546.13 (115,882.52) 267,990.55 City Share Account 25.00 0.36 25.36
City Market Rate Account 1,359.69 1,359.69
Department Head Access Account 3,080.12 5,000.00 (2,821.68) 5,258.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
76,404.22 318,746.49 (118,704.20) 276,446.51
Fund Cash Balances
General Fund 310,727.96 34,782.31 345,510.27
Gas Tax (Streets) Fund (20,242.65) (1,758.97) (22,001.62) Used Oil Fund 5,244.60 4,793.39 10,037.99
Revolving Loan Funds 104,694.04 51,103.60 155,797.64
Capital Projects (Grants) (164,861.71) (40,066.54) (204,928.25) Pier Fund (98,432.59) 51,561.35 (46,871.24)
Wastewater Fund (81,621.65) 60,827.58 (20,794.07)
55,508.00 - 161,242.72 216,750.72
City of Point Arena
Schedule of Checking Account Transactions - Book Basis
APRIL 2023
Type Date Name Amount
1110 · City Checking
Issued:
Bill Pmt -Check 4/14/2023 PG&E (6,532.32)
Bill Pmt -Check 4/14/2023 PG&E (6,832.36)
Bill Pmt -Check 4/14/2023 A & E Porta Potty Service (392.93) Bill Pmt -Check 4/14/2023 Allied Administrators (635.44) Bill Pmt -Check 4/14/2023 Alpha Analytical Labratories, Inc. (1,820.00) Bill Pmt -Check 4/14/2023 Charles Schwab & Co, Inc (2,467.52) Bill Pmt -Check 4/14/2023 Coast Life Support District (50.00) Bill Pmt -Check 4/14/2023 Douglas Burkey - V (150.00)
Bill Pmt -Check 4/14/2023 Ferrellgas (213.15)
Bill Pmt -Check 4/14/2023 Healdsburg Lumber (374.53)
Bill Pmt -Check 4/14/2023 Kieran Martin (1,200.00)
Bill Pmt -Check 4/14/2023 League of California Cities (200.00) Bill Pmt -Check 4/14/2023 Mendocino Community Network (28.00) Bill Pmt -Check 4/14/2023 Mendocino County Sheriff's COPS (8,333.33) Bill Pmt -Check 4/14/2023 Point Arena Gas (321.00)
Bill Pmt -Check 4/14/2023 Point Arena Water Works, Inc. (1,933.52) Bill Pmt -Check 4/14/2023 Purchase Power (200.95)
Bill Pmt -Check 4/14/2023 Ryan Process, Inc. (2,871.94) Bill Pmt -Check 4/14/2023 Suburban Propane (968.81)
Bill Pmt -Check 4/14/2023 TIAA Commercial Finance, INC. (968.59) Bill Pmt -Check 4/14/2023 Trill Nye (900.00)
Bill Pmt -Check 4/28/2023 Alex Marian (4,916.57)
Bill Pmt -Check 4/28/2023 Barbara Burkey (238.38)
Bill Pmt -Check 4/28/2023 Charles Schwab & Co, Inc (1,645.47) Bill Pmt -Check 4/28/2023 Community Development Services (2,625.00) Bill Pmt -Check 4/28/2023 Dan Doyle (57.20)
Bill Pmt -Check 4/28/2023 Electronic Service (534.68)
Bill Pmt -Check 4/28/2023 General Code, LLC (874.00)
Bill Pmt -Check 4/28/2023 JJACPA, Inc (12,550.00)
Bill Pmt -Check 4/28/2023 Ramiro Nunez (55.04)
Bill Pmt -Check 4/28/2023 S&B (2,071.36)
Bill Pmt -Check 4/28/2023 SHN Consulting Engineers & Geologists (7,205.00) Check 4/14/2023 Payroll (92.35)
City of Point Arena
Schedule of Checking Account Transactions - Book Basis
APRIL 2023
Type Date Name Amount
Check 4/14/2023 Payroll (1,502.56)
Check 4/14/2023 Payroll (69.26)
Check 4/14/2023 Payroll (69.26)
Check 4/14/2023 Pa (1,421.11)
Check 4/14/2023 Payroll Direct Deposits (12,164.79)
Check 4/5/2023 Employment Development Department (740.17) Check 4/5/2023 US Treasury (4,887.99)
Check 4/28/2023 Payroll (1,482.29)
Check 4/28/2023 Payroll (1,440.04)
Check 4/28/2023 Payroll Direct Deposits (11,380.37)
Check 4/19/2023 Employment Development Department (701.23) Check 4/19/2023 US Treasury (4,764.01)
Transfer 4/20/2023 (5,000.00)
(115,882.52)
Inflows:
Deposit 4/3/2023 4200 · Gas Tax 1,199.61
Deposit 4/5/2023 4360 · State Water Grants 15,169.00
Deposit 4/5/2023 4104 · Property Tax, Unsecure, Current 1,357.89 Deposit 4/5/2023 4105 · Property Tax, Unsecure, Prior 21.46 Deposit 4/5/2023 4103 · Homeowners Property Tax Relief 204.97 Deposit 4/5/2023 4103 · Homeowners Property Tax Relief 1.52 Deposit 4/5/2023 4107 · Motor Vehicle In-Lieu Tax 23,859.50 Deposit 4/5/2023 4113 · Transfer Tax 1,300.75
Deposit 4/5/2023 4590 · Principal Collected 234.61
Deposit 4/5/2023 4510 · Interest Income 22.51
Deposit 4/5/2023 4110 · In Lieu Sales Tax - Triple Flip 1,417.41 Deposit 4/5/2023 Boat Storage 200.00
Deposit 4/10/2023 4300 · Grant Revenues 5,000.00
Deposit 4/10/2023 4410 · Franchise Fees 4,780.65
Deposit 4/10/2023 4410 · Franchise Fees 1,644.45
Deposit 4/13/2023 4990 · Miscellaneous Sales & Services 20.00 Deposit 4/13/2023 6910 · Miscellaneous Expense (0.62)
Deposit 4/14/2023 4620 · Fish Poundage 990.45
Deposit 4/14/2023 4990 · Miscellaneous Sales & Services 211.00 Deposit 4/18/2023 Sewer Billings 369.25
Deposit 4/18/2023 4310 · Grants - CDBG 4,000.00
Deposit 4/18/2023 4101 · Property Tax, Secured, Current 22,267.29
Type Date Name Amount
Deposit 4/18/2023 4104 · Property Tax, Unsecure, Current (0.60) Deposit 4/18/2023 4102 · Property Tax, Secured, Prior Yr 10.34 Deposit 4/18/2023 4110 · In Lieu Sales Tax - Triple Flip 863.62 Deposit 4/18/2023 4710 · Sewer Service Fees 96,865.85
Deposit 4/18/2023 4113 · Transfer Tax 805.20
Deposit 4/18/2023 4320 · Grants - MCOG 16,380.67
Deposit 4/18/2023 4310 · Grants - CDBG 73,937.50
Deposit 4/18/2023 4990 · Miscellaneous Sales & Services 225.00 Deposit 4/18/2023 4810 · Donations and Contributions 520.00 Deposit 4/18/2023 4420 · Business License Fee 150.00
Deposit 4/18/2023 4520 · Rents & Concessions 165.00
Deposit 4/18/2023 Sewer Billings 3.50
Deposit 4/18/2023 Boat Storage 250.00
General Journal 4/19/2023 1102 · Cash on Hand (100.00)
General Journal 4/19/2023 4993 · Cash Over and Short 100.00 General Journal 4/19/2023 1110 · General Fund Checking - RCU 100.00 Deposit 4/19/2023 4640 · Launch Fees 600.00
Deposit 4/19/2023 6910 · Miscellaneous Expense (15.70)
Deposit 4/20/2023 4990 · Miscellaneous Sales & Services 10.00 Deposit 4/20/2023 6910 · Miscellaneous Expense (11.00)
Deposit 4/20/2023 Boat Storage 300.00
Deposit 4/21/2023 4250 · RMRA SB1 Funds 868.35
Deposit 4/24/2023 4108 · Sales Tax - General 5,072.53
Deposit 4/24/2023 4109 · Sales Tax - Streets 3,696.32
Deposit 4/26/2023 4420 · Business License Fee 50.00
Deposit 4/26/2023 4810 · Donations and Contributions 1,000.00 Deposit 4/26/2023 4440 · Planning Fees/Permits 2,290.00 Deposit 4/26/2023 4440 · Planning Fees/Permits 980.00
Deposit 4/26/2023 4111 · Transient Occupancy Tax 19,853.94 Deposit 4/26/2023 Sewer Billings 1,871.12
Deposit 4/28/2023 4111 · Transient Occupancy Tax 539.63 Deposit 4/28/2023 4810 · Donations and Contributions 600.00 Deposit 4/28/2023 4590 · Principal Collected 234.80
Deposit 4/28/2023 4510 · Interest Income 22.32
Deposit 4/28/2023 4620 · Fish Poundage 532.85
Deposit 4/28/2023 4640 · Launch Fees 80.00
Deposit 4/28/2023 4990 · Miscellaneous Sales & Services 106.00 Deposit 4/28/2023 4990 · Miscellaneous Sales & Services 273.66 Deposit 4/30/2023 4510 · Interest Income 43.53
Type Date Name Amount
313,546.13
1119 · Department Head Access Account
Check 4/1/2023 Further Reach (200.00)
Check 4/1/2023 Further Reach (130.00)
Check 4/1/2023 Zoom.us (47.97)
Check 4/1/2023 AT&T (347.98)
Check 4/6/2023 Center Street Market (103.90)
Check 4/6/2023 Belkorp AG (39.08)
Check 4/6/2023 Pitney Bowes Global Financial Serv LLC (155.75) Check 4/6/2023 U.S. Postmaster (88.20)
Check 4/14/2023 U.S. Postmaster (63.00)
Check 4/14/2023 YouTube (64.99)
Check 4/17/2023 Harvey's (361.14)
Check 4/17/2023 US Cellular (172.51)
Check 4/17/2023 SF Chronicle.com (19.96)
Check 4/17/2023 New York Times (17.00)
Check 4/17/2023 Amazon.com (65.01)
Check 4/25/2023 ParcelQuest (199.95)
Check 4/25/2023 Boat Outfitters (72.23)
Check 4/25/2023 Amazon.com (606.05)
Check 4/25/2023 Adobe (54.99)
Check 4/28/2023 Amazon.com (11.97)
(2,821.68)
Transfer 4/20/2023 5,000.00
5,000.00
1150 · Local Agency Investment Fund
-
Bank Balances 04/30/23 Inflows Outflows 05/31/23
City Checking 267,990.55 82,763.21 (108,921.08) 241,832.68 City Share Account 25.36 - - 25.36
City Market Rate Account 1,359.69 1,359.69
Department Head Access Account 5,258.44 364.00 (4,611.84) 1,010.60 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
276,446.51 83,127.21 (113,532.92) 246,040.80
Fund Cash Balances
General Fund 345,510.27 (1,080.41) 344,429.86
Gas Tax (Streets) Fund (22,001.62) (2,026.06) (24,027.68) Used Oil Fund 10,037.99 (279.50) 9,758.49
Revolving Loan Funds 155,797.64 4,340.97 160,138.61
Capital Projects (Grants) (204,928.25) (2,297.14) (207,225.39) Pier Fund (46,871.24) (9,610.18) (56,481.42)
Wastewater Fund (20,794.07) 11,432.67 (9,361.40)
216,750.72 - 480.35 217,231.07
City of Point Arena
Schedule of Cash Balances
May 31, 2023
Type Date Num Name Memo Amount
1110 · City Checking
Issued:
Bill Pmt -Check 05/03/2023 14219 Alameida Architecture Architectural services (12,053.69) Bill Pmt -Check 05/03/2023 14220 Hand and Spade Landscaping and Gardening CDBG Mini Grant (12,500.00) Bill Pmt -Check 05/03/2023 14221 Kieran Martin Tree cutting (1,112.50) Bill Pmt -Check 05/03/2023 14222 Pyro Spectaculars North, Inc. Fireworks Deposit (7,500.00) Bill Pmt -Check 05/03/2023 14223 Trill Nye Tree cutting (665.00) Bill Pmt -Check 05/17/2023 14237 A & E Porta Potty Service Inv #' 2628 (492.93) Bill Pmt -Check 05/17/2023 14238 Allied Administrators Group ID #07917-06025: 6/1/23-6/30/23 (529.52) Bill Pmt -Check 05/17/2023 14239 Allied Crane, Inc. Crane Maintenance (2,505.76) Bill Pmt -Check 05/17/2023 14240 Alpha Analytical Labratories, Inc. Lab testing (950.00) Bill Pmt -Check 05/17/2023 14241 Blue Shield of Calif (Health) Health Insurance-222560013296 May 2023 (5,614.22) Bill Pmt -Check 05/17/2023 14242 Community Development Services CDBG and Related Services: April 2023 (5,812.50) Bill Pmt -Check 05/17/2023 14243 Douglas Burkey - V Supplemental Insurance Reimbursement May 2023 (150.00) Bill Pmt -Check 05/17/2023 14244 Independent Coast Observer Notice of Public Hearing (144.00) Bill Pmt -Check 05/17/2023 14245 Joe Wilson-V Travel Reimbursement (390.30) Bill Pmt -Check 05/17/2023 14246 Nick Barbieri Trucking Diesel Fuel (924.90) Bill Pmt -Check 05/17/2023 14247 Patricia Schwindt, CPA Payroll Services: March 2023 (336.00) Bill Pmt -Check 05/17/2023 14248 PG&E April 2023 billings (6,633.43) Bill Pmt -Check 05/17/2023 14249 Point Arena Water Works, Inc. April Water Service (1,059.17) Bill Pmt -Check 05/17/2023 14250 Quill Office supplies (584.66) Bill Pmt -Check 05/17/2023 14251 TIAA Commercial Finance, INC. Copier rental: Contract # 20420012 Apr 2023 (379.12) Check 05/12/2023 13796 Payroll 2023-05-12 Payroll (92.35) Check 05/12/2023 13797 Payroll 2023-05-12 Payroll (1,568.46) Check 05/12/2023 13798 Payroll 2023-05-12 Payroll (69.26) Check 05/12/2023 13799 Payroll 2023-05-12 Payroll (69.26) Check 05/12/2023 13800 Payroll 2023-05-12 Payroll (1,506.26) Check 05/12/2023 ACH Payroll 2023-05-12 Payroll (12,483.00) Check 05/26/2023 13801 Payroll 2023-05-26 Payroll (1,543.12) Check 05/26/2023 13802 Payroll 2023-05-26 Payroll (1,440.04) Check 05/26/2023 ACH Payroll Direct Deposits 2023-05-26 Payroll (11,907.49) Check 05/03/2023 ACH US Treasury Federal Payroll Taxes (4,334.00) Check 05/17/2023 ACH US Treasury Federal Payroll Taxes (4,730.11) Check 05/17/2023 ACH Employment Development Department State Payroll Taxes (670.63) Check 05/03/2023 ACH Employment Development Department State Payroll Taxes (604.63) Check 05/31/2023 ACH Employment Development Department State Payroll Taxes (661.42) Check 05/31/2023 ACH US Treasury Federal Payroll Taxes (4,606.21) General Journal 05/16/2023 LOC-Int Transfer payment to LOC (2,297.14) Total Outflows - City Checking (108,921.08)
Inflows:
Deposit 05/02/2023 4640 · Launch Fees Deposit 40.00
Deposit 05/02/2023 4111 · Transient Occupancy Tax Deposit 104.06 Deposit 05/02/2023 Parks: Fireworks 4810 · Donations and Contributions Deposit 250.00 Deposit 05/02/2023 4420 · Business License Fee Deposit 70.00 Deposit 05/02/2023 4590 · Principal Collected Deposit 602.62 Deposit 05/02/2023 4510 · Interest Income Deposit 65.37 Deposit 05/02/2023 2343 · Tax & Ins Escrow - Fuentes Deposit 332.01 Deposit 05/02/2023 4590 · Principal Collected Deposit 578.55 Deposit 05/02/2023 4510 · Interest Income Deposit 59.16 Deposit 05/02/2023 2342 · Tax & Ins Escrow - Santillan Deposit 362.29 City of Point Arena
Schedule of Checking Account Transactions - Book Basis
Type Date Num Name Memo Amount
Deposit 05/02/2023 4200 · Gas Tax Deposit 1,092.99
Deposit 05/02/2023 4993 · Cash Over and Short Deposit 0.80 Deposit 05/04/2023 4111 · Transient Occupancy Tax Deposit 9,870.00 Deposit 05/04/2023 4111 · Transient Occupancy Tax Deposit 870.57 Deposit 05/04/2023 4340 · COP's AB1913 Allocation Deposit 5,535.13 Deposit 05/04/2023 Sewer Billings Deposit 138.24
Deposit 05/04/2023 Sewer Billings Deposit 103.68
Deposit 05/05/2023 Sewer Billings Deposit 103.68
Deposit 05/05/2023 Sewer Billings Deposit 138.24
Deposit 05/05/2023 Sewer Billings Deposit 69.12
Deposit 05/05/2023 4111 · Transient Occupancy Tax Deposit 1,651.20 Deposit 05/05/2023 GRANTS:I&I Study 4360 · State Water Grants Deposit 16,215.00 Deposit 05/05/2023 4810 · Donations and Contributions Deposit 1,700.00 Deposit 05/15/2023 4990 · Miscellaneous Sales & Services Deposit 3.00 Deposit 05/15/2023 6910 · Miscellaneous Expense Square Fee (0.18) Deposit 05/16/2023 4990 · Miscellaneous Sales & Services Deposit 253.92 Deposit 05/22/2023 4250 · RMRA SB1 Funds Deposit 753.68 Deposit 05/26/2023 4111 · Transient Occupancy Tax Deposit 105.24 Deposit 05/26/2023 4310 · Grants - CDBG Deposit 8,625.00 Deposit 05/26/2023 GRANTS:I&I Study 4360 · State Water Grants Deposit 12,816.00 Deposit 05/26/2023 4990 · Miscellaneous Sales & Services Deposit 143.61 Deposit 05/26/2023 4590 · Principal Collected Deposit 234.80 Deposit 05/26/2023 4510 · Interest Income Deposit 22.32 Deposit 05/26/2023 4810 · Donations and Contributions Deposit 450.00 Deposit 05/26/2023 4520 · Rents & Concessions Deposit 640.00 Deposit 05/26/2023 4420 · Business License Fee Deposit 104.00 Deposit 05/26/2023 Parks: Fireworks 4810 · Donations and Contributions Deposit 40.00 Deposit 05/26/2023 Sewer Billings Deposit 369.25
Deposit 05/26/2023 Sewer Billings Deposit 103.68
Deposit 05/26/2023 Sewer Billings Deposit 3.50
Deposit 05/26/2023 4640 · Launch Fees Deposit 160.00
Deposit 05/26/2023 4620 · Fish Poundage Deposit 1,202.10 Deposit 05/26/2023 4990 · Miscellaneous Sales & Services Deposit 324.00 Deposit 05/26/2023 4640 · Launch Fees Deposit 40.00
Deposit 05/26/2023 6910 · Miscellaneous Expense Square Fee (1.14) Deposit 05/30/2023 4108 · Sales Tax - General Deposit 7,121.26 Deposit 05/30/2023 4109 · Sales Tax - Streets Deposit 8,776.44 Deposit 05/31/2023 4510 · Interest Income Deposit 46.78 Deposit 05/31/2023 4990 · Miscellaneous Sales & Services Deposit 50.00 Deposit 05/31/2023 4420 · Business License Fee Deposit 100.00 Deposit 05/31/2023 4810 · Donations and Contributions Deposit 70.00 Deposit 05/31/2023 4520 · Rents & Concessions Deposit 115.00 Deposit 05/31/2023 Sewer Billings Deposit 138.24
Total Inflows - City Checking 82,763.21
1119 · Department Head Access Account
Check 05/01/2023 DH1209 Further Reach Internet Fees (200.00) Check 05/01/2023 DH1210 Further Reach Internet Fees (130.00) Check 05/01/2023 DH1211 Zoom.us Zoom Subscription (47.97) Check 05/01/2023 DH1212 Paypal Purchase in error (84.16) Check 05/01/2023 DH1213 VistaPrint City Envelopes (203.87) Check 05/01/2023 DH1214 AT&T Cell Phone (143.75)
Check 05/01/2023 DH1215 Bolt Depot Hoop bolts (98.75)
Check 05/01/2023 DH1216 Amazon.com Hose (98.78)
Check 05/01/2023 DH1217 Chevron Fuel (30.02)
Type Date Num Name Memo Amount
Check 05/01/2023 DH1218 Outback Garden and Feed Plants (119.16) Check 05/01/2023 DH1219 B & B Industrial Supply, Inc. Temp Collar (181.63) Check 05/01/2023 DH1220 Chevron Fuel (30.15)
Check 05/01/2023 DH1221 Ukiah Brewing Co. CM Lunch (26.30) Check 05/01/2023 DH1222 YouTube Membership (72.99)
Check 05/01/2023 DH1223 Holiday Inn Conference hotel (105.00) Check 05/01/2023 DH1224 New York Times Subscription (20.00) Check 05/01/2023 DH1225 SF Chronicle.com Subscription (0.33) Check 05/01/2023 DH1226 US Cellular Cell phones (167.87) Check 05/01/2023 DH1227 Chevron Fuel (25.22)
Check 05/01/2023 DH1228 Amazon.com Nitrile Gloves (135.46) Total Outflows - Department Head Access Account (4,611.84) Deposit 05/01/2023 Amazon refund Credit 364.00
Total Inflows - Department Head Access Account 364.00
1150 · Local Agency Investment Fund
Total Inflows - LAIF -