Partner Zone

About bank reconciliation and bank reconciliation report

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Sissic
1 Post
User

1Posts

0Kudos

0Solutions

About bank reconciliation and bank reconciliation report

We were flat using the bank reconciliation, but when we used the bank reconciliation report, the account balance exceeded the reconciliation balance by $34.65. I have tried all kinds of methods, but can't solve it. The amount of $34.65 has always been there, and it can't be balanced. What should I do? This issue started appearing on November 1, 2021.

What do I do next? How do I fix this problem? 

1 REPLY 1
LRBooks61
Ultimate Cover User
1,054 Posts
Ultimate Cover User
Australia
Ultimate Cover User

1,054Posts

258Kudos

124Solutions

Re: About bank reconciliation and bank reconciliation report

Hi

 

If your bank doesn't reconcile it means that there is either an additional transaction or a missing transaction.

 

You say that the difference is in excess so that would indicate an additional transaction.

 

A reconciliation verifies the transactions in myob to the transactions on your bank statement - so you need to find the transaction that is incorrect.

 

I would suggest firstly that you do a find transaction ( Banking tab -last entry)

Select the bank account and change the date range (make it a broad as possible as you say the amount has always been there) and then enter the amount you are looking for $34.65

 

See what comes up - hopefully there will be some transactions

 

So you would look for either a doubled up transaction or a transaction in MYOB that does not appear on your bank statement.

 

That makes it easy to resolve - as the transaction is from another period I suggest that rather than undoing reconciliations , just to do a transaction to offset it as at 30/6 . What I mean is if it is a spend money do a receive money with the same details as the original transaction.

 

If that doesn't help then you will need to find where the out of balance first occurred and then go through the bank transactions to see if you can find the problem

 

Hope this helps

 

Lisa

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post