{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Check Register","Chase"],"not_rendered":{"macros":1,"defined_names":6,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Check Register","index":0,"n_rows":17,"n_cols":11,"rows_kept":17,"merged":[[0,1,0,2],[0,3,0,4],[0,5,0,6]]}
["Balance",{"$f":"SUM(RegisterTable[Amount])","v":{"v":715.71,"d":"$715.71"}},null,"Banks balance",null,{"$f":"SUMIF(E3:E8, \"Y\", RegisterTable[Amount])","v":{"v":465.71,"d":"$465.71"}},{"$nulls":3},"bank_reconcile_settings"]
["Date","Check #","Name","Description","cleared","Amount","Balance",null,null,"start cell to work on, should be a cell reference","=E3"]
["2020-01-02","deposit",null,null,"Y",{"v":509,"d":"$509.00"},{"$f":"RegisterTable[[#This Row],[Amount]]","v":{"v":509,"d":"$509.00"}},null,null,"Amount column, on this sheet ",{"$f":"F:F","v":509}]
["2020-01-02","fee",null,null,"Y",{"v":-25,"d":"$(25.00)"},{"$f":"IF(ISBLANK(RegisterTable[[#This Row],[Amount]]), \"\", SUM(G3,RegisterTable[[#This Row],[Amount]]))","v":{"v":484,"d":"$484.00"}},null,null,"Amount column, on sheet compared","=Chase!D:D"]
["2020-01-06","check #199","abc name",null,"Y",{"v":-18.29,"d":"$(18.29)"},{"$f":"IF(ISBLANK(RegisterTable[[#This Row],[Amount]]), \"\", SUM(G4,RegisterTable[[#This Row],[Amount]]))","v":{"v":465.71,"d":"$465.71"}},null,null,"Date column, on this sheet ","=A:A"]
["2020-01-06","Deposit",null,null,"X",{"v":500,"d":"$500.00"},{"$f":"IF(ISBLANK(RegisterTable[[#This Row],[Amount]]), \"\", SUM(G5,RegisterTable[[#This Row],[Amount]]))","v":{"v":965.71,"d":"$965.71"}},null,null,"Date column, on sheet compared","=Chase!B:B"]
["2020-01-06","Deposit",null,null,"X",{"v":500,"d":"$500.00"},{"$f":"IF(ISBLANK(RegisterTable[[#This Row],[Amount]]), \"\", SUM(G6,RegisterTable[[#This Row],[Amount]]))","v":{"v":1465.71,"d":"$1,465.71"}},null,null,"Check column, on this sheet ","=B:B"]
["2020-01-07","#200","def name",null,"X",{"v":-750,"d":"$(750.00)"},{"$f":"IF(ISBLANK(RegisterTable[[#This Row],[Amount]]), \"\", SUM(G7,RegisterTable[[#This Row],[Amount]]))","v":{"v":715.71,"d":"$715.71"}},null,null,"Check  column, on sheet compared","=Chase!G:G"]
[{"$nulls":9},"Transaction column, on this sheet","=B:B"]
[{"$nulls":9},"Transaction column, on sheet compared","=Chase!E:E"]
[{"$nulls":9},"days to look backwards for transaction, if empty = 0","=1"]
[{"$nulls":9},"days to look forward for transaction, if empty = 0","=4"]
[{"$nulls":9},"leve empty after and befor, if empty = false","=true"]
[{"$nulls":9},"fix date on this sheet to date  on sheet compared, if empty = false","=true"]
[{"$nulls":9},"Transaction Split on this sheet, no split if empty"]
[{"$nulls":9},"Transaction Split on serach sheet, no split if empty",{"$f":"_","v":{"$error":"#NAME?"}}]
[{"$nulls":9},"Interchangeable, transactions names discrepancies to overlook",{"$f":"quickpay\\chase\\PARTNERFI,deposit\\check\\REFUND\\RETURN\\atm\\misc,transfer\\acct","v":{"$error":"#NAME?"}}]

{"sheet":"Chase","index":1,"n_rows":17,"n_cols":10,"rows_kept":17}
["Details","Posting Date","Description","Amount","Type","Balance","Check or Slip #","Column1","bank_reconcile_settings"]
["DEBIT","2020-01-02","QUICK DEP MTH CHG SINGLE",-25,"FEE_TRANSACTION",6338.5,null,"Y","start cell to work on, should be a cell reference","=H2"]
["DEBIT","2020-01-02","QuickPay with Zelle payment to",-802.7,"QUICKPAY_DEBIT",6363.5,null,"X","Amount column, on this sheet ","=D:D"]
["DSLIP","2020-01-02","REMOTE ONLINE DEPOSIT #          1",509,"CHECK_DEPOSIT",11166.2,1,"Y","Amount column, on sheet compared","='Check Register'!F:F"]
["CHECK","2020-01-14","Comments",-18.29,"CHECK_PAID",7232.56,199,"Y","Date column, on this sheet ","=B:B"]
[{"$nulls":8},"Date column, on sheet compared","='Check Register'!A:A"]
[{"$nulls":8},"Check column, on this sheet ","=G:G"]
[{"$nulls":8},"Check  column, on sheet compared","='Check Register'!B:B"]
[{"$nulls":8},"Transaction column, on this sheet","=E:E"]
[{"$nulls":8},"Transaction column, on sheet compared","='Check Register'!B:B"]
[{"$nulls":8},"days to look backwards for transaction, if empty = 0","=4"]
[{"$nulls":8},"days to look forward for transaction, if empty = 0","=1"]
[{"$nulls":8},"leve empty after and befor, if empty = false"]
[{"$nulls":8},"fix date on this sheet to date  on sheet compared, if empty = false"]
[{"$nulls":8},"Transaction Split on this sheet, no split if empty",{"$f":"_","v":{"$error":"#NAME?"}}]
[{"$nulls":8},"Transaction Split on serach sheet, no split if empty"]
[{"$nulls":8},"Interchangeable, transactions names discrepancies to overlook",{"$f":"quickpay\\chase\\PARTNERFI,deposit\\check\\REFUND\\RETURN\\atm\\misc,transfer\\acct","v":{"$error":"#NAME?"}}]