Check Reconciliation Definition Coverage
- Security:Process: Account Reconciliation - Run Perioddomain in the Financial Accounting functional area.
You can perform a coverage check to ensure that every ledger account you want to reconcile is covered by an account reconciliation definition.
If you are migrating partially to account reconciliation and haven't included all ledger accounts in your reconciliation definitions, we recommend that you make a copy of the
Reconciliation Definition Coverage Check
standard report and add a filter to exclude ledger accounts. When you run the custom report, use this filter to exclude any ledger accounts that you don't want to reconcile using the account reconciliation functionality.- Access theReconciliation Definition Coverage Checkreport.
- Select filter criteria to identify the activity you want to evaluate:
Option Description Company and Company HierarchyYou can check the reconciliation coverage for multiple companies or hierarchies.Fiscal PeriodWorkday uses the fiscal period to identify the fiscal schedule associated with the account reconciliation definition.When you run the report, Workday evaluates activity in all fiscal periods for the selected period to the beginning of the fiscal year.BookYou can filter the coverage check by multiple books.Ledger Account and Ledger Account SummaryYou can filter the coverage check by multiple ledger accounts or ledger accounts summaries.Display by Worktag Type 1Display by Worktag Type 2Select up to 2 worktag types to check reconciliation coverage by worktag type. The report will return new worktag activity that isn't covered by your reconciliation definitions.Example: Journal lines in your Cash ledger account contain Bank Account worktags. To ensure these journal lines are all covered by a reconciliation definition, you select theBank Accountworktag type.When you select worktag types from these prompts, Workday only evaluates reconciliation definitions on which you selected this worktag type.When you have multiple reconciliation definitions with the same companies and ledger accounts but different worktags, leave these fields clear to include any journal lines that fall outside your existing worktag configurations, including those with new worktags or blank worktags.Report Effective DateCheck the reconciliation coverage as of a specific date. This option affects any effective-dated information in your accounting data.Example: The composition of your company hierarchy changed midway through a period. Select an effective date to check reconciliation coverage for the companies in the hierarchy either before or after the reorganization. - ClickOK.
Workday returns any ledger accounts matching the filter criteria you selected that are not covered by an account reconciliation definition.
When there are no results, this indicates that either:
- All journals for the fiscal schedule in this fiscal year are covered by reconciliation definitions, or
- There is no activity that matches the filter criteria in the fiscal year.
Create account reconciliations for fiscal periods.