Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GF Revenues.033118
04/11/2018 15:11 |CITY OF NORTHAMPTON, MA - LIVE |P 1 1281swri |THIRD QUARTER - REVENUES |glytdbud GENERAL FUND FOR 2018 09 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,434,985 21,937 -1,413,048 -1,005,318.69 -407,729.31 71.1% 412000 R.E. TAX REVENUE -55,964,408 -369,710 -56,334,118 -42,507,600.01 -13,826,517.99 75.5% 412010 CLAUSE 41A R.E.PAYBACK 0 0 0 -57,488.69 57,488.69 100.0% 414200 TAX TITLE REVENUE 0 0 0 -145,263.53 145,263.53 100.0% 415000 MOTOR VEHICLE EXCISE -2,455,690 -40,310 -2,496,000 -2,294,254.71 -201,745.29 91.9% 416010 BOAT EXCISE -4,250 -500 -4,750 -4,223.75 -526.25 88.9% 416030 HOTEL/MOTEL TAX CH 145 -600,919 34,238 -566,681 -556,377.11 -10,303.89 98.2% 416035 MEALS TAX, CHAPT. 64L, S.2A -667,238 3,919 -663,319 -565,127.96 -98,191.04 85.2% 416040 CH61A - R.E. DEFERRED 0 0 0 6,627.41 -6,627.41 100.0% 417010 INTEREST ON TAXES -100,000 6,000 -94,000 -96,591.19 2,591.19 102.8% 417030 INTEREST ON TAX TITLES -30,000 0 -30,000 -26,511.47 -3,488.53 88.4% 417031 TAX TITLE ATTORNEY FEES 0 0 0 -8,499.16 8,499.16 100.0% 417040 TAX TITLE RELEASES -1,000 0 -1,000 -825.00 -175.00 82.5% 417050 INT/RELEASE/CH41A R.E. 0 0 0 -51,408.87 51,408.87 100.0% 418010 PILOT-HOUSING AUTHORITY -28,000 0 -28,000 -34,314.56 6,314.56 122.6% 418011 PILOT-SMITH COLLEGE -93,000 -4,200 -97,200 -101,273.35 4,073.35 104.2% 418012 PILOT-B'NAI ISRAEL SYNAGOGUE -2,800 0 -2,800 -2,982.00 182.00 106.5% 418014 PILOT - EASTHAMPTON -1,000 0 -1,000 -918.46 -81.54 91.8% 418015 PILOT-FAIR GROUNDS -14,000 0 -14,000 .00 -14,000.00 .0% 418016 PILOT-NONOTUCK COMM SCH 0 0 0 -1,235.40 1,235.40 100.0% 418017 PILOT-SOLDIER ON 0 0 0 -9,447.02 9,447.02 100.0% 418018 PILOT-LANDFILL SOLAR ARRAY 0 0 0 -1,793.22 1,793.22 100.0% TOTAL GENERAL FUND REVENUES -61,397,290 -348,626 -61,745,916 -47,464,826.74 -14,281,089.26 76.9% TOTAL TAXES & EXCISES -61,397,290 -348,626 -61,745,916 -47,464,826.74 -14,281,089.26 76.9% 42 CHARGES FOR SERVICES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 424010 PARKING REVENUES -665,504 0 -665,504 -484,438.70 -181,065.30 72.8% 424011 PARKING LOT REVENUE -402,371 0 -402,371 -206,882.14 -195,488.86 51.4% 424012 PARKING GARAGE REVENUE -572,108 0 -572,108 -405,515.90 -166,592.10 70.9% 04/11/2018 15:11 |CITY OF NORTHAMPTON, MA - LIVE |P 2 1281swri |THIRD QUARTER - REVENUES |glytdbud GENERAL FUND FOR 2018 09 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ 424013 PARKING PASS REVENUE -154,814 0 -154,814 -134,886.10 -19,927.90 87.1% 424014 PD PARKING GARAGE REVENUE -1,000 0 -1,000 .00 -1,000.00 .0% 424015 PRK KIOSK CREDIT CARD 0 0 0 -141,089.42 141,089.42 100.0% 424016 MOBILE APP REVENUE 0 0 0 -45,812.41 45,812.41 100.0% 424020 RECREATION REVENUES -46,000 4,500 -41,500 .00 -41,500.00 .0% 424025 AMBULANCE SERVICES -1,450,000 95,797 -1,354,203 -1,307,541.44 -46,661.56 96.6% 424035 SALE OF SCRAP METAL 0 -2,590 -2,590 .00 -2,590.00 .0% TOTAL GENERAL FUND REVENUES -3,291,797 97,707 -3,194,090 -2,726,166.11 -467,923.89 85.4% TOTAL CHARGES FOR SERVICES -3,291,797 97,707 -3,194,090 -2,726,166.11 -467,923.89 85.4% 43 CHARGES FOR SERVICES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 432010 FEES - COLLECTOR -124,000 9,000 -115,000 -60,447.16 -54,552.84 52.6% 432011 FEES - MUNICIPAL LIENS -35,000 0 -35,000 -26,500.00 -8,500.00 75.7% 432012 FEES - MVE SURCHARGES -14,000 0 -14,000 -10,440.00 -3,560.00 74.6% 432014 FEES - CEMETERY INTERMENTS -21,000 -4,500 -25,500 -20,645.00 -4,855.00 81.0% 432016 FEES - POLICE OUT/DET ADMIN -32,000 -6,650 -38,650 -34,469.82 -4,180.18 89.2% 432018 FEES - FIRE OUT/DET ADMIN 0 0 0 -1,897.20 1,897.20 100.0% 432020 FEES - LICENSE COMM ADMIN FE 0 0 0 -200.00 200.00 100.0% 432021 FEES - CITY CLERK - MISC -37,000 0 -37,000 -33,843.00 -3,157.00 91.5% 432022 FEES - CITY CLERK - COPIES/R -82,000 0 -82,000 -60,525.00 -21,475.00 73.8% 434035 TUITION - SVHS -6,403,000 0 -6,403,000 -3,459,088.45 -2,943,911.55 54.0% 436010 RENTALS - CITY PROPERTY 0 0 0 -800.00 800.00 100.0% 437003 DEPT REV - TREASURER -250 0 -250 -195.00 -55.00 78.0% 437005 DEPT REV - ASSESSORS 0 0 0 -13.50 13.50 100.0% 437009 DEPT REV - REGISTRAR OF VOTE -900 0 -900 -715.00 -185.00 79.4% 437011 DEPT REV - POLICE DEPT -59,500 -6,000 -65,500 -33,943.33 -31,556.67 51.8% 437012 DEPT REV - GENERAL HIGHWAYS 0 0 0 -30.00 30.00 100.0% 437014 DEPT REV - CEMETERIES -4,000 0 -4,000 -1,230.00 -2,770.00 30.8% 437016 DEPT REV - POLICE AUCTIONS -1,000 0 -1,000 -3,853.90 2,853.90 385.4% 437018 DEPT REV - BOARD OF HEALTH -5,000 0 -5,000 -10,818.00 5,818.00 216.4% 437021 DEPT REV - BUILDING INSPECTI -37,800 0 -37,800 -37,800.00 .00 100.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 -13.55 13.55 100.0% 437027 DEPT REV - DPW BID DOCUMENTS 0 0 0 -330.00 330.00 100.0% TOTAL GENERAL FUND REVENUES -6,858,850 -8,150 -6,867,000 -3,800,235.41 -3,066,764.59 55.3% 04/11/2018 15:11 |CITY OF NORTHAMPTON, MA - LIVE |P 3 1281swri |THIRD QUARTER - REVENUES |glytdbud GENERAL FUND FOR 2018 09 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ TOTAL CHARGES FOR SERVICES -6,858,850 -8,150 -6,867,000 -3,800,235.41 -3,066,764.59 55.3% 44 LICENSES & PERMITS _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 441000 LIQUOR & OTHER COMMT LICENSE -198,000 0 -198,000 -191,238.00 -6,762.00 96.6% 442010 LICENSE COMM - SHORT TERM FE 0 0 0 -300.00 300.00 100.0% 442020 CITY CLERK LICENSES -25,000 0 -25,000 -16,526.00 -8,474.00 66.1% 442030 FIREARM LICENSES -3,000 0 -3,000 -4,087.50 1,087.50 136.3% 445010 PERMITS - HEALTH DEPT -60,000 0 -60,000 -55,340.00 -4,660.00 92.2% 445012 PERMITS - BURIALS -12,000 0 -12,000 -11,340.00 -660.00 94.5% 445020 PERMITS - POLICE DEPT -1,000 0 -1,000 -796.00 -204.00 79.6% 445031 PERMITS - BUILDING INSPECTOR -343,000 50,000 -293,000 -464,530.71 171,530.71 158.5% 445032 PERMITS - PLUMBING INSPECTOR -110,000 0 -110,000 -79,880.00 -30,120.00 72.6% 445033 PERMITS - WIRE INSPECTOR -110,000 25,000 -85,000 -99,348.34 14,348.34 116.9% 445034 PERMITS - WEIGHTS & MEASURES -50,000 0 -50,000 -27,875.00 -22,125.00 55.8% 445035 PERIODIC INSPECTION -23,000 0 -23,000 -23,115.00 115.00 100.5% 445036 PERMITS - SIDEWALK SIGNS -10,000 0 -10,000 -8,950.00 -1,050.00 89.5% 445040 PERMITS - GENERAL HIGHWAYS -90,000 0 -90,000 -39,550.00 -50,450.00 43.9% 445050 PERMITS - PLANNING DEPT -44,000 0 -44,000 -25,902.60 -18,097.40 58.9% 445060 PERMITS - FIRE DEPT -75,000 10,250 -64,750 -54,023.60 -10,726.40 83.4% TOTAL GENERAL FUND REVENUES -1,154,000 85,250 -1,068,750 -1,102,802.75 34,052.75 103.2% TOTAL LICENSES & PERMITS -1,154,000 85,250 -1,068,750 -1,102,802.75 34,052.75 103.2% 45 FEDERAL REVENUE _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 458010 MEDICAID REIMB. SCHOOL -315,644 102,644 -213,000 -112,575.85 -100,424.15 52.9% TOTAL GENERAL FUND REVENUES -315,644 102,644 -213,000 -112,575.85 -100,424.15 52.9% TOTAL FEDERAL REVENUE -315,644 102,644 -213,000 -112,575.85 -100,424.15 52.9% 46 STATE REVENUE _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 04/11/2018 15:11 |CITY OF NORTHAMPTON, MA - LIVE |P 4 1281swri |THIRD QUARTER - REVENUES |glytdbud GENERAL FUND FOR 2018 09 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ 461050 ABATE VETS, BLIND, SURV SPOU -123,551 0 -123,551 -38,772.00 -84,779.00 31.4% 461070 LIEU OF TAXES-STATE OWNED LA -63,791 -1 -63,792 -47,835.00 -15,957.00 75.0% 462010 CHAPTER 70 SCHOOL AID -8,302,674 0 -8,302,674 -6,227,001.00 -2,075,673.00 75.0% 462030 SCHOOL CONSTRUCTION CH645 -1,108,358 0 -1,108,358 .00 -1,108,358.00 .0% 462040 CHARTER SCHOOL AID -169,670 -55,698 -225,368 -227,106.00 1,738.00 100.8% 466020 VETERANS BENEFITS -571,215 0 -571,215 -272,563.00 -298,652.00 47.7% 466035 UNRESTRICTED GENERAL AID -4,390,877 0 -4,390,877 -3,293,154.00 -1,097,723.00 75.0% 468000 OTHER STATE REVENUE -4,500 0 -4,500 -19,499.00 14,999.00 433.3% 468001 MA AMBULANCE CPE 0 -42,000 -42,000 .00 -42,000.00 .0% 468010 RETIREMENT COLA REIMB. -3,400 0 -3,400 -2,352.84 -1,047.16 69.2% TOTAL GENERAL FUND REVENUES -14,738,036 -97,699 -14,835,735 -10,128,282.84 -4,707,452.16 68.3% TOTAL STATE REVENUE -14,738,036 -97,699 -14,835,735 -10,128,282.84 -4,707,452.16 68.3% 47 IG/ASSESS/FINES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 477010 PARKING TICKETS -836,000 111,000 -725,000 -543,042.50 -181,957.50 74.9% 477020 CMVI REIMB. RMV -75,000 0 -75,000 -48,962.50 -26,037.50 65.3% TOTAL GENERAL FUND REVENUES -911,000 111,000 -800,000 -592,005.00 -207,995.00 74.0% TOTAL IG/ASSESS/FINES -911,000 111,000 -800,000 -592,005.00 -207,995.00 74.0% 48 MISCELLANEOUS _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 482000 INTEREST ON INVESTMENTS -80,000 -15,500 -95,500 -70,618.09 -24,881.91 73.9% 483010 SMITH CHARITIES INCOME -7,500 0 -7,500 -6,913.81 -586.19 92.2% 484000 MISCELLANEOUS RECEIPTS 0 0 0 -160,195.49 160,195.49 100.0% 484001 OVER/UNDER RECEIPTS 0 0 0 9.73 -9.73 100.0% 484003 MED MARIJUANA HOST COMM FEE -200,000 100,000 -100,000 -200,000.00 100,000.00 200.0% 484010 PVTA-5 COLLEGE REIMBURSEMENT -69,000 0 -69,000 .00 -69,000.00 .0% 484012 VET SERVICES REGIONAL ASSESS -152,810 3,657 -149,153 -152,809.00 3,656.00 102.5% 04/11/2018 15:11 |CITY OF NORTHAMPTON, MA - LIVE |P 5 1281swri |THIRD QUARTER - REVENUES |glytdbud GENERAL FUND FOR 2018 09 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ 484020 STATE/FED SNOW/ICE/FLOOD REI 0 0 0 -3,253.87 3,253.87 100.0% 484021 INSURANCE PROCEEDS 0 0 0 -2,251.25 2,251.25 100.0% TOTAL GENERAL FUND REVENUES -509,310 88,157 -421,153 -596,031.78 174,878.78 141.5% TOTAL MISCELLANEOUS -509,310 88,157 -421,153 -596,031.78 174,878.78 141.5% GRAND TOTAL -89,175,927 30,283 -89,145,644 -66,522,926.48 -22,622,717.52 74.6% ** END OF REPORT - Generated by Susan Wright ** 04/11/2018 15:11 |CITY OF NORTHAMPTON, MA - LIVE |P 6 1281swri |THIRD QUARTER - REVENUES |glytdbud GENERAL FUND 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: THIRD QUARTER - REVENUES Includes accounts exceeding 0% of budget. Print totals only: Y Year/Period: 2018/ 9 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: 2016/ 9 To Yr/Per: 2016/ 9 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 04/11/2018 15:11 |CITY OF NORTHAMPTON, MA - LIVE |P 7 1281swri |THIRD QUARTER - REVENUES |glytdbud GENERAL FUND REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Account status Rollup Code