Create Ad Hoc Bank Transaction Templates

Configure the Ad Hoc Bank Transaction Template Event
business process and security policy in the Banking and Settlement functional area.

Security: Set Up: Ad Hoc Bank Transaction Template
domain in the Banking and Settlement functional area.

You can set up templates to simplify the process of creating recurring ad hoc bank transactions with common attributes. Workday automatically populates the values from a predefined template onto new ad hoc bank transactions created from the template.

Example: Your bank statements include interest earned on your account balances each month. You set up a template to create ad hoc bank transactions for this recurring first-notice item during first-notice reconciliations.

Access the

Create Ad Hoc Bank Transaction Template

task.

As you complete the

Ad Hoc Bank Transaction Line Defaults

section, consider:

Option	Description
Company	Select a line-level company other than the header company to create and reconcile intercompany ad hoc bank transactions.
Revenue/Spend Category	Select a revenue or spend category to use for posting the ad hoc bank transactions to ledger accounts.
Assign Worktags from Bank Statement Line	Select to assign revenue or spend category worktags from the bank statement lines reconciled to the ad hoc transactions. Workday also assigns the worktags to ad hoc transactions created for first-notice items. When you assign the worktags from the individual statement lines, you can reuse the template across different business areas. If you select both the check box and a default revenue or spend category, Workday only uses the worktags from the bank statement lines.
Worktags	You can assign worktags to use for account posting rule condition dimensions. You can also use worktags to classify and track ad hoc transactions for financial reporting.

As you complete the

Accounting Options

section, consider:

Option	Description
Exclude Bank Account Worktag on Lines	Select to exclude the bank account worktag from noncash accounting lines and add it to only cash lines for ad hoc bank transactions. Example: You can exclude the worktag on line company expense journal entries for intercompanies that don't have access to the bank account.
Eliminate Foreign Exchange Gain or Loss	Select to exclude realized foreign exchange gain or loss from ad hoc bank transactions. Example: If you override the currency conversion rate with a bank rate from your statement, the difference between the 2 values creates a realized exchange gain or loss journal entry. When you select the check box, Workday eliminates this additional journal entry line and applies the difference to the expense or revenue journal entry.

Option

Description

Exclude Bank Account Worktag on Lines

Select to exclude the bank account worktag from noncash accounting lines and add it to only cash lines for ad hoc bank transactions.

Example: You can exclude the worktag on line company expense journal entries for intercompanies that don't have access to the bank account.

Eliminate Foreign Exchange Gain or Loss

Select to exclude realized foreign exchange gain or loss from ad hoc bank transactions.

Example: If you override the currency conversion rate with a bank rate from your statement, the difference between the 2 values creates a realized exchange gain or loss journal entry.

When you select the check box, Workday eliminates this additional journal entry line and applies the difference to the expense or revenue journal entry.

In the

Transaction Date Options

section, select a date type for ad hoc bank transactions and the associated accounting:

Statement Line Date

: The date when the financial institution posts the transaction to the bank account.

Value Date

: The date when the financial institution recognizes the full transaction value on the bank statement line.

Workday routes the completed ad hoc bank transaction template for review and approval.

Use the

Find Ad Hoc Bank Transaction Template

report to review your ad hoc bank transaction templates. From the related actions menu of a template, you can:

Copy your ad hoc bank transaction template to create additional templates.

Amend an ad hoc bank transaction template submitted for approval or that's already approved.

Edit an ad hoc bank transaction template that's in Draft
status.

Create manual ad hoc bank transactions from an approved template.

Specify an ad hoc bank transaction template in bank reconciliation, matching, and first-notice item rules or rule sets to use in automatic reconciliations.