WEBSTER) Forlr Income &Expense through5 5/31/18 INCOME AdValorem' Taxes Personal Taxes Franchise Taxes Fund Balance Appropriated- Town of Webster Budget FY 2017-2018 Revised02/07/18 %used Budget Amount $ 23,000.00 $ 27,500.00 Generals 12,000.00 Misc_s 7,100.00 Repairs_s 3,000.00 Sidewalk Funds 5,000.00 Budget 93.14 $ 996.57 $ 22,003.43 96% 138.07 $ 1,540.49 $ 2,459.51 61% (2,750.95) $ 30,250.95 110% $ 12,000.00 $ 7,100.00 $ 3,000.00 5,000.00 (64.64)$ 64.64 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May 2018Remaining: YTDIncome YTD $2,199.97_ 768.90 $ 2,109.82 $7,040.02 > 6,863.13 $ 2,928.45 $ 4,000.00 $ 312.53 $ 173.64 170.66 208.77 $ 192.08 $176.89 $ 99.33 $ 587.43 9 400.11 $6,807.23 $ 6,720.93 9,391.97 $ 7,330.82 0% 0% 0% 0% Other Income Rental Income Sales& Use Taxes EXPENSES Government Administration Adverising/Legal) Notice $ 100.00 $45.70 Attorney Fees Audit & Accnting Svcs $ 5,174.75 Bonding Fees Council Stipends Co. Interlocal. Agr. Chrg $ 2,000.00 Election Liability Insurance Membership! Dues Plan/1 Train/1 Travel: .00 64.64 $ 8,400.00 $ 350.00 700.00 $700.00 $ 700.00 $ 700.00 $ 700.00 $ 700.00 $ 700.00 $ 700.00 $ 700.00 $ 700.00 $ 1,050.00$ 7,350.00 88% $ 15,000.00 982.84 863.71 $999.40 977.51 $ 978.80 $ 982.50 908.85 931.82 $ 970.83 $ 795.63 $ 2,419.55 $ 3,188.56 $ 11,811.44 79% obal Income 105,000.00 1,645.37 1,801.99 $ 10,877.26 2,655.18 $ 10,701.63 $ 8,722.52 $ 18,040.84 4,659.60 $ 9,589.08 $ 1,895.74 $ 3,350.76 $ 31,060.03 $ 73,939.97 70% Budget Amount Budget May-18/Remaining YTD YTD 392.93 $ 736.82 $6,263.18 89% 54.30 $45.70 46% $ 1,690.00 $4,310.00 72% $5,174.75 100% $590.00 100% 1,000.00 $1,000.00 50% 2,000.00 $0.00 0% $1,720.47 100% 76.00 $1,224.00 94% $ 1,905.00 $95.00 5% %used Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 $ 7,000.00 $589.95 498.69 700.48_$ 867.24 $ 376.77 $ 265.50 $ 350.49 $ 433.24 $ 994.07 $ 793.82 $ 6,000.00 $ 590.00 $ 2,000.00 $ 1,720.47 $ 1,720.47 1,300.00 1,024.00 $ 2,000.00 $ 500.00 $920.00 $ 660.00 $ 9 2,500.00 $1,250.00 $ 630.00 $ 600.00 $ 400.00 $ 300.00 $ 300.00 174.75 $ 1,250.00 $ 340.00 250.00 $ 1,000.00 $ 10,500.00 $ 995.00 $ 500.00 $1,663.25_$ 538.25 $ 538.25 $ 1,684.29 $ 538.25 $ 538.25 $ 1,577.19 $ 538.25 $ 538.25 $ 850.77 $9,649.23 92% 100.00 100.00 $ 95.00 $130.00S (130.00)! Goremment/apenies $ 38,385.22 4,375.12$ 3,998.69 4,663.73$ 1,935.49$ 1,355.02 $ 2,579.79 2,738.74 1,546.24$ 4,216.26 $ 1,732.07 931.18 8,312.89 30,072.33 78% ResidentialSrcs Fire Protection SylvaFD $ 20,500.00 $2 20,457.00 43.00 $ 20,457.00 100% $ 2,200.00 $ 5,535.00 72% $ 1,000.00 5,000.00 1,000.00 $ 704.05 $ 12,544.79 $ 35,690.21 74% 580.96 $ 919.04 61% 5,500.00 $ 0% 173.70 $ 488.60$ 2,511.40 84% 49.23 $ 320.71 679.29 68% 242.14$ 257.86 52% 375.05 $ 7,648.58 $ 6,526.47 47% 21.30 $ 2,610.06 $ 1,991.02 43% Landkcaping/Sidewalk Cleaning 7,735.00 $ 1,350.00 $ 690.00 $690.00 $ 1,360.00 125.00 600.00 720.00 Law Enforcement Rescue Squad- Jackson $ 1,000.00 Sidewalk Fund Street] Lights Webster Cemetery Town Hall Repairs Repair Fund Office Expenses: Utilities: Electric: Apartment Web Page Miscellancous $ 8,000.00 388.00 $ 337.50 $601.50 $ 475.50 $ 525.50 $ 600.50 $ 300.00 $ 600.00 525.00 $ 600.00 $ 300.00 $ 2,746.50 5,253.50 66% 9 5,000.00 404.22 $404.21 $404.11$ 403.99 $ 403.99 $ 403.99 $ 404.00 $ 404.05 $ 404.05 $ 404.05 $ 404.05 555.29$ 4,444.71 89% 0% 0% 0% $ 5,000.00 1,000.00 $ 1,500.00 $ 5,500.00 $ 500.00 $ ToalRenhehalBpaer 48,235.00 2,142.22 1,431.71 1,695.61$ 2,239.49 929.49 1,129.49$ 704.00 $ 21,461.05 $ 1,529.05 $ 1,724.05 $726.44 96.30 $96.30 $ 2,300.00 $ 729.88 $108.74 $108.04 $ 23.90 $ 294.13 $ 36.95 $42.26 $245.99 $ 197.08 $ 219.79 $ 152.12 $ 141.12 2,158.88 94% $ 3,000.00 $ 56.61 $184.05 $298.68 $ 169.86 $ 302.26 $ 278.24 $267.73 $288.79 $ 257.96 233.52 1,000.00 121.93 $105.38 $101.93 $ 62.87 $ 39.31 9 44.57 $ 41.88 $ 44.50 $ 34.34 33.35 $95.92 65.94 9 96.00 $ 12.58 281.32 $ 209.47 Tom/Towak HallEpenses 13,800.00 908.42 $ 1,220.53 508.65 256.63 732.00 $ 359.76 $ 351.87 741.52 585.38 486.66 4,579.78 $ 467.07 $ 24.08 $ 108.97 396.79 $ 291.96 177.48 $ Total Actual: IoapematsiBane $ 7,892.83 $ 6,675.01 $ 6,976.96 $ 4,828.40 $ 3,308.47 $ 4,246.52 $ 3,794.61 $ 23,761.39 $ 6,612.01 $ 4,152.25 July August September October November December January February March April $2,031.58 $ 31,116.32 $74,280.03 71% Checking Account Balance: 1-Vear CDE Balance: 4-Year CDE Balance: Total Town Fund: $ 75,762.13 70,243.59 $75,592.06 $71,171.52 $71,016.08 $75,976.65 $90,830.09 $70,727.75 $74,882.18 $73,216.42 May $ 25,111.16 25,119.91 $25,128.66 25137.13 $25,145.88 $25,154.36 $25,163.12 $25,171.88 $25,179.80 $25,188.57 $72,371.21 $ 37,463.34 37,499.95 $37,536.59 37572.09 $37,608.80 $37,644.36 $37,681.14 $37,717.96 $37,751.25 $37,788.14 $25,197.06 $138,336.63 $1 132,863.45 $138,257.31 $133,880.74 $133,770.76 $138,775.37 $153,674.35 $133,617.59 $137,813.23 $136,193.13 $37,823.87 $135,392.14 3:16PM 06/05/18 TOWN OF WEBSTER Reconciliation Detail Entegra Checking Account, Period Ending 05/31/2018 Type Beginning Balance Cleared Transactions Checks and Payments 22 items Check Check Paycheck Paycheck Check Check Check Check Check Check Check Check Check Check Check Check Check Check Check Check Paycheck Check Deposit Deposit Deposit Deposit Deposit Date Num Name Cir X X X X X Amount Balance 73,216.42 -300.00 -525.00 -981.75 -1,318.82 -1,618.82 -1,918.82 -2,031.16 -2,041.16 -2,761.16 -2,771.69 -3,071.69 -3,443.02 -3,509.90 -3,559.13 -3,591.85 -3,614.15 -3,628.05 -3,674.09 -3,712.57 -3,717.92 -4,174.67 -4,195.97 -4,195.97 700.00 1,490.99 1,584.13 3,212.69 3,350.76 3,350.76 -845.21 72,371.21 -53.16 -102.32 -111.74 -786.74 -824.62 -1,284.62 -1,367.24 -2,276.09 -2,286.09 -2,586.09 -2,686.09 -2,686.09 -2,686.09 69,685.12 -10.00 -466.75 -914.65 -1,133.51 -1,341.30 -1,549.08 -1,756.86 03/07/2018 1209 Josh Yopp 04/04/2018 1218 Josh Yopp 05/01/2018 1221 Tracy RI Rodes 05/01/2018 1220 Joyce! MF Pope 05/01/2018 1222 Matthew Hawkins 05/01/2018 1219 Smith & MorganLa... X 05/15/2018 1225 Smith & Morgan La... -300.00 -225.00 -456.75 -337.07 -300.00 -300.00 -112.34 -10.00 -720.00 -10.53 -300.00 -371.33 -66.88 -49.23 -32.72 -22.30 -13.90 -46.04 -38.48 -5.35 -456.75 -21.30 -4,195.97 700.00 790.99 93.14 1,628.56 138.07 3,350.76 -845.21 -845.21 -53.16 -49.16 -9.42 -675.00 -37.88 -460.00 -82.62 -908.85 -10.00 -300.00 -100.00 -2,686.09 -2,686.09 -3,531.30 -10.00 456.75 -447.90 -218.86 -207.79 -207.78 -207.78 05/02/2018 05/02/2018 05/07/2018 05/07/2018 05/17/2018 05/17/2018 05/17/2018 05/17/2018 05/17/2018 05/17/2018 05/23/2018 05/25/2018 05/30/2018 05/31/2018 05/03/2018 05/14/2018 05/21/2018 05/25/2018 05/29/2018 Norton.Com Google Services Woodard Landscaping WalMart Duke Energy Frontier Duke Energy Duke Energy Duke Energy ADOBE PSNC TWSA WalMart Amazon X X X X X X X X X X X 05/31/2018 1226 Tracy RI Rodes Total Checks and Payments Deposits and Credits 5 items Total Deposits and Credits Total Cleared Transactions Cleared Balance Uncleared Transactions Checks and Payments 11 items Check 07/26/2017 Check 07/26/2017 Check 07/26/2017 Check 07/27/2017 Check 07/27/2017 Check 09/11/2017 Check 10/25/2017 Check 01/16/2018 Check 03/27/2018 Check Check Duke Energy WalMart WalMart Woodard Landscaping TWSA Michele Smith, Attor... United States Treas... US Postmaster 05/15/2018 1224 Josh Yopp 05/15/2018 1223 Jackson County Cha... Total Checks and Payments Total Uncleared Transactions Register Balance as of 05/31/2018 New Transactions Checks and Payments 9i items Check. 06/02/2018 Paycheck Paycheck Liability Check Paycheck Paycheck Paycheck Google Services 06/04/2018 1233 Tracy RF Rodes 06/04/2018 1234 Joyce MF Pope 06/04/2018 E-pay United States Treas... 06/04/2018 1230 Danell AI Moses 06/04/2018 1231 Leigh A) Young 06/04/2018 1229 Billie ME Bryson Page 1 3:16PM 06/05/18 TOWN OF WEBSTER Reconciliation Detail Entegra Checking Account, Period Ending 05/31/2018 Type Paycheck Paycheck Deposit Date Num Name Cir Amount -207.78 -207.78 -2,172.42 700.00 700.00 -1,472.42 -5,003.72 Balance -1,964.64 -2,172.42 -2,172.42 700.00 700.00 -1,472.42 68,212.70 06/04/2018 1228 Allan D Grant 06/04/2018 1232 Richard' WI Fulton Total Checks and Payments Deposits and Credits 1 item Total Deposits and Credits Total New Transactions Ending Balance 06/01/2018 3:16PM 06/05/18 TOWN OF WEBSTER Reconciliation Summary Entegra Checking Account, Period Ending 05/31/2018 May: 31,18 -4,195.97 3,350.76 -845.21 Beginning Balance Cleared Transactions Checks and Payments 22 items Deposits and Credits 5i items Total Cleared Transactions Cleared Balance Uncleared' Transactions Checks and Payments- 11 items Total Uncleared' Transactions Register Balance as of 05/31/2018 New Transactions Checks and Payments 9i items Deposits and Credits -1i item Total New Transactions Ending Balance 73,216.42 72,371.21 -2,686.09 -2,686.09 -2,172.42 700.00 -1,472.42 69,685.12 68,212.70