How to edit reconciled transactions
Description
Cause
Resolution

NOTE:

See the article Limitations on editing reconciled transactions before making adjustments.

 Reconciled vs Unreconciled

The transaction stays reconciled when you change the following fields:

  • Reference
  • Method
  • Ledger Account
  • Date, if it remains within the reconciled period

The transaction becomes unreconciled when you change the following fields:

  • Bank Account
  • Amount
  • Date, if it moves beyond the reconciled period

Sage Accounting adds a Removed from Reconciliation label in the Corrected Transaction column. The starting balance updates for the next reconciliation.

▼Example

  1. The closing balance equals $1,000.
  2. You reconcile a $500 payment, making both balances $500.
  3. The correct payment amount is $400.
  4. You edit the payment, and the bank balance becomes $600.
  5. The reconciled balance stays $500.
  6. Sage Accounting marks the payment as Not Reconciled.
  7. The reconciliation shows Removed from Reconciliation.
  8. The starting balance resets to $1,000.
  9. Reconciling the corrected payment updates the closing balance to $600.

You can continue reconciling the next statement as usual.

How to edit a Reconciled Transaction

  1. Open Banking.
  2. Select the relevant bank account.
  3. Open the transaction from the Activity tab.
  4. Edit one or more of the following:
    • Description
    • Reference
    • Ledger Account
    • Date
    • Bank Account
    • Amount
  5. Adjust Amount to Pay or Discount if required.
  6. Select Save.

Reconcile again

  1. Open the reconciliation page.
  2. Confirm the Statement End Date and Starting Balance.
  3. Enter the Statement End Balance.
  4. Select the checkbox in the Reconcile column.
  5. Confirm the reconciled balance equals zero.
  6. Select Finish.

Customer or Vendor Changes

You can’t change the customer or vendor on a reconciled transaction. Delete the transaction. Create a new receipt or payment with the correct customer or vendor.

Reconciled Bank Transfers or Deposits

You can’t edit reconciled bank transfers or deposits. Reverse the transfer or deposit to remove the value from the bank account.

 

Audit Trail and Reports

When you edit a transaction, the system reverses the original transaction. It creates a new transaction with a new transaction number. Only the new transaction appears on reports.

Unreconciled transactions and reconciled other receipts or payments

  • The original transaction shows with a strike-through
  • A new transaction appears with updated details

Reconciled customer receipts and vendor payments

  • A reversing transaction appears with type Correction
  • A new transaction appears with updated details

 

Steps to duplicate
Related Solutions

Bank Reconciliation Overview

Delete bank transactions