Creating statement parsing rules

Use the statement parsing rule to determine how bank statement lines are parsed. This rule defines the criteria and parsing options to extract and retain specific values or character strings for accurate grouping and processing of bank statement line data. This data is used for downstream processes such as reporting, or the data is used with Reconciliation Match Rules.

  1. Select Statement Parsing Rules.
  2. Click Create.
  3. Specify a Statement Parsing Rule name and Description.
  4. Specify the custom group to define the condition used to select the bank statement lines.
    See Custom groups.
  5. In Parsing Options, specify this information:
    Literal Value
    Specify the exact text or numeric value to populate the field.
    Remove Character String
    Select this check box and specify a character string to remove.
    Remove Character String and Preceding Characters
    Select this check box and specify the character string to remove. All preceding characters are also removed.
    Remove Character String and Subsequent Characters
    Select this check box and specify the character string to remove. All subsequent characters are also removed.
    Include Character String in Range
    Select this check box to extract and retain the specified string within a range of character positions.