> ## Documentation Index
> Fetch the complete documentation index at: https://docs.ebrc.in/llms.txt
> Use this file to discover all available pages before exploring further.

# Download Bulk Upload Template

> Download the Excel bulk upload template for eBRC generation, with all 37 column headers and one example row, then fill one row per IRM-to-invoice mapping.

Download a pre-filled Excel (`.xlsx`) template with all required and optional column headers and one example row. Use it as the starting point for a [bulk upload](/api-reference/genebrc/bulk-upload). Column headers are matched to fields by name, so keep the header text unchanged.

The file is named `ebrc-bulk-upload-template.xlsx` and the sheet is named `EBRC Bulk Upload`.

### Request example

```bash theme={"dark"}
curl --request GET \
  --url 'https://ebrcapi.eximfiles.io/api/v1/genebrc/bulk-upload/template' \
  --header 'x-api-key: <YOUR_API_KEY>' \
  --output ebrc-bulk-upload-template.xlsx
```

### Template columns

The template contains these 37 columns, in order, with the example row the file ships with:

| Column header               | Example row value |
| --------------------------- | ----------------- |
| Serial No                   | `1`               |
| Upload Type                 | `1`               |
| Branch Sl No                | `1`               |
| IRM IFSC Code               | `HDFC0001234`     |
| IRM AD Code                 | `0510215`         |
| IRM Number                  | `IRMNUMBER123`    |
| IRM Date                    | `01/01/2024`      |
| IRM FCC                     | `USD`             |
| IRM Purpose Code            | `P0102`           |
| IRM Remit Amt FCC           | `10000`           |
| SB Cum Invoice Number       | `INV/2024/001`    |
| SB Cum Invoice Date         | `01/01/2024`      |
| Port Code                   | `INMAA1`          |
| Bill No                     | `SB123456`        |
| SB Cum Invoice FCC          | `USD`             |
| SB Cum Invoice Value In FCC | `10000`           |
| Mapped IRM Amount FCC       | `10000`           |
| Is Vostro                   | `N`               |
| Vostro Type                 |                   |
| Mapped ORM Amount FCC       |                   |
| Is Third Party Export       | `N`               |
| Commission Val Deduct       |                   |
| Commission Val Info         |                   |
| Discount Val Deduct         |                   |
| Discount Val Info           |                   |
| Insurance Val Deduct        |                   |
| Insurance Val Info          |                   |
| Other Deduction Deduct      |                   |
| Other Deductions Info       |                   |
| Freight Val Deduct          |                   |
| Freight Val Info            |                   |
| SAC Code 1                  |                   |
| SAC Code 2                  |                   |
| Service Type Modes Value    |                   |
| Is GST Avail                | `N`               |
| GSTIN Invoice Number        |                   |
| GSTIN Invoice Date          |                   |

Each column maps to the field of the same name in the [Push IRM Request Fields annexure](/annexure/push-irm), which documents formats and constraints.

### Valid codes

* [Purpose Codes](/annexure/purpose-codes) for IRM Purpose Code
* [Currency Codes](/annexure/currency-codes) for IRM FCC and SB Cum Invoice FCC
* [Port Codes](/annexure/port-codes) for Port Code

### Next steps

* [Upload the filled file](/api-reference/genebrc/bulk-upload).
* Want the template pre-filled with real IRM data? Use [Load IRMs in Excel](/api-reference/irm/bulk-template).


## OpenAPI

````yaml GET /genebrc/bulk-upload/template
openapi: 3.1.0
info:
  title: eBRC API
  description: >-
    REST API for generating and managing electronic Bank Realization
    Certificates (eBRC) through DGFT's GenEBRC module. Onboard exporters,
    validate their DGFT credentials, pull inward remittance (IRM) data, submit
    certificate generation requests singly or in bulk, and track them to
    completion. All JSON responses are wrapped in the standard envelope {
    success, data, statusCode, timestamp }; the schemas on each endpoint
    describe the data field.
  contact:
    name: Eximfiles support
    email: amin@eximfiles.io
  version: 1.0.0
servers:
  - url: https://ebrcapi.eximfiles.io/api/v1
    description: Production
  - url: https://ebrcapi.dev.eximfiles.com/api/v1
    description: Sandbox
security:
  - x-api-key: []
paths:
  /genebrc/bulk-upload/template:
    get:
      summary: Download bulk upload template
      description: >-
        Download a pre-filled Excel (.xlsx) template with all required and
        optional column headers and one example row. Use this as the starting
        point for your bulk upload file.
      operationId: downloadBulkUploadTemplate
      responses:
        '200':
          description: Excel template file (.xlsx)
          content:
            application/vnd.openxmlformats-officedocument.spreadsheetml.sheet:
              schema:
                type: string
                format: binary
components:
  securitySchemes:
    x-api-key:
      type: apiKey
      name: x-api-key
      in: header

````