Forum Discussion

CBaumber's avatar
28 days ago

Payroll EFT Payments manually processed in bank which is creating a double up in MYOB

Hi

 

All my employees are set up in the Employee card to be paid electronically. However my bank doesn't support ABA files. This is because we pay the labourers from a subaccount within our personal bank account - this subaccount is only used for work expenses though so that I am able to reconcile the account every month. 

 

I pay all the labourers manually via this "work subaccount" rather than via an ABA file as my bank doesn't support an ABA file upload. Automatic bank feeds into MYOB are set up for this "work subaccount" because the transactions in this account are 100% work use. Therefore when I make a manual payment from my bank to pay our labourers, the transaction then gets imported into MYOB automatically using the bank feed and I allocate this transaction to 6-4100 Payroll - Wages & Salaries. I run into a problem as the payrun is then double counted in MYOB each time I process it so I create the following general journal each time I do a payrun:

DR 1-1171  Electronic Clearing Account      xx

CR 6-4100  Payroll - Wages & Salaries                xx

 

And this journal clears out the electronic clearing account so that the balance is $0 and removes the double count that is made to the Payroll - Wages & Salaries account. I don't want to have to do this every single time I process a payrun. 

 

I'm wondering what would happen if I change the Employee card to say that I'm paying the labourers Cash but then doing a manual bank transfer. Would this fix the double up in MYOB? I'm very confused! Any and all help would be greatly appreciated.

 

  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator

    Hi CBaumber,

     

    The reason your transactions doubled up is that a transaction is created when you create the ABA file and another when you allocate the bank feed. If you set up the employee cards to cash instead of electronic payments, you'll still have the same issue if you allocate the transactions from the bank feed. This happens because one transaction is created from the pay run and another is created when allocating. The best way to handle this is to match the bank feed to the electronic payment instead of allocating it. This way, the bank feed will match with the already recorded transaction instead of creating a new one.

     

    Feel free to create a new thread if you need any other help.

     

    Thanks,
    Genreve