Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
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 -
Let me know if you need anything further.
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 -
Let me know if you need anything further.
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.
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
How can I run a VAT report to show all transactions - including the missing invoices entered now but relating to to a previous 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?
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:
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.
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?
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:
If so, let's check the date of the first VAT filing in QuickBooks. Then, perform the steps below:
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:
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.