Previous submitted VAT returns item

We are a VAT registered business & started using quickbooks desktop partway through a year so im entering old sales & purchase invoices that have already been included on a vat return.  Is there a way in QB of marking them like you can do in sage as already incldued on VAT Rtn so that they dont show up on teh exceptions report.    The only way i can think of at the moment is by creating  a  VAT liability account & instead of adding vat adding a second line item to this vat liabilty on all invoices then i post the VAT payment here too. 


Take the TB  from the old system which I guess is the end or last years accounts use that date (for example 31st December 2017) As the date of all data take on in Qb posting to opening balance equity account as opposite posting account so you can generate a TB in QB that matches the old system. (Feel free to tweak it as required to tidy up or consolidate odd accounts)

These opening balances can be tweaked later is you find odd late entries or you get transactions in transit that come in later.

Now open the first day of new year in QB and you will see Qb has gone through a year end and everything is ready to start entering the transactions to build the data forward to current date. At first Vat period end date run vat summary and compare to that posted. Tweak using vat adjustment as required or trace difference and correct if any.

When satisfied QB is correct fil to paper and save this is just within QB and asllows you to assign the payments to the vat bill which is created.

Now just run through to current period date. Any queries just ask but you should be able to build QB to current period where you can choose to set up direct HMRC posting.

Make sure you set up your vat period end dates correctly in supplier account for Vat usually HMRC you might have two accounts for them one will be payroll if used the other I usually rename as HMRV Vat to distinguish.

Make sure the End of accounting year is also set up correctly before you start this.

Was this answer helpful? Yes No
1 additional answer

No answers have been posted

More Actions

People come to QuickBooks Learn & Support for help and answers—we want to let them know that we're here to listen and share our knowledge. We do that with the style and format of our responses. Here are five guidelines:

  1. Keep it conversational. When answering questions, write like you speak. Imagine you're explaining something to a trusted friend, using simple, everyday language. Avoid jargon and technical terms when possible. When no other word will do, explain technical terms in plain English.
  2. Be clear and state the answer right up front. Ask yourself what specific information the person really needs and then provide it. Stick to the topic and avoid unnecessary details. Break information down into a numbered or bulleted list and highlight the most important details in bold.
  3. Be concise. Aim for no more than two short sentences in a paragraph, and try to keep paragraphs to two lines. A wall of text can look intimidating and many won't read it, so break it up. It's okay to link to other resources for more details, but avoid giving answers that contain little more than a link.
  4. Be a good listener. When people post very general questions, take a second to try to understand what they're really looking for. Then, provide a response that guides them to the best possible outcome.
  5. Be encouraging and positive. Look for ways to eliminate uncertainty by anticipating people's concerns. Make it apparent that we really like helping them achieve positive outcomes.

Select a file to attach:

Qb community
Looking for advice from other business owners?

Visit our QuickBooks Community site.