Partner Zone

Bank Reconciliation - Calculated Statement Balance

CraigGP
4 Posts
Cover User
Australia
Cover User

4Posts

0Kudos

0Solutions

Bank Reconciliation - Calculated Statement Balance

We opened a new G/L code for a new bank account in June22 & have recently started doing bank feeds. Last week we ended up with an amount of $5,420 in the Calculated Statement Balance even when everything is 'unticked'. We have unreconciled all the way to the beginning of June (ie before the g/l code was created) and the $5,420 remains in the Calculated Statement Balance. 

 

I have checked that nothing is in the opening balance of the account (in account profile) and have also extended the dates to see if anything was perhaps posted in say year 2202 instead of 2022 and no joy there either. 

 

There is 1 transaction of $5,420 entered as a 'Spend Money', but there doesn't appear to be anything wrong with it. I deleted the transaction anyway and re-entered, but no change. 

 

Any help would be appreciated. 

Craig

3 REPLIES 3
Komal_S
MYOB Moderator
7,988 Posts
MYOB Moderator
MYOB Moderator

7,988Posts

697Kudos

1,132Solutions

Re: Bank Reconciliation - Calculated Statement Balance

Hi @CraigGP 

Can you please delete that spend money transaction again, but do not re-enter it, and check if the balance is then correct? If not, please check the reconciliation reports to see if this transaction is sitting as outstanding and also confirm if you're using AccountRight or MYOB Business. 

Kind regards,
Komal

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

CraigGP
4 Posts
Cover User
Australia
Cover User

4Posts

0Kudos

0Solutions

Re: Bank Reconciliation - Calculated Statement Balance

Thanks for your reply. When I deleted the transaction the balance remained incorrect. I am not sure what you mean by the 'balance sitting as outstanding'. When all transactions are unticked, the calculated statement balance shows $5420 whether that transaction is entered or not.

 

We are using Account Right & have recently gone to the cloud. Something I noticed was that when closing down the file, it said that I hadn't backed up for 48 days, but this is not the case - the file was backed up earlier in the day. When I tried to back up it said that I was over-riding a file of the same name, so the back up did happen. Could this be some sort of synchronisation problem?

 

 

 

Komal_S
MYOB Moderator
7,988 Posts
MYOB Moderator
MYOB Moderator

7,988Posts

697Kudos

1,132Solutions

Re: Bank Reconciliation - Calculated Statement Balance

Hi @CraigGP 

 

Thanks for confirming. As you're using AccountRight, sometimes this can happen due to a glitch in the reports. So we can confirm that's the issue, can you please do the following:

 

  1. Check Last Reconciled date on Reconcile Accounts window.
  2. Go to Reports > Banking > Cheques and Deposits > Reconciliation Report
  3.  Select Advanced Filters
  4.  Select Individual bank account > OK
  5.  Select Change Entered Statement Date to List of Recorded Statement Dates and Run Report
  6. Click on Statement Date to see all statement dates
 
 
If the latest date on this report does not match the last reconciled date on the reconcile accounts window, that means there is an issue with the report. In order to correct it, take a backup of your file, and
 
  1. Go to Banking > Reconcile Accounts
  2. Enter a fake date after the latest statement date: e.g. 01/08/2023. Ignore the message about the transaction being future-dated.
  3. Enter the Calculated Statement Balance into the Closing Statement Balance field, so that the Out of Balance is $0.00
  4. Press the Reconcile button. This should then allow you undo the 'fake' reconciliation and any other future dated transactions and should display everything correctly. 

Kind regards,
Komal

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

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