Loading...
GF Revenue.123119 01/15/2020 11:50 |CITY OF NORTHAMPTON, MA - LIVE |P 1 1281swri |CITY OF NORTHAMPTON |glytdbud REVENUE - GENERAL FUND - QUARTER 2 FOR 2020 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,502,706 25,458 -1,477,248 -726,173.40 -751,074.60 49.2% 412000 R.E. TAX REVENUE -60,435,980 75,863 -60,360,117 -29,025,578.95 -31,334,538.05 48.1% 412010 CLAUSE 41A R.E.PAYBACK 0 0 0 -16,659.99 16,659.99 100.0% 414200 TAX TITLE REVENUE 0 0 0 -68,236.77 68,236.77 100.0% 415000 MOTOR VEHICLE EXCISE -2,700,000 175,158 -2,524,842 -481,849.78 -2,042,992.22 19.1% 416010 BOAT EXCISE -3,500 -500 -4,000 .00 -4,000.00 .0% 416030 HOTEL/MOTEL TAX CH 145 -700,000 2,500 -697,500 -516,819.34 -180,680.66 74.1% 416035 MEALS TAX, CHAPT. 64L, S.2A -700,000 55,000 -645,000 -392,076.00 -252,924.00 60.8% 416036 ADULT MARIJUANA EXCISE CH64N -1,200,000 0 -1,200,000 -980,056.29 -219,943.71 81.7% 417010 INTEREST ON TAXES -100,000 -3,406 -103,406 -73,086.69 -30,319.31 70.7% 417030 INTEREST ON TAX TITLES -30,000 0 -30,000 -12,039.21 -17,960.79 40.1% 417031 TAX TITLE ATTORNEY FEES 0 0 0 -6,461.80 6,461.80 100.0% 417040 TAX TITLE RELEASES -1,000 0 -1,000 -480.00 -520.00 48.0% 417050 INT/RELEASE/CH41A R.E. 0 0 0 -3,213.80 3,213.80 100.0% 418010 PILOT-HOUSING AUTHORITY -30,000 0 -30,000 .00 -30,000.00 .0% 418011 PILOT-SMITH COLLEGE -100,000 0 -100,000 .00 -100,000.00 .0% 418012 PILOT-B'NAI ISRAEL SYNAGOGUE -2,900 0 -2,900 .00 -2,900.00 .0% 418013 PILOT-US FISH & WILDLIFE -250 0 -250 .00 -250.00 .0% 418014 PILOT - EASTHAMPTON -756 0 -756 .00 -756.00 .0% 418015 PILOT-FAIR GROUNDS -14,000 1,000 -13,000 .00 -13,000.00 .0% 418016 PILOT-NONOTUCK COMM SCH -1,000 0 -1,000 .00 -1,000.00 .0% 418017 PILOT-SOLDIER ON -8,500 0 -8,500 .00 -8,500.00 .0% 418018 PILOT-LANDFILL SOLAR ARRAY -10,000 0 -10,000 .00 -10,000.00 .0% TOTAL GENERAL FUND REVENUES -67,540,592 331,073 -67,209,519 -32,302,732.02 -34,906,786.98 48.1% TOTAL TAXES & EXCISES -67,540,592 331,073 -67,209,519 -32,302,732.02 -34,906,786.98 48.1% 42 CHARGES FOR SERVICES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 424010 PARKING REVENUES -600,000 0 -600,000 -261,899.07 -338,100.93 43.6% 424011 PARKING LOT REVENUE -200,000 0 -200,000 -91,248.00 -108,752.00 45.6% 01/15/2020 11:50 |CITY OF NORTHAMPTON, MA - LIVE |P 2 1281swri |CITY OF NORTHAMPTON |glytdbud REVENUE - GENERAL FUND - QUARTER 2 FOR 2020 06 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ 424012 PARKING GARAGE REVENUE -500,000 0 -500,000 -306,341.24 -193,658.76 61.3% 424013 PARKING PASS REVENUE -150,000 0 -150,000 -82,940.75 -67,059.25 55.3% 424015 PRK KIOSK CREDIT CARD -200,000 0 -200,000 -118,102.39 -81,897.61 59.1% 424016 MOBILE APP REVENUE -207,164 0 -207,164 -129,693.79 -77,470.21 62.6% 424020 RECREATION REVENUES -46,000 0 -46,000 .00 -46,000.00 .0% 424025 AMBULANCE SERVICES -1,654,000 -128,836 -1,782,836 -1,102,556.88 -680,279.12 61.8% TOTAL GENERAL FUND REVENUES -3,557,164 -128,836 -3,686,000 -2,092,782.12 -1,593,217.88 56.8% TOTAL CHARGES FOR SERVICES -3,557,164 -128,836 -3,686,000 -2,092,782.12 -1,593,217.88 56.8% 43 CHARGES FOR SERVICES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 432010 FEES - COLLECTOR -119,570 0 -119,570 -43,188.41 -76,381.59 36.1% 432011 FEES - MUNICIPAL LIENS -33,000 0 -33,000 -20,300.00 -12,700.00 61.5% 432012 FEES - MVE SURCHARGES -12,000 0 -12,000 -7,160.00 -4,840.00 59.7% 432014 FEES - CEMETERY INTERMENTS -28,521 2,021 -26,500 -12,125.00 -14,375.00 45.8% 432016 FEES - POLICE OUT/DET ADMIN -39,270 -35,180 -74,450 -48,237.49 -26,212.51 64.8% 432018 FEES - FIRE OUT/DET ADMIN -1,000 0 -1,000 -1,200.50 200.50 120.1% 432020 FEES - LICENSE COMM ADMIN FE 0 0 0 -100.00 100.00 100.0% 432021 FEES - CITY CLERK - MISC -40,239 0 -40,239 -11,371.95 -28,867.05 28.3% 432022 FEES - CITY CLERK - COPIES/R -82,000 -18,191 -100,191 -48,390.00 -51,801.00 48.3% 432023 FEES - TREE WARDEN 0 0 0 -41,100.00 41,100.00 100.0% 434035 TUITION - SVHS -7,056,429 0 -7,056,429 -2,102,106.95 -4,954,322.05 29.8% 436010 RENTALS - CITY PROPERTY 0 0 0 -400.00 400.00 100.0% 437003 DEPT REV - TREASURER -250 0 -250 -50.00 -200.00 20.0% 437009 DEPT REV - REGISTRAR OF VOTE -900 0 -900 -390.00 -510.00 43.3% 437011 DEPT REV - POLICE DEPT -45,000 0 -45,000 -17,782.50 -27,217.50 39.5% 437012 DEPT REV - GENERAL HIGHWAYS 0 -20,000 -20,000 -22,263.98 2,263.98 111.3% 437014 DEPT REV - CEMETERIES -4,000 0 -4,000 -1,993.80 -2,006.20 49.8% 437016 DEPT REV - POLICE AUCTIONS -1,000 0 -1,000 -1,036.67 36.67 103.7% 437018 DEPT REV - BOARD OF HEALTH -16,000 0 -16,000 -10,500.00 -5,500.00 65.6% 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 -2,437.50 37.50 101.6% 437026 DEPT REV - FIRE 0 0 0 -166.35 166.35 100.0% TOTAL GENERAL FUND REVENUES -7,524,579 -71,350 -7,595,929 -2,392,301.10 -5,203,627.90 31.5% TOTAL CHARGES FOR SERVICES -7,524,579 -71,350 -7,595,929 -2,392,301.10 -5,203,627.90 31.5% 44 LICENSES & PERMITS _________________________________________ 01/15/2020 11:50 |CITY OF NORTHAMPTON, MA - LIVE |P 3 1281swri |CITY OF NORTHAMPTON |glytdbud REVENUE - GENERAL FUND - QUARTER 2 FOR 2020 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 -185,000 0 -185,000 -175,050.00 -9,950.00 94.6% 442010 LICENSE COMM - SHORT TERM FE 0 0 0 -2,713.00 2,713.00 100.0% 442020 CITY CLERK LICENSES -25,000 0 -25,000 -7,105.00 -17,895.00 28.4% 442030 FIREARM LICENSES -3,000 0 -3,000 -2,125.00 -875.00 70.8% 445010 PERMITS - HEALTH DEPT -60,000 0 -60,000 -66,715.00 6,715.00 111.2% 445012 PERMITS - BURIALS -9,000 0 -9,000 -5,425.00 -3,575.00 60.3% 445020 PERMITS - POLICE DEPT -950 0 -950 -330.00 -620.00 34.7% 445031 PERMITS - BUILDING INSPECTOR -440,568 -82,379 -522,947 -220,518.23 -302,428.77 42.2% 445032 PERMITS - PLUMBING INSPECTOR -109,906 0 -109,906 -51,915.00 -57,991.00 47.2% 445033 PERMITS - WIRE INSPECTOR -128,196 0 -128,196 -60,355.00 -67,841.00 47.1% 445034 PERMITS - WEIGHTS & MEASURES -50,000 0 -50,000 -33,035.00 -16,965.00 66.1% 445035 PERIODIC INSPECTION -20,000 0 -20,000 -2,910.00 -17,090.00 14.6% 445036 PERMITS - SIDEWALK SIGNS -8,000 0 -8,000 -2,775.00 -5,225.00 34.7% 445040 PERMITS - GENERAL HIGHWAYS -65,000 0 -65,000 -19,042.50 -45,957.50 29.3% 445050 PERMITS - PLANNING DEPT -25,000 0 -25,000 -17,718.92 -7,281.08 70.9% 445060 PERMITS - FIRE DEPT -90,000 0 -90,000 -34,028.97 -55,971.03 37.8% TOTAL GENERAL FUND REVENUES -1,219,620 -82,379 -1,301,999 -701,761.62 -600,237.38 53.9% TOTAL LICENSES & PERMITS -1,219,620 -82,379 -1,301,999 -701,761.62 -600,237.38 53.9% 45 FEDERAL REVENUE _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 458010 MEDICAID REIMB. SCHOOL -180,000 -5,000 -185,000 -52,265.55 -132,734.45 28.3% TOTAL GENERAL FUND REVENUES -180,000 -5,000 -185,000 -52,265.55 -132,734.45 28.3% TOTAL FEDERAL REVENUE -180,000 -5,000 -185,000 -52,265.55 -132,734.45 28.3% 46 STATE REVENUE _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 01/15/2020 11:50 |CITY OF NORTHAMPTON, MA - LIVE |P 4 1281swri |CITY OF NORTHAMPTON |glytdbud REVENUE - GENERAL FUND - QUARTER 2 FOR 2020 06 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ 461050 ABATE VETS, BLIND, SURV SPOU -115,741 0 -115,741 -22,888.00 -92,853.00 19.8% 461070 LIEU OF TAXES-STATE OWNED LA -95,638 -4,425 -100,063 -49,824.00 -50,239.00 49.8% 462010 CHAPTER 70 SCHOOL AID -8,471,394 0 -8,471,394 -4,234,416.00 -4,236,978.00 50.0% 462030 SCHOOL CONSTRUCTION CH645 -1,108,359 0 -1,108,359 .00 -1,108,359.00 .0% 462040 CHARTER SCHOOL AID -183,782 -141,020 -324,802 -132,596.00 -192,206.00 40.8% 466020 VETERANS BENEFITS -437,906 0 -437,906 -210,758.00 -227,148.00 48.1% 466035 UNRESTRICTED GENERAL AID -4,667,261 0 -4,667,261 -2,333,628.00 -2,333,633.00 50.0% 468000 OTHER STATE REVENUE -4,500 0 -4,500 .00 -4,500.00 .0% 468001 MA AMBULANCE CPE -95,000 -102,495 -197,495 .00 -197,495.00 .0% 468010 RETIREMENT COLA REIMB. -3,400 0 -3,400 -2,352.84 -1,047.16 69.2% TOTAL GENERAL FUND REVENUES -15,182,981 -247,940 -15,430,921 -6,986,462.84 -8,444,458.16 45.3% TOTAL STATE REVENUE -15,182,981 -247,940 -15,430,921 -6,986,462.84 -8,444,458.16 45.3% 47 IG/ASSESS/FINES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 477010 PARKING TICKETS -700,000 6,581 -693,419 -413,985.75 -279,433.25 59.7% 477020 CMVI REIMB. RMV -66,581 10,000 -56,581 -27,306.84 -29,274.16 48.3% TOTAL GENERAL FUND REVENUES -766,581 16,581 -750,000 -441,292.59 -308,707.41 58.8% TOTAL IG/ASSESS/FINES -766,581 16,581 -750,000 -441,292.59 -308,707.41 58.8% 48 MISCELLANEOUS _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 482000 INTEREST ON INVESTMENTS -100,000 -96,576 -196,576 -156,107.17 -40,468.83 79.4% 483010 SMITH CHARITIES INCOME -6,500 0 -6,500 .00 -6,500.00 .0% 484000 MISCELLANEOUS RECEIPTS 0 0 0 -167,652.80 167,652.80 100.0% 484001 OVER/UNDER RECEIPTS 0 0 0 -11.21 11.21 100.0% 484010 PVTA-5 COLLEGE REIMBURSEMENT -52,000 0 -52,000 .00 -52,000.00 .0% 484012 VET SERVICES REGIONAL ASSESS -169,605 0 -169,605 -169,606.00 1.00 100.0% 484013 IT SERVICE REGIONAL ASSESS -11,000 0 -11,000 .00 -11,000.00 .0% 484015 TAILINGS CLOSEOUT 0 0 0 -278.16 278.16 100.0% TOTAL GENERAL FUND REVENUES -339,105 -96,576 -435,681 -493,655.34 57,974.34 113.3% 01/15/2020 11:50 |CITY OF NORTHAMPTON, MA - LIVE |P 5 1281swri |CITY OF NORTHAMPTON |glytdbud REVENUE - GENERAL FUND - QUARTER 2 FOR 2020 06 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ TOTAL MISCELLANEOUS -339,105 -96,576 -435,681 -493,655.34 57,974.34 113.3% GRAND TOTAL -96,310,622 -284,427 -96,595,049 -45,463,253.18 -51,131,795.82 47.1% ** END OF REPORT - Generated by Susan Wright **