Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2025-10-31
Reference: Workday-Delivered Reports for Financial Close in AP&C

Reference: Workday-Delivered Reports for Financial Close in AP&C

This table lists some of the Workday-delivered reports in Adaptive Planning and Consolidation (AP&C) that enable you to:
  • Gain visibility into your data.
  • 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.
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.
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.
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).
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.
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.
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.
View Intercompany Reconciliation Report
Use this report to view intercompany differences due to unmatched intercompany journal lines. This report enables you to:
  • View unreconciled intercompany balances by:
    • Intercompany pair.
    • Elimination rule.
    • Transaction currency.
  • View intercompany reconciliation balances in translation currency, and by time period and amount types.
  • Drill down into unmatched journal lines and amounts to understand the source of differences.
When you run this report, you select a company or hierarchy to view its intercompany reconciliation balances. To ensure a complete view, you must have access to any companies with which the selected company has intercompany transactions.
The tiles in the
Reconciliation Differences in Absolute Values
 section display the totals for certain sources of difference in absolute values. An absolute value is a number’s distance from zero, regardless of whether the number is positive or negative. We use absolute values on these tiles to indicate the total magnitude of differences, and to avoid positive and negative differences netting each other out.
You can click the tiles to filter the grid to display journal lines relevant to:
  • Differences due to unmatched intercompany journal lines.
  • Differences due to translated currency amounts.
  • Both sources of difference.
The report doesn’t support:
  • Alternate ledger currencies.
  • Commitment or Budget ledger types.
You should only use this report when using the Intercompany Matching feature. Otherwise, you should continue to use the existing
Intercompany Elimination Out of Balance
 report.
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.
You can also access the
Workday Standard Reports
 report to view a list of all Workday-delivered reports.