How to generate mandate requests using bulk CSV upload?

How to generate mandate requests using bulk CSV upload?


A sample CSV can be found on this link and upload under mandate book CSV upload section pictured below:


   

   

Column name

Example input

Description

mandate_sequence

1

This should be unique, like serial number

customer_ref_number

CUST0001

Pass customer_id here. For your internal reference

scheme_ref_number

HFL00001

Pass loan account number / folio number / policy number etc. For your internal reference

sponsor_bank_name

YES Bank Ltd

Sponsor bank name

bank_identifier

YESB

Sponsor bank short code

sponsor_bank_id

YESB0000001

Sponsor bank IFSC code

login_id

NACHTEST0000001

Sponsor bank login ID or Corporate Identifier or Utility Code, as instructed by Sponsor Bank

service_provider_name

DHFL Housing Finance Ltd

Corporate name registered with NPCI

service_provider_utility_code

NACHTEST0000001

Utility code

management_category

L001

Management category mapped to utility code

instrument_type

DEBIT

DEBIT

is_recurring

TRUE

True if recurring, False if one-time

frequency

ADHOC

The highest frequency at which debits can be made.

first_collection_date

43109

yyyy-mm-dd

final_collection_date

43474

yyyy-mm-dd

collection_amount

12345

Applicable for a fixed amount mandate. Either collection_amount or maximum amount should be passed. Max allowed for eNACH is 100000

maximum_amount

20000

For mandate for maximum amount. Either collection_amount or maximum amount should be passed. Max allowed for eNACH is 100000

customer_account_type

SAVINGS

SAVINGS

destination_bank_name

HDFC Bank Ltd

Customer (Destination) bank name

destination_bank_id

HDFC0000001

Customer Bank IFSC code

customer_account_number

536375000000

Customer Bank account number. Please ensure all numeric fields are formatted as TEXT to avoid removal of '0's prefixed

customer_name

SANKET NAYAK

Customer name as per bank records

customer_mobile

919536000000

Customer mobile

customer_email

sanket@digio.in

Customer email

expire_in_days

30

The number of days that the eSign link is to be valid 

notify_signer

TRUE

If TRUE, send SMS/Email

signer_identifier

sanket@digio.in

Enter Customer Mobile (91XXXXXXXXXX) number or Email

expire_in_days

30

eSign link to be valid for how many days

notify_signer

TRUE

TRUE, if send SMS/Email

signer_identifier

sanket@digio.in

Enter Customer Mobile (91XXXXXXXXXX) number or Email


All the mandates will be visible under the Mandate Book section.