Schedule Customer Payment from Bank Statement Line

Configure customer payment rule sets and link them to bank accounts.

Security: Process: Customer Invoice Payment
domain in the Customer Accounts functional area.

You can configure the schedule job to:

Process customer payment rule sets.

Create payments and deposits.

Reconcile the customer deposit back to the bank statement automatically.

Consider these processing behavior:

The schedule job matches the bank statement lines based on the order of the rules defined in the applicable rule set.

Each bank statement line creates 1 payment and 1 deposit.

The invoice, payment and deposit currency will always be the same as the bank statement currency.

You can run this job for 1 bank account per schedule.

When the look up value is an exact match, Workday populates the

Remit-To Customer

field on a payment.

When you create a payment in error or, re-process a bank statement line, you will need to first unreconcile deposit against the bank statement line. Then cancel the deposit, and then the payment. You can’t cancel the customer payment while it’s still attached to a customer deposit.

When the approver rejects a deposit during the Customer Deposit Event
business process approval, it cancels the customer payment and unreconciles the bank statement line.

Access the

Schedule Customer Payment from Bank Statement Line

task.

Select a desired frequency of running the job. For frequency other than Run Now
, complete the associated criteria or configurations on the

Schedule

tab.

As you complete the task, on the

Customer Payment From Bank Statement Line Criteria

tab consider:

Option	Description
Bank Account	From these prompts, select 1 or more bank accounts that you want to run the job for: Accounts by Bank Accounts by Company If you don't see an option for selection, ensure that you have linked payment rule sets to the bank accounts.
Last X Days from Bank Statement Date	Specify a value for number of days from the bank statement header date that you want to include when the scheduler runs.
Only Include Auto-Reconciled Bank Statements	Select the check box to include only those bank statements that have run through the bank statement auto-reconciliation job in the past.
Exclude Unreconciled Bank Statement Lines with Canceled Payments and Deposits	Select the check box to exclude bank statement lines that you use to create a payment and deposit but later don't reconcile and cancel the deposit and payment.

When the job completes, Workday:

Records the customer payment with a status of In Progress
and application status of Unapplied
and creates a separate deposit.

Creates the customer payment and deposit that meets the filter criteria in the rule of the customer payment rule set, but doesn't populate the remit-from, mark for auto-apply, or populate the left-hand side of the remittance advice if it doesn't find a match.

Populates Invoice instances with matching prefix values from the associated rule set and remit-from customers from these invoices.

Automatically selects the

Ready for Auto Apply

check box.

Creates customer payments and deposits for up to 1,000 eligible bank statement lines when the remit-from mapping table is configured on the customer payment rule set. You must run the scheduled job more than once when you have more than 1,000 eligible payments and deposits.

When you run the task with the relevant information copied to the remittance advice on the customer payment, Workday populates the remit-from customer on the customer payment and selects it for auto-apply if the lookup field from the mapping table matches to a value in the payment remittance advice text.

You can view the matched payments in the

Customer Payments from Bank Statement Lines

background process page:

From the

Process Info

tab, you can click on the number in

Result Instances

column to view the payments created.

From the

Customer Payments and Deposits Generated

field, you can drill down to view details of the customer payments and deposits created.

Access the

Find Customer Payments

and

Find Customer Deposits

reports to view payments and deposits created from bank statements.