Hi Andrewtao
Looking at the screenshots provided, you have recorded 1-1000 as the account on the Electronic Payment, but the bank account you are reconciling is 1-1100.
If the latter is the correct bank account then you would need to reverse and recreate the bank file with the correct bank account entered in the Pay From Account field.
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.
Hi Samara,
Thank you for your advice.
The product I'm using is "MYOB Essentials Accounting Starter". But the link for " reverse and recreate the bank file " you posted is for "AccountRight". So I can't find the menu item it mentioned in my version. Do you have the instruction for my version?
Thanks.
Hi all
ASanders0210 - By default, when a file is upgraded, if your employee had banking information in the Original MYOB Essentials, their Payment method will be set to Electronic. This can be changed under; the Payroll menu > Employees > employee Payment details tab.
Andrewtao - My apologies, here are the same instructions for Essentials: How do I recreate a bank file?
SamaraM Hi Samara,
Since the electronic payroll payment always auto-linked to back account 1-1000, I inactivated 1-1000 and reversed the payroll run and re-did it. After downloaded the bank file, I went to the bank transactions list and checked. Guess what? The payroll bank transaction found a possible match. I opened up, it was the electronic payment I've just done. I ticked the box and saved it. The issue solved!
Conclusion:
As you pointed out, the payroll run I've done before linked to a wrong bank account for some unknown reason and that's why automatch failed. After I inactivated the wrong bank account, it operated back to normal. I still have no idea why this would happen. But anyway, the issue solved. Hope this could help other users who are also stuck in with this automatch issue.
Hi Samara,
I think you are right, the reason why MYOB can't automatch the bank transaction to payroll record is that the back transactions are under "Accout 1-1100" while payrolls are undet "Account 1-1000". So I checked details of "Account 1-1000" and "Account 1-1100" and found that under both accounts, the box: "I create ABA bank files for this account" was ticked. As "1-1100" is my main bank account and "1-1000" is barely used, I unticked the box in "1-1000", but kept the box under "1-1100" ticked. Now I assumed that the electronic payment would go through "Account 1-1100"
Then I reversed the two payroll runs and re-did one of the pay run (new reference number 946) and followed the instruction tried to download bank file. But unfortunately, unlike the previous reference number 944, there was no link at the left bottom like "Electronic payment recorded Reference number EP000001". Please refer to the screen shots below. It looked like no electronic payment recorded and no bank file was generated. I guess the payroll electronic payment still linked to "Account 1-1000" and as the electronic payment information was missing in this account, so the electronic payment was not recorded. Do you know how to re-link it to the account I want ("1-1100")?
