Skip to main content
Administrator Guide
Last Updated: 2023-06-23
Reference: Bank Account Reconciliation Reports

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:
  • A projected bank account balance based on the reconciled and unreconciled bank statement lines, and beginning balance of the first bank statement.
  • The last bank statement ending balance.
  • A projected ledger ending balance based on the unreconciled items, items fully reconciled in a future period, items canceled or escheated in a future period, and reconciled items accounted for in a future period.
  • The actual ledger ending balance.
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.