Loading...
GF Revenue.063022 08/15/2022 16:55 |CITY OF NORTHAMPTON, MA - LIVE |P 1 1281cnar |FY22 REVENUES - GENERAL FUND |glytdbud 4TH QUARTER FOR 2022 13 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 -1,674,464 -294,130 -1,968,594 -1,927,194.29 -41,399.71 97.9% 412000 R.E. TAX REVENUE -68,094,866 -43,387 -68,138,253 -67,624,881.77 -513,371.23 99.2% 412010 CLAUSE 41A R.E.PAYBACK 0 0 0 -49,613.14 49,613.14 100.0% 414200 TAX TITLE REVENUE 0 0 0 -377,064.89 377,064.89 100.0% 415000 MOTOR VEHICLE EXCISE -2,600,000 322,000 -2,278,000 -2,982,188.47 704,188.47 130.9% 415010 ABATED MVE 0 0 0 -1,137.30 1,137.30 100.0% 416010 BOAT EXCISE -4,000 500 -3,500 -4,520.39 1,020.39 129.2% 416030 HOTEL/MOTEL TAX CH 145 -250,000 0 -250,000 -843,069.92 593,069.92 337.2% 416035 MEALS TAX, CHAPT. 64L, S.2A -500,000 0 -500,000 -692,008.42 192,008.42 138.4% 416036 ADULT MARIJUANA EXCISE CH64N -1,300,000 142,376 -1,157,624 -1,150,577.19 -7,046.81 99.4% 417010 INTEREST ON TAXES -95,000 -90,000 -185,000 -175,346.86 -9,653.14 94.8% 417030 INTEREST ON TAX TITLES -28,000 0 -28,000 -57,386.33 29,386.33 205.0% 417031 TAX TITLE ATTORNEY FEES 0 0 0 -3,806.67 3,806.67 100.0% 417040 TAX TITLE RELEASES -1,000 0 -1,000 -5,430.00 4,430.00 543.0% 417050 INT/RELEASE/CH41A R.E. 0 0 0 -24,308.69 24,308.69 100.0% 418010 PILOT-HOUSING AUTHORITY -27,000 0 -27,000 -27,028.09 28.09 100.1% 418011 PILOT-SMITH COLLEGE -115,000 0 -115,000 -127,898.81 12,898.81 111.2% 418012 PILOT-B'NAI ISRAEL SYNAGOGUE -3,000 0 -3,000 -4,691.65 1,691.65 156.4% 418013 PILOT-US FISH & WILDLIFE -250 0 -250 -304.00 54.00 121.6% 418014 PILOT - EASTHAMPTON -800 0 -800 -975.01 175.01 121.9% 418015 PILOT-FAIR GROUNDS -5,000 0 -5,000 -11,313.82 6,313.82 226.3% 418016 PILOT-NONOTUCK COMM SCH -700 0 -700 -799.24 99.24 114.2% 418017 PILOT-SOLDIER ON -11,000 0 -11,000 -11,997.14 997.14 109.1% 418018 PILOT-LANDFILL SOLAR ARRAY -10,000 0 -10,000 -5,000.00 -5,000.00 50.0% 418020 PILOT-MUSIC SCHOOL -3,500 0 -3,500 -3,622.75 122.75 103.5% TOTAL GENERAL FUND REVENUES -74,723,580 37,359 -74,686,221 -76,112,164.84 1,425,943.84 101.9% TOTAL TAXES & EXCISES -74,723,580 37,359 -74,686,221 -76,112,164.84 1,425,943.84 101.9% 42 CHARGES FOR SERVICES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 08/15/2022 16:55 |CITY OF NORTHAMPTON, MA - LIVE |P 2 1281cnar |FY22 REVENUES - GENERAL FUND |glytdbud 4TH QUARTER FOR 2022 13 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ 424010 PARKING REVENUES -225,000 0 -225,000 -225,000.00 .00 100.0% 424011 PARKING LOT REVENUE -125,000 0 -125,000 -125,000.00 .00 100.0% 424012 PARKING GARAGE REVENUE -275,000 0 -275,000 -275,000.00 .00 100.0% 424013 PARKING PASS REVENUE -90,000 0 -90,000 -90,000.00 .00 100.0% 424015 PRK KIOSK CREDIT CARD -235,000 0 -235,000 -235,000.00 .00 100.0% 424016 MOBILE APP REVENUE -250,000 0 -250,000 -250,000.00 .00 100.0% 424025 AMBULANCE SERVICES -2,002,610 100,000 -1,902,610 -2,831,296.64 928,686.64 148.8% TOTAL GENERAL FUND REVENUES -3,202,610 100,000 -3,102,610 -4,031,296.64 928,686.64 129.9% TOTAL CHARGES FOR SERVICES -3,202,610 100,000 -3,102,610 -4,031,296.64 928,686.64 129.9% 43 CHARGES FOR SERVICES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 432010 FEES - COLLECTOR -60,000 -60,000 -120,000 -125,232.92 5,232.92 104.4% 432011 FEES - MUNICIPAL LIENS -35,000 0 -35,000 -45,350.00 10,350.00 129.6% 432012 FEES - MVE SURCHARGES -12,000 0 -12,000 -17,120.00 5,120.00 142.7% 432014 FEES - CEMETERY INTERMENTS -16,000 0 -16,000 -24,595.00 8,595.00 153.7% 432016 FEES - POLICE OUT/DET ADMIN -75,000 0 -75,000 -71,812.62 -3,187.38 95.8% 432018 FEES - FIRE OUT/DET ADMIN -1,000 0 -1,000 -2,548.00 1,548.00 254.8% 432020 FEES - LICENSE COMM ADMIN FE 0 0 0 -605.00 605.00 100.0% 432021 FEES - CITY CLERK - MISC -25,000 0 -25,000 -38,235.50 13,235.50 152.9% 432022 FEES - CITY CLERK - COPIES/R -80,000 0 -80,000 -95,445.00 15,445.00 119.3% 432023 FEES - TREE WARDEN -20,000 0 -20,000 .00 -20,000.00 .0% 434035 TUITION - SVHS -7,761,032 0 -7,761,032 -7,761,032.00 .00 100.0% 437003 DEPT REV - TREASURER 0 0 0 -75.00 75.00 100.0% 437009 DEPT REV - REGISTRAR OF VOTE -675 0 -675 -930.00 255.00 137.8% 437011 DEPT REV - POLICE DEPT -12,000 0 -12,000 -20,527.50 8,527.50 171.1% 437012 DEPT REV - GENERAL HIGHWAYS -10,000 0 -10,000 .00 -10,000.00 .0% 437014 DEPT REV - CEMETERIES -2,500 0 -2,500 -2,533.40 33.40 101.3% 437016 DEPT REV - POLICE AUCTIONS -1,000 0 -1,000 -7,730.55 6,730.55 773.1% 437018 DEPT REV - BOARD OF HEALTH -12,000 0 -12,000 -21,900.00 9,900.00 182.5% 437021 DEPT REV - BUILDING INSPECTI -43,000 0 -43,000 -44,150.00 1,150.00 102.7% 437022 DEPT REV - HEARING OFC FEES -2,400 0 -2,400 -2,437.50 37.50 101.6% 437026 DEPT REV - FIRE 0 0 0 -413.36 413.36 100.0% TOTAL GENERAL FUND REVENUES -8,168,607 -60,000 -8,228,607 -8,282,673.35 54,066.35 100.7% TOTAL CHARGES FOR SERVICES -8,168,607 -60,000 -8,228,607 -8,282,673.35 54,066.35 100.7% 44 LICENSES & PERMITS _________________________________________ 08/15/2022 16:55 |CITY OF NORTHAMPTON, MA - LIVE |P 3 1281cnar |FY22 REVENUES - GENERAL FUND |glytdbud 4TH QUARTER FOR 2022 13 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 441000 LIQUOR & OTHER COMMT LICENSE -175,000 0 -175,000 -180,479.00 5,479.00 103.1% 442010 LICENSE COMM - SHORT TERM FE 0 0 0 -3,526.00 3,526.00 100.0% 442020 CITY CLERK LICENSES -15,000 0 -15,000 -26,390.00 11,390.00 175.9% 442030 FIREARM LICENSES -3,000 0 -3,000 -3,837.50 837.50 127.9% 445010 PERMITS - HEALTH DEPT -60,000 0 -60,000 -86,295.00 26,295.00 143.8% 445012 PERMITS - BURIALS -9,000 0 -9,000 -11,475.00 2,475.00 127.5% 445020 PERMITS - POLICE DEPT -950 0 -950 -660.00 -290.00 69.5% 445031 PERMITS - BUILDING INSPECTOR -370,000 -2,000 -372,000 -390,077.63 18,077.63 104.9% 445032 PERMITS - PLUMBING INSPECTOR -75,000 0 -75,000 -84,510.00 9,510.00 112.7% 445033 PERMITS - WIRE INSPECTOR -100,000 0 -100,000 -121,323.46 21,323.46 121.3% 445034 PERMITS - WEIGHTS & MEASURES -55,000 0 -55,000 -93,551.00 38,551.00 170.1% 445035 PERIODIC INSPECTION -35,000 0 -35,000 -21,300.00 -13,700.00 60.9% 445036 PERMITS - SIDEWALK SIGNS -5,000 0 -5,000 -8,512.50 3,512.50 170.3% 445040 PERMITS - GENERAL HIGHWAYS -31,000 0 -31,000 -33,152.25 2,152.25 106.9% 445050 PERMITS - PLANNING DEPT -25,000 0 -25,000 -25,433.50 433.50 101.7% 445060 PERMITS - FIRE DEPT -70,000 0 -70,000 -110,606.89 40,606.89 158.0% TOTAL GENERAL FUND REVENUES -1,028,950 -2,000 -1,030,950 -1,201,129.73 170,179.73 116.5% TOTAL LICENSES & PERMITS -1,028,950 -2,000 -1,030,950 -1,201,129.73 170,179.73 116.5% 45 FEDERAL REVENUE _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 458010 MEDICAID REIMB. SCHOOL -80,000 0 -80,000 -199,202.14 119,202.14 249.0% TOTAL GENERAL FUND REVENUES -80,000 0 -80,000 -199,202.14 119,202.14 249.0% TOTAL FEDERAL REVENUE -80,000 0 -80,000 -199,202.14 119,202.14 249.0% 46 STATE REVENUE _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 08/15/2022 16:55 |CITY OF NORTHAMPTON, MA - LIVE |P 4 1281cnar |FY22 REVENUES - GENERAL FUND |glytdbud 4TH QUARTER FOR 2022 13 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ 461050 ABATE VETS, BLIND, SURV SPOU -108,671 0 -108,671 -219,479.00 110,808.00 202.0% 461070 LIEU OF TAXES-STATE OWNED LA -107,230 -6,499 -113,729 -113,729.00 .00 100.0% 462010 CHAPTER 70 SCHOOL AID -8,554,554 0 -8,554,554 -8,554,554.00 .00 100.0% 462040 CHARTER SCHOOL AID -173,077 -54,052 -227,129 -401,964.00 174,835.00 177.0% 466020 VETERANS BENEFITS -365,312 0 -365,312 -289,282.00 -76,030.00 79.2% 466035 UNRESTRICTED GENERAL AID -4,830,615 0 -4,830,615 -4,830,615.00 .00 100.0% 468000 OTHER STATE REVENUE -25,000 0 -25,000 -66,230.00 41,230.00 264.9% 468001 MA AMBULANCE CPE -195,000 -10,000 -205,000 -417,994.00 212,994.00 203.9% 468010 RETIREMENT COLA REIMB. -3,400 0 -3,400 -1,370.13 -2,029.87 40.3% TOTAL GENERAL FUND REVENUES -14,362,859 -70,551 -14,433,410 -14,895,217.13 461,807.13 103.2% TOTAL STATE REVENUE -14,362,859 -70,551 -14,433,410 -14,895,217.13 461,807.13 103.2% 47 IG/ASSESS/FINES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 477010 PARKING TICKETS -450,000 0 -450,000 -651,890.86 201,890.86 144.9% 477020 CMVI REIMB. RMV -55,000 0 -55,000 -39,537.67 -15,462.33 71.9% TOTAL GENERAL FUND REVENUES -505,000 0 -505,000 -691,428.53 186,428.53 136.9% TOTAL IG/ASSESS/FINES -505,000 0 -505,000 -691,428.53 186,428.53 136.9% 48 MISCELLANEOUS _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 482000 INTEREST ON INVESTMENTS -125,000 0 -125,000 -205,383.05 80,383.05 164.3% 483010 SMITH CHARITIES INCOME -6,500 0 -6,500 -6,407.43 -92.57 98.6% 484000 MISCELLANEOUS RECEIPTS 0 0 0 -272,554.98 272,554.98 100.0% 484001 OVER/UNDER RECEIPTS 0 0 0 93.37 -93.37 100.0% 484010 PVTA-5 COLLEGE REIMBURSEMENT -75,000 0 -75,000 -67,044.00 -7,956.00 89.4% 484012 VET SERVICES REGIONAL ASSESS -187,387 0 -187,387 -187,388.00 1.00 100.0% 484013 IT SERVICE REGIONAL ASSESS -11,000 0 -11,000 -11,280.00 280.00 102.5% TOTAL GENERAL FUND REVENUES -404,887 0 -404,887 -749,964.09 345,077.09 185.2% 08/15/2022 16:55 |CITY OF NORTHAMPTON, MA - LIVE |P 5 1281cnar |FY22 REVENUES - GENERAL FUND |glytdbud 4TH QUARTER FOR 2022 13 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ TOTAL MISCELLANEOUS -404,887 0 -404,887 -749,964.09 345,077.09 185.2% GRAND TOTAL -102,476,493 4,808-102,471,685-106,163,076.45 3,691,391.45 103.6% ** END OF REPORT - Generated by Charlene Nardi ** 08/15/2022 16:55 |CITY OF NORTHAMPTON, MA - LIVE |P 6 1281cnar |FY22 REVENUES - GENERAL FUND |glytdbud 4TH 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: FY22 REVENUES - GENERAL FUND Includes accounts exceeding 0% of budget. Print totals only: Y Year/Period: 2022/13 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 08/15/2022 16:55 |CITY OF NORTHAMPTON, MA - LIVE |P 7 1281cnar |FY22 REVENUES - GENERAL FUND |glytdbud 4TH QUARTER REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Account status Rollup Code