{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Billing Statement"],"read":"whole","date_system":"1900"}

{"sheet":"Billing Statement","index":0,"n_rows":36,"n_cols":7,"rows_kept":36,"merged":[[0,0,0,6],[1,0,1,6],[2,1,2,3],[2,5,2,6],[3,1,3,3],[3,5,3,6],[4,1,4,3],[4,5,4,6],[5,0,5,3],[5,4,5,6],[6,0,6,3],[6,4,6,5],[7,0,7,3],[7,4,7,5],[8,0,8,1],[8,2,8,3],[8,4,8,6],[9,0,9,1],[9,2,9,3],[9,4,9,6],[10,0,10,1],[10,2,10,3],[10,4,10,6],[11,0,11,6],[12,0,12,1],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[32,0,32,2],[32,4,32,6],[33,0,33,2],[33,4,33,6],[34,0,34,6],[35,0,35,6],[36,0,36,6]]}
["Company Name"]
["Billing Statement"]
["Bill To:","Customer Name",null,null,"Statement Date:",{"$f":"TODAY()","v":"2016-12-19"}]
[null,"Address",null,null,"Statement #:",1]
[{"$nulls":4},"Customer Code:","AB12"]
["Remittance Details",{"$nulls":3},"Account Summary"]
["To ensure proper credit, please ensclose a copy of this statement",{"$nulls":3},"Balance Due",null,{"$f":"G32","v":{"v":4750,"d":"₹ 4,750.00"}}]
["with your check and remit to:",{"$nulls":3},"Payment Due Date",null,{"$f":"F3+10","v":"2016-12-29"}]
["Bank Account Number:",{"$nulls":3},"All checks payable to"]
["Bank IFSC Code:",{"$nulls":3},{"$f":"+A1","v":"Company Name"}]
["Bank Branch:"]
["Note: Please write your Customer ID behind on your check."]
["Account Activity"]
["DATE","INVOICE #","DESCRIPTION",null,"PAYMENT","INVOICE AMOUNT","BALANCE"]
[null,null,"Balance Forward",{"$nulls":3},{"v":250,"d":"₹ 250"}]
["2016-11-07","ABC123","Dispatch Voucher number - 123456",null,{"v":2000,"d":"₹ 2,000"},{"v":5000,"d":"₹ 5,000"},{"$f":"IF(AND(ISBLANK(E16), ISBLANK(F16)),\"\",OFFSET(G16,-1,0,1,1)+F16-E16)","v":{"v":3250,"d":"₹ 3,250"}}]
["15-11-16","ABC123","Dispatch Voucher number - 123456",null,{"v":1500,"d":"₹ 1,500.00"},0,{"$f":"IF(AND(ISBLANK(E17), ISBLANK(F17)),\"\",OFFSET(G17,-1,0,1,1)+F17-E17)","v":{"v":1750,"d":"₹ 1,750"}}]
["22-11-16","ABC234","Dispatch Voucher number - 234560",null,{"v":5000,"d":"₹ 5,000.00"},{"v":15000,"d":"₹ 15,000.00"},{"v":11750,"d":"₹ 11,750.00"}]
["27-11-16","ABC234","Dispatch Voucher number - 234560",null,{"v":7000,"d":"₹ 7,000.00"},0,{"v":4750,"d":"₹ 4,750.00"}]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":3},"Payable Balance as of this date:",{"$f":"TODAY()","v":"2016-12-19"},"is Amount",{"$f":"G15+SUM(F15:F31)-SUM(E15:E31)","v":{"v":4750,"d":"₹ 4,750.00"}}]
[]
["Authorized Signatory",{"$nulls":3},"Customer's Signature"]
["If you have any questions about this invoice, please contact"]
["Name, Street Address, Phone 1234567890, Fax 1234567890, Email"]