Skip to main content

Manage Transaction Import Rules

  • Updated

Contents

 

Rules are part of the Transactions import process  within ChMeetings Accounting. 

If the transactions you want to import to ChMeetings Accounting must belong to specific Categories, Funds, or Payees, you can save time by setting up Rules before import. When applied, these Rules will automatically allocate imported transactions to the corresponding Categories or Funds, depending on the criteria you set. 

Import Rules apply to both manually imported transactions, and to those imported directly from your bank account, if linked. 

Add a New Rule

To add a new Import Rule, go to Accounting > Accounts > Financial Accounts, and select the Account to which you want to import transactions. 

On your account page, click Manage Rules.


 

In the Manage Rules window, click Add Rule.

 

In the Add Rule window, configure the following: 

  1. Name your Rule.
  2. Select the Type of transactions it should filter for.
  3. Select the Rule’s Criteria. You can create the following logical operations:
    1. “Description contains / does not contain / is exactly ….” This option matches with the “Description” or “Memo” fields in your import files. In the text field, enter the text by which you want to filter transactions. For example, if we want to assign book-related expenses to the Book Purchase Category and the Library Fund, then we will filter transactions by the word “book”. The text field is not case-sensitive and only accepts single items. Logical operators are not supported. 
    2. “Amount equals / does not equal / is greater than / is less than …” This field matches the transaction amount in your import file.
  4. Select an Action: Here is where you have two options: 
    1. Automatically apply these actions below, which lets you set the Category, Fund, and Payee to allocate the transaction to, once imported. You can also add a note to transactions imported via the rule. Notes are imported as line item notes (not as transaction memos). If an imported item already contains a note, then the rule will NOT overwrite it. 
    2. Skip the transaction (do not import), which will result in transactions being omitted from the import if they meet the rule criteria. 
  5. Save when ready.

Rule Options

Once your rule is saved, you will see it listed in the Manage Rules window. Here is where you can access the following options: 

  • Search existing rules by any keyword.
  • Toggle the Rule on or off () to enable or disable it. Once you’ve done so, click Save to enforce your rule change. 
  • Edit the rule I✐) 
  • Delete the rule (🗑). Note that deleted rules cannot be restored. 
  • Change the rule order by moving them up or down the list. (⠿)

Any imported transactions that match the rule will automatically be subject to the rule’s actions, and be assigned to the corresponding Category, Fund, and Payee, and/or have a line item note added if none exists, as set by the Rule.


 

Related articles