Forum Discussion

MaryHa's avatar
MaryHa
Experienced User
20 days ago

PLEASE HELP Need to Match a Payroll that was Paid incorrectlty

I did they pay run in Myob. When I paid the pay from the bank account I underpaid by 40c. I then processed the 40c the next day to the employee. However I cannot match both these transactions to the payrun.

One solution that was suggested by someone was the below, however when I match the transaction (per step 2) and add the adjustment to the payroll clearing account of 40c do there is no out of balance and press save...it does not save! The transaction is still there in my bank feeds unmatched. What am I doing wrong this is driving me crazy.

----------------------------------------------------------------------

Hi Lisa, Anna22​ RS66​ 

Good questions and i have the same issue.

 

Possible work around is to:- 

1/ go into unallocated transactions from your bank feed.

2/ select the first pay payment amount in your bank feed and select "Match transaction", match the myob pay account transaction, it will not balance. Then click the "+ Adjustment button" and add another transaction for the negative amount and allocated to your "Payroll Clearing Account"

The first payment amount will now be gone from your to-do in bank feeds.

 

3/ select the second pay payment amount in your bank feed and select "Categorise" and add a transaction for the positive amount allocated to the "Payroll Clearing Account"

The second payment amount will now be gone from your to-do in bank feeds.

 

4/ when reconciling the bank statement, select all the bank transaction to balance.

 

Not an accountant, so let them balance if needed at end of year.

 

4 Replies

  • ClientsNeeds's avatar
    ClientsNeeds
    Experienced Cover User
    19 days ago

    Hi, I have another work around that I used which works very well.

    I will assume you have created an ABA file for the payrun and are trying to match it to the bank feeds.

    1. Please delete the ABA file and have the payslips go back into the electronic clearing a/c
    2. Go to the electronic clearing account , this time choose the "Payroll Clearing A/c" as the bank account and create the ABA file.
    3. In the bank feeds code the wages payment to the payroll clearing a/c and also the 40 cents.
    4. Now go to reconcile - choose payroll clearing a/c and tick them both off against each other and it should reconcile to NIL

    If your unable to create the ABA file for the payroll clearing a/c just edit that in the chart of accounts to allow ABA and just input any numbers and codes as it won't actually be used for bank purposes.

    Thanks, Matthew Powell - Clients Needs Bookkeeping - get the books done the right way

  • MaryHa's avatar
    MaryHa
    Experienced User
    13 days ago

    I am sorry but I have no idea what a ABA file is and how to delete it and then re-install it. Surely like a payment you should be able to allocate 2 transactions to one payslip?

     

    What I ended up doing is cancelling the payment and notified the ATO. Then ran the payrun for this one person again but added the extra 40c as tax (so the net would be what was actually paid from the bank account) and processed it and advised the ATO of the change. When I went back into MYOB the next day I was now able to match the transaction. I got the employee to pay back the 40c that I had transferred to her seperately in my initial attempt to match transactions.

    What a mess and headache.

  • ClientsNeeds's avatar
    ClientsNeeds
    Experienced Cover User
    12 days ago

    That isn't the best fix, PAYG isn't reported in cents so there will be an imbalance there and asking the employee to pay back 40 cents is a bit embarrassing, it does sound like you may need someone to guide you with the technical part of things. I do offer my services as a consultant if you need help let me know.

    https://www.clientsneeds.com.au 

  • MaryHa's avatar
    MaryHa
    Experienced User
    8 days ago

    Its not the PAYG - its matching the actual pay to what cane out of our bank account. This has worked and balanced so its all good thats all that matters.

    By the way for 40c I would pay it out of my own pockets - employee was not asked to pay the money back

Looking for something else?

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

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.