Join BKN

Join BKN
Join BKN

Bookkeeping Hall of Fame

Join BKN

Post Info TOPIC: VAT Relief on Bad Debt w/o - how to do in SAGE


Member

Status: Offline
Posts: 23
Date:
VAT Relief on Bad Debt w/o - how to do in SAGE


Hi

Can anyone help with this quandry?

I am doing an Adv. Sage course and the way of processing VAT relief for old [post-6 months] bad debts w/o is confusing.

Acct textbooks like Wood say that such VAT relief claimed should be added to Input Tax, not, it seems, just deducted from Output Tax.

But it terms of Sage system processing, the solution given by the IAB actually processes the w/o as a sales credit note through the personal a/c and debits bad debts net, with a debit of the VAT recovered to OUTPUT tax.

If this scenario came up in an exam, should I go with this method?

The other way would be to use the  bad debt w/o wizard and post gross to bad debt w/o. Then, the decision would be: journal out the VAT relief as a debit to Input tax or debit to Output tax account?

PS: I think [though not 100% sure] that HMRC Vat notice on this says to increase input tax on the return by the amount relieved. If correct, I suppose you could do anything in Sage as long as return was accurate, but returns are Sage-generated, so I think it's valid to try to get this clear.

Any ideas anyone?

Thanks

John

__________________


Member

Status: Offline
Posts: 22
Date:

My understanding is as follows:

1) Issue a non-VAT internal credit note for the amount inclusive of VAT - code the amount to the Bad Debt Account. This clears the sales ledger
2) Enter a purchase invoice with VAT on it coded to the Bad Debt account - this recovers the VAT as input tax as is required by the rules
3) Enter a non-VAT purchase credit note coded to the Bad Debt account for the VAT inclusive bad debt.

Hope that this makes sense!
Regards

__________________

Claire



Senior Member

Status: Offline
Posts: 107
Date:

I wouldnt do any credits or purchase invoices? If you are an experienced bookkeeper then a journal would just suffice..

__________________


Guru

Status: Offline
Posts: 882
Date:

any VAT on bad debts should be added to the input tax as it is an expense to the company not just a straight forward credit note to get it off the sales ledger.

I agree to enter a credit on the sales ledger, to the bad debt nominal code (8100) using T9 code. Then you will need to do a journal entry from the bad debt code to purchase tax control account. If you have a bad debt provision, then the net amount will be set off against this. If not, it will remain on the P&L.

However when you come to the VAT return, Sage will not include that amount so you will have do amend the final figures, it all depends on how you use sage!

__________________


Guru

Status: Offline
Posts: 595
Date:

I agree with the above. And yes VAT returns are generated by Sage but you CAN amend them. And then the question is what to do in an exam situation. I think you should go with the method IAB or your learning provider for IAB suggest...they should know what they expect. don,t worry they not always know :) I would not do the you can do anything as long as the result is right, definietly not in an exam...

__________________

Attila



Guru

Status: Offline
Posts: 882
Date:

I think the IAB are wrong though to suggest that the VAT is deducted to the outputs and not the inputs.

HMRC says
If you are entitled to claim bad debt relief, you add the amount of VAT you are reclaiming to the amount of VAT you are reclaiming on your purchases (input tax) and put the total figure in Box 4 of your VAT return.

I would question it with your training provider as this is an important issue.....

P

__________________


Newbie

Status: Offline
Posts: 1
Date:

I know not an option sage Exclude / Include early reconciled transactions. Select early projects included in the run-time to give in return. In addition, if you are a cash accounting to enter invoices, you should not run the return difference.

__________________
same day loans


Expert

Status: Offline
Posts: 1501
Date:

BackOfficeGroup wrote:

I think the IAB are wrong though to suggest that the VAT is deducted to the outputs and not the inputs.

HMRC says
If you are entitled to claim bad debt relief, you add the amount of VAT you are reclaiming to the amount of VAT you are reclaiming on your purchases (input tax) and put the total figure in Box 4 of your VAT return.

I would question it with your training provider as this is an important issue.....

P



But surely you are reducing the output VAT, you've made a sale (output) this has gone bad so reduce that amount so DR that figure by the VAT element of the bad debt. ................ or however you might want to do it because lets admit it they are only interested in final figures and they all work out the same in the end :)

 



__________________
Steve


Guru

Status: Offline
Posts: 1405
Date:

Hi there,

I agree with Philip. If I was using Sage I would remove the bad debt from the sales ledger by doing a credit note to the bad debt nominal code for the total amount with a T9 tax code and then do a journal to credit bad debt nominal with the amount of the VAT with a T9 code and debit Purchase tax control with a T1 tax code. That way it will pick it up in the VAT Return.

You can only claim the VAT back on a bad debt after 6 months, but if you know that it is definitely bad then you will want to remove it from the sales ledger straight away or it will make your debtors figure overstated.

Pauline

__________________

Pauline



Senior Member

Status: Offline
Posts: 384
Date:

As per HMRC http://www.hmrc.gov.uk/vat/managing/reclaiming/bad-debts.htm#1
If you are entitled to claim bad debt relief, you add the amount of VAT you are reclaiming to the amount of VAT you are reclaiming on your purchases (input tax) and put the total figure in Box 4 of your VAT Return.
I have always been informed you must show the full value in bad debts that is to be written off and then adjust out the VAT element you are reclaiming by journal. On completing the journal you will need to enter tax code T1 otherwise it will not show up on the VAT return.




__________________

 

Donna - Complete Book-Keeping Ltd & CBK Training - 07939 101900

Payroll & bookkeeping solutions.

www.completebookkeeping.co.uk / www.cbktrain.co.uk



Guru

Status: Offline
Posts: 1405
Date:

Donna, we are of the same mind smile.gif

Pauline

__________________

Pauline

Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  

BKN Special Offers

 

Resources

Careers & Qualifications  Start Up Essentials  Marketing Centre   Software Reviews
What is a book-keeper  Register as Self-Employed Networking  Software Blog
 Home Study Courses  Money Laundering Local Accountants  
 Qualifications/ Associations  Data Protection Direct Marketing  
 Franchises  Registering as an agent  Telemarketing  
 College / Night School  PI Insurance  Directories  
 Recruitment  Stationery  Google  
     Twitter  
     Volunteer Work  

 

 

 

 

 
 

 
   

 

Copy Right Bookcert Limited