Detailed settlement report

Paymentology also provides a detailed version of the Summary Settlement Report.The Detailed Settlement Report shows each settled transaction, which allows you to use the Transaction ID to mark off settled transactions from authorized transactions. This also assists in confirming the values of the amounts in the Summary Settlement Report. The network provides the Transaction ID field during authorization. The same Transaction ID for authorizations is included in the Detailed Settlement Report.

You can generate the Detailed Settlement Report by sending an HTTP GET request and download it as a CSV file.

The report includes the following details:

• Transactions date – this is the settlement date of the transaction.
• The amount in the issuing currency (cardholder currency) – the actual amount is a decimal number.
• The amount in the settlement currency – it’s the amount passed over by the network. It should be multiplied by 100 to include cents. If the settlement currency does not have decimals, you’ll take the value as-is.
• Transaction narrative – it’s the merchant’s description.
• Transaction description – this describes the transaction type, such as:
  • Deduct – shows all deductions at the time of settlement.
  • Load – shows loads/credits at the time of settlement.
  • Reversal – shows reversals at the time of settlement. In most cases these are reversals of an original deduct transaction.
  • Load reversal – shows loads that have been reversed at the time of settlement.
  • 2nd presentment – shows 2nd presentments at the time of settlement.
  • 2nd presentment reversal – shows a 2nd presentment that has been reversed at the time of settlement.
• Transaction ID – it’s a reference for the transaction.
  • In most cases, the provided Transaction ID will be the same Transaction ID as the original authorization. It’s usually 7 to 10 digits.
  • In case of refunds, there will be a unique Transaction ID for each of them. The ID does not relate to the original authorization. It’s also longer, up to 23 characters.
  • In case of chargebacks, there will be a unique Transaction ID for each of them. The ID does not relate to the original authorization. It’s also longer, up to 23 characters.
• Currency code – this is the currency code for the settlement currency.
• Transaction types – they can be marked as 00 (for POS transactions), 01 (for ATM transactions), or 02 (for adjustment transactions).
• Wallet reference – this is a unique customer reference for the card.
• System date – this is Paymentology’s system date in UTC +2 time zone.
• Sequence number – this is a unique sequence card identifier showing a running number for the cards created.
• Tracking number – this is a unique 15-digit tracking identifier for the card.
• Settlement currency – this is the currency code for the settlement currency.
• Interchange amount – this is the individual amounts earned per transaction.
• Network transaction ID – (Mastercard only) this is the Networks TraceID, it assists clients with matching pre-authorizations and incremental pre-authorizations to the settlements for those transactions.