When an employee has two bank accounts.

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
limtr
Contributing User
12 Posts
Contributing User
Contributing User

12Posts

0Kudos

0Solutions

When an employee has two bank accounts.

When an employee has two bank account the new version is not allowing me to allocate the bank accounts to coincide with that pay period

12 REPLIES 12
limtr
Contributing User
12 Posts
Contributing User
Contributing User

12Posts

0Kudos

0Solutions

Re: Payroll split between two accounts wont match in bank feed after Essentials Upgrade

I also have this problem 

I have contacted MYOB and no one is willing to help. 
I was able to match these before the upgrade very frustrating 

Tracey_H
12,172 Posts
Former Staff
Former Staff

12,172Posts

0Kudos

1,836Solutions

Re: When an employee has two bank accounts.

Hi @limtr 

 

Thanks for your post. The Help Article, Split a pay between accounts, has detailed instructions on how to set up and process pays split between bank accounts.

 

For pays that have already been processed and paid, it's not possible to match two bank feed transactions with one pay transaction. You would need to reverse and reprocess the pay using the method in that Help Article. The other option is to reverse the pay and reprocess as two pay runs so the net amounts match the amounts of each bank feed transaction.

 

Please let me know if you need further help.

 

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

Cheers,
Tracey
Previously @bungy15

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

KayeC
Contributing User
8 Posts
Contributing User
Contributing User

8Posts

4Kudos

0Solutions

Re: When an employee has two bank accounts.

We have an employee who has two bank accounts - 1 is a fixed amount and the balance varies.

To manage this we made the fixed amount a deduction.

However, the net pay cannot be matched to the bank feed.  eg.  The net pay on the payslip shows net - deduction but the options for matching the bank feed includes the deduction.

This is obviously a programming error.

Tracey_H
12,172 Posts
Former Staff
Former Staff

12,172Posts

0Kudos

1,836Solutions

Re: When an employee has two bank accounts.

Hi @KayeC 

 

To split an employee's pay between two accounts, in the employee card>>Payment details select Electronic as the Payment method, select the number of bank accounts and enter the account details. For a fixed amount into one account change the Value to Dollars in Bank account 1 and enter the fixed amount. The balance of the net amount will be automatically paid into Bank account 2:

 

image.png

 

Process the pay run as normal. Then:

 

  1. go to Banking>>Prepare electronic payments
  2. tick the pay transaction
  3. click on Download bank file
  4. upload the bank file in your internet banking and the bank will split the amount between the two bank accounts
  5. in Bank transactions match the electronic payment transaction to the bank feed transaction

 

Deductions are amounts withheld from employee pays and paid to a third party, so the software is correctly reducing the net amount by the deduction. If you used this method and manually transferred the wages into two bank accounts in Bank transactions you would have:

 

  1. bank feed transaction for the fixed amount - you would need to record a Spend money transaction or allocate to the linked payable account
  2. bank feed transaction for the balance - you would match this to the pay transaction which is the reduced net amount

Cheers,
Tracey
Previously @bungy15

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

KayeC
Contributing User
8 Posts
Contributing User
Contributing User

8Posts

4Kudos

0Solutions

Re: When an employee has two bank accounts.

Thanks for your response Tracey.
 
I choose to follow the second option and make a deduction which is then allocated from the bank feed to Payroll Deductions
 
The problem arises matching the bank feed for the balance as the 'Match transaction' does not display the reduced net balance as anticipated.
It is picking up the net balance after tax which includes deductions ??
 
 
Tracey_H
12,172 Posts
Former Staff
Former Staff

12,172Posts

0Kudos

1,836Solutions

Re: When an employee has two bank accounts.

Hi @KayeC 

 

The bank feed transaction for the balance is matched to the pay transaction.

 

I've used the Child support deduction in the following example. The pay transaction has a net amount of $519 which is gross $602 less PAYG $58 less Child support $25:

 

image.png

 

 

In Bank transactions the bank feed is matched to that pay transaction:

 

image.png

 

 

The second bank feed transaction for the deduction amount is allocated to the deductions liability account:

 

image.png

 

Please let me know if you need further help.

Cheers,
Tracey
Previously @bungy15

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

KayeC
Contributing User
8 Posts
Contributing User
Contributing User

8Posts

4Kudos

0Solutions

Re: When an employee has two bank accounts.

That's perfect and exactly as we would hope.

But...

The deduction shows on our payslip leaving a reduced balance as per your example. 

However, the 'Match transaction' pulls up the wrong amount

Tracey_H
12,172 Posts
Former Staff
Former Staff

12,172Posts

0Kudos

1,836Solutions

Re: When an employee has two bank accounts.

Hi @KayeC 

 

When you click on Match transaction, the pay transactions are listed for matching. Can you send me a screenshot of the Bank transactions window and the pay transaction, in Bank transactions click on the purple reference no to open the pay transaction. Make sure sensitive information is removed from screenshots prior to posting on the Forum.

Cheers,
Tracey
Previously @bungy15

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

KayeC
Contributing User
8 Posts
Contributing User
Contributing User

8Posts

4Kudos

0Solutions

Re: When an employee has two bank accounts.

Please see files attached

Screenshot_20230221_123510.png
Screenshot_20230221_123838.png

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post