Sample import file

<< Click to Display Table of Contents >>

Navigation:  Invoicing > QuickBooks Online import >

Sample import file

clip0483

 

Sample import file data

InvoiceNo,Customer,InvoiceDate,DueDate,Terms,ServiceDate,Memo,Item(Product/Service)",Description,Quantity,ItemRate,ItemAmount,ItemTaxCode,ItemTaxAmount,Currency,Other,Other1,Other2

50799,"Rodco Enterprises",2024-01-19,2024-01-19,"Due on receipt",2024-01-12,,"CPD_N SS","Native Screened Sand (Ticket # 43)",13.27,150.27,1994.08,"H",259.23,"CAD","Picked Up","43","1"

50799,"Rodco Enterprises",2024-01-19,2024-01-19,"Due on receipt",2024-01-12,,"CPD_N SS","Native Screened Sand (Ticket # 45)",13.82,150.27,2076.73,"H",269.98,"CAD","Picked Up","45","1"

50799,"Rodco Enterprises",2024-01-19,2024-01-19,"Due on receipt",2024-01-12,,"CPD_N SS","Native Screened Sand (Ticket # 46)",14.88,150.27,2236.02,"H",290.68,"CAD","Picked Up","46","1"