Child pages
  • Resolving out of balance bank reconciliations

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 31 Next »


 

 

Close

How satisfied are you with our online help?*

Just these help pages, not phone support or the product itself

0
1
2
3
4
5
Very dissatisfied
Very satisfied

Why did you give this rating?

Anything else you want to tell us about the help?

When you're reconciling a bank account, an out of balance amount tells you that something isn't quite right. So you need to work out what's gone wrong.

Checking your reconciliation

Here are some things to look out for:

    • did you type the correct figure in the Closing Statement Balance field? You need to type the closing balance from your bank statement, not the opening balance.
    • did you enter the correct date (that of the closing balance from your bank statement) in the Bank Statement Date field? An incorrect date may prevent some transactions from appearing in the list.
    • did you select all the transactions that appear on the bank statement? If not, some transactions might not have been accounted for in the reconciled balance.
    • did you select, by mistake, a transaction that didn’t appear on your bank statement? If yes, you need to deselect this transaction.
    • did you record all bank charges and bank interest entries that appear on the bank statement? If not, you need to record them and select them for reconciliation.
    • has the opening balance of the bank account been changed? If it has, you'll need to change it back to its original value. You might need to restore an early backup to check the account's original opening balance.

    • has a previously reconciled transaction been deleted or reversed? If it has, re-enter it then select it in the Reconcile Accounts window when performing the reconciliation.

Checking the Calculated Statement Balance 

If you've checked all the things listed above and your reconciliation still doesn't balance, it might relate to an incorrectly displayed Calculated Statement Balance in the Reconcile Accounts window. This is a rare issue that only affects the displayed balance, not the actual balance.

Here's a quick check to see if this is your issue:

  

To check the Calculated Statement Balance
  1. On the Reconcile Accounts window:
    1. Enter the closing date of your latest bank statement in the Bank Statement Date field.
    2. Enter $0.00 in the Closing Statement Balance field.
    3. Select all transactions as cleared and take note of the Calculated Statement Balance.
  2. Go to Find Transactions > Accounts tab.
  3. Select the bank account you're trying to reconcile.
  4. Enter the closing date of your latest bank statement in both the Dated From and To fields.
  5. Press the TAB key on your keyboard and take note of the Ending Balance in the bottom-right of the screen.

If the Ending Balance is the same as the Calculated Statement Balance, it's fine. If not, you'll need to contact MYOB for help (Australia 1300 555 123 or New Zealand 0508 328 283).

Undoing a reconciliation

If your issue relates to a previous reconciliation (perhaps a transaction was incorrectly reconciled, or a wrong date was used) and you haven't been able to fix these issues, try undoing the last reconciliation. All transactions for that period will return to an unreconciled state, and you'll need to reconcile them again using the previous bank statement.

 

To undo a bank reconciliation
  1. Go to the Banking command centre and click Reconcile Accounts. The Reconcile Accounts window appears.
  2. In the Account field, enter the account for which you want to undo the reconciliation.
  3. Click Undo Reconciliation. The Undo Last Reconciliation window appears, confirming the account and date of the reconciliation you are undoing.
     

    Undoing a bank reconciliation can't be reversed, so it's strongly suggested you click Back Up to create a backup before proceeding.

  4. Click Undo Reconciliation. A confirmation window appears.
  5. Click OK. The Reconcile Accounts window reappears.