Loading...
HomeMy Public PortalAboutmay19financial TOWN OF WATERTOWN �. YEAR-TO-DATE BUDGET REPORT ACCOUNTS FOR: ORIGINAL 000 . PROP .O• . . EXPENDED BUDNFRS/ REVISED GET D 0161051 510111 FULL TIME SALARI 1,469,985 -12,989 1,456,996 1,175,710.62 .00 281,285.38 80.7% 0161051 510112 PART TIME SALARI 502,627 16,600 519,227 421,056.56 .00 98,170.44 81.1% 0161051 510130 OVERTIME 25,000 0 25,000 20,526.95 .00 4,473.05 82.1% 0161051 510141 SHIFT DIFFERENTI 3,719 0 3,719 3,063.75 .00 655.25 82.4% 0161051 510143 LONGEVITY 26,781 -600 26,181 20,843.40 .00 5,337.60 79.6% 0161051 510190 CLOTHING ALLOWAN 2,772 0 2,772 2,762.00 .00 10.00 99.6% TOTAL LIBRARY - PERS. SVCS. 2,030,884 3,011 2,033,895 1,643,963.28 .00 389,931.72 80.8% 0161052 520211 ELECTRICITY 131,404 0 131,404 100,215.40 .00 31,188.60 76.3% 0161052 520213 GAS 35,848 0 35,848 19,501.81 .00 16,346.19 54.4% 0161052 520240 OFFICE EQUIPMENT 9,049 0 9,049 8,370.91 623.14 54.95 99.4% 0161052 520241 BUILDING MAINTEN 38,730 0 38,730 38,159.41 570.00 .59 100.0% 0161052 520244 COMPUTER MAINTEN 90,850 0 90,850 54,701.31 11,039.47 25,109.22 72.4% 0161052 530327 REGIONAL LIBRARY 66,898 0 66,898 66,897.82 .00 .18 100.0% 0161052 530342 COMMUNICATIONS - 1,600 0 1,600 1,480.00 .00 120.00 92.5% 0161052 540421 OFFICE SUPPLIES 12,000 0 12,000 8,311.77 2,931.57 756.66 93.7% 0161052 540422 PRINTING & FORMS 6,000 0 61000 3,511.52 1,647.20 841.28 86.0% 0161052 540430 BUILDING MAINTEN 16,000 0 16,000 8,555.50 4,576.28 2,868.22 82.1% 0161052 550511 BOOKS 405,000 0 405,000 364,219.17 29,380.55 11,400.28 97.2% 0161052 550512 BOOK PROCESSING 58,000 0 58,000 31,901.47 7,585.41 18,513.12 68.1% 0161052 570710 IN STATE TRAVEL 500 0 500 308.73 .00 191.27 61.7% 0161052 570730 DUES & SUBSCRIPT 1,445 0 1,445 1,190.00 .00 255.00 82.4% 0161052 570735 PROJECT LITERACY 62,320 0 62,320 49,182.85 1,888.78 11,248.37 82.0% 0161052 570785 COMMITTEE EXPENS 3,600 0 3,600 942.00 138.00 2,520.00 30.0% 0161052 570787 STAFF DEVELOPMEN 10,000 0 10,000 2,807.28 3,000.00 4,192.72 58.1% TOTAL LIBRARY - EXPENSES 949,244 0 949,244 760,256.95 63,380.40 125,606.65 86.8% MLr/.1�.4ym4wh-WlcAy 4A,Lluu,k 0161058 580840 BUILDING RENOVAT 41,000 0 41,000 29,107.27 .00 11,892.73 71.0% 0161058 580870 REPLACEMENT OF E 14,000 5,451 19,451 8,630.79 .00 10,819.76 44.4% TOTAL LIBRARY - CAPITAL 55,000 5,451 60,451 37,738.06 .00 22,712.49 62.4% Report generated: 05/07/2019 16:44 User: nruggeri-koret Page 1 Program So: glYtdbud TOWN OF WATERTOWN YEAR-TO-DATE BUDGET REPORT ORIGINALACCOUNTS FOR: 0001 GENERAL FUND - TOWN APPROP AD3STMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED TOTAL GENERAL FUND - TOWN 3,035,128 8,462 3,043,590 2,441,958.29 63,380.40 538,250.86 82.3% TOTAL EXPENSES 3.035,128 8,462 3,043,590 2,441,958.29 63,380.40 538,250.86 Report generated: os/07/2019 16:44 Page 2 User: nrug eri-karet Program iU: glyt bud FY19 FUNDS AND GRANTS Available to I Current spend balance lExpended ' available Fund or Grant 7/1/2018 as of 7/1/2018 Deposits YTD YTD balance Notes - --- Book- Funds - - - - - -- - - - -- - - Pratt(includes Pratt Stock) 122,954.39 3,282.61 41962.73 3,282.61 - 80%of int on periodicals - - - - - -- - - . Whitney- - -- -- ---- - 2,639.93 2,639.93 166.39 2_ - -.- --- �-80632- ----- -- --------- Mead 6,480.22 3,480.22 408.41 - i 3,888.63 ---------- Charles - 21118.68 ' 1,918.68- 189.47 133.53 - 2,052.21 =Armenian History books Barry _ -- - - - _ 3,195.62 _ __ _ 3 006.15 ', -3,006.15 - McGuire 2,836.26 j 1,836.26 1 178.75 - t 2,015.01 --423.55� - - - -- - -- - -- - 1 � - - 4,011.90 W. Pierce � 22,588.35 2,588.35 MacDonald Y - 7,987.75 2,987.75 503.431 - 3,491.18 Grief related books 6,983 77 471.63 - 7,455.40 Fiction O'Reilly-- -- - ---7,483.77- --- --- -------- -- - - ---- - - y Stone 2,968.48 - . - - -- ----------- --- - --- -------�------------�-------2,968.48 -- 188.51 ----- -- _ .. - 3,156.99 __ Campbell- - 4 342.83 3 -- - - - - - --- 342.83_ 275.02 - 3,617.85 Large print books Santoro 1, - 115.31 - 344.77 Art _Brown 1 1,656.10 -- - 656.10 - --- ---- --- ------� - - - --- --- - 104.36 - 760.46 Sci-fi books , Keith -- -- -- --- 3,309.34 -- ------- - - -------- - ---- --- -_ -- -- -- - - - 2,309.34 208.57 - 2,517.91 Wat history books -- - - 2,381.24 - 2,531.32 Humanities books Drucker 2 381.24 150.08 Special Gifts - - - - 4,946.69 _ 4,946.69 5,231.23 2,639.15 7,538.77 Unrestricted -Cohen and 9,982.48-_- - - 9,982.48 288.66 9,693.82 Cookbook and Mysteries - , Makerspace Fund 4,388.66 4,388.66 100.00 ,- . 3 928.38 , 560.28 ;Makerspace materials -- - --__- � - r Other Funds& Grants _ - KavenY 31,172.38 r_ _ 2,800.89 1,944.23 804.53 3,940.59 Benefit of the library - Masters--------- 31610.41 f 903.41 227.52 - t 1,130.93 Trustees discretion B. Pierce 1,805.36 1,805.36 113.78 - 1,919.14 Trustees discretion -- ------ - - ------ -- -- - - -- ---- 60,798.98 -28,038.25 - - - - ---- _ _ 125 027.29 Revolving Printing Account 17 459.87 17 459.87 15_37.5.5_8-II - , 9 t - -- _ � 4,674.06 28,161.39 ; Friends of Project Literacy Fundraising 9,461.39 t 9,461.39 - _� _ y _ '_ g- _ _ _ - 25,052.00 24,582.69- 9,930.70 � McCall Gift Fund - - ---73,169.79 , 73,169.79 r - 5,196.84 67,972.95 For children's dept only GRIFFIN FUND REPORT CASH VERIZON AVAILABLE INTEREST/ INVESTMENT VERIZON STOCK CASH HELD FOR MONTH ENDING BEG BAL ADDED WITHDRAWN DIVIDENDS MKT VAL ADJ DIVIDENDS MKT VAL AD1 END BAL FOR INV SPENDING INV FY18 BAL FWD 168,272.12 $ 168,272.12 $ 1,573.88 $ 6,762.75 $ 159,935.49 31-Jul 168,272.12 7.24 114.76 - 4,228.07 $ 172,622.19 $ 8,458.63 $ 164,163.56 31-Aug 172,622.19 26.51 40.79 1,875.61 8,678.67 $ 183,243.77 $ 750.24 $ 9,651.30 $ 172,842.23 30-Sep 183,243.77 25.29 (53.03) 3,115.42 $ 186,331.45 $ - $ 10,373.80 $ 175,957.65 31-Oct 186,331.45 14.30 (77.46) - 11,762.30 $ 198,030.59 $ - $ 10,310.64 $ 187,719.95 30-Nov 198,030.59 60.68 103.02 1,875.61 10,204.59 $ 210,274.49 $ 750.24 $ 11,599.71 $ 197,924.54 31-Dec 210,274.49 (3,067. ) 15.55 (77.54) (16,052.84) $ 191,092.54 $ (3,067.12) $ 12,287.96 $ 181,871.70 31-Jan 191,092.54 5.58 139.16 (3,752.60) $ 187,484.68 $ - $ 9,365.58 $ 178,119.10 28-Feb 187,484.68 1,976.57 63.05 6,017.10 $ 195,541.40 $ - $ 11,405.20 $ 184,136.20 31-Mar 195,541.40 33.31 142.84 7,149.35 $ 202,866.90 $ - $ 11,581.35 $ 191,285.55 30-Apr 202,866.90 $ 202,866.90 $ - $ 11,581.35 $ 191,285.55 31-May 202,866.90 $ 202,866.90 $ - $ 11,581.35 $ 191,285.55 30-Jun 202,866.90 $ 202,866.90 $ - $ 11,581.35 $ 191,285.55 FY19 TOTAL - (3,067.12) 2,165.03 395.59 3,751.22 32,350.06 $ 202,866.90 - 11,581.35 $ 191,285.55 FUNDS USED.TO PURCHASE ADDITIONAL SHARES J Burke FY19 Munis Teen.Mat. Teen.Prog. Child.Mat. Child.Prog. Adult Mat. Adult Prog. Museums Mov.Lic $27,086.28 $27,086.28 $2,708.28 $2,700.00 $1,354.00 $81563.00 $1,354.00 $3,957.00 $5,000.00 $1,450.00 i PO or Check# Date Vendor/Description Spent as of 518/2019 $26.296.76 $2,693.24 $2,699.95 $1,345.95 $8,521.00 $1,296.86 $3,531.28 $4,670.00 $1,538.48 Balance of Accounts as of 518/2019 5789.52 $15.04 $0.05 $8.05 $42.00 $57.14 $425.72 $330.00 $88.48 FY 19 Hatch Financials Starting Available Budget=carry over from FY18 Starting available Budget $ 17,506.57 f spreadsheet+the Town Budget funds dedicated to Hatch.This number is static. Additional FY19 Hatch Funding Approvals $ 500.00 -` Additional FY19 Hatch Spending Approvals=any new funds designated to Hatch in FY19.This is a variable Expenditures To Date By Fund number. It will only increase if new funds are Special Gifts $ 4,048.38 allocated. LIG/MEG $ 316.05 Building Committee $ 4,214.85 Expenditures are tracked on a separate Town Budget $ 6,600.06 ✓ spreadsheet by account.The Trustees will receive YTD Total Expenditure $ 15,179.34 ` this item tracking spreadsheet quarterly. Current Available Budget by Fund Special Gifts $ 340.28 LIG/MEG $ 0.60 Building Committee $ 1,886.41 Town Budget $ 599.94 Total Current Available $ 2,827.23 Accrued FY19 Hatch Spending Budget=total funds Accrued FY19 Hatch Spending Budget $ 18,006.57 available to spend on Hatch throughout FY19 by Total Spent $ 15,179.34 adding lines 3 and 5. Remaining Balance $ 2,827.23 Remaining Balance=Starting Available Budget for FY20 from non-town budget sources