Reconcile an account transaction without an imported bank statement

If you're missing a bank statement line or can't import it, use Mark as Reconciled to manually reconcile the account transaction.

Mark as Reconciled is only recommended where the original bank statement data can't be imported from the bank, either manually or via a feed.

About Mark as Reconciled

  • When you mark an account transaction as reconciled, Xero creates a new bank statement line to reconcile the transaction against.
  • The new bank statement line displays in the Bank Statement tab of the bank account, and has User in the Source column.
  • You can enable or disable Mark as Reconciled in the Account Transactions tab of any bank account. This turns the feature on or off for all bank accounts for your login only. Each user in the organisation needs to enable this for their own login.
  • If the actual bank statement lines are imported by a feed or manually and Mark as Reconciled is used, duplicate bank statement lines will be created.

Enable Mark as Reconciled

Before you can manually mark a transaction as reconciled, you need to enable the Mark as Reconciled option.

  1. In the Accounts menu, select Bank Accounts.
  2. Click any bank account name.
  3. Click the question mark icon Image of the question mark icon., then select Enable Mark as Reconciled. (If you see Disable Mark as Reconciled, you've already turned this feature on).

Reconcile the account transaction

When Mark as Reconciled has been enabled, you can reconcile the account transaction from the Account Transactions tab of the bank account.

  1. On the Account Transactions tab, select the checkbox for the account transaction you want to reconcile.
  2. Click More, then select Mark as Reconciled.

    Animated image showing mark as reconciled button.

Disable Mark as Reconciled

  1. In the Accounts menu, select Bank Accounts.
  2. Click any bank account name.
  3. Click the question mark icon Image of the question mark icon., then select Disable Mark as Reconciled.

Identify transactions manually marked as reconciled

Account transactions reconciled using Mark as Reconciled have User in the Source column of the Account Transactions tab of the bank account.

Bank statement lines created by manually marking a transaction as reconciled will show in the Bank Statement tab of the bank account, with User in the Source column.

Duplicate bank statement lines

If Mark as Reconciled has been used and the actual bank statement line was also imported, duplicate bank statement lines will be created.

You can identify duplicate bank statement lines on the Bank Statement tab of the bank account. If duplicates have been created, delete the bank statement line generated by using Mark as Reconciled (the one with User as the Source).