Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GF Expenses.123122
01/17/2023 11:43 |CITY OF NORTHAMPTON, MA - LIVE |P 1 1281cnar |FY23 GENERAL FUND EXPENSES |glytdbud 2ND QUARTER FOR 2023 06 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 74,707.57 .00 71,334.43 51.2% 11112 CITY COUNCIL-OM 63,600 0 63,600 684.70 .00 62,915.30 1.1% TOTAL CITY COUNCIL 209,642 0 209,642 75,392.27 .00 134,249.73 36.0% 121 MAYOR _________________________________________ 11211 MAYOR-PS 418,228 0 418,228 197,410.06 .00 220,817.94 47.2% 11212 MAYOR-OM 16,442 0 16,442 7,987.97 .00 8,454.03 48.6% TOTAL MAYOR 434,670 0 434,670 205,398.03 .00 229,271.97 47.3% 135 AUDITOR _________________________________________ 11351 AUDITOR-PS 360,897 0 360,897 166,309.85 .00 194,587.15 46.1% 11352 AUDITOR-OM 15,280 0 15,280 1,894.48 .00 13,385.52 12.4% TOTAL AUDITOR 376,177 0 376,177 168,204.33 .00 207,972.67 44.7% 141 ASSESSOR _________________________________________ 11411 ASSESSOR-PS 177,232 0 177,232 84,908.34 .00 92,323.66 47.9% 11412 ASSESSOR-OM 116,200 99,298 215,498 66,319.97 .00 149,178.03 30.8% TOTAL ASSESSOR 293,432 99,298 392,730 151,228.31 .00 241,501.69 38.5% 146 COLLECTOR _________________________________________ 11461 COLLECTOR-PS 404,308 0 404,308 179,694.16 .00 224,613.84 44.4% 11462 COLLECTOR-OM 276,435 0 276,435 83,088.11 .00 193,346.89 30.1% TOTAL COLLECTOR 680,743 0 680,743 262,782.27 .00 417,960.73 38.6% 151 LEGAL SERVICES _________________________________________ 01/17/2023 11:43 |CITY OF NORTHAMPTON, MA - LIVE |P 2 1281cnar |FY23 GENERAL FUND EXPENSES |glytdbud 2ND QUARTER FOR 2023 06 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 71,588.85 .00 203,411.15 26.0% TOTAL LEGAL SERVICES 275,000 0 275,000 71,588.85 .00 203,411.15 26.0% 152 HUMAN RESOURCES _________________________________________ 11521 HUMAN RESOURCES-PS 312,614 0 312,614 175,546.48 .00 137,067.52 56.2% 11522 HUMAN RESOURCES-OM 19,550 0 19,550 4,291.01 .00 15,258.99 21.9% TOTAL HUMAN RESOURCES 332,164 0 332,164 179,837.49 .00 152,326.51 54.1% 155 INFORMATION TECHNOLOGY _________________________________________ 11551 INFORMATION TECHNOLOGY - PS 453,282 0 453,282 215,264.26 .00 238,017.74 47.5% 11552 INFORMATION TECHNOLOGY - OM 748,499 9,320 757,819 474,613.69 .00 283,205.31 62.6% TOTAL INFORMATION TECHNOLOGY 1,201,781 9,320 1,211,101 689,877.95 .00 521,223.05 57.0% 161 CITY CLERK _________________________________________ 11611 CITY CLERK-PS 327,841 0 327,841 191,541.80 .00 136,299.20 58.4% 11612 CITY CLERK-OM 34,565 0 34,565 9,795.90 .00 24,769.10 28.3% TOTAL CITY CLERK 362,406 0 362,406 201,337.70 .00 161,068.30 55.6% 175 PLANNING & SUSTAINABILITY _________________________________________ 11751 PLANNING & SUSTAINABILITY - P 406,167 0 406,167 166,324.65 .00 239,842.35 40.9% 11752 PLANNING & SUSTAINABILITY -OM 64,200 0 64,200 16,071.70 .00 48,128.30 25.0% TOTAL PLANNING & SUSTAINABILITY 470,367 0 470,367 182,396.35 .00 287,970.65 38.8% 192 CENTRAL SERVICES _________________________________________ 01/17/2023 11:43 |CITY OF NORTHAMPTON, MA - LIVE |P 3 1281cnar |FY23 GENERAL FUND EXPENSES |glytdbud 2ND QUARTER FOR 2023 06 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 323,288.91 .00 442,611.09 42.2% 11922 CENTRAL SERVICES-OM 1,106,145 3,050 1,109,195 445,870.71 .00 663,324.29 40.2% TOTAL CENTRAL SERVICES 1,872,045 3,050 1,875,095 769,159.62 .00 1,105,935.38 41.0% 210 POLICE _________________________________________ 12101 POLICE-PS 5,677,286 0 5,677,286 2,702,504.11 .00 2,974,781.89 47.6% 12102 POLICE-OM 524,531 45,000 569,531 249,405.00 .00 320,126.00 43.8% TOTAL POLICE 6,201,817 45,000 6,246,817 2,951,909.11 .00 3,294,907.89 47.3% 211 PARKING ENFORCEMENT _________________________________________ 12111 PARKING ENFORCEMENT-PS 163,729 0 163,729 49,681.35 .00 114,047.65 30.3% 12112 PARKING ENFORCEMENT-OM 12,200 0 12,200 4,330.09 .00 7,869.91 35.5% TOTAL PARKING ENFORCEMENT 175,929 0 175,929 54,011.44 .00 121,917.56 30.7% 212 PUBLIC SAFETY COMM CENTER _________________________________________ 12121 PUBLIC SAFETY COMM CTR-PS 660,293 0 660,293 288,101.68 .00 372,191.32 43.6% 12122 PUBLIC SAFETY COMM CTR-OM 24,998 0 24,998 12,521.57 .00 12,476.43 50.1% TOTAL PUBLIC SAFETY COMM CENTER 685,291 0 685,291 300,623.25 .00 384,667.75 43.9% 220 FIRE RESCUE DEPARTMENT _________________________________________ 12201 FIRE RESCUE - PS 5,820,477 0 5,820,477 2,802,354.34 .00 3,018,122.66 48.1% 12202 FIRE RESCUE - OM 832,680 421,561 1,254,241 578,601.85 .00 675,638.77 46.1% TOTAL FIRE RESCUE DEPARTMENT 6,653,157 421,561 7,074,718 3,380,956.19 .00 3,693,761.43 47.8% 241 BUILDING INSPECTORS _________________________________________ 01/17/2023 11:43 |CITY OF NORTHAMPTON, MA - LIVE |P 4 1281cnar |FY23 GENERAL FUND EXPENSES |glytdbud 2ND QUARTER FOR 2023 06 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 239,113.95 .00 256,557.05 48.2% 12412 BUILDING INSPECTORS-OM 26,200 0 26,200 10,887.85 .00 15,312.15 41.6% TOTAL BUILDING INSPECTORS 521,871 0 521,871 250,001.80 .00 271,869.20 47.9% 421 DPW-ADMIN & ENGINEERING _________________________________________ 14211 DPW ADMINISTRATION-PS 250,295 0 250,295 99,923.62 .00 150,371.38 39.9% 14212 DPW ADMINISTRATION-OM 39,325 0 39,325 17,754.59 .00 21,570.41 45.1% TOTAL DPW-ADMIN & ENGINEERING 289,620 0 289,620 117,678.21 .00 171,941.79 40.6% 422 HIGHWAYS _________________________________________ 14221 HIGHWAYS-PS 771,667 0 771,667 303,775.09 .00 467,891.91 39.4% 14222 HIGHWAYS-OM 520,400 166,320 686,720 231,275.32 .00 455,444.68 33.7% 14223 HIGHWAYS-CAP 510,000 657,677 1,167,677 270,375.87 .00 897,301.17 23.2% TOTAL HIGHWAYS 1,802,067 823,997 2,626,064 805,426.28 .00 1,820,637.76 30.7% 423 SNOW & ICE _________________________________________ 14231 SNOW & ICE-PS 131,000 0 131,000 29,692.13 .00 101,307.87 22.7% 14232 SNOW & ICE-OM 369,000 0 369,000 21,087.96 .00 347,912.04 5.7% TOTAL SNOW & ICE 500,000 0 500,000 50,780.09 .00 449,219.91 10.2% 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 _________________________________________ 01/17/2023 11:43 |CITY OF NORTHAMPTON, MA - LIVE |P 5 1281cnar |FY23 GENERAL FUND EXPENSES |glytdbud 2ND QUARTER FOR 2023 06 ORIGINAL TRANFRS/REVISED AVAILABLE PCT 481 PARKING APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 14811 PARKING-PS 271,269 0 271,269 124,862.63 .00 146,406.37 46.0% 14812 PARKING-OM 262,398 0 262,398 109,240.45 .00 153,157.55 41.6% 14813 PARKING-CAP 80,000 0 80,000 34,447.35 .00 45,552.65 43.1% TOTAL PARKING 613,667 0 613,667 268,550.43 .00 345,116.57 43.8% 492 DPW FORESTRY, PARKS & REC _________________________________________ 14921 DPW FORESTRY, PARKS & REC-PS 981,660 0 981,660 356,775.47 .00 624,884.53 36.3% 14922 DPW FORESTRY, PARKS & REC-OM 311,200 0 311,200 150,101.13 .00 161,098.87 48.2% 14923 DPW FORESTRY, PARKS & REC-CAP 199,999 144,425 344,424 79,595.87 .00 264,827.64 23.1% TOTAL DPW FORESTRY, PARKS & REC 1,492,859 144,425 1,637,284 586,472.47 .00 1,050,811.04 35.8% 511 HEALTH DEPARTMENT _________________________________________ 15111 HEALTH DEPARTMENT - PS 1,092,129 0 1,092,129 301,362.98 .00 790,766.02 27.6% 15112 HEALTH DEPARTMENT - OM 166,230 0 166,230 33,911.38 .00 132,318.62 20.4% TOTAL HEALTH DEPARTMENT 1,258,359 0 1,258,359 335,274.36 .00 923,084.64 26.6% 529 COMMUNITY CARE _________________________________________ 15292 COMMUNITY CARE-OM 0 241,706 241,706 59,511.32 .00 182,194.89 24.6% TOTAL COMMUNITY CARE 0 241,706 241,706 59,511.32 .00 182,194.89 24.6% 541 SENIOR SERVICES _________________________________________ 15411 SENIOR SERVICES -PS 352,340 0 352,340 160,792.97 .00 191,547.03 45.6% 15412 SENIOR SERVICES - OM 46,264 0 46,264 19,543.08 .00 26,720.92 42.2% TOTAL SENIOR SERVICES 398,604 0 398,604 180,336.05 .00 218,267.95 45.2% 543 VETERANS' SERVICE _________________________________________ 01/17/2023 11:43 |CITY OF NORTHAMPTON, MA - LIVE |P 6 1281cnar |FY23 GENERAL FUND EXPENSES |glytdbud 2ND QUARTER FOR 2023 06 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 103,016.74 .00 116,947.26 46.8% 15432 VETERANS' SERVICE-OM 509,130 0 509,130 153,478.07 .00 355,651.93 30.1% TOTAL VETERANS' SERVICE 729,094 0 729,094 256,494.81 .00 472,599.19 35.2% 610 FORBES LIBRARY _________________________________________ 16101 FORBES LIBRARY-PS 1,267,095 0 1,267,095 739,138.75 .00 527,956.25 58.3% 16102 FORBES LIBRARY-OM 210,629 0 210,629 142,314.18 .00 68,314.82 67.6% TOTAL FORBES LIBRARY 1,477,724 0 1,477,724 881,452.93 .00 596,271.07 59.6% 611 LILLY LIBRARY _________________________________________ 16111 LILLY LIBRARY-PS 278,902 0 278,902 162,692.81 .00 116,209.19 58.3% 16112 LILLY LIBRARY-OM 93,939 0 93,939 54,797.75 .00 39,141.25 58.3% TOTAL LILLY LIBRARY 372,841 0 372,841 217,490.56 .00 155,350.44 58.3% 630 PARKS & RECREATION DEPARTMENT _________________________________________ 16301 PARKS & RECREATION - PS 332,793 0 332,793 204,374.90 .00 128,418.10 61.4% 16302 PARKS & RECREATION-OM 27,500 0 27,500 10,027.23 .00 17,472.77 36.5% TOTAL PARKS & RECREATION DEPARTMENT 360,293 0 360,293 214,402.13 .00 145,890.87 59.5% 699 ARTS AND CULTURE _________________________________________ 16991 ARTS & CULTURE-PS 69,453 0 69,453 33,421.36 .00 36,031.64 48.1% 16992 ARTS & CULTURE-OM 21,250 0 21,250 20,750.00 .00 500.00 97.6% TOTAL ARTS AND CULTURE 90,703 0 90,703 54,171.36 .00 36,531.64 59.7% 710 MUNICIPAL INDEBTEDNESS _________________________________________ 01/17/2023 11:43 |CITY OF NORTHAMPTON, MA - LIVE |P 7 1281cnar |FY23 GENERAL FUND EXPENSES |glytdbud 2ND QUARTER FOR 2023 06 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 1,646,200.00 .00 1,805,001.00 47.7% TOTAL MUNICIPAL INDEBTEDNESS 3,451,201 0 3,451,201 1,646,200.00 .00 1,805,001.00 47.7% 750 INTEREST ON DEBT _________________________________________ 17503 INTEREST ON MUNICIPAL DEBT 1,055,761 0 1,055,761 543,341.32 .00 512,419.68 51.5% TOTAL INTEREST ON DEBT 1,055,761 0 1,055,761 543,341.32 .00 512,419.68 51.5% 911 CONTRIBUTORY RETIREMENT _________________________________________ 19111 CONTRIBUTORY RETIREMENT-PS 7,085,854 0 7,085,854 7,070,631.00 .00 15,223.00 99.8% 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,080,581.00 .00 25,273.00 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 16,431.00 .00 182,225.11 8.3% 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 24,671.00 .00 183,985.11 11.8% 914 MEDICAL INSURANCE _________________________________________ 19141 MEDICAL INSURANCE 12,619,303 167,740 12,787,043 5,942,325.76 .00 6,844,717.38 46.5% 01/17/2023 11:43 |CITY OF NORTHAMPTON, MA - LIVE |P 8 1281cnar |FY23 GENERAL FUND EXPENSES |glytdbud 2ND QUARTER FOR 2023 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 12,634,303 167,740 12,802,043 5,942,325.76 .00 6,859,717.38 46.4% 919 OTHER EMPLOYEE BENEFITS _________________________________________ 19191 OTHER EMPLOYEE BENEFITS 1,651,122 0 1,651,122 1,020,235.07 .00 630,886.93 61.8% TOTAL OTHER EMPLOYEE BENEFITS 1,651,122 0 1,651,122 1,020,235.07 .00 630,886.93 61.8% 920 CHERRY SHEET ASSESSMENTS _________________________________________ 19202 CHERRY SHEET ASSESSMENTS 3,913,623 140,809 4,054,432 1,982,665.00 .00 2,071,767.00 48.9% TOTAL CHERRY SHEET ASSESSMENTS 3,913,623 140,809 4,054,432 1,982,665.00 .00 2,071,767.00 48.9% 930 CAPITAL IMPROVEMENTS _________________________________________ 19303 CAPITAL IMPROVEMENTS 446,057 11,434,343 11,880,400 1,859,273.15 236,212.79 9,784,914.03 17.6% TOTAL CAPITAL IMPROVEMENTS 446,057 11,434,343 11,880,400 1,859,273.15 236,212.79 9,784,914.03 17.6% 943 RESERVE FOR PERSONNEL _________________________________________ 19491 RESERVE FOR PERSONNEL 675,127 0 675,127 259,146.95 .00 415,980.05 38.4% TOTAL RESERVE FOR PERSONNEL 675,127 0 675,127 259,146.95 .00 415,980.05 38.4% 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 13,639,905 76,338,492 35,773,553.21 236,212.79 40,328,725.60 47.2% ** END OF REPORT - Generated by Charlene Nardi ** 01/17/2023 11:43 |CITY OF NORTHAMPTON, MA - LIVE |P 9 1281cnar |FY23 GENERAL FUND EXPENSES |glytdbud 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: FY23 GENERAL FUND EXPENSES Includes accounts exceeding 0% of budget. Print totals only: Y Year/Period: 2023/ 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 01/17/2023 11:43 |CITY OF NORTHAMPTON, MA - LIVE |P 10 1281cnar |FY23 GENERAL FUND EXPENSES |glytdbud 2ND QUARTER REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Account status Rollup Code