Loading...
HomeMy Public PortalAboutSept20Financial FY21 YEAR TO DATE BUDGET REPORT ORG OBJ ACCOUNT DESCRIPTION ORIGINAL APPROP TRANFRS/ADJSMTS REVISED BUDGET YTD EXPENDED ENCUMBRANCES AVAILABLE BUDGET %USED 0161051 510111 FULL TIME SALARIES 1,550,350 0 1,550,350 249,930.60 0.00 1,300,419 16.10 0161051 510112 PART TIME SALARIES 624,176 0 624,176 76,810.02 0.00 547,366 12.30 0161051 510130 OVERTIME 25,000 0 25,000 3,522.85 0.00 21,477 14.10 0161051 510141 SHIFT DIFFERENTIAL 3,719 0 3,719 388.75 0.00 3,330 10.50 U161051 510143 LONGEVITY 31,971 0 31,971 6,834.12 0.00 25,137 21.40 ❑161051 510190 CLOTHING ALLOWANCE 2,771 0 2,771 1,381.00 0.00 1,390 49.80 Total 0161051 LIBRARY-PERS.SVCS. 2,237,987 0 2,237,987 338,867.34 0.00 1,899,120 15.10 0161052 520211 ELECTRICITY 139,406 0 139;406. 22,734.08 91,265.92 25,406 81.80 0161052 520213 GAS 38,031 0 38,031 763.40 23,236.60 14,031 63.10 0161052 520240 OFFICE EQUIPMENT MAINTENANCE 17,383 0 17,383 1,752.62 3,367.70 12,263 1-9,50 0161052 520241 BUILDING MAINTENANCE 43,500 0 43,500 701.50 7,368.50 35,430 18.60 0161052 520244 COMPUTER MAINTENANCE 91,025 0 91,025 25,633.17 42,557.01 22,835 74.90 ❑151052 530327 REGIONAL LIBRARY SERVICES 72,650 0 72,650 71,570.00 1,080.00 0 100.00 0161052 530342 COMMUNICATIONS-POSTAGE 1,600 0 1,600 0.00 1,600.00 0 1w.00 0161052 530383 PROGRAM SERVICES 6,500 0 6,500 300.00 0.00 6,200 4.60 0161052 540421 OFFICE SUPPLIES 12,000 0 12,000 1,135.84 4,805.27 6,059 49.50 0161052 540422 PRINTING&FORMS 6,300 0 6,300 0.00 0.00 6,300 0.00 0161052 540425 PROGRAM SUPPLIES 500 0 500 24.80 0.00 475 5.00 0161052 540430 BUILDING MAINTENANCE SUP. 17,000 0 17,000 68.42 4,419.98 12,512 26.40 0161052 550511 BOOKS 415,000 0 415,000 40,572.64 198,858.45 175,569 57.70 0161052 550512 BOOK PROCESSING 41,500 0 41,500 3,806.33 11,202.93 26,491 36.20 0161052 570710 IN STATE TRAVEL 500 0 500 0.00 0.00 500 0.30 0161052 570730 DUES&SUBSCRIPTIONS 1,250 0 1,250 0.00 1,250.00 0 100.00 0161052 570735 PROJECT LITERACY/TOWN 8,635 0 8,635 27.88 172.12 8,435 2.30 0161052 570785 COMMITTEE EXPENSES 3,600 0 3,600 0.00 450.00 3,150 12.50 0161052 570787 STAFF DEVELOPMENT 10,000 0 10,000 0.00 1,450.00 8,550 14.50 Total 0161052 LIBRARY-EXPENSES 926,380 0 926,380 169,090.68 393,084.48 364,205 60.70 I01.61058 580840 BUILDING RENOVATIONS 49,000 0 49,000 2,764.48 -2,764.48 49,000 0.00 0161058 580870 REPLACEMENT OF EQUIPMENT 20,000 0 20,000 0.00 0.00 20,000 0.00 Total 0161058 LIBRARY-CAPITAL 69,000 0 69,000 2,764.48 -2,764.48 69,000 0.06 Grand Total 3,233,367 0 3,233,367 510,722.50 390,320.00 2,332,325 27.901 FY21 FUNDS AND GRANTS Available to Current spend balance Expended available Fund or Grant 7/1/2020 as of 7/1/2020 Deposits YTD YTD balance Notes Book Funds Pratt(includes Pratt Stock) 131,412.14 TBD 1,469.97 - #VALUE! 80%of in_t on periodicals Whitney 3,135.84 3,135.84 49.15 - 3,184.99 Mead 7,293.30 4,293.30 123.46 - 4,416.76 _ Charles __ 2,450.15 2,250.15 39.44 - 2,289.59 Armenian Histo books Barry 3,476.48 3,476.48 55.97 - 3,532.45 McGuire 2,812.35 1,812.35 61.39 - 1,873.74 W. Pierce 24,625.70 4,625.70 420.70 - 5,046.40 MacDonald 8,740.34 3,740.34 155.20 - 3,895.54 Grief related books O'Reilly _ _ _ _ 8,654.58 8,154.58 139.33 - 8,293.91 Fiction Stone 3,434.46 3,434.46 55.30 _ - 3,489.76 Campbell 5,023.72 4,023.72 80.87 - 4,104.59 Large print books Santoro 2,115.68 515.68 34.07 - 549.75 Art Brown 2,382.85 1,382.85 39.28 - 1,422.13 Sci-fi books Keith 3,827.13 . 2,827.13 61.61 - 2,888.74 Wat history books Drucker 2,753.80 2,753.80 44.32 - 2,798.12 Humanities books Special Gifts 68,983.73 68,983.73 _ 1,290.47 - 70,274.20 Unrestricted -Cohen Fund 9,185.14 9,185.14 - 9,185.14 Cookbook and Mysteries - Makers ace Fund 2,654.33 2,654.33 - - 2,654.33 Makerspace materials Other Funds&Grants Kaveny 34,321.37 5,949.88 552.53 - 6,502.41 Benefit of the library Masters 4,175.25 1,468.25 67.22 . 1,535.47 Trustees discretion B. Pierce 2,009.71 __ 2,009.71 32.35 2,042.06 Trustees discretion LIG/MEG 147,300.00 147,300.00 10,559.97 136,740.03 Revolving Printing Account 13,674.67 13,674.67 - 47.62 13,627.05 Friends of Project Literacy Fund_ raising 5,952.04 5,952.04 - 561.75 5,390.29 MCCaII Gift Fund 59,417.30 59,417.30 - 379.96 59,037.34 For children's dept only FY20 GRIFFIN REPORT CASH VERIZON AVAILABLE MONTH INTEREST/ INVESTMENT VERIZON STOCK CASH HELD FOR ENDING BEG BAL ADDED WITHDRAWN DIVIDENDS MKT VALADJ DIVIDENDS MKTVALADJ END BAL FORINV SPENDING INV FY18 BAL FWD 199,515.95 $ 199,515.95 $ $ 14,700.40 $ 184,815.55 31-Jul 199,515.95 16.01 (28.16) (6,019.10) $ 193,484.70 $ 14,688.25 $ 178,796.45 31-Aug 193,484.70 1,995.19 (5.63) 9,436.35 $ 204,910.61 $ $ 16,677.81 $ 188,232.80 30-Sep 204,910.61 54.80 73.46 7,117.00 $ 212,155.87 $ $ 16,806.07 $ 195,349.80 31-Oct 212,155.87 18.63 27.56 355.85 $ 212,557.91 $ $ 16,852.26 $ 195,705.65 30-Nov 212,557.91 2,016.63 69.04 (834.05) $ 213,809.53 $ $ 18,937.93 $ 194,871.60 31-Dec 213,809.53 27.88 165.30 3,842.60 $ 217,845.31 $ $ 19,131.11 $ 198,714.20 31-Jan 217,845.31 7.83 163.43 (6,340.60) $ 211,675.97 $ $ 19,302.37 $ 192,373.60 28-Feb 211,675.97 10,000.00 2,048.99 (389.41) (17,080.80) $ 206,254.75 $ $ 30,961.95 $ 175,292.80 31-Mar 206,254.75 94.10 (216.47) (1,391.05) $ 204,741.33 $ $ 30,839.58 $ 173,901.75 30-Apr 204,741.33 40.80 12,034.21 1,036.94 $ 217,853.28 $ $ 42,914.59 $ 174,938.69 31-May 217,853.28 2,022.16 (226.46) 284.88 S 219,933.86 $ $ 44,710.29 $ 175,223.57 30-Jun 219,933.86 59.35 (7,278.75) (115.25) $ 212,599.21 $ $ 37,490.89 $ 175,108.32 FY19 TOTAL 10,000.00 - 8,402.37 4,388.12 (9,707.23) S 212,599.21 37,490.89 $ 175,108.32 FUNDS USED TO PURCHASE ADDITIONAL SHARES FY21 GRIFFIN REPORT CASH VERIZON AVAILABLE MONTH INTEREST/ INVESTMENT VERIZON STOCK CASH HELD FOR ENDING BEG BAL ADDED WITHDRAWN DIVIDENDS MKT VALADJ DIVIDENDS MKT VAL ADJ END BAL FOR INV SPENDING INV FY20 BAL FWD 199,515.95 $ 199,515.95 $ $ 14,700.40 $ 184,815.55 31-Jul 199,515.95 16.01 (28.16) (6,019.10) $ 193,484.70 $ 14,688.25 $ 178,796.45 31-Aug $ - $ $ 14,688.25 $ 178,796.45 (193,484.70) 30-Sep $ $ $ 14,688.25 $ 178,796.45 (193,484.70) 31-Oct $ $ $ 14,688.25 $ 178,796.45 (193,484.70) 30-Nov $ $ $ 14,688.25 $ 178,796.45 (193,484.70) 31-Dec $ $ $ 14,688.25 $ 178,796.45 (193,484.70) 31-Jan $ $ $ 14,688.25 $ 178,796.45 (193,484.70) 28-Feb $ $ $ 14,688.25 $ 178,796.45 (193,484.70) 31-Mar $ $ $ 14,688.25 $ 178,796.45 (193,484.70) 30-Apr $ $ $ 14,688.25 $ 178,796.45 (193,484.70) 31-May $ $ $ 14,688.25 $ 178,796.45 (193,484.70) 30-Jun $ $ $ 14,688.25 $ 178,796.45 (193,484.70) FY21 TOTAL 16.01 (28.16) (6,019.10) $ 193,484.70 14,688.25 $ 178,796.45 FUNDS USED TO PURCHASE ADDITIONAL SHARES Burke FY21 Munis Teen-Mat. Teen_Prog. Child Mat. Child.Prog Adult Mat_ Adult Prog. Museums Mav Lic $27,148.40 $27.148.00 $2.715.00 $2.560.00 $1.358.00 $8.702.00 11.358.00 S3.915.00 $5.000.00 $1.540.00, PO or Check# Date Vendoifflescription Spent as of 8/2812020 $667.07 $0.00 SU7.07 $0.00 $0.00 $0.00, S0.00 SO.00 $0.00 Accounts as of 823RO20 $26 480.93 52,715.00 $1,892.93 $1,358.00 $8,702.00 $1.358.00 S3,915.00 $5.000.00 $1,540.00 FY21 HATCH FINANCIALS Adjustments (new funds July 1 Allocation added) Encumbrances Expenditures Available funds Special Gifts $ 594.33 $ - $ $ $ 594.33 LIG/MEG $ - $ - $ - $ $ - Building Committee $ 503.17 $ - $ $ $ 503.17 Watertown Commuty Foundation Grant* $ 60.00 $ - $ - $ - $ 60.00 Town Budget: Equip. Maint. $ 13,534.00 $ - $ 1,656.42 $ (528.74) $ 12,406.32 Town Budget: Printing $ 300.00 $ $ - $ - $ 300.00 Town Budget: Programming $ 2,000.00 $ - $ - $ (24.80) $ 2,024.80 Totals $ 16,991.50 $ $ 1,656.42 $ (553.54) $ 15,888.62