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:
-
Click Edit.
-
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.
-
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.
-
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.
-
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.