Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GF Revenue.123122
01/17/2023 11:35 |CITY OF NORTHAMPTON, MA - LIVE |P 1 1281cnar |FY23 GENERAL FUND REVENUES |glytdbud 2ND QUARTER FOR 2023 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,174,462 -10,928 -2,185,390 -960,598.64 -1,224,791.36 44.0% 412000 R.E. TAX REVENUE -70,307,590 150,125 -70,157,465 -33,792,067.79 -36,365,397.21 48.2% 414200 TAX TITLE REVENUE 0 0 0 -74,376.51 74,376.51 100.0% 415000 MOTOR VEHICLE EXCISE -2,313,962 -89,038 -2,403,000 -456,547.83 -1,946,452.17 19.0% 415010 ABATED MVE 0 0 0 -243.75 243.75 100.0% 416010 BOAT EXCISE -3,500 -150 -3,650 -3,071.17 -578.83 84.1% 416030 HOTEL/MOTEL TAX CH 145 -600,000 -74,500 -674,500 -526,034.63 -148,465.37 78.0% 416035 MEALS TAX, CHAPT. 64L, S.2A -550,000 -4,500 -554,500 -407,814.65 -146,685.35 73.5% 416036 ADULT MARIJUANA EXCISE CH64N -975,000 0 -975,000 -454,954.28 -520,045.72 46.7% 417010 INTEREST ON TAXES -150,000 -20,000 -170,000 -69,659.24 -100,340.76 41.0% 417030 INTEREST ON TAX TITLES -32,000 -11,300 -43,300 -18,184.95 -25,115.05 42.0% 417031 TAX TITLE ATTORNEY FEES 0 0 0 -8,251.91 8,251.91 100.0% 417040 TAX TITLE RELEASES -1,000 0 -1,000 -240.00 -760.00 24.0% 418010 PILOT-HOUSING AUTHORITY -27,000 7,000 -20,000 -29,929.76 9,929.76 149.6% 418011 PILOT-SMITH COLLEGE -127,000 19,000 -108,000 .00 -108,000.00 .0% 418012 PILOT-B'NAI ISRAEL SYNAGOGUE -4,600 0 -4,600 .00 -4,600.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 -11,000 4,000 -7,000 -19,388.35 12,388.35 277.0% 418016 PILOT-NONOTUCK COMM SCH -700 0 -700 -736.16 36.16 105.2% 418017 PILOT-SOLDIER ON -11,000 2,000 -9,000 .00 -9,000.00 .0% 418018 PILOT-LANDFILL SOLAR ARRAY -10,000 5,000 -5,000 -10,000.00 5,000.00 200.0% 418020 PILOT-MUSIC SCHOOL -3,500 0 -3,500 -3,207.60 -292.40 91.6% TOTAL GENERAL FUND REVENUES -77,303,464 -23,291 -77,326,755 -36,835,307.22 -40,491,447.78 47.6% TOTAL TAXES & EXCISES -77,303,464 -23,291 -77,326,755 -36,835,307.22 -40,491,447.78 47.6% 42 CHARGES FOR SERVICES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 424010 PARKING REVENUES -230,000 0 -230,000 -143,118.45 -86,881.55 62.2% 424011 PARKING LOT REVENUE -80,000 0 -80,000 -42,053.62 -37,946.38 52.6% 01/17/2023 11:35 |CITY OF NORTHAMPTON, MA - LIVE |P 2 1281cnar |FY23 GENERAL FUND REVENUES |glytdbud 2ND QUARTER FOR 2023 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 -221,535.75 -178,464.25 55.4% 424013 PARKING PASS REVENUE -125,000 0 -125,000 -98,431.50 -26,568.50 78.7% 424015 PRK KIOSK CREDIT CARD -175,000 0 -175,000 -97,134.38 -77,865.62 55.5% 424016 MOBILE APP REVENUE -200,000 0 -200,000 -101,623.35 -98,376.65 50.8% 424025 AMBULANCE SERVICES -2,465,266 450,000 -2,015,266 -1,592,833.89 -422,432.11 79.0% TOTAL GENERAL FUND REVENUES -3,675,266 450,000 -3,225,266 -2,296,730.94 -928,535.06 71.2% TOTAL CHARGES FOR SERVICES -3,675,266 450,000 -3,225,266 -2,296,730.94 -928,535.06 71.2% 43 CHARGES FOR SERVICES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 432010 FEES - COLLECTOR -90,000 -13,500 -103,500 -48,805.11 -54,694.89 47.2% 432011 FEES - MUNICIPAL LIENS -35,000 0 -35,000 -16,100.00 -18,900.00 46.0% 432012 FEES - MVE SURCHARGES -12,000 0 -12,000 -9,820.00 -2,180.00 81.8% 432014 FEES - CEMETERY INTERMENTS -16,000 -4,800 -20,800 -16,725.00 -4,075.00 80.4% 432016 FEES - POLICE OUT/DET ADMIN -50,000 -19,100 -69,100 -29,301.98 -39,798.02 42.4% 432018 FEES - FIRE OUT/DET ADMIN -1,000 0 -1,000 -1,419.60 419.60 142.0% 432020 FEES - LICENSE COMM ADMIN FE 0 0 0 -250.25 250.25 100.0% 432021 FEES - CITY CLERK - MISC -25,000 0 -25,000 -14,218.00 -10,782.00 56.9% 432022 FEES - CITY CLERK - COPIES/R -80,000 0 -80,000 -44,880.00 -35,120.00 56.1% 434035 TUITION - SVHS -8,518,594 0 -8,518,594 -2,177,731.76 -6,340,862.24 25.6% 437003 DEPT REV - TREASURER 0 0 0 -25.00 25.00 100.0% 437009 DEPT REV - REGISTRAR OF VOTE -675 0 -675 -755.00 80.00 111.9% 437011 DEPT REV - POLICE DEPT -8,000 0 -8,000 -9,950.00 1,950.00 124.4% 437014 DEPT REV - CEMETERIES -1,000 0 -1,000 -2,072.20 1,072.20 207.2% 437018 DEPT REV - BOARD OF HEALTH -15,000 0 -15,000 -7,750.00 -7,250.00 51.7% 437021 DEPT REV - BUILDING INSPECTI -42,500 0 -42,500 .00 -42,500.00 .0% 437022 DEPT REV - HEARING OFC FEES -2,400 0 -2,400 -1,625.00 -775.00 67.7% 437026 DEPT REV - FIRE 0 0 0 -226.72 226.72 100.0% TOTAL GENERAL FUND REVENUES -8,897,169 -37,400 -8,934,569 -2,381,655.62 -6,552,913.38 26.7% TOTAL CHARGES FOR SERVICES -8,897,169 -37,400 -8,934,569 -2,381,655.62 -6,552,913.38 26.7% 44 LICENSES & PERMITS _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 01/17/2023 11:35 |CITY OF NORTHAMPTON, MA - LIVE |P 3 1281cnar |FY23 GENERAL FUND REVENUES |glytdbud 2ND QUARTER FOR 2023 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 -169,078.00 9,078.00 105.7% 442010 LICENSE COMM - SHORT TERM FE 0 0 0 -1,636.00 1,636.00 100.0% 442020 CITY CLERK LICENSES -10,000 0 -10,000 -6,236.00 -3,764.00 62.4% 442030 FIREARM LICENSES -3,000 0 -3,000 -2,250.00 -750.00 75.0% 445010 PERMITS - HEALTH DEPT -60,000 0 -60,000 -32,535.00 -27,465.00 54.2% 445012 PERMITS - BURIALS -9,000 0 -9,000 -5,425.00 -3,575.00 60.3% 445020 PERMITS - POLICE DEPT -600 0 -600 -330.00 -270.00 55.0% 445031 PERMITS - BUILDING INSPECTOR -300,000 -25,500 -325,500 -316,000.58 -9,499.42 97.1% 445032 PERMITS - PLUMBING INSPECTOR -75,000 0 -75,000 -47,295.00 -27,705.00 63.1% 445033 PERMITS - WIRE INSPECTOR -100,000 0 -100,000 -65,613.06 -34,386.94 65.6% 445034 PERMITS - WEIGHTS & MEASURES -53,000 0 -53,000 -76,076.00 23,076.00 143.5% 445035 PERIODIC INSPECTION -30,000 0 -30,000 -1,900.00 -28,100.00 6.3% 445036 PERMITS - SIDEWALK SIGNS -5,000 -1,000 -6,000 -75.00 -5,925.00 1.3% 445040 PERMITS - GENERAL HIGHWAYS -25,000 0 -25,000 -13,217.50 -11,782.50 52.9% 445050 PERMITS - PLANNING DEPT -20,000 -2,000 -22,000 -11,568.30 -10,431.70 52.6% 445060 PERMITS - FIRE DEPT -75,000 -31,500 -106,500 -25,442.95 -81,057.05 23.9% TOTAL GENERAL FUND REVENUES -925,600 -60,000 -985,600 -774,678.39 -210,921.61 78.6% TOTAL LICENSES & PERMITS -925,600 -60,000 -985,600 -774,678.39 -210,921.61 78.6% 45 FEDERAL REVENUE _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 458010 MEDICAID REIMB. SCHOOL -80,000 -79,355 -159,355 -100,674.67 -58,680.33 63.2% TOTAL GENERAL FUND REVENUES -80,000 -79,355 -159,355 -100,674.67 -58,680.33 63.2% TOTAL FEDERAL REVENUE -80,000 -79,355 -159,355 -100,674.67 -58,680.33 63.2% 46 STATE REVENUE _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 461050 ABATE VETS, BLIND, SURV SPOU -110,043 0 -110,043 -24,342.00 -85,701.00 22.1% 461070 LIEU OF TAXES-STATE OWNED LA -113,666 -32,318 -145,984 -71,522.00 -74,462.00 49.0% 462010 CHAPTER 70 SCHOOL AID -8,638,404 -83,850 -8,722,254 -4,361,124.00 -4,361,130.00 50.0% 01/17/2023 11:35 |CITY OF NORTHAMPTON, MA - LIVE |P 4 1281cnar |FY23 GENERAL FUND REVENUES |glytdbud 2ND QUARTER FOR 2023 06 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ 462040 CHARTER SCHOOL AID -530,889 -111,372 -642,261 -292,296.00 -349,965.00 45.5% 466020 VETERANS BENEFITS -354,050 0 -354,050 -128,227.00 -225,823.00 36.2% 466035 UNRESTRICTED GENERAL AID -4,961,042 -130,426 -5,091,468 -2,539,805.00 -2,551,663.00 49.9% 468000 OTHER STATE REVENUE -25,000 0 -25,000 -9,181.00 -15,819.00 36.7% 468001 MA AMBULANCE CPE -300,000 -19,000 -319,000 .00 -319,000.00 .0% 468005 OPIOID SETTLEMENT 0 0 0 -239,024.44 239,024.44 100.0% 468010 RETIREMENT COLA REIMB. 0 0 0 -1,234.98 1,234.98 100.0% TOTAL GENERAL FUND REVENUES -15,033,094 -376,966 -15,410,060 -7,666,756.42 -7,743,303.58 49.8% TOTAL STATE REVENUE -15,033,094 -376,966 -15,410,060 -7,666,756.42 -7,743,303.58 49.8% 47 IG/ASSESS/FINES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 477010 PARKING TICKETS -550,000 25,000 -525,000 -258,013.16 -266,986.84 49.1% 477020 CMVI REIMB. RMV -40,000 10,000 -30,000 -19,429.75 -10,570.25 64.8% TOTAL GENERAL FUND REVENUES -590,000 35,000 -555,000 -277,442.91 -277,557.09 50.0% TOTAL IG/ASSESS/FINES -590,000 35,000 -555,000 -277,442.91 -277,557.09 50.0% 48 MISCELLANEOUS _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 482000 INTEREST ON INVESTMENTS -125,000 0 -125,000 -155,249.19 30,249.19 124.2% 483010 SMITH CHARITIES INCOME -6,400 0 -6,400 .00 -6,400.00 .0% 484000 MISCELLANEOUS RECEIPTS 0 0 0 -41,434.67 41,434.67 100.0% 484001 OVER/UNDER RECEIPTS 0 0 0 1.00 -1.00 100.0% 484010 PVTA-5 COLLEGE REIMBURSEMENT -67,044 0 -67,044 .00 -67,044.00 .0% 484012 VET SERVICES REGIONAL ASSESS -188,405 0 -188,405 -175,695.00 -12,710.00 93.3% 484013 IT SERVICE REGIONAL ASSESS -10,500 0 -10,500 .00 -10,500.00 .0% TOTAL GENERAL FUND REVENUES -397,349 0 -397,349 -372,377.86 -24,971.14 93.7% TOTAL MISCELLANEOUS -397,349 0 -397,349 -372,377.86 -24,971.14 93.7% GRAND TOTAL -106,901,942 -92,012-106,993,954 -50,705,624.03 -56,288,329.97 47.4% ** END OF REPORT - Generated by Charlene Nardi ** 01/17/2023 11:35 |CITY OF NORTHAMPTON, MA - LIVE |P 5 1281cnar |FY23 GENERAL FUND REVENUES |glytdbud 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: FY23 GENERAL FUND REVENUES 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: 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 01/17/2023 11:35 |CITY OF NORTHAMPTON, MA - LIVE |P 6 1281cnar |FY23 GENERAL FUND REVENUES |glytdbud 2ND QUARTER REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Account status Rollup Code