Loading...
HomeMy WebLinkAboutIII - BillsGL ACTIVITY REPORT FOR CITY OF HASTINGS From 06/01/2025 to 07/30/2025 Date JNL Type Description Reference #Debits Credits Balance 06/01/2025 407-1502-6101.0000 FULL-TIME SALARIES-REGULAR BEG. BALANCE 98,504.89 06/06/2025 PR CHK SUMMARY PR 06/06/2025 9,119.34 107,624.23 06/20/2025 PR CHK SUMMARY PR 06/20/2025 9,119.39 116,743.62 07/03/2025 PR CHK SUMMARY PR 07/03/2025 9,119.36 125,862.98 07/18/2025 PR CHK SUMMARY PR 07/18/2025 9,119.39 134,982.37 07/30/2025 END BALANCE 36,477.48 134,982.37 06/01/2025 407-1502-6103.0000 PART-TIME SALARIES-REGULAR BEG. BALANCE 0.00 06/06/2025 PR CHK SUMMARY PR 06/06/2025 1,287.00 1,287.00 06/20/2025 PR CHK SUMMARY PR 06/20/2025 1,296.00 2,583.00 07/03/2025 PR CHK SUMMARY PR 07/03/2025 1,233.00 3,816.00 07/18/2025 PR CHK SUMMARY PR 07/18/2025 1,395.00 5,211.00 07/30/2025 END BALANCE 5,211.00 5,211.00 06/01/2025 407-1502-6121.0000 EMPLOYER CONTRIBUTION-PERA BEG. BALANCE 7,387.84 06/06/2025 PR CHK SUMMARY PR 06/06/2025 683.95 8,071.79 06/20/2025 PR CHK SUMMARY PR 06/20/2025 683.95 8,755.74 07/03/2025 PR CHK SUMMARY PR 07/03/2025 683.95 9,439.69 07/18/2025 PR CHK SUMMARY PR 07/18/2025 683.95 10,123.64 07/30/2025 END BALANCE 2,735.80 10,123.64 06/01/2025 407-1502-6122.0000 EMPLOYER CONTRIBUTION-FICA/MED BEG. BALANCE 7,497.91 06/06/2025 PR CHK SUMMARY PR 06/06/2025 793.28 8,291.19 06/20/2025 PR CHK SUMMARY PR 06/20/2025 792.94 9,084.13 07/03/2025 PR CHK SUMMARY PR 07/03/2025 788.13 9,872.26 07/18/2025 PR CHK SUMMARY PR 07/18/2025 800.53 10,672.79 07/30/2025 END BALANCE 3,174.88 10,672.79 06/01/2025 407-1502-6131.0000 EMPLOYER PAID-HEALTH INSURANCE BEG. BALANCE 11,141.59 06/06/2025 PR CHK SUMMARY PR 06/06/2025 1,872.92 13,014.51 06/20/2025 PR CHK SUMMARY PR 06/20/2025 91.67 13,106.18 06/29/2025 AP INV WEX HEALTH, INC.2174531-IN 4.81 13,110.99 07/03/2025 PR CHK SUMMARY PR 07/03/2025 1,872.92 14,983.91 07/18/2025 PR CHK SUMMARY PR 07/18/2025 91.67 15,075.58 07/30/2025 END BALANCE 3,933.99 15,075.58 06/01/2025 407-1502-6133.0000 EMPLOYER PAID-LIFE INSURANCE BEG. BALANCE 60.35 06/06/2025 PR CHK SUMMARY PR 06/06/2025 12.08 72.43 07/03/2025 PR CHK SUMMARY PR 07/03/2025 12.07 84.50 07/30/2025 END BALANCE 24.15 84.50 06/01/2025 407-1502-6134.0000 EMPLOYER PAID-DISABILITY (LTD)BEG. BALANCE 146.19 06/06/2025 PR CHK SUMMARY PR 06/06/2025 30.10 176.29 07/03/2025 PR CHK SUMMARY PR 07/03/2025 30.10 206.39 07/30/2025 END BALANCE 60.20 206.39 06/01/2025 407-1502-6201.0000 OFFICE SUPPLIES BEG. BALANCE 83.13 07/05/2025 AP INV BMO 06/23/2025 31.30 114.43 07/30/2025 END BALANCE 31.30 114.43 06/01/2025 407-1502-6304.0000 LEGAL FEES BEG. BALANCE 1,972.00 06/17/2025 AP INV CAMPBELL KNUTSON P.A.3445-0004G-12 200.00 2,172.00 07/15/2025 AP INV LEVANDER GILLEN & MILLER PA JUNE 2025 2,016.00 4,188.00 07/30/2025 END BALANCE 2,216.00 4,188.00 06/01/2025 407-1502-6311.0000 EXPERT & CONSULTANT BEG. BALANCE 10,575.40 07/30/2025 END BALANCE 10,575.40 06/01/2025 407-1502-6319.0000 OTHER PROFESSIONAL SERVICES BEG. BALANCE 1,461.54 07/30/2025 END BALANCE 1,461.54 06/01/2025 407-1502-6322.0000 POSTAGE BEG. BALANCE 2.76 07/30/2025 END BALANCE 2.76 06/01/2025 407-1502-6323.0000 CONFERENCE & SCHOOLS BEG. BALANCE 356.45 06/07/2025 AP INV BMO 05/02/2025 220.00 576.45 07/31/2025 09:00 AM Page:1/2 GL ACTIVITY REPORT FOR CITY OF HASTINGS From 06/01/2025 to 07/30/2025 Date JNL Type Description Reference #Debits Credits Balance 06/07/2025 AP INV BMO 04/25/2025 230.52 806.97 07/30/2025 END BALANCE 450.52 806.97 06/01/2025 407-1502-6324.0000 MILEAGE BEG. BALANCE 108.92 07/30/2025 END BALANCE 108.92 06/01/2025 407-1502-6331.0000 ADVERTISING-PROMOTIONAL BEG. BALANCE 230.59 07/30/2025 END BALANCE 230.59 06/01/2025 407-1502-6337.0000 INSURANCE - GENERAL LIABILITY BEG. BALANCE 2,556.37 06/30/2025 DTDF JE QUARTERLY GEN LIABILITY INSURANCE 00000906 2,556.37 5,112.74 07/30/2025 END BALANCE 2,556.37 5,112.74 06/01/2025 407-1502-6340.0000 INSURANCE - WORKERS COMP BEG. BALANCE 218.24 06/30/2025 DTDF JE QUARTERLY WORKERS COMP INSURANCE 00000907 218.24 436.48 07/30/2025 END BALANCE 218.24 436.48 06/01/2025 407-1502-6343.0000 LIGHT & POWER BEG. BALANCE (13.40) 07/30/2025 END BALANCE (13.40) 06/01/2025 407-1502-6350.0000 REPAIRS & MAINTENANCE - BLDG BEG. BALANCE 1,355.00 06/24/2025 AP INV FOXS FLOWRITE GUTTERS 6-13-25 150.00 1,505.00 07/30/2025 END BALANCE 150.00 1,505.00 06/01/2025 407-1502-6402.0000 GRANTS BEG. BALANCE 0.00 06/24/2025 AP INV HOESCHEN, LYNN 2025-05 1,800.00 1,800.00 07/08/2025 AP INV ELJIN PROPERTIES, LLC.2025-04 5,000.00 6,800.00 07/30/2025 END BALANCE 6,800.00 6,800.00 06/01/2025 407-1502-6450.0000 MISCELLANEOUS BEG. BALANCE 0.00 06/10/2025 AP INV THE JOURNAL 95064 2,700.00 2,700.00 07/22/2025 AP INV KDWA KDWA3101250673757 645.00 3,345.00 07/22/2025 AP INV KDWA KDWA3101250773758 660.00 4,005.00 07/22/2025 AP INV KDWA KDWA3101250873760-435.00 4,440.00 07/30/2025 END BALANCE 4,440.00 4,440.00 06/01/2025 407-1502-6720.0000 OPERATING TRANSFER OUT BEG. BALANCE 5,996.00 06/30/2025 DTDF JE QUARTERLY ADMIN FEE TRANSFER 00000902 5,996.00 11,992.00 07/30/2025 END BALANCE 5,996.00 11,992.00 06/01/2025 413-0000-6319.0000 OTHER PROFESSIONAL SERVICES BEG. BALANCE 93,991.02 06/03/2025 AP INV CENTERPOINT ENERGY 2025.05.19 53.41 94,044.43 06/10/2025 AP INV MIDWEST ELECTRICAL CONSTRUCTION 25-1334 240.00 94,284.43 06/17/2025 AP INV SRF CONSULTING GROUP INC 16799.00-20 82.50 94,366.93 07/08/2025 AP INV CENTERPOINT ENERGY 13764593-3 06-23-2 36.04 94,402.97 07/08/2025 AP INV CENTERPOINT ENERGY 13851748-7 MAY-JU 45.33 94,448.30 07/08/2025 AP INV CENTERPOINT ENERGY 13848982-8 MAY JUN 39.87 94,488.17 07/08/2025 AP INV MOSENG LOCKSMITHING 25079 86.43 94,574.60 07/08/2025 AP INV PRECISION LANDSCAPING & CONSTRUCTIO 196339 255.00 94,829.60 07/08/2025 AP INV XCEL ENERGY 931457348 207.10 95,036.70 07/22/2025 AP INV FSHS LEASING GROUP LLC 1 1,710.23 96,746.93 07/22/2025 AP INV LAKE ISABELLE FLATS LLC TIF9-AUG25 89,409.23 186,156.16 07/22/2025 AP INV PRECISION LANDSCAPING & CONSTRUCTIO 198917 85.00 186,241.16 07/22/2025 AP INV PRECISION LANDSCAPING & CONSTRUCTIO 198763 255.00 186,496.16 07/29/2025 AP INV XCEL ENERGY 935842331 282.17 186,778.33 07/30/2025 END BALANCE 92,787.31 186,778.33 07/31/2025 09:00 AM Page:2/2