Reporting Overview

Welcome to your training on the new Commercial Advantage platform.

Royal First Bank Commercial Advantage is a digital treasury platform that gives you access to real time information, seamless payment functionality and practical tools to meet daily cash flow requirements and make well-informed decisions. This webinar focuses on Reporting.

Once you log into Commercial Advantage, you’ll find default widgets on the Homepage. These widgets found can be customized to fit your specific needs. To resize or remove a widget, click on the gear located in the top right-corner of the widget and select the appropriate option.

Within the widgets themselves, there are additional customizing options. You can adjust the width of any column by hovering the mouse between two columns. When the double-headed arrow appears, click and hold the left mouse button and move the mouse to the right to expand or left to shrink the column.

Information in your view can be sorted by any of the available fields. Clicking the left side of a column header will sort the data for the selected column within the widget. If the column header is clicked a second time, the data will be sorted in reverse order. An arrow will appear in the column header indicating which order it is currently sorted, either from highest to lowest or lowest to highest.

You can change the order of the columns by simply dragging from one position to another while clicking and holding the left mouse button.

Selecting which fields, you wish to have displayed is also possible by clicking on the gear to the right of the column headers. This presents a series of fields that can be displayed for this widget. Select or deselect the fields you wish to see by checking or unchecking the box next to the field and then choosing Update at the bottom of the screen.

Once you've finished your customization, you can save your view by choosing the dropdown in the upper right of the widget and selecting Save View. You’ll be presented an option to name the view, save it, and set this as the default view for the widget.

One of the recommended widgets to have on the Homepage is the Account Summary. The same features are located in the Reporting Menu by selecting Balance and Transaction Reporting, but having the Account Summary widget on the Homepage provides quicker access to the information.

The Account Summary widget provides account balances and transactions that are updated in real time. You can refresh the balances by clicking the corresponding link and symbol at the top right corner of the widget. The Account Summary widget gives you a summary of all accounts and associated balance information based on the tab chosen from the top of the widget such as Previous and Current Day. The rollup of each tab contains the opening ledger, closing ledger and/or the current available balances for all accounts.

The Account Groups tab allows you to group accounts together for tracking and reporting purposes. Groups can be created for the available account types your company has: Deposit, Loan, and Line of Credit are examples. To begin, choose Create Account Groups. A pop-up box will appear where you’ll choose to Add Group and give the group a name. After naming the group, drag and drop the accounts you want to include from the first column to the blue box containing the group name, then click Save. Once a group has been created, it remains available for future use such as in creating and writing custom reports.

Speaking of custom reports, you can create and write them by selecting the Custom Reporting tab from the Account Summary widget, and then selecting either a previously created report or creating a new one.

And from the Transaction Search tab you’re able to search transactions. You can also run transaction reporting from the individual account pages.

To print a view of the information you see in the widget, click the printer icon and choose all items or selected items. This will create a Landscaped PDF version of the data on the screen, known as a Print View, that can be simply viewed, downloaded and saved or printed. This information is a more formal version of a screen capture and will include all the data from the page.

There’s also the ability to export from Commercial Advantage as well. You’ll simply choose the Export icon and select the desired format from the dropdown list to fit your organization needs. There are several export types to choose including: Standard grid export, BAI export, CSV, SWIFT and TSV. After selecting the type, click on the create export button to generate the file in your chosen format. Once you have exported the file, you’ll be able to access the file from the Download page. Here you’ll find the files as well as the status of those files, such as In-Progress or Completed. The Status of In-Progress reports can be updated by selecting the refresh icon within the platform. These exports, which you can also begin from the Download page, will stay within Commercial Advantage for a period of seven days, giving more than enough time to View or Download the reports as desired.

The Print and Export functionality is also available within the Specific Account, as well as other pages in the Commercial Advantage Platform.

To create and save a new custom report, start at the Custom Reporting tab, and populate the available fields with the desired selection criteria. Notice that there is the capability to show from reports that have been saved previously to speed the report creations or create new reports. You’ll begin by selecting the account or group of accounts desired, followed by the date or time frame and how you would like to see the credits and debits—either separately or in a single view. Next choose to filter the transactions to your preference or leave this field blank to run the report for any and all transactions that meet the report criteria. Once you’ve completed setting the full criteria for the report, you can Save this report by naming it, and also have the option to Share this saved report for others in your organization to select and run as needed.

Selecting Submit the report will process the report based on the criteria selected and present it at the bottom of the page. Notice the Report Criteria is rolled up at the top of the page where the ability to Edit is also available. The report will include a roll up for the overall group if that was chosen, as well as roll ups and transactions for each of the accounts.

By selecting the arrow to the left of the rolled-up account, the ledger information will be presented as well as a link to View Account Transactions meeting the criteria selected. You also have the ability to Print or Export your report to review the actual transactions as we discussed earlier.

Let’s come back to the Account Summary widget from the Homepage, or the Balance and Transactions page found in the Reporting Menu and take another look at the Transaction Search tab and the reporting available. Just as with the custom Reporting tab and reports, select the account or group of accounts, the date range and then choose the transaction filters. Unlike the Custom Reporting, the option to Save or Share the report is not available here. When this report is submitted the transactions are listed, without the account ledger information. The options to print and/or export the report are available as well.

With the transactions you’ll find the images, if available, where you can view, Save or Print the images depending on your organization needs.

As you can see, reporting is an integral part of the Commercial Advantage platform. On the Report Management page, found under Reporting, you'll see additional reports that are available depending on your permissions. Choosing View allows you to update the criteria filtering and to Save this Report for quick runs at a later time with the same criteria. The report will be generated in a PDF format and appear at the bottom of the page where the ability to Print, Save, and/or Export are also available.

Also under Reporting is the Legacy Reports. Legacy Reports are those that Royal First Bank runs from the bank’s system and presents to you in the Commercial Advantage platform. Simply edit the Search Criteria and select Search to present the reports for viewing, downloading, and printing.

Next—eStatements. eStatements is where you’re able to find electronic copies of your monthly bank statements.

The Image Search page gives you the ability to specifically search for and view Deposit Tickets, Checks and Return Deposit Items without having to sift through a broader Transaction Search.

Within Commercial Advantage there’s a great resource for additional assistance found at the Help Menu. Within Help you’ll find step-by-step guides related to General Information like User Administration as well as many other topics.

You also also have access to the Royal First Bank Commercial Advantage site, where you’ll find quick reference guides, user guides, videos and other webinars that provide helpful self-service assistance.

Thanks for watching this video where we provided a reporting overview within Commercial Advantage.