{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Invoice","FAQs"],"not_rendered":{"defined_names":54,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Invoice","index":0,"n_rows":53,"n_cols":11,"rows_kept":53,"merged":[[3,5,3,6],[4,5,4,6],[5,5,5,6],[35,1,35,6],[45,1,46,6],[49,1,50,6],[53,1,53,6]]}
[{"$nulls":6},"INVOICE"]
[]
[]
[null,"Your contact info",null,null,"Invoice number","(Leave blank to auto-number)",null,"Invoice ID:"]
[null,"Business name",null,null,"Invoice date *",{"$f":"TODAY()","v":{"v":41593,"d":"4159300.00%"}},null,"Locale:","en_US"]
[null,"Business email",null,null,"Due date",null,null,"Version:",1]
[{"$nulls":7},"Invoice URL:"]
[null,"First name"]
[null,"Last name"]
[null,"Address"]
[]
[null,"City"]
[null,"State"]
[null,"ZIP code"]
[null,"Phone number"]
[null,"Fax number"]
[null,"Website"]
[null,"Additional info"]
[null,"Send to"]
[null,"Recipient's email *"]
[]
[null,"Bill to",null,null,"Ship to"]
[null,"Business name",null,null,"Business name"]
[null,"First name",null,null,"First name"]
[null,"Last name",null,null,"Last name"]
[null,"Address",null,null,"Address"]
[]
[null,"City",null,null,"City"]
[null,"State",null,null,"State"]
[null,"ZIP code",null,null,"ZIP code"]
[null,"Additional info"]
[]
[" ","Item name *","Item description","Quantity *","Unit price *","Amount","Taxable","Discount","Pretax Amt","Tax","Line Sub"]
[null,"Item 1","Description 1",0,{"v":0,"d":"$0.00"},{"$f":"IF(AND(LEN(ItemTable[[#This Row],[Item name *]])>0,ItemTable[[#This Row],[Quantity *]]<>\"\",ItemTable[[#This Row],[Unit price *]]<>\"\"),ItemTable[[#This Row],[Quantity *]]*ItemTable[[#This Row],[Unit price *]],\"\")","v":{"v":0,"d":"$0.00"}},"Yes",{"$f":"IF(AND(ItemTable[[#This Row],[Amount]]>0,ItemTable[[#This Row],[Amount]]<>\"\"),IF(DiscountType=\"percent\",ItemTable[[#This Row],[Amount]]*DiscountRange,ItemTable[[#This Row],[Amount]]*(DiscountRange/SubtotalRange)),0)","v":{"v":0,"d":"$0.00"}},{"$f":"IF(ItemTable[[#This Row],[Amount]]<>\"\",ItemTable[[#This Row],[Amount]]-ItemTable[[#This Row],[Discount]],\"\")","v":{"v":0,"d":"$0.00"}},{"$f":"IF(AND(TaxRange>0,ItemTable[[#This Row],[Taxable]] = \"Yes\"), ROUND(PRODUCT(ItemTable[[#This Row],[Pretax Amt]], TaxRange), 2), 0)","v":{"v":0,"d":"$0.00"}},{"$f":"IF(AND(ItemTable[[#This Row],[Amount]]>0,ItemTable[[#This Row],[Amount]]<>\"\"),ItemTable[[#This Row],[Pretax Amt]]+ItemTable[[#This Row],[Tax]],\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(AND(LEN(ItemTable[[#This Row],[Item name *]])>0,ItemTable[[#This Row],[Quantity *]]<>\"\",ItemTable[[#This Row],[Unit price *]]<>\"\"),ItemTable[[#This Row],[Quantity *]]*ItemTable[[#This Row],[Unit price *]],\"\")","v":""},null,{"$f":"IF(AND(ItemTable[[#This Row],[Amount]]>0,ItemTable[[#This Row],[Amount]]<>\"\"),IF(DiscountType=\"percent\",ItemTable[[#This Row],[Amount]]*DiscountRange,ItemTable[[#This Row],[Amount]]*(DiscountRange/SubtotalRange)),0)","v":{"v":0,"d":"$0.00"}},{"$f":"IF(ItemTable[[#This Row],[Amount]]<>\"\",ItemTable[[#This Row],[Amount]]-ItemTable[[#This Row],[Discount]],\"\")","v":""},{"$f":"IF(AND(TaxRange>0,ItemTable[[#This Row],[Taxable]] = \"Yes\"), ROUND(PRODUCT(ItemTable[[#This Row],[Pretax Amt]], TaxRange), 2), 0)","v":{"v":0,"d":"$0.00"}},{"$f":"IF(AND(ItemTable[[#This Row],[Amount]]>0,ItemTable[[#This Row],[Amount]]<>\"\"),ItemTable[[#This Row],[Pretax Amt]]+ItemTable[[#This Row],[Tax]],\"\")","v":""}]
[]
[{"$nulls":3},"Subtotal",null,{"$f":"SUM(ItemTable[Amount])","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Discount type","Amount"]
[{"$nulls":3},"Discount",{"v":0,"d":"($0.00)"},{"$f":"-1*SUM(ItemTable[Discount])","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Shipping",{"v":0,"d":"$0.00"},{"$f":"IF(ShippingRange<>\"\",ShippingRange,0)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Shipping taxable?","Yes"]
[{"$nulls":3},"Sales tax rate",{"v":0,"d":"0.00%"},{"$f":"IF(TaxTotal<>\"\",TaxTotal,0)+IF(TaxableShipping=\"yes\",ShippingTax,0)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Total",null,{"$f":"IFERROR(SubtotalRange+DiscountTotal+ShippingAmount+SalesTaxRange,0)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Terms & conditions",{"$nulls":4},{"$f":"\"Characters remaining: \"& 4000-LEN(TermsAndConditions)","v":"Characters remaining: 4000"}]
[]
[]
[]
[null,"Note to recipient",{"$nulls":4},{"$f":"\"Characters remaining: \"& 4000-LEN(NoteToRecipient)","v":"Characters remaining: 4000"}]
[]
[]
[]
[null,"Memo (Your recipient won't see this)",{"$nulls":4},{"$f":"\"Characters remaining: \"& 150-LEN(Memo)","v":"Characters remaining: 150"}]

{"sheet":"FAQs","index":1,"n_rows":32,"n_cols":2,"rows_kept":32}
[null,"Frequently Asked Questions"]
[null,"How do I add a logo to my invoice?"]
[]
[null,"To add a logo to your invoice, go to the invoice logo page in your PayPal account and add a logo. This image will be used in the invoice that is sent to your customers from Excel."]
[null,"Click this link to go to the invoice logo page in your PayPal account."]
[null,"Note: Your logo will not be displayed in the Excel template, but will be displayed to your customer in the invoice that you send."]
[]
[null,"How do I add or edit my business information?"]
[]
[null,"Click the [+] sign to the left of the business information to expand the section and enter more details."]
[]
[null,"How do I add or edit my customer's billing or shipping information?"]
[]
[null,"Click the [+] sign to the left of your recipient's email address to display the billing and shipping section."]
[]
[null,"The web application panel disappeared.  How do I get it back?"]
[]
[null,"On the Insert tab, in the Apps group, click Apps for Office. Search for PayPal Invoicing. Then insert it."]
[]
[null,"What if I don’t have Excel 2013?"]
[]
[null,"If you don’t have Excel 2013, you can try an Office 365 plan that includes a desktop version of Excel 2013 free for one month."]
[null,"Click this link to try 1 month for free."]
[]
[null,"Or you can download PayPal’s Excel Invoicing Application for Excel 2007 & 2010."]
[null,"Click this link to get the invoicing add-in."]
[]
[null,"What should I do if I still have questions? "]
[]
[null,"Additional answers can be found in the web panel under More in the FAQ section."]
[null,"If you have unanswered questions or ideas for improvements to the invoicing tool, feel free to send feedback to: "]
[null,"excelinvoicing2013@paypal.com "]