Agenda — Farmersville City Council, February 26, 2024

CITY OF
FARMERSVILLE Farmersville City Council
Regular Meeting
Tina Hernandez, Mayor
Danny Valdovinos, Mayor Pro Tem Monday, February 26, 2024 6:00 PM Gregorio Gomez, Council Member Meeting held in Civic Center Council Chambers Paul Boyer, Council Member - 909 W. Visalia Road Farmersville, California Armando Hinojosa, Council Member
Pending no technical difficulties, the City Council meeting will also be streamed (for observation only) via Zoom and accessed as follows:

Please dial 1-669-900-6833
Meeting ID: 854 5739 1839
Password: 859673
Call to Order:

2. Roll Call:

Invocation:

Pledge of Allegiance:

Public Comment:

Provides an opportunity for members of the public to address the City Council on items of interest to the public within the Council's jurisdiction and which are not already on the agenda this evening. It is the policy of the Council not to answer questions impromptu. Concerns or complaints will be referred to the City Manager's office. Speakers should limit their comments to not more than two (2) minutes. No more than twenty (20) total minutes will be allowed for Public Comment. For items which are on the agenda this evening, members of the public will be provided an opportunity to address the council as each item is brought up for discussion. Comments are to be addressed to the Council as a body and not to any individual Council Member.

6. Presentations:

A. Update by GRID Alternatives - Hector Uriarte

7. Consent Agenda:

Under a CONSENT AGENDA category, a recommended course of action for each item is made. Any Council Member or Member of the Public may remove any item from the CONSENT AGENDA in order to discuss and/or change the recommended course of action, and the Council can approve the remainder of the CONSENT AGENDA.

A. Authorization to waive full reading of ordinances and resolutions and to identify by title only.

Recommend that the City Council approve the full reading of all ordinances and resolutions be waived and to identify by title only.

Recommend approval of minutes.

Documents: Draft Action Minutes of February 12, 2024 :

Finance Update for January 2024: Warrant Register and Investment Summary
Recommend that the City Council:

1. Approve the Warrant Register as presented for the period. This reporting period represents warrants issued for the current Fiscal Year (2023/2024);

2. Accept the Investment Summary as presented for the period. This reporting period represents investment summary for the previous month.

Documents: January 2024 Warrant Register
Investment Summary January 2024
D. Request by Farmersville Elite Soccer Club for Special Event Funding :
for Fiscal Year 2023-24
Documents: Event Funding Application :

General Business
:

A. Consider Approving Resolution 2024-007 adopting Mid-Year Budget Amendment for Fiscal Year 2023-24
Recommend that the City Council approve Resolution 2024-007 adopting the Mid-Year Budget Amendment for Fiscal Year 2023-24.

Documents: Resolution 2024-007
Mid-Year Salary & Benefits
5 Year Capital Improvement Projects
Budget Journal Mid-Year FY2024
Council Reports
A. City Council Updates and Committee Reports

10. Staff Communications:

11. Future Agenda Items

1. Amend Ordinance - Temporary Outdoor Use Permits

2. Review of Cannabis Cultivation
Site Visits to Woodlake, Exeter, and Lindsay

4. Water Restrictions

5. Update City Ordinances related to Code Enforcement
:

6. Reopening Two-way Traffic on E. Citrus at Freedom Drive

7. Transit Services with Visalia Transit and TCRTA

12. Adjourn to Closed Session: :

A. CONFERENCE WITH LABOR NEGOTIATORS
Pursuant to Government Code Section 54957.6 :

Agency designated representative:

Jennifer Gomez, Steve Huntley, Teqia Velyines, and Michael Schulte
Employee organization:

Miscellaneous Employees
Police Officers Association
International Brotherhood of Teamsters Local 517
Mid-Management Employee Association.

Department Heads

CONFERENCE WITH LEGAL COUNSEL - ANTICIPATED LITIGATION
Significant exposure to litigation pursuant to Government Code Section :
54956.9 (d)(2): 1 case

CONFERENCE WITH LEGAL COUNSEL - ANTICIPATED LITIGATION
Initiation of litigation pursuant to Government Code Section 54956.9 (d)(4): 1 case
:

PUBLIC EMPLOYMENT
Pursuant to Government Code Section 54957
Title: City Attorney

13. Reconvene to Open Session:
:

14. Closed Session Report (if any):

15. Adjournment:

NOTICE TO PUBLIC
The City of Farmersville Civic Center and City Council Chambers comply with the provisions of the Americans with Disabilities Act (ADA). Anyone needing special assistance please contact City Hall at (559) 747-0458 please allow at least six (6) hours prior to the meeting so that staff may make arrangements to accommodate you.

Materials related to an item on this agenda submitted to the Council after distribution of the agenda packet are available for public inspection in the City's offices during normal business hours.

Drafted by: J. Gomez
:

Strong Roots..... Growing Possibilities •

CITY OF
FARMERSVILLE Farmersville City Council
Regular Meeting
Tina Hernandez, Mayor
Danny Valdovinos, Mayor Pro Tem Monday, February 12, 2024 6:00 PM Gregorio Gomez, Council Member Meeting held in Civic Center Council Chambers Paul Boyer, Council Member - 909 W. Visalia Road Farmersville, California Armando Hinojosa, Council Member
Pending no technical difficulties, the City Council meeting will also be streamed (for observation only) via Zoom and accessed as follows:

Please dial 1-669-900-6833
Meeting ID: 89650089380
Password: 459727
Call to Order: 6:00 pm
Roll Call:

Attendee Name Title Status Arrived
Tina Hernandez Mayor Present 6:00 pm
Danny Valdovinos Mayor Pro Tem Present 6:00 pm
Greg Gomez Council Member Present 6:00 pm
Paul Boyer Council Member Present 6:12 pm
Armando Hinojosa Council Member Present 6:00 pm
Invocation: Mayor Pro Tem Valdovinos
Pledge of Allegiance: Mayor Hernandez

5. Public Comment:

John Alvarez, a business owner in Farmersville, voiced concerns regarding the cost of his business license.

6. Presentations:

A. Business License Analysis & Ordinance Review - HdL Companies Eric Myers, a representative from HdL, delivered a PowerPoint presentation in which he discussed and reviewed the City's Business License and Ordinance. During the presentation, Mir. Myers utilized graphs and charts to summarize the current business tax. He offered examples illustrating the potential impact of a new business tax on the City. Mr. Myers answered questions from the Council. !
Discussion took place.

The Council instructed staff to prepare a report illustrating the potential changes that •
would occur if the current structure were altered without the need for a Prop 218.

Additionally, they requested that this topic be included as an agenda item for further discussion. :

B. Water & Sewer Utility Rate Study - Willdan Financial Services Chris Fisher; a representative from Willdan, presented the Council with a PowerPoint presentation outlining a five-year financial plan. The plan addressed funding for current and future operations, debt repayment, compliance, maintenance of operating reserves, establishment of a cost-based rate structure, and adherence to Proposition 218 requirements. Additionally, Mr. Fisher informed the Council that the Proposition 218 public hearing, will be scheduled for the Council meeting on April 22, 2024. At this • hearing, the Council will discuss and consider adopting the utility rate implementation. !

7. Consent Agenda:

A. Authorization to waive full reading of ordinances and resolutions and to identify by title only. :

Recommend that the City Council approve the full reading of all ordinances and resolutions be waived and to identify by title only.

B. Minutes of Regular City Council Meeting of January 22, 2024 Recommend approval of minutes.

Documents: Draft Action Minutes of January 22, 2024
Notice of Completion of the Farmersville ADA Improvement Project Recommend that the City Council accept the Farmersville ADA Improvements Project, and the City Council authorize the City Manager :
• • .
sign the Notice of Completion and the City Clerk file the Notice of Completion with the County Clerk's office.

Documents: Notice of Completion
Motion to approve as presented.

RESULT APPROVED (UNANIMOUS)
MOVER Councilmember Boyer
SECONDER Councilmember Gomez
AYES Hernandez, Valdovinos, Gomez, Boyer, Hinojosa
ABSENT

ABSTAIN

8. General Business
A. Cooperative Agreement between the City of Farmersville and the County of Tulare for Avenue 280 Widening Project - Segment 2 Recommend that the City Council authorize the City Manager to sign the Cooperative Agreement.

Documents: Cooperative Agreement
City Manager Jennifer Gomez provided the Council with background information on the agreement between the City of Farmersville and the County of Tulare for the Avenue 280 Widening Project. She explained that the project involves widening Avenue 280 between Lover's Lane in Visalia and Virginia Ave. in Farmersville. Additionally, South Virginia Avenue will be realigned at Visalia Road as part of the project. A storm basin will also be constructed on the south side of Visalia Road next to South Virginia. i
Discussion took place.
:

Motion to approve as presented.

RESULT APPROVED (UNANIMOUS)
MOVER _Mayor Pro Tem Valdovinos ,
SECONDER Councilmember Boyer
AYES Hernandez, Valdovinos, Gomez, Boyer, Hinojosa
ABSENT
ABSTAIN 0-0
B. 4Creeks Proposal for Construction Management Services and Inspection Services for the Fire Station 83 Project
Recommend that the City Council authorize the City Manager to contract with 4Creeks tor Construction Management Services and Inspection Services for the Fire Station 83 Project for an estimated Time and Materials amount of $ 160,770. :

Documents: 4Creeks Proposal
City Manager Jennifer Gomez briefed the Council on the background information - - regarding 4Creeks' proposal for construction management and inspection services for the Fire Station 83 project. The proposal includes construction management services, :
public works inspection services, materials testing, and special inspections.

Motion to approve as presented.

RESULT APPROVED (UNANIMOUS)
MOVER Councilmember Gomez
SECONDER Mayor Pro Tem Valdovinos
AYES Hernandez, Valdovinos, Gomez, Boyer, Hinojosa
ABSENT

ABSTAIN
:

9. Council Reports :

A. City Council Updates and Committee Reports
Councilmember Hinojosa asked if there were any updates on La Mejor. City Manager Jennifer Gomez informed the Council that she has been in contact with the owner, and she plans on rebuilding.

Councilmember Boyer raised a question about the potential crosswalk installation at • Snowden School. Additionally, Mr. Boyer shared his attendance at the League of California Cities New Mayor and Councilmembers conference, recommending that all • :
members consider attending next year. Furthermore, he provided an update on the Greater Kaweah Ground Water meeting he recently attended.

City Manager Jennifer Gomez updated the Council, informing them that the crosswalk at Snowden School was removed from the contractor's contract. She further explained that the City will now be responsible for installing the crosswalk.

Councilmember Gomez thanked the staff for their availability during the recent storms.

He also inquired about any potential damage caused by the storms. Public Works Director Jeff Dowien responded, informing the Council that there was minimal damage throughout the City, mainly limited to potholes. He assured them that the Public Works department is actively working to address and fill the potholes.

Mayor Pro Tem Valdovinos asked for an update on the Animal Control.contract.

Additionally, he requested that City staff reach out to the Tulare County Elections office to ensure there are no issues for residents intending to run for Council.

Attorney Michael Shulte advised the Council that he is currently working with the City of :

Visalia's attorney regarding the Animal Control contract.

10. Staff Communications:

City Manager Jennifer Gomez updated the Council, informing them that Townsend Public Affairs, our lobbyist, has submitted paperwork for the Fire Department's bulldozer ! and trailer. The request totals $950,000. This funding would be allocated in next year's budget with state or federal funds.

Public Works Director Jeff Dowlen reminded the Council about the availability of free compost near City Hall. He also updated, them on the installation process of baseball bleachers at Veterans Park, which Public Works has initiated. Furthermore, he informed the Council that the North half of Roy's Park has been completed.

Battalion Chief Thomas provided an update on a recent structure fire on February 9th.

Additionally, he informed the Council that both Code Enforcement officers had completed their first Code Enforcement module class with the State. :

11. Future Agenda Items

1. Amend Ordinance - Temporary Outdoor Use Permits

2. Review of Cannabis Cultivation

3. Site Visits to Woodlake, Exeter, and Lindsay

4. Water Restrictions

5. Update City Ordinances related to Code Enforcement

6. Reopening Two-way Traffic on E. Citrus at Freedom Drive

7. Transit Services with Visalia Transit and TCRTA

12. Adjourn to Closed Session:

Mayor Hernandez adjourned to closed session at 7:55 pm. :

A. CONFERENCE WITH LABOR NEGOTIATORS
Pursuant to Government Code Section 54957.6
Agency designated representative:

Jennifer Gomez, Steve Huntley, Teqia Velyines, and Michael Schulte
Employee organization:

Miscellaneous Employees
Police Officers Association )
International Brotherhood of Teamsters Local 517
Mid-Management Employee Association
Department Heads
B. PUBLIC EMPLOYMENT
Pursuant to Government Code Section 54957
Title: City Attorney

13.' Reconvene to Open Session:

Mayor Hernardez reconvened to open session at 9:18 pm with nothing to report.

14. Closed Session Report (if any):

15. Adjournment:

Mayor Hernandez adjourned the meeting at 9:18 pm.

Respectfully submitted,"
Rochelle Giovani, City Clerk :

Strong Roots..... Growing Possibilities
---
.: = -

CITY OF

FARMERSVILLE
City Council
Staff Report
Consent Item # 7C
TO: Honorable Mayor and City Council
FROM: Steve Huntley, CPFO, IPMA-SCP
Director of Finance & Administration
DATE: February 26, 2024
SUBJECT: Finance Update for January 2024: Warrant Register and Investment Summary
RECOMMENDED ACTION:

It is respectfully recommended that the City Council:

1. Approve the Warrant Register as presented for the period. This reporting period represents warrants issued for the Fiscal Year 2023/2024.

2. Accept the Investment Summary as presented for the period. This reporting period represents investment summary for the previous month.

COORDINATION & REVIEW:

Preparation and presentation of the Warrant Register has been coordinated with the City Finance Department and City Manager's Office.

Preparation and presentation of the Investment Summary is in compliance with Government Code 53607 and 53646(b) and has been coordinated with the City Finance Department and City Manager's Office.
1 FISCAL IMPACT:

Each demand has been audited for accuracy and sufficiency of funds for payment. The current Warrant Registers for November & December total to $1,312,911.36 inclusive of the following batches allowed for in the adopted Fiscal Year 2023/2024 Budaet NOVEMBER - -=
GENERAL FUND WARRANTS #137971-138020 147,261.03
GENERAL FUND WARRANTS #138021-138087 672,389.87
GENERAL FUND ACH #1002185 16,782.79
GENERAL FUND ACH #1002186-102207 9,420.00
GENERAL FUND ACH # #1002208-1002237 304,730.88
PAYROLL WARRANTS #14941-14984 80,508.71
PAYROLL WARRANTS # #14985-15111 VOID
PAYROLL WARRANTS #15112-15151 81,817.97
$1,312,911.36
CONCLUSION:

It is respectfully recommended that the City Council approve the Warrant Register as presented for the period January 1, 2024, to January 31, 2024:

It is respectfully recommended that the City Council accept the Investment Summary as presented for the period of December 2023
:

Attachments):

2. Mean no Silen a De, 20gi 2023.
2 CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

CHECHNA OUR DATE TYPE VENDOR NAME CASH COVE TO/OVE FRCHER INVOICE INV DATE PO WARRANT NET
01/18/2024 PRTD 542 THOMSON REUTERS 849496273 01/01/2024 3103 271.57 CHECK TOTAL: 271.57
01/18/2024 PRTD 544 SIERRA DESIGNS, INC 21-080-22 12/17/2023 3103 1,961.68 CHECK TOTAL: 1,961.68
| 01/18/2024 PRTD 849 MURILLO, JOSE ULISES 122823 12/28/2023 3103 333.00 CHECK TOTAL: 333.00
01/18/2024 PRTD 1015 ABLE INDUSTRIES, INC 122320 12/31/2023 3103 2,216.40 CHECK TOTAL: 2,216.40
01/18/2024 PRTD 1481 HINDERLITER DELLAMAS SIN034320 12/27/2023 3103 150.00 SIN032397 09/30/2023 3103 300.00
CHECK TOTAL: 450.00
• 01/18/2024 PRTD 1491 SIERRA AERIFORM LLC 1444 12/27/2023 3103 200.00 CHECK TOTAL: 200.00
01/18/2024 PRTD 1517 CITY OF TULARE FIRE TRN-10223 10/03/2023 3103 700.00 CHECK I TOTAL: 700.00
01/18/2024 PRTD 1598 CSET 123123 01/11/2024 3103 7,824.45 063023 06/30/2023 3103 2,740.45
083123 08/31/2023 3103 7,281.84
CHECK TOTAL: 17,846.74
01/18/2024 PRTD 1636 CRAWFORD & BOWEN PLA 856 01/04/2024 3103 980.00 CHECK TOTAL: 980.00
sport generated: 02/3m42024 09:46 Page
6175mame
Program ID: apeshdsb
CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

VOUCHER INVOICE INV DATE PO WARRANT NET
01/18/2024 PRTD 1662 LIEBERT CASSIDY WHIT 256668 11/30/2023 3103 127.50 255768 11/30/2023 3103 34.50
CHECK TOTAL: 162.00
01/18/2024 PRTD 1695 SUPERIOR POOL PRODUC 02025643 12/06/2023 3103 2,546.70 02025789 12/27/2023 3103 1,282.78
02025817 01/02/2024 3103 -550.00
CHECK TOTAL: 3,279.48
01/18/2024 PRTD 1702 CAL BENNETTS INC. 27831-0 12/12/2023 3103 377.13 CHECK TOTAL: 377.13
• 01/18/2024 PRTD 2011 ROGER VOGT'S PERFORM 36061 08/02/2023 3103 1,100.16 CHECK I TOTAL: 1,100.16
01/18/2024 PRTD 2203 WESTSCAPES, INC 20984 12/31/2023 3103 2,275.00 CHECK I TOTAL: 2,275.00
01/18/2024 PRTD 2266 TFD ENTERPRISES LLC 10 12/08/2023 3103 5,539.44 CHECK TOTAL: 5,539.44
• 01/18/2024 PRTD 2267 TOWNSEND PUBLIC AFFA 20382 09/01/2023 3103 5,000.00 CHECK I TOTAL: 5,000.00
N 01/18/2024 PRTD 2285 THE POLICE AND SHERI 186466 12/14/2023 | 3103 17.60 CHECK TOTAL: 17.60
01/18/2024 PRTD 2304 KINGS MEDICAL CENTER 211848 01/11/2024 3103 879.41 CHECK • TOTAL: 879.41
eport generated: 01/18/2024 09:46 Page 2
User: 175mame
Program ID: apcshdsb
CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

CHECK OUR DARE TAPE VENDOR NAME CASH COUE TO/DUE ORCHER INVOICE WARRANT

INV DATE PO NET
01/18/2024 PRTD 2374 KNOWBE4, INC. 122923 12/29/2023 3103 341.88 CHECK TOTAL: 341.88
01/18/2024 PRTD 2400 PANKEY, DAVID 121923 12/19/2023 3103 51.00 CHECK TOTAL: 51.00
01/18/2024 PRTD 2403 LEBOEUF, RACHEL 121923 12/19/2023 3103 185.00 CHECK TOTAL: 185.00
01/18/2024 PRTD 2460 ASPEN RENTALS, INC 6288607 12/19/2023 3103 15,768.75 CHECK TOTAL: 15,768.75
01/18/2024 PRTD 2472 PACIFIC STORAGE COMP 5190299 12/31/2023 3103 145.80 CHECK TOTAL: 145.80
| 01/18/2024 PRTD 2505 CALPORTLAND COMPANY 96183521 12/28/2023 3103 1,529.04 96183520 12/27/2023 3103 1,529.04
96171635 12/14/2023 3103 1,534.48
96162694 12/01/2023 3103 1,353.95
96171636 12/15/2023 3103 2,018.43
CHECK • TOTAL: 7,964.94
01/18/2024 PRTD 2508 WILSON TACTICAL OPER 121923 12/19/2023 3103 745.00 CHECK • TOTAL: 745.00
01/18/2024 PRTD 2509 CERCAS, BRENDA 122823 12/28/2023 3103 333.00 CHECK TOTAL: 333.00
M 01/18/2024 PRTD 2510 GANNETT CALIFORNIA L 0006143582 12/31/2023 3103 1,110.22 Vroor enerated: 02282302 0-16 Page
6175mame
apcshdsb
CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

CHECK A OUR DATE TYPE VENDOR NAME CASH COVE TO/OVE FROM VOUCHER INVOICE INV DATE PO WARRANT NET CHECK TOTAL: 1,110.22
01/18/2024 PRTD 3602 BILL WALL'S DIRECT A 16830 12/29/2023 3103 90.00 16828 12/22/2023 3103 90.00
16827 12/15/2023 3103 240.00
16833 01/05/2024 3103 330.00
16831 12/29/2023 3103 210.00
16829 12/22/2023 3103 360.00
CHECK TOTAL: 1,320.00
01/18/2024 PRTD 4867 BOYS & GIRLS CLUB OF 101857 11/30/2023 3103 18,442.88 CHECK I TOTAL: 18,442.88
01/18/2024 PRTD 4901 BROCK, JAY 011124 01/11/2024 3103 407.00 CHECK • TOTAL: 407.00
M 01/18/2024 PRTD 4901 BROCK, JAY 121923 12/19/2023 3103 407.00 CHECK I TOTAL: 407.00
01/18/2024 PRTD 5300 B S & E COMPANY, INC 351272 12/14/2023 3103 118.51 350978 12/11/2023 3103 147.65
CHECK TOTAL: 266.16
| 01/18/2024 PRTD 6085 CASCADE FIRE EQUIPME INV9366 12/19/2023 3103 274.05 INV9314 12/14/2023 3103 116.58
CHECK • TOTAL: 390.63
S 01/18/2024 PRTD 9940 DEPARTMENT OF JUSTIC 700262 12/05/2023 3103 200.00 CHECK TOTAL: 200.00
port ered: 042021 0.16 Page 4
aposhdsb
CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

CHECK NACHK DATE TYPE VENDOR NAME CASH COUE TO/OUE OUCHER INVOICE WARRANT

INV DATE PO NET
01/18/2024 PRTD 10600 EVRETT, TROY 011124 01/11/2024 3103 310.50 CHECK I TOTAL: 310.50
• 01/18/2024 PRTD 10600 EVRETT, TROY 121923 12/19/2023 3103 379.50 CHECK TOTAL: 379.50
| 01/18/2024 PRTD 12000 FARLEY LAW FIRM 122723 12/27/2023 3103 16,935.65 CHECK I TOTAL: 16,935.65
01/18/2024 PRTD 14651 FGL ENVIRONMENTAL 348161A 12/18/2023 3103 99.00 346197A 09/23/2023 3103 41.00
346198A 09/23/2023 3103 41.00
346196A 09/23/2023 3103 41.00
346195A 09/23/2023 3103 99.00
346019A 09/21/2023 3103 41.00
344863A 08/07/2023 3103 99.00
348416A 12/27/2023 3103 99.00
CHECK I TOTAL: 560.00
- 01/18/2024 PRTD 14785 THE GLASS SHOP, INC. 1-23-1331 11/10/2023 3103 1,545.00 CHECK I TOTAL: 1,545.00
01/18/2024 PRTD 16580 GRAFIX SHOPPE 154094 11/29/2023 3103 268.00 CHECK • TOTAL: 268.00
• 01/18/2024 PRTD 16603 GROSS & STEVENS INC 139357 12/21/2023 3103 2,056.70 CHECK TOTAL: 2,056.70
are generated: 0928202 0:46 Page 5
apcshdsb
CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

CASH (DUE TO/DUE FUCHER INVOICE INV DATE PO WARRANT
NET
01/18/2024 PRTD 20000 IDEA PRINTING & GRAP 121145 12/22/2023 3103 119.35 CHECK I TOTAL: 119.35
• 01/18/2024 PRTD 37000 QUAD KNOPF, INC. 121635 12/20/2023 3103 1,484.65 CHECK TOTAL: 1,484.65
01/18/2024 PRTD 41000 SELF-HELP ENTERPRISE FVL12RE JUL-OCT23 12/29/2023 3103 18,170.40 CHECK TOTAL: 18,170.40
01/18/2024 PRTD 43673 SWRCB LW-1046413 12/20/2023 3103 9,111.92 CHECK TOTAL: 9,111.92
01/18/2024 PRTD 43760 SUN-GAZETTE 712735 01/09/2024 3103 220.00 712734 01/09/2024 3103 220.00
CHECK I TOTAL: 440.00
• 01/18/2024 PRTD 45000 TRUCK PARTS AND SERV 117897 12/30/2023 3103 812.50 CHECK I TOTAL: 812.50
01/18/2024 PRTD 51555 VINCENT COMMUNICATIO 87001 09/19/2023 3103 270.00 CHECK I TOTAL: 270.00
01/18/2024 PRTD 52000 VISALIA TIMES DELTA/ 0006073670 11/30/2023 3103 1,309.09 CHECK I TOTAL: 1,309.09
• 01/18/2024 PRTD 53075 WATER TECHNOLOGY OF 23-9951 12/26/2023 3103 1,818.90 CHECK I TOTAL: 1,818.90
usert generated: 01/3ha2024 09:46 Page 6
Program ID: apeshdsb
CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL
NUMBER OF CHECKS 50 *** CASH ACCOUNT TOTAL *** 147,261.03

COUNT AMOUNT
TOTAL PRINTED CHECKS 50 147-261.03
*** GRAND TOTAL *** 147,261.03
Report generated: 01/18/2024 09:46 Page
User: 6175mame
Program ID: apcshdsb
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3103 NEW INVOICES

DOCUMENT

VENDOR REMIT NAMEN INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE

APPROVED UNPAID INVOICES TO BE POSTED
542 000000 THOMSON REUTERS 829936273 3103 271.57 - 00 -00 CASH 01 2024/07 INV 01/01/2024 SEP-CHK: N DES PROFESSIONAL SERVICE 01411 5205 271.57 1099:

ACCT 1100 DEPT DUE 01/16/2024
CONDITIONS THAT PREVENT POSTING INVOICE 542/47093
* w9hld
544 00000 SIERRA DESIGNS, 21-080-22 3103 1,961.68 .00 .00 ASH 01 2024/07 INV 12/17/2023 DESCE FREE PROFESSIONAL SERVICE DISC: .01 31425 5516 FREE 1,961.68 1099:

CCT 110( DUE 01/16/2024
849 00000 MURILLO, JOSE UL 47084 3103 333.00 .00 -00
122823
CASH 01 2024/07 INV 12/28/2023 DES MODULE ONE ACADEMI DISC: .0 01415 5208 333.00 1099:0 ACCT 1100 DUE 01/16/2024
CONDITIONS THAT PREVENT POSTING INVOICE 849/47084
1015 00000 ABLE INDUSTRIES, 47152 3103 2,216.40 .00 .00 122320
CASH 01 2024/07 DISC: .0l 01425 5205 2,216.40 1099:

ACCT 1100 DA 22 DESPROFESSTONAL SERVICE
CONDITIONS THAT PREVENT POSTING INVOICE 1015/47152
* w9h1d
1481 00000 HINDERLITER DELL 47143 3103 150.00 .00 .00
SIN034320
ACT 1100 2024/07 DUE 022/2024 DESCRESSIONAL SERVICE DISC: .01 01414 5205 150.00 1099:

CONDITIONS THAT PREVENT POSTING INVOICE 1481/47143
* w9h1d
sert generated: 61/3man024 09:38 Page 1
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3103 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 1481 00000 HINDERLITER DELL 47145 3103 300.00 •00 -00
SINO32397
CASH 01 2024/07 INV 09/30/202 SES CBS-PROFESSIONAL SERVICE DISC: 01404 5205 CNBIS 300.00 1099:

ACCT 1100 UE 01/16/202
CONDITIONS THAT PREVENT POSTING INVOICE 1481/47145
1491 00000 SIERRA AERIFORM 17124 3103 200.00 - 00 .00
CASH 01 2024/07 INV 12/27/2023 SEP-CHK: N SES FREES-PROFESSIONAL SERVICE 31425 5516 FREE 100.00 1099:

ACCT 1100 DEPT DUE 01/16/2024 12400 5516 AHSC 100.00 1099:

CONDITIONS THAT PREVENT POSTING INVOICE 1491/47124
W9h1d
1517 00000 CITY OF TULARE F 47115 3103 700.00 .00 -00
TRN-10223
CASH 01 2024/07 NV 10/03/202 01420 5208 700.00 1099:

ACCT 1100 UE 01/16/202 DESCE PROFESSIONAL SERVIC SERVIC CONDITIONS THAT PREVENT POSTING INVOICE 1517/47115
* w9hld
1598 00000 CSET 47111 3103 7,824.45 .00 .00
123123
2024/07 SESC PROFESSIONAL SERVICE DISC: .0 01414 5205 7,824.45 1099:

CONDITIONS THAT PREVENT POSTING INVOICE 1598/47111
* W9h1d
1598 00000 CSET 063323 3103 2,740.45 .00 .00
CASH 01 2024/07 INV 06/30/2023 DESC: PROFESSTONAL SERVICE SEP-CHK: N 01414 5205 2,740.45 1099:

ACCT 1100 DEPT DUE 01/16/2024
CONDITIONS THAT PREVENT POSTING INVOICE 1598/47130
* w9h1d
üserrt generated: 01/3ma2024 09:38 Page 2
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3103 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 1598 00000 CSET 47131 3103 7,281.84 -00 .00
083123
EAST 1100 2024/07 IN 0/1/2024 DESCEPROFESSIONAL SERVICE 01414 5205 7,281.84 1099:

DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 1598/47131
* w9hld
1636 00000 CRAWFORD & BOWEN 47083 3103 980.00 -00 - 00
2024/07 DUE 01/1/2024 DESPIRD-PROFESSIONAL SERVICE 60425 5504 PWYRD 980.00 1099:

ACCT 1100 DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 1636/47083
* wahld
1662 00000 LIEBERT CASSIDY 47127 3103 127.50 .00 •00
256668
ASH 0 2024/07 IN 01/10/2024 SECESSIONAL SERVICE 01406 5205 127.50 1099:

CCT 110( DEPT DUE 01/16/2024
CONDITIONS THAT PREVENT POSTING INVOICE 1662/47127
* w9hld
1662 00000 LIEBERT CASSIDY 47128 3103 34.50 - 00 -00
255768
AST 1100 2024/07 NV 11/30/202 01404 5205 34.50 1099:

DEPT JE 01/16/202
CONDITIONS THAT PREVENT POSTING INVOICE 1662/47128
1695 00000 SUPERTOR POOL PR 42025643 3103 2,546.70 - 00 .00 CAST 1100 2024/07 DES: PROFESSIONAL SERVICE DISC: .00 02425 5202 2,546.70 1099:

DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 1695/47134
W9h1d
user generated: 01/3a2024 09:38 Page 3
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3103 NEW INVOICES

DOCUMENT

VENDOR REMIT NAMEN INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 1695 00000 SUPERIOR POOL PR 47154 3103 1,282.78 .00 .00 Q2025789
AACT 1100 2024/07 DUE 02/27/2024 DESCOPER SUPPLIES DISC:.00 02425 5202 1,282.78 1099:

DEP
CONDITIONS THAT PREVENT POSTING INVOICE 1695/47154
* w9hld
1695 00000 SUPERTOR POOL PR 42025817 3103 -550.00 .00 - 00 CASH 01 2024/07 INV 01/02/2024 SEP-CHK: N DISC: .00 02425 5202 -550.00 1099:

ACCT 1100 DEPT DUE 01/02/2024 DESC: CREDIT
CONDITIONS THAT PREVENT POSTING INVOICE 1695/47157
W9h1d
1702 00000 CAL BENNETTS INC 47081 3103 377.13 .00 .00
27831-0
CASH 01 2024/07 ONE 02/12/2023 DESC:PROFESSTONAL SERVIC DISC: .0 01404 5504 377.13 1099:

ACCT 1100 DUE 01/16/2024
CONDITIONS THAT PREVENT POSTING INVOICE 1702/47081
2011 00000 ROGER VOGT'S PER 17061 3103 1,100.16 .00 .00 ACCT 1100 2021/07 DUE 01/46/2023 DES PROFESSIONAL SERVIC DISC: .0 01420 5204 1,100.16 1099:

CONDITIONS THAT PREVENT POSTING INVOICE 2011/47113
* w9hld
2203 00000 WESTSCAPES, INC 20944 3103 2,275.00 .00 -00
ASH 01 2024/07 INV 12/31/2023 SEP-CHK: N DESC PROFESSIONAL SERVICE 35425 5205 2,275.00 1099:

ACCT 1101 DEPT DUE 01/16/2024
CONDITIONS THAT PREVENT POSTING INVOICE 2203/47149
usert generated: 01/3ha2024 09:38 Page 4
6175mame
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3103 NEW INVOICES

DOCUMENT

VENDOR REMIT NAMER INVOICEN PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 2266 00000 TED ENTERPRISES 17144 3103 5,539.44 .00 .00
CAST 1100 2024/07 IN 02182024 SECURESSIONAL SERVOO 04425 5205 5,539.44 1099:

DEPT
2267 00000 TOWNSEND PUBLIC 10382 3103 5,000.00 •00 - 00 EAST 1100 2024/07 TUE 0/1/2024 SECURO ESSIONAL SERVICE 01404 5205 5,000.00 1099:

DEPT
2285 00000 THE POLICE AND S 47098 3103 17.60 .00 .00
186466
EAST 1100 2024/07 NE 0214/2023 DESC:PROFESSIONAL SERVIC ISC: .0 01411 5205 17.60 1099:

DEPT
2304 000000 KINGS MEDICAL CE 471848 3103 879.41 .00 .00 CASH 01 2024/07 INV 01/11/2024 SES: PROFESSIONAL SERVICE DISC: .00 01425 5205 ACCT 1100 DEPT DUE 01/16/2024 02425 5205 93:10 1099:

CONDITIONS THAT PREVENT POSTING INVOICE 2304/47100
04425 5205
21425 5205 87: 6° 1039;
01411 5205 607.01
2374 00000 KNOWBE4, INC. 7087 3103 341.88 .00 •00
2292
ACT 1100 2021/07 BUY 02/18/2024 DESCROFESSIONA SERViCE 01404 5205 341.88 1099:
2400 00000 PANKEY, DAVID 123923 3103 51.00 -00 • 00
CAST 1100 2021/07 IN 01/202 DESERS SING SYSTEM INSTRUCTOR COURSE1411 5208 51.00 1099:

CONDITIONS THAT PREVENT POSTING INVOICE 2400/47104
*W9h1d
usert generated: 01/33a2024 09:38 Page 5
Program ID:

CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3103 NEW INVOICES

DOCUMENT

VENDOR REMIT NAMER INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 2403 00000 LEBOEUF, RACHEL 121923 3103 185.00 .00 .00
CAST 1100 2021/07 Due 02/18/2023 SES-CHICA CONFERENCE: 100 01411 5208 185.00 1099:

CONDITIONS THAT PREVENT POSTING INVOICE 2403/47103
*W9h1d
2460 000000 ASPEN RENTALS, I 4288607 3103 15,768.75 -00 .00 CASH 01 2024/07 INV 12/19/2023 SES-SDGE-PROFESSIONAL SERVICE DISC: .00 04425 5205 SLDGE 15,768.75 1099:
сст 1100 DEPT DUE 01/16/2024
CONDITIONS THAT PREVENT POSTING INVOICE 2460/47142
W9hld
2472 00000 PACIFIC STORAGE 47148 3103 145.80 .00 .00
5190299
ACT 1100 2024/07 ONE 02/1/2024 DESOSTONAL SERVICE 1411 5205 35.40 1099 DEPT 1406 520
2505 00000 CALPORTLAND COMP 47106 3103 1,529.04 .00 .00 96183521
ISH 0 2024/07 NV 12/28/202 SEP-CHK: N 60404 5516 ROYZ 1,529.04 1099:

CT 110 DEPT UE 01/16/202 DESCROYZ PROFESSTONAL SERVICE
2505 00000 CALPORTLAND COMP 47183520 3103 1,529.04 .00 .00 ACCT 1100 2024/07 DUE 02/22/2024 DISC: 60404 5516 ROYZ 1,529.04 1099:

DEPT SES CROY PROFESSIONAL SERVICE
2505 00000 CALPORTLAND COMP 47108 3103 1,534.48 •00 .00 96171635
AST 1100 2024/07 DUE 0212024 SEC:PK-PROFESSIONAL SERVICE 31425 5516 ROYPK 1,534.48 1099:

DEPT
2505 00000 CALPORTLAND COMP 47109 3103 1,353.95 - 00 .00 96162694
2024/07 DUE 02/16/2024 DESCRIPROFESSTONAL SERVICI DISC: .0 60404 5516 ROY2 1,353.95 1099:

Usert generated: 0143man024 09:38 Page 6
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3103 NEW INVOICES

DOCUMENT
VENDOR REMIT NAMER INVOICE Po VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 2505 00000 CALPORTLAND COMP 47110 3103 2,018.43 .00 .00 96171636
2024/0 TU SECHO: ROPK-PEOFESSONAL SERVICE 52425 3516 R0YK 1,008.09 1099:
2508 00000 WILSON TACTICAL 121923 3103 745.00 .00 .00
CAST 1100 2024/07 DUE 02/16/2024 DESCREARMS SIGHTING SYSTEM INSTRUCTORS COURSE 01411 5208 745.00 1099:

DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 2508/47105
* w9hld
2509 00000 CERCAS, BRENDA 47085 3103 333.00 -00 - 00
L22823
CAST 1100 2024/01 NV 12/28/202: DES MODULE ONE ACADEM ISC: .0 01415 5208 333.00 1099:

DEPT UE 01/16/202
CONDITIONS THAT PREVENT POSTING INVOICE 2509/47085
w9hld
2510 00000 GANNETT CALIFORN 4706143582 3103 1,110.22 -00 -00 CASH 01 2024/07 INV 12/31/2023 DESC PROFESSIONAL SERVICE SEP-CHK: N 01414 5205 1,110.22 1099:

ACCT 1100 DEPT, DUE 01/16/2024
CONDITIONS THAT PREVENT POSTING INVOICE 2510/47090
* W9h1d
3602 00000 BILL WALL'S DIRE 47094 3103 90.00 -00 .00
16830
ASH 01 2024/07 DA 2202023 DESOSULTING DISC: .00 01411 5205 90.00 1099:0 сст 1100 DEPT
3602 00000 BILL WALL'S DIRE 12828 3103 90.00 -00 .00
CASH 01 2024/07 CNV 12/22/2023 SEP-CHK: / DISC:.00 01411 5205 90.00 1099:0 ACCT 1100 DEPT DUE 01/16/2024 DESC: CONSULTINC

Page 7 ends

Prora enerated: 012024 0:38
apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3103 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 3602 00000 BILL WALL'S DIRE 47096 3103 240.00 .00 •00
16827
CAST 1100 01411 5205 240.00 1099:0
3602 00000 BILL WALL'S DIRE 17833 3103 330.00 .00 .00
ACCT 1100 2024/07 DISC: 00 01406 5205 330.00 1099:0
DEPT DUE 01/15/2024 DESCECONSULTING
3602 00000 BILL WALL'S DIRE 12831 3103 210.00 .00 •00
ASH 01 2024/07 wv 12/29/2023 SEP-CHK: _ DISC: .00 01406 5205 210.00 1099:0 сст 1100 DEPT JE 01/16/2024 DESC: CONSULTIN
3602 00000 BILL WALL'S DIRE 17329 3103 360.00 - 00 • 00 CASH 01 2024/07 INV 12/22/2023 SES CONSULTING DISC: .01 01406 5205 360.00 1099:0 ACCT 1100 DEPT DUE 01/16/2024
4867 00000 BOYS & GIRLS CLU 47123 3103 18,442.88 .00 -00 101857
2024/07 01414 5205 18,442.88 1099:

DEPT
4901 00000 BROCK, JAY 709 3103 407.00 -00 .00
1112
CAST 1100 2024/07 01411 5208 407.00 1099:

DEPT
4901 00000 BROCK, JAY 47101 3103 407.00 -00 .00
121923
CASH 01 2024/07 DUE 02/16/2023 DESC:POST" *EXECUTIVE COURSE 01411 5208 407.00 1099:

ACCT 1100 DUE 01/16/2024
5300 00000 B S & E COMPANY, 553252 3103 118.51 - 00 .00 CASH 01 2024/07 INV 12/14/2023 SEP-CHK:_ DISC: .00 60404 5516 ROY2 118.51 1099:

ACCT 1100 DEPT DUE 01/02/2024 DESC: ROY2-PROFESSIONAL SERVIC usert generated: 01133a024 09:38 Page 8
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3103 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 5300 00000 B S & E COMPANY, 150998 3103 147.65 -00 -00
CAST 1100 DEP4/0 DUE 02/02/2023 DESCROY PROFESSTONA SERVICE 60404 5516 ROY2 147.65 1099:
6085 00000 CASCADE FIRE EQU 47118 3103 274.05 •00 • 00
INV9366
CAST 1100 2021/07 IN 26202 SEER"SUPPLIES DISC: .00 01420 5202 274.05 1099:
6085 00000 CASCADE FIRE EQU 47119 3103 116.58 -00 - 00
INV9314
CAST 1100 2024/07 UE 02/16/2024 DESCOPER SUPPLIE SEP-CHK: DISC: .00 01420 5202 116.58 1099:

DEPT
9940 00000 DEPARTMENT OF 3U 420262 3103 200.00 .00 -00
SH C 2024/07 NV 12/05/2023 DES: PROFESSIONAL SERVICE DISC: .O1 01411 5205 200.00 1099:
ст 11( DEPT UE 01/16/2024
10600 00000 EVRETT, TROY 7092 3103 310.50 -00 •00
011124
CAST 1100 2024/07 IN 012024 SECRET MANAGEMENT COURSE 01411 5208 310.50 1099:

DEPT
10600 00000 EVRETT, TROY 121923 3103 379.50 .00 •00
CAST 1100 2021/07 IN 02/16/2024 SECOST MANAGENENT COURSE 01411 5208 379.50 1099:
12000 00000 FARLEY LAW FIRM 422713 3103 16,935.65 - 00 • 00 CAST 1100 2024/07
DEPT IN 02/22/202 SECURESSIONAL SEAVE
3208 385
3,947.13 1099:0
Hora enerated: 0/182024 09:38 Page 9
apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3103 NEW INVOICES

DOCUMENT

VENDOR REMIT NAMEN INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 14651 00000 FGL ENVIRONMENTA 47135 3103 99.00 -00 -00
348161A
CAST 1100 DESC: PROFESSIONAL SERVIC ISC: .( 02425 5205 99.00 1099:
14651 00000 FGL ENVIRONMENTA 47136 3103 41.00 -00 -00
346197A
CAST 1 2024/07 IN 01/2/2024 SES:PROFESSIONAL SERVICE DISC: .00 02425 5205 41.00 1099:
14651 00000 FL ENWIROMMENTA 476198A 3103 41.00 - 00 .00 ACT 1100 2024/07 DISC: 00 02425 5205 41.00 1099:

DEPT
14651 00000 FL ENVIRONMENTA 376396A 3103 41.00 - 00 .00 ASH 0. 2024/07 INV 09/23/2023 SESC: PROFESSIONAL SERVICE DISC: 00 02425 5205 41.00 1099:

CCT 1100 DEPT DUE 01/16/2024
14651 00000 FGL ENVIRONMENTA 47139 3103 99.00 -00 -00
346195A
ASH O 2024/07 TN SECRETIONAL SERVICE 02425 5205 99.00 1099:

ССт 1100 DEPT
14651 00000 FGL ENVIRONMENTA 47140 3103 41.00 .00 .00
346019A
ACET 1100 20P1/07 02425 5205 41.00 1099:
14651 00000 FL ENVIROMENTA 374863A 3103 99.00 •00 .00
2024/07 02425 5205 99.00 1099:

DEPT DUE 0/2024 DESCROFESSIONAL SERVICE
14651 00000 FL ENVIRONMENTA 373416A 3103 99.00 .00 -00
ASH O 2024/07 ENV 12/27/2023 DISC: .00 02425 5205 99.00 1099:
сст 110 DEPT DUE 01/16/2024 SES PROFESSIONAL SERVICE
usert generated: 0173ma2024 09:38 6175mame Page 10
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3103 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 14785 00000 THE GLASS SHOP, 1723-1331 3103 1,545.00 .00 .00 ACT 1100 2024/07 B0e 00/18/2023 SES PRESSIONAL SERVICE 01404 5205 1,545.00 1099:

DEPT
16580 00000 GRAFIX SHOPPE 154294 3103 268.00 .00 .00
CAST 1100 2024/0 ONE 07/26/2024 DESC:PROFESSIONAL SERViCE 01411 5204 268.00 1099:
16603 00000 GROSS & STEVENS 47097 3103 2,056.70 .00 .00 139357
ACT 1100 DEP/ DUE 02/2/2024 DES: PROFESSTONAL SERViCE 01411 5204 2,056.70 1099:
20000 00000 IDEA PRINTING & 121145 3103 119.35 -00 -00
ACCT 1100 2024/07 INV 12/22/2023 DISC: .00 01420 5202 119.35 1099:

DEPT DUE 01/16/2024 SES PROFESSIONAL SERVICE
37000 00001 QUAD KNOPF, INC. 121635 3103 1,484.65 -00 .00 ACET 1100 DEP/07 DUE 02/28/2024 DES-: PROFESSIONAL SERViCE 01414 5205 1,484.65 1099:
41000 00000 SELF-HELP ENTERP 47160 3103 18,170.40 -00 .00 FVL12RE JUL-OCT23
ACT 1100- 2021/07 ONE 002/2024 DESC:O-PROFESSIONAL SERVICE 12400 5205 00005 18,170.40 1099:
43673 00001 SWRCB 1W=2046413 3103 9,111.92 -00 .00
EACH 1100 2024/07 DUE 026/2024 DESC:PROFESSTONAL SERVICE 02425 5205 9,111.92 1099:

DEPT
43760 00000 SUN-GAZETTE 272735 3103 220.00 .00 .00
ASH O 2024/07 DUE 012024 SESPROESSTONAL SERVICE 01414 5205 220.00 1099:
сст 110( DEPT DUE 01/16/2024
User: prora enerated: 02/2e2024 00:38 Page 11
Program ID:
munis

CITY OF FARMERSVILLE
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3103 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 43760 00000 SUN-GAZETTE 17089 3103 220.00 -00 -00
712734
CAST 1100 201/07 01414 5205 220.00 1099:
45000 00000 TRUCK PARTS AND 47116 3103 812.50 - 00 -00
117897
ASH 01 2024/07 TUN 02/36/2024 SES:PRO ESSIONAL SERVICE DISC: .00 01420 5504 812.50 1099:

ACCT 110( DEPT
51555 00000 VINCENT COMMUNIC 47001 3103 270.00 -00 .00
2024/07 INV 09/19/2023 DISC: .00 01420 5204 270.00 1099:

CAST 1100 DEPT DUE 01/16/2024 SES PROFESSIONAL SERVICE
52000 00001 VISALIA TIMES DE 47122 3103 1,309.09 .00 -00 0006073670
CASH 01 2024/07 INV 11/30/2023 01414 5205 215.48 1099
ACCT 1100 DEPT DUE 01/16/2024 01404 5205 371.24 1099
01414 5205 381.28 1099
01414 5205 341.09 1099
53075 00000 WATER TECHOLOGY 43-5951 3103 1,818.90 •00 .00 CASH 01 2024/07 INV 12/26/2023 ONE 02/26/2024 DESC: PROFESSIONAL SERVICE SEP-CHK: N 02425 5205 1,818.90 1099:0 ACCT 1100 DEPT
75 APPROVED UNPAID INVOICES TOTAL 147,261.03
75 INVOICE (S) REPORT POST TOTAL 147,261.03]
Veran enerated: 034iam024 09:38 Page 12
6175mame
apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

HE DATE EVEN NAME CASH DUE TO/DUE FUCH) VOUCHER INVOICE INV DATE PO WARRANT NET • 01/22/2024 PRTD 127 QUALITY MUFFLER SERV 189372 10/05/2023 3104 1,026.73 CHECK TOTAL: 1,026.73
• 01/22/2024 PRTD 626 STRADLING YOCCA CARL 403466 01/10/2024 3104 367.50 CHECK • TOTAL: 367.50
01/22/2024 PRTD 633 CHARTER COMMUNICATIO 170047601122123 12/21/2023 3104 3,305.64 CHECK TOTAL: 3,305,64
01/22/2024 PRTD 769 AMERICAN INCORPORATE 7169205 12/22/2023 3104 1,466.00 CHECK TOTAL: 1,466.00
• 01/22/2024 PRTD 990 TERMINIX 441341629 12/13/2023 3104 122.00 441341257 12/13/2023 3104 78.00
CHECK TOTAL: 200.00
01/22/2024 PRTD 1207 PROFESSIONAL PRINT & 119314 01/04/2024 3104 2,364.06 CHECK • TOTAL: 2,364.06
01/22/2024 PRTD 1234 AUTOZONE 3711558270 11/20/2023 3104 29.06 CHECK I TOTAL: 29.06
01/22/2024 PRTD 1242 CALIFORNIA BUSINESS 338967 12/15/2023 3104 253.65 CHECK TOTAL: 253.65
01/22/2024 PRTD 1245 HUNTLEY, STEVE 011724 01/17/2024 3104 140.75 CHECK TOTAL: 140.75
01/22/2024 PRTD 1245 HUNTLEY, STEVE 11724 01/17/2024 3104 161.25 CHECK I TOTAL: 161.25
Report generated: 01/22/2024 16:48 Page 1
User: 6175mame
Program ID: apcshdsb
CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

CHECK NO CAN DATE TYPE VENDOR NAME CASH DUE TO/DUE FUCH VOUCHER INVOICE INV DATE PO WARRANT NET
01/22/2024 PRTD 1245 HUNTLEY, STEVE 01172024 01/17/2024 3104 264.50 CHECK TOTAL: 264.50
| 01/22/2024 PRTD 1361 TULARE KINGS HISPANI 18997-33439 01/01/2024 3104 175.00 CHECK TOTAL: 175.00
01/22/2024 PRTD 1378 MID VALLEY DISPOSAL м-2024-6 01/22/2024 3104 42,881.57 CHECK TOTAL: 42,881.57
01/22/2024 PRTD 1456 FRANCHISE TAX BOARD 122023 01/19/2024 3104 648.03 CHECK TOTAL: 648.03
NG 01/22/2024 PRTD 1481 HINDERLITER DELLAMAS SIN034417 11/30/2023 3104 132.00 CHECK TOTAL: 132.00
MY 01/22/2024 PRTD 1555 METLIFE 121423 12/14/2023 3104 6,750.73 CHECK • TOTAL: 6, 750.73
01/22/2024 PRTD 1633 PITNEY BOWES 1024409606 12/31/2023 3104 157.48 CHECK TOTAL: 157.48
01/22/2024 PRTD 1657 LASQUITE, ANTHONY WI 010424 01/04/2024 3104 250.00 CHECK A TOTAL: 250.00
01/22/2024 PRTD 1658 DIAZ, VINCENT A. 010524 01/04/2024 3104 500.00 CHECK I TOTAL: 500.00
01/22/2024 PRTD 1761 AUTOTECH SERVICE CEN 1115507 11/22/2022 3104 41.75 1115497 11/22/2022 3104 41.75
1115487 11/21/2022 3104 51.75
Report generated: 01/22/2024 16:48 Page 2
User: 6175mamd
Program ID: apcshdsb
CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

CHECK NA COK DATE TYPE VENDOR NAME CASH COUE TO/DUE DUCHER INVOZCE WARRANT

INV DATE PO NET
1115493 11/21/2022 3104 41.75
1115489 11/21/2022 3104 41.75
1115512 11/22/2022 3104 41.75
CHECK I TOTAL: 260.50
01/22/2024 PRTD 1854 PROACTIVE ENVIRONMEN 32582 09/14/2023 3104 169.95 CHECK TOTAL: 169.95
01/22/2024 PRTD 2100 AT&T MOBILITY 1022024 01/02/2024 3104 2,380.85 CHECK TOTAL: 2,380.85
| 01/22/2024 PRTD 2137 4CREEKS, INC. 23511-30856 01/17/2024 3104 7,683.25 23488-30854 01/17/2024 3104 9,540.85
23417-30855 01/17/2024 3104 4,512.73
23465-30821 01/17/2024 3104 875.00
23496-30819 01/17/2024 3104 612.50
23541-30817 01/17/2024 3104 3,150.00
23451-30818 01/17/2024 3104 3,882.50
23391-308200 01/17/2024 3104 2,660.00
CHECK TOTAL: 32,916.83
01/22/2024 PRTD 2167 ADVANCED BUILDING MA INV19749 01/05/2024 3104 1,149.75 CHECK I TOTAL: 1,149.75
01/22/2024 PRTD 2215 SANCHEZ, MATTHEW 122923 12/29/2023 3104 4,249.32 CHECK I TOTAL: 4,249.32
01/22/2024 PRTD 2220 JESSE'S AUTO GARAGE 3015 01/08/2024 3104 240.00

Page 3 ends

5175mame
Program ID: pcshds|
CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

CHECE ON DARE TYPE VENDOR NAME CASH COVE TO/OVE ERNER INVOICE INV DATE PO WARRANT NET CHECK TOTAL: 240.00
01/22/2024 PRTD 2226 INFORMOR, INC 5537JAN24 01/01/2023 3104 260.00 CHECK TOTAL: 260.00
01/22/2024 PRTD 2228 CENTRAL CAL WATERWOR 22879 11/08/2023 3104 3,613.91 22723 09/20/2023 3104 543.00
22713 08/31/2023 3104 6,607.13
22852 11/01/2023 3104 26,479.00
01/01/2024 3104 26,479.00
12/15/2023 3104 987.34
01/01/2024 3104 26,479.00
11/02/2023 3104 407.24
22930 01/01/2024 3104 13,961.10
CHECK • TOTAL: 105,556.72
01/22/2024 PRTD 2267 TOWNSEND PUBLIC AFFA 20944 01/01/2024 3104 5,000.00 CHECK I TOTAL: 5,000.00
D 01/22/2024 PRTD 2295 MOORE, SKYLER 0 010424 01/04/2024 3104 725.00 CHECK • TOTAL: 725.00
01/22/2024 PRTD 2295 MOORE, SKYLER Q 122923 12/29/2023 3104 4,249.32 CHECK • TOTAL: 4,249.32
01/22/2024 PRTD 2296 HOPF, LATHAN A 010424 01/04/2024 3104 250.00 CHECK • TOTAL: 250.00
/ 01/22/2024 PRTD 2311 FLAMING, EMILEE A 010424 01/04/2024 3104 450.00 Report generated: 01/22/2024 16:48 Page 4
User: 6175mame
Program ID: apcshdsb
CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

VOUCHER INVOICE INV DATE PO WARRANT NET
CHECK TOTAL: 450.00
| 01/22/2024 PRTD 2319 WEBB, TRAVIN 010424 01/04/2024 3104 625.00 CHECK TOTAL: 625.00
01/22/2024 PRTD 2385 COMMERCE TRUCK & EQU 011624D 01/16/2024 3104 180,736.31 CHECK TOTAL: 180,736.31
| 01/22/2024 PRTD 2406 MOORE TWINING ASSOCI 3379004 11/27/2023 3104 258.50 4135004 01/09/2024 3104 1,250.00
4134983 01/08/2024 3104 206.00
3380324 12/29/2023 3104 206.00
3380019 12/21/2023 3104 206.00
3379970 12/20/2023 3104 65.00
CHECK I TOTAL: 2,191.50
M 01/22/2024 PRTD 2415 NICKELS, STUART 010424 01/04/2024 3104 4,525.00 CHECK • TOTAL: 4,525.00
01/22/2024 PRTD 2429 BENEDETTA, MICHAEL R 010424 01/04/2024 3104 625.00 CHECK •I TOTAL: 625.00
01/22/2024 PRTD 2438 AVISON CONSTRUCTION, 9-FREE 01/11/2024 3104 5,453.00 CHECK I TOTAL: 5,453.00
01/22/2024 PRTD 2454 HYDROPRO SOLUTIONS 0002448-IN 01/10/2024 3104 6,999.07 CHECK • TOTAL: 6,999.07
01/22/2024 PRTD 2467 HOLLOWAY ENVIRONMENT INV-HES-2492 09/30/2023 3104 1,516.75 pore enerated: 04202 16-48 Page 5
CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

VOUCHER INVOICE INV DATE PO WARRANT NET
CHECK TOTAL: 1,516.75
01/22/2024 PRTD 2489 BOTELLO, DIEGO 010424 01/04/2024 3104 500.00 CHECK TOTAL: 500.00
01/22/2024 PRTD 2493 SANDOVAL, MARIA 010424 01/04/2024 3104 750.00 CHECK TOTAL: 750.00
2505 CALPORTLAND COMPANY 96154371 11/29/2023 3104 1,457.27 CHECK TOTAL: 1,457.27
01/22/2024 PRTD 2507 HOPEWELL MANUFACTURI 23085 01/30/2023 3104 2,906.00 CHECK TOTAL: 2,906.00
01/22/2024 PRTD 2511 CLARK EQUIPMENT CO. 27-0CT-23 10/27/2023 3104 117,189.63 CHECK TOTAL: 117,189.63
| 01/22/2024 PRTD 2512 VELYINES, TEQUIA 011724 01/17/2024 3104 486.87 CHECK TOTAL: 486.87
01/22/2024 PRTD 2513 BR WELDING AND FABRI INV1311 12/09/2023 3104 6,450.00 CHECK I TOTAL: 6,450.00
01/22/2024 PRTD 3602 BILL WALL'S DIRECT A 16836 01/12/2024 3104 360.00 16834 01/12/2024 3104 810.00
CHECK I TOTAL: 1,170.00
01/22/2024 PRTD 4399 BLAIS & ASSOCIATES BA-6806-2023 01/15/2024 3104 907.50 BA-6889-2023 01/15/2024 3104 3,052.50
BA-6805-2023 01/15/2024 3104 95.00
BA-6807-2023 01/15/2024 3104 220.54
userrt generated: 61/3mam024 16:48 Page 6
Program ID: apcshdsb
munis

CITY OF FARMERSVILLE
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

TYPE VENDOR MAME CASH COVE TO/OWE TECHER INVOICE INV DATE PO WARRANT NET BA-2808-2023 01/15/2024 3104 1,437.50
BA-6803-2023 01/15/2024 3104 2,600.00
BA-2804-2023 01/15/2024 3104 2,296.00
CHECK TOTAL: 10,609.04
01/22/2024 PRTD 4865 BOYER, PAUL 122723 12/27/2023 3104 502.04 CHECK TOTAL: 502.04
01/22/2024 PRTD 4867 BOYS & GIRLS CLUB OF 101873 12/31/2023 3104 10,560.76 CHECK TOTAL: 10,560.76
01/22/2024 PRTD 5300 B S & E COMPANY, INC 347496 10/31/2023 3104 57.07 CHECK • TOTAL: 57.07
01/22/2024 PRTD 8300 CITY OF FARMERSVILLE 123123 12/31/2023 3104 3,682.62 CHECK I TOTAL: 3,682.62
01/22/2024 PRTD 8399 CITY OF VISALIA AR100126 12/01/2023 3104 6,155.42 AR100315 01/01/2024 3104 6,155.42
CHECK • TOTAL: 12,310.84
• 01/22/2024 PRTD 11000 FARIAS, RUBEN 010424 01/04/2024 3104 400.00 CHECK I TOTAL: 400.00
N 01/22/2024 PRTD 14651 FGL ENVIRONMENTAL 347573A 11/27/2023 3104 99.00 348696A 01/04/2024 3104 99.00
CHECK • TOTAL: 198.00
I 01/22/2024 PRTD 24200 LEAGUE OF CALIFORNIA INV - 12085-L5P2M9 01/18/2023 3104 6,742.00 Prora enerated: 03c22024 16:48 Page 7
617 Smame
apcshdsb
CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

CHECHNA CHK DATE TYPE VENDOR NAME CASH COUE TO/DUE FUCH) VOUCHER INVOICE INV DATE PO WARRANT NET CHECK TOTAL: 6,742.00
01/22/2024 PRTD 31560 OFFICE DEPOT 29225639 12/31/2023 3104 94.11 CHECK TOTAL: 94.11
01/22/2024 PRTD 34500 AT & T 010724 01/07/2024 3104 318.64 CHECK TOTAL: 318.64
01/22/2024 PRTD 34634 PITNEY BOWES-PURCHAS 121723 12/17/2023 3104 926.14 CHECK TOTAL: 926.14
01/22/2024 PRTD 36695 PRICE PAIGE & COMPAN 32201 11/30/2023 3104 19,922.00 CHECK I TOTAL: 19,922.00
01/22/2024 PRTD 37000 QUAD KNOPF, INC. 121788 01/04/2024 3104 2,211.30 121751 01/04/2024 3104 1,823.00
121749 01/04/2024 3104 15,272.46
121727 01/04/2024 3104 1,929.52
121726 01/04/2024 3104 4,634.62
121732 01/04/2024 3104 11,848.29
121786 01/08/2024 3104 3,511.32
CHECK TOTAL: 41,230.51
01/22/2024 PRTD 41000 SELF-HELP ENTERPRISE FVL21HJUL-OCT23 12/06/2023 3104 8,874.17 FVLADM DEC-23 01/12/2024 3104 2,142.00
CHECK TOTAL: 11,016.17
01/22/2024 PRTD 43760 SUN-GAZETTE 712733 01/09/2024 3104 220.00 CHECK I TOTAL: 220.00
rora enerated: 022a2024 5:48 Page 8
User:

Program ID:

CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

VOUCHER INVOICE INV DATE PO WARRANT NET
01/22/2024 PRTD 51550 VERIZON WIRELESS 9952042621 12/19/2023 3104 896.29 CHECK I TOTAL: 896.29
| 01/22/2024 PRTD 51550 VERIZON WIRELESS 9953393380 01/04/2024 3104 190.05 CHECK TOTAL: 190.05
NUMBER OF CHECKS 67 *** CASH ACCOUNT TOTAL *** 672,389.87

COUNT AMOUNT
TOTAL PRINTED CHECKS 67 672,389.87
*** GRAND TOTAL *** 672,389.87
Report generated: 01/22/2024 16:48 Page
User: 6175mame
Program ID: apcshdsb
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3104 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE

APPROVED UNPAID INVOICES TO BE POSTED
127 00000 QUALITY MUFFLER 139332 3104 1,026.73 -00 .00
CAST 1100 2024/07 Due 00/2/2024 DESC: PROFESSIONAL SERVICE DISC: .00 02425 5205 342:24 1099 CONDITIONS THAT PREVENT POSTING INVOICE 127/47173
* w9hld
04425 5205 342.25 1099:
626 00000 STRADLING YOCCA 47195 3104 367.50 .00 .00
403466
2024/07 ONE 01/22/2024 SESCPROFESSTONAL SERVİC 04425 5205 367.50 1099:
ст 110 DEPT DUE 01/22/202
CONDITIONS THAT PREVENT POSTING INVOICE 626/47195
* w9hld
633 00000 CHARTER COMMUNIC 470047601122123 3104 3,305.64 .00 .00 ASH 1100 2021/07 DISC: .0 07404 5211 321:52 1099
ONE 12/22/2024 DESCROFESSIONAL SERVIC
CONDITIONS THAT PREVENT POSTING INVOICE 633/47271
01411 5211 921:65 1099
14411 5211 SLESF

30.46 1099
1099:
149.24 1099
159: 33 1099
02425 5211 1099
04404 5211 143.15 1099
04415 5211 24.37 1099
04425 521 149.24 1099
06404 521 30.46 1099
06415 5211 12.18 1099
06425 5211 9.14 1099
1099:
332 E 22%15 1099
1099
serrt generated: 01132a2024 16:3 Page 1
rogram Id apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3104 NEW INVOICES

DOCUMENT

VENDOR REMIT NAMEN INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 39425 5211 442.61 1099:
769 00000 AMERICAN INCORPO 4269205 3104 1,466.00 .00 .00 CASH 01 2024/07 INV 12/22/2023 DESC: PROFESSIONAL SERVIC DISC: •0 01425 5205 1,466.00 1099:

ACCT 1100 DEPT DUE 01/22/2024
990 00000 TERMINIX 47242 3104 122.00 -00 -00
441341629
CAST 1100 2024/07 DUE 02/23/2024 DESC:PEST CONTROL'SC: .00 01406 5205 122.00 1099:
990 00000 TERMINIX 471331257 3104 78.00 .00 -00
ASH 0 2024/07 ONE 02/23/2023 DESC: PEST" CONTROl DISC: .00 01406 5205 78.00 1099:

Ст 1100 DEPT
1207 00000 PROFESSIONAL PRI 47247 3104 2,364.06 .00 .00 119314
CASH 01 2024/07 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE DISC: .0C 024255205 ACCT 1100 DUE 01/22/2024 04425 5205 788:02 20990
06425 5205
1234 00000 AUTOZONE 47228 3104 29.06 .00 .00
3711558270
CASH 01 2024/07 ONE 01/22/2023 DESC: PROFESSIONAL SERVICE DISC: .01 425 52| 10-00 1099 ACCT 1100 DEPT DUE 01/22/2024 425 520
CONDITIONS THAT PREVENT POSTING INVOICE 1234/47228
w9h1d
04425 5203 9.06 1099:
1242 00001 CALIFORNIA BUSIN 47204 3104 253.65 -00 -00
338967
ACT 1100 2021/07 DUE 02/2/2024 DES-PROFESSTONAL SERVICE 02406 5205 126.82 10993 1245 00000 HUNTLEY, STEVE 47196 3104 140.75 .00 -00
011724
ASH 0 2024/07 DISC: 00 01404 5208 140.75 1099:
сст 110 DEP
CONDITIONS THAT PREVENT POSTING INVOICE 1245/47196
Report generated: 01/22/2024 16:39 Page 2
User: 6175mame
Program ID:

CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3104 NEW INVOICES

DOCUMENT

VENDOR REMIT NAMEN INVOICE PO VOUCHER WARRANTIN NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 1245 00000 HUNTLEY, STEVE 17724 3104 161.25 .00 - 00
CASH 01 2024/07 INV 01/17/2024 DES CAR ANNUAL RETREAT DISC: .00 01404 5208 161.25 1099:

ACCT 1100 DEPT DUE 01/22/2024
CONDITIONS THAT PREVENT POSTING INVOICE 1245/47197
1245 00000 HUNTLEY, STEVE 47198 3104 264.50 .00 -00
01172024
ACET 1100 2024/07 ONE 01/22/2024 DESCEMO ANNUAL SONFERENCI DISC: .0 01404 5208 264.50 1099:

DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 1245/47198
* w9hld
1361 00000 TULARE KINGS HIS 47232 3104 175.00 .00 .00
18997-33439
CASH 01 2024/07 ONE 01/22/2024 DESC: PROFESSIONAL SERVIC DISC: .01 01405 5205 175.00 1099:

ACCT 1100
CONDITIONS THAT PREVENT POSTING INVOICE 1361/47232
* w9hld
1378 00000 MID VALLEY DISPO 47267 3104 42,881.57 .00 •00 M-2024-6
ASH 01 2024/07 INV 01/22/2024 DISC: 00 06425 5205 62;620.02 1099 сст 110( DEPT DUE 01/22/2024 DES DEC 2023 606425 4004
CONDITIONS THAT PREVENT POSTING INVOICE 1378/47267
* w9hld
606425 4092
606425 4093 :48.32 10380
606425 4094
1456 00000 FRANCHISE TAX BO 47239 3104 648.03 .00 .00
122023
CASH 01 2024/07 01 2230 648.03 1099:

ACCT 1100 DEPT
usert generated: 61/3man02 16:39 Page
6175mame
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3104 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE CONDITIONS THAT PREVENT POSTING INVOICE 1456/47239
* w9hld
1481 00000 HINDERLITER DELL 47249 3104 132.00 .00 - 00
SIN034417
CASH 01 2024/07 ONE 0132/2023 DESCROFESSIONAL SERVICE 01404 5205 132.00 1099:

ACCT 1100 DUE 01/22/2024
CONDITIONS THAT PREVENT POSTING INVOICE 1481/47249
W9lld
1555 00000 METLIFE 47240 3104 6,750.73 .00 -00
121423
AST 1100 2024/07 DU 02/2/2024 DES:01/0/2402931/24 00 L 23 DEPT 2,405:97 1093
CONDITIONS THAT PREVENT POSTING INVOICE 1555/47240
* w9hld
1633 00000 PITNEY BOWES 1024509606 3104 157.48 .00 .00
CASH 01 2024/07 01406 5205 157.48 1099:

ACCT 1100 DEPT SES-: PROFESSIONAL SERVICE
CONDITIONS THAT PREVENT POSTING INVOICE 1633/47245
* w9hld
1657 00000 LASQUITE, ANTHON 470424 3104 250.00 .00 •00
CASH 01 2024/07 D222 DESPROFESSTONAL SERVICE 01420 5205 250.00 1099:

ACCT 1100 DUE 01/22/2024
CONDITIONS THAT PREVENT POSTING INVOICE 1657/47180
1658 00000 DIAZ, VINCENT A. 47177 3104 500.00 -00 .00
010524
ASH 1100 2024/07 NV 01/04/2024 SES PROFESSTONAL SERVICE 01420 5205 500.00 1099:

DEPT UE 01/22/202
Prora enerated: 1202 16:39 6175mame Page 4
apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3104 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE CONDITIONS THAT PREVENT POSTING INVOICE 1658/47177
* w9hld
1761 00000 AUTOTECH SERVICE 1735507 3104 41.75 •00 -00
CASH 01 2024/07 INV 11/22/2022 DESC: PROFESSIONAL SERVICE DISC: 00 01420 5205 41.75 1099:

ACCT 1100 DEPT DUE 01/22/2024
CONDITIONS THAT PREVENT POSTING INVOICE 1761/47217
* wohld
1761 00000 AUTOTECH SERVICE 47218 3104 41.75 .00 .00
1115497
CASH 01 2024/07 ISC: .0 01406 5205 41.75 1099:

ACCT 1100 DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 1761/47218
1761 00000 AUTOTECH SERVICE 47219 3104 51.75 -00 .00
1115487
2024/07 TUE 02/22/2024 DES PROFESSIONAL SERVICE DISC: .00 1425 520 DEPT 2425 520 17:35 1093
CONDITIONS THAT PREVENT POSTING INVOICE 1761/47219
04425 5205 17.25 1099:
1761 00000 AUTOTECH SERVICE 47220 3104 41.75 .00 -00
1115493
CASH 01 2024/07 INV 11/21/2022 SEP-CHK: N DISC: .00 02425 5205 10.44 1099 ACCT 1100 DUE 01/22/2024 DESC: PROFESSIONAL SERVICE 02425 10.44 L090 CONDITIONS THAT PREVENT POSTING INVOICE 1761/47220
* w9hld
04425 5205 10.43 1099
21425 5205
sert generated: 01/3na202 16:39 Page 5
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3104 NEW INVOICES

DOCUMENT

VENDOR REMIT NAMER INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 1761 00000 AUTOTECH SERVICE 1715489 3104 41.75 -00 •00
CAST 1100 302407 BUY /2/2032 BECOFESSOM SEAV:00 02423 5205 10:43 1039 CONDITIONS THAT PREVENT POSTING INVOICE 1761/47221
* wond
04425 520 10:14 1039
21425 5205
1761 00000 AUTOTECH SERVICE 4723312 3104 41.75 .00 -00
ASH 01 2024/07 INV 11/22/2022
CCT 1100 DEPT, IN 0122202 SEROESSIONAO SERVICE 02435 5305 10:13 1099 CONDITIONS THAT PREVENT POSTING INVOICE 1761/47222
* w9hld
04425 5205 10.44 1099
21425 5205
1854 00000 PROACTIVE ENVIRO 42582 3104 169.95 .00 -00
CAST 1100 2024/07 IN 09/22/2024 DESC:PROFESSIONAL SERVICE DISC: .00 04425 5205 169.95 1099:

CONDITIONS THAT PREVENT POSTING INVOICE 1854/47189

Page 6 ends

Prora enerated: on 2024 26:39
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3104 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 2100 00001 AT&T MOBILITY 1222324 3104 2,380.85 .00 -00
ACCT 1100 2021/07 DUE 01/22/2024 DESCPROFESSTONAL SERVICE 1404 523 126.99 1093 1411 521
14411 5211 SLESF 14.04 1099
01415 5211 19.05 1099
01420 5211 314.79 109.
01425 5211 132.88 L09!
02404 5211 88.40
02415 5211 39.62 1099
02425 5211 133.70
04404 5211 83.73
04415 5211 39.62
04425 5211 129.20
06404 5211 1099
06415 5211 13 1098
06425 5211
21404 5211 8.83 1099:
21425 5211 112.67 1099
35425 5211 7.26 1099
2137 00000 4CREEKS, INC. 47259 3104 7,683.25 .00 -00
23511-30856
2024/07 01414 5205 7,683.25 1099:

DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 2137/47259
2137 00000 4CREEKS, INC. 47260 3104 9,540.85 -00 .00
3488-30854
CASH 01 2024/07 DUE 02/2/2024 SES: PROFESSIONAL SERVICE DISC: .00 01414 5205 9,540.85 1099:

ACCT 1100 DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 2137/47260
* w9hld
2137 00000 4CREEKS, INC. 47261 3104 4,512.73 .00 -00
23417-30855
CASH 01 2024/07 DISC: .00 12400 5516 CCLGP 4,512.73 1099:

ACCT 1100 DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 2137/47261
Report generated: 01/22/2024 16:39 Page 7
User: 6175mame
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3104 NEW INVOICES

DOCUMENT
VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY • PO BALANCE CHK/WIRE * W9hld
2137 00000 4CREEKS, INC. 43265-30821 3104 875.00 .00 .00 CASH 01 2024/07 DISC: 00 72420 5516 STATN 875.00 1099:

ACCT 1100 DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 2137/47262
* W9hld
2137 00000 4CREEKS, INC. 47263 3104 612.50 - 00 .00
23496-30819
ASH O 2024/07 DESC PROFESSTONAL SERVICE SEP-CHK: N 01414 5205 612.50 1099:
сст 110( DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 2137/47263
w9h1d
2137 00000 4CREEKS, INC. 47264 3104 3,150.00 .00 .00
23541-30817
CAST 1100 2021/07 DU 012024 SECRETA. SERVICE 02425 5516 BIRCH 3,150.00 1099:

CONDITIONS THAT PREVENT POSTING INVOICE 2137/47264
* w9h1d
2137 00000 4CREEKS, INC. 43491-30818 3104 3,882.50 .00 .00 ACT 1100 2024/07 NE 12202 DESPOSTONAL SERVIC ISC: . ( 01414 5205 3,882.50 1099:

DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 2137/47265
* w9h1d
2137 00000 4CREEKS, INC. 47266 3104 2,660.00 .00 •00
23391-308200
CASH 01 2024/07 DUE 02/22/2024 DESC PROFESSIONAL SERVIC DISC: .0 01414 5205 1,302.50 1090 ACCT 1100 DEPT 01414 5205
CONDITIONS THAT PREVENT POSTING INVOICE 2137/47266
* w9hld
usert generated: 01/3man024 16:39 Page 8
6175mame
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3104 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 01414 5205 87.50 1099:
2167 00000 ADVANCED BUILDIN 4N219749 3104 1,149.75 -00 .00 CASH 01 2024/07 INV 01/05/202 DISC: .00 01406 5205 1,149.75 1099:

ACCT 1100 DEPT DUE 01/22/202
CONDITIONS THAT PREVENT POSTING INVOICE 2167/47214
* w9hld
2215 00000 SANCHEZ, MATTHEW 472323 3104 4,249.32 -00 •00 ASH 0 2024/07 INV 12/29/2023 SEP-CHK: Y 72420 5205 4,249.32 1099:
сст 110( DEPT DUE 01/22/2024
CONDITIONS THAT PREVENT POSTING INVOICE 2215/47170
2220 00000 JESSE'S AUTO GAR 37130 3104 240.00 .00 .00
ASH O 2024/07 INV 01/08/2024 01425 5205 60.00
сст 110 DEPT DUE 01/22/2024 SES ESSIONAD SERVICE 02425 5205 60.00 1099 CONDITIONS THAT PREVENT POSTING INVOICE 2220/47230
* w9hld
4425 520 60.00 1099
21425 520 60.00
2226 00000 INFOARMOR, INC 47223 3104 260.00 .00 .00
5537JAN24
ASH 0, 2024/07 INV 01/01/2023 SEP-CHK:N DESC PROFESSIONAL SERVICE 01404 5205 260.00 1099:
сст 110( DEPT DUE 01/22/2024
CONDITIONS THAT PREVENT POSTING INVOICE 2226/47223
* w9hld
2228 00000 CENTRAL CAL WATE 47190 3104 3,613.91 .00 .00 22879
ASH 01 2024/07 IN 01222024 DESPOONAL SERVICE DISC: 00 04425 5205 3,613.91 1099:

CCT 1100 DEPT
usert generated: 61/3mam024 16:39 Page 9
6175mame
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3104 NEW INVOICES

DOCUMENT

VENDOR REMIT NAMER INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 2228 00000 CENTRAL CAL WATE 12123 3104 543.00 .00 .00
2021/07 1Ne 01/20/2023 SES: PROFESSIONAL SERVICE DISC: 04425 5205 543.00 1099:
2228 00000 CENTRAL CAL WATE 42713 3104 6,607.13 .00 .00 ACCT 1100 2024/07 DUE 01/3/2023 DESCEPROFESSIONAL SERVICE DISC: .00 04425 5205 6,607.13 1099:

DEPT
2228 00000 CENTRAL CAL WATE 22832 3104 26,479.00 -00 .00 ACT 1100 2EP1/07 INV 11/01/2023 SES PROFESSIONAL SERVICI DISC : .0 04425 5205 23:839:50 1039:

DUE 01/22/2024 02425 5205
2228 00000 CENTRAL CAL WATE 42900 3104 26,479.00 .00 .00 AST 1100 2024/07 INV 01/01/2024 DES PROFESSTONAL SERVICE DISC: .00 04425 5205 3,639.5 1099 DEPT DUE 01/22/2024 02425 5205 2,839.5
2228 00000 CENTRAL CAL WATE 12929 3104 987.34 .00 .00
CASH 01 2024/07 04425 5205 987.34 1099:

ACT 1100 DEPT ONE 022024 SEC: ESTONAL SERVICE
2228 00000 CENTRAL CAL WATE 42337 3104 26,479.00 .00 .00 ACT 1100 20P1/07 DUE 022202 DES ROFESSIONAL SERVICE 02425 5205 23:639:50 1039:
2228 00000 CENTRAL CAL WATE 12376 3104 407.24 • 00 -00
2024/07 DUE 02/2/2024 DESC:PROFESSIONAL SERVICE 04425 5205 407.24 1099:

DEPT
2228 00000 CENTRAL CAL WATE 42330 3104 13,961.10 .00 .00 CAST 1 2024/07 DUE 012/2024 DESC PROFESSTONAL SERVICE DISC: .00 04425 5205 13,961.10 1099:

DEPT DUE 01/22/2024
sert generated: 01/3mam024 16:3 Page 10
175mam
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3104 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 2267 00000 TOWNSEND PUBLIC 10215 3104 5,000.00 •00 - 00 ASH 0 2024/07 ENV 01/01/2024 01404 5205 5,000.00 1099:

CCT 1100 UE 01/22/2024
2295 00000 MOORE, SKYLER Q 47169 3104 4,249.32 -00 - 00 122923
CAST 1100 D021/0 D0222/2024 DESCRABBIT FIRDSC: •00 72420 5205 4,249.32 1099:

CONDITIONS THAT PREVENT POSTING INVOICE 2295/47169
* w9hld
2295 00000 MOORE, SKYLER Q 47181 3104 725.00 .00 .00
010424
ASH 0. 2024/07 NV 01/04/2024 DES: PROFESSIONAL SERVICE DISC: .0 01420 5205 725.00 1099:

CCT 1101 DEPT VE 01/22/202
CONDITIONS THAT PREVENT POSTING INVOICE 2295/47181
* w9hld
2296 00000 HOPF, LATHAN A 4717g 3104 250.00 -00 - 00
010424
CASH 01 2024/07 01420 5205 250.00 1099:

ACCT 1100 DEPT IN 02/2024 DESCHROFESSTONAD SERVICE
CONDITIONS THAT PREVENT POSTING INVOICE 2296/47179
* w9hld
2311 00000 FLAMING, EMILEE 47178 3104 450.00 .00 .00
010424
ISH 2024/07 INV 01/04/202 SES PROFESSIONAL SERVICE DISC: 00 01420 5205 450.00 1099:
ст 11( DEPT UE 01/22/202
CONDITIONS THAT PREVENT POSTING INVOICE 2311/47178
* w9hld
report generated: 01/22/2024 16:39 11
User: 175mame Page
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3104 NEW INVOICES

DOCUMENT

VENDOR REME NAMER INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 2319 00000 WEBB, TRAVIN 020824 3104 625.00 - 00 .00
ACET 1100 2024/07 DUE 02/21/2024 DES:#OFESSONA SEE iCE 01420 5205 625.00 1099:

CONDITIONS THAT PREVENT POSTING INVOICE 2319/47184
* w9h1d
2385 00000 COMMERCE TRUCK & 4716240 3104 180, 736.31 .00 .00 ASH 01 2024/07 INV 01/16/2024 DES BUCKET TRUE: 0 60425 5504 180,736.31 1099:
сст 1100 DEPT DUE 01/22/2024
CONDITIONS THAT PREVENT POSTING INVOICE 2385/47186
2406 00000 MOORE TWINING AS 47194 3104 258.50 .00 -00
3379004
AST 1100 2024/07 INV 11/27/2023 DES: PROFESSIONAL SERVICE DISC: .00 04425 5205 258.50 1099:

DEPT DUE 01/22/2024
2406 00000 MOORE TWINING AS 4733004 3104 1,250.00 .00 -00 ASH 0 2024/07 INV 01/09/2024 DES PROFESSIONAL SERVICE DISC: .01 04425 5205 1,250.00 1099:
сст 110 DEPT DUE 01/22/2024
2406 00000 MOORE TWINING AS 47207 3104 206.00 .00 .00
134983
CAST 1100 2024/07 SES: PROFESSIONAL SERVICE 04425 5205 206.00 1099:

DEPT
2406 00000 MOORE TWINING AS 47234 3104 206.00 .00 .00
3380324
ACT 1100 2024/07 DUE 22/202 DESCPROFESSTOMAL SERVICE 04425 5205 206.00 1099:

DEPT
2406 00000 MOORE TWINING AS 47235 3104 206.00 .00 -00
3380019
ACT 1100 2024/07 INV 12/21/2023 DESCE PROFESSIONAL SERVIC ISC: .0 04425 5205 206.00 1099:

DEPT DUE 01/22/2024
Report generated: 01/22/2024 16:39 Page 12
Program ID:

CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3104 NEW INVOICES

DOCUMENT

VENDOR REMIT NAMER INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 2406 00000 MOORE TWINING AS 47236 3104 65.00 -00 - 00
3379970
ACT 1100 2021/07 ISC: .l 04425 5205 65.00 1099:
2415 00000 NICKELS, STUART 420124 3104 4,525.00 .00 .00 CASH 01 2024/07 DUE 0122/2024 DESCPROFESSIONAL SERVICE DISC: 00 01420 5205 4,525.00 1099:

ACCT 1100 DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 2415/47182
* w9hld
2429 000000 BENEDETTA, MICHA 470424 3104 625.00 .00 .00 CAST 1100 2024/07 INV 01/04/2024 SES PROFESSIONAL SERVICE 01420 5205 625.00 1099:

DEPT DUE 01/22/2024
2438 00000 AVISON CONSTRUCT 47216 3104 5,453.00 .00 .00 9-FREE
CAST 1100 2024/07 ONE 01222024 DESCREE*PROFESSTOCAL ISC: .0 1425 5516 FRE ,740.0 1099 DEPT SERVICE 1 2245 FRE -287.0
CONDITIONS THAT PREVENT POSTING INVOICE 2438/47216
* w9hld
2454 000000 HYDROPRO SOLUTIO 4702448-IN 3104 6,999.07 .00 -00 CASH 01 2024/07 ONE 01/22/2024 DESC: PROFESSTONAL SERVIC DISC: .0 02425 5203 6,999.07 1099:

ACCT 1100 DEPT
2467 00000 HOLLOWAY ENVIRON 472-HES-2492 3104 1,516.75 •00 .00 CAST 1100 2024/07 DUE 0222024 DESCEPROFESTONAL SERVICE 04425 5205 1,516.75 1099:

DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 2467/47205
Report generated: 01/22/2024 16:39 Page 13
Program 10:
apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3104 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE VOUCHER WARRANT NET AMOUNTIN EXCEEDS PO BY PO BALANCE CHK/WIRE 2489 00000 BOTELLO, DIEGO 471754 3104 500.00 .00 -00
CAST 1100 2024/07 IN 0122024 DESCROFESSIONAL SERVICE 01420 5205 500-00 1099:

DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 2489/47176
* w9hld
2493 00000 SANDOVAL, MARIA 420424 3104 750.00 -00 -00
ASH O1 2024/07 SO 122024 DESROFESSIONAL SERVICE DISC: .01 01420 5205 750.00 1099:
сст 1100 DEPT DUE 01/22/2024
CONDITIONS THAT PREVENT POSTING INVOICE 2493/47183
* w9hld
2505 00000 CALPORTLAND COMP 47229 3104 1,457.27 .00 -00 96154371
ASH 0 2024/07 INV 11/29/2023 31425 5516 ROYPK 1,457.27 1099:
сст 110 DUE 01/22/2024 SES CRYP -PROFESSIONAL SERVICE
2507 000000 HOPEWELL MANUFAC 47085 3104 2,906.00 .00 -00 ASH 01 2024/07 INV 01/30/2023 SEP-CHK: N DESC FREE PROFESSTONAL SERVICE 31425 5516 FREE 2,906.00 1099:

ACCT 1100 DEPT DUE 01/22/2024
CONDITIONS THAT PREVENT POSTING INVOICE 2507/47238
W9h1d
2511 00000 CLARK EQUIPMENT 47188 3104 117,189.63 - 00 .00 27-0CТ-23
CAST 1100 2024/07 VY 01/22/2024 DESC:PROFESSIONAL SERVIC ISC: . 02425 5504 DEPT 04425 5504
103425 5504
2512 00000 VELVINES, TEQUIA 471724 3104 486.87 -00 .00
ASH 01 2024/07 DUE 02/22/2024 SES--LN ANNUAL PUBLIC SECTOR CONFERENC DISC: .0 01404 5208 486.87 1099:
сст 110(
CONDITIONS THAT PREVENT POSTING INVOICE 2512/47199
usert generated: 01/3na2024 16:39 Page 14
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3104 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE • Willd
2513 00000 BR WELDING AND F 47231 3104 6,450.00 -00 -00 INV1311
ASH 01 2024/07 :NV 12/09/2023 DES PROFESSIONAL SERVICE DISC: 00 01420 5504 6,450.00 1099:
сст 1100 DEPT UE 01/22/2024
3602 00000 BILL WALL'S DIRE 15836 3104 360.00 .00 .00
ISH 2024/07 01406 5205 360.00 1099:0
ст 11( DEPT
3602 000000 BILL WALL'S DIRE 12334 3104 810.00 .00 -00
AST 1100 2024/07 DISC: 00 01406 5205 810.00 1099:0
DEPT
4399 00001 BLAIS & ASSOCIAT 47252 3104 907.50 -00 .00
BA-6806-2023
CASH 01 2024/07 INV 01/15/2024 SEP-CHK: N 12400 5516 ALLEY 907.50 1099:

ACCT 1100 DEPT SNY 01/22/2024 DESCALLEY-PROFESSIONAL SERVICE 4399 00001 BLAIS & ASSOCIAT 47253 3104 3,052.50 .00 .00 BA-6889-2023
ASH O 2024/07 IN 01/15/2024 SEPH: N ONE 0112024 DEFER ESTONAL SERVICE 31425 5516 FREE 3,052.50 1099:
*CT 1100 DEPT
4399 00001 BLATS & ASSOCIAT 47-6805-2023 3104 95.00 -00 •00 ASH O 2024/07 DUE 012/2024 DESC:S20T-PROFESSTONAI SERVICE 12400 5205 SB2DT 95.00 1099:

CCT 1100 DEPT
4399 00001 BLAIS & ASSOCIAT 47255 3104 220.54 .00 .00
BA-6807-2023
CAST 1100 2024/07 DUE 01/22/2024 DESCAP PROFESSONAL SERVICE 12400 5205 LEAP 220.54 1099:
4399 00001 BLAIS & ASSOCIAT 47256 3104 1,437.50 .00 .00 BA-2808-2023
ACCT 1100 2024/07 12400 5516 CCLGP 1,437.50 1099:
sert generated: 01/3ma202a 16:39 Page 15
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3104 NEW INVOICES

DOCUMENT

VENDOR REMIT NAMER INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 4399 00001 BLAIS & ASSOCIAT 47257 3104 2,600.00 -00 -00 BA-6803-2023
CAST 1100 2021/07 TA 2202 DE SIONAL SERVICEN DISC: .00 01414 5205 2,600.00 1099:
4399 00001 BLAIS & ASSOCIAT 47258 3104 2,296.00 - 00 .00 BA-2804-2023
ACCT 1100 2024/07 01414 5205 2,296.00 1099:

DEPT
4865 00000 BOYER, PAUL 47273 3104 502.04 .00 -00
122723
2024/07 NV 12/27/2023 SED HAN 24-26 DISC: .00 01401 5208 502.04 1099:

CAST 1100 DEPT UE 01/22/202
4867 00000 BOYS & GIRLS CLU 101873 3104 10,560.76 .00 .00 ACET 1100 2021/07 INV 12/31/2023 SESC: PROFESSIONAL SERVICE DISC: .00 01414 5205 10,560.76 1099:

DUE 01/22/2024
5300 00000 B S & E COMPANY, 377496 3104 57.07 -00 .00
AST 1100 2024/07 ONE 09/32/2024 DES:PROFESSIONAL SERVICE INV 10/31/2023 01425 5203 20.00 1099:

DEPT 02425 5203 20.00 1099
21425 5203 17.07 1099
8300 00000 CITY OF FARMERSV 47268 3104 3,682.62 .00 -00 123123
ACET 1100 DEP /07 VE 02/32/2023 DESC: PROFESSIONAL SERVIC ISC: .( 1420 520 33.93 1099 1425 520 ., 169.1 1099
236.26 1099
1,044.98 1099
905.21 1099:

82.89 1099
160.25 1099
8399 00001 CITY OF VISALIA 47171 3104 6,155.42 .00 -00
AR100126
CASH 01 2024/07 INV 12/01/2023 DES DEC 2023 ANDMAL SERVIC ISC: .0 01426 5205 6,155.42 1099:

ACCT 1100 DEPT DUE 01/22/2024
Prora generated: 0122024 16:39 Page 16
abinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3104 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 8399 00001 CITY OF VISALIA 47172 3104 6, 155.42 - 00 -00 AR100315
DEP1/07 DUE 0122/2024 DES-:JAN2024 ANIMAL SERVICE 01426 5205 6,155.42 1099:
11000 00000 FARIAS, RUBEN 010454 3104 400.00 -00 •00
ACT 1100 207107 CNV 01/04/2024 SES PROFESSIONAL SERVICE DISC: 01420 5205 400.00 1099:0 DUE 01/22/202
14651 00000 FGL ENVIRONMENTA 47193 3104 99.00 .00 .00
347573A
EACH 1100 2024/07 DUE 02/22/2023 SES PROFESSIONAL SERVICE DISC: .00 02425 5205 99.00 1099:

DEPT
14651 00000 FL ENVIROMMENTA 473696A 3104 99.00 .00 .00
ISH ( 2024/07 INV 01/04/2024 SES: PROFESSIONAL SERVICEPROFESSIONAL SERVICE 02425 5202 99.00 1099:
ст 110 DEPT DUE 01/22/2024
24200 00001 LEAGUE OF CALIFO 47224 3104 6,742.00 .00 .00 INV-12085-L5P2M9
ASH C 2024/07 01405 5205 6,742.00 1099:
сст 110 DEPT
31560 00001 OFFICE DEPOT 29225639 3104 94.11 .00 .00
20P1/07 DUE 02/32/2024 DESC: OFFICE SUPPLIES DISC: .Ol 01406 5201 94.11 1099:
34500 00001 AT & T 010724 3104 318.64 .00 .00
ISH 2024/07 INV 01/07/2024 DES PROFESSIONAL SERVIC ISC: .0 1411 521 120:06 1090 CT 11 DEPT DUE 01/22/2024 1406 521
1420 521 18.45 1099:
1415 521 38.04 1099:
39425 5211 29.25 1099
04425 5211 29.25 1099
Report generated: 01/22/2024 16:39 Page 17
175mame
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3104 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 34634 00001 PITNEY BOWES-PUR 122123 3104 926.14 -00 .00 ACT 1100 20010 ENV 12/17/202 DES PROFESSIONAL SERVICE DISC: 01406 5205 926.14 1099:

UE 01/22/202
36695 00000 PRICE PAIGE & CO 42201 3104 19,922.00 •00 -00 CAST 1100 3024/07 DU 0/30/2024 DES-#KO ESTONAL SERV:00 01406 5205 12;980:00 1099 21425 5205
37000 00001 QUAD KNOPF, INC. 421788 3104 2,211.30 .00 .00 2024/07 NV 01/04/2024 NY 01/22/2024 DESC:PROFESSIONAL SERVIC 01414 5205 2,211.30 1099:

DEPT
37000 00001 QUAD KNOPF, INC. 47164 3104 1,823.00 .00 -00 121751
ASH 01 2024/07 INV 01/04/2024 SEP-CHK: N DISC: 00 60425 5504 PUMP 1,823.00 1099:

ACCT 1100 DEPT DUE 01/22/2024 DESC: PUMP-PROFESSIONAL SERVICE 37000 00001 QUAD KNOPF, INC. 47165 3104 15,272.46 .00 .00 121749
CASH 01 2024/07 12400 5516 CCLGP 15,272.46 1099:

ACCT 1100 DEPT 22024 SEC PROFESSERVICE
37000 00001 QUAD KNOPF, INC. 421727 3104 1,929.52 .00 .00 ACCT 1100 2024/07 TUX 02202 SECTAT-PROFESSAL SERVICE 72420 5516 STATN 1,929.52 1099:
37000 00001 QUAD KNOPF, INC. 47167 3104 4,634.62 .00 .00 121726
LET 1100 2021/07 DEP/07 SUE 01/2/2024 SES-:PipY-PROFE355C.A SERVICE 22425 5516 PMPY1 4,634.62 1099:
37000 00001 QUAD KNOPF, INC. 47168 3104 11,848.29 .00 -00 121732
CASH 01 2024/07 DO 2024 DESCREENPROFESSTONAL SERVICE DISC: .00 31425 5516 FREE 11,848.29 1099:

ACCT 1100 DEPT DUE 01/22/2024
Report generated: 01/22/2024 16:39 Page 18
User: 6175mame
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3104 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 37000 00001 QUAD KNOPF, INC. 121786 3104 3,511.32 .00 .00 CAST 1100 20010 103425 5205 ADAFX 3,511.32 1099:
41000 00000 SELF-HELP ENTERP 47200 3104 8,874.17 .00 -00 FVL 21HJUL-OCT23
ASH O 2024/07 IN 022/2024 SEC:004 PROFESTONAL SERVICE 12400 5205 0004 8,874.17 1099:
сст 110 DEPT
41000 00000 SELF-HELP ENTERP 47251 3104 2,142.00 -00 -00 FVLADM DEC-23
CASH 01 2024/07 ISC: .( 01414 5205 2,142.00 1099:

ACCT 1100 DEPT E 01222024 DESPROFESSIONAL SERVIC
43760 00000 SUN-GAZETTE 472733 3104 220.00 -00 .00
ASH 0 2024/07 INV 01/09/2024 EP-CHK: 1 01414 5205 220.00 1099:
сст 110 DEPT DUE 01/22/2024
51550 00001 VERIZON WIRELESS 47250 3104 896.29 -00 .00
9952042621
CAST 1100 2024/07 INV 12/19/2023 VE 01/12/2024 DESPROFESSIONAL SERVIC SEP-CHK: 01411 5211 DEPT 04425 5211 3: 18
01420 5211
51550 00001 VERIZON WIRELESS 47270 3104 190.05 -00 -00
9953393380
ASH 01 2024/07 01415 5211 158:01 1000
CCT 110( DEPT
109 APPROVED UNPAID INVOICES 672,389.87
109 INVOICE (S REPORT POST TOTAL 672,389.87
useort generated: 01/3man024 16:39 Page 19
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

CHECHNO CHR DATE TYPE VENDOR NAME CASH COUE TO/DUE ORCH) VOUCHER INVOICE INV DATE WARRANT NET PO
01/30/2024 PRTD 1211 US BANK 122623 12/26/2023 ACH3111 16,782.79 CHECK TOTAL: 16,782.79
NUMBER OF CHECKS 1 *** CASH ACCOUNT TOTAL *** 16,782.79

COUNT AMOUNT
TOTAL PRINTED CHECKS 16,782.79
*** GRAND TOTAL *** 16,782.79
Report generated: 01/30/2024 15:39 Page 1
User: 6175mame
Program ID: apcshdsb
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3111 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE

APPROVED UNPAID INVOICES TO BE POSTED
Report generated: 01/30/2024 15:28 Page 1
User: 6175mame
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3111 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 1211 00001 US BANK 422023 ACH3111 16,782.79 .00 .00
02420 5304 1,421:29 1099:

CONDITIONS THAT PREVENT POSTING INVOICE 1211/47274
01420 5205 175.00 1099:
01420 5202 54.98 1099:
01420 5205 212.53 1099
01420 5203 19.30 1099
01420 5208 205.66 .099
01420 5504 671.53 L099
01420 5208 99.00 1099:

47.08 1099:

59.20 1099:
33333
02 ROYPK
ROYZ
00 8888₴
Report generated: 01/30/2024 15:28 Page 2
User: 6175mame
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST

NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 01406 5205 5.42 1099:
01406 5205 160.00 1099:
01406 5205 80.00 1099
01406 5205 90.98 1099
01414 5205 14.99 1099:
01401 520 59. 68 1099
01406 520 388.50 1099
01404 520 108.70 1099
01401 520 28.75 1099
01404 520 110.01 1099
01404 520 860.45 1099:
01404 520 671.87 1099
01420 520 36.70 1099
01420 520 29.28 1099
01420 520 26.09 1099
01420 5203 9.40 1099
01420 5203 26.09 1099
01401 5208 1099
01420 5202 1099:
52 44
00 5202
5205

NN ROYPK
01 01425 207
01415 7.
01415
60404 5516 ROY2
01425 5203
01425 5203
1 01411 5203
01414 5205 DEVLP
01404 5208
01420
01411
01411
01411
01411 1099
01411 1099
1 APPROVED UNPAID INVOICES TOTAL 16,782.79
Report generated: 01/30/2024 15:28 Page 3
User: 6175mame
Program ID: apinvent
munis

CITY OF FARMERSVILLE
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

CHES A OUR DARE TYPE VENDOR NAME CASH COVE TO/OUE FRCHER INVOICE INV DATE PO WARRANT NET • 01/30/2024 PRTD 849 MURILLO, JOSE ULISES 013024 01/30/2024 ACH3112 110.00 CHECK TOTAL: 110.00
01/30/2024 PRTD 1365 HAYASHI, CHASEN 013024 01/30/2024 ACH3112 270.00 CHECK TOTAL: 270.00
01/30/2024 PRTD 1615 DIAZ, BRENDAN MICHAE 013024 01/30/2024 ACH3112 30.00 CHECK TOTAL: 30.00
01/30/2024 PRTD 1657 LASQUITE, ANTHONY WI 013024 01/30/2024 ACH3112 400.00 CHECK TOTAL: 400.00
01/30/2024 PRTD 1658 DIAZ, VINCENT A. 013024 01/30/2024 ACH3112 420.00 CHECK TOTAL: 420.00
01/30/2024 PRTD 2215 SANCHEZ, MATTHEW 013024 01/30/2024 ACH3112 330.00 CHECK TOTAL: 330.00
01/30/2024 PRTD 2295 MOORE, SKYLER Q 013024 01/30/2024 ACH3112 1,660.00 CHECK TOTAL: 1,660.00
01/30/2024 PRTD 2296 HOPF, LATHAN A 013024 01/30/2024 ACH3112 200.00 CHECK TOTAL: 200.00
01/30/2024 PRTD 2311 FLAMING, EMILEE A 013024 01/30/2024 ACH3112 380.00 CHECK TOTAL: 380.00
01/30/2024 PRTD 2314 LOKEY, MICHAEL 013024 01/30/2024 ACH3112 40.00 CHECK TOTAL: 40.00
cort generated: 01/30/2024 16: Page 1
ogram I apcshdsb
CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

CHECK DATE ENOR NAME CASH DUE TOUCH VOUCHER INVOICE INV DATE PO WARRANT NET 01/30/2024 PRTD 2319 WEBB, TRAVIN 013024 01/30/2024 ACH3112 580.00 CHECK TOTAL: 580.00
01/30/2024 PRTD 2388 JEFFRIES, CHRISTOPHE 013024 01/30/2024 ACH3112 230.00 CHECK TOTAL: 230.00
01/30/2024 PRTD 2390 RIOS, OMERO 013024 01/30/2024 ACH3112 320.00 CHECK TOTAL: 320.00
01/30/2024 PRTD 2415 NICKELS, STUART 013024 01/30/2024 ACH3112 1,410.00 CHECK TOTAL: 1,410.00
01/30/2024 PRTD 2429 BENEDETTA, MICHAEL R 013024 01/30/2024 ACH3112 1,030.00 CHECK TOTAL: 1,030.00
01/30/2024 PRTD 2439 PRICE, CRAIG 013024 01/30/2024 ACH3112 130.00 CHECK TOTAL: 130.00
01/30/2024 PRTD 2441 METCHIKOFF, MATT 013024 01/30/2024 ACH3112 160.00 CHECK TOTAL: 160.00
01/30/2024 PRTD 2459 ACEVEDO, JESUS 013024 01/30/2024 ACH3112 190.00 CHECK I TOTAL: 190.00
01/30/2024 PRTD 2489 BOTELLO, DIEGO 013024 01/30/2024 ACH3112 640.00 CHECK | TOTAL: 640.00
01/30/2024 PRTD 2493 SANDOVAL, MARIA 013024 01/30/2024 ACH3112 390.00 CHECK TOTAL: 390.00
üsert generated: 61/30a2024 16:34 6175mame Page 2
Program ID: apcshdsb
CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

CHECHNA OK DATE TYPE VENDOR NAME CASH COVE TO/DUE FUCHE

VOUCHER INVOICE INV DATE PO WARRANT NET
01/30/2024 PRT 2497 CRUZ, ALEXIS VARGAS 013024 01/30/2024 ACH3112 200.00 CHECK TOTAL: 200.00
01/30/2024 PRTD 11000 FARIAS, RUBEN 013024 01/30/2024 ACH3112 300.00 CHECK TOTAL: 300.00
NUMBER OF CHECKS 22 *** CASH ACCOUNT TOTAL *** 9,420.00

COUNT AMOUNT
TOTAL PRINTED CHECKS 22 9,420.00
*** GRAND TOTAL *** 9,420.00
Report generated: 01/30/2024 16:34 3
User: 6175mame Page
Program ID: apcshdsb
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3112 NEW INVOICES

DOCUMENT

VENDOR REMIT NAMEN INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE

APPROVED UNPAID INVOICES TO BE POSTED
849 00000 MURILLO, JOSE UL 473024 ACH3112 110.00 .00 -00 CASH 01 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 01420 5205 110.00 1099:0 ACCT 1100 DEPT DUE 01/30/2024 DESC:04 202
CONDITIONS THAT PREVENT POSTING INVOICE 849/47281
* w9h1d
1365 00000 HAYASHI, CHASEN 47288 ACH3112 270.00 .00 -00 013024
CAST 1100 2024/07 INV 01/30/2024 DUN 1/30224 SES 0: 2023 DISC: .00 01420 5205 270.00 1099:0 DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 1365/47288
* W9hld
1615 00000 DIAZ, BRENDAN MI 47292 ACH3112 30.00 .00 .00 013024
ASH 01 2024/07 DISC: .00 01420 5205 30.00 1099:0
CCT 110( DEPT T 0/30202 SES 202
CONDITIONS THAT PREVENT POSTING INVOICE 1615/47292
* w9hld
1657 00000 LASQUITE, ANTHON 47285 ACH3112 400.00 .00 .00 013024
CASH 01 2024/07 CNV 01/30/2024 SEP-CHK: DISC: .00 01420 5205 400.00 1099:0 ACCT 1100 DEPT UE 01/30/2024 DESC:04 202
CONDITIONS THAT PREVENT POSTING INVOICE 1657/47285
* w9hld
1658 00000 DIAZ, VINCENT A. 473024 ACH3112 420.00 .00 .00 CASH 01 2024/07 INV 01/30/2024 SEP-CHK: DISC: .00 01420 5205 420.00 1099:

ACCT 1100 DEPT, DUE 01/30/2024 ESC: 04 20
CONDITIONS THAT PREVENT POSTING INVOICE 1658/47291
isert generated: 01/30am024 16:29 Page 1
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3112 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE * W9hld
2215 00000 SANCHEZ, MATTHEW 473024 ACH3112 330.00 - 00 -00 CASH 01 2024/07 ENV 01/30/202 VE 01/30/2024 DES CO: 202 DISC: 00 01420 5205 330.00 1099:0 ACCT 1100 DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 2215/47277
W9h1d
2295 00000 MOORE, SKYLER Q 473024 ACH3112 1,660.00 .00 -00 CASH 01 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 01420 5205 1,660.00 1099:0 ACC 1100 DEPT DUE 01/30/2024 DESC: 04 202:

CONDITIONS THAT PREVENT POSTING INVOICE 2295/47282
9h1d
2296 00000 HOPF, LATHAN A 47287 ACH3112 200.00 - 00 .00 013024
CASH 01 2024/07 DISC: .00 01420 5205 200.00 1099:0
ACCT 1100 DEPT DUE 01/30/2024
CONDITIONS THAT PREVENT POSTING INVOICE 2296/47287
* w9h1d
2311 00000 FLAMING, EMILEE 473024 ACH3112 380.00 .00 •00 AAST 1100 2024/07 DUE 01/30/2024 SES 094 2023 DISC: .00 01420 5205 380.00 1099:0 DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 2311/47289
*W9h1d
2314 00000 LOKEY, MICHAEL 4728 ACH3112 40.00 .00 .00
1302
ASH 01 2024/07 INV 01/30/2024 SEP-CHK: N DISC: 00 01420 5205 40.00 1099:
сст 1100 DEPT DUE 01/30/2024 DESC: 04 2023
CONDITIONS THAT PREVENT POSTING INVOICE 2314/47284
serrt generated: 81/3na2024 16:29 Page
6175mame
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3112 NEW INVOICES

DOCUMENT

VENDOR REMIT NAMER INVOICE VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 2319 00000 WEBB, TRAVIN 413024 ACH3112 580.00 -00 -00
CAST 1100 2024/0 DISC: .00 01420 5205 580.00 1099:0
SES :04 2023
CONDITIONS THAT PREVENT POSTING INVOICE 2319/47275
* w9hld
2388 00000 JEFFRIES, CHRIST 47286 ACH3112 230.00 •00 .00 013024
CASH 01 2024/07 INV 01/30/2024 SEP-CHK: 1 DISC: .00 01420 5205 230.00 1099:0 ACCT 1100 DEPT DUE 01/30/2024 ESC: Q4 202
2390 00000 RIOS, OMERO 727 ACH3112 320.00 .00 •00
1302
CAST 1100 2024/07 DUE 002024 DISC: .00 01420 5205 320.00 1099:0 DEPT
241500000 NICKELS, STUART 47280 ACH3112 1,410.00 -00 -00 013024
ASH 01 2024/07 DISC: .00 01420 5205 1,410.00 1099:0
ACCT 110( DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 2415/47280
2429 00000 BENEDETTA, MICHA 47295 ACH3112 1,030.00 .00 - 00 013024
ACCT 1100 2024/07 ENV 01/30/2024 DISC: 00 01420 5205 1,030.00 1099:

DEPT DUE 01/30/2024
2439 00000 PRICE, CRAIG 727 ACH3112 130.00 -00 .00
1302
ASH 0 2024/07 DISC: .00 01420 5205 130.00 1099:0
CCT 110
CONDITIONS THAT PREVENT POSTING INVOICE 2439/47279
W9h1d
userrt generated: 6173man 24 16:29 Page 3
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3112 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 2441 00000 METCHIKOFF, MATT 47283 ACH3112 160.00 .00 .00 013024
ACCT 1100 20P1/07 DISC: .00 01420 5205 160.00 1099:0
CONDITIONS THAT PREVENT POSTING INVOICE 2441/47283
* w9hld
2459 00000 ACEVEDO, JESUS 013024 ACH3112 190.00 -00 -00 CAST 1100 2024/07 DUe 0102024 DESO 2023 DISC: .00 01420 5205 190.00 1099:

DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 2459/47296
2489 00000 BOTELLO, DIEGO 47294 ACH3112 640.00 .00 .00
013024
CASH 01 2024/07 NV 01/30/2024 SEP-CHK:| DISC: .00 01420 5205 640.00 1099:0 ACCT 1100 DEPT DUE 01/30/2024 ESC: 04 202
CONDITIONS THAT PREVENT POSTING INVOICE 2489/47294
2493 00000 SANDOVAL, MARIA 47276 ACH3112 390.00 •00 .00 013024
пест 1100 2024/07 DUE 01/30/2024 DISC: 00 01420 5205 390.00 1099:

DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 2493/47276
W9h1d
2497 00000 CRUZ, ALEXIS VAR 473024 ACH3112 200.00 -00 •00 AST 1100 2024/07 00 01202024 DES 04 2023 DISC: .00 01420 5205 200.00 1099:

CONDITIONS THAT PREVENT POSTING INVOICE 2497/47293
sert generated: 01302024 16:29 Page 4
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3112 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 11000 00000 FARIAS, RUBEN 473024 ACH3112 300.00 .00 .00 ACT 1100 20p1/07 IN 0302024 SEP :04 2023 DISC: .00 01420 5205 300.00 1099:0 22 APPROVED UNPAID INVOICES TOTAL 9,420.00
22 INVOICE(S) REPORT POST TOTAL 9,420.00
Report generated: 01/30/2024 16:29 Page
user. 6175mame
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

VOUCHER INVOICE INV DATE PO WARRANT NET
01/31/2024 PRTD 488 US TREASURY 012424 01/24/2024 ACH3113 117.00 CHECK TOTAL: 117.00
01/31/2024 PRTD 488 US TREASURY 010524 01/03/2024 ACH3113 32,638.69 CHECK TOTAL: 32,638.69
• 01/31/2024 PRTD 488 US TREASURY 011924 01/18/2024 ACH3113 33,448.01 CHECK TOTAL: 33,448.01
01/31/2024 PRTD 1075 AFLAC 420728 01/03/2024 ACH3113 637.74 CHECK TOTAL: 637.74
01/31/2024 PRTD 1075 AFLAC 770269 01/24/2024 ACH3113 695.94 CHECK I TOTAL: 695.94
01/31/2024 PRTD 1247 LEAF 010224 01/02/2024 ACH3113 702.29 CHECK • TOTAL: 702.29
01/31/2024 PRTD 1507 TEAMSTERS LOCAL UNIO 011724 01/17/2024 ACH3113 180.00 CHECK TOTAL: 180.00
01/31/2024 PRTD 1556 BLUE SHIELD OF CALIF 011924 01/19/2024 ACH3113 51,084.72 CHECK I TOTAL: 51,084.72
01/31/2024 PRTD 1873 MICROSOFT E0400QCNLG 01/09/2024 ACH3113 1,368.00 CHECK TOTAL: 1,368.00
01/31/2024 PRTD 2144 MERCHANT STATEMENT 010224 01/02/2024 ACH3113 61.65 CHECK TOTAL: 61.65
usert generated: 01/ma2024 16:20 Page 1
Program ID: apcshdsb
munis

CITY OF FARMERSVILLE
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

CHECK NACHE DATE VENDRE CAS DUE TOUTE VOUCHER INVOICE INV DATE PO WARRANT NET 01/31/2024 PRTD 2278 GLOBAL PAYMENTS 01022024 01/02/2024 ACH3113 147.85 CHECK TOTAL: 147.85
01/31/2024 PRTD 2278 GLOBAL PAYMENTS 010224 01/02/2024 ACH3113 15.00 CHECK TOTAL: 15.00
01/31/2024 PRTD 2289 WEX FUEL CARD 100324 01/03/2024 ACH3113 10,704.00 CHECK TOTAL: 10,704.00
01/31/2024 PRTD 2289 WEX FUEL CARD 013024 01/30/2024 ACH3113 11,346.75 CHECK TOTAL: 11,346.75
01/31/2024 PRTD 2380 EDIS, INC 011624 01/16/2024 ACH3113 3,378.14 CHECK A TOTAL: 3,378.14
01/31/2024 PRTD 2380 EDIS, INC 122823 12/28/2023 ACH3113 1,057.50 CHECK TOTAL: 1,057.50
01/31/2024 PRTD 2380 EDIS, INC 013024 01/30/2024 ACH3113 1,003.50 CHECK TOTAL: 1,003.50
01/31/2024 PRTD 6070 CALPERS 010324 01/03/2024 ACH3113 21,119.37 CHECK TOTAL: 21,119.37
01/31/2024 PRTD 10530 EMPLOYMENT DEVELOPME 010324 01/03/2024 ACH3113 4,535.84 CHECK TOTAL: 4,535.84
01/31/2024 PRTD 10530 EMPLOYMENT DEVELOPME 011724 01/17/2024 ACH3113 21,119.37 CHECK TOTAL: 21,119.37
escort generated: 01/3mam024 16:20 Page 2
Program ID: apcshdsb
CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL

CHECK NACK DATE TYPE VENDOR NAME CASH (DUE TO/DUE ORCHER INVOICE INV DATE PO WARRANT NET 01/31/2024 PRTD 10530 EMPLOYMENT DEVELOPME 011824 01/18/2024 ACH3113 4,671.40 CHECK TOTAL: 4,671.40
01/31/2024 PRTD 10530 EMPLOYMENT DEVELOPME 012624 01/26/2024 ACH3113 8,086.00 CHECK TOTAL: 8,086.00
01/31/2024 PRTD 14500 FARMERSVILLE POLICE 010324 01/03/2024 ACH3113 455.00 CHECK TOTAL: 455.00
01/31/2024 PRTD 14500 FARMERSVILLE POLICE 011724 01/17/2024 ACH3113 455.00 CHECK TOTAL: 455.00
01/31/2024 PRTD 42000 SOUTHERN CALIFORNIA 11124 01/11/2024 ACH3113 34,665.45 CHECK TOTAL: 34,665.45
01/31/2024 PRTD 42000 SOUTHERN CALIFORNIA 121223 12/12/2023 ACH3113 37,717.08 CHECK TOTAL: 37,717.08
01/31/2024 PRTD 42000 SOUTHERN CALIFORNIA SL011624 01/16/2024 ACH3113 11,845.03 CHECK TOTAL: 11,845.03
01/31/2024 PRTD 43000 THE GAS COMPANY 122823 12/28/2023 ACH3113 2,021.52 CHECK I TOTAL: 2,021.52
01/31/2024 PRTD 50100 VALIC 011924 01/19/2024 ACH3113 4,726.52 CHECK TOTAL: 4,726.52
01/31/2024 PRTD 50100 VALIC 010324 01/03/2024 ACH3113 4,726.52 CHECK TOTAL: 4,726.52
Report generated: 01/31/2024 16:20 Page 3
User: 6175mame
Program ID: apcshdsb
CITY OF FARMERSVILLE munis
a tyler erp solution

A/P CASH DISBURSEMENTS JOURNAL
NUMBER OF CHECKS 30 *** CASH ACCOUNT TOTAL *** 304,730.88

COUNT AMOUNT
TOTAL PRINTED CHECKS 30 304,730.88
*** GRAND TOTAL *** 304,730.88
Report generated: 01/31/2024 16:20 Page 4
user: 6175mame
Program ID: apcshdsb
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3113 NEW INVOICES

DOCUMENT

VENDOR REMIT NAMEN INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE

APPROVED UNPAID INVOICES TO BE POSTED
488 00000 US TREASURY 072924 ACH3113 117.00 .00 .00
CASH 01 2024/07 INV 01/24/2024 SEP-CHK: Y DISC: .00 01406 5205 117.00 1099:

ACCT 1100 DEPT DUE 01/31/2024 DESC: PAYROLL
CONDITIONS THAT PREVENT POSTING INVOICE 488/47297
* w9hld
488 00000 US TREASURY 47301 ACH3113 32,638.69 - 00 -00
010524
ASH 01 2024/07 NV 01/03/202 DISC: .00 01 2223
ACCT 1100 DEPT 01 2222 15: 384-88 1093
CONDITIONS THAT PREVENT POSTING INVOICE 488/47301
012224 13,717.45 1099:
488 00000 US TREASURY 47311 ACH3113 33,448.01 .00 .00
011924
ACT 1100 2024/0 NV 01/18/202 DISC: .00 1 222
VE 01/31/202 1 222 15,650.16 1099
CONDITIONS THAT PREVENT POSTING INVOICE 488/47311
01 2224 14,137.45 1099:
1075 00000 AFLAC 47299 ACH3113 637.74 .00 .00
420728
ASH 0. 2024/07 NV 01/03/2024 SEP-CHK: DISC: .00 01 2227 637.74 1099:

CCT 110| DEPT DUE 01/31/2024 ESC: PAYROL
1075 00000 AFLAC 47307 ACH3113 695.94 .00 .00
770269
CASH 01 2024/07 INV 01/24/2024 EP-CHK: DISC:.00 01 2227 695.94 1099:

ACCT 1100 DEPT DUE 01/31/2024 ESC: JAN 202
Report generated: 01/31/2024 16:15 Page 1
User: 6175mame
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3113 NEW INVOICES

DOCUMENT

VENDOR REMIT NAMER INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 1247 00000 LEAF 1731 ACH3113 702.29 .00 .00
10224
CAST 1100 2024/07 1406 52
DEPT SED CHORESSIONAL SERVICE 1411 52 351:14 1093
CONDITIONS THAT PREVENT POSTING INVOICE 1247/47314
W9h1d
1507 00000 TEAMSTERS LOCAL 47372 ACH3113 180.00 .00 •00 ASH 0 2024/07 INV 01/17/2024 SEP-CHK: Y DISC: .00 01 2232 180.00 1099:
сст 1100 DEPT DUE 01/31/2024 DESC: PAYROLL
CONDITIONS THAT PREVENT POSTING INVOICE 1507/47306
W9h1d
1556 00000 BLUE SHIELD OF C 47309 ACH3113 51,084.72 -00 .00 011924
CAST 110 2024/07 TUE 01/31/2024 SESC:02/01/24-02025/2400 012233 51,084.72 1099:

CONDITIONS THAT PREVENT POSTING INVOICE 1556/47309
1873 00000 MICROSOFT 47321 ACH3113 1,368.00 .00 .00
:0400QCNL(
2021/0 DUE 0/12024 DESCAN 2024 DISC:.00 0140 5211 295.06 1099 CONDITIONS THAT PREVENT POSTING INVOICE 1873/47321
* w9hld
L414 52 27-57 1099:

L415 52
01420 5211 188.69 1099
01425 5211 125.01 1099:
02404 521] 115.57 1099
2415 521 18.87 1099
2425 521 120.29 1099:
04404 5211 110.86 1099.
04415 5211 18.87 1099:
4425 521 123:30
6404 521 1099
Report generated: 01/31/2024 16:15 Page 2
Urogram ID:
apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3113 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 06415 5211 9.43 1099
06425 5211
21404 5211
21425 5211 99:06 1099
35425 5211
2144 00000 MERCHANT STATEME 47316 ACH3113 61.65 .00 .00 010224
CASH 01 2024/07 DISC: .01 01414 5205 61.65 1099:

АССТ 1100 DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 2144/47316
2278 00000 GLOBAL PAYMENTS 470234 ACH3113 15.00 .00 •00 ASH O 2024/07 DUE 01/3/2024 SES PROFESSIONAL SERVICE 01406 5205 15.00 1099:
сст 110 DEPT
CONDITIONS THAT PREVENT POSTING INVOICE 2278/47313
W9hld
2278 00000 GLOBAL PAYMENTS 47315 ACH3113 147.85 .00 .00 01022024
CASH 01 2024/07 INV 01/02/2024 SEP-CHK: A DESC: PROFESSTONAL SERVICE 01406 5205 147.85 1099:

ACCT 1100 DEPT DUE 01/31/2024
CONDITIONS THAT PREVENT POSTING INVOICE 2278/47315
* wahld
2289 00000 WEX FUEL CARD 47326 ACH3113 10,704.00 -00 •00 100324
ASH O 2024/07 DISC: 00 01406 5255
сст 110 DEPT 01411 5259 5,793:25 1039:

CONDITIONS THAT PREVENT POSTING INVOICE 2289/47326
* w9hld
01415 5255 471.54
01420 5255 1,835.90
01425 5255 655.43
02425 5255 630.23
04425 5255 630.23 10300
06425 5255 50.42
Report generated: 01/31/2024 16:15 Page
User: 6175mame
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3113 NEW INVOICES

VENDOR REMIT NAMERI DOCUMENT

INVOICE PO VOUCHER WARRANTI NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 1425 525
5425 525 529:30 1093:
2289 00000 WEX FUEL CARD 47327 ACH3113 11,346.75 .00 .00 13024
ASH O 2024/07 DUE 01/31/2024 DESCUELY DISC: .00 01406 5255 61:93 109 сст 110 DEPT DUE 01/31/2024 01411 5255 , 761.7
CONDITIONS THAT PREVENT POSTING INVOICE 2289/47327
01415 5255 1,621.34 1099
01420 5255
01425 5255 382.78 1099:
02425 5255 848.83 1099
04425 5255 848.83 1099
06425 5255 67.91 1099:
21425 5255
35425 5255 33.9!
2380 00000 EDIS, INC 47322 ACH3113 3,378.14 .00 .00
011624
2024/07 INV 01/16/2024 01 2233 3,378.14 1099:

DEPT DUE 01/31/2024 I SES PROFESSIONAL SERVICE
2380 00000 EDIS, INC 47323 ACH3113 1,057.50 -00 .00
122823
2024/07 DUE 0232023 DESCPROFESSIONAL SERVICE 01 2233 1,057.50 1099:

DUE 01/31/2024
2380 00000 EDIS, INC 073024 ACH3113 1,003.50 •00 .00
ACT 1100 2024/07 INV 01/30/2024 DES: PROFESSIONAL SERVICE DISC: .00 01 2233 1,003.50 1099:

DEPT DUE 01/31/2024
6070 00000 CALPERS 47298 ACH3113 21,119.37 .00 .00
010324
2024/07 DISC: 00 01 2226 21,119.37 1099:

DEPT
10530 00001 EMPLOYMENT DEVEL 470324 ACH3113 4,535.84 -00 .00 CAST 1100 2024/07 DISC: .00 012235 4,535.84 1099:

Useort generated: 61/3ma2024 16:15 Page 4
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3113 NEW INVOICES

DOCUMENT
VENDOR REMIT NAMEN INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY •PO BALANCE CHK/WIRE 10530 00001 EMPLOYMENT DEVEL 473024 ACH3113 21,119.37 -00 -00 CAST 1100 2021/0 NV 01/17/202 DISC: .00 01 2235 21,119.37 1099:

UE 01/31/202
10530 00001 EMPLOYMENT DEVEL 47310 ACH3113 4,671.40 -00 -00 011824
AST 1100 2024/07 INV 01/18/202 DISC: 00 01 2235 4,671.40 1099:

UE 01/31/202
10530 00001 EMPLOYMENT DEVEL 47312 ACH3113 8,086.00 -00 .00 012624
ACCT 1100 2027/0 ONe 0/3/2024 DISC: .00 01 2235 8,086.00 1099:
14500 00000 FARMERSVILLE POL 470334 ACH3113 455.00 -00 •00 ASH O 2024/07 ENV 01/03/202 SEP-CHK: DISC: 00 01 2232 455.00 1099:
сст 110 DEPT UE 01/31/202 DESC: PAYROL
14500 00000 FARMERSVILLE POL 973724 ACH3113 455.00 -00 - 00 CASH 01 20P1/07 IN 01/1/2024 DESCEPAYROLL SEP-CHK: Y DISC: 00 012232 455.00 1099:

ACCT 1100
42000 00001 SOUTHERN CALIFOR 17324 ACH3113 34,665.45 .00 -00 CAST 1100 2021/07 INV 01/11/2024 DISC: 00
01420 5206 657:89
1099
0242 3206 1099
1099
01406 5206 1099
35425 5206 1099:
39425 5206 HLTHY 186:46 1099
39425 5206 CMCTR
usert generated: 01/3ma2024 16:15 Page 5
6175mame
Program ID: apinvent
CITY OF FARMERSVILLE munis
a tyler erp solution

INVOICE ENTRY PROOF LIST
CLERK: 6175mame BATCH: 3113 NEW INVOICES

DOCUMENT

VENDOR REMIT NAME INVOICE PO VOUCHER WARRANT NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 42000 00001 SOUTHERN CALIFOR 423233 ACH3113 37,717.08 -00 -00 ACST 1100 2024/07 INV 12/12/2023 DISC: 00 01420 520€ 1099 DUE 01/31/2024 SED ELECTRIC 01425 520€ 803001 1099
21425 5206 1099
02425 5206 1099
044255206 1099
01406 5206 1099
35425 5206
9425 5206 HLTH 1099
9425 5206 CMCT
42000 00001 SOUTHERN CALIFOR 47325 ACH3113 11,845.03 .00 .00 SL011624
ACCT 1100 2024/07 DISC: 00 21425 5206 11,845.03 1099:

DEPT
43000 00001 THE GAS COMPANY 47317 ACH3113 2,021.52 - 00 .00 122823
CASH 01 2024/07 INV 12/28/2023 SEP-CHK: N DISC: 00 014255206 243.76 1099:

ACCT 1100 DEPT DUE 01/31/2024 DESC: PROFESSIONAL SERVICE 01406 5206 861.88 10993 39425 5206 CMCTR 915.88
50100 00001 VALIC 47300 ACH3113 4,726.52 .00 .00
010324
ASH O 2024/07 INV 01/03/2024 SEP-CHK: Y DISC: .00 01 2332 4,726.52 1099:
сст 110 DEPT DUE 01/31/2024 DESC: PAYROLL
50100 00001 VALIC 47308 ACH3113 4,726.52 .00 •00
11924
CASH 01 2024/07 INV 01/19/2024 DESE PROFESSIONAL SERVICES SEP-CHK: N 012332 4,726.52 1099:

ACCT 1100 DEPT DUE 01/31/2024
30 APPROVED UNPAID INVOICES TOTAL 304,730.88
30 INVOICE (S) REPORT POST TOTAL 304,730.88

Page 6 ends

Arora enerated: 0142024 26:25
Program ID:
- --
- "
01/17/2024 14:46
6175bash Bradvred
WARRANT: 011924 From: 01/03/2024 To: 01/16/2024
EXP # NAME CHK # NET PAY
g-a p-1 8-
i-irivrin-irinrim-iriri
38 fririnnrinirinirin.iriri
2;629:35
Total Deposits: 44 80,508.71
** END OF REPORT - Generated by Betina Ashoori **
01/31/2024 14:09 ICITY OF FARMERSVILLE
6175bash ADVICE REGISTER - BI WEEKLY pradiureg
WARRANT: 020224 FIOm: 01/17/2024 IO: 01/30/2024
EMP # NAME CHK # NET PAY
1,729.13
1,033.95
18 1,939.12
149 1,917.57
23 2,073.06
153 1,635.3B
11 6,237.76
98 2,473.92
148 1,855.78
112 2,480.96
152 1,240.47
25 2,694.34
119 1,437.14
135 1,453.60
26 2,956.42
39 2,354.64
75 3,360.59
113 1,787.94
82 1,695.64
111 1,464.91
86 3,499.66
157 1,101.96
38 1, 766 . 06
154 1,278 .19
55 4, 356 .02
151 1,800.69
117 788 57
97 2,146 . 05
145 320 86
143 1,523.95
81 2,423.19
124 2,392.15
108 1,614.47
144 1,258.01
80 2,293.66
147 1,660.25
61 1,115.69
156 1,963.20
155 1,603.71
130 2,029.37
Total Deposits: 40 81,817.97
** END OF REPORT - Genexated by Betina Ashoori **

CITY OF

CITY OF FARMERSVILLE

PORTFOLIO SUMMARY

FARMERSVILLE
Treasurer's Report for January 2024
Monthly Transaction Report as prescribed by Government Code Section 53607 & 53646(b) Market %of Days to Est. 1Mo
Investments Par Value Value Book Value Portfolio Term Maturity Yield CAMP Pool (PFM Asset Management) 5,285,993 5,285,993 5,285,993 20.44% 1 1 5.54% CLASS Pool (Public Trust Advisors) 5,743,241 5,743,241 5,743,241 22.20% 1 1 5.50% LAIF Pool (CA State Treasurer) 72,164 72,164 72,164 0.28% 1 1 4.01% CSJVRMA Pool (Chandler Asset Management) 2,664,838 2,609,874 2,609,874 10.09% 1 1 3.79% Pool Total 13,766,237 13,711,273 13,711,273 53%
Certificates of Deposit 4,215,000 4,115,490 4,115,490 15.91% 1442 548 2.46% Federal Agency Securities 4,302,000 4,090,376 4,090,376 15.81% 1753 746 1.14% Money Market (Time Value Investments) 105,044 105,044 105,044 0.41% 4.97% Money Market (Citizens Business Bank) 390,630 390,630 390,630 1.51% 1 1 0.10% Securities Total 9,012,674 8,701,540 8,701,540 34%
Cash 3,452,441 3.452,441 3,452,441 13.35% 1 1 0.10%
Grand Total 26,231,352 25,865,254 25,865,254 100%
This monthly report accurately reflects all the City pooled investments.

It is in conformity with the City's investment policy as amended.

The City has sufficient cash flow to meet six months expenditures.

Citizens Business Bank, Time Value Investments, Chandler Asset Management, CAMP, CLASS, and LAIF statements are the source for market values. 2/7/2024
Steve Huntley, Treasurer Date

CITY OF

FARMERSVILLE
City Council
Staff Report 7D
TO: Honorable Mayor and City Council
FROM: Jennifer Gomez, City Manager
DATE: February 26, 2024
SUBJECT: Request by Farmersville Elite Soccer Club for Special Event Funding for Fiscal Year 2023-24
RECOMMENDED ACTION:

It is recommended that the City Council review and approve a request from Farmersville Elite Soccer Club in the amount of $1,050.

BACKGROUND and DISCUSSION:

The City Council established an annual grant program in which funds may be awarded to applicants that fund activities or events which will benefit the community. The Farmersville Elite Soccer Club has requested $1,050 to assist with their expenses pertaining to fees at the Community Center.

The program will take place June 11t through September 19'h on Tuesdays and Thursdays.

Adults are charged a $5 fee to play, but children will be able to play for free if this request is approved. Councilmembers Gomez and Valdovinos have reviewed the application and recommend the approval of $1,050.

FISCAL IMPACT:

Approving this request will leave a balance of $7,340 in the Special Event Budget in the current fiscal year.

DOCUMENTS:

Event Funding Application
:

CITY OF
2023-2024
FARMERSVILLE City of Farmersville Event Funding
Request Form B
(Request for Assistance $1,000)
Special Notice for Fiscal Year 2022-2023:

This announcement of submission of an application is in no way a commitment of funding.

Request Guidelines:
• It you are requesting financial assistance for more than one event, a separate request form and distinct separate budget must be submitted for each request. • Any questions re submitting a funding request should be directed to the City of Farmersville 559-747-0458

1. Name of Event:_Futsal (Soccer)

2. Date of Event: _Tuesdays & Thursdays 6 PM - 8 pm June 11 thru Sept 19

3. Location of Event: Farmersville Community Center Gym

4. Name of Applicant/Organization hosting event: Farmersville Elite Soccer Club

5. Contact Person:

Name: Manuel Amezcua
Title: Club President
Phone:_559-623-5861
Email:[email protected]
Address: 1853 N Steven CT
City: Farmersville _ State:_CA _Zip: 93223

6. pesription of Event Opening the sym for the community to come p'ay and learnabeus :

7. Describe what benefits the community and City of Farmersville will receive from the event:

The kids and community will receive highly skilled training in the game of soccer from trained professionals who only wish to pass on wisdom and the love of the game.to everyone in Farmersville.

8. 'Anticipated Number of out-of-town overnight attendees: _0

9. Anticipated number of local attendees: _20-40 on each of the 2 days

10. Is this fundraising event? Yes_x. No

11. Event Promotion- What type of advertising/public relations/promotion methods do you plan to use to advertise the event? For example, provide details of promotional activities, materials, and ad placements, including the name of publications, location of billboards, tv/radio stations, websites, number of postcards to be produced, etc.

We will be promoting the Futsal/Open gym on the Club website and Facebook page

12. Is this event free to the public: Yes_ No x

13. Is this a first-time event: Yes

14. What hotels have committed to special rates or packages for the event date?

15. Describe your procedures for crowd control and security:

No security needed, only people participating will be allowed into the gym

16. How many estimated hotel room nights will be generated by this event?

17. Liability Insurance: Yes. _ No

18. Have you consulted with City/County/State and other agencies to determine what permits will be required to conduct this event? Yes_ No

19. Total Amount of Financial Assistance requesting: $1,050.00

20. Complete this projected event budget worksheet:
•
Anticipated Revenue:

1. Admissions • $_ 500.00

2. Booth/Space Rentals --

3. Corporate/Individual Sponsors ----- $
$_

4. Other Revenue (please list)

5. Requested City of Farmersville in Kind Support (Please List) (i.e., Permit Fee Waive, Traffic Control, Security, Electrical Support, Other City Staff Labor, City Equipment, Portable Restrooms, Street Barricades, City Facilities, etc.) $
$
$
$

6. Requested City of Farmersville Monetary Support $
Total Projected Revenue: $.

Anticipated Expenses:

7. Personnel:

Administrative $.

Artistic $
Technical- $
Other -- $

8. Space Rental $1,050.00

9. Equipment Rental -- $.

10. Miscellaneous Supplies $- 200.00

11. Permits/License - $
•
• 12. Advertising/Marketing- $

13. Other Expenses
Insurance $_450.00
$.

Total Projected Expenses: - $1,700.00

OFFICIAL WITH CONTRACTING AUTHORITY FOR THE

ORGANIZATION
I HEREBY CERTIFY that the facts stated herein this Event Funding Request are true and correct to the best of my knowledge. The Event described herein will be conducted in accordance with all applicable city/county and other regulations, and the Event provides equal access to employment and event participation without regard to race, color, religion, sex, national origin, age, disability, or military status in accordance with applicable federal laws.
:
:

Official's Signature: Date: 2/15/24
Official's Name & Title (Print): Manuel Amezcua Farmersville Elite Soccer Club President Phone Number: 559-623-5861 E-Mail address: [email protected]_ :
•
:

BOYS & GIRLS CLUBS
OF THE SEQUOIA!

FARMERSVILLE COMMUNITY CENTER

FACILITY RENTAL AGREEMENT-FEE WAIVER
Organization/ Group Name:_Farmersville Elite Soccer Club (FESC) Address:_ 1853 N. Steven Ct, Farmersville CA 93223 Phone: 559-623-5861 Contact person: Manuel Amezcua Phone: 559-623-5861
Cell phone Email: [email protected]
Room(s) to befused: Gym
Purpose of use: Futsal Soccer
•
Group is not to start activity until agreed-upon start time. User group agrees to following:

1. Reservation days and time: Tuesdays & Thursdays 6:00 P.M -8:00 P.M :

2. Dates agreement is in effect: June 11, 2024 - Sept 19, 2024

3. Damage deposit and rental fees are to be paid in advance of facility use.

4. Agreed fee for Boys & Girls Club Attendant: $25 per hour × 60 hours = $ 1.500.00 - $ 450 = $1,050.00 (total fee)
2 days of Credit:

FESC ended the open gym night on Sept. 07, 2023, the original end date was Sept, 28 2023. That gives us 6 days of credit.

PESC did not open for the 4"r of July. This is 1 day of credit.

Boys & Girls Club canceled 2 open gym nights because of Boys & Girls Club training. This gave us 2 days of credit.
9 days of credit, 2 hours each day at $25 gives us a credit of $450 to go towards this year's gym rental.

City to fund the Fee: Date:
(City manager signature)
Or
City waives the presence of an Attendant: Date:_

Page 1 ends

BOYS & GIRLS CLUBS

OF THE SECUOTA
• (City manager signature)
Damage/cleaning deposit: $300 - will be refunded at discretion of BGCS and in full if facility is left clean and undamaged and rules and policies are followed. The renter will be billed for any damages or extra staff time not covered by deposit. Allow up to four (4) weeks for processing and return of deposits.

First payment of deposit plus use fee =$. _due by:

Subsequent payments due each week/month, etc.

Liability Insurance:

À Certificate of Liability Insurance is required for facility reservations. Renters are to provide proof of liability insurance with minimum coverage of $1,000,000, naming the City of Farmersville, its officers, officials, employees, agents, representatives, volunteers and Boys & Girls Clubs of the Sequoias as additional insured. If alcohol is seryed at the event, the policy must specifically state that it covers an event wịth alcohol. Contact your local insurance agent to obtain insurance or obtain an insurance certificate online at: https://www.theeventhelper.com/ Turn in insurance certificate to facility at: 623 N. Avery Ave. Farmersville, CA 93223 or email - [email protected]
Failure to provide appropriate documentation will result in cancellation.

Security Guard Service
:

Professional security guard services are required for all public and private gatherings which include the following: dances, music, and alcohol.. :
create renter is responsible for consuming the clean-up for all areas used, This inchutes kitchen, areas in need of mopping due to spilled beverages, and assistance with take down of tables and chairs, taking down all decorations, removing trash to the proper •area. Building attendants will clean restrooms and assume other basic custodial cleaning. Additional hours of required cleaning post rental due to messy rentals, will lead to deduction in facility damage/cleaning deposit return. Facility must be Adult Supervision
•.

Pace 2 of 4
:
:

BOYS & GIRLS CLUBS

OF THE SEQUOIAS
Programs involving youth under age 18 must be supervised by an adult at all times with a minimum of one (1) adult per 20 youth.

Renter Conduct
The renter is solely responsible for all accidents or injuries to individuals or property resulting from use of the facilities. The renter is resporisible for the control and supervision of all people in attendance. The renter must ensure that no damage is done to the facilities, and that all of the attendees conduct themselves in an orderly manner in and around the facility, including the parking lot. If behavior of the group is deemed inappropriate or unsafe for any reason, the function may be stopped and denied further use of the facility. The latter applies to any damages to facilities and equipment during function. Furthermore, if it becomes necessary during the course of the function to summon the police for any reason, all or part of the damage/cleaning deposit may be forfeited. The damage/cleaning deposit may also be forfeited for litter in parking lot, property, or excessive cleaning done by building attendant.

Renters will be billed for damages, cleaning expenses, and staff overtime in excess of the deposit or for total damages.

Cancellations
Should a renter need to cancel. It must be cancelled 2 weeks prior to the event with a $25 reservation fee. Cancellations between one and two weeks will be charged $75 and less than one week will be charged the full damage/cleaning deposit ($150).

BGCS has the right to cancel the event if deposits) have not been paid by date due or other required paperwork has not been submitted by date due.

Refund Policy
Refunds on damage/cleaning deposit and dance/music deposits are based on compliance with the rental contact, as well as the security and clean-up requirements.

To receive a full refund on the damage/cleaning deposit; the building must be cleaned, and cleared of ail guests, rental party, etc. at the agreed upon time. Caterers, musicians, etc. may continue cleaning up during the last hour of the rental time. The renter is responsible for caterers, musicians, photographers, and guest's tardiness and may have all or part of their security deposit withheld if they go over the agreed upon rental time. The renter will be billed for any damages or extra staff time not covered by deposit. Deposit will be refunded at discretion of BGCS and in full if facility is left clean and undamaged and rules and policies are followed. Allow up to four (4) weeks for processing and return of deposits.

I hereby certify that I have read and agree to abide by the policies and regulations set forth by this agreement, and I understand that failure to comply may result in the cancellation of use of Pare 3 of 4

BOYS & GIRLS CLUBS

OF THE SEQUOIAS
the facility. I agree as representative of the group or organization to hold the Boys & Girls Clubs of the Sequoias (Club) and City of Farmersville (City) harmless, indemnify and defend the Club and City and all its officers, employees, volunteers and independent agents from any claim, damage, demand, liability, loss, cost or expense, for any damage whatsoever, including but not limited to death or injury to any person or injury to any property, resulting from misconduct, negligent acts, or of any of its officers, employees or agents in the performánce of this agreement, except such damage as is caused by the sole negligence of the Club or City or any of its officers, employees, volunteers or agents.

The Boys & Girls Club has the authority to approve applications. Facility rentals are not confirmed until the application has been approved in writing by authorized staff of the Boys & Girls Club and City of Farmersville. Permits are immediately revocable if false statements were made when reserving a facility or if an individual or group willfully violated any city ordinance, facility policies or regulations. Fees will be retained in the event that the activity is terminated due to violation of any city ordinance, rule or regulation, or the falsification of the application.

City Manager/Designee signature: _Date:_
User signature: _Date: Z/14/24
B&GC signature: _Date: 2/14/24

Page 4 of 4 ends

CITY OF

FARMERSVILLE
City Council
Staff Report 8A
TO: Honorable Mayor and City Council
FROM: Steve Huntley, CPFO, IPMA-SCP
Director of Finance and Administration
DATE: February 26, 2024
SUBJECT: Consider Approving Resolution 2024-007 adopting Mid-Year Budget Amendment for Fiscal Year 2023-24
RECOMMENDED ACTION:

Approve Resolution 2024-007 adopting the Mid-Year Budget Amendment for Fiscal Year 2023-

24. BACKGROUND and DISCUSSION:

The intent of this report is to give the City Council and the public a brief synopsis of progress made thus far through the budget year. All figures are represented exactly fifty percent (50%) of the way through the Fiscal Year 2023-2024 (FY 2024) which occurred on December 31, 2023.

The Mid-Year Review, while almost always accompanied by a budget amendment, does not necessarily have to include an amendment to the budget. The mid-year point is just a logical milestone by which to measure progress made and make the necessary adjustments needed given the changing variables halfway through a year.

This mid-year report is accompanied by an amendment, and in fact, is the only amendment of the year so far. However, there are a significant amount of changes within it, making this adjustment a larger one than usual.

As a result, the discussion about the existing budget has no mention of a "revised budget" figure within this report (like past years' reports) because there haven't been any changes yet. While there are plenty of changes that occurred (staff, inflation, emergency purchases, etc.) they just haven't been turned into a budget amendment until the proposed amendment accompanying this report.
1 ORGANIZATION OF DOCUMENTS
This staff report is accompanied by several documents and organized in a certain way to transparently display the changes proposed to the FY 2024 budget. This staff report contains several different portions with the intent of answering the questions "What happened so far?" and "Why?" to each of the proposed changes. Here is a description of the documents and how they are laid out:

The staff report/gives a snapshot as of 12/31/2023 and then details the changes needed to the capital budget, the operational budget, and then dives down further specifically on grants and projects. Overall, the staff report has three parts, and two sections in each part:
• Part One is the update on the progress through the budget for FY 2024 as of 12/31/2023 (50%). The two sections within the first part cover 1) the capital budget and 2) the operations budget.
• Part Two discusses the proposed amendments to the budget which are discussed in two sections 1) the capital budget and 2) the operations budget. • Part Three discusses financial health as context to this budget amendment by 1) discussing the risk factors and ranking of the City by the State Auditor and.2) discussing other health factors applicable to the City. The current fund balances are also listed here.

There are several documents included with this report to help facilitate the update and changes needed:
• The budget journal is a simplified accounting document created to show the actual changes to the budget by each accounting line that will take place in the budgeting system for the City.
• The resolution is the official document the City Council uses to adopt the adjustments to the FY 2024 budget.
• The Operation and Capital Budget documents are spreadsheets used internally to display the budget in accounting terms, by fund for tracking and entering data into the system. This compares the proposed budget to actual, the original budget, and to prior year budget.
• Capital Budget worksheets detail out each Capital Budget item included in the Five-Year Capital Improvement Plan, as needed.

All of these together are the complete details of what is happening with the budget as a result of the analysis at mid-year. However, by just reviewing this staff report, one should be able to. understand all of this at a high level. :
2 PART ONE: CURRENT YEAR PROGRESS
The City of Farmersville has officially reached the 50% mark of the year and this report will now breakout any statistically significant variations or other financially significant events impacting the City through the Capital or Operation Budgets for FY 2024. The goal of this part of the report is to answer the question of "What has happened in the first half of the year?" Here are the high-level statistics relevant to the budget progress made so far through the year, first examining the Capital Budget and then the Operations Budget.

CAPITAL BUDGET AS OF 12/31/2023
The City of Farmersville started the year with a busy Capital Budget of $19,802,511 spread across many City funds for FY 2024.

YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5
SUMMARY OF CAPITAL IMPROVEMENT PLAN 2023-24 2024-25 2025-26 2026-27 2027-28 TOTAL Administration 43,500 43,500
Code Enforcement 50,000 50,000
Engineering 14,938,069 2,436,692 7,531,624 2,327,500 2,842,500 30,076,385 Fire 647,000 6,500,000 660,000 7,807,000
Planning 305,999 129,525 435,524
Police 89,811 168,612 183,542 172,042 197,542 811,549
Public Works 982,500 878,500 500,000 1,045,000 7,177,632 TOTAL 19,802,511 10,217,329 8,593,666 3,043,042 4,745,042 46,401,590, A few of the projects within these budgets above are recommended to be modified in some way or another, which will be covered in the second half of this report in the proposed changes section.

For now, to further breakdown the progress made in the Capital Budget, the following table compares the Capital Budget for FY 2024 to what has been spent on those items as of 12/31/2023 and a summarizing status for reference.

The table on the following page reveals that the Capital Budget was about 24% spent as of mid- year. While this is not close to matching the 50% mark throughout the year, staff anticipates that the spending will begin to catch up near the end of the year with the release of all capital spending by the City Manager.

As of December 31, 2023, there were 33 Capital items budgeted for the FY 2024, of which, only 3 are complete, another 7 are anticipated to be complete by the end of the fiscal year, and the rest are either ongoing multi-year projects or will need to be modified to adjust the scope/timeline. So, at this point, staff is expecting that 10 of the 33 (30%) of projects will be completed or substantially begun with an estimated value of about $5 million by the end of the year with a very small portion of projects delayed or removed. Those specific projects will be covered more in Part 2 of this report.

Some of the highlights that should be mentioned in the Capital Budget so far through the year:

Great progress has been made on the Freedom Field project and should be in use soon. This is the latest phase of park development. Along with this are the refurbishment of the amenities in Roy's Park too. The other largest spending this year has been the Year One pavement 3 improvement projects that have taken place throughout town. There are also several important pieces of equipment that have been purchased (or are in progress) including a new Fire Patrol, Fire Water Tender, Public Works backhoe, skid steer loader, bucket truck, and new Police patrol vehicles.

In addition to parks, roads, and equipment, there are still planning and engineering related studies being conducted. These will be important for future capital projects.

Unfortunately, the City is still a victim of delayed deliveries when it comes to some purchases, specifically vehicles. The City just received the new police vehicles (ordered a year ago) and we are still waiting for the delivery of a Code Enforcement vehicle, a Vacuum Truck, and other pickup trucks.

While progress is being made, staff believes that the budget will not be fully spent by year end due to many delays out of control of staff.

YEAR 1 YTD SPENT PERCENT OF
CAPITAL BUDGET FOR FISCAL YEAR 2023-24 2023-24 2023-24 BUDGET CURRENT STATUS Code Enforcement Vehicle (Air Quality Grant) 50,000 0.0% COMPLETE BY 6/30 Birch Water Line Relocation 35,000 3,150 9.0% IN PROGRESS Master Plans for Sewer, Water, and Storm Drain 140,000 0.0% IN PROGRESS New Water Well (ARP allocation) 822,000 - 0.0% DELAYED TO FY25 City Hall Parking Lot (Phase 1) 450,000 1,233 0.3% IN PROGRESS Pavement Management Program: Street Repairs Year 1 2,700,000 2,377,462 88.1% COMPLETE BY 6/30 Pavement Management Program: Ongoing Repairs 2,000,000 0.0% IN PROGRESS Solar Plant located at new WWTP 5,000,000 0.0% DELAYED TO FY25 Highway 198 Gateway Improvements (CCLGP) 3,601,069 207,475 5.8% IN PROGRESS Citrus/Road 168 Connectivity Street Project 190,000 0.0% IN PROGRESS Central Fire Station 392,000 2,550 0.7% IN PROGRESS
Fire Patrol Vehicle 255,000 86,567 33.9% IN PROGRESS
Downtown Specific Plan 80,000 39,069 48.8% COMPLETE BY 6/30 Zoning Ordinance Update 50,000 38,938 77.9% COMPLETE BY 6/30 General Plan Update 175,999 12,750 7.2% IN PROGRESS
Jennings Park Remodel Project 334,000 0.0% IN PROGRESS
New Corporation Yard 240,000 20,185 8.4% IN PROGRESS
Sports Park Rehabilitation Project 39,000 0.0% IN PROGRESS Roy's Park Improvement 96,500 79,706 82.6% IN PROGRESS
Skid Steer Loader (Bobcat) 147,000 117,190 79.7% COMPLETED Downtown Streetlight Upgrade 40,188 0.0% IN PROGRESS
Freedom Field 884,000 843,125 95.4% COMPLETE BY 6/30
Booster Pump & Electrical Panel for Sports Park 180,000 17,515 9.7% IN PROGRESS Liberty Park Trail Improvements 141,000 0.0% IN PROGRESS Pocket Park Improvements 150,000 0.0% IN PROGRESS
Roy's Park - Phase I| 775,000 528,006 68.1% IN PROGRESS Vacuum Truck 384,500 0.0% COMPLETE BY 6/30
Public Works Backhoe 172,000 139,635 81.2% COMPLETED
Community Center Air Conditioning Units 108,475 105,725 97.5% COMPLETED Public Works Pickup Trucks 79,969 0.0% COMPLETE BY 6/30 Patrol Vehicle Replacement (FY22) 58,070 43,553 75.0% IN PROGRESS Patrol Vehicle Replacement (FY24) 11,500 0.0% IN PROGRESS Axon Fleet 3 In-Vehicle Camera System 20,241 0.0% IN PROGRESS TOTAL 19,802,511 4,663,832.97 23.6%
4 OPERATION BUDGET AS OF 12/31/2023
In addition to the Capital Budget, which encompasses many large purchases and projects, the City also employs over 40 employees in multiple departments to meet the required services and other essential needs of the City of Farmersville. Most of the budget relative to the ongoing operations of the City are housed within the General Fund and the Enterprise Funds: Water Utility, Sewer Utility, and the Refuse Utility funds. Therefore, most of the discussion about progress through the year will deal with these four funds and some other minor funds, as needed
Overall, the budgets for the four main funds listed above are performing as expected half-way through the fiscal year:

GENERAL FUND BUDGET ACTUAL AS OF 12/31/2023 PERCENT DIFFERENCE REVENUES 6,512,011 2,728,770 42%
EXPENSES 6,412,998 3,218,850 50%
SURPLUS/DEFICIT 99,013 (490,080)
The table above displays a comparison between the budget and actual figures as of 12/31/2023 for the General Fund as well as a percentage difference between budget and actual by account type. At the bottom the anticipated Surplus or Deficit figure is displayed with deficits indicated negative with parenthetical marks. Please note that General Fund Capital costs are excluded from these figures because they are housed in the Capital Fund (103).

Expenses are at 50% of budget (average since 2020 is 50%) thus far through the year which is about where staff anticipates this should be. There are no outstanding or surprising trends to report that the City Council has not already been made aware of by staff previously in the year.

However, there were some expenses that need to be adjusted associated with staffing and certain one-time purchases necessary for the operation of the City and meeting strategic goals.

Those changes will be covered in Part 2 of this report.

Revenues are nearly 42% (average since 2020 is 46%) which appears slightly behind of where the General Fund normally is at this time of year. The City's Sales Tax revenues are in a trend to miss the original budget figure by about 10%. Revenue in total is tracking unfavorably by less than 10% because of other non-sales tax revenues performing as expected or slightly better.

Please recall that the City is completely dependent upon revenues from State-wide and local taxation with a smaller portion paid for by cost recovery efforts and fees. Sales Tax revenues are a huge portion of those revenues and lag by two months (about 17%) and other major revenue sources are not paid equally throughout the year.

A new "normal" is setting in now with the jump in Sales Tax revenues over the last several years from Cannabis business increases coming to an end. The cannabis industry is changing because supply has now caught up to demand, significantly lowering prices, and therefore tax revenues to the City. Future revenues are expected to be generally flat or slow growth now that the new industry has begun to normalize.

WATER UTILITY BUDGET ACTUAL AS OF 12/31/2023 PERCENT DIFFERENCE REVENUES 1,199,035 598,312 50%
EXPENSES 1,579,567 530,310 34%
SURPLUS/DEFICIT (380,532) 68,002
The table above displays a comparison between the budget and actual figures as of 12/31/2023 for the Water Utility Fund as well as a percentage difference between budget and actual by account type. At the bottom the anticipated Surplus or Deficit figure is displayed with deficits indicated negative with parenthetical marks. Please note that Water Utility Fund Capital costs are included in these figures.

Expenses are tracking at 34% (average since 2020 is 41%) thus far through the year which is about where staff anticipates this should be. One of the largest expenses of the year for the fund is the allocation of the overhead expense from the General Fund (about 17% of budget).

However, this does not occur until the end of the year. Otherwise, there are no outstanding or surprising trends to report.

Revenues are at just about 50% (average since 2020 is 47%) which is slightly ahead of where the Water Utility Fund normally is at this time of year. This is likely due to improved collections on payment plans and assistance payments made from the LIHWAP program from the State on behalf of customers who are eligible and apply for funds.

This fund is, however, anticipated to still be in an operational deficit (spending more than it earns, even without accounting for depreciation) at the end of the year. The Water Utility fund's final approved rate increase was in Fiscal Year 2022. A rate study has been completed and the City is starting a Proposition 218 compliant hearing process to increase these rates to ensure that operations and capital costs are appropriately funded.

SEWER UTILITY BUDGET ACTUAL AS OF 12/31/2023 PERCENT DIFFERENCE REVENUES 7,123,827 1,001,521 14%
EXPENSES 7,647,450 1,672,766 22%
SURPLUS/DEFICIT (523,623) 671,245)
The table above displays a comparison between the budget and actual figures as of 12/31/2023 for the Sewer Utility Fund as well as a percentage difference between budget and actual by account type. At the bottom the anticipated Surplus or Deficit figure is displayed with deficits indicated negative with parenthetical marks. Please note that Sewer Utility Fund Capital costs are included in these figures.

Expenses are tracking at 22% (average since 2020 is 40%) thus far through the year which is about where staff anticipates this should be given the large solar project that is budgeted. If the grant-funded solar project is removed, this percentage of budget climbs to 63% which is a more normal rate of spending. Otherwise, there are no outstanding or surprising trends to report that the City Council has not already been made aware of by staff previously in the year.

Revenues are at just about 14% (the average since 2020 is 64%). The fund is beginning to behave more normally (now that grant and loan activity is subsiding) and the primary expenses are only operational and debt service. If the grant-funded solar project is removed, this percentage of budget climbs to 47% which is a more normal rate of spending. Otherwise, there are no outstanding or surprising trends to report that the City Council has not already been made aware of by staff previously in the year. These rates will begin to look more like other funds do in coming years when there is less reimbursement activity throwing off the budget.

As mentioned in previous updates, there is ongoing concern about the operational expenses of this fund in the future, and these proved well founded. After careful analysis and the creation of a Revenue Stabilization Fund to maximize cash on hand to stabilize debt payments and keep rates lower for ratepayers, more changes are still needed. The Sewer Utility fund's final approved rate increase was in Fiscal Year 2017. Therefore, a rate study has been completed and the City is starting a Proposition 218 compliant hearing process to increase these rates to ensure that operations and capital costs are appropriately funded.

REFUSE UTILITY BUDGET ACTUAL AS OF 12/31/2023 PERCENT DIFFERENCE REVENUES 941,077 477,096 51%
EXPENSES 1,166,036 372,321 32%
SURPLUS/DEFICIT (224,959) 104,775
The table above displays a comparison between the budget and actual figures as of 12/31/2023 for the Refuse Utility Fund as well as a percentage difference between budget and actual by account type. At the bottom the anticipated Surplus or Deficit figure is displayed with deficits indicated negative with parenthetical marks. Please note that Refuse Utility Fund currently does not have any Capital costs to either include or exclude in these figures. The fund mostly operates as a pass-thru for the outsourced contracted waste-hauler.

Expenses are tracking nearly 32% (average since 2020 is 43%) thus far through the year which is about where staff anticipates this should be at this point in the year. Staff anticipates normal increases in this category related to the contract with the waste-hauler and other incremental increases normally associated with this type of service as discussed in previous Council meetings.

Revenues are at just about 51% (average since 2020 is 49%) which is where the Refuse Utility Fund revenue is normally this time of year. The City is in year three of five annual rate increases now. This is likely due to improved collections on payment plans and assistance payments made from the LIHWAP program from the State on behalf of customers who are eligible and apply for funds.

Overall, the Refuse Utility is functioning as it should but the approved rates will be ending in a couple years and so prudent fiscal management behooves the City to re-examine rates sooner rather than later to keep this enterprise running smoothly.

PART TWO: DESCRIPTION OF PROPOSED CHANGES

CAPITAL BUDGET - PROPOSED REVISION
7 So far this year ,, progress has been made with the Capital Budget but there are still delays that need to be dealt with. These vary from lingering "capacity" issues in some industries (mostly vehicles) as well as weather related, inflation related, and even City staff capacity (as in past years). There is not enough staff to do all these projects listed concurrently.

Therefore, what dominates the updates to the budget at mid-year this year are changes needed due to capacity to deliver projects. The City has more stait, has hired more grant managers, has more engineering staff, and yet projects are still being delayed. There are simply too many projects and so those of less priority must be delayed to ensure timely delivery of others (many times with hard deadlines associated with grant funding).

It is important to note that, as discussed earlier in this report, increasing expenses and decreasing revenues will have an impact on capital projects, not just operations. As the balance • of one-time cash diminishes, there will be less resources to tackle these projects and some may even need to be indefinitely delayed until a new funding source is secured. However, at this point in the mid-year review, this does not need to be adjusted right now. This makes more sense to make these changes with the Fiscal Year 2024-25 budget coming up soon.

There are only a few changes this year summarized in the bullet points below for what is proposed in the amendment for capital budgeted items and the Capital Improvement plan:
• Relist the ADA Sidewalk Improvement Project. Finance staff was informed that this project was going to be completed by the end of Fiscal Year 2022-23 but this didn't really get under way until the current fiscal year and should be relisted to reflect the spending that was done. This is the same budgeted amount of $250,000 and should be completed by 6/30/2024.
• Relist the Fire Department Water Tender project - some delayed expenses trickled in later than anticipated and had to be included in the current fiscal year even though most of this purchase cost was applied in Fiscal Year 2022-23. • Add Public Works Bucket Truck. This was an emergency purchase due to the sudden inability to operate the current bucket truck. Council was informed and the purchase was made timely as an emergency since there are so many public works functions dependent upon this vehicle type. The total cost is $180,736 (From ARPA funds). • Add the Sewer Plant De-Water System. The Council was also previously informed of this emergency purchase as well. This was a necessary purchase that is paid off in parts during the current fiscal year to remedy an absolute necessary flaw in the sewage treatment process. The total cost is $934,342 (from Sewer Fund balance). • Add the Police Electric Bicycle purchase needed for more flexibility in patrolling the boulevard business area as requested by City Council. This purchase is about $11,000 from the Police developer impact funds.
• Add the Police Camera Pod purchase needed for more flexibility in securing safety and deterring vandalism in the park areas of the City as previously discussed with City:

Council. This purchase is about $11,000 from the Police developer impact funds. !
8 These changes to the Capital Budget are minor compared to prior years but will most likely be overshadowed by needed changes that will take place mostly in the next fiscal year. The City will be limited by staff capacity and other hiring issues but now, more obviously impacted by lower and slower cash flows for one-time funding related to capital expenditures.

YEAR 1
CAPITAL BUDGET FOR FISCAL YEAR 2023-24 2023-24 CHANGE / UPDATE FOR MIDYEAR Code Enforcement Vehicle (Air Quality Grant) 50,000 WAITING SHIPMENT Birch Water Line Relocation 35,000 NO CHANGE
Master Plans for Sewer, Water, and Storm Drain 140,000 NO CHANGE New Water Well (ARP allocation) 822,000 PENDING GRANT AWARD City Hall Parking Lot (Phase 1) 450,000 NO CHANGE
Pavement Management Program: Street Repairs Year 1 2,700,000 NO CHANGE Pavement Management Program: Ongoing Repairs 2,000,000 NO CHANGE Solar Plant located at new WWTP 5,000,000 PENDING GRANT AWARD Highway 198 Gateway Improvements (CCLGP) 3,601,069 NO CHANGE Citrus/Road 168 Connectivity Street Project 190,000 NO CHANGE Central Fire Station 392,000 NO CHANGE
Fire Patrol Vehicle 255,000 NO CHANGE
Downtown Specific Plan 80,000 NO CHANGE
Zoning Ordinance Update 50,000 NO CHANGE
General Plan Update 175,999 NO CHANGE
Jennings Park Remodel Project 334,000 NO CHANGE
New Corporation Yard 240,000 NO CHANGE
Sports Park Rehabilitation Project 39,000 NO CHANGE
Roy's Park Improvement 96,500 NO CHANGE
Skid Steer Loader (Bobcat) 147,000 NO CHANGE
Downtown Streetlight Upgrade 40,188 NO CHANGE
Freedom Field 884,000 NO CHANGE
Booster Pump & Electrical Panel for Sports Park 180,000 NO CHANGE Liberty Park Trail Improvements 141,000 NO CHANGE
Pocket Park Improvements 150,000 NO CHANGE
Roy's Park - Phase I| 775,000 NO CHANGE
Vacuum Truck 384,500 WAITING SHIPMENT
Public Works Backhoe 172,000 NO CHANGE
Community Center Air Conditioning Units 108,475 NO CHANGE Public Works Pickup Trucks 79,969 WAITING SHIPMENT
Patrol Vehicle Replacement (FY22) 58,070 NO CHANGE
Patrol Vehicle Replacement (FY24) 11,500 NO CHANGE
Axon Fleet 3 In-Vehicle Camera System 20,241 NO CHANGE
Public Works Bucket Truck (emergency purchase) 180,736 ADD NEW PROJECT Sewer Plant De-Watering System 934,342 ADD NEW PROJECT
ADA Sidewalk Improvements 250,000 RELIST OLD PROJECT
Police Electric Bicycle 11,000 ADD NEW PROJECT
Police Camera Pod System 62,000 ADD NEW PROJECT
Fire Department - Water Tender 7,354 RELIST OLD PROJECT TOTAL 21,247,943
9 Although there were not as many changes to the projects for this year, and most are minor and most changes are merely an adjustment of when; not what, will be done. 'Ultimately, the changes increased the Capital Budget by 7.2% from $19,802,511 to $21,247,943. However, the most prominent changes are merely reflecting things that have already happened, not shifting focus or unexpected delaying of projects.

OPERATION BUDGET - PROPOSED REVISION
While capital purchases were delayed, nearly all operational budget lines are on track with where they should be at this time of year. However, not all budgets are used up in a linear fashion, and therefore not all budget lines are 50% spent halfway through the year. That said, there are several known adjustments that can be made to this budget with the understanding that this tiscal year was started with uncertainty as the base assumption..

Now that the City has weathered the first six months of the year, the fiscal outlook is more solid, and there is more information available. The revenue situation has changed slightly negative, but this does not mean that there is no uncertainty left in the future. So, while there are slight changes, any significant operational changes should be evaluated for the new fiscal year ahead (Fiscal Year 2024-2025). This process is already underway.

A full listing of the detail of the proposed changes can be found in the attached schedule, City of Farmersville Operational Budget for the Year Ending June 30, 2024. In order to streamline the process to finding all the adjustments to the budget, the following is a summary of the proposed changes for the Operation Budget:

Operation Budget Revision Summary:
• Revised Salary and Benefit Expense to actuals within General Fund (numerous changes within several departments).
-
• Revised Property Tax income from $340,000 to $355,000 • Revised Sales Tax income from $1,270,000 to $1, 100,000 • Revised VLF income from $1, 187,500 to $1,239,094
• Revised Sales Tax Add On - Measure U from $770,000 to $677,000 • Revised Sales Tax Add On - Measure P from $770,000 to $677,000 • Revised PERS UAL Payment (ADP) from $50,000 to $0 !
• Revised Administration Equipment from $5,000 to $20,000 for upgrades needed with - network and new fiber internet connection.
• Revised Administrative Overhead Insurance cost from $478,886 to $438,295 to match actuals.
• Revised Police Professional Expense from $235,000 to $285,000 to offset ongoing legal fees. :
• Created Revenue and Expense lines for Patrol replacement of total loss vehicles and insurance reimbursements. Expense is $144,859 and Revenue is $126,385. The uncovered expense of $18,474 will be covered by contingency funds. • Revised Animal Control professional expense to project increased costs from proposed new contract language with Visalia.
• Revised Gas Tax Revenue from $111,560 to $91,416

10. • Revised Gas Tax Revenue from $73,080 to $63,213
• Revised Gas Tax Revenue from $43,529 to $38,966
• Revised Gas Tax Revenue from $99,839 to $86,340
• Revised RMRA income from $256,695 to $248,610
Some of the most important changes listed above include an adjustment to the revenue projections of main tax sources up to match growth trends so far this year. Additionally, an adjustment to the revenue projections for Gas Tax and RMRA (SB1) to fund the City's Street repairs and improvements. Finally, some operational expenses changed based on actually incurred expenditures to date and reflecting staff changes to actual costs.

The table below tracks the changes to the budget for the General Fund from the original budget in June 2023 to the proposed budget amendment at mid-year (this report).

Fund Dept Original Budget Revised Budget Amount Percent 1: General Fund 400: Revenues (5,409,846) (5,120,440) 289,406.00 -5.3% 1: General Fund 401: City Council 29,648 29,648 0.0%
1: General Fund 404: Administration 413,583 389,790 (23,793.00) -5.8% 1: General Fund 405: Membership Legislation 16,000 16,000 0.0% 1: General Fund 406: Administrative Overhead 378,861 338,270 (40,591.00) -10.7% 1: General Fund 407: City Sponsorships 12,000 12,000 0.0% 1: General Fund 411: Police 2,382,855 2,384,812 1,957.00 0.1% 1: General Fund 414: Community Development 468,089 468,995 906.00 0.2% 1: General Fund 415: Code Enforcement 130,119 122,055 (8,064.00) -6.2% 1: General Fund 420: Fire 824,665 834,481 9,816.00 1.2% 1: General Fund 425: Public Works 559,387 559,307 (80.00) 0.0% 1: General Fund 426: Animal Control 95,625 142,382 46,757.00 48.9%, Total Revenues (6,512,011) (6,348,990) 97.5%
Total Expenses 6,412,998 6,526,291 101.8%
Net (99,013) 177,301

CONCLUSION AND RECOMMENDATION
After careful consideration of many variables that have impacted the budget this far through the transitional year, and anticipating changes in the next six months, staff recommends that the changes, described in this report, and laid out in the attached journal document, be adopted to amend the FY 2024 budget by Resolution 2024-007. This resolution adoption will enact both the Capital Budget changes and the Operation Budget changes.

The key take-aways from this year's mid-year analysis are:
• The revised budget is a structural deficit but the small percentage may be made up by year end by underspending or delaying costs in combination with salary savings. If not, the fund balance will likely be able to cover this amount temporarily. • General Fund Revenues continue to level off or decline without changes to the tax rate or tax base.
11 • General Costs continue to increase and service levels may suffer as a result. • Some capital expenditures may be delayed.
• Most of the painful adjustments for revenue declines are likely to be delayed until Fiscal Year 2024-25 when the budget will be looked at in total and more thoroughly with new requests from the departments for funding allocations. :
• The future revenue of the City is still uncertain, so prioritizing expenses will be essential to good budgetary management.
• PART THREE: FINANCIAL HEALTH CONTEXT FOR THE BUDGET
The City was recently informed that the California State Auditor had stopped producing the Local Government High-Risk Dashboard. It isn't clear why this valuable comparison tool is no longer being supported, or why the historical information can't be viewed either. Without this tool, it will be much more difficult to assess the health of Farmersville in context. However, it is important to note that as of the last reading (Fiscal Year 2022 audited financial statements) the City was in a healthy rating, the highest in the County in fact.

The City anticipates that it's score for Fiscal Year 2023 (and likely Fiscal Year 2024) would show our rating slipping some it would still rank positively in general. The City is aware that the revenue trends of the city are now not positive and yet the debt burden remains. Additionally, with declining revenues, less work can be done to prepay pension debt and that would also likely impact the overall score by the Auditor's dashboard would it still be operating.

The City still has a Strategic Goal of Financial Sustainability to meet without this tool or with it.

Budgeting appropriately and accounting for our transactions transparently aré essential to good financial health. Essentially, good budgets beget good audits, and good audits beget good budgets.

We know that the City of Farmersville was ranked 356 out of 471 (2018: 388, 2019: 370, 2020:
316) for risk (the higher number, the lower the risk) and is still considered the lowest risk City in all of Tulare County as of the last reporting by the State Auditor and this was determined with a specific scoring by the State
As indicated in the table below, the State Auditor values General Fund Reserves (30%), Deb Burden (15%), Liquidity (10%), Pension Obligations (10%), and OPEB Obligations (10%) wit the greatest impact on risk for a City
12 Farmersville
san Jose Low
California
Statewide Rank: 316;
General Fund Reserves
Debt Burden
Liquidity
Revenue Trends
Fresno
Pension Obligations
Pension Funding
Pension Costs
Future Pension Costs
OPEB Obligations
OPEB Funding
King City
Porterville
While the City did well overall (top 1/4 of all cities), it scored in only the 36th position for Debt Burden getting a score of only 6.5 out of 15 points. The auditor's website states the concern, "This city's long-term debts equate to 122 percent of the city's total government revenues, which may be too high for the city to pay back its debts without significant financial strain. In order to be low risk for debt burden, a city's debt should ideally not exceed 40 percent of total government revenue." While the debt situation is improving, it is still significant and is a risk.

However, all other scores are not only very high comparatively but have consistently improved over the years.

California State Auditor's Local Government High-Risk Rating Financial Indicators (2021) Points Possible Farmersville Score Farmersville Rank Liquidity 10 10 57
Debt Burden 15 6.5 36
General Fund Reserves 30 30 276
Revenue Trends 5 5 416
Pension Obligations 10 10 332
Pension Funding 5 4.85 349
Pension Costs 5 4.17 316
Future Pension Costs 5 4.17 366
OPE Obligations 10 n/a
OPE Funding 5 5 n/a
Total 100 89.69 356
This is why the enactment of the minimum fund balance and budgetary uncertainty fund policy and the establishment of a larger reserve in general in 2019 was so important. While the City 13 has incurred much more debt since 2018, it has also professionalized its reserve practices and policy and eliminated other obligations when possible (specifically pension debt).

Clearly, based upon this evaluation criteria, the priorities that the State thinks should be applied to our budget are:

1. To fully fund and expand the General Fund and Enterprise reserves even more.

2. To pre-pay debt in all funds, if possible

3. To reduce pension obligations of all kinds

4. To ensure that the City does not incur OPEB obligations (currently none).

These scores point to Farmersville's strengths of good budgeting, avoiding and/or eliminating debt, maintaining reserves, and living within its means by not over-extending departments or programs or incurring excessive debt.

Historically, Farmersville has done well to adhere to the spending allowed in its budgets as indicated in the following chart showing spending consistently within budget each year.

Recently years don't look as good, but there were years of planned spending from fund balance that will throw off these stats slightly.

General Fund Expense - Budget vs. Actual
7,088,316 7,094,044 6,840,580
6,231,550 6,412,998
4,311,946 4,904,262 4,882,533
3,634,112 3,482,261 4,129,627 4,001,903 3,684,145
2018 2019 2020 2021 2022 2023 2024
• Budget i Actuall
The City has also done well projecting revenue conservatively to not overextend and deplete reserves or incur debt unnecessarily. However, recently years have been more challenging as the massive spike in sales tax revenues from cannabis businesses has dropped dramatically due to lower prices industry-wide.
14 General Fund Revenue - Budget vs. Actual
5,960,252 6,419,828 6,422,741 6,231,055
4,372,231 4,904,262

4.059.821 4,047,420 4.233,672
2018 2019 2020 2021 2022 2023 2024
• Budget • Actual
As a whole, this improves the financial health of the City and puts the City Council and Management in a good position to not have to make budget cuts for lack of cash but rather to make decisions on how to allocate additions cash on hand to current priorities. However, the future is not known and the potential dip or leveling off of revenue amounts in the future is still unknown.

General Fund Revenue & Expense Actuals (and FY 2024 Budget)

7.194.044 6.422.741 6.840,580 6,412,998 6,512,011
5,960,252 6.231.055
4,129,62; 4,233,672 4,882.533
3,482,261 3,537,333 4,059,821 3,684,145
2018 2019 2020 2021 2022 2023 2024
• Expense Revenue • Linear (Expense)
The cash positions of the various funds, while not explicitly relevant because they are not always dollar amounts that are budgeted each year, they are relevant to some degree to show a portion of the financial picture for the City. Cash balances are most relevant to Capital Budgets 15 :
as ongoing operations, salaries, and benefits should not be supported by cash reserves, but only by ongoing cash flows.

General Fund Health and Cash Balances
Cash Positions relative to the General Fund (01), the General Fund Reserve (102), and the General Fund Capital Fund (103) are listed below with a combined total and percent change from year to year.

Positive cash balances in the General Fund (01) are presumed to be spent by year-end or allocated as carryover in the following period and so are generally not available except through the budget. Cash balances are very fluid and fluctuate regularly throughout the fiscal year.

Year-end figures and mid-year figures are typically the highest balances throughout the year as they coincide with regular, large revenue receipts.

The City is complying with the Minimum Fund Balance Policy by reserving at least $1,400,332 (25% of average 3 prior year tax revenues) in the General Fund Reserve Fund (102). Funds above the reserye minimum amount are committed for other one-time uses such as funding the Capital Budget or other unexpected expenses or revenue shortfalls.

However, the City, while making progress in the last few years, has still not fully-funded its Budgetary Uncertainty Fund. By policy, this is to be 15% of the average 3 prior year tax revenues. However, this is only about 80% at this time with $801,000.

Staff also anticipates the reserve requirement to increase in coming years due to the increases in revenue recently and this cash will be needed to comply with the Minimum Fund Balance Policy.

The cash balance in the Capital Fund (103) are budgeted amounts and only allocated to the fund when budgeted as transfers from other funds.

As context to this analysis, the entirety of the cash balances of all the relevant funds of the City are listed below. The lines are color-coded to show their affiliation with other funds and/or restrictions on spending: blue for water utility, yellow for sewer utility, green for refuse utility, red for restricted/special revenue funds, and white for unrestricted (General Fund). --_..
16 ENDING CASH POSITIONS OF CITY OF FARMERSVILLE FUNDS FY 2021 TO FY 2024 ACCOUNT 6/30/2021 6/30/2022 12/31/2022 6/30/2023 12/31/2023 01 GENERAL FUND 1,347,524.58 641,284.08 (382,270.39) 201,839.91 (61,412.72) 08 SELF INSURED RESERVES 551,000.00 801,000.00 801,000.00 801,000.00 801,000.00 60 AMERICAN RESCUE PLAN (ARPA) 1,176,000.79 2,299,954.43 2,214,152.53 2,100,849.52 102 GENERAL FUND RESERVE 1,439,868.82 1,439,868.82 1,439,868.82 1,439,868.82 1,439,868.82 103 GENERAL FUND CAPITAL (213,482.61) (460.92) (238,562.96) 104 MEASURE Q (CANNABIS) 1,065,025.91 1,462,839.03 2,063,006.75 1,477,750.66 1,889,989.39 General Government Total 4,403,419.31 5,520,992.72 6,008,077.00 6,134,151.00 5,931,732.05 02 WATER UTILITY 1,070,986.34 1,171,847.36 1,377,826.02 1,297,051.40 1,255,911.25 04 SEWER UTILITY 5,568,637.98 5,752,974.77 5,729,749.43 5,452,795.10 2,944,760.26 54 SEWER REVENUE STABILIZATION 1,500,000.00
06 REFUSE UTILITY 372,826.47 379,402.93 473,578.85 445,361.91 498,967.53 09 CUSTOMER DEPOSITS 13,948.70 16,401.63 20,101.63 24,922.63 27,662.63 Utilities Total 7,026,399.49 7,320,626.69 7,601,255.93 7,220,131.04 6,227,301.67 12 FEDERAL AND STATE GRANTS (426,346.07) (257,554.87) (491,585.39) (700,268.42) (231,853.88) 50 CHILDCARE FUND
Pass Through Grants Total (426,346.07) (257,554.87) (491,585.39) (700,268.42) (231,853.88) 10 POLICE DEPT SLESE
11 DRUG ENFORCEMENT 17,044.00 17,155.46 16,467.51 17,448.90 14,835.58 14 POLICE DEPT SLESF 230,772.30 186,768.58 168,573.10 165,080.64 178,860.14 15 POLICE DEPT AB 109
80 EVIDENCE HOLDING 17,779.85 17,779.85 20,779.85 20,779.85 20,779.85 82 ASSET FORFEITURES 2,297.03 2,312.05 3,011.68
83 LIVE SCAN (4,319.00) (4,493.00
Law Enforcement Total 263,574.18 219,522.94 205,820.46 206,321.07 214,475.57 72 FIRE ASSET REPLACEMENT (21,354.76) 7,014,123.75 7,014,232.21 Fire Department Total (21,354.76) 7,014,123.75 7,014,232.21 03 WATER DEVELOPMENT 387,002.19 292,154.94 305,140.40 376,097.80 380,710.30 05 SEWER DEVELOPMENT 1,025,088.79 806,463.75 829,445.82 953,527.02 955,653.52 23 STORM DRAIN DEVELOPMENT 154,642.98 8,317.38 15,051.38 59,702.12 66,231.12 30 PARK DEVELOPMENT 18,991.55 21,050.61 24,442.47 38,856.98 48,095.63 61 CIRCULATION DEVELOPMENT 249.59 767.46 7,746.83
62 GOV FACILITIES DEVELOPMENT 760.28 3,773.30
63 LIBRARY DEVELOPMENT 14.45 44.43 109.29
64 COMM FACILITIES DEVELOPMENT 782.92 2,407.40 5,921.83 71 FIRE DEVELOPMENT 157,505.52 160,799.41 103,427.09 183,911.36 186,635.00 81 POLICE DEVELOPMENT 14,191.96 25,671.38 8,513.54 68,984.81 78,242.46 Developer Impact Fees Total 1,757,422.99 1,314,457.47 1,287,067.66 1,685,059.66 1,733,119.28 20 STP 90,021.87 845,348.62 845,348.62 859,943.61 859,943.61 21 GAS TAX 373,625.71 263,225.80 248,057.44 240,534.77 227,038.33 22 TDA / LTF 1,612,361.48 1,750,797.81 2,268,556.96 2,105,900.50 394,256.55 25 STREET MITIGATION
26 MEASURE R 1,338,077.96 (516,605.77) 1,700,174.82 2,574,894.77 2,737,332.13 27 RMRA (SB1) 226,402.86 339,013.65 459,720.83 586,566.82 Streets & Transportation Total 3,414,087.02 2,569,169.32 5,401,151.49 6,240,994.48 4,805,137.44 31 PARK IMPROVEMENTS 198,671.19 (1,109,769.63) (1,291,007.14) (2,302,225.10) 35 MAINTENCE DISTRICTS (7,250.92) 14,933.51
39 CITY PROPERTIES 85,583.14 86,933.37 101,810.12
Maintenance Total (45,288.55) 273,521.76 (1,030,949.72) (1,203,460.88) (2,185,481.47) 40 CDBG PROGRAM INCOME 56,606.86 328,730.77 358,321.77 435,500.61 458,070.61 41 HOME PROGRAM INCOME 66,758.58 22,802.70 88,152.70 188,526.09 206,621.09 42 CAL HOME PROGRAM INCOME 259,211.14 215,378.99 81,895.99 (159.47) 540.53 Housing Total 382,576.58 566,912.46 528,370.46 623,867.23 665,232.23 TOTAL 16,775,844.95 17,527,648.49 19,509,207.89 27,220,918.93 24,173,895.10 17 RESOLUTION 2024-007

A RESOLUTION OF THE COUNCIL OF THE CITY OF FARMERSVILLE

APPROVING AND ADOPTING THE FIRST BUDGET AMENDMENT
FOR FISCAL YEAR 2023-24
WHEREAS, the adopted budget for Fiscal Year 2023-24 was approved by the City Council on June 12, 2023 by Resolution 2023-17; and
WHEREAS, the City Council has received and reviewed the mid-year review staff report and proposed budgetary amendment on February 26, 2024; and WHEREAS, the City Council has considered the recommended amendment to the •budget presented in the attached staff report;
:

NOW, THEREFORE, BE IT RESOLVED, the Farmersville City Council hereby makes the budget amendment for Fiscal Year 2023-24, as attached hereto as the supporting staff report, regarding the revenues and expenditures are hereby approved and adopted effective The foregoing resolution was adopted upon motion of Council Member • and Council Member. seconded the motion at a regular meeting of the City Council held on the 26th day of February, 2024, by the following roll call vote:

AYES:

NOES:

ABSTAIN:

ABSENT:
- Tina Hernandez, Mayor
WITNESS my hand and seal this 26th day of February, 2024.

Rochelle Giovani, City Clerk
•

CITY OF

FARMERSVILLE
2023-2024 2023-2024

BUDGET PROPOSED AMENDMENT
01 GENERAL FUND
400 GENERAL REVENUES
01-400-400-4001 - PROPERTY TAX (340,000) (355,000)
01-400-400-4002 - SALES TAX (54058) (1,270,000) (1,100,000) 01-400-400-4005 - PROPERTY TAX - VLF (1,187,500) (1,239,094) 01-400-400-4105 - SALES TAX - ADD ON (121) (770,000) (677,000) 01-400-400-4109 - SALES TAX - ADD ON (628) (770,000) (677,000) 401 CITY COUNCIL
01-401-300-5101 - SALARIES 14,400
01-401-300-5205 - PROFESSIONAL & CONTRACTUAL SRV 11,400 404 ADMINISTRATION
01 -404-400-5101 - SALARIES 243,146 246,328
01 -404-400-5110 - FICA 15,131 15,328
01 -404-400-5111 - MEDICARE 3,539 3,585
01-404-400-5112 - PERS RETIREMENT 20,754 21,057
01-404-400-5119 - DEFERRED COMP 8,408 9,686
01-404-400-5122 - PERS UAL PAYMENT 6,201
01-404-400-5122 -ADP PERS UAL PAYMENT 50,000
01 -404-400-5504 - EQUIPMENT 5,000 20,000
406 ADMINISTRATIVE OVERHEAD
01-406-400-5207 - INSURANCE 478,886 438,295
411 POLICE
01-411-000-4081 -PTROL VEHICLES (REPLACEMENT) (126,385) 01 -411-100-5101 - SALARIES 1,356,167 1,275,139
01-411-100-5110 - FICA 85,054 80,031
01-411-100-5111 - MEDICARE 19,892 18,717
01 -411-100-5112 - PERS RETIREMENT 155,174 146,379
01 -411-100-5116 - LTD/LIFE INSURANCE 11,250 10,949
01-411-100-5119 - DEFERRED COMP 32,126 29,637
01 -411-100-5122 - PERS UAL PAYMENT 32,295
01-411-100-5205 - PROFESSIONAL & CONTRACTUAL SRV 235,000 285,000 1 CITY OF
FARMERSVILLE 2023-2024 2023-2024

BUDGET PROPOSED AMENDMENT

ONEND TAS INCORPON Y
01-411-000-5514 -PTROL VEHICLES (REPLACEMENT) 144,859
414 COMMUNITY DEVELOPMENT
01-414-800-5101 - SALARIES
34,196
01-414-800-5110 - FICA 2,134
01 -414-800-5111 - MEDICARE 499
01-414-800-5116 - LTD/LIFE INSURANCE 347
01-414-800-5119 - DEFERRED COMP 1,026
01 -414-800-5122 - PERS UAL PAYMENT 725
415 CODE ENFORCEMENT
01-415-800-5101 - SALARIES 54,238
01-415-800-5110 - FICA 3,417
01-415-800-5111 - MEDICARE 799
01-415-800-5112 - PERS RETIREMENT 3,970
01-415-800-5116 - LTD/LIFE INSURANCE 645 577
01-415-800-5122 - PERS UAL PAYMENT 1,329
420 FIRE DEPARTMENT
01-420-100-5101 - SALARIES 310,813 313,867
01-420-100-5110 - FICA 19,513 19,703
01-420-100-5111 - MEDICARE 4,564 4,608
01 -420-100-5116 - LTD/LIFE INSURANCE 2,778 2,802
01 -420-100-5119 - DEFERRED COMP 4,896
4,942
01 -420-100 -5122 - PERS UAL PAYMENT 6,457
425 PARKS, BUILDINGS & GROUNDS
01 -425-600-5101 - SALARIES 153,931 150,730
01 -425-600-5110 - FICA 9,713 9,514
01 -425-600-5111 - MEDICARE 2,272 2,225
01 -425-600-5112 - PERS RETIREMENT 12,634 12,402
01 -425-600-5116 - LTD/LIFE INSURANCE 1,532 1,505
01 -425-600-5119 - DEFERRED COMP 5,041
5,137
01 -425-600-5122 - PERS UAL PAYMENT 3,720
2 CITY OF
FARMERSVILLE 2023-2024 2023-2024

BUDGET PROPOSED AMENDMENT
426 ANIMAL CONTROL
01-426-100-5205 - PROFESSIONAL & CONTRACTUAL SRV 96,025 142,782 103 GENERAL FUND CAPITAL
103-425-000-5205 -ADAX PROFESSIONAL & CONTRACTUAL SRV 250,000 02 WATER UTILITY
02 -404-000 -5101 - SALARIES 243,437 246,700
02 -404-000-5110 - FICA 15,158 15,361
02 -404-000-5111 - MEDICARE 3,545 3,592
02 -404-000-5112 - PERS RETIREMENT 21,038 21,341
02 -404-000-5116 - LTD/LIFE INSURANCE 1,754
02-404-000-5119 - DEFERRED COMP 8,258 9,538
02 -404-000-5122 - PERS UAL PAYMENT 6,284
02 -415-000-5101 - SALARIES 24,959 21,695
02 -415-000-5110 - FICA 1,569 1,367
02 -415-000-5111 - MEDICARE 367 320
02 -415-000-5112 - PERS RETIREMENT 1,805 1,588
02 -415-000-5116 - LTD/LIFE INSURANCE 258 231
02 -415-000-5122 - PERS UAL PAYMENT 532
02 -425-00 -5101 - SALARIES 151,137 144,572
02-425-00 -5110 - FICA 9,533 9,126
02-425-00 -5111 - MEDICARE 2,230 2,134
02 -425-00 -5112 - PERS RETIREMENT 12,194 11,720
02 -425-00 -5116 - LTD/LIFE INSURANCE 1,496 1,441
02 -425-00 -5119 DEFERRED COMP 5,053 4,856
02 -425-00 -5122 - PERS UAL PAYMENT 3,591
04 SEWER UTILITY
04 -404-000-5101 - SALARIES 229,356 232,619
04 -404-000-5110 - FICA 14,283 14,485
04 -404-000-5111 - MEDICARE 3,340 3,388
04 -404-000-5112 - PERS RETIREMENT 19,754 20,056
04-404-000-5116 - LTD/LIFE INSURANCE 1,674 1,674
04-404-000-5119 - DEFERRED COMP 7,676 8,957
3 CITY OF
FARMERSVILLE 2023-2024 2023-2024
ОБИВ ТВАВ INONYORID BUDGET PROPOSED AMENDMENT
04 -404-000-5122 - PERS UAL PAYMENT 5,906
04-415-000-5101 - SALARIES 24,959 21,695
04-415-000-5110 - FICA 1,569 1,367
04 -415-000-5111 - MEDICARE 367 320
04 -415-000-5112 - PERS RETIREMENT 1,805 1,588
04 -415-000-5116 - LTD/LIFE INSURANCE 258 231
04 -415-000-5122 - PERS UAL PAYMENT 532
04 -425-00 -5101 - SALARIES 139,095
04 -425-00 -5110 - FICA 8,780
04 -425-00 -5111 - MEDICARE 2,053
04 -425-00 -5112 - PERS RETIREMENT 11,223
04-425-00-5116 - LTD/LIFE INSURANCE 1,383
04 -425-00 -5119 - DEFERRED COMP 4,692
04-425-00 -5122 - PERS UAL PAYMENT 3,445
04-425-00 -5504 -SLDGE EQUIPMENT 934,342
06 REFUSE
06-404-000-5122 - PERS UAL PAYMENT 1,178
06-415-000-5101 - SALARIES 12,480 10,848
06 -415-000-5110 - FICA 785 683
06-415-000-5111 - MEDICARE 184 160
06 -415-000-5112 - PERS RETIREMENT 902 794
06 -415-000-5116 - LTD/LIFE INSURANCE 129 115
06-415-000-5122 - PERS UAL PAYMENT 266
06 -425-00 -5122 - PERS UAL PAYMENT : 512
14 POLICE SLESF
14 -411-00 -5101 -SLESF SALARIES 127,610 130,685
14-411-00 -5110 -SLESF FICA 8,033 8,224
14-411-00 -5111 -SLESF MEDICARE 1,879 1,923
14 -411-00 -5116 -SLESF LTD/LIFE INSURANCE 1,287
1,263
14 -411-00 -5122 - PERS UAL PAYMENT 2,718
21 GAS TAX
21 -404-000-5101 - SALARIES 18,646 19,706
4 CITY OF
FARMERSVILLE 2023-2024 2023-2024

BUDGET PROPOSED AMENDMENT
21 -404-000-5110 - FICA 1,159 1,224
21 -404-000-5111 - MEDICARE 271 286
21 -404-000-5112 - PERS RETIREMENT 1,759 1,860
21 -404-000-5119 - DEFERRED COMP 559 985
21 -404-000-5122 - PERS UAL PAYMENT 548
21 -425-00 -5101 - SALARIES 115,120 108,377
21 -425-00 -5110 - FICA 7,272 6,853
21 -425-00 -5111 - MEDICARE 1,701 1,603
21 -425-00 -5112 - PERS RETIREMENT 9,055 8,568
21 -425-00 -5116 - LTD/LIFE INSURANCE 1,140 1,084
21 -425-00 -5119 - DEFERRED COMP 3,973 3,770
21 -425-00 -5122 - PERS UAL PAYMENT 2,667
21 -425-000 -4035 - STATE GAS TAX 2103 (111,560) (91,416) 21-425-000 -4036 - STATE GAS TAX 2105 (73,080) (63,213) 21 -425-000 -4037 - STATE GAS TAX 2106 (43,529) (38,966) 21 -425-000-4038 - STATE GAS TAX 2107 (99,839)
(86,340)
27 ROAD MAINTENANCE & REHAB (SB1)
27 -425-000-4081 - STATE GRANT (256,695) (248,610)
35 MAINTENANCE DISTRICTS
35-425-00 -5122 - PERS UAL PAYMENT 250
60 AMERICAN RESCUE PLAN (ARPA)
60 -420-000 -5504 -TENDR CONSTRUCTION IN PROCESS 7,354
60-425-00 -5514 VEHICLES 180,736
60-425-000-5504 - EQUIPMENT 240,000
60 -425-000 -5504 -PWYRD EQUIPMENT 240,000
81 POLICE DEVELOPMENT
81 -411-000-5504 - EQUIPMENT 73,000
5 FISCAL YEAR 2023-24 MID-YEAR

BUDGET UPDATE
City of Farmersville - 2/26/2024
Table of Contents
-
1 2 3 4
Introduction & Part One: Current Part Two: Part Three: Financial Purpose (p.1) Year Progress (p.3) Description of Health Context for • Capital Budget Proposed Changes the Budget (p.15)
• Operation Budget (p.7) • Risk Factors
• Capital Budget • Cash Balances
• Operation Budget
- PREVIOUS BUDGET - CHANGES WERE OCCURRING

AMENDMENT THAT NEEDED TO BE

ADDRESSED BUT NO FORMAL

BUDGET AMENDMENT
• Previous years usually had at least

BROUGHT TO COUNCIL SO FAR
one amendment prior to the mid-
year analysis. THIS YEAR.
= PART ONE:

CURRENT YEAR

PROGRESS
What has happened in the first half of the year?
— Capital Budget as of 12/31/23
Started the year with a Capital Budget of about $19.8 million (p.3) YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5
SUMMARY OF CAPITAL IMPROVEMENT PLAN 2023-24 2024-25 2025-26 2026-27 2027-28 TOTAL Administration 43,500 43,500
Code Enforcement 50,000 50,000
Engineering 14,938,069 2,436,692 7,531,624 2,327,500 2,842,500 30,076,385 Fire 647,000 6,500,000 660,000 7,807,000
Planning 305,999 129,525 435,524
Police 89,811 168,612 183,542 197,542
172,042 811,549
Public Works 3,771,622 982,500 878,500 500,000 1,045,000 7,177,632 TOTAL 19,802,511 10,217,329 8,593,666 3,043,042 4,745,042 46,401,590 _ Capital Budget Continued
7 More Will be
33 Capital Budget
3 are Complete Complete by
Items
6/30/2024
30% of Budget
Total Estimated
Items Anticipated
to be Completed Spending:

This Year $5,000,000
YEAR 1 YTD SPENT PERCENT OF
CAPITAL BUDGET FOR FISCAL YEAR 2023-24 2023-24 2023-24: BUDGET CURRENT STATUS Code Enforcement Vehicle (Air Quality Grant) 50,000 0.0% COMPLETE BY 6/30 Birch Water Line Relocation 35,000 3,150 9.0% IN PROGRESS Master Plans for Sewer, Water, and Storm Drain 140,000 0.0% IN PROGRESS New Water Well (ARP allocation) 822,000. 0.0% DELAYED TO FY25 City Hall Parking Lot (Phase 1) 450,000 1,233 0.3% IN PROGRESS Pavement Management Program: Street Repairs Year 1 2,700,000 2,377,462 88.1% COMPLETE BY 6/30 Pavement Management Program: Ongoing Repairs 2,000,000 0.0% IN PROGRESS Solar Plant located at new WWTP 5,000,000 0.0% DELAYED TO FY25 Highway 198 Gateway Improvements (CCLGP) 3,601,069 207,475 5.8% IN PROGRESS Citrus/Road 168 Connectivity Street Project 190,000 0.0% IN PROGRESS Central Fire Station 392,000 2,550 0.7% IN PROGRESS
Fire Patrol Vehicle 255,000 86,567 33.9% IN PROGRESS
Downtown Specific Plan 80,000 39,069 48.8% COMPLETE BY 6/30 Zoning Ordinance Update 50,000 38,938 77.9% COMPLETE BY 6/30 General Plan Update 175,999 12,750 7.2% IN PROGRESS
Jennings Park Remodel Project 334,000 0.0% IN PROGRESS
New Corporation Yard 240,000 20,185 8.4% IN PROGRESS
Sports Park Rehabilitation Project 39,000 0.0% IN PROGRESS Roy's Park Improvement 96,500 79,706 82.6% IN PROGRESS
Skid Steer Loader (Bobcat) 147,000 117,190 79.7% COMPLETED Downtown Streetlight Upgrade 40,188 0.0% IN PROGRESS
Freedom Field 884,000 843,125 95.4% COMPLETE BY 6/30
Booster Pump & Electrical Panel for Sports Park 180,000 17,515 9.7% IN PROGRESS Liberty Park Trail Improvements 141,000 0.0% IN PROGRESS Pocket Park Improvements 150,000 0.0% IN PROGRESS
Roy's Park - Phase II 775,000 528,006 68.1% IN PROGRESS Vacuum Truck 384,500 0.0% COMPLETE BY 6/30
Public Works Backhoe 172,000 139,635 81.2% COMPLETED
Community Center Air Conditioning Units 108,475 105,725 97.5% COMPLETED Public Works Pickup Trucks 79,969 0.0% COMPLETE BY 6/30 Patrol Vehicle Replacement (FY22) 58,070 43,553
150% IN PROGRESS
Patrol Vehicle Replacement (FY24) 11,500
Axon Fleet 3 In-Vehicle Camera System 20,241 0.0% IN PROGRESS TOTAL 19,802,511 4,663,832.97 23.6%
— Operation Budget as of 12/31/23
- Mid-Year Review of Operations Begins on Page 4:

1. General Fund

2. Water Utility Fund

3. Sewer Utility Fund

4. Refuse Utility Fund

GENERAL FUND

BUDGET TO ACTUAL
Capital Costs are Excluded
Revenues are 42% this year
(45% last year) GENERAL FUND BUDGET ACTUAL AS OF 12/31/2023 PERCENT DIFFERENCE REVENUES 6,512,011 2,728,770 42%
Expenses are 54% this year EXPENSES 6,412,998 3,218,850 50% (55% last year) SURPLUS/DEFICIT 99,013 (490,080)
Located on Page 5

WATER UTILITY
FUND

BUDGET TO ACTUAL
Capital Costs are Included
Revenues are 53% this year
(52% last year) WATER UTILITY BUDGET ACTUAL AS OF 12/31/2023 PERCENT DIFFERENCE REVENUES 1,199,035 598,312 50%
Expenses are 32% this year EXPENSES 1,579,567 530,310 34% (45% last year) SURPLUS/DEFICIT (380,532) 68,002
Located on Page 5

SEWER UTILITY
FUND

BUDGET TO ACTUAL
Capital Costs are Included
Revenues are 50% this year
(86% last year) SEWER UTILITY BUDGET ACTUAL AS OF 12/31/2023 PERCENT DIFFERENCE REVENUES 7,123,827 1,001,521
Expenses are 30% this year EXPENSES 7,647,450 1,672,766 22% (72% last year) SURPLUS/DEFICIT (523,623) (671,245)
Located on Page 6

REFUSE UTILITY
FUND

BUDGET TO ACTUAL
Capital Costs are not applicable
Revenues are 50% this year
(50% last year) REFUSE UTILITY BUDGET ACTUAL AS OF 12/31/2023 PERCENT DIFFERENCE REVENUES 941,077 477,096
Expenses are 42% this year EXPENSES 1,166,036 372,321 32% (51% last year) SURPLUS/DEFICIT (224,959) 104,775
Located on Page 7
PART TWO:

DESCRIPTION OF

PROPOSED CHANGES
What needs to be changed and why?
YEAR 1
CAPITAL BUDGET FOR FISCAL YEAR 2023-24 2023-24 CHANGE / UPDATE FOR MIDYEAR Code Enforcement Vehicle (Air Quality Grant) 50,000 WAITING SHIPMENT Birch Water Line Relocation 35,000 NO CHANGE
Master Plans for Sewer, Water, and Storm Drain 140,000 NO CHANGE New Water Well (ARP allocation) 822,000 PENDING GRANT AWARD City Hall Parking Lot (Phase 1) 450,000 NO CHANGE
Capital Budget Pavement Management Program: Street Repairs Year 1 2,700,000 NO CHANGE Pavement Management Program: Ongoing Repairs 2,000,000 NO CHANGE Proposed Revision Solar Plant located at new WWTP 5,000,000 PENDING GRANT AWARD Highway 198 Gateway Improvements (CCLGP) 3,601,069 NO CHANGE Citrus/Road 168 Connectivity Street Project 190,000 NO CHANGE Central Fire Station 392,000 NO CHANGE
Fire Patrol Vehicle 255,000 NO CHANGE
- Many Changes: Downtown Specific Plan 80,000 NO CHANGE Zoning Ordinance Update 50,000 NO CHANGE
• Timing General Plan Update 175,999 NO CHANGE
Jennings Park Remodel Project 334,000 NO CHANGE
New Corporation Yard 240,000 NO CHANGE
• Capacity
Sports Park Rehabilitation Project 39,000 NO CHANGE
Roy's Park Improvement 96,500 NO CHANGE
• Scope Skid Steer Loader (Bobcat) 147,000 NO CHANGE
Downtown Streetlight Upgrade 40,188 NO CHANGE
Freedom Field 884,000 NO CHANGE
- Pages 7-11 Booster Pump & Electrical Panel for Sports Park 180,000 NO CHANGE Liberty Park Trail Improvements 141,000 NO CHANGE
Pocket Park Improvements 150,000 NO CHANGE
Roy's Park - Phase II 775,000 NO CHANGE
Vacuum Truck 384,500 WAITING SHIPMENT
Public Works Backhoe 172,000 NO CHANGE
Community Center Air Conditioning Units 108,475 NO CHANGE Public Works Pickup Trucks 79,969 WAITING SHIPMENT
Patrol Vehicle Replacement (FY22) 58,070 NO CHANGE
Patrol Vehicle Replacement (FY24) 11,500 NO CHANGE
Axon Fleet 3 In-Vehicle Camera System 20,241 NO CHANGE
Public Works Bucket Truck (emergency purchase) 180,736 ADD NEW PROJECT Sewer Plant De-Watering System 934,342 ADD NEW PROJECT
ADA Sidewalk Improvements 250,000 RELIST OLD PROJECT
Police Electric Bicycle 11,000 ADD NEW PROJECT
Police Camera Pod System 62,000 ADD NEW PROJECT
Fire Department - Water Tender 7,354 RELIST OLD PROJECT TOTAL 21,247,943
— Operation Budget Changes
•
Tax Revenues Service Costs City Staffing
Sales Tax & Animal Control, Street Position Turnover,
Other Revenues Repairs, Transit Costs, Normal Benefit Changes, and Operations
Negative Trend Pension Costs Increasing
Fund Dept Original Budget Revised Budget Amount Percent 1: General Fund 400: Revenues (5,409,846) (5,120,440) 289,406.00 -5.3% 1: General Fund 401: City Council 29,648 29,648 0.0%
Summary of
1: General Fund 404: Administration 413,583 389,790 (23,793.00) -5.8% 1: General Fund 405: Membership Legislation 16,000 16,000 0.0% Budget 1: General Fund 406: Administrative Overhead 378,861 338,270 (40,591.00) -10.7% 1: General Fund 407: City Sponsorships 12,000 12,000 0.0% Changes 1: General Fund 411: Police 2,382,855 2,384,812 1,957.00 0.1% 1: General Fund 414: Community Development 468,089 468,995 906.00 0.2% 1: General Fund 415: Code Enforcement 130,119 122,055 (8,064.00) -6.2% 1: General Fund 420: Fire 824,665 834,481 9,816.00 1.2% 1: General Fund 425: Public Works 559,387 559,307 (80,00) 0.0%

Page 12 ends

Total Revenues (6,512,011) (6,348,990) 97.5%
Total Expenses 6,412,998 6,526,291 101.8%
Net (99,013) 177,301
-2.7% Margin
PART THREE: FINANCIAL

HEALTH CONTEXT FOR

THE BUDGET

Page 15 ends

- Local Government
High-Risk Dashboard
Fi p nt
Farmersville
@ san Jose Low
california
Statewide Rank: 316
General Fund Reserves
Debt Burden
Liquidity
Revenue Trends
Fresno
Pension Obligations
Pension Funding
Pension Costs
Future Pension Costs
OPEB Obligations
OPEB Funding
King City
- FARMERVILLE RISK SCORE
- Farmersville Ranked 356/471 - Risk Assessment Based Upon 10 Factors (Higher Score = Less Risks)
- Most Significant Factors:
- Highest Rank in Tulare County • General Fund Reserves (30%) - Not a Raw Score, but a Ranking > Debt Burden (15%)
› Pension Obligation (10%)
• OPEB Obligation (10%)
FARMERSVILLE California State Auditor's Local Government High-Risk Rating Financial Indicators (2021) Points Possible Farmersville Score Farmersville Rank IN TOP 1/4 OF
STATE General Fund Reserves
Revenue Trends 5 416
Pension Obligations 10 10 332
Pension Funding 4.85 349
Pension Costs 5 4.17 316
Future Pension Costs 5 4.17 366
- State's Focus for Farmersville: OPEB Obligations 10 10 n/a OPEB Funding 5 5 n/a
• Fully Fund Reserves Total 100 89.69 356
• Pre-pay Debt
• Reduce Pension Obligations
• Avoid OPEB
- FARMERSVILLE
STAYS ON General Fund Expense - Budget vs. Actual
BUDGET
7,088,316 7.094,044 6,840,580
6,231,550 6,412,998
PAGE 17
4,904,262 4,882,533
4,129,627 4,001,903 3,684,145
2018 2019 2020 2021 2022 2023 2024
• Budget • Actual
General Fund Revenue & Expense Actuals (and FY 2024 Budget)

Page 18 ends

7,094,044 6,422,741 6.840,540 6,412.998 6,512,011
5,960,252 6,231,055
4,129,621 4,059,821 4,233,672 4.882,533
3,482,261 3,537,333
2018 2019 2020 2021 2022 2023 2024
- Expense I Revenue — Linear (Expense)
- CASH POSITION AS
OF 12/31/2023

GENERAL FUND CASH

PRIORITIES
GOAL: Plan for operations conservatively and allocate extra later, not over-extend and cut later.

ENDING CASH POSITIONS OF CITY OF FARMERSVILLE FUNDS FY 2021 TO FY 2024 ACCOUNT 6/30/2021 6/30/2022 12/31/2022 6/30/2023 12/31/2023 01 GENERAL FUND 1,347,524.58 641,284.08 (382,270.39) 201,839.91 (61,412.72) 08 SELF INSURED RESERVES 551,000.00 801,000.00 801,000.00 801,000.00 801,000.00 60 AMERICAN RESCUE PLAN (ARPA) 1,176,000.79 2,299,954.43 2,214,152.53 2,100,849.52 102 GENERAL FUND RESERVE 1,439,868.82 1,439,868.82 1,439,868.82 1,439,868.82 1,439,868.82 103 GENERAL FUND CAPITAL - (213,482.61) (460.92) (238,562.96) 104 MEASURE Q (CANNABIS) 1,065,025.91 1,462,839.03 2,063,006.75 1,477,750.66 1,889,989.39 General Government Total 4,403,419.31 5,520,992.72 6,008,077.00 6,134,151.00 5,931,732.05 QUESTIONS?
Thank You!

Farmersville City CouncilFebruary 26, 2024

Farmersville City Council
February 26, 2024