Steps: Create and Reconcile Electronic Payment Reconciliation Groups

Configure the Bank Account Event
business process and security policy in the Banking and Settlement functional area.

You can consolidate your outgoing electronic payments into electronic payment reconciliation groups (EPRG) for a more streamlined reconciliation. When you settle the EFT and direct deposit payments, Workday generates EPRGs with the payments for each bank account.

EPRGs enable you to:

Group payroll payments together to avoid displaying confidential information for individual payments.

Manually reconcile a large number of electronic payments as a single group.

Match a group of electronic payments to a single bank statement line in automatic reconciliations.

Reduce bank fees by grouping all of your electronic payments onto a single bank statement line, per your bank service agreement.

Access the

Create Bank Account

Edit Bank Account

task.

Select the

Group Electronic Payments for Reconciliation

check box.

Security: Set Up: Bank Entity
domain in the Banking and Settlement functional area.

(Optional) Configure Workday to receive and upload payment acknowledgment files.

The files acknowledge whether the bank received, processed, or rejected your payments.

See:

Steps: Acknowledge Payments.

Concept: Electronic Payment Acknowledgement.

Settle the electronic payments.

You can either:

Create Manual Settlement Runs.

Schedule Automatic Settlement Runs.

Workday groups the payments that have all of these same payment attributes into an EPRG:

Payment category. Example: Ad hoc payment or miscellaneous payment.

Payment date.

Payment type. Example: EFT or direct deposit.

Transaction currency.

Workday includes both the group reference ID and individual payment IDs in the payment file delivered to the bank. When the bank accepts and completes at least 1 payment in the group, Workday enables the EPRG for bank reconciliation. Workday considers both received payments and returned payments as complete.

When any payment in the group is still awaiting acknowledgment, Workday prevents you from reconciling the EPRG.

Identify the EPRG reference ID in the payment file.

To locate the group reference ID that your bank uses in the payment file, select the business process payment message in the

Payment Groups

tab when viewing the settlement run. Example: In an ISO20022 XML document, the Payment Information ID
element contains the group ID and Payment ID
the individual payment ID.

Notify your bank to generate a single bank statement line per EPRG.

You can instruct your bank to incorporate the group reference ID from the payment file on the resulting bank statement line to simplify bank reconciliation.

Example: You process multiple ACH payroll payments from Workday to your employees. To enable a 1-to-1 matching method for reconciliation, you request your bank to return a single statement line that represents the sum of all individual ACH payments in the group.

Record bank statement information in Workday.

You can either:

Enter Bank Statements Manually.

Use Quick Entry and Reconciliation.

Configure a bank statement integration to upload bank statement files in bulk.

See Steps: Set Up Bank Statement Load Integration.

Reconcile your bank statement lines with the EPRGs.

You can either:

Reconcile a Bank Statement Automatically.

Reconcile Multiple Bank Statements Automatically.

Reconcile a Bank Statement Manually.

To reconcile, either:

Create a 1-to-1 matching rule using a condition rule based on the

Transaction Reference

field for automatic reconciliation.

Match the group reference ID on the statement line and EPRG during manual reconciliation.

To view the reference number for an EPRG and the payment statuses of its constituent payments, you can access the

View Electronic Payment Reconciliation Group

report from either this task or report:

Manual Bank Reconciliation

. In the

Reconcilable Items

grid, click the magnifying glass icon for the EPRG.

View Settlement Run

. Select the payment group, and then the EPRG payment message.

The bank reconciliation enables you to verify that your grouped payments are accurately reflected on your bank statement lines. You can use the

Book to Bank Summary Report

and other bank reconciliation reports to confirm the details.

You enable the EPRG feature for bank reconciliation and configure Workday to receive payment acknowledgments. Workday groups your 4 EFT payments in an EPRG with a total value of $1000.00.

This table illustrates how Workday determines the EPRG total amount and availability for reconciliation based on different payment and acknowledgment statuses within the group. An EPRG that includes a payment in status:

Awaiting Payment Acknowledgment
isn't yet reconcilable, though the payment counts towards the original EPRG amount.

Canceled
or Rejected
is reconcilable, but Workday deducts this payment from the original EPRG amount. If all underlying payments in the group are canceled or rejected, the EPRG isn't reconcilable.

	Payments in EPRG	Scenario 1	Scenario 2	Scenario 3	Scenario 4	Scenario 5	Scenario 6	Scenario 7
Payment 1	$100.00	Awaiting Acknowledgment	Awaiting Acknowledgment	Complete	Rejected	Rejected	Rejected	Rejected
Payment 2	$200.00	Awaiting Acknowledgment	Complete	Complete	Complete	Rejected	Awaiting Acknowledgment	Awaiting Acknowledgment
Payment 3	$300.00	Awaiting Acknowledgment	Complete	Complete	Complete	Rejected	Complete	Canceled
Payment 4	$400.00	Awaiting Acknowledgment	Complete	Complete	Complete	Rejected	Complete	Complete
EPRG Total Amount	$1000.00	$1000.00	$1000.00	$1000.00	$900.00	$0.00	$900.00	$600.00
Is EPRG Reconcilable		No	No	Yes	Yes	No	No	No

Define Bank Accounts

Steps: Set Up Automatic Bank Account Reconciliation

Reference: Book-to-Bank Reports