Thanks for your post and welcome to the QuickBooks Online Community.
When you link QuickBooks to HMRC this will not change anything within your account, it is only when you submit a return that the filed amount will move from the VAT control to the VAT suspense account, from which this balance is cleared when the VAT payment is recorded on the Taxes screen against the filing.
For the three journals posting to the VAT suspense, do these relate to filings which were made prior to joining QuickBooks or did you submit these through QuickBooks Online?
Yes those three files (my 3 returns for the year so far) appears as open returns on the taxes tab and the total on them does not match with my actual returns and also my returns have been already filed and paid (apart from the last one) so I do not know why QB has created those files when also and the VAT control account it matches with my previous system (SAGE) ?
Thank you for getting back to me with the additional information.
It is only possible to have one open return in QuickBooks, are any of these returns showing under 'Filed' or 'Paid' on the Taxes screen?
Is the amount which is showing in the 'VAT DUE' column different to the amount showing in the journal for this date in the VAT suspense account?
If possible are you able to attach a screenshot of one of the journals created?
So on the taxes tab (attached) the 3 VAT FILES when I linked with HMRC were on the open return at the top with totals which does no agree with my actual accounts (SAGE-QB) and HMRC, I moved them to filed to see which will be the impact but numbers are wrong and my VAT control is fine so I got a total on the VAT SUSPENSE account which correspond to this 3 returns with wrong amounts on them which I do not know from where QB is taking the totals as my ledger is fine
Thank you for the screenshot. Did you move these to filed by selecting 'Mark as Filed'?
Filings should only be marked filed when the returns are correct with the figures matching what was submitted to HMRC.
We can raise an unfiling request for the two returns showing as 'filed' - this would re-open the periods to allow you to reconcile the return and ensure the correct transactions are included to file with the correct figure.
Were these returns recorded as filed within Sage pre-migration?
I hope you well, as this was quite important to get fixed I spoke over the phone with one of your colleagues on Friday and they said an specialist will call me on Monday and I have not received a phone call back from an specialist yet,
And yes I requested same as you suggest to please move the file and unfailing them so at leats we can look into them and yes on SAGE and HMRC my VAT files were filed and paid and totals on both does not agree with what is on the ones I sent you and the VAT CONTROL ACCOUNT is fine on QB.
Can you please proceed accordingly?
Thank you, I still have not heard from you.
At leats, Can you please move the filed VAT files to open as discussed last week over the phone and again on this chat?
Looking forward o your response,
I have checked the status of the callback request and this is still in progress due to be actioned, we aim to process these within 48 hours, however during busy periods this may take longer than expected.
To complete the unfiling request we require the figures showing in the 'VAT DUE' column for the two returns to be unfiled - we would be grateful if you could reply with a screenshot which captures this.
Please also check the exception report (drop-down on action menu > view exception report) against all three returns to view if there are any exceptions showing here and reply to the below with yes/no.
- Open return
- Filed return ending 30/09/2019
-Filed return ending 30/06/2019