Forum Discussion

NickyS1's avatar
NickyS1
Experienced User
3 years ago

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...
bank transaction matching
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

     

NickyS1's avatar
NickyS1
Experienced User

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.

 

Related content