Allocating pays

Hi JenniBate 

You could change your payroll setup, so the payments are paid from a different bank account (suggestion: Payroll Clearing Account).  Then when the payments come through your Bank Feed, you can allocate these as a transfer to the 'Payroll Clearing Account'.

Hope that helps,

AlanT

Hi AlanT 

What do we need to do for the historical bank transactions that we are trying to match to payroll items?

If we change the account to "Payroll Clearing" that will work with items going forward - but not the previous ones.

Thank you in advance for your help.

Hi AngieK25 

Thanks for your post. Generally speaking, if you have multiple bank feed transactions and one electronic payment transaction you could delete/reverse the electronic payment transaction. Then process electronic payments for each individual pay transaction separately. You can then match the bank feed transactions with the individual electronic payment transactions.

Please let us know if you need further help.

Hi Tracey,

One employee pay will not allocate to the transaction (ie no match is found), all the rest have. The date and amount are correct and the payment method is CHEQUE, the same as the other payees for that payrun.

In bankrec that unallocated pay is auto reconciled but has a REF no next to it , all the others don't.

Employee was only paid once , not twice by mistake.

Please help

There are no electronic payments

Hi

Do you have one bank transaction for the 4 pays and 4 individual MYOB transactions for thr payroll ?

Thats how I am interpreting your message

My suggestion would be to manually reconcile the 4 pays in myob 

Do a journal 

DR Bank Total of bank payment N-T

CR Payroll clearing account bank payment amount N-T

Then allocate the bank payment through bank feeds to the payroll clearing account ( this will be a DR Payroll clearing account N-T transaction)

This will, record the payroll correctly and offset the bank payment

Hope that helps

Lisa

Hi Lisa,

No, I have a seperate bank transfer for each employee and don't use the clearing account, so I am still stuck.

Thanks for reply

Hi same should apply 

Lisa

Hi

Is the issue about the one pay that hasn't been able to be matched?

You said that the bank feed had been automatched but not to the payroll cheque, Can you go into the payment that it has matched with and see what it is?

If it is not the correct match can you unmatch and put it back into bank feeds to properly match it with the payroll transaction

Investigate the automatched transaction to see if it a legitimate entry and match it to the correct bank feed transaction or delete it if it is incorrect or a duplication

Hope that helps

Lisa

Hi Lisa,

I was wrong about auto match. All the seperate pays have 'TFR to bank acc details'' except the one in question which has 'Pay employee NAME' in the bank rec.

This transaction has no drop down arrow on the right in the  rec window and has the REF no.  on the left.

It can't see the bank transaction for some reason even though amount, date are correct and there is no double up of the payment.

Andrew