Transactions Export Data

Time	Status	User Agent
Retrieving recent requests…

Time

Status

User Agent

Retrieving recent requests…

Transactions Export Data

The Transactions export file provides detailed financial transaction data organized by merchant and batch. It covers all payment transactions processed on a given date and is the primary file for transaction-level reconciliation, interchange qualification analysis, and settlement verification. Amounts are expressed in cents throughout the file.

Endpoint

GET /download/YYYYMMDD/Transactions

Authentication

Basic HTTP Authentication required.
Encode username:password in Base64 and pass in the Authorization header:

Authorization: Basic {base64(username:password)}

When to use

Use this file daily to reconcile settled transactions against batch totals, verify that NetDepositAmount at the batch level equals SalesAmount minus RefundAmount minus fees, and audit TerminalEntryMode values to ensure correct interchange qualification. Cross-reference PS2000TransactionIdentifier with the TransactionsExtendedData file when analyzing interchange costs by extended card type.

Query Parameters

None. The file is identified by the date path segment (YYYYMMDD) and delivered via SFTP.

Response

200 OK — Returns XML content with the following structure:

XML Hierarchy: Merchant > Batches > Batch > Transactions > Transaction

<Merchant> fields:

Field	Type	Description
`MID`	string	Merchant identifier (unique account number)

<Batch> fields:

Field	Type	Description
`InternalId`	integer	Internal system identifier for the batch
`BatchId`	string	External batch identifier
`PointOfSaleOrInteractionTerminalIdentifier`	string	V-number: terminal ID where the batch originated
`BatchDate`	datetime	Date the batch was closed
`MerchantDepositDate`	datetime	Date funds are scheduled to be deposited to the merchant
`BatchNumber`	string	Sequential batch number for the processing period
`NetDepositAmount`	decimal	Net amount deposited after fees and refunds (in cents)
`TransactionsCount`	integer	Total number of transactions in the batch
`SalesAmount`	decimal	Total sales volume in cents
`SalesCount`	integer	Number of sale transactions
`RefundAmount`	decimal	Total refund amount in cents
`RefundCount`	integer	Number of refund transactions

<Transaction> fields:

Field	Type	Description
`CardType`	string	Card network: `V` = Visa, `M` = Mastercard, `S` = Amex, `D` = Discover, `R` = Discover (proprietary BIN)
`CardholderAccountNumber`	string	Masked card PAN, e.g. `000000******0000`
`TransactionDate`	datetime	Date and time the transaction occurred
`TransactionAmount`	decimal	Transaction amount in cents
`TerminalEntryMode`	string	Card capture method: `01` = manual, `02` = magnetic stripe, `05` = chip/EMV, `07` = contactless
`AuthorizationCode`	string	Approval code returned by the card issuer
`AuthorizationSourceCode`	string	Source of authorization response (empty for Mastercard)
`CardholderIdentificationMethod`	string	Cardholder ID: space = not specified, `1` = signature, `2` = PIN, `3` = unattended, `4` = MOTO
`AuthorizationCharacteristicsIndicator`	string	Interchange qualification indicator
`PS2000TransactionIdentifier`	string	Unique network-level transaction reference identifier
`ValidationCode`	string	Interchange validation code (empty for Mastercard)
`TransactionCode`	string	Internal code classifying the transaction type
`AuthorizationResponseCode`	string	Issuer response code: `00` = approved
`TransactionFee`	decimal	Fee applied to the transaction in cents (`0` if none)
`TransactionFeeIndicator`	string	Fee type indicator (empty if none)

<Merchant>
  <MID>9180000000001234</MID>
  <Batches>
    <Batch>
      <InternalId>20275286</InternalId>
      <BatchId>00000124797</BatchId>
      <PointOfSaleOrInteractionTerminalIdentifier>79416045</PointOfSaleOrInteractionTerminalIdentifier>
      <BatchDate>2026-05-27T00:00:00</BatchDate>
      <MerchantDepositDate>2026-05-28T00:00:00</MerchantDepositDate>
      <BatchNumber>0193</BatchNumber>
      <NetDepositAmount>47500</NetDepositAmount>
      <TransactionsCount>2</TransactionsCount>
      <SalesAmount>47500</SalesAmount>
      <SalesCount>2</SalesCount>
      <RefundAmount>0</RefundAmount>
      <RefundCount>0</RefundCount>
      <Transactions>
        <Transaction>
          <CardType>V</CardType>
          <CardholderAccountNumber>414100******0555</CardholderAccountNumber>
          <TransactionDate>2026-05-27T14:22:00</TransactionDate>
          <TransactionAmount>25000</TransactionAmount>
          <TerminalEntryMode>07</TerminalEntryMode>
          <AuthorizationCode>412649</AuthorizationCode>
          <AuthorizationSourceCode>V</AuthorizationSourceCode>
          <CardholderIdentificationMethod>1</CardholderIdentificationMethod>
          <AuthorizationCharacteristicsIndicator>E</AuthorizationCharacteristicsIndicator>
          <PS2000TransactionIdentifier>346134553487245</PS2000TransactionIdentifier>
          <ValidationCode>ML6X</ValidationCode>
          <TransactionCode>0101</TransactionCode>
          <AuthorizationResponseCode>00</AuthorizationResponseCode>
          <TransactionFee>0</TransactionFee>
          <TransactionFeeIndicator />
        </Transaction>
        <Transaction>
          <CardType>M</CardType>
          <CardholderAccountNumber>536759******6473</CardholderAccountNumber>
          <TransactionDate>2026-05-27T15:10:00</TransactionDate>
          <TransactionAmount>22500</TransactionAmount>
          <TerminalEntryMode>05</TerminalEntryMode>
          <AuthorizationCode>072795</AuthorizationCode>
          <AuthorizationSourceCode />
          <CardholderIdentificationMethod>1</CardholderIdentificationMethod>
          <AuthorizationCharacteristicsIndicator>A</AuthorizationCharacteristicsIndicator>
          <PS2000TransactionIdentifier>MDJN4MFFJ</PS2000TransactionIdentifier>
          <ValidationCode />
          <TransactionCode>0101</TransactionCode>
          <AuthorizationResponseCode />
          <TransactionFee>0</TransactionFee>
          <TransactionFeeIndicator />
        </Transaction>
      </Transactions>
    </Batch>
  </Batches>
</Merchant>

Error Codes

Code	When it happens
400	Malformed date format in URL path
401	Invalid or missing Basic Auth credentials
403	User does not have permission for this operation
404	No Transactions file found for the specified date
500	Internal server error

Common Mistakes

Not dividing amounts by 100 — TransactionAmount: 25000 = $250.00; all amounts are in cents.
Treating NetDepositAmount as the gross sales total — it is the net after refunds and fees at the batch level.
Flagging empty ValidationCode and AuthorizationResponseCode for Mastercard as errors — these fields are intentionally blank for Mastercard.
Using TerminalEntryMode incorrectly can result in interchange downgrades — validate that the reported entry mode matches the physical capture method at the terminal.
Not masking CardholderAccountNumber in downstream storage — the file already delivers a masked PAN but parsers must not re-expose raw data in logs.

Related Endpoints

GET /download/YYYYMMDD/SimplifiedFormat — simplified multi-merchant consolidated format
GET /download/YYYYMMDD/TransactionsExtendedData — extended card type and network identifier per transaction
GET /download/YYYYMMDD/TransAuth — authorization records for each transaction attempt
GET /download/YYYYMMDD/ACH — ACH deposit records that settle the batches in this file

Example

curl -X GET "https://hq.staging.netevia.dev/download/20260528/Transactions" \
  -H "Authorization: Basic $(echo -n 'username:password' | base64)"

Transactions Export Data

Endpoint

Authentication

When to use

Query Parameters

Response

Error Codes

Common Mistakes

Related Endpoints

Example

200OK