Loading...
GF Expenses.063023CITY OF NORTHAMPTON, MA - LIVE FY23 EXPENSES GENERAL FUND Report generated: 08/14/2023 11:35 User: 1281bgarcia Program ID: glytdbud Page 1 4TH QUARTER FOR 2023 13 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 111 CITY COUNCIL 11111 CITY COUNCIL-PS 146,042 4,472 150,514 150,507.08 .00 6.92 100.0% 11112 CITY COUNCIL-OM 63,600 0 63,600 59,384.04 .00 4,215.96 93.4% TOTAL CITY COUNCIL 209,642 4,472 214,114 209,891.12 .00 4,222.88 98.0% 121 MAYOR 11211 MAYOR-PS 418,228 8,519 426,747 421,536.01 .00 5,210.99 98.8% 11212 MAYOR-OM 16,442 0 16,442 16,442.00 .00 .00 100.0% TOTAL MAYOR 434,670 8,519 443,189 437,978.01 .00 5,210.99 98.8% 135 AUDITOR 11351 AUDITOR-PS 360,897 0 360,897 346,621.19 .00 14,275.81 96.0% 11352 AUDITOR-OM 15,280 0 15,280 3,287.54 .00 11,992.46 21.5% TOTAL AUDITOR 376,177 0 376,177 349,908.73 .00 26,268.27 93.0% 141 ASSESSOR 11411 ASSESSOR-PS 177,232 5,462 182,694 182,686.58 .00 7.42 100.0% 11412 ASSESSOR-OM 116,200 99,298 215,498 73,455.98 116,148.00 25,894.02 88.0% TOTAL ASSESSOR 293,432 104,760 398,192 256,142.56 116,148.00 25,901.44 93.5% 146 COLLECTOR 11461 COLLECTOR-PS 404,308 0 404,308 393,717.41 .00 10,590.59 97.4% 11462 COLLECTOR-OM 276,435 0 276,435 208,043.09 .00 68,391.91 75.3% TOTAL COLLECTOR 680,743 0 680,743 601,760.50 .00 78,982.50 88.4% 151 LEGAL SERVICES CITY OF NORTHAMPTON, MA - LIVE FY23 EXPENSES GENERAL FUND Report generated: 08/14/2023 11:35 User: 1281bgarcia Program ID: glytdbud Page 2 4TH QUARTER FOR 2023 13 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 264,240.16 8,605.00 2,154.84 99.2% TOTAL LEGAL SERVICES 275,000 0 275,000 264,240.16 8,605.00 2,154.84 99.2% 152 HUMAN RESOURCES 11521 HUMAN RESOURCES-PS 312,614 42,888 355,502 347,769.92 .00 7,732.08 97.8% 11522 HUMAN RESOURCES-OM 19,550 0 19,550 13,067.84 .00 6,482.16 66.8% TOTAL HUMAN RESOURCES 332,164 42,888 375,052 360,837.76 .00 14,214.24 96.2% 155 INFORMATION TECHNOLOGY 11551 INFORMATION TECHNOLOGY - PS 453,282 19,628 472,910 463,840.74 .00 9,069.26 98.1% 11552 INFORMATION TECHNOLOGY - OM 748,499 18,640 767,139 761,443.36 .00 5,695.64 99.3% TOTAL INFORMATION TECHNOLOGY 1,201,781 38,268 1,240,049 1,225,284.10 .00 14,764.90 98.8% 161 CITY CLERK 11611 CITY CLERK-PS 327,841 0 327,841 312,841.47 .00 14,999.53 95.4% 11612 CITY CLERK-OM 34,565 0 34,565 31,502.90 .00 3,062.10 91.1% TOTAL CITY CLERK 362,406 0 362,406 344,344.37 .00 18,061.63 95.0% 175 PLANNING & SUSTAINABILITY 11751 PLANNING & SUSTAINABILITY - P 406,167 0 406,167 359,156.47 .00 47,010.53 88.4% 11752 PLANNING & SUSTAINABILITY -OM 64,200 0 64,200 43,219.97 8,900.00 12,080.03 81.2% TOTAL PLANNING & SUSTAINABILITY 470,367 0 470,367 402,376.44 8,900.00 59,090.56 87.4% 192 CENTRAL SERVICES CITY OF NORTHAMPTON, MA - LIVE FY23 EXPENSES GENERAL FUND Report generated: 08/14/2023 11:35 User: 1281bgarcia Program ID: glytdbud Page 3 4TH QUARTER FOR 2023 13 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 717,028.45 .00 48,871.55 93.6% 11922 CENTRAL SERVICES-OM 1,106,145 3,050 1,109,195 1,004,508.05 100,444.62 4,242.33 99.6% TOTAL CENTRAL SERVICES 1,872,045 3,050 1,875,095 1,721,536.50 100,444.62 53,113.88 97.2% 210 POLICE 12101 POLICE-PS 5,677,286 270,061 5,947,347 5,756,362.50 .00 190,984.50 96.8% 12102 POLICE-OM 524,531 45,000 569,531 531,301.45 37,270.67 958.88 99.8% TOTAL POLICE 6,201,817 315,061 6,516,878 6,287,663.95 37,270.67 191,943.38 97.1% 211 PARKING ENFORCEMENT 12111 PARKING ENFORCEMENT-PS 163,729 -36,053 127,676 127,675.80 .00 .20 100.0% 12112 PARKING ENFORCEMENT-OM 12,200 -4,833 7,367 7,366.60 .00 .40 100.0% TOTAL PARKING ENFORCEMENT 175,929 -40,886 135,043 135,042.40 .00 .60 100.0% 212 PUBLIC SAFETY COMM CENTER 12121 PUBLIC SAFETY COMM CTR-PS 660,293 94,869 755,162 725,955.35 .00 29,206.65 96.1% 12122 PUBLIC SAFETY COMM CTR-OM 24,998 0 24,998 24,998.00 .00 .00 100.0% TOTAL PUBLIC SAFETY COMM CENTER 685,291 94,869 780,160 750,953.35 .00 29,206.65 96.3% 220 FIRE RESCUE DEPARTMENT 12201 FIRE RESCUE - PS 5,820,477 304,385 6,124,862 5,975,258.32 .00 149,603.68 97.6% 12202 FIRE RESCUE - OM 832,680 421,561 1,254,241 885,256.91 368,954.70 29.01 100.0% TOTAL FIRE RESCUE DEPARTMENT 6,653,157 725,946 7,379,103 6,860,515.23 368,954.70 149,632.69 98.0% 241 BUILDING INSPECTORS CITY OF NORTHAMPTON, MA - LIVE FY23 EXPENSES GENERAL FUND Report generated: 08/14/2023 11:35 User: 1281bgarcia Program ID: glytdbud Page 4 4TH QUARTER FOR 2023 13 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 241 BUILDING INSPECTORS APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 12411 BUILDING INSPECTORS-PS 495,671 23,497 519,168 511,005.62 .00 8,162.38 98.4% 12412 BUILDING INSPECTORS-OM 26,200 20,000 46,200 41,935.26 .00 4,264.74 90.8% TOTAL BUILDING INSPECTORS 521,871 43,497 565,368 552,940.88 .00 12,427.12 97.8% 421 DPW-ADMIN & ENGINEERING 14211 DPW ADMINISTRATION-PS 250,295 -33,000 217,295 211,218.90 .00 6,076.10 97.2% 14212 DPW ADMINISTRATION-OM 39,325 3,000 42,325 42,325.00 .00 .00 100.0% TOTAL DPW-ADMIN & ENGINEERING 289,620 -30,000 259,620 253,543.90 .00 6,076.10 97.7% 422 HIGHWAYS 14221 HIGHWAYS-PS 771,667 -85,641 686,026 675,840.98 .00 10,185.02 98.5% 14222 HIGHWAYS-OM 520,400 166,320 686,720 467,438.20 215,925.59 3,356.21 99.5% 14223 HIGHWAYS-CAP 510,000 657,677 1,167,677 345,560.56 792,378.15 29,738.33 97.5% TOTAL HIGHWAYS 1,802,067 738,356 2,540,423 1,488,839.74 1,008,303.74 43,279.56 98.3% 423 SNOW & ICE 14231 SNOW & ICE-PS 131,000 62,941 193,941 193,940.29 .00 .71 100.0% 14232 SNOW & ICE-OM 369,000 44,077 413,077 412,419.71 .00 657.29 99.8% TOTAL SNOW & ICE 500,000 107,018 607,018 606,360.00 .00 658.00 99.9% 481 PARKING 14811 PARKING-PS 271,269 2,705 273,974 273,973.50 .00 .00 100.0% 14812 PARKING-OM 262,398 -58,789 203,609 202,952.09 656.61 .30 100.0% 14813 PARKING-CAP 80,000 -373 79,627 79,626.38 .00 .62 100.0% TOTAL PARKING 613,667 -56,458 557,210 556,551.97 656.61 .92 100.0% 492 DPW FORESTRY, PARKS & REC CITY OF NORTHAMPTON, MA - LIVE FY23 EXPENSES GENERAL FUND Report generated: 08/14/2023 11:35 User: 1281bgarcia Program ID: glytdbud Page 5 4TH QUARTER FOR 2023 13 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 492 DPW FORESTRY, PARKS & REC APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 14921 DPW FORESTRY, PARKS & REC-PS 981,660 -189,277 792,383 785,185.90 .00 7,197.10 99.1% 14922 DPW FORESTRY, PARKS & REC-OM 311,200 -19,350 291,850 291,850.00 350.00 -350.00 100.1% 14923 DPW FORESTRY, PARKS & REC-CAP 199,999 361,675 561,674 153,556.79 408,116.72 .00 100.0% TOTAL DPW FORESTRY, PARKS & REC 1,492,859 153,048 1,645,907 1,230,592.69 408,466.72 6,847.10 99.6% 511 HEALTH DEPARTMENT 15111 HEALTH DEPARTMENT - PS 1,092,129 0 1,092,129 739,253.95 .00 352,875.05 67.7% 15112 HEALTH DEPARTMENT - OM 166,230 0 166,230 132,737.72 24,750.19 8,742.09 94.7% TOTAL HEALTH DEPARTMENT 1,258,359 0 1,258,359 871,991.67 24,750.19 361,617.14 71.3% 529 COMMUNITY CARE 15292 COMMUNITY CARE-OM 0 241,706 241,706 198,379.47 42,962.74 364.00 99.8% TOTAL COMMUNITY CARE 0 241,706 241,706 198,379.47 42,962.74 364.00 99.8% 541 SENIOR SERVICES 15411 SENIOR SERVICES -PS 352,340 1,874 354,214 327,783.29 .00 26,430.71 92.5% 15412 SENIOR SERVICES - OM 46,264 0 46,264 46,264.00 .00 .00 100.0% TOTAL SENIOR SERVICES 398,604 1,874 400,478 374,047.29 .00 26,430.71 93.4% 543 VETERANS' SERVICE 15431 VETERANS' SERVICE-PS 219,964 460 220,424 220,297.19 .00 126.81 99.9% 15432 VETERANS' SERVICE-OM 509,130 0 509,130 313,890.29 .00 195,239.71 61.7% TOTAL VETERANS' SERVICE 729,094 460 729,554 534,187.48 .00 195,366.52 73.2% 610 FORBES LIBRARY CITY OF NORTHAMPTON, MA - LIVE FY23 EXPENSES GENERAL FUND Report generated: 08/14/2023 11:35 User: 1281bgarcia Program ID: glytdbud Page 6 4TH QUARTER FOR 2023 13 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 610 FORBES LIBRARY APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 16101 FORBES LIBRARY-PS 1,267,095 0 1,267,095 1,267,095.00 .00 .00 100.0% 16102 FORBES LIBRARY-OM 210,629 0 210,629 210,628.98 .00 .02 100.0% TOTAL FORBES LIBRARY 1,477,724 0 1,477,724 1,477,723.98 .00 .02 100.0% 611 LILLY LIBRARY 16111 LILLY LIBRARY-PS 278,902 0 278,902 278,901.96 .00 .04 100.0% 16112 LILLY LIBRARY-OM 93,939 0 93,939 93,939.00 .00 .00 100.0% TOTAL LILLY LIBRARY 372,841 0 372,841 372,840.96 .00 .04 100.0% 630 PARKS & RECREATION DEPARTMENT 16301 PARKS & RECREATION - PS 332,793 27,274 360,067 360,067.00 .00 .00 100.0% 16302 PARKS & RECREATION-OM 27,500 0 27,500 27,500.00 .00 .00 100.0% TOTAL PARKS & RECREATION DEPARTMENT 360,293 27,274 387,567 387,567.00 .00 .00 100.0% 699 ARTS AND CULTURE 16991 ARTS & CULTURE-PS 69,453 1,725 71,178 71,178.00 .00 .00 100.0% 16992 ARTS & CULTURE-OM 21,250 0 21,250 20,750.00 .00 500.00 97.6% TOTAL ARTS AND CULTURE 90,703 1,725 92,428 91,928.00 .00 500.00 99.5% 710 MUNICIPAL INDEBTEDNESS 17103 MUNICIPAL DEBT SERVICE 3,451,201 0 3,451,201 3,451,201.00 .00 .00 100.0% TOTAL MUNICIPAL INDEBTEDNESS 3,451,201 0 3,451,201 3,451,201.00 .00 .00 100.0% 750 INTEREST ON DEBT CITY OF NORTHAMPTON, MA - LIVE FY23 EXPENSES GENERAL FUND Report generated: 08/14/2023 11:35 User: 1281bgarcia Program ID: glytdbud Page 7 4TH QUARTER FOR 2023 13 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 750 INTEREST ON DEBT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 17503 INTEREST ON MUNICIPAL DEBT 1,055,761 0 1,055,761 994,000.72 .00 61,760.28 94.2% TOTAL INTEREST ON DEBT 1,055,761 0 1,055,761 994,000.72 .00 61,760.28 94.2% 911 CONTRIBUTORY RETIREMENT 19111 CONTRIBUTORY RETIREMENT-PS 7,085,854 0 7,085,854 7,080,668.04 .00 5,185.96 99.9% 19112 CONTRIBUTORY RETIREMENT-OM 10,000 10,000 20,000 9,950.00 10,050.00 .00 100.0% TOTAL CONTRIBUTORY RETIREMENT 7,095,854 10,000 7,105,854 7,090,618.04 10,050.00 5,185.96 99.9% 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 30,749.18 148,000.00 19,906.93 90.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 38,989.18 148,000.00 21,666.93 89.6% 914 MEDICAL INSURANCE 19141 MEDICAL INSURANCE 12,619,303 20,306 12,639,609 11,685,593.93 151,824.63 802,190.58 93.7% 19142 MEDICAL INSURANCE 15,000 0 15,000 .00 .00 15,000.00 .0% TOTAL MEDICAL INSURANCE 12,634,303 20,306 12,654,609 11,685,593.93 151,824.63 817,190.58 93.5% 919 OTHER EMPLOYEE BENEFITS CITY OF NORTHAMPTON, MA - LIVE FY23 EXPENSES GENERAL FUND Report generated: 08/14/2023 11:35 User: 1281bgarcia Program ID: glytdbud Page 8 4TH QUARTER FOR 2023 13 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 919 OTHER EMPLOYEE BENEFITS APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 19191 OTHER EMPLOYEE BENEFITS 1,651,122 147,334 1,798,456 1,738,376.86 .00 60,079.14 96.7% TOTAL OTHER EMPLOYEE BENEFITS 1,651,122 147,334 1,798,456 1,738,376.86 .00 60,079.14 96.7% 920 CHERRY SHEET ASSESSMENTS 19202 CHERRY SHEET ASSESSMENTS 3,913,623 140,809 4,054,432 3,866,523.00 .00 187,909.00 95.4% TOTAL CHERRY SHEET ASSESSMENTS 3,913,623 140,809 4,054,432 3,866,523.00 .00 187,909.00 95.4% 930 CAPITAL IMPROVEMENTS 19303 CAPITAL IMPROVEMENTS 446,057 20,158,945 20,605,002 6,260,943.11 14,336,808.15 7,250.53 100.0% TOTAL CAPITAL IMPROVEMENTS 446,057 20,158,945 20,605,002 6,260,943.11 14,336,808.15 7,250.53 100.0% 943 RESERVE FOR PERSONNEL 19491 RESERVE FOR PERSONNEL 675,127 -218,885 456,242 444,788.38 .00 11,453.62 97.5% TOTAL RESERVE FOR PERSONNEL 675,127 -218,885 456,242 444,788.38 .00 11,453.62 97.5% 945 GENERAL LIABILITY INS. 19452 GENERAL LIABILITY INSURANCE 713,097 0 713,097 705,047.28 .00 8,049.72 98.9% TOTAL GENERAL LIABILITY INS. 713,097 0 713,097 705,047.28 .00 8,049.72 98.9% GRAND TOTAL 62,698,587 22,882,612 85,581,199 66,282,904.71 16,772,145.77 2,526,148.44 97.0% ** END OF REPORT - Generated by Barney Garcia **