Create Bank Statement Worktag Mappings

Security: Set Up: Map Worktags
domain in the Common Financial Management and Worktags functional areas.

You can create worktag mappings based on type codes that identify transactions on bank statements. The bank statement worktag mappings are applied to all of your bank accounts. Workday uses the worktag mappings to process cash position reports and automatic bank statement reconciliations by:

Grouping cash activities by worktag on cash position reports.

Matching bank statement lines with your operational transactions based on worktags specified in reconciliation condition rules.

Assigning worktags to new ad hoc bank transactions created for first-notice items.

You can create a set of worktag mappings for each of these bank statement file formats:

BAI2

BTRS

ISO 20022

MT940/942

Other

Access the

View Bank Statement Worktag Mapping

report.

(Optional) Click

Edit Default Worktags

to select default worktags to use when there are no matches for the specified mappings.

You can select multiple worktags, but only 1 of each category.

Select the bank statement file format for which to define your worktag mappings.

You create a unique set of worktag mappings for each bank statement file format that you use.

Click

Maintain Bank Statement Worktag Mapping

to map the type codes for the selected bank statement file format to worktags.

You can assign the same worktag to more than 1 type code.

For each bank statement that you manually enter or upload, Workday assigns the worktags to bank statement lines based on the worktag mappings.

You can override the bank statement worktag mappings using specific attributes on bank statement lines. This enables you to apply the worktag mappings at a more granular level. You can apply the same override mappings to multiple bank accounts of your choice.

Create Bank Reconciliation and First Notice Item Condition Rules

Steps: Define Cash Activity Categories