cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
JDirect
Level 1

Import orders from Amazon & Ebay from 6th of April 2021 but VAT from February 2022

Hello,

 

I want to import all my eBay and amazon transactions into QBK. I have already configured the apps (I haven't turned it on yet). My question is, if I want to download all transactions from April 6, 2021, and from February 2022, I have to register for VAT.
What about transactions before February 2022 that were not subject to VAT.
How to separate or label them in QBK. My VAT configuration in QBK is still not configured, waiting for a VAT number to be assigned.

Is it better to start accounting in QBK when I have already received a VAT number and only report those transactions that are already with VAT - i.e. from February 2022.

 

Kind regards

Sam

1 REPLY 1
MariaSoledadG
QuickBooks Team

Import orders from Amazon & Ebay from 6th of April 2021 but VAT from February 2022

Let me guide you on what to do with your VAT transactions so you can import them in QuickBooks, JDirect.

 

With Automated VAT and to keep your records accurate, you can adjust the VAT you owe for the month of April to a specific period you want it to be adjusted. To do this, follow the steps below:

 

To set up an account for adjustment:

  1. Select the Gear icon at the top, then choose Chart of accounts.
  2. Select New at the top right.
  3. From the Account Type dropdown, select Income or Expenses.
    • If you need to decrease your VAT due, set up an income account.
    • If you need to increase your VAT due, set up an expense account.
  4. Select the account’s Detail Type.
    • Use Sales of Product Income for an income account.
    • Use Taxes Paid for an expense account.
  5. Name your adjustment account (for example, "VAT due increase").
  6. Select Save and Close.

 

Then, add an adjustment. Here's how:

  1. Select Taxes from the left menu, then select VAT.
  2. Find the tax period you need to adjust, then select Prepare return.
  3. Select Adjust against the entry to be adjusted.
  4. Select the Adjustment date and the Tax rate.
  5. Select the Adjustment account for adjusting VAT.
    • Choose an expense account if you need to increase the tax due.
    • Choose an income account if you need to decrease the tax due.
  6. Enter the Adjustment amount.
  7. Enter notes in Memo, then select Save.

 

From there, you can now import your transactions to QuickBooks Online (QBO).

 

Please know that you set vat rates for your transactions. I've added these articles for your guide:

 

Additionally, to learn more details about VAT, check out this article for more information: What Is The Difference Between VAT Control and VAT Suspense?

 

Feel free to let me know if you have any concerns about VAT. As always, I'll be a few clicks away if you need help.

Need to get in touch?

Contact us