@user04032022
I am not familiar with the app you are using. Afaik, as of 2008, Intuit dropped support for setting Tax1Total and Tax2Total via the QBSDK. Users that have been using these fields to set GST/PST (Canada) or VAT (UK) will not longer have access to these fields once they upgrade to QuickBooks 2008 or later. Our clients have been using another importer tool and prepare their data in XLS format. The workaround is using the Sales Tax Code field to set the VAT code on each line.
| Customer | Transaction Date | RefNumber | PO Number | Terms | Class | Template Name | To Be Printed | Ship Date | BillTo Line1 | BillTo Line2 | BillTo Line3 | BillTo Line4 | BillTo City | BillTo State | BillTo PostalCode | BillTo Country | ShipTo Line1 | ShipTo Line2 | ShipTo Line3 | ShipTo Line4 | ShipTo City | ShipTo State | ShipTo PostalCode | ShipTo Country | Phone | Fax | Email | Contact Name | First Name | Last Name | Rep | Due Date | Ship Method | Customer Message | Memo | Cust. Tax Code | Item | Quantity | Description | Price | Is Pending | Item Line Class | Service Date | FOB | Customer Acct No | Sales Tax Item | To Be E-Mailed | Other | Other1 | Other2 | Unit of Measure | AR Account | Currency | Exchange Rate | Sales Tax Code |
| Anne's Bakery | 01/09/2020 | 100 | | | | | Y | 15/09/2020 | Anne's Bakery | One Harbor Street | | | Anytown | NY | 12345 | USA | Anne's Bakery | One Harbor Street | | | Anytown | NY | 12345 | USA | (123) 456-7890 | | | | | | | | | | | Non | Cabinets | 10 | Cabinets | 1000 | | | | | | | | | | | | | | | Non |
| Anne's Bakery | 01/09/2020 | 100 | | | | | Y | 15/09/2020 | Anne's Bakery | One Harbor Street | | | Anytown | NY | 12345 | USA | Anne's Bakery | One Harbor Street | | | Anytown | NY | 12345 | USA | (123) 456-7890 | | | | | | | | | | | Non | Hardware | 10 | Hardware | 50 | | | | | | | | | | | | | | | Non |
| John's Barber Shope | 02/09/2020 | 101 | | | | | Y | 15/09/2020 | John's Barber Shope | 1 Main Street | | | Anytown | NY | 12345 | USA | John's Barber Shope | 1 Main Street | | | Anytown | NY | 12345 | USA | (999) 888-8888 | | | | | | | | | | | Non | Blueprints | 1 | Blueprints | 500 | | | | | | | | | | | | | | | Non |
| Main St Bank | 03/09/2020 | 102 | | | | | N | 16/09/2020 | Main St Bank | 1 State Street | | | Anytown | NY | 12345 | USA | Main St Bank | 1 State Street | | | Anytown | NY | 12345 | USA | (888) 888-8888 | | | | | | | | | | | Non | Door | 1 | Door | 300 | | | | | | | | | | | | | | | Non |
Explore this importer tool. If you need other clarifications, you may contact their Support.
https://transactionpro.grsm.io/qbd
