Loading...
GF Revenue 10/31/2022 10:33 |CITY OF NORTHAMPTON, MA - LIVE |P 1 1281rcro |FY23 REVENUES GENERAL FUND |glytdbud 1ST QUARTER FOR 2023 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,174,462 0 -2,174,462 -512,399.41 -1,662,062.59 23.6% 412000 R.E. TAX REVENUE -70,307,590 0 -70,307,590 -17,251,135.46 -53,056,454.54 24.5% 414200 TAX TITLE REVENUE 0 0 0 -55,709.16 55,709.16 100.0% 415000 MOTOR VEHICLE EXCISE -2,313,962 0 -2,313,962 -295,910.50 -2,018,051.50 12.8% 415010 ABATED MVE 0 0 0 -243.75 243.75 100.0% 416010 BOAT EXCISE -3,500 0 -3,500 20.96 -3,520.96 -.6% 416030 HOTEL/MOTEL TAX CH 145 -600,000 0 -600,000 -201,938.23 -398,061.77 33.7% 416035 MEALS TAX, CHAPT. 64L, S.2A -550,000 0 -550,000 -203,302.94 -346,697.06 37.0% 416036 ADULT MARIJUANA EXCISE CH64N -975,000 0 -975,000 -245,832.07 -729,167.93 25.2% 417010 INTEREST ON TAXES -150,000 0 -150,000 -30,160.87 -119,839.13 20.1% 417030 INTEREST ON TAX TITLES -32,000 0 -32,000 -15,413.09 -16,586.91 48.2% 417031 TAX TITLE ATTORNEY FEES 0 0 0 -284.53 284.53 100.0% 417040 TAX TITLE RELEASES -1,000 0 -1,000 -240.00 -760.00 24.0% 418010 PILOT-HOUSING AUTHORITY -27,000 0 -27,000 .00 -27,000.00 .0% 418011 PILOT-SMITH COLLEGE -127,000 0 -127,000 .00 -127,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 0 -11,000 .00 -11,000.00 .0% 418016 PILOT-NONOTUCK COMM SCH -700 0 -700 .00 -700.00 .0% 418017 PILOT-SOLDIER ON -11,000 0 -11,000 .00 -11,000.00 .0% 418018 PILOT-LANDFILL SOLAR ARRAY -10,000 0 -10,000 .00 -10,000.00 .0% 418020 PILOT-MUSIC SCHOOL -3,500 0 -3,500 .00 -3,500.00 .0% TOTAL GENERAL FUND REVENUES -77,303,464 0 -77,303,464 -18,812,549.05 -58,490,914.95 24.3% TOTAL TAXES & EXCISES -77,303,464 0 -77,303,464 -18,812,549.05 -58,490,914.95 24.3% 42 CHARGES FOR SERVICES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 424010 PARKING REVENUES -230,000 0 -230,000 -66,853.10 -163,146.90 29.1% 424011 PARKING LOT REVENUE -80,000 0 -80,000 -26,800.91 -53,199.09 33.5% 10/31/2022 10:33 |CITY OF NORTHAMPTON, MA - LIVE |P 2 1281rcro |FY23 REVENUES GENERAL FUND |glytdbud 1ST QUARTER FOR 2023 03 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 -100,035.25 -299,964.75 25.0% 424013 PARKING PASS REVENUE -125,000 0 -125,000 -51,958.60 -73,041.40 41.6% 424015 PRK KIOSK CREDIT CARD -175,000 0 -175,000 -49,017.57 -125,982.43 28.0% 424016 MOBILE APP REVENUE -200,000 0 -200,000 -51,821.82 -148,178.18 25.9% 424025 AMBULANCE SERVICES -2,465,266 0 -2,465,266 -795,133.89 -1,670,132.11 32.3% TOTAL GENERAL FUND REVENUES -3,675,266 0 -3,675,266 -1,141,621.14 -2,533,644.86 31.1% TOTAL CHARGES FOR SERVICES -3,675,266 0 -3,675,266 -1,141,621.14 -2,533,644.86 31.1% 43 CHARGES FOR SERVICES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 432010 FEES - COLLECTOR -90,000 0 -90,000 -34,148.58 -55,851.42 37.9% 432011 FEES - MUNICIPAL LIENS -35,000 0 -35,000 -8,700.00 -26,300.00 24.9% 432012 FEES - MVE SURCHARGES -12,000 0 -12,000 -5,040.00 -6,960.00 42.0% 432014 FEES - CEMETERY INTERMENTS -16,000 0 -16,000 -5,250.00 -10,750.00 32.8% 432016 FEES - POLICE OUT/DET ADMIN -50,000 0 -50,000 -10,521.15 -39,478.85 21.0% 432018 FEES - FIRE OUT/DET ADMIN -1,000 0 -1,000 -548.80 -451.20 54.9% 432020 FEES - LICENSE COMM ADMIN FE 0 0 0 -75.25 75.25 100.0% 432021 FEES - CITY CLERK - MISC -25,000 0 -25,000 -4,992.00 -20,008.00 20.0% 432022 FEES - CITY CLERK - COPIES/R -80,000 0 -80,000 -25,140.00 -54,860.00 31.4% 434035 TUITION - SVHS -8,518,594 0 -8,518,594 .00 -8,518,594.00 .0% 437009 DEPT REV - REGISTRAR OF VOTE -675 0 -675 -255.00 -420.00 37.8% 437011 DEPT REV - POLICE DEPT -8,000 0 -8,000 -2,645.00 -5,355.00 33.1% 437014 DEPT REV - CEMETERIES -1,000 0 -1,000 -520.00 -480.00 52.0% 437018 DEPT REV - BOARD OF HEALTH -15,000 0 -15,000 -5,850.00 -9,150.00 39.0% 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 .00 -2,400.00 .0% 437026 DEPT REV - FIRE 0 0 0 -28.34 28.34 100.0% TOTAL GENERAL FUND REVENUES -8,897,169 0 -8,897,169 -103,714.12 -8,793,454.88 1.2% TOTAL CHARGES FOR SERVICES -8,897,169 0 -8,897,169 -103,714.12 -8,793,454.88 1.2% 44 LICENSES & PERMITS _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 10/31/2022 10:33 |CITY OF NORTHAMPTON, MA - LIVE |P 3 1281rcro |FY23 REVENUES GENERAL FUND |glytdbud 1ST QUARTER FOR 2023 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 -80.00 -159,920.00 .1% 442010 LICENSE COMM - SHORT TERM FE 0 0 0 -1,026.00 1,026.00 100.0% 442020 CITY CLERK LICENSES -10,000 0 -10,000 -4,451.00 -5,549.00 44.5% 442030 FIREARM LICENSES -3,000 0 -3,000 -1,062.50 -1,937.50 35.4% 445010 PERMITS - HEALTH DEPT -60,000 0 -60,000 -6,730.00 -53,270.00 11.2% 445012 PERMITS - BURIALS -9,000 0 -9,000 -2,875.00 -6,125.00 31.9% 445020 PERMITS - POLICE DEPT -600 0 -600 -200.00 -400.00 33.3% 445031 PERMITS - BUILDING INSPECTOR -300,000 0 -300,000 -179,822.20 -120,177.80 59.9% 445032 PERMITS - PLUMBING INSPECTOR -75,000 0 -75,000 -20,240.00 -54,760.00 27.0% 445033 PERMITS - WIRE INSPECTOR -100,000 0 -100,000 -30,998.56 -69,001.44 31.0% 445034 PERMITS - WEIGHTS & MEASURES -53,000 0 -53,000 -45,258.00 -7,742.00 85.4% 445035 PERIODIC INSPECTION -30,000 0 -30,000 -1,300.00 -28,700.00 4.3% 445036 PERMITS - SIDEWALK SIGNS -5,000 0 -5,000 -75.00 -4,925.00 1.5% 445040 PERMITS - GENERAL HIGHWAYS -25,000 0 -25,000 -7,542.50 -17,457.50 30.2% 445050 PERMITS - PLANNING DEPT -20,000 0 -20,000 -8,618.30 -11,381.70 43.1% 445060 PERMITS - FIRE DEPT -75,000 0 -75,000 -15,729.07 -59,270.93 21.0% TOTAL GENERAL FUND REVENUES -925,600 0 -925,600 -326,008.13 -599,591.87 35.2% TOTAL LICENSES & PERMITS -925,600 0 -925,600 -326,008.13 -599,591.87 35.2% 45 FEDERAL REVENUE _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 458010 MEDICAID REIMB. SCHOOL -80,000 0 -80,000 -170.00 -79,830.00 .2% TOTAL GENERAL FUND REVENUES -80,000 0 -80,000 -170.00 -79,830.00 .2% TOTAL FEDERAL REVENUE -80,000 0 -80,000 -170.00 -79,830.00 .2% 46 STATE REVENUE _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 461050 ABATE VETS, BLIND, SURV SPOU -110,043 0 -110,043 -12,171.00 -97,872.00 11.1% 461070 LIEU OF TAXES-STATE OWNED LA -113,666 0 -113,666 -34,292.00 -79,374.00 30.2% 462010 CHAPTER 70 SCHOOL AID -8,638,404 0 -8,638,404 -2,180,562.00 -6,457,842.00 25.2% 10/31/2022 10:33 |CITY OF NORTHAMPTON, MA - LIVE |P 4 1281rcro |FY23 REVENUES GENERAL FUND |glytdbud 1ST QUARTER FOR 2023 03 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ 462040 CHARTER SCHOOL AID -530,889 0 -530,889 -158,996.00 -371,893.00 29.9% 466020 VETERANS BENEFITS -354,050 0 -354,050 -69,915.00 -284,135.00 19.7% 466035 UNRESTRICTED GENERAL AID -4,961,042 0 -4,961,042 -1,263,974.00 -3,697,068.00 25.5% 468000 OTHER STATE REVENUE -25,000 0 -25,000 -9,181.00 -15,819.00 36.7% 468001 MA AMBULANCE CPE -300,000 0 -300,000 .00 -300,000.00 .0% 468005 OPIOID SETTLEMENT 0 0 0 -39,479.49 39,479.49 100.0% TOTAL GENERAL FUND REVENUES -15,033,094 0 -15,033,094 -3,768,570.49 -11,264,523.51 25.1% TOTAL STATE REVENUE -15,033,094 0 -15,033,094 -3,768,570.49 -11,264,523.51 25.1% 47 IG/ASSESS/FINES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 477010 PARKING TICKETS -550,000 0 -550,000 -153,468.16 -396,531.84 27.9% 477020 CMVI REIMB. RMV -40,000 0 -40,000 -9,191.13 -30,808.87 23.0% TOTAL GENERAL FUND REVENUES -590,000 0 -590,000 -162,659.29 -427,340.71 27.6% TOTAL IG/ASSESS/FINES -590,000 0 -590,000 -162,659.29 -427,340.71 27.6% 48 MISCELLANEOUS _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 482000 INTEREST ON INVESTMENTS -125,000 0 -125,000 -49,700.08 -75,299.92 39.8% 483010 SMITH CHARITIES INCOME -6,400 0 -6,400 .00 -6,400.00 .0% 484000 MISCELLANEOUS RECEIPTS 0 0 0 -34,759.06 34,759.06 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 .00 -188,405.00 .0% 484013 IT SERVICE REGIONAL ASSESS -10,500 0 -10,500 .00 -10,500.00 .0% TOTAL GENERAL FUND REVENUES -397,349 0 -397,349 -84,459.14 -312,889.86 21.3% TOTAL MISCELLANEOUS -397,349 0 -397,349 -84,459.14 -312,889.86 21.3% GRAND TOTAL -106,901,942 0-106,901,942 -24,399,751.36 -82,502,190.64 22.8% ** END OF REPORT - Generated by Ryan Crowther ** 10/31/2022 10:33 |CITY OF NORTHAMPTON, MA - LIVE |P 5 1281rcro |FY23 REVENUES GENERAL FUND |glytdbud 1ST 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 REVENUES GENERAL FUND Includes accounts exceeding 0% of budget. Print totals only: Y Year/Period: 2023/ 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: 2023/ 1 To Yr/Per: 2023/ 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 10/31/2022 10:33 |CITY OF NORTHAMPTON, MA - LIVE |P 6 1281rcro |FY23 REVENUES GENERAL FUND |glytdbud 1ST QUARTER REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Account status Rollup Code