Customizing the Consolidated Balance Report

 

You can set up the Consolidated Balance Report to display information that suits your needs. You can save your settings under a unique Report ID that you can use whenever you want to view or print the report.

 

1.      From the Account Information menu, select Consolidated Balances.

 

2.      On the Consolidated Balance Report screen, select the create link to access the ‘Create a Custom Consolidated Balance Report’ screen.

 

3.      In the Report ID field, enter the name of the new report.

 

4.      You can schedule a Report by selecting the ‘Yes’ option for the Schedule Report and then select the starting date, frequency and time for the Schedule.

Note: Scheduled reports will be available within 15 min of the selected scheduled time.

 

5.      The Standard Report Groups are displayed on the lower half of the screen.  If you want to exclude any of these groups from the report, click on [delete] next to the group that you want to remove.  A message will come up asking if you are sure you want to delete a particular group? Click OK.

 

6.      You can add new groups that contain accounts that you want to group together.  To add a new group:

·         In the Group Name box, enter the name of the new group.

·         From the Group Currency dropdown menu, select the currency of the accounts that you would like to select for this group. 

·         From the Group Type dropdown menu, select the type of accounts the group will contain. The available choices are:

 

DDA

Indicates Scotiabank current accounts - including Canadian-domiciled USD and Foreign Currency Account types (FCA) (i.e. EUR, JPY, and GBP accounts)

 

 

OLL

Indicates loan accounts

 

 

TD

Indicates term deposits and GICs

 

 

GBL

Indicates global accounts that are held at other banks around the world

 

 

WIA

Indicates the US domiciled investment style Money Market Deposit Account

 

 

OPR

Indicates the US domiciled transactional style Demand Deposit Account

 

 

Click on the Add Group button and the ‘Add a Consolidated Balance Reporting Group’ window will appear.

·         To assign an account to the Report Group, highlight the account in the Accounts Available list and click on the   >  button.

·         To remove an assigned account, highlight the account in the Accounts Assigned list and click on the  <  button.

·         Click on the Save button to save your changes and return to the ‘Create a Custom Consolidated Balance Report’ screen.  The new report group will be listed on the lower half of the screen.

 

7.      You can determine the order in which the Groups will be displayed on the report:

·         Click the Group Order button to access the CBR Group Order screen.

·         Click on a Report Group to highlight and, using the arrows to the right of the screen, move the group to the desired position.   

·         Click on the Save button to save your changes.

 

8.      Once you have selected the parameters for the Custom Consolidated Balance Report, you can save them by clicking the Save Settings button.

 

Your settings will be saved under the Report ID that you assigned to the custom report and the new Report ID will appear as one of the options in the Reports dropdown menu.

 

 

 

 

 

Related Topics
About the Consolidated Balance Report
Modifying/Deleting a Custom Consolidated Balance Report ID
Viewing/Printing the Consolidated Balance Report

Setting a Consolidated Balance Report Default

My Global Accounts
Additional Help