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. |