Please needing help to post a refund correctly

SOLVED

Hello - Since this morning (over 6 hours ago) I've been trying to process/post an eTranfer (refund) to a client without affecting AR or AP or any other GL acount for that matter. I would still to need to reconcile the actual bank accout statement, exact as in Sage -  I need to have both identical.
The issue is, this X amount supposedly been posted twice within the past fiscal year in Sage. The owner did an eTranfer refund (manually/physically) for one of the two payments which is fine. I do need to post this transaction in Sage as well.

Thank you kindly for sharing your insight.

I posted this post elsewhere within this forum, but I couldn't find it again, also I wasn't sure if I posted in the correct section.

  • +1
    verified answer

    hmmm - I will give this a try. I am assuming the X amount was paid twice to same client. What I am not sure is if the 2nd payment was also posted in Sage. If not then what should have happened is the 2nd X amount is posted to the same client but as an overpayment. Then this will show up twice in the bank account. Now an e-Transfer was done to return the overpayment back to the client so this is posted as a refund back to same client. This results in showing all GL as an overpayment and again as a refund amount. Now you can reconcile the bank account, the GL affecting the client will show one payment made since the second payment is now cleared out by the e-transfer refund.