Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Concept: Management of Unreconciled Items

Concept: Management of Unreconciled Items

We plan to retire the Reconciliation Work Area functionality in a future update. Workday recommends that you use these new book-to-bank reports to help you identify unreconciled bank statement lines and operational transactions:
  • Book to Bank Summary
  • Book to Bank Summary - Uncleared Bank Statement Lines
  • Book to Bank Summary - Uncleared Operational Transactions
From the report details, you can access the
Manage Exception Detail
 page described below to reconcile uncleared bank statement lines.
Bank statements remain unreconciled until all the items in the statement are matched to operational transactions.
There are 2 different places that you can go to start working on as-yet unreconciled items: the Reconciliation Work Area for a summary of all unreconciled items, and the
Manage Exceptions
 page, for an individual bank statement.

Reconciliation Work Area

This work area provides a quick starting point for managing your bank statements. It lists the most recent 15 unreconciled bank statements, and if a bank statement isn't listed, you can use
Find Bank Statements
 at the top of the page. This work area also lists the oldest unreconciled bank statement lines from the listed bank statements.
To start manual reconciliation, click
Manual Bank Reconciliation
. See Reconcile a Bank Statement Manually.
The Reconciliation Work Area has 3 parts:
Last 15 Unreconciled Bank Statements
Each line is for an unreconciled bank statement. The related actions menu for the bank statement enables you to edit the statement, manage exceptions, and automatically or manually reconcile the statement. You can also access the bank account or drill down on the number of unreconciled lines.
When you drill down on the number of unreconciled statement lines, you get a list of all unreconciled lines. You can click any line to get additional detail. From the related actions menu for the
Bank Statement Line
 field, select
Bank Statement Line
Manage Exception Detail
 to look at possible transactions with which to reconcile.
If you select
Manage Bank Reconciliation Exceptions
, at the right, you get a list of all the unreconciled bank statement lines.
Oldest Unreconciled Statement Lines
This section lists the oldest lines and includes suggested matches and the reasons why they're suggested. Click the
Manage Exception Detail
 button at the right to look at possible transactions with which to reconcile.
Suggestions Chart
This donut chart lists, for the unreconciled items with suggestions, the percentage of suggestions by the type of match reason listed.

Manage Bank Reconciliation Exceptions

The
Manage Exceptions
 page enables you to see all the unreconciled lines in a specific bank statement. From here, you manually reconcile the statement by handling each line individually.
Access the
Manage Exceptions
 task by selecting
Bank Statement
Manage Exceptions
 from the related action menu on any unreconciled bank statement. Or, from the Reconciliation Work area, by clicking
Manage Bank Reconciliation Exceptions
 at the left of a statement line.
To manually reconcile an individual line, click
Manage Exception Detail
, at the right of the line.
If the line has suggestions, the number of them displays in the
Suggested Item Count
 column. When you click the related actions menu icon at the left end of a line with suggestions, the preview window displays these suggestions. If a suggestion is valid, you can click the
Reconcile
 button to reconcile to that suggestion.

Manage Exception Detail

When you click the
Manage Exception Detail
 button, it lists each unreconciled line, so you can look at possible transactions with which to reconcile.
  1. Under Reconciliation Information, use the prompt for the
    Reconciled To
     field to find an operational transaction to which to match this bank statement.
  2. The prompt lists suggestions for each of the rules whose action was Suggest Items, if there are any. It also displays a category for all unreconciled items. You can select one or more unreconciled items to reconcile with this bank statement line.
    If this item has suggestions, they display at the bottom of the page. You can click the magnifying glass icon at the right of the
    Reconcilable Item
     field to see details for this suggested transaction.
  3. If the bank statement line needs an ad hoc transaction, click the
    Create
     option on the Reconcile To prompt. See Create Ad Hoc Bank Transaction. When you create a matching ad hoc transaction, it reconciles automatically. After creating the ad hoc transaction, you can return to the
    Manage Exception Detail
     page.
  4. (Optional) Specify a
    Reviewer
     and enter some notes. Someone else can review comments, or advise on a line before you can reconcile it.
    When you enter a user name in the
    Reviewer
     field and click
    OK
    , the user receives a Workday task in My Tasks with a link to the bank statement line.
  5. (Optional) Check
    Select
     next to 1 or more of the suggested reconcilable items, and then click
    OK
    .
    If you select items with amounts that don't match, Workday guides you through creating an ad hoc bank transaction for the difference.
  6. When you finish with the
    Manage Exception Detail
     page, click
    OK
    .