Ingenico Direct Support Site

Results for

icon-search-large No search results yet
Enter your search query above

1. Introduction

When doing online business, it is important to keep track of your transactions. We offer various solutions for you to do so. The quickest and easiest way to check is via your Back Office. Have a look at the video to learn how it works:

But there is a lot more to it! In this guide, we show you how to:

  • Look up individual or batches of transactions
  • Get detailed information about transactions
  • Download comprehensive reports
  • Look up transactions and perform captures/refunds etc in one go

Have a look how you can get all the information you need easily.

2. Understand view transactions and Financial history

Our platform assigns a unique identifier to all transactions (also known as PAYID). You can receive this PAYID i.e. via our webhooks feature or a Get Hosted Checkout status request in property payment.id.  The property consists of two strings, separated by an underscore "_"

paymentid_operationid

Each string indicates a different dimensions to reflect the transaction's current status

  • paymentid: the global transaction status - the current status of the order for which you created the transaction for 
  • operationid: the amount of maintenance operations (i.e. authorisation/capture/refund) performed so far on this paymentid in the transaction life cycle

Hence, our platform allows you to search for your transaction in the Back Office in two distinctive ways:

  • By global transaction status (Operations > View transactions)
  • Individual maintenance operations (Operations > Financial history)
Find detailed information about the differences between global transaction status and individual maintenance operations in a dedicated chapter in our webhooks guide. 

Depending on what you are looking for, one way is the more suitable. The following table helps you decide:

View transactions Financial history
Definition
Provides a list of transactions with their current global status (the paymentid, a unique ten-digit number). The latest final maintenance operation (i.e. authorisation/ capture/refund) you have performed defines the current global status

Provides a list of individual maintenance operations (i.e. authorisations/captures/refunds) you have performed on your transactions (the operationid, a paymentid with a sub step “x” (paymentid/x) indicating its order in the transaction life cycle).

Each maintenance operation has an individual status, i.e.

3106631483/0: authorisation (statusOutput.statusCode=5)
3106631483/1: capture (statusOutput.statusCode=9)
3106631483/2: refund (statusOutput.statusCode=8)

Useful for
  • Looking up a specific transaction and its status in the transaction life cycle
  • Getting an overview on the latest status of your orders
  • Looking up specific maintenance operations performed on a certain date
  • Getting an overview on all the authorisations/captures/refunds on a certain date/in a timeframe
Possible actions
Perform maintenance operations in the Back Office directly: Capture authorisations, refund payments etc. Reconciliate your gross amounts with your accounting (Use our Reconciliation tool to match net amounts)

3. Look up transactions

Log in to the Back Office and go to either Operations > Financial history or Operations > View transactions. Either screen shows a search mask. Clicking on “ADVANCED SELECTION CRITERIA” adds more search criteria. Have a look at the tables what search criteria are available:

The search masks for both View transactions and Financial history are nearly identical. The following tables explaining the search criteria point out the differences.

Use basic search mask


The basic search mask is immediately visible when accessing Financial history/View transactions. It contains the most basic search criteria:

Search criterium Explanation
Order date / Payment date
  • Order date (available for View transactions): The date you sent the transaction to our platform before it reached any final status
  • Payment date (available for Financial history): The date the transaction reached either statusOutput.statusCode=9 / statusOutput.statusCode=8
You can look up transactions of a period of maximum 30 days per query
Charging method / Card type The payment method the transactions were processed with. The content of the drop down menu is identical to your active payment methods in Configuration > Payment methods
Merch ref Your identifier for the order (The value you sent in property order.references.merchantReference)
Pay ID Our platform’s unique identifier of the transaction (the payment.id). Using this criteria produces a single transaction matching this Pay ID
Status
  • View transactions: The global status of a transaction
  • Financial history: The status of individual maintenance operations of a transaction
Read more to learn about the differences between global status and maintenance operation status

Use advanced selection criteria

You might want to narrow down your search in certain situations. Clicking on “ADVANCED SELECTION CRITERIA” offers you many more criteria to do so:

Search criterium Explanation
Order date/Payment date
  • Order date (available for Financial history): The date you sent the transaction to our platform before it reached any final status
  • Payment date (available for View transactions): The date the transaction reached either statusOutput.statusCode=9 / statusOutput.statusCode=8
You can look up transactions of a period of maximum 30 days per query
Amount Value you sent in property Order.amountOfMoney.amount
Scoring Numerical fraud score for transaction processed with our Fraud Expert Scoring
Global Fraud Score Fraud category (green / orange / red) based on the Global Fraud Score calculated by our Fraud Expert Scoring
Company name Value you sent in property Order.customer.companyInformation.name
Card number

Unmasked card number used for this transaction

This search field accepts only full credit card numbers. Please be aware that storing card numbers in your system requires a specific PCI DSS standard.

IP address

IP address the transaction originated from

Name

Name of the card holder

E-mail

Value you sent in property order.shipping.emailAddress

Encoded by

User who created the transaction

Alias 

Card profile safely stored on our platform

Once you have selected your search criteria, click on SUBMIT to get the results. You can also download the result or receive daily reports automatically.

We archive transactions after 540 days of their creation (around 18 months). After that period, you cannot look up the transactions anymore.

4. Use 'View transactions' query

Once you click “SUBMIT”, you get an overview page with all matches of your query. Have a look at the different columns and their meaning:

Column Description
Pay ID Our platform’s unique identifier of the transaction (property payment.id)
REN/SAS/RFS Depending on the current global status, you can put flags to perform maintenance operations for many transactions in one go. Learn how to do it in our dedicated guide.
Merch ref Your identifier for the order (The value you sent in property order.references.merchantReference)
Orders Date you sent the transaction to our platform before it reached any final status
Status Current global status of the transaction
Authorisation Authorisation/Refund code from your acquirer. Applies only for statusOutput.statusCode=5/8/9 transactions
Payments Date the transaction reached either statusOutput.statusCode=9 / statusOutput.statusCode=8
Total Value you sent in property Order.amountOfMoney.amount
Rating Fraud rating
Name Cardholder name
Method Payment method used

The image shows a typical result of a "View transaction" query

The last line of column “Total” sums up the value of property Order.amountOfMoney.amount of all transactions in all currencies from this list, regardless of the transaction status. Hence, the total sum also includes unsuccessful transactions (statusOutput.statusCode=0/1/ 2 etc.), authorisations (statusOutput.statusCode=5) and refunds/cancellations (statusOutput.statusCode=6/7/8/85 etc.).

Clicking on a Pay ID provides you an extensive overview on the transaction. It includes all maintenance operations and detailed data provided in your request and by your acquirer in the response. Read the dedicated chapter to learn more.

5. Use 'Financial history' query

Once you click “SUBMIT”, you get an overview page with all matches of your query. Maintenance operations (authorisations/captures/refunds etc.) sharing the same

  • Payment method
  • Date (the date the transaction reached its current status as mentioned in the line)
  • Status
  • Currency

are put in individual lines. Have a look at the different columns and their meaning and some of the lines in this example to learn how to read them:

Column Description
Method Payment method used
Date Date the transaction reached its current status as mentioned in the line
Status Current status of the maintenance operation
Tr. no. Amount of transactions sharing the same payment method/date/status/currency
BR

Batch Reference of the file our platform added the maintenance operation to.

All maintenance operations from one batch are processed in one go.

Depending on the status, your acquirer has not finished processing the file (any x1 statusOutput.statusCode, i.e. 91) yet

Details Clicking on the button provides you with the full list of all maintenance operations (operationid) belonging to this line
Download Clicking on the button provides you with a file containing the all maintenance operations (operationid) belonging to this line
Line Description
1 All authorisations (three in total) performed for Visa transactions on 05.03.2021 in EUR
2 All captures (one in total) performed for Visa transactions on 08.03.2021 in EUR
3 All refunds (one in total) performed for Visa transactions on 10.03.2021 in CHF

The image shows a typical result of a “Financial history” query with some examples pointed out

Once you look up operationids via “Details”, you receive an extensive overview on the maintenance operation. It includes detailed data provided in your request and/or by the acquirer in the response. Read the next chapter to learn more.

6. Understand detailed transaction information

If you access a transaction via “View Transactions” via the button in column “Pay Id”, you get a detailed overview on the transaction. It includes detailed data provided in your request and/or by the acquirer in the response.

General transaction overview

The image shows a typical transaction overview screen from the Back Office

Have a look at the available data and what it means:

Item Description
Pay ID Our platform’s unique identifier of the transaction
Status The global status of a transaction
Total charge Value you sent in property Order.amountOfMoney.amount
Payment methods The payment method the transaction was processed with
NC ID Our platform’s unique identifier of the initial maintenance operation for this transaction
email Value you sent in property order.shipping.emailAddress
Company name Value you sent in property Order.customer.companyInformation.name
encoded by User who created the transaction
Merch ref Value you sent in property order.references.merchantReference
Order date Date you sent the transaction to our platform before it reached any final status
Description Value you sent in property order.references.descriptor
Card/Account number

Masked card number used
Cardholder's name Name of the card holder
Authorisation date Date the transaction reached statusOutput.statusCode=5
Payment date Date the transaction reached statusOutput.statusCode=8/9
NC ST/ER Error code
Set to 0/0 for any successful transaction status
Invoicing customer Value you sent in properties
order.customer.personalInformation.name.firstName
order.customer.personalInformation.name.surname
order.customer.personalInformation.name.title

Shopping cart extension ID If you use a shopping cart, this field may contain an identifier of the shopping cart used
Purge date Date when our platform deletes the transaction according to GDPR regulations
3-D Secure authentication result Result of your customers’ 3-D Secure authentication attempt
Card verification code Indicates with OK/NOK whether the acquirer could verify the CVC
Card country Country the card was issued in based on the BIN (first six digits of the card)
IP address country IP country of the device used for the purchase
Received IP address Full IP address of the device used for the purchase

You can find all maintenance operations performed on this transaction on the lower part of the screen. For each maintenance operations, the overview bundles the most important information from the general overview in a table:

The image shows a typical overview of all maintenance operations performed on a transaction

Item Description
Pay ID Our platform’s unique identifier (operationid) for this maintenance operation
Merch ref Value you sent in property order.references.merchantReference
Status Status of the maintenance operation
Authorisation Authorisation code from your acquirer. Applies only for statusOutput.statusCode=5/8/9 transactions
Payment date Date the maintenance operation reached its status
Total (Partial) amount processed for this operation
NCID Our platform’s unique identifier for this maintenance operation
Error Error code
Set to 0 for any successful maintenance operation 
 
Charg Meth Payment method used for the transaction
Card/ACC no Card number used for this maintenance operation

Each maintenance operation has its own PAYIDSUB, added as an eleventh cipher separated by a slash:

The image highlights the different PAYIDSUBs from a transaction

If you click on a PAYIDSUB, you get a detailed overview on the data that is specific for the respective maintenance operation.

operationid overview

The information provided is similar to the one provided in the general transaction overview, but lists fields specifically relevant for this maintenance operation:

The image shows a typical operationid overview screen from the Back Office

Item

Description

Pay ID

Our platform’s unique identifier (operationid) for this maintenance operation

Status

Status of the maintenance operation 

Total charge

(Partial) amount processed for this operation

Payment methods

Payment method used for the transaction

Authorization code

Authorisation code from your acquirer. Applies only statusOutput.statusCode=5 maintenance operations

NCMODE

Channel used for performing this maintenance operation. Possible values:

·  WEB: Via the Back Office

·  DIR: Via our API (i.e. CreatePayment, RefundPayment)

Transaction date

Date the maintenance operation reached its status

UID

Your Unique Identifier in your acquirer’s system. Our platform uses this (alpha-)numeric code to route your transactions/maintenance operations from our platform to your acquirer. You can look up every UID for any of your payment methods in the Back Office via Configuration > Payment methods > Contract data   

Invoicing customer

Value you sent in properties
order.customer.personalInformation.name.firstName
order.customer.personalInformation.name.surname
order.customer.personalInformation.name.title

Merch ref

Your identifier for the order (The value you sent in property order.references.merchantReference)

Order date

Date you sent the maintenance operation to our platform before it reached any final status

Description

Value you sent in property order.references.descriptor

Card/Account number

Masked card number used

Cardholder’s name

Name of the card holder

NC ID

Our platform’s unique identifier for this maintenance operation

TID

Your virtual Terminal ID linked to your PSPID. Used together with your UID to route your transactions/maintenance operations from our platform to your acquirer.

Encoded by

User who performed the maintenance operation 

6. Use additional possibilities

The search query tool offers more than just looking up transactions. Once you have found the transactions you are looking for, you can perform different actions directly in the Back Office. Have a look at what all is possible:

Download transaction reports manually

Instead of displaying the transactions in the Back Office, you can download them as a list. Depending on whether you want to look up transactions or individual maintenance operations, go to either Operations > View transactions or Operations > Financial history.

Fill in the search mask and click on “DOWNLOAD LIST” which will appear in your local download folder. You can modify the file format, select available columns and many more things by clicking on “File format >>>”. Read our dedicated guide to learn about what you can manage.

Receive transaction reports automatically

You can even leave the steps described above to our platform and receive transaction reports automatically. Click on “DAILY” which allows you to define the addressee, the delivery format and the frequency. Read our dedicated guide to learn more about these reports.

The image shows where to find buttons “DOWNLOAD LIST” / “SEND DAILY” and the “File format” link in Operations > View transactions / > Financial history

Perform (multiple) maintenance operations

Check out our dedicated chapter in our Modify your transactions guide to learn how to renew/capture authorisations or refund transactions.