Exceptions (Daily)

The exceptions files can be used by treasury and accounting teams to reconcile funds movement associated with exception items. Chargebacks, returns, and adjustments are included in this file.

The Exceptions Report is generated daily. If there are no exceptions for the day, then an empty report is generated (header only).

📄

File name: 20250110_exceptions_v2-5.csv

📘

Report Names

If you are configured to receive reports at the ISO level, the file name format will be: ISO_YYYYMMDD_reportname (e.g. 1234_20251017_reportname.csv)

If you are configured to receive reports at the MID level, the file format name will be: ISO_MID_YYYYMMDD_reportname (e.g. e.g. 1234_321_20251017_reportname.csv)

Position

Field

Description

1

ISO

4-Digit ID assigned by TabaPay

2

MID

Merchant ID (Identifies a specific program/merchant under the ISO)

3

Merchant Reference ID

referenceID sent by the merchant in the Create Transaction API request

4

Original Transaction ID

transactionID sent by TabaPay in the Create Transaction API response

5

Exception ID

Unique reference number generated by TabaPay for each exception.

6

Exception type

Adjustment - credit
Adjustment - debit
CHARGEBACK
CHARGEBACK REVERSAL
REPRESENTMENT
Return

7

Exception Code

Network-specific reason code

8

Exception Description

Description of the Exception Code

9

Exception Date

Date exception posted. Corresponds with the date of the report.

10

Action-Status

Indicates the status of the exception.

11

Status Date

Date of most recent change in Action Status. This is the date of the Exceptions report.

12

Days Open

Days since last movement of funds.

13

Network Transaction ID

Acquirer Reference Number (ARN)

14

Original Creation Date

Date/Time (GMT) original Transaction Request was created

15

Original Processed Date

Date/Time (GMT) Transaction processed at the Network

16

Original Transaction Type

Purchase
Disbursement
Adjustment - credit

17

Exception Source

If "Exception type" = CHARGEBACK, exception source = Settlement
If "Exception type" = REPRESENTMENT, exception source = the exception network

18

Exception Destination

If "Exception type" = CHARGEBACK, exception destination = the exception network
If "Exception type" = REPRESENTMENT, exception destination = Settlement

19

Exception Network

Network card scheme

20

Last 4

Last 4 of beneficiary card (add “0s” in front of number if less than 4 digits)

21

Original Settled Amount

Original transaction amount

22

Exception Settled Amount

Original transaction amount

23

TabaPay Fee

TabaPay fee for the exception

24

Network Fee

Network fee for the exception

25

Interchange

Interchange for the exception

26

Memo

memo passed in the Create Transaction request.

27

CB ID

Case ID assigned by the card network.

28

Firstname

First Name

29

Lastname

Last Name

30

Network ID

Original transaction Network ID