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. In AccountRight 2011 and later, click the Insert/Modify tab then click Show/Hide. Select Reconciled Date in the Available columns list then click Show then click OK. See our example below.
   

5. Click Display or Run Report (based on your software version).

   • 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.

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.

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

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. See 2: Delete the transaction below.

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.

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.
    

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.

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.

Note the Calculated Statement Balance in the Reconcile Accounts window shown below.

The Calculated Statement Balance amount represents the total value of all transactions that have been ceared 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'.

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. In AccountRight 2011 and later, click the Insert/Modify tab then click Show/Hide. Select Reconciled Date in the Available columns list then click Show then click OK.
5. Click the Finishing tab and set the Sort By field to ID#. In AccountRight 2011 and later, click Sort (on the Filters tab) and sort by ID No. then by Date. Click OK.
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 4. Reconcile the replacement transaction above.