Partner Zone

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

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.
ZacW
Contributing Cover User
7 Posts
Contributing Cover User
Contributing Cover User

7Posts

5Kudos

0Solutions

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

The employee file is set up correctly - split pay between 2 bank accounts.

I pay my staff manually via bank but I tried "preparing electronic payments" - this does get the payroll transaction to the bank feed but I still can't match it as it's the whole amount, not split between 2..

 

This has only happened since the upgrade.

13 REPLIES 13
Tracey_H
12,172 Posts
Former Staff
Former Staff

12,172Posts

0Kudos

1,836Solutions

Re: Payroll split between two accounts

Hi @ZacW 

 

Thanks for your post. When the employee pay needs to be split between bank accounts you would need to upload the bank file to make the payment. Your bank will then split the payment and the bank feed transaction will be the total amount that you can match to the pay transaction.

 

To match the existing transactions you would need to reverse the original pay transaction and reprocess as two separate pays.

 

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

JOSIE
Experienced User
17 Posts
Experienced User
Experienced User

17Posts

11Kudos

0Solutions

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

To match the existing transactions you would need to reverse the original pay transaction and reprocess as two separate pays   OMG THIS IS GOING TO BE PAINFULL 

ZacW
Contributing Cover User
7 Posts
Contributing Cover User
Contributing Cover User

7Posts

5Kudos

0Solutions

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

It seems ridiculous. I only have 3 staff so we pay them manually. Fine for the ones whose pay goes into one account, I have changed to "cheque" on the employee file. So now I have to upload a bank file for one employee? 

It's stupid...

I didn't reverse the pay.....another stupid workaround.....I did a spend money from the Electronic Payments ac which is now back to zero. Yes the transaction is now sitting in my Prepare Electronic Payments page but I'm happy to leave it there. I've already reversed and processed the pay again trying to get it to work. I'm over it Smiley Sad

ZacW
Contributing Cover User
7 Posts
Contributing Cover User
Contributing Cover User

7Posts

5Kudos

0Solutions

Re: Payroll split between two accounts

There needs to be a better solution than this...

My business banking is not set up to upload electronic files. We are a small business with less than 5 employees. 

Only one employee has pay split between 2 accounts. 

I could do this quite easily before the upgrade.

My workaround was to do 2 x spend moneys from the electronic payments ac which gets it back to zero on the GL. The payment is still sitting on the "Prepare Electronic Payments" page which I don't really care about as I never use it. Please advise if you see any other problems with my workaround that I haven't thought of..

Bassist
Contributing User
5 Posts
Contributing User
Contributing User

5Posts

4Kudos

0Solutions

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

Totally agree that this is painful. I accidentally paid the incorrect amount to employee so paid her the top-up.

However, the pay is now going to be a split payment and it doesn't match the pay transaction.

Before the upgrade, it was kind of a simpler solution - deleted the original individual pay (not the entire pay run) and fiddled with the split payment into two account options, then ran the individual's pay again as a separate pay run. Not sure how to do it now? I may end up getting the employee to EFT back the wrong amt, and then I pay the correct amt in a single transaction. What a total pain....

Kitchendesigns
Experienced User
35 Posts
Experienced User
Experienced User

35Posts

13Kudos

0Solutions

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

Am also trying to work a way to fix this...underpaid employee and did a top up, now have no idea how to match this in bank transactions...not easy, any assistance would be great.  Should not be this difficult

Tracey_H
12,172 Posts
Former Staff
Former Staff

12,172Posts

0Kudos

1,836Solutions

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

Hi @Kitchendesigns and @Bassist 

 

Payroll over/under payments are a different situation to the pay being split between the employee's bank accounts. As such, the information provided to the original poster on this thread doesn't match your situation.

 

If the pay transaction is correct but the amount actually transferred is underpaid, you will need to reverse the pay transaction and reprocess as two separate pay runs. You can then match the separate bank transactions to the pay transactions.

 

To prevent this from happening in the future we would recommend using electronic payments to make wage payments: Paying suppliers and employees electronically

 

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

zumrut25
Contributing User
6 Posts
Contributing User
Contributing User

6Posts

3Kudos

0Solutions

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

That's not always possible for some business for a variety of reasons, as you will see from some of the comments further up the thread. This has only been a problem since the "upgrade", and it's painful. Plus the in-software help implies the opposite, that if you set up the split, download the electronic file, even if you don't upload it to the bank, it will "fix" the problem by allowing the two separate transactions to be matched to one pay. You're corrent in saying it doesn't work that way, because I just tried it. Now I have to do another reversal and process 2 pays for that person. 

Tracey_H
12,172 Posts
Former Staff
Former Staff

12,172Posts

0Kudos

1,836Solutions

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

Hi @zumrut25 

 

We recommend paying employees using a bank file to split the amount between bank accounts as this reduces the risk of errors.

 

However, if you're not able to do this and you don't want to record separate pay runs, allocate the pays to the Payroll clearing account and then record Transfer money transactions to split the amount into two transactions. 

 

To do this you will need to go to Accounting>>Manage linked accounts and select the Payroll clearing account as the Bank account for Cash (or Cheque) payments. Then go to the employee card>>Payment details and select Cash (or Cheque) as the Payment method.

 

Process the pay run as normal. In Bank transactions allocate the two bank feed transactions to the Payroll clearing account. I'd recommend reconciling the Payroll clearing account back to zero in the Reconcile accounts window on a regular basis.

 

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

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