Importing Mandates via Dashboard

You will learn how to import mandates via Dashboard.

You can now import mandates from the Subscription Dashboard. Merchants can utilize the CF Format, with a convenient sample file that is available for download from the Subscription Dashboard.

Importing Mandate File Columns Description (Cashfree Format)

Required Fields	Description
UMRN_NO	UMRN number of the mandate (should be 20 characters).
PAYMENT_TYPE	Import mandates is applicable only for eNACH. The value for this should be E_MANDATE.
DEBIT_ACCOUNT_NUMBER	Account number of the customer (should be a maximum of 35 characters).
DEBIT_ACCOUNT_HOLDER_NAME	Name of the customer (should be maximum of 40 characters).
DEBIT_BANK_ID	Bank ID. It should be the same as the first 4 characters of the UMRN number (should be same as first 4 characters of the UMRN number).
DEBIT_ACCOUNT_TYPE	Account type. Possible values - SAVINGS or CURRENT.
MAX_AMOUNT	Maximum amount of the mandate.
FREQUENCY	Debit frequency. Possible values: ADHO-Adhoc WEEK-Weekly MNTH-Monthly BIMN-Every 2 months QURT-Every 3 months MIAN-Every 6 months YEAR-Yearly.
START_DATE	The date on which the mandate was authorized. (This should ideally be before current date).
END_DATE	Expiry date of the mandate (should be a future date).
SUBSCRIPTION_ID	A unique ID for the subscription. It can include alphanumeric characters, underscore, dot, hyphen, and space. Maximum characters allowed is 200.
CUSTOMER_EMAIL	Email ID of the Customer (should be a valid email address, a maximum of 250 characters are allowed).
CUSTOMER_PHONE	Phone number of the customer (should be a valid phone number, with or without +91).

Conditional Fields

Required Fields	Description
FIXED_AMOUNT	This will be the recurring amount for mandate for the given FREQUENCY. Mandatory filed if FREQUENCY is not ADHO.
FIRST_CHARGE_DATE	The first charge date for mandate after import. Mandatory if FREQUENCY is not ADHO.

Optional Fields

Required Fields	Description
MAX_CYCLES	The number of charge cycles that is needed before moving the subscription to COMPLETED state.

Importing Mandates via Dashboard

Download the sample file and fill the details of mandates to be imported.

Click on the Upload File option and upload the file.

ℹ️
We reject the files if -

If the file format is wrong (only csv is supported), headers are different or all records have invalid data.

If some of the records are wrong, we show a popup asking whether mandates can be imported for the valid records or cancel the whole file.

We will process the file only if all the records are valid. After the processing is complete - merchant can see the imported subscriptions in ACTIVE state in the subscriptions page.

Updated 4 months ago