Loading...
GF Expenses 10/26/2022 09:18 |CITY OF NORTHAMPTON, MA - LIVE |P 1 1281rcro |FY23 EXPENSES GENERAL FUND |glytdbud 1ST QUARTER FOR 2023 03 ORIGINAL TRANFRS/REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 111 CITY COUNCIL _________________________________________ 11111 CITY COUNCIL-PS 146,042 0 146,042 35,899.79 .00 110,142.21 24.6% 11112 CITY COUNCIL-OM 63,600 0 63,600 .00 .00 63,600.00 .0% TOTAL CITY COUNCIL 209,642 0 209,642 35,899.79 .00 173,742.21 17.1% 121 MAYOR _________________________________________ 11211 MAYOR-PS 418,228 0 418,228 99,170.61 .00 319,057.39 23.7% 11212 MAYOR-OM 16,442 0 16,442 6,510.20 .00 9,931.80 39.6% TOTAL MAYOR 434,670 0 434,670 105,680.81 .00 328,989.19 24.3% 135 AUDITOR _________________________________________ 11351 AUDITOR-PS 360,897 0 360,897 87,780.97 .00 273,116.03 24.3% 11352 AUDITOR-OM 15,280 0 15,280 235.00 .00 15,045.00 1.5% TOTAL AUDITOR 376,177 0 376,177 88,015.97 .00 288,161.03 23.4% 141 ASSESSOR _________________________________________ 11411 ASSESSOR-PS 177,232 0 177,232 41,264.25 .00 135,967.75 23.3% 11412 ASSESSOR-OM 116,200 99,298 215,498 62,656.21 .00 152,841.79 29.1% TOTAL ASSESSOR 293,432 99,298 392,730 103,920.46 .00 288,809.54 26.5% 146 COLLECTOR _________________________________________ 11461 COLLECTOR-PS 404,308 0 404,308 85,976.11 .00 318,331.89 21.3% 11462 COLLECTOR-OM 276,435 0 276,435 29,732.34 .00 246,702.66 10.8% TOTAL COLLECTOR 680,743 0 680,743 115,708.45 .00 565,034.55 17.0% 151 LEGAL SERVICES _________________________________________ 10/26/2022 09:18 |CITY OF NORTHAMPTON, MA - LIVE |P 2 1281rcro |FY23 EXPENSES GENERAL FUND |glytdbud 1ST QUARTER FOR 2023 03 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 19,448.05 .00 255,551.95 7.1% TOTAL LEGAL SERVICES 275,000 0 275,000 19,448.05 .00 255,551.95 7.1% 152 HUMAN RESOURCES _________________________________________ 11521 HUMAN RESOURCES-PS 312,614 0 312,614 85,898.57 .00 226,715.43 27.5% 11522 HUMAN RESOURCES-OM 19,550 0 19,550 1,810.00 .00 17,740.00 9.3% TOTAL HUMAN RESOURCES 332,164 0 332,164 87,708.57 .00 244,455.43 26.4% 155 INFORMATION TECHNOLOGY _________________________________________ 11551 INFORMATION TECHNOLOGY - PS 453,282 0 453,282 107,322.23 .00 345,959.77 23.7% 11552 INFORMATION TECHNOLOGY - OM 748,499 9,320 757,819 331,482.52 .00 426,336.48 43.7% TOTAL INFORMATION TECHNOLOGY 1,201,781 9,320 1,211,101 438,804.75 .00 772,296.25 36.2% 161 CITY CLERK _________________________________________ 11611 CITY CLERK-PS 327,841 0 327,841 86,379.33 .00 241,461.67 26.3% 11612 CITY CLERK-OM 34,565 0 34,565 7,870.28 .00 26,694.72 22.8% TOTAL CITY CLERK 362,406 0 362,406 94,249.61 .00 268,156.39 26.0% 175 PLANNING & SUSTAINABILITY _________________________________________ 11751 PLANNING & SUSTAINABILITY - P 406,167 0 406,167 78,276.38 .00 327,890.62 19.3% 11752 PLANNING & SUSTAINABILITY -OM 64,200 0 64,200 7,857.31 .00 56,342.69 12.2% TOTAL PLANNING & SUSTAINABILITY 470,367 0 470,367 86,133.69 .00 384,233.31 18.3% 192 CENTRAL SERVICES _________________________________________ 10/26/2022 09:18 |CITY OF NORTHAMPTON, MA - LIVE |P 3 1281rcro |FY23 EXPENSES GENERAL FUND |glytdbud 1ST QUARTER FOR 2023 03 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 192 CENTRAL SERVICES APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 11921 CENTRAL SERVICES-PS 765,900 0 765,900 153,153.79 .00 612,746.21 20.0% 11922 CENTRAL SERVICES-OM 1,106,145 3,050 1,109,195 238,894.19 .00 870,300.81 21.5% TOTAL CENTRAL SERVICES 1,872,045 3,050 1,875,095 392,047.98 .00 1,483,047.02 20.9% 210 POLICE _________________________________________ 12101 POLICE-PS 5,677,286 0 5,677,286 1,219,730.70 .00 4,457,555.30 21.5% 12102 POLICE-OM 524,531 45,000 569,531 122,485.26 .00 447,045.74 21.5% TOTAL POLICE 6,201,817 45,000 6,246,817 1,342,215.96 .00 4,904,601.04 21.5% 211 PARKING ENFORCEMENT _________________________________________ 12111 PARKING ENFORCEMENT-PS 163,729 0 163,729 27,124.51 .00 136,604.49 16.6% 12112 PARKING ENFORCEMENT-OM 12,200 0 12,200 1,036.66 .00 11,163.34 8.5% TOTAL PARKING ENFORCEMENT 175,929 0 175,929 28,161.17 .00 147,767.83 16.0% 212 PUBLIC SAFETY COMM CENTER _________________________________________ 12121 PUBLIC SAFETY COMM CTR-PS 660,293 0 660,293 208,451.05 .00 451,841.95 31.6% 12122 PUBLIC SAFETY COMM CTR-OM 24,998 0 24,998 6,811.01 .00 18,186.99 27.2% TOTAL PUBLIC SAFETY COMM CENTER 685,291 0 685,291 215,262.06 .00 470,028.94 31.4% 220 FIRE RESCUE DEPARTMENT _________________________________________ 12201 FIRE RESCUE - PS 5,820,477 0 5,820,477 1,274,105.07 .00 4,546,371.93 21.9% 12202 FIRE RESCUE - OM 832,680 421,561 1,254,241 453,672.18 .00 800,568.44 36.2% TOTAL FIRE RESCUE DEPARTMENT 6,653,157 421,561 7,074,718 1,727,777.25 .00 5,346,940.37 24.4% 241 BUILDING INSPECTORS _________________________________________ 10/26/2022 09:18 |CITY OF NORTHAMPTON, MA - LIVE |P 4 1281rcro |FY23 EXPENSES GENERAL FUND |glytdbud 1ST QUARTER FOR 2023 03 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 241 BUILDING INSPECTORS APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 12411 BUILDING INSPECTORS-PS 495,671 0 495,671 113,976.77 .00 381,694.23 23.0% 12412 BUILDING INSPECTORS-OM 26,200 0 26,200 8,732.82 .00 17,467.18 33.3% TOTAL BUILDING INSPECTORS 521,871 0 521,871 122,709.59 .00 399,161.41 23.5% 421 DPW-ADMIN & ENGINEERING _________________________________________ 14211 DPW ADMINISTRATION-PS 250,295 0 250,295 49,311.68 .00 200,983.32 19.7% 14212 DPW ADMINISTRATION-OM 39,325 0 39,325 7,802.02 .00 31,522.98 19.8% TOTAL DPW-ADMIN & ENGINEERING 289,620 0 289,620 57,113.70 .00 232,506.30 19.7% 422 HIGHWAYS _________________________________________ 14221 HIGHWAYS-PS 771,667 0 771,667 155,617.17 .00 616,049.83 20.2% 14222 HIGHWAYS-OM 520,400 166,320 686,720 112,915.15 .00 573,804.85 16.4% 14223 HIGHWAYS-CAP 510,000 657,677 1,167,677 108,544.33 .00 1,059,132.71 9.3% TOTAL HIGHWAYS 1,802,067 823,997 2,626,064 377,076.65 .00 2,248,987.39 14.4% 423 SNOW & ICE _________________________________________ 14231 SNOW & ICE-PS 131,000 0 131,000 32.00 .00 130,968.00 .0% 14232 SNOW & ICE-OM 369,000 0 369,000 464.00 .00 368,536.00 .1% TOTAL SNOW & ICE 500,000 0 500,000 496.00 .00 499,504.00 .1% 441 STORM DRAINS _________________________________________ 14411 STORM DRAINS-PS 0 0 0 325.00 .00 -325.00 100.0% TOTAL STORM DRAINS 0 0 0 325.00 .00 -325.00 100.0% 481 PARKING _________________________________________ 10/26/2022 09:18 |CITY OF NORTHAMPTON, MA - LIVE |P 5 1281rcro |FY23 EXPENSES GENERAL FUND |glytdbud 1ST QUARTER FOR 2023 03 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 481 PARKING APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 14811 PARKING-PS 271,269 0 271,269 65,629.50 .00 205,639.50 24.2% 14812 PARKING-OM 262,398 0 262,398 60,406.29 .00 201,991.71 23.0% 14813 PARKING-CAP 80,000 0 80,000 7,269.42 .00 72,730.58 9.1% TOTAL PARKING 613,667 0 613,667 133,305.21 .00 480,361.79 21.7% 492 DPW FORESTRY, PARKS & REC _________________________________________ 14921 DPW FORESTRY, PARKS & REC-PS 981,660 0 981,660 183,051.09 .00 798,608.91 18.6% 14922 DPW FORESTRY, PARKS & REC-OM 311,200 0 311,200 66,757.83 .00 244,442.17 21.5% 14923 DPW FORESTRY, PARKS & REC-CAP 199,999 144,425 344,424 72,119.87 .00 272,303.64 20.9% TOTAL DPW FORESTRY, PARKS & REC 1,492,859 144,425 1,637,284 321,928.79 .00 1,315,354.72 19.7% 511 HEALTH DEPARTMENT _________________________________________ 15111 HEALTH DEPARTMENT - PS 1,092,129 0 1,092,129 153,881.47 .00 938,247.53 14.1% 15112 HEALTH DEPARTMENT - OM 166,230 0 166,230 23,810.34 .00 142,419.66 14.3% TOTAL HEALTH DEPARTMENT 1,258,359 0 1,258,359 177,691.81 .00 1,080,667.19 14.1% 529 COMMUNITY CARE _________________________________________ 15292 COMMUNITY CARE-OM 0 241,706 241,706 35,729.22 .00 205,976.99 14.8% TOTAL COMMUNITY CARE 0 241,706 241,706 35,729.22 .00 205,976.99 14.8% 541 SENIOR SERVICES _________________________________________ 15411 SENIOR SERVICES -PS 352,340 0 352,340 77,559.64 .00 274,780.36 22.0% 15412 SENIOR SERVICES - OM 46,264 0 46,264 9,086.11 .00 37,177.89 19.6% TOTAL SENIOR SERVICES 398,604 0 398,604 86,645.75 .00 311,958.25 21.7% 543 VETERANS' SERVICE _________________________________________ 10/26/2022 09:18 |CITY OF NORTHAMPTON, MA - LIVE |P 6 1281rcro |FY23 EXPENSES GENERAL FUND |glytdbud 1ST QUARTER FOR 2023 03 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 543 VETERANS' SERVICE APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 15431 VETERANS' SERVICE-PS 219,964 0 219,964 48,476.99 .00 171,487.01 22.0% 15432 VETERANS' SERVICE-OM 509,130 0 509,130 80,328.18 .00 428,801.82 15.8% TOTAL VETERANS' SERVICE 729,094 0 729,094 128,805.17 .00 600,288.83 17.7% 610 FORBES LIBRARY _________________________________________ 16101 FORBES LIBRARY-PS 1,267,095 0 1,267,095 422,365.00 .00 844,730.00 33.3% 16102 FORBES LIBRARY-OM 210,629 0 210,629 101,325.30 .00 109,303.70 48.1% TOTAL FORBES LIBRARY 1,477,724 0 1,477,724 523,690.30 .00 954,033.70 35.4% 611 LILLY LIBRARY _________________________________________ 16111 LILLY LIBRARY-PS 278,902 0 278,902 92,967.32 .00 185,934.68 33.3% 16112 LILLY LIBRARY-OM 93,939 0 93,939 31,313.00 .00 62,626.00 33.3% TOTAL LILLY LIBRARY 372,841 0 372,841 124,280.32 .00 248,560.68 33.3% 630 PARKS & RECREATION DEPARTMENT _________________________________________ 16301 PARKS & RECREATION - PS 332,793 0 332,793 108,934.37 .00 223,858.63 32.7% 16302 PARKS & RECREATION-OM 27,500 0 27,500 5,995.20 .00 21,504.80 21.8% TOTAL PARKS & RECREATION DEPARTMENT 360,293 0 360,293 114,929.57 .00 245,363.43 31.9% 699 ARTS AND CULTURE _________________________________________ 16991 ARTS & CULTURE-PS 69,453 0 69,453 17,095.62 .00 52,357.38 24.6% 16992 ARTS & CULTURE-OM 21,250 0 21,250 10,750.00 .00 10,500.00 50.6% TOTAL ARTS AND CULTURE 90,703 0 90,703 27,845.62 .00 62,857.38 30.7% 710 MUNICIPAL INDEBTEDNESS _________________________________________ 10/26/2022 09:18 |CITY OF NORTHAMPTON, MA - LIVE |P 7 1281rcro |FY23 EXPENSES GENERAL FUND |glytdbud 1ST QUARTER FOR 2023 03 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 710 MUNICIPAL INDEBTEDNESS APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 17103 MUNICIPAL DEBT SERVICE 3,451,201 0 3,451,201 314,200.00 .00 3,137,001.00 9.1% TOTAL MUNICIPAL INDEBTEDNESS 3,451,201 0 3,451,201 314,200.00 .00 3,137,001.00 9.1% 750 INTEREST ON DEBT _________________________________________ 17503 INTEREST ON MUNICIPAL DEBT 1,055,761 0 1,055,761 30,145.00 .00 1,025,616.00 2.9% TOTAL INTEREST ON DEBT 1,055,761 0 1,055,761 30,145.00 .00 1,025,616.00 2.9% 911 CONTRIBUTORY RETIREMENT _________________________________________ 19111 CONTRIBUTORY RETIREMENT-PS 7,085,854 0 7,085,854 7,065,742.50 .00 20,111.50 99.7% 19112 CONTRIBUTORY RETIREMENT-OM 10,000 10,000 20,000 9,950.00 .00 10,050.00 49.8% TOTAL CONTRIBUTORY RETIREMENT 7,095,854 10,000 7,105,854 7,075,692.50 .00 30,161.50 99.6% 912 WORKERS' COMP INSURANCE _________________________________________ 19121 WORKERS' COMP INSURANCE 558,571 0 558,571 545,582.00 .00 12,989.00 97.7% 19122 WORKERS' COMP INSURANCE 261,548 0 261,548 255,271.00 .00 6,277.00 97.6% TOTAL WORKERS' COMP INSURANCE 820,119 0 820,119 800,853.00 .00 19,266.00 97.7% 913 UNEMPLOYMENT INSURANCE _________________________________________ 19131 UNEMPLOYMENT INSURANCE 100,000 98,656 198,656 .00 .00 198,656.11 .0% 19132 UNEMPLOYMENT INSURANCE 10,000 0 10,000 8,240.00 .00 1,760.00 82.4% TOTAL UNEMPLOYMENT INSURANCE 110,000 98,656 208,656 8,240.00 .00 200,416.11 3.9% 914 MEDICAL INSURANCE _________________________________________ 19141 MEDICAL INSURANCE 12,619,303 167,740 12,787,043 2,982,421.75 .00 9,804,621.39 23.3% 10/26/2022 09:18 |CITY OF NORTHAMPTON, MA - LIVE |P 8 1281rcro |FY23 EXPENSES GENERAL FUND |glytdbud 1ST QUARTER FOR 2023 03 ORIGINAL TRANFRS/REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 19142 MEDICAL INSURANCE 15,000 0 15,000 .00 .00 15,000.00 .0% TOTAL MEDICAL INSURANCE 12,634,303 167,740 12,802,043 2,982,421.75 .00 9,819,621.39 23.3% 919 OTHER EMPLOYEE BENEFITS _________________________________________ 19191 OTHER EMPLOYEE BENEFITS 1,651,122 0 1,651,122 367,505.97 .00 1,283,616.03 22.3% TOTAL OTHER EMPLOYEE BENEFITS 1,651,122 0 1,651,122 367,505.97 .00 1,283,616.03 22.3% 920 CHERRY SHEET ASSESSMENTS _________________________________________ 19202 CHERRY SHEET ASSESSMENTS 3,913,623 0 3,913,623 1,009,359.00 .00 2,904,264.00 25.8% TOTAL CHERRY SHEET ASSESSMENTS 3,913,623 0 3,913,623 1,009,359.00 .00 2,904,264.00 25.8% 930 CAPITAL IMPROVEMENTS _________________________________________ 19303 CAPITAL IMPROVEMENTS 446,057 10,684,343 11,130,400 694,668.48 307,632.89 10,128,098.60 9.0% TOTAL CAPITAL IMPROVEMENTS 446,057 10,684,343 11,130,400 694,668.48 307,632.89 10,128,098.60 9.0% 943 RESERVE FOR PERSONNEL _________________________________________ 19491 RESERVE FOR PERSONNEL 675,127 0 675,127 26,350.10 .00 648,776.90 3.9% TOTAL RESERVE FOR PERSONNEL 675,127 0 675,127 26,350.10 .00 648,776.90 3.9% 945 GENERAL LIABILITY INS. _________________________________________ 19452 GENERAL LIABILITY INSURANCE 713,097 0 713,097 691,190.00 .00 21,907.00 96.9% TOTAL GENERAL LIABILITY INS. 713,097 0 713,097 691,190.00 .00 21,907.00 96.9% GRAND TOTAL 62,698,587 12,749,096 75,447,683 21,114,233.07 307,632.89 54,025,816.64 28.4% ** END OF REPORT - Generated by Ryan Crowther ** 10/26/2022 09:18 |CITY OF NORTHAMPTON, MA - LIVE |P 9 1281rcro |FY23 EXPENSES GENERAL FUND |glytdbud 1ST 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: FY23 EXPENSES GENERAL FUND Includes accounts exceeding 0% of budget. Print totals only: Y Year/Period: 2023/ 3 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: 2023/ 1 To Yr/Per: 2023/ 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 10/26/2022 09:18 |CITY OF NORTHAMPTON, MA - LIVE |P 10 1281rcro |FY23 EXPENSES GENERAL FUND |glytdbud 1ST QUARTER REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Account status Rollup Code