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.