Entering cheque from customer and account for their overpayment

SOLVED

The last cheque I received from a client was actually made out for for $23.10 more than what was owed, i.e. this was a case of a customer overpaying.

With that, I recorded the overpayment as per the instructions in Sage50.

I have now received the next cheque from the same customer, and the cheque is for the full amount accommodating the over payment, what I'm unclear about is how to enter this into Sage50.

Am I on the right track with:

  • 0
    verified answer
    Do you mean they paid off their account in full and deducted the over payment? If they really paid in your example, the $87291.32 then click beside the Deposit amount in the Amount Received column to indicate you wish to include that Deposit in the entry just like you did with the invoices. Don't use the Deposit box at the bottom with the negative because the program will not know which deposit you are applying it to.

    Personally I just get to the date field and make sure it's correct then hold down the tab key until the total is correct or start with the first invoice and hold down the down arrow key until I am done.
  • 0 in reply to Richard S. Ridings
    Hi Richard,

    My bad! I thought I had tried clicking in the column under Amount Received as you suggested, but it turns out I was clicking Amount Received in a row not down far enough to be across from the $23.10.

    So now I've clicked under Amount Received correctly across from the $23.10 and it's all adding up to the the correct amount as per the cheque I received from the client, i.e. the $87,291.32 ... and, I no longer have an amount entered into the "Deposit Amount" input box.

    Thanks for pointing me in the right direction!! A silly mistake on my part. :)

    Cheers,
    Kristine
  • 0
    Assuming that the 2nd chq was actually $87,291.32 (i.e. they noticed their previous overpayment and corrected this payment), then you are almost but not quite right with your entry above.

    From your previous entry, you have an unapplied $23.10 overpayment (shown as the red lines in the list of outstanding invoices in your screen shot. Every time you make an entry in the Deposit Amount box, you are creating a new unapplied line in this red section.

    Your entry as you have shown it will create a negative 23.10 unapplied overpayment. This will fully offset the existing positive 23.10 unapplied overpayment, so your overall result will be right - but sloppy. The two unapplied amounts will carry on as unapplied forever, or until you manually 'explain' to Sage that they actually cancel each other out.

    What you want to do is delete the -23.10 from the Deposit Amount box in this second entry, and instead click next to the red 23.10 in the list-of-invoices section to indicate that the customer has used up the prior overpayment. You'll know you have it right when you have -23.10 in the amount received column in the body of the invoice, nothing in the Deposit Amount box, and the total at the bottom is once again correct.