Table of Contents
Purpose... 3
1. Quick Balances ... 3
1.1. Quick Balances Setup ... 3
2. Scheduled Statement Reporting... 5
2.1. Scheduled Daily Operating Account Statement... 5
2.2. Scheduled Intra-day Statement ... 11
2.3. Scheduled Daily Operating Account Statement Via Email... 16
3. Statements Reporting... 18
3.1. Operating Account Statements Based On Date Range Selection... 18
3.2. HTML, PDF And CSV Reports ... 20
3.3. Intra-day Statements ... 24
4. Cash Info Manager – Quick Reference... 26
5. Trade Info Manager ... 36
5.1 Trade Transactions Covered ... 36
5.2 Trade Info Manager ... 36
5.3 Create Report ... 37
5.3.1 Select Product & Sub-Product ... 38
5.5.2 Select Columns & Sorting... 39
5.3.3 Select Filter Settings... 40
5.3.4 Select Schedule & Delivery ... 42
5.4 Manage Reports ... 44
5.4.1 Shared Reports... 45
5.4.2 Report View & Report Running Online ... 46
5.4.3 Copy Report... 48
5.4.4 Delete Report... 49
5.4.5 Export Report... 50
5.4.6 Detailed Report View ... 52
5.5 Create & Save Alerts ... 55
5.5.1 Create Alert... 56
5.6 Manage Alerts... 62
5.7 Quick Search ... 65
Disclaimer
This document is issued by Standard Chartered Bank (“SCB”). While all reasonable care has been taken in preparing this document, no responsibility or liability is accepted for any errors of fact, omission or for any opinion expressed herein. You are advised to exercise your own independent judgment (with the advice of your professional advisers as necessary) with respect to the risks and consequences of any matter contained herein. SCB expressly disclaims any liability and responsibility for any losses arising from any uses to which this document is put and for any errors or omissions in this document. This document contains information that is proprietary to SCB and should not be circulated to third parties without SCB’s prior written approval.
Purpose
The Reporting Easy Reference Guide has been created with the intention in showing users quick and easy steps in getting account statement balances.
1. Quick Balances
The Quick Balances section displays the balances for up to Three Operating and Three Deposit accounts you have selected to be your defaults. The balances displayed based on the previous day as well as the latest available balance (if available).
1.1. Quick Balances Setup
Step 1:
• Click ‘Home’
• Click ‘Select Accounts’
• Select ‘Account Class’
• Select ‘Company’
• Select ‘Bank’
• Select ‘Currency’
• Select ‘Account Number’
• Click ‘Save’
Step 3:
• Clicking on the hyperlinks will allow you to drill-down into the reports to obtain a greater level of detail.
2. Scheduled Statement Reporting
2.1. Scheduled Daily Operating Account Statement Step 1: Select
• Reports
• Cash
• Operating Account Statement
Step 2:
• Select ‘Company’
• Select ‘Currency’
• Select ‘ Account Number’
• Specify whether ‘Credit/Debit’ amount to be shown
• Specify ‘Sort On’ by Amount
• Specify ‘Sort Order’ – Ascending or Descending
• Specify ‘Consolidated Statement’ – Yes or No
• Click ‘Save as Template’
Step 3:
• Enter ‘Template Name’
• Specify Public or Private Template
• Click ‘Add A Schedule’
Step 4:
• Specify ‘Schedule Start Date’
• Specify the frequency of the report
• Specify the report format to be received in PDF or CSV or Message format
• Click ‘Save Template’
• Click ‘Close’
Once generated, an alert message will appear in the Straight2BankMessage Center on the homepage to notify you that the schedule query is available.
• Click on the alert message to view the report.
• Click ‘Report Link’
• Click ‘Open’ or ‘Save’
Note: Straight2Bank Web Statements will only be available for 90 days. Kindly perform the required backup of the statements downloaded at your end for future retrieval.
2.2. Scheduled Intra-day Statement Step 1: Select
• Reports
• Cash
• Intraday Transaction Details
Step 2:
• Select ‘Company’
• Select ‘ Account Number’
• Specify whether ‘Credit/Debit’ amount to be shown
• Specify ‘Sort On’ by Amount
• Specify ‘Sort Order’ – Ascending or Descending
• Specify ‘Consolidated Statement’ – Yes or No
• Click ‘Save as Template’
Step 3:
• Enter ‘Template Name’
• Specify Public or Private Template
• Click ‘Add A Schedule’
Step 4:
• Specify ‘Schedule Start Date’
• Specify the frequency of the report
• Specify the report format to be received in PDF or CSV or Message format
• Click ‘Save Template’
• Click ‘Close’
Once generated, an alert message will appear in the Straight2BankMessage Center on the homepage to notify you that the schedule query is available. Click on the alert message to view the report.
• Click on the alert message to view the report.
• Click ‘Report Link’
• Click ‘Open’ or ‘Save’
Note: Straight2Bank Web Statements will only be available for 90 days. Kindly perform the required backup of the statements downloaded at your end for future retrieval.
2.3. Scheduled Daily Operating Account Statement Via Email
Below are the steps for setting up scheduler for delivery PDF Operating Account Statement for via Info Manager Email.
Step 1
• Navigate to Cash Management Reports / Info Manager
• Click “Manage Reports”
Step 2
Under “Manage Cash Reports” Tab
• Select “Adhoc Reports”
• Check against the “Adhoc Statement”
• Click “Edit Report”
Step 3
• Enter “Report Description” if applicable. (Optional)
• Under “Filter Settings”, select the accounts information need for report generation.
• Go to “Schedule & Delivery” Tab
• Specify the scheduling criteria for delivering the PDF Operating Account Statement
• Click “Save Report”.
Select the accounts information need for report generation.
Specify the scheduling criteria for delivering the PDF Operating Account Statement.
3. Statements Reporting
3.1. Operating Account Statements Based On Date Range Selection Step 1: Select
• Reports
• Cash
• Operating Account Statement
Step 2:
• Select ‘Company’
• Select ‘Currency’
• Select ‘ Account Number’
• Specify the date range
• Specify whether ‘Credit/Debit’ amount to be shown
• Specify ‘Sort On’ by Amount
• Specify ‘Sort Order’ – Ascending or Descending
• Specify ‘Consolidated Statement’ – Yes or No
• Click ‘Run Report’
Step 3: Click ‘Print’
3.2. HTML, PDF And CSV Reports
After clicking on ‘Print’ – Report in HTML format will be launched.
HTML Report
Other Reporting Format Available:-
• PDF Report Format
• CSV Report Format
When click on ‘Request as PDF’, below message will be reflected.
When click on ‘Request as CSV’, below message will be reflected.
To retrieve the PDF and CSV reports, perform steps listed below.
• Click ‘Home’
• Go to Straight2BankMessage Center
• Click on the alert message to view the report.
• Click ‘Report Link’
• Click ‘Open’ or ‘Save’
.
Note: Straight2Bank Web Statements will only be available for 90 days. Kindly perform the required backup of the statements downloaded at your end for future retrieval.
3.3. Intra-day Statements Step 1: Select
• Reports
• Cash
• Intraday Transactions Details
Step 2:
• Select ‘Company’
• Select ‘ Account Number’
• Specify whether ‘Credit/Debit’ amount to be shown
• Specify ‘Sort On’ by Amount
• Specify ‘Sort Order’ – Ascending or Descending
• Click ‘Run Report’
Step 3: Click ‘Print’
4. Cash Info Manager – Quick Reference
The Cash Info Manager module enables users to :-
1. Self administer the creation and scheduling of customized reports.
2. Deliver reports via e-mail.
3. Send an EOD statement and intraday advices.
Steps To Be Performed Under Info Manager Cash
Use Info Manager to create “Operating Account Statement”.
Click “Create Report”.
Create a Custom Report
Specify the “Report Name”
Specify “Report Description”
Select “Both”
Under Columns & Sorting Tab
Specify the type of Data for Operating Acc Statement to be reflected in the report.
Specify the “Sort Order” - eg by “Account Name” in Ascending order.
Options Available:
Data to be reflected:
Click “On” for Schedule & Delivery
Specify “Start Date” & “End Date”
Specify “Frequency” – Daily or Weekly or Monthly.
Specify the time where the report should be delivered in 24Hrs format.
Specify the “Delivery Format” – CSV or Excel only.
Specify the “Delivery Channel”
Specify “Email To” – the recipients email address.
Tick against the box for “ ”.
Input the content for “Custom Email Body”.
Tick against the box for “ ”.
Click “ ” .
From here user can perform 3 options 1. Run Report
2. Save Report
3. Save and Run Report
By clicking “ ” Æ the Scheduled Custom Report “Ops Acc Statem” will be saved and the HTML report will be reflected.
From here, user can either:-
Print All
Export All Reports
Print All
When click “ ” – the HTML Report will be launched.
Sample Printout.
Select “Excel File”
Click “Export”
Click “Save” for saving the excel file to a local PC drive.
Sample Excel Report.
This same excel report will be delivered via email as well.
Other Useful Information Straight2Bank Web Form
Info Manager Cash Report Delivery Format
If ZIP format is selected, email sent to the recipient will contain a ZIP file as illustrated below:-
When click on the ZIP file, it will prompt the recipient for password during the extraction process.
E-mail Domain
As of now 256 characters is the maximum allow field length in email domain column.
If more than 1 Email Domains are entered should it be by Comma.
If PDF format is selected, email sent to the recipient will contain a PDF file as illustrated below:-
When click on “ ”, it
will prompt the recipient for password.
Sample Excel Report.
PDF file will be launched after successful password entry and recipient can retrieve the attachments from the PDF itself.
5. Trade Info Manager
The Trade Info Manager module enables users to create customized reports, view transaction data online and receive alerts when trade activities they have previously selected occurs. Trade Info Manager will eliminate a large percentage of manual intervention required for traditional report generation.
5.1 Trade Transactions Covered
Trade Info Manager will support the following trade transactions.
IMPORTS EXPORTS
Letter of Credits Letter of Credits Bills lodged against L/C Bills lodged against L/C Documentary Collections Documentary Collections
5.2 Trade Info Manager Step 1: Select
• Reports
• Info Manager
Create Report This will help you create a new product specific Trade report, designed to your personal specifications.
Manage Report Using this option you can run, edit, copy and delete existing reports Create Alert Use this tool to set up alerts in few easy steps.
Manage Alerts To edit, copy or delete your existing alerts.
Quick Search This helpful function enables you to run a search on an individual transaction. In case the full transaction details are not known the search functions include the ability to use wild-card characters to find the correct information.
5.3 Create Report
To begin, select Create Report from the Info Manager menu. Here you are able to select your desired product and sub-product from the two drop down menus. Once completed, you can proceed to the selection of the various columns for your report.
At the end of this section, you will be able to create customized views of your trade transactions.
In a few simple steps you can define your Report Filter, Report Layout, Fields, Sorting order, Delivery Schedule, Delivery Channel and finally the Format for delivery.
5.3.1 Select Product & Sub-Product Step 1: Select
• Reports
• Info Manager
• Create Report
Step 2: Select
• Select a Product
•
Select a sub product•
Click “Create Report”5.5.2 Select Columns & Sorting
To create Reports, Info Manager provides three tabs:
• Columns & Sorting
• Filter Settings
• Schedule & Delivery
Where you will be prompted to fill in or select relevant information. Once you are ready with this tab, select next tab, i.e. “Filter Setting”.
Step 1: Columns & Sorting
• Enter Report Name
• Enter Report Description
• Select Columns from this list. Press “Ctrl” key and click on individual items for multiple selections.
• Click on the or to move the selected items
These options allow you to change column name and sorting order.
5.3.3 Select Filter Settings
Filters enable you to “fine tune” the data which will appear in your report. Select those filters which are most appropriate to your report.
Step 1: Filter Settings
• Select available filter criteria from this list. Press “Ctrl” key and click on individual items for multiple selections.
• Click on the or to move the selected items
• Click “Continue” button when complete OR
• Click “Reset” button to clear selections.
Depending on the type of filter selected (i.e. text box, numeric, date etc. as shown in previous page) list boxes, text boxes or calendar are displayed as appropriate to your choice.
Step 2: Options available
• Click “Save” to save report. OR
• Click “Run” report OR
• Click “Reset” to clear information
To run the report online, system will prompt you to enter values, for generation of the report online. You can also use Text fields which supports “wild-card” characters e.g. “%”. If you wish to filter a Beneficiary name which has a pattern like, “Company” in between, you can use a combination of wild-card character and text (e.g.“%company%”) in Beneficiary text box. For your ease of use, we have designed the date field to support all types of “Roll Over Dates”, which are:
Current Date : Report will show result as of “system date”
Last Month : Report will show result for “last month”
Between two dates : Report will display result between the
“from” and “to” dates
Before any specific date : Report will show result based on a specified
“Before Date.”
After any specific date : Report will show result of dates between “After Date” and “System Date.”
Amount field will be supported for following options :
This section allows you to select appropriate options for each of your selected filter criteria. NOTE: You can use the built-in calendar tool.
5.3.4 Select Schedule & Delivery
Click ‘Schedule & Delivery’ for scheduling reports and chose report delivery channel. By default the Schedule & Delivery option remains ‘Off’, which needs to be turned ‘ON’ by you. Note: All fields in this dialogue are mandatory. Hence care should be taken while selecting dates etc.
Step 1:
• Schedule & Delivery – Click “ON”
• Start Date - specify a date for initiation of report delivery
• End Date - indicate end date of report delivery
• Define frequency of the report generation – Daily, Weekly and Monthly.
• Delivery Format – select CSV, or Excel format for delivery
• Delivery Channel - offers different delivery modes of report via Straight2Bank Message and Email. In case of Email option, enter an email ID for report delivery. You can also enter multiple email IDs using comma separators. If you select Straight2Bank Message option, reports would be generated according to the schedule and message would be generated and remain stored in your message centre.
• Save or Run your reports. You can use either of the two buttons for necessary action.
You will receive a message confirming the same.
From Run Report screen if you click the hyperlink, you can see the corresponding details of your transaction
5.4 Manage Reports
From Manage Reports, you can select type of reports to be viewed e.g. All Reports, System defined Reports, Recently Run Reports, Shared Reports as shown in the screen.
Step 1: Select
• Reports
• Info Manager
• Manage Reports
• You can view and sort your reports from here. E.g. Import OR Export types
• Also select your sub-product as shown here.
All Reports: All the “User defined” and “System defined” reports will be displayed. Under this option, for each report, you can view details such as, if the report is a) Scheduled or not. b) User Defined or System Defined.
System Defined Reports: You will be provided with system defined (pre-defined) reports only, which will have fixed selection criteria, fixed sorting order and fixed report format. You can use these report formats as templates or baseline format to define your own personalised MIS report.
Recently Run Reports: Reports which have been run by you recently will be displayed.
5.4.1 Shared Reports
Share Reports: Under this option, you can share reports among your user group. During this process, if the Attribute Access Profile (AAP) of the users with whom the report is shared will be checked. If the group user does not have the requisite AAP, sharing will not be allowed and an alert will be displayed. The schedule of the report will not be transferred to the other users.
Following screen displays simple procedure of selecting users within your group and the system confirmation.
5.4.2 Report View & Report Running Online
You can search for reports by Report Name, Product, Schedule or Delivery Format. Various action buttons are provided to help you in run edit, copy and delete reports.
Run Reports Online: Apart from delivering the report to you on a predefined schedule, the option also exists for you to execute your reports online as and when required. The report will be generated in a format defined by you.
Drop down menu for report viewing option
Hyper-linked Report Name for Click & View.
Hyper-linked Report Name for Click & View.
Similarly, all other details pertaining to a particular Trade Transaction can be viewed by clicking the corresponding tab, (For example: Document Details Drawing Bills Financial Details and Transaction History)
The complete transaction is on display, which you can print using print option of Internet Explorer.
5.4.3 Copy Report
This is a handy option which saves you from creating a new report from scratch. Just create a copy of one of the existing custom reports and select the option to edit its definitions.
Step 1:
• Enter new report name.
• Click “Save”
5.4.4 Delete Report Step 1:
• Click on the Radio button for selection of report for deletion.
• Click “Delete Report” button.
• System will ask for delete confirmation.
NOTE: You can only delete one report at a time.
5.4.5 Export Report
Info Manager allows you to export your reports in CSV or EXCEL formats.
• Click “Run Report”
• Click ”Export Report”
A pop-up screen will appear for selection of desired file format.
• Click to select file type
• Click “Export”
• Click “OK”
5.4.6 Detailed Report View
Available information under LC Details view tabs.
5.5 Create & Save Alerts
Info Manager will allow alert generation for various trade transactions. The following table explains alert details under various products.
Alert Type Product type Product Alert Activity Event Based Imports Letter of credit Issuance
Amendment
Documents presentation
Documents accepted Documents paid
Event Based Imports Collections Documents received Documents accepted Documents paid
Event Based Imports Shipping Issued
guarantees Sent for redemption
Event Based Exports Letter of credit Advising
Amendment advising
Confirmation Event Based Exports Bills under LC Discounted
Documents presented
Acceptance received Payment received
Event Based Exports Collections Discounted
Documents presented
Acceptance received Payment received
Event Based Export Loans Approval
Event Based Import Loans Approval
5.5.1 Create Alert
The Create Alert option under Info Manager is designed to send notification to the user when a pre-defined trade activity has occurred. The alerts generated can be sent via email or fax.
You can navigate to this page directly from Info Manager main menu by performing Step 1: Selecting
• Reports
• Info Manager
• Create Alert
Step 2:
•
Start with the selection of Product & Sub-Product•
Click “Create Alert” button.Step 3: For Email/ Fax Delivery, enter
• Alert Name, Alert Description and Alert Activity
• Select Email / Fax Delivery and specify start date, end date & email address or fax no.
• Enter Subject for alert, select content from Available Columns and move them to Body Content using the arrow button .
Note : Do not forget to turn “ON” the delivery selection radio button.
Step 4: For Alert Trigger Setting
•
Select your filtering criteria and move them to selected criteria field, by using arrowbuttons - .
•
Click “Continue” to confirm selection.• Following screen will show up under trigger alert setting and prompt you to fill in details for corresponding selected filter criteria
• Click “Save My Alert”
After entering the criteria, you have the option to attach corresponding documents which pertain to the transaction and user.
Step 5:
• Click “Attach Document”
A detailed list of attachments which are available under various alert types is provided in annexure.
Step 6:
• Tick to select desired attachment
• Click “Attached”
Step 7:
• Click “Save Alert”
System will confirm the operation.
5.6 Manage Alerts
Step 1: Select
• Reports
• Info Manager
• Manage Alerts
You can sort & search alerts by:
• Alert name,
• Product,
• Alert activity &
• Delivery channel.
• You can also use wild-card characters for searching.
You can also perform Edit, Copy or Delete alerts
Edit Alert
This is similar to creating an alert, wherein you have the option to change or add information to an existing alert (See section 4.5.1Create Alert).
Copy Alert Step 1:
• Click on the “Radio Button”
• Click “Copy Alert”
• Enter new “Alert Name”
• Click “Save”
Once done, you will receive a conformation.
Delete Alerts Step 1:
• Click on the “Radio Button”
• Click “Delete Alert”
• Click “OK”
5.7 Quick Search
Step 1: Select
• Reports
• Info Manager
• Manage Alerts
You can use Quick search dialogue box to look for specific reports by specifying
• Product Type
• Reference No
• Reference Value (including wild-card characters).
• Click “Search”
• Click the hyperlinked “SCB Deal Ref No”.
