Loading...
GF Expenses.093023CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND EXPENSES Report generated: 10/13/2023 11:07 User: 1281cnar Program ID: glytdbud Page 1 QTR ONE FOR 2024 03 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 111 CITY COUNCIL 11111 CITY COUNCIL-PS 149,660 0 149,660 36,263.59 .00 113,396.41 24.2% 11112 CITY COUNCIL-OM 63,900 0 63,900 .00 .00 63,900.00 .0% TOTAL CITY COUNCIL 213,560 0 213,560 36,263.59 .00 177,296.41 17.0% 121 MAYOR 11211 MAYOR-PS 438,985 30,000 468,985 99,387.18 .00 369,597.82 21.2% 11212 MAYOR-OM 16,942 0 16,942 6,550.59 .00 10,391.41 38.7% TOTAL MAYOR 455,927 30,000 485,927 105,937.77 .00 379,989.23 21.8% 135 AUDITOR 11351 AUDITOR-PS 333,402 0 333,402 84,116.29 .00 249,285.71 25.2% 11352 AUDITOR-OM 15,282 0 15,282 1,030.00 .00 14,252.00 6.7% TOTAL AUDITOR 348,684 0 348,684 85,146.29 .00 263,537.71 24.4% 141 ASSESSOR 11411 ASSESSOR-PS 190,498 0 190,498 44,453.42 .00 146,044.58 23.3% 11412 ASSESSOR-OM 32,700 0 32,700 2,651.42 .00 30,048.58 8.1% 11413 ASSESSORS - CAPITAL 95,000 116,148 211,148 52,910.00 .00 158,238.00 25.1% TOTAL ASSESSOR 318,198 116,148 434,346 100,014.84 .00 334,331.16 23.0% 146 COLLECTOR 11461 COLLECTOR-PS 430,809 0 430,809 99,280.16 .00 331,528.84 23.0% 11462 COLLECTOR-OM 266,435 0 266,435 47,503.99 .00 218,931.01 17.8% TOTAL COLLECTOR 697,244 0 697,244 146,784.15 .00 550,459.85 21.1% CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND EXPENSES Report generated: 10/13/2023 11:07 User: 1281cnar Program ID: glytdbud Page 2 QTR ONE FOR 2024 03 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 11,757.45 .00 271,847.55 4.1% TOTAL LEGAL SERVICES 275,000 8,605 283,605 11,757.45 .00 271,847.55 4.1% 152 HUMAN RESOURCES 11521 HUMAN RESOURCES-PS 318,830 0 318,830 87,352.34 .00 231,477.66 27.4% 11522 HUMAN RESOURCES-OM 21,550 0 21,550 1,425.00 .00 20,125.00 6.6% TOTAL HUMAN RESOURCES 340,380 0 340,380 88,777.34 .00 251,602.66 26.1% 155 INFORMATION TECHNOLOGY 11551 INFORMATION TECHNOLOGY - PS 519,460 0 519,460 85,210.29 .00 434,249.71 16.4% 11552 INFORMATION TECHNOLOGY - OM 846,050 0 846,050 384,660.67 .00 461,389.33 45.5% TOTAL INFORMATION TECHNOLOGY 1,365,510 0 1,365,510 469,870.96 .00 895,639.04 34.4% 161 CITY CLERK 11611 CITY CLERK-PS 335,095 0 335,095 55,055.35 .00 280,039.65 16.4% 11612 CITY CLERK-OM 34,565 0 34,565 5,115.30 .00 29,449.70 14.8% TOTAL CITY CLERK 369,660 0 369,660 60,170.65 .00 309,489.35 16.3% 175 PLANNING & SUSTAINABILITY 11751 PLANNING & SUSTAINABILITY - P 404,632 0 404,632 89,915.92 .00 314,716.08 22.2% 11752 PLANNING & SUSTAINABILITY -OM 65,735 8,900 74,635 8,132.34 .00 66,502.66 10.9% TOTAL PLANNING & SUSTAINABILITY 470,367 8,900 479,267 98,048.26 .00 381,218.74 20.5% 182 CLIMATE ACTION/PROJECT ADMIN CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND EXPENSES Report generated: 10/13/2023 11:07 User: 1281cnar Program ID: glytdbud Page 3 QTR ONE FOR 2024 03 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 31,202.14 .00 199,303.86 13.5% 11822 CLIMATE ACTION/PROJECT ADMIN 15,150 0 15,150 180.00 .00 14,970.00 1.2% TOTAL CLIMATE ACTION/PROJECT ADMIN 245,656 0 245,656 31,382.14 .00 214,273.86 12.8% 192 CENTRAL SERVICES 11921 CENTRAL SERVICES-PS 809,493 0 809,493 167,262.10 .00 642,230.90 20.7% 11922 CENTRAL SERVICES-OM 1,140,289 100,445 1,240,734 278,393.73 .00 962,339.89 22.4% TOTAL CENTRAL SERVICES 1,949,782 100,445 2,050,227 445,655.83 .00 1,604,570.79 21.7% 210 POLICE 12101 POLICE-PS 6,295,758 0 6,295,758 1,229,685.50 .00 5,066,072.50 19.5% 12102 POLICE-OM 539,531 37,271 576,802 149,297.65 .00 427,504.02 25.9% TOTAL POLICE 6,835,289 37,271 6,872,560 1,378,983.15 .00 5,493,576.52 20.1% 211 PARKING ENFORCEMENT 12111 PARKING ENFORCEMENT-PS 194,582 0 194,582 47,249.41 .00 147,332.59 24.3% 12112 PARKING ENFORCEMENT-OM 12,200 0 12,200 565.09 .00 11,634.91 4.6% TOTAL PARKING ENFORCEMENT 206,782 0 206,782 47,814.50 .00 158,967.50 23.1% 212 PUBLIC SAFETY COMM CENTER 12121 PUBLIC SAFETY COMM CTR-PS 706,210 0 706,210 205,412.42 .00 500,797.58 29.1% 12122 PUBLIC SAFETY COMM CTR-OM 18,223 0 18,223 4,976.76 .00 13,246.24 27.3% TOTAL PUBLIC SAFETY COMM CENTER 724,433 0 724,433 210,389.18 .00 514,043.82 29.0% 220 FIRE RESCUE DEPARTMENT CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND EXPENSES Report generated: 10/13/2023 11:07 User: 1281cnar Program ID: glytdbud Page 4 QTR ONE FOR 2024 03 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 1,498,934.95 .00 5,088,624.05 22.8% 12202 FIRE RESCUE - OM 690,330 368,955 1,059,285 187,925.17 .00 871,359.53 17.7% TOTAL FIRE RESCUE DEPARTMENT 7,277,889 368,955 7,646,844 1,686,860.12 .00 5,959,983.58 22.1% 241 BUILDING INSPECTORS 12411 BUILDING INSPECTORS-PS 534,380 0 534,380 121,748.65 .00 412,631.35 22.8% 12412 BUILDING INSPECTORS-OM 20,400 0 20,400 3,768.48 .00 16,631.52 18.5% TOTAL BUILDING INSPECTORS 554,780 0 554,780 125,517.13 .00 429,262.87 22.6% 421 DPW-ADMIN & ENGINEERING 14211 DPW ADMINISTRATION-PS 263,935 0 263,935 48,552.70 .00 215,382.30 18.4% 14212 DPW ADMINISTRATION-OM 39,325 0 39,325 6,027.10 .00 33,297.90 15.3% TOTAL DPW-ADMIN & ENGINEERING 303,260 0 303,260 54,579.80 .00 248,680.20 18.0% 422 HIGHWAYS 14221 HIGHWAYS-PS 886,650 0 886,650 170,851.37 .00 715,798.63 19.3% 14222 HIGHWAYS-OM 448,150 215,926 664,076 97,589.32 .00 566,486.27 14.7% 14223 HIGHWAYS-CAP 595,000 792,378 1,387,378 27,559.05 .00 1,359,819.10 2.0% TOTAL HIGHWAYS 1,929,800 1,008,304 2,938,104 295,999.74 .00 2,642,104.00 10.1% 423 SNOW & ICE 14231 SNOW & ICE-PS 131,000 0 131,000 .00 .00 131,000.00 .0% 14232 SNOW & ICE-OM 369,000 0 369,000 11,284.13 .00 357,715.87 3.1% TOTAL SNOW & ICE 500,000 0 500,000 11,284.13 .00 488,715.87 2.3% 481 PARKING CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND EXPENSES Report generated: 10/13/2023 11:07 User: 1281cnar Program ID: glytdbud Page 5 QTR ONE FOR 2024 03 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 481 PARKING APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 14811 PARKING-PS 287,180 0 287,180 67,649.76 .00 219,530.24 23.6% 14812 PARKING-OM 268,576 657 269,233 56,941.42 .00 212,291.19 21.1% 14813 PARKING-CAP 80,000 0 80,000 34,161.80 .00 45,838.20 42.7% TOTAL PARKING 635,756 657 636,413 158,752.98 .00 477,659.63 24.9% 492 DPW FORESTRY, PARKS & REC 14921 DPW FORESTRY, PARKS & REC-PS 1,041,233 0 1,041,233 190,449.62 .00 850,783.38 18.3% 14922 DPW FORESTRY, PARKS & REC-OM 319,900 350 320,250 74,927.33 .00 245,322.67 23.4% 14923 DPW FORESTRY, PARKS & REC-CAP 190,000 408,117 598,117 92,457.12 .00 505,659.60 15.5% TOTAL DPW FORESTRY, PARKS & REC 1,551,133 408,467 1,959,600 357,834.07 .00 1,601,765.65 18.3% 511 HEALTH DEPARTMENT 15111 HEALTH DEPARTMENT - PS 1,066,956 0 1,066,956 235,120.25 .00 831,835.75 22.0% 15112 HEALTH DEPARTMENT - OM 206,230 24,750 230,980 59,612.07 .00 171,368.12 25.8% TOTAL HEALTH DEPARTMENT 1,273,186 24,750 1,297,936 294,732.32 .00 1,003,203.87 22.7% 529 COMMUNITY CARE 15292 COMMUNITY CARE-OM 0 42,963 42,963 8,375.00 .00 34,587.74 19.5% TOTAL COMMUNITY CARE 0 42,963 42,963 8,375.00 .00 34,587.74 19.5% 541 SENIOR SERVICES 15411 SENIOR SERVICES -PS 380,046 0 380,046 105,754.30 .00 274,291.70 27.8% 15412 SENIOR SERVICES - OM 63,437 0 63,437 13,717.15 .00 49,719.85 21.6% TOTAL SENIOR SERVICES 443,483 0 443,483 119,471.45 .00 324,011.55 26.9% 543 VETERANS' SERVICE CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND EXPENSES Report generated: 10/13/2023 11:07 User: 1281cnar Program ID: glytdbud Page 6 QTR ONE FOR 2024 03 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 54,173.35 .00 178,268.65 23.3% 15432 VETERANS' SERVICE-OM 467,185 0 467,185 90,775.39 .00 376,409.61 19.4% TOTAL VETERANS' SERVICE 699,627 0 699,627 144,948.74 .00 554,678.26 20.7% 610 FORBES LIBRARY 16101 FORBES LIBRARY-PS 1,314,310 0 1,314,310 328,577.49 .00 985,732.51 25.0% 16102 FORBES LIBRARY-OM 215,132 0 215,132 101,619.96 .00 113,512.04 47.2% TOTAL FORBES LIBRARY 1,529,442 0 1,529,442 430,197.45 .00 1,099,244.55 28.1% 611 LILLY LIBRARY 16111 LILLY LIBRARY-PS 285,572 0 285,572 71,393.01 .00 214,178.99 25.0% 16112 LILLY LIBRARY-OM 100,317 0 100,317 25,079.25 .00 75,237.75 25.0% TOTAL LILLY LIBRARY 385,889 0 385,889 96,472.26 .00 289,416.74 25.0% 630 PARKS & RECREATION DEPARTMENT 16301 PARKS & RECREATION - PS 352,283 0 352,283 99,353.83 .00 252,929.17 28.2% 16302 PARKS & RECREATION-OM 29,500 0 29,500 5,286.16 .00 24,213.84 17.9% TOTAL PARKS & RECREATION DEPARTMENT 381,783 0 381,783 104,639.99 .00 277,143.01 27.4% 699 ARTS AND CULTURE 16991 ARTS & CULTURE-PS 74,468 0 74,468 17,939.09 .00 56,528.91 24.1% 16992 ARTS & CULTURE-OM 23,000 0 23,000 13,325.00 .00 9,675.00 57.9% TOTAL ARTS AND CULTURE 97,468 0 97,468 31,264.09 .00 66,203.91 32.1% 710 MUNICIPAL INDEBTEDNESS CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND EXPENSES Report generated: 10/13/2023 11:07 User: 1281cnar Program ID: glytdbud Page 7 QTR ONE FOR 2024 03 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 782,900.00 .00 2,992,000.00 20.7% TOTAL MUNICIPAL INDEBTEDNESS 3,774,900 0 3,774,900 782,900.00 .00 2,992,000.00 20.7% 750 INTEREST ON DEBT 17503 INTEREST ON MUNICIPAL DEBT 1,169,874 0 1,169,874 244,656.67 .00 925,217.33 20.9% TOTAL INTEREST ON DEBT 1,169,874 0 1,169,874 244,656.67 .00 925,217.33 20.9% 911 CONTRIBUTORY RETIREMENT 19111 CONTRIBUTORY RETIREMENT-PS 7,505,027 0 7,505,027 7,485,078.01 .00 19,948.99 99.7% 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,485,078.01 .00 39,998.99 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 4,037.00 .00 243,963.00 1.6% 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 12,277.00 .00 245,723.00 4.8% 914 MEDICAL INSURANCE 19141 MEDICAL INSURANCE 13,185,387 151,825 13,337,212 3,295,784.36 .00 10,041,427.27 24.7% CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND EXPENSES Report generated: 10/13/2023 11:07 User: 1281cnar Program ID: glytdbud Page 8 QTR ONE FOR 2024 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 13,200,387 151,825 13,352,212 3,295,784.36 .00 10,056,427.27 24.7% 919 OTHER EMPLOYEE BENEFITS 19191 OTHER EMPLOYEE BENEFITS 1,683,860 0 1,683,860 381,752.91 .00 1,302,107.09 22.7% TOTAL OTHER EMPLOYEE BENEFITS 1,683,860 0 1,683,860 381,752.91 .00 1,302,107.09 22.7% 920 CHERRY SHEET ASSESSMENTS 19202 CHERRY SHEET ASSESSMENTS 4,129,833 0 4,129,833 1,052,267.00 .00 3,077,566.00 25.5% TOTAL CHERRY SHEET ASSESSMENTS 4,129,833 0 4,129,833 1,052,267.00 .00 3,077,566.00 25.5% 930 CAPITAL IMPROVEMENTS 19303 CAPITAL IMPROVEMENTS 200,000 14,780,292 14,980,292 1,191,832.96 220,849.37 13,567,609.69 9.4% TOTAL CAPITAL IMPROVEMENTS 200,000 14,780,292 14,980,292 1,191,832.96 220,849.37 13,567,609.69 9.4% 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,245,630 83,131,153 23,197,042.47 220,849.37 59,713,260.80 28.2% ** END OF REPORT - Generated by Charlene Nardi ** CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND EXPENSES Report generated: 10/13/2023 11:07 User: 1281cnar Program ID: glytdbud Page 9 QTR ONE 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 EXPENSES Includes accounts exceeding 0% of budget. Print totals only: Y Year/Period: 2024/ 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: 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 EXPENSES Report generated: 10/13/2023 11:07 User: 1281cnar Program ID: glytdbud Page 10 QTR ONE REPORT OPTIONS Account status Rollup Code