Transaction reporting
Batches Transactions
When transactions are authorised they are sent to the acquiring bank for settlement. At this stage the transactions are referred to as settled transactions and are processed into batches which are created Monday through Friday.
For more information on specific batch times please contact Global Payments.
BATCH OVERVIEW
To view ‘Settled’ transactions, click on ‘Settled’ from the navigation menu on the left side of the screen.
Step 1
All settled transactions are grouped under a daily batch ID.
Step 2
To view further information on the batch of settled transactions click on the batch line. The Batch Overview screen will then be displayed.
Step 3
If you wish to generate a report based on the transactions within that batch, click on ‘Generate Report’.
Step 4
To view all transactions within the batch, click on ‘View Transactions’.
Once you have clicked on ‘View Transactions’, you will be brought to the screen below:
By selecting the plus sign on the left of the transaction, this will expand the transaction line allowing you to view more information on the transaction as below.
Alternatively you can also click on ‘Expand All’ which will display the extra details for all transactions in the batch.
You can click on each transaction line to view the individual transactions details for that transaction. The transaction details section gives you a view of the general information about the transaction as below
FRAUD
In the Fraud section of the transaction details screen, you can view the Fraud Score, Security Code and 3D secure information. You can also view the AVS Address and AVS Postcode results returned for the transaction.
Explanation of details within the Fraud Section of Transaction Details
|
Title |
Description |
|---|---|
|
UCAF (AAV/CAVV) |
This is the Cardholder Authentication Verification Value created during cardholder authentication. |
|
XID |
This is a Global Payments generated transaction reference that the merchant sends to the Access Control Server in advance of the cardholder authentication. |
|
ACS URL |
This is the address of the Access Control Server, the card issuing banks website. |
|
ECI |
This is the E-Commerce Indicator. For more information on this field, please see the below table. |
|
Visa |
Mastercard / Switch (UK DMK) |
Ecommerce Indicator (ECI) |
|---|---|---|
|
5 |
2 |
Full 3D Secure – cardholder Enrolled |
|
6 |
1 |
Merchant 3D Secure – cardholder not enrolled or attempt to contact ACS server was used |
|
7 |
0 |
Non 3D Secure transaction. E.g. a refund or a 3D Secure transaction which failed midway. It is up to the merchant to decide whether or not to proceed with a non-3D Secure transaction. The liability shift no longer applies. |
For more information on 3d Secure implementation and management please see the RealMPI Developers Guide.
DCC (Dynamic Currency Conversion)
In the DCC section of the transaction details screen, you can view the Dynamic Currency Conversion (DCC) result of the transaction.
Explanation of details within the DCC Section of Transaction Details
|
Visa |
Ecommerce Indicator (ECI) |
|---|---|
|
Authorisation Amount |
The amount of the transaction processed. |
|
Authorisation CCP Rate |
The currency conversion rate being offered by the Currency Conversion Processor for this transaction. |
|
Currency Processor |
The processor of the DCC transaction e.g. Fexco/Elavon. For more information on your currency processor please contact the Global Payments Support Team. |
For more information on DCC implementation please see the RealFX Developer Guide.
HISTORY
In the history section of the transaction details screen, you can view the details of the authorisation and all subsequent actions that have been carried out against the order. These may include settle, rebate and void details.
Explanation of Fields on Transaction Details screen
|
Field |
Description |
|---|---|
|
Timestamp |
The date and time the transaction was processed. |
|
Cardholder Name |
The Cardholder name. |
|
Order ID |
This is the unique identifier for the transaction. |
|
Account |
The sub-account that the transaction was processed under. |
|
Transaction Amount |
The value of the transaction. |
|
Customer Number |
This displays information sent in the Customer Number field of the authorisation. |
|
Product ID |
This displays information sent in the Product ID field of the authorisation. |
|
Variable Reference |
This displays information from the Variable Reference field. |
|
Status |
This shows the current stage of the transaction process. |
|
Result |
The result of the transaction which is passed back by the card holders issuing bank. |
|
Message |
This is the result message which is passed back by the card holders issuing bank. |
|
Batch ID |
This shows the Batch ID of the batch that the transaction is associated with. If a transaction is declined and therefore not batched, this will display "-1". In this instance the Batch ID will be available in the ‘Settled’ section of the application. |
|
Pas Ref |
This is an internal Global Payments reference, unique to each transaction. |
|
Transaction ID |
This is an internal Global Payments reference, unique to each transaction. |
|
Card Number |
This shows the card type and the card number masked with X's for security reasons. The first 6 digits and last 4 digits will be the only characters visible. |
|
Card Issuer |
This displays the name of the bank that issued the card, if that information is available. |
|
Card Issuer Country |
The country the card was issued in. |
|
Originating I.P. |
This shows the IP address that the transaction was processed through. |
|
Customer I.P. |
This shows the IP address of the customer. |
|
Fraud Score (TSS) |
This is the score that the transaction received by the fraud scoring tool. |
|
Security Code |
This shows the result of the Security Code check. Please see the Appendix for the possible security code results. |
|
AVS Address |
This shows the result of the Address Verification Service (AVS) check on the information supplied by the customer in the billing address field. |
|
AVS Postcode |
This shows the result of the Address Verification Service (AVS) on the postcode supplied by the customer. |
Viewing Related Transactions
In the ‘Payment Method’ section of the transaction details screen you can view related transactions by clicking on:
- Number
- Cardholder Name
These values will be underlined as below. For example if you click on the card number this will display all transactions processed on this card.
View and Print Receipt
To print a receipt, click on the ‘Print Receipt’ button which will appear on the top right of your transaction details screen. This will open up a new tab in your browser, containing the receipt. Then use the onscreen options to save or print the receipt as necessary.
Download Reports to Excel
In order to generate reports of all transactions, click on ‘Generate Report’. For example, within the ‘Settled’ section, the ‘Generate Report’ button is located within the batch overview screen below.
This will produce a report of all transactions within that batch. This functionality can be used throughout multiple sections of the RealControl system wherever the ‘Generate Report’ button is located.
Click on ‘Generate Report’, this will schedule the batch report in the ‘Reports’ section of the application.
To view reports click on the ‘Reports’ section of the main navigation menu. Click the ‘Download’ icon to the right of the report line to open or save the file.
If you choose to save the file, you can save it as a .csv file on your local machine.
