Get started

HTML Wrap

class	section group

HTML
<span data-swiftype-index="true">

html-wrap

class	col span_3_of_5

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

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

UI Text Box

size	medium
type	tip

Get expert help resolving out of balance reconciliations - invite your bookkeeper or accountant into your online file so they can investigate the issue and fix it. See Invite a user to an online file.

UI Expand

expanded	true
title	To check where the out of balance occurred

Follow the steps below to determine if your out of balance is caused by your current reconciliation or a previous reconciliation.

Enter the Bank Statement Date as the same date as your Last Reconciled Date.
Enter your Closing Statement Balance as the Closing balance on your Last Reconciled Date. (You may need to check your previous bank statement)
Deselect all transactions from the Mark Cleared Transactions section.
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.

UI Expand

title	Check current reconciliation

Check your current reconciliation

Here are some things to look out for:

did you set up a bank account and carry over an opening balance? If so, have you performed an initial bank reconciliation?
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.

Checking previous reconciliations

If you've checked the above things and there's still an out of balance, it probably means a previously reconciled transaction has been changed, deleted or reversed.

Run the Reconciliation Report for each of the previously reconciled months.

UI Expand

title	To check previous reconciliations

UI Expand

title	Check previous reconciliations

Check previous reconciliations

Go to the Reports menu and click Index to Reports.
From the Banking section click Reconciliation Report.
Enter the date of your previously reconciled bank reconciliation.
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.
Identify which transaction(s) are causing the out of balance by comparing the Reconciliation Report with the corresponding bank statement.
Correct the transaction(s) causing the out of balance.
Re-reconcile the corrected transaction(s).
Repeat with each subsequent reconciliation until no more out of balances are found.

Checking the Calculated Statement Balance

If no reports balance it is possible you have changed your account opening balance. You might need to restore an early backup to check the account's original opening balance.

If you've checked all the things causes 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:

UI Expand

title	To check the Calculated Statement Balance

To check the Calculated Statement Balance

On the Reconcile Accounts window:

Enter the closing date of your latest bank statement in the Bank Statement Date field.
Enter $0.00 in the Closing Statement Balance field.
Select all transactions as cleared and take note of the Calculated Statement Balance .

Go to Find Transactions > Accounts tab.
Select the bank account you're trying to reconcile.
Enter the closing date of your latest bank statement in both the Dated From and To fields.
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).give us a call and we'll help you:

HTML
<p><b>Australia</b> - <a href="tel:1300-555-123">1300 555 123</a> \| Monday to Friday <b>7am</b> to <b>8pm</b>, Saturday to Sunday <b>9am</b> to <b>5pm</b> (Melbourne time)</p>

HTML
<p><b>New Zealand</b> - <a href="tel:0508-328-283">0508 328 283</a> \| Monday to Friday <b>9am</b> to <b>10pm</b>, Saturday to Sunday <b>11am</b> to <b>7pm</b> (New Zealand time)</p>

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.

UI Expand

title	To undo a bank reconciliation

To undo a bank reconciliation

Go to the Banking command centre and click Reconcile Accounts. The Reconcile Accounts window appears.
In the Account field, enter the account for which you want to undo the reconciliation.
Click Undo Reconciliation. If this button is inactive, it means the account hasn't been reconciled, or your user role doesn't allow this function.
The Undo Last Reconciliation window appears, confirming the account and date of the reconciliation you are undoing.
Image Removed Image Added
UI Text Box
type warning
Undoing a bank reconciliation can't be reversed, so it's strongly suggested you click Back Up to create a backup before proceeding.
Click Undo Reconciliation. A confirmation window appears.
Click OK. The Reconcile Accounts window reappears.

HTML
</span>

HTML-wrap

width	15%
class	col span_1_of_5

HTML Wrap

float	left
class	col span_1_of_5

Panelbox

name	green
title	Related topics

HTML Wrap

class	sidebarlinks

Reconciling your bank accounts

Set up banking: Your first bank rec

Month-end procedures

Deleting a transaction

Panelbox

name	yellow
title	From the community

RSS Feed

titleBar	false
max	5
showTitlesOnly	true
url	http://community.myob.com/myob/rss/search?q=reconciling+bank+accounts&filter=labels%2Clocation%2CsolvedThreads%2CincludeForums&include_forums=true&location=category%3AAccountRight&search_type=thread&solved=true

HTML Wrap

class	morelinks

More »

Page tree

Versions Compared

Old Version 40

New Version 67

Key

Check your current reconciliation

Checking previous reconciliations

Check previous reconciliations

To check the Calculated Statement Balance

Undoing a reconciliation

To undo a bank reconciliation

Was this information helpful?

Why not?

How would you improve this topic?

Thanks! Anything you'd like to add?

Get started

Company file

Work with others

Banking

Emails & printing

Items

Employees (AU)

Suppliers

Customers

Reporting

EOFY

Tips & tricks