cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
briancronin2021
Level 1

How to fix Import that has messed up my GST on all invoices?

I have recently had an import carried out from Xero to QBO As a result of the import all of the existing invoices imported have been applied with "Out of Scope Tax" with GST(deleted) in the Product line and no Tax amount showing in the invoice. I am fairly certain that this will result in incorrect GST return values. Q: I cannot understand how the import could have been so negligent and how to correct this.
2 Comments 2
BabyB
QuickBooks Team

How to fix Import that has messed up my GST on all invoices?

When you import transactions to QuickBooks Online, the sales tax rate is set as Out-of-scope Tax. You'll need to manually edit each transaction to include the correct rate, Brian.

 

You can customise a report to show invoices with missing sales tax. Here's how:

 

  1. Go to Reports.
  2. Enter Transaction List by Date in the search field.
  3. From the Report period dropdown menu, select the correct date range.
  4. Select Columns,  then select Tax Amount.

 

After that, you can manually add sales tax to each transaction. Here's how:

 

  1. From the list of results, select an invoice with missing sales tax.
  2. In the customer form, click the Amounts are dropdown, and choose your preferred tax information.
  3. Under the Sales Tax column, select the appropriate sales tax rate.
  4. Click Save and close.

 

Additionally, you can refer to this article on how to record or edit your sales tax payments: Manage sales tax payments in QuickBooks Online.

 

I'll keep this thread open if you have further questions regarding sales tax. Just add a reply below and we'll address them promptly.

briancronin2021
Level 1

How to fix Import that has messed up my GST on all invoices?

I appreciate the support.
This community is exceptionally fast and provides great replies. regretfully, this option is not viable, as my accounts for 2024-25 still require filing, and without the GST being correctly imported on both Invoices and Bills, my filing would be completely inaccurate.
To carry out the task as you have noted for a year's invoicing and Bills would be a greater task than I would look to undertake. 
The attachment here is for one of the invoices that shows GST (deleted) (Out of scope of Tax)
The Bills show similarly.
194 Bills and 735 Expenses, this is a task that would not be possible. 
QBO and the importing companies should be a lot more considerate to the customers; this has cost me a lot of time and money for no gain.  
I cannot believe that other importing companies "from New Zealand" have not encountered this problem.
Thankyou once again for your support.
Regards
Brian