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

Old Unassigned VAT Amounts

Hi,

 

I have just signed up for Making Tax digital and imported by files from my old quickbooks. However the VAT amount is incorrect. One of the issues is a lot of old unassigned VAT from 2016 and older. We are not due the VAT to HMRC and the accounts have been completed and submitted since then. How can I clear these unassigned VAT amounts as due to them being imported and not relating to the current VAT quarter I cannot adjust the totals shown. In case this make a difference our VAT rates vary from exempt, partial and full. Thank you.

Solved
Best answer October 25, 2019

Accepted Solutions
Ryan_M
Moderator

Old Unassigned VAT Amounts

Hi @Optom,

 

Thank you for your prompt reply. Let me take care of this query for you.

 

You'll have to mark each return manually, from way back 2016 up until the present, following the steps provided by my peer, @Jen_D above. Once it's marked as filed, the link beside that return will show Record payment. You'll have to manually record the payment as well, and then move on to the next return. Keep doing these steps until you get to your latest VAT return period.

 

More details on recording a VAT payment or refund are in this article: How to record a VAT payment or refund. This includes a video for your reference, as well as 2 separate steps for the payment and refund process.

 

Feel free to post a comment below, in case you have other questions. I'll get back to you as soon as I can.

View solution in original post

5 REPLIES 5
Jen_D
Moderator

Old Unassigned VAT Amounts

Welcome to the UK Community, @Optom,

 

To remove any unassigned VAT in QuickBooks, you'll have to mark them as filed from the start period until the current quarter.

 

The most likely reason why they are showing up in the VAT page, is that they might be categorised as VAT Control, or the start date selected during the MTD setup goes back to 2016.

 

Here's how to manually file a VAT return:

 

  1. From the left menu, click Taxes.
  2. In the Returns tab, select the previous VAT returns.
  3. Click Prepare return under the Action column.
  4. Review the Start date and End date of the period.
  5. In the Prepare VAT return page, select Mark as filed from the Submit to HMRC drop-down.
  6. Click Continue.

You can also find these steps in this article: File your VAT return and record tax payments in QuickBooks Online.

 

I've added these articles to learn more about MTD:

 

 

If you have other questions, please drop them here by clicking the Reply button below. I'll be here to help whenever you need one. Have a nice day!

Optom
Level 1

Old Unassigned VAT Amounts

Hi, Thank you for replying.

Can you please tell me how can I mark them as filed from the start period until the current quarter?

 

I also suspect that it is calculating VAT due from 2016 to 2019 which has also been paid. These amounts are not showing up as unassigned VAT. How can I rectify these?

 

Thank you

 

 

Ryan_M
Moderator

Old Unassigned VAT Amounts

Hi @Optom,

 

Thank you for your prompt reply. Let me take care of this query for you.

 

You'll have to mark each return manually, from way back 2016 up until the present, following the steps provided by my peer, @Jen_D above. Once it's marked as filed, the link beside that return will show Record payment. You'll have to manually record the payment as well, and then move on to the next return. Keep doing these steps until you get to your latest VAT return period.

 

More details on recording a VAT payment or refund are in this article: How to record a VAT payment or refund. This includes a video for your reference, as well as 2 separate steps for the payment and refund process.

 

Feel free to post a comment below, in case you have other questions. I'll get back to you as soon as I can.

Cahir20
Level 3

Old Unassigned VAT Amounts

Unassigned vat amounts

Hi,

We are working in ROI and using Quickbooks Desktop Pro 2020,

We transferred our Quickbooks program from a desktop PC to a laptop last year (due to covid 19 and working from home requirements)

Since then we have unassigned vat amounts of over €96,000.00 apparently owed to us by Revenue (if only!!)

These are dated back as far as 2011!!

Our ‘customer’ is Collector General and we don’t know  (i) where or (ii) how to add the vat item or code we need to make these figures go away!!

We would appreciate any help please, and thanks in advance

jamespaul
Moderator

Old Unassigned VAT Amounts

Hello, Cahir20.

 

I have an idea on how to remove the old unassigned VAT amounts from your books. 

 

You can create a VAT adjustment to remove those unassigned VAT amounts. It is normally done through sales receipts. Here's a detailed guide: 

 

  1. Click the Customers menu, then select Enter Sales Receipts.
  2. Leave the Customer field blank.
  3. Open the Tax drop-down menu, and select a 0% VAT rate item.
  4. Under the Item column, add the VAT rate item you want to adjust.
  5. In the Amount column, enter the amount of the adjustment.
  6. Click OK on the message "Changing the amount of a tax line item may cause your sales tax reports to be incorrect."

 

You might also need to adjust a negative value to remove the €96,000.00 unassigned VAT amounts. For more details, you can check this article: Process sales tax adjustment.

 

If you're unsure how to do this, I would recommend contacting our agents. They can help you adjust the unassigned VAT amounts and ensure your VAT taxes are correctly recorded while adjusting. 

 

Here's how to reach them: 

 

  1. Click the Help menu, then select QuickBooks Desktop Help.
  2. On the new pop-up window, click the Contact us link.
  3. A new built-in web browser will open. Simply select a topic.
  4. Scroll down, then choose how you want to reach us.

 

You can also use this article as a reference: Contact QuickBooks Desktop support.

 

We have QuickBooks Desktop help resources to assist you in managing your business. Give them a shot if you need a guide or two. 

 

Please let me know if you have more questions in managing your taxes or books in QuickBooks. I'm always here to help. 

Need to get in touch?

Contact us