Making You Count The Institute of Certified Bookkeepers
Making you count Login 

Welcome to the Institute of Certified Bookkeepers UK forum

New to the forum? See our Getting Started Guide

Search the forum here

Latest Topic Updates

 

ICB Main Site -> Forum Home -> Technical Queries -> Quickbooks allocating to wrong VAT account
Quickbooks allocating to wrong VAT account
Tue 08 May 2012 09:57 AM
Rich8man

Rich8man

Member CB.Dip
Practice Licence


11 posts
Has anyone come across this situation before? I've been handling the books for a company for some years now with no trouble in preparing the VAT return. In January we started a new company so set up a new company (vatable) in quickbooks. Since then its been allocating all the S rated transactions straight to the VAT liability account rather than the control account. Hence when running the VAT return, no figures are generated. Z rated are sent to the control account, but thats not helpful. Ive been in touch with Quickbooks helpdesk and guess what, since we are running 2008 its not supported and they refuse to give any advice at all. How helpful is that!!! I have also tried putting a journal entry from the liabilty account over to the control account with the VAT total dated the end of the VAT quarter, but its not helped either. Any thoughts?  
 
 
Tue 08 May 2012 02:36 PM
Stardoe

Stardoe

Associate CB.Cert PM.Dip
Practice Licence


164 posts
Hi there,

Have you set up HM Revenue & Customs Supplier as the VAT Agency and checked to see what account VAT on purchases and sales are being tracked to?  There should be two boxes on the Supplier account, one for Sales tax and one for Purchase tax.  There are drop down boxes to choose the account.

I only have one VAT Control account which is set up as a Current Liability.  All VAT items are posted to this....on the debit side if it's purchase tax and credit side if it's sales tax.  When you run the VAT return, file it and then pay the resulting amount through the supplier account then the amounts get automatically journalled out of the VAT Control account.

Hope this helps

Pauline 
 
 
 
Tue 08 May 2012 03:01 PM
Rich8man

Rich8man

Member CB.Dip
Practice Licence


11 posts
Hi Pauline,

Thanks for response, however I have already checked all those settings. You are correct in stating that  there is just one control account, nothing has changed there. The only thing that is different is the allocation in the items list.  VAT on sales/purchases is now allocated to the liability account, not control. Cant see any way of changing that.

Glad for your input.

Richard.
 
 
 
Tue 08 May 2012 04:45 PM
Stardoe

Stardoe

Associate CB.Cert PM.Dip
Practice Licence


164 posts
Hi Richard,

So you have a VAT Control account and a VAT Liability account?  The way to change the account that the particular code in the item list is allocated to is by changing the account in the HMRC VAT Supplier - Edit Supplier - VAT Agency Info window.

Pauline 
 
 
First Previous - Page 1 of 1 - Next Last

Posts on this forum are not the views or opinion of the ICB unless stated
The ICB reserves the right to moderate or remove any posts made on this forum
Any abusive posts or users should be reported to memberservices@bookkeepers.org.uk

By using this forum you are agreeing to abide by the full Forum Terms and Conditions viewable here

 






© The Institute of Certified Bookkeepers