ÇITYOA FARMERSVILLE Farmersville City Council Regular Meeting Tina Hernandez, Mayor Danny Valdovinos, Mayor Pro Tem Gregorio Gomez, Council Member Paul Boyer, Council Member Armando Hinojosa, Council Member Monday, February 26, 20246:00F PM Meeting held in Civic Center Council Chambers 9 909V W. Visalia Road Farmersville, California 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: 85457391839 Password: 859673 1. Call to Order: Roll Call: Invocation: Pledge of Allegiance: Public Comment: 2. 3. 4. 5. 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. Itis the policy oft 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 willl be provided an opportunity to address the council as each item is brought upi for discussion. Comments are to be addressed to the Council as al body and not to any individual Council Member. Presentations: 6. 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. B. Minutes of Regular City Council Meeting of February 12, 2024 Recommend approval of minutes. Documents: Draft Action Minutes of February 12, 2024 C. 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 représents investment summary for the previous month. and 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 Recommend that the City Council review and approve a request from Farmersville Elite Soccer Club in the amount of $1,050. Documents: Event Funding Application 8. 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 9. 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 3. Site Visits to Woodlake, Exeter, and Lindsay 4. Water Restrictions 5. Update City Ordinances related to Code Enforcement 6. Reopening-wo-way Traffic on E. Citrus at Freedom Drive 7. Transit Services with Visalia Transit and TCRTA 12. Adjourn to Closed Session: A. ÇONFERENCE WITHL 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 Department Heads International Brotherhood of Teamsters Local 517 Mid-Management Employee Association. B. ÇONFERENCE WITH LEGAL COUNSEL - ANTICIPATED LITIGATION Significant exposure to litigation pursuant to Government Code Section 54956.9 (d)(2): 1 case C. CONFERENCE WITH LEGAL COUNSEL - ANTICIPATED LITIGATION Initiation of litigation pursuant to Government Code Section 54956.9 (d)(4): 1 case D. PUBLIC EMPLOYMENT Title: City Attorney Pursuant to Government Code Section 54957 13. Reconyene 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 Materials- related to an item on this agenda submitted to the Council after distribution of the agenda packet are available for public inspection ini the City's offices during normal business hours. I arrangements toaccommodate you. Drafted by: J. Gomez Strong Roots...Growing Possibllities ÇITYOF FARMERSVILLE Farmersville City Council Regular Meeting Tina Hernandez, Mayor Danny Valdovinos, Mayor Pro Tem Gregorio Gomez, Council Member Paul Boyer, Council Member Armando Hinojosa, Council Member Monday, February 12, 2024 6:00 PM Meeting held in Civic Center Council Chambers -909W. Visalia Road Farmersville, California 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 1. Call to Order: 6:00 pm Roll Call: Attendee Name Tina Hernandez Danny Valdovinos Greg Gomez Paul Boyer Armando Hinojosa 2. Title Mayor Mayor Pro Tem Council Member Council Member Council Member Status Present Present Present Present Present Arrived 6:00 pm 6:00 pm 6:00 pm 6:12 pm 6:00 pm 3. 4. 5. Invocation: Mayor Pro Tem Valdovinos Pledge of Allegiance: Mayor Hernandez 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. Fori items which are on the agenda this evening, members of the public will be provided an opportunity to address the council as each itemi is brought up for discussion. Comments are to be addressed to the Council as al body and not to any John Alvarez, a business owner in Farmersville, voiced concerns regarding the cost of individual Council Member. 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, Mr. Myers utilized graphs and charts to summarize the current business tax. He offered examples illustrating the potential impact ofa 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 ifthe current structure were altered without the nèed 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, à representative from Willdan, presented the Council with a PowerPoint presentation outlining a five-year financial plan. The. plan addressed funding for current and future opèrations, debt repayment, compliance, maintenance of operating reserves, establishment of a cost-based rate structure, and adherence to Proposition 218 equrements/Aduitional, Mr. Fisher informed the Council that the Proposition 218 public hearing, will be scheduled for the Council meeting on April 22, 2024. Atthis hearing, the Council will discuss and consider adopting the utility rate implementation. Under a CONSENT AGENDA category, a recommended course of action for each item is made. Any Council Memberor Member of the Public may remove any item from the CONSENT AGENDA in order to discuss andlor change the recommended course of action, and the Council can approve the remainder. of 7. Consent Agenda: the CONSENT AGENDA. A. Authorization to waive full reading of ordinances and resolutions and toi identify by title only. Recommend that the City Council approve the fuill 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 C. 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 MOVER AYES ABSENT ABSTAIN 8. APPROVED (UNANIMOUS) Councilmember Boyer SEÇONDER Councilmember Gomez Hernandez, Valdovinos, Gomez, Boyer, Hinojosa 0 General Business A. Çooperative Agreement between the City of Farmersville and the Çounty of Tulare for Avenue 280 Widening Project- Segment2 Recommend that the City Council authorize the City Manager to sign the Çooperative Agreement. Documents: Cooperative Agreement City ManagerJennifer 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. Discussion took place. Motion to approve as presented. RESULT MOVER AYES ABSENT ABSTAIN APPROVED (UNANIMOUS) Mayor Pro Tem Valdovinos ? SECONDER Councilmember Boyer Hernandez, Valdovinos/Gomer, Boyer, Hinojosa 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 for 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 MOVER AYES ABSENT ABSTAIN 9. APPROVED (UNANIMOUS) Councilmember Gomez SECONDER Mayor Pro Tem Valdovinos Hernandez, Valdovinos, Gomez, Boyer, Hinojosa 0 0 Council Reports A. City Council Updates and Committee Reports Councilmemberk 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 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 yeàr. Furthermore, he provided an update on the City Managerennifer Gomez updated the Council, informing them that the crosswalk at Snowden School was removed from the contractor's contract. She further explained Councilmember Gomez thanked the staff for their availability during the recent storms. He àlso inquired about any, potential damage caused by the storms. Public Works Director. Jeff Dowlen responded, informing the Council that there was minimal damage she plans on rebuilding. Greater Kaweah Ground Water meeting he recently attended. that the City will now be responsible for installing the crosswalk. throughout theCity, mainly limited to potholes. He. assured them that the Public Works 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 department is actively working to, address and fill the potholes. 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 Public Works DirectorJeff 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 Battalion Chief Thomas provided an update on a recent structure fire on February 9th. Additionally, he informed the Çouncil that both Code Enforcement officers had completed their first Code Enforcement module class with the State. budget with state or federal funds. the Council that the North half of Roy's Park has been completed. 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 Restriçtions 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. ÇONFERENCE 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 Department Heads International Brotherhood of Teamsters Local 517 Mid-Management Employee Association B. PUBLIC EMPLOYMENT Title: City Attorney Pursuant to Government Code Section 54957 13.' Reconvene to Open Session: MayorHernaridez reconvened to open session at 9:18 pm with nothing to report. 14. Closed Session Report(ifany): 15. Adjournment: Mayor Hernandez adjourned the meeting at 9:18 pm. Respectiulysubmited, Rochelle Giovani, City Clerk Strong Roots...rowing Possibilities CITYOF FARMERSVILLE City Council Staff Report Consent Item # 7C TO: FROM: DATE: Honorable Mayor and City Council Steve Huntley, CPFO, IPMA-SCP Director of Finance & Administration February 26, 2024 Summary SUBJECT: Finance Update for January 2024: Warrant Register and Investment RECOMMENDED ACTION: Itis 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 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 City Finance Department and City Manager's Office. 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 Budget: NOVEMBER GENERAL FUND WARRANTS GENERAL FUND WARRANTS GENERAL FUND. ACH GENERAL FUND. ACH GENERAL FUND ACH# PAYROLL WARRANTS PAYROLL WARRANTS # PAYROLLI WARRANTS #137971-138020 #138021-138087 #1002185 #1002186-102207 #1002208-1002237 #14941-14984 #14985-15111 #15112-15151 147,261.03 672,389.87 16,782.79 9,420.00 304,730.88 80,508.71 VOID 81,817.97 $1,312,911.36 CONCLUSION: Itis respectfully recommended that the City Council approve the Warrant Register as Itis respectfully recommended that the City Council accept the Investment Summary as presented for the period January 1, 2024, to January 31, 2024 presented for the period of December 2023 Attachment(s): 1. Warrant Registers January 2024. 2. Investment Summary December 2023. 2 OF FARMERSVILLE A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME munis atyler erp solution CITY 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE INV DATE PO 01/01/2024 CHECK 12/17/2023 CHECK 12/28/2023 CHECK 12/31/2023 CHECK 12/27/2023 09/30/2023 CHECK 12/27/2023 CHECK 10/03/2023 CHECK 01/11/2024 06/30/2023 08/31/2023 CHECK 01/04/2024 CHECK WARRANT 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 3103 3103 TOTAL: 3103 TOTAL: NET 271.57 271.57 1,961.68 1,961.68 333.00 333.00 2,216.40 2,216.40 150.00 300.00 450.00 200.00 200.00 700.00 700.00 7,824.45 2,740.45 7,281.84 17,846.74 980.00 980.00 01/18/2024 PRTD 542 THOMSON REUTERS 849496273 01/18/2024 PRTD 544 SIERRA DESIGNS, INC 21-080-22 01/18/2024 PRTD 849 MURILLO, JOSE ULISES 122823 01/18/2024 PRTD 1015 ABLE INDUSTRIES, INC 122320 01/18/2024 PRTD 1481 HINDERLITER DELLAMAS SIN034320 SIN032397 1444 01/18/2024 PRTD 1491 SIERRA AERIFORM LLC 01/18/2024 PRTD 1517 CITY OF TULARE FIRE TRN-10223 01/18/2024 PRTD 1598 CSET 123123 063023 083123 01/18/2024 PRTD 1636 CRAWFORD & BOWEN PLA 856 Report generated: 01/18/2024 09:46 6175mame Program ID: apcshdsb Page CITY OF FARMERSVILLE A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME munis atyler erp solution 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE INV DATE PO 11/30/2023 11/30/2023 CHECK 12/06/2023 12/27/2023 01/02/2024 CHECK 12/12/2023 CHECK 08/02/2023 CHECK 12/31/2023 CHECK 12/08/2023 CHECK 09/01/2023 CHECK 12/14/2023 CHECK 01/11/2024 CHECK WARRANT 3103 3103 TOTAL: 3103 3103 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: NET 127.50 34.50 162.00 2,546.70 1,282.78 -550.00 3,279.48 377.13 377.13 1,100.16 1,100.16 2,275.00 2,275.00 5,539.44 5,539.44 5,000.00 5,000.00 17.60 17.60 879.41 879.41 01/18/2024 PRTD 1662 LIEBERT CASSIDY WHIT 256668 255768 01/18/2024 PRTD 1695 SUPERIOR POOL PRODUC Q2025643 Q2025789 Q2025817 01/18/2024 PRTD 1702 CAL BENNETTS INC. 27831-0 01/18/2024 PRTD 2011 ROGER VOGT's PERFORM 36061 01/18/2024 PRTD 2203 WESTSCAPES, INC 20984 10 01/18/2024 PRTD 2266 TFD ENTERPRISES LLC 01/18/2024 PRTD 2267 TOWNSEND PUBLIC AFFA 20382 01/18/2024 PRTD 2285 THE POLICE AND SHERI 186466 01/18/2024 PRTD 2304 KINGS MEDICAL CENTER 211848 Report generated: 01/18/2024 09:46 user: 6175mame Program ID: apcshdsb Page 2 OF FARMERSVILLE A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME munis atyler erp solution CITY 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE INV DATE PO 12/29/2023 CHECK 12/19/2023 CHECK 12/19/2023 CHECK 12/19/2023 CHECK 12/31/2023 CHECK 12/28/2023 12/27/2023 12/14/2023 12/01/2023 12/15/2023 CHECK 12/19/2023 CHECK 12/28/2023 CHECK 12/31/2023 WARRANT 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 3103 3103 3103 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 NET 341.88 341.88 51.00 51.00 185.00 185.00 15,768.75 15,768.75 145.80 145.80 1,529.04 1,529.04 1,534.48 1,353.95 2,018.43 7,964.94 745.00 745.00 333.00 333.00 1,110.22 01/18/2024 PRTD 2374 KNOWBE4, INC. 122923 01/18/2024 PRTD 2400 PANKEY, DAVID 121923 01/18/2024 PRTD 2403 LEBOEUF, RACHEL 121923 01/18/2024 PRTD 2460 ASPEN RENTALS, INC 6288607 01/18/2024 PRTD 2472. PACIFIC STORAGE COMP 5190299 01/18/2024 PRTD 2505 CALPORTLAND COMPANY 96183521 96183520 96171635 96162694 96171636 01/18/2024 PRTD 2508 WILSON TACTICAL OPER 121923 01/18/2024 PRTD 2509 CERCAS, BRENDA 122823 01/18/2024 PRTD 2510 GANNETT CALIFORNIA L 0006143582 Report generated: 01/18/2024 09:46 User: 6175mame Program ID: apcshdsb 3 Page FARMERSVILLE munis atyler erps solution CITY OF A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE INV DATE PO CHECK 12/29/2023 12/22/2023 12/15/2023 01/05/2024 12/29/2023 12/22/2023 CHECK 11/30/2023 CHECK 01/11/2024 CHECK 12/19/2023 CHECK 12/14/2023 12/11/2023 CHECK 12/19/2023 12/14/2023 CHECK 12/05/2023 CHECK WARRANT TOTAL: 3103 3103 3103 3103 3103 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 3103 TOTAL: 3103 3103 TOTAL: 3103 TOTAL: NET 1,110.22 90.00 90.00 240.00 330.00 210.00 360.00 1,320.00 18,442.88 18,442.88 407.00 407.00 407.00 407.00 118.51 147.65 266.16 274.05 116.58 390.63 200.00 200.00 01/18/2024 PRTD 3602 BILL WALL's DIRECT A 16830 16828 16827 16833 16831 16829 01/18/2024 PRTD 4867 BOYS & GIRLS CLUB OF 101857 01/18/2024 PRTD 4901 BROCK, JAY 011124 01/18/2024 PRTD 4901 BROCK, JAY 121923 01/18/2024 PRTD 5300 BS&E COMPANY, INC 351272 350978 01/18/2024 PRTD 6085 CASCADE FIRE EQUIPME INV9366 INV9314 01/18/2024 PRTD 9940 DEPARTMENT OF JUSTIC 700262 Report generated: 01/18/2024 09:46 user: 6175mame Program ID: apcshdsb Page CITY OF FARMERSVILLE A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME munis atyler erp solution 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE INV DATE PO 01/11/2024 CHECK 12/19/2023 CHECK 12/27/2023 CHECK 12/18/2023 09/23/2023 09/23/2023 09/23/2023 09/23/2023 09/21/2023 08/07/2023 12/27/2023 CHECK 11/10/2023 CHECK 11/29/2023 CHECK 12/21/2023 CHECK WARRANT 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 3103 3103 3103 3103 3103 3103 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: NET 310.50 310.50 379.50 379.50 16,935.65 16,935.65 99.00 41.00 41.00 41.00 99.00 41.00 99.00 99.00 560.00 1,545.00 1,545.00 268.00 268.00 2,056.70 2,056.70 01/18/2024 PRTD 10600 EVRETT, TROY 011124 01/18/2024 PRTD 10600 EVRETT, TROY 121923 01/18/2024 PRTD 12000 FARLEY LAW FIRM 122723 01/18/2024 PRTD 14651 FGL ENVIRONMENTAL 348161A 346197A 346198A 346196A 346195A 346019A 344863A 348416A 01/18/2024 PRTD 14785 THE GLASS SHOP, INC. I-23-1331 01/18/2024 PRTD 16580 GRAFIX SHOPPE 154094 01/18/2024 PRTD 16603 GROSS & STEVENS INC 139357 Report generated: 01/18/2024 09:46 user: 6175mame Program ID: apcshdsb Page FARMERSVILLE munis alyler erp solution CITY OF A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE INV DATE PO 12/22/2023 CHECK 12/20/2023 CHECK 12/29/2023 CHECK 12/20/2023 CHECK 01/09/2024 01/09/2024 CHECK 12/30/2023 CHECK 09/19/2023 CHECK 11/30/2023 CHECK 12/26/2023 CHECK WARRANT 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: 3103 TOTAL: NET 119.35 119.35 1,484.65 1,484.65 18,170.40 18,170.40 9,111.92 9,111.92 220.00 220.00 440.00 812.50 812.50 270.00 270.00 1,309.09 1,309.09 1,818.90 1,818.90 01/18/2024 PRTD 20000 IDEA PRINTING & GRAP 121145 01/18/2024 PRTD 37000 QUAD KNOPF, INC. 121635 01/18/2024 PRTD 41000 SELF-HELP ENTERPRISE FVL12RE JUL-OCT23 01/18/2024 PRTD 43673 SWRCB LW-1046413 712735 712734 01/18/2024 PRTD 43760 SUN-GAZETTE 01/18/2024 PRTD 45000 TRUCK PARTS AND SERV 117897 01/18/2024 PRTD 51555 VINCENT COMMUNICATIO 87001 01/18/2024 PRTD 52000 VISALIA TIMES DELTA/ 0006073670 01/18/2024 PRTD 53075 WATER TECHNOLOGY OF 23-9951 Report generated: 01/18/2024 09:46 user: 6175mame Program ID: apcshdsb Page FARMERSVILLE munis atyler erp solution CITY OF A/P CASH DISBURSEMENTS JOURNAL NUMBER OF CHECKS 50 TOTAL PRINTED CHECKS *** CASH ACCOUNT TOTAL *** 147,261.03 COUNT 50 AMOUNT 147,261.03 *** GRAND TOTAL *** 147,261.03 Report generated: 01/18/2024 09:46 User: 6175mame Program ID: apcshdsb Page FARMERSVILLE munis atyler erps solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3103 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT DOCUMENT INVOICE PO NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE APPROVED UNPAID INVOICES TO BE POSTED 542 00000 THOMSON REUTERS 47093 CASH 01 ACCT 1100 DEPT w9hld 3103 271.57 .00 .00 849496273 2024/07 INV 01/01/2024 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 01411 5205 271.57 1099: CONDITIONS THAT PREVENT POSTING INVOICE 544 00000 SIERRA DESIGNS, 47133 CASH 01 ACCT 1100 DEPT 849 00000 MURILLO, JOSE UL 47084 CASH 01 ACCT 1100 DEPT w9hld 542/47093 3103 1,961.68 .00 31425 5516 FREE .00 1,961.68 1099: .00 21-080-22 2024/07 INV 12/17/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:FREE-PROFESSIONAL SERVICE 3103 333.00 .00 122823 2024/07 INV 12/28/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:MODULE ONE ACADEMY 01415 5208 333.00 1099:0 CONDITIONS THAT PREVENT POSTING INVOICE 1015 00000 ABLE INDUSTRIES, 47152 CASH 01 ACCT 1100 DEPT w9hld 849/47084 3103 2,216.40 .00 .00 122320 2024/07 INV 12/31/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROPESSIONAL SERVICE 01425 5205 2,216.40 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1481 00000 HINDERLITER DELL 47143 CASH 01 ACCT 1100 DEPT w9hld 1015/47152 3103 150.00 .00 .00 SIN034320 2024/07 INV 12/27/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 01414 5205 150.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1481/47143 Report generated: 01/18/2024 09:38 user: 6175mame Program ID: apinvent Page CITY OF FARMERSVILLE INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3103 VENDOR REMIT NAME munis alyler erps solution NEW INVOICES VOUCHER WARRANT 3103 DOCUMENT INVOICE PO SIN032397 NET AMOUNT EXCEEDS PO_BY PO BALANCE CHK/WIRE 1481 00000 HINDERLITER DELL 47145. CASH 01 ACCT 1100 DEPT w9hld 300.00 .00 01404 5205 CNBIS .00 2024/07 INV 09/30/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESCIOABIS-POFESSIDNAL SERVICE 300.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1491 00000 SIERRA AERIFORM 47124 CASH 01 ACCT 1100 DEPT w9hld 1481/47145 3103 200.00 .00 31425 5516 FREE 12400 5516 AHSC .00 1444 2024/07 INV 12/27/2023 SEP-CHK: N DISC: .00 100.00 1099:7 100.00 1099:7 DUE 01/16/2024 DESC:FREEGAHSC-PROFESSIONAL SERVICE CONDITIONS THAT PREVENT POSTING INVOICE 1517 00000 CITY OF TULARE F 47115 CASH 01 ACCT 1100 DEPT w9hld 1598 00000 CSET CASH 01 ACCT 1100 DEPT w9hld 1598 00000 CSET CASH 01 ACCT 1100 DEPT w9hld 1491/47124 3103 700.00 .00 .00 TRN-10223 2024/07 INV 10/03/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 01420 5208 700.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1517/47115 47111 123123 3103 7,824.45 .00 .00 2024/07 INV 01/11/2024 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESCEPROFESSIONAL SERVICE 01414 5205 7,824.45 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1598/47111 47130 063023 3103 2,740.45 .00 .00 2024/07 INV 06/30/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 01414 5205 2,740.45 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1598/47130 Report generated: 01/18/2024 09:38 user: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erps solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3103 VENDOR REMIT NAME 1598 00000 CSET CASH 01 ACCT 1100 DEPT w9hld NEW INVOICES VOUCHER WARRANT 3103 DOCUMENT INVOICE PO 47131 083123 NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 7,281.84 .00 .00 2024/07 INV 08/31/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 01414 5205 7,281.84 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1636 00000 CRAWFORD & BOWEN 47083 CASH 01 ACCT 1100 DEPT w9hld 1598/47131 3103 980.00 .00 60425 5504 PWYRD .00 856 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PWYRD-PROFESSIONAL SERVICE 980.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1662 00000 LIEBERT CASSIDY 47127 CASH 01 ACCT 1100 DEPT w9hld 1636/47083 3103 127.50 .00 .00 256668 2024/07 INV 11/30/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESCPROFESSIONAL SERVICE 01406 5205 127.50 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1662 00000 LIEBERT CASSIDY 47128 CASH 01 ACCT 1100 DEPT W9hld 1662/47127 3103 34.50 .00 .00 255768 2024/07 INV 11/30/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 01404 5205 34.50 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1695 00000 SUPERIOR POOL PR 47134 CASH 01 ACCT 1100 DEPT w9hld 1662/47128 3103 2,546.70 .00 .00 Q2025643 2024/07 INV 12/06/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESCIPROFESSIONAL SERVICE 02425 5202 2,546.70 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1695/47134 Report generated: 01/18/2024 09:38 user: 6175mame Program ID: apinvent 3 Page FARMERSVILLE munis atyler erp solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3103 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT 3103 DOCUMENT INVOICE PO Q2025789 NET AMOUNT EXCEEDS PO_BY PO BALANCE CHK/WIRE 1695 00000 SUPERIOR POOL PR 47154 CASH 01 ACCT 1100 DEPT w9hld 1,282.78 .00 02425 5202 .00 2024/07 INV 12/27/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:OPER SUPPLIES 1,282.78 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1695 00000 SUPERIOR POOL PR 47157 CASH 01 ACCT 1100 DEPT w9hld 1695/47154 3103 -550.00 .00 .00 Q2025817 2024/07 INV 01/02/2024 SEP-CHK: N DISC: .00 DUE 01/02/2024 DESC:CREDIT 02425 5202 -550.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1702 00000 CAL BENNETTS INC 47081 CASH 01 ACCT 1100 DEPT w9hld 1695/47157 3103 377.13 .00 .00 27831-0 2024/07 INV 12/12/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESCIFROFESSIONAL SERVICE 01404 5504 377.13 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2011 00000 ROGER VOGT's PER 47113 CASH 01 ACCT 1100 DEPT w9hld 1702/47081 3103 1,100.16 .00 .00 36061 2024/07 INV 08/02/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESCEPROFESSIONAL SERVICE 01420 5204 1,100.16 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2203 00000 WESTSCAPES, INC 47149 CASH 01 ACCT 1100 DEPT w9hld 2011/47113 3103 2,275.00 .00 35425 5205 .00 2,275.00 1099: 20984 2024/07 INV 12/31/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESCIPROFESSIONAL SERVICE CONDITIONS THAT PREVENT POSTING INVOICE 2203/47149 Report generated: 01/18/2024 09:38 user: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erp solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3103 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT 3103 DOCUMENT INVOICE PO 10 NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 2266 00000 TFD ENTERPRISES 47144 CASH 01 ACCT 1100 DEPT 2267 00000 TOWNSEND PUBLIC 47147 CASH 01 ACCT 1100 DEPT 2285 00000 THE POLICE AND S 47098 CASH 01 ACCT 1100 DEPT 2304 00000 KINGS MEDICAL CE 47100 CASH 01 ACCT 1100 DEPT w9hld 5,539.44 .00 .00 2024/07 INV 12/08/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 04425 5205 5,539.44 1099: .00 3103 5,000.00 .00 20382 2024/07 INV 09/01/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESCEPROFESSIONAL SERVICE 01404 5205 17.60 5,000.00 1099: .00 3103 .00 186466 2024/07 INV 12/14/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 01411 5205 879.41 17.60 1099: .00 3103 .00 211848 2024/07 INV 01/11/2024 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 01425 5205 02425 5205 93.10 1099: 93.10 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2304/47100 04425 5205 21425 5205 01411 5205 341.88 93.10 1099: 93.10 1099: 507.01 1099: .00 2374 00000 KNOWBE4, INC. 47087 CASH 01 ACCT 1100 DEPT 2400 00000 PANKEY, DAVID 47104 CASH 01 ACCT 1100 DEPT w9hld 3103 .00 122923 2024/07 INV 12/29/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 01404 5205 51.00 341.88 1099: .00 3103 .00 121923 2024/07 INV 12/19/2023 SEP-CHK: N DISC: .00 01411 5208 51.00 1099: DUE 01/16/2024 DESC:FIREARMS SIGHTING SYSTEM INSTRUCTOR COURSE CONDITIONS THAT PREVENT POSTING INVOICE 2400/47104 Report generated: 01/18/2024 09:38 User: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erp solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3103 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT 3103 DOCUMENT INVOICE PO 121923 NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 2403 00000 LEBOEUF, RACHEL 47103. CASH 01 ACCT 1100 DEPT w9hld 185.00 .00 .00 2024/07 INV 12/19/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:CNCA CONFERENCE 01411 5208 185.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2460 00000 ASPEN RENTALS, I 47142 CASH 01 ACCT 1100 DEPT w9hld 2403/47103 3103 15,768.75 .00 04425 5205 SLDGE .00 15,768.75 1099: 6288607 2024/07 INV 12/19/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:SLDGE-PROFESSIONAL SERVICE CONDITIONS THAT PREVENT POSTING INVOICE 2472 00000 PACIFIC STORAGE 47148 CASH 01 ACCT 1100 DEPT 2505 00000 CALPORTLAND COMP 47106 CASH 01 ACCT 1100 DEPT 2505 00000 CALPORTLAND COMP 47107 CASH 01 ACCT 1100 DEPT 2505 00000 CALPORTLAND COMP 47108 CASH 01 ACCT 1100 DEPT 2505 00000 CALPORTLAND COMP 47109 CASH 01 ACCT 1100 DEPT 2460/47142 3103 145.80 .00 .00 5190299 2024/07 INV 12/31/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 01411 5205 01406 5205 95.40 1099: 50.40 1099: .00 3103 1,529.04 .00 60404 5516 ROY2 96183521 2024/07 INV 12/28/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:ROY2-PROFESSIONAL SERVICE 1,529.04 1099: .00 3103 1,529.04 .00 60404 5516 ROY2 96183520 2024/07 INV 12/27/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:ROY2-PROFESSIONAL SERVICE 1,529.04 1099: .00 1,534.48 1099: .00 3103 1,534.48 .00 31425 5516 ROYPK 96171635 2024/07 INV 12/14/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:ROYPK-PROFESSIONAL SERVICE 3103 1,353.95 .00 60404 5516 ROY2 96162694 2024/07 INV 12/01/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC.ROV2-POPESSIOMAL SERVICE 1,353.95 1099: Report generated: 01/18/2024 09:38 User: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erps solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3103 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT 3103 DOCUMENT INVOICE PO 96171636 NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 2505 00000 CALPORTLAND COMP 47110 CASH 01 ACCT 1100 DEPT 2508 00000 WILSON TACTICAL 47105 CASH 01 ACCT 1100 DEPT w9hld 2,018.43 .00 60404 5516 ROY2 31425 5516 ROYPK .00 01411 5208 .00 1,000.00 1099: 1,018.43 1099: .00 2024/07 INV 12/15/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESCEROYZAROYPK-PROFESSIONAL SERVICE 3103 745.00 121923 2024/07 INV 12/19/2023 SEP-CHK: N DISC: .00 745.00 1099: DUE 01/16/2024 DESC:FIREARMS SIGHTING SYSTEM INSTRUCTORS COURSE CONDITIONS THAT PREVENT POSTING INVOICE 2509 00000 CERCAS, BRENDA 47085 CASH 01 ACCT 1100 DEPT w9hld 2508/47105 3103 333.00 .00 .00 122823 2024/07 INV 12/28/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:MODULE ONE ACADEMY 01415 5208 333.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2510 00000 GANNETT CALIFORN 47090 CASH 01 ACCT 1100 DEPT w9hld 2509/47085 3103 1,110.22 .00 .00 0006143582 2024/07 INV 12/31/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROPFESSIONAL SERVICE 01414 5205 1,110.22 1099: CONDITIONS THAT PREVENT POSTING INVOICE 3602 00000 BILL WALL's DIRE 47094 CASH 01 ACCT 1100 DEPT 3602 00000 BILL WALL's DIRE 47095 CASH 01 ACCT 1100 DEPT 2510/47090 3103 90.00 .00 01411 5205 90.00 .00 16830 2024/07 INV 12/29/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:CONSULTING 16828 90.00 1099:0 .00 3103 .00 01411 5205 2024/07 INV 12/22/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:CONSULTING 90.00 1099:0 Report generated: 01/18/2024 09:38 User: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erp solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3103 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT 3103 DOCUMENT INVOICE PO 16827 NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 3602 00000 BILL WALL's DIRE 47096 CASH 01 ACCT 1100 DEPT 3602 00000 BILL WALL'S DIRE 47112 CASH 01 ACCT 1100 DEPT 3602 00000 BILL WALL's DIRE 47125 CASH 01 ACCT 1100 DEPT 3602 00000 BILL WALL's DIRE 47126 CASH 01 ACCT 1100 DEPT 4867 00000 BOYS & GIRLS CLU 47123 CASH 01 ACCT 1100 DEPT 4901 00000 BROCK, JAY CASH 01 ACCT 1100 DEPT 4901 00000 BROCK, JAY CASH 01 ACCT 1100 DEPT 5300 00000 B S&E COMPANY, 47158 CASH 01 ACCT 1100 DEPT 240.00 .00 .00 2024/07 INV 12/15/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:CONSULTING 16833 01411 5205 330.00 240.00 1099:0 .00 3103 .00 01406 5205 210.00 2024/07 INV 01/05/2024 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:CONSULTING 16831 330.00 1099:0 .00 3103 .00 01406 5205 360.00 2024/07 INV 12/29/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:CONSULTING 16829 210.00 1099:0 .00 3103 .00 2024/07 INV 12/22/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:CONSULTING 101857 01406 5205 360.00 1099:0 .00 18,442.88 1099: .00 3103 18,442.88 .00 2024/07 INV 11/30/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 01414 5205 407.00 47091 011124 3103 .00 2024/07 INV 01/11/2024 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:POST EXECUTIVE COURSE 01411 5208 407.00 407.00 1099: .00 47101 121923 3103 .00 2024/07 INV 12/19/2023 SEP-CHK: Y DISC: .00 DUE 01/16/2024 DESC:POST EXECUTIVE COURSE 01411 5208 118.51 407.00 1099: .00 3103 .00 60404 5516 ROY2 351272 2024/07 INV 12/14/2023 SEP-CHK: N DISC: .00 DUE 01/02/2024 DESC:ROY2-PROFESSIONAL SERVICE 118.51 1099: Report generated: 01/18/2024 09:38 user: 6175mame Program ID: apinvent Page CITY OF FARMERSVILLE INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3103 MENDOR REMIT NAME munis afyler erps solution NEW INVOICES VOUCHER WARRANT 3103 DOCUMENT INVOICE PO 350978 NET AMOUNT EXCEEDS PO_BY PO BALANCE CHK/WIRE 5300 00000 B S&E COMPANY, 47159 CASH 01 ACCT 1100 DEPT 6085 00000 CASCADE FIRE EQU 47118 CASH 01 ACCT 1100 DEPT 6085 00000 CASCADE FIRE EQU 47119 CASH 01 ACCT 1100 DEPT 9940 00000 DEPARTMENT OF JU 47099 CASH 01 ACCT 1100 DEPT 10600 00000 EVRETT, TROY 47092 CASH 01 ACCT 1100 DEPT 10600 00000 EVRETT, TROY 47102 CASH 01 ACCT 1100 DEPT 12000 00000 FARLEY LAW FIRM 47161 CASH 01 ACCT 1100 DEPT 147.65 .00 60404 5516 ROY2 .00 2024/07 INV 12/11/2023 SEP-CHK: N DISC: .00 DUE 01/02/2024 DESC:ROY2-PROFESSIONAL SERVICE 147.65 1099: .00 3103 274.05 .00 INV9366 2024/07 INV 12/19/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:OPER SUPPLIES 01420 5202 116.58 274.05 1099: .00 3103 .00 01420 5202 200.00 INV9314 2024/07 INV 12/14/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:OPER SUPPLIES 116.58 1099: .00 3103 .00 700262 2024/07 INV 12/05/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESCEPROFESSIONAL SERVICE 01411 5205 310.50 200.00 1099: .00 3103 .00 011124 2024/07 INV 01/11/2024 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:POST MANAGEMENT COURSE 01411 5208 379.50 310.50 1099: .00 3103 .00 121923 2024/07 INV 12/19/2023 SEP-CHK: Y DISC: .00 DUE 01/16/2024 DESC:POST MANAGEMENT COURSE 01411 5208 379.50 1099: .00 3103 16,935.65 .00 122723 2024/07 INV 12/27/2023 SEP-CHK: N DISC: .00 DUE 01/02/2024 DESC:PROFESSIONAL SERVICE 01404 5205 04425 5205 SLDGE 04425 5205 SLDGE 01404 5205 01411 5205 01406 5205 01406 5205 290.00 1099:0 7,002.75 1099:0 1,712.39 1099:0 2,469.63 1099:0 1,368.75 1099:0 145.00 1099:0 3,947.13 1099:0 Report generated: 01/18/2024 09:38 User: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erp solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3103 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT 3103 DOCUMENT INVOICE PO 348161A NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 14651 00000 FGL ENVIRONMENTA 47135 CASH 01 ACCT 1100 DEPT 14651 00000 FGL ENVIRONMENTA 47136 CASH 01 ACCT 1100 DEPT 14651 00000 FGL ENVIRONMENTA 47137 CASH 01 ACCT 1100 DEPT 14651 00000 FGL ENVIRONMENTA 47138 CASH 01 ACCT 1100 DEPT 14651 00000 FGL ENVIRONMENTA 47139. CASH 01 ACCT 1100 DEPT 14651 00000 FGL ENVIRONMENTA 47140 CASH 01 ACCT 1100 DEPT 14651 00000 FGL ENVIRONMENTA 47141, CASH 01 ACCT 1100 DEPT 14651 00000 FGL ENVIRONMENTA 47153 CASH 01 ACCT 1100 DEPT 99.00 .00 .00 2024/07 INV 12/18/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 02425 5205 41.00 99.00 1099: .00 3103 .00 02425 5205 41.00 346197A 2024/07 INV 09/23/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESCEPROFESSIONAL SERVICE 41.00 1099: .00 3103 .00 346198A 2024/07 INV 09/23/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 02425 5205 41.00 41.00 1099: .00 3103 .00 346196A 2024/07 INV 09/23/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 02425 5205 99.00 41.00 1099: .00 3103 .00 02425 5205 41.00 346195A 2024/07 INV 09/23/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 99.00 1099: .00 3103 .00 02425 5205 99.00 346019A 2024/07 INV 09/21/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESCEPROFESSIONAL SERVICE 41.00 1099: .00 3103 .00 344863A 2024/07 INV 08/07/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESCPROFESSIONAL SERVICE 02425 5205 99.00 99.00 1099: .00 3103 .00 348416A 2024/07 INV 12/27/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESCEPROFESSIONAL SERVICE 02425 5205 99.00 1099: Report generated: 01/18/2024 09:38 user: 6175mame Program ID: apinvent Page FARMERSVILLE munis alyler erps solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3103 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT 3103 DOCUMENT INVOICE PO I-23-1331 NET AMOUNT EXCEEDS PO BY PO_BALANCE CHK/WIRE 14785 00000 THE GLASS SHOP, 47082 CASH 01 ACCT 1100 DEPT 16580 00000 GRAFIX SHOPPE 47120 CASH 01 ACCT 1100 DEPT 16603 00000 GROSS & STEVENS 47097 CASH 01 ACCT 1100 DEPT 20000 00000 IDEA PRINTING & 47117 CASH 01 ACCT 1100 DEPT 37000 00001 QUAD KNOPF, INC. 47132 CASH 01 ACCT 1100 DEPT 41000 00000 SELF-HELP ENTERP 47160 CASH 01 ACCT 1100- DEPT 43673 00001 SWRCB CASH 01 ACCT 1100 DEPT 43760 00000 SUN-GAZETTE 47088 CASH 01 ACCT 1100 DEPT 1,545.00 .00 01404 5205 268.00 .00 2024/07 INV 11/10/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 1,545.00 1099: .00 3103 .00 154094 2024/07 INV 11/29/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 01411 5204 268.00 1099: .00 3103 2,056.70 .00 01411 5204 119.35 139357 2024/07 INV 12/21/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 2,056.70 1099: .00 3103 .00 01420 5202 121145 2024/07 INV 12/22/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 119.35 1099: .00 3103 1,484.65 .00 01414 5205 121635 2024/07 INV 12/20/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE FVL12RE JUL-OCT23 1,484.65 1099: .00 18,170.40 1099: .00 3103 18,170.40 .00 12400 5205 00005 2024/07 INV 12/29/2023 SEP-CHK: N DISC: .00 DUE 01/02/2024 DESC.000-POFESIONA SERVICE 47129 LW-1046413 3103 9,111.92 .00 2024/07 INV 12/20/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 02425 5205 220.00 9,111.92 1099: .00 3103 .00 712735 2024/07 INV 01/09/2024 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 01414 5205 220.00 1099: Report generated: 01/18/2024 09:38 user: 6175mame Program ID: apinvent Page munis atyler erp solution CITY OF FARMERSVILLE INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3103 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT 3103 DOCUMENT INVOICE PO 712734 NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 43760 00000 SUN-GAZETTE 47089 CASH 01 ACCT 1100 DEPT 45000 00000 TRUCK PARTS AND 47116 CASH 01 ACCT 1100 DEPT 51555 00000 VINCENT COMMUNIC 47114 CASH 01 ACCT 1100 DEPT 52000 00001 VISALIA TIMES DE 47122. CASH 01 ACCT 1100 DEPT 220.00 .00 .00 2024/07 INV 01/09/2024 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 01414 5205 812.50 220.00 1099: .00 3103 .00 01420 5504 270.00 117897 2024/07 INV 12/30/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 812.50 1099: .00 3103 .00 87001 2024/07 INV 09/19/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 01420 5204 270.00 1099: .00 3103 1,309.09 .00 0006073670 2024/07 INV 11/30/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 01414 5205 01404 5205 01414 5205 01414 5205 215.48 1099: 371.24 1099: 381.28 1099: 341.09 1099: .00 53075 00000 WATER TECHNOLOGY 47150. CASH 01 ACCT 1100 DEPT 3103 1,818.90 .00 23-9951 2024/07 INV 12/26/2023 SEP-CHK: N DISC: .00 DUE 01/16/2024 DESC:PROFESSIONAL SERVICE 02425 5205 1,818.90 1099:0 75 APPROVED UNPAID INVOICES 75 INVOICE(S) TOTAL 147,261.03 147,261.03 REPORT POST TOTAL eport generated: 01/18/2024 09:38 user: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erp solution CITY OF A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE 189372 INV DATE PO 10/05/2023 CHECK 01/10/2024 CHECK 12/21/2023 CHECK 12/22/2023 CHECK 12/13/2023 12/13/2023 CHECK 01/04/2024 CHECK 11/20/2023 CHECK 12/15/2023 CHECK 01/17/2024 CHECK 01/17/2024 CHECK WARRANT 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: NET 1,026.73 1,026.73 367.50 367.50 3,305.64 3,305.64 1,466.00 1,466.00 122.00 78.00. 200.00 2,364.06 2,364.06 29.06 29.06 253.65 253.65 140.75 140.75 161.25 161.25 01/22/2024 PRTD 127 QUALITY MUFFLER SERV 01/22/2024 PRTD 626 STRADLING YOCCA CARL 403466 01/22/2024 PRTD 633 CHARTER COMMUNICATIO 170047601122125 01/22/2024 PRTD 769 AMERICAN INCORPORATE 7169205 01/22/2024 PRTD 990 TERMINIX 441341629 441341257 01/22/2024 PRTD 1207 PROFESSIONAL PRINT & 119314 01/22/2024 PRTD 1234 AUTOZONE 3711558270 01/22/2024 PRTD 1242 CALIFORNIA BUSINESS 338967 01/22/2024 PRTD 1245 HUNTLEY, STEVE 011724 01/22/2024 PRTD 1245 HUNTLEY, STEVE 11724 Report generated: 01/22/2024 16:48 user: 6175mame Program ID: apcshdsb 1 Page FARMERSVILLE munis atyler erps solution CITY OF A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE INV DATE PO 01/17/2024 CHECK 01/01/2024 CHECK 01/22/2024 CHECK 01/19/2024 CHECK 11/30/2023 CHECK 12/14/2023 CHECK 12/31/2023 CHECK 01/04/2024 CHECK 01/04/2024 CHECK 11/22/2022 11/22/2022 11/21/2022 WARRANT 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 3104 3104 NET 264.50 264.50 175.00 175.00 42,881.57 42,881.57 648.03 648.03 132.00 132.00 6,750.73 6,750.73 157.48 157.48 250.00 250.00 500.00 500.00 41.75 41.75 51.75 01/22/2024 PRTD 1245 HUNTLEY, STEVE 01172024 01/22/2024 PRTD 1361 TULARE KINGS HISPANI 18997-33439 01/22/2024 PRTD 1378 MID VALLEY DISPOSAL M-2024-6 01/22/2024 PRTD 1456 FRANCHISE TAX BOARD 122023 01/22/2024 PRTD 1481 HINDERLITER DELLAMAS SIN034417 01/22/2024 PRTD 1555 METLIFE 121423 01/22/2024 PRTD 1633 PITNEY BOWES 1024409606 01/22/2024 PRTD 1657 LASQUITE, ANTHONY WI 010424 01/22/2024 PRTD 1658 DIAZ, VINCENT A. 010524 01/22/2024 PRTD 1761 AUTOTECH SERVICE CEN 1115507 1115497 1115487 Report generated: 01/22/2024 16:48 user: 6175mame Program ID: apcshdsb 2 Page CITY FARMERSVILLE OF A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME munis atyler erp solution 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE INV DATE PO 11/21/2022 11/21/2022 11/22/2022 CHECK 09/14/2023 CHECK 01/02/2024 CHECK 01/17/2024 01/17/2024 01/17/2024 01/17/2024 01/17/2024 01/17/2024 01/17/2024 01/17/2024 CHECK 01/05/2024 CHECK 12/29/2023 CHECK 01/08/2024 WARRANT 3104 3104 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104. 3104 3104. 3104 3104 3104 3104 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 NET 41.75 41.75 41.75 260.50 169.95 169.95 2,380.85 2,380.85 7,683.25 9,540.85 4,512.73 875.00 612.50 3,150.00 3,882.50 2,660.00 32,916.83 1,149.75 1,149.75 4,249.32 4,249.32 240.00 1115493 1115489 1115512 01/22/2024 PRTD 1854 PROACTIVE ENVIRONMEN 32582 01/22/2024 PRTD 2100 AT&T MOBILITY 1022024 01/22/2024 PRTD 2137 4CREEKS, INC. 23511-30856 23488-30854 23417-30855 23465-30821 23496-30819 23541-30817 23451-30818 23391-308200 01/22/2024 PRTD 2167 ADVANCED BUILDING MA INV19749 01/22/2024 PRTD 2215 SANCHEZ, MATTHEW 122923 01/22/2024 PRTD 2220 JESSE's AUTO GARAGE 3015 Report generated: 01/22/2024 16:48 user: 6175mame Program ID: apcshdsb 3 Page FARMERSVILLE munis atyler erp solution CITY OF A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME 1100 CASH (DUE TO/DUE FROM). VOUCHER INVOICE INV DATE PO CHECK 01/01/2023 CHECK 11/08/2023 09/20/2023 08/31/2023 11/01/2023 01/01/2024 12/15/2023 01/01/2024 11/02/2023 01/01/2024 CHECK 01/01/2024 CHECK 01/04/2024 CHECK 12/29/2023 CHECK 01/04/2024 CHECK 01/04/2024 WARRANT TOTAL: 3104 TOTAL: 3104 3104 3104 3104 3104 3104 3104 3104 3104 NET 240.00 260.00 260.00 3,613.91 543.00 6,607.13 26,479.00 26,479.00 987.34 26,479.00 407.24 13,961.10 01/22/2024 PRTD 2226 INFOARMOR, INC 5537JAN24 22879 22723 22713 22852 22900 22929 22957 22876 22930 01/22/2024 PRTD 2228 CENTRAL CAL WATERWOR TOTAL: 105,556.72 01/22/2024 PRTD 2267 TOWNSEND PUBLIC AFFA 20944 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 5,000.00 5,000.00 725.00 725.00 4,249.32 4,249.32 250.00 250.00 450.00 01/22/2024 PRTD 2295 MOORE, SKYLER Q 010424 01/22/2024 PRTD 2295 MOORE, SKYLER Q 122923 01/22/2024 PRTD 2296 HOPF, LATHAN A. 010424 01/22/2024 PRTD 2311 FLAMING, EMILEE A 010424 Report generated: 01/22/2024 16:48 User: 6175mame Program ID: apcshdsb Page CITY OF FARMERSVILLE A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME munis atyler erp solution 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE INV DATE PO CHECK 01/04/2024 CHECK 01/16/2024 CHECK 11/27/2023 01/09/2024 01/08/2024 12/29/2023 12/21/2023 12/20/2023 CHECK 01/04/2024 CHECK 01/04/2024 CHECK 01/11/2024 CHECK 01/10/2024 CHECK 09/30/2023 WARRANT TOTAL: 3104 TOTAL: 3104 NET 450.00 625.00 625.00 180,736.31 TOTAL: 180,736.31 01/22/2024 PRTD 2319 WEBB, TRAVIN 010424 01/22/2024 PRTD 2385 COMMERCE TRUCK & EQU 011624D 01/22/2024 PRTD 2406 MOORE TWINING ASSOCI 3379004 4135004 4134983 3380324 3380019 3379970 3104 3104 3104 3104 3104 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 258.50 1,250.00 206.00 206.00 206.00 65.00 2,191.50 4,525.00 4,525.00 625.00 625.00 5,453.00 5,453.00 6,999.07 6,999.07 1,516.75 01/22/2024 PRTD 2415 NICKELS, STUART 010424 01/22/2024 PRTD 2429 BENEDETTA, MICHAEL R 010424 01/22/2024 PRTD 2438 AVISON CONSTRUCTION, 9-FREE 01/22/2024 PRTD 2454 HYDROPRO SOLUTIONS 0002448-IN 01/22/2024 PRTD 2467 HOLLOWAY ENVIRONMENT INV-HES-2492 Report generated: 01/22/2024 16:48 User: 6175mame Program ID: apcshdsb 5 Page FARMERSVILLE munis atyler erp solution CITY OF A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE INV DATE PO CHECK 01/04/2024 CHECK 01/04/2024 CHECK 11/29/2023 CHECK 01/30/2023 CHECK 10/27/2023 CHECK 01/17/2024 CHECK 12/09/2023 CHECK 01/12/2024 01/12/2024 CHECK 01/15/2024 01/15/2024 01/15/2024 01/15/2024 WARRANT TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 3104 TOTAL: 3104 3104 3104 3104 NET 1,516.75 500.00 500.00 750.00 750.00 1,457.27 1,457.27 2,906.00 2,906.00 117,189.63 117,189.63 486.87 486.87 6,450.00 6,450.00 360.00 810.00 1,170.00 907.50 3,052.50 95.00 220.54 01/22/2024 PRTD 2489 BOTELLO, DIEGO 010424 01/22/2024 PRTD 2493 SANDOVAL, MARIA 010424 01/22/2024 PRTD 2505 CALPORTLAND COMPANY 96154371 01/22/2024 PRTD 2507 HOPEWELL MANUFACTURI 23085 01/22/2024 PRTD 2511 CLARK EQUIPMENT CO. 27-OCT-23 011724 01/22/2024 PRTD 2512 VELYINES, TEQUIA 01/22/2024 PRTD 2513 BR WELDING AND FABRI INV1311 01/22/2024 PRTD 3602 BILL WALL'S DIRECT A 16836 16834 01/22/2024 PRTD 4399 BLAIS & ASSOCIATES BA-6806-2023 BA-6889-2023 BA-6805-2023 BA-6807-2023 Report generated: 01/22/2024 16:48 user: 6175mame Program ID: apcshdsb Page FARMERSVILLE munis atyler erp solution CITY OF A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE INV DATE PO 01/15/2024 01/15/2024 01/15/2024 CHECK 12/27/2023 CHECK 12/31/2023 CHECK 10/31/2023 CHECK 12/31/2023 CHECK 12/01/2023 01/01/2024 CHECK 01/04/2024 CHECK 11/27/2023 01/04/2024 CHECK 01/18/2023 WARRANT 3104 3104 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 3104 TOTAL: 3104 TOTAL: 3104 3104 TOTAL: 3104 NET 1,437.50 2,600.00 2,296.00 10,609.04 502.04 502.04 10,560.76 10,560.76 57.07 57.07 3,682.62 3,682.62 6,155.42 6,155.42 12,310.84 400.00 400.00 99.00 99.00 198.00 6,742.00 BA-2808-2023 BA-6803-2023 BA-2804-2023 01/22/2024 PRTD 4865 BOYER, PAUL 122723 01/22/2024 PRTD 4867 BOYS & GIRLS CLUB OF 101873 01/22/2024 PRTD 5300 BS&E COMPANY, INC 347496 01/22/2024 PRTD 8300 CITY OF FARMERSVILLE 123123 01/22/2024 PRTD 8399 CITY OF VISALIA AR100126 AR100315 01/22/2024 PRTD 11000 FARIAS, RUBEN 010424 01/22/2024 PRTD 14651 FGL ENVIRONMENTAL 347573A 348696A 01/22/2024 PRTD 24200 LEAGUE OF CALIFORNIA INV-12085-L5P2M Report generated: 01/22/2024 16:48 User: 6175mame Program ID: apcshdsb Page munis atyler erp solution CITY OF FARMERSVILLE A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME 1100 CASH (DUE TO/DUE FROM). VOUCHER INVOICE INV DATE PO CHECK 12/31/2023 CHECK 01/07/2024 CHECK 12/17/2023 CHECK 11/30/2023 CHECK 01/04/2024 01/04/2024 01/04/2024 01/04/2024 01/04/2024 01/04/2024 01/08/2024 CHECK 12/06/2023 01/12/2024 CHECK 01/09/2024 CHECK WARRANT TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 TOTAL: 3104 3104 3104 3104 3104 3104 3104 TOTAL: 3104 3104 TOTAL: 3104 TOTAL: NET 6,742.00 94.11 94.11 318.64 318.64 926.14 926.14 19,922.00 19,922.00 2,211.30 1,823.00 15,272.46 1,929.52 4,634.62 11,848.29 3,511.32 41,230.51 8,874.17 2,142.00 11,016.17 220.00 220.00 01/22/2024 PRTD 31560 OFFICE DEPOT 29225639 01/22/2024 PRTD 34500 AT &T 010724 01/22/2024 PRTD 34634 PITNEY BOWES-PURCHAS 121723 01/22/2024 PRTD 36695 PRICE PAIGE & COMPAN 32201 01/22/2024 PRTD 37000 QUAD KNOPF, INC. 121788 121751 121749 121727 121726 121732 121786 01/22/2024 PRTD 41000 SELF-HELP ENTERPRISE FVLZ1HJUL-OCT23 FVLADM DEC-23 01/22/2024 PRTD 43760 SUN-GAZETTE 712733 Report generated: 01/22/2024 16:48 User: 6175mame Program ID: apcshdsb Page CITY FARMERSVILLE OF A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME munis atyler erps solution 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE INV DATE PO 12/19/2023 CHECK 01/04/2024 CHECK WARRANT 3104 TOTAL: 3104 TOTAL: NET 896.29 896.29 190.05 190.05 01/22/2024 PRTD 51550 VERIZON WIRELESS 9952042621 01/22/2024 PRTD 51550 VERIZON WIRELESS 9953393380 NUMBER OF CHECKS 67 TOTAL PRINTED CHECKS *** CASH ACCOUNT TOTAL *** 672,389.87 COUNT 67 AMOUNT 672,389.87 *** GRAND TOTAL *** 672,389.87 Report generated: 01/22/2024 16:48 user: 6175mame Program ID: apcshdsb Page 9 munis atyler erp solution CITY OF FARMERSVILLE INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3104 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT DOCUMENT INVOICE PO NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE APPROVED UNPAID INVOICES TO BE POSTED 127 00000 QUALITY MUFFLER 47173 CASH 01 ACCT 1100 DEPT w9hld 3104 1,026.73 .00 01425 5205 02425 5205 .00 189372 2024/07 INV 10/05/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 342.24 1099: 342.24 1099: CONDITIONS THAT PREVENT POSTING INVOICE 127/47173 04425 5205 367.50 342.25 1099: .00 626 00000 STRADLING YOCCA 47195 CASH 01 ACCT 1100 DEPT w9hld 3104 .00 04425 5205 403466 2024/07 INV 01/10/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 367.50 1099: CONDITIONS THAT PREVENT POSTING INVOICE 633 00000 CHARTER COMMUNIC 47271 CASH 01 ACCT 1100 DEPT w9hld 626/47195 3104 3,305.64 .00 .00 170047601122123 2024/07 INV 12/21/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCPROFESSIONAL SERVICE 01401 5211 01404 5211 304.58 1099: 127.92 1099: CONDITIONS THAT PREVENT POSTING INVOICE 633/47271 01411 5211 14411 5211 SLESF 01414 5211 01415 5211 01420 5211 01425 5211 02404 5211 02415 5211 02425 5211 04404 5211 04415 5211 04425 5211 06404 5211 06415 5211 06425 5211 21404 5211 21425 5211 35425 5211 974.65 1099: 121.83 1099: 30.46 1099: 60.92 1099: 243.66 1099: 161.43 1099: 149.24 1099: 24.37 1099: 155.33 1099: 143.15 1099: 24.37 1099: 149.24 1099: 30.46 1099: 12.18 1099: 9.14 1099: 6.09 1099: 127.92 1099: 6.09 1099: Report generated: 01/22/2024 16:39 user: 6175mame Program ID: apinvent Page CITY OF FARMERSVILLE INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3104 VENDOR REMIT NAME munis atyler erp solution NEW INVOICES VOUCHER WARRANT DOCUMENT INVOICE PO NET AMOUNT EXCEEDS PO_BY PO BALANCE CHK/WIRE 39425 5211 442.61 1099: .00 769 00000 AMERICAN INCORPO 47248 CASH 01 ACCT 1100 DEPT 990 00000 TERMINIX CASH 01 ACCT 1100 DEPT 990 00000 TERMINIX CASH 01 ACCT 1100 DEPT 1207 00000 PROFESSIONAL PRI 47247 CASH 01 ACCT 1100 DEPT 1234 00000 AUTOZONE CASH 01 ACCT 1100 DEPT w9hld 3104 1,466.00 .00 01425 5205 122.00 7169205 2024/07 INV 12/22/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 1,466.00 1099: .00 47242 441341629 3104 .00 01406 5205 78.00 2024/07 INV 12/13/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PEST CONTROL 47243 441341257 122.00 1099: .00 3104 .00 2024/07 INV 12/13/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PEST CONTROL 01406 5205 78.00 1099: .00 3104 2,364.06 .00 119314 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 02425 5205 04425 5205 06425 5205 29.06 788.02 1099: 788.02 1099: 788.02 1099: .00 47228 3711558270 3104 .00 2024/07 INV 11/20/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01425 5203 02425 5203 10.00 1099: 10.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1242 00001 CALIFORNIA BUSIN 47204 CASH 01 ACCT 1100 DEPT 1245 00000 HUNTLEY, STEVE 47196 CASH 01 ACCT 1100 DEPT 1234/47228 04425 5203 253.65 9.06 1099: .00 3104 .00 338967 2024/07 INV 12/15/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01411 5205 01406 5205 140.75 126.83 1099: 126.82 1099: .00 3104 .00 01404 5208 011724 2024/07 INV 01/17/2024 SEP-CHK: Y DISC: .00 DUE 01/22/2024 DESC:CSJVRMA ANNUAL RETREAT 140.75 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1245/47196 Report generated: 01/22/2024 16:39 User: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erp solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3104 VENDOR REMIT NAME w9hld NEW INVOICES VOUCHER WARRANT DOCUMENT INVOICE PO NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 1245 00000 HUNTLEY, STEVE 47197 CASH 01 ACCT 1100 DEPT w9hld 3104 161.25 .00 01404 5208 .00 11724 2024/07 INV 01/17/2024 SEP-CHK: Y DISC: .00 DUE 01/22/2024 DESC:CARMA ANNUAL RETREAT 161.25 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1245 00000 HUNTLEY, STEVE 47198 CASH 01 ACCT 1100 DEPT w9hld 1245/47197 3104 264.50 .00 .00 01172024 2024/07 INV 01/17/2024 SEP-CHK: Y DISC: .00 DUE 01/22/2024 DESC:CSMFO ANNUAL CONFERENCE 01404 5208 264.50 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1361 00000 TULARE KINGS HIS 47232 CASH 01 ACCT 1100 DEPT w9hld 1245/47198 3104 175.00 .00 .00 18997-33439 2024/07 INV 01/01/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01405 5205 175.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1378 00000 MID VALLEY DISPO 47267 CASH 01 ACCT 1100 DEPT w9hld 1361/47232 3104 42,881.57 .00 .00 62,285.66 1099: -4,620.02 1099: M-2024-6 2024/07 INV 01/22/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:DEC 2023 06425 5205 606425 4004 CONDITIONS THAT PREVENT POSTING INVOICE 1378/47267 606425 4092 606425 4093 606425 4094 648.03 -6,468.03 1099: -3,696.02 1099: -4,620.02 1099: .00 1456 00000 FRANCHISE TAX BO 47239 CASH 01 ACCT 1100 DEPT 3104 .00 122023 2024/07 INV 01/19/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:1211639659 01_2230 648.03 1099: Report generated: 01/22/2024 16:39 user: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erps solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3104 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT 1456/47239 DOCUMENT INVOICE PO NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE CONDITIONS THAT PREVENT POSTING INVOICE 1481 00000 HINDERLITER DELL 47249 CASH 01 ACCT 1100 DEPT w9hld 1555 00000 METLIFE CASH 01 ACCT 1100 DEPT w9hld w9hld 3104 132.00 .00 .00 SIN034417 2024/07 INV 11/30/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01404 5205 132.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1481/47249 47240 121423 3104 6,750.73 .00 .00 2024/07 INV 12/14/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 0ESC01/0124-0/124 01 2335 012233 2,344.76 1099: 4,405.97 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1633 00000 PITNEY BOWES 47245 CASH 01 ACCT 1100 DEPT w9hld 1555/47240 3104 157.48 .00 .00 1024409606 2024/07 INV 12/31/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01406 5205 157.48 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1657 00000 LASQUITE, ANTHON 47180 CASH 01 ACCT 1100 DEPT w9hld 1633/47245 3104 250.00 .00 .00 010424 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCPROFESSIONAL SERVICE 01420 5205 250.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1658 00000 DIAZ, VINCENT A. 47177 CASH 01 ACCT 1100 DEPT 1657/47180 3104 500.00 .00 .00 010524 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01420 5205 500.00 1099: Report generated: 01/22/2024 16:39 user: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erps solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3104 VENDOR REMIT NAME CONDITIONS THAT PREVENT POSTING INVOICE w9hld 1761 00000 AUTOTECH SERVICE 47217 CASH 01 ACCT 1100 DEPT w9hld NEW INVOICES VOUCHER WARRANT 1658/47177 DOCUMENT INVOICE PO NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 3104 41.75 .00 .00 1115507 2024/07 INV 11/22/2022 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01420 5205 41.75 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1761 00000 AUTOTECH SERVICE 47218 CASH 01 ACCT 1100 DEPT w9hld 1761/47217 3104 41.75 .00 .00 1115497 2024/07 INV 11/22/2022 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCIPROFESSIONAL SERVICE 01406 5205 41.75 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1761 00000 AUTOTECH SERVICE 47219 CASH 01 ACCT 1100 DEPT w9hld 1761/47218 3104 51.75 .00 .00 1115487 2024/07 INV 11/21/2022 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCEPAOFESSIONAL SERVICE 01425 5205 02425 5205 17.25 1099: 17.25 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1761 00000 AUTOTECH SERVICE 47220 CASH 01 ACCT 1100 DEPT w9hld 1761/47219 04425 5205 41.75 17.25 1099: .00 3104 .00 1115493 2024/07 INV 11/21/2022 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01425 5205 02425 5205 10.44 1099: 10.44 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1761/47220 04425 5205 21425 5205 10.44 1099: 10.43 1099: Report generated: 01/22/2024 16:39 User: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erps solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3104 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT 3104 DOCUMENT INVOICE PO 1115489 NET AMOUNT EXCEEDS PO_BY PO BALANCE CHK/WIRE 1761 00000 AUTOTECH SERVICE 47221 CASH 01 ACCT 1100 DEPT w9hld 41.75 .00 .00 2024/07 INV 11/21/2022 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCEPAOFESSIONAL SERVICE 01425 5205 02425 5205 10.43 1099: 10.44 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1761/47221 04425 5205 21425 5205 41.75 10.44 1099: 10.44 1099: .00 1761 00000 AUTOTECH SERVICE 47222. CASH 01 ACCT 1100 DEPT w9hld 3104 .00 1115512 2024/07 INV 11/22/2022 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01425 5205 02425 5205 10.43 1099: 10.44 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1761/47222 04425 5205 21425 5205 169.95 10.44 1099: 10.44 1099: .00 1854 00000 PROACTIVE ENVIRO 47189 CASH 01 ACCT 1100 DEPT W9hld 3104 .00 32582 2024/07 INV 09/14/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROPFESSIONAL SERVICE 04425 5205 169.95 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1854/47189 Report generated: 01/22/2024 16:39 user: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erps solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3104 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT 3104 DOCUMENT INVOICE PO 1022024 NET AMOUNT EXCEEDS PO_BY PO BALANCE CHK/WIRE 2100 00001 AT&T MOBILITY 47272 CASH 01 ACCT 1100 DEPT 2,380.85 .00 .00 2024/07 INV 01/02/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01404 5211 01411 5211 14411 5211 SLESF 01415 5211 01420 5211 01425 5211 02404 5211 02415 5211 02425 5211 04404 5211 04415 5211 04425 5211 06404 5211 06415 5211 06425 5211 21404 5211 21425 5211 35425 5211 126.97 1099: 926.09 1099: 94.62 1099: 99.05 1099: 314.79 1099: 132.88 1099: 88.40 1099: 39.62 1099: 133.70 1099: 83.73 1099: 39.62 1099: 129.20 1099: 9.33 1099: 19.81 1099: 14.28 1099: 8.83 1099: 112.67 1099: 7.26 1099: .00 2137 00000 4CREEKS, INC. 47259 CASH 01 ACCT 1100 DEPT w9hld 3104 7,683.25 .00 23511-30856 2024/07 INV 01/17/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCEPROFESSIONAL SERVICE 01414 5205 7,683.25 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2137 00000 4CREEKS, INC. 47260 CASH 01 ACCT 1100 DEPT w9hld 2137/47259 3104 9,540.85 .00 .00 9,540.85 1099: 23488-30854 2024/07 INV 01/17/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCEPROFESSIONAL SERVICE 01414 5205 CONDITIONS THAT PREVENT POSTING INVOICE 2137 00000 4CREEKS, INC. 47261 CASH 01 ACCT 1100 DEPT 2137/47260 3104 4,512.73 .00 12400 5516 CCLGP .00 4,512.73 1099: 23417-30855 2024/07 INV 01/17/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:CCLGP-PROFESSIONAL SERVICE CONDITIONS THAT PREVENT POSTING INVOICE 2137/47261 Report generated: 01/22/2024 16:39 user: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erps solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3104 VENDOR REMIT NAME w9hld NEW INVOICES VOUCHER WARRANT DOCUMENT INVOICE PO NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 2137 00000 4CREEKS, INC. 47262 CASH 01 ACCT 1100 DEPT w9hld 3104 875.00 .00 72420 5516 STATN .00 23465-30821 2024/07 INV 01/17/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:STATN-PROFESSIONAL SERVICE 875.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2137 00000 4CREEKS, INC. 47263 CASH 01 ACCT 1100 DEPT w9hld 2137/47262 3104 612.50 .00 .00 23496-30819 2024/07 INV 01/17/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01414 5205 612.50 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2137 00000 4CREEKS, INC. 47264 CASH 01 ACCT 1100 DEPT w9hld 2137/47263 3104. 3,150.00 .00 02425 5516 BIRCH .00 23541-30817 2024/07 INV 01/17/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:BIRCH-PROFESSIONAL SERVICE 3,150.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2137 00000 4CREEKS, INC. 47265 CASH 01 ACCT 1100 DEPT w9hld 2137/47264 3104 3,882.50 .00 .00 23451-30818 2024/07 INV 01/17/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROPFESSIONAL SERVICE 01414 5205 3,882.50 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2137 00000 4CREEKS, INC. 47266 CASH 01 ACCT 1100 DEPT w9hld 2137/47265 3104 2,660.00 .00 .00 23391-308200 2024/07 INV 01/17/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01414 5205 01414 5205 1,872.50 1099: 700.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2137/47266 Report generated: 01/22/2024 16:39 user: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erps solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3104 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT DOCUMENT INVOICE PO NET AMOUNT EXCEEDS PO_BY PO BALANCE CHK/WIRE 01414 5205 87.50 1099: .00 2167 00000 ADVANCED BUILDIN 47214 CASH 01 ACCT 1100 DEPT w9hld 3104 1,149.75 .00 INV19749 2024/07 INV 01/05/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:JAN 2024 SERVICE 01406 5205 1,149.75 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2215 00000 SANCHEZ, MATTHEW 47170 CASH 01 ACCT 1100 DEPT w9hld 2167/47214 3104 4,249.32 .00 .00 122923 2024/07 INV 12/29/2023 SEP-CHK: Y DISC: .00 DUE 01/22/2024 DESC:RABBIT FIRE 72420 5205 4,249.32 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2220 00000 JESSE'S AUTO GAR 47230 CASH 01 ACCT 1100 DEPT w9hld 2215/47170 3104 240.00 .00 .00 3015 2024/07 INV 01/08/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01425 5205 02425 5205 60.00 1099: 60.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2220/47230 04425 5205 21425 5205 260.00 60.00 1099: 60.00 1099: .00 2226 00000 INFOARMOR, INC 47223 CASH 01 ACCT 1100 DEPT w9hld 3104 .00 5537JAN24 2024/07 INV 01/01/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCEPAOFESSIONAL SERVICE 01404 5205 260.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2228 00000 CENTRAL CAL WATE 47190 CASH 01 ACCT 1100 DEPT 2226/47223 3104 3,613.91 .00 .00 22879 2024/07 INV 11/08/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCEPROFESSIONAL SERVICE 04425 5205 3,613.91 1099: Report generated: 01/22/2024 16:39 User: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erps solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3104 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT 3104 DOCUMENT INVOICE PO 22723 NET AMOUNT EXCEEDS PO BY PO_BALANCE CHK/WIRE 2228 00000 CENTRAL CAL WATE 47191 CASH 01 ACCT 1100 DEPT 2228 00000 CENTRAL CAL WATE 47192 CASH 01 ACCT 1100 DEPT 2228 00000 CENTRAL CAL WATE 47209 CASH 01 ACCT 1100 DEPT 2228 00000 CENTRAL CAL WATE 47210 CASH 01 ACCT 1100 DEPT 2228 00000 CENTRAL CAL WATE 47211 CASH 01 ACCT 1100 DEPT 2228 00000 CENTRAL CAL WATE 47212 CASH 01 ACCT 1100 DEPT 2228 00000 CENTRAL CAL WATE 47213 CASH 01 ACCT 1100 DEPT 2228 00000 CENTRAL CAL WATE 47237 CASH 01 ACCT 1100 DEPT 543.00 .00 04425 5205 .00 2024/07 INV 09/20/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 543.00 1099: .00 3104 6,607.13 .00 04425 5205 22713 2024/07 INV 08/31/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 6,607.13 1099: .00 23,639.50 1099: 2,839.50 1099: .00 23,639.50 1099: 2,839.50 1099: .00 3104 26,479.00 .00 22852 2024/07 INV 11/01/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 04425 5205 02425 5205 3104 26,479.00 .00 22900 2024/07 INV 01/01/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 04425 5205 02425 5205 987.34 3104 .00 22929 2024/07 INV 12/15/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 04425 5205 987.34 1099: .00 23,639.50 1099: 2,839.50 1099: .00 3104 26,479.00 .00 22957 2024/07 INV 01/01/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 04425 5205 02425 5205 407.24 3104 .00 22876 2024/07 INV 11/02/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 04425 5205 407.24 1099: .00 13,961.10 1099: 3104 13,961.10 .00 22930 2024/07 INV 01/01/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 04425 5205 Report generated: 01/22/2024 16:39 user: 6175mame Program ID: apinvent Page FARMERSVILLE munis tyler erps solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3104 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT 3104 DOCUMENT INVOICE PO 20944 NET AMOUNT EXCEEDS PO_BY PO BALANCE CHK/WIRE 2267 00000 TOWNSEND PUBLIC 47215 CASH 01 ACCT 1100 DEPT 2295 00000 MOORE, SKYLER Q 47169 CASH 01 ACCT 1100 DEPT w9hld 5,000.00 .00 01404 5205 .00 2024/07 INV 01/01/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 5,000.00 1099: .00 3104 4,249.32 .00 72420 5205 122923 2024/07 INV 12/29/2023 SEP-CHK: Y DISC: .00 DUE 01/22/2024 DESC:RABBIT FIRE 4,249.32 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2295 00000 MOORE, SKYLER Q 47181. CASH 01 ACCT 1100 DEPT w9hld 2295/47169 3104 725.00 .00 01420 5205 .00 010424 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCPROFESSIONAL SERVICE 725.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2296 00000 HOPF, LATHAN A 47179 CASH 01 ACCT 1100 DEPT w9hld 2295/47181 3104 250.00 .00 .00 010424 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01420 5205 250.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2311 00000 FLAMING, EMILEE 47178 CASH 01 ACCT 1100 DEPT w9hld 2296/47179 3104 450.00 .00 .00 010424 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROPFESSIONAL SERVICE 01420 5205 450.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2311/47178 Report generated: 01/22/2024 16:39 user: 6175mame Program ID: apinvent Page CITY OF FARMERSVILLE INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3104 MENDOR REMIT NAME munis atyler erps solution NEW INVOICES VOUCHER WARRANT 3104 DOCUMENT INVOICE PO 010424 NET AMOUNT EXCEEDS POE BY PO BALANCE CHK/WIRE 2319 00000 WEBB, TRAVIN 47184 CASH 01 ACCT 1100 DEPT w9hld 625.00 .00 .00 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCEPAOFESSIONAL SERVICE 01420 5205 625.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2385 00000 COMMERCE TRUCK & 47186 CASH 01 ACCT 1100 DEPT w9hld 2319/47184 3104 180,736.31 .00 .00 180,736.31 1099: 011624D 2024/07 INV 01/16/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:BUCKET TRUCK 60425 5504 CONDITIONS THAT PREVENT POSTING INVOICE 2406 00000 MOORE TWINING AS 47194 CASH 01 ACCT 1100 DEPT 2406 00000 MOORE TWINING AS 47206 CASH 01 ACCT 1100 DEPT 2406 00000 MOORE TWINING AS 47207 CASH 01 ACCT 1100 DEPT 2406 00000 MOORE TWINING AS 47234 CASH 01 ACCT 1100 DEPT 2406 00000 MOORE TWINING AS 47235 CASH 01 ACCT 1100 DEPT 2385/47186 3104 258.50 .00 .00 3379004 2024/07 INV 11/27/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCEPROFESSIONAL SERVICE 04425 5205 258.50 1099: .00 3104 1,250.00 .00 4135004 2024/07 INV 01/09/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 04425 5205 206.00 1,250.00 1099: .00 3104 .00 04425 5205 206.00 4134983 2024/07 INV 01/08/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 206.00 1099: .00 3104 .00 3380324 2024/07 INV 12/29/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCIPROFESSIONAL SERVICE 04425 5205 206.00 206.00 1099: .00 3104 .00 3380019 2024/07 INV 12/21/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 04425 5205 206.00 1099: Report generated: 01/22/2024 16:39 user: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erp solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3104 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT 3104. DOCUMENT INVOICE PO 3379970 NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 2406 00000 MOORE TWINING AS 47236 CASH 01 ACCT 1100 DEPT 2415 00000 NICKELS, STUART 47182 CASH 01 ACCT 1100 DEPT w9hld 65.00 .00 .00 2024/07 INV 12/20/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCEPROFESSIONAL SERVICE 04425 5205 65.00 1099: .00 3104 4,525.00 .00 010424 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCPROFESSIONAL SERVICE 01420 5205 4,525.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2429 00000 BENEDETTA, MICHA 47175 CASH 01 ACCT 1100 DEPT 2438 00000 AVISON CONSTRUCT 47216 CASH 01 ACCT 1100 DEPT w9hld 2415/47182 3104 625.00 .00 .00 010424 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01420 5205 625.00 1099: .00 5,740.00 1099: -287.00 1099: 3104 5,453.00 .00 31425 5516 FREE 312245 FREE 9-FREE 2024/07 INV 01/11/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:FREE-PROFESSIONAL SERVICE CONDITIONS THAT PREVENT POSTING INVOICE 2454 00000 HYDROPRO SOLUTIO 47208 CASH 01 ACCT 1100 DEPT 2467 00000 HOLLOWAY ENVIRON 47205 CASH 01 ACCT 1100 DEPT w9hld 2438/47216 3104 6,999.07 .00 02425 5203 .00 0002448-IN 2024/07 INV 01/10/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 6,999.07 1099: .00 3104 1,516.75 .00 INV-HES-2492 2024/07 INV 09/30/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCPROFESSIONAL SERVICE 04425 5205 1,516.75 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2467/47205 Report generated: 01/22/2024 16:39 user: 6175mame Program ID: apinvent Page munis atyler erp solution CITY OF FARMERSVILLE INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3104 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT 3104 DOCUMENT INVOICE PO 010424 NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 2489 00000 BOTELLO, DIEGO 47176 CASH 01 ACCT 1100 DEPT w9hld 500.00 .00 .00 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCPROFESSIONAL SERVICE 01420 5205 500.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2493 00000 SANDOVAL, MARIA 47183 CASH 01 ACCT 1100 DEPT w9hld 2489/47176 3104 750.00 .00 .00 010424 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCEPROFESSIONAL SERVICE 01420 5205 750.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2505 00000 CALPORTLAND COMP 47229 CASH 01 ACCT 1100 DEPT 2507 00000 HOPEWELL MANUFAC 47238 CASH 01 ACCT 1100 DEPT w9hld 2493/47183 3104 1,457.27 .00 31425 5516 ROYPK .00 96154371 2024/07 INV 11/29/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:ROYPK-PROFESSIONAL SERVICE 1,457.27 1099: .00 3104 2,906.00 .00 31425 5516 FREE 23085 2024/07 INV 01/30/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:FREE-PROFESSIONAL SERVICE 2,906.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2511 00000 CLARK EQUIPMENT 47188 CASH 01 ACCT 1100 DEPT 2507/47238 3104 117,189.63 .00 .00 39,063.21 1099: 39,063.21 1099: 39,063.21 1099: .00 27-OCT-23 2024/07 INV 10/27/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 02425 5504 04425 5504 103425 5504 486.87 2512 00000 VELYINES, TEQUIA 47199 CASH 01 ACCT 1100 DEPT 3104 .00 011724 2024/07 INV 01/17/2024 SEP-CHK: N DISC: .00 01404 5208 486.87 1099: DUE 01/22/2024 DESC:LCW ANNUAL PUBLIC SECTOR CONFERENCE CONDITIONS THAT PREVENT POSTING INVOICE 2512/47199 Report generated: 01/22/2024 16:39 user: 6175mame Program ID: apinvent Page CITY FARMERSVILLE OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3104 VENDOR REMIT NAME w9hld munis atyler erp solution NEW INVOICES VOUCHER WARRANT DOCUMENT INVOICE PO NET AMOUNT EXCEEDS PO_BY PO BALANCE CHK/WIRE 2513 00000 BR WELDING AND F 47231 CASH 01 ACCT 1100 DEPT 3602 00000 BILL WALL's DIRE 47201 CASH 01 ACCT 1100 DEPT 3602 00000 BILL WALL's DIRE 47202 CASH 01 ACCT 1100 DEPT 4399 00001 BLAIS & ASSOCIAT 47252. CASH 01 ACCT 1100 DEPT 4399 00001 BLAIS & ASSOCIAT 47253 CASH 01 ACCT 1100 DEPT 4399 00001 BLAIS & ASSOCIAT 47254 CASH 01 ACCT 1100 DEPT 4399 00001 BLAIS & ASSOCIAT 47255 CASH 01 ACCT 1100 DEPT 4399 00001 BLAIS & ASSOCIAT 47256 CASH 01 ACCT 1100 DEPT 3104 6,450.00 .00 .00 INV1311 2024/07 INV 12/09/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01420 5504 360.00 6,450.00 1099: .00 3104 .00 16836 2024/07 INV 01/12/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:CONSULTING 16834 01406 5205 810.00 360.00 1099:0 .00 3104 .00 2024/07 INV 01/12/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:CONSULTING BA-6806-2023 01406 5205 907.50 810.00 1099:0 .00 3104 .00 12400 5516 ALLEY 2024/07 INV 01/15/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:ALLEY-PROFESSIONAL SERVICE 907.50 1099: .00 3104 3,052.50 .00 31425 5516 FREE BA-6889-2023 2024/07 INV 01/15/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:FREE-PROFESSIONAL SERVICE 3,052.50 1099: .00 3104 95.00 .00 12400 5205 SB2DT BA-6805-2023 2024/07 INV 01/15/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:SB2DT-PROFESSIONAL SERVICE 95.00 1099: .00 3104 220.54 .00 12400 5205 LEAP BA-6807-2023 2024/07 INV 01/15/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:LEAP-PROFESSIONAL SERVICE 220.54 1099: .00 3104 1,437.50 .00 12400 5516 CCLGP BA-2808-2023 2024/07 INV 01/15/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:CCLGP-PROFESSIONAL SERVICE 1,437.50 1099: Report generated: 01/22/2024 16:39 user: 6175mame Program ID: apinvent Page FARMERSVILLE munis alyler erp solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3104 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT 3104 DOCUMENT INVOICE PO BA-6803-2023 NET_AMOUNT EXCEEDS PO_BY PO BALANCE CHK/WIRE 4399 00001 BLAIS & ASSOCIAT 47257 CASH 01 ACCT 1100 DEPT 4399 00001 BLAIS & ASSOCIAT 47258 CASH 01 ACCT 1100 DEPT 4865 00000 BOYER, PAUL 47273 CASH 01 ACCT 1100 DEPT 4867 00000 BOYS & GIRLS CLU 47225 CASH 01 ACCT 1100 DEPT 5300 00000 B S&E COMPANY, 47227 CASH 01 ACCT 1100 DEPT 2,600.00 .00 .00 2024/07 INV 01/15/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01414 5205 2,600.00 1099: .00 2,296.00 1099: .00 3104 2,296.00 .00 01414 5205 502.04 BA-2804-2023 2024/07 INV 01/15/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 3104 .00 122723 2024/07 INV 12/27/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:JAN 24-26 101873 01401 5208 502.04 1099: .00 10,560.76 1099: .00 3104 10,560.76 .00 2024/07 INV 12/31/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01414 5205 57.07 3104 .00 347496 2024/07 INV 10/31/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01425 5203 02425 5203 21425 5203 20.00 1099: 20.00 1099: 17.07 1099: .00 8300 00000 CITY OF FARMERSV 47268 CASH 01 ACCT 1100 DEPT 3104 3,682.62 .00 123123 2024/07 INV 12/31/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01420 5206 01425 5206 01406 5206 01425 5206 01406 5206 39425 5206 39425 5206 83.93 1099: 1,169.10 1099: 236.26 1099: 1,044.98 1099: 905.21 1099: 82.89 1099: 160.25 1099: .00 6,155.42 1099: 8399 00001 CITY OF VISALIA 47171 CASH 01 ACCT 1100 DEPT 3104 6,155.42 .00 01426 5205 AR100126 2024/07 INV 12/01/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:DEC 2023 ANIMAL SERVICE Report generated: 01/22/2024 16:39 user: 6175mame Program ID: apinvent 16 Page FARMERSVILLE munis atyler erp solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3104 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT 3104 DOCUMENT INVOICE PO AR100315 NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 8399 00001 CITY OF VISALIA 47172 CASH 01 ACCT 1100 DEPT 11000 00000 FARIAS, RUBEN 47185 CASH 01 ACCT 1100 DEPT 14651 00000 FGL ENVIRONMENTA 47193 CASH 01 ACCT 1100 DEPT 14651 00000 FGL ENVIRONMENTA 47233 CASH 01 ACCT 1100 DEPT 24200 00001 LEAGUE OF CALIFO 47224 CASH 01 ACCT 1100 DEPT 31560 00001 OFFICE DEPOT 47244 CASH 01 ACCT 1100 DEPT 34500 00001 AT &T CASH 01 ACCT 1100 DEPT 6,155.42 .00 .00 2024/07 INV 01/01/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:JAN2024 ANIMAL SERVICE 01426 5205 400.00 6,155.42 1099: .00 3104 .00 010424 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01420 5205 99.00 400.00 1099:0 .00 3104 .00 347573A 2024/07 INV 11/27/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 02425 5205 99.00 99.00 1099: .00 3104 .00 348696A 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 02425 5202 99.00 1099: .00 6,742.00 1099: .00 DUE 01/22/2024 DESC:PROFESSIONAL ERVICEPAOFESSIONAL SERVICE 3104 6,742.00 .00 INV-12085-L5P2M9 2024/07 INV 01/18/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01405 5205 94.11 3104 .00 29225639 47269 010724 2024/07 INV 12/31/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:OFFICE SUPPLIES 01406 5201 318.64 94.11 1099: .00 3104 .00 2024/07 INV 01/07/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01411 5211 01406 5211 01420 5211 01415 5211 39425 5211 04425 5211 92.96 1099: 110.69 1099: 18.45 1099: 38.04 1099: 29.25 1099: 29.25 1099: Report generated: 01/22/2024 16:39 User: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erps solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3104 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT 3104 DOCUMENT INVOICE PO 121723 NET AMOUNT EXCEEDS PO_BY PO BALANCE CHK/WIRE 34634 00001 PITNEY BOWES-PUR 47246 CASH 01 ACCT 1100 DEPT 36695 00000 PRICE PAIGE & CO 47226 CASH 01 ACCT 1100 DEPT 37000 00001 QUAD KNOPF, INC. 47163 CASH 01 ACCT 1100 DEPT 37000 00001 QUAD KNOPF, INC. 47164 CASH 01 ACCT 1100 DEPT 37000 00001 QUAD KNOPF, INC. 47165 CASH 01 ACCT 1100 DEPT 37000 00001 QUAD KNOPF, INC. 47166 CASH 01 ACCT 1100 DEPT 37000 00001 QUAD KNOPF, INC. 47167 CASH 01 ACCT 1100 DEPT 37000 00001 QUAD KNOPF, INC. 47168 CASH 01 ACCT 1100 DEPT 926.14 .00 01406 5205 .00 2024/07 INV 12/17/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCEPROFESSIONAL SERVICE 926.14 1099: .00 17,942.00 1099: 1,980.00 1099: .00 3104 19,922.00 .00 32201 2024/07 INV 11/30/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01406 5205 21425 5205 3104 2,211.30 .00 121788 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PROFESSIONAL SERVICE 01414 5205 2,211.30 1099: .00 3104 1,823.00 .00 60425 5504 PUMP 121751 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PUMP-PROFESSIONAL SERVICE 1,823.00 1099: .00 15,272.46 1099: .00 3104 15,272.46 .00 12400 5516 CCLGP 121749 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:CCLGP-PROFESSIONAL SERVICE 3104 1,929.52 .00 72420 5516 STATN 121727 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:STATN-PROFESSIONAL SERVICE 1,929.52 1099: .00 4,634.62 1099: .00 11,848.29 1099: 3104 4,634.62 .00 22425 5516 PMPY1 121726 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:PMPY1-PROFESSIONAL SERVICE 3104 11,848.29 .00 31425 5516 FREE 121732 2024/07 INV 01/04/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:FREE-PROFESSIONAL SERVICE Report generated: 01/22/2024 16:39 user: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erp solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3104 MENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT 3104 DOCUMENT INVOICE PO 121786 NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 37000 00001 QUAD KNOPF, INC. 47174 CASH 01 ACCT 1100 DEPT 41000 00000 SELF-HELP ENTERP 47200 CASH 01 ACCT 1100 DEPT 41000 00000 SELF-HELP ENTERP 47251 CASH 01 ACCT 1100 DEPT 43760 00000 SUN-GAZETTE 47187 CASH 01 ACCT 1100 DEPT 51550 00001 VERIZON WIRELESS 47250 CASH 01 ACCT 1100 DEPT 3,511.32 .00 103425 5205 ADAFX .00 2024/07 INV 01/08/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESC:ADAFX-PROFESSIONAL SERVICE 3,511.32 1099: .00 8,874.17 1099: .00 3104 8,874.17 .00 12400 5205 0004 FVLZIHJUL-OCI25 2024/07 INV 12/06/2023 SEP-CHK: N DISC: .00 DUE 01/22/2024 0ESC:O0OA-PROPESSIONA SERVICE 3104 2,142.00 .00 FVLADM DEC-23 2024/07 INV 01/12/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCEPROFESSIONAL SERVICE 01414 5205 220.00 2,142.00 1099: .00 3104 .00 712733 2024/07 INV 01/09/2024 SEP-CHK: N DISC: .00 DUE 01/22/2024 DESCEPROFESSIONAL SERVICE 01414 5205 896.29 220.00 1099: .00 3104 .00 9952042621 2024/07 INV 12/19/2023 SEP-CHK: Y DISC: .00 DUE 01/22/2024 DESCEPROFESSIONAL SERVICE 01411 5211 04425 5211 01420 5211 190.05 597.52 1099: 85.36 1099: 213.41 1099: .00 51550 00001 VERIZON WIRELESS 47270 CASH 01 ACCT 1100 DEPT 3104 .00 01411 5211 01415 5211 9953393380 2024/07 INV 01/04/2024 SEP-CHK: Y DISC: .00 DUE 01/22/2024 DESCEPROFESSIONAL SERVICE 152.04 1099: 38.01 1099: 109 APPROVED UNPAID INVOICES 109 INVOICE(S) TOTAL 672,389.87 672,389.87 REPORT POST TOTAL Report generated: 01/22/2024 16:39 user: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erp solution CITY OF A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE 122623 INV DATE PO 12/26/2023 CHECK WARRANT ACH3111 TOTAL: NET 16,782.79 16,782.79 16,782.79 01/30/2024 PRTD 1211 US BANK NUMBER OF CHECKS 1 TOTAL PRINTED CHECKS *** CASH ACCOUNT TOTAL *** COUNT AMOUNT 16,782.79 *** GRAND TOTAL *** 16,782.79 Report generated: 01/30/2024 15:39 User: 6175mame Program ID: apcshdsb 1 Page FARMERSVILLE munis atyler erp solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3111 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT DOCUMENT INVOICE PO NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE APPROVED UNPAID INVOICES TO BE POSTED Report generated: 01/30/2024 15:28 user: 6175mame Program ID: apinvent 1 Page CITY OF FARMERSVILLE INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3111 VENDOR REMIT NAME 1211 00001 US BANK CASH 01 ACCT 1100 DEPT w9hld munis atyler erp solution NEW INVOICES VOUCHER WARRANT ACH3111 DOCUMENT INVOICE PO 47274 122623 NET AMOUNT EXCEEDS PO_BY PO_BALANCE CHK/WIRE 16,782.79 .00 .00 2024/07 INV 12/26/2023 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:MONTHL BILLING 01420 5205 01420 5504 15.00 1099: 1,421.21 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1211/47274 01420 5205 01420 5202 01420 5205 01420 5203 01420 5208 01420 5504 01420 5208 01420 5202 01411 5202 01411 5204 01411 5204 01411 5202 01411 5504 01411 5504 01411 5202 01411 5202 01411 5205 01411 5204 01411 5202 31425 5516 ROYPK 31425 5516 ROYPK 60404 5516 ROY2 01420 5202 01406 5205 31425 5516 ROYPK 60404 5516 ROY2 01425 5203 01425 5203 01425 5203 01425 5203 02425 5203 04425 5203 01420 5205 01420 5205 01406 5205 01415 5205 01406 5205 01406 5205 01406 5205 01406 5205 01406 5205 175.00 1099: 54.98 1099: 212.53 1099: 19.30 1099: 205.66 1099: 671.53 1099: 99.00 1099: 47.08 1099: 59.20 1099: 179.00 1099: 390.06 1099: 53.00 1099: 355.64 1099: 375.64 1099: 17.85 1099: 75.00 1099: 56.65 1099: 18.87 1099: 29.35 1099: 954.26 1099: 1,000.00 1099: 1,026.78 1099: 78.94 1099: 275.08 1099: 56.68 1099: 50.00 1099: 297.00 1099: 73.28 1099: 177.20 1099: 5.00 1099: 5.00 1099: 4.89 1099: 189.71 1099: 26.07 1099: 108.76 1099: 10.86 1099: 88.79 1099: 40.77 1099: 2.31 1099: 39.90 1099: 8.69 1099: Report generated: 01/30/2024 15:28 User: 6175mame Program ID: apinvent Page 2 CITY FARMERSVILLE OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3111 VENDOR REMIT NAME munis atyler erp solution NEW INVOICES VOUCHER WARRANT DOCUMENT INVOICE PO NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 01406 5205 01406 5205 01406 5205 01406 5205 01414 5205 01401 5205 01406 5205 01404 5205 01401 5205 01404 5205 01404 5205 01404 5208 01420 5202 01420 5202 01420 5203 01420 5203 01420 5203 01401 5208 01420 5202 01420 5205 01420 5202 01420 5203 01420 5202 01420 5203 01420 5202 01420 5202 01420 5202 01404 5205 31425 5516 ROYPK 01425 5203 01425 5203 01415 5205 01415 5205 60404 5516 ROY2 01425 5203 01425 5203 01411 5203 01414 5205 DEVLP 01404 5208 01420 5202 01411 5201 01411 5504 01411 5208 01411 5202 01411 5202 5.42 1099: 160.00 1099: 80.00 1099: 90.98 1099: 14.99 1099: 59.68 1099: 388.50 1099: 108.70 1099: 28.75 1099: 110.01 1099: 860.45 1099: 671.87 1099: 36.70 1099: 29.28 1099: 26.09 1099: 9.40 1099: 26.09 1099: 675.00 1099: 326.24 1099: 30.00 1099: 23.54 1099: 272.18 1099: 141.60 1099: 330.95 1099: 44.86 1099: 59.00 1099: 29.20 1099: 48.34 1099: 21.14 1099: 199.16 1099: 207.69 1099: 7.49 1099: 326.24 1099: 987.91 1099: 10.40 1099: 10.88 1099: 33.05 1099: 500.00 1099: 81.88 1099: 19.55 1099: 18.48 1099: 191.10 1099: 237.80 1099: 46.09 1099: 144.59 1099: 1 APPROVED UNPAID INVOICES TOTAL 16,782.79 Report user: generated: 01/30/2024 6175mame 15:28 Program ID: apinvent Page 3 munis atyler erp solution CITY OF FARMERSVILLE A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE 013024 INV DATE PO 01/30/2024 CHECK 01/30/2024 CHECK 01/30/2024 CHECK 01/30/2024 CHECK 01/30/2024 CHECK 01/30/2024 CHECK 01/30/2024 CHECK 01/30/2024 CHECK 01/30/2024 CHECK 01/30/2024 CHECK WARRANT ACH3112 TOTAL: ACH3112 TOTAL: ACH3112 TOTAL: ACH3112 TOTAL: ACH3112 TOTAL: ACH3112 TOTAL: ACH3112 TOTAL: ACH3112 TOTAL: ACH3112 TOTAL: ACH3112 TOTAL: NET 110.00 110.00 270.00 270.00 30.00 30.00 400.00 400.00 420.00 420.00 330.00 330.00 1,660.00 1,660.00 200.00 200.00 380.00 380.00 40.00 40.00 01/30/2024 PRTD 849 MURILLO, J0SE ULISES 01/30/2024 PRTD 1365 HAYASHI, CHASEN 013024 01/30/2024 PRTD 1615 DIAZ, BRENDAN MICHAE 013024 01/30/2024 PRTD 1657 LASQUITE, ANTHONY WI 013024 01/30/2024 PRTD 1658 DIAZ, VINCENT A. 013024 01/30/2024 PRTD 2215 SANCHEZ, MATTHEW 013024 01/30/2024 PRTD 2295 MOORE, SKYLER Q 013024 01/30/2024 PRTD 2296 HOPF, LATHAN A 013024 01/30/2024 PRTD 2311 FLAMING, EMILEE A 013024 01/30/2024 PRTD 2314 LOKEY, MICHAEL 013024 Report generated: 01/30/2024 16:34 User: 6175mame Program ID: apcshdsb Page FARMERSVILLE munis atyler erps solution CITY OF A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE INV DATE PO 01/30/2024 CHECK 01/30/2024 CHECK 01/30/2024 CHECK 01/30/2024 CHECK 01/30/2024 CHECK 01/30/2024 CHECK 01/30/2024 CHECK 01/30/2024 CHECK 01/30/2024 CHECK 01/30/2024 CHECK WARRANT ACH3112 TOTAL: ACH3112 TOTAL: ACH3112 TOTAL: ACH3112 TOTAL: ACH3112 TOTAL: ACH3112 TOTAL: ACH3112 TOTAL: ACH3112 TOTAL: ACH3112 TOTAL: ACH3112 TOTAL: NET 580.00 580.00 230.00 230.00 320.00 320.00 1,410.00 1,410.00 1,030.00 1,030.00 130.00 130.00 160.00 160.00 190.00 190.00 640.00 640.00 390.00 390.00 01/30/2024 PRTD 2319 WEBB, TRAVIN 013024 01/30/2024 PRTD 2388 JEFFRIES, CHRISTOPHE 013024 01/30/2024 PRTD 2390 RIOS, OMERO 013024 01/30/2024 PRTD 2415 NICKELS, STUART 013024 01/30/2024 PRTD 2429 BENEDETTA, MICHAEL R 013024 01/30/2024 PRTD 2439 PRICE, CRAIG 013024 01/30/2024 PRTD 2441 METCHIKOFF, MATT 013024 01/30/2024 PRTD 2459 ACEVEDO, JESUS 013024 01/30/2024 PRTD 2489 BOTELLO, DIEGO 013024 01/30/2024 PRTD 2493 SANDOVAL, MARIA 013024 Report generated: 01/30/2024 16:34 user: 6175mame Program ID: apcshdsb Page 2 CITY OF FARMERSVILLE A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME munis atyler erps solution 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE INV DATE PO 01/30/2024 CHECK 01/30/2024 CHECK *** CASH ACCOUNT TOTAL *** WARRANT ACH3112 TOTAL: ACH3112 TOTAL: NET 200.00 200.00 300.00 300.00 9,420.00 01/30/2024 PRTD 2497 CRUZ, ALEXIS VARGAS 013024 01/30/2024 PRTD 11000 FARIAS, RUBEN 013024 NUMBER OF CHECKS 22 TOTAL PRINTED CHECKS COUNT Z2 AMOUNT 9,420.00 *** GRAND TOTAL *** 9,420.00 Report generated: 01/30/2024 16:34 User: 6175mame Program ID: apcshdsb 3 Page FARMERSVILLE munis atyler erp solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3112 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT DOCUMENT INVOICE PO NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE APPROVED UNPAID INVOICES TO BE POSTED 849 00000 MURILLO, JOSE UL 47281 CASH 01 ACCT 1100 DEPT w9hld ACH3112 110.00 .00 01420 5205 .00 013024 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 110.00 1099:0 CONDITIONS THAT PREVENT POSTING INVOICE 1365 00000 HAYASHI, CHASEN 47288 CASH 01 ACCT 1100 DEPT w9hld 849/47281 ACH3112 270.00 .00 01420 5205 .00 013024 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 270.00 1099:0 CONDITIONS THAT PREVENT POSTING INVOICE 1615 00000 DIAZ, BRENDAN MI 47292 CASH 01 ACCT 1100 DEPT w9hld 1365/47288 ACH3112 30.00 .00 .00 013024 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 01420 5205 30.00 1099:0 CONDITIONS THAT PREVENT POSTING INVOICE 1657 00000 LASQUITE, ANTHON 47285 CASH 01 ACCT 1100 DEPT w9hld 1615/47292 ACH3112 400.00 .00 .00 013024 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 01420 5205 400.00 1099:0 CONDITIONS THAT PREVENT POSTING INVOICE 1658 00000 DIAZ, VINCENT A. 47291 CASH 01 ACCT 1100 DEPT 1657/47285 ACH3112 420.00 .00 .00 013024 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 01420 5205 420.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1658/47291 Report generated: 01/30/2024 16:29 user: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erp solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3112 VENDOR REMIT NAME w9hld NEW INVOICES VOUCHER WARRANT DOCUMENT INVOICE PO NET AMOUNT EXCEEDS PO BY PO_BALANCE CHK/WIRE 2215 00000 SANCHEZ, MATTHEW 47277 CASH 01 ACCT 1100 DEPT w9hld ACH3112 330.00 .00 .00 013024 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 01420 5205 330.00 1099:0 CONDITIONS THAT PREVENT POSTING INVOICE 2295 00000 MOORE, SKYLER Q 47282 CASH 01 ACCT 1100 DEPT w9hld 2215/47277 ACH3112 1,660.00 .00 01420 5205 .00 013024 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 1,660.00 1099:0 CONDITIONS THAT PREVENT POSTING INVOICE 2296 00000 HOPF, LATHAN A 47287 CASH 01 ACCT 1100 DEPT w9hld 2295/47282 ACH3112 200.00 .00 .00 013024 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 01420 5205 200.00 1099:0 CONDITIONS THAT PREVENT POSTING INVOICE 2311 00000 FLAMING, EMILEE 47289 CASH 01 ACCT 1100 DEPT w9hld 2296/47287 ACH3112 380.00 .00 .00 013024 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 01420 5205 380.00 1099:0 CONDITIONS THAT PREVENT POSTING INVOICE 2314 00000 LOKEY, MICHAEL 47284 CASH 01 ACCT 1100 DEPT w9hld 2311/47289 ACH3112 40.00 .00 01420 5205 .00 013024 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 40.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2314/47284 Report generated: 01/30/2024 16:29 User: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erps solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3112 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT ACH3112 DOCUMENT INVOICE PO 013024 NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 2319 00000 WEBB, TRAVIN 47275 CASH 01 ACCT 1100 DEPT w9hld 580.00 .00 01420 5205 .00 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 580.00 1099:0 CONDITIONS THAT PREVENT POSTING INVOICE 2388 00000 JEFFRIES, CHRIST 47286 CASH 01 ACCT 1100 DEPT 2390 00000 RIOS, OMERO 47278 CASH 01 ACCT 1100 DEPT 2415 00000 NICKELS, STUART 47280 CASH 01 ACCT 1100 DEPT w9hld 2319/47275 ACH3112 230.00 .00 .00 013024 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 013024 01420 5205 320.00 230.00 1099:0 .00 ACH3112 .00 01420 5205 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 013024 320.00 1099:0 .00 ACH3112 1,410.00 .00 01420 5205 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 1,410.00 1099:0 CONDITIONS THAT PREVENT POSTING INVOICE 2429 00000 BENEDETTA, MICHA 47295. CASH 01 ACCT 1100 DEPT 2439 00000 PRICE, CRAIG 47279 CASH 01 ACCT 1100 DEPT w9hld 2415/47280 ACH3112 1,030.00 .00 .00 013024 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 013024 01420 5205 130.00 1,030.00 1099: .00 ACH3112 .00 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 01420 5205 130.00 1099:0 CONDITIONS THAT PREVENT POSTING INVOICE 2439/47279 Report generated: 01/30/2024 16:29 user: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erps solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3112 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT ACH3112 DOCUMENT INVOICE PO 013024 NET AMOUNT EXCEEDS PO_BY PO_BALANCE CHK/WIRE 2441 00000 METCHIKOFF, MATT 47283 CASH 01 ACCT 1100 DEPT w9hld 160.00 .00 .00 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 01420 5205 160.00 1099:0 CONDITIONS THAT PREVENT POSTING INVOICE 2459 00000 ACEVEDO, JESUS 47296 CASH 01 ACCT 1100 DEPT w9hld 2441/47283 ACH3112 190.00 .00 .00 013024 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 01420 5205 190.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2489 00000 BOTELLO, DIEGO 47294 CASH 01 ACCT 1100 DEPT w9hld 2459/47296 ACH3112 640.00 .00 .00 013024 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 01420 5205 640.00 1099:0 CONDITIONS THAT PREVENT POSTING INVOICE 2493 00000 SANDOVAL, MARIA 47276 CASH 01 ACCT 1100 DEPT w9hld 2489/47294 ACH3112 390.00 .00 .00 013024 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 01420 5205 390.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2497 00000 CRUZ, ALEXIS VAR 47293 CASH 01 ACCT 1100 DEPT w9hld 2493/47276 ACH3112 200.00 .00 .00 013024 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 01420 5205 200.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2497/47293 Report generated: 01/30/2024 16:29 User: 6175mame Program ID: apinvent Page FARMERSVILLE munis alyler erp solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3112 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT ACH3112 DOCUMENT INVOICE PO 013024 NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 11000 00000 FARIAS, RUBEN 47290 CASH 01 ACCT 1100 DEPT 300.00 .00 .00 2024/07 INV 01/30/2024 SEP-CHK: N DISC: .00 DUE 01/30/2024 DESC:Q4 2023 01420 5205 300.00 1099:0 22 APPROVED UNPAID INVOICES 22 INVOICE(S) TOTAL 9,420.00 9,420.00 REPORT POST TOTAL Report generated: 01/30/2024 16:29 User: 6175mame Program ID: apinvent Page CITY OF FARMERSVILLE A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME munis atyler erp solution 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE 012424 INV DATE PO 01/24/2024 CHECK 01/03/2024 CHECK 01/18/2024 CHECK 01/03/2024 CHECK 01/24/2024 CHECK 01/02/2024 CHECK 01/17/2024 CHECK 01/19/2024 CHECK 01/09/2024 CHECK 01/02/2024 CHECK WARRANT ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: NET 117.00 117.00 32,638.69 32,638.69 33,448.01 33,448.01 637.74 637.74 695.94 695.94 702.29 702.29 180.00 180.00 51,084.72 51,084.72 1,368.00 1,368.00 61.65 61.65 01/31/2024 PRTD 488 US TREASURY 01/31/2024 PRTD 488 US TREASURY 010524 01/31/2024 PRTD 488 US TREASURY 011924 01/31/2024 PRTD 1075 AFLAC 420728 01/31/2024 PRTD 1075 AFLAC 770269 01/31/2024 PRTD 1247 LEAF 010224 01/31/2024 PRTD 1507 TEAMSTERS LOCAL UNIO 011724 01/31/2024 PRTD 1556 BLUE SHIELD OF CALIF 011924 01/31/2024 PRTD 1873 MICROSOFT E0400QCNLG 010224 01/31/2024 PRTD 2144 MERCHANT STATEMENT Report generated: 01/31/2024 16:20 User: 6175mame Program ID: apcshdsb Page FARMERSVILLE munis atyler erp solution CITY OF A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE INV DATE PO 01/02/2024 CHECK 01/02/2024 CHECK 01/03/2024 CHECK 01/30/2024 CHECK 01/16/2024 CHECK 12/28/2023 CHECK 01/30/2024 CHECK 01/03/2024 CHECK 01/03/2024 CHECK 01/17/2024 CHECK WARRANT ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: NET 147.85 147.85 15.00 15.00 10,704.00 10,704.00 11,346.75 11,346.75 3,378.14 3,378.14 1,057.50 1,057.50 1,003.50 1,003.50 21,119.37 21,119.37 4,535.84 4,535.84 21,119.37 21,119.37 01/31/2024 PRTD 2278 GLOBAL PAYMENTS 01022024 01/31/2024 PRTD 2278 GLOBAL PAYMENTS 010224 01/31/2024 PRTD 2289 WEX FUEL CARD 100324 01/31/2024 PRTD 2289 WEX FUEL CARD 013024 01/31/2024 PRTD 2380 EDIS, INC 011624 01/31/2024 PRTD 2380 EDIS, INC 122823 01/31/2024 PRTD 2380 EDIS, INC 013024 01/31/2024 PRTD 6070 CALPERS 010324 01/31/2024 PRTD 10530 EMPLOYMENT DEVELOPME 010324 01/31/2024 PRTD 10530 EMPLOYMENT DEVELOPME 011724 Report generated: 01/31/2024 16:20 user: 6175mame Program ID: apcshdsb 2 Page FARMERSVILLE munis atyler erp solution CITY OF A/P CASH DISBURSEMENTS JOURNAL CASH ACCOUNT: 01 CHECK NO CHK DATE TYPE VENDOR NAME 1100 CASH (DUE TO/DUE FROM) VOUCHER INVOICE INV DATE PO 01/18/2024 CHECK 01/26/2024 CHECK 01/03/2024 CHECK 01/17/2024 CHECK 01/11/2024 CHECK. 12/12/2023 CHECK 01/16/2024 CHECK 12/28/2023 CHECK 01/19/2024 CHECK 01/03/2024 CHECK. WARRANT ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: ACH3113 TOTAL: NET 4,671.40 4,671.40 8,086.00 8,086.00 455.00 455.00 455.00 455.00 34,665.45 34,665.45 37,717.08 37,717.08 11,845.03 11,845.03 2,021.52 2,021.52 4,726.52 4,726.52 4,726.52 4,726.52 01/31/2024 PRTD 10530 EMPLOYMENT DEVELOPME 011824 01/31/2024 PRTD 10530 EMPLOYMENT DEVELOPME 012624 01/31/2024 PRTD 14500 FARMERSVILLE POLICE 010324 01/31/2024 PRTD 14500 FARMERSVILLE POLICE 011724 01/31/2024 PRTD 42000 SOUTHERN CALIFORNIA 11124 01/31/2024 PRTD 42000 SOUTHERN CALIFORNIA 121223 01/31/2024 PRTD 42000 SOUTHERN CALIFORNIA SL011624 01/31/2024 PRTD 43000 THE GAS COMPANY 122823 01/31/2024 PRTD 50100 VALIC 011924 01/31/2024 PRTD 50100 VALIC 010324 Report generated: 01/31/2024 16:20 user: 6175mame Program ID: apcshdsb 3 Page FARMERSVILLE munis atyler erp solution CITY OF A/P CASH DISBURSEMENTS JOURNAL NUMBER OF CHECKS 30 TOTAL PRINTED CHECKS *** CASH ACCOUNT TOTAL *** 304,730.88 COUNT 30 AMOUNT 304,730.88 *** GRAND TOTAL *** 304,730.88 Report generated: 01/31/2024 16:20 user: 6175mame Program ID: apcshdsb Page CITY OF FARMERSVILLE INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3113 VENDOR REMIT NAME munis atyler erp solution NEW INVOICES VOUCHER WARRANT DOCUMENT INVOICE PO NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE APPROVED UNPAID INVOICES TO BE POSTED 488 00000 US TREASURY 47297 CASH 01 ACCT 1100 DEPT w9hld ACH3113 117.00 .00 .00 012424 2024/07 INV 01/24/2024 SEP-CHK: Y DISC: .00 DUE 01/31/2024 DESC:PAYROLL 01406 5205 117.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 488 00000 US TREASURY 47301 CASH 01 ACCT 1100 DEPT w9hld 488/47297 ACH3113 32,638.69 .00 .00 15,334.86 1099: 3,586.38 1099: 010524 2024/07 INV 01/03/2024 SEP-CHK: Y DISC: .00 DUE 01/31/2024 DESC:PAYROLL 012223 012222 CONDITIONS THAT PREVENT POSTING INVOICE 488/47301 012224 33,448.01 13,717.45 1099: .00 15,650.40 1099: 3,660.16 1099: 488 00000 US TREASURY 47311 CASH 01 ACCT 1100 DEPT w9hld 1075 00000 AFLAC CASH 01 ACCT 1100 DEPT 1075 00000 AFLAC CASH 01 ACCT 1100 DEPT ACH3113 .00 011924 2024/07 INV 01/18/2024 SEP-CHK: Y DISC: .00 DUE 01/31/2024 DESC:PAYROLL 012223 012222 CONDITIONS THAT PREVENT POSTING INVOICE 488/47311 012224 637.74 14,137.45 1099: .00 47299 420728 ACH3113 .00 2024/07 INV 01/03/2024 SEP-CHK: y DISC: .00 DUE 01/31/2024 DESC:PAYROLL 47307 770269 012227 695.94 637.74 1099: .00 ACH3113 .00 2024/07 INV 01/24/2024 SEP-CHK: y DISC: .00 DUE 01/31/2024 DESC:JAN 2024 012227 695.94 1099: Report generated: 01/31/2024 16:15 user: 6175mame Program ID: apinvent Page FARMERSVILLE CITY OF munis atyler erp solution INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3113 VENDOR REMIT NAME 1247 00000 LEAF CASH 01 ACCT 1100 DEPT w9hld NEW INVOICES VOUCHER WARRANT ACH3113 DOCUMENT INVOICE PO 47314 010224 NET AMOUNT EXCEEDS PO BY PO_BALANCE CHK/WIRE 702.29 .00 .00 2024/07 INV 01/02/2024 SEP-CHK: N DISC: .00 DUE 01/31/2024 DESCPROFESSIONAL SERVICE 01406 5205 01411 5205 351.15 1099: 351.14 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1507 00000 TEAMSTERS LOCAL 47306 CASH 01 ACCT 1100 DEPT w9hld 1247/47314 ACH3113 180.00 .00 .00 011724 2024/07 INV 01/17/2024 SEP-CHK: y DISC: .00 DUE 01/31/2024 DESC:PAYROLL 01 2232 180.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1556 00000 BLUE SHIELD OF C 47309 CASH 01 ACCT 1100 DEPT CONDITIONS THAT PREVENT POSTING INVOICE w9hld 1873 00000 MICROSOFT CASH 01 ACCT 1100 DEPT w9hld 1507/47306 ACH3113 51,084.72 .00 .00 51,084.72 1099: 011924 2024/07 INV 01/19/2024 SEP-CHK: N DISC: .00 DUE 01/31/2024 055C:02/01/4-022924 012233 1556/47309 47321 E0400QCNLG 2024/07 INV 01/09/2024 SEP-CHK: N DISC: .00 DUE 01/31/2024 DESC:JAN 2024 ACH3113 1,368.00 .00 .00 01401 5211 01404 5211 235.86 1099: 99.06 1099: CONDITIONS THAT PREVENT POSTING INVOICE 1873/47321 01414 5211 01415 5211 01420 5211 01425 5211 02404 5211 02415 5211 02425 5211 04404 5211 04415 5211 04425 5211 06404 5211 23.59 1099: 47.17 1099: 188.69 1099: 125.01 1099: 115.57 1099: 18.87 1099: 120.29 1099: 110.86 1099: 18.87 1099: 115.57 1099: 23.59 1099: Report generated: 01/31/2024 16:15 User: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erps solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3113 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT DOCUMENT INVOICE PO NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 06415 5211 06425 5211 21404 5211 21425 5211 35425 5211 61.65 9.43 1099: 7.08 1099: 4.72 1099: 99.06 1099: 4.71 1099: .00 2144 00000 MERCHANT STATEME 47316 CASH 01 ACCT 1100 DEPT V w9hld ACH3113 .00 01414 5205 010224 2024/07 INV 01/02/2024 SEP-CHK: N DISC: .00 DUE 01/31/2024 DESCEPROFESSIONAL SERVICE 61.65 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2278 00000 GLOBAL PAYMENTS 47313 CASH 01 ACCT 1100 DEPT w9hld 2144/47316 ACH3113 15.00 .00 .00 010224 2024/07 INV 01/02/2024 SEP-CHK: Y DISC: .00 DUE 01/31/2024 DESCEPROFESSIONAL SERVICE 01406 5205 15.00 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2278 00000 GLOBAL PAYMENTS 47315 CASH 01 ACCT 1100 DEPT w9hld 2278/47313 ACH3113 147.85 .00 .00 01022024 2024/07 INV 01/02/2024 SEP-CHK: N DISC: .00 DUE 01/31/2024 DESC:PROFESSIONAL SERVICE 01406 5205 147.85 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2289 00000 WEX FUEL CARD 47326 CASH 01 ACCT 1100 DEPT w9hld 2278/47315 ACH3113 10,704.00 .00 .00 100324 2024/07 INV 01/03/2024 SEP-CHK: Y DISC: .00 DUE 01/31/2024 DESC:FUEL 01406 5255 01411 5255 82.21 1099: 5,793.45 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2289/47326 01415 5255 01420 5255 01425 5255 02425 5255 04425 5255 06425 5255 471.54 1099: 1,835.90 1099: 655.43 1099: 630.23 1099: 630.23 1099: 50.42 1099: Report generated: 01/31/2024 16:15 user: 6175mame Program ID: apinvent Page FARMERSVILLE munis atyler erps solution CITY OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3113 VENDOR REMIT NAME NEW INVOICES VOUCHER WARRANT DOCUMENT INVOICE PO NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 21425 5255 35425 5255 529.39 1099: 25.20 1099: .00 2289 00000 WEX FUEL CARD 47327 CASH 01 ACCT 1100 DEPT w9hld ACH3113 11,346.75 .00 013024 2024/07 INV 01/30/2024 SEP-CHK: Y DISC: .00 DUE 01/31/2024 DESC:FUEL 01406 5255 01411 5255 127.00 1099: 5,761.73 1099: CONDITIONS THAT PREVENT POSTING INVOICE 2289/47327 01415 5255 01420 5255 01425 5255 02425 5255 04425 5255 06425 5255 21425 5255 35425 5255 440.76 1099: 1,621.94 1099: 882.78 1099: 848.83 1099: 848.83 1099: 67.91 1099: 713.02 1099: 33.95 1099: .00 2380 00000 EDIS, INC CASH 01 ACCT 1100 DEPT 2380 00000 EDIS, INC CASH 01 ACCT 1100 DEPT 2380 00000 EDIS, INC CASH 01 ACCT 1100 DEPT 6070 00000 CALPERS CASH 01 ACCT 1100 DEPT 10530 00001 EMPLOYMENT DEVEL 47302 CASH 01 ACCT 1100 DEPT 47322 011624 ACH3113 3,378.14 .00 2024/07 INV 01/16/2024 SEP-CHK: Y DISC: .00 DUE 01/31/2024 DESCIPROFESSIONAL SERVICE 01_2233 3,378.14 1099: .00 1,057.50 1099: .00 1,003.50 1099: .00 21,119.37 1099: .00 4,535.84 1099: 47323 122823 ACH3113 1,057.50 .00 2024/07 INV 12/28/2023 SEP-CHK: Y DISC: .00 DUE 01/31/2024 DESCEPROFESSIONAL SERVICE 012233 47324. 013024 ACH3113 1,003.50 .00 2024/07 INV 01/30/2024 SEP-CHK: Y DISC: .00 DUE 01/31/2024 DESCEPROFESSIONAL SERVICE 01_2233 47298 010324 ACH3113 21,119.37 .00 2024/07 INV 01/03/2024 SEP-CHK: Y DISC: .00 DUE 01/31/2024 DESC:PAYROLL 010324 01_2226 ACH3113 4,535.84 .00 2024/07 INV 01/03/2024 SEP-CHK: Y DISC: .00 DUE 01/31/2024 DESC:PAYROLL 01_2235 Report generated: 01/31/2024 16:15 user: 6175mame Program ID: apinvent Page CITY FARMERSVILLE OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3113 VENDOR REMIT NAME munis atyler erps solution NEW INVOICES VOUCHER WARRANT DOCUMENT INVOICE PO 011724 NET AMOUNT EXCEEDS PO BY PO BALANCE CHK/WIRE 10530 00001 EMPLOYMENT DEVEL 47304 CASH 01 ACCT 1100 DEPT 10530 00001 EMPLOYMENT DEVEL 47310 CASH 01 ACCT 1100 DEPT 10530 00001 EMPLOYMENT DEVEL 47312 CASH 01 ACCT 1100 DEPT 14500 00000 FARMERSVILLE POL 47303 CASH 01 ACCT 1100 DEPT 14500 00000 FARMERSVILLE POL 47305 CASH 01 ACCT 1100 DEPT 42000 00001 SOUTHERN CALIFOR 47319 CASH 01 ACCT 1100 DEPT ACH3113 21,119.37 .00 .00 21,119.37 1099: .00 2024/07 INV 01/17/2024 SEP-CHK: Y DISC: .00 DUE 01/31/2024 DESC:PAYROLL 011824 012235 ACH3113 4,671.40 .00 2024/07 INV 01/18/2024 SEP-CHK: y DISC: .00 DUE 01/31/2024 DESC:PAYROLL 012624 01_2235 4,671.40 1099: .00 ACH3113 8,086.00 .00 2024/07 INV 01/26/2024 SEP-CHK: Y DISC: .00 DUE 01/31/2024 DESC:PAYROLL 010324 012235 455.00 8,086.00 1099: .00 ACH3113 .00 2024/07 INV 01/03/2024 SEP-CHK: Y DISC: .00 DUE 01/31/2024 DESC:PAYROLL 011724 012232 455.00 455.00 1099: .00 ACH3113 .00 2024/07 INV 01/17/2024 SEP-CHK: Y DISC: .00 DUE 01/31/2024 DESC:PAYROLL 11124 012232 455.00 1099: .00 ACH3113 34,665.45 .00 2024/07 INV 01/11/2024 SEP-CHK: Y DISC: .00 DUE 01/31/2024 DESC:ELECTRIC 01420 5206 01425 5206 21425 5206 02425 5206 04425 5206 01406 5206 35425 5206 39425 5206 HLTHY 39425 5206 CMCTR 17.89 1099: 654.65 1099: 177.84 1099: 7,700.76 1099: 22,082.79 1099: 2,900.42 1099: 127.13 1099: 17.51 1099: 986.46 1099: Report generated: 01/31/2024 16:15 user: 6175mame Program ID: apinvent Page CITY FARMERSVILLE OF INVOICE ENTRY PROOF LIST CLERK: 6175mame BATCH: 3113 VENDOR REMIT NAME munis atyler erp solution NEW INVOICES VOUCHER WARRANT ACH3113 DOCUMENT INVOICE PO 121223 NET AMOUNT EXCEEDS PO_BY PO BALANCE CHK/WIRE 42000 00001 SOUTHERN CALIFOR 47320 CASH 01 ACCT 1100 DEPT 37,717.08 .00 .00 2024/07 INV 12/12/2023 SEP-CHK: y DISC: .00 DUE 01/31/2024 DESC:ELECTRIC 01420 5206 01425 5206 21425 5206 02425 5206 04425 5206 01406 5206 35425 5206 39425 5206 HLTHY 39425 5206 CMCTR .00 21425 5206 19.01 1099: 803.01 1099: 180.15 1099: 7,659.41 1099: 24,744.28 1099: 3,079.33 1099: 129.50 1099: 18.47 1099: 1,083.92 1099: .00 11,845.03 1099: .00 42000 00001 SOUTHERN CALIFOR 47325 CASH 01 ACCT 1100 DEPT 43000 00001 THE GAS COMPANY 47317 CASH 01 ACCT 1100 DEPT 50100 00001 VALIC CASH 01 ACCT 1100 DEPT 50100 00001 VALIC CASH 01 ACCT 1100 DEPT ACH3113 11,845.03 SL011624 2024/07 INV 01/16/2024 SEP-CHK: Y DISC: .00 DUE 01/31/2024 DESC:ELECTRIC 122823 ACH3113 2,021.52 .00 2024/07 INV 12/28/2023 SEP-CHK: N DISC: .00 DUE 01/31/2024 DESCEPROFESSIONAL SERVICE 01425 5206 01406 5206 39425 5206 CMCTR .00 243.76 1099: 861.88 1099: 915.88 1099: .00 4,726.52 1099: .00 4,726.52 1099: 47300 010324 ACH3113 4,726.52 2024/07 INV 01/03/2024 SEP-CHK: Y DISC: .00 DUE 01/31/2024 DESC:PAYROLL 47308 011924 012332 ACH3113 4,726.52 .00 2024/07 INV 01/19/2024 SEP-CHK: N DISC: .00 DUE 01/31/2024 DESC:PROFESSIONAL SERVICES 012332 30 APPROVED UNPAID INVOICES 30 INVOICE(S) TOTAL 304,730.88 304,730.88 REPORT POST TOTAL Report generated: 01/31/2024 16:15 user: 6175mame Program ID: apinvent Page U 8 01/31/2024 14:09 CITY OF FARMERSVILLE 6175bash WARRANT: 020224 EMP # NAME 7 18 149 23 153 11 98 148 112 152 25 119 135 26 39 75 113 B2 111 86 157 38 154 55 151 117 97 145 143 81 124 108 144 80 147 61 156 155 130 ADVICE REGISTER : BI WEEKLY. From: 01/17/2024 To: 01/30/2024 lpradvres NET PAY 1,729.13 1,033.95 1,939.12 1,977.57 2,073.06 1,635.38 4,237.76 2,473.92 1,855.78 2,480.96 1,240.47 2,694.34 1,437.14 1,453.60 2,956.42 2,354.64 3,360.59 1,787.94 1,695.64 1,464.91 3,499.66 1,101.96 1,766.06 1,278.19 4,356.02 1,800.69 1,788.51 2,146.05 2,320.86 1,523.95 2,423.19 2,392.15 1,614.47 1,258.01 2,293.66 1,660.25 1,115.69 1,963.20 1,603.71 2,029.37 81,817.97 CHK # Total Deposits: 40 ** END OF REPORT - Generated by Betina Ashoori ** CITYOF 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 Par Value Value %of Book Value Portfolio Term Days to Est. 1Mo Maturity Yield 1 1 5.54% 1 1 5.50% 1 1 4.01% 1 1 3.79% 1442 548 2.46% 1753 746 1.14% 0 0 4.97% 1 1 0.10% 1 0.10% Investments CAMP Pool (PFM Asset Management) CLASS Pool (Public Trust Advisors) LAIF Pool (CA State Treasurer) CSJVRMA Pool (Chandler Asset Management) 5,285,993 5,285,993 5,285,993 20.44% 5,743,241 5,743,241 5,743,241 22.20% 72,164 72,164 72,164 0.28% 2,664,838 2,609,874 2,609,874 10.09% Pool Total 13,766,237 13,711,273 13,711,273 53% Certificates of Deposit Federal Agency Securities Money Market (Time Value Investments) Money Market (Citizens Business Bank) 4,215,000 4,115,490 4,115,490 15.91% 4,302,000 4,090,376 4,090,376 15.81% 105,044 105,044 105,044 0.41% 390,630 390,630 390,630 1.51% 3,452,441 3,452,441 3,452,441 13.35% Securities Total 9,012,674 8,701,540 8,701,540 34% 100% Cash Grand Total 26,231,352 25,865,254 25,865,254 This monthly report accurately reflects all the City pooled investments. Itis 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. 76 SAG Steve Huntley, Treasurer 2/7/2024 Date CITYOF FARMERSVILLE, City Council Staff Report 7D TO: FROM: DATE: Honorable Mayor and City Council Jennifer Gomez, City Manager February 26, 2024 Year 2023-24 SUBJECT: Request by Farmersville Elite Soccer Club for Special Event Funding for Fiscal RECOMMENDED ACTION: Itis 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 The program will take place June 11th through September 19th 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. Counciimembers Gomez and Valdovinos have reviewed the application and Community Center. recommend the approval of $1,050. FISCAL IMPACT: fiscal year. DOCUMENTS: Event Funding Application Approving this request will leave a balance of $7,340 in the Special Event Budget in the current CITVOF FARMERSVILLE 2023-2024 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 off funding. Request Guidelines: Ifyou arê 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 ai funding request should be directed to the City of Farmersville 559-747-0458 1. Name ofEvent: Futsal (Soccer) 2. Date.of Event:. Tuesdays & Thursdays 6PM-8pm June 11 thru'Sept 19 3. Location, of Event: Farmersville Community Center Gym 4. Name ofAplicant/Organization hosting event:F Farmersville Elite Soccer Club 5. Contact Person: Name: Manuel Amezcua Title:. Club President Phone: 559-623-5861 Email: amezual286egmalcon Address: 1853 N Steven GT City: Farmersville State: CA Zip:93223 6. Description of Event: Opening the gvm fort the community to come. play and learn about Futsal Soccer 7. Describe what benefits the community and City of Farmersville will receive from the The kidsand communitywilly receive highly skilled training in the game of soccer from trained professionals who only wish to pass on wisdom and the love of the gameto event: everyone in Farmersville. 8. Anticipated Number of out-of-town overnight attendees: 0 9. Anticipated number of local attendees: 20-40c on each oft the 2 days 10. Is this fundraising event? Yes_ - x No 11. Event Promotion- What type ofa advertising/publicrelations/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. Wev will be promoting the' Futsal/Open gym on the Club website and Facebook page 12. Is this event free to the public: Yes_ 13. Isthis a first-time event: Yes_ No X No X 14. What hotels have committed to special rates or packages for the event date? 15. Describeyour procedures for crowd control and security: Nos securityr 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 Ihsurance: Yes_ X No 18. Havé you consulted with City/County/State and other agencies to determine what permits will be required to conduct this event? Yes_ x 19. Total Amount of Financial Assistance requesting: $1,050.00 20. Complete this projected event budget worksheet: No Anticipated Revenue: 1. Admissions 2. Booth/Spaçe Rentals 3. Corporate/Individual Sponsors $_ 5 500.00 $ $_ $ $ 4. Other Revenue (please list) 5. Requestèd City of Farmersville In Kind Support (Please List) Portable Restrooms, Street Barricades, City Facilities, etc.) (ie., Permit Fee Waive, Traffic Control, Security, Electrical Support, Other City Staff Labor, City Equipment, 6. Requested City of Farmersville Monetary Support $ $ Total Projected, Revenue: Anticipated Expenses: 7. Personne!: Administrative Artistic Technical Other 8. Space Rental 9. Equipment Rental 10. Miscellaneous Supplies 11. Permits/License $ $. $ $ 1,050.00 200.00 12. Advertising/Marketing- 13. Other Expenses Insurance $. $_450.00 $. Total Projected Expenses: 1,700.00 OFFICIALWITHCONTRACTING: AUTHORITYFOR1 THE ORGANIZATION IHEREBY CERTIFY that the facts stated herein this Event Funding Request are true and correct to the best of my knowledge. The Event described herein willl be conducted in accordance with all applicable city/county andotherregulations, and the Event provides equal access to employment and event participation without regard to race, color,r religion, sex, national Origin, age, disability, ori military status in accordance with applicable federal laws. Oficia'sSignature: Date:_ 1/6/24 Official's Name & Title (Print):Manuel Amezcua Farmersville Elite Soccer Club President Phone Number.559-623-5861 E-Mail address:amezcua126@gmail.com. BOYS& GIRLS CLUBS OFTHES SEQUOIAS FARMERSVILLE COMMUNITY CENTER FACILITY RENTAL. AGREEMENT-FEE WAIVER Organization/Group Name: Farmersville Elite Soccer Club(FESC) Address: 1853NSteven Ct, Farmersville CA93223 Phone: 559-623-5861 Contact person: Manuel Amezcua Phone:_5$9-623-5861 Cell phone Email: anezral286@gmailcom Room(s) tol belused: Gym Purpose ofuse_ 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 2. Dates agreement is in effect: June 11,2024 - Sept 19.2024 3. Damagé deposit and rental fees are to be paidi in advance of facility use. 600PM-8OPM 4. Agreed fee for Boys & Giris Club Attendant: $25 per hour: x 601 hours =$1.500.00- $450=$1,050.00 (total fee) 9days of Credit: gives us 6 days ofo credit. FESC ended the open gym night on Sept. 07,2023, the original end date was Sept. 282023.That FESC did not open for the 4th ofJuly, This is Idayo ofcredit. Boys & Girls Club canceled 2 open gym nights because of Boys & Girls Club training. Thisgave 9 days ofcredit.2hours each day at $25 gives us a credit of$450 to go towards this year'sgym us 2 days ofcredit. rental. City to fund the Fee: Date: (City manager signature) Or City waives the presençe ofa an: Attendant: Date: Page lof4 BOYS & GIRLS CLUBS OFTHE SEQUOIAS (City manager signature) Damage/cleaning deposit: $300-1 will be refunded at discretion ofBGCS and in full if facility is left clean and undamaged and rules and policies are followed. The renter billed for àny damages or extra staff time not covered by deposit. Allow up to four will weeks be for processing and return of deposits. First payment of deposit plus use fee =$_ Subsequent payments due Liability Insurance: (4) due by: each week/month, etc. ACertificate ofLiability Insurançe is required for facility reservations. Renters are to provide proofo of liability insurance with minimum coverageofs1,00,p00, the City ofl Farmersville, its officers, officials, employees, agents, representatives, naming volunteers and Boys & Girls Clubs ofthe Sequoias as additional insured. Ifalcoholis is served at the event, the policy must specifically state thati it covers an event with alcohol. Contact your local insurance agent to obtain insurance or obtain an insurance certificate online at:! AshmeoN Turn in insurance certificate to facility at: 623N. Avery Ave. Farmersville, CA 93223 or email - atinapa-dhsuisat Failure to provide appropriate documentation will result in cancellation. Professional security guard services are required for all public and private gatherings Security Guard Service which include the following: dances, music, and alcohol.. Clean Up The renter is responsible for ensuring the clean-up for all areas used. This includes kitchen, areas in need of mopping due to spilled beverages, and assistance with take down oftables 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 requirèd cleaning post rental due to messy rentals, will lead to deduction in facility damage/cleaning deposit return. Facility must be left as you found it. Adult Supervision Page 2 of4 BOYS& GIRLS CLUBS OFTHE 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 résulting from use oft the facilities. The renteri is resporisible for the control and supervision of all people in attendance. Ther renter must ensure that no damage is done to the facilities, and that all oft the attendees conduct themselves in an orderly manner in and around the facility, including the parking lot. Ifbehavior oft the group is'deemed inappropriate or unsafe for any reason, the function. may be stopped and denied further use oft the facility. The latter applies to any damages to facilities and equipment during function. Furthermore, ifit becomes necessary during the course of the function to summon. the police for any reason, all or part oft 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 Shoulda ar 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 deposit(s). 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 seçurity and clean-up requirements. Tor receive a full refund on the damage/cleaning deposit; the building must be cleaned, and cleared ofall 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 mayhave all or part oft 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 déposit. Deposit will be refunded at discretion ofBGCS 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. Ihereby certify that It have read and agree to abide by the policies and regulations set forthl by this agreement, and I understand that failure to comply may result in the cancellation of use of Page 3of4 BOYS& GIBLS CLUBS OF1 THE SEQUOIAS the facility. Iagree as representative of the group or organization to hold the Boys & Girls Clubs ofthe Sequoias (Club) and City of] Farmersville (City). harmless, indemnify and defend the Club and City and all its officers, employees, volunteers ànd 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 ofa any ofitso offiçers, employees or agents in the performance ofthis agreement, except such damage as is caused by the sole negligence oft the Club or City or any of The Boys & Giris 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 Girls Club and City of Farmersville. Permits are immediately revocable if false statements were made when resérving a facility or ifan 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 orr regulation, or the faisification oft the application. its officers, employees, volunteers or agents. & Boys City Managet/Designee signature: Date: Date:2/14/24 Date:_ z/14/24 Users signature: B&GC: signature: R Page4of4 CITYOF FARMERSVILLE City Council Staff Report 8A TO: FROM: DATE: Honorable Mayor and City Council Steve Huntley, CPFO, IPMA-SCP Director of Finance and Administration February 26, 2024 for Fiscal Year 2023-24 SUBJECT: Consider Approving Resolution 2024-007 adopting Mid-Year Budget Amendment 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 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 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 given the changing variables halfway through a year. adjustment a larger one than usual. 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 éach of the proposed changes. Here is a description of the documents and how The staff reportigives 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: they are laid out: 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 Part Two discusses the proposed amendments to the budget which are discussed in two 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 operations budget. sections! 1) the capital budget and 2) the operations budget. 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 The resolution is the official document the City Council uses to adopt the adjustments to 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 Capital Budget worksheets detail out each Capital Budget item included in the Five-Year system for the City. the FY 2024 budget. year budget. 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 across many City funds for FY 2024. SUMMARY OFCAPITAL IMPROVEMENT PLAN Administration Code Enforcement Engineering Fire Planning Police Public Works The City of Farmersville started the year with a busy Capital Budget of $19,802,511 spread YEAR1 50,000 647,000 6,500,000 305,999 129,525 YEAR2 YEAR3 YEAR4 YEAR5 43,500 2023-24 2024-25 2025-26 2026-27 2027-28 14,938,069 2,436,692 7,531,624 2,327,500 2,842,500 30,076,385 89,811 168,612 183,542 172,042 197,542 811,549 982,500 878,500 500,000 1,045,000 7,177,632 TOTAC 19,802,511 10,217,329 8,593,666 3,043,042 4,745,042 46,401,590 TOTAL 43,500 50,000 660,000 7,807,000 435,524 Ai 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 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 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 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 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 section. 12/31/2023 and a summarizing status for reference. spending by the City Manager. covered more in Part 2 of this report. 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 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 While progress is being made, staff believes that the budget will not be fully spent by year end vehicles. pickup trucks. due to many delays out of control of staff. CAPITAL BUDGET FOR FISCAL YEAR: 2023-24 Code Enforcement Vehicle (Air Quality Grant) Birch Water Line Relocation Master Plans for Sewer, Water, and Storm Drain New Water Well (ARP allocation) City Hall Parking Lot (Phase 1) Pavement Management Program: Street Repairs Year1 Pavement Management Program: Ongoing Repairs Solar Plant located at new WWTP Highway 198 Gateway Improvements (CCLGP) Citrus/Road 168 Connectivity Street Project Central Fire Station Fire Patrol Vehicle Downtown Specific Plan Zoning Ordinance Update General Plan Update Jennings Park Remodel Project New Corporation' Yard Sports Park Rehabilitation Project Roy's Park Improvement Skid SteerLoader (Bobcat) Downtown StreetlightUpgrade Freedom Field Booster Pump & Electrical Panel for Sports Park Liberty Park Trail Improvements Pocket Park improvements Roy's Park-F Phase II Vacuum Truck Public Works Backhoe Community Center Air Conditioning Units Public Works Pickup Trucks Patrol Vehicle Replacement (FY22) Patrol Vehicle Replacement (FY24) Axon Fleet 3ln-Vehicle Camera System YEAR1 2023-24 50,000 35,000 140,000 822,000 450,000 2,700,000 2,377,462 2,000,000 5,000,000 3,601,069 190,000 392,000 255,000 80,000 50,000 175,999 334,000 240,000 39,000 96,500 147,000 40,188 884,000 180,000 141,000 150,000 775,000 384,500 172,000 108,475 79,969 58,070 11,500 20,241 YTDSPENT PERCENTOF 2023-24 3,150 1,233 207,475 2,550 86,567 39,069 38,938 12,750 20,185 79,706 117,190 843,125 17,515 528,006 139,635 105,725 43,553 BUDGET CURRENTS STATUS 0.0% COMPLETE BY 6/30 9.0% IN PROGRESS 0.0% IN PROGRESS 0.0% DELAYED TOFY25 0.3% IN PROGRESS 88.1 1% COMPLETE BY 6/30 0.0% IN PROGRESS 0.0% DELAYED' TOFY25 5.8% IN PROGRESS 0.0% IN PROGRESS 0.7% IN PROGRESS 33.9% IN PROGRESS 48.8% COMPLETE BY 6/30 77.9% COMPLETE BY 6/30 7.2% IN PROGRESS 0.0% IN PROGRESS 8.4% IN PROGRESS 0.0% IN PROGRESS 82.6% IN PROGRESS 79.7% COMPLETED 0.0% IN PROGRESS 95.4% COMPLETE BY 6/30 9.7% IN PROGRESS 0.0% IN PROGRESS 0.0% IN PROGRESS 68.1% IN PROGRESS 0.0% COMPLETE BY 6/30 81.2% COMPLETED 97.5% COMPLETED 0.0% COMPLETE BY 6/30 75.0% IN PROGRESS 0.0% IN PROGRESS 0.0% IN PROGRESS 23.6% TOTAL 19,802,511 4,663,832.97 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 tot 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 Overall, the budgets for the four main funds listed above are performing as expected half-way needed. through the fiscal year: GENERAL FUND BUDGET REVENUES EXPENSES SURPLUS/DEFICIT ACTUAL/ ASOF12/31/2023 PERCENT DIFFERENCE 6,512,011 6,412,998 99,013 2,728,770 3,218,850 (490,080) 42% 50% 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 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. 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 tor 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 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 from these figures because they are housed ini the Capital Fund (103). Those changes will be covered in Part 2 of this report. revenue sources are not paid equally throughout the year. the new industry has begun to normalize. 5 WATER UTILITY BUDGET ACTUAL AS OF 12/31/2023 PERCENT DIFFERENCE REVENUES EXPENSES SURPLUS/DEFICIT 1,199,035 1,579,567 (380,532) 598,312 530,310 68,002 50% 34% 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 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 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 toi improved collections on payment plans and assistance payments made from the LIHWAP program from the State on 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 are included in these figures. surprising trends to report. behalf of customers who are eligible and apply for funds. that operations and capital costs are appropriately funded. SEWERUTILITY BUDGET ACTUAL ASOF 12/31/2023 PERCENTDIFFERENCE REVENUES EXPENSES SURPLUS/DEFICIT 7,123,827 7,647,450 (523,623) 1,001,521 1,672,766 (671,245) 14% 22% 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 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. Ift 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 are included in these figures. 6 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 ASOF 12/31/2023 PERCENT DIFFERENCE REVENUES EXPENSES SURPLUS/DEFICIT 941,077 1,166,036 (224,959) 477,096 372,321 104,775 51% 32% 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 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 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 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 operates as a pass-thru for the outsourced contracted waste-hauler. meetings. eligible and apply for funds. 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 toi the budget at mid-year this year are changes needed due to capacityt to deliver projects. The City has more staff, has hired more grant managers, has more engineering staff, and yet projects are still bèing delayed. There are simply too many projects and so those of less priority must be delayed to ensure timely delivery of others (many Itisi important to note that, as discussed earlier in this report, increasing expenses and decreasing revénues 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 newi 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 ini 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 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 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 Add the Police Camera Pod purchase needed for more flexibility in securing safety and deterringyandalism ini the park areas of the City as previously discussed with City Council. This purchase is about $11,000 from the Police developer impact funds. times with hardideadines associated with grant funding). completèd by 6/30/2024. oft this purchase cost was applied in Fiscal Year 2022-23. 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. YEAR1 2023-24 CAPITAL BUDGETFOR FISCAL YEAR2 2023-24 Code Enforcement Vehicle (Air Quality Grant) Birch Water Line Relocation Master Plans for Sewer, Water, and Storm Drain New Water Well (ARP allocation) City Hall Parking Lot (Phase 1) Pavement Management Program: Ongoing Repairs Solar Plant located at new WWTP Highway 198 Gateway Improvements (CCLGP) Citrus/Road 168 Connectivity Street Project Central Fire Station Fire Patrol Vehicle Downtown Specific Plan Zoning Ordinance Update General Plan Update Jennings Park Remodel Project New Corporation Yard Sports Park Rehabilitation Project Roy's Park Improvement Skid Steerl Loader (Bobcat) Downtown Streetlight Upgrade Freedom Field Booster Pump & Electrical Panel for Sports Park Liberty Park Trail Improvements Pocket Park Improvements Roy's Park-F Phase II Vacuum Truck Public Works Backhoe Community Center Air Conditioning Units PublicWorks Pickup Trucks Patrol Vehicle Replacement (FY22) Patrol Vehicle Replacement (FY24) Axon Fleet 3In-Vehicle Camera System Public Works Bucket Truck (emergency purchase) Sewer Plant De-Watering! System ADA Sidewalk Improvements Police Electric Bicycle Police Camera Pod System Fire Department Water Tender CHANGE/ /UPDATE FOR MIDYEAR 50,000 WAITING SHIPMENT 35,000 NO CHANGE 140,000 NO CHANGE 822,000 PENDING GRANT AWARD 450,000 NO CHANGE 2,000,000 NO CHANGE 5,000,000 PENDING GRANT AWARD 3,601,069 NOCHANGE 190,000 NO CHANGE 392,000 NO CHANGE 255,000 NO CHANGE 80,000 NOCHANGE 50,000 NO CHANGE 175,999 NO CHANGE 334,000 NO CHANGE 240,000 NO CHANGE 39,000 NO CHANGE 96,500 NO CHANGE 147,000 NO CHANGE 40, 188 NO CHANGE 884,000 NO CHANGE 180,000 NO CHANGE 141,000 NOCHANGE 150,000 NOC CHANGE 775,000 NO CHANGE 384,500 WAITING SHIPMENT 172,000 NOCHANGE 108,475 NOCHANGE 79,969 WAITING SHIPMENT 58,070 NOCHANGE 11,500 NOCHANGE 20,241 NOCHANGE 180,736 ADDI NEW PROJECT 934,342 ADDI NEW PROJECT 250,000 RELIST OLDPROJECT 11,000 ADDI NEW PROJECT 62,000 ADDI NEW PROJECT 7,354 REUSTOLDPROJECT Pavement Management Program: Street Repairs Year1 2,700,000 NO CHANGE 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 àre 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 thérefore 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 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'i 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 A full listing of the detail of the proposed changes can be found int 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 that this fiscal year was started with uncertainty as the base assumption.. (Fiscal Year 2024-2025). This process is already underway. 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 MLF 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 network and new fiber internet connection. Revised Administration Equipment from $5,000 to $20,000 for upgrades needed with Revised, Administrative Overhead Insurance cost from $478,886 to $438,295 to match Revised Police Professional Expense from $235,000 to $285,000 to offset ongoing legal 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 actuals. fees. 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 289,406.00 -5.3% 0.0% (23,793.00) -5.8% 0.0% (40,591.00) -10.7% 0.0% 1,957.00 0.1% 906.00 0.2% (8,064.00) -6.2% 9,816.00 1.2% (80.00) 0.0% 46,757.00 48.9% 97.5% 101.8% 1:General Fund 400: Revenues 1:General Fund 401: City Council 1:General Fund 404: Administration 1:General Fund 405: Membership Legislation 1:General Fund 406: Administrative Overhead 1:General Fund 407: City Sponsorships 1:General Fund 411: Police 1:General Fund 414: Community Development 1:General Fund 415: Code Enforcement 1: General Fund 420: Fire 1: General Fund 425: Public Works 1:General Fund 426: Animal Control (5,409,846) 29,648 413,583 16,000 378,861 12,000 2,382,855 468,089 130,119 824,665 559,387 95,625 (6,512,011) 6,412,998 (99,013) (5,120,440) 29,648 389,790 16,000 338,270 12,000 2,384,812 468,995 122,055 834,481 559,307 142,382 (6,348,990) 6,526,291 177,301 Total Revenues Total Expenses Net 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. Ifnot, General Fund Revenues continue to level off or decline without changes to the tax rate the fund balance will likely be able to cover this amount temporarily. ort 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 The future revenue of the City is still uncertain, sO prioritizing expenses will be essential requests from the departments for funding allocations. tog 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. Itisn'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, itis important to note that as of the last reading (Fiscal Year 2022 audited financial statements) the 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 oft 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 theloverall 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 are - essential to good financial health. Essentially, good budgets beget good audits, and good audits beget good 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 City was in a healthy rating, the highest in the County in fact. budgets. specific scoring by the State As indicated in the table below, the State Auditor values General Fund Reserves (30%), Debt Burden (15%), Liquidity (10%), Pension Obligations (10%), and OPEB Obligations (10%) with the greatest impact on risk for a City. 12 Farmersville Low Statewide Rank:316. Reserves Debt Burden Liquidity Revenuel Trends Pension Obligations PensionFunding Pension Costs Future PensionCosts OPEBObligations OPEBFunding Porterville Atwater Merced SanJ Jose uz Fresno KingCity Cortran 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'sLocal Government High-Risk Rating Financial Indicators (2021) Points Possible Farmersville Score Farmersville Rank Liquidity Debt Burden General Fund Reserves Revenue Trends Pension Obligations Pension Funding Pension Costs Future Pension Costs OPEB Obligations OPEB Funding Total 10 15 30 5 10 5 5 5 10 5 100 10 6.5 30 5 10 4.85 4.17 4.17 10 5 89.69 57 36 276 416 332 349 316 366 n/a n/a 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 1. To fully fund and expand the General Fund and Enterprise reserves even more. 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 to our budget are: 2. To pre-pay debt in all funds, if possible 3. To reduce pension obligations of all kinds 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 2018 2019 2020 2021 Budget Actual 2022 2023 2024 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 Budgetvs.A Actual T 2018 2019 2020 2021 Budget Actual 2022 2023 2024 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 FY2024Budget) 2018 2019 2020 Expense 2021 Revenue 2022 Linear (Expense) 2023 2024 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 listéd below with a combined total and percent change 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 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 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. Howèver, 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 inr revenue recently and this cash will be needed to comply with the Minimum Fund Balance The cash balance in the Capital Fund (103) are budgeted amounts and only allocated to the As context to this ànalysis, 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 andlor restrictions on spending: blue for water utility, yellow for sewer utility, green for refuse utility, red for restrictedspecial revenue funds, and white for unrestricted (General Fund). from year to year. they coincide with. regular, large revenue receipts. Capital Budget or other unexpected expensès or revenue shortfalls. Policy. fund when budgeted as transfers from other funds. 16 ENDING CASH POSITIONS OF CITY OF FARMERSVILLE FUNDS FY: 2021 TOFY2024 ACCOUNT 01 GENERAL FUND 08 SELF INSURED RESERVES 60 AMERICANI RESCUE PLAN (ARPA) 102 GENERAL FUND RESERVE 103 GENERAL FUND CAPITAL 104 MEASURE Q (CANNABIS) General Government Total 02 WATER UTILITY 04 SEWER UTILITY 545 SEWER REVENUE STABILIZATION 06 REFUSE UTILITY 09 CUSTOMER DEPOSITS Utilities Total 12 FEDERAL AND STATE GRANTS SOCHIDCAREFUND Pass Through Grants Total 1OPOLICE-DEPISLES: 11 DRUG ENFORCEMENT 14F POLICE DEPTSLESF 15-POUCEDEPEABIO9. 80E EVIDENCE HOLDING 82 ASSET FORFEITURES 83-LMVESCAN Law Enforcement Total 72FIRE ASSET REPLACEMENT Fire Department Total 03 WATER DEVELOPMENT 05 SEWER DEVELOPMENT 23 STORM DRAIN DEVELOPMENT 30F PARK DEVELOPMENT 61 CIRCULATION DEVELOPMENT 62 GOV FACILITIES DEVELOPMENT 63 LIBRARY DEVELOPMENT 64 COMM FACILITIES DEVELOPMENT 71 FIRE DEVELOPMENT 81 POLICE DEVELOPMENT Developer Impact Fees Total 20STP 21 GASTAX 22T TDA/LTF 5STREIMITIGATION 26MEASURER 27RMRA(SB1) Streets & Transportation Total 31 PARK IMPROVEMENTS 35 MAINTENCE DISTRICTS 39CITY PROPERTIES Maintenance Total 40C CDBG PROGRAM INCOME 41 HOME PROGRAM INCOME 420 CALHOME PROGRAM INCOME Housing Total TOTAL 6/30/2021 6/30/2022 12/31/2022 6/30/2023 12/31/2023 1,347,524.58 641,284.08 (382,270.39) 201,839.91 (61,412.72) 551,000.00 801,000.00 801,000.00 801,000.00 801,000.00 1,176,000.79 2,299,954.43 2,214,152.53 2,100,849.52 1,439,868.82 1,439,868.82 1,439,868.82 1,439,868.82 1,439,868.82 1,065,025.91 1,462,839.03 2,063,006.75 1,477,750.66 1,889,989.39 4,403,419.31 5,520,992.72 6,008,077.00 6,134,151.00 5,931,732.05 1,070,986.34 1,171,847.36 1,377,826.02 1,297,051.40 1,255,911.25 5,568,637.98 5,752,974.77 5,729,749.43 5,452,795.10 2,944,760.26 372,826.47 379,402.93 473,578.85 445,361.91 498,967.53 13,948.70 16,401.63 20,101.63 24,922.63 27,662.63 7,026,399.49 7,320,626.69 7,601,255.93 7,220,131.04 6,227,301.67 (426,346.07) (257,554.87) (491,585.39) (700,268.42) (231,853.88) (426,346.07) (257,554.87) (491,585.39) (700,268.42) (231,853.88) 17,044.00 17,155.46 16,467.51 17,448.90 14,835.58 230,772.30 186,768.58 168,573.10 165,080.64 178,860.14 17,779.85 17,779.85 20,779.85 20,779.85 20,779.85 263,574.18 219,522.94 205,820.46 206,321.07 214,475.57 (213,482.61) (460.92) (238,562.96) 1,500,000.00 2,297.03 2,312.05 (4,319.00) (4,493.00) 3,011.68 (21,354.76) 7,014,123.75 7,014,232.21 (21,354.76) 7,014,123.75 7,014,232.21 387,002.19 292,154.94 305,140.40 376,097.80 380,710.30 1,025,088.79 806,463.75 829,445.82 953,527.02 955,653.52 154,642.98 8,317.38 15,051.38 59,702.12 66,231.12 18,991.55 21,050.61 24,442.47 38,856.98 48,095.63 249.59 14.45 767.46 7,746.83 760.28 44.43 3,773.30 109.29 782.92 2,407.40 5,921.83 8,513.54 68,984.81 78,242.46 157,505.52 160,799.41 103,427.09 183,911.36 186,635.00 1,757,422.99 1,314,457.47 1,287,067.66 1,685,059.66 1,733,119.28 90,021.87 845,348.62 845,348.62 859,943.61 859,943.61 373,625.71 263,225.80 248,057.44 240,534.77 227,038.33 1,612,361.48 1,750,797.81 2,268,556.96 2,105,900.50 394,256.55 1,338,077.96 (516,605.77) 1,700,174.82 2,574,894.77 2,737,332.13 3,414,087.02 2,569,169.32 5,401,151.49 6,240,994.48 4,805,137.44 (100,010.56) 198,671.19 (1,109,769.63) (1,291,007.14) (2,302,225.10) 59,992.15 82,101.49 85,583.14 86,933.37 101,810.12 (45,288.55) 273,521.76 (1,030,949.72) (1,203,460.88) (2,185,481.47) 56,606.86 328,730.77 358,321.77 435,500.61 458,070.61 66,758.58 22,802.70 88,152.70 188,526.09 206,621.09 382,576.58 566,912.46 528,370.46 623,867.23 665,232.23 16,775,844.95 17,527,648.49 19,509,207.89 27,220,918.93 24,173,895.10 14,191.96 25,671.38 226,402.86 339,013.65 459,720.83 586,566.82 (5,270.14) (7,250.92) (6,763.23) 612.89 14,933.51 259,211.14 215,378.99 81,895.99 (159.47) 540.53 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 WHEREAS, the City Council has received and reviewed the mid-year review staff WHEREAS, the City Council has considered the recommended amendment to the 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 rèport, regarding the revenues and expenditures are hereby approved and adopted effective Council on June 12, 2023 by Resolution 2023-17; and report and proposed budgetary amendment on February 26th, 2024; and budget presented in the attached staff report; February 26, 2024. Council Member The foregoing resolution was adopted upon motion of Council Member and 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 CITYOE FARMERSVILLE, 2023-2024 BUDGET 2023-2024 PROPOSED AMENDMENT 01 GENERAL FUND 400 GENERAL REVENUES 01 -400-400-4001 01 -400-400-4002 01 -400-400-4005 01 -400-400- -4105 01 -400-400- -4109 401 CITY COUNCIL 01 -401-300- -5101 01 -401-300-5205 404 ADMINISTRATION 01 -404-400- -5101 01 -404-400 -5110 01 -404-400-5111 - 01 -404-400-5112 01 -404-400- -5119 01 -404-400 -5122 01 -404-400 -5122 -ADP 01 -404-400- -5504 - 406 ADMINISTRATIVE OVERHEAD 01 -406-400 -5207 411 POLICE 01 -411-000 -4081 -PTROL 01 -411-100 -5101 01 -411-100 -5110 - 01 -411-100- -5111 - 01 -411-100 -5112 01 -411-100- -5116 01 -411-100 -5119 01 -411-100 -5122 01 -411-100 -5205 PROPERTYTAX SALES TAX (54058) PROPERTY TAX-VLF SALES TAX- ADD ON (121) SALES TAX- ADD ON (628) SALARIES (340,000) (1,270,000) (1,187,500) (770,000) (770,000) 35 (1,100 (1,239, (677,0 (677,000) 14,400 PROFESSIONAL & CONTRACTUAL SRV 14,400 243,146 15,131 3,539 20,754 8,408 50,000 5,000 478,886 SALARIES FICA MEDICARE PERS RETIREMENT DEFERRED COMP PERS UAL PAYMENT PERS UAL PAYMENT EQUIPMENT INSURANCE 246,328 15,328 3,585 21,057 9,686 6,201 20,000 438,295 (126,385) 1,275,139 80,031 18,717 146,379 10,949 29,637 32,295 285,000 VEHICLES (REPLACEMENT) SALARIES FICA MEDICARE PERS RETIREMENT LTD/LIFE INSURANCE DEFERRED COMP PERS UAL PAYMENT PROFESSIONAL & CONTRACTUAL SRV 1,356,167 85,054 19,892 155,174 11,250 32,126 235,000 CITYOF FARMERSVILLE) 2023-2024 BUDGET 2023-2024 PROPOSED. AMENDMENT 01 -411-000-5514 -PTROL 414 COMMUNITY DEVELOPMENT 01 -414-800-5101 01 -414-800-5110 01 -414-800-5111 01 -414-800-5116 01 414-800-5119 01 414-800-5122 415 CODE ENFORCEMENT 01 -415-800- -5101 - 01 -415-800- -5110 01 -415-800 -5111 01 -415-800 -5112 01 -415-800 -5116 01 -415-800 -5122 420 FIRE DEPARTMENT 01 -420-100- -5101 - 01 -420-100- -5110 01 -420-100-5111 01 -420-100-5116 01 -420-100-5119 01 -420-100 -5122 425 PARKS, BUILDINGS & GROUNDS 01 -425-600 -5101 01 -425-600- -5110 - 01 -425-600- -5111 01 -425-600 -5112 - 01 -425-600 -5116 01 -425-600 -5119 01 -425-600- -5122 VEHICLES (REPLACEMENT) SALARIES FICA MEDICARE LTD/LIFE INSURANCE DEFERRED COMP PERS UAL PAYMENT SALARIES FICA MEDICARE PERS RETIREMENT LTD/LIFE INSURANCE PERS UAL PAYMENT SALARIES FICA MEDICARE LTD/LIFE INSURANCE DEFERRED COMP PERSUAL PAYMENT SALARIES FICA MEDICARE PERS RETIREMENT LTD/LIFE INSURANCE DEFERRED COMP PERS UAL PAYMENT 144 34,034 2,123 497 346 1,021 62,398 3,923 918 4,512 645 54,238 3,417 799 3,970 577 1,329 313,867 19,703 4,608 2,802 4,942 6,457 150,730 9,514 2,225 12,402 1,505 5,041 3,720 310,813 19,513 4,564 2,778 4,896 153,931 9,713 2,272 12,634 1,532 5,137 CITYOF FARMERSVILLE, 2023-2024 BUDGET 2023-2024 PROPOSED AMENDMENT 426 ANIMAL CONTROL 01 -426-100 -5205 103 GENERAL FUND CAPITAL 103 -425-000- -5205 -ADAFX 02 WATER UTILITY 02 -404-000-5101 02 -404-000-5110 02 -404-000- -5111 02 -404-000- -5112 02 -404-000- -5116 02 -404-000 -5119 02 -404-000 -5122 02 -415-000 -5101 02 -415-000- -5110 02 -415-000- -5111 02 -415-000- -5112 02 -415-000- -5116 02 -415-000- -5122 02 -425-00 -5101 02 -425-00 -5110 02 -425-00 -5111 - 02 -425-00 -5112 02 -425-00 -5116 02 -425-00 -5119 02 -425-00 -5122 04 SEWER UTILITY 04 -404-000- -5101 04 -404-000- -5110 04 -404-000- -5111 04 -404-000 -5112 04 -404-000- -5116 04 -404-000- -5119 PROFESSIONAL & CONTRACTUAL SRV PROFESSIONAL & CONTRACTUAL SRV 96,025 0.00 14 250 246,700 15,361 3,592 21,341 1,754 9,538 6,284 21,695 1,367 320 1,588 231 532 144,572 9,126 2,134 11,720 1,441 4,856 3,591 232,619 14,485 3,388 20,056 1,674 8,957 SALARIES FICA MEDICARE PERS RETIREMENT LTD/LIFE INSURANCE DEFERRED COMP PERS UAL PAYMENT SALARIES FICA MEDICARE PERS RETIREMENT LTD/LIFE INSURANCE PERS UAL PAYMENT SALARIES FICA MEDICARE PERS RETIREMENT LTD/LIFE INSURANCE DEFERRED COMP PERS UAL PAYMENT SALARIES FICA MEDICARE PERS RETIREMENT LTD/LIFE INSURANCE DEFERRED COMP 243,437 15,158 3,545 21,038 1,753 8,258 24,959 1,569 367 1,805 258 151,137 9,533 2,230 12,194 1,496 5,053 229,356 14,283 3,340 19,754 1,674 7,676 3 CITYOF FARMERSVILLE 2023-2024 BUDGET 2023-2024 PROPOSED AMENDMENT 04 -404-000-5122 04 -415-000-5101 04 415-000-5110 04 -415-000-5111 04 -415-000-5112 04 -415-000-5116 04 -415-000- -5122 - 04 -425-00 -5101 04 -425-00 -5110 04 -425-00 -5111 - 04 -425-00 -5112 04 -425-00 -5116 04 -425-00 -5119 04 -425-00 -5122 04 -425-00 -5504 -SLDGE 06 REFUSE 06 -404-000-5122 06 -415-000-5101 06 -415-000-5110 06 -415-000-5111 06 -415-000-5112 06 -415-000- -5116 06 -415-000-5122 06 -425-00 -5122 14 POLICE SLESF 14 -411-00 -5101 -SLESF 14 -411-00 -5110 -SLESF 14 -411-00 -5111 -SLESF 14 -411-00 -5116 -SLESF 14 -411-00 -5122 21G GAS TAX 21 -404-000-5101 PERS UAL PAYMENT SALARIES FICA MEDICARE PERS RETIREMENT LTD/LIFE INSURANCE PERS UAL PAYMENT SALARIES FICA MEDICARE PERS RETIREMENT LTD/LIFE INSURANCE DEFERRED COMP PERS UAL PAYMENT EQUIPMENT PERS UAL PAYMENT SALARIES FICA MEDICARE PERS RETIREMENT LTD/LIFE INSURANCE PERS UAL PAYMENT PERS UAL PAYMENT SALARIES FICA MEDICARE LTD/LIFE INSURANCE PERS UALI PAYMENT SALARIES 24,959 1,569 367 1,805 258 145,659 9,187 2,149 11,698 1,438 4,889 139, 8,7 2,053 11,223 1,383 4,692 3,445 934,342 1,178 10,848 683 160 794 115 266 512 130,685 8,224 1,923 1,287 2,718 19,706 12,480 785 184 902 129 127,610 8,033 1,879 1,263 18,646 CITYOF FARMERSVILLE, 2023-2024 BUDGET 2023-2024 PROPOSED AMENDMENT 21 -404-000-5110 21 -404-000-5111 21 -404-000-5112 21 -404-000-5119 21 -404-000-5122 21 -425-00 -5101 - 21 -425-00 -5110 21 -425-00 -5111 - 21 -425-00 -5112 21 -425-00 -5116 21 -425-00 -5119 21 -425-00 -5122 21 -425-000- -4035 21 -425-000-4036 21 -425-000-4037 21 -425-000 -4038 27 ROAD MAINTENANCE & REHAB (SB1) 27 -425-000 -4081 - 35 MAINTENANCE DISTRICTS 35 -425-00 -5122 60 AMERICAN RESCUE PLAN (ARPA) 60 -420-000- -5504 -TENDR 60 -425-00 -5514 60 -425-000- -5504 60 -425-000- -5504 -PWYRD 81 POLICE DEVELOPMENT 81 -411-000- -5504 FICA MEDICARE PERS RETIREMENT DEFERRED COMP PERS UAL PAYMENT SALARIES FICA MEDICARE PERS RETIREMENT LTD/LIFE INSURANCE DEFERRED COMP PERS UAL PAYMENT STATE GASTAX2103 STATE GASTAX2105 STATE GAS TAX2106 STATE GAS TAX: 2107 STATE GRANT PERS UAL PAYMENT 1,159 271 1,759 559 115,120 7,272 1,701 9,055 1,140 3,973 (111,560) (73,080) (43,529) (99,839) (256,695) 108,3 6,853 1,603 8,568 1,084 3,770 2,667 (91,416) (63,213) (38,966) (86,340) (248,610) 250 7,354 180,736 240,000 73,000 CONSTRUCTION IN PROCESS VEHICLES EQUIPMENT EQUIPMENT EQUIPMENT 240,000 FISCALYEAR2023-24MID-YEAR BUDGET UPDATE City of Farmersville - 2/26/2024 Table of Contents 1 2 3 4 Introduction & Purpose (p.1) Part One: Current Year Progress (p.3) Capital Budget Operation Budget Part Two: Description of Proposed Changes (p.7) Capital Budget Operation Budget Part Three: Financial Health Context for the Budget (p.15) Risk Factors Cash Balances PREVIOUS BUDGET AMENDMENT CHANGES WERE OCCURRING THAT NEEDED TO BE ADDRESSED BUT NO FORMAL BUDGET AMENDMENT Previous years usually had at least one amendment prior to the mid- BROUGHT TO COUNCIL sO FAR 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) YEAR1 YEAR2 YEAR3 YEAR4 YEAR5 2026-27 2027-28 43,500 SUMMARY OF CAPITAL IMPROVEMENTF PLAN Administration Code Enforcement Engineering Fire Planning Police Public Works 2023-24 2024-25 2025-26 TOTAL 43,500 50,000 660,000 7,807,000 435,524 50,000 647,000 6,500,000 305,999 129,525 89,811 168,612 14,938,069 2,436,692 7,531,624 2,327,500 2,842,500 30,076,385 183,542 172,042 197,542 811,549 474,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 33 Capital Budget 71 More Will be Complete by 6/30/2024 Items 3 are Complete 30% of Budget Items Anticipated to be Completed This Year Total Estimated Spending: $5,000,000 YEAR1 YTDSPENT PERCENT OF 2023-24 2023-24 BUDGET CURRENTS STATUS CAPITAL BUDGET FOR FISCAL YEAR: 2023-24 Code Enforcement Vehicle (Air Quality Grant) Birch Water Line Relocation Master Plans for Sewer, Water, and Storm Drain New Water) Well (ARP allocation) City Hall Parking Lot (Phase 1) Pavement Management Program: Ongoing Repairs Solar Plant located atr new WWTP Highway 198 Gateway Improvements (CCLGP) Citrus/Road: 168 Connectivity Street Project Central Fire Station Fire Patrol Vehicle Downtown Specific Plan Zoning Ordinance Update General Plan Update Jennings ParkF Remodel Project New Corporation Yard Sports Park Rehabilitation Project Roy's Park Improvement Skid Steer Loader (Bobcat) Downtown Streetlight Upgrade Freedom Field Booster Pump & Electrical Panel for Sports Park Liberty Park" Trail improvements Pocket Park Improvements Roy's Park- Phase II Vacuum Truck Public Works Backhoe Community Center Air Conditioning Units Public' Works Pickup Trucks Patrol Vehicle Replacement (FY22) Patrol Vehicle Replacement (FY24) Axon Fleet 3In-Vehicle Camera System 50,000 35,000 140,000 822,000 450,000 2,000,000 5,000,000 3,601,069 207,475 190,000 392,000 2,550 255,000 86,567 80,000 39,069 50,000 38,938 175,999 12,750 334,000 240,000 20,185 39,000 96,500 79,706 147,000 117,190 40,188 884,000 843,125 180,000 141,000 150,000 775,000 528,006 384,500 172,000 139,635 108,475 105,725 79,969 58,070 11,500 20,241 TOTAL 19,802,511 4,663,832.97 0.0% COMPLETE BY 6/30 9.0% IN PROGRESS 0.0% IN PROGRESS 0.0% DELAYEDTOFY25 0.3% IN PROGRESS 88.1% COMPLETE BY 6/30 0.0% IN PROGRESS 0.0% DELAYEDT TOF FY25 5.8% IN PROGRESS 0.0% IN PROGRESS 0.7% IN PROGRESS 33.9% IN PROGRESS 48.8% COMPLETE BY 6/30 77.9% COMPLETE BY 6/30 7.2% IN PROGRESS 0.0% IN PROGRESS 8.4% IN PROGRESS 0.0% INF PROGRESS 82.6% INF PROGRESS 79.7% COMPLETED 0.0% IN PROGRESS 95.4% COMPLETE BY 6/30 9.7% IN PROGRESS 0.0% INF PROGRESS 0.0% IN PROGRESS 68.1% IN PROGRESS 0.0% COMPLETE BY 6/30 81.2% COMPLETED 97.5% COMPLETED 0.0% COMPLETE BY 6/30 75.0% IN PROGRESS 0.0% IN PROGRESS 0.0% INF PROGRESS 23.6% 3,150 1,233 Pavement Management Program: Street Repairs Year1 2,700,000 2,377,462 17,515 43,553 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 REVENUES EXPENSES SURPLUS/DEFICIT ACTUALASOF 12/31/2023 PERCENTDIFFERE: 6,512,011 6,412,998 99,013 2,728,770 3,218,850 (490,080) 42% 50% Expenses are 54% this year (55% last year) 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 REVENUES EXPENSES SURPLUS/DEFICIT ACTUALA ASOF 12/31/2023 PERCENT DIFFEREN 1,199,035 1,579,567 (380,532) 598,312 530,310 68,002 50% 34% Expenses are 32% this year (45% last year) 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 REVENUES EXPENSES SURPLUS/DEFICIT ACTUALAS OF 12/31/2023 PERCENTDIFFERENCE 7,123,827 7,647,450 (523,623) 1,001,521 1,672,766 (671,245) 14% 22% Expenses are 30% this year (72% last year) 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 REVENUES EXPENSES SURPLUS/DEFICIT ACTUALASOF 12/31/2023 PERCENT DIFFERENCI 941,077 1,166,036 (224,959) 477,096 372,321 104,775 51% 32% Expenses are 42% this year (51% last year) Located on Page 7 PARTTWO: DESCRIPTIONOF PROPOSED CHANGES - What needs to be changed and why? - YEAR1 2023-24 CHANGE/ /UPDATE FOR MIDYEAR 50,000 WAITING SHIPMENT 35,000 NOCHANGE 140,000 NOCHANGE 822,000 PENDING GRANTA AWARD 450,000 NOCHANGE 5,000,000 PENDING GRANT AWARD 3,601,069 NOCHANGE 190,000 NOCHANGE 392,000 NOCHANGE 255,000 NO CHANGE 80,000 NOCHANGE 50,000 NOCHANGE 175,999 NOCHANGE 334,000 NOCHANGE 240,000 NOCHANGE 39,000 NOCHANGE 96,500 NOCHANGE 147,000 NOCHANGE 40,188 NOCHANGE 884,000 NOCHANGE 180,000 NOCHANGE 141,000 NOCHANGE 150,000 NOCHANGE 775,000 NOCHANGE 384,500 WAITING SHIPMENT 172,000 NOCHANGE 108,475 NOCHANGE 79,969 WAITING SHIPMENT 58,070 NOCHANGE 11,500 NO CHANGE 20,241 NOCHANGE 180,736 ADDNEW PROJECT 934,342 ADDNEW PROJECT 250,000 RELIST OLDPROJECT 11,000 ADDNEW! PROJECT 62,000 ADDNEW! PROJECT 7,354 RELIST OLDPROJECT TOTAL 21,247,943 CAPITAL BUDGET FORF FISCAL YEAR 2023-24 Code Enforcement Vehicle (Air Quality Grant) Birch Water Line Relocation Master Plans for Sewer, Water, and Storm Drain New Water Well (ARP allocation) City Hall Parking! Lot (Phase 1) Solar Plantl located atr new WWTP Highway 198 Gateway! Improvements (CCLGP) Citrus/Road: 168 Connectivity Street Project Central Fire Station Fire Patrol Vehicle Downtown! Specifick Plan Zoning Ordinance Update General Plan Update Jennings Park Remodel Project New Corporation Yard Sports Park Rehabilitation Project Roy's Park Improvement Skids Steer Loader (Bobcat) Downtown: Streetlight Upgrade Freedom Field Booster Pump8 & Electrical Panel for Sports Park Liberty Park" Trail Improvements Pocket Park Improvements Roy's Park- Phasel II Vacuum Truck Public Works Backhoe Community Center Air Conditioning Units Public Works Pickup Trucks Patrol Vehicle Replacement (FY22) Patrol Vehicle Replacement (FY24) Axon Fleet 3In-Vehice Camera! System Public Works Bucket Truck (emergency purchase) Sewer Plant De- Watering System ADA Sidewalk Improvements Police Electric Bicycle Police Camera Pod System Fire Department Water Tender Capital Budget Proposed Revision Pavement Management Program: Street Repairs Year1 2,700,000 NOCHANGE Pavement Management Program: Ongoing Repairs 2,000,000 NO CHANGE Many Changes: Timing Capacity Scope Pages 7-11 Operation Budget Changes Tax Revenues Sales Tax & Other Revenues Negative Trend Service Costs Animal Control, Street Repairs, Transit Costs, Normal Operations City Staffing Position Turnover, Benefit Changes, and Pension Costs Increasing Fund Dept Original Budget Revised Budget Amount Percent 289,406.00 -5.3% 0.0% (23,793.00) -5.8% 0.0% (40,591.00) -10.7% 0.0% 1,957.00 0.1% 906.00 0.2% (8,064.00) -6.2% 9,816.00 1.2% (80.00) 0.0% 46,757.00 48.9%. 97.5% 101.8% 1:General Fund 400: Revenues 1: General Fund 401: City Council 1:G General Fund 404: Administration 1: General Fund 405: Membership Legislation 1:General Fund 406: Administrative Overhead 1:G General Fund 407: City sponsorships 1:General Fund 411: Police 1: General Fund 414: Community Development 1: General Fund 415: Code Enforcement 1: General Fund 420: Fire 1:General Fund 425: Public' Works 1: General Fund 426: Animal Control (5,409,846) 29,648 413,583 16,000 378,861 12,000 2,382,855 468,089 130,119 824,665 559,387 95,625 (6,512,011) 6,412,998 (99,013) (5,120,440) 29,648 389,790 16,000 338,270 12,000 2,384,812 468,995 122,055 834,481 559,307 142,382 (6,348,990) 6,526,291 177,301 of Summary Budget Changes Page 12 Total Revenues Total Expenses Net -2.7% Margin PART THREE: FINANCIAL HEALTH CONTEXT FOR THEBUDGET Page-5 Local Government High-Risk Dashboard Farmersville Low Statewide Rank: 316 GeneralFund Reserves Debt Burden Liquidity Revenue Trends Pension Obligations Pension Funding Pension Costs Future Pension Costs OPEBO Obligations OPEBFunding flara San. Jose Atwater, Merced taCrur Hollister Salinas Fresno Solegad KingCity Porterville FARMERVILLE RISK SCORE Farmersville Ranked 356/471 (Higher Score = Less Risks) Highest Rank in Tulare County Not a Raw Score, but a Ranking Risk Assessment Based Upon 10 Factors Most Significant Factors: C General Fund Reserves (30%) Debt Burden (15%) F Pension Obligation (10%) OPEB Obligation (10%) FARMERSVILLE IN TOP 1/4OF California State Auditor's Local Government High- Risk Rating Financial Indicators (2021) Points Possible Farmersville Score Farmersville Liquidity Debt Burden General Fund Reserves Revenue Trends Pension Obligations Pension Funding Pension Costs Future Pension Costs OPEB Obligations OPEB Funding Total 10 15 30 5 10 5 5 5 10 5 100 10 6.5 30 5 10 4.85 4.17 4.17 10 5 89.69 57 36 276 416 332 349 316 366 n/a n/a 356 STATE State's Focus for Farmersville: Fully Fund Reserves Pre-pay Debt Reduce Pension Obligations Avoid OPEB FARMERSVILLE STAYS ON BUDGET General Fund Expense- Budgetvs.Actual PAGE 17 - IT 7 7 2018 2019 2020 2021 Budget Actual 2022 2023 2024 General Fund Revenue & Expense Actuals (and FY2024Budget) Page 18 / I 2018 2019 2020 Expense 2021 Revenue 2022 Linear (Expense) 2023 2024 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 FY2024 ACCOUNT 6/30/2021 6/30/2022 12/31/2022 6/30/2023 12/31/2023 1,347,524.58 641,284.08 (382,270.39) 201,839.91 01 GENERAL FUND 08 SELF INSURED RESERVES 60 AMERICAN RESCUE PLAN (ARPA) 102 GENERAL FUND RESERVE 103 GENERAL FUND CAPITAL 104 MEASURE Q (CANNABIS) General Government Total (61,412.72 551,000.00 801,000.00 801,000.00 801,000.00 801,000.00 1,176,000.79 2,299,954.43 2,214,152.53 2,100,849.52 1,439,868.82 1,439,868.82 1,439,868.82 1,439,868.82 1,439,868.82 1,065,025.91 1,462,839.03 2,063,006.75 1,477,750.66 1,889,989.39 4,403,419.31 5,520,992.72 6,008,077.00 6,134,151.00 5,931,732.05 (213,482.61) (460.92) (238,562.96) QUESTIONS? Thank You!