# E-Invoicing FTP Magnet (Excel)

FTP Magnet is a middleware application between your FTP server and ClearTax E-Invoicing Malaysia application. You can export data from your ERP to your own FTP server. As a part of on-boarding, ClearTax configures it’s FTP Magnet to connect to your FTP server. The FTP Magnet reads the input files from your FTP server and uploads them to ClearTax E-Invoicing Malaysia application. Once the uploaded files are processed, it writes the response back to your FTP server.

To download the specification document and a typical project plan, click on the link below.

FTP Magnet : Generate

{% file src="<https://2888774781-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LZ9fXxeBEm3pJiVldcu%2Fuploads%2FHxJUL2YwCyiOnVTalWs0%2FMY%20FTP%20Magnet%20-%20Generate%20Einv-%20Specification%20Document%20%26%20Project%20Plan.pdf?alt=media&token=04ba785d-166e-457f-8744-525a762cdd17>" %}

FTP Magnet : Upload

{% file src="<https://2888774781-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LZ9fXxeBEm3pJiVldcu%2Fuploads%2F6bbw7zqW6iq7HvgS2SuQ%2FMY%20FTP%20Magnet%20-%20Upload%20Einv-%20Specification%20Document%20%26%20Project%20Plan.pdf?alt=media&token=d86b4d69-5b5b-4c9a-ae7a-be26bf49c6c3>" %}

### Sample templates for various actions

#### Input:&#x20;

{% file src="<https://2888774781-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LZ9fXxeBEm3pJiVldcu%2Fuploads%2FrQ8TRdAGBOzAwlvIath7%2FC58746708080_Einvoice%20Malaysia%20Sales%20B2C%20System%20Template_TESTINGUPLOAD001.xlsx?alt=media&token=5fcf7d5a-7150-4211-a0bf-f71c9f2a3f27>" %}

{% file src="<https://2888774781-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LZ9fXxeBEm3pJiVldcu%2Fuploads%2FTUwT9sffmJoQkJHTTcF3%2FC58746708080_Einvoice%20Malaysia%20-%20Self%20Billed%20System%20Template_GENERATINGSELFBILLED003.xlsx?alt=media&token=7aaa3b26-e492-4b8e-aad0-ff8c725e5235>" %}

{% file src="<https://2888774781-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LZ9fXxeBEm3pJiVldcu%2Fuploads%2FrjJIOsD8QOE00aUA7COS%2FC58746708080_E-Invoice%20Malaysia%20Standard_TESTINGGENERATE002.xlsx?alt=media&token=f62473e2-23e2-4dd1-ab28-50ba062de044>" %}

{% file src="<https://2888774781-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LZ9fXxeBEm3pJiVldcu%2Fuploads%2F92kbu9l9ntvuqbgM4sfl%2FC58746708080_Einvoice%20Malaysia%20Sales%20B2C%20Generate%20System%20Template_TESTINGGENERATE002.xlsx?alt=media&token=b1087656-0042-4ae9-89e6-b317772ea6d5>" %}

{% hint style="warning" %}
**Note**: These template names and samples are applicable only if you are using our standard templates available in the portal. In case you have created custom templates, then the template names and headers might vary based on your customizations.
{% endhint %}

#### Output:&#x20;

{% file src="<https://2888774781-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LZ9fXxeBEm3pJiVldcu%2Fuploads%2FaL5wcB9GS53oYPiKTYiT%2FGENERATION_ERROR_RESPONSE.csv?alt=media&token=64d492a5-3ae9-4aa9-b726-97361a641805>" %}

{% file src="<https://2888774781-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LZ9fXxeBEm3pJiVldcu%2Fuploads%2FjZFOHp4Ejp6RC1o4wI4O%2FUPLOAD_ERROR_RESPONSE_FORMAT1.csv?alt=media&token=795fcea1-b2b0-4c22-8647-1f165324a9f1>" %}

{% file src="<https://2888774781-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LZ9fXxeBEm3pJiVldcu%2Fuploads%2FsAaKUV0AKQ88wICSiVK4%2FSUCCESS_RESPONSE.csv?alt=media&token=7d96d769-ebd1-406b-8d2d-ac515bde4c07>" %}

{% hint style="info" %}
The success and error file templates are subject to change. Both the headers and the order of columns may change. We recommend you map the output with flexible options to add or change the headers in the future.
{% endhint %}

### **Security** <a href="#security" id="security"></a>

The incoming requests from Clear to your FTP server will be sent from the below IPs:

**Sandbox**:  **3.1.39.20** AND **13.214.246.96** AND **18.136.230.8**

**Production**:  **54.169.101.178** AND **54.254.85.191** AND **18.141.130.70**

Since these IPs are for redundancies, you will have to whitelist all the IPs in respective environments.