Forum Discussion

megann's avatar
megann
Member
1 month ago

I have created the Group electronic payment and couldn't match it off in bank transaction

Hi, 

I have created an electronic group payment a couple weeks ago. The payment was made on difference date the electronic group payment was filed/ created. Normally it will auto match on the bank transaction but I understand if we made the payment difference day from the electronic payment was filed. We have to delete and recreate and put the same date as the payment date. I did that and tried to reconcile with the bank transaction. Unfortunately, after I matched and approve the transaction still there and not match with the new electronic group payment I was created.

3 Replies

  • Isaiah_C's avatar
    Isaiah_C
    MYOB Moderator
    1 month ago

    Hi megann,

     

    When an electronic group payment doesn't match, it's usually because MYOB treats it as one lump-sum transaction, while the bank feed might be showing it a bit differently. A couple of things worth checking:

     

    • Make sure the total amount of the group payment exactly matches the bank transaction.
    • Check the bank account used on the group payment is the same one the feed is coming into.
    • If you've already approved the bank transaction, it won't auto-match anymore in that case, you can undo the approval, then manually match it to the group payment.
    • If it's still won't play nice, the safest option is usually to allocate the bank transaction to the same clearing account the group payment used. That'll clear it out without duplicating anything.

     

    If you're still seeing odd behaviour after that, it might be worth jumping onto our live chat support through our virtual assistant, MOCA, or submit a case via My Account so the team can have a look at the backend and make sure nothing's stuck.

     

    Regards,

    Sai

  • megann's avatar
    megann
    Member
    1 month ago

    Thank you for your reply.

    It turned out that we did upload the electronic payment twice in 2 difference dates. The second payment was shown on the bank transaction which process a day after the electronic payment was processed but the first payment wasn't show on the bank transaction yet. So, I though it doesn't match or allow me to match if the electronic date not match with the payment date on bank transaction. So, I decided to delete the electronic payment and process it again and select the payment date that match the bank transaction but still doesn't allow me to match. The next day the 2 same electronic payment transactions has appeared in the bank feed. I redo the same process again and was able to match it off. And now I have one outstanding electronic payment in the bank feed that we double process the second time. How we treated this transaction if the second payment was a mistake and we will get refund from the supplier later.

     

    Thank you

  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator
    1 month ago

    Hi megann

     

    That second payment definitely makes things look a bit messy on your end, but we can tidy it up. The idea is to get the software to match what actually happened at the bank.

    Here’s the simplest way to treat it:

    • Keep the first payment matched to the bill; that’s the one that was correctly paid.
    • Treat the second (accidental) payment as an overpayment to the supplier, then match that to the extra bank feed line.
    • When the supplier’s refund comes through the bank, record it as a supplier refund and match that bank feed to it.

    That way, your bank account and the supplier balance both end up correct.

     

    Regards,

    Genreve