Summary
Create bank rules in Sage Accounting to automate the categorisation of incoming transactions.
Resolution
Watch the video
Create a bank rule
- Select Banking, then select Manage bank rules.
- From Bank Account, choose the account you want to use.
- Select Manage bank rules, then Create rule.
- Enter a unique rule name.
- Choose whether the rule applies to Payments or Receipts.
- Select Activate this rule when saving if you want to use the rule immediately.
- Set the conditions the transaction must meet.
- Set the transaction details to apply when the rule matches.
- Select Save. When you add more rules, you can select the priority order of the rule before you Save.
TIP: You can create up to 300 bank rules per bank account.
Conditions
Conditions define which transactions match the rule. Conditions are case-sensitive.
Condition fields
| Field | Description |
|---|---|
| Field | The part of the transaction to check, such as Reference or Amount. |
| Value | How the rule compares the field, such as Equals or Contains. |
Value options
| Value | Description |
| Equals | Matches the value exactly. Use this when the reference or amount never changes. |
| Contains | Matches part of the value. Use this when references vary but include consistent text. |
| Does not contain | Excludes transactions with specific text. Use this to filter out unwanted matches. |
Example
This example shows how to create a rule for a recurring utility payment of £199 by direct debit.
| Field | Value | Description |
| Reference | Equals | Utilities |
| Amount | Equals | 199.00 |
Transaction details
- Transaction type: Other Payment
- Supplier: Utilities
- Method: Credit / Debit Card
- Reference: Utilities Company
- Description: Utilities direct debit
- Ledger Account: Electricity (7200)
- VAT Rate: Lower Rate 5%