Matching rule examples

Learn how to set up some commonly used matching rules and rule sets.

Keep in mind that a rule set can be used for credit card accounts or bank accounts but not both. You need to set up different rule sets for bank accounts and credit card accounts.

Create a simple matching rule to match transactions by date and amount.

  1. Go to Cash Management > Setup > Reconciliation rules and select Add (circle) next to Matching and creation rules.

  2. In the Type dropdown list, select Match rule.

  3. Enter an ID and a Name.

    Learn best practices for Name and ID creation.

  4. Create a matching condition for Amount.

    All matching rules require a matching condition for Amount.

    1. Scroll down to the Matching conditions section.
    2. In the Bank transaction field dropdown list, select Amount.
    3. In the Operator dropdown list, select Equals.
    4. In the Match this field in an Intacct transaction dropdown list, select Amount.

  5. In the next row, create another matching condition for the posting date.

    1. In the Bank transaction field dropdown list, select Posting date.
    2. In the Operator dropdown list, select Equals.
    3. In the Match this field in an Intacct transaction dropdown list, select Posting date.

  6. Select Save.

Next step: When you're ready, add the rule to a rule set. Then, apply the rule set to an account.

Some bank feed transactions have extra zeroes preceding the document number. Create a rule set to ignore these zeroes and match transactions.

Leading zeroes on Intacct transactions are automatically ignored.

  1. Go to Cash Management > Setup > Reconciliation rules and select Add (circle) next to Matching and creation rules.

  2. In the Type list, select Match rule.

  3. Enter an ID and a Name.

    Learn best practices for Name and ID creation.

  4. Create a matching condition for Amount.

    All matching rules require a matching condition for Amount.

    1. Scroll down to the Matching conditions section.
    2. In the Bank transaction field dropdown list, select Amount.
    3. In the Operator dropdown list, select Equals.
    4. In the Match this field in an Intacct transaction dropdown list, select Amount.

  5. In the next row, create another matching condition for the document number.

    1. In the Bank transaction field dropdown list, select Document number (leading zeroes removed).
    2. In the Operator dropdown list, select Equals.
    3. In the Match this field in an Intacct transaction dropdown list, select Document number.

  6. Select Save.

Next step: When you're ready, add the rule to a rule set. Then, apply the rule set to an account.

You can set up a matching rule to group multiple Intacct transactions to one bank transaction, or vice versa. For example, you might have customer payments that were recorded as multiple Intacct transactions but correspond to one ACH payment at the bank.

  1. Go to Cash Management > Setup > Reconciliation rules and select Add (circle) next to Matching and creation rules.

  2. In the Type list, select Match rule.

  3. Enter an ID and a Name.

    Learn best practices for Name and ID creation.

  4. Optionally, you can choose to filter for only credit type transactions to target the ACH payments.

    1. In the Filter transaction by section, in the Data source dropdown list, select Intacct transactions.
    2. In the Field dropdown list, select Transaction type.
    3. In the Operator dropdown list, select Equals.
    4. In the Value dropdown list, select Credit.

  5. In the Group transactions by section, select to group Intacct transactions by Document number.

    If you know these transactions post on the same date, you can select to group by Posting date.

  6. Create a matching condition for Amount.

    All matching rules require a matching condition for Amount.

    1. Scroll down to the Matching conditions section.
    2. In the Bank transaction field dropdown list, select Amount.
    3. In the Operator dropdown list, select Equals.
    4. In the Match this field in an Intacct transaction dropdown list, select Amount.

  7. Select Save.

Next step: When you're ready, add the rule to a rule set. Then, apply the rule set to an account.

On the Bank transactions page, you can view the Document type of each transaction. This might be something like CHECK, DEBIT, or XFER (Transfer).

  1. Go to Cash Management > Setup > Reconciliation rules and select Add (circle) next to Matching and creation rules.

  2. In the Type list, select Match rule.

  3. Enter an ID and a Name.

    Learn best practices for Name and ID creation.

  4. In the Filter transaction by section, enter information about how to filter transactions.

    1. In the Data source dropdown list, select Bank transactions.
    2. In the Field dropdown list, select Document type.
    3. In the Operator dropdown list, select Equals.
    4. In the Value field, enter the value exactly as it appears on the bank transaction.

  5. Create a matching condition for Amount.

    All matching rules require a matching condition for Amount.

    1. Scroll down to the Matching conditions section.
    2. In the Bank transaction field dropdown list, select Amount.
    3. In the Operator dropdown list, select Equals.
    4. In the Match this field in an Intacct transaction dropdown list, select Amount.

  6. Create any other matching conditions as needed.

  7. Select Save.

Limit transactions to be considered for matching by using filters. For example, you might want to look only at debit type transactions that exist in Intacct.

  1. Go to Cash Management > Setup > Reconciliation rules and select Add (circle) next to Matching and creation rules.

  2. In the Type list, select Match rule.

  3. Enter an ID and a Name.

    Learn best practices for Name and ID creation.

  4. In the Filter transaction by section, enter information about how to filter transactions.

    1. In the Data source dropdown list, select Intacct transactions.
    2. In the Field dropdown list, select Transaction type.
    3. In the Operator dropdown list, select Equals.
    4. In the Value dropdown list, select Debit.

  5. Create a matching condition for Amount.

    All matching rules require a matching condition for Amount.

    1. Scroll down to the Matching conditions section.
    2. In the Bank transaction field dropdown list, select Amount.
    3. In the Operator dropdown list, select Equals.
    4. In the Match this field in an Intacct transaction dropdown list, select Amount.
  6. Create any other matching conditions as needed.

  7. Select Save.

Next step: When you're ready, add the rule to a rule set. Then, apply the rule set to an account.

You might have transactions from the bank that contain important information in the description field, like the cheque number or document number. Set up a rule to identity these transactions and match them to Intacct transactions.

  1. Go to Cash Management > Setup > Reconciliation rules and select Add (circle) next to Matching and creation rules.

  2. In the Type list, select Match rule.

  3. Enter an ID and a Name.

    Learn best practices for Name and ID creation.

  4. Optionally, in the Filter transaction by section, enter information about how to filter transactions.

  5. Create a matching condition for Amount.

    All matching rules require a matching condition for Amount.

    1. Scroll down to the Matching conditions section.
    2. In the Bank transaction field dropdown list, select Amount.
    3. In the Operator dropdown list, select Equals.
    4. In the Match this field in an Intacct transaction dropdown list, select Amount.

  6. Create a matching condition that matches on the description field.

    1. In the Bank transaction field dropdown list, select Description.

    2. To match to an exact description, in the Operator dropdown list, select Equals .

      Or to filter for descriptions that include a specific value, phrase, or word, in the Operator dropdown list, select Contains.

    3. In the Match this field in an Intacct transaction dropdown list, select Description.

      If you select Equals in the Operator dropdown list, this value is case sensitive. Otherwise it's not case sensitive.

  7. Select Save.

Next step: When you're ready, add the rule to a rule set. Then, apply the rule set to an account.

You might be banking with an institution that's in a different time zone than where your business is located. Create a matching condition to account for a difference in posting dates.

  1. Go to Cash Management > Setup > Reconciliation rules and select Add (circle) next to Matching and creation rules.

  2. In the Type list, select Match rule.

  3. Enter an ID and a Name.

    Learn best practices for Name and ID creation.

  4. Optionally, in the Filter transaction by section, enter information about how to filter transactions.

  5. Create a matching condition for Amount.

    All matching rules require a matching condition for Amount.

    1. Scroll down to the Matching conditions section.
    2. In the Bank transaction field dropdown list, select Amount.
    3. In the Operator dropdown list, select Equals.
    4. In the Match this field in an Intacct transaction dropdown list, select Amount.

  6. Create a matching condition for a range of posting dates.

    1. In the Bank transaction field dropdown list, select Posting date.
    2. In the Operator dropdown list, select Within .

    3. In the Value field, enter the number of days in which the posting date can occur.

      For example, you can enter 1 to have bank transactions match within 1 day before and 1 day after the Intacct transaction's posting date.

    4. In the Match this field in an Intacct transaction dropdown list, select Posting date.

  7. Select Save.

Next step: When you're ready, add the rule to a rule set. Then, apply the rule set to an account.