Skip to main content
P
pezza
July 30, 2020
Question

Migration of VAT submissions from QBO to QBAO

  • July 30, 2020
  • 1 reply
  • 0 views

Hi,

 

Having migrated my data over to QBAO, VAT returns slowly generated automatically and then detected that these have already been submitted for which I was able to simply mark as filed.  They were zero amounts anyway as I haven't been trading for over a year now.

 

It has only gone back so far though and it hasn't picked up the VAT returns for the previous year.

 

The issue is that I have bank transactions waiting to be reconciled at the moment but there are no VAT return entries for these periods/payments.

 

How can I re-generate those returns so that they:

 

1) Appear in the VAT returns

2) are marked as filed

3) are marked as PAID (and linked to the pending bank transactions)

 

I did get a third party tool which I used for all of my other data import/export but exporting and importing VAT submissions/entries/details doesn't seem to be possible (apart from control and adjustments)

 

Thanks

 

Andrew

1 reply

S
ShiellaGraceA
July 30, 2020

I have just the information you'll need about VAT, @pezza.

 

Since you've migrated, you'll want to mark your taxes as filed in QuickBooks for your record. Here's how you can mark your VAT as filed in QBO:

 

  1. Go to Taxes, then VAT.
  2. Select Prepare return to view your open return.
  3. Confirm the dates and figures are correct. When you are ready to submit your VAT return to HMRC, click File online with HMRC.
  4. Choose Submit a VAT Return/Set up a VAT Direct Debit Instruction, then Submit a return.
  5. Tick Mark as Filed.

 

As with your reconciliation, you can record your VAT payment and then find a match in the banking page to reconcile. Here's how:

 

  1. Go to Banking, then the Banking tab.
  2. Choose the For Review tab, and locate the VAT payment.
  3. Click the Find Match button. Then, select the possible transactions that match the payment.
  4. Hit Save.

With these steps, you're able to mark your taxes as filed and paid. For details about VAT return, please check out this link: Submit a VAT return in QuickBooks Online.

 

I'll also share with you our page about assign, categorize, edit, and add your downloaded banking transactions which I'm sure you'll find helpful. It has detailed steps to guide you through the process.

 

That'll do it. Please let me know if there's anything else I can assist you with. I'll be around to help. Thanks for joining us today and I wish you have nice day ahead.

P
pezzaAuthor
July 31, 2020

Thanks for the reply @ShiellaGraceA , however my point was that the items are not available in the VAT section as it has only pulled in returns going back 1 year.

 

The payments that I need to reconcile are for prior submissions that are not showing, and therefore there are no entries for me to select "Prepare Return" for.  All of the ones that did appear, as mentioned, I have already marked as filed.

 

What I need to do is either get the system to recognise these earlier submissions so that I can then do as you suggest, or find a way to manually record them in the way that the system does.  It would appear that it only goes back so far (or at least that seems to be the case with my scenario)

 

Thank you

 

Andrew

G
GlinetteC
July 31, 2020

Thanks for getting back to us and providing additional information about your concern, pezza.

 

Yes, that is correct. You may consider recording those payments manually in QuickBooks  so the system will recognise them and then reconcile them after. I'll walk you through recording payments in QBO. Here are the steps:

 

  1.  Go to the Taxes section on your left-hand navigation bar.
  2. For the period you are wanting to record the payment / refund you will have a drop-down arrow on the same line but the far right-hand side under the Action column.
  3. Select Record Payment.
  4. Fill in the information,date, bank, and amount and save.

If you have your bank connected to QuickBooks you can then match them from your For Review section to the payment you created in the steps above. 

 

I've also added this link about submitting a VAT return in QuickBooks Online for your reference.

 

Let me know if you have other questions. I'm always here to help.

Terms & ConditionsAccessibility statement