Map Bank Statement Balance Types to Normalized Balances

Security: Set Up: Cash Forecasting
domain in the Cash Management functional area.

You can map bank statement balance type codes to normalized balances for each bank statement format that you use. Workday summarizes the balance type amounts using the normalized balances.

Access the

Maintain Normalized Balance Mapping Set

task.

Select a bank statement file format.

Workday automatically populates the balance type code related to each normalized balance.

(Optional) Select a different balance type code to update an existing normalized balance mapping.

Workday groups the bank statement balance type codes by the mappings defined in the normalized balance set. You can display the normalized balances as actuals in cash position and cash forecast reports.

Workday provides these mappings for each bank statement format in the mapping set, which you can modify:

Normalized Balance	BAI2	BTRS	ISO 20022	MT940/942
Opening Ledger	010 Opening Ledger	010 Opening Ledger - BTRS	OPBD Opening Ledger Balance	60F Final Opening Ledger Balance
Opening Available	040 Opening Available	040 Opening Available Next Business Day - BTRS	OPAV Opening Available Current Day	62M Current Ledger Balance
Closing Ledger	015 Closing Ledger	015 Closing Ledger - BTRS	CLBD Closing Ledger Balance	62F Final Closing Ledger Balance
Closing Available	045 Closing Available	045 Closing Available - BTRS	CLAV Closing Available (Collected)	64 Closing Available Balance
Float	072 1-Day Float	072 1 Day Available - BTRS	FWAV Opening Available Next Business Day	65 Forward Available Balance