Loading...
GF Revenue.123023CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND REVENUE Report generated: 01/23/2024 09:52 User: 1281cnar Program ID: glytdbud Page 1 2ND QUARTER FOR 2024 06 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 330,643 -1,932,659 -872,983.63 -1,059,675.71 45.2% 412000 R.E. TAX REVENUE -73,180,090 -402,958 -73,583,048 -34,231,329.10 -39,351,718.63 46.5% 414200 TAX TITLE REVENUE 0 0 0 -150,933.32 150,933.32 100.0% 415000 MOTOR VEHICLE EXCISE -2,800,000 200,317 -2,599,683 -499,289.08 -2,100,393.99 19.2% 415010 ABATED MVE 0 0 0 -340.83 340.83 100.0% 416010 BOAT EXCISE -3,650 369 -3,281 -5,395.63 2,114.63 164.5% 416030 HOTEL/MOTEL TAX CH 145 -750,000 -30,000 -780,000 -688,169.85 -91,830.15 88.2% 416035 MEALS TAX, CHAPT. 64L, S.2A -650,000 0 -650,000 -407,138.69 -242,861.31 62.6% 416036 ADULT MARIJUANA EXCISE CH64N -800,000 55,605 -744,395 -437,909.03 -306,485.97 58.8% 417010 INTEREST ON TAXES -150,000 0 -150,000 -74,727.06 -75,272.94 49.8% 417030 INTEREST ON TAX TITLES -36,000 0 -36,000 -36,820.60 820.60 102.3% 417031 TAX TITLE ATTORNEY FEES 0 0 0 -8,756.73 8,756.73 100.0% 417040 TAX TITLE RELEASES -1,000 0 -1,000 -1,761.78 761.78 176.2% 418010 PILOT-HOUSING AUTHORITY -27,000 0 -27,000 -36,983.80 9,983.80 137.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 -766.72 66.72 109.5% 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 153,976 -80,668,416 -37,458,305.85 -43,210,110.29 46.4% TOTAL TAXES & EXCISES -80,822,392 153,976 -80,668,416 -37,458,305.85 -43,210,110.29 46.4% 42 CHARGES FOR SERVICES 10004 GENERAL FUND REVENUES 424010 PARKING REVENUES -230,000 0 -230,000 -123,430.72 -106,569.28 53.7% 424011 PARKING LOT REVENUE -80,000 0 -80,000 -43,361.97 -36,638.03 54.2% CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND REVENUE Report generated: 01/23/2024 09:52 User: 1281cnar Program ID: glytdbud Page 2 2ND QUARTER FOR 2024 06 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL 424012 PARKING GARAGE REVENUE -400,000 0 -400,000 -181,054.29 -218,945.71 45.3% 424013 PARKING PASS REVENUE -125,000 0 -125,000 -70,103.58 -54,896.42 56.1% 424015 PRK KIOSK CREDIT CARD -175,000 0 -175,000 -141,009.55 -33,990.45 80.6% 424016 MOBILE APP REVENUE -200,000 0 -200,000 -309,263.30 109,263.30 154.6% 424017 UNION STATION PARKING REV 0 0 0 -15,000.00 15,000.00 100.0% 424025 AMBULANCE SERVICES -2,800,000 0 -2,800,000 -1,668,830.95 -1,131,169.05 59.6% TOTAL GENERAL FUND REVENUES -4,010,000 0 -4,010,000 -2,552,054.36 -1,457,945.64 63.6% TOTAL CHARGES FOR SERVICES -4,010,000 0 -4,010,000 -2,552,054.36 -1,457,945.64 63.6% 43 CHARGES FOR SERVICES 10004 GENERAL FUND REVENUES 432010 FEES - COLLECTOR -95,000 0 -95,000 -53,835.66 -41,164.34 56.7% 432011 FEES - MUNICIPAL LIENS -30,000 0 -30,000 -12,900.00 -17,100.00 43.0% 432012 FEES - MVE SURCHARGES -12,000 0 -12,000 -7,280.00 -4,720.00 60.7% 432013 FEES - LEGAL NOT REIMB 0 0 0 -249.10 249.10 100.0% 432014 FEES - CEMETERY INTERMENTS -20,800 -400 -21,200 -16,200.00 -5,000.00 76.4% 432016 FEES - POLICE OUT/DET ADMIN -60,000 0 -60,000 -28,839.39 -31,160.61 48.1% 432018 FEES - FIRE OUT/DET ADMIN -1,000 0 -1,000 -1,752.40 752.40 175.2% 432020 FEES - LICENSE COMM ADMIN FE 0 0 0 -250.00 250.00 100.0% 432021 FEES - CITY CLERK - MISC -25,000 0 -25,000 -12,183.00 -12,817.00 48.7% 432022 FEES - CITY CLERK - COPIES/R -80,000 0 -80,000 -39,780.00 -40,220.00 49.7% 434035 TUITION - SVHS -9,078,820 0 -9,078,820 -2,843,542.31 -6,235,277.69 31.3% 437003 DEPT REV - TREASURER 0 0 0 -25.00 25.00 100.0% 437009 DEPT REV - REGISTRAR OF VOTE -675 0 -675 -90.00 -585.00 13.3% 437011 DEPT REV - POLICE DEPT -10,000 0 -10,000 -8,741.75 -1,258.25 87.4% 437014 DEPT REV - CEMETERIES -1,000 0 -1,000 -2,591.80 1,591.80 259.2% 437018 DEPT REV - BOARD OF HEALTH -15,000 0 -15,000 -15,350.00 350.00 102.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 -127.53 127.53 100.0% TOTAL GENERAL FUND REVENUES -9,474,195 -400 -9,474,595 -3,088,237.94 -6,386,357.06 32.6% TOTAL CHARGES FOR SERVICES -9,474,195 -400 -9,474,595 -3,088,237.94 -6,386,357.06 32.6% 44 LICENSES & PERMITS 10004 GENERAL FUND REVENUES CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND REVENUE Report generated: 01/23/2024 09:52 User: 1281cnar Program ID: glytdbud Page 3 2ND QUARTER FOR 2024 06 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 -165,165.00 5,165.00 103.2% 442010 LICENSE COMM - SHORT TERM FE 0 0 0 -1,293.00 1,293.00 100.0% 442020 CITY CLERK LICENSES -20,000 0 -20,000 -5,175.00 -14,825.00 25.9% 442030 FIREARM LICENSES -3,000 0 -3,000 -2,337.50 -662.50 77.9% 445010 PERMITS - HEALTH DEPT -70,000 0 -70,000 -67,535.00 -2,465.00 96.5% 445012 PERMITS - BURIALS -9,000 0 -9,000 -5,825.00 -3,175.00 64.7% 445020 PERMITS - POLICE DEPT -600 0 -600 -388.98 -211.02 64.8% 445031 PERMITS - BUILDING INSPECTOR -450,000 -15,000 -465,000 -350,169.38 -114,830.62 75.3% 445032 PERMITS - PLUMBING INSPECTOR -85,000 0 -85,000 -44,933.00 -40,067.00 52.9% 445033 PERMITS - WIRE INSPECTOR -115,000 0 -115,000 -68,310.28 -46,689.72 59.4% 445034 PERMITS - WEIGHTS & MEASURES -75,000 0 -75,000 -28,762.00 -46,238.00 38.3% 445035 PERIODIC INSPECTION -20,000 0 -20,000 -39,200.00 19,200.00 196.0% 445036 PERMITS - SIDEWALK SIGNS -6,000 0 -6,000 .00 -6,000.00 .0% 445040 PERMITS - GENERAL HIGHWAYS -25,000 0 -25,000 -17,280.00 -7,720.00 69.1% 445050 PERMITS - PLANNING DEPT -22,000 0 -22,000 -14,382.90 -7,617.10 65.4% 445060 PERMITS - FIRE DEPT -100,000 0 -100,000 -23,791.37 -76,208.63 23.8% TOTAL GENERAL FUND REVENUES -1,160,600 -15,000 -1,175,600 -834,548.41 -341,051.59 71.0% TOTAL LICENSES & PERMITS -1,160,600 -15,000 -1,175,600 -834,548.41 -341,051.59 71.0% 45 FEDERAL REVENUE 10004 GENERAL FUND REVENUES 458010 MEDICAID REIMB. SCHOOL -150,000 -11,000 -161,000 -105,046.91 -55,953.09 65.2% TOTAL GENERAL FUND REVENUES -150,000 -11,000 -161,000 -105,046.91 -55,953.09 65.2% TOTAL FEDERAL REVENUE -150,000 -11,000 -161,000 -105,046.91 -55,953.09 65.2% 46 STATE REVENUE 10004 GENERAL FUND REVENUES 461050 ABATE VETS, BLIND, SURV SPOU -101,554 0 -101,554 -23,844.00 -77,710.00 23.5% 461070 LIEU OF TAXES-STATE OWNED LA -161,730 0 -161,730 -80,778.00 -80,952.00 49.9% CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND REVENUE Report generated: 01/23/2024 09:52 User: 1281cnar Program ID: glytdbud Page 4 2ND QUARTER FOR 2024 06 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL 462010 CHAPTER 70 SCHOOL AID -8,889,234 0 -8,889,234 -4,444,614.00 -4,444,620.00 50.0% 462040 CHARTER SCHOOL AID -564,356 -63,540 -627,896 -313,476.00 -314,420.00 49.9% 466020 VETERANS BENEFITS -223,550 0 -223,550 -103,937.92 -119,612.08 46.5% 466035 UNRESTRICTED GENERAL AID -5,172,931 -81,464 -5,254,395 -2,627,196.00 -2,627,199.00 50.0% 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% 468010 RETIREMENT COLA REIMB. 0 0 0 -1,234.98 1,234.98 100.0% TOTAL GENERAL FUND REVENUES -15,538,355 -145,004 -15,683,359 -7,597,537.57 -8,085,821.43 48.4% TOTAL STATE REVENUE -15,538,355 -145,004 -15,683,359 -7,597,537.57 -8,085,821.43 48.4% 47 IG/ASSESS/FINES 10004 GENERAL FUND REVENUES 477010 PARKING TICKETS -475,000 -5,000 -480,000 -382,025.97 -97,974.03 79.6% 477020 CMVI REIMB. RMV -35,000 -5,000 -40,000 -22,802.25 -17,197.75 57.0% TOTAL GENERAL FUND REVENUES -510,000 -10,000 -520,000 -404,828.22 -115,171.78 77.9% TOTAL IG/ASSESS/FINES -510,000 -10,000 -520,000 -404,828.22 -115,171.78 77.9% 48 MISCELLANEOUS 10004 GENERAL FUND REVENUES 481000 SALE OF INVENTORY 0 0 0 -6,600.00 6,600.00 100.0% 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 -12,365.14 12,365.14 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 -200,923.00 5,163.00 102.6% 484013 IT SERVICE REGIONAL ASSESS -10,500 0 -10,500 .00 -10,500.00 .0% TOTAL GENERAL FUND REVENUES -444,806 0 -444,806 -643,206.75 198,400.75 144.6% TOTAL MISCELLANEOUS -444,806 0 -444,806 -643,206.75 198,400.75 144.6% GRAND TOTAL -112,110,348 -27,428-112,137,776 -52,683,766.01 -59,454,010.13 47.0% CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND REVENUE Report generated: 01/23/2024 09:52 User: 1281cnar Program ID: glytdbud Page 5 2ND QUARTER FOR 2024 06 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL ** END OF REPORT - Generated by Charlene Nardi ** CITY OF NORTHAMPTON, MA - LIVE FY2024 GENERAL FUND REVENUE Report generated: 01/23/2024 09:52 User: 1281cnar Program ID: glytdbud Page 6 2ND QUARTER 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/ 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: 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: 01/23/2024 09:52 User: 1281cnar Program ID: glytdbud Page 7 2ND QUARTER REPORT OPTIONS Account status Rollup Code