Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Reference: Workday-Delivered Reports for Financial Close

Reference: Workday-Delivered Reports for Financial Close

This table lists some of the Workday-delivered reports that enable you to:
  • Gain visibility into your data.
  • Reconcile operational transactions.
  • Track the status of account certifications.
Report
Description
Subreports and Security
Account Certification Definitions for Balance Sheet Accounts.
Lists all balance sheet ledger accounts and their associated account certification definitions.
Set Up: Account Certifications
 domain in the Financial Accounting functional area.
Balance Sheet Certification Progress.
Use this report (secured to the
Report Execution
domain in the Tenant Non-Configurable functional area) to display ledger balances versus amounts to certify with variances. Also, the report indicates if a given account certification has:
  • Has started
  • Not started
  • Isn't created
The 3 subreports:
  • Sub Report - Journal Lines for Account Certification - Ledger Amount, secured to the
    Reports: Financial Accounting
     domain in the Financial Accounting functional area.
  • Sub Report - Account Certification Lines By Status, secured to the
    Process: Account Certifications - Reporting
    domain in the Financial Accounting functional area.
  • Sub Report - All Balance Sheet Ledger Accounts with Optional Ledger Account Filter, secured to the
    Reports: Financial Accounting
     domain in the Financial Accounting functional area.
Cash to Bank Reconciliation
Use this report (secured to the
Report Execution
domain in the Tenant Non-Configurable functional area) to reconcile cash to bank for a single company and one or more bank accounts for a specified fiscal period and time period.
Reconciles in company currency, operational cash ending balances to the operational ledger ending balances and displays any differences by company, ledger account, and bank account.
If you run this report without creating initial balances or Beginning Balances, Workday displays zeroes.
These 6 subreports secured to the
Reports: Financial Accounting
 domain in the Financial Accounting functional area:
  • Sub Report - Cash to Bank Journal Non-Operational Transaction Activity Ending Balance (Standard).
  • Sub Report - Cash to Bank Ledger Balances by Balancing Worktag (Standard).
  • Sub Report - Cash to Bank Reconciliation Activities (Standard).
  • Sub Report - Cash to Bank Reconciliation Future Period Activities.
  • Sub Report - Cash to Bank Reconciliation Error Activities.
  • Sub Report - Cash to Bank Reconciliation Beginning Balances (Standard).
Cash to Bank Reconciliation in Bank Currency
Use this report (secured to the
Report Execution
domain in the Tenant Non-Configurable functional area) to reconcile cash to bank for a single company and one or more bank accounts for a specified fiscal period and time period.
Reconciles in bank currency, operational cash ending balances to the operational ledger ending balances and displays any differences by company, ledger account, and bank account.
These 6 subreports secured to the
Reports: Financial Accounting
domain in the Financial Accounting functional area:
  • Sub Report - Cash to Bank Reconciliation Beginning Balances.
  • Sub Report - Cash to Bank Reconciliation Activities.
  • Sub Report - Cash to Bank Reconciliation Future Period Activities.
  • Sub Report - Cash to Bank Reconciliation Error Activities.
  • Sub Report - Cash to Bank Journal Non-Operational Transaction Activity Ending Balance in Transaction Currency.
  • Sub Report - Cash to Bank Ledger Balances in Transaction Currency by Balancing Worktag.
Cash to Bank Reconciliation by Reconciliation Status
Use this report (secured to the
Report Execution
domain in the Tenant Non-Configurable functional area) to view the reconciliation status of each cash operational transaction to cash ledger balance.
This report is similar to the
Cash to Bank Reconciliation
 report.
These 6 subreports secured to the
Reports: Financial Accounting
 domain in the Financial Accounting functional area:
  • Sub Report - Cash to Bank Reconciliation Beginning Balances.
  • Sub Report - Cash to Bank Ledger Balances.
  • Sub Report - Cash to Bank Reconciliation Activities - Unreconciled Prior Periods.
  • Sub Report - Cash to Bank Reconciliation Activities - Reconciled.
  • Sub Report - Cash to Bank Reconciliation Activities - Unreconciled.
  • Sub Report - Cash to Bank Journal Non-Operational Transaction Activity Ending Balance.
Cash to Bank Reconciliation by Reconciliation Status in Bank Currency
Use this report (secured to the
Report Execution
domain in the Tenant Non-Configurable functional area) to view the reconciliation status of each cash operational transaction to cash ledger balance in bank currency.
These 6 subreports secured to the
Reports: Financial Accounting
 domain in the Financial Accounting functional area:
  • Sub Report - Cash to Bank Reconciliation Beginning Balances.
  • Sub Report - Cash to Bank Reconciliation Activities - Unreconciled Prior Periods.
  • Sub Report - Cash to Bank Reconciliation Activities - Reconciled.
  • Sub Report - Cash to Bank Reconciliation Activities - Unreconciled.
  • Sub Report - Cash to Bank Journal Non-Operational Transaction Activity Ending Balance in Transaction Currency.
  • Sub Report - Cash to Bank Ledger Balances in Transaction Currency.
Cash to Bank Reconciliation Initial Balances
Use this report (secured to the
Report Execution
domain in the Tenant Non-Configurable functional area) to verify and reconcile cash to bank initial balances for a single company and one or more bank accounts.
For each company and bank account, compares cash ledger ending balances, including manual cash journals to the related operational cash ending balances.
These 3 subreports secured to the
Reports: Financial Accounting
 domain in the Financial Accounting functional area:
  • Sub Report - Cash to Bank Journal Non-Operational Transaction Activity Ending Balance for Reconciliation Initial Balances (Standard).
  • Sub Report - Cash to Bank Ledger Balances for Reconciliation Initial Balances(Standard).
  • Sub Report - Cash to Bank Ledger Balances for Reconciliation Initial Balances by Balancing Worktag (Standard).
Cash to Bank Reconciliation Initial Balances in Bank Currency
Use this report (secured to the
Report Execution
domain in the Tenant Non-Configurable functional area) to verify and reconcile cash to bank initial balances for a single company and one or more bank accounts.
For each company and bank account, compares cash ledger ending balances, including manual cash journals to the related operational cash ending balances in bank currency.
These 6 subreports secured to the
Reports: Financial Accounting
 domain in the Financial Accounting functional area:
  • Sub Report - Cash to Bank Reconciliation Beginning Balances.
  • Sub Report - Cash to Bank Reconciliation Activities - Unreconciled Prior Periods.
  • Sub Report - Cash to Bank Reconciliation Activities - Reconciled.
  • Sub Report - Cash to Bank Reconciliation Activities - Unreconciled.
  • Sub Report - Cash to Bank Journal Non-Operational Transaction Activity Ending Balance in Transaction Currency.
  • Sub Report - Cash to Bank Ledger Balances for Reconciliation Initial Balances in Transaction Currency by Balancing Worktag
Currency Translation Adjustment Reconciliation
Use this report (secured to the
Report Execution
domain in the Tenant Non-Configurable functional area) to:
  • Reconcile currency translation gains and losses by ledger account for a single company.
  • Compare the currency translation adjustment for the current period with the prior period.
    View derived journal entries by drilling on the Currency Translation Gain and Loss accounts in the Reconciliation section of this report.
You can run this report for a single company only.
These 3 subreports secured to the
Reports: Financial Accounting
 domain in the Financial Accounting functional area:
  • Sub Report - Current Period CTA Derivation (Standard).
  • Sub Report - Journal Lines Translated for CTA Gain (Standard).
  • Sub Report - Journal Lines Translated for CTA Loss (Standard).
Currency Translation Adjustment Reconciliation by Company
Use this report (secured to the
Report Execution
domain in the Tenant Non-Configurable functional area) to:
  • Reconcile currency translation gains and losses by ledger account for a company or company hierarchy.
  • View derived journal entries by drilling on the Currency Translation Gain and Loss accounts in the Reconciliation section of this report.
These 3 subreports secured to the
Reports: Financial Accounting
 domain in the Financial Accounting functional area:
  • Sub Report - Current Period CTA Derivation (Standard).
  • Sub Report - Journal Lines Translated for CTA Gain (Standard).
  • Sub Report - Journal Lines Translated for CTA Loss (Standard).
Intercompany Elimination Out of Balance Report
Use this report to reconcile:
  • Intercompany accounts in an Elimination rule.
  • Differences with the Suspense account in the Consolidated Trial Balance report.
The report displays Intercompany and Intercompany Affiliate Elimination Ledger account differences in both transaction and translated currencies.
The report by default runs for all Elimination rules, but you can select to run it for a specific rule.
Clear the
Include all Intercompany Affiliates
 option if you want to run the report for affiliates that are only under the company hierarchy.
Reports: Financial Accounting
 domain in the Financial Accounting functional area.
Find Cash to Bank Reconciliation Activities
Use this report to view details of cash operational activities for a company and one or more bank accounts.
Displays cash operational activity by:
  • Accounting date
  • Bank account
  • Company
  • Ledger account
  • Reconciliation activity type
  • Transaction date
Reports: Financial Accounting
in the Financial Accounting functional area.
Find Cash to Bank Reconciliation Initial Balances
Use this report to view initial balances for company or company hierarchy and one or more bank accounts and ledger accounts.
Displays initial cash balances in ledger and bank currency by company, ledger account, bank account, and accounting date. Also, use this report to edit and delete an initial balance using related actions.
Reports: Financial Accounting
in the Financial Accounting functional area.
Ledger Year Beginning Balances by Company
Use this report (secured to the
Report Execution
domain in the Tenant Non-Configurable functional area) to display the ledger year beginning balances for a company or company hierarchy in:
  • Ledger Currency
  • Translation Currency
These 2 subreports secured to the
Reports: Financial Accounting
 domain in the Financial Accounting functional area:
  • Sub Report - Beginning Balance Journal Lines.
  • Sub Report - Beginning Balance Journal Lines Translated.
Number of Account Certifications by Status.
Provides the number of account certifications grouped by Account Certification status. Drill-down provides details of ledger accounts included in each Account Certification along with other pertinent data.
Process: Account Certifications - Reporting
 domain in the Financial Accounting functional area.
Outstanding Intercompany Transactions
Use this report to review outstanding intercompany transactions by paying company and intercompany affiliate.
Workday doesn't include any posted reversal journals that have a related reversal journal in the next period. This prevents you from adjusting any journals that Workday will automatically reverse the next period.
Reports: Financial Accounting
in the Financial Accounting functional area.
View Ledger Period Statuses
Use this report to view Reference IDs of all ledger period statuses.
Process: Period End
 in the Common Financial Management functional area.
Balance Sheet Retained Earnings Reconciliation
Use this report to reconcile the current year retained earnings calculated from balance sheets and income statements.
Report Execution
 domain in the Tenant Non-Configurable functional area.
Income Statement Retained Earnings Reconciliation
Use this report to reconcile the current year retained earnings calculated from income statements.
Report Execution
 domain in the Tenant Non-Configurable functional area.
Balance Sheet - Consolidated
Use this report to view a consolidated balance sheet across companies in a hierarchy.
Report Execution
 domain in the Tenant Non-Configurable functional area.
Balance Sheet - Non Consolidated
Use this report to view a balance sheet for a single company.
Report Execution
 domain in the Tenant Non-Configurable functional area.
You can also access the
Workday Standard Reports
 report to view a list of all Workday-delivered reports.