Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Parse Bank Statements

Parse Bank Statements

Security: These domains in the Banking and Settlement functional area:
  • Process: Bank Statement Parsing
  • Set Up: Bank Statement Parsing
You can parse data from bank statement line fields to streamline automatic bank statement reconciliations and enhance reporting. Bank statement line fields such as the addenda often contain key values in an unstructured format. Create a parsing rule set to identify, extract, and copy these values to the same or other statement line fields to use in reconciliation condition rules and highlight in reports.
  1. Access the
    Create Parsing Rule Set
     task.
  2. As you complete the task, consider:
    Option Description
    Order
    Place the most specific rules before broader rules that require less precision for the parsing.
    You can create up to 50 rules for a parsing rule set. If you’ve more than 50 parsing rules, consider creating multiple rule sets that are particular to the different bank accounts.
    Source Field
    Target Field
    Workday extracts and copies the string of data from the source field to the target field, overriding any existing data.
    You can select a field as both the source and target to change the field value to the parsed data string. Example: Select
    Addenda
     as the source and target field to replace its string of concatenated values with only the parsed supplier name.
    Parsing Type
    To determine how to parse content from the source field, select:
    • Parse by Delimiter
       to extract data between starting and ending delimiters. You can enter either a text string or a character, such as an asterisk (*) or pipe (|), as a delimiter. Select the
      Use Space as Starting Delimiter
       and
      Use Space as Ending Delimiter
       check boxes to use spaces as starting and ending delimiters. Example: ValueA
      space
       ValueB.
      If there's another delimiter of the same type in the field, specify its occurrence.
      Example: To parse a store number that displays between the second and third pipe symbol, enter | as the
      Starting Delimiter
       and
      2
       as the
      Starting Delimiter Occurrence
      . Then, enter | as the
      Ending Delimiter
       and
      3
       as the
      Ending Delimiter Occurrence
      .
    • Parse by Exact Match
       to extract a specific phrase or text string.
      Example: You enter
      Dell
       for the supplier name as
      Matching Text
      . Workday parses the source field content
      17-inch Dell XPS laptop computer
       and matches the supplier name you entered. Workday then copies
      Dell
       to the target field.
    • Parse by Position
       to extract data from a start position to an end position.
      Example: To extract the first 6 digits of a payment reference number, enter
      1
       as the
      Start Position
       and
      6
       as the
      End Position
      .
  3. (Optional) Configure parsing rule conditions to filter the particular bank statement lines, such as by type code or addenda value, to apply the parsing rules. You can also leverage the condition rule framework to define advanced filter criteria.
  4. (Optional) To test the parsing rule before running bank statement parsing, click
    Test
    . Copy the complete source field value from a bank statement line to the
    Parsing String
    .
    This test returns the parsing results based on each rule defined in the set.
  5. Assign the parsing rule set to a company bank account.
When you import a bank statement, Workday automatically parses the information from and to the bank statement line fields based on the parsing rule set associated with the bank account. This process occurs before automatic bank statement reconciliations and reporting.
Note that if you create a parsing rule with a starting and ending delimiter and then import a bank statement with only 1 of the delimiters, Workday doesn't parse the bank statement. To return partial matches based on only 1 of the delimiters, create an additional rule with either a starting or ending delimiter.
To manually run a parsing job, select
Run Parsing
 from the related actions menu of an unreconciled bank statement.
You define a parsing rule that extracts the payment reference number from the
Addenda
 field and adds it to the
Reference Number
 field on the bank statement lines. This enables you to identify payments by their reference number on bank reconciliation reports.
  • To clear any incorrectly parsed data, select
    Clear Parsing
     from the related actions menu of a bank statement. Workday restores the original field values on all affected bank statement lines. You can edit your parsing rule, and then manually rerun the parsing job on the bank statement.
    To clear parsing for values that you used for reconciliation, you must unreconcile the bank statement lines first.
  • Configure condition rules to reconcile bank statement lines or first-notice items based on the new target field values.
  • To report on your payments by a parsed value, build custom reports using the target report field containing the parsed data.