Bank feed transactions not linking to payroll items

Question

Hi there,&nbsp;&nbsp;I'm needing help. My wage payments in my payslips aren't matching the payments in the past payruns reports and therefore aren't showing up with possible matches in my bank feed. Also, some are being automatically linked to transactions for other staff members with the same net payment. Please help asap so I can lodge BAS asap. I have screenshots ready to send through.&nbsp;&nbsp;Thanks,&nbsp;D

tracey_h · Accepted Answer

Hi&nbsp;DanaeB&nbsp;
&nbsp;
When you record an electronic payment transaction all transactions selected in that window are included in one lump sum EP transaction. As the bank feed transactions are for individual transfers you can't match them to one bulk EP transaction.
&nbsp;
You will need to delete the electronic payment transactions and reprocess them separately by selecting one pay transaction then clicking on Download bank file. The Total payment amount needs to be the same as the bank feed transaction amount:
&nbsp;

&nbsp;
&nbsp;
You can then match each individual electronic payment transaction to the individual bank feed transactions.
&nbsp;
Please let me know if you need further help.
&nbsp;
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

danaeb · Answer

Thanks Tracey.&nbsp;&nbsp;I was hoping there was a more time efficient way.&nbsp;&nbsp;Thanks for your prompt reply

tracey_h · Answer

Hi&nbsp;DanaeB&nbsp;
&nbsp;
If your employee's Payment method was Electronic in the original MYOB Essentials platform, pay transactions in the newer platform are posted to the electronic clearing account. This is because we've added the ability to pay suppliers electronically so the process for electronic payments has changed.
&nbsp;
If pay transactions aren't appearing to be matched in Bank transactions the first thing to check is the Account selected in the Bank account field. To check that account go to Banking&gt;&gt;Find transactions&gt;&gt;locate a pay transaction and click on the reference no to open.&nbsp;
&nbsp;

&nbsp;
If the account is the electronic clearing account you will need to set up and process the electronic payment. This will record an electronic payment transaction which moves 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 do not need to upload the bank file to your bank if wages have already been paid.
&nbsp;
Setting up electronic payments
Making electronic payments
Why are employee pays missing in bank reconciliation
&nbsp;
If the account is a different account or the bank account please send me screenshots so that I can assist further. Make sure sensitive information is removed from screenshots prior to posting on the Forum.
&nbsp;
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

danaeb · Answer

Hi Tracey,&nbsp;&nbsp;Thank you for your reply.&nbsp;&nbsp;I have set everything up as you directed.&nbsp;&nbsp;The electronic payments are now not linking to the payroll payments. Please see attached photos.&nbsp;When I try to match the wage payment in the transaction feed to the electronic payment, it won't allocate it as it is an unbalanced transaction. Is there a way to match all the wage payments from that date to the electronic payment?&nbsp;Please help.&nbsp;&nbsp;Thanks,&nbsp;&nbsp;Danae

Forum Discussion

Bank feed transactions not linking to payroll items

4 Replies

Related content

Payroll bank fee transactions not automatically matching to payroll details

Can't link a document to a recurring bill transaction

BAS link

Linked account for tax

Duplicate Payroll Transaction

Matching Payroll Transactions in the Bank Account

Linking receipts in my intray to match the bank transaction

linking a bank account