How bank rule conditions work
Xero uses conditions you set to match against the information on your imported bank statement lines to decide when to apply the rule. Your rule may be simple, with only one or two conditions, or complex, with multiple conditions that evaluate several pieces of information.
The conditions explained
Every bank rule must have at least one condition, but you can add as many as you need to build the rule.
If you create a bank rule when you're reconciling or cash coding, Xero will automatically add conditions based on the statement line, using an equals comparison. Any conditions that you add will also use information from the statement line if possible.
What's the difference between Any and All?
- All - The rule is applied only when every condition is met. If one condition doesn't match, then the rule will not run. This makes the rule more restrictive.
- Any - The rule is applied if only one of the conditions is met. The rule won't fail just because one or more conditions doesn't match. This makes the rule less restrictive.
Condition fields explained
You can select an individual text field, such as Payee, and Xero will apply the rule if that particular field meets the condition.
If you select Any text field, Xero will search the Payee, Description, Reference and Analysis Code fields on the bank statement line. Xero will apply the rule if one of the fields meets the condition.
|equals||The condition has to exactly match the selected text field of the bank statement line.|
|contains||The selected text field in the bank statement line has to contain the value(s) entered.|
|starts with||The selected text field in the bank statement line has to start exactly the same as the value(s) entered.|
|is blank||The selected text field in the bank statement line must be blank|
For the comparison options equals, contains or starts with, enter the relevant value(s) to meet the condition.
For example, for the condition below, the bank rule would be applied if either the description or reference text fields in the bank statement line contained the word 'Energy'.
Allocating line items
Allocating fixed value line items (optional) and the remainder
You can set up your bank rule to allocate one or more fixed-value portions of the transaction to an account in your Chart of Accounts.
After you've set up any fixed value allocations, you need to tell Xero what to do with the balance of the transaction. You can allocate the remainder to one account in your Chart of Accounts or split it between two or more. You can also assign a tracking category to these lines if you wish.
For example, if you make personal toll calls on your business telephone, you may want to allocate the base charge to Telephone & Internet. Then you can separate out the personal and business calls when you reconcile the transaction each month.
the Amount of a fixed value allocation as either a positive or negative number with up to two decimal places
the Percent of a remainder allocation as either a positive or negative number with up to two decimal places
Add a comments placeholder
If you've started a discussion in the bank reconciliation, you can use the text from it by adding the Comments placeholder to your bank rule. Use the placeholder in the Description field of a fixed or remainder allocation. Placeholders have square brackets around them, for example [Comments].