Skip to main content
JackS
August 30, 2023
Question

All things VAT | Post Your Question Below

  • August 30, 2023
  • 12 replies
  • 0 views

 

This article aims to help you with all things VAT. It may be that you need help recording VAT payments, submitting a VAT return or you need a hand with setting up VAT. Post your questions below and we'll have an expert get back to you.

 

 

 

 

 

 

 

12 replies

September 12, 2023

I am trying to record vat refund but unable to allocate to correct bank account.  Dropdown box does not give me any options

September 12, 2023

I am having the same issue - I am unable to record the VAT refund using the VAT drop down box.  There is no option to choose the bank account.

October 18, 2023

I ma having the axactly same problem.

I can't choose the bank account for the VAT payment to HMRC.

Can anyone help please???

September 12, 2023

Hello Debbie Saines, thanks for posting on this thread, how are you trying to record this vat refund exactly? Can you provide us with the steps you are taking to do this so that we can look into this more for you. 

September 12, 2023

I'm just recording my VAT payment of £3425.49 which is correct. What is the £1868.13 in relation to? My current period VAT100 report shows nothing like that amount so far?

 

September 12, 2023

Hello Mark, so the Total VAT Due is all the unpaid VAT for the filed returns in QBO, whereas VAT Due this period is the amount due for your current return. You may possibly have a VAT Refund or Payment from an earlier VAT period that hasn’t been recorded.

September 12, 2023

All payments are up to date but as far as my current period it's at -£38.60, been a heavy purchase quater so far. No idea where the other amount shown in the payment is from. I've not had full confidence in VAT since moving over the data fully from QBD last year.

Is there a way to view where this missing payment is located?

September 12, 2023

Thanks for replying back, Mark. I appreciate the opportunity given to further and answer your queries. 

 

I agree that the Total VAT Due showing in QuickBooks Online is your unpaid VAT obligation. To be able to view your missing VAT payments, you can run the VAT Liability Report. I would be more than happy to guide you through the steps involved in generating this report.

 

Here's how:

 

  1. Go to the Reports menu.
  2. In the Find report by name section, enter VAT Liability Report.


     
  3. Click on the report to open.
  4. You can customize the Report period, VAT Agency, and Accounting method.


     
  5. When done, hit Run report.

 

There, you can now get a detailed look at the taxes you owe and why you owe them. This helps you make sure everything is accurate before you file your return to your tax agency. You can check out this article to learn more about running this report and how to file your VAT return: Check how much VAT you owe in QuickBooks Online.

 

Additionally, aside from customizing your reports, please know that QuickBooks Online also offers us the ability to memorize our customized reports so we don't have to report the process all over again every time we run the same report. To get started, feel free to browse through this article: Memorise reports in QuickBooks Online.

 

Please don't hesitate to ask any questions along the way. My utmost priority is to ensure that you feel confident and empowered in managing your VAT payment stubs. Thank you for choosing QuickBooks Online, and I eagerly anticipate the opportunity to provide you with further assistance.

November 6, 2023

Hi, we have an invoice, where by we purchased goods in Germany and they where shipped directly within Germany toe site. We have been charged 19% VAT but this is not reclaimable. We shouldn't have shipped this method, to be honest. 

I used the code EU GM 19% but this is showing in my VAT report as reclaimable.

Can you please advise how to adjust?

Thanks

November 6, 2023

Hello Debbie, thanks for getting in touch about adjusting your VAT. You can adjust the VAT using the article we've linked as a guide. We would recommend speaking to an accountant to confirm they are happy with this or HMRC as it looks like you are using a manually created code if you are using the UK version as it does not have a 19% EU code as standard.

January 16, 2024

HI

 

I have changed from QB desktop - really old - to QBO. 

 

I have transferred all transactions including previous 2 years with using spreadsheets etc.

 

The previous years sales (not produced on QBO) have imported with the wrong tax amount - it duplicated the invoice value.

 

I have adjusted the correct tax value which now gives a huge difference in VAT - I cant see anyway to change the VAT to confirm that the amounts do not mean HMRC owe me money (I wish !) and I need to do so urgently as the exception report has shown on the current return.

 

Help please!

 

January 16, 2024

Welcome to the Community, Chris. This isn't the experience we want you to have. No worries, I've got the steps you can follow to solve this.

 

First, let's confirm the company settings. Although we can move your accounting figures into QuickBooks, we don't carry over information like company name, address, and email details.

 

  1. Go to the Gear icon, then choose Accounts and settings.
  2. In the Company tab, enter your company and contact info.
  3. Update the email addresses to ensure billing and customer communications are handled correctly.
  4. Select Save.

 

Second, confirm your VAT settings. It's essential that QuickBooks Online is set up with the correct VAT registration number and filing frequency before you and your client start using it. You can skip this step if your business isn't registered for VAT.

 

  1. Go to Taxes, then choose VAT.
  2. Select the Edit VAT dropdown and select Edit Settings.
  3. Enter the Tax registration date.
  4. Make sure How often do you submit a VAT return to HMRC? Is correct and change Which VAT accounting scheme do you use? If required.
  5. Select Save.

 

Third, clean up VAT. Because you have never filed VAT using QuickBooks Online before, QuickBooks Online assumes that all VAT recorded in the accounts is now due. This means the VAT balance shown in QuickBooks needs to be corrected. Enter the date of the last VAT filing from your QuickBooks Desktop file. This will ensure the VAT balance shows correctly and that future VAT returns are accurate.

 

  1. Go to Taxes, choose VAT, and select Prepare Return.
  2. Enter the Start Date and End Date in the Prepare VAT Return screen.
  3. Select the Mark as Filed button, then click Continue to confirm that the VAT returns have been filed up to the To Date.
  4. You'll be taken to the VAT screen. You need to enter a reverse journal entry to ensure your current balance is correct.
  5. Select Save and new.

 

The VAT balance shown in QuickBooks should now be correct, ensuring that future VAT returns are accurate.

 

You can refer to this article for a detailed step. Follow steps 2, 3, and 4: Post-conversion checks for getting started with QuickBooks Online.

 

If you need assistance with the process, I recommend contacting our support team for guidance.

 

Additionally, you can refer to this article about recording, managing, and deleting VAT payments in the tax centre: Manage VAT payments in QuickBooks Online.

 

Let me know if you have other VAT-related concerns. I'm here to assist. Keep safe.

April 16, 2024

When I am trying to record a VAT payment I enter the VAT paid in the payment amount box. When I have done I am no longer able to reconcile my bank balance as the figure entered has now created a difference. This is effectively double counting as payment will be recorded is part of the transaction when the funds are paid to HMRC. 

April 16, 2024

Is your bank account connected to QuickBooks Online (QBO)? @Jesmond B.

 

If it is, one reason the amount is being double counted is due to a manually entered transaction for the VAT payment. You only need to match the VAT payment you made to the transaction from your bank.

 

To avoid double counting, please delete the manually added VAT payment transaction located in the bank register of the account you used for the VAT payment.

 

  1. Go to the Gear icon.
  2. Choose Chart of accounts.
  3. Navigate to the account you used for the payment and click View register.
  4. Locate the VAT payment and delete it.

 

Additionally, you can refer to this article for more information on what to do if QBO doesn't match your bank statement at the end of a reconciliation: Fix issues at the end of a reconciliation in QuickBooks Online.

 

Please let me know if you have any further questions about your reconciliation. I'm here to help you in any way I can.

August 21, 2024
have a major issue with my VAT this quarter.
I use a third-party program that creates invoices and syncs them into QBO. I started using that program around 2017. When QBO marks them as paid it mostly syncs back and tells the third-party program that is paid although not all the time.
Since my last VAT return, there was an issue with the third-party program whereby it synced all the invoices from 2017 to the current date back to QBO.
We did something to fix that but I cannot recall what and clearly not enough. I think my VAT bill this quarter currently stands at £4932 although it may come down BUT QBO is showing it as £43,413.37 as being due. There are about £38,000 odd in the exceptions report.
Not sure what to do
Bryan_M
August 21, 2024

Thanks for joining this forum, @AtmosSteveVR.

 

Let's ensure to correct your VAT in this quarter.

 

Please know that the VAT return QuickBooks generates is based on the transactions imported by your third-party program. 

 

Since you mentioned that this is a re-occurring issue and was fixed in 2017, I suggest contacting your third-party program support to recall steps on how you resolve it.

 

Also, you can review your imported invoices to check duplicated transactions that cause the incorrect balance of your VAT. Here's how:

 

  1. Select Invoices from the Sales tab.
  2. Look for invoices that have duplicates by filtering the Status and Date tabs.
  3. Once you find it, click the dropdown icon below the Action column and select Delete.
  4. Then, click the Delete icon in the prompt message. The system will recalculate the total VAT automatically.

 

Also, reach out to your accountant and perform VAT adjustments. Check out this article for more info: Make VAT adjustments in QuickBooks Online.

 

If the issue persists within QBO, I recommend contacting our Care Team to check your account in a safe environment and find the root cause.

 

Additionally, you can read this article if you want to modify your VAT settings: Set up and edit VAT settings, codes, and rates in QuickBooks Online.

 

You can always return here if you have additional questions about managing your VAT return. We'll be willing to lend a hand. Keep safe, and have a good one.

September 18, 2024

Can I do my vat abroad

September 18, 2024

Hi John, thanks for dropping in. With QuickBooks Online, you can work at anytime, anywhere. This means you can perform the same VAT actions (including submitting to HMRC) as you would in the UK.