Loading...
GF Revenue.093021 10/18/2021 14:24 |CITY OF NORTHAMPTON, MA - LIVE |P 1 1281cnar |FY22 REVENUE GENERAL FUND |glytdbud 1ST QUARTER FOR 2022 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 -1,674,464 0 -1,674,464 -407,349.02 -1,267,114.98 24.3% 412000 R.E. TAX REVENUE -68,094,866 0 -68,094,866 -16,149,168.40 -51,945,697.60 23.7% 412010 CLAUSE 41A R.E.PAYBACK 0 0 0 -23,239.04 23,239.04 100.0% 414200 TAX TITLE REVENUE 0 0 0 -77,331.50 77,331.50 100.0% 415000 MOTOR VEHICLE EXCISE -2,600,000 0 -2,600,000 -331,166.36 -2,268,833.64 12.7% 415010 ABATED MVE 0 0 0 -173.75 173.75 100.0% 416010 BOAT EXCISE -4,000 0 -4,000 .00 -4,000.00 .0% 416030 HOTEL/MOTEL TAX CH 145 -250,000 0 -250,000 -205,216.58 -44,783.42 82.1% 416035 MEALS TAX, CHAPT. 64L, S.2A -500,000 0 -500,000 -173,680.28 -326,319.72 34.7% 416036 ADULT MARIJUANA EXCISE CH64N -1,300,000 0 -1,300,000 -344,213.83 -955,786.17 26.5% 417010 INTEREST ON TAXES -95,000 0 -95,000 -43,097.57 -51,902.43 45.4% 417030 INTEREST ON TAX TITLES -28,000 0 -28,000 -12,166.15 -15,833.85 43.5% 417031 TAX TITLE ATTORNEY FEES 0 0 0 -973.20 973.20 100.0% 417040 TAX TITLE RELEASES -1,000 0 -1,000 -630.00 -370.00 63.0% 417050 INT/RELEASE/CH41A R.E. 0 0 0 -10,167.59 10,167.59 100.0% 418010 PILOT-HOUSING AUTHORITY -27,000 0 -27,000 .00 -27,000.00 .0% 418011 PILOT-SMITH COLLEGE -115,000 0 -115,000 .00 -115,000.00 .0% 418012 PILOT-B'NAI ISRAEL SYNAGOGUE -3,000 0 -3,000 .00 -3,000.00 .0% 418013 PILOT-US FISH & WILDLIFE -250 0 -250 .00 -250.00 .0% 418014 PILOT - EASTHAMPTON -800 0 -800 .00 -800.00 .0% 418015 PILOT-FAIR GROUNDS -5,000 0 -5,000 .00 -5,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 -5,000.00 -5,000.00 50.0% 418020 PILOT-MUSIC SCHOOL -3,500 0 -3,500 .00 -3,500.00 .0% TOTAL GENERAL FUND REVENUES -74,723,580 0 -74,723,580 -17,783,573.27 -56,940,006.73 23.8% TOTAL TAXES & EXCISES -74,723,580 0 -74,723,580 -17,783,573.27 -56,940,006.73 23.8% 42 CHARGES FOR SERVICES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 10/18/2021 14:24 |CITY OF NORTHAMPTON, MA - LIVE |P 2 1281cnar |FY22 REVENUE GENERAL FUND |glytdbud 1ST QUARTER FOR 2022 03 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ 424010 PARKING REVENUES -225,000 0 -225,000 -72,223.65 -152,776.35 32.1% 424011 PARKING LOT REVENUE -125,000 0 -125,000 -29,082.62 -95,917.38 23.3% 424012 PARKING GARAGE REVENUE -275,000 0 -275,000 -107,616.96 -167,383.04 39.1% 424013 PARKING PASS REVENUE -90,000 0 -90,000 -33,135.70 -56,864.30 36.8% 424015 PRK KIOSK CREDIT CARD -235,000 0 -235,000 -52,327.14 -182,672.86 22.3% 424016 MOBILE APP REVENUE -250,000 0 -250,000 -64,458.03 -185,541.97 25.8% 424025 AMBULANCE SERVICES -2,002,610 0 -2,002,610 -573,382.76 -1,429,227.24 28.6% TOTAL GENERAL FUND REVENUES -3,202,610 0 -3,202,610 -932,226.86 -2,270,383.14 29.1% TOTAL CHARGES FOR SERVICES -3,202,610 0 -3,202,610 -932,226.86 -2,270,383.14 29.1% 43 CHARGES FOR SERVICES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 432010 FEES - COLLECTOR -60,000 0 -60,000 -31,494.66 -28,505.34 52.5% 432011 FEES - MUNICIPAL LIENS -35,000 0 -35,000 -14,150.00 -20,850.00 40.4% 432012 FEES - MVE SURCHARGES -12,000 0 -12,000 -4,300.00 -7,700.00 35.8% 432014 FEES - CEMETERY INTERMENTS -16,000 0 -16,000 -9,400.00 -6,600.00 58.8% 432016 FEES - POLICE OUT/DET ADMIN -75,000 0 -75,000 -12,802.28 -62,197.72 17.1% 432018 FEES - FIRE OUT/DET ADMIN -1,000 0 -1,000 -470.40 -529.60 47.0% 432020 FEES - LICENSE COMM ADMIN FE 0 0 0 -75.00 75.00 100.0% 432021 FEES - CITY CLERK - MISC -25,000 0 -25,000 -7,995.00 -17,005.00 32.0% 432022 FEES - CITY CLERK - COPIES/R -80,000 0 -80,000 -21,170.00 -58,830.00 26.5% 432023 FEES - TREE WARDEN -20,000 0 -20,000 .00 -20,000.00 .0% 434035 TUITION - SVHS -7,761,032 0 -7,761,032 .00 -7,761,032.00 .0% 437009 DEPT REV - REGISTRAR OF VOTE -675 0 -675 -180.00 -495.00 26.7% 437011 DEPT REV - POLICE DEPT -12,000 0 -12,000 -1,525.00 -10,475.00 12.7% 437012 DEPT REV - GENERAL HIGHWAYS -10,000 0 -10,000 .00 -10,000.00 .0% 437014 DEPT REV - CEMETERIES -2,500 0 -2,500 -976.30 -1,523.70 39.1% 437016 DEPT REV - POLICE AUCTIONS -1,000 0 -1,000 .00 -1,000.00 .0% 437018 DEPT REV - BOARD OF HEALTH -12,000 0 -12,000 -4,300.00 -7,700.00 35.8% 437021 DEPT REV - BUILDING INSPECTI -43,000 0 -43,000 .00 -43,000.00 .0% 437022 DEPT REV - HEARING OFC FEES -2,400 0 -2,400 -812.50 -1,587.50 33.9% 437026 DEPT REV - FIRE 0 0 0 -72.75 72.75 100.0% TOTAL GENERAL FUND REVENUES -8,168,607 0 -8,168,607 -109,723.89 -8,058,883.11 1.3% TOTAL CHARGES FOR SERVICES -8,168,607 0 -8,168,607 -109,723.89 -8,058,883.11 1.3% 44 LICENSES & PERMITS _________________________________________ 10004 GENERAL FUND REVENUES 10/18/2021 14:24 |CITY OF NORTHAMPTON, MA - LIVE |P 3 1281cnar |FY22 REVENUE GENERAL FUND |glytdbud 1ST QUARTER FOR 2022 03 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ _________________________________________ 441000 LIQUOR & OTHER COMMT LICENSE -175,000 0 -175,000 -320.00 -174,680.00 .2% 442010 LICENSE COMM - SHORT TERM FE 0 0 0 -701.00 701.00 100.0% 442020 CITY CLERK LICENSES -15,000 0 -15,000 -3,990.00 -11,010.00 26.6% 442030 FIREARM LICENSES -3,000 0 -3,000 -600.00 -2,400.00 20.0% 445010 PERMITS - HEALTH DEPT -60,000 0 -60,000 -3,650.00 -56,350.00 6.1% 445012 PERMITS - BURIALS -9,000 0 -9,000 -2,575.00 -6,425.00 28.6% 445020 PERMITS - POLICE DEPT -950 0 -950 -100.00 -850.00 10.5% 445031 PERMITS - BUILDING INSPECTOR -370,000 0 -370,000 -75,916.34 -294,083.66 20.5% 445032 PERMITS - PLUMBING INSPECTOR -75,000 0 -75,000 -20,165.00 -54,835.00 26.9% 445033 PERMITS - WIRE INSPECTOR -100,000 0 -100,000 -28,591.16 -71,408.84 28.6% 445034 PERMITS - WEIGHTS & MEASURES -55,000 0 -55,000 -24,062.00 -30,938.00 43.7% 445035 PERIODIC INSPECTION -35,000 0 -35,000 -925.00 -34,075.00 2.6% 445036 PERMITS - SIDEWALK SIGNS -5,000 0 -5,000 .00 -5,000.00 .0% 445040 PERMITS - GENERAL HIGHWAYS -31,000 0 -31,000 -11,062.25 -19,937.75 35.7% 445050 PERMITS - PLANNING DEPT -25,000 0 -25,000 -12,752.75 -12,247.25 51.0% 445060 PERMITS - FIRE DEPT -70,000 0 -70,000 -15,222.09 -54,777.91 21.7% TOTAL GENERAL FUND REVENUES -1,028,950 0 -1,028,950 -200,632.59 -828,317.41 19.5% TOTAL LICENSES & PERMITS -1,028,950 0 -1,028,950 -200,632.59 -828,317.41 19.5% 45 FEDERAL REVENUE _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 458010 MEDICAID REIMB. SCHOOL -80,000 0 -80,000 -9,346.38 -70,653.62 11.7% TOTAL GENERAL FUND REVENUES -80,000 0 -80,000 -9,346.38 -70,653.62 11.7% TOTAL FEDERAL REVENUE -80,000 0 -80,000 -9,346.38 -70,653.62 11.7% 46 STATE REVENUE _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 461050 ABATE VETS, BLIND, SURV SPOU -108,671 0 -108,671 -95,835.00 -12,836.00 88.2% 10/18/2021 14:24 |CITY OF NORTHAMPTON, MA - LIVE |P 4 1281cnar |FY22 REVENUE GENERAL FUND |glytdbud 1ST QUARTER FOR 2022 03 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ 461070 LIEU OF TAXES-STATE OWNED LA -107,230 0 -107,230 -28,431.00 -78,799.00 26.5% 462010 CHAPTER 70 SCHOOL AID -8,554,554 0 -8,554,554 -2,138,637.00 -6,415,917.00 25.0% 462040 CHARTER SCHOOL AID -173,077 0 -173,077 -56,781.00 -116,296.00 32.8% 466020 VETERANS BENEFITS -365,312 0 -365,312 .00 -365,312.00 .0% 466035 UNRESTRICTED GENERAL AID -4,830,615 0 -4,830,615 -1,207,653.00 -3,622,962.00 25.0% 468000 OTHER STATE REVENUE -25,000 0 -25,000 .00 -25,000.00 .0% 468001 MA AMBULANCE CPE -195,000 0 -195,000 .00 -195,000.00 .0% 468010 RETIREMENT COLA REIMB. -3,400 0 -3,400 .00 -3,400.00 .0% TOTAL GENERAL FUND REVENUES -14,362,859 0 -14,362,859 -3,527,337.00 -10,835,522.00 24.6% TOTAL STATE REVENUE -14,362,859 0 -14,362,859 -3,527,337.00 -10,835,522.00 24.6% 47 IG/ASSESS/FINES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 477010 PARKING TICKETS -450,000 0 -450,000 -185,971.89 -264,028.11 41.3% 477020 CMVI REIMB. RMV -55,000 0 -55,000 -6,750.90 -48,249.10 12.3% TOTAL GENERAL FUND REVENUES -505,000 0 -505,000 -192,722.79 -312,277.21 38.2% TOTAL IG/ASSESS/FINES -505,000 0 -505,000 -192,722.79 -312,277.21 38.2% 48 MISCELLANEOUS _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 482000 INTEREST ON INVESTMENTS -125,000 0 -125,000 -23,441.24 -101,558.76 18.8% 483010 SMITH CHARITIES INCOME -6,500 0 -6,500 .00 -6,500.00 .0% 484000 MISCELLANEOUS RECEIPTS 0 0 0 -27,941.05 27,941.05 100.0% 484001 OVER/UNDER RECEIPTS 0 0 0 -.35 .35 100.0% 484010 PVTA-5 COLLEGE REIMBURSEMENT -75,000 0 -75,000 .00 -75,000.00 .0% 484012 VET SERVICES REGIONAL ASSESS -187,387 0 -187,387 -2,603.00 -184,784.00 1.4% 484013 IT SERVICE REGIONAL ASSESS -11,000 0 -11,000 .00 -11,000.00 .0% TOTAL GENERAL FUND REVENUES -404,887 0 -404,887 -53,985.64 -350,901.36 13.3% TOTAL MISCELLANEOUS -404,887 0 -404,887 -53,985.64 -350,901.36 13.3% GRAND TOTAL -102,476,493 0-102,476,493 -22,809,548.42 -79,666,944.58 22.3% 10/18/2021 14:24 |CITY OF NORTHAMPTON, MA - LIVE |P 5 1281cnar |FY22 REVENUE GENERAL FUND |glytdbud 1ST QUARTER FOR 2022 03 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ ** END OF REPORT - Generated by Charlene Nardi ** 10/18/2021 14:24 |CITY OF NORTHAMPTON, MA - LIVE |P 6 1281cnar |FY22 REVENUE 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: FY22 REVENUE GENERAL FUND Includes accounts exceeding 0% of budget. Print totals only: Y Year/Period: 2022/ 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 10/18/2021 14:24 |CITY OF NORTHAMPTON, MA - LIVE |P 7 1281cnar |FY22 REVENUE GENERAL FUND |glytdbud 1ST QUARTER REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Account status Rollup Code