# 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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.cleartax.in/cleartax-docs/e-invoicing-ftp-magnet-excel.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.