{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Invoice","VAT settings"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Invoice","index":0,"n_rows":56,"n_cols":9,"rows_kept":56,"merged":[[2,6,2,7],[3,6,3,7],[5,12,5,13],[8,7,8,8],[8,12,8,13],[9,7,9,8],[9,12,9,13],[10,7,10,8],[12,7,12,8],[13,7,13,8]]}
[]
[]
["My Company Name",{"$nulls":4},"INVOICE"]
[{"$f":"A53 & \", \" & A54","v":"11113 Research Boulevard, Austin"}]
[{"$f":"A55","v":"TX 78759"}]
[]
[]
["To:"]
["Buyer Ltd.",{"$nulls":5},"Invoice Date:",{"$f":"TODAY()","v":"2015-05-15"}]
["Billy Buyer",{"$nulls":5},"Invoice Number:",123]
["43 Customer Road",{"$nulls":5},"Client Number:","A00342"]
["CA 91362",{"$nulls":5},"Payment Terms:",30,"days"]
["USA",{"$nulls":5},"Due Date:",{"$f":"H9+H12","v":"2015-06-14"}]
[{"$nulls":6},"Late payment interest:",{"v":0.085,"d":"8.5%"}]
[]
[]
[]
["Additional information"]
["Add any additional instructions or terms here."]
[]
[]
[]
["Description",null,null,"Qty","Unit","Unit Price","VAT %","VAT","Total"]
["Client work",null,null,5,"h",{"v":60,"d":"$60.00"},{"v":0.2,"d":"20%"},{"$f":"IF(ISBLANK(G24),\"\",IF(F24*G24*D24>0,F24*G24*D24,0))","v":{"v":60,"d":"$60.00"}},{"$f":"IF(SUM(D24*F24,H24)>0,SUM(D24*F24,H24),\"\")","v":{"v":360,"d":"$360.00"}}]
["Products",null,null,10,"pcs",{"v":103.99,"d":"$103.99"},{"v":0.2,"d":"20%"},{"v":207.98000000000002,"d":"$207.98"},{"v":1247.8799999999999,"d":"$1,247.88"}]
[{"$nulls":7},"",""]
[{"$nulls":7},"",""]
[{"$nulls":7},"",""]
[{"$nulls":7},"",""]
[{"$nulls":7},"",""]
[{"$nulls":7},"",""]
[{"$nulls":7},"",""]
[]
[{"$nulls":7},{"$f":"IF(ISBLANK(G34),\"\",IF(F34*G34*D34>0,F34*G34*D34,0))","v":""},{"$f":"IF(SUM(D34*F34,H34)>0,SUM(D34*F34,H34),\"\")","v":""}]
[{"$nulls":7},"",""]
[{"$nulls":7},"",""]
[{"$nulls":7},"",""]
[{"$nulls":7},"",""]
[{"$nulls":7},"",""]
[{"$nulls":7},"",""]
[{"$nulls":7},"",""]
[]
[{"$nulls":7},"Sub Total",{"$f":"SUM(I24:I41)-SUM(H24:H41)","v":{"v":1339.8999999999999,"d":"$1,339.90"}}]
[{"$nulls":7},"Total VAT",{"$f":"SUM(H24:H41)","v":{"v":267.98,"d":"$267.98"}}]
[]
[{"$nulls":6},"Total amount due",null,{"$f":"SUM(I24:I41)","v":{"v":1607.8799999999999,"d":"$1,607.88"}}]
[]
[]
[]
[{"$nulls":7},"Please pay within the agreed term"]
[]
[{"$f":"A3","v":"My Company Name"},null,null,"Contact Information",{"$nulls":3},"Payment Details"]
["11113 Research Boulevard",null,null,"Toby Warren",{"$nulls":3},"Bank Name","Barclays PLC"]
["Austin",null,null,"Phone (512) 324-6000",{"$nulls":3},"Routing No.",123456789]
["TX 78759",null,null,"Email: Warren@mycompany.com",{"$nulls":3},"Account No.",12345678]
["VAT No.",null,null,"www.mycompany.com"]

{"sheet":"VAT settings","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"merged":[[0,1,0,4]]}
[]
[]
[null,"VAT-%"]
[null,{"v":0,"d":"0%"}," <= You can change the VAT for the invoice template here"]
[null,{"v":0.05,"d":"5%"}]
[null,{"v":0.2,"d":"20%"}]