Steps: Create Recurring Accounting Journals in AP&C
Security:
- Process: Journals - Coredomain in the Common Financial Management functional area.
- Security: These domains in the Common Financial Management area:
- Process: Journals - Core
- Process: Journals - Inactivate/Activate Recurring Journal Template
You can create recurring journal templates to generate recurring journals for transactions that you repeat every accounting period in Adaptive Planning and Consolidation (AP&C).
Examples:
- Accruals.
- Allocations.
You can optionally configure the
Recurring Journal Template Event
business process to include an Approval
step immediately after initiation. This enables you to review, approve, send back, or deny the recurring journal templates before they are finalized. Recurring journals have the same journal lines for the same accounts and amounts. You can apply the same custom validations you create for the accounting journal.
Workday doesn't apply account segment security to recurring journal templates or recurring journals that you generate.
- (Optional) Edit Business Processes.Add an Approval or Review step to the Recurring Journal Template Event business process definition.
- Access theCreate Recurring Journal Templatetask.
- As you complete the task, consider:
Option Description LedgerSelect a company that includes 1 of these ledgers:- Actuals
- Commitment
- Obligation
Enable MulticurrencySelect to enable the:- Currency Rate Typetemplate prompt.
- Reset Currency Rate at Journal Generationcheck box.
- CurrencyandCurrency Ratecolumns in theJournal Entry Linesgrid.
Template Start DateTemplate End DateYou can enter a start date that is in the future. TheTemplate Start DateandTemplate End Datedefine the accounting date window within which recurring journals can be generated from a given template. The Template Start Date does not control the template's status. For recurring journals to be generated, the template must be in anAvailablestatus.You can create future-dated recurring reversal journals before a reversal period opens. Workday assigns a status ofCreatedto future-dated reversal journals.Journal SourceDisplays journal sources that you set as anAccounting Sourceon theMaintain Journal Sourcestask.Currency Rate TypeWorkday uses the currency rate typer override that you select on theEdit Company Accounting Detailstask. When you don't specify a default currency rate type for the company, Workday uses the default currency rate type for the tenant.Reset Currency Rate at Journal GenerationSelect to have Workday reset to the default currency rate.External Reference IDEnter the reference ID to track imported journals for auditing purposes.When generating a journal from a template, Workday automatically populates this external ID on the resulting journal header based on the value in the template.Document LinkAdd theAccounting Journal Document Linktype and valid uniform resource identifier (URI) patterns on theMaintain External Link Validationtask. This configuration enables you to link external documents to accounting journals.If you store supporting documents or images in an external repository, then enter the URL to that location. Once you save the transaction, Workday displays the URL as a live hyperlink to the image. Approvers can reference this document before approving the transaction.Workday validates the link to ensure that it has a valid Uniform Resource Identifier (URI) pattern, as defined by your security administrator. This process provides additional security to help avoid malicious content in external links.Create ReversalSelect to create a reversal journal with the recurring journal template.the defaultReversal Dateis the first day of the next period.Ledger AccountSelect a ledger account.Displays the ledger accounts that are available for use with the company you select. Based on the restricted-to companies you enter on theCreate Account SetorEdit Account Settasks.WorktagUse worktags as keywords to more easily classify and find transactions. Configure the allowed worktag types on theMaintain Worktag Usagetask. When you select a worktag type that has related worktags, Workday automatically populates transactions with the related worktag values. - Click either:
- Save for Laterto save the journal template. The template status changes toCreated.
- Submitto submit the journal template per the business process.
By default, theRecurring Journal Template Eventbusiness process contains only an initiation step. If you don’t add an Approval or Review step, all newly created templates will complete and activate automatically upon submission.If you added an Approval step to theRecurring Journal Templatebusiness process, Workday routes the completed template for review and approval. The template will remain with anIn Progressstatus until the template is approved. Once the template is approved the template status changes toAvailable. If the template is denied the template status changes toCanceled. If the journal template is sent back, the status remainsIn Progress. - Access theRecurring Journal Generationtask.Create journals based on recurring journal templates. You can create future-dated reversal journals before a reversal period opens. Workday assigns a status ofCreatedto future-dated reversal journals.
- Access theMass Post Reversal Journalstask.Post the reversal journals when the reversal period opens.
Workday verifies any custom journal validations by creating a canceled journal when you submit your recurring journal template. The canceled journal doesn't affect your general ledger.
Access the
Find Recurring Journal Template
report to review your recurring journal templates and perform these tasks to change the availability of a template without initiating a business process event:
- From the related actions menu of the template, selectRecurring Journal Template > Inactivateto inactivate a Recurring Journal Template that’s inAvailablestatus.
- From the related actions menu of the template, selectRecurring Journal Template > Activateto activate a Recurring Journal Template that’s inNot Availablestatus.
- From the related actions of the template, selectRecurring Journal Template > Cancelto cancel a Recurring Journal Template.You can only cancel templates that meet all of these conditions:
- Status is inCreatedorIn Progressstatus.
- Has not generated any journals.
- Has no successfully completed events.