Transactions Reports
Overview
The transaction is the payment action initiated by the shopper or the merchant. The action is finalized with the confirmation of the checkout phase. Unlike settlements, finalizing the transaction does not imply automatically that the funds have been successfully transferred.
The Dashboard Transactions Reports page in Verifone Central allows you to view and export comprehensive reports on transactions that you can filter according to Organisation, Merchant ID, Currency, Product or Payment Method (wallet) used for the transaction. The same Transactions report can be generated by choosing Transactions in the drop-down list of the Reports menu section.
Transactions Reports
To view and export transaction reports from Dashboard, follow these steps:
- Log in to your Verifone Central account.
- Navigate to Reports and select Transactions.
Your transaction report includes all transactions from all your Payment Channels, including refunds and pre-authorizations.
In addition to filtering your transactions by the organisation and Merchant ID, you can also apply the following filters to your transactions:
- Transaction or settlement date
- Transaction details
- Transaction identifiers
Transactions
Filter by transaction or settlement date
Click Created date or Settled date to filter transactions based on a date range.
- If ‘Created date’ is selected, the filter will include transactions initiated during the selected date range
- If ‘Settled date’ is selected, the filter will include transactions settled during the selected date range
Filter by transaction details
Select + Add Filter to filter transactions based on the following transaction details:
- Channel: Where the sale originated, e.g., from terminal or online (Note: For New Zealand, the ‘POS’ means the transaction was processed on an EFTPOS terminal in-store)
- Currency: Currency in which the transaction was tendered, e.g., New Zealand Dollar (NZD)
- Product: The card type used by the cardholder
- Transaction type: The type of transaction, e.g., sale or refund
- Transaction status: The status of the transaction, e.g., approved or declined
- Wallet: You can view and export reports that display your transactions based on the wallet used (Google Pay, Apple Pay, MobilePay, Vipps, etc.)
- Stored Credential Type: Stored data used to authorize payment in recurring transactions. There are two types:
- Sign up- for the initial payment
- Charge- for recurring payments
- Processor: The acquirer bank or institution that processed the payment.
- Account Type: The type of account used in the transaction, whether it is a Debit or a Credit account.
Filter by transaction identifiers
You can search for transactions based on transaction identifiers (see below). Select a transaction identifier from the dropdown menu, enter the correct value for the transaction(s) you are searching for into the search bar and then click Search.
You can find some of these identifiers on your terminal receipts.
Note: Applicable for NZ only.
- Terminal ID: You can find this on all of your receipts. It is the last four digits of the ‘TSP’ number
- STAN (System Trace Audit Number): The 6-digit number incremented for each transaction the terminal sends
- Note: New Zealand users can find this on their EFTPOS receipt as the ‘Tran’ number. Example: 000287.
- RRN (Reference Retrieval Number): Only available on some merchant EFTPOS receipts. Made up of the date the transaction was processed and the transaction STAN number (System Trace Audit Number). Example: 200807030680.
- Batch Number: This is the settlement date of the transaction in the format YYDDMM
- Reference: For transactions processed on an EFTPOS terminal in-store, this is the RRN
- Settlement ID: Not applicable for New Zealand
- Transaction ID: For New Zealand transactions processed on an EFTPOS terminal in-store, this is the RRN
Transaction detail
Click a particular transaction to see additional details about the transaction:
- Organization: The organization associated with this transaction
- Reference: The transaction reference number. For New Zealand in-store EFTPOS terminals, this is the RRN
- Channel: Where the sale originated, i.e., on a terminal or online. If the channel is given as ‘POS’, this means the transaction was processed on a terminal in-store.
Click on the tabs to see more information about the transaction:
- History: Past transactions with their log information: date, time, amount, currency, user
- Actions: Operations that can be performed on each transaction such as: Capture, Void and Refund. The actions available depend on the type and status of the transaction.
- Details: More detailed information on the transactions including organization, settlement status and 3DS details. See the Report column section below for more information.
- Customer: General customer information such as name, billing and shipping address.
- Documents (Available in limited regions): The tab enables the option to resend either the Merchant or Cardholder Copy of the transaction receipt. After clicking the appropriate button, you will need to enter an email address.
- (Available in Israel)
- You are also able to see the Invoice4U identifier of the receipts below the Merchant and Cardholder Copies
- You have the option of e-mailing the Merchant and Cardholder Copies
- (Available in France) Merchants using Carte Bancaire services also have the option of e-mailing copies of the Merchant and Cardholder receipts
- (Available in New Zeeland) Merchants using Australia and New Zealand Bank and MPGS acquirers also have the option of e-mailing copies of the Merchant and Cardholder receipts.
- (Available in Israel)
Exporting reports
Once you’ve applied filters to display the transactions you want to export, click Export CSV to generate a transaction report for download.
1. Select the report type:
- ‘Basic report’ will contain the same columns as the transaction table in the Portal
- ‘Full report’ will export all transaction detail fields
2. Click Download CSV
- See the report columns section for definitions of all transaction detail fields
Report columns
Below are definitions for all of the transaction detail fields included in the full reports. Each field is listed also with their availability as filters and search criteria.
Field Name | Definition (region specific) | Mandatory |
List (= basic CSV) |
Search | Filters |
CSV full report |
Details |
---|---|---|---|---|---|---|---|
Created | Date of transaction | Yes | Yes | No | Yes | Yes | Yes |
Reference | Unique ID of the transaction | Yes | Yes | Yes | No | Yes | Yes |
Organisation | Organisation name | Yes | Yes | No | No | Yes | Yes |
Organisation ID | Organisation ID | Yes | No | No | Yes | No | Yes |
Merchant ID | Identifier assigned to the Merchant and known by the Merchant or Client, whether this is an external Client, Client System or Gateway i.e this field is for the MID used internally by VF | Yes | Yes | Yes | Yes | Yes | Yes |
Product | Payment method used to place the order | Yes | Yes | No | Yes | Yes | Yes |
Orig. Amount | Initial amount of the transaction | Yes | Yes | No | No | Yes | No |
Current Amount | Current amount of the transaction (after some actions) | Yes | Yes | No | No | Yes | Yes |
Status | Status of the transaction | Yes | Yes | No | Yes | Yes | Yes |
Type | Type of the transaction | Yes | Yes | No | Yes | No | Yes |
Transaction ID | ID of the transaction | Yes | No | Yes | No | Yes | Yes |
Batch number | Batch or settlement date as assigned by the Payment Acceptor (in most cases Verifone) for the POI or merchant. This is not the same as the batch that can be assigned by the acquirer. | Yes | No | Yes | No | Yes | Yes |
Settlement Batch ID | Batch ID assigned to a settlement batch | Yes | No | Yes | No | Yes | Yes |
Bin Number |
The Bank Identification Number contains the first 6-8 digits of the Primary Account Number (PAN). The BIN (or a BIN range) is assigned to a card issuer. |
Yes | No | Yes | No | Yes | No |
Card number | Primary Account Number or Card Number. Displayed in an encrypted format | Yes | No | Yes | No | Yes | Yes |
Expires (card) | Expiry date of the card | Yes | No | No | No | No |
Yes |
Merchant reference |
Merchant reference is a value (up to 50 characters) that is assigned by the merchant in each transaction for their own identification. |
Yes | No | Yes | No | Yes | Yes |
Processor STAN | Number that is assigned by a counter in the gateway (or the terminal) to identify the uniqueness against processor. | Yes | No
|
Yes | No | Yes | Yes |
Provider reference | Type indicator for the contract that is being processed | Yes | No | No | No | No | Yes |
Provider Transaction IDA | Transaction ID generated by the provider | Yes | No | Yes | No | No | Yes |
RRN | Retrieval Reference Number may be used as reference against Acquirers | Yes | No | Yes | No | Yes | Yes |
STAN |
Verification method for API calls. Verification is done through a number that is assigned by a counter in the gateway (or the terminal) to identify the uniqueness against Acquirers. |
Yes | No | Yes | No | Yes | Yes |
Subscription ID | Identifier of the subscription or agreement in the payment provider's system | Yes | No | Yes | No | No | No |
Terminal ID |
Identifier assigned to POI and known by the Merchant or Client, whether this is an external Client, Client System or Gateway -- an ID assigned to each POS. For ecommerce it is assigned by the gateway. It distinguishes the requestor. |
Yes | No | Yes | No | Yes | Yes |
Channel | Sales channel of the transaction (ecom, mail, POS) | Yes | No | No | Yes | No |
Yes |
Currency | Currency of the transaction | Yes | No | No | Yes | Yes | No |
Wallet | Wallet that was used to initiate the transaction (eg. Google Pay, Apple Pay, Vipps, MobilePay etc) | Yes | No
|
No | Yes | No | Yes |
Stored Credential type |
A signup or enrolment request for the stored credentials A subsequent charge request for the stored credentials, related to a previous signup |
Yes | No | No | Yes | No | No |
Transaction logs (type, state, amount, currency, date&time, user) | The previous states of the transactions, users and their actions performed on that particular transaction | - | No | No | No | No | Yes |
Actions | The available actions per transaction | - | No | No | No | No | Yes |
Authorisation code | Value assigned by the Acquirer for specific authorized transactions | - | No | No | No | No | Yes |
Response | Response received from the acquirer | - | No | No | No | Yes | Yes |
Response description | Description of the response received from the acquirer | - | No | No | No | Yes | Yes |
Response code | Code of the response received from the acquire | - | No | No | No | Yes | Yes |
Acquirer response code | Acquired Response Code | - | No | No | No | Yes | Yes |
ARN | Acquirer Reference Number is the "transaction ID " set by the Acquirer. It is usually used when communicating to banks and schemes. | - | No | No | No | Yes | Yes |
Technology | Entry mode (breakdown of cards like mag stripe, chip insert or contactless) | - | No | No | No | Yes | Yes |
Authentication mode | Authentication method | - | No | No | No | No | Yes |
Cardholder choice | Brand choice | - | No | No | No | No | Yes |
Site Reference | An identifier for the Site that is unique to the Merchant Organisation. This will be used to locate this instance of a Site. | - | No | No | No | Yes | Yes |
Transaction fee | Fees applicable for the transaction | - | No | No | No | Yes | Yes |
Settlement amount | Amount settled | - | No | No | No | No | |
Batch created | Date of the Batch creation | - | No | No | No | No | Yes |
Settlement date | Date of the settlement | - | No | No | No | Yes | Yes |
Acquirer | Type indicator to identify the acquirer of the payment | - | No | No | No | Yes | Yes |
Processor | Type indicator to identify the processor of the payment | - | No | No | No | Yes | Yes |
XID |
Transaction ID assigned for 3DS1.0.2 transactions |
- | No | No
|
No | No | Yes |
Authentication value |
Unique value assigned by the Issuer to distinguish the 3ds transaction. Is it similar to the Authorisation code, but for 3DS |
- | No | No | No | No | Yes |
Status(3DS) | Status of the 3DS check (e.g., successful, failed, etc.) | - | No | No | No | No | Yes |
Enrolled | Card enrolled for 3DS | - | No | No | No | No | Yes |
Scheme transaction ID | Transaction ID assigned by the schemes for 3DS1.0.2 transactions | - | No | No | No | No |
Yes |
Version | Version of 3DS | - | No | No | No | No |
Yes |
Challenge indicator | Did the issuer request challenge the cardholder? | - | No | No | No | No | Yes |
Customer ID | Identifier as a string for the Customer. This is for the Verifone defined customer ID e.g from the customer service. | - | No | No | No | No |
Yes |
Name | Shopper full name | - | No | No | No | Yes | Yes |
Title | Shopper title | - | No | No | No | No | Yes |
Gender | Shopper gender | - | No | No | No | No | Yes |
Shopper email | - | No | No | No | Yes | Yes | |
Shipping address | Shopper shipping address | - | No | No | No | Yes | Yes |
IP address | IP Address v4 where the event originated. | - | No | No | No | No | Yes |
Documents | Available documents - receipts | - | No | No | No | No | Yes |
Instalment payment index |
Field is applicable for Israel only. Possible values are:
|
- | No | No | No | Yes | No |
Cross border fee |
Cross border fee., a fee taken for processing cross boarder (when a payment card of a cardholder and a merchant are located in different countries) transactions. | - | No | No | No | Yes | Yes |
Card token | Identifier associated with the payment card that allow to search data related to that payment card in a safe way | - | No | Yes | No | No | Yes |