Skip to main content

Changing or Undoing a Reconciliation

How to fix, edit, or remove a reconciliation after you've started or finished it.

Written by Katie Brooks

After you reconcile an account, you might find something that needs fixing, like a statement date, an ending balance, a transaction, or the account's Starting Balance. This article covers what you can change, what's locked, and how to fix things without throwing off other months.

Reconciliation works from a web browser. Log in from a computer to make these changes.

Two kinds of "Starting Balance"

You'll see "Starting Balance" in two places, and they mean different things:

  • The account's Starting Balance is set on the Accounts page, in the account's Details section. It's the account's balance on its Starting Date.

  • A reconciliation's Starting Balance appears at the top of each reconciliation session. For your first reconciliation on an account, it's calculated from the account's Starting Balance plus the transactions before the session. For every reconciliation after that, it's the ending balance you entered for the previous completed reconciliation.

What you can change anytime

  • Categories and tags. You can edit these on any transaction, reconciled or not. You don't need to remove a reconciliation.

  • Descriptions on transactions you haven't reconciled, even if they're dated in a month you've already reconciled.

Bank-synced transactions can't have their date, amount, or description edited, reconciled or not.

Fixing a reconciliation that's still in progress

If the statement dates or ending balance are wrong in a reconciliation you haven't finished, click Setup at the top of the session. You can also click the three dots and choose Change statement period, Change ending balance, or Attach statement. There's no need to start over.

The new dates can't overlap a reconciliation you've already completed.

What's locked when you reconcile

Transactions you check off are marked reconciled right away, even before you finish. You can't edit a reconciled transaction's date, amount, or description until you uncheck it (if the reconciliation is still in progress) or remove the reconciliation session that includes it.

Once you finish a reconciliation, Ambrook also locks the date and amount of every transaction in that period and earlier, including ones you left unchecked. You also can't delete a reconciled transaction until you remove the reconciliation session that includes it.

Completed reconciliations can't be edited. To change a completed reconciliation's dates or ending balance, remove it and reconcile that month again.

You can't unreconcile a single transaction in a completed reconciliation. Removing a session unreconciles every transaction in it.

Removing a reconciliation session

  1. Go to Reports > Reconciliation.

  2. Open the account's reconciliation history.

  3. Click the three dots next to the session you want to remove.

  4. Click Remove, then click Delete Reconciliation to confirm.

When you remove a session its transactions are marked unreconciled, and you'll need to reconcile them again. This can't be undone. Additionally, any bank statement attached to it is removed.

TIP: Before removing a completed session, download its reconciliation report so you keep a record of what was reconciled.

Fixing a transaction in an earlier month

If the transaction you need to change is in a month you've already reconciled, and later months are reconciled too:

  1. Remove the reconciliation sessions for that month and every month after it, starting with the most recent.

  2. Edit the transaction.

  3. Reconcile each month again in order, starting with the month you fixed.

If you're only correcting a transaction within its own month, your later months should match their statements again when you re-reconcile them. If you move a transaction into a different month, start from the earlier of the two months.

Changing the account's Starting Balance or Starting Date

  1. On the Accounts page, click the account and scroll to Details.

  2. Click the Starting Date or Starting Balance value to edit it, then Confirm.

You usually don't need to remove your reconciliations first. Changing the account's Starting Balance only affects your first reconciliation, and only while it's in progress. Completed reconciliations keep the balances they were finished with, and later reconciliations start from the previous reconciliation's ending balance.

You'll need to remove reconciliations first if:

  • You're moving the Starting Date later than a reconciliation you've completed. Ambrook won't save the change and will show which reconciliation is in the way. Remove it, starting with the most recent, then change the date.

  • You also need to edit or delete transactions in a reconciled month, such as an adjustment you added to make up for the old Starting Balance. Follow the steps in Fixing a transaction in an earlier month.

FAQ

Can I edit a completed reconciliation's ending balance?

No, you can't edit a completed reconciliation. Remove it, then reconcile that month again with the correct ending balance.

Can I unreconcile just one transaction?

Not once the reconciliation is completed. If it's still in progress, just uncheck it. Otherwise, remove the reconciliation session that contains it, then reconcile that month again.

Why did the Starting Balance at the top of my reconciliation change?

The Starting Balance at the top of a reconciliation can change while the reconciliation is still in progress. Once you finish a reconciliation, its balances don't change.

  • If it's your first reconciliation on the account, it changes when the account's Starting Balance or Starting Date changes, or when a transaction dated before the session is added, edited, deleted, excluded, or included.

  • If it's a later reconciliation, it changes when the previous completed reconciliation is removed. It then comes from the reconciliation before that one, or from the account's Starting Balance if no earlier reconciliations remain.

Did this answer your question?