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

{"sheet":"Start","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"ABOUT THIS TEMPLATE"]
[null,"Use this template to create a Sales Invoice with simple lines design."]
[null,"Fill in basic information like Company Name, Note To, and Ship To details."]
[null,"Enter details in tables."]
[null,"Total is auto calculated for you."]
[null,"Note: "]
[null,"Additional instructions have been provided in column A in SALES INVOICE worksheet. This text has been intentionally hidden. To remove text, select column A, then select DELETE. To unhide text, select column A, then change font colour."]
[null,"To learn more about tables, press SHIFT and then F10 within a table, select the TABLE option, and then select ALTERNATIVE TEXT."]

{"sheet":"Sales Invoice","index":1,"n_rows":44,"n_cols":8,"rows_kept":44,"merged":[[1,1,1,2],[1,3,1,7],[5,2,5,3],[6,2,6,3],[13,1,13,7],[40,1,40,4],[40,5,40,7],[42,1,42,7],[43,1,43,7]]}
[]
[{"$nulls":3},"Invoice"]
[null,"Your Company Name",{"$nulls":4},"Date:",{"$f":"TODAY()","v":"2022-05-09"}]
[null," Your Company Slogan Here",{"$nulls":4},"Invoice #:","No."]
[{"$nulls":6},"Customer ID:","ID"]
[null,"To:","Name",null,"Ship to:","Name"]
[null,null,"Company Name",null,null,"Company Name"]
[null,null,"Street Address",null,null,"Street Address"]
[null,null,"City, postcode",null,null,"City, postcode"]
[null,null,"Phone",null,null,"Phone"]
[]
[null,"Salesperson","Job","Shipping Method","Shipping Terms","Delivery Date","Payment Terms","Due Date"]
[]
[]
[null,"Qty","Item #","Description","Column1","Unit Price","Discount","Line Total"]
[{"$nulls":7},{"$f":"IF(SUM(B16)>0,SUM((B16*F16)-G16),\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(SUM(B17)>0,SUM((B17*F17)-G17),\"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},{"$f":"IF(SUM(B22)>0,SUM((B22*F22)-G22),\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(SUM(B23)>0,SUM((B23*F23)-G23),\"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":5},"Total Discount",{"$f":"IF(SUM(G16:G35)>0,SUM(G16:G35),\"\")","v":""}]
[{"$nulls":6},"Subtotal",{"$f":"IF(SUM(H16:H35)>0,SUM(H16:H35),\"\")","v":""}]
[{"$nulls":6},"Sales Tax"]
[{"$nulls":6},"Total",{"$f":"IF(SUM(H37)>0,SUM((H37*H38)+H37),\"\")","v":""}]
[]
[null,"Make all checks payable to ",{"$nulls":3},{"$f":"B3","v":"Your Company Name"}]
[]
[null,"Thank you for your business!"]
[null,"Street Address, City, Postcode,  Phone,  Fax,  Email"]