Skip to main content
May 6, 2020
Question

How can I import total sales tax on one invoice that has multiple items with multiple sales tax rate?

  • May 6, 2020
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

May 6, 2020

Hi there, 

 

Importing your data to QuickBooks Online is an awesome feature that saves you time and effort. When importing invoices, the system will recognize the columns that are named according to the QuickBooks Online defaults. These fields will be mapped automatically if the following column headers are used (the fields marked with * are mandatory):

  1. *Invoice number
  2. *Customer
  3. *Invoice date
  4. *Due date
  5. Item amount
  6. Item tax code
  7. Terms
  8. Service Date
  9. Item (Product/Service)
  10. Item Description
  11. Item Quantity
  12. Item Rate
  13. *Item Amount
  14. Memo

If you use different column headers, then you'll have to manually map the fields while importing the transactions. To know more about how to import invoices in QuickBooks Online, check this detailed article: Import multiple invoices at once.

 

 In case you have other questions, feel free to contact our support team using this link here.