Forum Discussion

SCan's avatar
SCan
Experienced User
5 years ago
Solved

Manual reconciliation conflicts with bank feed

I have started using Bank Feeds and set up my first feeds from 1/4/19. However I had already manually reconciled up to 1/6/19. So I thought I could just hide the transactions in the feed from 1/4 to 1/6. But my feeds don't reconcile. Is that because it is still accounting for the hidden bank feed entries? Because those have been entered and reconciled manually the transactions don't show up next to the bank feed entries. 

 

So if the opening balance refers to the beginning of the entire bank feed (from 1/4) it will include the hidden entries which can no longer be allocated.  How do I set the opening balance to the start of the un-hidden entries? Or reset the bank feeds?

 

How do I fix this?

  • SCan's avatar
    SCan
    5 years ago

    Thanks, I figured it out, reconcile window was incorrectly ticked/unticked. Once I figured that out everythin balanced.

3 Replies

Sort By
Replies have been turned off for this discussion
  • GDay53's avatar
    GDay53
    Ultimate Partner
    5 years ago

    SCan 

     

    Welcome to the MYOB Community Forum, I hope you find plenty of useful information.

     

    The best way is to never Hide transaction except in an extreme emergency.

    Ideally you should reconcile your bank accounts manually up to the start date of the bank feeds and from that date onwards ONLY use the bank feeds. You will need to setup Transaction, Bill and Invoice Rules as well.

    Once everything is setup and working then to reconcile all you are doing is looking for transactions that have NOT been reconciled as they will more than likey be double entry or entered as paid from the wrong account. So the reconciliation takes seconds to do.

     

    • SCan's avatar
      SCan
      Experienced User
      5 years ago

      Thanks, I figured it out, reconcile window was incorrectly ticked/unticked. Once I figured that out everythin balanced.

  • Tracey_H's avatar
    Tracey_H
    Former Staff
    5 years ago

    Hi SCan 

     

    To unhide your transactions go to the Bank Feeds window and select Hidden in the Display Transactions drop down list.  When a bank feed transaction is hidden it won't have any impact on your balances. I'd start by going back to the beginning and unhiding the hidden transactions and, using your Bank reconciliation reports, check that each transaction was manually reconciled before rehiding it. 

     

    These support notes may help find why you are out of balance -

    Resolving out of balance bank recs 

    Hiding bank feed transactions 

     

    If you're still having problems please feel free to send me screenshots by private message