Loading...
HomeMy WebLinkAbout2022-08-31 Accounting2022 YTD ACTIVITY FOR AMENDED BALANCE MONTH ENCUMBERED UNENCUMBERED % BDGT ACCOUNT DESCRIPTION BUDGET 08/31/2022 08/31/22 YEAR-TO-DATE BALANCE USED Fund 240 - LIBRARY 41010 REGULAR EMPLOYEES 442,600.00 294,988.67 26,645.99 0.00 147,611.33 66.65 41011 PART-TIME EMPLOYEES 113,300.00 65,105.95 6,836.31 0.00 48,194.05 57.46 41020 OVERTIME-REGULAR 900.00 423.25 32.17 0.00 476.75 47.03 41070 INTERDEPARTMENTAL LABOR SERV 2,000.00 0.00 0.00 0.00 2,000.00 0.00 41210 P.E.R.A. CONTRIBUTION 41,900.00 26,426.60 3,155.97 0.00 15,473.40 63.07 41220 F.I.C.A. CONTRIBUTION 42,800.00 27,405.71 2,527.58 0.00 15,394.29 64.03 41300 INSURANCE 78,200.00 50,945.30 6,368.45 0.00 27,254.70 65.15 41510 WORKERS COMP INSURANCE PREM 2,700.00 2,623.52 332.60 0.00 76.48 97.17 41810 COLA ALLOWANCE 21,200.00 0.00 0.00 0.00 21,200.00 0.00 42000 OFFICE SUPPLIES 1,200.00 826.26 296.38 0.00 373.74 68.86 42010 MINOR EQUIPMENT 100.00 885.67 84.95 0.00 (785.67)885.67 1 42011 END USER DEVICES 30,100.00 5,168.69 0.00 29,280.00 (4,348.69)114.45 2 42012 OTHER TECHNOLOGY EQUIPMENT 0.00 141.97 0.00 0.00 (141.97)100.00 42020 COMPUTER SUPPLIES 100.00 0.00 0.00 0.00 100.00 0.00 42030 PRINTING & PRINTED FORMS 900.00 206.50 0.00 0.00 693.50 22.94 42170 PROGRAM SUPPLIES 1,800.00 972.91 0.00 0.00 827.09 54.05 42171 GENERAL SUPPLIES 6,600.00 9,919.12 786.30 0.00 (3,319.12)150.29 3 42175 FOOD SUPPLIES 200.00 67.21 25.92 0.00 132.79 33.61 42180 BOOKS 58,000.00 26,387.45 5,517.77 0.00 31,612.55 45.50 42181 PERIODICALS, MAG, NEWSPAPERS 7,000.00 2,373.77 0.00 0.00 4,626.23 33.91 42183 E-BOOKS 8,000.00 0.00 0.00 0.00 8,000.00 0.00 42185 COMPACT DISCS 5,000.00 2,175.42 370.78 0.00 2,824.58 43.51 42187 BOOK/CD SET 500.00 0.00 0.00 0.00 500.00 0.00 42189 DVD 6,300.00 2,779.15 11.24 0.00 3,520.85 44.11 42190 DOWNLOADABLE VIDEO 2,500.00 0.00 0.00 0.00 2,500.00 0.00 42990 COMM. PURCHASED FOR RESALE 300.00 0.00 0.00 0.00 300.00 0.00 43050 EXPERT & PROFESSIONAL SERV.19,200.00 9,951.07 165.60 6,656.22 2,592.71 86.50 4 43105 TRAINING & EDUCATION ACTIVITIES 500.00 266.16 0.00 0.00 233.84 53.23 43210 TELEPHONE 700.00 239.85 22.15 0.00 460.15 34.26 43220 POSTAGE 200.00 75.97 0.00 0.00 124.03 37.99 43250 OTHER TELECOMMUNICATIONS 2,300.00 1,580.27 204.13 0.00 719.73 68.71 43310 LOCAL TRAVEL EXPENSE 700.00 95.72 0.00 0.00 604.28 13.67 43600 PROP & LIAB INSURANCE 9,300.00 5,425.00 0.00 0.00 3,875.00 58.33 43800 UTILITY SERVICES 0.00 2,398.01 0.00 0.00 (2,398.01)100.00 5 43810 ELECTRIC 37,100.00 24,592.17 4,655.89 0.00 12,507.83 66.29 43820 WATER 2,700.00 0.00 0.00 0.00 2,700.00 0.00 43830 GAS 8,000.00 8,892.04 114.14 0.00 (892.04)111.15 43850 SEWER 3,200.00 0.00 0.00 0.00 3,200.00 0.00 44000 REPAIR & MAINT. SERVICES 19,600.00 16,420.00 240.95 0.00 3,180.00 83.78 44010 BUILDING MAINT:INTERNAL SVCS 39,300.00 22,951.81 0.00 0.00 16,348.19 58.40 44020 BLDG MAINT CONTRACTUAL SERVICES 27,100.00 24,616.38 3,436.83 0.00 2,483.62 90.84 44040 INFORMATION SYS:INTERNAL SVC 74,300.00 43,341.69 0.00 0.00 30,958.31 58.33 44050 GARAGE, LABOR BURD.500.00 0.00 0.00 0.00 500.00 0.00 44310 CREDIT CARD FEES 300.00 0.00 0.00 0.00 300.00 0.00 44330 SUBSCRIPTION, MEMBERSHIP 650.00 0.00 0.00 0.00 650.00 0.00 44375 VOLUNTEER RECOGNITION 200.00 0.00 0.00 0.00 200.00 0.00 47100 OPER. TRANSFER OUT - LABOR 15,750.00 9,187.50 0.00 0.00 6,562.50 58.33 TOTAL EXPENDITURES 1,135,800.00 689,856.76 61,832.10 35,936.22 410,007.02 63.90 1: Outreach Event Shade Canopy + Weight Bags ($700.73) 2: Laptop+Docking Station, Department-wide Microsoft Licenses 3: Building HEPA Filters…replaced every 5/6 years ($3,918.45) 4: 2022 ILS Operating Costs-Blanket PO ($13,312.44…$6,656.22 spent so far) 5: Water, Sewer, Stormwater Base Charge (usage excluded) EXPENDITURE REPORT FOR CITY OF COLUMBIA HEIGHTS Fiscal Year Completed: 66.58%