Trouble matching payroll to bank feed.

[benp]

Hi.

Im having a little trouble matching payroll with the bankfeeds in the updated essentials. Im fairly certain where ive gone wrong but not sure to rectify it.

Ive set up employees to be paid electronically, downloaded the bank file as a whole pay run rather than as indavidial pay amounts. Thats where ive gone wrong. So I now have the issue of the bank file amounts not matching the bank feed. 

Any help on how to fix this?

[Tracey_H]

Hi @benp 

Thanks for your post. If the employee's pays are showing as individual transactions in the Bank transactions window you would need to process individual electronic payments for each pay transaction. The Total payment amount in Prepare electronic payments window needs to be the amount of the actual withdrawal. In this situation you would need to delete the electronic payment transaction and reprocess each pay transaction separately.

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.

[Princess_R]

Hi @KathyAEP 

Thank you for your post. 

To work out why your pay transactions are not appearing for matching bank transactions, the first thing I would check is the payment method of your employees. Check if it is electronic payments and go to the actual pay transaction to check the account. Go to Banking >> Find transactions >> transactions tab >> Source Journal: Payroll >> click on the reference no. to open the transaction and check the Account selected.

If the account is electronic clearing account you'll need to go Banking >>Prepare electronic payments >> enter the date payment >> tick the pay transaction and click on Download bank file. You can then go to Bank transactions and match the bank feeds with the electronic payment transaction. You don't need to upload the bank file to your bank as payment was been made manually.

Additionally, I would recommend speaking to your accountant in regards to the double entries in the wages report.

For more information, our Help articles has detailed instruction to assist with this.

• Prepare electronic payments

Please let me know how you go about this.

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

Cheers,

Princess