{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Service Invoice","How to use this template"],"not_rendered":{"images":5,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Service Invoice","index":0,"n_rows":30,"n_cols":5,"rows_kept":30,"merged":[[0,3,0,4],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[26,1,26,2],[27,1,27,3],[28,1,28,4],[29,1,29,4]]}
[null,null,"Your company slogan","INVOICE"]
[null,"Your Company Name"]
[null,"Street Address",null,"Invoice No.:",100]
[null,"City, County/Region, Postcode",null,"Date:",{"$f":"TODAY()","v":"2018-08-23"}]
[null,"[Phone number] [Fax number]",null,"Customer ID:","ABC12345"]
[null,"Email Address"]
[null,"Name"]
[null,"Company Name"]
[null,"Street Address"]
[null,"City, County/Region, Postcode"]
[null,"Phone Number"]
[null,"Salesperson","Job","Payment Terms","Due date"]
[{"$nulls":3},"Due upon receipt"]
[]
[null,"Quantity","Description","Unit Price","Line Total"]
[{"$nulls":4},{"$f":"IFERROR(IF(SUM(B16)>0,SUM(B16*D16),\"\"), \"\")","v":""}]
[{"$nulls":4},""]
[{"$nulls":4},""]
[null,null," ",null,""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":3},"Subtotal",{"$f":"IFERROR(IF(SUM(E16:E25)>0,SUM(E16:E25),\"\"), \"\")","v":""}]
[null,"VAT @",null,{"v":0.095,"d":"9.50%"},{"$f":"IFERROR(IF(SUM(Invoice[[#Totals],[Line Total]])>0,SUM(Invoice[[#Totals],[Line Total]]*D27),\"\"), \"\")","v":""}]
[null,"TOTAL",null,null,{"$f":"IFERROR(IF(SUM(Invoice[[#Totals],[Line Total]])>0,SUM(Invoice[[#Totals],[Line Total]],E27),\"\"), \"\")","v":""}]
[null,{"$f":"\"Make all cheques payable to \"&Company_Name&\".\"","v":"Make all cheques payable to Your Company Name."}]
[null,"THANK YOU FOR YOUR BUSINESS!"]

{"sheet":"How to use this template","index":1,"n_rows":4,"n_cols":2,"rows_kept":4}
[null,"Get started using the service invoice"]
[null,"\nUse this template to create professional looking invoices that are a snap to fill in and are easy for your customers to read."]
[null,"To get started, in the top portion, type your company name, address and phone information in cells B2 to B6 on the Service Invoice tab, and then save the template as an Excel template (.xltx) so that it always has this information prepopulated in those cells. Make sure that the template is saved somewhere where it’s easy for you to access. If you can save it in your computer’s templates folder (usually C:\\Users\\<username>\\AppData\\Roaming\\Microsoft\\Templates), it will be easily available by selecting the New tab, selecting New and then selecting My Templates. Otherwise, you can select New from Existing and then browse to and open your .xltx file. Either way, the first time you save your file, you’ll be prompted to save it as an .xlsx workbook."]
[null,"Enter your invoice number and customer ID. The date is automatically filled in for you. Then enter your customer information: contact name, company name, address and phone information. Set the tax rate in cell D27. Your company Name is automatically appended in cell B29. Finally, enter all the order transaction information in Invoice table starting at cell B15."]