Forum Discussion

TracyL2's avatar
TracyL2
Experienced User
4 years ago

Reconciliation Outstanding Cheques in Bank Reconciliation

Hi Team   I've been reading through the questions and answers to this in the Community, however still unsure what to do.   We have Outstanding cheques appearing in our Reconciliation Report - and...
  • Tracey_H's avatar
    Tracey_H
    4 years ago

    TracyL2 

     

    Hi Tracy

     

    You can send me those screenshots by private message.

     

    It sounds like there is a duplication happening somewhere. Once I have a look at those screenshots we'll be able to work it out.

     

    Can you open both transactions that are appearing in the Bank Register and send me screenshots of those too.

Tracey_H's avatar
Tracey_H
Former Staff

Hi TracyL2 

 

Thanks for your post. The first thing I'd look into is why those transactions are appearing as outstanding. Have they been changed so have become unreconciled? Have they been recorded twice?

 

I would recommend going through the steps in this help article to work out what's happened: Resolving out of balance bank reconciliations

 

Bank reconciliations do need to be completed in date order, as such, you wouldn't be able to go back and reconcile October now. If there is an issue with the October rec you would need to undo all reconciliations back to October and then re-reconcile.

 

Please let me know if you need further help.

 

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

TracyL2's avatar
TracyL2
Experienced User
4 years ago

Thanks for the reply.

 

I'll give it a shot and check the link you've provided, and yes the entries appear twice in the MYOB feed - but like this as an example:

 

The Bank Feed displays wages 3/2/21 (the date the wages are set to be auto paid), then I process the wages on 4/2/21 - so I therefore end up with two entries in MYOB for the same week of pays.

So when I come to reconcile the month of February - the wages appear twice for each fortnight and I end up with an OOB figure which is always the total sum of wages. The only way I can reconcile the month is to NOT include the MYOB entries for the 4/2/21, go to RECONCILE Accts - put the statement date and actual bank balance statement figure and then I'm no long OOB. However, as I've not inlcuded the payaments show up on the Reconciled Report as Outstanding.

 

Hope that makes sense. Am I doing something wrong?

 

Thanks

Trac

 

I have to unclick the MYOB entries processed in MYOB

  • Tracey_H's avatar
    Tracey_H
    Former Staff
    4 years ago

    Hi TracyL2 

     

    Can you send me a screenshot of the Bank feed window showing the two transactions? Can you also tell me exactly what transactions you are processing?

    • TracyL2's avatar
      TracyL2
      Experienced User
      4 years ago

      Tracey - is there any chance I can send personally to you or offline?

      There's too much info to block out.  I will do what I can to block out if I can't send to you offline from here.

      Sorry, I meant it's the BANK REGISTER that shows two entries for the same payments, the BANK FEED is correct.

      The BANK FEED is not OOB atm, it only appears OOB when I come to reconcile - which means entries must be wrong - but it's always related to the wages - and this started occurring in September.

      • Tracey_H's avatar
        Tracey_H
        Former Staff
        4 years ago

        TracyL2 

         

        Hi Tracy

         

        You can send me those screenshots by private message.

         

        It sounds like there is a duplication happening somewhere. Once I have a look at those screenshots we'll be able to work it out.

         

        Can you open both transactions that are appearing in the Bank Register and send me screenshots of those too.

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.