---
title: Fundings File
slug: fundings-file
createdAt: 2023-09-02T14:15:43.985Z
---

# Overview

**Context:&#x20;**&#x41;ll funding/settlement transactions for all merchants on a given day.&#x20;

**File Type**: CSV

**File Name**: \<company\_name>\_funding\_YYYYMMDDHHmmSS&#x20;

- 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&#x20;

| **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                                |

&#x20;\* IP address is mandatory for all transactions where channel is "Online".

&#x20;† 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.&#x20;
- 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.

