{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Bank Reconciliation"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Bank Reconciliation","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[1,1,4,2],[13,1,13,4]]}
[]
[null,"monthly\nbank\nstatement",null,"MONTH","PREVIOUS BALANCE","TOTAL DEPOSITS"]
[{"$nulls":3},"JUNE",{"v":2525.54,"d":"$2,525.54"},{"$f":"tblDeposits[[#Totals],[amount]]","v":{"v":5400,"d":"$5,400.00"}}]
[{"$nulls":3},"YEAR","ENDING BALANCE","TOTAL WITHDRAWLS"]
[{"$nulls":3},2013,{"$f":"EndingBalance+tblDeposits[[#Totals],[amount]]-tblChecks[[#Totals],[amount]]","v":{"v":6550.54,"d":"$6,550.54"}},{"$f":"tblChecks[[#Totals],[amount]]","v":{"v":1375,"d":"$1,375.00"}}," "]
[]
[null,"deposits",{"$nulls":4}," "]
[null,"deposit no.","date","amount","description","reconciled"]
[null,{"$f":"ROW()-ROW(tblDeposits[[#Headers],[deposit no.]])","v":1},"2013-06-02",{"v":1500,"d":"$1,500.00"},"job 1, check 1","yes"]
[null,{"$f":"ROW()-ROW(tblDeposits[[#Headers],[deposit no.]])","v":2},"2013-06-15",{"v":1200,"d":"$1,200.00"},"job 2, check 1","yes"]
[null,{"$f":"ROW()-ROW(tblDeposits[[#Headers],[deposit no.]])","v":3},"2013-06-16",{"v":1500,"d":"$1,500.00"},"job 1, check 2","yes"]
[null,{"$f":"ROW()-ROW(tblDeposits[[#Headers],[deposit no.]])","v":4},"2013-06-30",{"v":1200,"d":"$1,200.00"},"job 2, check 2","yes"]
[null,"TOTAL",null,{"$f":"SUBTOTAL(109,tblDeposits[amount])","v":{"v":5400,"d":"$5,400.00"}}]
[]
[null,"withdrawals"]
[null,"type","date","amount","for","reconciled"]
[null,"check 1001","2013-06-01",{"v":150,"d":"$150.00"},"electricity","yes"]
[null,"check 1002","2013-06-02",{"v":150,"d":"$150.00"},"water/sewer/garbage","yes"]
[null,"check 1003","2013-06-04",{"v":850,"d":"$850.00"},"mortgage","yes"]
[null,"debit","2013-06-08",{"v":125,"d":"$125.00"},"groceries","yes"]
[null,"ATM","2013-06-09",{"v":100,"d":"$100.00"},"cash","yes"]
[null,"TOTAL",null,{"$f":"SUBTOTAL(109,tblChecks[amount])","v":{"v":1375,"d":"$1,375.00"}}]