cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
Anonymous
Not applicable

Newbie. I'm not VAT registered. Logging expenses I've noticed that if I include VAT the VAT is then deducted from my expenses making the total less than I've paid?

 
Solved
Best answer January 31, 2022

Accepted Solutions
John C
QuickBooks Team

Newbie. I'm not VAT registered. Logging expenses I've noticed that if I include VAT the VAT is then deducted from my expenses making the total less than I've paid?

Hi Gunde As you're not VAT registered and you've activated the VAT/Taxes feature for future transactions you can set the default tax setting to No VAT; select the cog/gear icon > account and settings > advanced > accounting > default tax rate selection > No VAT > save. In relation to the historic transactions then you will have to change those manually, there is no option to change the amounts are field to No VAT in batch/bulk. We will of course pass you valued comments/feedback on to our developers for their consideration and encourage you to leave feedback from within the product.

View solution in original post

6 REPLIES 6
JessT
Moderator

Newbie. I'm not VAT registered. Logging expenses I've noticed that if I include VAT the VAT is then deducted from my expenses making the total less than I've paid?

Hi studio2,

 

I'll be glad to share an information on adding VAT to purchases.

 

If you don't need to add VAT on purchases, you can use the No VAT option.

 

 

On the other hand, the effect of adding VAT on your expenses depends on whether it's Inclusive or Exclusive.

 

Let's say you purchased an item worth €100 and it's 20% VAT inclusive. When you enter it in QuickBooks, the total will be €100 and 20% (€) of it is your VAT. If you choose Exclusive, 20% of  €100 will added to the transaction. Please see the screenshot for comparison.

 

 

Please note that not all VAT Codes posts the same way if a company is on a Flat Rate scheme. Here are some articles for your reference in the future:

Feel free to post again if you need more help.

Anonymous
Not applicable

Newbie. I'm not VAT registered. Logging expenses I've noticed that if I include VAT the VAT is then deducted from my expenses making the total less than I've paid?

Thanks! Although when I select inclusive of tax it is still one;y adding the pretax amount of an item to my profit and loss reports, the only way around it seems to select NO VAT. Any ideas?

John C
QuickBooks Team

Newbie. I'm not VAT registered. Logging expenses I've noticed that if I include VAT the VAT is then deducted from my expenses making the total less than I've paid?

Hi studio2

 

If you record any transaction with No VAT it will not be recorded in the VAT/Taxes section however it will still show on your Profit and Loss, Balance Sheet and Trial Balance.

 

 

Gunde
Level 1

Newbie. I'm not VAT registered. Logging expenses I've noticed that if I include VAT the VAT is then deducted from my expenses making the total less than I've paid?


Have the same issue and the only workaround seems to be manually go through each transaction and change the tax rate to No Tax, otherwise reports seems to calculatw the VAT exclusive prices which is not right! 

Have chat someone on Quickbooks about this but he had no clue! In fact he couldn’t even answer my question let alone give me a workaround to remove VAT the rate in bulk all these transactions replacing it with No VAT. Apparently we have to do this manually for each transactions! Woow! I mean come on this is such a basic feature that even the smallest companies provide! Changing the VAT rate from thousands transactions manually doesn’t make sense! 

Apart from this, when you run a report the transaction amounts seems to be recorded at VAT exclusive amounts. Shouldn’t these show up as VAT inclusive total amounts when you had this selected on each transactions?

 

For example I have an expense that I paid £100. The expense were recorded as VAT inclusive, so VAT exclusive amount is £80 on this spending and the VAT amount is £20 at 20% rate.

 

Everything seems fine here but when you run a financial year report what I see is recorded on that expense is £80 (VAT Exclusive amount) instead of £100 (VAT Inclusive amount)

 

This obviously not correct as I paid £100 for that expense so when I do may tax return I should be able to reclaim that amount which is £100.

 

Shouldn’t reports show the VAT inclusive totals when you run a report? 

John C
QuickBooks Team

Newbie. I'm not VAT registered. Logging expenses I've noticed that if I include VAT the VAT is then deducted from my expenses making the total less than I've paid?

Hi Gunde As you're not VAT registered and you've activated the VAT/Taxes feature for future transactions you can set the default tax setting to No VAT; select the cog/gear icon > account and settings > advanced > accounting > default tax rate selection > No VAT > save. In relation to the historic transactions then you will have to change those manually, there is no option to change the amounts are field to No VAT in batch/bulk. We will of course pass you valued comments/feedback on to our developers for their consideration and encourage you to leave feedback from within the product.

Noeley
Level 1

Newbie. I'm not VAT registered. Logging expenses I've noticed that if I include VAT the VAT is then deducted from my expenses making the total less than I've paid?

I agree ,why is this not a thing on QB its a basic thing .you should be able to batch change anything .

Need to get in touch?

Contact us