Download PDF
Create Trial Balance Reports in AP&C
The Workday trial balance in Adaptive Planning and Consolidation (AP&C) is a list of all the ledger accounts with balances for your company. You can only view and report on ledger accounts to which you have security permission.
When run for a single company, the report lists the:
- Ledger account.
- Beginning balance.
- Total debit amount.
- Total credit amount.
- Ending balance for the reporting period.
When run for multiple companies, you can select from these display options:
- Company: Displays an ending balance column for each company that you include in the report request.
- Summary: When running the report for a multilevel company hierarchy, displays an ending balance column for each subordinate company hierarchy.
- Total: For a company hierarchy, displays an ending balance column with the total amount for each company in the company hierarchy.
When run for multiple fiscal schedules, Workday:
- Summarizes journal lines by journal date instead of accounting period and fiscal year. You can then run financial statements for either the primary or alternate fiscal schedules.
- Determines the correct fiscal period based on the fiscal schedule you select.
Workday also delivers a standard composite consolidated trial balance report that is useful for reporting on company hierarchies. Use Workday Report Writer to copy and configure column and row types that enable you to:
- View a list of companies and their respective totals.
- View intercompany entries.
- View elimination entries.
- Define calculations for columns and row types.
- Select fields that you want summarized.
- Select fields for which you want to view detailed data.
- Configure filter conditions.
- Define prompt defaults.
Filters and data are specific to your Workday tenant, and might be different than the values used in the standard composite trial balance report. Use any value in the report as guidance.