Forum Discussion

Treasurer2429's avatar
Treasurer2429
Member
21 days ago
Solved

Unmatched Payroll Transactions

Hello

I am new to MYOB (have taken over from previous treasurer) and I need help please.

 

In our Payroll system it has been set-up as CASH and the bank acct linked is our No.1 acct.
Pays have generally always been paid from this account. We pay manually via internet banking and not via myob. 

On 4 x separate occasions in April, May & June wages were NOT paid from this acct but were paid from our No.2 acct. 
The wages paid have been manually matched in myob via category.

 

My problem is this:

When I go to reconcile No.1 acct, myob is listing these payroll / payrun transactions as Not Matched. 

I've tried to match them with the transaction from No.2 acct, but it doesn't show when I choose 'match to existing record'. 

 

In Bank Reconciliation for No.1 acct, if I do not tick the payroll transaction then myob and bank balance match BUT when I reconcile the acct and then create a P&L + BS report the figures are incorrect and showing a negative balance. 


If I do tick the payroll transactions then it makes the myob balance worse and doesn't match to bank balance. 

 

I have sent a support request on 12th June but have had no reply. 


Any assistance on how to fix this would be greatly appreciated 

 

Thanks 

  • Merry2's avatar
    Merry2
    20 days ago

    Hi - have you fixed your problem?  It's a bit confusing.  Do you actually have 2 separate bank accounts?  When you say 'manually matched via MYOB category do you mean they have been manually matched to the wages expense account - this would cause a duplication.  When you pay manually via internet banking does it generate one payment in your bank or individual payments to employees?  If you go into banking/prepare electronic payments are there a whole series of payments in there?

3 Replies

  • Treasurer2429's avatar
    Treasurer2429
    Member
    20 days ago

    Hi Merry2

     

    Thank you for your reply. Sorry that my explanation was a bit confusing. Yes, we have 2 separate bank accounts. 

    I have finally received a reply from MYOB support and they have advised for me to uncategorise the wages paid from the 2nd account..their reply is below

    If the wages were paid from a different bank account, they need to be recorded against that account in MYOB, rather than categorized manually through the bank feed. 

    If the instructions from MYOB does not work I will give your suggestion a go.

    Thanks again

     

  • Merry2's avatar
    Merry2
    Trusted User
    20 days ago

    Sorry I should have said, I don't think you will not be able to 'match' across 2 separate bank accounts but a work around this would be to generate a 'payment' between the 2 accounts. Banking/spend money.  Choose the bank account you have paid the wages from leave everything blank except the date (you could put adj in ref no) and then put the other bank account in the category field and enter the amount of the transaction.  If there are multiple transactions you can select the drop down arrow next to "record and new" and select record and duplicate and just keep changing dates and amounts. 

  • Merry2's avatar
    Merry2
    Trusted User
    20 days ago

    Hi - have you fixed your problem?  It's a bit confusing.  Do you actually have 2 separate bank accounts?  When you say 'manually matched via MYOB category do you mean they have been manually matched to the wages expense account - this would cause a duplication.  When you pay manually via internet banking does it generate one payment in your bank or individual payments to employees?  If you go into banking/prepare electronic payments are there a whole series of payments in there?

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home