Skip to main content

Verifone Central

Transactions Reports

Last updated: 17-Jun-2022
Rate this article:

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:

  1. Log in to your Verifone Central account.
  2. Navigate to Reports and select Transactions.

transaction_reports_1

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

Transaction Filtering

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

Verifone Central Transaction Filtering by 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

Filtering by Identifier

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.

receipt

  • 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

Tranactions Details

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: CaptureVoid 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.E-mail Copies of receipts

Exporting reports

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
Email 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:

  • index-linked
  • dollar-linked
- 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

 

Rate this article:
Logo of Verifone