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

{"sheet":"Bank Book","index":0,"n_rows":11,"n_cols":8,"rows_kept":11,"merged":[[0,0,0,6],[1,0,1,6],[2,1,2,6],[10,0,10,2],[10,4,10,6]]}
["Company Name",{"$nulls":6},"Bank Balance"]
["Bank Book",{"$nulls":6},{"$f":"D11-H11","v":{"v":199000,"d":"Rs. 199,000"}}]
["Dr.","Bank Name/Bank Account Number",{"$nulls":5},"Cr"]
["Date","Particulars","Bank Details","Amount","Date","Particulars","Bank Details","Amount"]
["2016-03-01","Balance B/F",null,{"v":140000,"d":"₹ 140,000"},"2016-03-05","Name of Vendor or Supplier","Chq #",{"v":5000,"d":"₹ 5,000"}]
["2016-03-15","Name of Customer","Chq #",{"v":21000,"d":"₹ 21,000"},"2016-03-08","Cash Withdrawl","-",{"v":10000,"d":"₹ 10,000"}]
["2016-03-19","Cash Deposit","-",{"v":23000,"d":"₹ 23,000"},"2016-03-12","Name of Vendor or Supplier","NTFS",{"v":35000,"d":"₹ 35,000"}]
["2016-03-22","Name of Customer","NTFS",{"v":25000,"d":"₹ 25,000"},"2016-03-15","Name of Vendor or Supplier","RTGS",{"v":15000,"d":"₹ 15,000"}]
["2016-03-25","Name of Customer","RTGS",{"v":55000,"d":"₹ 55,000"},null,"Loan Repayment"]
[]
["Total",null,null,{"$f":"SUM(D5:D10)","v":{"v":264000,"d":"Rs. 264,000"}},"Total",null,null,{"$f":"SUM(H5:H10)","v":{"v":65000,"d":"Rs. 65,000"}}]

{"sheet":"Bank Recon","index":1,"n_rows":20,"n_cols":12,"rows_kept":20,"merged":[[0,0,0,11],[1,0,1,11],[2,0,2,3],[2,4,2,5],[3,3,3,5],[3,7,3,8],[3,10,3,11],[19,3,19,4],[19,8,19,11]]}
["BANK RECONCILIATION STATEMENT"]
["COMPANY NAME"]
["MONTH ENDING",{"$nulls":3},"DD/MM/YYYY"]
["Statement Date","2016-12-24",null,"Outstanding Cheques",{"$nulls":3},"Outstanding Deposits",null,null,"Other Adjustments"]
["Closing Balance Bank Statement",{"v":225000,"d":"₹ 225,000.00"},null,"Date","Cheque #","Amount",null,"Date","Amount",null,"Date","Amount"]
[]
["Less: Outstanding Cheques",{"$f":"-(ABS(F16))","v":{"v":-31000,"d":"₹ -31,000.00"}},null,"ABC",12345,{"v":5000,"d":"₹ 5,000.00"},null,"ABC",{"v":5000,"d":"₹ 5,000.00"},null,null,0]
["Add: Outstanding Deposits",{"$f":"+(ABS(I16))","v":{"v":5000,"d":"₹ 5,000.00"}},{"$nulls":3},{"v":2500,"d":"₹ 2,500.00"}]
["Other Adjustments",{"$f":"L16","v":0},{"$nulls":3},{"v":10000,"d":"₹ 10,000.00"}]
[{"$nulls":5},{"v":13500,"d":"₹ 13,500.00"}]
["Adjusted Balance",{"$f":"SUM(B5:B10)","v":{"v":199000,"d":"₹ 199,000.00"}}]
[]
[]
["Closing Balance Bank Book ",{"v":199000,"d":"₹ 199,000.00"}]
[]
["Variance",{"$f":"B11-B14","v":0},{"$nulls":3},{"$f":"SUM(F7:F15)","v":{"v":31000,"d":"₹ 31,000.00"}},null,null,{"$f":"SUM(I7:I15)","v":{"v":5000,"d":"₹ 5,000.00"}},null,null,{"$f":"SUM(L7:L15)","v":0}]
[{"$nulls":5},0,null,null,0,null,null,0]
["Remarks",{"$f":"IF(B16=0,\"BALANCED\",\"OUT OF BALANCE\")","v":"BALANCED"}]
[]
[{"$nulls":3},"Prepared By",{"$nulls":4},"Approved By"]