Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Troubleshooting: Automatic Bank Statement Reconciliation Processes

Troubleshooting: Automatic Bank Statement Reconciliation Processes

First-notice item reconciliation doesn't run after automatic bank reconciliation.

Automatic bank reconciliation completes using matching rules but not the first-notice rules. Workday displays first-notice items as unreconciled on these tasks and reports:
  • Manage Bank Reconciliation Exceptions
  • Manual Bank Reconciliation
  • View Bank Statement
  • View Bank Statement Line
You've more than 50 first-notice rules in the first-notice item rule set.
For a single bank account, you can remove any rules in the first-notice item rule set that aren't applicable for the bank account.
  1. Access the
    View Bank Reconciliation and First Notice Item Rule Sets
     report.
    Select the first-notice item rule set to edit.
    Security:
    Set Up: Bank Reconciliation
     domain in the Banking and Settlement functional area.
  2. Delete any rules that you don't need from the complete list of rules. You can also reorder the remaining rules in the rule set as needed. Workday reconciles items using the rules in specified order.
  3. Run first-notice reconciliation either automatically or manually.
For multiple bank accounts, you can create additional first-notice item rule sets to customize for each bank account. This enables you to reassign the same rules to different rule sets, or add new rules.

Matching rule doesn’t match check numbers with leading zeros on the bank statement lines.

Workday only matches bank statement line fields with leading zeros to corresponding reconcilable items with leading zeros.
Create a parsing rule set to parse the leading zeros from the check number field on your bank statements.
You can assign the same parsing rule set to multiple bank accounts. If the criteria to parse leading zeros varies across accounts, you can create a different parsing rule set for each account. Example: The string of leading zeros displays in different start positions across your bank statements. For each bank account, you create a customized rule set that parses the string of zeros from its distinct start position.
You can use this solution when you don't need the leading zeros for reporting purposes or to sync with third-party systems.
  1. When you create the parsing rule, select the bank statement line field that contains the check number as your source. To configure the target field, select either:
    • A different bank statement line field. When you parse the leading zeros from
      Source Field
      , Workday moves them to
      Target Field
       while overriding any existing data.
    • The source bank statement line field. When you parse the leading zeros from
      Source Field
      , Workday replaces both
      Source Field
       and
      Target Field
       values with the resulting parsed check number.
  2. Access the
    Edit Matching Rule Set
     task.
    Edit your existing matching rule set for each bank account to add a new matching rule.
    Security:
    Set Up: Matching Rule Set
     domain in the Banking and Settlement functional area.
  3. Create a new matching rule to match bank statement lines based on the parsed source field. You can select this field in either the
    Match On
     grid or in condition rules.
  4. Run parsing.
    You can parse either:
    • Automatically when you import bank statements.
      Workday automatically parses the information from and to the bank statement line fields based on the parsing rule set that you assign to the bank account.
    • Manually when you select
      Run Parsing
       from the related actions menu of an unreconciled bank statement.
  5. Rerun bank reconciliation either automatically or manually.
Create a new matching rule that ignores the leading zeros on check numbers when matching bank statement lines to reconcilable items.
You can use this solution when you need to retain the leading zeros in the reference number field on your bank statement.
  1. Access the
    Edit Matching Rule Set
     task.
    Edit your existing matching rule set for each bank account to add a new matching rule.
    Security:
    Set Up: Matching Rule Set
     domain in the Banking and Settlement functional area.
  2. In the
    Match On
     grid, select:
    • Statement Line Reference Number with Leading Zeros Stripped
       from the
      Bank Statement Line
       prompt.
    • Transaction Reference with Leading Zeros Stripped
       from the
      Reconcilable Item
       prompt.
  3. Run parsing.
    You can parse either:
    • Automatically when you import bank statements.
      Workday automatically parses the information from and to the bank statement line fields based on the parsing rule set that you assign to the bank account.
    • Manually when you select
      Run Parsing
       from the related actions menu of an unreconciled bank statement.
      Security:
      Process: Bank Statement Parsing
       domain in the Banking and Settlement functional area.
  4. Rerun bank reconciliation either automatically or manually.