Field descriptions: Rules

Type

 The type of rule you are creating.

Matching rules automatically match incoming transactions from a bank feed to transactions in Sage Intacct.

Creation rules automatically create transactions from bank data to match for reconciliation in Sage Intacct.

ID

Enter an ID for the rule. After you save, this field cannot be edited.

Learn best practices for Name and ID creation.

Name

Enter a name for the rule.

Learn best practices for Name and ID creation.

Description

Enter a description for the rule.

Status

The default value is Active.

Instead of deleting a rule, you can deactivate it. Inactive rules can remain in a rule set but they do not have any effect.

Data source

Filters are optional for matching rules. They can be used to define which transactions the rule will consider when attempting to make a match. You can filter by Bank transactions or Intacct transactions.

You can only filter by bank transactions for creation rules. Creation rules require a filter for bank transaction posting dates.

See filtering examples.

Field

Determine the field to include in results.

When the data source is Intacct transactions, select from the following:

• Transaction type
• Document number
• Document date
• Transaction amount
• Base amount
• Transaction currency
• Base currency
• Posting date
• Description

When the data source is Bank transactions, select from the following:

• Account type
• Amount
• Amount to match
• Bank account ID
• Bank name
• Bank reference number
• Category
• Category ID
• Currency
• Customer ID
• Customer name
• Date added
• Description
• Detailed feed type
• Document number
• Document type
• Extended description
• Feed type
• File name
• Import ID
• Match sequence
• Payee
• Payee account
• Payee address
• Payee city
• Payee ID
• Payee postal code
• Payee state
• Posting date (required for creation rules)
• Reconciliation date
• Reconciliation status
• Record URL
• Short description 1
• Short description 2
• Subcategory
• Transaction ID
• Transaction type

Operator

Depending on the field you select, options include the following.

• Equals
• Contains
• Does not contain
• Is less than
• Is greater than
• Begins with
• Ends with

Value

After you select a field to filter transactions by, relevant options are available for you to select.

If you filter by a text field, for example by Amount, Document number, or Description, enter that value here.

Intacct transactions

For matching rules only. Grouping is optional.

A rule first considers the results of any defined filters, then attempts to create a group. For example, you have a group of Sage Intacct transactions that corresponds to a single transaction at the bank that appears on a specific day.

Select to group existing Intacct transactions by the following:

• Document number
• Posting date

Bank transactions

Select to group bank transactions by the following:

• Document number
• Posting date

Bank transaction field

Options include the following.

• Document number
• Posting date
• Description
• Amount

• Document number (leading zeroes removed)

  Intacct automatically ignores leading zeroes on Intacct transactions.

• Amount (combine debits and credits)

Operator

Select an operator by which to match transactions. Depending on the selected Bank transaction field options, you can choose from the following.

• Contains
• Less than
• Equals
• Begins with
• Within

Value

After you select a Bank transaction field, relevant options are available for you to select.

If you selected to filter by a text field, for example by Amount, Document number, or Description, enter that value here.

Match with this field in an Intacct transaction

Options include the following:

• Document number
• Posting date
• Description
• Amount
• Amount (combine debits and credits)

Transaction type

Select the type of transaction to create.

Options include the following.

• Journal entry

• Credit card transaction

Transaction template

Add or select a transaction template. Transaction templates define how to create new transactions.