{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Income Exp","Sales - Purchase","Settings"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":13,"comments":1,"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":"Income Exp","index":0,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Income and Expenses"]
[]
["Account","Date","Description","Category","✔","Income Money IN","Expense Money OUT","Account Balance","Overall Balance"]
["Checking","2017-09-01","Beginning Balance","[Balance]",null,750,null,{"$f":"SUMIF($A$3:OFFSET(A4,0,0),A4,$F$3:OFFSET(F4,0,0))-SUMIF($A$3:OFFSET(A4,0,0),A4,$G$3:OFFSET(G4,0,0))","v":750},{"$f":"IF(ISBLANK(B4),\" - \",IFERROR(OFFSET(I4,-1,0,1,1)+F4-G4,F4-G4))","v":750}]
["Cash","2017-09-01","Beginning Balance","[Balance]",null,50,null,{"$f":"SUMIF($A$3:OFFSET(A5,0,0),A5,$F$3:OFFSET(F5,0,0))-SUMIF($A$3:OFFSET(A5,0,0),A5,$G$3:OFFSET(G5,0,0))","v":50},800]
["Credit","2017-09-01","Beginning Balance","[Balance]",null,null,340,{"$f":"SUMIF($A$3:OFFSET(A6,0,0),A6,$F$3:OFFSET(F6,0,0))-SUMIF($A$3:OFFSET(A6,0,0),A6,$G$3:OFFSET(G6,0,0))","v":-340},460]
["Savings","2017-09-01","Beginning Balance","[Balance]",null,850,null,{"$f":"SUMIF($A$3:OFFSET(A7,0,0),A7,$F$3:OFFSET(F7,0,0))-SUMIF($A$3:OFFSET(A7,0,0),A7,$G$3:OFFSET(G7,0,0))","v":850},1310]
["Cash","2017-09-15","ATM","[Transfer]",null,50,null,{"$f":"SUMIF($A$3:OFFSET(A8,0,0),A8,$F$3:OFFSET(F8,0,0))-SUMIF($A$3:OFFSET(A8,0,0),A8,$G$3:OFFSET(G8,0,0))","v":100},1360]
["Checking","2017-09-15","ATM","[Transfer]",null,null,50,{"$f":"SUMIF($A$3:OFFSET(A9,0,0),A9,$F$3:OFFSET(F9,0,0))-SUMIF($A$3:OFFSET(A9,0,0),A9,$G$3:OFFSET(G9,0,0))","v":700},1310]
["Credit","2017-09-20","Jay's Auto Mart","Fuel",null,null,34.58,{"$f":"SUMIF($A$3:OFFSET(A10,0,0),A10,$F$3:OFFSET(F10,0,0))-SUMIF($A$3:OFFSET(A10,0,0),A10,$G$3:OFFSET(G10,0,0))","v":-374.58},1275.42]
["Checking","2017-09-22","Smith's","Groceries",null,null,25.12,{"$f":"SUMIF($A$3:OFFSET(A11,0,0),A11,$F$3:OFFSET(F11,0,0))-SUMIF($A$3:OFFSET(A11,0,0),A11,$G$3:OFFSET(G11,0,0))","v":674.88},1250.3000000000002]
["Checking","2017-09-30","Credit Card Interest","Interest Expense",null,null,6.5,{"$f":"SUMIF($A$3:OFFSET(A12,0,0),A12,$F$3:OFFSET(F12,0,0))-SUMIF($A$3:OFFSET(A12,0,0),A12,$G$3:OFFSET(G12,0,0))","v":668.38},1243.8000000000002]
["Checking","2017-09-30","Credit Card Principal","[Transfer]",null,null,374.58,{"$f":"SUMIF($A$3:OFFSET(A13,0,0),A13,$F$3:OFFSET(F13,0,0))-SUMIF($A$3:OFFSET(A13,0,0),A13,$G$3:OFFSET(G13,0,0))","v":293.8},869.22000000000025]
["Credit","2017-09-30","Credit Card Principal","[Transfer]",null,374.58,null,{"$f":"SUMIF($A$3:OFFSET(A14,0,0),A14,$F$3:OFFSET(F14,0,0))-SUMIF($A$3:OFFSET(A14,0,0),A14,$G$3:OFFSET(G14,0,0))","v":0},1243.8000000000002]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A15,0,0),A15,$F$3:OFFSET(F15,0,0))-SUMIF($A$3:OFFSET(A15,0,0),A15,$G$3:OFFSET(G15,0,0))","v":0}," - "]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A16,0,0),A16,$F$3:OFFSET(F16,0,0))-SUMIF($A$3:OFFSET(A16,0,0),A16,$G$3:OFFSET(G16,0,0))","v":0},{"$f":"IF(ISBLANK(B16),\" - \",IFERROR(OFFSET(I16,-1,0,1,1)+F16-G16,F16-G16))","v":" - "}]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A17,0,0),A17,$F$3:OFFSET(F17,0,0))-SUMIF($A$3:OFFSET(A17,0,0),A17,$G$3:OFFSET(G17,0,0))","v":0}," - "]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A18,0,0),A18,$F$3:OFFSET(F18,0,0))-SUMIF($A$3:OFFSET(A18,0,0),A18,$G$3:OFFSET(G18,0,0))","v":0}," - "]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A19,0,0),A19,$F$3:OFFSET(F19,0,0))-SUMIF($A$3:OFFSET(A19,0,0),A19,$G$3:OFFSET(G19,0,0))","v":0},{"$f":"IF(ISBLANK(B19),\" - \",IFERROR(OFFSET(I19,-1,0,1,1)+F19-G19,F19-G19))","v":" - "}]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A20,0,0),A20,$F$3:OFFSET(F20,0,0))-SUMIF($A$3:OFFSET(A20,0,0),A20,$G$3:OFFSET(G20,0,0))","v":0}," - "]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A21,0,0),A21,$F$3:OFFSET(F21,0,0))-SUMIF($A$3:OFFSET(A21,0,0),A21,$G$3:OFFSET(G21,0,0))","v":0}," - "]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A22,0,0),A22,$F$3:OFFSET(F22,0,0))-SUMIF($A$3:OFFSET(A22,0,0),A22,$G$3:OFFSET(G22,0,0))","v":0}," - "]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A23,0,0),A23,$F$3:OFFSET(F23,0,0))-SUMIF($A$3:OFFSET(A23,0,0),A23,$G$3:OFFSET(G23,0,0))","v":0}," - "]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A24,0,0),A24,$F$3:OFFSET(F24,0,0))-SUMIF($A$3:OFFSET(A24,0,0),A24,$G$3:OFFSET(G24,0,0))","v":0}," - "]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A25,0,0),A25,$F$3:OFFSET(F25,0,0))-SUMIF($A$3:OFFSET(A25,0,0),A25,$G$3:OFFSET(G25,0,0))","v":0}," - "]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A26,0,0),A26,$F$3:OFFSET(F26,0,0))-SUMIF($A$3:OFFSET(A26,0,0),A26,$G$3:OFFSET(G26,0,0))","v":0}," - "]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A27,0,0),A27,$F$3:OFFSET(F27,0,0))-SUMIF($A$3:OFFSET(A27,0,0),A27,$G$3:OFFSET(G27,0,0))","v":0}," - "]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A28,0,0),A28,$F$3:OFFSET(F28,0,0))-SUMIF($A$3:OFFSET(A28,0,0),A28,$G$3:OFFSET(G28,0,0))","v":0}," - "]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A29,0,0),A29,$F$3:OFFSET(F29,0,0))-SUMIF($A$3:OFFSET(A29,0,0),A29,$G$3:OFFSET(G29,0,0))","v":0}," - "]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A30,0,0),A30,$F$3:OFFSET(F30,0,0))-SUMIF($A$3:OFFSET(A30,0,0),A30,$G$3:OFFSET(G30,0,0))","v":0}," - "]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A31,0,0),A31,$F$3:OFFSET(F31,0,0))-SUMIF($A$3:OFFSET(A31,0,0),A31,$G$3:OFFSET(G31,0,0))","v":0}," - "]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A32,0,0),A32,$F$3:OFFSET(F32,0,0))-SUMIF($A$3:OFFSET(A32,0,0),A32,$G$3:OFFSET(G32,0,0))","v":0}," - "]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A33,0,0),A33,$F$3:OFFSET(F33,0,0))-SUMIF($A$3:OFFSET(A33,0,0),A33,$G$3:OFFSET(G33,0,0))","v":0}," - "]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A34,0,0),A34,$F$3:OFFSET(F34,0,0))-SUMIF($A$3:OFFSET(A34,0,0),A34,$G$3:OFFSET(G34,0,0))","v":0}," - "]
[{"$nulls":7},{"$f":"SUMIF($A$3:OFFSET(A35,0,0),A35,$F$3:OFFSET(F35,0,0))-SUMIF($A$3:OFFSET(A35,0,0),A35,$G$3:OFFSET(G35,0,0))","v":0}," - "]
["Total",{"$nulls":4},{"$f":"SUBTOTAL(109,Table42[Income Money IN])","v":2074.58},{"$f":"SUBTOTAL(109,Table42[Expense Money OUT])","v":830.78},null,{"$f":"Table42[[#Totals],[Income Money IN]]-Table42[[#Totals],[Expense Money OUT]]","v":1243.8}]

{"sheet":"Sales - Purchase","index":1,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Date","Nature","Party","Taxable Amount","SGST","CGST","IGST"]
[null,"Sale"]
[null,"Purchase"]

{"sheet":"Settings","index":2,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Accounts",null,"Categories",null,"Descriptions",null,"Date"]
[]
["Cash",null,"[Balance]",null,"Beginning Balance",null,{"$f":"TODAY()","v":"2019-09-09"},null,"These lists are used to populate the"]
["Checking",null,"[Transfer]",null,"To/From Savings",null,{"$f":"G3-1","v":"2019-09-08"},null,"drop-down boxes."]
["Savings",null,"Cell phones",null,"To/From Cash",null,"2019-09-07"]
["Credit",null,"Dining",null,"To/From Checking",null,"2019-09-06",null,"You can edit these list as needed."]
[null,null,"Entertainment",null,"To/From Credit",null,"2019-09-05"]
[null,null,"Fuel",null,"Paycheck",null,"2019-09-04"]
[null,null,"Groceries",null,"Jay's Auto Mart",null,"2019-09-03"]
[null,null,"Insurance",null,"ATM",null,"2019-09-02"]
[null,null,"Interest Expense",null,"Smith's",null,{"$f":"G10-1","v":"2019-09-01"}]
[null,null,"Interest Income",null,null,null,"2019-08-31"]
[null,null,"Miscellaneous",null,null,null,"2019-08-30"]
[null,null,"Offerings",null,null,null,"2019-08-29"]
[null,null,"Rent",null,null,null,"2019-08-28"]
[null,null,"Savings",null,null,null,"2019-08-27"]
[null,null,"Tithing",null,null,null,"2019-08-26"]
[null,null,"Transportation"]
[null,null,"Utilities"]