VAT Return on Flat Rate Scheme - Invoice without VAT and VAT-only invoice
I issued two invoices to a single client without VAT while I was waiting for my VAT registration to come through. The effective date for my VAT registration was before the two invoices without VAT were issued. I also registered for the Flat Rate Scheme with the same effective date. Following advice from my accountant, I then issued a VAT-only invoice for the VAT on the first two invoices.
On my VAT Return page, the VAT Payable for the first two invoices (without VAT) is zero, and the VAT Payable for the third (VAT-only) invoice is calculated by multiplying the Value Inc VAT (which in this case is *only* VAT) by the Flat Rate. This has the overall result that the total VAT Payable is much lower than I believe it should be. Here are the figures to illustrate what I mean :-
Invoice 001: £8,500.00 (no VAT)
Invoice 002: £8,075.00 (no VAT)
Invoice 003: £2,486.25 (VAT only)
Total incl VAT: £19,061.25
VAT Payable on invoices 001, 002 & 003: £19,061.25 X 10.5% = £2,001.43
But FreeAgent calculates it as £2,486.25 X 10.5% = £261.06
I now know that what I should have done when my VAT registration came through is to issue credit notes for the first two invoices and then issue new invoices including the VAT. However, since I have already issued (and been payed for) the VAT-only invoice, things seem to be a lot more complicated.
In FreeAgent, I've tried adding credit notes for all 3 issued invoices, and then adding two new invoices including the relevant VAT amounts, but this doesn't seem to reconcile the numbers in the VAT Return page :-
* The initial problem seems to be that the VAT Return is calculating the VAT Payable based on the Value Inc VAT for an invoice and when the invoice is VAT-only this results in paying VAT on VAT.
* Invoice 007 (which is actually a credit note for just the VAT) does successfully cancel out the VAT Payable for Invoice 003, but Credit Notes 005 & 006 generate non-zero values for VAT Payable which do *not* correspond with the zero values for VAT Payable on Invoice 001 & 002.
* As a minor point, I would have thought that Invoice 007 should be labelled as a Credit Note and not an Invoice. The fact that it's only VAT does not change the fact that it is a negative amount.
I may well be approaching this in completely the wrong way, but any help or advice would be very welcome.
Thanks, James.
On my VAT Return page, the VAT Payable for the first two invoices (without VAT) is zero, and the VAT Payable for the third (VAT-only) invoice is calculated by multiplying the Value Inc VAT (which in this case is *only* VAT) by the Flat Rate. This has the overall result that the total VAT Payable is much lower than I believe it should be. Here are the figures to illustrate what I mean :-
Invoice 001: £8,500.00 (no VAT)
Invoice 002: £8,075.00 (no VAT)
Invoice 003: £2,486.25 (VAT only)
Total incl VAT: £19,061.25
VAT Payable on invoices 001, 002 & 003: £19,061.25 X 10.5% = £2,001.43
But FreeAgent calculates it as £2,486.25 X 10.5% = £261.06
I now know that what I should have done when my VAT registration came through is to issue credit notes for the first two invoices and then issue new invoices including the VAT. However, since I have already issued (and been payed for) the VAT-only invoice, things seem to be a lot more complicated.
In FreeAgent, I've tried adding credit notes for all 3 issued invoices, and then adding two new invoices including the relevant VAT amounts, but this doesn't seem to reconcile the numbers in the VAT Return page :-
Description , VAT Payable , Value Inc VAT
Invoice 001 , 0.00 , 8,500.00
Invoice 002 , 0.00 , 8,075.00
Invoice 003 , 261.06 , 2,486.25
Credit Note 005 , -892.50 , -8,500.00
Credit Note 006 , -847.88 , -8,075.00
Invoice 007 , -261.06 , -2,486.25
Invoice 008 , 1,026.38 , 9,775.00
Invoice 009 , 975.06 , 9,286.25
Totals , 517.65 , 21,505.00
* The initial problem seems to be that the VAT Return is calculating the VAT Payable based on the Value Inc VAT for an invoice and when the invoice is VAT-only this results in paying VAT on VAT.
* Invoice 007 (which is actually a credit note for just the VAT) does successfully cancel out the VAT Payable for Invoice 003, but Credit Notes 005 & 006 generate non-zero values for VAT Payable which do *not* correspond with the zero values for VAT Payable on Invoice 001 & 002.
* As a minor point, I would have thought that Invoice 007 should be labelled as a Credit Note and not an Invoice. The fact that it's only VAT does not change the fact that it is a negative amount.
I may well be approaching this in completely the wrong way, but any help or advice would be very welcome.
Thanks, James.
2
people have this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
The company marked this question as answered.
-
Inappropriate?floehopper,
The way FreeAgent expects (perhaps unreasonably) you to do this is:
* Set your VAT Status as 'Registration Applied For'.
* Create your two invoices, with the appropriate rates of VAT set at the invoice-item level
* FreeAgent will then display an invoice which includes VAT in the prices, so reflecting that VAT is charged, but without breaking it out specifically.
* You then issue those invoices to your client.
* Once your VAT registration has come through, you change the VAT Status to 'Registered'. The invoices automagically change to show the VAT broken out, and you re-issue those to the client.
That's the workflow the HMRC outline here.
But actually your method is just as valid (and was indeed an alternative workflow the HMRC published until fairly recently).
Taking a quick look at the database (we have some very low-level tools, and can't access your account like you can) it looks like those initial invoices may have been marked as sent before any VAT registration was set up. Since invoices are pretty much 'frozen' once they're sent, they still 'think' they're not VAT-related and are therefore reporting no VAT output liability.
I think if you:
* remove the payment explanations temporarily
* mark as draft
* mark as sent
* re-add the payments
then you should see the correct VAT reporting.
Do let me know how you get on...
(btw we take your point about VAT-only credit notes and we'll tidy that up)
1 person says
this answers the question
-
Inappropriate?Hi Ed,
Many thanks for your help. I really appreciate it.
The steps you suggested do seem to have fixed the VAT reporting. However, I still have a couple of smaller problems which I'd like to resolve :-
* In FreeAgent, my first invoices now have the company VAT registration details on them, but when I sent the invoices to the client they did not have the details on them. I know that I have the PDF copies of the actual invoices I sent, but it would be preferable if they matched up with the ones in FreeAgent. Is there a way I can change the invoices so that they either don't have the VAT registration details on them; or at least that they say that VAT registration has been applied for?
* I can't seem to explain the payment for the VAT-only invoice. The VAT-only invoice (003) is not showing up in the drop-down list of sent unpaid invoices.
* Your link to the HMRC workflow doesn't seem to work for me.
Cheers, James.
I’m getting there
-
Inappropriate?Can anyone help me with the issues in my last message?
I’m waiting patiently for a response
-
Inappropriate?I have just successfully "explained" the VAT-only invoice (003), but my question about removing the VAT registration details from invoices 001 & 002 still stands.
Thanks, James.
I’m a little happier
-
Inappropriate?floehopper,
Sorry for the delay.
Re: invoices 1 and 2: Sorry, that's not possible. I agree it would be good if you could see both 'applied for' and 'registered' versions, but that's not how FreeAgent currently works.
Your PDF invoices stored elsewhere, together will your explanation of how it's been handled should be OK for any future VAT investigation...;->
Loading Profile...




EMPLOYEE