Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GF Expenses.123023
CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND EXPENSE Report generated: 01/23/2024 10:05 User: 1281cnar Program ID: glytdbud Page 1 2ND QUARTER FOR 2024 06 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 111 CITY COUNCIL 11111 CITY COUNCIL-PS 149,660 73,614 223,274 72,472.94 .00 150,800.66 32.5% 11112 CITY COUNCIL-OM 63,900 0 63,900 .00 .00 63,900.00 .0% TOTAL CITY COUNCIL 213,560 73,614 287,174 72,472.94 .00 214,700.66 25.2% 121 MAYOR 11211 MAYOR-PS 438,985 67,500 506,485 194,401.55 .00 312,083.45 38.4% 11212 MAYOR-OM 16,942 0 16,942 7,030.60 .00 9,911.40 41.5% TOTAL MAYOR 455,927 67,500 523,427 201,432.15 .00 321,994.85 38.5% 135 AUDITOR 11351 AUDITOR-PS 333,402 0 333,402 172,246.64 .00 161,155.36 51.7% 11352 AUDITOR-OM 15,282 0 15,282 2,369.21 .00 12,912.79 15.5% TOTAL AUDITOR 348,684 0 348,684 174,615.85 .00 174,068.15 50.1% 141 ASSESSOR 11411 ASSESSOR-PS 190,498 0 190,498 88,406.77 .00 102,091.23 46.4% 11412 ASSESSOR-OM 32,700 0 32,700 6,501.42 .00 26,198.58 19.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 163,418.19 .00 270,927.81 37.6% 146 COLLECTOR 11461 COLLECTOR-PS 430,809 0 430,809 192,799.81 .00 238,009.19 44.8% 11462 COLLECTOR-OM 266,435 0 266,435 100,485.53 .00 165,949.47 37.7% TOTAL COLLECTOR 697,244 0 697,244 293,285.34 .00 403,958.66 42.1% CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND EXPENSE Report generated: 01/23/2024 10:05 User: 1281cnar Program ID: glytdbud Page 2 2ND QUARTER FOR 2024 06 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 58,820.55 .00 224,784.45 20.7% TOTAL LEGAL SERVICES 275,000 8,605 283,605 58,820.55 .00 224,784.45 20.7% 152 HUMAN RESOURCES 11521 HUMAN RESOURCES-PS 318,830 0 318,830 152,150.20 .00 166,679.80 47.7% 11522 HUMAN RESOURCES-OM 21,550 0 21,550 2,712.59 .00 18,837.41 12.6% TOTAL HUMAN RESOURCES 340,380 0 340,380 154,862.79 .00 185,517.21 45.5% 155 INFORMATION TECHNOLOGY 11551 INFORMATION TECHNOLOGY - PS 519,460 0 519,460 159,674.38 .00 359,785.62 30.7% 11552 INFORMATION TECHNOLOGY - OM 846,050 -79,680 766,370 526,990.24 .00 239,380.00 68.8% TOTAL INFORMATION TECHNOLOGY 1,365,510 -79,680 1,285,830 686,664.62 .00 599,165.62 53.4% 161 CITY CLERK 11611 CITY CLERK-PS 335,095 0 335,095 145,369.74 .00 189,725.26 43.4% 11612 CITY CLERK-OM 34,565 0 34,565 17,821.95 .00 16,743.05 51.6% TOTAL CITY CLERK 369,660 0 369,660 163,191.69 .00 206,468.31 44.1% 175 PLANNING & SUSTAINABILITY 11751 PLANNING & SUSTAINABILITY - P 404,632 0 404,632 178,581.79 .00 226,050.21 44.1% 11752 PLANNING & SUSTAINABILITY -OM 65,735 8,900 74,635 17,493.74 .00 57,141.26 23.4% TOTAL PLANNING & SUSTAINABILITY 470,367 8,900 479,267 196,075.53 .00 283,191.47 40.9% 182 CLIMATE ACTION/PROJECT ADMIN CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND EXPENSE Report generated: 01/23/2024 10:05 User: 1281cnar Program ID: glytdbud Page 3 2ND QUARTER FOR 2024 06 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 81,828.67 .00 148,677.33 35.5% 11822 CLIMATE ACTION/PROJECT ADMIN 15,150 0 15,150 1,150.29 .00 13,999.71 7.6% TOTAL CLIMATE ACTION/PROJECT ADMIN 245,656 0 245,656 82,978.96 .00 162,677.04 33.8% 192 CENTRAL SERVICES 11921 CENTRAL SERVICES-PS 809,493 0 809,493 351,897.87 .00 457,595.13 43.5% 11922 CENTRAL SERVICES-OM 1,140,289 100,445 1,240,734 603,150.44 .00 637,583.18 48.6% TOTAL CENTRAL SERVICES 1,949,782 100,445 2,050,227 955,048.31 .00 1,095,178.31 46.6% 210 POLICE 12101 POLICE-PS 6,295,758 0 6,295,758 2,795,660.12 .00 3,500,097.88 44.4% 12102 POLICE-OM 539,531 37,271 576,802 259,053.97 .00 317,747.70 44.9% TOTAL POLICE 6,835,289 37,271 6,872,560 3,054,714.09 .00 3,817,845.58 44.4% 211 PARKING ENFORCEMENT 12111 PARKING ENFORCEMENT-PS 194,582 0 194,582 88,848.29 .00 105,733.71 45.7% 12112 PARKING ENFORCEMENT-OM 12,200 0 12,200 907.06 .00 11,292.94 7.4% TOTAL PARKING ENFORCEMENT 206,782 0 206,782 89,755.35 .00 117,026.65 43.4% 212 PUBLIC SAFETY COMM CENTER 12121 PUBLIC SAFETY COMM CTR-PS 706,210 0 706,210 297,364.15 .00 408,845.85 42.1% 12122 PUBLIC SAFETY COMM CTR-OM 18,223 0 18,223 7,309.21 .00 10,913.79 40.1% TOTAL PUBLIC SAFETY COMM CENTER 724,433 0 724,433 304,673.36 .00 419,759.64 42.1% 220 FIRE RESCUE DEPARTMENT CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND EXPENSE Report generated: 01/23/2024 10:05 User: 1281cnar Program ID: glytdbud Page 4 2ND QUARTER FOR 2024 06 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 3,095,446.91 .00 3,492,112.09 47.0% 12202 FIRE RESCUE - OM 690,330 368,955 1,059,285 326,754.62 .00 732,530.08 30.8% TOTAL FIRE RESCUE DEPARTMENT 7,277,889 368,955 7,646,844 3,422,201.53 .00 4,224,642.17 44.8% 241 BUILDING INSPECTORS 12411 BUILDING INSPECTORS-PS 534,380 0 534,380 244,276.56 .00 290,103.44 45.7% 12412 BUILDING INSPECTORS-OM 20,400 0 20,400 6,504.44 .00 13,895.56 31.9% TOTAL BUILDING INSPECTORS 554,780 0 554,780 250,781.00 .00 303,999.00 45.2% 421 DPW-ADMIN & ENGINEERING 14211 DPW ADMINISTRATION-PS 263,935 0 263,935 97,628.20 .00 166,306.80 37.0% 14212 DPW ADMINISTRATION-OM 39,325 0 39,325 17,647.69 .00 21,677.31 44.9% TOTAL DPW-ADMIN & ENGINEERING 303,260 0 303,260 115,275.89 .00 187,984.11 38.0% 422 HIGHWAYS 14221 HIGHWAYS-PS 886,650 0 886,650 324,224.01 .00 562,425.99 36.6% 14222 HIGHWAYS-OM 448,150 215,926 664,076 172,657.28 .00 491,418.31 26.0% 14223 HIGHWAYS-CAP 595,000 792,378 1,387,378 178,185.24 .00 1,209,192.91 12.8% TOTAL HIGHWAYS 1,929,800 1,008,304 2,938,104 675,066.53 .00 2,263,037.21 23.0% 423 SNOW & ICE 14231 SNOW & ICE-PS 131,000 0 131,000 8,869.93 .00 122,130.07 6.8% 14232 SNOW & ICE-OM 369,000 0 369,000 44,611.42 .00 324,388.58 12.1% TOTAL SNOW & ICE 500,000 0 500,000 53,481.35 .00 446,518.65 10.7% 481 PARKING CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND EXPENSE Report generated: 01/23/2024 10:05 User: 1281cnar Program ID: glytdbud Page 5 2ND QUARTER FOR 2024 06 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 481 PARKING APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 14811 PARKING-PS 287,180 0 287,180 128,564.66 .00 158,615.34 44.8% 14812 PARKING-OM 268,576 657 269,233 105,343.08 .00 163,889.53 39.1% 14813 PARKING-CAP 80,000 0 80,000 42,887.66 .00 37,112.34 53.6% TOTAL PARKING 635,756 657 636,413 276,795.40 .00 359,617.21 43.5% 492 DPW FORESTRY, PARKS & REC 14921 DPW FORESTRY, PARKS & REC-PS 1,041,233 0 1,041,233 354,981.79 .00 686,251.21 34.1% 14922 DPW FORESTRY, PARKS & REC-OM 319,900 350 320,250 137,329.30 .00 182,920.70 42.9% 14923 DPW FORESTRY, PARKS & REC-CAP 190,000 408,117 598,117 142,226.67 .00 455,890.05 23.8% TOTAL DPW FORESTRY, PARKS & REC 1,551,133 408,467 1,959,600 634,537.76 .00 1,325,061.96 32.4% 511 HEALTH DEPARTMENT 15111 HEALTH DEPARTMENT - PS 1,066,956 0 1,066,956 467,967.56 .00 598,988.44 43.9% 15112 HEALTH DEPARTMENT - OM 206,230 24,750 230,980 109,662.41 .00 121,317.78 47.5% TOTAL HEALTH DEPARTMENT 1,273,186 24,750 1,297,936 577,629.97 .00 720,306.22 44.5% 529 COMMUNITY CARE 15292 COMMUNITY CARE-OM 0 42,963 42,963 14,915.00 .00 28,047.74 34.7% TOTAL COMMUNITY CARE 0 42,963 42,963 14,915.00 .00 28,047.74 34.7% 541 SENIOR SERVICES 15411 SENIOR SERVICES -PS 380,046 0 380,046 211,008.57 .00 169,037.43 55.5% 15412 SENIOR SERVICES - OM 63,437 0 63,437 27,263.24 .00 36,173.76 43.0% TOTAL SENIOR SERVICES 443,483 0 443,483 238,271.81 .00 205,211.19 53.7% 543 VETERANS' SERVICE CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND EXPENSE Report generated: 01/23/2024 10:05 User: 1281cnar Program ID: glytdbud Page 6 2ND QUARTER FOR 2024 06 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 108,565.38 .00 123,876.62 46.7% 15432 VETERANS' SERVICE-OM 467,185 0 467,185 183,758.91 .00 283,426.09 39.3% TOTAL VETERANS' SERVICE 699,627 0 699,627 292,324.29 .00 407,302.71 41.8% 610 FORBES LIBRARY 16101 FORBES LIBRARY-PS 1,314,310 0 1,314,310 657,154.98 .00 657,155.02 50.0% 16102 FORBES LIBRARY-OM 215,132 0 215,132 126,989.65 .00 88,142.35 59.0% TOTAL FORBES LIBRARY 1,529,442 0 1,529,442 784,144.63 .00 745,297.37 51.3% 611 LILLY LIBRARY 16111 LILLY LIBRARY-PS 285,572 0 285,572 142,786.02 .00 142,785.98 50.0% 16112 LILLY LIBRARY-OM 100,317 0 100,317 50,158.50 .00 50,158.50 50.0% TOTAL LILLY LIBRARY 385,889 0 385,889 192,944.52 .00 192,944.48 50.0% 630 PARKS & RECREATION DEPARTMENT 16301 PARKS & RECREATION - PS 352,283 0 352,283 197,942.29 .00 154,340.71 56.2% 16302 PARKS & RECREATION-OM 29,500 0 29,500 12,867.13 .00 16,632.87 43.6% TOTAL PARKS & RECREATION DEPARTMENT 381,783 0 381,783 210,809.42 .00 170,973.58 55.2% 699 ARTS AND CULTURE 16991 ARTS & CULTURE-PS 74,468 0 74,468 35,086.37 .00 39,381.63 47.1% 16992 ARTS & CULTURE-OM 23,000 0 23,000 18,000.00 .00 5,000.00 78.3% TOTAL ARTS AND CULTURE 97,468 0 97,468 53,086.37 .00 44,381.63 54.5% 710 MUNICIPAL INDEBTEDNESS CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND EXPENSE Report generated: 01/23/2024 10:05 User: 1281cnar Program ID: glytdbud Page 7 2ND QUARTER FOR 2024 06 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,154,900.00 .00 1,620,000.00 57.1% TOTAL MUNICIPAL INDEBTEDNESS 3,774,900 0 3,774,900 2,154,900.00 .00 1,620,000.00 57.1% 750 INTEREST ON DEBT 17503 INTEREST ON MUNICIPAL DEBT 1,169,874 0 1,169,874 634,195.81 .00 535,678.19 54.2% TOTAL INTEREST ON DEBT 1,169,874 0 1,169,874 634,195.81 .00 535,678.19 54.2% 911 CONTRIBUTORY RETIREMENT 19111 CONTRIBUTORY RETIREMENT-PS 7,505,027 0 7,505,027 7,490,129.02 .00 14,897.98 99.8% 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,490,129.02 .00 34,947.98 99.5% 912 WORKERS' COMP INSURANCE 19121 WORKERS' COMP INSURANCE 495,220 0 495,220 474,002.00 .00 21,218.00 95.7% 19122 WORKERS' COMP INSURANCE 274,625 0 274,625 265,360.00 .00 9,265.00 96.6% TOTAL WORKERS' COMP INSURANCE 769,845 0 769,845 739,362.00 .00 30,483.00 96.0% 913 UNEMPLOYMENT INSURANCE 19131 UNEMPLOYMENT INSURANCE 100,000 148,000 248,000 -9,569.65 .00 257,569.65 -3.9% 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 -1,329.65 .00 259,329.65 -.5% 914 MEDICAL INSURANCE 19141 MEDICAL INSURANCE 13,185,387 151,825 13,337,212 6,581,571.78 .00 6,755,639.85 49.3% CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND EXPENSE Report generated: 01/23/2024 10:05 User: 1281cnar Program ID: glytdbud Page 8 2ND QUARTER FOR 2024 06 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 6,581,571.78 .00 6,770,639.85 49.3% 919 OTHER EMPLOYEE BENEFITS 19191 OTHER EMPLOYEE BENEFITS 1,683,860 0 1,683,860 276,976.48 .00 1,406,883.52 16.4% TOTAL OTHER EMPLOYEE BENEFITS 1,683,860 0 1,683,860 276,976.48 .00 1,406,883.52 16.4% 920 CHERRY SHEET ASSESSMENTS 19202 CHERRY SHEET ASSESSMENTS 4,129,833 75,851 4,205,684 2,094,322.00 .00 2,111,362.00 49.8% TOTAL CHERRY SHEET ASSESSMENTS 4,129,833 75,851 4,205,684 2,094,322.00 .00 2,111,362.00 49.8% 930 CAPITAL IMPROVEMENTS 19303 CAPITAL IMPROVEMENTS 200,000 14,910,137 15,110,137 2,993,654.90 59,644.71 12,056,836.91 20.2% TOTAL CAPITAL IMPROVEMENTS 200,000 14,910,137 15,110,137 2,993,654.90 59,644.71 12,056,836.91 20.2% 943 RESERVE FOR PERSONNEL 19491 RESERVE FOR PERSONNEL 100,000 0 100,000 -291.81 .00 100,291.81 -.3% TOTAL RESERVE FOR PERSONNEL 100,000 0 100,000 -291.81 .00 100,291.81 -.3% 945 GENERAL LIABILITY INS. 19452 GENERAL LIABILITY INSURANCE 851,829 0 851,829 773,498.00 .00 78,331.00 90.8% TOTAL GENERAL LIABILITY INS. 851,829 0 851,829 773,498.00 .00 78,331.00 90.8% GRAND TOTAL 65,885,523 17,482,759 83,368,282 38,181,263.72 59,644.71 45,127,373.55 45.9% ** END OF REPORT - Generated by Charlene Nardi ** CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND EXPENSE Report generated: 01/23/2024 10:05 User: 1281cnar Program ID: glytdbud Page 9 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: FY2024 GENERAL FUND EXPENSE Includes accounts exceeding 0% of budget. Print totals only: Y Year/Period: 2024/ 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 CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND EXPENSE Report generated: 01/23/2024 10:05 User: 1281cnar Program ID: glytdbud Page 10 2ND QUARTER REPORT OPTIONS Account status Rollup Code