Payments export

Find out how to export your payment listing from the Connect portal.

📘

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

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

  1. Export canvas will be loaded on right side of the screen
Export view screen

Export view screen

  1. 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
Screen to select export outputs

Screen to select export outputs

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

Export view - Starting status

Export view - Processing status

Export view - Processing status

Export view

Export view

  1. If you want to cancel the export operation, select Cancel to stop the processing
  2. 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.
Success message

Success message

Failure message

Failure message


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


Field #Field NameField Description
01Transaction dateThe date of the payment in UTC.
02StatusThe payment status e.g. Authorised, Captured, Refunded, Voided, etc.
03ChannelPayment channel. The values can either be Online or In-store.
04Input methodIdentifies the method used to provide card information. e.g. Swipe, Contactless, Insert for in-store and Ecommerce, Card on file for online.
05Local transaction timestampThe local date and time of the payment.
06Transaction IDUnique payment identifier.
07Merchant reference IDUnique merchant-generated order reference or tracking number for each transaction.
08Transaction typeThe payment type. Possible values are CP for in-store or CNP for ecommerce.
09Primary tender binThe 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.
10Primary tender labelThe 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.
11Primary tender payment methodThe payment method of primary tender. e.g. CardDebit, CardCredit, Paypal, etc.
12Primary tender schemeThe card scheme.
13Primary tender amountThe primary tender transaction amount.
14Primary tender refunded amountThe primary tender refunded amount.
15Primary tender statusThe payment status e.g. Authorised, Captured, Refunded, Voided, etc.
16GC# IDUnique giftcard payment identifier.
17GC# binGift card issuer Bank Identification Number (BIN)
18GC# amountGift card transaction amount.
19GC# refunded amountGift card refunded amount.
20GC# statusGift card payment status e.g. Authorised, Captured, Refunded, Voided, etc.
21GC# sub-statusGift card payment sub-status provides more details into why it was declined.
22GC# error codeThe error code for gift card. When a payment has been declined or failed this field would provide additional details.
23GC# raw error codeThe raw error code for gift card. When a payment has been declined or failed this field would provide additional details.
24GC# error messageThe error message for gift card. When a payment has been declined or failed this field would provide additional details.
25Item# nameThe name of the cart item.
26Item# quantityThe quantity of item in the cart.
27Item# amountAmount of the cart item.
28Item# discountThe amount discounted for this item.
29Item# tax amountThe tax amount for this item.
30Item# categoriesA list of strings containing product categories for the item.
31Payment methodThe payment method. e.g. CardDebit, CardCredit, Paypal, etc.
32ExpirationThe payment method expiration date.
33CurrencyThe payment currency.
34In-store CountryThe country associated with the in-store payment method used for payment e.g. the country of issuance of the scheme card.
35Issuer institution nameThe name of the financial institution that issued the credit or debit card.
36Issuer institution IDThe ID of the financial institution that issued the credit or debit card.
37Card acceptor idThe ID of the store/location where payment originated from.
38Online CountryThe country associated with the online payment method used for payment e.g. the country of issuance of the scheme card.
39Total transaction amountTotal transaction amount.
40Purchase amountThe 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.
41Cashout amountThe cashout amount and currency.
42Tip amountThe tip amount and currency.
43Surcharge amountThe surcharge amount and currency.
44Captured amountThe captured amount of the payment.
45Refunded amountThe refunded amount of the payment.
46Retrieval 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).
47Sub-statusThe payment sub-status provides more details into why it was declined.
48In-store response codeThe response code from the card issuer when the payment is declined for in-store channel.
49Online response codeThe response code from the card issuer when the payment is declined for online channel.
50Online response descriptionThe description of the response code for online channel. When a payment has been declined or failed this field would provide additional details.
51Error codeThis is an error code set by Gr4vy.
52Acceptance codeThe acceptance code of an in-store transaction.
53AVS response codeResponse code for Address Verification Service (AVS) check.
54CVV response codeResponse code for Card Verification Value (CVV) check.
55Scheme transaction IDThe payment identifier assigned by the scheme.
56Reconciliation IDThe unique identifier assigned to this payment by the payment orchestration layer.
57Service IDThe payment identifier assigned by the payment processor.
58Payment Account Reference (PAR)Payment Account Reference code for the payment.
59Card fingerprintCard fingerprint for the payment.
60Instrument typeThe name of the instrument used to process the transaction.
61Merchant nameThe merchant name.
62Buyer external identifierThe unique identifier assigned to the online buyer in the merchant's ecommerce platform.
63Buyer nameThe buyer name (applicable to online only).
64Buyer IDThe buyer identifier (applicable to online only).
65Network terminal IDThe ID of a payment terminal within a store (applicable to in-store only).
66System 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).
67POS card input methodCard data input method (applicable to in-store only).
68Card acceptor name locationIdentifies the store location or only payment statement descriptor.
69External merchant store IDThe ID of a specific store (applicable to in-store only).
703DS status3-D Secure status.
713DS method3-D Secure method (frictionless/challenge).
723DS authentication3-D Secure authorisation response code.
733DS CAVVThe cardholder authentication value or AAV.
74Payment account reference 3DS (PAR)3-D Secure Payment Account Reference.
753DS Transaction ID3-D Secure transaction identifier.
763DS reason3-D Secure reason code.
773DS versionThe version of 3DS used for this transaction.
783DS XIDThe transaction identifier.
793DS directory responseThe transaction status received as part of the authentication request.
803DS error codeThe error code.
813DS error componentCode indicating the 3-D Secure component that identified the error.
823DS error descriptionThe error description.
833DS error detailDetail for the error.
84Payment sourceThe payment source.
85Merchant initiatedA 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.
86Subsequent transactionIndicates whether the transaction represents a subsequent payment coming from a recurring / installment.
87Billing first nameThe first name of the customer paying for the good/service.
88Billing last nameThe last name of the customer paying for the good/service.
89Billing email addressThe email of the customer paying for the good/service.
90Billing phone numberThe phone number of the customer paying for the good/service.
91Billing house numberThe house number of the customer paying for the good/service.
92Billing address line 1The address line 1 of the customer paying for the good/service.
93Billing address line 2The address line 2 of the customer paying for the good/service.
94Billing CityThe city or suburb of the customer paying for the good/service.
95Billing StateThe state of the customer paying for the good/service.
96Billing PostcodeThe postal code of the customer paying for the good/service.
97Billing CountryThe country of the customer paying for the good/service.
98Billing OrganisationThe organisation of the customer paying for the good/service.
99Shipping first nameThe first name of the customer receiving for the good/service.
100Shipping last nameThe last name of the customer receiving for the good/service.
101Shipping email addressThe email of the customer receiving for the good/service.
102Shipping phone numberThe phone of the customer receiving for the good/service.
103Shipping house numberThe house number of the customer receiving for the good/service.
104Shipping address line 1The address line 1 of the customer receiving for the good/service.
105Shipping address line 2The address line 2 of the customer receiving for the good/service.
106Shipping CityThe city of the customer receiving for the good/service.
107Shipping StateThe state of the customer receiving for the good/service.
108Shipping PostcodeThe postcode of the customer receiving for the good/service.
109Shipping CountryThe country of the customer receiving for the good/service.
110Shipping OrganisationThe organisation of the customer receiving for the good/service.
111Refunds# IDThe refund identifier.
112Refunds# statusThe refund payment status payment status e.g. Authorised, Captured, Refunded, Voided, etc.
113Refunds# currencyThe refund payment currency.
114Refunds# amountThe refund payment amount.
115Refunds# targetTypeThe type of the payment that was refunded.
116Refunds# targetIdThe identifier of the payment that was refunded.
117Refunds# created dateThe refund created date.
118Refunds# updatedAtThe refund updated date.
119Authorized dateThe date the payment was authorised.
120Updated dateThe date the payment was last updated.
121Captured dateThe date the payment was captured.
122Voided dateThe date the payment was voided.
123Refund earliest dateThe earliest refund date.
124Refund latest dateThe latest refund date.