The Interchange report details credit card interchange fees paid on a daily and monthly basis, per Merchant ID.
For an in-depth guide on Online Payments Reporting, view the Online Payments Reporting Guide.
The report displays gross and net amounts for both sales and refunded transactions.
Parameter Options
- Period (able to select the date or date range)
Accessibility Options
- View on screen
- Download
- Subscription
Columns
The column names listed in the table below read left to right on the report.
# | Data Element | Data Type | Description |
1 | Merchant ID | bigint | Unique identification number for the merchant |
2 | Processing Date | timestamp | Date the transaction cleared |
3 | Interchange Program | varchar | Name of the interchange program as per the card brand association |
4 | Card Category | varchar | Category that the card type is linked to |
5 | Card Type | varchar | Type of card (e.g. Credit / Debit / Prepaid) |
6 | IC Rate % | bigint | Percentage per transaction, applied against the transaction amount |
7 | IC Rate $ | bigint | Fixed fee assessed by card brands (E.g. Visa, Mastercard, Discover, American Express etc.) |
8 | Exempt/Regulated | varchar | States if the interchange of the card is regulated or unregulated |
9 | Sales Count | bigint | Total count of transaction sales |
10 | Sales Amount | bigint | Total amount of transaction sales |
11 | Refund Count | bigint | Total count of refunds |
12 | Refund Amount | bigint | Total amount of refunds |
13 | Fees | bigint | Total fees per card category |
14 | Net Sales | bigint | Sales total minus the interchange fee |
Proceed to the next article on this topic: Refund Report.
Comments
0 comments
Please sign in to leave a comment.