The Book-keepers Forum (BKF)

Post Info TOPIC: paymnen returned to current account


Newbie

Status: Offline
Posts: 3
Date:
paymnen returned to current account
Permalink Closed


Hi,

 

Having to teach myself sage and would like some advice on how to input a returned payment on sage.

 

I paid a contractor invoice in early feb however the payment was returned to current account for some reason so payment needs to be made again. So far on sage I have Debit and credit on the contractors customer account (original transaction).

However I need to record the returned payment, which will be a (Credit), then record the outgoing payment again (Debit). Do I just record these on his sage account but code T9?

Not sure which is the correct/best way.

Many thanks in advance for help.

 

cheers

sage newbie

 



__________________


Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

You have a few of choices, each with their own advantages/disadvantages.

The 'cleanest' approach is to go to the supplier ledger and in the task list on the left, select "supplier refund", and you'll get a window much like the one for entering supplier payments. You can enter the amount, but you won't be able to allocate it against the original payment (because that'll be allocated against the original invoice) - so when you save it, it'll be a supplier refund on account.

The advantages of this approach are that it's the simplest and cleanest (by cleanest, I mean it doesn't involve editing or deleting any original transactions), and that because the payment was returned to the bank account, it'll give you a payment and a receipt on your bank rec to match the original payment and its return. The disadvantage is that when you pay the supplier again, you'll be paying against a refund - which might look odd if you send remittance advices from Sage - and over time, when you look back, it might not be obvious what happened without looking in detail. (Especially since Sage gives you a default text for the refund).

The next best option would be to deallocate the original payment from the invoice. Strictly speaking, there isn't a way to do this - and it only works in some circumstances (IIRC it doesn't work if you are on a cash basis for the VAT). To do this, find the transaction number for the original payment. Go to file maintenance, find the transaction and double click on it for editing. Change the supplier account to another, and save it. Then double click on it again, and change the supplier account back to the original, and save it again. Now the payment and invoice are unallocated. Now go to supplier refunds as before, but this time you can allocate the refund to the original payment.

The advantages here are that, as before, you have a payment and a receipt on your bank rec to match the original payment and its return, and the original invoice now shows as outstanding for when you make a new payment. The disadvantages are that it means playing around in file maintenance (which I don't like telling people to do if it can be avoided) and it might not work depending on your VAT basis.

The next option would be to just delete the payment via file maintenance - the main advantage being that it leaves the original invoice outstanding, the disadvantage is that the transactions on Sage (and your bank rec) no longer correspond to the actual transactions on the statement.

Personally, I'd go for the middle option - deallocate the payment if possible, then show a refund - and if that doesn't work, just go for the first option.

(Thinking about it, if you go for the first option, you can always edit the detail shown on the refund via file maintenance to make it clearer what happened - but again, it means using file maintenance! Come on, Sage - give us the option of entering some detail with supplier and customer payments and refunds! How hard can it be to provide another field at the top of the screen, and just put your default text if it's blank?)

__________________

Vince M Hudd - Soft Rock Software

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

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