Matching Payroll Transactions in the Bank Account

[Sam_R]

Hi @endtop,

Great to hear, thanks for letting us know. 

Do reach out if I can assist any further!

[VickyH]

Hi Stephen,

I had the same problem after MYOB updated the version. 

I checked your post and realised it is because the linked account setting in Payroll was automatically changed from our daily banking account to a new account "1-3000 Electronic Clearance Account". Then I changed the link back to "1-1000 daily bank account" and it does appear in the bank transactions to be matched.

However, I realised I used a silly method to correct the STP as I have 5 payruns outstanding to be matched. I reversed the 5 pay runs manually. BUT, just after I reversed all of them, I thought I should do a banking transaction to link 1-1000 to 1-3000, and it won't affect any STP.

Anyway, I updated here and hope more people can be benefit from my experiences.

Thank you all for the ideas provided.

Kind regards,

Vicky

[Felicity11]

Hi Sam, 

I have the exact same issue. It's only occurred since changing to the myob app this week. I've tried your instructions and a few others. But still not able to resolve the issue. Would you kindly be able to screengrab your instructions? 

The payroll has allocated to electronic and therefore not appearing at a match in the drop down when I try to reconcile as spent. 

[Felicity11]

I'm sorry I still can't get this to work and the payroll transaction doesn't have a matching option appear. 

Do you have any other suggestions. 

[Sam_R]

Hi @Felicity11,

Thanks for reaching out. 

If you open your employee card/s > Payment details > What it is the payment method selected here? If it is electronic, you will need to change it to 'Cheque' or 'Cash' to resolve this for future pay runs. 

If you need any further assistance with that, please do let me know. 

[Felicity11]

Thanks Sam, 

I've changed that now. Thanks. 

So should I delete the two pay runs that I can't seem to reconcile? 

Thanks

Felicity

[Sam_R]

Hi @Felicity11,

Yes, you can reverse/delete those pay runs and re-enter them. They will then be able to match as normal.

Do let me know if you have any further trouble with that. 

[Felicity11]

thank you. I'll try and confirm it's worked. 

[tamarandrea]

Hi!

Thank you for the solution. However, it's worth mentioning that you should download one single file per transaction. I had several payrun payments unmatched, I downloaded one single document for all of them, but Myob Essentials doesn't allow matching multiple payroll transactions to one Electronic Payment, so here I am stuck because the other "solution" provided by Myob is that I have to delete the electronic payment transactions, which I'm very relectutant to do, as I don't want to potentially create another problem.

I'd appreaciate if a better way to match the one single EP to the several payroll payments is provided.

Thank you,

Tamara

[tamarandrea]

Hi, community.

@Sam_R , I followed the steps as you said in this message. However, as I had several unmatched payroll transactions, I created one single EP and download it. However, when I go to "Bank Transactions", I can't match the individual transactions to the single EP I created.

I found "another" solution in another post that asks to:

1. delete the electronic payment transaction by going to Find transactions>>locate the electronic payment transaction>>click on the reference number to open>>click Delete
2. go to Prepare electronic payments>>tick one payroll transaction, enter the date of the payment and click on Download bank file. The Total payment amount needs to be the same as the bank feed transaction.

However, as it involves deleting something, I'm reluctant to do so.

Do you know another way for me to match several payroll payments to one single EP? Could I just allocate it to "Wages and salaries" or will it cause any internal mismatch between the payroll and the banking part?

Thank you,

Tamara