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

     

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

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