{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["QuickBooks Desktop Export Tips","Sheet1"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":105,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"QuickBooks Desktop Export Tips","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet1","index":1,"n_rows":33,"n_cols":31,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[{"$nulls":6},"Jan 25",null,"Feb 25",null,"Mar 25",null,"Apr 25",null,"May 25",null,"Jun 25",null,"Jul 25",null,"Aug 25",null,"Sep 25",null,"Oct 25",null,"Nov 25",null,"Dec 25",null,"TOTAL"]
[null,"Ordinary Income/Expense"]
[null,null,null,"Income"]
[{"$nulls":4},"41000 · Rental Income"]
[{"$nulls":5},"41100 · Apartment Rental",21600,null,22803,null,23600,null,23600,null,23600,null,24725,null,24000,null,22550,null,22550,null,21200,null,21200,null,17500,null,{"$f":"ROUND(SUM(G5:AC5),5)","v":268928}]
[{"$nulls":5},"41200 · Hotel Rental",5835,null,7635,null,10445,null,20330,null,4490,null,10955,null,21235,null,28341.5,null,26409.5,null,25560,null,14275,null,14015,null,189526]
[{"$nulls":5},"41300 · Commercial Rental",10750,null,10750,null,10750,null,7750,null,8750,null,7750,null,8750,null,8750,null,7750,null,10750,null,10750,null,10750,null,114000]
[{"$nulls":4},"Total 41000 · Rental Income",null,{"$f":"ROUND(SUM(G4:G7),5)","v":38185},null,{"$f":"ROUND(SUM(I4:I7),5)","v":41188},null,{"$f":"ROUND(SUM(K4:K7),5)","v":44795},null,{"$f":"ROUND(SUM(M4:M7),5)","v":51680},null,{"$f":"ROUND(SUM(O4:O7),5)","v":36840},null,{"$f":"ROUND(SUM(Q4:Q7),5)","v":43430},null,{"$f":"ROUND(SUM(S4:S7),5)","v":53985},null,{"$f":"ROUND(SUM(U4:U7),5)","v":59641.5},null,{"$f":"ROUND(SUM(W4:W7),5)","v":56709.5},null,{"$f":"ROUND(SUM(Y4:Y7),5)","v":57510},null,{"$f":"ROUND(SUM(AA4:AA7),5)","v":46225},null,{"$f":"ROUND(SUM(AC4:AC7),5)","v":42265},null,572454]
[{"$nulls":4},"42000 · Sales Tax Discount",null,27.52,null,9.34,null,12.22,null,16.71,null,32.53,null,7.19,null,14.14,null,16.02,null,15.34,null,29.59,null,32.450000000000003,null,0,null,213.05]
[null,null,null,"Total Income",null,null,{"$f":"ROUND(G3+SUM(G8:G9),5)","v":38212.519999999997},null,{"$f":"ROUND(I3+SUM(I8:I9),5)","v":41197.339999999997},null,{"$f":"ROUND(K3+SUM(K8:K9),5)","v":44807.22},null,{"$f":"ROUND(M3+SUM(M8:M9),5)","v":51696.71},null,{"$f":"ROUND(O3+SUM(O8:O9),5)","v":36872.53},null,{"$f":"ROUND(Q3+SUM(Q8:Q9),5)","v":43437.19},null,{"$f":"ROUND(S3+SUM(S8:S9),5)","v":53999.14},null,{"$f":"ROUND(U3+SUM(U8:U9),5)","v":59657.52},null,{"$f":"ROUND(W3+SUM(W8:W9),5)","v":56724.84},null,{"$f":"ROUND(Y3+SUM(Y8:Y9),5)","v":57539.59},null,{"$f":"ROUND(AA3+SUM(AA8:AA9),5)","v":46257.45},null,{"$f":"ROUND(AC3+SUM(AC8:AC9),5)","v":42265},null,572667.05000000005]
[null,null,"Gross Profit",null,null,null,{"$f":"G10","v":38212.519999999997},null,{"$f":"I10","v":41197.339999999997},null,{"$f":"K10","v":44807.22},null,{"$f":"M10","v":51696.71},null,{"$f":"O10","v":36872.53},null,{"$f":"Q10","v":43437.19},null,{"$f":"S10","v":53999.14},null,{"$f":"U10","v":59657.52},null,{"$f":"W10","v":56724.84},null,{"$f":"Y10","v":57539.59},null,{"$f":"AA10","v":46257.45},null,{"$f":"AC10","v":42265},null,572667.05000000005]
[null,null,null,"Expense"]
[{"$nulls":4},"62000 · Bank Charges",null,36,null,10,null,0,null,0,null,0,null,0,null,36,null,0,null,0,null,0,null,0,null,0,null,{"$f":"ROUND(SUM(G13:AC13),5)","v":82}]
[{"$nulls":4},"63000 · Reservation Clerk",null,0,null,0,null,3750,null,0,null,0,null,3750,null,0,null,0,null,3750,null,0,null,0,null,3750,null,15000]
[{"$nulls":4},"63300 · Insurance Expense",null,2074.75,null,2074.75,null,4032.25,null,8181.75,null,2682.25,null,5364.5,null,2682.25,null,0,null,5364.5,null,0,null,2682.25,null,5364.5,null,40503.75]
[{"$nulls":4},"63700 · Grounds and Maintenance",null,0,null,0,null,0,null,358.88,null,0,null,0,null,0,null,0,null,118.71,null,0,null,125.63,null,0,null,603.22]
[{"$nulls":4},"66250 · License and Permits",null,0,null,0,null,0,null,0,null,254,null,0,null,0,null,0,null,33,null,0,null,0,null,0,null,287]
[{"$nulls":4},"66500 · Postage and Delivery",null,0,null,0,null,0,null,64.599999999999994,null,0,null,0,null,0,null,0,null,0,null,68.599999999999994,null,0,null,0,null,133.19999999999999]
[{"$nulls":4},"66600 · Audit and Tax Fees",null,0,null,0,null,0,null,0,null,53.14,null,0,null,0,null,0,null,0,null,0,null,0,null,339.97,null,393.11]
[{"$nulls":4},"66700 · Professional Fees",null,1093.2,null,424.47,null,977.15,null,705.78,null,1658.71,null,306.97000000000003,null,666.87,null,1728.1,null,1287.47,null,1628.09,null,1564.09,null,1235.6400000000001,null,13276.54]
[{"$nulls":4},"66750 · Dues and Subscriptions",null,348,null,0,null,0,null,0,null,0,null,0,null,187.03,null,2448,null,0,null,0,null,0,null,204,null,3187.03]
[{"$nulls":4},"67000 · Security Monitoring",null,1061.32,null,40,null,0,null,144.44999999999999,null,138.57,null,90.45,null,144.44999999999999,null,0,null,0,null,144.44999999999999,null,101.65,null,642,null,2507.34]
[{"$nulls":4},"67100 · Rent Expense",null,500,null,500,null,500,null,500,null,500,null,500,null,0,null,1000,null,500,null,500,null,500,null,500,null,6000]
[{"$nulls":4},"67150 · Housekeeping",null,1480,null,0,null,0,null,1570,null,0,null,1520,null,1100,null,0,null,1520,null,0,null,1530,null,1530,null,10250]
[{"$nulls":4},"67155 · Room Supplies",null,957.68,null,8.52,null,326.13,null,247.92,null,523.29999999999995,null,55.61,null,187.91,null,224.64,null,329.06,null,106.99,null,153.1,null,7.33,null,3128.19]
[{"$nulls":4},"67175 · Linens",null,0,null,0,null,0,null,320.97000000000003,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,320.97000000000003]
[{"$nulls":4},"67200 · Repairs and Maintenance",null,1012.58,null,1431.6,null,631.16999999999996,null,767.5,null,2519.52,null,647.59,null,1074.79,null,1030.82,null,393.04,null,1129.6300000000001,null,1485.32,null,1452.55,null,13576.11]
[{"$nulls":4},"68100 · Telephone Expense-Answering Ser",null,117.7,null,117.7,null,117.7,null,117.7,null,117.7,null,117.7,null,117.7,null,117.7,null,0,null,0,null,235.4,null,0,null,1177]
[{"$nulls":4},"68600 · Utilities",null,5121.51,null,5695.87,null,7928.56,null,4340.55,null,5223.3599999999997,null,5352.69,null,6405.41,null,7581.55,null,6888.85,null,5244.77,null,3794.08,null,4104.04,null,67681.240000000005]
[{"$nulls":4},"70000 · Property Taxes",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,43072.65,null,43072.65]
[null,null,null,"Total Expense",null,null,{"$f":"ROUND(SUM(G12:G30),5)","v":13802.74},null,{"$f":"ROUND(SUM(I12:I30),5)","v":10302.91},null,{"$f":"ROUND(SUM(K12:K30),5)","v":18262.96},null,{"$f":"ROUND(SUM(M12:M30),5)","v":17320.099999999999},null,{"$f":"ROUND(SUM(O12:O30),5)","v":13670.55},null,{"$f":"ROUND(SUM(Q12:Q30),5)","v":17705.509999999998},null,{"$f":"ROUND(SUM(S12:S30),5)","v":12602.41},null,{"$f":"ROUND(SUM(U12:U30),5)","v":14130.81},null,{"$f":"ROUND(SUM(W12:W30),5)","v":20184.63},null,{"$f":"ROUND(SUM(Y12:Y30),5)","v":8822.5300000000007},null,{"$f":"ROUND(SUM(AA12:AA30),5)","v":12171.52},null,{"$f":"ROUND(SUM(AC12:AC30),5)","v":62202.68},null,221179.35]
[null,"Net Ordinary Income",{"$nulls":4},{"$f":"ROUND(G2+G11-G31,5)","v":24409.78},null,{"$f":"ROUND(I2+I11-I31,5)","v":30894.43},null,{"$f":"ROUND(K2+K11-K31,5)","v":26544.26},null,{"$f":"ROUND(M2+M11-M31,5)","v":34376.61},null,{"$f":"ROUND(O2+O11-O31,5)","v":23201.98},null,{"$f":"ROUND(Q2+Q11-Q31,5)","v":25731.68},null,{"$f":"ROUND(S2+S11-S31,5)","v":41396.730000000003},null,{"$f":"ROUND(U2+U11-U31,5)","v":45526.71},null,{"$f":"ROUND(W2+W11-W31,5)","v":36540.21},null,{"$f":"ROUND(Y2+Y11-Y31,5)","v":48717.06},null,{"$f":"ROUND(AA2+AA11-AA31,5)","v":34085.93},null,{"$f":"ROUND(AC2+AC11-AC31,5)","v":-19937.68},null,351487.7]
["Net Income",{"$nulls":5},{"$f":"G32","v":24409.78},null,{"$f":"I32","v":30894.43},null,{"$f":"K32","v":26544.26},null,{"$f":"M32","v":34376.61},null,{"$f":"O32","v":23201.98},null,{"$f":"Q32","v":25731.68},null,{"$f":"S32","v":41396.730000000003},null,{"$f":"U32","v":45526.71},null,{"$f":"W32","v":36540.21},null,{"$f":"Y32","v":48717.06},null,{"$f":"AA32","v":34085.93},null,{"$f":"AC32","v":-19937.68},null,351487.7]