Steps: Define Normalized Bank Balances
Workday enables you to create normalized groupings of opening, closing, float, and other
balances across all of your bank statement file formats. You can standardize the bank
balances by type code to simplify cash position and cash forecast reporting.
- Access theMaintain Normalized Balancestask.Workday automatically populates normalized balance names and assigns them to normalized balance types. You can modify the default names or create new ones for reporting purposes.Workday provides these normalized balances and their corresponding types:
- Opening Ledger:Opening
- Opening Available:Opening
- Closing Ledger:Closing
- Closing Available:Closing
- Float:Float
You can inactivate any normalized balances that you don't use, and that aren't mapped in a normalized balance set.Security:Set Up: Cash Forecastingdomain in the Cash Management functional area.
When you upload bank statements, Workday derives the normalized balances based on the
mapping set.
To include the normalized balances in cash position and cash forecast reports, either:
- Add theNormalized Balancereport field available on theBank Statement Balance (All)business object to a custom cash position report.
- Select normalized balances when defining a cash forecast outline. Workday displays the normalized balances as actuals in theCash Forecast to Actuals in Reporting Currencyreport.