Set Up Account Reconciliation Definitions
- Set up assignable roles for preparers and approvers. See Steps: Set Up Roles for Account Reconciliation.
- Security:Set Up: Account Reconciliationdomain in the Financial Accounting functional area.
Set up an account reconciliation definition to determine which balances to reconcile, using criteria such as company, ledger accounts, worktags, and frequency. Assign users to preparer and approver roles for reconciliations created from this account reconciliation definition.
After you create reconciliations for a period using a definition, the only settings you can change on the definition are the role assignments and the autocertification rule. To change any other settings, you can either:
- Inactivate the existing definition and create a new definition with the new values.
- Cancel any reconciliations created from the definition, then change the definition.
- Access theMaintain Account Reconciliation Definitionstask. Complete the task:
Option Description InactiveSelect to inactivate the definition.Example: You want to change a definition but you already created reconciliations based on it. You inactivate the existing definition and recreate it with the required changes.Definition NameEnter a name that helps you identify the reconciliation definition when you create reconciliations or when you view reconciliation details.Reconciliation TypeThe only reconciliation type that's currently available isDefault.LedgerWorkday only supports the Actuals ledger for account reconciliation.Account SetWhen you select an account set, theCompanyprompt only shows companies that use it as the primary account set.CompanySelect the companies or hierarchies to include on reconciliations created from this definition. You can include companies that use different ledger currencies.After you select the first company or hierarchy, the prompt filters the remaining options to only display other companies or hierarchies that share the same primary fiscal schedule.When you update a hierarchy that's used on an account reconciliation definition to include a company with a different primary fiscal schedule, or when a hierarchy is no longer valid for any other reason, Workday displays an error the next time you try to edit the account reconciliation definition.Ledger Account / Ledger Account SummarySelect the ledger accounts or ledger account summaries to include on the reconciliation definition.WorktagsWhen you select 2 or more types of worktag on the definition, reconciliations that you create from this definition will only include journal lines that have all of those worktags.BookSelect the book to include on the reconciliation definition.Revalued Ledger AccountsSelect this check box when the ledger accounts on the reconciliation definition are revalued.When this check box is checked, Workday updates theCurrency Rate at Period EndandLedger Amount at Period Endfields on the reconciling item automatically based on the rate in effect at the end of the period.When this check box is unchecked and a reconciling item rolls forward to the next period, Workday doesn't update theCurrency Rate at Period EndandLedger Amount at Period Endfields on the reconciling item.Currency Rate TypeSelect the currency rate type that Workday will use when converting reconciling items and supporting balances from transaction currency to the ledger currency.Workday automatically selects the company rate type override, where available, or the currency rate type for the tenant. You can change this default.Reconciliation CurrencySelect a common translation currency for all ledger accounts on the reconciliation. Workday will convert balances from the ledger currency to this currency.When there's 1 company or company hierarchy on the definition, or all companies or hierarchies share the same ledger currency, Workday automatically selects that ledger currency. You can change this default.Account Translation Rule SetSelect the account translation rule set that Workday will apply when translating balances from the ledger currency to the reconciliation currency.You must select an account translation rule set when the reconciliation currency is different to the ledger currency of any company on the definition.When the definition contains:- A single company, Workday automatically populates the account translation rule set based on the company accounting details of that company.
- Multiple companies that have the same account translation rule set in their company accounting details, Workday automatically populates that account translation rule set.
- A company hierarchy that has an account translation rule set specified in its consolidation details, Workday populates that account translation rule set.
You can change this default.Risk RatingSelect the risk rating to include on the reconciliation definition based on historical activity in the selected ledger accounts.Policy Purpose and ProcedureSelect from policy purpose and procedure documents created on theCreate Policy Purpose and Proceduretask.If you previously set up the basic account certification functionality, you can select policy purpose and procedure documents that you configured in certification sets for account certification. However, we recommend that you don't reconcile using both basic account certification and account reconciliation.FrequencyYou can select 1 of the fiscal summary schedules you set up for the primary fiscal schedule used by the selected companies. Example:Annual,Half-Yearly, orQuarterly. SeeSteps: Set Up Fiscal Schedules and Years.When you don't select a frequency, Workday creates account reconciliations on a monthly basis.When you create reconciliations, Workday uses the selected frequency in combination with thePeriod Optionson theCreate Account Reconciliation for Periodtask to determine which reconciliations to create.Autocertification RuleSelect the autocertification rule that Workday will apply when you run autocertification for this reconciliation definition.The only rule currently available isNo Activity for Period. With this rule, Workday will automatically certify reconciliations that have the statusNot Started, have no activity in the general ledger, and have no supporting balances or reconciling items. - ClickOK, thenDone.
- In the row containing the reconciliation definition, clickAssign Roles.
- On theAssign Rolestask, assign users to the preparer and approver roles for account reconciliations created using this definition.Ensure that you assign approvers before preparers submit reconciliations. Approvers can't approve reconciliations that are submitted before you assign them to the definition.
- ClickOK, thenDone.
Access the
Reconciliation Definition Coverage Check
report to identify ledger accounts that aren't covered by a reconciliation definition.Mass assign users to roles on account reconciliation definitions.