SageForum for UK versions of Sage 50- Help and support.

I have a cheque refund from a supplier who took a duplicate payment from us via DD.

However, they have given the refund less two invoices and a payment which we hadn't physically made.

I have entered the invoices plus a payment on account but how on earth do I do the refund?!

It is going to be made up of lots of different transaction types so I can't see how to do it!! I tried loads of different things like credit notes and dummy invoices etc

Thanks in advance for any replies

What do you mean by a payment you hadn't physically made?

Are you saying that they have incorrectly entered a payment against you account?

If so you need to advise them of their error, to take the payment made against your account would be theft.

Are you sure the payment is not a credit note they have correctly issued?

Hi Bruce

Thanks for the reply, sorry it has taken me so long to respond.

Basically, they sent us a statement showing how they had made the refund up.

On it was an invoice that they would have sent us eventually but instead have used it to make up our refund. If that makes sense?

So we haven't paid it ourselves but we would have done at some point.

Thanks
Emily

So the account has a negative balance for the amount you were refunded.


The solution depends on the Version of Sage 50 you are running.

Assuming you are NOT on VAT cash accounting

This is the more complicated older solution, new versions have a transaction fora supplier refund.


Raise a credit note to 9999 for the amount of the refund (T9)
Post the cheque received to 9999 (T9)

In the bank do a supplier payment for 0, match the credit items against the debit items.

easiest way is to post a bank receipt against suspense account (use T9), then raise a credit note on purchase ledger also against suspense accout( also using T9 so no effect on VAT). You will have the bank receipt for your bankrec, and you can also allocate the credit note agaisnt the purchase invoice(s) to tidy up the purchase ledger and the effect on p&l is nil.

Hope that helps

(oops -just repeated the earlier post - that'll teach me to read the replies before submitting one!)