Forum Discussion

AlexBaxter27's avatar
20 days ago

Online payment already applied to invoice but bank feed deposit won’t reconcile (creates duplicate payment)

Hi, I’m stuck on a reconciliation issue in MYOB and can’t get past it.

 

I have an invoice (SBA08) that was paid via MYOB online payments. The invoice is already marked as paid with reference CR000449 (“Online payment”).

Then the actual bank deposit came through the next day in my NAB bank feed for $1,936.00 with the description “MYOB010000 MYOB PAYBY XXXXXXX”.

The problem is:

  • The invoice is already closed from the online payment
  • If I try to match the bank transaction to the invoice, it creates a second payment and puts the invoice into credit
  • I can’t edit or delete the original payment (CR000449)

I can also see the transaction under Online Payments with reference MYOB010000, so everything seems to exist, but I just can’t reconcile the bank feed properly.

 

It feels like the bank deposit isn’t linking to the original online payment correctly.

Can you please help me fix this so the bank transaction can be reconciled without duplicating the payment on the invoice?

4 Replies

  • JuliaE's avatar
    JuliaE
    Cover User
    6 days ago

    Hi Alex,

    I have just gone through similar with MYOB Support and for my issue MYOB did not create the offsetting entry to match to the bank feed deposit due to an issue with the bank account not being updated. If you are just starting out using online payments or have changed bank accounts you need to go to settings (COG icon at top of right ribbon), then select Payments. Under online payments select edit preferences which takes you to an online payments screen. In here on the setting tab make sure your settlement bank account is setup correctly as well as the transaction categories. We had changed bank account over a year ago then had a customer wanting to pay online so we manually select online payments for them but hadn't realised there was a separate area to update the settlement bank account and the old bank account details were still showing. In the interim the payments went through, but we think this is why the MYOB offsetting entry was missing and therefore not matching to the bank feed payment. In the end, we allocated the bank feed payment to Accounts Receivable as this does not affect any other reporting or taxation and is not a reconciled account. We are hoping the next payment flows through correctly! Hopefully this may be of some help as it took weeks for support to contact us.

  • AlexBaxter27's avatar
    AlexBaxter27
    Member
    10 days ago

    Hi, thanks for the explanation.

    I understand the Undeposited Funds flow, but my issue is different.

    I cannot find or match the transfer transaction from Undeposited Funds to my bank account for this payment.

    • Invoice SBA08 is closed (CR000449)
    • Bank feed deposit for $1,936 is sitting unmatched
    • Matching it to the invoice creates a duplicate payment
    • I cannot find any corresponding transfer/deposit transaction to match it to

    Because of this, the amount is affecting my BAS incorrectly.

    Can you please check whether the settlement/transfer transaction for MYOB010000 is missing, hidden, or corrupted and help fix it so I can reconcile it properly?

    This is blocking me from lodging my BAS.

  • JuliaE's avatar
    JuliaE
    Cover User
    14 days ago

    Hi Doreen

     

    I am having this same issue. There is no automatic matching of the bank feed transactions to the transfer from Undeposited Funds. I have checked all the reasons for why as you have suggested above but everything is set up properly. I wouldn't think MYOB would generate the required auto matching entry if the transactions have already taken place even if there was an incorrect setting. How do I correct this manually to allocate the bank feed transactions?

    Thanks

    Julia

     

  • Doreen_P's avatar
    Doreen_P
    MYOB Moderator
    19 days ago

    Hi AlexBaxter27,

     

    Online payments will always throw up two transactions. One lands the money into Undeposited Funds, then another moves it from Undeposited Funds into your bank account, so it looks a bit “double” in the history even though it’s just one payment doing a lap. You don’t need to match the bank feed to the invoice again. You only want to match that feed line to the transfer from Undeposited Funds to the bank. If it’s still not auto matching, we’ve got a handy link you can run through, especially the “What can prevent automatic matching” section to see what’s blocking it. If you're still having issues with the payment, you can reach out to our team on Live Chat via our virtual assistant, MOCA, or by submitting a support case via My Account. This way, they’ll be able to check what’s causing the payment not to link.

     

    Cheers,

    Doreen

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.