{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Start","Service invoice"],"not_rendered":{"images":1,"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."]
[null,"Fill in basic information such as Company name, Bill to and Dispatch to details."]
[null,"Enter invoice details in tables."]
[null,"Total is auto-calculated for you."]
[null,"Note: "]
[null,"Additional instructions have been provided in column A in SERVICE 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":"Service invoice","index":1,"n_rows":39,"n_cols":8,"rows_kept":39,"merged":[[0,1,0,3],[0,4,0,7],[1,1,1,6],[2,1,2,3],[3,1,3,3],[4,1,4,2],[4,5,4,6],[5,1,5,2],[5,5,5,6],[6,1,6,2],[6,3,6,4],[6,5,6,6],[7,1,7,2],[7,3,7,4],[8,2,8,3],[8,5,8,6],[9,2,9,3],[9,5,9,6],[10,2,10,3],[10,5,10,6],[11,2,11,3],[11,5,11,6],[12,2,12,3],[12,5,12,6],[37,1,37,4],[37,5,37,7],[38,1,38,7]]}
["Create a Sales invoice in this worksheet. Enter Company logo in cell to the right and title of this worksheet in cell E1. Helpful instructions on how to use this worksheet are in the cells in this column. Next instruction is in cell A3.","Logo placeholder is in this cell.",null,null,"INVOICE"]
[]
["Enter Company name in cell to the right.","Your Company Name"]
["Enter Company slogan in cell to the right.","Your company slogan"]
["Enter Street address in cell to the right and Invoice number in cell F5.","Street address",null,null,"INVOICE NO.","No"]
["Enter City, County/Region and Postcode in cell to the right, and invoicing Date in cell F6.","City, County/Region, Postcode",null,null,"DATE",{"$f":"TODAY()","v":"2019-05-05"}]
["Enter Phone and Fax numbers in cell to the right, and Customer ID in cell F7.","Phone fax",null,"CUSTOMER ID",null,"ID"]
["Enter Email address in cell to the right.","Email"]
["Enter Bill to details in cells C9 to C13, and Dispatch to details in cells F9 to F13. Next instruction is in cell A14.","TO","Name",null,"DELIVER TO","Name"]
[null,null,"Company name",null,null,"Company name"]
[null,null,"Street address",null,null,"Street address"]
[null,null,"City, County/Region, Postcode",null,null,"City, County/Region, Postcode"]
[null,null,"Phone",null,null,"Phone number"]
["Enter information in Details table starting in cell to the right. Next instruction is in cell A17.","SALESPERSON","JOB","DELIVERY METHOD","DELIVERY TERMS","DELIVERY DATE","PAYMENT TERMS","DUE DATE"]
[{"$nulls":6},"Due upon receipt"]
[]
["Enter information in Invoice table starting in cell to the right. Subtotal and Total are auto-calculated at the end. Next instruction is in cell A38.","QTY","ITEM No.","DESCRIPTION","Custom column","UNIT PRICE","DISCOUNT","LINE TOTAL"]
[{"$nulls":7},{"$f":"IF(SUM(B18)>0,SUM(B18*F18-G18),\"\")","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":5},"TOTAL DISCOUNT",{"$f":"IF(SUM(G18:G32)>0,SUM(G18:G32),\"\")","v":""}]
[{"$nulls":6},"SUBTOTAL",{"$f":"IF(SUM(H18:H32)>0,SUM(H18:H32),\"\")","v":""}]
[{"$nulls":6},"VAT"]
[{"$nulls":6},"TOTAL",{"$f":"IF(SUM(H34)>0,SUM((H34*H35)+H34),\"\")","v":""}]
[]
["Company name is auto-updated in cell F38.","Make all cheques payable to",{"$nulls":3},{"$f":"B3","v":"Your Company Name"}]
["Thank-you message is in cell to the right.","THANK YOU FOR YOUR BUSINESS."]