Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
JackS
Level 3
August 30, 2023
Question

All things VAT | Post Your Question Below

  • August 30, 2023
  • 32 replies
  • 38 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.

 

 

 

 

 

 

 

32 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???

Level 14
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. 

New Member
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?

 

Level 14
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.

New Member
September 13, 2023

@Ashleigh1After going over the figures I can see that this is  wrong, and wrong is a few ways.
Firstly I don't have any outstanding VAT to be paid, other than the figure of £3425.49, which is what I was recording after VAT going out on the 12th.
 
The £1868.13 is NOT the due figure for the current quarter. This is in fact than the total amount of VAT due on SALES ONLY. If this figure is to show the current periods VAT due, it should be the correct figure of the difference between VAT on sales and VAT on purchases!
This figure is also incorrect as it's the total of VAT on sales only but based on ACCRUAL AND NOT CASH. I pay my VAT using the cash scheme and it is setup that way in QBO.
 
What I do have to ask, after again wasting more time trying to figure out Intuits thought process here. Why is this even on this payment page? It's not even a factor when assigning a payment to previous quarter or period????

 

Level 9
September 18, 2023

And zero response to the obvious issue with the VAT?


I understand encountering issues with VAT figures in QuickBooks Online has caused you inconvenience, Mark. And I know you've already contacted our support team regarding this matter.

 

As much as I want to help you resolve this, I am unable to do it here in the Community as this is a public space. I'd still recommend contacting our support once again to address account-specific concerns. They have tools to access your account and investigate this further.

 

Once everything gets fixed, consider generating the VAT Liability report to review and track your VAT obligations. The report provides a detailed breakdown of each VAT agency, the taxable amount of sales, and payments. By reviewing this report, you can ensure that your VAT calculations are accurate and identify any discrepancies or errors.

 

The Community is here to assist you with further questions about VAT or any related concerns. 

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!

 

QuickBooks Team
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. 

QuickBooks Team
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
QuickBooks Team
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

Level 13
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.