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

{"sheet":"Start","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"ABOUT THIS TEMPLATE"]
[null,"Use this template to create a simple Sales Receipt."]
[null,"Fill in Company Name, Payment Method, Check number, and Sold To details."]
[null,"Enter details in table and Total is auto calculated for you."]
[null,"Note: "]
[null,"Additional instructions have been provided in column A in SALES RECEIPT worksheet. This text has been intentionally hidden. To remove text, select column A, then select DELETE."]
[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 Receipt","index":1,"n_rows":44,"n_cols":7,"rows_kept":44,"merged":[[1,1,1,2],[1,3,1,6],[4,2,4,3],[5,2,5,3],[5,4,5,5],[6,2,6,3],[6,4,6,5],[7,2,7,3],[7,4,7,5],[8,2,8,3],[8,4,8,5],[10,1,10,2],[10,4,10,6],[11,1,11,2],[11,4,11,6],[42,1,42,6],[43,1,43,6],[46,2,46,4]]}
[]
[null,"Logo placeholder is in this cell.",null,"Sales Receipt"]
[null,"Your Company Name",{"$nulls":3},"Date:",{"$f":"TODAY()","v":"2022-05-25"}]
[null," Your Company Slogan Here",{"$nulls":3},"Invoice #:","No"]
[null,"Sold to:","Name"]
[null,null,"Company Name"]
[null,null,"Street Address"]
[null,null,"City, postcode"]
[null,null,"Phone"]
[]
[null,"Payment Method",null,"Check No.","Job"]
[]
[]
[null,"Qty","Item #","Description","Unit Price","Discount","Line Total"]
[{"$nulls":6},{"$f":"IF(SUM(B15)>0,SUM((B15*E15)-F15),\"\")","v":""}]
[{"$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":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":4},"Total Discount",{"$f":"IF(SUM(F16:F37)>0,SUM(F16:F37),\"\")","v":""}]
[{"$nulls":5},"Subtotal",{"$f":"IF(SUM(G16:G37)>0,SUM(G16:G37),\"\")","v":""}]
[{"$nulls":5},"Sales Tax"]
[null," ",{"$nulls":3},"Total",{"$f":"IF(SUM(G39)>0,SUM((G39*G40)+G39),\"\")","v":""}]
[]
[null,"Thank you for your business!"]
[null,"Street Address, City, Postcode  Phone  Fax  Email"]