Payments export

📘
Export limit
You can only export a maximum of 100k transactions at one time. If the number of transactions listed in the payment dashboard is more than 100k, continue to refine the search filters until it returns a number of transactions below the maximum limit before you hit the Export button.

To export your payments, go via the Payments search page

Above the payment listing data table, you will see Export button and can easily export your payments by selecting the Export button.

Export canvas will be loaded on right side of the screen

Select Export view and you will see Select export output modal. This will allow you to select or deselect or re-order fields for Export CSV

Select Export to start export CSV processing. The status change journey will look like Starting > Processing > Completed or Failed

If you want to cancel the export operation, select Cancel to stop the processing
Download .csv button will appear after successful export completion. Select Download .csv , you will see a toast message on the top for download completion or failure. Select the link to download your export CSV.

The following fields will be available in the Select export output modal for your selection.

Field #	Field Name	Field Description
01	Transaction date	The date of the payment in UTC.
02	Status	The payment status e.g. `Authorised`, `Captured`, `Refunded`, `Voided`, etc.
03	Channel	Payment channel. The values can either be `Online` or `In-store`.
04	Card input method	Identifies the method used to provide card information. e.g. `Swipe`, `Contactless`, `Insert` for in-store and `ecommerce`, `card_on_file` for online.
05	Local transaction timestamp	The local date and time of the payment.
06	Transaction ID	Unique payment identifier.
07	Merchant reference ID	Unique merchant-generated order reference or tracking number for each transaction.
08	Transaction type	The payment type. Possible values are `CP` for in-store or `CNP` for ecommerce.
09	Primary tender bin	The card issuer Bank Identification Number (BIN). A Bank Identification Number (BIN) is the first six to eight digits of the Primary Account Number (PAN) that identifies the financial institution that issued the card.
10	Primary tender label	The last 4 digits of Payment Account Number (PAN) or Device Payment Account Number (DPAN) for card payments. For non-card payments, this field is used as the identifier for the buyer account e.g. PayPal buyer's email address.
11	Primary tender payment method	The payment method of primary tender. e.g. `CardDebit`, `CardCredit`, `Paypal`, etc.
12	Primary tender scheme	The card scheme.
13	Primary tender amount	The primary tender transaction amount.
14	Primary tender refunded amount	The primary tender refunded amount.
15	Primary tender status	The payment status e.g. `Authorised`, `Captured`, `Refunded`, `Voided`, etc.
16	GC# ID	Unique giftcard payment identifier.
17	GC# bin	Gift card issuer Bank Identification Number (BIN)
18	GC# amount	Gift card transaction amount.
19	GC# refunded amount	Gift card refunded amount.
20	GC# status	Gift card payment status e.g. `Authorised`, `Captured`, `Refunded`, `Voided`, etc.
21	GC# sub-status	Gift card payment sub-status provides more details into why it was declined.
22	GC# error code	The error code for gift card. When a payment has been declined or failed this field would provide additional details.
23	GC# raw error code	The raw error code for gift card. When a payment has been declined or failed this field would provide additional details.
24	GC# error message	The error message for gift card. When a payment has been declined or failed this field would provide additional details.
25	Item# name	The name of the cart item.
26	Item# quantity	The quantity of item in the cart.
27	Item# amount	Amount of the cart item.
28	Item# discount	The amount discounted for this item.
29	Item# tax amount	The tax amount for this item.
30	Item# categories	A list of strings containing product categories for the item.
31	Payment method	The payment method. e.g. `CardDebit`, `CardCredit`, `Paypal`, etc.
32	Expiration	The payment method expiration date.
33	Currency	The payment currency.
34	In-store Country	The country associated with the in-store payment method used for payment e.g. the country of issuance of the scheme card.
35	Issuer institution name	The name of the financial institution that issued the credit or debit card.
36	Issuer institution ID	The ID of the financial institution that issued the credit or debit card.
37	Card acceptor id	The ID of the store/location where payment originated from.
38	Online Country	The country associated with the online payment method used for payment e.g. the country of issuance of the scheme card.
39	Total transaction amount	Total transaction amount.
40	Purchase amount	The purchase amount and currency. This is applicable for in-store where the total purchase amount may be different to the total transaction amount due to cashout, tip, and surcharge amounts.
41	Cashout amount	The cashout amount and currency.
42	Tip amount	The tip amount and currency.
43	Surcharge amount	The surcharge amount and currency.
44	Captured amount	The captured amount of the payment.
45	Refunded amount	The refunded amount of the payment.
46	Retrieval Reference Number (RRN)	A Retrieval Reference Number (RRN) is a a numeric key to uniquely identify a card-based payment (applicable to in-store only).
47	Sub-status	The payment sub-status provides more details into why it was declined.
48	In-store response code	The response code from the card issuer when the payment is declined for in-store channel.
49	Online response code	The response code from the card issuer when the payment is declined for online channel.
50	Online response description	The description of the response code for online channel. When a payment has been declined or failed this field would provide additional details.
51	Acceptance code	The acceptance code of an in-store transaction.
52	AVS response code	Response code for Address Verification Service (AVS) check.
53	CVV response code	Response code for Card Verification Value (CVV) check.
54	Scheme transaction ID	The payment identifier assigned by the scheme.
55	Reconciliation ID	The unique identifier assigned to this payment by the payment orchestration layer.
56	Service ID	The payment identifier assigned by the payment processor.
57	Payment Account Reference (PAR)	Payment Account Reference code for the payment.
58	Card fingerprint	Card fingerprint for the payment.
59	Merchant name	The merchant name.
60	Buyer external identifier	The unique identifier assigned to the online buyer in the merchant's ecommerce platform.
61	Buyer name	The buyer name (applicable to online only).
62	Buyer ID	The buyer identifier (applicable to online only).
63	Network terminal ID	The ID of a payment terminal within a store (applicable to in-store only).
64	System Audit Trace Number (STAN)	A System Trace Audit Number (STAN) is a number generated by the cardholder bank that can be used to identify a payment (applicable to in-store only).
65	POS card input method	Card data input method (applicable to in-store only).
66	Card acceptor name location	Identifies the store location or only payment statement descriptor.
67	External merchant store ID	The ID of a specific store (applicable to in-store only).
68	3DS status	3-D Secure status.
69	3DS method	3-D Secure method (frictionless/challenge).
70	3DS authentication	3-D Secure authorisation response code.
71	3DS CAVV	The cardholder authentication value or AAV.
72	Payment account reference 3DS (PAR)	3-D Secure Payment Account Reference.
73	3DS Transaction ID	3-D Secure transaction identifier.
74	3DS reason	3-D Secure reason code.
75	3DS version	The version of 3DS used for this transaction.
76	Payment source	The payment source.
77	Merchant initiated	A flag that indicates whether it is a merchant-initiated transaction (true) or a customer-initiated-transaction (false). A merchant-initiated-transaction (MIT) refers to a card payment made by a merchant without the presence of the buyer.
78	Subsequent transaction	Indicates whether the transaction represents a subsequent payment coming from a recurring / installment.
79	Billing first name	The first name of the customer paying for the good/service.
80	Billing last name	The last name of the customer paying for the good/service.
81	Billing email address	The email of the customer paying for the good/service.
82	Billing phone number	The phone number of the customer paying for the good/service.
83	Billing house number	The house number of the customer paying for the good/service.
84	Billing address line 1	The address line 1 of the customer paying for the good/service.
85	Billing address line 2	The address line 2 of the customer paying for the good/service.
86	Billing City	The city or suburb of the customer paying for the good/service.
87	Billing State	The state of the customer paying for the good/service.
88	Billing Postcode	The postal code of the customer paying for the good/service.
89	Billing Country	The country of the customer paying for the good/service.
90	Billing Organisation	The organisation of the customer paying for the good/service.
91	Shipping first name	The first name of the customer receiving for the good/service.
92	Shipping last name	The last name of the customer receiving for the good/service.
93	Shipping email address	The email of the customer receiving for the good/service.
94	Shipping phone number	The phone of the customer receiving for the good/service.
95	Shipping house number	The house number of the customer receiving for the good/service.
96	Shipping address line 1	The address line 1 of the customer receiving for the good/service.
97	Shipping address line 2	The address line 2 of the customer receiving for the good/service.
98	Shipping City	The city of the customer receiving for the good/service.
99	Shipping State	The state of the customer receiving for the good/service.
100	Shipping Postcode	The postcode of the customer receiving for the good/service.
101	Shipping Country	The country of the customer receiving for the good/service.
102	Shipping Organisation	The organisation of the customer receiving for the good/service.
103	Refunds# ID	The refund identifier.
104	Refunds# status	The refund payment status payment status e.g. `Authorised`, `Captured`, `Refunded`, `Voided`, etc.
105	Refunds# currency	The refund payment currency.
106	Refunds# amount	The refund payment amount.
107	Refunds# targetType	The type of the payment that was refunded.
108	Refunds# targetId	The identifier of the payment that was refunded.
109	Refunds# created date	The refund created date.
110	Refunds# updatedAt	The refund updated date.
111	Authorized date	The date the payment was authorised.
112	Updated date	The date the payment was last updated.
113	Captured date	The date the payment was captured.
114	Voided date	The date the payment was voided.
115	Refund earliest date	The earliest refund date.
116	Refund latest date	The latest refund date.

📘Export limit

📘
Export limit