Manage dimension tables

On the Treasury Cash Management page, click Administration > Manage Dimension Tables to access the following features:

• Manage BAI2 cash codes

• Manage bank accounts

• Manage companies

• Manage Detail Rollup

• Manage FSDetail

Manage BAI2 cash codes

BAI2 cash codes are part of the cash management balance reporting specification developed by the BAI (Bank Administration Institute).

1. On the Treasury Cash Management page, click Administration > Manage Dimension Tables.

2. Click BAI2 Cash Codes.

   

3. For each cash code, enter or modify the description.

4. Select the applicable Plan Rollup from the drop-down menu.

5. Select the checkbox in the Plan Include column to include the plan in the forecast or clear the checkbox to exclude the plan.

6. Select the applicable Report Rollup from the drop-down menu.

7. Select the checkbox in the Report Include column to include the plan in the report or clear the checkbox to exclude the plan.

8. Select the applicable Level option from the drop-down menu. Options include: Detail, Status, and Summary.

9. Select the transaction type from the DBCR drop-down menu to indicate whether this code is a debit (DB) or credit (CR).

10. To filter records, click Data filter to open the Filter Wizard window, enter and select criteria, and then click OK.

11. Click Save to save any added changes.

12. Click OK to confirm the saved data.

Manage bank accounts

1. On the Treasury Cash Management page, click Administration > Manage Dimension Tables.

2. Click Bank Accounts.

   

3. For each bank account, enter or modify the Description.

4. Select a Company and Group.

5. Select a Plan Code and a Plan Rollup from the drop-down menus.

6. Select the checkbox in the Plan Include column to include the plan code in the forecast or clear the checkbox to exclude the plan code.

7. Select the applicable Report Rollup from the drop-down menu.

8. To filter records, click Data filter, enter and select criteria, and then click OK.

9. Click Save to save any added changes.

10. Click OK to confirm the saved data.

Manage companies

1. On the Treasury Cash Management page, click Administration > Dimension Table Management.

2. Click Companies.

   

3. To add a company, click Add Company. A new row appears at the top of the table.

4. Enter a Company name and Description.

5. Select the checkbox in the Include? column to include the company in the Cash Forecast or clear the checkbox to exclude the company.

   NOTE: The TCM Budget Integration columns appear only if they are enabled on the Administration > Cash Flow / Working Capital > Budget Integration page.

   • Select the applicable Primary Bank Account to include.

   • Enter the cash amount for the FY 2022 Beginning Balance.

     NOTE: The cash amount is used to calculate the budgeted daily cash balances.

     NOTE: The year is based on the current year defined on the Administration > Cash Flow / Working Capital > Budget Integration page.

6. Click Save to save any changes.

7. Click OK to confirm the saved data.

Manage Detail Rollup

1. Click Administration > Dimension Table Management.

2. Click Detail Rollup. A Detail rollup categorizes transactions based on information in the description field.

   

3. To add a new record to the table, click Add Detail Rollup. An additional blank record is added to the top of the table.

4. Enter a name and description for the new detail rollup in their respective fields.

5. Select the applicable category in the Plan rollup drop-down menu.

6. Select the checkbox in the Include? column to include the detail rollup in the forecast or clear the checkbox to exclude the detail rollup.

7. Select the detail rollup to use in the Working Capital Dashboard from the Report Rollup drop-down menu.

8. Select the applicable options in the Budget Integration columns.

   NOTE: The Budget Integration columns appear only if they are enabled on the Administration > Cash Flow / Working Capital > Manage CFWC data and processes page.

   1. Select the applicable FS (Financial Statement) Summary (a high-level category in budgeting, such as salaries or supplies) to assign each Detail Rollup.

   2. Select the applicable Budget BAI2 Cash Code related to the selected FS Summary field to assign each Detail Rollup.

   3. Select the applicable Pay Date for each Detail Rollup (this selection indicates how the amounts are translated from monthly to daily).

      NOTE: The Payment Date Methods are defined on the Administration > Cash Flow / Working Capital > Manage CFWC data and processes page.

9. Click Save to save any changes.

10. Click OK to confirm the saved data.

Manage FSDetail

Budget data is assigned to multiple categories called Financial Statement (FS) Details. You can assign these categories to a Detail Rollup (defined in the previous section).

NOTE: The FSDetail tab appears only if Budget Integration is enabled on the Administration > Cash Flow / Working Capital > Manage CFWC data and processes page.

1. Click Administration > Dimension Table Management.

2. Click FSDetail.

   

3. Select the checkbox in the Include? column to include the FSDetail in the forecast or clear the checkbox to exclude the FSDetail.

4. Select the applicable Detail Rollup from the drop-down menu. To view the details of the Detail Rollup, see Manage Detail Rollup.

5. Click Save to save any added changes.

6. Click OK to confirm the saved data.