How to edit reconciled transactions

Summary

Learn how to modify transactions already reconciled in Sage Accounting.

You can’t change the customer or vendor.
Delete the transaction and enter a new receipt or payment with the correct customer or vendor.

The transaction stays reconciled if you change the Reference, Method, Ledger Account, or Date within the reconciled period.
The transaction stays unreconciled if you change the Bank account, Amount, or Date to one beyond the reconciliation period.
We add a Removed from reconciliation label to the Corrected Transaction column.
We update the starting balance of your next reconciliation.

The closing balance was $1000.
You put in a $500 payment and reconcile it, making both balances $500.
The payment must be $400.
You fix the payment, so the bank balance becomes $600, but the reconciled balance stays $500.
The payment shows as Not reconciled.
The completed reconciliation says Removed from reconciliation.
You need to reconcile the edited payment to match the balances.
The bank reconciliation page says Corrected.
The starting balance is now $1000 after removing the $500 payment.
Reconciling the edited payment updates the closing balance to $600.

You’re now ready to reconcile your next statement as usual.

When you edit a transaction, we reverse the original transaction and create a new one with a new transaction number.
Only the new transaction shows on your reports.

For unreconciled transactions and reconciled other payments and other receipts:

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

For reconciled customer receipts and vendor 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

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 Save.
- The transaction remains reconciled if the new date is within the reconciliation period
- The transaction remains unreconciled if the new date is after the reconciliation period

From Banking, select the relevant bank account.
From the Activity tab, select the relevant row to open the transaction.
Change the bank account or amount.
If you're reducing the amount of an allocated customer receipt or vendor payment, adjust the Amount to Pay or Discount as required.
Save your changes.

Open the reconciliation page and check the Statement End Date and Starting Balance.
Enter the Statement End Balance to match the new balance after reconciling the edited transaction.
Select the check box in the Reconcile column.
Check the Reconciled balance is correct and the difference is zero.
Select Finish.