Matters ▸ Attachment
YTD General Fund Revenue — File 24-0210
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 1
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
01 MOTOR VEHICLE EXCISE
415000 MOTOR VEHICLE EXCISE TAX
00145150 415000 MOTOR VEHICLE E -6,368,163 -1,000 -6,369,163 -1,106,520.18 .00 -5,262,642.82 17.4%
TOTAL MOTOR VEHICLE EXCISE TAX -6,368,163 -1,000 -6,369,163 -1,106,520.18 .00 -5,262,642.82 17.4%
TOTAL MOTOR VEHICLE EXCISE -6,368,163 -1,000 -6,369,163 -1,106,520.18 .00 -5,262,642.82 17.4%
TOTAL REVENUES -6,368,163 -1,000 -6,369,163 -1,106,520.18 .00 -5,262,642.82
02 OTHER EXCISE
466002 URBAN EXCISE DEVELOPMENT
00820610 466002 URBAN EXCISE DE 0 0 0 .00 .00 .00 .0%
TOTAL URBAN EXCISE DEVELOPMENT 0 0 0 .00 .00 .00 .0%
468001 LOCAL MEALS EXCISE
00820680 468001 LOCAL MEALS EXC -2,717,637 0 -2,717,637 -1,376,253.08 .00 -1,341,383.92 50.6%
TOTAL LOCAL MEALS EXCISE -2,717,637 0 -2,717,637 -1,376,253.08 .00 -1,341,383.92 50.6%
468002 LOCAL OPTION ROOM EXCISE
00820680 468002 LOCAL OPTION RO -2,425,853 0 -2,425,853 -1,922,113.77 .00 -503,739.23 79.2%
TOTAL LOCAL OPTION ROOM EXCISE -2,425,853 0 -2,425,853 -1,922,113.77 .00 -503,739.23 79.2%
468004 LOCAL MARIJUANA
00820680 468004 LOCAL MARIJUANA 0 0 0 -147,054.57 .00 147,054.57 100.0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 2
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL LOCAL MARIJUANA 0 0 0 -147,054.57 .00 147,054.57 100.0%
TOTAL OTHER EXCISE -5,143,490 0 -5,143,490 -3,445,421.42 .00 -1,698,068.58 67.0%
TOTAL REVENUES -5,143,490 0 -5,143,490 -3,445,421.42 .00 -1,698,068.58
03 PENALTIES AND INTERE
417001 INTEREST - PERSONAL PRO
00145170 417001 PENALTIES & INT -7,985 0 -7,985 -7,186.66 .00 -798.34 90.0%
TOTAL INTEREST - PERSONAL PRO -7,985 0 -7,985 -7,186.66 .00 -798.34 90.0%
417002 INTEREST - REAL ESTATE
00145170 417002 PENALTIES & INT -389,535 0 -389,535 -231,105.56 .00 -158,429.44 59.3%
TOTAL INTEREST - REAL ESTATE -389,535 0 -389,535 -231,105.56 .00 -158,429.44 59.3%
417003 INTEREST - EXCISE TAX
00145170 417003 INTEREST- VEHIC -51,510 0 -51,510 -42,111.00 .00 -9,399.00 81.8%
TOTAL INTEREST - EXCISE TAX -51,510 0 -51,510 -42,111.00 .00 -9,399.00 81.8%
417004 INTEREST - TAX TITLE
00145170 417004 INTEREST - TAX -125,000 0 -125,000 -39,709.15 .00 -85,290.85 31.8%
TOTAL INTEREST - TAX TITLE -125,000 0 -125,000 -39,709.15 .00 -85,290.85 31.8%
417005 PENALTIES EXCISE FEE
00145170 417005 PENALTIES EXCIS 0 0 0 .00 .00 .00 .0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 3
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL PENALTIES EXCISE FEE 0 0 0 .00 .00 .00 .0%
417006 PENALTIES TAX TITLE
00145170 417006 PENALTIES - TAX 0 0 0 -75.00 .00 75.00 100.0%
TOTAL PENALTIES TAX TITLE 0 0 0 -75.00 .00 75.00 100.0%
417007 DEMAND & PENALTIES TAX/EXCISE
00145170 417007 PENALTIES TAX/E -115,500 0 -115,500 -89,557.78 .00 -25,942.22 77.5%
TOTAL DEMAND & PENALTIES TAX/EXCISE -115,500 0 -115,500 -89,557.78 .00 -25,942.22 77.5%
417009 PENALTIES NON CRIMINAL DEMAND
00145170 417009 PENALTIES NON C -3,500 0 -3,500 -17,616.00 .00 14,116.00 503.3%
00161170 417009 PENALTIES NON C 0 0 0 -6,498.00 .00 6,498.00 100.0%
TOTAL PENALTIES NON CRIMINAL DEMAND -3,500 0 -3,500 -24,114.00 .00 20,614.00 689.0%
417010 PENALTIES NON CRIMINAL LIEN
00145170 417010 PENALTIES NON C -3,500 0 -3,500 -73,235.34 .00 69,735.34 2092.4%
00161170 417010 PENALTIES NON C 0 0 0 -1,050.00 .00 1,050.00 100.0%
TOTAL PENALTIES NON CRIMINAL LIEN -3,500 0 -3,500 -74,285.34 .00 70,785.34 2122.4%
417013 INTEREST-DEFERRED TAX
0001 417013 INTEREST-DEFERRED T 0 0 0 .00 .00 .00 .0%
00145170 417013 INTEREST-DEFERR -25 -257 -282 -295.87 .00 13.87 104.9%
TOTAL INTEREST-DEFERRED TAX -25 -257 -282 -295.87 .00 13.87 104.9%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 4
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL PENALTIES AND INTERE -696,555 -257 -696,812 -508,440.36 .00 -188,371.64 73.0%
TOTAL REVENUES -696,555 -257 -696,812 -508,440.36 .00 -188,371.64
04 PILOT
418000 PAYMENTS IN LIEU OF TAXES
00145180 418000 PAYMENTS IN LIE -1,661,522 0 -1,661,522 -50,455.48 .00 -1,611,066.52 3.0%
TOTAL PAYMENTS IN LIEU OF TAXES -1,661,522 0 -1,661,522 -50,455.48 .00 -1,611,066.52 3.0%
418001 PARTNERS PILOT
00145180 418001 PARTNERS PILOT 0 0 0 .00 .00 .00 .0%
TOTAL PARTNERS PILOT 0 0 0 .00 .00 .00 .0%
TOTAL PILOT -1,661,522 0 -1,661,522 -50,455.48 .00 -1,611,066.52 3.0%
TOTAL REVENUES -1,661,522 0 -1,661,522 -50,455.48 .00 -1,611,066.52
08 CHARGES - TRASH
432017 RESIDENTIAL TRASH FE
00406320 432017 RESIDENTIAL TRA -35,600 -5,000 -40,600 -59,800.00 .00 19,200.00 147.3%
TOTAL RESIDENTIAL TRASH FE -35,600 -5,000 -40,600 -59,800.00 .00 19,200.00 147.3%
432019 ROYALTY FEES VENDOR
00406320 432019 ROYALTY FEES VE 0 0 0 .00 .00 .00 .0%
TOTAL ROYALTY FEES VENDOR 0 0 0 .00 .00 .00 .0%
432020 SANITATION FEES
00161320 432020 SANITATION FEES 0 0 0 -4,350.00 .00 4,350.00 100.0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 5
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
00406320 432020 SANITATION FEES -36,279 0 -36,279 -1,652.00 .00 -34,627.00 4.6%
TOTAL SANITATION FEES -36,279 0 -36,279 -6,002.00 .00 -30,277.00 16.5%
445010 REMOVAL OF GARBAGE
00406450 445010 REMOVAL OF GARB 0 0 0 .00 .00 .00 .0%
TOTAL REMOVAL OF GARBAGE 0 0 0 .00 .00 .00 .0%
TOTAL CHARGES - TRASH -71,879 -5,000 -76,879 -65,802.00 .00 -11,077.00 85.6%
TOTAL REVENUES -71,879 -5,000 -76,879 -65,802.00 .00 -11,077.00
10 FEES
417014 FEES- DEFERRED TAX
00145170 417014 FEES- DEFERRED 0 0 0 .00 .00 .00 .0%
TOTAL FEES- DEFERRED TAX 0 0 0 .00 .00 .00 .0%
432000 FEES
00161320 432000 MISC FEES 0 0 0 .00 .00 .00 .0%
00512320 432000 FEES 0 0 0 .00 .00 .00 .0%
TOTAL FEES 0 0 0 .00 .00 .00 .0%
432001 ADVERTISING FEES
00161320 432001 ADVERTISING FEE 0 -300 -300 -675.00 .00 375.00 225.0%
00630320 432001 ADVERTISING FEE 0 0 0 -600.00 .00 600.00 100.0%
TOTAL ADVERTISING FEES 0 -300 -300 -1,275.00 .00 975.00 425.0%
432002 BUS CERTIFICATE
00161320 432002 BUS CERTIFICATE -10,500 0 -10,500 -9,960.00 .00 -540.00 94.9%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 6
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL BUS CERTIFICATE -10,500 0 -10,500 -9,960.00 .00 -540.00 94.9%
432003 CERT OF LIENS
00145320 432003 CERT OF LIENS -96,826 0 -96,826 -46,980.00 .00 -49,846.00 48.5%
TOTAL CERT OF LIENS -96,826 0 -96,826 -46,980.00 .00 -49,846.00 48.5%
432004 CONDO APPL FEE
00165320 432004 CONDO APPL FEE 0 0 0 .00 .00 .00 .0%
00183320 432004 CONDO APPL FEE -39,600 0 -39,600 -28,200.00 .00 -11,400.00 71.2%
TOTAL CONDO APPL FEE -39,600 0 -39,600 -28,200.00 .00 -11,400.00 71.2%
432005 CONSTABLE FEES
00145320 432005 CONSTABLE FEES -590 0 -590 -975.00 .00 385.00 165.3%
TOTAL CONSTABLE FEES -590 0 -590 -975.00 .00 385.00 165.3%
432006 COPIES OF RECORDS
00100320 432006 COPIES OF RECOR -10 0 -10 .00 .00 -10.00 .0%
00138320 432006 COPIES OF RECOR 0 0 0 .00 .00 .00 .0%
00141320 432006 COPIES OF RECOR -500 0 -500 -624.00 .00 124.00 124.8%
00145320 432006 COPIES OF RECOR -800 0 -800 .00 .00 -800.00 .0%
00151320 432006 COPIES OF RECOR -300 0 -300 -183.25 .00 -116.75 61.1%
00152320 432006 COPIES OF RECOR 0 0 0 .00 .00 .00 .0%
00155320 432006 COPIES OF RECOR 0 0 0 .00 .00 .00 .0%
00157320 432006 COPIES OF RECOR 0 0 0 .00 .00 .00 .0%
00161320 432006 COPIES OF RECOR -84,000 0 -84,000 -41,177.00 .00 -42,823.00 49.0%
00162320 432006 COPIES OF RECOR -250 0 -250 .00 .00 -250.00 .0%
00181320 432006 COPIES OF RECOR -4,300 0 -4,300 -2,117.96 .00 -2,182.04 49.3%
00182320 432006 COPIES OF RECOR 0 0 0 .00 .00 .00 .0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 7
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
00183320 432006 COPIES OF RECOR 0 0 0 .00 .00 .00 .0%
00187320 432006 COPIES OF RECOR 0 0 0 .00 .00 .00 .0%
00210320 432006 COPIES OF RECOR 0 0 0 .00 .00 .00 .0%
00220320 432006 COPIES OF RECOR -50 0 -50 .00 .00 -50.00 .0%
00293320 432006 COPIES OF RECOR 0 0 0 .00 .00 .00 .0%
00401320 432006 COPIES OF RECOR 0 0 0 .00 .00 .00 .0%
00403320 432006 COPIES OF RECOR 0 0 0 .00 .00 .00 .0%
TOTAL COPIES OF RECORDS -90,210 0 -90,210 -44,102.21 .00 -46,107.79 48.9%
432008 DETAIL SURCHARGE
00210320 432008 POLICE DETAIL S -290,362 0 -290,362 -142,986.91 .00 -147,375.09 49.2%
00220320 432008 FIRE DETAIL SUR -89,738 0 -89,738 -73,759.18 .00 -15,978.82 82.2%
00401320 432008 CUSTODIAL DETAI -10,887 0 -10,887 -4,817.79 .00 -6,069.21 44.3%
TOTAL DETAIL SURCHARGE -390,987 0 -390,987 -221,563.88 .00 -169,423.12 56.7%
432010 FINGERPRINTING FEES
00210320 432010 FINGERPRINTING -1,500 0 -1,500 -2,010.00 .00 510.00 134.0%
TOTAL FINGERPRINTING FEES -1,500 0 -1,500 -2,010.00 .00 510.00 134.0%
432011 FIRE ALARM REIMB
00402320 432011 FIRE ALARM REIM -132,395 0 -132,395 -124,300.00 .00 -8,095.00 93.9%
TOTAL FIRE ALARM REIMB -132,395 0 -132,395 -124,300.00 .00 -8,095.00 93.9%
432012 MISC FEES
00100320 432012 GEN GOV MISC FE 0 0 0 .00 .00 .00 .0%
00161320 432012 MISC FEES 0 0 0 .00 .00 .00 .0%
00220320 432012 MISC FIRE FEES -95,000 0 -95,000 -52,125.00 .00 -42,875.00 54.9%
TOTAL MISC FEES -95,000 0 -95,000 -52,125.00 .00 -42,875.00 54.9%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 8
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
432013 NEWSPAPER MACHINE FEES
00187320 432013 NEWSPAPER MACHI 0 0 0 .00 .00 .00 .0%
TOTAL NEWSPAPER MACHINE FEES 0 0 0 .00 .00 .00 .0%
432014 NOTARIZATION
00161320 432014 NOTARIZATION 0 -170 -170 -295.00 .00 125.00 173.5%
TOTAL NOTARIZATION 0 -170 -170 -295.00 .00 125.00 173.5%
432015 PARKING FINE CC FEE
00293320 432015 PARKING FINE CC 0 0 0 .00 .00 .00 .0%
TOTAL PARKING FINE CC FEE 0 0 0 .00 .00 .00 .0%
432016 POLICE CRUISER FEES
00210320 432016 POLICE CRUISER -8,000 0 -8,000 -5,880.00 .00 -2,120.00 73.5%
TOTAL POLICE CRUISER FEES -8,000 0 -8,000 -5,880.00 .00 -2,120.00 73.5%
432018 RETURNED CHECK FEE
00145320 432018 RETURNED CHECK -980 0 -980 -825.00 .00 -155.00 84.2%
00187320 432018 RETURNED CHECK 0 0 0 -125.00 .00 125.00 100.0%
00293320 432018 RETURNED CHECK 0 0 0 .00 .00 .00 .0%
TOTAL RETURNED CHECK FEE -980 0 -980 -950.00 .00 -30.00 96.9%
432021 SMOKE DETECTOR INSP
00220320 432021 SMOKE DETECTOR -65,000 0 -65,000 -23,225.00 .00 -41,775.00 35.7%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 9
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL SMOKE DETECTOR INSP -65,000 0 -65,000 -23,225.00 .00 -41,775.00 35.7%
432022 SPGA FEES
00161320 432022 SPGA FEES 0 -270 -270 -465.00 .00 195.00 172.2%
TOTAL SPGA FEES 0 -270 -270 -465.00 .00 195.00 172.2%
432023 WITNESS FEES
00151320 432023 WITNESS FEES 0 0 0 .00 .00 .00 .0%
00210320 432023 WITNESS FEES -20 0 -20 .00 .00 -20.00 .0%
TOTAL WITNESS FEES -20 0 -20 .00 .00 -20.00 .0%
432027 FRANCHISE FEE
00157320 432027 FRANCHISE FEE 0 0 0 .00 .00 .00 .0%
TOTAL FRANCHISE FEE 0 0 0 .00 .00 .00 .0%
432028 CURB CUT FEE
00403320 432028 CURB CUT FEE -10,000 0 -10,000 -7,700.00 .00 -2,300.00 77.0%
00405320 432028 CURB CUT FEE 0 0 0 .00 .00 .00 .0%
TOTAL CURB CUT FEE -10,000 0 -10,000 -7,700.00 .00 -2,300.00 77.0%
432029 TEMPORARY NO PARKING SIGN FEE
00293320 432029 TEMPORARY NO PA -80,000 0 -80,000 -54,471.00 .00 -25,529.00 68.1%
TOTAL TEMPORARY NO PARKING SIGN FEE -80,000 0 -80,000 -54,471.00 .00 -25,529.00 68.1%
432030 COMPOST BIN FEE
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 10
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
00401320 432030 COMPOST BIN FEE 0 0 0 .00 .00 .00 .0%
TOTAL COMPOST BIN FEE 0 0 0 .00 .00 .00 .0%
432031 LATE INCOME AND EXPENSE FEE
00145320 432031 LATE INCOME AND 0 0 0 .00 .00 .00 .0%
TOTAL LATE INCOME AND EXPENSE FEE 0 0 0 .00 .00 .00 .0%
432033 TAXICAB REINSPECTION FEE
00210320 432033 TAXICAB REINSPE 0 0 0 .00 .00 .00 .0%
TOTAL TAXICAB REINSPECTION FEE 0 0 0 .00 .00 .00 .0%
432034 WHITE GOODS FEES
00406320 432034 WHITE GOODS FEE -14,525 0 -14,525 -13,825.00 .00 -700.00 95.2%
TOTAL WHITE GOODS FEES -14,525 0 -14,525 -13,825.00 .00 -700.00 95.2%
432035 POOL FEES
00630320 432035 POOL FEES -17,000 0 -17,000 -14,820.00 .00 -2,180.00 87.2%
TOTAL POOL FEES -17,000 0 -17,000 -14,820.00 .00 -2,180.00 87.2%
432036 PARK PERMIT FEES
00630320 432036 PARK PERMIT FEE 0 0 0 .00 .00 .00 .0%
TOTAL PARK PERMIT FEES 0 0 0 .00 .00 .00 .0%
432037 PARK LIGHT FEE
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 11
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
00630320 432037 PARK LIGHT FEE -18,000 0 -18,000 -3,173.75 .00 -14,826.25 17.6%
TOTAL PARK LIGHT FEE -18,000 0 -18,000 -3,173.75 .00 -14,826.25 17.6%
432038 HEARING FEES
00165320 432038 HEARING FEES -26,900 0 -26,900 -28,900.00 .00 2,000.00 107.4%
TOTAL HEARING FEES -26,900 0 -26,900 -28,900.00 .00 2,000.00 107.4%
432039 MBTA ADMIN FEES
00512320 432039 MBTA ADMIN FEES 0 0 0 .00 .00 .00 .0%
TOTAL MBTA ADMIN FEES 0 0 0 .00 .00 .00 .0%
432040 CANOE/BOAT RENTAL
00630320 432040 CANOE/BOAT RENT -24,000 0 -24,000 -330.00 .00 -23,670.00 1.4%
TOTAL CANOE/BOAT RENTAL -24,000 0 -24,000 -330.00 .00 -23,670.00 1.4%
432041 GAS STATIONS
00187321 432041 GAS STATIONS -3,000 0 -3,000 -1,455.00 .00 -1,545.00 48.5%
TOTAL GAS STATIONS -3,000 0 -3,000 -1,455.00 .00 -1,545.00 48.5%
432042 OIL TRUCKS
00187321 432042 OIL TRUCKS -3,200 0 -3,200 -1,000.00 .00 -2,200.00 31.3%
TOTAL OIL TRUCKS -3,200 0 -3,200 -1,000.00 .00 -2,200.00 31.3%
432043 SCALES
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 12
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
00187321 432043 SCALES -5,500 0 -5,500 -1,510.00 .00 -3,990.00 27.5%
TOTAL SCALES -5,500 0 -5,500 -1,510.00 .00 -3,990.00 27.5%
432044 TAXI METERS
00187321 432044 TAXI METERS -500 0 -500 -1,200.00 .00 700.00 240.0%
TOTAL TAXI METERS -500 0 -500 -1,200.00 .00 700.00 240.0%
432045 PARKING SIGN - LABOR
00293320 432045 PARKING SIGN - 0 0 0 .00 .00 .00 .0%
TOTAL PARKING SIGN - LABOR 0 0 0 .00 .00 .00 .0%
432046 MEDICAL MARIJUANA FEE
00181320 432046 MEDICAL MARIJUA -1,400 0 -1,400 .00 .00 -1,400.00 .0%
TOTAL MEDICAL MARIJUANA FEE -1,400 0 -1,400 .00 .00 -1,400.00 .0%
432047 CS APPLICATION FEE
00161320 432047 CS APPLICATION -2,000 0 -2,000 -1,500.00 .00 -500.00 75.0%
TOTAL CS APPLICATION FEE -2,000 0 -2,000 -1,500.00 .00 -500.00 75.0%
432048 TOTER FEES
00401320 432048 TOTER FEES 0 0 0 -3,150.00 .00 3,150.00 100.0%
TOTAL TOTER FEES 0 0 0 -3,150.00 .00 3,150.00 100.0%
432102 SAFETY REVIEW FEE
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 13
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
00187320 432102 SAFETY REVIEW F -680,000 0 -680,000 -516,818.75 .00 -163,181.25 76.0%
TOTAL SAFETY REVIEW FEE -680,000 0 -680,000 -516,818.75 .00 -163,181.25 76.0%
432104 USE OF PUBLIC SPACE FEE
00165320 432104 USE OF PUBLIC S 0 0 0 -61,158.00 .00 61,158.00 100.0%
TOTAL USE OF PUBLIC SPACE FEE 0 0 0 -61,158.00 .00 61,158.00 100.0%
437002 BUS ROUTES REVENUE
00161370 437002 BUS ROUTES 0 0 0 .00 .00 .00 .0%
TOTAL BUS ROUTES REVENUE 0 0 0 .00 .00 .00 .0%
437003 BUS SHELTER ADVERTISING REVENU
00145370 437003 BUS SHELTER ADV 0 0 0 .00 .00 .00 .0%
00401370 437003 BUS SHELTER ADV 0 0 0 .00 .00 .00 .0%
TOTAL BUS SHELTER ADVERTISING REVENU 0 0 0 .00 .00 .00 .0%
437006 E-RATE REIMBURSEMENT
00155370 437006 E-RATE REIMB 0 0 0 .00 .00 .00 .0%
TOTAL E-RATE REIMBURSEMENT 0 0 0 .00 .00 .00 .0%
437016 BIKE PROFIT SHARE FEE
00185370 437016 BIKE SHARE FEE 0 0 0 .00 .00 .00 .0%
TOTAL BIKE PROFIT SHARE FEE 0 0 0 .00 .00 .00 .0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 14
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
437017 BIKE ADVERTISING FEE
00145370 437017 BIKE ADVERTISIN -32,400 0 -32,400 .00 .00 -32,400.00 .0%
TOTAL BIKE ADVERTISING FEE -32,400 0 -32,400 .00 .00 -32,400.00 .0%
437018 VEHICLE INSPECTIONS FEE
00401320 437018 VEHICLE INSPECT 0 0 0 .00 .00 .00 .0%
TOTAL VEHICLE INSPECTIONS FEE 0 0 0 .00 .00 .00 .0%
445013 SEALING FEES
00429450 445013 SEALING FEES 0 0 0 .00 .00 .00 .0%
TOTAL SEALING FEES 0 0 0 .00 .00 .00 .0%
TOTAL FEES -1,850,033 -740 -1,850,773 -1,273,317.59 .00 -577,455.41 68.8%
TOTAL REVENUES -1,850,033 -740 -1,850,773 -1,273,317.59 .00 -577,455.41
11 RENTALS
436000 RENTAL INCOME
00127360 436000 RENTALS MUNICIP 0 0 0 .00 .00 .00 .0%
00157360 436000 RENTALS -5,400 0 -5,400 -900.00 .00 -4,500.00 16.7%
00182360 436000 RENTAL INCOME 0 0 0 .00 .00 .00 .0%
00293360 436000 RENTALS -22,000 4,500 -17,500 -15,055.60 .00 -2,444.40 86.0%
00401360 436000 RENTALS 0 0 0 -70,000.00 .00 70,000.00 100.0%
TOTAL RENTAL INCOME -27,400 4,500 -22,900 -85,955.60 .00 63,055.60 375.4%
436100 BUILDING USE REVENUE
00182360 436100 RENTALS -62,244 0 -62,244 -39,309.00 .00 -22,935.00 63.2%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 15
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
00401320 436100 BUILDING USE RE 0 0 0 -7,900.00 .00 7,900.00 100.0%
00610360 436100 BUILDING USE RE 0 0 0 .00 .00 .00 .0%
TOTAL BUILDING USE REVENUE -62,244 0 -62,244 -47,209.00 .00 -15,035.00 75.8%
TOTAL RENTALS -89,644 4,500 -85,144 -133,164.60 .00 48,020.60 156.4%
TOTAL REVENUES -89,644 4,500 -85,144 -133,164.60 .00 48,020.60
16 OTHER DEPT REVENUE
437001 PLANNING AND ZONING/BOA REV.
00176370 437001 BOARD OF APPEAL 0 0 0 .00 .00 .00 .0%
00181370 437001 PLANNING AND ZO -100,000 0 -100,000 -20,298.28 .00 -79,701.72 20.3%
TOTAL PLANNING AND ZONING/BOA REV. -100,000 0 -100,000 -20,298.28 .00 -79,701.72 20.3%
437004 COMMISSION ON MACHINES
00100370 437004 COMMISSION ON M 0 0 0 .00 .00 .00 .0%
00138370 437004 COMMISSION ON M 0 0 0 .00 .00 .00 .0%
TOTAL COMMISSION ON MACHINES 0 0 0 .00 .00 .00 .0%
TOTAL OTHER DEPT REVENUE -100,000 0 -100,000 -20,298.28 .00 -79,701.72 20.3%
TOTAL REVENUES -100,000 0 -100,000 -20,298.28 .00 -79,701.72
17 LICENSES AND PERMITS
441001 CLUB RESTR LIC-7 DAY
00165410 441001 CLUB RESTR LIC- -24,000 0 -24,000 -24,000.00 .00 .00 100.0%
TOTAL CLUB RESTR LIC-7 DAY -24,000 0 -24,000 -24,000.00 .00 .00 100.0%
441002 COMMON VICTUALLERS
00165410 441002 COMMON VICTUALL -68,000 0 -68,000 -77,400.00 .00 9,400.00 113.8%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 16
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL COMMON VICTUALLERS -68,000 0 -68,000 -77,400.00 .00 9,400.00 113.8%
441003 INNHOLDER LICENSE
00165410 441003 INNHOLDER LICEN -10,500 0 -10,500 -6,750.00 .00 -3,750.00 64.3%
TOTAL INNHOLDER LICENSE -10,500 0 -10,500 -6,750.00 .00 -3,750.00 64.3%
441004 MALT & WINES EDC INT
00165410 441004 MALT & WINES ED -3,500 0 -3,500 -3,500.00 .00 .00 100.0%
TOTAL MALT & WINES EDC INT -3,500 0 -3,500 -3,500.00 .00 .00 100.0%
441005 MALT BEV & WINE STOR
00165410 441005 MALT BEV & WINE -20,000 0 -20,000 -22,500.00 .00 2,500.00 112.5%
TOTAL MALT BEV & WINE STOR -20,000 0 -20,000 -22,500.00 .00 2,500.00 112.5%
441006 MALT BEV/WINE RESTRN
00165410 441006 MALT BEV/WINE R -42,000 0 -42,000 -36,700.00 .00 -5,300.00 87.4%
TOTAL MALT BEV/WINE RESTRN -42,000 0 -42,000 -36,700.00 .00 -5,300.00 87.4%
441007 PACKAGE STORE LIC
00165410 441007 PACKAGE STORE L -77,000 0 -77,000 -73,500.00 .00 -3,500.00 95.5%
TOTAL PACKAGE STORE LIC -77,000 0 -77,000 -73,500.00 .00 -3,500.00 95.5%
441008 RESTAURANT LIC-LIQUR
00165410 441008 RESTAURANT LIC- -392,000 0 -392,000 -375,387.00 .00 -16,613.00 95.8%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 17
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL RESTAURANT LIC-LIQUR -392,000 0 -392,000 -375,387.00 .00 -16,613.00 95.8%
441009 SPEC ALCOHOL LICENSE
00165410 441009 SPEC ALCOHOL LI -10,000 0 -10,000 -17,350.00 .00 7,350.00 173.5%
TOTAL SPEC ALCOHOL LICENSE -10,000 0 -10,000 -17,350.00 .00 7,350.00 173.5%
441010 FARMER POURER
00165410 441010 FARMER POURER -6,000 0 -6,000 -6,000.00 .00 .00 100.0%
TOTAL FARMER POURER -6,000 0 -6,000 -6,000.00 .00 .00 100.0%
441020 NON-INTOXICATING BEVERAGES
00165410 441020 NON-INTOXICATIN 0 0 0 .00 .00 .00 .0%
TOTAL NON-INTOXICATING BEVERAGES 0 0 0 .00 .00 .00 .0%
442001 AUCTIONEER LICENSE
00161420 442001 AUCTIONEER LICE 0 0 0 .00 .00 .00 .0%
TOTAL AUCTIONEER LICENSE 0 0 0 .00 .00 .00 .0%
442002 AUTO AMUSM'T DEVICE
00161420 442002 AUTO AMUSM'T DE -110 0 -110 .00 .00 -110.00 .0%
TOTAL AUTO AMUSM'T DEVICE -110 0 -110 .00 .00 -110.00 .0%
442003 BILL/POOL/BOWL/ LIC
00161420 442003 BILL/POOL/BOWL/ -110 -110 -220 -220.00 .00 .00 100.0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 18
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL BILL/POOL/BOWL/ LIC -110 -110 -220 -220.00 .00 .00 100.0%
442004 BUILDERS LICENSE
00187420 442004 BUILDERS LICENS 0 0 0 .00 .00 .00 .0%
TOTAL BUILDERS LICENSE 0 0 0 .00 .00 .00 .0%
442005 CLOSE OUT SALE
00161420 442005 CLOSE OUT SALE 0 0 0 .00 .00 .00 .0%
TOTAL CLOSE OUT SALE 0 0 0 .00 .00 .00 .0%
442006 CONSTABLES LICENSE
00161420 442006 CONSTABLES LICE -825 0 -825 -495.00 .00 -330.00 60.0%
TOTAL CONSTABLES LICENSE -825 0 -825 -495.00 .00 -330.00 60.0%
442007 DANCE LICENSE
00165420 442007 DANCE LICENSE 0 0 0 .00 .00 .00 .0%
TOTAL DANCE LICENSE 0 0 0 .00 .00 .00 .0%
442008 DOG KENNEL LICENSE
00161420 442008 DOG KENNEL LICE -60 0 -60 -2,700.00 .00 2,640.00 4500.0%
TOTAL DOG KENNEL LICENSE -60 0 -60 -2,700.00 .00 2,640.00 4500.0%
442009 DOG LICENSE
00161420 442009 DOG LICENSE -45,788 0 -45,788 -23,760.00 .00 -22,028.00 51.9%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 19
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL DOG LICENSE -45,788 0 -45,788 -23,760.00 .00 -22,028.00 51.9%
442010 DRAINLAYER LICENSE
00161420 442010 DRAINLAYER LICE -15,125 0 -15,125 -3,025.00 .00 -12,100.00 20.0%
TOTAL DRAINLAYER LICENSE -15,125 0 -15,125 -3,025.00 .00 -12,100.00 20.0%
442011 ENTERTAINMENT LIC
00165420 442011 ENTERTAINMENT L -58,750 0 -58,750 -62,450.00 .00 3,700.00 106.3%
TOTAL ENTERTAINMENT LIC -58,750 0 -58,750 -62,450.00 .00 3,700.00 106.3%
442012 FUNERAL DIRECT LICS
00512420 442012 FUNERAL DIRECT 0 0 0 .00 .00 .00 .0%
TOTAL FUNERAL DIRECT LICS 0 0 0 .00 .00 .00 .0%
442013 HAWKER/PEDDLER LICN
00161420 442013 HAWKER/PEDDLER -165 0 -165 .00 .00 -165.00 .0%
TOTAL HAWKER/PEDDLER LICN -165 0 -165 .00 .00 -165.00 .0%
442014 JUNK DEALER LICENSE
00161420 442014 JUNK DEALER LIC -1,375 0 -1,375 -275.00 .00 -1,100.00 20.0%
TOTAL JUNK DEALER LICENSE -1,375 0 -1,375 -275.00 .00 -1,100.00 20.0%
442015 LIVERY/ LIMOUSINE
00161420 442015 LIVERY/ LIMOUSI 0 0 0 .00 .00 .00 .0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 20
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL LIVERY/ LIMOUSINE 0 0 0 .00 .00 .00 .0%
442016 LODGING LICENSE
00161420 442016 LODGING LICENS -22,385 0 -22,385 -21,780.00 .00 -605.00 97.3%
TOTAL LODGING LICENSE -22,385 0 -22,385 -21,780.00 .00 -605.00 97.3%
442017 MEDICAL REGISTRATION
00161420 442017 MEDICAL REGISTR 0 0 0 .00 .00 .00 .0%
TOTAL MEDICAL REGISTRATION 0 0 0 .00 .00 .00 .0%
442018 MILK LICENSE
00187420 442018 MILK LICENSE -3,500 0 -3,500 -1,245.00 .00 -2,255.00 35.6%
TOTAL MILK LICENSE -3,500 0 -3,500 -1,245.00 .00 -2,255.00 35.6%
442019 MOVING VANS & PODS
00293420 442019 MOVING VANS & P -95,000 0 -95,000 -59,070.00 .00 -35,930.00 62.2%
TOTAL MOVING VANS & PODS -95,000 0 -95,000 -59,070.00 .00 -35,930.00 62.2%
442020 OUTDOOR PARKING SPAC
00161420 442020 OUTDOOR PARKING -125 0 -125 .00 .00 -125.00 .0%
TOTAL OUTDOOR PARKING SPAC -125 0 -125 .00 .00 -125.00 .0%
442021 OUTDOOR GOODS
00161420 442021 OUTDOOR SEATING -9,000 0 -9,000 -165.00 .00 -8,835.00 1.8%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 21
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL OUTDOOR GOODS -9,000 0 -9,000 -165.00 .00 -8,835.00 1.8%
442022 PHYSICAL THER LICNSE
00187420 442022 PHYSICAL THER L -7,500 0 -7,500 .00 .00 -7,500.00 .0%
TOTAL PHYSICAL THER LICNSE -7,500 0 -7,500 .00 .00 -7,500.00 .0%
442023 PHYSICIANS/ OSTEOPTH
00161420 442023 PHYSICIANS/ OST 0 0 0 -60.00 .00 60.00 100.0%
TOTAL PHYSICIANS/ OSTEOPTH 0 0 0 -60.00 .00 60.00 100.0%
442024 SIGNS AND AWNING
00161420 442024 SIGNS AND AWNIN -2,750 0 -2,750 -550.00 .00 -2,200.00 20.0%
TOTAL SIGNS AND AWNING -2,750 0 -2,750 -550.00 .00 -2,200.00 20.0%
442025 SPORTING LICENSE
00161420 442025 SPORTING LICENS 0 0 0 .00 .00 .00 .0%
TOTAL SPORTING LICENSE 0 0 0 .00 .00 .00 .0%
442026 SWIM POOL LICENSE
00187420 442026 SWIM POOL LICEN -2,000 0 -2,000 -2,160.00 .00 160.00 108.0%
TOTAL SWIM POOL LICENSE -2,000 0 -2,000 -2,160.00 .00 160.00 108.0%
442027 TAXI STAND LIC
00161420 442027 TAXI STAND LIC 0 0 0 .00 .00 .00 .0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 22
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL TAXI STAND LIC 0 0 0 .00 .00 .00 .0%
442028 TAXICAB MEDALLION
00161420 442028 TAXICAB MEDALLI -5,795 0 -5,795 -915.00 .00 -4,880.00 15.8%
00210420 442028 TAXICAB MEDALLI 0 0 0 -425.00 .00 425.00 100.0%
TOTAL TAXICAB MEDALLION -5,795 0 -5,795 -1,340.00 .00 -4,455.00 23.1%
442029 USED CAR DEALER LIC
00161420 442029 USED CAR DEALER -27,225 0 -27,225 -21,175.00 .00 -6,050.00 77.8%
TOTAL USED CAR DEALER LIC -27,225 0 -27,225 -21,175.00 .00 -6,050.00 77.8%
442030 BOTTLE REDEMPTION
00161420 442030 BOTTLE REDEMPTI 0 0 0 .00 .00 .00 .0%
TOTAL BOTTLE REDEMPTION 0 0 0 .00 .00 .00 .0%
442031 FORTUNE TELLER
00161420 442031 FORTUNE TELLER 0 0 0 .00 .00 .00 .0%
00165420 442031 FORTUNE TELLER 0 0 0 .00 .00 .00 .0%
TOTAL FORTUNE TELLER 0 0 0 .00 .00 .00 .0%
442032 URBAN AGRICULTURE LICENSE
00512420 442032 URBAN AGRICULTU 0 -75 -75 -75.00 .00 .00 100.0%
TOTAL URBAN AGRICULTURE LICENSE 0 -75 -75 -75.00 .00 .00 100.0%
442033 BOA MOBILE FOOD VENDOR
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 23
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
00161420 442033 BOA MOBILE FOOD 0 0 0 .00 .00 .00 .0%
TOTAL BOA MOBILE FOOD VENDOR 0 0 0 .00 .00 .00 .0%
442034 SMALL WIRELESS LICENSE
00161420 442034 SMALL WIRELESS -13,500 0 -13,500 -11,880.00 .00 -1,620.00 88.0%
00403420 442034 SMALL WIRELESS 0 0 0 .00 .00 .00 .0%
TOTAL SMALL WIRELESS LICENSE -13,500 0 -13,500 -11,880.00 .00 -1,620.00 88.0%
442035 BIOSAFETY LICENSE
00187420 442035 BIOSAFETY LICEN 0 0 0 -5,800.00 .00 5,800.00 100.0%
TOTAL BIOSAFETY LICENSE 0 0 0 -5,800.00 .00 5,800.00 100.0%
442036 SHORT TERM RENTAL REGIST LICEN
00187420 442036 SHORT TERM RENT 0 -7,050 -7,050 -10,100.00 .00 3,050.00 143.3%
TOTAL SHORT TERM RENTAL REGIST LICEN 0 -7,050 -7,050 -10,100.00 .00 3,050.00 143.3%
442037 OUTDOOR SEATING LICENSE
00165420 442037 OUTDOOR SEATING 0 -1,800 -1,800 -18,200.00 .00 16,400.00 1011.1%
TOTAL OUTDOOR SEATING LICENSE 0 -1,800 -1,800 -18,200.00 .00 16,400.00 1011.1%
442038 PRIVATE OUTDOOR SEAT 1ST TIME
00165420 442038 PRIVATE OUTDOOR 0 0 0 .00 .00 .00 .0%
TOTAL PRIVATE OUTDOOR SEAT 1ST TIME 0 0 0 .00 .00 .00 .0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 24
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
442039 SIDEWALK SEATING 1ST TIME
00165420 442039 SIDEWALK SEATIN 0 0 0 .00 .00 .00 .0%
TOTAL SIDEWALK SEATING 1ST TIME 0 0 0 .00 .00 .00 .0%
442040 PARKLET SEATING 1ST TIME
00165420 442040 PARKLET SEATING 0 0 0 .00 .00 .00 .0%
TOTAL PARKLET SEATING 1ST TIME 0 0 0 .00 .00 .00 .0%
445001 BURIAL PERMITS
00512450 445001 BURIAL PERMITS -3,325 0 -3,325 -1,075.00 .00 -2,250.00 32.3%
TOTAL BURIAL PERMITS -3,325 0 -3,325 -1,075.00 .00 -2,250.00 32.3%
445002 DUMPSTER CONTRACTORS
00187450 445002 DUMPSTER CONTRA -1,500 0 -1,500 -330.00 .00 -1,170.00 22.0%
TOTAL DUMPSTER CONTRACTORS -1,500 0 -1,500 -330.00 .00 -1,170.00 22.0%
445003 EXPLOSIVE STOR FLAMB
00220450 445003 EXPLOSIVE STOR -25,000 0 -25,000 -32,745.00 .00 7,745.00 131.0%
TOTAL EXPLOSIVE STOR FLAMB -25,000 0 -25,000 -32,745.00 .00 7,745.00 131.0%
445004 EXTENDED RETAIL HOUR
00161450 445004 EXTENDED RETAIL -6,050 0 -6,050 -1,815.00 .00 -4,235.00 30.0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 25
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL EXTENDED RETAIL HOUR -6,050 0 -6,050 -1,815.00 .00 -4,235.00 30.0%
445005 FLAMMABLE PERMIT
00161450 445005 FLAMMABLE PERMI -12,100 0 -12,100 -165.00 .00 -11,935.00 1.4%
TOTAL FLAMMABLE PERMIT -12,100 0 -12,100 -165.00 .00 -11,935.00 1.4%
445006 GARAGE PERMITS
00161450 445006 GARAGE PERMITS -33,275 0 -33,275 -3,630.00 .00 -29,645.00 10.9%
TOTAL GARAGE PERMITS -33,275 0 -33,275 -3,630.00 .00 -29,645.00 10.9%
445007 MARRIAGE PERMIT
00161450 445007 MARRIAGE PERMIT -17,500 0 -17,500 -18,950.00 .00 1,450.00 108.3%
TOTAL MARRIAGE PERMIT -17,500 0 -17,500 -18,950.00 .00 1,450.00 108.3%
445008 POLICE REVOLVER PERM
00210450 445008 POLICE REVOLVER -6,000 0 -6,000 -3,675.00 .00 -2,325.00 61.3%
TOTAL POLICE REVOLVER PERM -6,000 0 -6,000 -3,675.00 .00 -2,325.00 61.3%
445009 RAFFLE/BAZAAR PERMIT
00161450 445009 RAFFLE/BAZAAR P -60 0 -60 .00 .00 -60.00 .0%
TOTAL RAFFLE/BAZAAR PERMIT -60 0 -60 .00 .00 -60.00 .0%
445011 RESIDENT PARK PERMIT
00293450 445011 RESIDENT PARK P -1,967,433 0 -1,967,433 -913,205.00 .00 -1,054,228.00 46.4%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 26
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL RESIDENT PARK PERMIT -1,967,433 0 -1,967,433 -913,205.00 .00 -1,054,228.00 46.4%
445012 RETAIL&FOOD PERMIT
00187450 445012 RETAIL&FOOD PER 0 -29,400 -29,400 -57,580.00 .00 28,180.00 195.9%
00512450 445012 RETAIL&FOOD PER 0 0 0 .00 .00 .00 .0%
TOTAL RETAIL&FOOD PERMIT 0 -29,400 -29,400 -57,580.00 .00 28,180.00 195.9%
445014 SWORN WEIGHER
00161450 445014 SWORN WEIGHER 0 0 0 .00 .00 .00 .0%
TOTAL SWORN WEIGHER 0 0 0 .00 .00 .00 .0%
445015 UNDERGROUD TANK REMV
00220450 445015 UNDERGROUD TANK -1,000 0 -1,000 .00 .00 -1,000.00 .0%
TOTAL UNDERGROUD TANK REMV -1,000 0 -1,000 .00 .00 -1,000.00 .0%
445016 BUSINESS PARK PERMIT
00293450 445016 BUSINESS PARK P 0 0 0 .00 .00 .00 .0%
TOTAL BUSINESS PARK PERMIT 0 0 0 .00 .00 .00 .0%
445017 OTHER PARK PERMITS
00293450 445017 OTHER PARK PERM 0 0 0 .00 .00 .00 .0%
TOTAL OTHER PARK PERMITS 0 0 0 .00 .00 .00 .0%
445018 FIELD USAGE PERMIT
00630450 445018 FIELD USAGE PER -85,000 0 -85,000 -50,723.25 .00 -34,276.75 59.7%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 27
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL FIELD USAGE PERMIT -85,000 0 -85,000 -50,723.25 .00 -34,276.75 59.7%
448001 ALARM HOOKUP FEE
00402480 448001 ALARM HOOKUP FE 0 0 0 .00 .00 .00 .0%
TOTAL ALARM HOOKUP FEE 0 0 0 .00 .00 .00 .0%
448002 BUILDING PERMIT
00187480 448002 BUILDING PERMIT -8,500,000 0 -8,500,000 -7,892,038.59 .00 -607,961.41 92.8%
TOTAL BUILDING PERMIT -8,500,000 0 -8,500,000 -7,892,038.59 .00 -607,961.41 92.8%
448003 BURNER PERMIT
00187480 448003 BURNER PERMIT 0 0 0 .00 .00 .00 .0%
TOTAL BURNER PERMIT 0 0 0 .00 .00 .00 .0%
448004 DUMPSTER PERMIT
00187480 448004 DUMPSTER PERMIT -75,000 0 -75,000 -56,095.39 .00 -18,904.61 74.8%
TOTAL DUMPSTER PERMIT -75,000 0 -75,000 -56,095.39 .00 -18,904.61 74.8%
448005 ELECTRICAL PERMIT
00187480 448005 ELECTRICAL PERM -460,000 0 -460,000 -247,433.50 .00 -212,566.50 53.8%
00402480 448005 ELECTRICAL PERM 0 0 0 .00 .00 .00 .0%
TOTAL ELECTRICAL PERMIT -460,000 0 -460,000 -247,433.50 .00 -212,566.50 53.8%
448006 GAS PERMIT
00187480 448006 GAS PERMIT -40,000 0 -40,000 -26,190.00 .00 -13,810.00 65.5%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 28
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL GAS PERMIT -40,000 0 -40,000 -26,190.00 .00 -13,810.00 65.5%
448007 GRANT OF LOCATION
00161480 448007 GRANT OF LOCATI -30,250 0 -30,250 -9,307.00 .00 -20,943.00 30.8%
TOTAL GRANT OF LOCATION -30,250 0 -30,250 -9,307.00 .00 -20,943.00 30.8%
448008 HOUSING CERTIFICATE
00187480 448008 HOUSING CERTIFI 0 -55 -55 -220.00 .00 165.00 400.0%
TOTAL HOUSING CERTIFICATE 0 -55 -55 -220.00 .00 165.00 400.0%
448009 INSPECTION
00187480 448009 INSPECTION -45,000 0 -45,000 -21,293.00 .00 -23,707.00 47.3%
TOTAL INSPECTION -45,000 0 -45,000 -21,293.00 .00 -23,707.00 47.3%
448010 OCCUPANCY PERMIT
00187480 448010 OCCUPANCY PERMI -50,000 0 -50,000 -51,393.00 .00 1,393.00 102.8%
00403480 448010 OCCUPANCY PERMI 0 0 0 .00 .00 .00 .0%
TOTAL OCCUPANCY PERMIT -50,000 0 -50,000 -51,393.00 .00 1,393.00 102.8%
448011 PLUMBING PERMIT
00187480 448011 PLUMBING PERMIT -200,000 0 -200,000 -69,460.00 .00 -130,540.00 34.7%
TOTAL PLUMBING PERMIT -200,000 0 -200,000 -69,460.00 .00 -130,540.00 34.7%
448012 SIDEWALK OPENING
00401480 448012 SIDEWALK OPENIN 0 0 0 .00 .00 .00 .0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 29
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
00403480 448012 SIDEWALK OPENIN -560,000 0 -560,000 -294,250.00 .00 -265,750.00 52.5%
00405480 448012 SIDEWALK OPENIN 0 0 0 .00 .00 .00 .0%
TOTAL SIDEWALK OPENING -560,000 0 -560,000 -294,250.00 .00 -265,750.00 52.5%
448013 TRENCH PERMITS
00403480 448013 TRENCH PERMITS 0 0 0 .00 .00 .00 .0%
TOTAL TRENCH PERMITS 0 0 0 .00 .00 .00 .0%
448014 DRIVEWAY PERMIT
00403480 448014 DRIVEWAY PERMIT 0 0 0 .00 .00 .00 .0%
TOTAL DRIVEWAY PERMIT 0 0 0 .00 .00 .00 .0%
448015 SHEET METAL PERMIT
00187480 448015 SHEET METAL PER 0 0 0 .00 .00 .00 .0%
TOTAL SHEET METAL PERMIT 0 0 0 .00 .00 .00 .0%
448016 ZONING COMPLIANCE PERMIT
00187480 448016 ZONING COMPLIAN -35,000 0 -35,000 .00 .00 -35,000.00 .0%
TOTAL ZONING COMPLIANCE PERMIT -35,000 0 -35,000 .00 .00 -35,000.00 .0%
448017 ENGINEERING SITE PERMIT
00403480 448017 ENGINEERING SIT -30,000 0 -30,000 .00 .00 -30,000.00 .0%
TOTAL ENGINEERING SITE PERMIT -30,000 0 -30,000 .00 .00 -30,000.00 .0%
477007 OPEN AIR VENDOR
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 30
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
00161770 477007 OPEN AIR VENDOR 0 0 0 .00 .00 .00 .0%
TOTAL OPEN AIR VENDOR 0 0 0 .00 .00 .00 .0%
TOTAL LICENSES AND PERMITS -13,147,581 -38,490 -13,186,071 -10,641,185.73 .00 -2,544,885.27 80.7%
TOTAL REVENUES -13,147,581 -38,490 -13,186,071 -10,641,185.73 .00 -2,544,885.27
19 FINES AND FORFEITS
432009 FALSE ALARM FINE
00210320 432009 FALSE ALARM FIN -30,000 0 -30,000 -10,500.00 .00 -19,500.00 35.0%
TOTAL FALSE ALARM FINE -30,000 0 -30,000 -10,500.00 .00 -19,500.00 35.0%
468003 COURT FINES
00820680 468003 COURT FINES -1,000 500 -500 -125.00 .00 -375.00 25.0%
TOTAL COURT FINES -1,000 500 -500 -125.00 .00 -375.00 25.0%
468006 MASS COURT MOVING VIOLATN
00820680 468006 MASS COURT MOVI -40,000 0 -40,000 -34,751.01 .00 -5,248.99 86.9%
TOTAL MASS COURT MOVING VIOLATN -40,000 0 -40,000 -34,751.01 .00 -5,248.99 86.9%
477001 PARKING FINES
00293770 477001 PARKING FINES -4,783,644 0 -4,783,644 -3,745,812.05 .00 -1,037,831.95 78.3%
TOTAL PARKING FINES -4,783,644 0 -4,783,644 -3,745,812.05 .00 -1,037,831.95 78.3%
477002 PARKING FINE SURCHAG
00293770 477002 PARKING FINE SU -20,000 0 -20,000 -21,140.00 .00 1,140.00 105.7%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 31
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL PARKING FINE SURCHAG -20,000 0 -20,000 -21,140.00 .00 1,140.00 105.7%
477003 LIBRARY FINES
00610770 477003 LIBRARY FINES 0 -537 -537 -1,296.48 .00 759.48 241.4%
TOTAL LIBRARY FINES 0 -537 -537 -1,296.48 .00 759.48 241.4%
477005 LANDCOURT/RECORDING
00145770 477005 LANDCOURT/RECOR 0 0 0 .00 .00 .00 .0%
TOTAL LANDCOURT/RECORDING 0 0 0 .00 .00 .00 .0%
477006 ORDINANCE VIOLATIONS
00145770 477006 ORDINANCE VIOLA 0 0 0 -111,025.14 .00 111,025.14 100.0%
00161770 477006 ORDINANCE VIOLA -250,000 0 -250,000 -237,819.99 .00 -12,180.01 95.1%
00191770 477006 ORDINANCE VIOLA 0 0 0 .00 .00 .00 .0%
TOTAL ORDINANCE VIOLATIONS -250,000 0 -250,000 -348,845.13 .00 98,845.13 139.5%
477008 TRANSIENT VENDOR
00161770 477008 TRANSIENT VENDO 0 0 0 .00 .00 .00 .0%
TOTAL TRANSIENT VENDOR 0 0 0 .00 .00 .00 .0%
477009 RESTITUTION
00210770 477009 RESTITUTION 0 0 0 .00 .00 .00 .0%
00293770 477009 RESTITUTION 0 0 0 .00 .00 .00 .0%
TOTAL RESTITUTION 0 0 0 .00 .00 .00 .0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 32
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
477010 RMV NON RENEWAL SURCHARGE
00145770 477010 RMV NON RENEWAL 0 0 0 -34,652.91 .00 34,652.91 100.0%
00293770 477010 RMV NON RENEWAL -20,000 -4,270 -24,270 -21,140.00 .00 -3,130.00 87.1%
TOTAL RMV NON RENEWAL SURCHARGE -20,000 -4,270 -24,270 -55,792.91 .00 31,522.91 229.9%
477011 TOBACCO FINES
00512770 477011 TOBACCO FINES 0 0 0 .00 .00 .00 .0%
TOTAL TOBACCO FINES 0 0 0 .00 .00 .00 .0%
477012 CHAPTER148A,SEC5
00145770 477012 CHAPTER148A,SEC 0 0 0 .00 .00 .00 .0%
TOTAL CHAPTER148A,SEC5 0 0 0 .00 .00 .00 .0%
477013 DELINQUENT PARKING TICKET REC
00293770 477013 DELINQUENT PARK 0 0 0 .00 .00 .00 .0%
TOTAL DELINQUENT PARKING TICKET REC 0 0 0 .00 .00 .00 .0%
477014 EXPIRED REG & SAFETY INSPECT
00293770 477014 EXPIRED REG & S 0 0 0 .00 .00 .00 .0%
TOTAL EXPIRED REG & SAFETY INSPECT 0 0 0 .00 .00 .00 .0%
484005 TOWING CHARGES
00210800 484005 TOWING CHARGES -20,000 0 -20,000 .00 .00 -20,000.00 .0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 33
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL TOWING CHARGES -20,000 0 -20,000 .00 .00 -20,000.00 .0%
TOTAL FINES AND FORFEITS -5,164,644 -4,307 -5,168,951 -4,218,262.58 .00 -950,688.42 81.6%
TOTAL REVENUES -5,164,644 -4,307 -5,168,951 -4,218,262.58 .00 -950,688.42
20 INVESTMENT INCOME
482000 INVESTMENT INCOME
00145800 482000 INVESTMENT INCO -2,321,526 0 -2,321,526 -234,432.32 .00 -2,087,093.68 10.1%
00145820 482000 INTEREST 0 0 0 -1,979,280.78 .00 1,979,280.78 100.0%
TOTAL INVESTMENT INCOME -2,321,526 0 -2,321,526 -2,213,713.10 .00 -107,812.90 95.4%
TOTAL INVESTMENT INCOME -2,321,526 0 -2,321,526 -2,213,713.10 .00 -107,812.90 95.4%
TOTAL REVENUES -2,321,526 0 -2,321,526 -2,213,713.10 .00 -107,812.90
21 MISC RECURRING
437005 DPW RECYCLING REVENUE
00126370 437005 DPW RECYCLING R 0 0 0 .00 .00 .00 .0%
00401370 437005 DPW RECYCLING 0 0 0 .00 .00 .00 .0%
00406320 437005 DPW RECYCLING R 0 0 0 .00 .00 .00 .0%
TOTAL DPW RECYCLING REVENUE 0 0 0 .00 .00 .00 .0%
437007 VENDOR REBATES/REFUNDS
00100370 437007 VENDOR REBATES/ -5,000 0 -5,000 -11,018.93 .00 6,018.93 220.4%
00138370 437007 VENDOR REBATES/ 0 0 0 .00 .00 .00 .0%
00401370 437007 VENDOR REBATES/ 0 0 0 .00 .00 .00 .0%
TOTAL VENDOR REBATES/REFUNDS -5,000 0 -5,000 -11,018.93 .00 6,018.93 220.4%
454001 MEDICARE REIMBURSEMNT RDS
00810540 454001 MEDICARE REIMBU 0 0 0 .00 .00 .00 .0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 34
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL MEDICARE REIMBURSEMNT RDS 0 0 0 .00 .00 .00 .0%
468007 MEDICAID REIMBURSEMNT DMA
00820680 468007 MEDICAID REIMBU -400,000 0 -400,000 -301,912.26 .00 -98,087.74 75.5%
TOTAL MEDICAID REIMBURSEMNT DMA -400,000 0 -400,000 -301,912.26 .00 -98,087.74 75.5%
468009 C OF M REIMB C-O-L-A
00820680 468009 C OF M REIMB C- 0 0 0 .00 .00 .00 .0%
TOTAL C OF M REIMB C-O-L-A 0 0 0 .00 .00 .00 .0%
468010 C OF M REIMBURSEMENT
00820680 468010 C OF M REIMBURS 0 0 0 .00 .00 .00 .0%
TOTAL C OF M REIMBURSEMENT 0 0 0 .00 .00 .00 .0%
468011 REIMBURSEMENT - MISC.
00820680 468011 REIMBURSEMENT - 0 -245,108 -245,108 -245,108.00 .00 .00 100.0%
TOTAL REIMBURSEMENT - MISC. 0 -245,108 -245,108 -245,108.00 .00 .00 100.0%
483000 DONATIONS
00145800 483000 DONATIONS 0 0 0 .00 .00 .00 .0%
TOTAL DONATIONS 0 0 0 .00 .00 .00 .0%
484000 MISCELLANEOUS REVENUE
00100800 484000 GENERAL GOV MIS 0 0 0 -28,942.93 .00 28,942.93 100.0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 35
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
00127800 484000 MISCELLANEOUS R 0 0 0 -90.00 .00 90.00 100.0%
00138800 484000 MISCELLANEOUS R 0 0 0 .00 .00 .00 .0%
00145800 484000 MISCELLANEOUS R -10,163 0 -10,163 -29.92 .00 -10,133.08 .3%
00157800 484000 MISCELLANEOUS R 0 0 0 .00 .00 .00 .0%
00181800 484000 MISCELLANEOUS R 0 0 0 .00 .00 .00 .0%
00187800 484000 MISCELLANEOUS R 0 0 0 -50.00 .00 50.00 100.0%
00210800 484000 MISCELLANEOUS R 0 0 0 .00 .00 .00 .0%
00220800 484000 MISCELLANEOUS R 0 0 0 .00 .00 .00 .0%
00293800 484000 MISCELLANEOUS R 0 0 0 179.99 .00 -179.99 100.0%
00401480 484000 MISCELLANEOUS R 0 0 0 .00 .00 .00 .0%
00403800 484000 MISCELLANEOUS R 0 0 0 -76.25 .00 76.25 100.0%
00910800 484000 MISCELLANEOUS R 0 0 0 .00 .00 .00 .0%
TOTAL MISCELLANEOUS REVENUE -10,163 0 -10,163 -29,009.11 .00 18,846.11 285.4%
484001 PRIOR YEAR REIMBURSEMENTS
00100800 484001 PRIOR YEAR REIM 0 -38,801 -38,801 -6,755.88 .00 -32,045.12 17.4%
00127800 484001 PRIOR YEAR REIM 0 0 0 .00 .00 .00 .0%
00138800 484001 PRIOR YEAR REIM 0 0 0 .00 .00 .00 .0%
00145800 484001 PRIOR YEAR REIM 0 0 0 -6,643.13 .00 6,643.13 100.0%
00151800 484001 PRIOR YEAR REIM 0 0 0 .00 .00 .00 .0%
00152800 484001 PRIOR YEAR REIM 0 0 0 -175.78 .00 175.78 100.0%
00157800 484001 PRIOR YEAR REIM 0 0 0 .00 .00 .00 .0%
00181800 484001 PRIOR YEAR REIM 0 0 0 .00 .00 .00 .0%
00187800 484001 PRIOR YEAR REIM 0 0 0 .00 .00 .00 .0%
00210800 484001 PRIOR YEAR REIM 0 0 0 -128.18 .00 128.18 100.0%
00220800 484001 PRIOR YEAR REIM 0 0 0 .00 .00 .00 .0%
00293800 484001 PRIOR YEAR REIM 0 0 0 .00 .00 .00 .0%
00512800 484001 PRIOR YEAR REIM 0 0 0 -1,625.00 .00 1,625.00 100.0%
00543800 484001 PRIOR YEAR REIM 0 0 0 .00 .00 .00 .0%
00610800 484001 PRIOR YEAR REIM 0 0 0 -83.99 .00 83.99 100.0%
00910800 484001 PRIOR YEAR REIM 0 0 0 .00 .00 .00 .0%
0115552 484001 PRIOR YEAR REIMB 0 0 0 .00 .00 .00 .0%
TOTAL PRIOR YEAR REIMBURSEMENTS 0 -38,801 -38,801 -15,411.96 .00 -23,389.04 39.7%
484002 PROCEEDS FROM AUCTION
00100800 484002 PROCEEDS FROM A 0 0 0 .00 .00 .00 .0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 36
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
00210800 484002 PROCEEDS FROM A 0 0 0 .00 .00 .00 .0%
TOTAL PROCEEDS FROM AUCTION 0 0 0 .00 .00 .00 .0%
484003 INSURANCE REIMBURSEMENT
00100800 484003 INSURANCE REIMB 0 0 0 .00 .00 .00 .0%
TOTAL INSURANCE REIMBURSEMENT 0 0 0 .00 .00 .00 .0%
484004 SETTLEMENT OF CLAIMS
00100800 484004 SETTLEMENT OF C 0 0 0 .00 .00 .00 .0%
00151800 484004 SETTLEMENT OF C 0 0 0 .00 .00 .00 .0%
TOTAL SETTLEMENT OF CLAIMS 0 0 0 .00 .00 .00 .0%
484010 MISC GRANT REIMBURSEMENT
00100800 484010 MISC GRANT REIM 0 0 0 .00 .00 .00 .0%
TOTAL MISC GRANT REIMBURSEMENT 0 0 0 .00 .00 .00 .0%
484012 BANK REVENUE SHARE
00145800 484012 BANK REVENUE SH 0 -12,539 -12,539 -18,936.66 .00 6,397.66 151.0%
TOTAL BANK REVENUE SHARE 0 -12,539 -12,539 -18,936.66 .00 6,397.66 151.0%
484016 MVE PRIOR 2001
00145800 484016 MVE PRIOR 2001 0 0 0 .00 .00 .00 .0%
TOTAL MVE PRIOR 2001 0 0 0 .00 .00 .00 .0%
484017 MISC REBATE
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 37
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
00152800 484017 MISC REBATE 0 0 0 .00 .00 .00 .0%
TOTAL MISC REBATE 0 0 0 .00 .00 .00 .0%
484018 WYNN CASINO PAYMENT
00145800 484018 WYNN CASINO PAY -250,000 0 -250,000 -250,000.00 .00 .00 100.0%
TOTAL WYNN CASINO PAYMENT -250,000 0 -250,000 -250,000.00 .00 .00 100.0%
484020 GEN GOV MISC REIMBURSEMENT
00293800 484020 GEN GOV MISC RE 0 0 0 -424.80 .00 424.80 100.0%
TOTAL GEN GOV MISC REIMBURSEMENT 0 0 0 -424.80 .00 424.80 100.0%
494002 SALE OF SURPLUS EQUIPMENT
00138900 494002 SALE OF SURPLUS 0 0 0 -448.00 .00 448.00 100.0%
TOTAL SALE OF SURPLUS EQUIPMENT 0 0 0 -448.00 .00 448.00 100.0%
494003 SALE OF VEHICLES
00138900 494003 SALE OF VEHICLE 0 0 0 .00 .00 .00 .0%
TOTAL SALE OF VEHICLES 0 0 0 .00 .00 .00 .0%
494004 WASTE MANAGEMENT RECYCLIN
00138900 494004 WASTE MANAGEMEN 0 0 0 .00 .00 .00 .0%
TOTAL WASTE MANAGEMENT RECYCLIN 0 0 0 .00 .00 .00 .0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 38
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL MISC RECURRING -665,163 -296,448 -961,611 -872,269.72 .00 -89,341.28 90.7%
TOTAL REVENUES -665,163 -296,448 -961,611 -872,269.72 .00 -89,341.28
22 MISC NON-RECURRING
484014 ABANDONED PROPERTY REVENUE
00145800 484014 ABANDONED PROPE 0 0 0 .00 .00 .00 .0%
TOTAL ABANDONED PROPERTY REVENUE 0 0 0 .00 .00 .00 .0%
484500 MISCELLANEOUS NON-RECURRING
00145800 484500 MISCELLANEOUS N 0 0 0 .00 .00 .00 .0%
00152800 484500 MISCELLANEOUS N 0 0 0 .00 .00 .00 .0%
00512800 484500 MISCELLANEOUS N 0 0 0 .00 .00 .00 .0%
TOTAL MISCELLANEOUS NON-RECURRING 0 0 0 .00 .00 .00 .0%
484501 MISC NON RECUR GLX INT REFUND
00145800 484501 MISC NON RECUR 0 0 0 .00 .00 .00 .0%
TOTAL MISC NON RECUR GLX INT REFUND 0 0 0 .00 .00 .00 .0%
484502 MISC NON RECUR OPIOD SETTLEM
00145800 484502 MISC NON RECUR 0 0 0 .00 .00 .00 .0%
TOTAL MISC NON RECUR OPIOD SETTLEM 0 0 0 .00 .00 .00 .0%
493000 PREMIUM FROM SALE OF BOND
00900900 493000 PREMIUM FROM SA 0 0 0 .00 .00 .00 .0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 39
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL PREMIUM FROM SALE OF BOND 0 0 0 .00 .00 .00 .0%
494005 SALE OF BUILDING
00138900 494005 SALE OF BUILDIN 0 0 0 .00 .00 .00 .0%
TOTAL SALE OF BUILDING 0 0 0 .00 .00 .00 .0%
TOTAL MISC NON-RECURRING 0 0 0 .00 .00 .00 .0%
41 PROPERTY TAXES
411000 PERSONAL PROPERTY TAXES
00145110 411000 PERSONAL PROPER 0 0 0 -6,304,403.89 .00 6,304,403.89 100.0%
TOTAL PERSONAL PROPERTY TAXES 0 0 0 -6,304,403.89 .00 6,304,403.89 100.0%
412000 REAL ESTATE TAXES
00145110 412000 REAL ESTATE TAX -242,405,936 -2,422,594-244,828,530-161,190,325.91 .00 -83,638,204.09 65.8%
TOTAL REAL ESTATE TAXES -242,405,936 -2,422,594-244,828,530-161,190,325.91 .00 -83,638,204.09 65.8%
414200 TAX TITLE REDEEMED
00145142 414200 R/E TAX TITLE R 0 0 0 -201,965.66 .00 201,965.66 100.0%
TOTAL TAX TITLE REDEEMED 0 0 0 -201,965.66 .00 201,965.66 100.0%
414201 TAX LIENS REDEEMED - WANG
00145142 414201 TAX LIENS REDEE 0 0 0 .00 .00 .00 .0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 40
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL TAX LIENS REDEEMED - WANG 0 0 0 .00 .00 .00 .0%
414400 DEFERRED TAX
00145147 414400 DEFERRED TAX 0 0 0 -11,820.01 .00 11,820.01 100.0%
TOTAL DEFERRED TAX 0 0 0 -11,820.01 .00 11,820.01 100.0%
414500 TAX FORECLOSURE REDEMPTN
00145145 414500 TAX FORECLOSURE 0 0 0 .00 .00 .00 .0%
TOTAL TAX FORECLOSURE REDEMPTN 0 0 0 .00 .00 .00 .0%
TOTAL PROPERTY TAXES -242,405,936 -2,422,594-244,828,530-167,708,515.47 .00 -77,120,014.53 68.5%
TOTAL REVENUES -242,405,936 -2,422,594-244,828,530-167,708,515.47 .00 -77,120,014.53
45 FEDERAL REVENUES
454002 OTHER FEDERAL DIRECT
00810540 454002 OTHER FEDERAL 0 0 0 .00 .00 .00 .0%
TOTAL OTHER FEDERAL DIRECT 0 0 0 .00 .00 .00 .0%
TOTAL FEDERAL REVENUES 0 0 0 .00 .00 .00 .0%
46 STATE REVENUE
461002 STATE REIM ABATE SURV SPS
00820610 461002 STATE REIM ABAT -219,702 0 -219,702 -9,282.00 .00 -210,420.00 4.2%
TOTAL STATE REIM ABATE SURV SPS -219,702 0 -219,702 -9,282.00 .00 -210,420.00 4.2%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 41
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
461003 STATE REIM ABATE ELDERLY
00820610 461003 STATE REIM ABAT 0 0 0 .00 .00 .00 .0%
TOTAL STATE REIM ABATE ELDERLY 0 0 0 .00 .00 .00 .0%
462001 SCHOOL AID CHAPTER 70
00820610 462001 SCHOOL AID CHAP -21,245,048 0 -21,245,048 -10,622,520.00 .00 -10,622,528.00 50.0%
TOTAL SCHOOL AID CHAPTER 70 -21,245,048 0 -21,245,048 -10,622,520.00 .00 -10,622,528.00 50.0%
462004 CONSTRUCTION OF SCHL PROJ
00820610 462004 CONSTRUCTION OF 0 0 0 .00 .00 .00 .0%
TOTAL CONSTRUCTION OF SCHL PROJ 0 0 0 .00 .00 .00 .0%
462005 CHARTER SCHOOL REIMBURSMT
00820610 462005 CHARTER SCHOOL -1,887,397 -116,935 -2,004,332 -834,136.00 .00 -1,170,196.00 41.6%
TOTAL CHARTER SCHOOL REIMBURSMT -1,887,397 -116,935 -2,004,332 -834,136.00 .00 -1,170,196.00 41.6%
466000 UNRESTRICTED GEN GOVT AID
00820610 466000 UNRESTRICTED GE -30,121,177 0 -30,121,177 -15,060,588.00 .00 -15,060,589.00 50.0%
TOTAL UNRESTRICTED GEN GOVT AID -30,121,177 0 -30,121,177 -15,060,588.00 .00 -15,060,589.00 50.0%
466001 POLICE CAREER INCENTIVE
00820610 466001 POLICE CAREER I 0 0 0 .00 .00 .00 .0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 42
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL POLICE CAREER INCENTIVE 0 0 0 .00 .00 .00 .0%
466003 VETERANS AND BENEFITS
00820610 466003 VETERANS AND BE -79,485 0 -79,485 -58,056.71 .00 -21,428.29 73.0%
TOTAL VETERANS AND BENEFITS -79,485 0 -79,485 -58,056.71 .00 -21,428.29 73.0%
466004 LOCAL AID FUND
00820610 466004 LOCAL AID FUND 0 0 0 .00 .00 .00 .0%
TOTAL LOCAL AID FUND 0 0 0 .00 .00 .00 .0%
466005 LOTTERY & BEANO
00820610 466005 LOTTERY & BEANO 0 0 0 .00 .00 .00 .0%
TOTAL LOTTERY & BEANO 0 0 0 .00 .00 .00 .0%
466009 GF-SUPPLMNT HH - LOTTERY
00820610 466009 GF-SUPPLMNT HH 0 0 0 .00 .00 .00 .0%
TOTAL GF-SUPPLMNT HH - LOTTERY 0 0 0 .00 .00 .00 .0%
468008 C OF M MISC
00820680 468008 C OF M MISC 0 0 0 .00 .00 .00 .0%
TOTAL C OF M MISC 0 0 0 .00 .00 .00 .0%
468014 STATE QUALIFIED BONDS
00820680 468014 STATE QUALIFIED 0 0 0 .00 .00 .00 .0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 43
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL STATE QUALIFIED BONDS 0 0 0 .00 .00 .00 .0%
TOTAL STATE REVENUE -53,552,809 -116,935 -53,669,744 -26,584,582.71 .00 -27,085,161.29 49.5%
TOTAL REVENUES -53,552,809 -116,935 -53,669,744 -26,584,582.71 .00 -27,085,161.29
49 OTHER FINANCING SOUR
494001 SALE OF FURNITURE
00138900 494001 SALE OF FURNITU 0 0 0 .00 .00 .00 .0%
TOTAL SALE OF FURNITURE 0 0 0 .00 .00 .00 .0%
497001 TRANSFER FROM GEN FUND
00990970 497001 TRANSFER FROM G 0 0 0 .00 .00 .00 .0%
TOTAL TRANSFER FROM GEN FUND 0 0 0 .00 .00 .00 .0%
497002 TRANSFERS FROM SPEC REV
00100800 497002 TRANSFERS FROM 0 0 0 .00 .00 .00 .0%
00990970 497002 TRANSFERS FROM -2,502,191 -30,020 -2,532,211 -2,532,212.03 .00 1.03 100.0%
TOTAL TRANSFERS FROM SPEC REV -2,502,191 -30,020 -2,532,211 -2,532,212.03 .00 1.03 100.0%
497003 TRANSFERS FROM STABILIZATION
00990970 497003 TRANSFERS FROM 0 -335,774 -335,774 -335,774.00 .00 .00 100.0%
TOTAL TRANSFERS FROM STABILIZATION 0 -335,774 -335,774 -335,774.00 .00 .00 100.0%
497004 TRANSFERS FROM CAPITAL
00990970 497004 TRANSFERS FROM 0 0 0 .00 .00 .00 .0%
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 44
FOR 2024 07
ORIGINAL TRANFRS/ REVISED AVAILABLE PCT
APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED
TOTAL TRANSFERS FROM CAPITAL 0 0 0 .00 .00 .00 .0%
497005 TRANSFERS FROM ENTERPRISE
00990970 497005 TRANSFERS FROM -1,590,820 0 -1,590,820 -1,590,820.00 .00 .00 100.0%
TOTAL TRANSFERS FROM ENTERPRISE -1,590,820 0 -1,590,820 -1,590,820.00 .00 .00 100.0%
497006 TRANSFERS FROM TRUST
00990970 497006 TRANSFERS FROM 0 0 0 .00 .00 .00 .0%
TOTAL TRANSFERS FROM TRUST 0 0 0 .00 .00 .00 .0%
TOTAL OTHER FINANCING SOUR -4,093,011 -365,794 -4,458,805 -4,458,806.03 .00 1.03 100.0%
TOTAL REVENUES -4,093,011 -365,794 -4,458,805 -4,458,806.03 .00 1.03
GRAND TOTAL -337,331,956 -3,247,065-340,579,021-223,300,755.25 .00-117,278,265.75 65.6%
** END OF REPORT - Generated by Monique Johnson **
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 45
REPORT OPTIONS
Field # Total Page Break
Sequence 1 10 Y N
Sequence 2 11 Y N
Sequence 3 0 N N
Sequence 4 0 N N
Report title:
YEAR-TO-DATE BUDGET REPORT
Includes accounts exceeding 0% of budget.
Print totals only: N Year/Period: 2024/ 7
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: N
Include requisition amount: N
Print Revenues-Version headings: N
Print revenue as credit: Y
Print revenue budgets as zero: N
Include Fund Balance: N
Print journal detail: N
From Yr/Per: 2020/ 2
To Yr/Per: 2020/ 2
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 0001
Func
Year
Prog/DOEFunc
Dept/Loc
SDeptSubject
Rev DOEPrg
Budget Ctrl
Character Code
Org
Object
Project
Account type Revenue
City of Somerville
YEAR-TO-DATE BUDGET REPORT
Report generated: 02/20/2024 08:48
User: 1278mjohnson
Program ID: glytdbud
Page 46
REPORT OPTIONS
Account status
Rollup Code