cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements


We've set up a drop-in clinic for all your payroll and COVID-19 payroll related questions. Visit quickbooks.co.uk/yearendclinic to connect with an expert.
Level 1

How to Adjust VAT for prior period

Hi - I've completed a VAT return and submitted it. It came up as a refund which then sparked the Revenue to come and look. Really nice chap etc. but, of course, he found a couple of discrepancies and adjusted the return at their end.

I now need to make those adjustments in my file copy of QB. I've done this which generates a VAT 100 showing the difference so added with the original return the figures are correct.

But I can't make QB "file" the return - it says that there's a previous return for these dates.

So what I want to know is how to account for these adjustments and make QB balance up to the refund that i actually received.

Thanks in advance.

Solved
Best answer 02-07-2019

Accepted Solutions
Highlighted
Level 4

How to Adjust VAT for prior period

As this is Desktop locate the last period return in the control account and delete it now refile that period again making the adjustments to match the HMRC vat as filed and then file to paper and receive refund later.

View solution in original post

16 REPLIES 16
Highlighted
Level 4

How to Adjust VAT for prior period

As this is Desktop locate the last period return in the control account and delete it now refile that period again making the adjustments to match the HMRC vat as filed and then file to paper and receive refund later.

View solution in original post

Highlighted
Level 1

How to Adjust VAT for prior period

Graceman - you're a hero! Many thanks.
Highlighted
Level 1

How to Adjust VAT for prior period

Hi. I have a similar problem but I am using Quickbooks online.

The lovely VAT man came to see us as we filed a return for a rather large refund. He then found out what the problem was (long story) but we ended up owing them.

They have obviously made the adjustment on their side but I need to now adjust on QB.

I had seen on another thread (which I can't for the life of me find!) which seemed to answer part of my query but as this is closer to what happened I thought I would jump in here.

 

Many thanks

 

Highlighted
QuickBooks Team

How to Adjust VAT for prior period

Hello Rhiannon226.

 

Did you file this return directly to HMRC through QuickBooks?

 

Thanks,

 

Talia

Highlighted
Level 1

How to Adjust VAT for prior period

Hi Talia.

 

Yes I did.

Highlighted
QuickBooks Team

How to Adjust VAT for prior period

Hello,

 

In that case, we are unable to unfile it - which would allow you to correct it on the actual period. Your only option is to adjust your current open period reflecting any changes that should have been made on previous periods - i.e. to reflect how much extra/less you should have paid/reclaimed. Please let us know if you have any further questions on this.

 

Thanks,

 

Talia

Highlighted
Level 1

How to Adjust VAT for prior period

Hi,

Iam filing tax return for March 2019, but in the statement it is showing adjustments of Jan and Feb 2018 input tax how do I track down this transaction to get exact amount for only March 2019 tax?

Highlighted
QuickBooks Team

How to Adjust VAT for prior period

Hi Accounts SA

 

Are the amounts showing in box 1?

Highlighted
Level 1

How to Adjust VAT for prior period

No, we don't have boxes. It is showing in Block 18.

Highlighted
QuickBooks Team

How to Adjust VAT for prior period

Hey Accounts SA,

 

Thanks for contacting us with regards your VAT in QuickBooks. Are you using QuckBooks online ZA, or QuickBooks desktop to file your VAT returns?

Thanks,

Highlighted
Level 1

How to Adjust VAT for prior period

We are using Quickbooks online ZA

Highlighted
QuickBooks Team

How to Adjust VAT for prior period

Thanks for clarifying that,

From what I can see, block 18 of the VAT 201 report should represent input tax on all acquisitions of goods and services where VAT rate of 14% is applicable.

When you go to the 'Prepare return' screen from the 'Taxes' menu on the left hand side of QuickBooks online, you should be able to drill into the figure represented in block 18. Within there, it will show you a detail report with the individual transactions represented in the box total. Is that the case?


Thanks,

Highlighted
Level 1

How to Adjust VAT for prior period

Yes Mr. Chris_H, I have filed 2018-19 return month wise but it has not shown that time but now it is taking as input credit why?

Highlighted
QuickBooks Team

How to Adjust VAT for prior period

Hi Accounts SA,
 

I am aware of a couple of things which have been known to cause this in the past.

1) If any historical transactions in previously filed VAT periods have been edited, deleted, or indeed transactions have been added to these closed periods after filing, then balances will be brought forward in the relevant blocks; In this case block 18. A way you can check if this is the case, is to drill into your current figures for block 18 to itemise the transactions, open the ones which have historical dates. This should show an audit log providing information on when the transactions were edited and by how much.

2) Has your accounting method for VAT changed from a cash basis to accrual recently? If that is the case, then any previously open bill's which were not showing in Box 18, would post in the most recent VAT return.

Thanks,

Highlighted
Level 1

How to Adjust VAT for prior period

Thanks for the explanation, I think the first will apply to us. If this is the case then how to treat those transactions?

Highlighted
QuickBooks Team

How to Adjust VAT for prior period

So with regards these transactions, if the VAT amount has changed or not been entered in on previous filings, but has now, this VAT will be due to pay or reclaim in the current return which you are filing. QuickBooks online is working as designed, in the sense that any historically entered VAT which is added into already closed/filed filing periods will be reflected in the current filing so as to be captured ther.

If you have any questions or concerns about the actual correct recording of these transactions as per ZA Vat regulations, it may be a good idea to speak to the SARS and explain the situation to them.

Thanks,

 

Chris.