Integrated
Payments Reconciliation Reports
|
|
Two
types of the Integrated Payments Reconciliation Reports are available: 1.
Consolidated Reconciliation
Report provides you with the ability
to monitor the status of all payments initiated in the last 21 days and to
reconcile payment input and settlement. 2.
Consolidated Settlement Report
provides you with the ability to know how much to fund each settlement
account in order to fulfill all payments that will be settled on a specific
day. |
Consolidated
Reconciliation Report
|
|
Payments from one input file may have been
approved and settled at different points of time and therefore, were reported
on different settlement reports, and vice versa, payments listed in one
settlement report may have originated from various input files and were
listed on different input reports. This report allows you to track and
reconcile payments input and settlement. Consolidated
Reconciliation Report is generated in real time and will capture all
transactions that satisfy the following criteria: ·
Payment entered the system in
the last 21 calendar days ·
Payment was initiated by any
division (Service Group) ·
Payment can be in any status ·
Payment was created online at
ScotiaConnect - “Online Payments” ·
Payment was transmitted in a
file and stopped at ScotiaConnect for review and approval (Online Payment
Control) – “Batch Payments” ·
Payment was transmitted in a
file and was stored in the Integrated Payments Online History at
ScotiaConnect Important
note: Direct host-to-host transactions will not
be included in this report. This report contains three tabs, i.e.
each tab is a separate worksheet in the spreadsheet file. Online Payments and Batch Payments are displayed in
separate sections in each tab.
The “Payment Overview” tab contains the
status of each payment initiated in the last 21 calendar days. This period is
calculated on the basis of date of report generation. e. g. if report is
generated on 18 June 2013 then system will fetch all payments entered in
ScotiaConnect between 29 May 2013 and 18 June 2013. In
the Tab/Sheet 2 (Input to Settlement), the column “Status” displays a
group-wise sum of the payment amounts and the total number of payments for
each status, where the aggregate values are calculated/displayed at the
following levels: ·
Group by Originator ID, Input
FCN (File Creation Number), Fulfillment FCN and Payment Status ·
Group by Originator ID, Input
FCN, and Fulfillment FCN ·
Group by Originator ID and
Input FCN In
the Tab/Sheet 3 (Settlement to Input), the column “Status” displays a
group-wise sum of the payment amounts and the total number of payments for
each status, where the aggregate values are calculated/displayed at the
following levels: ·
Group by Fulfillment Agreement, Fulfillment FCN,
Payment Method, Input FCN and Payment Status ·
Group by Fulfillment Agreement,
Fulfillment FCN, Payment Method and Input FCN ·
Group by Fulfillment Agreement
and Fulfillment FCN |
Consolidated
Settlement Report
|
|
Consolidated
Settlement Report provides you with the ability to know the amount of funds
required in each settlement account in order to fulfill all payments that
will be settled on a specific day. Consolidated
Settlement Report is generated in real time and will capture all transactions
that satisfy the following criteria: ·
Payment was initiated by any
division (Service Group) ·
Payment has the settlement date
set for the current date (today) or any day in the future ·
Payment was created online at
ScotiaConnect - “Online Payments” ·
Payment was transmitted in a
file and stopped at ScotiaConnect for review and approval (Online Payment
Control) – “Batch Payments” ·
Payment was transmitted in a
file and was stored in the Integrated Payments Online History at
ScotiaConnect Important
note: Direct host-to-host transactions will not
be included in this report. This report contains two tabs, i.e.
each tab is a separate worksheet in the spreadsheet file. Online Payments and Batch Payments are displayed in
separate sections in each tab.
Tab/Sheet 1 (Payment Overview) lists
all transaction with a Settlement Date of current date (i.e. date of report
generation) or in the future. Tab/Sheet 2 (Settlement by Date)
displays the aggregate settlement amount for each Settlement Account and Settlement
Date. Data in this report is grouped in below order: ·
Payment Currency ·
Settlement Account ·
Fulfillment
Agreement ·
Fulfillment FCN
(File Creation Number) ·
Settlement Date ·
Status |
|
||||||
Related Topics
|
|||||||
Integrated
Payments: Payments Search
Administration:
Integrated Payments service privilege details