Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Reconcile Multiple Bank Statements Automatically

Reconcile Multiple Bank Statements Automatically

  • Create a bank account. Indicate either a basic or advanced automatic reconciliation for the bank account.
  • Enter or upload bank statements.
  • Security:
    Process: Bank Reconciliation
     domain in the Banking and Settlement functional area.
We plan to retire the bank reconciliation rule functionality in a future update. Workday recommends that you use the new matching rules and the
Run Bank Statement Auto Reconciliation
 task to reconcile multiple bank statements.
You can run an automatic reconciliation across multiple bank statements using bank reconciliation rules and first-notice item rules. This enables you to:
  • Streamline the reconciliation of multiple unreconciled bank statements.
  • Reconcile a large number of items for a specified bank account at once.
  • Reconcile transactions that are completed or transferred from other systems after you've imported the corresponding bank statements into Workday.
  1. Access the
    Run Multiple Bank Statement Auto Reconciliation
     task.
  2. Enter the
    Start Date
     of the unreconciled bank statements. You can optionally enter an
    End Date
     for a specific time range of statements.
  3. Click
    OK
     to start the reconciliation, or schedule it to run on a specified date and time.
  4. When the reconciliation process is complete, select the
    Reconciliation Criteria
     tab to see if the bank statements are fully reconciled. You can drill-down on the statements that are either still in progress or reconciled to view the transaction details.
  5. (Optional) Select
    Bank Statement
     >
    Manage Exceptions
     from the bank statement related actions menu to handle any unreconciled lines.
Use the bank reconciliation reports to confirm the details.
The
Auto Reconciled By Rule
 field on these reports displays the bank reconciliation or first-notice item rule used to reconcile a statement line to an operational or ad hoc bank transaction:
  • Find Bank Statement Lines
  • View Bank Statement