Loading...
General Fund Revenue.123121 01/13/2022 16:24 |CITY OF NORTHAMPTON, MA - LIVE |P 1 1281cnar |YTD FY2022 REVENUES GENERAL FUND |glytdbud 2ND QUARTER FOR 2022 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 -1,674,464 -294,130 -1,968,594 -753,762.92 -1,214,831.08 38.3% 412000 R.E. TAX REVENUE -68,094,866 -43,387 -68,138,253 -32,099,425.80 -36,038,827.20 47.1% 412010 CLAUSE 41A R.E.PAYBACK 0 0 0 -49,613.14 49,613.14 100.0% 414200 TAX TITLE REVENUE 0 0 0 -173,714.87 173,714.87 100.0% 415000 MOTOR VEHICLE EXCISE -2,600,000 322,000 -2,278,000 -465,177.26 -1,812,822.74 20.4% 415010 ABATED MVE 0 0 0 -403.13 403.13 100.0% 416010 BOAT EXCISE -4,000 500 -3,500 -4,062.86 562.86 116.1% 416030 HOTEL/MOTEL TAX CH 145 -250,000 0 -250,000 -465,141.11 215,141.11 186.1% 416035 MEALS TAX, CHAPT. 64L, S.2A -500,000 0 -500,000 -366,426.88 -133,573.12 73.3% 416036 ADULT MARIJUANA EXCISE CH64N -1,300,000 142,376 -1,157,624 -650,292.75 -507,331.25 56.2% 417010 INTEREST ON TAXES -95,000 -90,000 -185,000 -77,081.44 -107,918.56 41.7% 417030 INTEREST ON TAX TITLES -28,000 0 -28,000 -27,315.73 -684.27 97.6% 417031 TAX TITLE ATTORNEY FEES 0 0 0 -2,806.28 2,806.28 100.0% 417040 TAX TITLE RELEASES -1,000 0 -1,000 -2,415.00 1,415.00 241.5% 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 .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 -3,622.75 122.75 103.5% TOTAL GENERAL FUND REVENUES -74,723,580 37,359 -74,686,221 -35,197,598.70 -39,488,622.30 47.1% TOTAL TAXES & EXCISES -74,723,580 37,359 -74,686,221 -35,197,598.70 -39,488,622.30 47.1% 42 CHARGES FOR SERVICES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 01/13/2022 16:24 |CITY OF NORTHAMPTON, MA - LIVE |P 2 1281cnar |YTD FY2022 REVENUES GENERAL FUND |glytdbud 2ND QUARTER FOR 2022 06 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ 424010 PARKING REVENUES -225,000 0 -225,000 -142,320.16 -82,679.84 63.3% 424011 PARKING LOT REVENUE -125,000 0 -125,000 -50,098.43 -74,901.57 40.1% 424012 PARKING GARAGE REVENUE -275,000 0 -275,000 -219,827.51 -55,172.49 79.9% 424013 PARKING PASS REVENUE -90,000 0 -90,000 -70,557.80 -19,442.20 78.4% 424015 PRK KIOSK CREDIT CARD -235,000 0 -235,000 -100,636.94 -134,363.06 42.8% 424016 MOBILE APP REVENUE -250,000 0 -250,000 -107,681.50 -142,318.50 43.1% 424025 AMBULANCE SERVICES -2,002,610 100,000 -1,902,610 -1,440,440.33 -462,169.67 75.7% TOTAL GENERAL FUND REVENUES -3,202,610 100,000 -3,102,610 -2,131,562.67 -971,047.33 68.7% TOTAL CHARGES FOR SERVICES -3,202,610 100,000 -3,102,610 -2,131,562.67 -971,047.33 68.7% 43 CHARGES FOR SERVICES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 432010 FEES - COLLECTOR -60,000 -60,000 -120,000 -49,387.35 -70,612.65 41.2% 432011 FEES - MUNICIPAL LIENS -35,000 0 -35,000 -25,650.00 -9,350.00 73.3% 432012 FEES - MVE SURCHARGES -12,000 0 -12,000 -8,600.00 -3,400.00 71.7% 432014 FEES - CEMETERY INTERMENTS -16,000 0 -16,000 -16,235.00 235.00 101.5% 432016 FEES - POLICE OUT/DET ADMIN -75,000 0 -75,000 -29,609.86 -45,390.14 39.5% 432018 FEES - FIRE OUT/DET ADMIN -1,000 0 -1,000 -950.60 -49.40 95.1% 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 -15,066.00 -9,934.00 60.3% 432022 FEES - CITY CLERK - COPIES/R -80,000 0 -80,000 -39,920.00 -40,080.00 49.9% 432023 FEES - TREE WARDEN -20,000 0 -20,000 .00 -20,000.00 .0% 434035 TUITION - SVHS -7,761,032 0 -7,761,032 -2,383,339.19 -5,377,692.81 30.7% 437003 DEPT REV - TREASURER 0 0 0 -25.00 25.00 100.0% 437009 DEPT REV - REGISTRAR OF VOTE -675 0 -675 -570.00 -105.00 84.4% 437011 DEPT REV - POLICE DEPT -12,000 0 -12,000 -4,420.00 -7,580.00 36.8% 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 -8,925.00 -3,075.00 74.4% 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 -203.64 203.64 100.0% TOTAL GENERAL FUND REVENUES -8,168,607 -60,000 -8,228,607 -2,584,940.44 -5,643,666.56 31.4% TOTAL CHARGES FOR SERVICES -8,168,607 -60,000 -8,228,607 -2,584,940.44 -5,643,666.56 31.4% 44 LICENSES & PERMITS _________________________________________ 01/13/2022 16:24 |CITY OF NORTHAMPTON, MA - LIVE |P 3 1281cnar |YTD FY2022 REVENUES GENERAL FUND |glytdbud 2ND QUARTER FOR 2022 06 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 -162,957.00 -12,043.00 93.1% 442010 LICENSE COMM - SHORT TERM FE 0 0 0 -1,677.00 1,677.00 100.0% 442020 CITY CLERK LICENSES -15,000 0 -15,000 -6,115.00 -8,885.00 40.8% 442030 FIREARM LICENSES -3,000 0 -3,000 -1,625.00 -1,375.00 54.2% 445010 PERMITS - HEALTH DEPT -60,000 0 -60,000 -53,980.00 -6,020.00 90.0% 445012 PERMITS - BURIALS -9,000 0 -9,000 -4,775.00 -4,225.00 53.1% 445020 PERMITS - POLICE DEPT -950 0 -950 -340.00 -610.00 35.8% 445031 PERMITS - BUILDING INSPECTOR -370,000 -2,000 -372,000 -149,350.69 -222,649.31 40.1% 445032 PERMITS - PLUMBING INSPECTOR -75,000 0 -75,000 -43,130.00 -31,870.00 57.5% 445033 PERMITS - WIRE INSPECTOR -100,000 0 -100,000 -60,812.82 -39,187.18 60.8% 445034 PERMITS - WEIGHTS & MEASURES -55,000 0 -55,000 -34,172.00 -20,828.00 62.1% 445035 PERIODIC INSPECTION -35,000 0 -35,000 -1,300.00 -33,700.00 3.7% 445036 PERMITS - SIDEWALK SIGNS -5,000 0 -5,000 -712.50 -4,287.50 14.3% 445040 PERMITS - GENERAL HIGHWAYS -31,000 0 -31,000 -17,204.75 -13,795.25 55.5% 445050 PERMITS - PLANNING DEPT -25,000 0 -25,000 -14,152.75 -10,847.25 56.6% 445060 PERMITS - FIRE DEPT -70,000 0 -70,000 -28,899.24 -41,100.76 41.3% TOTAL GENERAL FUND REVENUES -1,028,950 -2,000 -1,030,950 -581,203.75 -449,746.25 56.4% TOTAL LICENSES & PERMITS -1,028,950 -2,000 -1,030,950 -581,203.75 -449,746.25 56.4% 45 FEDERAL REVENUE _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 458010 MEDICAID REIMB. SCHOOL -80,000 0 -80,000 -9,556.38 -70,443.62 11.9% TOTAL GENERAL FUND REVENUES -80,000 0 -80,000 -9,556.38 -70,443.62 11.9% TOTAL FEDERAL REVENUE -80,000 0 -80,000 -9,556.38 -70,443.62 11.9% 46 STATE REVENUE _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 01/13/2022 16:24 |CITY OF NORTHAMPTON, MA - LIVE |P 4 1281cnar |YTD FY2022 REVENUES GENERAL FUND |glytdbud 2ND QUARTER FOR 2022 06 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 -109,229.00 558.00 100.5% 461070 LIEU OF TAXES-STATE OWNED LA -107,230 -6,499 -113,729 -56,862.00 -56,867.00 50.0% 462010 CHAPTER 70 SCHOOL AID -8,554,554 0 -8,554,554 -4,277,274.00 -4,277,280.00 50.0% 462040 CHARTER SCHOOL AID -173,077 -54,052 -227,129 -146,342.00 -80,787.00 64.4% 466020 VETERANS BENEFITS -365,312 0 -365,312 -147,728.00 -217,584.00 40.4% 466035 UNRESTRICTED GENERAL AID -4,830,615 0 -4,830,615 -2,415,306.00 -2,415,309.00 50.0% 468000 OTHER STATE REVENUE -25,000 0 -25,000 -36,234.00 11,234.00 144.9% 468001 MA AMBULANCE CPE -195,000 -10,000 -205,000 .00 -205,000.00 .0% 468010 RETIREMENT COLA REIMB. -3,400 0 -3,400 -135.15 -3,264.85 4.0% TOTAL GENERAL FUND REVENUES -14,362,859 -70,551 -14,433,410 -7,189,110.15 -7,244,299.85 49.8% TOTAL STATE REVENUE -14,362,859 -70,551 -14,433,410 -7,189,110.15 -7,244,299.85 49.8% 47 IG/ASSESS/FINES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 477010 PARKING TICKETS -450,000 0 -450,000 -360,639.64 -89,360.36 80.1% 477020 CMVI REIMB. RMV -55,000 0 -55,000 -17,565.34 -37,434.66 31.9% TOTAL GENERAL FUND REVENUES -505,000 0 -505,000 -378,204.98 -126,795.02 74.9% TOTAL IG/ASSESS/FINES -505,000 0 -505,000 -378,204.98 -126,795.02 74.9% 48 MISCELLANEOUS _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 482000 INTEREST ON INVESTMENTS -125,000 0 -125,000 -58,899.05 -66,100.95 47.1% 483010 SMITH CHARITIES INCOME -6,500 0 -6,500 .00 -6,500.00 .0% 484000 MISCELLANEOUS RECEIPTS 0 0 0 -29,054.20 29,054.20 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 -187,388.00 1.00 100.0% 484013 IT SERVICE REGIONAL ASSESS -11,000 0 -11,000 -780.00 -10,220.00 7.1% TOTAL GENERAL FUND REVENUES -404,887 0 -404,887 -276,121.60 -128,765.40 68.2% 01/13/2022 16:24 |CITY OF NORTHAMPTON, MA - LIVE |P 5 1281cnar |YTD FY2022 REVENUES GENERAL FUND |glytdbud 2ND QUARTER FOR 2022 06 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ TOTAL MISCELLANEOUS -404,887 0 -404,887 -276,121.60 -128,765.40 68.2% GRAND TOTAL -102,476,493 4,808-102,471,685 -48,348,298.67 -54,123,386.33 47.2% ** END OF REPORT - Generated by Charlene Nardi ** 01/13/2022 16:24 |CITY OF NORTHAMPTON, MA - LIVE |P 6 1281cnar |YTD FY2022 REVENUES GENERAL FUND |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: YTD FY2022 REVENUES GENERAL FUND Includes accounts exceeding 0% of budget. Print totals only: Y Year/Period: 2022/ 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/13/2022 16:24 |CITY OF NORTHAMPTON, MA - LIVE |P 7 1281cnar |YTD FY2022 REVENUES GENERAL FUND |glytdbud 2ND QUARTER REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Account status Rollup Code