{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["P&L to Bud","YTD Rev by Type","June Rev by Type","Balance Sheet"],"not_rendered":{"charts":0,"images":8,"macros":0,"external_links":0,"defined_names":400,"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":"P&L to Bud","index":0,"n_rows":45,"n_cols":60,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL"]
[null,null,null,null,null,"Jan 23",null,"Budget",null,"$ Over Budget",null,"% of Budget",null,"Feb 23",null,"Budget",null,"$ Over Budget",null,"% of Budget",null,"Mar 23",null,"Budget",null,"$ Over Budget",null,"% of Budget",null,"Apr 23",null,"Budget",null,"$ Over Budget",null,"% of Budget",null,"May 23",null,"Budget",null,"$ Over Budget",null,"% of Budget",null,"Jun 23",null,"Budget",null,"$ Over Budget",null,"% of Budget",null,"Jan - Jun 23",null,"Budget",null,"$ Over Budget",null,"% of Budget"]
[null,"Ordinary Income/Expense"]
[null,null,null,"Income"]
[null,null,null,null,"40000 · Member Dues and Fees",66850,null,66250,null,{"$f":"ROUND((F5-H5),5)","v":600},null,{"$f":"ROUND(IF(H5=0, IF(F5=0, 0, 1), F5/H5),5)","v":1.0090600000000001},null,65350,null,66250,null,{"$f":"ROUND((N5-P5),5)","v":-900},null,{"$f":"ROUND(IF(P5=0, IF(N5=0, 0, 1), N5/P5),5)","v":0.98641999999999996},null,71300,null,66250,null,{"$f":"ROUND((V5-X5),5)","v":5050},null,{"$f":"ROUND(IF(X5=0, IF(V5=0, 0, 1), V5/X5),5)","v":1.07623},null,64050,null,66250,null,{"$f":"ROUND((AD5-AF5),5)","v":-2200},null,{"$f":"ROUND(IF(AF5=0, IF(AD5=0, 0, 1), AD5/AF5),5)","v":0.96679000000000004},null,71800,null,66250,null,{"$f":"ROUND((AL5-AN5),5)","v":5550},null,{"$f":"ROUND(IF(AN5=0, IF(AL5=0, 0, 1), AL5/AN5),5)","v":1.0837699999999999},null,70300,null,66250,null,{"$f":"ROUND((AT5-AV5),5)","v":4050},null,{"$f":"ROUND(IF(AV5=0, IF(AT5=0, 0, 1), AT5/AV5),5)","v":1.0611299999999999},null,{"$f":"ROUND(F5+N5+V5+AD5+AL5+AT5,5)","v":409650},null,{"$f":"ROUND(H5+P5+X5+AF5+AN5+AV5,5)","v":397500},null,{"$f":"ROUND((BB5-BD5),5)","v":12150},null,{"$f":"ROUND(IF(BD5=0, IF(BB5=0, 0, 1), BB5/BD5),5)","v":1.03057}]
[null,null,null,null,"40100 · Meal Sales",41371,null,19000,null,22371,null,2.1774200000000001,null,45613,null,33000,null,12613,null,1.3822099999999999,null,55366,null,63801,null,-8435,null,0.86778999999999995,null,86873,null,83300,null,3573,null,1.0428900000000001,null,83229,null,80714,null,2515,null,1.0311600000000001,null,102719,null,92182,null,10537,null,1.1143099999999999,null,415171,null,371997,null,43174,null,1.1160600000000001]
[null,null,null,null,"40200 · Beverage Sales",8739,null,5063,null,3676,null,1.7260500000000001,null,6249,null,6289,null,-40,null,0.99363999999999997,null,9893,null,9000,null,893,null,1.0992200000000001,null,23777,null,13000,null,10777,null,1.829,null,7710,null,13000,null,-5290,null,0.59308000000000005,null,11378,null,16000,null,-4622,null,0.71113000000000004,null,67746,null,62352,null,5394,null,1.0865100000000001]
[null,null,null,null,"40300 · Service Fees",4330,null,578,null,3752,null,7.4913499999999997,null,3047,null,539,null,2508,null,5.65306,null,3287,null,6894,null,-3607,null,0.47678999999999999,null,12027,null,9006,null,3021,null,1.33544,null,4766,null,9025,null,-4259,null,0.52808999999999995,null,9385,null,9388,null,-3,null,0.99968000000000001,null,36842,null,35430,null,1412,null,1.0398499999999999]
[null,null,null,null,"40400 · Rental Income",0,null,0,null,0,null,0,null,0,null,152,null,-152,null,0,null,0,null,2600,null,-2600,null,0,null,3132,null,2600,null,532,null,1.20462,null,140,null,2600,null,-2460,null,5.3850000000000002E-2,null,15449,null,2600,null,12849,null,5.9419199999999996,null,18721,null,10552,null,8169,null,1.77417]
[null,null,null,null,"40800 · Other Income",675,null,168,null,507,null,4.0178599999999998,null,300,null,919,null,-619,null,0.32644000000000001,null,71,null,553,null,-482,null,0.12839,null,430,null,670,null,-240,null,0.64178999999999997,null,230,null,757,null,-527,null,0.30382999999999999,null,165,null,1402,null,-1237,null,0.11769,null,1871,null,4469,null,-2598,null,0.41865999999999998]
[null,null,null,"Total Income",null,{"$f":"ROUND(SUM(F4:F10),5)","v":121965},null,{"$f":"ROUND(SUM(H4:H10),5)","v":91059},null,30906,null,1.33941,null,{"$f":"ROUND(SUM(N4:N10),5)","v":120559},null,{"$f":"ROUND(SUM(P4:P10),5)","v":107149},null,13410,null,1.1251500000000001,null,{"$f":"ROUND(SUM(V4:V10),5)","v":139917},null,{"$f":"ROUND(SUM(X4:X10),5)","v":149098},null,-9181,null,0.93842000000000003,null,{"$f":"ROUND(SUM(AD4:AD10),5)","v":190289},null,{"$f":"ROUND(SUM(AF4:AF10),5)","v":174826},null,15463,null,1.0884499999999999,null,{"$f":"ROUND(SUM(AL4:AL10),5)","v":167875},null,{"$f":"ROUND(SUM(AN4:AN10),5)","v":172346},null,-4471,null,0.97406000000000004,null,{"$f":"ROUND(SUM(AT4:AT10),5)","v":209396},null,{"$f":"ROUND(SUM(AV4:AV10),5)","v":187822},null,21574,null,1.11486,null,950001,null,882300,null,67701,null,1.07673]
[null,null,"Gross Profit",null,null,{"$f":"F11","v":121965},null,{"$f":"H11","v":91059},null,30906,null,1.33941,null,{"$f":"N11","v":120559},null,{"$f":"P11","v":107149},null,13410,null,1.1251500000000001,null,{"$f":"V11","v":139917},null,{"$f":"X11","v":149098},null,-9181,null,0.93842000000000003,null,{"$f":"AD11","v":190289},null,{"$f":"AF11","v":174826},null,15463,null,1.0884499999999999,null,{"$f":"AL11","v":167875},null,{"$f":"AN11","v":172346},null,-4471,null,0.97406000000000004,null,{"$f":"AT11","v":209396},null,{"$f":"AV11","v":187822},null,21574,null,1.11486,null,950001,null,882300,null,67701,null,1.07673]
[null,null,null,"Expense"]
[null,null,null,null,"55100 · Food Purchased",16506,null,17020,null,{"$f":"ROUND((F14-H14),5)","v":-514},null,{"$f":"ROUND(IF(H14=0, IF(F14=0, 0, 1), F14/H14),5)","v":0.9698},null,18293,null,20000,null,{"$f":"ROUND((N14-P14),5)","v":-1707},null,{"$f":"ROUND(IF(P14=0, IF(N14=0, 0, 1), N14/P14),5)","v":0.91464999999999996},null,21249,null,22000,null,{"$f":"ROUND((V14-X14),5)","v":-751},null,{"$f":"ROUND(IF(X14=0, IF(V14=0, 0, 1), V14/X14),5)","v":0.96586000000000005},null,27673,null,27000,null,{"$f":"ROUND((AD14-AF14),5)","v":673},null,{"$f":"ROUND(IF(AF14=0, IF(AD14=0, 0, 1), AD14/AF14),5)","v":1.0249299999999999},null,26099,null,27000,null,{"$f":"ROUND((AL14-AN14),5)","v":-901},null,{"$f":"ROUND(IF(AN14=0, IF(AL14=0, 0, 1), AL14/AN14),5)","v":0.96662999999999999},null,27306,null,28000,null,{"$f":"ROUND((AT14-AV14),5)","v":-694},null,{"$f":"ROUND(IF(AV14=0, IF(AT14=0, 0, 1), AT14/AV14),5)","v":0.97521000000000002},null,{"$f":"ROUND(F14+N14+V14+AD14+AL14+AT14,5)","v":137126},null,{"$f":"ROUND(H14+P14+X14+AF14+AN14+AV14,5)","v":141020},null,{"$f":"ROUND((BB14-BD14),5)","v":-3894},null,{"$f":"ROUND(IF(BD14=0, IF(BB14=0, 0, 1), BB14/BD14),5)","v":0.97238999999999998}]
[null,null,null,null,"55200 · Beverages",12326,null,4051,null,8275,null,3.04271,null,5382,null,7805,null,-2423,null,0.68955999999999995,null,10200,null,12716,null,-2516,null,0.80213999999999996,null,22493,null,16643,null,5850,null,1.3514999999999999,null,20126,null,11828,null,8298,null,1.70156,null,13350,null,15100,null,-1750,null,0.88410999999999995,null,83877,null,68143,null,15734,null,1.2309000000000001]
[null,null,null,null,"55300 · Kitchen Employee Expense",31159,null,30332,null,827,null,1.0272600000000001,null,31421,null,30332,null,1089,null,1.0359,null,29671,null,30332,null,-661,null,0.97821000000000002,null,31990,null,30332,null,1658,null,1.0546599999999999,null,37353,null,30332,null,7021,null,1.2314700000000001,null,31704,null,30332,null,1372,null,1.0452300000000001,null,193298,null,181992,null,11306,null,1.06212]
[null,null,null,null,"55400 · Front of House Employee Expense",24021,null,30425,null,-6404,null,0.78952,null,23094,null,30425,null,-7331,null,0.75905,null,24415,null,30425,null,-6010,null,0.80247000000000002,null,30535,null,30425,null,110,null,1.00362,null,41005,null,30425,null,10580,null,1.3477399999999999,null,30573,null,30425,null,148,null,1.0048600000000001,null,173643,null,182550,null,-8907,null,0.95121]
[null,null,null,null,"55500 · Kitchen Supplies",1058,null,1098,null,-40,null,0.96357000000000004,null,464,null,1098,null,-634,null,0.42259000000000002,null,1431,null,1098,null,333,null,1.30328,null,708,null,1098,null,-390,null,0.64480999999999999,null,1035,null,1098,null,-63,null,0.94262000000000001,null,1130,null,1098,null,32,null,1.0291399999999999,null,5826,null,6588,null,-762,null,0.88434000000000001]
[null,null,null,null,"55800 · Entertainment",654,null,5426,null,-4772,null,0.12053,null,4854,null,5426,null,-572,null,0.89458000000000004,null,2054,null,5426,null,-3372,null,0.37855,null,3454,null,5426,null,-1972,null,0.63656000000000001,null,7504,null,5426,null,2078,null,1.38297,null,10504,null,5426,null,5078,null,1.9358599999999999,null,29024,null,32556,null,-3532,null,0.89151000000000002]
[null,null,null,null,"60000 · General & Admin Employee Exp",24908,null,26572,null,-1664,null,0.93737999999999999,null,24328,null,26572,null,-2244,null,0.91554999999999997,null,24203,null,26572,null,-2369,null,0.91085000000000005,null,24203,null,26572,null,-2369,null,0.91085000000000005,null,25727,null,26572,null,-845,null,0.96819999999999995,null,24203,null,26572,null,-2369,null,0.91085000000000005,null,147572,null,159432,null,-11860,null,0.92561000000000004]
[null,null,null,null,"60700 · Advertising & Promotional",887,null,2065,null,-1178,null,0.42953999999999998,null,1139,null,2065,null,-926,null,0.55157,null,905,null,2065,null,-1160,null,0.43825999999999998,null,607,null,2065,null,-1458,null,0.29394999999999999,null,4322,null,2065,null,2257,null,2.0929799999999998,null,1767,null,2065,null,-298,null,0.85568999999999995,null,9627,null,12390,null,-2763,null,0.77700000000000002]
[null,null,null,null,"62020 · Dues & Subscriptions",338,null,85,null,253,null,3.9764699999999999,null,0,null,85,null,-85,null,0,null,0,null,85,null,-85,null,0,null,401,null,85,null,316,null,4.7176499999999999,null,0,null,85,null,-85,null,0,null,0,null,85,null,-85,null,0,null,739,null,510,null,229,null,1.44902]
[null,null,null,null,"62030 · Equipment Rental",333,null,2101,null,-1768,null,0.1585,null,458,null,2101,null,-1643,null,0.21798999999999999,null,391,null,2101,null,-1710,null,0.18609999999999999,null,4932,null,2101,null,2831,null,2.3474499999999998,null,2203,null,2101,null,102,null,1.0485500000000001,null,9888,null,2101,null,7787,null,4.7063300000000003,null,18205,null,12606,null,5599,null,1.44415]
[null,null,null,null,"62040 · Repairs & Maintenance",5558,null,6782,null,-1224,null,0.81952000000000003,null,8028,null,6782,null,1246,null,1.1837200000000001,null,2888,null,6782,null,-3894,null,0.42582999999999999,null,8601,null,6782,null,1819,null,1.2682100000000001,null,5057,null,6782,null,-1725,null,0.74565000000000003,null,5094,null,6782,null,-1688,null,0.75111000000000006,null,35226,null,40692,null,-5466,null,0.86567000000000005]
[null,null,null,null,"62100 · Auto related",51,null,64,null,-13,null,0.79688000000000003,null,114,null,64,null,50,null,1.78125,null,0,null,64,null,-64,null,0,null,170,null,64,null,106,null,2.65625,null,75,null,64,null,11,null,1.17188,null,80,null,64,null,16,null,1.25,null,490,null,384,null,106,null,1.2760400000000001]
[null,null,null,null,"62200 · Meals and Entertainment",3278,null,60,null,3218,null,54.633330000000001,null,0,null,60,null,-60,null,0,null,157,null,60,null,97,null,2.6166700000000001,null,0,null,60,null,-60,null,0,null,0,null,60,null,-60,null,0,null,0,null,60,null,-60,null,0,null,3435,null,360,null,3075,null,9.5416699999999999]
[null,null,null,null,"62300 · Postage",0,null,211,null,-211,null,0,null,676,null,211,null,465,null,3.2037900000000001,null,31,null,211,null,-180,null,0.14692,null,630,null,211,null,419,null,2.9857800000000001,null,0,null,211,null,-211,null,0,null,630,null,211,null,419,null,2.9857800000000001,null,1967,null,1266,null,701,null,1.5537099999999999]
[null,null,null,null,"62400 · Printing",1101,null,160,null,941,null,6.8812499999999996,null,0,null,160,null,-160,null,0,null,378,null,160,null,218,null,2.3624999999999998,null,0,null,160,null,-160,null,0,null,0,null,160,null,-160,null,0,null,0,null,160,null,-160,null,0,null,1479,null,960,null,519,null,1.5406299999999999]
[null,null,null,null,"62500 · Training",100,null,325,null,-225,null,0.30769000000000002,null,850,null,325,null,525,null,2.61538,null,262,null,325,null,-63,null,0.80615000000000003,null,0,null,325,null,-325,null,0,null,0,null,325,null,-325,null,0,null,0,null,325,null,-325,null,0,null,1212,null,1950,null,-738,null,0.62153999999999998]
[null,null,null,null,"63000 · Insurance",2782,null,3923,null,-1141,null,0.70914999999999995,null,1417,null,3923,null,-2506,null,0.36120000000000002,null,-926,null,3923,null,-4849,null,-0.23604,null,2786,null,3923,null,-1137,null,0.71016999999999997,null,2950,null,3923,null,-973,null,0.75197999999999998,null,2806,null,3923,null,-1117,null,0.71526999999999996,null,11815,null,23538,null,-11723,null,0.50195000000000001]
[null,null,null,null,"64000 · Supplies and Related",5637,null,3487,null,2150,null,1.6165799999999999,null,4729,null,3487,null,1242,null,1.3561799999999999,null,2052,null,3487,null,-1435,null,0.58847000000000005,null,2219,null,3487,null,-1268,null,0.63636000000000004,null,4883,null,3487,null,1396,null,1.4003399999999999,null,2851,null,3487,null,-636,null,0.81760999999999995,null,22371,null,20922,null,1449,null,1.0692600000000001]
[null,null,null,null,"65000 · Professional Services",4557,null,3015,null,1542,null,1.5114399999999999,null,4038,null,3015,null,1023,null,1.3392999999999999,null,3247,null,3015,null,232,null,1.0769500000000001,null,2706,null,3015,null,-309,null,0.89751000000000003,null,3011,null,3015,null,-4,null,0.99866999999999995,null,3699,null,3015,null,684,null,1.2268699999999999,null,21258,null,18090,null,3168,null,1.1751199999999999]
[null,null,null,null,"65050 · Other Outside Services",322,null,2579,null,-2257,null,0.12485,null,971,null,2579,null,-1608,null,0.3765,null,1214,null,2579,null,-1365,null,0.47072999999999998,null,1401,null,2579,null,-1178,null,0.54322999999999999,null,1428,null,2579,null,-1151,null,0.55369999999999997,null,1680,null,2579,null,-899,null,0.65142,null,7016,null,15474,null,-8458,null,0.45340999999999998]
[null,null,null,null,"66000 · Bank and Other Service Charges",462,null,290,null,172,null,1.5931,null,252,null,290,null,-38,null,0.86897000000000002,null,258,null,290,null,-32,null,0.88966000000000001,null,266,null,290,null,-24,null,0.91724000000000006,null,285,null,290,null,-5,null,0.98275999999999997,null,293,null,290,null,3,null,1.01034,null,1816,null,1740,null,76,null,1.0436799999999999]
[null,null,null,null,"67000 · Taxes and Fees",0,null,0,null,0,null,0,null,7112,null,7000,null,112,null,1.016,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,654,null,500,null,154,null,1.3080000000000001,null,2095,null,1000,null,1095,null,2.0950000000000002,null,9861,null,8500,null,1361,null,1.16012]
[null,null,null,null,"68000 · Utilities",5149,null,5801,null,-652,null,0.88761000000000001,null,5827,null,5801,null,26,null,1.00448,null,5066,null,5801,null,-735,null,0.87329999999999997,null,4311,null,5801,null,-1490,null,0.74314999999999998,null,5686,null,5801,null,-115,null,0.98018000000000005,null,8059,null,5801,null,2258,null,1.38924,null,34098,null,34806,null,-708,null,0.97965999999999998]
[null,null,null,"Total Expense",null,{"$f":"ROUND(SUM(F13:F36),5)","v":141187},null,{"$f":"ROUND(SUM(H13:H36),5)","v":145872},null,-4685,null,0.96787999999999996,null,{"$f":"ROUND(SUM(N13:N36),5)","v":143447},null,{"$f":"ROUND(SUM(P13:P36),5)","v":159606},null,-16159,null,0.89876,null,{"$f":"ROUND(SUM(V13:V36),5)","v":129146},null,{"$f":"ROUND(SUM(X13:X36),5)","v":159517},null,-30371,null,0.80961000000000005,null,{"$f":"ROUND(SUM(AD13:AD36),5)","v":170086},null,{"$f":"ROUND(SUM(AF13:AF36),5)","v":168444},null,1642,null,1.0097499999999999,null,{"$f":"ROUND(SUM(AL13:AL36),5)","v":189403},null,{"$f":"ROUND(SUM(AN13:AN36),5)","v":164129},null,25274,null,1.1539900000000001,null,{"$f":"ROUND(SUM(AT13:AT36),5)","v":177712},null,{"$f":"ROUND(SUM(AV13:AV36),5)","v":168901},null,8811,null,1.05217,null,950981,null,966469,null,-15488,null,0.98397000000000001]
[null,"Net Ordinary Income",null,null,null,{"$f":"ROUND(F3+F12-F37,5)","v":-19222},null,{"$f":"ROUND(H3+H12-H37,5)","v":-54813},null,35591,null,0.35067999999999999,null,{"$f":"ROUND(N3+N12-N37,5)","v":-22888},null,{"$f":"ROUND(P3+P12-P37,5)","v":-52457},null,29569,null,0.43631999999999999,null,{"$f":"ROUND(V3+V12-V37,5)","v":10771},null,{"$f":"ROUND(X3+X12-X37,5)","v":-10419},null,21190,null,-1.0337799999999999,null,{"$f":"ROUND(AD3+AD12-AD37,5)","v":20203},null,{"$f":"ROUND(AF3+AF12-AF37,5)","v":6382},null,13821,null,3.1656200000000001,null,{"$f":"ROUND(AL3+AL12-AL37,5)","v":-21528},null,{"$f":"ROUND(AN3+AN12-AN37,5)","v":8217},null,-29745,null,-2.6199300000000001,null,{"$f":"ROUND(AT3+AT12-AT37,5)","v":31684},null,{"$f":"ROUND(AV3+AV12-AV37,5)","v":18921},null,12763,null,1.6745399999999999,null,-980,null,-84169,null,83189,null,1.1639999999999999E-2]
[null,"Other Income/Expense"]
[null,null,"Other Income"]
[null,null,null,"70001 · Interest & Dividend Income",null,1,null,1,null,{"$f":"ROUND((F41-H41),5)","v":0},null,{"$f":"ROUND(IF(H41=0, IF(F41=0, 0, 1), F41/H41),5)","v":1},null,0,null,1,null,{"$f":"ROUND((N41-P41),5)","v":-1},null,{"$f":"ROUND(IF(P41=0, IF(N41=0, 0, 1), N41/P41),5)","v":0},null,0,null,1,null,{"$f":"ROUND((V41-X41),5)","v":-1},null,{"$f":"ROUND(IF(X41=0, IF(V41=0, 0, 1), V41/X41),5)","v":0},null,0,null,1,null,{"$f":"ROUND((AD41-AF41),5)","v":-1},null,{"$f":"ROUND(IF(AF41=0, IF(AD41=0, 0, 1), AD41/AF41),5)","v":0},null,0,null,1,null,{"$f":"ROUND((AL41-AN41),5)","v":-1},null,{"$f":"ROUND(IF(AN41=0, IF(AL41=0, 0, 1), AL41/AN41),5)","v":0},null,1,null,1,null,{"$f":"ROUND((AT41-AV41),5)","v":0},null,{"$f":"ROUND(IF(AV41=0, IF(AT41=0, 0, 1), AT41/AV41),5)","v":1},null,{"$f":"ROUND(F41+N41+V41+AD41+AL41+AT41,5)","v":2},null,{"$f":"ROUND(H41+P41+X41+AF41+AN41+AV41,5)","v":6},null,{"$f":"ROUND((BB41-BD41),5)","v":-4},null,{"$f":"ROUND(IF(BD41=0, IF(BB41=0, 0, 1), BB41/BD41),5)","v":0.33333000000000002}]
[null,null,null,"70011 · Assessment Fee Income",null,125,null,125,null,{"$f":"ROUND((F42-H42),5)","v":0},null,{"$f":"ROUND(IF(H42=0, IF(F42=0, 0, 1), F42/H42),5)","v":1},null,125,null,125,null,{"$f":"ROUND((N42-P42),5)","v":0},null,{"$f":"ROUND(IF(P42=0, IF(N42=0, 0, 1), N42/P42),5)","v":1},null,125,null,125,null,{"$f":"ROUND((V42-X42),5)","v":0},null,{"$f":"ROUND(IF(X42=0, IF(V42=0, 0, 1), V42/X42),5)","v":1},null,125,null,125,null,{"$f":"ROUND((AD42-AF42),5)","v":0},null,{"$f":"ROUND(IF(AF42=0, IF(AD42=0, 0, 1), AD42/AF42),5)","v":1},null,125,null,125,null,{"$f":"ROUND((AL42-AN42),5)","v":0},null,{"$f":"ROUND(IF(AN42=0, IF(AL42=0, 0, 1), AL42/AN42),5)","v":1},null,125,null,125,null,{"$f":"ROUND((AT42-AV42),5)","v":0},null,{"$f":"ROUND(IF(AV42=0, IF(AT42=0, 0, 1), AT42/AV42),5)","v":1},null,{"$f":"ROUND(F42+N42+V42+AD42+AL42+AT42,5)","v":750},null,{"$f":"ROUND(H42+P42+X42+AF42+AN42+AV42,5)","v":750},null,{"$f":"ROUND((BB42-BD42),5)","v":0},null,{"$f":"ROUND(IF(BD42=0, IF(BB42=0, 0, 1), BB42/BD42),5)","v":1}]
[null,null,null,"70012 · Other Member Contributions",null,0,null,0,null,{"$f":"ROUND((F43-H43),5)","v":0},null,{"$f":"ROUND(IF(H43=0, IF(F43=0, 0, 1), F43/H43),5)","v":0},null,850,null,0,null,{"$f":"ROUND((N43-P43),5)","v":850},null,{"$f":"ROUND(IF(P43=0, IF(N43=0, 0, 1), N43/P43),5)","v":1},null,1200,null,0,null,{"$f":"ROUND((V43-X43),5)","v":1200},null,{"$f":"ROUND(IF(X43=0, IF(V43=0, 0, 1), V43/X43),5)","v":1},null,-85,null,0,null,{"$f":"ROUND((AD43-AF43),5)","v":-85},null,{"$f":"ROUND(IF(AF43=0, IF(AD43=0, 0, 1), AD43/AF43),5)","v":1},null,127475,null,81008,null,{"$f":"ROUND((AL43-AN43),5)","v":46467},null,{"$f":"ROUND(IF(AN43=0, IF(AL43=0, 0, 1), AL43/AN43),5)","v":1.57361},null,4450,null,0,null,{"$f":"ROUND((AT43-AV43),5)","v":4450},null,{"$f":"ROUND(IF(AV43=0, IF(AT43=0, 0, 1), AT43/AV43),5)","v":1},null,{"$f":"ROUND(F43+N43+V43+AD43+AL43+AT43,5)","v":133890},null,{"$f":"ROUND(H43+P43+X43+AF43+AN43+AV43,5)","v":81008},null,{"$f":"ROUND((BB43-BD43),5)","v":52882},null,{"$f":"ROUND(IF(BD43=0, IF(BB43=0, 0, 1), BB43/BD43),5)","v":1.6528}]
[null,"Net Other Income",null,null,null,{"$f":"ROUND(SUM(F40:F43),5)","v":126},null,{"$f":"ROUND(SUM(H40:H43),5)","v":126},null,{"$f":"ROUND((F44-H44),5)","v":0},null,{"$f":"ROUND(IF(H44=0, IF(F44=0, 0, 1), F44/H44),5)","v":1},null,{"$f":"ROUND(SUM(N40:N43),5)","v":975},null,{"$f":"ROUND(SUM(P40:P43),5)","v":126},null,{"$f":"ROUND((N44-P44),5)","v":849},null,{"$f":"ROUND(IF(P44=0, IF(N44=0, 0, 1), N44/P44),5)","v":7.7381000000000002},null,{"$f":"ROUND(SUM(V40:V43),5)","v":1325},null,{"$f":"ROUND(SUM(X40:X43),5)","v":126},null,{"$f":"ROUND((V44-X44),5)","v":1199},null,{"$f":"ROUND(IF(X44=0, IF(V44=0, 0, 1), V44/X44),5)","v":10.51587},null,{"$f":"ROUND(SUM(AD40:AD43),5)","v":40},null,{"$f":"ROUND(SUM(AF40:AF43),5)","v":126},null,{"$f":"ROUND((AD44-AF44),5)","v":-86},null,{"$f":"ROUND(IF(AF44=0, IF(AD44=0, 0, 1), AD44/AF44),5)","v":0.31746000000000002},null,{"$f":"ROUND(SUM(AL40:AL43),5)","v":127600},null,{"$f":"ROUND(SUM(AN40:AN43),5)","v":81134},null,{"$f":"ROUND((AL44-AN44),5)","v":46466},null,{"$f":"ROUND(IF(AN44=0, IF(AL44=0, 0, 1), AL44/AN44),5)","v":1.5727100000000001},null,{"$f":"ROUND(SUM(AT40:AT43),5)","v":4576},null,{"$f":"ROUND(SUM(AV40:AV43),5)","v":126},null,{"$f":"ROUND((AT44-AV44),5)","v":4450},null,{"$f":"ROUND(IF(AV44=0, IF(AT44=0, 0, 1), AT44/AV44),5)","v":36.317459999999997},null,{"$f":"ROUND(F44+N44+V44+AD44+AL44+AT44,5)","v":134642},null,{"$f":"ROUND(H44+P44+X44+AF44+AN44+AV44,5)","v":81764},null,{"$f":"ROUND((BB44-BD44),5)","v":52878},null,{"$f":"ROUND(IF(BD44=0, IF(BB44=0, 0, 1), BB44/BD44),5)","v":1.6467099999999999}]
["Net Income (excluding depreciation)",null,null,null,null,{"$f":"ROUND(F38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(H38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND((F45-H45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(IF(H45=0, IF(F45=0, 0, 1), F45/H45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(N38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(P38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND((N45-P45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(IF(P45=0, IF(N45=0, 0, 1), N45/P45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(V38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(X38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND((V45-X45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(IF(X45=0, IF(V45=0, 0, 1), V45/X45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(AD38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(AF38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND((AD45-AF45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(IF(AF45=0, IF(AD45=0, 0, 1), AD45/AF45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(AL38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(AN38+#REF!,5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND((AL45-AN45),5)","v":{"$error":"#REF!"}},null,{"$f":"ROUND(IF(AN45=0, IF(AL45=0, 0, 1), AL45/AN45),5)","v":{"$error":"#REF!"}},null,{"$f":"AT38+AT44","v":36260},null,{"$f":"AV38+AV44","v":19047},null,{"$f":"ROUND((AT45-AV45),5)","v":17213},null,{"$f":"ROUND(IF(AV45=0, IF(AT45=0, 0, 1), AT45/AV45),5)","v":1.90371},null,{"$f":"BB38+BB44","v":133662},null,{"$f":"BD38+BD44","v":-2405},null,{"$f":"ROUND((BB45-BD45),5)","v":136067},null,{"$f":"ROUND(IF(BD45=0, IF(BB45=0, 0, 1), BB45/BD45),5)","v":-55.576720000000002}]

{"sheet":"YTD Rev by Type","index":1,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Events- Member",null,"Events- Member Referral & Other",null,"Events-Club",null,"Member Services",null,"TOTAL"]
[null,"Ordinary Income/Expense"]
[null,null,null,"Income"]
[null,null,null,null,"40000 · Member Dues and Fees",0,null,0,null,0,null,409650,null,{"$f":"ROUND(SUM(F4:L4),5)","v":409650}]
[null,null,null,null,"40100 · Meal Sales",102529,null,53186,null,81474,null,177982,null,415171]
[null,null,null,null,"40200 · Beverage Sales",9355,null,6158,null,40,null,52193,null,67746]
[null,null,null,null,"40300 · Service Fees",16276,null,6758,null,182,null,13627,null,36843]
[null,null,null,null,"40400 · Rental Income",8457,null,10264,null,0,null,0,null,18721]
[null,null,null,null,"40800 · Other Income",375,null,800,null,0,null,696,null,1871]
[null,null,null,"Total Income",null,{"$f":"ROUND(SUM(F3:F9),5)","v":136992},null,{"$f":"ROUND(SUM(H3:H9),5)","v":77166},null,{"$f":"ROUND(SUM(J3:J9),5)","v":81696},null,{"$f":"ROUND(SUM(L3:L9),5)","v":654148},null,950002]
[null,null,"Prior Year Revenues",null,null,119887,null,99778,null,59065,null,625670,null,904400]
[null,null,"Change from Prior Year",null,null,{"$f":"F10-F11","v":17105},null,{"$f":"H10-H11","v":-22612},null,{"$f":"J10-J11","v":22631},null,{"$f":"L10-L11","v":28478},null,{"$f":"N10-N11","v":45602}]
[]
[null,null,"% of Total Revenues",null,null,{"$f":"F10/N10","v":0.14420180168041752},null,{"$f":"H10/N10","v":8.1227197416426491E-2},null,{"$f":"J10/N10","v":8.5995608430298048E-2},null,{"$f":"L10/N10","v":0.68857539247285793},null,1]

{"sheet":"June Rev by Type","index":2,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Events- Member",null,"Events- Member Referral & Other",null,"Events-Club",null,"Member Services",null,"TOTAL"]
[null,"Ordinary Income/Expense"]
[null,null,null,"Income"]
[null,null,null,null,"40000 · Member Dues and Fees",0,null,0,null,0,null,70300,null,{"$f":"ROUND(SUM(F4:L4),5)","v":70300}]
[null,null,null,null,"40100 · Meal Sales",41359,null,13325,null,17034,null,31000,null,102718]
[null,null,null,null,"40200 · Beverage Sales",1015,null,3250,null,0,null,7113,null,11378]
[null,null,null,null,"40300 · Service Fees",4530,null,2785,null,10,null,2061,null,9386]
[null,null,null,null,"40400 · Rental Income",5185,null,10264,null,0,null,0,null,15449]
[null,null,null,null,"40800 · Other Income",150,null,0,null,0,null,15,null,165]
[null,null,null,"Total Income",null,{"$f":"ROUND(SUM(F3:F9),5)","v":52239},null,{"$f":"ROUND(SUM(H3:H9),5)","v":29624},null,{"$f":"ROUND(SUM(J3:J9),5)","v":17044},null,{"$f":"ROUND(SUM(L3:L9),5)","v":110489},null,209396]
[null,null,"Prior Year Revenues",null,null,38752,null,33370,null,18183,null,97202,null,187507]
[null,null,"Change from Prior Year",null,null,{"$f":"F10-F11","v":13487},null,{"$f":"H10-H11","v":-3746},null,{"$f":"J10-J11","v":-1139},null,{"$f":"L10-L11","v":13287},null,{"$f":"N10-N11","v":21889}]
[]
[null,null,"% of Total Revenues",null,null,{"$f":"F10/N10","v":0.24947467955452826},null,{"$f":"H10/N10","v":0.14147357160595236},null,{"$f":"J10/N10","v":8.1396015205639077E-2},null,{"$f":"L10/N10","v":0.5276557336338803},null,1]

{"sheet":"Balance Sheet","index":3,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"Jun 30, 23",null,"Jun 30, 22",null,"$ Change",null,"% Change"]
["ASSETS"]
[null,"Current Assets"]
[null,null,"Checking/Savings",null,455580,null,310758,null,{"$f":"ROUND((E5-G5),5)","v":144822},null,{"$f":"ROUND(IF(E5=0, IF(G5=0, 0, SIGN(-G5)), IF(G5=0, SIGN(E5), (E5-G5)/ABS(G5))),5)","v":0.46603}]
[null,null,"Accounts Receivable",null,250624,null,278379,null,-27755,null,-9.9699999999999997E-2]
[null,null,"Other Current Assets",null,75481,null,66169,null,9312,null,0.14072999999999999]
[null,"Total Current Assets",null,null,{"$f":"ROUND(SUM(E4:E7),5)","v":781685},null,{"$f":"ROUND(SUM(G4:G7),5)","v":655306},null,126379,null,0.19284999999999999]
[null,"Fixed Assets",null,null,1044878,null,1062716,null,-17838,null,-1.6789999999999999E-2]
["TOTAL ASSETS",null,null,null,{"$f":"ROUND(E3+SUM(E8:E9),5)","v":1826563},null,{"$f":"ROUND(G3+SUM(G8:G9),5)","v":1718022},null,108541,null,6.318E-2]
["LIABILITIES & EQUITY"]
[null,"Liabilities"]
[null,null,"Current Liabilities"]
[null,null,null,"Accounts Payable",38227,null,118832,null,{"$f":"ROUND((E14-G14),5)","v":-80605},null,{"$f":"ROUND(IF(E14=0, IF(G14=0, 0, SIGN(-G14)), IF(G14=0, SIGN(E14), (E14-G14)/ABS(G14))),5)","v":-0.67830999999999997}]
[null,null,null,"Other Current Liabilities",13392,null,11400,null,1992,null,0.17474000000000001]
[null,null,"Total Current Liabilities",null,{"$f":"ROUND(SUM(E13:E15),5)","v":51619},null,{"$f":"ROUND(SUM(G13:G15),5)","v":130232},null,-78613,null,-0.60363999999999995]
[null,"Total Liabilities",null,null,{"$f":"ROUND(E12+E16,5)","v":51619},null,{"$f":"ROUND(G12+G16,5)","v":130232},null,-78613,null,-0.60363999999999995]
[null,"Equity",null,null,1774943,null,1587790,null,187153,null,0.11787]
["TOTAL LIABILITIES & EQUITY",null,null,null,{"$f":"ROUND(E11+SUM(E17:E18),5)","v":1826562},null,{"$f":"ROUND(G11+SUM(G17:G18),5)","v":1718022},null,108540,null,6.318E-2]