Interchange Report
Description: 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.