Track Rejected Payments using a Payment Acknowledgements Report

Configure a custom Payment Acknowledgements Report

You can create a custom report to track approver rejections and processing problems with your payments. This is often more efficient than tracking all payments through their entire lifecycle. (Read more about Payment Statuses.)

There are many ways to design reports in Workday, these instructions below will guide you in customizing a standard report for this use case. 

  1. Using the Workday search bar, navigate to the All Workday-Delivered and Custom Reports task.

Search Workday Reports.png
  • Select Payment Acknowledgement as the Data Source.
Dialog Report Filters.png

  1. Find the Workday-delivered Payment Acknowledgements report, navigate to Copy from the report's related actions menu.

Copy Report.png

  1. Set Columns for the report.

Report Columns.png

Suggested Columns for the Rejection Report, all use the Payment Acknowledgment business object:

Field
 Column Heading Override
Description/Purpose
Original Payment ID   Workday's identifier for this payment
Matched To Payment Links to the payment record including details such as Invoices Paid, payment type, payment account, etc
Payment Processing ID   Unique identifier assigned by Bank Connect. If you need help with a payment, please provide this ID
Original Payment Date   Date on which the payment was processed
Payment Acknowledgement Status Status Rejected
Payment Acknowledgement Status Description Rejection Message This will include text explaining the rejection:
  • Rejection Reason entered by the approver who rejected the payment
  • a description of the processing error from Bank Connect
  • a cancelation description from your bank

 

 

  1. Define your report Sort.

Report Sort.png

  1. Define a Filter for report cadence.

  • This example creates a Calculated Field that returns the date-time of the Payment Acknowledgement. Then, it evaluates the value of this field against a Workday-delivered field: Current Moment - 1 Day (i.e.: this report returns acknowledgements within the past day).
Report Filter.png

  1. Define report Prompts.

  • This example sets a Rejected default value for the Payment Acknowledgement Statuses.
Report Prompts.png

  1. Define report Output.

  • This example sets a Table default value for the Output Type.
Report Output.png

  1. Define report Sharing options.

  • This example sets the Share with all authorized users option; report definitions do not need to be shared with a user for them to be able to receive or view the report.
Report Share.png