The Book-keepers Forum (BKF)

Post Info TOPIC: write off a bad debt in sage instant accounts


Veteran Member

Status: Offline
Posts: 44
Date:
write off a bad debt in sage instant accounts
Permalink Closed


Hi

I'm wanting to write off a bad debt in sage instant accounts - it was a bankruptcy case and we never got paid out - the debt consists of 5 invoices going back to January 2013.

Could anyone please advise of the correct way to write off this debt so as to enable me to claim back the VAT

thanks

Sue



__________________


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Ive got one to do for a company - my thinking was raise a Credit note to customer account but code it to a bad debt account. The CN will allocate the VAT then to the VAT control.

Will stand to be corrected though is this is incorrect!

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Senior Member

Status: Offline
Posts: 259
Date:
Permalink Closed

Hi Sue,

I'm afraid the official line is not as simple as that! See https://www.gov.uk/government/publications/vat-notice-70018-relief-from-vat-on-bad-debts/vat-notice-70018-relief-from-vat-on-bad-debts

Regards,



__________________

Ian

Ian Brown FCA
Onion Reporting Software Ltd

www.onionrs.co.uk

Sage accounts in Excel. No set-up necessary. Free 30 day trial.



Expert

Status: Offline
Posts: 1609
Date:
Permalink Closed

I'm not really sure but a lot of people will tell you to credit the amount to 8100 or wherever you bad debt nominal is, and to be fair it is what I have done in the past as the "wizard" just posts a credit to 8100 as a gross amount, and a T9 vat code.

One problem I see with this, ( and as usual I could be completely wrong), is that on the VAT return bad debt relief shouldn't be a reduction in output vat (box 1) which just posting a credit will do, but an increase in input vat (box 4). So if you use the wizard then it will credit the amount and put the gross to 8100 as a t9 and then you have to manually adjust your vat return box 4 for the reclaimed vat. It also helps to keep a record of vat reclaimed as it is singled out in your adjustment printout when you run your vat return.

 

 



-- Edited by Rhianrach on Thursday 29th of January 2015 04:39:39 PM

__________________
Steve


Senior Member

Status: Offline
Posts: 259
Date:
Permalink Closed

Excerpt below:

5.6 Can I issue a Credit note instead of claiming relief?
No. You may not issue a credit note simply because your customer has not paid you for your supply. You may only issue a credit note where there is a genuine mistake or overcharge or an agreed reduction in the value of your supply.

__________________

Ian

Ian Brown FCA
Onion Reporting Software Ltd

www.onionrs.co.uk

Sage accounts in Excel. No set-up necessary. Free 30 day trial.



Senior Member

Status: Offline
Posts: 141
Date:
Permalink Closed

There is no difference in the amount of VAT the Vat man gets.

I would not expect a VAT Inspection to penalise you for it.
You should always protect yourself at the start of any VAT Inspection by declaring all the things you are unsure of that may be mis-declarations and that way you will at worst not have additional penalties.






__________________

For just about anything Sage :- switch to renting, pay-as-you-go sage support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me.

Image



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Onion4Sage wrote:

Excerpt below:

5.6 Can I issue a Credit note instead of claiming relief?
No. You may not issue a credit note simply because your customer has not paid you for your supply. You may only issue a credit note where there is a genuine mistake or overcharge or an agreed reduction in the value of your supply.


Sorry for any confusion - I was just answering the specific question around how to deal with it in the Sage software, although I was unaware there was a wizard available.  My thinking - the Credit note would clear the customer's account and then drop the relevant amount of VAT into box 1 on the return (which is what I understand the link is saying at section 3.15! Or have I missed something else re box 4?).  

I certainly didnt mean for a credit note to be 'issued' to the client.



__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

Transactionally, "raising" a credit note with the correct coding is exactly what the wizard does, AFAICR - it amounts to the same thing, so doing the same thing yourself is fine.

What the HMRC guidance is telling you not to do is raise a credit note in the sense of it being sent to the customer - so your advice is fine, Joanne.

(Back when the rule was that you had to send the customer a notification, I used to raise a credit note, but the credit note that was actually printed and sent was the notification itself. Two birds, one stone.)

__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Expert

Status: Offline
Posts: 1609
Date:
Permalink Closed

Sage advise you to use the wizard and apply the reclaimed vat to box 4 and not box 1. It raising a credit as per advice but it credits the gross amount as a out of scope, you then should apply an adjustment to box 4 ............. according to sage. However as mentioned it all works out the same for the vat man :)

__________________
Steve


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Thanks for the clarification guys. Will have a look at the wizard.

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Senior Member

Status: Offline
Posts: 259
Date:
Permalink Closed

Joanne,

Don't worry, I hadn't taken it as that. In hindsight, the excerpt wasn't helpful. 

This would have been a better one:

2.4 How do I claim bad debt relief?
To claim a refund you should include the amount of the VAT you are claiming in Box 4 of your VAT return which covers the date when you fulfil the conditions to make a claim.

This is where Bruce's point is well made. I'd think you'd get a sympathetic ear from HMRC if you comply with the all the conditions laid out except for putting the VAT in Box 1 instead of Box 4. Steve's post is on point about Box 4.

I hope this helps.

 



__________________

Ian

Ian Brown FCA
Onion Reporting Software Ltd

www.onionrs.co.uk

Sage accounts in Excel. No set-up necessary. Free 30 day trial.



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Ah, I clearly rushed passed that bit(!) just had another look. Thanks Ian. Hope that's helps you too Sue.

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

Ah, oh, yes, well, er... it seems I remember wrongly about what the wizard does, then, and I hadn't picked up on the box 1 vs box 4 point. I've tended to use the credit approach.

Oops.

I have now duly slapped my own wrist, and will use the wizard in future. ;)


__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Senior Member

Status: Offline
Posts: 259
Date:
Permalink Closed

So, the official Sage recommendation to write off a £100 sale + £20 VAT to customer Brown is a credit transaction (either manually or using the wizard)

A/CDateRefN/CDetailsNetT/CVAT
BROWNWrite off dateBADDBT8100Bad Debt Write Off120.00T90.00

i.e. Dr 8100 Bad Debt Write Off £120, Cr 1100 Debtors Control Account £120

followed by a journal to get the £20 into Box 4

N/CNameDetailsT/CDebitCredit
2201Purchase Tax Control AccountBad Debt ReliefT120.000.00
8100Bad Debt Write OffBad Debt ReliefT90.0020.00


__________________

Ian

Ian Brown FCA
Onion Reporting Software Ltd

www.onionrs.co.uk

Sage accounts in Excel. No set-up necessary. Free 30 day trial.



Expert

Status: Offline
Posts: 1609
Date:
Permalink Closed

I was just about to post the same as funnily enough I have just had to write off an amount. My apologies as I had forgotten about the journal last night, as I had previously just made an adjustment in the VAT return :)

__________________
Steve


Veteran Member

Status: Offline
Posts: 44
Date:
Permalink Closed

Hi thanks for all the help
regards Sue

__________________


Veteran Member

Status: Offline
Posts: 44
Date:
Permalink Closed

thanks again for all your replies - I've finally got round to having a go at this and it was all going well until I realised the customer account in question on which I'm trying to reclaim the vat has along with all the outstanding invoices on the account a credit note - can anyone advise how I take this into account when posting my journal

many thanks
sue

__________________


Veteran Member

Status: Offline
Posts: 44
Date:
Permalink Closed

If I haven't explained myself correctly I am trying to claim back £487.00 vat which is made up of 6 invoices and one credit note

Sue

__________________


Expert

Status: Offline
Posts: 1609
Date:
Permalink Closed

If you have an un-allocated credit on the account then you need to allocate it. Go to bank, any account, customer receipt, enter the customer and pay in full the credit then allocate the same amount to the invoice it refers to and you should have a zero balance at the bottom, click save and the credit has then been allocated. Proceed with bad debt write off and journal out the vat from the bad debt account and you should be good to go.

__________________
Steve


Veteran Member

Status: Offline
Posts: 44
Date:
Permalink Closed

thanks very much steve

__________________
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  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About