old Unbalanced Reconciliation and ways to fix it.

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.
Stonegalleria
Experienced User
13 Posts
Experienced User
Experienced User

13Posts

3Kudos

0Solutions

Solved: Go to Solution

old Unbalanced Reconciliation and ways to fix it.

Hi All,

I recently joined a new company from this month. When I looked at the Account Reconciliation, its last date of reconciliation was 2019 with havoc Out of balance and Calculated Statement Balance. We use MYOB AccountRights and do the manual entry.

Can somebody plase help me sort this out;

1) How to clear those unmatched transactions (Bcoz there are lot of it).

2) How to fix that Out of Balance and Calculated Statement Balance.

And also if you could provide some Journal Entry guidance for that, it would be great help.

 

Thanks.

Dan.

2 REPLIES 2
LRBooks61
Ultimate Cover User
1,054 Posts
Ultimate Cover User
Australia
Ultimate Cover User

1,054Posts

217Kudos

124Solutions

Accepted Solution Solved

Re: old Unbalanced Reconciliation and ways to fix it.

Hi

Interesting problem

 

Are the unmatched entries older than the last reconciled date?

 

Really you need to reconcile the bank month by month year by year

 

There are issues around existing transactions if BAS has been lodged etc 

If BAS has been reported but you need to add transactions or delete transactions this will lead to amendments to the previous BAS lodgements. This can of course be done in the next BAS .

An issue that you can deal with by running GST reports before and after you made the amendments ( You should have previous BAS reports but ensure you do)

 

I would make sure that the bank  does balance as at the last date reconciled in 2019.

 

Then manually reconcile month by month and year by year ( are bank feeds being used? make sure they are all matched or allocated) - go into the reconcile bank screen or reconcile from bank feeds 

 

Enter the date you want to reconcile - the transactions relevant to that date will be shown 

 

If they are ticked you can see if it reconciles to the statement , if they don't it may need to be manually checked to see the error. Something it is evident that there is a double up in transactions. Anyway I am sure you know what to do 

 

Work through it and any transactions that are left once reconciled need to be investigated and dealt with

 

Hope that helps 

 

Lisa

Stonegalleria
Experienced User
13 Posts
Experienced User
Experienced User

13Posts

3Kudos

0Solutions

Re: old Unbalanced Reconciliation and ways to fix it.

Hi Lisa,

Thank You for your support.

Followed the Month-by-Month reconciliation approach.

 

Thanks!

Dan.

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