Create bank feeds matching rules

Transaction matching is a useful feature of IRIS Elements Cashbookthat allows you to automate the process of invoices, purchases, or transactions based on data imported from your bank feed.

You can create rules that specify certain criteria, such as the description of the transaction or the customer or supplier involved, and then IRIS Elements Cashbook will search for matching transactions and automatically create the necessary invoices, purchases, or transactions. In this way, transaction matching can save time and reduce errors.

To create custom rules to match bank feeds:

1. Go to Banking > Banks

2. For the appropriate account, from Bank Feeds select Import.

3. Select Matching Rules.

4. Select Add matching rule. The Add matching rule.

5. Enter a name for the new rule and select if this should apply to money in, money out, or both.

   You can select Disabled if you want to turn off a matching rule without deleting it.

6. From Select condition logic choose how the rule will handle multiple conditions. Select AND from the list and all conditions must be met to match. Select OR and the transaction will match if any of the conditions are met.

7. Select Add another condition to build a list of up to 5 conditions to check when matching transactions. Select the field, condition and term to check.

• Description: The text description of the transaction will be checked to see if it meets the criteria entered in Search term.

  • Conditions for description fields:

    • Containing: The description contains the text entered in Search term anywhere within the text.

    • Not containing: The description does not contains the text entered in Search term anywhere within the text.

    • Beginning with: The description starts with the text entered in Search term anywhere within the text.

    • Ending with: The description ends with the text entered in Search term anywhere within the text.

• Amount: The value of the transaction will be checked to see if it meets the criteria entered in Search term.

  • Conditions for amount fields:

    • Equal to the search term value.

    • Not equal to the search term value.

    • Greater than the search term value.

    • Less than the search term value.

    • Greater than or equal to the search term value.

    • Less than or equal to the search term value.

8. Select the Action to apply when a transaction is matched. Choose to create a Sales invoice, Purchase invoice, Expense or Bank transaction. Depending on which option you select you have further options to configure, such as which supplier to use or bank code to assign, etc.

9. Complete the form to set the appropriate behaviour, then select Save.

System rules are matched first, followed by custom rules in the order they appear in the list.