Forum Discussion

RUNCO's avatar
RUNCO
Experienced User
9 months ago

Payroll double up since move to new Business pro

I have recently discovered that since the move of accounting programmes back in Nov last year ( NZ) that my employee profile's had been checked as bank file ( I did not previously have this checked) which resulted in all my employee wages being coded to an electonric clearing account. I pay my employees manualy via bank transfer after submiting their pay via myob payroll. Then in the bank feed I code them as expense wages account. ( just a side note that one of my employess is paid into 2 bank acounts, this new pay roll does not record this so I manually alocate his pay to the correct wages expense account, ie this is not able to be matched) This was all working fine prior to the change over.

I called the help line to ask why this had happened and how to get rid of the wages appearing in my electronic clearing account. After a 3 hour phone conversation with a payroll advisor she has journaled this figure (as a wages total)  from the electronic cleaing account to my wages expense account. This issue I have now is that the figure includes amounts from prior to my last bank reconciliation done 31 jan. I am Trying to do a bank reconciliation for end of Feb and I am now out by this amount of the journal. 

 My second question and going forward she said I would need to code the wages into the clearing account (from the bank feed instead of to wages expense account) then journal them each time back to the wages expense account. My wages I processed  a couple of days ago show me that trying to code them the old way ( via bank transacations) is causing me a double up when I do a bank recon.

She has not explained why this has happened, to be honest journaling each employees wages is double handling for me and not ideal. ( Here is my case no from the phone call 01623810 - Trish).

 

I would appreciate advice as how to fix this journal amount that is now causing my bank recon not to match. And for future payroll what is the correct process ( ie hopefully without having to create a journal each time).

  • jenniek's avatar
    jenniek
    Ultimate Partner

    Hi RUNCO 

    Have you checked the linked accounts are correct since the change were done. In MYOB Business go to Accounting - Manage linked accounts and check the payroll links.

    • RUNCO's avatar
      RUNCO
      Experienced User

      Thanks, the payroll linked accounts are correctly set up.

      • RUNCO's avatar
        RUNCO
        Experienced User

        I still don't have a resolution to this issue. My end of financial year is 31 March and I will like to have this resolved asap.

  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator

    Hi RUNCO

     

    Thanks for the post. I apologize for the delay in attending to your thread. 

     

    From my understanding, the most effective method to remove transactions from the 'Prepare Electronic Payment' window is to process them as an electronic payment within the same window. This action will function similarly to a transfer, moving funds from an electronic clearing account to your chosen bank account. However, it's important to process the transactions in batches that align with the dates and amounts of the bank feed transactions to ensure automatic matching.

     

    Regarding the payroll specialist's advice about coding the transactions to the electronic clearing account, the article 'Split a Pay Between Accounts' can provide further clarity. This process involves temporarily setting up a split pay in the employee contact, recording the pay as usual, and then removing the split settings in the employee contact. This will result in two payroll amounts ready to be matched to bank transactions.

     

    If you need more assistance, please provide us with more details about your concern. In the meantime, feel free to create a new thread if you need help with anything else.

     

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

     

    Thanks,
    Genreve

    • RUNCO's avatar
      RUNCO
      Experienced User

      Hi, the advice here https://www.myob.com/au/support/myob-business/payroll/add-an-employee/myob-business-payroll-split-a-pay-between-accounts

      To  split a pay and pay electronicaly, this advice does not match what is showing on my screen. Under employment > bank account there is only a box to check saying "Pay via electronic payments (bank file)" 

      There is no option to " 

      1. Set the Payment method to Electronic." Just a side note my bank dosent let me use a csv file or bank file.I still dont understand how preparing and electronic payment replaces my method of entering the info via payroll which deducts the paye, kiwisaver, annual leave etc. Does paying via electronic payments replace the payroll function?

  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator

    Hi RUNCO

     

    I appreciate your response and apologize for any confusion. The option to split payments, as mentioned in the article, is currently only available for MYOB Business AU. Therefore, the specialist suggested a workaround for MYOB Business NZ.

     

    If you need to record payments in separate bank accounts in NZ Business, the recommended method is to utilize the electronic clearing account as a temporary account for any split payments, as suggested by the specialist. After allocating the bank feed to the electronic clearing account, you can then journal all transactions from there.

     

    This method allows you to effectively manage split payments across different bank accounts while ensuring accurate record-keeping.

     

    Please let us know if you need further assistance with this process.

     

    Thanks,
    Genreve

     

    • RUNCO's avatar
      RUNCO
      Experienced User

      Hi, as per the previous advice to allocate from the bank feed to electronic clearing account, then  journal the amount form the electronic clearing account ( to the wages expense account ) I have done this as a total figure ( to create journals for each employee is time consuming and less than ideal. I want to point out that another employees wages ( who is not paid via split back ac) is also showing on my bank reconcilation ie as a double up.

      This 'upgrade' is seriously a step backwards. While is was not perfect before it is now problematic, I should not have to be journaling employee wages done via the payroll each time.

    • RUNCO's avatar
      RUNCO
      Experienced User

      Hi sorry for my late reply, I have been trying to find a solution and so far have not. See my previous post/reply.

      • jenniek's avatar
        jenniek
        Ultimate Partner

        Hi RUNCO 

        I'd be happy to have a phone conversation with you to see if we can find a solution. With the new payroll effectively posting the transactions for you - you shouldn't need to be manually processing - but the system relies on you creating the bank file and then it matching to one total transaction. I would maybe look at creating a "bank clearing Account" in your accounts list to save the confusion with the electronic clearing account - as this is used for other purposes. I'll run some tests in my demo file and see if I can work something out.