Forum Discussion

NickyS1's avatar
NickyS1
Experienced User
3 years ago
Solved

Paid an employee with 2 payments - rerun doesn't record split payment transactions

Hi,

 

I did a payrun recently where one of the employees had an incorrect amount of tax withheld.  They are under 18 & should have had no tax deducted from their pay but I didn't notice this & paid them the net amount.  After finding my error I reversed their pay & reran it, setting the tax withheld amount to 0 & then paid them the balance they were owed.  During this 2nd payrun I forgot to set them up with a split pay so the transaction recorded had the full amount instead of the 2 amounts I actually paid.  So, as per instructions from similar posts, I reversed this again, set up the split payment & then reran the payrun.  When I downloaded the bank file (to record the payment transactions but not actually pay again), I could see the aba file had the 2 split payments.  However, when I went to match the first bank transaction amount, only the total amount (sum of the 2 split payments) was available for matching.  Any suggestions on how to get past this?

 

Thanks

 

Nicky

Payroll
  • LRBooks61's avatar
    LRBooks61
    3 years ago

    Hi again

     

    so you have the payrun in the bank in myob 

     

    I am assuming that this payrun transaction that  you have sitting in the bank account in MYOB reflects the correct payroll amount in total

     

    eg $2150 in total but the bank statement has two transactions eg $2000 and then the additional 150

     

    and to match the transaction seems impossible as there is only the one payroll but the two transactions 

     

    if that is correct I suggest

     

    match the payroll transaction with the first payment and on the right hand side you can do an adjustment ( in purple)

     

    allocate the difference to the payroll clearing account ( set this up if you need to)

     

     

    so you  match the $2000 payment in bank feeds with the payroll transaction and then add the adjustment as payroll clearing account with a minus $150

     

    then when the $150 needs to be allocated assign it to the payroll clearing account

     

    the myob payroll transaction is reconciled and the payroll clearing account cancels each other out

     

     

    hope that I have properly understood and this suggestion helps

     

    Lisa

     

7 Replies

Replies have been turned off for this discussion
  • LRBooks61's avatar
    LRBooks61
    Ultimate Cover User
    3 years ago

    Hi

     

    What you are trying to do is match 2 payments in the bank

     

    SO what you want to do is two separate aba files to be able to match

     

    So just delete the electronic payment with the two together and redo individually , then they will match

     

    Hope that helps

     

    Lisa

  • NickyS1's avatar
    NickyS1
    Experienced User
    3 years ago

    Hi LRBooks61 ,

     

    That would only work if the 2 amounts appeared in the 'Prepare electronic payments' list, or did I miss something?  Ony a single amount appears there so I don't have the option to download separate aba transactions.

     

    Please let me know if I've misunderstood your suggestion.

     

    Thanks

     

    Nicky

  • LRBooks61's avatar
    LRBooks61
    Ultimate Cover User
    3 years ago

    Hi

     

    what I mean is you have two withdrawals for payroll from your bank

    the first for the original payroll with the incorrect pay for $xxxx

    then you have another with the additional payment for the PAYG Of $XX

     

    so you should be preparing two aba files

     

    the original which will match the first payment 

    and the second should have the corrected pay of the underpayment, made up of the transaction you actually paid 

     

    I am not sure what you mean by the split payment , but if you reversed the pay and then redid with the correct amount then the reversal and the correct pay should equal the correction and you should be able to create an aba transaction in the bank for that and match your bank

    Hope that clarifies what I mean

     

    Lisa

  • NickyS1's avatar
    NickyS1
    Experienced User
    3 years ago

    Hi LRBooks61 ,

     

    I am using the newer version of MYOB Essentials.  The employee in question has already been set up to get the split payments to match what I paid them.  I already reversed the original pay run & reran another one.  When I went to the 'Prepare electronic payments' screen it should have had the 2 payments listed separately but it didn't - it only had the single figure for the full amount.  When I selected 'Download bank file' for that one & only 1 record, then a single aba file was created with 2 transactions.  However, the only available payment transaction I can match to in the 'Bank transactions' page is the single total payment that appeared in the 'Prepare electronic payments' screen.  So, what you have suggested has not been possible for me.

     

    Nicky

  • LRBooks61's avatar
    LRBooks61
    Ultimate Cover User
    3 years ago

    Hi again

     

    so you have the payrun in the bank in myob 

     

    I am assuming that this payrun transaction that  you have sitting in the bank account in MYOB reflects the correct payroll amount in total

     

    eg $2150 in total but the bank statement has two transactions eg $2000 and then the additional 150

     

    and to match the transaction seems impossible as there is only the one payroll but the two transactions 

     

    if that is correct I suggest

     

    match the payroll transaction with the first payment and on the right hand side you can do an adjustment ( in purple)

     

    allocate the difference to the payroll clearing account ( set this up if you need to)

     

     

    so you  match the $2000 payment in bank feeds with the payroll transaction and then add the adjustment as payroll clearing account with a minus $150

     

    then when the $150 needs to be allocated assign it to the payroll clearing account

     

    the myob payroll transaction is reconciled and the payroll clearing account cancels each other out

     

     

    hope that I have properly understood and this suggestion helps

     

    Lisa

     

  • NickyS1's avatar
    NickyS1
    Experienced User
    3 years ago

    Hi LRBooks61 ,

     

    Thanks for your patience on this one!  It had crossed my mind to try the adjustment you suggested when I first was trying to to the match but I wasn't sure what to do with the 2nd payment.  Your explanation for that part was the ticket!  The 2nd bank payment was reconciled via an allocation  to the payroll clearing account rather than trying to find any matching transaction.

     

    Thanks again,

     

    Nicky

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.