Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2026-03-13
Create Customer Payment Rule Set

Create Customer Payment Rule Set

  • Configure bank accounts for the company.
  • Security:
    Set Up: Customer Accounts
     domain in the Customer Accounts functional area.
You can define rules to filter bank statement lines, copy the lines to customer payment, and auto populate the payment and deposit fields. We recommend that you:
  • Arrange the rule lines in the desired processing order.
  • Refrain from making the rule sets too restrictive for easier matching.
  • Don't set up a separate rule for every remit-from customer.
Configure your customer payment rule set so as to exclude these items:
  • Intercompany receipts.
  • Lockbox payments.
  • Sponsor payments recorded through the
    Letter of Credit Draw Down Event
     business process.
For a bank statement line to be eligible for creating a customer payment and deposit, ensure that:
  • The bank statement line is a credit.
  • The bank statement line is unreconciled.
  • The bank statement line matches the criteria on the schedule task.
  • The bank statement line matches to a rule in the associated payment rule set for the bank account.
  1. Access the
    Create Customer Payment Rule Set
     task.
    Specify the rule name.
  2. (Optional) To associate a customer mapping table to the customer payment rule set, from the
    Remit-From Customer Mapping
     prompt, select the mapping table.
    • You can add lookup mapping tables with up to 50,000 mapping lookup values for each table for your remit-from customers or sponsors on the
      Put Remit-From Customer Lookup Mapping Table
       web service.
    • Add the invoice lookup prefixes.
      • Enter a unique prefix value that's 3 or more characters.
      • You can add a maximum of 500 prefix values for each rule set.
      • When gapless sequencing is enabled for a company, specify the
        Prefix Value
         of the gapless sequence.
  3. Complete the
    Rule Information
     section.
    Add 1 or more rules. In the
    Order
     field, enter the processing order number for each rule in the rule set.
  4. Complete the
    Bank Statement Filter Criteria
     section:
    Option
    Description
    Bank Statement Field
    Select a value to filter the bank statement lines.
    You can use each bank statement field as a criteria for multiple rows in each rule set.
    When you add more than 1 filter row, a bank statement line is eligible for customer payment creation only when all row conditions are met.
    Relational Operator
    Select an option to either include or exclude the values in the filter.
    Criteria Value
    Specify a value.
    Example: When you select the
    Statement Line Type Code
     for the bank statement field, you can select multiple values from the provided list of codes for a given bank statement format.
  5. Complete the
    Copy Bank Statement Lines to Customer Payment
     section:
    Option
    Description
    Bank Statement Line
    Select a value to copy from the bank statement line to the remittance advice type on the customer payment.
    Click
    +
     to add more than 1 lines to copy.
    We can’t provide a unique match when a string of text includes several invoices. You need to record the payment manually based on the remittance information copied into the customer payment.
    Customer Payment Remittance Advice Type
    Select a value for the customer payment where you want to copy the information from the bank statement line.
    Example: You can copy the
    Statement Line Reference Number
     from the bank statement line as an
    Invoice Number
     on the customer payment remittance advice.
  6. Complete the
    Payment and Deposit Defaulting
     section:
    Option
    Description
    Payment Type
    Select a payment type to populate on the payment when the rule condition is met.
    Payment Date
    By default, we set this date to
    Bank Statement Line Date
    . You can also select 1 of the options.
    Deposit Date
    By default, we set this date to
    Bank Statement Line Date
    . You can also select 1 of the options.
    Remit-From Customer
    When there is an exact match, Workday adds this customer to the
    Remit-To Customer
     field on the payment.
    When the rule is specific to a particular customer, select that same customer.
    When you select a different lookup field such as
    Invoice Number
    , or a
    Reference Number
     in the
    Customer Payment Remittance Advice Type
     prompt under the
    Copy Bank Statement Lines to Customer Payment
     section, the customer value specified here takes precedence.
  7. Click
    OK
    .
Workday creates the rule sets that you can use in a bank account to automate the process of recording payments and deposits and reconciling the deposits.
  • You can access the
    Maintain Customer Payment Rule Set
     task to view all the customer payment rule sets created, bank accounts using the rule sets, and the number of rules in each rule set. You can also manage the status of the rule set and create new rule sets.
  • Access the desired bank account and configure an appropriate payment rule set.