Forum Discussion

EmmaIEES's avatar
EmmaIEES
Member
7 days ago

Pay Item Not Matching After Incorrect Rule Applied

Payroll gets paid by "cash". Normally, I / MYOB automatically match the money coming from the bank account to the Payroll Reference Number that relates to processing of the actual payroll.

I have a payroll payment that got allocated using a bank rule, which has since been deleted.  I "unmatched" the payment (bank) of payroll to the rule (which had it going to the electronic clearing account).  Then I tried to match the bank item agains the payroll (ref #) item.

I am unable to do this.  The payroll reference number isn't found when I search against existing records.  Nor is the amount.  I have given broad date ranges as well.

When I reconcile the bank account, the payment shows as unmatched & I am unable to match against the payroll reference number their either.  The bank account reconciles up to the date prior to the transaction though.

In find transactions there is only the payroll item, not a spend money.  I have checked the General Ledger and nothing apart from payroll item found.

Suggestions on how to allocate / what to do so I can move forward with reconciling and end of month that is looming?

Thanks

 

 

4 Replies

  • EmmaIEES's avatar
    EmmaIEES
    Member
    6 days ago

    I have worked it out.

    Payroll = Paid from Everyday Account
    Actual = Paid from Loan Account

    Which is why they can't find each other.

    Solution: Allocated Actual to a "holding" account and then did a journal to move from holding account to bank account.

    Now item is "matched" and bank accounts all balance.

  • Princess_R's avatar
    Princess_R
    MYOB Moderator
    7 days ago

    Hi EmmaIEES,

     

    Thanks for following up and for checking those things.

     

    As the setup looks correct from your side and the issue is only affecting this one item, this will need a closer look at the file and how that rule was applied. The best next step would be to reach out to our team directly through My Account or via live chat with MOCA so they can investigate it further for you.

     

    Cheers,

    Princess

  • Hi,  

    Thanks for the assistance.

    Employee Payment Method = Cash


    Bank Account for Cash Payments , Cheque Payments & Electronic Payments is the same.

    It is still not resolved.

    The week prior, where it didn't accidentally get caught by the rule, it matched perfectly.  Also, all other employees matched.  It is just this item that was caught up by a rule, that is causing issues.

  • Doreen_P's avatar
    Doreen_P
    MYOB Moderator
    7 days ago

    Hi EmmaIEES,

     

    That does sound like a messy little payroll matching puzzle. A good place to start is checking the employee Payment Method and your Payroll Linked Accounts, as those usually explain where the payroll payment is sitting and why it’s not matching the way you expect. If the employees are set to be paid electronically, the transactions may still be sitting in Prepare Electronic Payments. In that case, you’ll need to download the bank file so the payment can flow through and be allocated in bank feeds.

     

    If the employees are set to Cash or Cheque, check the linked payroll accounts for those payment methods in:

    • Setup
    • Linked Accounts
    • Payroll Accounts

    Then review:

    • Bank Account for Cash Payments
    • Bank Account for Cheque Payments
    • Bank Account for Electronic Payments

    These guides should help with the setup side of it:

    If it’s still not resolved after those checks, you can reach out to our support team via the Contact Us page so they can take a closer look with you.

     

    Cheers,

    Doreen