MYOB AUTO MATCHING INVOICES IN BANK FEED

[4Annette]

Hi

I am having trouble with payments in the bank feed being matched to invoices automatically by MYOB. 

In the match or allocate column it just shows 'matched to customer payment CRblah blah" from this I cannot tell that it has auto matched it. (Also the CRnumber tells me nothing.... how can a payment be matched to it's own payment number? Why display that info at all...the invoice number would be much more practical. )

The problem is that it is not matching them correctly.... I have clients payments against other clients invoices!

I have checked that I do not have rules that would do this and I cannot find a check box to stop this happening? 

I now have clients telling me they have paid an invoice that they could see as paid (although it was someone else's payment that MYOB auto allocated) 

This has already cost me hours to check out.... What is the solution please?

[HeaderTarps]

Hi, This is also happening to me. But further to this Myob is allocating payments (correct and incorrect amounts) to invoices that I have not received payments for. This is the latest in many frustrating problems I am having since the update.

[4Annette]

Yes, one of the many problems.....

[4Annette]

Further to this - I have unmatched one of the incorrectly auto matched payments in the bank feed and allocated it to the correct invoices. However the CRaction is still there, so it did not delete the payment to the wrong account.... I had to locate the payment and delete it manually....

[Tracey_H]

Hi @4Annette and @HeaderTarps 

If bank feed transactions are being matched to the wrong invoices you can turn this function off in Banking>>Bank rules>>Automatically match bank transactions to MYOB bills and invoices. You can also try refreshing the system by turning that function off and on again.

When a bank feed is matched with an open sale invoice the software automatically records the Create customer payment transaction, which applies the payment to the invoice. The CRxxxxx number that appears in the Match or Allocate column is the reference number for that Create customer payment transaction. You can view that transaction by clicking on the expand arrow and clicking on the purple reference number. The CRxxxxx number is displayed in Bank transactions because the bank feed is matched to the payment transaction, not the invoice.

Unmatching a bank feed transaction only removes the match, it doesn't delete the MYOB Essentials transaction. This is so that if you have recorded an MYOB Essentials transaction and matched it to the wrong bank feed, you can just unmatch the bank feed and rematch the transaction to the correct bank feed without having to re-enter the transaction.

Please let me know if you need further help.

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

[4Annette]

Yes but that then turns off all the ones that I want to apply.... so you are saying I can have none or have to put up with errors the program creates to be able to have useful ones.

I think we all understand what the CR number is.... however it shows as 'matached to CRnumber" but in reality the payment itself is the CR number and what it is being matched to is another action completely.... being the specific invoice or 'account'. In my uneducated opinion it should be kept behind the scenes and in the 'matched to' column it should show the 'action' the CRnumber was matched to.

Your reply states:

The CRxxxxx number is displayed in Bank transactions because the bank feed is matched to the payment transaction, not the invoice.

Could you explain where it is matched to the invoice then?

N.B- sentences below in italics are from your answer.

Unmatching a bank feed transaction only removes the match, So are your saying it delets the CR number?

, it doesn't delete the MYOB Essentials transaction. So how did the payment stay attached to the invoice if it's only the CR number that its matched to?

This is so that if you have recorded an MYOB Essentials transaction and matched it to the wrong bank feed, you can just unmatch the bank feed and rematch the transaction to the correct bank feed without having to re-enter the transaction.

1 I didn't match it.... it was auto matched.... 

2. If the transaction that was recorded, was recorded by matching an invoice to the bank feed item, then the transaction was recorded as a payment..... and if there isn't a invoice to allocate that payment to, after unmatching the wrong one,  then transaction/payment is still recorded and remained allocated to the wrong invoice.

There is a problem.... can you see it?

My problem was it didn't unattach/unmatch the incorrectly auto matched invoice and still showed as a payment there.

Please help this is driving me nuts.

[HeaderTarps]

If we can change all these thing around in MYOB (which is handy when you makle a mistake or choose the wrong bank account) why can't we change the Bank account chosen for a Super Payment? The payment came out of bank account No.2 which was correct but in Myob I mistakingly chose account No.1 and now MYOB is asking me to allocate it, but I can't. If I do it will upset my balances?

[Tracey_H]

Hi @4Annette 

Bank feeds is a tool to make reconciliation easier. The transactions in the Bank transactions window are the transactions brought into your file from your bank. They are matched to MYOB Essentials transactions which are automatically ticked in the Reconcile accounts window.

When you match a bank feed transaction with an invoice the payment transaction is automatically recorded. It is the payment transaction that is actually matched to the bank feed transaction as only the payment transaction is posted to the bank account and appears in Reconcile accounts to be reconciled. Invoices are posted to Accounts Receivable, the payment is applied to the invoice when the payment transaction is recorded.

When unmatching a bank transaction:

• if the bank transaction was matched to an open sale invoice the payment transaction is automatically deleted
• if the bank transaction was matched to a manually recorded payment transaction the payment transaction is not deleted

I have matched a bank transaction to an open invoice then unmatched. The Journal security audit report shows the payment transaction has been added when I matched the bank transaction. Then deleted when I unmatched:

I then recorded a Create invoice payment transaction, matched the payment to the bank transaction then unmatched it. The payment transaction hasn't been deleted:

Please let me know if you need further help.

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

[Tracey_H]

Hi @HeaderTarps 

If you have selected the wrong bank account when recording a payment you can record a Transfer money transaction. The From account is the account the funds are coming out of, the To account is the incorrect bank account. You can then match the Transfer money transaction to the bank transaction.

In your case, you want the withdrawal to appear in bank account No 2 so this would be the From account. The To account would be bank account No 1. 

Please let me know if you need further help.

[HeaderTarps]

Hi Tracey,

Thank you for your help, I really appreciate you getting back to my question. Yes that has worked.