{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":98,"n_cols":18,"rows_kept":98,"cut":false,"hidden":false,"merged":[[0,1,0,14],[18,2,18,14]]}
[null,"Beach Walk Financials January 2017 thru December 2017"]
["Banking",null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[1010,"Checking Account"]
[null,"Beginning Balance",6959.36,23915.8,25298.400000000001,15690.03,26872.33,15620.02,11466.86,21267.79,20927.62,18284.849999999999,31072.58,28914.34]
[null,"Ending Balance",23915.8,25298.400000000001,15690.03,26872.33,15620.02,11466.86,21267.79,20927.62,18284.849999999999,31072.58,28914.34,33746.51]
[null,"Net Change",16956.439999999999,1382.6000000000022,-9608.3700000000008,11182.300000000001,-11252.310000000001,-4153.16,9800.93,-340.17000000000189,-2642.7700000000004,12787.730000000003,-2158.2400000000016,4832.1700000000019,0]
[]
[1020,"Reserve Savings"]
[null,"Beginning Balance",24397.83,24398.66,24399.41,24400.240000000002,24401.040000000001,24401.87,27402.720000000001,33015.31,33016.43,36853.65,36854.9,36856.11]
[null,"Ending Balance",24398.66,24399.41,24400.240000000002,24401.040000000001,24401.87,27402.720000000001,33015.31,33016.43,36853.65,36854.9,36856.11,36857.360000000001]
[null,"Net Change",0.82999999999810825,0.75,0.83000000000174623,0.7999999999992724,0.82999999999810825,3000.8500000000022,5612.5899999999965,1.1200000000026193,3837.2200000000012,1.25,1.2099999999991269,1.25,0]
[]
[1030,"Special Assessment "]
[null,"Beginning Balance",148366.26,87681.72,55114.55,35608.089999999997,35609.26,35610.47,32611.59,27001.040000000001,27001.96,23166.720000000001,23167.51,23168.27]
[null,"Ending Balance",87681.72,55114.55,35608.089999999997,35609.26,35610.47,32611.59,27001.040000000001,27001.96,23166.720000000001,23167.51,23168.27,23169.06]
[null,"Net Change",-60684.540000000008,-32567.17,-19506.460000000006,1.1700000000055297,1.2099999999991269,-2998.880000000001,-5610.5499999999993,0.91999999999825377,-3835.239999999998,0.78999999999723514,0.76000000000203727,0.79000000000087311,0]
[]
[179723.45,"Total Assests",135996.18,104812.36,75698.36,86882.63,75632.36,71481.17,81284.14,80946.010000000009,78305.22,91094.99,88938.72,93772.93,0]
[null,null,"Beachwalk Financials January 2017 thru December 2017"]
[null,null,null,null,40606,null,null,37604,null,null,37157,null,null,38441]
["Income",null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YTD","Budgeted",null,"Remaining"]
[100,"Monthly HOA Dues",25716,7419,7471,20982,9624,6998,21862,8303,6992,21414,10051,6976,153808,148580,null,-5228]
[106,"Interest",4.29,3.58,2.37,1.97,2.04,1.97,2.04,2.04,1.98,2.04,1.97,2.04,28.329999999999995,0]
[102,"Key Card Income",null,null,null,null,null,null,null,null,null,10,null,null,10,0]
[101,"Late Fee",30,10,40,10,10,40,0,null,10,10,10,10,180,0]
[103,"Clubhouse Reservation",null,null,null,null,null,null,null,null,null,0,0,null,0,0]
[106,"Legal Fee Income",null,null,null,null,null,null,null,null,null,0,0,null,0]
[null,"Total Income",25750.29,7432.58,7513.37,20993.97,9636.0400000000009,7039.97,21864.04,8305.0400000000009,7003.98,21436.04,10062.969999999999,6988.04,154026.32999999999]
[null,null,null,33135,40606,61588,71212,78210,100072,108375,115367,136781,146832,153808]
[]
[]
[null,null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YTD","Budgeted",null,"Variance"]
["Operating Expenses"]
[300,"Management Fees",750,750,750,750,750,750,750,750,750,750,750,750,9000,9000,null,0]
[301,"Flag Expense",56.88,0,0,null,null,null,95.73,null,null,0,null,null,152.61000000000001,275,null,122.38999999999999]
[302,"Strom Water Routine Maint.",0,456.04,228.02,null,456.04,228.02,336.92,228.02,null,456.04,228.02,null,2617.1200000000003,4000,null,1382.8799999999997]
[303,"Meeting Expense",0,0,0,null,null,null,null,null,null,0,null,null,0,75,null,75]
[304,"Social",0,0,0,null,100.87,null,200.59,null,151.57,71.33,null,null,524.36,1000,null,475.64]
[305,"Other Expense",45,0,0,null,null,null,null,45,360.62,58.85,null,null,509.47,3000,null,2490.5299999999997]
[306,"Office Expense",293.77,0,0,90.82,null,null,113.07,null,null,371.86,null,null,869.52,1200,null,330.48]
[307,"Pest Control",30,170,30,30,30,30,30,35,35,35,35,35,525,500,null,-25]
[308,"Club House Supplies",0,0,0,null,126.45,null,null,null,null,0,null,null,126.45,500,null,373.55]
[309,"Telephone",105.89,0,52.94,69.44,70.64,70.599999999999994,141.16999999999999,70.58,null,70.58,70.77,70.69,793.3,650,null,-143.29999999999995]
[310,"Grounds Maintenace",6475,0,12950,null,12950,null,6475,3220,5994,5275,10296,null,63635,77700,null,14065]
[311,"Club House/Cabana cleaning",0,200,0,null,450,250,300,200,200,150,null,100,1850,1800,null,-50]
[null,"Basci service",null,null,null,null,null,null,null,null,null,null,null,null,null,null,68608]
[null,"Aeration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2215]
[null,"Servere Pruning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,5500]
[null,"Mulch Palm Behind Club House",null,null,null,null,null,null,null,null,null,null,null,null,null,null,260]
[312,"Pool Services",220,275,220,275,220,700,700,700,700,700,200,220,5130,5728,null,598]
[313,"Pool Chemicals & Supplies",64.52,412.69,148.83000000000001,118.28,633.41999999999996,311.04000000000002,274.02999999999997,404.56,202.65,97.04,69.64,20,2756.7,4488,null,1731.3000000000002]
[314,"Electricity",670.81,1350.93,69.3,657.78,655.66,696.85,770.93,718.22,816.73,693.73,645.49,660.59,8407.02,10000,null,1592.9799999999996]
[315,"Water, Sewer & Trash",144.47,251.49,131.49,262.98,135.5,291.56,201.32,297.76,182.17,155.1,185.62,219.93,2459.39,2080,null,-379.38999999999987]
[316,"Bank Chrages",29.95,0,0,null,null,null,null,null,null,0,0,0,29.95,125,null,95.05]
[317,"Legal & Accounting",0,0,575,null,null,null,null,null,null,0,null,null,575,5000,null,4425]
[318,"Insurance ",0,0,447.2,6270.4,null,null,340.4,null,340,0,null,null,7397.9999999999991,8000,null,602.00000000000091]
[319,"Web Site",0,0,0,null,null,null,null,null,null,0,null,null,0,0,null,0]
[]
[null,"Sub Total",8886.2900000000009,3866.1499999999996,15602.779999999999,8524.7000000000007,16578.580000000002,3328.0699999999997,10729.16,6669.1400000000012,9732.74,8884.5300000000007,12480.54,2076.21,107358.89,135121,null,27762.11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,107358.89]
[]
[null,"Common Area Maintenance",0]
[501,"Pool & Foundation Repairs",0,0,2053.59,0,3738.33,169.06,170.91,150,448.66,0,224.7,565.62,7520.87,7320,null,-200.86999999999989]
[502,"Common Area Maintenance",3.27,0,null,0,0,0,null,null,null,71.94,null,null,75.209999999999994,3445,null,3369.79]
[]
[null,"Total Maintenance",3.27,0,2053.59,0,3738.33,169.06,170.91,150,448.66,71.94,224.7,565.62,7596.08,10765,null,3168.92]
[]
[]
[]
[null,"Operating Expenses",8889.5600000000013,3866.1499999999996,17656.37,8524.7000000000007,20316.910000000003,3497.1299999999997,10900.07,6819.1400000000012,10181.4,8956.4700000000012,12705.240000000002,2641.83,114954.97,145886,null,33625.03]
[]
[]
[]
["Capital Improvement Projects"]
[701.1,"Electrical - On demand Unit",null,null,null,null,1198.4000000000001,null,null,null,null,null,null,null,1198.4000000000001,1000,null,-198.40000000000009]
[702.1,"Garbage disosal",null,null,null,null,null,276.02999999999997,null,null,null,null,null,null,276.02999999999997,780]
[702.2,"Trespassing Signs",null,null,null,null,null,null,null,null,null,null,null,null,0,181]
[702.3,"Awning Over Cabana Door",null,null,null,null,null,null,null,null,null,null,null,null,0,655]
[]
[null,"Total Capital Improvement Cost",0,0,0,0,1198.4000000000001,276.02999999999997,0,0,0,0,0,0,1474.43,2616,null,1141.57]
[]
[]
[null,"Total Operating/Capital Expenses",8889.5600000000013,3866.1499999999996,17656.37,8524.7000000000007,21515.310000000005,3773.16,10900.07,6819.1400000000012,10181.4,8956.4700000000012,12705.240000000002,2641.83,116429.4,148502,null,32072.600000000006]
[]
[]
[]
[]
["Storm Water System Project"]
[4120,"Special Assesment SWS",100,100,100,100,100,50,150,100,100,1147,50,50,2147,2295,null,148]
[700,"Storm Water System Expenses",60688,35281.25,19508,505,345,8325,0,1925,0,416.8,0,0,126994.05]
[]
[]
[]
[null,"Total Monthly Expenses",69577.56,39147.4,37164.369999999995,9029.7000000000007,21860.310000000005,12098.16,10900.07,8744.1400000000012,10181.4,9373.27,12705.240000000002,2641.83,243423.44999999998]
[]
[]
[]
[null,"Notes:"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}