Loading...
GF Revenue.093023CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND REVENUE Report generated: 10/13/2023 10:44 User: 1281cnar Program ID: glytdbud Page 1 FOR 2024 03 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL 41 TAXES & EXCISES 10004 GENERAL FUND REVENUES 411000 P.P. TAX REVENUE -2,263,302 0 -2,263,302 -495,266.84 -1,768,035.16 21.9% 412000 R.E. TAX REVENUE -73,180,090 0 -73,180,090 -18,390,961.37 -54,789,128.63 25.1% 414200 TAX TITLE REVENUE 0 0 0 -67,051.09 67,051.09 100.0% 415000 MOTOR VEHICLE EXCISE -2,800,000 0 -2,800,000 -339,305.14 -2,460,694.86 12.1% 415010 ABATED MVE 0 0 0 -5,076.60 5,076.60 100.0% 416010 BOAT EXCISE -3,650 0 -3,650 .00 -3,650.00 .0% 416030 HOTEL/MOTEL TAX CH 145 -750,000 0 -750,000 -363,801.31 -386,198.69 48.5% 416035 MEALS TAX, CHAPT. 64L, S.2A -650,000 0 -650,000 -201,746.17 -448,253.83 31.0% 416036 ADULT MARIJUANA EXCISE CH64N -800,000 0 -800,000 -208,429.30 -591,570.70 26.1% 417010 INTEREST ON TAXES -150,000 0 -150,000 -40,135.05 -109,864.95 26.8% 417030 INTEREST ON TAX TITLES -36,000 0 -36,000 -14,586.42 -21,413.58 40.5% 417031 TAX TITLE ATTORNEY FEES 0 0 0 -4,063.72 4,063.72 100.0% 417040 TAX TITLE RELEASES -1,000 0 -1,000 -951.78 -48.22 95.2% 417050 INT/RELEASE/CH41A R.E. 0 0 0 -8.20 8.20 100.0% 418010 PILOT-HOUSING AUTHORITY -27,000 0 -27,000 .00 -27,000.00 .0% 418011 PILOT-SMITH COLLEGE -125,000 0 -125,000 .00 -125,000.00 .0% 418012 PILOT-B'NAI ISRAEL SYNAGOGUE -4,300 0 -4,300 .00 -4,300.00 .0% 418013 PILOT-US FISH & WILDLIFE -250 0 -250 .00 -250.00 .0% 418014 PILOT - EASTHAMPTON -900 0 -900 .00 -900.00 .0% 418015 PILOT-FAIR GROUNDS -7,000 0 -7,000 .00 -7,000.00 .0% 418016 PILOT-NONOTUCK COMM SCH -700 0 -700 .00 -700.00 .0% 418017 PILOT-SOLDIER ON -10,000 0 -10,000 .00 -10,000.00 .0% 418018 PILOT-LANDFILL SOLAR ARRAY -10,000 0 -10,000 -5,000.00 -5,000.00 50.0% 418020 PILOT-MUSIC SCHOOL -3,200 0 -3,200 .00 -3,200.00 .0% TOTAL GENERAL FUND REVENUES -80,822,392 0 -80,822,392 -20,136,382.99 -60,686,009.01 24.9% TOTAL TAXES & EXCISES -80,822,392 0 -80,822,392 -20,136,382.99 -60,686,009.01 24.9% 42 CHARGES FOR SERVICES 10004 GENERAL FUND REVENUES 424010 PARKING REVENUES -230,000 0 -230,000 -53,834.94 -176,165.06 23.4% CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND REVENUE Report generated: 10/13/2023 10:44 User: 1281cnar Program ID: glytdbud Page 2 FOR 2024 03 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL 424011 PARKING LOT REVENUE -80,000 0 -80,000 -19,441.71 -60,558.29 24.3% 424012 PARKING GARAGE REVENUE -400,000 0 -400,000 -69,314.79 -330,685.21 17.3% 424013 PARKING PASS REVENUE -125,000 0 -125,000 -28,151.98 -96,848.02 22.5% 424015 PRK KIOSK CREDIT CARD -175,000 0 -175,000 -63,828.35 -111,171.65 36.5% 424016 MOBILE APP REVENUE -200,000 0 -200,000 -100,524.22 -99,475.78 50.3% 424017 UNION STATION PARKING REV 0 0 0 -7,500.00 7,500.00 100.0% 424025 AMBULANCE SERVICES -2,800,000 0 -2,800,000 -714,141.66 -2,085,858.34 25.5% TOTAL GENERAL FUND REVENUES -4,010,000 0 -4,010,000 -1,056,737.65 -2,953,262.35 26.4% TOTAL CHARGES FOR SERVICES -4,010,000 0 -4,010,000 -1,056,737.65 -2,953,262.35 26.4% 43 CHARGES FOR SERVICES 10004 GENERAL FUND REVENUES 432010 FEES - COLLECTOR -95,000 0 -95,000 -35,134.93 -59,865.07 37.0% 432011 FEES - MUNICIPAL LIENS -30,000 0 -30,000 -6,700.00 -23,300.00 22.3% 432012 FEES - MVE SURCHARGES -12,000 0 -12,000 -4,120.00 -7,880.00 34.3% 432014 FEES - CEMETERY INTERMENTS -20,800 0 -20,800 -6,675.00 -14,125.00 32.1% 432016 FEES - POLICE OUT/DET ADMIN -60,000 0 -60,000 -13,324.70 -46,675.30 22.2% 432018 FEES - FIRE OUT/DET ADMIN -1,000 0 -1,000 -804.40 -195.60 80.4% 432020 FEES - LICENSE COMM ADMIN FE 0 0 0 -50.00 50.00 100.0% 432021 FEES - CITY CLERK - MISC -25,000 0 -25,000 -5,778.00 -19,222.00 23.1% 432022 FEES - CITY CLERK - COPIES/R -80,000 0 -80,000 -20,190.00 -59,810.00 25.2% 434035 TUITION - SVHS -9,078,820 0 -9,078,820 .00 -9,078,820.00 .0% 437009 DEPT REV - REGISTRAR OF VOTE -675 0 -675 -60.00 -615.00 8.9% 437011 DEPT REV - POLICE DEPT -10,000 0 -10,000 -5,321.75 -4,678.25 53.2% 437014 DEPT REV - CEMETERIES -1,000 0 -1,000 -390.00 -610.00 39.0% 437018 DEPT REV - BOARD OF HEALTH -15,000 0 -15,000 -4,100.00 -10,900.00 27.3% 437021 DEPT REV - BUILDING INSPECTI -42,500 0 -42,500 -42,500.00 .00 100.0% 437022 DEPT REV - HEARING OFC FEES -2,400 0 -2,400 -2,000.00 -400.00 83.3% 437026 DEPT REV - FIRE 0 0 0 -28.34 28.34 100.0% TOTAL GENERAL FUND REVENUES -9,474,195 0 -9,474,195 -147,177.12 -9,327,017.88 1.6% TOTAL CHARGES FOR SERVICES -9,474,195 0 -9,474,195 -147,177.12 -9,327,017.88 1.6% 44 LICENSES & PERMITS 10004 GENERAL FUND REVENUES CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND REVENUE Report generated: 10/13/2023 10:44 User: 1281cnar Program ID: glytdbud Page 3 FOR 2024 03 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL 441000 LIQUOR & OTHER COMMT LICENSE -160,000 0 -160,000 -195.00 -159,805.00 .1% 442010 LICENSE COMM - SHORT TERM FE 0 0 0 -805.00 805.00 100.0% 442020 CITY CLERK LICENSES -20,000 0 -20,000 -3,565.00 -16,435.00 17.8% 442030 FIREARM LICENSES -3,000 0 -3,000 -975.00 -2,025.00 32.5% 445010 PERMITS - HEALTH DEPT -70,000 0 -70,000 -8,900.00 -61,100.00 12.7% 445012 PERMITS - BURIALS -9,000 0 -9,000 -2,725.00 -6,275.00 30.3% 445020 PERMITS - POLICE DEPT -600 0 -600 -178.98 -421.02 29.8% 445031 PERMITS - BUILDING INSPECTOR -450,000 0 -450,000 -108,126.70 -341,873.30 24.0% 445032 PERMITS - PLUMBING INSPECTOR -85,000 0 -85,000 -18,875.00 -66,125.00 22.2% 445033 PERMITS - WIRE INSPECTOR -115,000 0 -115,000 -28,584.00 -86,416.00 24.9% 445034 PERMITS - WEIGHTS & MEASURES -75,000 0 -75,000 -10,678.00 -64,322.00 14.2% 445035 PERIODIC INSPECTION -20,000 0 -20,000 -1,000.00 -19,000.00 5.0% 445036 PERMITS - SIDEWALK SIGNS -6,000 0 -6,000 .00 -6,000.00 .0% 445040 PERMITS - GENERAL HIGHWAYS -25,000 0 -25,000 -9,645.00 -15,355.00 38.6% 445050 PERMITS - PLANNING DEPT -22,000 0 -22,000 -4,075.00 -17,925.00 18.5% 445060 PERMITS - FIRE DEPT -100,000 0 -100,000 -11,518.23 -88,481.77 11.5% TOTAL GENERAL FUND REVENUES -1,160,600 0 -1,160,600 -209,845.91 -950,754.09 18.1% TOTAL LICENSES & PERMITS -1,160,600 0 -1,160,600 -209,845.91 -950,754.09 18.1% 45 FEDERAL REVENUE 10004 GENERAL FUND REVENUES 458010 MEDICAID REIMB. SCHOOL -150,000 0 -150,000 -140.00 -149,860.00 .1% TOTAL GENERAL FUND REVENUES -150,000 0 -150,000 -140.00 -149,860.00 .1% TOTAL FEDERAL REVENUE -150,000 0 -150,000 -140.00 -149,860.00 .1% 46 STATE REVENUE 10004 GENERAL FUND REVENUES 461050 ABATE VETS, BLIND, SURV SPOU -101,554 0 -101,554 -11,922.00 -89,632.00 11.7% 461070 LIEU OF TAXES-STATE OWNED LA -161,730 0 -161,730 -40,389.00 -121,341.00 25.0% 462010 CHAPTER 70 SCHOOL AID -8,889,234 0 -8,889,234 -2,222,307.00 -6,666,927.00 25.0% CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND REVENUE Report generated: 10/13/2023 10:44 User: 1281cnar Program ID: glytdbud Page 4 FOR 2024 03 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL 462040 CHARTER SCHOOL AID -564,356 0 -564,356 -156,389.00 -407,967.00 27.7% 466020 VETERANS BENEFITS -223,550 0 -223,550 .00 -223,550.00 .0% 466035 UNRESTRICTED GENERAL AID -5,172,931 0 -5,172,931 -1,313,598.00 -3,859,333.00 25.4% 468000 OTHER STATE REVENUE -25,000 0 -25,000 -2,456.67 -22,543.33 9.8% 468001 MA AMBULANCE CPE -400,000 0 -400,000 .00 -400,000.00 .0% TOTAL GENERAL FUND REVENUES -15,538,355 0 -15,538,355 -3,747,061.67 -11,791,293.33 24.1% TOTAL STATE REVENUE -15,538,355 0 -15,538,355 -3,747,061.67 -11,791,293.33 24.1% 47 IG/ASSESS/FINES 10004 GENERAL FUND REVENUES 477010 PARKING TICKETS -475,000 0 -475,000 -73,965.00 -401,035.00 15.6% 477020 CMVI REIMB. RMV -35,000 0 -35,000 -8,237.80 -26,762.20 23.5% TOTAL GENERAL FUND REVENUES -510,000 0 -510,000 -82,202.80 -427,797.20 16.1% TOTAL IG/ASSESS/FINES -510,000 0 -510,000 -82,202.80 -427,797.20 16.1% 48 MISCELLANEOUS 10004 GENERAL FUND REVENUES 482000 INTEREST ON INVESTMENTS -165,002 0 -165,002 -423,319.99 258,317.99 256.6% 483010 SMITH CHARITIES INCOME -6,500 0 -6,500 .00 -6,500.00 .0% 484000 MISCELLANEOUS RECEIPTS 0 0 0 -6,191.46 6,191.46 100.0% 484001 OVER/UNDER RECEIPTS 0 0 0 1.38 -1.38 100.0% 484010 PVTA-5 COLLEGE REIMBURSEMENT -67,044 0 -67,044 .00 -67,044.00 .0% 484012 VET SERVICES REGIONAL ASSESS -195,760 0 -195,760 -198,205.00 2,445.00 101.2% 484013 IT SERVICE REGIONAL ASSESS -10,500 0 -10,500 .00 -10,500.00 .0% TOTAL GENERAL FUND REVENUES -444,806 0 -444,806 -627,715.07 182,909.07 141.1% TOTAL MISCELLANEOUS -444,806 0 -444,806 -627,715.07 182,909.07 141.1% GRAND TOTAL -112,110,348 0-112,110,348 -26,007,263.21 -86,103,084.79 23.2% ** END OF REPORT - Generated by Charlene Nardi ** CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND REVENUE Report generated: 10/13/2023 10:44 User: 1281cnar Program ID: glytdbud Page 5 REPORT OPTIONS Field # Total Page Break Sequence 1 10 Y N Sequence 2 9 Y N Sequence 3 11 Y N Sequence 4 0 N N Report title: FY2024 GENERAL FUND REVENUE 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: Y 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 DEPARTMENT DOE BUDGET CAT LOCATION CURR/GRANT GRADE Character Code Org Object Project Account type Revenue CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND REVENUE Report generated: 10/13/2023 10:44 User: 1281cnar Program ID: glytdbud Page 6 REPORT OPTIONS Account status Rollup Code