Find a group of transaction lines using Find & Recode

Begin recoding by searching for a group of transaction lines that match one or more conditions. You can also define conditions to exclude transaction lines.

Recoding can result in significant changes to accounts and reports. We recommend you only use Find & Recode if you are an accountant or bookkeeper, or have experience with recoding.

Search for transaction lines

To find a group of transaction lines in Xero:

  1. In the Advisor menu, select Find & Recode.
  2. Click Find & Recode.
  3. Select All to search for transaction lines that match several conditions at once. Select Any to search for transaction lines that match at least one of the conditions you specify.
  4. Click Add a condition, then select a search condition from the list. If you've created tracking options, they will appear at the bottom of the list.
  5. Enter details for the search condition you’ve selected.

    To find transaction lines that haven’t been assigned a tracking category, select Unassigned from the list displayed for tracking.

  6. To add another, click Add a condition. To remove a condition, select Image of delete icon. next to the condition you’d like to remove.
  7. Click Search. You can now recode transaction lines.

Search conditions

You can search for transaction lines matching or excluding one or more of the following conditions.

CategorySearch Conditions
TypeAll supported transaction types.
Status

All transactions lines with statuses matching Draft, Awaiting Approval, Awaiting Payment and Paid.

When you search for Awaiting Payment transactions the search results will include transaction lines for spend money and receive money.

AccountCan't search accounts receivable, accounts payable, unpaid expense claims, tracking transfers, bank revaluations, unrealized currency gains and bank accounts.
DateTransaction lines created on a specific date or within a certain date range. You can't search for transaction lines created prior to a lock date, unless lock date was set for all users except advisors.
Transaction totalAmounts equal to, less than or more than a specific transaction total.
Tax rateAll active and archived tax rates.
Entered byUser that created the transaction.
ContactActive contacts, but not archived contacts.
TrackingIf you've created a tracking category tracking category. You can also search for transaction lines that haven't been assigned a tracking category.
InventoryUntracked inventory can be searched for and recoded, tracked inventory can't be searched for or recoded.