Financial Accounting Reports

RPT Financial Accounting - Report Listing

AP Revaluation Calculation By Document: Matrix report summarizing the amount of revaluation gain or loss expected on supplier invoices as of the reporting date. Last Updated 5/31/2021.

AR Revaluation Calculation By Document: Matrix report summarizing the amount of revaluation gain or loss expected on customer invoices as of the reporting date. Last Updated 5/31/2021.

Bad Debt Write-Offs With Tax Impact: The report displays all Write-Offs by Write-Off reason on customer invoices that have a nonzero tax impact. Including calculations of that tax impact on the write-off amount. Last Updated 3/8/2021.

Beginning Balance Analysis - Ledger vs Translated for Translation Adjustments: This composite report compares ledger and translated beginning balances at the desired granularity for all or selected balance sheet ledger accounts after running roll-forward. Last Updated 9/8/2021.

Beginning Balance vs Prior Year Ending Balances: This Beginning Balance vs Prior Year Ending Balance report is meant to help compare the ledger year beginning balances against the prior year ending balances. This report can help prove that the year-end closing balances match next year's opening balance. If there’s any variance, you can make another copy of the report and have it repeat by company to view where there’s a discrepancy. This report should be run for the 1st period of the fiscal schedule. Last Updated 3/8/2021.

CTA Flux and Constant Currency Report: We provide this report template to help you identify changes in amounts due to currency translation.

Find Invalid Journal Lines - Posting Rule Validation: Custom Report to view the journal lines that don’t meet the Account Posting Rule criteria for the ledger account and spend/revenue category combination. Note, this report can be updated to include other valid worktag dimensions as needed by copying the calculated fields. Last Updated 3/8/2021.

Find Invalid Plan Lines - Posting Rule Validation: Custom Report to view the plan lines that don’t meet the Account Posting Rule criteria for the ledger account and spend/revenue category combination. Note, this report can be updated to include other valid worktag dimensions as needed by copying the calculated fields. Last Updated 11/2/2021.

Find Plan Lines: Accesses all Plan Entry Lines and returns 1 row per Budget Entry Line. It prompts you for worktags to filter the report results. Last Updated 5/19/2022.

Find Journal Lines - For Conversion: Journal Lines report that returns the values and reference IDs of objects typically found within a submitted EIB. Last Updated 9/8/2021.

General Ledger Detail Report: This custom report enables you to report on the detail in the general ledger. The summary provides the lookup field values for journal line details and provides the activity amounts. Last Updated 3/8/2021.

Journal Lines by Allocation: This indexed matrix report summarizes the number of journal lines and the translated debit and credit amounts generated by allocation definition and by company. This Journal Lines by Allocation report enables you to verify that each allocation result is within the performance guideline of 50K lines per allocation. It's meant to be run as you notice any performance issues with finalizing allocations to confirm if you're meeting those guidelines or to identify any allocations producing the highest number of journal lines. Consider splitting those allocation definitions creating more than 50K lines. Last Updated 6/25/2021.

Ledger Account - Posting Rule Details: Custom Report to view where the ledger accounts are used within the Account Posting Rules and which valid Spend and Revenue Categories are associated with them. Note, this report can be updated to include other valid worktag dimensions as needed by copying the calculated fields. Last Updated 3/8/2021.

Ledger Accounts by Hierarchy: Reports on each ledger account, displays the summary that includes it, and displays the hierarchies up to the top level. Last Updated 3/8/2021.

Ledger Account Summaries and Hierarchies with Ranges: Displays the ledger account ranges and specific ledger accounts that are included with each ledger account summary. By default, this option only returns the bottom level of the hierarchy, but at run time you can select the option to display all hierarchies. Last Updated 3/8/2021.

Ledger Account Summaries by Hierarchy: Report based on the Ledger Account Summary object that returns the account ranges associated with each summary and displays the hierarchies the summaries roll up into. Last Updated 3/8/2021.

Long Term vs Short Term Prepaid Lines - Summary: The Long Term vs Short Term Prepaid Lines - Summary report can be used as a way to determine what the split between short-term and long-term prepaid amounts are based on the date prompts. The output can then be input in as a reversing reclass journal each month based off of those amounts and the worktags present on the transaction. You can add and remove worktags or details as needed. Last Updated 3/8/2021.

Operational Journal Posting Rule: Report for operational journals based on the Journal Lines object that returns the Account Posting Rule used to derive Ledger Account. Last Updated 3/8/2021.

Receipt Accrual Tax Details: In some countries, Receipt Accruals also need to make a reservation for Tax amounts. Standard Receipt Accrual doesn’t calculate tax amounts. This report aims to produce a basis for which a monthly accrual journal for tax can be made. Last Updated 3/8/2021.

Short-Term Vs Long-Term Deferred Revenue: The Long-Term vs Short-Term Revenue report can be used as a way to determine what the split between short-term and long-term deferred/accrued revenue is based on date prompts. The output can then be input as a reversing reclass journal each month based on those amounts and the worktags present on the transaction. Last Updated 3/8/2021.

Spend Category Breakout MTD: Summarized matrix view of the month to date use of spend categories as it relates to journal lines. Last Updated 6/25/2021.

Top 10 Spend Category by Period: Summarized matrix view of the top 10 spend categories by period as it relates to journal amounts. Last Updated 6/25/2021.

Transaction Matching Open Item Balance: The Transaction Matching Open Item Balance report returns 1 row per ledger account with an open balance based on if there are items that aren’t marked as unavailable or matched as of the date prompt. If the line is matched after that prompted date, the report will still return a line for that instance, but will display the Transaction Matching details. If the line is unavailable regardless of prompted date, it doesn't display on the report output. This report can help coordinate reviewing the open items and balances that remain and need to be either matched or marked as unavailable for a company and ledger account. Last Updated 3/8/2021.

Transaction Matching - Open Item Balance Review Composite: Run the Transaction Matching - Open Item Balance Review Composite report as part of the transaction matching process and reconciliation. It displays the unmatched values as of the date selected, and compare it to the ledger balance to determine the difference between the 2. The data is summarized at the company, book code, and ledger account level. Last Updated 7/14/2021.

• Note: The data summarized for the Unmatched column doesn't include any Beginning Balance journals, it only includes unmatched activity that is before the As Of date. The Ledger Balance displays Beginning Balance journals based on the time period and period selected. To ensure that the 2 columns are aligned, use the last day of the prompted period for the As Of Date prompt.

Transaction Matching Open Item Reconciliation: The Transaction Matching Open Item Reconciliation report returns 1 row per line that isn’t marked as unavailable or matched as of the date prompt. If the line is matched after that prompted date, the report will still return a line for that instance, but will display the Transaction Matching details. If the line is unavailable regardless of prompted date, it doesn't display on the report output. This report can help coordinate the reconciliation process as it relates to reviewing the open items that remain and need to be either matched or marked as unavailable. Last Updated 3/8/2021.

Trial Balance - Alternate Account Set: This version of the Trial Balance is to be used for companies with an Alternate Account Set. If the company doesn't have an alternate account set, then the amounts return for a blank ledger account. We recommend that you ensure that there are no exceptions to the alternate account set mapping or journals in error due to a missing mapping before running this report. This report and the sub report can be updated to coordinate drilldown or detail needs. Translations can be used within the report's definition to update the naming of the fields. Last Updated 9/7/2021.

Migration Information

Deployment of reports requires appropriate access to Object Transporter and your organization's Customer Central tenant. For information, read Implementation Tools.

Prerequisites:

Alternatively, the Tailored Loading for Object Transporter functionality can be used to help map any of these instances to a target instance using the reference ID. Ensure that the configuration that's being mapped is used in a similar manner. 

This content isn't included in your Workday Customer Support services offering, so they can't answer questions or resolve issues related to these dashboards. Instead:

• Find troubleshooting guidance on the Configuration Catalog Troubleshooting page.
• Document questions, issues, or defects associated with this content through the Ask a related question button at the bottom of this page.

Tools

• Next Level: Getting Started with Customer Central
• Next Level: Migration Made Easy with Object Transporter (OX)
• Implementation Tools – Customer Guide
• Configuration Catalog Guide: Troubleshooting
• WDSetup Release Notes