MYOB payroll transactions not matching

Hi ratracemngment 

Thanks for your post. I'd suggest going to Banking>>Find transactions>>locate a payroll transaction and click on the reference number to open. Then check the Payment method and Account. The Payment Method is determined by what has been selected in the employee card>>Payment details tab.

You can check the account linked to the Payment method in Accounting>>Manage linked accounts>>Payroll tab. If the payroll clearing account has been selected for the employee's chosen Payment method you can change it in Manage linked accounts to the bank account.

You can also use the Find transactions window to search for transactions posted to the payroll clearing account by clicking on the Debits & Credits tab and selecting the account in the Account search field.

Once you know which account the payroll transactions have been posted to I'll be happy to help with moving those amounts to the bank account.

Let me know how you go.

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

Hi VanessaT 

That error means that you've selected the electronic clearing account in the Account field:

That account needs to be the bank account that funds are withdrawn from:

Please let me know if you need further help.

That worked! thank you

Hi Tracey,

Thanking you for your reply and help. I discovered that the payroll was coming from and going to the clearing account which I changed to the main account which was originally set up as a bank feed. Im not sure why it suddenly was going to the clearing account?? Anyway, could I have some advice on how to move these amounts to the main account please?

Another annoying issue (which Im not sure is a MYOB glitch), everytime I go to match payroll even now it matches up with these payroll transactions which equal 0.00. Ive tried to delete these payruns - but MYOB wont let me, it only lets me 'reverse pay' which I have done, then it duplicates the transaction and I am not allowed to delete and it STILL matches my payroll with these payruns which equal 0.00. Can you help me with this issue also? Many thanks, Heidi (Rat Race Garage)

Hi ratracemngment 

If the pay transactions were being posted to the Payroll clearing account it would mean that the clearing account was linked to the employee's Payment method in Accounting>>Manage linked accounts. You can move the amount from the Payroll clearing account to the bank account by recording a Transfer money transaction. The From account is the bank account and the To account is the Payroll clearing account. You then match the bank feed transaction to the Transfer money transaction.

If the pay transactions were going to the Electronic clearing account, it means that the employee's Payment method is Electronic. In this case you need to process the electronic payment in Prepare electronic payments to move the amount from the Electronic clearing account to the bank account. The post, Why can't I match employee pays in Bank transactions, has detailed instructions for this.

For the second issue, $0 pays are recorded by clicking on the Send update event button in the STP reporting centre or by manually recording a $0 adjustment pay. Both methods are used to update the YTD amounts in STP, as such, they shouldn't be deleted or reversed.

They are appearing in the Bank transactions window as possible matches due to the Show filter being set to show All transactions. You can manually reconcile these transactions in the Reconcile accounts window by ticking them. They won't affect the reconciliation as they are $0 transactions. Manually reconciling them will stop them from appearing in the Bank transactions window and the Reconcile accounts window.

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.

Hi again Tracey,

I am completely confused now, Thank you for your reply. I changed both employees as cash under payment method, and cash is linked up to the main bank account now. I followed your instruction to tick all the 0.00 payrolls in reconcile accounts. My issue now is that when I go to match up payroll transaction in the bank feed, there is now nothing there to match.

I dont know what amounts went to the clearing account when everything was set to 'electronic' to be moving it back to the main account, is there an area where I can find out how much went there so that I can follow your advice and 'transfer' the money back again?

I have to say, this is a very complicated accounting system and not very user friendly!

Thank you for your support and help.

Many thanks

Heidi

Also Tracey,

Sorry to be a pain, when I 'transfer money' under banking - do I transfer the money FROM electronic cleaing account back TO our main account? and, do I enter the gross amount before taxes and super etc?

Thanks again

ratracemngment 

Hi Heidi

If the clearing account is the electronic clearing account you don't do a Transfer money transaction, that's only if the clearing account is the payroll clearing account. 

If the pay transactions were going to the Electronic clearing account, it means that the employee's Payment method is Electronic. In this case you need to process the electronic payment in Prepare electronic payments to move the amount from the Electronic clearing account to the bank account. The post, Why can't I match employee pays in Bank transactions, has detailed instructions for this.

I know it sounds confusing but we'll get it sorted and you won't have this issue in the future.

Hi again Tracey,

Just to be clear, the pays went into the respective employee accounts and i just want to make sure that the set up electronic pays (to transfer the amounts back to the main account via a bank file) arent actually amounts of money physically being being moved? Just the data if that makes sense??