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

{"sheet":"Invoice","index":0,"n_rows":56,"n_cols":11,"rows_kept":56,"merged":[[0,1,0,4],[2,0,2,11],[3,0,3,5],[4,5,4,7],[5,5,5,6],[6,5,6,6],[7,5,7,6],[27,5,27,6],[38,1,38,6],[48,1,49,6],[52,1,53,6],[56,1,56,6]]}
[{"$nulls":6},"INVOICE"]
[]
[]
[]
[null,"Your contact info",null,null,"Invoice number","(Leave blank to auto-number)"]
[null,"Business name",null,null,"Invoice date *",{"$f":"TODAY()","v":{"v":41669,"d":"4166900.00%"}},null,"Locale:","en_US",{"$f":"VLOOKUP(MerchantCountryCodeLong, Data!B6:C9, 2, FALSE)","v":"US"}]
[null,"Business email",null,null,"Due date",null,null,"Version:",2,{"$f":"VLOOKUP(BillCountryCodeLong, Data!B6:C9, 2, FALSE)","v":"US"}]
[{"$nulls":4},"Currency","USD",null,"Invoice URL:",null,{"$f":"VLOOKUP(ShipCountryCodeLong, Data!B6:C9, 2, FALSE)","v":"US"}]
[null,"First name"]
[null,"Last name"]
[null,"Country *","United States"]
[null,"Address"]
[]
[null,"City"]
[null,{"$f":"IFERROR(VLOOKUP(MerchantCountryCodeLong, CountryLookup[],3),\"State\")","v":"State"}]
[null,{"$f":"IFERROR(VLOOKUP(MerchantCountryCodeLong, CountryLookup[],4),\"ZIP code\")","v":"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,"Country *","United States",null,"Country *","United States"]
[null,"Address",null,null,"Address"]
[]
[null,"City",null,null,"City"]
[null,{"$f":"IFERROR(VLOOKUP(BillCountryCodeLong, CountryLookup[],3),\"State\")","v":"State"},null,null,{"$f":"IFERROR(VLOOKUP(ShipCountryCodeLong, CountryLookup[],3),\"State\")","v":"State"}]
[null,{"$f":"IFERROR(VLOOKUP(BillCountryCodeLong, CountryLookup[],4),\"ZIP code\")","v":"ZIP code"},null,null,{"$f":"IFERROR(VLOOKUP(ShipCountryCodeLong, CountryLookup[],4),\"ZIP code\")","v":"ZIP code"}]
[null,"Additional info"]
[]
[" ","Item name *","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(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(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":"Batch","index":1,"n_rows":51,"n_cols":17,"rows_kept":51,"hidden":true,"merged":[[12,7,12,9],[13,3,13,4],[13,7,13,9],[14,3,14,4],[14,7,14,9],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4]]}
[null,"BATCH INVOICING"]
[]
[]
[null,"The functionality on this sheet is not currently available in the PayPal Invoicing app."]
[]
[null,"INSTRUCTIONS (Click plus sign to view/hide)"]
[null," ž Enter up to 100 rows of invoice details."]
[null," ž Only email address, amount, and currency is required."]
[null," ž We'll auto-enter invoice numbers and invoice date if left blank. "]
[null," ž Select CREATE > BATCH > SEND ALL INVOICES on the web application  to send your invoices."]
[]
[]
[null,"Your contact info",{"$nulls":4},"Invoice number","(Leave blank to auto-number)"]
[null,"Business name",null,"PayPal",null,null,"Invoice date *",{"$f":"TODAY()","v":{"v":41669,"d":"4166900.00%"}},{"$nulls":8},{"$f":"VLOOKUP(BatchMerchantCountryCodeLong, CountryLookup[], 2, FALSE)","v":"US"}]
[null,"Business email",{"$nulls":4},"Due date *",{"$nulls":9},"en_US"]
[{"$nulls":16},2]
[null,"First name"]
[null,"Last name"]
[null,"Address"]
[]
[null,"City"]
[null,"State"]
[null,"Zip code"]
[null,"Country",null,"United States"]
[null,"Phone number"]
[null,"Fax number"]
[null,"Website"]
[null,"Additional info"]
[{"$nulls":16},2]
[null," ","Email Address *","First Name","Last Name","Business Name","Invoice #","Inv Date","Due Date","Description *","Amount *","Currency *","Tax Rate","Note (to customer)","Memo","PayPal Message"]
[null,null,"someone@example.com","Mike","Gragg","Fourth Coffee",null,{"$f":"TODAY()","v":"2014-01-30"},{"$f":"IF(BatchDueDate=\"\", \"\", BatchDueDate)","v":""},"Line item description",{"v":100,"d":"100.00"},"USD",{"v":0.0825,"d":"8.250%"},"Thank you for your business.","This customer wants 1 day shipping."]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]
[{"$nulls":7},"2014-01-30","",null,0,"USD",{"v":0,"d":"0.000%"}]

{"sheet":"Data","index":2,"n_rows":9,"n_cols":6,"rows_kept":9,"hidden":true,"merged":[[2,0,2,5]]}
[{"$nulls":5},"INVOICE DATA"]
[]
["The data on this sheet is used by the PayPal Invoicing app and should remain hidden. Any changes made to this sheet could result in invoice errors. "]
[]
[null,"Country","Code","State","ZIP","Currency Code"]
[null,"Australia","AU","State","Postal code","AUD"]
[null,"Canada","CA","Province","Postal code","CAD"]
[null,"United Kingdom","GB","County","Postal code","GBP"]
[null,"United States","US","State","ZIP code","USD"]

{"sheet":"FAQs","index":3,"n_rows":76,"n_cols":2,"rows_kept":76}
[null,"Frequently Asked Questions"]
[]
[null,"This invoicing template was built to be used with Excel 2013."]
[]
[null,"When you download the template an application should appear that enables you to send and manage your invoices. If this application does not appear, on the Insert tab, in the Apps group, click Apps for Office. Search for PayPal Invoicing, and then insert it."]
[]
[null,"What if I don’t have Excel 2013?"]
[]
[null,"If you have an older version of Excel you can download PayPal’s Excel Invoicing Application for Excel 2007 & Excel 2010."]
[null,"Click this link to get the invoicing add-in."]
[]
[null,"Or, 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,"Can I use this tool to manage invoices created on PayPal.com?"]
[]
[null,"Yes.  All invoices that you created using the web invoicing tool on PayPal.com will appear on your invoice management screen.  A blue \"W\" will appear next to the invoice to indicate it was created on the web.  To view or edit these invoices you can click the View and Edit action."]
[]
[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, and then insert it."]
[]
[null,"What will my customers receive when I submit the invoice?"]
[]
[null,"When you send the invoice, your customer will receive an email that shows the summary of the invoice. It will also include a button to View and Pay the Invoice."]
{"$rows_empty":16}
[null,"When your customer clicks View and Pay Invoice, they will see the details of the invoice and a button to pay online."]
{"$rows_empty":15}
[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 "]