Unable to locate Payroll items to match in bank feeds

[Jacqui6]

Hi there,

I have ran a payroll which is showing correctly in the Pay Runs section.

It is also showing in the Banking > Find Transactions correctly. The dates and bank account selected are the usual accounts however I cannot find this transaction in the Bank Feeds to allow me to match the bank transaction too??

What could be causing this? I am having this problem for all 4 employees paid on that day and the Super file which was also paid on that day?

Every week I run payroll without an issue, all the transactions prior too (and after this particular run) have come through without an issue? How can i rectify this?

Thanks!

[MattHarv]

I am having the exact same problem. Could someone from MYOB kindly provide an answer to this? When I search the transaction I can see it is allocating to various accounts (electronic clearning account and PAYG withholding payable) however I am unable to find/ match the transaction (i.e. net pay amount) in the bank feed. Prior to the upgrade it used to do this automatically. Thanks, Matt

[Tracey_H · Accepted solution]

Hi @Jacqui6 

If the account selected in the Bank account field is the correct bank account, go to Reconcile accounts and make sure those pay transactions aren't ticked. If they are, untick them and they will appear to be matched in Bank transactions. 

If you continue to have problems with this can you send me screenshots of a pay transaction (click on the reference no in Find transactions to open the transaction) and the Bank transactions window. Make sure sensitive information is removed from screenshots before posting on the Forum.

Let me know how you go.

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

[Tracey_H]

Hi @MattHarv 

If your pay transactions have been allocated to the electronic clearing account you will need to record the electronic payment transaction in Banking>> Prepare electronic payments. This will move the amounts from the electronic clearing account to the bank account. You can then match the electronic payment transaction to the bank feed transaction.

Setting up electronic payments

Making electronic payments

Why are employee pays missing in bank reconciliation

Please let me know if you need further help.

[MattHarv]

Hi Tracey

Thanks for your help - however I have already paid my employee directly from my bank account (manual bank transfer) so I am worried if I process the electronic payments it will pay him twice? When I go to 'prepare electronic payments' as you noted below, the only option is to download the bank file. Is there a way to retrospectively change the payroll payment to cash instead of electronic payments (or any other work around) so that I can match it in the bank feed?

thanks

Matt

[Tracey_H]

Hi @MattHarv 

When you click on Download bank file two things happen:

1. the bank file is created and downloaded. The payment is not processed until you upload the bank file to your bank and authorise.
2. the electronic payment transaction is recorded which moves the amount from the electronic clearing account to the bank account

So you will need to click on Download bank file, just don't upload the file to your bank.

The only way to change the Payment method is to reverse and reprocess the pays. It will be much easier to process the electronic payment and match the electronic payment transaction to the bank feed 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.

[Skeggsy]

Hi Tracey

I am having the same issue as the two users above, I process pays through MYOB but payment of the acual pays is done via manual bank transfer.

I cannot reconcile the manual bank payments to the pay (which prior to upgrade used to be done automatically) nor can I download the bank file as the bank account the pay is coming from is not set up to create ABA bank files (I do not want to set it up, plus I can't as the bank account I use does not have a bank code or a direct entry user ID).

I am really confused as to what to do, advice on this would be greatly appreciated.

Thanks

Adele

Note - I have just found another post that indicates if paying this way (via EFT) I need to have the employee payment method set as cash (which I did not, I had it as electronic - as you would considering I am paying via EFT?? very confusing).  Anyway I guess my question now is if I change the payment method to cash how do I allocate the previous pays that are sitting in the bank feed waiting to be allocated????

[Tracey_H]

Hi @Skeggsy 

You will need to process the Prepare electronic payment transaction to move the amount from the electronic clearing account to the bank account. You can then match the electronic payment transaction to the bank feed transaction. 

You will need to set up the bank account for electronic payments, the Bank code is the 3 letter abbreviation for your bank, eg NAB, CBA, ANZ. If you're not going to upload the bank file to your bank for payment, enter 000000 as the Direct entry user ID.

The Payment method in the employee card relates to how the software will handle the payment. If you select Electronic, the net amount is posted to the electronic clearing account so that you can create an ABA file. 

For future pays, if you don't want to use a bank file to pay employees change their Payment method to cash then go to Accounting>>Manage linked accounts>>Payroll tab and make sure the account selected for Bank account for cash payments is the correct bank account. The net amount will be posted to that bank account.

Please let me know if you need further help.

[Skeggsy]

All rectified, thank you so much for the advice!

[cel_at_tsgaust]

Hi

I have experienced the same problem. When I processed payrol, only 1 of my 8 employees is visible in Bank Transactions to match with the Withdrwals that have linked from my bank account. As you suggested I have:

 - reviewed the payment method and all employee payments are alocated as Cheque

 - reviewed Reconcile Accounts to see if the transactions are ticked and they are not

 - reviewed the Manage Linked Accounts and confirm that the payrol payments were being posted to the bank account, not the electronic clearing account

Can you please assit in how to find the payrol transaction so that I may match them to the bank withdrawls.

Regards

Cel