Reference: Bank Account Reconciliation Reports
This table lists reports that are useful in managing your bank statements and
reconciliations.
For a complete list of bank reconciliation reports, access Workday Standard Reports
and select these report categories:
- Banking
- Financial Reconciliation and Close
- Set Up Bank Reconciliation
Report | Description |
|---|---|
All Condition Rules
| View condition rules, their descriptions, and the rule definitions for
condition rules used throughout Workday. Select View Condition Rules
used as
Bank Statement Rules to see condition rules used for reconciliation and
other bank-statement-related activities. You can also edit or delete
rules. |
Bank Reconciliation
| Displays summary information about a reconciled bank statement such as the
beginning and ending dates, beginning and ending balances, cleared items, and
uncleared items up to the statement date. Drill down on the total
reconcilable items amount to view all transactions cleared on the bank
statement by debit or credit. |
Bank Reconciliation Detail
| Displays details about a reconciled bank statement such as the beginning
and ending balances, cleared items, and uncleared items up to the statement
date. Also includes a calculated account register balance that reconciles with
the account register report, and a ledger balance as of the statement end date.
Drill down on the total reconcilable items amount to view all
transactions cleared on the bank statement by debit or credit. |
Book to Bank
| Compare bank statement balances against the ledger bank balances for a
specified period. After running bank statement reconciliations, you can use this
report at month end to review the discrepancies between the bank and ledger
balances. Example: Identify transactions that posted to the ledger but are still
unreconciled. The report information includes:
|
Book to Bank by Bank Account Currency
| View the book-to-bank report in a single bank account currency. Workday
translates multicurrency transactions posted to the ledger using the specified
translation rule set and bank account currency. |
Cross Statement Reconciliation
| Displays groups of reconciled items and bank statement lines from multiple
bank statements. Workday creates a reconciled group when multiple bank statement
lines are reconciled to 1 or more items. |
Find Ad Hoc Bank Transactions
| Lists ad hoc bank transactions by company or by company bank account.
|
Find Bank Statements
| View a list of bank statements for a company or specific bank account. Each
bank statement includes the status, date, balances, reconciliation status, and
transaction count. You can also edit a bank statement from its related actions
menu. |
Find Bank Statement Lines
| Displays all bank statement lines and the reconciliation status for a
specified set of bank accounts and bank statements. |
Maintain One Sided Reconciliation
| View and maintain all reconcilable items that are reconciled with other
reconcilable items for a specified bank account. To unreconcile items, click
Unreconcile for the set of reconciled
items. |
Uncleared Items
| View all items in a bank account that are uncleared as of a specified date.
Drill down on payment and deposit totals to view all uncleared
transactions and amounts. Workday displays the payee name and
transaction date of payroll payments if you have access and contextual
security to applicable payroll security domains and companies. |
View Account Register
| Displays all transactions for a bank account. |
View Bank Reconciliation and First Notice Item Rule
Sets
| View all rule sets of both types and the reconciliation rules in each set.
You can see which sets each reconciliation rule is used in, examine the
condition rules used, and create new rule sets. You can also edit a particular
rule set from its related actions menu. |
View Bank Reconciliations Reasons
| View the reconciliation reasons that you've defined in Workday. You can
also edit a reconciliation reason from its related actions menu. |
View Bank Reconciliation Rule
| View the bank reconciliation rule definition and the action it takes when
there's a match. Details include the conditions that make up the rule and the
rule sets that use this rule. You can also edit the rule from its related
actions menu. |
View First Notice Item Rule
| View the rule definition and the action it takes when there's a match. You
can view the conditions that make up the rule and the rule sets that use this
rule. You can also edit the rule from its related actions menu. |
View Reconciliation Metrics
| View metrics for rules used in an automatically reconciled bank statement.
You can view how each rule performed including the number of:
To clear the metrics from the most recent reconciliation, select
Clear Reconciliation Metrics from the related
actions menu of the bank statement. |