Loading...
GF Expenses.033124CITY OF NORTHAMPTON, MA - LIVE FY24 GENERAL FUND EXPENSES Report generated: 04/08/2024 14:24 User: 1281cnar Program ID: glytdbud Page 1 3RD QUARTER FOR 2024 09 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 111 CITY COUNCIL 11111 CITY COUNCIL-PS 149,660 36,807 186,467 130,211.86 .00 56,254.94 69.8% 11112 CITY COUNCIL-OM 63,900 0 63,900 56,361.71 .00 7,538.29 88.2% TOTAL CITY COUNCIL 213,560 36,807 250,367 186,573.57 .00 63,793.23 74.5% 121 MAYOR 11211 MAYOR-PS 438,985 48,750 487,735 318,960.18 .00 168,774.82 65.4% 11212 MAYOR-OM 16,942 0 16,942 10,561.03 .00 6,380.97 62.3% TOTAL MAYOR 455,927 48,750 504,677 329,521.21 .00 175,155.79 65.3% 135 AUDITOR 11351 AUDITOR-PS 333,402 0 333,402 253,503.12 .00 79,898.88 76.0% 11352 AUDITOR-OM 15,282 0 15,282 4,086.93 .00 11,195.07 26.7% TOTAL AUDITOR 348,684 0 348,684 257,590.05 .00 91,093.95 73.9% 141 ASSESSOR 11411 ASSESSOR-PS 190,498 0 190,498 139,452.39 .00 51,045.61 73.2% 11412 ASSESSOR-OM 32,700 0 32,700 11,095.80 .00 21,604.20 33.9% 11413 ASSESSORS - CAPITAL 95,000 116,148 211,148 68,510.00 .00 142,638.00 32.4% TOTAL ASSESSOR 318,198 116,148 434,346 219,058.19 .00 215,287.81 50.4% 146 COLLECTOR 11461 COLLECTOR-PS 430,809 0 430,809 301,548.32 .00 129,260.68 70.0% 11462 COLLECTOR-OM 266,435 0 266,435 163,580.59 .00 102,854.41 61.4% TOTAL COLLECTOR 697,244 0 697,244 465,128.91 .00 232,115.09 66.7% CITY OF NORTHAMPTON, MA - LIVE FY24 GENERAL FUND EXPENSES Report generated: 04/08/2024 14:24 User: 1281cnar Program ID: glytdbud Page 2 3RD QUARTER FOR 2024 09 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 151 LEGAL SERVICES APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 151 LEGAL SERVICES 11512 LEGAL SERVICES-OM 275,000 8,605 283,605 110,268.90 .00 173,336.10 38.9% TOTAL LEGAL SERVICES 275,000 8,605 283,605 110,268.90 .00 173,336.10 38.9% 152 HUMAN RESOURCES 11521 HUMAN RESOURCES-PS 318,830 0 318,830 229,597.16 .00 89,232.84 72.0% 11522 HUMAN RESOURCES-OM 21,550 0 21,550 3,557.56 .00 17,992.44 16.5% TOTAL HUMAN RESOURCES 340,380 0 340,380 233,154.72 .00 107,225.28 68.5% 155 INFORMATION TECHNOLOGY 11551 INFORMATION TECHNOLOGY - PS 519,460 0 519,460 252,894.45 .00 266,565.55 48.7% 11552 INFORMATION TECHNOLOGY - OM 846,050 0 846,050 784,286.81 .00 61,763.19 92.7% TOTAL INFORMATION TECHNOLOGY 1,365,510 0 1,365,510 1,037,181.26 .00 328,328.74 76.0% 161 CITY CLERK 11611 CITY CLERK-PS 335,095 0 335,095 251,569.68 .00 83,525.32 75.1% 11612 CITY CLERK-OM 34,565 0 34,565 31,720.34 .00 2,844.66 91.8% TOTAL CITY CLERK 369,660 0 369,660 283,290.02 .00 86,369.98 76.6% 175 PLANNING & SUSTAINABILITY 11751 PLANNING & SUSTAINABILITY - P 404,632 0 404,632 283,432.44 .00 121,199.56 70.0% 11752 PLANNING & SUSTAINABILITY -OM 65,735 8,900 74,635 22,978.04 .00 51,656.96 30.8% TOTAL PLANNING & SUSTAINABILITY 470,367 8,900 479,267 306,410.48 .00 172,856.52 63.9% 182 CLIMATE ACTION/PROJECT ADMIN CITY OF NORTHAMPTON, MA - LIVE FY24 GENERAL FUND EXPENSES Report generated: 04/08/2024 14:24 User: 1281cnar Program ID: glytdbud Page 3 3RD QUARTER FOR 2024 09 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 182 CLIMATE ACTION/PROJECT ADMIN APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 11821 CLIMATE ACTION/PROJECT ADMIN 230,506 0 230,506 126,546.92 .00 103,959.08 54.9% 11822 CLIMATE ACTION/PROJECT ADMIN 15,150 0 15,150 1,769.31 .00 13,380.69 11.7% TOTAL CLIMATE ACTION/PROJECT ADMIN 245,656 0 245,656 128,316.23 .00 117,339.77 52.2% 192 CENTRAL SERVICES 11921 CENTRAL SERVICES-PS 809,493 0 809,493 577,334.37 .00 232,158.63 71.3% 11922 CENTRAL SERVICES-OM 1,140,289 100,445 1,240,734 920,820.40 .00 319,913.22 74.2% TOTAL CENTRAL SERVICES 1,949,782 100,445 2,050,227 1,498,154.77 .00 552,071.85 73.1% 210 POLICE 12101 POLICE-PS 6,295,758 0 6,295,758 4,243,237.34 .00 2,052,520.66 67.4% 12102 POLICE-OM 539,531 37,271 576,802 347,559.80 .00 229,241.87 60.3% TOTAL POLICE 6,835,289 37,271 6,872,560 4,590,797.14 .00 2,281,762.53 66.8% 211 PARKING ENFORCEMENT 12111 PARKING ENFORCEMENT-PS 194,582 0 194,582 132,151.61 .00 62,430.39 67.9% 12112 PARKING ENFORCEMENT-OM 12,200 0 12,200 2,242.86 .00 9,957.14 18.4% TOTAL PARKING ENFORCEMENT 206,782 0 206,782 134,394.47 .00 72,387.53 65.0% 212 PUBLIC SAFETY COMM CENTER 12121 PUBLIC SAFETY COMM CTR-PS 706,210 0 706,210 442,018.51 .00 264,191.49 62.6% 12122 PUBLIC SAFETY COMM CTR-OM 18,223 0 18,223 14,103.29 .00 4,119.71 77.4% TOTAL PUBLIC SAFETY COMM CENTER 724,433 0 724,433 456,121.80 .00 268,311.20 63.0% 220 FIRE RESCUE DEPARTMENT CITY OF NORTHAMPTON, MA - LIVE FY24 GENERAL FUND EXPENSES Report generated: 04/08/2024 14:24 User: 1281cnar Program ID: glytdbud Page 4 3RD QUARTER FOR 2024 09 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 220 FIRE RESCUE DEPARTMENT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 12201 FIRE RESCUE - PS 6,587,559 0 6,587,559 4,641,513.51 .00 1,946,045.49 70.5% 12202 FIRE RESCUE - OM 690,330 368,955 1,059,285 790,444.79 .00 268,839.91 74.6% TOTAL FIRE RESCUE DEPARTMENT 7,277,889 368,955 7,646,844 5,431,958.30 .00 2,214,885.40 71.0% 241 BUILDING INSPECTORS 12411 BUILDING INSPECTORS-PS 534,380 0 534,380 383,990.69 .00 150,389.31 71.9% 12412 BUILDING INSPECTORS-OM 20,400 0 20,400 12,366.56 .00 8,033.44 60.6% TOTAL BUILDING INSPECTORS 554,780 0 554,780 396,357.25 .00 158,422.75 71.4% 421 DPW-ADMIN & ENGINEERING 14211 DPW ADMINISTRATION-PS 263,935 0 263,935 160,629.23 .00 103,305.77 60.9% 14212 DPW ADMINISTRATION-OM 39,325 0 39,325 27,519.57 .00 11,805.43 70.0% TOTAL DPW-ADMIN & ENGINEERING 303,260 0 303,260 188,148.80 .00 115,111.20 62.0% 422 HIGHWAYS 14221 HIGHWAYS-PS 886,650 0 886,650 522,528.78 .00 364,121.22 58.9% 14222 HIGHWAYS-OM 448,150 215,926 664,076 257,367.78 .00 406,707.81 38.8% 14223 HIGHWAYS-CAP 595,000 792,378 1,387,378 217,394.56 .00 1,169,983.59 15.7% TOTAL HIGHWAYS 1,929,800 1,008,304 2,938,104 997,291.12 .00 1,940,812.62 33.9% 423 SNOW & ICE 14231 SNOW & ICE-PS 131,000 0 131,000 114,423.02 .00 16,576.98 87.3% 14232 SNOW & ICE-OM 369,000 0 369,000 178,529.99 .00 190,470.01 48.4% TOTAL SNOW & ICE 500,000 0 500,000 292,953.01 .00 207,046.99 58.6% 481 PARKING CITY OF NORTHAMPTON, MA - LIVE FY24 GENERAL FUND EXPENSES Report generated: 04/08/2024 14:24 User: 1281cnar Program ID: glytdbud Page 5 3RD QUARTER FOR 2024 09 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 481 PARKING APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 14811 PARKING-PS 287,180 0 287,180 195,759.40 .00 91,420.60 68.2% 14812 PARKING-OM 268,576 657 269,233 138,539.96 .00 130,692.65 51.5% 14813 PARKING-CAP 80,000 0 80,000 55,250.70 .00 24,749.30 69.1% TOTAL PARKING 635,756 657 636,413 389,550.06 .00 246,862.55 61.2% 492 DPW FORESTRY, PARKS & REC 14921 DPW FORESTRY, PARKS & REC-PS 1,041,233 0 1,041,233 557,077.56 .00 484,155.44 53.5% 14922 DPW FORESTRY, PARKS & REC-OM 319,900 350 320,250 177,636.56 .00 142,613.44 55.5% 14923 DPW FORESTRY, PARKS & REC-CAP 190,000 408,117 598,117 179,428.08 .00 418,688.64 30.0% TOTAL DPW FORESTRY, PARKS & REC 1,551,133 408,467 1,959,600 914,142.20 .00 1,045,457.52 46.6% 511 HEALTH DEPARTMENT 15111 HEALTH DEPARTMENT - PS 1,066,956 0 1,066,956 746,487.46 .00 320,468.54 70.0% 15112 HEALTH DEPARTMENT - OM 206,230 24,750 230,980 156,716.73 .00 74,263.46 67.8% TOTAL HEALTH DEPARTMENT 1,273,186 24,750 1,297,936 903,204.19 .00 394,732.00 69.6% 529 COMMUNITY CARE 15292 COMMUNITY CARE-OM 0 42,963 42,963 35,496.00 .00 7,466.74 82.6% TOTAL COMMUNITY CARE 0 42,963 42,963 35,496.00 .00 7,466.74 82.6% 541 SENIOR SERVICES 15411 SENIOR SERVICES -PS 380,046 0 380,046 327,080.96 .00 52,965.04 86.1% 15412 SENIOR SERVICES - OM 63,437 0 63,437 40,230.91 .00 23,206.09 63.4% TOTAL SENIOR SERVICES 443,483 0 443,483 367,311.87 .00 76,171.13 82.8% 543 VETERANS' SERVICE CITY OF NORTHAMPTON, MA - LIVE FY24 GENERAL FUND EXPENSES Report generated: 04/08/2024 14:24 User: 1281cnar Program ID: glytdbud Page 6 3RD QUARTER FOR 2024 09 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 543 VETERANS' SERVICE APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 15431 VETERANS' SERVICE-PS 232,442 0 232,442 171,543.51 .00 60,898.49 73.8% 15432 VETERANS' SERVICE-OM 467,185 0 467,185 271,819.08 .00 195,365.92 58.2% TOTAL VETERANS' SERVICE 699,627 0 699,627 443,362.59 .00 256,264.41 63.4% 610 FORBES LIBRARY 16101 FORBES LIBRARY-PS 1,314,310 0 1,314,310 985,732.47 .00 328,577.53 75.0% 16102 FORBES LIBRARY-OM 215,132 0 215,132 171,015.34 .00 44,116.66 79.5% TOTAL FORBES LIBRARY 1,529,442 0 1,529,442 1,156,747.81 .00 372,694.19 75.6% 611 LILLY LIBRARY 16111 LILLY LIBRARY-PS 285,572 0 285,572 214,179.03 .00 71,392.97 75.0% 16112 LILLY LIBRARY-OM 100,317 0 100,317 75,237.75 .00 25,079.25 75.0% TOTAL LILLY LIBRARY 385,889 0 385,889 289,416.78 .00 96,472.22 75.0% 630 PARKS & RECREATION DEPARTMENT 16301 PARKS & RECREATION - PS 352,283 0 352,283 308,170.63 .00 44,112.37 87.5% 16302 PARKS & RECREATION-OM 29,500 0 29,500 16,932.36 .00 12,567.64 57.4% TOTAL PARKS & RECREATION DEPARTMENT 381,783 0 381,783 325,102.99 .00 56,680.01 85.2% 699 ARTS AND CULTURE 16991 ARTS & CULTURE-PS 74,468 0 74,468 55,069.03 .00 19,398.97 73.9% 16992 ARTS & CULTURE-OM 23,000 0 23,000 23,000.00 .00 .00 100.0% TOTAL ARTS AND CULTURE 97,468 0 97,468 78,069.03 .00 19,398.97 80.1% 710 MUNICIPAL INDEBTEDNESS CITY OF NORTHAMPTON, MA - LIVE FY24 GENERAL FUND EXPENSES Report generated: 04/08/2024 14:24 User: 1281cnar Program ID: glytdbud Page 7 3RD QUARTER FOR 2024 09 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 710 MUNICIPAL INDEBTEDNESS APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 17103 MUNICIPAL DEBT SERVICE 3,774,900 0 3,774,900 2,184,900.00 .00 1,590,000.00 57.9% TOTAL MUNICIPAL INDEBTEDNESS 3,774,900 0 3,774,900 2,184,900.00 .00 1,590,000.00 57.9% 750 INTEREST ON DEBT 17503 INTEREST ON MUNICIPAL DEBT 1,169,874 0 1,169,874 751,713.31 .00 418,160.69 64.3% TOTAL INTEREST ON DEBT 1,169,874 0 1,169,874 751,713.31 .00 418,160.69 64.3% 911 CONTRIBUTORY RETIREMENT 19111 CONTRIBUTORY RETIREMENT-PS 7,505,027 0 7,505,027 7,495,180.03 .00 9,846.97 99.9% 19112 CONTRIBUTORY RETIREMENT-OM 10,000 10,050 20,050 .00 .00 20,050.00 .0% TOTAL CONTRIBUTORY RETIREMENT 7,515,027 10,050 7,525,077 7,495,180.03 .00 29,896.97 99.6% 912 WORKERS' COMP INSURANCE 19121 WORKERS' COMP INSURANCE 495,220 72,949 568,169 568,169.00 .00 .00 100.0% 19122 WORKERS' COMP INSURANCE 274,625 0 274,625 265,360.00 .00 9,265.00 96.6% TOTAL WORKERS' COMP INSURANCE 769,845 72,949 842,794 833,529.00 .00 9,265.00 98.9% 913 UNEMPLOYMENT INSURANCE 19131 UNEMPLOYMENT INSURANCE 100,000 148,000 248,000 5,840.05 .00 242,159.95 2.4% 19132 UNEMPLOYMENT INSURANCE 10,000 0 10,000 8,240.00 .00 1,760.00 82.4% TOTAL UNEMPLOYMENT INSURANCE 110,000 148,000 258,000 14,080.05 .00 243,919.95 5.5% 914 MEDICAL INSURANCE 19141 MEDICAL INSURANCE 13,185,387 151,825 13,337,212 9,885,483.44 .00 3,451,728.19 74.1% CITY OF NORTHAMPTON, MA - LIVE FY24 GENERAL FUND EXPENSES Report generated: 04/08/2024 14:24 User: 1281cnar Program ID: glytdbud Page 8 3RD QUARTER FOR 2024 09 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 13,200,387 151,825 13,352,212 9,885,483.44 .00 3,466,728.19 74.0% 919 OTHER EMPLOYEE BENEFITS 19191 OTHER EMPLOYEE BENEFITS 1,683,860 0 1,683,860 1,362,639.50 .00 321,220.50 80.9% TOTAL OTHER EMPLOYEE BENEFITS 1,683,860 0 1,683,860 1,362,639.50 .00 321,220.50 80.9% 920 CHERRY SHEET ASSESSMENTS 19202 CHERRY SHEET ASSESSMENTS 4,129,833 75,851 4,205,684 3,108,632.00 .00 1,097,052.00 73.9% TOTAL CHERRY SHEET ASSESSMENTS 4,129,833 75,851 4,205,684 3,108,632.00 .00 1,097,052.00 73.9% 930 CAPITAL IMPROVEMENTS 19303 CAPITAL IMPROVEMENTS 200,000 15,435,412 15,635,412 4,764,605.42 211,967.81 10,658,838.29 31.8% TOTAL CAPITAL IMPROVEMENTS 200,000 15,435,412 15,635,412 4,764,605.42 211,967.81 10,658,838.29 31.8% 943 RESERVE FOR PERSONNEL 19491 RESERVE FOR PERSONNEL 100,000 0 100,000 64,506.94 .00 35,493.06 64.5% TOTAL RESERVE FOR PERSONNEL 100,000 0 100,000 64,506.94 .00 35,493.06 64.5% 945 GENERAL LIABILITY INS. 19452 GENERAL LIABILITY INSURANCE 851,829 -72,949 778,880 775,164.00 .00 3,716.00 99.5% TOTAL GENERAL LIABILITY INS. 851,829 -72,949 778,880 775,164.00 .00 3,716.00 99.5% GRAND TOTAL 65,885,523 18,032,157 83,917,680 53,685,507.41 211,967.81 30,020,204.72 64.2% ** END OF REPORT - Generated by Charlene Nardi ** CITY OF NORTHAMPTON, MA - LIVE FY24 GENERAL FUND EXPENSES Report generated: 04/08/2024 14:24 User: 1281cnar Program ID: glytdbud Page 9 3RD 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: FY24 GENERAL FUND EXPENSES Includes accounts exceeding 0% of budget. Print totals only: Y Year/Period: 2024/ 9 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 CITY OF NORTHAMPTON, MA - LIVE FY24 GENERAL FUND EXPENSES Report generated: 04/08/2024 14:24 User: 1281cnar Program ID: glytdbud Page 10 3RD QUARTER REPORT OPTIONS Account status Rollup Code