Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
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
  • 1 view
No text available

1 reply

Level 5
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.