cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
Fylde
Level 1

Posting Missing Invoices From a Previous VAT Period

Hello,

 

Having just migrated to Quickbooks in meeting the making Tax Digital requirements, there are of course, elements of this new system that function differently to what I am used to.

 

I completed and submitted my first VAT return for March several weeks ago and I am now working towards the April return. I have just started using Receiptbank and have realised that in amongst my April supplier invoices are some invoices that are dated prior to 1st April. Essentially these are invoices that were missing when completing the March return. 

 

My previous system (TAS) allowed for two dates when posting an invoice, one that was the true date of the invoice and one for the accounting period. Quickbooks only seems to allow one date.

 

What is the best way to deal with invoices that fall in a previous period for which a VAT return has already been submitted? If I let the system post these invoices with their actual dates on, surely this will adjust a VAT return that has already been submitted and will not include these on the most current VAT return?

 

I have become aware that there is a process for closing down a period in Quickbooks although I did not do this for March. I tried this but the system would not let me until any minus stock figures are dealt with.

 

Does the period closing process address the above and prevent any issues?

 

Many thanks in advance.

Solved
Best answer May 28, 2019

Accepted Solutions
JackS
Moderator

Posting Missing Invoices From a Previous VAT Period

Hi Flyde,

 

Welcome to our Community.

 

Having looked at your query, you are correct in that QuickBooks Online does only allow one date to be entered on the transactions. What you would need to do is enter the transaction with the correct date, ie the date that falls within the previous filing period, and QBO will account for any VAT due on your current return as an exception.

 

The exception will notify HMRC that the transaction has been accounted for within the current period but refers to a previously filed period. It will not physically alter the already filed return.

 

With regards to the closing of the period within QBO, are you looking to close the books so no changes can be made to the period? The process you mention closes the entire books up until the date entered meaning no changes can be made at all. For more information on this function, have a look at our article - How to close the books.

 

If you are looking to close off the period as simply filed with HMRC and reconciled, then the above process would not necessarily work for you in this sense. Filing the VAT closes the VAT period and any changes made to transactions that fall within this period will show as Exceptions as above. Reconciling the period closes this off in a similar fashion. For more tips on Reconciling, you can visit our dedicated Community article -

How to reconcile accounts.

 

Let me know if you need anything further.

View solution in original post

8 REPLIES 8
JackS
Moderator

Posting Missing Invoices From a Previous VAT Period

Hi Flyde,

 

Welcome to our Community.

 

Having looked at your query, you are correct in that QuickBooks Online does only allow one date to be entered on the transactions. What you would need to do is enter the transaction with the correct date, ie the date that falls within the previous filing period, and QBO will account for any VAT due on your current return as an exception.

 

The exception will notify HMRC that the transaction has been accounted for within the current period but refers to a previously filed period. It will not physically alter the already filed return.

 

With regards to the closing of the period within QBO, are you looking to close the books so no changes can be made to the period? The process you mention closes the entire books up until the date entered meaning no changes can be made at all. For more information on this function, have a look at our article - How to close the books.

 

If you are looking to close off the period as simply filed with HMRC and reconciled, then the above process would not necessarily work for you in this sense. Filing the VAT closes the VAT period and any changes made to transactions that fall within this period will show as Exceptions as above. Reconciling the period closes this off in a similar fashion. For more tips on Reconciling, you can visit our dedicated Community article -

How to reconcile accounts.

 

Let me know if you need anything further.

Fylde
Level 1

Posting Missing Invoices From a Previous VAT Period

Hello and thank you for your help, yes that was exactly what I was missing, I was not aware of the procedure for closing the VAT period by marking the return as submitted but I have now completed this.

 

Am I correct in my understanding that any transactions which end up on the exceptions report must be manually entered by using the adjustment function on the VAT 100 report? It looks like these do not automatically get included in the VAT 100 report figures.

 

Thanks again.

TaliaI
QuickBooks Team

Posting Missing Invoices From a Previous VAT Period

Hello,

 

Any transactions included in the exceptions report will have been included in the overall figure for VAT due. You do not need to re-enter these - they don't show on the VAT 100 report.

 

Thanks,

 

Talia

A K1
Level 1

Posting Missing Invoices From a Previous VAT Period

How can I run a VAT report to show all transactions - including the missing invoices entered now but relating to to a previous period?

A K1
Level 1

Posting Missing Invoices From a Previous VAT Period

I found this report actually but it doesn`t show any items at all. We are new to Quickbooks. And I know entered some September invoices recently. Our next return due is for the month of October. Do I need to manually adjust the return with these transactions?

CharleneMaeF
QuickBooks Team

Posting Missing Invoices From a Previous VAT Period

Hello, A K1. Thanks for joining in this thread.

 

I'm here to help ensure you the invoices are added correctly for accurate VAT returns filing and run a VAT report to show all transactions in QuickBooks Online.

 

First, if you have previous submissions, you can go into the invoices that were included on the previous VAT return and make amendments to the invoice by selecting VAT, and this will cause exceptions. For more details on how this works, please see this article: VAT exceptions and reports in QuickBooks Online.

 

However, we highly recommend talking to an accountant to ensure everything is tracked accurately and avoid messing up your records.

 

Then, let's run the VAT Detail Report in the program. This report lists all transactions that are included in each box on the VAT return. Here's how:

 

  1. Go to Reports.
  2. In the search box, enter VAT Detail Report and then select it.
  3. Select the report period and desired date range.
  4. Click Run report.

 

However, if you've backdated any transactions or made any changes to a transaction you have already filed (known as Exceptions), these will not be included on this screen. You can run the VAT Exception Report instead.

 

Please feel free to ask if you have any further questions about VAT returns. I am here to assist you and will ensure this conversation remains open for your replies at any time. Take care.

A K1
Level 1

Posting Missing Invoices From a Previous VAT Period

My VAT Exception report has no data. However, I entered a couple of invoices dated earlier than the current vat period. 

Is this happening because this is my very first VAT filing from Quickbooks Online? Is there a way to retrieve these numbers so I can manually adjust the first VAT return from QO?

CharleneMaeF
QuickBooks Team

Posting Missing Invoices From a Previous VAT Period

Let's make sure this is sorted out so it shows the VAT Exception report correctly, A K1.

 

When you make modifications to transactions that have already been filed in a VAT return using QuickBooks Online, this is the time you create exceptions. It helps to ensure that no VAT is overlooked or duplicated when reporting to His Majesty's Revenue and Customs (HMRC).

 

Please note that QuickBooks generates exceptions when you perform the following:

 

  • Change the VAT code in the transaction.
  • Add, remove, or modify the transaction amount.
  • Add or remove an income/expense account line from the transaction.
  • Add or remove a customer or supplier from the transaction.

 

If so, let's check the date of the first VAT filing in QuickBooks. Then, perform the steps below:

 

  1. Run the VAT Exception Report.
  2. Check the exception dates on the return. If the exceptions on the transaction are:
    • Dated on or after the first VAT filing, these are classed as 'genuine exceptions' and will not be removed.
    • Dated before the first VAT filing, contact support to have the exception removed.
    • If there is no date on the transaction, this would suggest the transaction has been deleted. Select the transaction to find out when it was created.

 

However, if the report remains empty, I recommend contacting our Live QuickBooks Support Team. This will allow us to securely access your account information and get all the details we need to ensure the issue is investigated and fixed promptly.

 

Here's the step-by-step process:

 

  1. Click this link: https://intuit.me/CU.
  2. Select the product you're using and the edition.
  3. Enter a brief summary of your concern in the What's your question? field.
  4. Click Continue.
  5. Choose how you would like to connect with us.

 

You can also contact our support team inside the QuickBooks program. For the detailed steps, please check this article: QuickBooks Support.

 

Let us know if you have any questions about the VAT Exception. We'll always be right here to help you anytime. Have a nice day!

Need to get in touch?

Contact us