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

[ZacW]

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.

[Tracey_H]

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.

[JOSIE]

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]

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

[ZacW]

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]

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]

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]

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.

[zumrut25]

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]

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.