Daily sales and redemption report

A report which includes all Loads, Redemptions, Authorization, Fees that takes place on a voucher/card.

The report includes the following details:

• VoucherEngineRef - this is the vouchers table reference (integer).

• VoucherNumber - this is the actual card number (10 character string).

• ControlVoucherNumber - this is the main card number for a pocket campaign, where one plastic card is linked to multiple cards i.e. the pockets. Note: ControlVoucherNumber is only included in PocketCampaigns (16 character string).

• TrackingNumber - this is the public card number that we share with clients (15 character string).

• MerchantName - this is the name of the merchant (string).

• Date - this is the date of the transaction (YYYY/MM/DD HH:MM:SS).

• Type - this is the transaction type, which include (string):

  • Issued - a card allocated to a cardholder and loaded.
  • Redeemed - spend.
  • Cancelled - removing a load from a cardholders account.
  • Authorised - an authorisation, the first level of a transaction.

• Method - this is how the transaction was initiated or processed, which include (string):

  • Web
  • SMS
  • Batch
  • Terminal
  • Application
  • IVR
  • n/a

• Value - this is the amount of the transaction (decimal).

• Description - this describes the transaction (string).

• SequenceNumber - A sequence number is essentially another card identifier which tells you the actual sequence number of the card/voucher (string).

Report format

Report time frame

Report sample

CampaignName_DailySalesRedmeptionStatement YYYY-MM-DD.csv