{"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 simple Sales Invoice."]
[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,3],[1,4,1,7],[2,5,2,6],[3,1,4,4],[3,5,3,6],[4,5,4,6],[5,2,5,3],[5,5,5,6],[6,2,6,3],[6,5,6,6],[7,2,7,3],[7,5,7,6],[8,2,8,3],[8,5,8,6],[9,2,9,3],[9,5,9,6],[13,1,13,7],[41,1,41,3],[41,4,41,7],[42,1,42,7],[43,1,43,7]]}
[]
[{"$nulls":4},"Invoice"]
[null,"Your Company Name",{"$nulls":3},"Date:",null,{"$f":"TODAY()","v":"2022-05-09"}]
[null," Your Company Slogan Here",{"$nulls":3},"Invoice #:",null,"No."]
[{"$nulls":5},"Customer ID:",null,"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","Customised Column","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},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},{"$f":"IF(SUM(B34)>0,SUM((B34*F34)-G34),\"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":5},"Total Discount",{"$f":"IF(SUM(G16:G36)>0,SUM(G16:G36),\"\")","v":""}]
[{"$nulls":6},"Subtotal",{"$f":"IF(SUM(H16:H36)>0,SUM(H16:H36),\"\")","v":""}]
[{"$nulls":6},"Sales Tax"]
[{"$nulls":6},"Total",{"$f":"IF(SUM(H38)>0,SUM((H38*H39)+H38),\"\")","v":""}]
[]
[null,"Make all checks payable to",null,null,{"$f":"B3","v":"Your Company Name"}]
[null,"Thank you for your business!"]
[null,"Street Address, City, Postcode,  Phone,  Fax,  Email"]