MYOB Exo Business

Hide NavigationShow Navigation

  • Contents
  • Index
  • Search
 
Show results that include all search words

 

Editing Reconciliations

You can change a Bank Reconciliation by double clicking on a row in the search/summary screen to display the Details screen in View mode.

While in View mode, you cannot change the reconciliation. To change the reconciliation, put it into Edit mode.

Restrictions

You can edit the last reconciliation, but you should avoid editing reconciliations before the last one. Use the User-level profile setting Allow editing of bank reconciliations to control editing.

This table shows the logic that either enables or disables the Edit button, and which warning messages appear:

Last Rec

Locked

Profile

Edit Button

Messages

Yes

No

Don't allow

Enabled

None

Yes

Yes

Don't allow

Disabled

Not applicable – Edit button is disabled

No

No

Don't allow

Disabled

Not applicable – Edit button is disabled

No

Yes

Don't allow

Disabled

Not applicable – Edit button is disabled

Yes

No

Allow

Enabled

None

Yes

Yes

Allow

Enabled

Warning message that is blocked

No

No

Allow

Enabled

Subsequent Bank Reconciliation warning (see below).

No

Yes

Allow

Enabled

Subsequent Bank Reconciliation warning. # Warning message that it is locked

Note: You cannot edit Bank Reconciliations that were entered before upgrading to MYOB Exo Business 7.0.

The Editing Process

To put the reconciliation into Edit mode:

  1. Click Edit.

  2. Exo Business revises the GL Balance by re-selecting all GL transactions up to and including the reconciliation date. New, unreconciled GL transactions with a date on or before the reconciliation date appear in the list on the left. You can reconcile these transactions.

  3. You can also reconcile other transactions in the list on the left as long as they were not reconciled in a subsequent reconciliation. If they have been reconciled on a subsequent reconciliation, an error message displays.

  4. You can unreconcile transactions in the list on the right by double clicking on them. Exo Business adjusts the total unreconciled value and the closing bank statement balance.

  5. Click Save. If this is not the last reconciliation, Exo Business moves to the next reconciliation. You can edit or save it.

Note: If you don't save your changes, the GL bank balance and opening/closing bank statement balances on subsequent bank reconciliations are not revised and the data is incorrect.

Deleting Reconciliations

Utilities > Bank Reconciliation > {select the conciliation in the list} > Tools > Delete

To delete a Bank Reconciliation, select Tools > Delete Reconciliation in the Bank Reconciliation window. This sets the General Ledger transactions that have been reconciled to unreconciled.

If the reconciliation was a CSV reconciliation, all imported bank statement items are deleted from the database table bank_rec_uploads). The import file is not deleted.

Note: You can only delete the last Bank Reconciliation for a GL Bank account.

Related Topics

Setting up a New Manual Reconciliation

Bank Reconciliation Details Window