Forum Discussion

Melanie75's avatar
Melanie75
Experienced Cover User
3 years ago
Solved

Matching multiple payroll entries to one bank transaction

Hello,

 

I cannot match my individual payroll entries to the bank transaction.

 

I have attempted all of the solutions in the forum, e.g find transactions, locate pay, check electronic payment account etc.

 

The total amount appears in my bank rec but I cannot tick off the individual employee payments.

 

Is somebody availble to help? I have screenshots ready to submit.

  • Tracey_H's avatar
    Tracey_H
    3 years ago

    Hi Melanie75 

     

    When an employee's pay is split between bank accounts you would need to pay that employee electronically using an ABA file. This Help Article, Split a pay between accounts, has detailed information on this for future pay runs.

     

    For pays that have been transferred as two separate payments you would need to reverse the original pay transaction and process as two separate pays with the net amounts matching the transfer amount. You can then match bank feed transactions with the pay transactions.

     

    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.

7 Replies

Replies have been turned off for this discussion
  • Tracey_H's avatar
    Tracey_H
    Former Staff
    3 years ago

    Hi Melanie75 

     

    When an employee's pay is split between bank accounts you would need to pay that employee electronically using an ABA file. This Help Article, Split a pay between accounts, has detailed information on this for future pay runs.

     

    For pays that have been transferred as two separate payments you would need to reverse the original pay transaction and process as two separate pays with the net amounts matching the transfer amount. You can then match bank feed transactions with the pay transactions.

     

    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.

  • Hi Melanie75 

     

    Thanks for your post. If the pay transactions have been posted to the correct bank account, go to Reconcile accounts and make sure they are not ticked in that window. If they are, untick them then go back to Bank transactions and they will appear for matching.

     

    If you continue to have problems please do send those screenshots of the Bank transactions window and a pay transaction. Make sure sensitive information is removed from screenshots prior to 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.

  • Melanie75's avatar
    Melanie75
    Experienced Cover User
    3 years ago

    Hi Tracey,

     

    Thank you for your suggestions - they helped me to solve initial query. Now I cannot match a pay for my only employee who has his pay split between two accounts.

     

    In the bank feed I can see the two payments of $500.00 + $686.94

     

    When I click 'match transaction' the drop down menu only shows the total of $1,186.94

     

    The employee is definitely set up to have pay split between two accounts

     

    I have reversed this pay and re-entered 4 times already in an attempt to rectify, so I am reluctant to reverse it again.

     

    Can you offer any solution for this? 

     

    Kind regards,

     

    Melanie 

  • LisaC123's avatar
    LisaC123
    Cover User
    3 years ago

    "For pays that have been transferred as two separate payments you would need to reverse the original pay transaction and process as two separate pays with the net amounts matching the transfer amount. You can then match bank feed transactions with the pay transactions."

     

    Why has this changed?? It use to be so easy before the latest version. I will be changing accounting software because of this.

  • Shella_A's avatar
    Shella_A
    MYOB Moderator
    3 years ago

    Hi LisaC123 

     

    Thank you for your post. Yes, as our previous moderator Tracey mentioned, it needs to be reversed if two payments have been made and just process one pay run. It should be two separate payments and two separate pay runs so that it would be easy to reconcile and match bank feed transactions. 

     

    You may have a look at this help article: Fixing a Pay that has all the detailed information and steps regarding with this. 

     

    If you need further help, don't hesitate to start a new post and we'll be happy to assist.

     

     

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

     

    Cheers,

    Shella_A

  • LisaC123's avatar
    LisaC123
    Cover User
    3 years ago

    Hi Shella_A 

     

    Thanks for your responce. How does the go with PAYG?

     

    If you do a seperate run with only the overtime then its likley they will end up not withholding enough tax.

     

     

  • Shella_A's avatar
    Shella_A
    MYOB Moderator
    2 years ago

    Hi LisaC123 

     

    Thank you for your response. Overtime pay should be included when processing pay run as it should calculate PAYG, you would need to reverse the pay run, then reprocess the pay run with the overtime hours to calculate the correct PAYG amount. 

     

    You might want to look at this Help Article: Reverse and Reprocess pay run that has all the detailed information and steps to assist you with this. 

     

    If you need further help, don't hesitate to start a new post and we'll be happy to assist.

     

     

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

     

     

    Cheers,

    Shella_A