Find transactions to match to bank statement lines | No Stress Accounting Knowledge Base

ⓘ This article is for small businesses who use Xero

Overview

Search for unreconciled transactions or reconcile a statement line with multiple items.
Account for bank fees or make an adjustment during reconciliation.
Create an additional transaction to account for part of a payment.

How it works

What you need to know

Find and match is a feature of bank reconciliation. It helps you find an invoice, bill or account transaction that's already entered in Xero, but not showing as a suggested match for the relevant bank statement line.

Use find and match to:

Search for an unreconciled invoice, bill or account transaction
Reconcile a statement line with more than one invoice, bill or account transaction
Account for bank fees incurred as part of a transaction, or adjust the transaction to account for a small rounding or human error
Create additional transactions to account for a payment that totals more than the transaction already entered into Xero
Record a part payment of an invoice or bill

Find and match shouldn’t be used to reconcile a prepayment or deposit payment that relates to an invoice or bill that hasn’t been created in Xero. You should record a prepayment instead.

If you receive a payment that’s substantially more than the amount due, record an overpayment.

Access find and match

You can access find and match from the bank reconciliation screen:

Next to any reconciliation line, click Find & Match
Under any suggested match, click [number] other possible match found

1 other possible match found' link in the Match tab

Match a statement line to one or more transactions

Web

iOS

Android

If the transaction you want to reconcile a bank statement line with isn’t showing as a suggested match, or you want to match a statement line with multiple transactions:

For the relevant bank statement line, click Find & Match.
To find the transactions, search by name or invoice number. You can also search the amount, reference or cheque number, or click the column heading to change the display order.
To select both spent and received transactions, select either the Show Received Items or Show Spent Items checkbox.
Select the checkbox for each transaction you want to reconcile with the statement line.
Click Reconcile.

From your dashboard, tap the bank account you want to reconcile. Bank accounts with unreconciled transactions show an orange dot.
Find the statement line to reconcile. Swipe up or down to see different lines.
Tap the options icon , then tap Find and match.
(Optional) To reconcile both spent and received amounts against the statement line, tap Spent or Received, then select All Items.
Find the Xero transactions that match the statement line. You can swipe up and down, or search for specific transactions.
Tap the checkbox next to each transaction to select it.
Once the amounts equal, tap Match to reconcile.

From your dashboard, tap the bank account you want to reconcile. Bank accounts with unreconciled transactions show an orange dot.
Find the statement line to reconcile. Swipe up or down to see different lines.
Tap the options icon , then tap Find and match.
(Optional) To reconcile both spent and received amounts against the statement line, tap Spent or Received, then select All items.
Find the Xero transactions that match the statement line. You can swipe up and down, or search for specific transactions.
Tap the checkbox next to each transaction to select it.
Once the amounts equal, tap Match to reconcile.

Create a new transaction to account for part of the statement line

Create a new transaction when the bank statement line includes payment for an item that’s not included on the invoice, bill or expense claim you’re reconciling it with.

Only do this if you don’t intend to create an invoice, bill or expense claim for this payment because the item is considered a cash transaction.

Web	iOS	Android
For the relevant bank statement line, click Find & Match. Select the checkbox for the existing invoices or bills the payment relates to. Search for the transaction by name, reference or amount. Click New Transaction, then select Receive Money or Spend Money to account for the remaining amount. Enter details for the amount not yet invoiced or billed, then click Save Transaction. Click Reconcile.	For the relevant bank statement line, tap the options icon , then tap Find and match. Select the existing transaction it relates to. Tap the add icon , then complete or edit the fields for the adjustment transaction. Tap Save, then tap Match.	For the relevant bank statement line, tap the options icon , then tap Find and match. Select the existing transaction it relates to. Tap the add icon , then complete or edit the fields for the adjustment transaction. Tap Save, then tap Match.

Add a bank fee to the transaction

If a statement line includes a small fee, such as cash handling, add a bank fee adjustment during reconciliation.

Web	iOS	Android
For the relevant bank statement line, click Find & Match. Select the checkbox for the transaction you want to match. Click Adjustments, then select Bank fee. Enter the bank fee details. Click Reconcile.	For the relevant bank statement line, tap the options icon , then tap Find and match. Select the existing transaction it relates to. Tap Make an adjustment, then select Bank Fee. Complete the fields for the bank fee adjustment. Tap Done, then tap Match.	For the relevant bank statement line, tap the options icon , then tap Find and match. Select the existing transaction it relates to. Tap Make an adjustment, then select Bank fee. Complete the fields for the bank fee adjustment. Tap DONE, then tap Match.

Make a minor reconciliation adjustment for a small error

Create a minor adjustment when a statement line doesn't quite match the transaction in Xero due to a rounding or human error.

When you make a minor adjustment, Xero posts a reconciliation adjustment to the system rounding account.

To create a minor adjustment:

Web	iOS	Android
For the relevant bank statement line, click Find & Match. Select the checkbox for the transaction you want to match. Click Adjustments, then select Minor adjustment. Enter the adjustment amount. Click Reconcile. View the reconciliation adjustment in the Account Transactions tab for the bank account.	For the relevant bank statement line, tap the options icon , then tap Find and Match. Select the existing transaction it relates to. Tap Make an adjustment, then select Minor Adjustment. If the adjustment amount is: More than 1.00, enter the amount, then tap Confirm Less than 1.00, Xero automatically calculates and adds the amount Tap Match. View the reconciliation adjustment in the Account Transactions tab for the bank account.	For the relevant bank statement line, tap the options icon , then tap Find and match. Select the existing transaction it relates to. Tap Make an adjustment, then select Minor adjustment. If the adjustment amount is: More than 1.00, enter the amount, then tap Confirm Less than 1.00, Xero automatically calculates and adds the amount Tap Match. View the reconciliation adjustment in the Account Transactions tab for the bank account.