{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["P&L Act to Bud","Rev by Type YTD","Balance Sheet"],"not_rendered":{"charts":0,"images":6,"macros":0,"external_links":0,"defined_names":287,"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 Act to Bud","index":0,"n_rows":45,"n_cols":28,"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,"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,"Jan - Feb 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,65600,null,66250,null,{"$f":"ROUND((N5-P5),5)","v":-650},null,{"$f":"ROUND(IF(P5=0, IF(N5=0, 0, 1), N5/P5),5)","v":0.99019000000000001},null,{"$f":"ROUND(F5+N5,5)","v":132450},null,{"$f":"ROUND(H5+P5,5)","v":132500},null,{"$f":"ROUND((V5-X5),5)","v":-50},null,{"$f":"ROUND(IF(X5=0, IF(V5=0, 0, 1), V5/X5),5)","v":0.99961999999999995}]
[null,null,null,null,"40100 · Meal Sales",37371,null,19000,null,{"$f":"ROUND((F6-H6),5)","v":18371},null,{"$f":"ROUND(IF(H6=0, IF(F6=0, 0, 1), F6/H6),5)","v":1.96689},null,49613,null,33000,null,{"$f":"ROUND((N6-P6),5)","v":16613},null,{"$f":"ROUND(IF(P6=0, IF(N6=0, 0, 1), N6/P6),5)","v":1.50342},null,{"$f":"ROUND(F6+N6,5)","v":86984},null,{"$f":"ROUND(H6+P6,5)","v":52000},null,{"$f":"ROUND((V6-X6),5)","v":34984},null,{"$f":"ROUND(IF(X6=0, IF(V6=0, 0, 1), V6/X6),5)","v":1.6727700000000001}]
[null,null,null,null,"40200 · Beverage Sales",7739,null,5063,null,{"$f":"ROUND((F7-H7),5)","v":2676},null,{"$f":"ROUND(IF(H7=0, IF(F7=0, 0, 1), F7/H7),5)","v":1.52854},null,7249,null,6289,null,{"$f":"ROUND((N7-P7),5)","v":960},null,{"$f":"ROUND(IF(P7=0, IF(N7=0, 0, 1), N7/P7),5)","v":1.15265},null,{"$f":"ROUND(F7+N7,5)","v":14988},null,{"$f":"ROUND(H7+P7,5)","v":11352},null,{"$f":"ROUND((V7-X7),5)","v":3636},null,{"$f":"ROUND(IF(X7=0, IF(V7=0, 0, 1), V7/X7),5)","v":1.3203}]
[null,null,null,null,"40300 · Service Fees",3430,null,578,null,{"$f":"ROUND((F8-H8),5)","v":2852},null,{"$f":"ROUND(IF(H8=0, IF(F8=0, 0, 1), F8/H8),5)","v":5.9342600000000001},null,3947,null,539,null,{"$f":"ROUND((N8-P8),5)","v":3408},null,{"$f":"ROUND(IF(P8=0, IF(N8=0, 0, 1), N8/P8),5)","v":7.3228200000000001},null,{"$f":"ROUND(F8+N8,5)","v":7377},null,{"$f":"ROUND(H8+P8,5)","v":1117},null,{"$f":"ROUND((V8-X8),5)","v":6260},null,{"$f":"ROUND(IF(X8=0, IF(V8=0, 0, 1), V8/X8),5)","v":6.6043000000000003}]
[null,null,null,null,"40400 · Rental Income",0,null,0,null,{"$f":"ROUND((F9-H9),5)","v":0},null,{"$f":"ROUND(IF(H9=0, IF(F9=0, 0, 1), F9/H9),5)","v":0},null,0,null,152,null,{"$f":"ROUND((N9-P9),5)","v":-152},null,{"$f":"ROUND(IF(P9=0, IF(N9=0, 0, 1), N9/P9),5)","v":0},null,{"$f":"ROUND(F9+N9,5)","v":0},null,{"$f":"ROUND(H9+P9,5)","v":152},null,{"$f":"ROUND((V9-X9),5)","v":-152},null,{"$f":"ROUND(IF(X9=0, IF(V9=0, 0, 1), V9/X9),5)","v":0}]
[null,null,null,null,"40800 · Other Income",75,null,168,null,{"$f":"ROUND((F10-H10),5)","v":-93},null,{"$f":"ROUND(IF(H10=0, IF(F10=0, 0, 1), F10/H10),5)","v":0.44642999999999999},null,900,null,919,null,{"$f":"ROUND((N10-P10),5)","v":-19},null,{"$f":"ROUND(IF(P10=0, IF(N10=0, 0, 1), N10/P10),5)","v":0.97933000000000003},null,{"$f":"ROUND(F10+N10,5)","v":975},null,{"$f":"ROUND(H10+P10,5)","v":1087},null,{"$f":"ROUND((V10-X10),5)","v":-112},null,{"$f":"ROUND(IF(X10=0, IF(V10=0, 0, 1), V10/X10),5)","v":0.89695999999999998}]
[null,null,null,"Total Income",null,{"$f":"ROUND(SUM(F4:F10),5)","v":115465},null,{"$f":"ROUND(SUM(H4:H10),5)","v":91059},null,{"$f":"ROUND((F11-H11),5)","v":24406},null,{"$f":"ROUND(IF(H11=0, IF(F11=0, 0, 1), F11/H11),5)","v":1.2680199999999999},null,{"$f":"ROUND(SUM(N4:N10),5)","v":127309},null,{"$f":"ROUND(SUM(P4:P10),5)","v":107149},null,{"$f":"ROUND((N11-P11),5)","v":20160},null,{"$f":"ROUND(IF(P11=0, IF(N11=0, 0, 1), N11/P11),5)","v":1.18815},null,{"$f":"ROUND(F11+N11,5)","v":242774},null,{"$f":"ROUND(H11+P11,5)","v":198208},null,{"$f":"ROUND((V11-X11),5)","v":44566},null,{"$f":"ROUND(IF(X11=0, IF(V11=0, 0, 1), V11/X11),5)","v":1.2248399999999999}]
[null,null,"Gross Profit",null,null,{"$f":"F11","v":115465},null,{"$f":"H11","v":91059},null,{"$f":"ROUND((F12-H12),5)","v":24406},null,{"$f":"ROUND(IF(H12=0, IF(F12=0, 0, 1), F12/H12),5)","v":1.2680199999999999},null,{"$f":"N11","v":127309},null,{"$f":"P11","v":107149},null,{"$f":"ROUND((N12-P12),5)","v":20160},null,{"$f":"ROUND(IF(P12=0, IF(N12=0, 0, 1), N12/P12),5)","v":1.18815},null,{"$f":"ROUND(F12+N12,5)","v":242774},null,{"$f":"ROUND(H12+P12,5)","v":198208},null,{"$f":"ROUND((V12-X12),5)","v":44566},null,{"$f":"ROUND(IF(X12=0, IF(V12=0, 0, 1), V12/X12),5)","v":1.2248399999999999}]
[null,null,null,"Expense"]
[null,null,null,null,"55100 · Food Purchased",16608,null,17020,null,{"$f":"ROUND((F14-H14),5)","v":-412},null,{"$f":"ROUND(IF(H14=0, IF(F14=0, 0, 1), F14/H14),5)","v":0.97579000000000005},null,18338,null,20000,null,{"$f":"ROUND((N14-P14),5)","v":-1662},null,{"$f":"ROUND(IF(P14=0, IF(N14=0, 0, 1), N14/P14),5)","v":0.91690000000000005},null,{"$f":"ROUND(F14+N14,5)","v":34946},null,{"$f":"ROUND(H14+P14,5)","v":37020},null,{"$f":"ROUND((V14-X14),5)","v":-2074},null,{"$f":"ROUND(IF(X14=0, IF(V14=0, 0, 1), V14/X14),5)","v":0.94398000000000004}]
[null,null,null,null,"55200 · Beverages",12326,null,4051,null,{"$f":"ROUND((F15-H15),5)","v":8275},null,{"$f":"ROUND(IF(H15=0, IF(F15=0, 0, 1), F15/H15),5)","v":3.04271},null,5382,null,7805,null,{"$f":"ROUND((N15-P15),5)","v":-2423},null,{"$f":"ROUND(IF(P15=0, IF(N15=0, 0, 1), N15/P15),5)","v":0.68955999999999995},null,{"$f":"ROUND(F15+N15,5)","v":17708},null,{"$f":"ROUND(H15+P15,5)","v":11856},null,{"$f":"ROUND((V15-X15),5)","v":5852},null,{"$f":"ROUND(IF(X15=0, IF(V15=0, 0, 1), V15/X15),5)","v":1.49359}]
[null,null,null,null,"55300 · Kitchen Employee Expense",31159,null,30332,null,{"$f":"ROUND((F16-H16),5)","v":827},null,{"$f":"ROUND(IF(H16=0, IF(F16=0, 0, 1), F16/H16),5)","v":1.0272600000000001},null,31421,null,30332,null,{"$f":"ROUND((N16-P16),5)","v":1089},null,{"$f":"ROUND(IF(P16=0, IF(N16=0, 0, 1), N16/P16),5)","v":1.0359},null,{"$f":"ROUND(F16+N16,5)","v":62580},null,{"$f":"ROUND(H16+P16,5)","v":60664},null,{"$f":"ROUND((V16-X16),5)","v":1916},null,{"$f":"ROUND(IF(X16=0, IF(V16=0, 0, 1), V16/X16),5)","v":1.0315799999999999}]
[null,null,null,null,"55400 · Front of House Employee Expense",24021,null,30425,null,{"$f":"ROUND((F17-H17),5)","v":-6404},null,{"$f":"ROUND(IF(H17=0, IF(F17=0, 0, 1), F17/H17),5)","v":0.78952},null,23094,null,30425,null,{"$f":"ROUND((N17-P17),5)","v":-7331},null,{"$f":"ROUND(IF(P17=0, IF(N17=0, 0, 1), N17/P17),5)","v":0.75905},null,{"$f":"ROUND(F17+N17,5)","v":47115},null,{"$f":"ROUND(H17+P17,5)","v":60850},null,{"$f":"ROUND((V17-X17),5)","v":-13735},null,{"$f":"ROUND(IF(X17=0, IF(V17=0, 0, 1), V17/X17),5)","v":0.77427999999999997}]
[null,null,null,null,"55500 · Kitchen Supplies",1058,null,1098,null,{"$f":"ROUND((F18-H18),5)","v":-40},null,{"$f":"ROUND(IF(H18=0, IF(F18=0, 0, 1), F18/H18),5)","v":0.96357000000000004},null,464,null,1098,null,{"$f":"ROUND((N18-P18),5)","v":-634},null,{"$f":"ROUND(IF(P18=0, IF(N18=0, 0, 1), N18/P18),5)","v":0.42259000000000002},null,{"$f":"ROUND(F18+N18,5)","v":1522},null,{"$f":"ROUND(H18+P18,5)","v":2196},null,{"$f":"ROUND((V18-X18),5)","v":-674},null,{"$f":"ROUND(IF(X18=0, IF(V18=0, 0, 1), V18/X18),5)","v":0.69308000000000003}]
[null,null,null,null,"55800 · Entertainment",654,null,5426,null,{"$f":"ROUND((F19-H19),5)","v":-4772},null,{"$f":"ROUND(IF(H19=0, IF(F19=0, 0, 1), F19/H19),5)","v":0.12053},null,4854,null,5426,null,{"$f":"ROUND((N19-P19),5)","v":-572},null,{"$f":"ROUND(IF(P19=0, IF(N19=0, 0, 1), N19/P19),5)","v":0.89458000000000004},null,{"$f":"ROUND(F19+N19,5)","v":5508},null,{"$f":"ROUND(H19+P19,5)","v":10852},null,{"$f":"ROUND((V19-X19),5)","v":-5344},null,{"$f":"ROUND(IF(X19=0, IF(V19=0, 0, 1), V19/X19),5)","v":0.50756000000000001}]
[null,null,null,null,"60000 · General & Admin Employee Exp",24908,null,26572,null,{"$f":"ROUND((F20-H20),5)","v":-1664},null,{"$f":"ROUND(IF(H20=0, IF(F20=0, 0, 1), F20/H20),5)","v":0.93737999999999999},null,24328,null,26572,null,{"$f":"ROUND((N20-P20),5)","v":-2244},null,{"$f":"ROUND(IF(P20=0, IF(N20=0, 0, 1), N20/P20),5)","v":0.91554999999999997},null,{"$f":"ROUND(F20+N20,5)","v":49236},null,{"$f":"ROUND(H20+P20,5)","v":53144},null,{"$f":"ROUND((V20-X20),5)","v":-3908},null,{"$f":"ROUND(IF(X20=0, IF(V20=0, 0, 1), V20/X20),5)","v":0.92645999999999995}]
[null,null,null,null,"60700 · Advertising & Promotional",887,null,2065,null,{"$f":"ROUND((F21-H21),5)","v":-1178},null,{"$f":"ROUND(IF(H21=0, IF(F21=0, 0, 1), F21/H21),5)","v":0.42953999999999998},null,1139,null,2065,null,{"$f":"ROUND((N21-P21),5)","v":-926},null,{"$f":"ROUND(IF(P21=0, IF(N21=0, 0, 1), N21/P21),5)","v":0.55157},null,{"$f":"ROUND(F21+N21,5)","v":2026},null,{"$f":"ROUND(H21+P21,5)","v":4130},null,{"$f":"ROUND((V21-X21),5)","v":-2104},null,{"$f":"ROUND(IF(X21=0, IF(V21=0, 0, 1), V21/X21),5)","v":0.49056}]
[null,null,null,null,"62020 · Dues & Subscriptions",338,null,85,null,{"$f":"ROUND((F22-H22),5)","v":253},null,{"$f":"ROUND(IF(H22=0, IF(F22=0, 0, 1), F22/H22),5)","v":3.9764699999999999},null,0,null,85,null,{"$f":"ROUND((N22-P22),5)","v":-85},null,{"$f":"ROUND(IF(P22=0, IF(N22=0, 0, 1), N22/P22),5)","v":0},null,{"$f":"ROUND(F22+N22,5)","v":338},null,{"$f":"ROUND(H22+P22,5)","v":170},null,{"$f":"ROUND((V22-X22),5)","v":168},null,{"$f":"ROUND(IF(X22=0, IF(V22=0, 0, 1), V22/X22),5)","v":1.98824}]
[null,null,null,null,"62030 · Equipment Rental",333,null,2101,null,{"$f":"ROUND((F23-H23),5)","v":-1768},null,{"$f":"ROUND(IF(H23=0, IF(F23=0, 0, 1), F23/H23),5)","v":0.1585},null,458,null,2101,null,{"$f":"ROUND((N23-P23),5)","v":-1643},null,{"$f":"ROUND(IF(P23=0, IF(N23=0, 0, 1), N23/P23),5)","v":0.21798999999999999},null,{"$f":"ROUND(F23+N23,5)","v":791},null,{"$f":"ROUND(H23+P23,5)","v":4202},null,{"$f":"ROUND((V23-X23),5)","v":-3411},null,{"$f":"ROUND(IF(X23=0, IF(V23=0, 0, 1), V23/X23),5)","v":0.18823999999999999}]
[null,null,null,null,"62040 · Repairs & Maintenance",5558,null,6782,null,{"$f":"ROUND((F24-H24),5)","v":-1224},null,{"$f":"ROUND(IF(H24=0, IF(F24=0, 0, 1), F24/H24),5)","v":0.81952000000000003},null,7116,null,6782,null,{"$f":"ROUND((N24-P24),5)","v":334},null,{"$f":"ROUND(IF(P24=0, IF(N24=0, 0, 1), N24/P24),5)","v":1.04925},null,{"$f":"ROUND(F24+N24,5)","v":12674},null,{"$f":"ROUND(H24+P24,5)","v":13564},null,{"$f":"ROUND((V24-X24),5)","v":-890},null,{"$f":"ROUND(IF(X24=0, IF(V24=0, 0, 1), V24/X24),5)","v":0.93439000000000005}]
[null,null,null,null,"62100 · Auto related",51,null,64,null,{"$f":"ROUND((F25-H25),5)","v":-13},null,{"$f":"ROUND(IF(H25=0, IF(F25=0, 0, 1), F25/H25),5)","v":0.79688000000000003},null,114,null,64,null,{"$f":"ROUND((N25-P25),5)","v":50},null,{"$f":"ROUND(IF(P25=0, IF(N25=0, 0, 1), N25/P25),5)","v":1.78125},null,{"$f":"ROUND(F25+N25,5)","v":165},null,{"$f":"ROUND(H25+P25,5)","v":128},null,{"$f":"ROUND((V25-X25),5)","v":37},null,{"$f":"ROUND(IF(X25=0, IF(V25=0, 0, 1), V25/X25),5)","v":1.2890600000000001}]
[null,null,null,null,"62200 · Meals and Entertainment",3278,null,60,null,{"$f":"ROUND((F26-H26),5)","v":3218},null,{"$f":"ROUND(IF(H26=0, IF(F26=0, 0, 1), F26/H26),5)","v":54.633330000000001},null,0,null,60,null,{"$f":"ROUND((N26-P26),5)","v":-60},null,{"$f":"ROUND(IF(P26=0, IF(N26=0, 0, 1), N26/P26),5)","v":0},null,{"$f":"ROUND(F26+N26,5)","v":3278},null,{"$f":"ROUND(H26+P26,5)","v":120},null,{"$f":"ROUND((V26-X26),5)","v":3158},null,{"$f":"ROUND(IF(X26=0, IF(V26=0, 0, 1), V26/X26),5)","v":27.316669999999998}]
[null,null,null,null,"62300 · Postage",0,null,211,null,{"$f":"ROUND((F27-H27),5)","v":-211},null,{"$f":"ROUND(IF(H27=0, IF(F27=0, 0, 1), F27/H27),5)","v":0},null,676,null,211,null,{"$f":"ROUND((N27-P27),5)","v":465},null,{"$f":"ROUND(IF(P27=0, IF(N27=0, 0, 1), N27/P27),5)","v":3.2037900000000001},null,{"$f":"ROUND(F27+N27,5)","v":676},null,{"$f":"ROUND(H27+P27,5)","v":422},null,{"$f":"ROUND((V27-X27),5)","v":254},null,{"$f":"ROUND(IF(X27=0, IF(V27=0, 0, 1), V27/X27),5)","v":1.6019000000000001}]
[null,null,null,null,"62400 · Printing",1101,null,160,null,{"$f":"ROUND((F28-H28),5)","v":941},null,{"$f":"ROUND(IF(H28=0, IF(F28=0, 0, 1), F28/H28),5)","v":6.8812499999999996},null,0,null,160,null,{"$f":"ROUND((N28-P28),5)","v":-160},null,{"$f":"ROUND(IF(P28=0, IF(N28=0, 0, 1), N28/P28),5)","v":0},null,{"$f":"ROUND(F28+N28,5)","v":1101},null,{"$f":"ROUND(H28+P28,5)","v":320},null,{"$f":"ROUND((V28-X28),5)","v":781},null,{"$f":"ROUND(IF(X28=0, IF(V28=0, 0, 1), V28/X28),5)","v":3.4406300000000001}]
[null,null,null,null,"62500 · Training",100,null,325,null,{"$f":"ROUND((F29-H29),5)","v":-225},null,{"$f":"ROUND(IF(H29=0, IF(F29=0, 0, 1), F29/H29),5)","v":0.30769000000000002},null,850,null,325,null,{"$f":"ROUND((N29-P29),5)","v":525},null,{"$f":"ROUND(IF(P29=0, IF(N29=0, 0, 1), N29/P29),5)","v":2.61538},null,{"$f":"ROUND(F29+N29,5)","v":950},null,{"$f":"ROUND(H29+P29,5)","v":650},null,{"$f":"ROUND((V29-X29),5)","v":300},null,{"$f":"ROUND(IF(X29=0, IF(V29=0, 0, 1), V29/X29),5)","v":1.4615400000000001}]
[null,null,null,null,"63000 · Insurance",2782,null,3923,null,{"$f":"ROUND((F30-H30),5)","v":-1141},null,{"$f":"ROUND(IF(H30=0, IF(F30=0, 0, 1), F30/H30),5)","v":0.70914999999999995},null,1417,null,3923,null,{"$f":"ROUND((N30-P30),5)","v":-2506},null,{"$f":"ROUND(IF(P30=0, IF(N30=0, 0, 1), N30/P30),5)","v":0.36120000000000002},null,{"$f":"ROUND(F30+N30,5)","v":4199},null,{"$f":"ROUND(H30+P30,5)","v":7846},null,{"$f":"ROUND((V30-X30),5)","v":-3647},null,{"$f":"ROUND(IF(X30=0, IF(V30=0, 0, 1), V30/X30),5)","v":0.53517999999999999}]
[null,null,null,null,"64000 · Supplies and Related",5656,null,3487,null,{"$f":"ROUND((F31-H31),5)","v":2169},null,{"$f":"ROUND(IF(H31=0, IF(F31=0, 0, 1), F31/H31),5)","v":1.62202},null,4729,null,3487,null,{"$f":"ROUND((N31-P31),5)","v":1242},null,{"$f":"ROUND(IF(P31=0, IF(N31=0, 0, 1), N31/P31),5)","v":1.3561799999999999},null,{"$f":"ROUND(F31+N31,5)","v":10385},null,{"$f":"ROUND(H31+P31,5)","v":6974},null,{"$f":"ROUND((V31-X31),5)","v":3411},null,{"$f":"ROUND(IF(X31=0, IF(V31=0, 0, 1), V31/X31),5)","v":1.4891000000000001}]
[null,null,null,null,"65000 · Professional Services",4557,null,3015,null,{"$f":"ROUND((F32-H32),5)","v":1542},null,{"$f":"ROUND(IF(H32=0, IF(F32=0, 0, 1), F32/H32),5)","v":1.5114399999999999},null,4038,null,3015,null,{"$f":"ROUND((N32-P32),5)","v":1023},null,{"$f":"ROUND(IF(P32=0, IF(N32=0, 0, 1), N32/P32),5)","v":1.3392999999999999},null,{"$f":"ROUND(F32+N32,5)","v":8595},null,{"$f":"ROUND(H32+P32,5)","v":6030},null,{"$f":"ROUND((V32-X32),5)","v":2565},null,{"$f":"ROUND(IF(X32=0, IF(V32=0, 0, 1), V32/X32),5)","v":1.42537}]
[null,null,null,null,"65050 · Other Outside Services",322,null,2579,null,{"$f":"ROUND((F33-H33),5)","v":-2257},null,{"$f":"ROUND(IF(H33=0, IF(F33=0, 0, 1), F33/H33),5)","v":0.12485},null,971,null,2579,null,{"$f":"ROUND((N33-P33),5)","v":-1608},null,{"$f":"ROUND(IF(P33=0, IF(N33=0, 0, 1), N33/P33),5)","v":0.3765},null,{"$f":"ROUND(F33+N33,5)","v":1293},null,{"$f":"ROUND(H33+P33,5)","v":5158},null,{"$f":"ROUND((V33-X33),5)","v":-3865},null,{"$f":"ROUND(IF(X33=0, IF(V33=0, 0, 1), V33/X33),5)","v":0.25068000000000001}]
[null,null,null,null,"66000 · Bank and Other Service Charges",462,null,290,null,{"$f":"ROUND((F34-H34),5)","v":172},null,{"$f":"ROUND(IF(H34=0, IF(F34=0, 0, 1), F34/H34),5)","v":1.5931},null,252,null,290,null,{"$f":"ROUND((N34-P34),5)","v":-38},null,{"$f":"ROUND(IF(P34=0, IF(N34=0, 0, 1), N34/P34),5)","v":0.86897000000000002},null,{"$f":"ROUND(F34+N34,5)","v":714},null,{"$f":"ROUND(H34+P34,5)","v":580},null,{"$f":"ROUND((V34-X34),5)","v":134},null,{"$f":"ROUND(IF(X34=0, IF(V34=0, 0, 1), V34/X34),5)","v":1.2310300000000001}]
[null,null,null,null,"67000 · Taxes and Fees",0,null,0,null,{"$f":"ROUND((F35-H35),5)","v":0},null,{"$f":"ROUND(IF(H35=0, IF(F35=0, 0, 1), F35/H35),5)","v":0},null,7112,null,7000,null,{"$f":"ROUND((N35-P35),5)","v":112},null,{"$f":"ROUND(IF(P35=0, IF(N35=0, 0, 1), N35/P35),5)","v":1.016},null,{"$f":"ROUND(F35+N35,5)","v":7112},null,{"$f":"ROUND(H35+P35,5)","v":7000},null,{"$f":"ROUND((V35-X35),5)","v":112},null,{"$f":"ROUND(IF(X35=0, IF(V35=0, 0, 1), V35/X35),5)","v":1.016}]
[null,null,null,null,"68000 · Utilities",5149,null,5801,null,{"$f":"ROUND((F36-H36),5)","v":-652},null,{"$f":"ROUND(IF(H36=0, IF(F36=0, 0, 1), F36/H36),5)","v":0.88761000000000001},null,5827,null,5801,null,{"$f":"ROUND((N36-P36),5)","v":26},null,{"$f":"ROUND(IF(P36=0, IF(N36=0, 0, 1), N36/P36),5)","v":1.00448},null,{"$f":"ROUND(F36+N36,5)","v":10976},null,{"$f":"ROUND(H36+P36,5)","v":11602},null,{"$f":"ROUND((V36-X36),5)","v":-626},null,{"$f":"ROUND(IF(X36=0, IF(V36=0, 0, 1), V36/X36),5)","v":0.94603999999999999}]
[null,null,null,"Total Expense",null,{"$f":"ROUND(SUM(F13:F36),5)","v":141308},null,{"$f":"ROUND(SUM(H13:H36),5)","v":145872},null,{"$f":"ROUND((F37-H37),5)","v":-4564},null,{"$f":"ROUND(IF(H37=0, IF(F37=0, 0, 1), F37/H37),5)","v":0.96870999999999996},null,{"$f":"ROUND(SUM(N13:N36),5)","v":142580},null,{"$f":"ROUND(SUM(P13:P36),5)","v":159606},null,{"$f":"ROUND((N37-P37),5)","v":-17026},null,{"$f":"ROUND(IF(P37=0, IF(N37=0, 0, 1), N37/P37),5)","v":0.89332},null,{"$f":"ROUND(F37+N37,5)","v":283888},null,{"$f":"ROUND(H37+P37,5)","v":305478},null,{"$f":"ROUND((V37-X37),5)","v":-21590},null,{"$f":"ROUND(IF(X37=0, IF(V37=0, 0, 1), V37/X37),5)","v":0.92932000000000003}]
[null,"Net Ordinary Income",null,null,null,{"$f":"ROUND(F3+F12-F37,5)","v":-25843},null,{"$f":"ROUND(H3+H12-H37,5)","v":-54813},null,{"$f":"ROUND((F38-H38),5)","v":28970},null,{"$f":"ROUND(IF(H38=0, IF(F38=0, 0, 1), F38/H38),5)","v":0.47148000000000001},null,{"$f":"ROUND(N3+N12-N37,5)","v":-15271},null,{"$f":"ROUND(P3+P12-P37,5)","v":-52457},null,{"$f":"ROUND((N38-P38),5)","v":37186},null,{"$f":"ROUND(IF(P38=0, IF(N38=0, 0, 1), N38/P38),5)","v":0.29110999999999998},null,{"$f":"ROUND(F38+N38,5)","v":-41114},null,{"$f":"ROUND(H38+P38,5)","v":-107270},null,{"$f":"ROUND((V38-X38),5)","v":66156},null,{"$f":"ROUND(IF(X38=0, IF(V38=0, 0, 1), V38/X38),5)","v":0.38328000000000001}]
[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,{"$f":"ROUND(F41+N41,5)","v":1},null,{"$f":"ROUND(H41+P41,5)","v":2},null,{"$f":"ROUND((V41-X41),5)","v":-1},null,{"$f":"ROUND(IF(X41=0, IF(V41=0, 0, 1), V41/X41),5)","v":0.5}]
[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,{"$f":"ROUND(F42+N42,5)","v":250},null,{"$f":"ROUND(H42+P42,5)","v":250},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,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,{"$f":"ROUND(F43+N43,5)","v":850},null,{"$f":"ROUND(H43+P43,5)","v":0},null,{"$f":"ROUND((V43-X43),5)","v":850},null,{"$f":"ROUND(IF(X43=0, IF(V43=0, 0, 1), V43/X43),5)","v":1}]
[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(F44+N44,5)","v":1101},null,{"$f":"ROUND(H44+P44,5)","v":252},null,{"$f":"ROUND((V44-X44),5)","v":849},null,{"$f":"ROUND(IF(X44=0, IF(V44=0, 0, 1), V44/X44),5)","v":4.3690499999999997}]
["Net Income (loss) excluding depreciation",null,null,null,null,{"$f":"F38+F44","v":-25717},null,{"$f":"H38+H44","v":-54687},null,{"$f":"ROUND((F45-H45),5)","v":28970},null,{"$f":"ROUND(IF(H45=0, IF(F45=0, 0, 1), F45/H45),5)","v":0.47026000000000001},null,{"$f":"N38+N44","v":-14296},null,{"$f":"P38+P44","v":-52331},null,{"$f":"ROUND((N45-P45),5)","v":38035},null,{"$f":"ROUND(IF(P45=0, IF(N45=0, 0, 1), N45/P45),5)","v":0.27317999999999998},null,{"$f":"V38+V44","v":-40013},null,{"$f":"X38+X44","v":-107018},null,{"$f":"ROUND((V45-X45),5)","v":67005},null,{"$f":"ROUND(IF(X45=0, IF(V45=0, 0, 1), V45/X45),5)","v":0.37389}]

{"sheet":"Rev by Type YTD","index":1,"n_rows":13,"n_cols":14,"rows_kept":13,"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,132450,null,{"$f":"ROUND(SUM(F4:L4),5)","v":132450}]
[null,null,null,null,"40100 · Meal Sales",12092,null,8502,null,5895,null,60494,null,{"$f":"ROUND(SUM(F5:L5),5)","v":86983}]
[null,null,null,null,"40200 · Beverage Sales",1500,null,1500,null,0,null,11988,null,{"$f":"ROUND(SUM(F6:L6),5)","v":14988}]
[null,null,null,null,"40300 · Service Fees",1449,null,1299,null,6,null,4623,null,{"$f":"ROUND(SUM(F7:L7),5)","v":7377}]
[null,null,null,null,"40800 · Other Income",0,null,600,null,0,null,375,null,{"$f":"ROUND(SUM(F8:L8),5)","v":975}]
[null,null,null,"Total Income",null,{"$f":"ROUND(SUM(F3:F8),5)","v":15041},null,{"$f":"ROUND(SUM(H3:H8),5)","v":11901},null,{"$f":"ROUND(SUM(J3:J8),5)","v":5901},null,{"$f":"ROUND(SUM(L3:L8),5)","v":209930},null,{"$f":"ROUND(SUM(F9:L9),5)","v":242773}]
[null,null,"Prior Year Revenues",null,null,7567,null,2528,null,3400,null,191506,null,{"$f":"ROUND(SUM(F10:L10),5)","v":205001}]
[null,null,"Change from Prior Year",null,null,{"$f":"F9-F10","v":7474},null,{"$f":"H9-H10","v":9373},null,{"$f":"J9-J10","v":2501},null,{"$f":"L9-L10","v":18424},null,{"$f":"ROUND(SUM(F11:L11),5)","v":37772}]
[]
[null,null,"% of Total Revenues",null,null,{"$f":"F9/N9","v":6.195499499532485E-2},null,{"$f":"H9/N9","v":4.9021102017110636E-2},null,{"$f":"J9/N9","v":2.4306656835809584E-2},null,{"$f":"L9/N9","v":0.86471724615175494},null,{"$f":"SUM(F13:L13)","v":1}]

{"sheet":"Balance Sheet","index":2,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"Feb 28, 23",null,"Feb 28, 22",null,"$ Change",null,"% Change"]
["ASSETS"]
[null,"Current Assets"]
[null,null,"Checking/Savings",null,472803,null,598445,null,{"$f":"ROUND((E5-G5),5)","v":-125642},null,{"$f":"ROUND(IF(E5=0, IF(G5=0, 0, SIGN(-G5)), IF(G5=0, SIGN(E5), (E5-G5)/ABS(G5))),5)","v":-0.20995}]
[null,null,"Accounts Receivable",null,109216,null,83964,null,{"$f":"ROUND((E6-G6),5)","v":25252},null,{"$f":"ROUND(IF(E6=0, IF(G6=0, 0, SIGN(-G6)), IF(G6=0, SIGN(E6), (E6-G6)/ABS(G6))),5)","v":0.30075000000000002}]
[null,null,"Other Current Assets",null,42756,null,39967,null,{"$f":"ROUND((E7-G7),5)","v":2789},null,{"$f":"ROUND(IF(E7=0, IF(G7=0, 0, SIGN(-G7)), IF(G7=0, SIGN(E7), (E7-G7)/ABS(G7))),5)","v":6.9779999999999995E-2}]
[null,"Total Current Assets",null,null,{"$f":"ROUND(SUM(E4:E7),5)","v":624775},null,{"$f":"ROUND(SUM(G4:G7),5)","v":722376},null,{"$f":"ROUND((E8-G8),5)","v":-97601},null,{"$f":"ROUND(IF(E8=0, IF(G8=0, 0, SIGN(-G8)), IF(G8=0, SIGN(E8), (E8-G8)/ABS(G8))),5)","v":-0.13511000000000001}]
[null,"Fixed Assets",null,null,1042555,null,695037,null,{"$f":"ROUND((E9-G9),5)","v":347518},null,{"$f":"ROUND(IF(E9=0, IF(G9=0, 0, SIGN(-G9)), IF(G9=0, SIGN(E9), (E9-G9)/ABS(G9))),5)","v":0.5}]
["TOTAL ASSETS",null,null,null,{"$f":"ROUND(E3+SUM(E8:E9),5)","v":1667330},null,{"$f":"ROUND(G3+SUM(G8:G9),5)","v":1417413},null,{"$f":"ROUND((E10-G10),5)","v":249917},null,{"$f":"ROUND(IF(E10=0, IF(G10=0, 0, SIGN(-G10)), IF(G10=0, SIGN(E10), (E10-G10)/ABS(G10))),5)","v":0.17632}]
["LIABILITIES & EQUITY"]
[null,"Liabilities"]
[null,null,"Current Liabilities"]
[null,null,null,"Accounts Payable",33706,null,27342,null,{"$f":"ROUND((E14-G14),5)","v":6364},null,{"$f":"ROUND(IF(E14=0, IF(G14=0, 0, SIGN(-G14)), IF(G14=0, SIGN(E14), (E14-G14)/ABS(G14))),5)","v":0.23275999999999999}]
[null,null,null,"Other Current Liabilities",13335,null,2421,null,{"$f":"ROUND((E15-G15),5)","v":10914},null,{"$f":"ROUND(IF(E15=0, IF(G15=0, 0, SIGN(-G15)), IF(G15=0, SIGN(E15), (E15-G15)/ABS(G15))),5)","v":4.5080499999999999}]
[null,null,"Total Current Liabilities",null,{"$f":"ROUND(SUM(E13:E15),5)","v":47041},null,{"$f":"ROUND(SUM(G13:G15),5)","v":29763},null,{"$f":"ROUND((E16-G16),5)","v":17278},null,{"$f":"ROUND(IF(E16=0, IF(G16=0, 0, SIGN(-G16)), IF(G16=0, SIGN(E16), (E16-G16)/ABS(G16))),5)","v":0.58052000000000004}]
[null,"Total Liabilities",null,null,{"$f":"ROUND(E12+E16,5)","v":47041},null,{"$f":"ROUND(G12+G16,5)","v":29763},null,{"$f":"ROUND((E17-G17),5)","v":17278},null,{"$f":"ROUND(IF(E17=0, IF(G17=0, 0, SIGN(-G17)), IF(G17=0, SIGN(E17), (E17-G17)/ABS(G17))),5)","v":0.58052000000000004}]
[null,"Equity",null,null,1620290,null,1387649,null,{"$f":"ROUND((E18-G18),5)","v":232641},null,{"$f":"ROUND(IF(E18=0, IF(G18=0, 0, SIGN(-G18)), IF(G18=0, SIGN(E18), (E18-G18)/ABS(G18))),5)","v":0.16764999999999999}]
["TOTAL LIABILITIES & EQUITY",null,null,null,{"$f":"ROUND(E11+SUM(E17:E18),5)","v":1667331},null,{"$f":"ROUND(G11+SUM(G17:G18),5)","v":1417412},null,{"$f":"ROUND((E19-G19),5)","v":249919},null,{"$f":"ROUND(IF(E19=0, IF(G19=0, 0, SIGN(-G19)), IF(G19=0, SIGN(E19), (E19-G19)/ABS(G19))),5)","v":0.17632}]