{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Invoice","Sales Report","Customer Report","Product Report","Customer Statement","Sales Rep. Report","Payment Report","Aging","©","Office-Kit.com.System"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":268,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Invoice","index":0,"n_rows":47,"n_cols":18,"rows_kept":47,"cut":false,"hidden":false,"merged":[[34,5,36,10],[28,7,28,9],[27,7,27,9],[1,16,2,20],[3,17,3,20],[4,16,5,16],[4,17,5,20],[6,16,7,16],[6,17,7,20],[8,16,9,16],[8,17,9,20],[10,16,12,16],[10,17,12,20],[13,16,16,16],[13,17,16,20],[20,10,20,11],[19,10,19,11],[19,7,19,9],[29,10,29,11],[29,7,29,9],[18,7,18,9],[18,10,18,11],[28,10,28,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[22,7,22,9],[23,10,23,11],[22,10,22,11],[23,7,23,9],[25,7,25,9],[24,10,24,11],[24,7,24,9],[26,7,26,9],[21,7,21,9],[21,10,21,11],[2,0,2,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[9,5,9,6],[15,0,17,0],[11,5,11,8],[12,5,12,8],[13,5,13,8],[14,5,14,8],[20,7,20,9],[17,5,17,6],[5,12,5,13],[6,12,6,13],[8,0,8,1],[9,0,9,1],[10,5,10,8],[12,12,12,13],[10,12,10,13],[11,12,11,13],[14,9,15,13],[17,7,17,9],[17,10,17,11]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To create an invoice (tutorial Movie)"]
["Current Database",null,null,null,null,null,null,"Business Name",null,null,null,null,null,"INVOICE"]
[null,null,null,null,null,null,null,"Business Slogan",null,null,null,null,null,null,null,null,1,"Click Clear & New."]
["c5143",null,null,null,null,null,null,"Address",null,null,null,null,null,null,null,null,2,"Fill client information into the BILL To section. Or click the \"on-sheet picker\" button to pick from existing customers."]
["Invoice Status",null,null,null,null,null,null,"City State ZIP",null,null,null,"DATE:","2018-10-22"]
["Pending",null,null,null,null,null,null,"Phone, Email, Web Address",null,null,null,"INVOICE #:",null,null,null,null,3,"Fill products / items, or click the \"on-sheet picker\" button to pick from existing items."]
[]
["Customer #",null,"TaxSystem",null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Click Save Invoice to create a new invoice. Click Save Invoice to create a new invoice. Invoice# and date is filled automatically if empty."]
[null,null,1,null,null,"Customer:",null,null,null,null,null,"Type of Service:"]
[null,"Name",0,null,null,null,null,null,null,null,null,"Make:",null,null,null,null,5,"Extract, Email or print the invoice by clicking the corresponding button on the task pane."]
[null,"Address",0,null,null,null,null,null,null,null,null,"Model:"]
[null,"City, State ZIP",8.2500000000000004E-2,null,null,null,null,null,null,null,null,"Serial:"]
[null,"Phone",0.06,null,null,null,null,null,null,"Problem:",null,null,null,null,null,null,6,"Click the Help button on the Invoice ribbon tab to open detailed documents"]
[null,"Phone2"]
["Type of Service"]
[]
[null,"Item","Taxable","cost",null,"Item# / Taxable",null,"Description",null,null,"Quantity",null,"Unit Price","Line Total"]
["Repair",null,0,0,null,null,null,null,null,null,0,null,0,{"$f":"ROUND(oknQuantity_1*oknPrice_1,2)","v":0}]
["Sale",null,0,0,null,null,null,null,null,null,0,null,0,{"$f":"ROUND(oknQuantity_2*oknPrice_2,2)","v":0}]
[null,null,0,0,null,null,null,null,null,null,0,null,0,{"$f":"ROUND(oknQuantity_3*oknPrice_3,2)","v":0}]
[null,null,0,0,null,null,null,null,null,null,0,null,0,{"$f":"ROUND(oknQuantity_4*oknPrice_4,2)","v":0}]
[null,null,0,0,null,null,null,null,null,null,0,null,0,{"$f":"ROUND(oknQuantity_5*oknPrice_5,2)","v":0}]
[null,null,0,0,null,null,null,null,null,null,0,null,0,{"$f":"ROUND(oknQuantity_6*oknPrice_6,2)","v":0}]
[null,null,0,0,null,null,null,null,null,null,0,null,0,{"$f":"ROUND(oknQuantity_7*oknPrice_7,2)","v":0}]
[null,null,0,0,null,null,null,null,null,null,0,null,0,{"$f":"ROUND(oknQuantity_8*oknPrice_8,2)","v":0}]
[null,null,0,0,null,null,null,null,null,null,0,null,0,{"$f":"ROUND(oknQuantity_9*oknPrice_9,2)","v":0}]
[null,null,0,0,null,null,null,null,null,null,0,null,0,{"$f":"ROUND(oknQuantity_10*oknPrice_10,2)","v":0}]
[null,null,0,0,null,null,null,null,null,null,0,null,0,{"$f":"ROUND(oknQuantity_11*oknPrice_11,2)","v":0}]
[null,null,0,0,null,null,null,null,null,null,0,null,0,{"$f":"ROUND(oknQuantity_12*oknPrice_12,2)","v":0}]
[null,null,null,{"$f":"SUM(oknTaxable_1:oknTaxable_12*oknLineTotal_1:oknLineTotal_12)","v":0},null,null,null,null,null,null,null,null,"SUBTOTAL",{"$f":"SUM(oknLineTotal_1:oknLineTotal_12)","v":0}]
[null,null,null,null,null,null,"THANK YOU FOR YOUR BUSINESS!",null,null,null,null,"Sales Tax",8.2500000000000004E-2,{"$f":"ROUND(IF(oknTaxType=0,0, oknTax1Rate*(oknLineTotalTaxable+IF(oknTaxTotalIncludingShippingCost=0,0,oknShippingCost))),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"GST",0.06,{"$f":"ROUND(IF(oknTaxType<>2,0,oknTax2Rate*(oknLineTotalTaxable+IF(oknTaxTotalIncludingShippingCost=0,0,oknShippingCost)+IF(oknTax2IsAppliedToTax1=0,0,oknTax1))),2)","v":0}]
[null,null,null,null,null,"NOTES:",null,null,null,null,null,null,"SHIPPING & HANDLING",0]
[null,null,"Paid",0,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"ROUND(oknSubTotal + oknShippingCost + IF(oknTaxType=0,0,IF(oknTaxType=1,oknTax1,oknTax1+oknTax2)),2)","v":0}]
[null,null,"BalanceDue",0,null,null,null,null,null,null,null,null,"Repaired by:"]
[]
[null,null,null,null,null,"REPAIR POLICY --- PLEASE READ!"]
[null,null,null,null,null,"By leaving your repair, you accept and agree to this policy.",null,null,null,null,null,null,{"$f":"oknCompanyName","v":"Business Name"}]
[null,null,null,null,null,"A $10.50 ESTIMATE FEE APPLIES TO ALL VACUUMS",null,null,null,null,null,null,{"$f":"oknCompanyAddress","v":"Address"}]
[null,null,null,null,null,"MUST BE PICKED UP WITHIN SEVEN  DAYS OF COMPLETION",null,null,null,null,null,null,{"$f":"oknCompanyCityStateZip","v":"City State ZIP"}]
[null,null,null,null,null,"AFTER 14 DAYS A $1.00 PER DAY FEE WILL ACCRUE.",null,null,null,null,null,null,{"$f":"oknCompanyContact","v":"Phone, Email, Web Address"}]
[null,null,null,null,null,"REPAIRS LEFT OVER 30 DAYS WILL BE SOLD FOR CHARGES.",null,null,null,null,null,null,"All Sales Final"]
[null,null,null,null,null,"ESTIMATE FEES ARE POSTED AND ADHERED TO.",null,null,null,null,null,null,"No Cash Refunds"]
[]
[null,null,null,null,null,{"$f":"M11","v":0},null,{"$f":"M12","v":0},null,{"$f":"M6","v":"2018-10-22"},null,null,{"$f":"oknWhoName","v":0}]
[null,null,null,null,null,"CLAIM CHECK",null,null,null,null,null,null,null,{"$f":"M7","v":0}]

{"sheet":"Sales Report","index":1,"n_rows":12,"n_cols":17,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,{"$f":"oknCompanyName","v":"Business Name"}]
[null,{"$f":"oknCompanyAddress","v":"Address"}]
[null,{"$f":"oknCompanyCityStateZip","v":"City State ZIP"}]
[null,{"$f":"oknCompanyContact","v":"Phone, Email, Web Address"}]
[]
[null,"Date:"]
[null,"From"]
[null,"To"]
[]
[null,"Month","Date","Cost","Invoice #","P.O. #","Sales Rep.","Subtotal","Shipping",{"$f":"oknTax1Name","v":"Sales Tax"},{"$f":"oknTax2Name","v":"GST"},"Total","Paid","Balance Due","Due Date","Payment Term","Customer"]

{"sheet":"Customer Report","index":2,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,{"$f":"oknCompanyName","v":"Business Name"}]
[null,{"$f":"oknCompanyAddress","v":"Address"}]
[null,{"$f":"oknCompanyCityStateZip","v":"City State ZIP"}]
[null,{"$f":"oknCompanyContact","v":"Phone, Email, Web Address"}]
[null,"Date:"]
[null,"From"]
[null,"To"]
[]
[null,"Customer ID","Date","Name","Invoice #","Cost",{"$f":"oknTax1Name","v":"Sales Tax"},{"$f":"oknTax2Name","v":"GST"},"Shipping Cost","Paid","Balance Due","Subtotal","Total","Due Date","P.O. #","Sales Rep.","Payment Term"]

{"sheet":"Product Report","index":3,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,{"$f":"oknCompanyName","v":"Business Name"}]
[null,{"$f":"oknCompanyAddress","v":"Address"}]
[null,{"$f":"oknCompanyCityStateZip","v":"City State ZIP"}]
[null,{"$f":"oknCompanyContact","v":"Phone, Email, Web Address"}]
[null,"Date:"]
[null,"From"]
[null,"To"]
[]
[null,"Product ID","Date","Invoice #","Description","Quantity","Price","Line Total","Unit Cost"]

{"sheet":"Customer Statement","index":4,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[8,5,8,6],[9,5,9,6],[11,5,11,6]]}
[]
[]
[null,{"$f":"oknCompanyName","v":"Business Name"}]
[null,{"$f":"oknCompanyAddress","v":"Address"}]
[null,{"$f":"oknCompanyCityStateZip","v":"City State ZIP"}]
[null,{"$f":"oknCompanyContact","v":"Phone, Email, Web Address"}]
[]
[null,"Bill To:"]
[null,"ID:",null,null,null,"Balance forward",null,0]
[null,"Name:",null,null,null,"Current balance",null,0]
[null,"Address:"]
[null,"City,ST ZIP:",null,null,null,"Invoice total",null,0]
[null,"Country:",null,null,null,"Payment total",null,0]
[null,"Phone:"]
[]
[null,"Statement Period:"]
[null,"From:"]
[null,"To:"]
[]
[null,"Date","Description","Document#","Due Date","Status","Amount","Balance"]

{"sheet":"Sales Rep. Report","index":5,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,{"$f":"oknCompanyName","v":"Business Name"}]
[null,{"$f":"oknCompanyAddress","v":"Address"}]
[null,{"$f":"oknCompanyCityStateZip","v":"City State ZIP"}]
[null,{"$f":"oknCompanyContact","v":"Phone, Email, Web Address"}]
[]
[null,"Date:"]
[null,"From"]
[null,"To"]
[]
[]
[null,"Sales Rep.","Date","P.O. #","Invoice #","Cost",{"$f":"oknTax1Name","v":"Sales Tax"},{"$f":"oknTax2Name","v":"GST"},"Shipping","Total","Paid","Subtotal","Balance Due","Due Date"]

{"sheet":"Payment Report","index":6,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,{"$f":"oknCompanyName","v":"Business Name"}]
[null,{"$f":"oknCompanyAddress","v":"Address"}]
[null,{"$f":"oknCompanyCityStateZip","v":"City State ZIP"}]
[null,{"$f":"oknCompanyContact","v":"Phone, Email, Web Address"}]
[]
[null,"Date:"]
[null,"From"]
[null,"To"]
[]
[]
[null,"Type","Date","Invoice #","Check / Money Order #","Notes","Amount","Total Applied","Customer ID","Customer Name"]

{"sheet":"Aging","index":7,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,0,1,30],[3,9,3,13],[20,1,20,2],[20,3,20,8],[20,9,20,10],[20,11,20,12]]}
[]
[]
[]
[null,{"$f":"oknCompanyName","v":"Business Name"},null,null,null,null,null,null,null,"Accounts Receivable Aging Report "]
[null,{"$f":"oknCompanyAddress","v":"Address"}]
[null,{"$f":"oknCompanyCityStateZip","v":"City State ZIP"}]
[null,{"$f":"oknCompanyContact","v":"Phone, Email, Web Address"}]
[]
[null,"Bill To:"]
[null,"ID:"]
[null,"Name:"]
[null,"Address:"]
[null,"City,ST ZIP:"]
[null,"Country:"]
[null,"Phone:"]
[]
[null,"Statement Period:"]
[null,"From:"]
[null,"To:"]
[]
[null,"Current",null,"31-60 Days Past Due",null,null,null,null,null,"61-90 Days",null,"Over 90 Days",null,"Total"]
[null,{"$f":"SUM(IF(oknAgDateTo-C25:C1001<=30,1,0)*J25:J1001)","v":0},null,{"$f":"SUM(IF(oknAgDateTo-C25:C1001<=60,1,0)*IF(oknAgDateTo-C25:C1001>=31,1,0)*J25:J1001)","v":0},null,null,null,null,null,{"$f":"SUM(IF(oknAgDateTo-C25:C1001<=90,1,0)*IF(oknAgDateTo-C25:C1001>=61,1,0)*J25:J1001)","v":0},null,{"$f":"SUM(IF(oknAgDateTo-C25:C1001>90,1,0)*J25:J1001)","v":0},null,{"$f":"SUM(B22:M22)","v":0}]
[]
[null,"Invoice #","Date","Total","Subtotal",{"$f":"oknTax1Name","v":"Sales Tax"},{"$f":"oknTax2Name","v":"GST"},"Shipping","Paid","Balance Due","Due Date","P.O. #","Sales Rep.","Type"]

{"sheet":"©","index":8,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Advanced Sample - Print One Invoice in Two Different Formats - c5143"]
[]
[null,"By InvoicingTemplate.com"]
[null,"Template URL"]
[]
[null,"© 2017 InvoicingTemplate.com / Uniform Software LTD"]
[]
[null,"This spreadsheet, including all worksheets and associated content is considered a copyrighted work under the United States and other copyright laws."]
[]
[null,"Do not submit copies or modifications of this template to any website or online template gallery."]
[]
[null,"Please review the following Terms of Use to learn how you may or may not use this template. Thank you."]
[]
[null,"See our Terms of Use / Copyright Notic"]
[null,"http://www.invoicingtemplate.com/about.html"]
[]
[null,"Do not delete this worksheet. If necessary, you may hide it by right-clicking on the tab and selecting Hide."]

{"sheet":"Office-Kit.com.System","index":9,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
["SoftID","OkInv 1.0"]
["DbPath","c5143.mdb"]
["HowToCloseBook",0,null,"Valid Value:","0=Auto discard changes,  1=AutoSave,   2=DefaultOperation,prompt "]
["SavingInvoicePromptForPayment",0]
["SavingInvoiceClearWorksheet",0]
["ExtractingReportRemoveRowCol",1]
["ExtractingInvoiceRemoveRowCol",1]
["ExtractingProtectWorksheet",1]
["ExtractingProtectPwd"]
["ExtractingEmailInvoice",0]
["ExtractingWhereToPlaceNewInvoice","$C$3"]
["ExtractingRowsToRemoveOnReportWorksheet",1]
["ExtractingInvoiceCopyPageSetup",1]
["InvoiceBodyMinNumber",1]
["InvoiceBodyMaxNumber",12]
["Allow incomplete line",1]
[]
["Allow zero line total",1]
[null,"3FI6I6I5DI1D"]
[]
[]
[]
[]
[]
[]
[null,1]
[]
[]
[null,2]
[null,1]
[null,1]
[null,1]
[]
[null,1]
[null,1]