Unsettled transactions report

This report provides client’s with a full list of unsettled transactions, it assists with overall reconciliation.

There are two versions of this report available:

Version 1.0

Version 2.0

Version 1

This report includes the following details:

• CampaignName – Name of client’s campaign
• TransactionDate – This is the authorization date of the transaction
• TransactionAmount – the value of the transaction
• TransactionNarrative – it’s the merchant’s description
• TransactionDecription – this describes the transaction type, such as:
  • DEDUCT – deductions or debits
  • LOAD – refunds or credits
  • CHARGEBACK
• TransactionID – it’s a reference for the transaction
• TransactionType – it can be marked as any of the following:
  • 0 – POS Transaction
  • 1 – ATM Transaction
  • 2 – Adjustment
• WalletReference – this is a unique customer reference for the card (applicable to Companion API). This column will be empty for Card API reporting.
• SystemDate – this is Paymentology’s system date in UTC +2 time zone.
• SequenceNumber – this is a unique sequence card identifier showing a running number for the cards created.
• TrackingNumber – this is a unique 15-digit tracking identifier for the card.

Version 2

This report includes the following details:

• CampaignName – Name of client’s campaign
• TransactionDate – This is the authorization date of the transaction
• TransactionAmount – the value of the transaction
• TransactionNarrative – it’s the merchant’s description
• TransactionDecription – this describes the transaction type, such as:
  • DEDUCT – deductions or debits
  • LOAD – refunds or credits
  • CHARGEBACK
• TransactionID – it’s a reference for the transaction
• TransactionType – it can be marked as any of the following:
  • 0 – POS Transaction
  • 1 – ATM Transaction
  • 2 – Adjustment
• WalletReference – this is a unique customer reference for the card (applicable to Companion API). This column will be empty for Card API reporting.
• SystemDate – this is Paymentology’s system date in UTC +2 time zone.
• SequenceNumber – this is a unique sequence card identifier showing a running number for the cards created.
• TrackingNumber – this is a unique 15-digit tracking identifier for the card.
• NetworkTransactionID – the Transaction ID of the transaction, as created by the card network. You can match this against the Transaction ID on the Mark-off file

Report format

Report time frame

Report sample

CampaignName_UnsettledTransactionReport_YYYYMMDD.csv

CampaignName_UnsettledTransactionReport_YYYYMMDD.csv V2 sample