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

{"sheet":"How to use this template","index":0,"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 upper portion, type your company name, address, and phone information in cells B2 through 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 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 the 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."]

{"sheet":"Service Invoice","index":1,"n_rows":31,"n_cols":5,"rows_kept":31,"merged":[[0,3,0,4],[26,1,26,2],[29,1,29,4],[30,1,30,4]]}
[null,null,"Your Company Slogan","INVOICE"]
[null,"Your Company Name"]
[null,"Street Address",null,"Invoice No :",100]
[null,"Town/city, county/region, postcode:",null,"Date :",{"$f":"TODAY()","v":"2022-06-16"}]
[null,"[Phone] [Fax]",null,"Customer ID :","ABC12345"]
[null,"Email address"]
[null,"Name"]
[null,"Company Name"]
[null,"Street Address"]
[null,"Town/city, county/region, postcode:"]
[null,"Phone"]
[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,"Sales Tax @",null,{"v":0.095,"d":"9.50%"},{"$f":"IFERROR(IF(SUM(Invoice[[#Totals],[Line Total]])>0,SUM(Invoice[[#Totals],[Line Total]]*D27),\"\"), \"\")","v":""}]
[{"$nulls":3},"TOTAL",{"$f":"IFERROR(IF(SUM(Invoice[[#Totals],[Line Total]])>0,SUM(Invoice[[#Totals],[Line Total]],E27),\"\"), \"\")","v":""}]
[]
[null,{"$f":"\"Make all checks payable to \"&Company_Name&\".\"","v":"Make all checks payable to Your Company Name."}]
[null,"THANK YOU FOR YOUR BUSINESS!"]