Manage CFWC data and processes

Use this page to manage CFWC (Cash Flow / Working Capital) data and processes.

On the Treasury Cash Management page, in the Cash flow and working capital section, click Manage CFWC data and processes.

• Data integration
• Forecast
• Reporting
• Filter records

Data integration

• Import files

• Manage companies

• Manage bank accounts

• Manage BAI2 cash codes

Import files

Data Integration tab, Imports tab (click to enlarge)

1. On the Treasury Cash Management page, in the Cash flow and working capital section, click Manage CFWC data and processes.

2. Click Data Integration.

3. On the Imports tab, enter a path for the CFWC (Cash Flow / Working Capital) file in the Import path field.

4. Select the format of the import file. Options include: Syntellis XLSX or BAI2.

5. Click one of the save options:

   • If you want to save this configuration to use with an automated import or save it to run later, click Save changes.

   • If you want to save this configuration and run the import immediately, click Save and run.

NOTE: This import can be set up to run automatically in the Axiom scheduler. See either the "Automated CFWC BAI2 Data Integration" or "Automated CFWC XLSX Data Integration" job (depending on which file format you selected) in the Scheduler to set up an automated import schedule.

Manage companies

Data Integration tab, Company tab (click to enlarge)

1. On the Treasury Cash Management page, in the Cash flow and working capital section, click Manage CFWC data and processes.

2. Click Data Integration.

3. On the Company tab:

   • To add a company: In the Add company section, enter a company ID and description.

   • To modify a company: In the Existing companies section, modify the company’s description.

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

4. Click Save.

Manage bank accounts

Data Integration tab, Bank account tab (click to enlarge)

1. On the Treasury Cash Management page, in the Cash flow and working capital section, click Manage CFWC data and processes.

2. Click Data Integration.

3. On the Bank account tab, for each bank account, enter or modify the description.

4. Select a company and bank.

5. Enter a group.

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

7. Click Save.

Manage BAI2 cash codes

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

Data Integration tab, BAI2 tab (click to enlarge)

1. On the Treasury Cash Management page, in the Cash flow and working capital section, click Manage CFWC data and processes.

2. Click Data Integration.

3. On the BAI2 tab, for each cash code, enter or modify the description.

4. Select a level: Detail; Status; Summary.

5. Indicate whether this code is a debit (DB) or credit (CR).

6. Indicate whether this code is intercompany (that is, can be used by multiple companies).

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

8. Click Save.

Forecast

• Manage settings

• Manage transaction assignment rules

• Run the assignment utility

• Manage bank account rollups

• Manage BAI cash code rollups

Manage settings

Forecast tab, Settings tab (click to enlarge)

1. On the Treasury Cash Management page, in the Cash flow and working capital section, click Manage CFWC data and processes.

2. Click Forecast.

3. On the Settings tab, enter or select a beginning forecast date.

4. Enter a version.

5. Select the day of the week on which to begin the forecasting report.

6. To save the information you entered, click Save changes.

7. To calculate the forecast for six weeks from the specified forecast date, click Run baseline forecast.

Manage transaction assignment rules

Forecast tab, Transaction assignment rules tab (click to enlarge)

1. On the Treasury Cash Management page, in the Cash flow and working capital section, click Manage CFWC data and processes.

2. Click Forecast.

3. On the Transaction assignment rules tab, click Add a New Record.

4. Specify the rule’s order; for example, 1, 2, 3, and so on.

5. Enter a search term.

6. Select a rollup bucket.

7. Indicate whether this is a debit (DB) or credit (CR).

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

9. Click Save.

Run the assignment utility

Forecast tab, Run assignment utility tab (click to enlarge)

1. On the Treasury Cash Management page, in the Cash flow and working capital section, click Manage CFWC data and processes.

2. Click Forecast.

3. On the Run assignment utility tab, enter or select start and end dates.

4. Indicate whether to overwrite previously labeled records.

5. Click Run transaction utility.

Manage bank account rollups

Forecast tab, Bank account rollups tab (click to enlarge)

1. On the Treasury Cash Management page, in the Cash flow and working capital section, click Manage CFWC data and processes.

2. Click Forecast.

3. On the Bank account rollups tab, for each bank account, select a plan code and rollup.

4. To include a rollup in forecasting, select the Include? check box.

5. Enter a group.

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

7. Click Save.

Manage BAI cash code rollups

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

Forecast tab, BAI cash code rollups tab (click to enlarge)

1. On the Treasury Cash Management page, in the Cash flow and working capital section, click Manage CFWC data and processes.

2. Click Forecast.

3. On the BAI2 cash code rollups tab, for each cash code, select a plan rollup.

4. To include a rollup in forecasting, select the Include? check box.

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

6. Click Save.

Manage detail rollups

Forecast tab, Detail rollups tab (click to enlarge)

1. On the Treasury Cash Management page, in the Cash flow and working capital section, click Manage CFWC data and processes.

2. Click Forecast.

3. On the Detail rollups tab, enter a description for each detail rollup.

4. Select a plan rollup.

5. To include a rollup in forecasting, select the Include? check box.

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

7. Click Save.

Reporting

• Manage bank account reports

• Manage BAI2 reports

• Manage detail rollup reports

Manage bank account reports

Reporting tab, Bank account tab (click to enlarge)

1. On the Treasury Cash Management page, in the Cash flow and working capital section, click Manage CFWC data and processes.

2. Click Reporting.

3. On the Bank account tab, for each bank account, select a report rollup.

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

5. Click Save.

Manage BAI2 reports

BAI2 is the cash management balance reporting specification developed by the BAI (Bank Administration Institute).

Reporting tab, BAI2 tab (click to enlarge)

1. On the Treasury Cash Management page, in the Cash flow and working capital section, click Manage CFWC data and processes.

2. Click Reporting.

3. On the BAI2 tab, for each cash code: Select a report rollup.

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

5. Click Save.

Manage detail rollup reports

Reporting tab, Detail rollup tab (click to enlarge)

1. On the Treasury Cash Management page, in the Cash flow and working capital section, click Manage CFWC data and processes.

2. Click Reporting.

3. On the Detail rollup tab, for each rollup bucket, select a report rollup.

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

5. Click Save.

Filter records

1. On the Treasury Cash Management page, in the Cash flow and working capital section, click Manage CFWC data and processes.

2. At the top of the page, click Data filter.

3. On the Filter Wizard, enter and select criteria.

   

   Example Filter Wizard (click to enlarge)

4. Click OK.