Payroll amount doubled itself in Bank reconciliation

[mabelwmp]

Hi,

I have set up a payroll clearing account in MYOB Essentials to do the adjustments. 

The original payroll record was deleted, and payroll was re-done in the payroll clearing account.

The amount I entered should be correct, and the balance in the clearing acount is 0 now. 

The system allows me to match the payroll amounts to the bank transactions, but if i do, the matched payroll amounts are doubled in the bank reconcilation. 

If I unmatch the payroll amounts in the bank transaction, the bank reconcilation amount is the same as the bank statement, but it will show unmatched in bank transaction as shown in the pic attached.

Please kindly advise how to fix it. Thank you.

[CloverQ · Accepted solution]

Hi @mabelwmp 

Generally speaking, you can delete the original pay run then re-do it with the payroll clearing account which puts the clearing account's balance to a negative figure. Once the bank transactions are in, allocate the corresponding bank transactions to the payroll clearing account as well, which shall return the clearing account's balance back to 0.

In your situation, the clearing account's balance is already 0 before the bank transactions are allocated/matched, this suggests there are manual transactions recorded in Essentials to return the clearing account's balance to 0. I'd recommend locate and delete these manual transactions, then allocate the bank transaction to the clearing account instead. 

Please feel free to let us know how you go.

[mabelwmp]

Hi @CloverQ ,

I have double checked the works I did. There is something weird with my funds transfers entered. 

The date showed on the transaction history page was different from the date entered in the entry itself.

I could not tell how it turned like that, but I think that is why those enteries were doubled.

Anyway, I deleted those weird entries and re-entered them. The problem is fixed now. Thank you.