> ## Documentation Index
> Fetch the complete documentation index at: https://docs.quidkey.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Transaction Export

> The columns of a file of transactions, in the order a file has them

`GET /merchants/{id}/transactions` and `POST /merchants/{id}/transactions:search` answer a file for `Accept: text/csv` or `Accept: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet`. [Lists, Pagination and Filters](https://docs.quidkey.com/api-v1/standards/collections.md#files) says how to ask for one. The file has a header row, then one row per transaction in the list's order, each from the transaction's full representation:

* A link is its target's `id`, in a column named after the field with `_id`, such as `payout_id`.
* An amount is a decimal in the currency's major units, at its ISO 4217 exponent: `45.50` for GBP 45.50, `1000` for JPY 1000, `12.340` for KWD 12.340. Its currency is in the column after it. In Excel it's a number shown at those places, so a spreadsheet sums it, and every other cell is text, so a value that looks like a formula is never evaluated. A file is an exception to the [money format](https://docs.quidkey.com/api-v1/standards/responses.md#money), as an event's [earlier fields](https://docs.quidkey.com/api-v1/webhooks.md#the-earlier-format) are.
* An instant is RFC 3339 in UTC, as in JSON, and an enum value is the one the representation holds.
* `true` and `false` are written as words, and `null` is an empty cell.
* `|` separates several values in one cell.

A file leaves out `required_actions`, which a single read explains, `rewards`, the `refunds` collection link, the `customer_details` link, the one-time `checkout` and `failure`'s `message`. It holds no customer details.

| Column | Meaning |
| - | - |
| `id` | The transaction's `id`. |
| `type` | `payment`, `refund` or `reversal`. |
| `is_test` | `true` on a test transaction. A file holds live transactions, or test ones with `is_test=true`, as the list does. |
| `transaction_number` | A short reference, the same in Console and the API. |
| `status` | `pending`, `processing`, `completed`, `failed`, `cancelled` or `unresolved`. No status confirms that money has arrived. |
| `reason` | The caller's reason, on a refund. |
| `failure_code` | Why a `failed` payment transaction failed, such as `INSUFFICIENT_FUNDS`. Empty otherwise. |
| `failure_retryable` | `true` or `false`: whether the same payment transaction could succeed if the customer tried again. Empty when neither the bank nor Quidkey gave an indication, and with no `failure_code`. |
| `amount` | The customer's side, in the customer's currency: what they were charged, what they get back, or what the bank took back. |
| `amount_currency` | The currency of `amount`. |
| `payout_amount` | What a payment transaction adds to the merchant's payouts, after fees and any conversion. Empty unless a payment transaction is `processing` or `completed`. |
| `payout_amount_currency` | The currency of `payout_amount`. |
| `exchange_rate` | 1 unit of `exchange_rate_from_currency` converts to this many units of `exchange_rate_to_currency`. Empty until converted, and when no conversion ran. It explains the amounts, which are authoritative. |
| `exchange_rate_from_currency` | The currency the rate converts from. |
| `exchange_rate_to_currency` | The currency the rate converts to. |
| `fees_total` | The fees, in the customer's currency, or on a refund the refund account's. Empty when there are none, and on a `failed`, `cancelled` or `unresolved` payment transaction. |
| `fees_total_currency` | The currency of `fees_total`. |
| `fee_items` | Each fee as `type:amount`, its `type` `percentage` or `fixed` and its amount in `fees_total_currency`, such as `percentage:2.00\|fixed:0.30`. |
| `routing` | `virtual_account` when the money passes through a virtual account Quidkey runs for the merchant, or `direct`. Empty until decided. |
| `refund_status` | How far refunds of a payment transaction have got: `refunding`, `refunding_blocked`, `refunding_failed`, `partially_refunded` or `fully_refunded`. Empty with no refunds, and on a refund or a reversal. |
| `can_refund` | Whether a refund that moves money can be created now. |
| `order_id` | The caller's order. |
| `reported_statement_descriptor` | What the provider reported as sent. |
| `platform` | How the payment transaction came: `api`, `payment_link`, `shopify` or `woocommerce`. Empty on a refund and a reversal. |
| `merchant_id` | The merchant's `id`. |
| `parent_transaction_id` | The payment transaction, on a refund or a reversal. |
| `reversal_ids` | A payment transaction's reversals. |
| `payout_id` | The payout that carries the transaction. Empty until batched, and on a test transaction. |
| `created_at` | When the transaction was created. |
| `updated_at` | When the transaction last changed. |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.