You can create NACH Debit transactions via batch file import. Go to Payments > Import, download the template, fill in the details and upload it. If it's valid, you can process it.
If you want to create multiple payments on existing mandates, you can import a CSV file to do it in bulk.
- Click on Payments in the side menu bar.
- Click on Import.
- Click on Download Template and open the CSV file.
- Follow the instructions below to complete the data in the CSV file.
- When you're ready, upload the CSV into the dashboard page. You can drag and drop the file in the box, or click on Browse to select the file from your computer.
- If the file is correctly formed, on the next page you will see the validation process beginning. If the file is not correctly formed, the on-screen notification will notify you what needs to be corrected.
- Refresh the page after a few seconds to check the validation status.
- If there are errors, repeat steps 4 to 6 to correct them. If there are no errors, click on Process and your payments will be created.
- You can export the created payments to a CSV file.
Populating data in the import file
Payments can be created against mandates with status of: pending, pending_submission, submitted, acknowledged and active. Although you can create payments on mandates that are already linked to subscriptions, it is not advisable. You will have to independently determine whether the mandate has capacity to support additional payments. For example: Suppose a mandate is of frequency monthly and it has a linked subscription recurring monthly - whilst our system will let you create additional payments on this mandate, the customer's bank may reject the second payment in a calendar month or one month period.
Enter one payment request per row.
Import data fields:
- Amount (mandatory) - Amount in Rupees (can have two decimal places). Must be less than or equal to the mandate's maximum_amount or equal to the mandate's fixed_amount.
- Charge Date (optional) - The date (today or a future date) on which the payment should be collected. If not specified, the payment will be collected as soon as possible. Must be on or after the mandate’s first collection date and on or before the mandate's final collection date. Charge date will be rolled forward by LotusPay to the next working day if it is not a working day. If created before 9am on a working day and passed with no charge date or charge date today, the payment will be collected on the same day, else it will be rolled forward by LotusPay. Charge date should be written as 'yyyy-mm-dd'. In Excel, enter the apostrophe prefix before the date value, save and close the file and do not reopen it.
- Description (optional) - A human-readable description of the payment. This will be included in the notification email LotusPay sends to your customer.
- Mandate (conditionally required) - The identifier of the mandate against which this payment should be collected. Either mandate ID or UMRN must be supplied (one or the other, not both).
- UMRN (conditionally required) - The NACH Unique Mandate Reference Number of the mandate against which this payment should be collected. Either mandate ID or UMRN must be supplied (one or the other, not both).