Fundings File
Overview
Context: All funding/settlement transactions for all merchants on a given day.
File Type: CSV
File Name: <company_name>_funding_YYYYMMDDHHmmSS
- Example = <company_name>_funding_20221110233030
- company_name = your companies name
- When uploading test files, please append "_testing" at the end of the file name
- Example = <company_name>_funding_20221110233030_testing
Frequency: Daily
Funding - Data Columns
Column Name | Mandatory | Format Details | Example |
|---|---|---|---|
Environment | Mandatory | Valid values are: "Production" or "Testing" | Production |
Settlement Date/Time | Mandatory | DD/MM/YYYY HH:mm:SS | 31/01/2022 16:34:45 |
Transaction ID | Mandatory | | a13f1609-7854-47a6-b533-339f3ac80be8 |
Authorisation ID | Mandatory | | b533-339f3ac80be8-100122 |
Merchant Registration ID | Mandatory | Depends on registered country - see data dictionary | 12345678 |
Payment Method | Mandatory | Depends on registered country - see data dictionary | Credit Card |
Transaction Type | Mandatory | Valid values are: "Purchase" & "Refund" | Purchase / Refund |
Merchant Category Code | Mandatory | 4 digit numeric value based on ISO 18245 | 5812 |
URL | Mandatory | Merchant website URL | www.timstiles.com |
Billing Descriptor | Mandatory | | Tim's Tiles |
Scheme MID | Mandatory | | MID used within the card scheme network |
Card Bin | Mandatory | First 6 digits of the card number. | 512345 |
Transaction Currency | Mandatory | 3 letter, ISO 4217 currency code | USD |
Transaction Amount | Mandatory | Numeric value with no currency symbol. | 100 |
Channel | Mandatory | Valid values are: "POS", "Online" & "Other" | POS / Online / Other |
IP Address | Mandatory* | IPv6 or IPv4 | 101.100.10.100 |
Terminal ID | Mandatory† | | 10350001 |
* IP address is mandatory for all transactions where channel is "Online".
† Terminal ID is mandatory for all transactions where channel is "POS".
Notes:
- Please adhere by the format details of each column provided.
- The funding file should contain all purchase/sale events, as well as any refunds that occur.
- Each funding/settlement should have a corresponding authorisation in the Authorisations File (but not neccessarly on the same day). This should be linkable via the Authorisation ID values in both files.
- Scheme MID is the card scheme/network merchant ID.