Page tree




How satisfied are you with our online help?*

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

Very dissatisfied
Very satisfied

Why did you give this rating?

Anything else you want to tell us about the help?

Just upgraded from old MYOB Essentials and your bank rec doesn't look right? This might be because of an unsaved reconciliation in your old MYOB Essentials – see Check your MYOB business after upgrading.

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.

What can cause an out of balance?

The out of balance will be caused by a problem in your current reconciliation or a previous reconciliation.

Get expert help resolving out of balance reconciliations – invite your accountant or bookkeeper into your MYOB file so they can investigate the issue and help you fix it.

To check where the out of balance occurred

The key to determining where the out-of-balance amount occurred is by narrowing it down to current or previous reconciliations.

Here's how to do this:

  1. Go to the Banking menu and choose Reconcile accounts.
  2. Enter the Bank statement closing date as the same date as your Last reconciled date.
  3. Enter your Closing bank statement balance as the closing balance on your Last reconciled date (you might need to check your previous bank statement for this).
  4. Deselect all transactions on the Reconcile account page.
  5. If there is no Out of balance, the problem is with your current reconciliation. If there is an Out of balance you'll need to check your previous reconciliations as a previously reconciled transaction may have been changed or deleted.
Check current reconciliation

Check your current reconciliation

Here are some things to look out for:

  • if this is your first reconciliation, check that your account opening balance doesn't include any uncleared transactions. If it does include uncleared transactions, change the account opening balance.
  • did you type the correct figure in the Closing bank 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 closing 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.

Check previous reconciliations

Check previous reconciliations

  1. Go to the Reporting menu and choose Reports.
  2. From the Banking section click to run the Banking reconciliation report.
  3. For the Bank statement date, enter or select the date of your previously reconciled bank reconciliation. If you're not sure of the dates, check the Baking reconciliation report (Reporting menu > Reports > Banking tab > Baking reconciliation).
  4. Work back until you find a month where the out of balance is zero ($0.00). This identifies that the suspect transaction(s) will have occurred in the following month.
  5. Identify which transaction(s) are causing the out of balance by comparing the Banking reconciliation report with the corresponding bank statement.
  6. Correct the transaction(s) causing the out of balance. You can open a transaction to edit or delete it by clicking its reference number. See Editing bills, Editing invoices or Deleting transactions.
  7. Re-reconcile the corrected transaction(s).
  8. Repeat with each subsequent reconciliation until no more out of balances are found.

If no reports balance it is possible you have changed your account opening balance.

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

To undo a bank reconciliation

  1. From the Banking menu choose Reconcile accounts.

  2. If you only want to show reconciliations you've completed on a particular account, choose that account from the Account dropdown list.
  3. Click Undo last reconciliation.
  4. Click Yes to the confirmation message.