I use QB for one of my clients (his choice) and since the accountant came round to post year end adjustments I now have an uncategorised tax amount showing in the VAT100 and in the Trial Balance. This has been accounted for in the financial accounts.
My question is, how do I clear the uncategorised amount in QB??
The most common cause of uncategorised VAT amounts is that a journal has been posted to the VAT control account without a VAT item assigned to it. It means that QB doesn't know where to put this amount as you haven't told it whether it's VAT on sales or purchases.
If you open up your VAT100 report and double click on the uncategorised amount, it will bring up the transaction in the detailed VAT report. If you then double click on this it will bring up the actual transaction itself. At the end of each line are VAT item boxes and for each net transaction you need to put in whether it is VAT on sales or purchases and the rate (ie 17.5% or 20%) HM Revenue & Customs should be the Supplier. If you save this and then refresh the report, the uncategorised amount should have gone.
I tried as you suggested but QB has now put the figure into the current VAT return.... Do you know if QB has a similar code to Sage's T9?? Or is do you have another suggestion I could try?
Sorry couldn't get back to you earlier. I guess Amanda has now answered your question I would do as she suggested to remove the amount from your current VAT return.
I would use O "Outside scope" as the code that is the same as T9 in Sage.
Hi Corry, Sorry couldn't get back to you earlier. I guess Amanda has now answered your question I would do as she suggested to remove the amount from your current VAT return. I would use O "Outside scope" as the code that is the same as T9 in Sage. Pauline
Hi Corry & Pauline,
I am having a very similar issue. Thanks for this thread. I cannot see Amanda's answer to this question to follow her suggestions and would also like to remove the amount from my current VAT return. Is is simply a matter of changing the code on each entry to O "Outside Scope" or is there more to it?
This is Amanda's reply which was in another thread:-
"This is what I did to get rid of uncatagorised amounts in the VAT return, I had a similar problem when the previous person had a 2006 version and mine was 2008. I set up in the COA a VAT suspense and labelled it 2006 so the accountant knows what it is for as like you its already been accounted for. Then I journalled out the amount. I did:- DEB VAT control CREdit VAT suspense Then put abit in the memo to tell the accountant what it was for, in the name section put HMRC(default), then the next column which is VAT item leave it BLANK, this will then automatically go tot he uncatagorised part of the VAT return and take it out of there. I have done it so it works OK. If you need to take out any amounts in the Sales or purchases section do the same but in the VAT item put it to Sales or purchases."
Hope this helps.
@Amanda....hope you don't mind me pinching your answer!
No probs I missed this one earlier, mine you that was over a year ago I did that journal and I have a memory like a sieve so I wouldn't have remembered without going back over my QB and going through the previous journals to find it.
I will give that a go and report back. And thanks for noticing this very old thread to re-engaging with it. I found this reply by Googling my question and then joined to connect with others as well as get the answer. Did not know you existed and am glad to have connected with a helpful bunch such as yourselves.
I would do as she suggested to remove the amount from your current VAT return.
