Loading...
General Fund Expenses.123121 01/13/2022 16:35 |CITY OF NORTHAMPTON, MA - LIVE |P 1 1281cnar |YTD FY2022 GENERAL FUND EXPENSES |glytdbud 2ND QUARTER FOR 2022 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 111 CITY COUNCIL _________________________________________ 11111 CITY COUNCIL-PS 143,036 0 143,036 70,056.84 .00 72,979.16 49.0% 11112 CITY COUNCIL-OM 60,600 0 60,600 551.27 .00 60,048.73 .9% TOTAL CITY COUNCIL 203,636 0 203,636 70,608.11 .00 133,027.89 34.7% 121 MAYOR _________________________________________ 11211 MAYOR-PS 419,269 0 419,269 195,341.79 .00 223,927.21 46.6% 11212 MAYOR-OM 16,442 0 16,442 7,736.02 .00 8,705.98 47.1% TOTAL MAYOR 435,711 0 435,711 203,077.81 .00 232,633.19 46.6% 135 AUDITOR _________________________________________ 11351 AUDITOR-PS 362,901 0 362,901 169,016.68 .00 193,884.32 46.6% 11352 AUDITOR-OM 15,280 0 15,280 1,064.23 .00 14,215.77 7.0% TOTAL AUDITOR 378,181 0 378,181 170,080.91 .00 208,100.09 45.0% 141 ASSESSOR _________________________________________ 11411 ASSESSOR-PS 178,124 0 178,124 81,780.27 .00 96,343.73 45.9% 11412 ASSESSOR-OM 123,650 62,348 185,998 50,118.31 .00 135,879.69 26.9% TOTAL ASSESSOR 301,774 62,348 364,122 131,898.58 .00 232,223.42 36.2% 146 COLLECTOR _________________________________________ 11461 COLLECTOR-PS 396,099 0 396,099 184,536.21 .00 211,562.79 46.6% 11462 COLLECTOR-OM 276,435 0 276,435 92,466.79 .00 183,968.21 33.4% TOTAL COLLECTOR 672,534 0 672,534 277,003.00 .00 395,531.00 41.2% 151 LEGAL SERVICES _________________________________________ 01/13/2022 16:35 |CITY OF NORTHAMPTON, MA - LIVE |P 2 1281cnar |YTD FY2022 GENERAL FUND EXPENSES |glytdbud 2ND QUARTER FOR 2022 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 151 LEGAL SERVICES APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 11512 LEGAL SERVICES-OM 275,000 0 275,000 81,729.33 .00 193,270.67 29.7% TOTAL LEGAL SERVICES 275,000 0 275,000 81,729.33 .00 193,270.67 29.7% 152 HUMAN RESOURCES _________________________________________ 11521 HUMAN RESOURCES-PS 310,139 0 310,139 140,330.15 .00 169,808.85 45.2% 11522 HUMAN RESOURCES-OM 19,550 0 19,550 2,410.46 .00 17,139.54 12.3% TOTAL HUMAN RESOURCES 329,689 0 329,689 142,740.61 .00 186,948.39 43.3% 155 INFORMATION TECHNOLOGY _________________________________________ 11551 INFORMATION TECHNOLOGY - PS 466,231 0 466,231 189,814.79 .00 276,416.21 40.7% 11552 INFORMATION TECHNOLOGY - OM 688,089 0 688,089 400,740.26 .00 287,348.74 58.2% TOTAL INFORMATION TECHNOLOGY 1,154,320 0 1,154,320 590,555.05 .00 563,764.95 51.2% 161 CITY CLERK _________________________________________ 11611 CITY CLERK-PS 306,893 0 306,893 149,884.98 .00 157,008.02 48.8% 11612 CITY CLERK-OM 32,525 1,236 33,761 32,130.92 .00 1,630.28 95.2% TOTAL CITY CLERK 339,418 1,236 340,654 182,015.90 .00 158,638.30 53.4% 175 PLANNING & SUSTAINABILITY _________________________________________ 11751 PLANNING & SUSTAINABILITY - P 390,089 0 390,089 179,577.84 .00 210,511.16 46.0% 11752 PLANNING & SUSTAINABILITY -OM 61,200 0 61,200 18,101.86 .00 43,098.14 29.6% TOTAL PLANNING & SUSTAINABILITY 451,289 0 451,289 197,679.70 .00 253,609.30 43.8% 192 CENTRAL SERVICES _________________________________________ 01/13/2022 16:35 |CITY OF NORTHAMPTON, MA - LIVE |P 3 1281cnar |YTD FY2022 GENERAL FUND EXPENSES |glytdbud 2ND QUARTER FOR 2022 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 192 CENTRAL SERVICES APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 11921 CENTRAL SERVICES-PS 749,152 0 749,152 302,634.28 .00 446,517.72 40.4% 11922 CENTRAL SERVICES-OM 1,060,050 122,471 1,182,521 593,325.91 .00 589,194.67 50.2% TOTAL CENTRAL SERVICES 1,809,202 122,471 1,931,673 895,960.19 .00 1,035,712.39 46.4% 210 POLICE _________________________________________ 12101 POLICE-PS 5,653,469 0 5,653,469 2,505,354.93 .00 3,148,114.07 44.3% 12102 POLICE-OM 555,965 95,903 651,868 241,859.96 .00 410,008.04 37.1% 12103 POLICE-CAP 0 4,474 4,474 4,474.08 .00 .00 100.0% TOTAL POLICE 6,209,434 100,377 6,309,811 2,751,688.97 .00 3,558,122.11 43.6% 211 PARKING ENFORCEMENT _________________________________________ 12111 PARKING ENFORCEMENT-PS 188,023 0 188,023 60,248.93 .00 127,774.07 32.0% 12112 PARKING ENFORCEMENT-OM 12,200 0 12,200 2,045.65 .00 10,154.35 16.8% TOTAL PARKING ENFORCEMENT 200,223 0 200,223 62,294.58 .00 137,928.42 31.1% 212 PUBLIC SAFETY COMM CENTER _________________________________________ 12121 PUBLIC SAFETY COMM CTR-PS 696,014 0 696,014 226,875.53 .00 469,138.47 32.6% 12122 PUBLIC SAFETY COMM CTR-OM 31,392 0 31,392 16,794.16 .00 14,597.84 53.5% TOTAL PUBLIC SAFETY COMM CENTER 727,406 0 727,406 243,669.69 .00 483,736.31 33.5% 220 FIRE RESCUE DEPARTMENT _________________________________________ 12201 FIRE RESCUE - PS 5,803,146 0 5,803,146 2,717,820.68 .00 3,085,325.32 46.8% 12202 FIRE RESCUE - OM 778,930 329,294 1,108,224 262,743.72 .00 845,480.12 23.7% TOTAL FIRE RESCUE DEPARTMENT 6,582,076 329,294 6,911,370 2,980,564.40 .00 3,930,805.44 43.1% 241 BUILDING INSPECTORS _________________________________________ 01/13/2022 16:35 |CITY OF NORTHAMPTON, MA - LIVE |P 4 1281cnar |YTD FY2022 GENERAL FUND EXPENSES |glytdbud 2ND QUARTER FOR 2022 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 241 BUILDING INSPECTORS APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 12411 BUILDING INSPECTORS-PS 493,086 0 493,086 219,612.11 .00 273,473.89 44.5% 12412 BUILDING INSPECTORS-OM 26,200 0 26,200 5,228.32 .00 20,971.68 20.0% TOTAL BUILDING INSPECTORS 519,286 0 519,286 224,840.43 .00 294,445.57 43.3% 421 DPW-ADMIN & ENGINEERING _________________________________________ 14211 DPW ADMINISTRATION-PS 245,357 0 245,357 104,229.74 .00 141,127.26 42.5% 14212 DPW ADMINISTRATION-OM 37,750 0 37,750 15,950.27 .00 21,799.73 42.3% TOTAL DPW-ADMIN & ENGINEERING 283,107 0 283,107 120,180.01 .00 162,926.99 42.5% 422 HIGHWAYS _________________________________________ 14221 HIGHWAYS-PS 754,107 0 754,107 276,941.17 .00 477,165.83 36.7% 14222 HIGHWAYS-OM 445,150 72,800 517,950 162,449.32 .00 355,500.68 31.4% 14223 HIGHWAYS-CAP 510,000 325,176 835,176 75,413.97 .00 759,762.38 9.0% TOTAL HIGHWAYS 1,709,257 397,976 2,107,233 514,804.46 .00 1,592,428.89 24.4% 423 SNOW & ICE _________________________________________ 14231 SNOW & ICE-PS 131,000 0 131,000 16,181.95 .00 114,818.05 12.4% 14232 SNOW & ICE-OM 369,000 0 369,000 64,347.84 .00 304,652.16 17.4% TOTAL SNOW & ICE 500,000 0 500,000 80,529.79 .00 419,470.21 16.1% 481 PARKING _________________________________________ 14811 PARKING-PS 245,016 0 245,016 110,688.88 .00 134,327.12 45.2% 14812 PARKING-OM 261,966 0 261,966 82,189.23 .00 179,776.77 31.4% 14813 PARKING-CAP 90,000 0 90,000 34,873.11 .00 55,126.89 38.7% TOTAL PARKING 596,982 0 596,982 227,751.22 .00 369,230.78 38.2% 492 DPW FORESTRY, PARKS & REC _________________________________________ 01/13/2022 16:35 |CITY OF NORTHAMPTON, MA - LIVE |P 5 1281cnar |YTD FY2022 GENERAL FUND EXPENSES |glytdbud 2ND QUARTER FOR 2022 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 492 DPW FORESTRY, PARKS & REC APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 14921 DPW FORESTRY, PARKS & REC-PS 1,006,070 0 1,006,070 395,731.44 .00 610,338.56 39.3% 14922 DPW FORESTRY, PARKS & REC-OM 293,750 0 293,750 124,587.02 .00 169,162.98 42.4% 14923 DPW FORESTRY, PARKS & REC-CAP 150,000 162,124 312,124 42,812.50 .00 269,311.33 13.7% TOTAL DPW FORESTRY, PARKS & REC 1,449,820 162,124 1,611,944 563,130.96 .00 1,048,812.87 34.9% 511 HEALTH DEPARTMENT _________________________________________ 15111 HEALTH DEPARTMENT - PS 548,630 0 548,630 215,314.34 .00 333,315.66 39.2% 15112 HEALTH DEPARTMENT - OM 43,710 0 43,710 27,064.16 .00 16,645.84 61.9% TOTAL HEALTH DEPARTMENT 592,340 0 592,340 242,378.50 .00 349,961.50 40.9% 529 COMMUNITY CARE _________________________________________ 15291 COMMUNITY CARE-PS 112,255 0 112,255 1,043.13 .00 111,211.87 .9% 15292 COMMUNITY CARE-OM 311,700 0 311,700 225.00 .00 311,475.00 .1% TOTAL COMMUNITY CARE 423,955 0 423,955 1,268.13 .00 422,686.87 .3% 541 SENIOR SERVICES _________________________________________ 15411 SENIOR SERVICES -PS 346,611 0 346,611 179,999.89 .00 166,611.11 51.9% 15412 SENIOR SERVICES - OM 46,264 0 46,264 16,099.61 .00 30,164.39 34.8% TOTAL SENIOR SERVICES 392,875 0 392,875 196,099.50 .00 196,775.50 49.9% 543 VETERANS' SERVICE _________________________________________ 15431 VETERANS' SERVICE-PS 219,824 0 219,824 101,796.96 .00 118,027.04 46.3% 15432 VETERANS' SERVICE-OM 580,600 0 580,600 169,128.04 .00 411,471.96 29.1% TOTAL VETERANS' SERVICE 800,424 0 800,424 270,925.00 .00 529,499.00 33.8% 610 FORBES LIBRARY _________________________________________ 01/13/2022 16:35 |CITY OF NORTHAMPTON, MA - LIVE |P 6 1281cnar |YTD FY2022 GENERAL FUND EXPENSES |glytdbud 2ND QUARTER FOR 2022 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 610 FORBES LIBRARY APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 16101 FORBES LIBRARY-PS 1,239,873 0 1,239,873 723,259.25 .00 516,613.75 58.3% 16102 FORBES LIBRARY-OM 193,108 0 193,108 132,100.05 .00 61,007.95 68.4% TOTAL FORBES LIBRARY 1,432,981 0 1,432,981 855,359.30 .00 577,621.70 59.7% 611 LILLY LIBRARY _________________________________________ 16111 LILLY LIBRARY-PS 270,581 0 270,581 157,838.94 .00 112,742.06 58.3% 16112 LILLY LIBRARY-OM 91,400 0 91,400 53,316.69 .00 38,083.31 58.3% TOTAL LILLY LIBRARY 361,981 0 361,981 211,155.63 .00 150,825.37 58.3% 630 PARKS & RECREATION DEPARTMENT _________________________________________ 16301 PARKS & RECREATION - PS 327,233 0 327,233 161,571.66 .00 165,661.34 49.4% 16302 PARKS & RECREATION-OM 39,000 0 39,000 13,051.06 .00 25,948.94 33.5% TOTAL PARKS & RECREATION DEPARTMENT 366,233 0 366,233 174,622.72 .00 191,610.28 47.7% 699 ARTS AND CULTURE _________________________________________ 16991 ARTS & CULTURE-PS 67,785 0 67,785 31,708.92 .00 36,076.08 46.8% 16992 ARTS & CULTURE-OM 21,250 0 21,250 20,750.00 .00 500.00 97.6% TOTAL ARTS AND CULTURE 89,035 0 89,035 52,458.92 .00 36,576.08 58.9% 710 MUNICIPAL INDEBTEDNESS _________________________________________ 17103 MUNICIPAL DEBT SERVICE 4,111,300 0 4,111,300 1,860,300.00 .00 2,251,000.00 45.2% TOTAL MUNICIPAL INDEBTEDNESS 4,111,300 0 4,111,300 1,860,300.00 .00 2,251,000.00 45.2% 750 INTEREST ON DEBT _________________________________________ 01/13/2022 16:35 |CITY OF NORTHAMPTON, MA - LIVE |P 7 1281cnar |YTD FY2022 GENERAL FUND EXPENSES |glytdbud 2ND QUARTER FOR 2022 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 750 INTEREST ON DEBT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 17503 INTEREST ON MUNICIPAL DEBT 950,324 0 950,324 520,060.43 .00 430,263.57 54.7% TOTAL INTEREST ON DEBT 950,324 0 950,324 520,060.43 .00 430,263.57 54.7% 911 CONTRIBUTORY RETIREMENT _________________________________________ 19111 CONTRIBUTORY RETIREMENT-PS 6,835,018 0 6,835,018 6,812,600.00 .00 22,418.00 99.7% 19112 CONTRIBUTORY RETIREMENT-OM 10,000 0 10,000 .00 .00 10,000.00 .0% TOTAL CONTRIBUTORY RETIREMENT 6,845,018 0 6,845,018 6,812,600.00 .00 32,418.00 99.5% 912 WORKERS' COMP INSURANCE _________________________________________ 19121 WORKERS' COMP INSURANCE 465,281 0 465,281 462,623.00 .00 2,658.00 99.4% 19122 WORKERS' COMP INSURANCE 237,298 0 237,298 239,952.00 .00 -2,654.00 101.1% TOTAL WORKERS' COMP INSURANCE 702,579 0 702,579 702,575.00 .00 4.00 100.0% 913 UNEMPLOYMENT INSURANCE _________________________________________ 19131 UNEMPLOYMENT INSURANCE 100,000 30,000 130,000 2,164.27 .00 127,835.73 1.7% 19132 UNEMPLOYMENT INSURANCE 10,000 0 10,000 8,240.00 .00 1,760.00 82.4% TOTAL UNEMPLOYMENT INSURANCE 110,000 30,000 140,000 10,404.27 .00 129,595.73 7.4% 914 MEDICAL INSURANCE _________________________________________ 19141 MEDICAL INSURANCE 12,197,937 178,640 12,376,577 5,817,546.03 .00 6,559,031.11 47.0% TOTAL MEDICAL INSURANCE 12,197,937 178,640 12,376,577 5,817,546.03 .00 6,559,031.11 47.0% 919 OTHER EMPLOYEE BENEFITS _________________________________________ 19191 OTHER EMPLOYEE BENEFITS 1,566,159 0 1,566,159 851,276.95 .00 714,882.05 54.4% 01/13/2022 16:35 |CITY OF NORTHAMPTON, MA - LIVE |P 8 1281cnar |YTD FY2022 GENERAL FUND EXPENSES |glytdbud 2ND QUARTER FOR 2022 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 919 OTHER EMPLOYEE BENEFITS APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ TOTAL OTHER EMPLOYEE BENEFITS 1,566,159 0 1,566,159 851,276.95 .00 714,882.05 54.4% 920 CHERRY SHEET ASSESSMENTS _________________________________________ 19202 CHERRY SHEET ASSESSMENTS 3,551,319 44,876 3,596,195 1,802,006.00 .00 1,794,189.00 50.1% TOTAL CHERRY SHEET ASSESSMENTS 3,551,319 44,876 3,596,195 1,802,006.00 .00 1,794,189.00 50.1% 925 OTHER ASSESSMENTS _________________________________________ 19252 GOVERNMENTAL ASSESSMENTS 27,122 -27,122 0 .00 .00 .00 .0% TOTAL OTHER ASSESSMENTS 27,122 -27,122 0 .00 .00 .00 .0% 930 CAPITAL IMPROVEMENTS _________________________________________ 19303 CAPITAL IMPROVEMENTS 407,500 11,955,238 12,362,738 2,864,478.64 398,622.05 9,099,636.96 26.4% TOTAL CAPITAL IMPROVEMENTS 407,500 11,955,238 12,362,738 2,864,478.64 398,622.05 9,099,636.96 26.4% 943 RESERVE FOR PERSONNEL _________________________________________ 19491 RESERVE FOR PERSONNEL 100,000 0 100,000 73,209.24 .00 26,790.76 73.2% TOTAL RESERVE FOR PERSONNEL 100,000 0 100,000 73,209.24 .00 26,790.76 73.2% 945 GENERAL LIABILITY INS. _________________________________________ 19452 GENERAL LIABILITY INSURANCE 651,970 0 651,970 645,574.00 .00 6,396.00 99.0% TOTAL GENERAL LIABILITY INS. 651,970 0 651,970 645,574.00 .00 6,396.00 99.0% GRAND TOTAL 60,809,397 13,357,458 74,166,855 34,677,101.96 398,622.05 39,091,130.66 47.3% ** END OF REPORT - Generated by Charlene Nardi ** 01/13/2022 16:35 |CITY OF NORTHAMPTON, MA - LIVE |P 9 1281cnar |YTD FY2022 GENERAL FUND EXPENSES |glytdbud 2ND QUARTER REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Field # Total Page Break Sequence 1 3 Y N Sequence 2 9 Y N Sequence 3 0 N N Sequence 4 0 N N Report title: YTD FY2022 GENERAL FUND EXPENSES Includes accounts exceeding 0% of budget. Print totals only: Y Year/Period: 2022/ 6 Print Full or Short description: F Print MTD Version: N Print full GL account: N Format type: 1 Roll projects to object: N Double space: N Carry forward code: 1 Suppress zero bal accts: Y Include requisition amount: N Print Revenues-Version headings: N Print revenue as credit: Y Print revenue budgets as zero: N Include Fund Balance: N Print journal detail: N From Yr/Per: 2021/ 1 To Yr/Per: 2021/ 1 Include budget entries: Y Incl encumb/liq entries: Y Sort by JE # or PO #: J Detail format option: 1 Include additional JE comments: N Multiyear view: D Amounts/totals exceed 999 million dollars: N Find Criteria Field Name Field Value Fund 0100 FUNCTION <>3 DEPARTMENT DOE BUDGET CAT LOCATION CURR/GRANT GRADE Character Code Org Object Project Account type Expense 01/13/2022 16:35 |CITY OF NORTHAMPTON, MA - LIVE |P 10 1281cnar |YTD FY2022 GENERAL FUND EXPENSES |glytdbud 2ND QUARTER REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Account status Rollup Code