{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Deposits","Withdrawals"],"not_rendered":{"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Deposits","index":0,"n_rows":13,"n_cols":6,"rows_kept":13,"merged":[[1,1,4,2]]}
[]
[null,"MONTHY\nBANK\nSTATEMENTS",null,"MONTH","PREVIOUS BALANCE","TOTAL DEPOSITS"]
[{"$nulls":3},{"$f":"UPPER(TEXT(TODAY(),\"mmmm\"))","v":"JANUARY"},{"v":2525.54,"d":"$2,525.54"},{"$f":"Deposit_total","v":{"v":5400,"d":"$5,400.00"}}]
[{"$nulls":3},"YEAR","ENDING BALANCE","TOTAL WITHDRAWLS"]
[{"$nulls":3},{"$f":"YEAR(TODAY())","v":2023},{"$f":"IFERROR(EndingBalance+Deposit_total-Withdrawls_total, \"\")","v":{"v":6550.54,"d":"$6,550.54"}},{"$f":"Withdrawls_total","v":{"v":1375,"d":"$1,375.00"}}]
[]
[null,"Deposits"]
[null,"Deposit No.","Date","Amount","Description","Reconciled"]
[null,{"$f":"ROW()-ROW(Deposits[[#Headers],[Deposit No.]])","v":1},{"$f":"TODAY()-15","v":"2023-01-03"},{"v":1500,"d":"$1,500.00"},"job 1 - check 1","yes"]
[null,{"$f":"ROW()-ROW(Deposits[[#Headers],[Deposit No.]])","v":2},{"$f":"TODAY()-10","v":"2023-01-08"},{"v":1200,"d":"$1,200.00"},"job 2 - check 1","yes"]
[null,{"$f":"ROW()-ROW(Deposits[[#Headers],[Deposit No.]])","v":3},{"$f":"TODAY()-5","v":"2023-01-13"},{"v":1500,"d":"$1,500.00"},"job 1 - check 2","yes"]
[null,{"$f":"ROW()-ROW(Deposits[[#Headers],[Deposit No.]])","v":4},{"$f":"TODAY()","v":"2023-01-18"},{"v":1200,"d":"$1,200.00"},"job 2 - check 2","yes"]
[null,"TOTAL",null,{"$f":"SUBTOTAL(109,Deposits[Amount])","v":{"v":5400,"d":"$5,400.00"}}]

{"sheet":"Withdrawals","index":1,"n_rows":9,"n_cols":6,"rows_kept":9}
[]
[null,"Withdrawals"]
[null,"Type","Date","Amount","For","Reconciled"]
[null,"check 1001",{"$f":"TODAY()-8","v":"2023-01-10"},{"v":150,"d":"$150.00"},"electricity","yes"]
[null,"check 1002",{"$f":"TODAY()-6","v":"2023-01-12"},{"v":150,"d":"$150.00"},"water/sewer/garbage","yes"]
[null,"check 1003",{"$f":"TODAY()-4","v":"2023-01-14"},{"v":850,"d":"$850.00"},"mortgage","yes"]
[null,"debit",{"$f":"TODAY()-2","v":"2023-01-16"},{"v":125,"d":"$125.00"},"groceries","yes"]
[null,"ATM",{"$f":"TODAY()","v":"2023-01-18"},{"v":100,"d":"$100.00"},"cash","yes"]
[null,"TOTAL",null,{"$f":"SUBTOTAL(109,Checks[Amount])","v":{"v":1375,"d":"$1,375.00"}}]