Forum Discussion

MJ7's avatar
MJ7
Experienced Cover User
5 days ago

Further help required with employees shortfall pay

Hi

 

I asked a question yesterday regarding an error I had made on a payrun.  Essentially my STP payroll for 2 employees was correct and sent to the ATO, however I accidentally paid them $5 short each.

 

I have since paid them each $5 directly into their bank accounts to make up for this shortfall.

 

I was seeking help to assign two bank payments to a single Payroll entry in MYOB Business for each employee so that they will reconcile.

 

Princess_R (Moderator) kindly provided me with a link to another thread with the advice below.

 

I successfully have done all 5 steps, however what do you mean by your last paragraph (highlighted in bold) about reconciling spend money, reconcile initial pay ray run, and reconcile general journal to ensure balance.  How do you reconcile all these items?

 

After following steps 1 - 5 I just tried to reconcile my bank feed and the 2 x pay run items are still sitting in my bank feed and I am unable to reconcile them because I can't match them to anything??

 

What am I doing wrong and how can I reconcile these?

 

Thank you

 

_________________________________________________________________________________________________

FROM PRINCEES_R

 

Thank you for your post, and welcome to the Community Forum!

 

I get that you're aiming to assign two bank payments to a single payroll entry in MYOB Business. To assist you in resolving this, please give these steps a shot:

  1. If you have a payroll clearing account already set up, proceed to step 2. If not, you can easily create one by navigating to Accounting >> Chart of Accounts >>Create Account.

  2. Within bank transactions, allocate the separate wage payment bank fee transactions to the clearing account.

  3. Generate a general ledger report from Reporting >> Reports to observe credit amounts now present in the bank account due to the allocations made in Step 2. Additionally, note the debit balance in the payroll clearing account reflecting the allocated amount.

  4. Utilize the Accounting menu to create a general journal, transferring the total pay amount between the bank account and the payroll clearing account.

  5. Run the general ledger report from Reporting >> Reports once more. The general journal created in Step 4 offsets the spend-money transactions, effectively reducing the balance in the payroll clearing account.

When conducting the next bank reconciliation, it's crucial to reconcile the spend money allocations, the initial pay run, and the general journal to ensure balance.

 

Feel free to create a new post again if you need help in the future.

 

2 Replies

  • Princess_R's avatar
    Princess_R
    MYOB Moderator
    5 days ago

    Hi MJ7,

     

    Thanks for following up. What that last part means is there are really two separate things happening here, clearing the bank feed transactions, and then making sure the MYOB entries balance out properly.

     

    In your situation, the two extra $5 payments should be handled using Allocate me in Banking > Bank transactions, and each of those bank feed lines should be allocated to the payroll clearing account rather than matched to the original pay run. Once those two bank transactions are allocated, MYOB creates the spend money entries for them. After that, the general journal is used to move the total shortfall amount between the bank account and the payroll clearing account, and that journal needs to have equal debit and credit amounts so it balances properly. Since this part can affect how your bank feeds and reconciliation are recorded, it’s recommended to check with your accountant so the allocation and reconciliation are handled correctly.

     

    Cheers,

    Princess

     

  • MJ7's avatar
    MJ7
    Experienced Cover User
    5 days ago

    Thank you Princess, it appears that the $5 payments have all be allocated correctly and the payroll clearing account and general journal balances, it is just that the original 2 x Payroll entries ($789 & $1153 what I originally paid my employees) remain unallocated in my bank feed.  

     

    Thank you for your help.  I will check with my accountant