Enhanced interface

Create a rule set

A rule set is a container for matching and creation rules. Rules determine how to match incoming bank transactions or create new transactions in Sage Intacct for reconciliation.

Create rule sets at the same level in which the bank account was created and the same level that you perform reconciliations. For example, if a bank account was created within an entity, create rule sets at the entity level. Set up different rule sets for bank accounts and credit card accounts.

In a rule set, the most specific matching rule needs to run first. Make sure that any creation rules run last. The rule set first matches any existing Intacct transactions to bank transactions before it attempts to create anything new.

Rule prioritization example

Within a rule set, group matching rules first, and group creation rules last.

Matching rules

Order	Range	Using filters	Match on amount	Match on document number	Match on exact date	Match on date within
1	Narrow	Yes	Required	Yes	Yes	No
2	Narrow	Yes	Required	Yes	Yes	No
3	Narrow	Optional	Required	Yes	No	within 3 days
4	Wide	Optional	Required	No	Yes	no
5	Wide	Optional	Required	No	No	within 3 days

Creation rules

Order	Range	Filter on bank transactions	Filter on Intacct transactions	Using multiple filters
6	Narrow	Yes	Yes	Yes
7	Narrow	Yes	Yes	No
8	Narrow	Yes	No	Yes
9	Wide	Yes	No	No

Video

Subscription	Cash Management
Regional availability	All regions
User type	Business
Permissions	Bank transactions rule sets: Add

Go to Cash Management > Setup > Reconciliation rules and select Add (circle) next to Rule sets.
Enter an ID, a Name, and a Description.

Learn best practices for Name and ID creation.
Select the Account type.

You can use this rule set for Bank accounts or Credit card accounts, but not both.
In the Rules section, select Select rules.

Or, select New rule to create a new rule.

You can add up to 9999 rules.
On the Select rules page, select the rules you want to add.
Select Add and close.
Prioritize which rule to run first by using the Move icon to drag and drop rules within the table.
On the Accounts tab select Select accounts to apply the rule set to an account.

The accounts that appear for selection are determined by the Type you selected on the Rule Set tab.
Select Save.

Next step: Apply the rule set to an account.

On this page