How can I generate presentation requests(debits) using bulk CSV upload?

How can I generate presentation requests(debits) using bulk CSV upload?

To create one or more presentations via csv upload, download the sample csv from the ‘Utilities’ menu on the ‘Presentations’ screen and fill up the fields in the sheet as below:

A sample csv can be found on this link




Field Name

Format/Example

Description

1

umrn

UMRN

Unique Mandate Reference Number.

2

amount

<debit_amt>

The amount to be debited from the customer's account.

3

settlement_date

<YYYY-MM-DD debit date>

The date on which the presentation file is to be shared with the bank.

4

unique_key

<unique_id_for_loan_emi>

The unique identifier used by the Corporate to track the business transaction carried out by the presentation.

5

corporate_account_number

<account_number>

The account to which the amount is to be credited.

6

corporate_config_id


The config ID set up for the Corporate with a Bank for the purpose of registering mandates.

7

destination_bank_id

<customer_ifsc/micr_as per mandate>

The IFSC code or MICR code of the customer's bank account, as per the registered mandate.

8

customer_account_number

<customer_ac_number>

The account number of the customer from which the amount is to be debited, as per the registered mandate.

9

destination_account_type

<customer_ac_type>

The type of the customer's account (Savings/Current)

10

customer_name

<customer_name>

The name of the customer as per the mandate.

11

frequency

ONETIME


12

present_before_days

1


13

narration

<txn_narration>

Narration as would appear in the customer's bank statement.




    • Related Articles

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

    • How can I download the CSV for bulk upload based on my template?

      To download the CSV for bulk upload based on your template, log into the Digio dashboard, navigate to the template, click on the template's dropdown arrow, and select "Download blank CSV."

    • How can I create multiple/ bulk form requests?

      This approach is recommended to be taken if you wish to create multiple forms links in bulk Step 1 : Select the form from the dashboard and click on download sample csv from the panel Step 2 : Import the csv into csv reader (msexcel, googlesheet, etc ...

    • How can I generate multiple/bulk sign requests from a single document?

      Step 1 : Select the template from the dashboard and click on download blank csv from the panel Step 2 : Upload the filled csv/xls using upload csv/xls option. Tips to fill the imported csv : First few columns would be the variables defined in the ...

    • What is the mandate presentation process using DigiCollect?

      For a debit to happen on day T, the API call/file upload should be done by late night on T-1. At 00:00 hrs T, Digio creates an ACH debit file in standard NPCI format and shares it with the Sponsor Bank. The Sponsor Bank uploads the debit files to ...