Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Revenue - General Fund - Second Quarter
01/16/2018 11:07 |City of Northampton |P 1 1281swri |REVENUE |glytdbud GENERAL FUND FOR 2018 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,434,985 21,937 -1,413,048 -624,714.91 -788,333.09 44.2% 412000 R.E. TAX REVENUE -55,964,408 -369,710 -56,334,118 -28,429,497.98 -27,904,620.02 50.5% 412010 CLAUSE 41A R.E.PAYBACK 0 0 0 -12,252.72 12,252.72 100.0% 414200 TAX TITLE REVENUE 0 0 0 -119,742.52 119,742.52 100.0% 415000 MOTOR VEHICLE EXCISE -2,455,690 -40,310 -2,496,000 -373,117.94 -2,122,882.06 14.9% 416010 BOAT EXCISE -4,250 -500 -4,750 -4,682.18 -67.82 98.6% 416030 HOTEL/MOTEL TAX CH 145 -600,919 34,238 -566,681 -420,770.26 -145,910.74 74.3% 416035 MEALS TAX, CHAPT. 64L, S.2A -667,238 3,919 -663,319 -393,706.69 -269,612.31 59.4% 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 -68,725.04 -25,274.96 73.1% 417030 INTEREST ON TAX TITLES -30,000 0 -30,000 -22,166.30 -7,833.70 73.9% 417031 TAX TITLE ATTORNEY FEES 0 0 0 -6,319.34 6,319.34 100.0% 417040 TAX TITLE RELEASES -1,000 0 -1,000 -525.00 -475.00 52.5% 417050 INT/RELEASE/CH41A R.E. 0 0 0 -21,634.85 21,634.85 100.0% 418010 PILOT-HOUSING AUTHORITY -28,000 0 -28,000 .00 -28,000.00 .0% 418011 PILOT-SMITH COLLEGE -93,000 -4,200 -97,200 .00 -97,200.00 .0% 418012 PILOT-B'NAI ISRAEL SYNAGOGUE -2,800 0 -2,800 .00 -2,800.00 .0% 418014 PILOT - EASTHAMPTON -1,000 0 -1,000 .00 -1,000.00 .0% 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% TOTAL GENERAL FUND REVENUES -61,397,290 -348,626 -61,745,916 -30,492,463.72 -31,253,452.28 49.4% TOTAL TAXES & EXCISES -61,397,290 -348,626 -61,745,916 -30,492,463.72 -31,253,452.28 49.4% 42 CHARGES FOR SERVICES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 424010 PARKING REVENUES -665,504 0 -665,504 -356,443.00 -309,061.00 53.6% 424011 PARKING LOT REVENUE -402,371 0 -402,371 -153,197.02 -249,173.98 38.1% 424012 PARKING GARAGE REVENUE -572,108 0 -572,108 -274,008.50 -298,099.50 47.9% 424013 PARKING PASS REVENUE -154,814 0 -154,814 -101,833.30 -52,980.70 65.8% 424014 PD PARKING GARAGE REVENUE -1,000 0 -1,000 .00 -1,000.00 .0% 01/16/2018 11:07 |City of Northampton |P 2 1281swri |REVENUE |glytdbud GENERAL FUND FOR 2018 06 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ 424015 PRK KIOSK CREDIT CARD 0 0 0 -103,181.50 103,181.50 100.0% 424016 MOBILE APP REVENUE 0 0 0 -24,679.91 24,679.91 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 -795,134.09 -559,068.91 58.7% 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 -1,808,477.32 -1,385,612.68 56.6% TOTAL CHARGES FOR SERVICES -3,291,797 97,707 -3,194,090 -1,808,477.32 -1,385,612.68 56.6% 43 CHARGES FOR SERVICES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 432010 FEES - COLLECTOR -124,000 9,000 -115,000 -49,504.82 -65,495.18 43.0% 432011 FEES - MUNICIPAL LIENS -35,000 0 -35,000 -20,050.00 -14,950.00 57.3% 432012 FEES - MVE SURCHARGES -14,000 0 -14,000 -7,200.00 -6,800.00 51.4% 432014 FEES - CEMETERY INTERMENTS -21,000 -4,500 -25,500 -15,510.00 -9,990.00 60.8% 432016 FEES - POLICE OUT/DET ADMIN -32,000 -6,650 -38,650 -26,905.87 -11,744.13 69.6% 432018 FEES - FIRE OUT/DET ADMIN 0 0 0 -1,412.10 1,412.10 100.0% 432020 FEES - LICENSE COMM APPLIC F 0 0 0 -175.00 175.00 100.0% 432021 FEES - CITY CLERK - MISC -37,000 0 -37,000 -18,638.00 -18,362.00 50.4% 432022 FEES - CITY CLERK - COPIES/R -82,000 0 -82,000 -36,930.00 -45,070.00 45.0% 434035 TUITION - SVHS -6,403,000 0 -6,403,000 -1,845,013.10 -4,557,986.90 28.8% 436010 RENTALS - CITY PROPERTY 0 0 0 -500.00 500.00 100.0% 437003 DEPT REV - TREASURER -250 0 -250 -110.00 -140.00 44.0% 437005 DEPT REV - ASSESSORS 0 0 0 -10.00 10.00 100.0% 437009 DEPT REV - REGISTRAR OF VOTE -900 0 -900 -385.00 -515.00 42.8% 437011 DEPT REV - POLICE DEPT -59,500 -6,000 -65,500 -19,420.83 -46,079.17 29.7% 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,721.00 2,721.00 372.1% 437018 DEPT REV - BOARD OF HEALTH -5,000 0 -5,000 -7,678.00 2,678.00 153.6% 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 -1,625.00 -775.00 67.7% TOTAL GENERAL FUND REVENUES -6,858,850 -8,150 -6,867,000 -2,093,848.72 -4,773,151.28 30.5% TOTAL CHARGES FOR SERVICES -6,858,850 -8,150 -6,867,000 -2,093,848.72 -4,773,151.28 30.5% 44 LICENSES & PERMITS _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 01/16/2018 11:07 |City of Northampton |P 3 1281swri |REVENUE |glytdbud GENERAL FUND FOR 2018 06 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ 441000 LIQUOR LICENSES -198,000 0 -198,000 -123,741.00 -74,259.00 62.5% 442010 LICENSE COMM - OTHER LICENSE 0 0 0 -300.00 300.00 100.0% 442020 CITY CLERK LICENSES -25,000 0 -25,000 -5,946.00 -19,054.00 23.8% 442030 FIREARM LICENSES -3,000 0 -3,000 -2,512.50 -487.50 83.8% 445010 PERMITS - HEALTH DEPT -60,000 0 -60,000 -47,510.00 -12,490.00 79.2% 445012 PERMITS - BURIALS -12,000 0 -12,000 -6,720.00 -5,280.00 56.0% 445020 PERMITS - POLICE DEPT -1,000 0 -1,000 -691.00 -309.00 69.1% 445031 PERMITS - BUILDING INSPECTOR -343,000 50,000 -293,000 -303,874.80 10,874.80 103.7% 445032 PERMITS - PLUMBING INSPECTOR -110,000 0 -110,000 -52,955.00 -57,045.00 48.1% 445033 PERMITS - WIRE INSPECTOR -110,000 25,000 -85,000 -65,402.13 -19,597.87 76.9% 445034 PERMITS - WEIGHTS & MEASURES -50,000 0 -50,000 -17,190.00 -32,810.00 34.4% 445035 PERIODIC INSPECTION -23,000 0 -23,000 -2,695.00 -20,305.00 11.7% 445036 PERMITS - SIDEWALK SIGNS -10,000 0 -10,000 -600.00 -9,400.00 6.0% 445040 PERMITS - GENERAL HIGHWAYS -90,000 0 -90,000 -32,875.00 -57,125.00 36.5% 445050 PERMITS - PLANNING DEPT -44,000 0 -44,000 -21,850.15 -22,149.85 49.7% 445060 PERMITS - FIRE DEPT -75,000 10,250 -64,750 -27,721.10 -37,028.90 42.8% TOTAL GENERAL FUND REVENUES -1,154,000 85,250 -1,068,750 -712,583.68 -356,166.32 66.7% TOTAL LICENSES & PERMITS -1,154,000 85,250 -1,068,750 -712,583.68 -356,166.32 66.7% 45 FEDERAL REVENUE _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 458010 MEDICAID REIMB. SCHOOL -315,644 102,644 -213,000 -29,249.77 -183,750.23 13.7% TOTAL GENERAL FUND REVENUES -315,644 102,644 -213,000 -29,249.77 -183,750.23 13.7% TOTAL FEDERAL REVENUE -315,644 102,644 -213,000 -29,249.77 -183,750.23 13.7% 46 STATE REVENUE _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 461050 ABATE VETS, BLIND, SURV SPOU -123,551 0 -123,551 -25,848.00 -97,703.00 20.9% 461070 LIEU OF TAXES-STATE OWNED LA -63,791 -1 -63,792 -31,890.00 -31,902.00 50.0% 01/16/2018 11:07 |City of Northampton |P 4 1281swri |REVENUE |glytdbud GENERAL FUND FOR 2018 06 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ 462010 CHAPTER 70 SCHOOL AID -8,302,674 0 -8,302,674 -4,151,334.00 -4,151,340.00 50.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 -128,098.00 -97,270.00 56.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 -2,195,436.00 -2,195,441.00 50.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 .00 -3,400.00 .0% TOTAL GENERAL FUND REVENUES -14,738,036 -97,699 -14,835,735 -6,824,668.00 -8,011,067.00 46.0% TOTAL STATE REVENUE -14,738,036 -97,699 -14,835,735 -6,824,668.00 -8,011,067.00 46.0% 47 IG/ASSESS/FINES _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 477010 PARKING TICKETS -836,000 111,000 -725,000 -367,247.50 -357,752.50 50.7% 477020 CMVI REIMB. RMV -75,000 0 -75,000 -29,020.00 -45,980.00 38.7% TOTAL GENERAL FUND REVENUES -911,000 111,000 -800,000 -396,267.50 -403,732.50 49.5% TOTAL IG/ASSESS/FINES -911,000 111,000 -800,000 -396,267.50 -403,732.50 49.5% 48 MISCELLANEOUS _________________________________________ 10004 GENERAL FUND REVENUES _________________________________________ 482000 INTEREST ON INVESTMENTS -80,000 -15,500 -95,500 -44,269.49 -51,230.51 46.4% 483010 SMITH CHARITIES INCOME -7,500 0 -7,500 .00 -7,500.00 .0% 484000 MISCELLANEOUS RECEIPTS 0 0 0 -44,569.06 44,569.06 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 .00 -100,000.00 .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 -62,168.00 -86,985.00 41.7% 484020 STATE/FED SNOW/ICE/FLOOD REI 0 0 0 -3,253.87 3,253.87 100.0% TOTAL GENERAL FUND REVENUES -509,310 88,157 -421,153 -154,250.69 -266,902.31 36.6% 01/16/2018 11:07 |City of Northampton |P 5 1281swri |REVENUE |glytdbud GENERAL FUND FOR 2018 06 ORIGINAL ESTIM REV REVISED ACTUAL YTD REMAINING PCT ESTIM REV ADJSTMTS EST REV REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ TOTAL MISCELLANEOUS -509,310 88,157 -421,153 -154,250.69 -266,902.31 36.6% GRAND TOTAL -89,175,927 30,283 -89,145,644 -42,511,809.40 -46,633,834.60 47.7% ** END OF REPORT - Generated by Susan Wright ** 01/16/2018 11:07 |City of Northampton |P 6 1281swri |REVENUE |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: REVENUE Includes accounts exceeding 0% of budget. Print totals only: Y Year/Period: 2018/ 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: 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 01/16/2018 11:07 |City of Northampton |P 7 1281swri |REVENUE |glytdbud GENERAL FUND REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Account status Rollup Code