Edit reconciled transactions

Summary

Steps to take to edit a transaction included on a bank reconciliation in Sage Accounting.

Resolution

On your bank activity, they have a tick in the reconciled column.

You cannot change the customer or supplier. You'll need to delete the payment or receipt, then enter a new receipt or payment with the correct customer/supplier.
You cannot edit:

Reconciled bank transfers or deposits
Read how to reverse a bank transfer or cash deposit in UK or Read how to reverse a bank transfer or cash deposit in Ireland
Payments and receipts included on a VAT return and submitted to HMRC
Read how to correct transactions included on a VAT return in UK or Read how to correct transactions included on a VAT return in Ireland

How this works

Edited transactions remain reconciled when changing Reference, Method, Ledger Account, and Date within the reconciled period
For example, if the reconciliation ends on July 31, any date up to July 31 maintains reconciliation

The transaction is no longer reconciled if Bank, Amount, or Date's amended with a later reconciliation end date.

We unreconcile and update the transaction so it is ready for you to check and reconcile again
On your next reconciliation:
- We adjust the starting balance by the amount of the edited transaction
- We show the edited transaction with a Corrected label in the Corrected Transaction column

Follow an example

The closing balance from your last statement was £1000.
You enter a payment for £500 and reconcile it. Your bank account balance and your closing balance is now £500.
After finishing the bank reconciliation, you realise that you entered the payment with the wrong amount. The payment should be £400.
You go to the bank activity and edit the payment.
Your bank balance is now £600, but the closing balance of the reconciliation was £500.
On the bank activity, the payment shows as not reconciled.
When you open the completed reconciliation, the payment has a Removed from reconciliation label in the Corrected Transaction column.
To make sure your reconciled balance matches your bank statement, start a new bank reconciliation. Then reconcile the edited transaction.
When you start the new reconciliation, the edited transaction is not reconciled and shows as Corrected.
The Starting Balance is now £1000 as we removed the £500 payment. You reconcile the edited payment. This updates your closing balance to £600.

You are now ready to reconcile your next statement as usual.

Audit trail and reports

When you edit a transaction, we reverse the original transaction and create a new one with a new transaction number. Apart from the audit trail, only the new transaction shows on your reports.

How this shows on the audit trail

For all unreconciled transactions, and reconciled other payments and other receipts:

The original transaction shows with a line through to show it is reversed
We create a new transaction with the updated details and a new transaction number

For reconciled customer receipts and supplier payments:

We create a new transaction to reverse the original. This has a type of Correction
We create a new transaction with the updated details and a new transaction number

Change the description, reference or ledger account

From Banking, select the relevant bank account.
From the Activity tab, select the relevant row to open the transaction to edit.
Make the required changes and Save.

Change the date

From Banking, select the relevant bank account.
From the Activity tab, select the relevant row to open the transaction to edit.
Change the date and select Save.

The edited transaction remains reconciled when the new date is the same period as the reconciliation.

The edited transaction is unreconciled when the new date is after the end date of the reconciliation. For example, if the end date of the reconciliation is 31 July, and you change the transaction date to 5 August.

Change the bank account or amount

From Banking, select the relevant bank account.
From the Activity tab, select the relevant row to open the transaction to edit.
Change the bank account or amount.
If you reduce the amount of an allocated customer receipt or supplier payment, select the edit icon in Paid column. The Part Pay window opens. Adjust the Amount to Pay or Discount as required.
Save your changes.

Reconcile again

If you previously reconciled the transaction, you may need to reconcile it again. Do this when you change the bank account, amount, or date where the new date is later than the end date of the reconciliation.

When you open the reconciliation page and view an existing reconciliation, the edited transaction shows with a Corrected label in the Corrections column.

From Banking, open the bank account you want to reconcile.
Choose the Reconcile link.
Check the Statement End Date. Make sure this is the same as or later than the date of the edited transaction.
The edited transaction shows with a Corrected label in the Corrected Transactions column. To reconcile the edited transaction, select the check box in the Reconcile column.
Check the Starting Balance. This is the closing balance from your previous reconciliation, adjusted by the amount of the edited transaction.
For example, the starting balance was previously £500. You edit a payment of £500. As the payment is no longer reconciled, the new starting balance is £1000.
Enter the Statement End Balance to match the new balance after you reconcile the edited transaction.
For example, you change the payment amount to £400. As the payment is no longer reconciled, the starting balance is £1000. To reconcile the edited payment, enter £600 as the new Statement End Balance. This is the Starting balance £1000 less the edited payment £400.
Check the Reconciled balance is now correct and the difference is zero.
Select Finish.

The starting balance of your next reconciliation will now be correct.

Edit reconciled transactions

Summary

Resolution

How this works

Follow an example

Audit trail and reports

Change the description, reference or ledger account

Change the date

Change the bank account or amount

Reconcile again

Related Solutions

SUPPORT & TRAINING

PARTNERS

COMPANY

FAQs