Forum Discussion

Mathilda's avatar
Mathilda
Trusted User
2 years ago

Bank Reconciliation out of balance

Good morning

I need some help please. I am trying to reconcile our bank account for BAS but I was only able to reconcile up to 20 March.  I have a problem with the transactions on the 21st

Our cheque account balance on that day was $-30,682.94 

I am out of balance with the exact amount of the wages I paid that day: $13,151.60 – why is that?

Also, I never made a separate payment of $937.92 to "Debra" (using only a name for privacy)  – her wage was included in the total wages amount paid, but it appears as a separate entry on my MYOB bank statement as well.  When I click on the arrow there, is comes up with her pay slip which I apparently can’t delete but have to reverse because of payroll reporting (which I have never done before).  I have no idea why this has happened.

Some pointers would be greatly appreciated. 

Attaching a screen shot of the bank statement and payroll summary.

 

 

9 Replies

  • Princess_R's avatar
    Princess_R
    MYOB Moderator
    2 years ago

    Hi Mathilda,

     

    Thank you for your post.

     

    Regarding the wages paid on the 21st, it seems like the total amount of $13,151.60 isn't reflected correctly in your bank account balance. We'll need to investigate why this discrepancy exists. It's possible that there might be missing or duplicate transactions causing the imbalance. The first thing you should check is the linked account within the transactions. You can recap the transactions to see the linked account.

     

    As for the separate payment of $937.92 to "Debra," it is indeed puzzling, especially if her wage was already included in the total wage amount paid. It's essential to figure out why this entry appears separately on your MYOB bank statement. Reversing the transaction as per payroll reporting requirements is necessary. However, you need to ensure that this will not affect your payroll reports.

     

    For more information, please check Fixing out-of-balance bank reconciliations.

     

    Feel free to respond if you need further assistance.

     

    Cheers,

    Princess

  • Mathilda's avatar
    Mathilda
    Trusted User
    2 years ago

    Hi Princess_R 

    Thanks for your reply.  Okay I have no idea how to do the recapping from what I've read on your link as it gives examples on sales and purchases.  I need more time to investigate the "linked account" issue.

     

    Secondly, I've looked at my payroll reporting centre and that single transaction for "Debra" was not reported and accepted (screen shot attached) - only the combined payroll for the day.  Does that mean I can delete the single pay or must it still be reversed?

  • Shella_A's avatar
    Shella_A
    MYOB Moderator
    2 years ago

    Hi Mathilda,

     

    Thanks for your response. It's key to really understanding the linked account issue, so take the time you need for your research. Checking the setup of the payroll linked accounts in Manage linked accounts is a smart move. Also, I see the screenshot of Debra's unreported single transaction. If it's not reported, you're free to delete the transactions. Just make sure this won't affect your payroll reports.

     

    Feel free to post again anytime you require further assistance.


    If my response has answered your inquiry, please click "Accept as Solution" to help other users find this.

     

     

    Kind regards,

    Shella

  • Mathilda's avatar
    Mathilda
    Trusted User
    2 years ago

    Hi Shella_A 

     

    I have just tried to delete that entry of Debra's separate pay but it comes up with a message that says that the pay has been reported so it needs to be reversed.  I have not reported this, it does not even show up on the payroll reporting centre records.  I don't understand it.

     

    I'm still going to need help with the linked accounts to get rid of that payroll total that I'm out of balance with but I'm going to try and sort out the Debra pay first.

  • Shella_A's avatar
    Shella_A
    MYOB Moderator
    2 years ago

    Hi Mathilda,

     

    You might want to check the security settings that determine if your transactions can be deleted or reversed. You can find this under Setup > Preferences > Security > Transactions CAN'T be Changed, They Must Be Reversed. If the pay run isn't reported, you shouldn't be seeing an error message.

     

    Reverse option deselected

     

    Delete transaction on the edit menu

     

    For more details, you can refer to the article, Fixing a Pay.

     

    Regarding the linked accounts balance, the steps can differ based on your situation. It could be helpful to revisit the previous articles shared by my colleague.

     

    Feel free to post again anytime you require further assistance. 


    If my response has answered your inquiry, please click "Accept as Solution" to help other users find this.

     

     

    Kind regards,

    Shella

  • Mathilda's avatar
    Mathilda
    Trusted User
    2 years ago

    Hi Shella_A 

    Okay thanks I have managed to reverse the pay for Debra (hoping this is going to be okay as according to me it was not reported, but anyway ...)

    I also managed to get to the Recap Transaction for the total wage amount that I am out of balance with on my bank reconciliation.  Attaching a screen shot of what came up ...

  • Earl_HD's avatar
    Earl_HD
    MYOB Moderator
    2 years ago

    Hi Mathilda,

    Thanks for your response. If you're still experiencing issues with this, why not give our virtual assistant MOCA a try? MOCA is designed to delve deeper into problems like this and may offer solutions. Feel free to interact with MOCA through myob.com/support for any queries or assistance you may need. If MOCA isn't able to provide the help you need, our live chat team is available to continue where MOCA left off.

    Feel free to start a new post if you have further queries and one of us will be happy to assist you.
    Regards,
    Earl

  • Mathilda's avatar
    Mathilda
    Trusted User
    2 years ago

    Hi Princess_R 

    I managed to get the recap of that transaction of the wages that I am out of balance with.  Does the result of it (attached) show any reason for not balancing? 

  • Mathilda's avatar
    Mathilda
    Trusted User
    2 years ago

    Earl_HD 

    Really?  You're showing me away when I am already at my wit's end.  I've done all the steps that I was told to do, and I am making progress.  So you want me to cope with "Hmm, I don't know that one" and then start a new post?