Import Rules

Accounting Import Rules Watch full video →

When you upload statements or bring in transactions with Bank Link, Import Rules fill in payees, Categories and Funds for you.

What are Import Rules?

Import Rules are customizable instructions that automate how your church's transactions are processed. Each rule looks for transactions that match something you choose, such as a payee name, and then either fills in details for you or skips the transaction. 

Creating Import Rules

Step 1: On the Accounting dashboard, select the account to open its register, then select Import / Bank Link.

Accounting Import Rules

Step 2: On the Transactions to Review screen, select Actions, then Manage Import Rules.

Accounting Import Rules 2

Step 3: Select Add Rule.

Accounting Import Rules 3

Step 4: Fill in the rule:

  • Type a Name for This Rule: something you'll recognize, like "Electric" or "Office Supplies."
  • Apply this Rule to transactions in: choose the account or accounts this rule should apply to.
  • If an imported transaction matches this criteria: choose what to match (for example, Payee), how to match it (for example, Contains), and type the value to look for (for example, "comcast").

Step 5: Choose what the rule does:

  • Automatically apply the Actions below: fill in details on matching transactions.
  • Automatically skip the transaction (do not import): leave matching transactions out of your register entirely.

Step 6: If you chose to apply actions, fill in any of these:

  • Change the Payee Name/Description to
  • Set the Category to - Set the Fund to 
  • Add Transaction Tags
  • Add a Note

Step 7: Select Add Rule. Your rule applies to transactions the next time you upload a statement or bring in transactions with Bank Link.

Accounting Import Rules 4

Pro Tip: You can also create a rule without leaving the review screen. While reviewing a transaction, select "Edit transaction details" to open the Review Transaction window. Choose the Category and Fund, then check "Create an import rule for this payee." Future transactions from that payee are categorized the same way automatically.

Using Import Rules

The Import Rules screen lists all your rules with their Priority, Name, Accounts, Criteria, and Result. Select Return to Import to go back to the Transactions to Review screen.

Turn a Rule On or Off 

Use the Active switch next to a rule to turn it off without deleting it, or back on again.

Accounting Import Rules 5

Rule Priority 

Rules run in priority order, starting with 1. Once a transaction matches a rule, ChurchTrac applies that rule and moves on to the next transaction. If two rules could match the same transaction, give the more specific rule the higher priority (the lower number).

Accounting Import Rules 6

Re-Apply Rules 

Rules apply when transactions are uploaded or brought in with Bank Link. To apply new or changed rules to transactions already waiting for review, go to the Transactions to Review screen and select Actions, then Re-Apply Rules Now.

Accounting Import Rules 7

Import Rules Examples

Using banking import rules has many benefits. Here are a few examples...

1. Making transactions more readable

Sometimes, the payee/description provided by banks are borderline unreadable or just frankly unpleasant for church bookkeeping! You can create rules to update these automatically.

Accounting Import Rules 8

2. Automatically assigning a Category or Fund

Cut down on the time you spend assigning your transactions to various categories or funds.

Watch our helpful Automating Church Expense Tracking Pro Tip video to see this in action.

Accounting Import Rules 9

3. Assigning Transaction Tags

Transaction Tags are very useful in church bookkeeping for specifying income and expenses beyond Categories. These are commonly used for tracking benevolence, missions, and sources of giving.

Accounting Import Rules 10

4. Skipping transactions you've already recorded

If you already record certain transactions another way, such as giving deposits created from the Giving screen, create a rule that automatically skips them so they aren't added to your register twice.

Accounting Import Rules 10 (1)