Child pages
  • Deleting or reversing a reconciled transaction

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML Wrap
classcol span_3_of_5

ANSWER ID:9084

AccountEdge treats reconciled transactions as being finalised. Changing or deleting these transactions will cause the particular account to become out of balance. For the account to reconcile again, the affected transactions must be returned to their original state.

This page describes how to delete a reconciled transaction, and also how to reverse reconciled transactions - in case you want to maintain an audit trail of the original transaction.

UI Text Box
typenote

Before you begin Make a backup of your company file before making any changes to it. See the AccountEdge help for more information (Australia | New Zealand).

Deleting a reconciled transaction

If you are unsure how to determine if a reconciled transaction has been deleted, then please refer to our support note . Once you have identified the reconciled transaction that has been deleted, please proceed to 3. Re-enter the transaction below.

Situations can arise that requires a reconciled transaction to be deleted. An example of this would be where its realised that a reconciled Pay Bills payment had been entered for the wrong supplier. The following steps explain how you can delete and re-enter a reconciled transaction so as not to affect your bank reconciliation.

 

UI Expand
title1. Note the transaction Reconciled Date
 When deleting a reconciled transaction, its Reconciled Date will be needed for re-reconciling the account.
  1. From the Banking command centre, click Reports.
  2. Highlight the Bank Register report then click Customise (or Display - depending on your software version).
  3. Set the report parameters to capture the transaction to be deleted.
  4. Click the Report Fields tab and select the option - Reconciled Date from the list of Available Fields.
  5. Click Display.

    • Identify the transaction to be deleted and note its:
    • Date
    • Amount
    • Reconciled Date

In our example Bank Register report shown below, we want to delete payment #1 which has a Reconciled Date of 1/11/2013.

In addition to the above, note the Calculated Statement Balance prior to deleting this transaction.

UI Expand
title2. Delete the transaction
  1. With the Bank Register report displayed, move your cursor over the transaction. Once the cursor turns into the shape of a magnifying glass, click to open the transaction.
  2. Click OK to the Reconciled Transaction message.
  3. Go to Edit on the menu bar and click Delete.
  4. Return to the Bank Register report, click Redisplay and the transaction will now be missing.

In the window below you can see the Calculated Statement Balance has changed by the amount of the deleted payment.

UI Expand
title3. Re-enter the transaction

Re-enter the transaction making sure to use the correct transaction type, transaction Date and Amount.

UI Text Box
typenote
The Amount and the bank account must be the same as those of the original transaction.  
UI Expand
title4. Reconcile the replacement transaction

For your bank account to reconcile again, the replacement transaction will need to be reconciled.

  1. Open the Reconcile Accounts window.
  2. Set the Account field to the bank account.
  3. Enter the Last Reconciled Date to repeat in the Bank Statement Date field.
  4. Select the replacement transaction as Cleared.
  5. Enter the New Statement Balance amount - this is the closing balance of the statement as at the Last Reconciled Date.
  6. Make sure the Out of Balance is zero then click Reconciled and follow the remaining on-screen steps to reconcile the account.

In our example, the Last Reconciled Date was 1/11/2013, so this is the date we would enter in the Bank Statement Date field as can be seen in the Reconcile Accounts window shown below.

Note: With the transaction selected as cleared, the Calculated Statement Balance has returned to its original amount.

The Reconciliation Report when customised for the replacement transaction's Reconciled Date, will be the same as it was when the account was originally reconciled.

Reversing and re-entering reconciled transactions

This method differs from the above in that an audit trail will remain for the original transaction.

UI Expand
title1. Set the required preference
  1. Go to the Setup menu and choose Preferences.
  2. Click the Security tab.
  3. Select the option Transactions CAN'T be changed; They Must be Reversed .
  4. Click OK. See our example below.
UI Expand
title2. Reverse the transaction
  1. Go to the Banking command centre and click Bank Register.
  2. Specify the applicable date range to locate the transaction to be reversed.
  3. Click the zoom arrow next to the transaction. The following message will be displayed advising that the transaction is already reconciled.
  4. Click OK to the message.
  5. Go to the Edit menu and choose Reverse Transaction.
  6. Change the date to represent when you want the reversal to appear in your reconciliation. See our example below.
  7. Click Record.
UI Expand
title3. Re-enter the transaction and reconcile the account

Re-enter the transaction against the applicable bank account. The choose to reconcile accounts and you will see a debit and credit amount reflecting your bank account. See our example below.

You will now be able to reconcile again by selecting the reversal and the new payment as these balance each other out.

HTML
<h2><i class="fa fa-comments"></i>&nbsp;&nbsp;FAQs</h2><br>
UI Expand
titleHow does changing or deleting a reconciled transaction affect the bank reconciliation?

The Calculated Statement Balance amount represents the total value of all transactions that have been cleared in the software. Similarly, it also represents the balance of all transactions for the account that have been presented to your bank.

Reconciling transactions keeps your software's accounts aligned with your bank records. Changing or deleting a reconciled transaction alters the software's Calculated Statement Balance amount so it no longer corresponds your bank records; this is termed an 'out of balance'.

UI Expand
titleA reconciled transaction is appearing in the Reconcile Accounts window to be reconciled again. What happened?

There are three things that will cause this:

  • The reconciled transaction was deleted and has since been re-entered (but not yet reconciled).
  • The reconciled transaction has been duplicated.
  • The reconciled transaction has been changed and resaved

To determine which of the above has happened:

  1. Locate the bank statement you last reconciled your account to and note its closing balance.
  2. From the Banking command centre, click Reconcile Accounts.
  3. Set the Account field to your bank account then press the tab key on your keyboard.
  4. With no transactions selected as Cleared, does the Calculated Statement Balance equal the bank statement balance noted at step 1?
  • Yes: This suggests the unreconciled transaction is a duplicate entry.
  • No: This indicates the reconciled transaction was deleted and has since been re-entered, or changed and resaved.

The above can be quickly confirmed by using the Bank Register report.

  1. From the Banking command centre, click Reports.
  2. Highlight the Bank Register report then click Customise (or Display - depending on your software version).
  3. Set a date range to capture the transaction.
  4. Click Report Fields and select the Reconciled Date option.
  5. Click the Finishing tab and set the Sort By field to ID#.
  6. Click Display.

In Bank Register report 1 shown below, you can see cheque #4 is listed twice and only one copy of it has a Reconciled Date. From this you can see that cheque #4 has been duplicated. Your options to correct this are to either delete or reverse the unreconciled entry.

Bank Register report #1

In Bank Register report #2 shown below, you can see that cheque #4 is listed only once, and, it doesn't have a Reconciled Date. This shows the original reconciled entry was deleted and the one being reported is a replacement.

Bank Register report #2

To correct this, please refer to 3. Re-enter the transaction and reconcile the account above.

HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Deleting transactions (Australia)

Deleting transactions (New Zealand)

Out of balance bank reconciliations

Customer deposits

Reconciling a bank account (Australia)

Reconciling a bank account (New Zealand)